DBA Data[Home] [Help]

APPS.AHL_UC_INSTANCE_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 164: , a5 JTF_VARCHAR2_TABLE_300

160: , a1 JTF_NUMBER_TABLE
161: , a2 JTF_NUMBER_TABLE
162: , a3 JTF_NUMBER_TABLE
163: , a4 JTF_VARCHAR2_TABLE_100
164: , a5 JTF_VARCHAR2_TABLE_300
165: , a6 JTF_VARCHAR2_TABLE_300
166: , a7 JTF_VARCHAR2_TABLE_100
167: , a8 JTF_VARCHAR2_TABLE_100
168: , a9 JTF_VARCHAR2_TABLE_100

Line 165: , a6 JTF_VARCHAR2_TABLE_300

161: , a2 JTF_NUMBER_TABLE
162: , a3 JTF_NUMBER_TABLE
163: , a4 JTF_VARCHAR2_TABLE_100
164: , a5 JTF_VARCHAR2_TABLE_300
165: , a6 JTF_VARCHAR2_TABLE_300
166: , a7 JTF_VARCHAR2_TABLE_100
167: , a8 JTF_VARCHAR2_TABLE_100
168: , a9 JTF_VARCHAR2_TABLE_100
169: , a10 JTF_VARCHAR2_TABLE_100

Line 184: , a25 JTF_VARCHAR2_TABLE_300

180: , a21 JTF_NUMBER_TABLE
181: , a22 JTF_VARCHAR2_TABLE_100
182: , a23 JTF_NUMBER_TABLE
183: , a24 JTF_VARCHAR2_TABLE_100
184: , a25 JTF_VARCHAR2_TABLE_300
185: , a26 JTF_NUMBER_TABLE
186: , a27 JTF_VARCHAR2_TABLE_100
187: , a28 JTF_VARCHAR2_TABLE_100
188: , a29 JTF_NUMBER_TABLE

Line 193: , a34 JTF_VARCHAR2_TABLE_300

189: , a30 JTF_VARCHAR2_TABLE_100
190: , a31 JTF_VARCHAR2_TABLE_100
191: , a32 JTF_VARCHAR2_TABLE_100
192: , a33 JTF_VARCHAR2_TABLE_100
193: , a34 JTF_VARCHAR2_TABLE_300
194: , a35 JTF_NUMBER_TABLE
195: , a36 JTF_VARCHAR2_TABLE_100
196: , a37 JTF_NUMBER_TABLE
197: , a38 JTF_VARCHAR2_TABLE_300

Line 197: , a38 JTF_VARCHAR2_TABLE_300

193: , a34 JTF_VARCHAR2_TABLE_300
194: , a35 JTF_NUMBER_TABLE
195: , a36 JTF_VARCHAR2_TABLE_100
196: , a37 JTF_NUMBER_TABLE
197: , a38 JTF_VARCHAR2_TABLE_300
198: ) as
199: ddindx binary_integer; indx binary_integer;
200: begin
201: if a0 is not null and a0.count > 0 then

Line 259: , a5 out nocopy JTF_VARCHAR2_TABLE_300

255: , a1 out nocopy JTF_NUMBER_TABLE
256: , a2 out nocopy JTF_NUMBER_TABLE
257: , a3 out nocopy JTF_NUMBER_TABLE
258: , a4 out nocopy JTF_VARCHAR2_TABLE_100
259: , a5 out nocopy JTF_VARCHAR2_TABLE_300
260: , a6 out nocopy JTF_VARCHAR2_TABLE_300
261: , a7 out nocopy JTF_VARCHAR2_TABLE_100
262: , a8 out nocopy JTF_VARCHAR2_TABLE_100
263: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 260: , a6 out nocopy JTF_VARCHAR2_TABLE_300

256: , a2 out nocopy JTF_NUMBER_TABLE
257: , a3 out nocopy JTF_NUMBER_TABLE
258: , a4 out nocopy JTF_VARCHAR2_TABLE_100
259: , a5 out nocopy JTF_VARCHAR2_TABLE_300
260: , a6 out nocopy JTF_VARCHAR2_TABLE_300
261: , a7 out nocopy JTF_VARCHAR2_TABLE_100
262: , a8 out nocopy JTF_VARCHAR2_TABLE_100
263: , a9 out nocopy JTF_VARCHAR2_TABLE_100
264: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 279: , a25 out nocopy JTF_VARCHAR2_TABLE_300

275: , a21 out nocopy JTF_NUMBER_TABLE
276: , a22 out nocopy JTF_VARCHAR2_TABLE_100
277: , a23 out nocopy JTF_NUMBER_TABLE
278: , a24 out nocopy JTF_VARCHAR2_TABLE_100
279: , a25 out nocopy JTF_VARCHAR2_TABLE_300
280: , a26 out nocopy JTF_NUMBER_TABLE
281: , a27 out nocopy JTF_VARCHAR2_TABLE_100
282: , a28 out nocopy JTF_VARCHAR2_TABLE_100
283: , a29 out nocopy JTF_NUMBER_TABLE

Line 288: , a34 out nocopy JTF_VARCHAR2_TABLE_300

284: , a30 out nocopy JTF_VARCHAR2_TABLE_100
285: , a31 out nocopy JTF_VARCHAR2_TABLE_100
286: , a32 out nocopy JTF_VARCHAR2_TABLE_100
287: , a33 out nocopy JTF_VARCHAR2_TABLE_100
288: , a34 out nocopy JTF_VARCHAR2_TABLE_300
289: , a35 out nocopy JTF_NUMBER_TABLE
290: , a36 out nocopy JTF_VARCHAR2_TABLE_100
291: , a37 out nocopy JTF_NUMBER_TABLE
292: , a38 out nocopy JTF_VARCHAR2_TABLE_300

Line 292: , a38 out nocopy JTF_VARCHAR2_TABLE_300

288: , a34 out nocopy JTF_VARCHAR2_TABLE_300
289: , a35 out nocopy JTF_NUMBER_TABLE
290: , a36 out nocopy JTF_VARCHAR2_TABLE_100
291: , a37 out nocopy JTF_NUMBER_TABLE
292: , a38 out nocopy JTF_VARCHAR2_TABLE_300
293: ) as
294: ddindx binary_integer; indx binary_integer;
295: begin
296: if t is null or t.count = 0 then

Line 302: a5 := JTF_VARCHAR2_TABLE_300();

298: a1 := JTF_NUMBER_TABLE();
299: a2 := JTF_NUMBER_TABLE();
300: a3 := JTF_NUMBER_TABLE();
301: a4 := JTF_VARCHAR2_TABLE_100();
302: a5 := JTF_VARCHAR2_TABLE_300();
303: a6 := JTF_VARCHAR2_TABLE_300();
304: a7 := JTF_VARCHAR2_TABLE_100();
305: a8 := JTF_VARCHAR2_TABLE_100();
306: a9 := JTF_VARCHAR2_TABLE_100();

Line 303: a6 := JTF_VARCHAR2_TABLE_300();

299: a2 := JTF_NUMBER_TABLE();
300: a3 := JTF_NUMBER_TABLE();
301: a4 := JTF_VARCHAR2_TABLE_100();
302: a5 := JTF_VARCHAR2_TABLE_300();
303: a6 := JTF_VARCHAR2_TABLE_300();
304: a7 := JTF_VARCHAR2_TABLE_100();
305: a8 := JTF_VARCHAR2_TABLE_100();
306: a9 := JTF_VARCHAR2_TABLE_100();
307: a10 := JTF_VARCHAR2_TABLE_100();

Line 322: a25 := JTF_VARCHAR2_TABLE_300();

318: a21 := JTF_NUMBER_TABLE();
319: a22 := JTF_VARCHAR2_TABLE_100();
320: a23 := JTF_NUMBER_TABLE();
321: a24 := JTF_VARCHAR2_TABLE_100();
322: a25 := JTF_VARCHAR2_TABLE_300();
323: a26 := JTF_NUMBER_TABLE();
324: a27 := JTF_VARCHAR2_TABLE_100();
325: a28 := JTF_VARCHAR2_TABLE_100();
326: a29 := JTF_NUMBER_TABLE();

Line 331: a34 := JTF_VARCHAR2_TABLE_300();

327: a30 := JTF_VARCHAR2_TABLE_100();
328: a31 := JTF_VARCHAR2_TABLE_100();
329: a32 := JTF_VARCHAR2_TABLE_100();
330: a33 := JTF_VARCHAR2_TABLE_100();
331: a34 := JTF_VARCHAR2_TABLE_300();
332: a35 := JTF_NUMBER_TABLE();
333: a36 := JTF_VARCHAR2_TABLE_100();
334: a37 := JTF_NUMBER_TABLE();
335: a38 := JTF_VARCHAR2_TABLE_300();

Line 335: a38 := JTF_VARCHAR2_TABLE_300();

331: a34 := JTF_VARCHAR2_TABLE_300();
332: a35 := JTF_NUMBER_TABLE();
333: a36 := JTF_VARCHAR2_TABLE_100();
334: a37 := JTF_NUMBER_TABLE();
335: a38 := JTF_VARCHAR2_TABLE_300();
336: else
337: a0 := JTF_NUMBER_TABLE();
338: a1 := JTF_NUMBER_TABLE();
339: a2 := JTF_NUMBER_TABLE();

Line 342: a5 := JTF_VARCHAR2_TABLE_300();

338: a1 := JTF_NUMBER_TABLE();
339: a2 := JTF_NUMBER_TABLE();
340: a3 := JTF_NUMBER_TABLE();
341: a4 := JTF_VARCHAR2_TABLE_100();
342: a5 := JTF_VARCHAR2_TABLE_300();
343: a6 := JTF_VARCHAR2_TABLE_300();
344: a7 := JTF_VARCHAR2_TABLE_100();
345: a8 := JTF_VARCHAR2_TABLE_100();
346: a9 := JTF_VARCHAR2_TABLE_100();

Line 343: a6 := JTF_VARCHAR2_TABLE_300();

339: a2 := JTF_NUMBER_TABLE();
340: a3 := JTF_NUMBER_TABLE();
341: a4 := JTF_VARCHAR2_TABLE_100();
342: a5 := JTF_VARCHAR2_TABLE_300();
343: a6 := JTF_VARCHAR2_TABLE_300();
344: a7 := JTF_VARCHAR2_TABLE_100();
345: a8 := JTF_VARCHAR2_TABLE_100();
346: a9 := JTF_VARCHAR2_TABLE_100();
347: a10 := JTF_VARCHAR2_TABLE_100();

Line 362: a25 := JTF_VARCHAR2_TABLE_300();

358: a21 := JTF_NUMBER_TABLE();
359: a22 := JTF_VARCHAR2_TABLE_100();
360: a23 := JTF_NUMBER_TABLE();
361: a24 := JTF_VARCHAR2_TABLE_100();
362: a25 := JTF_VARCHAR2_TABLE_300();
363: a26 := JTF_NUMBER_TABLE();
364: a27 := JTF_VARCHAR2_TABLE_100();
365: a28 := JTF_VARCHAR2_TABLE_100();
366: a29 := JTF_NUMBER_TABLE();

Line 371: a34 := JTF_VARCHAR2_TABLE_300();

367: a30 := JTF_VARCHAR2_TABLE_100();
368: a31 := JTF_VARCHAR2_TABLE_100();
369: a32 := JTF_VARCHAR2_TABLE_100();
370: a33 := JTF_VARCHAR2_TABLE_100();
371: a34 := JTF_VARCHAR2_TABLE_300();
372: a35 := JTF_NUMBER_TABLE();
373: a36 := JTF_VARCHAR2_TABLE_100();
374: a37 := JTF_NUMBER_TABLE();
375: a38 := JTF_VARCHAR2_TABLE_300();

Line 375: a38 := JTF_VARCHAR2_TABLE_300();

371: a34 := JTF_VARCHAR2_TABLE_300();
372: a35 := JTF_NUMBER_TABLE();
373: a36 := JTF_VARCHAR2_TABLE_100();
374: a37 := JTF_NUMBER_TABLE();
375: a38 := JTF_VARCHAR2_TABLE_300();
376: if t.count > 0 then
377: a0.extend(t.count);
378: a1.extend(t.count);
379: a2.extend(t.count);

Line 1084: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300

1080: , p14_a1 out nocopy JTF_NUMBER_TABLE
1081: , p14_a2 out nocopy JTF_NUMBER_TABLE
1082: , p14_a3 out nocopy JTF_NUMBER_TABLE
1083: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100
1084: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300
1085: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_300
1086: , p14_a7 out nocopy JTF_VARCHAR2_TABLE_100
1087: , p14_a8 out nocopy JTF_VARCHAR2_TABLE_100
1088: , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 1085: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_300

1081: , p14_a2 out nocopy JTF_NUMBER_TABLE
1082: , p14_a3 out nocopy JTF_NUMBER_TABLE
1083: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_100
1084: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300
1085: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_300
1086: , p14_a7 out nocopy JTF_VARCHAR2_TABLE_100
1087: , p14_a8 out nocopy JTF_VARCHAR2_TABLE_100
1088: , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100
1089: , p14_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 1104: , p14_a25 out nocopy JTF_VARCHAR2_TABLE_300

1100: , p14_a21 out nocopy JTF_NUMBER_TABLE
1101: , p14_a22 out nocopy JTF_VARCHAR2_TABLE_100
1102: , p14_a23 out nocopy JTF_NUMBER_TABLE
1103: , p14_a24 out nocopy JTF_VARCHAR2_TABLE_100
1104: , p14_a25 out nocopy JTF_VARCHAR2_TABLE_300
1105: , p14_a26 out nocopy JTF_NUMBER_TABLE
1106: , p14_a27 out nocopy JTF_VARCHAR2_TABLE_100
1107: , p14_a28 out nocopy JTF_VARCHAR2_TABLE_100
1108: , p14_a29 out nocopy JTF_NUMBER_TABLE

Line 1113: , p14_a34 out nocopy JTF_VARCHAR2_TABLE_300

1109: , p14_a30 out nocopy JTF_VARCHAR2_TABLE_100
1110: , p14_a31 out nocopy JTF_VARCHAR2_TABLE_100
1111: , p14_a32 out nocopy JTF_VARCHAR2_TABLE_100
1112: , p14_a33 out nocopy JTF_VARCHAR2_TABLE_100
1113: , p14_a34 out nocopy JTF_VARCHAR2_TABLE_300
1114: , p14_a35 out nocopy JTF_NUMBER_TABLE
1115: , p14_a36 out nocopy JTF_VARCHAR2_TABLE_100
1116: , p14_a37 out nocopy JTF_NUMBER_TABLE
1117: , p14_a38 out nocopy JTF_VARCHAR2_TABLE_300

Line 1117: , p14_a38 out nocopy JTF_VARCHAR2_TABLE_300

1113: , p14_a34 out nocopy JTF_VARCHAR2_TABLE_300
1114: , p14_a35 out nocopy JTF_NUMBER_TABLE
1115: , p14_a36 out nocopy JTF_VARCHAR2_TABLE_100
1116: , p14_a37 out nocopy JTF_NUMBER_TABLE
1117: , p14_a38 out nocopy JTF_VARCHAR2_TABLE_300
1118: , x_tbl_count out nocopy NUMBER
1119: )
1120:
1121: as

Line 1237: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_300

1233: , p13_a1 out nocopy JTF_NUMBER_TABLE
1234: , p13_a2 out nocopy JTF_NUMBER_TABLE
1235: , p13_a3 out nocopy JTF_NUMBER_TABLE
1236: , p13_a4 out nocopy JTF_VARCHAR2_TABLE_100
1237: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_300
1238: , p13_a6 out nocopy JTF_VARCHAR2_TABLE_300
1239: , p13_a7 out nocopy JTF_VARCHAR2_TABLE_100
1240: , p13_a8 out nocopy JTF_VARCHAR2_TABLE_100
1241: , p13_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 1238: , p13_a6 out nocopy JTF_VARCHAR2_TABLE_300

1234: , p13_a2 out nocopy JTF_NUMBER_TABLE
1235: , p13_a3 out nocopy JTF_NUMBER_TABLE
1236: , p13_a4 out nocopy JTF_VARCHAR2_TABLE_100
1237: , p13_a5 out nocopy JTF_VARCHAR2_TABLE_300
1238: , p13_a6 out nocopy JTF_VARCHAR2_TABLE_300
1239: , p13_a7 out nocopy JTF_VARCHAR2_TABLE_100
1240: , p13_a8 out nocopy JTF_VARCHAR2_TABLE_100
1241: , p13_a9 out nocopy JTF_VARCHAR2_TABLE_100
1242: , p13_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 1257: , p13_a25 out nocopy JTF_VARCHAR2_TABLE_300

1253: , p13_a21 out nocopy JTF_NUMBER_TABLE
1254: , p13_a22 out nocopy JTF_VARCHAR2_TABLE_100
1255: , p13_a23 out nocopy JTF_NUMBER_TABLE
1256: , p13_a24 out nocopy JTF_VARCHAR2_TABLE_100
1257: , p13_a25 out nocopy JTF_VARCHAR2_TABLE_300
1258: , p13_a26 out nocopy JTF_NUMBER_TABLE
1259: , p13_a27 out nocopy JTF_VARCHAR2_TABLE_100
1260: , p13_a28 out nocopy JTF_VARCHAR2_TABLE_100
1261: , p13_a29 out nocopy JTF_NUMBER_TABLE

Line 1266: , p13_a34 out nocopy JTF_VARCHAR2_TABLE_300

1262: , p13_a30 out nocopy JTF_VARCHAR2_TABLE_100
1263: , p13_a31 out nocopy JTF_VARCHAR2_TABLE_100
1264: , p13_a32 out nocopy JTF_VARCHAR2_TABLE_100
1265: , p13_a33 out nocopy JTF_VARCHAR2_TABLE_100
1266: , p13_a34 out nocopy JTF_VARCHAR2_TABLE_300
1267: , p13_a35 out nocopy JTF_NUMBER_TABLE
1268: , p13_a36 out nocopy JTF_VARCHAR2_TABLE_100
1269: , p13_a37 out nocopy JTF_NUMBER_TABLE
1270: , p13_a38 out nocopy JTF_VARCHAR2_TABLE_300

Line 1270: , p13_a38 out nocopy JTF_VARCHAR2_TABLE_300

1266: , p13_a34 out nocopy JTF_VARCHAR2_TABLE_300
1267: , p13_a35 out nocopy JTF_NUMBER_TABLE
1268: , p13_a36 out nocopy JTF_VARCHAR2_TABLE_100
1269: , p13_a37 out nocopy JTF_NUMBER_TABLE
1270: , p13_a38 out nocopy JTF_VARCHAR2_TABLE_300
1271: )
1272:
1273: as
1274: ddx_avail_subinv_instance_tbl ahl_uc_instance_pvt.available_instance_tbl_type;