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_COA_PKG dependencies on BIS_PMV_PARAMETERS_PUB

Line 60: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

56: l_inner_group_by VARCHAR2(4000);
57:
58: BEGIN
59:
60: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
61: x_custom_output := bis_query_attributes_tbl();
62:
63: ENI_DBI_UTIL_PKG.get_parameters( p_page_parameter_tbl
64: , l_period_type

Line 442: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;

438: order by
439: ' || l_order_by ;
440:
441:
442: l_custom_rec := BIS_PMV_PARAMETERS_PUB.Initialize_Query_Type;
443: x_custom_output := bis_query_attributes_tbl();
444:
445:
446:

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

446:
447: x_custom_output.extend;
448: l_custom_rec.attribute_name := ':ITEM';
449: l_custom_rec.attribute_value := l_item;
450: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
451: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
452: x_custom_output(1) := l_custom_rec;
453:
454:

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

447: x_custom_output.extend;
448: l_custom_rec.attribute_name := ':ITEM';
449: l_custom_rec.attribute_value := l_item;
450: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
451: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
452: x_custom_output(1) := l_custom_rec;
453:
454:
455: x_custom_output.extend;

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

454:
455: x_custom_output.extend;
456: l_custom_rec.attribute_name := ':ORG';
457: l_custom_rec.attribute_value := replace(l_org,'''');
458: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
459: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
460: x_custom_output(2) := l_custom_rec;
461:
462: x_custom_output.extend;

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

455: x_custom_output.extend;
456: l_custom_rec.attribute_name := ':ORG';
457: l_custom_rec.attribute_value := replace(l_org,'''');
458: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
459: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
460: x_custom_output(2) := l_custom_rec;
461:
462: x_custom_output.extend;
463: l_custom_rec.attribute_name := ':REASON';

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

461:
462: x_custom_output.extend;
463: l_custom_rec.attribute_name := ':REASON';
464: l_custom_rec.attribute_value := l_reason;
465: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
466: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
467: x_custom_output(3) := l_custom_rec;
468:
469: x_custom_output.extend;

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

462: x_custom_output.extend;
463: l_custom_rec.attribute_name := ':REASON';
464: l_custom_rec.attribute_value := l_reason;
465: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
466: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
467: x_custom_output(3) := l_custom_rec;
468:
469: x_custom_output.extend;
470: l_custom_rec.attribute_name := ':PRIORITY';

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

468:
469: x_custom_output.extend;
470: l_custom_rec.attribute_name := ':PRIORITY';
471: l_custom_rec.attribute_value := l_priority;
472: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
473: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
474: x_custom_output(4) := l_custom_rec;
475:
476: x_custom_output.extend;

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

469: x_custom_output.extend;
470: l_custom_rec.attribute_name := ':PRIORITY';
471: l_custom_rec.attribute_value := l_priority;
472: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
473: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.VARCHAR2_BIND;
474: x_custom_output(4) := l_custom_rec;
475:
476: x_custom_output.extend;
477: l_custom_rec.attribute_name := ':STATUS';

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

475:
476: x_custom_output.extend;
477: l_custom_rec.attribute_name := ':STATUS';
478: l_custom_rec.attribute_value := replace(l_status,'''');
479: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
480: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
481: x_custom_output(5) := l_custom_rec;
482:
483: x_custom_output.extend;

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

476: x_custom_output.extend;
477: l_custom_rec.attribute_name := ':STATUS';
478: l_custom_rec.attribute_value := replace(l_status,'''');
479: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
480: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
481: x_custom_output(5) := l_custom_rec;
482:
483: x_custom_output.extend;
484: l_custom_rec.attribute_name := ':TYPE';

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

482:
483: x_custom_output.extend;
484: l_custom_rec.attribute_name := ':TYPE';
485: l_custom_rec.attribute_value := replace(l_type,'''');
486: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
487: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
488: x_custom_output(6) := l_custom_rec;
489:
490:

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

483: x_custom_output.extend;
484: l_custom_rec.attribute_name := ':TYPE';
485: l_custom_rec.attribute_value := replace(l_type,'''');
486: l_custom_rec.attribute_type := BIS_PMV_PARAMETERS_PUB.BIND_TYPE;
487: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
488: x_custom_output(6) := l_custom_rec;
489:
490:
491: --l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

Line 491: --l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;

487: l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.INTEGER_BIND;
488: x_custom_output(6) := l_custom_rec;
489:
490:
491: --l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
492: --l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
493:
494:
495:

Line 492: --l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;

488: x_custom_output(6) := l_custom_rec;
489:
490:
491: --l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.NUMERIC_BIND;
492: --l_custom_rec.attribute_data_type := BIS_PMV_PARAMETERS_PUB.DATE_BIND;
493:
494:
495:
496: END GET_SQL;