delete_all_errors Procedure

BEGIN
DBMS_APPLY_ADM.DELETE_ALL_ERRORs(
Apply_name => ‘LN4_APPLY’);
END;
/

It is important to note that if the apply_name is specified as NULL, error transactions of all the Apply Processes are dropped. Beware of this. Sometimes, this may not the intention. When that happens, the record of all errors is lost. 

drop_apply Procedure

When a particular apply process is no longer needed, the drop_apply procedure helps to drop it.

Here is the syntax:
DBMS_APPLY_ADM.DROP_APPLY(
apply_name                              IN VARCHAR2,
drop_unused_rule_sets             IN BOOLEAN DEFAULT false);

When drop_unused_rule_sets is set to TRUE, it drops any rule sets; positive and negative, used by the specified Apply process provided these rule sets are not used by any other Streams client.  Other Streams clients include Capture Processes, Propagations, Apply processes, and messaging clients. If this procedure drops a rule set, the procedure also drops any rules in the rule set that are not in another rule set. Any particular rule can be in multiple rules sets.