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.AHL_FMP_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_pvt.mr_item_instance_tbl_type, a0 JTF_VARCHAR2_TABLE_100

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_pvt.mr_item_instance_tbl_type, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_4000
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_400

Line 17: , a1 JTF_VARCHAR2_TABLE_100

13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_pvt.mr_item_instance_tbl_type, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_4000
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_400
21: , a5 JTF_VARCHAR2_TABLE_300

Line 19: , a3 JTF_VARCHAR2_TABLE_100

15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_pvt.mr_item_instance_tbl_type, a0 JTF_VARCHAR2_TABLE_100
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_4000
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_400
21: , a5 JTF_VARCHAR2_TABLE_300
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_NUMBER_TABLE

Line 22: , a6 JTF_VARCHAR2_TABLE_100

18: , a2 JTF_VARCHAR2_TABLE_4000
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_400
21: , a5 JTF_VARCHAR2_TABLE_300
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE

Line 27: , a11 JTF_VARCHAR2_TABLE_100

23: , a7 JTF_NUMBER_TABLE
24: , a8 JTF_NUMBER_TABLE
25: , a9 JTF_NUMBER_TABLE
26: , a10 JTF_NUMBER_TABLE
27: , a11 JTF_VARCHAR2_TABLE_100
28: ) as
29: ddindx binary_integer; indx binary_integer;
30: begin
31: if a0 is not null and a0.count > 0 then

Line 57: procedure rosetta_table_copy_out_p1(t ahl_fmp_pvt.mr_item_instance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

53: end loop;
54: end if;
55: end if;
56: end rosetta_table_copy_in_p1;
57: procedure rosetta_table_copy_out_p1(t ahl_fmp_pvt.mr_item_instance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
58: , a1 out nocopy JTF_VARCHAR2_TABLE_100
59: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
60: , a3 out nocopy JTF_VARCHAR2_TABLE_100
61: , a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 58: , a1 out nocopy JTF_VARCHAR2_TABLE_100

54: end if;
55: end if;
56: end rosetta_table_copy_in_p1;
57: procedure rosetta_table_copy_out_p1(t ahl_fmp_pvt.mr_item_instance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
58: , a1 out nocopy JTF_VARCHAR2_TABLE_100
59: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
60: , a3 out nocopy JTF_VARCHAR2_TABLE_100
61: , a4 out nocopy JTF_VARCHAR2_TABLE_400
62: , a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 60: , a3 out nocopy JTF_VARCHAR2_TABLE_100

56: end rosetta_table_copy_in_p1;
57: procedure rosetta_table_copy_out_p1(t ahl_fmp_pvt.mr_item_instance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
58: , a1 out nocopy JTF_VARCHAR2_TABLE_100
59: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
60: , a3 out nocopy JTF_VARCHAR2_TABLE_100
61: , a4 out nocopy JTF_VARCHAR2_TABLE_400
62: , a5 out nocopy JTF_VARCHAR2_TABLE_300
63: , a6 out nocopy JTF_VARCHAR2_TABLE_100
64: , a7 out nocopy JTF_NUMBER_TABLE

Line 63: , a6 out nocopy JTF_VARCHAR2_TABLE_100

59: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
60: , a3 out nocopy JTF_VARCHAR2_TABLE_100
61: , a4 out nocopy JTF_VARCHAR2_TABLE_400
62: , a5 out nocopy JTF_VARCHAR2_TABLE_300
63: , a6 out nocopy JTF_VARCHAR2_TABLE_100
64: , a7 out nocopy JTF_NUMBER_TABLE
65: , a8 out nocopy JTF_NUMBER_TABLE
66: , a9 out nocopy JTF_NUMBER_TABLE
67: , a10 out nocopy JTF_NUMBER_TABLE

Line 68: , a11 out nocopy JTF_VARCHAR2_TABLE_100

64: , a7 out nocopy JTF_NUMBER_TABLE
65: , a8 out nocopy JTF_NUMBER_TABLE
66: , a9 out nocopy JTF_NUMBER_TABLE
67: , a10 out nocopy JTF_NUMBER_TABLE
68: , a11 out nocopy JTF_VARCHAR2_TABLE_100
69: ) as
70: ddindx binary_integer; indx binary_integer;
71: begin
72: if t is null or t.count = 0 then

Line 73: a0 := JTF_VARCHAR2_TABLE_100();

69: ) as
70: ddindx binary_integer; indx binary_integer;
71: begin
72: if t is null or t.count = 0 then
73: a0 := JTF_VARCHAR2_TABLE_100();
74: a1 := JTF_VARCHAR2_TABLE_100();
75: a2 := JTF_VARCHAR2_TABLE_4000();
76: a3 := JTF_VARCHAR2_TABLE_100();
77: a4 := JTF_VARCHAR2_TABLE_400();

Line 74: a1 := JTF_VARCHAR2_TABLE_100();

70: ddindx binary_integer; indx binary_integer;
71: begin
72: if t is null or t.count = 0 then
73: a0 := JTF_VARCHAR2_TABLE_100();
74: a1 := JTF_VARCHAR2_TABLE_100();
75: a2 := JTF_VARCHAR2_TABLE_4000();
76: a3 := JTF_VARCHAR2_TABLE_100();
77: a4 := JTF_VARCHAR2_TABLE_400();
78: a5 := JTF_VARCHAR2_TABLE_300();

Line 76: a3 := JTF_VARCHAR2_TABLE_100();

72: if t is null or t.count = 0 then
73: a0 := JTF_VARCHAR2_TABLE_100();
74: a1 := JTF_VARCHAR2_TABLE_100();
75: a2 := JTF_VARCHAR2_TABLE_4000();
76: a3 := JTF_VARCHAR2_TABLE_100();
77: a4 := JTF_VARCHAR2_TABLE_400();
78: a5 := JTF_VARCHAR2_TABLE_300();
79: a6 := JTF_VARCHAR2_TABLE_100();
80: a7 := JTF_NUMBER_TABLE();

Line 79: a6 := JTF_VARCHAR2_TABLE_100();

75: a2 := JTF_VARCHAR2_TABLE_4000();
76: a3 := JTF_VARCHAR2_TABLE_100();
77: a4 := JTF_VARCHAR2_TABLE_400();
78: a5 := JTF_VARCHAR2_TABLE_300();
79: a6 := JTF_VARCHAR2_TABLE_100();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: a10 := JTF_NUMBER_TABLE();

Line 84: a11 := JTF_VARCHAR2_TABLE_100();

80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_VARCHAR2_TABLE_100();
85: else
86: a0 := JTF_VARCHAR2_TABLE_100();
87: a1 := JTF_VARCHAR2_TABLE_100();
88: a2 := JTF_VARCHAR2_TABLE_4000();

Line 86: a0 := JTF_VARCHAR2_TABLE_100();

82: a9 := JTF_NUMBER_TABLE();
83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_VARCHAR2_TABLE_100();
85: else
86: a0 := JTF_VARCHAR2_TABLE_100();
87: a1 := JTF_VARCHAR2_TABLE_100();
88: a2 := JTF_VARCHAR2_TABLE_4000();
89: a3 := JTF_VARCHAR2_TABLE_100();
90: a4 := JTF_VARCHAR2_TABLE_400();

Line 87: a1 := JTF_VARCHAR2_TABLE_100();

83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_VARCHAR2_TABLE_100();
85: else
86: a0 := JTF_VARCHAR2_TABLE_100();
87: a1 := JTF_VARCHAR2_TABLE_100();
88: a2 := JTF_VARCHAR2_TABLE_4000();
89: a3 := JTF_VARCHAR2_TABLE_100();
90: a4 := JTF_VARCHAR2_TABLE_400();
91: a5 := JTF_VARCHAR2_TABLE_300();

Line 89: a3 := JTF_VARCHAR2_TABLE_100();

85: else
86: a0 := JTF_VARCHAR2_TABLE_100();
87: a1 := JTF_VARCHAR2_TABLE_100();
88: a2 := JTF_VARCHAR2_TABLE_4000();
89: a3 := JTF_VARCHAR2_TABLE_100();
90: a4 := JTF_VARCHAR2_TABLE_400();
91: a5 := JTF_VARCHAR2_TABLE_300();
92: a6 := JTF_VARCHAR2_TABLE_100();
93: a7 := JTF_NUMBER_TABLE();

Line 92: a6 := JTF_VARCHAR2_TABLE_100();

88: a2 := JTF_VARCHAR2_TABLE_4000();
89: a3 := JTF_VARCHAR2_TABLE_100();
90: a4 := JTF_VARCHAR2_TABLE_400();
91: a5 := JTF_VARCHAR2_TABLE_300();
92: a6 := JTF_VARCHAR2_TABLE_100();
93: a7 := JTF_NUMBER_TABLE();
94: a8 := JTF_NUMBER_TABLE();
95: a9 := JTF_NUMBER_TABLE();
96: a10 := JTF_NUMBER_TABLE();

Line 97: a11 := JTF_VARCHAR2_TABLE_100();

93: a7 := JTF_NUMBER_TABLE();
94: a8 := JTF_NUMBER_TABLE();
95: a9 := JTF_NUMBER_TABLE();
96: a10 := JTF_NUMBER_TABLE();
97: a11 := JTF_VARCHAR2_TABLE_100();
98: if t.count > 0 then
99: a0.extend(t.count);
100: a1.extend(t.count);
101: a2.extend(t.count);

Line 139: , a3 JTF_VARCHAR2_TABLE_100

135:
136: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE
137: , a1 JTF_NUMBER_TABLE
138: , a2 JTF_NUMBER_TABLE
139: , a3 JTF_VARCHAR2_TABLE_100
140: , a4 JTF_VARCHAR2_TABLE_100
141: , a5 JTF_NUMBER_TABLE
142: , a6 JTF_VARCHAR2_TABLE_100
143: , a7 JTF_VARCHAR2_TABLE_100

Line 140: , a4 JTF_VARCHAR2_TABLE_100

136: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE
137: , a1 JTF_NUMBER_TABLE
138: , a2 JTF_NUMBER_TABLE
139: , a3 JTF_VARCHAR2_TABLE_100
140: , a4 JTF_VARCHAR2_TABLE_100
141: , a5 JTF_NUMBER_TABLE
142: , a6 JTF_VARCHAR2_TABLE_100
143: , a7 JTF_VARCHAR2_TABLE_100
144: , a8 JTF_NUMBER_TABLE

Line 142: , a6 JTF_VARCHAR2_TABLE_100

138: , a2 JTF_NUMBER_TABLE
139: , a3 JTF_VARCHAR2_TABLE_100
140: , a4 JTF_VARCHAR2_TABLE_100
141: , a5 JTF_NUMBER_TABLE
142: , a6 JTF_VARCHAR2_TABLE_100
143: , a7 JTF_VARCHAR2_TABLE_100
144: , a8 JTF_NUMBER_TABLE
145: , a9 JTF_VARCHAR2_TABLE_100
146: , a10 JTF_NUMBER_TABLE

Line 143: , a7 JTF_VARCHAR2_TABLE_100

139: , a3 JTF_VARCHAR2_TABLE_100
140: , a4 JTF_VARCHAR2_TABLE_100
141: , a5 JTF_NUMBER_TABLE
142: , a6 JTF_VARCHAR2_TABLE_100
143: , a7 JTF_VARCHAR2_TABLE_100
144: , a8 JTF_NUMBER_TABLE
145: , a9 JTF_VARCHAR2_TABLE_100
146: , a10 JTF_NUMBER_TABLE
147: , a11 JTF_NUMBER_TABLE

Line 145: , a9 JTF_VARCHAR2_TABLE_100

141: , a5 JTF_NUMBER_TABLE
142: , a6 JTF_VARCHAR2_TABLE_100
143: , a7 JTF_VARCHAR2_TABLE_100
144: , a8 JTF_NUMBER_TABLE
145: , a9 JTF_VARCHAR2_TABLE_100
146: , a10 JTF_NUMBER_TABLE
147: , a11 JTF_NUMBER_TABLE
148: ) as
149: ddindx binary_integer; indx binary_integer;

Line 180: , a3 out nocopy JTF_VARCHAR2_TABLE_100

176: end rosetta_table_copy_in_p3;
177: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
178: , a1 out nocopy JTF_NUMBER_TABLE
179: , a2 out nocopy JTF_NUMBER_TABLE
180: , a3 out nocopy JTF_VARCHAR2_TABLE_100
181: , a4 out nocopy JTF_VARCHAR2_TABLE_100
182: , a5 out nocopy JTF_NUMBER_TABLE
183: , a6 out nocopy JTF_VARCHAR2_TABLE_100
184: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 181: , a4 out nocopy JTF_VARCHAR2_TABLE_100

177: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
178: , a1 out nocopy JTF_NUMBER_TABLE
179: , a2 out nocopy JTF_NUMBER_TABLE
180: , a3 out nocopy JTF_VARCHAR2_TABLE_100
181: , a4 out nocopy JTF_VARCHAR2_TABLE_100
182: , a5 out nocopy JTF_NUMBER_TABLE
183: , a6 out nocopy JTF_VARCHAR2_TABLE_100
184: , a7 out nocopy JTF_VARCHAR2_TABLE_100
185: , a8 out nocopy JTF_NUMBER_TABLE

Line 183: , a6 out nocopy JTF_VARCHAR2_TABLE_100

179: , a2 out nocopy JTF_NUMBER_TABLE
180: , a3 out nocopy JTF_VARCHAR2_TABLE_100
181: , a4 out nocopy JTF_VARCHAR2_TABLE_100
182: , a5 out nocopy JTF_NUMBER_TABLE
183: , a6 out nocopy JTF_VARCHAR2_TABLE_100
184: , a7 out nocopy JTF_VARCHAR2_TABLE_100
185: , a8 out nocopy JTF_NUMBER_TABLE
186: , a9 out nocopy JTF_VARCHAR2_TABLE_100
187: , a10 out nocopy JTF_NUMBER_TABLE

Line 184: , a7 out nocopy JTF_VARCHAR2_TABLE_100

180: , a3 out nocopy JTF_VARCHAR2_TABLE_100
181: , a4 out nocopy JTF_VARCHAR2_TABLE_100
182: , a5 out nocopy JTF_NUMBER_TABLE
183: , a6 out nocopy JTF_VARCHAR2_TABLE_100
184: , a7 out nocopy JTF_VARCHAR2_TABLE_100
185: , a8 out nocopy JTF_NUMBER_TABLE
186: , a9 out nocopy JTF_VARCHAR2_TABLE_100
187: , a10 out nocopy JTF_NUMBER_TABLE
188: , a11 out nocopy JTF_NUMBER_TABLE

Line 186: , a9 out nocopy JTF_VARCHAR2_TABLE_100

182: , a5 out nocopy JTF_NUMBER_TABLE
183: , a6 out nocopy JTF_VARCHAR2_TABLE_100
184: , a7 out nocopy JTF_VARCHAR2_TABLE_100
185: , a8 out nocopy JTF_NUMBER_TABLE
186: , a9 out nocopy JTF_VARCHAR2_TABLE_100
187: , a10 out nocopy JTF_NUMBER_TABLE
188: , a11 out nocopy JTF_NUMBER_TABLE
189: ) as
190: ddindx binary_integer; indx binary_integer;

Line 196: a3 := JTF_VARCHAR2_TABLE_100();

192: if t is null or t.count = 0 then
193: a0 := JTF_NUMBER_TABLE();
194: a1 := JTF_NUMBER_TABLE();
195: a2 := JTF_NUMBER_TABLE();
196: a3 := JTF_VARCHAR2_TABLE_100();
197: a4 := JTF_VARCHAR2_TABLE_100();
198: a5 := JTF_NUMBER_TABLE();
199: a6 := JTF_VARCHAR2_TABLE_100();
200: a7 := JTF_VARCHAR2_TABLE_100();

Line 197: a4 := JTF_VARCHAR2_TABLE_100();

193: a0 := JTF_NUMBER_TABLE();
194: a1 := JTF_NUMBER_TABLE();
195: a2 := JTF_NUMBER_TABLE();
196: a3 := JTF_VARCHAR2_TABLE_100();
197: a4 := JTF_VARCHAR2_TABLE_100();
198: a5 := JTF_NUMBER_TABLE();
199: a6 := JTF_VARCHAR2_TABLE_100();
200: a7 := JTF_VARCHAR2_TABLE_100();
201: a8 := JTF_NUMBER_TABLE();

Line 199: a6 := JTF_VARCHAR2_TABLE_100();

195: a2 := JTF_NUMBER_TABLE();
196: a3 := JTF_VARCHAR2_TABLE_100();
197: a4 := JTF_VARCHAR2_TABLE_100();
198: a5 := JTF_NUMBER_TABLE();
199: a6 := JTF_VARCHAR2_TABLE_100();
200: a7 := JTF_VARCHAR2_TABLE_100();
201: a8 := JTF_NUMBER_TABLE();
202: a9 := JTF_VARCHAR2_TABLE_100();
203: a10 := JTF_NUMBER_TABLE();

Line 200: a7 := JTF_VARCHAR2_TABLE_100();

196: a3 := JTF_VARCHAR2_TABLE_100();
197: a4 := JTF_VARCHAR2_TABLE_100();
198: a5 := JTF_NUMBER_TABLE();
199: a6 := JTF_VARCHAR2_TABLE_100();
200: a7 := JTF_VARCHAR2_TABLE_100();
201: a8 := JTF_NUMBER_TABLE();
202: a9 := JTF_VARCHAR2_TABLE_100();
203: a10 := JTF_NUMBER_TABLE();
204: a11 := JTF_NUMBER_TABLE();

Line 202: a9 := JTF_VARCHAR2_TABLE_100();

198: a5 := JTF_NUMBER_TABLE();
199: a6 := JTF_VARCHAR2_TABLE_100();
200: a7 := JTF_VARCHAR2_TABLE_100();
201: a8 := JTF_NUMBER_TABLE();
202: a9 := JTF_VARCHAR2_TABLE_100();
203: a10 := JTF_NUMBER_TABLE();
204: a11 := JTF_NUMBER_TABLE();
205: else
206: a0 := JTF_NUMBER_TABLE();

Line 209: a3 := JTF_VARCHAR2_TABLE_100();

205: else
206: a0 := JTF_NUMBER_TABLE();
207: a1 := JTF_NUMBER_TABLE();
208: a2 := JTF_NUMBER_TABLE();
209: a3 := JTF_VARCHAR2_TABLE_100();
210: a4 := JTF_VARCHAR2_TABLE_100();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_VARCHAR2_TABLE_100();
213: a7 := JTF_VARCHAR2_TABLE_100();

Line 210: a4 := JTF_VARCHAR2_TABLE_100();

206: a0 := JTF_NUMBER_TABLE();
207: a1 := JTF_NUMBER_TABLE();
208: a2 := JTF_NUMBER_TABLE();
209: a3 := JTF_VARCHAR2_TABLE_100();
210: a4 := JTF_VARCHAR2_TABLE_100();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_VARCHAR2_TABLE_100();
213: a7 := JTF_VARCHAR2_TABLE_100();
214: a8 := JTF_NUMBER_TABLE();

Line 212: a6 := JTF_VARCHAR2_TABLE_100();

208: a2 := JTF_NUMBER_TABLE();
209: a3 := JTF_VARCHAR2_TABLE_100();
210: a4 := JTF_VARCHAR2_TABLE_100();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_VARCHAR2_TABLE_100();
213: a7 := JTF_VARCHAR2_TABLE_100();
214: a8 := JTF_NUMBER_TABLE();
215: a9 := JTF_VARCHAR2_TABLE_100();
216: a10 := JTF_NUMBER_TABLE();

Line 213: a7 := JTF_VARCHAR2_TABLE_100();

209: a3 := JTF_VARCHAR2_TABLE_100();
210: a4 := JTF_VARCHAR2_TABLE_100();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_VARCHAR2_TABLE_100();
213: a7 := JTF_VARCHAR2_TABLE_100();
214: a8 := JTF_NUMBER_TABLE();
215: a9 := JTF_VARCHAR2_TABLE_100();
216: a10 := JTF_NUMBER_TABLE();
217: a11 := JTF_NUMBER_TABLE();

Line 215: a9 := JTF_VARCHAR2_TABLE_100();

211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_VARCHAR2_TABLE_100();
213: a7 := JTF_VARCHAR2_TABLE_100();
214: a8 := JTF_NUMBER_TABLE();
215: a9 := JTF_VARCHAR2_TABLE_100();
216: a10 := JTF_NUMBER_TABLE();
217: a11 := JTF_NUMBER_TABLE();
218: if t.count > 0 then
219: a0.extend(t.count);

Line 261: , a5 JTF_VARCHAR2_TABLE_100

257: , a1 JTF_NUMBER_TABLE
258: , a2 JTF_NUMBER_TABLE
259: , a3 JTF_NUMBER_TABLE
260: , a4 JTF_NUMBER_TABLE
261: , a5 JTF_VARCHAR2_TABLE_100
262: , a6 JTF_VARCHAR2_TABLE_100
263: , a7 JTF_VARCHAR2_TABLE_100
264: , a8 JTF_VARCHAR2_TABLE_100
265: , a9 JTF_VARCHAR2_TABLE_100

Line 262: , a6 JTF_VARCHAR2_TABLE_100

258: , a2 JTF_NUMBER_TABLE
259: , a3 JTF_NUMBER_TABLE
260: , a4 JTF_NUMBER_TABLE
261: , a5 JTF_VARCHAR2_TABLE_100
262: , a6 JTF_VARCHAR2_TABLE_100
263: , a7 JTF_VARCHAR2_TABLE_100
264: , a8 JTF_VARCHAR2_TABLE_100
265: , a9 JTF_VARCHAR2_TABLE_100
266: ) as

Line 263: , a7 JTF_VARCHAR2_TABLE_100

259: , a3 JTF_NUMBER_TABLE
260: , a4 JTF_NUMBER_TABLE
261: , a5 JTF_VARCHAR2_TABLE_100
262: , a6 JTF_VARCHAR2_TABLE_100
263: , a7 JTF_VARCHAR2_TABLE_100
264: , a8 JTF_VARCHAR2_TABLE_100
265: , a9 JTF_VARCHAR2_TABLE_100
266: ) as
267: ddindx binary_integer; indx binary_integer;

Line 264: , a8 JTF_VARCHAR2_TABLE_100

260: , a4 JTF_NUMBER_TABLE
261: , a5 JTF_VARCHAR2_TABLE_100
262: , a6 JTF_VARCHAR2_TABLE_100
263: , a7 JTF_VARCHAR2_TABLE_100
264: , a8 JTF_VARCHAR2_TABLE_100
265: , a9 JTF_VARCHAR2_TABLE_100
266: ) as
267: ddindx binary_integer; indx binary_integer;
268: begin

Line 265: , a9 JTF_VARCHAR2_TABLE_100

261: , a5 JTF_VARCHAR2_TABLE_100
262: , a6 JTF_VARCHAR2_TABLE_100
263: , a7 JTF_VARCHAR2_TABLE_100
264: , a8 JTF_VARCHAR2_TABLE_100
265: , a9 JTF_VARCHAR2_TABLE_100
266: ) as
267: ddindx binary_integer; indx binary_integer;
268: begin
269: if a0 is not null and a0.count > 0 then

Line 298: , a5 out nocopy JTF_VARCHAR2_TABLE_100

294: , a1 out nocopy JTF_NUMBER_TABLE
295: , a2 out nocopy JTF_NUMBER_TABLE
296: , a3 out nocopy JTF_NUMBER_TABLE
297: , a4 out nocopy JTF_NUMBER_TABLE
298: , a5 out nocopy JTF_VARCHAR2_TABLE_100
299: , a6 out nocopy JTF_VARCHAR2_TABLE_100
300: , a7 out nocopy JTF_VARCHAR2_TABLE_100
301: , a8 out nocopy JTF_VARCHAR2_TABLE_100
302: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 299: , a6 out nocopy JTF_VARCHAR2_TABLE_100

295: , a2 out nocopy JTF_NUMBER_TABLE
296: , a3 out nocopy JTF_NUMBER_TABLE
297: , a4 out nocopy JTF_NUMBER_TABLE
298: , a5 out nocopy JTF_VARCHAR2_TABLE_100
299: , a6 out nocopy JTF_VARCHAR2_TABLE_100
300: , a7 out nocopy JTF_VARCHAR2_TABLE_100
301: , a8 out nocopy JTF_VARCHAR2_TABLE_100
302: , a9 out nocopy JTF_VARCHAR2_TABLE_100
303: ) as

Line 300: , a7 out nocopy JTF_VARCHAR2_TABLE_100

296: , a3 out nocopy JTF_NUMBER_TABLE
297: , a4 out nocopy JTF_NUMBER_TABLE
298: , a5 out nocopy JTF_VARCHAR2_TABLE_100
299: , a6 out nocopy JTF_VARCHAR2_TABLE_100
300: , a7 out nocopy JTF_VARCHAR2_TABLE_100
301: , a8 out nocopy JTF_VARCHAR2_TABLE_100
302: , a9 out nocopy JTF_VARCHAR2_TABLE_100
303: ) as
304: ddindx binary_integer; indx binary_integer;

Line 301: , a8 out nocopy JTF_VARCHAR2_TABLE_100

297: , a4 out nocopy JTF_NUMBER_TABLE
298: , a5 out nocopy JTF_VARCHAR2_TABLE_100
299: , a6 out nocopy JTF_VARCHAR2_TABLE_100
300: , a7 out nocopy JTF_VARCHAR2_TABLE_100
301: , a8 out nocopy JTF_VARCHAR2_TABLE_100
302: , a9 out nocopy JTF_VARCHAR2_TABLE_100
303: ) as
304: ddindx binary_integer; indx binary_integer;
305: begin

Line 302: , a9 out nocopy JTF_VARCHAR2_TABLE_100

298: , a5 out nocopy JTF_VARCHAR2_TABLE_100
299: , a6 out nocopy JTF_VARCHAR2_TABLE_100
300: , a7 out nocopy JTF_VARCHAR2_TABLE_100
301: , a8 out nocopy JTF_VARCHAR2_TABLE_100
302: , a9 out nocopy JTF_VARCHAR2_TABLE_100
303: ) as
304: ddindx binary_integer; indx binary_integer;
305: begin
306: if t is null or t.count = 0 then

Line 312: a5 := JTF_VARCHAR2_TABLE_100();

308: a1 := JTF_NUMBER_TABLE();
309: a2 := JTF_NUMBER_TABLE();
310: a3 := JTF_NUMBER_TABLE();
311: a4 := JTF_NUMBER_TABLE();
312: a5 := JTF_VARCHAR2_TABLE_100();
313: a6 := JTF_VARCHAR2_TABLE_100();
314: a7 := JTF_VARCHAR2_TABLE_100();
315: a8 := JTF_VARCHAR2_TABLE_100();
316: a9 := JTF_VARCHAR2_TABLE_100();

Line 313: a6 := JTF_VARCHAR2_TABLE_100();

309: a2 := JTF_NUMBER_TABLE();
310: a3 := JTF_NUMBER_TABLE();
311: a4 := JTF_NUMBER_TABLE();
312: a5 := JTF_VARCHAR2_TABLE_100();
313: a6 := JTF_VARCHAR2_TABLE_100();
314: a7 := JTF_VARCHAR2_TABLE_100();
315: a8 := JTF_VARCHAR2_TABLE_100();
316: a9 := JTF_VARCHAR2_TABLE_100();
317: else

Line 314: a7 := JTF_VARCHAR2_TABLE_100();

310: a3 := JTF_NUMBER_TABLE();
311: a4 := JTF_NUMBER_TABLE();
312: a5 := JTF_VARCHAR2_TABLE_100();
313: a6 := JTF_VARCHAR2_TABLE_100();
314: a7 := JTF_VARCHAR2_TABLE_100();
315: a8 := JTF_VARCHAR2_TABLE_100();
316: a9 := JTF_VARCHAR2_TABLE_100();
317: else
318: a0 := JTF_NUMBER_TABLE();

Line 315: a8 := JTF_VARCHAR2_TABLE_100();

311: a4 := JTF_NUMBER_TABLE();
312: a5 := JTF_VARCHAR2_TABLE_100();
313: a6 := JTF_VARCHAR2_TABLE_100();
314: a7 := JTF_VARCHAR2_TABLE_100();
315: a8 := JTF_VARCHAR2_TABLE_100();
316: a9 := JTF_VARCHAR2_TABLE_100();
317: else
318: a0 := JTF_NUMBER_TABLE();
319: a1 := JTF_NUMBER_TABLE();

Line 316: a9 := JTF_VARCHAR2_TABLE_100();

312: a5 := JTF_VARCHAR2_TABLE_100();
313: a6 := JTF_VARCHAR2_TABLE_100();
314: a7 := JTF_VARCHAR2_TABLE_100();
315: a8 := JTF_VARCHAR2_TABLE_100();
316: a9 := JTF_VARCHAR2_TABLE_100();
317: else
318: a0 := JTF_NUMBER_TABLE();
319: a1 := JTF_NUMBER_TABLE();
320: a2 := JTF_NUMBER_TABLE();

Line 323: a5 := JTF_VARCHAR2_TABLE_100();

319: a1 := JTF_NUMBER_TABLE();
320: a2 := JTF_NUMBER_TABLE();
321: a3 := JTF_NUMBER_TABLE();
322: a4 := JTF_NUMBER_TABLE();
323: a5 := JTF_VARCHAR2_TABLE_100();
324: a6 := JTF_VARCHAR2_TABLE_100();
325: a7 := JTF_VARCHAR2_TABLE_100();
326: a8 := JTF_VARCHAR2_TABLE_100();
327: a9 := JTF_VARCHAR2_TABLE_100();

Line 324: a6 := JTF_VARCHAR2_TABLE_100();

320: a2 := JTF_NUMBER_TABLE();
321: a3 := JTF_NUMBER_TABLE();
322: a4 := JTF_NUMBER_TABLE();
323: a5 := JTF_VARCHAR2_TABLE_100();
324: a6 := JTF_VARCHAR2_TABLE_100();
325: a7 := JTF_VARCHAR2_TABLE_100();
326: a8 := JTF_VARCHAR2_TABLE_100();
327: a9 := JTF_VARCHAR2_TABLE_100();
328: if t.count > 0 then

Line 325: a7 := JTF_VARCHAR2_TABLE_100();

321: a3 := JTF_NUMBER_TABLE();
322: a4 := JTF_NUMBER_TABLE();
323: a5 := JTF_VARCHAR2_TABLE_100();
324: a6 := JTF_VARCHAR2_TABLE_100();
325: a7 := JTF_VARCHAR2_TABLE_100();
326: a8 := JTF_VARCHAR2_TABLE_100();
327: a9 := JTF_VARCHAR2_TABLE_100();
328: if t.count > 0 then
329: a0.extend(t.count);

Line 326: a8 := JTF_VARCHAR2_TABLE_100();

322: a4 := JTF_NUMBER_TABLE();
323: a5 := JTF_VARCHAR2_TABLE_100();
324: a6 := JTF_VARCHAR2_TABLE_100();
325: a7 := JTF_VARCHAR2_TABLE_100();
326: a8 := JTF_VARCHAR2_TABLE_100();
327: a9 := JTF_VARCHAR2_TABLE_100();
328: if t.count > 0 then
329: a0.extend(t.count);
330: a1.extend(t.count);

Line 327: a9 := JTF_VARCHAR2_TABLE_100();

323: a5 := JTF_VARCHAR2_TABLE_100();
324: a6 := JTF_VARCHAR2_TABLE_100();
325: a7 := JTF_VARCHAR2_TABLE_100();
326: a8 := JTF_VARCHAR2_TABLE_100();
327: a9 := JTF_VARCHAR2_TABLE_100();
328: if t.count > 0 then
329: a0.extend(t.count);
330: a1.extend(t.count);
331: a2.extend(t.count);

Line 365: , a3 JTF_VARCHAR2_TABLE_100

361:
362: procedure rosetta_table_copy_in_p7(t out nocopy ahl_fmp_pvt.applicable_programs_tbl_type, a0 JTF_NUMBER_TABLE
363: , a1 JTF_VARCHAR2_TABLE_200
364: , a2 JTF_VARCHAR2_TABLE_200
365: , a3 JTF_VARCHAR2_TABLE_100
366: , a4 JTF_NUMBER_TABLE
367: , a5 JTF_VARCHAR2_TABLE_300
368: , a6 JTF_VARCHAR2_TABLE_300
369: , a7 JTF_NUMBER_TABLE

Line 372: , a10 JTF_VARCHAR2_TABLE_100

368: , a6 JTF_VARCHAR2_TABLE_300
369: , a7 JTF_NUMBER_TABLE
370: , a8 JTF_VARCHAR2_TABLE_200
371: , a9 JTF_VARCHAR2_TABLE_2000
372: , a10 JTF_VARCHAR2_TABLE_100
373: , a11 JTF_VARCHAR2_TABLE_100
374: , a12 JTF_NUMBER_TABLE
375: , a13 JTF_DATE_TABLE
376: , a14 JTF_DATE_TABLE

Line 373: , a11 JTF_VARCHAR2_TABLE_100

369: , a7 JTF_NUMBER_TABLE
370: , a8 JTF_VARCHAR2_TABLE_200
371: , a9 JTF_VARCHAR2_TABLE_2000
372: , a10 JTF_VARCHAR2_TABLE_100
373: , a11 JTF_VARCHAR2_TABLE_100
374: , a12 JTF_NUMBER_TABLE
375: , a13 JTF_DATE_TABLE
376: , a14 JTF_DATE_TABLE
377: , a15 JTF_VARCHAR2_TABLE_100

Line 377: , a15 JTF_VARCHAR2_TABLE_100

373: , a11 JTF_VARCHAR2_TABLE_100
374: , a12 JTF_NUMBER_TABLE
375: , a13 JTF_DATE_TABLE
376: , a14 JTF_DATE_TABLE
377: , a15 JTF_VARCHAR2_TABLE_100
378: , a16 JTF_VARCHAR2_TABLE_100
379: , a17 JTF_DATE_TABLE
380: , a18 JTF_DATE_TABLE
381: , a19 JTF_VARCHAR2_TABLE_100

Line 378: , a16 JTF_VARCHAR2_TABLE_100

374: , a12 JTF_NUMBER_TABLE
375: , a13 JTF_DATE_TABLE
376: , a14 JTF_DATE_TABLE
377: , a15 JTF_VARCHAR2_TABLE_100
378: , a16 JTF_VARCHAR2_TABLE_100
379: , a17 JTF_DATE_TABLE
380: , a18 JTF_DATE_TABLE
381: , a19 JTF_VARCHAR2_TABLE_100
382: , a20 JTF_VARCHAR2_TABLE_2000

Line 381: , a19 JTF_VARCHAR2_TABLE_100

377: , a15 JTF_VARCHAR2_TABLE_100
378: , a16 JTF_VARCHAR2_TABLE_100
379: , a17 JTF_DATE_TABLE
380: , a18 JTF_DATE_TABLE
381: , a19 JTF_VARCHAR2_TABLE_100
382: , a20 JTF_VARCHAR2_TABLE_2000
383: , a21 JTF_DATE_TABLE
384: , a22 JTF_VARCHAR2_TABLE_100
385: , a23 JTF_VARCHAR2_TABLE_500

Line 384: , a22 JTF_VARCHAR2_TABLE_100

380: , a18 JTF_DATE_TABLE
381: , a19 JTF_VARCHAR2_TABLE_100
382: , a20 JTF_VARCHAR2_TABLE_2000
383: , a21 JTF_DATE_TABLE
384: , a22 JTF_VARCHAR2_TABLE_100
385: , a23 JTF_VARCHAR2_TABLE_500
386: , a24 JTF_NUMBER_TABLE
387: ) as
388: ddindx binary_integer; indx binary_integer;

Line 432: , a3 out nocopy JTF_VARCHAR2_TABLE_100

428: end rosetta_table_copy_in_p7;
429: procedure rosetta_table_copy_out_p7(t ahl_fmp_pvt.applicable_programs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
430: , a1 out nocopy JTF_VARCHAR2_TABLE_200
431: , a2 out nocopy JTF_VARCHAR2_TABLE_200
432: , a3 out nocopy JTF_VARCHAR2_TABLE_100
433: , a4 out nocopy JTF_NUMBER_TABLE
434: , a5 out nocopy JTF_VARCHAR2_TABLE_300
435: , a6 out nocopy JTF_VARCHAR2_TABLE_300
436: , a7 out nocopy JTF_NUMBER_TABLE

Line 439: , a10 out nocopy JTF_VARCHAR2_TABLE_100

435: , a6 out nocopy JTF_VARCHAR2_TABLE_300
436: , a7 out nocopy JTF_NUMBER_TABLE
437: , a8 out nocopy JTF_VARCHAR2_TABLE_200
438: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
439: , a10 out nocopy JTF_VARCHAR2_TABLE_100
440: , a11 out nocopy JTF_VARCHAR2_TABLE_100
441: , a12 out nocopy JTF_NUMBER_TABLE
442: , a13 out nocopy JTF_DATE_TABLE
443: , a14 out nocopy JTF_DATE_TABLE

Line 440: , a11 out nocopy JTF_VARCHAR2_TABLE_100

436: , a7 out nocopy JTF_NUMBER_TABLE
437: , a8 out nocopy JTF_VARCHAR2_TABLE_200
438: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
439: , a10 out nocopy JTF_VARCHAR2_TABLE_100
440: , a11 out nocopy JTF_VARCHAR2_TABLE_100
441: , a12 out nocopy JTF_NUMBER_TABLE
442: , a13 out nocopy JTF_DATE_TABLE
443: , a14 out nocopy JTF_DATE_TABLE
444: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 444: , a15 out nocopy JTF_VARCHAR2_TABLE_100

440: , a11 out nocopy JTF_VARCHAR2_TABLE_100
441: , a12 out nocopy JTF_NUMBER_TABLE
442: , a13 out nocopy JTF_DATE_TABLE
443: , a14 out nocopy JTF_DATE_TABLE
444: , a15 out nocopy JTF_VARCHAR2_TABLE_100
445: , a16 out nocopy JTF_VARCHAR2_TABLE_100
446: , a17 out nocopy JTF_DATE_TABLE
447: , a18 out nocopy JTF_DATE_TABLE
448: , a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 445: , a16 out nocopy JTF_VARCHAR2_TABLE_100

441: , a12 out nocopy JTF_NUMBER_TABLE
442: , a13 out nocopy JTF_DATE_TABLE
443: , a14 out nocopy JTF_DATE_TABLE
444: , a15 out nocopy JTF_VARCHAR2_TABLE_100
445: , a16 out nocopy JTF_VARCHAR2_TABLE_100
446: , a17 out nocopy JTF_DATE_TABLE
447: , a18 out nocopy JTF_DATE_TABLE
448: , a19 out nocopy JTF_VARCHAR2_TABLE_100
449: , a20 out nocopy JTF_VARCHAR2_TABLE_2000

Line 448: , a19 out nocopy JTF_VARCHAR2_TABLE_100

444: , a15 out nocopy JTF_VARCHAR2_TABLE_100
445: , a16 out nocopy JTF_VARCHAR2_TABLE_100
446: , a17 out nocopy JTF_DATE_TABLE
447: , a18 out nocopy JTF_DATE_TABLE
448: , a19 out nocopy JTF_VARCHAR2_TABLE_100
449: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
450: , a21 out nocopy JTF_DATE_TABLE
451: , a22 out nocopy JTF_VARCHAR2_TABLE_100
452: , a23 out nocopy JTF_VARCHAR2_TABLE_500

Line 451: , a22 out nocopy JTF_VARCHAR2_TABLE_100

447: , a18 out nocopy JTF_DATE_TABLE
448: , a19 out nocopy JTF_VARCHAR2_TABLE_100
449: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
450: , a21 out nocopy JTF_DATE_TABLE
451: , a22 out nocopy JTF_VARCHAR2_TABLE_100
452: , a23 out nocopy JTF_VARCHAR2_TABLE_500
453: , a24 out nocopy JTF_NUMBER_TABLE
454: ) as
455: ddindx binary_integer; indx binary_integer;

Line 461: a3 := JTF_VARCHAR2_TABLE_100();

457: if t is null or t.count = 0 then
458: a0 := JTF_NUMBER_TABLE();
459: a1 := JTF_VARCHAR2_TABLE_200();
460: a2 := JTF_VARCHAR2_TABLE_200();
461: a3 := JTF_VARCHAR2_TABLE_100();
462: a4 := JTF_NUMBER_TABLE();
463: a5 := JTF_VARCHAR2_TABLE_300();
464: a6 := JTF_VARCHAR2_TABLE_300();
465: a7 := JTF_NUMBER_TABLE();

Line 468: a10 := JTF_VARCHAR2_TABLE_100();

464: a6 := JTF_VARCHAR2_TABLE_300();
465: a7 := JTF_NUMBER_TABLE();
466: a8 := JTF_VARCHAR2_TABLE_200();
467: a9 := JTF_VARCHAR2_TABLE_2000();
468: a10 := JTF_VARCHAR2_TABLE_100();
469: a11 := JTF_VARCHAR2_TABLE_100();
470: a12 := JTF_NUMBER_TABLE();
471: a13 := JTF_DATE_TABLE();
472: a14 := JTF_DATE_TABLE();

Line 469: a11 := JTF_VARCHAR2_TABLE_100();

465: a7 := JTF_NUMBER_TABLE();
466: a8 := JTF_VARCHAR2_TABLE_200();
467: a9 := JTF_VARCHAR2_TABLE_2000();
468: a10 := JTF_VARCHAR2_TABLE_100();
469: a11 := JTF_VARCHAR2_TABLE_100();
470: a12 := JTF_NUMBER_TABLE();
471: a13 := JTF_DATE_TABLE();
472: a14 := JTF_DATE_TABLE();
473: a15 := JTF_VARCHAR2_TABLE_100();

Line 473: a15 := JTF_VARCHAR2_TABLE_100();

469: a11 := JTF_VARCHAR2_TABLE_100();
470: a12 := JTF_NUMBER_TABLE();
471: a13 := JTF_DATE_TABLE();
472: a14 := JTF_DATE_TABLE();
473: a15 := JTF_VARCHAR2_TABLE_100();
474: a16 := JTF_VARCHAR2_TABLE_100();
475: a17 := JTF_DATE_TABLE();
476: a18 := JTF_DATE_TABLE();
477: a19 := JTF_VARCHAR2_TABLE_100();

Line 474: a16 := JTF_VARCHAR2_TABLE_100();

470: a12 := JTF_NUMBER_TABLE();
471: a13 := JTF_DATE_TABLE();
472: a14 := JTF_DATE_TABLE();
473: a15 := JTF_VARCHAR2_TABLE_100();
474: a16 := JTF_VARCHAR2_TABLE_100();
475: a17 := JTF_DATE_TABLE();
476: a18 := JTF_DATE_TABLE();
477: a19 := JTF_VARCHAR2_TABLE_100();
478: a20 := JTF_VARCHAR2_TABLE_2000();

Line 477: a19 := JTF_VARCHAR2_TABLE_100();

473: a15 := JTF_VARCHAR2_TABLE_100();
474: a16 := JTF_VARCHAR2_TABLE_100();
475: a17 := JTF_DATE_TABLE();
476: a18 := JTF_DATE_TABLE();
477: a19 := JTF_VARCHAR2_TABLE_100();
478: a20 := JTF_VARCHAR2_TABLE_2000();
479: a21 := JTF_DATE_TABLE();
480: a22 := JTF_VARCHAR2_TABLE_100();
481: a23 := JTF_VARCHAR2_TABLE_500();

Line 480: a22 := JTF_VARCHAR2_TABLE_100();

476: a18 := JTF_DATE_TABLE();
477: a19 := JTF_VARCHAR2_TABLE_100();
478: a20 := JTF_VARCHAR2_TABLE_2000();
479: a21 := JTF_DATE_TABLE();
480: a22 := JTF_VARCHAR2_TABLE_100();
481: a23 := JTF_VARCHAR2_TABLE_500();
482: a24 := JTF_NUMBER_TABLE();
483: else
484: a0 := JTF_NUMBER_TABLE();

Line 487: a3 := JTF_VARCHAR2_TABLE_100();

483: else
484: a0 := JTF_NUMBER_TABLE();
485: a1 := JTF_VARCHAR2_TABLE_200();
486: a2 := JTF_VARCHAR2_TABLE_200();
487: a3 := JTF_VARCHAR2_TABLE_100();
488: a4 := JTF_NUMBER_TABLE();
489: a5 := JTF_VARCHAR2_TABLE_300();
490: a6 := JTF_VARCHAR2_TABLE_300();
491: a7 := JTF_NUMBER_TABLE();

Line 494: a10 := JTF_VARCHAR2_TABLE_100();

490: a6 := JTF_VARCHAR2_TABLE_300();
491: a7 := JTF_NUMBER_TABLE();
492: a8 := JTF_VARCHAR2_TABLE_200();
493: a9 := JTF_VARCHAR2_TABLE_2000();
494: a10 := JTF_VARCHAR2_TABLE_100();
495: a11 := JTF_VARCHAR2_TABLE_100();
496: a12 := JTF_NUMBER_TABLE();
497: a13 := JTF_DATE_TABLE();
498: a14 := JTF_DATE_TABLE();

Line 495: a11 := JTF_VARCHAR2_TABLE_100();

491: a7 := JTF_NUMBER_TABLE();
492: a8 := JTF_VARCHAR2_TABLE_200();
493: a9 := JTF_VARCHAR2_TABLE_2000();
494: a10 := JTF_VARCHAR2_TABLE_100();
495: a11 := JTF_VARCHAR2_TABLE_100();
496: a12 := JTF_NUMBER_TABLE();
497: a13 := JTF_DATE_TABLE();
498: a14 := JTF_DATE_TABLE();
499: a15 := JTF_VARCHAR2_TABLE_100();

Line 499: a15 := JTF_VARCHAR2_TABLE_100();

495: a11 := JTF_VARCHAR2_TABLE_100();
496: a12 := JTF_NUMBER_TABLE();
497: a13 := JTF_DATE_TABLE();
498: a14 := JTF_DATE_TABLE();
499: a15 := JTF_VARCHAR2_TABLE_100();
500: a16 := JTF_VARCHAR2_TABLE_100();
501: a17 := JTF_DATE_TABLE();
502: a18 := JTF_DATE_TABLE();
503: a19 := JTF_VARCHAR2_TABLE_100();

Line 500: a16 := JTF_VARCHAR2_TABLE_100();

496: a12 := JTF_NUMBER_TABLE();
497: a13 := JTF_DATE_TABLE();
498: a14 := JTF_DATE_TABLE();
499: a15 := JTF_VARCHAR2_TABLE_100();
500: a16 := JTF_VARCHAR2_TABLE_100();
501: a17 := JTF_DATE_TABLE();
502: a18 := JTF_DATE_TABLE();
503: a19 := JTF_VARCHAR2_TABLE_100();
504: a20 := JTF_VARCHAR2_TABLE_2000();

Line 503: a19 := JTF_VARCHAR2_TABLE_100();

499: a15 := JTF_VARCHAR2_TABLE_100();
500: a16 := JTF_VARCHAR2_TABLE_100();
501: a17 := JTF_DATE_TABLE();
502: a18 := JTF_DATE_TABLE();
503: a19 := JTF_VARCHAR2_TABLE_100();
504: a20 := JTF_VARCHAR2_TABLE_2000();
505: a21 := JTF_DATE_TABLE();
506: a22 := JTF_VARCHAR2_TABLE_100();
507: a23 := JTF_VARCHAR2_TABLE_500();

Line 506: a22 := JTF_VARCHAR2_TABLE_100();

502: a18 := JTF_DATE_TABLE();
503: a19 := JTF_VARCHAR2_TABLE_100();
504: a20 := JTF_VARCHAR2_TABLE_2000();
505: a21 := JTF_DATE_TABLE();
506: a22 := JTF_VARCHAR2_TABLE_100();
507: a23 := JTF_VARCHAR2_TABLE_500();
508: a24 := JTF_NUMBER_TABLE();
509: if t.count > 0 then
510: a0.extend(t.count);

Line 587: , p14_a0 out nocopy JTF_VARCHAR2_TABLE_100

583: , p_unique_inst_flag VARCHAR2
584: , p_sort_flag VARCHAR2
585: , p_consider_fleet_flag VARCHAR2
586: , p_flt_range_calc_date date
587: , p14_a0 out nocopy JTF_VARCHAR2_TABLE_100
588: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_100
589: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_4000
590: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_100
591: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 588: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_100

584: , p_sort_flag VARCHAR2
585: , p_consider_fleet_flag VARCHAR2
586: , p_flt_range_calc_date date
587: , p14_a0 out nocopy JTF_VARCHAR2_TABLE_100
588: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_100
589: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_4000
590: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_100
591: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_400
592: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 590: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_100

586: , p_flt_range_calc_date date
587: , p14_a0 out nocopy JTF_VARCHAR2_TABLE_100
588: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_100
589: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_4000
590: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_100
591: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_400
592: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300
593: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_100
594: , p14_a7 out nocopy JTF_NUMBER_TABLE

Line 593: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_100

589: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_4000
590: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_100
591: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_400
592: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300
593: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_100
594: , p14_a7 out nocopy JTF_NUMBER_TABLE
595: , p14_a8 out nocopy JTF_NUMBER_TABLE
596: , p14_a9 out nocopy JTF_NUMBER_TABLE
597: , p14_a10 out nocopy JTF_NUMBER_TABLE

Line 598: , p14_a11 out nocopy JTF_VARCHAR2_TABLE_100

594: , p14_a7 out nocopy JTF_NUMBER_TABLE
595: , p14_a8 out nocopy JTF_NUMBER_TABLE
596: , p14_a9 out nocopy JTF_NUMBER_TABLE
597: , p14_a10 out nocopy JTF_NUMBER_TABLE
598: , p14_a11 out nocopy JTF_VARCHAR2_TABLE_100
599: )
600:
601: as
602: ddp_flt_range_calc_date date;

Line 689: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100

685: , p_insert_into_tmp_tbl VARCHAR2
686: , p15_a0 out nocopy JTF_NUMBER_TABLE
687: , p15_a1 out nocopy JTF_NUMBER_TABLE
688: , p15_a2 out nocopy JTF_NUMBER_TABLE
689: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
690: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_100
691: , p15_a5 out nocopy JTF_NUMBER_TABLE
692: , p15_a6 out nocopy JTF_VARCHAR2_TABLE_100
693: , p15_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 690: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_100

686: , p15_a0 out nocopy JTF_NUMBER_TABLE
687: , p15_a1 out nocopy JTF_NUMBER_TABLE
688: , p15_a2 out nocopy JTF_NUMBER_TABLE
689: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
690: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_100
691: , p15_a5 out nocopy JTF_NUMBER_TABLE
692: , p15_a6 out nocopy JTF_VARCHAR2_TABLE_100
693: , p15_a7 out nocopy JTF_VARCHAR2_TABLE_100
694: , p15_a8 out nocopy JTF_NUMBER_TABLE

Line 692: , p15_a6 out nocopy JTF_VARCHAR2_TABLE_100

688: , p15_a2 out nocopy JTF_NUMBER_TABLE
689: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
690: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_100
691: , p15_a5 out nocopy JTF_NUMBER_TABLE
692: , p15_a6 out nocopy JTF_VARCHAR2_TABLE_100
693: , p15_a7 out nocopy JTF_VARCHAR2_TABLE_100
694: , p15_a8 out nocopy JTF_NUMBER_TABLE
695: , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100
696: , p15_a10 out nocopy JTF_NUMBER_TABLE

Line 693: , p15_a7 out nocopy JTF_VARCHAR2_TABLE_100

689: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
690: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_100
691: , p15_a5 out nocopy JTF_NUMBER_TABLE
692: , p15_a6 out nocopy JTF_VARCHAR2_TABLE_100
693: , p15_a7 out nocopy JTF_VARCHAR2_TABLE_100
694: , p15_a8 out nocopy JTF_NUMBER_TABLE
695: , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100
696: , p15_a10 out nocopy JTF_NUMBER_TABLE
697: , p15_a11 out nocopy JTF_NUMBER_TABLE

Line 695: , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100

691: , p15_a5 out nocopy JTF_NUMBER_TABLE
692: , p15_a6 out nocopy JTF_VARCHAR2_TABLE_100
693: , p15_a7 out nocopy JTF_VARCHAR2_TABLE_100
694: , p15_a8 out nocopy JTF_NUMBER_TABLE
695: , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100
696: , p15_a10 out nocopy JTF_NUMBER_TABLE
697: , p15_a11 out nocopy JTF_NUMBER_TABLE
698: )
699:

Line 786: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

782: , p8_a1 out nocopy JTF_NUMBER_TABLE
783: , p8_a2 out nocopy JTF_NUMBER_TABLE
784: , p8_a3 out nocopy JTF_NUMBER_TABLE
785: , p8_a4 out nocopy JTF_NUMBER_TABLE
786: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
787: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
788: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
789: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
790: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 787: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100

783: , p8_a2 out nocopy JTF_NUMBER_TABLE
784: , p8_a3 out nocopy JTF_NUMBER_TABLE
785: , p8_a4 out nocopy JTF_NUMBER_TABLE
786: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
787: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
788: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
789: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
790: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
791: , p9_a0 out nocopy JTF_NUMBER_TABLE

Line 788: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100

784: , p8_a3 out nocopy JTF_NUMBER_TABLE
785: , p8_a4 out nocopy JTF_NUMBER_TABLE
786: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
787: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
788: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
789: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
790: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
791: , p9_a0 out nocopy JTF_NUMBER_TABLE
792: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 789: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100

785: , p8_a4 out nocopy JTF_NUMBER_TABLE
786: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
787: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
788: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
789: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
790: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
791: , p9_a0 out nocopy JTF_NUMBER_TABLE
792: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
793: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200

Line 790: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100

786: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
787: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
788: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
789: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
790: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
791: , p9_a0 out nocopy JTF_NUMBER_TABLE
792: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
793: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
794: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 794: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100

790: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
791: , p9_a0 out nocopy JTF_NUMBER_TABLE
792: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
793: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
794: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
795: , p9_a4 out nocopy JTF_NUMBER_TABLE
796: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
797: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_300
798: , p9_a7 out nocopy JTF_NUMBER_TABLE

Line 801: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100

797: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_300
798: , p9_a7 out nocopy JTF_NUMBER_TABLE
799: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
800: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_2000
801: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
802: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
803: , p9_a12 out nocopy JTF_NUMBER_TABLE
804: , p9_a13 out nocopy JTF_DATE_TABLE
805: , p9_a14 out nocopy JTF_DATE_TABLE

Line 802: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100

798: , p9_a7 out nocopy JTF_NUMBER_TABLE
799: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
800: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_2000
801: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
802: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
803: , p9_a12 out nocopy JTF_NUMBER_TABLE
804: , p9_a13 out nocopy JTF_DATE_TABLE
805: , p9_a14 out nocopy JTF_DATE_TABLE
806: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 806: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100

802: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
803: , p9_a12 out nocopy JTF_NUMBER_TABLE
804: , p9_a13 out nocopy JTF_DATE_TABLE
805: , p9_a14 out nocopy JTF_DATE_TABLE
806: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
807: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
808: , p9_a17 out nocopy JTF_DATE_TABLE
809: , p9_a18 out nocopy JTF_DATE_TABLE
810: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 807: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100

803: , p9_a12 out nocopy JTF_NUMBER_TABLE
804: , p9_a13 out nocopy JTF_DATE_TABLE
805: , p9_a14 out nocopy JTF_DATE_TABLE
806: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
807: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
808: , p9_a17 out nocopy JTF_DATE_TABLE
809: , p9_a18 out nocopy JTF_DATE_TABLE
810: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
811: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_2000

Line 810: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100

806: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
807: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
808: , p9_a17 out nocopy JTF_DATE_TABLE
809: , p9_a18 out nocopy JTF_DATE_TABLE
810: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
811: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_2000
812: , p9_a21 out nocopy JTF_DATE_TABLE
813: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_100
814: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500

Line 813: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_100

809: , p9_a18 out nocopy JTF_DATE_TABLE
810: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
811: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_2000
812: , p9_a21 out nocopy JTF_DATE_TABLE
813: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_100
814: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
815: , p9_a24 out nocopy JTF_NUMBER_TABLE
816: )
817:

Line 910: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100

906: , p_include_donotimplmt VARCHAR2
907: , p11_a0 out nocopy JTF_NUMBER_TABLE
908: , p11_a1 out nocopy JTF_NUMBER_TABLE
909: , p11_a2 out nocopy JTF_NUMBER_TABLE
910: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
911: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
912: , p11_a5 out nocopy JTF_NUMBER_TABLE
913: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
914: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 911: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100

907: , p11_a0 out nocopy JTF_NUMBER_TABLE
908: , p11_a1 out nocopy JTF_NUMBER_TABLE
909: , p11_a2 out nocopy JTF_NUMBER_TABLE
910: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
911: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
912: , p11_a5 out nocopy JTF_NUMBER_TABLE
913: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
914: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
915: , p11_a8 out nocopy JTF_NUMBER_TABLE

Line 913: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100

909: , p11_a2 out nocopy JTF_NUMBER_TABLE
910: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
911: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
912: , p11_a5 out nocopy JTF_NUMBER_TABLE
913: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
914: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
915: , p11_a8 out nocopy JTF_NUMBER_TABLE
916: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
917: , p11_a10 out nocopy JTF_NUMBER_TABLE

Line 914: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100

910: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
911: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
912: , p11_a5 out nocopy JTF_NUMBER_TABLE
913: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
914: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
915: , p11_a8 out nocopy JTF_NUMBER_TABLE
916: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
917: , p11_a10 out nocopy JTF_NUMBER_TABLE
918: , p11_a11 out nocopy JTF_NUMBER_TABLE

Line 916: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100

912: , p11_a5 out nocopy JTF_NUMBER_TABLE
913: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
914: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
915: , p11_a8 out nocopy JTF_NUMBER_TABLE
916: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
917: , p11_a10 out nocopy JTF_NUMBER_TABLE
918: , p11_a11 out nocopy JTF_NUMBER_TABLE
919: )
920: