DBA Data[Home] [Help]

APPS.OKL_RAS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 16: , a13 JTF_VARCHAR2_TABLE_100

12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_VARCHAR2_TABLE_300
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_500
18: , a15 JTF_VARCHAR2_TABLE_500
19: , a16 JTF_VARCHAR2_TABLE_500
20: , a17 JTF_VARCHAR2_TABLE_500

Line 37: , a34 JTF_VARCHAR2_TABLE_100

33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_DATE_TABLE

Line 38: , a35 JTF_VARCHAR2_TABLE_100

34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_DATE_TABLE
42: );

Line 39: , a36 JTF_VARCHAR2_TABLE_100

35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_DATE_TABLE
42: );
43: procedure rosetta_table_copy_out_p2(t okl_ras_pvt.ras_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 56: , a13 out nocopy JTF_VARCHAR2_TABLE_100

52: , a9 out nocopy JTF_NUMBER_TABLE
53: , a10 out nocopy JTF_DATE_TABLE
54: , a11 out nocopy JTF_VARCHAR2_TABLE_300
55: , a12 out nocopy JTF_NUMBER_TABLE
56: , a13 out nocopy JTF_VARCHAR2_TABLE_100
57: , a14 out nocopy JTF_VARCHAR2_TABLE_500
58: , a15 out nocopy JTF_VARCHAR2_TABLE_500
59: , a16 out nocopy JTF_VARCHAR2_TABLE_500
60: , a17 out nocopy JTF_VARCHAR2_TABLE_500

Line 77: , a34 out nocopy JTF_VARCHAR2_TABLE_100

73: , a30 out nocopy JTF_DATE_TABLE
74: , a31 out nocopy JTF_NUMBER_TABLE
75: , a32 out nocopy JTF_DATE_TABLE
76: , a33 out nocopy JTF_NUMBER_TABLE
77: , a34 out nocopy JTF_VARCHAR2_TABLE_100
78: , a35 out nocopy JTF_VARCHAR2_TABLE_100
79: , a36 out nocopy JTF_VARCHAR2_TABLE_100
80: , a37 out nocopy JTF_NUMBER_TABLE
81: , a38 out nocopy JTF_DATE_TABLE

Line 78: , a35 out nocopy JTF_VARCHAR2_TABLE_100

74: , a31 out nocopy JTF_NUMBER_TABLE
75: , a32 out nocopy JTF_DATE_TABLE
76: , a33 out nocopy JTF_NUMBER_TABLE
77: , a34 out nocopy JTF_VARCHAR2_TABLE_100
78: , a35 out nocopy JTF_VARCHAR2_TABLE_100
79: , a36 out nocopy JTF_VARCHAR2_TABLE_100
80: , a37 out nocopy JTF_NUMBER_TABLE
81: , a38 out nocopy JTF_DATE_TABLE
82: );

Line 79: , a36 out nocopy JTF_VARCHAR2_TABLE_100

75: , a32 out nocopy JTF_DATE_TABLE
76: , a33 out nocopy JTF_NUMBER_TABLE
77: , a34 out nocopy JTF_VARCHAR2_TABLE_100
78: , a35 out nocopy JTF_VARCHAR2_TABLE_100
79: , a36 out nocopy JTF_VARCHAR2_TABLE_100
80: , a37 out nocopy JTF_NUMBER_TABLE
81: , a38 out nocopy JTF_DATE_TABLE
82: );
83:

Line 85: , a1 JTF_VARCHAR2_TABLE_100

81: , a38 out nocopy JTF_DATE_TABLE
82: );
83:
84: procedure rosetta_table_copy_in_p5(t out nocopy okl_ras_pvt.oklrelocateassetstltbltype, a0 JTF_NUMBER_TABLE
85: , a1 JTF_VARCHAR2_TABLE_100
86: , a2 JTF_VARCHAR2_TABLE_100
87: , a3 JTF_VARCHAR2_TABLE_100
88: , a4 JTF_VARCHAR2_TABLE_2000
89: , a5 JTF_NUMBER_TABLE

Line 86: , a2 JTF_VARCHAR2_TABLE_100

82: );
83:
84: procedure rosetta_table_copy_in_p5(t out nocopy okl_ras_pvt.oklrelocateassetstltbltype, a0 JTF_NUMBER_TABLE
85: , a1 JTF_VARCHAR2_TABLE_100
86: , a2 JTF_VARCHAR2_TABLE_100
87: , a3 JTF_VARCHAR2_TABLE_100
88: , a4 JTF_VARCHAR2_TABLE_2000
89: , a5 JTF_NUMBER_TABLE
90: , a6 JTF_DATE_TABLE

Line 87: , a3 JTF_VARCHAR2_TABLE_100

83:
84: procedure rosetta_table_copy_in_p5(t out nocopy okl_ras_pvt.oklrelocateassetstltbltype, a0 JTF_NUMBER_TABLE
85: , a1 JTF_VARCHAR2_TABLE_100
86: , a2 JTF_VARCHAR2_TABLE_100
87: , a3 JTF_VARCHAR2_TABLE_100
88: , a4 JTF_VARCHAR2_TABLE_2000
89: , a5 JTF_NUMBER_TABLE
90: , a6 JTF_DATE_TABLE
91: , a7 JTF_NUMBER_TABLE

Line 96: , a1 out nocopy JTF_VARCHAR2_TABLE_100

92: , a8 JTF_DATE_TABLE
93: , a9 JTF_NUMBER_TABLE
94: );
95: procedure rosetta_table_copy_out_p5(t okl_ras_pvt.oklrelocateassetstltbltype, a0 out nocopy JTF_NUMBER_TABLE
96: , a1 out nocopy JTF_VARCHAR2_TABLE_100
97: , a2 out nocopy JTF_VARCHAR2_TABLE_100
98: , a3 out nocopy JTF_VARCHAR2_TABLE_100
99: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
100: , a5 out nocopy JTF_NUMBER_TABLE

Line 97: , a2 out nocopy JTF_VARCHAR2_TABLE_100

93: , a9 JTF_NUMBER_TABLE
94: );
95: procedure rosetta_table_copy_out_p5(t okl_ras_pvt.oklrelocateassetstltbltype, a0 out nocopy JTF_NUMBER_TABLE
96: , a1 out nocopy JTF_VARCHAR2_TABLE_100
97: , a2 out nocopy JTF_VARCHAR2_TABLE_100
98: , a3 out nocopy JTF_VARCHAR2_TABLE_100
99: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
100: , a5 out nocopy JTF_NUMBER_TABLE
101: , a6 out nocopy JTF_DATE_TABLE

Line 98: , a3 out nocopy JTF_VARCHAR2_TABLE_100

94: );
95: procedure rosetta_table_copy_out_p5(t okl_ras_pvt.oklrelocateassetstltbltype, a0 out nocopy JTF_NUMBER_TABLE
96: , a1 out nocopy JTF_VARCHAR2_TABLE_100
97: , a2 out nocopy JTF_VARCHAR2_TABLE_100
98: , a3 out nocopy JTF_VARCHAR2_TABLE_100
99: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
100: , a5 out nocopy JTF_NUMBER_TABLE
101: , a6 out nocopy JTF_DATE_TABLE
102: , a7 out nocopy JTF_NUMBER_TABLE

Line 109: , a2 JTF_VARCHAR2_TABLE_100

105: );
106:
107: procedure rosetta_table_copy_in_p8(t out nocopy okl_ras_pvt.rasv_tbl_type, a0 JTF_NUMBER_TABLE
108: , a1 JTF_NUMBER_TABLE
109: , a2 JTF_VARCHAR2_TABLE_100
110: , a3 JTF_NUMBER_TABLE
111: , a4 JTF_NUMBER_TABLE
112: , a5 JTF_NUMBER_TABLE
113: , a6 JTF_DATE_TABLE

Line 117: , a10 JTF_VARCHAR2_TABLE_100

113: , a6 JTF_DATE_TABLE
114: , a7 JTF_VARCHAR2_TABLE_2000
115: , a8 JTF_VARCHAR2_TABLE_300
116: , a9 JTF_NUMBER_TABLE
117: , a10 JTF_VARCHAR2_TABLE_100
118: , a11 JTF_VARCHAR2_TABLE_500
119: , a12 JTF_VARCHAR2_TABLE_500
120: , a13 JTF_VARCHAR2_TABLE_500
121: , a14 JTF_VARCHAR2_TABLE_500

Line 143: , a36 JTF_VARCHAR2_TABLE_100

139: , a32 JTF_DATE_TABLE
140: , a33 JTF_NUMBER_TABLE
141: , a34 JTF_NUMBER_TABLE
142: , a35 JTF_DATE_TABLE
143: , a36 JTF_VARCHAR2_TABLE_100
144: , a37 JTF_VARCHAR2_TABLE_100
145: , a38 JTF_VARCHAR2_TABLE_100
146: , a39 JTF_NUMBER_TABLE
147: , a40 JTF_DATE_TABLE

Line 144: , a37 JTF_VARCHAR2_TABLE_100

140: , a33 JTF_NUMBER_TABLE
141: , a34 JTF_NUMBER_TABLE
142: , a35 JTF_DATE_TABLE
143: , a36 JTF_VARCHAR2_TABLE_100
144: , a37 JTF_VARCHAR2_TABLE_100
145: , a38 JTF_VARCHAR2_TABLE_100
146: , a39 JTF_NUMBER_TABLE
147: , a40 JTF_DATE_TABLE
148: );

Line 145: , a38 JTF_VARCHAR2_TABLE_100

141: , a34 JTF_NUMBER_TABLE
142: , a35 JTF_DATE_TABLE
143: , a36 JTF_VARCHAR2_TABLE_100
144: , a37 JTF_VARCHAR2_TABLE_100
145: , a38 JTF_VARCHAR2_TABLE_100
146: , a39 JTF_NUMBER_TABLE
147: , a40 JTF_DATE_TABLE
148: );
149: procedure rosetta_table_copy_out_p8(t okl_ras_pvt.rasv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 151: , a2 out nocopy JTF_VARCHAR2_TABLE_100

147: , a40 JTF_DATE_TABLE
148: );
149: procedure rosetta_table_copy_out_p8(t okl_ras_pvt.rasv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
150: , a1 out nocopy JTF_NUMBER_TABLE
151: , a2 out nocopy JTF_VARCHAR2_TABLE_100
152: , a3 out nocopy JTF_NUMBER_TABLE
153: , a4 out nocopy JTF_NUMBER_TABLE
154: , a5 out nocopy JTF_NUMBER_TABLE
155: , a6 out nocopy JTF_DATE_TABLE

Line 159: , a10 out nocopy JTF_VARCHAR2_TABLE_100

155: , a6 out nocopy JTF_DATE_TABLE
156: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
157: , a8 out nocopy JTF_VARCHAR2_TABLE_300
158: , a9 out nocopy JTF_NUMBER_TABLE
159: , a10 out nocopy JTF_VARCHAR2_TABLE_100
160: , a11 out nocopy JTF_VARCHAR2_TABLE_500
161: , a12 out nocopy JTF_VARCHAR2_TABLE_500
162: , a13 out nocopy JTF_VARCHAR2_TABLE_500
163: , a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 185: , a36 out nocopy JTF_VARCHAR2_TABLE_100

181: , a32 out nocopy JTF_DATE_TABLE
182: , a33 out nocopy JTF_NUMBER_TABLE
183: , a34 out nocopy JTF_NUMBER_TABLE
184: , a35 out nocopy JTF_DATE_TABLE
185: , a36 out nocopy JTF_VARCHAR2_TABLE_100
186: , a37 out nocopy JTF_VARCHAR2_TABLE_100
187: , a38 out nocopy JTF_VARCHAR2_TABLE_100
188: , a39 out nocopy JTF_NUMBER_TABLE
189: , a40 out nocopy JTF_DATE_TABLE

Line 186: , a37 out nocopy JTF_VARCHAR2_TABLE_100

182: , a33 out nocopy JTF_NUMBER_TABLE
183: , a34 out nocopy JTF_NUMBER_TABLE
184: , a35 out nocopy JTF_DATE_TABLE
185: , a36 out nocopy JTF_VARCHAR2_TABLE_100
186: , a37 out nocopy JTF_VARCHAR2_TABLE_100
187: , a38 out nocopy JTF_VARCHAR2_TABLE_100
188: , a39 out nocopy JTF_NUMBER_TABLE
189: , a40 out nocopy JTF_DATE_TABLE
190: );

Line 187: , a38 out nocopy JTF_VARCHAR2_TABLE_100

183: , a34 out nocopy JTF_NUMBER_TABLE
184: , a35 out nocopy JTF_DATE_TABLE
185: , a36 out nocopy JTF_VARCHAR2_TABLE_100
186: , a37 out nocopy JTF_VARCHAR2_TABLE_100
187: , a38 out nocopy JTF_VARCHAR2_TABLE_100
188: , a39 out nocopy JTF_NUMBER_TABLE
189: , a40 out nocopy JTF_DATE_TABLE
190: );
191:

Line 287: , p5_a2 JTF_VARCHAR2_TABLE_100

283: , x_msg_count out nocopy NUMBER
284: , x_msg_data out nocopy VARCHAR2
285: , p5_a0 JTF_NUMBER_TABLE
286: , p5_a1 JTF_NUMBER_TABLE
287: , p5_a2 JTF_VARCHAR2_TABLE_100
288: , p5_a3 JTF_NUMBER_TABLE
289: , p5_a4 JTF_NUMBER_TABLE
290: , p5_a5 JTF_NUMBER_TABLE
291: , p5_a6 JTF_DATE_TABLE

Line 295: , p5_a10 JTF_VARCHAR2_TABLE_100

291: , p5_a6 JTF_DATE_TABLE
292: , p5_a7 JTF_VARCHAR2_TABLE_2000
293: , p5_a8 JTF_VARCHAR2_TABLE_300
294: , p5_a9 JTF_NUMBER_TABLE
295: , p5_a10 JTF_VARCHAR2_TABLE_100
296: , p5_a11 JTF_VARCHAR2_TABLE_500
297: , p5_a12 JTF_VARCHAR2_TABLE_500
298: , p5_a13 JTF_VARCHAR2_TABLE_500
299: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 321: , p5_a36 JTF_VARCHAR2_TABLE_100

317: , p5_a32 JTF_DATE_TABLE
318: , p5_a33 JTF_NUMBER_TABLE
319: , p5_a34 JTF_NUMBER_TABLE
320: , p5_a35 JTF_DATE_TABLE
321: , p5_a36 JTF_VARCHAR2_TABLE_100
322: , p5_a37 JTF_VARCHAR2_TABLE_100
323: , p5_a38 JTF_VARCHAR2_TABLE_100
324: , p5_a39 JTF_NUMBER_TABLE
325: , p5_a40 JTF_DATE_TABLE

Line 322: , p5_a37 JTF_VARCHAR2_TABLE_100

318: , p5_a33 JTF_NUMBER_TABLE
319: , p5_a34 JTF_NUMBER_TABLE
320: , p5_a35 JTF_DATE_TABLE
321: , p5_a36 JTF_VARCHAR2_TABLE_100
322: , p5_a37 JTF_VARCHAR2_TABLE_100
323: , p5_a38 JTF_VARCHAR2_TABLE_100
324: , p5_a39 JTF_NUMBER_TABLE
325: , p5_a40 JTF_DATE_TABLE
326: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 323: , p5_a38 JTF_VARCHAR2_TABLE_100

319: , p5_a34 JTF_NUMBER_TABLE
320: , p5_a35 JTF_DATE_TABLE
321: , p5_a36 JTF_VARCHAR2_TABLE_100
322: , p5_a37 JTF_VARCHAR2_TABLE_100
323: , p5_a38 JTF_VARCHAR2_TABLE_100
324: , p5_a39 JTF_NUMBER_TABLE
325: , p5_a40 JTF_DATE_TABLE
326: , p6_a0 out nocopy JTF_NUMBER_TABLE
327: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 328: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

324: , p5_a39 JTF_NUMBER_TABLE
325: , p5_a40 JTF_DATE_TABLE
326: , p6_a0 out nocopy JTF_NUMBER_TABLE
327: , p6_a1 out nocopy JTF_NUMBER_TABLE
328: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
329: , p6_a3 out nocopy JTF_NUMBER_TABLE
330: , p6_a4 out nocopy JTF_NUMBER_TABLE
331: , p6_a5 out nocopy JTF_NUMBER_TABLE
332: , p6_a6 out nocopy JTF_DATE_TABLE

Line 336: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

332: , p6_a6 out nocopy JTF_DATE_TABLE
333: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
334: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300
335: , p6_a9 out nocopy JTF_NUMBER_TABLE
336: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
337: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
338: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
339: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
340: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 362: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100

358: , p6_a32 out nocopy JTF_DATE_TABLE
359: , p6_a33 out nocopy JTF_NUMBER_TABLE
360: , p6_a34 out nocopy JTF_NUMBER_TABLE
361: , p6_a35 out nocopy JTF_DATE_TABLE
362: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
363: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
364: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
365: , p6_a39 out nocopy JTF_NUMBER_TABLE
366: , p6_a40 out nocopy JTF_DATE_TABLE

Line 363: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100

359: , p6_a33 out nocopy JTF_NUMBER_TABLE
360: , p6_a34 out nocopy JTF_NUMBER_TABLE
361: , p6_a35 out nocopy JTF_DATE_TABLE
362: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
363: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
364: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
365: , p6_a39 out nocopy JTF_NUMBER_TABLE
366: , p6_a40 out nocopy JTF_DATE_TABLE
367: );

Line 364: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100

360: , p6_a34 out nocopy JTF_NUMBER_TABLE
361: , p6_a35 out nocopy JTF_DATE_TABLE
362: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
363: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
364: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
365: , p6_a39 out nocopy JTF_NUMBER_TABLE
366: , p6_a40 out nocopy JTF_DATE_TABLE
367: );
368: procedure lock_row(p_api_version NUMBER

Line 422: , p5_a2 JTF_VARCHAR2_TABLE_100

418: , x_msg_count out nocopy NUMBER
419: , x_msg_data out nocopy VARCHAR2
420: , p5_a0 JTF_NUMBER_TABLE
421: , p5_a1 JTF_NUMBER_TABLE
422: , p5_a2 JTF_VARCHAR2_TABLE_100
423: , p5_a3 JTF_NUMBER_TABLE
424: , p5_a4 JTF_NUMBER_TABLE
425: , p5_a5 JTF_NUMBER_TABLE
426: , p5_a6 JTF_DATE_TABLE

Line 430: , p5_a10 JTF_VARCHAR2_TABLE_100

426: , p5_a6 JTF_DATE_TABLE
427: , p5_a7 JTF_VARCHAR2_TABLE_2000
428: , p5_a8 JTF_VARCHAR2_TABLE_300
429: , p5_a9 JTF_NUMBER_TABLE
430: , p5_a10 JTF_VARCHAR2_TABLE_100
431: , p5_a11 JTF_VARCHAR2_TABLE_500
432: , p5_a12 JTF_VARCHAR2_TABLE_500
433: , p5_a13 JTF_VARCHAR2_TABLE_500
434: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 456: , p5_a36 JTF_VARCHAR2_TABLE_100

452: , p5_a32 JTF_DATE_TABLE
453: , p5_a33 JTF_NUMBER_TABLE
454: , p5_a34 JTF_NUMBER_TABLE
455: , p5_a35 JTF_DATE_TABLE
456: , p5_a36 JTF_VARCHAR2_TABLE_100
457: , p5_a37 JTF_VARCHAR2_TABLE_100
458: , p5_a38 JTF_VARCHAR2_TABLE_100
459: , p5_a39 JTF_NUMBER_TABLE
460: , p5_a40 JTF_DATE_TABLE

Line 457: , p5_a37 JTF_VARCHAR2_TABLE_100

453: , p5_a33 JTF_NUMBER_TABLE
454: , p5_a34 JTF_NUMBER_TABLE
455: , p5_a35 JTF_DATE_TABLE
456: , p5_a36 JTF_VARCHAR2_TABLE_100
457: , p5_a37 JTF_VARCHAR2_TABLE_100
458: , p5_a38 JTF_VARCHAR2_TABLE_100
459: , p5_a39 JTF_NUMBER_TABLE
460: , p5_a40 JTF_DATE_TABLE
461: );

Line 458: , p5_a38 JTF_VARCHAR2_TABLE_100

454: , p5_a34 JTF_NUMBER_TABLE
455: , p5_a35 JTF_DATE_TABLE
456: , p5_a36 JTF_VARCHAR2_TABLE_100
457: , p5_a37 JTF_VARCHAR2_TABLE_100
458: , p5_a38 JTF_VARCHAR2_TABLE_100
459: , p5_a39 JTF_NUMBER_TABLE
460: , p5_a40 JTF_DATE_TABLE
461: );
462: procedure update_row(p_api_version NUMBER

Line 557: , p5_a2 JTF_VARCHAR2_TABLE_100

553: , x_msg_count out nocopy NUMBER
554: , x_msg_data out nocopy VARCHAR2
555: , p5_a0 JTF_NUMBER_TABLE
556: , p5_a1 JTF_NUMBER_TABLE
557: , p5_a2 JTF_VARCHAR2_TABLE_100
558: , p5_a3 JTF_NUMBER_TABLE
559: , p5_a4 JTF_NUMBER_TABLE
560: , p5_a5 JTF_NUMBER_TABLE
561: , p5_a6 JTF_DATE_TABLE

Line 565: , p5_a10 JTF_VARCHAR2_TABLE_100

561: , p5_a6 JTF_DATE_TABLE
562: , p5_a7 JTF_VARCHAR2_TABLE_2000
563: , p5_a8 JTF_VARCHAR2_TABLE_300
564: , p5_a9 JTF_NUMBER_TABLE
565: , p5_a10 JTF_VARCHAR2_TABLE_100
566: , p5_a11 JTF_VARCHAR2_TABLE_500
567: , p5_a12 JTF_VARCHAR2_TABLE_500
568: , p5_a13 JTF_VARCHAR2_TABLE_500
569: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 591: , p5_a36 JTF_VARCHAR2_TABLE_100

587: , p5_a32 JTF_DATE_TABLE
588: , p5_a33 JTF_NUMBER_TABLE
589: , p5_a34 JTF_NUMBER_TABLE
590: , p5_a35 JTF_DATE_TABLE
591: , p5_a36 JTF_VARCHAR2_TABLE_100
592: , p5_a37 JTF_VARCHAR2_TABLE_100
593: , p5_a38 JTF_VARCHAR2_TABLE_100
594: , p5_a39 JTF_NUMBER_TABLE
595: , p5_a40 JTF_DATE_TABLE

Line 592: , p5_a37 JTF_VARCHAR2_TABLE_100

588: , p5_a33 JTF_NUMBER_TABLE
589: , p5_a34 JTF_NUMBER_TABLE
590: , p5_a35 JTF_DATE_TABLE
591: , p5_a36 JTF_VARCHAR2_TABLE_100
592: , p5_a37 JTF_VARCHAR2_TABLE_100
593: , p5_a38 JTF_VARCHAR2_TABLE_100
594: , p5_a39 JTF_NUMBER_TABLE
595: , p5_a40 JTF_DATE_TABLE
596: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 593: , p5_a38 JTF_VARCHAR2_TABLE_100

589: , p5_a34 JTF_NUMBER_TABLE
590: , p5_a35 JTF_DATE_TABLE
591: , p5_a36 JTF_VARCHAR2_TABLE_100
592: , p5_a37 JTF_VARCHAR2_TABLE_100
593: , p5_a38 JTF_VARCHAR2_TABLE_100
594: , p5_a39 JTF_NUMBER_TABLE
595: , p5_a40 JTF_DATE_TABLE
596: , p6_a0 out nocopy JTF_NUMBER_TABLE
597: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 598: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

594: , p5_a39 JTF_NUMBER_TABLE
595: , p5_a40 JTF_DATE_TABLE
596: , p6_a0 out nocopy JTF_NUMBER_TABLE
597: , p6_a1 out nocopy JTF_NUMBER_TABLE
598: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
599: , p6_a3 out nocopy JTF_NUMBER_TABLE
600: , p6_a4 out nocopy JTF_NUMBER_TABLE
601: , p6_a5 out nocopy JTF_NUMBER_TABLE
602: , p6_a6 out nocopy JTF_DATE_TABLE

Line 606: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

602: , p6_a6 out nocopy JTF_DATE_TABLE
603: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
604: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300
605: , p6_a9 out nocopy JTF_NUMBER_TABLE
606: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
607: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
608: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
609: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
610: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 632: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100

628: , p6_a32 out nocopy JTF_DATE_TABLE
629: , p6_a33 out nocopy JTF_NUMBER_TABLE
630: , p6_a34 out nocopy JTF_NUMBER_TABLE
631: , p6_a35 out nocopy JTF_DATE_TABLE
632: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
633: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
634: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
635: , p6_a39 out nocopy JTF_NUMBER_TABLE
636: , p6_a40 out nocopy JTF_DATE_TABLE

Line 633: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100

629: , p6_a33 out nocopy JTF_NUMBER_TABLE
630: , p6_a34 out nocopy JTF_NUMBER_TABLE
631: , p6_a35 out nocopy JTF_DATE_TABLE
632: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
633: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
634: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
635: , p6_a39 out nocopy JTF_NUMBER_TABLE
636: , p6_a40 out nocopy JTF_DATE_TABLE
637: );

Line 634: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100

630: , p6_a34 out nocopy JTF_NUMBER_TABLE
631: , p6_a35 out nocopy JTF_DATE_TABLE
632: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
633: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
634: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
635: , p6_a39 out nocopy JTF_NUMBER_TABLE
636: , p6_a40 out nocopy JTF_DATE_TABLE
637: );
638: procedure delete_row(p_api_version NUMBER

Line 692: , p5_a2 JTF_VARCHAR2_TABLE_100

688: , x_msg_count out nocopy NUMBER
689: , x_msg_data out nocopy VARCHAR2
690: , p5_a0 JTF_NUMBER_TABLE
691: , p5_a1 JTF_NUMBER_TABLE
692: , p5_a2 JTF_VARCHAR2_TABLE_100
693: , p5_a3 JTF_NUMBER_TABLE
694: , p5_a4 JTF_NUMBER_TABLE
695: , p5_a5 JTF_NUMBER_TABLE
696: , p5_a6 JTF_DATE_TABLE

Line 700: , p5_a10 JTF_VARCHAR2_TABLE_100

696: , p5_a6 JTF_DATE_TABLE
697: , p5_a7 JTF_VARCHAR2_TABLE_2000
698: , p5_a8 JTF_VARCHAR2_TABLE_300
699: , p5_a9 JTF_NUMBER_TABLE
700: , p5_a10 JTF_VARCHAR2_TABLE_100
701: , p5_a11 JTF_VARCHAR2_TABLE_500
702: , p5_a12 JTF_VARCHAR2_TABLE_500
703: , p5_a13 JTF_VARCHAR2_TABLE_500
704: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 726: , p5_a36 JTF_VARCHAR2_TABLE_100

722: , p5_a32 JTF_DATE_TABLE
723: , p5_a33 JTF_NUMBER_TABLE
724: , p5_a34 JTF_NUMBER_TABLE
725: , p5_a35 JTF_DATE_TABLE
726: , p5_a36 JTF_VARCHAR2_TABLE_100
727: , p5_a37 JTF_VARCHAR2_TABLE_100
728: , p5_a38 JTF_VARCHAR2_TABLE_100
729: , p5_a39 JTF_NUMBER_TABLE
730: , p5_a40 JTF_DATE_TABLE

Line 727: , p5_a37 JTF_VARCHAR2_TABLE_100

723: , p5_a33 JTF_NUMBER_TABLE
724: , p5_a34 JTF_NUMBER_TABLE
725: , p5_a35 JTF_DATE_TABLE
726: , p5_a36 JTF_VARCHAR2_TABLE_100
727: , p5_a37 JTF_VARCHAR2_TABLE_100
728: , p5_a38 JTF_VARCHAR2_TABLE_100
729: , p5_a39 JTF_NUMBER_TABLE
730: , p5_a40 JTF_DATE_TABLE
731: );

Line 728: , p5_a38 JTF_VARCHAR2_TABLE_100

724: , p5_a34 JTF_NUMBER_TABLE
725: , p5_a35 JTF_DATE_TABLE
726: , p5_a36 JTF_VARCHAR2_TABLE_100
727: , p5_a37 JTF_VARCHAR2_TABLE_100
728: , p5_a38 JTF_VARCHAR2_TABLE_100
729: , p5_a39 JTF_NUMBER_TABLE
730: , p5_a40 JTF_DATE_TABLE
731: );
732: procedure validate_row(p_api_version NUMBER

Line 786: , p5_a2 JTF_VARCHAR2_TABLE_100

782: , x_msg_count out nocopy NUMBER
783: , x_msg_data out nocopy VARCHAR2
784: , p5_a0 JTF_NUMBER_TABLE
785: , p5_a1 JTF_NUMBER_TABLE
786: , p5_a2 JTF_VARCHAR2_TABLE_100
787: , p5_a3 JTF_NUMBER_TABLE
788: , p5_a4 JTF_NUMBER_TABLE
789: , p5_a5 JTF_NUMBER_TABLE
790: , p5_a6 JTF_DATE_TABLE

Line 794: , p5_a10 JTF_VARCHAR2_TABLE_100

790: , p5_a6 JTF_DATE_TABLE
791: , p5_a7 JTF_VARCHAR2_TABLE_2000
792: , p5_a8 JTF_VARCHAR2_TABLE_300
793: , p5_a9 JTF_NUMBER_TABLE
794: , p5_a10 JTF_VARCHAR2_TABLE_100
795: , p5_a11 JTF_VARCHAR2_TABLE_500
796: , p5_a12 JTF_VARCHAR2_TABLE_500
797: , p5_a13 JTF_VARCHAR2_TABLE_500
798: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 820: , p5_a36 JTF_VARCHAR2_TABLE_100

816: , p5_a32 JTF_DATE_TABLE
817: , p5_a33 JTF_NUMBER_TABLE
818: , p5_a34 JTF_NUMBER_TABLE
819: , p5_a35 JTF_DATE_TABLE
820: , p5_a36 JTF_VARCHAR2_TABLE_100
821: , p5_a37 JTF_VARCHAR2_TABLE_100
822: , p5_a38 JTF_VARCHAR2_TABLE_100
823: , p5_a39 JTF_NUMBER_TABLE
824: , p5_a40 JTF_DATE_TABLE

Line 821: , p5_a37 JTF_VARCHAR2_TABLE_100

817: , p5_a33 JTF_NUMBER_TABLE
818: , p5_a34 JTF_NUMBER_TABLE
819: , p5_a35 JTF_DATE_TABLE
820: , p5_a36 JTF_VARCHAR2_TABLE_100
821: , p5_a37 JTF_VARCHAR2_TABLE_100
822: , p5_a38 JTF_VARCHAR2_TABLE_100
823: , p5_a39 JTF_NUMBER_TABLE
824: , p5_a40 JTF_DATE_TABLE
825: );

Line 822: , p5_a38 JTF_VARCHAR2_TABLE_100

818: , p5_a34 JTF_NUMBER_TABLE
819: , p5_a35 JTF_DATE_TABLE
820: , p5_a36 JTF_VARCHAR2_TABLE_100
821: , p5_a37 JTF_VARCHAR2_TABLE_100
822: , p5_a38 JTF_VARCHAR2_TABLE_100
823: , p5_a39 JTF_NUMBER_TABLE
824: , p5_a40 JTF_DATE_TABLE
825: );
826: end okl_ras_pvt_w;