Previous  Next          Contents  Index  Glossary  Library

Item_Activity_Statuses

Syntax

procedure Item_Activity_Statuses

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

Description

Deletes from the tables WF_ITEM_ACTIVITY_STATUSES and WF_ITEM_ACTIVITY_STATUSES_H all rows of data associated with the specified item type and whose value for END_DATE is less than or equal to the specified end date.

Arguments (input)

itemtypeItem type associated with the activity statuses you want to delete. Leave this argument null to delete activity statuses for all item types.
itemkey A string generated from the application object's primary key. The string uniquely identifies the item within an item type. If null, the procedure purges all items in the specified itemtype.
enddate Specified date to delete up to.

         Previous  Next          Contents  Index  Glossary  Library