USP_DATAFORMTEMPLATE_EDIT_MKTSPONSORSHIPMAILINGTEMPLATE_2

The save procedure used by the edit dataform template "Sponsorship Effort 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.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@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
@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 sponsorship efforts
@APPEALINFORMATION	xml	IN	Appeal information including the appeal searchlist and record source.
@RUNACTIVATEANDEXPORT	bit	IN	Activate and export sponsorship effort when template processing completes
@EXPORTDESCRIPTION	nvarchar(255)	IN	Export description
@MAILEXPORTDEFINITIONID	uniqueidentifier	IN	Mail export definition
@EMAILEXPORTDEFINITIONID	uniqueidentifier	IN	Email export definition
@PHONEEXPORTDEFINITIONID	uniqueidentifier	IN	Phone export definition
@CODEVALUEID	uniqueidentifier	IN	Code value ID
@RUNSEGMENTATIONSEGMENTREFRESHPROCESS	bit	IN	Refresh segment selections and filters
@CACHESOURCEANALYSISRULEDATA	bit	IN	Capture source analysis rule data

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTSPONSORSHIPMAILINGTEMPLATE_2]
(
  @ID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @CODE nvarchar(10),
  @NAME nvarchar(50),
  @DESCRIPTION nvarchar(255),
  @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,
  @RUNACTIVATEANDEXPORT bit,
  @EXPORTDESCRIPTION nvarchar(255),
  @MAILEXPORTDEFINITIONID uniqueidentifier,
  @EMAILEXPORTDEFINITIONID uniqueidentifier,
  @PHONEEXPORTDEFINITIONID uniqueidentifier,
  @CODEVALUEID uniqueidentifier,
  @RUNSEGMENTATIONSEGMENTREFRESHPROCESS bit,
  @CACHESOURCEANALYSISRULEDATA bit
)
as
begin
  set nocount on;

  declare @RUNMARKETINGEXCLUSIONSREPORT bit;

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

  exec dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTSPONSORSHIPMAILINGTEMPLATE_3]
    @ID,
    @CURRENTAPPUSERID,
    @CHANGEAGENTID,
    @CODE,
    @NAME,
    @DESCRIPTION,
    @SITEID,
    @SOURCECODEID,
    @ITEMLIST,
    @EXCLUSIONDATETYPECODE,
    @EXCLUSIONASOFDATE,
    @EXCLUDEDECEASED,
    @EXCLUDEINACTIVE,
    @EXCLUSIONS,
    @USEADDRESSPROCESSING,
    @ADDRESSPROCESSINGOPTIONID,
    @NAMEFORMATPARAMETERID,
    @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE,
    @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE,
    @ACTIVATIONKPIS,
    @USEKPISASDEFAULT,
    @APPEALINFORMATION,
    @RUNACTIVATEANDEXPORT,
    @EXPORTDESCRIPTION,
    @MAILEXPORTDEFINITIONID,
    @EMAILEXPORTDEFINITIONID,
    @PHONEEXPORTDEFINITIONID,
    @CODEVALUEID,
    @RUNSEGMENTATIONSEGMENTREFRESHPROCESS,
    @CACHESOURCEANALYSISRULEDATA,
    @RUNMARKETINGEXCLUSIONSREPORT;

end