USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTATION_5

The save procedure used by the edit dataform template "Marketing Effort Edit Form 4".

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(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@SITEID	uniqueidentifier	IN	Site
@SOURCECODEID	uniqueidentifier	IN	Source code
@ITEMLIST	xml	IN	Items
@MAILDATE	datetime	IN	Date
@HOUSEHOLDINGTYPECODE	tinyint	IN	Include
@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 efforts
@APPEALINFORMATION	xml	IN	Appeal information including the appeal searchlist and record source.
@RUNACTIVATEANDEXPORT	bit	IN	Export marketing effort when activation 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
@BUSINESSUNITS	xml	IN	Business units
@OVERRIDEBUSINESSUNITS	bit	IN	Override appeal business units

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTATION_5]
(
  @ID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @CODE nvarchar(10),
  @NAME nvarchar(100),
  @DESCRIPTION nvarchar(255),
  @SITEID uniqueidentifier,
  @SOURCECODEID uniqueidentifier,
  @ITEMLIST xml,
  @MAILDATE datetime,
  @HOUSEHOLDINGTYPECODE tinyint,
  @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,
  @BUSINESSUNITS xml,
  @OVERRIDEBUSINESSUNITS bit
)
as
begin
  set nocount on;

  declare @RUNMARKETINGEXCLUSIONSREPORT bit;

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

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

end