USP_DATAFORMTEMPLATE_EDIT_TRIBUTEACKNOWLEDGEMENTPROCESS

Compatibility procedure for USP_DATAFORMTEMPLATE_EDIT_TRIBUTEACKNOWLEDGEMENTPROCESS_2.

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
@TRIBUTELETTERCODEID	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_TRIBUTEACKNOWLEDGEMENTPROCESS 
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,                
                @NAME nvarchar(100), 
                @IDSETREGISTERID uniqueidentifier, 
                @DESCRIPTION nvarchar(255), 
                @CREATEOUTPUTIDSET bit,
                @OUTPUTIDSETRECORDTYPEID uniqueidentifier, 
                @OUTPUTIDSETNAME nvarchar(100), 
                @OVERWRITEOUTPUTIDSET bit,
                @TRIBUTELETTERCODEID 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_TRIBUTEACKNOWLEDGEMENTPROCESS_2
                @ID = @ID,
                @SITEID = @SITEID output;

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