105:
106:
107: -- Prepare PMV bind variables
108: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
109: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
110:
111: -- get all the basic binds used by POA queries
112: -- Do this before adding any of our binds, since the procedure
113: -- reinitializes the output table
118:
119: -- Passing ISC_AGGREGATION_LEVEL_FLAG to PMV
120: l_custom_rec.attribute_name := ':ISC_AGG_FLAG';
121: l_custom_rec.attribute_value := l_aggregation_level_flag;
122: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
123: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
124: x_custom_output.extend;
125: x_custom_output(x_custom_output.count) := l_custom_rec;
126:
119: -- Passing ISC_AGGREGATION_LEVEL_FLAG to PMV
120: l_custom_rec.attribute_name := ':ISC_AGG_FLAG';
121: l_custom_rec.attribute_value := l_aggregation_level_flag;
122: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
123: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
124: x_custom_output.extend;
125: x_custom_output(x_custom_output.count) := l_custom_rec;
126:
127: x_custom_sql := l_query;