PACKAGE: APPS.OE_PURGE_WF

Source

1 PACKAGE oe_purge_wf AUTHID CURRENT_USER AS
2   /* $Header: OEXVPWFS.pls 120.0.12010000.1 2009/06/24 07:57:59 spothula noship $ */
3 TYPE wf_details_type
4 IS
5   RECORD
6   (
7     instance_label VARCHAR2(30) ,
8     item_key       VARCHAR2(240) ,
9     order_number   NUMBER ,
10     org_id         NUMBER ) ;
11 TYPE wf_details_tbl_type
12 IS
13   TABLE OF wf_details_type INDEX BY binary_integer;
14 TYPE wf_type
15 IS
16   RECORD
17   (
18     item_type VARCHAR2(8) ,
19     item_key  VARCHAR2(240) );
20 TYPE wf_tbl_type
21 IS
22   TABLE OF wf_type INDEX BY BINARY_INTEGER;
23 PROCEDURE purge_orphan_errors
24   (
25     p_item_key IN VARCHAR2 DEFAULT NULL );
26 PROCEDURE attempt_to_close
27   (
28     p_item_key IN VARCHAR2 DEFAULT NULL );
29 PROCEDURE purge_item_type
30   (
31     p_item_type IN VARCHAR2 );
32 PROCEDURE purge_om_flows
33   (
34     errbuf OUT NOCOPY  VARCHAR2 ,
35     retcode OUT NOCOPY VARCHAR2 ,
36     p_item_type        IN VARCHAR2 DEFAULT NULL ,
37     p_item_key         IN VARCHAR2 DEFAULT NULL ,
38     p_age              IN NUMBER DEFAULT 0 ,
39     p_attempt_to_close IN VARCHAR2 DEFAULT 'N' ,
40     p_commit_frequency IN NUMBER DEFAULT 500 );
41 END OE_PURGE_WF;