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.BIX_REAL_TIME_RPTS_PKG dependencies on BIX_DM_REPORT

Line 76: delete from BIX_DM_REPORT

72: l_date_high := sysdate;
73:
74: l_session_id:= bix_util_pkg.get_icx_session_id;
75:
76: delete from BIX_DM_REPORT
77: where session_id = l_session_id
78: and report_code = 'BIX_QUEUE_STATUS_RPT';
79:
80: /* drill down from queue status bin, queue status report itself.

Line 424: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4, col6, col8, col10, col12, col14, col16, col18, col20, col22, col24)

420: /* for parameter passing */
421: pstring := 'G' || to_char(v_group_id) || 'C' ||to_char(v_classification_id) || 'S' || to_char(v_site_id) ;
422:
423: /* Make sure check col1 for bixxqstr.jsp seeding */
424: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4, col6, col8, col10, col12, col14, col16, col18, col20, col22, col24)
425: values (l_session_id,'BIX_QUEUE_STATUS_RPT','1' || pstring , 'Calls Waiting', callsWaiting,
426: 'Calls Offered', callsOffered,'', calls_range1, calls_range2, calls_range3, calls_range4, calls_range5, calls_range6, calls_range7);
427:
428: l_string2:= bix_util_pkg.get_hrmiss_frmt(longestCallWaiting);

Line 430: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4, col6, col8,col10, col12)

426: 'Calls Offered', callsOffered,'', calls_range1, calls_range2, calls_range3, calls_range4, calls_range5, calls_range6, calls_range7);
427:
428: l_string2:= bix_util_pkg.get_hrmiss_frmt(longestCallWaiting);
429:
430: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4, col6, col8,col10, col12)
431: values (l_session_id,'BIX_QUEUE_STATUS_RPT','2' || pstring, 'Longest Call Waiting', l_string2,
432: 'Abandon Calls', abandonCalls, null, null);
433:
434: l_string2:= bix_util_pkg.get_hrmiss_frmt(avgQtime);

Line 436: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4, col6, col8,col10, col12)

432: 'Abandon Calls', abandonCalls, null, null);
433:
434: l_string2:= bix_util_pkg.get_hrmiss_frmt(avgQtime);
435:
436: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4, col6, col8,col10, col12)
437: values (l_session_id,'BIX_QUEUE_STATUS_RPT','3' || pstring, 'Average Queue Time', l_string2,
438: 'Calls within Service Level', callsSrvLevel,null, null);
439:
440:

Line 442: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4, col6, col8,col10, col12)

438: 'Calls within Service Level', callsSrvLevel,null, null);
439:
440:
441: l_string:= bix_util_pkg.get_hrmiss_frmt(avgAbandonTime);
442: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4, col6, col8,col10, col12)
443: values (l_session_id,'BIX_QUEUE_STATUS_RPT','4'|| pstring, 'Talking Agents', talk_graph,
444: 'Average abandon Time', l_string, null, null);
445:
446: l_string := bix_util_pkg.get_hrmiss_frmt(avgSpeedToAnswer);

Line 449: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4, col6, col8,col10, col12)

445:
446: l_string := bix_util_pkg.get_hrmiss_frmt(avgSpeedToAnswer);
447:
448:
449: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4, col6, col8,col10, col12)
450: values (l_session_id,'BIX_QUEUE_STATUS_RPT','5', '', null,
451: 'Average Speed To Answer', l_string,null, null);
452:
453: l_string := bix_util_pkg.get_hrmiss_frmt(avgTalkTime);

Line 455: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4, col6, col8,col10, col12)

451: 'Average Speed To Answer', l_string,null, null);
452:
453: l_string := bix_util_pkg.get_hrmiss_frmt(avgTalkTime);
454:
455: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4, col6, col8,col10, col12)
456: values (l_session_id,'BIX_QUEUE_STATUS_RPT','6', '', null,
457: 'Average Talk Time', l_string,null, null);
458:
459: /*

Line 469: update BIX_DM_REPORT set col10=l_string, col12=calls_range1

465: else l_string :=rec.class;
466: end if;
467: i :=i+1;
468: if i<=numRowRTmeasure then
469: update BIX_DM_REPORT set col10=l_string, col12=calls_range1
470: where col1 like to_char(i) || '%';
471: else insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4, col6, col8,col10, col12)
472: values (l_session_id,'BIX_QUEUE_STATUS_RPT', i ,null,null,null,null,l_string,rec.calls);
473: end if;

Line 471: else insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4, col6, col8,col10, col12)

467: i :=i+1;
468: if i<=numRowRTmeasure then
469: update BIX_DM_REPORT set col10=l_string, col12=calls_range1
470: where col1 like to_char(i) || '%';
471: else insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4, col6, col8,col10, col12)
472: values (l_session_id,'BIX_QUEUE_STATUS_RPT', i ,null,null,null,null,l_string,rec.calls);
473: end if;
474: end loop;
475: */

Line 626: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

622:
623: BEGIN
624:
625: if i=3 then
626: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
627: values (l_session_id,'BIX_AGENT_DETAIL_RPT',5,null, null,
628: 'Out', p_out);
629: elsif i=2 then
630: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

Line 630: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

626: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
627: values (l_session_id,'BIX_AGENT_DETAIL_RPT',5,null, null,
628: 'Out', p_out);
629: elsif i=2 then
630: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
631: values (l_session_id,'BIX_AGENT_DETAIL_RPT',4,null, null,
632: 'Idle', idle);
633: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
634: values (l_session_id,'BIX_AGENT_DETAIL_RPT',5,null, null,

Line 633: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

629: elsif i=2 then
630: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
631: values (l_session_id,'BIX_AGENT_DETAIL_RPT',4,null, null,
632: 'Idle', idle);
633: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
634: values (l_session_id,'BIX_AGENT_DETAIL_RPT',5,null, null,
635: 'Out', p_out);
636: elsif i=1 then
637: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

Line 637: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

633: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
634: values (l_session_id,'BIX_AGENT_DETAIL_RPT',5,null, null,
635: 'Out', p_out);
636: elsif i=1 then
637: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
638: values (l_session_id,'BIX_AGENT_DETAIL_RPT',3,null, null,
639: 'Available', available);
640: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
641: values (l_session_id,'BIX_AGENT_DETAIL_RPT',4,null, null,

Line 640: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

636: elsif i=1 then
637: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
638: values (l_session_id,'BIX_AGENT_DETAIL_RPT',3,null, null,
639: 'Available', available);
640: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
641: values (l_session_id,'BIX_AGENT_DETAIL_RPT',4,null, null,
642: 'Idle', idle);
643: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
644: values (l_session_id,'BIX_AGENT_DETAIL_RPT',5,null, null,

Line 643: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

639: 'Available', available);
640: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
641: values (l_session_id,'BIX_AGENT_DETAIL_RPT',4,null, null,
642: 'Idle', idle);
643: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
644: values (l_session_id,'BIX_AGENT_DETAIL_RPT',5,null, null,
645: 'Out', p_out);
646: elsif i=0 then
647: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

Line 647: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

643: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
644: values (l_session_id,'BIX_AGENT_DETAIL_RPT',5,null, null,
645: 'Out', p_out);
646: elsif i=0 then
647: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
648: values (l_session_id,'BIX_AGENT_DETAIL_RPT',2,null, null,
649: 'Wrap', wrap);
650: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
651: values (l_session_id,'BIX_AGENT_DETAIL_RPT',3,null, null,

Line 650: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

646: elsif i=0 then
647: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
648: values (l_session_id,'BIX_AGENT_DETAIL_RPT',2,null, null,
649: 'Wrap', wrap);
650: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
651: values (l_session_id,'BIX_AGENT_DETAIL_RPT',3,null, null,
652: 'Available', available);
653: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
654: values (l_session_id,'BIX_AGENT_DETAIL_RPT',4,null, null,

Line 653: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

649: 'Wrap', wrap);
650: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
651: values (l_session_id,'BIX_AGENT_DETAIL_RPT',3,null, null,
652: 'Available', available);
653: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
654: values (l_session_id,'BIX_AGENT_DETAIL_RPT',4,null, null,
655: 'Idle', idle);
656: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
657: values (l_session_id,'BIX_AGENT_DETAIL_RPT',5,null, null,

Line 656: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

652: 'Available', available);
653: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
654: values (l_session_id,'BIX_AGENT_DETAIL_RPT',4,null, null,
655: 'Idle', idle);
656: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
657: values (l_session_id,'BIX_AGENT_DETAIL_RPT',5,null, null,
658: 'Out', p_out);
659: end if;
660:

Line 828: delete from BIX_DM_REPORT

824: l_date_high := sysdate;
825:
826: l_session_id:= bix_util_pkg.get_icx_session_id;
827:
828: delete from BIX_DM_REPORT
829: where session_id = l_session_id
830: and report_code = 'BIX_AGENT_DETAIL_RPT';
831:
832: /* check if drilled down from q status or agent status report */

Line 933: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

929: where agent_id = v_resource_id;
930:
931: l_string := bix_util_pkg.get_hrmiss_frmt(v_duration);
932:
933: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
934: values (l_session_id,'BIX_AGENT_DETAIL_RPT',1, 'Agent Name', l_agent_name,'Talk',
935: talk);
936:
937: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

Line 937: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

933: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
934: values (l_session_id,'BIX_AGENT_DETAIL_RPT',1, 'Agent Name', l_agent_name,'Talk',
935: talk);
936:
937: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
938: values (l_session_id,'BIX_AGENT_DETAIL_RPT',2, 'Current Status', v_status,'Wrap',
939: wrap);
940: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
941: values (l_session_id,'BIX_AGENT_DETAIL_RPT',3, 'Duration in Status', l_string,'Available',available);

Line 940: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

936:
937: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
938: values (l_session_id,'BIX_AGENT_DETAIL_RPT',2, 'Current Status', v_status,'Wrap',
939: wrap);
940: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
941: values (l_session_id,'BIX_AGENT_DETAIL_RPT',3, 'Duration in Status', l_string,'Available',available);
942:
943: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
944: values (l_session_id,'BIX_AGENT_DETAIL_RPT',4,'Calls Handled',CallsHandled,'Idle',

Line 943: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

939: wrap);
940: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
941: values (l_session_id,'BIX_AGENT_DETAIL_RPT',3, 'Duration in Status', l_string,'Available',available);
942:
943: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
944: values (l_session_id,'BIX_AGENT_DETAIL_RPT',4,'Calls Handled',CallsHandled,'Idle',
945: idle);
946:
947: if LoginTime>24*3600 then l_string := '>24 Hours';

Line 952: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

948: else
949: l_string := bix_util_pkg.get_hrmiss_frmt(LoginTime);
950: end if;
951:
952: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
953: values (l_session_id,'BIX_AGENT_DETAIL_RPT',5,'Login Time', l_string,'Out',l_out);
954:
955: end if; /* of display 1 */
956:

Line 961: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

957: /******************time Card *********************************************/
958:
959: if v_display_id= 2 then
960:
961: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
962: values (l_session_id,'BIX_AGENT_DETAIL_RPT',1,'Login/Logout Time', 'Reason',
963: 'Talk',talk);
964:
965: i:=0;

Line 984: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

980: elsif i=3 then l_string3 := 'Idle'; j:=idle;
981: else l_string3 := 'Out'; j:=l_out;
982: end if;
983:
984: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
985: values (l_session_id,'BIX_AGENT_DETAIL_RPT',i+1,l_string || '/' || l_string2, LogoutReason,
986: l_string3, j);
987:
988: end loop;

Line 997: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

993:
994: /******************Checkout duration**************************************/
995: if v_display_id=3 then
996:
997: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
998: values (l_session_id,'BIX_AGENT_DETAIL_RPT',1,'Check Out Reason', 'Duration',
999: 'Talk',talk);
1000: i:=0;
1001: for rec in getLogoutTime

Line 1018: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

1014: elsif i=3 then l_string3 := 'Idle'; j:=idle;
1015: else l_string3 := 'Out'; j:=l_out;
1016: end if;
1017:
1018: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
1019: values (l_session_id,'BIX_AGENT_DETAIL_RPT', i+1, LogoutReason, l_string ,l_string3,j);
1020: end loop;
1021:
1022: insertRowsForGraph(i, l_session_id, available, talk, wrap, idle, l_out);

Line 1031: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

1027: if v_display_id =4 then
1028:
1029: i:=0;
1030:
1031: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
1032: values (l_session_id,'BIX_AGENT_DETAIL_RPT',1,'Skill', 'Level',
1033: null,null);
1034: for skilldata in getAgentSkills LOOP
1035: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

Line 1035: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

1031: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
1032: values (l_session_id,'BIX_AGENT_DETAIL_RPT',1,'Skill', 'Level',
1033: null,null);
1034: for skilldata in getAgentSkills LOOP
1035: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
1036: values (l_session_id,'BIX_AGENT_DETAIL_RPT',i,skilldata.skillname,skilldata.skilllevel, null, null);
1037: i := i + 1;
1038: end loop;
1039:

Line 1040: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)

1036: values (l_session_id,'BIX_AGENT_DETAIL_RPT',i,skilldata.skillname,skilldata.skilllevel, null, null);
1037: i := i + 1;
1038: end loop;
1039:
1040: insert into BIX_DM_REPORT(session_id,report_code, col1, col2, col4,col6,col8)
1041: values (l_session_id,'BIX_AGENT_DETAIL_RPT',1,'', '',
1042: 'Talk',talk);
1043: i:=0;
1044: /* for ... */

Line 1186: ( select col3 from BIX_DM_REPORT

1182: and (J3.group_id = J4.group_id)
1183: and (J3.group_id = v_group_id)
1184: and (J5.server_group_id = v_site_id or (v_site_id =-999 or v_site_id is null))
1185: and I1.resource_id not in
1186: ( select col3 from BIX_DM_REPORT
1187: where report_code = 'BIX_AGENT_STATUS_REPORT'
1188: and session_id = l_session_id
1189: and (col8 = 'TALK' or col8='WRAP' or col8='AVAILABLE')
1190: )

Line 1234: from BIX_DM_REPORT

1230: where J4.group_id = v_group_id
1231: and J5.resource_id = J4.resource_id
1232: and J5.resource_id not in
1233: (select col3
1234: from BIX_DM_REPORT
1235: where report_code = 'BIX_AGENT_STATUS_REPORT'
1236: and session_id = l_session_id
1237: )
1238: order by J5.resource_name;

Line 1245: delete from BIX_DM_REPORT

1241: BEGIN
1242:
1243: l_session_id:= bix_util_pkg.get_icx_session_id;
1244:
1245: delete from BIX_DM_REPORT
1246: where session_id = l_session_id
1247: and report_code = 'BIX_AGENT_STATUS_REPORT';
1248:
1249: l_date_low := trunc(sysdate);

Line 1339: insert into BIX_DM_REPORT(session_id,report_code, col1, col2,col3, col4,col6, col7, col8, col10, col12,col14)

1335: */
1336: if v_show=1 then l_groupName :=null;
1337: end if; /* only one group name is showing */
1338:
1339: insert into BIX_DM_REPORT(session_id,report_code, col1, col2,col3, col4,col6, col7, col8, col10, col12,col14)
1340: values (l_session_id,'BIX_AGENT_STATUS_REPORT',reportcode,l_groupName, rec.agentID,
1341: rec.agentName, rec.extension,'TALK','TALK',l_timestring,' ', rec.class);
1342: v_show:=1;
1343: end loop;

Line 1355: insert into BIX_DM_REPORT(session_id,report_code, col1, col2,col3, col4,col6, col7, col8, col10,col12,col14)

1351: reportcode := reportcode +1;
1352: l_timestring := bix_util_pkg.get_hrmiss_frmt(rec.wrapTime);
1353: if v_show=1 then l_groupName :=null;
1354: end if;
1355: insert into BIX_DM_REPORT(session_id,report_code, col1, col2,col3, col4,col6, col7, col8, col10,col12,col14)
1356: values (l_session_id,'BIX_AGENT_STATUS_REPORT',reportcode,l_groupName, rec.agentID,rec.agentName,
1357: rec.extension,'WRAP','WRAP',l_timestring,'', '');
1358: v_show :=1;
1359: end loop;

Line 1370: insert into BIX_DM_REPORT(session_id,report_code, col1, col2,col3, col4,col6, col7, col8,

1366: reportcode := reportcode +1;
1367: l_timestring := bix_util_pkg.get_hrmiss_frmt(rec.availTime);
1368: if v_show=1 then l_groupName :=null;
1369: end if;
1370: insert into BIX_DM_REPORT(session_id,report_code, col1, col2,col3, col4,col6, col7, col8,
1371: col10,col12, col14)
1372: values (l_session_id,'BIX_AGENT_STATUS_REPORT',reportcode,l_groupName, rec.agentID,
1373: rec.agentName, rec.extension,'AVAIL','AVAILABLE',l_timestring,' ',' ');
1374: v_show :=1;

Line 1386: insert into BIX_DM_REPORT(session_id,report_code, col1, col2,col3, col4,col6, col7, col8, col10,col12,col14)

1382: reportcode := reportcode +1;
1383: if v_show=1 then l_groupName :=null;
1384: end if;
1385: l_timestring := bix_util_pkg.get_hrmiss_frmt(trunc(rec.idleTime));
1386: insert into BIX_DM_REPORT(session_id,report_code, col1, col2,col3, col4,col6, col7, col8, col10,col12,col14)
1387: values (l_session_id,'BIX_AGENT_STATUS_REPORT',reportcode,l_groupName, rec.agentID,
1388: rec.agentName, rec.extension,'IDLE','IDLE',
1389: l_timestring,' ',' ');
1390:

Line 1411: insert into BIX_DM_REPORT(session_id,report_code, col1, col2,col3, col4,col6, col7, col8, col10,col12,col14)

1407:
1408: if v_show=1 then l_groupName :=null;
1409: end if;
1410:
1411: insert into BIX_DM_REPORT(session_id,report_code, col1, col2,col3, col4,col6, col7, col8, col10,col12,col14)
1412: values (l_session_id,'BIX_AGENT_STATUS_REPORT',reportcode,l_groupName, rec.agentID,rec.agentName, rec.extension,'Out','Out',
1413: bix_util_pkg.get_hrmiss_frmt(rec.loggedoutTime),' ',logoutreason);
1414: v_show :=1;
1415: end loop;

Line 1430: insert into BIX_DM_REPORT(session_id,report_code, col1, col2,col3, col4,col6, col7,

1426:
1427: if v_show=1 then l_groupName :=null;
1428: end if;
1429:
1430: insert into BIX_DM_REPORT(session_id,report_code, col1, col2,col3, col4,col6, col7,
1431: col8, col10,col12,col14)
1432: values(l_session_id,'BIX_AGENT_STATUS_REPORT',reportcode,l_groupName,rec.agentID,rec.agentName,
1433: ' ','None','None',' ',' ',' ');
1434: v_show :=1;