134: ELSE l_bucket_high_where := '
135: AND mv.days_late < :ISC_HIGH';
136: END IF;
137:
138: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
139: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
140:
141: l_outer_sql:= 'ISC_ATTRIBUTE_2,ISC_ATTRIBUTE_4,ISC_ATTRIBUTE_8,ISC_MEASURE_1,ISC_MEASURE_2,
142: ISC_MEASURE_3,ISC_MEASURE_4,ISC_MEASURE_5,ISC_MEASURE_6,CURRENCY';
187: x_custom_sql := l_stmt;
188:
189: l_custom_rec.attribute_name := ':ISC_LOW';
190: l_custom_rec.attribute_value := to_char(l_low);
191: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
192: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
193: x_custom_output.extend;
194: x_custom_output(1) := l_custom_rec;
195:
188:
189: l_custom_rec.attribute_name := ':ISC_LOW';
190: l_custom_rec.attribute_value := to_char(l_low);
191: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
192: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
193: x_custom_output.extend;
194: x_custom_output(1) := l_custom_rec;
195:
196: l_custom_rec.attribute_name := ':ISC_HIGH';
194: x_custom_output(1) := l_custom_rec;
195:
196: l_custom_rec.attribute_name := ':ISC_HIGH';
197: l_custom_rec.attribute_value := to_char(l_high);
198: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
199: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
200: x_custom_output.extend;
201: x_custom_output(2) := l_custom_rec;
202:
195:
196: l_custom_rec.attribute_name := ':ISC_HIGH';
197: l_custom_rec.attribute_value := to_char(l_high);
198: l_custom_Rec.attribute_type := bis_pmv_parameters_pub.bind_type;
199: l_custom_rec.attribute_data_type := bis_pmv_parameters_pub.integer_bind;
200: x_custom_output.extend;
201: x_custom_output(2) := l_custom_rec;
202:
203: l_custom_rec.attribute_name := ':ISC_LANG';
201: x_custom_output(2) := l_custom_rec;
202:
203: l_custom_rec.attribute_name := ':ISC_LANG';
204: l_custom_rec.attribute_value := l_lang;
205: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
206: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
207: x_custom_output.EXTEND;
208: x_custom_output(3) := l_custom_rec;
209:
202:
203: l_custom_rec.attribute_name := ':ISC_LANG';
204: l_custom_rec.attribute_value := l_lang;
205: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
206: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
207: x_custom_output.EXTEND;
208: x_custom_output(3) := l_custom_rec;
209:
210: END Get_Sql;