USP_FUNDINGREQUESTSTEP_ADD

Create a new prospect plan step.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@FUNDINGREQUESTID	uniqueidentifier	IN
@EXPECTEDDATE	datetime	IN
@ACTUALDATE	datetime	IN
@STATUSCODE	tinyint	IN
@OWNERID	uniqueidentifier	IN
@INTERACTIONTYPECODEID	uniqueidentifier	IN
@OBJECTIVE	nvarchar(100)	IN
@FUNDINGREQUESTSTAGECODEID	uniqueidentifier	IN
@COMMENT	nvarchar(max)	IN
@ADDITIONALFUNDRAISERS	xml	IN
@PARTICIPANTS	xml	IN
@INTERACTIONSUBCATEGORYID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_FUNDINGREQUESTSTEP_ADD
            (
                @ID uniqueidentifier = null output,
                @CHANGEAGENTID uniqueidentifier = null,
                @FUNDINGREQUESTID uniqueidentifier,
                @EXPECTEDDATE datetime,
                @ACTUALDATE datetime = null,
                @STATUSCODE tinyint = 0,
                @OWNERID uniqueidentifier = null,
                @INTERACTIONTYPECODEID uniqueidentifier = null,
                @OBJECTIVE nvarchar(100) = '',
                @FUNDINGREQUESTSTAGECODEID uniqueidentifier = null,
                @COMMENT nvarchar(max) = '',
                @ADDITIONALFUNDRAISERS xml = null,
                @PARTICIPANTS xml = null,
                @INTERACTIONSUBCATEGORYID uniqueidentifier = null
            )
            as begin
                set nocount on;

                if @ID is null
                    set @ID = newid()

                if @CHANGEAGENTID is null  
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                declare @CONSTITUENTID uniqueidentifier;
                select @CONSTITUENTID = GRANTS.GRANTORID 
                from dbo.FUNDINGREQUEST
                    inner join GRANTS on GRANTS.ID = FUNDINGREQUEST.GRANTSID
                where FUNDINGREQUEST.ID = @FUNDINGREQUESTID;

                begin try
                    insert into dbo.INTERACTION (
                        ID,
                        ADDEDBYID,
                        CHANGEDBYID,
                        CONSTITUENTID,
                        FUNDINGREQUESTID,
                        ACTUALDATE,
                        EXPECTEDDATE,
                        STATUSCODE,
                        FUNDRAISERID,
                        INTERACTIONTYPECODEID,
                        OBJECTIVE,
                        FUNDINGREQUESTSTAGECODEID,
                        INTERACTIONSUBCATEGORYID,
                        COMMENT
                    ) values (
                        @ID,
                        @CHANGEAGENTID,
                        @CHANGEAGENTID,
                        @CONSTITUENTID,
                        @FUNDINGREQUESTID,
                        @ACTUALDATE,
                        @EXPECTEDDATE,
                        @STATUSCODE,
                        @OWNERID,
                        @INTERACTIONTYPECODEID,
                        @OBJECTIVE,
                        @FUNDINGREQUESTSTAGECODEID,
                        @INTERACTIONSUBCATEGORYID,
                        @COMMENT
                    )

                    exec dbo.USP_INTERACTION_ADDITIONALFUNDRAISERS_ADDFROMXML @ID, @ADDITIONALFUNDRAISERS, @CHANGEAGENTID;
                    exec dbo.USP_INTERACTION_PARTICIPANTS_ADDFROMXML @ID, @PARTICIPANTS, @CHANGEAGENTID;
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch;
            end