APPS.BSC_DB_MEASURE_COLS_PKG dependencies on DBMS_SQL

Line 220: l_cursor := dbms_sql.open_cursor;

216: end loop;
217:
218: if (l_valid) then
219: -- Parse to check if it's not a reserved word
220: l_cursor := dbms_sql.open_cursor;
221: dbms_sql.parse(l_cursor, 'select null ' || p_measure_col || ' from dual', dbms_sql.native);
222: dbms_sql.close_cursor(l_cursor);
223: end if;
224:

Line 221: dbms_sql.parse(l_cursor, 'select null ' || p_measure_col || ' from dual', dbms_sql.native);

217:
218: if (l_valid) then
219: -- Parse to check if it's not a reserved word
220: l_cursor := dbms_sql.open_cursor;
221: dbms_sql.parse(l_cursor, 'select null ' || p_measure_col || ' from dual', dbms_sql.native);
222: dbms_sql.close_cursor(l_cursor);
223: end if;
224:
225: end if;

Line 222: dbms_sql.close_cursor(l_cursor);

218: if (l_valid) then
219: -- Parse to check if it's not a reserved word
220: l_cursor := dbms_sql.open_cursor;
221: dbms_sql.parse(l_cursor, 'select null ' || p_measure_col || ' from dual', dbms_sql.native);
222: dbms_sql.close_cursor(l_cursor);
223: end if;
224:
225: end if;
226: