APPS.JTF_DIAG_REPORT_FACTORY dependencies on DBMS_SQL

Line 238: columns_describe dbms_sql.desc_tab;

234:
235: FUNCTION GET_COLUMN_NAMES(sql_query VARCHAR2) RETURN JTF_VARCHAR2_TABLE_4000
236: IS
237: cursor_id number;
238: columns_describe dbms_sql.desc_tab;
239: column_count number;
240: loop_counter number;
241: column_headers JTF_VARCHAR2_TABLE_4000;
242: BEGIN

Line 244: cursor_id := DBMS_SQL.OPEN_CURSOR;

240: loop_counter number;
241: column_headers JTF_VARCHAR2_TABLE_4000;
242: BEGIN
243: column_headers := JTF_VARCHAR2_TABLE_4000();
244: cursor_id := DBMS_SQL.OPEN_CURSOR;
245: DBMS_SQL.PARSE(cursor_id, sql_query, DBMS_SQL.V7);
246: DBMS_SQL.DESCRIBE_COLUMNS(cursor_id, column_count, columns_describe);
247: FOR loop_counter in 1..column_count
248: LOOP

Line 245: DBMS_SQL.PARSE(cursor_id, sql_query, DBMS_SQL.V7);

241: column_headers JTF_VARCHAR2_TABLE_4000;
242: BEGIN
243: column_headers := JTF_VARCHAR2_TABLE_4000();
244: cursor_id := DBMS_SQL.OPEN_CURSOR;
245: DBMS_SQL.PARSE(cursor_id, sql_query, DBMS_SQL.V7);
246: DBMS_SQL.DESCRIBE_COLUMNS(cursor_id, column_count, columns_describe);
247: FOR loop_counter in 1..column_count
248: LOOP
249: column_headers.extend(1);

Line 246: DBMS_SQL.DESCRIBE_COLUMNS(cursor_id, column_count, columns_describe);

242: BEGIN
243: column_headers := JTF_VARCHAR2_TABLE_4000();
244: cursor_id := DBMS_SQL.OPEN_CURSOR;
245: DBMS_SQL.PARSE(cursor_id, sql_query, DBMS_SQL.V7);
246: DBMS_SQL.DESCRIBE_COLUMNS(cursor_id, column_count, columns_describe);
247: FOR loop_counter in 1..column_count
248: LOOP
249: column_headers.extend(1);
250: column_headers(column_headers.count) := columns_describe(loop_counter).col_name;

Line 252: DBMS_SQL.CLOSE_CURSOR(cursor_id);

248: LOOP
249: column_headers.extend(1);
250: column_headers(column_headers.count) := columns_describe(loop_counter).col_name;
251: END LOOP;
252: DBMS_SQL.CLOSE_CURSOR(cursor_id);
253: RETURN column_headers;
254: END GET_COLUMN_NAMES;
255:
256: