USP_DATAFORMTEMPLATE_ADD_FUNDINGREQUESTSTEP

The save procedure used by the add dataform template "Funding Request Step Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@FUNDINGREQUESTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@EXPECTEDDATE	datetime	IN	Expected date
@ACTUALDATE	datetime	IN	Actual date
@STATUSCODE	tinyint	IN	Status
@OWNERID	uniqueidentifier	IN	Owner
@INTERACTIONTYPECODEID	uniqueidentifier	IN	Contact method
@OBJECTIVE	nvarchar(100)	IN	Objective
@FUNDINGREQUESTSTAGECODEID	uniqueidentifier	IN	Stage
@COMMENT	nvarchar(max)	IN	Comment
@ADDITIONALFUNDRAISERS	xml	IN	Additional fundraisers
@PARTICIPANTS	xml	IN	Participants
@INTERACTIONCATEGORYID	uniqueidentifier	IN	Category
@INTERACTIONSUBCATEGORYID	uniqueidentifier	IN	Subcategory

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_FUNDINGREQUESTSTEP
                    (
                        @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,
                        @INTERACTIONCATEGORYID uniqueidentifier = null,
                        @INTERACTIONSUBCATEGORYID uniqueidentifier = null
                    )
                    as begin
                        set nocount on;

                        exec dbo.USP_FUNDINGREQUESTSTEP_ADD @ID output, @CHANGEAGENTID, @FUNDINGREQUESTID, @EXPECTEDDATE, @ACTUALDATE, @STATUSCODE, @OWNERID, 
                            @INTERACTIONTYPECODEID, @OBJECTIVE, @FUNDINGREQUESTSTAGECODEID, @COMMENT, @ADDITIONALFUNDRAISERS, @PARTICIPANTS, 
                            @INTERACTIONSUBCATEGORYID;

                        return 0;
                    end