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_TMPL_UTIL dependencies on POA_DBI_UTIL_PKG

Line 563: ( x_dim_map out nocopy poa_DBI_UTIL_PKG.poa_dbi_dim_map

559: return '';
560: end get_fact_mv_name;
561:
562: procedure init_dim_map
563: ( x_dim_map out nocopy poa_DBI_UTIL_PKG.poa_dbi_dim_map
564: , p_report_type in varchar2 -- 'ACTIVITY','CLOSED','BACKLOG','BACKLOG_AGE'
565: -- 'BACKLOG_DETAIL', 'CLOSED_DETAIL', 'RESOLVED'
566: -- , 'RESOLVED_DETAIL'
567: , p_product_cat in varchar2

Line 569: l_dim_rec poa_DBI_UTIL_PKG.poa_dbi_dim_rec;

565: -- 'BACKLOG_DETAIL', 'CLOSED_DETAIL', 'RESOLVED'
566: -- , 'RESOLVED_DETAIL'
567: , p_product_cat in varchar2
568: ) is
569: l_dim_rec poa_DBI_UTIL_PKG.poa_dbi_dim_rec;
570: begin
571: -- Request Type
572: l_dim_rec.col_name := get_fact_col_name(g_REQUEST_TYPE);
573: l_dim_rec.view_by_table := get_dim_table_name(g_REQUEST_TYPE);

Line 659: , p_dim_map in poa_DBI_UTIL_PKG.poa_dbi_dim_map

655: end init_dim_map;
656:
657: function get_join_info
658: ( p_view_by in varchar2
659: , p_dim_map in poa_DBI_UTIL_PKG.poa_dbi_dim_map
660: )
661: return poa_DBI_UTIL_PKG.poa_dbi_join_tbl
662: is
663: l_join_rec poa_DBI_UTIL_PKG.poa_dbi_join_rec;

Line 661: return poa_DBI_UTIL_PKG.poa_dbi_join_tbl

657: function get_join_info
658: ( p_view_by in varchar2
659: , p_dim_map in poa_DBI_UTIL_PKG.poa_dbi_dim_map
660: )
661: return poa_DBI_UTIL_PKG.poa_dbi_join_tbl
662: is
663: l_join_rec poa_DBI_UTIL_PKG.poa_dbi_join_rec;
664: l_join_tbl poa_DBI_UTIL_PKG.poa_dbi_join_tbl;
665: begin

Line 663: l_join_rec poa_DBI_UTIL_PKG.poa_dbi_join_rec;

659: , p_dim_map in poa_DBI_UTIL_PKG.poa_dbi_dim_map
660: )
661: return poa_DBI_UTIL_PKG.poa_dbi_join_tbl
662: is
663: l_join_rec poa_DBI_UTIL_PKG.poa_dbi_join_rec;
664: l_join_tbl poa_DBI_UTIL_PKG.poa_dbi_join_tbl;
665: begin
666: -- reinitialize the join table
667: l_join_tbl := poa_DBI_UTIL_PKG.poa_dbi_join_tbl();

Line 664: l_join_tbl poa_DBI_UTIL_PKG.poa_dbi_join_tbl;

660: )
661: return poa_DBI_UTIL_PKG.poa_dbi_join_tbl
662: is
663: l_join_rec poa_DBI_UTIL_PKG.poa_dbi_join_rec;
664: l_join_tbl poa_DBI_UTIL_PKG.poa_dbi_join_tbl;
665: begin
666: -- reinitialize the join table
667: l_join_tbl := poa_DBI_UTIL_PKG.poa_dbi_join_tbl();
668:

Line 667: l_join_tbl := poa_DBI_UTIL_PKG.poa_dbi_join_tbl();

663: l_join_rec poa_DBI_UTIL_PKG.poa_dbi_join_rec;
664: l_join_tbl poa_DBI_UTIL_PKG.poa_dbi_join_tbl;
665: begin
666: -- reinitialize the join table
667: l_join_tbl := poa_DBI_UTIL_PKG.poa_dbi_join_tbl();
668:
669: -- If the view by column is not in the bitmap, then
670: -- there is nothing to join to. Can this ever be true?
671: if (not p_dim_map.exists(p_view_by)) then

Line 743: l_dim_map poa_DBI_UTIL_PKG.poa_dbi_dim_map;

739: , x_join_where out nocopy varchar2
740: )
741: is
742:
743: l_dim_map poa_DBI_UTIL_PKG.poa_dbi_dim_map;
744: l_alias varchar2(10);
745: l_dim varchar2(50);
746:
747: begin

Line 806: , x_join_tbl out nocopy poa_DBI_UTIL_PKG.poa_dbi_join_tbl

802: , x_comparison_type out nocopy varchar2
803: , x_xtd out nocopy varchar2
804: , x_where_clause out nocopy varchar2
805: , x_mv out nocopy varchar2
806: , x_join_tbl out nocopy poa_DBI_UTIL_PKG.poa_dbi_join_tbl
807: , x_as_of_date out nocopy date
808: ) is
809:
810: l_dim_map poa_DBI_UTIL_PKG.poa_dbi_dim_map;

Line 810: l_dim_map poa_DBI_UTIL_PKG.poa_dbi_dim_map;

806: , x_join_tbl out nocopy poa_DBI_UTIL_PKG.poa_dbi_join_tbl
807: , x_as_of_date out nocopy date
808: ) is
809:
810: l_dim_map poa_DBI_UTIL_PKG.poa_dbi_dim_map;
811: l_as_of_date date;
812: l_prev_as_of_date date;
813: l_nested_pattern number;
814: l_cur_suffix varchar2(1);

Line 827: poa_DBI_UTIL_PKG.get_parameter_values

823: l_product_cat := get_product_category(p_param);
824:
825: init_dim_map(l_dim_map, p_report_type, l_product_cat);
826:
827: poa_DBI_UTIL_PKG.get_parameter_values
828: ( p_param => p_param
829: , p_dim_map => l_dim_map
830: , p_view_by => l_view_by
831: , p_comparison_type => x_comparison_type

Line 853: l_where_clause := poa_DBI_UTIL_PKG.get_where_clauses(l_dim_map, p_trend);

849: end if;
850:
851: x_view_by := l_view_by;
852:
853: l_where_clause := poa_DBI_UTIL_PKG.get_where_clauses(l_dim_map, p_trend);
854:
855: if l_mv_name like '%_h_sum_mv%' or
856: l_mv_name like '%vbh_top_node_flag%' then
857: if l_product_cat is null then

Line 870: -- no longer need to do this as poa_DBI_UTIL_PKG.get_parameter_values

866: x_where_clause := l_where_clause;
867:
868: x_join_tbl := get_join_info(l_view_by, l_dim_map);
869:
870: -- no longer need to do this as poa_DBI_UTIL_PKG.get_parameter_values
871: -- does it correctly.
872: --
873: -- x_xtd := get_period_type(p_param);
874:

Line 1002: , p_col_tbl in out nocopy poa_DBI_UTIL_PKG.poa_dbi_col_tbl

998: end get_bucket_outer_query;
999:
1000: procedure add_bucket_inner_query
1001: ( p_short_name in varchar2
1002: , p_col_tbl in out nocopy poa_DBI_UTIL_PKG.poa_dbi_col_tbl
1003: , p_col_name in varchar2
1004: , p_alias_name in varchar2
1005: , p_grand_total in varchar2
1006: , p_prior_code in varchar2

Line 1023: poa_DBI_UTIL_PKG.add_column

1019: , x_error_tbl => l_error_tbl
1020: );
1021: if l_return_status = 'S' then
1022: if l_bucket_rec.range1_name is not null then
1023: poa_DBI_UTIL_PKG.add_column
1024: ( p_col_tbl => p_col_tbl
1025: , p_col_name => p_col_name || '_b1'
1026: , p_alias_name => p_alias_name || '_b1'
1027: , p_to_date_type => p_to_date_type

Line 1032: poa_DBI_UTIL_PKG.add_column

1028: , p_prior_code => p_prior_code
1029: );
1030: end if;
1031: if l_bucket_rec.range2_name is not null then
1032: poa_DBI_UTIL_PKG.add_column
1033: ( p_col_tbl => p_col_tbl
1034: , p_col_name => p_col_name || '_b2'
1035: , p_alias_name => p_alias_name || '_b2'
1036: , p_to_date_type => p_to_date_type

Line 1041: poa_DBI_UTIL_PKG.add_column

1037: , p_prior_code => p_prior_code
1038: );
1039: end if;
1040: if l_bucket_rec.range3_name is not null then
1041: poa_DBI_UTIL_PKG.add_column
1042: ( p_col_tbl => p_col_tbl
1043: , p_col_name => p_col_name || '_b3'
1044: , p_alias_name => p_alias_name || '_b3'
1045: , p_to_date_type => p_to_date_type

Line 1050: poa_DBI_UTIL_PKG.add_column

1046: , p_prior_code => p_prior_code
1047: );
1048: end if;
1049: if l_bucket_rec.range4_name is not null then
1050: poa_DBI_UTIL_PKG.add_column
1051: ( p_col_tbl => p_col_tbl
1052: , p_col_name => p_col_name || '_b4'
1053: , p_alias_name => p_alias_name || '_b4'
1054: , p_to_date_type => p_to_date_type

Line 1059: poa_DBI_UTIL_PKG.add_column

1055: , p_prior_code => p_prior_code
1056: );
1057: end if;
1058: if l_bucket_rec.range5_name is not null then
1059: poa_DBI_UTIL_PKG.add_column
1060: ( p_col_tbl => p_col_tbl
1061: , p_col_name => p_col_name || '_b5'
1062: , p_alias_name => p_alias_name || '_b5'
1063: , p_to_date_type => p_to_date_type

Line 1068: poa_DBI_UTIL_PKG.add_column

1064: , p_prior_code => p_prior_code
1065: );
1066: end if;
1067: if l_bucket_rec.range6_name is not null then
1068: poa_DBI_UTIL_PKG.add_column
1069: ( p_col_tbl => p_col_tbl
1070: , p_col_name => p_col_name || '_b6'
1071: , p_alias_name => p_alias_name || '_b6'
1072: , p_to_date_type => p_to_date_type

Line 1077: poa_DBI_UTIL_PKG.add_column

1073: , p_prior_code => p_prior_code
1074: );
1075: end if;
1076: if l_bucket_rec.range7_name is not null then
1077: poa_DBI_UTIL_PKG.add_column
1078: ( p_col_tbl => p_col_tbl
1079: , p_col_name => p_col_name || '_b7'
1080: , p_alias_name => p_alias_name || '_b7'
1081: , p_to_date_type => p_to_date_type

Line 1086: poa_DBI_UTIL_PKG.add_column

1082: , p_prior_code => p_prior_code
1083: );
1084: end if;
1085: if l_bucket_rec.range8_name is not null then
1086: poa_DBI_UTIL_PKG.add_column
1087: ( p_col_tbl => p_col_tbl
1088: , p_col_name => p_col_name || '_b8'
1089: , p_alias_name => p_alias_name || '_b8'
1090: , p_to_date_type => p_to_date_type

Line 1095: poa_DBI_UTIL_PKG.add_column

1091: , p_prior_code => p_prior_code
1092: );
1093: end if;
1094: if l_bucket_rec.range9_name is not null then
1095: poa_DBI_UTIL_PKG.add_column
1096: ( p_col_tbl => p_col_tbl
1097: , p_col_name => p_col_name || '_b9'
1098: , p_alias_name => p_alias_name || '_b9'
1099: , p_to_date_type => p_to_date_type

Line 1104: poa_DBI_UTIL_PKG.add_column

1100: , p_prior_code => p_prior_code
1101: );
1102: end if;
1103: if l_bucket_rec.range10_name is not null then
1104: poa_DBI_UTIL_PKG.add_column
1105: ( p_col_tbl => p_col_tbl
1106: , p_col_name => p_col_name || '_b10'
1107: , p_alias_name => p_alias_name || '_b10'
1108: , p_to_date_type => p_to_date_type

Line 1156: -- this is a wrapper to poa_dbi_util_pkg.change_clause

1152: return 'null ' || p_column_alias;
1153:
1154: end get_category_drill_down;
1155:
1156: -- this is a wrapper to poa_dbi_util_pkg.change_clause
1157: function change_column
1158: ( p_current_column in varchar2
1159: , p_prior_column in varchar2
1160: , p_column_alias in varchar2

Line 1166: return poa_DBI_UTIL_PKG.change_clause(p_current_column,p_prior_column) ||

1162: ) return varchar2
1163: is
1164: begin
1165: if p_percent = 'Y' then
1166: return poa_DBI_UTIL_PKG.change_clause(p_current_column,p_prior_column) ||
1167: ' ' || p_column_alias;
1168: end if;
1169: -- return poa_DBI_UTIL_PKG.change_clause('nvl('||p_current_column||',0)',p_prior_column,'X') ||
1170: return poa_DBI_UTIL_PKG.change_clause(p_current_column,p_prior_column,'X') ||

Line 1169: -- return poa_DBI_UTIL_PKG.change_clause('nvl('||p_current_column||',0)',p_prior_column,'X') ||

1165: if p_percent = 'Y' then
1166: return poa_DBI_UTIL_PKG.change_clause(p_current_column,p_prior_column) ||
1167: ' ' || p_column_alias;
1168: end if;
1169: -- return poa_DBI_UTIL_PKG.change_clause('nvl('||p_current_column||',0)',p_prior_column,'X') ||
1170: return poa_DBI_UTIL_PKG.change_clause(p_current_column,p_prior_column,'X') ||
1171: ' ' || p_column_alias;
1172: end change_column;
1173:

Line 1170: return poa_DBI_UTIL_PKG.change_clause(p_current_column,p_prior_column,'X') ||

1166: return poa_DBI_UTIL_PKG.change_clause(p_current_column,p_prior_column) ||
1167: ' ' || p_column_alias;
1168: end if;
1169: -- return poa_DBI_UTIL_PKG.change_clause('nvl('||p_current_column||',0)',p_prior_column,'X') ||
1170: return poa_DBI_UTIL_PKG.change_clause(p_current_column,p_prior_column,'X') ||
1171: ' ' || p_column_alias;
1172: end change_column;
1173:
1174: -- this is a wrapper to poa_dbi_util_pkg.rate_clause

Line 1174: -- this is a wrapper to poa_dbi_util_pkg.rate_clause

1170: return poa_DBI_UTIL_PKG.change_clause(p_current_column,p_prior_column,'X') ||
1171: ' ' || p_column_alias;
1172: end change_column;
1173:
1174: -- this is a wrapper to poa_dbi_util_pkg.rate_clause
1175: function rate_column
1176: ( p_numerator in varchar2
1177: , p_denominator in varchar2
1178: , p_column_alias in varchar2

Line 1183: return poa_DBI_UTIL_PKG.rate_clause( p_numerator

1179: , p_percent in varchar2 default 'Y'
1180: ) return varchar2
1181: is
1182: begin
1183: return poa_DBI_UTIL_PKG.rate_clause( p_numerator
1184: , p_denominator
1185: , case p_percent
1186: when 'Y' then 'P'
1187: else 'NP'

Line 1604: , x_join_tbl out nocopy poa_DBI_UTIL_PKG.poa_dbi_join_tbl

1600: , x_xtd out nocopy varchar2
1601: , x_mv out nocopy varchar2
1602: , x_join_from out nocopy varchar2
1603: , x_join_where out nocopy varchar2
1604: , x_join_tbl out nocopy poa_DBI_UTIL_PKG.poa_dbi_join_tbl
1605: , x_as_of_date out nocopy date
1606: )
1607: is
1608: