USP_DATAFORMTEMPLATE_EDITLOAD_APPEALMAILINGACTIVATE

The load procedure used by the edit dataform template "Appeal Mailing Activate Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@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.
@APPEALMAILINGID	uniqueidentifier	INOUT	Appeal mailing ID
@MKTPACKAGEID	uniqueidentifier	INOUT	Package
@CONSTITUENTRECORDTYPEID	uniqueidentifier	INOUT	Constituent record type
@IDSETREGISTERID	uniqueidentifier	INOUT	Selection
@LABELFILECHANGED	bit	INOUT	Letter File changed?
@LABELFILENAME	nvarchar(255)	INOUT	Label template
@LABELFILE	varbinary	INOUT	LABELFILE
@CREATEOUTPUTIDSET	bit	INOUT	Create selection from results
@OUTPUTIDSETNAME	nvarchar(100)	INOUT	Selection name
@OVERWRITEOUTPUTIDSET	bit	INOUT	Overwrite existing selection
@SITEID	uniqueidentifier	INOUT	Site ID
@BBECRECORDSOURCEID	uniqueidentifier	INOUT	BBEC record source ID
@ISHYBRID	bit	INOUT
@MAILDATE	datetime	INOUT	Mail date
@PACKAGEADDDATAFORMCONTEXT	nvarchar(128)	INOUT	Package add data form context

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_APPEALMAILINGACTIVATE]
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
  @APPEALMAILINGID uniqueidentifier = null output,
  @MKTPACKAGEID uniqueidentifier = null output,
  @CONSTITUENTRECORDTYPEID uniqueidentifier = null output,
  @IDSETREGISTERID uniqueidentifier = null output,
  @LABELFILECHANGED bit = null output,
  @LABELFILENAME nvarchar(255) = null output,
  @LABELFILE varbinary(max) = null output,
  @CREATEOUTPUTIDSET bit = null output,
  @OUTPUTIDSETNAME nvarchar(100) = null output,
  @OVERWRITEOUTPUTIDSET bit = null output,
  @SITEID uniqueidentifier = null output,
  @BBECRECORDSOURCEID uniqueidentifier = null output,
  @ISHYBRID bit = null output,
  @MAILDATE datetime = null output,
  @PACKAGEADDDATAFORMCONTEXT nvarchar(128) = null output
)
as
  set nocount on;

  set @DATALOADED = 0;
  set @TSLONG = 0;

  set @BBECRECORDSOURCEID = dbo.[UFN_MKTRECORDSOURCE_GETFIRSTBBECRECORDSOURCEID]();

  select top(1)
    @DATALOADED = 1,
    @TSLONG = [APPEALMAILING].[TSLONG],
    @APPEALMAILINGID = [APPEALMAILING].[ID],
    @MKTPACKAGEID = [MKTSEGMENTATIONSEGMENT].[PACKAGEID],
    @CONSTITUENTRECORDTYPEID = (select [ID] from dbo.[RECORDTYPE] where upper([NAME]) = 'CONSTITUENT'),
    @IDSETREGISTERID = [MKTSEGMENTSELECTION].[SELECTIONID],
    @LABELFILECHANGED = 0,
    @LABELFILENAME = [APPEALMAILING].[LABELFILENAME],
    @LABELFILE = null,   /* DO NOT LOAD THE FILE HERE, IT WILL BE DOWNLOADED ON DEMAND */
    @CREATEOUTPUTIDSET = [MKTSEGMENTATION].[CREATEOUTPUTIDSET],
    @OUTPUTIDSETNAME = [MKTSEGMENTATION].[OUTPUTIDSETNAME],
    @OVERWRITEOUTPUTIDSET = [MKTSEGMENTATION].[OVERWRITEOUTPUTIDSET],
    @SITEID = [MKTSEGMENTATION].[SITEID],
    @ISHYBRID = (case when [APPEALMAILINGSETUP].[ID] is null then 0 else 1 end),
    @MAILDATE = [MKTSEGMENTATION].[MAILDATE],
    @PACKAGEADDDATAFORMCONTEXT = '0|' + convert(nvarchar(36), [MKTSEGMENTATION].[BASECURRENCYID])
  from dbo.[MKTSEGMENTATIONACTIVATEPROCESS]
  inner join dbo.[APPEALMAILING] on [APPEALMAILING].[ID] = [MKTSEGMENTATIONACTIVATEPROCESS].[SEGMENTATIONID]
  inner join dbo.[MKTSEGMENTATION] on [MKTSEGMENTATION].[ID] = [MKTSEGMENTATIONACTIVATEPROCESS].[SEGMENTATIONID]
  inner join dbo.[MKTSEGMENTATIONSEGMENT] on [MKTSEGMENTATIONSEGMENT].[SEGMENTATIONID] = [MKTSEGMENTATION].[ID]
  inner join dbo.[MKTSEGMENTSELECTION] on [MKTSEGMENTSELECTION].[SEGMENTID] = [MKTSEGMENTATIONSEGMENT].[SEGMENTID]
  left join dbo.[APPEALMAILINGSETUP] on [APPEALMAILINGSETUP].[ID] = [APPEALMAILING].[ID]
  where [MKTSEGMENTATIONACTIVATEPROCESS].[ID] = @ID;

  return 0;