DBA Data[Home] [Help]

APPS.ISC_DBI_PLAN_INV_TURN_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 194: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

190:
191: END if;
192:
193:
194: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
195: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
196:
197:
198: IF (l_plan IS NULL OR l_plan2 IS NULL)

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

333: x_custom_sql := l_stmt;
334:
335: l_custom_rec.attribute_name := ':ISC_CUR_START';
336: l_custom_rec.attribute_value := to_char(l_cur_start,'DD/MM/YYYY');
337: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
338: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
339: x_custom_output.EXTEND;
340: x_custom_output(1) := l_custom_rec;
341:

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

334:
335: l_custom_rec.attribute_name := ':ISC_CUR_START';
336: l_custom_rec.attribute_value := to_char(l_cur_start,'DD/MM/YYYY');
337: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
338: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
339: x_custom_output.EXTEND;
340: x_custom_output(1) := l_custom_rec;
341:
342: l_custom_rec.attribute_name := ':ISC_CUR_END';

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

340: x_custom_output(1) := l_custom_rec;
341:
342: l_custom_rec.attribute_name := ':ISC_CUR_END';
343: l_custom_rec.attribute_value := to_char(l_cur_end,'DD/MM/YYYY');
344: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
345: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
346: x_custom_output.EXTEND;
347: x_custom_output(2) := l_custom_rec;
348:

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

341:
342: l_custom_rec.attribute_name := ':ISC_CUR_END';
343: l_custom_rec.attribute_value := to_char(l_cur_end,'DD/MM/YYYY');
344: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
345: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
346: x_custom_output.EXTEND;
347: x_custom_output(2) := l_custom_rec;
348:
349: l_custom_rec.attribute_name := ':ISC_PRE_START';

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

347: x_custom_output(2) := l_custom_rec;
348:
349: l_custom_rec.attribute_name := ':ISC_PRE_START';
350: l_custom_rec.attribute_value := to_char(l_pre_start,'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(3) := l_custom_rec;
355:

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

348:
349: l_custom_rec.attribute_name := ':ISC_PRE_START';
350: l_custom_rec.attribute_value := to_char(l_pre_start,'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(3) := l_custom_rec;
355:
356: l_custom_rec.attribute_name := ':ISC_PRE_END';

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

354: x_custom_output(3) := l_custom_rec;
355:
356: l_custom_rec.attribute_name := ':ISC_PRE_END';
357: l_custom_rec.attribute_value := to_char(l_pre_end,'DD/MM/YYYY');
358: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
359: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
360: x_custom_output.EXTEND;
361: x_custom_output(4) := l_custom_rec;
362:

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

355:
356: l_custom_rec.attribute_name := ':ISC_PRE_END';
357: l_custom_rec.attribute_value := to_char(l_pre_end,'DD/MM/YYYY');
358: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
359: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
360: x_custom_output.EXTEND;
361: x_custom_output(4) := l_custom_rec;
362:
363: l_custom_rec.attribute_name := ':ISC_LANG';

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

361: x_custom_output(4) := l_custom_rec;
362:
363: l_custom_rec.attribute_name := ':ISC_LANG';
364: l_custom_rec.attribute_value := l_lang;
365: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
366: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
367: x_custom_output.EXTEND;
368: x_custom_output(5) := l_custom_rec;
369:

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

362:
363: l_custom_rec.attribute_name := ':ISC_LANG';
364: l_custom_rec.attribute_value := l_lang;
365: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
366: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
367: x_custom_output.EXTEND;
368: x_custom_output(5) := l_custom_rec;
369:
370: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';

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

368: x_custom_output(5) := l_custom_rec;
369:
370: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
371: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
372: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
373: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
374: x_custom_output.EXTEND;
375: x_custom_output(6) := l_custom_rec;
376:

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

369:
370: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
371: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
372: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
373: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
374: x_custom_output.EXTEND;
375: x_custom_output(6) := l_custom_rec;
376:
377: l_custom_rec.attribute_name := ':ISC_MON_NUM';

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

375: x_custom_output(6) := l_custom_rec;
376:
377: l_custom_rec.attribute_name := ':ISC_MON_NUM';
378: l_custom_rec.attribute_value := to_char(l_mon_num);
379: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
380: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
381: x_custom_output.EXTEND;
382: x_custom_output(7) := l_custom_rec;
383:

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

376:
377: l_custom_rec.attribute_name := ':ISC_MON_NUM';
378: l_custom_rec.attribute_value := to_char(l_mon_num);
379: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
380: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
381: x_custom_output.EXTEND;
382: x_custom_output(7) := l_custom_rec;
383:
384: