USP_DATAFORMTEMPLATE_EDIT_MARKSTEWARDSHIPPLANSTEPCOMPLETE

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.
@ACTUALDATE	datetime	IN	Actual date
@NEXTDATE	datetime	IN	Next date

Definition

Copy



        CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MARKSTEWARDSHIPPLANSTEPCOMPLETE
        (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier = null,
            @ACTUALDATE datetime,
            @NEXTDATE datetime
        ) as begin
            set nocount on;

            declare @ACTUALSTARTTIME dbo.UDT_HOURMINUTE;
            declare @ACTUALENDTIME dbo.UDT_HOURMINUTE;

            exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MARKSTEWARDSHIPPLANSTEPCOMPLETE
                @ID,
                @ACTUALSTARTTIME,
                @ACTUALENDTIME

            exec dbo.USP_DATAFORMTEMPLATE_EDIT_MARKSTEWARDSHIPPLANSTEPCOMPLETE_2
                @ID,
                @ACTUALDATE,
                @NEXTDATE,
                @ACTUALSTARTTIME,
                @ACTUALENDTIME
        end