USP_DATAFORMTEMPLATE_EDIT_POSTEDGRANTAWARD

Maintain backwards compatibility for Grant Award Adjust

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.
@DATE	datetime	IN	Date
@AMOUNT	money	IN	Amount
@POSTSTATUSCODE	tinyint	IN	Post status
@POSTDATE	datetime	IN	Post date
@SPLITS	xml	IN	Designations
@FREQUENCYCODE	tinyint	IN	Frequency
@NUMBEROFINSTALLMENTS	int	IN	No. installments remaining
@NEXTTRANSACTIONDATE	datetime	IN	Next installment date
@INSTALLMENTS	xml	IN
@DONOTACKNOWLEDGE	bit	IN	Do not acknowledge
@CATEGORYCODEID	uniqueidentifier	IN	Revenue category
@ADJUSTMENTDATE	datetime	IN	Adjusted Date
@ADJUSTMENTPOSTDATE	datetime	IN	Adjusted Post Date
@ADJUSTMENTREASON	nvarchar(300)	IN	Adjustment reason
@ISREIMBURSABLE	bit	IN	Grant award is reimbursable
@OPPORTUNITYID	uniqueidentifier	IN	Opportunity

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_POSTEDGRANTAWARD(
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @DATE datetime,
                @AMOUNT money,
                @POSTSTATUSCODE tinyint,
                @POSTDATE datetime,
                @SPLITS xml,
                @FREQUENCYCODE tinyint,
                @NUMBEROFINSTALLMENTS int,
                @NEXTTRANSACTIONDATE datetime,
                @INSTALLMENTS xml,
                @DONOTACKNOWLEDGE bit,
                @CATEGORYCODEID uniqueidentifier,
                @ADJUSTMENTDATE datetime,
                @ADJUSTMENTPOSTDATE datetime,
                @ADJUSTMENTREASON nvarchar(300),
                @ISREIMBURSABLE bit,
                @OPPORTUNITYID uniqueidentifier
            )
            as

                set nocount on;

                declare @BASECURRENCYID uniqueidentifier;
                declare @TRANSACTIONCURRENCYID uniqueidentifier;
                declare @BASEEXCHANGERATEID uniqueidentifier;
                declare @EXCHANGERATE decimal(20,8);
                declare @HADSPOTRATE bit;
                declare @RATECHANGED bit;
                declare @ADJUSTMENTREASONCODEID uniqueidentifier;

                exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_POSTEDGRANTAWARD
                    @ID = @ID,
                    @BASECURRENCYID = @BASECURRENCYID output,
                    @TRANSACTIONCURRENCYID = @TRANSACTIONCURRENCYID output,
                    @BASEEXCHANGERATEID = @BASEEXCHANGERATEID output,
                    @EXCHANGERATE = @EXCHANGERATE output,
                    @HADSPOTRATE = @HADSPOTRATE output,
                    @RATECHANGED = @RATECHANGED output,
                    @ADJUSTMENTREASONCODEID = @ADJUSTMENTREASONCODEID output;

                exec dbo.USP_DATAFORMTEMPLATE_EDIT_POSTEDGRANTAWARD_2
                    @ID,
                    @CHANGEAGENTID,
                    @DATE,
                    @AMOUNT,
                    @POSTSTATUSCODE,
                    @POSTDATE,
                    @SPLITS,
                    @FREQUENCYCODE,
                    @NUMBEROFINSTALLMENTS,
                    @NEXTTRANSACTIONDATE,
                    @INSTALLMENTS,
                    @DONOTACKNOWLEDGE,
                    @CATEGORYCODEID,
                    @ADJUSTMENTDATE,
                    @ADJUSTMENTPOSTDATE,
                    @ADJUSTMENTREASON,
                    @ISREIMBURSABLE,
                    @OPPORTUNITYID,
                    @BASECURRENCYID,
                    @TRANSACTIONCURRENCYID,
                    @BASEEXCHANGERATEID,
                    @EXCHANGERATE,
                    @HADSPOTRATE,
                    @RATECHANGED,
                    @ADJUSTMENTREASONCODEID;