USP_DATAFORMTEMPLATE_ADD_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_MINIMAL_PRELOAD

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

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

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_MINIMAL_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  
)
as
  set nocount on;

  select
    @SOURCECODEID = [SOURCECODEID],
    @ACKNOWLEDGEMENTMAILINGTEMPLATESITEID = [SITEID]
  from dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATE]
  where [ID] = @ACKNOWLEDGEMENTMAILINGTEMPLATEID;

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

  if @MAXDAYS is null
    set @MAXDAYS = 1;

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

  if @MINQUANTITY is null
    set @MINQUANTITY = 1;

  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;