USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTATIONSEGMENT_7

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@SEGMENTID	uniqueidentifier	IN
@CODE	nvarchar(10)	IN
@TESTSEGMENTCODE	nvarchar(10)	IN
@PACKAGEID	uniqueidentifier	IN
@PACKAGECODE	nvarchar(10)	IN
@RESPONSERATE	decimal(5, 2)	IN
@GIFTAMOUNT	money	IN
@SAMPLESIZE	int	IN
@SAMPLESIZETYPECODE	tinyint	IN
@SAMPLESIZEMETHODCODE	tinyint	IN
@SAMPLESIZEEXCLUDEREMAINDER	bit	IN
@ASKLADDERID	uniqueidentifier	IN
@OVERRIDEADDRESSPROCESSING	bit	IN
@USEADDRESSPROCESSING	bit	IN
@ADDRESSPROCESSINGOPTIONID	uniqueidentifier	IN
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE	tinyint	IN
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATE	datetime	IN
@NAMEFORMATPARAMETERID	uniqueidentifier	IN
@CODEVALUEID	uniqueidentifier	IN
@PACKAGECODEVALUEID	uniqueidentifier	IN
@TESTSEGMENTCODEVALUEID	uniqueidentifier	IN
@ITEMLIST	xml	IN
@CHANNELSOURCECODE	nvarchar(10)	IN
@CHANNELSOURCECODEVALUEID	uniqueidentifier	IN
@EXCLUDESPOUSE	bit	IN
@OVERRIDEBUSINESSUNITS	bit	IN
@BUSINESSUNITS	xml	IN
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTATIONSEGMENT_7]
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @SEGMENTID uniqueidentifier,
    @CODE nvarchar(10),
    @TESTSEGMENTCODE nvarchar(10),
    @PACKAGEID uniqueidentifier,
    @PACKAGECODE nvarchar(10),
    @RESPONSERATE decimal(5,2),
    @GIFTAMOUNT money,
    @SAMPLESIZE int,
    @SAMPLESIZETYPECODE tinyint,
    @SAMPLESIZEMETHODCODE tinyint,
    @SAMPLESIZEEXCLUDEREMAINDER bit,
    @ASKLADDERID uniqueidentifier,
    @OVERRIDEADDRESSPROCESSING bit,
    @USEADDRESSPROCESSING bit,
    @ADDRESSPROCESSINGOPTIONID uniqueidentifier,
    @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE tinyint,
    @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE datetime,
    @NAMEFORMATPARAMETERID uniqueidentifier,
    @CODEVALUEID uniqueidentifier,
    @PACKAGECODEVALUEID uniqueidentifier,
    @TESTSEGMENTCODEVALUEID uniqueidentifier,
    @ITEMLIST xml,
    @CHANNELSOURCECODE nvarchar(10),
    @CHANNELSOURCECODEVALUEID uniqueidentifier,
    @EXCLUDESPOUSE bit,
    @OVERRIDEBUSINESSUNITS bit,
    @BUSINESSUNITS xml,
    @CURRENTAPPUSERID uniqueidentifier
)

as
  set nocount on;

    declare @EXCLUDE bit;

  exec dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_MKTSEGMENTATIONSEGMENT_4]
        @ID = @ID,
        @CURRENTAPPUSERID = @CURRENTAPPUSERID,
        @EXCLUDE = @EXCLUDE output

  exec dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTATIONSEGMENT_8]
        @ID,
        @CHANGEAGENTID,
        @SEGMENTID,
        @CODE,
        @TESTSEGMENTCODE,
        @PACKAGEID,
        @PACKAGECODE,
        @RESPONSERATE,
        @GIFTAMOUNT,
        @SAMPLESIZE,
        @SAMPLESIZETYPECODE,
        @SAMPLESIZEMETHODCODE,
        @SAMPLESIZEEXCLUDEREMAINDER,
        @ASKLADDERID,
        @OVERRIDEADDRESSPROCESSING,
        @USEADDRESSPROCESSING,
        @ADDRESSPROCESSINGOPTIONID,
        @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE,
        @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE,
        @NAMEFORMATPARAMETERID,
        @CODEVALUEID,
        @PACKAGECODEVALUEID,
        @TESTSEGMENTCODEVALUEID,
        @ITEMLIST,
        @CHANNELSOURCECODE,
        @CHANNELSOURCECODEVALUEID,
        @EXCLUDESPOUSE,
        @OVERRIDEBUSINESSUNITS,
        @BUSINESSUNITS,
        @CURRENTAPPUSERID,
        @EXCLUDE

  return 0;