USP_DATAFORMTEMPLATE_EDIT_ADDPROSPECTPLANSPROCESS_2

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
@OPPORTUNITYTYPECODEID	uniqueidentifier	IN	Opportunity type
@EXPECTEDASKAMOUNT	money	IN	Expected ask amount
@OPPORTUNITYDESIGNATIONS	xml	IN	Designations
@PROSPECTPLANCURRENCYSETID	uniqueidentifier	IN	Plan base currency
@OPPORTUNITYTRANSACTIONCURRENCYID	uniqueidentifier	IN	Opportunity transaction currency
@OPPORTUNITYSTATUSCODE	tinyint	IN	Opportunity status

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_ADDPROSPECTPLANSPROCESS_2
(
    @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,
    @OPPORTUNITYTYPECODEID uniqueidentifier,
    @EXPECTEDASKAMOUNT money,
    @OPPORTUNITYDESIGNATIONS xml,
    @PROSPECTPLANCURRENCYSETID uniqueidentifier,
    @OPPORTUNITYTRANSACTIONCURRENCYID uniqueidentifier,
    @OPPORTUNITYSTATUSCODE tinyint
)

as
  set nocount on;

    declare @PLANSTEPS xml;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_ADDPROSPECTPLANSPROCESS
        @ID = @ID,
        @PLANSTEPS = @PLANSTEPS output

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

  return 0;