APPS.OPI_DBI_MFG_VAR_RPT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 106: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

102: 'N');
103:
104: -- prepare output for bind variables
105: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
106: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
107:
108: -- set the basic bind variables for the status SQL
109: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
110:

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

110:
111: -- Passing OPI_ITEM_CAT_FLAG to PMV
112: l_custom_rec.attribute_name := ':OPI_ITEM_CAT_FLAG';
113: l_custom_rec.attribute_value := l_item_cat_flag;
114: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
115: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
116: x_custom_output.extend;
117: x_custom_output(x_custom_output.count) := l_custom_rec;
118:

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

111: -- Passing OPI_ITEM_CAT_FLAG to PMV
112: l_custom_rec.attribute_name := ':OPI_ITEM_CAT_FLAG';
113: l_custom_rec.attribute_value := l_item_cat_flag;
114: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
115: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
116: x_custom_output.extend;
117: x_custom_output(x_custom_output.count) := l_custom_rec;
118:
119: commit;

Line 295: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

291:
292:
293: -- Prepare PMV bind variables
294: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
295: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
296:
297: -- get all the basic binds used by POA queries
298: -- Do this before adding any of our binds, since the procedure
299: -- reinitializes the output table

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

302:
303: -- put the custom OPI binds in
304: l_custom_rec.attribute_name := ':OPI_ITEM_CAT_FLAG';
305: l_custom_rec.attribute_value := l_item_cat_flag;
306: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
307: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
308: x_custom_output.extend;
309: x_custom_output(x_custom_output.count) := l_custom_rec;
310:

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

303: -- put the custom OPI binds in
304: l_custom_rec.attribute_name := ':OPI_ITEM_CAT_FLAG';
305: l_custom_rec.attribute_value := l_item_cat_flag;
306: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
307: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
308: x_custom_output.extend;
309: x_custom_output(x_custom_output.count) := l_custom_rec;
310:
311: commit;