385: group by cal_name, cal_start_date) uset
386: order by cal_start_date
387: ';
388:
389: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
390: x_custom_output := bis_query_attributes_tbl();
391:
392: l_custom_rec.attribute_name := ':ISC_AGG_LEVEL';
393: l_custom_rec.attribute_value := l_agg_level;
390: x_custom_output := bis_query_attributes_tbl();
391:
392: l_custom_rec.attribute_name := ':ISC_AGG_LEVEL';
393: l_custom_rec.attribute_value := l_agg_level;
394: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
395: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
396: x_custom_output.EXTEND;
397: x_custom_output(x_custom_output.count) := l_custom_rec;
398:
391:
392: l_custom_rec.attribute_name := ':ISC_AGG_LEVEL';
393: l_custom_rec.attribute_value := l_agg_level;
394: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
395: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
396: x_custom_output.EXTEND;
397: x_custom_output(x_custom_output.count) := l_custom_rec;
398:
399: l_custom_rec.attribute_name := ':ISC_LAG';
397: x_custom_output(x_custom_output.count) := l_custom_rec;
398:
399: l_custom_rec.attribute_name := ':ISC_LAG';
400: l_custom_rec.attribute_value := l_lag;
401: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
402: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
403: x_custom_output.EXTEND;
404: x_custom_output(x_custom_output.count) := l_custom_rec;
405:
398:
399: l_custom_rec.attribute_name := ':ISC_LAG';
400: l_custom_rec.attribute_value := l_lag;
401: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
402: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
403: x_custom_output.EXTEND;
404: x_custom_output(x_custom_output.count) := l_custom_rec;
405:
406: l_custom_rec.attribute_name := ':ISC_SG';
404: x_custom_output(x_custom_output.count) := l_custom_rec;
405:
406: l_custom_rec.attribute_name := ':ISC_SG';
407: l_custom_rec.attribute_value := to_char(l_sg_sg);
408: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
409: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
410: x_custom_output.extend;
411: x_custom_output(x_custom_output.count) := l_custom_rec;
412:
405:
406: l_custom_rec.attribute_name := ':ISC_SG';
407: l_custom_rec.attribute_value := to_char(l_sg_sg);
408: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
409: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
410: x_custom_output.extend;
411: x_custom_output(x_custom_output.count) := l_custom_rec;
412:
413: l_custom_rec.attribute_name := ':ISC_RES';
411: x_custom_output(x_custom_output.count) := l_custom_rec;
412:
413: l_custom_rec.attribute_name := ':ISC_RES';
414: l_custom_rec.attribute_value := to_char(l_sg_res);
415: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
416: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
417: x_custom_output.extend;
418: x_custom_output(x_custom_output.count) := l_custom_rec;
419:
412:
413: l_custom_rec.attribute_name := ':ISC_RES';
414: l_custom_rec.attribute_value := to_char(l_sg_res);
415: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
416: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
417: x_custom_output.extend;
418: x_custom_output(x_custom_output.count) := l_custom_rec;
419:
420: x_custom_sql := l_query;