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_NUM_TBL_TYPE

Line 151: l_project_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;

147: l_itd_html SYSTEM.PA_VARCHAR2_2000_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;

Line 155: l_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;

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:
158: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
159: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 156: l_measure_values_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:
158: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
159: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
160: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 158: l_ptd_trans_id SYSTEM.PA_NUM_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:
158: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
159: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
160: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
161: l_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
162: l_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 159: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

155: l_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
156: l_measure_values_tbl SYSTEM.PA_NUM_TBL_TYPE;
157:
158: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
159: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
160: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
161: l_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
162: l_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
163: l_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 160: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

156: l_measure_values_tbl SYSTEM.PA_NUM_TBL_TYPE;
157:
158: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
159: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
160: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
161: l_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
162: l_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
163: l_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
164:

Line 161: l_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

157:
158: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
159: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
160: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
161: l_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
162: l_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
163: l_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
164:
165: l_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 162: l_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;

158: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
159: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
160: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
161: l_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
162: l_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
163: l_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
164:
165: l_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
166: l_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 163: l_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;

159: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
160: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
161: l_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
162: l_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
163: l_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
164:
165: l_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
166: l_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
167: l_qtd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 174: l_plan_version_ids SYSTEM.PA_NUM_TBL_TYPE;

170: l_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
171:
172:
173: l_exception_indicator_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
174: l_plan_version_ids SYSTEM.PA_NUM_TBL_TYPE;
175: l_i NUMBER;
176: x NUMBER;
177:
178: l_slice_name VARCHAR2(30);

Line 393: l_plan_version_ids := SYSTEM.PA_NUM_TBL_TYPE(

389: l_prg_rollup := 'N';--Pji_Rep_Util.Derive_Prg_Rollup_Flag(l_project_ids_tbl(i));
390:
391:
392:
393: l_plan_version_ids := SYSTEM.PA_NUM_TBL_TYPE(
394: l_actual_version_id
395: , l_cstforecast_version_id
396: , l_cstbudget_version_id
397: , l_cstbudget2_version_id

Line 655: , x_measure_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

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
659: )

Line 675: x_measure_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();

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);
679: x_timeslices_tbl.extend(p_measure_codes_tbl.LAST);

Line 744: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL

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
748: , x_return_status OUT NOCOPY VARCHAR2

Line 775: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

771: l_ytd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
772: l_itd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
773: l_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
774: l_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
775: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
776: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
777: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
778: l_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
779: l_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 776: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

772: l_itd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
773: l_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
774: l_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
775: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
776: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
777: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
778: l_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
779: l_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
780: l_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 777: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

773: l_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
774: l_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
775: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
776: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
777: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
778: l_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
779: l_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
780: l_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
781: l_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 778: l_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

774: l_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
775: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
776: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
777: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
778: l_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
779: l_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
780: l_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
781: l_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
782: l_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 779: l_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;

775: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
776: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
777: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
778: l_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
779: l_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
780: l_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
781: l_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
782: l_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
783: l_qtd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 780: l_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;

776: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
777: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
778: l_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
779: l_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
780: l_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
781: l_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
782: l_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
783: l_qtd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
784: l_itd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 832: l_plan_version_ids SYSTEM.PA_NUM_TBL_TYPE;

828: l_tmp_xtd_type VARCHAR2(255);
829: l_effective_i NUMBER;
830: l_slice_name VARCHAR2(80);
831:
832: l_plan_version_ids SYSTEM.PA_NUM_TBL_TYPE;
833: l_i NUMBER;
834:
835: -- Add by Ning, besides passing the measure_set_code, also pass the measure_ids
836: l_measure_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

Line 836: l_measure_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

832: l_plan_version_ids SYSTEM.PA_NUM_TBL_TYPE;
833: l_i NUMBER;
834:
835: -- Add by Ning, besides passing the measure_set_code, also pass the measure_ids
836: l_measure_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
837: BEGIN
838: NULL;
839:
840: IF g_debug_mode = 'Y' THEN

Line 852: l_measure_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();

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();
854:
855: IF p_measure_codes_tbl.LAST < 1 THEN
856: x_measure_values_tbl := NULL;

Line 951: l_plan_version_ids := SYSTEM.PA_NUM_TBL_TYPE(

947: --bug 4355820, only compute project amount for project list
948: l_prg_rollup := 'N'; --Pji_Rep_Util.Derive_Prg_Rollup_Flag(p_project_id);
949:
950:
951: l_plan_version_ids := SYSTEM.PA_NUM_TBL_TYPE(
952: l_actual_version_id
953: , l_cstforecast_version_id
954: , l_cstbudget_version_id
955: , l_cstbudget2_version_id

Line 1084: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL

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
1088: , x_return_status OUT NOCOPY VARCHAR2

Line 1483: x_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

1479: x_ytd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1480: x_itd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1481: x_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1482: x_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1483: x_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1484: x_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1485: x_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1486: x_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1487: x_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 1484: x_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

1480: x_itd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1481: x_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1482: x_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1483: x_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1484: x_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1485: x_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1486: x_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1487: x_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1488: x_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 1485: x_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

1481: x_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1482: x_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1483: x_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1484: x_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1485: x_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1486: x_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1487: x_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1488: x_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1489: x_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1486: x_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

1482: x_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1483: x_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1484: x_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1485: x_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1486: x_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1487: x_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1488: x_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1489: x_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1490: x_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1487: x_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;

1483: x_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1484: x_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1485: x_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1486: x_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1487: x_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1488: x_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1489: x_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1490: x_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1491: x_qtd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1488: x_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;

1484: x_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1485: x_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1486: x_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1487: x_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1488: x_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1489: x_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1490: x_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1491: x_qtd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1492: x_itd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1696: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL

1692: , p_raw_text_flag VARCHAR2 DEFAULT 'Y'
1693: , pWBSRollupFlag VARCHAR2 DEFAULT 'Y'
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

Line 1711: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

1707: , x_ytd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1708: , x_itd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1709: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1710: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1711: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1712: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1713: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1714: , x_itd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1715: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 1712: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

1708: , x_itd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1709: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1710: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1711: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1712: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1713: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1714: , x_itd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1715: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1716: , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 1713: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

1709: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1710: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1711: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1712: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1713: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1714: , x_itd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1715: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1716: , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1717: , x_ptd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 1714: , x_itd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

1710: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1711: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1712: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1713: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1714: , x_itd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1715: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1716: , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1717: , x_ptd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1718: , x_ytd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 1715: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

1711: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1712: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1713: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1714: , x_itd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1715: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1716: , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1717: , x_ptd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1718: , x_ytd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1719: , x_qtd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 1716: , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

1712: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1713: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1714: , x_itd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1715: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1716: , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1717: , x_ptd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1718: , x_ytd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1719: , x_qtd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1720: , x_itd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 1757: ptd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;

1753: l_orig_rev_budget2_index NUMBER;
1754: l_prior_cost_forecast_index NUMBER;
1755: l_prior_rev_forecast_index NUMBER;
1756: l_check_plan_versions NUMBER;
1757: ptd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1758: qtd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1759: ytd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1760: itd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1761: ac_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;

Line 1758: qtd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;

1754: l_prior_cost_forecast_index NUMBER;
1755: l_prior_rev_forecast_index NUMBER;
1756: l_check_plan_versions NUMBER;
1757: ptd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1758: qtd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1759: ytd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1760: itd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1761: ac_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1762: prp_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;

Line 1759: ytd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;

1755: l_prior_rev_forecast_index NUMBER;
1756: l_check_plan_versions NUMBER;
1757: ptd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1758: qtd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1759: ytd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1760: itd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1761: ac_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1762: prp_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1763: l_seeded_measures SYSTEM.PA_Num_Tbl_Type;

Line 1760: itd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;

1756: l_check_plan_versions NUMBER;
1757: ptd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1758: qtd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1759: ytd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1760: itd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1761: ac_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1762: prp_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1763: l_seeded_measures SYSTEM.PA_Num_Tbl_Type;
1764: l_seeded_measures_ptd SYSTEM.PA_Num_Tbl_Type;

Line 1761: ac_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;

1757: ptd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1758: qtd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1759: ytd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1760: itd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1761: ac_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1762: prp_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1763: l_seeded_measures SYSTEM.PA_Num_Tbl_Type;
1764: l_seeded_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1765: l_seeded_measures_qtd SYSTEM.PA_Num_Tbl_Type;

Line 1762: prp_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;

1758: qtd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1759: ytd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1760: itd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1761: ac_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1762: prp_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1763: l_seeded_measures SYSTEM.PA_Num_Tbl_Type;
1764: l_seeded_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1765: l_seeded_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1766: l_seeded_measures_ytd SYSTEM.PA_Num_Tbl_Type;

Line 1763: l_seeded_measures SYSTEM.PA_Num_Tbl_Type;

1759: ytd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1760: itd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1761: ac_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1762: prp_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1763: l_seeded_measures SYSTEM.PA_Num_Tbl_Type;
1764: l_seeded_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1765: l_seeded_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1766: l_seeded_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1767: l_seeded_measures_itd SYSTEM.PA_Num_Tbl_Type;

Line 1764: l_seeded_measures_ptd SYSTEM.PA_Num_Tbl_Type;

1760: itd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1761: ac_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1762: prp_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1763: l_seeded_measures SYSTEM.PA_Num_Tbl_Type;
1764: l_seeded_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1765: l_seeded_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1766: l_seeded_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1767: l_seeded_measures_itd SYSTEM.PA_Num_Tbl_Type;
1768: l_seeded_measures_ac SYSTEM.PA_Num_Tbl_Type;

Line 1765: l_seeded_measures_qtd SYSTEM.PA_Num_Tbl_Type;

1761: ac_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1762: prp_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1763: l_seeded_measures SYSTEM.PA_Num_Tbl_Type;
1764: l_seeded_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1765: l_seeded_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1766: l_seeded_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1767: l_seeded_measures_itd SYSTEM.PA_Num_Tbl_Type;
1768: l_seeded_measures_ac SYSTEM.PA_Num_Tbl_Type;
1769: l_seeded_measures_prp SYSTEM.PA_Num_Tbl_Type;

Line 1766: l_seeded_measures_ytd SYSTEM.PA_Num_Tbl_Type;

1762: prp_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1763: l_seeded_measures SYSTEM.PA_Num_Tbl_Type;
1764: l_seeded_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1765: l_seeded_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1766: l_seeded_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1767: l_seeded_measures_itd SYSTEM.PA_Num_Tbl_Type;
1768: l_seeded_measures_ac SYSTEM.PA_Num_Tbl_Type;
1769: l_seeded_measures_prp SYSTEM.PA_Num_Tbl_Type;
1770: l_fp_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;

Line 1767: l_seeded_measures_itd SYSTEM.PA_Num_Tbl_Type;

1763: l_seeded_measures SYSTEM.PA_Num_Tbl_Type;
1764: l_seeded_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1765: l_seeded_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1766: l_seeded_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1767: l_seeded_measures_itd SYSTEM.PA_Num_Tbl_Type;
1768: l_seeded_measures_ac SYSTEM.PA_Num_Tbl_Type;
1769: l_seeded_measures_prp SYSTEM.PA_Num_Tbl_Type;
1770: l_fp_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1771: l_fp_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;

Line 1768: l_seeded_measures_ac SYSTEM.PA_Num_Tbl_Type;

1764: l_seeded_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1765: l_seeded_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1766: l_seeded_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1767: l_seeded_measures_itd SYSTEM.PA_Num_Tbl_Type;
1768: l_seeded_measures_ac SYSTEM.PA_Num_Tbl_Type;
1769: l_seeded_measures_prp SYSTEM.PA_Num_Tbl_Type;
1770: l_fp_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1771: l_fp_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1772: l_fp_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;

Line 1769: l_seeded_measures_prp SYSTEM.PA_Num_Tbl_Type;

1765: l_seeded_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1766: l_seeded_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1767: l_seeded_measures_itd SYSTEM.PA_Num_Tbl_Type;
1768: l_seeded_measures_ac SYSTEM.PA_Num_Tbl_Type;
1769: l_seeded_measures_prp SYSTEM.PA_Num_Tbl_Type;
1770: l_fp_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1771: l_fp_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1772: l_fp_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1773: l_fp_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;

Line 1770: l_fp_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;

1766: l_seeded_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1767: l_seeded_measures_itd SYSTEM.PA_Num_Tbl_Type;
1768: l_seeded_measures_ac SYSTEM.PA_Num_Tbl_Type;
1769: l_seeded_measures_prp SYSTEM.PA_Num_Tbl_Type;
1770: l_fp_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1771: l_fp_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1772: l_fp_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1773: l_fp_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1774: l_fp_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;

Line 1771: l_fp_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;

1767: l_seeded_measures_itd SYSTEM.PA_Num_Tbl_Type;
1768: l_seeded_measures_ac SYSTEM.PA_Num_Tbl_Type;
1769: l_seeded_measures_prp SYSTEM.PA_Num_Tbl_Type;
1770: l_fp_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1771: l_fp_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1772: l_fp_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1773: l_fp_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1774: l_fp_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1775: l_fp_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;

Line 1772: l_fp_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;

1768: l_seeded_measures_ac SYSTEM.PA_Num_Tbl_Type;
1769: l_seeded_measures_prp SYSTEM.PA_Num_Tbl_Type;
1770: l_fp_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1771: l_fp_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1772: l_fp_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1773: l_fp_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1774: l_fp_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1775: l_fp_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1776: l_ac_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;

Line 1773: l_fp_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;

1769: l_seeded_measures_prp SYSTEM.PA_Num_Tbl_Type;
1770: l_fp_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1771: l_fp_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1772: l_fp_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1773: l_fp_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1774: l_fp_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1775: l_fp_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1776: l_ac_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1777: l_ac_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;

Line 1774: l_fp_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;

1770: l_fp_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1771: l_fp_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1772: l_fp_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1773: l_fp_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1774: l_fp_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1775: l_fp_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1776: l_ac_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1777: l_ac_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1778: l_ac_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;

Line 1775: l_fp_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;

1771: l_fp_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1772: l_fp_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1773: l_fp_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1774: l_fp_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1775: l_fp_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1776: l_ac_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1777: l_ac_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1778: l_ac_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1779: l_ac_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;

Line 1776: l_ac_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;

1772: l_fp_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1773: l_fp_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1774: l_fp_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1775: l_fp_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1776: l_ac_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1777: l_ac_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1778: l_ac_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1779: l_ac_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1780: l_ac_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;

Line 1777: l_ac_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;

1773: l_fp_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1774: l_fp_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1775: l_fp_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1776: l_ac_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1777: l_ac_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1778: l_ac_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1779: l_ac_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1780: l_ac_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1781: l_ac_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;

Line 1778: l_ac_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;

1774: l_fp_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1775: l_fp_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1776: l_ac_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1777: l_ac_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1778: l_ac_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1779: l_ac_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1780: l_ac_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1781: l_ac_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1782: l_fp_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;

Line 1779: l_ac_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;

1775: l_fp_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1776: l_ac_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1777: l_ac_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1778: l_ac_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1779: l_ac_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1780: l_ac_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1781: l_ac_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1782: l_fp_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1783: l_fp_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;

Line 1780: l_ac_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;

1776: l_ac_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1777: l_ac_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1778: l_ac_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1779: l_ac_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1780: l_ac_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1781: l_ac_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1782: l_fp_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1783: l_fp_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1784: l_fp_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;

Line 1781: l_ac_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;

1777: l_ac_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1778: l_ac_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1779: l_ac_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1780: l_ac_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1781: l_ac_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1782: l_fp_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1783: l_fp_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1784: l_fp_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1785: l_fp_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;

Line 1782: l_fp_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;

1778: l_ac_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1779: l_ac_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1780: l_ac_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1781: l_ac_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1782: l_fp_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1783: l_fp_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1784: l_fp_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1785: l_fp_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1786: l_fp_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;

Line 1783: l_fp_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;

1779: l_ac_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1780: l_ac_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1781: l_ac_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1782: l_fp_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1783: l_fp_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1784: l_fp_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1785: l_fp_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1786: l_fp_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1787: l_fp_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;

Line 1784: l_fp_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;

1780: l_ac_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1781: l_ac_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1782: l_fp_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1783: l_fp_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1784: l_fp_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1785: l_fp_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1786: l_fp_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1787: l_fp_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1788: l_ac_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;

Line 1785: l_fp_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;

1781: l_ac_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1782: l_fp_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1783: l_fp_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1784: l_fp_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1785: l_fp_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1786: l_fp_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1787: l_fp_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1788: l_ac_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1789: l_ac_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;

Line 1786: l_fp_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;

1782: l_fp_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1783: l_fp_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1784: l_fp_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1785: l_fp_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1786: l_fp_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1787: l_fp_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1788: l_ac_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1789: l_ac_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1790: l_ac_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;

Line 1787: l_fp_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;

1783: l_fp_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1784: l_fp_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1785: l_fp_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1786: l_fp_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1787: l_fp_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1788: l_ac_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1789: l_ac_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1790: l_ac_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1791: l_ac_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;

Line 1788: l_ac_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;

1784: l_fp_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1785: l_fp_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1786: l_fp_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1787: l_fp_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1788: l_ac_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1789: l_ac_custom_measures_qtd SYSTEM.PA_Num_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;

Line 1789: l_ac_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;

1785: l_fp_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1786: l_fp_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1787: l_fp_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1788: l_ac_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1789: l_ac_custom_measures_qtd SYSTEM.PA_Num_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;

Line 1790: l_ac_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;

1786: l_fp_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1787: l_fp_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1788: l_ac_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1789: l_ac_custom_measures_qtd SYSTEM.PA_Num_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;

Line 1791: l_ac_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;

1787: l_fp_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1788: l_ac_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1789: l_ac_custom_measures_qtd SYSTEM.PA_Num_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;

Line 1792: l_ac_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;

1788: l_ac_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1789: l_ac_custom_measures_qtd SYSTEM.PA_Num_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;

Line 1793: l_ac_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;

1789: l_ac_custom_measures_qtd SYSTEM.PA_Num_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;

Line 3280: ptd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();

3276: --
3277: -- get the HTML code for the color indicators for each PTD measure
3278: --
3279:
3280: ptd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3281: ptd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3282: qtd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3283: qtd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3284: ytd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();

Line 3282: qtd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();

3278: --
3279:
3280: ptd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3281: ptd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3282: qtd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3283: qtd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3284: ytd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3285: ytd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3286: itd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();

Line 3284: ytd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();

3280: ptd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3281: ptd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3282: qtd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3283: qtd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3284: ytd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3285: ytd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3286: itd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3287: itd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3288: ac_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();

Line 3286: itd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();

3282: qtd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3283: qtd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3284: ytd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3285: ytd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3286: itd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3287: itd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3288: ac_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3289: ac_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3290: prp_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();

Line 3288: ac_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();

3284: ytd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3285: ytd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3286: itd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3287: itd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3288: ac_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3289: ac_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3290: prp_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3291: prp_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3292:

Line 3290: prp_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();

3286: itd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3287: itd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3288: ac_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3289: ac_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3290: prp_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3291: prp_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3292:
3293:
3294: --

Line 3373: x_ptd_trans_id := SYSTEM.pa_NUM_TBL_TYPE();

3369:
3370: IF x_ptd_html IS NULL THEN
3371: x_ptd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3372: x_ptd_html.EXTEND(p_measure_set_code.LAST);
3373: x_ptd_trans_id := SYSTEM.pa_NUM_TBL_TYPE();
3374: x_ptd_trans_id.extend(p_measure_set_code.LAST);
3375: x_ptd_meaning := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3376: x_ptd_meaning.extend(p_measure_set_code.LAST);
3377: END IF;

Line 3382: x_qtd_trans_id := SYSTEM.pa_NUM_TBL_TYPE();

3378:
3379: IF x_qtd_html IS NULL THEN
3380: x_qtd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3381: x_qtd_html.EXTEND(p_measure_set_code.LAST);
3382: x_qtd_trans_id := SYSTEM.pa_NUM_TBL_TYPE();
3383: x_qtd_trans_id.extend(p_measure_set_code.LAST);
3384: x_qtd_meaning := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3385: x_qtd_meaning.extend(p_measure_set_code.LAST);
3386: END IF;

Line 3391: x_ytd_trans_id := SYSTEM.pa_NUM_TBL_TYPE();

3387:
3388: IF x_ytd_html IS NULL THEN
3389: x_ytd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3390: x_ytd_html.EXTEND(p_measure_set_code.LAST);
3391: x_ytd_trans_id := SYSTEM.pa_NUM_TBL_TYPE();
3392: x_ytd_trans_id.extend(p_measure_set_code.LAST);
3393: x_ytd_meaning := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3394: x_ytd_meaning.extend(p_measure_set_code.LAST);
3395: END IF;

Line 3400: x_itd_trans_id := SYSTEM.pa_NUM_TBL_TYPE();

3396:
3397: IF x_itd_html IS NULL THEN
3398: x_itd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3399: x_itd_html.EXTEND(p_measure_set_code.LAST);
3400: x_itd_trans_id := SYSTEM.pa_NUM_TBL_TYPE();
3401: x_itd_trans_id.extend(p_measure_set_code.LAST);
3402: x_itd_meaning := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3403: x_itd_meaning.extend(p_measure_set_code.LAST);
3404: END IF;

Line 3409: x_ac_trans_id := SYSTEM.pa_NUM_TBL_TYPE();

3405:
3406: IF x_ac_html IS NULL THEN
3407: x_ac_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3408: x_ac_html.EXTEND(p_measure_set_code.LAST);
3409: x_ac_trans_id := SYSTEM.pa_NUM_TBL_TYPE();
3410: x_ac_trans_id.extend(p_measure_set_code.LAST);
3411: x_ac_meaning := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3412: x_ac_meaning.extend(p_measure_set_code.LAST);
3413: END IF;

Line 3418: x_prp_trans_id := SYSTEM.pa_NUM_TBL_TYPE();

3414:
3415: IF x_prp_html IS NULL THEN
3416: x_prp_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3417: x_prp_html.EXTEND(p_measure_set_code.LAST);
3418: x_prp_trans_id := SYSTEM.pa_NUM_TBL_TYPE();
3419: x_prp_trans_id.extend(p_measure_set_code.LAST);
3420: x_prp_meaning := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3421: x_prp_meaning.extend(p_measure_set_code.LAST);
3422: END IF;

Line 3476: l_seeded_measures := SYSTEM.PA_Num_Tbl_Type();

3472: --
3473: -- initialize custom measures arrays
3474: --
3475:
3476: l_seeded_measures := SYSTEM.PA_Num_Tbl_Type();
3477:
3478: l_fp_custom_measures_ptd := SYSTEM.PA_NUM_TBL_TYPE(
3479: l_overview_type(l_actual_index).ptd_custom_1,
3480: l_overview_type(l_actual_index).ptd_custom_2,

Line 3478: l_fp_custom_measures_ptd := SYSTEM.PA_NUM_TBL_TYPE(

3474: --
3475:
3476: l_seeded_measures := SYSTEM.PA_Num_Tbl_Type();
3477:
3478: l_fp_custom_measures_ptd := SYSTEM.PA_NUM_TBL_TYPE(
3479: l_overview_type(l_actual_index).ptd_custom_1,
3480: l_overview_type(l_actual_index).ptd_custom_2,
3481: l_overview_type(l_actual_index).ptd_custom_3,
3482: l_overview_type(l_actual_index).ptd_custom_4,

Line 3495: l_fp_custom_measures_qtd := SYSTEM.PA_NUM_TBL_TYPE(

3491: l_overview_type(l_actual_index).ptd_custom_13,
3492: l_overview_type(l_actual_index).ptd_custom_14,
3493: l_overview_type(l_actual_index).ptd_custom_15
3494: );
3495: l_fp_custom_measures_qtd := SYSTEM.PA_NUM_TBL_TYPE(
3496: l_overview_type(l_actual_index).qtd_custom_1,
3497: l_overview_type(l_actual_index).qtd_custom_2,
3498: l_overview_type(l_actual_index).qtd_custom_3,
3499: l_overview_type(l_actual_index).qtd_custom_4,

Line 3512: l_fp_custom_measures_ytd := SYSTEM.PA_NUM_TBL_TYPE(

3508: l_overview_type(l_actual_index).qtd_custom_13,
3509: l_overview_type(l_actual_index).qtd_custom_14,
3510: l_overview_type(l_actual_index).qtd_custom_15
3511: );
3512: l_fp_custom_measures_ytd := SYSTEM.PA_NUM_TBL_TYPE(
3513: l_overview_type(l_actual_index).ytd_custom_1,
3514: l_overview_type(l_actual_index).ytd_custom_2,
3515: l_overview_type(l_actual_index).ytd_custom_3,
3516: l_overview_type(l_actual_index).ytd_custom_4,

Line 3529: l_fp_custom_measures_itd := SYSTEM.PA_NUM_TBL_TYPE(

3525: l_overview_type(l_actual_index).ytd_custom_13,
3526: l_overview_type(l_actual_index).ytd_custom_14,
3527: l_overview_type(l_actual_index).ytd_custom_15
3528: );
3529: l_fp_custom_measures_itd := SYSTEM.PA_NUM_TBL_TYPE(
3530: l_overview_type(l_actual_index).itd_custom_1,
3531: l_overview_type(l_actual_index).itd_custom_2,
3532: l_overview_type(l_actual_index).itd_custom_3,
3533: l_overview_type(l_actual_index).itd_custom_4,

Line 3546: l_fp_custom_measures_ac := SYSTEM.PA_NUM_TBL_TYPE(

3542: l_overview_type(l_actual_index).itd_custom_13,
3543: l_overview_type(l_actual_index).itd_custom_14,
3544: l_overview_type(l_actual_index).itd_custom_15
3545: );
3546: l_fp_custom_measures_ac := SYSTEM.PA_NUM_TBL_TYPE(
3547: l_overview_type(l_actual_index).ac_custom_1,
3548: l_overview_type(l_actual_index).ac_custom_2,
3549: l_overview_type(l_actual_index).ac_custom_3,
3550: l_overview_type(l_actual_index).ac_custom_4,

Line 3563: l_fp_custom_measures_prp := SYSTEM.PA_NUM_TBL_TYPE(

3559: l_overview_type(l_actual_index).ac_custom_13,
3560: l_overview_type(l_actual_index).ac_custom_14,
3561: l_overview_type(l_actual_index).ac_custom_15
3562: );
3563: l_fp_custom_measures_prp := SYSTEM.PA_NUM_TBL_TYPE(
3564: l_overview_type(l_actual_index).prp_custom_1,
3565: l_overview_type(l_actual_index).prp_custom_2,
3566: l_overview_type(l_actual_index).prp_custom_3,
3567: l_overview_type(l_actual_index).prp_custom_4,

Line 3581: l_ac_custom_measures_ptd := SYSTEM.PA_NUM_TBL_TYPE(

3577: l_overview_type(l_actual_index).prp_custom_14,
3578: l_overview_type(l_actual_index).prp_custom_15
3579: );
3580:
3581: l_ac_custom_measures_ptd := SYSTEM.PA_NUM_TBL_TYPE(
3582: l_pji_facts.ptd_custom_1,
3583: l_pji_facts.ptd_custom_2,
3584: l_pji_facts.ptd_custom_3,
3585: l_pji_facts.ptd_custom_4,

Line 3598: l_ac_custom_measures_qtd := SYSTEM.PA_NUM_TBL_TYPE(

3594: l_pji_facts.ptd_custom_13,
3595: l_pji_facts.ptd_custom_14,
3596: l_pji_facts.ptd_custom_15
3597: );
3598: l_ac_custom_measures_qtd := SYSTEM.PA_NUM_TBL_TYPE(
3599: l_pji_facts.qtd_custom_1,
3600: l_pji_facts.qtd_custom_2,
3601: l_pji_facts.qtd_custom_3,
3602: l_pji_facts.qtd_custom_4,

Line 3615: l_ac_custom_measures_ytd := SYSTEM.PA_NUM_TBL_TYPE(

3611: l_pji_facts.qtd_custom_13,
3612: l_pji_facts.qtd_custom_14,
3613: l_pji_facts.qtd_custom_15
3614: );
3615: l_ac_custom_measures_ytd := SYSTEM.PA_NUM_TBL_TYPE(
3616: l_pji_facts.ytd_custom_1,
3617: l_pji_facts.ytd_custom_2,
3618: l_pji_facts.ytd_custom_3,
3619: l_pji_facts.ytd_custom_4,

Line 3632: l_ac_custom_measures_itd := SYSTEM.PA_NUM_TBL_TYPE(

3628: l_pji_facts.ytd_custom_13,
3629: l_pji_facts.ytd_custom_14,
3630: l_pji_facts.ytd_custom_15
3631: );
3632: l_ac_custom_measures_itd := SYSTEM.PA_NUM_TBL_TYPE(
3633: l_pji_facts.itd_custom_1,
3634: l_pji_facts.itd_custom_2,
3635: l_pji_facts.itd_custom_3,
3636: l_pji_facts.itd_custom_4,

Line 3649: l_ac_custom_measures_ac := SYSTEM.PA_NUM_TBL_TYPE(

3645: l_pji_facts.itd_custom_13,
3646: l_pji_facts.itd_custom_14,
3647: l_pji_facts.itd_custom_15
3648: );
3649: l_ac_custom_measures_ac := SYSTEM.PA_NUM_TBL_TYPE(
3650: l_pji_facts.ac_custom_1,
3651: l_pji_facts.ac_custom_2,
3652: l_pji_facts.ac_custom_3,
3653: l_pji_facts.ac_custom_4,

Line 3666: l_ac_custom_measures_prp := SYSTEM.PA_NUM_TBL_TYPE(

3662: l_pji_facts.ac_custom_13,
3663: l_pji_facts.ac_custom_14,
3664: l_pji_facts.ac_custom_15
3665: );
3666: l_ac_custom_measures_prp := SYSTEM.PA_NUM_TBL_TYPE(
3667: l_pji_facts.prp_custom_1,
3668: l_pji_facts.prp_custom_2,
3669: l_pji_facts.prp_custom_3,
3670: l_pji_facts.prp_custom_4,

Line 10012: p_project_id_tbl IN SYSTEM.pa_num_tbl_type

10008: * exception indicators for All the passed project ids.
10009: */
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

Line 10016: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL

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
10020: , x_return_status OUT NOCOPY VARCHAR2

Line 10041: l_project_id_tbl SYSTEM.pa_num_tbl_type;

10037:
10038: l_pji_excp_ind_rec SYSTEM.PJI_EXCP_IND_REC;
10039: l_pji_excp_ind_rec_tbl SYSTEM.PJI_EXCP_IND_REC_TBL_TYPE;
10040:
10041: l_project_id_tbl SYSTEM.pa_num_tbl_type;
10042:
10043: BEGIN
10044:
10045: l_project_id_tbl := p_project_id_tbl;