eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_RX_PUBLISH dependencies on DBMS_SQL

Line 352: c := dbms_sql.open_cursor;

348: --
349: -- Per instructions from bug 1082862, FIRST_ROWS hint has been taken out.
350: sqlstmt := 'SELECT ORGANIZATION_NAME, FUNCTIONAL_CURRENCY_CODE '||NEWLINE||
351: Get_From_Clause||NEWLINE||get_where_clause;
352: c := dbms_sql.open_cursor;
353: IF (g_print_debug) THEN
354: fa_rx_util_pkg.debug('is_multi_format_report: ' || sqlstmt);
355: END IF;
356: fa_rx_util_pkg.debug('Parsing statement : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));

Line 357: dbms_sql.parse(c, sqlstmt, dbms_sql.native);

353: IF (g_print_debug) THEN
354: fa_rx_util_pkg.debug('is_multi_format_report: ' || sqlstmt);
355: END IF;
356: fa_rx_util_pkg.debug('Parsing statement : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
357: dbms_sql.parse(c, sqlstmt, dbms_sql.native);
358: IF (g_print_debug) THEN
359: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Binding statement');
360: END IF;
361: bind_variables(c);

Line 363: dbms_sql.define_column(c, 1, m_report.set_of_books_name, 100);

359: fa_rx_util_pkg.debug('is_multi_format_report: ' || 'Binding statement');
360: END IF;
361: bind_variables(c);
362: fa_rx_util_pkg.debug('Defining columns : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
363: dbms_sql.define_column(c, 1, m_report.set_of_books_name, 100);
364: dbms_sql.define_column(c, 2, m_report.functional_currency, 100);
365: fa_rx_util_pkg.debug('Executing : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
366: rows := dbms_sql.execute(c);
367: fa_rx_util_pkg.debug('Fetching : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));

Line 364: dbms_sql.define_column(c, 2, m_report.functional_currency, 100);

360: END IF;
361: bind_variables(c);
362: fa_rx_util_pkg.debug('Defining columns : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
363: dbms_sql.define_column(c, 1, m_report.set_of_books_name, 100);
364: dbms_sql.define_column(c, 2, m_report.functional_currency, 100);
365: fa_rx_util_pkg.debug('Executing : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
366: rows := dbms_sql.execute(c);
367: fa_rx_util_pkg.debug('Fetching : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
368: rows := dbms_sql.fetch_rows(c);

Line 366: rows := dbms_sql.execute(c);

362: fa_rx_util_pkg.debug('Defining columns : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
363: dbms_sql.define_column(c, 1, m_report.set_of_books_name, 100);
364: dbms_sql.define_column(c, 2, m_report.functional_currency, 100);
365: fa_rx_util_pkg.debug('Executing : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
366: rows := dbms_sql.execute(c);
367: fa_rx_util_pkg.debug('Fetching : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
368: rows := dbms_sql.fetch_rows(c);
369: fa_rx_util_pkg.debug('Got '||To_char(rows)||' row(s) : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
370: if rows = 0 then

Line 368: rows := dbms_sql.fetch_rows(c);

364: dbms_sql.define_column(c, 2, m_report.functional_currency, 100);
365: fa_rx_util_pkg.debug('Executing : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
366: rows := dbms_sql.execute(c);
367: fa_rx_util_pkg.debug('Fetching : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
368: rows := dbms_sql.fetch_rows(c);
369: fa_rx_util_pkg.debug('Got '||To_char(rows)||' row(s) : '||To_char(Sysdate, 'YY/MM/DD HH24:MI:SS'));
370: if rows = 0 then
371: --
372: -- The column did not exist in the database

Line 386: dbms_sql.column_value(c, 1, m_report.set_of_books_name);

382: m_report.functional_currency := null;
383:
384: else
385:
386: dbms_sql.column_value(c, 1, m_report.set_of_books_name);
387: dbms_sql.column_value(c, 2, m_report.functional_currency);
388:
389: end if;
390: dbms_sql.close_cursor(c);

Line 387: dbms_sql.column_value(c, 2, m_report.functional_currency);

383:
384: else
385:
386: dbms_sql.column_value(c, 1, m_report.set_of_books_name);
387: dbms_sql.column_value(c, 2, m_report.functional_currency);
388:
389: end if;
390: dbms_sql.close_cursor(c);
391:

Line 390: dbms_sql.close_cursor(c);

386: dbms_sql.column_value(c, 1, m_report.set_of_books_name);
387: dbms_sql.column_value(c, 2, m_report.functional_currency);
388:
389: end if;
390: dbms_sql.close_cursor(c);
391:
392: exception
393: when others then
394: -- no set of books

Line 405: if dbms_sql.is_open(c) then

401: m_report.display_functional_currency := 'N';
402: m_report.set_of_books_name := null;
403: m_report.functional_currency := null;
404:
405: if dbms_sql.is_open(c) then
406: dbms_sql.close_cursor(c);
407: end if;
408: return;
409: end populate_sob;

Line 406: dbms_sql.close_cursor(c);

402: m_report.set_of_books_name := null;
403: m_report.functional_currency := null;
404:
405: if dbms_sql.is_open(c) then
406: dbms_sql.close_cursor(c);
407: end if;
408: return;
409: end populate_sob;
410:

Line 1037: c := dbms_sql.open_cursor;

1033: END IF;
1034:
1035: --
1036: -- Get the parameter values
1037: c := dbms_sql.open_cursor;
1038: dbms_sql.parse(c, sqlstmt, dbms_sql.native);
1039: dbms_sql.bind_variable(c, ':b_request_id', p_request_id); /* bug 2276534, rravunny */
1040: for idx in 1..m_param_count loop
1041: dbms_sql.define_column(c, idx, m_params(idx).value, 240);

Line 1038: dbms_sql.parse(c, sqlstmt, dbms_sql.native);

1034:
1035: --
1036: -- Get the parameter values
1037: c := dbms_sql.open_cursor;
1038: dbms_sql.parse(c, sqlstmt, dbms_sql.native);
1039: dbms_sql.bind_variable(c, ':b_request_id', p_request_id); /* bug 2276534, rravunny */
1040: for idx in 1..m_param_count loop
1041: dbms_sql.define_column(c, idx, m_params(idx).value, 240);
1042: end loop;

Line 1039: dbms_sql.bind_variable(c, ':b_request_id', p_request_id); /* bug 2276534, rravunny */

1035: --
1036: -- Get the parameter values
1037: c := dbms_sql.open_cursor;
1038: dbms_sql.parse(c, sqlstmt, dbms_sql.native);
1039: dbms_sql.bind_variable(c, ':b_request_id', p_request_id); /* bug 2276534, rravunny */
1040: for idx in 1..m_param_count loop
1041: dbms_sql.define_column(c, idx, m_params(idx).value, 240);
1042: end loop;
1043: rows := dbms_sql.execute(c);

Line 1041: dbms_sql.define_column(c, idx, m_params(idx).value, 240);

1037: c := dbms_sql.open_cursor;
1038: dbms_sql.parse(c, sqlstmt, dbms_sql.native);
1039: dbms_sql.bind_variable(c, ':b_request_id', p_request_id); /* bug 2276534, rravunny */
1040: for idx in 1..m_param_count loop
1041: dbms_sql.define_column(c, idx, m_params(idx).value, 240);
1042: end loop;
1043: rows := dbms_sql.execute(c);
1044: rows := dbms_sql.fetch_rows(c);
1045: if rows = 0 then raise no_data_found;

Line 1043: rows := dbms_sql.execute(c);

1039: dbms_sql.bind_variable(c, ':b_request_id', p_request_id); /* bug 2276534, rravunny */
1040: for idx in 1..m_param_count loop
1041: dbms_sql.define_column(c, idx, m_params(idx).value, 240);
1042: end loop;
1043: rows := dbms_sql.execute(c);
1044: rows := dbms_sql.fetch_rows(c);
1045: if rows = 0 then raise no_data_found;
1046: end if;
1047: for idx in 1..m_param_count loop

Line 1044: rows := dbms_sql.fetch_rows(c);

1040: for idx in 1..m_param_count loop
1041: dbms_sql.define_column(c, idx, m_params(idx).value, 240);
1042: end loop;
1043: rows := dbms_sql.execute(c);
1044: rows := dbms_sql.fetch_rows(c);
1045: if rows = 0 then raise no_data_found;
1046: end if;
1047: for idx in 1..m_param_count loop
1048: dbms_sql.column_value(c, idx, m_params(idx).value);

Line 1048: dbms_sql.column_value(c, idx, m_params(idx).value);

1044: rows := dbms_sql.fetch_rows(c);
1045: if rows = 0 then raise no_data_found;
1046: end if;
1047: for idx in 1..m_param_count loop
1048: dbms_sql.column_value(c, idx, m_params(idx).value);
1049: end loop;
1050: dbms_sql.close_cursor(c);
1051:
1052: m_params_with_actual_value := m_params;

Line 1050: dbms_sql.close_cursor(c);

1046: end if;
1047: for idx in 1..m_param_count loop
1048: dbms_sql.column_value(c, idx, m_params(idx).value);
1049: end loop;
1050: dbms_sql.close_cursor(c);
1051:
1052: m_params_with_actual_value := m_params;
1053:
1054: --

Line 2397: l_cursor := dbms_sql.open_cursor;

2393: get_from_clause||NEWLINE||
2394: tmp_where_clause||NEWLINE||
2395: get_order_by_clause;
2396: BEGIN
2397: l_cursor := dbms_sql.open_cursor;
2398:
2399: IF (g_print_debug) THEN
2400: arp_util_tax.debug('BEGIN '||rtrim(ltrim(sqlstmt))||'; END;');
2401: END IF;

Line 2403: dbms_sql.parse(l_cursor,

2399: IF (g_print_debug) THEN
2400: arp_util_tax.debug('BEGIN '||rtrim(ltrim(sqlstmt))||'; END;');
2401: END IF;
2402:
2403: dbms_sql.parse(l_cursor,
2404: 'BEGIN '||rtrim(ltrim(sqlstmt))||'; END;', dbms_sql.native);
2405: dbms_sql.close_cursor(l_cursor);
2406:
2407: EXCEPTION

Line 2404: 'BEGIN '||rtrim(ltrim(sqlstmt))||'; END;', dbms_sql.native);

2400: arp_util_tax.debug('BEGIN '||rtrim(ltrim(sqlstmt))||'; END;');
2401: END IF;
2402:
2403: dbms_sql.parse(l_cursor,
2404: 'BEGIN '||rtrim(ltrim(sqlstmt))||'; END;', dbms_sql.native);
2405: dbms_sql.close_cursor(l_cursor);
2406:
2407: EXCEPTION
2408: WHEN OTHERS THEN

Line 2405: dbms_sql.close_cursor(l_cursor);

2401: END IF;
2402:
2403: dbms_sql.parse(l_cursor,
2404: 'BEGIN '||rtrim(ltrim(sqlstmt))||'; END;', dbms_sql.native);
2405: dbms_sql.close_cursor(l_cursor);
2406:
2407: EXCEPTION
2408: WHEN OTHERS THEN
2409: IF (g_print_debug) THEN

Line 2500: c := dbms_sql.open_cursor;

2496: '||sqlstmt||'
2497: ');
2498: END IF;
2499:
2500: c := dbms_sql.open_cursor;
2501: begin
2502: dbms_sql.parse(c, sqlstmt, dbms_sql.native);
2503: exception
2504: when invalid_result_columns then

Line 2502: dbms_sql.parse(c, sqlstmt, dbms_sql.native);

2498: END IF;
2499:
2500: c := dbms_sql.open_cursor;
2501: begin
2502: dbms_sql.parse(c, sqlstmt, dbms_sql.native);
2503: exception
2504: when invalid_result_columns then
2505: IF (g_print_debug) THEN
2506: fa_rx_util_pkg.debug('Expand_Complex_Multiformat: ' || 'Cannot use complex mode for these sets of reports');

Line 2512: dbms_sql.define_column(c, idx, buf, 400);

2508: fnd_message.set_name('OFA', 'FA_RX_INVALID_USE_OF_COMPLEX');
2509: app_exception.raise_exception;
2510: end;
2511: for idx in 1..numcols loop
2512: dbms_sql.define_column(c, idx, buf, 400);
2513: end loop;
2514: rows := dbms_sql.execute(c);
2515: loop
2516: rows := dbms_sql.fetch_rows(c);

Line 2514: rows := dbms_sql.execute(c);

2510: end;
2511: for idx in 1..numcols loop
2512: dbms_sql.define_column(c, idx, buf, 400);
2513: end loop;
2514: rows := dbms_sql.execute(c);
2515: loop
2516: rows := dbms_sql.fetch_rows(c);
2517: exit when rows = 0 ;
2518:

Line 2516: rows := dbms_sql.fetch_rows(c);

2512: dbms_sql.define_column(c, idx, buf, 400);
2513: end loop;
2514: rows := dbms_sql.execute(c);
2515: loop
2516: rows := dbms_sql.fetch_rows(c);
2517: exit when rows = 0 ;
2518:
2519: for idx in 1..p_count loop
2520: m_format_count := m_format_count + 1;

Line 2527: dbms_sql.column_value(c, colidx, buf);

2523:
2524: colidx := 0;
2525: for crow in cols(p_formats(idx).report_id, p_formats(idx).attribute_set) loop
2526: colidx := colidx + 1;
2527: dbms_sql.column_value(c, colidx, buf);
2528:
2529: if crow.display_format = 'VARCHAR2' then
2530: where_clause := where_clause || sep ||
2531: crow.column_name ||' = '''||buf||'''';

Line 2552: dbms_sql.close_cursor(c);

2548: END IF;
2549: end loop;
2550: end loop;
2551:
2552: dbms_sql.close_cursor(c);
2553: end expand_complex_multiformat;
2554:
2555:
2556:

Line 2705: dbms_sql.bind_variable(c, ':b'||To_char(i), v);

2701: v := get_bind_variable;
2702: IF (g_print_debug) THEN
2703: fa_rx_util_pkg.debug('bind_variables: ' || 'Bind :b'||To_char(i)||' => '||v);
2704: END IF;
2705: dbms_sql.bind_variable(c, ':b'||To_char(i), v);
2706: END LOOP;
2707: END bind_variables;
2708:
2709: PROCEDURE get_rows_purged(request_id IN VARCHAR2, l_report_id IN NUMBER,