USP_DATAFORMTEMPLATE_EDIT_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_3

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	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.
@SEGMENTID	uniqueidentifier	IN	Segment
@CODE	nvarchar(10)	IN	Code
@TESTSEGMENTCODE	nvarchar(10)	IN	Test segment
@PACKAGEID	uniqueidentifier	IN	Package
@PACKAGECODE	nvarchar(10)	IN	Package code
@RESPONSERATE	decimal(5, 2)	IN	Response rate
@GIFTAMOUNT	money	IN	Gift amount
@MAXDAYSCHECKED	bit	IN	Process transactions within
@MAXDAYS	int	IN	Maximum number of days
@MINQUANTITYCHECKED	bit	IN	Process when the number of transactions reaches
@MINQUANTITY	int	IN	Minimum quantity to process
@ASKLADDERID	uniqueidentifier	IN	Ask ladder
@OVERRIDEADDRESSPROCESSING	bit	IN	Override address processing / name format rules
@USEADDRESSPROCESSING	bit	IN	Use address processing?
@ADDRESSPROCESSINGOPTIONID	uniqueidentifier	IN	Address processing options
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE	tinyint	IN	Consider seasonal addresses as of
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATE	datetime	IN	Consider seasonal addresses as of
@NAMEFORMATPARAMETERID	uniqueidentifier	IN	Name format options
@CODEVALUEID	uniqueidentifier	IN	Code value ID
@PACKAGECODEVALUEID	uniqueidentifier	IN	Package code value ID
@TESTSEGMENTCODEVALUEID	uniqueidentifier	IN	Test segment code value ID
@CHANNELSOURCECODE	nvarchar(10)	IN	Channel source code
@CHANNELSOURCECODEVALUEID	uniqueidentifier	IN	Channel code value ID

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_3]
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @SEGMENTID uniqueidentifier,
    @CODE nvarchar(10),
    @TESTSEGMENTCODE nvarchar(10),
    @PACKAGEID uniqueidentifier,
    @PACKAGECODE nvarchar(10),
    @RESPONSERATE decimal(5,2),
    @GIFTAMOUNT money,
    @MAXDAYSCHECKED bit,
    @MAXDAYS int,
    @MINQUANTITYCHECKED bit,
    @MINQUANTITY int,
    @ASKLADDERID uniqueidentifier,
    @OVERRIDEADDRESSPROCESSING bit,
    @USEADDRESSPROCESSING bit,
    @ADDRESSPROCESSINGOPTIONID uniqueidentifier,
    @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE tinyint,
    @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE datetime,
    @NAMEFORMATPARAMETERID uniqueidentifier,
    @CODEVALUEID uniqueidentifier,
    @PACKAGECODEVALUEID uniqueidentifier,
    @TESTSEGMENTCODEVALUEID uniqueidentifier,
    @CHANNELSOURCECODE nvarchar(10),
    @CHANNELSOURCECODEVALUEID uniqueidentifier
)

as
  set nocount on;

    declare @CURRENTAPPUSERID uniqueidentifier;

  exec dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_4]
        @ID,
        @CHANGEAGENTID,
        @SEGMENTID,
        @CODE,
        @TESTSEGMENTCODE,
        @PACKAGEID,
        @PACKAGECODE,
        @RESPONSERATE,
        @GIFTAMOUNT,
        @MAXDAYSCHECKED,
        @MAXDAYS,
        @MINQUANTITYCHECKED,
        @MINQUANTITY,
        @ASKLADDERID,
        @OVERRIDEADDRESSPROCESSING,
        @USEADDRESSPROCESSING,
        @ADDRESSPROCESSINGOPTIONID,
        @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE,
        @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE,
        @NAMEFORMATPARAMETERID,
        @CODEVALUEID,
        @PACKAGECODEVALUEID,
        @TESTSEGMENTCODEVALUEID,
        @CHANNELSOURCECODE,
        @CHANNELSOURCECODEVALUEID,
        null;

  return 0;