USP_DATAFORMTEMPLATE_EDIT_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_3

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CODE	nvarchar(10)	IN
@NAME	nvarchar(50)	IN
@DESCRIPTION	nvarchar(255)	IN
@MARKLETTERSACKNOWLEDGED	bit	IN
@ACKNOWLEDGEDATETYPECODE	tinyint	IN
@ACKNOWLEDGEDATE	datetime	IN
@SITEID	uniqueidentifier	IN
@SOURCECODEID	uniqueidentifier	IN
@ITEMLIST	xml	IN
@EXCLUSIONDATETYPECODE	tinyint	IN
@EXCLUSIONASOFDATE	datetime	IN
@EXCLUDEDECEASED	bit	IN
@EXCLUDEINACTIVE	bit	IN
@EXCLUSIONS	xml	IN
@USEADDRESSPROCESSING	bit	IN
@ADDRESSPROCESSINGOPTIONID	uniqueidentifier	IN
@NAMEFORMATPARAMETERID	uniqueidentifier	IN
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE	tinyint	IN
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATE	datetime	IN
@ACTIVATIONKPIS	xml	IN
@USEKPISASDEFAULT	bit	IN
@APPEALINFORMATION	xml	IN
@MULTIPLELETTERSPERREVENUE	bit	IN
@RUNACTIVATEANDEXPORT	bit	IN
@EXPORTDESCRIPTION	nvarchar(255)	IN
@CODEVALUEID	uniqueidentifier	IN
@CACHESOURCEANALYSISRULEDATA	bit	IN
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_3]
(
  @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,
  @CURRENTAPPUSERID uniqueidentifier = null
)
as
begin
  set nocount on;

  declare @RUNMARKETINGEXCLUSIONSREPORT bit;

  exec dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_2]
    @ID = @ID,
    @RUNMARKETINGEXCLUSIONSREPORT = @RUNMARKETINGEXCLUSIONSREPORT output;

  exec dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTACKNOWLEDGEMENTMAILINGTEMPLATE_4]
    @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,
    @CURRENTAPPUSERID,
    @RUNMARKETINGEXCLUSIONSREPORT;

end