468: group by cal_name, cal_start_date) uset
469: order by cal_start_date
470: ';
471:
472: l_custom_rec := bis_pmv_parameters_pub.initialize_query_type;
473: x_custom_output := bis_query_attributes_tbl();
474:
475: l_custom_rec.attribute_name := ':ISC_AGG_LEVEL';
476: l_custom_rec.attribute_value := l_agg_level;
473: x_custom_output := bis_query_attributes_tbl();
474:
475: l_custom_rec.attribute_name := ':ISC_AGG_LEVEL';
476: l_custom_rec.attribute_value := l_agg_level;
477: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
478: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
479: x_custom_output.EXTEND;
480: x_custom_output(x_custom_output.count) := l_custom_rec;
481:
474:
475: l_custom_rec.attribute_name := ':ISC_AGG_LEVEL';
476: l_custom_rec.attribute_value := l_agg_level;
477: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
478: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
479: x_custom_output.EXTEND;
480: x_custom_output(x_custom_output.count) := l_custom_rec;
481:
482: l_custom_rec.attribute_name := ':ISC_LAG';
480: x_custom_output(x_custom_output.count) := l_custom_rec;
481:
482: l_custom_rec.attribute_name := ':ISC_LAG';
483: l_custom_rec.attribute_value := l_lag;
484: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
485: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
486: x_custom_output.EXTEND;
487: x_custom_output(x_custom_output.count) := l_custom_rec;
488:
481:
482: l_custom_rec.attribute_name := ':ISC_LAG';
483: l_custom_rec.attribute_value := l_lag;
484: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
485: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
486: x_custom_output.EXTEND;
487: x_custom_output(x_custom_output.count) := l_custom_rec;
488:
489: l_custom_rec.attribute_name := ':ISC_SG';
487: x_custom_output(x_custom_output.count) := l_custom_rec;
488:
489: l_custom_rec.attribute_name := ':ISC_SG';
490: l_custom_rec.attribute_value := to_char(l_sg_sg);
491: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
492: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
493: x_custom_output.extend;
494: x_custom_output(x_custom_output.count) := l_custom_rec;
495:
488:
489: l_custom_rec.attribute_name := ':ISC_SG';
490: l_custom_rec.attribute_value := to_char(l_sg_sg);
491: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
492: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
493: x_custom_output.extend;
494: x_custom_output(x_custom_output.count) := l_custom_rec;
495:
496: l_custom_rec.attribute_name := ':ISC_RES';
494: x_custom_output(x_custom_output.count) := l_custom_rec;
495:
496: l_custom_rec.attribute_name := ':ISC_RES';
497: l_custom_rec.attribute_value := to_char(l_sg_res);
498: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
499: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
500: x_custom_output.extend;
501: x_custom_output(x_custom_output.count) := l_custom_rec;
502:
495:
496: l_custom_rec.attribute_name := ':ISC_RES';
497: l_custom_rec.attribute_value := to_char(l_sg_res);
498: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
499: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
500: x_custom_output.extend;
501: x_custom_output(x_custom_output.count) := l_custom_rec;
502:
503: x_custom_sql := l_query;