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

Line 316: x_cur:=dbms_sql.open_cursor;

312: TO_CHAR(X_ORDER_BY)||':'||x_sql_sttmnt,'BIV_CUSTOMER_BACKLOG');
313: commit;
314: end if;
315:
316: x_cur:=dbms_sql.open_cursor;
317: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);
318: biv_core_pkg.bind_all_variables(x_cur);
319: if x_order_by=7 then
320: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);

Line 317: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);

313: commit;
314: end if;
315:
316: x_cur:=dbms_sql.open_cursor;
317: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);
318: biv_core_pkg.bind_all_variables(x_cur);
319: if x_order_by=7 then
320: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
321: end if;

Line 320: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);

316: x_cur:=dbms_sql.open_cursor;
317: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);
318: biv_core_pkg.bind_all_variables(x_cur);
319: if x_order_by=7 then
320: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
321: end if;
322: dbms_sql.bind_variable(x_cur,':x_display',x_display);
323: dbms_sql.bind_variable(x_cur,':x_session',x_session);
324: x_dummy:=dbms_sql.execute(x_cur);

Line 322: dbms_sql.bind_variable(x_cur,':x_display',x_display);

318: biv_core_pkg.bind_all_variables(x_cur);
319: if x_order_by=7 then
320: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
321: end if;
322: dbms_sql.bind_variable(x_cur,':x_display',x_display);
323: dbms_sql.bind_variable(x_cur,':x_session',x_session);
324: x_dummy:=dbms_sql.execute(x_cur);
325: dbms_sql.close_cursor(x_cur);
326: -- setting the customer id parameter to null in the parameter list

Line 323: dbms_sql.bind_variable(x_cur,':x_session',x_session);

319: if x_order_by=7 then
320: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
321: end if;
322: dbms_sql.bind_variable(x_cur,':x_display',x_display);
323: dbms_sql.bind_variable(x_cur,':x_session',x_session);
324: x_dummy:=dbms_sql.execute(x_cur);
325: dbms_sql.close_cursor(x_cur);
326: -- setting the customer id parameter to null in the parameter list
327:

Line 324: x_dummy:=dbms_sql.execute(x_cur);

320: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
321: end if;
322: dbms_sql.bind_variable(x_cur,':x_display',x_display);
323: dbms_sql.bind_variable(x_cur,':x_session',x_session);
324: x_dummy:=dbms_sql.execute(x_cur);
325: dbms_sql.close_cursor(x_cur);
326: -- setting the customer id parameter to null in the parameter list
327:
328:

Line 325: dbms_sql.close_cursor(x_cur);

321: end if;
322: dbms_sql.bind_variable(x_cur,':x_display',x_display);
323: dbms_sql.bind_variable(x_cur,':x_session',x_session);
324: x_dummy:=dbms_sql.execute(x_cur);
325: dbms_sql.close_cursor(x_cur);
326: -- setting the customer id parameter to null in the parameter list
327:
328:
329: biv_core_pkg.g_cust_id_cnt:=0;

Line 436: x_cur:=dbms_sql.open_cursor;

432: biv_core_pkg.biv_debug(x_sql_sttmnt,'BIV_CUSTOMER_BACKLOG');
433: commit;
434: end if;
435:
436: x_cur:=dbms_sql.open_cursor;
437: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);
438: biv_core_pkg.bind_all_variables(x_cur);
439: if x_order_by <> 7 then
440: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);

Line 437: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);

433: commit;
434: end if;
435:
436: x_cur:=dbms_sql.open_cursor;
437: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);
438: biv_core_pkg.bind_all_variables(x_cur);
439: if x_order_by <> 7 then
440: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
441: end if;

Line 440: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);

436: x_cur:=dbms_sql.open_cursor;
437: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);
438: biv_core_pkg.bind_all_variables(x_cur);
439: if x_order_by <> 7 then
440: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
441: end if;
442: --dbms_sql.bind_variable(x_cur,':x_display',x_display);
443: dbms_sql.bind_variable(x_cur,':x_session',x_session);
444: x_dummy:=dbms_sql.execute(x_cur);

Line 442: --dbms_sql.bind_variable(x_cur,':x_display',x_display);

438: biv_core_pkg.bind_all_variables(x_cur);
439: if x_order_by <> 7 then
440: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
441: end if;
442: --dbms_sql.bind_variable(x_cur,':x_display',x_display);
443: dbms_sql.bind_variable(x_cur,':x_session',x_session);
444: x_dummy:=dbms_sql.execute(x_cur);
445: dbms_sql.close_cursor(x_cur);
446: -- x_cur:=dbms_sql.open_cursor;

Line 443: dbms_sql.bind_variable(x_cur,':x_session',x_session);

439: if x_order_by <> 7 then
440: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
441: end if;
442: --dbms_sql.bind_variable(x_cur,':x_display',x_display);
443: dbms_sql.bind_variable(x_cur,':x_session',x_session);
444: x_dummy:=dbms_sql.execute(x_cur);
445: dbms_sql.close_cursor(x_cur);
446: -- x_cur:=dbms_sql.open_cursor;
447:

Line 444: x_dummy:=dbms_sql.execute(x_cur);

440: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
441: end if;
442: --dbms_sql.bind_variable(x_cur,':x_display',x_display);
443: dbms_sql.bind_variable(x_cur,':x_session',x_session);
444: x_dummy:=dbms_sql.execute(x_cur);
445: dbms_sql.close_cursor(x_cur);
446: -- x_cur:=dbms_sql.open_cursor;
447:
448: execute immediate 'delete from biv_tmp_rt1 where report_code=''X'' and session_id=:x_session'

Line 445: dbms_sql.close_cursor(x_cur);

441: end if;
442: --dbms_sql.bind_variable(x_cur,':x_display',x_display);
443: dbms_sql.bind_variable(x_cur,':x_session',x_session);
444: x_dummy:=dbms_sql.execute(x_cur);
445: dbms_sql.close_cursor(x_cur);
446: -- x_cur:=dbms_sql.open_cursor;
447:
448: execute immediate 'delete from biv_tmp_rt1 where report_code=''X'' and session_id=:x_session'
449: using x_session;

Line 446: -- x_cur:=dbms_sql.open_cursor;

442: --dbms_sql.bind_variable(x_cur,':x_display',x_display);
443: dbms_sql.bind_variable(x_cur,':x_session',x_session);
444: x_dummy:=dbms_sql.execute(x_cur);
445: dbms_sql.close_cursor(x_cur);
446: -- x_cur:=dbms_sql.open_cursor;
447:
448: execute immediate 'delete from biv_tmp_rt1 where report_code=''X'' and session_id=:x_session'
449: using x_session;
450:

Line 652: x_cur:=dbms_sql.open_cursor;

648: biv_core_pkg.biv_debug(x_sql_sttmnt,'BIV_ESCALATED_SR');
649: commit;
650: end if;
651:
652: x_cur:=dbms_sql.open_cursor;
653: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);
654: biv_core_pkg.bind_all_variables(x_cur);
655: if x_order_by=4 then
656: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);

Line 653: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);

649: commit;
650: end if;
651:
652: x_cur:=dbms_sql.open_cursor;
653: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);
654: biv_core_pkg.bind_all_variables(x_cur);
655: if x_order_by=4 then
656: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
657: end if;

Line 656: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);

652: x_cur:=dbms_sql.open_cursor;
653: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);
654: biv_core_pkg.bind_all_variables(x_cur);
655: if x_order_by=4 then
656: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
657: end if;
658: dbms_sql.bind_variable(x_cur,':x_display',x_display);
659: dbms_sql.bind_variable(x_cur,':x_session',x_session);
660: x_dummy:=dbms_sql.execute(x_cur);

Line 658: dbms_sql.bind_variable(x_cur,':x_display',x_display);

654: biv_core_pkg.bind_all_variables(x_cur);
655: if x_order_by=4 then
656: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
657: end if;
658: dbms_sql.bind_variable(x_cur,':x_display',x_display);
659: dbms_sql.bind_variable(x_cur,':x_session',x_session);
660: x_dummy:=dbms_sql.execute(x_cur);
661: dbms_sql.close_cursor(x_cur);
662:

Line 659: dbms_sql.bind_variable(x_cur,':x_session',x_session);

655: if x_order_by=4 then
656: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
657: end if;
658: dbms_sql.bind_variable(x_cur,':x_display',x_display);
659: dbms_sql.bind_variable(x_cur,':x_session',x_session);
660: x_dummy:=dbms_sql.execute(x_cur);
661: dbms_sql.close_cursor(x_cur);
662:
663:

Line 660: x_dummy:=dbms_sql.execute(x_cur);

656: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
657: end if;
658: dbms_sql.bind_variable(x_cur,':x_display',x_display);
659: dbms_sql.bind_variable(x_cur,':x_session',x_session);
660: x_dummy:=dbms_sql.execute(x_cur);
661: dbms_sql.close_cursor(x_cur);
662:
663:
664: -- Fix for bug 3461261

Line 661: dbms_sql.close_cursor(x_cur);

657: end if;
658: dbms_sql.bind_variable(x_cur,':x_display',x_display);
659: dbms_sql.bind_variable(x_cur,':x_session',x_session);
660: x_dummy:=dbms_sql.execute(x_cur);
661: dbms_sql.close_cursor(x_cur);
662:
663:
664: -- Fix for bug 3461261
665: -- x_from_list1:=x_from_list1||',biv_tmp_rt1 rep ' ;

Line 719: x_cur:=dbms_sql.open_cursor;

715: biv_core_pkg.biv_debug(x_sql_sttmnt,'BIV_ESCALATED_SR');
716: commit;
717: end if;
718:
719: x_cur:=dbms_sql.open_cursor;
720: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);
721: biv_core_pkg.bind_all_variables(x_cur);
722: if x_order_by <> 4 then
723: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);

Line 720: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);

716: commit;
717: end if;
718:
719: x_cur:=dbms_sql.open_cursor;
720: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);
721: biv_core_pkg.bind_all_variables(x_cur);
722: if x_order_by <> 4 then
723: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
724: end if;

Line 723: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);

719: x_cur:=dbms_sql.open_cursor;
720: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);
721: biv_core_pkg.bind_all_variables(x_cur);
722: if x_order_by <> 4 then
723: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
724: end if;
725: dbms_sql.bind_variable(x_cur,':x_stat_1',x_stat_1);
726: dbms_sql.bind_variable(x_cur,':x_stat_2',x_stat_2);
727: dbms_sql.bind_variable(x_cur,':x_stat_3',x_stat_3);

Line 725: dbms_sql.bind_variable(x_cur,':x_stat_1',x_stat_1);

721: biv_core_pkg.bind_all_variables(x_cur);
722: if x_order_by <> 4 then
723: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
724: end if;
725: dbms_sql.bind_variable(x_cur,':x_stat_1',x_stat_1);
726: dbms_sql.bind_variable(x_cur,':x_stat_2',x_stat_2);
727: dbms_sql.bind_variable(x_cur,':x_stat_3',x_stat_3);
728: dbms_sql.bind_variable(x_cur,':x_display',x_display);
729: dbms_sql.bind_variable(x_cur,':x_session',x_session);

Line 726: dbms_sql.bind_variable(x_cur,':x_stat_2',x_stat_2);

722: if x_order_by <> 4 then
723: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
724: end if;
725: dbms_sql.bind_variable(x_cur,':x_stat_1',x_stat_1);
726: dbms_sql.bind_variable(x_cur,':x_stat_2',x_stat_2);
727: dbms_sql.bind_variable(x_cur,':x_stat_3',x_stat_3);
728: dbms_sql.bind_variable(x_cur,':x_display',x_display);
729: dbms_sql.bind_variable(x_cur,':x_session',x_session);
730: x_dummy:=dbms_sql.execute(x_cur);

Line 727: dbms_sql.bind_variable(x_cur,':x_stat_3',x_stat_3);

723: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
724: end if;
725: dbms_sql.bind_variable(x_cur,':x_stat_1',x_stat_1);
726: dbms_sql.bind_variable(x_cur,':x_stat_2',x_stat_2);
727: dbms_sql.bind_variable(x_cur,':x_stat_3',x_stat_3);
728: dbms_sql.bind_variable(x_cur,':x_display',x_display);
729: dbms_sql.bind_variable(x_cur,':x_session',x_session);
730: x_dummy:=dbms_sql.execute(x_cur);
731: dbms_sql.close_cursor(x_cur);

Line 728: dbms_sql.bind_variable(x_cur,':x_display',x_display);

724: end if;
725: dbms_sql.bind_variable(x_cur,':x_stat_1',x_stat_1);
726: dbms_sql.bind_variable(x_cur,':x_stat_2',x_stat_2);
727: dbms_sql.bind_variable(x_cur,':x_stat_3',x_stat_3);
728: dbms_sql.bind_variable(x_cur,':x_display',x_display);
729: dbms_sql.bind_variable(x_cur,':x_session',x_session);
730: x_dummy:=dbms_sql.execute(x_cur);
731: dbms_sql.close_cursor(x_cur);
732:

Line 729: dbms_sql.bind_variable(x_cur,':x_session',x_session);

725: dbms_sql.bind_variable(x_cur,':x_stat_1',x_stat_1);
726: dbms_sql.bind_variable(x_cur,':x_stat_2',x_stat_2);
727: dbms_sql.bind_variable(x_cur,':x_stat_3',x_stat_3);
728: dbms_sql.bind_variable(x_cur,':x_display',x_display);
729: dbms_sql.bind_variable(x_cur,':x_session',x_session);
730: x_dummy:=dbms_sql.execute(x_cur);
731: dbms_sql.close_cursor(x_cur);
732:
733: execute immediate 'delete from biv_tmp_rt1 where report_code=''X'' and session_id=:x_session'

Line 730: x_dummy:=dbms_sql.execute(x_cur);

726: dbms_sql.bind_variable(x_cur,':x_stat_2',x_stat_2);
727: dbms_sql.bind_variable(x_cur,':x_stat_3',x_stat_3);
728: dbms_sql.bind_variable(x_cur,':x_display',x_display);
729: dbms_sql.bind_variable(x_cur,':x_session',x_session);
730: x_dummy:=dbms_sql.execute(x_cur);
731: dbms_sql.close_cursor(x_cur);
732:
733: execute immediate 'delete from biv_tmp_rt1 where report_code=''X'' and session_id=:x_session'
734: using x_session;

Line 731: dbms_sql.close_cursor(x_cur);

727: dbms_sql.bind_variable(x_cur,':x_stat_3',x_stat_3);
728: dbms_sql.bind_variable(x_cur,':x_display',x_display);
729: dbms_sql.bind_variable(x_cur,':x_session',x_session);
730: x_dummy:=dbms_sql.execute(x_cur);
731: dbms_sql.close_cursor(x_cur);
732:
733: execute immediate 'delete from biv_tmp_rt1 where report_code=''X'' and session_id=:x_session'
734: using x_session;
735:

Line 969: x_cur:=dbms_sql.open_cursor;

965: biv_core_pkg.biv_debug(x_sql_sttmnt,'BIV_CUSTOMER_BACKLOG');
966: commit;
967: end if;
968:
969: x_cur:=dbms_sql.open_cursor;
970: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);
971: biv_core_pkg.bind_all_variables(x_cur);
972: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
973: dbms_sql.bind_variable(x_cur,':x_session',x_session);

Line 970: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);

966: commit;
967: end if;
968:
969: x_cur:=dbms_sql.open_cursor;
970: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);
971: biv_core_pkg.bind_all_variables(x_cur);
972: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
973: dbms_sql.bind_variable(x_cur,':x_session',x_session);
974: x_dummy:=dbms_sql.execute(x_cur);

Line 972: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);

968:
969: x_cur:=dbms_sql.open_cursor;
970: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);
971: biv_core_pkg.bind_all_variables(x_cur);
972: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
973: dbms_sql.bind_variable(x_cur,':x_session',x_session);
974: x_dummy:=dbms_sql.execute(x_cur);
975: dbms_sql.close_cursor(x_cur);
976:

Line 973: dbms_sql.bind_variable(x_cur,':x_session',x_session);

969: x_cur:=dbms_sql.open_cursor;
970: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);
971: biv_core_pkg.bind_all_variables(x_cur);
972: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
973: dbms_sql.bind_variable(x_cur,':x_session',x_session);
974: x_dummy:=dbms_sql.execute(x_cur);
975: dbms_sql.close_cursor(x_cur);
976:
977: update biv_tmp_rt1

Line 974: x_dummy:=dbms_sql.execute(x_cur);

970: dbms_sql.parse(x_cur,x_sql_sttmnt,dbms_sql.native);
971: biv_core_pkg.bind_all_variables(x_cur);
972: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
973: dbms_sql.bind_variable(x_cur,':x_session',x_session);
974: x_dummy:=dbms_sql.execute(x_cur);
975: dbms_sql.close_cursor(x_cur);
976:
977: update biv_tmp_rt1
978: set ID=biv_core_pkg.g_cust_id(1);

Line 975: dbms_sql.close_cursor(x_cur);

971: biv_core_pkg.bind_all_variables(x_cur);
972: dbms_sql.bind_variable(x_cur,':x_severity_id',x_severity_id);
973: dbms_sql.bind_variable(x_cur,':x_session',x_session);
974: x_dummy:=dbms_sql.execute(x_cur);
975: dbms_sql.close_cursor(x_cur);
976:
977: update biv_tmp_rt1
978: set ID=biv_core_pkg.g_cust_id(1);
979: