APPS.BSC_UTILITY dependencies on DBMS_SQL

Line 259: h_handle := dbms_sql.open_cursor;

255: BEGIN
256:
257: bsc_utility.print_debug('SQL stmt: '||x_sql_stmt);
258:
259: h_handle := dbms_sql.open_cursor;
260: dbms_sql.parse(h_handle, x_sql_stmt, dbms_sql.native);
261: h_ignore := dbms_sql.execute(h_handle);
262:
263: RETURN(h_handle);

Line 260: dbms_sql.parse(h_handle, x_sql_stmt, dbms_sql.native);

256:
257: bsc_utility.print_debug('SQL stmt: '||x_sql_stmt);
258:
259: h_handle := dbms_sql.open_cursor;
260: dbms_sql.parse(h_handle, x_sql_stmt, dbms_sql.native);
261: h_ignore := dbms_sql.execute(h_handle);
262:
263: RETURN(h_handle);
264:

Line 261: h_ignore := dbms_sql.execute(h_handle);

257: bsc_utility.print_debug('SQL stmt: '||x_sql_stmt);
258:
259: h_handle := dbms_sql.open_cursor;
260: dbms_sql.parse(h_handle, x_sql_stmt, dbms_sql.native);
261: h_ignore := dbms_sql.execute(h_handle);
262:
263: RETURN(h_handle);
264:
265: END exec_dynamic_sql;

Line 271: IF( dbms_sql.is_open( p_cursor_handle ) ) THEN

267:
268: PROCEDURE close_cursor( p_cursor_handle IN OUT NOCOPY NUMBER ) IS
269: BEGIN
270:
271: IF( dbms_sql.is_open( p_cursor_handle ) ) THEN
272:
273: dbms_sql.close_cursor( p_cursor_handle );
274:
275: END IF;

Line 273: dbms_sql.close_cursor( p_cursor_handle );

269: BEGIN
270:
271: IF( dbms_sql.is_open( p_cursor_handle ) ) THEN
272:
273: dbms_sql.close_cursor( p_cursor_handle );
274:
275: END IF;
276:
277: EXCEPTION

Line 300: h_handle := dbms_sql.open_cursor;

296: h_handle NUMBER;
297: h_ignore NUMBER;
298: Begin
299:
300: h_handle := dbms_sql.open_cursor;
301:
302: dbms_sql.parse(h_handle, x_sql_stmt, dbms_sql.native);
303:
304: h_ignore := dbms_sql.execute(h_handle);

Line 302: dbms_sql.parse(h_handle, x_sql_stmt, dbms_sql.native);

298: Begin
299:
300: h_handle := dbms_sql.open_cursor;
301:
302: dbms_sql.parse(h_handle, x_sql_stmt, dbms_sql.native);
303:
304: h_ignore := dbms_sql.execute(h_handle);
305:
306: dbms_sql.close_cursor(h_handle);

Line 304: h_ignore := dbms_sql.execute(h_handle);

300: h_handle := dbms_sql.open_cursor;
301:
302: dbms_sql.parse(h_handle, x_sql_stmt, dbms_sql.native);
303:
304: h_ignore := dbms_sql.execute(h_handle);
305:
306: dbms_sql.close_cursor(h_handle);
307:
308: Exception

Line 306: dbms_sql.close_cursor(h_handle);

302: dbms_sql.parse(h_handle, x_sql_stmt, dbms_sql.native);
303:
304: h_ignore := dbms_sql.execute(h_handle);
305:
306: dbms_sql.close_cursor(h_handle);
307:
308: Exception
309: When Others Then
310:

Line 322: if (dbms_sql.is_open(h_handle)) then

318: x_debug_msg => x_sql_stmt,
319: x_mode => 'I'
320: );
321:
322: if (dbms_sql.is_open(h_handle)) then
323: dbms_sql.close_cursor(h_handle);
324: end if;
325:
326: End Do_SQL;

Line 323: dbms_sql.close_cursor(h_handle);

319: x_mode => 'I'
320: );
321:
322: if (dbms_sql.is_open(h_handle)) then
323: dbms_sql.close_cursor(h_handle);
324: end if;
325:
326: End Do_SQL;
327: