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_QUEUE_DETAIL_REPORT dependencies on BIX_UTIL_PKG

Line 77: , bix_util_pkg.get_hrmiss_frmt(SUM(ABANDON_TIME)/SUM(CALLS_ABANDONED))

73: , NULL
74: , decode(SUM(CALLS_OFFERED), NULL, 0, SUM(CALLS_OFFERED))
75: , decode(SUM(CALLS_ABANDONED), NULL, 0, SUM(CALLS_ABANDONED))
76: , decode(SUM(CALLS_ANSWRD_WITHIN_X_TIME), NULL, 0, SUM(CALLS_ANSWRD_WITHIN_X_TIME))
77: , bix_util_pkg.get_hrmiss_frmt(SUM(ABANDON_TIME)/SUM(CALLS_ABANDONED))
78: ,bix_util_pkg.get_hrmiss_frmt(SUM(QUEUE_TIME_ANSWERED)/decode(SUM(calls_answered), 0, 1, SUM(calls_answered)))
79: ,bix_util_pkg.get_hrmiss_frmt(SUM(talk_time)/ DECODE(SUM(calls_handled),0,1,SUM(calls_handled)))
80: from bix_dm_real_queue_sum
81: where classification_id = v_classification_id

Line 78: ,bix_util_pkg.get_hrmiss_frmt(SUM(QUEUE_TIME_ANSWERED)/decode(SUM(calls_answered), 0, 1, SUM(calls_answered)))

74: , decode(SUM(CALLS_OFFERED), NULL, 0, SUM(CALLS_OFFERED))
75: , decode(SUM(CALLS_ABANDONED), NULL, 0, SUM(CALLS_ABANDONED))
76: , decode(SUM(CALLS_ANSWRD_WITHIN_X_TIME), NULL, 0, SUM(CALLS_ANSWRD_WITHIN_X_TIME))
77: , bix_util_pkg.get_hrmiss_frmt(SUM(ABANDON_TIME)/SUM(CALLS_ABANDONED))
78: ,bix_util_pkg.get_hrmiss_frmt(SUM(QUEUE_TIME_ANSWERED)/decode(SUM(calls_answered), 0, 1, SUM(calls_answered)))
79: ,bix_util_pkg.get_hrmiss_frmt(SUM(talk_time)/ DECODE(SUM(calls_handled),0,1,SUM(calls_handled)))
80: from bix_dm_real_queue_sum
81: where classification_id = v_classification_id
82: and session_id = g_session_id

Line 79: ,bix_util_pkg.get_hrmiss_frmt(SUM(talk_time)/ DECODE(SUM(calls_handled),0,1,SUM(calls_handled)))

75: , decode(SUM(CALLS_ABANDONED), NULL, 0, SUM(CALLS_ABANDONED))
76: , decode(SUM(CALLS_ANSWRD_WITHIN_X_TIME), NULL, 0, SUM(CALLS_ANSWRD_WITHIN_X_TIME))
77: , bix_util_pkg.get_hrmiss_frmt(SUM(ABANDON_TIME)/SUM(CALLS_ABANDONED))
78: ,bix_util_pkg.get_hrmiss_frmt(SUM(QUEUE_TIME_ANSWERED)/decode(SUM(calls_answered), 0, 1, SUM(calls_answered)))
79: ,bix_util_pkg.get_hrmiss_frmt(SUM(talk_time)/ DECODE(SUM(calls_handled),0,1,SUM(calls_handled)))
80: from bix_dm_real_queue_sum
81: where classification_id = v_classification_id
82: and session_id = g_session_id
83: and period_start_date_time between p_start_period and p_end_period

Line 114: , bix_util_pkg.get_hrmiss_frmt(SUM(ABANDON_TIME)/SUM(CALLS_ABANDONED))

110: 4,to_char(to_date(floor(substr(period_start_time,1,2) / 4) * 4, 'hh24:mi'), 'hh24:miAM'), period_start_date_time)
111: , decode(sum(CALLS_OFFERED), NULL, 0, sum(CALLS_OFFERED))
112: , decode(sum(CALLS_ABANDONED), NULL, 0,sum(CALLS_ABANDONED))
113: , decode(sum(CALLS_ANSWRD_WITHIN_X_TIME), NULL, 0,sum(CALLS_ANSWRD_WITHIN_X_TIME))
114: , bix_util_pkg.get_hrmiss_frmt(SUM(ABANDON_TIME)/SUM(CALLS_ABANDONED))
115: ,bix_util_pkg.get_hrmiss_frmt(SUM(QUEUE_TIME_ANSWERED)/decode(SUM(calls_answered), 0, 1, SUM(calls_answered)))
116: ,bix_util_pkg.get_hrmiss_frmt(SUM(talk_time)/ DECODE(SUM(calls_handled),0,1,SUM(calls_handled)))
117: from bix_dm_real_queue_sum
118: where classification_id = v_classification_id

Line 115: ,bix_util_pkg.get_hrmiss_frmt(SUM(QUEUE_TIME_ANSWERED)/decode(SUM(calls_answered), 0, 1, SUM(calls_answered)))

111: , decode(sum(CALLS_OFFERED), NULL, 0, sum(CALLS_OFFERED))
112: , decode(sum(CALLS_ABANDONED), NULL, 0,sum(CALLS_ABANDONED))
113: , decode(sum(CALLS_ANSWRD_WITHIN_X_TIME), NULL, 0,sum(CALLS_ANSWRD_WITHIN_X_TIME))
114: , bix_util_pkg.get_hrmiss_frmt(SUM(ABANDON_TIME)/SUM(CALLS_ABANDONED))
115: ,bix_util_pkg.get_hrmiss_frmt(SUM(QUEUE_TIME_ANSWERED)/decode(SUM(calls_answered), 0, 1, SUM(calls_answered)))
116: ,bix_util_pkg.get_hrmiss_frmt(SUM(talk_time)/ DECODE(SUM(calls_handled),0,1,SUM(calls_handled)))
117: from bix_dm_real_queue_sum
118: where classification_id = v_classification_id
119: and session_id = g_session_id

Line 116: ,bix_util_pkg.get_hrmiss_frmt(SUM(talk_time)/ DECODE(SUM(calls_handled),0,1,SUM(calls_handled)))

112: , decode(sum(CALLS_ABANDONED), NULL, 0,sum(CALLS_ABANDONED))
113: , decode(sum(CALLS_ANSWRD_WITHIN_X_TIME), NULL, 0,sum(CALLS_ANSWRD_WITHIN_X_TIME))
114: , bix_util_pkg.get_hrmiss_frmt(SUM(ABANDON_TIME)/SUM(CALLS_ABANDONED))
115: ,bix_util_pkg.get_hrmiss_frmt(SUM(QUEUE_TIME_ANSWERED)/decode(SUM(calls_answered), 0, 1, SUM(calls_answered)))
116: ,bix_util_pkg.get_hrmiss_frmt(SUM(talk_time)/ DECODE(SUM(calls_handled),0,1,SUM(calls_handled)))
117: from bix_dm_real_queue_sum
118: where classification_id = v_classification_id
119: and session_id = g_session_id
120: and classification_id = g_classification_id

Line 169: , bix_util_pkg.get_hrmiss_frmt(SUM(ABANDON_TIME)/SUM(CALLS_ABANDONED))

165: , NULL
166: , decode(SUM(CALLS_OFFERED), NULL, 0, SUM(CALLS_OFFERED))
167: , decode(SUM(CALLS_ABANDONED), NULL, 0, SUM(CALLS_ABANDONED))
168: , decode(SUM(CALLS_ANSWRD_WITHIN_X_TIME), NULL, 0, SUM(CALLS_ANSWRD_WITHIN_X_TIME))
169: , bix_util_pkg.get_hrmiss_frmt(SUM(ABANDON_TIME)/SUM(CALLS_ABANDONED))
170: ,bix_util_pkg.get_hrmiss_frmt(SUM(QUEUE_TIME_ANSWERED)/decode(SUM(calls_answered), 0, 1, SUM(calls_answered)))
171: ,bix_util_pkg.get_hrmiss_frmt(SUM(talk_time)/ DECODE(SUM(calls_handled),0,1,SUM(calls_handled)))
172: from bix_dm_real_queue_sum
173: where ( classification_id is null or classification_id not in

Line 170: ,bix_util_pkg.get_hrmiss_frmt(SUM(QUEUE_TIME_ANSWERED)/decode(SUM(calls_answered), 0, 1, SUM(calls_answered)))

166: , decode(SUM(CALLS_OFFERED), NULL, 0, SUM(CALLS_OFFERED))
167: , decode(SUM(CALLS_ABANDONED), NULL, 0, SUM(CALLS_ABANDONED))
168: , decode(SUM(CALLS_ANSWRD_WITHIN_X_TIME), NULL, 0, SUM(CALLS_ANSWRD_WITHIN_X_TIME))
169: , bix_util_pkg.get_hrmiss_frmt(SUM(ABANDON_TIME)/SUM(CALLS_ABANDONED))
170: ,bix_util_pkg.get_hrmiss_frmt(SUM(QUEUE_TIME_ANSWERED)/decode(SUM(calls_answered), 0, 1, SUM(calls_answered)))
171: ,bix_util_pkg.get_hrmiss_frmt(SUM(talk_time)/ DECODE(SUM(calls_handled),0,1,SUM(calls_handled)))
172: from bix_dm_real_queue_sum
173: where ( classification_id is null or classification_id not in
174: (select distinct classification_id

Line 171: ,bix_util_pkg.get_hrmiss_frmt(SUM(talk_time)/ DECODE(SUM(calls_handled),0,1,SUM(calls_handled)))

167: , decode(SUM(CALLS_ABANDONED), NULL, 0, SUM(CALLS_ABANDONED))
168: , decode(SUM(CALLS_ANSWRD_WITHIN_X_TIME), NULL, 0, SUM(CALLS_ANSWRD_WITHIN_X_TIME))
169: , bix_util_pkg.get_hrmiss_frmt(SUM(ABANDON_TIME)/SUM(CALLS_ABANDONED))
170: ,bix_util_pkg.get_hrmiss_frmt(SUM(QUEUE_TIME_ANSWERED)/decode(SUM(calls_answered), 0, 1, SUM(calls_answered)))
171: ,bix_util_pkg.get_hrmiss_frmt(SUM(talk_time)/ DECODE(SUM(calls_handled),0,1,SUM(calls_handled)))
172: from bix_dm_real_queue_sum
173: where ( classification_id is null or classification_id not in
174: (select distinct classification_id
175: from cct_classifications))

Line 209: , bix_util_pkg.get_hrmiss_frmt(SUM(ABANDON_TIME)/SUM(CALLS_ABANDONED))

205: 4,to_char(to_date(floor(substr(period_start_time,1,2) / 4) * 4, 'hh24:mi'), 'hh24:miAM'), period_start_date_time)
206: , decode(sum(CALLS_OFFERED), NULL, 0, sum(CALLS_OFFERED))
207: , decode(sum(CALLS_ABANDONED), NULL, 0,sum(CALLS_ABANDONED))
208: , decode(sum(CALLS_ANSWRD_WITHIN_X_TIME), NULL, 0,sum(CALLS_ANSWRD_WITHIN_X_TIME))
209: , bix_util_pkg.get_hrmiss_frmt(SUM(ABANDON_TIME)/SUM(CALLS_ABANDONED))
210: ,bix_util_pkg.get_hrmiss_frmt(SUM(QUEUE_TIME_ANSWERED)/decode(SUM(calls_answered), 0, 1, SUM(calls_answered)))
211: ,bix_util_pkg.get_hrmiss_frmt(SUM(talk_time)/ DECODE(SUM(calls_handled),0,1,SUM(calls_handled)))
212: from bix_dm_real_queue_sum
213: where (classification_id is null or classification_id not in

Line 210: ,bix_util_pkg.get_hrmiss_frmt(SUM(QUEUE_TIME_ANSWERED)/decode(SUM(calls_answered), 0, 1, SUM(calls_answered)))

206: , decode(sum(CALLS_OFFERED), NULL, 0, sum(CALLS_OFFERED))
207: , decode(sum(CALLS_ABANDONED), NULL, 0,sum(CALLS_ABANDONED))
208: , decode(sum(CALLS_ANSWRD_WITHIN_X_TIME), NULL, 0,sum(CALLS_ANSWRD_WITHIN_X_TIME))
209: , bix_util_pkg.get_hrmiss_frmt(SUM(ABANDON_TIME)/SUM(CALLS_ABANDONED))
210: ,bix_util_pkg.get_hrmiss_frmt(SUM(QUEUE_TIME_ANSWERED)/decode(SUM(calls_answered), 0, 1, SUM(calls_answered)))
211: ,bix_util_pkg.get_hrmiss_frmt(SUM(talk_time)/ DECODE(SUM(calls_handled),0,1,SUM(calls_handled)))
212: from bix_dm_real_queue_sum
213: where (classification_id is null or classification_id not in
214: (select distinct classification_id

Line 211: ,bix_util_pkg.get_hrmiss_frmt(SUM(talk_time)/ DECODE(SUM(calls_handled),0,1,SUM(calls_handled)))

207: , decode(sum(CALLS_ABANDONED), NULL, 0,sum(CALLS_ABANDONED))
208: , decode(sum(CALLS_ANSWRD_WITHIN_X_TIME), NULL, 0,sum(CALLS_ANSWRD_WITHIN_X_TIME))
209: , bix_util_pkg.get_hrmiss_frmt(SUM(ABANDON_TIME)/SUM(CALLS_ABANDONED))
210: ,bix_util_pkg.get_hrmiss_frmt(SUM(QUEUE_TIME_ANSWERED)/decode(SUM(calls_answered), 0, 1, SUM(calls_answered)))
211: ,bix_util_pkg.get_hrmiss_frmt(SUM(talk_time)/ DECODE(SUM(calls_handled),0,1,SUM(calls_handled)))
212: from bix_dm_real_queue_sum
213: where (classification_id is null or classification_id not in
214: (select distinct classification_id
215: from cct_classifications))

Line 279: g_session_id := bix_util_pkg.get_icx_session_id; /* get current session id */

275: end if;
276:
277:
278: g_drilldown := 0; /* drilldown default to yes */
279: g_session_id := bix_util_pkg.get_icx_session_id; /* get current session id */
280: BIX_DM_REAL_QUEUE_SUMMARY_PKG.get_calls(g_session_id);
281: /* get the classification id for the clicked row or data */
282: v_parent := jtfb_dcf.get_parameter_value(p_context, 'pContext');
283: /* to make the report listing link work */