UFN_FUNDINGREQUESTOUTLINE_STEPSFORFUNDINGPLANEDIT

Returns steps from a funding request outline for use on a specific funding plan's request in edit mode.
Return

Return Type
table
Parameters

Parameter	Parameter Type	Mode
@FUNDINGREQUESTOUTLINEID	uniqueidentifier	IN
@FUNDINGREQUESTID	uniqueidentifier	IN
@BASEDATE	datetime	IN
Definition

Copy


            CREATE function dbo.UFN_FUNDINGREQUESTOUTLINE_STEPSFORFUNDINGPLANEDIT(
                @FUNDINGREQUESTOUTLINEID uniqueidentifier, 
                @FUNDINGREQUESTID uniqueidentifier, 
                @BASEDATE datetime
            )
            returns @RET table (
                ID uniqueidentifier,
                FUNDINGREQUESTOUTLINESTEPID uniqueidentifier,
                OBJECTIVE nvarchar(100),
                OWNERID uniqueidentifier,
                FUNDINGREQUESTSTAGECODEID uniqueidentifier,
                STATUSCODE tinyint,
                EXPECTEDDATE datetime,
                ACTUALDATE datetime,
                INTERACTIONTYPECODEID uniqueidentifier,
                CONSTITUENTID uniqueidentifier
            )
            with execute as caller
            as begin
                declare @CONSTITUENTID uniqueidentifier;
                declare @FUNDINGPLANMANAGERID uniqueidentifier;
                declare @PRIMARYMANAGERID uniqueidentifier;
                declare @SECONDARYMANAGERID uniqueidentifier;

                select 
                    @CONSTITUENTID = GRANTS.GRANTORID,
                    @FUNDINGPLANMANAGERID = FUNDINGPLAN.FUNDINGPLANMANAGERID,
                    @PRIMARYMANAGERID = FUNDINGREQUEST.PRIMARYMANAGERID,
                    @SECONDARYMANAGERID = FUNDINGREQUEST.SECONDARYMANAGERID
                from dbo.FUNDINGPLAN
                    inner join dbo.FUNDINGREQUEST on FUNDINGREQUEST.FUNDINGPLANID = FUNDINGPLAN.ID
                    inner join dbo.GRANTS on GRANTS.ID = FUNDINGREQUEST.GRANTSID
                where FUNDINGREQUEST.ID=@FUNDINGREQUESTID;

                insert into @RET
                select 
                    null,
                    ID,
                    OBJECTIVE, 
                    case FUNDRAISERROLECODE 
                        when 0 
                            then @FUNDINGPLANMANAGERID 
                        when 1 
                            then @PRIMARYMANAGERID 
                        when 2 
                            then @SECONDARYMANAGERID 
                        else null 
                    end,
                    FUNDINGREQUESTSTAGECODEID, 
                    0,
                    dateadd(day, DATEOFFSET, dbo.UFN_DATE_GETEARLIESTTIME(@BASEDATE)),
                    null,
                    INTERACTIONTYPECODEID,
                    @CONSTITUENTID
                from 
                    dbo.FUNDINGREQUESTOUTLINESTEP
                where 
                    FUNDINGREQUESTOUTLINEID=@FUNDINGREQUESTOUTLINEID;

                return;
            end