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 353: c := dbms_sql.open_cursor;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 391: dbms_sql.close_cursor(c);

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

Line 406: if dbms_sql.is_open(c) then

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

Line 407: dbms_sql.close_cursor(c);

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

Line 1032: c := dbms_sql.open_cursor;

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

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

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

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

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

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

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

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

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

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

1035: for idx in 1..m_param_count loop
1036: dbms_sql.define_column(c, idx, m_params(idx).value, 240);
1037: end loop;
1038: rows := dbms_sql.execute(c);
1039: rows := dbms_sql.fetch_rows(c);
1040: if rows = 0 then raise no_data_found;
1041: end if;
1042: for idx in 1..m_param_count loop
1043: dbms_sql.column_value(c, idx, m_params(idx).value);

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

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

Line 1045: dbms_sql.close_cursor(c);

1041: end if;
1042: for idx in 1..m_param_count loop
1043: dbms_sql.column_value(c, idx, m_params(idx).value);
1044: end loop;
1045: dbms_sql.close_cursor(c);
1046:
1047: m_params_with_actual_value := m_params;
1048: --
1049: -- Try to reformat date values

Line 2329: l_cursor := dbms_sql.open_cursor;

2325: get_from_clause||NEWLINE||
2326: tmp_where_clause||NEWLINE||
2327: get_order_by_clause;
2328: BEGIN
2329: l_cursor := dbms_sql.open_cursor;
2330:
2331: IF (g_print_debug) THEN
2332: arp_util_tax.debug('BEGIN '||rtrim(ltrim(sqlstmt))||'; END;');
2333: END IF;

Line 2335: dbms_sql.parse(l_cursor,

2331: IF (g_print_debug) THEN
2332: arp_util_tax.debug('BEGIN '||rtrim(ltrim(sqlstmt))||'; END;');
2333: END IF;
2334:
2335: dbms_sql.parse(l_cursor,
2336: 'BEGIN '||rtrim(ltrim(sqlstmt))||'; END;', dbms_sql.native);
2337: dbms_sql.close_cursor(l_cursor);
2338:
2339: EXCEPTION

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

2332: arp_util_tax.debug('BEGIN '||rtrim(ltrim(sqlstmt))||'; END;');
2333: END IF;
2334:
2335: dbms_sql.parse(l_cursor,
2336: 'BEGIN '||rtrim(ltrim(sqlstmt))||'; END;', dbms_sql.native);
2337: dbms_sql.close_cursor(l_cursor);
2338:
2339: EXCEPTION
2340: WHEN OTHERS THEN

Line 2337: dbms_sql.close_cursor(l_cursor);

2333: END IF;
2334:
2335: dbms_sql.parse(l_cursor,
2336: 'BEGIN '||rtrim(ltrim(sqlstmt))||'; END;', dbms_sql.native);
2337: dbms_sql.close_cursor(l_cursor);
2338:
2339: EXCEPTION
2340: WHEN OTHERS THEN
2341: IF (g_print_debug) THEN

Line 2432: c := dbms_sql.open_cursor;

2428: '||sqlstmt||'
2429: ');
2430: END IF;
2431:
2432: c := dbms_sql.open_cursor;
2433: begin
2434: dbms_sql.parse(c, sqlstmt, dbms_sql.native);
2435: exception
2436: when invalid_result_columns then

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

2430: END IF;
2431:
2432: c := dbms_sql.open_cursor;
2433: begin
2434: dbms_sql.parse(c, sqlstmt, dbms_sql.native);
2435: exception
2436: when invalid_result_columns then
2437: IF (g_print_debug) THEN
2438: fa_rx_util_pkg.debug('Expand_Complex_Multiformat: ' || 'Cannot use complex mode for these sets of reports');

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

2440: fnd_message.set_name('OFA', 'FA_RX_INVALID_USE_OF_COMPLEX');
2441: app_exception.raise_exception;
2442: end;
2443: for idx in 1..numcols loop
2444: dbms_sql.define_column(c, idx, buf, 400);
2445: end loop;
2446: rows := dbms_sql.execute(c);
2447: loop
2448: rows := dbms_sql.fetch_rows(c);

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

2442: end;
2443: for idx in 1..numcols loop
2444: dbms_sql.define_column(c, idx, buf, 400);
2445: end loop;
2446: rows := dbms_sql.execute(c);
2447: loop
2448: rows := dbms_sql.fetch_rows(c);
2449: exit when rows = 0 ;
2450:

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

2444: dbms_sql.define_column(c, idx, buf, 400);
2445: end loop;
2446: rows := dbms_sql.execute(c);
2447: loop
2448: rows := dbms_sql.fetch_rows(c);
2449: exit when rows = 0 ;
2450:
2451: for idx in 1..p_count loop
2452: m_format_count := m_format_count + 1;

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

2455:
2456: colidx := 0;
2457: for crow in cols(p_formats(idx).report_id, p_formats(idx).attribute_set) loop
2458: colidx := colidx + 1;
2459: dbms_sql.column_value(c, colidx, buf);
2460:
2461: if crow.display_format = 'VARCHAR2' then
2462: where_clause := where_clause || sep ||
2463: crow.column_name ||' = '''||buf||'''';

Line 2484: dbms_sql.close_cursor(c);

2480: END IF;
2481: end loop;
2482: end loop;
2483:
2484: dbms_sql.close_cursor(c);
2485: end expand_complex_multiformat;
2486:
2487:
2488:

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

2633: v := get_bind_variable;
2634: IF (g_print_debug) THEN
2635: fa_rx_util_pkg.debug('bind_variables: ' || 'Bind :b'||To_char(i)||' => '||v);
2636: END IF;
2637: dbms_sql.bind_variable(c, ':b'||To_char(i), v);
2638: END LOOP;
2639: END bind_variables;
2640:
2641: PROCEDURE get_rows_purged(request_id IN VARCHAR2, l_report_id IN NUMBER,