DBA Data[Home] [Help]

APPS.OKL_PAM_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: OKLIPAMB.pls 120.0 2005/07/07 10:40:11 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_pam_pvt.okl_pamv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_DATE_TABLE

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p1(t out nocopy okl_pam_pvt.okl_pamv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE

Line 9: , a6 JTF_VARCHAR2_TABLE_100

5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_500

Line 12: , a9 JTF_VARCHAR2_TABLE_100

8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_500
14: , a11 JTF_VARCHAR2_TABLE_500
15: , a12 JTF_VARCHAR2_TABLE_500
16: , a13 JTF_VARCHAR2_TABLE_500

Line 87: , a3 out nocopy JTF_VARCHAR2_TABLE_100

83: end rosetta_table_copy_in_p1;
84: procedure rosetta_table_copy_out_p1(t okl_pam_pvt.okl_pamv_tbl, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_NUMBER_TABLE
86: , a2 out nocopy JTF_NUMBER_TABLE
87: , a3 out nocopy JTF_VARCHAR2_TABLE_100
88: , a4 out nocopy JTF_VARCHAR2_TABLE_100
89: , a5 out nocopy JTF_NUMBER_TABLE
90: , a6 out nocopy JTF_VARCHAR2_TABLE_100
91: , a7 out nocopy JTF_DATE_TABLE

Line 88: , a4 out nocopy JTF_VARCHAR2_TABLE_100

84: procedure rosetta_table_copy_out_p1(t okl_pam_pvt.okl_pamv_tbl, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_NUMBER_TABLE
86: , a2 out nocopy JTF_NUMBER_TABLE
87: , a3 out nocopy JTF_VARCHAR2_TABLE_100
88: , a4 out nocopy JTF_VARCHAR2_TABLE_100
89: , a5 out nocopy JTF_NUMBER_TABLE
90: , a6 out nocopy JTF_VARCHAR2_TABLE_100
91: , a7 out nocopy JTF_DATE_TABLE
92: , a8 out nocopy JTF_DATE_TABLE

Line 90: , a6 out nocopy JTF_VARCHAR2_TABLE_100

86: , a2 out nocopy JTF_NUMBER_TABLE
87: , a3 out nocopy JTF_VARCHAR2_TABLE_100
88: , a4 out nocopy JTF_VARCHAR2_TABLE_100
89: , a5 out nocopy JTF_NUMBER_TABLE
90: , a6 out nocopy JTF_VARCHAR2_TABLE_100
91: , a7 out nocopy JTF_DATE_TABLE
92: , a8 out nocopy JTF_DATE_TABLE
93: , a9 out nocopy JTF_VARCHAR2_TABLE_100
94: , a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 93: , a9 out nocopy JTF_VARCHAR2_TABLE_100

89: , a5 out nocopy JTF_NUMBER_TABLE
90: , a6 out nocopy JTF_VARCHAR2_TABLE_100
91: , a7 out nocopy JTF_DATE_TABLE
92: , a8 out nocopy JTF_DATE_TABLE
93: , a9 out nocopy JTF_VARCHAR2_TABLE_100
94: , a10 out nocopy JTF_VARCHAR2_TABLE_500
95: , a11 out nocopy JTF_VARCHAR2_TABLE_500
96: , a12 out nocopy JTF_VARCHAR2_TABLE_500
97: , a13 out nocopy JTF_VARCHAR2_TABLE_500

Line 123: a3 := JTF_VARCHAR2_TABLE_100();

119: if t is null or t.count = 0 then
120: a0 := JTF_NUMBER_TABLE();
121: a1 := JTF_NUMBER_TABLE();
122: a2 := JTF_NUMBER_TABLE();
123: a3 := JTF_VARCHAR2_TABLE_100();
124: a4 := JTF_VARCHAR2_TABLE_100();
125: a5 := JTF_NUMBER_TABLE();
126: a6 := JTF_VARCHAR2_TABLE_100();
127: a7 := JTF_DATE_TABLE();

Line 124: a4 := JTF_VARCHAR2_TABLE_100();

120: a0 := JTF_NUMBER_TABLE();
121: a1 := JTF_NUMBER_TABLE();
122: a2 := JTF_NUMBER_TABLE();
123: a3 := JTF_VARCHAR2_TABLE_100();
124: a4 := JTF_VARCHAR2_TABLE_100();
125: a5 := JTF_NUMBER_TABLE();
126: a6 := JTF_VARCHAR2_TABLE_100();
127: a7 := JTF_DATE_TABLE();
128: a8 := JTF_DATE_TABLE();

Line 126: a6 := JTF_VARCHAR2_TABLE_100();

122: a2 := JTF_NUMBER_TABLE();
123: a3 := JTF_VARCHAR2_TABLE_100();
124: a4 := JTF_VARCHAR2_TABLE_100();
125: a5 := JTF_NUMBER_TABLE();
126: a6 := JTF_VARCHAR2_TABLE_100();
127: a7 := JTF_DATE_TABLE();
128: a8 := JTF_DATE_TABLE();
129: a9 := JTF_VARCHAR2_TABLE_100();
130: a10 := JTF_VARCHAR2_TABLE_500();

Line 129: a9 := JTF_VARCHAR2_TABLE_100();

125: a5 := JTF_NUMBER_TABLE();
126: a6 := JTF_VARCHAR2_TABLE_100();
127: a7 := JTF_DATE_TABLE();
128: a8 := JTF_DATE_TABLE();
129: a9 := JTF_VARCHAR2_TABLE_100();
130: a10 := JTF_VARCHAR2_TABLE_500();
131: a11 := JTF_VARCHAR2_TABLE_500();
132: a12 := JTF_VARCHAR2_TABLE_500();
133: a13 := JTF_VARCHAR2_TABLE_500();

Line 156: a3 := JTF_VARCHAR2_TABLE_100();

152: else
153: a0 := JTF_NUMBER_TABLE();
154: a1 := JTF_NUMBER_TABLE();
155: a2 := JTF_NUMBER_TABLE();
156: a3 := JTF_VARCHAR2_TABLE_100();
157: a4 := JTF_VARCHAR2_TABLE_100();
158: a5 := JTF_NUMBER_TABLE();
159: a6 := JTF_VARCHAR2_TABLE_100();
160: a7 := JTF_DATE_TABLE();

Line 157: a4 := JTF_VARCHAR2_TABLE_100();

153: a0 := JTF_NUMBER_TABLE();
154: a1 := JTF_NUMBER_TABLE();
155: a2 := JTF_NUMBER_TABLE();
156: a3 := JTF_VARCHAR2_TABLE_100();
157: a4 := JTF_VARCHAR2_TABLE_100();
158: a5 := JTF_NUMBER_TABLE();
159: a6 := JTF_VARCHAR2_TABLE_100();
160: a7 := JTF_DATE_TABLE();
161: a8 := JTF_DATE_TABLE();

Line 159: a6 := JTF_VARCHAR2_TABLE_100();

155: a2 := JTF_NUMBER_TABLE();
156: a3 := JTF_VARCHAR2_TABLE_100();
157: a4 := JTF_VARCHAR2_TABLE_100();
158: a5 := JTF_NUMBER_TABLE();
159: a6 := JTF_VARCHAR2_TABLE_100();
160: a7 := JTF_DATE_TABLE();
161: a8 := JTF_DATE_TABLE();
162: a9 := JTF_VARCHAR2_TABLE_100();
163: a10 := JTF_VARCHAR2_TABLE_500();

Line 162: a9 := JTF_VARCHAR2_TABLE_100();

158: a5 := JTF_NUMBER_TABLE();
159: a6 := JTF_VARCHAR2_TABLE_100();
160: a7 := JTF_DATE_TABLE();
161: a8 := JTF_DATE_TABLE();
162: a9 := JTF_VARCHAR2_TABLE_100();
163: a10 := JTF_VARCHAR2_TABLE_500();
164: a11 := JTF_VARCHAR2_TABLE_500();
165: a12 := JTF_VARCHAR2_TABLE_500();
166: a13 := JTF_VARCHAR2_TABLE_500();

Line 267: , a4 JTF_VARCHAR2_TABLE_100

263: procedure rosetta_table_copy_in_p3(t out nocopy okl_pam_pvt.okl_pamb_tbl, a0 JTF_NUMBER_TABLE
264: , a1 JTF_VARCHAR2_TABLE_300
265: , a2 JTF_NUMBER_TABLE
266: , a3 JTF_NUMBER_TABLE
267: , a4 JTF_VARCHAR2_TABLE_100
268: , a5 JTF_VARCHAR2_TABLE_100
269: , a6 JTF_NUMBER_TABLE
270: , a7 JTF_VARCHAR2_TABLE_100
271: , a8 JTF_DATE_TABLE

Line 268: , a5 JTF_VARCHAR2_TABLE_100

264: , a1 JTF_VARCHAR2_TABLE_300
265: , a2 JTF_NUMBER_TABLE
266: , a3 JTF_NUMBER_TABLE
267: , a4 JTF_VARCHAR2_TABLE_100
268: , a5 JTF_VARCHAR2_TABLE_100
269: , a6 JTF_NUMBER_TABLE
270: , a7 JTF_VARCHAR2_TABLE_100
271: , a8 JTF_DATE_TABLE
272: , a9 JTF_DATE_TABLE

Line 270: , a7 JTF_VARCHAR2_TABLE_100

266: , a3 JTF_NUMBER_TABLE
267: , a4 JTF_VARCHAR2_TABLE_100
268: , a5 JTF_VARCHAR2_TABLE_100
269: , a6 JTF_NUMBER_TABLE
270: , a7 JTF_VARCHAR2_TABLE_100
271: , a8 JTF_DATE_TABLE
272: , a9 JTF_DATE_TABLE
273: , a10 JTF_VARCHAR2_TABLE_100
274: , a11 JTF_VARCHAR2_TABLE_500

Line 273: , a10 JTF_VARCHAR2_TABLE_100

269: , a6 JTF_NUMBER_TABLE
270: , a7 JTF_VARCHAR2_TABLE_100
271: , a8 JTF_DATE_TABLE
272: , a9 JTF_DATE_TABLE
273: , a10 JTF_VARCHAR2_TABLE_100
274: , a11 JTF_VARCHAR2_TABLE_500
275: , a12 JTF_VARCHAR2_TABLE_500
276: , a13 JTF_VARCHAR2_TABLE_500
277: , a14 JTF_VARCHAR2_TABLE_500

Line 346: , a4 out nocopy JTF_VARCHAR2_TABLE_100

342: procedure rosetta_table_copy_out_p3(t okl_pam_pvt.okl_pamb_tbl, a0 out nocopy JTF_NUMBER_TABLE
343: , a1 out nocopy JTF_VARCHAR2_TABLE_300
344: , a2 out nocopy JTF_NUMBER_TABLE
345: , a3 out nocopy JTF_NUMBER_TABLE
346: , a4 out nocopy JTF_VARCHAR2_TABLE_100
347: , a5 out nocopy JTF_VARCHAR2_TABLE_100
348: , a6 out nocopy JTF_NUMBER_TABLE
349: , a7 out nocopy JTF_VARCHAR2_TABLE_100
350: , a8 out nocopy JTF_DATE_TABLE

Line 347: , a5 out nocopy JTF_VARCHAR2_TABLE_100

343: , a1 out nocopy JTF_VARCHAR2_TABLE_300
344: , a2 out nocopy JTF_NUMBER_TABLE
345: , a3 out nocopy JTF_NUMBER_TABLE
346: , a4 out nocopy JTF_VARCHAR2_TABLE_100
347: , a5 out nocopy JTF_VARCHAR2_TABLE_100
348: , a6 out nocopy JTF_NUMBER_TABLE
349: , a7 out nocopy JTF_VARCHAR2_TABLE_100
350: , a8 out nocopy JTF_DATE_TABLE
351: , a9 out nocopy JTF_DATE_TABLE

Line 349: , a7 out nocopy JTF_VARCHAR2_TABLE_100

345: , a3 out nocopy JTF_NUMBER_TABLE
346: , a4 out nocopy JTF_VARCHAR2_TABLE_100
347: , a5 out nocopy JTF_VARCHAR2_TABLE_100
348: , a6 out nocopy JTF_NUMBER_TABLE
349: , a7 out nocopy JTF_VARCHAR2_TABLE_100
350: , a8 out nocopy JTF_DATE_TABLE
351: , a9 out nocopy JTF_DATE_TABLE
352: , a10 out nocopy JTF_VARCHAR2_TABLE_100
353: , a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 352: , a10 out nocopy JTF_VARCHAR2_TABLE_100

348: , a6 out nocopy JTF_NUMBER_TABLE
349: , a7 out nocopy JTF_VARCHAR2_TABLE_100
350: , a8 out nocopy JTF_DATE_TABLE
351: , a9 out nocopy JTF_DATE_TABLE
352: , a10 out nocopy JTF_VARCHAR2_TABLE_100
353: , a11 out nocopy JTF_VARCHAR2_TABLE_500
354: , a12 out nocopy JTF_VARCHAR2_TABLE_500
355: , a13 out nocopy JTF_VARCHAR2_TABLE_500
356: , a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 381: a4 := JTF_VARCHAR2_TABLE_100();

377: a0 := JTF_NUMBER_TABLE();
378: a1 := JTF_VARCHAR2_TABLE_300();
379: a2 := JTF_NUMBER_TABLE();
380: a3 := JTF_NUMBER_TABLE();
381: a4 := JTF_VARCHAR2_TABLE_100();
382: a5 := JTF_VARCHAR2_TABLE_100();
383: a6 := JTF_NUMBER_TABLE();
384: a7 := JTF_VARCHAR2_TABLE_100();
385: a8 := JTF_DATE_TABLE();

Line 382: a5 := JTF_VARCHAR2_TABLE_100();

378: a1 := JTF_VARCHAR2_TABLE_300();
379: a2 := JTF_NUMBER_TABLE();
380: a3 := JTF_NUMBER_TABLE();
381: a4 := JTF_VARCHAR2_TABLE_100();
382: a5 := JTF_VARCHAR2_TABLE_100();
383: a6 := JTF_NUMBER_TABLE();
384: a7 := JTF_VARCHAR2_TABLE_100();
385: a8 := JTF_DATE_TABLE();
386: a9 := JTF_DATE_TABLE();

Line 384: a7 := JTF_VARCHAR2_TABLE_100();

380: a3 := JTF_NUMBER_TABLE();
381: a4 := JTF_VARCHAR2_TABLE_100();
382: a5 := JTF_VARCHAR2_TABLE_100();
383: a6 := JTF_NUMBER_TABLE();
384: a7 := JTF_VARCHAR2_TABLE_100();
385: a8 := JTF_DATE_TABLE();
386: a9 := JTF_DATE_TABLE();
387: a10 := JTF_VARCHAR2_TABLE_100();
388: a11 := JTF_VARCHAR2_TABLE_500();

Line 387: a10 := JTF_VARCHAR2_TABLE_100();

383: a6 := JTF_NUMBER_TABLE();
384: a7 := JTF_VARCHAR2_TABLE_100();
385: a8 := JTF_DATE_TABLE();
386: a9 := JTF_DATE_TABLE();
387: a10 := JTF_VARCHAR2_TABLE_100();
388: a11 := JTF_VARCHAR2_TABLE_500();
389: a12 := JTF_VARCHAR2_TABLE_500();
390: a13 := JTF_VARCHAR2_TABLE_500();
391: a14 := JTF_VARCHAR2_TABLE_500();

Line 413: a4 := JTF_VARCHAR2_TABLE_100();

409: a0 := JTF_NUMBER_TABLE();
410: a1 := JTF_VARCHAR2_TABLE_300();
411: a2 := JTF_NUMBER_TABLE();
412: a3 := JTF_NUMBER_TABLE();
413: a4 := JTF_VARCHAR2_TABLE_100();
414: a5 := JTF_VARCHAR2_TABLE_100();
415: a6 := JTF_NUMBER_TABLE();
416: a7 := JTF_VARCHAR2_TABLE_100();
417: a8 := JTF_DATE_TABLE();

Line 414: a5 := JTF_VARCHAR2_TABLE_100();

410: a1 := JTF_VARCHAR2_TABLE_300();
411: a2 := JTF_NUMBER_TABLE();
412: a3 := JTF_NUMBER_TABLE();
413: a4 := JTF_VARCHAR2_TABLE_100();
414: a5 := JTF_VARCHAR2_TABLE_100();
415: a6 := JTF_NUMBER_TABLE();
416: a7 := JTF_VARCHAR2_TABLE_100();
417: a8 := JTF_DATE_TABLE();
418: a9 := JTF_DATE_TABLE();

Line 416: a7 := JTF_VARCHAR2_TABLE_100();

412: a3 := JTF_NUMBER_TABLE();
413: a4 := JTF_VARCHAR2_TABLE_100();
414: a5 := JTF_VARCHAR2_TABLE_100();
415: a6 := JTF_NUMBER_TABLE();
416: a7 := JTF_VARCHAR2_TABLE_100();
417: a8 := JTF_DATE_TABLE();
418: a9 := JTF_DATE_TABLE();
419: a10 := JTF_VARCHAR2_TABLE_100();
420: a11 := JTF_VARCHAR2_TABLE_500();

Line 419: a10 := JTF_VARCHAR2_TABLE_100();

415: a6 := JTF_NUMBER_TABLE();
416: a7 := JTF_VARCHAR2_TABLE_100();
417: a8 := JTF_DATE_TABLE();
418: a9 := JTF_DATE_TABLE();
419: a10 := JTF_VARCHAR2_TABLE_100();
420: a11 := JTF_VARCHAR2_TABLE_500();
421: a12 := JTF_VARCHAR2_TABLE_500();
422: a13 := JTF_VARCHAR2_TABLE_500();
423: a14 := JTF_VARCHAR2_TABLE_500();

Line 518: , a2 JTF_VARCHAR2_TABLE_100

514: end rosetta_table_copy_out_p3;
515:
516: procedure rosetta_table_copy_in_p5(t out nocopy okl_pam_pvt.okl_pamtl_tbl, a0 JTF_NUMBER_TABLE
517: , a1 JTF_VARCHAR2_TABLE_2000
518: , a2 JTF_VARCHAR2_TABLE_100
519: , a3 JTF_VARCHAR2_TABLE_100
520: , a4 JTF_VARCHAR2_TABLE_100
521: , a5 JTF_NUMBER_TABLE
522: , a6 JTF_DATE_TABLE

Line 519: , a3 JTF_VARCHAR2_TABLE_100

515:
516: procedure rosetta_table_copy_in_p5(t out nocopy okl_pam_pvt.okl_pamtl_tbl, a0 JTF_NUMBER_TABLE
517: , a1 JTF_VARCHAR2_TABLE_2000
518: , a2 JTF_VARCHAR2_TABLE_100
519: , a3 JTF_VARCHAR2_TABLE_100
520: , a4 JTF_VARCHAR2_TABLE_100
521: , a5 JTF_NUMBER_TABLE
522: , a6 JTF_DATE_TABLE
523: , a7 JTF_NUMBER_TABLE

Line 520: , a4 JTF_VARCHAR2_TABLE_100

516: procedure rosetta_table_copy_in_p5(t out nocopy okl_pam_pvt.okl_pamtl_tbl, a0 JTF_NUMBER_TABLE
517: , a1 JTF_VARCHAR2_TABLE_2000
518: , a2 JTF_VARCHAR2_TABLE_100
519: , a3 JTF_VARCHAR2_TABLE_100
520: , a4 JTF_VARCHAR2_TABLE_100
521: , a5 JTF_NUMBER_TABLE
522: , a6 JTF_DATE_TABLE
523: , a7 JTF_NUMBER_TABLE
524: , a8 JTF_DATE_TABLE

Line 555: , a2 out nocopy JTF_VARCHAR2_TABLE_100

551: end if;
552: end rosetta_table_copy_in_p5;
553: procedure rosetta_table_copy_out_p5(t okl_pam_pvt.okl_pamtl_tbl, a0 out nocopy JTF_NUMBER_TABLE
554: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
555: , a2 out nocopy JTF_VARCHAR2_TABLE_100
556: , a3 out nocopy JTF_VARCHAR2_TABLE_100
557: , a4 out nocopy JTF_VARCHAR2_TABLE_100
558: , a5 out nocopy JTF_NUMBER_TABLE
559: , a6 out nocopy JTF_DATE_TABLE

Line 556: , a3 out nocopy JTF_VARCHAR2_TABLE_100

552: end rosetta_table_copy_in_p5;
553: procedure rosetta_table_copy_out_p5(t okl_pam_pvt.okl_pamtl_tbl, a0 out nocopy JTF_NUMBER_TABLE
554: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
555: , a2 out nocopy JTF_VARCHAR2_TABLE_100
556: , a3 out nocopy JTF_VARCHAR2_TABLE_100
557: , a4 out nocopy JTF_VARCHAR2_TABLE_100
558: , a5 out nocopy JTF_NUMBER_TABLE
559: , a6 out nocopy JTF_DATE_TABLE
560: , a7 out nocopy JTF_NUMBER_TABLE

Line 557: , a4 out nocopy JTF_VARCHAR2_TABLE_100

553: procedure rosetta_table_copy_out_p5(t okl_pam_pvt.okl_pamtl_tbl, a0 out nocopy JTF_NUMBER_TABLE
554: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
555: , a2 out nocopy JTF_VARCHAR2_TABLE_100
556: , a3 out nocopy JTF_VARCHAR2_TABLE_100
557: , a4 out nocopy JTF_VARCHAR2_TABLE_100
558: , a5 out nocopy JTF_NUMBER_TABLE
559: , a6 out nocopy JTF_DATE_TABLE
560: , a7 out nocopy JTF_NUMBER_TABLE
561: , a8 out nocopy JTF_DATE_TABLE

Line 569: a2 := JTF_VARCHAR2_TABLE_100();

565: begin
566: if t is null or t.count = 0 then
567: a0 := JTF_NUMBER_TABLE();
568: a1 := JTF_VARCHAR2_TABLE_2000();
569: a2 := JTF_VARCHAR2_TABLE_100();
570: a3 := JTF_VARCHAR2_TABLE_100();
571: a4 := JTF_VARCHAR2_TABLE_100();
572: a5 := JTF_NUMBER_TABLE();
573: a6 := JTF_DATE_TABLE();

Line 570: a3 := JTF_VARCHAR2_TABLE_100();

566: if t is null or t.count = 0 then
567: a0 := JTF_NUMBER_TABLE();
568: a1 := JTF_VARCHAR2_TABLE_2000();
569: a2 := JTF_VARCHAR2_TABLE_100();
570: a3 := JTF_VARCHAR2_TABLE_100();
571: a4 := JTF_VARCHAR2_TABLE_100();
572: a5 := JTF_NUMBER_TABLE();
573: a6 := JTF_DATE_TABLE();
574: a7 := JTF_NUMBER_TABLE();

Line 571: a4 := JTF_VARCHAR2_TABLE_100();

567: a0 := JTF_NUMBER_TABLE();
568: a1 := JTF_VARCHAR2_TABLE_2000();
569: a2 := JTF_VARCHAR2_TABLE_100();
570: a3 := JTF_VARCHAR2_TABLE_100();
571: a4 := JTF_VARCHAR2_TABLE_100();
572: a5 := JTF_NUMBER_TABLE();
573: a6 := JTF_DATE_TABLE();
574: a7 := JTF_NUMBER_TABLE();
575: a8 := JTF_DATE_TABLE();

Line 580: a2 := JTF_VARCHAR2_TABLE_100();

576: a9 := JTF_NUMBER_TABLE();
577: else
578: a0 := JTF_NUMBER_TABLE();
579: a1 := JTF_VARCHAR2_TABLE_2000();
580: a2 := JTF_VARCHAR2_TABLE_100();
581: a3 := JTF_VARCHAR2_TABLE_100();
582: a4 := JTF_VARCHAR2_TABLE_100();
583: a5 := JTF_NUMBER_TABLE();
584: a6 := JTF_DATE_TABLE();

Line 581: a3 := JTF_VARCHAR2_TABLE_100();

577: else
578: a0 := JTF_NUMBER_TABLE();
579: a1 := JTF_VARCHAR2_TABLE_2000();
580: a2 := JTF_VARCHAR2_TABLE_100();
581: a3 := JTF_VARCHAR2_TABLE_100();
582: a4 := JTF_VARCHAR2_TABLE_100();
583: a5 := JTF_NUMBER_TABLE();
584: a6 := JTF_DATE_TABLE();
585: a7 := JTF_NUMBER_TABLE();

Line 582: a4 := JTF_VARCHAR2_TABLE_100();

578: a0 := JTF_NUMBER_TABLE();
579: a1 := JTF_VARCHAR2_TABLE_2000();
580: a2 := JTF_VARCHAR2_TABLE_100();
581: a3 := JTF_VARCHAR2_TABLE_100();
582: a4 := JTF_VARCHAR2_TABLE_100();
583: a5 := JTF_NUMBER_TABLE();
584: a6 := JTF_DATE_TABLE();
585: a7 := JTF_NUMBER_TABLE();
586: a8 := JTF_DATE_TABLE();

Line 797: , p5_a3 JTF_VARCHAR2_TABLE_100

793: , x_msg_data out nocopy VARCHAR2
794: , p5_a0 JTF_NUMBER_TABLE
795: , p5_a1 JTF_NUMBER_TABLE
796: , p5_a2 JTF_NUMBER_TABLE
797: , p5_a3 JTF_VARCHAR2_TABLE_100
798: , p5_a4 JTF_VARCHAR2_TABLE_100
799: , p5_a5 JTF_NUMBER_TABLE
800: , p5_a6 JTF_VARCHAR2_TABLE_100
801: , p5_a7 JTF_DATE_TABLE

Line 798: , p5_a4 JTF_VARCHAR2_TABLE_100

794: , p5_a0 JTF_NUMBER_TABLE
795: , p5_a1 JTF_NUMBER_TABLE
796: , p5_a2 JTF_NUMBER_TABLE
797: , p5_a3 JTF_VARCHAR2_TABLE_100
798: , p5_a4 JTF_VARCHAR2_TABLE_100
799: , p5_a5 JTF_NUMBER_TABLE
800: , p5_a6 JTF_VARCHAR2_TABLE_100
801: , p5_a7 JTF_DATE_TABLE
802: , p5_a8 JTF_DATE_TABLE

Line 800: , p5_a6 JTF_VARCHAR2_TABLE_100

796: , p5_a2 JTF_NUMBER_TABLE
797: , p5_a3 JTF_VARCHAR2_TABLE_100
798: , p5_a4 JTF_VARCHAR2_TABLE_100
799: , p5_a5 JTF_NUMBER_TABLE
800: , p5_a6 JTF_VARCHAR2_TABLE_100
801: , p5_a7 JTF_DATE_TABLE
802: , p5_a8 JTF_DATE_TABLE
803: , p5_a9 JTF_VARCHAR2_TABLE_100
804: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 803: , p5_a9 JTF_VARCHAR2_TABLE_100

799: , p5_a5 JTF_NUMBER_TABLE
800: , p5_a6 JTF_VARCHAR2_TABLE_100
801: , p5_a7 JTF_DATE_TABLE
802: , p5_a8 JTF_DATE_TABLE
803: , p5_a9 JTF_VARCHAR2_TABLE_100
804: , p5_a10 JTF_VARCHAR2_TABLE_500
805: , p5_a11 JTF_VARCHAR2_TABLE_500
806: , p5_a12 JTF_VARCHAR2_TABLE_500
807: , p5_a13 JTF_VARCHAR2_TABLE_500

Line 829: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

825: , p5_a31 JTF_VARCHAR2_TABLE_2000
826: , p6_a0 out nocopy JTF_NUMBER_TABLE
827: , p6_a1 out nocopy JTF_NUMBER_TABLE
828: , p6_a2 out nocopy JTF_NUMBER_TABLE
829: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
830: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
831: , p6_a5 out nocopy JTF_NUMBER_TABLE
832: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
833: , p6_a7 out nocopy JTF_DATE_TABLE

Line 830: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

826: , p6_a0 out nocopy JTF_NUMBER_TABLE
827: , p6_a1 out nocopy JTF_NUMBER_TABLE
828: , p6_a2 out nocopy JTF_NUMBER_TABLE
829: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
830: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
831: , p6_a5 out nocopy JTF_NUMBER_TABLE
832: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
833: , p6_a7 out nocopy JTF_DATE_TABLE
834: , p6_a8 out nocopy JTF_DATE_TABLE

Line 832: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

828: , p6_a2 out nocopy JTF_NUMBER_TABLE
829: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
830: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
831: , p6_a5 out nocopy JTF_NUMBER_TABLE
832: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
833: , p6_a7 out nocopy JTF_DATE_TABLE
834: , p6_a8 out nocopy JTF_DATE_TABLE
835: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
836: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 835: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

831: , p6_a5 out nocopy JTF_NUMBER_TABLE
832: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
833: , p6_a7 out nocopy JTF_DATE_TABLE
834: , p6_a8 out nocopy JTF_DATE_TABLE
835: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
836: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
837: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
838: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
839: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500

Line 1133: , p5_a3 JTF_VARCHAR2_TABLE_100

1129: , x_msg_data out nocopy VARCHAR2
1130: , p5_a0 JTF_NUMBER_TABLE
1131: , p5_a1 JTF_NUMBER_TABLE
1132: , p5_a2 JTF_NUMBER_TABLE
1133: , p5_a3 JTF_VARCHAR2_TABLE_100
1134: , p5_a4 JTF_VARCHAR2_TABLE_100
1135: , p5_a5 JTF_NUMBER_TABLE
1136: , p5_a6 JTF_VARCHAR2_TABLE_100
1137: , p5_a7 JTF_DATE_TABLE

Line 1134: , p5_a4 JTF_VARCHAR2_TABLE_100

1130: , p5_a0 JTF_NUMBER_TABLE
1131: , p5_a1 JTF_NUMBER_TABLE
1132: , p5_a2 JTF_NUMBER_TABLE
1133: , p5_a3 JTF_VARCHAR2_TABLE_100
1134: , p5_a4 JTF_VARCHAR2_TABLE_100
1135: , p5_a5 JTF_NUMBER_TABLE
1136: , p5_a6 JTF_VARCHAR2_TABLE_100
1137: , p5_a7 JTF_DATE_TABLE
1138: , p5_a8 JTF_DATE_TABLE

Line 1136: , p5_a6 JTF_VARCHAR2_TABLE_100

1132: , p5_a2 JTF_NUMBER_TABLE
1133: , p5_a3 JTF_VARCHAR2_TABLE_100
1134: , p5_a4 JTF_VARCHAR2_TABLE_100
1135: , p5_a5 JTF_NUMBER_TABLE
1136: , p5_a6 JTF_VARCHAR2_TABLE_100
1137: , p5_a7 JTF_DATE_TABLE
1138: , p5_a8 JTF_DATE_TABLE
1139: , p5_a9 JTF_VARCHAR2_TABLE_100
1140: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 1139: , p5_a9 JTF_VARCHAR2_TABLE_100

1135: , p5_a5 JTF_NUMBER_TABLE
1136: , p5_a6 JTF_VARCHAR2_TABLE_100
1137: , p5_a7 JTF_DATE_TABLE
1138: , p5_a8 JTF_DATE_TABLE
1139: , p5_a9 JTF_VARCHAR2_TABLE_100
1140: , p5_a10 JTF_VARCHAR2_TABLE_500
1141: , p5_a11 JTF_VARCHAR2_TABLE_500
1142: , p5_a12 JTF_VARCHAR2_TABLE_500
1143: , p5_a13 JTF_VARCHAR2_TABLE_500

Line 1165: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

1161: , p5_a31 JTF_VARCHAR2_TABLE_2000
1162: , p6_a0 out nocopy JTF_NUMBER_TABLE
1163: , p6_a1 out nocopy JTF_NUMBER_TABLE
1164: , p6_a2 out nocopy JTF_NUMBER_TABLE
1165: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1166: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1167: , p6_a5 out nocopy JTF_NUMBER_TABLE
1168: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1169: , p6_a7 out nocopy JTF_DATE_TABLE

Line 1166: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

1162: , p6_a0 out nocopy JTF_NUMBER_TABLE
1163: , p6_a1 out nocopy JTF_NUMBER_TABLE
1164: , p6_a2 out nocopy JTF_NUMBER_TABLE
1165: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1166: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1167: , p6_a5 out nocopy JTF_NUMBER_TABLE
1168: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1169: , p6_a7 out nocopy JTF_DATE_TABLE
1170: , p6_a8 out nocopy JTF_DATE_TABLE

Line 1168: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

1164: , p6_a2 out nocopy JTF_NUMBER_TABLE
1165: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1166: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1167: , p6_a5 out nocopy JTF_NUMBER_TABLE
1168: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1169: , p6_a7 out nocopy JTF_DATE_TABLE
1170: , p6_a8 out nocopy JTF_DATE_TABLE
1171: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1172: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 1171: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

1167: , p6_a5 out nocopy JTF_NUMBER_TABLE
1168: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1169: , p6_a7 out nocopy JTF_DATE_TABLE
1170: , p6_a8 out nocopy JTF_DATE_TABLE
1171: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
1172: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
1173: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
1174: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
1175: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500

Line 1401: , p5_a3 JTF_VARCHAR2_TABLE_100

1397: , x_msg_data out nocopy VARCHAR2
1398: , p5_a0 JTF_NUMBER_TABLE
1399: , p5_a1 JTF_NUMBER_TABLE
1400: , p5_a2 JTF_NUMBER_TABLE
1401: , p5_a3 JTF_VARCHAR2_TABLE_100
1402: , p5_a4 JTF_VARCHAR2_TABLE_100
1403: , p5_a5 JTF_NUMBER_TABLE
1404: , p5_a6 JTF_VARCHAR2_TABLE_100
1405: , p5_a7 JTF_DATE_TABLE

Line 1402: , p5_a4 JTF_VARCHAR2_TABLE_100

1398: , p5_a0 JTF_NUMBER_TABLE
1399: , p5_a1 JTF_NUMBER_TABLE
1400: , p5_a2 JTF_NUMBER_TABLE
1401: , p5_a3 JTF_VARCHAR2_TABLE_100
1402: , p5_a4 JTF_VARCHAR2_TABLE_100
1403: , p5_a5 JTF_NUMBER_TABLE
1404: , p5_a6 JTF_VARCHAR2_TABLE_100
1405: , p5_a7 JTF_DATE_TABLE
1406: , p5_a8 JTF_DATE_TABLE

Line 1404: , p5_a6 JTF_VARCHAR2_TABLE_100

1400: , p5_a2 JTF_NUMBER_TABLE
1401: , p5_a3 JTF_VARCHAR2_TABLE_100
1402: , p5_a4 JTF_VARCHAR2_TABLE_100
1403: , p5_a5 JTF_NUMBER_TABLE
1404: , p5_a6 JTF_VARCHAR2_TABLE_100
1405: , p5_a7 JTF_DATE_TABLE
1406: , p5_a8 JTF_DATE_TABLE
1407: , p5_a9 JTF_VARCHAR2_TABLE_100
1408: , p5_a10 JTF_VARCHAR2_TABLE_500

Line 1407: , p5_a9 JTF_VARCHAR2_TABLE_100

1403: , p5_a5 JTF_NUMBER_TABLE
1404: , p5_a6 JTF_VARCHAR2_TABLE_100
1405: , p5_a7 JTF_DATE_TABLE
1406: , p5_a8 JTF_DATE_TABLE
1407: , p5_a9 JTF_VARCHAR2_TABLE_100
1408: , p5_a10 JTF_VARCHAR2_TABLE_500
1409: , p5_a11 JTF_VARCHAR2_TABLE_500
1410: , p5_a12 JTF_VARCHAR2_TABLE_500
1411: , p5_a13 JTF_VARCHAR2_TABLE_500