USP_DATAFORMTEMPLATE_ADD_MKTMEMBERSHIPMAILINGTEMPLATERULE_PRELOAD

The load procedure used by the edit dataform template "Membership Renewal Effort Template Rule Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@MEMBERSHIPMAILINGTEMPLATEID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SOURCECODEID	uniqueidentifier	INOUT	Source code ID
@MEMBERSHIPMAILINGTEMPLATESITEID	uniqueidentifier	INOUT	Membership renewal effort template site ID
@USEADDRESSPROCESSING	bit	INOUT	Use address processing?
@ADDRESSPROCESSINGOPTIONID	uniqueidentifier	INOUT	Address processing options
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE	tinyint	INOUT	Consider seasonal addresses as of
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATE	datetime	INOUT	Consider seasonal addresses as of
@NAMEFORMATPARAMETERID	uniqueidentifier	INOUT	Name format options
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency ID
@PACKAGEADDDATAFORMCONTEXT	nvarchar(128)	INOUT	Package add data form context
@ISBBEC	bit	INOUT
@ISBBAC	bit	INOUT
@RECORDSOURCEID	uniqueidentifier	INOUT
@LISTCODEVALUEID	uniqueidentifier	INOUT
@LISTCODE	nvarchar(10)	INOUT
@PACKAGECHANNELCODE	tinyint	INOUT
@ITEMLIST	xml	INOUT

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_MKTMEMBERSHIPMAILINGTEMPLATERULE_PRELOAD]
(
  @MEMBERSHIPMAILINGTEMPLATEID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @SOURCECODEID uniqueidentifier = null output,
  @MEMBERSHIPMAILINGTEMPLATESITEID uniqueidentifier = null output,
  @USEADDRESSPROCESSING bit = null output,
  @ADDRESSPROCESSINGOPTIONID uniqueidentifier = null output,
  @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE tinyint = null output,
  @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE datetime = null output,
  @NAMEFORMATPARAMETERID uniqueidentifier = null output,
  @BASECURRENCYID uniqueidentifier = null output,
  @PACKAGEADDDATAFORMCONTEXT nvarchar(128) = null output,
  @ISBBEC bit = null output,
  @ISBBAC bit = null output,
  @RECORDSOURCEID uniqueidentifier = null output,
  @LISTCODEVALUEID uniqueidentifier = null output,
  @LISTCODE nvarchar(10) = null output,
  @PACKAGECHANNELCODE tinyint = null output,
  @ITEMLIST xml = null output
)
as
  set nocount on;

  set @ISBBEC = (case when dbo.[UFN_INSTALLEDPRODUCTS_PRODUCTIS]('BB9873D7-F1ED-430A-8AB4-F09F47056538') = 0 then 1 else 0 end);
  set @ISBBAC = dbo.[UFN_MKTCOMMON_PRODUCTISALTRU]();

  select
    @MEMBERSHIPMAILINGTEMPLATESITEID = [SITEID],
    @BASECURRENCYID = [BASECURRENCYID],
    @PACKAGEADDDATAFORMCONTEXT = '2|' + convert(nvarchar(36), [BASECURRENCYID]),
    @SOURCECODEID = [SOURCECODEID],
    @ITEMLIST = dbo.[UFN_MKTMEMBERSHIPMAILINGTEMPLATESOURCECODEPART_GETITEMLIST2_TOITEMLISTXML](@MEMBERSHIPMAILINGTEMPLATEID),
    @USEADDRESSPROCESSING = [USEADDRESSPROCESSING],
    @ADDRESSPROCESSINGOPTIONID = [ADDRESSPROCESSINGOPTIONID],
    @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE = [ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE],
    @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE = [ADDRESSPROCESSINGOPTIONSEASONALASOFDATE],
    @NAMEFORMATPARAMETERID = [NAMEFORMATPARAMETERID]
  from dbo.[MKTMEMBERSHIPMAILINGTEMPLATE]
  where [ID] = @MEMBERSHIPMAILINGTEMPLATEID;

  if @ADDRESSPROCESSINGOPTIONID is null
    select top 1 @ADDRESSPROCESSINGOPTIONID = [ID] from dbo.[ADDRESSPROCESSINGOPTION] where [ISDEFAULT] = 1 and dbo.[UFN_SITEALLOWEDFORUSER](@CURRENTAPPUSERID, [SITEID]) = 1;

  if @NAMEFORMATPARAMETERID is null
    select top 1 @NAMEFORMATPARAMETERID = [ID] from dbo.[NAMEFORMATPARAMETER] where [ISDEFAULT] = 1 and dbo.[UFN_SITEALLOWEDFORUSER](@CURRENTAPPUSERID, [SITEID]) = 1;

  return 0;