Oracle Workflow API Reference Release 2.6.3.5 Part Number B12163-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 design 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 |