USP_DATAFORMTEMPLATE_EDIT_ACKNOWLEDGEMENTPROCESS_2

Compatibility procedure for USP_DATAFORMTEMPLATE_EDIT_ACKNOWLEDGEMENTPROCESS_3.

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.
@NAME	nvarchar(100)	IN	Name
@IDSETREGISTERID	uniqueidentifier	IN	Selection
@DESCRIPTION	nvarchar(255)	IN	Description
@CREATEOUTPUTIDSET	bit	IN	Create selection from results
@OUTPUTIDSETRECORDTYPEID	uniqueidentifier	IN	Selection type
@OUTPUTIDSETNAME	nvarchar(100)	IN	Selection name
@OVERWRITEOUTPUTIDSET	bit	IN	Overwrite existing selection
@LETTERCODEID	uniqueidentifier	IN	Acknowledge revenue with letter
@MARKLETTERSACKNOWLEDGED	bit	IN	Mark letters 'Acknowledged' when process completes
@ACKNOWLEDGEDATETYPECODE	tinyint	IN	Acknowledge date
@ACKNOWLEDGEDATE	datetime	IN	Acknowledge date
@LABELFILE	varbinary	IN	Label File
@LABELFILENAME	nvarchar(255)	IN	Label File
@DISPLAYEDLABELFILENAME	nvarchar(255)	IN	Label file
@LABELFILECHANGED	bit	IN	Label File changed?
@EXCLUSIONDATETYPECODE	tinyint	IN	Consider exclusions as of
@EXCLUSIONASOFDATE	datetime	IN	Consider exclusions as of
@EXCLUDEDECEASED	bit	IN	Exclude deceased constituents
@EXCLUDEINACTIVE	bit	IN	Exclude inactive constituents
@EXCLUSIONS	xml	IN	Exclusions
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_ACKNOWLEDGEMENTPROCESS_2
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,                
  @NAME nvarchar(100), 
  @IDSETREGISTERID uniqueidentifier, 
  @DESCRIPTION nvarchar(255), 
  @CREATEOUTPUTIDSET bit,
  @OUTPUTIDSETRECORDTYPEID uniqueidentifier, 
  @OUTPUTIDSETNAME nvarchar(100), 
  @OVERWRITEOUTPUTIDSET bit,
  @LETTERCODEID uniqueidentifier,
  @MARKLETTERSACKNOWLEDGED bit,
  @ACKNOWLEDGEDATETYPECODE tinyint,
  @ACKNOWLEDGEDATE datetime,
  @LABELFILE varbinary(max),
  @LABELFILENAME nvarchar(255),
  @DISPLAYEDLABELFILENAME nvarchar(255),
  @LABELFILECHANGED bit,
  @EXCLUSIONDATETYPECODE tinyint,
  @EXCLUSIONASOFDATE datetime,
  @EXCLUDEDECEASED bit,
  @EXCLUDEINACTIVE bit,
  @EXCLUSIONS xml,
  @CURRENTAPPUSERID uniqueidentifier = null
)    
  as 
  set nocount on;

  declare @SITEID uniqueidentifier = null;

  exec dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_ACKNOWLEDGEMENTPROCESS_3]
    @ID, 
    @SITEID = @SITEID output;

  exec dbo.[USP_DATAFORMTEMPLATE_EDIT_ACKNOWLEDGEMENTPROCESS_3]
    @ID,
    @CHANGEAGENTID,
    @NAME,
    @IDSETREGISTERID,
    @DESCRIPTION,
    @CREATEOUTPUTIDSET,
    @OUTPUTIDSETRECORDTYPEID,
    @OUTPUTIDSETNAME,
    @OVERWRITEOUTPUTIDSET,
    @LETTERCODEID,
    @MARKLETTERSACKNOWLEDGED,
    @ACKNOWLEDGEDATETYPECODE,
    @ACKNOWLEDGEDATE,
    @LABELFILE,
    @LABELFILENAME,
    @DISPLAYEDLABELFILENAME,
    @LABELFILECHANGED,
    @EXCLUSIONDATETYPECODE,
    @EXCLUSIONASOFDATE,
    @EXCLUDEDECEASED,
    @EXCLUDEINACTIVE,
    @EXCLUSIONS,
    @CURRENTAPPUSERID,
    @SITEID;