168: l_cur_end := FII_TIME_API.next_period_end_date(l_cur_end, l_period_type);
169: END LOOP;
170:
171:
172: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
173: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
174:
175: IF (l_plan IS NULL OR l_plan2 IS NULL)
176: THEN l_stmt := '
221: x_custom_sql := l_stmt;
222:
223: l_custom_rec.attribute_name := ':ISC_PERIOD_TYPE_ID';
224: l_custom_rec.attribute_value := to_char(l_period_type_id);
225: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
226: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
227: x_custom_output.EXTEND;
228: x_custom_output(1) := l_custom_rec;
229:
222:
223: l_custom_rec.attribute_name := ':ISC_PERIOD_TYPE_ID';
224: l_custom_rec.attribute_value := to_char(l_period_type_id);
225: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
226: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
227: x_custom_output.EXTEND;
228: x_custom_output(1) := l_custom_rec;
229:
230: l_custom_rec.attribute_name := ':ISC_CUR_START';
228: x_custom_output(1) := l_custom_rec;
229:
230: l_custom_rec.attribute_name := ':ISC_CUR_START';
231: l_custom_rec.attribute_value := to_char(l_cur_start,'DD/MM/YYYY');
232: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
233: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
234: x_custom_output.EXTEND;
235: x_custom_output(2) := l_custom_rec;
236:
229:
230: l_custom_rec.attribute_name := ':ISC_CUR_START';
231: l_custom_rec.attribute_value := to_char(l_cur_start,'DD/MM/YYYY');
232: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
233: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
234: x_custom_output.EXTEND;
235: x_custom_output(2) := l_custom_rec;
236:
237: l_custom_rec.attribute_name := ':ISC_CUR_END';
235: x_custom_output(2) := l_custom_rec;
236:
237: l_custom_rec.attribute_name := ':ISC_CUR_END';
238: l_custom_rec.attribute_value := to_char(l_cur_end,'DD/MM/YYYY');
239: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
240: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
241: x_custom_output.EXTEND;
242: x_custom_output(3) := l_custom_rec;
243:
236:
237: l_custom_rec.attribute_name := ':ISC_CUR_END';
238: l_custom_rec.attribute_value := to_char(l_cur_end,'DD/MM/YYYY');
239: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
240: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
241: x_custom_output.EXTEND;
242: x_custom_output(3) := l_custom_rec;
243:
244: l_custom_rec.attribute_name := ':ISC_RES_GP_FLAG';
242: x_custom_output(3) := l_custom_rec;
243:
244: l_custom_rec.attribute_name := ':ISC_RES_GP_FLAG';
245: l_custom_rec.attribute_value := to_char(l_res_gp_flag);
246: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
247: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
248: x_custom_output.EXTEND;
249: x_custom_output(4) := l_custom_rec;
250:
243:
244: l_custom_rec.attribute_name := ':ISC_RES_GP_FLAG';
245: l_custom_rec.attribute_value := to_char(l_res_gp_flag);
246: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
247: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
248: x_custom_output.EXTEND;
249: x_custom_output(4) := l_custom_rec;
250:
251: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
247: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
248: x_custom_output.EXTEND;
249: x_custom_output(4) := l_custom_rec;
250:
251: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
252: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
253: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
254: x_custom_output.EXTEND;
255: x_custom_output(5) := l_custom_rec;
249: x_custom_output(4) := l_custom_rec;
250:
251: l_custom_rec.attribute_name := BIS_PMV_PARAMETERS_PUB.VIEW_BY_VALUE;
252: l_custom_rec.attribute_value := 'TIME+'||l_period_type;
253: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.VIEW_BY_TYPE;
254: x_custom_output.EXTEND;
255: x_custom_output(5) := l_custom_rec;
256:
257: END get_sql;