Previous  Next          Contents  Index  Glossary  Library

Items

Syntax

procedure Items

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

Description

Deletes all items for the specified item type and end date using Item_Activity_Statuses( ). Deletes from the tables WF_ITEM_ATTRIBUTE_VALUES and WF_ITEMS 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 to delete. Leave this argument null to delete 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