USP_DATAFORMTEMPLATE_RESEARCHDETAILS_EDITSAVE

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.
@PROSPECTMANAGERFUNDRAISERID	uniqueidentifier	IN	Prospect manager
@RESEARCHSTATUSCONFIRMED	bit	IN	Confirmed

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_RESEARCHDETAILS_EDITSAVE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @PROSPECTMANAGERFUNDRAISERID uniqueidentifier,
    @RESEARCHSTATUSCONFIRMED bit
)

as
  set nocount on;

    declare @RESEARCHSUMMARY nvarchar(max);

  exec dbo.USP_DATAFORMTEMPLATE_RESEARCHDETAILS_EDITLOAD
        @ID = @ID,
        @RESEARCHSUMMARY = @RESEARCHSUMMARY output

  exec dbo.USP_DATAFORMTEMPLATE_RESEARCHDETAILS_EDITSAVE_2
        @ID,
        @CHANGEAGENTID,
        @PROSPECTMANAGERFUNDRAISERID,
        @RESEARCHSTATUSCONFIRMED,
        @RESEARCHSUMMARY

  return 0;