Previous  Next          Contents  Index  Glossary  Library

Item_Notifications

Syntax

procedure Item_Notifications

    (itemtype in varchar2 default null,
     itemkey in varchar2 default null,
     enddate in date default sysdate);

Description

Deletes notifications sent by a particular item from the tables WF_NOTIFICATION_ATTRIBUTES and WF_NOTIFICATIONS 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.

Note: You should call Items( ) before calling Item_Notifications( ) to avoid having obsolete item references prevent obsolete notifications from being deleted.

Arguments (input)

itemtypeItem type associated with the notifications you want to delete. Leave this argument null to delete notifications for all item types.
itemkey A string generated from the application object's primary key. The string uniquely identifies the item within an item type. If null, the procedure purges all items in the specified itemtype.
enddate Specified date to delete up to.

         Previous  Next          Contents  Index  Glossary  Library