170: and((oset.rnk between &START_INDEX and &END_INDEX) OR (&END_INDEX = -1))
171: &ORDER_BY_CLAUSE nulls last
172: ';
173:
174: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
175: x_custom_output := bis_query_attributes_tbl();
176:
177: l_custom_rec.attribute_name := ':ISC_SG';
178: l_custom_rec.attribute_value := to_char(l_sg_sg);
175: x_custom_output := bis_query_attributes_tbl();
176:
177: l_custom_rec.attribute_name := ':ISC_SG';
178: l_custom_rec.attribute_value := to_char(l_sg_sg);
179: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
180: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
181: x_custom_output.extend;
182: x_custom_output(x_custom_output.count) := l_custom_rec;
183:
176:
177: l_custom_rec.attribute_name := ':ISC_SG';
178: l_custom_rec.attribute_value := to_char(l_sg_sg);
179: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
180: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
181: x_custom_output.extend;
182: x_custom_output(x_custom_output.count) := l_custom_rec;
183:
184: l_custom_rec.attribute_name := ':ISC_RES';
182: x_custom_output(x_custom_output.count) := l_custom_rec;
183:
184: l_custom_rec.attribute_name := ':ISC_RES';
185: l_custom_rec.attribute_value := to_char(l_sg_res);
186: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
187: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
188: x_custom_output.extend;
189: x_custom_output(x_custom_output.count) := l_custom_rec;
190:
183:
184: l_custom_rec.attribute_name := ':ISC_RES';
185: l_custom_rec.attribute_value := to_char(l_sg_res);
186: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
187: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
188: x_custom_output.extend;
189: x_custom_output(x_custom_output.count) := l_custom_rec;
190:
191: x_custom_sql := l_query;