USP_DATAFORMTEMPLATE_EDIT_POSTEDGRANTAWARD_2

The save procedure used by the edit dataform template "Posted Grant Award Edit 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.
@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 description
@ISREIMBURSABLE	bit	IN	Grant award is reimbursable
@OPPORTUNITYID	uniqueidentifier	IN	Opportunity
@BASECURRENCYID	uniqueidentifier	IN	Base currency
@TRANSACTIONCURRENCYID	uniqueidentifier	IN	Transaction currency
@BASEEXCHANGERATEID	uniqueidentifier	IN	Exchange rate ID
@EXCHANGERATE	decimal(20, 8)	IN	Exchange rate
@HADSPOTRATE	bit	IN	Had spot rate
@RATECHANGED	bit	IN	Rate changed
@ADJUSTMENTREASONCODEID	uniqueidentifier	IN	Adjustment reason

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_POSTEDGRANTAWARD_2 (
                        @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,
                        @BASECURRENCYID uniqueidentifier,
                        @TRANSACTIONCURRENCYID uniqueidentifier,
                        @BASEEXCHANGERATEID uniqueidentifier,
                        @EXCHANGERATE decimal(20,8),
                        @HADSPOTRATE bit,
                        @RATECHANGED bit,
                        @ADJUSTMENTREASONCODEID uniqueidentifier
                    )
                    as

            declare @r int;

            exec @r = dbo.USP_DATAFORMTEMPLATE_EDIT_POSTEDGRANTAWARD_3 
                            @ID=@ID,
                            @CHANGEAGENTID=@CHANGEAGENTID,
                            @DATE=@DATE,
                            @AMOUNT=@AMOUNT,
                            @POSTSTATUSCODE=@POSTSTATUSCODE,
                            @POSTDATE=@POSTDATE,
                            @SPLITS=@SPLITS,
                            @FREQUENCYCODE=@FREQUENCYCODE,
                            @NUMBEROFINSTALLMENTS=@NUMBEROFINSTALLMENTS,
                            @NEXTTRANSACTIONDATE=@NEXTTRANSACTIONDATE,
                            @INSTALLMENTS=@INSTALLMENTS,
                            @DONOTACKNOWLEDGE=@DONOTACKNOWLEDGE,
                            @CATEGORYCODEID=@CATEGORYCODEID,
                            @ADJUSTMENTDATE=@ADJUSTMENTDATE,
                            @ADJUSTMENTPOSTDATE=@ADJUSTMENTPOSTDATE,
                            @ADJUSTMENTREASON=@ADJUSTMENTREASON,
                            @ISREIMBURSABLE=@ISREIMBURSABLE,
                            @OPPORTUNITYID=@OPPORTUNITYID,
                            @BASECURRENCYID=@BASECURRENCYID,
                            @TRANSACTIONCURRENCYID=@TRANSACTIONCURRENCYID,
                            @BASEEXCHANGERATEID=@BASEEXCHANGERATEID,
                            @EXCHANGERATE=@EXCHANGERATE,
                            @HADSPOTRATE=@HADSPOTRATE,
                            @RATECHANGED=@RATECHANGED,
                            @ADJUSTMENTREASONCODEID=@ADJUSTMENTREASONCODEID,
                @ADJPAYMENT_DATE=NULL,
                @ADJPAYMENT_POSTDATE=NULL,
                @ADJPAYMENT_REASONCODEID=NULL,
                @ADJPAYMENT_DETAILS=NULL;

            if @@error <> 0
                begin 
                    if @r <> 0 return @r
                    return 1;    
                end 

            return @r;