[Home] [Help]
PACKAGE: APPS.INV_MGD_PURGE_CP
Source
1 PACKAGE INV_MGD_PURGE_CP AUTHID CURRENT_USER AS
2 /* $Header: INVCPURS.pls 120.1 2005/06/21 06:30:18 appldev ship $ */
3 -- +======================================================================+
4 -- | Copyright (c) 2000 Oracle Corporation |
5 -- | Redwood Shores, CA, USA |
6 -- | All rights reserved. |
7 -- +======================================================================+
8 -- | FILENAME |
9 -- | INVCPURS.pls |
10 -- | |
11 -- | DESCRIPTION |
12 -- | Spec of INV_MGD_PURGE_CP |
13 -- | |
14 -- | HISTORY |
15 -- | 08/28/00 vjavli Created |
16 -- | 12/11/00 vjavli signature updated to hierarchy_origin_id |
17 -- | 11/14/01 vjavli updated with Get_Organization_List |
18 -- | performance enhancement |
19 -- +======================================================================+
20
21 -- ===============================================
22 -- CONSTANTS for concurrent program return values
23 -- ===============================================
24 -- Return values for RETCODE parameter (standard for concurrent programs)
25 RETCODE_SUCCESS VARCHAR2(10) := '0';
26 RETCODE_WARNING VARCHAR2(10) := '1';
27 RETCODE_ERROR VARCHAR2(10) := '2';
28
29
30 -- =========================
31 -- PROCEDURES AND FUNCTIONS
32 -- =========================
33
34 --========================================================================
35 -- PROCEDURE : Purge PUBLIC
36 -- PARAMETERS: x_retcode return status
37 -- x_errbuf return error messages
38 -- p_org_hier_origin_id IN NUMBER Organization Hierarchy
39 -- Origin Id
40 -- p_org_hierarchy_id IN Organization Hierarchy Id
41 -- p_purge_date IN Purge Date
42 -- p_purge_name IN Purge Name
43 -- p_request_limit IN Number of request limit
44 --
45 -- COMMENT : This is a wrapper procedure invokes core transaction purge
46 -- program repetitively for each organization in the organization
47 -- hierarchy origin list. The procedure purges the transactions
48 -- across organizations
49 --=========================================================================
50 PROCEDURE Purge(x_retcode OUT NOCOPY VARCHAR2,
51 x_errbuff OUT NOCOPY VARCHAR2,
52 p_org_hier_origin_id IN NUMBER,
53 p_org_hierarchy_id IN NUMBER,
54 p_purge_date IN VARCHAR2,
55 p_purge_name IN VARCHAR2,
56 p_request_limit IN NUMBER);
57
58 END INV_MGD_PURGE_CP;