DBA Data[Home] [Help]

APPS.OKL_TAS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package okl_tas_pvt_w as
2: /* $Header: OKLITASS.pls 120.2 2007/11/06 07:36:24 veramach ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_tas_pvt.tas_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_500
9: , a6 JTF_VARCHAR2_TABLE_500

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p2(t out nocopy okl_tas_pvt.tas_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_500
9: , a6 JTF_VARCHAR2_TABLE_500
10: , a7 JTF_VARCHAR2_TABLE_500
11: , a8 JTF_VARCHAR2_TABLE_500

Line 28: , a25 JTF_VARCHAR2_TABLE_100

24: , a21 JTF_DATE_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_VARCHAR2_TABLE_4000

Line 41: , a2 out nocopy JTF_VARCHAR2_TABLE_100

37: , a34 JTF_DATE_TABLE
38: );
39: procedure rosetta_table_copy_out_p2(t okl_tas_pvt.tas_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_NUMBER_TABLE
41: , a2 out nocopy JTF_VARCHAR2_TABLE_100
42: , a3 out nocopy JTF_NUMBER_TABLE
43: , a4 out nocopy JTF_VARCHAR2_TABLE_100
44: , a5 out nocopy JTF_VARCHAR2_TABLE_500
45: , a6 out nocopy JTF_VARCHAR2_TABLE_500

Line 43: , a4 out nocopy JTF_VARCHAR2_TABLE_100

39: procedure rosetta_table_copy_out_p2(t okl_tas_pvt.tas_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
40: , a1 out nocopy JTF_NUMBER_TABLE
41: , a2 out nocopy JTF_VARCHAR2_TABLE_100
42: , a3 out nocopy JTF_NUMBER_TABLE
43: , a4 out nocopy JTF_VARCHAR2_TABLE_100
44: , a5 out nocopy JTF_VARCHAR2_TABLE_500
45: , a6 out nocopy JTF_VARCHAR2_TABLE_500
46: , a7 out nocopy JTF_VARCHAR2_TABLE_500
47: , a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 64: , a25 out nocopy JTF_VARCHAR2_TABLE_100

60: , a21 out nocopy JTF_DATE_TABLE
61: , a22 out nocopy JTF_NUMBER_TABLE
62: , a23 out nocopy JTF_DATE_TABLE
63: , a24 out nocopy JTF_NUMBER_TABLE
64: , a25 out nocopy JTF_VARCHAR2_TABLE_100
65: , a26 out nocopy JTF_NUMBER_TABLE
66: , a27 out nocopy JTF_DATE_TABLE
67: , a28 out nocopy JTF_NUMBER_TABLE
68: , a29 out nocopy JTF_VARCHAR2_TABLE_4000

Line 79: , a3 JTF_VARCHAR2_TABLE_100

75:
76: procedure rosetta_table_copy_in_p5(t out nocopy okl_tas_pvt.tasv_tbl_type, a0 JTF_NUMBER_TABLE
77: , a1 JTF_NUMBER_TABLE
78: , a2 JTF_NUMBER_TABLE
79: , a3 JTF_VARCHAR2_TABLE_100
80: , a4 JTF_VARCHAR2_TABLE_500
81: , a5 JTF_VARCHAR2_TABLE_500
82: , a6 JTF_VARCHAR2_TABLE_500
83: , a7 JTF_VARCHAR2_TABLE_500

Line 95: , a19 JTF_VARCHAR2_TABLE_100

91: , a15 JTF_VARCHAR2_TABLE_500
92: , a16 JTF_VARCHAR2_TABLE_500
93: , a17 JTF_VARCHAR2_TABLE_500
94: , a18 JTF_VARCHAR2_TABLE_500
95: , a19 JTF_VARCHAR2_TABLE_100
96: , a20 JTF_NUMBER_TABLE
97: , a21 JTF_DATE_TABLE
98: , a22 JTF_NUMBER_TABLE
99: , a23 JTF_DATE_TABLE

Line 101: , a25 JTF_VARCHAR2_TABLE_100

97: , a21 JTF_DATE_TABLE
98: , a22 JTF_NUMBER_TABLE
99: , a23 JTF_DATE_TABLE
100: , a24 JTF_NUMBER_TABLE
101: , a25 JTF_VARCHAR2_TABLE_100
102: , a26 JTF_NUMBER_TABLE
103: , a27 JTF_DATE_TABLE
104: , a28 JTF_NUMBER_TABLE
105: , a29 JTF_VARCHAR2_TABLE_4000

Line 115: , a3 out nocopy JTF_VARCHAR2_TABLE_100

111: );
112: procedure rosetta_table_copy_out_p5(t okl_tas_pvt.tasv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
113: , a1 out nocopy JTF_NUMBER_TABLE
114: , a2 out nocopy JTF_NUMBER_TABLE
115: , a3 out nocopy JTF_VARCHAR2_TABLE_100
116: , a4 out nocopy JTF_VARCHAR2_TABLE_500
117: , a5 out nocopy JTF_VARCHAR2_TABLE_500
118: , a6 out nocopy JTF_VARCHAR2_TABLE_500
119: , a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 131: , a19 out nocopy JTF_VARCHAR2_TABLE_100

127: , a15 out nocopy JTF_VARCHAR2_TABLE_500
128: , a16 out nocopy JTF_VARCHAR2_TABLE_500
129: , a17 out nocopy JTF_VARCHAR2_TABLE_500
130: , a18 out nocopy JTF_VARCHAR2_TABLE_500
131: , a19 out nocopy JTF_VARCHAR2_TABLE_100
132: , a20 out nocopy JTF_NUMBER_TABLE
133: , a21 out nocopy JTF_DATE_TABLE
134: , a22 out nocopy JTF_NUMBER_TABLE
135: , a23 out nocopy JTF_DATE_TABLE

Line 137: , a25 out nocopy JTF_VARCHAR2_TABLE_100

133: , a21 out nocopy JTF_DATE_TABLE
134: , a22 out nocopy JTF_NUMBER_TABLE
135: , a23 out nocopy JTF_DATE_TABLE
136: , a24 out nocopy JTF_NUMBER_TABLE
137: , a25 out nocopy JTF_VARCHAR2_TABLE_100
138: , a26 out nocopy JTF_NUMBER_TABLE
139: , a27 out nocopy JTF_DATE_TABLE
140: , a28 out nocopy JTF_NUMBER_TABLE
141: , a29 out nocopy JTF_VARCHAR2_TABLE_4000

Line 233: , p5_a3 JTF_VARCHAR2_TABLE_100

229: , x_msg_data out nocopy VARCHAR2
230: , p5_a0 JTF_NUMBER_TABLE
231: , p5_a1 JTF_NUMBER_TABLE
232: , p5_a2 JTF_NUMBER_TABLE
233: , p5_a3 JTF_VARCHAR2_TABLE_100
234: , p5_a4 JTF_VARCHAR2_TABLE_500
235: , p5_a5 JTF_VARCHAR2_TABLE_500
236: , p5_a6 JTF_VARCHAR2_TABLE_500
237: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 249: , p5_a19 JTF_VARCHAR2_TABLE_100

245: , p5_a15 JTF_VARCHAR2_TABLE_500
246: , p5_a16 JTF_VARCHAR2_TABLE_500
247: , p5_a17 JTF_VARCHAR2_TABLE_500
248: , p5_a18 JTF_VARCHAR2_TABLE_500
249: , p5_a19 JTF_VARCHAR2_TABLE_100
250: , p5_a20 JTF_NUMBER_TABLE
251: , p5_a21 JTF_DATE_TABLE
252: , p5_a22 JTF_NUMBER_TABLE
253: , p5_a23 JTF_DATE_TABLE

Line 255: , p5_a25 JTF_VARCHAR2_TABLE_100

251: , p5_a21 JTF_DATE_TABLE
252: , p5_a22 JTF_NUMBER_TABLE
253: , p5_a23 JTF_DATE_TABLE
254: , p5_a24 JTF_NUMBER_TABLE
255: , p5_a25 JTF_VARCHAR2_TABLE_100
256: , p5_a26 JTF_NUMBER_TABLE
257: , p5_a27 JTF_DATE_TABLE
258: , p5_a28 JTF_NUMBER_TABLE
259: , p5_a29 JTF_VARCHAR2_TABLE_4000

Line 268: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

264: , p5_a34 JTF_DATE_TABLE
265: , p6_a0 out nocopy JTF_NUMBER_TABLE
266: , p6_a1 out nocopy JTF_NUMBER_TABLE
267: , p6_a2 out nocopy JTF_NUMBER_TABLE
268: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
269: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
270: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
271: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
272: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 284: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

280: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
281: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
282: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
283: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
284: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
285: , p6_a20 out nocopy JTF_NUMBER_TABLE
286: , p6_a21 out nocopy JTF_DATE_TABLE
287: , p6_a22 out nocopy JTF_NUMBER_TABLE
288: , p6_a23 out nocopy JTF_DATE_TABLE

Line 290: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100

286: , p6_a21 out nocopy JTF_DATE_TABLE
287: , p6_a22 out nocopy JTF_NUMBER_TABLE
288: , p6_a23 out nocopy JTF_DATE_TABLE
289: , p6_a24 out nocopy JTF_NUMBER_TABLE
290: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
291: , p6_a26 out nocopy JTF_NUMBER_TABLE
292: , p6_a27 out nocopy JTF_DATE_TABLE
293: , p6_a28 out nocopy JTF_NUMBER_TABLE
294: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000

Line 350: , p5_a3 JTF_VARCHAR2_TABLE_100

346: , x_msg_data out nocopy VARCHAR2
347: , p5_a0 JTF_NUMBER_TABLE
348: , p5_a1 JTF_NUMBER_TABLE
349: , p5_a2 JTF_NUMBER_TABLE
350: , p5_a3 JTF_VARCHAR2_TABLE_100
351: , p5_a4 JTF_VARCHAR2_TABLE_500
352: , p5_a5 JTF_VARCHAR2_TABLE_500
353: , p5_a6 JTF_VARCHAR2_TABLE_500
354: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 366: , p5_a19 JTF_VARCHAR2_TABLE_100

362: , p5_a15 JTF_VARCHAR2_TABLE_500
363: , p5_a16 JTF_VARCHAR2_TABLE_500
364: , p5_a17 JTF_VARCHAR2_TABLE_500
365: , p5_a18 JTF_VARCHAR2_TABLE_500
366: , p5_a19 JTF_VARCHAR2_TABLE_100
367: , p5_a20 JTF_NUMBER_TABLE
368: , p5_a21 JTF_DATE_TABLE
369: , p5_a22 JTF_NUMBER_TABLE
370: , p5_a23 JTF_DATE_TABLE

Line 372: , p5_a25 JTF_VARCHAR2_TABLE_100

368: , p5_a21 JTF_DATE_TABLE
369: , p5_a22 JTF_NUMBER_TABLE
370: , p5_a23 JTF_DATE_TABLE
371: , p5_a24 JTF_NUMBER_TABLE
372: , p5_a25 JTF_VARCHAR2_TABLE_100
373: , p5_a26 JTF_NUMBER_TABLE
374: , p5_a27 JTF_DATE_TABLE
375: , p5_a28 JTF_NUMBER_TABLE
376: , p5_a29 JTF_VARCHAR2_TABLE_4000

Line 467: , p5_a3 JTF_VARCHAR2_TABLE_100

463: , x_msg_data out nocopy VARCHAR2
464: , p5_a0 JTF_NUMBER_TABLE
465: , p5_a1 JTF_NUMBER_TABLE
466: , p5_a2 JTF_NUMBER_TABLE
467: , p5_a3 JTF_VARCHAR2_TABLE_100
468: , p5_a4 JTF_VARCHAR2_TABLE_500
469: , p5_a5 JTF_VARCHAR2_TABLE_500
470: , p5_a6 JTF_VARCHAR2_TABLE_500
471: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 483: , p5_a19 JTF_VARCHAR2_TABLE_100

479: , p5_a15 JTF_VARCHAR2_TABLE_500
480: , p5_a16 JTF_VARCHAR2_TABLE_500
481: , p5_a17 JTF_VARCHAR2_TABLE_500
482: , p5_a18 JTF_VARCHAR2_TABLE_500
483: , p5_a19 JTF_VARCHAR2_TABLE_100
484: , p5_a20 JTF_NUMBER_TABLE
485: , p5_a21 JTF_DATE_TABLE
486: , p5_a22 JTF_NUMBER_TABLE
487: , p5_a23 JTF_DATE_TABLE

Line 489: , p5_a25 JTF_VARCHAR2_TABLE_100

485: , p5_a21 JTF_DATE_TABLE
486: , p5_a22 JTF_NUMBER_TABLE
487: , p5_a23 JTF_DATE_TABLE
488: , p5_a24 JTF_NUMBER_TABLE
489: , p5_a25 JTF_VARCHAR2_TABLE_100
490: , p5_a26 JTF_NUMBER_TABLE
491: , p5_a27 JTF_DATE_TABLE
492: , p5_a28 JTF_NUMBER_TABLE
493: , p5_a29 JTF_VARCHAR2_TABLE_4000

Line 502: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

498: , p5_a34 JTF_DATE_TABLE
499: , p6_a0 out nocopy JTF_NUMBER_TABLE
500: , p6_a1 out nocopy JTF_NUMBER_TABLE
501: , p6_a2 out nocopy JTF_NUMBER_TABLE
502: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
503: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_500
504: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
505: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
506: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 518: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

514: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
515: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
516: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
517: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
518: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
519: , p6_a20 out nocopy JTF_NUMBER_TABLE
520: , p6_a21 out nocopy JTF_DATE_TABLE
521: , p6_a22 out nocopy JTF_NUMBER_TABLE
522: , p6_a23 out nocopy JTF_DATE_TABLE

Line 524: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100

520: , p6_a21 out nocopy JTF_DATE_TABLE
521: , p6_a22 out nocopy JTF_NUMBER_TABLE
522: , p6_a23 out nocopy JTF_DATE_TABLE
523: , p6_a24 out nocopy JTF_NUMBER_TABLE
524: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
525: , p6_a26 out nocopy JTF_NUMBER_TABLE
526: , p6_a27 out nocopy JTF_DATE_TABLE
527: , p6_a28 out nocopy JTF_NUMBER_TABLE
528: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_4000

Line 584: , p5_a3 JTF_VARCHAR2_TABLE_100

580: , x_msg_data out nocopy VARCHAR2
581: , p5_a0 JTF_NUMBER_TABLE
582: , p5_a1 JTF_NUMBER_TABLE
583: , p5_a2 JTF_NUMBER_TABLE
584: , p5_a3 JTF_VARCHAR2_TABLE_100
585: , p5_a4 JTF_VARCHAR2_TABLE_500
586: , p5_a5 JTF_VARCHAR2_TABLE_500
587: , p5_a6 JTF_VARCHAR2_TABLE_500
588: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 600: , p5_a19 JTF_VARCHAR2_TABLE_100

596: , p5_a15 JTF_VARCHAR2_TABLE_500
597: , p5_a16 JTF_VARCHAR2_TABLE_500
598: , p5_a17 JTF_VARCHAR2_TABLE_500
599: , p5_a18 JTF_VARCHAR2_TABLE_500
600: , p5_a19 JTF_VARCHAR2_TABLE_100
601: , p5_a20 JTF_NUMBER_TABLE
602: , p5_a21 JTF_DATE_TABLE
603: , p5_a22 JTF_NUMBER_TABLE
604: , p5_a23 JTF_DATE_TABLE

Line 606: , p5_a25 JTF_VARCHAR2_TABLE_100

602: , p5_a21 JTF_DATE_TABLE
603: , p5_a22 JTF_NUMBER_TABLE
604: , p5_a23 JTF_DATE_TABLE
605: , p5_a24 JTF_NUMBER_TABLE
606: , p5_a25 JTF_VARCHAR2_TABLE_100
607: , p5_a26 JTF_NUMBER_TABLE
608: , p5_a27 JTF_DATE_TABLE
609: , p5_a28 JTF_NUMBER_TABLE
610: , p5_a29 JTF_VARCHAR2_TABLE_4000

Line 666: , p5_a3 JTF_VARCHAR2_TABLE_100

662: , x_msg_data out nocopy VARCHAR2
663: , p5_a0 JTF_NUMBER_TABLE
664: , p5_a1 JTF_NUMBER_TABLE
665: , p5_a2 JTF_NUMBER_TABLE
666: , p5_a3 JTF_VARCHAR2_TABLE_100
667: , p5_a4 JTF_VARCHAR2_TABLE_500
668: , p5_a5 JTF_VARCHAR2_TABLE_500
669: , p5_a6 JTF_VARCHAR2_TABLE_500
670: , p5_a7 JTF_VARCHAR2_TABLE_500

Line 682: , p5_a19 JTF_VARCHAR2_TABLE_100

678: , p5_a15 JTF_VARCHAR2_TABLE_500
679: , p5_a16 JTF_VARCHAR2_TABLE_500
680: , p5_a17 JTF_VARCHAR2_TABLE_500
681: , p5_a18 JTF_VARCHAR2_TABLE_500
682: , p5_a19 JTF_VARCHAR2_TABLE_100
683: , p5_a20 JTF_NUMBER_TABLE
684: , p5_a21 JTF_DATE_TABLE
685: , p5_a22 JTF_NUMBER_TABLE
686: , p5_a23 JTF_DATE_TABLE

Line 688: , p5_a25 JTF_VARCHAR2_TABLE_100

684: , p5_a21 JTF_DATE_TABLE
685: , p5_a22 JTF_NUMBER_TABLE
686: , p5_a23 JTF_DATE_TABLE
687: , p5_a24 JTF_NUMBER_TABLE
688: , p5_a25 JTF_VARCHAR2_TABLE_100
689: , p5_a26 JTF_NUMBER_TABLE
690: , p5_a27 JTF_DATE_TABLE
691: , p5_a28 JTF_NUMBER_TABLE
692: , p5_a29 JTF_VARCHAR2_TABLE_4000