Oracle Workflow Guide Release 2.6.2 Part Number A95265-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 |