USP_DATAFORMTEMPLATE_EDIT_GRANTAWARD_3

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@DATE	datetime	IN
@AMOUNT	money	IN
@POSTSTATUSCODE	tinyint	IN
@POSTDATE	datetime	IN
@SPLITS	xml	IN
@FREQUENCYCODE	tinyint	IN
@NUMBEROFINSTALLMENTS	int	IN
@NEXTTRANSACTIONDATE	datetime	IN
@INSTALLMENTS	xml	IN
@DONOTACKNOWLEDGE	bit	IN
@CATEGORYCODEID	uniqueidentifier	IN
@ISREIMBURSABLE	bit	IN
@OPPORTUNITYID	uniqueidentifier	IN
@BASECURRENCYID	uniqueidentifier	IN
@TRANSACTIONCURRENCYID	uniqueidentifier	IN
@BASEEXCHANGERATEID	uniqueidentifier	IN
@EXCHANGERATE	decimal(20, 8)	IN
@HADSPOTRATE	bit	IN
@RATECHANGED	bit	IN
@ADJPAYMENT_DATE	datetime	IN
@ADJPAYMENT_POSTDATE	datetime	IN
@ADJPAYMENT_REASONCODEID	uniqueidentifier	IN
@ADJPAYMENT_DETAILS	nvarchar(255)	IN

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_GRANTAWARD_3 (
              @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
              ,@ISREIMBURSABLE bit
              ,@OPPORTUNITYID uniqueidentifier
              ,@BASECURRENCYID uniqueidentifier
              ,@TRANSACTIONCURRENCYID uniqueidentifier
              ,@BASEEXCHANGERATEID uniqueidentifier
              ,@EXCHANGERATE decimal(20, 8)
              ,@HADSPOTRATE bit
              ,@RATECHANGED bit
              ,@ADJPAYMENT_DATE datetime
              ,@ADJPAYMENT_POSTDATE datetime
              ,@ADJPAYMENT_REASONCODEID uniqueidentifier
              ,@ADJPAYMENT_DETAILS nvarchar(255)
              )
            as
            set nocount on;

                declare @UPDATERECOGNITIONOPTION tinyint;

            exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_GRANTAWARD_3
                @ID = @ID
                ,@UPDATERECOGNITIONOPTION = @UPDATERECOGNITIONOPTION output

            exec dbo.USP_DATAFORMTEMPLATE_EDIT_GRANTAWARD_4
               @ID
               ,@CHANGEAGENTID
               ,@DATE
               ,@AMOUNT
               ,@POSTSTATUSCODE
               ,@POSTDATE
               ,@SPLITS
               ,@FREQUENCYCODE
               ,@NUMBEROFINSTALLMENTS
               ,@NEXTTRANSACTIONDATE
               ,@INSTALLMENTS
               ,@DONOTACKNOWLEDGE
               ,@CATEGORYCODEID
               ,@ISREIMBURSABLE
               ,@OPPORTUNITYID
               ,@BASECURRENCYID
               ,@TRANSACTIONCURRENCYID
               ,@BASEEXCHANGERATEID
               ,@EXCHANGERATE
               ,@HADSPOTRATE
               ,@RATECHANGED 
               ,@ADJPAYMENT_DATE
               ,@ADJPAYMENT_POSTDATE
               ,@ADJPAYMENT_REASONCODEID
               ,@ADJPAYMENT_DETAILS
               ,@UPDATERECOGNITIONOPTION

            return 0;