USP_DATAFORM_EDIT_STEWARDSHIPPLANPENDINGSTEPS_ORGWITHSUBSIDIARIES

The save procedure used by the edit dataform template "Organization Stewardship Plan With Subsidiaries Pending Steps Edit Form".

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

Definition

Copy


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

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

  declare @CHANGEDATE datetime;
  set @CHANGEDATE = getdate();

  begin try    
    exec dbo.USP_STEWARDSHIPPLAN_STEPSWITHCHILDREN_UPDATEFROMXML @ID, 0, @STEPS, @CURRENTAPPUSERID, @CHANGEAGENTID, @CHANGEDATE;                            
  end try
  begin catch
    exec dbo.USP_RAISE_ERROR;
    return 1;
  end catch

  return 0;
end;