USP_DATAFORMTEMPLATE_EDITLOAD_APPEALMAILINGHYBRIDACTIVATE

The load procedure used by the edit dataform template "Appeal Mailing Hybrid Activate Edit Data 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.
@LETTERCHANNELINSTANCES	xml	INOUT
@EMAILPROCESSINGTYPE	tinyint	INOUT
@CREATEOUTPUTIDSET	bit	INOUT	Create selection from recipients
@OUTPUTIDSETNAME	nvarchar(100)	INOUT	Selection name
@OVERWRITEOUTPUTIDSET	bit	INOUT	Overwrite existing selection
@EMAILDATETIME	datetime	INOUT
@LETTEROPTIONS	xml	INOUT

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_APPEALMAILINGHYBRIDACTIVATE]
(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
  @TSLONG bigint = 0 output,
  @LETTERCHANNELINSTANCES xml = null output,
  @EMAILPROCESSINGTYPE tinyint = null output,
  @CREATEOUTPUTIDSET bit = null output,
  @OUTPUTIDSETNAME nvarchar(100) = null output,
  @OVERWRITEOUTPUTIDSET bit = null output,
  @EMAILDATETIME datetime = null output,
  @LETTEROPTIONS xml = null output
)
as

  set nocount on;

  set @DATALOADED = 0
  set @TSLONG = 0

    declare @SEGMENTATIONID uniqueidentifier;
    select
      @SEGMENTATIONID = [MKTSEGMENTATIONACTIVATEPROCESS].[SEGMENTATIONID]
    from dbo.[MKTSEGMENTATIONACTIVATEPROCESS]
    where [MKTSEGMENTATIONACTIVATEPROCESS].[ID] = @ID

    set @LETTERCHANNELINSTANCES = dbo.[UFN_APPEALMAILING_GETLETTERCHANNELINSTANCES_TOITEMLISTXML](@SEGMENTATIONID);

    select top (1)
      @DATALOADED = 1,
      @TSLONG = [MKTSEGMENTATION].[TSLONG],
      @CREATEOUTPUTIDSET = [MKTSEGMENTATION].[CREATEOUTPUTIDSET],
      @OUTPUTIDSETNAME = [MKTSEGMENTATION].[OUTPUTIDSETNAME],
      @OVERWRITEOUTPUTIDSET = [MKTSEGMENTATION].[OVERWRITEOUTPUTIDSET],
      @LETTEROPTIONS = dbo.UFN_SELECTIVECOMMUNICATIONLETTERS_GETLETTEROPTIONS_TOITEMLISTXML(@SEGMENTATIONID)
    from dbo.[MKTSEGMENTATIONACTIVATEPROCESS]
    inner join dbo.[MKTSEGMENTATION] on [MKTSEGMENTATION].[ID] = [MKTSEGMENTATIONACTIVATEPROCESS].[SEGMENTATIONID]
    where [MKTSEGMENTATIONACTIVATEPROCESS].[ID] = @ID;

  return 0;