USP_DATAFORMTEMPLATE_EDIT_RECOGNITIONPROGRAMREVENUE_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.
@SELECTIONID	uniqueidentifier	IN	Additional revenue selection
@STARTDATE	datetime	IN	Consider revenue as of
@GIFTTYPESFILTER	xml	IN	Revenue types
@MAXIMUMAMOUNT	money	IN	Maximum revenue amount
@PLANNEDGIFTCODE	tinyint	IN

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RECOGNITIONPROGRAMREVENUE_2 (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @SELECTIONID uniqueidentifier,
                    @STARTDATE datetime,
                    @GIFTTYPESFILTER xml,
                    @MAXIMUMAMOUNT money,
                    @PLANNEDGIFTCODE tinyint
                )
                as
                    set nocount on;

                    declare @RECOGNITIONCREDITTYPES xml;
                    declare @INCLUDECREDITWITHOUTTYPE tinyint;

                    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RECOGNITIONPROGRAMREVENUE_2
                        @ID = @ID,                        
                        @RECOGNITIONCREDITTYPES = @RECOGNITIONCREDITTYPES output,
                        @INCLUDECREDITWITHOUTTYPE = @INCLUDECREDITWITHOUTTYPE output;

                    exec dbo.USP_DATAFORMTEMPLATE_EDIT_RECOGNITIONPROGRAMREVENUE_3
                        @ID,
                        @CHANGEAGENTID,
                        @SELECTIONID,
                        @STARTDATE,
                        @GIFTTYPESFILTER,
                        @MAXIMUMAMOUNT,
                        @PLANNEDGIFTCODE,
                        @RECOGNITIONCREDITTYPES,
                        @INCLUDECREDITWITHOUTTYPE;

                return 0;