135: l_cur_end := FII_TIME_API.next_period_end_date(l_cur_end, l_period_type);
136: END LOOP;
137:
138:
139: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
140: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
141:
142: IF (l_plan IS NULL OR l_plan2 IS NULL)
143: THEN l_stmt := '
235: x_custom_sql := l_stmt;
236:
237: l_custom_rec.attribute_name := ':ISC_PERIOD_TYPE_ID';
238: l_custom_rec.attribute_value := to_char(l_period_type_id);
239: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
240: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
241: x_custom_output.EXTEND;
242: x_custom_output(1) := l_custom_rec;
243:
236:
237: l_custom_rec.attribute_name := ':ISC_PERIOD_TYPE_ID';
238: l_custom_rec.attribute_value := to_char(l_period_type_id);
239: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
240: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
241: x_custom_output.EXTEND;
242: x_custom_output(1) := l_custom_rec;
243:
244: l_custom_rec.attribute_name := ':ISC_CUR_START';
242: x_custom_output(1) := l_custom_rec;
243:
244: l_custom_rec.attribute_name := ':ISC_CUR_START';
245: l_custom_rec.attribute_value := to_char(l_cur_start,'DD/MM/YYYY');
246: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
247: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
248: x_custom_output.EXTEND;
249: x_custom_output(2) := l_custom_rec;
250:
243:
244: l_custom_rec.attribute_name := ':ISC_CUR_START';
245: l_custom_rec.attribute_value := to_char(l_cur_start,'DD/MM/YYYY');
246: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
247: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
248: x_custom_output.EXTEND;
249: x_custom_output(2) := l_custom_rec;
250:
251: l_custom_rec.attribute_name := ':ISC_CUR_END';
249: x_custom_output(2) := l_custom_rec;
250:
251: l_custom_rec.attribute_name := ':ISC_CUR_END';
252: l_custom_rec.attribute_value := to_char(l_cur_end,'DD/MM/YYYY');
253: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
254: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
255: x_custom_output.EXTEND;
256: x_custom_output(3) := l_custom_rec;
257:
250:
251: l_custom_rec.attribute_name := ':ISC_CUR_END';
252: l_custom_rec.attribute_value := to_char(l_cur_end,'DD/MM/YYYY');
253: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
254: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
255: x_custom_output.EXTEND;
256: x_custom_output(3) := l_custom_rec;
257:
258: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
254: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
255: x_custom_output.EXTEND;
256: x_custom_output(3) := l_custom_rec;
257:
258: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
259: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
260: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
261: x_custom_output.EXTEND;
262: x_custom_output(4) := l_custom_rec;
256: x_custom_output(3) := l_custom_rec;
257:
258: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
259: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
260: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
261: x_custom_output.EXTEND;
262: x_custom_output(4) := l_custom_rec;
263:
264: