DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 18: , a15 JTF_VARCHAR2_TABLE_100

14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_300
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_100

Line 19: , a16 JTF_VARCHAR2_TABLE_100

15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_300
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100

Line 22: , a19 JTF_VARCHAR2_TABLE_100

18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE

Line 23: , a20 JTF_VARCHAR2_TABLE_100

19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE

Line 24: , a21 JTF_VARCHAR2_TABLE_100

20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE

Line 41: , a38 JTF_VARCHAR2_TABLE_100

37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_NUMBER_TABLE
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_200
45: , a42 JTF_VARCHAR2_TABLE_200

Line 43: , a40 JTF_VARCHAR2_TABLE_100

39: , a36 JTF_NUMBER_TABLE
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_200
45: , a42 JTF_VARCHAR2_TABLE_200
46: , a43 JTF_VARCHAR2_TABLE_200
47: , a44 JTF_VARCHAR2_TABLE_200

Line 59: , a56 JTF_VARCHAR2_TABLE_100

55: , a52 JTF_VARCHAR2_TABLE_200
56: , a53 JTF_VARCHAR2_TABLE_200
57: , a54 JTF_VARCHAR2_TABLE_200
58: , a55 JTF_VARCHAR2_TABLE_200
59: , a56 JTF_VARCHAR2_TABLE_100
60: ) as
61: ddindx binary_integer; indx binary_integer;
62: begin
63: if a0 is not null and a0.count > 0 then

Line 149: , a15 out nocopy JTF_VARCHAR2_TABLE_100

145: , a11 out nocopy JTF_NUMBER_TABLE
146: , a12 out nocopy JTF_NUMBER_TABLE
147: , a13 out nocopy JTF_NUMBER_TABLE
148: , a14 out nocopy JTF_VARCHAR2_TABLE_300
149: , a15 out nocopy JTF_VARCHAR2_TABLE_100
150: , a16 out nocopy JTF_VARCHAR2_TABLE_100
151: , a17 out nocopy JTF_NUMBER_TABLE
152: , a18 out nocopy JTF_VARCHAR2_TABLE_500
153: , a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 150: , a16 out nocopy JTF_VARCHAR2_TABLE_100

146: , a12 out nocopy JTF_NUMBER_TABLE
147: , a13 out nocopy JTF_NUMBER_TABLE
148: , a14 out nocopy JTF_VARCHAR2_TABLE_300
149: , a15 out nocopy JTF_VARCHAR2_TABLE_100
150: , a16 out nocopy JTF_VARCHAR2_TABLE_100
151: , a17 out nocopy JTF_NUMBER_TABLE
152: , a18 out nocopy JTF_VARCHAR2_TABLE_500
153: , a19 out nocopy JTF_VARCHAR2_TABLE_100
154: , a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 153: , a19 out nocopy JTF_VARCHAR2_TABLE_100

149: , a15 out nocopy JTF_VARCHAR2_TABLE_100
150: , a16 out nocopy JTF_VARCHAR2_TABLE_100
151: , a17 out nocopy JTF_NUMBER_TABLE
152: , a18 out nocopy JTF_VARCHAR2_TABLE_500
153: , a19 out nocopy JTF_VARCHAR2_TABLE_100
154: , a20 out nocopy JTF_VARCHAR2_TABLE_100
155: , a21 out nocopy JTF_VARCHAR2_TABLE_100
156: , a22 out nocopy JTF_NUMBER_TABLE
157: , a23 out nocopy JTF_NUMBER_TABLE

Line 154: , a20 out nocopy JTF_VARCHAR2_TABLE_100

150: , a16 out nocopy JTF_VARCHAR2_TABLE_100
151: , a17 out nocopy JTF_NUMBER_TABLE
152: , a18 out nocopy JTF_VARCHAR2_TABLE_500
153: , a19 out nocopy JTF_VARCHAR2_TABLE_100
154: , a20 out nocopy JTF_VARCHAR2_TABLE_100
155: , a21 out nocopy JTF_VARCHAR2_TABLE_100
156: , a22 out nocopy JTF_NUMBER_TABLE
157: , a23 out nocopy JTF_NUMBER_TABLE
158: , a24 out nocopy JTF_DATE_TABLE

Line 155: , a21 out nocopy JTF_VARCHAR2_TABLE_100

151: , a17 out nocopy JTF_NUMBER_TABLE
152: , a18 out nocopy JTF_VARCHAR2_TABLE_500
153: , a19 out nocopy JTF_VARCHAR2_TABLE_100
154: , a20 out nocopy JTF_VARCHAR2_TABLE_100
155: , a21 out nocopy JTF_VARCHAR2_TABLE_100
156: , a22 out nocopy JTF_NUMBER_TABLE
157: , a23 out nocopy JTF_NUMBER_TABLE
158: , a24 out nocopy JTF_DATE_TABLE
159: , a25 out nocopy JTF_NUMBER_TABLE

Line 172: , a38 out nocopy JTF_VARCHAR2_TABLE_100

168: , a34 out nocopy JTF_NUMBER_TABLE
169: , a35 out nocopy JTF_NUMBER_TABLE
170: , a36 out nocopy JTF_NUMBER_TABLE
171: , a37 out nocopy JTF_NUMBER_TABLE
172: , a38 out nocopy JTF_VARCHAR2_TABLE_100
173: , a39 out nocopy JTF_NUMBER_TABLE
174: , a40 out nocopy JTF_VARCHAR2_TABLE_100
175: , a41 out nocopy JTF_VARCHAR2_TABLE_200
176: , a42 out nocopy JTF_VARCHAR2_TABLE_200

Line 174: , a40 out nocopy JTF_VARCHAR2_TABLE_100

170: , a36 out nocopy JTF_NUMBER_TABLE
171: , a37 out nocopy JTF_NUMBER_TABLE
172: , a38 out nocopy JTF_VARCHAR2_TABLE_100
173: , a39 out nocopy JTF_NUMBER_TABLE
174: , a40 out nocopy JTF_VARCHAR2_TABLE_100
175: , a41 out nocopy JTF_VARCHAR2_TABLE_200
176: , a42 out nocopy JTF_VARCHAR2_TABLE_200
177: , a43 out nocopy JTF_VARCHAR2_TABLE_200
178: , a44 out nocopy JTF_VARCHAR2_TABLE_200

Line 190: , a56 out nocopy JTF_VARCHAR2_TABLE_100

186: , a52 out nocopy JTF_VARCHAR2_TABLE_200
187: , a53 out nocopy JTF_VARCHAR2_TABLE_200
188: , a54 out nocopy JTF_VARCHAR2_TABLE_200
189: , a55 out nocopy JTF_VARCHAR2_TABLE_200
190: , a56 out nocopy JTF_VARCHAR2_TABLE_100
191: ) as
192: ddindx binary_integer; indx binary_integer;
193: begin
194: if t is null or t.count = 0 then

Line 210: a15 := JTF_VARCHAR2_TABLE_100();

206: a11 := JTF_NUMBER_TABLE();
207: a12 := JTF_NUMBER_TABLE();
208: a13 := JTF_NUMBER_TABLE();
209: a14 := JTF_VARCHAR2_TABLE_300();
210: a15 := JTF_VARCHAR2_TABLE_100();
211: a16 := JTF_VARCHAR2_TABLE_100();
212: a17 := JTF_NUMBER_TABLE();
213: a18 := JTF_VARCHAR2_TABLE_500();
214: a19 := JTF_VARCHAR2_TABLE_100();

Line 211: a16 := JTF_VARCHAR2_TABLE_100();

207: a12 := JTF_NUMBER_TABLE();
208: a13 := JTF_NUMBER_TABLE();
209: a14 := JTF_VARCHAR2_TABLE_300();
210: a15 := JTF_VARCHAR2_TABLE_100();
211: a16 := JTF_VARCHAR2_TABLE_100();
212: a17 := JTF_NUMBER_TABLE();
213: a18 := JTF_VARCHAR2_TABLE_500();
214: a19 := JTF_VARCHAR2_TABLE_100();
215: a20 := JTF_VARCHAR2_TABLE_100();

Line 214: a19 := JTF_VARCHAR2_TABLE_100();

210: a15 := JTF_VARCHAR2_TABLE_100();
211: a16 := JTF_VARCHAR2_TABLE_100();
212: a17 := JTF_NUMBER_TABLE();
213: a18 := JTF_VARCHAR2_TABLE_500();
214: a19 := JTF_VARCHAR2_TABLE_100();
215: a20 := JTF_VARCHAR2_TABLE_100();
216: a21 := JTF_VARCHAR2_TABLE_100();
217: a22 := JTF_NUMBER_TABLE();
218: a23 := JTF_NUMBER_TABLE();

Line 215: a20 := JTF_VARCHAR2_TABLE_100();

211: a16 := JTF_VARCHAR2_TABLE_100();
212: a17 := JTF_NUMBER_TABLE();
213: a18 := JTF_VARCHAR2_TABLE_500();
214: a19 := JTF_VARCHAR2_TABLE_100();
215: a20 := JTF_VARCHAR2_TABLE_100();
216: a21 := JTF_VARCHAR2_TABLE_100();
217: a22 := JTF_NUMBER_TABLE();
218: a23 := JTF_NUMBER_TABLE();
219: a24 := JTF_DATE_TABLE();

Line 216: a21 := JTF_VARCHAR2_TABLE_100();

212: a17 := JTF_NUMBER_TABLE();
213: a18 := JTF_VARCHAR2_TABLE_500();
214: a19 := JTF_VARCHAR2_TABLE_100();
215: a20 := JTF_VARCHAR2_TABLE_100();
216: a21 := JTF_VARCHAR2_TABLE_100();
217: a22 := JTF_NUMBER_TABLE();
218: a23 := JTF_NUMBER_TABLE();
219: a24 := JTF_DATE_TABLE();
220: a25 := JTF_NUMBER_TABLE();

Line 233: a38 := JTF_VARCHAR2_TABLE_100();

229: a34 := JTF_NUMBER_TABLE();
230: a35 := JTF_NUMBER_TABLE();
231: a36 := JTF_NUMBER_TABLE();
232: a37 := JTF_NUMBER_TABLE();
233: a38 := JTF_VARCHAR2_TABLE_100();
234: a39 := JTF_NUMBER_TABLE();
235: a40 := JTF_VARCHAR2_TABLE_100();
236: a41 := JTF_VARCHAR2_TABLE_200();
237: a42 := JTF_VARCHAR2_TABLE_200();

Line 235: a40 := JTF_VARCHAR2_TABLE_100();

231: a36 := JTF_NUMBER_TABLE();
232: a37 := JTF_NUMBER_TABLE();
233: a38 := JTF_VARCHAR2_TABLE_100();
234: a39 := JTF_NUMBER_TABLE();
235: a40 := JTF_VARCHAR2_TABLE_100();
236: a41 := JTF_VARCHAR2_TABLE_200();
237: a42 := JTF_VARCHAR2_TABLE_200();
238: a43 := JTF_VARCHAR2_TABLE_200();
239: a44 := JTF_VARCHAR2_TABLE_200();

Line 251: a56 := JTF_VARCHAR2_TABLE_100();

247: a52 := JTF_VARCHAR2_TABLE_200();
248: a53 := JTF_VARCHAR2_TABLE_200();
249: a54 := JTF_VARCHAR2_TABLE_200();
250: a55 := JTF_VARCHAR2_TABLE_200();
251: a56 := JTF_VARCHAR2_TABLE_100();
252: else
253: a0 := JTF_NUMBER_TABLE();
254: a1 := JTF_NUMBER_TABLE();
255: a2 := JTF_NUMBER_TABLE();

Line 268: a15 := JTF_VARCHAR2_TABLE_100();

264: a11 := JTF_NUMBER_TABLE();
265: a12 := JTF_NUMBER_TABLE();
266: a13 := JTF_NUMBER_TABLE();
267: a14 := JTF_VARCHAR2_TABLE_300();
268: a15 := JTF_VARCHAR2_TABLE_100();
269: a16 := JTF_VARCHAR2_TABLE_100();
270: a17 := JTF_NUMBER_TABLE();
271: a18 := JTF_VARCHAR2_TABLE_500();
272: a19 := JTF_VARCHAR2_TABLE_100();

Line 269: a16 := JTF_VARCHAR2_TABLE_100();

265: a12 := JTF_NUMBER_TABLE();
266: a13 := JTF_NUMBER_TABLE();
267: a14 := JTF_VARCHAR2_TABLE_300();
268: a15 := JTF_VARCHAR2_TABLE_100();
269: a16 := JTF_VARCHAR2_TABLE_100();
270: a17 := JTF_NUMBER_TABLE();
271: a18 := JTF_VARCHAR2_TABLE_500();
272: a19 := JTF_VARCHAR2_TABLE_100();
273: a20 := JTF_VARCHAR2_TABLE_100();

Line 272: a19 := JTF_VARCHAR2_TABLE_100();

268: a15 := JTF_VARCHAR2_TABLE_100();
269: a16 := JTF_VARCHAR2_TABLE_100();
270: a17 := JTF_NUMBER_TABLE();
271: a18 := JTF_VARCHAR2_TABLE_500();
272: a19 := JTF_VARCHAR2_TABLE_100();
273: a20 := JTF_VARCHAR2_TABLE_100();
274: a21 := JTF_VARCHAR2_TABLE_100();
275: a22 := JTF_NUMBER_TABLE();
276: a23 := JTF_NUMBER_TABLE();

Line 273: a20 := JTF_VARCHAR2_TABLE_100();

269: a16 := JTF_VARCHAR2_TABLE_100();
270: a17 := JTF_NUMBER_TABLE();
271: a18 := JTF_VARCHAR2_TABLE_500();
272: a19 := JTF_VARCHAR2_TABLE_100();
273: a20 := JTF_VARCHAR2_TABLE_100();
274: a21 := JTF_VARCHAR2_TABLE_100();
275: a22 := JTF_NUMBER_TABLE();
276: a23 := JTF_NUMBER_TABLE();
277: a24 := JTF_DATE_TABLE();

Line 274: a21 := JTF_VARCHAR2_TABLE_100();

270: a17 := JTF_NUMBER_TABLE();
271: a18 := JTF_VARCHAR2_TABLE_500();
272: a19 := JTF_VARCHAR2_TABLE_100();
273: a20 := JTF_VARCHAR2_TABLE_100();
274: a21 := JTF_VARCHAR2_TABLE_100();
275: a22 := JTF_NUMBER_TABLE();
276: a23 := JTF_NUMBER_TABLE();
277: a24 := JTF_DATE_TABLE();
278: a25 := JTF_NUMBER_TABLE();

Line 291: a38 := JTF_VARCHAR2_TABLE_100();

287: a34 := JTF_NUMBER_TABLE();
288: a35 := JTF_NUMBER_TABLE();
289: a36 := JTF_NUMBER_TABLE();
290: a37 := JTF_NUMBER_TABLE();
291: a38 := JTF_VARCHAR2_TABLE_100();
292: a39 := JTF_NUMBER_TABLE();
293: a40 := JTF_VARCHAR2_TABLE_100();
294: a41 := JTF_VARCHAR2_TABLE_200();
295: a42 := JTF_VARCHAR2_TABLE_200();

Line 293: a40 := JTF_VARCHAR2_TABLE_100();

289: a36 := JTF_NUMBER_TABLE();
290: a37 := JTF_NUMBER_TABLE();
291: a38 := JTF_VARCHAR2_TABLE_100();
292: a39 := JTF_NUMBER_TABLE();
293: a40 := JTF_VARCHAR2_TABLE_100();
294: a41 := JTF_VARCHAR2_TABLE_200();
295: a42 := JTF_VARCHAR2_TABLE_200();
296: a43 := JTF_VARCHAR2_TABLE_200();
297: a44 := JTF_VARCHAR2_TABLE_200();

Line 309: a56 := JTF_VARCHAR2_TABLE_100();

305: a52 := JTF_VARCHAR2_TABLE_200();
306: a53 := JTF_VARCHAR2_TABLE_200();
307: a54 := JTF_VARCHAR2_TABLE_200();
308: a55 := JTF_VARCHAR2_TABLE_200();
309: a56 := JTF_VARCHAR2_TABLE_100();
310: if t.count > 0 then
311: a0.extend(t.count);
312: a1.extend(t.count);
313: a2.extend(t.count);

Line 443: , a5 JTF_VARCHAR2_TABLE_100

439: , a1 JTF_NUMBER_TABLE
440: , a2 JTF_NUMBER_TABLE
441: , a3 JTF_NUMBER_TABLE
442: , a4 JTF_NUMBER_TABLE
443: , a5 JTF_VARCHAR2_TABLE_100
444: , a6 JTF_VARCHAR2_TABLE_300
445: , a7 JTF_NUMBER_TABLE
446: , a8 JTF_VARCHAR2_TABLE_100
447: , a9 JTF_VARCHAR2_TABLE_100

Line 446: , a8 JTF_VARCHAR2_TABLE_100

442: , a4 JTF_NUMBER_TABLE
443: , a5 JTF_VARCHAR2_TABLE_100
444: , a6 JTF_VARCHAR2_TABLE_300
445: , a7 JTF_NUMBER_TABLE
446: , a8 JTF_VARCHAR2_TABLE_100
447: , a9 JTF_VARCHAR2_TABLE_100
448: , a10 JTF_VARCHAR2_TABLE_300
449: , a11 JTF_NUMBER_TABLE
450: , a12 JTF_VARCHAR2_TABLE_100

Line 447: , a9 JTF_VARCHAR2_TABLE_100

443: , a5 JTF_VARCHAR2_TABLE_100
444: , a6 JTF_VARCHAR2_TABLE_300
445: , a7 JTF_NUMBER_TABLE
446: , a8 JTF_VARCHAR2_TABLE_100
447: , a9 JTF_VARCHAR2_TABLE_100
448: , a10 JTF_VARCHAR2_TABLE_300
449: , a11 JTF_NUMBER_TABLE
450: , a12 JTF_VARCHAR2_TABLE_100
451: , a13 JTF_VARCHAR2_TABLE_100

Line 450: , a12 JTF_VARCHAR2_TABLE_100

446: , a8 JTF_VARCHAR2_TABLE_100
447: , a9 JTF_VARCHAR2_TABLE_100
448: , a10 JTF_VARCHAR2_TABLE_300
449: , a11 JTF_NUMBER_TABLE
450: , a12 JTF_VARCHAR2_TABLE_100
451: , a13 JTF_VARCHAR2_TABLE_100
452: , a14 JTF_VARCHAR2_TABLE_100
453: , a15 JTF_DATE_TABLE
454: , a16 JTF_NUMBER_TABLE

Line 451: , a13 JTF_VARCHAR2_TABLE_100

447: , a9 JTF_VARCHAR2_TABLE_100
448: , a10 JTF_VARCHAR2_TABLE_300
449: , a11 JTF_NUMBER_TABLE
450: , a12 JTF_VARCHAR2_TABLE_100
451: , a13 JTF_VARCHAR2_TABLE_100
452: , a14 JTF_VARCHAR2_TABLE_100
453: , a15 JTF_DATE_TABLE
454: , a16 JTF_NUMBER_TABLE
455: , a17 JTF_NUMBER_TABLE

Line 452: , a14 JTF_VARCHAR2_TABLE_100

448: , a10 JTF_VARCHAR2_TABLE_300
449: , a11 JTF_NUMBER_TABLE
450: , a12 JTF_VARCHAR2_TABLE_100
451: , a13 JTF_VARCHAR2_TABLE_100
452: , a14 JTF_VARCHAR2_TABLE_100
453: , a15 JTF_DATE_TABLE
454: , a16 JTF_NUMBER_TABLE
455: , a17 JTF_NUMBER_TABLE
456: , a18 JTF_DATE_TABLE

Line 467: , a29 JTF_VARCHAR2_TABLE_100

463: , a25 JTF_NUMBER_TABLE
464: , a26 JTF_NUMBER_TABLE
465: , a27 JTF_NUMBER_TABLE
466: , a28 JTF_NUMBER_TABLE
467: , a29 JTF_VARCHAR2_TABLE_100
468: , a30 JTF_VARCHAR2_TABLE_100
469: , a31 JTF_VARCHAR2_TABLE_100
470: , a32 JTF_VARCHAR2_TABLE_300
471: , a33 JTF_VARCHAR2_TABLE_100

Line 468: , a30 JTF_VARCHAR2_TABLE_100

464: , a26 JTF_NUMBER_TABLE
465: , a27 JTF_NUMBER_TABLE
466: , a28 JTF_NUMBER_TABLE
467: , a29 JTF_VARCHAR2_TABLE_100
468: , a30 JTF_VARCHAR2_TABLE_100
469: , a31 JTF_VARCHAR2_TABLE_100
470: , a32 JTF_VARCHAR2_TABLE_300
471: , a33 JTF_VARCHAR2_TABLE_100
472: , a34 JTF_VARCHAR2_TABLE_100

Line 469: , a31 JTF_VARCHAR2_TABLE_100

465: , a27 JTF_NUMBER_TABLE
466: , a28 JTF_NUMBER_TABLE
467: , a29 JTF_VARCHAR2_TABLE_100
468: , a30 JTF_VARCHAR2_TABLE_100
469: , a31 JTF_VARCHAR2_TABLE_100
470: , a32 JTF_VARCHAR2_TABLE_300
471: , a33 JTF_VARCHAR2_TABLE_100
472: , a34 JTF_VARCHAR2_TABLE_100
473: , a35 JTF_VARCHAR2_TABLE_100

Line 471: , a33 JTF_VARCHAR2_TABLE_100

467: , a29 JTF_VARCHAR2_TABLE_100
468: , a30 JTF_VARCHAR2_TABLE_100
469: , a31 JTF_VARCHAR2_TABLE_100
470: , a32 JTF_VARCHAR2_TABLE_300
471: , a33 JTF_VARCHAR2_TABLE_100
472: , a34 JTF_VARCHAR2_TABLE_100
473: , a35 JTF_VARCHAR2_TABLE_100
474: , a36 JTF_NUMBER_TABLE
475: , a37 JTF_VARCHAR2_TABLE_300

Line 472: , a34 JTF_VARCHAR2_TABLE_100

468: , a30 JTF_VARCHAR2_TABLE_100
469: , a31 JTF_VARCHAR2_TABLE_100
470: , a32 JTF_VARCHAR2_TABLE_300
471: , a33 JTF_VARCHAR2_TABLE_100
472: , a34 JTF_VARCHAR2_TABLE_100
473: , a35 JTF_VARCHAR2_TABLE_100
474: , a36 JTF_NUMBER_TABLE
475: , a37 JTF_VARCHAR2_TABLE_300
476: , a38 JTF_NUMBER_TABLE

Line 473: , a35 JTF_VARCHAR2_TABLE_100

469: , a31 JTF_VARCHAR2_TABLE_100
470: , a32 JTF_VARCHAR2_TABLE_300
471: , a33 JTF_VARCHAR2_TABLE_100
472: , a34 JTF_VARCHAR2_TABLE_100
473: , a35 JTF_VARCHAR2_TABLE_100
474: , a36 JTF_NUMBER_TABLE
475: , a37 JTF_VARCHAR2_TABLE_300
476: , a38 JTF_NUMBER_TABLE
477: , a39 JTF_VARCHAR2_TABLE_100

Line 477: , a39 JTF_VARCHAR2_TABLE_100

473: , a35 JTF_VARCHAR2_TABLE_100
474: , a36 JTF_NUMBER_TABLE
475: , a37 JTF_VARCHAR2_TABLE_300
476: , a38 JTF_NUMBER_TABLE
477: , a39 JTF_VARCHAR2_TABLE_100
478: , a40 JTF_NUMBER_TABLE
479: , a41 JTF_VARCHAR2_TABLE_100
480: , a42 JTF_NUMBER_TABLE
481: , a43 JTF_NUMBER_TABLE

Line 479: , a41 JTF_VARCHAR2_TABLE_100

475: , a37 JTF_VARCHAR2_TABLE_300
476: , a38 JTF_NUMBER_TABLE
477: , a39 JTF_VARCHAR2_TABLE_100
478: , a40 JTF_NUMBER_TABLE
479: , a41 JTF_VARCHAR2_TABLE_100
480: , a42 JTF_NUMBER_TABLE
481: , a43 JTF_NUMBER_TABLE
482: , a44 JTF_VARCHAR2_TABLE_100
483: , a45 JTF_NUMBER_TABLE

Line 482: , a44 JTF_VARCHAR2_TABLE_100

478: , a40 JTF_NUMBER_TABLE
479: , a41 JTF_VARCHAR2_TABLE_100
480: , a42 JTF_NUMBER_TABLE
481: , a43 JTF_NUMBER_TABLE
482: , a44 JTF_VARCHAR2_TABLE_100
483: , a45 JTF_NUMBER_TABLE
484: , a46 JTF_NUMBER_TABLE
485: , a47 JTF_NUMBER_TABLE
486: , a48 JTF_VARCHAR2_TABLE_100

Line 486: , a48 JTF_VARCHAR2_TABLE_100

482: , a44 JTF_VARCHAR2_TABLE_100
483: , a45 JTF_NUMBER_TABLE
484: , a46 JTF_NUMBER_TABLE
485: , a47 JTF_NUMBER_TABLE
486: , a48 JTF_VARCHAR2_TABLE_100
487: , a49 JTF_NUMBER_TABLE
488: , a50 JTF_NUMBER_TABLE
489: , a51 JTF_VARCHAR2_TABLE_100
490: , a52 JTF_VARCHAR2_TABLE_100

Line 489: , a51 JTF_VARCHAR2_TABLE_100

485: , a47 JTF_NUMBER_TABLE
486: , a48 JTF_VARCHAR2_TABLE_100
487: , a49 JTF_NUMBER_TABLE
488: , a50 JTF_NUMBER_TABLE
489: , a51 JTF_VARCHAR2_TABLE_100
490: , a52 JTF_VARCHAR2_TABLE_100
491: , a53 JTF_NUMBER_TABLE
492: , a54 JTF_NUMBER_TABLE
493: , a55 JTF_VARCHAR2_TABLE_300

Line 490: , a52 JTF_VARCHAR2_TABLE_100

486: , a48 JTF_VARCHAR2_TABLE_100
487: , a49 JTF_NUMBER_TABLE
488: , a50 JTF_NUMBER_TABLE
489: , a51 JTF_VARCHAR2_TABLE_100
490: , a52 JTF_VARCHAR2_TABLE_100
491: , a53 JTF_NUMBER_TABLE
492: , a54 JTF_NUMBER_TABLE
493: , a55 JTF_VARCHAR2_TABLE_300
494: , a56 JTF_VARCHAR2_TABLE_100

Line 494: , a56 JTF_VARCHAR2_TABLE_100

490: , a52 JTF_VARCHAR2_TABLE_100
491: , a53 JTF_NUMBER_TABLE
492: , a54 JTF_NUMBER_TABLE
493: , a55 JTF_VARCHAR2_TABLE_300
494: , a56 JTF_VARCHAR2_TABLE_100
495: , a57 JTF_VARCHAR2_TABLE_100
496: , a58 JTF_NUMBER_TABLE
497: , a59 JTF_NUMBER_TABLE
498: , a60 JTF_NUMBER_TABLE

Line 495: , a57 JTF_VARCHAR2_TABLE_100

491: , a53 JTF_NUMBER_TABLE
492: , a54 JTF_NUMBER_TABLE
493: , a55 JTF_VARCHAR2_TABLE_300
494: , a56 JTF_VARCHAR2_TABLE_100
495: , a57 JTF_VARCHAR2_TABLE_100
496: , a58 JTF_NUMBER_TABLE
497: , a59 JTF_NUMBER_TABLE
498: , a60 JTF_NUMBER_TABLE
499: , a61 JTF_NUMBER_TABLE

Line 504: , a66 JTF_VARCHAR2_TABLE_100

500: , a62 JTF_NUMBER_TABLE
501: , a63 JTF_NUMBER_TABLE
502: , a64 JTF_NUMBER_TABLE
503: , a65 JTF_NUMBER_TABLE
504: , a66 JTF_VARCHAR2_TABLE_100
505: , a67 JTF_VARCHAR2_TABLE_100
506: , a68 JTF_NUMBER_TABLE
507: , a69 JTF_VARCHAR2_TABLE_100
508: , a70 JTF_NUMBER_TABLE

Line 505: , a67 JTF_VARCHAR2_TABLE_100

501: , a63 JTF_NUMBER_TABLE
502: , a64 JTF_NUMBER_TABLE
503: , a65 JTF_NUMBER_TABLE
504: , a66 JTF_VARCHAR2_TABLE_100
505: , a67 JTF_VARCHAR2_TABLE_100
506: , a68 JTF_NUMBER_TABLE
507: , a69 JTF_VARCHAR2_TABLE_100
508: , a70 JTF_NUMBER_TABLE
509: , a71 JTF_NUMBER_TABLE

Line 507: , a69 JTF_VARCHAR2_TABLE_100

503: , a65 JTF_NUMBER_TABLE
504: , a66 JTF_VARCHAR2_TABLE_100
505: , a67 JTF_VARCHAR2_TABLE_100
506: , a68 JTF_NUMBER_TABLE
507: , a69 JTF_VARCHAR2_TABLE_100
508: , a70 JTF_NUMBER_TABLE
509: , a71 JTF_NUMBER_TABLE
510: , a72 JTF_NUMBER_TABLE
511: , a73 JTF_NUMBER_TABLE

Line 512: , a74 JTF_VARCHAR2_TABLE_100

508: , a70 JTF_NUMBER_TABLE
509: , a71 JTF_NUMBER_TABLE
510: , a72 JTF_NUMBER_TABLE
511: , a73 JTF_NUMBER_TABLE
512: , a74 JTF_VARCHAR2_TABLE_100
513: , a75 JTF_NUMBER_TABLE
514: , a76 JTF_NUMBER_TABLE
515: , a77 JTF_VARCHAR2_TABLE_100
516: , a78 JTF_VARCHAR2_TABLE_200

Line 515: , a77 JTF_VARCHAR2_TABLE_100

511: , a73 JTF_NUMBER_TABLE
512: , a74 JTF_VARCHAR2_TABLE_100
513: , a75 JTF_NUMBER_TABLE
514: , a76 JTF_NUMBER_TABLE
515: , a77 JTF_VARCHAR2_TABLE_100
516: , a78 JTF_VARCHAR2_TABLE_200
517: , a79 JTF_VARCHAR2_TABLE_200
518: , a80 JTF_VARCHAR2_TABLE_200
519: , a81 JTF_VARCHAR2_TABLE_200

Line 536: , a98 JTF_VARCHAR2_TABLE_100

532: , a94 JTF_NUMBER_TABLE
533: , a95 JTF_DATE_TABLE
534: , a96 JTF_NUMBER_TABLE
535: , a97 JTF_NUMBER_TABLE
536: , a98 JTF_VARCHAR2_TABLE_100
537: , a99 JTF_VARCHAR2_TABLE_100
538: , a100 JTF_VARCHAR2_TABLE_100
539: ) as
540: ddindx binary_integer; indx binary_integer;

Line 537: , a99 JTF_VARCHAR2_TABLE_100

533: , a95 JTF_DATE_TABLE
534: , a96 JTF_NUMBER_TABLE
535: , a97 JTF_NUMBER_TABLE
536: , a98 JTF_VARCHAR2_TABLE_100
537: , a99 JTF_VARCHAR2_TABLE_100
538: , a100 JTF_VARCHAR2_TABLE_100
539: ) as
540: ddindx binary_integer; indx binary_integer;
541: begin

Line 538: , a100 JTF_VARCHAR2_TABLE_100

534: , a96 JTF_NUMBER_TABLE
535: , a97 JTF_NUMBER_TABLE
536: , a98 JTF_VARCHAR2_TABLE_100
537: , a99 JTF_VARCHAR2_TABLE_100
538: , a100 JTF_VARCHAR2_TABLE_100
539: ) as
540: ddindx binary_integer; indx binary_integer;
541: begin
542: if a0 is not null and a0.count > 0 then

Line 662: , a5 out nocopy JTF_VARCHAR2_TABLE_100

658: , a1 out nocopy JTF_NUMBER_TABLE
659: , a2 out nocopy JTF_NUMBER_TABLE
660: , a3 out nocopy JTF_NUMBER_TABLE
661: , a4 out nocopy JTF_NUMBER_TABLE
662: , a5 out nocopy JTF_VARCHAR2_TABLE_100
663: , a6 out nocopy JTF_VARCHAR2_TABLE_300
664: , a7 out nocopy JTF_NUMBER_TABLE
665: , a8 out nocopy JTF_VARCHAR2_TABLE_100
666: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 665: , a8 out nocopy JTF_VARCHAR2_TABLE_100

661: , a4 out nocopy JTF_NUMBER_TABLE
662: , a5 out nocopy JTF_VARCHAR2_TABLE_100
663: , a6 out nocopy JTF_VARCHAR2_TABLE_300
664: , a7 out nocopy JTF_NUMBER_TABLE
665: , a8 out nocopy JTF_VARCHAR2_TABLE_100
666: , a9 out nocopy JTF_VARCHAR2_TABLE_100
667: , a10 out nocopy JTF_VARCHAR2_TABLE_300
668: , a11 out nocopy JTF_NUMBER_TABLE
669: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 666: , a9 out nocopy JTF_VARCHAR2_TABLE_100

662: , a5 out nocopy JTF_VARCHAR2_TABLE_100
663: , a6 out nocopy JTF_VARCHAR2_TABLE_300
664: , a7 out nocopy JTF_NUMBER_TABLE
665: , a8 out nocopy JTF_VARCHAR2_TABLE_100
666: , a9 out nocopy JTF_VARCHAR2_TABLE_100
667: , a10 out nocopy JTF_VARCHAR2_TABLE_300
668: , a11 out nocopy JTF_NUMBER_TABLE
669: , a12 out nocopy JTF_VARCHAR2_TABLE_100
670: , a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 669: , a12 out nocopy JTF_VARCHAR2_TABLE_100

665: , a8 out nocopy JTF_VARCHAR2_TABLE_100
666: , a9 out nocopy JTF_VARCHAR2_TABLE_100
667: , a10 out nocopy JTF_VARCHAR2_TABLE_300
668: , a11 out nocopy JTF_NUMBER_TABLE
669: , a12 out nocopy JTF_VARCHAR2_TABLE_100
670: , a13 out nocopy JTF_VARCHAR2_TABLE_100
671: , a14 out nocopy JTF_VARCHAR2_TABLE_100
672: , a15 out nocopy JTF_DATE_TABLE
673: , a16 out nocopy JTF_NUMBER_TABLE

Line 670: , a13 out nocopy JTF_VARCHAR2_TABLE_100

666: , a9 out nocopy JTF_VARCHAR2_TABLE_100
667: , a10 out nocopy JTF_VARCHAR2_TABLE_300
668: , a11 out nocopy JTF_NUMBER_TABLE
669: , a12 out nocopy JTF_VARCHAR2_TABLE_100
670: , a13 out nocopy JTF_VARCHAR2_TABLE_100
671: , a14 out nocopy JTF_VARCHAR2_TABLE_100
672: , a15 out nocopy JTF_DATE_TABLE
673: , a16 out nocopy JTF_NUMBER_TABLE
674: , a17 out nocopy JTF_NUMBER_TABLE

Line 671: , a14 out nocopy JTF_VARCHAR2_TABLE_100

667: , a10 out nocopy JTF_VARCHAR2_TABLE_300
668: , a11 out nocopy JTF_NUMBER_TABLE
669: , a12 out nocopy JTF_VARCHAR2_TABLE_100
670: , a13 out nocopy JTF_VARCHAR2_TABLE_100
671: , a14 out nocopy JTF_VARCHAR2_TABLE_100
672: , a15 out nocopy JTF_DATE_TABLE
673: , a16 out nocopy JTF_NUMBER_TABLE
674: , a17 out nocopy JTF_NUMBER_TABLE
675: , a18 out nocopy JTF_DATE_TABLE

Line 686: , a29 out nocopy JTF_VARCHAR2_TABLE_100

682: , a25 out nocopy JTF_NUMBER_TABLE
683: , a26 out nocopy JTF_NUMBER_TABLE
684: , a27 out nocopy JTF_NUMBER_TABLE
685: , a28 out nocopy JTF_NUMBER_TABLE
686: , a29 out nocopy JTF_VARCHAR2_TABLE_100
687: , a30 out nocopy JTF_VARCHAR2_TABLE_100
688: , a31 out nocopy JTF_VARCHAR2_TABLE_100
689: , a32 out nocopy JTF_VARCHAR2_TABLE_300
690: , a33 out nocopy JTF_VARCHAR2_TABLE_100

Line 687: , a30 out nocopy JTF_VARCHAR2_TABLE_100

683: , a26 out nocopy JTF_NUMBER_TABLE
684: , a27 out nocopy JTF_NUMBER_TABLE
685: , a28 out nocopy JTF_NUMBER_TABLE
686: , a29 out nocopy JTF_VARCHAR2_TABLE_100
687: , a30 out nocopy JTF_VARCHAR2_TABLE_100
688: , a31 out nocopy JTF_VARCHAR2_TABLE_100
689: , a32 out nocopy JTF_VARCHAR2_TABLE_300
690: , a33 out nocopy JTF_VARCHAR2_TABLE_100
691: , a34 out nocopy JTF_VARCHAR2_TABLE_100

Line 688: , a31 out nocopy JTF_VARCHAR2_TABLE_100

684: , a27 out nocopy JTF_NUMBER_TABLE
685: , a28 out nocopy JTF_NUMBER_TABLE
686: , a29 out nocopy JTF_VARCHAR2_TABLE_100
687: , a30 out nocopy JTF_VARCHAR2_TABLE_100
688: , a31 out nocopy JTF_VARCHAR2_TABLE_100
689: , a32 out nocopy JTF_VARCHAR2_TABLE_300
690: , a33 out nocopy JTF_VARCHAR2_TABLE_100
691: , a34 out nocopy JTF_VARCHAR2_TABLE_100
692: , a35 out nocopy JTF_VARCHAR2_TABLE_100

Line 690: , a33 out nocopy JTF_VARCHAR2_TABLE_100

686: , a29 out nocopy JTF_VARCHAR2_TABLE_100
687: , a30 out nocopy JTF_VARCHAR2_TABLE_100
688: , a31 out nocopy JTF_VARCHAR2_TABLE_100
689: , a32 out nocopy JTF_VARCHAR2_TABLE_300
690: , a33 out nocopy JTF_VARCHAR2_TABLE_100
691: , a34 out nocopy JTF_VARCHAR2_TABLE_100
692: , a35 out nocopy JTF_VARCHAR2_TABLE_100
693: , a36 out nocopy JTF_NUMBER_TABLE
694: , a37 out nocopy JTF_VARCHAR2_TABLE_300

Line 691: , a34 out nocopy JTF_VARCHAR2_TABLE_100

687: , a30 out nocopy JTF_VARCHAR2_TABLE_100
688: , a31 out nocopy JTF_VARCHAR2_TABLE_100
689: , a32 out nocopy JTF_VARCHAR2_TABLE_300
690: , a33 out nocopy JTF_VARCHAR2_TABLE_100
691: , a34 out nocopy JTF_VARCHAR2_TABLE_100
692: , a35 out nocopy JTF_VARCHAR2_TABLE_100
693: , a36 out nocopy JTF_NUMBER_TABLE
694: , a37 out nocopy JTF_VARCHAR2_TABLE_300
695: , a38 out nocopy JTF_NUMBER_TABLE

Line 692: , a35 out nocopy JTF_VARCHAR2_TABLE_100

688: , a31 out nocopy JTF_VARCHAR2_TABLE_100
689: , a32 out nocopy JTF_VARCHAR2_TABLE_300
690: , a33 out nocopy JTF_VARCHAR2_TABLE_100
691: , a34 out nocopy JTF_VARCHAR2_TABLE_100
692: , a35 out nocopy JTF_VARCHAR2_TABLE_100
693: , a36 out nocopy JTF_NUMBER_TABLE
694: , a37 out nocopy JTF_VARCHAR2_TABLE_300
695: , a38 out nocopy JTF_NUMBER_TABLE
696: , a39 out nocopy JTF_VARCHAR2_TABLE_100

Line 696: , a39 out nocopy JTF_VARCHAR2_TABLE_100

692: , a35 out nocopy JTF_VARCHAR2_TABLE_100
693: , a36 out nocopy JTF_NUMBER_TABLE
694: , a37 out nocopy JTF_VARCHAR2_TABLE_300
695: , a38 out nocopy JTF_NUMBER_TABLE
696: , a39 out nocopy JTF_VARCHAR2_TABLE_100
697: , a40 out nocopy JTF_NUMBER_TABLE
698: , a41 out nocopy JTF_VARCHAR2_TABLE_100
699: , a42 out nocopy JTF_NUMBER_TABLE
700: , a43 out nocopy JTF_NUMBER_TABLE

Line 698: , a41 out nocopy JTF_VARCHAR2_TABLE_100

694: , a37 out nocopy JTF_VARCHAR2_TABLE_300
695: , a38 out nocopy JTF_NUMBER_TABLE
696: , a39 out nocopy JTF_VARCHAR2_TABLE_100
697: , a40 out nocopy JTF_NUMBER_TABLE
698: , a41 out nocopy JTF_VARCHAR2_TABLE_100
699: , a42 out nocopy JTF_NUMBER_TABLE
700: , a43 out nocopy JTF_NUMBER_TABLE
701: , a44 out nocopy JTF_VARCHAR2_TABLE_100
702: , a45 out nocopy JTF_NUMBER_TABLE

Line 701: , a44 out nocopy JTF_VARCHAR2_TABLE_100

697: , a40 out nocopy JTF_NUMBER_TABLE
698: , a41 out nocopy JTF_VARCHAR2_TABLE_100
699: , a42 out nocopy JTF_NUMBER_TABLE
700: , a43 out nocopy JTF_NUMBER_TABLE
701: , a44 out nocopy JTF_VARCHAR2_TABLE_100
702: , a45 out nocopy JTF_NUMBER_TABLE
703: , a46 out nocopy JTF_NUMBER_TABLE
704: , a47 out nocopy JTF_NUMBER_TABLE
705: , a48 out nocopy JTF_VARCHAR2_TABLE_100

Line 705: , a48 out nocopy JTF_VARCHAR2_TABLE_100

701: , a44 out nocopy JTF_VARCHAR2_TABLE_100
702: , a45 out nocopy JTF_NUMBER_TABLE
703: , a46 out nocopy JTF_NUMBER_TABLE
704: , a47 out nocopy JTF_NUMBER_TABLE
705: , a48 out nocopy JTF_VARCHAR2_TABLE_100
706: , a49 out nocopy JTF_NUMBER_TABLE
707: , a50 out nocopy JTF_NUMBER_TABLE
708: , a51 out nocopy JTF_VARCHAR2_TABLE_100
709: , a52 out nocopy JTF_VARCHAR2_TABLE_100

Line 708: , a51 out nocopy JTF_VARCHAR2_TABLE_100

704: , a47 out nocopy JTF_NUMBER_TABLE
705: , a48 out nocopy JTF_VARCHAR2_TABLE_100
706: , a49 out nocopy JTF_NUMBER_TABLE
707: , a50 out nocopy JTF_NUMBER_TABLE
708: , a51 out nocopy JTF_VARCHAR2_TABLE_100
709: , a52 out nocopy JTF_VARCHAR2_TABLE_100
710: , a53 out nocopy JTF_NUMBER_TABLE
711: , a54 out nocopy JTF_NUMBER_TABLE
712: , a55 out nocopy JTF_VARCHAR2_TABLE_300

Line 709: , a52 out nocopy JTF_VARCHAR2_TABLE_100

705: , a48 out nocopy JTF_VARCHAR2_TABLE_100
706: , a49 out nocopy JTF_NUMBER_TABLE
707: , a50 out nocopy JTF_NUMBER_TABLE
708: , a51 out nocopy JTF_VARCHAR2_TABLE_100
709: , a52 out nocopy JTF_VARCHAR2_TABLE_100
710: , a53 out nocopy JTF_NUMBER_TABLE
711: , a54 out nocopy JTF_NUMBER_TABLE
712: , a55 out nocopy JTF_VARCHAR2_TABLE_300
713: , a56 out nocopy JTF_VARCHAR2_TABLE_100

Line 713: , a56 out nocopy JTF_VARCHAR2_TABLE_100

709: , a52 out nocopy JTF_VARCHAR2_TABLE_100
710: , a53 out nocopy JTF_NUMBER_TABLE
711: , a54 out nocopy JTF_NUMBER_TABLE
712: , a55 out nocopy JTF_VARCHAR2_TABLE_300
713: , a56 out nocopy JTF_VARCHAR2_TABLE_100
714: , a57 out nocopy JTF_VARCHAR2_TABLE_100
715: , a58 out nocopy JTF_NUMBER_TABLE
716: , a59 out nocopy JTF_NUMBER_TABLE
717: , a60 out nocopy JTF_NUMBER_TABLE

Line 714: , a57 out nocopy JTF_VARCHAR2_TABLE_100

710: , a53 out nocopy JTF_NUMBER_TABLE
711: , a54 out nocopy JTF_NUMBER_TABLE
712: , a55 out nocopy JTF_VARCHAR2_TABLE_300
713: , a56 out nocopy JTF_VARCHAR2_TABLE_100
714: , a57 out nocopy JTF_VARCHAR2_TABLE_100
715: , a58 out nocopy JTF_NUMBER_TABLE
716: , a59 out nocopy JTF_NUMBER_TABLE
717: , a60 out nocopy JTF_NUMBER_TABLE
718: , a61 out nocopy JTF_NUMBER_TABLE

Line 723: , a66 out nocopy JTF_VARCHAR2_TABLE_100

719: , a62 out nocopy JTF_NUMBER_TABLE
720: , a63 out nocopy JTF_NUMBER_TABLE
721: , a64 out nocopy JTF_NUMBER_TABLE
722: , a65 out nocopy JTF_NUMBER_TABLE
723: , a66 out nocopy JTF_VARCHAR2_TABLE_100
724: , a67 out nocopy JTF_VARCHAR2_TABLE_100
725: , a68 out nocopy JTF_NUMBER_TABLE
726: , a69 out nocopy JTF_VARCHAR2_TABLE_100
727: , a70 out nocopy JTF_NUMBER_TABLE

Line 724: , a67 out nocopy JTF_VARCHAR2_TABLE_100

720: , a63 out nocopy JTF_NUMBER_TABLE
721: , a64 out nocopy JTF_NUMBER_TABLE
722: , a65 out nocopy JTF_NUMBER_TABLE
723: , a66 out nocopy JTF_VARCHAR2_TABLE_100
724: , a67 out nocopy JTF_VARCHAR2_TABLE_100
725: , a68 out nocopy JTF_NUMBER_TABLE
726: , a69 out nocopy JTF_VARCHAR2_TABLE_100
727: , a70 out nocopy JTF_NUMBER_TABLE
728: , a71 out nocopy JTF_NUMBER_TABLE

Line 726: , a69 out nocopy JTF_VARCHAR2_TABLE_100

722: , a65 out nocopy JTF_NUMBER_TABLE
723: , a66 out nocopy JTF_VARCHAR2_TABLE_100
724: , a67 out nocopy JTF_VARCHAR2_TABLE_100
725: , a68 out nocopy JTF_NUMBER_TABLE
726: , a69 out nocopy JTF_VARCHAR2_TABLE_100
727: , a70 out nocopy JTF_NUMBER_TABLE
728: , a71 out nocopy JTF_NUMBER_TABLE
729: , a72 out nocopy JTF_NUMBER_TABLE
730: , a73 out nocopy JTF_NUMBER_TABLE

Line 731: , a74 out nocopy JTF_VARCHAR2_TABLE_100

727: , a70 out nocopy JTF_NUMBER_TABLE
728: , a71 out nocopy JTF_NUMBER_TABLE
729: , a72 out nocopy JTF_NUMBER_TABLE
730: , a73 out nocopy JTF_NUMBER_TABLE
731: , a74 out nocopy JTF_VARCHAR2_TABLE_100
732: , a75 out nocopy JTF_NUMBER_TABLE
733: , a76 out nocopy JTF_NUMBER_TABLE
734: , a77 out nocopy JTF_VARCHAR2_TABLE_100
735: , a78 out nocopy JTF_VARCHAR2_TABLE_200

Line 734: , a77 out nocopy JTF_VARCHAR2_TABLE_100

730: , a73 out nocopy JTF_NUMBER_TABLE
731: , a74 out nocopy JTF_VARCHAR2_TABLE_100
732: , a75 out nocopy JTF_NUMBER_TABLE
733: , a76 out nocopy JTF_NUMBER_TABLE
734: , a77 out nocopy JTF_VARCHAR2_TABLE_100
735: , a78 out nocopy JTF_VARCHAR2_TABLE_200
736: , a79 out nocopy JTF_VARCHAR2_TABLE_200
737: , a80 out nocopy JTF_VARCHAR2_TABLE_200
738: , a81 out nocopy JTF_VARCHAR2_TABLE_200

Line 755: , a98 out nocopy JTF_VARCHAR2_TABLE_100

751: , a94 out nocopy JTF_NUMBER_TABLE
752: , a95 out nocopy JTF_DATE_TABLE
753: , a96 out nocopy JTF_NUMBER_TABLE
754: , a97 out nocopy JTF_NUMBER_TABLE
755: , a98 out nocopy JTF_VARCHAR2_TABLE_100
756: , a99 out nocopy JTF_VARCHAR2_TABLE_100
757: , a100 out nocopy JTF_VARCHAR2_TABLE_100
758: ) as
759: ddindx binary_integer; indx binary_integer;

Line 756: , a99 out nocopy JTF_VARCHAR2_TABLE_100

752: , a95 out nocopy JTF_DATE_TABLE
753: , a96 out nocopy JTF_NUMBER_TABLE
754: , a97 out nocopy JTF_NUMBER_TABLE
755: , a98 out nocopy JTF_VARCHAR2_TABLE_100
756: , a99 out nocopy JTF_VARCHAR2_TABLE_100
757: , a100 out nocopy JTF_VARCHAR2_TABLE_100
758: ) as
759: ddindx binary_integer; indx binary_integer;
760: begin

Line 757: , a100 out nocopy JTF_VARCHAR2_TABLE_100

753: , a96 out nocopy JTF_NUMBER_TABLE
754: , a97 out nocopy JTF_NUMBER_TABLE
755: , a98 out nocopy JTF_VARCHAR2_TABLE_100
756: , a99 out nocopy JTF_VARCHAR2_TABLE_100
757: , a100 out nocopy JTF_VARCHAR2_TABLE_100
758: ) as
759: ddindx binary_integer; indx binary_integer;
760: begin
761: if t is null or t.count = 0 then

Line 767: a5 := JTF_VARCHAR2_TABLE_100();

763: a1 := JTF_NUMBER_TABLE();
764: a2 := JTF_NUMBER_TABLE();
765: a3 := JTF_NUMBER_TABLE();
766: a4 := JTF_NUMBER_TABLE();
767: a5 := JTF_VARCHAR2_TABLE_100();
768: a6 := JTF_VARCHAR2_TABLE_300();
769: a7 := JTF_NUMBER_TABLE();
770: a8 := JTF_VARCHAR2_TABLE_100();
771: a9 := JTF_VARCHAR2_TABLE_100();

Line 770: a8 := JTF_VARCHAR2_TABLE_100();

766: a4 := JTF_NUMBER_TABLE();
767: a5 := JTF_VARCHAR2_TABLE_100();
768: a6 := JTF_VARCHAR2_TABLE_300();
769: a7 := JTF_NUMBER_TABLE();
770: a8 := JTF_VARCHAR2_TABLE_100();
771: a9 := JTF_VARCHAR2_TABLE_100();
772: a10 := JTF_VARCHAR2_TABLE_300();
773: a11 := JTF_NUMBER_TABLE();
774: a12 := JTF_VARCHAR2_TABLE_100();

Line 771: a9 := JTF_VARCHAR2_TABLE_100();

767: a5 := JTF_VARCHAR2_TABLE_100();
768: a6 := JTF_VARCHAR2_TABLE_300();
769: a7 := JTF_NUMBER_TABLE();
770: a8 := JTF_VARCHAR2_TABLE_100();
771: a9 := JTF_VARCHAR2_TABLE_100();
772: a10 := JTF_VARCHAR2_TABLE_300();
773: a11 := JTF_NUMBER_TABLE();
774: a12 := JTF_VARCHAR2_TABLE_100();
775: a13 := JTF_VARCHAR2_TABLE_100();

Line 774: a12 := JTF_VARCHAR2_TABLE_100();

770: a8 := JTF_VARCHAR2_TABLE_100();
771: a9 := JTF_VARCHAR2_TABLE_100();
772: a10 := JTF_VARCHAR2_TABLE_300();
773: a11 := JTF_NUMBER_TABLE();
774: a12 := JTF_VARCHAR2_TABLE_100();
775: a13 := JTF_VARCHAR2_TABLE_100();
776: a14 := JTF_VARCHAR2_TABLE_100();
777: a15 := JTF_DATE_TABLE();
778: a16 := JTF_NUMBER_TABLE();

Line 775: a13 := JTF_VARCHAR2_TABLE_100();

771: a9 := JTF_VARCHAR2_TABLE_100();
772: a10 := JTF_VARCHAR2_TABLE_300();
773: a11 := JTF_NUMBER_TABLE();
774: a12 := JTF_VARCHAR2_TABLE_100();
775: a13 := JTF_VARCHAR2_TABLE_100();
776: a14 := JTF_VARCHAR2_TABLE_100();
777: a15 := JTF_DATE_TABLE();
778: a16 := JTF_NUMBER_TABLE();
779: a17 := JTF_NUMBER_TABLE();

Line 776: a14 := JTF_VARCHAR2_TABLE_100();

772: a10 := JTF_VARCHAR2_TABLE_300();
773: a11 := JTF_NUMBER_TABLE();
774: a12 := JTF_VARCHAR2_TABLE_100();
775: a13 := JTF_VARCHAR2_TABLE_100();
776: a14 := JTF_VARCHAR2_TABLE_100();
777: a15 := JTF_DATE_TABLE();
778: a16 := JTF_NUMBER_TABLE();
779: a17 := JTF_NUMBER_TABLE();
780: a18 := JTF_DATE_TABLE();

Line 791: a29 := JTF_VARCHAR2_TABLE_100();

787: a25 := JTF_NUMBER_TABLE();
788: a26 := JTF_NUMBER_TABLE();
789: a27 := JTF_NUMBER_TABLE();
790: a28 := JTF_NUMBER_TABLE();
791: a29 := JTF_VARCHAR2_TABLE_100();
792: a30 := JTF_VARCHAR2_TABLE_100();
793: a31 := JTF_VARCHAR2_TABLE_100();
794: a32 := JTF_VARCHAR2_TABLE_300();
795: a33 := JTF_VARCHAR2_TABLE_100();

Line 792: a30 := JTF_VARCHAR2_TABLE_100();

788: a26 := JTF_NUMBER_TABLE();
789: a27 := JTF_NUMBER_TABLE();
790: a28 := JTF_NUMBER_TABLE();
791: a29 := JTF_VARCHAR2_TABLE_100();
792: a30 := JTF_VARCHAR2_TABLE_100();
793: a31 := JTF_VARCHAR2_TABLE_100();
794: a32 := JTF_VARCHAR2_TABLE_300();
795: a33 := JTF_VARCHAR2_TABLE_100();
796: a34 := JTF_VARCHAR2_TABLE_100();

Line 793: a31 := JTF_VARCHAR2_TABLE_100();

789: a27 := JTF_NUMBER_TABLE();
790: a28 := JTF_NUMBER_TABLE();
791: a29 := JTF_VARCHAR2_TABLE_100();
792: a30 := JTF_VARCHAR2_TABLE_100();
793: a31 := JTF_VARCHAR2_TABLE_100();
794: a32 := JTF_VARCHAR2_TABLE_300();
795: a33 := JTF_VARCHAR2_TABLE_100();
796: a34 := JTF_VARCHAR2_TABLE_100();
797: a35 := JTF_VARCHAR2_TABLE_100();

Line 795: a33 := JTF_VARCHAR2_TABLE_100();

791: a29 := JTF_VARCHAR2_TABLE_100();
792: a30 := JTF_VARCHAR2_TABLE_100();
793: a31 := JTF_VARCHAR2_TABLE_100();
794: a32 := JTF_VARCHAR2_TABLE_300();
795: a33 := JTF_VARCHAR2_TABLE_100();
796: a34 := JTF_VARCHAR2_TABLE_100();
797: a35 := JTF_VARCHAR2_TABLE_100();
798: a36 := JTF_NUMBER_TABLE();
799: a37 := JTF_VARCHAR2_TABLE_300();

Line 796: a34 := JTF_VARCHAR2_TABLE_100();

792: a30 := JTF_VARCHAR2_TABLE_100();
793: a31 := JTF_VARCHAR2_TABLE_100();
794: a32 := JTF_VARCHAR2_TABLE_300();
795: a33 := JTF_VARCHAR2_TABLE_100();
796: a34 := JTF_VARCHAR2_TABLE_100();
797: a35 := JTF_VARCHAR2_TABLE_100();
798: a36 := JTF_NUMBER_TABLE();
799: a37 := JTF_VARCHAR2_TABLE_300();
800: a38 := JTF_NUMBER_TABLE();

Line 797: a35 := JTF_VARCHAR2_TABLE_100();

793: a31 := JTF_VARCHAR2_TABLE_100();
794: a32 := JTF_VARCHAR2_TABLE_300();
795: a33 := JTF_VARCHAR2_TABLE_100();
796: a34 := JTF_VARCHAR2_TABLE_100();
797: a35 := JTF_VARCHAR2_TABLE_100();
798: a36 := JTF_NUMBER_TABLE();
799: a37 := JTF_VARCHAR2_TABLE_300();
800: a38 := JTF_NUMBER_TABLE();
801: a39 := JTF_VARCHAR2_TABLE_100();

Line 801: a39 := JTF_VARCHAR2_TABLE_100();

797: a35 := JTF_VARCHAR2_TABLE_100();
798: a36 := JTF_NUMBER_TABLE();
799: a37 := JTF_VARCHAR2_TABLE_300();
800: a38 := JTF_NUMBER_TABLE();
801: a39 := JTF_VARCHAR2_TABLE_100();
802: a40 := JTF_NUMBER_TABLE();
803: a41 := JTF_VARCHAR2_TABLE_100();
804: a42 := JTF_NUMBER_TABLE();
805: a43 := JTF_NUMBER_TABLE();

Line 803: a41 := JTF_VARCHAR2_TABLE_100();

799: a37 := JTF_VARCHAR2_TABLE_300();
800: a38 := JTF_NUMBER_TABLE();
801: a39 := JTF_VARCHAR2_TABLE_100();
802: a40 := JTF_NUMBER_TABLE();
803: a41 := JTF_VARCHAR2_TABLE_100();
804: a42 := JTF_NUMBER_TABLE();
805: a43 := JTF_NUMBER_TABLE();
806: a44 := JTF_VARCHAR2_TABLE_100();
807: a45 := JTF_NUMBER_TABLE();

Line 806: a44 := JTF_VARCHAR2_TABLE_100();

802: a40 := JTF_NUMBER_TABLE();
803: a41 := JTF_VARCHAR2_TABLE_100();
804: a42 := JTF_NUMBER_TABLE();
805: a43 := JTF_NUMBER_TABLE();
806: a44 := JTF_VARCHAR2_TABLE_100();
807: a45 := JTF_NUMBER_TABLE();
808: a46 := JTF_NUMBER_TABLE();
809: a47 := JTF_NUMBER_TABLE();
810: a48 := JTF_VARCHAR2_TABLE_100();

Line 810: a48 := JTF_VARCHAR2_TABLE_100();

806: a44 := JTF_VARCHAR2_TABLE_100();
807: a45 := JTF_NUMBER_TABLE();
808: a46 := JTF_NUMBER_TABLE();
809: a47 := JTF_NUMBER_TABLE();
810: a48 := JTF_VARCHAR2_TABLE_100();
811: a49 := JTF_NUMBER_TABLE();
812: a50 := JTF_NUMBER_TABLE();
813: a51 := JTF_VARCHAR2_TABLE_100();
814: a52 := JTF_VARCHAR2_TABLE_100();

Line 813: a51 := JTF_VARCHAR2_TABLE_100();

809: a47 := JTF_NUMBER_TABLE();
810: a48 := JTF_VARCHAR2_TABLE_100();
811: a49 := JTF_NUMBER_TABLE();
812: a50 := JTF_NUMBER_TABLE();
813: a51 := JTF_VARCHAR2_TABLE_100();
814: a52 := JTF_VARCHAR2_TABLE_100();
815: a53 := JTF_NUMBER_TABLE();
816: a54 := JTF_NUMBER_TABLE();
817: a55 := JTF_VARCHAR2_TABLE_300();

Line 814: a52 := JTF_VARCHAR2_TABLE_100();

810: a48 := JTF_VARCHAR2_TABLE_100();
811: a49 := JTF_NUMBER_TABLE();
812: a50 := JTF_NUMBER_TABLE();
813: a51 := JTF_VARCHAR2_TABLE_100();
814: a52 := JTF_VARCHAR2_TABLE_100();
815: a53 := JTF_NUMBER_TABLE();
816: a54 := JTF_NUMBER_TABLE();
817: a55 := JTF_VARCHAR2_TABLE_300();
818: a56 := JTF_VARCHAR2_TABLE_100();

Line 818: a56 := JTF_VARCHAR2_TABLE_100();

814: a52 := JTF_VARCHAR2_TABLE_100();
815: a53 := JTF_NUMBER_TABLE();
816: a54 := JTF_NUMBER_TABLE();
817: a55 := JTF_VARCHAR2_TABLE_300();
818: a56 := JTF_VARCHAR2_TABLE_100();
819: a57 := JTF_VARCHAR2_TABLE_100();
820: a58 := JTF_NUMBER_TABLE();
821: a59 := JTF_NUMBER_TABLE();
822: a60 := JTF_NUMBER_TABLE();

Line 819: a57 := JTF_VARCHAR2_TABLE_100();

815: a53 := JTF_NUMBER_TABLE();
816: a54 := JTF_NUMBER_TABLE();
817: a55 := JTF_VARCHAR2_TABLE_300();
818: a56 := JTF_VARCHAR2_TABLE_100();
819: a57 := JTF_VARCHAR2_TABLE_100();
820: a58 := JTF_NUMBER_TABLE();
821: a59 := JTF_NUMBER_TABLE();
822: a60 := JTF_NUMBER_TABLE();
823: a61 := JTF_NUMBER_TABLE();

Line 828: a66 := JTF_VARCHAR2_TABLE_100();

824: a62 := JTF_NUMBER_TABLE();
825: a63 := JTF_NUMBER_TABLE();
826: a64 := JTF_NUMBER_TABLE();
827: a65 := JTF_NUMBER_TABLE();
828: a66 := JTF_VARCHAR2_TABLE_100();
829: a67 := JTF_VARCHAR2_TABLE_100();
830: a68 := JTF_NUMBER_TABLE();
831: a69 := JTF_VARCHAR2_TABLE_100();
832: a70 := JTF_NUMBER_TABLE();

Line 829: a67 := JTF_VARCHAR2_TABLE_100();

825: a63 := JTF_NUMBER_TABLE();
826: a64 := JTF_NUMBER_TABLE();
827: a65 := JTF_NUMBER_TABLE();
828: a66 := JTF_VARCHAR2_TABLE_100();
829: a67 := JTF_VARCHAR2_TABLE_100();
830: a68 := JTF_NUMBER_TABLE();
831: a69 := JTF_VARCHAR2_TABLE_100();
832: a70 := JTF_NUMBER_TABLE();
833: a71 := JTF_NUMBER_TABLE();

Line 831: a69 := JTF_VARCHAR2_TABLE_100();

827: a65 := JTF_NUMBER_TABLE();
828: a66 := JTF_VARCHAR2_TABLE_100();
829: a67 := JTF_VARCHAR2_TABLE_100();
830: a68 := JTF_NUMBER_TABLE();
831: a69 := JTF_VARCHAR2_TABLE_100();
832: a70 := JTF_NUMBER_TABLE();
833: a71 := JTF_NUMBER_TABLE();
834: a72 := JTF_NUMBER_TABLE();
835: a73 := JTF_NUMBER_TABLE();

Line 836: a74 := JTF_VARCHAR2_TABLE_100();

832: a70 := JTF_NUMBER_TABLE();
833: a71 := JTF_NUMBER_TABLE();
834: a72 := JTF_NUMBER_TABLE();
835: a73 := JTF_NUMBER_TABLE();
836: a74 := JTF_VARCHAR2_TABLE_100();
837: a75 := JTF_NUMBER_TABLE();
838: a76 := JTF_NUMBER_TABLE();
839: a77 := JTF_VARCHAR2_TABLE_100();
840: a78 := JTF_VARCHAR2_TABLE_200();

Line 839: a77 := JTF_VARCHAR2_TABLE_100();

835: a73 := JTF_NUMBER_TABLE();
836: a74 := JTF_VARCHAR2_TABLE_100();
837: a75 := JTF_NUMBER_TABLE();
838: a76 := JTF_NUMBER_TABLE();
839: a77 := JTF_VARCHAR2_TABLE_100();
840: a78 := JTF_VARCHAR2_TABLE_200();
841: a79 := JTF_VARCHAR2_TABLE_200();
842: a80 := JTF_VARCHAR2_TABLE_200();
843: a81 := JTF_VARCHAR2_TABLE_200();

Line 860: a98 := JTF_VARCHAR2_TABLE_100();

856: a94 := JTF_NUMBER_TABLE();
857: a95 := JTF_DATE_TABLE();
858: a96 := JTF_NUMBER_TABLE();
859: a97 := JTF_NUMBER_TABLE();
860: a98 := JTF_VARCHAR2_TABLE_100();
861: a99 := JTF_VARCHAR2_TABLE_100();
862: a100 := JTF_VARCHAR2_TABLE_100();
863: else
864: a0 := JTF_NUMBER_TABLE();

Line 861: a99 := JTF_VARCHAR2_TABLE_100();

857: a95 := JTF_DATE_TABLE();
858: a96 := JTF_NUMBER_TABLE();
859: a97 := JTF_NUMBER_TABLE();
860: a98 := JTF_VARCHAR2_TABLE_100();
861: a99 := JTF_VARCHAR2_TABLE_100();
862: a100 := JTF_VARCHAR2_TABLE_100();
863: else
864: a0 := JTF_NUMBER_TABLE();
865: a1 := JTF_NUMBER_TABLE();

Line 862: a100 := JTF_VARCHAR2_TABLE_100();

858: a96 := JTF_NUMBER_TABLE();
859: a97 := JTF_NUMBER_TABLE();
860: a98 := JTF_VARCHAR2_TABLE_100();
861: a99 := JTF_VARCHAR2_TABLE_100();
862: a100 := JTF_VARCHAR2_TABLE_100();
863: else
864: a0 := JTF_NUMBER_TABLE();
865: a1 := JTF_NUMBER_TABLE();
866: a2 := JTF_NUMBER_TABLE();

Line 869: a5 := JTF_VARCHAR2_TABLE_100();

865: a1 := JTF_NUMBER_TABLE();
866: a2 := JTF_NUMBER_TABLE();
867: a3 := JTF_NUMBER_TABLE();
868: a4 := JTF_NUMBER_TABLE();
869: a5 := JTF_VARCHAR2_TABLE_100();
870: a6 := JTF_VARCHAR2_TABLE_300();
871: a7 := JTF_NUMBER_TABLE();
872: a8 := JTF_VARCHAR2_TABLE_100();
873: a9 := JTF_VARCHAR2_TABLE_100();

Line 872: a8 := JTF_VARCHAR2_TABLE_100();

868: a4 := JTF_NUMBER_TABLE();
869: a5 := JTF_VARCHAR2_TABLE_100();
870: a6 := JTF_VARCHAR2_TABLE_300();
871: a7 := JTF_NUMBER_TABLE();
872: a8 := JTF_VARCHAR2_TABLE_100();
873: a9 := JTF_VARCHAR2_TABLE_100();
874: a10 := JTF_VARCHAR2_TABLE_300();
875: a11 := JTF_NUMBER_TABLE();
876: a12 := JTF_VARCHAR2_TABLE_100();

Line 873: a9 := JTF_VARCHAR2_TABLE_100();

869: a5 := JTF_VARCHAR2_TABLE_100();
870: a6 := JTF_VARCHAR2_TABLE_300();
871: a7 := JTF_NUMBER_TABLE();
872: a8 := JTF_VARCHAR2_TABLE_100();
873: a9 := JTF_VARCHAR2_TABLE_100();
874: a10 := JTF_VARCHAR2_TABLE_300();
875: a11 := JTF_NUMBER_TABLE();
876: a12 := JTF_VARCHAR2_TABLE_100();
877: a13 := JTF_VARCHAR2_TABLE_100();

Line 876: a12 := JTF_VARCHAR2_TABLE_100();

872: a8 := JTF_VARCHAR2_TABLE_100();
873: a9 := JTF_VARCHAR2_TABLE_100();
874: a10 := JTF_VARCHAR2_TABLE_300();
875: a11 := JTF_NUMBER_TABLE();
876: a12 := JTF_VARCHAR2_TABLE_100();
877: a13 := JTF_VARCHAR2_TABLE_100();
878: a14 := JTF_VARCHAR2_TABLE_100();
879: a15 := JTF_DATE_TABLE();
880: a16 := JTF_NUMBER_TABLE();

Line 877: a13 := JTF_VARCHAR2_TABLE_100();

873: a9 := JTF_VARCHAR2_TABLE_100();
874: a10 := JTF_VARCHAR2_TABLE_300();
875: a11 := JTF_NUMBER_TABLE();
876: a12 := JTF_VARCHAR2_TABLE_100();
877: a13 := JTF_VARCHAR2_TABLE_100();
878: a14 := JTF_VARCHAR2_TABLE_100();
879: a15 := JTF_DATE_TABLE();
880: a16 := JTF_NUMBER_TABLE();
881: a17 := JTF_NUMBER_TABLE();

Line 878: a14 := JTF_VARCHAR2_TABLE_100();

874: a10 := JTF_VARCHAR2_TABLE_300();
875: a11 := JTF_NUMBER_TABLE();
876: a12 := JTF_VARCHAR2_TABLE_100();
877: a13 := JTF_VARCHAR2_TABLE_100();
878: a14 := JTF_VARCHAR2_TABLE_100();
879: a15 := JTF_DATE_TABLE();
880: a16 := JTF_NUMBER_TABLE();
881: a17 := JTF_NUMBER_TABLE();
882: a18 := JTF_DATE_TABLE();

Line 893: a29 := JTF_VARCHAR2_TABLE_100();

889: a25 := JTF_NUMBER_TABLE();
890: a26 := JTF_NUMBER_TABLE();
891: a27 := JTF_NUMBER_TABLE();
892: a28 := JTF_NUMBER_TABLE();
893: a29 := JTF_VARCHAR2_TABLE_100();
894: a30 := JTF_VARCHAR2_TABLE_100();
895: a31 := JTF_VARCHAR2_TABLE_100();
896: a32 := JTF_VARCHAR2_TABLE_300();
897: a33 := JTF_VARCHAR2_TABLE_100();

Line 894: a30 := JTF_VARCHAR2_TABLE_100();

890: a26 := JTF_NUMBER_TABLE();
891: a27 := JTF_NUMBER_TABLE();
892: a28 := JTF_NUMBER_TABLE();
893: a29 := JTF_VARCHAR2_TABLE_100();
894: a30 := JTF_VARCHAR2_TABLE_100();
895: a31 := JTF_VARCHAR2_TABLE_100();
896: a32 := JTF_VARCHAR2_TABLE_300();
897: a33 := JTF_VARCHAR2_TABLE_100();
898: a34 := JTF_VARCHAR2_TABLE_100();

Line 895: a31 := JTF_VARCHAR2_TABLE_100();

891: a27 := JTF_NUMBER_TABLE();
892: a28 := JTF_NUMBER_TABLE();
893: a29 := JTF_VARCHAR2_TABLE_100();
894: a30 := JTF_VARCHAR2_TABLE_100();
895: a31 := JTF_VARCHAR2_TABLE_100();
896: a32 := JTF_VARCHAR2_TABLE_300();
897: a33 := JTF_VARCHAR2_TABLE_100();
898: a34 := JTF_VARCHAR2_TABLE_100();
899: a35 := JTF_VARCHAR2_TABLE_100();

Line 897: a33 := JTF_VARCHAR2_TABLE_100();

893: a29 := JTF_VARCHAR2_TABLE_100();
894: a30 := JTF_VARCHAR2_TABLE_100();
895: a31 := JTF_VARCHAR2_TABLE_100();
896: a32 := JTF_VARCHAR2_TABLE_300();
897: a33 := JTF_VARCHAR2_TABLE_100();
898: a34 := JTF_VARCHAR2_TABLE_100();
899: a35 := JTF_VARCHAR2_TABLE_100();
900: a36 := JTF_NUMBER_TABLE();
901: a37 := JTF_VARCHAR2_TABLE_300();

Line 898: a34 := JTF_VARCHAR2_TABLE_100();

894: a30 := JTF_VARCHAR2_TABLE_100();
895: a31 := JTF_VARCHAR2_TABLE_100();
896: a32 := JTF_VARCHAR2_TABLE_300();
897: a33 := JTF_VARCHAR2_TABLE_100();
898: a34 := JTF_VARCHAR2_TABLE_100();
899: a35 := JTF_VARCHAR2_TABLE_100();
900: a36 := JTF_NUMBER_TABLE();
901: a37 := JTF_VARCHAR2_TABLE_300();
902: a38 := JTF_NUMBER_TABLE();

Line 899: a35 := JTF_VARCHAR2_TABLE_100();

895: a31 := JTF_VARCHAR2_TABLE_100();
896: a32 := JTF_VARCHAR2_TABLE_300();
897: a33 := JTF_VARCHAR2_TABLE_100();
898: a34 := JTF_VARCHAR2_TABLE_100();
899: a35 := JTF_VARCHAR2_TABLE_100();
900: a36 := JTF_NUMBER_TABLE();
901: a37 := JTF_VARCHAR2_TABLE_300();
902: a38 := JTF_NUMBER_TABLE();
903: a39 := JTF_VARCHAR2_TABLE_100();

Line 903: a39 := JTF_VARCHAR2_TABLE_100();

899: a35 := JTF_VARCHAR2_TABLE_100();
900: a36 := JTF_NUMBER_TABLE();
901: a37 := JTF_VARCHAR2_TABLE_300();
902: a38 := JTF_NUMBER_TABLE();
903: a39 := JTF_VARCHAR2_TABLE_100();
904: a40 := JTF_NUMBER_TABLE();
905: a41 := JTF_VARCHAR2_TABLE_100();
906: a42 := JTF_NUMBER_TABLE();
907: a43 := JTF_NUMBER_TABLE();

Line 905: a41 := JTF_VARCHAR2_TABLE_100();

901: a37 := JTF_VARCHAR2_TABLE_300();
902: a38 := JTF_NUMBER_TABLE();
903: a39 := JTF_VARCHAR2_TABLE_100();
904: a40 := JTF_NUMBER_TABLE();
905: a41 := JTF_VARCHAR2_TABLE_100();
906: a42 := JTF_NUMBER_TABLE();
907: a43 := JTF_NUMBER_TABLE();
908: a44 := JTF_VARCHAR2_TABLE_100();
909: a45 := JTF_NUMBER_TABLE();

Line 908: a44 := JTF_VARCHAR2_TABLE_100();

904: a40 := JTF_NUMBER_TABLE();
905: a41 := JTF_VARCHAR2_TABLE_100();
906: a42 := JTF_NUMBER_TABLE();
907: a43 := JTF_NUMBER_TABLE();
908: a44 := JTF_VARCHAR2_TABLE_100();
909: a45 := JTF_NUMBER_TABLE();
910: a46 := JTF_NUMBER_TABLE();
911: a47 := JTF_NUMBER_TABLE();
912: a48 := JTF_VARCHAR2_TABLE_100();

Line 912: a48 := JTF_VARCHAR2_TABLE_100();

908: a44 := JTF_VARCHAR2_TABLE_100();
909: a45 := JTF_NUMBER_TABLE();
910: a46 := JTF_NUMBER_TABLE();
911: a47 := JTF_NUMBER_TABLE();
912: a48 := JTF_VARCHAR2_TABLE_100();
913: a49 := JTF_NUMBER_TABLE();
914: a50 := JTF_NUMBER_TABLE();
915: a51 := JTF_VARCHAR2_TABLE_100();
916: a52 := JTF_VARCHAR2_TABLE_100();

Line 915: a51 := JTF_VARCHAR2_TABLE_100();

911: a47 := JTF_NUMBER_TABLE();
912: a48 := JTF_VARCHAR2_TABLE_100();
913: a49 := JTF_NUMBER_TABLE();
914: a50 := JTF_NUMBER_TABLE();
915: a51 := JTF_VARCHAR2_TABLE_100();
916: a52 := JTF_VARCHAR2_TABLE_100();
917: a53 := JTF_NUMBER_TABLE();
918: a54 := JTF_NUMBER_TABLE();
919: a55 := JTF_VARCHAR2_TABLE_300();

Line 916: a52 := JTF_VARCHAR2_TABLE_100();

912: a48 := JTF_VARCHAR2_TABLE_100();
913: a49 := JTF_NUMBER_TABLE();
914: a50 := JTF_NUMBER_TABLE();
915: a51 := JTF_VARCHAR2_TABLE_100();
916: a52 := JTF_VARCHAR2_TABLE_100();
917: a53 := JTF_NUMBER_TABLE();
918: a54 := JTF_NUMBER_TABLE();
919: a55 := JTF_VARCHAR2_TABLE_300();
920: a56 := JTF_VARCHAR2_TABLE_100();

Line 920: a56 := JTF_VARCHAR2_TABLE_100();

916: a52 := JTF_VARCHAR2_TABLE_100();
917: a53 := JTF_NUMBER_TABLE();
918: a54 := JTF_NUMBER_TABLE();
919: a55 := JTF_VARCHAR2_TABLE_300();
920: a56 := JTF_VARCHAR2_TABLE_100();
921: a57 := JTF_VARCHAR2_TABLE_100();
922: a58 := JTF_NUMBER_TABLE();
923: a59 := JTF_NUMBER_TABLE();
924: a60 := JTF_NUMBER_TABLE();

Line 921: a57 := JTF_VARCHAR2_TABLE_100();

917: a53 := JTF_NUMBER_TABLE();
918: a54 := JTF_NUMBER_TABLE();
919: a55 := JTF_VARCHAR2_TABLE_300();
920: a56 := JTF_VARCHAR2_TABLE_100();
921: a57 := JTF_VARCHAR2_TABLE_100();
922: a58 := JTF_NUMBER_TABLE();
923: a59 := JTF_NUMBER_TABLE();
924: a60 := JTF_NUMBER_TABLE();
925: a61 := JTF_NUMBER_TABLE();

Line 930: a66 := JTF_VARCHAR2_TABLE_100();

926: a62 := JTF_NUMBER_TABLE();
927: a63 := JTF_NUMBER_TABLE();
928: a64 := JTF_NUMBER_TABLE();
929: a65 := JTF_NUMBER_TABLE();
930: a66 := JTF_VARCHAR2_TABLE_100();
931: a67 := JTF_VARCHAR2_TABLE_100();
932: a68 := JTF_NUMBER_TABLE();
933: a69 := JTF_VARCHAR2_TABLE_100();
934: a70 := JTF_NUMBER_TABLE();

Line 931: a67 := JTF_VARCHAR2_TABLE_100();

927: a63 := JTF_NUMBER_TABLE();
928: a64 := JTF_NUMBER_TABLE();
929: a65 := JTF_NUMBER_TABLE();
930: a66 := JTF_VARCHAR2_TABLE_100();
931: a67 := JTF_VARCHAR2_TABLE_100();
932: a68 := JTF_NUMBER_TABLE();
933: a69 := JTF_VARCHAR2_TABLE_100();
934: a70 := JTF_NUMBER_TABLE();
935: a71 := JTF_NUMBER_TABLE();

Line 933: a69 := JTF_VARCHAR2_TABLE_100();

929: a65 := JTF_NUMBER_TABLE();
930: a66 := JTF_VARCHAR2_TABLE_100();
931: a67 := JTF_VARCHAR2_TABLE_100();
932: a68 := JTF_NUMBER_TABLE();
933: a69 := JTF_VARCHAR2_TABLE_100();
934: a70 := JTF_NUMBER_TABLE();
935: a71 := JTF_NUMBER_TABLE();
936: a72 := JTF_NUMBER_TABLE();
937: a73 := JTF_NUMBER_TABLE();

Line 938: a74 := JTF_VARCHAR2_TABLE_100();

934: a70 := JTF_NUMBER_TABLE();
935: a71 := JTF_NUMBER_TABLE();
936: a72 := JTF_NUMBER_TABLE();
937: a73 := JTF_NUMBER_TABLE();
938: a74 := JTF_VARCHAR2_TABLE_100();
939: a75 := JTF_NUMBER_TABLE();
940: a76 := JTF_NUMBER_TABLE();
941: a77 := JTF_VARCHAR2_TABLE_100();
942: a78 := JTF_VARCHAR2_TABLE_200();

Line 941: a77 := JTF_VARCHAR2_TABLE_100();

937: a73 := JTF_NUMBER_TABLE();
938: a74 := JTF_VARCHAR2_TABLE_100();
939: a75 := JTF_NUMBER_TABLE();
940: a76 := JTF_NUMBER_TABLE();
941: a77 := JTF_VARCHAR2_TABLE_100();
942: a78 := JTF_VARCHAR2_TABLE_200();
943: a79 := JTF_VARCHAR2_TABLE_200();
944: a80 := JTF_VARCHAR2_TABLE_200();
945: a81 := JTF_VARCHAR2_TABLE_200();

Line 962: a98 := JTF_VARCHAR2_TABLE_100();

958: a94 := JTF_NUMBER_TABLE();
959: a95 := JTF_DATE_TABLE();
960: a96 := JTF_NUMBER_TABLE();
961: a97 := JTF_NUMBER_TABLE();
962: a98 := JTF_VARCHAR2_TABLE_100();
963: a99 := JTF_VARCHAR2_TABLE_100();
964: a100 := JTF_VARCHAR2_TABLE_100();
965: if t.count > 0 then
966: a0.extend(t.count);

Line 963: a99 := JTF_VARCHAR2_TABLE_100();

959: a95 := JTF_DATE_TABLE();
960: a96 := JTF_NUMBER_TABLE();
961: a97 := JTF_NUMBER_TABLE();
962: a98 := JTF_VARCHAR2_TABLE_100();
963: a99 := JTF_VARCHAR2_TABLE_100();
964: a100 := JTF_VARCHAR2_TABLE_100();
965: if t.count > 0 then
966: a0.extend(t.count);
967: a1.extend(t.count);

Line 964: a100 := JTF_VARCHAR2_TABLE_100();

960: a96 := JTF_NUMBER_TABLE();
961: a97 := JTF_NUMBER_TABLE();
962: a98 := JTF_VARCHAR2_TABLE_100();
963: a99 := JTF_VARCHAR2_TABLE_100();
964: a100 := JTF_VARCHAR2_TABLE_100();
965: if t.count > 0 then
966: a0.extend(t.count);
967: a1.extend(t.count);
968: a2.extend(t.count);

Line 1188: , a7 JTF_VARCHAR2_TABLE_100

1184: , a3 JTF_NUMBER_TABLE
1185: , a4 JTF_NUMBER_TABLE
1186: , a5 JTF_NUMBER_TABLE
1187: , a6 JTF_NUMBER_TABLE
1188: , a7 JTF_VARCHAR2_TABLE_100
1189: ) as
1190: ddindx binary_integer; indx binary_integer;
1191: begin
1192: if a0 is not null and a0.count > 0 then

Line 1221: , a7 out nocopy JTF_VARCHAR2_TABLE_100

1217: , a3 out nocopy JTF_NUMBER_TABLE
1218: , a4 out nocopy JTF_NUMBER_TABLE
1219: , a5 out nocopy JTF_NUMBER_TABLE
1220: , a6 out nocopy JTF_NUMBER_TABLE
1221: , a7 out nocopy JTF_VARCHAR2_TABLE_100
1222: ) as
1223: ddindx binary_integer; indx binary_integer;
1224: begin
1225: if t is null or t.count = 0 then

Line 1233: a7 := JTF_VARCHAR2_TABLE_100();

1229: a3 := JTF_NUMBER_TABLE();
1230: a4 := JTF_NUMBER_TABLE();
1231: a5 := JTF_NUMBER_TABLE();
1232: a6 := JTF_NUMBER_TABLE();
1233: a7 := JTF_VARCHAR2_TABLE_100();
1234: else
1235: a0 := JTF_NUMBER_TABLE();
1236: a1 := JTF_NUMBER_TABLE();
1237: a2 := JTF_NUMBER_TABLE();

Line 1242: a7 := JTF_VARCHAR2_TABLE_100();

1238: a3 := JTF_NUMBER_TABLE();
1239: a4 := JTF_NUMBER_TABLE();
1240: a5 := JTF_NUMBER_TABLE();
1241: a6 := JTF_NUMBER_TABLE();
1242: a7 := JTF_VARCHAR2_TABLE_100();
1243: if t.count > 0 then
1244: a0.extend(t.count);
1245: a1.extend(t.count);
1246: a2.extend(t.count);

Line 1275: , a2 JTF_VARCHAR2_TABLE_100

1271: end rosetta_table_copy_out_p5;
1272:
1273: procedure rosetta_table_copy_in_p13(t out nocopy ahl_prd_workorder_pvt.turnover_notes_tbl_type, a0 JTF_NUMBER_TABLE
1274: , a1 JTF_NUMBER_TABLE
1275: , a2 JTF_VARCHAR2_TABLE_100
1276: , a3 JTF_VARCHAR2_TABLE_2000
1277: , a4 JTF_NUMBER_TABLE
1278: , a5 JTF_VARCHAR2_TABLE_300
1279: , a6 JTF_DATE_TABLE

Line 1308: , a2 out nocopy JTF_VARCHAR2_TABLE_100

1304: end if;
1305: end rosetta_table_copy_in_p13;
1306: procedure rosetta_table_copy_out_p13(t ahl_prd_workorder_pvt.turnover_notes_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
1307: , a1 out nocopy JTF_NUMBER_TABLE
1308: , a2 out nocopy JTF_VARCHAR2_TABLE_100
1309: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
1310: , a4 out nocopy JTF_NUMBER_TABLE
1311: , a5 out nocopy JTF_VARCHAR2_TABLE_300
1312: , a6 out nocopy JTF_DATE_TABLE

Line 1320: a2 := JTF_VARCHAR2_TABLE_100();

1316: begin
1317: if t is null or t.count = 0 then
1318: a0 := JTF_NUMBER_TABLE();
1319: a1 := JTF_NUMBER_TABLE();
1320: a2 := JTF_VARCHAR2_TABLE_100();
1321: a3 := JTF_VARCHAR2_TABLE_2000();
1322: a4 := JTF_NUMBER_TABLE();
1323: a5 := JTF_VARCHAR2_TABLE_300();
1324: a6 := JTF_DATE_TABLE();

Line 1329: a2 := JTF_VARCHAR2_TABLE_100();

1325: a7 := JTF_NUMBER_TABLE();
1326: else
1327: a0 := JTF_NUMBER_TABLE();
1328: a1 := JTF_NUMBER_TABLE();
1329: a2 := JTF_VARCHAR2_TABLE_100();
1330: a3 := JTF_VARCHAR2_TABLE_2000();
1331: a4 := JTF_NUMBER_TABLE();
1332: a5 := JTF_VARCHAR2_TABLE_300();
1333: a6 := JTF_DATE_TABLE();

Line 1379: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100

1375: , p9_a1 in out nocopy JTF_NUMBER_TABLE
1376: , p9_a2 in out nocopy JTF_NUMBER_TABLE
1377: , p9_a3 in out nocopy JTF_NUMBER_TABLE
1378: , p9_a4 in out nocopy JTF_NUMBER_TABLE
1379: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1380: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
1381: , p9_a7 in out nocopy JTF_NUMBER_TABLE
1382: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
1383: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1382: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100

1378: , p9_a4 in out nocopy JTF_NUMBER_TABLE
1379: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1380: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
1381: , p9_a7 in out nocopy JTF_NUMBER_TABLE
1382: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
1383: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
1384: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_300
1385: , p9_a11 in out nocopy JTF_NUMBER_TABLE
1386: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1383: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100

1379: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1380: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_300
1381: , p9_a7 in out nocopy JTF_NUMBER_TABLE
1382: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
1383: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
1384: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_300
1385: , p9_a11 in out nocopy JTF_NUMBER_TABLE
1386: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1387: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1386: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100

1382: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
1383: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
1384: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_300
1385: , p9_a11 in out nocopy JTF_NUMBER_TABLE
1386: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1387: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
1388: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1389: , p9_a15 in out nocopy JTF_DATE_TABLE
1390: , p9_a16 in out nocopy JTF_NUMBER_TABLE

Line 1387: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100

1383: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
1384: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_300
1385: , p9_a11 in out nocopy JTF_NUMBER_TABLE
1386: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1387: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
1388: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1389: , p9_a15 in out nocopy JTF_DATE_TABLE
1390: , p9_a16 in out nocopy JTF_NUMBER_TABLE
1391: , p9_a17 in out nocopy JTF_NUMBER_TABLE

Line 1388: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100

1384: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_300
1385: , p9_a11 in out nocopy JTF_NUMBER_TABLE
1386: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_100
1387: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_100
1388: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_100
1389: , p9_a15 in out nocopy JTF_DATE_TABLE
1390: , p9_a16 in out nocopy JTF_NUMBER_TABLE
1391: , p9_a17 in out nocopy JTF_NUMBER_TABLE
1392: , p9_a18 in out nocopy JTF_DATE_TABLE

Line 1403: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100

1399: , p9_a25 in out nocopy JTF_NUMBER_TABLE
1400: , p9_a26 in out nocopy JTF_NUMBER_TABLE
1401: , p9_a27 in out nocopy JTF_NUMBER_TABLE
1402: , p9_a28 in out nocopy JTF_NUMBER_TABLE
1403: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
1404: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
1405: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
1406: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_300
1407: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1404: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100

1400: , p9_a26 in out nocopy JTF_NUMBER_TABLE
1401: , p9_a27 in out nocopy JTF_NUMBER_TABLE
1402: , p9_a28 in out nocopy JTF_NUMBER_TABLE
1403: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
1404: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
1405: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
1406: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_300
1407: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100
1408: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1405: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100

1401: , p9_a27 in out nocopy JTF_NUMBER_TABLE
1402: , p9_a28 in out nocopy JTF_NUMBER_TABLE
1403: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
1404: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
1405: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
1406: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_300
1407: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100
1408: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
1409: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1407: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100

1403: , p9_a29 in out nocopy JTF_VARCHAR2_TABLE_100
1404: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
1405: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
1406: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_300
1407: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100
1408: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
1409: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
1410: , p9_a36 in out nocopy JTF_NUMBER_TABLE
1411: , p9_a37 in out nocopy JTF_VARCHAR2_TABLE_300

Line 1408: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100

1404: , p9_a30 in out nocopy JTF_VARCHAR2_TABLE_100
1405: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
1406: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_300
1407: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100
1408: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
1409: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
1410: , p9_a36 in out nocopy JTF_NUMBER_TABLE
1411: , p9_a37 in out nocopy JTF_VARCHAR2_TABLE_300
1412: , p9_a38 in out nocopy JTF_NUMBER_TABLE

Line 1409: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100

1405: , p9_a31 in out nocopy JTF_VARCHAR2_TABLE_100
1406: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_300
1407: , p9_a33 in out nocopy JTF_VARCHAR2_TABLE_100
1408: , p9_a34 in out nocopy JTF_VARCHAR2_TABLE_100
1409: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
1410: , p9_a36 in out nocopy JTF_NUMBER_TABLE
1411: , p9_a37 in out nocopy JTF_VARCHAR2_TABLE_300
1412: , p9_a38 in out nocopy JTF_NUMBER_TABLE
1413: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1413: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100

1409: , p9_a35 in out nocopy JTF_VARCHAR2_TABLE_100
1410: , p9_a36 in out nocopy JTF_NUMBER_TABLE
1411: , p9_a37 in out nocopy JTF_VARCHAR2_TABLE_300
1412: , p9_a38 in out nocopy JTF_NUMBER_TABLE
1413: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100
1414: , p9_a40 in out nocopy JTF_NUMBER_TABLE
1415: , p9_a41 in out nocopy JTF_VARCHAR2_TABLE_100
1416: , p9_a42 in out nocopy JTF_NUMBER_TABLE
1417: , p9_a43 in out nocopy JTF_NUMBER_TABLE

Line 1415: , p9_a41 in out nocopy JTF_VARCHAR2_TABLE_100

1411: , p9_a37 in out nocopy JTF_VARCHAR2_TABLE_300
1412: , p9_a38 in out nocopy JTF_NUMBER_TABLE
1413: , p9_a39 in out nocopy JTF_VARCHAR2_TABLE_100
1414: , p9_a40 in out nocopy JTF_NUMBER_TABLE
1415: , p9_a41 in out nocopy JTF_VARCHAR2_TABLE_100
1416: , p9_a42 in out nocopy JTF_NUMBER_TABLE
1417: , p9_a43 in out nocopy JTF_NUMBER_TABLE
1418: , p9_a44 in out nocopy JTF_VARCHAR2_TABLE_100
1419: , p9_a45 in out nocopy JTF_NUMBER_TABLE

Line 1418: , p9_a44 in out nocopy JTF_VARCHAR2_TABLE_100

1414: , p9_a40 in out nocopy JTF_NUMBER_TABLE
1415: , p9_a41 in out nocopy JTF_VARCHAR2_TABLE_100
1416: , p9_a42 in out nocopy JTF_NUMBER_TABLE
1417: , p9_a43 in out nocopy JTF_NUMBER_TABLE
1418: , p9_a44 in out nocopy JTF_VARCHAR2_TABLE_100
1419: , p9_a45 in out nocopy JTF_NUMBER_TABLE
1420: , p9_a46 in out nocopy JTF_NUMBER_TABLE
1421: , p9_a47 in out nocopy JTF_NUMBER_TABLE
1422: , p9_a48 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1422: , p9_a48 in out nocopy JTF_VARCHAR2_TABLE_100

1418: , p9_a44 in out nocopy JTF_VARCHAR2_TABLE_100
1419: , p9_a45 in out nocopy JTF_NUMBER_TABLE
1420: , p9_a46 in out nocopy JTF_NUMBER_TABLE
1421: , p9_a47 in out nocopy JTF_NUMBER_TABLE
1422: , p9_a48 in out nocopy JTF_VARCHAR2_TABLE_100
1423: , p9_a49 in out nocopy JTF_NUMBER_TABLE
1424: , p9_a50 in out nocopy JTF_NUMBER_TABLE
1425: , p9_a51 in out nocopy JTF_VARCHAR2_TABLE_100
1426: , p9_a52 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1425: , p9_a51 in out nocopy JTF_VARCHAR2_TABLE_100

1421: , p9_a47 in out nocopy JTF_NUMBER_TABLE
1422: , p9_a48 in out nocopy JTF_VARCHAR2_TABLE_100
1423: , p9_a49 in out nocopy JTF_NUMBER_TABLE
1424: , p9_a50 in out nocopy JTF_NUMBER_TABLE
1425: , p9_a51 in out nocopy JTF_VARCHAR2_TABLE_100
1426: , p9_a52 in out nocopy JTF_VARCHAR2_TABLE_100
1427: , p9_a53 in out nocopy JTF_NUMBER_TABLE
1428: , p9_a54 in out nocopy JTF_NUMBER_TABLE
1429: , p9_a55 in out nocopy JTF_VARCHAR2_TABLE_300

Line 1426: , p9_a52 in out nocopy JTF_VARCHAR2_TABLE_100

1422: , p9_a48 in out nocopy JTF_VARCHAR2_TABLE_100
1423: , p9_a49 in out nocopy JTF_NUMBER_TABLE
1424: , p9_a50 in out nocopy JTF_NUMBER_TABLE
1425: , p9_a51 in out nocopy JTF_VARCHAR2_TABLE_100
1426: , p9_a52 in out nocopy JTF_VARCHAR2_TABLE_100
1427: , p9_a53 in out nocopy JTF_NUMBER_TABLE
1428: , p9_a54 in out nocopy JTF_NUMBER_TABLE
1429: , p9_a55 in out nocopy JTF_VARCHAR2_TABLE_300
1430: , p9_a56 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1430: , p9_a56 in out nocopy JTF_VARCHAR2_TABLE_100

1426: , p9_a52 in out nocopy JTF_VARCHAR2_TABLE_100
1427: , p9_a53 in out nocopy JTF_NUMBER_TABLE
1428: , p9_a54 in out nocopy JTF_NUMBER_TABLE
1429: , p9_a55 in out nocopy JTF_VARCHAR2_TABLE_300
1430: , p9_a56 in out nocopy JTF_VARCHAR2_TABLE_100
1431: , p9_a57 in out nocopy JTF_VARCHAR2_TABLE_100
1432: , p9_a58 in out nocopy JTF_NUMBER_TABLE
1433: , p9_a59 in out nocopy JTF_NUMBER_TABLE
1434: , p9_a60 in out nocopy JTF_NUMBER_TABLE

Line 1431: , p9_a57 in out nocopy JTF_VARCHAR2_TABLE_100

1427: , p9_a53 in out nocopy JTF_NUMBER_TABLE
1428: , p9_a54 in out nocopy JTF_NUMBER_TABLE
1429: , p9_a55 in out nocopy JTF_VARCHAR2_TABLE_300
1430: , p9_a56 in out nocopy JTF_VARCHAR2_TABLE_100
1431: , p9_a57 in out nocopy JTF_VARCHAR2_TABLE_100
1432: , p9_a58 in out nocopy JTF_NUMBER_TABLE
1433: , p9_a59 in out nocopy JTF_NUMBER_TABLE
1434: , p9_a60 in out nocopy JTF_NUMBER_TABLE
1435: , p9_a61 in out nocopy JTF_NUMBER_TABLE

Line 1440: , p9_a66 in out nocopy JTF_VARCHAR2_TABLE_100

1436: , p9_a62 in out nocopy JTF_NUMBER_TABLE
1437: , p9_a63 in out nocopy JTF_NUMBER_TABLE
1438: , p9_a64 in out nocopy JTF_NUMBER_TABLE
1439: , p9_a65 in out nocopy JTF_NUMBER_TABLE
1440: , p9_a66 in out nocopy JTF_VARCHAR2_TABLE_100
1441: , p9_a67 in out nocopy JTF_VARCHAR2_TABLE_100
1442: , p9_a68 in out nocopy JTF_NUMBER_TABLE
1443: , p9_a69 in out nocopy JTF_VARCHAR2_TABLE_100
1444: , p9_a70 in out nocopy JTF_NUMBER_TABLE

Line 1441: , p9_a67 in out nocopy JTF_VARCHAR2_TABLE_100

1437: , p9_a63 in out nocopy JTF_NUMBER_TABLE
1438: , p9_a64 in out nocopy JTF_NUMBER_TABLE
1439: , p9_a65 in out nocopy JTF_NUMBER_TABLE
1440: , p9_a66 in out nocopy JTF_VARCHAR2_TABLE_100
1441: , p9_a67 in out nocopy JTF_VARCHAR2_TABLE_100
1442: , p9_a68 in out nocopy JTF_NUMBER_TABLE
1443: , p9_a69 in out nocopy JTF_VARCHAR2_TABLE_100
1444: , p9_a70 in out nocopy JTF_NUMBER_TABLE
1445: , p9_a71 in out nocopy JTF_NUMBER_TABLE

Line 1443: , p9_a69 in out nocopy JTF_VARCHAR2_TABLE_100

1439: , p9_a65 in out nocopy JTF_NUMBER_TABLE
1440: , p9_a66 in out nocopy JTF_VARCHAR2_TABLE_100
1441: , p9_a67 in out nocopy JTF_VARCHAR2_TABLE_100
1442: , p9_a68 in out nocopy JTF_NUMBER_TABLE
1443: , p9_a69 in out nocopy JTF_VARCHAR2_TABLE_100
1444: , p9_a70 in out nocopy JTF_NUMBER_TABLE
1445: , p9_a71 in out nocopy JTF_NUMBER_TABLE
1446: , p9_a72 in out nocopy JTF_NUMBER_TABLE
1447: , p9_a73 in out nocopy JTF_NUMBER_TABLE

Line 1448: , p9_a74 in out nocopy JTF_VARCHAR2_TABLE_100

1444: , p9_a70 in out nocopy JTF_NUMBER_TABLE
1445: , p9_a71 in out nocopy JTF_NUMBER_TABLE
1446: , p9_a72 in out nocopy JTF_NUMBER_TABLE
1447: , p9_a73 in out nocopy JTF_NUMBER_TABLE
1448: , p9_a74 in out nocopy JTF_VARCHAR2_TABLE_100
1449: , p9_a75 in out nocopy JTF_NUMBER_TABLE
1450: , p9_a76 in out nocopy JTF_NUMBER_TABLE
1451: , p9_a77 in out nocopy JTF_VARCHAR2_TABLE_100
1452: , p9_a78 in out nocopy JTF_VARCHAR2_TABLE_200

Line 1451: , p9_a77 in out nocopy JTF_VARCHAR2_TABLE_100

1447: , p9_a73 in out nocopy JTF_NUMBER_TABLE
1448: , p9_a74 in out nocopy JTF_VARCHAR2_TABLE_100
1449: , p9_a75 in out nocopy JTF_NUMBER_TABLE
1450: , p9_a76 in out nocopy JTF_NUMBER_TABLE
1451: , p9_a77 in out nocopy JTF_VARCHAR2_TABLE_100
1452: , p9_a78 in out nocopy JTF_VARCHAR2_TABLE_200
1453: , p9_a79 in out nocopy JTF_VARCHAR2_TABLE_200
1454: , p9_a80 in out nocopy JTF_VARCHAR2_TABLE_200
1455: , p9_a81 in out nocopy JTF_VARCHAR2_TABLE_200

Line 1472: , p9_a98 in out nocopy JTF_VARCHAR2_TABLE_100

1468: , p9_a94 in out nocopy JTF_NUMBER_TABLE
1469: , p9_a95 in out nocopy JTF_DATE_TABLE
1470: , p9_a96 in out nocopy JTF_NUMBER_TABLE
1471: , p9_a97 in out nocopy JTF_NUMBER_TABLE
1472: , p9_a98 in out nocopy JTF_VARCHAR2_TABLE_100
1473: , p9_a99 in out nocopy JTF_VARCHAR2_TABLE_100
1474: , p9_a100 in out nocopy JTF_VARCHAR2_TABLE_100
1475: , p10_a0 JTF_NUMBER_TABLE
1476: , p10_a1 JTF_NUMBER_TABLE

Line 1473: , p9_a99 in out nocopy JTF_VARCHAR2_TABLE_100

1469: , p9_a95 in out nocopy JTF_DATE_TABLE
1470: , p9_a96 in out nocopy JTF_NUMBER_TABLE
1471: , p9_a97 in out nocopy JTF_NUMBER_TABLE
1472: , p9_a98 in out nocopy JTF_VARCHAR2_TABLE_100
1473: , p9_a99 in out nocopy JTF_VARCHAR2_TABLE_100
1474: , p9_a100 in out nocopy JTF_VARCHAR2_TABLE_100
1475: , p10_a0 JTF_NUMBER_TABLE
1476: , p10_a1 JTF_NUMBER_TABLE
1477: , p10_a2 JTF_NUMBER_TABLE

Line 1474: , p9_a100 in out nocopy JTF_VARCHAR2_TABLE_100

1470: , p9_a96 in out nocopy JTF_NUMBER_TABLE
1471: , p9_a97 in out nocopy JTF_NUMBER_TABLE
1472: , p9_a98 in out nocopy JTF_VARCHAR2_TABLE_100
1473: , p9_a99 in out nocopy JTF_VARCHAR2_TABLE_100
1474: , p9_a100 in out nocopy JTF_VARCHAR2_TABLE_100
1475: , p10_a0 JTF_NUMBER_TABLE
1476: , p10_a1 JTF_NUMBER_TABLE
1477: , p10_a2 JTF_NUMBER_TABLE
1478: , p10_a3 JTF_NUMBER_TABLE

Line 1482: , p10_a7 JTF_VARCHAR2_TABLE_100

1478: , p10_a3 JTF_NUMBER_TABLE
1479: , p10_a4 JTF_NUMBER_TABLE
1480: , p10_a5 JTF_NUMBER_TABLE
1481: , p10_a6 JTF_NUMBER_TABLE
1482: , p10_a7 JTF_VARCHAR2_TABLE_100
1483: )
1484:
1485: as
1486: ddp_x_prd_workorder_tbl ahl_prd_workorder_pvt.prd_workorder_tbl;

Line 1868: , p11_a15 in out nocopy JTF_VARCHAR2_TABLE_100

1864: , p11_a11 in out nocopy JTF_NUMBER_TABLE
1865: , p11_a12 in out nocopy JTF_NUMBER_TABLE
1866: , p11_a13 in out nocopy JTF_NUMBER_TABLE
1867: , p11_a14 in out nocopy JTF_VARCHAR2_TABLE_300
1868: , p11_a15 in out nocopy JTF_VARCHAR2_TABLE_100
1869: , p11_a16 in out nocopy JTF_VARCHAR2_TABLE_100
1870: , p11_a17 in out nocopy JTF_NUMBER_TABLE
1871: , p11_a18 in out nocopy JTF_VARCHAR2_TABLE_500
1872: , p11_a19 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1869: , p11_a16 in out nocopy JTF_VARCHAR2_TABLE_100

1865: , p11_a12 in out nocopy JTF_NUMBER_TABLE
1866: , p11_a13 in out nocopy JTF_NUMBER_TABLE
1867: , p11_a14 in out nocopy JTF_VARCHAR2_TABLE_300
1868: , p11_a15 in out nocopy JTF_VARCHAR2_TABLE_100
1869: , p11_a16 in out nocopy JTF_VARCHAR2_TABLE_100
1870: , p11_a17 in out nocopy JTF_NUMBER_TABLE
1871: , p11_a18 in out nocopy JTF_VARCHAR2_TABLE_500
1872: , p11_a19 in out nocopy JTF_VARCHAR2_TABLE_100
1873: , p11_a20 in out nocopy JTF_VARCHAR2_TABLE_100

Line 1872: , p11_a19 in out nocopy JTF_VARCHAR2_TABLE_100

1868: , p11_a15 in out nocopy JTF_VARCHAR2_TABLE_100
1869: , p11_a16 in out nocopy JTF_VARCHAR2_TABLE_100
1870: , p11_a17 in out nocopy JTF_NUMBER_TABLE
1871: , p11_a18 in out nocopy JTF_VARCHAR2_TABLE_500
1872: , p11_a19 in out nocopy JTF_VARCHAR2_TABLE_100
1873: , p11_a20 in out nocopy JTF_VARCHAR2_TABLE_100
1874: , p11_a21 in out nocopy JTF_VARCHAR2_TABLE_100
1875: , p11_a22 in out nocopy JTF_NUMBER_TABLE
1876: , p11_a23 in out nocopy JTF_NUMBER_TABLE

Line 1873: , p11_a20 in out nocopy JTF_VARCHAR2_TABLE_100

1869: , p11_a16 in out nocopy JTF_VARCHAR2_TABLE_100
1870: , p11_a17 in out nocopy JTF_NUMBER_TABLE
1871: , p11_a18 in out nocopy JTF_VARCHAR2_TABLE_500
1872: , p11_a19 in out nocopy JTF_VARCHAR2_TABLE_100
1873: , p11_a20 in out nocopy JTF_VARCHAR2_TABLE_100
1874: , p11_a21 in out nocopy JTF_VARCHAR2_TABLE_100
1875: , p11_a22 in out nocopy JTF_NUMBER_TABLE
1876: , p11_a23 in out nocopy JTF_NUMBER_TABLE
1877: , p11_a24 in out nocopy JTF_DATE_TABLE

Line 1874: , p11_a21 in out nocopy JTF_VARCHAR2_TABLE_100

1870: , p11_a17 in out nocopy JTF_NUMBER_TABLE
1871: , p11_a18 in out nocopy JTF_VARCHAR2_TABLE_500
1872: , p11_a19 in out nocopy JTF_VARCHAR2_TABLE_100
1873: , p11_a20 in out nocopy JTF_VARCHAR2_TABLE_100
1874: , p11_a21 in out nocopy JTF_VARCHAR2_TABLE_100
1875: , p11_a22 in out nocopy JTF_NUMBER_TABLE
1876: , p11_a23 in out nocopy JTF_NUMBER_TABLE
1877: , p11_a24 in out nocopy JTF_DATE_TABLE
1878: , p11_a25 in out nocopy JTF_NUMBER_TABLE

Line 1891: , p11_a38 in out nocopy JTF_VARCHAR2_TABLE_100

1887: , p11_a34 in out nocopy JTF_NUMBER_TABLE
1888: , p11_a35 in out nocopy JTF_NUMBER_TABLE
1889: , p11_a36 in out nocopy JTF_NUMBER_TABLE
1890: , p11_a37 in out nocopy JTF_NUMBER_TABLE
1891: , p11_a38 in out nocopy JTF_VARCHAR2_TABLE_100
1892: , p11_a39 in out nocopy JTF_NUMBER_TABLE
1893: , p11_a40 in out nocopy JTF_VARCHAR2_TABLE_100
1894: , p11_a41 in out nocopy JTF_VARCHAR2_TABLE_200
1895: , p11_a42 in out nocopy JTF_VARCHAR2_TABLE_200

Line 1893: , p11_a40 in out nocopy JTF_VARCHAR2_TABLE_100

1889: , p11_a36 in out nocopy JTF_NUMBER_TABLE
1890: , p11_a37 in out nocopy JTF_NUMBER_TABLE
1891: , p11_a38 in out nocopy JTF_VARCHAR2_TABLE_100
1892: , p11_a39 in out nocopy JTF_NUMBER_TABLE
1893: , p11_a40 in out nocopy JTF_VARCHAR2_TABLE_100
1894: , p11_a41 in out nocopy JTF_VARCHAR2_TABLE_200
1895: , p11_a42 in out nocopy JTF_VARCHAR2_TABLE_200
1896: , p11_a43 in out nocopy JTF_VARCHAR2_TABLE_200
1897: , p11_a44 in out nocopy JTF_VARCHAR2_TABLE_200

Line 1909: , p11_a56 in out nocopy JTF_VARCHAR2_TABLE_100

1905: , p11_a52 in out nocopy JTF_VARCHAR2_TABLE_200
1906: , p11_a53 in out nocopy JTF_VARCHAR2_TABLE_200
1907: , p11_a54 in out nocopy JTF_VARCHAR2_TABLE_200
1908: , p11_a55 in out nocopy JTF_VARCHAR2_TABLE_200
1909: , p11_a56 in out nocopy JTF_VARCHAR2_TABLE_100
1910: )
1911:
1912: as
1913: ddp_x_prd_workorder_rec ahl_prd_workorder_pvt.prd_workorder_rec;

Line 2288: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100

2284: , x_msg_count out nocopy NUMBER
2285: , x_msg_data out nocopy VARCHAR2
2286: , p9_a0 in out nocopy JTF_NUMBER_TABLE
2287: , p9_a1 in out nocopy JTF_NUMBER_TABLE
2288: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
2289: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
2290: , p9_a4 in out nocopy JTF_NUMBER_TABLE
2291: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_300
2292: , p9_a6 in out nocopy JTF_DATE_TABLE