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 592: p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE

588:
589:
590: PROCEDURE Get_Measure_Labels
591: (
592: p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
593: , p_measure_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE
594: , x_return_status OUT NOCOPY VARCHAR2
595: , x_msg_count OUT NOCOPY NUMBER
596: , x_msg_data OUT NOCOPY VARCHAR2

Line 652: p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE

648: END Get_Measure_Labels;
649:
650: PROCEDURE Get_Measure_Attributes
651: (
652: p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
653: , x_measure_set_codes_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
654: , x_timeslices_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
655: , x_measure_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
656: , x_return_status OUT NOCOPY VARCHAR2

Line 741: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE

737:
738: PROCEDURE Get_Financial_Measures
739: (
740: p_project_id NUMBER
741: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
742: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
743: , p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
744: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
745: , x_measure_values_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 745: , x_measure_values_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

741: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
742: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
743: , p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
744: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
745: , x_measure_values_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
746: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
747: --, x_exception_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE
748: , x_return_status OUT NOCOPY VARCHAR2
749: , x_msg_count OUT NOCOPY NUMBER

Line 763: l_ptd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

759: i NUMBER;
760: l_measure_set_codes_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
761: l_timeslices_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
762: l_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
763: l_ptd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
764: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
765: l_ytd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
766: l_itd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
767: l_ac_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 764: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

760: l_measure_set_codes_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
761: l_timeslices_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
762: l_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
763: l_ptd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
764: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
765: l_ytd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
766: l_itd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
767: l_ac_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
768: l_prp_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 765: l_ytd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

761: l_timeslices_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
762: l_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
763: l_ptd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
764: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
765: l_ytd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
766: l_itd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
767: l_ac_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
768: l_prp_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
769: l_ptd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 766: l_itd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

762: l_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
763: l_ptd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
764: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
765: l_ytd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
766: l_itd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
767: l_ac_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
768: l_prp_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
769: l_ptd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
770: l_qtd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 767: l_ac_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

763: l_ptd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
764: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
765: l_ytd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
766: l_itd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
767: l_ac_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
768: l_prp_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
769: l_ptd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
770: l_qtd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
771: l_ytd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 768: l_prp_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

764: l_qtd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
765: l_ytd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
766: l_itd_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
767: l_ac_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
768: l_prp_values SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
769: l_ptd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
770: l_qtd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
771: l_ytd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
772: l_itd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 781: l_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

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

Line 782: l_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

778: l_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
779: l_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
780: l_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
781: l_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
782: l_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
783: l_qtd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
784: l_itd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
785: l_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
786: l_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 783: l_qtd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

779: l_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
780: l_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
781: l_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
782: l_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
783: l_qtd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
784: l_itd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
785: l_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
786: l_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
787: l_WBS_Version_ID NUMBER;

Line 784: l_itd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

780: l_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
781: l_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
782: l_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
783: l_qtd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
784: l_itd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
785: l_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
786: l_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
787: l_WBS_Version_ID NUMBER;
788: l_WBS_Element_Id NUMBER;

Line 785: l_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

781: l_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
782: l_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
783: l_qtd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
784: l_itd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
785: l_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
786: l_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
787: l_WBS_Version_ID NUMBER;
788: l_WBS_Element_Id NUMBER;
789: l_RBS_Version_ID NUMBER;

Line 786: l_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

782: l_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
783: l_qtd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
784: l_itd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
785: l_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
786: l_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
787: l_WBS_Version_ID NUMBER;
788: l_WBS_Element_Id NUMBER;
789: l_RBS_Version_ID NUMBER;
790: l_RBS_Element_Id NUMBER;

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

846:
847:
848: l_measure_set_codes_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
849: l_timeslices_tbl := SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
850: x_measure_values_tbl := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
851: x_exception_indicator_tbl := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
852: l_measure_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
853: --x_exception_labels_tbl := SYSTEM.PA_VARCHAR2_240_TBL_TYPE();
854:

Line 1081: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE

1077: --
1078: PROCEDURE Get_Activity_Measures
1079: (
1080: p_project_id NUMBER
1081: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1082: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
1083: , p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
1084: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
1085: , x_measure_values_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 1085: , x_measure_values_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

1081: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1082: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
1083: , p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
1084: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
1085: , x_measure_values_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1086: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1087: --, x_exception_labels_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_240_TBL_TYPE
1088: , x_return_status OUT NOCOPY VARCHAR2
1089: , x_msg_count OUT NOCOPY NUMBER

Line 1471: x_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1467:
1468: x_measure_set_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1469: x_measure_name SYSTEM.PA_VARCHAR2_240_TBL_TYPE;
1470: x_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1471: x_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1472: x_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1473: x_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1474: x_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1475: x_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1472: x_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1468: x_measure_set_code SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1469: x_measure_name SYSTEM.PA_VARCHAR2_240_TBL_TYPE;
1470: x_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1471: x_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1472: x_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1473: x_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1474: x_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1475: x_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1476: x_prp_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1473: x_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1469: x_measure_name SYSTEM.PA_VARCHAR2_240_TBL_TYPE;
1470: x_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1471: x_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1472: x_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1473: x_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1474: x_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1475: x_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1476: x_prp_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1477: x_ptd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 1474: x_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1470: x_measure_type SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1471: x_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1472: x_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1473: x_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1474: x_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1475: x_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1476: x_prp_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1477: x_ptd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1478: x_qtd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 1475: x_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1471: x_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1472: x_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1473: x_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1474: x_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1475: x_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1476: x_prp_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1477: x_ptd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1478: x_qtd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1479: x_ytd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 1476: x_prp_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1472: x_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1473: x_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1474: x_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1475: x_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1476: x_prp_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1477: x_ptd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1478: x_qtd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1479: x_ytd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1480: x_itd_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 1489: x_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

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

Line 1490: x_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1486: x_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1487: x_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1488: x_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1489: x_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1490: x_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1491: x_qtd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1492: x_itd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1493: x_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1494: x_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1491: x_qtd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1487: x_ac_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1488: x_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1489: x_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1490: x_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1491: x_qtd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1492: x_itd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1493: x_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1494: x_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1495:

Line 1492: x_itd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1488: x_prp_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1489: x_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1490: x_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1491: x_qtd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1492: x_itd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1493: x_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1494: x_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1495:
1496: l_exception_indicator_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 1493: x_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1489: x_ptd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1490: x_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1491: x_qtd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1492: x_itd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1493: x_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1494: x_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1495:
1496: l_exception_indicator_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1497: l_sql_errm VARCHAR2(255);

Line 1494: x_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1490: x_ytd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1491: x_qtd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1492: x_itd_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1493: x_ac_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1494: x_prp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1495:
1496: l_exception_indicator_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1497: l_sql_errm VARCHAR2(255);
1498:

Line 1699: , x_ptd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

1695: , pCallingType VARCHAR2
1696: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
1697: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1698: , x_measure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1699: , x_ptd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1700: , x_qtd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1701: , x_ytd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1702: , x_itd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1703: , x_ac_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 1700: , x_qtd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

1696: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
1697: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1698: , x_measure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1699: , x_ptd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1700: , x_qtd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1701: , x_ytd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1702: , x_itd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1703: , x_ac_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1704: , x_prp_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 1701: , x_ytd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

1697: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1698: , x_measure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1699: , x_ptd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1700: , x_qtd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1701: , x_ytd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1702: , x_itd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1703: , x_ac_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1704: , x_prp_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1705: , x_ptd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

Line 1702: , x_itd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

1698: , x_measure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1699: , x_ptd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1700: , x_qtd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1701: , x_ytd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1702: , x_itd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1703: , x_ac_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1704: , x_prp_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1705: , x_ptd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1706: , x_qtd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

Line 1703: , x_ac_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

1699: , x_ptd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1700: , x_qtd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1701: , x_ytd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1702: , x_itd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1703: , x_ac_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1704: , x_prp_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1705: , x_ptd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1706: , x_qtd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1707: , x_ytd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

Line 1704: , x_prp_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

1700: , x_qtd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1701: , x_ytd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1702: , x_itd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1703: , x_ac_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1704: , x_prp_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1705: , x_ptd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1706: , x_qtd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1707: , x_ytd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1708: , x_itd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

Line 1717: , x_ptd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

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

Line 1718: , x_ytd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

1714: , x_itd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1715: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1716: , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1717: , x_ptd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1718: , x_ytd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1719: , x_qtd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1720: , x_itd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1721: , x_ac_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1722: , x_prp_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 1719: , x_qtd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

1715: , x_ac_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1716: , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1717: , x_ptd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1718: , x_ytd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1719: , x_qtd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1720: , x_itd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1721: , x_ac_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1722: , x_prp_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1723: , xDaysSinceITD OUT NOCOPY NUMBER

Line 1720: , x_itd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

1716: , x_prp_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1717: , x_ptd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1718: , x_ytd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1719: , x_qtd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1720: , x_itd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1721: , x_ac_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1722: , x_prp_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1723: , xDaysSinceITD OUT NOCOPY NUMBER
1724: , xDaysInPeriod OUT NOCOPY NUMBER

Line 1721: , x_ac_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

1717: , x_ptd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1718: , x_ytd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1719: , x_qtd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1720: , x_itd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1721: , x_ac_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1722: , x_prp_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1723: , xDaysSinceITD OUT NOCOPY NUMBER
1724: , xDaysInPeriod OUT NOCOPY NUMBER
1725: , x_return_status IN OUT NOCOPY VARCHAR2

Line 1722: , x_prp_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

1718: , x_ytd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1719: , x_qtd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1720: , x_itd_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1721: , x_ac_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1722: , x_prp_meaning OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1723: , xDaysSinceITD OUT NOCOPY NUMBER
1724: , xDaysInPeriod OUT NOCOPY NUMBER
1725: , x_return_status IN OUT NOCOPY VARCHAR2
1726: , x_msg_count IN OUT NOCOPY NUMBER

Line 1796: l_fp_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1792: l_ac_custom_measures_ac SYSTEM.PA_Num_Tbl_Type;
1793: l_ac_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1794: l_fp_cus_meas_formats SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1795: l_ac_cus_meas_formats SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1796: l_fp_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1797: l_fp_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1798: l_fp_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1799: l_fp_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1800: l_fp_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1797: l_fp_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1793: l_ac_custom_measures_prp SYSTEM.PA_Num_Tbl_Type;
1794: l_fp_cus_meas_formats SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1795: l_ac_cus_meas_formats SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1796: l_fp_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1797: l_fp_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1798: l_fp_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1799: l_fp_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1800: l_fp_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1801: l_fp_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1798: l_fp_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1794: l_fp_cus_meas_formats SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1795: l_ac_cus_meas_formats SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1796: l_fp_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1797: l_fp_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1798: l_fp_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1799: l_fp_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1800: l_fp_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1801: l_fp_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1802: l_ac_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1799: l_fp_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1795: l_ac_cus_meas_formats SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
1796: l_fp_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1797: l_fp_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1798: l_fp_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1799: l_fp_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1800: l_fp_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1801: l_fp_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1802: l_ac_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1803: l_ac_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1800: l_fp_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1796: l_fp_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1797: l_fp_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1798: l_fp_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1799: l_fp_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1800: l_fp_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1801: l_fp_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1802: l_ac_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1803: l_ac_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1804: l_ac_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1801: l_fp_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1797: l_fp_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1798: l_fp_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1799: l_fp_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1800: l_fp_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1801: l_fp_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1802: l_ac_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1803: l_ac_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1804: l_ac_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1805: l_ac_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1802: l_ac_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1798: l_fp_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1799: l_fp_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1800: l_fp_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1801: l_fp_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1802: l_ac_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1803: l_ac_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1804: l_ac_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1805: l_ac_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1806: l_ac_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1803: l_ac_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1799: l_fp_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1800: l_fp_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1801: l_fp_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1802: l_ac_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1803: l_ac_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1804: l_ac_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1805: l_ac_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1806: l_ac_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1807: l_ac_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1804: l_ac_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1800: l_fp_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1801: l_fp_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1802: l_ac_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1803: l_ac_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1804: l_ac_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1805: l_ac_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1806: l_ac_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1807: l_ac_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1808: l_num NUMBER;

Line 1805: l_ac_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1801: l_fp_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1802: l_ac_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1803: l_ac_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1804: l_ac_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1805: l_ac_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1806: l_ac_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1807: l_ac_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1808: l_num NUMBER;
1809: i NUMBER;

Line 1806: l_ac_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1802: l_ac_custom_measures_ptd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1803: l_ac_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1804: l_ac_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1805: l_ac_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1806: l_ac_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1807: l_ac_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1808: l_num NUMBER;
1809: i NUMBER;
1810: l_PrgRollupFlag1 VARCHAR2(1);

Line 1807: l_ac_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1803: l_ac_custom_measures_qtd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1804: l_ac_custom_measures_ytd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1805: l_ac_custom_measures_itd_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1806: l_ac_custom_measures_ac_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1807: l_ac_custom_measures_prp_char SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1808: l_num NUMBER;
1809: i NUMBER;
1810: l_PrgRollupFlag1 VARCHAR2(1);
1811: l_PrgRollupFlag2 VARCHAR2(1);

Line 1821: l_temp_excp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1817: l_backlog NUMBER;
1818: S VARCHAR2(255);
1819: l_factor_by NUMBER;
1820: l_effort_UOM NUMBER;
1821: l_temp_excp_meaning SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1822: l_indirect_proj_mask NUMBER;
1823: l_contract_proj_mask NUMBER;
1824: /* Added by Ning for the pass-in pRBSRollupFlag */
1825: l_rbs_aggr_level VARCHAR2(1);

Line 1833: l_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1829: l_billing_offset NUMBER;
1830: l_seeded_measure_count NUMBER;
1831: l_hours_per_day NUMBER;
1832:
1833: l_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1834: l_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1835: l_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1836: l_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1837: l_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1834: l_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1830: l_seeded_measure_count NUMBER;
1831: l_hours_per_day NUMBER;
1832:
1833: l_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1834: l_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1835: l_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1836: l_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1837: l_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1838: l_prp_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

Line 1835: l_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1831: l_hours_per_day NUMBER;
1832:
1833: l_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1834: l_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1835: l_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1836: l_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1837: l_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1838: l_prp_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1839: l_cust_measure_number NUMBER;

Line 1836: l_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1832:
1833: l_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1834: l_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1835: l_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1836: l_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1837: l_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1838: l_prp_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1839: l_cust_measure_number NUMBER;
1840:

Line 1837: l_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1833: l_ptd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1834: l_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1835: l_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1836: l_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1837: l_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1838: l_prp_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1839: l_cust_measure_number NUMBER;
1840:
1841: --

Line 1838: l_prp_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

1834: l_qtd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1835: l_ytd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1836: l_itd_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1837: l_ac_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1838: l_prp_value SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
1839: l_cust_measure_number NUMBER;
1840:
1841: --
1842: -- Added following local variables for bug 3898511

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

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

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

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

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

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

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

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

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

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

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

3416: x_prp_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3417: x_prp_html.EXTEND(p_measure_set_code.LAST);
3418: x_prp_trans_id := SYSTEM.pa_NUM_TBL_TYPE();
3419: x_prp_trans_id.extend(p_measure_set_code.LAST);
3420: x_prp_meaning := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3421: x_prp_meaning.extend(p_measure_set_code.LAST);
3422: END IF;
3423:
3424: --FOR i IN 1..x_itd_html.last LOOP

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

3429: --
3430: -- initialize all the remaining output collections
3431: --
3432: x_measure_type:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3433: x_ptd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3434: x_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3435: x_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3436: x_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3437: x_ac_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

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

3430: -- initialize all the remaining output collections
3431: --
3432: x_measure_type:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3433: x_ptd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3434: x_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3435: x_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3436: x_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3437: x_ac_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3438: x_prp_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

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

3431: --
3432: x_measure_type:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3433: x_ptd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3434: x_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3435: x_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3436: x_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3437: x_ac_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3438: x_prp_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3439:

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

3432: x_measure_type:= SYSTEM.PA_VARCHAR2_30_TBL_TYPE();
3433: x_ptd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3434: x_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3435: x_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3436: x_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3437: x_ac_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3438: x_prp_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3439:
3440: x_measure_type.EXTEND(p_measure_set_code.LAST);

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

3433: x_ptd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3434: x_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3435: x_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3436: x_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3437: x_ac_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3438: x_prp_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3439:
3440: x_measure_type.EXTEND(p_measure_set_code.LAST);
3441: x_ptd_value.EXTEND(p_measure_set_code.LAST);

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

3434: x_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3435: x_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3436: x_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3437: x_ac_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3438: x_prp_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3439:
3440: x_measure_type.EXTEND(p_measure_set_code.LAST);
3441: x_ptd_value.EXTEND(p_measure_set_code.LAST);
3442: x_qtd_value.EXTEND(p_measure_set_code.LAST);

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

3444: x_itd_value.EXTEND(p_measure_set_code.LAST);
3445: x_ac_value.EXTEND(p_measure_set_code.LAST);
3446: x_prp_value.EXTEND(p_measure_set_code.LAST);
3447:
3448: l_ptd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3449: l_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3450: l_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3451: l_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3452: l_ac_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

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

3445: x_ac_value.EXTEND(p_measure_set_code.LAST);
3446: x_prp_value.EXTEND(p_measure_set_code.LAST);
3447:
3448: l_ptd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3449: l_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3450: l_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3451: l_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3452: l_ac_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3453: l_prp_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

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

3446: x_prp_value.EXTEND(p_measure_set_code.LAST);
3447:
3448: l_ptd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3449: l_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3450: l_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3451: l_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3452: l_ac_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3453: l_prp_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3454:

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

3447:
3448: l_ptd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3449: l_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3450: l_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3451: l_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3452: l_ac_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3453: l_prp_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3454:
3455: l_ptd_value.EXTEND(p_measure_set_code.LAST);

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

3448: l_ptd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3449: l_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3450: l_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3451: l_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3452: l_ac_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3453: l_prp_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3454:
3455: l_ptd_value.EXTEND(p_measure_set_code.LAST);
3456: l_qtd_value.EXTEND(p_measure_set_code.LAST);

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

3449: l_qtd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3450: l_ytd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3451: l_itd_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3452: l_ac_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3453: l_prp_value := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
3454:
3455: l_ptd_value.EXTEND(p_measure_set_code.LAST);
3456: l_qtd_value.EXTEND(p_measure_set_code.LAST);
3457: l_ytd_value.EXTEND(p_measure_set_code.LAST);

Line 10013: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE

10009: */
10010: PROCEDURE Get_Financial_Measures_wrp
10011: (
10012: p_project_id_tbl IN SYSTEM.pa_num_tbl_type
10013: , p_measure_codes_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE
10014: , p_measure_set_codes_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
10015: , p_timeslices_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT NULL
10016: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
10017: , x_measure_values_tbl OUT NOCOPY SYSTEM.PJI_FIN_MEAS_REC_TBL_TYPE

Line 10032: l_measure_values_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE;

10028: l_sec_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
10029: l_sec_msg_count NUMBER := 0;
10030: l_sec_msg_data VARCHAR2(1) := NULL;
10031:
10032: l_measure_values_tbl SYSTEM.PA_VARCHAR2_80_TBL_TYPE;
10033: l_exception_indicator_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
10034:
10035: l_pji_fin_meas_rec SYSTEM.PJI_FIN_MEAS_REC;
10036: l_pji_fin_meas_rec_tbl SYSTEM.PJI_FIN_MEAS_REC_TBL_TYPE ;

Line 10071: l_measure_values_tbl := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

10067: --------------
10068:
10069: FOR i IN l_project_id_tbl.FIRST .. l_project_id_tbl.LAST LOOP
10070:
10071: l_measure_values_tbl := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();
10072: l_exception_indicator_tbl := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
10073:
10074: x_sec_ret_code := 'F';
10075: