121:
122:
123: -- Prepare PMV bind variables
124: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
125: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
126:
127: -- get all the basic binds used by POA queries
128: -- Do this before adding any of our binds, since the procedure
129: -- reinitializes the output table
134:
135: -- Passing ISC_AGGREGATION_LEVEL_FLAG to PMV
136: l_custom_rec.attribute_name := ':ISC_AGG_FLAG';
137: l_custom_rec.attribute_value := l_aggregation_level_flag;
138: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
139: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
140: x_custom_output.extend;
141: x_custom_output(x_custom_output.count) := l_custom_rec;
142:
135: -- Passing ISC_AGGREGATION_LEVEL_FLAG to PMV
136: l_custom_rec.attribute_name := ':ISC_AGG_FLAG';
137: l_custom_rec.attribute_value := l_aggregation_level_flag;
138: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
139: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
140: x_custom_output.extend;
141: x_custom_output(x_custom_output.count) := l_custom_rec;
142:
143: x_custom_sql := l_query;