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 593: , p_measure_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE

589:
590: PROCEDURE Get_Measure_Labels
591: (
592: p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
593: , p_measure_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE
594: , x_return_status OUT NOCOPY VARCHAR2
595: , x_msg_count OUT NOCOPY NUMBER
596: , x_msg_data OUT NOCOPY VARCHAR2
597: ) IS

Line 599: l_measure_labels_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE;

595: , x_msg_count OUT NOCOPY NUMBER
596: , x_msg_data OUT NOCOPY VARCHAR2
597: ) IS
598:
599: l_measure_labels_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE;
600: l_sql_errm VARCHAR2(255);
601:
602: BEGIN
603: l_measure_labels_tbl := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();

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

599: l_measure_labels_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE;
600: l_sql_errm VARCHAR2(255);
601:
602: BEGIN
603: l_measure_labels_tbl := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
604: --
605: -- Check if the array needs processing.
606: --
607: IF p_measure_codes_tbl.COUNT > 0 THEN

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

743: , p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
744: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
745: , x_measure_values_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
746: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
747: --, x_exception_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE
748: , x_return_status OUT NOCOPY VARCHAR2
749: , x_msg_count OUT NOCOPY NUMBER
750: , x_msg_data OUT NOCOPY VARCHAR2 -- not used
751: )

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

849: l_timeslices_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
850: x_measure_values_tbl := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
851: x_exception_indicator_tbl := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
852: l_measure_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
853: --x_exception_labels_tbl := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
854:
855: IF p_measure_codes_tbl.LAST < 1 THEN
856: x_measure_values_tbl := NULL;
857: x_exception_indicator_tbl := NULL;

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

1083: , p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
1084: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
1085: , x_measure_values_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1086: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1087: --, x_exception_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE
1088: , x_return_status OUT NOCOPY VARCHAR2
1089: , x_msg_count OUT NOCOPY NUMBER
1090: , x_msg_data OUT NOCOPY VARCHAR2
1091: ) IS

Line 1469: x_measure_name SYSTEM.PA_VARCHAR2_240_TBL_TYPE;

1465: , x_msg_data OUT NOCOPY VARCHAR2
1466: ) AS
1467:
1468: x_measure_set_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1469: x_measure_name SYSTEM.PA_VARCHAR2_240_TBL_TYPE;
1470: x_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1471: x_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1472: x_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1473: x_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

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

10015: , p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
10016: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
10017: , x_measure_values_tbl OUT NOCOPY SYSTEM.PJI_FIN_MEAS_REC_TBL_TYPE
10018: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PJI_EXCP_IND_REC_TBL_TYPE
10019: --, x_exception_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE
10020: , x_return_status OUT NOCOPY VARCHAR2
10021: , x_msg_count OUT NOCOPY NUMBER
10022: , x_msg_data OUT NOCOPY VARCHAR2 -- not used
10023: )

Line 10105: --, x_exception_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE -- remove

10101: , p_timeslices_tbl => p_timeslices_tbl
10102: , p_measure_id_tbl => p_measure_id_tbl
10103: , x_measure_values_tbl => l_measure_values_tbl
10104: , x_exception_indicator_tbl => l_exception_indicator_tbl
10105: --, x_exception_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE -- remove
10106: , x_return_status => x_return_status
10107: , x_msg_count => x_msg_count
10108: , x_msg_data => x_msg_data
10109: