117: 'N');
118:
119: -- prepare output for bind variables
120: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
121: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
122:
123: -- set the basic bind variables for the status SQL
124: poa_dbi_util_pkg.get_custom_status_binds (x_custom_output);
125:
125:
126: -- Passing OPI_ITEM_CAT_FLAG to PMV
127: l_custom_rec.attribute_name := ':OPI_ITEM_CAT_FLAG';
128: l_custom_rec.attribute_value := l_item_cat_flag;
129: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
130: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
131: x_custom_output.extend;
132: x_custom_output(x_custom_output.count) := l_custom_rec;
133:
126: -- Passing OPI_ITEM_CAT_FLAG to PMV
127: l_custom_rec.attribute_name := ':OPI_ITEM_CAT_FLAG';
128: l_custom_rec.attribute_value := l_item_cat_flag;
129: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
130: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
131: x_custom_output.extend;
132: x_custom_output(x_custom_output.count) := l_custom_rec;
133:
134: x_custom_sql := l_query;
353:
354:
355: -- Prepare PMV bind variables
356: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
357: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
358:
359: -- get all the basic binds used by POA queries
360: -- Do this before adding any of our binds, since the procedure
361: -- reinitializes the output table
364:
365: -- put the custom OPI binds in
366: l_custom_rec.attribute_name := ':OPI_ITEM_CAT_FLAG';
367: l_custom_rec.attribute_value := l_item_cat_flag;
368: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
369: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
370: x_custom_output.extend;
371: x_custom_output(x_custom_output.count) := l_custom_rec;
372:
365: -- put the custom OPI binds in
366: l_custom_rec.attribute_name := ':OPI_ITEM_CAT_FLAG';
367: l_custom_rec.attribute_value := l_item_cat_flag;
368: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
369: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
370: x_custom_output.extend;
371: x_custom_output(x_custom_output.count) := l_custom_rec;
372:
373: x_custom_sql := l_query;