APPS.POA_DBI_NCP_PKG dependencies on POA_DBI_SUTIL_PKG

Line 33: 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, x_custom_output ,

29: BEGIN
30: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
31: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
32:
33: 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, x_custom_output ,
34: 'N','PO', '5.0', 'VPP','POD');
35:
36: poa_dbi_util_pkg.add_column(l_col_tbl, 'purchase_amt_' || l_cur_suffix, 'purchase_amt');
37: poa_dbi_util_pkg.add_column(l_col_tbl, 'n_contract_amt_' || l_cur_suffix, 'n_contract_amt');

Line 86: poa_dbi_sutil_pkg.process_parameters(p_param

82: BEGIN
83: l_join_tbl := poa_dbi_util_pkg.POA_DBI_JOIN_TBL();
84: l_col_tbl := poa_dbi_util_pkg.POA_DBI_COL_TBL();
85:
86: poa_dbi_sutil_pkg.process_parameters(p_param
87: ,l_view_by
88: ,l_view_by_col
89: ,l_view_by_value
90: ,l_comparison_type

Line 122: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;

118: END;
119:
120: FUNCTION get_status_filter_where return VARCHAR2
121: IS
122: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
123: BEGIN
124: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
125: l_col_tbl.extend;
126: l_col_tbl(1) := 'POA_MEASURE1';

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

120: FUNCTION get_status_filter_where return VARCHAR2
121: IS
122: l_col_tbl poa_dbi_sutil_pkg.poa_dbi_filter_tbl;
123: BEGIN
124: l_col_tbl := poa_dbi_sutil_pkg.POA_DBI_FILTER_TBL();
125: l_col_tbl.extend;
126: l_col_tbl(1) := 'POA_MEASURE1';
127: l_col_tbl.extend;
128: l_col_tbl(2) := 'POA_PERCENT2';

Line 134: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);

130: l_col_tbl(3) := 'POA_PERCENT1';
131: l_col_tbl.extend;
132: l_col_tbl(4) := 'POA_MEASURE3';
133:
134: return poa_dbi_sutil_pkg.get_filter_where(l_col_tbl);
135:
136: END;
137:
138: FUNCTION get_status_sel_clause(p_view_by_col in VARCHAR2, p_url in VARCHAR2) return VARCHAR2