USP_DATAFORMTEMPLATE_ADD_PROSPECT

The save procedure used by the add dataform template "Prospect 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.
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@PROSPECTID	uniqueidentifier	IN	Constituent
@PROSPECTMANAGERFUNDRAISERID	uniqueidentifier	IN	Prospect manager
@PROSPECTPLAN_PROSPECTPLANTYPECODEID	uniqueidentifier	IN	Plan type
@PROSPECTPLAN_PLANOUTLINEID	uniqueidentifier	IN	Plan outline
@PROSPECTPLAN_PRIMARYMANAGERFUNDRAISERID	uniqueidentifier	IN	Primary manager
@PROSPECTPLAN_SECONDARYMANAGERFUNDRAISERID	uniqueidentifier	IN	Secondary manager
@SECONDARYFUNDRAISERS	xml	IN	Secondary solicitors
@PROSPECTPLAN_NAME	nvarchar(100)	IN	Plan name
@PROSPECTPLAN_PARTICIPANTS	xml	IN	Plan participants
@SITES	xml	IN	Sites
@PROSPECTTEAM	xml	IN	Prospect team
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@PROSPECTPLAN_PRIMARYMANAGERDATEFROM	datetime	IN	Start date
@PROSPECTPLAN_SECONDARYMANAGERDATEFROM	datetime	IN	Start date
@PROSPECTMANAGERDATEFROM	datetime	IN	Start date
@PROSPECTPLAN_STARTDATE	datetime	IN	Start date

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PROSPECT (
                        @ID uniqueidentifier = null output,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @CONSTITUENTID uniqueidentifier, -- unused, left in for backwards compatibility

                        @PROSPECTID uniqueidentifier,
                        @PROSPECTMANAGERFUNDRAISERID uniqueidentifier = null,
                        @PROSPECTPLAN_PROSPECTPLANTYPECODEID uniqueidentifier = null,
                        @PROSPECTPLAN_PLANOUTLINEID uniqueidentifier = null,
                        @PROSPECTPLAN_PRIMARYMANAGERFUNDRAISERID uniqueidentifier = null,
                        @PROSPECTPLAN_SECONDARYMANAGERFUNDRAISERID uniqueidentifier = null,
                        @SECONDARYFUNDRAISERS xml = null,
                        @PROSPECTPLAN_NAME nvarchar(100) = '',
                        @PROSPECTPLAN_PARTICIPANTS xml = null,
                        @SITES xml = null,
                        @PROSPECTTEAM xml = null,
                        @CURRENTAPPUSERID uniqueidentifier = null,
                        @PROSPECTPLAN_PRIMARYMANAGERDATEFROM datetime = null,
                        @PROSPECTPLAN_SECONDARYMANAGERDATEFROM datetime = null,
                        @PROSPECTMANAGERDATEFROM datetime = null,
                        @PROSPECTPLAN_STARTDATE datetime = null
                    )
                    as begin
                        set nocount on;

                        declare @PROSPECTPLAN_BASECURRENCYID uniqueidentifier;
                        set @PROSPECTPLAN_BASECURRENCYID = dbo.UFN_APPUSER_GETBASECURRENCY(@CURRENTAPPUSERID);

                        exec dbo.USP_PROSPECT_ADD
                            @ID = @ID output,
                            @CHANGEAGENTID = @CHANGEAGENTID,
                            @PROSPECTID = @PROSPECTID,
                            @PROSPECTMANAGERFUNDRAISERID = @PROSPECTMANAGERFUNDRAISERID,
                            @PROSPECTPLAN_PROSPECTPLANTYPECODEID = @PROSPECTPLAN_PROSPECTPLANTYPECODEID,
                            @PROSPECTPLAN_PLANOUTLINEID = @PROSPECTPLAN_PLANOUTLINEID,
                            @PROSPECTPLAN_PRIMARYMANAGERFUNDRAISERID = @PROSPECTPLAN_PRIMARYMANAGERFUNDRAISERID,
                            @PROSPECTPLAN_SECONDARYMANAGERFUNDRAISERID = @PROSPECTPLAN_SECONDARYMANAGERFUNDRAISERID,
                            @SECONDARYFUNDRAISERS = @SECONDARYFUNDRAISERS,
                            @PROSPECTPLAN_NAME = @PROSPECTPLAN_NAME,
                            @PROSPECTPLAN_PARTICIPANTS = @PROSPECTPLAN_PARTICIPANTS,
                            @SITES = @SITES,
                            @PROSPECTTEAM = @PROSPECTTEAM,
                            @PROSPECTPLAN_PRIMARYMANAGERDATEFROM = @PROSPECTPLAN_PRIMARYMANAGERDATEFROM,
                            @PROSPECTPLAN_SECONDARYMANAGERDATEFROM = @PROSPECTPLAN_SECONDARYMANAGERDATEFROM,
                            @PROSPECTMANAGERSTARTDATE = @PROSPECTMANAGERDATEFROM,
                            @PROSPECTPLAN_BASECURRENCYID = @PROSPECTPLAN_BASECURRENCYID,
                            @PROSPECTPLAN_STARTDATE = @PROSPECTPLAN_STARTDATE

                    end