| Oracle Workflow API Reference Release 2.6.3 Part Number B10286-02 |
|
|
|
|
| ||
| Previous | Next | Contents | Index | Glossary |
procedure Activities
(itemtype in varchar2 default null,
name in varchar2 default null,
enddate in date default sysdate);
Description
Deletes old versions of eligible activities from the tables WF_ACTIVITY_ATTR_VALUES, WF_ACTIVITY_TRANSITIONS, WF_PROCESS_ACTIVITIES, WF_ACTIVITY_ATTRIBUTES_TL, WF_ACTIVITY_ATTRIBUTES, WF_ACTIVITIES_TL, and WF_ACTIVITIES 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 as either a process or activity.
Note: You should call Items( ) before calling Activities( ) to avoid having obsolete item references prevent obsolete activities from being deleted.
Arguments (input)
| itemtype | Item type associated with the activities you want to delete. Leave this argument null to delete activities for all item types. |
| name | Internal name of activity to delete. Leave this argument null to delete all activities for the specified item type. |
| enddate | Specified date to delete up to. |
| Previous | Next | Contents | Index | Glossary |
