APPS.GL_RX_TRIAL_BALANCE_PKG dependencies on DBMS_SQL

Line 330: l_dyn_cursor := dbms_sql.open_cursor;

326: END IF;
327: --
328: -- execute the dynamic sql
329: --
330: l_dyn_cursor := dbms_sql.open_cursor;
331: dbms_sql.parse(l_dyn_cursor, l_dyn_stmt, dbms_sql.native);
332: l_dyn_rows := dbms_sql.execute(l_dyn_cursor);
333: dbms_sql.close_cursor(l_dyn_cursor);
334: IF (debug_mode = 'Y') THEN

Line 331: dbms_sql.parse(l_dyn_cursor, l_dyn_stmt, dbms_sql.native);

327: --
328: -- execute the dynamic sql
329: --
330: l_dyn_cursor := dbms_sql.open_cursor;
331: dbms_sql.parse(l_dyn_cursor, l_dyn_stmt, dbms_sql.native);
332: l_dyn_rows := dbms_sql.execute(l_dyn_cursor);
333: dbms_sql.close_cursor(l_dyn_cursor);
334: IF (debug_mode = 'Y') THEN
335: -- dbms_output.put_line('Done with the main cursor');

Line 332: l_dyn_rows := dbms_sql.execute(l_dyn_cursor);

328: -- execute the dynamic sql
329: --
330: l_dyn_cursor := dbms_sql.open_cursor;
331: dbms_sql.parse(l_dyn_cursor, l_dyn_stmt, dbms_sql.native);
332: l_dyn_rows := dbms_sql.execute(l_dyn_cursor);
333: dbms_sql.close_cursor(l_dyn_cursor);
334: IF (debug_mode = 'Y') THEN
335: -- dbms_output.put_line('Done with the main cursor');
336: NULL;

Line 333: dbms_sql.close_cursor(l_dyn_cursor);

329: --
330: l_dyn_cursor := dbms_sql.open_cursor;
331: dbms_sql.parse(l_dyn_cursor, l_dyn_stmt, dbms_sql.native);
332: l_dyn_rows := dbms_sql.execute(l_dyn_cursor);
333: dbms_sql.close_cursor(l_dyn_cursor);
334: IF (debug_mode = 'Y') THEN
335: -- dbms_output.put_line('Done with the main cursor');
336: NULL;
337: END IF;