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

Line 99: ' , bix_util_pkg.get_hrmiss_frmt(SUM(login_time))

95: END IF;
96:
97: /* Get the measures */
98: g_sqlstmt := g_sqlstmt ||
99: ' , bix_util_pkg.get_hrmiss_frmt(SUM(login_time))
100: , trunc(SUM(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time)
101: / DECODE(SUM(login_time),0,1,SUM(login_time)) * 100,2)
102: , SUM(in_calls_handled)
103: , trunc(SUM(in_talk_time + in_wrap_time)

Line 105: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + in_wrap_time)

101: / DECODE(SUM(login_time),0,1,SUM(login_time)) * 100,2)
102: , SUM(in_calls_handled)
103: , trunc(SUM(in_talk_time + in_wrap_time)
104: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)), 2)
105: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + in_wrap_time)
106: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)))
107: , trunc(SUM(in_talk_time)
108: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)), 2)
109: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time)

Line 109: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time)

105: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + in_wrap_time)
106: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)))
107: , trunc(SUM(in_talk_time)
108: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)), 2)
109: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time)
110: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)))
111: , trunc(SUM(in_wrap_time)
112: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)), 2)
113: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time)

Line 113: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time)

109: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time)
110: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)))
111: , trunc(SUM(in_wrap_time)
112: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)), 2)
113: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time)
114: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)))
115: , trunc(SUM(available_time + in_talk_time + in_wrap_time)
116: / DECODE(SUM(login_time),0,1,SUM(login_time)) * 100, 2)
117: , SUM(out_calls_handled)

Line 120: , bix_util_pkg.get_hrmiss_frmt(SUM(out_talk_time + out_wrap_time)

116: / DECODE(SUM(login_time),0,1,SUM(login_time)) * 100, 2)
117: , SUM(out_calls_handled)
118: , trunc(SUM(out_talk_time + out_wrap_time)
119: / DECODE(SUM(out_calls_handled),0,1,SUM(out_calls_handled)), 2)
120: , bix_util_pkg.get_hrmiss_frmt(SUM(out_talk_time + out_wrap_time)
121: / DECODE(SUM(out_calls_handled),0,1,SUM(out_calls_handled)))
122: , trunc(SUM(out_talk_time)
123: / DECODE(SUM(out_calls_handled),0,1,SUM(out_calls_handled)), 2)
124: , bix_util_pkg.get_hrmiss_frmt(SUM(out_talk_time)

Line 124: , bix_util_pkg.get_hrmiss_frmt(SUM(out_talk_time)

120: , bix_util_pkg.get_hrmiss_frmt(SUM(out_talk_time + out_wrap_time)
121: / DECODE(SUM(out_calls_handled),0,1,SUM(out_calls_handled)))
122: , trunc(SUM(out_talk_time)
123: / DECODE(SUM(out_calls_handled),0,1,SUM(out_calls_handled)), 2)
124: , bix_util_pkg.get_hrmiss_frmt(SUM(out_talk_time)
125: / DECODE(SUM(out_calls_handled),0,1,SUM(out_calls_handled)))
126: , trunc(SUM(out_wrap_time)
127: / DECODE(SUM(out_calls_handled),0,1,SUM(out_calls_handled)), 2)
128: , bix_util_pkg.get_hrmiss_frmt(SUM(out_wrap_time)

Line 128: , bix_util_pkg.get_hrmiss_frmt(SUM(out_wrap_time)

124: , bix_util_pkg.get_hrmiss_frmt(SUM(out_talk_time)
125: / DECODE(SUM(out_calls_handled),0,1,SUM(out_calls_handled)))
126: , trunc(SUM(out_wrap_time)
127: / DECODE(SUM(out_calls_handled),0,1,SUM(out_calls_handled)), 2)
128: , bix_util_pkg.get_hrmiss_frmt(SUM(out_wrap_time)
129: / DECODE(SUM(out_calls_handled),0,1,SUM(out_calls_handled)))
130: , trunc(SUM(available_time + out_talk_time + out_wrap_time)
131: / DECODE(SUM(login_time),0,1,SUM(login_time)) * 100, 2)
132: , trunc(SUM(available_time)

Line 138: , bix_util_pkg.get_hrmiss_frmt(SUM(available_time + in_talk_time + out_talk_time

134: , trunc(SUM(idle_time)
135: / DECODE(SUM(login_time),0,1,SUM(login_time)) * 100, 2)
136: , trunc(SUM(in_wrap_time + out_wrap_time)
137: / DECODE(SUM(login_time),0,1,SUM(login_time)) * 100, 2)
138: , bix_util_pkg.get_hrmiss_frmt(SUM(available_time + in_talk_time + out_talk_time
139: + in_wrap_time + out_wrap_time))
140: , trunc(SUM(in_talk_time + out_talk_time + in_wrap_time + out_wrap_time)
141: / DECODE( SUM(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time),0,1,
142: SUM(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time)) * 100,2) ';

Line 270: ' , bix_util_pkg.get_hrmiss_frmt(SUM(login_time))

266: END IF;
267:
268: /* Get the measures */
269: g_sqlstmt := g_sqlstmt ||
270: ' , bix_util_pkg.get_hrmiss_frmt(SUM(login_time))
271: , trunc(SUM(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time)
272: / DECODE(SUM(login_time),0,1,SUM(login_time)) * 100,2)
273: , SUM(in_calls_handled)
274: , trunc(SUM(in_talk_time + in_wrap_time)

Line 276: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + in_wrap_time)

272: / DECODE(SUM(login_time),0,1,SUM(login_time)) * 100,2)
273: , SUM(in_calls_handled)
274: , trunc(SUM(in_talk_time + in_wrap_time)
275: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)), 2)
276: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + in_wrap_time)
277: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)))
278: , trunc(SUM(in_talk_time)
279: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)), 2)
280: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time)

Line 280: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time)

276: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time + in_wrap_time)
277: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)))
278: , trunc(SUM(in_talk_time)
279: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)), 2)
280: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time)
281: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)))
282: , trunc(SUM(in_wrap_time)
283: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)), 2)
284: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time)

Line 284: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time)

280: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time)
281: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)))
282: , trunc(SUM(in_wrap_time)
283: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)), 2)
284: , bix_util_pkg.get_hrmiss_frmt(SUM(in_wrap_time)
285: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)))
286: , trunc(SUM(available_time + in_talk_time + in_wrap_time)
287: / DECODE(SUM(login_time),0,1,SUM(login_time)) * 100, 2)
288: , SUM(out_calls_handled)

Line 291: , bix_util_pkg.get_hrmiss_frmt(SUM(out_talk_time + out_wrap_time)

287: / DECODE(SUM(login_time),0,1,SUM(login_time)) * 100, 2)
288: , SUM(out_calls_handled)
289: , trunc(SUM(out_talk_time + out_wrap_time)
290: / DECODE(SUM(out_calls_handled),0,1,SUM(out_calls_handled)), 2)
291: , bix_util_pkg.get_hrmiss_frmt(SUM(out_talk_time + out_wrap_time)
292: / DECODE(SUM(out_calls_handled),0,1,SUM(out_calls_handled)))
293: , trunc(SUM(out_talk_time)
294: / DECODE(SUM(out_calls_handled),0,1,SUM(out_calls_handled)), 2)
295: , bix_util_pkg.get_hrmiss_frmt(SUM(out_talk_time)

Line 295: , bix_util_pkg.get_hrmiss_frmt(SUM(out_talk_time)

291: , bix_util_pkg.get_hrmiss_frmt(SUM(out_talk_time + out_wrap_time)
292: / DECODE(SUM(out_calls_handled),0,1,SUM(out_calls_handled)))
293: , trunc(SUM(out_talk_time)
294: / DECODE(SUM(out_calls_handled),0,1,SUM(out_calls_handled)), 2)
295: , bix_util_pkg.get_hrmiss_frmt(SUM(out_talk_time)
296: / DECODE(SUM(out_calls_handled),0,1,SUM(out_calls_handled)))
297: , trunc(SUM(out_wrap_time)
298: / DECODE(SUM(out_calls_handled),0,1,SUM(out_calls_handled)), 2)
299: , bix_util_pkg.get_hrmiss_frmt(SUM(out_wrap_time)

Line 299: , bix_util_pkg.get_hrmiss_frmt(SUM(out_wrap_time)

295: , bix_util_pkg.get_hrmiss_frmt(SUM(out_talk_time)
296: / DECODE(SUM(out_calls_handled),0,1,SUM(out_calls_handled)))
297: , trunc(SUM(out_wrap_time)
298: / DECODE(SUM(out_calls_handled),0,1,SUM(out_calls_handled)), 2)
299: , bix_util_pkg.get_hrmiss_frmt(SUM(out_wrap_time)
300: / DECODE(SUM(out_calls_handled),0,1,SUM(out_calls_handled)))
301: , trunc(SUM(available_time + out_talk_time + out_wrap_time)
302: / DECODE(SUM(login_time),0,1,SUM(login_time)) * 100, 2)
303: , trunc(SUM(available_time)

Line 309: , bix_util_pkg.get_hrmiss_frmt(SUM(available_time + in_talk_time + out_talk_time

305: , trunc(SUM(idle_time)
306: / DECODE(SUM(login_time),0,1,SUM(login_time)) * 100, 2)
307: , trunc(SUM(in_wrap_time + out_wrap_time)
308: / DECODE(SUM(login_time),0,1,SUM(login_time)) * 100, 2)
309: , bix_util_pkg.get_hrmiss_frmt(SUM(available_time + in_talk_time + out_talk_time
310: + in_wrap_time + out_wrap_time))
311: , trunc(SUM(in_talk_time + out_talk_time + in_wrap_time + out_wrap_time)
312: / DECODE( SUM(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time),0,1,
313: SUM(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time)) * 100,2) ';

Line 430: g_parent := bix_util_pkg.get_parameter_value(p_context, 'pContext');

426: g_nls_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
427:
428: /* Parse all the parameter values from the variable p_context : pContext (Drill down ID) , Agent Group */
429: /* Site , Classification , Period Indicator , From date and Time , To Date and Time */
430: g_parent := bix_util_pkg.get_parameter_value(p_context, 'pContext');
431: g_agent_group := bix_util_pkg.get_parameter_value(p_context, 'P_AGENT_GROUP');
432: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_PERIOD_IND'));
433: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_FROM_DATE'), g_nls_date_format);
434: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_FROM_TIME');

Line 431: g_agent_group := bix_util_pkg.get_parameter_value(p_context, 'P_AGENT_GROUP');

427:
428: /* Parse all the parameter values from the variable p_context : pContext (Drill down ID) , Agent Group */
429: /* Site , Classification , Period Indicator , From date and Time , To Date and Time */
430: g_parent := bix_util_pkg.get_parameter_value(p_context, 'pContext');
431: g_agent_group := bix_util_pkg.get_parameter_value(p_context, 'P_AGENT_GROUP');
432: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_PERIOD_IND'));
433: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_FROM_DATE'), g_nls_date_format);
434: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_FROM_TIME');
435: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_TO_DATE'), g_nls_date_format);

Line 432: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_PERIOD_IND'));

428: /* Parse all the parameter values from the variable p_context : pContext (Drill down ID) , Agent Group */
429: /* Site , Classification , Period Indicator , From date and Time , To Date and Time */
430: g_parent := bix_util_pkg.get_parameter_value(p_context, 'pContext');
431: g_agent_group := bix_util_pkg.get_parameter_value(p_context, 'P_AGENT_GROUP');
432: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_PERIOD_IND'));
433: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_FROM_DATE'), g_nls_date_format);
434: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_FROM_TIME');
435: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_TO_DATE'), g_nls_date_format);
436: g_to_time := bix_util_pkg.get_parameter_value(p_context, 'P_TO_TIME');

Line 433: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_FROM_DATE'), g_nls_date_format);

429: /* Site , Classification , Period Indicator , From date and Time , To Date and Time */
430: g_parent := bix_util_pkg.get_parameter_value(p_context, 'pContext');
431: g_agent_group := bix_util_pkg.get_parameter_value(p_context, 'P_AGENT_GROUP');
432: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_PERIOD_IND'));
433: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_FROM_DATE'), g_nls_date_format);
434: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_FROM_TIME');
435: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_TO_DATE'), g_nls_date_format);
436: g_to_time := bix_util_pkg.get_parameter_value(p_context, 'P_TO_TIME');
437:

Line 434: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_FROM_TIME');

430: g_parent := bix_util_pkg.get_parameter_value(p_context, 'pContext');
431: g_agent_group := bix_util_pkg.get_parameter_value(p_context, 'P_AGENT_GROUP');
432: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_PERIOD_IND'));
433: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_FROM_DATE'), g_nls_date_format);
434: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_FROM_TIME');
435: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_TO_DATE'), g_nls_date_format);
436: g_to_time := bix_util_pkg.get_parameter_value(p_context, 'P_TO_TIME');
437:
438: /* Calculate the reporting period depending on the user input */

Line 435: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_TO_DATE'), g_nls_date_format);

431: g_agent_group := bix_util_pkg.get_parameter_value(p_context, 'P_AGENT_GROUP');
432: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_PERIOD_IND'));
433: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_FROM_DATE'), g_nls_date_format);
434: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_FROM_TIME');
435: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_TO_DATE'), g_nls_date_format);
436: g_to_time := bix_util_pkg.get_parameter_value(p_context, 'P_TO_TIME');
437:
438: /* Calculate the reporting period depending on the user input */
439: IF (g_period_ind IS NULL) THEN

Line 436: g_to_time := bix_util_pkg.get_parameter_value(p_context, 'P_TO_TIME');

432: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_PERIOD_IND'));
433: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_FROM_DATE'), g_nls_date_format);
434: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_FROM_TIME');
435: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_TO_DATE'), g_nls_date_format);
436: g_to_time := bix_util_pkg.get_parameter_value(p_context, 'P_TO_TIME');
437:
438: /* Calculate the reporting period depending on the user input */
439: IF (g_period_ind IS NULL) THEN
440: /* If the period indicator is NULL then report on the maximum date for which data has been collected */

Line 467: bix_util_pkg.get_time_range(g_period_ind, g_from_date, g_to_date);

463: ELSE
464: /* Period Indicator = 1 to 6 indicates Current Week , Prior Week , Current Month , Prior Month */
465: /* Current Year and Prior Year respectively ; get_time_range procedure will return appropiate */
466: /* g_from_date and g_to_date depending on the period indicator (g_period_ind) */
467: bix_util_pkg.get_time_range(g_period_ind, g_from_date, g_to_date);
468:
469: END IF;
470:
471: EXCEPTION