USP_DATAFORMTEMPLATE_ADD_MKTLETTERCODE_PRELOAD

The load procedure used by the edit dataform template "Letter Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@MAILINGTYPECODE	tinyint	IN	Input parameter indicating the context ID for the record being added.
@MAILINGTYPECODECHANNELCODE	nvarchar(3)	INOUT	Export definition add form context ID
@ACKNOWLEDGEMENTMAILINGSINSTALLED	bit	INOUT	Marketing Acknowledgements installed?
@MEMBERSHIPMAILINGSINSTALLED	bit	INOUT	Membership efforts installed?
@SPONSORSHIPMAILINGSINSTALLED	bit	INOUT	Sponsorship efforts installed?
@MAILINGTYPECODEFORFORMFIELDOVERRIDE	tinyint	INOUT	Marketing effort type code
@EXPORTDEFINITIONRECORDTYPE	nvarchar(50)	INOUT	Export definition record type
@EXPORTDEFINITIONRECORDTYPEID	uniqueidentifier	INOUT	Export definition record type ID
@EXPORTDEFINITIONQUERYVIEWID	uniqueidentifier	INOUT	Export definition query view ID
@SITEREQUIRED	bit	INOUT	Site required
@SITES	xml	INOUT	Sites
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_MKTLETTERCODE_PRELOAD]
(
  @MAILINGTYPECODE tinyint,
  @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;

  set @MAILINGTYPECODECHANNELCODE = convert(nvarchar(1), @MAILINGTYPECODE) + '|0';
  set @MAILINGTYPECODEFORFORMFIELDOVERRIDE = @MAILINGTYPECODE;
  set @EXPORTDEFINITIONRECORDTYPE = dbo.[UFN_MKTEXPORTDEFINITION_GETRECORDTYPEFROMMAILINGTYPECODE](@MAILINGTYPECODE);
  set @EXPORTDEFINITIONRECORDTYPEID = dbo.[UFN_MKTEXPORTDEFINITION_GETRECORDTYPEIDFROMMAILINGTYPECODE](@MAILINGTYPECODE);
  set @EXPORTDEFINITIONQUERYVIEWID = dbo.[UFN_MKTEXPORTDEFINITION_GETQUERYVIEWIDFROMMAILINGTYPECODE](@MAILINGTYPECODE);

  set @ACKNOWLEDGEMENTMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_ACKNOWLEDGEMENTMAILINGSINSTALLED]();
  set @MEMBERSHIPMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_MEMBERSHIPMAILINGSINSTALLED]();
  set @SPONSORSHIPMAILINGSINSTALLED = dbo.[UFN_MKTCOMMON_SPONSORSHIPMAILINGSINSTALLED]();

  set @SITEREQUIRED = dbo.[UFN_SITEREQUIREDFORUSERONFEATURE](@CURRENTAPPUSERID, '2B50DFE4-83C0-46B9-A6FD-76199C95BC74', 1);

  declare @DEFAULTSITEID uniqueidentifier;
  set @DEFAULTSITEID = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID);

  if @DEFAULTSITEID is not null
    set @SITES = (select newid() as [ID], @DEFAULTSITEID as [SITEID] for xml raw('ITEM'), type, elements, root('SITES'), binary base64);

  return 0;