[Home] [Help]
PACKAGE: APPS.AD_ZD_TABLE
Source
1 package AD_ZD_TABLE AUTHID CURRENT_USER as
2 /* $Header: ADZDTMS.pls 120.27.12020000.6 2012/12/12 16:04:42 asutrala ship $ */
3
4
5
6 /*
7 ** Utility Functions (Public)
8 */
9
10 function EV_EXISTS(
11 X_TABLE_OWNER in varchar2,
12 X_TABLE_NAME in varchar2) return varchar2;
13 pragma restrict_references (ev_exists, wnds, rnps, wnps);
14
15 function EV_VIEW (
16 X_TABLE_NAME in varchar2 ) return varchar2;
17 pragma restrict_references (ev_view, rnds, wnds, rnps, wnps);
18
19 function EV_TABLE (
20 X_EV_OWNER in varchar2,
21 X_EV_NAME in varchar2 ) return varchar2;
22 pragma restrict_references (ev_table, wnds, rnps, wnps);
23
24 function EV_VIEW_COLUMN (
25 X_COLUMN_NAME in varchar2 ) return varchar2;
26 pragma restrict_references (ev_view_column, rnds, wnds, rnps, wnps);
27
28 function EV_TABLE_COLUMN(
29 X_EV_OWNER in varchar2,
30 X_EV_NAME in varchar2,
31 X_COLUMN_NAME in varchar2) return varchar2;
32 pragma restrict_references (ev_table_column, wnds, rnps, wnps);
33
34 function EV_TABLE_COLUMN_REVISION(
35 X_COLUMN_NAME in varchar2) return varchar2;
36 pragma restrict_references (ev_table_column_revision, rnds, wnds, rnps, wnps);
37
38 function IS_SEED (
39 X_TABLE_OWNER in varchar2,
40 X_TABLE_NAME in varchar2 ) return varchar2;
41 pragma restrict_references (is_seed, wnds, rnps, wnps);
42
43
44 /*
45 ** Upgrade APIs (public)
46 */
47
48 procedure UPGRADE (
49 X_TABLE_OWNER in varchar2,
50 X_TABLE_NAME in varchar2 );
51
52 procedure UPGRADE_DB;
53
54 procedure DOWNGRADE (
55 X_TABLE_OWNER in varchar2,
56 X_TABLE_NAME in varchar2 );
57
58
59 procedure DROP_TABLE (
60 X_TABLE_OWNER in varchar2,
61 X_TABLE_NAME in varchar2,
62 X_DROP_STMT in varchar2,
63 X_UPD_STMT in varchar2,
64 X_DROPPED out nocopy varchar2);
65 /*
66 ** Index APIs (internal)
67 */
68
69 function REVISED_INDEX_NAME(X_ORIGINAL_INDEX_NAME in varchar2) return varchar2;
70 function REVISED_INDEX_REGEXP return varchar2;
71
72 function ORIGINAL_INDEX_NAME(X_REVISED_INDEX_NAME in varchar2) return varchar2;
73 function ORIGINAL_INDEX_REGEXP return varchar2;
74
75
76 procedure REVISE_INDEXES (
77 X_TABLE_OWNER in varchar2,
78 X_TABLE_NAME in varchar2);
79
80 procedure CUTOVER_INDEXES (
81 X_TABLE_OWNER in varchar2,
82 X_TABLE_NAME in varchar2);
83 /*
84 ** Patch APIs (public)
85 */
86 procedure PATCH (
87 X_TABLE_OWNER in varchar2,
88 X_TABLE_NAME in varchar2 );
89
90 procedure APPLY ( X_CET_NAME in varchar2);
91
92
93 /*
94 ** Patch APIs (internal)
95 */
96
97 procedure FINALIZE;
98
99 procedure CUTOVER (
100 X_TABLE_OWNER in varchar2 default NULL,
101 X_TABLE_NAME in varchar2 default NULL,
102 X_EXECUTE in boolean default true );
103
104 procedure CLEANUP (
105 X_TABLE_OWNER in varchar2 default NULL,
106 X_TABLE_NAME in varchar2 default NULL,
107 X_CLEAN_MODE in varchar2 default 'QUICK' );
108
109 procedure ABORT;
110
111 end AD_ZD_TABLE;