DBA Data[Home] [Help]

APPS.POA_DBI_POP_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 162: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

158: l_cols VARCHAR2(600);
159: BEGIN
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');

Line 248: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

244: x_custom_sql := l_query;
245:
246: l_custom_rec.attribute_name := '&PREV_PREV_DATE';
247: l_custom_rec.attribute_value := TO_CHAR(l_prev_as_of_date2, 'DD/MM/YYYY');
248: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
249: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
250: x_custom_output.EXTEND;
251: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
252:

Line 249: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

245:
246: l_custom_rec.attribute_name := '&PREV_PREV_DATE';
247: l_custom_rec.attribute_value := TO_CHAR(l_prev_as_of_date2, 'DD/MM/YYYY');
248: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
249: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
250: x_custom_output.EXTEND;
251: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
252:
253: