| Previous | Next |  | Contents | Index | Glossary

## Activities

Syntax

`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) | itemtypeItem 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