USP_DATAFORMTEMPLATE_EDIT_ADDPROSPECTPLANSPROCESS

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@IDSETREGISTERID	uniqueidentifier	IN	Constituent selection
@PROSPECTMANAGERFUNDRAISERID	uniqueidentifier	IN	Manager for new prospects
@PROSPECTPLANNAME	nvarchar(100)	IN	Plan name
@PROSPECTPLANTYPECODEID	uniqueidentifier	IN	Plan type
@NARRATIVE	nvarchar(1000)	IN	Narrative
@PLANOUTLINEID	uniqueidentifier	IN	Plan outline
@STARTDATETYPECODE	tinyint	IN	Plan start date
@STARTDATE	date	IN
@DAYSBEFOREORAFTER	int	IN
@PRIMARYMANAGERFUNDRAISERID	uniqueidentifier	IN	Primary manager
@SECONDARYMANAGERFUNDRAISERID	uniqueidentifier	IN	Secondary manager
@SECONDARYFUNDRAISERS	xml	IN	Secondary solicitors
@SITES	xml	IN	Sites
@CREATEOPPORTUNITIES	bit	IN	Add opportunities for plans
@OPPORTUNITYTYPECODEID	uniqueidentifier	IN	Opportunity type
@EXPECTEDASKAMOUNT	money	IN	Expected ask amount
@OPPORTUNITYDESIGNATIONS	xml	IN	Designations

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_ADDPROSPECTPLANSPROCESS
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(100),
    @DESCRIPTION nvarchar(255),
    @IDSETREGISTERID uniqueidentifier,
    @PROSPECTMANAGERFUNDRAISERID uniqueidentifier,
    @PROSPECTPLANNAME nvarchar(100),
    @PROSPECTPLANTYPECODEID uniqueidentifier,
    @NARRATIVE nvarchar(1000),
    @PLANOUTLINEID uniqueidentifier,
    @STARTDATETYPECODE tinyint,
    @STARTDATE date,
    @DAYSBEFOREORAFTER int,
    @PRIMARYMANAGERFUNDRAISERID uniqueidentifier,
    @SECONDARYMANAGERFUNDRAISERID uniqueidentifier,
    @SECONDARYFUNDRAISERS xml,
    @SITES xml,
    @CREATEOPPORTUNITIES bit,
    @OPPORTUNITYTYPECODEID uniqueidentifier,
    @EXPECTEDASKAMOUNT money,
    @OPPORTUNITYDESIGNATIONS xml
)

as
  set nocount on;

    declare @PROSPECTPLANCURRENCYSETID uniqueidentifier;
    declare @OPPORTUNITYTRANSACTIONCURRENCYID uniqueidentifier;
    declare @OPPORTUNITYSTATUSCODE tinyint;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_ADDPROSPECTPLANSPROCESS
        @ID = @ID,
        @PROSPECTPLANCURRENCYSETID = @PROSPECTPLANCURRENCYSETID output,
        @OPPORTUNITYTRANSACTIONCURRENCYID = @OPPORTUNITYTRANSACTIONCURRENCYID output,
        @OPPORTUNITYSTATUSCODE = @OPPORTUNITYSTATUSCODE output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_ADDPROSPECTPLANSPROCESS_2
        @ID,
        @CHANGEAGENTID,
        @NAME,
        @DESCRIPTION,
        @IDSETREGISTERID,
        @PROSPECTMANAGERFUNDRAISERID,
        @PROSPECTPLANNAME,
        @PROSPECTPLANTYPECODEID,
        @NARRATIVE,
        @PLANOUTLINEID,
        @STARTDATETYPECODE,
        @STARTDATE,
        @DAYSBEFOREORAFTER,
        @PRIMARYMANAGERFUNDRAISERID,
        @SECONDARYMANAGERFUNDRAISERID,
        @SECONDARYFUNDRAISERS,
        @SITES,
        @CREATEOPPORTUNITIES,
        @OPPORTUNITYTYPECODEID,
        @EXPECTEDASKAMOUNT,
        @OPPORTUNITYDESIGNATIONS,
        @PROSPECTPLANCURRENCYSETID,
        @OPPORTUNITYTRANSACTIONCURRENCYID,
        @OPPORTUNITYSTATUSCODE

  return 0;