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 BIV_TMP_RT1

Line 198: biv_core_pkg.clean_dcf_table('BIV_TMP_RT1');

194:
195: begin
196: x_session:=biv_core_pkg.get_session_id;
197:
198: biv_core_pkg.clean_dcf_table('BIV_TMP_RT1');
199:
200: q3_str:=' ';
201: q4_str:=' ';
202: q5_str:=' ';

Line 276: -- Building Sql to populate the BIV_TMP_RT1 table

272: x_display:=to_number(nvl(biv_core_pkg.g_disp,0))+1;
273:
274: -- q2_str : unowned_sr q3_str :escalated_sr , q4_str : total_backlog , q5_str : severity_backlog,
275:
276: -- Building Sql to populate the BIV_TMP_RT1 table
277: if (x_order_by=4)then
278: x_sql_sttmnt:='select ''X'',:x_session, sr.customer_id,count(1)'
279: ||x_from_list||x_where_clause||'
280: and (nvl(sr.resource_type,''X'') <>''RS_EMPLOYEE'' or sr.incident_owner_id is null )

Line 305: x_sql_sttmnt:='insert into biv_tmp_rt1 rep(report_code,session_id, ID,col2)(select * from ( '

301: group by sr.customer_id ';
302:
303: end if;
304:
305: x_sql_sttmnt:='insert into biv_tmp_rt1 rep(report_code,session_id, ID,col2)(select * from ( '
306: ||x_sql_sttmnt||' order by 4 desc ) where rownum < :x_display )';
307:
308:
309:

Line 350: x_from_list :=x_from_list||', biv_tmp_rt1 rep ' ;

346: x_from_list:='from cs_incidents_b_sec sr,cs_incident_statuses_b stat ';
347: biv_core_pkg.get_where_clause(x_from_list,x_where_clause);
348: x_where_clause:= x_where_clause ||' and sr.incident_status_id=stat.incident_status_id ' ;
349:
350: x_from_list :=x_from_list||', biv_tmp_rt1 rep ' ;
351: x_from_list1 :=x_from_list1||', biv_tmp_rt1 rep ' ;
352:
353: if (l_debug = 'Y') then
354: biv_core_pkg.biv_debug('Rebuild Severity Query Where Clause :'||

Line 351: x_from_list1 :=x_from_list1||', biv_tmp_rt1 rep ' ;

347: biv_core_pkg.get_where_clause(x_from_list,x_where_clause);
348: x_where_clause:= x_where_clause ||' and sr.incident_status_id=stat.incident_status_id ' ;
349:
350: x_from_list :=x_from_list||', biv_tmp_rt1 rep ' ;
351: x_from_list1 :=x_from_list1||', biv_tmp_rt1 rep ' ;
352:
353: if (l_debug = 'Y') then
354: biv_core_pkg.biv_debug('Rebuild Severity Query Where Clause :'||
355: x_where_clause1,'BIV_CUSTOMER_BACKLOG');

Line 410: q3_str:='select ID a,to_number(col2) b ,0 c,0 d,0 e from biv_tmp_rt1 where report_code=''X''

406: and sr.customer_id=rep.ID
407: and rep.session_id=:x_session group by sr.customer_id ';
408:
409: if (x_order_by=4)then
410: q3_str:='select ID a,to_number(col2) b ,0 c,0 d,0 e from biv_tmp_rt1 where report_code=''X''
411: and session_id=:x_session';
412: elsif (x_order_by=5) then
413: q4_str:='select ID a,0 b ,to_number(col2) c,0 d,0 e from biv_tmp_rt1 where report_code=''X''
414: and session_id=:x_session ';

Line 413: q4_str:='select ID a,0 b ,to_number(col2) c,0 d,0 e from biv_tmp_rt1 where report_code=''X''

409: if (x_order_by=4)then
410: q3_str:='select ID a,to_number(col2) b ,0 c,0 d,0 e from biv_tmp_rt1 where report_code=''X''
411: and session_id=:x_session';
412: elsif (x_order_by=5) then
413: q4_str:='select ID a,0 b ,to_number(col2) c,0 d,0 e from biv_tmp_rt1 where report_code=''X''
414: and session_id=:x_session ';
415: elsif (x_order_by=6) then
416: q5_str:='select ID a,0 b ,0 c,to_number(col2) d,0 e from biv_tmp_rt1 where report_code=''X''
417: and session_id=:x_session ';

Line 416: q5_str:='select ID a,0 b ,0 c,to_number(col2) d,0 e from biv_tmp_rt1 where report_code=''X''

412: elsif (x_order_by=5) then
413: q4_str:='select ID a,0 b ,to_number(col2) c,0 d,0 e from biv_tmp_rt1 where report_code=''X''
414: and session_id=:x_session ';
415: elsif (x_order_by=6) then
416: q5_str:='select ID a,0 b ,0 c,to_number(col2) d,0 e from biv_tmp_rt1 where report_code=''X''
417: and session_id=:x_session ';
418: elsif (x_order_by=7 ) then
419: q6_str:='select ID a,0 b ,0 c,0 d,to_number(col2) e from biv_tmp_rt1 where report_code=''X''
420: and session_id=:x_session ';

Line 419: q6_str:='select ID a,0 b ,0 c,0 d,to_number(col2) e from biv_tmp_rt1 where report_code=''X''

415: elsif (x_order_by=6) then
416: q5_str:='select ID a,0 b ,0 c,to_number(col2) d,0 e from biv_tmp_rt1 where report_code=''X''
417: and session_id=:x_session ';
418: elsif (x_order_by=7 ) then
419: q6_str:='select ID a,0 b ,0 c,0 d,to_number(col2) e from biv_tmp_rt1 where report_code=''X''
420: and session_id=:x_session ';
421: end if;
422:
423:

Line 424: x_sql_sttmnt:='insert into biv_tmp_rt1 ( report_code,rowno,session_id,ID,col4,col6,col8,col10)

420: and session_id=:x_session ';
421: end if;
422:
423:
424: x_sql_sttmnt:='insert into biv_tmp_rt1 ( report_code,rowno,session_id,ID,col4,col6,col8,col10)
425: (select ''BIV_CUSTOMER_BACKLOG'',rownum,ses,ID,col4,col6,col8,col10 from (
426: (select ''BIV_CUSTOMER_BACKLOG'',:x_session ses, a ID , sum(b) col4, sum(c) col6, sum(d) col8, sum(e) col10 from ('
427: ||q3_str||' union all '||q4_str||' union all '||q5_str||' union all '||q6_str||
428: ') group by a ) order by '||x_order_by||' desc ))';

Line 448: execute immediate 'delete from biv_tmp_rt1 where report_code=''X'' and session_id=: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:
451: biv_core_pkg.update_description('P_CUST_ID','ID','col2','BIV_TMP_RT1');
452:

Line 451: biv_core_pkg.update_description('P_CUST_ID','ID','col2','BIV_TMP_RT1');

447:
448: execute immediate 'delete from biv_tmp_rt1 where report_code=''X'' and session_id=:x_session'
449: using x_session;
450:
451: biv_core_pkg.update_description('P_CUST_ID','ID','col2','BIV_TMP_RT1');
452:
453: biv_core_pkg.reset_view_by_param;
454: l_new_param_str := 'BIV_SERVICE_REQUEST' ||biv_core_pkg.g_param_sep ||
455: biv_core_pkg.reconstruct_param_str;

Line 465: update biv_tmp_rt1 rep

461: biv_core_pkg.reconstruct_param_str;
462: l_new_param_str1 := l_new_param_str1 ||'P_CUST_ID' ||biv_core_pkg.g_value_sep ;
463: -- biv_core_pkg.g_value_sep || 'BIV_RT_CUS_BLOG_DD' ||
464:
465: update biv_tmp_rt1 rep
466: set col1=l_new_param_str1||nvl(to_char(rep.ID),biv_core_pkg.g_null)||
467: biv_core_pkg.g_param_sep,
468: col3=l_new_param_str||nvl(to_char(rep.ID),biv_core_pkg.g_null)||
469: biv_core_pkg.g_param_sep ||'P_UNOWN'|| biv_core_pkg.g_value_sep ||

Line 486: from biv_tmp_rt1

482: biv_core_pkg.g_value_sep || 'Y'||biv_core_pkg.g_param_sep,
483: creation_date = sysdate,
484: col20 = 'INDV_ROW';
485: select count(1) into l_ttl_recs
486: from biv_tmp_rt1
487: where session_id = x_session
488: and report_code = 'BIV_CUSTOMER_BACKLOG';
489: if (nvl(l_ttl_recs,0) between 2 and biv_core_pkg.g_disp-1) then
490: if (l_debug = 'Y') then

Line 493: insert into biv_tmp_rt1(report_code,session_id, rowno,col4,col6,col8,

489: if (nvl(l_ttl_recs,0) between 2 and biv_core_pkg.g_disp-1) then
490: if (l_debug = 'Y') then
491: biv_core_pkg.biv_debug('Inserting totol row','BIV_CUSTOMER_BACKLOG');
492: end if;
493: insert into biv_tmp_rt1(report_code,session_id, rowno,col4,col6,col8,
494: col10,col20)
495: select 'BIV_CUSTOMER_BACKLOG',x_session,max(rowno)+1,
496: sum(col4), sum(col6),
497: sum(col8), sum(col10),'TTL_ROW'

Line 498: from biv_tmp_rt1

494: col10,col20)
495: select 'BIV_CUSTOMER_BACKLOG',x_session,max(rowno)+1,
496: sum(col4), sum(col6),
497: sum(col8), sum(col10),'TTL_ROW'
498: from biv_tmp_rt1
499: where session_id = x_session
500: and report_code = 'BIV_CUSTOMER_BACKLOG'
501: and col20 = 'INDV_ROW';
502: l_new_param_str := 'BIV_SERVICE_REQUEST' ||biv_core_pkg.g_param_sep ||

Line 512: update biv_tmp_rt1 rep

508: biv_core_pkg.biv_debug('Updating hyper links in total row',
509: 'BIV_CUSTOMER_BACKLOG');
510: end if;
511: l_ttl_meaning := biv_core_pkg.get_lookup_meaning('TOTAL');
512: update biv_tmp_rt1 rep
513: set col1=l_new_param_str1 ,
514: col2=l_ttl_meaning,
515: col3=l_new_param_str||
516: 'P_UNOWN'|| biv_core_pkg.g_value_sep ||

Line 572: biv_core_pkg.clean_dcf_table('BIV_TMP_RT1');

568: l_debug varchar2(30) := fnd_profile.value('BIV:DEBUG');
569:
570: begin
571: x_session:=biv_core_pkg.get_session_id;
572: biv_core_pkg.clean_dcf_table('BIV_TMP_RT1');
573:
574:
575: x_severity_id:=fnd_profile.value('BIV:INC_SEVERITY_1');
576: x_stat_1:=fnd_profile.value('BIV:INC_STATUS_1');

Line 644: x_sql_sttmnt:='insert into biv_tmp_rt1 rep(report_code,session_id, ID,col2)(select * from ( '

640: end if;
641:
642:
643:
644: x_sql_sttmnt:='insert into biv_tmp_rt1 rep(report_code,session_id, ID,col2)(select * from ( '
645: ||x_sql_sttmnt||' order by 4 desc ) where rownum < :x_display )';
646:
647: if (l_debug = 'Y') then
648: biv_core_pkg.biv_debug(x_sql_sttmnt,'BIV_ESCALATED_SR');

Line 665: -- x_from_list1:=x_from_list1||',biv_tmp_rt1 rep ' ;

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 ' ;
666:
667: if (x_order_by=5) then /* Sort by Escalation */
668: x_from_list2:=x_from_list2||', biv_tmp_rt1 rep ' ;
669: end if;

Line 668: x_from_list2:=x_from_list2||', biv_tmp_rt1 rep ' ;

664: -- Fix for bug 3461261
665: -- x_from_list1:=x_from_list1||',biv_tmp_rt1 rep ' ;
666:
667: if (x_order_by=5) then /* Sort by Escalation */
668: x_from_list2:=x_from_list2||', biv_tmp_rt1 rep ' ;
669: end if;
670:
671:
672: -- Fix for bug 3461261

Line 682: from biv_tmp_rt1 where report_code=''X'' and session_id=:x_session )';

678:
679:
680: if x_order_by=4 then /* Sort by Severity, overwrites previous values sort by Escalation */
681: q3_str:='(select ''BIV_ESCALATED_SR'',:x_session, ID a ,to_number(col2) b, 0 c ,0 d,0 e,0 f,0 g
682: from biv_tmp_rt1 where report_code=''X'' and session_id=:x_session )';
683: else
684: /* Used when sort by Escalation (first part of union all) */
685: q3_str:= '(select ''BIV_ESCALATED_SR'',:x_session ,'|| biv_core_pkg.g_base_column||' a,
686: count(1) b, 0 c ,0 d,0 e,0 f,0 g '

Line 711: x_sql_sttmnt:='insert into biv_tmp_rt1 rep (report_code,rowno,session_id,ID,col4,col6,col8,col10,col12,col14)

707: union all '||q4_str||'
708: ) group by a
709: order by '||x_order_by ||' desc ) where rownum < :x_display)' ;
710:
711: x_sql_sttmnt:='insert into biv_tmp_rt1 rep (report_code,rowno,session_id,ID,col4,col6,col8,col10,col12,col14)
712: '||x_sql_sttmnt||' ' ;
713:
714: if (l_debug = 'Y') then
715: biv_core_pkg.biv_debug(x_sql_sttmnt,'BIV_ESCALATED_SR');

Line 733: execute immediate 'delete from biv_tmp_rt1 where report_code=''X'' and session_id=:x_session'

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:
736:
737: biv_core_pkg.update_base_col_desc('BIV_TMP_RT1');

Line 737: biv_core_pkg.update_base_col_desc('BIV_TMP_RT1');

733: execute immediate 'delete from biv_tmp_rt1 where report_code=''X'' and session_id=:x_session'
734: using x_session;
735:
736:
737: biv_core_pkg.update_base_col_desc('BIV_TMP_RT1');
738:
739:
740: dd_param_str:=biv_core_pkg.param_for_base_col;
741: --dd_param_str:='P_PRD_ID';

Line 748: update biv_tmp_rt1 rep

744: biv_core_pkg.reconstruct_param_str;
745: l_new_param_str := l_new_param_str ||dd_param_str ||biv_core_pkg.g_value_sep ;
746: -- 'jtfBinId' || biv_core_pkg.g_value_sep || 'BIV_SERVICE_REQUEST' ||biv_core_pkg.g_param_sep ||
747:
748: update biv_tmp_rt1 rep
749: set col3=l_new_param_str||
750: nvl(to_char(rep.ID),biv_core_pkg.g_null)||
751: biv_core_pkg.g_param_sep ||'P_SEV'||
752: biv_core_pkg.g_value_sep ||to_char(x_severity_id)||

Line 794: from biv_tmp_rt1

790: -- Generate total row
791: --
792: commit;
793: select count(1) into l_ttl_recs
794: from biv_tmp_rt1
795: where session_id = x_session
796: and report_code = 'BIV_ESCALATED_SR';
797: l_ttl_meaning := biv_core_pkg.get_lookup_meaning('TOTAL');
798: if (nvl(l_ttl_recs,0) between 2 and biv_core_pkg.g_disp-1) then

Line 799: insert into biv_tmp_rt1(report_code,rowno,col2,col4,col6,col8,col10,

795: where session_id = x_session
796: and report_code = 'BIV_ESCALATED_SR';
797: l_ttl_meaning := biv_core_pkg.get_lookup_meaning('TOTAL');
798: if (nvl(l_ttl_recs,0) between 2 and biv_core_pkg.g_disp-1) then
799: insert into biv_tmp_rt1(report_code,rowno,col2,col4,col6,col8,col10,
800: col12, col14, session_id,col20)
801: select report_code, max(rowno)+1, l_ttl_meaning, sum(col4), sum(col6),
802: sum(col8), sum(col10), sum(col12), sum(col14), session_id,'TTL_ROW'
803: from biv_tmp_rt1

Line 803: from biv_tmp_rt1

799: insert into biv_tmp_rt1(report_code,rowno,col2,col4,col6,col8,col10,
800: col12, col14, session_id,col20)
801: select report_code, max(rowno)+1, l_ttl_meaning, sum(col4), sum(col6),
802: sum(col8), sum(col10), sum(col12), sum(col14), session_id,'TTL_ROW'
803: from biv_tmp_rt1
804: where report_code = 'BIV_ESCALATED_SR'
805: and session_id = x_session
806: and col20 = 'INDV_ROW'
807: group by report_code, session_id;

Line 810: update biv_tmp_rt1 rep

806: and col20 = 'INDV_ROW'
807: group by report_code, session_id;
808: l_new_param_str := 'BIV_SERVICE_REQUEST' ||biv_core_pkg.g_param_sep ||
809: biv_core_pkg.reconstruct_param_str;
810: update biv_tmp_rt1 rep
811: set col3=l_new_param_str||'P_SEV'|| biv_core_pkg.g_value_sep ||
812: to_char(x_severity_id)||biv_core_pkg.g_param_sep||'P_BLOG'||
813: biv_core_pkg.g_value_sep || 'Y'||biv_core_pkg.g_param_sep,
814: col5=l_new_param_str||'P_ESC_SR'|| biv_core_pkg.g_value_sep || 'Y'||

Line 875: biv_core_pkg.clean_dcf_table('BIV_TMP_RT1');

871:
872: begin
873: x_session:=biv_core_pkg.get_session_id;
874:
875: biv_core_pkg.clean_dcf_table('BIV_TMP_RT1');
876:
877: x_severity_id:=fnd_profile.value('BIV:INC_SEVERITY_1');
878:
879: biv_core_pkg.get_report_parameters(p_param_str);

Line 961: x_sql_sttmnt:='insert into biv_tmp_rt1(report_code,rowno,session_id,col2,col4,col6,col8,col10)

957: group by sr.contract_number)) group by A
958: ORDER BY 3 ))';
959:
960:
961: x_sql_sttmnt:='insert into biv_tmp_rt1(report_code,rowno,session_id,col2,col4,col6,col8,col10)
962: '||x_sql_sttmnt||' ' ;
963:
964: if (l_debug = 'Y') then
965: biv_core_pkg.biv_debug(x_sql_sttmnt,'BIV_CUSTOMER_BACKLOG');

Line 977: update biv_tmp_rt1

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:
980:
981: biv_core_pkg.reset_view_by_param;

Line 992: update biv_tmp_rt1 d

988: 'BIV_CUSTOMER_BACKLOG');
989: end if;
990: -- 'jtfBinId' ||biv_core_pkg.g_value_sep || 'BIV_SERVICE_REQUEST' ||biv_core_pkg.g_param_sep ||
991: -- may be cust_id in update in not needed
992: update biv_tmp_rt1 d
993: set col3=l_new_param_str||nvl(to_char(d.ID),biv_core_pkg.g_null)||
994: biv_core_pkg.g_param_sep ||'P_UNOWN'|| biv_core_pkg.g_value_sep ||
995: 'Y'||biv_core_pkg.g_param_sep ||'P_CNTR_ID' ||
996: biv_core_pkg.g_value_sep||nvl(d.col2,biv_core_pkg.g_null)||

Line 1021: from biv_tmp_rt1

1017: creation_date = sysdate;
1018:
1019: /*** 7/30/2 not needed as this drill does not have g_disp. it is to display all
1020: select count(1) into l_ttl_recs
1021: from biv_tmp_rt1
1022: where session_id = x_session
1023: and report_code = 'BIV_CUSTOMER_BACKLOG';
1024: *****/
1025:

Line 1026: insert into biv_tmp_rt1 ( report_code,session_id, rowno, col4, col6,

1022: where session_id = x_session
1023: and report_code = 'BIV_CUSTOMER_BACKLOG';
1024: *****/
1025:
1026: insert into biv_tmp_rt1 ( report_code,session_id, rowno, col4, col6,
1027: col8, col10, col20)
1028: select 'BIV_CUSTOMER_BACKLOG', x_session, max(rowno)+1,sum(col4),
1029: sum(col6), sum(col8), sum(col10), 'TTL_ROW'
1030: from biv_tmp_rt1

Line 1030: from biv_tmp_rt1

1026: insert into biv_tmp_rt1 ( report_code,session_id, rowno, col4, col6,
1027: col8, col10, col20)
1028: select 'BIV_CUSTOMER_BACKLOG', x_session, max(rowno)+1,sum(col4),
1029: sum(col6), sum(col8), sum(col10), 'TTL_ROW'
1030: from biv_tmp_rt1
1031: where session_id = x_session
1032: and col20 = 'INDV_ROW'
1033: and report_code = 'BIV_CUSTOMER_BACKLOG';
1034:

Line 1038: update biv_tmp_rt1 d

1034:
1035: l_new_param_str := 'BIV_SERVICE_REQUEST' ||biv_core_pkg.g_param_sep ||
1036: biv_core_pkg.reconstruct_param_str;
1037: l_ttl_meaning := biv_core_pkg.get_lookup_meaning('TOTAL');
1038: update biv_tmp_rt1 d
1039: set col3=l_new_param_str||
1040: 'P_UNOWN'|| biv_core_pkg.g_value_sep ||
1041: 'Y'||
1042: biv_core_pkg.g_param_sep||'P_BLOG'|| biv_core_pkg.g_value_sep ||