USP_DATAFORMTEMPLATE_ADD_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_PRELOAD

The load procedure used by the edit dataform template "Marketing Acknowledgement Template Rule Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ACKNOWLEDGEMENTMAILINGTEMPLATEID	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
@MAXDAYS	int	INOUT	Maximum number of days
@MINQUANTITY	int	INOUT	Minimum quantity to process
@ACKNOWLEDGEMENTMAILINGTEMPLATESITEID	uniqueidentifier	INOUT	Marketing Acknowledgement Template site ID
@ISBBEC	bit	INOUT	Is BBEC?
@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
@RECORDSOURCEID	uniqueidentifier	INOUT
@LISTCODEVALUEID	uniqueidentifier	INOUT
@LISTCODE	nvarchar(10)	INOUT
@PACKAGECHANNELCODE	tinyint	INOUT
@ITEMLIST	xml	INOUT

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_PRELOAD]
(
  @ACKNOWLEDGEMENTMAILINGTEMPLATEID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @SOURCECODEID uniqueidentifier = null output,
  @MAXDAYS int = null output,
  @MINQUANTITY int = null output,
  @ACKNOWLEDGEMENTMAILINGTEMPLATESITEID uniqueidentifier = null output,
  @ISBBEC bit = 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,
  @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;

  select
    @ACKNOWLEDGEMENTMAILINGTEMPLATESITEID = [SITEID],
    @BASECURRENCYID = [BASECURRENCYID],
    @PACKAGEADDDATAFORMCONTEXT = '1|' + convert(nvarchar(36), [BASECURRENCYID]),
    @PACKAGECHANNELCODE = 0,
    @SOURCECODEID = [SOURCECODEID],
    @ITEMLIST = dbo.[UFN_MKTACKNOWLEDGEMENTMAILINGTEMPLATESOURCECODEPART_GETITEMLIST2_TOITEMLISTXML](@ACKNOWLEDGEMENTMAILINGTEMPLATEID)
  from dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATE]
  where [ID] = @ACKNOWLEDGEMENTMAILINGTEMPLATEID;

  select
    @MAXDAYS = isnull(max([MAXDAYS]), 1)
  from dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE]
  inner join dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATE] on [MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE].[ACKNOWLEDGEMENTMAILINGTEMPLATEID] = [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[ID]
  where (@ACKNOWLEDGEMENTMAILINGTEMPLATESITEID is null or [SITEID] = @ACKNOWLEDGEMENTMAILINGTEMPLATESITEID);

  select
    @MINQUANTITY = isnull(max([MINQUANTITY]), 1)
  from dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE]
  inner join dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATE] on [MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE].[ACKNOWLEDGEMENTMAILINGTEMPLATEID] = [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[ID]
  where (@ACKNOWLEDGEMENTMAILINGTEMPLATESITEID is null or [SITEID] = @ACKNOWLEDGEMENTMAILINGTEMPLATESITEID);

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

  if @ISBBEC = 1
    begin
      select 
        @USEADDRESSPROCESSING = [USEADDRESSPROCESSING],
        @ADDRESSPROCESSINGOPTIONID = [ADDRESSPROCESSINGOPTIONID],
        @NAMEFORMATPARAMETERID = [NAMEFORMATPARAMETERID],
        @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE = [ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE],
        @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE = [ADDRESSPROCESSINGOPTIONSEASONALASOFDATE]
      from dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATE]
      where [ID] = @ACKNOWLEDGEMENTMAILINGTEMPLATEID;

      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;
    end
  else
    begin
      set @USEADDRESSPROCESSING = 0;
      set @ADDRESSPROCESSINGOPTIONID = null;
      set @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE = 0;
      set @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE = null;
      set @NAMEFORMATPARAMETERID = null;
    end

  return 0;