USP_DATAFORMTEMPLATE_EDIT_PROSPECTFUNDINGINTEREST

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.
@FUNDINGTYPECODEID	uniqueidentifier	IN	Funding type
@INTERESTLEVELCODE	tinyint	IN	Level of interest
@COMMENT	nvarchar(max)	IN	Comments

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_PROSPECTFUNDINGINTEREST
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @FUNDINGTYPECODEID uniqueidentifier,
    @INTERESTLEVELCODE tinyint,
    @COMMENT nvarchar(max)
)

as
  set nocount on;

    declare @SITES xml;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PROSPECTFUNDINGINTEREST
        @ID = @ID,
        @SITES = @SITES output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_PROSPECTFUNDINGINTEREST_2
        @ID,
        @CHANGEAGENTID,
        @FUNDINGTYPECODEID,
        @INTERESTLEVELCODE,
        @COMMENT,
        @SITES

  return 0;