Delete Business Event and Subscription

------------------------
declare
   cursor cur_event
   is
     select we.guid event_guid
           ,wes.guid subscription_guid
       from wf_events we
           ,wf_event_subscriptions wes
      where we.name = 'oracle.apps.xxpo.test_busi_event' --<<Business Event Name>>
        and wes.event_filter_guid = we.guid;  
begin
   for rec_event in cur_event
   loop
      wf_events_pkg.delete_row(rec_event.event_guid);
      wf_event_subscriptions_pkg.delete_row(rec_event.subscription_guid);
   end loop;
   commit;
exception  
   when others then
      dbms_output.put_line('Error: '||sqlerrm);
end;