USP_DATAFORMTEMPLATE_EDIT_MKTSPONSORSHIPMAILINGTEMPLATERULE_MULTIPLE_3

Parameters

Parameter	Parameter Type	Mode
@ID	nvarchar(max)	IN
@CHANGEAGENTID	uniqueidentifier	IN
@ASKLADDER	xml	IN
@ASKLADDERLOADED	bit	IN
@PACKAGEID	uniqueidentifier	IN
@PACKAGECODE	nvarchar(10)	IN
@PACKAGELOADED	bit	IN
@RESPONSERATE	decimal(5, 2)	IN
@RESPONSERATELOADED	bit	IN
@GIFTAMOUNT	money	IN
@GIFTAMOUNTLOADED	bit	IN
@PACKAGECODEVALUEID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy



create procedure USP_DATAFORMTEMPLATE_EDIT_MKTSPONSORSHIPMAILINGTEMPLATERULE_MULTIPLE_3
(
    @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,
    @PACKAGECODEVALUEID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier
)

as
  set nocount on;

    declare @EXCLUDE bit;
    declare @EXCLUDELOADED bit;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MKTSPONSORSHIPMAILINGTEMPLATERULE_MULTIPLE
        @ID = @ID,
        @EXCLUDE = @EXCLUDE output,
        @EXCLUDELOADED = @EXCLUDELOADED output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_MKTSPONSORSHIPMAILINGTEMPLATERULE_MULTIPLE_4
        @ID,
        @CHANGEAGENTID,
        @ASKLADDER,
        @ASKLADDERLOADED,
        @PACKAGEID,
        @PACKAGECODE,
        @PACKAGELOADED,
        @RESPONSERATE,
        @RESPONSERATELOADED,
        @GIFTAMOUNT,
        @GIFTAMOUNTLOADED,
        @PACKAGECODEVALUEID,
        @CURRENTAPPUSERID,
        @EXCLUDE,
        @EXCLUDELOADED

  return 0;