DBA Data[Home] [Help]

APPS.ISC_DBI_PLAN_RES_UT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 191: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

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 := '

Line 305: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

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:

Line 306: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

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';

Line 312: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

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:

Line 313: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

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';

Line 319: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

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:

Line 320: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

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';

Line 326: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

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:

Line 327: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

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: