USP_COMMITMULTIPLEBATCHESPROCESS_DELETE

Executes the "Commit Multiple Batches 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_COMMITMULTIPLEBATCHESPROCESS_DELETE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin                        
    set nocount on

    exec dbo.USP_BUSINESSPROCESS_PARAMETERSETCANBEDELETED 'BATCHESCOMMITPROCESSSTATUS', @ID;

    exec dbo.USP_BUSINESSPROCESSINSTANCE_DELETE '8bda5883-5fc0-4b1e-b88a-b6cba975f515', @ID, @CHANGEAGENTID;

    exec dbo.USP_BATCHESCOMMITPROCESS_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID
    return 0;
end