USP_DATAFORMTEMPLATE_EDIT_MKTSPONSORSHIPMAILINGTEMPLATERULE_3

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
@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
@CHANNELSOURCECODE	nvarchar(10)	IN
@CHANNELSOURCECODEVALUEID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTSPONSORSHIPMAILINGTEMPLATERULE_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,
  @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,
  @CURRENTAPPUSERID uniqueidentifier
)

as
  set nocount on;

  declare @EXCLUDE bit;

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

  exec dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTSPONSORSHIPMAILINGTEMPLATERULE_4]
    @ID,
    @CHANGEAGENTID,
    @SEGMENTID,
    @CODE,
    @TESTSEGMENTCODE,
    @PACKAGEID,
    @PACKAGECODE,
    @RESPONSERATE,
    @GIFTAMOUNT,
    @ASKLADDERID,
    @OVERRIDEADDRESSPROCESSING,
    @USEADDRESSPROCESSING,
    @ADDRESSPROCESSINGOPTIONID,
    @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE,
    @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE,
    @NAMEFORMATPARAMETERID,
    @CODEVALUEID,
    @PACKAGECODEVALUEID,
    @TESTSEGMENTCODEVALUEID,
    @CHANNELSOURCECODE,
    @CHANNELSOURCECODEVALUEID,
    @CURRENTAPPUSERID,
    @EXCLUDE;

  return 0;