Skip Headers

Oracle Workflow API Reference
Release 2.6.3.5

Part Number B12163-02
Previous Next       Contents Index Glossary
         Previous  Next          Contents  Index  Glossary

TotalPERM

Syntax

procedure TotalPERM

    (itemtype in varchar2 default null,
itemkey in varchar2 default null,
enddate in date default sysdate,
docommit in boolean default TRUE,
runtimeonly in boolean default FALSE);

Description

Deletes all eligible obsolete runtime data that is of persistence type 'PERM' (Permanent) and that is associated with the specified item type and has an END_DATE less than or equal to the specified end date. In Oracle Applications, this procedure also deletes any Oracle XML Gateway transaction information associated with the items being purged.

If the RUNTIME ONLY parameter is set to TRUE, TotalPERM() deletes only runtime data associated with work items. However, if the RUNTIMEONLY parameter is set to FALSE, TotalPERM() also deletes these types of data:

TotalPERM() is similar to Total() except that TotalPERM() deletes only items with a persistence type of 'PERM'. See: Total.

Arguments (input)

itemtype Item type associated with the obsolete runtime data you want to delete. Leave this argument null to delete obsolete runtime data 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.
docommit Specify TRUE or FALSE to indicate whether to commit data while purging. If you want TotalPERM() to commit data as it purges to reduce rollback size and improve performance, specify TRUE. If you do not want to perform automatic commits, specify FALSE. Defaults to TRUE.
runtimeonly Specify TRUE to purge only obsolete runtime data associated with work items, or FALSE to purge all obsolete runtime data as well obsolete design data. Defaults to FALSE.


         Previous  Next          Contents  Index  Glossary



Oracle Logo
Copyright © 2003, 2004, Oracle. All rights reserved.