USP_DATAFORM_EDIT_STEWARDSHIPPLANMANAGER

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.
@MANAGERID	uniqueidentifier	IN	Manager

Definition

Copy



CREATE procedure USP_DATAFORM_EDIT_STEWARDSHIPPLANMANAGER
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @MANAGERID uniqueidentifier
)

as
  set nocount on;

    declare @STARTDATE date;
    declare @ENDDATE date;

  exec dbo.USP_DATAFORM_EDITLOAD_STEWARDSHIPPLANMANAGER
        @ID = @ID,
        @STARTDATE = @STARTDATE output,
        @ENDDATE = @ENDDATE output

  exec dbo.USP_DATAFORM_EDIT_STEWARDSHIPPLANMANAGER_2
        @ID,
        @CHANGEAGENTID,
        @MANAGERID,
        @STARTDATE,
        @ENDDATE

  return 0;