Oracle Apps Knowledge Sharing

        Below script will help you to cancel any workflow notification from Database

Tested Instance: R12

Script:

CREATE OR REPLACE FUNCTION xxwf_cancel (pin_noitification_id  IN NUMBER)
RETURN VARCHAR2 
IS
BEGIN
  wf_notification.cancel
       (nid            => pin_noitification_id,
        cancel_comment => 'This notification is cancelled from Backend.'
       );
  COMMIT;   
  RETURN 'Action Completed Successfully';  
EXCEPTION
  WHEN OTHERS THEN
    RETURN 'Error: ' || SQLERRM;
END xxwf_cancel;

Test Script:

DECLARE 
 lv_message VARCHAR2(1000);
BEGIN 
 lv_message := xxwf_cancel(2906622);
 DBMS_OUTPUT.put_line(lv_message);
END;