APPS.AHL_PRD_WORKORDER_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 31: , a15 JTF_VARCHAR2_TABLE_100

27: , a11 JTF_NUMBER_TABLE
28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_VARCHAR2_TABLE_300
31: , a15 JTF_VARCHAR2_TABLE_100
32: , a16 JTF_VARCHAR2_TABLE_100
33: , a17 JTF_NUMBER_TABLE
34: , a18 JTF_VARCHAR2_TABLE_500
35: , a19 JTF_VARCHAR2_TABLE_100

Line 32: , a16 JTF_VARCHAR2_TABLE_100

28: , a12 JTF_NUMBER_TABLE
29: , a13 JTF_NUMBER_TABLE
30: , a14 JTF_VARCHAR2_TABLE_300
31: , a15 JTF_VARCHAR2_TABLE_100
32: , a16 JTF_VARCHAR2_TABLE_100
33: , a17 JTF_NUMBER_TABLE
34: , a18 JTF_VARCHAR2_TABLE_500
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_VARCHAR2_TABLE_100

Line 35: , a19 JTF_VARCHAR2_TABLE_100

31: , a15 JTF_VARCHAR2_TABLE_100
32: , a16 JTF_VARCHAR2_TABLE_100
33: , a17 JTF_NUMBER_TABLE
34: , a18 JTF_VARCHAR2_TABLE_500
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_VARCHAR2_TABLE_100
37: , a21 JTF_VARCHAR2_TABLE_100
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_NUMBER_TABLE

Line 36: , a20 JTF_VARCHAR2_TABLE_100

32: , a16 JTF_VARCHAR2_TABLE_100
33: , a17 JTF_NUMBER_TABLE
34: , a18 JTF_VARCHAR2_TABLE_500
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_VARCHAR2_TABLE_100
37: , a21 JTF_VARCHAR2_TABLE_100
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_NUMBER_TABLE
40: , a24 JTF_DATE_TABLE

Line 37: , a21 JTF_VARCHAR2_TABLE_100

33: , a17 JTF_NUMBER_TABLE
34: , a18 JTF_VARCHAR2_TABLE_500
35: , a19 JTF_VARCHAR2_TABLE_100
36: , a20 JTF_VARCHAR2_TABLE_100
37: , a21 JTF_VARCHAR2_TABLE_100
38: , a22 JTF_NUMBER_TABLE
39: , a23 JTF_NUMBER_TABLE
40: , a24 JTF_DATE_TABLE
41: , a25 JTF_NUMBER_TABLE

Line 54: , a38 JTF_VARCHAR2_TABLE_100

50: , a34 JTF_NUMBER_TABLE
51: , a35 JTF_NUMBER_TABLE
52: , a36 JTF_NUMBER_TABLE
53: , a37 JTF_NUMBER_TABLE
54: , a38 JTF_VARCHAR2_TABLE_100
55: , a39 JTF_NUMBER_TABLE
56: , a40 JTF_VARCHAR2_TABLE_100
57: , a41 JTF_VARCHAR2_TABLE_200
58: , a42 JTF_VARCHAR2_TABLE_200

Line 56: , a40 JTF_VARCHAR2_TABLE_100

52: , a36 JTF_NUMBER_TABLE
53: , a37 JTF_NUMBER_TABLE
54: , a38 JTF_VARCHAR2_TABLE_100
55: , a39 JTF_NUMBER_TABLE
56: , a40 JTF_VARCHAR2_TABLE_100
57: , a41 JTF_VARCHAR2_TABLE_200
58: , a42 JTF_VARCHAR2_TABLE_200
59: , a43 JTF_VARCHAR2_TABLE_200
60: , a44 JTF_VARCHAR2_TABLE_200

Line 72: , a56 JTF_VARCHAR2_TABLE_100

68: , a52 JTF_VARCHAR2_TABLE_200
69: , a53 JTF_VARCHAR2_TABLE_200
70: , a54 JTF_VARCHAR2_TABLE_200
71: , a55 JTF_VARCHAR2_TABLE_200
72: , a56 JTF_VARCHAR2_TABLE_100
73: ) as
74: ddindx binary_integer; indx binary_integer;
75: begin
76: if a0 is not null and a0.count > 0 then

Line 162: , a15 out nocopy JTF_VARCHAR2_TABLE_100

158: , a11 out nocopy JTF_NUMBER_TABLE
159: , a12 out nocopy JTF_NUMBER_TABLE
160: , a13 out nocopy JTF_NUMBER_TABLE
161: , a14 out nocopy JTF_VARCHAR2_TABLE_300
162: , a15 out nocopy JTF_VARCHAR2_TABLE_100
163: , a16 out nocopy JTF_VARCHAR2_TABLE_100
164: , a17 out nocopy JTF_NUMBER_TABLE
165: , a18 out nocopy JTF_VARCHAR2_TABLE_500
166: , a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 163: , a16 out nocopy JTF_VARCHAR2_TABLE_100

159: , a12 out nocopy JTF_NUMBER_TABLE
160: , a13 out nocopy JTF_NUMBER_TABLE
161: , a14 out nocopy JTF_VARCHAR2_TABLE_300
162: , a15 out nocopy JTF_VARCHAR2_TABLE_100
163: , a16 out nocopy JTF_VARCHAR2_TABLE_100
164: , a17 out nocopy JTF_NUMBER_TABLE
165: , a18 out nocopy JTF_VARCHAR2_TABLE_500
166: , a19 out nocopy JTF_VARCHAR2_TABLE_100
167: , a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 166: , a19 out nocopy JTF_VARCHAR2_TABLE_100

162: , a15 out nocopy JTF_VARCHAR2_TABLE_100
163: , a16 out nocopy JTF_VARCHAR2_TABLE_100
164: , a17 out nocopy JTF_NUMBER_TABLE
165: , a18 out nocopy JTF_VARCHAR2_TABLE_500
166: , a19 out nocopy JTF_VARCHAR2_TABLE_100
167: , a20 out nocopy JTF_VARCHAR2_TABLE_100
168: , a21 out nocopy JTF_VARCHAR2_TABLE_100
169: , a22 out nocopy JTF_NUMBER_TABLE
170: , a23 out nocopy JTF_NUMBER_TABLE

Line 167: , a20 out nocopy JTF_VARCHAR2_TABLE_100

163: , a16 out nocopy JTF_VARCHAR2_TABLE_100
164: , a17 out nocopy JTF_NUMBER_TABLE
165: , a18 out nocopy JTF_VARCHAR2_TABLE_500
166: , a19 out nocopy JTF_VARCHAR2_TABLE_100
167: , a20 out nocopy JTF_VARCHAR2_TABLE_100
168: , a21 out nocopy JTF_VARCHAR2_TABLE_100
169: , a22 out nocopy JTF_NUMBER_TABLE
170: , a23 out nocopy JTF_NUMBER_TABLE
171: , a24 out nocopy JTF_DATE_TABLE

Line 168: , a21 out nocopy JTF_VARCHAR2_TABLE_100

164: , a17 out nocopy JTF_NUMBER_TABLE
165: , a18 out nocopy JTF_VARCHAR2_TABLE_500
166: , a19 out nocopy JTF_VARCHAR2_TABLE_100
167: , a20 out nocopy JTF_VARCHAR2_TABLE_100
168: , a21 out nocopy JTF_VARCHAR2_TABLE_100
169: , a22 out nocopy JTF_NUMBER_TABLE
170: , a23 out nocopy JTF_NUMBER_TABLE
171: , a24 out nocopy JTF_DATE_TABLE
172: , a25 out nocopy JTF_NUMBER_TABLE

Line 185: , a38 out nocopy JTF_VARCHAR2_TABLE_100

181: , a34 out nocopy JTF_NUMBER_TABLE
182: , a35 out nocopy JTF_NUMBER_TABLE
183: , a36 out nocopy JTF_NUMBER_TABLE
184: , a37 out nocopy JTF_NUMBER_TABLE
185: , a38 out nocopy JTF_VARCHAR2_TABLE_100
186: , a39 out nocopy JTF_NUMBER_TABLE
187: , a40 out nocopy JTF_VARCHAR2_TABLE_100
188: , a41 out nocopy JTF_VARCHAR2_TABLE_200
189: , a42 out nocopy JTF_VARCHAR2_TABLE_200

Line 187: , a40 out nocopy JTF_VARCHAR2_TABLE_100

183: , a36 out nocopy JTF_NUMBER_TABLE
184: , a37 out nocopy JTF_NUMBER_TABLE
185: , a38 out nocopy JTF_VARCHAR2_TABLE_100
186: , a39 out nocopy JTF_NUMBER_TABLE
187: , a40 out nocopy JTF_VARCHAR2_TABLE_100
188: , a41 out nocopy JTF_VARCHAR2_TABLE_200
189: , a42 out nocopy JTF_VARCHAR2_TABLE_200
190: , a43 out nocopy JTF_VARCHAR2_TABLE_200
191: , a44 out nocopy JTF_VARCHAR2_TABLE_200

Line 203: , a56 out nocopy JTF_VARCHAR2_TABLE_100

199: , a52 out nocopy JTF_VARCHAR2_TABLE_200
200: , a53 out nocopy JTF_VARCHAR2_TABLE_200
201: , a54 out nocopy JTF_VARCHAR2_TABLE_200
202: , a55 out nocopy JTF_VARCHAR2_TABLE_200
203: , a56 out nocopy JTF_VARCHAR2_TABLE_100
204: ) as
205: ddindx binary_integer; indx binary_integer;
206: begin
207: if t is null or t.count = 0 then

Line 223: a15 := JTF_VARCHAR2_TABLE_100();

219: a11 := JTF_NUMBER_TABLE();
220: a12 := JTF_NUMBER_TABLE();
221: a13 := JTF_NUMBER_TABLE();
222: a14 := JTF_VARCHAR2_TABLE_300();
223: a15 := JTF_VARCHAR2_TABLE_100();
224: a16 := JTF_VARCHAR2_TABLE_100();
225: a17 := JTF_NUMBER_TABLE();
226: a18 := JTF_VARCHAR2_TABLE_500();
227: a19 := JTF_VARCHAR2_TABLE_100();

Line 224: a16 := JTF_VARCHAR2_TABLE_100();

220: a12 := JTF_NUMBER_TABLE();
221: a13 := JTF_NUMBER_TABLE();
222: a14 := JTF_VARCHAR2_TABLE_300();
223: a15 := JTF_VARCHAR2_TABLE_100();
224: a16 := JTF_VARCHAR2_TABLE_100();
225: a17 := JTF_NUMBER_TABLE();
226: a18 := JTF_VARCHAR2_TABLE_500();
227: a19 := JTF_VARCHAR2_TABLE_100();
228: a20 := JTF_VARCHAR2_TABLE_100();

Line 227: a19 := JTF_VARCHAR2_TABLE_100();

223: a15 := JTF_VARCHAR2_TABLE_100();
224: a16 := JTF_VARCHAR2_TABLE_100();
225: a17 := JTF_NUMBER_TABLE();
226: a18 := JTF_VARCHAR2_TABLE_500();
227: a19 := JTF_VARCHAR2_TABLE_100();
228: a20 := JTF_VARCHAR2_TABLE_100();
229: a21 := JTF_VARCHAR2_TABLE_100();
230: a22 := JTF_NUMBER_TABLE();
231: a23 := JTF_NUMBER_TABLE();

Line 228: a20 := JTF_VARCHAR2_TABLE_100();

224: a16 := JTF_VARCHAR2_TABLE_100();
225: a17 := JTF_NUMBER_TABLE();
226: a18 := JTF_VARCHAR2_TABLE_500();
227: a19 := JTF_VARCHAR2_TABLE_100();
228: a20 := JTF_VARCHAR2_TABLE_100();
229: a21 := JTF_VARCHAR2_TABLE_100();
230: a22 := JTF_NUMBER_TABLE();
231: a23 := JTF_NUMBER_TABLE();
232: a24 := JTF_DATE_TABLE();

Line 229: a21 := JTF_VARCHAR2_TABLE_100();

225: a17 := JTF_NUMBER_TABLE();
226: a18 := JTF_VARCHAR2_TABLE_500();
227: a19 := JTF_VARCHAR2_TABLE_100();
228: a20 := JTF_VARCHAR2_TABLE_100();
229: a21 := JTF_VARCHAR2_TABLE_100();
230: a22 := JTF_NUMBER_TABLE();
231: a23 := JTF_NUMBER_TABLE();
232: a24 := JTF_DATE_TABLE();
233: a25 := JTF_NUMBER_TABLE();

Line 246: a38 := JTF_VARCHAR2_TABLE_100();

242: a34 := JTF_NUMBER_TABLE();
243: a35 := JTF_NUMBER_TABLE();
244: a36 := JTF_NUMBER_TABLE();
245: a37 := JTF_NUMBER_TABLE();
246: a38 := JTF_VARCHAR2_TABLE_100();
247: a39 := JTF_NUMBER_TABLE();
248: a40 := JTF_VARCHAR2_TABLE_100();
249: a41 := JTF_VARCHAR2_TABLE_200();
250: a42 := JTF_VARCHAR2_TABLE_200();

Line 248: a40 := JTF_VARCHAR2_TABLE_100();

244: a36 := JTF_NUMBER_TABLE();
245: a37 := JTF_NUMBER_TABLE();
246: a38 := JTF_VARCHAR2_TABLE_100();
247: a39 := JTF_NUMBER_TABLE();
248: a40 := JTF_VARCHAR2_TABLE_100();
249: a41 := JTF_VARCHAR2_TABLE_200();
250: a42 := JTF_VARCHAR2_TABLE_200();
251: a43 := JTF_VARCHAR2_TABLE_200();
252: a44 := JTF_VARCHAR2_TABLE_200();

Line 264: a56 := JTF_VARCHAR2_TABLE_100();

260: a52 := JTF_VARCHAR2_TABLE_200();
261: a53 := JTF_VARCHAR2_TABLE_200();
262: a54 := JTF_VARCHAR2_TABLE_200();
263: a55 := JTF_VARCHAR2_TABLE_200();
264: a56 := JTF_VARCHAR2_TABLE_100();
265: else
266: a0 := JTF_NUMBER_TABLE();
267: a1 := JTF_NUMBER_TABLE();
268: a2 := JTF_NUMBER_TABLE();

Line 281: a15 := JTF_VARCHAR2_TABLE_100();

277: a11 := JTF_NUMBER_TABLE();
278: a12 := JTF_NUMBER_TABLE();
279: a13 := JTF_NUMBER_TABLE();
280: a14 := JTF_VARCHAR2_TABLE_300();
281: a15 := JTF_VARCHAR2_TABLE_100();
282: a16 := JTF_VARCHAR2_TABLE_100();
283: a17 := JTF_NUMBER_TABLE();
284: a18 := JTF_VARCHAR2_TABLE_500();
285: a19 := JTF_VARCHAR2_TABLE_100();

Line 282: a16 := JTF_VARCHAR2_TABLE_100();

278: a12 := JTF_NUMBER_TABLE();
279: a13 := JTF_NUMBER_TABLE();
280: a14 := JTF_VARCHAR2_TABLE_300();
281: a15 := JTF_VARCHAR2_TABLE_100();
282: a16 := JTF_VARCHAR2_TABLE_100();
283: a17 := JTF_NUMBER_TABLE();
284: a18 := JTF_VARCHAR2_TABLE_500();
285: a19 := JTF_VARCHAR2_TABLE_100();
286: a20 := JTF_VARCHAR2_TABLE_100();

Line 285: a19 := JTF_VARCHAR2_TABLE_100();

281: a15 := JTF_VARCHAR2_TABLE_100();
282: a16 := JTF_VARCHAR2_TABLE_100();
283: a17 := JTF_NUMBER_TABLE();
284: a18 := JTF_VARCHAR2_TABLE_500();
285: a19 := JTF_VARCHAR2_TABLE_100();
286: a20 := JTF_VARCHAR2_TABLE_100();
287: a21 := JTF_VARCHAR2_TABLE_100();
288: a22 := JTF_NUMBER_TABLE();
289: a23 := JTF_NUMBER_TABLE();

Line 286: a20 := JTF_VARCHAR2_TABLE_100();

282: a16 := JTF_VARCHAR2_TABLE_100();
283: a17 := JTF_NUMBER_TABLE();
284: a18 := JTF_VARCHAR2_TABLE_500();
285: a19 := JTF_VARCHAR2_TABLE_100();
286: a20 := JTF_VARCHAR2_TABLE_100();
287: a21 := JTF_VARCHAR2_TABLE_100();
288: a22 := JTF_NUMBER_TABLE();
289: a23 := JTF_NUMBER_TABLE();
290: a24 := JTF_DATE_TABLE();

Line 287: a21 := JTF_VARCHAR2_TABLE_100();

283: a17 := JTF_NUMBER_TABLE();
284: a18 := JTF_VARCHAR2_TABLE_500();
285: a19 := JTF_VARCHAR2_TABLE_100();
286: a20 := JTF_VARCHAR2_TABLE_100();
287: a21 := JTF_VARCHAR2_TABLE_100();
288: a22 := JTF_NUMBER_TABLE();
289: a23 := JTF_NUMBER_TABLE();
290: a24 := JTF_DATE_TABLE();
291: a25 := JTF_NUMBER_TABLE();

Line 304: a38 := JTF_VARCHAR2_TABLE_100();

300: a34 := JTF_NUMBER_TABLE();
301: a35 := JTF_NUMBER_TABLE();
302: a36 := JTF_NUMBER_TABLE();
303: a37 := JTF_NUMBER_TABLE();
304: a38 := JTF_VARCHAR2_TABLE_100();
305: a39 := JTF_NUMBER_TABLE();
306: a40 := JTF_VARCHAR2_TABLE_100();
307: a41 := JTF_VARCHAR2_TABLE_200();
308: a42 := JTF_VARCHAR2_TABLE_200();

Line 306: a40 := JTF_VARCHAR2_TABLE_100();

302: a36 := JTF_NUMBER_TABLE();
303: a37 := JTF_NUMBER_TABLE();
304: a38 := JTF_VARCHAR2_TABLE_100();
305: a39 := JTF_NUMBER_TABLE();
306: a40 := JTF_VARCHAR2_TABLE_100();
307: a41 := JTF_VARCHAR2_TABLE_200();
308: a42 := JTF_VARCHAR2_TABLE_200();
309: a43 := JTF_VARCHAR2_TABLE_200();
310: a44 := JTF_VARCHAR2_TABLE_200();

Line 322: a56 := JTF_VARCHAR2_TABLE_100();

318: a52 := JTF_VARCHAR2_TABLE_200();
319: a53 := JTF_VARCHAR2_TABLE_200();
320: a54 := JTF_VARCHAR2_TABLE_200();
321: a55 := JTF_VARCHAR2_TABLE_200();
322: a56 := JTF_VARCHAR2_TABLE_100();
323: if t.count > 0 then
324: a0.extend(t.count);
325: a1.extend(t.count);
326: a2.extend(t.count);

Line 456: , a5 JTF_VARCHAR2_TABLE_100

452: , a1 JTF_NUMBER_TABLE
453: , a2 JTF_NUMBER_TABLE
454: , a3 JTF_NUMBER_TABLE
455: , a4 JTF_NUMBER_TABLE
456: , a5 JTF_VARCHAR2_TABLE_100
457: , a6 JTF_VARCHAR2_TABLE_300
458: , a7 JTF_NUMBER_TABLE
459: , a8 JTF_VARCHAR2_TABLE_300
460: , a9 JTF_VARCHAR2_TABLE_100

Line 460: , a9 JTF_VARCHAR2_TABLE_100

456: , a5 JTF_VARCHAR2_TABLE_100
457: , a6 JTF_VARCHAR2_TABLE_300
458: , a7 JTF_NUMBER_TABLE
459: , a8 JTF_VARCHAR2_TABLE_300
460: , a9 JTF_VARCHAR2_TABLE_100
461: , a10 JTF_VARCHAR2_TABLE_300
462: , a11 JTF_NUMBER_TABLE
463: , a12 JTF_VARCHAR2_TABLE_100
464: , a13 JTF_VARCHAR2_TABLE_100

Line 463: , a12 JTF_VARCHAR2_TABLE_100

459: , a8 JTF_VARCHAR2_TABLE_300
460: , a9 JTF_VARCHAR2_TABLE_100
461: , a10 JTF_VARCHAR2_TABLE_300
462: , a11 JTF_NUMBER_TABLE
463: , a12 JTF_VARCHAR2_TABLE_100
464: , a13 JTF_VARCHAR2_TABLE_100
465: , a14 JTF_VARCHAR2_TABLE_100
466: , a15 JTF_DATE_TABLE
467: , a16 JTF_NUMBER_TABLE

Line 464: , a13 JTF_VARCHAR2_TABLE_100

460: , a9 JTF_VARCHAR2_TABLE_100
461: , a10 JTF_VARCHAR2_TABLE_300
462: , a11 JTF_NUMBER_TABLE
463: , a12 JTF_VARCHAR2_TABLE_100
464: , a13 JTF_VARCHAR2_TABLE_100
465: , a14 JTF_VARCHAR2_TABLE_100
466: , a15 JTF_DATE_TABLE
467: , a16 JTF_NUMBER_TABLE
468: , a17 JTF_NUMBER_TABLE

Line 465: , a14 JTF_VARCHAR2_TABLE_100

461: , a10 JTF_VARCHAR2_TABLE_300
462: , a11 JTF_NUMBER_TABLE
463: , a12 JTF_VARCHAR2_TABLE_100
464: , a13 JTF_VARCHAR2_TABLE_100
465: , a14 JTF_VARCHAR2_TABLE_100
466: , a15 JTF_DATE_TABLE
467: , a16 JTF_NUMBER_TABLE
468: , a17 JTF_NUMBER_TABLE
469: , a18 JTF_DATE_TABLE

Line 480: , a29 JTF_VARCHAR2_TABLE_100

476: , a25 JTF_NUMBER_TABLE
477: , a26 JTF_NUMBER_TABLE
478: , a27 JTF_NUMBER_TABLE
479: , a28 JTF_NUMBER_TABLE
480: , a29 JTF_VARCHAR2_TABLE_100
481: , a30 JTF_VARCHAR2_TABLE_100
482: , a31 JTF_VARCHAR2_TABLE_100
483: , a32 JTF_VARCHAR2_TABLE_300
484: , a33 JTF_VARCHAR2_TABLE_100

Line 481: , a30 JTF_VARCHAR2_TABLE_100

477: , a26 JTF_NUMBER_TABLE
478: , a27 JTF_NUMBER_TABLE
479: , a28 JTF_NUMBER_TABLE
480: , a29 JTF_VARCHAR2_TABLE_100
481: , a30 JTF_VARCHAR2_TABLE_100
482: , a31 JTF_VARCHAR2_TABLE_100
483: , a32 JTF_VARCHAR2_TABLE_300
484: , a33 JTF_VARCHAR2_TABLE_100
485: , a34 JTF_VARCHAR2_TABLE_100

Line 482: , a31 JTF_VARCHAR2_TABLE_100

478: , a27 JTF_NUMBER_TABLE
479: , a28 JTF_NUMBER_TABLE
480: , a29 JTF_VARCHAR2_TABLE_100
481: , a30 JTF_VARCHAR2_TABLE_100
482: , a31 JTF_VARCHAR2_TABLE_100
483: , a32 JTF_VARCHAR2_TABLE_300
484: , a33 JTF_VARCHAR2_TABLE_100
485: , a34 JTF_VARCHAR2_TABLE_100
486: , a35 JTF_VARCHAR2_TABLE_100

Line 484: , a33 JTF_VARCHAR2_TABLE_100

480: , a29 JTF_VARCHAR2_TABLE_100
481: , a30 JTF_VARCHAR2_TABLE_100
482: , a31 JTF_VARCHAR2_TABLE_100
483: , a32 JTF_VARCHAR2_TABLE_300
484: , a33 JTF_VARCHAR2_TABLE_100
485: , a34 JTF_VARCHAR2_TABLE_100
486: , a35 JTF_VARCHAR2_TABLE_100
487: , a36 JTF_NUMBER_TABLE
488: , a37 JTF_VARCHAR2_TABLE_300

Line 485: , a34 JTF_VARCHAR2_TABLE_100

481: , a30 JTF_VARCHAR2_TABLE_100
482: , a31 JTF_VARCHAR2_TABLE_100
483: , a32 JTF_VARCHAR2_TABLE_300
484: , a33 JTF_VARCHAR2_TABLE_100
485: , a34 JTF_VARCHAR2_TABLE_100
486: , a35 JTF_VARCHAR2_TABLE_100
487: , a36 JTF_NUMBER_TABLE
488: , a37 JTF_VARCHAR2_TABLE_300
489: , a38 JTF_NUMBER_TABLE

Line 486: , a35 JTF_VARCHAR2_TABLE_100

482: , a31 JTF_VARCHAR2_TABLE_100
483: , a32 JTF_VARCHAR2_TABLE_300
484: , a33 JTF_VARCHAR2_TABLE_100
485: , a34 JTF_VARCHAR2_TABLE_100
486: , a35 JTF_VARCHAR2_TABLE_100
487: , a36 JTF_NUMBER_TABLE
488: , a37 JTF_VARCHAR2_TABLE_300
489: , a38 JTF_NUMBER_TABLE
490: , a39 JTF_VARCHAR2_TABLE_100

Line 490: , a39 JTF_VARCHAR2_TABLE_100

486: , a35 JTF_VARCHAR2_TABLE_100
487: , a36 JTF_NUMBER_TABLE
488: , a37 JTF_VARCHAR2_TABLE_300
489: , a38 JTF_NUMBER_TABLE
490: , a39 JTF_VARCHAR2_TABLE_100
491: , a40 JTF_NUMBER_TABLE
492: , a41 JTF_VARCHAR2_TABLE_100
493: , a42 JTF_NUMBER_TABLE
494: , a43 JTF_NUMBER_TABLE

Line 492: , a41 JTF_VARCHAR2_TABLE_100

488: , a37 JTF_VARCHAR2_TABLE_300
489: , a38 JTF_NUMBER_TABLE
490: , a39 JTF_VARCHAR2_TABLE_100
491: , a40 JTF_NUMBER_TABLE
492: , a41 JTF_VARCHAR2_TABLE_100
493: , a42 JTF_NUMBER_TABLE
494: , a43 JTF_NUMBER_TABLE
495: , a44 JTF_VARCHAR2_TABLE_100
496: , a45 JTF_NUMBER_TABLE

Line 495: , a44 JTF_VARCHAR2_TABLE_100

491: , a40 JTF_NUMBER_TABLE
492: , a41 JTF_VARCHAR2_TABLE_100
493: , a42 JTF_NUMBER_TABLE
494: , a43 JTF_NUMBER_TABLE
495: , a44 JTF_VARCHAR2_TABLE_100
496: , a45 JTF_NUMBER_TABLE
497: , a46 JTF_NUMBER_TABLE
498: , a47 JTF_NUMBER_TABLE
499: , a48 JTF_VARCHAR2_TABLE_100

Line 499: , a48 JTF_VARCHAR2_TABLE_100

495: , a44 JTF_VARCHAR2_TABLE_100
496: , a45 JTF_NUMBER_TABLE
497: , a46 JTF_NUMBER_TABLE
498: , a47 JTF_NUMBER_TABLE
499: , a48 JTF_VARCHAR2_TABLE_100
500: , a49 JTF_NUMBER_TABLE
501: , a50 JTF_NUMBER_TABLE
502: , a51 JTF_VARCHAR2_TABLE_100
503: , a52 JTF_VARCHAR2_TABLE_100

Line 502: , a51 JTF_VARCHAR2_TABLE_100

498: , a47 JTF_NUMBER_TABLE
499: , a48 JTF_VARCHAR2_TABLE_100
500: , a49 JTF_NUMBER_TABLE
501: , a50 JTF_NUMBER_TABLE
502: , a51 JTF_VARCHAR2_TABLE_100
503: , a52 JTF_VARCHAR2_TABLE_100
504: , a53 JTF_NUMBER_TABLE
505: , a54 JTF_NUMBER_TABLE
506: , a55 JTF_VARCHAR2_TABLE_300

Line 503: , a52 JTF_VARCHAR2_TABLE_100

499: , a48 JTF_VARCHAR2_TABLE_100
500: , a49 JTF_NUMBER_TABLE
501: , a50 JTF_NUMBER_TABLE
502: , a51 JTF_VARCHAR2_TABLE_100
503: , a52 JTF_VARCHAR2_TABLE_100
504: , a53 JTF_NUMBER_TABLE
505: , a54 JTF_NUMBER_TABLE
506: , a55 JTF_VARCHAR2_TABLE_300
507: , a56 JTF_VARCHAR2_TABLE_100

Line 507: , a56 JTF_VARCHAR2_TABLE_100

503: , a52 JTF_VARCHAR2_TABLE_100
504: , a53 JTF_NUMBER_TABLE
505: , a54 JTF_NUMBER_TABLE
506: , a55 JTF_VARCHAR2_TABLE_300
507: , a56 JTF_VARCHAR2_TABLE_100
508: , a57 JTF_VARCHAR2_TABLE_100
509: , a58 JTF_NUMBER_TABLE
510: , a59 JTF_NUMBER_TABLE
511: , a60 JTF_NUMBER_TABLE

Line 508: , a57 JTF_VARCHAR2_TABLE_100

504: , a53 JTF_NUMBER_TABLE
505: , a54 JTF_NUMBER_TABLE
506: , a55 JTF_VARCHAR2_TABLE_300
507: , a56 JTF_VARCHAR2_TABLE_100
508: , a57 JTF_VARCHAR2_TABLE_100
509: , a58 JTF_NUMBER_TABLE
510: , a59 JTF_NUMBER_TABLE
511: , a60 JTF_NUMBER_TABLE
512: , a61 JTF_NUMBER_TABLE

Line 517: , a66 JTF_VARCHAR2_TABLE_100

513: , a62 JTF_NUMBER_TABLE
514: , a63 JTF_NUMBER_TABLE
515: , a64 JTF_NUMBER_TABLE
516: , a65 JTF_NUMBER_TABLE
517: , a66 JTF_VARCHAR2_TABLE_100
518: , a67 JTF_VARCHAR2_TABLE_100
519: , a68 JTF_NUMBER_TABLE
520: , a69 JTF_VARCHAR2_TABLE_100
521: , a70 JTF_NUMBER_TABLE

Line 518: , a67 JTF_VARCHAR2_TABLE_100

514: , a63 JTF_NUMBER_TABLE
515: , a64 JTF_NUMBER_TABLE
516: , a65 JTF_NUMBER_TABLE
517: , a66 JTF_VARCHAR2_TABLE_100
518: , a67 JTF_VARCHAR2_TABLE_100
519: , a68 JTF_NUMBER_TABLE
520: , a69 JTF_VARCHAR2_TABLE_100
521: , a70 JTF_NUMBER_TABLE
522: , a71 JTF_NUMBER_TABLE

Line 520: , a69 JTF_VARCHAR2_TABLE_100

516: , a65 JTF_NUMBER_TABLE
517: , a66 JTF_VARCHAR2_TABLE_100
518: , a67 JTF_VARCHAR2_TABLE_100
519: , a68 JTF_NUMBER_TABLE
520: , a69 JTF_VARCHAR2_TABLE_100
521: , a70 JTF_NUMBER_TABLE
522: , a71 JTF_NUMBER_TABLE
523: , a72 JTF_NUMBER_TABLE
524: , a73 JTF_NUMBER_TABLE

Line 525: , a74 JTF_VARCHAR2_TABLE_100

521: , a70 JTF_NUMBER_TABLE
522: , a71 JTF_NUMBER_TABLE
523: , a72 JTF_NUMBER_TABLE
524: , a73 JTF_NUMBER_TABLE
525: , a74 JTF_VARCHAR2_TABLE_100
526: , a75 JTF_NUMBER_TABLE
527: , a76 JTF_NUMBER_TABLE
528: , a77 JTF_VARCHAR2_TABLE_100
529: , a78 JTF_VARCHAR2_TABLE_200

Line 528: , a77 JTF_VARCHAR2_TABLE_100

524: , a73 JTF_NUMBER_TABLE
525: , a74 JTF_VARCHAR2_TABLE_100
526: , a75 JTF_NUMBER_TABLE
527: , a76 JTF_NUMBER_TABLE
528: , a77 JTF_VARCHAR2_TABLE_100
529: , a78 JTF_VARCHAR2_TABLE_200
530: , a79 JTF_VARCHAR2_TABLE_200
531: , a80 JTF_VARCHAR2_TABLE_200
532: , a81 JTF_VARCHAR2_TABLE_200

Line 549: , a98 JTF_VARCHAR2_TABLE_100

545: , a94 JTF_NUMBER_TABLE
546: , a95 JTF_DATE_TABLE
547: , a96 JTF_NUMBER_TABLE
548: , a97 JTF_NUMBER_TABLE
549: , a98 JTF_VARCHAR2_TABLE_100
550: , a99 JTF_VARCHAR2_TABLE_100
551: , a100 JTF_VARCHAR2_TABLE_100
552: , a101 JTF_NUMBER_TABLE
553: , a102 JTF_VARCHAR2_TABLE_100

Line 550: , a99 JTF_VARCHAR2_TABLE_100

546: , a95 JTF_DATE_TABLE
547: , a96 JTF_NUMBER_TABLE
548: , a97 JTF_NUMBER_TABLE
549: , a98 JTF_VARCHAR2_TABLE_100
550: , a99 JTF_VARCHAR2_TABLE_100
551: , a100 JTF_VARCHAR2_TABLE_100
552: , a101 JTF_NUMBER_TABLE
553: , a102 JTF_VARCHAR2_TABLE_100
554: , a103 JTF_VARCHAR2_TABLE_100

Line 551: , a100 JTF_VARCHAR2_TABLE_100

547: , a96 JTF_NUMBER_TABLE
548: , a97 JTF_NUMBER_TABLE
549: , a98 JTF_VARCHAR2_TABLE_100
550: , a99 JTF_VARCHAR2_TABLE_100
551: , a100 JTF_VARCHAR2_TABLE_100
552: , a101 JTF_NUMBER_TABLE
553: , a102 JTF_VARCHAR2_TABLE_100
554: , a103 JTF_VARCHAR2_TABLE_100
555: , a104 JTF_VARCHAR2_TABLE_100

Line 553: , a102 JTF_VARCHAR2_TABLE_100

549: , a98 JTF_VARCHAR2_TABLE_100
550: , a99 JTF_VARCHAR2_TABLE_100
551: , a100 JTF_VARCHAR2_TABLE_100
552: , a101 JTF_NUMBER_TABLE
553: , a102 JTF_VARCHAR2_TABLE_100
554: , a103 JTF_VARCHAR2_TABLE_100
555: , a104 JTF_VARCHAR2_TABLE_100
556: ) as
557: ddindx binary_integer; indx binary_integer;

Line 554: , a103 JTF_VARCHAR2_TABLE_100

550: , a99 JTF_VARCHAR2_TABLE_100
551: , a100 JTF_VARCHAR2_TABLE_100
552: , a101 JTF_NUMBER_TABLE
553: , a102 JTF_VARCHAR2_TABLE_100
554: , a103 JTF_VARCHAR2_TABLE_100
555: , a104 JTF_VARCHAR2_TABLE_100
556: ) as
557: ddindx binary_integer; indx binary_integer;
558: begin

Line 555: , a104 JTF_VARCHAR2_TABLE_100

551: , a100 JTF_VARCHAR2_TABLE_100
552: , a101 JTF_NUMBER_TABLE
553: , a102 JTF_VARCHAR2_TABLE_100
554: , a103 JTF_VARCHAR2_TABLE_100
555: , a104 JTF_VARCHAR2_TABLE_100
556: ) as
557: ddindx binary_integer; indx binary_integer;
558: begin
559: if a0 is not null and a0.count > 0 then

Line 683: , a5 out nocopy JTF_VARCHAR2_TABLE_100

679: , a1 out nocopy JTF_NUMBER_TABLE
680: , a2 out nocopy JTF_NUMBER_TABLE
681: , a3 out nocopy JTF_NUMBER_TABLE
682: , a4 out nocopy JTF_NUMBER_TABLE
683: , a5 out nocopy JTF_VARCHAR2_TABLE_100
684: , a6 out nocopy JTF_VARCHAR2_TABLE_300
685: , a7 out nocopy JTF_NUMBER_TABLE
686: , a8 out nocopy JTF_VARCHAR2_TABLE_300
687: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 687: , a9 out nocopy JTF_VARCHAR2_TABLE_100

683: , a5 out nocopy JTF_VARCHAR2_TABLE_100
684: , a6 out nocopy JTF_VARCHAR2_TABLE_300
685: , a7 out nocopy JTF_NUMBER_TABLE
686: , a8 out nocopy JTF_VARCHAR2_TABLE_300
687: , a9 out nocopy JTF_VARCHAR2_TABLE_100
688: , a10 out nocopy JTF_VARCHAR2_TABLE_300
689: , a11 out nocopy JTF_NUMBER_TABLE
690: , a12 out nocopy JTF_VARCHAR2_TABLE_100
691: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 690: , a12 out nocopy JTF_VARCHAR2_TABLE_100

686: , a8 out nocopy JTF_VARCHAR2_TABLE_300
687: , a9 out nocopy JTF_VARCHAR2_TABLE_100
688: , a10 out nocopy JTF_VARCHAR2_TABLE_300
689: , a11 out nocopy JTF_NUMBER_TABLE
690: , a12 out nocopy JTF_VARCHAR2_TABLE_100
691: , a13 out nocopy JTF_VARCHAR2_TABLE_100
692: , a14 out nocopy JTF_VARCHAR2_TABLE_100
693: , a15 out nocopy JTF_DATE_TABLE
694: , a16 out nocopy JTF_NUMBER_TABLE

Line 691: , a13 out nocopy JTF_VARCHAR2_TABLE_100

687: , a9 out nocopy JTF_VARCHAR2_TABLE_100
688: , a10 out nocopy JTF_VARCHAR2_TABLE_300
689: , a11 out nocopy JTF_NUMBER_TABLE
690: , a12 out nocopy JTF_VARCHAR2_TABLE_100
691: , a13 out nocopy JTF_VARCHAR2_TABLE_100
692: , a14 out nocopy JTF_VARCHAR2_TABLE_100
693: , a15 out nocopy JTF_DATE_TABLE
694: , a16 out nocopy JTF_NUMBER_TABLE
695: , a17 out nocopy JTF_NUMBER_TABLE

Line 692: , a14 out nocopy JTF_VARCHAR2_TABLE_100

688: , a10 out nocopy JTF_VARCHAR2_TABLE_300
689: , a11 out nocopy JTF_NUMBER_TABLE
690: , a12 out nocopy JTF_VARCHAR2_TABLE_100
691: , a13 out nocopy JTF_VARCHAR2_TABLE_100
692: , a14 out nocopy JTF_VARCHAR2_TABLE_100
693: , a15 out nocopy JTF_DATE_TABLE
694: , a16 out nocopy JTF_NUMBER_TABLE
695: , a17 out nocopy JTF_NUMBER_TABLE
696: , a18 out nocopy JTF_DATE_TABLE

Line 707: , a29 out nocopy JTF_VARCHAR2_TABLE_100

703: , a25 out nocopy JTF_NUMBER_TABLE
704: , a26 out nocopy JTF_NUMBER_TABLE
705: , a27 out nocopy JTF_NUMBER_TABLE
706: , a28 out nocopy JTF_NUMBER_TABLE
707: , a29 out nocopy JTF_VARCHAR2_TABLE_100
708: , a30 out nocopy JTF_VARCHAR2_TABLE_100
709: , a31 out nocopy JTF_VARCHAR2_TABLE_100
710: , a32 out nocopy JTF_VARCHAR2_TABLE_300
711: , a33 out nocopy JTF_VARCHAR2_TABLE_100

Line 708: , a30 out nocopy JTF_VARCHAR2_TABLE_100

704: , a26 out nocopy JTF_NUMBER_TABLE
705: , a27 out nocopy JTF_NUMBER_TABLE
706: , a28 out nocopy JTF_NUMBER_TABLE
707: , a29 out nocopy JTF_VARCHAR2_TABLE_100
708: , a30 out nocopy JTF_VARCHAR2_TABLE_100
709: , a31 out nocopy JTF_VARCHAR2_TABLE_100
710: , a32 out nocopy JTF_VARCHAR2_TABLE_300
711: , a33 out nocopy JTF_VARCHAR2_TABLE_100
712: , a34 out nocopy JTF_VARCHAR2_TABLE_100

Line 709: , a31 out nocopy JTF_VARCHAR2_TABLE_100

705: , a27 out nocopy JTF_NUMBER_TABLE
706: , a28 out nocopy JTF_NUMBER_TABLE
707: , a29 out nocopy JTF_VARCHAR2_TABLE_100
708: , a30 out nocopy JTF_VARCHAR2_TABLE_100
709: , a31 out nocopy JTF_VARCHAR2_TABLE_100
710: , a32 out nocopy JTF_VARCHAR2_TABLE_300
711: , a33 out nocopy JTF_VARCHAR2_TABLE_100
712: , a34 out nocopy JTF_VARCHAR2_TABLE_100
713: , a35 out nocopy JTF_VARCHAR2_TABLE_100

Line 711: , a33 out nocopy JTF_VARCHAR2_TABLE_100

707: , a29 out nocopy JTF_VARCHAR2_TABLE_100
708: , a30 out nocopy JTF_VARCHAR2_TABLE_100
709: , a31 out nocopy JTF_VARCHAR2_TABLE_100
710: , a32 out nocopy JTF_VARCHAR2_TABLE_300
711: , a33 out nocopy JTF_VARCHAR2_TABLE_100
712: , a34 out nocopy JTF_VARCHAR2_TABLE_100
713: , a35 out nocopy JTF_VARCHAR2_TABLE_100
714: , a36 out nocopy JTF_NUMBER_TABLE
715: , a37 out nocopy JTF_VARCHAR2_TABLE_300

Line 712: , a34 out nocopy JTF_VARCHAR2_TABLE_100

708: , a30 out nocopy JTF_VARCHAR2_TABLE_100
709: , a31 out nocopy JTF_VARCHAR2_TABLE_100
710: , a32 out nocopy JTF_VARCHAR2_TABLE_300
711: , a33 out nocopy JTF_VARCHAR2_TABLE_100
712: , a34 out nocopy JTF_VARCHAR2_TABLE_100
713: , a35 out nocopy JTF_VARCHAR2_TABLE_100
714: , a36 out nocopy JTF_NUMBER_TABLE
715: , a37 out nocopy JTF_VARCHAR2_TABLE_300
716: , a38 out nocopy JTF_NUMBER_TABLE

Line 713: , a35 out nocopy JTF_VARCHAR2_TABLE_100

709: , a31 out nocopy JTF_VARCHAR2_TABLE_100
710: , a32 out nocopy JTF_VARCHAR2_TABLE_300
711: , a33 out nocopy JTF_VARCHAR2_TABLE_100
712: , a34 out nocopy JTF_VARCHAR2_TABLE_100
713: , a35 out nocopy JTF_VARCHAR2_TABLE_100
714: , a36 out nocopy JTF_NUMBER_TABLE
715: , a37 out nocopy JTF_VARCHAR2_TABLE_300
716: , a38 out nocopy JTF_NUMBER_TABLE
717: , a39 out nocopy JTF_VARCHAR2_TABLE_100

Line 717: , a39 out nocopy JTF_VARCHAR2_TABLE_100

713: , a35 out nocopy JTF_VARCHAR2_TABLE_100
714: , a36 out nocopy JTF_NUMBER_TABLE
715: , a37 out nocopy JTF_VARCHAR2_TABLE_300
716: , a38 out nocopy JTF_NUMBER_TABLE
717: , a39 out nocopy JTF_VARCHAR2_TABLE_100
718: , a40 out nocopy JTF_NUMBER_TABLE
719: , a41 out nocopy JTF_VARCHAR2_TABLE_100
720: , a42 out nocopy JTF_NUMBER_TABLE
721: , a43 out nocopy JTF_NUMBER_TABLE

Line 719: , a41 out nocopy JTF_VARCHAR2_TABLE_100

715: , a37 out nocopy JTF_VARCHAR2_TABLE_300
716: , a38 out nocopy JTF_NUMBER_TABLE
717: , a39 out nocopy JTF_VARCHAR2_TABLE_100
718: , a40 out nocopy JTF_NUMBER_TABLE
719: , a41 out nocopy JTF_VARCHAR2_TABLE_100
720: , a42 out nocopy JTF_NUMBER_TABLE
721: , a43 out nocopy JTF_NUMBER_TABLE
722: , a44 out nocopy JTF_VARCHAR2_TABLE_100
723: , a45 out nocopy JTF_NUMBER_TABLE

Line 722: , a44 out nocopy JTF_VARCHAR2_TABLE_100

718: , a40 out nocopy JTF_NUMBER_TABLE
719: , a41 out nocopy JTF_VARCHAR2_TABLE_100
720: , a42 out nocopy JTF_NUMBER_TABLE
721: , a43 out nocopy JTF_NUMBER_TABLE
722: , a44 out nocopy JTF_VARCHAR2_TABLE_100
723: , a45 out nocopy JTF_NUMBER_TABLE
724: , a46 out nocopy JTF_NUMBER_TABLE
725: , a47 out nocopy JTF_NUMBER_TABLE
726: , a48 out nocopy JTF_VARCHAR2_TABLE_100

Line 726: , a48 out nocopy JTF_VARCHAR2_TABLE_100

722: , a44 out nocopy JTF_VARCHAR2_TABLE_100
723: , a45 out nocopy JTF_NUMBER_TABLE
724: , a46 out nocopy JTF_NUMBER_TABLE
725: , a47 out nocopy JTF_NUMBER_TABLE
726: , a48 out nocopy JTF_VARCHAR2_TABLE_100
727: , a49 out nocopy JTF_NUMBER_TABLE
728: , a50 out nocopy JTF_NUMBER_TABLE
729: , a51 out nocopy JTF_VARCHAR2_TABLE_100
730: , a52 out nocopy JTF_VARCHAR2_TABLE_100

Line 729: , a51 out nocopy JTF_VARCHAR2_TABLE_100

725: , a47 out nocopy JTF_NUMBER_TABLE
726: , a48 out nocopy JTF_VARCHAR2_TABLE_100
727: , a49 out nocopy JTF_NUMBER_TABLE
728: , a50 out nocopy JTF_NUMBER_TABLE
729: , a51 out nocopy JTF_VARCHAR2_TABLE_100
730: , a52 out nocopy JTF_VARCHAR2_TABLE_100
731: , a53 out nocopy JTF_NUMBER_TABLE
732: , a54 out nocopy JTF_NUMBER_TABLE
733: , a55 out nocopy JTF_VARCHAR2_TABLE_300

Line 730: , a52 out nocopy JTF_VARCHAR2_TABLE_100

726: , a48 out nocopy JTF_VARCHAR2_TABLE_100
727: , a49 out nocopy JTF_NUMBER_TABLE
728: , a50 out nocopy JTF_NUMBER_TABLE
729: , a51 out nocopy JTF_VARCHAR2_TABLE_100
730: , a52 out nocopy JTF_VARCHAR2_TABLE_100
731: , a53 out nocopy JTF_NUMBER_TABLE
732: , a54 out nocopy JTF_NUMBER_TABLE
733: , a55 out nocopy JTF_VARCHAR2_TABLE_300
734: , a56 out nocopy JTF_VARCHAR2_TABLE_100

Line 734: , a56 out nocopy JTF_VARCHAR2_TABLE_100

730: , a52 out nocopy JTF_VARCHAR2_TABLE_100
731: , a53 out nocopy JTF_NUMBER_TABLE
732: , a54 out nocopy JTF_NUMBER_TABLE
733: , a55 out nocopy JTF_VARCHAR2_TABLE_300
734: , a56 out nocopy JTF_VARCHAR2_TABLE_100
735: , a57 out nocopy JTF_VARCHAR2_TABLE_100
736: , a58 out nocopy JTF_NUMBER_TABLE
737: , a59 out nocopy JTF_NUMBER_TABLE
738: , a60 out nocopy JTF_NUMBER_TABLE

Line 735: , a57 out nocopy JTF_VARCHAR2_TABLE_100

731: , a53 out nocopy JTF_NUMBER_TABLE
732: , a54 out nocopy JTF_NUMBER_TABLE
733: , a55 out nocopy JTF_VARCHAR2_TABLE_300
734: , a56 out nocopy JTF_VARCHAR2_TABLE_100
735: , a57 out nocopy JTF_VARCHAR2_TABLE_100
736: , a58 out nocopy JTF_NUMBER_TABLE
737: , a59 out nocopy JTF_NUMBER_TABLE
738: , a60 out nocopy JTF_NUMBER_TABLE
739: , a61 out nocopy JTF_NUMBER_TABLE

Line 744: , a66 out nocopy JTF_VARCHAR2_TABLE_100

740: , a62 out nocopy JTF_NUMBER_TABLE
741: , a63 out nocopy JTF_NUMBER_TABLE
742: , a64 out nocopy JTF_NUMBER_TABLE
743: , a65 out nocopy JTF_NUMBER_TABLE
744: , a66 out nocopy JTF_VARCHAR2_TABLE_100
745: , a67 out nocopy JTF_VARCHAR2_TABLE_100
746: , a68 out nocopy JTF_NUMBER_TABLE
747: , a69 out nocopy JTF_VARCHAR2_TABLE_100
748: , a70 out nocopy JTF_NUMBER_TABLE

Line 745: , a67 out nocopy JTF_VARCHAR2_TABLE_100

741: , a63 out nocopy JTF_NUMBER_TABLE
742: , a64 out nocopy JTF_NUMBER_TABLE
743: , a65 out nocopy JTF_NUMBER_TABLE
744: , a66 out nocopy JTF_VARCHAR2_TABLE_100
745: , a67 out nocopy JTF_VARCHAR2_TABLE_100
746: , a68 out nocopy JTF_NUMBER_TABLE
747: , a69 out nocopy JTF_VARCHAR2_TABLE_100
748: , a70 out nocopy JTF_NUMBER_TABLE
749: , a71 out nocopy JTF_NUMBER_TABLE

Line 747: , a69 out nocopy JTF_VARCHAR2_TABLE_100

743: , a65 out nocopy JTF_NUMBER_TABLE
744: , a66 out nocopy JTF_VARCHAR2_TABLE_100
745: , a67 out nocopy JTF_VARCHAR2_TABLE_100
746: , a68 out nocopy JTF_NUMBER_TABLE
747: , a69 out nocopy JTF_VARCHAR2_TABLE_100
748: , a70 out nocopy JTF_NUMBER_TABLE
749: , a71 out nocopy JTF_NUMBER_TABLE
750: , a72 out nocopy JTF_NUMBER_TABLE
751: , a73 out nocopy JTF_NUMBER_TABLE

Line 752: , a74 out nocopy JTF_VARCHAR2_TABLE_100

748: , a70 out nocopy JTF_NUMBER_TABLE
749: , a71 out nocopy JTF_NUMBER_TABLE
750: , a72 out nocopy JTF_NUMBER_TABLE
751: , a73 out nocopy JTF_NUMBER_TABLE
752: , a74 out nocopy JTF_VARCHAR2_TABLE_100
753: , a75 out nocopy JTF_NUMBER_TABLE
754: , a76 out nocopy JTF_NUMBER_TABLE
755: , a77 out nocopy JTF_VARCHAR2_TABLE_100
756: , a78 out nocopy JTF_VARCHAR2_TABLE_200

Line 755: , a77 out nocopy JTF_VARCHAR2_TABLE_100

751: , a73 out nocopy JTF_NUMBER_TABLE
752: , a74 out nocopy JTF_VARCHAR2_TABLE_100
753: , a75 out nocopy JTF_NUMBER_TABLE
754: , a76 out nocopy JTF_NUMBER_TABLE
755: , a77 out nocopy JTF_VARCHAR2_TABLE_100
756: , a78 out nocopy JTF_VARCHAR2_TABLE_200
757: , a79 out nocopy JTF_VARCHAR2_TABLE_200
758: , a80 out nocopy JTF_VARCHAR2_TABLE_200
759: , a81 out nocopy JTF_VARCHAR2_TABLE_200

Line 776: , a98 out nocopy JTF_VARCHAR2_TABLE_100

772: , a94 out nocopy JTF_NUMBER_TABLE
773: , a95 out nocopy JTF_DATE_TABLE
774: , a96 out nocopy JTF_NUMBER_TABLE
775: , a97 out nocopy JTF_NUMBER_TABLE
776: , a98 out nocopy JTF_VARCHAR2_TABLE_100
777: , a99 out nocopy JTF_VARCHAR2_TABLE_100
778: , a100 out nocopy JTF_VARCHAR2_TABLE_100
779: , a101 out nocopy JTF_NUMBER_TABLE
780: , a102 out nocopy JTF_VARCHAR2_TABLE_100

Line 777: , a99 out nocopy JTF_VARCHAR2_TABLE_100

773: , a95 out nocopy JTF_DATE_TABLE
774: , a96 out nocopy JTF_NUMBER_TABLE
775: , a97 out nocopy JTF_NUMBER_TABLE
776: , a98 out nocopy JTF_VARCHAR2_TABLE_100
777: , a99 out nocopy JTF_VARCHAR2_TABLE_100
778: , a100 out nocopy JTF_VARCHAR2_TABLE_100
779: , a101 out nocopy JTF_NUMBER_TABLE
780: , a102 out nocopy JTF_VARCHAR2_TABLE_100
781: , a103 out nocopy JTF_VARCHAR2_TABLE_100

Line 778: , a100 out nocopy JTF_VARCHAR2_TABLE_100

774: , a96 out nocopy JTF_NUMBER_TABLE
775: , a97 out nocopy JTF_NUMBER_TABLE
776: , a98 out nocopy JTF_VARCHAR2_TABLE_100
777: , a99 out nocopy JTF_VARCHAR2_TABLE_100
778: , a100 out nocopy JTF_VARCHAR2_TABLE_100
779: , a101 out nocopy JTF_NUMBER_TABLE
780: , a102 out nocopy JTF_VARCHAR2_TABLE_100
781: , a103 out nocopy JTF_VARCHAR2_TABLE_100
782: , a104 out nocopy JTF_VARCHAR2_TABLE_100

Line 780: , a102 out nocopy JTF_VARCHAR2_TABLE_100

776: , a98 out nocopy JTF_VARCHAR2_TABLE_100
777: , a99 out nocopy JTF_VARCHAR2_TABLE_100
778: , a100 out nocopy JTF_VARCHAR2_TABLE_100
779: , a101 out nocopy JTF_NUMBER_TABLE
780: , a102 out nocopy JTF_VARCHAR2_TABLE_100
781: , a103 out nocopy JTF_VARCHAR2_TABLE_100
782: , a104 out nocopy JTF_VARCHAR2_TABLE_100
783: ) as
784: ddindx binary_integer; indx binary_integer;

Line 781: , a103 out nocopy JTF_VARCHAR2_TABLE_100

777: , a99 out nocopy JTF_VARCHAR2_TABLE_100
778: , a100 out nocopy JTF_VARCHAR2_TABLE_100
779: , a101 out nocopy JTF_NUMBER_TABLE
780: , a102 out nocopy JTF_VARCHAR2_TABLE_100
781: , a103 out nocopy JTF_VARCHAR2_TABLE_100
782: , a104 out nocopy JTF_VARCHAR2_TABLE_100
783: ) as
784: ddindx binary_integer; indx binary_integer;
785: begin

Line 782: , a104 out nocopy JTF_VARCHAR2_TABLE_100

778: , a100 out nocopy JTF_VARCHAR2_TABLE_100
779: , a101 out nocopy JTF_NUMBER_TABLE
780: , a102 out nocopy JTF_VARCHAR2_TABLE_100
781: , a103 out nocopy JTF_VARCHAR2_TABLE_100
782: , a104 out nocopy JTF_VARCHAR2_TABLE_100
783: ) as
784: ddindx binary_integer; indx binary_integer;
785: begin
786: if t is null or t.count = 0 then

Line 792: a5 := JTF_VARCHAR2_TABLE_100();

788: a1 := JTF_NUMBER_TABLE();
789: a2 := JTF_NUMBER_TABLE();
790: a3 := JTF_NUMBER_TABLE();
791: a4 := JTF_NUMBER_TABLE();
792: a5 := JTF_VARCHAR2_TABLE_100();
793: a6 := JTF_VARCHAR2_TABLE_300();
794: a7 := JTF_NUMBER_TABLE();
795: a8 := JTF_VARCHAR2_TABLE_300();
796: a9 := JTF_VARCHAR2_TABLE_100();

Line 796: a9 := JTF_VARCHAR2_TABLE_100();

792: a5 := JTF_VARCHAR2_TABLE_100();
793: a6 := JTF_VARCHAR2_TABLE_300();
794: a7 := JTF_NUMBER_TABLE();
795: a8 := JTF_VARCHAR2_TABLE_300();
796: a9 := JTF_VARCHAR2_TABLE_100();
797: a10 := JTF_VARCHAR2_TABLE_300();
798: a11 := JTF_NUMBER_TABLE();
799: a12 := JTF_VARCHAR2_TABLE_100();
800: a13 := JTF_VARCHAR2_TABLE_100();

Line 799: a12 := JTF_VARCHAR2_TABLE_100();

795: a8 := JTF_VARCHAR2_TABLE_300();
796: a9 := JTF_VARCHAR2_TABLE_100();
797: a10 := JTF_VARCHAR2_TABLE_300();
798: a11 := JTF_NUMBER_TABLE();
799: a12 := JTF_VARCHAR2_TABLE_100();
800: a13 := JTF_VARCHAR2_TABLE_100();
801: a14 := JTF_VARCHAR2_TABLE_100();
802: a15 := JTF_DATE_TABLE();
803: a16 := JTF_NUMBER_TABLE();

Line 800: a13 := JTF_VARCHAR2_TABLE_100();

796: a9 := JTF_VARCHAR2_TABLE_100();
797: a10 := JTF_VARCHAR2_TABLE_300();
798: a11 := JTF_NUMBER_TABLE();
799: a12 := JTF_VARCHAR2_TABLE_100();
800: a13 := JTF_VARCHAR2_TABLE_100();
801: a14 := JTF_VARCHAR2_TABLE_100();
802: a15 := JTF_DATE_TABLE();
803: a16 := JTF_NUMBER_TABLE();
804: a17 := JTF_NUMBER_TABLE();

Line 801: a14 := JTF_VARCHAR2_TABLE_100();

797: a10 := JTF_VARCHAR2_TABLE_300();
798: a11 := JTF_NUMBER_TABLE();
799: a12 := JTF_VARCHAR2_TABLE_100();
800: a13 := JTF_VARCHAR2_TABLE_100();
801: a14 := JTF_VARCHAR2_TABLE_100();
802: a15 := JTF_DATE_TABLE();
803: a16 := JTF_NUMBER_TABLE();
804: a17 := JTF_NUMBER_TABLE();
805: a18 := JTF_DATE_TABLE();

Line 816: a29 := JTF_VARCHAR2_TABLE_100();

812: a25 := JTF_NUMBER_TABLE();
813: a26 := JTF_NUMBER_TABLE();
814: a27 := JTF_NUMBER_TABLE();
815: a28 := JTF_NUMBER_TABLE();
816: a29 := JTF_VARCHAR2_TABLE_100();
817: a30 := JTF_VARCHAR2_TABLE_100();
818: a31 := JTF_VARCHAR2_TABLE_100();
819: a32 := JTF_VARCHAR2_TABLE_300();
820: a33 := JTF_VARCHAR2_TABLE_100();

Line 817: a30 := JTF_VARCHAR2_TABLE_100();

813: a26 := JTF_NUMBER_TABLE();
814: a27 := JTF_NUMBER_TABLE();
815: a28 := JTF_NUMBER_TABLE();
816: a29 := JTF_VARCHAR2_TABLE_100();
817: a30 := JTF_VARCHAR2_TABLE_100();
818: a31 := JTF_VARCHAR2_TABLE_100();
819: a32 := JTF_VARCHAR2_TABLE_300();
820: a33 := JTF_VARCHAR2_TABLE_100();
821: a34 := JTF_VARCHAR2_TABLE_100();

Line 818: a31 := JTF_VARCHAR2_TABLE_100();

814: a27 := JTF_NUMBER_TABLE();
815: a28 := JTF_NUMBER_TABLE();
816: a29 := JTF_VARCHAR2_TABLE_100();
817: a30 := JTF_VARCHAR2_TABLE_100();
818: a31 := JTF_VARCHAR2_TABLE_100();
819: a32 := JTF_VARCHAR2_TABLE_300();
820: a33 := JTF_VARCHAR2_TABLE_100();
821: a34 := JTF_VARCHAR2_TABLE_100();
822: a35 := JTF_VARCHAR2_TABLE_100();

Line 820: a33 := JTF_VARCHAR2_TABLE_100();

816: a29 := JTF_VARCHAR2_TABLE_100();
817: a30 := JTF_VARCHAR2_TABLE_100();
818: a31 := JTF_VARCHAR2_TABLE_100();
819: a32 := JTF_VARCHAR2_TABLE_300();
820: a33 := JTF_VARCHAR2_TABLE_100();
821: a34 := JTF_VARCHAR2_TABLE_100();
822: a35 := JTF_VARCHAR2_TABLE_100();
823: a36 := JTF_NUMBER_TABLE();
824: a37 := JTF_VARCHAR2_TABLE_300();

Line 821: a34 := JTF_VARCHAR2_TABLE_100();

817: a30 := JTF_VARCHAR2_TABLE_100();
818: a31 := JTF_VARCHAR2_TABLE_100();
819: a32 := JTF_VARCHAR2_TABLE_300();
820: a33 := JTF_VARCHAR2_TABLE_100();
821: a34 := JTF_VARCHAR2_TABLE_100();
822: a35 := JTF_VARCHAR2_TABLE_100();
823: a36 := JTF_NUMBER_TABLE();
824: a37 := JTF_VARCHAR2_TABLE_300();
825: a38 := JTF_NUMBER_TABLE();

Line 822: a35 := JTF_VARCHAR2_TABLE_100();

818: a31 := JTF_VARCHAR2_TABLE_100();
819: a32 := JTF_VARCHAR2_TABLE_300();
820: a33 := JTF_VARCHAR2_TABLE_100();
821: a34 := JTF_VARCHAR2_TABLE_100();
822: a35 := JTF_VARCHAR2_TABLE_100();
823: a36 := JTF_NUMBER_TABLE();
824: a37 := JTF_VARCHAR2_TABLE_300();
825: a38 := JTF_NUMBER_TABLE();
826: a39 := JTF_VARCHAR2_TABLE_100();

Line 826: a39 := JTF_VARCHAR2_TABLE_100();

822: a35 := JTF_VARCHAR2_TABLE_100();
823: a36 := JTF_NUMBER_TABLE();
824: a37 := JTF_VARCHAR2_TABLE_300();
825: a38 := JTF_NUMBER_TABLE();
826: a39 := JTF_VARCHAR2_TABLE_100();
827: a40 := JTF_NUMBER_TABLE();
828: a41 := JTF_VARCHAR2_TABLE_100();
829: a42 := JTF_NUMBER_TABLE();
830: a43 := JTF_NUMBER_TABLE();

Line 828: a41 := JTF_VARCHAR2_TABLE_100();

824: a37 := JTF_VARCHAR2_TABLE_300();
825: a38 := JTF_NUMBER_TABLE();
826: a39 := JTF_VARCHAR2_TABLE_100();
827: a40 := JTF_NUMBER_TABLE();
828: a41 := JTF_VARCHAR2_TABLE_100();
829: a42 := JTF_NUMBER_TABLE();
830: a43 := JTF_NUMBER_TABLE();
831: a44 := JTF_VARCHAR2_TABLE_100();
832: a45 := JTF_NUMBER_TABLE();

Line 831: a44 := JTF_VARCHAR2_TABLE_100();

827: a40 := JTF_NUMBER_TABLE();
828: a41 := JTF_VARCHAR2_TABLE_100();
829: a42 := JTF_NUMBER_TABLE();
830: a43 := JTF_NUMBER_TABLE();
831: a44 := JTF_VARCHAR2_TABLE_100();
832: a45 := JTF_NUMBER_TABLE();
833: a46 := JTF_NUMBER_TABLE();
834: a47 := JTF_NUMBER_TABLE();
835: a48 := JTF_VARCHAR2_TABLE_100();

Line 835: a48 := JTF_VARCHAR2_TABLE_100();

831: a44 := JTF_VARCHAR2_TABLE_100();
832: a45 := JTF_NUMBER_TABLE();
833: a46 := JTF_NUMBER_TABLE();
834: a47 := JTF_NUMBER_TABLE();
835: a48 := JTF_VARCHAR2_TABLE_100();
836: a49 := JTF_NUMBER_TABLE();
837: a50 := JTF_NUMBER_TABLE();
838: a51 := JTF_VARCHAR2_TABLE_100();
839: a52 := JTF_VARCHAR2_TABLE_100();

Line 838: a51 := JTF_VARCHAR2_TABLE_100();

834: a47 := JTF_NUMBER_TABLE();
835: a48 := JTF_VARCHAR2_TABLE_100();
836: a49 := JTF_NUMBER_TABLE();
837: a50 := JTF_NUMBER_TABLE();
838: a51 := JTF_VARCHAR2_TABLE_100();
839: a52 := JTF_VARCHAR2_TABLE_100();
840: a53 := JTF_NUMBER_TABLE();
841: a54 := JTF_NUMBER_TABLE();
842: a55 := JTF_VARCHAR2_TABLE_300();

Line 839: a52 := JTF_VARCHAR2_TABLE_100();

835: a48 := JTF_VARCHAR2_TABLE_100();
836: a49 := JTF_NUMBER_TABLE();
837: a50 := JTF_NUMBER_TABLE();
838: a51 := JTF_VARCHAR2_TABLE_100();
839: a52 := JTF_VARCHAR2_TABLE_100();
840: a53 := JTF_NUMBER_TABLE();
841: a54 := JTF_NUMBER_TABLE();
842: a55 := JTF_VARCHAR2_TABLE_300();
843: a56 := JTF_VARCHAR2_TABLE_100();

Line 843: a56 := JTF_VARCHAR2_TABLE_100();

839: a52 := JTF_VARCHAR2_TABLE_100();
840: a53 := JTF_NUMBER_TABLE();
841: a54 := JTF_NUMBER_TABLE();
842: a55 := JTF_VARCHAR2_TABLE_300();
843: a56 := JTF_VARCHAR2_TABLE_100();
844: a57 := JTF_VARCHAR2_TABLE_100();
845: a58 := JTF_NUMBER_TABLE();
846: a59 := JTF_NUMBER_TABLE();
847: a60 := JTF_NUMBER_TABLE();

Line 844: a57 := JTF_VARCHAR2_TABLE_100();

840: a53 := JTF_NUMBER_TABLE();
841: a54 := JTF_NUMBER_TABLE();
842: a55 := JTF_VARCHAR2_TABLE_300();
843: a56 := JTF_VARCHAR2_TABLE_100();
844: a57 := JTF_VARCHAR2_TABLE_100();
845: a58 := JTF_NUMBER_TABLE();
846: a59 := JTF_NUMBER_TABLE();
847: a60 := JTF_NUMBER_TABLE();
848: a61 := JTF_NUMBER_TABLE();

Line 853: a66 := JTF_VARCHAR2_TABLE_100();

849: a62 := JTF_NUMBER_TABLE();
850: a63 := JTF_NUMBER_TABLE();
851: a64 := JTF_NUMBER_TABLE();
852: a65 := JTF_NUMBER_TABLE();
853: a66 := JTF_VARCHAR2_TABLE_100();
854: a67 := JTF_VARCHAR2_TABLE_100();
855: a68 := JTF_NUMBER_TABLE();
856: a69 := JTF_VARCHAR2_TABLE_100();
857: a70 := JTF_NUMBER_TABLE();

Line 854: a67 := JTF_VARCHAR2_TABLE_100();

850: a63 := JTF_NUMBER_TABLE();
851: a64 := JTF_NUMBER_TABLE();
852: a65 := JTF_NUMBER_TABLE();
853: a66 := JTF_VARCHAR2_TABLE_100();
854: a67 := JTF_VARCHAR2_TABLE_100();
855: a68 := JTF_NUMBER_TABLE();
856: a69 := JTF_VARCHAR2_TABLE_100();
857: a70 := JTF_NUMBER_TABLE();
858: a71 := JTF_NUMBER_TABLE();

Line 856: a69 := JTF_VARCHAR2_TABLE_100();

852: a65 := JTF_NUMBER_TABLE();
853: a66 := JTF_VARCHAR2_TABLE_100();
854: a67 := JTF_VARCHAR2_TABLE_100();
855: a68 := JTF_NUMBER_TABLE();
856: a69 := JTF_VARCHAR2_TABLE_100();
857: a70 := JTF_NUMBER_TABLE();
858: a71 := JTF_NUMBER_TABLE();
859: a72 := JTF_NUMBER_TABLE();
860: a73 := JTF_NUMBER_TABLE();

Line 861: a74 := JTF_VARCHAR2_TABLE_100();

857: a70 := JTF_NUMBER_TABLE();
858: a71 := JTF_NUMBER_TABLE();
859: a72 := JTF_NUMBER_TABLE();
860: a73 := JTF_NUMBER_TABLE();
861: a74 := JTF_VARCHAR2_TABLE_100();
862: a75 := JTF_NUMBER_TABLE();
863: a76 := JTF_NUMBER_TABLE();
864: a77 := JTF_VARCHAR2_TABLE_100();
865: a78 := JTF_VARCHAR2_TABLE_200();

Line 864: a77 := JTF_VARCHAR2_TABLE_100();

860: a73 := JTF_NUMBER_TABLE();
861: a74 := JTF_VARCHAR2_TABLE_100();
862: a75 := JTF_NUMBER_TABLE();
863: a76 := JTF_NUMBER_TABLE();
864: a77 := JTF_VARCHAR2_TABLE_100();
865: a78 := JTF_VARCHAR2_TABLE_200();
866: a79 := JTF_VARCHAR2_TABLE_200();
867: a80 := JTF_VARCHAR2_TABLE_200();
868: a81 := JTF_VARCHAR2_TABLE_200();

Line 885: a98 := JTF_VARCHAR2_TABLE_100();

881: a94 := JTF_NUMBER_TABLE();
882: a95 := JTF_DATE_TABLE();
883: a96 := JTF_NUMBER_TABLE();
884: a97 := JTF_NUMBER_TABLE();
885: a98 := JTF_VARCHAR2_TABLE_100();
886: a99 := JTF_VARCHAR2_TABLE_100();
887: a100 := JTF_VARCHAR2_TABLE_100();
888: a101 := JTF_NUMBER_TABLE();
889: a102 := JTF_VARCHAR2_TABLE_100();

Line 886: a99 := JTF_VARCHAR2_TABLE_100();

882: a95 := JTF_DATE_TABLE();
883: a96 := JTF_NUMBER_TABLE();
884: a97 := JTF_NUMBER_TABLE();
885: a98 := JTF_VARCHAR2_TABLE_100();
886: a99 := JTF_VARCHAR2_TABLE_100();
887: a100 := JTF_VARCHAR2_TABLE_100();
888: a101 := JTF_NUMBER_TABLE();
889: a102 := JTF_VARCHAR2_TABLE_100();
890: a103 := JTF_VARCHAR2_TABLE_100();

Line 887: a100 := JTF_VARCHAR2_TABLE_100();

883: a96 := JTF_NUMBER_TABLE();
884: a97 := JTF_NUMBER_TABLE();
885: a98 := JTF_VARCHAR2_TABLE_100();
886: a99 := JTF_VARCHAR2_TABLE_100();
887: a100 := JTF_VARCHAR2_TABLE_100();
888: a101 := JTF_NUMBER_TABLE();
889: a102 := JTF_VARCHAR2_TABLE_100();
890: a103 := JTF_VARCHAR2_TABLE_100();
891: a104 := JTF_VARCHAR2_TABLE_100();

Line 889: a102 := JTF_VARCHAR2_TABLE_100();

885: a98 := JTF_VARCHAR2_TABLE_100();
886: a99 := JTF_VARCHAR2_TABLE_100();
887: a100 := JTF_VARCHAR2_TABLE_100();
888: a101 := JTF_NUMBER_TABLE();
889: a102 := JTF_VARCHAR2_TABLE_100();
890: a103 := JTF_VARCHAR2_TABLE_100();
891: a104 := JTF_VARCHAR2_TABLE_100();
892: else
893: a0 := JTF_NUMBER_TABLE();

Line 890: a103 := JTF_VARCHAR2_TABLE_100();

886: a99 := JTF_VARCHAR2_TABLE_100();
887: a100 := JTF_VARCHAR2_TABLE_100();
888: a101 := JTF_NUMBER_TABLE();
889: a102 := JTF_VARCHAR2_TABLE_100();
890: a103 := JTF_VARCHAR2_TABLE_100();
891: a104 := JTF_VARCHAR2_TABLE_100();
892: else
893: a0 := JTF_NUMBER_TABLE();
894: a1 := JTF_NUMBER_TABLE();

Line 891: a104 := JTF_VARCHAR2_TABLE_100();

887: a100 := JTF_VARCHAR2_TABLE_100();
888: a101 := JTF_NUMBER_TABLE();
889: a102 := JTF_VARCHAR2_TABLE_100();
890: a103 := JTF_VARCHAR2_TABLE_100();
891: a104 := JTF_VARCHAR2_TABLE_100();
892: else
893: a0 := JTF_NUMBER_TABLE();
894: a1 := JTF_NUMBER_TABLE();
895: a2 := JTF_NUMBER_TABLE();

Line 898: a5 := JTF_VARCHAR2_TABLE_100();

894: a1 := JTF_NUMBER_TABLE();
895: a2 := JTF_NUMBER_TABLE();
896: a3 := JTF_NUMBER_TABLE();
897: a4 := JTF_NUMBER_TABLE();
898: a5 := JTF_VARCHAR2_TABLE_100();
899: a6 := JTF_VARCHAR2_TABLE_300();
900: a7 := JTF_NUMBER_TABLE();
901: a8 := JTF_VARCHAR2_TABLE_300();
902: a9 := JTF_VARCHAR2_TABLE_100();

Line 902: a9 := JTF_VARCHAR2_TABLE_100();

898: a5 := JTF_VARCHAR2_TABLE_100();
899: a6 := JTF_VARCHAR2_TABLE_300();
900: a7 := JTF_NUMBER_TABLE();
901: a8 := JTF_VARCHAR2_TABLE_300();
902: a9 := JTF_VARCHAR2_TABLE_100();
903: a10 := JTF_VARCHAR2_TABLE_300();
904: a11 := JTF_NUMBER_TABLE();
905: a12 := JTF_VARCHAR2_TABLE_100();
906: a13 := JTF_VARCHAR2_TABLE_100();

Line 905: a12 := JTF_VARCHAR2_TABLE_100();

901: a8 := JTF_VARCHAR2_TABLE_300();
902: a9 := JTF_VARCHAR2_TABLE_100();
903: a10 := JTF_VARCHAR2_TABLE_300();
904: a11 := JTF_NUMBER_TABLE();
905: a12 := JTF_VARCHAR2_TABLE_100();
906: a13 := JTF_VARCHAR2_TABLE_100();
907: a14 := JTF_VARCHAR2_TABLE_100();
908: a15 := JTF_DATE_TABLE();
909: a16 := JTF_NUMBER_TABLE();

Line 906: a13 := JTF_VARCHAR2_TABLE_100();

902: a9 := JTF_VARCHAR2_TABLE_100();
903: a10 := JTF_VARCHAR2_TABLE_300();
904: a11 := JTF_NUMBER_TABLE();
905: a12 := JTF_VARCHAR2_TABLE_100();
906: a13 := JTF_VARCHAR2_TABLE_100();
907: a14 := JTF_VARCHAR2_TABLE_100();
908: a15 := JTF_DATE_TABLE();
909: a16 := JTF_NUMBER_TABLE();
910: a17 := JTF_NUMBER_TABLE();

Line 907: a14 := JTF_VARCHAR2_TABLE_100();

903: a10 := JTF_VARCHAR2_TABLE_300();
904: a11 := JTF_NUMBER_TABLE();
905: a12 := JTF_VARCHAR2_TABLE_100();
906: a13 := JTF_VARCHAR2_TABLE_100();
907: a14 := JTF_VARCHAR2_TABLE_100();
908: a15 := JTF_DATE_TABLE();
909: a16 := JTF_NUMBER_TABLE();
910: a17 := JTF_NUMBER_TABLE();
911: a18 := JTF_DATE_TABLE();

Line 922: a29 := JTF_VARCHAR2_TABLE_100();

918: a25 := JTF_NUMBER_TABLE();
919: a26 := JTF_NUMBER_TABLE();
920: a27 := JTF_NUMBER_TABLE();
921: a28 := JTF_NUMBER_TABLE();
922: a29 := JTF_VARCHAR2_TABLE_100();
923: a30 := JTF_VARCHAR2_TABLE_100();
924: a31 := JTF_VARCHAR2_TABLE_100();
925: a32 := JTF_VARCHAR2_TABLE_300();
926: a33 := JTF_VARCHAR2_TABLE_100();

Line 923: a30 := JTF_VARCHAR2_TABLE_100();

919: a26 := JTF_NUMBER_TABLE();
920: a27 := JTF_NUMBER_TABLE();
921: a28 := JTF_NUMBER_TABLE();
922: a29 := JTF_VARCHAR2_TABLE_100();
923: a30 := JTF_VARCHAR2_TABLE_100();
924: a31 := JTF_VARCHAR2_TABLE_100();
925: a32 := JTF_VARCHAR2_TABLE_300();
926: a33 := JTF_VARCHAR2_TABLE_100();
927: a34 := JTF_VARCHAR2_TABLE_100();

Line 924: a31 := JTF_VARCHAR2_TABLE_100();

920: a27 := JTF_NUMBER_TABLE();
921: a28 := JTF_NUMBER_TABLE();
922: a29 := JTF_VARCHAR2_TABLE_100();
923: a30 := JTF_VARCHAR2_TABLE_100();
924: a31 := JTF_VARCHAR2_TABLE_100();
925: a32 := JTF_VARCHAR2_TABLE_300();
926: a33 := JTF_VARCHAR2_TABLE_100();
927: a34 := JTF_VARCHAR2_TABLE_100();
928: a35 := JTF_VARCHAR2_TABLE_100();

Line 926: a33 := JTF_VARCHAR2_TABLE_100();

922: a29 := JTF_VARCHAR2_TABLE_100();
923: a30 := JTF_VARCHAR2_TABLE_100();
924: a31 := JTF_VARCHAR2_TABLE_100();
925: a32 := JTF_VARCHAR2_TABLE_300();
926: a33 := JTF_VARCHAR2_TABLE_100();
927: a34 := JTF_VARCHAR2_TABLE_100();
928: a35 := JTF_VARCHAR2_TABLE_100();
929: a36 := JTF_NUMBER_TABLE();
930: a37 := JTF_VARCHAR2_TABLE_300();

Line 927: a34 := JTF_VARCHAR2_TABLE_100();

923: a30 := JTF_VARCHAR2_TABLE_100();
924: a31 := JTF_VARCHAR2_TABLE_100();
925: a32 := JTF_VARCHAR2_TABLE_300();
926: a33 := JTF_VARCHAR2_TABLE_100();
927: a34 := JTF_VARCHAR2_TABLE_100();
928: a35 := JTF_VARCHAR2_TABLE_100();
929: a36 := JTF_NUMBER_TABLE();
930: a37 := JTF_VARCHAR2_TABLE_300();
931: a38 := JTF_NUMBER_TABLE();

Line 928: a35 := JTF_VARCHAR2_TABLE_100();

924: a31 := JTF_VARCHAR2_TABLE_100();
925: a32 := JTF_VARCHAR2_TABLE_300();
926: a33 := JTF_VARCHAR2_TABLE_100();
927: a34 := JTF_VARCHAR2_TABLE_100();
928: a35 := JTF_VARCHAR2_TABLE_100();
929: a36 := JTF_NUMBER_TABLE();
930: a37 := JTF_VARCHAR2_TABLE_300();
931: a38 := JTF_NUMBER_TABLE();
932: a39 := JTF_VARCHAR2_TABLE_100();

Line 932: a39 := JTF_VARCHAR2_TABLE_100();

928: a35 := JTF_VARCHAR2_TABLE_100();
929: a36 := JTF_NUMBER_TABLE();
930: a37 := JTF_VARCHAR2_TABLE_300();
931: a38 := JTF_NUMBER_TABLE();
932: a39 := JTF_VARCHAR2_TABLE_100();
933: a40 := JTF_NUMBER_TABLE();
934: a41 := JTF_VARCHAR2_TABLE_100();
935: a42 := JTF_NUMBER_TABLE();
936: a43 := JTF_NUMBER_TABLE();

Line 934: a41 := JTF_VARCHAR2_TABLE_100();

930: a37 := JTF_VARCHAR2_TABLE_300();
931: a38 := JTF_NUMBER_TABLE();
932: a39 := JTF_VARCHAR2_TABLE_100();
933: a40 := JTF_NUMBER_TABLE();
934: a41 := JTF_VARCHAR2_TABLE_100();
935: a42 := JTF_NUMBER_TABLE();
936: a43 := JTF_NUMBER_TABLE();
937: a44 := JTF_VARCHAR2_TABLE_100();
938: a45 := JTF_NUMBER_TABLE();

Line 937: a44 := JTF_VARCHAR2_TABLE_100();

933: a40 := JTF_NUMBER_TABLE();
934: a41 := JTF_VARCHAR2_TABLE_100();
935: a42 := JTF_NUMBER_TABLE();
936: a43 := JTF_NUMBER_TABLE();
937: a44 := JTF_VARCHAR2_TABLE_100();
938: a45 := JTF_NUMBER_TABLE();
939: a46 := JTF_NUMBER_TABLE();
940: a47 := JTF_NUMBER_TABLE();
941: a48 := JTF_VARCHAR2_TABLE_100();

Line 941: a48 := JTF_VARCHAR2_TABLE_100();

937: a44 := JTF_VARCHAR2_TABLE_100();
938: a45 := JTF_NUMBER_TABLE();
939: a46 := JTF_NUMBER_TABLE();
940: a47 := JTF_NUMBER_TABLE();
941: a48 := JTF_VARCHAR2_TABLE_100();
942: a49 := JTF_NUMBER_TABLE();
943: a50 := JTF_NUMBER_TABLE();
944: a51 := JTF_VARCHAR2_TABLE_100();
945: a52 := JTF_VARCHAR2_TABLE_100();

Line 944: a51 := JTF_VARCHAR2_TABLE_100();

940: a47 := JTF_NUMBER_TABLE();
941: a48 := JTF_VARCHAR2_TABLE_100();
942: a49 := JTF_NUMBER_TABLE();
943: a50 := JTF_NUMBER_TABLE();
944: a51 := JTF_VARCHAR2_TABLE_100();
945: a52 := JTF_VARCHAR2_TABLE_100();
946: a53 := JTF_NUMBER_TABLE();
947: a54 := JTF_NUMBER_TABLE();
948: a55 := JTF_VARCHAR2_TABLE_300();

Line 945: a52 := JTF_VARCHAR2_TABLE_100();

941: a48 := JTF_VARCHAR2_TABLE_100();
942: a49 := JTF_NUMBER_TABLE();
943: a50 := JTF_NUMBER_TABLE();
944: a51 := JTF_VARCHAR2_TABLE_100();
945: a52 := JTF_VARCHAR2_TABLE_100();
946: a53 := JTF_NUMBER_TABLE();
947: a54 := JTF_NUMBER_TABLE();
948: a55 := JTF_VARCHAR2_TABLE_300();
949: a56 := JTF_VARCHAR2_TABLE_100();

Line 949: a56 := JTF_VARCHAR2_TABLE_100();

945: a52 := JTF_VARCHAR2_TABLE_100();
946: a53 := JTF_NUMBER_TABLE();
947: a54 := JTF_NUMBER_TABLE();
948: a55 := JTF_VARCHAR2_TABLE_300();
949: a56 := JTF_VARCHAR2_TABLE_100();
950: a57 := JTF_VARCHAR2_TABLE_100();
951: a58 := JTF_NUMBER_TABLE();
952: a59 := JTF_NUMBER_TABLE();
953: a60 := JTF_NUMBER_TABLE();

Line 950: a57 := JTF_VARCHAR2_TABLE_100();

946: a53 := JTF_NUMBER_TABLE();
947: a54 := JTF_NUMBER_TABLE();
948: a55 := JTF_VARCHAR2_TABLE_300();
949: a56 := JTF_VARCHAR2_TABLE_100();
950: a57 := JTF_VARCHAR2_TABLE_100();
951: a58 := JTF_NUMBER_TABLE();
952: a59 := JTF_NUMBER_TABLE();
953: a60 := JTF_NUMBER_TABLE();
954: a61 := JTF_NUMBER_TABLE();

Line 959: a66 := JTF_VARCHAR2_TABLE_100();

955: a62 := JTF_NUMBER_TABLE();
956: a63 := JTF_NUMBER_TABLE();
957: a64 := JTF_NUMBER_TABLE();
958: a65 := JTF_NUMBER_TABLE();
959: a66 := JTF_VARCHAR2_TABLE_100();
960: a67 := JTF_VARCHAR2_TABLE_100();
961: a68 := JTF_NUMBER_TABLE();
962: a69 := JTF_VARCHAR2_TABLE_100();
963: a70 := JTF_NUMBER_TABLE();

Line 960: a67 := JTF_VARCHAR2_TABLE_100();

956: a63 := JTF_NUMBER_TABLE();
957: a64 := JTF_NUMBER_TABLE();
958: a65 := JTF_NUMBER_TABLE();
959: a66 := JTF_VARCHAR2_TABLE_100();
960: a67 := JTF_VARCHAR2_TABLE_100();
961: a68 := JTF_NUMBER_TABLE();
962: a69 := JTF_VARCHAR2_TABLE_100();
963: a70 := JTF_NUMBER_TABLE();
964: a71 := JTF_NUMBER_TABLE();

Line 962: a69 := JTF_VARCHAR2_TABLE_100();

958: a65 := JTF_NUMBER_TABLE();
959: a66 := JTF_VARCHAR2_TABLE_100();
960: a67 := JTF_VARCHAR2_TABLE_100();
961: a68 := JTF_NUMBER_TABLE();
962: a69 := JTF_VARCHAR2_TABLE_100();
963: a70 := JTF_NUMBER_TABLE();
964: a71 := JTF_NUMBER_TABLE();
965: a72 := JTF_NUMBER_TABLE();
966: a73 := JTF_NUMBER_TABLE();

Line 967: a74 := JTF_VARCHAR2_TABLE_100();

963: a70 := JTF_NUMBER_TABLE();
964: a71 := JTF_NUMBER_TABLE();
965: a72 := JTF_NUMBER_TABLE();
966: a73 := JTF_NUMBER_TABLE();
967: a74 := JTF_VARCHAR2_TABLE_100();
968: a75 := JTF_NUMBER_TABLE();
969: a76 := JTF_NUMBER_TABLE();
970: a77 := JTF_VARCHAR2_TABLE_100();
971: a78 := JTF_VARCHAR2_TABLE_200();

Line 970: a77 := JTF_VARCHAR2_TABLE_100();

966: a73 := JTF_NUMBER_TABLE();
967: a74 := JTF_VARCHAR2_TABLE_100();
968: a75 := JTF_NUMBER_TABLE();
969: a76 := JTF_NUMBER_TABLE();
970: a77 := JTF_VARCHAR2_TABLE_100();
971: a78 := JTF_VARCHAR2_TABLE_200();
972: a79 := JTF_VARCHAR2_TABLE_200();
973: a80 := JTF_VARCHAR2_TABLE_200();
974: a81 := JTF_VARCHAR2_TABLE_200();

Line 991: a98 := JTF_VARCHAR2_TABLE_100();

987: a94 := JTF_NUMBER_TABLE();
988: a95 := JTF_DATE_TABLE();
989: a96 := JTF_NUMBER_TABLE();
990: a97 := JTF_NUMBER_TABLE();
991: a98 := JTF_VARCHAR2_TABLE_100();
992: a99 := JTF_VARCHAR2_TABLE_100();
993: a100 := JTF_VARCHAR2_TABLE_100();
994: a101 := JTF_NUMBER_TABLE();
995: a102 := JTF_VARCHAR2_TABLE_100();

Line 992: a99 := JTF_VARCHAR2_TABLE_100();

988: a95 := JTF_DATE_TABLE();
989: a96 := JTF_NUMBER_TABLE();
990: a97 := JTF_NUMBER_TABLE();
991: a98 := JTF_VARCHAR2_TABLE_100();
992: a99 := JTF_VARCHAR2_TABLE_100();
993: a100 := JTF_VARCHAR2_TABLE_100();
994: a101 := JTF_NUMBER_TABLE();
995: a102 := JTF_VARCHAR2_TABLE_100();
996: a103 := JTF_VARCHAR2_TABLE_100();

Line 993: a100 := JTF_VARCHAR2_TABLE_100();

989: a96 := JTF_NUMBER_TABLE();
990: a97 := JTF_NUMBER_TABLE();
991: a98 := JTF_VARCHAR2_TABLE_100();
992: a99 := JTF_VARCHAR2_TABLE_100();
993: a100 := JTF_VARCHAR2_TABLE_100();
994: a101 := JTF_NUMBER_TABLE();
995: a102 := JTF_VARCHAR2_TABLE_100();
996: a103 := JTF_VARCHAR2_TABLE_100();
997: a104 := JTF_VARCHAR2_TABLE_100();

Line 995: a102 := JTF_VARCHAR2_TABLE_100();

991: a98 := JTF_VARCHAR2_TABLE_100();
992: a99 := JTF_VARCHAR2_TABLE_100();
993: a100 := JTF_VARCHAR2_TABLE_100();
994: a101 := JTF_NUMBER_TABLE();
995: a102 := JTF_VARCHAR2_TABLE_100();
996: a103 := JTF_VARCHAR2_TABLE_100();
997: a104 := JTF_VARCHAR2_TABLE_100();
998: if t.count > 0 then
999: a0.extend(t.count);

Line 996: a103 := JTF_VARCHAR2_TABLE_100();

992: a99 := JTF_VARCHAR2_TABLE_100();
993: a100 := JTF_VARCHAR2_TABLE_100();
994: a101 := JTF_NUMBER_TABLE();
995: a102 := JTF_VARCHAR2_TABLE_100();
996: a103 := JTF_VARCHAR2_TABLE_100();
997: a104 := JTF_VARCHAR2_TABLE_100();
998: if t.count > 0 then
999: a0.extend(t.count);
1000: a1.extend(t.count);

Line 997: a104 := JTF_VARCHAR2_TABLE_100();

993: a100 := JTF_VARCHAR2_TABLE_100();
994: a101 := JTF_NUMBER_TABLE();
995: a102 := JTF_VARCHAR2_TABLE_100();
996: a103 := JTF_VARCHAR2_TABLE_100();
997: a104 := JTF_VARCHAR2_TABLE_100();
998: if t.count > 0 then
999: a0.extend(t.count);
1000: a1.extend(t.count);
1001: a2.extend(t.count);

Line 1229: , a7 JTF_VARCHAR2_TABLE_100

1225: , a3 JTF_NUMBER_TABLE
1226: , a4 JTF_NUMBER_TABLE
1227: , a5 JTF_NUMBER_TABLE
1228: , a6 JTF_NUMBER_TABLE
1229: , a7 JTF_VARCHAR2_TABLE_100
1230: ) as
1231: ddindx binary_integer; indx binary_integer;
1232: begin
1233: if a0 is not null and a0.count > 0 then

Line 1262: , a7 out nocopy JTF_VARCHAR2_TABLE_100

1258: , a3 out nocopy JTF_NUMBER_TABLE
1259: , a4 out nocopy JTF_NUMBER_TABLE
1260: , a5 out nocopy JTF_NUMBER_TABLE
1261: , a6 out nocopy JTF_NUMBER_TABLE
1262: , a7 out nocopy JTF_VARCHAR2_TABLE_100
1263: ) as
1264: ddindx binary_integer; indx binary_integer;
1265: begin
1266: if t is null or t.count = 0 then

Line 1274: a7 := JTF_VARCHAR2_TABLE_100();

1270: a3 := JTF_NUMBER_TABLE();
1271: a4 := JTF_NUMBER_TABLE();
1272: a5 := JTF_NUMBER_TABLE();
1273: a6 := JTF_NUMBER_TABLE();
1274: a7 := JTF_VARCHAR2_TABLE_100();
1275: else
1276: a0 := JTF_NUMBER_TABLE();
1277: a1 := JTF_NUMBER_TABLE();
1278: a2 := JTF_NUMBER_TABLE();

Line 1283: a7 := JTF_VARCHAR2_TABLE_100();

1279: a3 := JTF_NUMBER_TABLE();
1280: a4 := JTF_NUMBER_TABLE();
1281: a5 := JTF_NUMBER_TABLE();
1282: a6 := JTF_NUMBER_TABLE();
1283: a7 := JTF_VARCHAR2_TABLE_100();
1284: if t.count > 0 then
1285: a0.extend(t.count);
1286: a1.extend(t.count);
1287: a2.extend(t.count);

Line 1316: , a2 JTF_VARCHAR2_TABLE_100

1312: end rosetta_table_copy_out_p5;
1313:
1314: procedure rosetta_table_copy_in_p14(t out nocopy ahl_prd_workorder_pvt.turnover_notes_tbl_type, a0 JTF_NUMBER_TABLE
1315: , a1 JTF_NUMBER_TABLE
1316: , a2 JTF_VARCHAR2_TABLE_100
1317: , a3 JTF_VARCHAR2_TABLE_2000
1318: , a4 JTF_NUMBER_TABLE
1319: , a5 JTF_VARCHAR2_TABLE_300
1320: , a6 JTF_DATE_TABLE

Line 1349: , a2 out nocopy JTF_VARCHAR2_TABLE_100

1345: end if;
1346: end rosetta_table_copy_in_p14;
1347: procedure rosetta_table_copy_out_p14(t ahl_prd_workorder_pvt.turnover_notes_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1348: , a1 out nocopy JTF_NUMBER_TABLE
1349: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1350: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
1351: , a4 out nocopy JTF_NUMBER_TABLE
1352: , a5 out nocopy JTF_VARCHAR2_TABLE_300
1353: , a6 out nocopy JTF_DATE_TABLE

Line 1361: a2 := JTF_VARCHAR2_TABLE_100();

1357: begin
1358: if t is null or t.count = 0 then
1359: a0 := JTF_NUMBER_TABLE();
1360: a1 := JTF_NUMBER_TABLE();
1361: a2 := JTF_VARCHAR2_TABLE_100();
1362: a3 := JTF_VARCHAR2_TABLE_2000();
1363: a4 := JTF_NUMBER_TABLE();
1364: a5 := JTF_VARCHAR2_TABLE_300();
1365: a6 := JTF_DATE_TABLE();

Line 1370: a2 := JTF_VARCHAR2_TABLE_100();

1366: a7 := JTF_NUMBER_TABLE();
1367: else
1368: a0 := JTF_NUMBER_TABLE();
1369: a1 := JTF_NUMBER_TABLE();
1370: a2 := JTF_VARCHAR2_TABLE_100();
1371: a3 := JTF_VARCHAR2_TABLE_2000();
1372: a4 := JTF_NUMBER_TABLE();
1373: a5 := JTF_VARCHAR2_TABLE_300();
1374: a6 := JTF_DATE_TABLE();

Line 1470: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100

1466: , p9_a1 in out nocopy JTF_NUMBER_TABLE
1467: , p9_a2 in out nocopy JTF_NUMBER_TABLE
1468: , p9_a3 in out nocopy JTF_NUMBER_TABLE
1469: , p9_a4 in out nocopy JTF_NUMBER_TABLE
1470: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1471: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
1472: , p9_a7 in out nocopy JTF_NUMBER_TABLE
1473: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_300
1474: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1474: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100

1470: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1471: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
1472: , p9_a7 in out nocopy JTF_NUMBER_TABLE
1473: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_300
1474: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
1475: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_300
1476: , p9_a11 in out nocopy JTF_NUMBER_TABLE
1477: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1478: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1477: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100

1473: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_300
1474: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
1475: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_300
1476: , p9_a11 in out nocopy JTF_NUMBER_TABLE
1477: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1478: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
1479: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1480: , p9_a15 in out nocopy JTF_DATE_TABLE
1481: , p9_a16 in out nocopy JTF_NUMBER_TABLE

Line 1478: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100

1474: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
1475: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_300
1476: , p9_a11 in out nocopy JTF_NUMBER_TABLE
1477: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1478: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
1479: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1480: , p9_a15 in out nocopy JTF_DATE_TABLE
1481: , p9_a16 in out nocopy JTF_NUMBER_TABLE
1482: , p9_a17 in out nocopy JTF_NUMBER_TABLE

Line 1479: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100

1475: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_300
1476: , p9_a11 in out nocopy JTF_NUMBER_TABLE
1477: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1478: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
1479: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1480: , p9_a15 in out nocopy JTF_DATE_TABLE
1481: , p9_a16 in out nocopy JTF_NUMBER_TABLE
1482: , p9_a17 in out nocopy JTF_NUMBER_TABLE
1483: , p9_a18 in out nocopy JTF_DATE_TABLE

Line 1494: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100

1490: , p9_a25 in out nocopy JTF_NUMBER_TABLE
1491: , p9_a26 in out nocopy JTF_NUMBER_TABLE
1492: , p9_a27 in out nocopy JTF_NUMBER_TABLE
1493: , p9_a28 in out nocopy JTF_NUMBER_TABLE
1494: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
1495: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
1496: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
1497: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_300
1498: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1495: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100

1491: , p9_a26 in out nocopy JTF_NUMBER_TABLE
1492: , p9_a27 in out nocopy JTF_NUMBER_TABLE
1493: , p9_a28 in out nocopy JTF_NUMBER_TABLE
1494: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
1495: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
1496: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
1497: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_300
1498: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100
1499: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1496: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100

1492: , p9_a27 in out nocopy JTF_NUMBER_TABLE
1493: , p9_a28 in out nocopy JTF_NUMBER_TABLE
1494: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
1495: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
1496: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
1497: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_300
1498: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100
1499: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
1500: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1498: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100

1494: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
1495: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
1496: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
1497: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_300
1498: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100
1499: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
1500: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
1501: , p9_a36 in out nocopy JTF_NUMBER_TABLE
1502: , p9_a37 in out nocopy JTF_VARCHAR2_TABLE_300

Line 1499: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100

1495: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
1496: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
1497: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_300
1498: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100
1499: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
1500: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
1501: , p9_a36 in out nocopy JTF_NUMBER_TABLE
1502: , p9_a37 in out nocopy JTF_VARCHAR2_TABLE_300
1503: , p9_a38 in out nocopy JTF_NUMBER_TABLE

Line 1500: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100

1496: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
1497: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_300
1498: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100
1499: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
1500: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
1501: , p9_a36 in out nocopy JTF_NUMBER_TABLE
1502: , p9_a37 in out nocopy JTF_VARCHAR2_TABLE_300
1503: , p9_a38 in out nocopy JTF_NUMBER_TABLE
1504: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1504: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100

1500: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
1501: , p9_a36 in out nocopy JTF_NUMBER_TABLE
1502: , p9_a37 in out nocopy JTF_VARCHAR2_TABLE_300
1503: , p9_a38 in out nocopy JTF_NUMBER_TABLE
1504: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100
1505: , p9_a40 in out nocopy JTF_NUMBER_TABLE
1506: , p9_a41 in out nocopy JTF_VARCHAR2_TABLE_100
1507: , p9_a42 in out nocopy JTF_NUMBER_TABLE
1508: , p9_a43 in out nocopy JTF_NUMBER_TABLE

Line 1506: , p9_a41 in out nocopy JTF_VARCHAR2_TABLE_100

1502: , p9_a37 in out nocopy JTF_VARCHAR2_TABLE_300
1503: , p9_a38 in out nocopy JTF_NUMBER_TABLE
1504: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100
1505: , p9_a40 in out nocopy JTF_NUMBER_TABLE
1506: , p9_a41 in out nocopy JTF_VARCHAR2_TABLE_100
1507: , p9_a42 in out nocopy JTF_NUMBER_TABLE
1508: , p9_a43 in out nocopy JTF_NUMBER_TABLE
1509: , p9_a44 in out nocopy JTF_VARCHAR2_TABLE_100
1510: , p9_a45 in out nocopy JTF_NUMBER_TABLE

Line 1509: , p9_a44 in out nocopy JTF_VARCHAR2_TABLE_100

1505: , p9_a40 in out nocopy JTF_NUMBER_TABLE
1506: , p9_a41 in out nocopy JTF_VARCHAR2_TABLE_100
1507: , p9_a42 in out nocopy JTF_NUMBER_TABLE
1508: , p9_a43 in out nocopy JTF_NUMBER_TABLE
1509: , p9_a44 in out nocopy JTF_VARCHAR2_TABLE_100
1510: , p9_a45 in out nocopy JTF_NUMBER_TABLE
1511: , p9_a46 in out nocopy JTF_NUMBER_TABLE
1512: , p9_a47 in out nocopy JTF_NUMBER_TABLE
1513: , p9_a48 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1513: , p9_a48 in out nocopy JTF_VARCHAR2_TABLE_100

1509: , p9_a44 in out nocopy JTF_VARCHAR2_TABLE_100
1510: , p9_a45 in out nocopy JTF_NUMBER_TABLE
1511: , p9_a46 in out nocopy JTF_NUMBER_TABLE
1512: , p9_a47 in out nocopy JTF_NUMBER_TABLE
1513: , p9_a48 in out nocopy JTF_VARCHAR2_TABLE_100
1514: , p9_a49 in out nocopy JTF_NUMBER_TABLE
1515: , p9_a50 in out nocopy JTF_NUMBER_TABLE
1516: , p9_a51 in out nocopy JTF_VARCHAR2_TABLE_100
1517: , p9_a52 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1516: , p9_a51 in out nocopy JTF_VARCHAR2_TABLE_100

1512: , p9_a47 in out nocopy JTF_NUMBER_TABLE
1513: , p9_a48 in out nocopy JTF_VARCHAR2_TABLE_100
1514: , p9_a49 in out nocopy JTF_NUMBER_TABLE
1515: , p9_a50 in out nocopy JTF_NUMBER_TABLE
1516: , p9_a51 in out nocopy JTF_VARCHAR2_TABLE_100
1517: , p9_a52 in out nocopy JTF_VARCHAR2_TABLE_100
1518: , p9_a53 in out nocopy JTF_NUMBER_TABLE
1519: , p9_a54 in out nocopy JTF_NUMBER_TABLE
1520: , p9_a55 in out nocopy JTF_VARCHAR2_TABLE_300

Line 1517: , p9_a52 in out nocopy JTF_VARCHAR2_TABLE_100

1513: , p9_a48 in out nocopy JTF_VARCHAR2_TABLE_100
1514: , p9_a49 in out nocopy JTF_NUMBER_TABLE
1515: , p9_a50 in out nocopy JTF_NUMBER_TABLE
1516: , p9_a51 in out nocopy JTF_VARCHAR2_TABLE_100
1517: , p9_a52 in out nocopy JTF_VARCHAR2_TABLE_100
1518: , p9_a53 in out nocopy JTF_NUMBER_TABLE
1519: , p9_a54 in out nocopy JTF_NUMBER_TABLE
1520: , p9_a55 in out nocopy JTF_VARCHAR2_TABLE_300
1521: , p9_a56 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1521: , p9_a56 in out nocopy JTF_VARCHAR2_TABLE_100

1517: , p9_a52 in out nocopy JTF_VARCHAR2_TABLE_100
1518: , p9_a53 in out nocopy JTF_NUMBER_TABLE
1519: , p9_a54 in out nocopy JTF_NUMBER_TABLE
1520: , p9_a55 in out nocopy JTF_VARCHAR2_TABLE_300
1521: , p9_a56 in out nocopy JTF_VARCHAR2_TABLE_100
1522: , p9_a57 in out nocopy JTF_VARCHAR2_TABLE_100
1523: , p9_a58 in out nocopy JTF_NUMBER_TABLE
1524: , p9_a59 in out nocopy JTF_NUMBER_TABLE
1525: , p9_a60 in out nocopy JTF_NUMBER_TABLE

Line 1522: , p9_a57 in out nocopy JTF_VARCHAR2_TABLE_100

1518: , p9_a53 in out nocopy JTF_NUMBER_TABLE
1519: , p9_a54 in out nocopy JTF_NUMBER_TABLE
1520: , p9_a55 in out nocopy JTF_VARCHAR2_TABLE_300
1521: , p9_a56 in out nocopy JTF_VARCHAR2_TABLE_100
1522: , p9_a57 in out nocopy JTF_VARCHAR2_TABLE_100
1523: , p9_a58 in out nocopy JTF_NUMBER_TABLE
1524: , p9_a59 in out nocopy JTF_NUMBER_TABLE
1525: , p9_a60 in out nocopy JTF_NUMBER_TABLE
1526: , p9_a61 in out nocopy JTF_NUMBER_TABLE

Line 1531: , p9_a66 in out nocopy JTF_VARCHAR2_TABLE_100

1527: , p9_a62 in out nocopy JTF_NUMBER_TABLE
1528: , p9_a63 in out nocopy JTF_NUMBER_TABLE
1529: , p9_a64 in out nocopy JTF_NUMBER_TABLE
1530: , p9_a65 in out nocopy JTF_NUMBER_TABLE
1531: , p9_a66 in out nocopy JTF_VARCHAR2_TABLE_100
1532: , p9_a67 in out nocopy JTF_VARCHAR2_TABLE_100
1533: , p9_a68 in out nocopy JTF_NUMBER_TABLE
1534: , p9_a69 in out nocopy JTF_VARCHAR2_TABLE_100
1535: , p9_a70 in out nocopy JTF_NUMBER_TABLE

Line 1532: , p9_a67 in out nocopy JTF_VARCHAR2_TABLE_100

1528: , p9_a63 in out nocopy JTF_NUMBER_TABLE
1529: , p9_a64 in out nocopy JTF_NUMBER_TABLE
1530: , p9_a65 in out nocopy JTF_NUMBER_TABLE
1531: , p9_a66 in out nocopy JTF_VARCHAR2_TABLE_100
1532: , p9_a67 in out nocopy JTF_VARCHAR2_TABLE_100
1533: , p9_a68 in out nocopy JTF_NUMBER_TABLE
1534: , p9_a69 in out nocopy JTF_VARCHAR2_TABLE_100
1535: , p9_a70 in out nocopy JTF_NUMBER_TABLE
1536: , p9_a71 in out nocopy JTF_NUMBER_TABLE

Line 1534: , p9_a69 in out nocopy JTF_VARCHAR2_TABLE_100

1530: , p9_a65 in out nocopy JTF_NUMBER_TABLE
1531: , p9_a66 in out nocopy JTF_VARCHAR2_TABLE_100
1532: , p9_a67 in out nocopy JTF_VARCHAR2_TABLE_100
1533: , p9_a68 in out nocopy JTF_NUMBER_TABLE
1534: , p9_a69 in out nocopy JTF_VARCHAR2_TABLE_100
1535: , p9_a70 in out nocopy JTF_NUMBER_TABLE
1536: , p9_a71 in out nocopy JTF_NUMBER_TABLE
1537: , p9_a72 in out nocopy JTF_NUMBER_TABLE
1538: , p9_a73 in out nocopy JTF_NUMBER_TABLE

Line 1539: , p9_a74 in out nocopy JTF_VARCHAR2_TABLE_100

1535: , p9_a70 in out nocopy JTF_NUMBER_TABLE
1536: , p9_a71 in out nocopy JTF_NUMBER_TABLE
1537: , p9_a72 in out nocopy JTF_NUMBER_TABLE
1538: , p9_a73 in out nocopy JTF_NUMBER_TABLE
1539: , p9_a74 in out nocopy JTF_VARCHAR2_TABLE_100
1540: , p9_a75 in out nocopy JTF_NUMBER_TABLE
1541: , p9_a76 in out nocopy JTF_NUMBER_TABLE
1542: , p9_a77 in out nocopy JTF_VARCHAR2_TABLE_100
1543: , p9_a78 in out nocopy JTF_VARCHAR2_TABLE_200

Line 1542: , p9_a77 in out nocopy JTF_VARCHAR2_TABLE_100

1538: , p9_a73 in out nocopy JTF_NUMBER_TABLE
1539: , p9_a74 in out nocopy JTF_VARCHAR2_TABLE_100
1540: , p9_a75 in out nocopy JTF_NUMBER_TABLE
1541: , p9_a76 in out nocopy JTF_NUMBER_TABLE
1542: , p9_a77 in out nocopy JTF_VARCHAR2_TABLE_100
1543: , p9_a78 in out nocopy JTF_VARCHAR2_TABLE_200
1544: , p9_a79 in out nocopy JTF_VARCHAR2_TABLE_200
1545: , p9_a80 in out nocopy JTF_VARCHAR2_TABLE_200
1546: , p9_a81 in out nocopy JTF_VARCHAR2_TABLE_200

Line 1563: , p9_a98 in out nocopy JTF_VARCHAR2_TABLE_100

1559: , p9_a94 in out nocopy JTF_NUMBER_TABLE
1560: , p9_a95 in out nocopy JTF_DATE_TABLE
1561: , p9_a96 in out nocopy JTF_NUMBER_TABLE
1562: , p9_a97 in out nocopy JTF_NUMBER_TABLE
1563: , p9_a98 in out nocopy JTF_VARCHAR2_TABLE_100
1564: , p9_a99 in out nocopy JTF_VARCHAR2_TABLE_100
1565: , p9_a100 in out nocopy JTF_VARCHAR2_TABLE_100
1566: , p9_a101 in out nocopy JTF_NUMBER_TABLE
1567: , p9_a102 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1564: , p9_a99 in out nocopy JTF_VARCHAR2_TABLE_100

1560: , p9_a95 in out nocopy JTF_DATE_TABLE
1561: , p9_a96 in out nocopy JTF_NUMBER_TABLE
1562: , p9_a97 in out nocopy JTF_NUMBER_TABLE
1563: , p9_a98 in out nocopy JTF_VARCHAR2_TABLE_100
1564: , p9_a99 in out nocopy JTF_VARCHAR2_TABLE_100
1565: , p9_a100 in out nocopy JTF_VARCHAR2_TABLE_100
1566: , p9_a101 in out nocopy JTF_NUMBER_TABLE
1567: , p9_a102 in out nocopy JTF_VARCHAR2_TABLE_100
1568: , p9_a103 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1565: , p9_a100 in out nocopy JTF_VARCHAR2_TABLE_100

1561: , p9_a96 in out nocopy JTF_NUMBER_TABLE
1562: , p9_a97 in out nocopy JTF_NUMBER_TABLE
1563: , p9_a98 in out nocopy JTF_VARCHAR2_TABLE_100
1564: , p9_a99 in out nocopy JTF_VARCHAR2_TABLE_100
1565: , p9_a100 in out nocopy JTF_VARCHAR2_TABLE_100
1566: , p9_a101 in out nocopy JTF_NUMBER_TABLE
1567: , p9_a102 in out nocopy JTF_VARCHAR2_TABLE_100
1568: , p9_a103 in out nocopy JTF_VARCHAR2_TABLE_100
1569: , p9_a104 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1567: , p9_a102 in out nocopy JTF_VARCHAR2_TABLE_100

1563: , p9_a98 in out nocopy JTF_VARCHAR2_TABLE_100
1564: , p9_a99 in out nocopy JTF_VARCHAR2_TABLE_100
1565: , p9_a100 in out nocopy JTF_VARCHAR2_TABLE_100
1566: , p9_a101 in out nocopy JTF_NUMBER_TABLE
1567: , p9_a102 in out nocopy JTF_VARCHAR2_TABLE_100
1568: , p9_a103 in out nocopy JTF_VARCHAR2_TABLE_100
1569: , p9_a104 in out nocopy JTF_VARCHAR2_TABLE_100
1570: , p10_a0 JTF_NUMBER_TABLE
1571: , p10_a1 JTF_NUMBER_TABLE

Line 1568: , p9_a103 in out nocopy JTF_VARCHAR2_TABLE_100

1564: , p9_a99 in out nocopy JTF_VARCHAR2_TABLE_100
1565: , p9_a100 in out nocopy JTF_VARCHAR2_TABLE_100
1566: , p9_a101 in out nocopy JTF_NUMBER_TABLE
1567: , p9_a102 in out nocopy JTF_VARCHAR2_TABLE_100
1568: , p9_a103 in out nocopy JTF_VARCHAR2_TABLE_100
1569: , p9_a104 in out nocopy JTF_VARCHAR2_TABLE_100
1570: , p10_a0 JTF_NUMBER_TABLE
1571: , p10_a1 JTF_NUMBER_TABLE
1572: , p10_a2 JTF_NUMBER_TABLE

Line 1569: , p9_a104 in out nocopy JTF_VARCHAR2_TABLE_100

1565: , p9_a100 in out nocopy JTF_VARCHAR2_TABLE_100
1566: , p9_a101 in out nocopy JTF_NUMBER_TABLE
1567: , p9_a102 in out nocopy JTF_VARCHAR2_TABLE_100
1568: , p9_a103 in out nocopy JTF_VARCHAR2_TABLE_100
1569: , p9_a104 in out nocopy JTF_VARCHAR2_TABLE_100
1570: , p10_a0 JTF_NUMBER_TABLE
1571: , p10_a1 JTF_NUMBER_TABLE
1572: , p10_a2 JTF_NUMBER_TABLE
1573: , p10_a3 JTF_NUMBER_TABLE

Line 1577: , p10_a7 JTF_VARCHAR2_TABLE_100

1573: , p10_a3 JTF_NUMBER_TABLE
1574: , p10_a4 JTF_NUMBER_TABLE
1575: , p10_a5 JTF_NUMBER_TABLE
1576: , p10_a6 JTF_NUMBER_TABLE
1577: , p10_a7 JTF_VARCHAR2_TABLE_100
1578: )
1579:
1580: as
1581: ddp_x_prd_workorder_tbl ahl_prd_workorder_pvt.prd_workorder_tbl;

Line 1975: , p11_a15 in out nocopy JTF_VARCHAR2_TABLE_100

1971: , p11_a11 in out nocopy JTF_NUMBER_TABLE
1972: , p11_a12 in out nocopy JTF_NUMBER_TABLE
1973: , p11_a13 in out nocopy JTF_NUMBER_TABLE
1974: , p11_a14 in out nocopy JTF_VARCHAR2_TABLE_300
1975: , p11_a15 in out nocopy JTF_VARCHAR2_TABLE_100
1976: , p11_a16 in out nocopy JTF_VARCHAR2_TABLE_100
1977: , p11_a17 in out nocopy JTF_NUMBER_TABLE
1978: , p11_a18 in out nocopy JTF_VARCHAR2_TABLE_500
1979: , p11_a19 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1976: , p11_a16 in out nocopy JTF_VARCHAR2_TABLE_100

1972: , p11_a12 in out nocopy JTF_NUMBER_TABLE
1973: , p11_a13 in out nocopy JTF_NUMBER_TABLE
1974: , p11_a14 in out nocopy JTF_VARCHAR2_TABLE_300
1975: , p11_a15 in out nocopy JTF_VARCHAR2_TABLE_100
1976: , p11_a16 in out nocopy JTF_VARCHAR2_TABLE_100
1977: , p11_a17 in out nocopy JTF_NUMBER_TABLE
1978: , p11_a18 in out nocopy JTF_VARCHAR2_TABLE_500
1979: , p11_a19 in out nocopy JTF_VARCHAR2_TABLE_100
1980: , p11_a20 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1979: , p11_a19 in out nocopy JTF_VARCHAR2_TABLE_100

1975: , p11_a15 in out nocopy JTF_VARCHAR2_TABLE_100
1976: , p11_a16 in out nocopy JTF_VARCHAR2_TABLE_100
1977: , p11_a17 in out nocopy JTF_NUMBER_TABLE
1978: , p11_a18 in out nocopy JTF_VARCHAR2_TABLE_500
1979: , p11_a19 in out nocopy JTF_VARCHAR2_TABLE_100
1980: , p11_a20 in out nocopy JTF_VARCHAR2_TABLE_100
1981: , p11_a21 in out nocopy JTF_VARCHAR2_TABLE_100
1982: , p11_a22 in out nocopy JTF_NUMBER_TABLE
1983: , p11_a23 in out nocopy JTF_NUMBER_TABLE

Line 1980: , p11_a20 in out nocopy JTF_VARCHAR2_TABLE_100

1976: , p11_a16 in out nocopy JTF_VARCHAR2_TABLE_100
1977: , p11_a17 in out nocopy JTF_NUMBER_TABLE
1978: , p11_a18 in out nocopy JTF_VARCHAR2_TABLE_500
1979: , p11_a19 in out nocopy JTF_VARCHAR2_TABLE_100
1980: , p11_a20 in out nocopy JTF_VARCHAR2_TABLE_100
1981: , p11_a21 in out nocopy JTF_VARCHAR2_TABLE_100
1982: , p11_a22 in out nocopy JTF_NUMBER_TABLE
1983: , p11_a23 in out nocopy JTF_NUMBER_TABLE
1984: , p11_a24 in out nocopy JTF_DATE_TABLE

Line 1981: , p11_a21 in out nocopy JTF_VARCHAR2_TABLE_100

1977: , p11_a17 in out nocopy JTF_NUMBER_TABLE
1978: , p11_a18 in out nocopy JTF_VARCHAR2_TABLE_500
1979: , p11_a19 in out nocopy JTF_VARCHAR2_TABLE_100
1980: , p11_a20 in out nocopy JTF_VARCHAR2_TABLE_100
1981: , p11_a21 in out nocopy JTF_VARCHAR2_TABLE_100
1982: , p11_a22 in out nocopy JTF_NUMBER_TABLE
1983: , p11_a23 in out nocopy JTF_NUMBER_TABLE
1984: , p11_a24 in out nocopy JTF_DATE_TABLE
1985: , p11_a25 in out nocopy JTF_NUMBER_TABLE

Line 1998: , p11_a38 in out nocopy JTF_VARCHAR2_TABLE_100

1994: , p11_a34 in out nocopy JTF_NUMBER_TABLE
1995: , p11_a35 in out nocopy JTF_NUMBER_TABLE
1996: , p11_a36 in out nocopy JTF_NUMBER_TABLE
1997: , p11_a37 in out nocopy JTF_NUMBER_TABLE
1998: , p11_a38 in out nocopy JTF_VARCHAR2_TABLE_100
1999: , p11_a39 in out nocopy JTF_NUMBER_TABLE
2000: , p11_a40 in out nocopy JTF_VARCHAR2_TABLE_100
2001: , p11_a41 in out nocopy JTF_VARCHAR2_TABLE_200
2002: , p11_a42 in out nocopy JTF_VARCHAR2_TABLE_200

Line 2000: , p11_a40 in out nocopy JTF_VARCHAR2_TABLE_100

1996: , p11_a36 in out nocopy JTF_NUMBER_TABLE
1997: , p11_a37 in out nocopy JTF_NUMBER_TABLE
1998: , p11_a38 in out nocopy JTF_VARCHAR2_TABLE_100
1999: , p11_a39 in out nocopy JTF_NUMBER_TABLE
2000: , p11_a40 in out nocopy JTF_VARCHAR2_TABLE_100
2001: , p11_a41 in out nocopy JTF_VARCHAR2_TABLE_200
2002: , p11_a42 in out nocopy JTF_VARCHAR2_TABLE_200
2003: , p11_a43 in out nocopy JTF_VARCHAR2_TABLE_200
2004: , p11_a44 in out nocopy JTF_VARCHAR2_TABLE_200

Line 2016: , p11_a56 in out nocopy JTF_VARCHAR2_TABLE_100

2012: , p11_a52 in out nocopy JTF_VARCHAR2_TABLE_200
2013: , p11_a53 in out nocopy JTF_VARCHAR2_TABLE_200
2014: , p11_a54 in out nocopy JTF_VARCHAR2_TABLE_200
2015: , p11_a55 in out nocopy JTF_VARCHAR2_TABLE_200
2016: , p11_a56 in out nocopy JTF_VARCHAR2_TABLE_100
2017: )
2018:
2019: as
2020: ddp_x_prd_workorder_rec ahl_prd_workorder_pvt.prd_workorder_rec;

Line 2402: , p5_a5 JTF_VARCHAR2_TABLE_100

2398: , p5_a1 JTF_NUMBER_TABLE
2399: , p5_a2 JTF_NUMBER_TABLE
2400: , p5_a3 JTF_NUMBER_TABLE
2401: , p5_a4 JTF_NUMBER_TABLE
2402: , p5_a5 JTF_VARCHAR2_TABLE_100
2403: , p5_a6 JTF_VARCHAR2_TABLE_300
2404: , p5_a7 JTF_NUMBER_TABLE
2405: , p5_a8 JTF_VARCHAR2_TABLE_300
2406: , p5_a9 JTF_VARCHAR2_TABLE_100

Line 2406: , p5_a9 JTF_VARCHAR2_TABLE_100

2402: , p5_a5 JTF_VARCHAR2_TABLE_100
2403: , p5_a6 JTF_VARCHAR2_TABLE_300
2404: , p5_a7 JTF_NUMBER_TABLE
2405: , p5_a8 JTF_VARCHAR2_TABLE_300
2406: , p5_a9 JTF_VARCHAR2_TABLE_100
2407: , p5_a10 JTF_VARCHAR2_TABLE_300
2408: , p5_a11 JTF_NUMBER_TABLE
2409: , p5_a12 JTF_VARCHAR2_TABLE_100
2410: , p5_a13 JTF_VARCHAR2_TABLE_100

Line 2409: , p5_a12 JTF_VARCHAR2_TABLE_100

2405: , p5_a8 JTF_VARCHAR2_TABLE_300
2406: , p5_a9 JTF_VARCHAR2_TABLE_100
2407: , p5_a10 JTF_VARCHAR2_TABLE_300
2408: , p5_a11 JTF_NUMBER_TABLE
2409: , p5_a12 JTF_VARCHAR2_TABLE_100
2410: , p5_a13 JTF_VARCHAR2_TABLE_100
2411: , p5_a14 JTF_VARCHAR2_TABLE_100
2412: , p5_a15 JTF_DATE_TABLE
2413: , p5_a16 JTF_NUMBER_TABLE

Line 2410: , p5_a13 JTF_VARCHAR2_TABLE_100

2406: , p5_a9 JTF_VARCHAR2_TABLE_100
2407: , p5_a10 JTF_VARCHAR2_TABLE_300
2408: , p5_a11 JTF_NUMBER_TABLE
2409: , p5_a12 JTF_VARCHAR2_TABLE_100
2410: , p5_a13 JTF_VARCHAR2_TABLE_100
2411: , p5_a14 JTF_VARCHAR2_TABLE_100
2412: , p5_a15 JTF_DATE_TABLE
2413: , p5_a16 JTF_NUMBER_TABLE
2414: , p5_a17 JTF_NUMBER_TABLE

Line 2411: , p5_a14 JTF_VARCHAR2_TABLE_100

2407: , p5_a10 JTF_VARCHAR2_TABLE_300
2408: , p5_a11 JTF_NUMBER_TABLE
2409: , p5_a12 JTF_VARCHAR2_TABLE_100
2410: , p5_a13 JTF_VARCHAR2_TABLE_100
2411: , p5_a14 JTF_VARCHAR2_TABLE_100
2412: , p5_a15 JTF_DATE_TABLE
2413: , p5_a16 JTF_NUMBER_TABLE
2414: , p5_a17 JTF_NUMBER_TABLE
2415: , p5_a18 JTF_DATE_TABLE

Line 2426: , p5_a29 JTF_VARCHAR2_TABLE_100

2422: , p5_a25 JTF_NUMBER_TABLE
2423: , p5_a26 JTF_NUMBER_TABLE
2424: , p5_a27 JTF_NUMBER_TABLE
2425: , p5_a28 JTF_NUMBER_TABLE
2426: , p5_a29 JTF_VARCHAR2_TABLE_100
2427: , p5_a30 JTF_VARCHAR2_TABLE_100
2428: , p5_a31 JTF_VARCHAR2_TABLE_100
2429: , p5_a32 JTF_VARCHAR2_TABLE_300
2430: , p5_a33 JTF_VARCHAR2_TABLE_100

Line 2427: , p5_a30 JTF_VARCHAR2_TABLE_100

2423: , p5_a26 JTF_NUMBER_TABLE
2424: , p5_a27 JTF_NUMBER_TABLE
2425: , p5_a28 JTF_NUMBER_TABLE
2426: , p5_a29 JTF_VARCHAR2_TABLE_100
2427: , p5_a30 JTF_VARCHAR2_TABLE_100
2428: , p5_a31 JTF_VARCHAR2_TABLE_100
2429: , p5_a32 JTF_VARCHAR2_TABLE_300
2430: , p5_a33 JTF_VARCHAR2_TABLE_100
2431: , p5_a34 JTF_VARCHAR2_TABLE_100

Line 2428: , p5_a31 JTF_VARCHAR2_TABLE_100

2424: , p5_a27 JTF_NUMBER_TABLE
2425: , p5_a28 JTF_NUMBER_TABLE
2426: , p5_a29 JTF_VARCHAR2_TABLE_100
2427: , p5_a30 JTF_VARCHAR2_TABLE_100
2428: , p5_a31 JTF_VARCHAR2_TABLE_100
2429: , p5_a32 JTF_VARCHAR2_TABLE_300
2430: , p5_a33 JTF_VARCHAR2_TABLE_100
2431: , p5_a34 JTF_VARCHAR2_TABLE_100
2432: , p5_a35 JTF_VARCHAR2_TABLE_100

Line 2430: , p5_a33 JTF_VARCHAR2_TABLE_100

2426: , p5_a29 JTF_VARCHAR2_TABLE_100
2427: , p5_a30 JTF_VARCHAR2_TABLE_100
2428: , p5_a31 JTF_VARCHAR2_TABLE_100
2429: , p5_a32 JTF_VARCHAR2_TABLE_300
2430: , p5_a33 JTF_VARCHAR2_TABLE_100
2431: , p5_a34 JTF_VARCHAR2_TABLE_100
2432: , p5_a35 JTF_VARCHAR2_TABLE_100
2433: , p5_a36 JTF_NUMBER_TABLE
2434: , p5_a37 JTF_VARCHAR2_TABLE_300

Line 2431: , p5_a34 JTF_VARCHAR2_TABLE_100

2427: , p5_a30 JTF_VARCHAR2_TABLE_100
2428: , p5_a31 JTF_VARCHAR2_TABLE_100
2429: , p5_a32 JTF_VARCHAR2_TABLE_300
2430: , p5_a33 JTF_VARCHAR2_TABLE_100
2431: , p5_a34 JTF_VARCHAR2_TABLE_100
2432: , p5_a35 JTF_VARCHAR2_TABLE_100
2433: , p5_a36 JTF_NUMBER_TABLE
2434: , p5_a37 JTF_VARCHAR2_TABLE_300
2435: , p5_a38 JTF_NUMBER_TABLE

Line 2432: , p5_a35 JTF_VARCHAR2_TABLE_100

2428: , p5_a31 JTF_VARCHAR2_TABLE_100
2429: , p5_a32 JTF_VARCHAR2_TABLE_300
2430: , p5_a33 JTF_VARCHAR2_TABLE_100
2431: , p5_a34 JTF_VARCHAR2_TABLE_100
2432: , p5_a35 JTF_VARCHAR2_TABLE_100
2433: , p5_a36 JTF_NUMBER_TABLE
2434: , p5_a37 JTF_VARCHAR2_TABLE_300
2435: , p5_a38 JTF_NUMBER_TABLE
2436: , p5_a39 JTF_VARCHAR2_TABLE_100

Line 2436: , p5_a39 JTF_VARCHAR2_TABLE_100

2432: , p5_a35 JTF_VARCHAR2_TABLE_100
2433: , p5_a36 JTF_NUMBER_TABLE
2434: , p5_a37 JTF_VARCHAR2_TABLE_300
2435: , p5_a38 JTF_NUMBER_TABLE
2436: , p5_a39 JTF_VARCHAR2_TABLE_100
2437: , p5_a40 JTF_NUMBER_TABLE
2438: , p5_a41 JTF_VARCHAR2_TABLE_100
2439: , p5_a42 JTF_NUMBER_TABLE
2440: , p5_a43 JTF_NUMBER_TABLE

Line 2438: , p5_a41 JTF_VARCHAR2_TABLE_100

2434: , p5_a37 JTF_VARCHAR2_TABLE_300
2435: , p5_a38 JTF_NUMBER_TABLE
2436: , p5_a39 JTF_VARCHAR2_TABLE_100
2437: , p5_a40 JTF_NUMBER_TABLE
2438: , p5_a41 JTF_VARCHAR2_TABLE_100
2439: , p5_a42 JTF_NUMBER_TABLE
2440: , p5_a43 JTF_NUMBER_TABLE
2441: , p5_a44 JTF_VARCHAR2_TABLE_100
2442: , p5_a45 JTF_NUMBER_TABLE

Line 2441: , p5_a44 JTF_VARCHAR2_TABLE_100

2437: , p5_a40 JTF_NUMBER_TABLE
2438: , p5_a41 JTF_VARCHAR2_TABLE_100
2439: , p5_a42 JTF_NUMBER_TABLE
2440: , p5_a43 JTF_NUMBER_TABLE
2441: , p5_a44 JTF_VARCHAR2_TABLE_100
2442: , p5_a45 JTF_NUMBER_TABLE
2443: , p5_a46 JTF_NUMBER_TABLE
2444: , p5_a47 JTF_NUMBER_TABLE
2445: , p5_a48 JTF_VARCHAR2_TABLE_100

Line 2445: , p5_a48 JTF_VARCHAR2_TABLE_100

2441: , p5_a44 JTF_VARCHAR2_TABLE_100
2442: , p5_a45 JTF_NUMBER_TABLE
2443: , p5_a46 JTF_NUMBER_TABLE
2444: , p5_a47 JTF_NUMBER_TABLE
2445: , p5_a48 JTF_VARCHAR2_TABLE_100
2446: , p5_a49 JTF_NUMBER_TABLE
2447: , p5_a50 JTF_NUMBER_TABLE
2448: , p5_a51 JTF_VARCHAR2_TABLE_100
2449: , p5_a52 JTF_VARCHAR2_TABLE_100

Line 2448: , p5_a51 JTF_VARCHAR2_TABLE_100

2444: , p5_a47 JTF_NUMBER_TABLE
2445: , p5_a48 JTF_VARCHAR2_TABLE_100
2446: , p5_a49 JTF_NUMBER_TABLE
2447: , p5_a50 JTF_NUMBER_TABLE
2448: , p5_a51 JTF_VARCHAR2_TABLE_100
2449: , p5_a52 JTF_VARCHAR2_TABLE_100
2450: , p5_a53 JTF_NUMBER_TABLE
2451: , p5_a54 JTF_NUMBER_TABLE
2452: , p5_a55 JTF_VARCHAR2_TABLE_300

Line 2449: , p5_a52 JTF_VARCHAR2_TABLE_100

2445: , p5_a48 JTF_VARCHAR2_TABLE_100
2446: , p5_a49 JTF_NUMBER_TABLE
2447: , p5_a50 JTF_NUMBER_TABLE
2448: , p5_a51 JTF_VARCHAR2_TABLE_100
2449: , p5_a52 JTF_VARCHAR2_TABLE_100
2450: , p5_a53 JTF_NUMBER_TABLE
2451: , p5_a54 JTF_NUMBER_TABLE
2452: , p5_a55 JTF_VARCHAR2_TABLE_300
2453: , p5_a56 JTF_VARCHAR2_TABLE_100

Line 2453: , p5_a56 JTF_VARCHAR2_TABLE_100

2449: , p5_a52 JTF_VARCHAR2_TABLE_100
2450: , p5_a53 JTF_NUMBER_TABLE
2451: , p5_a54 JTF_NUMBER_TABLE
2452: , p5_a55 JTF_VARCHAR2_TABLE_300
2453: , p5_a56 JTF_VARCHAR2_TABLE_100
2454: , p5_a57 JTF_VARCHAR2_TABLE_100
2455: , p5_a58 JTF_NUMBER_TABLE
2456: , p5_a59 JTF_NUMBER_TABLE
2457: , p5_a60 JTF_NUMBER_TABLE

Line 2454: , p5_a57 JTF_VARCHAR2_TABLE_100

2450: , p5_a53 JTF_NUMBER_TABLE
2451: , p5_a54 JTF_NUMBER_TABLE
2452: , p5_a55 JTF_VARCHAR2_TABLE_300
2453: , p5_a56 JTF_VARCHAR2_TABLE_100
2454: , p5_a57 JTF_VARCHAR2_TABLE_100
2455: , p5_a58 JTF_NUMBER_TABLE
2456: , p5_a59 JTF_NUMBER_TABLE
2457: , p5_a60 JTF_NUMBER_TABLE
2458: , p5_a61 JTF_NUMBER_TABLE

Line 2463: , p5_a66 JTF_VARCHAR2_TABLE_100

2459: , p5_a62 JTF_NUMBER_TABLE
2460: , p5_a63 JTF_NUMBER_TABLE
2461: , p5_a64 JTF_NUMBER_TABLE
2462: , p5_a65 JTF_NUMBER_TABLE
2463: , p5_a66 JTF_VARCHAR2_TABLE_100
2464: , p5_a67 JTF_VARCHAR2_TABLE_100
2465: , p5_a68 JTF_NUMBER_TABLE
2466: , p5_a69 JTF_VARCHAR2_TABLE_100
2467: , p5_a70 JTF_NUMBER_TABLE

Line 2464: , p5_a67 JTF_VARCHAR2_TABLE_100

2460: , p5_a63 JTF_NUMBER_TABLE
2461: , p5_a64 JTF_NUMBER_TABLE
2462: , p5_a65 JTF_NUMBER_TABLE
2463: , p5_a66 JTF_VARCHAR2_TABLE_100
2464: , p5_a67 JTF_VARCHAR2_TABLE_100
2465: , p5_a68 JTF_NUMBER_TABLE
2466: , p5_a69 JTF_VARCHAR2_TABLE_100
2467: , p5_a70 JTF_NUMBER_TABLE
2468: , p5_a71 JTF_NUMBER_TABLE

Line 2466: , p5_a69 JTF_VARCHAR2_TABLE_100

2462: , p5_a65 JTF_NUMBER_TABLE
2463: , p5_a66 JTF_VARCHAR2_TABLE_100
2464: , p5_a67 JTF_VARCHAR2_TABLE_100
2465: , p5_a68 JTF_NUMBER_TABLE
2466: , p5_a69 JTF_VARCHAR2_TABLE_100
2467: , p5_a70 JTF_NUMBER_TABLE
2468: , p5_a71 JTF_NUMBER_TABLE
2469: , p5_a72 JTF_NUMBER_TABLE
2470: , p5_a73 JTF_NUMBER_TABLE

Line 2471: , p5_a74 JTF_VARCHAR2_TABLE_100

2467: , p5_a70 JTF_NUMBER_TABLE
2468: , p5_a71 JTF_NUMBER_TABLE
2469: , p5_a72 JTF_NUMBER_TABLE
2470: , p5_a73 JTF_NUMBER_TABLE
2471: , p5_a74 JTF_VARCHAR2_TABLE_100
2472: , p5_a75 JTF_NUMBER_TABLE
2473: , p5_a76 JTF_NUMBER_TABLE
2474: , p5_a77 JTF_VARCHAR2_TABLE_100
2475: , p5_a78 JTF_VARCHAR2_TABLE_200

Line 2474: , p5_a77 JTF_VARCHAR2_TABLE_100

2470: , p5_a73 JTF_NUMBER_TABLE
2471: , p5_a74 JTF_VARCHAR2_TABLE_100
2472: , p5_a75 JTF_NUMBER_TABLE
2473: , p5_a76 JTF_NUMBER_TABLE
2474: , p5_a77 JTF_VARCHAR2_TABLE_100
2475: , p5_a78 JTF_VARCHAR2_TABLE_200
2476: , p5_a79 JTF_VARCHAR2_TABLE_200
2477: , p5_a80 JTF_VARCHAR2_TABLE_200
2478: , p5_a81 JTF_VARCHAR2_TABLE_200

Line 2495: , p5_a98 JTF_VARCHAR2_TABLE_100

2491: , p5_a94 JTF_NUMBER_TABLE
2492: , p5_a95 JTF_DATE_TABLE
2493: , p5_a96 JTF_NUMBER_TABLE
2494: , p5_a97 JTF_NUMBER_TABLE
2495: , p5_a98 JTF_VARCHAR2_TABLE_100
2496: , p5_a99 JTF_VARCHAR2_TABLE_100
2497: , p5_a100 JTF_VARCHAR2_TABLE_100
2498: , p5_a101 JTF_NUMBER_TABLE
2499: , p5_a102 JTF_VARCHAR2_TABLE_100

Line 2496: , p5_a99 JTF_VARCHAR2_TABLE_100

2492: , p5_a95 JTF_DATE_TABLE
2493: , p5_a96 JTF_NUMBER_TABLE
2494: , p5_a97 JTF_NUMBER_TABLE
2495: , p5_a98 JTF_VARCHAR2_TABLE_100
2496: , p5_a99 JTF_VARCHAR2_TABLE_100
2497: , p5_a100 JTF_VARCHAR2_TABLE_100
2498: , p5_a101 JTF_NUMBER_TABLE
2499: , p5_a102 JTF_VARCHAR2_TABLE_100
2500: , p5_a103 JTF_VARCHAR2_TABLE_100

Line 2497: , p5_a100 JTF_VARCHAR2_TABLE_100

2493: , p5_a96 JTF_NUMBER_TABLE
2494: , p5_a97 JTF_NUMBER_TABLE
2495: , p5_a98 JTF_VARCHAR2_TABLE_100
2496: , p5_a99 JTF_VARCHAR2_TABLE_100
2497: , p5_a100 JTF_VARCHAR2_TABLE_100
2498: , p5_a101 JTF_NUMBER_TABLE
2499: , p5_a102 JTF_VARCHAR2_TABLE_100
2500: , p5_a103 JTF_VARCHAR2_TABLE_100
2501: , p5_a104 JTF_VARCHAR2_TABLE_100

Line 2499: , p5_a102 JTF_VARCHAR2_TABLE_100

2495: , p5_a98 JTF_VARCHAR2_TABLE_100
2496: , p5_a99 JTF_VARCHAR2_TABLE_100
2497: , p5_a100 JTF_VARCHAR2_TABLE_100
2498: , p5_a101 JTF_NUMBER_TABLE
2499: , p5_a102 JTF_VARCHAR2_TABLE_100
2500: , p5_a103 JTF_VARCHAR2_TABLE_100
2501: , p5_a104 JTF_VARCHAR2_TABLE_100
2502: , x_return_status out nocopy VARCHAR2
2503: , x_msg_count out nocopy NUMBER

Line 2500: , p5_a103 JTF_VARCHAR2_TABLE_100

2496: , p5_a99 JTF_VARCHAR2_TABLE_100
2497: , p5_a100 JTF_VARCHAR2_TABLE_100
2498: , p5_a101 JTF_NUMBER_TABLE
2499: , p5_a102 JTF_VARCHAR2_TABLE_100
2500: , p5_a103 JTF_VARCHAR2_TABLE_100
2501: , p5_a104 JTF_VARCHAR2_TABLE_100
2502: , x_return_status out nocopy VARCHAR2
2503: , x_msg_count out nocopy NUMBER
2504: , x_msg_data out nocopy VARCHAR2

Line 2501: , p5_a104 JTF_VARCHAR2_TABLE_100

2497: , p5_a100 JTF_VARCHAR2_TABLE_100
2498: , p5_a101 JTF_NUMBER_TABLE
2499: , p5_a102 JTF_VARCHAR2_TABLE_100
2500: , p5_a103 JTF_VARCHAR2_TABLE_100
2501: , p5_a104 JTF_VARCHAR2_TABLE_100
2502: , x_return_status out nocopy VARCHAR2
2503: , x_msg_count out nocopy NUMBER
2504: , x_msg_data out nocopy VARCHAR2
2505: )

Line 2726: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100

2722: , x_msg_count out nocopy NUMBER
2723: , x_msg_data out nocopy VARCHAR2
2724: , p9_a0 in out nocopy JTF_NUMBER_TABLE
2725: , p9_a1 in out nocopy JTF_NUMBER_TABLE
2726: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
2727: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2728: , p9_a4 in out nocopy JTF_NUMBER_TABLE
2729: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_300
2730: , p9_a6 in out nocopy JTF_DATE_TABLE