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.ENI_DBI_COT_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 114: -- l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

110: l_order_by:=' t.start_date asc ';
111: END IF;
112:
113:
114: -- l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
115:
116: IF (l_priority IS NULL OR l_priority = '' OR l_priority = 'All')
117: THEN
118: null;

Line 380: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

376: t.name,t.start_date,t.c_end_date
377: ORDER BY
378: '||l_order_by;
379:
380: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
381: x_custom_output := bis_query_attributes_tbl();
382:
383:
384:

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

384:
385: x_custom_output.extend;
386: l_custom_rec.attribute_name := ':ITEM';
387: l_custom_rec.attribute_value := l_item;
388: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
389: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
390: x_custom_output(1) := l_custom_rec;
391:
392:

Line 389: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

385: x_custom_output.extend;
386: l_custom_rec.attribute_name := ':ITEM';
387: l_custom_rec.attribute_value := l_item;
388: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
389: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
390: x_custom_output(1) := l_custom_rec;
391:
392:
393: x_custom_output.extend;

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

392:
393: x_custom_output.extend;
394: l_custom_rec.attribute_name := ':ORG';
395: l_custom_rec.attribute_value := replace(l_org,'''');
396: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
397: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
398: x_custom_output(2) := l_custom_rec;
399:
400: x_custom_output.extend;

Line 397: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

393: x_custom_output.extend;
394: l_custom_rec.attribute_name := ':ORG';
395: l_custom_rec.attribute_value := replace(l_org,'''');
396: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
397: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
398: x_custom_output(2) := l_custom_rec;
399:
400: x_custom_output.extend;
401: l_custom_rec.attribute_name := ':REASON';

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

399:
400: x_custom_output.extend;
401: l_custom_rec.attribute_name := ':REASON';
402: l_custom_rec.attribute_value := l_reason;
403: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
404: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
405: x_custom_output(3) := l_custom_rec;
406:
407: x_custom_output.extend;

Line 404: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

400: x_custom_output.extend;
401: l_custom_rec.attribute_name := ':REASON';
402: l_custom_rec.attribute_value := l_reason;
403: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
404: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
405: x_custom_output(3) := l_custom_rec;
406:
407: x_custom_output.extend;
408: l_custom_rec.attribute_name := ':PRIORITY';

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

406:
407: x_custom_output.extend;
408: l_custom_rec.attribute_name := ':PRIORITY';
409: l_custom_rec.attribute_value := l_priority;
410: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
411: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
412: x_custom_output(4) := l_custom_rec;
413:
414: x_custom_output.extend;

Line 411: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

407: x_custom_output.extend;
408: l_custom_rec.attribute_name := ':PRIORITY';
409: l_custom_rec.attribute_value := l_priority;
410: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
411: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
412: x_custom_output(4) := l_custom_rec;
413:
414: x_custom_output.extend;
415: l_custom_rec.attribute_name := ':STATUS';

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

413:
414: x_custom_output.extend;
415: l_custom_rec.attribute_name := ':STATUS';
416: l_custom_rec.attribute_value := replace(l_status,'''');
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(5) := l_custom_rec;
420:
421: x_custom_output.extend;

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

414: x_custom_output.extend;
415: l_custom_rec.attribute_name := ':STATUS';
416: l_custom_rec.attribute_value := replace(l_status,'''');
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(5) := l_custom_rec;
420:
421: x_custom_output.extend;
422: l_custom_rec.attribute_name := ':TYPE';

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

420:
421: x_custom_output.extend;
422: l_custom_rec.attribute_name := ':TYPE';
423: l_custom_rec.attribute_value := replace(l_type,'''');
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(6) := l_custom_rec;
427:
428: --Bug 5083882 - Start Code

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

421: x_custom_output.extend;
422: l_custom_rec.attribute_name := ':TYPE';
423: l_custom_rec.attribute_value := replace(l_type,'''');
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(6) := l_custom_rec;
427:
428: --Bug 5083882 - Start Code
429: x_custom_output.extend;

Line 432: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

428: --Bug 5083882 - Start Code
429: x_custom_output.extend;
430: l_custom_rec.attribute_name := ':PERIODAND'; --Bug 5083652
431: l_custom_rec.attribute_value := replace(l_period_bitand,'''');
432: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
433: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
434: x_custom_output(7) := l_custom_rec;
435: --Bug 5083882 - End Code
436:

Line 433: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

429: x_custom_output.extend;
430: l_custom_rec.attribute_name := ':PERIODAND'; --Bug 5083652
431: l_custom_rec.attribute_value := replace(l_period_bitand,'''');
432: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
433: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
434: x_custom_output(7) := l_custom_rec;
435: --Bug 5083882 - End Code
436:
437: --Bug 5083652 -- Start Code

Line 441: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

437: --Bug 5083652 -- Start Code
438: x_custom_output.extend;
439: l_custom_rec.attribute_name := ':PERIODTYPE';
440: l_custom_rec.attribute_value := REPLACE(l_period_type,'''');
441: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
442: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
443: x_custom_output(8) := l_custom_rec;
444:
445: x_custom_output.extend;

Line 442: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

438: x_custom_output.extend;
439: l_custom_rec.attribute_name := ':PERIODTYPE';
440: l_custom_rec.attribute_value := REPLACE(l_period_type,'''');
441: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
442: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
443: x_custom_output(8) := l_custom_rec;
444:
445: x_custom_output.extend;
446: l_custom_rec.attribute_name := ':COMPARETYPE';

Line 448: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

444:
445: x_custom_output.extend;
446: l_custom_rec.attribute_name := ':COMPARETYPE';
447: l_custom_rec.attribute_value := REPLACE(l_comp_type,'''');
448: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
449: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
450: x_custom_output(9) := l_custom_rec;
451:
452: x_custom_output.extend;

Line 449: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;

445: x_custom_output.extend;
446: l_custom_rec.attribute_name := ':COMPARETYPE';
447: l_custom_rec.attribute_value := REPLACE(l_comp_type,'''');
448: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
449: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
450: x_custom_output(9) := l_custom_rec;
451:
452: x_custom_output.extend;
453: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';

Line 455: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;

451:
452: x_custom_output.extend;
453: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
454: l_custom_rec.attribute_value := REPLACE(l_cur_period,'''');
455: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
456: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
457: x_custom_output(10) := l_custom_rec;
458: --Bug 5083652 -- End Code
459:

Line 456: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;

452: x_custom_output.extend;
453: l_custom_rec.attribute_name := ':CUR_PERIOD_ID';
454: l_custom_rec.attribute_value := REPLACE(l_cur_period,'''');
455: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
456: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
457: x_custom_output(10) := l_custom_rec;
458: --Bug 5083652 -- End Code
459:
460: