USP_DATAFORMTEMPLATE_EDIT_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_2

The save procedure used by the edit dataform template "Marketing Acknowledgement Template Edit Form 2".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@CODE	nvarchar(10)	IN	Code
@NAME	nvarchar(50)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@MARKLETTERSACKNOWLEDGED	bit	IN	Mark letters 'Acknowledged/Receipted' when process completes
@ACKNOWLEDGEDATETYPECODE	tinyint	IN	Date
@ACKNOWLEDGEDATE	datetime	IN	Date
@SITEID	uniqueidentifier	IN	Site
@SOURCECODEID	uniqueidentifier	IN	Source code
@ITEMLIST	xml	IN	Items
@EXCLUSIONDATETYPECODE	tinyint	IN	Consider exclusions as of
@EXCLUSIONASOFDATE	datetime	IN	Consider exclusions as of
@EXCLUDEDECEASED	bit	IN	Exclude deceased constituents
@EXCLUDEINACTIVE	bit	IN	Exclude inactive constituents
@EXCLUSIONS	xml	IN	Exclusions
@USEADDRESSPROCESSING	bit	IN	Use address processing?
@ADDRESSPROCESSINGOPTIONID	uniqueidentifier	IN	Address processing options
@NAMEFORMATPARAMETERID	uniqueidentifier	IN	Name format options
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE	tinyint	IN	Consider seasonal addresses as of
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATE	datetime	IN	Consider seasonal addresses as of
@ACTIVATIONKPIS	xml	IN	Activation KPIs
@USEKPISASDEFAULT	bit	IN	Use the chosen KPIs as the default for future marketing acknowledgements
@APPEALINFORMATION	xml	IN	Appeal information including the appeal searchlist and record source.
@MULTIPLELETTERSPERREVENUE	bit	IN	Allow multiple letters per revenue
@RUNACTIVATEANDEXPORT	bit	IN	Activate and export marketing acknowledgement when template processing completes
@EXPORTDESCRIPTION	nvarchar(255)	IN	Export description
@CODEVALUEID	uniqueidentifier	IN	Code value ID
@CACHESOURCEANALYSISRULEDATA	bit	IN	Capture source analysis rule data

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_2]
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @CODE nvarchar(10),
  @NAME nvarchar(50),
  @DESCRIPTION nvarchar(255),
  @MARKLETTERSACKNOWLEDGED bit,
  @ACKNOWLEDGEDATETYPECODE tinyint,
  @ACKNOWLEDGEDATE datetime,
  @SITEID uniqueidentifier,
  @SOURCECODEID uniqueidentifier,
  @ITEMLIST xml,
  @EXCLUSIONDATETYPECODE tinyint,
  @EXCLUSIONASOFDATE datetime,
  @EXCLUDEDECEASED bit,
  @EXCLUDEINACTIVE bit,
  @EXCLUSIONS xml,
  @USEADDRESSPROCESSING bit,
  @ADDRESSPROCESSINGOPTIONID uniqueidentifier,
  @NAMEFORMATPARAMETERID uniqueidentifier,
  @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE tinyint,
  @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE datetime,
  @ACTIVATIONKPIS xml,
  @USEKPISASDEFAULT bit,
  @APPEALINFORMATION xml,
  @MULTIPLELETTERSPERREVENUE bit,
  @RUNACTIVATEANDEXPORT bit,
  @EXPORTDESCRIPTION nvarchar(255),
  @CODEVALUEID uniqueidentifier,
  @CACHESOURCEANALYSISRULEDATA bit
)

as
  set nocount on;

  exec dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_3]
    @ID,
    @CHANGEAGENTID,
    @CODE,
    @NAME,
    @DESCRIPTION,
    @MARKLETTERSACKNOWLEDGED,
    @ACKNOWLEDGEDATETYPECODE,
    @ACKNOWLEDGEDATE,
    @SITEID,
    @SOURCECODEID,
    @ITEMLIST,
    @EXCLUSIONDATETYPECODE,
    @EXCLUSIONASOFDATE,
    @EXCLUDEDECEASED,
    @EXCLUDEINACTIVE,
    @EXCLUSIONS,
    @USEADDRESSPROCESSING,
    @ADDRESSPROCESSINGOPTIONID,
    @NAMEFORMATPARAMETERID,
    @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE,
    @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE,
    @ACTIVATIONKPIS,
    @USEKPISASDEFAULT,
    @APPEALINFORMATION,
    @MULTIPLELETTERSPERREVENUE,
    @RUNACTIVATEANDEXPORT,
    @EXPORTDESCRIPTION,
    @CODEVALUEID,
    @CACHESOURCEANALYSISRULEDATA,
    null;

  return 0;