[Home] [Help]
PACKAGE: APPS.CZ_MIGRATE
Source
1 PACKAGE cz_migrate AUTHID CURRENT_USER AS
2 /* $Header: czmigrs.pls 120.1 2006/03/06 13:39:41 srangar ship $ */
3
4 EXPLORETREE_ERROR EXCEPTION;
5 PRAGMA EXCEPTION_INIT(EXPLORETREE_ERROR, -20001);
6
7
8 ------------------------------------------------------------------------------------------------------------
9 type ColumnNameArray is table of user_tab_columns.column_name%type index by binary_integer;
10 type PkColumnNameArray is table of user_cons_columns.column_name%type index by binary_integer;
11 type TriggerNameArray is table of user_triggers.trigger_name%type index by binary_integer;
12 TYPE jraddoc_type_tbl IS TABLE OF cz_ui_pages.jrad_doc%TYPE index by BINARY_INTEGER;
13 ------------------------------------------------------------------------------------------------------------
14
15 FATAL_ERROR CONSTANT PLS_INTEGER := -1;
16 SKIPPABLE_ERROR CONSTANT PLS_INTEGER := 1;
17 NO_ERROR CONSTANT PLS_INTEGER := 0;
18
19 URGENCY_ERROR CONSTANT PLS_INTEGER := 0;
20 URGENCY_WARNING CONSTANT PLS_INTEGER := 1;
21 URGENCY_MESSAGE CONSTANT PLS_INTEGER := 2;
22 URGENCY_DEBUG CONSTANT PLS_INTEGER := 3;
23
24 MESSAGE_START_ID CONSTANT PLS_INTEGER := 1000;
25 GENERIC_RUN_ID CONSTANT PLS_INTEGER := -1001;
26
27 CONCURRENT_SUCCESS CONSTANT PLS_INTEGER := 0;
28 CONCURRENT_ERROR CONSTANT PLS_INTEGER := 2;
29
30 APPLICATIONS_SCHEMA CONSTANT VARCHAR2(4) := 'APPS';
31 CONFIGURATOR_SCHEMA CONSTANT VARCHAR2(4) := 'CZ';
32
33 SETUP_STATUS_CODE CONSTANT PLS_INTEGER := 11778;
34 MIGRATE_STATUS_CODE CONSTANT PLS_INTEGER := 11777;
35
36 CZ_MIGR_FATAL_EXCEPTION EXCEPTION;
37 CZ_MIGR_SKIPPABLE_EXCEPTION EXCEPTION;
38 CZ_MIGR_UNABLE_TO_REPORT EXCEPTION;
39
40 ------------------------------------------------------------------------------------------------------------
41 FUNCTION migrate_setup(x_run_id IN OUT NOCOPY PLS_INTEGER,
42 p_local_name IN VARCHAR2,
43 p_force_run IN VARCHAR2)
44 RETURN INTEGER;
45 ------------------------------------------------------------------------------------------------------------
46 FUNCTION migrate(x_run_id IN OUT NOCOPY PLS_INTEGER,
47 p_force_run IN VARCHAR2,
48 CommitSize in pls_integer,
49 StopOnSkippable in number,
50 ForceSlowMode in number,
51 AllowDifferentVersions in number,
52 AllowRefresh in number,
53 ForceProcess in number,
54 DeleteDbLink in number)
55 RETURN INTEGER;
56 ------------------------------------------------------------------------------------------------------------
57 function compare_versions return integer;
58 ------------------------------------------------------------------------------------------------------------
59 function compare_columns(inTableName in varchar2) return integer;
60 ------------------------------------------------------------------------------------------------------------
61 function get_table_columns(inTableName in varchar2,outNamesArray OUT NOCOPY ColumnNameArray) return integer;
62 ------------------------------------------------------------------------------------------------------------
63 function compare_pk_columns(inTableName in varchar2) return integer;
64 ------------------------------------------------------------------------------------------------------------
65 function get_table_pk_columns(inTableName in varchar2, outNamesArray OUT NOCOPY PkColumnNameArray) return integer;
66 ------------------------------------------------------------------------------------------------------------
67 function copy_table(inTableName in varchar2,
68 inCommitSize in pls_integer,
69 inStopOnSkippable in number,
70 inRefreshable in number,
71 inForceSlowMode in number,
72 inForceProcess in number)
73 return integer;
74 ------------------------------------------------------------------------------------------------------------
75 FUNCTION copy_table_override(inTableName IN VARCHAR2,
76 inStopOnSkippable IN NUMBER)
77 RETURN INTEGER;
78 ------------------------------------------------------------------------------------------------------------
79 function copy_all_tables(inCommitSize in pls_integer,
80 inStopOnSkippable in number,
81 inRefreshable in number,
82 inForceSlowMode in number,
83 inForceProcess in number)
84 return integer;
85 ------------------------------------------------------------------------------------------------------------
86 function copy_table_slowmode(inTableName in varchar2,
87 inCommitSize in pls_integer,
88 inStopOnSkippable in number,
89 inRefreshable in number) return integer;
90 ------------------------------------------------------------------------------------------------------------
91 function copy_table_fastmode(inTableName in varchar2,
92 inStopOnSkippable in number)
93 return integer;
94 ------------------------------------------------------------------------------------------------------------
95 function copy_table_fastnorefresh(inTableName in varchar2,
96 inStopOnSkippable in number)
97 return integer;
98 ------------------------------------------------------------------------------------------------------------
99 function copy_table_fastrefresh(inTableName in varchar2,
100 inStopOnSkippable in number)
101 return integer;
102 ------------------------------------------------------------------------------------------------------------
103 function disable_triggers(inStopOnSkippable in number) return integer;
104 ------------------------------------------------------------------------------------------------------------
105 function enable_triggers(inStopOnSkippable in number) return integer;
106 ------------------------------------------------------------------------------------------------------------
107 FUNCTION adjust_sequence(sequenceName IN VARCHAR2, tableName IN VARCHAR2, inPkName IN VARCHAR2, p_increment IN NUMBER)
108 RETURN INTEGER;
109 ------------------------------------------------------------------------------------------------------------
110 FUNCTION adjust_all_sequences(inStopOnSkippable IN NUMBER)
111 RETURN INTEGER;
112 ------------------------------------------------------------------------------------------------------------
113 PROCEDURE report(inMessage IN VARCHAR2, inUrgency IN PLS_INTEGER);
114 ------------------------------------------------------------------------------------------------------------
115 PROCEDURE setup_migration_cp(errbuf OUT NOCOPY VARCHAR2,
116 retcode OUT NOCOPY NUMBER,
117 p_source_name IN VARCHAR2,
118 p_force_run IN VARCHAR2 DEFAULT 'NO');
119 ------------------------------------------------------------------------------------------------------------
120 PROCEDURE run_migration_cp(errbuf OUT NOCOPY VARCHAR2,
121 retcode OUT NOCOPY NUMBER,
122 p_force_run IN VARCHAR2 DEFAULT 'NO');
123 ------------------------------------------------------------------------------------------------------------
124 PROCEDURE get_xml_chunks (p_ui_def_id IN NUMBER,p_template_id IN NUMBER);
125
126 ------------------------------------------------------------------------------------------------------------
127 PROCEDURE import_jrad_docs (p_ui_def_id IN NUMBER,
128 p_link_name IN VARCHAR2,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2);
132 --------------------------------------------------------------------------------------------------------------
133 PROCEDURE import_template_jrad_docs (p_link_name IN VARCHAR2,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2);
137 ---------------------------------------------------------------------------------------------------------------
138 END cz_migrate;