USP_HOLD_DELETE

Executes the "Delete Hold" 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_HOLD_DELETE
        (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier
        )
        as begin

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

            exec USP_HOLD_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID
            return 0;

        end