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 648: , x_measure_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

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

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

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

Line 737: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL

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

Line 768: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

764: l_ytd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
765: l_itd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
766: l_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
767: l_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
768: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
769: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
770: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
771: l_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
772: l_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 769: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

765: l_itd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
766: l_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
767: l_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
768: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
769: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
770: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
771: l_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
772: l_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
773: l_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 770: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

766: l_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
767: l_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
768: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
769: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
770: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
771: l_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
772: l_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
773: l_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
774: l_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 771: l_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

767: l_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
768: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
769: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
770: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
771: l_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
772: l_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
773: l_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
774: l_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
775: l_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 772: l_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;

768: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
769: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
770: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
771: l_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
772: l_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
773: l_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
774: l_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
775: l_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
776: l_qtd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 773: l_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;

769: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
770: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
771: l_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
772: l_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
773: l_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
774: l_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
775: l_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
776: l_qtd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
777: l_itd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 825: l_plan_version_ids SYSTEM.PA_NUM_TBL_TYPE;

821: l_tmp_xtd_type VARCHAR2(255);
822: l_effective_i NUMBER;
823: l_slice_name VARCHAR2(80);
824:
825: l_plan_version_ids SYSTEM.PA_NUM_TBL_TYPE;
826: l_i NUMBER;
827:
828: -- Add by Ning, besides passing the measure_set_code, also pass the measure_ids
829: l_measure_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

Line 829: l_measure_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

825: l_plan_version_ids SYSTEM.PA_NUM_TBL_TYPE;
826: l_i NUMBER;
827:
828: -- Add by Ning, besides passing the measure_set_code, also pass the measure_ids
829: l_measure_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
830: BEGIN
831: NULL;
832:
833: IF g_debug_mode = 'Y' THEN

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

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();
847:
848: IF p_measure_codes_tbl.LAST < 1 THEN
849: x_measure_values_tbl := NULL;

Line 944: l_plan_version_ids := SYSTEM.PA_NUM_TBL_TYPE(

940: --bug 4355820, only compute project amount for project list
941: l_prg_rollup := 'N'; --Pji_Rep_Util.Derive_Prg_Rollup_Flag(p_project_id);
942:
943:
944: l_plan_version_ids := SYSTEM.PA_NUM_TBL_TYPE(
945: l_actual_version_id
946: , l_cstforecast_version_id
947: , l_cstbudget_version_id
948: , l_cstbudget2_version_id

Line 1077: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL

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

Line 1476: x_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

1472: x_ytd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1473: x_itd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1474: x_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1475: x_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1476: x_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1477: x_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1478: x_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1479: x_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1480: x_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 1477: x_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

1473: x_itd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1474: x_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1475: x_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1476: x_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1477: x_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1478: x_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1479: x_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1480: x_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1481: x_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 1478: x_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

1474: x_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1475: x_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1476: x_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1477: x_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1478: x_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1479: x_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1480: x_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1481: x_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1482: x_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1479: x_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

1475: x_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1476: x_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1477: x_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1478: x_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1479: x_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1480: x_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1481: x_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1482: x_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1483: x_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1480: x_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;

1476: x_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1477: x_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1478: x_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1479: x_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1480: x_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1481: x_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1482: x_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1483: x_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1484: x_qtd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1481: x_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;

1477: x_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1478: x_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1479: x_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1480: x_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1481: x_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1482: x_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1483: x_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1484: x_qtd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1485: x_itd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1689: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL

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

Line 1704: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

1700: , x_ytd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1701: , x_itd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1702: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1703: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1704: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1705: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1706: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1707: , x_itd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1708: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 1705: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

1701: , x_itd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1702: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1703: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1704: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1705: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1706: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1707: , x_itd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1708: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1709: , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 1706: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

1702: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1703: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1704: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1705: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1706: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1707: , x_itd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1708: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1709: , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1710: , x_ptd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 1707: , x_itd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

1703: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1704: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1705: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1706: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1707: , x_itd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1708: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1709: , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1710: , x_ptd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1711: , x_ytd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 1708: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

1704: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1705: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1706: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1707: , x_itd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1708: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1709: , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1710: , x_ptd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1711: , x_ytd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1712: , x_qtd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 1709: , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

1705: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1706: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1707: , x_itd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1708: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1709: , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1710: , x_ptd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1711: , x_ytd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1712: , x_qtd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1713: , x_itd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 1750: ptd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;

1746: l_orig_rev_budget2_index NUMBER;
1747: l_prior_cost_forecast_index NUMBER;
1748: l_prior_rev_forecast_index NUMBER;
1749: l_check_plan_versions NUMBER;
1750: ptd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1751: qtd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1752: ytd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1753: itd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1754: ac_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;

Line 1751: qtd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;

1747: l_prior_cost_forecast_index NUMBER;
1748: l_prior_rev_forecast_index NUMBER;
1749: l_check_plan_versions NUMBER;
1750: ptd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1751: qtd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1752: ytd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1753: itd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1754: ac_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1755: prp_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;

Line 1752: ytd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;

1748: l_prior_rev_forecast_index NUMBER;
1749: l_check_plan_versions NUMBER;
1750: ptd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1751: qtd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1752: ytd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1753: itd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1754: ac_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1755: prp_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1756: l_seeded_measures SYSTEM.PA_Num_Tbl_Type;

Line 1753: itd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;

1749: l_check_plan_versions NUMBER;
1750: ptd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1751: qtd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1752: ytd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1753: itd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1754: ac_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1755: prp_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1756: l_seeded_measures SYSTEM.PA_Num_Tbl_Type;
1757: l_seeded_measures_ptd SYSTEM.PA_Num_Tbl_Type;

Line 1754: ac_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;

1750: ptd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1751: qtd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1752: ytd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1753: itd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1754: ac_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1755: prp_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1756: l_seeded_measures SYSTEM.PA_Num_Tbl_Type;
1757: l_seeded_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1758: l_seeded_measures_qtd SYSTEM.PA_Num_Tbl_Type;

Line 1755: prp_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;

1751: qtd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1752: ytd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1753: itd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1754: ac_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1755: prp_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1756: l_seeded_measures SYSTEM.PA_Num_Tbl_Type;
1757: l_seeded_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1758: l_seeded_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1759: l_seeded_measures_ytd SYSTEM.PA_Num_Tbl_Type;

Line 1756: l_seeded_measures SYSTEM.PA_Num_Tbl_Type;

1752: ytd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1753: itd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1754: ac_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1755: prp_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1756: l_seeded_measures SYSTEM.PA_Num_Tbl_Type;
1757: l_seeded_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1758: l_seeded_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1759: l_seeded_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1760: l_seeded_measures_itd SYSTEM.PA_Num_Tbl_Type;

Line 1757: l_seeded_measures_ptd SYSTEM.PA_Num_Tbl_Type;

1753: itd_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1754: ac_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1755: prp_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1756: l_seeded_measures SYSTEM.PA_Num_Tbl_Type;
1757: l_seeded_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1758: l_seeded_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1759: l_seeded_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1760: l_seeded_measures_itd SYSTEM.PA_Num_Tbl_Type;
1761: l_seeded_measures_ac SYSTEM.PA_Num_Tbl_Type;

Line 1758: l_seeded_measures_qtd SYSTEM.PA_Num_Tbl_Type;

1754: ac_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1755: prp_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1756: l_seeded_measures SYSTEM.PA_Num_Tbl_Type;
1757: l_seeded_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1758: l_seeded_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1759: l_seeded_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1760: l_seeded_measures_itd SYSTEM.PA_Num_Tbl_Type;
1761: l_seeded_measures_ac SYSTEM.PA_Num_Tbl_Type;
1762: l_seeded_measures_prp SYSTEM.PA_Num_Tbl_Type;

Line 1759: l_seeded_measures_ytd SYSTEM.PA_Num_Tbl_Type;

1755: prp_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
1756: l_seeded_measures SYSTEM.PA_Num_Tbl_Type;
1757: l_seeded_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1758: l_seeded_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1759: l_seeded_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1760: l_seeded_measures_itd SYSTEM.PA_Num_Tbl_Type;
1761: l_seeded_measures_ac SYSTEM.PA_Num_Tbl_Type;
1762: l_seeded_measures_prp SYSTEM.PA_Num_Tbl_Type;
1763: l_fp_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;

Line 1760: l_seeded_measures_itd SYSTEM.PA_Num_Tbl_Type;

1756: l_seeded_measures SYSTEM.PA_Num_Tbl_Type;
1757: l_seeded_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1758: l_seeded_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1759: l_seeded_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1760: l_seeded_measures_itd SYSTEM.PA_Num_Tbl_Type;
1761: l_seeded_measures_ac SYSTEM.PA_Num_Tbl_Type;
1762: l_seeded_measures_prp SYSTEM.PA_Num_Tbl_Type;
1763: l_fp_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1764: l_fp_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;

Line 1761: l_seeded_measures_ac SYSTEM.PA_Num_Tbl_Type;

1757: l_seeded_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1758: l_seeded_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1759: l_seeded_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1760: l_seeded_measures_itd SYSTEM.PA_Num_Tbl_Type;
1761: l_seeded_measures_ac SYSTEM.PA_Num_Tbl_Type;
1762: l_seeded_measures_prp SYSTEM.PA_Num_Tbl_Type;
1763: l_fp_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1764: l_fp_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1765: l_fp_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;

Line 1762: l_seeded_measures_prp SYSTEM.PA_Num_Tbl_Type;

1758: l_seeded_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1759: l_seeded_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1760: l_seeded_measures_itd SYSTEM.PA_Num_Tbl_Type;
1761: l_seeded_measures_ac SYSTEM.PA_Num_Tbl_Type;
1762: l_seeded_measures_prp SYSTEM.PA_Num_Tbl_Type;
1763: l_fp_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1764: l_fp_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1765: l_fp_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1766: l_fp_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;

Line 1763: l_fp_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;

1759: l_seeded_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1760: l_seeded_measures_itd SYSTEM.PA_Num_Tbl_Type;
1761: l_seeded_measures_ac SYSTEM.PA_Num_Tbl_Type;
1762: l_seeded_measures_prp SYSTEM.PA_Num_Tbl_Type;
1763: l_fp_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1764: l_fp_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1765: l_fp_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1766: l_fp_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1767: l_fp_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;

Line 1764: l_fp_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;

1760: l_seeded_measures_itd SYSTEM.PA_Num_Tbl_Type;
1761: l_seeded_measures_ac SYSTEM.PA_Num_Tbl_Type;
1762: l_seeded_measures_prp SYSTEM.PA_Num_Tbl_Type;
1763: l_fp_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1764: l_fp_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1765: l_fp_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1766: l_fp_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1767: l_fp_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1768: l_fp_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;

Line 1765: l_fp_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;

1761: l_seeded_measures_ac SYSTEM.PA_Num_Tbl_Type;
1762: l_seeded_measures_prp SYSTEM.PA_Num_Tbl_Type;
1763: l_fp_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1764: l_fp_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1765: l_fp_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1766: l_fp_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1767: l_fp_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1768: l_fp_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1769: l_ac_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;

Line 1766: l_fp_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;

1762: l_seeded_measures_prp SYSTEM.PA_Num_Tbl_Type;
1763: l_fp_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1764: l_fp_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1765: l_fp_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1766: l_fp_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1767: l_fp_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1768: l_fp_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1769: l_ac_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1770: l_ac_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;

Line 1767: l_fp_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;

1763: l_fp_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1764: l_fp_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1765: l_fp_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1766: l_fp_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1767: l_fp_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1768: l_fp_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1769: l_ac_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1770: l_ac_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1771: l_ac_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;

Line 1768: l_fp_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;

1764: l_fp_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1765: l_fp_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1766: l_fp_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1767: l_fp_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1768: l_fp_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1769: l_ac_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1770: l_ac_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1771: l_ac_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1772: l_ac_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;

Line 1769: l_ac_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;

1765: l_fp_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1766: l_fp_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1767: l_fp_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1768: l_fp_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1769: l_ac_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1770: l_ac_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1771: l_ac_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1772: l_ac_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1773: l_ac_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;

Line 1770: l_ac_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;

1766: l_fp_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1767: l_fp_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1768: l_fp_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1769: l_ac_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1770: l_ac_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1771: l_ac_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1772: l_ac_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1773: l_ac_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1774: l_ac_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;

Line 1771: l_ac_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;

1767: l_fp_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1768: l_fp_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1769: l_ac_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1770: l_ac_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1771: l_ac_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1772: l_ac_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1773: l_ac_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1774: l_ac_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1775: l_fp_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;

Line 1772: l_ac_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;

1768: l_fp_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1769: l_ac_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1770: l_ac_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1771: l_ac_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1772: l_ac_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1773: l_ac_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1774: l_ac_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1775: l_fp_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1776: l_fp_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;

Line 1773: l_ac_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;

1769: l_ac_calc_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1770: l_ac_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1771: l_ac_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1772: l_ac_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1773: l_ac_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1774: l_ac_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1775: l_fp_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1776: l_fp_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1777: l_fp_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;

Line 1774: l_ac_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;

1770: l_ac_calc_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1771: l_ac_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1772: l_ac_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1773: l_ac_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1774: l_ac_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1775: l_fp_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1776: l_fp_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1777: l_fp_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1778: l_fp_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;

Line 1775: l_fp_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;

1771: l_ac_calc_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1772: l_ac_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1773: l_ac_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1774: l_ac_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1775: l_fp_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1776: l_fp_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1777: l_fp_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1778: l_fp_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1779: l_fp_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;

Line 1776: l_fp_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;

1772: l_ac_calc_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1773: l_ac_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1774: l_ac_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1775: l_fp_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1776: l_fp_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1777: l_fp_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1778: l_fp_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1779: l_fp_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1780: l_fp_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;

Line 1777: l_fp_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;

1773: l_ac_calc_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1774: l_ac_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1775: l_fp_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1776: l_fp_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1777: l_fp_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1778: l_fp_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1779: l_fp_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1780: l_fp_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1781: l_ac_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;

Line 1778: l_fp_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;

1774: l_ac_calc_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1775: l_fp_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1776: l_fp_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1777: l_fp_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1778: l_fp_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1779: l_fp_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1780: l_fp_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1781: l_ac_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1782: l_ac_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;

Line 1779: l_fp_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;

1775: l_fp_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1776: l_fp_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1777: l_fp_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1778: l_fp_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1779: l_fp_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1780: l_fp_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1781: l_ac_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1782: l_ac_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1783: l_ac_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;

Line 1780: l_fp_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;

1776: l_fp_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1777: l_fp_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1778: l_fp_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1779: l_fp_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1780: l_fp_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1781: l_ac_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1782: l_ac_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;
1783: l_ac_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1784: l_ac_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;

Line 1781: l_ac_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;

1777: l_fp_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;
1778: l_fp_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1779: l_fp_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1780: l_fp_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1781: l_ac_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1782: l_ac_custom_measures_qtd SYSTEM.PA_Num_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;

Line 1782: l_ac_custom_measures_qtd SYSTEM.PA_Num_Tbl_Type;

1778: l_fp_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;
1779: l_fp_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1780: l_fp_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1781: l_ac_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1782: l_ac_custom_measures_qtd SYSTEM.PA_Num_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;

Line 1783: l_ac_custom_measures_ytd SYSTEM.PA_Num_Tbl_Type;

1779: l_fp_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1780: l_fp_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1781: l_ac_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1782: l_ac_custom_measures_qtd SYSTEM.PA_Num_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;

Line 1784: l_ac_custom_measures_itd SYSTEM.PA_Num_Tbl_Type;

1780: l_fp_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1781: l_ac_custom_measures_ptd SYSTEM.PA_Num_Tbl_Type;
1782: l_ac_custom_measures_qtd SYSTEM.PA_Num_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;

Line 1785: l_ac_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;

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

Line 1786: l_ac_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;

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

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

3269: --
3270: -- get the HTML code for the color indicators for each PTD measure
3271: --
3272:
3273: ptd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3274: ptd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3275: qtd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3276: qtd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3277: ytd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();

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

3271: --
3272:
3273: ptd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3274: ptd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3275: qtd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3276: qtd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3277: ytd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3278: ytd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3279: itd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();

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

3273: ptd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3274: ptd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3275: qtd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3276: qtd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3277: ytd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3278: ytd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3279: itd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3280: itd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3281: ac_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();

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

3275: qtd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3276: qtd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3277: ytd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3278: ytd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3279: itd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3280: itd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3281: ac_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3282: ac_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3283: prp_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();

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

3277: ytd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3278: ytd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3279: itd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3280: itd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3281: ac_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3282: ac_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3283: prp_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3284: prp_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3285:

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

3279: itd_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3280: itd_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3281: ac_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3282: ac_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3283: prp_measure_ids_tbl := SYSTEM.PA_NUM_TBL_TYPE();
3284: prp_measure_ids_tbl.EXTEND(p_measure_set_code.LAST);
3285:
3286:
3287: --

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

3362:
3363: IF x_ptd_html IS NULL THEN
3364: x_ptd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3365: x_ptd_html.EXTEND(p_measure_set_code.LAST);
3366: x_ptd_trans_id := SYSTEM.pa_NUM_TBL_TYPE();
3367: x_ptd_trans_id.extend(p_measure_set_code.LAST);
3368: x_ptd_meaning := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3369: x_ptd_meaning.extend(p_measure_set_code.LAST);
3370: END IF;

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

3371:
3372: IF x_qtd_html IS NULL THEN
3373: x_qtd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3374: x_qtd_html.EXTEND(p_measure_set_code.LAST);
3375: x_qtd_trans_id := SYSTEM.pa_NUM_TBL_TYPE();
3376: x_qtd_trans_id.extend(p_measure_set_code.LAST);
3377: x_qtd_meaning := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3378: x_qtd_meaning.extend(p_measure_set_code.LAST);
3379: END IF;

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

3380:
3381: IF x_ytd_html IS NULL THEN
3382: x_ytd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3383: x_ytd_html.EXTEND(p_measure_set_code.LAST);
3384: x_ytd_trans_id := SYSTEM.pa_NUM_TBL_TYPE();
3385: x_ytd_trans_id.extend(p_measure_set_code.LAST);
3386: x_ytd_meaning := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3387: x_ytd_meaning.extend(p_measure_set_code.LAST);
3388: END IF;

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

3389:
3390: IF x_itd_html IS NULL THEN
3391: x_itd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3392: x_itd_html.EXTEND(p_measure_set_code.LAST);
3393: x_itd_trans_id := SYSTEM.pa_NUM_TBL_TYPE();
3394: x_itd_trans_id.extend(p_measure_set_code.LAST);
3395: x_itd_meaning := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3396: x_itd_meaning.extend(p_measure_set_code.LAST);
3397: END IF;

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

3398:
3399: IF x_ac_html IS NULL THEN
3400: x_ac_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3401: x_ac_html.EXTEND(p_measure_set_code.LAST);
3402: x_ac_trans_id := SYSTEM.pa_NUM_TBL_TYPE();
3403: x_ac_trans_id.extend(p_measure_set_code.LAST);
3404: x_ac_meaning := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3405: x_ac_meaning.extend(p_measure_set_code.LAST);
3406: END IF;

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

3407:
3408: IF x_prp_html IS NULL THEN
3409: x_prp_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3410: x_prp_html.EXTEND(p_measure_set_code.LAST);
3411: x_prp_trans_id := SYSTEM.pa_NUM_TBL_TYPE();
3412: x_prp_trans_id.extend(p_measure_set_code.LAST);
3413: x_prp_meaning := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3414: x_prp_meaning.extend(p_measure_set_code.LAST);
3415: END IF;

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

3465: --
3466: -- initialize custom measures arrays
3467: --
3468:
3469: l_seeded_measures := SYSTEM.PA_Num_Tbl_Type();
3470:
3471: l_fp_custom_measures_ptd := SYSTEM.PA_NUM_TBL_TYPE(
3472: l_overview_type(l_actual_index).ptd_custom_1,
3473: l_overview_type(l_actual_index).ptd_custom_2,

Line 3471: l_fp_custom_measures_ptd := SYSTEM.PA_NUM_TBL_TYPE(

3467: --
3468:
3469: l_seeded_measures := SYSTEM.PA_Num_Tbl_Type();
3470:
3471: l_fp_custom_measures_ptd := SYSTEM.PA_NUM_TBL_TYPE(
3472: l_overview_type(l_actual_index).ptd_custom_1,
3473: l_overview_type(l_actual_index).ptd_custom_2,
3474: l_overview_type(l_actual_index).ptd_custom_3,
3475: l_overview_type(l_actual_index).ptd_custom_4,

Line 3488: l_fp_custom_measures_qtd := SYSTEM.PA_NUM_TBL_TYPE(

3484: l_overview_type(l_actual_index).ptd_custom_13,
3485: l_overview_type(l_actual_index).ptd_custom_14,
3486: l_overview_type(l_actual_index).ptd_custom_15
3487: );
3488: l_fp_custom_measures_qtd := SYSTEM.PA_NUM_TBL_TYPE(
3489: l_overview_type(l_actual_index).qtd_custom_1,
3490: l_overview_type(l_actual_index).qtd_custom_2,
3491: l_overview_type(l_actual_index).qtd_custom_3,
3492: l_overview_type(l_actual_index).qtd_custom_4,

Line 3505: l_fp_custom_measures_ytd := SYSTEM.PA_NUM_TBL_TYPE(

3501: l_overview_type(l_actual_index).qtd_custom_13,
3502: l_overview_type(l_actual_index).qtd_custom_14,
3503: l_overview_type(l_actual_index).qtd_custom_15
3504: );
3505: l_fp_custom_measures_ytd := SYSTEM.PA_NUM_TBL_TYPE(
3506: l_overview_type(l_actual_index).ytd_custom_1,
3507: l_overview_type(l_actual_index).ytd_custom_2,
3508: l_overview_type(l_actual_index).ytd_custom_3,
3509: l_overview_type(l_actual_index).ytd_custom_4,

Line 3522: l_fp_custom_measures_itd := SYSTEM.PA_NUM_TBL_TYPE(

3518: l_overview_type(l_actual_index).ytd_custom_13,
3519: l_overview_type(l_actual_index).ytd_custom_14,
3520: l_overview_type(l_actual_index).ytd_custom_15
3521: );
3522: l_fp_custom_measures_itd := SYSTEM.PA_NUM_TBL_TYPE(
3523: l_overview_type(l_actual_index).itd_custom_1,
3524: l_overview_type(l_actual_index).itd_custom_2,
3525: l_overview_type(l_actual_index).itd_custom_3,
3526: l_overview_type(l_actual_index).itd_custom_4,

Line 3539: l_fp_custom_measures_ac := SYSTEM.PA_NUM_TBL_TYPE(

3535: l_overview_type(l_actual_index).itd_custom_13,
3536: l_overview_type(l_actual_index).itd_custom_14,
3537: l_overview_type(l_actual_index).itd_custom_15
3538: );
3539: l_fp_custom_measures_ac := SYSTEM.PA_NUM_TBL_TYPE(
3540: l_overview_type(l_actual_index).ac_custom_1,
3541: l_overview_type(l_actual_index).ac_custom_2,
3542: l_overview_type(l_actual_index).ac_custom_3,
3543: l_overview_type(l_actual_index).ac_custom_4,

Line 3556: l_fp_custom_measures_prp := SYSTEM.PA_NUM_TBL_TYPE(

3552: l_overview_type(l_actual_index).ac_custom_13,
3553: l_overview_type(l_actual_index).ac_custom_14,
3554: l_overview_type(l_actual_index).ac_custom_15
3555: );
3556: l_fp_custom_measures_prp := SYSTEM.PA_NUM_TBL_TYPE(
3557: l_overview_type(l_actual_index).prp_custom_1,
3558: l_overview_type(l_actual_index).prp_custom_2,
3559: l_overview_type(l_actual_index).prp_custom_3,
3560: l_overview_type(l_actual_index).prp_custom_4,

Line 3574: l_ac_custom_measures_ptd := SYSTEM.PA_NUM_TBL_TYPE(

3570: l_overview_type(l_actual_index).prp_custom_14,
3571: l_overview_type(l_actual_index).prp_custom_15
3572: );
3573:
3574: l_ac_custom_measures_ptd := SYSTEM.PA_NUM_TBL_TYPE(
3575: l_pji_facts.ptd_custom_1,
3576: l_pji_facts.ptd_custom_2,
3577: l_pji_facts.ptd_custom_3,
3578: l_pji_facts.ptd_custom_4,

Line 3591: l_ac_custom_measures_qtd := SYSTEM.PA_NUM_TBL_TYPE(

3587: l_pji_facts.ptd_custom_13,
3588: l_pji_facts.ptd_custom_14,
3589: l_pji_facts.ptd_custom_15
3590: );
3591: l_ac_custom_measures_qtd := SYSTEM.PA_NUM_TBL_TYPE(
3592: l_pji_facts.qtd_custom_1,
3593: l_pji_facts.qtd_custom_2,
3594: l_pji_facts.qtd_custom_3,
3595: l_pji_facts.qtd_custom_4,

Line 3608: l_ac_custom_measures_ytd := SYSTEM.PA_NUM_TBL_TYPE(

3604: l_pji_facts.qtd_custom_13,
3605: l_pji_facts.qtd_custom_14,
3606: l_pji_facts.qtd_custom_15
3607: );
3608: l_ac_custom_measures_ytd := SYSTEM.PA_NUM_TBL_TYPE(
3609: l_pji_facts.ytd_custom_1,
3610: l_pji_facts.ytd_custom_2,
3611: l_pji_facts.ytd_custom_3,
3612: l_pji_facts.ytd_custom_4,

Line 3625: l_ac_custom_measures_itd := SYSTEM.PA_NUM_TBL_TYPE(

3621: l_pji_facts.ytd_custom_13,
3622: l_pji_facts.ytd_custom_14,
3623: l_pji_facts.ytd_custom_15
3624: );
3625: l_ac_custom_measures_itd := SYSTEM.PA_NUM_TBL_TYPE(
3626: l_pji_facts.itd_custom_1,
3627: l_pji_facts.itd_custom_2,
3628: l_pji_facts.itd_custom_3,
3629: l_pji_facts.itd_custom_4,

Line 3642: l_ac_custom_measures_ac := SYSTEM.PA_NUM_TBL_TYPE(

3638: l_pji_facts.itd_custom_13,
3639: l_pji_facts.itd_custom_14,
3640: l_pji_facts.itd_custom_15
3641: );
3642: l_ac_custom_measures_ac := SYSTEM.PA_NUM_TBL_TYPE(
3643: l_pji_facts.ac_custom_1,
3644: l_pji_facts.ac_custom_2,
3645: l_pji_facts.ac_custom_3,
3646: l_pji_facts.ac_custom_4,

Line 3659: l_ac_custom_measures_prp := SYSTEM.PA_NUM_TBL_TYPE(

3655: l_pji_facts.ac_custom_13,
3656: l_pji_facts.ac_custom_14,
3657: l_pji_facts.ac_custom_15
3658: );
3659: l_ac_custom_measures_prp := SYSTEM.PA_NUM_TBL_TYPE(
3660: l_pji_facts.prp_custom_1,
3661: l_pji_facts.prp_custom_2,
3662: l_pji_facts.prp_custom_3,
3663: l_pji_facts.prp_custom_4,