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

Line 24: bix_util_pkg.get_conversion_rate(p_from_currency, p_to_currency, sysdate,

20: INTO l_conv_type
21: FROM dual;
22:
23: /* Get the exchange rate as per sysdate */
24: bix_util_pkg.get_conversion_rate(p_from_currency, p_to_currency, sysdate,
25: l_conv_type, p_denom_rate, p_num_rate, l_status);
26: EXCEPTION
27: WHEN OTHERS THEN
28: RAISE;

Line 95: l_null_class_name := bix_util_pkg.get_null_lookup;

91: to_char(to_date(a.period_start_time,''hh24:mi''), ''hh:miAM'') ';
92: END IF;
93: ELSE
94: /* Get the name for null classifications from lookup */
95: l_null_class_name := bix_util_pkg.get_null_lookup;
96: g_sqlstmt := g_sqlstmt || ', nvl(b.classification,''' ||
97: l_null_class_name || '''), null, null ';
98: END IF;
99:

Line 100: g_sqlstmt := g_sqlstmt || ' , bix_util_pkg.get_hrmiss_frmt(

96: g_sqlstmt := g_sqlstmt || ', nvl(b.classification,''' ||
97: l_null_class_name || '''), null, null ';
98: END IF;
99:
100: g_sqlstmt := g_sqlstmt || ' , bix_util_pkg.get_hrmiss_frmt(
101: DECODE( SUM(a.in_calls_handled + a.out_calls_handled), 0, 0,
102: SUM(in_talk_time + out_talk_time)/
103: SUM(a.in_calls_handled + a.out_calls_handled))) ,
104: bix_util_pkg.get_hrmiss_frmt(

Line 104: bix_util_pkg.get_hrmiss_frmt(

100: g_sqlstmt := g_sqlstmt || ' , bix_util_pkg.get_hrmiss_frmt(
101: DECODE( SUM(a.in_calls_handled + a.out_calls_handled), 0, 0,
102: SUM(in_talk_time + out_talk_time)/
103: SUM(a.in_calls_handled + a.out_calls_handled))) ,
104: bix_util_pkg.get_hrmiss_frmt(
105: DECODE( SUM(a.in_calls_handled + a.out_calls_handled), 0, 0,
106: SUM(a.in_wrap_time + a.out_wrap_time) /
107: SUM(a.in_calls_handled + a.out_calls_handled)))
108: , SUM(a.in_calls_handld_gt_thn_x_time)

Line 303: l_classification_parent := bix_util_pkg.get_parameter_value(

299: /* Get the JTF profile date format from the Profile */
300: g_date_format_mask := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
301:
302: /* Parse all the parameter values from the variable p_context */
303: l_classification_parent := bix_util_pkg.get_parameter_value(
304: p_context, 'pContext');
305: l_classification_id := TO_NUMBER(bix_util_pkg.get_parameter_value(
306: p_context, 'P_CLASSIFICATION_ID'));
307: l_site_id := TO_NUMBER(bix_util_pkg.get_parameter_value(

Line 305: l_classification_id := TO_NUMBER(bix_util_pkg.get_parameter_value(

301:
302: /* Parse all the parameter values from the variable p_context */
303: l_classification_parent := bix_util_pkg.get_parameter_value(
304: p_context, 'pContext');
305: l_classification_id := TO_NUMBER(bix_util_pkg.get_parameter_value(
306: p_context, 'P_CLASSIFICATION_ID'));
307: l_site_id := TO_NUMBER(bix_util_pkg.get_parameter_value(
308: p_context, 'P_SITE_ID'));
309: l_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(

Line 307: l_site_id := TO_NUMBER(bix_util_pkg.get_parameter_value(

303: l_classification_parent := bix_util_pkg.get_parameter_value(
304: p_context, 'pContext');
305: l_classification_id := TO_NUMBER(bix_util_pkg.get_parameter_value(
306: p_context, 'P_CLASSIFICATION_ID'));
307: l_site_id := TO_NUMBER(bix_util_pkg.get_parameter_value(
308: p_context, 'P_SITE_ID'));
309: l_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(
310: p_context, 'P_TIME_RANGE'));
311: l_udef_start_date := TO_DATE(bix_util_pkg.get_parameter_value(

Line 309: l_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(

305: l_classification_id := TO_NUMBER(bix_util_pkg.get_parameter_value(
306: p_context, 'P_CLASSIFICATION_ID'));
307: l_site_id := TO_NUMBER(bix_util_pkg.get_parameter_value(
308: p_context, 'P_SITE_ID'));
309: l_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(
310: p_context, 'P_TIME_RANGE'));
311: l_udef_start_date := TO_DATE(bix_util_pkg.get_parameter_value(
312: p_context, 'P_START_DATE'),g_date_format_mask);
313: l_udef_start_time := bix_util_pkg.get_parameter_value(

Line 311: l_udef_start_date := TO_DATE(bix_util_pkg.get_parameter_value(

307: l_site_id := TO_NUMBER(bix_util_pkg.get_parameter_value(
308: p_context, 'P_SITE_ID'));
309: l_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(
310: p_context, 'P_TIME_RANGE'));
311: l_udef_start_date := TO_DATE(bix_util_pkg.get_parameter_value(
312: p_context, 'P_START_DATE'),g_date_format_mask);
313: l_udef_start_time := bix_util_pkg.get_parameter_value(
314: p_context, 'P_START_TIME');
315: l_udef_end_date := TO_DATE(bix_util_pkg.get_parameter_value(

Line 313: l_udef_start_time := bix_util_pkg.get_parameter_value(

309: l_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(
310: p_context, 'P_TIME_RANGE'));
311: l_udef_start_date := TO_DATE(bix_util_pkg.get_parameter_value(
312: p_context, 'P_START_DATE'),g_date_format_mask);
313: l_udef_start_time := bix_util_pkg.get_parameter_value(
314: p_context, 'P_START_TIME');
315: l_udef_end_date := TO_DATE(bix_util_pkg.get_parameter_value(
316: p_context, 'P_END_DATE'), g_date_format_mask);
317:

Line 315: l_udef_end_date := TO_DATE(bix_util_pkg.get_parameter_value(

311: l_udef_start_date := TO_DATE(bix_util_pkg.get_parameter_value(
312: p_context, 'P_START_DATE'),g_date_format_mask);
313: l_udef_start_time := bix_util_pkg.get_parameter_value(
314: p_context, 'P_START_TIME');
315: l_udef_end_date := TO_DATE(bix_util_pkg.get_parameter_value(
316: p_context, 'P_END_DATE'), g_date_format_mask);
317:
318: l_udef_end_time := bix_util_pkg.get_parameter_value(p_context, 'P_END_TIME');
319:

Line 318: l_udef_end_time := bix_util_pkg.get_parameter_value(p_context, 'P_END_TIME');

314: p_context, 'P_START_TIME');
315: l_udef_end_date := TO_DATE(bix_util_pkg.get_parameter_value(
316: p_context, 'P_END_DATE'), g_date_format_mask);
317:
318: l_udef_end_time := bix_util_pkg.get_parameter_value(p_context, 'P_END_TIME');
319:
320: /* Calculate the reporting period depending on the user input */
321: IF (l_period_ind IS NULL)
322: THEN

Line 350: bix_util_pkg.get_time_range(l_period_ind, p_start_date, p_end_date);

346: l_udef_start_time, 'dd/mm/yyyy hh24');
347: p_end_date := to_date(to_char(l_udef_end_date,'dd/mm/yyyy ') ||
348: l_udef_end_time, 'dd/mm/yyyy hh24');
349: ELSE
350: bix_util_pkg.get_time_range(l_period_ind, p_start_date, p_end_date);
351: END IF;
352:
353: p_classification_parent := l_classification_parent;
354: p_classification_id := l_classification_id;

Line 382: l_session_id := bix_util_pkg.get_icx_session_id;

378: l_drill_down_ind VARCHAR2(1);
379:
380: BEGIN
381:
382: l_session_id := bix_util_pkg.get_icx_session_id;
383:
384: /* Delete the table for the current icx session and report */
385: DELETE from bix_dm_report
386: WHERE report_code = 'BIX_KPI_CLS_RPT'