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

Line 96: , bix_util_pkg.get_hrmiss_frmt(SUM(queue_time)

92: g_sqlstmt := g_sqlstmt ||
93: ' , trunc((SUM(calls_answrd_within_x_time)
94: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled))) * 100, 2)
95: , SUM(calls_answrd_within_x_time)
96: , bix_util_pkg.get_hrmiss_frmt(SUM(queue_time)
97: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)))
98: , bix_util_pkg.get_hrmiss_frmt(MAX(max_queue_time))
99: , bix_util_pkg.get_hrmiss_frmt(SUM(abandon_time)
100: / DECODE(SUM(calls_abandoned),0,1,SUM(calls_abandoned)))

Line 98: , bix_util_pkg.get_hrmiss_frmt(MAX(max_queue_time))

94: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled))) * 100, 2)
95: , SUM(calls_answrd_within_x_time)
96: , bix_util_pkg.get_hrmiss_frmt(SUM(queue_time)
97: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)))
98: , bix_util_pkg.get_hrmiss_frmt(MAX(max_queue_time))
99: , bix_util_pkg.get_hrmiss_frmt(SUM(abandon_time)
100: / DECODE(SUM(calls_abandoned),0,1,SUM(calls_abandoned)))
101: , bix_util_pkg.get_hrmiss_frmt(MAX(max_abandon_time))
102: , bix_util_pkg.get_hrmiss_frmt(SUM(ivr_time + available_time + in_talk_time + out_talk_time +

Line 99: , bix_util_pkg.get_hrmiss_frmt(SUM(abandon_time)

95: , SUM(calls_answrd_within_x_time)
96: , bix_util_pkg.get_hrmiss_frmt(SUM(queue_time)
97: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)))
98: , bix_util_pkg.get_hrmiss_frmt(MAX(max_queue_time))
99: , bix_util_pkg.get_hrmiss_frmt(SUM(abandon_time)
100: / DECODE(SUM(calls_abandoned),0,1,SUM(calls_abandoned)))
101: , bix_util_pkg.get_hrmiss_frmt(MAX(max_abandon_time))
102: , bix_util_pkg.get_hrmiss_frmt(SUM(ivr_time + available_time + in_talk_time + out_talk_time +
103: in_wrap_time + out_wrap_time) / DECODE(SUM(in_calls_handled + out_calls_handled),0,1,

Line 101: , bix_util_pkg.get_hrmiss_frmt(MAX(max_abandon_time))

97: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)))
98: , bix_util_pkg.get_hrmiss_frmt(MAX(max_queue_time))
99: , bix_util_pkg.get_hrmiss_frmt(SUM(abandon_time)
100: / DECODE(SUM(calls_abandoned),0,1,SUM(calls_abandoned)))
101: , bix_util_pkg.get_hrmiss_frmt(MAX(max_abandon_time))
102: , bix_util_pkg.get_hrmiss_frmt(SUM(ivr_time + available_time + in_talk_time + out_talk_time +
103: in_wrap_time + out_wrap_time) / DECODE(SUM(in_calls_handled + out_calls_handled),0,1,
104: SUM(in_calls_handled + out_calls_handled)))
105: , SUM(calls_offered)

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

98: , bix_util_pkg.get_hrmiss_frmt(MAX(max_queue_time))
99: , bix_util_pkg.get_hrmiss_frmt(SUM(abandon_time)
100: / DECODE(SUM(calls_abandoned),0,1,SUM(calls_abandoned)))
101: , bix_util_pkg.get_hrmiss_frmt(MAX(max_abandon_time))
102: , bix_util_pkg.get_hrmiss_frmt(SUM(ivr_time + available_time + in_talk_time + out_talk_time +
103: in_wrap_time + out_wrap_time) / DECODE(SUM(in_calls_handled + out_calls_handled),0,1,
104: SUM(in_calls_handled + out_calls_handled)))
105: , SUM(calls_offered)
106: , SUM(in_calls_handled + out_calls_handled)

Line 217: g_classification_parent := bix_util_pkg.get_parameter_value(p_context, 'pContext');

213: g_nls_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
214:
215: /* Parse all the parameter values from the variable p_context : pContext (Drill down ID) , */
216: /* Classification Site , Period Indicator , From date and Time , To Date and Time */
217: g_classification_parent := bix_util_pkg.get_parameter_value(p_context, 'pContext');
218: g_classification_param := bix_util_pkg.get_parameter_value(p_context, 'P_CLASSIFICATION');
219: g_site_id := nvl(TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_SITE_ID')),-999);
220: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_TIME_RANGE'));
221: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_START_DATE'), g_nls_date_format);

Line 218: g_classification_param := bix_util_pkg.get_parameter_value(p_context, 'P_CLASSIFICATION');

214:
215: /* Parse all the parameter values from the variable p_context : pContext (Drill down ID) , */
216: /* Classification Site , Period Indicator , From date and Time , To Date and Time */
217: g_classification_parent := bix_util_pkg.get_parameter_value(p_context, 'pContext');
218: g_classification_param := bix_util_pkg.get_parameter_value(p_context, 'P_CLASSIFICATION');
219: g_site_id := nvl(TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_SITE_ID')),-999);
220: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_TIME_RANGE'));
221: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_START_DATE'), g_nls_date_format);
222: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_FROM_TIME');

Line 219: g_site_id := nvl(TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_SITE_ID')),-999);

215: /* Parse all the parameter values from the variable p_context : pContext (Drill down ID) , */
216: /* Classification Site , Period Indicator , From date and Time , To Date and Time */
217: g_classification_parent := bix_util_pkg.get_parameter_value(p_context, 'pContext');
218: g_classification_param := bix_util_pkg.get_parameter_value(p_context, 'P_CLASSIFICATION');
219: g_site_id := nvl(TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_SITE_ID')),-999);
220: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_TIME_RANGE'));
221: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_START_DATE'), g_nls_date_format);
222: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_FROM_TIME');
223: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_END_DATE'), g_nls_date_format);

Line 220: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_TIME_RANGE'));

216: /* Classification Site , Period Indicator , From date and Time , To Date and Time */
217: g_classification_parent := bix_util_pkg.get_parameter_value(p_context, 'pContext');
218: g_classification_param := bix_util_pkg.get_parameter_value(p_context, 'P_CLASSIFICATION');
219: g_site_id := nvl(TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_SITE_ID')),-999);
220: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_TIME_RANGE'));
221: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_START_DATE'), g_nls_date_format);
222: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_FROM_TIME');
223: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_END_DATE'), g_nls_date_format);
224: g_to_time := bix_util_pkg.get_parameter_value(p_context, 'P_TO_TIME');

Line 221: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_START_DATE'), g_nls_date_format);

217: g_classification_parent := bix_util_pkg.get_parameter_value(p_context, 'pContext');
218: g_classification_param := bix_util_pkg.get_parameter_value(p_context, 'P_CLASSIFICATION');
219: g_site_id := nvl(TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_SITE_ID')),-999);
220: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_TIME_RANGE'));
221: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_START_DATE'), g_nls_date_format);
222: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_FROM_TIME');
223: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_END_DATE'), g_nls_date_format);
224: g_to_time := bix_util_pkg.get_parameter_value(p_context, 'P_TO_TIME');
225:

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

218: g_classification_param := bix_util_pkg.get_parameter_value(p_context, 'P_CLASSIFICATION');
219: g_site_id := nvl(TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_SITE_ID')),-999);
220: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_TIME_RANGE'));
221: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_START_DATE'), g_nls_date_format);
222: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_FROM_TIME');
223: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_END_DATE'), g_nls_date_format);
224: g_to_time := bix_util_pkg.get_parameter_value(p_context, 'P_TO_TIME');
225:
226: /* Calculate the reporting period depending on the user input */

Line 223: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_END_DATE'), g_nls_date_format);

219: g_site_id := nvl(TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_SITE_ID')),-999);
220: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_TIME_RANGE'));
221: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_START_DATE'), g_nls_date_format);
222: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_FROM_TIME');
223: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_END_DATE'), g_nls_date_format);
224: g_to_time := bix_util_pkg.get_parameter_value(p_context, 'P_TO_TIME');
225:
226: /* Calculate the reporting period depending on the user input */
227: IF (g_period_ind IS NULL) THEN

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

220: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_TIME_RANGE'));
221: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_START_DATE'), g_nls_date_format);
222: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_FROM_TIME');
223: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_END_DATE'), g_nls_date_format);
224: g_to_time := bix_util_pkg.get_parameter_value(p_context, 'P_TO_TIME');
225:
226: /* Calculate the reporting period depending on the user input */
227: IF (g_period_ind IS NULL) THEN
228: /* If the period indicator is NULL then report on the maximum date for which data has been collected */

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

251: ELSE
252: /* Period Indicator = 1 to 6 indicates Current Week , Prior Week , Current Month , Prior Month */
253: /* Current Year and Prior Year respectively ; get_time_range procedure will return appropiate */
254: /* g_from_date and g_to_date depending on the period indicator (g_period_ind) */
255: bix_util_pkg.get_time_range(g_period_ind, g_from_date, g_to_date);
256:
257: END IF;
258:
259: EXCEPTION

Line 289: g_null_desc := bix_util_pkg.get_null_lookup;

285: INTO g_sysdate
286: FROM dual;
287:
288: /* Get the description of NULL */
289: g_null_desc := bix_util_pkg.get_null_lookup;
290:
291: /* Fetch the time range (1 hour or 2 hour etc. ) preference of the user */
292: SELECT fnd_profile.value('BIX_DM_RPT_TIME_RANGE')
293: INTO g_time_range