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_2000_TBL_TYPE

Line 144: l_ptd_html SYSTEM.PA_VARCHAR2_2000_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;
148: l_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 145: l_qtd_html SYSTEM.PA_VARCHAR2_2000_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;
148: l_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
149: l_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 146: l_ytd_html SYSTEM.PA_VARCHAR2_2000_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;
148: l_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
149: l_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
150:

Line 147: l_itd_html SYSTEM.PA_VARCHAR2_2000_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;
148: l_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
149: l_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
150:
151: l_project_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;

Line 148: l_ac_html SYSTEM.PA_VARCHAR2_2000_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;
148: l_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
149: l_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
150:
151: l_project_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
152: l_calendar_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 149: l_prp_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;
148: l_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
149: l_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
150:
151: l_project_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
152: l_calendar_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
153: l_currency_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;

Line 154: l_rowids_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

150:
151: l_project_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
152: l_calendar_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
153: l_currency_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE;
154: l_rowids_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
155: l_measure_ids_tbl SYSTEM.PA_NUM_TBL_TYPE;
156: l_measure_values_tbl SYSTEM.PA_NUM_TBL_TYPE;
157:
158: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 173: l_exception_indicator_tbl SYSTEM.PA_VARCHAR2_2000_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;
175: l_i NUMBER;
176: x NUMBER;
177:

Line 746: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_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
750: , x_msg_data OUT NOCOPY VARCHAR2 -- not used

Line 769: l_ptd_html SYSTEM.PA_VARCHAR2_2000_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;
773: l_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 770: l_qtd_html SYSTEM.PA_VARCHAR2_2000_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;
773: l_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
774: l_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 771: l_ytd_html SYSTEM.PA_VARCHAR2_2000_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;
773: l_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
774: l_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
775: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 772: l_itd_html SYSTEM.PA_VARCHAR2_2000_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;
773: l_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
774: l_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
775: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
776: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 773: l_ac_html SYSTEM.PA_VARCHAR2_2000_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;
773: l_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
774: l_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
775: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
776: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
777: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 774: l_prp_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;
773: l_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
774: l_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
775: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
776: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
777: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
778: l_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 851: x_exception_indicator_tbl := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

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:
855: IF p_measure_codes_tbl.LAST < 1 THEN

Line 1024: x_exception_indicator_tbl := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

1020:
1021: x_measure_values_tbl.EXTEND(l_measure_set_codes_tbl.LAST);
1022: --Bug 5088377 Initialize the collection before extending
1023: IF (x_exception_indicator_tbl is NULL) THEN
1024: x_exception_indicator_tbl := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
1025: END IF;
1026: x_exception_indicator_tbl.EXTEND(l_measure_set_codes_tbl.LAST);
1027: --x_exception_labels_tbl.EXTEND(l_measure_set_code.LAST);
1028:

Line 1086: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_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
1090: , x_msg_data OUT NOCOPY VARCHAR2

Line 1477: x_ptd_html SYSTEM.PA_VARCHAR2_2000_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;
1481: x_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 1478: x_qtd_html SYSTEM.PA_VARCHAR2_2000_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;
1481: x_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1482: x_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 1479: x_ytd_html SYSTEM.PA_VARCHAR2_2000_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;
1481: x_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1482: x_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1483: x_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 1480: x_itd_html SYSTEM.PA_VARCHAR2_2000_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;
1481: x_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1482: x_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1483: x_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1484: x_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 1481: x_ac_html SYSTEM.PA_VARCHAR2_2000_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;
1481: x_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1482: x_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1483: x_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1484: x_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1485: x_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 1482: x_prp_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;
1481: x_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1482: x_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1483: x_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1484: x_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1485: x_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1486: x_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 1496: l_exception_indicator_tbl SYSTEM.PA_VARCHAR2_2000_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:
1499: BEGIN
1500: NULL;

Line 1697: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

1693: , pWBSRollupFlag VARCHAR2 DEFAULT 'Y'
1694: , pRBSRollupFlag VARCHAR2 DEFAULT 'Y'
1695: , pCallingType VARCHAR2
1696: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
1697: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1698: , x_measure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1699: , x_ptd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1700: , x_qtd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1701: , x_ytd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

Line 1705: , x_ptd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_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
1709: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

Line 1706: , x_qtd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_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
1709: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1710: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

Line 1707: , x_ytd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_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
1709: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1710: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1711: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 1708: , x_itd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_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
1709: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1710: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1711: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1712: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 1709: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_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
1709: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1710: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1711: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1712: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1713: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 1710: , x_prp_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
1709: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1710: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1711: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1712: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1713: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1714: , x_itd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 3371: x_ptd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

3367: -- output collections long as the p_measure_set_code input collection.
3368: --
3369:
3370: IF x_ptd_html IS NULL THEN
3371: x_ptd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3372: x_ptd_html.EXTEND(p_measure_set_code.LAST);
3373: x_ptd_trans_id := SYSTEM.pa_NUM_TBL_TYPE();
3374: x_ptd_trans_id.extend(p_measure_set_code.LAST);
3375: x_ptd_meaning := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

Line 3380: x_qtd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

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

Line 3389: x_ytd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

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

Line 3398: x_itd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

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

Line 3407: x_ac_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

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

Line 3416: x_prp_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

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

Line 3462: /*x_qtd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

3458: l_itd_value.EXTEND(p_measure_set_code.LAST);
3459: l_ac_value.EXTEND(p_measure_set_code.LAST);
3460: l_prp_value.EXTEND(p_measure_set_code.LAST);
3461:
3462: /*x_qtd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3463: x_ytd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3464: x_ac_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3465: x_prp_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3466: x_qtd_html.EXTEND(p_measure_set_code.LAST);

Line 3463: x_ytd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

3459: l_ac_value.EXTEND(p_measure_set_code.LAST);
3460: l_prp_value.EXTEND(p_measure_set_code.LAST);
3461:
3462: /*x_qtd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3463: x_ytd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3464: x_ac_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3465: x_prp_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3466: x_qtd_html.EXTEND(p_measure_set_code.LAST);
3467: x_ytd_html.EXTEND(p_measure_set_code.LAST);

Line 3464: x_ac_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

3460: l_prp_value.EXTEND(p_measure_set_code.LAST);
3461:
3462: /*x_qtd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3463: x_ytd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3464: x_ac_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3465: x_prp_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3466: x_qtd_html.EXTEND(p_measure_set_code.LAST);
3467: x_ytd_html.EXTEND(p_measure_set_code.LAST);
3468: x_ac_html.EXTEND(p_measure_set_code.LAST);

Line 3465: x_prp_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

3461:
3462: /*x_qtd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3463: x_ytd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3464: x_ac_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3465: x_prp_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3466: x_qtd_html.EXTEND(p_measure_set_code.LAST);
3467: x_ytd_html.EXTEND(p_measure_set_code.LAST);
3468: x_ac_html.EXTEND(p_measure_set_code.LAST);
3469: x_prp_html.EXTEND(p_measure_set_code.LAST);

Line 10033: l_exception_indicator_tbl SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

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 ;
10037:

Line 10072: l_exception_indicator_tbl := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();

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:
10076: PA_SECURITY_PVT.check_user_privilege