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

Line 59: bix_util_pkg.get_conversion_rate(l_global_curr, l_user_curr, sysdate, l_conv_type,

55: INTO l_conv_type
56: FROM dual;
57:
58: /* Get the exchange rate as per sysdate */
59: bix_util_pkg.get_conversion_rate(l_global_curr, l_user_curr, sysdate, l_conv_type,
60: g_denom_rate, g_num_rate, l_status);
61:
62: END IF;
63:

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

134:
135: /* Get the measures */
136: g_sqlstmt := g_sqlstmt ||
137: ' , SUM(in_calls_handled)
138: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time)
139: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)))
140: , SUM(out_calls_handled)
141: , bix_util_pkg.get_hrmiss_frmt(SUM(out_talk_time)
142: / DECODE(SUM(out_calls_handled),0,1,SUM(out_calls_handled)))

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

137: ' , SUM(in_calls_handled)
138: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time)
139: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)))
140: , SUM(out_calls_handled)
141: , bix_util_pkg.get_hrmiss_frmt(SUM(out_talk_time)
142: / DECODE(SUM(out_calls_handled),0,1,SUM(out_calls_handled)))
143: , bix_util_pkg.get_hrmiss_frmt(SUM(available_time + in_talk_time + out_talk_time
144: + in_wrap_time + out_wrap_time))
145: , trunc(SUM(in_talk_time + out_talk_time + in_wrap_time + out_wrap_time) /

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

139: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)))
140: , SUM(out_calls_handled)
141: , bix_util_pkg.get_hrmiss_frmt(SUM(out_talk_time)
142: / DECODE(SUM(out_calls_handled),0,1,SUM(out_calls_handled)))
143: , bix_util_pkg.get_hrmiss_frmt(SUM(available_time + in_talk_time + out_talk_time
144: + in_wrap_time + out_wrap_time))
145: , trunc(SUM(in_talk_time + out_talk_time + in_wrap_time + out_wrap_time) /
146: DECODE(SUM(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time),0,1,
147: SUM(available_time + in_talk_time + out_talk_time + in_wrap_time + out_wrap_time)) * 100, 2)

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

290:
291: /* Get the measures */
292: g_sqlstmt := g_sqlstmt ||
293: ' , SUM(in_calls_handled)
294: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time)
295: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)))
296: , SUM(out_calls_handled)
297: , bix_util_pkg.get_hrmiss_frmt(SUM(out_talk_time)
298: / DECODE(SUM(out_calls_handled),0,1,SUM(out_calls_handled)))

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

293: ' , SUM(in_calls_handled)
294: , bix_util_pkg.get_hrmiss_frmt(SUM(in_talk_time)
295: / DECODE(SUM(in_calls_handled),0,1,SUM(in_calls_handled)))
296: , SUM(out_calls_handled)
297: , bix_util_pkg.get_hrmiss_frmt(SUM(out_talk_time)
298: / DECODE(SUM(out_calls_handled),0,1,SUM(out_calls_handled)))
299: , bix_util_pkg.get_hrmiss_frmt(SUM(available_time + in_talk_time + out_talk_time
300: + in_wrap_time + out_wrap_time))
301: , trunc(SUM(in_talk_time + out_talk_time + in_wrap_time + out_wrap_time) /

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

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

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

449: g_nls_date_format := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
450:
451: /* Parse all the parameter values from the variable p_context : pContext (Drill down ID) , Agent Group */
452: /* Site , Classification , Period Indicator , From date and Time , To Date and Time */
453: g_parent := bix_util_pkg.get_parameter_value(p_context, 'pContext');
454: g_agent_group := bix_util_pkg.get_parameter_value(p_context, 'P_AGENT_GROUP');
455: g_site_id := nvl(TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_SITE')),-999);
456: g_classification_id := nvl(TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_CLASSIFICATION')),-999);
457: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_PERIOD_IND'));

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

450:
451: /* Parse all the parameter values from the variable p_context : pContext (Drill down ID) , Agent Group */
452: /* Site , Classification , Period Indicator , From date and Time , To Date and Time */
453: g_parent := bix_util_pkg.get_parameter_value(p_context, 'pContext');
454: g_agent_group := bix_util_pkg.get_parameter_value(p_context, 'P_AGENT_GROUP');
455: g_site_id := nvl(TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_SITE')),-999);
456: g_classification_id := nvl(TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_CLASSIFICATION')),-999);
457: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_PERIOD_IND'));
458: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_FROM_DATE'), g_nls_date_format);

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

451: /* Parse all the parameter values from the variable p_context : pContext (Drill down ID) , Agent Group */
452: /* Site , Classification , Period Indicator , From date and Time , To Date and Time */
453: g_parent := bix_util_pkg.get_parameter_value(p_context, 'pContext');
454: g_agent_group := bix_util_pkg.get_parameter_value(p_context, 'P_AGENT_GROUP');
455: g_site_id := nvl(TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_SITE')),-999);
456: g_classification_id := nvl(TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_CLASSIFICATION')),-999);
457: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_PERIOD_IND'));
458: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_FROM_DATE'), g_nls_date_format);
459: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_FROM_TIME');

Line 456: g_classification_id := nvl(TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_CLASSIFICATION')),-999);

452: /* Site , Classification , Period Indicator , From date and Time , To Date and Time */
453: g_parent := bix_util_pkg.get_parameter_value(p_context, 'pContext');
454: g_agent_group := bix_util_pkg.get_parameter_value(p_context, 'P_AGENT_GROUP');
455: g_site_id := nvl(TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_SITE')),-999);
456: g_classification_id := nvl(TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_CLASSIFICATION')),-999);
457: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_PERIOD_IND'));
458: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_FROM_DATE'), g_nls_date_format);
459: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_FROM_TIME');
460: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_TO_DATE'), g_nls_date_format);

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

453: g_parent := bix_util_pkg.get_parameter_value(p_context, 'pContext');
454: g_agent_group := bix_util_pkg.get_parameter_value(p_context, 'P_AGENT_GROUP');
455: g_site_id := nvl(TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_SITE')),-999);
456: g_classification_id := nvl(TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_CLASSIFICATION')),-999);
457: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_PERIOD_IND'));
458: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_FROM_DATE'), g_nls_date_format);
459: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_FROM_TIME');
460: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_TO_DATE'), g_nls_date_format);
461: g_to_time := bix_util_pkg.get_parameter_value(p_context, 'P_TO_TIME');

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

454: g_agent_group := bix_util_pkg.get_parameter_value(p_context, 'P_AGENT_GROUP');
455: g_site_id := nvl(TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_SITE')),-999);
456: g_classification_id := nvl(TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_CLASSIFICATION')),-999);
457: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_PERIOD_IND'));
458: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_FROM_DATE'), g_nls_date_format);
459: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_FROM_TIME');
460: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_TO_DATE'), g_nls_date_format);
461: g_to_time := bix_util_pkg.get_parameter_value(p_context, 'P_TO_TIME');
462:

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

455: g_site_id := nvl(TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_SITE')),-999);
456: g_classification_id := nvl(TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_CLASSIFICATION')),-999);
457: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_PERIOD_IND'));
458: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_FROM_DATE'), g_nls_date_format);
459: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_FROM_TIME');
460: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_TO_DATE'), g_nls_date_format);
461: g_to_time := bix_util_pkg.get_parameter_value(p_context, 'P_TO_TIME');
462:
463: /* Calculate the reporting period depending on the user input */

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

456: g_classification_id := nvl(TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_CLASSIFICATION')),-999);
457: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_PERIOD_IND'));
458: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_FROM_DATE'), g_nls_date_format);
459: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_FROM_TIME');
460: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_TO_DATE'), g_nls_date_format);
461: g_to_time := bix_util_pkg.get_parameter_value(p_context, 'P_TO_TIME');
462:
463: /* Calculate the reporting period depending on the user input */
464: IF (g_period_ind IS NULL) THEN

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

457: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_PERIOD_IND'));
458: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_FROM_DATE'), g_nls_date_format);
459: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_FROM_TIME');
460: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_TO_DATE'), g_nls_date_format);
461: g_to_time := bix_util_pkg.get_parameter_value(p_context, 'P_TO_TIME');
462:
463: /* Calculate the reporting period depending on the user input */
464: IF (g_period_ind IS NULL) THEN
465: /* If the period indicator is NULL then report on the maximum date for which data has been collected */

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

488: ELSE
489: /* Period Indicator = 1 to 6 indicates Current Week , Prior Week , Current Month , Prior Month */
490: /* Current Year and Prior Year respectively ; get_time_range procedure will return appropiate */
491: /* g_from_date and g_to_date depending on the period indicator (g_period_ind) */
492: bix_util_pkg.get_time_range(g_period_ind, g_from_date, g_to_date);
493:
494: END IF;
495:
496: EXCEPTION