procedure Notifications (itemtype in varchar2 default null, enddate in date default sysdate, docommit in boolean default TRUE, purgesigs in pls_integer default null);
Deletes old eligible notifications that are associated with the specified item type, have an END_DATE less than or equal to the specified end date, and are not referenced by an existing item. Any comments associated with these notifications are deleted as well.
However, to preserve electronic signature evidence for future reference, this API by default does not delete any notifications that required signatures or their associated signature information. If you do not need to maintain signature evidence, you can choose to delete signature-related information as well.
Deletes from the tables WF_NOTIFICATIONS, WF_NOTIFICATION_ATTRIBUTES, and WF_COMMENTS, and, if specified, from WF_DIG_SIGS.
You can use this procedure to delete notifications that are not associated with any work item, such as notifications that were sent by calling WF_NOTIFICATION.Send() rather than through a workflow process.
Note: You should call Items() before calling Notifications() to avoid having obsolete item references prevent obsolete notifications from being deleted.
| itemtype | Item type associated with the notifications you want to delete. Leave this argument null to delete notifications for all item types. |
| enddate | Specified date to delete up to. |
| docommit | Specify TRUE or FALSE to indicate whether to commit data while purging. If you want Notifications() to commit data as it purges to reduce rollback size and improve performance, specify TRUE. If you do not want to perform automatic commits, specify FALSE. Defaults to TRUE. |
| purgesigs | Leave this parameter null to preserve signature evidence, including notifications that required electronic signatures and their associated signature information. Specify 1 to delete signature-related information. Defaults to null. |