[Home] [Help]
1: package body ecx_utils as
2: -- $Header: ECXUTILB.pls 120.13 2011/02/15 07:05:39 jmaddila ship $
3: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
4: l_statement PLS_INTEGER := ecx_debug.g_statement;
5: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
15: i_level IN pls_integer,
16: i_Where_string OUT NOCOPY VARCHAR2
17: ) IS
18:
19: i_method_name varchar2(2000) := 'ecx_utils.select_clause';
20: cSelect_stmt VARCHAR2(32000) := 'SELECT ';
21: cFrom_stmt VARCHAR2(100) := ' FROM ';
22: cWhere_stmt VARCHAR2(80) := ' WHERE 1=1 ';
23:
25: cDATE VARCHAR2(40) := ',''YYYYMMDD HH24MISS'')';
26: cWord1 VARCHAR2(20) := ' ';
27: cWord2 VARCHAR2(40) := ' ';
28:
29: iRow_count pls_integer := ecx_utils.g_source.COUNT;
30: i pls_integer;
31: BEGIN
32: if (l_procedureEnabled) then
33: ecx_debug.push(i_method_name);
36: if(l_statementEnabled) then
37: ecx_debug.log(l_statement, 'i_level',i_level,i_method_name);
38: end if;
39:
40: i := ecx_utils.g_source_levels(i_level).file_start_pos;
41: loop
42: if (ecx_utils.g_source(i).external_level = i_level) then
43: -- **************************************
44: -- apply appropriate data conversion
38: end if;
39:
40: i := ecx_utils.g_source_levels(i_level).file_start_pos;
41: loop
42: if (ecx_utils.g_source(i).external_level = i_level) then
43: -- **************************************
44: -- apply appropriate data conversion
45: -- convert everything to VARCHAR2
46: -- **************************************
44: -- apply appropriate data conversion
45: -- convert everything to VARCHAR2
46: -- **************************************
47:
48: if 12 = ecx_utils.g_source(i).data_type Then
49: cWord1 := cTO_CHAR;
50: cWord2 := cDATE;
51:
52: elsif 2 = ecx_utils.g_source(i).data_type Then
48: if 12 = ecx_utils.g_source(i).data_type Then
49: cWord1 := cTO_CHAR;
50: cWord2 := cDATE;
51:
52: elsif 2 = ecx_utils.g_source(i).data_type Then
53: cWord1 := cTO_CHAR;
54: cWord2 := ')';
55: else
56: cWord1 := NULL;
58: END if;
59:
60: -- build SELECT statement
61: cSelect_stmt := cSelect_stmt || ' ' || cWord1 ||
62: nvl(ecx_utils.g_source(i).base_column_Name,'NULL') || cWord2 || ',';
63: end if;
64: exit when i= ecx_utils.g_source_levels(i_level).file_end_pos;
65: i := ecx_utils.g_source.next(i);
66: End Loop;
60: -- build SELECT statement
61: cSelect_stmt := cSelect_stmt || ' ' || cWord1 ||
62: nvl(ecx_utils.g_source(i).base_column_Name,'NULL') || cWord2 || ',';
63: end if;
64: exit when i= ecx_utils.g_source_levels(i_level).file_end_pos;
65: i := ecx_utils.g_source.next(i);
66: End Loop;
67:
68: -- build FROM, WHERE statements
61: cSelect_stmt := cSelect_stmt || ' ' || cWord1 ||
62: nvl(ecx_utils.g_source(i).base_column_Name,'NULL') || cWord2 || ',';
63: end if;
64: exit when i= ecx_utils.g_source_levels(i_level).file_end_pos;
65: i := ecx_utils.g_source.next(i);
66: End Loop;
67:
68: -- build FROM, WHERE statements
69:
66: End Loop;
67:
68: -- build FROM, WHERE statements
69:
70: cFrom_stmt := cFrom_Stmt||' '||ecx_utils.g_source_levels(i_level).base_table_name;
71:
72: cSelect_stmt := RTRIM(cSelect_stmt, ',');
73: i_Where_string := cSelect_stmt||' '||cFrom_stmt||' '||cWhere_Stmt;
74:
82: exception
83: when others then
84: if(l_unexpectedEnabled) then
85: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
86: 'PROGRESS_LEVEL','ECX_UTILS.SELect_CLAUSE');
87: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
88: 'ERROR_MESSAGE',SQLERRM);
89: end if;
90: ecx_utils.error_type := 30;
86: 'PROGRESS_LEVEL','ECX_UTILS.SELect_CLAUSE');
87: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
88: 'ERROR_MESSAGE',SQLERRM);
89: end if;
90: ecx_utils.error_type := 30;
91: ecx_utils.i_ret_code :=2;
92: raise ecx_utils.PROGRAM_EXIT;
93: END select_clause;
94:
87: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
88: 'ERROR_MESSAGE',SQLERRM);
89: end if;
90: ecx_utils.error_type := 30;
91: ecx_utils.i_ret_code :=2;
92: raise ecx_utils.PROGRAM_EXIT;
93: END select_clause;
94:
95: /**
88: 'ERROR_MESSAGE',SQLERRM);
89: end if;
90: ecx_utils.error_type := 30;
91: ecx_utils.i_ret_code :=2;
92: raise ecx_utils.PROGRAM_EXIT;
93: END select_clause;
94:
95: /**
96: Loads the Objects required by the Outbound transaction. This includes
102: (
103: i_map_id in pls_integer
104: )
105: is
106: i_method_name varchar2(2000) := 'ecx_utils.load_objects';
107: i_counter pls_integer :=0;
108: k pls_integer;
109: i_root_element ecx_objects.root_element%TYPE;
110: i_fullpath ecx_objects.fullpath%TYPE;
115: if (l_procedureEnabled) then
116: ecx_debug.push(i_method_name);
117: end if;
118:
119: if (ecx_utils.g_source_levels.COUNT >0) then
120: for i in ecx_utils.g_source_levels.first..ecx_utils.g_source_levels.last
121: LOOP
122: if (i <> 0)
123: then
116: ecx_debug.push(i_method_name);
117: end if;
118:
119: if (ecx_utils.g_source_levels.COUNT >0) then
120: for i in ecx_utils.g_source_levels.first..ecx_utils.g_source_levels.last
121: LOOP
122: if (i <> 0)
123: then
124: select_clause
123: then
124: select_clause
125: (
126: i,
127: ecx_utils.g_source_levels(i).sql_stmt
128: );
129:
130:
131: /** Call Append clause for all the levels **/
142: **/
143:
144:
145: if(l_statementEnabled) then
146: ecx_debug.log(l_statement,ecx_utils.g_source_levels(i).sql_stmt,i_method_name);
147: end if;
148:
149: -- Open Cursor For Each level and store the handles in the PL/SQL table.
150: ecx_utils.g_source_levels(i).Cursor_handle := dbms_sql.open_cursor;
146: ecx_debug.log(l_statement,ecx_utils.g_source_levels(i).sql_stmt,i_method_name);
147: end if;
148:
149: -- Open Cursor For Each level and store the handles in the PL/SQL table.
150: ecx_utils.g_source_levels(i).Cursor_handle := dbms_sql.open_cursor;
151:
152: if(l_statementEnabled) then
153: ecx_debug.log(l_statement,'Cursor handle',
154: ecx_utils.g_source_levels(i).Cursor_handle,i_method_name);
150: ecx_utils.g_source_levels(i).Cursor_handle := dbms_sql.open_cursor;
151:
152: if(l_statementEnabled) then
153: ecx_debug.log(l_statement,'Cursor handle',
154: ecx_utils.g_source_levels(i).Cursor_handle,i_method_name);
155: end if;
156:
157: -- Parse the Select Statement for Each level
158: BEGIN
156:
157: -- Parse the Select Statement for Each level
158: BEGIN
159: dbms_sql.parse (
160: ecx_utils.g_source_levels(i).cursor_handle,
161: ecx_utils.g_source_levels(i).sql_stmt,
162: dbms_sql.native
163: );
164: EXCEPTION
157: -- Parse the Select Statement for Each level
158: BEGIN
159: dbms_sql.parse (
160: ecx_utils.g_source_levels(i).cursor_handle,
161: ecx_utils.g_source_levels(i).sql_stmt,
162: dbms_sql.native
163: );
164: EXCEPTION
165: WHEN OTHERS THEN
165: WHEN OTHERS THEN
166: ecx_error_handling_pvt.print_parse_error
167: (
168: dbms_sql.last_error_position,
169: ecx_utils.g_source_levels(i).sql_stmt
170: );
171:
172:
173: if(l_statementEnabled) then
171:
172:
173: if(l_statementEnabled) then
174: ecx_debug.log(l_statement,'ECX','ECX_PROGRAM_ERROR',i_method_name,
175: 'PROGRESS_LEVEL','ECX_UTILS.LOAD_OBJECTS');
176: ecx_debug.log(l_statement,'ECX','ECX_PARSE_VIEW_ERROR',i_method_name,'LEVEL',i);
177: ecx_debug.log(l_statement, 'ECX', SQLERRM || ' - ECX_UTILS.LOAD_OBJECTS',i_method_name);
178: end if;
179: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_UTILS.LOAD_OBJECTS');
173: if(l_statementEnabled) then
174: ecx_debug.log(l_statement,'ECX','ECX_PROGRAM_ERROR',i_method_name,
175: 'PROGRESS_LEVEL','ECX_UTILS.LOAD_OBJECTS');
176: ecx_debug.log(l_statement,'ECX','ECX_PARSE_VIEW_ERROR',i_method_name,'LEVEL',i);
177: ecx_debug.log(l_statement, 'ECX', SQLERRM || ' - ECX_UTILS.LOAD_OBJECTS',i_method_name);
178: end if;
179: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_UTILS.LOAD_OBJECTS');
180: raise ecx_utils.PROGRAM_EXIT;
181: END;
175: 'PROGRESS_LEVEL','ECX_UTILS.LOAD_OBJECTS');
176: ecx_debug.log(l_statement,'ECX','ECX_PARSE_VIEW_ERROR',i_method_name,'LEVEL',i);
177: ecx_debug.log(l_statement, 'ECX', SQLERRM || ' - ECX_UTILS.LOAD_OBJECTS',i_method_name);
178: end if;
179: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_UTILS.LOAD_OBJECTS');
180: raise ecx_utils.PROGRAM_EXIT;
181: END;
182:
183: i_counter :=0;
176: ecx_debug.log(l_statement,'ECX','ECX_PARSE_VIEW_ERROR',i_method_name,'LEVEL',i);
177: ecx_debug.log(l_statement, 'ECX', SQLERRM || ' - ECX_UTILS.LOAD_OBJECTS',i_method_name);
178: end if;
179: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_UTILS.LOAD_OBJECTS');
180: raise ecx_utils.PROGRAM_EXIT;
181: END;
182:
183: i_counter :=0;
184: -- Define Columns for Each Level
181: END;
182:
183: i_counter :=0;
184: -- Define Columns for Each Level
185: k := ecx_utils.g_source_levels(i).file_start_pos;
186: LOOP
187: if (ecx_utils.g_source(k).external_level = i) then
188: i_counter := i_counter + 1;
189: /** Change required for Clob Support -- 2263729 ***/
183: i_counter :=0;
184: -- Define Columns for Each Level
185: k := ecx_utils.g_source_levels(i).file_start_pos;
186: LOOP
187: if (ecx_utils.g_source(k).external_level = i) then
188: i_counter := i_counter + 1;
189: /** Change required for Clob Support -- 2263729 ***/
190: if ecx_utils.g_source(k).data_type <> 112 Then
191: dbms_sql.define_column
186: LOOP
187: if (ecx_utils.g_source(k).external_level = i) then
188: i_counter := i_counter + 1;
189: /** Change required for Clob Support -- 2263729 ***/
190: if ecx_utils.g_source(k).data_type <> 112 Then
191: dbms_sql.define_column
192: (
193: ecx_utils.g_source_levels(i).Cursor_Handle,
194: i_counter,
189: /** Change required for Clob Support -- 2263729 ***/
190: if ecx_utils.g_source(k).data_type <> 112 Then
191: dbms_sql.define_column
192: (
193: ecx_utils.g_source_levels(i).Cursor_Handle,
194: i_counter,
195: ecx_utils.g_source_levels(i).sql_stmt,
196: ecx_utils.G_VARCHAR_LEN
197: );
191: dbms_sql.define_column
192: (
193: ecx_utils.g_source_levels(i).Cursor_Handle,
194: i_counter,
195: ecx_utils.g_source_levels(i).sql_stmt,
196: ecx_utils.G_VARCHAR_LEN
197: );
198: else
199: dbms_sql.define_column
192: (
193: ecx_utils.g_source_levels(i).Cursor_Handle,
194: i_counter,
195: ecx_utils.g_source_levels(i).sql_stmt,
196: ecx_utils.G_VARCHAR_LEN
197: );
198: else
199: dbms_sql.define_column
200: (
197: );
198: else
199: dbms_sql.define_column
200: (
201: ecx_utils.g_source_levels(i).Cursor_Handle,
202: i_counter,
203: l_clob
204: );
205: end if;
203: l_clob
204: );
205: end if;
206: end if;
207: exit when k = ecx_utils.g_source_levels(i).file_end_pos;
208: k := ecx_utils.g_source.next(k);
209: END LOOP;
210: end if;
211:
204: );
205: end if;
206: end if;
207: exit when k = ecx_utils.g_source_levels(i).file_end_pos;
208: k := ecx_utils.g_source.next(k);
209: END LOOP;
210: end if;
211:
212: END LOOP;
214: if (l_procedureEnabled) then
215: ecx_debug.pop(i_method_name);
216: end if;
217: EXCEPTION
218: WHEN ecx_utils.PROGRAM_EXIT then
219: raise ecx_utils.program_exit;
220: WHEN OTHERS THEN
221: if(l_unexpectedEnabled) then
222: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
215: ecx_debug.pop(i_method_name);
216: end if;
217: EXCEPTION
218: WHEN ecx_utils.PROGRAM_EXIT then
219: raise ecx_utils.program_exit;
220: WHEN OTHERS THEN
221: if(l_unexpectedEnabled) then
222: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
223: 'PROGRESS_LEVEL',
220: WHEN OTHERS THEN
221: if(l_unexpectedEnabled) then
222: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
223: 'PROGRESS_LEVEL',
224: 'ECX_UTILS.LOAD_OBJECTS');
225: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
226: 'ERROR_MESSAGE',SQLERRM);
227: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_UTILS.LOAD_OBJECTS',i_method_name);
228: end if;
223: 'PROGRESS_LEVEL',
224: 'ECX_UTILS.LOAD_OBJECTS');
225: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
226: 'ERROR_MESSAGE',SQLERRM);
227: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_UTILS.LOAD_OBJECTS',i_method_name);
228: end if;
229: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_UTILS.LOAD_OBJECTS');
230: raise ecx_utils.PROGRAM_EXIT;
231: end load_objects;
225: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
226: 'ERROR_MESSAGE',SQLERRM);
227: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_UTILS.LOAD_OBJECTS',i_method_name);
228: end if;
229: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_UTILS.LOAD_OBJECTS');
230: raise ecx_utils.PROGRAM_EXIT;
231: end load_objects;
232:
233: procedure load_procedure_mappings (
226: 'ERROR_MESSAGE',SQLERRM);
227: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_UTILS.LOAD_OBJECTS',i_method_name);
228: end if;
229: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_UTILS.LOAD_OBJECTS');
230: raise ecx_utils.PROGRAM_EXIT;
231: end load_objects;
232:
233: procedure load_procedure_mappings (
234: i_map_id IN pls_integer) IS
232:
233: procedure load_procedure_mappings (
234: i_map_id IN pls_integer) IS
235:
236: i_method_name varchar2(2000) := 'ecx_utils.load_procedure_mappings';
237: cursor proc_mapping (
238: p_map_id pls_integer) IS
239: select epm.transtage_id transtage_id,
240: upper(etsd.custom_procedure_name) procedure_name,
261: end if;
262: if(l_statementEnabled) then
263: ecx_debug.log(l_statement,'i_map_id',i_map_id,i_method_name);
264: end if;
265: ecx_utils.g_procedure_mappings.DELETE;
266:
267: for proc_map in proc_mapping (i_map_id) loop
268: i := i + 1;
269: ecx_utils.g_procedure_mappings(i).transtage_id := proc_map.transtage_id;
265: ecx_utils.g_procedure_mappings.DELETE;
266:
267: for proc_map in proc_mapping (i_map_id) loop
268: i := i + 1;
269: ecx_utils.g_procedure_mappings(i).transtage_id := proc_map.transtage_id;
270: ecx_utils.g_procedure_mappings(i).procedure_name := proc_map.procedure_name;
271: ecx_utils.g_procedure_mappings(i).parameter_name := proc_map.parameter_name;
272: ecx_utils.g_procedure_mappings(i).action_type := proc_map.action_type;
273: ecx_utils.g_procedure_mappings(i).variable_level := proc_map.variable_level;
266:
267: for proc_map in proc_mapping (i_map_id) loop
268: i := i + 1;
269: ecx_utils.g_procedure_mappings(i).transtage_id := proc_map.transtage_id;
270: ecx_utils.g_procedure_mappings(i).procedure_name := proc_map.procedure_name;
271: ecx_utils.g_procedure_mappings(i).parameter_name := proc_map.parameter_name;
272: ecx_utils.g_procedure_mappings(i).action_type := proc_map.action_type;
273: ecx_utils.g_procedure_mappings(i).variable_level := proc_map.variable_level;
274: ecx_utils.g_procedure_mappings(i).variable_name := proc_map.variable_name;
267: for proc_map in proc_mapping (i_map_id) loop
268: i := i + 1;
269: ecx_utils.g_procedure_mappings(i).transtage_id := proc_map.transtage_id;
270: ecx_utils.g_procedure_mappings(i).procedure_name := proc_map.procedure_name;
271: ecx_utils.g_procedure_mappings(i).parameter_name := proc_map.parameter_name;
272: ecx_utils.g_procedure_mappings(i).action_type := proc_map.action_type;
273: ecx_utils.g_procedure_mappings(i).variable_level := proc_map.variable_level;
274: ecx_utils.g_procedure_mappings(i).variable_name := proc_map.variable_name;
275: ecx_utils.g_procedure_mappings(i).variable_pos := proc_map.variable_pos;
268: i := i + 1;
269: ecx_utils.g_procedure_mappings(i).transtage_id := proc_map.transtage_id;
270: ecx_utils.g_procedure_mappings(i).procedure_name := proc_map.procedure_name;
271: ecx_utils.g_procedure_mappings(i).parameter_name := proc_map.parameter_name;
272: ecx_utils.g_procedure_mappings(i).action_type := proc_map.action_type;
273: ecx_utils.g_procedure_mappings(i).variable_level := proc_map.variable_level;
274: ecx_utils.g_procedure_mappings(i).variable_name := proc_map.variable_name;
275: ecx_utils.g_procedure_mappings(i).variable_pos := proc_map.variable_pos;
276: ecx_utils.g_procedure_mappings(i).variable_direction := proc_map.variable_direction;
269: ecx_utils.g_procedure_mappings(i).transtage_id := proc_map.transtage_id;
270: ecx_utils.g_procedure_mappings(i).procedure_name := proc_map.procedure_name;
271: ecx_utils.g_procedure_mappings(i).parameter_name := proc_map.parameter_name;
272: ecx_utils.g_procedure_mappings(i).action_type := proc_map.action_type;
273: ecx_utils.g_procedure_mappings(i).variable_level := proc_map.variable_level;
274: ecx_utils.g_procedure_mappings(i).variable_name := proc_map.variable_name;
275: ecx_utils.g_procedure_mappings(i).variable_pos := proc_map.variable_pos;
276: ecx_utils.g_procedure_mappings(i).variable_direction := proc_map.variable_direction;
277: ecx_utils.g_procedure_mappings(i).data_type := proc_map.data_type;
270: ecx_utils.g_procedure_mappings(i).procedure_name := proc_map.procedure_name;
271: ecx_utils.g_procedure_mappings(i).parameter_name := proc_map.parameter_name;
272: ecx_utils.g_procedure_mappings(i).action_type := proc_map.action_type;
273: ecx_utils.g_procedure_mappings(i).variable_level := proc_map.variable_level;
274: ecx_utils.g_procedure_mappings(i).variable_name := proc_map.variable_name;
275: ecx_utils.g_procedure_mappings(i).variable_pos := proc_map.variable_pos;
276: ecx_utils.g_procedure_mappings(i).variable_direction := proc_map.variable_direction;
277: ecx_utils.g_procedure_mappings(i).data_type := proc_map.data_type;
278: ecx_utils.g_procedure_mappings(i).variable_constant := proc_map.variable_constant;
271: ecx_utils.g_procedure_mappings(i).parameter_name := proc_map.parameter_name;
272: ecx_utils.g_procedure_mappings(i).action_type := proc_map.action_type;
273: ecx_utils.g_procedure_mappings(i).variable_level := proc_map.variable_level;
274: ecx_utils.g_procedure_mappings(i).variable_name := proc_map.variable_name;
275: ecx_utils.g_procedure_mappings(i).variable_pos := proc_map.variable_pos;
276: ecx_utils.g_procedure_mappings(i).variable_direction := proc_map.variable_direction;
277: ecx_utils.g_procedure_mappings(i).data_type := proc_map.data_type;
278: ecx_utils.g_procedure_mappings(i).variable_constant := proc_map.variable_constant;
279:
272: ecx_utils.g_procedure_mappings(i).action_type := proc_map.action_type;
273: ecx_utils.g_procedure_mappings(i).variable_level := proc_map.variable_level;
274: ecx_utils.g_procedure_mappings(i).variable_name := proc_map.variable_name;
275: ecx_utils.g_procedure_mappings(i).variable_pos := proc_map.variable_pos;
276: ecx_utils.g_procedure_mappings(i).variable_direction := proc_map.variable_direction;
277: ecx_utils.g_procedure_mappings(i).data_type := proc_map.data_type;
278: ecx_utils.g_procedure_mappings(i).variable_constant := proc_map.variable_constant;
279:
280: if(l_statementEnabled) then
273: ecx_utils.g_procedure_mappings(i).variable_level := proc_map.variable_level;
274: ecx_utils.g_procedure_mappings(i).variable_name := proc_map.variable_name;
275: ecx_utils.g_procedure_mappings(i).variable_pos := proc_map.variable_pos;
276: ecx_utils.g_procedure_mappings(i).variable_direction := proc_map.variable_direction;
277: ecx_utils.g_procedure_mappings(i).data_type := proc_map.data_type;
278: ecx_utils.g_procedure_mappings(i).variable_constant := proc_map.variable_constant;
279:
280: if(l_statementEnabled) then
281: ecx_debug.log(l_statement, ecx_utils.g_procedure_mappings(i).tranStage_id ||'|'||
274: ecx_utils.g_procedure_mappings(i).variable_name := proc_map.variable_name;
275: ecx_utils.g_procedure_mappings(i).variable_pos := proc_map.variable_pos;
276: ecx_utils.g_procedure_mappings(i).variable_direction := proc_map.variable_direction;
277: ecx_utils.g_procedure_mappings(i).data_type := proc_map.data_type;
278: ecx_utils.g_procedure_mappings(i).variable_constant := proc_map.variable_constant;
279:
280: if(l_statementEnabled) then
281: ecx_debug.log(l_statement, ecx_utils.g_procedure_mappings(i).tranStage_id ||'|'||
282: ecx_utils.g_procedure_mappings(i).procedure_name||'|'||
277: ecx_utils.g_procedure_mappings(i).data_type := proc_map.data_type;
278: ecx_utils.g_procedure_mappings(i).variable_constant := proc_map.variable_constant;
279:
280: if(l_statementEnabled) then
281: ecx_debug.log(l_statement, ecx_utils.g_procedure_mappings(i).tranStage_id ||'|'||
282: ecx_utils.g_procedure_mappings(i).procedure_name||'|'||
283: ecx_utils.g_procedure_mappings(i).parameter_name||'|'||
284: ecx_utils.g_procedure_mappings(i).action_type||'|'||
285: ecx_utils.g_procedure_mappings(i).variable_level||'|'||
278: ecx_utils.g_procedure_mappings(i).variable_constant := proc_map.variable_constant;
279:
280: if(l_statementEnabled) then
281: ecx_debug.log(l_statement, ecx_utils.g_procedure_mappings(i).tranStage_id ||'|'||
282: ecx_utils.g_procedure_mappings(i).procedure_name||'|'||
283: ecx_utils.g_procedure_mappings(i).parameter_name||'|'||
284: ecx_utils.g_procedure_mappings(i).action_type||'|'||
285: ecx_utils.g_procedure_mappings(i).variable_level||'|'||
286: ecx_utils.g_procedure_mappings(i).variable_name||'|'||
279:
280: if(l_statementEnabled) then
281: ecx_debug.log(l_statement, ecx_utils.g_procedure_mappings(i).tranStage_id ||'|'||
282: ecx_utils.g_procedure_mappings(i).procedure_name||'|'||
283: ecx_utils.g_procedure_mappings(i).parameter_name||'|'||
284: ecx_utils.g_procedure_mappings(i).action_type||'|'||
285: ecx_utils.g_procedure_mappings(i).variable_level||'|'||
286: ecx_utils.g_procedure_mappings(i).variable_name||'|'||
287: ecx_utils.g_procedure_mappings(i).variable_pos ||'|'||
280: if(l_statementEnabled) then
281: ecx_debug.log(l_statement, ecx_utils.g_procedure_mappings(i).tranStage_id ||'|'||
282: ecx_utils.g_procedure_mappings(i).procedure_name||'|'||
283: ecx_utils.g_procedure_mappings(i).parameter_name||'|'||
284: ecx_utils.g_procedure_mappings(i).action_type||'|'||
285: ecx_utils.g_procedure_mappings(i).variable_level||'|'||
286: ecx_utils.g_procedure_mappings(i).variable_name||'|'||
287: ecx_utils.g_procedure_mappings(i).variable_pos ||'|'||
288: ecx_utils.g_procedure_mappings(i).variable_direction ||'|'||
281: ecx_debug.log(l_statement, ecx_utils.g_procedure_mappings(i).tranStage_id ||'|'||
282: ecx_utils.g_procedure_mappings(i).procedure_name||'|'||
283: ecx_utils.g_procedure_mappings(i).parameter_name||'|'||
284: ecx_utils.g_procedure_mappings(i).action_type||'|'||
285: ecx_utils.g_procedure_mappings(i).variable_level||'|'||
286: ecx_utils.g_procedure_mappings(i).variable_name||'|'||
287: ecx_utils.g_procedure_mappings(i).variable_pos ||'|'||
288: ecx_utils.g_procedure_mappings(i).variable_direction ||'|'||
289: ecx_utils.g_procedure_mappings(i).data_type||'|'||
282: ecx_utils.g_procedure_mappings(i).procedure_name||'|'||
283: ecx_utils.g_procedure_mappings(i).parameter_name||'|'||
284: ecx_utils.g_procedure_mappings(i).action_type||'|'||
285: ecx_utils.g_procedure_mappings(i).variable_level||'|'||
286: ecx_utils.g_procedure_mappings(i).variable_name||'|'||
287: ecx_utils.g_procedure_mappings(i).variable_pos ||'|'||
288: ecx_utils.g_procedure_mappings(i).variable_direction ||'|'||
289: ecx_utils.g_procedure_mappings(i).data_type||'|'||
290: ecx_utils.g_procedure_mappings(i).variable_constant,i_method_name);
283: ecx_utils.g_procedure_mappings(i).parameter_name||'|'||
284: ecx_utils.g_procedure_mappings(i).action_type||'|'||
285: ecx_utils.g_procedure_mappings(i).variable_level||'|'||
286: ecx_utils.g_procedure_mappings(i).variable_name||'|'||
287: ecx_utils.g_procedure_mappings(i).variable_pos ||'|'||
288: ecx_utils.g_procedure_mappings(i).variable_direction ||'|'||
289: ecx_utils.g_procedure_mappings(i).data_type||'|'||
290: ecx_utils.g_procedure_mappings(i).variable_constant,i_method_name);
291: end if;
284: ecx_utils.g_procedure_mappings(i).action_type||'|'||
285: ecx_utils.g_procedure_mappings(i).variable_level||'|'||
286: ecx_utils.g_procedure_mappings(i).variable_name||'|'||
287: ecx_utils.g_procedure_mappings(i).variable_pos ||'|'||
288: ecx_utils.g_procedure_mappings(i).variable_direction ||'|'||
289: ecx_utils.g_procedure_mappings(i).data_type||'|'||
290: ecx_utils.g_procedure_mappings(i).variable_constant,i_method_name);
291: end if;
292: end loop;
285: ecx_utils.g_procedure_mappings(i).variable_level||'|'||
286: ecx_utils.g_procedure_mappings(i).variable_name||'|'||
287: ecx_utils.g_procedure_mappings(i).variable_pos ||'|'||
288: ecx_utils.g_procedure_mappings(i).variable_direction ||'|'||
289: ecx_utils.g_procedure_mappings(i).data_type||'|'||
290: ecx_utils.g_procedure_mappings(i).variable_constant,i_method_name);
291: end if;
292: end loop;
293:
286: ecx_utils.g_procedure_mappings(i).variable_name||'|'||
287: ecx_utils.g_procedure_mappings(i).variable_pos ||'|'||
288: ecx_utils.g_procedure_mappings(i).variable_direction ||'|'||
289: ecx_utils.g_procedure_mappings(i).data_type||'|'||
290: ecx_utils.g_procedure_mappings(i).variable_constant,i_method_name);
291: end if;
292: end loop;
293:
294: if (l_procedureEnabled) then
305:
306: WHEN OTHERS THEN
307: if(l_unexpectedEnabled) then
308: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR','PROGRESS_LEVEL',i_method_name,
309: 'ecx_utils.LOAD_PROCEDURE_MAPPINGS');
310: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
311: ecx_debug.log(l_unexpected, 'ECX',
312: ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.LOAD_PROCEDURE_MAPPINGS: ',
313: i_method_name);
308: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR','PROGRESS_LEVEL',i_method_name,
309: 'ecx_utils.LOAD_PROCEDURE_MAPPINGS');
310: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
311: ecx_debug.log(l_unexpected, 'ECX',
312: ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.LOAD_PROCEDURE_MAPPINGS: ',
313: i_method_name);
314: end if;
315: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM ||
316: ' - ecx_utils.LOAD_PROCEDURE_MAPPINGS: ');
311: ecx_debug.log(l_unexpected, 'ECX',
312: ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.LOAD_PROCEDURE_MAPPINGS: ',
313: i_method_name);
314: end if;
315: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM ||
316: ' - ecx_utils.LOAD_PROCEDURE_MAPPINGS: ');
317: if (l_procedureEnabled) then
318: ecx_debug.pop(i_method_name);
319: end if;
312: ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.LOAD_PROCEDURE_MAPPINGS: ',
313: i_method_name);
314: end if;
315: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM ||
316: ' - ecx_utils.LOAD_PROCEDURE_MAPPINGS: ');
317: if (l_procedureEnabled) then
318: ecx_debug.pop(i_method_name);
319: end if;
320: raise PROGRAM_EXIT;
322:
323: procedure load_procedure_definitions (
324: i_map_id IN pls_integer) IS
325:
326: i_method_name varchar2(2000) := 'ecx_utils.load_procedure_definitions';
327: cursor proc_definition is
328: select transtage_id,
329: custom_procedure_name
330: from ecx_tran_stage_data etsd
338: if (l_procedureEnabled) then
339: ecx_debug.push(i_method_name);
340: end if;
341:
342: ecx_utils.g_procedure_list.DELETE;
343: -- load all the procedure definitions and build the cursor
344: for get_proc_def in proc_definition loop
345: l_transtage_id := get_proc_def.transtage_id;
346: l_proc_name := upper(get_proc_def.custom_procedure_name);
344: for get_proc_def in proc_definition loop
345: l_transtage_id := get_proc_def.transtage_id;
346: l_proc_name := upper(get_proc_def.custom_procedure_name);
347:
348: ecx_utils.g_procedure_list(l_transtage_id).procedure_name := l_proc_name;
349: build_procedure_call (l_transtage_id, l_proc_name,
350: ecx_utils.g_procedure_list(l_transtage_id).cursor_handle);
351: end loop;
352:
346: l_proc_name := upper(get_proc_def.custom_procedure_name);
347:
348: ecx_utils.g_procedure_list(l_transtage_id).procedure_name := l_proc_name;
349: build_procedure_call (l_transtage_id, l_proc_name,
350: ecx_utils.g_procedure_list(l_transtage_id).cursor_handle);
351: end loop;
352:
353: if (l_procedureEnabled) then
354: ecx_debug.pop(i_method_name);
364: WHEN OTHERS THEN
365: if(l_unexpectedEnabled) then
366: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
367: 'PROGRESS_LEVEL',
368: 'ecx_utils.LOAD_PROCEDURE_DEFINITIONS');
369: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
370: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.LOAD_PROCEDURE_DEFINITIONS:',
371: i_method_name);
372: end if;
366: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
367: 'PROGRESS_LEVEL',
368: 'ecx_utils.LOAD_PROCEDURE_DEFINITIONS');
369: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
370: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.LOAD_PROCEDURE_DEFINITIONS:',
371: i_method_name);
372: end if;
373: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM ||
374: ' - ecx_utils.LOAD_PROCEDURE_DEFINITIONS: ');
369: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
370: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.LOAD_PROCEDURE_DEFINITIONS:',
371: i_method_name);
372: end if;
373: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM ||
374: ' - ecx_utils.LOAD_PROCEDURE_DEFINITIONS: ');
375: if (l_procedureEnabled) then
376: ecx_debug.pop(i_method_name);
377: end if;
370: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.LOAD_PROCEDURE_DEFINITIONS:',
371: i_method_name);
372: end if;
373: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM ||
374: ' - ecx_utils.LOAD_PROCEDURE_DEFINITIONS: ');
375: if (l_procedureEnabled) then
376: ecx_debug.pop(i_method_name);
377: end if;
378: raise PROGRAM_EXIT;
384: p_transtage_id IN pls_integer,
385: p_procedure_name IN Varchar2,
386: x_proc_cursor OUT NOCOPY pls_integer) IS
387:
388: i_method_name varchar2(2000) := 'ecx_utils.build_procedure_call';
389: error_position pls_integer;
390: l_proc_call Varchar2(32000);
391: l_first_param Boolean := True;
392: parse_error EXCEPTION;
400: ecx_debug.log(l_statement,'p_procedure_name',p_procedure_name,i_method_name);
401: end if;
402: l_proc_call := 'BEGIN ' || p_procedure_name || '(';
403:
404: if (ecx_utils.g_procedure_mappings.count <> 0)
405: then
406: for i in ecx_utils.g_procedure_mappings.first..ecx_utils.g_procedure_mappings.last
407: loop
408: if (ecx_utils.g_procedure_mappings(i).transtage_id = p_transtage_id) and
402: l_proc_call := 'BEGIN ' || p_procedure_name || '(';
403:
404: if (ecx_utils.g_procedure_mappings.count <> 0)
405: then
406: for i in ecx_utils.g_procedure_mappings.first..ecx_utils.g_procedure_mappings.last
407: loop
408: if (ecx_utils.g_procedure_mappings(i).transtage_id = p_transtage_id) and
409: (ecx_utils.g_procedure_mappings(i).procedure_name = p_procedure_name) then
410:
404: if (ecx_utils.g_procedure_mappings.count <> 0)
405: then
406: for i in ecx_utils.g_procedure_mappings.first..ecx_utils.g_procedure_mappings.last
407: loop
408: if (ecx_utils.g_procedure_mappings(i).transtage_id = p_transtage_id) and
409: (ecx_utils.g_procedure_mappings(i).procedure_name = p_procedure_name) then
410:
411: if not (l_first_param) then
412: l_proc_call := l_proc_call || ', ';
405: then
406: for i in ecx_utils.g_procedure_mappings.first..ecx_utils.g_procedure_mappings.last
407: loop
408: if (ecx_utils.g_procedure_mappings(i).transtage_id = p_transtage_id) and
409: (ecx_utils.g_procedure_mappings(i).procedure_name = p_procedure_name) then
410:
411: if not (l_first_param) then
412: l_proc_call := l_proc_call || ', ';
413: else
413: else
414: l_first_param := false;
415: end if;
416:
417: l_proc_call := l_proc_call || ecx_utils.g_procedure_mappings(i).parameter_name ||
418: ' => :' || ecx_utils.g_procedure_mappings(i).parameter_name;
419: end if;
420: end loop;
421: end if;
414: l_first_param := false;
415: end if;
416:
417: l_proc_call := l_proc_call || ecx_utils.g_procedure_mappings(i).parameter_name ||
418: ' => :' || ecx_utils.g_procedure_mappings(i).parameter_name;
419: end if;
420: end loop;
421: end if;
422:
420: end loop;
421: end if;
422:
423: l_proc_call := l_proc_call || '); END;';
424: ecx_utils.g_procedure_list(p_transtage_id).procedure_call := l_proc_call;
425:
426: for i in ecx_utils.g_procedure_list.first..ecx_utils.g_procedure_list.last-1
427: loop
428: if(ecx_utils.g_procedure_list.EXISTS(i) and ecx_utils.g_procedure_list(i).procedure_call = l_proc_call) then
422:
423: l_proc_call := l_proc_call || '); END;';
424: ecx_utils.g_procedure_list(p_transtage_id).procedure_call := l_proc_call;
425:
426: for i in ecx_utils.g_procedure_list.first..ecx_utils.g_procedure_list.last-1
427: loop
428: if(ecx_utils.g_procedure_list.EXISTS(i) and ecx_utils.g_procedure_list(i).procedure_call = l_proc_call) then
429: x_proc_cursor := ecx_utils.g_procedure_list(i).cursor_handle;
430: if(l_statementEnabled) then
424: ecx_utils.g_procedure_list(p_transtage_id).procedure_call := l_proc_call;
425:
426: for i in ecx_utils.g_procedure_list.first..ecx_utils.g_procedure_list.last-1
427: loop
428: if(ecx_utils.g_procedure_list.EXISTS(i) and ecx_utils.g_procedure_list(i).procedure_call = l_proc_call) then
429: x_proc_cursor := ecx_utils.g_procedure_list(i).cursor_handle;
430: if(l_statementEnabled) then
431: ecx_debug.log(l_statement, 'proc_call', l_proc_call,i_method_name);
432: ecx_debug.log(l_statement,'x_proc_cursor',x_proc_cursor,i_method_name);
425:
426: for i in ecx_utils.g_procedure_list.first..ecx_utils.g_procedure_list.last-1
427: loop
428: if(ecx_utils.g_procedure_list.EXISTS(i) and ecx_utils.g_procedure_list(i).procedure_call = l_proc_call) then
429: x_proc_cursor := ecx_utils.g_procedure_list(i).cursor_handle;
430: if(l_statementEnabled) then
431: ecx_debug.log(l_statement, 'proc_call', l_proc_call,i_method_name);
432: ecx_debug.log(l_statement,'x_proc_cursor',x_proc_cursor,i_method_name);
433: end if;
458: error_position := dbms_sql.last_error_position;
459: ecx_error_handling_pvt.print_parse_error (error_position, l_proc_call);
460: if(l_unexpectedEnabled) then
461: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
462: 'PROGRESS_LEVEL','ecx_utils.BUILD_PROCEDURE_CALL');
463: ecx_debug.log(l_unexpected, 'ECX', 'ECX_PARSE_ERROR', i_method_name);
464: end if;
465: ecx_debug.setErrorInfo(1, 25, 'ECX_PARSE_ERROR');
466: if (l_procedureEnabled) then
476:
477: WHEN OTHERS THEN
478: if(l_statementEnabled) then
479: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
480: 'PROGRESS_LEVEL','ecx_utils.BUILD_PROCEDURE_CALL');
481: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
482: 'ERROR_MESSAGE',SQLERRM);
483: ecx_debug.log(l_unexpected, 'ECX',
484: ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.BUILD_PROCEDURE_CALL: ',
480: 'PROGRESS_LEVEL','ecx_utils.BUILD_PROCEDURE_CALL');
481: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,
482: 'ERROR_MESSAGE',SQLERRM);
483: ecx_debug.log(l_unexpected, 'ECX',
484: ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.BUILD_PROCEDURE_CALL: ',
485: i_method_name);
486: end if;
487: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.BUILD_PROCEDURE_CALL: ');
488:
483: ecx_debug.log(l_unexpected, 'ECX',
484: ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.BUILD_PROCEDURE_CALL: ',
485: i_method_name);
486: end if;
487: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.BUILD_PROCEDURE_CALL: ');
488:
489: if (l_procedureEnabled) then
490: ecx_debug.pop(i_method_name);
491: end if;
498: i in pls_integer,
499: g_source IN dtd_node_tbl
500: )
501: is
502: i_method_name varchar2(2000) := 'ecx_utils.print_nodes';
503: begin
504: if (g_source.EXISTS(i))
505: then
506:
532: i_object_level IN pls_integer,
533: g_tbl IN OUT NOCOPY dtd_node_tbl,
534: g_level IN OUT NOCOPY level_tbl
535: ) is
536: i_method_name varchar2(2000) := 'ecx_utils.load_attributes';
537:
538: /* TYPE object_record is RECORD
539: (
540: attribute_id ecx_object_attributes.attribute_id%TYPE,
789: WHEN OTHERS THEN
790: if(l_unexpectedEnabled) then
791: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
792: 'PROGRESS_LEVEL',
793: 'ECX_UTILS.LOAD_ATTRIBUTES');
794: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
795: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.LOAD_ATTRIBUTES: ',
796: i_method_name);
797: end if;
791: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
792: 'PROGRESS_LEVEL',
793: 'ECX_UTILS.LOAD_ATTRIBUTES');
794: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
795: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.LOAD_ATTRIBUTES: ',
796: i_method_name);
797: end if;
798: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.LOAD_ATTRIBUTES: ');
799: if (l_procedureEnabled) then
794: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
795: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.LOAD_ATTRIBUTES: ',
796: i_method_name);
797: end if;
798: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.LOAD_ATTRIBUTES: ');
799: if (l_procedureEnabled) then
800: ecx_debug.pop(i_method_name);
801: end if;
802: raise PROGRAM_EXIT;
808: i_level_id IN pls_integer,
809: i_object_level IN pls_integer,
810: i_source IN boolean) IS
811:
812: i_method_name varchar2(2000) := 'ecx_utils.load_dtd_nodes';
813: l_dtd_id pls_integer;
814: l_map_type Varchar2(20);
815: i pls_integer := 0;
816: j pls_integer;
829: end if;
830:
831: if ( i_source )
832: then
833: load_attributes(i_map_id,i_level_id,i_object_level,ecx_utils.g_source,ecx_utils.g_source_levels);
834: else
835: load_attributes(i_map_id,i_level_id,i_object_level,ecx_utils.g_target,ecx_utils.g_target_levels);
836: end if;
837:
831: if ( i_source )
832: then
833: load_attributes(i_map_id,i_level_id,i_object_level,ecx_utils.g_source,ecx_utils.g_source_levels);
834: else
835: load_attributes(i_map_id,i_level_id,i_object_level,ecx_utils.g_target,ecx_utils.g_target_levels);
836: end if;
837:
838: if (l_procedureEnabled) then
839: ecx_debug.pop(i_method_name);
851: end if;
852: raise PROGRAM_EXIT;
853:
854: WHEN PROGRAM_EXIT then
855: ecx_debug.pop('ECX_UTILS.LOAD_DTD_NODES');
856: raise;
857: WHEN OTHERS THEN
858: if(l_unexpectedEnabled) then
859: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
857: WHEN OTHERS THEN
858: if(l_unexpectedEnabled) then
859: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
860: 'PROGRESS_LEVEL',
861: 'ECX_UTILS.LOAD_DTD_NODES');
862: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.LOAD_DTD_NODES',
863: i_method_name);
864: end if;
865: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.LOAD_DTD_NODES');
858: if(l_unexpectedEnabled) then
859: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,
860: 'PROGRESS_LEVEL',
861: 'ECX_UTILS.LOAD_DTD_NODES');
862: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.LOAD_DTD_NODES',
863: i_method_name);
864: end if;
865: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.LOAD_DTD_NODES');
866:
861: 'ECX_UTILS.LOAD_DTD_NODES');
862: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.LOAD_DTD_NODES',
863: i_method_name);
864: end if;
865: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.LOAD_DTD_NODES');
866:
867: if (l_procedureEnabled) then
868: ecx_debug.pop(i_method_name);
869: end if;
896: --dummy data for g_source_levels can be gotten from ecx_object_levels
897: for c_level_zero in get_level_zero(p_map_id=>g_map_id)
898: loop
899: -- should return only one match
900: ecx_utils.g_source_levels(0).level := c_level_zero.object_level;
901: ecx_utils.g_source_levels(0).parent_level := c_level_zero.parent_level;
902: ecx_utils.g_source_levels(0).start_element := c_level_zero.object_level_name;
903: ecx_utils.g_source_levels(0).base_table_name := c_level_zero.object_level_name;
904: ecx_utils.g_source_levels(0).sql_stmt := NULL;
897: for c_level_zero in get_level_zero(p_map_id=>g_map_id)
898: loop
899: -- should return only one match
900: ecx_utils.g_source_levels(0).level := c_level_zero.object_level;
901: ecx_utils.g_source_levels(0).parent_level := c_level_zero.parent_level;
902: ecx_utils.g_source_levels(0).start_element := c_level_zero.object_level_name;
903: ecx_utils.g_source_levels(0).base_table_name := c_level_zero.object_level_name;
904: ecx_utils.g_source_levels(0).sql_stmt := NULL;
905: ecx_utils.g_source_levels(0).cursor_handle := null;
898: loop
899: -- should return only one match
900: ecx_utils.g_source_levels(0).level := c_level_zero.object_level;
901: ecx_utils.g_source_levels(0).parent_level := c_level_zero.parent_level;
902: ecx_utils.g_source_levels(0).start_element := c_level_zero.object_level_name;
903: ecx_utils.g_source_levels(0).base_table_name := c_level_zero.object_level_name;
904: ecx_utils.g_source_levels(0).sql_stmt := NULL;
905: ecx_utils.g_source_levels(0).cursor_handle := null;
906: ecx_utils.g_source_levels(0).file_start_pos := 0;
899: -- should return only one match
900: ecx_utils.g_source_levels(0).level := c_level_zero.object_level;
901: ecx_utils.g_source_levels(0).parent_level := c_level_zero.parent_level;
902: ecx_utils.g_source_levels(0).start_element := c_level_zero.object_level_name;
903: ecx_utils.g_source_levels(0).base_table_name := c_level_zero.object_level_name;
904: ecx_utils.g_source_levels(0).sql_stmt := NULL;
905: ecx_utils.g_source_levels(0).cursor_handle := null;
906: ecx_utils.g_source_levels(0).file_start_pos := 0;
907: ecx_utils.g_source_levels(0).file_end_pos := 0;
900: ecx_utils.g_source_levels(0).level := c_level_zero.object_level;
901: ecx_utils.g_source_levels(0).parent_level := c_level_zero.parent_level;
902: ecx_utils.g_source_levels(0).start_element := c_level_zero.object_level_name;
903: ecx_utils.g_source_levels(0).base_table_name := c_level_zero.object_level_name;
904: ecx_utils.g_source_levels(0).sql_stmt := NULL;
905: ecx_utils.g_source_levels(0).cursor_handle := null;
906: ecx_utils.g_source_levels(0).file_start_pos := 0;
907: ecx_utils.g_source_levels(0).file_end_pos := 0;
908: ecx_utils.g_source_levels(0).dtd_node_index := 0;
901: ecx_utils.g_source_levels(0).parent_level := c_level_zero.parent_level;
902: ecx_utils.g_source_levels(0).start_element := c_level_zero.object_level_name;
903: ecx_utils.g_source_levels(0).base_table_name := c_level_zero.object_level_name;
904: ecx_utils.g_source_levels(0).sql_stmt := NULL;
905: ecx_utils.g_source_levels(0).cursor_handle := null;
906: ecx_utils.g_source_levels(0).file_start_pos := 0;
907: ecx_utils.g_source_levels(0).file_end_pos := 0;
908: ecx_utils.g_source_levels(0).dtd_node_index := 0;
909: end loop;
902: ecx_utils.g_source_levels(0).start_element := c_level_zero.object_level_name;
903: ecx_utils.g_source_levels(0).base_table_name := c_level_zero.object_level_name;
904: ecx_utils.g_source_levels(0).sql_stmt := NULL;
905: ecx_utils.g_source_levels(0).cursor_handle := null;
906: ecx_utils.g_source_levels(0).file_start_pos := 0;
907: ecx_utils.g_source_levels(0).file_end_pos := 0;
908: ecx_utils.g_source_levels(0).dtd_node_index := 0;
909: end loop;
910:
903: ecx_utils.g_source_levels(0).base_table_name := c_level_zero.object_level_name;
904: ecx_utils.g_source_levels(0).sql_stmt := NULL;
905: ecx_utils.g_source_levels(0).cursor_handle := null;
906: ecx_utils.g_source_levels(0).file_start_pos := 0;
907: ecx_utils.g_source_levels(0).file_end_pos := 0;
908: ecx_utils.g_source_levels(0).dtd_node_index := 0;
909: end loop;
910:
911: ecx_utils.g_source(0).attribute_id := 0;
904: ecx_utils.g_source_levels(0).sql_stmt := NULL;
905: ecx_utils.g_source_levels(0).cursor_handle := null;
906: ecx_utils.g_source_levels(0).file_start_pos := 0;
907: ecx_utils.g_source_levels(0).file_end_pos := 0;
908: ecx_utils.g_source_levels(0).dtd_node_index := 0;
909: end loop;
910:
911: ecx_utils.g_source(0).attribute_id := 0;
912: ecx_utils.g_source(0).attribute_name := ecx_utils.g_source_levels(0).start_element;
907: ecx_utils.g_source_levels(0).file_end_pos := 0;
908: ecx_utils.g_source_levels(0).dtd_node_index := 0;
909: end loop;
910:
911: ecx_utils.g_source(0).attribute_id := 0;
912: ecx_utils.g_source(0).attribute_name := ecx_utils.g_source_levels(0).start_element;
913: ecx_utils.g_source(0).parent_attribute_id := 0;
914: ecx_utils.g_source(0).attribute_type := 1;
915: ecx_utils.g_source(0).default_value := null;
908: ecx_utils.g_source_levels(0).dtd_node_index := 0;
909: end loop;
910:
911: ecx_utils.g_source(0).attribute_id := 0;
912: ecx_utils.g_source(0).attribute_name := ecx_utils.g_source_levels(0).start_element;
913: ecx_utils.g_source(0).parent_attribute_id := 0;
914: ecx_utils.g_source(0).attribute_type := 1;
915: ecx_utils.g_source(0).default_value := null;
916: ecx_utils.g_source(0).data_type := null;
909: end loop;
910:
911: ecx_utils.g_source(0).attribute_id := 0;
912: ecx_utils.g_source(0).attribute_name := ecx_utils.g_source_levels(0).start_element;
913: ecx_utils.g_source(0).parent_attribute_id := 0;
914: ecx_utils.g_source(0).attribute_type := 1;
915: ecx_utils.g_source(0).default_value := null;
916: ecx_utils.g_source(0).data_type := null;
917: ecx_utils.g_source(0).external_level := 0;
910:
911: ecx_utils.g_source(0).attribute_id := 0;
912: ecx_utils.g_source(0).attribute_name := ecx_utils.g_source_levels(0).start_element;
913: ecx_utils.g_source(0).parent_attribute_id := 0;
914: ecx_utils.g_source(0).attribute_type := 1;
915: ecx_utils.g_source(0).default_value := null;
916: ecx_utils.g_source(0).data_type := null;
917: ecx_utils.g_source(0).external_level := 0;
918: ecx_utils.g_source(0).internal_level := 0;
911: ecx_utils.g_source(0).attribute_id := 0;
912: ecx_utils.g_source(0).attribute_name := ecx_utils.g_source_levels(0).start_element;
913: ecx_utils.g_source(0).parent_attribute_id := 0;
914: ecx_utils.g_source(0).attribute_type := 1;
915: ecx_utils.g_source(0).default_value := null;
916: ecx_utils.g_source(0).data_type := null;
917: ecx_utils.g_source(0).external_level := 0;
918: ecx_utils.g_source(0).internal_level := 0;
919: ecx_utils.g_source(0).has_attributes := 0;
912: ecx_utils.g_source(0).attribute_name := ecx_utils.g_source_levels(0).start_element;
913: ecx_utils.g_source(0).parent_attribute_id := 0;
914: ecx_utils.g_source(0).attribute_type := 1;
915: ecx_utils.g_source(0).default_value := null;
916: ecx_utils.g_source(0).data_type := null;
917: ecx_utils.g_source(0).external_level := 0;
918: ecx_utils.g_source(0).internal_level := 0;
919: ecx_utils.g_source(0).has_attributes := 0;
920: ecx_utils.g_source(0).leaf_node := 0;
913: ecx_utils.g_source(0).parent_attribute_id := 0;
914: ecx_utils.g_source(0).attribute_type := 1;
915: ecx_utils.g_source(0).default_value := null;
916: ecx_utils.g_source(0).data_type := null;
917: ecx_utils.g_source(0).external_level := 0;
918: ecx_utils.g_source(0).internal_level := 0;
919: ecx_utils.g_source(0).has_attributes := 0;
920: ecx_utils.g_source(0).leaf_node := 0;
921:
914: ecx_utils.g_source(0).attribute_type := 1;
915: ecx_utils.g_source(0).default_value := null;
916: ecx_utils.g_source(0).data_type := null;
917: ecx_utils.g_source(0).external_level := 0;
918: ecx_utils.g_source(0).internal_level := 0;
919: ecx_utils.g_source(0).has_attributes := 0;
920: ecx_utils.g_source(0).leaf_node := 0;
921:
922: -- load all level 0 attributes
915: ecx_utils.g_source(0).default_value := null;
916: ecx_utils.g_source(0).data_type := null;
917: ecx_utils.g_source(0).external_level := 0;
918: ecx_utils.g_source(0).internal_level := 0;
919: ecx_utils.g_source(0).has_attributes := 0;
920: ecx_utils.g_source(0).leaf_node := 0;
921:
922: -- load all level 0 attributes
923: load_dtd_nodes( g_map_id,0, 0,true);
916: ecx_utils.g_source(0).data_type := null;
917: ecx_utils.g_source(0).external_level := 0;
918: ecx_utils.g_source(0).internal_level := 0;
919: ecx_utils.g_source(0).has_attributes := 0;
920: ecx_utils.g_source(0).leaf_node := 0;
921:
922: -- load all level 0 attributes
923: load_dtd_nodes( g_map_id,0, 0,true);
924:
921:
922: -- load all level 0 attributes
923: load_dtd_nodes( g_map_id,0, 0,true);
924:
925: ecx_utils.g_target(0).attribute_id := 0;
926: ecx_utils.g_target(0).attribute_name := ecx_utils.g_target_levels(0).start_element;
927: ecx_utils.g_target(0).parent_attribute_id := 0;
928: ecx_utils.g_target(0).attribute_type := 1;
929: ecx_utils.g_target(0).default_value := null;
922: -- load all level 0 attributes
923: load_dtd_nodes( g_map_id,0, 0,true);
924:
925: ecx_utils.g_target(0).attribute_id := 0;
926: ecx_utils.g_target(0).attribute_name := ecx_utils.g_target_levels(0).start_element;
927: ecx_utils.g_target(0).parent_attribute_id := 0;
928: ecx_utils.g_target(0).attribute_type := 1;
929: ecx_utils.g_target(0).default_value := null;
930: ecx_utils.g_target(0).data_type := null;
923: load_dtd_nodes( g_map_id,0, 0,true);
924:
925: ecx_utils.g_target(0).attribute_id := 0;
926: ecx_utils.g_target(0).attribute_name := ecx_utils.g_target_levels(0).start_element;
927: ecx_utils.g_target(0).parent_attribute_id := 0;
928: ecx_utils.g_target(0).attribute_type := 1;
929: ecx_utils.g_target(0).default_value := null;
930: ecx_utils.g_target(0).data_type := null;
931: ecx_utils.g_target(0).external_level := 0;
924:
925: ecx_utils.g_target(0).attribute_id := 0;
926: ecx_utils.g_target(0).attribute_name := ecx_utils.g_target_levels(0).start_element;
927: ecx_utils.g_target(0).parent_attribute_id := 0;
928: ecx_utils.g_target(0).attribute_type := 1;
929: ecx_utils.g_target(0).default_value := null;
930: ecx_utils.g_target(0).data_type := null;
931: ecx_utils.g_target(0).external_level := 0;
932: ecx_utils.g_target(0).internal_level := 0;
925: ecx_utils.g_target(0).attribute_id := 0;
926: ecx_utils.g_target(0).attribute_name := ecx_utils.g_target_levels(0).start_element;
927: ecx_utils.g_target(0).parent_attribute_id := 0;
928: ecx_utils.g_target(0).attribute_type := 1;
929: ecx_utils.g_target(0).default_value := null;
930: ecx_utils.g_target(0).data_type := null;
931: ecx_utils.g_target(0).external_level := 0;
932: ecx_utils.g_target(0).internal_level := 0;
933: ecx_utils.g_target(0).has_attributes := 0;
926: ecx_utils.g_target(0).attribute_name := ecx_utils.g_target_levels(0).start_element;
927: ecx_utils.g_target(0).parent_attribute_id := 0;
928: ecx_utils.g_target(0).attribute_type := 1;
929: ecx_utils.g_target(0).default_value := null;
930: ecx_utils.g_target(0).data_type := null;
931: ecx_utils.g_target(0).external_level := 0;
932: ecx_utils.g_target(0).internal_level := 0;
933: ecx_utils.g_target(0).has_attributes := 0;
934: ecx_utils.g_target(0).leaf_node := 0;
927: ecx_utils.g_target(0).parent_attribute_id := 0;
928: ecx_utils.g_target(0).attribute_type := 1;
929: ecx_utils.g_target(0).default_value := null;
930: ecx_utils.g_target(0).data_type := null;
931: ecx_utils.g_target(0).external_level := 0;
932: ecx_utils.g_target(0).internal_level := 0;
933: ecx_utils.g_target(0).has_attributes := 0;
934: ecx_utils.g_target(0).leaf_node := 0;
935:
928: ecx_utils.g_target(0).attribute_type := 1;
929: ecx_utils.g_target(0).default_value := null;
930: ecx_utils.g_target(0).data_type := null;
931: ecx_utils.g_target(0).external_level := 0;
932: ecx_utils.g_target(0).internal_level := 0;
933: ecx_utils.g_target(0).has_attributes := 0;
934: ecx_utils.g_target(0).leaf_node := 0;
935:
936: ecx_utils.g_target_source_levels(0).source_level := 0;
929: ecx_utils.g_target(0).default_value := null;
930: ecx_utils.g_target(0).data_type := null;
931: ecx_utils.g_target(0).external_level := 0;
932: ecx_utils.g_target(0).internal_level := 0;
933: ecx_utils.g_target(0).has_attributes := 0;
934: ecx_utils.g_target(0).leaf_node := 0;
935:
936: ecx_utils.g_target_source_levels(0).source_level := 0;
937: ecx_utils.g_target_source_levels(0).target_level := 0;
930: ecx_utils.g_target(0).data_type := null;
931: ecx_utils.g_target(0).external_level := 0;
932: ecx_utils.g_target(0).internal_level := 0;
933: ecx_utils.g_target(0).has_attributes := 0;
934: ecx_utils.g_target(0).leaf_node := 0;
935:
936: ecx_utils.g_target_source_levels(0).source_level := 0;
937: ecx_utils.g_target_source_levels(0).target_level := 0;
938:
932: ecx_utils.g_target(0).internal_level := 0;
933: ecx_utils.g_target(0).has_attributes := 0;
934: ecx_utils.g_target(0).leaf_node := 0;
935:
936: ecx_utils.g_target_source_levels(0).source_level := 0;
937: ecx_utils.g_target_source_levels(0).target_level := 0;
938:
939: root_level_found := TRUE;
940: end createDummyData;
933: ecx_utils.g_target(0).has_attributes := 0;
934: ecx_utils.g_target(0).leaf_node := 0;
935:
936: ecx_utils.g_target_source_levels(0).source_level := 0;
937: ecx_utils.g_target_source_levels(0).target_level := 0;
938:
939: root_level_found := TRUE;
940: end createDummyData;
941:
942:
943: procedure load_mappings (
944: i_map_id in pls_integer) IS
945:
946: i_method_name varchar2(2000) := 'ecx_utils.load_mappings';
947:
948: /* TYPE target_record
949: is RECORD (target_level_id ecx_object_levels.objectlevel_id%TYPE,
950: target_level ecx_object_levels.object_level%TYPE,
1059: if(l_statementEnabled) then
1060: ecx_debug.log(l_statement,'i_map_id',i_map_id,i_method_name);
1061: end if;
1062:
1063: ecx_utils.g_source_levels.DELETE;
1064: ecx_utils.g_target_levels.DELETE;
1065: ecx_utils.g_target_source_levels.DELETE;
1066: ecx_utils.g_target.DELETE;
1067: ecx_utils.g_source.DELETE;
1060: ecx_debug.log(l_statement,'i_map_id',i_map_id,i_method_name);
1061: end if;
1062:
1063: ecx_utils.g_source_levels.DELETE;
1064: ecx_utils.g_target_levels.DELETE;
1065: ecx_utils.g_target_source_levels.DELETE;
1066: ecx_utils.g_target.DELETE;
1067: ecx_utils.g_source.DELETE;
1068: if(l_statementEnabled) then
1061: end if;
1062:
1063: ecx_utils.g_source_levels.DELETE;
1064: ecx_utils.g_target_levels.DELETE;
1065: ecx_utils.g_target_source_levels.DELETE;
1066: ecx_utils.g_target.DELETE;
1067: ecx_utils.g_source.DELETE;
1068: if(l_statementEnabled) then
1069: ecx_debug.log(l_statement,'ECX','ECX_LOADING_LEVELS',i_method_name,
1062:
1063: ecx_utils.g_source_levels.DELETE;
1064: ecx_utils.g_target_levels.DELETE;
1065: ecx_utils.g_target_source_levels.DELETE;
1066: ecx_utils.g_target.DELETE;
1067: ecx_utils.g_source.DELETE;
1068: if(l_statementEnabled) then
1069: ecx_debug.log(l_statement,'ECX','ECX_LOADING_LEVELS',i_method_name,
1070: 'LEVEL','Loading Target levels');
1063: ecx_utils.g_source_levels.DELETE;
1064: ecx_utils.g_target_levels.DELETE;
1065: ecx_utils.g_target_source_levels.DELETE;
1066: ecx_utils.g_target.DELETE;
1067: ecx_utils.g_source.DELETE;
1068: if(l_statementEnabled) then
1069: ecx_debug.log(l_statement,'ECX','ECX_LOADING_LEVELS',i_method_name,
1070: 'LEVEL','Loading Target levels');
1071: end if;
1097: -- for c1 in target_rec ( p_map_id => i_map_id )
1098: loop
1099: -- ecx_debug.log(3,'Target Level Id',targ_rec_table(j).target_level_id||' Target Level =>'||targ_rec_table(j).target_level);
1100: cur_ext_level := v_target_level(j);
1101: ecx_utils.g_target_levels(cur_ext_level).level := cur_ext_level;
1102: ecx_utils.g_target_levels(cur_ext_level).level := v_parent_level(j);
1103: ecx_utils.g_target_levels(cur_ext_level).start_element := v_target_level_name(j);
1104: ecx_utils.g_target_levels(cur_ext_level).base_table_name := v_target_level_name(j);
1105: ecx_utils.g_target_levels(cur_ext_level).sql_stmt := NULL;
1098: loop
1099: -- ecx_debug.log(3,'Target Level Id',targ_rec_table(j).target_level_id||' Target Level =>'||targ_rec_table(j).target_level);
1100: cur_ext_level := v_target_level(j);
1101: ecx_utils.g_target_levels(cur_ext_level).level := cur_ext_level;
1102: ecx_utils.g_target_levels(cur_ext_level).level := v_parent_level(j);
1103: ecx_utils.g_target_levels(cur_ext_level).start_element := v_target_level_name(j);
1104: ecx_utils.g_target_levels(cur_ext_level).base_table_name := v_target_level_name(j);
1105: ecx_utils.g_target_levels(cur_ext_level).sql_stmt := NULL;
1106: ecx_utils.g_target_levels(cur_ext_level).cursor_handle := null;
1099: -- ecx_debug.log(3,'Target Level Id',targ_rec_table(j).target_level_id||' Target Level =>'||targ_rec_table(j).target_level);
1100: cur_ext_level := v_target_level(j);
1101: ecx_utils.g_target_levels(cur_ext_level).level := cur_ext_level;
1102: ecx_utils.g_target_levels(cur_ext_level).level := v_parent_level(j);
1103: ecx_utils.g_target_levels(cur_ext_level).start_element := v_target_level_name(j);
1104: ecx_utils.g_target_levels(cur_ext_level).base_table_name := v_target_level_name(j);
1105: ecx_utils.g_target_levels(cur_ext_level).sql_stmt := NULL;
1106: ecx_utils.g_target_levels(cur_ext_level).cursor_handle := null;
1107: ecx_utils.g_target_levels(cur_ext_level).file_start_pos := 0;
1100: cur_ext_level := v_target_level(j);
1101: ecx_utils.g_target_levels(cur_ext_level).level := cur_ext_level;
1102: ecx_utils.g_target_levels(cur_ext_level).level := v_parent_level(j);
1103: ecx_utils.g_target_levels(cur_ext_level).start_element := v_target_level_name(j);
1104: ecx_utils.g_target_levels(cur_ext_level).base_table_name := v_target_level_name(j);
1105: ecx_utils.g_target_levels(cur_ext_level).sql_stmt := NULL;
1106: ecx_utils.g_target_levels(cur_ext_level).cursor_handle := null;
1107: ecx_utils.g_target_levels(cur_ext_level).file_start_pos := 0;
1108: ecx_utils.g_target_levels(cur_ext_level).file_end_pos := 0;
1101: ecx_utils.g_target_levels(cur_ext_level).level := cur_ext_level;
1102: ecx_utils.g_target_levels(cur_ext_level).level := v_parent_level(j);
1103: ecx_utils.g_target_levels(cur_ext_level).start_element := v_target_level_name(j);
1104: ecx_utils.g_target_levels(cur_ext_level).base_table_name := v_target_level_name(j);
1105: ecx_utils.g_target_levels(cur_ext_level).sql_stmt := NULL;
1106: ecx_utils.g_target_levels(cur_ext_level).cursor_handle := null;
1107: ecx_utils.g_target_levels(cur_ext_level).file_start_pos := 0;
1108: ecx_utils.g_target_levels(cur_ext_level).file_end_pos := 0;
1109: ecx_utils.g_target_levels(cur_ext_level).dtd_node_index := 0;
1102: ecx_utils.g_target_levels(cur_ext_level).level := v_parent_level(j);
1103: ecx_utils.g_target_levels(cur_ext_level).start_element := v_target_level_name(j);
1104: ecx_utils.g_target_levels(cur_ext_level).base_table_name := v_target_level_name(j);
1105: ecx_utils.g_target_levels(cur_ext_level).sql_stmt := NULL;
1106: ecx_utils.g_target_levels(cur_ext_level).cursor_handle := null;
1107: ecx_utils.g_target_levels(cur_ext_level).file_start_pos := 0;
1108: ecx_utils.g_target_levels(cur_ext_level).file_end_pos := 0;
1109: ecx_utils.g_target_levels(cur_ext_level).dtd_node_index := 0;
1110: if(l_statementEnabled) then
1103: ecx_utils.g_target_levels(cur_ext_level).start_element := v_target_level_name(j);
1104: ecx_utils.g_target_levels(cur_ext_level).base_table_name := v_target_level_name(j);
1105: ecx_utils.g_target_levels(cur_ext_level).sql_stmt := NULL;
1106: ecx_utils.g_target_levels(cur_ext_level).cursor_handle := null;
1107: ecx_utils.g_target_levels(cur_ext_level).file_start_pos := 0;
1108: ecx_utils.g_target_levels(cur_ext_level).file_end_pos := 0;
1109: ecx_utils.g_target_levels(cur_ext_level).dtd_node_index := 0;
1110: if(l_statementEnabled) then
1111: ecx_debug.log(l_statement, 'External Level ('|| cur_ext_level||')',
1104: ecx_utils.g_target_levels(cur_ext_level).base_table_name := v_target_level_name(j);
1105: ecx_utils.g_target_levels(cur_ext_level).sql_stmt := NULL;
1106: ecx_utils.g_target_levels(cur_ext_level).cursor_handle := null;
1107: ecx_utils.g_target_levels(cur_ext_level).file_start_pos := 0;
1108: ecx_utils.g_target_levels(cur_ext_level).file_end_pos := 0;
1109: ecx_utils.g_target_levels(cur_ext_level).dtd_node_index := 0;
1110: if(l_statementEnabled) then
1111: ecx_debug.log(l_statement, 'External Level ('|| cur_ext_level||')',
1112: ecx_utils.g_target_levels(cur_ext_level).level,i_method_name);
1105: ecx_utils.g_target_levels(cur_ext_level).sql_stmt := NULL;
1106: ecx_utils.g_target_levels(cur_ext_level).cursor_handle := null;
1107: ecx_utils.g_target_levels(cur_ext_level).file_start_pos := 0;
1108: ecx_utils.g_target_levels(cur_ext_level).file_end_pos := 0;
1109: ecx_utils.g_target_levels(cur_ext_level).dtd_node_index := 0;
1110: if(l_statementEnabled) then
1111: ecx_debug.log(l_statement, 'External Level ('|| cur_ext_level||')',
1112: ecx_utils.g_target_levels(cur_ext_level).level,i_method_name);
1113: ecx_debug.log(l_statement, 'External Level ('||cur_ext_level||') Object Name: '
1108: ecx_utils.g_target_levels(cur_ext_level).file_end_pos := 0;
1109: ecx_utils.g_target_levels(cur_ext_level).dtd_node_index := 0;
1110: if(l_statementEnabled) then
1111: ecx_debug.log(l_statement, 'External Level ('|| cur_ext_level||')',
1112: ecx_utils.g_target_levels(cur_ext_level).level,i_method_name);
1113: ecx_debug.log(l_statement, 'External Level ('||cur_ext_level||') Object Name: '
1114: || 'start_element: ' || ecx_utils.g_target_levels (cur_ext_level).start_element,
1115: i_method_name);
1116: end if;
1110: if(l_statementEnabled) then
1111: ecx_debug.log(l_statement, 'External Level ('|| cur_ext_level||')',
1112: ecx_utils.g_target_levels(cur_ext_level).level,i_method_name);
1113: ecx_debug.log(l_statement, 'External Level ('||cur_ext_level||') Object Name: '
1114: || 'start_element: ' || ecx_utils.g_target_levels (cur_ext_level).start_element,
1115: i_method_name);
1116: end if;
1117:
1118: /** Load the Target Object Attributes **/
1179: then
1180: --this is the old 1 level mapping, so start j_count from 1
1181: j_count := 1;
1182: end if;
1183: ecx_utils.g_target_source_levels(j_count).source_level := cur_int_level;
1184: ecx_utils.g_target_source_levels(j_count).target_level := cur_ext_level;
1185: if(l_statementEnabled) then
1186: ecx_debug.log(l_statement,'Source and target Node Index ',v_source_element_id(k)||' '||v_target_element_id(k), i_method_name);
1187: end if;
1180: --this is the old 1 level mapping, so start j_count from 1
1181: j_count := 1;
1182: end if;
1183: ecx_utils.g_target_source_levels(j_count).source_level := cur_int_level;
1184: ecx_utils.g_target_source_levels(j_count).target_level := cur_ext_level;
1185: if(l_statementEnabled) then
1186: ecx_debug.log(l_statement,'Source and target Node Index ',v_source_element_id(k)||' '||v_target_element_id(k), i_method_name);
1187: end if;
1188: j_count := j_count + 1;
1187: end if;
1188: j_count := j_count + 1;
1189:
1190: /** Update the Target Node Index **/
1191: ecx_utils.g_target_levels(cur_ext_level).dtd_node_index := v_target_element_id(k);
1192: if(l_statementEnabled) then
1193: ecx_debug.log(l_statement, 'Target Node_index', g_target_levels(cur_ext_level).dtd_node_index ||
1194: ' at level' || cur_ext_level, i_method_name);
1195: ecx_debug.log(l_statement, 'Internal Level '|| cur_int_level||' External Level '
1209: /* Load the Internal Level */
1210: for c3 in source_rec ( i_map_id, v_source_level_id(k))
1211: loop
1212: int_loaded := True;
1213: ecx_utils.g_source_levels(cur_int_level).level := cur_int_level;
1214: ecx_utils.g_source_levels(cur_int_level).base_table_name := c3.source_level_name;
1215: ecx_utils.g_source_levels(cur_int_level).start_element := c3.source_level_name;
1216: ecx_utils.g_source_levels(cur_int_level).parent_level := c3.parent_level;
1217: ecx_utils.g_source_levels(cur_int_level).sql_stmt := null;
1210: for c3 in source_rec ( i_map_id, v_source_level_id(k))
1211: loop
1212: int_loaded := True;
1213: ecx_utils.g_source_levels(cur_int_level).level := cur_int_level;
1214: ecx_utils.g_source_levels(cur_int_level).base_table_name := c3.source_level_name;
1215: ecx_utils.g_source_levels(cur_int_level).start_element := c3.source_level_name;
1216: ecx_utils.g_source_levels(cur_int_level).parent_level := c3.parent_level;
1217: ecx_utils.g_source_levels(cur_int_level).sql_stmt := null;
1218: ecx_utils.g_source_levels(cur_int_level).cursor_handle := null;
1211: loop
1212: int_loaded := True;
1213: ecx_utils.g_source_levels(cur_int_level).level := cur_int_level;
1214: ecx_utils.g_source_levels(cur_int_level).base_table_name := c3.source_level_name;
1215: ecx_utils.g_source_levels(cur_int_level).start_element := c3.source_level_name;
1216: ecx_utils.g_source_levels(cur_int_level).parent_level := c3.parent_level;
1217: ecx_utils.g_source_levels(cur_int_level).sql_stmt := null;
1218: ecx_utils.g_source_levels(cur_int_level).cursor_handle := null;
1219: ecx_utils.g_source_levels(cur_int_level).rows_processed := 0;
1212: int_loaded := True;
1213: ecx_utils.g_source_levels(cur_int_level).level := cur_int_level;
1214: ecx_utils.g_source_levels(cur_int_level).base_table_name := c3.source_level_name;
1215: ecx_utils.g_source_levels(cur_int_level).start_element := c3.source_level_name;
1216: ecx_utils.g_source_levels(cur_int_level).parent_level := c3.parent_level;
1217: ecx_utils.g_source_levels(cur_int_level).sql_stmt := null;
1218: ecx_utils.g_source_levels(cur_int_level).cursor_handle := null;
1219: ecx_utils.g_source_levels(cur_int_level).rows_processed := 0;
1220: ecx_utils.g_source_levels(cur_int_level).file_start_pos := 0;
1213: ecx_utils.g_source_levels(cur_int_level).level := cur_int_level;
1214: ecx_utils.g_source_levels(cur_int_level).base_table_name := c3.source_level_name;
1215: ecx_utils.g_source_levels(cur_int_level).start_element := c3.source_level_name;
1216: ecx_utils.g_source_levels(cur_int_level).parent_level := c3.parent_level;
1217: ecx_utils.g_source_levels(cur_int_level).sql_stmt := null;
1218: ecx_utils.g_source_levels(cur_int_level).cursor_handle := null;
1219: ecx_utils.g_source_levels(cur_int_level).rows_processed := 0;
1220: ecx_utils.g_source_levels(cur_int_level).file_start_pos := 0;
1221: ecx_utils.g_source_levels(cur_int_level).file_end_pos := 0;
1214: ecx_utils.g_source_levels(cur_int_level).base_table_name := c3.source_level_name;
1215: ecx_utils.g_source_levels(cur_int_level).start_element := c3.source_level_name;
1216: ecx_utils.g_source_levels(cur_int_level).parent_level := c3.parent_level;
1217: ecx_utils.g_source_levels(cur_int_level).sql_stmt := null;
1218: ecx_utils.g_source_levels(cur_int_level).cursor_handle := null;
1219: ecx_utils.g_source_levels(cur_int_level).rows_processed := 0;
1220: ecx_utils.g_source_levels(cur_int_level).file_start_pos := 0;
1221: ecx_utils.g_source_levels(cur_int_level).file_end_pos := 0;
1222: ecx_utils.g_source_levels(cur_int_level).dtd_node_index := v_source_element_id(k);
1215: ecx_utils.g_source_levels(cur_int_level).start_element := c3.source_level_name;
1216: ecx_utils.g_source_levels(cur_int_level).parent_level := c3.parent_level;
1217: ecx_utils.g_source_levels(cur_int_level).sql_stmt := null;
1218: ecx_utils.g_source_levels(cur_int_level).cursor_handle := null;
1219: ecx_utils.g_source_levels(cur_int_level).rows_processed := 0;
1220: ecx_utils.g_source_levels(cur_int_level).file_start_pos := 0;
1221: ecx_utils.g_source_levels(cur_int_level).file_end_pos := 0;
1222: ecx_utils.g_source_levels(cur_int_level).dtd_node_index := v_source_element_id(k);
1223: if(l_statementEnabled) then
1216: ecx_utils.g_source_levels(cur_int_level).parent_level := c3.parent_level;
1217: ecx_utils.g_source_levels(cur_int_level).sql_stmt := null;
1218: ecx_utils.g_source_levels(cur_int_level).cursor_handle := null;
1219: ecx_utils.g_source_levels(cur_int_level).rows_processed := 0;
1220: ecx_utils.g_source_levels(cur_int_level).file_start_pos := 0;
1221: ecx_utils.g_source_levels(cur_int_level).file_end_pos := 0;
1222: ecx_utils.g_source_levels(cur_int_level).dtd_node_index := v_source_element_id(k);
1223: if(l_statementEnabled) then
1224: ecx_debug.log(l_statement, 'Source Node_index', g_source_levels(cur_int_level).dtd_node_index ||
1217: ecx_utils.g_source_levels(cur_int_level).sql_stmt := null;
1218: ecx_utils.g_source_levels(cur_int_level).cursor_handle := null;
1219: ecx_utils.g_source_levels(cur_int_level).rows_processed := 0;
1220: ecx_utils.g_source_levels(cur_int_level).file_start_pos := 0;
1221: ecx_utils.g_source_levels(cur_int_level).file_end_pos := 0;
1222: ecx_utils.g_source_levels(cur_int_level).dtd_node_index := v_source_element_id(k);
1223: if(l_statementEnabled) then
1224: ecx_debug.log(l_statement, 'Source Node_index', g_source_levels(cur_int_level).dtd_node_index ||
1225: ' at level' || cur_int_level,i_method_name);
1218: ecx_utils.g_source_levels(cur_int_level).cursor_handle := null;
1219: ecx_utils.g_source_levels(cur_int_level).rows_processed := 0;
1220: ecx_utils.g_source_levels(cur_int_level).file_start_pos := 0;
1221: ecx_utils.g_source_levels(cur_int_level).file_end_pos := 0;
1222: ecx_utils.g_source_levels(cur_int_level).dtd_node_index := v_source_element_id(k);
1223: if(l_statementEnabled) then
1224: ecx_debug.log(l_statement, 'Source Node_index', g_source_levels(cur_int_level).dtd_node_index ||
1225: ' at level' || cur_int_level,i_method_name);
1226:
1224: ecx_debug.log(l_statement, 'Source Node_index', g_source_levels(cur_int_level).dtd_node_index ||
1225: ' at level' || cur_int_level,i_method_name);
1226:
1227: ecx_debug.log(l_statement, 'Internal Level ('||cur_int_level||') Object Name: '
1228: || ecx_utils.g_source_levels (cur_int_level).base_table_name
1229: || ' Parent Level '
1230: || ecx_utils.g_source_levels(cur_int_level).parent_level,i_method_name);
1231: end if;
1232:
1226:
1227: ecx_debug.log(l_statement, 'Internal Level ('||cur_int_level||') Object Name: '
1228: || ecx_utils.g_source_levels (cur_int_level).base_table_name
1229: || ' Parent Level '
1230: || ecx_utils.g_source_levels(cur_int_level).parent_level,i_method_name);
1231: end if;
1232:
1233: --END IF;
1234: /** Load the Source Object Attributes **/
1260: end loop; -- external_rec
1261: end if;
1262: -- This is only to print out the file_start/end_pos.
1263: if(l_statementEnabled) then
1264: if (ecx_utils.g_source_levels.count <> 0)
1265: then
1266: for i in ecx_utils.g_source_levels.first..ecx_utils.g_source_levels.last
1267: loop
1268: ecx_debug.log(l_statement, 'ECX', 'ECX_INT_FILE_START',i_method_name, 'LEVEL', i,
1262: -- This is only to print out the file_start/end_pos.
1263: if(l_statementEnabled) then
1264: if (ecx_utils.g_source_levels.count <> 0)
1265: then
1266: for i in ecx_utils.g_source_levels.first..ecx_utils.g_source_levels.last
1267: loop
1268: ecx_debug.log(l_statement, 'ECX', 'ECX_INT_FILE_START',i_method_name, 'LEVEL', i,
1269: 'POSITION', ecx_utils.g_source_levels(i).file_start_pos);
1270: ecx_debug.log(l_statement, 'ECX', 'ECX_INT_FILE_END',i_method_name, 'LEVEL', i,
1265: then
1266: for i in ecx_utils.g_source_levels.first..ecx_utils.g_source_levels.last
1267: loop
1268: ecx_debug.log(l_statement, 'ECX', 'ECX_INT_FILE_START',i_method_name, 'LEVEL', i,
1269: 'POSITION', ecx_utils.g_source_levels(i).file_start_pos);
1270: ecx_debug.log(l_statement, 'ECX', 'ECX_INT_FILE_END',i_method_name, 'LEVEL', i,
1271: 'POSITION', ecx_utils.g_source_levels(i).file_end_pos);
1272: end loop;
1273: end if;
1267: loop
1268: ecx_debug.log(l_statement, 'ECX', 'ECX_INT_FILE_START',i_method_name, 'LEVEL', i,
1269: 'POSITION', ecx_utils.g_source_levels(i).file_start_pos);
1270: ecx_debug.log(l_statement, 'ECX', 'ECX_INT_FILE_END',i_method_name, 'LEVEL', i,
1271: 'POSITION', ecx_utils.g_source_levels(i).file_end_pos);
1272: end loop;
1273: end if;
1274: if (ecx_utils.g_target_levels.count <> 0)
1275: then
1270: ecx_debug.log(l_statement, 'ECX', 'ECX_INT_FILE_END',i_method_name, 'LEVEL', i,
1271: 'POSITION', ecx_utils.g_source_levels(i).file_end_pos);
1272: end loop;
1273: end if;
1274: if (ecx_utils.g_target_levels.count <> 0)
1275: then
1276: for i in ecx_utils.g_target_levels.first..ecx_utils.g_target_levels.last
1277: loop
1278: ecx_debug.log(l_statement, 'ECX', 'ECX_EXT_FILE_START',i_method_name, 'LEVEL', i,
1272: end loop;
1273: end if;
1274: if (ecx_utils.g_target_levels.count <> 0)
1275: then
1276: for i in ecx_utils.g_target_levels.first..ecx_utils.g_target_levels.last
1277: loop
1278: ecx_debug.log(l_statement, 'ECX', 'ECX_EXT_FILE_START',i_method_name, 'LEVEL', i,
1279: 'POSITION', ecx_utils.g_target_levels(i).file_start_pos);
1280: ecx_debug.log(l_statement, 'ECX', 'ECX_EXT_FILE_END',i_method_name, 'LEVEL', i,
1275: then
1276: for i in ecx_utils.g_target_levels.first..ecx_utils.g_target_levels.last
1277: loop
1278: ecx_debug.log(l_statement, 'ECX', 'ECX_EXT_FILE_START',i_method_name, 'LEVEL', i,
1279: 'POSITION', ecx_utils.g_target_levels(i).file_start_pos);
1280: ecx_debug.log(l_statement, 'ECX', 'ECX_EXT_FILE_END',i_method_name, 'LEVEL', i,
1281: 'POSITION', ecx_utils.g_target_levels(i).file_end_pos);
1282: end loop;
1283: end if;
1277: loop
1278: ecx_debug.log(l_statement, 'ECX', 'ECX_EXT_FILE_START',i_method_name, 'LEVEL', i,
1279: 'POSITION', ecx_utils.g_target_levels(i).file_start_pos);
1280: ecx_debug.log(l_statement, 'ECX', 'ECX_EXT_FILE_END',i_method_name, 'LEVEL', i,
1281: 'POSITION', ecx_utils.g_target_levels(i).file_end_pos);
1282: end loop;
1283: end if;
1284: end if;
1285:
1282: end loop;
1283: end if;
1284: end if;
1285:
1286: if (ecx_utils.g_source_levels.count <> 0 )
1287: then
1288: for i in ecx_utils.g_source_levels.first..ecx_utils.g_source_levels.last
1289: loop
1290: /** Reset all of the range variables. **/
1284: end if;
1285:
1286: if (ecx_utils.g_source_levels.count <> 0 )
1287: then
1288: for i in ecx_utils.g_source_levels.first..ecx_utils.g_source_levels.last
1289: loop
1290: /** Reset all of the range variables. **/
1291: /** These assume that there are fewer than a million levels. **/
1292: -- This is the beginning of a potential expansion range
1303: -- same as first_source_level and i.
1304: g_source_levels(i).last_source_level := -1;
1305:
1306: /** Retrieve the mapping ranges. **/
1307: if (ecx_utils.g_target_source_levels.count <> 0)
1308: then
1309: for k in ecx_utils.g_target_source_levels.first..ecx_utils.g_target_source_levels.last
1310: loop
1311: if ecx_utils.g_target_source_levels(k).source_level = i
1305:
1306: /** Retrieve the mapping ranges. **/
1307: if (ecx_utils.g_target_source_levels.count <> 0)
1308: then
1309: for k in ecx_utils.g_target_source_levels.first..ecx_utils.g_target_source_levels.last
1310: loop
1311: if ecx_utils.g_target_source_levels(k).source_level = i
1312: then
1313: /** These don't assume that the table is in order **/
1307: if (ecx_utils.g_target_source_levels.count <> 0)
1308: then
1309: for k in ecx_utils.g_target_source_levels.first..ecx_utils.g_target_source_levels.last
1310: loop
1311: if ecx_utils.g_target_source_levels(k).source_level = i
1312: then
1313: /** These don't assume that the table is in order **/
1314: if ecx_utils.g_target_source_levels(k).target_level <
1315: g_source_levels(i).first_target_level
1310: loop
1311: if ecx_utils.g_target_source_levels(k).source_level = i
1312: then
1313: /** These don't assume that the table is in order **/
1314: if ecx_utils.g_target_source_levels(k).target_level <
1315: g_source_levels(i).first_target_level
1316: then
1317: g_source_levels(i).first_target_level := ecx_utils.g_target_source_levels(k).target_level;
1318: /** The source_level could be wrong if this is a collapsing, but if so,
1313: /** These don't assume that the table is in order **/
1314: if ecx_utils.g_target_source_levels(k).target_level <
1315: g_source_levels(i).first_target_level
1316: then
1317: g_source_levels(i).first_target_level := ecx_utils.g_target_source_levels(k).target_level;
1318: /** The source_level could be wrong if this is a collapsing, but if so,
1319: it will be fixed in the next loop. **/
1320: g_source_levels(i).first_source_level := ecx_utils.g_target_source_levels(k).source_level;
1321: end if;
1316: then
1317: g_source_levels(i).first_target_level := ecx_utils.g_target_source_levels(k).target_level;
1318: /** The source_level could be wrong if this is a collapsing, but if so,
1319: it will be fixed in the next loop. **/
1320: g_source_levels(i).first_source_level := ecx_utils.g_target_source_levels(k).source_level;
1321: end if;
1322: if ecx_utils.g_target_source_levels(k).target_level > g_source_levels(i).last_target_level
1323: then
1324: g_source_levels(i).last_target_level := ecx_utils.g_target_source_levels(k).target_level;
1318: /** The source_level could be wrong if this is a collapsing, but if so,
1319: it will be fixed in the next loop. **/
1320: g_source_levels(i).first_source_level := ecx_utils.g_target_source_levels(k).source_level;
1321: end if;
1322: if ecx_utils.g_target_source_levels(k).target_level > g_source_levels(i).last_target_level
1323: then
1324: g_source_levels(i).last_target_level := ecx_utils.g_target_source_levels(k).target_level;
1325: g_source_levels(i).last_source_level := ecx_utils.g_target_source_levels(k).source_level;
1326: end if;
1320: g_source_levels(i).first_source_level := ecx_utils.g_target_source_levels(k).source_level;
1321: end if;
1322: if ecx_utils.g_target_source_levels(k).target_level > g_source_levels(i).last_target_level
1323: then
1324: g_source_levels(i).last_target_level := ecx_utils.g_target_source_levels(k).target_level;
1325: g_source_levels(i).last_source_level := ecx_utils.g_target_source_levels(k).source_level;
1326: end if;
1327: end if;
1328: end loop;
1321: end if;
1322: if ecx_utils.g_target_source_levels(k).target_level > g_source_levels(i).last_target_level
1323: then
1324: g_source_levels(i).last_target_level := ecx_utils.g_target_source_levels(k).target_level;
1325: g_source_levels(i).last_source_level := ecx_utils.g_target_source_levels(k).source_level;
1326: end if;
1327: end if;
1328: end loop;
1329: end if;
1330:
1331: /** Now that we've checked for expansion, check for collapsing. **/
1332: if g_source_levels(i).first_target_level = g_source_levels(i).last_target_level
1333: then
1334: if (ecx_utils.g_target_source_levels.count <> 0)
1335: then
1336: for k in ecx_utils.g_target_source_levels.first..ecx_utils.g_target_source_levels.last
1337: loop
1338: if ecx_utils.g_target_source_levels(k).target_level = g_source_levels(i).first_target_level
1332: if g_source_levels(i).first_target_level = g_source_levels(i).last_target_level
1333: then
1334: if (ecx_utils.g_target_source_levels.count <> 0)
1335: then
1336: for k in ecx_utils.g_target_source_levels.first..ecx_utils.g_target_source_levels.last
1337: loop
1338: if ecx_utils.g_target_source_levels(k).target_level = g_source_levels(i).first_target_level
1339: then
1340: if ecx_utils.g_target_source_levels(k).source_level < g_source_levels(i).first_source_level
1334: if (ecx_utils.g_target_source_levels.count <> 0)
1335: then
1336: for k in ecx_utils.g_target_source_levels.first..ecx_utils.g_target_source_levels.last
1337: loop
1338: if ecx_utils.g_target_source_levels(k).target_level = g_source_levels(i).first_target_level
1339: then
1340: if ecx_utils.g_target_source_levels(k).source_level < g_source_levels(i).first_source_level
1341: then
1342: g_source_levels(i).first_source_level := ecx_utils.g_target_source_levels(k).source_level;
1336: for k in ecx_utils.g_target_source_levels.first..ecx_utils.g_target_source_levels.last
1337: loop
1338: if ecx_utils.g_target_source_levels(k).target_level = g_source_levels(i).first_target_level
1339: then
1340: if ecx_utils.g_target_source_levels(k).source_level < g_source_levels(i).first_source_level
1341: then
1342: g_source_levels(i).first_source_level := ecx_utils.g_target_source_levels(k).source_level;
1343: end if;
1344: if ecx_utils.g_target_source_levels(k).source_level > g_source_levels(i).last_source_level
1338: if ecx_utils.g_target_source_levels(k).target_level = g_source_levels(i).first_target_level
1339: then
1340: if ecx_utils.g_target_source_levels(k).source_level < g_source_levels(i).first_source_level
1341: then
1342: g_source_levels(i).first_source_level := ecx_utils.g_target_source_levels(k).source_level;
1343: end if;
1344: if ecx_utils.g_target_source_levels(k).source_level > g_source_levels(i).last_source_level
1345: then
1346: g_source_levels(i).last_source_level := ecx_utils.g_target_source_levels(k).source_level;
1340: if ecx_utils.g_target_source_levels(k).source_level < g_source_levels(i).first_source_level
1341: then
1342: g_source_levels(i).first_source_level := ecx_utils.g_target_source_levels(k).source_level;
1343: end if;
1344: if ecx_utils.g_target_source_levels(k).source_level > g_source_levels(i).last_source_level
1345: then
1346: g_source_levels(i).last_source_level := ecx_utils.g_target_source_levels(k).source_level;
1347: end if;
1348: end if;
1342: g_source_levels(i).first_source_level := ecx_utils.g_target_source_levels(k).source_level;
1343: end if;
1344: if ecx_utils.g_target_source_levels(k).source_level > g_source_levels(i).last_source_level
1345: then
1346: g_source_levels(i).last_source_level := ecx_utils.g_target_source_levels(k).source_level;
1347: end if;
1348: end if;
1349: end loop;
1350: end if;
1387:
1388: WHEN OTHERS THEN
1389: if(l_unexpectedEnabled) then
1390: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1391: 'ecx_utils.LOAD_MAPPINGS');
1392: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1393: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.LOAD_MAPPINGS: ',
1394: i_method_name);
1395: end if;
1389: if(l_unexpectedEnabled) then
1390: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1391: 'ecx_utils.LOAD_MAPPINGS');
1392: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1393: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.LOAD_MAPPINGS: ',
1394: i_method_name);
1395: end if;
1396: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.LOAD_MAPPINGS: ');
1397: if (l_procedureEnabled) then
1392: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1393: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.LOAD_MAPPINGS: ',
1394: i_method_name);
1395: end if;
1396: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.LOAD_MAPPINGS: ');
1397: if (l_procedureEnabled) then
1398: ecx_debug.pop(i_method_name);
1399: end if;
1400: raise PROGRAM_EXIT;
1411: i_map_id IN pls_integer,
1412: i_result OUT NOCOPY boolean,
1413: i_ret_msg OUT NOCOPY varchar2 ) IS
1414:
1415: i_method_name varchar2(2000) := 'ecx_utils.check_version';
1416: i_major_version pls_integer;
1417: i_minor_version pls_integer;
1418: i_eng_major_version pls_integer;
1419: i_eng_minor_version pls_integer;
1544: exception
1545: when others then
1546: if(l_unexpectedEnabled) then
1547: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1548: 'ecx_utils.CHECK_VERSION');
1549: ecx_debug.log(l_unexpected,'ECX', 'ECX_ERROR_MESSAGE',i_method_name, 'ERROR_MESSAGE', SQLERRM);
1550: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.CHECK_VERSION',i_method_name);
1551: end if;
1552: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.CHECK_VERSION');
1546: if(l_unexpectedEnabled) then
1547: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1548: 'ecx_utils.CHECK_VERSION');
1549: ecx_debug.log(l_unexpected,'ECX', 'ECX_ERROR_MESSAGE',i_method_name, 'ERROR_MESSAGE', SQLERRM);
1550: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.CHECK_VERSION',i_method_name);
1551: end if;
1552: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.CHECK_VERSION');
1553: if (l_procedureEnabled) then
1554: ecx_debug.pop(i_method_name);
1548: 'ecx_utils.CHECK_VERSION');
1549: ecx_debug.log(l_unexpected,'ECX', 'ECX_ERROR_MESSAGE',i_method_name, 'ERROR_MESSAGE', SQLERRM);
1550: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.CHECK_VERSION',i_method_name);
1551: end if;
1552: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.CHECK_VERSION');
1553: if (l_procedureEnabled) then
1554: ecx_debug.pop(i_method_name);
1555: end if;
1556: raise ecx_utils.program_exit;
1552: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.CHECK_VERSION');
1553: if (l_procedureEnabled) then
1554: ecx_debug.pop(i_method_name);
1555: end if;
1556: raise ecx_utils.program_exit;
1557: end check_version;
1558:
1559:
1560: /*
1564: procedure initialize (
1565: i_map_id IN pls_integer,
1566: x_same_map OUT NOCOPY Boolean) IS
1567:
1568: i_method_name varchar2(2000) := 'ecx_utils.initialize';
1569: /* Cursor to get the Root Element and Path to the DTD */
1570: cursor get_dtd (
1571: p_map_id IN pls_integer ,
1572: p_object_id IN pls_integer) IS
1632: end if;
1633:
1634: i_ret_code := 0;
1635: i_errbuf := null;
1636: ecx_utils.i_errparams := null;
1637: ecx_utils.g_total_records := 0;
1638: ecx_utils.g_current_level := 0;
1639: ecx_utils.g_previous_level := 0;
1640: g_source_object_id := null;
1633:
1634: i_ret_code := 0;
1635: i_errbuf := null;
1636: ecx_utils.i_errparams := null;
1637: ecx_utils.g_total_records := 0;
1638: ecx_utils.g_current_level := 0;
1639: ecx_utils.g_previous_level := 0;
1640: g_source_object_id := null;
1641: g_target_object_id := null;
1634: i_ret_code := 0;
1635: i_errbuf := null;
1636: ecx_utils.i_errparams := null;
1637: ecx_utils.g_total_records := 0;
1638: ecx_utils.g_current_level := 0;
1639: ecx_utils.g_previous_level := 0;
1640: g_source_object_id := null;
1641: g_target_object_id := null;
1642: ecx_print_local.last_printed := -1;
1635: i_errbuf := null;
1636: ecx_utils.i_errparams := null;
1637: ecx_utils.g_total_records := 0;
1638: ecx_utils.g_current_level := 0;
1639: ecx_utils.g_previous_level := 0;
1640: g_source_object_id := null;
1641: g_target_object_id := null;
1642: ecx_print_local.last_printed := -1;
1643:
1641: g_target_object_id := null;
1642: ecx_print_local.last_printed := -1;
1643:
1644: -- check the version
1645: ecx_utils.check_version(i_map_id, i_result, i_ret_msg);
1646: if (not i_result)
1647: then
1648: if(l_statementEnabled) then
1649: ecx_debug.log(l_statement, 'ECX', 'ECX_PROGRAM_ERROR', i_method_name, 'PROGRESS_LEVEL',
1646: if (not i_result)
1647: then
1648: if(l_statementEnabled) then
1649: ecx_debug.log(l_statement, 'ECX', 'ECX_PROGRAM_ERROR', i_method_name, 'PROGRESS_LEVEL',
1650: 'ecx_utils.INITIALIZE');
1651: ecx_debug.log(l_statement, 'ECX','ECX_ERROR_MESSAGE', i_method_name,'ERROR_MESSAGE', i_ret_msg);
1652: end if;
1653: raise ecx_utils.program_exit;
1654: end if;
1649: ecx_debug.log(l_statement, 'ECX', 'ECX_PROGRAM_ERROR', i_method_name, 'PROGRESS_LEVEL',
1650: 'ecx_utils.INITIALIZE');
1651: ecx_debug.log(l_statement, 'ECX','ECX_ERROR_MESSAGE', i_method_name,'ERROR_MESSAGE', i_ret_msg);
1652: end if;
1653: raise ecx_utils.program_exit;
1654: end if;
1655: /* Find the map code for bug 1939677 */
1656: select map_code into i_map_code from ecx_mappings where map_id=i_map_id;
1657:
1669: if(l_unexpectedEnabled) then
1670: ecx_debug.log(l_unexpected,'ECX', 'ECX_MAPPINGS_NOT_FOUND',i_method_name,
1671: 'MAP_ID', i_map_id);
1672: end if;
1673: raise ecx_utils.program_exit;
1674: end;
1675:
1676: -- needed for root element support
1677: ecx_print_local.first_time_printing := TRUE;
1674: end;
1675:
1676: -- needed for root element support
1677: ecx_print_local.first_time_printing := TRUE;
1678: ecx_utils.g_xml_frag.DELETE;
1679: --for bug 5609625
1680: --if (nvl(ecx_utils.g_map_id,0) <> i_map_id) then
1681:
1682: ecx_utils.structure_printing := FALSE;
1676: -- needed for root element support
1677: ecx_print_local.first_time_printing := TRUE;
1678: ecx_utils.g_xml_frag.DELETE;
1679: --for bug 5609625
1680: --if (nvl(ecx_utils.g_map_id,0) <> i_map_id) then
1681:
1682: ecx_utils.structure_printing := FALSE;
1683: ecx_utils.dom_printing := FALSE;
1684:
1678: ecx_utils.g_xml_frag.DELETE;
1679: --for bug 5609625
1680: --if (nvl(ecx_utils.g_map_id,0) <> i_map_id) then
1681:
1682: ecx_utils.structure_printing := FALSE;
1683: ecx_utils.dom_printing := FALSE;
1684:
1685: -- if ( ecx_utils.g_parser.id = -1 )
1686: -- then
1679: --for bug 5609625
1680: --if (nvl(ecx_utils.g_map_id,0) <> i_map_id) then
1681:
1682: ecx_utils.structure_printing := FALSE;
1683: ecx_utils.dom_printing := FALSE;
1684:
1685: -- if ( ecx_utils.g_parser.id = -1 )
1686: -- then
1687: ecx_utils.g_parser := xmlParser.NewParser;
1681:
1682: ecx_utils.structure_printing := FALSE;
1683: ecx_utils.dom_printing := FALSE;
1684:
1685: -- if ( ecx_utils.g_parser.id = -1 )
1686: -- then
1687: ecx_utils.g_parser := xmlParser.NewParser;
1688: --else
1689: --xmlParser.freeParser(ecx_utils.g_parser);
1683: ecx_utils.dom_printing := FALSE;
1684:
1685: -- if ( ecx_utils.g_parser.id = -1 )
1686: -- then
1687: ecx_utils.g_parser := xmlParser.NewParser;
1688: --else
1689: --xmlParser.freeParser(ecx_utils.g_parser);
1690: --ecx_utils.g_parser := xmlParser.NewParser;
1691: -- end if;
1685: -- if ( ecx_utils.g_parser.id = -1 )
1686: -- then
1687: ecx_utils.g_parser := xmlParser.NewParser;
1688: --else
1689: --xmlParser.freeParser(ecx_utils.g_parser);
1690: --ecx_utils.g_parser := xmlParser.NewParser;
1691: -- end if;
1692:
1693: --if ( ecx_utils.g_inb_parser.id not in (-1) )
1686: -- then
1687: ecx_utils.g_parser := xmlParser.NewParser;
1688: --else
1689: --xmlParser.freeParser(ecx_utils.g_parser);
1690: --ecx_utils.g_parser := xmlParser.NewParser;
1691: -- end if;
1692:
1693: --if ( ecx_utils.g_inb_parser.id not in (-1) )
1694: -- then
1689: --xmlParser.freeParser(ecx_utils.g_parser);
1690: --ecx_utils.g_parser := xmlParser.NewParser;
1691: -- end if;
1692:
1693: --if ( ecx_utils.g_inb_parser.id not in (-1) )
1694: -- then
1695: -- xmlParser.freeParser(ecx_utils.g_inb_parser);
1696: -- end if;
1697: ---end of 5609625
1691: -- end if;
1692:
1693: --if ( ecx_utils.g_inb_parser.id not in (-1) )
1694: -- then
1695: -- xmlParser.freeParser(ecx_utils.g_inb_parser);
1696: -- end if;
1697: ---end of 5609625
1698: ecx_utils.getLogDirectory;
1699:
1694: -- then
1695: -- xmlParser.freeParser(ecx_utils.g_inb_parser);
1696: -- end if;
1697: ---end of 5609625
1698: ecx_utils.getLogDirectory;
1699:
1700: if(l_statementEnabled) then
1701: ecx_debug.log(l_statement, 'ecx_UTL_DTD_DIR', ecx_utils.g_logdir,i_method_name);
1702: end if;
1697: ---end of 5609625
1698: ecx_utils.getLogDirectory;
1699:
1700: if(l_statementEnabled) then
1701: ecx_debug.log(l_statement, 'ecx_UTL_DTD_DIR', ecx_utils.g_logdir,i_method_name);
1702: end if;
1703: -- xmlparser.setbaseDir (ecx_utils.g_parser, l_dtd_path);
1704:
1705: if ( g_direction = 'IN' )
1699:
1700: if(l_statementEnabled) then
1701: ecx_debug.log(l_statement, 'ecx_UTL_DTD_DIR', ecx_utils.g_logdir,i_method_name);
1702: end if;
1703: -- xmlparser.setbaseDir (ecx_utils.g_parser, l_dtd_path);
1704:
1705: if ( g_direction = 'IN' )
1706: then
1707: -- get the source details
1749: then
1750: if(l_statementEnabled) then
1751: ecx_debug.log(l_statement, 'Source and Target DTDs are same',i_method_name);
1752: end if;
1753: ecx_utils.dom_printing := FALSE;
1754: ecx_utils.structure_printing := FALSE;
1755:
1756: -- check for routing information
1757: if ((ecx_utils.g_routing_id not in (0)) AND
1750: if(l_statementEnabled) then
1751: ecx_debug.log(l_statement, 'Source and Target DTDs are same',i_method_name);
1752: end if;
1753: ecx_utils.dom_printing := FALSE;
1754: ecx_utils.structure_printing := FALSE;
1755:
1756: -- check for routing information
1757: if ((ecx_utils.g_routing_id not in (0)) AND
1758: (ecx_utils.g_rec_tp_id is not null))
1753: ecx_utils.dom_printing := FALSE;
1754: ecx_utils.structure_printing := FALSE;
1755:
1756: -- check for routing information
1757: if ((ecx_utils.g_routing_id not in (0)) AND
1758: (ecx_utils.g_rec_tp_id is not null))
1759: then
1760: -- this is a pass through transaction. Need to update
1761: -- the DOM
1754: ecx_utils.structure_printing := FALSE;
1755:
1756: -- check for routing information
1757: if ((ecx_utils.g_routing_id not in (0)) AND
1758: (ecx_utils.g_rec_tp_id is not null))
1759: then
1760: -- this is a pass through transaction. Need to update
1761: -- the DOM
1762: ecx_utils.dom_printing := TRUE;
1758: (ecx_utils.g_rec_tp_id is not null))
1759: then
1760: -- this is a pass through transaction. Need to update
1761: -- the DOM
1762: ecx_utils.dom_printing := TRUE;
1763: ecx_utils.structure_printing := FALSE;
1764: --for 5609625
1765: -- initialize the DS needed for this
1766: --ecx_utils.g_node_tbl.DELETE;
1759: then
1760: -- this is a pass through transaction. Need to update
1761: -- the DOM
1762: ecx_utils.dom_printing := TRUE;
1763: ecx_utils.structure_printing := FALSE;
1764: --for 5609625
1765: -- initialize the DS needed for this
1766: --ecx_utils.g_node_tbl.DELETE;
1767: --end of 5609625
1762: ecx_utils.dom_printing := TRUE;
1763: ecx_utils.structure_printing := FALSE;
1764: --for 5609625
1765: -- initialize the DS needed for this
1766: --ecx_utils.g_node_tbl.DELETE;
1767: --end of 5609625
1768: end if;
1769: else
1770: -- DTDs are different, so this is structure transformation
1771: if(l_statementEnabled) then
1772: ecx_debug.log(l_statement,'Source and Target DTDs are different',i_method_name);
1773: end if;
1774: -- initialize the target parser
1775: ecx_utils.g_inb_parser := xmlparser.NewParser;
1776:
1777: ecx_utils.dom_printing := FALSE;
1778: ecx_utils.structure_printing := TRUE;
1779: end if;
1773: end if;
1774: -- initialize the target parser
1775: ecx_utils.g_inb_parser := xmlparser.NewParser;
1776:
1777: ecx_utils.dom_printing := FALSE;
1778: ecx_utils.structure_printing := TRUE;
1779: end if;
1780: end if;
1781: else
1774: -- initialize the target parser
1775: ecx_utils.g_inb_parser := xmlparser.NewParser;
1776:
1777: ecx_utils.dom_printing := FALSE;
1778: ecx_utils.structure_printing := TRUE;
1779: end if;
1780: end if;
1781: else
1782: open get_dtd (i_map_id,g_target_object_id);
1814: raise no_dtd_exception;
1815: end if;
1816: close getDtdClob;
1817:
1818: xmlparser.parseDTDCLOB(ecx_utils.g_parser,i_dtdpayload,l_root_element);
1819:
1820: xmlparser.setValidationMode (ecx_utils.g_parser,true);
1821: l_doctype := xmlparser.getDocType (ecx_utils.g_parser);
1822: xmlparser.setDocType (ecx_utils.g_parser, l_doctype);
1816: close getDtdClob;
1817:
1818: xmlparser.parseDTDCLOB(ecx_utils.g_parser,i_dtdpayload,l_root_element);
1819:
1820: xmlparser.setValidationMode (ecx_utils.g_parser,true);
1821: l_doctype := xmlparser.getDocType (ecx_utils.g_parser);
1822: xmlparser.setDocType (ecx_utils.g_parser, l_doctype);
1823:
1824: else
1817:
1818: xmlparser.parseDTDCLOB(ecx_utils.g_parser,i_dtdpayload,l_root_element);
1819:
1820: xmlparser.setValidationMode (ecx_utils.g_parser,true);
1821: l_doctype := xmlparser.getDocType (ecx_utils.g_parser);
1822: xmlparser.setDocType (ecx_utils.g_parser, l_doctype);
1823:
1824: else
1825: --- DTD not specified in the Map. Optional. let us proceed without the DTD.
1818: xmlparser.parseDTDCLOB(ecx_utils.g_parser,i_dtdpayload,l_root_element);
1819:
1820: xmlparser.setValidationMode (ecx_utils.g_parser,true);
1821: l_doctype := xmlparser.getDocType (ecx_utils.g_parser);
1822: xmlparser.setDocType (ecx_utils.g_parser, l_doctype);
1823:
1824: else
1825: --- DTD not specified in the Map. Optional. let us proceed without the DTD.
1826: xmlparser.setValidationMode (ecx_utils.g_parser, false);
1822: xmlparser.setDocType (ecx_utils.g_parser, l_doctype);
1823:
1824: else
1825: --- DTD not specified in the Map. Optional. let us proceed without the DTD.
1826: xmlparser.setValidationMode (ecx_utils.g_parser, false);
1827: end if;
1828:
1829: -- check if we need to load the target's clob
1830: if (i_tar_obj_type not in ('DB') AND (structure_printing))
1843: raise no_dtd_exception;
1844: end if;
1845: close getDtdClob;
1846:
1847: xmlparser.parseDTDCLOB(ecx_utils.g_inb_parser,t_dtdpayload,t_root_element);
1848: xmlparser.setValidationMode (ecx_utils.g_inb_parser, true);
1849: t_doctype := xmlparser.getDocType (ecx_utils.g_inb_parser);
1850: xmlparser.setDocType (ecx_utils.g_inb_parser, t_doctype);
1851: else
1844: end if;
1845: close getDtdClob;
1846:
1847: xmlparser.parseDTDCLOB(ecx_utils.g_inb_parser,t_dtdpayload,t_root_element);
1848: xmlparser.setValidationMode (ecx_utils.g_inb_parser, true);
1849: t_doctype := xmlparser.getDocType (ecx_utils.g_inb_parser);
1850: xmlparser.setDocType (ecx_utils.g_inb_parser, t_doctype);
1851: else
1852: --- DTD not specified in the Map. Optional. let us proceed without the DTD.
1845: close getDtdClob;
1846:
1847: xmlparser.parseDTDCLOB(ecx_utils.g_inb_parser,t_dtdpayload,t_root_element);
1848: xmlparser.setValidationMode (ecx_utils.g_inb_parser, true);
1849: t_doctype := xmlparser.getDocType (ecx_utils.g_inb_parser);
1850: xmlparser.setDocType (ecx_utils.g_inb_parser, t_doctype);
1851: else
1852: --- DTD not specified in the Map. Optional. let us proceed without the DTD.
1853: xmlparser.setValidationMode (ecx_utils.g_inb_parser, false);
1846:
1847: xmlparser.parseDTDCLOB(ecx_utils.g_inb_parser,t_dtdpayload,t_root_element);
1848: xmlparser.setValidationMode (ecx_utils.g_inb_parser, true);
1849: t_doctype := xmlparser.getDocType (ecx_utils.g_inb_parser);
1850: xmlparser.setDocType (ecx_utils.g_inb_parser, t_doctype);
1851: else
1852: --- DTD not specified in the Map. Optional. let us proceed without the DTD.
1853: xmlparser.setValidationMode (ecx_utils.g_inb_parser, false);
1854: end if;
1849: t_doctype := xmlparser.getDocType (ecx_utils.g_inb_parser);
1850: xmlparser.setDocType (ecx_utils.g_inb_parser, t_doctype);
1851: else
1852: --- DTD not specified in the Map. Optional. let us proceed without the DTD.
1853: xmlparser.setValidationMode (ecx_utils.g_inb_parser, false);
1854: end if;
1855: end if;
1856: --for bug 5609625
1857: if (nvl(ecx_utils.g_map_id,0) <> i_map_id) then
1853: xmlparser.setValidationMode (ecx_utils.g_inb_parser, false);
1854: end if;
1855: end if;
1856: --for bug 5609625
1857: if (nvl(ecx_utils.g_map_id,0) <> i_map_id) then
1858: x_same_map := False;
1859: ecx_utils.g_map_id := i_map_id;
1860: if(ecx_utils.dom_printing = TRUE and
1861: ecx_utils.structure_printing = FALSE)
1855: end if;
1856: --for bug 5609625
1857: if (nvl(ecx_utils.g_map_id,0) <> i_map_id) then
1858: x_same_map := False;
1859: ecx_utils.g_map_id := i_map_id;
1860: if(ecx_utils.dom_printing = TRUE and
1861: ecx_utils.structure_printing = FALSE)
1862: then
1863: -- initialize the DS needed for this
1856: --for bug 5609625
1857: if (nvl(ecx_utils.g_map_id,0) <> i_map_id) then
1858: x_same_map := False;
1859: ecx_utils.g_map_id := i_map_id;
1860: if(ecx_utils.dom_printing = TRUE and
1861: ecx_utils.structure_printing = FALSE)
1862: then
1863: -- initialize the DS needed for this
1864: ecx_utils.g_node_tbl.DELETE;
1857: if (nvl(ecx_utils.g_map_id,0) <> i_map_id) then
1858: x_same_map := False;
1859: ecx_utils.g_map_id := i_map_id;
1860: if(ecx_utils.dom_printing = TRUE and
1861: ecx_utils.structure_printing = FALSE)
1862: then
1863: -- initialize the DS needed for this
1864: ecx_utils.g_node_tbl.DELETE;
1865: end if;
1860: if(ecx_utils.dom_printing = TRUE and
1861: ecx_utils.structure_printing = FALSE)
1862: then
1863: -- initialize the DS needed for this
1864: ecx_utils.g_node_tbl.DELETE;
1865: end if;
1866: --end of 5609625
1867: ecx_utils.close_process;
1868: x_same_map := False;
1863: -- initialize the DS needed for this
1864: ecx_utils.g_node_tbl.DELETE;
1865: end if;
1866: --end of 5609625
1867: ecx_utils.close_process;
1868: x_same_map := False;
1869: ecx_utils.g_map_id := i_map_id;
1870:
1871:
1865: end if;
1866: --end of 5609625
1867: ecx_utils.close_process;
1868: x_same_map := False;
1869: ecx_utils.g_map_id := i_map_id;
1870:
1871:
1872: /**
1873: Get all the Dynamic Inbound Staging data. The data is retrieved from the
1890: /**
1891: Save the PL/SQL table with default values. This will be used
1892: by all the documents.
1893: **/
1894: ecx_utils.g_empty_source := ecx_utils.g_source;
1895: ecx_utils.g_empty_target := ecx_utils.g_target;
1896:
1897: else
1898:
1891: Save the PL/SQL table with default values. This will be used
1892: by all the documents.
1893: **/
1894: ecx_utils.g_empty_source := ecx_utils.g_source;
1895: ecx_utils.g_empty_target := ecx_utils.g_target;
1896:
1897: else
1898:
1899: x_same_map := True;
1898:
1899: x_same_map := True;
1900: ecx_actions.execute_stage_data (10,0,'S');
1901: ecx_actions.execute_stage_data (10,0,'T');
1902: ecx_utils.g_source := ecx_utils.g_empty_source;
1903: ecx_utils.g_target := ecx_utils.g_empty_target;
1904: end if;
1905:
1906: --- Gets the Company name for the XML Gateway Server.
1899: x_same_map := True;
1900: ecx_actions.execute_stage_data (10,0,'S');
1901: ecx_actions.execute_stage_data (10,0,'T');
1902: ecx_utils.g_source := ecx_utils.g_empty_source;
1903: ecx_utils.g_target := ecx_utils.g_empty_target;
1904: end if;
1905:
1906: --- Gets the Company name for the XML Gateway Server.
1907:
1905:
1906: --- Gets the Company name for the XML Gateway Server.
1907:
1908: --- Check for the Installation Type ( Standalone or Embedded );
1909: ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');
1910:
1911: if ecx_utils.g_install_mode = 'EMBEDDED'
1912: then
1913: i_string := 'begin
1907:
1908: --- Check for the Installation Type ( Standalone or Embedded );
1909: ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');
1910:
1911: if ecx_utils.g_install_mode = 'EMBEDDED'
1912: then
1913: i_string := 'begin
1914: fnd_profile.get('||'''ECX_OAG_LOGICALID'''||',ecx_utils.g_company_name);
1915: end;';
1910:
1911: if ecx_utils.g_install_mode = 'EMBEDDED'
1912: then
1913: i_string := 'begin
1914: fnd_profile.get('||'''ECX_OAG_LOGICALID'''||',ecx_utils.g_company_name);
1915: end;';
1916: execute immediate i_string ;
1917: else
1918: ecx_utils.g_company_name := wf_core.translate('ECX_OAG_LOGICALID');
1914: fnd_profile.get('||'''ECX_OAG_LOGICALID'''||',ecx_utils.g_company_name);
1915: end;';
1916: execute immediate i_string ;
1917: else
1918: ecx_utils.g_company_name := wf_core.translate('ECX_OAG_LOGICALID');
1919: end if;
1920: /*bug 10254870 getting no of xslt transformation defined for map*/
1921: ecx_utils.g_cnt_xslt_defined := ecx_actions.get_Count_Action_Type(30,5000);
1922: if (l_procedureEnabled) then
1917: else
1918: ecx_utils.g_company_name := wf_core.translate('ECX_OAG_LOGICALID');
1919: end if;
1920: /*bug 10254870 getting no of xslt transformation defined for map*/
1921: ecx_utils.g_cnt_xslt_defined := ecx_actions.get_Count_Action_Type(30,5000);
1922: if (l_procedureEnabled) then
1923: ecx_debug.pop(i_method_name);
1924: end if;
1925:
1932: if get_dtd%ISOPEN
1933: then
1934: close get_dtd;
1935: end if;
1936: ecx_utils.g_map_id := -1;
1937: ecx_utils.g_node_tbl.DELETE;
1938: raise program_exit;
1939:
1940: WHEN PROGRAM_EXIT then
1933: then
1934: close get_dtd;
1935: end if;
1936: ecx_utils.g_map_id := -1;
1937: ecx_utils.g_node_tbl.DELETE;
1938: raise program_exit;
1939:
1940: WHEN PROGRAM_EXIT then
1941: ecx_utils.g_map_id := -1;
1937: ecx_utils.g_node_tbl.DELETE;
1938: raise program_exit;
1939:
1940: WHEN PROGRAM_EXIT then
1941: ecx_utils.g_map_id := -1;
1942: ecx_utils.g_node_tbl.DELETE;
1943: if (l_procedureEnabled) then
1944: ecx_debug.pop(i_method_name);
1945: end if;
1938: raise program_exit;
1939:
1940: WHEN PROGRAM_EXIT then
1941: ecx_utils.g_map_id := -1;
1942: ecx_utils.g_node_tbl.DELETE;
1943: if (l_procedureEnabled) then
1944: ecx_debug.pop(i_method_name);
1945: end if;
1946: -- bug 8718549, free parser before program exit
1943: if (l_procedureEnabled) then
1944: ecx_debug.pop(i_method_name);
1945: end if;
1946: -- bug 8718549, free parser before program exit
1947: if (ecx_utils.g_parser.id is not null ) then
1948: xmlparser.freeparser(ecx_utils.g_parser);
1949: if(ecx_utils.dom_printing = false and ecx_utils.structure_printing = true
1950: and ecx_utils.g_inb_parser.id is not null) then
1951: xmlparser.freeparser(ecx_utils.g_inb_parser);
1944: ecx_debug.pop(i_method_name);
1945: end if;
1946: -- bug 8718549, free parser before program exit
1947: if (ecx_utils.g_parser.id is not null ) then
1948: xmlparser.freeparser(ecx_utils.g_parser);
1949: if(ecx_utils.dom_printing = false and ecx_utils.structure_printing = true
1950: and ecx_utils.g_inb_parser.id is not null) then
1951: xmlparser.freeparser(ecx_utils.g_inb_parser);
1952: end if;
1945: end if;
1946: -- bug 8718549, free parser before program exit
1947: if (ecx_utils.g_parser.id is not null ) then
1948: xmlparser.freeparser(ecx_utils.g_parser);
1949: if(ecx_utils.dom_printing = false and ecx_utils.structure_printing = true
1950: and ecx_utils.g_inb_parser.id is not null) then
1951: xmlparser.freeparser(ecx_utils.g_inb_parser);
1952: end if;
1953: end if;
1946: -- bug 8718549, free parser before program exit
1947: if (ecx_utils.g_parser.id is not null ) then
1948: xmlparser.freeparser(ecx_utils.g_parser);
1949: if(ecx_utils.dom_printing = false and ecx_utils.structure_printing = true
1950: and ecx_utils.g_inb_parser.id is not null) then
1951: xmlparser.freeparser(ecx_utils.g_inb_parser);
1952: end if;
1953: end if;
1954: -- bug 8718549
1947: if (ecx_utils.g_parser.id is not null ) then
1948: xmlparser.freeparser(ecx_utils.g_parser);
1949: if(ecx_utils.dom_printing = false and ecx_utils.structure_printing = true
1950: and ecx_utils.g_inb_parser.id is not null) then
1951: xmlparser.freeparser(ecx_utils.g_inb_parser);
1952: end if;
1953: end if;
1954: -- bug 8718549
1955: raise;
1956:
1957: WHEN OTHERS THEN
1958: if(l_unexpectedEnabled) then
1959: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR',i_method_name, 'PROGRESS_LEVEL',
1960: 'ecx_utils.INITIALIZE');
1961: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1962: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.INITIALIZE: ',
1963: i_method_name);
1964: end if;
1958: if(l_unexpectedEnabled) then
1959: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR',i_method_name, 'PROGRESS_LEVEL',
1960: 'ecx_utils.INITIALIZE');
1961: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1962: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.INITIALIZE: ',
1963: i_method_name);
1964: end if;
1965: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.INITIALIZE: ');
1966: ecx_utils.g_map_id := -1;
1961: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1962: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.INITIALIZE: ',
1963: i_method_name);
1964: end if;
1965: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.INITIALIZE: ');
1966: ecx_utils.g_map_id := -1;
1967: ecx_utils.g_node_tbl.DELETE;
1968: if (l_procedureEnabled) then
1969: ecx_debug.pop(i_method_name);
1962: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.INITIALIZE: ',
1963: i_method_name);
1964: end if;
1965: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.INITIALIZE: ');
1966: ecx_utils.g_map_id := -1;
1967: ecx_utils.g_node_tbl.DELETE;
1968: if (l_procedureEnabled) then
1969: ecx_debug.pop(i_method_name);
1970: end if;
1963: i_method_name);
1964: end if;
1965: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.INITIALIZE: ');
1966: ecx_utils.g_map_id := -1;
1967: ecx_utils.g_node_tbl.DELETE;
1968: if (l_procedureEnabled) then
1969: ecx_debug.pop(i_method_name);
1970: end if;
1971: raise PROGRAM_EXIT;
1973: end initialize;
1974:
1975: procedure close_process IS
1976:
1977: i_method_name varchar2(2000) := 'ecx_utils.close_process';
1978: i pls_integer;
1979: j pls_integer;
1980:
1981: -- bug 6922998
2014: end if;
2015: end loop;
2016: end if;
2017:
2018: IF (ecx_utils.g_procedure_list.count > 0) THEN
2019: j := ecx_utils.g_procedure_list.first;
2020: WHILE j IS NOT NULL LOOP
2021: if (ecx_utils.g_procedure_list(j).cursor_handle > 0) and
2022: (ecx_utils.g_procedure_list(j).cursor_handle is not null) and
2015: end loop;
2016: end if;
2017:
2018: IF (ecx_utils.g_procedure_list.count > 0) THEN
2019: j := ecx_utils.g_procedure_list.first;
2020: WHILE j IS NOT NULL LOOP
2021: if (ecx_utils.g_procedure_list(j).cursor_handle > 0) and
2022: (ecx_utils.g_procedure_list(j).cursor_handle is not null) and
2023: (not closed_cursors.EXISTS (ecx_utils.g_procedure_list(j).cursor_handle) )
2017:
2018: IF (ecx_utils.g_procedure_list.count > 0) THEN
2019: j := ecx_utils.g_procedure_list.first;
2020: WHILE j IS NOT NULL LOOP
2021: if (ecx_utils.g_procedure_list(j).cursor_handle > 0) and
2022: (ecx_utils.g_procedure_list(j).cursor_handle is not null) and
2023: (not closed_cursors.EXISTS (ecx_utils.g_procedure_list(j).cursor_handle) )
2024: then
2025: closed_cursors( ecx_utils.g_procedure_list(j).cursor_handle ) := -1;
2018: IF (ecx_utils.g_procedure_list.count > 0) THEN
2019: j := ecx_utils.g_procedure_list.first;
2020: WHILE j IS NOT NULL LOOP
2021: if (ecx_utils.g_procedure_list(j).cursor_handle > 0) and
2022: (ecx_utils.g_procedure_list(j).cursor_handle is not null) and
2023: (not closed_cursors.EXISTS (ecx_utils.g_procedure_list(j).cursor_handle) )
2024: then
2025: closed_cursors( ecx_utils.g_procedure_list(j).cursor_handle ) := -1;
2026: dbms_sql.close_cursor(ecx_utils.g_procedure_list(j).cursor_handle);
2019: j := ecx_utils.g_procedure_list.first;
2020: WHILE j IS NOT NULL LOOP
2021: if (ecx_utils.g_procedure_list(j).cursor_handle > 0) and
2022: (ecx_utils.g_procedure_list(j).cursor_handle is not null) and
2023: (not closed_cursors.EXISTS (ecx_utils.g_procedure_list(j).cursor_handle) )
2024: then
2025: closed_cursors( ecx_utils.g_procedure_list(j).cursor_handle ) := -1;
2026: dbms_sql.close_cursor(ecx_utils.g_procedure_list(j).cursor_handle);
2027: end if;
2021: if (ecx_utils.g_procedure_list(j).cursor_handle > 0) and
2022: (ecx_utils.g_procedure_list(j).cursor_handle is not null) and
2023: (not closed_cursors.EXISTS (ecx_utils.g_procedure_list(j).cursor_handle) )
2024: then
2025: closed_cursors( ecx_utils.g_procedure_list(j).cursor_handle ) := -1;
2026: dbms_sql.close_cursor(ecx_utils.g_procedure_list(j).cursor_handle);
2027: end if;
2028: j := ecx_utils.g_procedure_list.NEXT(j);
2029: end loop;
2022: (ecx_utils.g_procedure_list(j).cursor_handle is not null) and
2023: (not closed_cursors.EXISTS (ecx_utils.g_procedure_list(j).cursor_handle) )
2024: then
2025: closed_cursors( ecx_utils.g_procedure_list(j).cursor_handle ) := -1;
2026: dbms_sql.close_cursor(ecx_utils.g_procedure_list(j).cursor_handle);
2027: end if;
2028: j := ecx_utils.g_procedure_list.NEXT(j);
2029: end loop;
2030: END IF;
2024: then
2025: closed_cursors( ecx_utils.g_procedure_list(j).cursor_handle ) := -1;
2026: dbms_sql.close_cursor(ecx_utils.g_procedure_list(j).cursor_handle);
2027: end if;
2028: j := ecx_utils.g_procedure_list.NEXT(j);
2029: end loop;
2030: END IF;
2031:
2032: if (l_procedureEnabled) then
2036: EXCEPTION
2037: WHEN OTHERS THEN
2038: if(l_unexpectedEnabled) then
2039: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
2040: 'ecx_utils.CLOSE_PROCESS');
2041: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2042: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.CLOSE_PROCESS: ',
2043: i_method_name);
2044: end if;
2038: if(l_unexpectedEnabled) then
2039: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
2040: 'ecx_utils.CLOSE_PROCESS');
2041: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2042: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.CLOSE_PROCESS: ',
2043: i_method_name);
2044: end if;
2045: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.CLOSE_PROCESS: ');
2046: raise PROGRAM_EXIT;
2041: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2042: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.CLOSE_PROCESS: ',
2043: i_method_name);
2044: end if;
2045: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.CLOSE_PROCESS: ');
2046: raise PROGRAM_EXIT;
2047:
2048: end close_process;
2049:
2054: procedure get_tran_stage_data (
2055: i_map_id IN pls_integer)
2056: IS
2057:
2058: i_method_name varchar2(2000) := 'ecx_utils.get_tran_stage_data';
2059:
2060: /* TYPE stage_data_record is RECORD (
2061: transtage_id ecx_tran_stage_data.transtage_id%TYPE,
2062: object_level ecx_object_levels.object_level%TYPE,
2210: TYPE t_operand6_constant is TABLE of ecx_tran_stage_data.operand6_constant%TYPE;
2211:
2212:
2213: -- temp_stage_rec stage_data_record;
2214: temp_util_rec ecx_utils.stage_rec;
2215:
2216: v_transtage_id t_transtage_id;
2217: v_object_level t_object_level;
2218: v_objectlevel_id t_objectlevel_id;
2374: */
2375:
2376: i_counter pls_integer := 0;
2377: BEGIN
2378: ecx_utils.g_delete_doctype := false;
2379: if (l_procedureEnabled) then
2380: ecx_debug.push(i_method_name);
2381: end if;
2382: ecx_utils.g_stage_data.DELETE;
2378: ecx_utils.g_delete_doctype := false;
2379: if (l_procedureEnabled) then
2380: ecx_debug.push(i_method_name);
2381: end if;
2382: ecx_utils.g_stage_data.DELETE;
2383:
2384: select
2385: transtage_id,
2386: object_level ,
2454: operand6_name,
2455: operand6_pos,
2456: operand6_direction,
2457: operand6_constant
2458: -- bulk collect into ecx_utils.g_stage_data
2459: bulk collect into
2460: -- i_stage_data
2461: v_transtage_id,
2462: v_object_level,
2700: temp_util_rec.operand6_direction||'|'||
2701: temp_util_rec.operand6_constant, i_method_name
2702: );
2703: end if;
2704: ecx_utils.g_stage_data(i_counter) := temp_util_rec;
2705:
2706: i_counter := i_counter + 1;
2707: end loop;
2708: end if;
2710:
2711: /* for get_stage_data in stage_data (
2712: p_map_id => i_map_id) loop
2713:
2714: ecx_utils.g_stage_data(i_counter).transtage_id := get_stage_data.transtage_id;
2715: ecx_utils.g_stage_data(i_counter).level := get_stage_data.object_level;
2716: ecx_utils.g_stage_data(i_counter).stage := get_stage_data.stage;
2717: ecx_utils.g_stage_data(i_counter).object_direction := get_stage_data.object_direction;
2718: ecx_utils.g_stage_data(i_counter).seq_number := get_stage_data.seq_number;
2711: /* for get_stage_data in stage_data (
2712: p_map_id => i_map_id) loop
2713:
2714: ecx_utils.g_stage_data(i_counter).transtage_id := get_stage_data.transtage_id;
2715: ecx_utils.g_stage_data(i_counter).level := get_stage_data.object_level;
2716: ecx_utils.g_stage_data(i_counter).stage := get_stage_data.stage;
2717: ecx_utils.g_stage_data(i_counter).object_direction := get_stage_data.object_direction;
2718: ecx_utils.g_stage_data(i_counter).seq_number := get_stage_data.seq_number;
2719: ecx_utils.g_stage_data(i_counter).action_type := get_stage_data.action_type;
2712: p_map_id => i_map_id) loop
2713:
2714: ecx_utils.g_stage_data(i_counter).transtage_id := get_stage_data.transtage_id;
2715: ecx_utils.g_stage_data(i_counter).level := get_stage_data.object_level;
2716: ecx_utils.g_stage_data(i_counter).stage := get_stage_data.stage;
2717: ecx_utils.g_stage_data(i_counter).object_direction := get_stage_data.object_direction;
2718: ecx_utils.g_stage_data(i_counter).seq_number := get_stage_data.seq_number;
2719: ecx_utils.g_stage_data(i_counter).action_type := get_stage_data.action_type;
2720: ecx_utils.g_stage_data(i_counter).variable_level := get_stage_data.variable_level;
2713:
2714: ecx_utils.g_stage_data(i_counter).transtage_id := get_stage_data.transtage_id;
2715: ecx_utils.g_stage_data(i_counter).level := get_stage_data.object_level;
2716: ecx_utils.g_stage_data(i_counter).stage := get_stage_data.stage;
2717: ecx_utils.g_stage_data(i_counter).object_direction := get_stage_data.object_direction;
2718: ecx_utils.g_stage_data(i_counter).seq_number := get_stage_data.seq_number;
2719: ecx_utils.g_stage_data(i_counter).action_type := get_stage_data.action_type;
2720: ecx_utils.g_stage_data(i_counter).variable_level := get_stage_data.variable_level;
2721: ecx_utils.g_stage_data(i_counter).variable_name := get_stage_data.variable_name;
2714: ecx_utils.g_stage_data(i_counter).transtage_id := get_stage_data.transtage_id;
2715: ecx_utils.g_stage_data(i_counter).level := get_stage_data.object_level;
2716: ecx_utils.g_stage_data(i_counter).stage := get_stage_data.stage;
2717: ecx_utils.g_stage_data(i_counter).object_direction := get_stage_data.object_direction;
2718: ecx_utils.g_stage_data(i_counter).seq_number := get_stage_data.seq_number;
2719: ecx_utils.g_stage_data(i_counter).action_type := get_stage_data.action_type;
2720: ecx_utils.g_stage_data(i_counter).variable_level := get_stage_data.variable_level;
2721: ecx_utils.g_stage_data(i_counter).variable_name := get_stage_data.variable_name;
2722: ecx_utils.g_stage_data(i_counter).variable_pos := get_stage_data.variable_pos;
2715: ecx_utils.g_stage_data(i_counter).level := get_stage_data.object_level;
2716: ecx_utils.g_stage_data(i_counter).stage := get_stage_data.stage;
2717: ecx_utils.g_stage_data(i_counter).object_direction := get_stage_data.object_direction;
2718: ecx_utils.g_stage_data(i_counter).seq_number := get_stage_data.seq_number;
2719: ecx_utils.g_stage_data(i_counter).action_type := get_stage_data.action_type;
2720: ecx_utils.g_stage_data(i_counter).variable_level := get_stage_data.variable_level;
2721: ecx_utils.g_stage_data(i_counter).variable_name := get_stage_data.variable_name;
2722: ecx_utils.g_stage_data(i_counter).variable_pos := get_stage_data.variable_pos;
2723: ecx_utils.g_stage_data(i_counter).variable_direction := get_stage_data.variable_direction;
2716: ecx_utils.g_stage_data(i_counter).stage := get_stage_data.stage;
2717: ecx_utils.g_stage_data(i_counter).object_direction := get_stage_data.object_direction;
2718: ecx_utils.g_stage_data(i_counter).seq_number := get_stage_data.seq_number;
2719: ecx_utils.g_stage_data(i_counter).action_type := get_stage_data.action_type;
2720: ecx_utils.g_stage_data(i_counter).variable_level := get_stage_data.variable_level;
2721: ecx_utils.g_stage_data(i_counter).variable_name := get_stage_data.variable_name;
2722: ecx_utils.g_stage_data(i_counter).variable_pos := get_stage_data.variable_pos;
2723: ecx_utils.g_stage_data(i_counter).variable_direction := get_stage_data.variable_direction;
2724: ecx_utils.g_stage_data(i_counter).variable_value := get_stage_data.variable_value;
2717: ecx_utils.g_stage_data(i_counter).object_direction := get_stage_data.object_direction;
2718: ecx_utils.g_stage_data(i_counter).seq_number := get_stage_data.seq_number;
2719: ecx_utils.g_stage_data(i_counter).action_type := get_stage_data.action_type;
2720: ecx_utils.g_stage_data(i_counter).variable_level := get_stage_data.variable_level;
2721: ecx_utils.g_stage_data(i_counter).variable_name := get_stage_data.variable_name;
2722: ecx_utils.g_stage_data(i_counter).variable_pos := get_stage_data.variable_pos;
2723: ecx_utils.g_stage_data(i_counter).variable_direction := get_stage_data.variable_direction;
2724: ecx_utils.g_stage_data(i_counter).variable_value := get_stage_data.variable_value;
2725: ecx_utils.g_stage_data(i_counter).default_value := get_stage_data.default_value;
2718: ecx_utils.g_stage_data(i_counter).seq_number := get_stage_data.seq_number;
2719: ecx_utils.g_stage_data(i_counter).action_type := get_stage_data.action_type;
2720: ecx_utils.g_stage_data(i_counter).variable_level := get_stage_data.variable_level;
2721: ecx_utils.g_stage_data(i_counter).variable_name := get_stage_data.variable_name;
2722: ecx_utils.g_stage_data(i_counter).variable_pos := get_stage_data.variable_pos;
2723: ecx_utils.g_stage_data(i_counter).variable_direction := get_stage_data.variable_direction;
2724: ecx_utils.g_stage_data(i_counter).variable_value := get_stage_data.variable_value;
2725: ecx_utils.g_stage_data(i_counter).default_value := get_stage_data.default_value;
2726: ecx_utils.g_stage_data(i_counter).sequence_name := get_stage_data.sequence_name;
2719: ecx_utils.g_stage_data(i_counter).action_type := get_stage_data.action_type;
2720: ecx_utils.g_stage_data(i_counter).variable_level := get_stage_data.variable_level;
2721: ecx_utils.g_stage_data(i_counter).variable_name := get_stage_data.variable_name;
2722: ecx_utils.g_stage_data(i_counter).variable_pos := get_stage_data.variable_pos;
2723: ecx_utils.g_stage_data(i_counter).variable_direction := get_stage_data.variable_direction;
2724: ecx_utils.g_stage_data(i_counter).variable_value := get_stage_data.variable_value;
2725: ecx_utils.g_stage_data(i_counter).default_value := get_stage_data.default_value;
2726: ecx_utils.g_stage_data(i_counter).sequence_name := get_stage_data.sequence_name;
2727: ecx_utils.g_stage_data(i_counter).custom_procedure_name := get_stage_data.custom_procedure_name;
2720: ecx_utils.g_stage_data(i_counter).variable_level := get_stage_data.variable_level;
2721: ecx_utils.g_stage_data(i_counter).variable_name := get_stage_data.variable_name;
2722: ecx_utils.g_stage_data(i_counter).variable_pos := get_stage_data.variable_pos;
2723: ecx_utils.g_stage_data(i_counter).variable_direction := get_stage_data.variable_direction;
2724: ecx_utils.g_stage_data(i_counter).variable_value := get_stage_data.variable_value;
2725: ecx_utils.g_stage_data(i_counter).default_value := get_stage_data.default_value;
2726: ecx_utils.g_stage_data(i_counter).sequence_name := get_stage_data.sequence_name;
2727: ecx_utils.g_stage_data(i_counter).custom_procedure_name := get_stage_data.custom_procedure_name;
2728: ecx_utils.g_stage_data(i_counter).data_type := get_stage_data.data_type;
2721: ecx_utils.g_stage_data(i_counter).variable_name := get_stage_data.variable_name;
2722: ecx_utils.g_stage_data(i_counter).variable_pos := get_stage_data.variable_pos;
2723: ecx_utils.g_stage_data(i_counter).variable_direction := get_stage_data.variable_direction;
2724: ecx_utils.g_stage_data(i_counter).variable_value := get_stage_data.variable_value;
2725: ecx_utils.g_stage_data(i_counter).default_value := get_stage_data.default_value;
2726: ecx_utils.g_stage_data(i_counter).sequence_name := get_stage_data.sequence_name;
2727: ecx_utils.g_stage_data(i_counter).custom_procedure_name := get_stage_data.custom_procedure_name;
2728: ecx_utils.g_stage_data(i_counter).data_type := get_stage_data.data_type;
2729: ecx_utils.g_stage_data(i_counter).function_name := get_stage_data.function_name;
2722: ecx_utils.g_stage_data(i_counter).variable_pos := get_stage_data.variable_pos;
2723: ecx_utils.g_stage_data(i_counter).variable_direction := get_stage_data.variable_direction;
2724: ecx_utils.g_stage_data(i_counter).variable_value := get_stage_data.variable_value;
2725: ecx_utils.g_stage_data(i_counter).default_value := get_stage_data.default_value;
2726: ecx_utils.g_stage_data(i_counter).sequence_name := get_stage_data.sequence_name;
2727: ecx_utils.g_stage_data(i_counter).custom_procedure_name := get_stage_data.custom_procedure_name;
2728: ecx_utils.g_stage_data(i_counter).data_type := get_stage_data.data_type;
2729: ecx_utils.g_stage_data(i_counter).function_name := get_stage_data.function_name;
2730: ecx_utils.g_stage_data(i_counter).clause := get_stage_data.where_clause;
2723: ecx_utils.g_stage_data(i_counter).variable_direction := get_stage_data.variable_direction;
2724: ecx_utils.g_stage_data(i_counter).variable_value := get_stage_data.variable_value;
2725: ecx_utils.g_stage_data(i_counter).default_value := get_stage_data.default_value;
2726: ecx_utils.g_stage_data(i_counter).sequence_name := get_stage_data.sequence_name;
2727: ecx_utils.g_stage_data(i_counter).custom_procedure_name := get_stage_data.custom_procedure_name;
2728: ecx_utils.g_stage_data(i_counter).data_type := get_stage_data.data_type;
2729: ecx_utils.g_stage_data(i_counter).function_name := get_stage_data.function_name;
2730: ecx_utils.g_stage_data(i_counter).clause := get_stage_data.where_clause;
2731: ecx_utils.g_stage_data(i_counter).cond_logical_operator := get_stage_data.cond_logical_operator;
2724: ecx_utils.g_stage_data(i_counter).variable_value := get_stage_data.variable_value;
2725: ecx_utils.g_stage_data(i_counter).default_value := get_stage_data.default_value;
2726: ecx_utils.g_stage_data(i_counter).sequence_name := get_stage_data.sequence_name;
2727: ecx_utils.g_stage_data(i_counter).custom_procedure_name := get_stage_data.custom_procedure_name;
2728: ecx_utils.g_stage_data(i_counter).data_type := get_stage_data.data_type;
2729: ecx_utils.g_stage_data(i_counter).function_name := get_stage_data.function_name;
2730: ecx_utils.g_stage_data(i_counter).clause := get_stage_data.where_clause;
2731: ecx_utils.g_stage_data(i_counter).cond_logical_operator := get_stage_data.cond_logical_operator;
2732: ecx_utils.g_stage_data(i_counter).cond_operator1 := get_stage_data.cond_operator1;
2725: ecx_utils.g_stage_data(i_counter).default_value := get_stage_data.default_value;
2726: ecx_utils.g_stage_data(i_counter).sequence_name := get_stage_data.sequence_name;
2727: ecx_utils.g_stage_data(i_counter).custom_procedure_name := get_stage_data.custom_procedure_name;
2728: ecx_utils.g_stage_data(i_counter).data_type := get_stage_data.data_type;
2729: ecx_utils.g_stage_data(i_counter).function_name := get_stage_data.function_name;
2730: ecx_utils.g_stage_data(i_counter).clause := get_stage_data.where_clause;
2731: ecx_utils.g_stage_data(i_counter).cond_logical_operator := get_stage_data.cond_logical_operator;
2732: ecx_utils.g_stage_data(i_counter).cond_operator1 := get_stage_data.cond_operator1;
2733: ecx_utils.g_stage_data(i_counter).cond_var1_level := get_stage_data.cond_var1_level;
2726: ecx_utils.g_stage_data(i_counter).sequence_name := get_stage_data.sequence_name;
2727: ecx_utils.g_stage_data(i_counter).custom_procedure_name := get_stage_data.custom_procedure_name;
2728: ecx_utils.g_stage_data(i_counter).data_type := get_stage_data.data_type;
2729: ecx_utils.g_stage_data(i_counter).function_name := get_stage_data.function_name;
2730: ecx_utils.g_stage_data(i_counter).clause := get_stage_data.where_clause;
2731: ecx_utils.g_stage_data(i_counter).cond_logical_operator := get_stage_data.cond_logical_operator;
2732: ecx_utils.g_stage_data(i_counter).cond_operator1 := get_stage_data.cond_operator1;
2733: ecx_utils.g_stage_data(i_counter).cond_var1_level := get_stage_data.cond_var1_level;
2734: ecx_utils.g_stage_data(i_counter).cond_var1_name := get_stage_data.cond_var1_name;
2727: ecx_utils.g_stage_data(i_counter).custom_procedure_name := get_stage_data.custom_procedure_name;
2728: ecx_utils.g_stage_data(i_counter).data_type := get_stage_data.data_type;
2729: ecx_utils.g_stage_data(i_counter).function_name := get_stage_data.function_name;
2730: ecx_utils.g_stage_data(i_counter).clause := get_stage_data.where_clause;
2731: ecx_utils.g_stage_data(i_counter).cond_logical_operator := get_stage_data.cond_logical_operator;
2732: ecx_utils.g_stage_data(i_counter).cond_operator1 := get_stage_data.cond_operator1;
2733: ecx_utils.g_stage_data(i_counter).cond_var1_level := get_stage_data.cond_var1_level;
2734: ecx_utils.g_stage_data(i_counter).cond_var1_name := get_stage_data.cond_var1_name;
2735: ecx_utils.g_stage_data(i_counter).cond_var1_pos := get_stage_data.cond_var1_pos;
2728: ecx_utils.g_stage_data(i_counter).data_type := get_stage_data.data_type;
2729: ecx_utils.g_stage_data(i_counter).function_name := get_stage_data.function_name;
2730: ecx_utils.g_stage_data(i_counter).clause := get_stage_data.where_clause;
2731: ecx_utils.g_stage_data(i_counter).cond_logical_operator := get_stage_data.cond_logical_operator;
2732: ecx_utils.g_stage_data(i_counter).cond_operator1 := get_stage_data.cond_operator1;
2733: ecx_utils.g_stage_data(i_counter).cond_var1_level := get_stage_data.cond_var1_level;
2734: ecx_utils.g_stage_data(i_counter).cond_var1_name := get_stage_data.cond_var1_name;
2735: ecx_utils.g_stage_data(i_counter).cond_var1_pos := get_stage_data.cond_var1_pos;
2736: ecx_utils.g_stage_data(i_counter).cond_var1_direction := get_stage_data.cond_var1_direction;
2729: ecx_utils.g_stage_data(i_counter).function_name := get_stage_data.function_name;
2730: ecx_utils.g_stage_data(i_counter).clause := get_stage_data.where_clause;
2731: ecx_utils.g_stage_data(i_counter).cond_logical_operator := get_stage_data.cond_logical_operator;
2732: ecx_utils.g_stage_data(i_counter).cond_operator1 := get_stage_data.cond_operator1;
2733: ecx_utils.g_stage_data(i_counter).cond_var1_level := get_stage_data.cond_var1_level;
2734: ecx_utils.g_stage_data(i_counter).cond_var1_name := get_stage_data.cond_var1_name;
2735: ecx_utils.g_stage_data(i_counter).cond_var1_pos := get_stage_data.cond_var1_pos;
2736: ecx_utils.g_stage_data(i_counter).cond_var1_direction := get_stage_data.cond_var1_direction;
2737: ecx_utils.g_stage_data(i_counter).cond_var1_constant := get_stage_data.cond_var1_constant;
2730: ecx_utils.g_stage_data(i_counter).clause := get_stage_data.where_clause;
2731: ecx_utils.g_stage_data(i_counter).cond_logical_operator := get_stage_data.cond_logical_operator;
2732: ecx_utils.g_stage_data(i_counter).cond_operator1 := get_stage_data.cond_operator1;
2733: ecx_utils.g_stage_data(i_counter).cond_var1_level := get_stage_data.cond_var1_level;
2734: ecx_utils.g_stage_data(i_counter).cond_var1_name := get_stage_data.cond_var1_name;
2735: ecx_utils.g_stage_data(i_counter).cond_var1_pos := get_stage_data.cond_var1_pos;
2736: ecx_utils.g_stage_data(i_counter).cond_var1_direction := get_stage_data.cond_var1_direction;
2737: ecx_utils.g_stage_data(i_counter).cond_var1_constant := get_stage_data.cond_var1_constant;
2738: ecx_utils.g_stage_data(i_counter).cond_val1_level := get_stage_data.cond_val1_level;
2731: ecx_utils.g_stage_data(i_counter).cond_logical_operator := get_stage_data.cond_logical_operator;
2732: ecx_utils.g_stage_data(i_counter).cond_operator1 := get_stage_data.cond_operator1;
2733: ecx_utils.g_stage_data(i_counter).cond_var1_level := get_stage_data.cond_var1_level;
2734: ecx_utils.g_stage_data(i_counter).cond_var1_name := get_stage_data.cond_var1_name;
2735: ecx_utils.g_stage_data(i_counter).cond_var1_pos := get_stage_data.cond_var1_pos;
2736: ecx_utils.g_stage_data(i_counter).cond_var1_direction := get_stage_data.cond_var1_direction;
2737: ecx_utils.g_stage_data(i_counter).cond_var1_constant := get_stage_data.cond_var1_constant;
2738: ecx_utils.g_stage_data(i_counter).cond_val1_level := get_stage_data.cond_val1_level;
2739: ecx_utils.g_stage_data(i_counter).cond_val1_name := get_stage_data.cond_val1_name;
2732: ecx_utils.g_stage_data(i_counter).cond_operator1 := get_stage_data.cond_operator1;
2733: ecx_utils.g_stage_data(i_counter).cond_var1_level := get_stage_data.cond_var1_level;
2734: ecx_utils.g_stage_data(i_counter).cond_var1_name := get_stage_data.cond_var1_name;
2735: ecx_utils.g_stage_data(i_counter).cond_var1_pos := get_stage_data.cond_var1_pos;
2736: ecx_utils.g_stage_data(i_counter).cond_var1_direction := get_stage_data.cond_var1_direction;
2737: ecx_utils.g_stage_data(i_counter).cond_var1_constant := get_stage_data.cond_var1_constant;
2738: ecx_utils.g_stage_data(i_counter).cond_val1_level := get_stage_data.cond_val1_level;
2739: ecx_utils.g_stage_data(i_counter).cond_val1_name := get_stage_data.cond_val1_name;
2740: ecx_utils.g_stage_data(i_counter).cond_val1_pos := get_stage_data.cond_val1_pos;
2733: ecx_utils.g_stage_data(i_counter).cond_var1_level := get_stage_data.cond_var1_level;
2734: ecx_utils.g_stage_data(i_counter).cond_var1_name := get_stage_data.cond_var1_name;
2735: ecx_utils.g_stage_data(i_counter).cond_var1_pos := get_stage_data.cond_var1_pos;
2736: ecx_utils.g_stage_data(i_counter).cond_var1_direction := get_stage_data.cond_var1_direction;
2737: ecx_utils.g_stage_data(i_counter).cond_var1_constant := get_stage_data.cond_var1_constant;
2738: ecx_utils.g_stage_data(i_counter).cond_val1_level := get_stage_data.cond_val1_level;
2739: ecx_utils.g_stage_data(i_counter).cond_val1_name := get_stage_data.cond_val1_name;
2740: ecx_utils.g_stage_data(i_counter).cond_val1_pos := get_stage_data.cond_val1_pos;
2741: ecx_utils.g_stage_data(i_counter).cond_val1_direction := get_stage_data.cond_val1_direction;
2734: ecx_utils.g_stage_data(i_counter).cond_var1_name := get_stage_data.cond_var1_name;
2735: ecx_utils.g_stage_data(i_counter).cond_var1_pos := get_stage_data.cond_var1_pos;
2736: ecx_utils.g_stage_data(i_counter).cond_var1_direction := get_stage_data.cond_var1_direction;
2737: ecx_utils.g_stage_data(i_counter).cond_var1_constant := get_stage_data.cond_var1_constant;
2738: ecx_utils.g_stage_data(i_counter).cond_val1_level := get_stage_data.cond_val1_level;
2739: ecx_utils.g_stage_data(i_counter).cond_val1_name := get_stage_data.cond_val1_name;
2740: ecx_utils.g_stage_data(i_counter).cond_val1_pos := get_stage_data.cond_val1_pos;
2741: ecx_utils.g_stage_data(i_counter).cond_val1_direction := get_stage_data.cond_val1_direction;
2742: ecx_utils.g_stage_data(i_counter).cond_val1_constant := get_stage_data.cond_val1_constant;
2735: ecx_utils.g_stage_data(i_counter).cond_var1_pos := get_stage_data.cond_var1_pos;
2736: ecx_utils.g_stage_data(i_counter).cond_var1_direction := get_stage_data.cond_var1_direction;
2737: ecx_utils.g_stage_data(i_counter).cond_var1_constant := get_stage_data.cond_var1_constant;
2738: ecx_utils.g_stage_data(i_counter).cond_val1_level := get_stage_data.cond_val1_level;
2739: ecx_utils.g_stage_data(i_counter).cond_val1_name := get_stage_data.cond_val1_name;
2740: ecx_utils.g_stage_data(i_counter).cond_val1_pos := get_stage_data.cond_val1_pos;
2741: ecx_utils.g_stage_data(i_counter).cond_val1_direction := get_stage_data.cond_val1_direction;
2742: ecx_utils.g_stage_data(i_counter).cond_val1_constant := get_stage_data.cond_val1_constant;
2743: ecx_utils.g_stage_data(i_counter).cond_operator2 := get_stage_data.cond_operator2;
2736: ecx_utils.g_stage_data(i_counter).cond_var1_direction := get_stage_data.cond_var1_direction;
2737: ecx_utils.g_stage_data(i_counter).cond_var1_constant := get_stage_data.cond_var1_constant;
2738: ecx_utils.g_stage_data(i_counter).cond_val1_level := get_stage_data.cond_val1_level;
2739: ecx_utils.g_stage_data(i_counter).cond_val1_name := get_stage_data.cond_val1_name;
2740: ecx_utils.g_stage_data(i_counter).cond_val1_pos := get_stage_data.cond_val1_pos;
2741: ecx_utils.g_stage_data(i_counter).cond_val1_direction := get_stage_data.cond_val1_direction;
2742: ecx_utils.g_stage_data(i_counter).cond_val1_constant := get_stage_data.cond_val1_constant;
2743: ecx_utils.g_stage_data(i_counter).cond_operator2 := get_stage_data.cond_operator2;
2744: ecx_utils.g_stage_data(i_counter).cond_var2_level := get_stage_data.cond_var2_level;
2737: ecx_utils.g_stage_data(i_counter).cond_var1_constant := get_stage_data.cond_var1_constant;
2738: ecx_utils.g_stage_data(i_counter).cond_val1_level := get_stage_data.cond_val1_level;
2739: ecx_utils.g_stage_data(i_counter).cond_val1_name := get_stage_data.cond_val1_name;
2740: ecx_utils.g_stage_data(i_counter).cond_val1_pos := get_stage_data.cond_val1_pos;
2741: ecx_utils.g_stage_data(i_counter).cond_val1_direction := get_stage_data.cond_val1_direction;
2742: ecx_utils.g_stage_data(i_counter).cond_val1_constant := get_stage_data.cond_val1_constant;
2743: ecx_utils.g_stage_data(i_counter).cond_operator2 := get_stage_data.cond_operator2;
2744: ecx_utils.g_stage_data(i_counter).cond_var2_level := get_stage_data.cond_var2_level;
2745: ecx_utils.g_stage_data(i_counter).cond_var2_name := get_stage_data.cond_var2_name;
2738: ecx_utils.g_stage_data(i_counter).cond_val1_level := get_stage_data.cond_val1_level;
2739: ecx_utils.g_stage_data(i_counter).cond_val1_name := get_stage_data.cond_val1_name;
2740: ecx_utils.g_stage_data(i_counter).cond_val1_pos := get_stage_data.cond_val1_pos;
2741: ecx_utils.g_stage_data(i_counter).cond_val1_direction := get_stage_data.cond_val1_direction;
2742: ecx_utils.g_stage_data(i_counter).cond_val1_constant := get_stage_data.cond_val1_constant;
2743: ecx_utils.g_stage_data(i_counter).cond_operator2 := get_stage_data.cond_operator2;
2744: ecx_utils.g_stage_data(i_counter).cond_var2_level := get_stage_data.cond_var2_level;
2745: ecx_utils.g_stage_data(i_counter).cond_var2_name := get_stage_data.cond_var2_name;
2746: ecx_utils.g_stage_data(i_counter).cond_var2_pos := get_stage_data.cond_var2_pos;
2739: ecx_utils.g_stage_data(i_counter).cond_val1_name := get_stage_data.cond_val1_name;
2740: ecx_utils.g_stage_data(i_counter).cond_val1_pos := get_stage_data.cond_val1_pos;
2741: ecx_utils.g_stage_data(i_counter).cond_val1_direction := get_stage_data.cond_val1_direction;
2742: ecx_utils.g_stage_data(i_counter).cond_val1_constant := get_stage_data.cond_val1_constant;
2743: ecx_utils.g_stage_data(i_counter).cond_operator2 := get_stage_data.cond_operator2;
2744: ecx_utils.g_stage_data(i_counter).cond_var2_level := get_stage_data.cond_var2_level;
2745: ecx_utils.g_stage_data(i_counter).cond_var2_name := get_stage_data.cond_var2_name;
2746: ecx_utils.g_stage_data(i_counter).cond_var2_pos := get_stage_data.cond_var2_pos;
2747: ecx_utils.g_stage_data(i_counter).cond_var2_direction := get_stage_data.cond_var2_direction;
2740: ecx_utils.g_stage_data(i_counter).cond_val1_pos := get_stage_data.cond_val1_pos;
2741: ecx_utils.g_stage_data(i_counter).cond_val1_direction := get_stage_data.cond_val1_direction;
2742: ecx_utils.g_stage_data(i_counter).cond_val1_constant := get_stage_data.cond_val1_constant;
2743: ecx_utils.g_stage_data(i_counter).cond_operator2 := get_stage_data.cond_operator2;
2744: ecx_utils.g_stage_data(i_counter).cond_var2_level := get_stage_data.cond_var2_level;
2745: ecx_utils.g_stage_data(i_counter).cond_var2_name := get_stage_data.cond_var2_name;
2746: ecx_utils.g_stage_data(i_counter).cond_var2_pos := get_stage_data.cond_var2_pos;
2747: ecx_utils.g_stage_data(i_counter).cond_var2_direction := get_stage_data.cond_var2_direction;
2748: ecx_utils.g_stage_data(i_counter).cond_var2_constant := get_stage_data.cond_var2_constant;
2741: ecx_utils.g_stage_data(i_counter).cond_val1_direction := get_stage_data.cond_val1_direction;
2742: ecx_utils.g_stage_data(i_counter).cond_val1_constant := get_stage_data.cond_val1_constant;
2743: ecx_utils.g_stage_data(i_counter).cond_operator2 := get_stage_data.cond_operator2;
2744: ecx_utils.g_stage_data(i_counter).cond_var2_level := get_stage_data.cond_var2_level;
2745: ecx_utils.g_stage_data(i_counter).cond_var2_name := get_stage_data.cond_var2_name;
2746: ecx_utils.g_stage_data(i_counter).cond_var2_pos := get_stage_data.cond_var2_pos;
2747: ecx_utils.g_stage_data(i_counter).cond_var2_direction := get_stage_data.cond_var2_direction;
2748: ecx_utils.g_stage_data(i_counter).cond_var2_constant := get_stage_data.cond_var2_constant;
2749: ecx_utils.g_stage_data(i_counter).cond_val2_level := get_stage_data.cond_val2_level;
2742: ecx_utils.g_stage_data(i_counter).cond_val1_constant := get_stage_data.cond_val1_constant;
2743: ecx_utils.g_stage_data(i_counter).cond_operator2 := get_stage_data.cond_operator2;
2744: ecx_utils.g_stage_data(i_counter).cond_var2_level := get_stage_data.cond_var2_level;
2745: ecx_utils.g_stage_data(i_counter).cond_var2_name := get_stage_data.cond_var2_name;
2746: ecx_utils.g_stage_data(i_counter).cond_var2_pos := get_stage_data.cond_var2_pos;
2747: ecx_utils.g_stage_data(i_counter).cond_var2_direction := get_stage_data.cond_var2_direction;
2748: ecx_utils.g_stage_data(i_counter).cond_var2_constant := get_stage_data.cond_var2_constant;
2749: ecx_utils.g_stage_data(i_counter).cond_val2_level := get_stage_data.cond_val2_level;
2750: ecx_utils.g_stage_data(i_counter).cond_val2_name := get_stage_data.cond_val2_name;
2743: ecx_utils.g_stage_data(i_counter).cond_operator2 := get_stage_data.cond_operator2;
2744: ecx_utils.g_stage_data(i_counter).cond_var2_level := get_stage_data.cond_var2_level;
2745: ecx_utils.g_stage_data(i_counter).cond_var2_name := get_stage_data.cond_var2_name;
2746: ecx_utils.g_stage_data(i_counter).cond_var2_pos := get_stage_data.cond_var2_pos;
2747: ecx_utils.g_stage_data(i_counter).cond_var2_direction := get_stage_data.cond_var2_direction;
2748: ecx_utils.g_stage_data(i_counter).cond_var2_constant := get_stage_data.cond_var2_constant;
2749: ecx_utils.g_stage_data(i_counter).cond_val2_level := get_stage_data.cond_val2_level;
2750: ecx_utils.g_stage_data(i_counter).cond_val2_name := get_stage_data.cond_val2_name;
2751: ecx_utils.g_stage_data(i_counter).cond_val2_pos := get_stage_data.cond_val2_pos;
2744: ecx_utils.g_stage_data(i_counter).cond_var2_level := get_stage_data.cond_var2_level;
2745: ecx_utils.g_stage_data(i_counter).cond_var2_name := get_stage_data.cond_var2_name;
2746: ecx_utils.g_stage_data(i_counter).cond_var2_pos := get_stage_data.cond_var2_pos;
2747: ecx_utils.g_stage_data(i_counter).cond_var2_direction := get_stage_data.cond_var2_direction;
2748: ecx_utils.g_stage_data(i_counter).cond_var2_constant := get_stage_data.cond_var2_constant;
2749: ecx_utils.g_stage_data(i_counter).cond_val2_level := get_stage_data.cond_val2_level;
2750: ecx_utils.g_stage_data(i_counter).cond_val2_name := get_stage_data.cond_val2_name;
2751: ecx_utils.g_stage_data(i_counter).cond_val2_pos := get_stage_data.cond_val2_pos;
2752: ecx_utils.g_stage_data(i_counter).cond_val2_direction := get_stage_data.cond_val2_direction;
2745: ecx_utils.g_stage_data(i_counter).cond_var2_name := get_stage_data.cond_var2_name;
2746: ecx_utils.g_stage_data(i_counter).cond_var2_pos := get_stage_data.cond_var2_pos;
2747: ecx_utils.g_stage_data(i_counter).cond_var2_direction := get_stage_data.cond_var2_direction;
2748: ecx_utils.g_stage_data(i_counter).cond_var2_constant := get_stage_data.cond_var2_constant;
2749: ecx_utils.g_stage_data(i_counter).cond_val2_level := get_stage_data.cond_val2_level;
2750: ecx_utils.g_stage_data(i_counter).cond_val2_name := get_stage_data.cond_val2_name;
2751: ecx_utils.g_stage_data(i_counter).cond_val2_pos := get_stage_data.cond_val2_pos;
2752: ecx_utils.g_stage_data(i_counter).cond_val2_direction := get_stage_data.cond_val2_direction;
2753: ecx_utils.g_stage_data(i_counter).cond_val2_constant := get_stage_data.cond_val2_constant;
2746: ecx_utils.g_stage_data(i_counter).cond_var2_pos := get_stage_data.cond_var2_pos;
2747: ecx_utils.g_stage_data(i_counter).cond_var2_direction := get_stage_data.cond_var2_direction;
2748: ecx_utils.g_stage_data(i_counter).cond_var2_constant := get_stage_data.cond_var2_constant;
2749: ecx_utils.g_stage_data(i_counter).cond_val2_level := get_stage_data.cond_val2_level;
2750: ecx_utils.g_stage_data(i_counter).cond_val2_name := get_stage_data.cond_val2_name;
2751: ecx_utils.g_stage_data(i_counter).cond_val2_pos := get_stage_data.cond_val2_pos;
2752: ecx_utils.g_stage_data(i_counter).cond_val2_direction := get_stage_data.cond_val2_direction;
2753: ecx_utils.g_stage_data(i_counter).cond_val2_constant := get_stage_data.cond_val2_constant;
2754: ecx_utils.g_stage_data(i_counter).operand1_level := get_stage_data.operand1_level;
2747: ecx_utils.g_stage_data(i_counter).cond_var2_direction := get_stage_data.cond_var2_direction;
2748: ecx_utils.g_stage_data(i_counter).cond_var2_constant := get_stage_data.cond_var2_constant;
2749: ecx_utils.g_stage_data(i_counter).cond_val2_level := get_stage_data.cond_val2_level;
2750: ecx_utils.g_stage_data(i_counter).cond_val2_name := get_stage_data.cond_val2_name;
2751: ecx_utils.g_stage_data(i_counter).cond_val2_pos := get_stage_data.cond_val2_pos;
2752: ecx_utils.g_stage_data(i_counter).cond_val2_direction := get_stage_data.cond_val2_direction;
2753: ecx_utils.g_stage_data(i_counter).cond_val2_constant := get_stage_data.cond_val2_constant;
2754: ecx_utils.g_stage_data(i_counter).operand1_level := get_stage_data.operand1_level;
2755: ecx_utils.g_stage_data(i_counter).operand1_name := get_stage_data.operand1_name;
2748: ecx_utils.g_stage_data(i_counter).cond_var2_constant := get_stage_data.cond_var2_constant;
2749: ecx_utils.g_stage_data(i_counter).cond_val2_level := get_stage_data.cond_val2_level;
2750: ecx_utils.g_stage_data(i_counter).cond_val2_name := get_stage_data.cond_val2_name;
2751: ecx_utils.g_stage_data(i_counter).cond_val2_pos := get_stage_data.cond_val2_pos;
2752: ecx_utils.g_stage_data(i_counter).cond_val2_direction := get_stage_data.cond_val2_direction;
2753: ecx_utils.g_stage_data(i_counter).cond_val2_constant := get_stage_data.cond_val2_constant;
2754: ecx_utils.g_stage_data(i_counter).operand1_level := get_stage_data.operand1_level;
2755: ecx_utils.g_stage_data(i_counter).operand1_name := get_stage_data.operand1_name;
2756: ecx_utils.g_stage_data(i_counter).operand1_pos := get_stage_data.operand1_pos;
2749: ecx_utils.g_stage_data(i_counter).cond_val2_level := get_stage_data.cond_val2_level;
2750: ecx_utils.g_stage_data(i_counter).cond_val2_name := get_stage_data.cond_val2_name;
2751: ecx_utils.g_stage_data(i_counter).cond_val2_pos := get_stage_data.cond_val2_pos;
2752: ecx_utils.g_stage_data(i_counter).cond_val2_direction := get_stage_data.cond_val2_direction;
2753: ecx_utils.g_stage_data(i_counter).cond_val2_constant := get_stage_data.cond_val2_constant;
2754: ecx_utils.g_stage_data(i_counter).operand1_level := get_stage_data.operand1_level;
2755: ecx_utils.g_stage_data(i_counter).operand1_name := get_stage_data.operand1_name;
2756: ecx_utils.g_stage_data(i_counter).operand1_pos := get_stage_data.operand1_pos;
2757: ecx_utils.g_stage_data(i_counter).operand1_direction := get_stage_data.operand1_direction;
2750: ecx_utils.g_stage_data(i_counter).cond_val2_name := get_stage_data.cond_val2_name;
2751: ecx_utils.g_stage_data(i_counter).cond_val2_pos := get_stage_data.cond_val2_pos;
2752: ecx_utils.g_stage_data(i_counter).cond_val2_direction := get_stage_data.cond_val2_direction;
2753: ecx_utils.g_stage_data(i_counter).cond_val2_constant := get_stage_data.cond_val2_constant;
2754: ecx_utils.g_stage_data(i_counter).operand1_level := get_stage_data.operand1_level;
2755: ecx_utils.g_stage_data(i_counter).operand1_name := get_stage_data.operand1_name;
2756: ecx_utils.g_stage_data(i_counter).operand1_pos := get_stage_data.operand1_pos;
2757: ecx_utils.g_stage_data(i_counter).operand1_direction := get_stage_data.operand1_direction;
2758: ecx_utils.g_stage_data(i_counter).operand1_constant := get_stage_data.operand1_constant;
2751: ecx_utils.g_stage_data(i_counter).cond_val2_pos := get_stage_data.cond_val2_pos;
2752: ecx_utils.g_stage_data(i_counter).cond_val2_direction := get_stage_data.cond_val2_direction;
2753: ecx_utils.g_stage_data(i_counter).cond_val2_constant := get_stage_data.cond_val2_constant;
2754: ecx_utils.g_stage_data(i_counter).operand1_level := get_stage_data.operand1_level;
2755: ecx_utils.g_stage_data(i_counter).operand1_name := get_stage_data.operand1_name;
2756: ecx_utils.g_stage_data(i_counter).operand1_pos := get_stage_data.operand1_pos;
2757: ecx_utils.g_stage_data(i_counter).operand1_direction := get_stage_data.operand1_direction;
2758: ecx_utils.g_stage_data(i_counter).operand1_constant := get_stage_data.operand1_constant;
2759: ecx_utils.g_stage_data(i_counter).operand1_len := get_stage_data.operand1_len;
2752: ecx_utils.g_stage_data(i_counter).cond_val2_direction := get_stage_data.cond_val2_direction;
2753: ecx_utils.g_stage_data(i_counter).cond_val2_constant := get_stage_data.cond_val2_constant;
2754: ecx_utils.g_stage_data(i_counter).operand1_level := get_stage_data.operand1_level;
2755: ecx_utils.g_stage_data(i_counter).operand1_name := get_stage_data.operand1_name;
2756: ecx_utils.g_stage_data(i_counter).operand1_pos := get_stage_data.operand1_pos;
2757: ecx_utils.g_stage_data(i_counter).operand1_direction := get_stage_data.operand1_direction;
2758: ecx_utils.g_stage_data(i_counter).operand1_constant := get_stage_data.operand1_constant;
2759: ecx_utils.g_stage_data(i_counter).operand1_len := get_stage_data.operand1_len;
2760: ecx_utils.g_stage_data(i_counter).operand1_start_pos := get_stage_data.operand1_start_pos;
2753: ecx_utils.g_stage_data(i_counter).cond_val2_constant := get_stage_data.cond_val2_constant;
2754: ecx_utils.g_stage_data(i_counter).operand1_level := get_stage_data.operand1_level;
2755: ecx_utils.g_stage_data(i_counter).operand1_name := get_stage_data.operand1_name;
2756: ecx_utils.g_stage_data(i_counter).operand1_pos := get_stage_data.operand1_pos;
2757: ecx_utils.g_stage_data(i_counter).operand1_direction := get_stage_data.operand1_direction;
2758: ecx_utils.g_stage_data(i_counter).operand1_constant := get_stage_data.operand1_constant;
2759: ecx_utils.g_stage_data(i_counter).operand1_len := get_stage_data.operand1_len;
2760: ecx_utils.g_stage_data(i_counter).operand1_start_pos := get_stage_data.operand1_start_pos;
2761: ecx_utils.g_stage_data(i_counter).operand2_level := get_stage_data.operand2_level;
2754: ecx_utils.g_stage_data(i_counter).operand1_level := get_stage_data.operand1_level;
2755: ecx_utils.g_stage_data(i_counter).operand1_name := get_stage_data.operand1_name;
2756: ecx_utils.g_stage_data(i_counter).operand1_pos := get_stage_data.operand1_pos;
2757: ecx_utils.g_stage_data(i_counter).operand1_direction := get_stage_data.operand1_direction;
2758: ecx_utils.g_stage_data(i_counter).operand1_constant := get_stage_data.operand1_constant;
2759: ecx_utils.g_stage_data(i_counter).operand1_len := get_stage_data.operand1_len;
2760: ecx_utils.g_stage_data(i_counter).operand1_start_pos := get_stage_data.operand1_start_pos;
2761: ecx_utils.g_stage_data(i_counter).operand2_level := get_stage_data.operand2_level;
2762: ecx_utils.g_stage_data(i_counter).operand2_name := get_stage_data.operand2_name;
2755: ecx_utils.g_stage_data(i_counter).operand1_name := get_stage_data.operand1_name;
2756: ecx_utils.g_stage_data(i_counter).operand1_pos := get_stage_data.operand1_pos;
2757: ecx_utils.g_stage_data(i_counter).operand1_direction := get_stage_data.operand1_direction;
2758: ecx_utils.g_stage_data(i_counter).operand1_constant := get_stage_data.operand1_constant;
2759: ecx_utils.g_stage_data(i_counter).operand1_len := get_stage_data.operand1_len;
2760: ecx_utils.g_stage_data(i_counter).operand1_start_pos := get_stage_data.operand1_start_pos;
2761: ecx_utils.g_stage_data(i_counter).operand2_level := get_stage_data.operand2_level;
2762: ecx_utils.g_stage_data(i_counter).operand2_name := get_stage_data.operand2_name;
2763: ecx_utils.g_stage_data(i_counter).operand2_pos := get_stage_data.operand2_pos;
2756: ecx_utils.g_stage_data(i_counter).operand1_pos := get_stage_data.operand1_pos;
2757: ecx_utils.g_stage_data(i_counter).operand1_direction := get_stage_data.operand1_direction;
2758: ecx_utils.g_stage_data(i_counter).operand1_constant := get_stage_data.operand1_constant;
2759: ecx_utils.g_stage_data(i_counter).operand1_len := get_stage_data.operand1_len;
2760: ecx_utils.g_stage_data(i_counter).operand1_start_pos := get_stage_data.operand1_start_pos;
2761: ecx_utils.g_stage_data(i_counter).operand2_level := get_stage_data.operand2_level;
2762: ecx_utils.g_stage_data(i_counter).operand2_name := get_stage_data.operand2_name;
2763: ecx_utils.g_stage_data(i_counter).operand2_pos := get_stage_data.operand2_pos;
2764: ecx_utils.g_stage_data(i_counter).operand2_direction := get_stage_data.operand2_direction;
2757: ecx_utils.g_stage_data(i_counter).operand1_direction := get_stage_data.operand1_direction;
2758: ecx_utils.g_stage_data(i_counter).operand1_constant := get_stage_data.operand1_constant;
2759: ecx_utils.g_stage_data(i_counter).operand1_len := get_stage_data.operand1_len;
2760: ecx_utils.g_stage_data(i_counter).operand1_start_pos := get_stage_data.operand1_start_pos;
2761: ecx_utils.g_stage_data(i_counter).operand2_level := get_stage_data.operand2_level;
2762: ecx_utils.g_stage_data(i_counter).operand2_name := get_stage_data.operand2_name;
2763: ecx_utils.g_stage_data(i_counter).operand2_pos := get_stage_data.operand2_pos;
2764: ecx_utils.g_stage_data(i_counter).operand2_direction := get_stage_data.operand2_direction;
2765: ecx_utils.g_stage_data(i_counter).operand2_constant := get_stage_data.operand2_constant;
2758: ecx_utils.g_stage_data(i_counter).operand1_constant := get_stage_data.operand1_constant;
2759: ecx_utils.g_stage_data(i_counter).operand1_len := get_stage_data.operand1_len;
2760: ecx_utils.g_stage_data(i_counter).operand1_start_pos := get_stage_data.operand1_start_pos;
2761: ecx_utils.g_stage_data(i_counter).operand2_level := get_stage_data.operand2_level;
2762: ecx_utils.g_stage_data(i_counter).operand2_name := get_stage_data.operand2_name;
2763: ecx_utils.g_stage_data(i_counter).operand2_pos := get_stage_data.operand2_pos;
2764: ecx_utils.g_stage_data(i_counter).operand2_direction := get_stage_data.operand2_direction;
2765: ecx_utils.g_stage_data(i_counter).operand2_constant := get_stage_data.operand2_constant;
2766: ecx_utils.g_stage_data(i_counter).operand3_level := get_stage_data.operand3_level;
2759: ecx_utils.g_stage_data(i_counter).operand1_len := get_stage_data.operand1_len;
2760: ecx_utils.g_stage_data(i_counter).operand1_start_pos := get_stage_data.operand1_start_pos;
2761: ecx_utils.g_stage_data(i_counter).operand2_level := get_stage_data.operand2_level;
2762: ecx_utils.g_stage_data(i_counter).operand2_name := get_stage_data.operand2_name;
2763: ecx_utils.g_stage_data(i_counter).operand2_pos := get_stage_data.operand2_pos;
2764: ecx_utils.g_stage_data(i_counter).operand2_direction := get_stage_data.operand2_direction;
2765: ecx_utils.g_stage_data(i_counter).operand2_constant := get_stage_data.operand2_constant;
2766: ecx_utils.g_stage_data(i_counter).operand3_level := get_stage_data.operand3_level;
2767: ecx_utils.g_stage_data(i_counter).operand3_name := get_stage_data.operand3_name;
2760: ecx_utils.g_stage_data(i_counter).operand1_start_pos := get_stage_data.operand1_start_pos;
2761: ecx_utils.g_stage_data(i_counter).operand2_level := get_stage_data.operand2_level;
2762: ecx_utils.g_stage_data(i_counter).operand2_name := get_stage_data.operand2_name;
2763: ecx_utils.g_stage_data(i_counter).operand2_pos := get_stage_data.operand2_pos;
2764: ecx_utils.g_stage_data(i_counter).operand2_direction := get_stage_data.operand2_direction;
2765: ecx_utils.g_stage_data(i_counter).operand2_constant := get_stage_data.operand2_constant;
2766: ecx_utils.g_stage_data(i_counter).operand3_level := get_stage_data.operand3_level;
2767: ecx_utils.g_stage_data(i_counter).operand3_name := get_stage_data.operand3_name;
2768: ecx_utils.g_stage_data(i_counter).operand3_pos := get_stage_data.operand3_pos;
2761: ecx_utils.g_stage_data(i_counter).operand2_level := get_stage_data.operand2_level;
2762: ecx_utils.g_stage_data(i_counter).operand2_name := get_stage_data.operand2_name;
2763: ecx_utils.g_stage_data(i_counter).operand2_pos := get_stage_data.operand2_pos;
2764: ecx_utils.g_stage_data(i_counter).operand2_direction := get_stage_data.operand2_direction;
2765: ecx_utils.g_stage_data(i_counter).operand2_constant := get_stage_data.operand2_constant;
2766: ecx_utils.g_stage_data(i_counter).operand3_level := get_stage_data.operand3_level;
2767: ecx_utils.g_stage_data(i_counter).operand3_name := get_stage_data.operand3_name;
2768: ecx_utils.g_stage_data(i_counter).operand3_pos := get_stage_data.operand3_pos;
2769: ecx_utils.g_stage_data(i_counter).operand3_direction := get_stage_data.operand3_direction;
2762: ecx_utils.g_stage_data(i_counter).operand2_name := get_stage_data.operand2_name;
2763: ecx_utils.g_stage_data(i_counter).operand2_pos := get_stage_data.operand2_pos;
2764: ecx_utils.g_stage_data(i_counter).operand2_direction := get_stage_data.operand2_direction;
2765: ecx_utils.g_stage_data(i_counter).operand2_constant := get_stage_data.operand2_constant;
2766: ecx_utils.g_stage_data(i_counter).operand3_level := get_stage_data.operand3_level;
2767: ecx_utils.g_stage_data(i_counter).operand3_name := get_stage_data.operand3_name;
2768: ecx_utils.g_stage_data(i_counter).operand3_pos := get_stage_data.operand3_pos;
2769: ecx_utils.g_stage_data(i_counter).operand3_direction := get_stage_data.operand3_direction;
2770: ecx_utils.g_stage_data(i_counter).operand3_constant := get_stage_data.operand3_constant;
2763: ecx_utils.g_stage_data(i_counter).operand2_pos := get_stage_data.operand2_pos;
2764: ecx_utils.g_stage_data(i_counter).operand2_direction := get_stage_data.operand2_direction;
2765: ecx_utils.g_stage_data(i_counter).operand2_constant := get_stage_data.operand2_constant;
2766: ecx_utils.g_stage_data(i_counter).operand3_level := get_stage_data.operand3_level;
2767: ecx_utils.g_stage_data(i_counter).operand3_name := get_stage_data.operand3_name;
2768: ecx_utils.g_stage_data(i_counter).operand3_pos := get_stage_data.operand3_pos;
2769: ecx_utils.g_stage_data(i_counter).operand3_direction := get_stage_data.operand3_direction;
2770: ecx_utils.g_stage_data(i_counter).operand3_constant := get_stage_data.operand3_constant;
2771: ecx_utils.g_stage_data(i_counter).operand4_level := get_stage_data.operand4_level;
2764: ecx_utils.g_stage_data(i_counter).operand2_direction := get_stage_data.operand2_direction;
2765: ecx_utils.g_stage_data(i_counter).operand2_constant := get_stage_data.operand2_constant;
2766: ecx_utils.g_stage_data(i_counter).operand3_level := get_stage_data.operand3_level;
2767: ecx_utils.g_stage_data(i_counter).operand3_name := get_stage_data.operand3_name;
2768: ecx_utils.g_stage_data(i_counter).operand3_pos := get_stage_data.operand3_pos;
2769: ecx_utils.g_stage_data(i_counter).operand3_direction := get_stage_data.operand3_direction;
2770: ecx_utils.g_stage_data(i_counter).operand3_constant := get_stage_data.operand3_constant;
2771: ecx_utils.g_stage_data(i_counter).operand4_level := get_stage_data.operand4_level;
2772: ecx_utils.g_stage_data(i_counter).operand4_name := get_stage_data.operand4_name;
2765: ecx_utils.g_stage_data(i_counter).operand2_constant := get_stage_data.operand2_constant;
2766: ecx_utils.g_stage_data(i_counter).operand3_level := get_stage_data.operand3_level;
2767: ecx_utils.g_stage_data(i_counter).operand3_name := get_stage_data.operand3_name;
2768: ecx_utils.g_stage_data(i_counter).operand3_pos := get_stage_data.operand3_pos;
2769: ecx_utils.g_stage_data(i_counter).operand3_direction := get_stage_data.operand3_direction;
2770: ecx_utils.g_stage_data(i_counter).operand3_constant := get_stage_data.operand3_constant;
2771: ecx_utils.g_stage_data(i_counter).operand4_level := get_stage_data.operand4_level;
2772: ecx_utils.g_stage_data(i_counter).operand4_name := get_stage_data.operand4_name;
2773: ecx_utils.g_stage_data(i_counter).operand4_pos := get_stage_data.operand4_pos;
2766: ecx_utils.g_stage_data(i_counter).operand3_level := get_stage_data.operand3_level;
2767: ecx_utils.g_stage_data(i_counter).operand3_name := get_stage_data.operand3_name;
2768: ecx_utils.g_stage_data(i_counter).operand3_pos := get_stage_data.operand3_pos;
2769: ecx_utils.g_stage_data(i_counter).operand3_direction := get_stage_data.operand3_direction;
2770: ecx_utils.g_stage_data(i_counter).operand3_constant := get_stage_data.operand3_constant;
2771: ecx_utils.g_stage_data(i_counter).operand4_level := get_stage_data.operand4_level;
2772: ecx_utils.g_stage_data(i_counter).operand4_name := get_stage_data.operand4_name;
2773: ecx_utils.g_stage_data(i_counter).operand4_pos := get_stage_data.operand4_pos;
2774: ecx_utils.g_stage_data(i_counter).operand4_direction := get_stage_data.operand4_direction;
2767: ecx_utils.g_stage_data(i_counter).operand3_name := get_stage_data.operand3_name;
2768: ecx_utils.g_stage_data(i_counter).operand3_pos := get_stage_data.operand3_pos;
2769: ecx_utils.g_stage_data(i_counter).operand3_direction := get_stage_data.operand3_direction;
2770: ecx_utils.g_stage_data(i_counter).operand3_constant := get_stage_data.operand3_constant;
2771: ecx_utils.g_stage_data(i_counter).operand4_level := get_stage_data.operand4_level;
2772: ecx_utils.g_stage_data(i_counter).operand4_name := get_stage_data.operand4_name;
2773: ecx_utils.g_stage_data(i_counter).operand4_pos := get_stage_data.operand4_pos;
2774: ecx_utils.g_stage_data(i_counter).operand4_direction := get_stage_data.operand4_direction;
2775: ecx_utils.g_stage_data(i_counter).operand4_constant := get_stage_data.operand4_constant;
2768: ecx_utils.g_stage_data(i_counter).operand3_pos := get_stage_data.operand3_pos;
2769: ecx_utils.g_stage_data(i_counter).operand3_direction := get_stage_data.operand3_direction;
2770: ecx_utils.g_stage_data(i_counter).operand3_constant := get_stage_data.operand3_constant;
2771: ecx_utils.g_stage_data(i_counter).operand4_level := get_stage_data.operand4_level;
2772: ecx_utils.g_stage_data(i_counter).operand4_name := get_stage_data.operand4_name;
2773: ecx_utils.g_stage_data(i_counter).operand4_pos := get_stage_data.operand4_pos;
2774: ecx_utils.g_stage_data(i_counter).operand4_direction := get_stage_data.operand4_direction;
2775: ecx_utils.g_stage_data(i_counter).operand4_constant := get_stage_data.operand4_constant;
2776: ecx_utils.g_stage_data(i_counter).operand5_level := get_stage_data.operand5_level;
2769: ecx_utils.g_stage_data(i_counter).operand3_direction := get_stage_data.operand3_direction;
2770: ecx_utils.g_stage_data(i_counter).operand3_constant := get_stage_data.operand3_constant;
2771: ecx_utils.g_stage_data(i_counter).operand4_level := get_stage_data.operand4_level;
2772: ecx_utils.g_stage_data(i_counter).operand4_name := get_stage_data.operand4_name;
2773: ecx_utils.g_stage_data(i_counter).operand4_pos := get_stage_data.operand4_pos;
2774: ecx_utils.g_stage_data(i_counter).operand4_direction := get_stage_data.operand4_direction;
2775: ecx_utils.g_stage_data(i_counter).operand4_constant := get_stage_data.operand4_constant;
2776: ecx_utils.g_stage_data(i_counter).operand5_level := get_stage_data.operand5_level;
2777: ecx_utils.g_stage_data(i_counter).operand5_name := get_stage_data.operand5_name;
2770: ecx_utils.g_stage_data(i_counter).operand3_constant := get_stage_data.operand3_constant;
2771: ecx_utils.g_stage_data(i_counter).operand4_level := get_stage_data.operand4_level;
2772: ecx_utils.g_stage_data(i_counter).operand4_name := get_stage_data.operand4_name;
2773: ecx_utils.g_stage_data(i_counter).operand4_pos := get_stage_data.operand4_pos;
2774: ecx_utils.g_stage_data(i_counter).operand4_direction := get_stage_data.operand4_direction;
2775: ecx_utils.g_stage_data(i_counter).operand4_constant := get_stage_data.operand4_constant;
2776: ecx_utils.g_stage_data(i_counter).operand5_level := get_stage_data.operand5_level;
2777: ecx_utils.g_stage_data(i_counter).operand5_name := get_stage_data.operand5_name;
2778: ecx_utils.g_stage_data(i_counter).operand5_pos := get_stage_data.operand5_pos;
2771: ecx_utils.g_stage_data(i_counter).operand4_level := get_stage_data.operand4_level;
2772: ecx_utils.g_stage_data(i_counter).operand4_name := get_stage_data.operand4_name;
2773: ecx_utils.g_stage_data(i_counter).operand4_pos := get_stage_data.operand4_pos;
2774: ecx_utils.g_stage_data(i_counter).operand4_direction := get_stage_data.operand4_direction;
2775: ecx_utils.g_stage_data(i_counter).operand4_constant := get_stage_data.operand4_constant;
2776: ecx_utils.g_stage_data(i_counter).operand5_level := get_stage_data.operand5_level;
2777: ecx_utils.g_stage_data(i_counter).operand5_name := get_stage_data.operand5_name;
2778: ecx_utils.g_stage_data(i_counter).operand5_pos := get_stage_data.operand5_pos;
2779: ecx_utils.g_stage_data(i_counter).operand5_direction := get_stage_data.operand5_direction;
2772: ecx_utils.g_stage_data(i_counter).operand4_name := get_stage_data.operand4_name;
2773: ecx_utils.g_stage_data(i_counter).operand4_pos := get_stage_data.operand4_pos;
2774: ecx_utils.g_stage_data(i_counter).operand4_direction := get_stage_data.operand4_direction;
2775: ecx_utils.g_stage_data(i_counter).operand4_constant := get_stage_data.operand4_constant;
2776: ecx_utils.g_stage_data(i_counter).operand5_level := get_stage_data.operand5_level;
2777: ecx_utils.g_stage_data(i_counter).operand5_name := get_stage_data.operand5_name;
2778: ecx_utils.g_stage_data(i_counter).operand5_pos := get_stage_data.operand5_pos;
2779: ecx_utils.g_stage_data(i_counter).operand5_direction := get_stage_data.operand5_direction;
2780: ecx_utils.g_stage_data(i_counter).operand5_constant := get_stage_data.operand5_constant;
2773: ecx_utils.g_stage_data(i_counter).operand4_pos := get_stage_data.operand4_pos;
2774: ecx_utils.g_stage_data(i_counter).operand4_direction := get_stage_data.operand4_direction;
2775: ecx_utils.g_stage_data(i_counter).operand4_constant := get_stage_data.operand4_constant;
2776: ecx_utils.g_stage_data(i_counter).operand5_level := get_stage_data.operand5_level;
2777: ecx_utils.g_stage_data(i_counter).operand5_name := get_stage_data.operand5_name;
2778: ecx_utils.g_stage_data(i_counter).operand5_pos := get_stage_data.operand5_pos;
2779: ecx_utils.g_stage_data(i_counter).operand5_direction := get_stage_data.operand5_direction;
2780: ecx_utils.g_stage_data(i_counter).operand5_constant := get_stage_data.operand5_constant;
2781: ecx_utils.g_stage_data(i_counter).operand6_level := get_stage_data.operand6_level;
2774: ecx_utils.g_stage_data(i_counter).operand4_direction := get_stage_data.operand4_direction;
2775: ecx_utils.g_stage_data(i_counter).operand4_constant := get_stage_data.operand4_constant;
2776: ecx_utils.g_stage_data(i_counter).operand5_level := get_stage_data.operand5_level;
2777: ecx_utils.g_stage_data(i_counter).operand5_name := get_stage_data.operand5_name;
2778: ecx_utils.g_stage_data(i_counter).operand5_pos := get_stage_data.operand5_pos;
2779: ecx_utils.g_stage_data(i_counter).operand5_direction := get_stage_data.operand5_direction;
2780: ecx_utils.g_stage_data(i_counter).operand5_constant := get_stage_data.operand5_constant;
2781: ecx_utils.g_stage_data(i_counter).operand6_level := get_stage_data.operand6_level;
2782: ecx_utils.g_stage_data(i_counter).operand6_name := get_stage_data.operand6_name;
2775: ecx_utils.g_stage_data(i_counter).operand4_constant := get_stage_data.operand4_constant;
2776: ecx_utils.g_stage_data(i_counter).operand5_level := get_stage_data.operand5_level;
2777: ecx_utils.g_stage_data(i_counter).operand5_name := get_stage_data.operand5_name;
2778: ecx_utils.g_stage_data(i_counter).operand5_pos := get_stage_data.operand5_pos;
2779: ecx_utils.g_stage_data(i_counter).operand5_direction := get_stage_data.operand5_direction;
2780: ecx_utils.g_stage_data(i_counter).operand5_constant := get_stage_data.operand5_constant;
2781: ecx_utils.g_stage_data(i_counter).operand6_level := get_stage_data.operand6_level;
2782: ecx_utils.g_stage_data(i_counter).operand6_name := get_stage_data.operand6_name;
2783: ecx_utils.g_stage_data(i_counter).operand6_pos := get_stage_data.operand6_pos;
2776: ecx_utils.g_stage_data(i_counter).operand5_level := get_stage_data.operand5_level;
2777: ecx_utils.g_stage_data(i_counter).operand5_name := get_stage_data.operand5_name;
2778: ecx_utils.g_stage_data(i_counter).operand5_pos := get_stage_data.operand5_pos;
2779: ecx_utils.g_stage_data(i_counter).operand5_direction := get_stage_data.operand5_direction;
2780: ecx_utils.g_stage_data(i_counter).operand5_constant := get_stage_data.operand5_constant;
2781: ecx_utils.g_stage_data(i_counter).operand6_level := get_stage_data.operand6_level;
2782: ecx_utils.g_stage_data(i_counter).operand6_name := get_stage_data.operand6_name;
2783: ecx_utils.g_stage_data(i_counter).operand6_pos := get_stage_data.operand6_pos;
2784: ecx_utils.g_stage_data(i_counter).operand6_direction := get_stage_data.operand6_direction;
2777: ecx_utils.g_stage_data(i_counter).operand5_name := get_stage_data.operand5_name;
2778: ecx_utils.g_stage_data(i_counter).operand5_pos := get_stage_data.operand5_pos;
2779: ecx_utils.g_stage_data(i_counter).operand5_direction := get_stage_data.operand5_direction;
2780: ecx_utils.g_stage_data(i_counter).operand5_constant := get_stage_data.operand5_constant;
2781: ecx_utils.g_stage_data(i_counter).operand6_level := get_stage_data.operand6_level;
2782: ecx_utils.g_stage_data(i_counter).operand6_name := get_stage_data.operand6_name;
2783: ecx_utils.g_stage_data(i_counter).operand6_pos := get_stage_data.operand6_pos;
2784: ecx_utils.g_stage_data(i_counter).operand6_direction := get_stage_data.operand6_direction;
2785: ecx_utils.g_stage_data(i_counter).operand6_constant := get_stage_data.operand6_constant;
2778: ecx_utils.g_stage_data(i_counter).operand5_pos := get_stage_data.operand5_pos;
2779: ecx_utils.g_stage_data(i_counter).operand5_direction := get_stage_data.operand5_direction;
2780: ecx_utils.g_stage_data(i_counter).operand5_constant := get_stage_data.operand5_constant;
2781: ecx_utils.g_stage_data(i_counter).operand6_level := get_stage_data.operand6_level;
2782: ecx_utils.g_stage_data(i_counter).operand6_name := get_stage_data.operand6_name;
2783: ecx_utils.g_stage_data(i_counter).operand6_pos := get_stage_data.operand6_pos;
2784: ecx_utils.g_stage_data(i_counter).operand6_direction := get_stage_data.operand6_direction;
2785: ecx_utils.g_stage_data(i_counter).operand6_constant := get_stage_data.operand6_constant;
2786:
2779: ecx_utils.g_stage_data(i_counter).operand5_direction := get_stage_data.operand5_direction;
2780: ecx_utils.g_stage_data(i_counter).operand5_constant := get_stage_data.operand5_constant;
2781: ecx_utils.g_stage_data(i_counter).operand6_level := get_stage_data.operand6_level;
2782: ecx_utils.g_stage_data(i_counter).operand6_name := get_stage_data.operand6_name;
2783: ecx_utils.g_stage_data(i_counter).operand6_pos := get_stage_data.operand6_pos;
2784: ecx_utils.g_stage_data(i_counter).operand6_direction := get_stage_data.operand6_direction;
2785: ecx_utils.g_stage_data(i_counter).operand6_constant := get_stage_data.operand6_constant;
2786:
2787: if(l_statementEnabled) then
2780: ecx_utils.g_stage_data(i_counter).operand5_constant := get_stage_data.operand5_constant;
2781: ecx_utils.g_stage_data(i_counter).operand6_level := get_stage_data.operand6_level;
2782: ecx_utils.g_stage_data(i_counter).operand6_name := get_stage_data.operand6_name;
2783: ecx_utils.g_stage_data(i_counter).operand6_pos := get_stage_data.operand6_pos;
2784: ecx_utils.g_stage_data(i_counter).operand6_direction := get_stage_data.operand6_direction;
2785: ecx_utils.g_stage_data(i_counter).operand6_constant := get_stage_data.operand6_constant;
2786:
2787: if(l_statementEnabled) then
2788: ecx_debug.log(l_statement,
2781: ecx_utils.g_stage_data(i_counter).operand6_level := get_stage_data.operand6_level;
2782: ecx_utils.g_stage_data(i_counter).operand6_name := get_stage_data.operand6_name;
2783: ecx_utils.g_stage_data(i_counter).operand6_pos := get_stage_data.operand6_pos;
2784: ecx_utils.g_stage_data(i_counter).operand6_direction := get_stage_data.operand6_direction;
2785: ecx_utils.g_stage_data(i_counter).operand6_constant := get_stage_data.operand6_constant;
2786:
2787: if(l_statementEnabled) then
2788: ecx_debug.log(l_statement,
2789: ecx_utils.g_stage_data(i_counter).transtage_id||'|'||
2785: ecx_utils.g_stage_data(i_counter).operand6_constant := get_stage_data.operand6_constant;
2786:
2787: if(l_statementEnabled) then
2788: ecx_debug.log(l_statement,
2789: ecx_utils.g_stage_data(i_counter).transtage_id||'|'||
2790: ecx_utils.g_stage_data(i_counter).level||'|'||
2791: ecx_utils.g_stage_data(i_counter).stage||'|'||
2792: ecx_utils.g_stage_data(i_counter).object_direction||'|'||
2793: ecx_utils.g_stage_data(i_counter).seq_number||'|'||
2786:
2787: if(l_statementEnabled) then
2788: ecx_debug.log(l_statement,
2789: ecx_utils.g_stage_data(i_counter).transtage_id||'|'||
2790: ecx_utils.g_stage_data(i_counter).level||'|'||
2791: ecx_utils.g_stage_data(i_counter).stage||'|'||
2792: ecx_utils.g_stage_data(i_counter).object_direction||'|'||
2793: ecx_utils.g_stage_data(i_counter).seq_number||'|'||
2794: ecx_utils.g_stage_data(i_counter).action_type||'|'||
2787: if(l_statementEnabled) then
2788: ecx_debug.log(l_statement,
2789: ecx_utils.g_stage_data(i_counter).transtage_id||'|'||
2790: ecx_utils.g_stage_data(i_counter).level||'|'||
2791: ecx_utils.g_stage_data(i_counter).stage||'|'||
2792: ecx_utils.g_stage_data(i_counter).object_direction||'|'||
2793: ecx_utils.g_stage_data(i_counter).seq_number||'|'||
2794: ecx_utils.g_stage_data(i_counter).action_type||'|'||
2795: ecx_utils.g_stage_data(i_counter).variable_level||'|'||
2788: ecx_debug.log(l_statement,
2789: ecx_utils.g_stage_data(i_counter).transtage_id||'|'||
2790: ecx_utils.g_stage_data(i_counter).level||'|'||
2791: ecx_utils.g_stage_data(i_counter).stage||'|'||
2792: ecx_utils.g_stage_data(i_counter).object_direction||'|'||
2793: ecx_utils.g_stage_data(i_counter).seq_number||'|'||
2794: ecx_utils.g_stage_data(i_counter).action_type||'|'||
2795: ecx_utils.g_stage_data(i_counter).variable_level||'|'||
2796: ecx_utils.g_stage_data(i_counter).variable_name||'|'||
2789: ecx_utils.g_stage_data(i_counter).transtage_id||'|'||
2790: ecx_utils.g_stage_data(i_counter).level||'|'||
2791: ecx_utils.g_stage_data(i_counter).stage||'|'||
2792: ecx_utils.g_stage_data(i_counter).object_direction||'|'||
2793: ecx_utils.g_stage_data(i_counter).seq_number||'|'||
2794: ecx_utils.g_stage_data(i_counter).action_type||'|'||
2795: ecx_utils.g_stage_data(i_counter).variable_level||'|'||
2796: ecx_utils.g_stage_data(i_counter).variable_name||'|'||
2797: ecx_utils.g_stage_data(i_counter).variable_pos||'|'||
2790: ecx_utils.g_stage_data(i_counter).level||'|'||
2791: ecx_utils.g_stage_data(i_counter).stage||'|'||
2792: ecx_utils.g_stage_data(i_counter).object_direction||'|'||
2793: ecx_utils.g_stage_data(i_counter).seq_number||'|'||
2794: ecx_utils.g_stage_data(i_counter).action_type||'|'||
2795: ecx_utils.g_stage_data(i_counter).variable_level||'|'||
2796: ecx_utils.g_stage_data(i_counter).variable_name||'|'||
2797: ecx_utils.g_stage_data(i_counter).variable_pos||'|'||
2798: ecx_utils.g_stage_data(i_counter).variable_direction||'|'||
2791: ecx_utils.g_stage_data(i_counter).stage||'|'||
2792: ecx_utils.g_stage_data(i_counter).object_direction||'|'||
2793: ecx_utils.g_stage_data(i_counter).seq_number||'|'||
2794: ecx_utils.g_stage_data(i_counter).action_type||'|'||
2795: ecx_utils.g_stage_data(i_counter).variable_level||'|'||
2796: ecx_utils.g_stage_data(i_counter).variable_name||'|'||
2797: ecx_utils.g_stage_data(i_counter).variable_pos||'|'||
2798: ecx_utils.g_stage_data(i_counter).variable_direction||'|'||
2799: ecx_utils.g_stage_data(i_counter).variable_value||'|'||
2792: ecx_utils.g_stage_data(i_counter).object_direction||'|'||
2793: ecx_utils.g_stage_data(i_counter).seq_number||'|'||
2794: ecx_utils.g_stage_data(i_counter).action_type||'|'||
2795: ecx_utils.g_stage_data(i_counter).variable_level||'|'||
2796: ecx_utils.g_stage_data(i_counter).variable_name||'|'||
2797: ecx_utils.g_stage_data(i_counter).variable_pos||'|'||
2798: ecx_utils.g_stage_data(i_counter).variable_direction||'|'||
2799: ecx_utils.g_stage_data(i_counter).variable_value||'|'||
2800: ecx_utils.g_stage_data(i_counter).default_value||'|'||
2793: ecx_utils.g_stage_data(i_counter).seq_number||'|'||
2794: ecx_utils.g_stage_data(i_counter).action_type||'|'||
2795: ecx_utils.g_stage_data(i_counter).variable_level||'|'||
2796: ecx_utils.g_stage_data(i_counter).variable_name||'|'||
2797: ecx_utils.g_stage_data(i_counter).variable_pos||'|'||
2798: ecx_utils.g_stage_data(i_counter).variable_direction||'|'||
2799: ecx_utils.g_stage_data(i_counter).variable_value||'|'||
2800: ecx_utils.g_stage_data(i_counter).default_value||'|'||
2801: ecx_utils.g_stage_data(i_counter).custom_procedure_name||'|'||
2794: ecx_utils.g_stage_data(i_counter).action_type||'|'||
2795: ecx_utils.g_stage_data(i_counter).variable_level||'|'||
2796: ecx_utils.g_stage_data(i_counter).variable_name||'|'||
2797: ecx_utils.g_stage_data(i_counter).variable_pos||'|'||
2798: ecx_utils.g_stage_data(i_counter).variable_direction||'|'||
2799: ecx_utils.g_stage_data(i_counter).variable_value||'|'||
2800: ecx_utils.g_stage_data(i_counter).default_value||'|'||
2801: ecx_utils.g_stage_data(i_counter).custom_procedure_name||'|'||
2802: ecx_utils.g_stage_data(i_counter).data_type||'|'||
2795: ecx_utils.g_stage_data(i_counter).variable_level||'|'||
2796: ecx_utils.g_stage_data(i_counter).variable_name||'|'||
2797: ecx_utils.g_stage_data(i_counter).variable_pos||'|'||
2798: ecx_utils.g_stage_data(i_counter).variable_direction||'|'||
2799: ecx_utils.g_stage_data(i_counter).variable_value||'|'||
2800: ecx_utils.g_stage_data(i_counter).default_value||'|'||
2801: ecx_utils.g_stage_data(i_counter).custom_procedure_name||'|'||
2802: ecx_utils.g_stage_data(i_counter).data_type||'|'||
2803: ecx_utils.g_stage_data(i_counter).function_name||'|'||
2796: ecx_utils.g_stage_data(i_counter).variable_name||'|'||
2797: ecx_utils.g_stage_data(i_counter).variable_pos||'|'||
2798: ecx_utils.g_stage_data(i_counter).variable_direction||'|'||
2799: ecx_utils.g_stage_data(i_counter).variable_value||'|'||
2800: ecx_utils.g_stage_data(i_counter).default_value||'|'||
2801: ecx_utils.g_stage_data(i_counter).custom_procedure_name||'|'||
2802: ecx_utils.g_stage_data(i_counter).data_type||'|'||
2803: ecx_utils.g_stage_data(i_counter).function_name||'|'||
2804: ecx_utils.g_stage_data(i_counter).clause||'|'||
2797: ecx_utils.g_stage_data(i_counter).variable_pos||'|'||
2798: ecx_utils.g_stage_data(i_counter).variable_direction||'|'||
2799: ecx_utils.g_stage_data(i_counter).variable_value||'|'||
2800: ecx_utils.g_stage_data(i_counter).default_value||'|'||
2801: ecx_utils.g_stage_data(i_counter).custom_procedure_name||'|'||
2802: ecx_utils.g_stage_data(i_counter).data_type||'|'||
2803: ecx_utils.g_stage_data(i_counter).function_name||'|'||
2804: ecx_utils.g_stage_data(i_counter).clause||'|'||
2805: ecx_utils.g_stage_data(i_counter).cond_logical_operator||'|'||
2798: ecx_utils.g_stage_data(i_counter).variable_direction||'|'||
2799: ecx_utils.g_stage_data(i_counter).variable_value||'|'||
2800: ecx_utils.g_stage_data(i_counter).default_value||'|'||
2801: ecx_utils.g_stage_data(i_counter).custom_procedure_name||'|'||
2802: ecx_utils.g_stage_data(i_counter).data_type||'|'||
2803: ecx_utils.g_stage_data(i_counter).function_name||'|'||
2804: ecx_utils.g_stage_data(i_counter).clause||'|'||
2805: ecx_utils.g_stage_data(i_counter).cond_logical_operator||'|'||
2806: ecx_utils.g_stage_data(i_counter).cond_operator1||'|'||
2799: ecx_utils.g_stage_data(i_counter).variable_value||'|'||
2800: ecx_utils.g_stage_data(i_counter).default_value||'|'||
2801: ecx_utils.g_stage_data(i_counter).custom_procedure_name||'|'||
2802: ecx_utils.g_stage_data(i_counter).data_type||'|'||
2803: ecx_utils.g_stage_data(i_counter).function_name||'|'||
2804: ecx_utils.g_stage_data(i_counter).clause||'|'||
2805: ecx_utils.g_stage_data(i_counter).cond_logical_operator||'|'||
2806: ecx_utils.g_stage_data(i_counter).cond_operator1||'|'||
2807: ecx_utils.g_stage_data(i_counter).cond_var1_level||'|'||
2800: ecx_utils.g_stage_data(i_counter).default_value||'|'||
2801: ecx_utils.g_stage_data(i_counter).custom_procedure_name||'|'||
2802: ecx_utils.g_stage_data(i_counter).data_type||'|'||
2803: ecx_utils.g_stage_data(i_counter).function_name||'|'||
2804: ecx_utils.g_stage_data(i_counter).clause||'|'||
2805: ecx_utils.g_stage_data(i_counter).cond_logical_operator||'|'||
2806: ecx_utils.g_stage_data(i_counter).cond_operator1||'|'||
2807: ecx_utils.g_stage_data(i_counter).cond_var1_level||'|'||
2808: ecx_utils.g_stage_data(i_counter).cond_var1_name||'|'||
2801: ecx_utils.g_stage_data(i_counter).custom_procedure_name||'|'||
2802: ecx_utils.g_stage_data(i_counter).data_type||'|'||
2803: ecx_utils.g_stage_data(i_counter).function_name||'|'||
2804: ecx_utils.g_stage_data(i_counter).clause||'|'||
2805: ecx_utils.g_stage_data(i_counter).cond_logical_operator||'|'||
2806: ecx_utils.g_stage_data(i_counter).cond_operator1||'|'||
2807: ecx_utils.g_stage_data(i_counter).cond_var1_level||'|'||
2808: ecx_utils.g_stage_data(i_counter).cond_var1_name||'|'||
2809: ecx_utils.g_stage_data(i_counter).cond_var1_pos||'|'||
2802: ecx_utils.g_stage_data(i_counter).data_type||'|'||
2803: ecx_utils.g_stage_data(i_counter).function_name||'|'||
2804: ecx_utils.g_stage_data(i_counter).clause||'|'||
2805: ecx_utils.g_stage_data(i_counter).cond_logical_operator||'|'||
2806: ecx_utils.g_stage_data(i_counter).cond_operator1||'|'||
2807: ecx_utils.g_stage_data(i_counter).cond_var1_level||'|'||
2808: ecx_utils.g_stage_data(i_counter).cond_var1_name||'|'||
2809: ecx_utils.g_stage_data(i_counter).cond_var1_pos||'|'||
2810: ecx_utils.g_stage_data(i_counter).cond_var1_direction||'|'||
2803: ecx_utils.g_stage_data(i_counter).function_name||'|'||
2804: ecx_utils.g_stage_data(i_counter).clause||'|'||
2805: ecx_utils.g_stage_data(i_counter).cond_logical_operator||'|'||
2806: ecx_utils.g_stage_data(i_counter).cond_operator1||'|'||
2807: ecx_utils.g_stage_data(i_counter).cond_var1_level||'|'||
2808: ecx_utils.g_stage_data(i_counter).cond_var1_name||'|'||
2809: ecx_utils.g_stage_data(i_counter).cond_var1_pos||'|'||
2810: ecx_utils.g_stage_data(i_counter).cond_var1_direction||'|'||
2811: ecx_utils.g_stage_data(i_counter).cond_var1_constant||'|'||
2804: ecx_utils.g_stage_data(i_counter).clause||'|'||
2805: ecx_utils.g_stage_data(i_counter).cond_logical_operator||'|'||
2806: ecx_utils.g_stage_data(i_counter).cond_operator1||'|'||
2807: ecx_utils.g_stage_data(i_counter).cond_var1_level||'|'||
2808: ecx_utils.g_stage_data(i_counter).cond_var1_name||'|'||
2809: ecx_utils.g_stage_data(i_counter).cond_var1_pos||'|'||
2810: ecx_utils.g_stage_data(i_counter).cond_var1_direction||'|'||
2811: ecx_utils.g_stage_data(i_counter).cond_var1_constant||'|'||
2812: ecx_utils.g_stage_data(i_counter).cond_val1_level||'|'||
2805: ecx_utils.g_stage_data(i_counter).cond_logical_operator||'|'||
2806: ecx_utils.g_stage_data(i_counter).cond_operator1||'|'||
2807: ecx_utils.g_stage_data(i_counter).cond_var1_level||'|'||
2808: ecx_utils.g_stage_data(i_counter).cond_var1_name||'|'||
2809: ecx_utils.g_stage_data(i_counter).cond_var1_pos||'|'||
2810: ecx_utils.g_stage_data(i_counter).cond_var1_direction||'|'||
2811: ecx_utils.g_stage_data(i_counter).cond_var1_constant||'|'||
2812: ecx_utils.g_stage_data(i_counter).cond_val1_level||'|'||
2813: ecx_utils.g_stage_data(i_counter).cond_val1_name||'|'||
2806: ecx_utils.g_stage_data(i_counter).cond_operator1||'|'||
2807: ecx_utils.g_stage_data(i_counter).cond_var1_level||'|'||
2808: ecx_utils.g_stage_data(i_counter).cond_var1_name||'|'||
2809: ecx_utils.g_stage_data(i_counter).cond_var1_pos||'|'||
2810: ecx_utils.g_stage_data(i_counter).cond_var1_direction||'|'||
2811: ecx_utils.g_stage_data(i_counter).cond_var1_constant||'|'||
2812: ecx_utils.g_stage_data(i_counter).cond_val1_level||'|'||
2813: ecx_utils.g_stage_data(i_counter).cond_val1_name||'|'||
2814: ecx_utils.g_stage_data(i_counter).cond_val1_pos||'|'||
2807: ecx_utils.g_stage_data(i_counter).cond_var1_level||'|'||
2808: ecx_utils.g_stage_data(i_counter).cond_var1_name||'|'||
2809: ecx_utils.g_stage_data(i_counter).cond_var1_pos||'|'||
2810: ecx_utils.g_stage_data(i_counter).cond_var1_direction||'|'||
2811: ecx_utils.g_stage_data(i_counter).cond_var1_constant||'|'||
2812: ecx_utils.g_stage_data(i_counter).cond_val1_level||'|'||
2813: ecx_utils.g_stage_data(i_counter).cond_val1_name||'|'||
2814: ecx_utils.g_stage_data(i_counter).cond_val1_pos||'|'||
2815: ecx_utils.g_stage_data(i_counter).cond_val1_direction||'|'||
2808: ecx_utils.g_stage_data(i_counter).cond_var1_name||'|'||
2809: ecx_utils.g_stage_data(i_counter).cond_var1_pos||'|'||
2810: ecx_utils.g_stage_data(i_counter).cond_var1_direction||'|'||
2811: ecx_utils.g_stage_data(i_counter).cond_var1_constant||'|'||
2812: ecx_utils.g_stage_data(i_counter).cond_val1_level||'|'||
2813: ecx_utils.g_stage_data(i_counter).cond_val1_name||'|'||
2814: ecx_utils.g_stage_data(i_counter).cond_val1_pos||'|'||
2815: ecx_utils.g_stage_data(i_counter).cond_val1_direction||'|'||
2816: ecx_utils.g_stage_data(i_counter).cond_val1_constant||'|'||
2809: ecx_utils.g_stage_data(i_counter).cond_var1_pos||'|'||
2810: ecx_utils.g_stage_data(i_counter).cond_var1_direction||'|'||
2811: ecx_utils.g_stage_data(i_counter).cond_var1_constant||'|'||
2812: ecx_utils.g_stage_data(i_counter).cond_val1_level||'|'||
2813: ecx_utils.g_stage_data(i_counter).cond_val1_name||'|'||
2814: ecx_utils.g_stage_data(i_counter).cond_val1_pos||'|'||
2815: ecx_utils.g_stage_data(i_counter).cond_val1_direction||'|'||
2816: ecx_utils.g_stage_data(i_counter).cond_val1_constant||'|'||
2817: ecx_utils.g_stage_data(i_counter).cond_operator2||'|'||
2810: ecx_utils.g_stage_data(i_counter).cond_var1_direction||'|'||
2811: ecx_utils.g_stage_data(i_counter).cond_var1_constant||'|'||
2812: ecx_utils.g_stage_data(i_counter).cond_val1_level||'|'||
2813: ecx_utils.g_stage_data(i_counter).cond_val1_name||'|'||
2814: ecx_utils.g_stage_data(i_counter).cond_val1_pos||'|'||
2815: ecx_utils.g_stage_data(i_counter).cond_val1_direction||'|'||
2816: ecx_utils.g_stage_data(i_counter).cond_val1_constant||'|'||
2817: ecx_utils.g_stage_data(i_counter).cond_operator2||'|'||
2818: ecx_utils.g_stage_data(i_counter).cond_var2_level||'|'||
2811: ecx_utils.g_stage_data(i_counter).cond_var1_constant||'|'||
2812: ecx_utils.g_stage_data(i_counter).cond_val1_level||'|'||
2813: ecx_utils.g_stage_data(i_counter).cond_val1_name||'|'||
2814: ecx_utils.g_stage_data(i_counter).cond_val1_pos||'|'||
2815: ecx_utils.g_stage_data(i_counter).cond_val1_direction||'|'||
2816: ecx_utils.g_stage_data(i_counter).cond_val1_constant||'|'||
2817: ecx_utils.g_stage_data(i_counter).cond_operator2||'|'||
2818: ecx_utils.g_stage_data(i_counter).cond_var2_level||'|'||
2819: ecx_utils.g_stage_data(i_counter).cond_var2_name||'|'||
2812: ecx_utils.g_stage_data(i_counter).cond_val1_level||'|'||
2813: ecx_utils.g_stage_data(i_counter).cond_val1_name||'|'||
2814: ecx_utils.g_stage_data(i_counter).cond_val1_pos||'|'||
2815: ecx_utils.g_stage_data(i_counter).cond_val1_direction||'|'||
2816: ecx_utils.g_stage_data(i_counter).cond_val1_constant||'|'||
2817: ecx_utils.g_stage_data(i_counter).cond_operator2||'|'||
2818: ecx_utils.g_stage_data(i_counter).cond_var2_level||'|'||
2819: ecx_utils.g_stage_data(i_counter).cond_var2_name||'|'||
2820: ecx_utils.g_stage_data(i_counter).cond_var2_pos||'|'||
2813: ecx_utils.g_stage_data(i_counter).cond_val1_name||'|'||
2814: ecx_utils.g_stage_data(i_counter).cond_val1_pos||'|'||
2815: ecx_utils.g_stage_data(i_counter).cond_val1_direction||'|'||
2816: ecx_utils.g_stage_data(i_counter).cond_val1_constant||'|'||
2817: ecx_utils.g_stage_data(i_counter).cond_operator2||'|'||
2818: ecx_utils.g_stage_data(i_counter).cond_var2_level||'|'||
2819: ecx_utils.g_stage_data(i_counter).cond_var2_name||'|'||
2820: ecx_utils.g_stage_data(i_counter).cond_var2_pos||'|'||
2821: ecx_utils.g_stage_data(i_counter).cond_var2_direction||'|'||
2814: ecx_utils.g_stage_data(i_counter).cond_val1_pos||'|'||
2815: ecx_utils.g_stage_data(i_counter).cond_val1_direction||'|'||
2816: ecx_utils.g_stage_data(i_counter).cond_val1_constant||'|'||
2817: ecx_utils.g_stage_data(i_counter).cond_operator2||'|'||
2818: ecx_utils.g_stage_data(i_counter).cond_var2_level||'|'||
2819: ecx_utils.g_stage_data(i_counter).cond_var2_name||'|'||
2820: ecx_utils.g_stage_data(i_counter).cond_var2_pos||'|'||
2821: ecx_utils.g_stage_data(i_counter).cond_var2_direction||'|'||
2822: ecx_utils.g_stage_data(i_counter).cond_var2_constant||'|'||
2815: ecx_utils.g_stage_data(i_counter).cond_val1_direction||'|'||
2816: ecx_utils.g_stage_data(i_counter).cond_val1_constant||'|'||
2817: ecx_utils.g_stage_data(i_counter).cond_operator2||'|'||
2818: ecx_utils.g_stage_data(i_counter).cond_var2_level||'|'||
2819: ecx_utils.g_stage_data(i_counter).cond_var2_name||'|'||
2820: ecx_utils.g_stage_data(i_counter).cond_var2_pos||'|'||
2821: ecx_utils.g_stage_data(i_counter).cond_var2_direction||'|'||
2822: ecx_utils.g_stage_data(i_counter).cond_var2_constant||'|'||
2823: ecx_utils.g_stage_data(i_counter).cond_val2_level||'|'||
2816: ecx_utils.g_stage_data(i_counter).cond_val1_constant||'|'||
2817: ecx_utils.g_stage_data(i_counter).cond_operator2||'|'||
2818: ecx_utils.g_stage_data(i_counter).cond_var2_level||'|'||
2819: ecx_utils.g_stage_data(i_counter).cond_var2_name||'|'||
2820: ecx_utils.g_stage_data(i_counter).cond_var2_pos||'|'||
2821: ecx_utils.g_stage_data(i_counter).cond_var2_direction||'|'||
2822: ecx_utils.g_stage_data(i_counter).cond_var2_constant||'|'||
2823: ecx_utils.g_stage_data(i_counter).cond_val2_level||'|'||
2824: ecx_utils.g_stage_data(i_counter).cond_val2_name||'|'||
2817: ecx_utils.g_stage_data(i_counter).cond_operator2||'|'||
2818: ecx_utils.g_stage_data(i_counter).cond_var2_level||'|'||
2819: ecx_utils.g_stage_data(i_counter).cond_var2_name||'|'||
2820: ecx_utils.g_stage_data(i_counter).cond_var2_pos||'|'||
2821: ecx_utils.g_stage_data(i_counter).cond_var2_direction||'|'||
2822: ecx_utils.g_stage_data(i_counter).cond_var2_constant||'|'||
2823: ecx_utils.g_stage_data(i_counter).cond_val2_level||'|'||
2824: ecx_utils.g_stage_data(i_counter).cond_val2_name||'|'||
2825: ecx_utils.g_stage_data(i_counter).cond_val2_pos||'|'||
2818: ecx_utils.g_stage_data(i_counter).cond_var2_level||'|'||
2819: ecx_utils.g_stage_data(i_counter).cond_var2_name||'|'||
2820: ecx_utils.g_stage_data(i_counter).cond_var2_pos||'|'||
2821: ecx_utils.g_stage_data(i_counter).cond_var2_direction||'|'||
2822: ecx_utils.g_stage_data(i_counter).cond_var2_constant||'|'||
2823: ecx_utils.g_stage_data(i_counter).cond_val2_level||'|'||
2824: ecx_utils.g_stage_data(i_counter).cond_val2_name||'|'||
2825: ecx_utils.g_stage_data(i_counter).cond_val2_pos||'|'||
2826: ecx_utils.g_stage_data(i_counter).cond_val2_direction||'|'||
2819: ecx_utils.g_stage_data(i_counter).cond_var2_name||'|'||
2820: ecx_utils.g_stage_data(i_counter).cond_var2_pos||'|'||
2821: ecx_utils.g_stage_data(i_counter).cond_var2_direction||'|'||
2822: ecx_utils.g_stage_data(i_counter).cond_var2_constant||'|'||
2823: ecx_utils.g_stage_data(i_counter).cond_val2_level||'|'||
2824: ecx_utils.g_stage_data(i_counter).cond_val2_name||'|'||
2825: ecx_utils.g_stage_data(i_counter).cond_val2_pos||'|'||
2826: ecx_utils.g_stage_data(i_counter).cond_val2_direction||'|'||
2827: ecx_utils.g_stage_data(i_counter).cond_val2_constant||'|'||
2820: ecx_utils.g_stage_data(i_counter).cond_var2_pos||'|'||
2821: ecx_utils.g_stage_data(i_counter).cond_var2_direction||'|'||
2822: ecx_utils.g_stage_data(i_counter).cond_var2_constant||'|'||
2823: ecx_utils.g_stage_data(i_counter).cond_val2_level||'|'||
2824: ecx_utils.g_stage_data(i_counter).cond_val2_name||'|'||
2825: ecx_utils.g_stage_data(i_counter).cond_val2_pos||'|'||
2826: ecx_utils.g_stage_data(i_counter).cond_val2_direction||'|'||
2827: ecx_utils.g_stage_data(i_counter).cond_val2_constant||'|'||
2828: ecx_utils.g_stage_data(i_counter).operand1_level||'|'||
2821: ecx_utils.g_stage_data(i_counter).cond_var2_direction||'|'||
2822: ecx_utils.g_stage_data(i_counter).cond_var2_constant||'|'||
2823: ecx_utils.g_stage_data(i_counter).cond_val2_level||'|'||
2824: ecx_utils.g_stage_data(i_counter).cond_val2_name||'|'||
2825: ecx_utils.g_stage_data(i_counter).cond_val2_pos||'|'||
2826: ecx_utils.g_stage_data(i_counter).cond_val2_direction||'|'||
2827: ecx_utils.g_stage_data(i_counter).cond_val2_constant||'|'||
2828: ecx_utils.g_stage_data(i_counter).operand1_level||'|'||
2829: ecx_utils.g_stage_data(i_counter).operand1_name||'|'||
2822: ecx_utils.g_stage_data(i_counter).cond_var2_constant||'|'||
2823: ecx_utils.g_stage_data(i_counter).cond_val2_level||'|'||
2824: ecx_utils.g_stage_data(i_counter).cond_val2_name||'|'||
2825: ecx_utils.g_stage_data(i_counter).cond_val2_pos||'|'||
2826: ecx_utils.g_stage_data(i_counter).cond_val2_direction||'|'||
2827: ecx_utils.g_stage_data(i_counter).cond_val2_constant||'|'||
2828: ecx_utils.g_stage_data(i_counter).operand1_level||'|'||
2829: ecx_utils.g_stage_data(i_counter).operand1_name||'|'||
2830: ecx_utils.g_stage_data(i_counter).operand1_pos||'|'||
2823: ecx_utils.g_stage_data(i_counter).cond_val2_level||'|'||
2824: ecx_utils.g_stage_data(i_counter).cond_val2_name||'|'||
2825: ecx_utils.g_stage_data(i_counter).cond_val2_pos||'|'||
2826: ecx_utils.g_stage_data(i_counter).cond_val2_direction||'|'||
2827: ecx_utils.g_stage_data(i_counter).cond_val2_constant||'|'||
2828: ecx_utils.g_stage_data(i_counter).operand1_level||'|'||
2829: ecx_utils.g_stage_data(i_counter).operand1_name||'|'||
2830: ecx_utils.g_stage_data(i_counter).operand1_pos||'|'||
2831: ecx_utils.g_stage_data(i_counter).operand1_direction||'|'||
2824: ecx_utils.g_stage_data(i_counter).cond_val2_name||'|'||
2825: ecx_utils.g_stage_data(i_counter).cond_val2_pos||'|'||
2826: ecx_utils.g_stage_data(i_counter).cond_val2_direction||'|'||
2827: ecx_utils.g_stage_data(i_counter).cond_val2_constant||'|'||
2828: ecx_utils.g_stage_data(i_counter).operand1_level||'|'||
2829: ecx_utils.g_stage_data(i_counter).operand1_name||'|'||
2830: ecx_utils.g_stage_data(i_counter).operand1_pos||'|'||
2831: ecx_utils.g_stage_data(i_counter).operand1_direction||'|'||
2832: ecx_utils.g_stage_data(i_counter).operand1_constant||'|'||
2825: ecx_utils.g_stage_data(i_counter).cond_val2_pos||'|'||
2826: ecx_utils.g_stage_data(i_counter).cond_val2_direction||'|'||
2827: ecx_utils.g_stage_data(i_counter).cond_val2_constant||'|'||
2828: ecx_utils.g_stage_data(i_counter).operand1_level||'|'||
2829: ecx_utils.g_stage_data(i_counter).operand1_name||'|'||
2830: ecx_utils.g_stage_data(i_counter).operand1_pos||'|'||
2831: ecx_utils.g_stage_data(i_counter).operand1_direction||'|'||
2832: ecx_utils.g_stage_data(i_counter).operand1_constant||'|'||
2833: ecx_utils.g_stage_data(i_counter).operand1_start_pos||'|'||
2826: ecx_utils.g_stage_data(i_counter).cond_val2_direction||'|'||
2827: ecx_utils.g_stage_data(i_counter).cond_val2_constant||'|'||
2828: ecx_utils.g_stage_data(i_counter).operand1_level||'|'||
2829: ecx_utils.g_stage_data(i_counter).operand1_name||'|'||
2830: ecx_utils.g_stage_data(i_counter).operand1_pos||'|'||
2831: ecx_utils.g_stage_data(i_counter).operand1_direction||'|'||
2832: ecx_utils.g_stage_data(i_counter).operand1_constant||'|'||
2833: ecx_utils.g_stage_data(i_counter).operand1_start_pos||'|'||
2834: ecx_utils.g_stage_data(i_counter).operand1_len||'|'||
2827: ecx_utils.g_stage_data(i_counter).cond_val2_constant||'|'||
2828: ecx_utils.g_stage_data(i_counter).operand1_level||'|'||
2829: ecx_utils.g_stage_data(i_counter).operand1_name||'|'||
2830: ecx_utils.g_stage_data(i_counter).operand1_pos||'|'||
2831: ecx_utils.g_stage_data(i_counter).operand1_direction||'|'||
2832: ecx_utils.g_stage_data(i_counter).operand1_constant||'|'||
2833: ecx_utils.g_stage_data(i_counter).operand1_start_pos||'|'||
2834: ecx_utils.g_stage_data(i_counter).operand1_len||'|'||
2835: ecx_utils.g_stage_data(i_counter).operand2_level||'|'||
2828: ecx_utils.g_stage_data(i_counter).operand1_level||'|'||
2829: ecx_utils.g_stage_data(i_counter).operand1_name||'|'||
2830: ecx_utils.g_stage_data(i_counter).operand1_pos||'|'||
2831: ecx_utils.g_stage_data(i_counter).operand1_direction||'|'||
2832: ecx_utils.g_stage_data(i_counter).operand1_constant||'|'||
2833: ecx_utils.g_stage_data(i_counter).operand1_start_pos||'|'||
2834: ecx_utils.g_stage_data(i_counter).operand1_len||'|'||
2835: ecx_utils.g_stage_data(i_counter).operand2_level||'|'||
2836: ecx_utils.g_stage_data(i_counter).operand2_name||'|'||
2829: ecx_utils.g_stage_data(i_counter).operand1_name||'|'||
2830: ecx_utils.g_stage_data(i_counter).operand1_pos||'|'||
2831: ecx_utils.g_stage_data(i_counter).operand1_direction||'|'||
2832: ecx_utils.g_stage_data(i_counter).operand1_constant||'|'||
2833: ecx_utils.g_stage_data(i_counter).operand1_start_pos||'|'||
2834: ecx_utils.g_stage_data(i_counter).operand1_len||'|'||
2835: ecx_utils.g_stage_data(i_counter).operand2_level||'|'||
2836: ecx_utils.g_stage_data(i_counter).operand2_name||'|'||
2837: ecx_utils.g_stage_data(i_counter).operand2_pos||'|'||
2830: ecx_utils.g_stage_data(i_counter).operand1_pos||'|'||
2831: ecx_utils.g_stage_data(i_counter).operand1_direction||'|'||
2832: ecx_utils.g_stage_data(i_counter).operand1_constant||'|'||
2833: ecx_utils.g_stage_data(i_counter).operand1_start_pos||'|'||
2834: ecx_utils.g_stage_data(i_counter).operand1_len||'|'||
2835: ecx_utils.g_stage_data(i_counter).operand2_level||'|'||
2836: ecx_utils.g_stage_data(i_counter).operand2_name||'|'||
2837: ecx_utils.g_stage_data(i_counter).operand2_pos||'|'||
2838: ecx_utils.g_stage_data(i_counter).operand2_direction||'|'||
2831: ecx_utils.g_stage_data(i_counter).operand1_direction||'|'||
2832: ecx_utils.g_stage_data(i_counter).operand1_constant||'|'||
2833: ecx_utils.g_stage_data(i_counter).operand1_start_pos||'|'||
2834: ecx_utils.g_stage_data(i_counter).operand1_len||'|'||
2835: ecx_utils.g_stage_data(i_counter).operand2_level||'|'||
2836: ecx_utils.g_stage_data(i_counter).operand2_name||'|'||
2837: ecx_utils.g_stage_data(i_counter).operand2_pos||'|'||
2838: ecx_utils.g_stage_data(i_counter).operand2_direction||'|'||
2839: ecx_utils.g_stage_data(i_counter).operand2_constant||'|'||
2832: ecx_utils.g_stage_data(i_counter).operand1_constant||'|'||
2833: ecx_utils.g_stage_data(i_counter).operand1_start_pos||'|'||
2834: ecx_utils.g_stage_data(i_counter).operand1_len||'|'||
2835: ecx_utils.g_stage_data(i_counter).operand2_level||'|'||
2836: ecx_utils.g_stage_data(i_counter).operand2_name||'|'||
2837: ecx_utils.g_stage_data(i_counter).operand2_pos||'|'||
2838: ecx_utils.g_stage_data(i_counter).operand2_direction||'|'||
2839: ecx_utils.g_stage_data(i_counter).operand2_constant||'|'||
2840: ecx_utils.g_stage_data(i_counter).operand3_level||'|'||
2833: ecx_utils.g_stage_data(i_counter).operand1_start_pos||'|'||
2834: ecx_utils.g_stage_data(i_counter).operand1_len||'|'||
2835: ecx_utils.g_stage_data(i_counter).operand2_level||'|'||
2836: ecx_utils.g_stage_data(i_counter).operand2_name||'|'||
2837: ecx_utils.g_stage_data(i_counter).operand2_pos||'|'||
2838: ecx_utils.g_stage_data(i_counter).operand2_direction||'|'||
2839: ecx_utils.g_stage_data(i_counter).operand2_constant||'|'||
2840: ecx_utils.g_stage_data(i_counter).operand3_level||'|'||
2841: ecx_utils.g_stage_data(i_counter).operand3_name||'|'||
2834: ecx_utils.g_stage_data(i_counter).operand1_len||'|'||
2835: ecx_utils.g_stage_data(i_counter).operand2_level||'|'||
2836: ecx_utils.g_stage_data(i_counter).operand2_name||'|'||
2837: ecx_utils.g_stage_data(i_counter).operand2_pos||'|'||
2838: ecx_utils.g_stage_data(i_counter).operand2_direction||'|'||
2839: ecx_utils.g_stage_data(i_counter).operand2_constant||'|'||
2840: ecx_utils.g_stage_data(i_counter).operand3_level||'|'||
2841: ecx_utils.g_stage_data(i_counter).operand3_name||'|'||
2842: ecx_utils.g_stage_data(i_counter).operand3_pos||'|'||
2835: ecx_utils.g_stage_data(i_counter).operand2_level||'|'||
2836: ecx_utils.g_stage_data(i_counter).operand2_name||'|'||
2837: ecx_utils.g_stage_data(i_counter).operand2_pos||'|'||
2838: ecx_utils.g_stage_data(i_counter).operand2_direction||'|'||
2839: ecx_utils.g_stage_data(i_counter).operand2_constant||'|'||
2840: ecx_utils.g_stage_data(i_counter).operand3_level||'|'||
2841: ecx_utils.g_stage_data(i_counter).operand3_name||'|'||
2842: ecx_utils.g_stage_data(i_counter).operand3_pos||'|'||
2843: ecx_utils.g_stage_data(i_counter).operand3_direction||'|'||
2836: ecx_utils.g_stage_data(i_counter).operand2_name||'|'||
2837: ecx_utils.g_stage_data(i_counter).operand2_pos||'|'||
2838: ecx_utils.g_stage_data(i_counter).operand2_direction||'|'||
2839: ecx_utils.g_stage_data(i_counter).operand2_constant||'|'||
2840: ecx_utils.g_stage_data(i_counter).operand3_level||'|'||
2841: ecx_utils.g_stage_data(i_counter).operand3_name||'|'||
2842: ecx_utils.g_stage_data(i_counter).operand3_pos||'|'||
2843: ecx_utils.g_stage_data(i_counter).operand3_direction||'|'||
2844: ecx_utils.g_stage_data(i_counter).operand3_constant||'|'||
2837: ecx_utils.g_stage_data(i_counter).operand2_pos||'|'||
2838: ecx_utils.g_stage_data(i_counter).operand2_direction||'|'||
2839: ecx_utils.g_stage_data(i_counter).operand2_constant||'|'||
2840: ecx_utils.g_stage_data(i_counter).operand3_level||'|'||
2841: ecx_utils.g_stage_data(i_counter).operand3_name||'|'||
2842: ecx_utils.g_stage_data(i_counter).operand3_pos||'|'||
2843: ecx_utils.g_stage_data(i_counter).operand3_direction||'|'||
2844: ecx_utils.g_stage_data(i_counter).operand3_constant||'|'||
2845: ecx_utils.g_stage_data(i_counter).operand4_level||'|'||
2838: ecx_utils.g_stage_data(i_counter).operand2_direction||'|'||
2839: ecx_utils.g_stage_data(i_counter).operand2_constant||'|'||
2840: ecx_utils.g_stage_data(i_counter).operand3_level||'|'||
2841: ecx_utils.g_stage_data(i_counter).operand3_name||'|'||
2842: ecx_utils.g_stage_data(i_counter).operand3_pos||'|'||
2843: ecx_utils.g_stage_data(i_counter).operand3_direction||'|'||
2844: ecx_utils.g_stage_data(i_counter).operand3_constant||'|'||
2845: ecx_utils.g_stage_data(i_counter).operand4_level||'|'||
2846: ecx_utils.g_stage_data(i_counter).operand4_name||'|'||
2839: ecx_utils.g_stage_data(i_counter).operand2_constant||'|'||
2840: ecx_utils.g_stage_data(i_counter).operand3_level||'|'||
2841: ecx_utils.g_stage_data(i_counter).operand3_name||'|'||
2842: ecx_utils.g_stage_data(i_counter).operand3_pos||'|'||
2843: ecx_utils.g_stage_data(i_counter).operand3_direction||'|'||
2844: ecx_utils.g_stage_data(i_counter).operand3_constant||'|'||
2845: ecx_utils.g_stage_data(i_counter).operand4_level||'|'||
2846: ecx_utils.g_stage_data(i_counter).operand4_name||'|'||
2847: ecx_utils.g_stage_data(i_counter).operand4_pos||'|'||
2840: ecx_utils.g_stage_data(i_counter).operand3_level||'|'||
2841: ecx_utils.g_stage_data(i_counter).operand3_name||'|'||
2842: ecx_utils.g_stage_data(i_counter).operand3_pos||'|'||
2843: ecx_utils.g_stage_data(i_counter).operand3_direction||'|'||
2844: ecx_utils.g_stage_data(i_counter).operand3_constant||'|'||
2845: ecx_utils.g_stage_data(i_counter).operand4_level||'|'||
2846: ecx_utils.g_stage_data(i_counter).operand4_name||'|'||
2847: ecx_utils.g_stage_data(i_counter).operand4_pos||'|'||
2848: ecx_utils.g_stage_data(i_counter).operand4_direction||'|'||
2841: ecx_utils.g_stage_data(i_counter).operand3_name||'|'||
2842: ecx_utils.g_stage_data(i_counter).operand3_pos||'|'||
2843: ecx_utils.g_stage_data(i_counter).operand3_direction||'|'||
2844: ecx_utils.g_stage_data(i_counter).operand3_constant||'|'||
2845: ecx_utils.g_stage_data(i_counter).operand4_level||'|'||
2846: ecx_utils.g_stage_data(i_counter).operand4_name||'|'||
2847: ecx_utils.g_stage_data(i_counter).operand4_pos||'|'||
2848: ecx_utils.g_stage_data(i_counter).operand4_direction||'|'||
2849: ecx_utils.g_stage_data(i_counter).operand4_constant||'|'||
2842: ecx_utils.g_stage_data(i_counter).operand3_pos||'|'||
2843: ecx_utils.g_stage_data(i_counter).operand3_direction||'|'||
2844: ecx_utils.g_stage_data(i_counter).operand3_constant||'|'||
2845: ecx_utils.g_stage_data(i_counter).operand4_level||'|'||
2846: ecx_utils.g_stage_data(i_counter).operand4_name||'|'||
2847: ecx_utils.g_stage_data(i_counter).operand4_pos||'|'||
2848: ecx_utils.g_stage_data(i_counter).operand4_direction||'|'||
2849: ecx_utils.g_stage_data(i_counter).operand4_constant||'|'||
2850: ecx_utils.g_stage_data(i_counter).operand5_level||'|'||
2843: ecx_utils.g_stage_data(i_counter).operand3_direction||'|'||
2844: ecx_utils.g_stage_data(i_counter).operand3_constant||'|'||
2845: ecx_utils.g_stage_data(i_counter).operand4_level||'|'||
2846: ecx_utils.g_stage_data(i_counter).operand4_name||'|'||
2847: ecx_utils.g_stage_data(i_counter).operand4_pos||'|'||
2848: ecx_utils.g_stage_data(i_counter).operand4_direction||'|'||
2849: ecx_utils.g_stage_data(i_counter).operand4_constant||'|'||
2850: ecx_utils.g_stage_data(i_counter).operand5_level||'|'||
2851: ecx_utils.g_stage_data(i_counter).operand5_name||'|'||
2844: ecx_utils.g_stage_data(i_counter).operand3_constant||'|'||
2845: ecx_utils.g_stage_data(i_counter).operand4_level||'|'||
2846: ecx_utils.g_stage_data(i_counter).operand4_name||'|'||
2847: ecx_utils.g_stage_data(i_counter).operand4_pos||'|'||
2848: ecx_utils.g_stage_data(i_counter).operand4_direction||'|'||
2849: ecx_utils.g_stage_data(i_counter).operand4_constant||'|'||
2850: ecx_utils.g_stage_data(i_counter).operand5_level||'|'||
2851: ecx_utils.g_stage_data(i_counter).operand5_name||'|'||
2852: ecx_utils.g_stage_data(i_counter).operand5_pos||'|'||
2845: ecx_utils.g_stage_data(i_counter).operand4_level||'|'||
2846: ecx_utils.g_stage_data(i_counter).operand4_name||'|'||
2847: ecx_utils.g_stage_data(i_counter).operand4_pos||'|'||
2848: ecx_utils.g_stage_data(i_counter).operand4_direction||'|'||
2849: ecx_utils.g_stage_data(i_counter).operand4_constant||'|'||
2850: ecx_utils.g_stage_data(i_counter).operand5_level||'|'||
2851: ecx_utils.g_stage_data(i_counter).operand5_name||'|'||
2852: ecx_utils.g_stage_data(i_counter).operand5_pos||'|'||
2853: ecx_utils.g_stage_data(i_counter).operand5_direction||'|'||
2846: ecx_utils.g_stage_data(i_counter).operand4_name||'|'||
2847: ecx_utils.g_stage_data(i_counter).operand4_pos||'|'||
2848: ecx_utils.g_stage_data(i_counter).operand4_direction||'|'||
2849: ecx_utils.g_stage_data(i_counter).operand4_constant||'|'||
2850: ecx_utils.g_stage_data(i_counter).operand5_level||'|'||
2851: ecx_utils.g_stage_data(i_counter).operand5_name||'|'||
2852: ecx_utils.g_stage_data(i_counter).operand5_pos||'|'||
2853: ecx_utils.g_stage_data(i_counter).operand5_direction||'|'||
2854: ecx_utils.g_stage_data(i_counter).operand5_constant||'|'||
2847: ecx_utils.g_stage_data(i_counter).operand4_pos||'|'||
2848: ecx_utils.g_stage_data(i_counter).operand4_direction||'|'||
2849: ecx_utils.g_stage_data(i_counter).operand4_constant||'|'||
2850: ecx_utils.g_stage_data(i_counter).operand5_level||'|'||
2851: ecx_utils.g_stage_data(i_counter).operand5_name||'|'||
2852: ecx_utils.g_stage_data(i_counter).operand5_pos||'|'||
2853: ecx_utils.g_stage_data(i_counter).operand5_direction||'|'||
2854: ecx_utils.g_stage_data(i_counter).operand5_constant||'|'||
2855: ecx_utils.g_stage_data(i_counter).operand6_level||'|'||
2848: ecx_utils.g_stage_data(i_counter).operand4_direction||'|'||
2849: ecx_utils.g_stage_data(i_counter).operand4_constant||'|'||
2850: ecx_utils.g_stage_data(i_counter).operand5_level||'|'||
2851: ecx_utils.g_stage_data(i_counter).operand5_name||'|'||
2852: ecx_utils.g_stage_data(i_counter).operand5_pos||'|'||
2853: ecx_utils.g_stage_data(i_counter).operand5_direction||'|'||
2854: ecx_utils.g_stage_data(i_counter).operand5_constant||'|'||
2855: ecx_utils.g_stage_data(i_counter).operand6_level||'|'||
2856: ecx_utils.g_stage_data(i_counter).operand6_name||'|'||
2849: ecx_utils.g_stage_data(i_counter).operand4_constant||'|'||
2850: ecx_utils.g_stage_data(i_counter).operand5_level||'|'||
2851: ecx_utils.g_stage_data(i_counter).operand5_name||'|'||
2852: ecx_utils.g_stage_data(i_counter).operand5_pos||'|'||
2853: ecx_utils.g_stage_data(i_counter).operand5_direction||'|'||
2854: ecx_utils.g_stage_data(i_counter).operand5_constant||'|'||
2855: ecx_utils.g_stage_data(i_counter).operand6_level||'|'||
2856: ecx_utils.g_stage_data(i_counter).operand6_name||'|'||
2857: ecx_utils.g_stage_data(i_counter).operand6_pos||'|'||
2850: ecx_utils.g_stage_data(i_counter).operand5_level||'|'||
2851: ecx_utils.g_stage_data(i_counter).operand5_name||'|'||
2852: ecx_utils.g_stage_data(i_counter).operand5_pos||'|'||
2853: ecx_utils.g_stage_data(i_counter).operand5_direction||'|'||
2854: ecx_utils.g_stage_data(i_counter).operand5_constant||'|'||
2855: ecx_utils.g_stage_data(i_counter).operand6_level||'|'||
2856: ecx_utils.g_stage_data(i_counter).operand6_name||'|'||
2857: ecx_utils.g_stage_data(i_counter).operand6_pos||'|'||
2858: ecx_utils.g_stage_data(i_counter).operand6_direction||'|'||
2851: ecx_utils.g_stage_data(i_counter).operand5_name||'|'||
2852: ecx_utils.g_stage_data(i_counter).operand5_pos||'|'||
2853: ecx_utils.g_stage_data(i_counter).operand5_direction||'|'||
2854: ecx_utils.g_stage_data(i_counter).operand5_constant||'|'||
2855: ecx_utils.g_stage_data(i_counter).operand6_level||'|'||
2856: ecx_utils.g_stage_data(i_counter).operand6_name||'|'||
2857: ecx_utils.g_stage_data(i_counter).operand6_pos||'|'||
2858: ecx_utils.g_stage_data(i_counter).operand6_direction||'|'||
2859: ecx_utils.g_stage_data(i_counter).operand6_constant,
2852: ecx_utils.g_stage_data(i_counter).operand5_pos||'|'||
2853: ecx_utils.g_stage_data(i_counter).operand5_direction||'|'||
2854: ecx_utils.g_stage_data(i_counter).operand5_constant||'|'||
2855: ecx_utils.g_stage_data(i_counter).operand6_level||'|'||
2856: ecx_utils.g_stage_data(i_counter).operand6_name||'|'||
2857: ecx_utils.g_stage_data(i_counter).operand6_pos||'|'||
2858: ecx_utils.g_stage_data(i_counter).operand6_direction||'|'||
2859: ecx_utils.g_stage_data(i_counter).operand6_constant,
2860: i_method_name
2853: ecx_utils.g_stage_data(i_counter).operand5_direction||'|'||
2854: ecx_utils.g_stage_data(i_counter).operand5_constant||'|'||
2855: ecx_utils.g_stage_data(i_counter).operand6_level||'|'||
2856: ecx_utils.g_stage_data(i_counter).operand6_name||'|'||
2857: ecx_utils.g_stage_data(i_counter).operand6_pos||'|'||
2858: ecx_utils.g_stage_data(i_counter).operand6_direction||'|'||
2859: ecx_utils.g_stage_data(i_counter).operand6_constant,
2860: i_method_name
2861: );
2854: ecx_utils.g_stage_data(i_counter).operand5_constant||'|'||
2855: ecx_utils.g_stage_data(i_counter).operand6_level||'|'||
2856: ecx_utils.g_stage_data(i_counter).operand6_name||'|'||
2857: ecx_utils.g_stage_data(i_counter).operand6_pos||'|'||
2858: ecx_utils.g_stage_data(i_counter).operand6_direction||'|'||
2859: ecx_utils.g_stage_data(i_counter).operand6_constant,
2860: i_method_name
2861: );
2862: end if;
2855: ecx_utils.g_stage_data(i_counter).operand6_level||'|'||
2856: ecx_utils.g_stage_data(i_counter).operand6_name||'|'||
2857: ecx_utils.g_stage_data(i_counter).operand6_pos||'|'||
2858: ecx_utils.g_stage_data(i_counter).operand6_direction||'|'||
2859: ecx_utils.g_stage_data(i_counter).operand6_constant,
2860: i_method_name
2861: );
2862: end if;
2863: i_counter := i_counter + 1;
2867: ecx_debug.pop(i_method_name);
2868: end if;
2869:
2870: EXCEPTION
2871: WHEN ecx_utils.PROGRAM_EXIT then
2872: if (l_procedureEnabled) then
2873: ecx_debug.pop(i_method_name);
2874: end if;
2875: raise;
2876:
2877: WHEN OTHERS THEN
2878: if(l_unexpectedEnabled) then
2879: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', i_method_name, 'PROGRESS_LEVEL',
2880: 'ecx_UTILS.GET_TRAN_STAGE_DATA');
2881: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE', i_method_name,'ERROR_MESSAGE', SQLERRM);
2882: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.GET_TRAN_STAGE_DATA: ',
2883: i_method_name);
2884: end if;
2878: if(l_unexpectedEnabled) then
2879: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', i_method_name, 'PROGRESS_LEVEL',
2880: 'ecx_UTILS.GET_TRAN_STAGE_DATA');
2881: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE', i_method_name,'ERROR_MESSAGE', SQLERRM);
2882: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.GET_TRAN_STAGE_DATA: ',
2883: i_method_name);
2884: end if;
2885: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.GET_TRAN_STAGE_DATA: ');
2886: if (l_procedureEnabled) then
2881: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE', i_method_name,'ERROR_MESSAGE', SQLERRM);
2882: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.GET_TRAN_STAGE_DATA: ',
2883: i_method_name);
2884: end if;
2885: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.GET_TRAN_STAGE_DATA: ');
2886: if (l_procedureEnabled) then
2887: ecx_debug.pop(i_method_name);
2888: end if;
2889: raise ecx_utils.PROGRAM_EXIT;
2885: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.GET_TRAN_STAGE_DATA: ');
2886: if (l_procedureEnabled) then
2887: ecx_debug.pop(i_method_name);
2888: end if;
2889: raise ecx_utils.PROGRAM_EXIT;
2890:
2891: END get_tran_stage_data;
2892:
2893: procedure getLogDirectory
2891: END get_tran_stage_data;
2892:
2893: procedure getLogDirectory
2894: is
2895: i_method_name varchar2(2000) := 'ecx_utils.getLogDirectory';
2896: i_string varchar2(2000);
2897: begin
2898: --- Check for the Installation Type ( Standalone or Embedded );
2899: ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');
2895: i_method_name varchar2(2000) := 'ecx_utils.getLogDirectory';
2896: i_string varchar2(2000);
2897: begin
2898: --- Check for the Installation Type ( Standalone or Embedded );
2899: ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');
2900:
2901: if ecx_utils.g_install_mode = 'EMBEDDED'
2902: then
2903: i_string := 'begin
2897: begin
2898: --- Check for the Installation Type ( Standalone or Embedded );
2899: ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');
2900:
2901: if ecx_utils.g_install_mode = 'EMBEDDED'
2902: then
2903: i_string := 'begin
2904: fnd_profile.get('||'''ECX_UTL_LOG_DIR'''||',ecx_utils.g_logdir);
2905: end;';
2900:
2901: if ecx_utils.g_install_mode = 'EMBEDDED'
2902: then
2903: i_string := 'begin
2904: fnd_profile.get('||'''ECX_UTL_LOG_DIR'''||',ecx_utils.g_logdir);
2905: end;';
2906: execute immediate i_string ;
2907: else
2908: ecx_utils.g_logdir := wf_core.translate('ECX_UTL_LOG_DIR');
2904: fnd_profile.get('||'''ECX_UTL_LOG_DIR'''||',ecx_utils.g_logdir);
2905: end;';
2906: execute immediate i_string ;
2907: else
2908: ecx_utils.g_logdir := wf_core.translate('ECX_UTL_LOG_DIR');
2909: end if;
2910:
2911:
2912: /* Remove the additional '/' at the end of the profile option if present
2911:
2912: /* Remove the additional '/' at the end of the profile option if present
2913: or else it will cause error in the ecx_debug.print_log */
2914:
2915: If (ecx_utils.g_logdir is not null) then
2916: if (substr(ecx_utils.g_logdir,-1,1) = '/') then
2917: ecx_utils.g_logdir := substr(ecx_utils.g_logdir,1,
2918: length(ecx_utils.g_logdir)-1);
2919: end if;
2912: /* Remove the additional '/' at the end of the profile option if present
2913: or else it will cause error in the ecx_debug.print_log */
2914:
2915: If (ecx_utils.g_logdir is not null) then
2916: if (substr(ecx_utils.g_logdir,-1,1) = '/') then
2917: ecx_utils.g_logdir := substr(ecx_utils.g_logdir,1,
2918: length(ecx_utils.g_logdir)-1);
2919: end if;
2920: End If;
2913: or else it will cause error in the ecx_debug.print_log */
2914:
2915: If (ecx_utils.g_logdir is not null) then
2916: if (substr(ecx_utils.g_logdir,-1,1) = '/') then
2917: ecx_utils.g_logdir := substr(ecx_utils.g_logdir,1,
2918: length(ecx_utils.g_logdir)-1);
2919: end if;
2920: End If;
2921: if(l_statementEnabled) then
2914:
2915: If (ecx_utils.g_logdir is not null) then
2916: if (substr(ecx_utils.g_logdir,-1,1) = '/') then
2917: ecx_utils.g_logdir := substr(ecx_utils.g_logdir,1,
2918: length(ecx_utils.g_logdir)-1);
2919: end if;
2920: End If;
2921: if(l_statementEnabled) then
2922: ecx_debug.log(l_statement, 'ecx_utils.g_logdir',ecx_utils.g_logdir,i_method_name);
2918: length(ecx_utils.g_logdir)-1);
2919: end if;
2920: End If;
2921: if(l_statementEnabled) then
2922: ecx_debug.log(l_statement, 'ecx_utils.g_logdir',ecx_utils.g_logdir,i_method_name);
2923: end if;
2924:
2925: exception
2926: when others then
2923: end if;
2924:
2925: exception
2926: when others then
2927: raise ecx_utils.program_exit;
2928: end getLogDirectory;
2929:
2930: /*
2931: Gets the file separator from the SystemProperty class
2967: p_token10 in varchar2,
2968: p_value10 in varchar2
2969: )
2970: is
2971: i_method_name varchar2(2000) := 'ecx_utils.set_error';
2972: begin
2973:
2974: if (l_procedureEnabled) then
2975: ecx_debug.push(i_method_name);
3004: exception
3005: when others then
3006: if(l_unexpectedEnabled) then
3007: ecx_debug.log(l_unexpected, 'ECX', 'ECX_PROGRAM_ERROR', i_method_name, 'PROGRESS_LEVEL',
3008: 'ECX_UTILS.SET_ERROR',i_method_name);
3009: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM,i_method_name);
3010: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.SET_ERROR: ',
3011: i_method_name);
3012: end if;
3006: if(l_unexpectedEnabled) then
3007: ecx_debug.log(l_unexpected, 'ECX', 'ECX_PROGRAM_ERROR', i_method_name, 'PROGRESS_LEVEL',
3008: 'ECX_UTILS.SET_ERROR',i_method_name);
3009: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM,i_method_name);
3010: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.SET_ERROR: ',
3011: i_method_name);
3012: end if;
3013: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.SET_ERROR: ');
3014: if (l_procedureEnabled) then
3009: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM,i_method_name);
3010: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.SET_ERROR: ',
3011: i_method_name);
3012: end if;
3013: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.SET_ERROR: ');
3014: if (l_procedureEnabled) then
3015: ecx_debug.pop(i_method_name);
3016: end if;
3017: raise ecx_utils.PROGRAM_EXIT;
3013: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.SET_ERROR: ');
3014: if (l_procedureEnabled) then
3015: ecx_debug.pop(i_method_name);
3016: end if;
3017: raise ecx_utils.PROGRAM_EXIT;
3018: end set_error;
3019:
3020: procedure convertPartyTypeToCode(
3021: p_party_type IN Varchar2,
3019:
3020: procedure convertPartyTypeToCode(
3021: p_party_type IN Varchar2,
3022: x_party_type OUT NOCOPY Varchar2) is
3023: i_method_name varchar2(2000) := 'ecx_utils.convertPartyTypeToCode';
3024: begin
3025: if (p_party_type is not null) then
3026: x_party_type := UPPER(p_party_type);
3027: if (x_party_type = 'BANK' or x_party_type = 'B') then
3043: x_party_type := null;
3044: end if;
3045: exception
3046: when others then
3047: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_UTILS.ConvertPartyTypeToCode: ');
3048: if(l_unexpectedEnabled) then
3049: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
3050: end if;
3051: if (l_procedureEnabled) then
3045: exception
3046: when others then
3047: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_UTILS.ConvertPartyTypeToCode: ');
3048: if(l_unexpectedEnabled) then
3049: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
3050: end if;
3051: if (l_procedureEnabled) then
3052: ecx_debug.pop(i_method_name);
3053: end if;
3050: end if;
3051: if (l_procedureEnabled) then
3052: ecx_debug.pop(i_method_name);
3053: end if;
3054: raise ecx_utils.PROGRAM_EXIT;
3055: end convertPartyTypeToCode;
3056:
3057: /* Return the node path of given attribute, from root till it's parent attribute*/
3058: function getNodePath
3058: function getNodePath
3059: (v_map_id IN NUMBER,
3060: v_attribute_id IN NUMBER) return varchar2
3061: IS
3062: i_method_name varchar2(2000) := 'ecx_utils.getNodePath';
3063: l_attribute_name ecx_object_attributes.attribute_name%type;
3064: l_attribute_id ecx_object_attributes.attribute_id%type;
3065: l_node_path varchar2(32767);
3066: l_parent_name ecx_object_attributes.attribute_name%type;
3115: end if;
3116: return l_node_path;
3117: exception
3118: when others then
3119: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_UTILS.getNodePath ');
3120: if(l_unexpectedEnabled) then
3121: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
3122: end if;
3123: if (l_procedureEnabled) then
3117: exception
3118: when others then
3119: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_UTILS.getNodePath ');
3120: if(l_unexpectedEnabled) then
3121: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
3122: end if;
3123: if (l_procedureEnabled) then
3124: ecx_debug.pop(i_method_name);
3125: end if;
3122: end if;
3123: if (l_procedureEnabled) then
3124: ecx_debug.pop(i_method_name);
3125: end if;
3126: raise ecx_utils.PROGRAM_EXIT;
3127: End getNodePath;
3128:
3129: /*get XML Parser version*/
3130:
3138: procedure clobToDomNode (
3139: p_xmlclob IN clob,
3140: x_xmldoc OUT NOCOPY xmlDOM.DOMNode)
3141: is
3142: i_method_name varchar2(2000) := 'ecx_utils.clobToDomNode';
3143: l_parser xmlparser.parser;
3144: l_ndoc xmlDOM.DOMDOcument;
3145: begin
3146: l_parser := xmlparser.newParser;
3162: if (l_parser.id <> -1)
3163: then
3164: xmlParser.freeParser(l_parser);
3165: end if;
3166: raise ecx_utils.program_exit;
3167: end clobToDomNode;
3168:
3169: end ecx_utils;
3165: end if;
3166: raise ecx_utils.program_exit;
3167: end clobToDomNode;
3168:
3169: end ecx_utils;