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_UFR_PKG dependencies on POA_DBI_SUTIL_PKG

Line 52: poa_dbi_sutil_pkg.process_parameters(p_param

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

Line 134: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim

130: l_sel_clause varchar2(4000);
131:
132: BEGIN
133:
134: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
135: ,'PO'
136: ,'7.1');
137:
138:

Line 230: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

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

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

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

Line 249: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

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

Line 281: poa_dbi_sutil_pkg.process_parameters(p_param

277: BEGIN
278: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
279: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
280: l_comparison_type := 'Y';
281: poa_dbi_sutil_pkg.process_parameters(p_param
282: , l_view_by
283: , l_view_by_col
284: , l_view_by_value
285: , l_comparison_type

Line 363: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim

359: return VARCHAR2
360: IS
361: l_sel_clause varchar2(4000);
362: BEGIN
363: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
364: ,'PO'
365: ,'7.1');
366:
367:

Line 514: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

510: END get_amt_sel_clause;
511:
512: FUNCTION get_amt_filter_where(p_view_by in VARCHAR2) return VARCHAR2
513: IS
514: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
515: BEGIN
516: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
517: l_col_tbl.extend;
518: l_col_tbl(1) := 'POA_MEASURE2';

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

512: FUNCTION get_amt_filter_where(p_view_by in VARCHAR2) return VARCHAR2
513: IS
514: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
515: BEGIN
516: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
517: l_col_tbl.extend;
518: l_col_tbl(1) := 'POA_MEASURE2';
519: l_col_tbl.extend;
520: l_col_tbl(2) := 'POA_MEASURE3';

Line 529: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

525: l_col_tbl.extend;
526: l_col_tbl(4) := 'POA_MEASURE1';
527: end if;
528:
529: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
530:
531: END;
532:
533:

Line 560: poa_dbi_sutil_pkg.process_parameters(p_param

556: BEGIN
557: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
558: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
559: l_comparison_type := 'Y';
560: poa_dbi_sutil_pkg.process_parameters(p_param
561: , l_view_by
562: , l_view_by_col
563: , l_view_by_value
564: , l_comparison_type

Line 645: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim

641: ) return VARCHAR2
642: IS
643: l_sel_clause varchar2(4000);
644: BEGIN
645: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
646: ,'PO'
647: ,'7.1');
648:
649:

Line 742: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

738: END get_sum_sel_clause;
739:
740: FUNCTION get_sum_rpt_filter_where(p_view_by in VARCHAR2) return VARCHAR2
741: IS
742: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
743: BEGIN
744: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
745: l_col_tbl.extend;
746: l_col_tbl(1) := 'POA_MEASURE2';

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

740: FUNCTION get_sum_rpt_filter_where(p_view_by in VARCHAR2) return VARCHAR2
741: IS
742: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
743: BEGIN
744: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
745: l_col_tbl.extend;
746: l_col_tbl(1) := 'POA_MEASURE2';
747: l_col_tbl.extend;
748: l_col_tbl(2) := 'POA_MEASURE3';

Line 761: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

757: l_col_tbl.extend;
758: l_col_tbl(6) := 'POA_MEASURE1';
759: end if;
760:
761: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
762:
763: END;
764:
765: PROCEDURE age_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

Line 792: poa_dbi_sutil_pkg.process_parameters(p_param

788: BEGIN
789: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
790: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
791: l_comparison_type := 'Y';
792: poa_dbi_sutil_pkg.process_parameters(p_param
793: , l_view_by
794: , l_view_by_col
795: , l_view_by_value
796: , l_comparison_type

Line 875: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim

871: return VARCHAR2
872: IS
873: l_sel_clause varchar2(4000);
874: BEGIN
875: l_sel_clause := poa_dbi_sutil_pkg.get_viewby_select_clause(p_view_by_dim
876: ,'PO'
877: ,'7.1');
878:
879: if(p_view_by_dim = 'ITEM+POA_ITEMS') then

Line 1015: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

1011: END get_age_sel_clause;
1012:
1013: FUNCTION get_age_filter_where(p_view_by in VARCHAR2) return VARCHAR2
1014: IS
1015: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
1016: BEGIN
1017: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
1018: l_col_tbl.extend;
1019: l_col_tbl(1) := 'POA_MEASURE2';

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

1013: FUNCTION get_age_filter_where(p_view_by in VARCHAR2) return VARCHAR2
1014: IS
1015: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
1016: BEGIN
1017: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
1018: l_col_tbl.extend;
1019: l_col_tbl(1) := 'POA_MEASURE2';
1020: l_col_tbl.extend;
1021: l_col_tbl(2) := 'POA_MEASURE3';

Line 1028: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

1024: l_col_tbl.extend;
1025: l_col_tbl(3) := 'POA_MEASURE1';
1026: end if;
1027:
1028: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
1029:
1030: END;
1031:
1032:

Line 1051: poa_dbi_sutil_pkg.drill_process_parameters(p_param, l_cur_suffix,

1047: l_rownum_where varchar2(300);
1048: l_vo_max_fetch_size varchar2(100);
1049: BEGIN
1050: l_aging_where := ' ';
1051: poa_dbi_sutil_pkg.drill_process_parameters(p_param, l_cur_suffix,
1052: l_where_clause, l_in_join_tbl, 'PO', '7.1', 'VPP','REQS');
1053:
1054: IF(l_in_join_tbl is not null) then
1055: FOR i in 1 .. l_in_join_tbl.COUNT

Line 1073: poa_dbi_sutil_pkg.bind_reqfact_date(x_custom_output);

1069: END LOOP;
1070:
1071: IF(l_context = 1) THEN -- Past Expected Date
1072: l_context_where := ' and fact.expected_date <= to_date(&REQ_FACT_UPDATE_DATE,''DD/MM/YYYY HH24:MI:SS'') ';
1073: poa_dbi_sutil_pkg.bind_reqfact_date(x_custom_output);
1074: ELSIF(l_context=2) THEN -- Pending Processing
1075: l_context_where := ' and fact.po_approved_date is null';
1076: ELSIF(l_context = 3) THEN -- Processed Pending Fulfill
1077: l_context_where := ' and fact.po_approved_date is not null';

Line 1099: poa_dbi_sutil_pkg.bind_reqfact_date(x_custom_output);

1095: else
1096: l_aging_where := '';
1097: end if;
1098:
1099: poa_dbi_sutil_pkg.bind_reqfact_date(x_custom_output);
1100:
1101: /* Determine the l_rownum_where. If VO_MAX_FETCH_SIZE is null then dont filter any rows */
1102: select fnd_profile.value('VO_MAX_FETCH_SIZE')
1103: into l_vo_max_fetch_size