APPS.OPI_DBI_MTL_VAR_RPT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 97: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

93: 'N');
94:
95: -- prepare output for bind variables
96: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
97: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
98:
99: -- set the basic bind variables for the status SQL
100: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
101:

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

101:
102: -- Passing OPI_ITEM_CAT_FLAG to PMV
103: l_custom_rec.attribute_name := ':OPI_ITEM_CAT_FLAG';
104: l_custom_rec.attribute_value := l_item_cat_flag;
105: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
106: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
107: x_custom_output.extend;
108: x_custom_output(x_custom_output.count) := l_custom_rec;
109:

Line 106: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

102: -- Passing OPI_ITEM_CAT_FLAG to PMV
103: l_custom_rec.attribute_name := ':OPI_ITEM_CAT_FLAG';
104: l_custom_rec.attribute_value := l_item_cat_flag;
105: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
106: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
107: x_custom_output.extend;
108: x_custom_output(x_custom_output.count) := l_custom_rec;
109:
110: commit;

Line 277: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

273:
274:
275: -- Prepare PMV bind variables
276: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
277: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
278:
279: -- get all the basic binds used by POA queries
280: -- Do this before adding any of our binds, since the procedure
281: -- reinitializes the output table

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

284:
285: -- put the custom OPI binds in
286: l_custom_rec.attribute_name := ':OPI_ITEM_CAT_FLAG';
287: l_custom_rec.attribute_value := l_item_cat_flag;
288: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
289: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
290: x_custom_output.extend;
291: x_custom_output(x_custom_output.count) := l_custom_rec;
292:

Line 289: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

285: -- put the custom OPI binds in
286: l_custom_rec.attribute_name := ':OPI_ITEM_CAT_FLAG';
287: l_custom_rec.attribute_value := l_item_cat_flag;
288: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
289: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
290: x_custom_output.extend;
291: x_custom_output(x_custom_output.count) := l_custom_rec;
292:
293: commit;