Oracle Workflow API Reference Release 2.6.3.5 Part Number B12163-02 |
Previous | Next | Contents | Index | Glossary |
procedure Items
(itemtype in varchar2 default null,
itemkey in varchar2 default null,
enddate in date default sysdate,
docommit in boolean default TRUE,
force in boolean default FALSE);
Description
Deletes all items for the specified item type, and/or item key, and end date, including process status information, notifications, and any comments associated with these notifications. In Oracle Applications, any electronic signature information associated with these notifications is deleted as well. Deletes from the tables WF_NOTIFICATIONS, WF_COMMENTS, WF_DIG_SIGS, WF_ITEM_ACTIVITY_STATUSES, WF_ITEM_ATTRIBUTE_VALUES and WF_ITEMS.
Arguments (input)
itemtype | Item type to delete. Leave this argument null to delete 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. |
docommit | Specify TRUE or FALSE to indicate whether to commit data while purging. If you want Items() 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. |
force | Specify TRUE or FALSE to indicate whether to delete records for child items that have ended, even if the corresponding parent item does not yet have an end date. Defaults to FALSE. |
Previous | Next | Contents | Index | Glossary |