DBA Data[Home] [Help]

APPS.PJI_REP_MEASURE_UTIL dependencies on PA_VARCHAR2_30_TBL_TYPE

Line 135: l_measure_set_codes_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

131: l_currency_type_msg_name VARCHAR2(255);
132: l_Return_Status VARCHAR2(255);
133: l_Msg_Count NUMBER;
134: l_Msg_Data VARCHAR2(255);
135: l_measure_set_codes_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
136: l_xtd_types_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
137: l_measure_set_types SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
138: l_ptd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
139: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 136: l_xtd_types_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

132: l_Return_Status VARCHAR2(255);
133: l_Msg_Count NUMBER;
134: l_Msg_Data VARCHAR2(255);
135: l_measure_set_codes_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
136: l_xtd_types_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
137: l_measure_set_types SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
138: l_ptd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
139: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
140: l_ytd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 137: l_measure_set_types SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

133: l_Msg_Count NUMBER;
134: l_Msg_Data VARCHAR2(255);
135: l_measure_set_codes_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
136: l_xtd_types_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
137: l_measure_set_types SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
138: l_ptd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
139: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
140: l_ytd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
141: l_itd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 152: l_calendar_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

148: l_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
149: l_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
150:
151: l_project_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
152: l_calendar_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
153: l_currency_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
154: l_rowids_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
155: l_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
156: l_measure_values_tbl SYSTEM.PA_NUM_TBL_TYPE;

Line 153: l_currency_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

149: l_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
150:
151: l_project_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
152: l_calendar_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
153: l_currency_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
154: l_rowids_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
155: l_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
156: l_measure_values_tbl SYSTEM.PA_NUM_TBL_TYPE;
157:

Line 653: , x_measure_set_codes_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE

649:
650: PROCEDURE Get_Measure_Attributes
651: (
652: p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
653: , x_measure_set_codes_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
654: , x_timeslices_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
655: , x_measure_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
656: , x_return_status OUT NOCOPY VARCHAR2
657: , x_msg_count OUT NOCOPY NUMBER

Line 654: , x_timeslices_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE

650: PROCEDURE Get_Measure_Attributes
651: (
652: p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
653: , x_measure_set_codes_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
654: , x_timeslices_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
655: , x_measure_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
656: , x_return_status OUT NOCOPY VARCHAR2
657: , x_msg_count OUT NOCOPY NUMBER
658: , x_msg_data OUT NOCOPY VARCHAR2 -- not used

Line 673: x_measure_set_codes_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

669: x_msg_count := 0;
670: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
671: END IF;
672:
673: x_measure_set_codes_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
674: x_timeslices_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
675: x_measure_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
676:
677:

Line 674: x_timeslices_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

670: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
671: END IF;
672:
673: x_measure_set_codes_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
674: x_timeslices_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
675: x_measure_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
676:
677:
678: x_measure_set_codes_tbl.extend(p_measure_codes_tbl.LAST);

Line 742: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL

738: PROCEDURE Get_Financial_Measures
739: (
740: p_project_id NUMBER
741: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
742: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
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

Line 743: , p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL

739: (
740: p_project_id NUMBER
741: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
742: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
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

Line 760: l_measure_set_codes_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

756: l_Msg_Data VARCHAR2(255);
757: l_DaysSinceITD NUMBER;
758: l_DaysInPeriod NUMBER;
759: i NUMBER;
760: l_measure_set_codes_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
761: l_timeslices_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
762: l_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
763: l_ptd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
764: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 761: l_timeslices_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

757: l_DaysSinceITD NUMBER;
758: l_DaysInPeriod NUMBER;
759: i NUMBER;
760: l_measure_set_codes_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
761: l_timeslices_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
762: l_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
763: l_ptd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
764: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
765: l_ytd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 762: l_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

758: l_DaysInPeriod NUMBER;
759: i NUMBER;
760: l_measure_set_codes_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
761: l_timeslices_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
762: l_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
763: l_ptd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
764: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
765: l_ytd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
766: l_itd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 848: l_measure_set_codes_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

844: x_msg_count := 0;
845: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
846:
847:
848: l_measure_set_codes_tbl := SYSTEM.PA_VARCHAR2_30_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();

Line 849: l_timeslices_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

845: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
846:
847:
848: l_measure_set_codes_tbl := SYSTEM.PA_VARCHAR2_30_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();

Line 1082: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL

1078: PROCEDURE Get_Activity_Measures
1079: (
1080: p_project_id NUMBER
1081: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1082: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
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

Line 1083: , p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL

1079: (
1080: p_project_id NUMBER
1081: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1082: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
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

Line 1468: x_measure_set_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

1464: , x_msg_count OUT NOCOPY NUMBER
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;

Line 1470: x_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

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;
1474: x_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1691: , p_measure_set_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

1687: , pTimeSlice NUMBER
1688: , pPrgRollup VARCHAR2
1689: , pReportType VARCHAR2
1690: , pPeriodName VARCHAR2
1691: , p_measure_set_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1692: , p_raw_text_flag VARCHAR2 DEFAULT 'Y'
1693: , pWBSRollupFlag VARCHAR2 DEFAULT 'Y'
1694: , pRBSRollupFlag VARCHAR2 DEFAULT 'Y'
1695: , pCallingType VARCHAR2

Line 1698: , x_measure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE

1694: , pRBSRollupFlag VARCHAR2 DEFAULT 'Y'
1695: , pCallingType VARCHAR2
1696: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
1697: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1698: , x_measure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1699: , x_ptd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1700: , x_qtd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1701: , x_ytd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1702: , x_itd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 1794: l_fp_cus_meas_formats SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

1790: l_ac_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1791: l_ac_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1792: l_ac_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1793: l_ac_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1794: l_fp_cus_meas_formats SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1795: l_ac_cus_meas_formats SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1796: l_fp_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1797: l_fp_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1798: l_fp_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1795: l_ac_cus_meas_formats SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

1791: l_ac_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1792: l_ac_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1793: l_ac_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1794: l_fp_cus_meas_formats SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1795: l_ac_cus_meas_formats SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1796: l_fp_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1797: l_fp_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1798: l_fp_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1799: l_fp_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 3432: x_measure_type:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

3428:
3429: --
3430: -- initialize all the remaining output collections
3431: --
3432: x_measure_type:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3433: x_ptd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3434: x_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3435: x_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3436: x_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

Line 4145: l_fp_cus_meas_formats := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

4141: l_ac_custom_measures_ac(i+15) := l_ac_calc_custom_measures_ac(i);
4142: l_ac_custom_measures_prp(i+15) := l_ac_calc_custom_measures_prp(i);
4143: END LOOP;
4144:
4145: l_fp_cus_meas_formats := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
4146: l_ac_cus_meas_formats := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
4147: BEGIN
4148: SELECT measure_format
4149: BULK COLLECT INTO l_fp_cus_meas_formats

Line 4146: l_ac_cus_meas_formats := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();

4142: l_ac_custom_measures_prp(i+15) := l_ac_calc_custom_measures_prp(i);
4143: END LOOP;
4144:
4145: l_fp_cus_meas_formats := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
4146: l_ac_cus_meas_formats := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
4147: BEGIN
4148: SELECT measure_format
4149: BULK COLLECT INTO l_fp_cus_meas_formats
4150: FROM pji_mt_measure_sets_b

Line 10014: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL

10010: PROCEDURE Get_Financial_Measures_wrp
10011: (
10012: p_project_id_tbl IN SYSTEM.pa_num_tbl_type
10013: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
10014: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
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

Line 10015: , p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL

10011: (
10012: p_project_id_tbl IN SYSTEM.pa_num_tbl_type
10013: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
10014: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
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