Previous	Next		Contents	Index	Glossary	Library

procedure Activities

    (itemtype in varchar2 default null,
     enddate in date default sysdate);

Description

Deletes old versions of 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 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.
enddate	Specified date to delete up to.