DBA Data[Home] [Help]

APPS.POA_DBI_INV_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 57: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

53: l_to_date_type VARCHAR2(3);
54: BEGIN
55: l_join_tbl := POA_DBI_UTIL_PKG.POA_DBI_JOIN_TBL();
56: l_col_tbl := POA_DBI_UTIL_PKG.POA_DBI_COL_TBL();
57: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
58: --
59: l_sec_context := poa_dbi_sutil_pkg.get_sec_context(p_param);
60: if (l_sec_context = 'OU' or l_sec_context = 'OU/COM' or l_sec_context = 'SUPPLIER')then
61: poa_dbi_sutil_pkg.process_parameters(

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

215: x_custom_sql := l_query;
216:
217: l_custom_rec.attribute_name := '&PREV_PREV_DATE';
218: l_custom_rec.attribute_value := TO_CHAR(l_prev_prev_as_of_date, 'DD/MM/YYYY');
219: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
220: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
221: x_custom_output.EXTEND;
222: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
223:

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

216:
217: l_custom_rec.attribute_name := '&PREV_PREV_DATE';
218: l_custom_rec.attribute_value := TO_CHAR(l_prev_prev_as_of_date, 'DD/MM/YYYY');
219: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
220: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
221: x_custom_output.EXTEND;
222: x_custom_output(x_custom_output.COUNT) := l_custom_rec;
223:
224: EXCEPTION