USP_DATAFORMTEMPLATE_EDIT_POSTEDGRANTAWARD_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
@ADJUSTMENTDATE	datetime	IN
@ADJUSTMENTPOSTDATE	datetime	IN
@ADJUSTMENTREASON	nvarchar(300)	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
@ADJUSTMENTREASONCODEID	uniqueidentifier	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_POSTEDGRANTAWARD_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
              ,@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
              ,@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_POSTEDGRANTAWARD_3
                @ID = @ID
                ,@UPDATERECOGNITIONOPTION = @UPDATERECOGNITIONOPTION output

              exec dbo.USP_DATAFORMTEMPLATE_EDIT_POSTEDGRANTAWARD_4
                @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 
                ,@ADJPAYMENT_DATE
                ,@ADJPAYMENT_POSTDATE
                ,@ADJPAYMENT_REASONCODEID
                ,@ADJPAYMENT_DETAILS
                ,@UPDATERECOGNITIONOPTION