USP_DATAFORM_EDIT_STEWARDSHIPPLANDETAILS

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Plan name
@MANAGERID	uniqueidentifier	IN	Manager
@SITES	xml	IN	Sites
@PLANTYPEID	uniqueidentifier	IN
@PLANSUBTYPEID	uniqueidentifier	IN

Definition

Copy



CREATE procedure USP_DATAFORM_EDIT_STEWARDSHIPPLANDETAILS
(
    @ID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(100),
    @MANAGERID uniqueidentifier,
    @SITES xml,
    @PLANTYPEID uniqueidentifier,
    @PLANSUBTYPEID uniqueidentifier
)

as
  set nocount on;

  declare @STARTDATE datetime;

  exec dbo.USP_DATAFORM_EDITLOAD_STEWARDSHIPPLANDETAILS
        @ID = @ID,
        @CURRENTAPPUSERID = @CURRENTAPPUSERID,
        @STARTDATE = @STARTDATE output

  exec dbo.USP_DATAFORM_EDIT_STEWARDSHIPPLANDETAILS_2
        @ID,
        @CURRENTAPPUSERID,
        @CHANGEAGENTID,
        @NAME,
        @MANAGERID,
        @SITES,
        @PLANTYPEID,
        @PLANSUBTYPEID,
        @STARTDATE

  return 0;