USP_DATAFORMTEMPLATE_EDIT_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_MULTIPLE_2

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
@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
@MAXDAYS	int	IN	Maximum days
@MAXDAYSCHECKED	bit	IN	Process transactions within
@MAXDAYSLOADED	bit	IN	Max days loaded
@MINQUANTITY	int	IN	Minimum quantity
@MINQUANTITYCHECKED	bit	IN	Process when the number of transactions reaches
@MINQUANTITYLOADED	bit	IN	Min quantity loaded
@PACKAGECODEVALUEID	uniqueidentifier	IN	Package code value ID

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_MULTIPLE_2]
(
    @ID nvarchar(max),
    @CHANGEAGENTID uniqueidentifier = null,
    @ASKLADDER xml,
    @ASKLADDERLOADED bit,
    @PACKAGEID uniqueidentifier,
    @PACKAGECODE nvarchar(10),
    @PACKAGELOADED bit,
    @RESPONSERATE decimal(5,2),
    @RESPONSERATELOADED bit,
    @GIFTAMOUNT money,
    @GIFTAMOUNTLOADED bit,
    @MAXDAYS int,
    @MAXDAYSCHECKED bit,
    @MAXDAYSLOADED bit,
    @MINQUANTITY int,
    @MINQUANTITYCHECKED bit,
    @MINQUANTITYLOADED bit,
    @PACKAGECODEVALUEID uniqueidentifier
)

as
  set nocount on;

  exec dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTACKNOWLEDGEMENTMAILINGTEMPLATERULE_MULTIPLE_3]
        @ID,
        @CHANGEAGENTID,
        @ASKLADDER,
        @ASKLADDERLOADED,
        @PACKAGEID,
        @PACKAGECODE,
        @PACKAGELOADED,
        @RESPONSERATE,
        @RESPONSERATELOADED,
        @GIFTAMOUNT,
        @GIFTAMOUNTLOADED,
        @MAXDAYS,
        @MAXDAYSCHECKED,
        @MAXDAYSLOADED,
        @MINQUANTITY,
        @MINQUANTITYCHECKED,
        @MINQUANTITYLOADED,
        @PACKAGECODEVALUEID,
        null;

  return 0;