USP_DATAFORMTEMPLATE_EDITLOAD_MKTSPONSORSHIPMAILINGSEGMENT

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

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@SEGMENTATIONID	uniqueidentifier	INOUT	Marketing effort
@MARKETINGPLANBRIEFID	uniqueidentifier	INOUT	Marketing plan brief ID
@SEGMENTATIONACTIVE	bit	INOUT	Marketing effort active?
@SEGMENTID	uniqueidentifier	INOUT	Segment
@CODE	nvarchar(10)	INOUT	Code
@TESTSEGMENTCODE	nvarchar(10)	INOUT	Test segment code
@PACKAGEID	uniqueidentifier	INOUT	Package
@PACKAGECODE	nvarchar(10)	INOUT	Package code
@RESPONSERATE	decimal(5, 2)	INOUT	Response rate
@GIFTAMOUNT	money	INOUT	Gift amount
@SAMPLESIZE	int	INOUT	Sample size
@SAMPLESIZETYPECODE	tinyint	INOUT	Sample size type
@SAMPLESIZEMETHODCODE	tinyint	INOUT	Sample size method
@SAMPLESIZEEXCLUDEREMAINDER	bit	INOUT	Exclude remaining records from the marketing effort
@SOURCECODEID	uniqueidentifier	INOUT	Source code ID
@ASKLADDERID	uniqueidentifier	INOUT	Ask ladder
@SEQUENCE	int	INOUT	Sequence
@SEGMENTATIONSITEID	uniqueidentifier	INOUT	Marketing effort site ID
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@MAILINGTYPECODE	tinyint	INOUT	Marketing effort type
@ISTESTMAILING	bit	INOUT	Is test marketing effort
@PACKAGECHANNELCODE	tinyint	INOUT	Package channel code
@USEADDRESSPROCESSING	bit	INOUT	Use address processing?
@ADDRESSPROCESSINGOPTIONID	uniqueidentifier	INOUT	Address processing options
@SEGMENTDATECHANGED	datetime	INOUT	Segment date last changed
@ISBBEC	bit	INOUT	Is BBEC?
@OVERRIDEADDRESSPROCESSING	bit	INOUT	Override address processing / name format rules
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE	tinyint	INOUT	Consider seasonal addresses as of
@ADDRESSPROCESSINGOPTIONSEASONALASOFDATE	datetime	INOUT	Consider seasonal addresses as of
@NAMEFORMATPARAMETERID	uniqueidentifier	INOUT	Name format options
@CODEVALUEID	uniqueidentifier	INOUT	Code value ID
@TESTSEGMENTCODEVALUEID	uniqueidentifier	INOUT	Test segment code value ID
@PACKAGECODEVALUEID	uniqueidentifier	INOUT	Package code value ID
@ITEMLIST	xml	INOUT	Items
@CHANNELSOURCECODE	nvarchar(10)	INOUT	Channel source code
@CHANNELSOURCECODEVALUEID	uniqueidentifier	INOUT	Channel code value ID
@EXCLUDESPOUSE	bit	INOUT	Exclude spouse (wording)
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency ID
@PACKAGEADDDATAFORMCONTEXT	nvarchar(128)	INOUT	Package add data form context
@EXCLUDE	bit	INOUT	Exclude from effort but show counts
@RECORDSOURCEID	uniqueidentifier	INOUT
@LISTCODEVALUEID	uniqueidentifier	INOUT
@LISTCODE	nvarchar(10)	INOUT

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_MKTSPONSORSHIPMAILINGSEGMENT]
(
  @ID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @SEGMENTATIONID uniqueidentifier = null output,
  @MARKETINGPLANBRIEFID uniqueidentifier = null output,
  @SEGMENTATIONACTIVE bit = null output,
  @SEGMENTID uniqueidentifier = null output,
  @CODE nvarchar(10) = null output,
  @TESTSEGMENTCODE nvarchar(10) = null output,
  @PACKAGEID uniqueidentifier = null output,
  @PACKAGECODE nvarchar(10) = null output,
  @RESPONSERATE decimal(5,2) = null output,
  @GIFTAMOUNT money = null output,
  @SAMPLESIZE int = null output,
  @SAMPLESIZETYPECODE tinyint = null output,
  @SAMPLESIZEMETHODCODE tinyint = null output,
  @SAMPLESIZEEXCLUDEREMAINDER bit = null output,
  @SOURCECODEID uniqueidentifier = null output,
  @ASKLADDERID uniqueidentifier = null output,
  @SEQUENCE int = null output,
  @SEGMENTATIONSITEID uniqueidentifier = null output,
  @TSLONG bigint = 0 output,
  @MAILINGTYPECODE tinyint = null output,
  @ISTESTMAILING bit = null output,
  @PACKAGECHANNELCODE tinyint = null output,
  @USEADDRESSPROCESSING bit = null output,
  @ADDRESSPROCESSINGOPTIONID uniqueidentifier = null output,
  @SEGMENTDATECHANGED datetime = null output,
  @ISBBEC bit = null output,
  @OVERRIDEADDRESSPROCESSING bit = null output,
  @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE tinyint = null output,
  @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE datetime = null output,
  @NAMEFORMATPARAMETERID uniqueidentifier = null output,
  @CODEVALUEID uniqueidentifier = null output,
  @TESTSEGMENTCODEVALUEID uniqueidentifier = null output,
  @PACKAGECODEVALUEID uniqueidentifier = null output,
  @ITEMLIST xml = null output,
  @CHANNELSOURCECODE nvarchar(10) = null output,
  @CHANNELSOURCECODEVALUEID uniqueidentifier = null output,
  @EXCLUDESPOUSE bit = null output,
  @BASECURRENCYID uniqueidentifier = null output,
  @PACKAGEADDDATAFORMCONTEXT nvarchar(128) = null output,
  @EXCLUDE bit = null output,
  @RECORDSOURCEID uniqueidentifier = null output,
  @LISTCODEVALUEID uniqueidentifier = null output,
  @LISTCODE nvarchar(10) = null output
)
as
  set nocount on;

  exec dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_MKTSEGMENTATIONSEGMENT_4]
    @ID,
    @CURRENTAPPUSERID,
    @DATALOADED output,
    @SEGMENTATIONID output,
    @MARKETINGPLANBRIEFID output,
    @SEGMENTATIONACTIVE output,
    @SEGMENTID output,
    @CODE output,
    @TESTSEGMENTCODE output,
    @PACKAGEID output,
    @PACKAGECODE output,
    @RESPONSERATE output,
    @GIFTAMOUNT output,
    @SAMPLESIZE output,
    @SAMPLESIZETYPECODE output,
    @SAMPLESIZEMETHODCODE output,
    @SAMPLESIZEEXCLUDEREMAINDER output,
    @SOURCECODEID output,
    @ASKLADDERID output,
    @SEQUENCE output,
    @SEGMENTATIONSITEID output,
    @TSLONG output,
    @MAILINGTYPECODE output,
    @ISTESTMAILING output,
    @PACKAGECHANNELCODE output,
    @USEADDRESSPROCESSING output,
    @ADDRESSPROCESSINGOPTIONID output,
    @SEGMENTDATECHANGED output,
    @ISBBEC output,
    @OVERRIDEADDRESSPROCESSING output,
    @ADDRESSPROCESSINGOPTIONSEASONALASOFDATETYPECODE output,
    @ADDRESSPROCESSINGOPTIONSEASONALASOFDATE output,
    @NAMEFORMATPARAMETERID output,
    @CODEVALUEID output,
    @PACKAGECODEVALUEID output,
    @TESTSEGMENTCODEVALUEID output,
    @ITEMLIST output,
    @CHANNELSOURCECODE output,
    @CHANNELSOURCECODEVALUEID output,
    @EXCLUDESPOUSE output,
    null,
    null,
    @BASECURRENCYID output,
    null,
    @EXCLUDE output,
    null,
    @RECORDSOURCEID output,
    @LISTCODEVALUEID output,
    @LISTCODE 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;