[Home] [Help]
1: package body ecx_utils as
2: -- $Header: ECXUTILB.pls 120.11 2008/05/02 19:03:17 cpeixoto 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:
1921: if (l_procedureEnabled) then
1922: ecx_debug.pop(i_method_name);
1931: if get_dtd%ISOPEN
1932: then
1933: close get_dtd;
1934: end if;
1935: ecx_utils.g_map_id := -1;
1936: ecx_utils.g_node_tbl.DELETE;
1937: raise program_exit;
1938:
1939: WHEN PROGRAM_EXIT then
1932: then
1933: close get_dtd;
1934: end if;
1935: ecx_utils.g_map_id := -1;
1936: ecx_utils.g_node_tbl.DELETE;
1937: raise program_exit;
1938:
1939: WHEN PROGRAM_EXIT then
1940: ecx_utils.g_map_id := -1;
1936: ecx_utils.g_node_tbl.DELETE;
1937: raise program_exit;
1938:
1939: WHEN PROGRAM_EXIT then
1940: ecx_utils.g_map_id := -1;
1941: ecx_utils.g_node_tbl.DELETE;
1942: if (l_procedureEnabled) then
1943: ecx_debug.pop(i_method_name);
1944: end if;
1937: raise program_exit;
1938:
1939: WHEN PROGRAM_EXIT then
1940: ecx_utils.g_map_id := -1;
1941: ecx_utils.g_node_tbl.DELETE;
1942: if (l_procedureEnabled) then
1943: ecx_debug.pop(i_method_name);
1944: end if;
1945: raise;
1946:
1947: WHEN OTHERS THEN
1948: if(l_unexpectedEnabled) then
1949: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR',i_method_name, 'PROGRESS_LEVEL',
1950: 'ecx_utils.INITIALIZE');
1951: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1952: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.INITIALIZE: ',
1953: i_method_name);
1954: end if;
1948: if(l_unexpectedEnabled) then
1949: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR',i_method_name, 'PROGRESS_LEVEL',
1950: 'ecx_utils.INITIALIZE');
1951: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1952: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.INITIALIZE: ',
1953: i_method_name);
1954: end if;
1955: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.INITIALIZE: ');
1956: ecx_utils.g_map_id := -1;
1951: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1952: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.INITIALIZE: ',
1953: i_method_name);
1954: end if;
1955: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.INITIALIZE: ');
1956: ecx_utils.g_map_id := -1;
1957: ecx_utils.g_node_tbl.DELETE;
1958: if (l_procedureEnabled) then
1959: ecx_debug.pop(i_method_name);
1952: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.INITIALIZE: ',
1953: i_method_name);
1954: end if;
1955: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.INITIALIZE: ');
1956: ecx_utils.g_map_id := -1;
1957: ecx_utils.g_node_tbl.DELETE;
1958: if (l_procedureEnabled) then
1959: ecx_debug.pop(i_method_name);
1960: end if;
1953: i_method_name);
1954: end if;
1955: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.INITIALIZE: ');
1956: ecx_utils.g_map_id := -1;
1957: ecx_utils.g_node_tbl.DELETE;
1958: if (l_procedureEnabled) then
1959: ecx_debug.pop(i_method_name);
1960: end if;
1961: raise PROGRAM_EXIT;
1963: end initialize;
1964:
1965: procedure close_process IS
1966:
1967: i_method_name varchar2(2000) := 'ecx_utils.close_process';
1968: i pls_integer;
1969: j pls_integer;
1970:
1971: -- bug 6922998
2004: end if;
2005: end loop;
2006: end if;
2007:
2008: IF (ecx_utils.g_procedure_list.count > 0) THEN
2009: j := ecx_utils.g_procedure_list.first;
2010: WHILE j IS NOT NULL LOOP
2011: if (ecx_utils.g_procedure_list(j).cursor_handle > 0) and
2012: (ecx_utils.g_procedure_list(j).cursor_handle is not null) and
2005: end loop;
2006: end if;
2007:
2008: IF (ecx_utils.g_procedure_list.count > 0) THEN
2009: j := ecx_utils.g_procedure_list.first;
2010: WHILE j IS NOT NULL LOOP
2011: if (ecx_utils.g_procedure_list(j).cursor_handle > 0) and
2012: (ecx_utils.g_procedure_list(j).cursor_handle is not null) and
2013: (not closed_cursors.EXISTS (ecx_utils.g_procedure_list(j).cursor_handle) )
2007:
2008: IF (ecx_utils.g_procedure_list.count > 0) THEN
2009: j := ecx_utils.g_procedure_list.first;
2010: WHILE j IS NOT NULL LOOP
2011: if (ecx_utils.g_procedure_list(j).cursor_handle > 0) and
2012: (ecx_utils.g_procedure_list(j).cursor_handle is not null) and
2013: (not closed_cursors.EXISTS (ecx_utils.g_procedure_list(j).cursor_handle) )
2014: then
2015: closed_cursors( ecx_utils.g_procedure_list(j).cursor_handle ) := -1;
2008: IF (ecx_utils.g_procedure_list.count > 0) THEN
2009: j := ecx_utils.g_procedure_list.first;
2010: WHILE j IS NOT NULL LOOP
2011: if (ecx_utils.g_procedure_list(j).cursor_handle > 0) and
2012: (ecx_utils.g_procedure_list(j).cursor_handle is not null) and
2013: (not closed_cursors.EXISTS (ecx_utils.g_procedure_list(j).cursor_handle) )
2014: then
2015: closed_cursors( ecx_utils.g_procedure_list(j).cursor_handle ) := -1;
2016: dbms_sql.close_cursor(ecx_utils.g_procedure_list(j).cursor_handle);
2009: j := ecx_utils.g_procedure_list.first;
2010: WHILE j IS NOT NULL LOOP
2011: if (ecx_utils.g_procedure_list(j).cursor_handle > 0) and
2012: (ecx_utils.g_procedure_list(j).cursor_handle is not null) and
2013: (not closed_cursors.EXISTS (ecx_utils.g_procedure_list(j).cursor_handle) )
2014: then
2015: closed_cursors( ecx_utils.g_procedure_list(j).cursor_handle ) := -1;
2016: dbms_sql.close_cursor(ecx_utils.g_procedure_list(j).cursor_handle);
2017: end if;
2011: if (ecx_utils.g_procedure_list(j).cursor_handle > 0) and
2012: (ecx_utils.g_procedure_list(j).cursor_handle is not null) and
2013: (not closed_cursors.EXISTS (ecx_utils.g_procedure_list(j).cursor_handle) )
2014: then
2015: closed_cursors( ecx_utils.g_procedure_list(j).cursor_handle ) := -1;
2016: dbms_sql.close_cursor(ecx_utils.g_procedure_list(j).cursor_handle);
2017: end if;
2018: j := ecx_utils.g_procedure_list.NEXT(j);
2019: end loop;
2012: (ecx_utils.g_procedure_list(j).cursor_handle is not null) and
2013: (not closed_cursors.EXISTS (ecx_utils.g_procedure_list(j).cursor_handle) )
2014: then
2015: closed_cursors( ecx_utils.g_procedure_list(j).cursor_handle ) := -1;
2016: dbms_sql.close_cursor(ecx_utils.g_procedure_list(j).cursor_handle);
2017: end if;
2018: j := ecx_utils.g_procedure_list.NEXT(j);
2019: end loop;
2020: END IF;
2014: then
2015: closed_cursors( ecx_utils.g_procedure_list(j).cursor_handle ) := -1;
2016: dbms_sql.close_cursor(ecx_utils.g_procedure_list(j).cursor_handle);
2017: end if;
2018: j := ecx_utils.g_procedure_list.NEXT(j);
2019: end loop;
2020: END IF;
2021:
2022: if (l_procedureEnabled) then
2026: EXCEPTION
2027: WHEN OTHERS THEN
2028: if(l_unexpectedEnabled) then
2029: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
2030: 'ecx_utils.CLOSE_PROCESS');
2031: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2032: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.CLOSE_PROCESS: ',
2033: i_method_name);
2034: end if;
2028: if(l_unexpectedEnabled) then
2029: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
2030: 'ecx_utils.CLOSE_PROCESS');
2031: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2032: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.CLOSE_PROCESS: ',
2033: i_method_name);
2034: end if;
2035: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.CLOSE_PROCESS: ');
2036: raise PROGRAM_EXIT;
2031: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
2032: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.CLOSE_PROCESS: ',
2033: i_method_name);
2034: end if;
2035: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ecx_utils.CLOSE_PROCESS: ');
2036: raise PROGRAM_EXIT;
2037:
2038: end close_process;
2039:
2044: procedure get_tran_stage_data (
2045: i_map_id IN pls_integer)
2046: IS
2047:
2048: i_method_name varchar2(2000) := 'ecx_utils.get_tran_stage_data';
2049:
2050: /* TYPE stage_data_record is RECORD (
2051: transtage_id ecx_tran_stage_data.transtage_id%TYPE,
2052: object_level ecx_object_levels.object_level%TYPE,
2200: TYPE t_operand6_constant is TABLE of ecx_tran_stage_data.operand6_constant%TYPE;
2201:
2202:
2203: -- temp_stage_rec stage_data_record;
2204: temp_util_rec ecx_utils.stage_rec;
2205:
2206: v_transtage_id t_transtage_id;
2207: v_object_level t_object_level;
2208: v_objectlevel_id t_objectlevel_id;
2364: */
2365:
2366: i_counter pls_integer := 0;
2367: BEGIN
2368: ecx_utils.g_delete_doctype := false;
2369: if (l_procedureEnabled) then
2370: ecx_debug.push(i_method_name);
2371: end if;
2372: ecx_utils.g_stage_data.DELETE;
2368: ecx_utils.g_delete_doctype := false;
2369: if (l_procedureEnabled) then
2370: ecx_debug.push(i_method_name);
2371: end if;
2372: ecx_utils.g_stage_data.DELETE;
2373:
2374: select
2375: transtage_id,
2376: object_level ,
2444: operand6_name,
2445: operand6_pos,
2446: operand6_direction,
2447: operand6_constant
2448: -- bulk collect into ecx_utils.g_stage_data
2449: bulk collect into
2450: -- i_stage_data
2451: v_transtage_id,
2452: v_object_level,
2690: temp_util_rec.operand6_direction||'|'||
2691: temp_util_rec.operand6_constant, i_method_name
2692: );
2693: end if;
2694: ecx_utils.g_stage_data(i_counter) := temp_util_rec;
2695:
2696: i_counter := i_counter + 1;
2697: end loop;
2698: end if;
2700:
2701: /* for get_stage_data in stage_data (
2702: p_map_id => i_map_id) loop
2703:
2704: ecx_utils.g_stage_data(i_counter).transtage_id := get_stage_data.transtage_id;
2705: ecx_utils.g_stage_data(i_counter).level := get_stage_data.object_level;
2706: ecx_utils.g_stage_data(i_counter).stage := get_stage_data.stage;
2707: ecx_utils.g_stage_data(i_counter).object_direction := get_stage_data.object_direction;
2708: ecx_utils.g_stage_data(i_counter).seq_number := get_stage_data.seq_number;
2701: /* for get_stage_data in stage_data (
2702: p_map_id => i_map_id) loop
2703:
2704: ecx_utils.g_stage_data(i_counter).transtage_id := get_stage_data.transtage_id;
2705: ecx_utils.g_stage_data(i_counter).level := get_stage_data.object_level;
2706: ecx_utils.g_stage_data(i_counter).stage := get_stage_data.stage;
2707: ecx_utils.g_stage_data(i_counter).object_direction := get_stage_data.object_direction;
2708: ecx_utils.g_stage_data(i_counter).seq_number := get_stage_data.seq_number;
2709: ecx_utils.g_stage_data(i_counter).action_type := get_stage_data.action_type;
2702: p_map_id => i_map_id) loop
2703:
2704: ecx_utils.g_stage_data(i_counter).transtage_id := get_stage_data.transtage_id;
2705: ecx_utils.g_stage_data(i_counter).level := get_stage_data.object_level;
2706: ecx_utils.g_stage_data(i_counter).stage := get_stage_data.stage;
2707: ecx_utils.g_stage_data(i_counter).object_direction := get_stage_data.object_direction;
2708: ecx_utils.g_stage_data(i_counter).seq_number := get_stage_data.seq_number;
2709: ecx_utils.g_stage_data(i_counter).action_type := get_stage_data.action_type;
2710: ecx_utils.g_stage_data(i_counter).variable_level := get_stage_data.variable_level;
2703:
2704: ecx_utils.g_stage_data(i_counter).transtage_id := get_stage_data.transtage_id;
2705: ecx_utils.g_stage_data(i_counter).level := get_stage_data.object_level;
2706: ecx_utils.g_stage_data(i_counter).stage := get_stage_data.stage;
2707: ecx_utils.g_stage_data(i_counter).object_direction := get_stage_data.object_direction;
2708: ecx_utils.g_stage_data(i_counter).seq_number := get_stage_data.seq_number;
2709: ecx_utils.g_stage_data(i_counter).action_type := get_stage_data.action_type;
2710: ecx_utils.g_stage_data(i_counter).variable_level := get_stage_data.variable_level;
2711: ecx_utils.g_stage_data(i_counter).variable_name := get_stage_data.variable_name;
2704: ecx_utils.g_stage_data(i_counter).transtage_id := get_stage_data.transtage_id;
2705: ecx_utils.g_stage_data(i_counter).level := get_stage_data.object_level;
2706: ecx_utils.g_stage_data(i_counter).stage := get_stage_data.stage;
2707: ecx_utils.g_stage_data(i_counter).object_direction := get_stage_data.object_direction;
2708: ecx_utils.g_stage_data(i_counter).seq_number := get_stage_data.seq_number;
2709: ecx_utils.g_stage_data(i_counter).action_type := get_stage_data.action_type;
2710: ecx_utils.g_stage_data(i_counter).variable_level := get_stage_data.variable_level;
2711: ecx_utils.g_stage_data(i_counter).variable_name := get_stage_data.variable_name;
2712: ecx_utils.g_stage_data(i_counter).variable_pos := get_stage_data.variable_pos;
2705: ecx_utils.g_stage_data(i_counter).level := get_stage_data.object_level;
2706: ecx_utils.g_stage_data(i_counter).stage := get_stage_data.stage;
2707: ecx_utils.g_stage_data(i_counter).object_direction := get_stage_data.object_direction;
2708: ecx_utils.g_stage_data(i_counter).seq_number := get_stage_data.seq_number;
2709: ecx_utils.g_stage_data(i_counter).action_type := get_stage_data.action_type;
2710: ecx_utils.g_stage_data(i_counter).variable_level := get_stage_data.variable_level;
2711: ecx_utils.g_stage_data(i_counter).variable_name := get_stage_data.variable_name;
2712: ecx_utils.g_stage_data(i_counter).variable_pos := get_stage_data.variable_pos;
2713: ecx_utils.g_stage_data(i_counter).variable_direction := get_stage_data.variable_direction;
2706: ecx_utils.g_stage_data(i_counter).stage := get_stage_data.stage;
2707: ecx_utils.g_stage_data(i_counter).object_direction := get_stage_data.object_direction;
2708: ecx_utils.g_stage_data(i_counter).seq_number := get_stage_data.seq_number;
2709: ecx_utils.g_stage_data(i_counter).action_type := get_stage_data.action_type;
2710: ecx_utils.g_stage_data(i_counter).variable_level := get_stage_data.variable_level;
2711: ecx_utils.g_stage_data(i_counter).variable_name := get_stage_data.variable_name;
2712: ecx_utils.g_stage_data(i_counter).variable_pos := get_stage_data.variable_pos;
2713: ecx_utils.g_stage_data(i_counter).variable_direction := get_stage_data.variable_direction;
2714: ecx_utils.g_stage_data(i_counter).variable_value := get_stage_data.variable_value;
2707: ecx_utils.g_stage_data(i_counter).object_direction := get_stage_data.object_direction;
2708: ecx_utils.g_stage_data(i_counter).seq_number := get_stage_data.seq_number;
2709: ecx_utils.g_stage_data(i_counter).action_type := get_stage_data.action_type;
2710: ecx_utils.g_stage_data(i_counter).variable_level := get_stage_data.variable_level;
2711: ecx_utils.g_stage_data(i_counter).variable_name := get_stage_data.variable_name;
2712: ecx_utils.g_stage_data(i_counter).variable_pos := get_stage_data.variable_pos;
2713: ecx_utils.g_stage_data(i_counter).variable_direction := get_stage_data.variable_direction;
2714: ecx_utils.g_stage_data(i_counter).variable_value := get_stage_data.variable_value;
2715: ecx_utils.g_stage_data(i_counter).default_value := get_stage_data.default_value;
2708: ecx_utils.g_stage_data(i_counter).seq_number := get_stage_data.seq_number;
2709: ecx_utils.g_stage_data(i_counter).action_type := get_stage_data.action_type;
2710: ecx_utils.g_stage_data(i_counter).variable_level := get_stage_data.variable_level;
2711: ecx_utils.g_stage_data(i_counter).variable_name := get_stage_data.variable_name;
2712: ecx_utils.g_stage_data(i_counter).variable_pos := get_stage_data.variable_pos;
2713: ecx_utils.g_stage_data(i_counter).variable_direction := get_stage_data.variable_direction;
2714: ecx_utils.g_stage_data(i_counter).variable_value := get_stage_data.variable_value;
2715: ecx_utils.g_stage_data(i_counter).default_value := get_stage_data.default_value;
2716: ecx_utils.g_stage_data(i_counter).sequence_name := get_stage_data.sequence_name;
2709: ecx_utils.g_stage_data(i_counter).action_type := get_stage_data.action_type;
2710: ecx_utils.g_stage_data(i_counter).variable_level := get_stage_data.variable_level;
2711: ecx_utils.g_stage_data(i_counter).variable_name := get_stage_data.variable_name;
2712: ecx_utils.g_stage_data(i_counter).variable_pos := get_stage_data.variable_pos;
2713: ecx_utils.g_stage_data(i_counter).variable_direction := get_stage_data.variable_direction;
2714: ecx_utils.g_stage_data(i_counter).variable_value := get_stage_data.variable_value;
2715: ecx_utils.g_stage_data(i_counter).default_value := get_stage_data.default_value;
2716: ecx_utils.g_stage_data(i_counter).sequence_name := get_stage_data.sequence_name;
2717: ecx_utils.g_stage_data(i_counter).custom_procedure_name := get_stage_data.custom_procedure_name;
2710: ecx_utils.g_stage_data(i_counter).variable_level := get_stage_data.variable_level;
2711: ecx_utils.g_stage_data(i_counter).variable_name := get_stage_data.variable_name;
2712: ecx_utils.g_stage_data(i_counter).variable_pos := get_stage_data.variable_pos;
2713: ecx_utils.g_stage_data(i_counter).variable_direction := get_stage_data.variable_direction;
2714: ecx_utils.g_stage_data(i_counter).variable_value := get_stage_data.variable_value;
2715: ecx_utils.g_stage_data(i_counter).default_value := get_stage_data.default_value;
2716: ecx_utils.g_stage_data(i_counter).sequence_name := get_stage_data.sequence_name;
2717: ecx_utils.g_stage_data(i_counter).custom_procedure_name := get_stage_data.custom_procedure_name;
2718: ecx_utils.g_stage_data(i_counter).data_type := get_stage_data.data_type;
2711: ecx_utils.g_stage_data(i_counter).variable_name := get_stage_data.variable_name;
2712: ecx_utils.g_stage_data(i_counter).variable_pos := get_stage_data.variable_pos;
2713: ecx_utils.g_stage_data(i_counter).variable_direction := get_stage_data.variable_direction;
2714: ecx_utils.g_stage_data(i_counter).variable_value := get_stage_data.variable_value;
2715: ecx_utils.g_stage_data(i_counter).default_value := get_stage_data.default_value;
2716: ecx_utils.g_stage_data(i_counter).sequence_name := get_stage_data.sequence_name;
2717: ecx_utils.g_stage_data(i_counter).custom_procedure_name := get_stage_data.custom_procedure_name;
2718: ecx_utils.g_stage_data(i_counter).data_type := get_stage_data.data_type;
2719: ecx_utils.g_stage_data(i_counter).function_name := get_stage_data.function_name;
2712: ecx_utils.g_stage_data(i_counter).variable_pos := get_stage_data.variable_pos;
2713: ecx_utils.g_stage_data(i_counter).variable_direction := get_stage_data.variable_direction;
2714: ecx_utils.g_stage_data(i_counter).variable_value := get_stage_data.variable_value;
2715: ecx_utils.g_stage_data(i_counter).default_value := get_stage_data.default_value;
2716: ecx_utils.g_stage_data(i_counter).sequence_name := get_stage_data.sequence_name;
2717: ecx_utils.g_stage_data(i_counter).custom_procedure_name := get_stage_data.custom_procedure_name;
2718: ecx_utils.g_stage_data(i_counter).data_type := get_stage_data.data_type;
2719: ecx_utils.g_stage_data(i_counter).function_name := get_stage_data.function_name;
2720: ecx_utils.g_stage_data(i_counter).clause := get_stage_data.where_clause;
2713: ecx_utils.g_stage_data(i_counter).variable_direction := get_stage_data.variable_direction;
2714: ecx_utils.g_stage_data(i_counter).variable_value := get_stage_data.variable_value;
2715: ecx_utils.g_stage_data(i_counter).default_value := get_stage_data.default_value;
2716: ecx_utils.g_stage_data(i_counter).sequence_name := get_stage_data.sequence_name;
2717: ecx_utils.g_stage_data(i_counter).custom_procedure_name := get_stage_data.custom_procedure_name;
2718: ecx_utils.g_stage_data(i_counter).data_type := get_stage_data.data_type;
2719: ecx_utils.g_stage_data(i_counter).function_name := get_stage_data.function_name;
2720: ecx_utils.g_stage_data(i_counter).clause := get_stage_data.where_clause;
2721: ecx_utils.g_stage_data(i_counter).cond_logical_operator := get_stage_data.cond_logical_operator;
2714: ecx_utils.g_stage_data(i_counter).variable_value := get_stage_data.variable_value;
2715: ecx_utils.g_stage_data(i_counter).default_value := get_stage_data.default_value;
2716: ecx_utils.g_stage_data(i_counter).sequence_name := get_stage_data.sequence_name;
2717: ecx_utils.g_stage_data(i_counter).custom_procedure_name := get_stage_data.custom_procedure_name;
2718: ecx_utils.g_stage_data(i_counter).data_type := get_stage_data.data_type;
2719: ecx_utils.g_stage_data(i_counter).function_name := get_stage_data.function_name;
2720: ecx_utils.g_stage_data(i_counter).clause := get_stage_data.where_clause;
2721: ecx_utils.g_stage_data(i_counter).cond_logical_operator := get_stage_data.cond_logical_operator;
2722: ecx_utils.g_stage_data(i_counter).cond_operator1 := get_stage_data.cond_operator1;
2715: ecx_utils.g_stage_data(i_counter).default_value := get_stage_data.default_value;
2716: ecx_utils.g_stage_data(i_counter).sequence_name := get_stage_data.sequence_name;
2717: ecx_utils.g_stage_data(i_counter).custom_procedure_name := get_stage_data.custom_procedure_name;
2718: ecx_utils.g_stage_data(i_counter).data_type := get_stage_data.data_type;
2719: ecx_utils.g_stage_data(i_counter).function_name := get_stage_data.function_name;
2720: ecx_utils.g_stage_data(i_counter).clause := get_stage_data.where_clause;
2721: ecx_utils.g_stage_data(i_counter).cond_logical_operator := get_stage_data.cond_logical_operator;
2722: ecx_utils.g_stage_data(i_counter).cond_operator1 := get_stage_data.cond_operator1;
2723: ecx_utils.g_stage_data(i_counter).cond_var1_level := get_stage_data.cond_var1_level;
2716: ecx_utils.g_stage_data(i_counter).sequence_name := get_stage_data.sequence_name;
2717: ecx_utils.g_stage_data(i_counter).custom_procedure_name := get_stage_data.custom_procedure_name;
2718: ecx_utils.g_stage_data(i_counter).data_type := get_stage_data.data_type;
2719: ecx_utils.g_stage_data(i_counter).function_name := get_stage_data.function_name;
2720: ecx_utils.g_stage_data(i_counter).clause := get_stage_data.where_clause;
2721: ecx_utils.g_stage_data(i_counter).cond_logical_operator := get_stage_data.cond_logical_operator;
2722: ecx_utils.g_stage_data(i_counter).cond_operator1 := get_stage_data.cond_operator1;
2723: ecx_utils.g_stage_data(i_counter).cond_var1_level := get_stage_data.cond_var1_level;
2724: ecx_utils.g_stage_data(i_counter).cond_var1_name := get_stage_data.cond_var1_name;
2717: ecx_utils.g_stage_data(i_counter).custom_procedure_name := get_stage_data.custom_procedure_name;
2718: ecx_utils.g_stage_data(i_counter).data_type := get_stage_data.data_type;
2719: ecx_utils.g_stage_data(i_counter).function_name := get_stage_data.function_name;
2720: ecx_utils.g_stage_data(i_counter).clause := get_stage_data.where_clause;
2721: ecx_utils.g_stage_data(i_counter).cond_logical_operator := get_stage_data.cond_logical_operator;
2722: ecx_utils.g_stage_data(i_counter).cond_operator1 := get_stage_data.cond_operator1;
2723: ecx_utils.g_stage_data(i_counter).cond_var1_level := get_stage_data.cond_var1_level;
2724: ecx_utils.g_stage_data(i_counter).cond_var1_name := get_stage_data.cond_var1_name;
2725: ecx_utils.g_stage_data(i_counter).cond_var1_pos := get_stage_data.cond_var1_pos;
2718: ecx_utils.g_stage_data(i_counter).data_type := get_stage_data.data_type;
2719: ecx_utils.g_stage_data(i_counter).function_name := get_stage_data.function_name;
2720: ecx_utils.g_stage_data(i_counter).clause := get_stage_data.where_clause;
2721: ecx_utils.g_stage_data(i_counter).cond_logical_operator := get_stage_data.cond_logical_operator;
2722: ecx_utils.g_stage_data(i_counter).cond_operator1 := get_stage_data.cond_operator1;
2723: ecx_utils.g_stage_data(i_counter).cond_var1_level := get_stage_data.cond_var1_level;
2724: ecx_utils.g_stage_data(i_counter).cond_var1_name := get_stage_data.cond_var1_name;
2725: ecx_utils.g_stage_data(i_counter).cond_var1_pos := get_stage_data.cond_var1_pos;
2726: ecx_utils.g_stage_data(i_counter).cond_var1_direction := get_stage_data.cond_var1_direction;
2719: ecx_utils.g_stage_data(i_counter).function_name := get_stage_data.function_name;
2720: ecx_utils.g_stage_data(i_counter).clause := get_stage_data.where_clause;
2721: ecx_utils.g_stage_data(i_counter).cond_logical_operator := get_stage_data.cond_logical_operator;
2722: ecx_utils.g_stage_data(i_counter).cond_operator1 := get_stage_data.cond_operator1;
2723: ecx_utils.g_stage_data(i_counter).cond_var1_level := get_stage_data.cond_var1_level;
2724: ecx_utils.g_stage_data(i_counter).cond_var1_name := get_stage_data.cond_var1_name;
2725: ecx_utils.g_stage_data(i_counter).cond_var1_pos := get_stage_data.cond_var1_pos;
2726: ecx_utils.g_stage_data(i_counter).cond_var1_direction := get_stage_data.cond_var1_direction;
2727: ecx_utils.g_stage_data(i_counter).cond_var1_constant := get_stage_data.cond_var1_constant;
2720: ecx_utils.g_stage_data(i_counter).clause := get_stage_data.where_clause;
2721: ecx_utils.g_stage_data(i_counter).cond_logical_operator := get_stage_data.cond_logical_operator;
2722: ecx_utils.g_stage_data(i_counter).cond_operator1 := get_stage_data.cond_operator1;
2723: ecx_utils.g_stage_data(i_counter).cond_var1_level := get_stage_data.cond_var1_level;
2724: ecx_utils.g_stage_data(i_counter).cond_var1_name := get_stage_data.cond_var1_name;
2725: ecx_utils.g_stage_data(i_counter).cond_var1_pos := get_stage_data.cond_var1_pos;
2726: ecx_utils.g_stage_data(i_counter).cond_var1_direction := get_stage_data.cond_var1_direction;
2727: ecx_utils.g_stage_data(i_counter).cond_var1_constant := get_stage_data.cond_var1_constant;
2728: ecx_utils.g_stage_data(i_counter).cond_val1_level := get_stage_data.cond_val1_level;
2721: ecx_utils.g_stage_data(i_counter).cond_logical_operator := get_stage_data.cond_logical_operator;
2722: ecx_utils.g_stage_data(i_counter).cond_operator1 := get_stage_data.cond_operator1;
2723: ecx_utils.g_stage_data(i_counter).cond_var1_level := get_stage_data.cond_var1_level;
2724: ecx_utils.g_stage_data(i_counter).cond_var1_name := get_stage_data.cond_var1_name;
2725: ecx_utils.g_stage_data(i_counter).cond_var1_pos := get_stage_data.cond_var1_pos;
2726: ecx_utils.g_stage_data(i_counter).cond_var1_direction := get_stage_data.cond_var1_direction;
2727: ecx_utils.g_stage_data(i_counter).cond_var1_constant := get_stage_data.cond_var1_constant;
2728: ecx_utils.g_stage_data(i_counter).cond_val1_level := get_stage_data.cond_val1_level;
2729: ecx_utils.g_stage_data(i_counter).cond_val1_name := get_stage_data.cond_val1_name;
2722: ecx_utils.g_stage_data(i_counter).cond_operator1 := get_stage_data.cond_operator1;
2723: ecx_utils.g_stage_data(i_counter).cond_var1_level := get_stage_data.cond_var1_level;
2724: ecx_utils.g_stage_data(i_counter).cond_var1_name := get_stage_data.cond_var1_name;
2725: ecx_utils.g_stage_data(i_counter).cond_var1_pos := get_stage_data.cond_var1_pos;
2726: ecx_utils.g_stage_data(i_counter).cond_var1_direction := get_stage_data.cond_var1_direction;
2727: ecx_utils.g_stage_data(i_counter).cond_var1_constant := get_stage_data.cond_var1_constant;
2728: ecx_utils.g_stage_data(i_counter).cond_val1_level := get_stage_data.cond_val1_level;
2729: ecx_utils.g_stage_data(i_counter).cond_val1_name := get_stage_data.cond_val1_name;
2730: ecx_utils.g_stage_data(i_counter).cond_val1_pos := get_stage_data.cond_val1_pos;
2723: ecx_utils.g_stage_data(i_counter).cond_var1_level := get_stage_data.cond_var1_level;
2724: ecx_utils.g_stage_data(i_counter).cond_var1_name := get_stage_data.cond_var1_name;
2725: ecx_utils.g_stage_data(i_counter).cond_var1_pos := get_stage_data.cond_var1_pos;
2726: ecx_utils.g_stage_data(i_counter).cond_var1_direction := get_stage_data.cond_var1_direction;
2727: ecx_utils.g_stage_data(i_counter).cond_var1_constant := get_stage_data.cond_var1_constant;
2728: ecx_utils.g_stage_data(i_counter).cond_val1_level := get_stage_data.cond_val1_level;
2729: ecx_utils.g_stage_data(i_counter).cond_val1_name := get_stage_data.cond_val1_name;
2730: ecx_utils.g_stage_data(i_counter).cond_val1_pos := get_stage_data.cond_val1_pos;
2731: ecx_utils.g_stage_data(i_counter).cond_val1_direction := get_stage_data.cond_val1_direction;
2724: ecx_utils.g_stage_data(i_counter).cond_var1_name := get_stage_data.cond_var1_name;
2725: ecx_utils.g_stage_data(i_counter).cond_var1_pos := get_stage_data.cond_var1_pos;
2726: ecx_utils.g_stage_data(i_counter).cond_var1_direction := get_stage_data.cond_var1_direction;
2727: ecx_utils.g_stage_data(i_counter).cond_var1_constant := get_stage_data.cond_var1_constant;
2728: ecx_utils.g_stage_data(i_counter).cond_val1_level := get_stage_data.cond_val1_level;
2729: ecx_utils.g_stage_data(i_counter).cond_val1_name := get_stage_data.cond_val1_name;
2730: ecx_utils.g_stage_data(i_counter).cond_val1_pos := get_stage_data.cond_val1_pos;
2731: ecx_utils.g_stage_data(i_counter).cond_val1_direction := get_stage_data.cond_val1_direction;
2732: ecx_utils.g_stage_data(i_counter).cond_val1_constant := get_stage_data.cond_val1_constant;
2725: ecx_utils.g_stage_data(i_counter).cond_var1_pos := get_stage_data.cond_var1_pos;
2726: ecx_utils.g_stage_data(i_counter).cond_var1_direction := get_stage_data.cond_var1_direction;
2727: ecx_utils.g_stage_data(i_counter).cond_var1_constant := get_stage_data.cond_var1_constant;
2728: ecx_utils.g_stage_data(i_counter).cond_val1_level := get_stage_data.cond_val1_level;
2729: ecx_utils.g_stage_data(i_counter).cond_val1_name := get_stage_data.cond_val1_name;
2730: ecx_utils.g_stage_data(i_counter).cond_val1_pos := get_stage_data.cond_val1_pos;
2731: ecx_utils.g_stage_data(i_counter).cond_val1_direction := get_stage_data.cond_val1_direction;
2732: ecx_utils.g_stage_data(i_counter).cond_val1_constant := get_stage_data.cond_val1_constant;
2733: ecx_utils.g_stage_data(i_counter).cond_operator2 := get_stage_data.cond_operator2;
2726: ecx_utils.g_stage_data(i_counter).cond_var1_direction := get_stage_data.cond_var1_direction;
2727: ecx_utils.g_stage_data(i_counter).cond_var1_constant := get_stage_data.cond_var1_constant;
2728: ecx_utils.g_stage_data(i_counter).cond_val1_level := get_stage_data.cond_val1_level;
2729: ecx_utils.g_stage_data(i_counter).cond_val1_name := get_stage_data.cond_val1_name;
2730: ecx_utils.g_stage_data(i_counter).cond_val1_pos := get_stage_data.cond_val1_pos;
2731: ecx_utils.g_stage_data(i_counter).cond_val1_direction := get_stage_data.cond_val1_direction;
2732: ecx_utils.g_stage_data(i_counter).cond_val1_constant := get_stage_data.cond_val1_constant;
2733: ecx_utils.g_stage_data(i_counter).cond_operator2 := get_stage_data.cond_operator2;
2734: ecx_utils.g_stage_data(i_counter).cond_var2_level := get_stage_data.cond_var2_level;
2727: ecx_utils.g_stage_data(i_counter).cond_var1_constant := get_stage_data.cond_var1_constant;
2728: ecx_utils.g_stage_data(i_counter).cond_val1_level := get_stage_data.cond_val1_level;
2729: ecx_utils.g_stage_data(i_counter).cond_val1_name := get_stage_data.cond_val1_name;
2730: ecx_utils.g_stage_data(i_counter).cond_val1_pos := get_stage_data.cond_val1_pos;
2731: ecx_utils.g_stage_data(i_counter).cond_val1_direction := get_stage_data.cond_val1_direction;
2732: ecx_utils.g_stage_data(i_counter).cond_val1_constant := get_stage_data.cond_val1_constant;
2733: ecx_utils.g_stage_data(i_counter).cond_operator2 := get_stage_data.cond_operator2;
2734: ecx_utils.g_stage_data(i_counter).cond_var2_level := get_stage_data.cond_var2_level;
2735: ecx_utils.g_stage_data(i_counter).cond_var2_name := get_stage_data.cond_var2_name;
2728: ecx_utils.g_stage_data(i_counter).cond_val1_level := get_stage_data.cond_val1_level;
2729: ecx_utils.g_stage_data(i_counter).cond_val1_name := get_stage_data.cond_val1_name;
2730: ecx_utils.g_stage_data(i_counter).cond_val1_pos := get_stage_data.cond_val1_pos;
2731: ecx_utils.g_stage_data(i_counter).cond_val1_direction := get_stage_data.cond_val1_direction;
2732: ecx_utils.g_stage_data(i_counter).cond_val1_constant := get_stage_data.cond_val1_constant;
2733: ecx_utils.g_stage_data(i_counter).cond_operator2 := get_stage_data.cond_operator2;
2734: ecx_utils.g_stage_data(i_counter).cond_var2_level := get_stage_data.cond_var2_level;
2735: ecx_utils.g_stage_data(i_counter).cond_var2_name := get_stage_data.cond_var2_name;
2736: ecx_utils.g_stage_data(i_counter).cond_var2_pos := get_stage_data.cond_var2_pos;
2729: ecx_utils.g_stage_data(i_counter).cond_val1_name := get_stage_data.cond_val1_name;
2730: ecx_utils.g_stage_data(i_counter).cond_val1_pos := get_stage_data.cond_val1_pos;
2731: ecx_utils.g_stage_data(i_counter).cond_val1_direction := get_stage_data.cond_val1_direction;
2732: ecx_utils.g_stage_data(i_counter).cond_val1_constant := get_stage_data.cond_val1_constant;
2733: ecx_utils.g_stage_data(i_counter).cond_operator2 := get_stage_data.cond_operator2;
2734: ecx_utils.g_stage_data(i_counter).cond_var2_level := get_stage_data.cond_var2_level;
2735: ecx_utils.g_stage_data(i_counter).cond_var2_name := get_stage_data.cond_var2_name;
2736: ecx_utils.g_stage_data(i_counter).cond_var2_pos := get_stage_data.cond_var2_pos;
2737: ecx_utils.g_stage_data(i_counter).cond_var2_direction := get_stage_data.cond_var2_direction;
2730: ecx_utils.g_stage_data(i_counter).cond_val1_pos := get_stage_data.cond_val1_pos;
2731: ecx_utils.g_stage_data(i_counter).cond_val1_direction := get_stage_data.cond_val1_direction;
2732: ecx_utils.g_stage_data(i_counter).cond_val1_constant := get_stage_data.cond_val1_constant;
2733: ecx_utils.g_stage_data(i_counter).cond_operator2 := get_stage_data.cond_operator2;
2734: ecx_utils.g_stage_data(i_counter).cond_var2_level := get_stage_data.cond_var2_level;
2735: ecx_utils.g_stage_data(i_counter).cond_var2_name := get_stage_data.cond_var2_name;
2736: ecx_utils.g_stage_data(i_counter).cond_var2_pos := get_stage_data.cond_var2_pos;
2737: ecx_utils.g_stage_data(i_counter).cond_var2_direction := get_stage_data.cond_var2_direction;
2738: ecx_utils.g_stage_data(i_counter).cond_var2_constant := get_stage_data.cond_var2_constant;
2731: ecx_utils.g_stage_data(i_counter).cond_val1_direction := get_stage_data.cond_val1_direction;
2732: ecx_utils.g_stage_data(i_counter).cond_val1_constant := get_stage_data.cond_val1_constant;
2733: ecx_utils.g_stage_data(i_counter).cond_operator2 := get_stage_data.cond_operator2;
2734: ecx_utils.g_stage_data(i_counter).cond_var2_level := get_stage_data.cond_var2_level;
2735: ecx_utils.g_stage_data(i_counter).cond_var2_name := get_stage_data.cond_var2_name;
2736: ecx_utils.g_stage_data(i_counter).cond_var2_pos := get_stage_data.cond_var2_pos;
2737: ecx_utils.g_stage_data(i_counter).cond_var2_direction := get_stage_data.cond_var2_direction;
2738: ecx_utils.g_stage_data(i_counter).cond_var2_constant := get_stage_data.cond_var2_constant;
2739: ecx_utils.g_stage_data(i_counter).cond_val2_level := get_stage_data.cond_val2_level;
2732: ecx_utils.g_stage_data(i_counter).cond_val1_constant := get_stage_data.cond_val1_constant;
2733: ecx_utils.g_stage_data(i_counter).cond_operator2 := get_stage_data.cond_operator2;
2734: ecx_utils.g_stage_data(i_counter).cond_var2_level := get_stage_data.cond_var2_level;
2735: ecx_utils.g_stage_data(i_counter).cond_var2_name := get_stage_data.cond_var2_name;
2736: ecx_utils.g_stage_data(i_counter).cond_var2_pos := get_stage_data.cond_var2_pos;
2737: ecx_utils.g_stage_data(i_counter).cond_var2_direction := get_stage_data.cond_var2_direction;
2738: ecx_utils.g_stage_data(i_counter).cond_var2_constant := get_stage_data.cond_var2_constant;
2739: ecx_utils.g_stage_data(i_counter).cond_val2_level := get_stage_data.cond_val2_level;
2740: ecx_utils.g_stage_data(i_counter).cond_val2_name := get_stage_data.cond_val2_name;
2733: ecx_utils.g_stage_data(i_counter).cond_operator2 := get_stage_data.cond_operator2;
2734: ecx_utils.g_stage_data(i_counter).cond_var2_level := get_stage_data.cond_var2_level;
2735: ecx_utils.g_stage_data(i_counter).cond_var2_name := get_stage_data.cond_var2_name;
2736: ecx_utils.g_stage_data(i_counter).cond_var2_pos := get_stage_data.cond_var2_pos;
2737: ecx_utils.g_stage_data(i_counter).cond_var2_direction := get_stage_data.cond_var2_direction;
2738: ecx_utils.g_stage_data(i_counter).cond_var2_constant := get_stage_data.cond_var2_constant;
2739: ecx_utils.g_stage_data(i_counter).cond_val2_level := get_stage_data.cond_val2_level;
2740: ecx_utils.g_stage_data(i_counter).cond_val2_name := get_stage_data.cond_val2_name;
2741: ecx_utils.g_stage_data(i_counter).cond_val2_pos := get_stage_data.cond_val2_pos;
2734: ecx_utils.g_stage_data(i_counter).cond_var2_level := get_stage_data.cond_var2_level;
2735: ecx_utils.g_stage_data(i_counter).cond_var2_name := get_stage_data.cond_var2_name;
2736: ecx_utils.g_stage_data(i_counter).cond_var2_pos := get_stage_data.cond_var2_pos;
2737: ecx_utils.g_stage_data(i_counter).cond_var2_direction := get_stage_data.cond_var2_direction;
2738: ecx_utils.g_stage_data(i_counter).cond_var2_constant := get_stage_data.cond_var2_constant;
2739: ecx_utils.g_stage_data(i_counter).cond_val2_level := get_stage_data.cond_val2_level;
2740: ecx_utils.g_stage_data(i_counter).cond_val2_name := get_stage_data.cond_val2_name;
2741: ecx_utils.g_stage_data(i_counter).cond_val2_pos := get_stage_data.cond_val2_pos;
2742: ecx_utils.g_stage_data(i_counter).cond_val2_direction := get_stage_data.cond_val2_direction;
2735: ecx_utils.g_stage_data(i_counter).cond_var2_name := get_stage_data.cond_var2_name;
2736: ecx_utils.g_stage_data(i_counter).cond_var2_pos := get_stage_data.cond_var2_pos;
2737: ecx_utils.g_stage_data(i_counter).cond_var2_direction := get_stage_data.cond_var2_direction;
2738: ecx_utils.g_stage_data(i_counter).cond_var2_constant := get_stage_data.cond_var2_constant;
2739: ecx_utils.g_stage_data(i_counter).cond_val2_level := get_stage_data.cond_val2_level;
2740: ecx_utils.g_stage_data(i_counter).cond_val2_name := get_stage_data.cond_val2_name;
2741: ecx_utils.g_stage_data(i_counter).cond_val2_pos := get_stage_data.cond_val2_pos;
2742: ecx_utils.g_stage_data(i_counter).cond_val2_direction := get_stage_data.cond_val2_direction;
2743: ecx_utils.g_stage_data(i_counter).cond_val2_constant := get_stage_data.cond_val2_constant;
2736: ecx_utils.g_stage_data(i_counter).cond_var2_pos := get_stage_data.cond_var2_pos;
2737: ecx_utils.g_stage_data(i_counter).cond_var2_direction := get_stage_data.cond_var2_direction;
2738: ecx_utils.g_stage_data(i_counter).cond_var2_constant := get_stage_data.cond_var2_constant;
2739: ecx_utils.g_stage_data(i_counter).cond_val2_level := get_stage_data.cond_val2_level;
2740: ecx_utils.g_stage_data(i_counter).cond_val2_name := get_stage_data.cond_val2_name;
2741: ecx_utils.g_stage_data(i_counter).cond_val2_pos := get_stage_data.cond_val2_pos;
2742: ecx_utils.g_stage_data(i_counter).cond_val2_direction := get_stage_data.cond_val2_direction;
2743: ecx_utils.g_stage_data(i_counter).cond_val2_constant := get_stage_data.cond_val2_constant;
2744: ecx_utils.g_stage_data(i_counter).operand1_level := get_stage_data.operand1_level;
2737: ecx_utils.g_stage_data(i_counter).cond_var2_direction := get_stage_data.cond_var2_direction;
2738: ecx_utils.g_stage_data(i_counter).cond_var2_constant := get_stage_data.cond_var2_constant;
2739: ecx_utils.g_stage_data(i_counter).cond_val2_level := get_stage_data.cond_val2_level;
2740: ecx_utils.g_stage_data(i_counter).cond_val2_name := get_stage_data.cond_val2_name;
2741: ecx_utils.g_stage_data(i_counter).cond_val2_pos := get_stage_data.cond_val2_pos;
2742: ecx_utils.g_stage_data(i_counter).cond_val2_direction := get_stage_data.cond_val2_direction;
2743: ecx_utils.g_stage_data(i_counter).cond_val2_constant := get_stage_data.cond_val2_constant;
2744: ecx_utils.g_stage_data(i_counter).operand1_level := get_stage_data.operand1_level;
2745: ecx_utils.g_stage_data(i_counter).operand1_name := get_stage_data.operand1_name;
2738: ecx_utils.g_stage_data(i_counter).cond_var2_constant := get_stage_data.cond_var2_constant;
2739: ecx_utils.g_stage_data(i_counter).cond_val2_level := get_stage_data.cond_val2_level;
2740: ecx_utils.g_stage_data(i_counter).cond_val2_name := get_stage_data.cond_val2_name;
2741: ecx_utils.g_stage_data(i_counter).cond_val2_pos := get_stage_data.cond_val2_pos;
2742: ecx_utils.g_stage_data(i_counter).cond_val2_direction := get_stage_data.cond_val2_direction;
2743: ecx_utils.g_stage_data(i_counter).cond_val2_constant := get_stage_data.cond_val2_constant;
2744: ecx_utils.g_stage_data(i_counter).operand1_level := get_stage_data.operand1_level;
2745: ecx_utils.g_stage_data(i_counter).operand1_name := get_stage_data.operand1_name;
2746: ecx_utils.g_stage_data(i_counter).operand1_pos := get_stage_data.operand1_pos;
2739: ecx_utils.g_stage_data(i_counter).cond_val2_level := get_stage_data.cond_val2_level;
2740: ecx_utils.g_stage_data(i_counter).cond_val2_name := get_stage_data.cond_val2_name;
2741: ecx_utils.g_stage_data(i_counter).cond_val2_pos := get_stage_data.cond_val2_pos;
2742: ecx_utils.g_stage_data(i_counter).cond_val2_direction := get_stage_data.cond_val2_direction;
2743: ecx_utils.g_stage_data(i_counter).cond_val2_constant := get_stage_data.cond_val2_constant;
2744: ecx_utils.g_stage_data(i_counter).operand1_level := get_stage_data.operand1_level;
2745: ecx_utils.g_stage_data(i_counter).operand1_name := get_stage_data.operand1_name;
2746: ecx_utils.g_stage_data(i_counter).operand1_pos := get_stage_data.operand1_pos;
2747: ecx_utils.g_stage_data(i_counter).operand1_direction := get_stage_data.operand1_direction;
2740: ecx_utils.g_stage_data(i_counter).cond_val2_name := get_stage_data.cond_val2_name;
2741: ecx_utils.g_stage_data(i_counter).cond_val2_pos := get_stage_data.cond_val2_pos;
2742: ecx_utils.g_stage_data(i_counter).cond_val2_direction := get_stage_data.cond_val2_direction;
2743: ecx_utils.g_stage_data(i_counter).cond_val2_constant := get_stage_data.cond_val2_constant;
2744: ecx_utils.g_stage_data(i_counter).operand1_level := get_stage_data.operand1_level;
2745: ecx_utils.g_stage_data(i_counter).operand1_name := get_stage_data.operand1_name;
2746: ecx_utils.g_stage_data(i_counter).operand1_pos := get_stage_data.operand1_pos;
2747: ecx_utils.g_stage_data(i_counter).operand1_direction := get_stage_data.operand1_direction;
2748: ecx_utils.g_stage_data(i_counter).operand1_constant := get_stage_data.operand1_constant;
2741: ecx_utils.g_stage_data(i_counter).cond_val2_pos := get_stage_data.cond_val2_pos;
2742: ecx_utils.g_stage_data(i_counter).cond_val2_direction := get_stage_data.cond_val2_direction;
2743: ecx_utils.g_stage_data(i_counter).cond_val2_constant := get_stage_data.cond_val2_constant;
2744: ecx_utils.g_stage_data(i_counter).operand1_level := get_stage_data.operand1_level;
2745: ecx_utils.g_stage_data(i_counter).operand1_name := get_stage_data.operand1_name;
2746: ecx_utils.g_stage_data(i_counter).operand1_pos := get_stage_data.operand1_pos;
2747: ecx_utils.g_stage_data(i_counter).operand1_direction := get_stage_data.operand1_direction;
2748: ecx_utils.g_stage_data(i_counter).operand1_constant := get_stage_data.operand1_constant;
2749: ecx_utils.g_stage_data(i_counter).operand1_len := get_stage_data.operand1_len;
2742: ecx_utils.g_stage_data(i_counter).cond_val2_direction := get_stage_data.cond_val2_direction;
2743: ecx_utils.g_stage_data(i_counter).cond_val2_constant := get_stage_data.cond_val2_constant;
2744: ecx_utils.g_stage_data(i_counter).operand1_level := get_stage_data.operand1_level;
2745: ecx_utils.g_stage_data(i_counter).operand1_name := get_stage_data.operand1_name;
2746: ecx_utils.g_stage_data(i_counter).operand1_pos := get_stage_data.operand1_pos;
2747: ecx_utils.g_stage_data(i_counter).operand1_direction := get_stage_data.operand1_direction;
2748: ecx_utils.g_stage_data(i_counter).operand1_constant := get_stage_data.operand1_constant;
2749: ecx_utils.g_stage_data(i_counter).operand1_len := get_stage_data.operand1_len;
2750: ecx_utils.g_stage_data(i_counter).operand1_start_pos := get_stage_data.operand1_start_pos;
2743: ecx_utils.g_stage_data(i_counter).cond_val2_constant := get_stage_data.cond_val2_constant;
2744: ecx_utils.g_stage_data(i_counter).operand1_level := get_stage_data.operand1_level;
2745: ecx_utils.g_stage_data(i_counter).operand1_name := get_stage_data.operand1_name;
2746: ecx_utils.g_stage_data(i_counter).operand1_pos := get_stage_data.operand1_pos;
2747: ecx_utils.g_stage_data(i_counter).operand1_direction := get_stage_data.operand1_direction;
2748: ecx_utils.g_stage_data(i_counter).operand1_constant := get_stage_data.operand1_constant;
2749: ecx_utils.g_stage_data(i_counter).operand1_len := get_stage_data.operand1_len;
2750: ecx_utils.g_stage_data(i_counter).operand1_start_pos := get_stage_data.operand1_start_pos;
2751: ecx_utils.g_stage_data(i_counter).operand2_level := get_stage_data.operand2_level;
2744: ecx_utils.g_stage_data(i_counter).operand1_level := get_stage_data.operand1_level;
2745: ecx_utils.g_stage_data(i_counter).operand1_name := get_stage_data.operand1_name;
2746: ecx_utils.g_stage_data(i_counter).operand1_pos := get_stage_data.operand1_pos;
2747: ecx_utils.g_stage_data(i_counter).operand1_direction := get_stage_data.operand1_direction;
2748: ecx_utils.g_stage_data(i_counter).operand1_constant := get_stage_data.operand1_constant;
2749: ecx_utils.g_stage_data(i_counter).operand1_len := get_stage_data.operand1_len;
2750: ecx_utils.g_stage_data(i_counter).operand1_start_pos := get_stage_data.operand1_start_pos;
2751: ecx_utils.g_stage_data(i_counter).operand2_level := get_stage_data.operand2_level;
2752: ecx_utils.g_stage_data(i_counter).operand2_name := get_stage_data.operand2_name;
2745: ecx_utils.g_stage_data(i_counter).operand1_name := get_stage_data.operand1_name;
2746: ecx_utils.g_stage_data(i_counter).operand1_pos := get_stage_data.operand1_pos;
2747: ecx_utils.g_stage_data(i_counter).operand1_direction := get_stage_data.operand1_direction;
2748: ecx_utils.g_stage_data(i_counter).operand1_constant := get_stage_data.operand1_constant;
2749: ecx_utils.g_stage_data(i_counter).operand1_len := get_stage_data.operand1_len;
2750: ecx_utils.g_stage_data(i_counter).operand1_start_pos := get_stage_data.operand1_start_pos;
2751: ecx_utils.g_stage_data(i_counter).operand2_level := get_stage_data.operand2_level;
2752: ecx_utils.g_stage_data(i_counter).operand2_name := get_stage_data.operand2_name;
2753: ecx_utils.g_stage_data(i_counter).operand2_pos := get_stage_data.operand2_pos;
2746: ecx_utils.g_stage_data(i_counter).operand1_pos := get_stage_data.operand1_pos;
2747: ecx_utils.g_stage_data(i_counter).operand1_direction := get_stage_data.operand1_direction;
2748: ecx_utils.g_stage_data(i_counter).operand1_constant := get_stage_data.operand1_constant;
2749: ecx_utils.g_stage_data(i_counter).operand1_len := get_stage_data.operand1_len;
2750: ecx_utils.g_stage_data(i_counter).operand1_start_pos := get_stage_data.operand1_start_pos;
2751: ecx_utils.g_stage_data(i_counter).operand2_level := get_stage_data.operand2_level;
2752: ecx_utils.g_stage_data(i_counter).operand2_name := get_stage_data.operand2_name;
2753: ecx_utils.g_stage_data(i_counter).operand2_pos := get_stage_data.operand2_pos;
2754: ecx_utils.g_stage_data(i_counter).operand2_direction := get_stage_data.operand2_direction;
2747: ecx_utils.g_stage_data(i_counter).operand1_direction := get_stage_data.operand1_direction;
2748: ecx_utils.g_stage_data(i_counter).operand1_constant := get_stage_data.operand1_constant;
2749: ecx_utils.g_stage_data(i_counter).operand1_len := get_stage_data.operand1_len;
2750: ecx_utils.g_stage_data(i_counter).operand1_start_pos := get_stage_data.operand1_start_pos;
2751: ecx_utils.g_stage_data(i_counter).operand2_level := get_stage_data.operand2_level;
2752: ecx_utils.g_stage_data(i_counter).operand2_name := get_stage_data.operand2_name;
2753: ecx_utils.g_stage_data(i_counter).operand2_pos := get_stage_data.operand2_pos;
2754: ecx_utils.g_stage_data(i_counter).operand2_direction := get_stage_data.operand2_direction;
2755: ecx_utils.g_stage_data(i_counter).operand2_constant := get_stage_data.operand2_constant;
2748: ecx_utils.g_stage_data(i_counter).operand1_constant := get_stage_data.operand1_constant;
2749: ecx_utils.g_stage_data(i_counter).operand1_len := get_stage_data.operand1_len;
2750: ecx_utils.g_stage_data(i_counter).operand1_start_pos := get_stage_data.operand1_start_pos;
2751: ecx_utils.g_stage_data(i_counter).operand2_level := get_stage_data.operand2_level;
2752: ecx_utils.g_stage_data(i_counter).operand2_name := get_stage_data.operand2_name;
2753: ecx_utils.g_stage_data(i_counter).operand2_pos := get_stage_data.operand2_pos;
2754: ecx_utils.g_stage_data(i_counter).operand2_direction := get_stage_data.operand2_direction;
2755: ecx_utils.g_stage_data(i_counter).operand2_constant := get_stage_data.operand2_constant;
2756: ecx_utils.g_stage_data(i_counter).operand3_level := get_stage_data.operand3_level;
2749: ecx_utils.g_stage_data(i_counter).operand1_len := get_stage_data.operand1_len;
2750: ecx_utils.g_stage_data(i_counter).operand1_start_pos := get_stage_data.operand1_start_pos;
2751: ecx_utils.g_stage_data(i_counter).operand2_level := get_stage_data.operand2_level;
2752: ecx_utils.g_stage_data(i_counter).operand2_name := get_stage_data.operand2_name;
2753: ecx_utils.g_stage_data(i_counter).operand2_pos := get_stage_data.operand2_pos;
2754: ecx_utils.g_stage_data(i_counter).operand2_direction := get_stage_data.operand2_direction;
2755: ecx_utils.g_stage_data(i_counter).operand2_constant := get_stage_data.operand2_constant;
2756: ecx_utils.g_stage_data(i_counter).operand3_level := get_stage_data.operand3_level;
2757: ecx_utils.g_stage_data(i_counter).operand3_name := get_stage_data.operand3_name;
2750: ecx_utils.g_stage_data(i_counter).operand1_start_pos := get_stage_data.operand1_start_pos;
2751: ecx_utils.g_stage_data(i_counter).operand2_level := get_stage_data.operand2_level;
2752: ecx_utils.g_stage_data(i_counter).operand2_name := get_stage_data.operand2_name;
2753: ecx_utils.g_stage_data(i_counter).operand2_pos := get_stage_data.operand2_pos;
2754: ecx_utils.g_stage_data(i_counter).operand2_direction := get_stage_data.operand2_direction;
2755: ecx_utils.g_stage_data(i_counter).operand2_constant := get_stage_data.operand2_constant;
2756: ecx_utils.g_stage_data(i_counter).operand3_level := get_stage_data.operand3_level;
2757: ecx_utils.g_stage_data(i_counter).operand3_name := get_stage_data.operand3_name;
2758: ecx_utils.g_stage_data(i_counter).operand3_pos := get_stage_data.operand3_pos;
2751: ecx_utils.g_stage_data(i_counter).operand2_level := get_stage_data.operand2_level;
2752: ecx_utils.g_stage_data(i_counter).operand2_name := get_stage_data.operand2_name;
2753: ecx_utils.g_stage_data(i_counter).operand2_pos := get_stage_data.operand2_pos;
2754: ecx_utils.g_stage_data(i_counter).operand2_direction := get_stage_data.operand2_direction;
2755: ecx_utils.g_stage_data(i_counter).operand2_constant := get_stage_data.operand2_constant;
2756: ecx_utils.g_stage_data(i_counter).operand3_level := get_stage_data.operand3_level;
2757: ecx_utils.g_stage_data(i_counter).operand3_name := get_stage_data.operand3_name;
2758: ecx_utils.g_stage_data(i_counter).operand3_pos := get_stage_data.operand3_pos;
2759: ecx_utils.g_stage_data(i_counter).operand3_direction := get_stage_data.operand3_direction;
2752: ecx_utils.g_stage_data(i_counter).operand2_name := get_stage_data.operand2_name;
2753: ecx_utils.g_stage_data(i_counter).operand2_pos := get_stage_data.operand2_pos;
2754: ecx_utils.g_stage_data(i_counter).operand2_direction := get_stage_data.operand2_direction;
2755: ecx_utils.g_stage_data(i_counter).operand2_constant := get_stage_data.operand2_constant;
2756: ecx_utils.g_stage_data(i_counter).operand3_level := get_stage_data.operand3_level;
2757: ecx_utils.g_stage_data(i_counter).operand3_name := get_stage_data.operand3_name;
2758: ecx_utils.g_stage_data(i_counter).operand3_pos := get_stage_data.operand3_pos;
2759: ecx_utils.g_stage_data(i_counter).operand3_direction := get_stage_data.operand3_direction;
2760: ecx_utils.g_stage_data(i_counter).operand3_constant := get_stage_data.operand3_constant;
2753: ecx_utils.g_stage_data(i_counter).operand2_pos := get_stage_data.operand2_pos;
2754: ecx_utils.g_stage_data(i_counter).operand2_direction := get_stage_data.operand2_direction;
2755: ecx_utils.g_stage_data(i_counter).operand2_constant := get_stage_data.operand2_constant;
2756: ecx_utils.g_stage_data(i_counter).operand3_level := get_stage_data.operand3_level;
2757: ecx_utils.g_stage_data(i_counter).operand3_name := get_stage_data.operand3_name;
2758: ecx_utils.g_stage_data(i_counter).operand3_pos := get_stage_data.operand3_pos;
2759: ecx_utils.g_stage_data(i_counter).operand3_direction := get_stage_data.operand3_direction;
2760: ecx_utils.g_stage_data(i_counter).operand3_constant := get_stage_data.operand3_constant;
2761: ecx_utils.g_stage_data(i_counter).operand4_level := get_stage_data.operand4_level;
2754: ecx_utils.g_stage_data(i_counter).operand2_direction := get_stage_data.operand2_direction;
2755: ecx_utils.g_stage_data(i_counter).operand2_constant := get_stage_data.operand2_constant;
2756: ecx_utils.g_stage_data(i_counter).operand3_level := get_stage_data.operand3_level;
2757: ecx_utils.g_stage_data(i_counter).operand3_name := get_stage_data.operand3_name;
2758: ecx_utils.g_stage_data(i_counter).operand3_pos := get_stage_data.operand3_pos;
2759: ecx_utils.g_stage_data(i_counter).operand3_direction := get_stage_data.operand3_direction;
2760: ecx_utils.g_stage_data(i_counter).operand3_constant := get_stage_data.operand3_constant;
2761: ecx_utils.g_stage_data(i_counter).operand4_level := get_stage_data.operand4_level;
2762: ecx_utils.g_stage_data(i_counter).operand4_name := get_stage_data.operand4_name;
2755: ecx_utils.g_stage_data(i_counter).operand2_constant := get_stage_data.operand2_constant;
2756: ecx_utils.g_stage_data(i_counter).operand3_level := get_stage_data.operand3_level;
2757: ecx_utils.g_stage_data(i_counter).operand3_name := get_stage_data.operand3_name;
2758: ecx_utils.g_stage_data(i_counter).operand3_pos := get_stage_data.operand3_pos;
2759: ecx_utils.g_stage_data(i_counter).operand3_direction := get_stage_data.operand3_direction;
2760: ecx_utils.g_stage_data(i_counter).operand3_constant := get_stage_data.operand3_constant;
2761: ecx_utils.g_stage_data(i_counter).operand4_level := get_stage_data.operand4_level;
2762: ecx_utils.g_stage_data(i_counter).operand4_name := get_stage_data.operand4_name;
2763: ecx_utils.g_stage_data(i_counter).operand4_pos := get_stage_data.operand4_pos;
2756: ecx_utils.g_stage_data(i_counter).operand3_level := get_stage_data.operand3_level;
2757: ecx_utils.g_stage_data(i_counter).operand3_name := get_stage_data.operand3_name;
2758: ecx_utils.g_stage_data(i_counter).operand3_pos := get_stage_data.operand3_pos;
2759: ecx_utils.g_stage_data(i_counter).operand3_direction := get_stage_data.operand3_direction;
2760: ecx_utils.g_stage_data(i_counter).operand3_constant := get_stage_data.operand3_constant;
2761: ecx_utils.g_stage_data(i_counter).operand4_level := get_stage_data.operand4_level;
2762: ecx_utils.g_stage_data(i_counter).operand4_name := get_stage_data.operand4_name;
2763: ecx_utils.g_stage_data(i_counter).operand4_pos := get_stage_data.operand4_pos;
2764: ecx_utils.g_stage_data(i_counter).operand4_direction := get_stage_data.operand4_direction;
2757: ecx_utils.g_stage_data(i_counter).operand3_name := get_stage_data.operand3_name;
2758: ecx_utils.g_stage_data(i_counter).operand3_pos := get_stage_data.operand3_pos;
2759: ecx_utils.g_stage_data(i_counter).operand3_direction := get_stage_data.operand3_direction;
2760: ecx_utils.g_stage_data(i_counter).operand3_constant := get_stage_data.operand3_constant;
2761: ecx_utils.g_stage_data(i_counter).operand4_level := get_stage_data.operand4_level;
2762: ecx_utils.g_stage_data(i_counter).operand4_name := get_stage_data.operand4_name;
2763: ecx_utils.g_stage_data(i_counter).operand4_pos := get_stage_data.operand4_pos;
2764: ecx_utils.g_stage_data(i_counter).operand4_direction := get_stage_data.operand4_direction;
2765: ecx_utils.g_stage_data(i_counter).operand4_constant := get_stage_data.operand4_constant;
2758: ecx_utils.g_stage_data(i_counter).operand3_pos := get_stage_data.operand3_pos;
2759: ecx_utils.g_stage_data(i_counter).operand3_direction := get_stage_data.operand3_direction;
2760: ecx_utils.g_stage_data(i_counter).operand3_constant := get_stage_data.operand3_constant;
2761: ecx_utils.g_stage_data(i_counter).operand4_level := get_stage_data.operand4_level;
2762: ecx_utils.g_stage_data(i_counter).operand4_name := get_stage_data.operand4_name;
2763: ecx_utils.g_stage_data(i_counter).operand4_pos := get_stage_data.operand4_pos;
2764: ecx_utils.g_stage_data(i_counter).operand4_direction := get_stage_data.operand4_direction;
2765: ecx_utils.g_stage_data(i_counter).operand4_constant := get_stage_data.operand4_constant;
2766: ecx_utils.g_stage_data(i_counter).operand5_level := get_stage_data.operand5_level;
2759: ecx_utils.g_stage_data(i_counter).operand3_direction := get_stage_data.operand3_direction;
2760: ecx_utils.g_stage_data(i_counter).operand3_constant := get_stage_data.operand3_constant;
2761: ecx_utils.g_stage_data(i_counter).operand4_level := get_stage_data.operand4_level;
2762: ecx_utils.g_stage_data(i_counter).operand4_name := get_stage_data.operand4_name;
2763: ecx_utils.g_stage_data(i_counter).operand4_pos := get_stage_data.operand4_pos;
2764: ecx_utils.g_stage_data(i_counter).operand4_direction := get_stage_data.operand4_direction;
2765: ecx_utils.g_stage_data(i_counter).operand4_constant := get_stage_data.operand4_constant;
2766: ecx_utils.g_stage_data(i_counter).operand5_level := get_stage_data.operand5_level;
2767: ecx_utils.g_stage_data(i_counter).operand5_name := get_stage_data.operand5_name;
2760: ecx_utils.g_stage_data(i_counter).operand3_constant := get_stage_data.operand3_constant;
2761: ecx_utils.g_stage_data(i_counter).operand4_level := get_stage_data.operand4_level;
2762: ecx_utils.g_stage_data(i_counter).operand4_name := get_stage_data.operand4_name;
2763: ecx_utils.g_stage_data(i_counter).operand4_pos := get_stage_data.operand4_pos;
2764: ecx_utils.g_stage_data(i_counter).operand4_direction := get_stage_data.operand4_direction;
2765: ecx_utils.g_stage_data(i_counter).operand4_constant := get_stage_data.operand4_constant;
2766: ecx_utils.g_stage_data(i_counter).operand5_level := get_stage_data.operand5_level;
2767: ecx_utils.g_stage_data(i_counter).operand5_name := get_stage_data.operand5_name;
2768: ecx_utils.g_stage_data(i_counter).operand5_pos := get_stage_data.operand5_pos;
2761: ecx_utils.g_stage_data(i_counter).operand4_level := get_stage_data.operand4_level;
2762: ecx_utils.g_stage_data(i_counter).operand4_name := get_stage_data.operand4_name;
2763: ecx_utils.g_stage_data(i_counter).operand4_pos := get_stage_data.operand4_pos;
2764: ecx_utils.g_stage_data(i_counter).operand4_direction := get_stage_data.operand4_direction;
2765: ecx_utils.g_stage_data(i_counter).operand4_constant := get_stage_data.operand4_constant;
2766: ecx_utils.g_stage_data(i_counter).operand5_level := get_stage_data.operand5_level;
2767: ecx_utils.g_stage_data(i_counter).operand5_name := get_stage_data.operand5_name;
2768: ecx_utils.g_stage_data(i_counter).operand5_pos := get_stage_data.operand5_pos;
2769: ecx_utils.g_stage_data(i_counter).operand5_direction := get_stage_data.operand5_direction;
2762: ecx_utils.g_stage_data(i_counter).operand4_name := get_stage_data.operand4_name;
2763: ecx_utils.g_stage_data(i_counter).operand4_pos := get_stage_data.operand4_pos;
2764: ecx_utils.g_stage_data(i_counter).operand4_direction := get_stage_data.operand4_direction;
2765: ecx_utils.g_stage_data(i_counter).operand4_constant := get_stage_data.operand4_constant;
2766: ecx_utils.g_stage_data(i_counter).operand5_level := get_stage_data.operand5_level;
2767: ecx_utils.g_stage_data(i_counter).operand5_name := get_stage_data.operand5_name;
2768: ecx_utils.g_stage_data(i_counter).operand5_pos := get_stage_data.operand5_pos;
2769: ecx_utils.g_stage_data(i_counter).operand5_direction := get_stage_data.operand5_direction;
2770: ecx_utils.g_stage_data(i_counter).operand5_constant := get_stage_data.operand5_constant;
2763: ecx_utils.g_stage_data(i_counter).operand4_pos := get_stage_data.operand4_pos;
2764: ecx_utils.g_stage_data(i_counter).operand4_direction := get_stage_data.operand4_direction;
2765: ecx_utils.g_stage_data(i_counter).operand4_constant := get_stage_data.operand4_constant;
2766: ecx_utils.g_stage_data(i_counter).operand5_level := get_stage_data.operand5_level;
2767: ecx_utils.g_stage_data(i_counter).operand5_name := get_stage_data.operand5_name;
2768: ecx_utils.g_stage_data(i_counter).operand5_pos := get_stage_data.operand5_pos;
2769: ecx_utils.g_stage_data(i_counter).operand5_direction := get_stage_data.operand5_direction;
2770: ecx_utils.g_stage_data(i_counter).operand5_constant := get_stage_data.operand5_constant;
2771: ecx_utils.g_stage_data(i_counter).operand6_level := get_stage_data.operand6_level;
2764: ecx_utils.g_stage_data(i_counter).operand4_direction := get_stage_data.operand4_direction;
2765: ecx_utils.g_stage_data(i_counter).operand4_constant := get_stage_data.operand4_constant;
2766: ecx_utils.g_stage_data(i_counter).operand5_level := get_stage_data.operand5_level;
2767: ecx_utils.g_stage_data(i_counter).operand5_name := get_stage_data.operand5_name;
2768: ecx_utils.g_stage_data(i_counter).operand5_pos := get_stage_data.operand5_pos;
2769: ecx_utils.g_stage_data(i_counter).operand5_direction := get_stage_data.operand5_direction;
2770: ecx_utils.g_stage_data(i_counter).operand5_constant := get_stage_data.operand5_constant;
2771: ecx_utils.g_stage_data(i_counter).operand6_level := get_stage_data.operand6_level;
2772: ecx_utils.g_stage_data(i_counter).operand6_name := get_stage_data.operand6_name;
2765: ecx_utils.g_stage_data(i_counter).operand4_constant := get_stage_data.operand4_constant;
2766: ecx_utils.g_stage_data(i_counter).operand5_level := get_stage_data.operand5_level;
2767: ecx_utils.g_stage_data(i_counter).operand5_name := get_stage_data.operand5_name;
2768: ecx_utils.g_stage_data(i_counter).operand5_pos := get_stage_data.operand5_pos;
2769: ecx_utils.g_stage_data(i_counter).operand5_direction := get_stage_data.operand5_direction;
2770: ecx_utils.g_stage_data(i_counter).operand5_constant := get_stage_data.operand5_constant;
2771: ecx_utils.g_stage_data(i_counter).operand6_level := get_stage_data.operand6_level;
2772: ecx_utils.g_stage_data(i_counter).operand6_name := get_stage_data.operand6_name;
2773: ecx_utils.g_stage_data(i_counter).operand6_pos := get_stage_data.operand6_pos;
2766: ecx_utils.g_stage_data(i_counter).operand5_level := get_stage_data.operand5_level;
2767: ecx_utils.g_stage_data(i_counter).operand5_name := get_stage_data.operand5_name;
2768: ecx_utils.g_stage_data(i_counter).operand5_pos := get_stage_data.operand5_pos;
2769: ecx_utils.g_stage_data(i_counter).operand5_direction := get_stage_data.operand5_direction;
2770: ecx_utils.g_stage_data(i_counter).operand5_constant := get_stage_data.operand5_constant;
2771: ecx_utils.g_stage_data(i_counter).operand6_level := get_stage_data.operand6_level;
2772: ecx_utils.g_stage_data(i_counter).operand6_name := get_stage_data.operand6_name;
2773: ecx_utils.g_stage_data(i_counter).operand6_pos := get_stage_data.operand6_pos;
2774: ecx_utils.g_stage_data(i_counter).operand6_direction := get_stage_data.operand6_direction;
2767: ecx_utils.g_stage_data(i_counter).operand5_name := get_stage_data.operand5_name;
2768: ecx_utils.g_stage_data(i_counter).operand5_pos := get_stage_data.operand5_pos;
2769: ecx_utils.g_stage_data(i_counter).operand5_direction := get_stage_data.operand5_direction;
2770: ecx_utils.g_stage_data(i_counter).operand5_constant := get_stage_data.operand5_constant;
2771: ecx_utils.g_stage_data(i_counter).operand6_level := get_stage_data.operand6_level;
2772: ecx_utils.g_stage_data(i_counter).operand6_name := get_stage_data.operand6_name;
2773: ecx_utils.g_stage_data(i_counter).operand6_pos := get_stage_data.operand6_pos;
2774: ecx_utils.g_stage_data(i_counter).operand6_direction := get_stage_data.operand6_direction;
2775: ecx_utils.g_stage_data(i_counter).operand6_constant := get_stage_data.operand6_constant;
2768: ecx_utils.g_stage_data(i_counter).operand5_pos := get_stage_data.operand5_pos;
2769: ecx_utils.g_stage_data(i_counter).operand5_direction := get_stage_data.operand5_direction;
2770: ecx_utils.g_stage_data(i_counter).operand5_constant := get_stage_data.operand5_constant;
2771: ecx_utils.g_stage_data(i_counter).operand6_level := get_stage_data.operand6_level;
2772: ecx_utils.g_stage_data(i_counter).operand6_name := get_stage_data.operand6_name;
2773: ecx_utils.g_stage_data(i_counter).operand6_pos := get_stage_data.operand6_pos;
2774: ecx_utils.g_stage_data(i_counter).operand6_direction := get_stage_data.operand6_direction;
2775: ecx_utils.g_stage_data(i_counter).operand6_constant := get_stage_data.operand6_constant;
2776:
2769: ecx_utils.g_stage_data(i_counter).operand5_direction := get_stage_data.operand5_direction;
2770: ecx_utils.g_stage_data(i_counter).operand5_constant := get_stage_data.operand5_constant;
2771: ecx_utils.g_stage_data(i_counter).operand6_level := get_stage_data.operand6_level;
2772: ecx_utils.g_stage_data(i_counter).operand6_name := get_stage_data.operand6_name;
2773: ecx_utils.g_stage_data(i_counter).operand6_pos := get_stage_data.operand6_pos;
2774: ecx_utils.g_stage_data(i_counter).operand6_direction := get_stage_data.operand6_direction;
2775: ecx_utils.g_stage_data(i_counter).operand6_constant := get_stage_data.operand6_constant;
2776:
2777: if(l_statementEnabled) then
2770: ecx_utils.g_stage_data(i_counter).operand5_constant := get_stage_data.operand5_constant;
2771: ecx_utils.g_stage_data(i_counter).operand6_level := get_stage_data.operand6_level;
2772: ecx_utils.g_stage_data(i_counter).operand6_name := get_stage_data.operand6_name;
2773: ecx_utils.g_stage_data(i_counter).operand6_pos := get_stage_data.operand6_pos;
2774: ecx_utils.g_stage_data(i_counter).operand6_direction := get_stage_data.operand6_direction;
2775: ecx_utils.g_stage_data(i_counter).operand6_constant := get_stage_data.operand6_constant;
2776:
2777: if(l_statementEnabled) then
2778: ecx_debug.log(l_statement,
2771: ecx_utils.g_stage_data(i_counter).operand6_level := get_stage_data.operand6_level;
2772: ecx_utils.g_stage_data(i_counter).operand6_name := get_stage_data.operand6_name;
2773: ecx_utils.g_stage_data(i_counter).operand6_pos := get_stage_data.operand6_pos;
2774: ecx_utils.g_stage_data(i_counter).operand6_direction := get_stage_data.operand6_direction;
2775: ecx_utils.g_stage_data(i_counter).operand6_constant := get_stage_data.operand6_constant;
2776:
2777: if(l_statementEnabled) then
2778: ecx_debug.log(l_statement,
2779: ecx_utils.g_stage_data(i_counter).transtage_id||'|'||
2775: ecx_utils.g_stage_data(i_counter).operand6_constant := get_stage_data.operand6_constant;
2776:
2777: if(l_statementEnabled) then
2778: ecx_debug.log(l_statement,
2779: ecx_utils.g_stage_data(i_counter).transtage_id||'|'||
2780: ecx_utils.g_stage_data(i_counter).level||'|'||
2781: ecx_utils.g_stage_data(i_counter).stage||'|'||
2782: ecx_utils.g_stage_data(i_counter).object_direction||'|'||
2783: ecx_utils.g_stage_data(i_counter).seq_number||'|'||
2776:
2777: if(l_statementEnabled) then
2778: ecx_debug.log(l_statement,
2779: ecx_utils.g_stage_data(i_counter).transtage_id||'|'||
2780: ecx_utils.g_stage_data(i_counter).level||'|'||
2781: ecx_utils.g_stage_data(i_counter).stage||'|'||
2782: ecx_utils.g_stage_data(i_counter).object_direction||'|'||
2783: ecx_utils.g_stage_data(i_counter).seq_number||'|'||
2784: ecx_utils.g_stage_data(i_counter).action_type||'|'||
2777: if(l_statementEnabled) then
2778: ecx_debug.log(l_statement,
2779: ecx_utils.g_stage_data(i_counter).transtage_id||'|'||
2780: ecx_utils.g_stage_data(i_counter).level||'|'||
2781: ecx_utils.g_stage_data(i_counter).stage||'|'||
2782: ecx_utils.g_stage_data(i_counter).object_direction||'|'||
2783: ecx_utils.g_stage_data(i_counter).seq_number||'|'||
2784: ecx_utils.g_stage_data(i_counter).action_type||'|'||
2785: ecx_utils.g_stage_data(i_counter).variable_level||'|'||
2778: ecx_debug.log(l_statement,
2779: ecx_utils.g_stage_data(i_counter).transtage_id||'|'||
2780: ecx_utils.g_stage_data(i_counter).level||'|'||
2781: ecx_utils.g_stage_data(i_counter).stage||'|'||
2782: ecx_utils.g_stage_data(i_counter).object_direction||'|'||
2783: ecx_utils.g_stage_data(i_counter).seq_number||'|'||
2784: ecx_utils.g_stage_data(i_counter).action_type||'|'||
2785: ecx_utils.g_stage_data(i_counter).variable_level||'|'||
2786: ecx_utils.g_stage_data(i_counter).variable_name||'|'||
2779: ecx_utils.g_stage_data(i_counter).transtage_id||'|'||
2780: ecx_utils.g_stage_data(i_counter).level||'|'||
2781: ecx_utils.g_stage_data(i_counter).stage||'|'||
2782: ecx_utils.g_stage_data(i_counter).object_direction||'|'||
2783: ecx_utils.g_stage_data(i_counter).seq_number||'|'||
2784: ecx_utils.g_stage_data(i_counter).action_type||'|'||
2785: ecx_utils.g_stage_data(i_counter).variable_level||'|'||
2786: ecx_utils.g_stage_data(i_counter).variable_name||'|'||
2787: ecx_utils.g_stage_data(i_counter).variable_pos||'|'||
2780: ecx_utils.g_stage_data(i_counter).level||'|'||
2781: ecx_utils.g_stage_data(i_counter).stage||'|'||
2782: ecx_utils.g_stage_data(i_counter).object_direction||'|'||
2783: ecx_utils.g_stage_data(i_counter).seq_number||'|'||
2784: ecx_utils.g_stage_data(i_counter).action_type||'|'||
2785: ecx_utils.g_stage_data(i_counter).variable_level||'|'||
2786: ecx_utils.g_stage_data(i_counter).variable_name||'|'||
2787: ecx_utils.g_stage_data(i_counter).variable_pos||'|'||
2788: ecx_utils.g_stage_data(i_counter).variable_direction||'|'||
2781: ecx_utils.g_stage_data(i_counter).stage||'|'||
2782: ecx_utils.g_stage_data(i_counter).object_direction||'|'||
2783: ecx_utils.g_stage_data(i_counter).seq_number||'|'||
2784: ecx_utils.g_stage_data(i_counter).action_type||'|'||
2785: ecx_utils.g_stage_data(i_counter).variable_level||'|'||
2786: ecx_utils.g_stage_data(i_counter).variable_name||'|'||
2787: ecx_utils.g_stage_data(i_counter).variable_pos||'|'||
2788: ecx_utils.g_stage_data(i_counter).variable_direction||'|'||
2789: ecx_utils.g_stage_data(i_counter).variable_value||'|'||
2782: ecx_utils.g_stage_data(i_counter).object_direction||'|'||
2783: ecx_utils.g_stage_data(i_counter).seq_number||'|'||
2784: ecx_utils.g_stage_data(i_counter).action_type||'|'||
2785: ecx_utils.g_stage_data(i_counter).variable_level||'|'||
2786: ecx_utils.g_stage_data(i_counter).variable_name||'|'||
2787: ecx_utils.g_stage_data(i_counter).variable_pos||'|'||
2788: ecx_utils.g_stage_data(i_counter).variable_direction||'|'||
2789: ecx_utils.g_stage_data(i_counter).variable_value||'|'||
2790: ecx_utils.g_stage_data(i_counter).default_value||'|'||
2783: ecx_utils.g_stage_data(i_counter).seq_number||'|'||
2784: ecx_utils.g_stage_data(i_counter).action_type||'|'||
2785: ecx_utils.g_stage_data(i_counter).variable_level||'|'||
2786: ecx_utils.g_stage_data(i_counter).variable_name||'|'||
2787: ecx_utils.g_stage_data(i_counter).variable_pos||'|'||
2788: ecx_utils.g_stage_data(i_counter).variable_direction||'|'||
2789: ecx_utils.g_stage_data(i_counter).variable_value||'|'||
2790: ecx_utils.g_stage_data(i_counter).default_value||'|'||
2791: ecx_utils.g_stage_data(i_counter).custom_procedure_name||'|'||
2784: ecx_utils.g_stage_data(i_counter).action_type||'|'||
2785: ecx_utils.g_stage_data(i_counter).variable_level||'|'||
2786: ecx_utils.g_stage_data(i_counter).variable_name||'|'||
2787: ecx_utils.g_stage_data(i_counter).variable_pos||'|'||
2788: ecx_utils.g_stage_data(i_counter).variable_direction||'|'||
2789: ecx_utils.g_stage_data(i_counter).variable_value||'|'||
2790: ecx_utils.g_stage_data(i_counter).default_value||'|'||
2791: ecx_utils.g_stage_data(i_counter).custom_procedure_name||'|'||
2792: ecx_utils.g_stage_data(i_counter).data_type||'|'||
2785: ecx_utils.g_stage_data(i_counter).variable_level||'|'||
2786: ecx_utils.g_stage_data(i_counter).variable_name||'|'||
2787: ecx_utils.g_stage_data(i_counter).variable_pos||'|'||
2788: ecx_utils.g_stage_data(i_counter).variable_direction||'|'||
2789: ecx_utils.g_stage_data(i_counter).variable_value||'|'||
2790: ecx_utils.g_stage_data(i_counter).default_value||'|'||
2791: ecx_utils.g_stage_data(i_counter).custom_procedure_name||'|'||
2792: ecx_utils.g_stage_data(i_counter).data_type||'|'||
2793: ecx_utils.g_stage_data(i_counter).function_name||'|'||
2786: ecx_utils.g_stage_data(i_counter).variable_name||'|'||
2787: ecx_utils.g_stage_data(i_counter).variable_pos||'|'||
2788: ecx_utils.g_stage_data(i_counter).variable_direction||'|'||
2789: ecx_utils.g_stage_data(i_counter).variable_value||'|'||
2790: ecx_utils.g_stage_data(i_counter).default_value||'|'||
2791: ecx_utils.g_stage_data(i_counter).custom_procedure_name||'|'||
2792: ecx_utils.g_stage_data(i_counter).data_type||'|'||
2793: ecx_utils.g_stage_data(i_counter).function_name||'|'||
2794: ecx_utils.g_stage_data(i_counter).clause||'|'||
2787: ecx_utils.g_stage_data(i_counter).variable_pos||'|'||
2788: ecx_utils.g_stage_data(i_counter).variable_direction||'|'||
2789: ecx_utils.g_stage_data(i_counter).variable_value||'|'||
2790: ecx_utils.g_stage_data(i_counter).default_value||'|'||
2791: ecx_utils.g_stage_data(i_counter).custom_procedure_name||'|'||
2792: ecx_utils.g_stage_data(i_counter).data_type||'|'||
2793: ecx_utils.g_stage_data(i_counter).function_name||'|'||
2794: ecx_utils.g_stage_data(i_counter).clause||'|'||
2795: ecx_utils.g_stage_data(i_counter).cond_logical_operator||'|'||
2788: ecx_utils.g_stage_data(i_counter).variable_direction||'|'||
2789: ecx_utils.g_stage_data(i_counter).variable_value||'|'||
2790: ecx_utils.g_stage_data(i_counter).default_value||'|'||
2791: ecx_utils.g_stage_data(i_counter).custom_procedure_name||'|'||
2792: ecx_utils.g_stage_data(i_counter).data_type||'|'||
2793: ecx_utils.g_stage_data(i_counter).function_name||'|'||
2794: ecx_utils.g_stage_data(i_counter).clause||'|'||
2795: ecx_utils.g_stage_data(i_counter).cond_logical_operator||'|'||
2796: ecx_utils.g_stage_data(i_counter).cond_operator1||'|'||
2789: ecx_utils.g_stage_data(i_counter).variable_value||'|'||
2790: ecx_utils.g_stage_data(i_counter).default_value||'|'||
2791: ecx_utils.g_stage_data(i_counter).custom_procedure_name||'|'||
2792: ecx_utils.g_stage_data(i_counter).data_type||'|'||
2793: ecx_utils.g_stage_data(i_counter).function_name||'|'||
2794: ecx_utils.g_stage_data(i_counter).clause||'|'||
2795: ecx_utils.g_stage_data(i_counter).cond_logical_operator||'|'||
2796: ecx_utils.g_stage_data(i_counter).cond_operator1||'|'||
2797: ecx_utils.g_stage_data(i_counter).cond_var1_level||'|'||
2790: ecx_utils.g_stage_data(i_counter).default_value||'|'||
2791: ecx_utils.g_stage_data(i_counter).custom_procedure_name||'|'||
2792: ecx_utils.g_stage_data(i_counter).data_type||'|'||
2793: ecx_utils.g_stage_data(i_counter).function_name||'|'||
2794: ecx_utils.g_stage_data(i_counter).clause||'|'||
2795: ecx_utils.g_stage_data(i_counter).cond_logical_operator||'|'||
2796: ecx_utils.g_stage_data(i_counter).cond_operator1||'|'||
2797: ecx_utils.g_stage_data(i_counter).cond_var1_level||'|'||
2798: ecx_utils.g_stage_data(i_counter).cond_var1_name||'|'||
2791: ecx_utils.g_stage_data(i_counter).custom_procedure_name||'|'||
2792: ecx_utils.g_stage_data(i_counter).data_type||'|'||
2793: ecx_utils.g_stage_data(i_counter).function_name||'|'||
2794: ecx_utils.g_stage_data(i_counter).clause||'|'||
2795: ecx_utils.g_stage_data(i_counter).cond_logical_operator||'|'||
2796: ecx_utils.g_stage_data(i_counter).cond_operator1||'|'||
2797: ecx_utils.g_stage_data(i_counter).cond_var1_level||'|'||
2798: ecx_utils.g_stage_data(i_counter).cond_var1_name||'|'||
2799: ecx_utils.g_stage_data(i_counter).cond_var1_pos||'|'||
2792: ecx_utils.g_stage_data(i_counter).data_type||'|'||
2793: ecx_utils.g_stage_data(i_counter).function_name||'|'||
2794: ecx_utils.g_stage_data(i_counter).clause||'|'||
2795: ecx_utils.g_stage_data(i_counter).cond_logical_operator||'|'||
2796: ecx_utils.g_stage_data(i_counter).cond_operator1||'|'||
2797: ecx_utils.g_stage_data(i_counter).cond_var1_level||'|'||
2798: ecx_utils.g_stage_data(i_counter).cond_var1_name||'|'||
2799: ecx_utils.g_stage_data(i_counter).cond_var1_pos||'|'||
2800: ecx_utils.g_stage_data(i_counter).cond_var1_direction||'|'||
2793: ecx_utils.g_stage_data(i_counter).function_name||'|'||
2794: ecx_utils.g_stage_data(i_counter).clause||'|'||
2795: ecx_utils.g_stage_data(i_counter).cond_logical_operator||'|'||
2796: ecx_utils.g_stage_data(i_counter).cond_operator1||'|'||
2797: ecx_utils.g_stage_data(i_counter).cond_var1_level||'|'||
2798: ecx_utils.g_stage_data(i_counter).cond_var1_name||'|'||
2799: ecx_utils.g_stage_data(i_counter).cond_var1_pos||'|'||
2800: ecx_utils.g_stage_data(i_counter).cond_var1_direction||'|'||
2801: ecx_utils.g_stage_data(i_counter).cond_var1_constant||'|'||
2794: ecx_utils.g_stage_data(i_counter).clause||'|'||
2795: ecx_utils.g_stage_data(i_counter).cond_logical_operator||'|'||
2796: ecx_utils.g_stage_data(i_counter).cond_operator1||'|'||
2797: ecx_utils.g_stage_data(i_counter).cond_var1_level||'|'||
2798: ecx_utils.g_stage_data(i_counter).cond_var1_name||'|'||
2799: ecx_utils.g_stage_data(i_counter).cond_var1_pos||'|'||
2800: ecx_utils.g_stage_data(i_counter).cond_var1_direction||'|'||
2801: ecx_utils.g_stage_data(i_counter).cond_var1_constant||'|'||
2802: ecx_utils.g_stage_data(i_counter).cond_val1_level||'|'||
2795: ecx_utils.g_stage_data(i_counter).cond_logical_operator||'|'||
2796: ecx_utils.g_stage_data(i_counter).cond_operator1||'|'||
2797: ecx_utils.g_stage_data(i_counter).cond_var1_level||'|'||
2798: ecx_utils.g_stage_data(i_counter).cond_var1_name||'|'||
2799: ecx_utils.g_stage_data(i_counter).cond_var1_pos||'|'||
2800: ecx_utils.g_stage_data(i_counter).cond_var1_direction||'|'||
2801: ecx_utils.g_stage_data(i_counter).cond_var1_constant||'|'||
2802: ecx_utils.g_stage_data(i_counter).cond_val1_level||'|'||
2803: ecx_utils.g_stage_data(i_counter).cond_val1_name||'|'||
2796: ecx_utils.g_stage_data(i_counter).cond_operator1||'|'||
2797: ecx_utils.g_stage_data(i_counter).cond_var1_level||'|'||
2798: ecx_utils.g_stage_data(i_counter).cond_var1_name||'|'||
2799: ecx_utils.g_stage_data(i_counter).cond_var1_pos||'|'||
2800: ecx_utils.g_stage_data(i_counter).cond_var1_direction||'|'||
2801: ecx_utils.g_stage_data(i_counter).cond_var1_constant||'|'||
2802: ecx_utils.g_stage_data(i_counter).cond_val1_level||'|'||
2803: ecx_utils.g_stage_data(i_counter).cond_val1_name||'|'||
2804: ecx_utils.g_stage_data(i_counter).cond_val1_pos||'|'||
2797: ecx_utils.g_stage_data(i_counter).cond_var1_level||'|'||
2798: ecx_utils.g_stage_data(i_counter).cond_var1_name||'|'||
2799: ecx_utils.g_stage_data(i_counter).cond_var1_pos||'|'||
2800: ecx_utils.g_stage_data(i_counter).cond_var1_direction||'|'||
2801: ecx_utils.g_stage_data(i_counter).cond_var1_constant||'|'||
2802: ecx_utils.g_stage_data(i_counter).cond_val1_level||'|'||
2803: ecx_utils.g_stage_data(i_counter).cond_val1_name||'|'||
2804: ecx_utils.g_stage_data(i_counter).cond_val1_pos||'|'||
2805: ecx_utils.g_stage_data(i_counter).cond_val1_direction||'|'||
2798: ecx_utils.g_stage_data(i_counter).cond_var1_name||'|'||
2799: ecx_utils.g_stage_data(i_counter).cond_var1_pos||'|'||
2800: ecx_utils.g_stage_data(i_counter).cond_var1_direction||'|'||
2801: ecx_utils.g_stage_data(i_counter).cond_var1_constant||'|'||
2802: ecx_utils.g_stage_data(i_counter).cond_val1_level||'|'||
2803: ecx_utils.g_stage_data(i_counter).cond_val1_name||'|'||
2804: ecx_utils.g_stage_data(i_counter).cond_val1_pos||'|'||
2805: ecx_utils.g_stage_data(i_counter).cond_val1_direction||'|'||
2806: ecx_utils.g_stage_data(i_counter).cond_val1_constant||'|'||
2799: ecx_utils.g_stage_data(i_counter).cond_var1_pos||'|'||
2800: ecx_utils.g_stage_data(i_counter).cond_var1_direction||'|'||
2801: ecx_utils.g_stage_data(i_counter).cond_var1_constant||'|'||
2802: ecx_utils.g_stage_data(i_counter).cond_val1_level||'|'||
2803: ecx_utils.g_stage_data(i_counter).cond_val1_name||'|'||
2804: ecx_utils.g_stage_data(i_counter).cond_val1_pos||'|'||
2805: ecx_utils.g_stage_data(i_counter).cond_val1_direction||'|'||
2806: ecx_utils.g_stage_data(i_counter).cond_val1_constant||'|'||
2807: ecx_utils.g_stage_data(i_counter).cond_operator2||'|'||
2800: ecx_utils.g_stage_data(i_counter).cond_var1_direction||'|'||
2801: ecx_utils.g_stage_data(i_counter).cond_var1_constant||'|'||
2802: ecx_utils.g_stage_data(i_counter).cond_val1_level||'|'||
2803: ecx_utils.g_stage_data(i_counter).cond_val1_name||'|'||
2804: ecx_utils.g_stage_data(i_counter).cond_val1_pos||'|'||
2805: ecx_utils.g_stage_data(i_counter).cond_val1_direction||'|'||
2806: ecx_utils.g_stage_data(i_counter).cond_val1_constant||'|'||
2807: ecx_utils.g_stage_data(i_counter).cond_operator2||'|'||
2808: ecx_utils.g_stage_data(i_counter).cond_var2_level||'|'||
2801: ecx_utils.g_stage_data(i_counter).cond_var1_constant||'|'||
2802: ecx_utils.g_stage_data(i_counter).cond_val1_level||'|'||
2803: ecx_utils.g_stage_data(i_counter).cond_val1_name||'|'||
2804: ecx_utils.g_stage_data(i_counter).cond_val1_pos||'|'||
2805: ecx_utils.g_stage_data(i_counter).cond_val1_direction||'|'||
2806: ecx_utils.g_stage_data(i_counter).cond_val1_constant||'|'||
2807: ecx_utils.g_stage_data(i_counter).cond_operator2||'|'||
2808: ecx_utils.g_stage_data(i_counter).cond_var2_level||'|'||
2809: ecx_utils.g_stage_data(i_counter).cond_var2_name||'|'||
2802: ecx_utils.g_stage_data(i_counter).cond_val1_level||'|'||
2803: ecx_utils.g_stage_data(i_counter).cond_val1_name||'|'||
2804: ecx_utils.g_stage_data(i_counter).cond_val1_pos||'|'||
2805: ecx_utils.g_stage_data(i_counter).cond_val1_direction||'|'||
2806: ecx_utils.g_stage_data(i_counter).cond_val1_constant||'|'||
2807: ecx_utils.g_stage_data(i_counter).cond_operator2||'|'||
2808: ecx_utils.g_stage_data(i_counter).cond_var2_level||'|'||
2809: ecx_utils.g_stage_data(i_counter).cond_var2_name||'|'||
2810: ecx_utils.g_stage_data(i_counter).cond_var2_pos||'|'||
2803: ecx_utils.g_stage_data(i_counter).cond_val1_name||'|'||
2804: ecx_utils.g_stage_data(i_counter).cond_val1_pos||'|'||
2805: ecx_utils.g_stage_data(i_counter).cond_val1_direction||'|'||
2806: ecx_utils.g_stage_data(i_counter).cond_val1_constant||'|'||
2807: ecx_utils.g_stage_data(i_counter).cond_operator2||'|'||
2808: ecx_utils.g_stage_data(i_counter).cond_var2_level||'|'||
2809: ecx_utils.g_stage_data(i_counter).cond_var2_name||'|'||
2810: ecx_utils.g_stage_data(i_counter).cond_var2_pos||'|'||
2811: ecx_utils.g_stage_data(i_counter).cond_var2_direction||'|'||
2804: ecx_utils.g_stage_data(i_counter).cond_val1_pos||'|'||
2805: ecx_utils.g_stage_data(i_counter).cond_val1_direction||'|'||
2806: ecx_utils.g_stage_data(i_counter).cond_val1_constant||'|'||
2807: ecx_utils.g_stage_data(i_counter).cond_operator2||'|'||
2808: ecx_utils.g_stage_data(i_counter).cond_var2_level||'|'||
2809: ecx_utils.g_stage_data(i_counter).cond_var2_name||'|'||
2810: ecx_utils.g_stage_data(i_counter).cond_var2_pos||'|'||
2811: ecx_utils.g_stage_data(i_counter).cond_var2_direction||'|'||
2812: ecx_utils.g_stage_data(i_counter).cond_var2_constant||'|'||
2805: ecx_utils.g_stage_data(i_counter).cond_val1_direction||'|'||
2806: ecx_utils.g_stage_data(i_counter).cond_val1_constant||'|'||
2807: ecx_utils.g_stage_data(i_counter).cond_operator2||'|'||
2808: ecx_utils.g_stage_data(i_counter).cond_var2_level||'|'||
2809: ecx_utils.g_stage_data(i_counter).cond_var2_name||'|'||
2810: ecx_utils.g_stage_data(i_counter).cond_var2_pos||'|'||
2811: ecx_utils.g_stage_data(i_counter).cond_var2_direction||'|'||
2812: ecx_utils.g_stage_data(i_counter).cond_var2_constant||'|'||
2813: ecx_utils.g_stage_data(i_counter).cond_val2_level||'|'||
2806: ecx_utils.g_stage_data(i_counter).cond_val1_constant||'|'||
2807: ecx_utils.g_stage_data(i_counter).cond_operator2||'|'||
2808: ecx_utils.g_stage_data(i_counter).cond_var2_level||'|'||
2809: ecx_utils.g_stage_data(i_counter).cond_var2_name||'|'||
2810: ecx_utils.g_stage_data(i_counter).cond_var2_pos||'|'||
2811: ecx_utils.g_stage_data(i_counter).cond_var2_direction||'|'||
2812: ecx_utils.g_stage_data(i_counter).cond_var2_constant||'|'||
2813: ecx_utils.g_stage_data(i_counter).cond_val2_level||'|'||
2814: ecx_utils.g_stage_data(i_counter).cond_val2_name||'|'||
2807: ecx_utils.g_stage_data(i_counter).cond_operator2||'|'||
2808: ecx_utils.g_stage_data(i_counter).cond_var2_level||'|'||
2809: ecx_utils.g_stage_data(i_counter).cond_var2_name||'|'||
2810: ecx_utils.g_stage_data(i_counter).cond_var2_pos||'|'||
2811: ecx_utils.g_stage_data(i_counter).cond_var2_direction||'|'||
2812: ecx_utils.g_stage_data(i_counter).cond_var2_constant||'|'||
2813: ecx_utils.g_stage_data(i_counter).cond_val2_level||'|'||
2814: ecx_utils.g_stage_data(i_counter).cond_val2_name||'|'||
2815: ecx_utils.g_stage_data(i_counter).cond_val2_pos||'|'||
2808: ecx_utils.g_stage_data(i_counter).cond_var2_level||'|'||
2809: ecx_utils.g_stage_data(i_counter).cond_var2_name||'|'||
2810: ecx_utils.g_stage_data(i_counter).cond_var2_pos||'|'||
2811: ecx_utils.g_stage_data(i_counter).cond_var2_direction||'|'||
2812: ecx_utils.g_stage_data(i_counter).cond_var2_constant||'|'||
2813: ecx_utils.g_stage_data(i_counter).cond_val2_level||'|'||
2814: ecx_utils.g_stage_data(i_counter).cond_val2_name||'|'||
2815: ecx_utils.g_stage_data(i_counter).cond_val2_pos||'|'||
2816: ecx_utils.g_stage_data(i_counter).cond_val2_direction||'|'||
2809: ecx_utils.g_stage_data(i_counter).cond_var2_name||'|'||
2810: ecx_utils.g_stage_data(i_counter).cond_var2_pos||'|'||
2811: ecx_utils.g_stage_data(i_counter).cond_var2_direction||'|'||
2812: ecx_utils.g_stage_data(i_counter).cond_var2_constant||'|'||
2813: ecx_utils.g_stage_data(i_counter).cond_val2_level||'|'||
2814: ecx_utils.g_stage_data(i_counter).cond_val2_name||'|'||
2815: ecx_utils.g_stage_data(i_counter).cond_val2_pos||'|'||
2816: ecx_utils.g_stage_data(i_counter).cond_val2_direction||'|'||
2817: ecx_utils.g_stage_data(i_counter).cond_val2_constant||'|'||
2810: ecx_utils.g_stage_data(i_counter).cond_var2_pos||'|'||
2811: ecx_utils.g_stage_data(i_counter).cond_var2_direction||'|'||
2812: ecx_utils.g_stage_data(i_counter).cond_var2_constant||'|'||
2813: ecx_utils.g_stage_data(i_counter).cond_val2_level||'|'||
2814: ecx_utils.g_stage_data(i_counter).cond_val2_name||'|'||
2815: ecx_utils.g_stage_data(i_counter).cond_val2_pos||'|'||
2816: ecx_utils.g_stage_data(i_counter).cond_val2_direction||'|'||
2817: ecx_utils.g_stage_data(i_counter).cond_val2_constant||'|'||
2818: ecx_utils.g_stage_data(i_counter).operand1_level||'|'||
2811: ecx_utils.g_stage_data(i_counter).cond_var2_direction||'|'||
2812: ecx_utils.g_stage_data(i_counter).cond_var2_constant||'|'||
2813: ecx_utils.g_stage_data(i_counter).cond_val2_level||'|'||
2814: ecx_utils.g_stage_data(i_counter).cond_val2_name||'|'||
2815: ecx_utils.g_stage_data(i_counter).cond_val2_pos||'|'||
2816: ecx_utils.g_stage_data(i_counter).cond_val2_direction||'|'||
2817: ecx_utils.g_stage_data(i_counter).cond_val2_constant||'|'||
2818: ecx_utils.g_stage_data(i_counter).operand1_level||'|'||
2819: ecx_utils.g_stage_data(i_counter).operand1_name||'|'||
2812: ecx_utils.g_stage_data(i_counter).cond_var2_constant||'|'||
2813: ecx_utils.g_stage_data(i_counter).cond_val2_level||'|'||
2814: ecx_utils.g_stage_data(i_counter).cond_val2_name||'|'||
2815: ecx_utils.g_stage_data(i_counter).cond_val2_pos||'|'||
2816: ecx_utils.g_stage_data(i_counter).cond_val2_direction||'|'||
2817: ecx_utils.g_stage_data(i_counter).cond_val2_constant||'|'||
2818: ecx_utils.g_stage_data(i_counter).operand1_level||'|'||
2819: ecx_utils.g_stage_data(i_counter).operand1_name||'|'||
2820: ecx_utils.g_stage_data(i_counter).operand1_pos||'|'||
2813: ecx_utils.g_stage_data(i_counter).cond_val2_level||'|'||
2814: ecx_utils.g_stage_data(i_counter).cond_val2_name||'|'||
2815: ecx_utils.g_stage_data(i_counter).cond_val2_pos||'|'||
2816: ecx_utils.g_stage_data(i_counter).cond_val2_direction||'|'||
2817: ecx_utils.g_stage_data(i_counter).cond_val2_constant||'|'||
2818: ecx_utils.g_stage_data(i_counter).operand1_level||'|'||
2819: ecx_utils.g_stage_data(i_counter).operand1_name||'|'||
2820: ecx_utils.g_stage_data(i_counter).operand1_pos||'|'||
2821: ecx_utils.g_stage_data(i_counter).operand1_direction||'|'||
2814: ecx_utils.g_stage_data(i_counter).cond_val2_name||'|'||
2815: ecx_utils.g_stage_data(i_counter).cond_val2_pos||'|'||
2816: ecx_utils.g_stage_data(i_counter).cond_val2_direction||'|'||
2817: ecx_utils.g_stage_data(i_counter).cond_val2_constant||'|'||
2818: ecx_utils.g_stage_data(i_counter).operand1_level||'|'||
2819: ecx_utils.g_stage_data(i_counter).operand1_name||'|'||
2820: ecx_utils.g_stage_data(i_counter).operand1_pos||'|'||
2821: ecx_utils.g_stage_data(i_counter).operand1_direction||'|'||
2822: ecx_utils.g_stage_data(i_counter).operand1_constant||'|'||
2815: ecx_utils.g_stage_data(i_counter).cond_val2_pos||'|'||
2816: ecx_utils.g_stage_data(i_counter).cond_val2_direction||'|'||
2817: ecx_utils.g_stage_data(i_counter).cond_val2_constant||'|'||
2818: ecx_utils.g_stage_data(i_counter).operand1_level||'|'||
2819: ecx_utils.g_stage_data(i_counter).operand1_name||'|'||
2820: ecx_utils.g_stage_data(i_counter).operand1_pos||'|'||
2821: ecx_utils.g_stage_data(i_counter).operand1_direction||'|'||
2822: ecx_utils.g_stage_data(i_counter).operand1_constant||'|'||
2823: ecx_utils.g_stage_data(i_counter).operand1_start_pos||'|'||
2816: ecx_utils.g_stage_data(i_counter).cond_val2_direction||'|'||
2817: ecx_utils.g_stage_data(i_counter).cond_val2_constant||'|'||
2818: ecx_utils.g_stage_data(i_counter).operand1_level||'|'||
2819: ecx_utils.g_stage_data(i_counter).operand1_name||'|'||
2820: ecx_utils.g_stage_data(i_counter).operand1_pos||'|'||
2821: ecx_utils.g_stage_data(i_counter).operand1_direction||'|'||
2822: ecx_utils.g_stage_data(i_counter).operand1_constant||'|'||
2823: ecx_utils.g_stage_data(i_counter).operand1_start_pos||'|'||
2824: ecx_utils.g_stage_data(i_counter).operand1_len||'|'||
2817: ecx_utils.g_stage_data(i_counter).cond_val2_constant||'|'||
2818: ecx_utils.g_stage_data(i_counter).operand1_level||'|'||
2819: ecx_utils.g_stage_data(i_counter).operand1_name||'|'||
2820: ecx_utils.g_stage_data(i_counter).operand1_pos||'|'||
2821: ecx_utils.g_stage_data(i_counter).operand1_direction||'|'||
2822: ecx_utils.g_stage_data(i_counter).operand1_constant||'|'||
2823: ecx_utils.g_stage_data(i_counter).operand1_start_pos||'|'||
2824: ecx_utils.g_stage_data(i_counter).operand1_len||'|'||
2825: ecx_utils.g_stage_data(i_counter).operand2_level||'|'||
2818: ecx_utils.g_stage_data(i_counter).operand1_level||'|'||
2819: ecx_utils.g_stage_data(i_counter).operand1_name||'|'||
2820: ecx_utils.g_stage_data(i_counter).operand1_pos||'|'||
2821: ecx_utils.g_stage_data(i_counter).operand1_direction||'|'||
2822: ecx_utils.g_stage_data(i_counter).operand1_constant||'|'||
2823: ecx_utils.g_stage_data(i_counter).operand1_start_pos||'|'||
2824: ecx_utils.g_stage_data(i_counter).operand1_len||'|'||
2825: ecx_utils.g_stage_data(i_counter).operand2_level||'|'||
2826: ecx_utils.g_stage_data(i_counter).operand2_name||'|'||
2819: ecx_utils.g_stage_data(i_counter).operand1_name||'|'||
2820: ecx_utils.g_stage_data(i_counter).operand1_pos||'|'||
2821: ecx_utils.g_stage_data(i_counter).operand1_direction||'|'||
2822: ecx_utils.g_stage_data(i_counter).operand1_constant||'|'||
2823: ecx_utils.g_stage_data(i_counter).operand1_start_pos||'|'||
2824: ecx_utils.g_stage_data(i_counter).operand1_len||'|'||
2825: ecx_utils.g_stage_data(i_counter).operand2_level||'|'||
2826: ecx_utils.g_stage_data(i_counter).operand2_name||'|'||
2827: ecx_utils.g_stage_data(i_counter).operand2_pos||'|'||
2820: ecx_utils.g_stage_data(i_counter).operand1_pos||'|'||
2821: ecx_utils.g_stage_data(i_counter).operand1_direction||'|'||
2822: ecx_utils.g_stage_data(i_counter).operand1_constant||'|'||
2823: ecx_utils.g_stage_data(i_counter).operand1_start_pos||'|'||
2824: ecx_utils.g_stage_data(i_counter).operand1_len||'|'||
2825: ecx_utils.g_stage_data(i_counter).operand2_level||'|'||
2826: ecx_utils.g_stage_data(i_counter).operand2_name||'|'||
2827: ecx_utils.g_stage_data(i_counter).operand2_pos||'|'||
2828: ecx_utils.g_stage_data(i_counter).operand2_direction||'|'||
2821: ecx_utils.g_stage_data(i_counter).operand1_direction||'|'||
2822: ecx_utils.g_stage_data(i_counter).operand1_constant||'|'||
2823: ecx_utils.g_stage_data(i_counter).operand1_start_pos||'|'||
2824: ecx_utils.g_stage_data(i_counter).operand1_len||'|'||
2825: ecx_utils.g_stage_data(i_counter).operand2_level||'|'||
2826: ecx_utils.g_stage_data(i_counter).operand2_name||'|'||
2827: ecx_utils.g_stage_data(i_counter).operand2_pos||'|'||
2828: ecx_utils.g_stage_data(i_counter).operand2_direction||'|'||
2829: ecx_utils.g_stage_data(i_counter).operand2_constant||'|'||
2822: ecx_utils.g_stage_data(i_counter).operand1_constant||'|'||
2823: ecx_utils.g_stage_data(i_counter).operand1_start_pos||'|'||
2824: ecx_utils.g_stage_data(i_counter).operand1_len||'|'||
2825: ecx_utils.g_stage_data(i_counter).operand2_level||'|'||
2826: ecx_utils.g_stage_data(i_counter).operand2_name||'|'||
2827: ecx_utils.g_stage_data(i_counter).operand2_pos||'|'||
2828: ecx_utils.g_stage_data(i_counter).operand2_direction||'|'||
2829: ecx_utils.g_stage_data(i_counter).operand2_constant||'|'||
2830: ecx_utils.g_stage_data(i_counter).operand3_level||'|'||
2823: ecx_utils.g_stage_data(i_counter).operand1_start_pos||'|'||
2824: ecx_utils.g_stage_data(i_counter).operand1_len||'|'||
2825: ecx_utils.g_stage_data(i_counter).operand2_level||'|'||
2826: ecx_utils.g_stage_data(i_counter).operand2_name||'|'||
2827: ecx_utils.g_stage_data(i_counter).operand2_pos||'|'||
2828: ecx_utils.g_stage_data(i_counter).operand2_direction||'|'||
2829: ecx_utils.g_stage_data(i_counter).operand2_constant||'|'||
2830: ecx_utils.g_stage_data(i_counter).operand3_level||'|'||
2831: ecx_utils.g_stage_data(i_counter).operand3_name||'|'||
2824: ecx_utils.g_stage_data(i_counter).operand1_len||'|'||
2825: ecx_utils.g_stage_data(i_counter).operand2_level||'|'||
2826: ecx_utils.g_stage_data(i_counter).operand2_name||'|'||
2827: ecx_utils.g_stage_data(i_counter).operand2_pos||'|'||
2828: ecx_utils.g_stage_data(i_counter).operand2_direction||'|'||
2829: ecx_utils.g_stage_data(i_counter).operand2_constant||'|'||
2830: ecx_utils.g_stage_data(i_counter).operand3_level||'|'||
2831: ecx_utils.g_stage_data(i_counter).operand3_name||'|'||
2832: ecx_utils.g_stage_data(i_counter).operand3_pos||'|'||
2825: ecx_utils.g_stage_data(i_counter).operand2_level||'|'||
2826: ecx_utils.g_stage_data(i_counter).operand2_name||'|'||
2827: ecx_utils.g_stage_data(i_counter).operand2_pos||'|'||
2828: ecx_utils.g_stage_data(i_counter).operand2_direction||'|'||
2829: ecx_utils.g_stage_data(i_counter).operand2_constant||'|'||
2830: ecx_utils.g_stage_data(i_counter).operand3_level||'|'||
2831: ecx_utils.g_stage_data(i_counter).operand3_name||'|'||
2832: ecx_utils.g_stage_data(i_counter).operand3_pos||'|'||
2833: ecx_utils.g_stage_data(i_counter).operand3_direction||'|'||
2826: ecx_utils.g_stage_data(i_counter).operand2_name||'|'||
2827: ecx_utils.g_stage_data(i_counter).operand2_pos||'|'||
2828: ecx_utils.g_stage_data(i_counter).operand2_direction||'|'||
2829: ecx_utils.g_stage_data(i_counter).operand2_constant||'|'||
2830: ecx_utils.g_stage_data(i_counter).operand3_level||'|'||
2831: ecx_utils.g_stage_data(i_counter).operand3_name||'|'||
2832: ecx_utils.g_stage_data(i_counter).operand3_pos||'|'||
2833: ecx_utils.g_stage_data(i_counter).operand3_direction||'|'||
2834: ecx_utils.g_stage_data(i_counter).operand3_constant||'|'||
2827: ecx_utils.g_stage_data(i_counter).operand2_pos||'|'||
2828: ecx_utils.g_stage_data(i_counter).operand2_direction||'|'||
2829: ecx_utils.g_stage_data(i_counter).operand2_constant||'|'||
2830: ecx_utils.g_stage_data(i_counter).operand3_level||'|'||
2831: ecx_utils.g_stage_data(i_counter).operand3_name||'|'||
2832: ecx_utils.g_stage_data(i_counter).operand3_pos||'|'||
2833: ecx_utils.g_stage_data(i_counter).operand3_direction||'|'||
2834: ecx_utils.g_stage_data(i_counter).operand3_constant||'|'||
2835: ecx_utils.g_stage_data(i_counter).operand4_level||'|'||
2828: ecx_utils.g_stage_data(i_counter).operand2_direction||'|'||
2829: ecx_utils.g_stage_data(i_counter).operand2_constant||'|'||
2830: ecx_utils.g_stage_data(i_counter).operand3_level||'|'||
2831: ecx_utils.g_stage_data(i_counter).operand3_name||'|'||
2832: ecx_utils.g_stage_data(i_counter).operand3_pos||'|'||
2833: ecx_utils.g_stage_data(i_counter).operand3_direction||'|'||
2834: ecx_utils.g_stage_data(i_counter).operand3_constant||'|'||
2835: ecx_utils.g_stage_data(i_counter).operand4_level||'|'||
2836: ecx_utils.g_stage_data(i_counter).operand4_name||'|'||
2829: ecx_utils.g_stage_data(i_counter).operand2_constant||'|'||
2830: ecx_utils.g_stage_data(i_counter).operand3_level||'|'||
2831: ecx_utils.g_stage_data(i_counter).operand3_name||'|'||
2832: ecx_utils.g_stage_data(i_counter).operand3_pos||'|'||
2833: ecx_utils.g_stage_data(i_counter).operand3_direction||'|'||
2834: ecx_utils.g_stage_data(i_counter).operand3_constant||'|'||
2835: ecx_utils.g_stage_data(i_counter).operand4_level||'|'||
2836: ecx_utils.g_stage_data(i_counter).operand4_name||'|'||
2837: ecx_utils.g_stage_data(i_counter).operand4_pos||'|'||
2830: ecx_utils.g_stage_data(i_counter).operand3_level||'|'||
2831: ecx_utils.g_stage_data(i_counter).operand3_name||'|'||
2832: ecx_utils.g_stage_data(i_counter).operand3_pos||'|'||
2833: ecx_utils.g_stage_data(i_counter).operand3_direction||'|'||
2834: ecx_utils.g_stage_data(i_counter).operand3_constant||'|'||
2835: ecx_utils.g_stage_data(i_counter).operand4_level||'|'||
2836: ecx_utils.g_stage_data(i_counter).operand4_name||'|'||
2837: ecx_utils.g_stage_data(i_counter).operand4_pos||'|'||
2838: ecx_utils.g_stage_data(i_counter).operand4_direction||'|'||
2831: ecx_utils.g_stage_data(i_counter).operand3_name||'|'||
2832: ecx_utils.g_stage_data(i_counter).operand3_pos||'|'||
2833: ecx_utils.g_stage_data(i_counter).operand3_direction||'|'||
2834: ecx_utils.g_stage_data(i_counter).operand3_constant||'|'||
2835: ecx_utils.g_stage_data(i_counter).operand4_level||'|'||
2836: ecx_utils.g_stage_data(i_counter).operand4_name||'|'||
2837: ecx_utils.g_stage_data(i_counter).operand4_pos||'|'||
2838: ecx_utils.g_stage_data(i_counter).operand4_direction||'|'||
2839: ecx_utils.g_stage_data(i_counter).operand4_constant||'|'||
2832: ecx_utils.g_stage_data(i_counter).operand3_pos||'|'||
2833: ecx_utils.g_stage_data(i_counter).operand3_direction||'|'||
2834: ecx_utils.g_stage_data(i_counter).operand3_constant||'|'||
2835: ecx_utils.g_stage_data(i_counter).operand4_level||'|'||
2836: ecx_utils.g_stage_data(i_counter).operand4_name||'|'||
2837: ecx_utils.g_stage_data(i_counter).operand4_pos||'|'||
2838: ecx_utils.g_stage_data(i_counter).operand4_direction||'|'||
2839: ecx_utils.g_stage_data(i_counter).operand4_constant||'|'||
2840: ecx_utils.g_stage_data(i_counter).operand5_level||'|'||
2833: ecx_utils.g_stage_data(i_counter).operand3_direction||'|'||
2834: ecx_utils.g_stage_data(i_counter).operand3_constant||'|'||
2835: ecx_utils.g_stage_data(i_counter).operand4_level||'|'||
2836: ecx_utils.g_stage_data(i_counter).operand4_name||'|'||
2837: ecx_utils.g_stage_data(i_counter).operand4_pos||'|'||
2838: ecx_utils.g_stage_data(i_counter).operand4_direction||'|'||
2839: ecx_utils.g_stage_data(i_counter).operand4_constant||'|'||
2840: ecx_utils.g_stage_data(i_counter).operand5_level||'|'||
2841: ecx_utils.g_stage_data(i_counter).operand5_name||'|'||
2834: ecx_utils.g_stage_data(i_counter).operand3_constant||'|'||
2835: ecx_utils.g_stage_data(i_counter).operand4_level||'|'||
2836: ecx_utils.g_stage_data(i_counter).operand4_name||'|'||
2837: ecx_utils.g_stage_data(i_counter).operand4_pos||'|'||
2838: ecx_utils.g_stage_data(i_counter).operand4_direction||'|'||
2839: ecx_utils.g_stage_data(i_counter).operand4_constant||'|'||
2840: ecx_utils.g_stage_data(i_counter).operand5_level||'|'||
2841: ecx_utils.g_stage_data(i_counter).operand5_name||'|'||
2842: ecx_utils.g_stage_data(i_counter).operand5_pos||'|'||
2835: ecx_utils.g_stage_data(i_counter).operand4_level||'|'||
2836: ecx_utils.g_stage_data(i_counter).operand4_name||'|'||
2837: ecx_utils.g_stage_data(i_counter).operand4_pos||'|'||
2838: ecx_utils.g_stage_data(i_counter).operand4_direction||'|'||
2839: ecx_utils.g_stage_data(i_counter).operand4_constant||'|'||
2840: ecx_utils.g_stage_data(i_counter).operand5_level||'|'||
2841: ecx_utils.g_stage_data(i_counter).operand5_name||'|'||
2842: ecx_utils.g_stage_data(i_counter).operand5_pos||'|'||
2843: ecx_utils.g_stage_data(i_counter).operand5_direction||'|'||
2836: ecx_utils.g_stage_data(i_counter).operand4_name||'|'||
2837: ecx_utils.g_stage_data(i_counter).operand4_pos||'|'||
2838: ecx_utils.g_stage_data(i_counter).operand4_direction||'|'||
2839: ecx_utils.g_stage_data(i_counter).operand4_constant||'|'||
2840: ecx_utils.g_stage_data(i_counter).operand5_level||'|'||
2841: ecx_utils.g_stage_data(i_counter).operand5_name||'|'||
2842: ecx_utils.g_stage_data(i_counter).operand5_pos||'|'||
2843: ecx_utils.g_stage_data(i_counter).operand5_direction||'|'||
2844: ecx_utils.g_stage_data(i_counter).operand5_constant||'|'||
2837: ecx_utils.g_stage_data(i_counter).operand4_pos||'|'||
2838: ecx_utils.g_stage_data(i_counter).operand4_direction||'|'||
2839: ecx_utils.g_stage_data(i_counter).operand4_constant||'|'||
2840: ecx_utils.g_stage_data(i_counter).operand5_level||'|'||
2841: ecx_utils.g_stage_data(i_counter).operand5_name||'|'||
2842: ecx_utils.g_stage_data(i_counter).operand5_pos||'|'||
2843: ecx_utils.g_stage_data(i_counter).operand5_direction||'|'||
2844: ecx_utils.g_stage_data(i_counter).operand5_constant||'|'||
2845: ecx_utils.g_stage_data(i_counter).operand6_level||'|'||
2838: ecx_utils.g_stage_data(i_counter).operand4_direction||'|'||
2839: ecx_utils.g_stage_data(i_counter).operand4_constant||'|'||
2840: ecx_utils.g_stage_data(i_counter).operand5_level||'|'||
2841: ecx_utils.g_stage_data(i_counter).operand5_name||'|'||
2842: ecx_utils.g_stage_data(i_counter).operand5_pos||'|'||
2843: ecx_utils.g_stage_data(i_counter).operand5_direction||'|'||
2844: ecx_utils.g_stage_data(i_counter).operand5_constant||'|'||
2845: ecx_utils.g_stage_data(i_counter).operand6_level||'|'||
2846: ecx_utils.g_stage_data(i_counter).operand6_name||'|'||
2839: ecx_utils.g_stage_data(i_counter).operand4_constant||'|'||
2840: ecx_utils.g_stage_data(i_counter).operand5_level||'|'||
2841: ecx_utils.g_stage_data(i_counter).operand5_name||'|'||
2842: ecx_utils.g_stage_data(i_counter).operand5_pos||'|'||
2843: ecx_utils.g_stage_data(i_counter).operand5_direction||'|'||
2844: ecx_utils.g_stage_data(i_counter).operand5_constant||'|'||
2845: ecx_utils.g_stage_data(i_counter).operand6_level||'|'||
2846: ecx_utils.g_stage_data(i_counter).operand6_name||'|'||
2847: ecx_utils.g_stage_data(i_counter).operand6_pos||'|'||
2840: ecx_utils.g_stage_data(i_counter).operand5_level||'|'||
2841: ecx_utils.g_stage_data(i_counter).operand5_name||'|'||
2842: ecx_utils.g_stage_data(i_counter).operand5_pos||'|'||
2843: ecx_utils.g_stage_data(i_counter).operand5_direction||'|'||
2844: ecx_utils.g_stage_data(i_counter).operand5_constant||'|'||
2845: ecx_utils.g_stage_data(i_counter).operand6_level||'|'||
2846: ecx_utils.g_stage_data(i_counter).operand6_name||'|'||
2847: ecx_utils.g_stage_data(i_counter).operand6_pos||'|'||
2848: ecx_utils.g_stage_data(i_counter).operand6_direction||'|'||
2841: ecx_utils.g_stage_data(i_counter).operand5_name||'|'||
2842: ecx_utils.g_stage_data(i_counter).operand5_pos||'|'||
2843: ecx_utils.g_stage_data(i_counter).operand5_direction||'|'||
2844: ecx_utils.g_stage_data(i_counter).operand5_constant||'|'||
2845: ecx_utils.g_stage_data(i_counter).operand6_level||'|'||
2846: ecx_utils.g_stage_data(i_counter).operand6_name||'|'||
2847: ecx_utils.g_stage_data(i_counter).operand6_pos||'|'||
2848: ecx_utils.g_stage_data(i_counter).operand6_direction||'|'||
2849: ecx_utils.g_stage_data(i_counter).operand6_constant,
2842: ecx_utils.g_stage_data(i_counter).operand5_pos||'|'||
2843: ecx_utils.g_stage_data(i_counter).operand5_direction||'|'||
2844: ecx_utils.g_stage_data(i_counter).operand5_constant||'|'||
2845: ecx_utils.g_stage_data(i_counter).operand6_level||'|'||
2846: ecx_utils.g_stage_data(i_counter).operand6_name||'|'||
2847: ecx_utils.g_stage_data(i_counter).operand6_pos||'|'||
2848: ecx_utils.g_stage_data(i_counter).operand6_direction||'|'||
2849: ecx_utils.g_stage_data(i_counter).operand6_constant,
2850: i_method_name
2843: ecx_utils.g_stage_data(i_counter).operand5_direction||'|'||
2844: ecx_utils.g_stage_data(i_counter).operand5_constant||'|'||
2845: ecx_utils.g_stage_data(i_counter).operand6_level||'|'||
2846: ecx_utils.g_stage_data(i_counter).operand6_name||'|'||
2847: ecx_utils.g_stage_data(i_counter).operand6_pos||'|'||
2848: ecx_utils.g_stage_data(i_counter).operand6_direction||'|'||
2849: ecx_utils.g_stage_data(i_counter).operand6_constant,
2850: i_method_name
2851: );
2844: ecx_utils.g_stage_data(i_counter).operand5_constant||'|'||
2845: ecx_utils.g_stage_data(i_counter).operand6_level||'|'||
2846: ecx_utils.g_stage_data(i_counter).operand6_name||'|'||
2847: ecx_utils.g_stage_data(i_counter).operand6_pos||'|'||
2848: ecx_utils.g_stage_data(i_counter).operand6_direction||'|'||
2849: ecx_utils.g_stage_data(i_counter).operand6_constant,
2850: i_method_name
2851: );
2852: end if;
2845: ecx_utils.g_stage_data(i_counter).operand6_level||'|'||
2846: ecx_utils.g_stage_data(i_counter).operand6_name||'|'||
2847: ecx_utils.g_stage_data(i_counter).operand6_pos||'|'||
2848: ecx_utils.g_stage_data(i_counter).operand6_direction||'|'||
2849: ecx_utils.g_stage_data(i_counter).operand6_constant,
2850: i_method_name
2851: );
2852: end if;
2853: i_counter := i_counter + 1;
2857: ecx_debug.pop(i_method_name);
2858: end if;
2859:
2860: EXCEPTION
2861: WHEN ecx_utils.PROGRAM_EXIT then
2862: if (l_procedureEnabled) then
2863: ecx_debug.pop(i_method_name);
2864: end if;
2865: raise;
2866:
2867: WHEN OTHERS THEN
2868: if(l_unexpectedEnabled) then
2869: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', i_method_name, 'PROGRESS_LEVEL',
2870: 'ecx_UTILS.GET_TRAN_STAGE_DATA');
2871: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE', i_method_name,'ERROR_MESSAGE', SQLERRM);
2872: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.GET_TRAN_STAGE_DATA: ',
2873: i_method_name);
2874: end if;
2868: if(l_unexpectedEnabled) then
2869: ecx_debug.log(l_unexpected,'ECX', 'ECX_PROGRAM_ERROR', i_method_name, 'PROGRESS_LEVEL',
2870: 'ecx_UTILS.GET_TRAN_STAGE_DATA');
2871: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE', i_method_name,'ERROR_MESSAGE', SQLERRM);
2872: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.GET_TRAN_STAGE_DATA: ',
2873: i_method_name);
2874: end if;
2875: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.GET_TRAN_STAGE_DATA: ');
2876: if (l_procedureEnabled) then
2871: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE', i_method_name,'ERROR_MESSAGE', SQLERRM);
2872: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.GET_TRAN_STAGE_DATA: ',
2873: i_method_name);
2874: end if;
2875: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.GET_TRAN_STAGE_DATA: ');
2876: if (l_procedureEnabled) then
2877: ecx_debug.pop(i_method_name);
2878: end if;
2879: raise ecx_utils.PROGRAM_EXIT;
2875: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.GET_TRAN_STAGE_DATA: ');
2876: if (l_procedureEnabled) then
2877: ecx_debug.pop(i_method_name);
2878: end if;
2879: raise ecx_utils.PROGRAM_EXIT;
2880:
2881: END get_tran_stage_data;
2882:
2883: procedure getLogDirectory
2881: END get_tran_stage_data;
2882:
2883: procedure getLogDirectory
2884: is
2885: i_method_name varchar2(2000) := 'ecx_utils.getLogDirectory';
2886: i_string varchar2(2000);
2887: begin
2888: --- Check for the Installation Type ( Standalone or Embedded );
2889: ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');
2885: i_method_name varchar2(2000) := 'ecx_utils.getLogDirectory';
2886: i_string varchar2(2000);
2887: begin
2888: --- Check for the Installation Type ( Standalone or Embedded );
2889: ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');
2890:
2891: if ecx_utils.g_install_mode = 'EMBEDDED'
2892: then
2893: i_string := 'begin
2887: begin
2888: --- Check for the Installation Type ( Standalone or Embedded );
2889: ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');
2890:
2891: if ecx_utils.g_install_mode = 'EMBEDDED'
2892: then
2893: i_string := 'begin
2894: fnd_profile.get('||'''ECX_UTL_LOG_DIR'''||',ecx_utils.g_logdir);
2895: end;';
2890:
2891: if ecx_utils.g_install_mode = 'EMBEDDED'
2892: then
2893: i_string := 'begin
2894: fnd_profile.get('||'''ECX_UTL_LOG_DIR'''||',ecx_utils.g_logdir);
2895: end;';
2896: execute immediate i_string ;
2897: else
2898: ecx_utils.g_logdir := wf_core.translate('ECX_UTL_LOG_DIR');
2894: fnd_profile.get('||'''ECX_UTL_LOG_DIR'''||',ecx_utils.g_logdir);
2895: end;';
2896: execute immediate i_string ;
2897: else
2898: ecx_utils.g_logdir := wf_core.translate('ECX_UTL_LOG_DIR');
2899: end if;
2900:
2901:
2902: /* Remove the additional '/' at the end of the profile option if present
2901:
2902: /* Remove the additional '/' at the end of the profile option if present
2903: or else it will cause error in the ecx_debug.print_log */
2904:
2905: If (ecx_utils.g_logdir is not null) then
2906: if (substr(ecx_utils.g_logdir,-1,1) = '/') then
2907: ecx_utils.g_logdir := substr(ecx_utils.g_logdir,1,
2908: length(ecx_utils.g_logdir)-1);
2909: end if;
2902: /* Remove the additional '/' at the end of the profile option if present
2903: or else it will cause error in the ecx_debug.print_log */
2904:
2905: If (ecx_utils.g_logdir is not null) then
2906: if (substr(ecx_utils.g_logdir,-1,1) = '/') then
2907: ecx_utils.g_logdir := substr(ecx_utils.g_logdir,1,
2908: length(ecx_utils.g_logdir)-1);
2909: end if;
2910: End If;
2903: or else it will cause error in the ecx_debug.print_log */
2904:
2905: If (ecx_utils.g_logdir is not null) then
2906: if (substr(ecx_utils.g_logdir,-1,1) = '/') then
2907: ecx_utils.g_logdir := substr(ecx_utils.g_logdir,1,
2908: length(ecx_utils.g_logdir)-1);
2909: end if;
2910: End If;
2911: if(l_statementEnabled) then
2904:
2905: If (ecx_utils.g_logdir is not null) then
2906: if (substr(ecx_utils.g_logdir,-1,1) = '/') then
2907: ecx_utils.g_logdir := substr(ecx_utils.g_logdir,1,
2908: length(ecx_utils.g_logdir)-1);
2909: end if;
2910: End If;
2911: if(l_statementEnabled) then
2912: ecx_debug.log(l_statement, 'ecx_utils.g_logdir',ecx_utils.g_logdir,i_method_name);
2908: length(ecx_utils.g_logdir)-1);
2909: end if;
2910: End If;
2911: if(l_statementEnabled) then
2912: ecx_debug.log(l_statement, 'ecx_utils.g_logdir',ecx_utils.g_logdir,i_method_name);
2913: end if;
2914:
2915: exception
2916: when others then
2913: end if;
2914:
2915: exception
2916: when others then
2917: raise ecx_utils.program_exit;
2918: end getLogDirectory;
2919:
2920: /*
2921: Gets the file separator from the SystemProperty class
2957: p_token10 in varchar2,
2958: p_value10 in varchar2
2959: )
2960: is
2961: i_method_name varchar2(2000) := 'ecx_utils.set_error';
2962: begin
2963:
2964: if (l_procedureEnabled) then
2965: ecx_debug.push(i_method_name);
2994: exception
2995: when others then
2996: if(l_unexpectedEnabled) then
2997: ecx_debug.log(l_unexpected, 'ECX', 'ECX_PROGRAM_ERROR', i_method_name, 'PROGRESS_LEVEL',
2998: 'ECX_UTILS.SET_ERROR',i_method_name);
2999: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM,i_method_name);
3000: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.SET_ERROR: ',
3001: i_method_name);
3002: end if;
2996: if(l_unexpectedEnabled) then
2997: ecx_debug.log(l_unexpected, 'ECX', 'ECX_PROGRAM_ERROR', i_method_name, 'PROGRESS_LEVEL',
2998: 'ECX_UTILS.SET_ERROR',i_method_name);
2999: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM,i_method_name);
3000: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.SET_ERROR: ',
3001: i_method_name);
3002: end if;
3003: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.SET_ERROR: ');
3004: if (l_procedureEnabled) then
2999: ecx_debug.log(l_unexpected, 'ECX', 'ECX_ERROR_MESSAGE', 'ERROR_MESSAGE', SQLERRM,i_method_name);
3000: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.SET_ERROR: ',
3001: i_method_name);
3002: end if;
3003: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.SET_ERROR: ');
3004: if (l_procedureEnabled) then
3005: ecx_debug.pop(i_method_name);
3006: end if;
3007: raise ecx_utils.PROGRAM_EXIT;
3003: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_UTILS.SET_ERROR: ');
3004: if (l_procedureEnabled) then
3005: ecx_debug.pop(i_method_name);
3006: end if;
3007: raise ecx_utils.PROGRAM_EXIT;
3008: end set_error;
3009:
3010: procedure convertPartyTypeToCode(
3011: p_party_type IN Varchar2,
3009:
3010: procedure convertPartyTypeToCode(
3011: p_party_type IN Varchar2,
3012: x_party_type OUT NOCOPY Varchar2) is
3013: i_method_name varchar2(2000) := 'ecx_utils.convertPartyTypeToCode';
3014: begin
3015: if (p_party_type is not null) then
3016: x_party_type := UPPER(p_party_type);
3017: if (x_party_type = 'BANK' or x_party_type = 'B') then
3033: x_party_type := null;
3034: end if;
3035: exception
3036: when others then
3037: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_UTILS.ConvertPartyTypeToCode: ');
3038: if(l_unexpectedEnabled) then
3039: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
3040: end if;
3041: if (l_procedureEnabled) then
3035: exception
3036: when others then
3037: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_UTILS.ConvertPartyTypeToCode: ');
3038: if(l_unexpectedEnabled) then
3039: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
3040: end if;
3041: if (l_procedureEnabled) then
3042: ecx_debug.pop(i_method_name);
3043: end if;
3040: end if;
3041: if (l_procedureEnabled) then
3042: ecx_debug.pop(i_method_name);
3043: end if;
3044: raise ecx_utils.PROGRAM_EXIT;
3045: end convertPartyTypeToCode;
3046:
3047: /* Return the node path of given attribute, from root till it's parent attribute*/
3048: function getNodePath
3048: function getNodePath
3049: (v_map_id IN NUMBER,
3050: v_attribute_id IN NUMBER) return varchar2
3051: IS
3052: i_method_name varchar2(2000) := 'ecx_utils.getNodePath';
3053: l_attribute_name ecx_object_attributes.attribute_name%type;
3054: l_attribute_id ecx_object_attributes.attribute_id%type;
3055: l_node_path varchar2(32767);
3056: l_parent_name ecx_object_attributes.attribute_name%type;
3105: end if;
3106: return l_node_path;
3107: exception
3108: when others then
3109: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_UTILS.getNodePath ');
3110: if(l_unexpectedEnabled) then
3111: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
3112: end if;
3113: if (l_procedureEnabled) then
3107: exception
3108: when others then
3109: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_UTILS.getNodePath ');
3110: if(l_unexpectedEnabled) then
3111: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
3112: end if;
3113: if (l_procedureEnabled) then
3114: ecx_debug.pop(i_method_name);
3115: end if;
3112: end if;
3113: if (l_procedureEnabled) then
3114: ecx_debug.pop(i_method_name);
3115: end if;
3116: raise ecx_utils.PROGRAM_EXIT;
3117: End getNodePath;
3118:
3119: /*get XML Parser version*/
3120:
3122: return varchar2
3123: is language java name 'oracle.xml.parser.v2.XMLParser.getReleaseVersion() returns java.lang.String';
3124:
3125:
3126: end ecx_utils;