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

Line 98: bix_util_pkg.get_hrmiss_frmt(

94:
95: nvl(sum(a.in_calls_handld_gt_thn_x_time),0),
96:
97: ''col13'',
98: bix_util_pkg.get_hrmiss_frmt(
99: sum(a.in_talk_time)/sum(decode(a.in_calls_handled,0,1,a.in_calls_handled)) ),
100:
101: ''col15'',
102:

Line 103: bix_util_pkg.get_hrmiss_frmt(

99: sum(a.in_talk_time)/sum(decode(a.in_calls_handled,0,1,a.in_calls_handled)) ),
100:
101: ''col15'',
102:
103: bix_util_pkg.get_hrmiss_frmt(
104: sum(a.in_wrap_time)/sum(decode(a.in_calls_handled,0,1,a.in_calls_handled)) ),
105:
106: ''col17'',
107: sum(a.out_calls_handled) ,

Line 110: bix_util_pkg.get_hrmiss_frmt(

106: ''col17'',
107: sum(a.out_calls_handled) ,
108: nvl(sum(a.out_cals_handld_gt_thn_x_time),0),
109:
110: bix_util_pkg.get_hrmiss_frmt(
111: sum(a.out_talk_time)/sum(decode(a.out_calls_handled,0,1,a.out_calls_handled)) ),
112:
113: ''col23'',
114: bix_util_pkg.get_hrmiss_frmt(

Line 114: bix_util_pkg.get_hrmiss_frmt(

110: bix_util_pkg.get_hrmiss_frmt(
111: sum(a.out_talk_time)/sum(decode(a.out_calls_handled,0,1,a.out_calls_handled)) ),
112:
113: ''col23'',
114: bix_util_pkg.get_hrmiss_frmt(
115: sum(a.out_wrap_time)/sum(decode(a.out_calls_handled,0,1,a.out_calls_handled)) ),
116:
117: ''col25'',
118: to_char(

Line 127: bix_util_pkg.get_hrmiss_frmt(trunc(sum(a.in_talk_time+a.out_talk_time+a.in_wrap_time+a.out_wrap_time))) ,';

123:
124: if (p_total_row_ind = 3) then g_sqlstmt := g_sqlstmt ||
125: ' ''col27'',
126: trunc(sum(a.in_calls_handled+a.out_calls_handled)),
127: bix_util_pkg.get_hrmiss_frmt(trunc(sum(a.in_talk_time+a.out_talk_time+a.in_wrap_time+a.out_wrap_time))) ,';
128: else g_sqlstmt := g_sqlstmt ||
129: ' null,
130: null,
131: null, ';

Line 136: g_sqlstmt := g_sqlstmt || 'concat( ' || ' '' ' ||bix_util_pkg.get_hrmiss_frmt(g_idx)|| ' '''

132: end if;
133:
134: /* col32 */
135: if (p_total_row_ind = 1) then
136: g_sqlstmt := g_sqlstmt || 'concat( ' || ' '' ' ||bix_util_pkg.get_hrmiss_frmt(g_idx)|| ' '''
137: || ', rsc.source_name) , ';
138: elsif (p_total_row_ind =3) then g_sqlstmt := g_sqlstmt || 'concat( ' || ' '' ' ||bix_util_pkg.get_hrmiss_frmt(g_idx)||' ''' || ', ''9'' ), ';
139: else
140: if (g_time_range = 5) then

Line 138: elsif (p_total_row_ind =3) then g_sqlstmt := g_sqlstmt || 'concat( ' || ' '' ' ||bix_util_pkg.get_hrmiss_frmt(g_idx)||' ''' || ', ''9'' ), ';

134: /* col32 */
135: if (p_total_row_ind = 1) then
136: g_sqlstmt := g_sqlstmt || 'concat( ' || ' '' ' ||bix_util_pkg.get_hrmiss_frmt(g_idx)|| ' '''
137: || ', rsc.source_name) , ';
138: elsif (p_total_row_ind =3) then g_sqlstmt := g_sqlstmt || 'concat( ' || ' '' ' ||bix_util_pkg.get_hrmiss_frmt(g_idx)||' ''' || ', ''9'' ), ';
139: else
140: if (g_time_range = 5) then
141: g_sqlstmt := g_sqlstmt || 'concat( ' || ' '' ' ||bix_util_pkg.get_hrmiss_frmt(g_idx)|| ' '' ' || ',to_char(to_date(period_start_date,''dd/mm/yyyy''),''dd/mm/yyyy'') ), ';
142: else

Line 141: g_sqlstmt := g_sqlstmt || 'concat( ' || ' '' ' ||bix_util_pkg.get_hrmiss_frmt(g_idx)|| ' '' ' || ',to_char(to_date(period_start_date,''dd/mm/yyyy''),''dd/mm/yyyy'') ), ';

137: || ', rsc.source_name) , ';
138: elsif (p_total_row_ind =3) then g_sqlstmt := g_sqlstmt || 'concat( ' || ' '' ' ||bix_util_pkg.get_hrmiss_frmt(g_idx)||' ''' || ', ''9'' ), ';
139: else
140: if (g_time_range = 5) then
141: g_sqlstmt := g_sqlstmt || 'concat( ' || ' '' ' ||bix_util_pkg.get_hrmiss_frmt(g_idx)|| ' '' ' || ',to_char(to_date(period_start_date,''dd/mm/yyyy''),''dd/mm/yyyy'') ), ';
142: else
143: g_sqlstmt := g_sqlstmt || 'concat( ' || ' '' ' ||bix_util_pkg.get_hrmiss_frmt(g_idx)|| ' '' ' || ',to_char(to_date(period_start_time,''hh24:mi''),''hh24:mi'') ), ';
144: end if;
145:

Line 143: g_sqlstmt := g_sqlstmt || 'concat( ' || ' '' ' ||bix_util_pkg.get_hrmiss_frmt(g_idx)|| ' '' ' || ',to_char(to_date(period_start_time,''hh24:mi''),''hh24:mi'') ), ';

139: else
140: if (g_time_range = 5) then
141: g_sqlstmt := g_sqlstmt || 'concat( ' || ' '' ' ||bix_util_pkg.get_hrmiss_frmt(g_idx)|| ' '' ' || ',to_char(to_date(period_start_date,''dd/mm/yyyy''),''dd/mm/yyyy'') ), ';
142: else
143: g_sqlstmt := g_sqlstmt || 'concat( ' || ' '' ' ||bix_util_pkg.get_hrmiss_frmt(g_idx)|| ' '' ' || ',to_char(to_date(period_start_time,''hh24:mi''),''hh24:mi'') ), ';
144: end if;
145:
146: end if;
147: /* col34 */

Line 278: bix_util_pkg.get_hrmiss_frmt(

274:
275: nvl(sum(a.in_calls_handld_gt_thn_x_time),0),
276:
277: ''col13'',
278: bix_util_pkg.get_hrmiss_frmt(
279: sum(a.in_talk_time)/sum(decode(a.in_calls_handled,0,1,a.in_calls_handled)) ),
280:
281: ''col15'',
282:

Line 283: bix_util_pkg.get_hrmiss_frmt(

279: sum(a.in_talk_time)/sum(decode(a.in_calls_handled,0,1,a.in_calls_handled)) ),
280:
281: ''col15'',
282:
283: bix_util_pkg.get_hrmiss_frmt(
284: sum(a.in_wrap_time)/sum(decode(a.in_calls_handled,0,1,a.in_calls_handled)) ),
285:
286: ''col17'',
287: sum(a.out_calls_handled) ,

Line 290: bix_util_pkg.get_hrmiss_frmt(

286: ''col17'',
287: sum(a.out_calls_handled) ,
288: nvl(sum(a.out_cals_handld_gt_thn_x_time),0),
289:
290: bix_util_pkg.get_hrmiss_frmt(
291: sum(a.out_talk_time)/sum(decode(a.out_calls_handled,0,1,a.out_calls_handled)) ),
292:
293: ''col23'',
294: bix_util_pkg.get_hrmiss_frmt(

Line 294: bix_util_pkg.get_hrmiss_frmt(

290: bix_util_pkg.get_hrmiss_frmt(
291: sum(a.out_talk_time)/sum(decode(a.out_calls_handled,0,1,a.out_calls_handled)) ),
292:
293: ''col23'',
294: bix_util_pkg.get_hrmiss_frmt(
295: sum(a.out_wrap_time)/sum(decode(a.out_calls_handled,0,1,a.out_calls_handled)) ),
296:
297: ''col25'',
298: to_char(

Line 308: bix_util_pkg.get_hrmiss_frmt(decode(:agentNum,0,0,

304:
305: ''col27'',
306: decode(:agentNum,0,0,trunc(sum(a.in_calls_handled+a.out_calls_handled)/:agentNum) ) ,
307:
308: bix_util_pkg.get_hrmiss_frmt(decode(:agentNum,0,0,
309: trunc(sum(a.in_talk_time+a.out_talk_time+a.in_wrap_time+a.out_wrap_time)/:agentNum ))) , ';
310:
311: g_sqlstmt := g_sqlstmt || 'CONCAT( ' || ' '' '||bix_util_pkg.get_hrmiss_frmt(g_idx)|| ' '' ' || ',grp.group_name),';
312: g_sqlstmt := g_sqlstmt ||

Line 311: g_sqlstmt := g_sqlstmt || 'CONCAT( ' || ' '' '||bix_util_pkg.get_hrmiss_frmt(g_idx)|| ' '' ' || ',grp.group_name),';

307:
308: bix_util_pkg.get_hrmiss_frmt(decode(:agentNum,0,0,
309: trunc(sum(a.in_talk_time+a.out_talk_time+a.in_wrap_time+a.out_wrap_time)/:agentNum ))) , ';
310:
311: g_sqlstmt := g_sqlstmt || 'CONCAT( ' || ' '' '||bix_util_pkg.get_hrmiss_frmt(g_idx)|| ' '' ' || ',grp.group_name),';
312: g_sqlstmt := g_sqlstmt ||
313: ' null,
314: null,
315: null,

Line 384: select bix_util_pkg.get_null_lookup into l_unknown

380: or classification_id = g_class;
381:
382:
383: BEGIN
384: select bix_util_pkg.get_null_lookup into l_unknown
385: from dual;
386: /*
387: SELECT meaning
388: into l_unknown

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

521: l_date_format_mask := FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK');
522:
523: /* Parse all the parameter values from the variable p_context */
524:
525: g_parent := bix_util_pkg.get_parameter_value(p_context, 'pContext');
526: g_agent_group := bix_util_pkg.get_parameter_value(p_context, 'P_GROUP_ID');
527: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_TIME'));
528: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_START_PERIOD'), l_date_format_mask);
529: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_START_HR');

Line 526: g_agent_group := bix_util_pkg.get_parameter_value(p_context, 'P_GROUP_ID');

522:
523: /* Parse all the parameter values from the variable p_context */
524:
525: g_parent := bix_util_pkg.get_parameter_value(p_context, 'pContext');
526: g_agent_group := bix_util_pkg.get_parameter_value(p_context, 'P_GROUP_ID');
527: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_TIME'));
528: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_START_PERIOD'), l_date_format_mask);
529: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_START_HR');
530: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_END_PERIOD'),l_date_format_mask);

Line 527: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_TIME'));

523: /* Parse all the parameter values from the variable p_context */
524:
525: g_parent := bix_util_pkg.get_parameter_value(p_context, 'pContext');
526: g_agent_group := bix_util_pkg.get_parameter_value(p_context, 'P_GROUP_ID');
527: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_TIME'));
528: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_START_PERIOD'), l_date_format_mask);
529: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_START_HR');
530: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_END_PERIOD'),l_date_format_mask);
531: g_to_time := bix_util_pkg.get_parameter_value(p_context, 'P_END_HR');

Line 528: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_START_PERIOD'), l_date_format_mask);

524:
525: g_parent := bix_util_pkg.get_parameter_value(p_context, 'pContext');
526: g_agent_group := bix_util_pkg.get_parameter_value(p_context, 'P_GROUP_ID');
527: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_TIME'));
528: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_START_PERIOD'), l_date_format_mask);
529: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_START_HR');
530: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_END_PERIOD'),l_date_format_mask);
531: g_to_time := bix_util_pkg.get_parameter_value(p_context, 'P_END_HR');
532: g_class := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_CLASSIFICATION'));

Line 529: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_START_HR');

525: g_parent := bix_util_pkg.get_parameter_value(p_context, 'pContext');
526: g_agent_group := bix_util_pkg.get_parameter_value(p_context, 'P_GROUP_ID');
527: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_TIME'));
528: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_START_PERIOD'), l_date_format_mask);
529: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_START_HR');
530: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_END_PERIOD'),l_date_format_mask);
531: g_to_time := bix_util_pkg.get_parameter_value(p_context, 'P_END_HR');
532: g_class := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_CLASSIFICATION'));
533: g_site := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_SITE_ID'));

Line 530: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_END_PERIOD'),l_date_format_mask);

526: g_agent_group := bix_util_pkg.get_parameter_value(p_context, 'P_GROUP_ID');
527: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_TIME'));
528: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_START_PERIOD'), l_date_format_mask);
529: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_START_HR');
530: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_END_PERIOD'),l_date_format_mask);
531: g_to_time := bix_util_pkg.get_parameter_value(p_context, 'P_END_HR');
532: g_class := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_CLASSIFICATION'));
533: g_site := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_SITE_ID'));
534:

Line 531: g_to_time := bix_util_pkg.get_parameter_value(p_context, 'P_END_HR');

527: g_period_ind := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_TIME'));
528: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_START_PERIOD'), l_date_format_mask);
529: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_START_HR');
530: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_END_PERIOD'),l_date_format_mask);
531: g_to_time := bix_util_pkg.get_parameter_value(p_context, 'P_END_HR');
532: g_class := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_CLASSIFICATION'));
533: g_site := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_SITE_ID'));
534:
535: /*

Line 532: g_class := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_CLASSIFICATION'));

528: g_from_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_START_PERIOD'), l_date_format_mask);
529: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_START_HR');
530: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_END_PERIOD'),l_date_format_mask);
531: g_to_time := bix_util_pkg.get_parameter_value(p_context, 'P_END_HR');
532: g_class := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_CLASSIFICATION'));
533: g_site := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_SITE_ID'));
534:
535: /*
536: g_class := -999;

Line 533: g_site := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_SITE_ID'));

529: g_from_time := bix_util_pkg.get_parameter_value(p_context, 'P_START_HR');
530: g_to_date := TO_DATE(bix_util_pkg.get_parameter_value(p_context, 'P_END_PERIOD'),l_date_format_mask);
531: g_to_time := bix_util_pkg.get_parameter_value(p_context, 'P_END_HR');
532: g_class := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_CLASSIFICATION'));
533: g_site := TO_NUMBER(bix_util_pkg.get_parameter_value(p_context, 'P_SITE_ID'));
534:
535: /*
536: g_class := -999;
537: g_site :=-999;

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

574: g_to_date := to_date(to_char(g_to_date,'dd/mm/yyyy ') || g_to_time, 'dd/mm/yyyy hh24');
575:
576: ELSE
577:
578: bix_util_pkg.get_time_range(g_period_ind, g_from_date, g_to_date);
579:
580: END IF;
581:
582: EXCEPTION

Line 606: l_session_id:= bix_util_pkg.get_icx_session_id;

602:
603: BEGIN
604:
605: /* Get the ICX Session Id */
606: l_session_id:= bix_util_pkg.get_icx_session_id;
607:
608: delete from BIX_DM_REPORT
609: where session_id = l_session_id
610: and report_code = 'BIX_AGENT_CLASS_REPORT';