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

Line 38: 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,

34: BEGIN
35: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
36: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
37:
38: 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,
39: x_custom_output,
40: 'N','PO', '5.0', 'VPP','POD');
41:
42: poa_dbi_util_pkg.add_column(l_col_tbl, 'p_contract_amt_' || l_cur_suffix, 'p_contract_amt');

Line 91: 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,

87: BEGIN
88: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
89: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
90:
91: 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,
92: x_custom_output,
93: 'Y','PO', '5.0', 'VPP','POD');
94:
95: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'purchase_amt', 'N');

Line 139: 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,

135: l_view_by_value VARCHAR2(100);
136: begin l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
137: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
138:
139: 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,
140: x_custom_output,
141: 'N','PO', '5.0', 'VPP','POD');
142:
143: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'purchase_amt');

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

146:
147: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
148:
149: l_join_rec.table_name :=
150: poa_dbi_sutil_pkg.get_table('ORGANIZATION+FII_OPERATING_UNITS', 'PO', '5.0');
151: l_join_rec.table_alias := 'v';
152: l_join_rec.fact_column :=
153: poa_dbi_sutil_pkg.get_col_name('ORGANIZATION+FII_OPERATING_UNITS', 'PO', '5.0', 'POD');
154: l_join_rec.column_name := 'id';

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

149: l_join_rec.table_name :=
150: poa_dbi_sutil_pkg.get_table('ORGANIZATION+FII_OPERATING_UNITS', 'PO', '5.0');
151: l_join_rec.table_alias := 'v';
152: l_join_rec.fact_column :=
153: poa_dbi_sutil_pkg.get_col_name('ORGANIZATION+FII_OPERATING_UNITS', 'PO', '5.0', 'POD');
154: l_join_rec.column_name := 'id';
155:
156: l_join_tbl.extend;
157: l_join_tbl(l_join_tbl.count) :=l_join_rec;

Line 196: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

192:
193:
194: FUNCTION get_status_filter_where return VARCHAR2
195: IS
196: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
197: BEGIN
198: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
199: l_col_tbl.extend;
200: l_col_tbl(1) := 'POA_MEASURE1';

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

194: FUNCTION get_status_filter_where return VARCHAR2
195: IS
196: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
197: BEGIN
198: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
199: l_col_tbl.extend;
200: l_col_tbl(1) := 'POA_MEASURE1';
201: l_col_tbl.extend;
202: l_col_tbl(2) := 'POA_PERCENT2';

Line 208: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

204: l_col_tbl(3) := 'POA_PERCENT1';
205: l_col_tbl.extend;
206: l_col_tbl(4) := 'POA_MEASURE3';
207:
208: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
209:
210: END;
211:
212: FUNCTION get_kpi_filter_where return VARCHAR2

Line 214: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

210: END;
211:
212: FUNCTION get_kpi_filter_where return VARCHAR2
213: IS
214: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
215: BEGIN
216: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
217: l_col_tbl.extend;
218: l_col_tbl(1) := 'POA_PERCENT3';

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

212: FUNCTION get_kpi_filter_where return VARCHAR2
213: IS
214: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
215: BEGIN
216: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
217: l_col_tbl.extend;
218: l_col_tbl(1) := 'POA_PERCENT3';
219: l_col_tbl.extend;
220: l_col_tbl(2) := 'POA_PERCENT2';

Line 226: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

222: l_col_tbl(3) := 'POA_PERCENT1';
223: l_col_tbl.extend;
224: l_col_tbl(4) := 'POA_PERCENT4';
225:
226: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
227:
228: END;
229:
230: