Close Oracle Open Notifications wf_notifications

 Closing WFERROR Notifications

/*

To Close Error Notifications use the Below Procedure :

 */

DECLARE

    CURSOR c_notif

    IS

        SELECT notification_id

          FROM wf_notifications

         WHERE     status = 'CLOSED'

               AND MESSAGE_TYPE = 'WFERROR'

               AND begin_date < SYSDATE - 1;

--AND ADDITIONAL CRITERIA THAT ALLOW TO LIST ALL THE FYI NOTIFICATIONS TO BE CLOSED>;

BEGIN

    FOR n IN c_notif

    LOOP

        wf_notification.close (n.notification_id, 'SYSADMIN');

    END LOOP;

--COMMIT;

END;