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

Line 75: l_cur_id := DBMS_SQL.OPEN_CURSOR;

71: biv_core_pkg.biv_debug(l_query,biv_core_pkg.g_report_id);
72: commit;
73: end if;
74:
75: l_cur_id := DBMS_SQL.OPEN_CURSOR;
76: DBMS_SQL.PARSE(l_cur_id,l_query,DBMS_SQL.NATIVE);
77: biv_core_pkg.bind_all_variables(l_cur_id);
78: DBMS_SQL.BIND_VARIABLE(l_cur_id,':report_id',biv_core_pkg.g_report_id);
79: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',biv_core_pkg.get_session_id);

Line 76: DBMS_SQL.PARSE(l_cur_id,l_query,DBMS_SQL.NATIVE);

72: commit;
73: end if;
74:
75: l_cur_id := DBMS_SQL.OPEN_CURSOR;
76: DBMS_SQL.PARSE(l_cur_id,l_query,DBMS_SQL.NATIVE);
77: biv_core_pkg.bind_all_variables(l_cur_id);
78: DBMS_SQL.BIND_VARIABLE(l_cur_id,':report_id',biv_core_pkg.g_report_id);
79: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',biv_core_pkg.get_session_id);
80: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);

Line 78: DBMS_SQL.BIND_VARIABLE(l_cur_id,':report_id',biv_core_pkg.g_report_id);

74:
75: l_cur_id := DBMS_SQL.OPEN_CURSOR;
76: DBMS_SQL.PARSE(l_cur_id,l_query,DBMS_SQL.NATIVE);
77: biv_core_pkg.bind_all_variables(l_cur_id);
78: DBMS_SQL.BIND_VARIABLE(l_cur_id,':report_id',biv_core_pkg.g_report_id);
79: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',biv_core_pkg.get_session_id);
80: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
81: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
82:

Line 79: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',biv_core_pkg.get_session_id);

75: l_cur_id := DBMS_SQL.OPEN_CURSOR;
76: DBMS_SQL.PARSE(l_cur_id,l_query,DBMS_SQL.NATIVE);
77: biv_core_pkg.bind_all_variables(l_cur_id);
78: DBMS_SQL.BIND_VARIABLE(l_cur_id,':report_id',biv_core_pkg.g_report_id);
79: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',biv_core_pkg.get_session_id);
80: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
81: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
82:
83: -- Change for enh 2914005 starts

Line 80: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);

76: DBMS_SQL.PARSE(l_cur_id,l_query,DBMS_SQL.NATIVE);
77: biv_core_pkg.bind_all_variables(l_cur_id);
78: DBMS_SQL.BIND_VARIABLE(l_cur_id,':report_id',biv_core_pkg.g_report_id);
79: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',biv_core_pkg.get_session_id);
80: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
81: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
82:
83: -- Change for enh 2914005 starts
84: if l_return_num > 0 then

Line 81: DBMS_SQL.CLOSE_CURSOR(l_cur_id);

77: biv_core_pkg.bind_all_variables(l_cur_id);
78: DBMS_SQL.BIND_VARIABLE(l_cur_id,':report_id',biv_core_pkg.g_report_id);
79: DBMS_SQL.BIND_VARIABLE(l_cur_id,':session_id',biv_core_pkg.get_session_id);
80: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
81: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
82:
83: -- Change for enh 2914005 starts
84: if l_return_num > 0 then
85: l_total := biv_core_pkg.get_lookup_meaning('TOTAL');

Line 207: l_cur_id := DBMS_SQL.OPEN_CURSOR;

203: biv_core_pkg.biv_debug(l_query,l_report_code);
204: commit;
205: end if;
206:
207: l_cur_id := DBMS_SQL.OPEN_CURSOR;
208: DBMS_SQL.PARSE(l_cur_id,l_query,DBMS_SQL.NATIVE);
209: biv_core_pkg.bind_all_variables(l_cur_id);
210: DBMS_SQL.BIND_VARIABLE(l_cur_id,':l_report_code',l_report_code);
211: DBMS_SQL.BIND_VARIABLE(l_cur_id,':x_session_id' ,g_session_id);

Line 208: DBMS_SQL.PARSE(l_cur_id,l_query,DBMS_SQL.NATIVE);

204: commit;
205: end if;
206:
207: l_cur_id := DBMS_SQL.OPEN_CURSOR;
208: DBMS_SQL.PARSE(l_cur_id,l_query,DBMS_SQL.NATIVE);
209: biv_core_pkg.bind_all_variables(l_cur_id);
210: DBMS_SQL.BIND_VARIABLE(l_cur_id,':l_report_code',l_report_code);
211: DBMS_SQL.BIND_VARIABLE(l_cur_id,':x_session_id' ,g_session_id);
212: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);

Line 210: DBMS_SQL.BIND_VARIABLE(l_cur_id,':l_report_code',l_report_code);

206:
207: l_cur_id := DBMS_SQL.OPEN_CURSOR;
208: DBMS_SQL.PARSE(l_cur_id,l_query,DBMS_SQL.NATIVE);
209: biv_core_pkg.bind_all_variables(l_cur_id);
210: DBMS_SQL.BIND_VARIABLE(l_cur_id,':l_report_code',l_report_code);
211: DBMS_SQL.BIND_VARIABLE(l_cur_id,':x_session_id' ,g_session_id);
212: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
213: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
214: --

Line 211: DBMS_SQL.BIND_VARIABLE(l_cur_id,':x_session_id' ,g_session_id);

207: l_cur_id := DBMS_SQL.OPEN_CURSOR;
208: DBMS_SQL.PARSE(l_cur_id,l_query,DBMS_SQL.NATIVE);
209: biv_core_pkg.bind_all_variables(l_cur_id);
210: DBMS_SQL.BIND_VARIABLE(l_cur_id,':l_report_code',l_report_code);
211: DBMS_SQL.BIND_VARIABLE(l_cur_id,':x_session_id' ,g_session_id);
212: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
213: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
214: --
215: -- Add total Row

Line 212: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);

208: DBMS_SQL.PARSE(l_cur_id,l_query,DBMS_SQL.NATIVE);
209: biv_core_pkg.bind_all_variables(l_cur_id);
210: DBMS_SQL.BIND_VARIABLE(l_cur_id,':l_report_code',l_report_code);
211: DBMS_SQL.BIND_VARIABLE(l_cur_id,':x_session_id' ,g_session_id);
212: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
213: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
214: --
215: -- Add total Row
216: --

Line 213: DBMS_SQL.CLOSE_CURSOR(l_cur_id);

209: biv_core_pkg.bind_all_variables(l_cur_id);
210: DBMS_SQL.BIND_VARIABLE(l_cur_id,':l_report_code',l_report_code);
211: DBMS_SQL.BIND_VARIABLE(l_cur_id,':x_session_id' ,g_session_id);
212: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
213: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
214: --
215: -- Add total Row
216: --
217: select count(*) into l_ttl_recs

Line 377: l_cur_id := DBMS_SQL.OPEN_CURSOR;

373: biv_core_pkg.biv_debug(l_query,l_report_code);
374: commit;
375: end if;
376:
377: l_cur_id := DBMS_SQL.OPEN_CURSOR;
378: DBMS_SQL.PARSE(l_cur_id,l_query,DBMS_SQL.NATIVE);
379: biv_core_pkg.bind_all_variables(l_cur_id);
380: DBMS_SQL.BIND_VARIABLE(l_cur_id,':l_report_code',l_report_code);
381: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_session_id',g_session_id);

Line 378: DBMS_SQL.PARSE(l_cur_id,l_query,DBMS_SQL.NATIVE);

374: commit;
375: end if;
376:
377: l_cur_id := DBMS_SQL.OPEN_CURSOR;
378: DBMS_SQL.PARSE(l_cur_id,l_query,DBMS_SQL.NATIVE);
379: biv_core_pkg.bind_all_variables(l_cur_id);
380: DBMS_SQL.BIND_VARIABLE(l_cur_id,':l_report_code',l_report_code);
381: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_session_id',g_session_id);
382: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);

Line 380: DBMS_SQL.BIND_VARIABLE(l_cur_id,':l_report_code',l_report_code);

376:
377: l_cur_id := DBMS_SQL.OPEN_CURSOR;
378: DBMS_SQL.PARSE(l_cur_id,l_query,DBMS_SQL.NATIVE);
379: biv_core_pkg.bind_all_variables(l_cur_id);
380: DBMS_SQL.BIND_VARIABLE(l_cur_id,':l_report_code',l_report_code);
381: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_session_id',g_session_id);
382: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
383: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
384: if (g_debug_flag = 'Y') then

Line 381: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_session_id',g_session_id);

377: l_cur_id := DBMS_SQL.OPEN_CURSOR;
378: DBMS_SQL.PARSE(l_cur_id,l_query,DBMS_SQL.NATIVE);
379: biv_core_pkg.bind_all_variables(l_cur_id);
380: DBMS_SQL.BIND_VARIABLE(l_cur_id,':l_report_code',l_report_code);
381: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_session_id',g_session_id);
382: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
383: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
384: if (g_debug_flag = 'Y') then
385: biv_core_pkg.biv_debug('End of Report, Params:',

Line 382: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);

378: DBMS_SQL.PARSE(l_cur_id,l_query,DBMS_SQL.NATIVE);
379: biv_core_pkg.bind_all_variables(l_cur_id);
380: DBMS_SQL.BIND_VARIABLE(l_cur_id,':l_report_code',l_report_code);
381: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_session_id',g_session_id);
382: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
383: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
384: if (g_debug_flag = 'Y') then
385: biv_core_pkg.biv_debug('End of Report, Params:',
386: biv_core_pkg.g_report_id);

Line 383: DBMS_SQL.CLOSE_CURSOR(l_cur_id);

379: biv_core_pkg.bind_all_variables(l_cur_id);
380: DBMS_SQL.BIND_VARIABLE(l_cur_id,':l_report_code',l_report_code);
381: DBMS_SQL.BIND_VARIABLE(l_cur_id,':g_session_id',g_session_id);
382: l_return_num := DBMS_SQL.EXECUTE(l_cur_id);
383: DBMS_SQL.CLOSE_CURSOR(l_cur_id);
384: if (g_debug_flag = 'Y') then
385: biv_core_pkg.biv_debug('End of Report, Params:',
386: biv_core_pkg.g_report_id);
387: end if;

Line 516: l_cur := dbms_sql.open_cursor;

512: and t.task_type_id = 22
513: and t.escalation_level is not null
514: and ina.incident_status_id = p_status;
515: */
516: l_cur := dbms_sql.open_cursor;
517: dbms_sql.parse(l_cur,g_esc_sel_stt,dbms_sql.native);
518: biv_core_pkg.bind_all_variables(l_cur);
519: dbms_sql.bind_variable(l_cur,':p_status', p_status);
520: dbms_sql.define_column(l_cur,1,x_val);

Line 517: dbms_sql.parse(l_cur,g_esc_sel_stt,dbms_sql.native);

513: and t.escalation_level is not null
514: and ina.incident_status_id = p_status;
515: */
516: l_cur := dbms_sql.open_cursor;
517: dbms_sql.parse(l_cur,g_esc_sel_stt,dbms_sql.native);
518: biv_core_pkg.bind_all_variables(l_cur);
519: dbms_sql.bind_variable(l_cur,':p_status', p_status);
520: dbms_sql.define_column(l_cur,1,x_val);
521: l_dummy := dbms_sql.execute(l_cur);

Line 519: dbms_sql.bind_variable(l_cur,':p_status', p_status);

515: */
516: l_cur := dbms_sql.open_cursor;
517: dbms_sql.parse(l_cur,g_esc_sel_stt,dbms_sql.native);
518: biv_core_pkg.bind_all_variables(l_cur);
519: dbms_sql.bind_variable(l_cur,':p_status', p_status);
520: dbms_sql.define_column(l_cur,1,x_val);
521: l_dummy := dbms_sql.execute(l_cur);
522: IF dbms_sql.fetch_rows(l_cur) > 0 then
523: dbms_sql.column_value(l_cur, 1, x_val);

Line 520: dbms_sql.define_column(l_cur,1,x_val);

516: l_cur := dbms_sql.open_cursor;
517: dbms_sql.parse(l_cur,g_esc_sel_stt,dbms_sql.native);
518: biv_core_pkg.bind_all_variables(l_cur);
519: dbms_sql.bind_variable(l_cur,':p_status', p_status);
520: dbms_sql.define_column(l_cur,1,x_val);
521: l_dummy := dbms_sql.execute(l_cur);
522: IF dbms_sql.fetch_rows(l_cur) > 0 then
523: dbms_sql.column_value(l_cur, 1, x_val);
524: else x_val := 0;

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

517: dbms_sql.parse(l_cur,g_esc_sel_stt,dbms_sql.native);
518: biv_core_pkg.bind_all_variables(l_cur);
519: dbms_sql.bind_variable(l_cur,':p_status', p_status);
520: dbms_sql.define_column(l_cur,1,x_val);
521: l_dummy := dbms_sql.execute(l_cur);
522: IF dbms_sql.fetch_rows(l_cur) > 0 then
523: dbms_sql.column_value(l_cur, 1, x_val);
524: else x_val := 0;
525: dbms_sql.close_cursor(l_cur);

Line 522: IF dbms_sql.fetch_rows(l_cur) > 0 then

518: biv_core_pkg.bind_all_variables(l_cur);
519: dbms_sql.bind_variable(l_cur,':p_status', p_status);
520: dbms_sql.define_column(l_cur,1,x_val);
521: l_dummy := dbms_sql.execute(l_cur);
522: IF dbms_sql.fetch_rows(l_cur) > 0 then
523: dbms_sql.column_value(l_cur, 1, x_val);
524: else x_val := 0;
525: dbms_sql.close_cursor(l_cur);
526: end if;

Line 523: dbms_sql.column_value(l_cur, 1, x_val);

519: dbms_sql.bind_variable(l_cur,':p_status', p_status);
520: dbms_sql.define_column(l_cur,1,x_val);
521: l_dummy := dbms_sql.execute(l_cur);
522: IF dbms_sql.fetch_rows(l_cur) > 0 then
523: dbms_sql.column_value(l_cur, 1, x_val);
524: else x_val := 0;
525: dbms_sql.close_cursor(l_cur);
526: end if;
527: return(x_val);

Line 525: dbms_sql.close_cursor(l_cur);

521: l_dummy := dbms_sql.execute(l_cur);
522: IF dbms_sql.fetch_rows(l_cur) > 0 then
523: dbms_sql.column_value(l_cur, 1, x_val);
524: else x_val := 0;
525: dbms_sql.close_cursor(l_cur);
526: end if;
527: return(x_val);
528: exception
529: when others then