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_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 646: , x_measure_set_codes_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE

642:
643: PROCEDURE Get_Measure_Attributes
644: (
645: p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
646: , x_measure_set_codes_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
647: , x_timeslices_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
648: , x_measure_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
649: , x_return_status OUT NOCOPY VARCHAR2
650: , x_msg_count OUT NOCOPY NUMBER

Line 647: , x_timeslices_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE

643: PROCEDURE Get_Measure_Attributes
644: (
645: p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
646: , x_measure_set_codes_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
647: , x_timeslices_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
648: , x_measure_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
649: , x_return_status OUT NOCOPY VARCHAR2
650: , x_msg_count OUT NOCOPY NUMBER
651: , x_msg_data OUT NOCOPY VARCHAR2 -- not used

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

662: x_msg_count := 0;
663: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
664: END IF;
665:
666: x_measure_set_codes_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
667: x_timeslices_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
668: x_measure_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
669:
670:

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

663: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
664: END IF;
665:
666: x_measure_set_codes_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
667: x_timeslices_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
668: x_measure_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
669:
670:
671: x_measure_set_codes_tbl.extend(p_measure_codes_tbl.LAST);

Line 735: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL

731: PROCEDURE Get_Financial_Measures
732: (
733: p_project_id NUMBER
734: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
735: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
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

Line 736: , p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL

732: (
733: p_project_id NUMBER
734: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
735: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
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

Line 753: l_measure_set_codes_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

749: l_Msg_Data VARCHAR2(255);
750: l_DaysSinceITD NUMBER;
751: l_DaysInPeriod NUMBER;
752: i NUMBER;
753: l_measure_set_codes_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
754: l_timeslices_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
755: l_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
756: l_ptd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
757: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 754: l_timeslices_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

750: l_DaysSinceITD NUMBER;
751: l_DaysInPeriod NUMBER;
752: i NUMBER;
753: l_measure_set_codes_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
754: l_timeslices_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
755: l_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
756: l_ptd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
757: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
758: l_ytd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 755: l_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

751: l_DaysInPeriod NUMBER;
752: i NUMBER;
753: l_measure_set_codes_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
754: l_timeslices_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
755: l_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
756: l_ptd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
757: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
758: l_ytd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
759: l_itd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

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

837: x_msg_count := 0;
838: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
839:
840:
841: l_measure_set_codes_tbl := SYSTEM.PA_VARCHAR2_30_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();

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

838: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
839:
840:
841: l_measure_set_codes_tbl := SYSTEM.PA_VARCHAR2_30_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();

Line 1075: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL

1071: PROCEDURE Get_Activity_Measures
1072: (
1073: p_project_id NUMBER
1074: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1075: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
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

Line 1076: , p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL

1072: (
1073: p_project_id NUMBER
1074: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1075: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
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

Line 1461: x_measure_set_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

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

Line 1463: x_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

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

Line 1684: , p_measure_set_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE

1680: , pTimeSlice NUMBER
1681: , pPrgRollup VARCHAR2
1682: , pReportType VARCHAR2
1683: , pPeriodName VARCHAR2
1684: , p_measure_set_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1685: , p_raw_text_flag VARCHAR2 DEFAULT 'Y'
1686: , pWBSRollupFlag VARCHAR2 DEFAULT 'Y'
1687: , pRBSRollupFlag VARCHAR2 DEFAULT 'Y'
1688: , pCallingType VARCHAR2

Line 1691: , x_measure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE

1687: , pRBSRollupFlag VARCHAR2 DEFAULT 'Y'
1688: , pCallingType VARCHAR2
1689: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
1690: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1691: , x_measure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1692: , x_ptd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1693: , x_qtd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1694: , x_ytd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1695: , x_itd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 1787: l_fp_cus_meas_formats SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

1783: l_ac_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1784: l_ac_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1785: l_ac_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1786: l_ac_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1787: l_fp_cus_meas_formats SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1788: l_ac_cus_meas_formats SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1789: l_fp_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1790: l_fp_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1791: l_fp_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1788: l_ac_cus_meas_formats SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

1784: l_ac_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1785: l_ac_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1786: l_ac_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1787: l_fp_cus_meas_formats SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1788: l_ac_cus_meas_formats SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1789: l_fp_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1790: l_fp_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1791: l_fp_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1792: l_fp_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

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

3421:
3422: --
3423: -- initialize all the remaining output collections
3424: --
3425: x_measure_type:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3426: x_ptd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3427: x_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3428: x_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3429: x_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

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

4122: l_ac_custom_measures_ac(i+15) := l_ac_calc_custom_measures_ac(i);
4123: l_ac_custom_measures_prp(i+15) := l_ac_calc_custom_measures_prp(i);
4124: END LOOP;
4125:
4126: l_fp_cus_meas_formats := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
4127: l_ac_cus_meas_formats := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
4128: BEGIN
4129: SELECT measure_format
4130: BULK COLLECT INTO l_fp_cus_meas_formats

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

4123: l_ac_custom_measures_prp(i+15) := l_ac_calc_custom_measures_prp(i);
4124: END LOOP;
4125:
4126: l_fp_cus_meas_formats := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
4127: l_ac_cus_meas_formats := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
4128: BEGIN
4129: SELECT measure_format
4130: BULK COLLECT INTO l_fp_cus_meas_formats
4131: FROM pji_mt_measure_sets_b