USP_DATAFORMTEMPLATE_ADD_MKTLETTERCODESPONSORSHIP_PRELOAD
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @MAILINGTYPECODECHANNELCODE | nvarchar(3) | INOUT | |
| @ACKNOWLEDGEMENTMAILINGSINSTALLED | bit | INOUT | |
| @MEMBERSHIPMAILINGSINSTALLED | bit | INOUT | |
| @SPONSORSHIPMAILINGSINSTALLED | bit | INOUT | |
| @MAILINGTYPECODEFORFORMFIELDOVERRIDE | tinyint | INOUT | |
| @EXPORTDEFINITIONRECORDTYPE | nvarchar(50) | INOUT | |
| @EXPORTDEFINITIONRECORDTYPEID | uniqueidentifier | INOUT | |
| @EXPORTDEFINITIONQUERYVIEWID | uniqueidentifier | INOUT | |
| @SITEREQUIRED | bit | INOUT | |
| @SITES | xml | INOUT | |
| @CURRENTAPPUSERID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_MKTLETTERCODESPONSORSHIP_PRELOAD]
(
@MAILINGTYPECODECHANNELCODE nvarchar(3) = null output,
@ACKNOWLEDGEMENTMAILINGSINSTALLED bit = null output,
@MEMBERSHIPMAILINGSINSTALLED bit = null output,
@SPONSORSHIPMAILINGSINSTALLED bit = null output,
@MAILINGTYPECODEFORFORMFIELDOVERRIDE tinyint = null output,
@EXPORTDEFINITIONRECORDTYPE nvarchar(50) = null output,
@EXPORTDEFINITIONRECORDTYPEID uniqueidentifier = null output,
@EXPORTDEFINITIONQUERYVIEWID uniqueidentifier = null output,
@SITEREQUIRED bit = null output,
@SITES xml = null output,
@CURRENTAPPUSERID uniqueidentifier = null
)
as
set nocount on;
exec dbo.[USP_DATAFORMTEMPLATE_ADD_MKTLETTERCODE_PRELOAD]
@MAILINGTYPECODE = 3,
@MAILINGTYPECODECHANNELCODE = @MAILINGTYPECODECHANNELCODE output,
@ACKNOWLEDGEMENTMAILINGSINSTALLED = @ACKNOWLEDGEMENTMAILINGSINSTALLED output,
@MEMBERSHIPMAILINGSINSTALLED = @MEMBERSHIPMAILINGSINSTALLED output,
@SPONSORSHIPMAILINGSINSTALLED = @SPONSORSHIPMAILINGSINSTALLED output,
@MAILINGTYPECODEFORFORMFIELDOVERRIDE = @MAILINGTYPECODEFORFORMFIELDOVERRIDE output,
@EXPORTDEFINITIONRECORDTYPE = @EXPORTDEFINITIONRECORDTYPE output,
@EXPORTDEFINITIONRECORDTYPEID = @EXPORTDEFINITIONRECORDTYPEID output,
@EXPORTDEFINITIONQUERYVIEWID = @EXPORTDEFINITIONQUERYVIEWID output,
@SITEREQUIRED = @SITEREQUIRED output,
@SITES = @SITES output,
@CURRENTAPPUSERID = @CURRENTAPPUSERID;
return 0;