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_FLEX_PKG dependencies on DBMS_SQL

Line 735: c := dbms_sql.open_cursor;

731:
732: --
733: -- We have the SELECT statement.
734: -- Now execute it.
735: c := dbms_sql.open_cursor;
736: dbms_sql.parse(c, sqlstmt, dbms_sql.native);
737: dbms_sql.bind_variable(c, 'ccid', p_ccid);
738: dbms_sql.define_column(c, 1, buffer, 2000);
739: rows := dbms_sql.execute(c);

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

732: --
733: -- We have the SELECT statement.
734: -- Now execute it.
735: c := dbms_sql.open_cursor;
736: dbms_sql.parse(c, sqlstmt, dbms_sql.native);
737: dbms_sql.bind_variable(c, 'ccid', p_ccid);
738: dbms_sql.define_column(c, 1, buffer, 2000);
739: rows := dbms_sql.execute(c);
740: rows := dbms_sql.fetch_rows(c);

Line 737: dbms_sql.bind_variable(c, 'ccid', p_ccid);

733: -- We have the SELECT statement.
734: -- Now execute it.
735: c := dbms_sql.open_cursor;
736: dbms_sql.parse(c, sqlstmt, dbms_sql.native);
737: dbms_sql.bind_variable(c, 'ccid', p_ccid);
738: dbms_sql.define_column(c, 1, buffer, 2000);
739: rows := dbms_sql.execute(c);
740: rows := dbms_sql.fetch_rows(c);
741: if rows <= 0 then

Line 738: dbms_sql.define_column(c, 1, buffer, 2000);

734: -- Now execute it.
735: c := dbms_sql.open_cursor;
736: dbms_sql.parse(c, sqlstmt, dbms_sql.native);
737: dbms_sql.bind_variable(c, 'ccid', p_ccid);
738: dbms_sql.define_column(c, 1, buffer, 2000);
739: rows := dbms_sql.execute(c);
740: rows := dbms_sql.fetch_rows(c);
741: if rows <= 0 then
742: IF (g_print_debug) THEN

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

735: c := dbms_sql.open_cursor;
736: dbms_sql.parse(c, sqlstmt, dbms_sql.native);
737: dbms_sql.bind_variable(c, 'ccid', p_ccid);
738: dbms_sql.define_column(c, 1, buffer, 2000);
739: rows := dbms_sql.execute(c);
740: rows := dbms_sql.fetch_rows(c);
741: if rows <= 0 then
742: IF (g_print_debug) THEN
743: fa_rx_util_pkg.debug('Invalid CCID in fa_rx_flex_pkg.get_value()');

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

736: dbms_sql.parse(c, sqlstmt, dbms_sql.native);
737: dbms_sql.bind_variable(c, 'ccid', p_ccid);
738: dbms_sql.define_column(c, 1, buffer, 2000);
739: rows := dbms_sql.execute(c);
740: rows := dbms_sql.fetch_rows(c);
741: if rows <= 0 then
742: IF (g_print_debug) THEN
743: fa_rx_util_pkg.debug('Invalid CCID in fa_rx_flex_pkg.get_value()');
744: fa_rx_util_pkg.debug('get_value: ' || 'CCID = '||to_char(p_ccid));

Line 749: dbms_sql.column_value(c, 1, buffer);

745: fa_rx_util_pkg.debug('fa_rx_flex_pkg.get_value(NO_DATA_FOUND)-');
746: END IF;
747: raise no_data_found;
748: end if;
749: dbms_sql.column_value(c, 1, buffer);
750: dbms_sql.close_cursor(c);
751:
752: IF (g_print_debug) THEN
753: fa_rx_util_pkg.debug('fa_rx_flex_pkg.get_value('||buffer||')-');

Line 750: dbms_sql.close_cursor(c);

746: END IF;
747: raise no_data_found;
748: end if;
749: dbms_sql.column_value(c, 1, buffer);
750: dbms_sql.close_cursor(c);
751:
752: IF (g_print_debug) THEN
753: fa_rx_util_pkg.debug('fa_rx_flex_pkg.get_value('||buffer||')-');
754: END IF;

Line 785: if dbms_sql.is_open(c) then

781: when others then
782: if cflex%isopen then
783: close cflex;
784: end if;
785: if dbms_sql.is_open(c) then
786: dbms_sql.close_cursor(c);
787: end if;
788:
789: fa_rx_util_pkg.log('Exception in fa_rx_flex_pkg.get_value()');

Line 786: dbms_sql.close_cursor(c);

782: if cflex%isopen then
783: close cflex;
784: end if;
785: if dbms_sql.is_open(c) then
786: dbms_sql.close_cursor(c);
787: end if;
788:
789: fa_rx_util_pkg.log('Exception in fa_rx_flex_pkg.get_value()');
790: fa_rx_util_pkg.log('Application_ID = ' || to_char(p_Application_ID));