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_UTIL_PKG

Line 74: l_session_id:= bix_util_pkg.get_icx_session_id;

70:
71: l_date_low := trunc(sysdate);
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';

Line 84: l_string := bix_util_pkg.get_parameter_value(p_context,'pContext');

80: /* drill down from queue status bin, queue status report itself.
81: to queue status report itself, agent status report, queue detail */
82:
83: /* try to get incoming parameter(s) */
84: l_string := bix_util_pkg.get_parameter_value(p_context,'pContext');
85:
86: if l_string is not null /*parameter got*/
87: then
88: l_string2 := substr(l_string,2,1);

Line 101: v_classification_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_CLASSIFICATION_ID'));

97: v_site_id := -999;
98: v_group_id := -999;
99: end if;
100: else
101: v_classification_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_CLASSIFICATION_ID'));
102: v_site_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_SITE_ID'));
103: v_group_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_GROUP_ID'));
104: end if;
105:

Line 102: v_site_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_SITE_ID'));

98: v_group_id := -999;
99: end if;
100: else
101: v_classification_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_CLASSIFICATION_ID'));
102: v_site_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_SITE_ID'));
103: v_group_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_GROUP_ID'));
104: end if;
105:
106:

Line 103: v_group_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_GROUP_ID'));

99: end if;
100: else
101: v_classification_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_CLASSIFICATION_ID'));
102: v_site_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_SITE_ID'));
103: v_group_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_GROUP_ID'));
104: end if;
105:
106:
107: /* If the user has selected "All" for agent group paramter , display the default group

Line 428: l_string2:= bix_util_pkg.get_hrmiss_frmt(longestCallWaiting);

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);
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);

Line 434: l_string2:= bix_util_pkg.get_hrmiss_frmt(avgQtime);

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);
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);

Line 441: l_string:= bix_util_pkg.get_hrmiss_frmt(avgAbandonTime);

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:
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:

Line 446: l_string := bix_util_pkg.get_hrmiss_frmt(avgSpeedToAnswer);

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);
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,

Line 453: l_string := bix_util_pkg.get_hrmiss_frmt(avgTalkTime);

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);
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);

Line 462: select bix_util_pkg.get_null_lookup into l_string2 from dual;

458:
459: /*
460: numRowRTmeasure := 6;
461: i :=0;
462: select bix_util_pkg.get_null_lookup into l_string2 from dual;
463: for rec in getCallsWaitingForClass loop
464: if rec.class is null then l_string:= l_string2;
465: else l_string :=rec.class;
466: end if;

Line 826: l_session_id:= bix_util_pkg.get_icx_session_id;

822:
823: l_date_low := trunc(sysdate);
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';

Line 833: l_string := bix_util_pkg.get_parameter_value(p_context,'pContext');

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 */
833: l_string := bix_util_pkg.get_parameter_value(p_context,'pContext');
834: if l_string is null then /* not drilled down */
835: v_display_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_DISPLAY_ID'));
836: v_resource_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_RESOURCE_ID'));
837: else

Line 835: v_display_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_DISPLAY_ID'));

831:
832: /* check if drilled down from q status or agent status report */
833: l_string := bix_util_pkg.get_parameter_value(p_context,'pContext');
834: if l_string is null then /* not drilled down */
835: v_display_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_DISPLAY_ID'));
836: v_resource_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_RESOURCE_ID'));
837: else
838: if l_string= 'BIX_AGENT_DETAIL_RPT' then v_resource_id := NULL;
839: else v_resource_id := to_number(l_string);

Line 836: v_resource_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_RESOURCE_ID'));

832: /* check if drilled down from q status or agent status report */
833: l_string := bix_util_pkg.get_parameter_value(p_context,'pContext');
834: if l_string is null then /* not drilled down */
835: v_display_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_DISPLAY_ID'));
836: v_resource_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_RESOURCE_ID'));
837: else
838: if l_string= 'BIX_AGENT_DETAIL_RPT' then v_resource_id := NULL;
839: else v_resource_id := to_number(l_string);
840: v_display_id := 1;

Line 904: l_string := bix_util_pkg.get_hrmiss_frmt(v_duration);

900: end if;
901:
902: if (v_duration>60*60*24) then l_string := '>24 Hours';
903: else
904: l_string := bix_util_pkg.get_hrmiss_frmt(v_duration);
905: end if;
906:
907: select count(I2.media_id) into CallsHandled
908: from IEU_SH_SESSIONS I1,

Line 931: l_string := bix_util_pkg.get_hrmiss_frmt(v_duration);

927: select agent_name into l_agent_name
928: from BIX_DM_AGENT_PARAM_V
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);

Line 949: l_string := bix_util_pkg.get_hrmiss_frmt(LoginTime);

945: idle);
946:
947: if LoginTime>24*3600 then l_string := '>24 Hours';
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);

Line 969: l_string := bix_util_pkg.get_hrmiss_frmt(rec.LoginTime);

965: i:=0;
966: for rec in getLogoutTime
967: loop
968:
969: l_string := bix_util_pkg.get_hrmiss_frmt(rec.LoginTime);
970: l_string2 := bix_util_pkg.get_hrmiss_frmt(rec.LogoutTime);
971:
972: select F.meaning into LogoutReason
973: from FND_LOOKUP_VALUES F

Line 970: l_string2 := bix_util_pkg.get_hrmiss_frmt(rec.LogoutTime);

966: for rec in getLogoutTime
967: loop
968:
969: l_string := bix_util_pkg.get_hrmiss_frmt(rec.LoginTime);
970: l_string2 := bix_util_pkg.get_hrmiss_frmt(rec.LogoutTime);
971:
972: select F.meaning into LogoutReason
973: from FND_LOOKUP_VALUES F
974: where F.lookup_code = rec.reason

Line 1004: l_string := bix_util_pkg.get_hrmiss_frmt(rec.LogoutTime-rec.LoginTime);

1000: i:=0;
1001: for rec in getLogoutTime
1002: loop
1003:
1004: l_string := bix_util_pkg.get_hrmiss_frmt(rec.LogoutTime-rec.LoginTime);
1005:
1006: select F.meaning into LogoutReason
1007: from FND_LOOKUP_VALUES F
1008: where F.lookup_code = rec.reason

Line 1243: l_session_id:= bix_util_pkg.get_icx_session_id;

1239:
1240: /*************** begin ************************/
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';

Line 1256: l_string := bix_util_pkg.get_parameter_value(p_context,'pContext');

1252:
1253:
1254: /* drill down from agent status bin, q status report */
1255: /* try to get incoming parameter(s) */
1256: l_string := bix_util_pkg.get_parameter_value(p_context,'pContext');
1257:
1258: if l_string is not null /*parameter got*/
1259: then
1260: l_string2 := substr(l_string,2,1);

Line 1274: v_classification:= to_number(bix_util_pkg.get_parameter_value(p_context,'P_CLASSIFICATION_ID'));

1270: v_group_id := -999;
1271: end if;
1272: else
1273: /*
1274: v_classification:= to_number(bix_util_pkg.get_parameter_value(p_context,'P_CLASSIFICATION_ID'));
1275: */
1276: v_site_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_SITE_ID'));
1277: v_status_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_STATUS_ID'));
1278: v_group_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_GROUP_ID'));

Line 1276: v_site_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_SITE_ID'));

1272: else
1273: /*
1274: v_classification:= to_number(bix_util_pkg.get_parameter_value(p_context,'P_CLASSIFICATION_ID'));
1275: */
1276: v_site_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_SITE_ID'));
1277: v_status_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_STATUS_ID'));
1278: v_group_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_GROUP_ID'));
1279: end if;
1280:

Line 1277: v_status_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_STATUS_ID'));

1273: /*
1274: v_classification:= to_number(bix_util_pkg.get_parameter_value(p_context,'P_CLASSIFICATION_ID'));
1275: */
1276: v_site_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_SITE_ID'));
1277: v_status_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_STATUS_ID'));
1278: v_group_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_GROUP_ID'));
1279: end if;
1280:
1281:

Line 1278: v_group_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_GROUP_ID'));

1274: v_classification:= to_number(bix_util_pkg.get_parameter_value(p_context,'P_CLASSIFICATION_ID'));
1275: */
1276: v_site_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_SITE_ID'));
1277: v_status_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_STATUS_ID'));
1278: v_group_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_GROUP_ID'));
1279: end if;
1280:
1281:
1282: select bix_util_pkg.get_null_lookup into l_unknown

Line 1282: select bix_util_pkg.get_null_lookup into l_unknown

1278: v_group_id := to_number(bix_util_pkg.get_parameter_value(p_context,'P_GROUP_ID'));
1279: end if;
1280:
1281:
1282: select bix_util_pkg.get_null_lookup into l_unknown
1283: from dual;
1284:
1285: /* If the user has selected "All" for agent group paramter , display the default group of the user */
1286: IF (v_group_id = -999 or v_group_id is null) THEN

Line 1326: l_timestring := bix_util_pkg.get_hrmiss_frmt(rec.talkTime);

1322: if (v_status_id=3 or v_status_id=-999) then
1323: for rec in getTalkAgentList
1324: loop
1325: reportcode := reportcode +1;
1326: l_timestring := bix_util_pkg.get_hrmiss_frmt(rec.talkTime);
1327: /* for null group name or an agent is not assigned to any group */
1328: /*
1329: l_groupName := l_unknown;
1330: l_agentId := rec.agentID;

Line 1352: l_timestring := bix_util_pkg.get_hrmiss_frmt(rec.wrapTime);

1348:
1349: for rec in getWrapAgentList
1350: loop
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,

Line 1367: l_timestring := bix_util_pkg.get_hrmiss_frmt(rec.availTime);

1363: if (v_status_id=2 or v_status_id=-999) then
1364: for rec in getAvailableAgentList
1365: loop
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)

Line 1385: l_timestring := bix_util_pkg.get_hrmiss_frmt(trunc(rec.idleTime));

1381: loop
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,' ',' ');

Line 1413: bix_util_pkg.get_hrmiss_frmt(rec.loggedoutTime),' ',logoutreason);

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;
1416: end if;
1417: