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

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

Line 763: l_qtd_html SYSTEM.PA_VARCHAR2_2000_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;
766: l_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
767: l_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 764: l_ytd_html SYSTEM.PA_VARCHAR2_2000_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;
766: l_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
767: l_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
768: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 765: l_itd_html SYSTEM.PA_VARCHAR2_2000_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;
766: l_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
767: l_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
768: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
769: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 766: l_ac_html SYSTEM.PA_VARCHAR2_2000_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;
766: l_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
767: l_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
768: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
769: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
770: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 767: l_prp_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;
766: l_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
767: l_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
768: l_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
769: l_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
770: l_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
771: l_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

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

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

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

1013:
1014: x_measure_values_tbl.EXTEND(l_measure_set_codes_tbl.LAST);
1015: --Bug 5088377 Initialize the collection before extending
1016: IF (x_exception_indicator_tbl is NULL) THEN
1017: x_exception_indicator_tbl := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
1018: END IF;
1019: x_exception_indicator_tbl.EXTEND(l_measure_set_codes_tbl.LAST);
1020: --x_exception_labels_tbl.EXTEND(l_measure_set_code.LAST);
1021:

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

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

Line 1471: x_qtd_html SYSTEM.PA_VARCHAR2_2000_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;
1474: x_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1475: x_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;

Line 1472: x_ytd_html SYSTEM.PA_VARCHAR2_2000_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;
1474: x_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1475: x_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1476: x_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 1473: x_itd_html SYSTEM.PA_VARCHAR2_2000_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;
1474: x_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1475: x_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1476: x_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1477: x_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 1474: x_ac_html SYSTEM.PA_VARCHAR2_2000_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;
1474: x_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1475: x_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1476: x_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1477: x_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1478: x_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 1475: x_prp_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;
1474: x_ac_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1475: x_prp_html SYSTEM.PA_VARCHAR2_2000_TBL_TYPE;
1476: x_ptd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1477: x_ytd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1478: x_qtd_trans_id SYSTEM.PA_NUM_TBL_TYPE;
1479: x_itd_trans_id SYSTEM.PA_NUM_TBL_TYPE;

Line 1489: l_exception_indicator_tbl SYSTEM.PA_VARCHAR2_2000_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:
1492: BEGIN
1493: NULL;

Line 1690: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

1686: , pWBSRollupFlag VARCHAR2 DEFAULT 'Y'
1687: , pRBSRollupFlag VARCHAR2 DEFAULT 'Y'
1688: , pCallingType VARCHAR2
1689: , p_measure_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT NULL
1690: , x_exception_indicator_tbl OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1691: , x_measure_type OUT NOCOPY SYSTEM.PA_VARCHAR2_30_TBL_TYPE
1692: , x_ptd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1693: , x_qtd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE
1694: , x_ytd_value OUT NOCOPY SYSTEM.PA_VARCHAR2_80_TBL_TYPE

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

Line 1699: , x_qtd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_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
1702: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1703: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE

Line 1700: , x_ytd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_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
1702: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1703: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1704: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 1701: , x_itd_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_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
1702: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1703: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1704: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1705: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 1702: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_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
1702: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1703: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1704: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1705: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1706: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

Line 1703: , x_prp_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
1702: , x_ac_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1703: , x_prp_html OUT NOCOPY SYSTEM.PA_VARCHAR2_2000_TBL_TYPE
1704: , x_ptd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1705: , x_ytd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1706: , x_qtd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE
1707: , x_itd_trans_id OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE

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

3360: -- output collections long as the p_measure_set_code input collection.
3361: --
3362:
3363: IF x_ptd_html IS NULL THEN
3364: x_ptd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3365: x_ptd_html.EXTEND(p_measure_set_code.LAST);
3366: x_ptd_trans_id := SYSTEM.pa_NUM_TBL_TYPE();
3367: x_ptd_trans_id.extend(p_measure_set_code.LAST);
3368: x_ptd_meaning := SYSTEM.PA_VARCHAR2_80_TBL_TYPE();

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

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

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

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

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

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

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

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

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

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

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

3451: l_itd_value.EXTEND(p_measure_set_code.LAST);
3452: l_ac_value.EXTEND(p_measure_set_code.LAST);
3453: l_prp_value.EXTEND(p_measure_set_code.LAST);
3454:
3455: /*x_qtd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3456: x_ytd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3457: x_ac_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3458: x_prp_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3459: x_qtd_html.EXTEND(p_measure_set_code.LAST);

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

3452: l_ac_value.EXTEND(p_measure_set_code.LAST);
3453: l_prp_value.EXTEND(p_measure_set_code.LAST);
3454:
3455: /*x_qtd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3456: x_ytd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3457: x_ac_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3458: x_prp_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3459: x_qtd_html.EXTEND(p_measure_set_code.LAST);
3460: x_ytd_html.EXTEND(p_measure_set_code.LAST);

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

3453: l_prp_value.EXTEND(p_measure_set_code.LAST);
3454:
3455: /*x_qtd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3456: x_ytd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3457: x_ac_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3458: x_prp_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3459: x_qtd_html.EXTEND(p_measure_set_code.LAST);
3460: x_ytd_html.EXTEND(p_measure_set_code.LAST);
3461: x_ac_html.EXTEND(p_measure_set_code.LAST);

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

3454:
3455: /*x_qtd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3456: x_ytd_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3457: x_ac_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3458: x_prp_html := SYSTEM.PA_VARCHAR2_2000_TBL_TYPE();
3459: x_qtd_html.EXTEND(p_measure_set_code.LAST);
3460: x_ytd_html.EXTEND(p_measure_set_code.LAST);
3461: x_ac_html.EXTEND(p_measure_set_code.LAST);
3462: x_prp_html.EXTEND(p_measure_set_code.LAST);