USP_DATAFORMTEMPLATE_EDIT_APPEALMAILINGHYBRIDACTIVATE

The save 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 indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@EMAILPROCESSINGTYPE	tinyint	IN
@CREATEOUTPUTIDSET	bit	IN	Create selection from recipients
@OUTPUTIDSETNAME	nvarchar(100)	IN	Selection name
@OVERWRITEOUTPUTIDSET	bit	IN	Overwrite existing selection
@EMAILDATETIME	datetime	IN

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_APPEALMAILINGHYBRIDACTIVATE]
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @EMAILPROCESSINGTYPE tinyint,
  @CREATEOUTPUTIDSET bit,
  @OUTPUTIDSETNAME nvarchar(100),
  @OVERWRITEOUTPUTIDSET bit,
  @EMAILDATETIME datetime
)
as
  set nocount on;

  if @CHANGEAGENTID is null  
    exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;

  declare @LETTEROPTIONS xml;

  exec dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_APPEALMAILINGHYBRIDACTIVATE]
    @ID = @ID,
    @LETTEROPTIONS = @LETTEROPTIONS output;

  exec dbo.[USP_DATAFORMTEMPLATE_EDIT_APPEALMAILINGHYBRIDACTIVATE_2]
    @ID,
    @CHANGEAGENTID,
    @EMAILPROCESSINGTYPE,
    @CREATEOUTPUTIDSET,
    @OUTPUTIDSETNAME,
    @OVERWRITEOUTPUTIDSET,
    @EMAILDATETIME,
    @LETTEROPTIONS;