eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_REP_MEASURE_UTIL dependencies on PA_VARCHAR2_80_TBL_TYPE

Line 138: l_ptd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

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

Line 139: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

135: l_measure_set_codes_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
136: l_xtd_types_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
137: l_measure_set_types SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
138: l_ptd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
139: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
140: l_ytd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
141: l_itd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
142: l_ac_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
143: l_prp_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 140: l_ytd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

136: l_xtd_types_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
137: l_measure_set_types SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
138: l_ptd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
139: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
140: l_ytd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
141: l_itd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
142: l_ac_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
143: l_prp_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
144: l_ptd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 141: l_itd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

137: l_measure_set_types SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
138: l_ptd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
139: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
140: l_ytd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
141: l_itd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
142: l_ac_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
143: l_prp_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
144: l_ptd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
145: l_qtd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 142: l_ac_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

138: l_ptd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
139: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
140: l_ytd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
141: l_itd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
142: l_ac_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
143: l_prp_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
144: l_ptd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
145: l_qtd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
146: l_ytd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 143: l_prp_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

139: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
140: l_ytd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
141: l_itd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
142: l_ac_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
143: l_prp_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
144: l_ptd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
145: l_qtd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
146: l_ytd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
147: l_itd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 165: l_ptd_meaning SYSTEM.PA_VARCHAR2_80_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;
168: l_itd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
169: l_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 166: l_ytd_meaning SYSTEM.PA_VARCHAR2_80_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;
168: l_itd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
169: l_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
170: l_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 167: l_qtd_meaning SYSTEM.PA_VARCHAR2_80_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;
168: l_itd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
169: l_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
170: l_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
171:

Line 168: l_itd_meaning SYSTEM.PA_VARCHAR2_80_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;
168: l_itd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
169: l_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
170: l_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
171:
172:

Line 169: l_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

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;
168: l_itd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
169: l_ac_meaning SYSTEM.PA_VARCHAR2_80_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;

Line 170: l_prp_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;
168: l_itd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
169: l_ac_meaning SYSTEM.PA_VARCHAR2_80_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;

Line 585: p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE

581:
582:
583: PROCEDURE Get_Measure_Labels
584: (
585: p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
586: , p_measure_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE
587: , x_return_status OUT NOCOPY VARCHAR2
588: , x_msg_count OUT NOCOPY NUMBER
589: , x_msg_data OUT NOCOPY VARCHAR2

Line 645: p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE

641: END Get_Measure_Labels;
642:
643: PROCEDURE Get_Measure_Attributes
644: (
645: p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
646: , x_measure_set_codes_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
647: , x_timeslices_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
648: , x_measure_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
649: , x_return_status OUT NOCOPY VARCHAR2

Line 734: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE

730:
731: PROCEDURE Get_Financial_Measures
732: (
733: p_project_id NUMBER
734: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
735: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
736: , p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
737: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
738: , x_measure_values_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 738: , x_measure_values_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

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

Line 756: l_ptd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

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

Line 757: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

753: l_measure_set_codes_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
754: l_timeslices_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
755: l_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
756: l_ptd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
757: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
758: l_ytd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
759: l_itd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
760: l_ac_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
761: l_prp_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 758: l_ytd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

754: l_timeslices_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
755: l_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
756: l_ptd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
757: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
758: l_ytd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
759: l_itd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
760: l_ac_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
761: l_prp_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
762: l_ptd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 759: l_itd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

755: l_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
756: l_ptd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
757: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
758: l_ytd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
759: l_itd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
760: l_ac_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
761: l_prp_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
762: l_ptd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
763: l_qtd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 760: l_ac_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

756: l_ptd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
757: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
758: l_ytd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
759: l_itd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
760: l_ac_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
761: l_prp_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
762: l_ptd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
763: l_qtd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
764: l_ytd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 761: l_prp_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

757: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
758: l_ytd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
759: l_itd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
760: l_ac_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
761: l_prp_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
762: l_ptd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
763: l_qtd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
764: l_ytd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
765: l_itd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 774: l_ptd_meaning SYSTEM.PA_VARCHAR2_80_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;
778: l_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 775: l_ytd_meaning SYSTEM.PA_VARCHAR2_80_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;
778: l_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
779: l_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 776: l_qtd_meaning SYSTEM.PA_VARCHAR2_80_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;
778: l_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
779: l_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
780: l_WBS_Version_ID NUMBER;

Line 777: l_itd_meaning SYSTEM.PA_VARCHAR2_80_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;
778: l_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
779: l_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
780: l_WBS_Version_ID NUMBER;
781: l_WBS_Element_Id NUMBER;

Line 778: l_ac_meaning SYSTEM.PA_VARCHAR2_80_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;
778: l_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
779: l_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
780: l_WBS_Version_ID NUMBER;
781: l_WBS_Element_Id NUMBER;
782: l_RBS_Version_ID NUMBER;

Line 779: l_prp_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;
778: l_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
779: l_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
780: l_WBS_Version_ID NUMBER;
781: l_WBS_Element_Id NUMBER;
782: l_RBS_Version_ID NUMBER;
783: l_RBS_Element_Id NUMBER;

Line 843: x_measure_values_tbl := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

839:
840:
841: l_measure_set_codes_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
842: l_timeslices_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
843: x_measure_values_tbl := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
844: x_exception_indicator_tbl := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
845: l_measure_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
846: --x_exception_labels_tbl := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
847:

Line 1074: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE

1070: --
1071: PROCEDURE Get_Activity_Measures
1072: (
1073: p_project_id NUMBER
1074: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1075: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
1076: , p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
1077: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
1078: , x_measure_values_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 1078: , x_measure_values_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

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

Line 1464: x_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1460:
1461: x_measure_set_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1462: x_measure_name SYSTEM.PA_VARCHAR2_240_TBL_TYPE;
1463: x_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1464: x_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1465: x_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1466: x_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1467: x_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1468: x_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1465: x_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1461: x_measure_set_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1462: x_measure_name SYSTEM.PA_VARCHAR2_240_TBL_TYPE;
1463: x_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1464: x_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1465: x_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1466: x_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1467: x_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1468: x_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1469: x_prp_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1466: x_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1462: x_measure_name SYSTEM.PA_VARCHAR2_240_TBL_TYPE;
1463: x_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1464: x_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1465: x_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1466: x_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1467: x_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1468: x_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1469: x_prp_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1470: x_ptd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 1467: x_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1463: x_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1464: x_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1465: x_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1466: x_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1467: x_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1468: x_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1469: x_prp_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1470: x_ptd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1471: x_qtd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 1468: x_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1464: x_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1465: x_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1466: x_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1467: x_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1468: x_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1469: x_prp_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1470: x_ptd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1471: x_qtd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1472: x_ytd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 1469: x_prp_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1465: x_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1466: x_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1467: x_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1468: x_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1469: x_prp_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1470: x_ptd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1471: x_qtd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1472: x_ytd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1473: x_itd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 1482: x_ptd_meaning SYSTEM.PA_VARCHAR2_80_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;
1486: x_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1483: x_ytd_meaning SYSTEM.PA_VARCHAR2_80_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;
1486: x_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1487: x_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1484: x_qtd_meaning SYSTEM.PA_VARCHAR2_80_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;
1486: x_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1487: x_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1488:

Line 1485: x_itd_meaning SYSTEM.PA_VARCHAR2_80_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;
1486: x_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1487: x_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1488:
1489: l_exception_indicator_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 1486: x_ac_meaning SYSTEM.PA_VARCHAR2_80_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;
1486: x_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1487: x_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1488:
1489: l_exception_indicator_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1490: l_sql_errm VARCHAR2(255);

Line 1487: x_prp_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;
1486: x_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1487: x_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1488:
1489: l_exception_indicator_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1490: l_sql_errm VARCHAR2(255);
1491:

Line 1692: , x_ptd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

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

Line 1693: , x_qtd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

1689: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
1690: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1691: , x_measure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1692: , x_ptd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1693: , x_qtd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1694: , x_ytd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1695: , x_itd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1696: , x_ac_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1697: , x_prp_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 1694: , x_ytd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

1690: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1691: , x_measure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1692: , x_ptd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1693: , x_qtd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1694: , x_ytd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1695: , x_itd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1696: , x_ac_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1697: , x_prp_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1698: , x_ptd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

Line 1695: , x_itd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

1691: , x_measure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1692: , x_ptd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1693: , x_qtd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1694: , x_ytd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1695: , x_itd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1696: , x_ac_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1697: , x_prp_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1698: , x_ptd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1699: , x_qtd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

Line 1696: , x_ac_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

1692: , x_ptd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1693: , x_qtd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1694: , x_ytd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1695: , x_itd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1696: , x_ac_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1697: , x_prp_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1698: , x_ptd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1699: , x_qtd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1700: , x_ytd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

Line 1697: , x_prp_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

1693: , x_qtd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1694: , x_ytd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1695: , x_itd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1696: , x_ac_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1697: , x_prp_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1698: , x_ptd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1699: , x_qtd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_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

Line 1710: , x_ptd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_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
1714: , x_ac_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 1711: , x_ytd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_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
1714: , x_ac_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1715: , x_prp_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 1712: , x_qtd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_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
1714: , x_ac_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1715: , x_prp_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1716: , xDaysSinceITD OUT NOCOPY NUMBER

Line 1713: , x_itd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_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
1714: , x_ac_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1715: , x_prp_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1716: , xDaysSinceITD OUT NOCOPY NUMBER
1717: , xDaysInPeriod OUT NOCOPY NUMBER

Line 1714: , x_ac_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_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
1714: , x_ac_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1715: , x_prp_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1716: , xDaysSinceITD OUT NOCOPY NUMBER
1717: , xDaysInPeriod OUT NOCOPY NUMBER
1718: , x_return_status IN OUT NOCOPY VARCHAR2

Line 1715: , x_prp_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
1714: , x_ac_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1715: , x_prp_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1716: , xDaysSinceITD OUT NOCOPY NUMBER
1717: , xDaysInPeriod OUT NOCOPY NUMBER
1718: , x_return_status IN OUT NOCOPY VARCHAR2
1719: , x_msg_count IN OUT NOCOPY NUMBER

Line 1789: l_fp_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

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

Line 1790: l_fp_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1786: l_ac_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1787: l_fp_cus_meas_formats SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1788: l_ac_cus_meas_formats SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1789: l_fp_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1790: l_fp_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1791: l_fp_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1792: l_fp_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1793: l_fp_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1794: l_fp_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1791: l_fp_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1787: l_fp_cus_meas_formats SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1788: l_ac_cus_meas_formats SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1789: l_fp_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1790: l_fp_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1791: l_fp_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1792: l_fp_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1793: l_fp_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1794: l_fp_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1795: l_ac_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1792: l_fp_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1788: l_ac_cus_meas_formats SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1789: l_fp_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1790: l_fp_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1791: l_fp_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1792: l_fp_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1793: l_fp_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1794: l_fp_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1795: l_ac_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1796: l_ac_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1793: l_fp_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1789: l_fp_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1790: l_fp_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1791: l_fp_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1792: l_fp_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1793: l_fp_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1794: l_fp_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1795: l_ac_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1796: l_ac_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1797: l_ac_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1794: l_fp_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1790: l_fp_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1791: l_fp_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1792: l_fp_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1793: l_fp_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1794: l_fp_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1795: l_ac_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1796: l_ac_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1797: l_ac_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1798: l_ac_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1795: l_ac_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1791: l_fp_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1792: l_fp_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1793: l_fp_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1794: l_fp_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1795: l_ac_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1796: l_ac_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1797: l_ac_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1798: l_ac_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1799: l_ac_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1796: l_ac_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1792: l_fp_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1793: l_fp_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1794: l_fp_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1795: l_ac_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1796: l_ac_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1797: l_ac_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1798: l_ac_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1799: l_ac_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1800: l_ac_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1797: l_ac_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1793: l_fp_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1794: l_fp_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1795: l_ac_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1796: l_ac_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1797: l_ac_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1798: l_ac_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1799: l_ac_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1800: l_ac_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1801: l_num NUMBER;

Line 1798: l_ac_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1794: l_fp_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1795: l_ac_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1796: l_ac_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1797: l_ac_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1798: l_ac_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1799: l_ac_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1800: l_ac_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1801: l_num NUMBER;
1802: i NUMBER;

Line 1799: l_ac_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1795: l_ac_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1796: l_ac_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1797: l_ac_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1798: l_ac_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1799: l_ac_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1800: l_ac_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1801: l_num NUMBER;
1802: i NUMBER;
1803: l_PrgRollupFlag1 VARCHAR2(1);

Line 1800: l_ac_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1796: l_ac_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1797: l_ac_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1798: l_ac_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1799: l_ac_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1800: l_ac_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1801: l_num NUMBER;
1802: i NUMBER;
1803: l_PrgRollupFlag1 VARCHAR2(1);
1804: l_PrgRollupFlag2 VARCHAR2(1);

Line 1814: l_temp_excp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1810: l_backlog NUMBER;
1811: S VARCHAR2(255);
1812: l_factor_by NUMBER;
1813: l_effort_UOM NUMBER;
1814: l_temp_excp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1815: l_indirect_proj_mask NUMBER;
1816: l_contract_proj_mask NUMBER;
1817: /* Added by Ning for the pass-in pRBSRollupFlag */
1818: l_rbs_aggr_level VARCHAR2(1);

Line 1826: l_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1822: l_billing_offset NUMBER;
1823: l_seeded_measure_count NUMBER;
1824: l_hours_per_day NUMBER;
1825:
1826: l_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1827: l_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1828: l_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1829: l_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1830: l_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1827: l_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1823: l_seeded_measure_count NUMBER;
1824: l_hours_per_day NUMBER;
1825:
1826: l_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1827: l_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1828: l_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1829: l_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1830: l_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1831: l_prp_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1828: l_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1824: l_hours_per_day NUMBER;
1825:
1826: l_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1827: l_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1828: l_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1829: l_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1830: l_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1831: l_prp_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1832: l_cust_measure_number NUMBER;

Line 1829: l_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1825:
1826: l_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1827: l_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1828: l_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1829: l_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1830: l_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1831: l_prp_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1832: l_cust_measure_number NUMBER;
1833:

Line 1830: l_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1826: l_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1827: l_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1828: l_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1829: l_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1830: l_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1831: l_prp_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1832: l_cust_measure_number NUMBER;
1833:
1834: --

Line 1831: l_prp_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1827: l_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1828: l_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1829: l_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1830: l_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1831: l_prp_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1832: l_cust_measure_number NUMBER;
1833:
1834: --
1835: -- Added following local variables for bug 3898511

Line 3368: x_ptd_meaning := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

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;
3371:
3372: IF x_qtd_html IS NULL THEN

Line 3377: x_qtd_meaning := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

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;
3380:
3381: IF x_ytd_html IS NULL THEN

Line 3386: x_ytd_meaning := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

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;
3389:
3390: IF x_itd_html IS NULL THEN

Line 3395: x_itd_meaning := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

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;
3398:
3399: IF x_ac_html IS NULL THEN

Line 3404: x_ac_meaning := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

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;
3407:
3408: IF x_prp_html IS NULL THEN

Line 3413: x_prp_meaning := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

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;
3416:
3417: --FOR i IN 1..x_itd_html.last LOOP

Line 3426: x_ptd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

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

Line 3427: x_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

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

Line 3428: x_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

3424: --
3425: x_measure_type:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3426: x_ptd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3427: x_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3428: x_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3429: x_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3430: x_ac_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3431: x_prp_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3432:

Line 3429: x_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

3425: x_measure_type:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3426: x_ptd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3427: x_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3428: x_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3429: x_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3430: x_ac_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3431: x_prp_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3432:
3433: x_measure_type.EXTEND(p_measure_set_code.LAST);

Line 3430: x_ac_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

3426: x_ptd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3427: x_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3428: x_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3429: x_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3430: x_ac_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3431: x_prp_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3432:
3433: x_measure_type.EXTEND(p_measure_set_code.LAST);
3434: x_ptd_value.EXTEND(p_measure_set_code.LAST);

Line 3431: x_prp_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

3427: x_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3428: x_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3429: x_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3430: x_ac_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3431: x_prp_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3432:
3433: x_measure_type.EXTEND(p_measure_set_code.LAST);
3434: x_ptd_value.EXTEND(p_measure_set_code.LAST);
3435: x_qtd_value.EXTEND(p_measure_set_code.LAST);

Line 3441: l_ptd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

3437: x_itd_value.EXTEND(p_measure_set_code.LAST);
3438: x_ac_value.EXTEND(p_measure_set_code.LAST);
3439: x_prp_value.EXTEND(p_measure_set_code.LAST);
3440:
3441: l_ptd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3442: l_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3443: l_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3444: l_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3445: l_ac_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

Line 3442: l_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

3438: x_ac_value.EXTEND(p_measure_set_code.LAST);
3439: x_prp_value.EXTEND(p_measure_set_code.LAST);
3440:
3441: l_ptd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3442: l_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3443: l_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3444: l_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3445: l_ac_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3446: l_prp_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

Line 3443: l_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

3439: x_prp_value.EXTEND(p_measure_set_code.LAST);
3440:
3441: l_ptd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3442: l_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3443: l_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3444: l_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3445: l_ac_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3446: l_prp_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3447:

Line 3444: l_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

3440:
3441: l_ptd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3442: l_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3443: l_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3444: l_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3445: l_ac_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3446: l_prp_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3447:
3448: l_ptd_value.EXTEND(p_measure_set_code.LAST);

Line 3445: l_ac_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

3441: l_ptd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3442: l_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3443: l_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3444: l_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3445: l_ac_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3446: l_prp_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3447:
3448: l_ptd_value.EXTEND(p_measure_set_code.LAST);
3449: l_qtd_value.EXTEND(p_measure_set_code.LAST);

Line 3446: l_prp_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

3442: l_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3443: l_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3444: l_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3445: l_ac_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3446: l_prp_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3447:
3448: l_ptd_value.EXTEND(p_measure_set_code.LAST);
3449: l_qtd_value.EXTEND(p_measure_set_code.LAST);
3450: l_ytd_value.EXTEND(p_measure_set_code.LAST);