eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ISC_DBI_PLAN_PERF_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 125: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;

121: l_pre_end := FII_TIME_API.ent_pper_end(l_time_to); -- get the previous month
122:
123: l_lang := USERENV('LANG');
124:
125: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
126: x_custom_output := BIS_QUERY_ATTRIBUTES_TBL();
127:
128:
129: IF (l_plan IS NULL OR l_plan2 IS NULL)

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

356: x_custom_sql := l_stmt;
357:
358: l_custom_rec.attribute_name := ':ISC_PERIOD_TYPE_ID';
359: l_custom_rec.attribute_value := to_char(l_period_type_id);
360: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
361: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
362: x_custom_output.EXTEND;
363: x_custom_output(1) := l_custom_rec;
364:

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

357:
358: l_custom_rec.attribute_name := ':ISC_PERIOD_TYPE_ID';
359: l_custom_rec.attribute_value := to_char(l_period_type_id);
360: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
361: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
362: x_custom_output.EXTEND;
363: x_custom_output(1) := l_custom_rec;
364:
365: l_custom_rec.attribute_name := ':ISC_CUR_START';

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

363: x_custom_output(1) := l_custom_rec;
364:
365: l_custom_rec.attribute_name := ':ISC_CUR_START';
366: l_custom_rec.attribute_value := to_char(l_cur_start,'DD/MM/YYYY');
367: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
368: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
369: x_custom_output.EXTEND;
370: x_custom_output(2) := l_custom_rec;
371:

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

364:
365: l_custom_rec.attribute_name := ':ISC_CUR_START';
366: l_custom_rec.attribute_value := to_char(l_cur_start,'DD/MM/YYYY');
367: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
368: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
369: x_custom_output.EXTEND;
370: x_custom_output(2) := l_custom_rec;
371:
372: l_custom_rec.attribute_name := ':ISC_CUR_END';

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

370: x_custom_output(2) := l_custom_rec;
371:
372: l_custom_rec.attribute_name := ':ISC_CUR_END';
373: l_custom_rec.attribute_value := to_char(l_cur_end,'DD/MM/YYYY');
374: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
375: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
376: x_custom_output.EXTEND;
377: x_custom_output(3) := l_custom_rec;
378:

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

371:
372: l_custom_rec.attribute_name := ':ISC_CUR_END';
373: l_custom_rec.attribute_value := to_char(l_cur_end,'DD/MM/YYYY');
374: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
375: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
376: x_custom_output.EXTEND;
377: x_custom_output(3) := l_custom_rec;
378:
379: l_custom_rec.attribute_name := ':ISC_PRE_START';

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

377: x_custom_output(3) := l_custom_rec;
378:
379: l_custom_rec.attribute_name := ':ISC_PRE_START';
380: l_custom_rec.attribute_value := to_char(l_pre_start,'DD/MM/YYYY');
381: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
382: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
383: x_custom_output.EXTEND;
384: x_custom_output(4) := l_custom_rec;
385:

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

378:
379: l_custom_rec.attribute_name := ':ISC_PRE_START';
380: l_custom_rec.attribute_value := to_char(l_pre_start,'DD/MM/YYYY');
381: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
382: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
383: x_custom_output.EXTEND;
384: x_custom_output(4) := l_custom_rec;
385:
386: l_custom_rec.attribute_name := ':ISC_PRE_END';

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

384: x_custom_output(4) := l_custom_rec;
385:
386: l_custom_rec.attribute_name := ':ISC_PRE_END';
387: l_custom_rec.attribute_value := to_char(l_pre_end,'DD/MM/YYYY');
388: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
389: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
390: x_custom_output.EXTEND;
391: x_custom_output(5) := l_custom_rec;
392:

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

385:
386: l_custom_rec.attribute_name := ':ISC_PRE_END';
387: l_custom_rec.attribute_value := to_char(l_pre_end,'DD/MM/YYYY');
388: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
389: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
390: x_custom_output.EXTEND;
391: x_custom_output(5) := l_custom_rec;
392:
393:

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

392:
393:
394: l_custom_rec.attribute_name := ':ISC_LANG';
395: l_custom_rec.attribute_value := l_lang;
396: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
397: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
398: x_custom_output.EXTEND;
399: x_custom_output(6) := l_custom_rec;
400:

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

393:
394: l_custom_rec.attribute_name := ':ISC_LANG';
395: l_custom_rec.attribute_value := l_lang;
396: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
397: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
398: x_custom_output.EXTEND;
399: x_custom_output(6) := l_custom_rec;
400:
401: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';

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

399: x_custom_output(6) := l_custom_rec;
400:
401: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
402: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
403: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
404: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
405: x_custom_output.EXTEND;
406: x_custom_output(7) := l_custom_rec;
407:

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

400:
401: l_custom_rec.attribute_name := ':ISC_ITEM_CAT_FLAG';
402: l_custom_rec.attribute_value := to_char(l_item_cat_flag);
403: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
404: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
405: x_custom_output.EXTEND;
406: x_custom_output(7) := l_custom_rec;
407:
408: l_custom_rec.attribute_name := ':ISC_UNION_FLAG';

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

406: x_custom_output(7) := l_custom_rec;
407:
408: l_custom_rec.attribute_name := ':ISC_UNION_FLAG';
409: l_custom_rec.attribute_value := to_char(l_union_flag);
410: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
411: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
412: x_custom_output.EXTEND;
413: x_custom_output(8) := l_custom_rec;
414:

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

407:
408: l_custom_rec.attribute_name := ':ISC_UNION_FLAG';
409: l_custom_rec.attribute_value := to_char(l_union_flag);
410: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
411: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
412: x_custom_output.EXTEND;
413: x_custom_output(8) := l_custom_rec;
414:
415: l_custom_rec.attribute_name := ':ISC_RES_GP_FLAG';

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

413: x_custom_output(8) := l_custom_rec;
414:
415: l_custom_rec.attribute_name := ':ISC_RES_GP_FLAG';
416: l_custom_rec.attribute_value := to_char(l_res_gp_flag);
417: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
418: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
419: x_custom_output.EXTEND;
420: x_custom_output(9) := l_custom_rec;
421:

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

414:
415: l_custom_rec.attribute_name := ':ISC_RES_GP_FLAG';
416: l_custom_rec.attribute_value := to_char(l_res_gp_flag);
417: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
418: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
419: x_custom_output.EXTEND;
420: x_custom_output(9) := l_custom_rec;
421:
422: l_custom_rec.attribute_name := ':ISC_MON_PERIOD_ID';

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

420: x_custom_output(9) := l_custom_rec;
421:
422: l_custom_rec.attribute_name := ':ISC_MON_PERIOD_ID';
423: l_custom_rec.attribute_value := to_char(l_mon_period_id);
424: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
425: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
426: x_custom_output.EXTEND;
427: x_custom_output(10) := l_custom_rec;
428:

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

421:
422: l_custom_rec.attribute_name := ':ISC_MON_PERIOD_ID';
423: l_custom_rec.attribute_value := to_char(l_mon_period_id);
424: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
425: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
426: x_custom_output.EXTEND;
427: x_custom_output(10) := l_custom_rec;
428:
429: l_custom_rec.attribute_name := ':ISC_MON_NUM';

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

427: x_custom_output(10) := l_custom_rec;
428:
429: l_custom_rec.attribute_name := ':ISC_MON_NUM';
430: l_custom_rec.attribute_value := to_char(l_mon_num);
431: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
432: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
433: x_custom_output.EXTEND;
434: x_custom_output(11) := l_custom_rec;
435:

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

428:
429: l_custom_rec.attribute_name := ':ISC_MON_NUM';
430: l_custom_rec.attribute_value := to_char(l_mon_num);
431: l_custom_Rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
432: l_custom_Rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
433: x_custom_output.EXTEND;
434: x_custom_output(11) := l_custom_rec;
435:
436: END get_sql;