APPS.POA_DBI_SPND_PKG dependencies on POA_DBI_SUTIL_PKG

Line 69: poa_dbi_sutil_pkg.process_parameters(p_param,

65:
66: l_mv_tbl := poa_dbi_util_pkg.poa_dbi_mv_tbl();
67:
68: ---Get the Invoice Amount Entered Measure
69: poa_dbi_sutil_pkg.process_parameters(p_param,
70: l_view_by,
71: l_view_by_col_name,
72: l_view_by_value,
73: l_comparison_type,

Line 98: poa_dbi_sutil_pkg.process_parameters(p_param,

94: , p_prior_code => poa_dbi_util_pkg.both_priors
95: , p_to_date_type => 'RLX');
96:
97: ---Get the Paid Amount Measure
98: poa_dbi_sutil_pkg.process_parameters(p_param,
99: l_view_by,
100: l_view_by_col_name,
101: l_view_by_value,
102: l_comparison_type,

Line 127: poa_dbi_sutil_pkg.process_parameters(p_param,

123: , p_prior_code => poa_dbi_util_pkg.both_priors
124: , p_to_date_type => 'RLX');
125:
126: ---Get the Purchased Amt. Measure
127: poa_dbi_sutil_pkg.process_parameters(p_param,
128: l_view_by,
129: l_view_by_col_name,
130: l_view_by_value,
131: l_comparison_type,

Line 156: poa_dbi_sutil_pkg.process_parameters(p_param,

152: , p_prior_code => poa_dbi_util_pkg.both_priors
153: , p_to_date_type => 'RLX');
154:
155: --Get the Invoice Amt. which is Matched to PO mesaure
156: poa_dbi_sutil_pkg.process_parameters(p_param,
157: l_view_by,
158: l_view_by_col_name,
159: l_view_by_value,
160: l_comparison_type,

Line 191: l_mv_tbl(1).mv_hint := poa_dbi_sutil_pkg.get_fact_hint(l_mv1);

187: l_mv_tbl(1).mv_col := l_col_tbl1;
188: l_mv_tbl(1).mv_where := l_where_clause1;
189: l_mv_tbl(1).in_join_tbls := l_in_join_tbl1;
190: l_mv_tbl(1).use_grp_id := 'N';
191: l_mv_tbl(1).mv_hint := poa_dbi_sutil_pkg.get_fact_hint(l_mv1);
192: l_mv_tbl(1).mv_xtd := l_xtd;
193:
194: l_mv_tbl.extend;
195: l_mv_tbl(2).mv_name := l_mv2;

Line 200: l_mv_tbl(2).mv_hint := poa_dbi_sutil_pkg.get_fact_hint(l_mv2);

196: l_mv_tbl(2).mv_col := l_col_tbl2;
197: l_mv_tbl(2).mv_where := l_where_clause2;
198: l_mv_tbl(2).in_join_tbls := l_in_join_tbl2;
199: l_mv_tbl(2).use_grp_id := 'N';
200: l_mv_tbl(2).mv_hint := poa_dbi_sutil_pkg.get_fact_hint(l_mv2);
201: l_mv_tbl(2).mv_xtd := l_xtd;
202:
203: l_mv_tbl.extend;
204: l_mv_tbl(3).mv_name := l_mv3;

Line 209: l_mv_tbl(3).mv_hint := poa_dbi_sutil_pkg.get_fact_hint(l_mv3);

205: l_mv_tbl(3).mv_col := l_col_tbl3;
206: l_mv_tbl(3).mv_where := l_where_clause3;
207: l_mv_tbl(3).in_join_tbls := l_in_join_tbl3;
208: l_mv_tbl(3).use_grp_id := 'N';
209: l_mv_tbl(3).mv_hint := poa_dbi_sutil_pkg.get_fact_hint(l_mv3);
210: l_mv_tbl(3).mv_xtd := l_xtd;
211:
212: l_mv_tbl.extend;
213: l_mv_tbl(4).mv_name := l_mv4;

Line 218: l_mv_tbl(4).mv_hint := poa_dbi_sutil_pkg.get_fact_hint(l_mv4);

214: l_mv_tbl(4).mv_col := l_col_tbl4;
215: l_mv_tbl(4).mv_where := l_where_clause4;
216: l_mv_tbl(4).in_join_tbls := l_in_join_tbl4;
217: l_mv_tbl(4).use_grp_id := 'N';
218: l_mv_tbl(4).mv_hint := poa_dbi_sutil_pkg.get_fact_hint(l_mv4);
219: l_mv_tbl(4).mv_xtd := l_xtd;
220:
221:
222: l_query := get_trend_sel_clause(l_view_by) ||