USP_DATAFORMTEMPLATE_ADD_MKTSPONSORSHIPMAILINGSEGMENT_PRELOAD

The load procedure used by the edit dataform template "Sponsorship Effort Segment Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTATIONIDMARKETINGPLANBRIEFIDSEQUENCE	nvarchar(100)	IN	Input parameter indicating the context ID for the record being added.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SOURCECODEID	uniqueidentifier	INOUT	Source code ID
@SEGMENTATIONSITEID	uniqueidentifier	INOUT	Marketing effort site ID
@PACKAGEID	uniqueidentifier	INOUT	Package
@PACKAGECODE	nvarchar(10)	INOUT	Package code
@RESPONSERATE	decimal(5, 2)	INOUT	Response rate
@GIFTAMOUNT	money	INOUT	Gift amount
@ISBBEC	bit	INOUT	Is BBEC?
@USEADDRESSPROCESSING	bit	INOUT	Use address processing?
@ADDRESSPROCESSINGOPTIONID	uniqueidentifier	INOUT	Address processing options
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE	tinyint	INOUT	Consider seasonal addresses as of
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATE	datetime	INOUT	Consider seasonal addresses as of
@NAMEFORMATPARAMETERID	uniqueidentifier	INOUT	Name format options
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency ID
@PACKAGEADDDATAFORMCONTEXT	nvarchar(128)	INOUT	Package add data form context
@RECORDSOURCEID	uniqueidentifier	INOUT
@LISTCODEVALUEID	uniqueidentifier	INOUT
@LISTCODE	nvarchar(10)	INOUT
@PACKAGECHANNELCODE	tinyint	INOUT
@ITEMLIST	xml	INOUT

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_MKTSPONSORSHIPMAILINGSEGMENT_PRELOAD]
(
  @SEGMENTATIONIDMARKETINGPLANBRIEFIDSEQUENCE nvarchar(100),
  @CURRENTAPPUSERID uniqueidentifier,
  @SOURCECODEID uniqueidentifier = null output,
  @SEGMENTATIONSITEID uniqueidentifier = null output,
  @PACKAGEID uniqueidentifier = null output,
  @PACKAGECODE nvarchar(10) = null output,
  @RESPONSERATE decimal(5,2) = null output,
  @GIFTAMOUNT money = null output,
  @ISBBEC bit = null output,
  @USEADDRESSPROCESSING bit = null output,
  @ADDRESSPROCESSINGOPTIONID uniqueidentifier = null output,
  @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE tinyint = null output,
  @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE datetime = null output,
  @NAMEFORMATPARAMETERID uniqueidentifier = null output,
  @BASECURRENCYID uniqueidentifier = null output,
  @PACKAGEADDDATAFORMCONTEXT nvarchar(128) = null output,
  @RECORDSOURCEID uniqueidentifier = null output,
  @LISTCODEVALUEID uniqueidentifier = null output,
  @LISTCODE nvarchar(10) = null output,
  @PACKAGECHANNELCODE tinyint = null output,
  @ITEMLIST xml = null output
)
as
  set nocount on;

  exec dbo.[USP_DATAFORMTEMPLATE_ADD_MKTSEGMENTATIONSEGMENT_PRELOAD]
    @SEGMENTATIONIDMARKETINGPLANBRIEFIDSEQUENCE,
    @CURRENTAPPUSERID,
    @SOURCECODEID output,
    @SEGMENTATIONSITEID output,
    @PACKAGEID output,
    @PACKAGECODE output,
    @RESPONSERATE output,
    @GIFTAMOUNT output,
    @ISBBEC output,
    @USEADDRESSPROCESSING output,
    @ADDRESSPROCESSINGOPTIONID output,
    @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE output,
    @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE output,
    @NAMEFORMATPARAMETERID output,
    null,
    @BASECURRENCYID output,
    null,
    null,
    null,
    null,
    null,
    null,
    @ITEMLIST output;

  --Set the package context here instead of from the USP above, because the mailing type needs to be different...

  set @PACKAGEADDDATAFORMCONTEXT = '3|' + convert(nvarchar(36), @BASECURRENCYID);

  return 0;