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

Line 75: poa_dbi_sutil_pkg.process_parameters (

71:
72: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
73: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
74:
75: poa_dbi_sutil_pkg.process_parameters (
76: p_param => p_param,
77: p_view_by => l_view_by,
78: p_view_by_col_name => l_view_by_col ,
79: p_view_by_value => l_view_by_value,

Line 97: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);

93: p_version => '8.0',
94: p_role => 'VPP',
95: p_mv_set => 'POD');
96:
97: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);
98:
99: IF(l_context_code = 'OU' or l_context_code = 'SUPPLIER') THEN
100: l_to_date_type := 'RLX';
101: ELSE

Line 142: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

138: ----------------------------------------------------------------------------------
139:
140: FUNCTION get_status_filter_where RETURN VARCHAR2
141: IS
142: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
143: BEGIN
144: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
145: l_col_tbl.extend;
146: l_col_tbl(1) := 'POA_MEASURE1';

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

140: FUNCTION get_status_filter_where RETURN VARCHAR2
141: IS
142: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
143: BEGIN
144: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
145: l_col_tbl.extend;
146: l_col_tbl(1) := 'POA_MEASURE1';
147: l_col_tbl.extend;
148: l_col_tbl(2) := 'POA_PERCENT1';

Line 156: RETURN poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

152: l_col_tbl(4) := 'POA_PERCENT2';
153: l_col_tbl.extend;
154: l_col_tbl(5) := 'POA_MEASURE12';
155:
156: RETURN poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
157:
158: END get_status_filter_where ;
159:
160:

Line 219: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

215: ----------------------------------------------------------------------------------
216:
217: FUNCTION get_iapd_filter_where RETURN VARCHAR2
218: IS
219: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
220: BEGIN
221: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
222: l_col_tbl.extend;
223: l_col_tbl(1) := 'POA_MEASURE1';

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

217: FUNCTION get_iapd_filter_where RETURN VARCHAR2
218: IS
219: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
220: BEGIN
221: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
222: l_col_tbl.extend;
223: l_col_tbl(1) := 'POA_MEASURE1';
224: l_col_tbl.extend;
225: l_col_tbl(2) := 'POA_PERCENT1';

Line 231: RETURN poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

227: l_col_tbl(3) := 'POA_MEASURE2';
228: l_col_tbl.extend;
229: l_col_tbl(4) := 'POA_PERCENT2';
230:
231: RETURN poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
232:
233: END get_iapd_filter_where ;
234:
235: ----------------------------------------------------------------------------------

Line 266: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);

262: BEGIN
263:
264: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
265: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
266: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);
267:
268: FOR i in 1..p_param.last
269: LOOP
270: IF p_param(i).parameter_name = 'LOOKUP+UOMCODE' THEN

Line 276: poa_dbi_sutil_pkg.drill_process_parameters(

272: END IF ;
273: END LOOP ;
274:
275:
276: poa_dbi_sutil_pkg.drill_process_parameters(
277: p_param => p_param,
278: p_cur_suffix => l_cur_suffix,
279: p_where_clause => l_where_clause,
280: p_in_join_tbl => l_in_join_tbl,

Line 410: poa_dbi_sutil_pkg.process_parameters(p_param,

406: END IF ;
407: END LOOP ;
408:
409: ---Get the Purchased Amt. Measure
410: poa_dbi_sutil_pkg.process_parameters(p_param,
411: l_view_by,
412: l_view_by_col_name,
413: l_view_by_value,
414: l_comparison_type,

Line 431: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);

427: p_version => '8.0',
428: p_role => 'VPP',
429: p_mv_set => 'POD');
430:
431: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);
432: IF(l_context_code = 'OU' or l_context_code = 'SUPPLIER') THEN
433: l_to_date_type := 'RLX';
434: ELSE
435: l_to_date_type := 'XTD';

Line 459: l_mv_tbl(1).mv_hint := poa_dbi_sutil_pkg.get_fact_hint(l_mv);

455: l_mv_tbl(1).mv_col := l_col_tbl;
456: l_mv_tbl(1).mv_where := l_where_clause;
457: l_mv_tbl(1).in_join_tbls := l_in_join_tbl;
458: l_mv_tbl(1).use_grp_id := 'N';
459: l_mv_tbl(1).mv_hint := poa_dbi_sutil_pkg.get_fact_hint(l_mv);
460: l_mv_tbl(1).mv_xtd := l_xtd;
461:
462: l_where_clause := l_where_clause ||
463: ' and nvl(fact.base_uom ,''-1'') = ''' || l_uom || '''' ;

Line 549: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);

545:
546:
547: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
548: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
549: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);
550:
551:
552: poa_dbi_sutil_pkg.process_parameters(p_param,
553: l_view_by,

Line 552: poa_dbi_sutil_pkg.process_parameters(p_param,

548: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
549: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);
550:
551:
552: poa_dbi_sutil_pkg.process_parameters(p_param,
553: l_view_by,
554: l_view_by_col,
555: l_view_by_value,
556: l_comparison_type,

Line 614: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

610: ----------------------------------------------------------------------------------
611:
612: FUNCTION get_dtl_sts_filter_where RETURN VARCHAR2
613: IS
614: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
615: BEGIN
616: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
617: l_col_tbl.extend;
618: l_col_tbl(1) := 'POA_MEASURE1';

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

612: FUNCTION get_dtl_sts_filter_where RETURN VARCHAR2
613: IS
614: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
615: BEGIN
616: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
617: l_col_tbl.extend;
618: l_col_tbl(1) := 'POA_MEASURE1';
619: l_col_tbl.extend;
620: l_col_tbl(2) := 'POA_PERCENT1';

Line 628: RETURN poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

624: l_col_tbl(4) := 'POA_PERCENT2';
625: l_col_tbl.extend;
626: l_col_tbl(5) := 'POA_MEASURE12';
627:
628: RETURN poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
629:
630: END get_dtl_sts_filter_where ;
631:
632: ----------------------------------------------------------------------------------