Oracle E-Business Suite: Cancelling or Closing Workflow Notification - Workflow Kapatma veya İptal Etme

There is a PL\SQL Script that can cancel or close workflow notifications through its API.   The script below has 2 parameters (recepient_role and close_type). The workflows can be closed or cansel with the script below according to its close type value.

 declare   
  -- declare Cursor   
  cursor get_notif is select * from wf_notifications where recipient_role='&UserName' and status='OPEN';  
  -- Local variables here  
  i integer      number(10):=1;  
  notification_type  varchar2(10):= '&nType';  
 begin  
  dbms_output.put_line('Executing Procedure');  
  -- open cursor to check open notifications which needs to be closed  
  for c_get_notif in get_notif  
   loop  
   begin  
   
   -- Check notificaiton type (close or cancel)  
   -- CLOSE - This will close information notifications only, all action required notification will not be close  
   -- CANCEL - This will cancel notification, action required notification such as Approve/Reject will be cancelled and cannot be rollback, users will not be able to take actiion on such notification later  
   if upper(notification_type)='CLOSE' then  
    wf_notification.Close(c_get_notif.notification_id, c_get_notif.recipient_role);  
    i:=i+1;  
   elsif upper(notification_type)='CANCEL' then  
    wf_notification.cancel(c_get_notif.notification_id, c_get_notif.recipient_role);  
    i:=i+1;  
   end if;  
     
   exception  
    when others then  
    null;  
   end;  
   end loop;  
     
   commit;  
   dbms_output.put_line(to_char(i)||' records effected');  
   dbms_output.put_line('Procedure Executed Successfully');  
 end;

Why This Is Important?

It is because if these workflows are not cleaned, they can cause some serious queue. That is to say it will prevent  the other mails from going out or in.

Reference:

1-http://maqappsfusion.blogspot.com.tr/2013/05/close-or-cancel-workflow-notification.html