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;
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;
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;
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;
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:
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
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
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:
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);
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
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
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;
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;
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;
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();
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();
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
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
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;
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;
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
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
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;
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;
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();
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
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
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
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