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.BIV_DBI_ACT_PKG dependencies on POA_DBI_UTIL_PKG

Line 40: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

36: l_where_clause varchar2(10000);
37: l_mv varchar2(10000);
38: l_stmt varchar2(32767);
39:
40: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
41: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
42:
43: l_custom_output bis_query_attributes_tbl;
44:

Line 41: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

37: l_mv varchar2(10000);
38: l_stmt varchar2(32767);
39:
40: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
41: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
42:
43: l_custom_output bis_query_attributes_tbl;
44:
45: l_to_date_type VARCHAR2 (3) ;

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

47:
48: begin
49:
50: -- clear out the tables.
51: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
52: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
53:
54: biv_dbi_tmpl_util.process_parameters
55: ( p_param => p_param

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

48: begin
49:
50: -- clear out the tables.
51: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
52: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
53:
54: biv_dbi_tmpl_util.process_parameters
55: ( p_param => p_param
56: , p_report_type => 'ACTIVITY'

Line 78: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

74: l_to_date_type := 'RLX';
75: END IF;
76:
77:
78: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
79: , p_col_name => 'first_opened_count'
80: , p_alias_name => 'first_opened'
81: , p_to_date_type => l_to_date_type
82: );

Line 84: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

80: , p_alias_name => 'first_opened'
81: , p_to_date_type => l_to_date_type
82: );
83:
84: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
85: , p_col_name => 'reopened_count'
86: , p_alias_name => 'reopened'
87: , p_to_date_type => l_to_date_type
88: );

Line 90: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

86: , p_alias_name => 'reopened'
87: , p_to_date_type => l_to_date_type
88: );
89:
90: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
91: , p_col_name => 'closed_count'
92: , p_alias_name => 'closed'
93: , p_to_date_type => l_to_date_type
94: );

Line 246: poa_dbi_util_pkg.get_custom_rolling_binds

242: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
243:
244: x_custom_sql := l_stmt;
245:
246: poa_dbi_util_pkg.get_custom_rolling_binds
247: ( p_custom_output => l_custom_output
248: , p_xtd => l_xtd
249: );
250:

Line 273: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

269: l_activity_stmt varchar2(32767);
270: l_stmt varchar2(32767);
271: l_balance_fact varchar2(200);
272:
273: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
274: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
275:
276: l_custom_output bis_query_attributes_tbl;
277:

Line 274: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

270: l_stmt varchar2(32767);
271: l_balance_fact varchar2(200);
272:
273: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
274: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
275:
276: l_custom_output bis_query_attributes_tbl;
277:
278: l_to_date_type VARCHAR2 (3) ;

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

280:
281: begin
282:
283: -- clear out the tables.
284: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
285: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
286:
287: biv_dbi_tmpl_util.process_parameters
288: ( p_param => p_param

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

281: begin
282:
283: -- clear out the tables.
284: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
285: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
286:
287: biv_dbi_tmpl_util.process_parameters
288: ( p_param => p_param
289: , p_report_type => 'BACKLOG'

Line 309: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

305: ELSE
306: l_to_date_type := 'BAL';
307: END IF;
308:
309: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
310: , p_col_name => 'backlog_count'
311: , p_alias_name => 'backlog'
312: , p_to_date_type => l_to_date_type
313: , p_grand_total => 'N'

Line 314: , p_prior_code => poa_dbi_util_pkg.OPENING_PRIOR_CURR

310: , p_col_name => 'backlog_count'
311: , p_alias_name => 'backlog'
312: , p_to_date_type => l_to_date_type
313: , p_grand_total => 'N'
314: , p_prior_code => poa_dbi_util_pkg.OPENING_PRIOR_CURR
315: );
316:
317: l_backlog_stmt := 'select
318: ' || l_view_by_col_name || '

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

348:
349: l_balance_fact := biv_dbi_tmpl_util.get_balance_fact(l_mv);
350:
351: -- clear out the tables.
352: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
353: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
354:
355: biv_dbi_tmpl_util.process_parameters
356: ( p_param => p_param

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

349: l_balance_fact := biv_dbi_tmpl_util.get_balance_fact(l_mv);
350:
351: -- clear out the tables.
352: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
353: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
354:
355: biv_dbi_tmpl_util.process_parameters
356: ( p_param => p_param
357: , p_report_type => 'ACTIVITY'

Line 377: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

373: ELSE
374: l_to_date_type := 'RLX';
375: END IF;
376:
377: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
378: , p_col_name => 'first_opened_count'
379: , p_alias_name => 'first_opened'
380: , p_to_date_type => l_to_date_type
381: , p_grand_total => 'N'

Line 384: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

380: , p_to_date_type => l_to_date_type
381: , p_grand_total => 'N'
382: );
383:
384: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
385: , p_col_name => 'reopened_count'
386: , p_alias_name => 'reopened'
387: , p_to_date_type => l_to_date_type
388: , p_grand_total => 'N'

Line 391: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

387: , p_to_date_type => l_to_date_type
388: , p_grand_total => 'N'
389: );
390:
391: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
392: , p_col_name => 'closed_count'
393: , p_alias_name => 'closed'
394: , p_to_date_type => l_to_date_type
395: , p_grand_total => 'N'

Line 551: poa_dbi_util_pkg.get_custom_balance_binds

547: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
548:
549: x_custom_sql := l_stmt;
550:
551: poa_dbi_util_pkg.get_custom_balance_binds
552: ( p_custom_output => l_custom_output
553: , p_balance_fact => l_balance_fact
554: , p_xtd => l_xtd
555: );

Line 557: poa_dbi_util_pkg.get_custom_rolling_binds

553: , p_balance_fact => l_balance_fact
554: , p_xtd => l_xtd
555: );
556:
557: poa_dbi_util_pkg.get_custom_rolling_binds
558: ( p_custom_output => l_custom_output
559: , p_xtd => l_xtd
560: );
561:

Line 581: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

577: l_where_clause varchar2(10000);
578: l_mv varchar2(10000);
579: l_stmt varchar2(32767);
580:
581: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
582: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
583:
584: l_custom_output bis_query_attributes_tbl;
585:

Line 582: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

578: l_mv varchar2(10000);
579: l_stmt varchar2(32767);
580:
581: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
582: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
583:
584: l_custom_output bis_query_attributes_tbl;
585:
586: l_to_date_type VARCHAR2 (3) ;

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

589:
590: begin
591:
592: -- clear out the tables.
593: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
594: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
595:
596: biv_dbi_tmpl_util.process_parameters
597: ( p_param => p_param

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

590: begin
591:
592: -- clear out the tables.
593: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
594: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
595:
596: biv_dbi_tmpl_util.process_parameters
597: ( p_param => p_param
598: , p_report_type => 'ACTIVITY'

Line 619: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

615: l_to_date_type := 'RLX';
616: END IF;
617:
618:
619: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
620: , p_col_name => 'first_opened_count'
621: , p_alias_name => 'first_opened'
622: , p_to_date_type => l_to_date_type
623: , p_grand_total => 'N'

Line 626: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

622: , p_to_date_type => l_to_date_type
623: , p_grand_total => 'N'
624: );
625:
626: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
627: , p_col_name => 'reopened_count'
628: , p_alias_name => 'reopened'
629: , p_to_date_type => l_to_date_type
630: , p_grand_total => 'N'

Line 633: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

629: , p_to_date_type => l_to_date_type
630: , p_grand_total => 'N'
631: );
632:
633: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
634: , p_col_name => 'closed_count'
635: , p_alias_name => 'closed'
636: , p_to_date_type => l_to_date_type
637: , p_grand_total => 'N'

Line 731: poa_dbi_util_pkg.get_custom_trend_binds

727: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
728:
729: x_custom_sql := l_stmt;
730:
731: poa_dbi_util_pkg.get_custom_trend_binds
732: ( x_custom_output => l_custom_output
733: , p_xtd => l_xtd
734: , p_comparison_type => l_comparison_type
735: );

Line 737: poa_dbi_util_pkg.get_custom_rolling_binds

733: , p_xtd => l_xtd
734: , p_comparison_type => l_comparison_type
735: );
736:
737: poa_dbi_util_pkg.get_custom_rolling_binds
738: ( p_custom_output => l_custom_output
739: , p_xtd => l_xtd
740: );
741:

Line 744: poa_dbi_util_pkg.get_custom_day_binds(p_custom_output => l_custom_output,

740: );
741:
742: IF(l_xtd = 'DAY')
743: THEN
744: poa_dbi_util_pkg.get_custom_day_binds(p_custom_output => l_custom_output,
745: p_as_of_date => l_as_of_date,
746: p_comparison_type => l_comparison_type);
747: null;
748: END IF;

Line 773: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;

769: l_activity_stmt varchar2(32767);
770: l_stmt varchar2(32767);
771: l_balance_fact varchar2(200);
772:
773: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
774: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
775:
776: l_custom_output bis_query_attributes_tbl;
777:

Line 774: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;

770: l_stmt varchar2(32767);
771: l_balance_fact varchar2(200);
772:
773: l_col_tbl poa_dbi_util_pkg.poa_dbi_col_tbl;
774: l_join_tbl poa_dbi_util_pkg.poa_dbi_join_tbl;
775:
776: l_custom_output bis_query_attributes_tbl;
777:
778: l_to_date_type VARCHAR2 (3) ;

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

780:
781: begin
782:
783: -- clear out the tables.
784: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
785: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
786:
787: biv_dbi_tmpl_util.process_parameters
788: ( p_param => p_param

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

781: begin
782:
783: -- clear out the tables.
784: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
785: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
786:
787: biv_dbi_tmpl_util.process_parameters
788: ( p_param => p_param
789: , p_report_type => 'BACKLOG'

Line 810: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

806: l_to_date_type := 'BAL';
807: END IF;
808:
809:
810: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
811: , p_col_name => 'backlog_count'
812: , p_alias_name => 'backlog'
813: , p_to_date_type => l_to_date_type
814: , p_grand_total => 'N'

Line 815: , p_prior_code => poa_dbi_util_pkg.OPENING_PRIOR_CURR

811: , p_col_name => 'backlog_count'
812: , p_alias_name => 'backlog'
813: , p_to_date_type => l_to_date_type
814: , p_grand_total => 'N'
815: , p_prior_code => poa_dbi_util_pkg.OPENING_PRIOR_CURR
816: );
817:
818: l_backlog_stmt := 'select
819: cal.name

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

840: l_balance_fact := biv_dbi_tmpl_util.get_balance_fact(l_mv);
841:
842:
843: -- clear out the tables.
844: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
845: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
846:
847: biv_dbi_tmpl_util.process_parameters
848: ( p_param => p_param

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

841:
842:
843: -- clear out the tables.
844: l_col_tbl := poa_dbi_util_pkg.poa_dbi_col_tbl();
845: l_join_tbl := poa_dbi_util_pkg.poa_dbi_join_tbl();
846:
847: biv_dbi_tmpl_util.process_parameters
848: ( p_param => p_param
849: , p_report_type => 'ACTIVITY'

Line 869: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

865: ELSE
866: l_to_date_type := 'RLX';
867: END IF;
868:
869: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
870: , p_col_name => 'first_opened_count'
871: , p_alias_name => 'first_opened'
872: , p_to_date_type => l_to_date_type
873: , p_grand_total => 'N'

Line 876: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

872: , p_to_date_type => l_to_date_type
873: , p_grand_total => 'N'
874: );
875:
876: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
877: , p_col_name => 'reopened_count'
878: , p_alias_name => 'reopened'
879: , p_to_date_type => l_to_date_type
880: , p_grand_total => 'N'

Line 883: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl

879: , p_to_date_type => l_to_date_type
880: , p_grand_total => 'N'
881: );
882:
883: poa_dbi_util_pkg.add_column( p_col_tbl => l_col_tbl
884: , p_col_name => 'closed_count'
885: , p_alias_name => 'closed'
886: , p_to_date_type => l_to_date_type
887: , p_grand_total => 'N'

Line 991: poa_dbi_util_pkg.get_custom_trend_binds

987: -- l_stmt := l_stmt || biv_dbi_tmpl_util.dump_parameters(p_param);
988:
989: x_custom_sql := l_stmt;
990:
991: poa_dbi_util_pkg.get_custom_trend_binds
992: ( x_custom_output => l_custom_output
993: , p_xtd => l_xtd
994: , p_comparison_type => l_comparison_type
995: -- only need to make lag offset adjustment for Week

Line 999: poa_dbi_util_pkg.get_custom_balance_binds

995: -- only need to make lag offset adjustment for Week
996: , p_opening_balance => case when l_xtd = 'RLW' then 'Y' else 'N' end
997: );
998:
999: poa_dbi_util_pkg.get_custom_balance_binds
1000: ( p_custom_output => l_custom_output
1001: , p_balance_fact => l_balance_fact
1002: , p_xtd => l_xtd
1003: );

Line 1005: poa_dbi_util_pkg.get_custom_rolling_binds

1001: , p_balance_fact => l_balance_fact
1002: , p_xtd => l_xtd
1003: );
1004:
1005: poa_dbi_util_pkg.get_custom_rolling_binds
1006: ( p_custom_output => l_custom_output
1007: , p_xtd => l_xtd
1008: );
1009:

Line 1012: poa_dbi_util_pkg.get_custom_day_binds(p_custom_output => l_custom_output,

1008: );
1009:
1010: IF(l_xtd = 'DAY')
1011: THEN
1012: poa_dbi_util_pkg.get_custom_day_binds(p_custom_output => l_custom_output,
1013: p_as_of_date => l_as_of_date,
1014: p_comparison_type => l_comparison_type);
1015: null;
1016: END IF;