APPS.OKL_LRV_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package okl_lrv_pvt_w as
2: /* $Header: OKLILRVS.pls 120.1 2005/09/30 11:00:39 asawanka noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_lrv_pvt.okl_lrvv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE

Line 12: , a9 JTF_VARCHAR2_TABLE_100

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

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_NUMBER_TABLE
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_DATE_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_DATE_TABLE

Line 24: , a21 JTF_VARCHAR2_TABLE_100

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

Line 44: , a2 out nocopy JTF_VARCHAR2_TABLE_100

40: , a37 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p1(t okl_lrv_pvt.okl_lrvv_tbl, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_DATE_TABLE
46: , a4 out nocopy JTF_DATE_TABLE
47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE

Line 51: , a9 out nocopy JTF_VARCHAR2_TABLE_100

47: , a5 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_NUMBER_TABLE
50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: , a10 out nocopy JTF_NUMBER_TABLE
53: , a11 out nocopy JTF_NUMBER_TABLE
54: , a12 out nocopy JTF_NUMBER_TABLE
55: , a13 out nocopy JTF_NUMBER_TABLE

Line 57: , a15 out nocopy JTF_VARCHAR2_TABLE_100

53: , a11 out nocopy JTF_NUMBER_TABLE
54: , a12 out nocopy JTF_NUMBER_TABLE
55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_NUMBER_TABLE
57: , a15 out nocopy JTF_VARCHAR2_TABLE_100
58: , a16 out nocopy JTF_NUMBER_TABLE
59: , a17 out nocopy JTF_DATE_TABLE
60: , a18 out nocopy JTF_NUMBER_TABLE
61: , a19 out nocopy JTF_DATE_TABLE

Line 63: , a21 out nocopy JTF_VARCHAR2_TABLE_100

59: , a17 out nocopy JTF_DATE_TABLE
60: , a18 out nocopy JTF_NUMBER_TABLE
61: , a19 out nocopy JTF_DATE_TABLE
62: , a20 out nocopy JTF_NUMBER_TABLE
63: , a21 out nocopy JTF_VARCHAR2_TABLE_100
64: , a22 out nocopy JTF_VARCHAR2_TABLE_500
65: , a23 out nocopy JTF_VARCHAR2_TABLE_500
66: , a24 out nocopy JTF_VARCHAR2_TABLE_500
67: , a25 out nocopy JTF_VARCHAR2_TABLE_500

Line 84: , a2 JTF_VARCHAR2_TABLE_100

80: );
81:
82: procedure rosetta_table_copy_in_p3(t out nocopy okl_lrv_pvt.okl_lrv_tbl, a0 JTF_NUMBER_TABLE
83: , a1 JTF_NUMBER_TABLE
84: , a2 JTF_VARCHAR2_TABLE_100
85: , a3 JTF_DATE_TABLE
86: , a4 JTF_DATE_TABLE
87: , a5 JTF_NUMBER_TABLE
88: , a6 JTF_NUMBER_TABLE

Line 91: , a9 JTF_VARCHAR2_TABLE_100

87: , a5 JTF_NUMBER_TABLE
88: , a6 JTF_NUMBER_TABLE
89: , a7 JTF_NUMBER_TABLE
90: , a8 JTF_NUMBER_TABLE
91: , a9 JTF_VARCHAR2_TABLE_100
92: , a10 JTF_NUMBER_TABLE
93: , a11 JTF_NUMBER_TABLE
94: , a12 JTF_NUMBER_TABLE
95: , a13 JTF_NUMBER_TABLE

Line 97: , a15 JTF_VARCHAR2_TABLE_100

93: , a11 JTF_NUMBER_TABLE
94: , a12 JTF_NUMBER_TABLE
95: , a13 JTF_NUMBER_TABLE
96: , a14 JTF_NUMBER_TABLE
97: , a15 JTF_VARCHAR2_TABLE_100
98: , a16 JTF_NUMBER_TABLE
99: , a17 JTF_DATE_TABLE
100: , a18 JTF_NUMBER_TABLE
101: , a19 JTF_DATE_TABLE

Line 103: , a21 JTF_VARCHAR2_TABLE_100

99: , a17 JTF_DATE_TABLE
100: , a18 JTF_NUMBER_TABLE
101: , a19 JTF_DATE_TABLE
102: , a20 JTF_NUMBER_TABLE
103: , a21 JTF_VARCHAR2_TABLE_100
104: , a22 JTF_VARCHAR2_TABLE_500
105: , a23 JTF_VARCHAR2_TABLE_500
106: , a24 JTF_VARCHAR2_TABLE_500
107: , a25 JTF_VARCHAR2_TABLE_500

Line 123: , a2 out nocopy JTF_VARCHAR2_TABLE_100

119: , a37 JTF_NUMBER_TABLE
120: );
121: procedure rosetta_table_copy_out_p3(t okl_lrv_pvt.okl_lrv_tbl, a0 out nocopy JTF_NUMBER_TABLE
122: , a1 out nocopy JTF_NUMBER_TABLE
123: , a2 out nocopy JTF_VARCHAR2_TABLE_100
124: , a3 out nocopy JTF_DATE_TABLE
125: , a4 out nocopy JTF_DATE_TABLE
126: , a5 out nocopy JTF_NUMBER_TABLE
127: , a6 out nocopy JTF_NUMBER_TABLE

Line 130: , a9 out nocopy JTF_VARCHAR2_TABLE_100

126: , a5 out nocopy JTF_NUMBER_TABLE
127: , a6 out nocopy JTF_NUMBER_TABLE
128: , a7 out nocopy JTF_NUMBER_TABLE
129: , a8 out nocopy JTF_NUMBER_TABLE
130: , a9 out nocopy JTF_VARCHAR2_TABLE_100
131: , a10 out nocopy JTF_NUMBER_TABLE
132: , a11 out nocopy JTF_NUMBER_TABLE
133: , a12 out nocopy JTF_NUMBER_TABLE
134: , a13 out nocopy JTF_NUMBER_TABLE

Line 136: , a15 out nocopy JTF_VARCHAR2_TABLE_100

132: , a11 out nocopy JTF_NUMBER_TABLE
133: , a12 out nocopy JTF_NUMBER_TABLE
134: , a13 out nocopy JTF_NUMBER_TABLE
135: , a14 out nocopy JTF_NUMBER_TABLE
136: , a15 out nocopy JTF_VARCHAR2_TABLE_100
137: , a16 out nocopy JTF_NUMBER_TABLE
138: , a17 out nocopy JTF_DATE_TABLE
139: , a18 out nocopy JTF_NUMBER_TABLE
140: , a19 out nocopy JTF_DATE_TABLE

Line 142: , a21 out nocopy JTF_VARCHAR2_TABLE_100

138: , a17 out nocopy JTF_DATE_TABLE
139: , a18 out nocopy JTF_NUMBER_TABLE
140: , a19 out nocopy JTF_DATE_TABLE
141: , a20 out nocopy JTF_NUMBER_TABLE
142: , a21 out nocopy JTF_VARCHAR2_TABLE_100
143: , a22 out nocopy JTF_VARCHAR2_TABLE_500
144: , a23 out nocopy JTF_VARCHAR2_TABLE_500
145: , a24 out nocopy JTF_VARCHAR2_TABLE_500
146: , a25 out nocopy JTF_VARCHAR2_TABLE_500

Line 250: , p5_a2 JTF_VARCHAR2_TABLE_100

246: , x_msg_count out nocopy NUMBER
247: , x_msg_data out nocopy VARCHAR2
248: , p5_a0 JTF_NUMBER_TABLE
249: , p5_a1 JTF_NUMBER_TABLE
250: , p5_a2 JTF_VARCHAR2_TABLE_100
251: , p5_a3 JTF_DATE_TABLE
252: , p5_a4 JTF_DATE_TABLE
253: , p5_a5 JTF_NUMBER_TABLE
254: , p5_a6 JTF_NUMBER_TABLE

Line 257: , p5_a9 JTF_VARCHAR2_TABLE_100

253: , p5_a5 JTF_NUMBER_TABLE
254: , p5_a6 JTF_NUMBER_TABLE
255: , p5_a7 JTF_NUMBER_TABLE
256: , p5_a8 JTF_NUMBER_TABLE
257: , p5_a9 JTF_VARCHAR2_TABLE_100
258: , p5_a10 JTF_NUMBER_TABLE
259: , p5_a11 JTF_NUMBER_TABLE
260: , p5_a12 JTF_NUMBER_TABLE
261: , p5_a13 JTF_NUMBER_TABLE

Line 263: , p5_a15 JTF_VARCHAR2_TABLE_100

259: , p5_a11 JTF_NUMBER_TABLE
260: , p5_a12 JTF_NUMBER_TABLE
261: , p5_a13 JTF_NUMBER_TABLE
262: , p5_a14 JTF_NUMBER_TABLE
263: , p5_a15 JTF_VARCHAR2_TABLE_100
264: , p5_a16 JTF_NUMBER_TABLE
265: , p5_a17 JTF_DATE_TABLE
266: , p5_a18 JTF_NUMBER_TABLE
267: , p5_a19 JTF_DATE_TABLE

Line 269: , p5_a21 JTF_VARCHAR2_TABLE_100

265: , p5_a17 JTF_DATE_TABLE
266: , p5_a18 JTF_NUMBER_TABLE
267: , p5_a19 JTF_DATE_TABLE
268: , p5_a20 JTF_NUMBER_TABLE
269: , p5_a21 JTF_VARCHAR2_TABLE_100
270: , p5_a22 JTF_VARCHAR2_TABLE_500
271: , p5_a23 JTF_VARCHAR2_TABLE_500
272: , p5_a24 JTF_VARCHAR2_TABLE_500
273: , p5_a25 JTF_VARCHAR2_TABLE_500

Line 288: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

284: , p5_a36 JTF_VARCHAR2_TABLE_500
285: , p5_a37 JTF_NUMBER_TABLE
286: , p6_a0 out nocopy JTF_NUMBER_TABLE
287: , p6_a1 out nocopy JTF_NUMBER_TABLE
288: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
289: , p6_a3 out nocopy JTF_DATE_TABLE
290: , p6_a4 out nocopy JTF_DATE_TABLE
291: , p6_a5 out nocopy JTF_NUMBER_TABLE
292: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 295: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

291: , p6_a5 out nocopy JTF_NUMBER_TABLE
292: , p6_a6 out nocopy JTF_NUMBER_TABLE
293: , p6_a7 out nocopy JTF_NUMBER_TABLE
294: , p6_a8 out nocopy JTF_NUMBER_TABLE
295: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
296: , p6_a10 out nocopy JTF_NUMBER_TABLE
297: , p6_a11 out nocopy JTF_NUMBER_TABLE
298: , p6_a12 out nocopy JTF_NUMBER_TABLE
299: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 301: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

297: , p6_a11 out nocopy JTF_NUMBER_TABLE
298: , p6_a12 out nocopy JTF_NUMBER_TABLE
299: , p6_a13 out nocopy JTF_NUMBER_TABLE
300: , p6_a14 out nocopy JTF_NUMBER_TABLE
301: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
302: , p6_a16 out nocopy JTF_NUMBER_TABLE
303: , p6_a17 out nocopy JTF_DATE_TABLE
304: , p6_a18 out nocopy JTF_NUMBER_TABLE
305: , p6_a19 out nocopy JTF_DATE_TABLE

Line 307: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100

303: , p6_a17 out nocopy JTF_DATE_TABLE
304: , p6_a18 out nocopy JTF_NUMBER_TABLE
305: , p6_a19 out nocopy JTF_DATE_TABLE
306: , p6_a20 out nocopy JTF_NUMBER_TABLE
307: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
308: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
309: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
310: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
311: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500

Line 414: , p5_a2 JTF_VARCHAR2_TABLE_100

410: , x_msg_count out nocopy NUMBER
411: , x_msg_data out nocopy VARCHAR2
412: , p5_a0 JTF_NUMBER_TABLE
413: , p5_a1 JTF_NUMBER_TABLE
414: , p5_a2 JTF_VARCHAR2_TABLE_100
415: , p5_a3 JTF_DATE_TABLE
416: , p5_a4 JTF_DATE_TABLE
417: , p5_a5 JTF_NUMBER_TABLE
418: , p5_a6 JTF_NUMBER_TABLE

Line 421: , p5_a9 JTF_VARCHAR2_TABLE_100

417: , p5_a5 JTF_NUMBER_TABLE
418: , p5_a6 JTF_NUMBER_TABLE
419: , p5_a7 JTF_NUMBER_TABLE
420: , p5_a8 JTF_NUMBER_TABLE
421: , p5_a9 JTF_VARCHAR2_TABLE_100
422: , p5_a10 JTF_NUMBER_TABLE
423: , p5_a11 JTF_NUMBER_TABLE
424: , p5_a12 JTF_NUMBER_TABLE
425: , p5_a13 JTF_NUMBER_TABLE

Line 427: , p5_a15 JTF_VARCHAR2_TABLE_100

423: , p5_a11 JTF_NUMBER_TABLE
424: , p5_a12 JTF_NUMBER_TABLE
425: , p5_a13 JTF_NUMBER_TABLE
426: , p5_a14 JTF_NUMBER_TABLE
427: , p5_a15 JTF_VARCHAR2_TABLE_100
428: , p5_a16 JTF_NUMBER_TABLE
429: , p5_a17 JTF_DATE_TABLE
430: , p5_a18 JTF_NUMBER_TABLE
431: , p5_a19 JTF_DATE_TABLE

Line 433: , p5_a21 JTF_VARCHAR2_TABLE_100

429: , p5_a17 JTF_DATE_TABLE
430: , p5_a18 JTF_NUMBER_TABLE
431: , p5_a19 JTF_DATE_TABLE
432: , p5_a20 JTF_NUMBER_TABLE
433: , p5_a21 JTF_VARCHAR2_TABLE_100
434: , p5_a22 JTF_VARCHAR2_TABLE_500
435: , p5_a23 JTF_VARCHAR2_TABLE_500
436: , p5_a24 JTF_VARCHAR2_TABLE_500
437: , p5_a25 JTF_VARCHAR2_TABLE_500

Line 452: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

448: , p5_a36 JTF_VARCHAR2_TABLE_500
449: , p5_a37 JTF_NUMBER_TABLE
450: , p6_a0 out nocopy JTF_NUMBER_TABLE
451: , p6_a1 out nocopy JTF_NUMBER_TABLE
452: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
453: , p6_a3 out nocopy JTF_DATE_TABLE
454: , p6_a4 out nocopy JTF_DATE_TABLE
455: , p6_a5 out nocopy JTF_NUMBER_TABLE
456: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 459: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100

455: , p6_a5 out nocopy JTF_NUMBER_TABLE
456: , p6_a6 out nocopy JTF_NUMBER_TABLE
457: , p6_a7 out nocopy JTF_NUMBER_TABLE
458: , p6_a8 out nocopy JTF_NUMBER_TABLE
459: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
460: , p6_a10 out nocopy JTF_NUMBER_TABLE
461: , p6_a11 out nocopy JTF_NUMBER_TABLE
462: , p6_a12 out nocopy JTF_NUMBER_TABLE
463: , p6_a13 out nocopy JTF_NUMBER_TABLE

Line 465: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

461: , p6_a11 out nocopy JTF_NUMBER_TABLE
462: , p6_a12 out nocopy JTF_NUMBER_TABLE
463: , p6_a13 out nocopy JTF_NUMBER_TABLE
464: , p6_a14 out nocopy JTF_NUMBER_TABLE
465: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
466: , p6_a16 out nocopy JTF_NUMBER_TABLE
467: , p6_a17 out nocopy JTF_DATE_TABLE
468: , p6_a18 out nocopy JTF_NUMBER_TABLE
469: , p6_a19 out nocopy JTF_DATE_TABLE

Line 471: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100

467: , p6_a17 out nocopy JTF_DATE_TABLE
468: , p6_a18 out nocopy JTF_NUMBER_TABLE
469: , p6_a19 out nocopy JTF_DATE_TABLE
470: , p6_a20 out nocopy JTF_NUMBER_TABLE
471: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
472: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
473: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
474: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
475: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500

Line 540: , p5_a2 JTF_VARCHAR2_TABLE_100

536: , x_msg_count out nocopy NUMBER
537: , x_msg_data out nocopy VARCHAR2
538: , p5_a0 JTF_NUMBER_TABLE
539: , p5_a1 JTF_NUMBER_TABLE
540: , p5_a2 JTF_VARCHAR2_TABLE_100
541: , p5_a3 JTF_DATE_TABLE
542: , p5_a4 JTF_DATE_TABLE
543: , p5_a5 JTF_NUMBER_TABLE
544: , p5_a6 JTF_NUMBER_TABLE

Line 547: , p5_a9 JTF_VARCHAR2_TABLE_100

543: , p5_a5 JTF_NUMBER_TABLE
544: , p5_a6 JTF_NUMBER_TABLE
545: , p5_a7 JTF_NUMBER_TABLE
546: , p5_a8 JTF_NUMBER_TABLE
547: , p5_a9 JTF_VARCHAR2_TABLE_100
548: , p5_a10 JTF_NUMBER_TABLE
549: , p5_a11 JTF_NUMBER_TABLE
550: , p5_a12 JTF_NUMBER_TABLE
551: , p5_a13 JTF_NUMBER_TABLE

Line 553: , p5_a15 JTF_VARCHAR2_TABLE_100

549: , p5_a11 JTF_NUMBER_TABLE
550: , p5_a12 JTF_NUMBER_TABLE
551: , p5_a13 JTF_NUMBER_TABLE
552: , p5_a14 JTF_NUMBER_TABLE
553: , p5_a15 JTF_VARCHAR2_TABLE_100
554: , p5_a16 JTF_NUMBER_TABLE
555: , p5_a17 JTF_DATE_TABLE
556: , p5_a18 JTF_NUMBER_TABLE
557: , p5_a19 JTF_DATE_TABLE

Line 559: , p5_a21 JTF_VARCHAR2_TABLE_100

555: , p5_a17 JTF_DATE_TABLE
556: , p5_a18 JTF_NUMBER_TABLE
557: , p5_a19 JTF_DATE_TABLE
558: , p5_a20 JTF_NUMBER_TABLE
559: , p5_a21 JTF_VARCHAR2_TABLE_100
560: , p5_a22 JTF_VARCHAR2_TABLE_500
561: , p5_a23 JTF_VARCHAR2_TABLE_500
562: , p5_a24 JTF_VARCHAR2_TABLE_500
563: , p5_a25 JTF_VARCHAR2_TABLE_500