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.BIV_RT_AGENT_MGR_PKG dependencies on DBMS_SQL

Line 127: l_cur := dbms_sql.open_cursor;

123: if (l_debug = 'Y') then
124: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);
125: end if;
126:
127: l_cur := dbms_sql.open_cursor;
128: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
129: biv_core_pkg.bind_all_variables(l_cur);
130: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
131: dbms_sql.bind_variable(l_cur,':rows_to_display',

Line 128: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);

124: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);
125: end if;
126:
127: l_cur := dbms_sql.open_cursor;
128: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
129: biv_core_pkg.bind_all_variables(l_cur);
130: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
131: dbms_sql.bind_variable(l_cur,':rows_to_display',
132: to_number(biv_core_pkg.g_disp));

Line 130: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);

126:
127: l_cur := dbms_sql.open_cursor;
128: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
129: biv_core_pkg.bind_all_variables(l_cur);
130: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
131: dbms_sql.bind_variable(l_cur,':rows_to_display',
132: to_number(biv_core_pkg.g_disp));
133: l_dummy := dbms_sql.execute(l_cur);
134: dbms_sql.close_cursor(l_cur);

Line 131: dbms_sql.bind_variable(l_cur,':rows_to_display',

127: l_cur := dbms_sql.open_cursor;
128: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
129: biv_core_pkg.bind_all_variables(l_cur);
130: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
131: dbms_sql.bind_variable(l_cur,':rows_to_display',
132: to_number(biv_core_pkg.g_disp));
133: l_dummy := dbms_sql.execute(l_cur);
134: dbms_sql.close_cursor(l_cur);
135: biv_core_pkg.update_base_col_desc('biv_tmp_rt2');

Line 133: l_dummy := dbms_sql.execute(l_cur);

129: biv_core_pkg.bind_all_variables(l_cur);
130: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
131: dbms_sql.bind_variable(l_cur,':rows_to_display',
132: to_number(biv_core_pkg.g_disp));
133: l_dummy := dbms_sql.execute(l_cur);
134: dbms_sql.close_cursor(l_cur);
135: biv_core_pkg.update_base_col_desc('biv_tmp_rt2');
136: end if;
137:

Line 134: dbms_sql.close_cursor(l_cur);

130: dbms_sql.bind_variable(l_cur,':session_id',l_session_id);
131: dbms_sql.bind_variable(l_cur,':rows_to_display',
132: to_number(biv_core_pkg.g_disp));
133: l_dummy := dbms_sql.execute(l_cur);
134: dbms_sql.close_cursor(l_cur);
135: biv_core_pkg.update_base_col_desc('biv_tmp_rt2');
136: end if;
137:
138: /***** 10/11/2002

Line 202: l_cur := dbms_sql.open_cursor;

198: if (l_debug = 'Y') then
199: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);
200: end if;
201:
202: l_cur := dbms_sql.open_cursor;
203: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
204: biv_core_pkg.bind_all_variables(l_cur);
205: dbms_sql.bind_variable(l_cur, ':session_id', l_session_id);
206: l_dummy := dbms_sql.execute(l_cur);

Line 203: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);

199: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);
200: end if;
201:
202: l_cur := dbms_sql.open_cursor;
203: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
204: biv_core_pkg.bind_all_variables(l_cur);
205: dbms_sql.bind_variable(l_cur, ':session_id', l_session_id);
206: l_dummy := dbms_sql.execute(l_cur);
207: biv_core_pkg.update_base_col_desc('biv_tmp_rt2');

Line 205: dbms_sql.bind_variable(l_cur, ':session_id', l_session_id);

201:
202: l_cur := dbms_sql.open_cursor;
203: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
204: biv_core_pkg.bind_all_variables(l_cur);
205: dbms_sql.bind_variable(l_cur, ':session_id', l_session_id);
206: l_dummy := dbms_sql.execute(l_cur);
207: biv_core_pkg.update_base_col_desc('biv_tmp_rt2');
208:
209: if (nvl(biv_core_pkg.g_srt_by,'1') = '1') then

Line 206: l_dummy := dbms_sql.execute(l_cur);

202: l_cur := dbms_sql.open_cursor;
203: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
204: biv_core_pkg.bind_all_variables(l_cur);
205: dbms_sql.bind_variable(l_cur, ':session_id', l_session_id);
206: l_dummy := dbms_sql.execute(l_cur);
207: biv_core_pkg.update_base_col_desc('biv_tmp_rt2');
208:
209: if (nvl(biv_core_pkg.g_srt_by,'1') = '1') then
210: l_order_by := '1 asc';

Line 472: l_cur := dbms_sql.open_cursor;

468: if (l_debug = 'Y') then
469: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);
470: end if;
471:
472: l_cur := dbms_sql.open_cursor;
473: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
474: biv_core_pkg.bind_all_variables(l_cur);
475: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);
476: dbms_sql.bind_variable(l_cur,':rows_to_display', biv_core_pkg.g_disp);

Line 473: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);

469: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);
470: end if;
471:
472: l_cur := dbms_sql.open_cursor;
473: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
474: biv_core_pkg.bind_all_variables(l_cur);
475: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);
476: dbms_sql.bind_variable(l_cur,':rows_to_display', biv_core_pkg.g_disp);
477: l_pos := 'Before Execute';

Line 475: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);

471:
472: l_cur := dbms_sql.open_cursor;
473: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
474: biv_core_pkg.bind_all_variables(l_cur);
475: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);
476: dbms_sql.bind_variable(l_cur,':rows_to_display', biv_core_pkg.g_disp);
477: l_pos := 'Before Execute';
478: l_dummy := dbms_sql.execute(l_cur);
479: dbms_sql.close_cursor(l_cur);

Line 476: dbms_sql.bind_variable(l_cur,':rows_to_display', biv_core_pkg.g_disp);

472: l_cur := dbms_sql.open_cursor;
473: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
474: biv_core_pkg.bind_all_variables(l_cur);
475: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);
476: dbms_sql.bind_variable(l_cur,':rows_to_display', biv_core_pkg.g_disp);
477: l_pos := 'Before Execute';
478: l_dummy := dbms_sql.execute(l_cur);
479: dbms_sql.close_cursor(l_cur);
480:

Line 478: l_dummy := dbms_sql.execute(l_cur);

474: biv_core_pkg.bind_all_variables(l_cur);
475: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);
476: dbms_sql.bind_variable(l_cur,':rows_to_display', biv_core_pkg.g_disp);
477: l_pos := 'Before Execute';
478: l_dummy := dbms_sql.execute(l_cur);
479: dbms_sql.close_cursor(l_cur);
480:
481: l_from_list := l_from_list || ',
482: biv_tmp_rt2 rep';

Line 479: dbms_sql.close_cursor(l_cur);

475: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);
476: dbms_sql.bind_variable(l_cur,':rows_to_display', biv_core_pkg.g_disp);
477: l_pos := 'Before Execute';
478: l_dummy := dbms_sql.execute(l_cur);
479: dbms_sql.close_cursor(l_cur);
480:
481: l_from_list := l_from_list || ',
482: biv_tmp_rt2 rep';
483: l_from_list2:= l_from_list2 || ',

Line 530: l_cur := dbms_sql.open_cursor;

526: if (l_debug = 'Y') then
527: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);
528: end if;
529:
530: l_cur := dbms_sql.open_cursor;
531: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
532: biv_core_pkg.bind_all_variables(l_cur);
533: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);
534: l_pos := 'Before 2nd Execute';

Line 531: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);

527: biv_core_pkg.biv_debug(l_sql_sttmnt,biv_core_pkg.g_report_id);
528: end if;
529:
530: l_cur := dbms_sql.open_cursor;
531: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
532: biv_core_pkg.bind_all_variables(l_cur);
533: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);
534: l_pos := 'Before 2nd Execute';
535: l_dummy := dbms_sql.execute(l_cur);

Line 533: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);

529:
530: l_cur := dbms_sql.open_cursor;
531: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
532: biv_core_pkg.bind_all_variables(l_cur);
533: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);
534: l_pos := 'Before 2nd Execute';
535: l_dummy := dbms_sql.execute(l_cur);
536: biv_core_pkg.update_base_col_desc('biv_tmp_rt2');
537:

Line 535: l_dummy := dbms_sql.execute(l_cur);

531: dbms_sql.parse(l_cur,l_sql_sttmnt,dbms_sql.native);
532: biv_core_pkg.bind_all_variables(l_cur);
533: dbms_sql.bind_variable(l_cur,':session_id', l_session_id);
534: l_pos := 'Before 2nd Execute';
535: l_dummy := dbms_sql.execute(l_cur);
536: biv_core_pkg.update_base_col_desc('biv_tmp_rt2');
537:
538: if (biv_core_pkg.g_srt_by = '2') then
539: l_order_by := 'to_number(col4) desc';