165: END IF;
166:
167:
168:
169: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
170: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
171:
172: IF (l_plan IS NULL OR l_plan2 IS NULL)
173: THEN l_stmt := '
340: x_custom_sql := l_stmt;
341:
342: l_custom_rec.attribute_name := ':ISC_PERIOD_TYPE_ID';
343: l_custom_rec.attribute_value := to_char(l_period_type_id);
344: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
345: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
346: x_custom_output.EXTEND;
347: x_custom_output(1) := l_custom_rec;
348:
341:
342: l_custom_rec.attribute_name := ':ISC_PERIOD_TYPE_ID';
343: l_custom_rec.attribute_value := to_char(l_period_type_id);
344: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
345: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
346: x_custom_output.EXTEND;
347: x_custom_output(1) := l_custom_rec;
348:
349: l_custom_rec.attribute_name := ':ISC_CUR_START';
347: x_custom_output(1) := l_custom_rec;
348:
349: l_custom_rec.attribute_name := ':ISC_CUR_START';
350: l_custom_rec.attribute_value := to_char(l_time_from,'DD/MM/YYYY');
351: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
352: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
353: x_custom_output.EXTEND;
354: x_custom_output(2) := l_custom_rec;
355:
348:
349: l_custom_rec.attribute_name := ':ISC_CUR_START';
350: l_custom_rec.attribute_value := to_char(l_time_from,'DD/MM/YYYY');
351: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
352: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
353: x_custom_output.EXTEND;
354: x_custom_output(2) := l_custom_rec;
355:
356: l_custom_rec.attribute_name := ':ISC_LANG';
354: x_custom_output(2) := l_custom_rec;
355:
356: l_custom_rec.attribute_name := ':ISC_LANG';
357: l_custom_rec.attribute_value := l_lang;
358: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
359: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
360: x_custom_output.EXTEND;
361: x_custom_output(3) := l_custom_rec;
362:
355:
356: l_custom_rec.attribute_name := ':ISC_LANG';
357: l_custom_rec.attribute_value := l_lang;
358: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
359: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
360: x_custom_output.EXTEND;
361: x_custom_output(3) := l_custom_rec;
362:
363: