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

Line 44: poa_dbi_sutil_pkg.process_parameters(p_param,l_view_by,l_view_by_col,l_view_by_value, l_comparison_type, l_xtd, l_as_of_date, l_prev_as_of_date, l_cur_suffix, l_nested_pattern, l_where_clause, l_mv, l_join_tbl, l_in_join_tbl,

40: BEGIN
41: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
42: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
43:
44: poa_dbi_sutil_pkg.process_parameters(p_param,l_view_by,l_view_by_col,l_view_by_value, l_comparison_type, l_xtd, l_as_of_date, l_prev_as_of_date, l_cur_suffix, l_nested_pattern, l_where_clause, l_mv, l_join_tbl, l_in_join_tbl,
45: x_custom_output,
46: 'N','PO', '5.0', 'VPP','POD');
47:
48: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);

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

44: poa_dbi_sutil_pkg.process_parameters(p_param,l_view_by,l_view_by_col,l_view_by_value, l_comparison_type, l_xtd, l_as_of_date, l_prev_as_of_date, l_cur_suffix, l_nested_pattern, l_where_clause, l_mv, l_join_tbl, l_in_join_tbl,
45: x_custom_output,
46: 'N','PO', '5.0', 'VPP','POD');
47:
48: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);
49: IF(l_context_code = 'OU' or l_context_code = 'SUPPLIER') THEN
50: l_to_date_type := 'RLX';
51: ELSE
52: l_to_date_type := 'XTD';

Line 104: poa_dbi_sutil_pkg.process_parameters(p_param,l_view_by,l_view_by_col,l_view_by_value,l_comparison_type, l_xtd, l_as_of_date, l_prev_as_of_date, l_cur_suffix, l_nested_pattern, l_where_clause, l_mv, l_join_tbl, l_in_join_tbl,

100: BEGIN
101: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
102: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
103:
104: poa_dbi_sutil_pkg.process_parameters(p_param,l_view_by,l_view_by_col,l_view_by_value,l_comparison_type, l_xtd, l_as_of_date, l_prev_as_of_date, l_cur_suffix, l_nested_pattern, l_where_clause, l_mv, l_join_tbl, l_in_join_tbl,
105: x_custom_output,
106: 'Y','PO', '5.0', 'VPP','POD');
107: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);
108: IF(l_context_code = 'OU' or l_context_code = 'SUPPLIER') THEN

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

103:
104: poa_dbi_sutil_pkg.process_parameters(p_param,l_view_by,l_view_by_col,l_view_by_value,l_comparison_type, l_xtd, l_as_of_date, l_prev_as_of_date, l_cur_suffix, l_nested_pattern, l_where_clause, l_mv, l_join_tbl, l_in_join_tbl,
105: x_custom_output,
106: 'Y','PO', '5.0', 'VPP','POD');
107: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);
108: IF(l_context_code = 'OU' or l_context_code = 'SUPPLIER') THEN
109: l_to_date_type := 'RLX';
110: ELSE
111: l_to_date_type := 'XTD';

Line 164: poa_dbi_sutil_pkg.process_parameters(p_param,l_view_by,l_view_by_col,l_view_by_value,l_comparison_type, l_xtd, l_as_of_date, l_prev_as_of_date, l_cur_suffix, l_nested_pattern, l_where_clause, l_mv, l_join_tbl, l_in_join_tbl,

160: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
161: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
162: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
163:
164: poa_dbi_sutil_pkg.process_parameters(p_param,l_view_by,l_view_by_col,l_view_by_value,l_comparison_type, l_xtd, l_as_of_date, l_prev_as_of_date, l_cur_suffix, l_nested_pattern, l_where_clause, l_mv, l_join_tbl, l_in_join_tbl,
165: x_custom_output,
166: 'N','PO', '5.0', 'VPP','POD');
167:
168: l_prev_as_of_date2 := poa_dbi_calendar_pkg.previous_period_asof_date(l_prev_as_of_date, l_xtd, l_comparison_type);

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

165: x_custom_output,
166: 'N','PO', '5.0', 'VPP','POD');
167:
168: l_prev_as_of_date2 := poa_dbi_calendar_pkg.previous_period_asof_date(l_prev_as_of_date, l_xtd, l_comparison_type);
169: l_context_code := poa_dbi_sutil_pkg.get_sec_context(p_param);
170:
171: IF(l_context_code = 'OU' or l_context_code = 'SUPPLIER') THEN
172: l_to_date_type := 'RLX';
173: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'purchase_amt', 'Y',

Line 193: poa_dbi_sutil_pkg.get_table('SUPPLIER+POA_SUPPLIERS', 'PO', '5.0');

189: /* l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
190:
191: IF(l_context_code = 'OU' or l_context_code = 'SUPPLIER') THEN
192: l_join_rec.table_name :=
193: poa_dbi_sutil_pkg.get_table('SUPPLIER+POA_SUPPLIERS', 'PO', '5.0');
194: l_join_rec.table_alias := 'v';
195: l_join_rec.fact_column :=
196: poa_dbi_sutil_pkg.get_col_name('SUPPLIER+POA_SUPPLIERS', 'PO', '5.0', 'POD');
197: l_join_rec.column_name := 'id';

Line 196: poa_dbi_sutil_pkg.get_col_name('SUPPLIER+POA_SUPPLIERS', 'PO', '5.0', 'POD');

192: l_join_rec.table_name :=
193: poa_dbi_sutil_pkg.get_table('SUPPLIER+POA_SUPPLIERS', 'PO', '5.0');
194: l_join_rec.table_alias := 'v';
195: l_join_rec.fact_column :=
196: poa_dbi_sutil_pkg.get_col_name('SUPPLIER+POA_SUPPLIERS', 'PO', '5.0', 'POD');
197: l_join_rec.column_name := 'id';
198: ELSE
199: l_join_rec.table_name :=
200: poa_dbi_sutil_pkg.get_table('ORGANIZATION+FII_OPERATING_UNITS', 'PO', '5.0');

Line 200: poa_dbi_sutil_pkg.get_table('ORGANIZATION+FII_OPERATING_UNITS', 'PO', '5.0');

196: poa_dbi_sutil_pkg.get_col_name('SUPPLIER+POA_SUPPLIERS', 'PO', '5.0', 'POD');
197: l_join_rec.column_name := 'id';
198: ELSE
199: l_join_rec.table_name :=
200: poa_dbi_sutil_pkg.get_table('ORGANIZATION+FII_OPERATING_UNITS', 'PO', '5.0');
201: l_join_rec.table_alias := 'v';
202: l_join_rec.fact_column :=
203: poa_dbi_sutil_pkg.get_col_name('ORGANIZATION+FII_OPERATING_UNITS', 'PO', '5.0', 'POD');
204: l_join_rec.column_name := 'id';

Line 203: poa_dbi_sutil_pkg.get_col_name('ORGANIZATION+FII_OPERATING_UNITS', 'PO', '5.0', 'POD');

199: l_join_rec.table_name :=
200: poa_dbi_sutil_pkg.get_table('ORGANIZATION+FII_OPERATING_UNITS', 'PO', '5.0');
201: l_join_rec.table_alias := 'v';
202: l_join_rec.fact_column :=
203: poa_dbi_sutil_pkg.get_col_name('ORGANIZATION+FII_OPERATING_UNITS', 'PO', '5.0', 'POD');
204: l_join_rec.column_name := 'id';
205: END IF;
206:
207: l_join_tbl.extend;

Line 258: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

254: END;
255:
256: FUNCTION get_status_filter_where return VARCHAR2
257: IS
258: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
259: BEGIN
260: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
261: l_col_tbl.extend;
262: l_col_tbl(1) := 'POA_MEASURE1';

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

256: FUNCTION get_status_filter_where return VARCHAR2
257: IS
258: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
259: BEGIN
260: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
261: l_col_tbl.extend;
262: l_col_tbl(1) := 'POA_MEASURE1';
263: l_col_tbl.extend;
264: l_col_tbl(2) := 'POA_PERCENT2';

Line 273: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

269: l_col_tbl.extend;
270: l_col_tbl(5) := 'POA_MEASURE4';
271: l_col_tbl.extend;
272: l_col_tbl(6) := 'POA_MEASURE5';
273: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
274:
275: END;
276:
277: FUNCTION get_kpi_filter_where return VARCHAR2

Line 279: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

275: END;
276:
277: FUNCTION get_kpi_filter_where return VARCHAR2
278: IS
279: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
280: BEGIN
281: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
282: l_col_tbl.extend;
283: l_col_tbl(1) := 'POA_PERCENT1';

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

277: FUNCTION get_kpi_filter_where return VARCHAR2
278: IS
279: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
280: BEGIN
281: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
282: l_col_tbl.extend;
283: l_col_tbl(1) := 'POA_PERCENT1';
284: l_col_tbl.extend;
285: l_col_tbl(2) := 'POA_PERCENT2';

Line 290: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

286: l_col_tbl.extend;
287: l_col_tbl(3) := 'POA_MEASURE4';
288: l_col_tbl.extend;
289: l_col_tbl(4) := 'POA_MEASURE5';
290: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
291:
292: END;
293:
294: