PACKAGE: APPS.WSM_JOBPURGE_GRP

Source

1 PACKAGE WSM_JobPurge_GRP AUTHID CURRENT_USER AS
2 /* $Header: WSMPLBJS.pls 120.2 2006/03/27 20:43:31 mprathap noship $ */
3 
4 REPORT_ONLY      constant number := 1;
5 PURGE_AND_REPORT constant number := 2;
6 PURGE_ONLY       constant number := 3;
7 -- Info type
8 EXCEPTIONS    constant number := 1;
9 ROWS_AFFECTED constant number := 2;
10 
11 
12 procedure delete_osfm_tables(
13                               p_option        in number,
14                               p_group_id      in number,
15                               p_purge_request in wip_wictpg.get_purge_requests%rowtype,
16                               -- ST Fix for bug 4918553
17                               p_detail_flag   IN BOOLEAN DEFAULT TRUE,
18                               p_return_status out NOCOPY VARCHAR2
19                               );
20 
21 
22 END WSM_JobPurge_GRP;