USP_DATAFORMTEMPLATE_EDITLOAD_FUNDINGREQUEST

The load procedure used by the edit dataform template "Funding Request Edit Data 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.
@FUNDINGPLANID	uniqueidentifier	INOUT	FUNDINGPLANID
@GRANTID	uniqueidentifier	INOUT	Grant program
@FUNDINGREQUESTSTATUSCODEID	uniqueidentifier	INOUT	Status
@AMOUNTREQUESTED	money	INOUT	Amount requested
@DATESUBMITTED	datetime	INOUT	Date submitted
@COMMENT	nvarchar(500)	INOUT	Comment
@PRIMARYMANAGERID	uniqueidentifier	INOUT	Primary manager
@SECONDARYMANAGERID	uniqueidentifier	INOUT	Secondary manager
@SPONSORS	xml	INOUT	Secondary solicitors
@AWARDED	bit	INOUT	AWARDED
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT	Currency
@GRANTORNAME	nvarchar(255)	INOUT	Grantor

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_FUNDINGREQUEST(
                        @ID uniqueidentifier,
                        @DATALOADED bit = 0 output,
                        @TSLONG bigint = 0 output,
                        @FUNDINGPLANID uniqueidentifier = null output,
                        @GRANTID uniqueidentifier = null output,
                        @FUNDINGREQUESTSTATUSCODEID uniqueidentifier = null output,
                        @AMOUNTREQUESTED money = null output,
                        @DATESUBMITTED datetime = null output,
                        @COMMENT nvarchar(500) = null output,
                        @PRIMARYMANAGERID uniqueidentifier = null output,
                        @SECONDARYMANAGERID uniqueidentifier = null output,
                        @SPONSORS xml = null output,
                        @AWARDED bit = null output,
                        @TRANSACTIONCURRENCYID uniqueidentifier = null output,
                        @GRANTORNAME nvarchar(255) = null output            
                    )
                    as

                        set nocount on;

                        -- be sure to set these, in case the select returns no rows        

                        set @DATALOADED = 0
                        set @TSLONG = 0

                        select                        
                            @TRANSACTIONCURRENCYID = FUNDINGREQUEST.TRANSACTIONCURRENCYID,
                            @DATALOADED = 1,
                            @FUNDINGPLANID = FUNDINGREQUEST.FUNDINGPLANID,
                            @GRANTID = FUNDINGREQUEST.GRANTSID,
                            @GRANTORNAME = dbo.UFN_CONSTITUENT_BUILDNAME(GRANTS.GRANTORID),
                            @FUNDINGREQUESTSTATUSCODEID = FUNDINGREQUEST.FUNDINGREQUESTSTATUSCODEID,
                            @AMOUNTREQUESTED = FUNDINGREQUEST.TRANSACTIONAMOUNTREQUESTED,
                            @DATESUBMITTED = FUNDINGREQUEST.DATESUBMITTED,
                            @COMMENT = FUNDINGREQUEST.COMMENT,
                            @PRIMARYMANAGERID = FUNDINGREQUEST.PRIMARYMANAGERID,
                            @SECONDARYMANAGERID = FUNDINGREQUEST.SECONDARYMANAGERID,
                            @SPONSORS = dbo.UFN_FUNDINGREQUEST_GETSPONSORS_TOITEMLISTXML(FUNDINGREQUEST.ID),
                            @AWARDED = case when (select count(ID) from dbo.REVENUEFUNDINGREQUEST where REVENUEFUNDINGREQUEST.FUNDINGREQUESTID = FUNDINGREQUEST.ID) > 0 then
                                1
                            else
                                0
                            end,
                            @TSLONG = FUNDINGREQUEST.TSLONG
                        from 
                            dbo.FUNDINGREQUEST
                            inner join dbo.GRANTS on GRANTS.ID = FUNDINGREQUEST.GRANTSID
                        where 
                            FUNDINGREQUEST.ID = @ID

                        return 0;