PACKAGE: APPS.HXC_UPGRADE_PKG

Source

1 PACKAGE HXC_UPGRADE_PKG
2 /* $Header: hxcupgpkg.pkh 120.5.12020000.1 2012/06/28 05:47:25 appldev ship $ */
3 AS
4 
5     TYPE VARCHARTABLE IS TABLE OF VARCHAR2(2500);
6     TYPE NUMTABLE IS TABLE OF NUMBER;
7     TYPE DATETABLE IS TABLE OF DATE;
8 
9 
10     TYPE VARCHAR_ASSOCARRAY IS TABLE OF VARCHAR2(100) INDEX BY VARCHAR2(50);
11     g_upg_name  VARCHAR_ASSOCARRAY;
12 
13   PROCEDURE upgrade( errbuff   OUT NOCOPY VARCHAR2,
14                      retcode   OUT NOCOPY NUMBER,
15                      p_type IN VARCHAR2,
16                      p_stop_after IN NUMBER DEFAULT -999,
17                      p_num_workers IN NUMBER DEFAULT -1);
18 
19   PROCEDURE upgrade_wk( errbuff  OUT NOCOPY VARCHAR2,
20                         retcode  OUT NOCOPY VARCHAR2,
21                         p_type   IN VARCHAR2,
22                         p_start  IN NUMBER,
23                         p_stop   IN NUMBER,
24                         p_stop_after IN NUMBER DEFAULT -999);
25 
26  PROCEDURE put_log(p_text   IN VARCHAR2);
27 
28  PROCEDURE insert_into_upg_defn
29                   (p_upg_type   IN VARCHAR2);
30 
31  FUNCTION ret_upgrade_completed
32  RETURN BOOLEAN;
33 
34  FUNCTION txn_upgrade_completed
35  RETURN BOOLEAN;
36 
37  FUNCTION get_ret_process_id (p_process  IN VARCHAR2)
38  RETURN NUMBER;
39 
40  FUNCTION upgrade_name(p_lookup_code  IN VARCHAR2)
41  RETURN VARCHAR2;
42 
43 
44  FUNCTION performance_upgrade_complete(p_upg_type  IN VARCHAR2)
45  RETURN BOOLEAN;
46 
47 
48 
49 END HXC_UPGRADE_PKG;