USP_DATAFORMTEMPLATE_EDITLOAD_POSTEDGRANTAWARD

The load 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 used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@GRANTNAME	nvarchar(150)	INOUT	Grant program
@GRANTORNAME	nvarchar(154)	INOUT	Grantor
@DATE	datetime	INOUT	Date
@AMOUNT	money	INOUT	Amount
@POSTSTATUSCODE	tinyint	INOUT	Post status
@POSTDATE	datetime	INOUT	Post date
@SPLITS	xml	INOUT	Designations
@FREQUENCYCODE	tinyint	INOUT	Frequency
@NUMBEROFINSTALLMENTS	int	INOUT	No. installments remaining
@NEXTTRANSACTIONDATE	datetime	INOUT	Next installment date
@AMOUNTPAID	money	INOUT	Amount paid
@INSTALLMENTS	xml	INOUT
@DONOTACKNOWLEDGE	bit	INOUT	Do not acknowledge
@MAINSINGLEDESIGNATIONID	uniqueidentifier	INOUT	Designation
@LASTPAYMENTSEQUENCE	int	INOUT	Installment sequence of last payment
@CATEGORYCODEID	uniqueidentifier	INOUT	Revenue category
@MAXSOLICITORSPLITAMOUNTS	xml	INOUT	Max solicitor split amounts
@ADJUSTMENTDATE	datetime	INOUT	Adjusted date
@ADJUSTMENTPOSTDATE	datetime	INOUT	Adjusted post date
@ADJUSTMENTPOSTSTATUSCODE	tinyint	INOUT	Post Status Code
@ADJUSTMENTREASON	nvarchar(300)	INOUT	Adjustment description
@ISREIMBURSABLE	bit	INOUT	Grant award is reimbursable
@GRANTAWARDON	tinyint	INOUT
@OPPORTUNITYID	uniqueidentifier	INOUT	Opportunity
@PROSPECTNAME	nvarchar(154)	INOUT	Prospect
@CONSTITUENTID	uniqueidentifier	INOUT
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT	Transaction currency
@BASEEXCHANGERATEID	uniqueidentifier	INOUT	Exchange rate ID
@EXCHANGERATE	decimal(20, 8)	INOUT	Exchange rate
@HADSPOTRATE	bit	INOUT	Had spot rate
@RATECHANGED	bit	INOUT	Rate changed
@BASEDECIMALDIGITS	tinyint	INOUT	Decimal digits
@BASEROUNDINGTYPECODE	tinyint	INOUT	Rounding type
@TRANSACTIONCURRENCYDESCRIPTION	nvarchar(110)	INOUT	Transaction currency description
@ADJUSTMENTREASONCODEID	uniqueidentifier	INOUT	Adjustment reason
@HASPOSTEDPAYMENTS	bit	INOUT	Grant award has posted payments
@USERGRANTEDSPOTRATE	bit	INOUT	User granted spot rate

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_POSTEDGRANTAWARD(
                        @ID uniqueidentifier,
                        @DATALOADED bit = 0 output,
                        @TSLONG bigint = 0 output,
                        @GRANTNAME nvarchar(150) = null output,
                        @GRANTORNAME nvarchar(154) = null output,
                        @DATE datetime = null output,
                        @AMOUNT money = null output,
                        @POSTSTATUSCODE tinyint = null output,
                        @POSTDATE datetime = null output,
                        @SPLITS xml = null output,
                        @FREQUENCYCODE tinyint = null output,
                        @NUMBEROFINSTALLMENTS int = null output,
                        @NEXTTRANSACTIONDATE datetime = null output,
                        @AMOUNTPAID money = null output,
                        @INSTALLMENTS xml = null output,
                        @DONOTACKNOWLEDGE bit = null output,
                        @MAINSINGLEDESIGNATIONID uniqueidentifier = null output,
                        @LASTPAYMENTSEQUENCE int = null output,
                        @CATEGORYCODEID uniqueidentifier = null output,
                        @MAXSOLICITORSPLITAMOUNTS xml = null output,
                        @ADJUSTMENTDATE datetime = null output,
                        @ADJUSTMENTPOSTDATE datetime = null output,
                        @ADJUSTMENTPOSTSTATUSCODE tinyint = null output,
                        @ADJUSTMENTREASON nvarchar(300) = null output,
                        @ISREIMBURSABLE bit = null output,
                        @GRANTAWARDON tinyint = null output,
                        @OPPORTUNITYID uniqueidentifier = null output,
                        @PROSPECTNAME nvarchar(154) = null output,
                        @CONSTITUENTID uniqueidentifier = null output,
                        @BASECURRENCYID uniqueidentifier = null output,
                        @TRANSACTIONCURRENCYID uniqueidentifier = null output,
                        @BASEEXCHANGERATEID uniqueidentifier = null output,
                        @EXCHANGERATE decimal(20,8) = null output,
                        @HADSPOTRATE bit = null output,
                        @RATECHANGED bit = null output,
                        @BASEDECIMALDIGITS tinyint = null output,
                        @BASEROUNDINGTYPECODE tinyint = null output,
                        @TRANSACTIONCURRENCYDESCRIPTION nvarchar(110) = null output,
                        @ADJUSTMENTREASONCODEID uniqueidentifier = null output,
            @HASPOSTEDPAYMENTS bit = null output,
            @USERGRANTEDSPOTRATE bit = null output
                    )
                    as

            set @DATALOADED = 0;

            declare @r int
            declare @HASPOSTEDWRITEOFFS bit = 0;

            exec @r = dbo.USP_DATAFORMTEMPLATE_EDITLOAD_POSTEDGRANTAWARD_3
                                    @ID=@ID,
                                    @DATALOADED=@DATALOADED output,
                                    @TSLONG=@TSLONG output,
                                    @GRANTNAME=@GRANTNAME output,
                                    @GRANTORNAME=@GRANTORNAME output,
                                    @DATE=@DATE output,
                                    @AMOUNT=@AMOUNT output,
                                    @POSTSTATUSCODE=@POSTSTATUSCODE output,
                                    @POSTDATE=@POSTDATE output,
                                    @SPLITS=@SPLITS output,
                                    @FREQUENCYCODE=@FREQUENCYCODE output,
                                    @NUMBEROFINSTALLMENTS=@NUMBEROFINSTALLMENTS output,
                                    @NEXTTRANSACTIONDATE=@NEXTTRANSACTIONDATE output,
                                    @AMOUNTPAID=@AMOUNTPAID output,
                                    @INSTALLMENTS=@INSTALLMENTS output,
                                    @DONOTACKNOWLEDGE=@DONOTACKNOWLEDGE output,
                                    @MAINSINGLEDESIGNATIONID=@MAINSINGLEDESIGNATIONID output,
                                    @LASTPAYMENTSEQUENCE=@LASTPAYMENTSEQUENCE output,
                                    @CATEGORYCODEID=@CATEGORYCODEID output,
                                    @MAXSOLICITORSPLITAMOUNTS=@MAXSOLICITORSPLITAMOUNTS output,
                                    @ADJUSTMENTDATE=@ADJUSTMENTDATE output,
                                    @ADJUSTMENTPOSTDATE=@ADJUSTMENTPOSTDATE output,
                                    @ADJUSTMENTPOSTSTATUSCODE=@ADJUSTMENTPOSTSTATUSCODE output,
                                    @ADJUSTMENTREASON=@ADJUSTMENTREASON output,
                                    @ISREIMBURSABLE=@ISREIMBURSABLE output,
                                    @GRANTAWARDON=@GRANTAWARDON output,
                                    @OPPORTUNITYID=@OPPORTUNITYID output,
                                    @PROSPECTNAME=@PROSPECTNAME output,
                                    @CONSTITUENTID=@CONSTITUENTID output,
                                    @BASECURRENCYID=@BASECURRENCYID output,
                              @TRANSACTIONCURRENCYID=@TRANSACTIONCURRENCYID output,
                                    @BASEEXCHANGERATEID=@BASEEXCHANGERATEID output,
                                    @EXCHANGERATE=@EXCHANGERATE output,
                                    @HADSPOTRATE=@HADSPOTRATE output,
                                    @RATECHANGED=@RATECHANGED output,
                                    @BASEDECIMALDIGITS=@BASEDECIMALDIGITS output,
                                    @BASEROUNDINGTYPECODE=@BASEROUNDINGTYPECODE output,
                                    @TRANSACTIONCURRENCYDESCRIPTION=@TRANSACTIONCURRENCYDESCRIPTION output,
                                    @ADJUSTMENTREASONCODEID=@ADJUSTMENTREASONCODEID output,
                        @HASPOSTEDPAYMENTS=@HASPOSTEDPAYMENTS output,
                        @HASPOSTEDWRITEOFFS=@HASPOSTEDWRITEOFFS output,
                        @HASPAYMENTS=@HASPOSTEDWRITEOFFS output,
                        @USERGRANTEDSPOTRATE=@USERGRANTEDSPOTRATE output,
                        @ADJPAYMENT_DATE=NULL,
                        @ADJPAYMENT_POSTDATE=NULL,
                        @ADJPAYMENT_REASONCODEID=NULL,
                        @ADJPAYMENT_DETAILS=NULL

                if @HASPOSTEDPAYMENTS=0 and @HASPOSTEDWRITEOFFS=1 set @HASPOSTEDPAYMENTS=1; --original routing returned true for @haspostedpayments, even if the revenue record just had posted writeoffs 


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

                return @r;