Delete Workflow Business Event and Subscription API

--API To Delete the Workflow Business Events and Subscriptions

declare


cursor c_del_lines is
SELECT we.guid event_guid
     , wes.guid subscription_guid
     , wes.rule_function
  FROM wf_events we
     , wf_event_subscriptions wes
 WHERE we.NAME = 'oracle.apps.wf.notification.respond'--give your event name
   AND wes.event_filter_guid = we.guid;
 
   begin

   for i in c_del_lines loop
EXEC WF_EVENTS_PKG.DELETE_ROW(i.event_guid);

EXEC WF_EVENT_SUBSCRIPTIONS_PKG.DELETE_ROW(i.subscription_guid);

COMMIT;

end loop;


end;