APPS.BIX_PMV_AI_AGTDTL_RPT_PKG dependencies on POA_DBI_UTIL_PKG

Line 359: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

355: l_mv_sess VARCHAR2(240);
356: l_comp_type VARCHAR2(500);
357: l_xtd VARCHAR2(500);
358:
359: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
360: l_col_tbl_cont poa_dbi_util_pkg.poa_dbi_col_tbl;
361: l_col_tbl_sess poa_dbi_util_pkg.poa_dbi_col_tbl;
362:
363: l_where_clause VARCHAR2(1000) ;

Line 360: l_col_tbl_cont poa_dbi_util_pkg.poa_dbi_col_tbl;

356: l_comp_type VARCHAR2(500);
357: l_xtd VARCHAR2(500);
358:
359: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
360: l_col_tbl_cont poa_dbi_util_pkg.poa_dbi_col_tbl;
361: l_col_tbl_sess poa_dbi_util_pkg.poa_dbi_col_tbl;
362:
363: l_where_clause VARCHAR2(1000) ;
364: l_where_clause_sess VARCHAR2(1000);

Line 361: l_col_tbl_sess poa_dbi_util_pkg.poa_dbi_col_tbl;

357: l_xtd VARCHAR2(500);
358:
359: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
360: l_col_tbl_cont poa_dbi_util_pkg.poa_dbi_col_tbl;
361: l_col_tbl_sess poa_dbi_util_pkg.poa_dbi_col_tbl;
362:
363: l_where_clause VARCHAR2(1000) ;
364: l_where_clause_sess VARCHAR2(1000);
365:

Line 366: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

362:
363: l_where_clause VARCHAR2(1000) ;
364: l_where_clause_sess VARCHAR2(1000);
365:
366: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
367: l_join_tbl_sess poa_dbi_util_pkg.poa_dbi_join_tbl;
368:
369: l_filter_where VARCHAR2 (2000);
370: l_filter_where_sess VARCHAR2 (2000);

Line 367: l_join_tbl_sess poa_dbi_util_pkg.poa_dbi_join_tbl;

363: l_where_clause VARCHAR2(1000) ;
364: l_where_clause_sess VARCHAR2(1000);
365:
366: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
367: l_join_tbl_sess poa_dbi_util_pkg.poa_dbi_join_tbl;
368:
369: l_filter_where VARCHAR2 (2000);
370: l_filter_where_sess VARCHAR2 (2000);
371:

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

387:
388: --insert into bix_Debug values (1);
389: /* Trial for Util Package..*/
390:
391: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
392: l_join_tbl_sess := poa_dbi_util_pkg.poa_dbi_join_tbl ();
393:
394: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
395: l_col_tbl_cont := poa_dbi_util_pkg.poa_dbi_col_tbl ();

Line 392: l_join_tbl_sess := poa_dbi_util_pkg.poa_dbi_join_tbl ();

388: --insert into bix_Debug values (1);
389: /* Trial for Util Package..*/
390:
391: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
392: l_join_tbl_sess := poa_dbi_util_pkg.poa_dbi_join_tbl ();
393:
394: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
395: l_col_tbl_cont := poa_dbi_util_pkg.poa_dbi_col_tbl ();
396: l_col_tbl_sess := poa_dbi_util_pkg.poa_dbi_col_tbl ();

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

390:
391: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
392: l_join_tbl_sess := poa_dbi_util_pkg.poa_dbi_join_tbl ();
393:
394: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
395: l_col_tbl_cont := poa_dbi_util_pkg.poa_dbi_col_tbl ();
396: l_col_tbl_sess := poa_dbi_util_pkg.poa_dbi_col_tbl ();
397:
398: bix_pmv_dbi_utl_pkg.process_parameters

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

391: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl ();
392: l_join_tbl_sess := poa_dbi_util_pkg.poa_dbi_join_tbl ();
393:
394: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
395: l_col_tbl_cont := poa_dbi_util_pkg.poa_dbi_col_tbl ();
396: l_col_tbl_sess := poa_dbi_util_pkg.poa_dbi_col_tbl ();
397:
398: bix_pmv_dbi_utl_pkg.process_parameters
399: ( p_param => p_page_parameter_tbl

Line 396: l_col_tbl_sess := poa_dbi_util_pkg.poa_dbi_col_tbl ();

392: l_join_tbl_sess := poa_dbi_util_pkg.poa_dbi_join_tbl ();
393:
394: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl ();
395: l_col_tbl_cont := poa_dbi_util_pkg.poa_dbi_col_tbl ();
396: l_col_tbl_sess := poa_dbi_util_pkg.poa_dbi_col_tbl ();
397:
398: bix_pmv_dbi_utl_pkg.process_parameters
399: ( p_param => p_page_parameter_tbl
400: , p_trend => 'N'

Line 414: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_cont

410: , p_view_by => l_view_by
411: );
412:
413: -- Populate col table with columns for continued measures
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 => 't'
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 => 't'
418: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
419: , p_to_date_type => l_timetype
420: );
421: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
422: , p_col_name => 'NULL'

Line 421: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont

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

Line 425: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

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

Line 428: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont

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

Line 432: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

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

Line 435: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont

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

Line 439: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

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

Line 442: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont

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

Line 446: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

442: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
443: , p_col_name => 'NULL'
444: , p_grand_total => 'N'
445: , p_alias_name => 'mc'
446: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
447: , p_to_date_type => l_timetype
448: );
449: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
450: , p_col_name => 'NULL'

Line 449: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont

445: , p_alias_name => 'mc'
446: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
447: , p_to_date_type => l_timetype
448: );
449: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
450: , p_col_name => 'NULL'
451: , p_grand_total => 'N'
452: , p_alias_name => 'tc'
453: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 453: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

449: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
450: , p_col_name => 'NULL'
451: , p_grand_total => 'N'
452: , p_alias_name => 'tc'
453: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
454: , p_to_date_type => l_timetype
455: );
456: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
457: , p_col_name => 'agent_cont_calls_hand_na'

Line 456: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont

452: , p_alias_name => 'tc'
453: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
454: , p_to_date_type => l_timetype
455: );
456: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
457: , p_col_name => 'agent_cont_calls_hand_na'
458: , p_grand_total => 'N'
459: , p_alias_name => 'cch'
460: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 460: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

456: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
457: , p_col_name => 'agent_cont_calls_hand_na'
458: , p_grand_total => 'N'
459: , p_alias_name => 'cch'
460: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
461: , p_to_date_type => l_timetype
462: );
463: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
464: , p_col_name => 'NULL'

Line 463: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont

459: , p_alias_name => 'cch'
460: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
461: , p_to_date_type => l_timetype
462: );
463: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
464: , p_col_name => 'NULL'
465: , p_grand_total => 'N'
466: , p_alias_name => 'ctc'
467: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 467: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

463: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
464: , p_col_name => 'NULL'
465: , p_grand_total => 'N'
466: , p_alias_name => 'ctc'
467: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
468: , p_to_date_type => l_timetype
469: );
470: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
471: , p_col_name => 'agent_cont_calls_tc_na'

Line 470: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont

466: , p_alias_name => 'ctc'
467: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
468: , p_to_date_type => l_timetype
469: );
470: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
471: , p_col_name => 'agent_cont_calls_tc_na'
472: , p_grand_total => 'N'
473: , p_alias_name => 'cct'
474: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 474: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

470: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
471: , p_col_name => 'agent_cont_calls_tc_na'
472: , p_grand_total => 'N'
473: , p_alias_name => 'cct'
474: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
475: , p_to_date_type => l_timetype
476: );
477: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
478: , p_col_name => 'NULL'

Line 477: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont

473: , p_alias_name => 'cct'
474: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
475: , p_to_date_type => l_timetype
476: );
477: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
478: , p_col_name => 'NULL'
479: , p_grand_total => 'N'
480: , p_alias_name => 'l'
481: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 481: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

477: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
478: , p_col_name => 'NULL'
479: , p_grand_total => 'N'
480: , p_alias_name => 'l'
481: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
482: , p_to_date_type => l_timetype
483: );
484: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
485: , p_col_name => 'NULL'

Line 484: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont

480: , p_alias_name => 'l'
481: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
482: , p_to_date_type => l_timetype
483: );
484: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
485: , p_col_name => 'NULL'
486: , p_grand_total => 'N'
487: , p_alias_name => 'o'
488: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 488: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

484: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
485: , p_col_name => 'NULL'
486: , p_grand_total => 'N'
487: , p_alias_name => 'o'
488: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
489: , p_to_date_type => l_timetype
490: );
491: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
492: , p_col_name => 'NULL'

Line 491: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont

487: , p_alias_name => 'o'
488: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
489: , p_to_date_type => l_timetype
490: );
491: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
492: , p_col_name => 'NULL'
493: , p_grand_total => 'N'
494: , p_alias_name => 's'
495: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 495: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

491: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
492: , p_col_name => 'NULL'
493: , p_grand_total => 'N'
494: , p_alias_name => 's'
495: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
496: , p_to_date_type => l_timetype
497: );
498: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
499: , p_col_name => 'NULL'

Line 498: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont

494: , p_alias_name => 's'
495: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
496: , p_to_date_type => l_timetype
497: );
498: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
499: , p_col_name => 'NULL'
500: , p_grand_total => 'N'
501: , p_alias_name => 'lg'
502: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 502: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

498: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
499: , p_col_name => 'NULL'
500: , p_grand_total => 'N'
501: , p_alias_name => 'lg'
502: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
503: , p_to_date_type => l_timetype
504: );
505: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
506: , p_col_name => 'NULL'

Line 505: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont

501: , p_alias_name => 'lg'
502: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
503: , p_to_date_type => l_timetype
504: );
505: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
506: , p_col_name => 'NULL'
507: , p_grand_total => 'N'
508: , p_alias_name => 'id'
509: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 509: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

505: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
506: , p_col_name => 'NULL'
507: , p_grand_total => 'N'
508: , p_alias_name => 'id'
509: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
510: , p_to_date_type => l_timetype
511: );
512: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
513: , p_col_name => 'NULL'

Line 512: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont

508: , p_alias_name => 'id'
509: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
510: , p_to_date_type => l_timetype
511: );
512: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
513: , p_col_name => 'NULL'
514: , p_grand_total => 'N'
515: , p_alias_name => 'av'
516: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 516: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

512: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl_cont
513: , p_col_name => 'NULL'
514: , p_grand_total => 'N'
515: , p_alias_name => 'av'
516: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
517: , p_to_date_type => l_timetype
518: );
519:
520: l_sqltext_cont :=

Line 553: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_sess

549: -- Populate col_table_session with session measures
550:
551: --insert into bix_Debug values ('Starting add columns for session');
552:
553: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_sess
554: , p_col_name => 'login_time'
555: , p_grand_total => 'N'
556: , p_alias_name => 'lg'
557: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 557: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

553: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_sess
554: , p_col_name => 'login_time'
555: , p_grand_total => 'N'
556: , p_alias_name => 'lg'
557: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
558: , p_to_date_type => l_timetype
559: );
560: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_sess
561: , p_col_name => 'idle_time'

Line 560: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_sess

556: , p_alias_name => 'lg'
557: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
558: , p_to_date_type => l_timetype
559: );
560: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_sess
561: , p_col_name => 'idle_time'
562: , p_grand_total => 'N'
563: , p_alias_name => 'id'
564: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 564: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

560: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_sess
561: , p_col_name => 'idle_time'
562: , p_grand_total => 'N'
563: , p_alias_name => 'id'
564: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
565: , p_to_date_type => l_timetype
566: );
567: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_sess
568: , p_col_name => 'available_time'

Line 567: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_sess

563: , p_alias_name => 'id'
564: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
565: , p_to_date_type => l_timetype
566: );
567: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_sess
568: , p_col_name => 'available_time'
569: , p_grand_total => 'N'
570: , p_alias_name => 'av'
571: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 571: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

567: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl_sess
568: , p_col_name => 'available_time'
569: , p_grand_total => 'N'
570: , p_alias_name => 'av'
571: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
572: , p_to_date_type => l_timetype
573: );
574:
575: --insert into bix_Debug values ('Setting nulls in l_sqltext_sess ');

Line 615: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl

611: --insert into bix_Debug values ('Calling add_column for regular columns');
612:
613: -- Populate col table with regular columns
614:
615: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl
616: , p_col_name => 'agent_talk_time_nac'
617: , p_grand_total => 'N'
618: , p_alias_name => 't'
619: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 619: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

615: poa_dbi_util_pkg.add_column(p_col_tbl => l_col_tbl
616: , p_col_name => 'agent_talk_time_nac'
617: , p_grand_total => 'N'
618: , p_alias_name => 't'
619: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
620: , p_to_date_type => l_timetype
621: );
622: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
623: , p_col_name => 'agent_wrap_time_nac'

Line 622: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

618: , p_alias_name => 't'
619: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
620: , p_to_date_type => l_timetype
621: );
622: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
623: , p_col_name => 'agent_wrap_time_nac'
624: , p_grand_total => 'N'
625: , p_alias_name => 'w'
626: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 626: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

622: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
623: , p_col_name => 'agent_wrap_time_nac'
624: , p_grand_total => 'N'
625: , p_alias_name => 'w'
626: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
627: , p_to_date_type => l_timetype
628: );
629: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
630: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN agent_calls_handled_total END)'

Line 629: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

625: , p_alias_name => 'w'
626: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
627: , p_to_date_type => l_timetype
628: );
629: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
630: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN agent_calls_handled_total END)'
631: , p_grand_total => 'N'
632: , p_alias_name => 'ic'
633: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 633: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

629: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
630: , p_col_name => '(CASE WHEN media_item_type in (''TELE_INB'',''TELE_DIRECT'') THEN agent_calls_handled_total END)'
631: , p_grand_total => 'N'
632: , p_alias_name => 'ic'
633: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
634: , p_to_date_type => l_timetype
635: );
636: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
637: , p_col_name => '(CASE WHEN media_item_type in (''TELE_WEB_CALLBACK'') THEN agent_calls_handled_total END)'

Line 636: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

632: , p_alias_name => 'ic'
633: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
634: , p_to_date_type => l_timetype
635: );
636: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
637: , p_col_name => '(CASE WHEN media_item_type in (''TELE_WEB_CALLBACK'') THEN agent_calls_handled_total END)'
638: , p_grand_total => 'N'
639: , p_alias_name => 'wc'
640: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 640: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

636: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
637: , p_col_name => '(CASE WHEN media_item_type in (''TELE_WEB_CALLBACK'') THEN agent_calls_handled_total END)'
638: , p_grand_total => 'N'
639: , p_alias_name => 'wc'
640: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
641: , p_to_date_type => l_timetype
642: );
643: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
644: , p_col_name => '(CASE WHEN media_item_type in (''TELE_MANUAL'') THEN agent_calls_handled_total END)'

Line 643: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

639: , p_alias_name => 'wc'
640: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
641: , p_to_date_type => l_timetype
642: );
643: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
644: , p_col_name => '(CASE WHEN media_item_type in (''TELE_MANUAL'') THEN agent_calls_handled_total END)'
645: , p_grand_total => 'N'
646: , p_alias_name => 'mc'
647: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 647: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

643: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
644: , p_col_name => '(CASE WHEN media_item_type in (''TELE_MANUAL'') THEN agent_calls_handled_total END)'
645: , p_grand_total => 'N'
646: , p_alias_name => 'mc'
647: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
648: , p_to_date_type => l_timetype
649: );
650: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
651: , p_col_name => 'agent_calls_handled_total'

Line 650: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

646: , p_alias_name => 'mc'
647: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
648: , p_to_date_type => l_timetype
649: );
650: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
651: , p_col_name => 'agent_calls_handled_total'
652: , p_grand_total => 'N'
653: , p_alias_name => 'tc'
654: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 654: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

650: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
651: , p_col_name => 'agent_calls_handled_total'
652: , p_grand_total => 'N'
653: , p_alias_name => 'tc'
654: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
655: , p_to_date_type => l_timetype
656: );
657: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
658: , p_col_name => 'NULL'

Line 657: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

653: , p_alias_name => 'tc'
654: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
655: , p_to_date_type => l_timetype
656: );
657: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
658: , p_col_name => 'NULL'
659: , p_grand_total => 'N'
660: , p_alias_name => 'cch'
661: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 661: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

657: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
658: , p_col_name => 'NULL'
659: , p_grand_total => 'N'
660: , p_alias_name => 'cch'
661: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
662: , p_to_date_type => l_timetype
663: );
664: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
665: , p_col_name => 'agent_calls_tran_conf_to_nac'

Line 664: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

660: , p_alias_name => 'cch'
661: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
662: , p_to_date_type => l_timetype
663: );
664: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
665: , p_col_name => 'agent_calls_tran_conf_to_nac'
666: , p_grand_total => 'N'
667: , p_alias_name => 'ctc'
668: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 668: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

664: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
665: , p_col_name => 'agent_calls_tran_conf_to_nac'
666: , p_grand_total => 'N'
667: , p_alias_name => 'ctc'
668: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
669: , p_to_date_type => l_timetype
670: );
671: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
672: , p_col_name => 'NULL'

Line 671: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

667: , p_alias_name => 'ctc'
668: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
669: , p_to_date_type => l_timetype
670: );
671: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
672: , p_col_name => 'NULL'
673: , p_grand_total => 'N'
674: , p_alias_name => 'cct'
675: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 675: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

671: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
672: , p_col_name => 'NULL'
673: , p_grand_total => 'N'
674: , p_alias_name => 'cct'
675: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
676: , p_to_date_type => l_timetype
677: );
678: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
679: , p_col_name => 'agent_leads_created'

Line 678: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

674: , p_alias_name => 'cct'
675: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
676: , p_to_date_type => l_timetype
677: );
678: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
679: , p_col_name => 'agent_leads_created'
680: , p_grand_total => 'N'
681: , p_alias_name => 'l'
682: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 682: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

678: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
679: , p_col_name => 'agent_leads_created'
680: , p_grand_total => 'N'
681: , p_alias_name => 'l'
682: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
683: , p_to_date_type => l_timetype
684: );
685: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
686: , p_col_name => 'agent_opportunities_created'

Line 685: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

681: , p_alias_name => 'l'
682: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
683: , p_to_date_type => l_timetype
684: );
685: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
686: , p_col_name => 'agent_opportunities_created'
687: , p_grand_total => 'N'
688: , p_alias_name => 'o'
689: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 689: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

685: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
686: , p_col_name => 'agent_opportunities_created'
687: , p_grand_total => 'N'
688: , p_alias_name => 'o'
689: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
690: , p_to_date_type => l_timetype
691: );
692: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
693: , p_col_name => 'agent_sr_created'

Line 692: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

688: , p_alias_name => 'o'
689: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
690: , p_to_date_type => l_timetype
691: );
692: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
693: , p_col_name => 'agent_sr_created'
694: , p_grand_total => 'N'
695: , p_alias_name => 's'
696: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 696: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

692: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
693: , p_col_name => 'agent_sr_created'
694: , p_grand_total => 'N'
695: , p_alias_name => 's'
696: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
697: , p_to_date_type => l_timetype
698: );
699: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
700: , p_col_name => 'NULL'

Line 699: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

695: , p_alias_name => 's'
696: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
697: , p_to_date_type => l_timetype
698: );
699: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
700: , p_col_name => 'NULL'
701: , p_grand_total => 'N'
702: , p_alias_name => 'lg'
703: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 703: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

699: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
700: , p_col_name => 'NULL'
701: , p_grand_total => 'N'
702: , p_alias_name => 'lg'
703: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
704: , p_to_date_type => l_timetype
705: );
706: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
707: , p_col_name => 'NULL'

Line 706: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

702: , p_alias_name => 'lg'
703: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
704: , p_to_date_type => l_timetype
705: );
706: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
707: , p_col_name => 'NULL'
708: , p_grand_total => 'N'
709: , p_alias_name => 'id'
710: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 710: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

706: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
707: , p_col_name => 'NULL'
708: , p_grand_total => 'N'
709: , p_alias_name => 'id'
710: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
711: , p_to_date_type => l_timetype
712: );
713: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
714: , p_col_name => 'NULL'

Line 713: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl

709: , p_alias_name => 'id'
710: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
711: , p_to_date_type => l_timetype
712: );
713: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
714: , p_col_name => 'NULL'
715: , p_grand_total => 'N'
716: , p_alias_name => 'av'
717: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

Line 717: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY

713: poa_dbi_util_pkg.add_column (p_col_tbl => l_col_tbl
714: , p_col_name => 'NULL'
715: , p_grand_total => 'N'
716: , p_alias_name => 'av'
717: , p_prior_code => poa_dbi_util_pkg.COL_PRIOR_ONLY
718: , p_to_date_type => l_timetype
719: );
720:
721: