USP_DATAFORMTEMPLATE_EDIT_ADDOPPORTUNITIESPROCESS

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	Prospect plan selection
@OPPORTUNITYTYPECODEID	uniqueidentifier	IN	Type
@EXPECTEDASKAMOUNT	money	IN	Expected ask amount
@OPPORTUNITYDESIGNATIONS	xml	IN	Designations
@TRANSACTIONCURRENCYID	uniqueidentifier	IN	Currency
@OPPORTUNITYSTATUSCODE	tinyint	IN	Status

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_ADDOPPORTUNITIESPROCESS
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(100),
    @DESCRIPTION nvarchar(255),
    @IDSETREGISTERID uniqueidentifier,
    @OPPORTUNITYTYPECODEID uniqueidentifier,
    @EXPECTEDASKAMOUNT money,
    @OPPORTUNITYDESIGNATIONS xml,
    @TRANSACTIONCURRENCYID uniqueidentifier,
    @OPPORTUNITYSTATUSCODE tinyint
)

as
  set nocount on;

    declare @EXPECTEDASKDATE datetime;
    declare @ASKAMOUNT money;
    declare @ASKDATE datetime;
    declare @LIKELIHOODTYPECODEID uniqueidentifier;
    declare @RESPONSEDATE datetime;
    declare @COMMENT nvarchar(max);

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_ADDOPPORTUNITIESPROCESS
        @ID = @ID,
        @EXPECTEDASKDATE = @EXPECTEDASKDATE output,
        @ASKAMOUNT = @ASKAMOUNT output,
        @ASKDATE = @ASKDATE output,
        @LIKELIHOODTYPECODEID = @LIKELIHOODTYPECODEID output,
        @RESPONSEDATE = @RESPONSEDATE output,
        @COMMENT = @COMMENT output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_ADDOPPORTUNITIESPROCESS_2
        @ID,
        @CHANGEAGENTID,
        @NAME,
        @DESCRIPTION,
        @IDSETREGISTERID,
        @OPPORTUNITYTYPECODEID,
        @EXPECTEDASKAMOUNT,
        @OPPORTUNITYDESIGNATIONS,
        @TRANSACTIONCURRENCYID,
        @OPPORTUNITYSTATUSCODE,
        @EXPECTEDASKDATE,
        @ASKAMOUNT,
        @ASKDATE,
        @LIKELIHOODTYPECODEID,
        @RESPONSEDATE,
        @COMMENT

  return 0;