USP_DATAFORM_EDIT_FUNDINGREQUESTSTEPSALL

The save procedure used by the edit dataform template "Funding Request Steps All Edit Form".

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.
@STEPS	xml	IN

Definition

Copy



          CREATE procedure dbo.USP_DATAFORM_EDIT_FUNDINGREQUESTSTEPSALL
          (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier = null,
            @STEPS xml
          ) as begin
            set nocount on;

            if @CHANGEAGENTID is null
              exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

            begin try
              exec dbo.USP_FUNDINGREQUEST_STEPSWITHCHILDREN_UPDATEFROMXML @ID, @STEPS, @CHANGEAGENTID;
            end try
            begin catch
              exec dbo.USP_RAISE_ERROR;
              return 1;
            end catch

          return 0;
        end;