APPS.ECX_UTILS dependencies on DBMS_SQL

Line 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);

Line 159: dbms_sql.parse (

155: end if;
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: );

Line 162: dbms_sql.native

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
166: ecx_error_handling_pvt.print_parse_error

Line 168: dbms_sql.last_error_position,

164: EXCEPTION
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:

Line 191: dbms_sql.define_column

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,
195: ecx_utils.g_source_levels(i).sql_stmt,

Line 199: dbms_sql.define_column

195: ecx_utils.g_source_levels(i).sql_stmt,
196: ecx_utils.G_VARCHAR_LEN
197: );
198: else
199: dbms_sql.define_column
200: (
201: ecx_utils.g_source_levels(i).Cursor_Handle,
202: i_counter,
203: l_clob

Line 443: x_proc_cursor := dbms_sql.open_cursor;

439: end loop;
440: if(l_statementEnabled) then
441: ecx_debug.log(l_statement, 'proc_call', l_proc_call,i_method_name);
442: end if;
443: x_proc_cursor := dbms_sql.open_cursor;
444: BEGIN
445: dbms_sql.parse (x_proc_cursor, l_proc_call, dbms_sql.native);
446: EXCEPTION
447: when others then

Line 445: dbms_sql.parse (x_proc_cursor, l_proc_call, dbms_sql.native);

441: ecx_debug.log(l_statement, 'proc_call', l_proc_call,i_method_name);
442: end if;
443: x_proc_cursor := dbms_sql.open_cursor;
444: BEGIN
445: dbms_sql.parse (x_proc_cursor, l_proc_call, dbms_sql.native);
446: EXCEPTION
447: when others then
448: raise parse_error;
449: END;

Line 458: error_position := dbms_sql.last_error_position;

454: ecx_debug.pop(i_method_name);
455: end if;
456: EXCEPTION
457: WHEN PARSE_ERROR then
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');

Line 1990: dbms_sql.close_cursor(g_source_levels(i).cursor_handle);

1986: if (g_source_levels(i).cursor_handle is not null ) and
1987: (not closed_cursors.EXISTS( g_source_levels(i).cursor_handle) )
1988: then
1989: closed_cursors( g_source_levels(i).cursor_handle ) := -1 ;
1990: dbms_sql.close_cursor(g_source_levels(i).cursor_handle);
1991: end if;
1992: end loop;
1993: end if;
1994:

Line 2003: dbms_sql.close_cursor(g_target_levels(i).cursor_handle);

1999: if (g_target_levels(i).cursor_handle is not null ) and
2000: (not closed_cursors.EXISTS (g_target_levels(i).cursor_handle) )
2001: then
2002: closed_cursors( g_target_levels(i).cursor_handle ) := -1;
2003: dbms_sql.close_cursor(g_target_levels(i).cursor_handle);
2004: end if;
2005: end loop;
2006: end if;
2007:

Line 2016: dbms_sql.close_cursor(ecx_utils.g_procedure_list(j).cursor_handle);

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;