USP_DATAFORMTEMPLATE_EDIT_STEWARDSHIPPLANSTEWARD

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.
@CONSTITUENTID	uniqueidentifier	IN	Steward
@ROLECODEID	uniqueidentifier	IN	Role

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_STEWARDSHIPPLANSTEWARD
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @CONSTITUENTID uniqueidentifier,
    @ROLECODEID uniqueidentifier
)

as
  set nocount on;

    declare @STARTDATE date;
    declare @ENDDATE date;

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

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_STEWARDSHIPPLANSTEWARD_2
        @ID,
        @CHANGEAGENTID,
        @CONSTITUENTID,
        @ROLECODEID,
        @STARTDATE,
        @ENDDATE

  return 0;