187:
188: END IF;
189:
190:
191: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
192: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
193:
194: IF (l_plan IS NULL OR l_plan2 IS NULL)
195: THEN l_stmt := '
301: x_custom_sql := l_stmt;
302:
303: l_custom_rec.attribute_name := ':ISC_PERIOD_TYPE_ID';
304: l_custom_rec.attribute_value := to_char(l_period_type_id);
305: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
306: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
307: x_custom_output.EXTEND;
308: x_custom_output(1) := l_custom_rec;
309:
302:
303: l_custom_rec.attribute_name := ':ISC_PERIOD_TYPE_ID';
304: l_custom_rec.attribute_value := to_char(l_period_type_id);
305: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
306: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
307: x_custom_output.EXTEND;
308: x_custom_output(1) := l_custom_rec;
309:
310: l_custom_rec.attribute_name := ':ISC_CUR_START';
308: x_custom_output(1) := l_custom_rec;
309:
310: l_custom_rec.attribute_name := ':ISC_CUR_START';
311: l_custom_rec.attribute_value := to_char(l_time_from,'DD/MM/YYYY');
312: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
313: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
314: x_custom_output.EXTEND;
315: x_custom_output(2) := l_custom_rec;
316:
309:
310: l_custom_rec.attribute_name := ':ISC_CUR_START';
311: l_custom_rec.attribute_value := to_char(l_time_from,'DD/MM/YYYY');
312: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
313: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
314: x_custom_output.EXTEND;
315: x_custom_output(2) := l_custom_rec;
316:
317: l_custom_rec.attribute_name := ':ISC_LANG';
315: x_custom_output(2) := l_custom_rec;
316:
317: l_custom_rec.attribute_name := ':ISC_LANG';
318: l_custom_rec.attribute_value := l_lang;
319: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
320: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
321: x_custom_output.EXTEND;
322: x_custom_output(3) := l_custom_rec;
323:
316:
317: l_custom_rec.attribute_name := ':ISC_LANG';
318: l_custom_rec.attribute_value := l_lang;
319: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
320: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
321: x_custom_output.EXTEND;
322: x_custom_output(3) := l_custom_rec;
323:
324: l_custom_rec.attribute_name := ':ISC_RES_GP_FLAG';
322: x_custom_output(3) := l_custom_rec;
323:
324: l_custom_rec.attribute_name := ':ISC_RES_GP_FLAG';
325: l_custom_rec.attribute_value := to_char(l_res_gp_flag);
326: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
327: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
328: x_custom_output.EXTEND;
329: x_custom_output(4) := l_custom_rec;
330:
323:
324: l_custom_rec.attribute_name := ':ISC_RES_GP_FLAG';
325: l_custom_rec.attribute_value := to_char(l_res_gp_flag);
326: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
327: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
328: x_custom_output.EXTEND;
329: x_custom_output(4) := l_custom_rec;
330:
331: