DBA Data[Home] [Help]

APPS.OKL_SPLIT_ASSET_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 24: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100

20: , p_split_into_units NUMBER
21: , p8_a0 JTF_NUMBER_TABLE
22: , p9_a0 out nocopy JTF_NUMBER_TABLE
23: , p9_a1 out nocopy JTF_NUMBER_TABLE
24: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
25: , p9_a3 out nocopy JTF_NUMBER_TABLE
26: , p9_a4 out nocopy JTF_NUMBER_TABLE
27: , p9_a5 out nocopy JTF_NUMBER_TABLE
28: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 28: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100

24: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
25: , p9_a3 out nocopy JTF_NUMBER_TABLE
26: , p9_a4 out nocopy JTF_NUMBER_TABLE
27: , p9_a5 out nocopy JTF_NUMBER_TABLE
28: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
29: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_2000
30: , p9_a8 out nocopy JTF_NUMBER_TABLE
31: , p9_a9 out nocopy JTF_NUMBER_TABLE
32: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 32: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100

28: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
29: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_2000
30: , p9_a8 out nocopy JTF_NUMBER_TABLE
31: , p9_a9 out nocopy JTF_NUMBER_TABLE
32: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
33: , p9_a11 out nocopy JTF_NUMBER_TABLE
34: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
35: , p9_a13 out nocopy JTF_NUMBER_TABLE
36: , p9_a14 out nocopy JTF_NUMBER_TABLE

Line 34: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100

30: , p9_a8 out nocopy JTF_NUMBER_TABLE
31: , p9_a9 out nocopy JTF_NUMBER_TABLE
32: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
33: , p9_a11 out nocopy JTF_NUMBER_TABLE
34: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
35: , p9_a13 out nocopy JTF_NUMBER_TABLE
36: , p9_a14 out nocopy JTF_NUMBER_TABLE
37: , p9_a15 out nocopy JTF_NUMBER_TABLE
38: , p9_a16 out nocopy JTF_NUMBER_TABLE

Line 39: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100

35: , p9_a13 out nocopy JTF_NUMBER_TABLE
36: , p9_a14 out nocopy JTF_NUMBER_TABLE
37: , p9_a15 out nocopy JTF_NUMBER_TABLE
38: , p9_a16 out nocopy JTF_NUMBER_TABLE
39: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
40: , p9_a18 out nocopy JTF_VARCHAR2_TABLE_500
41: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_500
42: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_500
43: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 60: , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100

56: , p9_a34 out nocopy JTF_DATE_TABLE
57: , p9_a35 out nocopy JTF_NUMBER_TABLE
58: , p9_a36 out nocopy JTF_DATE_TABLE
59: , p9_a37 out nocopy JTF_NUMBER_TABLE
60: , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100
61: , p9_a39 out nocopy JTF_VARCHAR2_TABLE_100
62: , p9_a40 out nocopy JTF_NUMBER_TABLE
63: , p9_a41 out nocopy JTF_DATE_TABLE
64: , p10_a0 out nocopy NUMBER

Line 61: , p9_a39 out nocopy JTF_VARCHAR2_TABLE_100

57: , p9_a35 out nocopy JTF_NUMBER_TABLE
58: , p9_a36 out nocopy JTF_DATE_TABLE
59: , p9_a37 out nocopy JTF_NUMBER_TABLE
60: , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100
61: , p9_a39 out nocopy JTF_VARCHAR2_TABLE_100
62: , p9_a40 out nocopy JTF_NUMBER_TABLE
63: , p9_a41 out nocopy JTF_DATE_TABLE
64: , p10_a0 out nocopy NUMBER
65: , p10_a1 out nocopy NUMBER

Line 184: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100

180: , p_split_into_individuals_yn VARCHAR2
181: , p_split_into_units NUMBER
182: , p8_a0 out nocopy JTF_NUMBER_TABLE
183: , p8_a1 out nocopy JTF_NUMBER_TABLE
184: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
185: , p8_a3 out nocopy JTF_NUMBER_TABLE
186: , p8_a4 out nocopy JTF_NUMBER_TABLE
187: , p8_a5 out nocopy JTF_NUMBER_TABLE
188: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 188: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100

184: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
185: , p8_a3 out nocopy JTF_NUMBER_TABLE
186: , p8_a4 out nocopy JTF_NUMBER_TABLE
187: , p8_a5 out nocopy JTF_NUMBER_TABLE
188: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
189: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_2000
190: , p8_a8 out nocopy JTF_NUMBER_TABLE
191: , p8_a9 out nocopy JTF_NUMBER_TABLE
192: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 192: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100

188: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
189: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_2000
190: , p8_a8 out nocopy JTF_NUMBER_TABLE
191: , p8_a9 out nocopy JTF_NUMBER_TABLE
192: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100
193: , p8_a11 out nocopy JTF_NUMBER_TABLE
194: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
195: , p8_a13 out nocopy JTF_NUMBER_TABLE
196: , p8_a14 out nocopy JTF_NUMBER_TABLE

Line 194: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100

190: , p8_a8 out nocopy JTF_NUMBER_TABLE
191: , p8_a9 out nocopy JTF_NUMBER_TABLE
192: , p8_a10 out nocopy JTF_VARCHAR2_TABLE_100
193: , p8_a11 out nocopy JTF_NUMBER_TABLE
194: , p8_a12 out nocopy JTF_VARCHAR2_TABLE_100
195: , p8_a13 out nocopy JTF_NUMBER_TABLE
196: , p8_a14 out nocopy JTF_NUMBER_TABLE
197: , p8_a15 out nocopy JTF_NUMBER_TABLE
198: , p8_a16 out nocopy JTF_NUMBER_TABLE

Line 199: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100

195: , p8_a13 out nocopy JTF_NUMBER_TABLE
196: , p8_a14 out nocopy JTF_NUMBER_TABLE
197: , p8_a15 out nocopy JTF_NUMBER_TABLE
198: , p8_a16 out nocopy JTF_NUMBER_TABLE
199: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
200: , p8_a18 out nocopy JTF_VARCHAR2_TABLE_500
201: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_500
202: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_500
203: , p8_a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 220: , p8_a38 out nocopy JTF_VARCHAR2_TABLE_100

216: , p8_a34 out nocopy JTF_DATE_TABLE
217: , p8_a35 out nocopy JTF_NUMBER_TABLE
218: , p8_a36 out nocopy JTF_DATE_TABLE
219: , p8_a37 out nocopy JTF_NUMBER_TABLE
220: , p8_a38 out nocopy JTF_VARCHAR2_TABLE_100
221: , p8_a39 out nocopy JTF_VARCHAR2_TABLE_100
222: , p8_a40 out nocopy JTF_NUMBER_TABLE
223: , p8_a41 out nocopy JTF_DATE_TABLE
224: , p9_a0 out nocopy NUMBER

Line 221: , p8_a39 out nocopy JTF_VARCHAR2_TABLE_100

217: , p8_a35 out nocopy JTF_NUMBER_TABLE
218: , p8_a36 out nocopy JTF_DATE_TABLE
219: , p8_a37 out nocopy JTF_NUMBER_TABLE
220: , p8_a38 out nocopy JTF_VARCHAR2_TABLE_100
221: , p8_a39 out nocopy JTF_VARCHAR2_TABLE_100
222: , p8_a40 out nocopy JTF_NUMBER_TABLE
223: , p8_a41 out nocopy JTF_DATE_TABLE
224: , p9_a0 out nocopy NUMBER
225: , p9_a1 out nocopy NUMBER

Line 346: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100

342: , p8_a0 JTF_NUMBER_TABLE
343: , p_trx_date date
344: , p10_a0 out nocopy JTF_NUMBER_TABLE
345: , p10_a1 out nocopy JTF_NUMBER_TABLE
346: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
347: , p10_a3 out nocopy JTF_NUMBER_TABLE
348: , p10_a4 out nocopy JTF_NUMBER_TABLE
349: , p10_a5 out nocopy JTF_NUMBER_TABLE
350: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 350: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100

346: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
347: , p10_a3 out nocopy JTF_NUMBER_TABLE
348: , p10_a4 out nocopy JTF_NUMBER_TABLE
349: , p10_a5 out nocopy JTF_NUMBER_TABLE
350: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
351: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_2000
352: , p10_a8 out nocopy JTF_NUMBER_TABLE
353: , p10_a9 out nocopy JTF_NUMBER_TABLE
354: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 354: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100

350: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
351: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_2000
352: , p10_a8 out nocopy JTF_NUMBER_TABLE
353: , p10_a9 out nocopy JTF_NUMBER_TABLE
354: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
355: , p10_a11 out nocopy JTF_NUMBER_TABLE
356: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
357: , p10_a13 out nocopy JTF_NUMBER_TABLE
358: , p10_a14 out nocopy JTF_NUMBER_TABLE

Line 356: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100

352: , p10_a8 out nocopy JTF_NUMBER_TABLE
353: , p10_a9 out nocopy JTF_NUMBER_TABLE
354: , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
355: , p10_a11 out nocopy JTF_NUMBER_TABLE
356: , p10_a12 out nocopy JTF_VARCHAR2_TABLE_100
357: , p10_a13 out nocopy JTF_NUMBER_TABLE
358: , p10_a14 out nocopy JTF_NUMBER_TABLE
359: , p10_a15 out nocopy JTF_NUMBER_TABLE
360: , p10_a16 out nocopy JTF_NUMBER_TABLE

Line 361: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100

357: , p10_a13 out nocopy JTF_NUMBER_TABLE
358: , p10_a14 out nocopy JTF_NUMBER_TABLE
359: , p10_a15 out nocopy JTF_NUMBER_TABLE
360: , p10_a16 out nocopy JTF_NUMBER_TABLE
361: , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
362: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_500
363: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_500
364: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
365: , p10_a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 382: , p10_a38 out nocopy JTF_VARCHAR2_TABLE_100

378: , p10_a34 out nocopy JTF_DATE_TABLE
379: , p10_a35 out nocopy JTF_NUMBER_TABLE
380: , p10_a36 out nocopy JTF_DATE_TABLE
381: , p10_a37 out nocopy JTF_NUMBER_TABLE
382: , p10_a38 out nocopy JTF_VARCHAR2_TABLE_100
383: , p10_a39 out nocopy JTF_VARCHAR2_TABLE_100
384: , p10_a40 out nocopy JTF_NUMBER_TABLE
385: , p10_a41 out nocopy JTF_DATE_TABLE
386: , p11_a0 out nocopy NUMBER

Line 383: , p10_a39 out nocopy JTF_VARCHAR2_TABLE_100

379: , p10_a35 out nocopy JTF_NUMBER_TABLE
380: , p10_a36 out nocopy JTF_DATE_TABLE
381: , p10_a37 out nocopy JTF_NUMBER_TABLE
382: , p10_a38 out nocopy JTF_VARCHAR2_TABLE_100
383: , p10_a39 out nocopy JTF_VARCHAR2_TABLE_100
384: , p10_a40 out nocopy JTF_NUMBER_TABLE
385: , p10_a41 out nocopy JTF_DATE_TABLE
386: , p11_a0 out nocopy NUMBER
387: , p11_a1 out nocopy NUMBER

Line 507: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100

503: , p_split_into_units NUMBER
504: , p_trx_date date
505: , p9_a0 out nocopy JTF_NUMBER_TABLE
506: , p9_a1 out nocopy JTF_NUMBER_TABLE
507: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
508: , p9_a3 out nocopy JTF_NUMBER_TABLE
509: , p9_a4 out nocopy JTF_NUMBER_TABLE
510: , p9_a5 out nocopy JTF_NUMBER_TABLE
511: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 511: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100

507: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
508: , p9_a3 out nocopy JTF_NUMBER_TABLE
509: , p9_a4 out nocopy JTF_NUMBER_TABLE
510: , p9_a5 out nocopy JTF_NUMBER_TABLE
511: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
512: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_2000
513: , p9_a8 out nocopy JTF_NUMBER_TABLE
514: , p9_a9 out nocopy JTF_NUMBER_TABLE
515: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 515: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100

511: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
512: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_2000
513: , p9_a8 out nocopy JTF_NUMBER_TABLE
514: , p9_a9 out nocopy JTF_NUMBER_TABLE
515: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
516: , p9_a11 out nocopy JTF_NUMBER_TABLE
517: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
518: , p9_a13 out nocopy JTF_NUMBER_TABLE
519: , p9_a14 out nocopy JTF_NUMBER_TABLE

Line 517: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100

513: , p9_a8 out nocopy JTF_NUMBER_TABLE
514: , p9_a9 out nocopy JTF_NUMBER_TABLE
515: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
516: , p9_a11 out nocopy JTF_NUMBER_TABLE
517: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
518: , p9_a13 out nocopy JTF_NUMBER_TABLE
519: , p9_a14 out nocopy JTF_NUMBER_TABLE
520: , p9_a15 out nocopy JTF_NUMBER_TABLE
521: , p9_a16 out nocopy JTF_NUMBER_TABLE

Line 522: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100

518: , p9_a13 out nocopy JTF_NUMBER_TABLE
519: , p9_a14 out nocopy JTF_NUMBER_TABLE
520: , p9_a15 out nocopy JTF_NUMBER_TABLE
521: , p9_a16 out nocopy JTF_NUMBER_TABLE
522: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
523: , p9_a18 out nocopy JTF_VARCHAR2_TABLE_500
524: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_500
525: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_500
526: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 543: , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100

539: , p9_a34 out nocopy JTF_DATE_TABLE
540: , p9_a35 out nocopy JTF_NUMBER_TABLE
541: , p9_a36 out nocopy JTF_DATE_TABLE
542: , p9_a37 out nocopy JTF_NUMBER_TABLE
543: , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100
544: , p9_a39 out nocopy JTF_VARCHAR2_TABLE_100
545: , p9_a40 out nocopy JTF_NUMBER_TABLE
546: , p9_a41 out nocopy JTF_DATE_TABLE
547: , p10_a0 out nocopy NUMBER

Line 544: , p9_a39 out nocopy JTF_VARCHAR2_TABLE_100

540: , p9_a35 out nocopy JTF_NUMBER_TABLE
541: , p9_a36 out nocopy JTF_DATE_TABLE
542: , p9_a37 out nocopy JTF_NUMBER_TABLE
543: , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100
544: , p9_a39 out nocopy JTF_VARCHAR2_TABLE_100
545: , p9_a40 out nocopy JTF_NUMBER_TABLE
546: , p9_a41 out nocopy JTF_DATE_TABLE
547: , p10_a0 out nocopy NUMBER
548: , p10_a1 out nocopy NUMBER

Line 665: , p6_a2 JTF_VARCHAR2_TABLE_100

661: , x_msg_data out nocopy VARCHAR2
662: , p_cle_id NUMBER
663: , p6_a0 JTF_NUMBER_TABLE
664: , p6_a1 JTF_NUMBER_TABLE
665: , p6_a2 JTF_VARCHAR2_TABLE_100
666: , p6_a3 JTF_NUMBER_TABLE
667: , p6_a4 JTF_NUMBER_TABLE
668: , p6_a5 JTF_NUMBER_TABLE
669: , p6_a6 JTF_VARCHAR2_TABLE_100

Line 669: , p6_a6 JTF_VARCHAR2_TABLE_100

665: , p6_a2 JTF_VARCHAR2_TABLE_100
666: , p6_a3 JTF_NUMBER_TABLE
667: , p6_a4 JTF_NUMBER_TABLE
668: , p6_a5 JTF_NUMBER_TABLE
669: , p6_a6 JTF_VARCHAR2_TABLE_100
670: , p6_a7 JTF_VARCHAR2_TABLE_2000
671: , p6_a8 JTF_NUMBER_TABLE
672: , p6_a9 JTF_NUMBER_TABLE
673: , p6_a10 JTF_VARCHAR2_TABLE_100

Line 673: , p6_a10 JTF_VARCHAR2_TABLE_100

669: , p6_a6 JTF_VARCHAR2_TABLE_100
670: , p6_a7 JTF_VARCHAR2_TABLE_2000
671: , p6_a8 JTF_NUMBER_TABLE
672: , p6_a9 JTF_NUMBER_TABLE
673: , p6_a10 JTF_VARCHAR2_TABLE_100
674: , p6_a11 JTF_NUMBER_TABLE
675: , p6_a12 JTF_VARCHAR2_TABLE_100
676: , p6_a13 JTF_NUMBER_TABLE
677: , p6_a14 JTF_NUMBER_TABLE

Line 675: , p6_a12 JTF_VARCHAR2_TABLE_100

671: , p6_a8 JTF_NUMBER_TABLE
672: , p6_a9 JTF_NUMBER_TABLE
673: , p6_a10 JTF_VARCHAR2_TABLE_100
674: , p6_a11 JTF_NUMBER_TABLE
675: , p6_a12 JTF_VARCHAR2_TABLE_100
676: , p6_a13 JTF_NUMBER_TABLE
677: , p6_a14 JTF_NUMBER_TABLE
678: , p6_a15 JTF_NUMBER_TABLE
679: , p6_a16 JTF_NUMBER_TABLE

Line 680: , p6_a17 JTF_VARCHAR2_TABLE_100

676: , p6_a13 JTF_NUMBER_TABLE
677: , p6_a14 JTF_NUMBER_TABLE
678: , p6_a15 JTF_NUMBER_TABLE
679: , p6_a16 JTF_NUMBER_TABLE
680: , p6_a17 JTF_VARCHAR2_TABLE_100
681: , p6_a18 JTF_VARCHAR2_TABLE_500
682: , p6_a19 JTF_VARCHAR2_TABLE_500
683: , p6_a20 JTF_VARCHAR2_TABLE_500
684: , p6_a21 JTF_VARCHAR2_TABLE_500

Line 701: , p6_a38 JTF_VARCHAR2_TABLE_100

697: , p6_a34 JTF_DATE_TABLE
698: , p6_a35 JTF_NUMBER_TABLE
699: , p6_a36 JTF_DATE_TABLE
700: , p6_a37 JTF_NUMBER_TABLE
701: , p6_a38 JTF_VARCHAR2_TABLE_100
702: , p6_a39 JTF_VARCHAR2_TABLE_100
703: , p6_a40 JTF_NUMBER_TABLE
704: , p6_a41 JTF_DATE_TABLE
705: , p7_a0 out nocopy JTF_NUMBER_TABLE

Line 702: , p6_a39 JTF_VARCHAR2_TABLE_100

698: , p6_a35 JTF_NUMBER_TABLE
699: , p6_a36 JTF_DATE_TABLE
700: , p6_a37 JTF_NUMBER_TABLE
701: , p6_a38 JTF_VARCHAR2_TABLE_100
702: , p6_a39 JTF_VARCHAR2_TABLE_100
703: , p6_a40 JTF_NUMBER_TABLE
704: , p6_a41 JTF_DATE_TABLE
705: , p7_a0 out nocopy JTF_NUMBER_TABLE
706: , p7_a1 out nocopy JTF_NUMBER_TABLE

Line 707: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100

703: , p6_a40 JTF_NUMBER_TABLE
704: , p6_a41 JTF_DATE_TABLE
705: , p7_a0 out nocopy JTF_NUMBER_TABLE
706: , p7_a1 out nocopy JTF_NUMBER_TABLE
707: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
708: , p7_a3 out nocopy JTF_NUMBER_TABLE
709: , p7_a4 out nocopy JTF_NUMBER_TABLE
710: , p7_a5 out nocopy JTF_NUMBER_TABLE
711: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 711: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100

707: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
708: , p7_a3 out nocopy JTF_NUMBER_TABLE
709: , p7_a4 out nocopy JTF_NUMBER_TABLE
710: , p7_a5 out nocopy JTF_NUMBER_TABLE
711: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
712: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_2000
713: , p7_a8 out nocopy JTF_NUMBER_TABLE
714: , p7_a9 out nocopy JTF_NUMBER_TABLE
715: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 715: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100

711: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
712: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_2000
713: , p7_a8 out nocopy JTF_NUMBER_TABLE
714: , p7_a9 out nocopy JTF_NUMBER_TABLE
715: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
716: , p7_a11 out nocopy JTF_NUMBER_TABLE
717: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
718: , p7_a13 out nocopy JTF_NUMBER_TABLE
719: , p7_a14 out nocopy JTF_NUMBER_TABLE

Line 717: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100

713: , p7_a8 out nocopy JTF_NUMBER_TABLE
714: , p7_a9 out nocopy JTF_NUMBER_TABLE
715: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
716: , p7_a11 out nocopy JTF_NUMBER_TABLE
717: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
718: , p7_a13 out nocopy JTF_NUMBER_TABLE
719: , p7_a14 out nocopy JTF_NUMBER_TABLE
720: , p7_a15 out nocopy JTF_NUMBER_TABLE
721: , p7_a16 out nocopy JTF_NUMBER_TABLE

Line 722: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100

718: , p7_a13 out nocopy JTF_NUMBER_TABLE
719: , p7_a14 out nocopy JTF_NUMBER_TABLE
720: , p7_a15 out nocopy JTF_NUMBER_TABLE
721: , p7_a16 out nocopy JTF_NUMBER_TABLE
722: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_100
723: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_500
724: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_500
725: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_500
726: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_500

Line 743: , p7_a38 out nocopy JTF_VARCHAR2_TABLE_100

739: , p7_a34 out nocopy JTF_DATE_TABLE
740: , p7_a35 out nocopy JTF_NUMBER_TABLE
741: , p7_a36 out nocopy JTF_DATE_TABLE
742: , p7_a37 out nocopy JTF_NUMBER_TABLE
743: , p7_a38 out nocopy JTF_VARCHAR2_TABLE_100
744: , p7_a39 out nocopy JTF_VARCHAR2_TABLE_100
745: , p7_a40 out nocopy JTF_NUMBER_TABLE
746: , p7_a41 out nocopy JTF_DATE_TABLE
747: );

Line 744: , p7_a39 out nocopy JTF_VARCHAR2_TABLE_100

740: , p7_a35 out nocopy JTF_NUMBER_TABLE
741: , p7_a36 out nocopy JTF_DATE_TABLE
742: , p7_a37 out nocopy JTF_NUMBER_TABLE
743: , p7_a38 out nocopy JTF_VARCHAR2_TABLE_100
744: , p7_a39 out nocopy JTF_VARCHAR2_TABLE_100
745: , p7_a40 out nocopy JTF_NUMBER_TABLE
746: , p7_a41 out nocopy JTF_DATE_TABLE
747: );
748: procedure split_fixed_asset(p_api_version NUMBER

Line 755: , p5_a2 JTF_VARCHAR2_TABLE_100

751: , x_msg_count out nocopy NUMBER
752: , x_msg_data out nocopy VARCHAR2
753: , p5_a0 JTF_NUMBER_TABLE
754: , p5_a1 JTF_NUMBER_TABLE
755: , p5_a2 JTF_VARCHAR2_TABLE_100
756: , p5_a3 JTF_NUMBER_TABLE
757: , p5_a4 JTF_NUMBER_TABLE
758: , p5_a5 JTF_NUMBER_TABLE
759: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 759: , p5_a6 JTF_VARCHAR2_TABLE_100

755: , p5_a2 JTF_VARCHAR2_TABLE_100
756: , p5_a3 JTF_NUMBER_TABLE
757: , p5_a4 JTF_NUMBER_TABLE
758: , p5_a5 JTF_NUMBER_TABLE
759: , p5_a6 JTF_VARCHAR2_TABLE_100
760: , p5_a7 JTF_VARCHAR2_TABLE_2000
761: , p5_a8 JTF_NUMBER_TABLE
762: , p5_a9 JTF_NUMBER_TABLE
763: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 763: , p5_a10 JTF_VARCHAR2_TABLE_100

759: , p5_a6 JTF_VARCHAR2_TABLE_100
760: , p5_a7 JTF_VARCHAR2_TABLE_2000
761: , p5_a8 JTF_NUMBER_TABLE
762: , p5_a9 JTF_NUMBER_TABLE
763: , p5_a10 JTF_VARCHAR2_TABLE_100
764: , p5_a11 JTF_NUMBER_TABLE
765: , p5_a12 JTF_VARCHAR2_TABLE_100
766: , p5_a13 JTF_NUMBER_TABLE
767: , p5_a14 JTF_NUMBER_TABLE

Line 765: , p5_a12 JTF_VARCHAR2_TABLE_100

761: , p5_a8 JTF_NUMBER_TABLE
762: , p5_a9 JTF_NUMBER_TABLE
763: , p5_a10 JTF_VARCHAR2_TABLE_100
764: , p5_a11 JTF_NUMBER_TABLE
765: , p5_a12 JTF_VARCHAR2_TABLE_100
766: , p5_a13 JTF_NUMBER_TABLE
767: , p5_a14 JTF_NUMBER_TABLE
768: , p5_a15 JTF_NUMBER_TABLE
769: , p5_a16 JTF_NUMBER_TABLE

Line 770: , p5_a17 JTF_VARCHAR2_TABLE_100

766: , p5_a13 JTF_NUMBER_TABLE
767: , p5_a14 JTF_NUMBER_TABLE
768: , p5_a15 JTF_NUMBER_TABLE
769: , p5_a16 JTF_NUMBER_TABLE
770: , p5_a17 JTF_VARCHAR2_TABLE_100
771: , p5_a18 JTF_VARCHAR2_TABLE_500
772: , p5_a19 JTF_VARCHAR2_TABLE_500
773: , p5_a20 JTF_VARCHAR2_TABLE_500
774: , p5_a21 JTF_VARCHAR2_TABLE_500

Line 791: , p5_a38 JTF_VARCHAR2_TABLE_100

787: , p5_a34 JTF_DATE_TABLE
788: , p5_a35 JTF_NUMBER_TABLE
789: , p5_a36 JTF_DATE_TABLE
790: , p5_a37 JTF_NUMBER_TABLE
791: , p5_a38 JTF_VARCHAR2_TABLE_100
792: , p5_a39 JTF_VARCHAR2_TABLE_100
793: , p5_a40 JTF_NUMBER_TABLE
794: , p5_a41 JTF_DATE_TABLE
795: , p7_a0 out nocopy JTF_NUMBER_TABLE

Line 792: , p5_a39 JTF_VARCHAR2_TABLE_100

788: , p5_a35 JTF_NUMBER_TABLE
789: , p5_a36 JTF_DATE_TABLE
790: , p5_a37 JTF_NUMBER_TABLE
791: , p5_a38 JTF_VARCHAR2_TABLE_100
792: , p5_a39 JTF_VARCHAR2_TABLE_100
793: , p5_a40 JTF_NUMBER_TABLE
794: , p5_a41 JTF_DATE_TABLE
795: , p7_a0 out nocopy JTF_NUMBER_TABLE
796: , p6_a0 NUMBER := 0-1962.0724

Line 891: , p5_a5 JTF_VARCHAR2_TABLE_100

887: , p5_a1 JTF_NUMBER_TABLE
888: , p5_a2 JTF_NUMBER_TABLE
889: , p5_a3 JTF_NUMBER_TABLE
890: , p5_a4 JTF_NUMBER_TABLE
891: , p5_a5 JTF_VARCHAR2_TABLE_100
892: , p5_a6 JTF_NUMBER_TABLE
893: , p5_a7 JTF_VARCHAR2_TABLE_100
894: , p5_a8 JTF_VARCHAR2_TABLE_100
895: , p5_a9 JTF_VARCHAR2_TABLE_200

Line 893: , p5_a7 JTF_VARCHAR2_TABLE_100

889: , p5_a3 JTF_NUMBER_TABLE
890: , p5_a4 JTF_NUMBER_TABLE
891: , p5_a5 JTF_VARCHAR2_TABLE_100
892: , p5_a6 JTF_NUMBER_TABLE
893: , p5_a7 JTF_VARCHAR2_TABLE_100
894: , p5_a8 JTF_VARCHAR2_TABLE_100
895: , p5_a9 JTF_VARCHAR2_TABLE_200
896: , p5_a10 JTF_VARCHAR2_TABLE_100
897: , p5_a11 JTF_VARCHAR2_TABLE_100

Line 894: , p5_a8 JTF_VARCHAR2_TABLE_100

890: , p5_a4 JTF_NUMBER_TABLE
891: , p5_a5 JTF_VARCHAR2_TABLE_100
892: , p5_a6 JTF_NUMBER_TABLE
893: , p5_a7 JTF_VARCHAR2_TABLE_100
894: , p5_a8 JTF_VARCHAR2_TABLE_100
895: , p5_a9 JTF_VARCHAR2_TABLE_200
896: , p5_a10 JTF_VARCHAR2_TABLE_100
897: , p5_a11 JTF_VARCHAR2_TABLE_100
898: , p5_a12 JTF_VARCHAR2_TABLE_200

Line 896: , p5_a10 JTF_VARCHAR2_TABLE_100

892: , p5_a6 JTF_NUMBER_TABLE
893: , p5_a7 JTF_VARCHAR2_TABLE_100
894: , p5_a8 JTF_VARCHAR2_TABLE_100
895: , p5_a9 JTF_VARCHAR2_TABLE_200
896: , p5_a10 JTF_VARCHAR2_TABLE_100
897: , p5_a11 JTF_VARCHAR2_TABLE_100
898: , p5_a12 JTF_VARCHAR2_TABLE_200
899: , p5_a13 JTF_VARCHAR2_TABLE_100
900: , p5_a14 JTF_NUMBER_TABLE

Line 897: , p5_a11 JTF_VARCHAR2_TABLE_100

893: , p5_a7 JTF_VARCHAR2_TABLE_100
894: , p5_a8 JTF_VARCHAR2_TABLE_100
895: , p5_a9 JTF_VARCHAR2_TABLE_200
896: , p5_a10 JTF_VARCHAR2_TABLE_100
897: , p5_a11 JTF_VARCHAR2_TABLE_100
898: , p5_a12 JTF_VARCHAR2_TABLE_200
899: , p5_a13 JTF_VARCHAR2_TABLE_100
900: , p5_a14 JTF_NUMBER_TABLE
901: , p5_a15 JTF_VARCHAR2_TABLE_100

Line 899: , p5_a13 JTF_VARCHAR2_TABLE_100

895: , p5_a9 JTF_VARCHAR2_TABLE_200
896: , p5_a10 JTF_VARCHAR2_TABLE_100
897: , p5_a11 JTF_VARCHAR2_TABLE_100
898: , p5_a12 JTF_VARCHAR2_TABLE_200
899: , p5_a13 JTF_VARCHAR2_TABLE_100
900: , p5_a14 JTF_NUMBER_TABLE
901: , p5_a15 JTF_VARCHAR2_TABLE_100
902: , p5_a16 JTF_VARCHAR2_TABLE_100
903: , p5_a17 JTF_NUMBER_TABLE

Line 901: , p5_a15 JTF_VARCHAR2_TABLE_100

897: , p5_a11 JTF_VARCHAR2_TABLE_100
898: , p5_a12 JTF_VARCHAR2_TABLE_200
899: , p5_a13 JTF_VARCHAR2_TABLE_100
900: , p5_a14 JTF_NUMBER_TABLE
901: , p5_a15 JTF_VARCHAR2_TABLE_100
902: , p5_a16 JTF_VARCHAR2_TABLE_100
903: , p5_a17 JTF_NUMBER_TABLE
904: , p5_a18 JTF_NUMBER_TABLE
905: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 902: , p5_a16 JTF_VARCHAR2_TABLE_100

898: , p5_a12 JTF_VARCHAR2_TABLE_200
899: , p5_a13 JTF_VARCHAR2_TABLE_100
900: , p5_a14 JTF_NUMBER_TABLE
901: , p5_a15 JTF_VARCHAR2_TABLE_100
902: , p5_a16 JTF_VARCHAR2_TABLE_100
903: , p5_a17 JTF_NUMBER_TABLE
904: , p5_a18 JTF_NUMBER_TABLE
905: , p5_a19 JTF_VARCHAR2_TABLE_100
906: , p5_a20 JTF_VARCHAR2_TABLE_500

Line 905: , p5_a19 JTF_VARCHAR2_TABLE_100

901: , p5_a15 JTF_VARCHAR2_TABLE_100
902: , p5_a16 JTF_VARCHAR2_TABLE_100
903: , p5_a17 JTF_NUMBER_TABLE
904: , p5_a18 JTF_NUMBER_TABLE
905: , p5_a19 JTF_VARCHAR2_TABLE_100
906: , p5_a20 JTF_VARCHAR2_TABLE_500
907: , p5_a21 JTF_VARCHAR2_TABLE_500
908: , p5_a22 JTF_VARCHAR2_TABLE_500
909: , p5_a23 JTF_VARCHAR2_TABLE_500

Line 928: , p5_a42 JTF_VARCHAR2_TABLE_100

924: , p5_a38 JTF_DATE_TABLE
925: , p5_a39 JTF_NUMBER_TABLE
926: , p5_a40 JTF_NUMBER_TABLE
927: , p5_a41 JTF_NUMBER_TABLE
928: , p5_a42 JTF_VARCHAR2_TABLE_100
929: , p5_a43 JTF_NUMBER_TABLE
930: , p6_a0 out nocopy JTF_NUMBER_TABLE
931: , p6_a1 out nocopy JTF_NUMBER_TABLE
932: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 935: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

931: , p6_a1 out nocopy JTF_NUMBER_TABLE
932: , p6_a2 out nocopy JTF_NUMBER_TABLE
933: , p6_a3 out nocopy JTF_NUMBER_TABLE
934: , p6_a4 out nocopy JTF_NUMBER_TABLE
935: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
936: , p6_a6 out nocopy JTF_NUMBER_TABLE
937: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
938: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
939: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200

Line 937: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

933: , p6_a3 out nocopy JTF_NUMBER_TABLE
934: , p6_a4 out nocopy JTF_NUMBER_TABLE
935: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
936: , p6_a6 out nocopy JTF_NUMBER_TABLE
937: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
938: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
939: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200
940: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
941: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 938: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100

934: , p6_a4 out nocopy JTF_NUMBER_TABLE
935: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
936: , p6_a6 out nocopy JTF_NUMBER_TABLE
937: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
938: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
939: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200
940: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
941: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
942: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200

Line 940: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

936: , p6_a6 out nocopy JTF_NUMBER_TABLE
937: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
938: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
939: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200
940: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
941: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
942: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200
943: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
944: , p6_a14 out nocopy JTF_NUMBER_TABLE

Line 941: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100

937: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
938: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
939: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200
940: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
941: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
942: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200
943: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
944: , p6_a14 out nocopy JTF_NUMBER_TABLE
945: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 943: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

939: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200
940: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
941: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
942: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200
943: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
944: , p6_a14 out nocopy JTF_NUMBER_TABLE
945: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
946: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
947: , p6_a17 out nocopy JTF_NUMBER_TABLE

Line 945: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

941: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
942: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200
943: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
944: , p6_a14 out nocopy JTF_NUMBER_TABLE
945: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
946: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
947: , p6_a17 out nocopy JTF_NUMBER_TABLE
948: , p6_a18 out nocopy JTF_NUMBER_TABLE
949: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 946: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100

942: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_200
943: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
944: , p6_a14 out nocopy JTF_NUMBER_TABLE
945: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
946: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
947: , p6_a17 out nocopy JTF_NUMBER_TABLE
948: , p6_a18 out nocopy JTF_NUMBER_TABLE
949: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
950: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500

Line 949: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

945: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
946: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
947: , p6_a17 out nocopy JTF_NUMBER_TABLE
948: , p6_a18 out nocopy JTF_NUMBER_TABLE
949: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
950: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
951: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
952: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
953: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500

Line 972: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100

968: , p6_a38 out nocopy JTF_DATE_TABLE
969: , p6_a39 out nocopy JTF_NUMBER_TABLE
970: , p6_a40 out nocopy JTF_NUMBER_TABLE
971: , p6_a41 out nocopy JTF_NUMBER_TABLE
972: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
973: , p6_a43 out nocopy JTF_NUMBER_TABLE
974: );
975: end okl_split_asset_pvt_w;