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.POA_DBI_UPR_PKG dependencies on POA_DBI_SUTIL_PKG

Line 53: poa_dbi_sutil_pkg.process_parameters(p_param

49:
50: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
51: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
52: l_comparison_type := 'Y';
53: poa_dbi_sutil_pkg.process_parameters(p_param
54: ,l_view_by
55: ,l_view_by_col
56: ,l_view_by_value
57: ,l_comparison_type

Line 138: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim

134: l_sel_clause varchar2(4000);
135:
136: BEGIN
137:
138: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
139: ,'PO'
140: ,'7.1');
141:
142: if(p_view_by_dim = 'ITEM+POA_ITEMS') then

Line 231: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

227:
228:
229: FUNCTION get_status_filter_where(p_view_by in VARCHAR2) return VARCHAR2
230: IS
231: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
232: BEGIN
233: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
234: l_col_tbl.extend;
235: l_col_tbl(1) := 'POA_MEASURE1';

Line 233: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();

229: FUNCTION get_status_filter_where(p_view_by in VARCHAR2) return VARCHAR2
230: IS
231: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
232: BEGIN
233: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
234: l_col_tbl.extend;
235: l_col_tbl(1) := 'POA_MEASURE1';
236: l_col_tbl.extend;
237: l_col_tbl(2) := 'POA_PERCENT1';

Line 250: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

246: l_col_tbl.extend;
247: l_col_tbl(6) := 'POA_MEASURE8';
248: end if;
249:
250: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
251:
252: END;
253:
254:

Line 285: poa_dbi_sutil_pkg.process_parameters(p_param

281:
282: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
283: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
284: l_comparison_type :='Y';
285: poa_dbi_sutil_pkg.process_parameters(p_param
286: ,l_view_by
287: ,l_view_by_col
288: ,l_view_by_value
289: ,l_comparison_type

Line 393: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim

389: IS
390: l_sel_clause varchar2(8000);
391:
392: BEGIN
393: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
394: ,'PO'
395: ,'7.1');
396:
397:

Line 559: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

555:
556:
557: FUNCTION get_amt_filter_where(p_view_by in VARCHAR2) return VARCHAR2
558: IS
559: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
560: BEGIN
561: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
562: l_col_tbl.extend;
563: l_col_tbl(1) := 'POA_MEASURE2';

Line 561: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();

557: FUNCTION get_amt_filter_where(p_view_by in VARCHAR2) return VARCHAR2
558: IS
559: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
560: BEGIN
561: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
562: l_col_tbl.extend;
563: l_col_tbl(1) := 'POA_MEASURE2';
564: l_col_tbl.extend;
565: l_col_tbl(2) := 'POA_MEASURE3';

Line 578: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

574: l_col_tbl.extend;
575: l_col_tbl(6) := 'POA_MEASURE1';
576: end if;
577:
578: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
579:
580: END;
581:
582: PROCEDURE age_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

Line 612: poa_dbi_sutil_pkg.process_parameters(p_param

608:
609: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
610: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
611: l_comparison_type := 'Y';
612: poa_dbi_sutil_pkg.process_parameters(p_param
613: ,l_view_by
614: ,l_view_by_col
615: ,l_view_by_value
616: ,l_comparison_type

Line 700: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim

696: l_sel_clause varchar2(4000);
697:
698: BEGIN
699:
700: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
701: ,'PO'
702: ,'7.1');
703:
704: if(p_view_by_dim = 'ITEM+POA_ITEMS') then

Line 830: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

826:
827:
828: FUNCTION get_age_filter_where(p_view_by in VARCHAR2) return VARCHAR2
829: IS
830: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
831: BEGIN
832: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
833: l_col_tbl.extend;
834: l_col_tbl(1) := 'POA_MEASURE7';

Line 832: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();

828: FUNCTION get_age_filter_where(p_view_by in VARCHAR2) return VARCHAR2
829: IS
830: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
831: BEGIN
832: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
833: l_col_tbl.extend;
834: l_col_tbl(1) := 'POA_MEASURE7';
835: l_col_tbl.extend;
836: l_col_tbl(2) := 'POA_MEASURE2';

Line 843: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

839: l_col_tbl.extend;
840: l_col_tbl(3) := 'POA_MEASURE1';
841: end if;
842:
843: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
844:
845: END;
846:
847: PROCEDURE sum_rpt_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

Line 877: poa_dbi_sutil_pkg.process_parameters(p_param

873:
874: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
875: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
876: l_comparison_type := 'Y';
877: poa_dbi_sutil_pkg.process_parameters(p_param
878: ,l_view_by
879: ,l_view_by_col
880: ,l_view_by_value
881: ,l_comparison_type

Line 993: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim

989: l_sel_clause varchar2(10000);
990:
991: BEGIN
992:
993: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
994: ,'PO'
995: ,'7.1');
996:
997:

Line 1115: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

1111:
1112:
1113: FUNCTION get_sum_rpt_filter_where(p_view_by in VARCHAR2) return VARCHAR2
1114: IS
1115: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
1116: BEGIN
1117: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
1118: l_col_tbl.extend;
1119: l_col_tbl(1) := 'POA_MEASURE2';

Line 1117: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();

1113: FUNCTION get_sum_rpt_filter_where(p_view_by in VARCHAR2) return VARCHAR2
1114: IS
1115: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
1116: BEGIN
1117: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
1118: l_col_tbl.extend;
1119: l_col_tbl(1) := 'POA_MEASURE2';
1120: l_col_tbl.extend;
1121: l_col_tbl(2) := 'POA_MEASURE3';

Line 1140: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

1136: l_col_tbl.extend;
1137: l_col_tbl(9) := 'POA_MEASURE1';
1138: end if;
1139:
1140: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
1141:
1142: END;
1143:
1144:

Line 1161: poa_dbi_sutil_pkg.drill_process_parameters(p_param, l_cur_suffix, l_where_clause, l_in_join_tbl, 'PO', '7.1',

1157: l_bucket_where VARCHAR2(440);
1158: l_rownum_where varchar2(300);
1159: l_vo_max_fetch_size varchar2(100);
1160: BEGIN
1161: poa_dbi_sutil_pkg.drill_process_parameters(p_param, l_cur_suffix, l_where_clause, l_in_join_tbl, 'PO', '7.1',
1162: 'VPP','REQS');
1163:
1164: IF(l_in_join_tbl is not null) then
1165: FOR i in 1 .. l_in_join_tbl.COUNT

Line 1223: poa_dbi_sutil_pkg.bind_reqfact_date(x_custom_output);

1219: else
1220: l_bucket_where := '';
1221: end if;
1222:
1223: poa_dbi_sutil_pkg.bind_reqfact_date(x_custom_output);
1224:
1225: /* Determine the l_rownum_where. If VO_MAX_FETCH_SIZE is null then dont filter any rows */
1226: select fnd_profile.value('VO_MAX_FETCH_SIZE')
1227: into l_vo_max_fetch_size