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.PJI_REP_MEASURE_UTIL dependencies on PA_VARCHAR2_240_TBL_TYPE

Line 586: , p_measure_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE

582:
583: PROCEDURE Get_Measure_Labels
584: (
585: p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
586: , p_measure_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE
587: , x_return_status OUT NOCOPY VARCHAR2
588: , x_msg_count OUT NOCOPY NUMBER
589: , x_msg_data OUT NOCOPY VARCHAR2
590: ) IS

Line 592: l_measure_labels_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE;

588: , x_msg_count OUT NOCOPY NUMBER
589: , x_msg_data OUT NOCOPY VARCHAR2
590: ) IS
591:
592: l_measure_labels_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE;
593: l_sql_errm VARCHAR2(255);
594:
595: BEGIN
596: l_measure_labels_tbl := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

Line 596: l_measure_labels_tbl := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

592: l_measure_labels_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE;
593: l_sql_errm VARCHAR2(255);
594:
595: BEGIN
596: l_measure_labels_tbl := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
597: --
598: -- Check if the array needs processing.
599: --
600: IF p_measure_codes_tbl.COUNT > 0 THEN

Line 740: --, x_exception_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE

736: , p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
737: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
738: , x_measure_values_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
739: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
740: --, x_exception_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE
741: , x_return_status OUT NOCOPY VARCHAR2
742: , x_msg_count OUT NOCOPY NUMBER
743: , x_msg_data OUT NOCOPY VARCHAR2 -- not used
744: )

Line 846: --x_exception_labels_tbl := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

842: l_timeslices_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
843: x_measure_values_tbl := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
844: x_exception_indicator_tbl := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
845: l_measure_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
846: --x_exception_labels_tbl := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
847:
848: IF p_measure_codes_tbl.LAST < 1 THEN
849: x_measure_values_tbl := NULL;
850: x_exception_indicator_tbl := NULL;

Line 1080: --, x_exception_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE

1076: , p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
1077: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
1078: , x_measure_values_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1079: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1080: --, x_exception_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE
1081: , x_return_status OUT NOCOPY VARCHAR2
1082: , x_msg_count OUT NOCOPY NUMBER
1083: , x_msg_data OUT NOCOPY VARCHAR2
1084: ) IS

Line 1462: x_measure_name SYSTEM.PA_VARCHAR2_240_TBL_TYPE;

1458: , x_msg_data OUT NOCOPY VARCHAR2
1459: ) AS
1460:
1461: x_measure_set_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1462: x_measure_name SYSTEM.PA_VARCHAR2_240_TBL_TYPE;
1463: x_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1464: x_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1465: x_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1466: x_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;