DBA Data[Home] [Help]

APPS.AHL_UC_INSTANCE_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 177: , a5 JTF_VARCHAR2_TABLE_300

173: , a1 JTF_NUMBER_TABLE
174: , a2 JTF_NUMBER_TABLE
175: , a3 JTF_NUMBER_TABLE
176: , a4 JTF_VARCHAR2_TABLE_100
177: , a5 JTF_VARCHAR2_TABLE_300
178: , a6 JTF_VARCHAR2_TABLE_300
179: , a7 JTF_VARCHAR2_TABLE_100
180: , a8 JTF_VARCHAR2_TABLE_100
181: , a9 JTF_VARCHAR2_TABLE_100

Line 178: , a6 JTF_VARCHAR2_TABLE_300

174: , a2 JTF_NUMBER_TABLE
175: , a3 JTF_NUMBER_TABLE
176: , a4 JTF_VARCHAR2_TABLE_100
177: , a5 JTF_VARCHAR2_TABLE_300
178: , a6 JTF_VARCHAR2_TABLE_300
179: , a7 JTF_VARCHAR2_TABLE_100
180: , a8 JTF_VARCHAR2_TABLE_100
181: , a9 JTF_VARCHAR2_TABLE_100
182: , a10 JTF_VARCHAR2_TABLE_100

Line 197: , a25 JTF_VARCHAR2_TABLE_300

193: , a21 JTF_NUMBER_TABLE
194: , a22 JTF_VARCHAR2_TABLE_100
195: , a23 JTF_NUMBER_TABLE
196: , a24 JTF_VARCHAR2_TABLE_100
197: , a25 JTF_VARCHAR2_TABLE_300
198: , a26 JTF_NUMBER_TABLE
199: , a27 JTF_VARCHAR2_TABLE_100
200: , a28 JTF_VARCHAR2_TABLE_100
201: , a29 JTF_NUMBER_TABLE

Line 206: , a34 JTF_VARCHAR2_TABLE_300

202: , a30 JTF_VARCHAR2_TABLE_100
203: , a31 JTF_VARCHAR2_TABLE_100
204: , a32 JTF_VARCHAR2_TABLE_100
205: , a33 JTF_VARCHAR2_TABLE_100
206: , a34 JTF_VARCHAR2_TABLE_300
207: , a35 JTF_NUMBER_TABLE
208: , a36 JTF_VARCHAR2_TABLE_100
209: , a37 JTF_NUMBER_TABLE
210: , a38 JTF_VARCHAR2_TABLE_300

Line 210: , a38 JTF_VARCHAR2_TABLE_300

206: , a34 JTF_VARCHAR2_TABLE_300
207: , a35 JTF_NUMBER_TABLE
208: , a36 JTF_VARCHAR2_TABLE_100
209: , a37 JTF_NUMBER_TABLE
210: , a38 JTF_VARCHAR2_TABLE_300
211: ) as
212: ddindx binary_integer; indx binary_integer;
213: begin
214: if a0 is not null and a0.count > 0 then

Line 272: , a5 out nocopy JTF_VARCHAR2_TABLE_300

268: , a1 out nocopy JTF_NUMBER_TABLE
269: , a2 out nocopy JTF_NUMBER_TABLE
270: , a3 out nocopy JTF_NUMBER_TABLE
271: , a4 out nocopy JTF_VARCHAR2_TABLE_100
272: , a5 out nocopy JTF_VARCHAR2_TABLE_300
273: , a6 out nocopy JTF_VARCHAR2_TABLE_300
274: , a7 out nocopy JTF_VARCHAR2_TABLE_100
275: , a8 out nocopy JTF_VARCHAR2_TABLE_100
276: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 273: , a6 out nocopy JTF_VARCHAR2_TABLE_300

269: , a2 out nocopy JTF_NUMBER_TABLE
270: , a3 out nocopy JTF_NUMBER_TABLE
271: , a4 out nocopy JTF_VARCHAR2_TABLE_100
272: , a5 out nocopy JTF_VARCHAR2_TABLE_300
273: , a6 out nocopy JTF_VARCHAR2_TABLE_300
274: , a7 out nocopy JTF_VARCHAR2_TABLE_100
275: , a8 out nocopy JTF_VARCHAR2_TABLE_100
276: , a9 out nocopy JTF_VARCHAR2_TABLE_100
277: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 292: , a25 out nocopy JTF_VARCHAR2_TABLE_300

288: , a21 out nocopy JTF_NUMBER_TABLE
289: , a22 out nocopy JTF_VARCHAR2_TABLE_100
290: , a23 out nocopy JTF_NUMBER_TABLE
291: , a24 out nocopy JTF_VARCHAR2_TABLE_100
292: , a25 out nocopy JTF_VARCHAR2_TABLE_300
293: , a26 out nocopy JTF_NUMBER_TABLE
294: , a27 out nocopy JTF_VARCHAR2_TABLE_100
295: , a28 out nocopy JTF_VARCHAR2_TABLE_100
296: , a29 out nocopy JTF_NUMBER_TABLE

Line 301: , a34 out nocopy JTF_VARCHAR2_TABLE_300

297: , a30 out nocopy JTF_VARCHAR2_TABLE_100
298: , a31 out nocopy JTF_VARCHAR2_TABLE_100
299: , a32 out nocopy JTF_VARCHAR2_TABLE_100
300: , a33 out nocopy JTF_VARCHAR2_TABLE_100
301: , a34 out nocopy JTF_VARCHAR2_TABLE_300
302: , a35 out nocopy JTF_NUMBER_TABLE
303: , a36 out nocopy JTF_VARCHAR2_TABLE_100
304: , a37 out nocopy JTF_NUMBER_TABLE
305: , a38 out nocopy JTF_VARCHAR2_TABLE_300

Line 305: , a38 out nocopy JTF_VARCHAR2_TABLE_300

301: , a34 out nocopy JTF_VARCHAR2_TABLE_300
302: , a35 out nocopy JTF_NUMBER_TABLE
303: , a36 out nocopy JTF_VARCHAR2_TABLE_100
304: , a37 out nocopy JTF_NUMBER_TABLE
305: , a38 out nocopy JTF_VARCHAR2_TABLE_300
306: ) as
307: ddindx binary_integer; indx binary_integer;
308: begin
309: if t is null or t.count = 0 then

Line 315: a5 := JTF_VARCHAR2_TABLE_300();

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

Line 316: a6 := JTF_VARCHAR2_TABLE_300();

312: a2 := JTF_NUMBER_TABLE();
313: a3 := JTF_NUMBER_TABLE();
314: a4 := JTF_VARCHAR2_TABLE_100();
315: a5 := JTF_VARCHAR2_TABLE_300();
316: a6 := JTF_VARCHAR2_TABLE_300();
317: a7 := JTF_VARCHAR2_TABLE_100();
318: a8 := JTF_VARCHAR2_TABLE_100();
319: a9 := JTF_VARCHAR2_TABLE_100();
320: a10 := JTF_VARCHAR2_TABLE_100();

Line 335: a25 := JTF_VARCHAR2_TABLE_300();

331: a21 := JTF_NUMBER_TABLE();
332: a22 := JTF_VARCHAR2_TABLE_100();
333: a23 := JTF_NUMBER_TABLE();
334: a24 := JTF_VARCHAR2_TABLE_100();
335: a25 := JTF_VARCHAR2_TABLE_300();
336: a26 := JTF_NUMBER_TABLE();
337: a27 := JTF_VARCHAR2_TABLE_100();
338: a28 := JTF_VARCHAR2_TABLE_100();
339: a29 := JTF_NUMBER_TABLE();

Line 344: a34 := JTF_VARCHAR2_TABLE_300();

340: a30 := JTF_VARCHAR2_TABLE_100();
341: a31 := JTF_VARCHAR2_TABLE_100();
342: a32 := JTF_VARCHAR2_TABLE_100();
343: a33 := JTF_VARCHAR2_TABLE_100();
344: a34 := JTF_VARCHAR2_TABLE_300();
345: a35 := JTF_NUMBER_TABLE();
346: a36 := JTF_VARCHAR2_TABLE_100();
347: a37 := JTF_NUMBER_TABLE();
348: a38 := JTF_VARCHAR2_TABLE_300();

Line 348: a38 := JTF_VARCHAR2_TABLE_300();

344: a34 := JTF_VARCHAR2_TABLE_300();
345: a35 := JTF_NUMBER_TABLE();
346: a36 := JTF_VARCHAR2_TABLE_100();
347: a37 := JTF_NUMBER_TABLE();
348: a38 := JTF_VARCHAR2_TABLE_300();
349: else
350: a0 := JTF_NUMBER_TABLE();
351: a1 := JTF_NUMBER_TABLE();
352: a2 := JTF_NUMBER_TABLE();

Line 355: a5 := JTF_VARCHAR2_TABLE_300();

351: a1 := JTF_NUMBER_TABLE();
352: a2 := JTF_NUMBER_TABLE();
353: a3 := JTF_NUMBER_TABLE();
354: a4 := JTF_VARCHAR2_TABLE_100();
355: a5 := JTF_VARCHAR2_TABLE_300();
356: a6 := JTF_VARCHAR2_TABLE_300();
357: a7 := JTF_VARCHAR2_TABLE_100();
358: a8 := JTF_VARCHAR2_TABLE_100();
359: a9 := JTF_VARCHAR2_TABLE_100();

Line 356: a6 := JTF_VARCHAR2_TABLE_300();

352: a2 := JTF_NUMBER_TABLE();
353: a3 := JTF_NUMBER_TABLE();
354: a4 := JTF_VARCHAR2_TABLE_100();
355: a5 := JTF_VARCHAR2_TABLE_300();
356: a6 := JTF_VARCHAR2_TABLE_300();
357: a7 := JTF_VARCHAR2_TABLE_100();
358: a8 := JTF_VARCHAR2_TABLE_100();
359: a9 := JTF_VARCHAR2_TABLE_100();
360: a10 := JTF_VARCHAR2_TABLE_100();

Line 375: a25 := JTF_VARCHAR2_TABLE_300();

371: a21 := JTF_NUMBER_TABLE();
372: a22 := JTF_VARCHAR2_TABLE_100();
373: a23 := JTF_NUMBER_TABLE();
374: a24 := JTF_VARCHAR2_TABLE_100();
375: a25 := JTF_VARCHAR2_TABLE_300();
376: a26 := JTF_NUMBER_TABLE();
377: a27 := JTF_VARCHAR2_TABLE_100();
378: a28 := JTF_VARCHAR2_TABLE_100();
379: a29 := JTF_NUMBER_TABLE();

Line 384: a34 := JTF_VARCHAR2_TABLE_300();

380: a30 := JTF_VARCHAR2_TABLE_100();
381: a31 := JTF_VARCHAR2_TABLE_100();
382: a32 := JTF_VARCHAR2_TABLE_100();
383: a33 := JTF_VARCHAR2_TABLE_100();
384: a34 := JTF_VARCHAR2_TABLE_300();
385: a35 := JTF_NUMBER_TABLE();
386: a36 := JTF_VARCHAR2_TABLE_100();
387: a37 := JTF_NUMBER_TABLE();
388: a38 := JTF_VARCHAR2_TABLE_300();

Line 388: a38 := JTF_VARCHAR2_TABLE_300();

384: a34 := JTF_VARCHAR2_TABLE_300();
385: a35 := JTF_NUMBER_TABLE();
386: a36 := JTF_VARCHAR2_TABLE_100();
387: a37 := JTF_NUMBER_TABLE();
388: a38 := JTF_VARCHAR2_TABLE_300();
389: if t.count > 0 then
390: a0.extend(t.count);
391: a1.extend(t.count);
392: a2.extend(t.count);

Line 1093: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300

1089: , p14_a1 out nocopy JTF_NUMBER_TABLE
1090: , p14_a2 out nocopy JTF_NUMBER_TABLE
1091: , p14_a3 out nocopy JTF_NUMBER_TABLE
1092: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100
1093: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300
1094: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_300
1095: , p14_a7 out nocopy JTF_VARCHAR2_TABLE_100
1096: , p14_a8 out nocopy JTF_VARCHAR2_TABLE_100
1097: , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 1094: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_300

1090: , p14_a2 out nocopy JTF_NUMBER_TABLE
1091: , p14_a3 out nocopy JTF_NUMBER_TABLE
1092: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100
1093: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300
1094: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_300
1095: , p14_a7 out nocopy JTF_VARCHAR2_TABLE_100
1096: , p14_a8 out nocopy JTF_VARCHAR2_TABLE_100
1097: , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100
1098: , p14_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 1113: , p14_a25 out nocopy JTF_VARCHAR2_TABLE_300

1109: , p14_a21 out nocopy JTF_NUMBER_TABLE
1110: , p14_a22 out nocopy JTF_VARCHAR2_TABLE_100
1111: , p14_a23 out nocopy JTF_NUMBER_TABLE
1112: , p14_a24 out nocopy JTF_VARCHAR2_TABLE_100
1113: , p14_a25 out nocopy JTF_VARCHAR2_TABLE_300
1114: , p14_a26 out nocopy JTF_NUMBER_TABLE
1115: , p14_a27 out nocopy JTF_VARCHAR2_TABLE_100
1116: , p14_a28 out nocopy JTF_VARCHAR2_TABLE_100
1117: , p14_a29 out nocopy JTF_NUMBER_TABLE

Line 1122: , p14_a34 out nocopy JTF_VARCHAR2_TABLE_300

1118: , p14_a30 out nocopy JTF_VARCHAR2_TABLE_100
1119: , p14_a31 out nocopy JTF_VARCHAR2_TABLE_100
1120: , p14_a32 out nocopy JTF_VARCHAR2_TABLE_100
1121: , p14_a33 out nocopy JTF_VARCHAR2_TABLE_100
1122: , p14_a34 out nocopy JTF_VARCHAR2_TABLE_300
1123: , p14_a35 out nocopy JTF_NUMBER_TABLE
1124: , p14_a36 out nocopy JTF_VARCHAR2_TABLE_100
1125: , p14_a37 out nocopy JTF_NUMBER_TABLE
1126: , p14_a38 out nocopy JTF_VARCHAR2_TABLE_300

Line 1126: , p14_a38 out nocopy JTF_VARCHAR2_TABLE_300

1122: , p14_a34 out nocopy JTF_VARCHAR2_TABLE_300
1123: , p14_a35 out nocopy JTF_NUMBER_TABLE
1124: , p14_a36 out nocopy JTF_VARCHAR2_TABLE_100
1125: , p14_a37 out nocopy JTF_NUMBER_TABLE
1126: , p14_a38 out nocopy JTF_VARCHAR2_TABLE_300
1127: , x_tbl_count out nocopy NUMBER
1128: )
1129:
1130: as

Line 1246: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_300

1242: , p13_a1 out nocopy JTF_NUMBER_TABLE
1243: , p13_a2 out nocopy JTF_NUMBER_TABLE
1244: , p13_a3 out nocopy JTF_NUMBER_TABLE
1245: , p13_a4 out nocopy JTF_VARCHAR2_TABLE_100
1246: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_300
1247: , p13_a6 out nocopy JTF_VARCHAR2_TABLE_300
1248: , p13_a7 out nocopy JTF_VARCHAR2_TABLE_100
1249: , p13_a8 out nocopy JTF_VARCHAR2_TABLE_100
1250: , p13_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 1247: , p13_a6 out nocopy JTF_VARCHAR2_TABLE_300

1243: , p13_a2 out nocopy JTF_NUMBER_TABLE
1244: , p13_a3 out nocopy JTF_NUMBER_TABLE
1245: , p13_a4 out nocopy JTF_VARCHAR2_TABLE_100
1246: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_300
1247: , p13_a6 out nocopy JTF_VARCHAR2_TABLE_300
1248: , p13_a7 out nocopy JTF_VARCHAR2_TABLE_100
1249: , p13_a8 out nocopy JTF_VARCHAR2_TABLE_100
1250: , p13_a9 out nocopy JTF_VARCHAR2_TABLE_100
1251: , p13_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 1266: , p13_a25 out nocopy JTF_VARCHAR2_TABLE_300

1262: , p13_a21 out nocopy JTF_NUMBER_TABLE
1263: , p13_a22 out nocopy JTF_VARCHAR2_TABLE_100
1264: , p13_a23 out nocopy JTF_NUMBER_TABLE
1265: , p13_a24 out nocopy JTF_VARCHAR2_TABLE_100
1266: , p13_a25 out nocopy JTF_VARCHAR2_TABLE_300
1267: , p13_a26 out nocopy JTF_NUMBER_TABLE
1268: , p13_a27 out nocopy JTF_VARCHAR2_TABLE_100
1269: , p13_a28 out nocopy JTF_VARCHAR2_TABLE_100
1270: , p13_a29 out nocopy JTF_NUMBER_TABLE

Line 1275: , p13_a34 out nocopy JTF_VARCHAR2_TABLE_300

1271: , p13_a30 out nocopy JTF_VARCHAR2_TABLE_100
1272: , p13_a31 out nocopy JTF_VARCHAR2_TABLE_100
1273: , p13_a32 out nocopy JTF_VARCHAR2_TABLE_100
1274: , p13_a33 out nocopy JTF_VARCHAR2_TABLE_100
1275: , p13_a34 out nocopy JTF_VARCHAR2_TABLE_300
1276: , p13_a35 out nocopy JTF_NUMBER_TABLE
1277: , p13_a36 out nocopy JTF_VARCHAR2_TABLE_100
1278: , p13_a37 out nocopy JTF_NUMBER_TABLE
1279: , p13_a38 out nocopy JTF_VARCHAR2_TABLE_300

Line 1279: , p13_a38 out nocopy JTF_VARCHAR2_TABLE_300

1275: , p13_a34 out nocopy JTF_VARCHAR2_TABLE_300
1276: , p13_a35 out nocopy JTF_NUMBER_TABLE
1277: , p13_a36 out nocopy JTF_VARCHAR2_TABLE_100
1278: , p13_a37 out nocopy JTF_NUMBER_TABLE
1279: , p13_a38 out nocopy JTF_VARCHAR2_TABLE_300
1280: )
1281:
1282: as
1283: ddx_avail_subinv_instance_tbl ahl_uc_instance_pvt.available_instance_tbl_type;