USP_GENERATEBATCHPROCESS_DELETE

Executes the "Generate 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_GENERATEBATCHPROCESS_DELETE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin
  set nocount on;

  exec dbo.USP_BUSINESSPROCESS_PARAMETERSETCANBEDELETED 'GENERATEBATCHPROCESSSTATUS', @ID;
  exec dbo.USP_BUSINESSPROCESSINSTANCE_DELETE 'b226b0a0-043d-47bf-9dc4-6594ba5bbcbd', @ID, @CHANGEAGENTID;
  exec dbo.USP_GENERATEBATCHPROCESS_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;

  return 0;    
end