USP_GENERATESTEPUPDATEBATCHPROCESS_DELETE

Executes the "Generate Step Update Batch Process: Delete" record operation.

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN Input parameter indicating the ID of the record being deleted.
@CHANGEAGENTID uniqueidentifier IN Input parameter indicating the ID of the change agent invoking the delete.

Definition

Copy


CREATE procedure dbo.USP_GENERATESTEPUPDATEBATCHPROCESS_DELETE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin
  set nocount on;

  exec dbo.USP_BUSINESSPROCESS_PARAMETERSETCANBEDELETED 'GENERATEBATCHPROCESSSTATUS', @ID;
  exec dbo.USP_BUSINESSPROCESSINSTANCE_DELETE 'd6aa3069-2c4a-4492-bb40-85e50c948ab9', @ID, @CHANGEAGENTID;
  exec dbo.USP_GENERATESTEPUPDATEBATCHPROCESS_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;

  return 0;    
end