APPS.BIX_PMV_AI_TELDTL_RPT_PKG dependencies on POA_DBI_UTIL_PKG

Line 284: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

280: l_comp_type VARCHAR2(500) ;
281: l_xtd VARCHAR2(500) ;
282: l_mv VARCHAR2 (240);
283: l_view_by_col VARCHAR2 (120);
284: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
285: l_col_tbl_cont poa_dbi_util_pkg.poa_dbi_col_tbl;
286: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
287: l_filter_where VARCHAR2 (2000);
288: l_func_area CONSTANT varchar2(5) := 'ITATR';

Line 285: l_col_tbl_cont poa_dbi_util_pkg.poa_dbi_col_tbl;

281: l_xtd VARCHAR2(500) ;
282: l_mv VARCHAR2 (240);
283: l_view_by_col VARCHAR2 (120);
284: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
285: l_col_tbl_cont poa_dbi_util_pkg.poa_dbi_col_tbl;
286: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
287: l_filter_where VARCHAR2 (2000);
288: l_func_area CONSTANT varchar2(5) := 'ITATR';
289: l_mv_set CONSTANT varchar2(3) := 'ITM';

Line 286: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

282: l_mv VARCHAR2 (240);
283: l_view_by_col VARCHAR2 (120);
284: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
285: l_col_tbl_cont poa_dbi_util_pkg.poa_dbi_col_tbl;
286: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
287: l_filter_where VARCHAR2 (2000);
288: l_func_area CONSTANT varchar2(5) := 'ITATR';
289: l_mv_set CONSTANT varchar2(3) := 'ITM';
290: l_version varchar2(3) := NULL;

Line 305: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();

301: p_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
302:
303: /* Trial for Util Package.. */
304:
305: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
306: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
307: l_col_tbl_cont := poa_dbi_util_pkg.poa_dbi_col_tbl ();
308:
309:

Line 306: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();

302:
303: /* Trial for Util Package.. */
304:
305: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
306: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
307: l_col_tbl_cont := poa_dbi_util_pkg.poa_dbi_col_tbl ();
308:
309:
310: bix_pmv_dbi_utl_pkg.process_parameters

Line 307: l_col_tbl_cont := poa_dbi_util_pkg.poa_dbi_col_tbl ();

303: /* Trial for Util Package.. */
304:
305: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
306: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
307: l_col_tbl_cont := poa_dbi_util_pkg.poa_dbi_col_tbl ();
308:
309:
310: bix_pmv_dbi_utl_pkg.process_parameters
311: ( p_param => p_page_parameter_tbl

Line 335: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

331: END IF;
332:
333:
334: -- Populate col table with columns for continued measures
335: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
336: , p_col_name => 'NULL'
337: , p_grand_total => 'N'
338: , p_alias_name => 'a'
339: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 339: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

335: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
336: , p_col_name => 'NULL'
337: , p_grand_total => 'N'
338: , p_alias_name => 'a'
339: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
340: , p_to_date_type => l_timetype
341: );
342: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
343: , p_col_name => 'NULL'

Line 342: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

338: , p_alias_name => 'a'
339: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
340: , p_to_date_type => l_timetype
341: );
342: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
343: , p_col_name => 'NULL'
344: , p_grand_total => 'N'
345: , p_alias_name => 'b'
346: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 346: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

342: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
343: , p_col_name => 'NULL'
344: , p_grand_total => 'N'
345: , p_alias_name => 'b'
346: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
347: , p_to_date_type => l_timetype
348: );
349:
350: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

Line 350: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

346: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
347: , p_to_date_type => l_timetype
348: );
349:
350: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
351: , p_col_name => 'NULL'
352: , p_grand_total => 'N'
353: , p_alias_name => 'c'
354: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 354: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

350: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
351: , p_col_name => 'NULL'
352: , p_grand_total => 'N'
353: , p_alias_name => 'c'
354: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
355: , p_to_date_type => l_timetype
356: );
357:
358: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

Line 358: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

354: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
355: , p_to_date_type => l_timetype
356: );
357:
358: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
359: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_cont_calls_offered_na END)'
360: , p_grand_total => 'N'
361: , p_alias_name => 'd'
362: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 362: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

358: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
359: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_cont_calls_offered_na END)'
360: , p_grand_total => 'N'
361: , p_alias_name => 'd'
362: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
363: , p_to_date_type => l_timetype
364: );
365:
366: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

Line 366: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

362: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
363: , p_to_date_type => l_timetype
364: );
365:
366: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
367: , p_col_name => 'NULL'
368: , p_grand_total => 'N'
369: , p_alias_name => 'e'
370: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 370: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

366: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
367: , p_col_name => 'NULL'
368: , p_grand_total => 'N'
369: , p_alias_name => 'e'
370: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
371: , p_to_date_type => l_timetype
372: );
373:
374: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

Line 374: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

370: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
371: , p_to_date_type => l_timetype
372: );
373:
374: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
375: , p_col_name => 'NULL'
376: , p_grand_total => 'N'
377: , p_alias_name => 'f'
378: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 378: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

374: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
375: , p_col_name => 'NULL'
376: , p_grand_total => 'N'
377: , p_alias_name => 'f'
378: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
379: , p_to_date_type => l_timetype
380: );
381:
382: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

Line 382: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

378: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
379: , p_to_date_type => l_timetype
380: );
381:
382: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
383: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_cont_calls_handled_tot_na END)'
384: , p_grand_total => 'N'
385: , p_alias_name => 'g'
386: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 386: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

382: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
383: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_cont_calls_handled_tot_na END)'
384: , p_grand_total => 'N'
385: , p_alias_name => 'g'
386: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
387: , p_to_date_type => l_timetype
388: );
389:
390: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

Line 390: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

386: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
387: , p_to_date_type => l_timetype
388: );
389:
390: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
391: , p_col_name => 'NULL'
392: , p_grand_total => 'N'
393: , p_alias_name => 'h'
394: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 394: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

390: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
391: , p_col_name => 'NULL'
392: , p_grand_total => 'N'
393: , p_alias_name => 'h'
394: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
395: , p_to_date_type => l_timetype
396: );
397:
398: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

Line 398: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

394: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
395: , p_to_date_type => l_timetype
396: );
397:
398: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
399: , p_col_name => 'call_cont_calls_handled_tot_na'
400: , p_grand_total => 'N'
401: , p_alias_name => 'i'
402: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 402: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

398: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
399: , p_col_name => 'call_cont_calls_handled_tot_na'
400: , p_grand_total => 'N'
401: , p_alias_name => 'i'
402: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
403: , p_to_date_type => l_timetype
404: );
405:
406: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

Line 406: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

402: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
403: , p_to_date_type => l_timetype
404: );
405:
406: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
407: , p_col_name => 'NULL'
408: , p_grand_total => 'N'
409: , p_alias_name => 'j'
410: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 410: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

406: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
407: , p_col_name => 'NULL'
408: , p_grand_total => 'N'
409: , p_alias_name => 'j'
410: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
411: , p_to_date_type => l_timetype
412: );
413:
414: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

Line 414: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

410: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
411: , p_to_date_type => l_timetype
412: );
413:
414: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
415: , p_col_name => 'NULL'
416: , p_grand_total => 'N'
417: , p_alias_name => 'k'
418: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 418: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

414: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
415: , p_col_name => 'NULL'
416: , p_grand_total => 'N'
417: , p_alias_name => 'k'
418: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
419: , p_to_date_type => l_timetype
420: );
421:
422: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

Line 422: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

418: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
419: , p_to_date_type => l_timetype
420: );
421:
422: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
423: , p_col_name => 'NULL'
424: , p_grand_total => 'N'
425: , p_alias_name => 'l'
426: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 426: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

422: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
423: , p_col_name => 'NULL'
424: , p_grand_total => 'N'
425: , p_alias_name => 'l'
426: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
427: , p_to_date_type => l_timetype
428: );
429:
430: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

Line 430: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

426: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
427: , p_to_date_type => l_timetype
428: );
429:
430: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
431: , p_col_name => 'NULL'
432: , p_grand_total => 'N'
433: , p_alias_name => 'm'
434: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 434: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

430: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
431: , p_col_name => 'NULL'
432: , p_grand_total => 'N'
433: , p_alias_name => 'm'
434: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
435: , p_to_date_type => l_timetype
436: );
437:
438: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

Line 438: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

434: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
435: , p_to_date_type => l_timetype
436: );
437:
438: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
439: , p_col_name => 'NULL'
440: , p_grand_total => 'N'
441: , p_alias_name => 'n'
442: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 442: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

438: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont
439: , p_col_name => 'NULL'
440: , p_grand_total => 'N'
441: , p_alias_name => 'n'
442: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
443: , p_to_date_type => l_timetype
444: );
445:
446:

Line 458: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl

454: , p_union => 'ALL');
455:
456: -- Populate col table with regular columns
457:
458: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl
459: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN agent_calls_answered_by_goal END)'
460: , p_grand_total => 'N'
461: , p_alias_name => 'a'
462: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 462: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

458: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl
459: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN agent_calls_answered_by_goal END)'
460: , p_grand_total => 'N'
461: , p_alias_name => 'a'
462: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
463: , p_to_date_type => l_timetype
464: );
465: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
466: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN agent_calls_handled_total END)'

Line 465: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

461: , p_alias_name => 'a'
462: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
463: , p_to_date_type => l_timetype
464: );
465: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
466: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN agent_calls_handled_total END)'
467: , p_grand_total => 'N'
468: , p_alias_name => 'b'
469: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 469: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

465: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
466: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN agent_calls_handled_total END)'
467: , p_grand_total => 'N'
468: , p_alias_name => 'b'
469: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
470: , p_to_date_type => l_timetype
471: );
472: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
473: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_tot_queue_to_answer END)'

Line 472: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

468: , p_alias_name => 'b'
469: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
470: , p_to_date_type => l_timetype
471: );
472: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
473: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_tot_queue_to_answer END)'
474: , p_grand_total => 'N'
475: , p_alias_name => 'c'
476: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 476: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

472: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
473: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_tot_queue_to_answer END)'
474: , p_grand_total => 'N'
475: , p_alias_name => 'c'
476: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
477: , p_to_date_type => l_timetype
478: );
479: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
480: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_calls_offered_total END)'

Line 479: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

475: , p_alias_name => 'c'
476: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
477: , p_to_date_type => l_timetype
478: );
479: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
480: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_calls_offered_total END)'
481: , p_grand_total => 'N'
482: , p_alias_name => 'd'
483: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 483: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

479: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
480: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_calls_offered_total END)'
481: , p_grand_total => 'N'
482: , p_alias_name => 'd'
483: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
484: , p_to_date_type => l_timetype
485: );
486: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
487: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_calls_abandoned END)'

Line 486: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

482: , p_alias_name => 'd'
483: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
484: , p_to_date_type => l_timetype
485: );
486: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
487: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_calls_abandoned END)'
488: , p_grand_total => 'N'
489: , p_alias_name => 'e'
490: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 490: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

486: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
487: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_calls_abandoned END)'
488: , p_grand_total => 'N'
489: , p_alias_name => 'e'
490: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
491: , p_to_date_type => l_timetype
492: );
493: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
494: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_calls_transferred END)'

Line 493: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

489: , p_alias_name => 'e'
490: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
491: , p_to_date_type => l_timetype
492: );
493: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
494: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_calls_transferred END)'
495: , p_grand_total => 'N'
496: , p_alias_name => 'f'
497: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 497: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

493: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
494: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_calls_transferred END)'
495: , p_grand_total => 'N'
496: , p_alias_name => 'f'
497: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
498: , p_to_date_type => l_timetype
499: );
500: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
501: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_calls_handled_total END)'

Line 500: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

496: , p_alias_name => 'f'
497: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
498: , p_to_date_type => l_timetype
499: );
500: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
501: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_calls_handled_total END)'
502: , p_grand_total => 'N'
503: , p_alias_name => 'g'
504: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 504: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

500: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
501: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN call_calls_handled_total END)'
502: , p_grand_total => 'N'
503: , p_alias_name => 'g'
504: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
505: , p_to_date_type => l_timetype
506: );
507: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
508: , p_col_name => '(CASE WHEN media_item_type=''TELE_WEB_CALLBACK'' THEN call_calls_handled_total END)'

Line 507: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

503: , p_alias_name => 'g'
504: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
505: , p_to_date_type => l_timetype
506: );
507: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
508: , p_col_name => '(CASE WHEN media_item_type=''TELE_WEB_CALLBACK'' THEN call_calls_handled_total END)'
509: , p_grand_total => 'N'
510: , p_alias_name => 'h'
511: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 511: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

507: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
508: , p_col_name => '(CASE WHEN media_item_type=''TELE_WEB_CALLBACK'' THEN call_calls_handled_total END)'
509: , p_grand_total => 'N'
510: , p_alias_name => 'h'
511: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
512: , p_to_date_type => l_timetype
513: );
514: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
515: , p_col_name => 'call_calls_handled_total'

Line 514: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

510: , p_alias_name => 'h'
511: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
512: , p_to_date_type => l_timetype
513: );
514: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
515: , p_col_name => 'call_calls_handled_total'
516: , p_grand_total => 'N'
517: , p_alias_name => 'i'
518: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 518: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

514: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
515: , p_col_name => 'call_calls_handled_total'
516: , p_grand_total => 'N'
517: , p_alias_name => 'i'
518: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
519: , p_to_date_type => l_timetype
520: );
521: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
522: , p_col_name => 'agent_wrap_time_nac'

Line 521: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

517: , p_alias_name => 'i'
518: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
519: , p_to_date_type => l_timetype
520: );
521: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
522: , p_col_name => 'agent_wrap_time_nac'
523: , p_grand_total => 'N'
524: , p_alias_name => 'j'
525: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 525: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

521: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
522: , p_col_name => 'agent_wrap_time_nac'
523: , p_grand_total => 'N'
524: , p_alias_name => 'j'
525: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
526: , p_to_date_type => l_timetype
527: );
528: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
529: , p_col_name => 'call_talk_time'

Line 528: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

524: , p_alias_name => 'j'
525: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
526: , p_to_date_type => l_timetype
527: );
528: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
529: , p_col_name => 'call_talk_time'
530: , p_grand_total => 'N'
531: , p_alias_name => 'k'
532: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 532: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

528: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
529: , p_col_name => 'call_talk_time'
530: , p_grand_total => 'N'
531: , p_alias_name => 'k'
532: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
533: , p_to_date_type => l_timetype
534: );
535: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
536: , p_col_name => 'agent_sr_created'

Line 535: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

531: , p_alias_name => 'k'
532: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
533: , p_to_date_type => l_timetype
534: );
535: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
536: , p_col_name => 'agent_sr_created'
537: , p_grand_total => 'N'
538: , p_alias_name => 'l'
539: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 539: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

535: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
536: , p_col_name => 'agent_sr_created'
537: , p_grand_total => 'N'
538: , p_alias_name => 'l'
539: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
540: , p_to_date_type => l_timetype
541: );
542: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
543: , p_col_name => 'agent_leads_created'

Line 542: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

538: , p_alias_name => 'l'
539: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
540: , p_to_date_type => l_timetype
541: );
542: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
543: , p_col_name => 'agent_leads_created'
544: , p_grand_total => 'N'
545: , p_alias_name => 'm'
546: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 546: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

542: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
543: , p_col_name => 'agent_leads_created'
544: , p_grand_total => 'N'
545: , p_alias_name => 'm'
546: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
547: , p_to_date_type => l_timetype
548: );
549: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
550: , p_col_name => 'agent_opportunities_created'

Line 549: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

545: , p_alias_name => 'm'
546: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
547: , p_to_date_type => l_timetype
548: );
549: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
550: , p_col_name => 'agent_opportunities_created'
551: , p_grand_total => 'N'
552: , p_alias_name => 'n'
553: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 553: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

549: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
550: , p_col_name => 'agent_opportunities_created'
551: , p_grand_total => 'N'
552: , p_alias_name => 'n'
553: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
554: , p_to_date_type => l_timetype
555: );
556:
557: l_sqltext :='select rset.*,BIX_PMV_AI_SL_CP BIX_CALC_ITEM1,BIX_PMV_TOTAL1 BIX_CALC_ITEM2,'