USP_DATAFORMTEMPLATE_ADD_FUNDINGREQUESTSTEP_PRELOAD

The load procedure used by the edit dataform template "Funding Request Step Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@FUNDINGREQUESTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@OWNERID	uniqueidentifier	INOUT	Owner
@FUNDINGPLAN	nvarchar(154)	INOUT	Funding plan

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_FUNDINGREQUESTSTEP_PRELOAD (
                        @FUNDINGREQUESTID uniqueidentifier,
                        @OWNERID uniqueidentifier = null output,
                        @FUNDINGPLAN nvarchar(154) = null output
                    ) as begin
                        set nocount on;

                        select
                            @OWNERID = FUNDINGREQUEST.PRIMARYMANAGERID,
                            @FUNDINGPLAN = FUNDINGPLAN.NAME
                        from dbo.FUNDINGREQUEST
                            inner join dbo.FUNDINGPLAN on FUNDINGREQUEST.FUNDINGPLANID = FUNDINGPLAN.ID
                        where FUNDINGREQUEST.ID = @FUNDINGREQUESTID;

                        return 0;
                    end