USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTATIONSEGMENT_MULTIPLE_5

Parameters

Parameter	Parameter Type	Mode	Description
@ID	nvarchar(max)	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.
@ASKLADDER	xml	IN	Ask ladder
@ASKLADDERLOADED	bit	IN	Ask ladder loaded
@TESTSEGMENTCODE	nvarchar(10)	IN	Test segment
@TESTSEGMENTCODELOADED	bit	IN	Test segment code loaded
@PACKAGEID	uniqueidentifier	IN	Package
@PACKAGECODE	nvarchar(10)	IN	Package code
@PACKAGELOADED	bit	IN	Package loaded
@RESPONSERATE	decimal(5, 2)	IN	Response rate
@RESPONSERATELOADED	bit	IN	Response rate loaded
@GIFTAMOUNT	money	IN	Gift amount
@GIFTAMOUNTLOADED	bit	IN	Gift amount loaded
@SAMPLESIZE	int	IN	Sample size
@SAMPLESIZETYPECODE	tinyint	IN	Sample size type
@SAMPLESIZEMETHODCODE	tinyint	IN	Sample size method
@SAMPLESIZEEXCLUDEREMAINDER	bit	IN	Exclude remaining records from the marketing effort
@SAMPLESIZELOADED	bit	IN	Sample size loaded
@ADDRESSPROCESSINGOPTIONSLOADED	bit	IN	Address processing options loaded
@OVERRIDEADDRESSPROCESSING	bit	IN	Override address processing / name format rules
@USEADDRESSPROCESSING	bit	IN	Use address processing?
@ADDRESSPROCESSINGOPTIONID	uniqueidentifier	IN	Address processing option ID
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE	tinyint	IN	Consider seasonal addresses as of
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATE	datetime	IN	Consider seasonal addresses as of
@NAMEFORMATPARAMETERID	uniqueidentifier	IN	Name format options
@TESTSEGMENTCODEVALUEID	uniqueidentifier	IN	Test segment code value ID
@PACKAGECODEVALUEID	uniqueidentifier	IN	Package code value ID
@ITEMLIST	xml	IN	Items
@CHANNELSOURCECODE	nvarchar(10)	IN	Channel source code
@CHANNELSOURCECODEVALUEID	uniqueidentifier	IN	Channel code value ID
@OVERRIDEBUSINESSUNITSLOADED	bit	IN	Override business units loaded
@OVERRIDEBUSINESSUNITS	bit	IN	Override business units
@BUSINESSUNITS	xml	IN	Business units

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTATIONSEGMENT_MULTIPLE_5]
(
    @ID nvarchar(max),
    @CHANGEAGENTID uniqueidentifier = null,
    @ASKLADDER xml,
    @ASKLADDERLOADED bit,
    @TESTSEGMENTCODE nvarchar(10),
    @TESTSEGMENTCODELOADED bit,
    @PACKAGEID uniqueidentifier,
    @PACKAGECODE nvarchar(10),
    @PACKAGELOADED bit,
    @RESPONSERATE decimal(5,2),
    @RESPONSERATELOADED bit,
    @GIFTAMOUNT money,
    @GIFTAMOUNTLOADED bit,
    @SAMPLESIZE int,
    @SAMPLESIZETYPECODE tinyint,
    @SAMPLESIZEMETHODCODE tinyint,
    @SAMPLESIZEEXCLUDEREMAINDER bit,
    @SAMPLESIZELOADED bit,
    @ADDRESSPROCESSINGOPTIONSLOADED bit,
    @OVERRIDEADDRESSPROCESSING bit,
    @USEADDRESSPROCESSING bit,
    @ADDRESSPROCESSINGOPTIONID uniqueidentifier,
    @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE tinyint,
    @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE datetime,
    @NAMEFORMATPARAMETERID uniqueidentifier,
    @TESTSEGMENTCODEVALUEID uniqueidentifier,
    @PACKAGECODEVALUEID uniqueidentifier,
    @ITEMLIST xml,
    @CHANNELSOURCECODE nvarchar(10),
    @CHANNELSOURCECODEVALUEID uniqueidentifier,
    @OVERRIDEBUSINESSUNITSLOADED bit,
    @OVERRIDEBUSINESSUNITS bit,
    @BUSINESSUNITS xml
)

as
  set nocount on;

  exec dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTATIONSEGMENT_MULTIPLE_6]
        @ID,
        @CHANGEAGENTID,
        @ASKLADDER,
        @ASKLADDERLOADED,
        @TESTSEGMENTCODE,
        @TESTSEGMENTCODELOADED,
        @PACKAGEID,
        @PACKAGECODE,
        @PACKAGELOADED,
        @RESPONSERATE,
        @RESPONSERATELOADED,
        @GIFTAMOUNT,
        @GIFTAMOUNTLOADED,
        @SAMPLESIZE,
        @SAMPLESIZETYPECODE,
        @SAMPLESIZEMETHODCODE,
        @SAMPLESIZEEXCLUDEREMAINDER,
        @SAMPLESIZELOADED,
        @ADDRESSPROCESSINGOPTIONSLOADED,
        @OVERRIDEADDRESSPROCESSING,
        @USEADDRESSPROCESSING,
        @ADDRESSPROCESSINGOPTIONID,
        @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE,
        @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE,
        @NAMEFORMATPARAMETERID,
        @TESTSEGMENTCODEVALUEID,
        @PACKAGECODEVALUEID,
        @ITEMLIST,
        @CHANNELSOURCECODE,
        @CHANNELSOURCECODEVALUEID,
        @OVERRIDEBUSINESSUNITSLOADED,
        @OVERRIDEBUSINESSUNITS,
        @BUSINESSUNITS,
        null;

  return 0;