DBA Data[Home] [Help]

APPS.OKL_SRV_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package okl_srv_pvt_w as
2: /* $Header: OKLISRVS.pls 120.0 2005/07/07 10:41:04 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_srv_pvt.okl_srv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100

Line 9: , a6 JTF_VARCHAR2_TABLE_100

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

Line 13: , a10 JTF_VARCHAR2_TABLE_100

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

Line 16: , a13 JTF_VARCHAR2_TABLE_100

12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
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 40: , a2 out nocopy JTF_VARCHAR2_TABLE_100

36: , a33 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p1(t okl_srv_pvt.okl_srv_tbl, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_VARCHAR2_TABLE_100
41: , a3 out nocopy JTF_NUMBER_TABLE
42: , a4 out nocopy JTF_DATE_TABLE
43: , a5 out nocopy JTF_DATE_TABLE
44: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 44: , a6 out nocopy JTF_VARCHAR2_TABLE_100

40: , a2 out nocopy JTF_VARCHAR2_TABLE_100
41: , a3 out nocopy JTF_NUMBER_TABLE
42: , a4 out nocopy JTF_DATE_TABLE
43: , a5 out nocopy JTF_DATE_TABLE
44: , a6 out nocopy JTF_VARCHAR2_TABLE_100
45: , a7 out nocopy JTF_NUMBER_TABLE
46: , a8 out nocopy JTF_NUMBER_TABLE
47: , a9 out nocopy JTF_NUMBER_TABLE
48: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 48: , a10 out nocopy JTF_VARCHAR2_TABLE_100

44: , a6 out nocopy JTF_VARCHAR2_TABLE_100
45: , a7 out nocopy JTF_NUMBER_TABLE
46: , a8 out nocopy JTF_NUMBER_TABLE
47: , a9 out nocopy JTF_NUMBER_TABLE
48: , a10 out nocopy JTF_VARCHAR2_TABLE_100
49: , a11 out nocopy JTF_NUMBER_TABLE
50: , a12 out nocopy JTF_NUMBER_TABLE
51: , a13 out nocopy JTF_VARCHAR2_TABLE_100
52: , a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 51: , a13 out nocopy JTF_VARCHAR2_TABLE_100

47: , a9 out nocopy JTF_NUMBER_TABLE
48: , a10 out nocopy JTF_VARCHAR2_TABLE_100
49: , a11 out nocopy JTF_NUMBER_TABLE
50: , a12 out nocopy JTF_NUMBER_TABLE
51: , a13 out nocopy JTF_VARCHAR2_TABLE_100
52: , a14 out nocopy JTF_VARCHAR2_TABLE_500
53: , a15 out nocopy JTF_VARCHAR2_TABLE_500
54: , a16 out nocopy JTF_VARCHAR2_TABLE_500
55: , a17 out nocopy JTF_VARCHAR2_TABLE_500

Line 155: , p5_a2 JTF_VARCHAR2_TABLE_100

151: , x_msg_count out nocopy NUMBER
152: , x_msg_data out nocopy VARCHAR2
153: , p5_a0 JTF_NUMBER_TABLE
154: , p5_a1 JTF_NUMBER_TABLE
155: , p5_a2 JTF_VARCHAR2_TABLE_100
156: , p5_a3 JTF_NUMBER_TABLE
157: , p5_a4 JTF_DATE_TABLE
158: , p5_a5 JTF_DATE_TABLE
159: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 159: , p5_a6 JTF_VARCHAR2_TABLE_100

155: , p5_a2 JTF_VARCHAR2_TABLE_100
156: , p5_a3 JTF_NUMBER_TABLE
157: , p5_a4 JTF_DATE_TABLE
158: , p5_a5 JTF_DATE_TABLE
159: , p5_a6 JTF_VARCHAR2_TABLE_100
160: , p5_a7 JTF_NUMBER_TABLE
161: , p5_a8 JTF_NUMBER_TABLE
162: , p5_a9 JTF_NUMBER_TABLE
163: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 163: , p5_a10 JTF_VARCHAR2_TABLE_100

159: , p5_a6 JTF_VARCHAR2_TABLE_100
160: , p5_a7 JTF_NUMBER_TABLE
161: , p5_a8 JTF_NUMBER_TABLE
162: , p5_a9 JTF_NUMBER_TABLE
163: , p5_a10 JTF_VARCHAR2_TABLE_100
164: , p5_a11 JTF_NUMBER_TABLE
165: , p5_a12 JTF_NUMBER_TABLE
166: , p5_a13 JTF_VARCHAR2_TABLE_100
167: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 166: , p5_a13 JTF_VARCHAR2_TABLE_100

162: , p5_a9 JTF_NUMBER_TABLE
163: , p5_a10 JTF_VARCHAR2_TABLE_100
164: , p5_a11 JTF_NUMBER_TABLE
165: , p5_a12 JTF_NUMBER_TABLE
166: , p5_a13 JTF_VARCHAR2_TABLE_100
167: , p5_a14 JTF_VARCHAR2_TABLE_500
168: , p5_a15 JTF_VARCHAR2_TABLE_500
169: , p5_a16 JTF_VARCHAR2_TABLE_500
170: , p5_a17 JTF_VARCHAR2_TABLE_500

Line 189: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

185: , p5_a32 JTF_DATE_TABLE
186: , p5_a33 JTF_NUMBER_TABLE
187: , p6_a0 out nocopy JTF_NUMBER_TABLE
188: , p6_a1 out nocopy JTF_NUMBER_TABLE
189: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
190: , p6_a3 out nocopy JTF_NUMBER_TABLE
191: , p6_a4 out nocopy JTF_DATE_TABLE
192: , p6_a5 out nocopy JTF_DATE_TABLE
193: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 193: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

189: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
190: , p6_a3 out nocopy JTF_NUMBER_TABLE
191: , p6_a4 out nocopy JTF_DATE_TABLE
192: , p6_a5 out nocopy JTF_DATE_TABLE
193: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
194: , p6_a7 out nocopy JTF_NUMBER_TABLE
195: , p6_a8 out nocopy JTF_NUMBER_TABLE
196: , p6_a9 out nocopy JTF_NUMBER_TABLE
197: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 197: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

193: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
194: , p6_a7 out nocopy JTF_NUMBER_TABLE
195: , p6_a8 out nocopy JTF_NUMBER_TABLE
196: , p6_a9 out nocopy JTF_NUMBER_TABLE
197: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
198: , p6_a11 out nocopy JTF_NUMBER_TABLE
199: , p6_a12 out nocopy JTF_NUMBER_TABLE
200: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
201: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 200: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

196: , p6_a9 out nocopy JTF_NUMBER_TABLE
197: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
198: , p6_a11 out nocopy JTF_NUMBER_TABLE
199: , p6_a12 out nocopy JTF_NUMBER_TABLE
200: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
201: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
202: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
203: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
204: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500

Line 303: , p5_a2 JTF_VARCHAR2_TABLE_100

299: , x_msg_count out nocopy NUMBER
300: , x_msg_data out nocopy VARCHAR2
301: , p5_a0 JTF_NUMBER_TABLE
302: , p5_a1 JTF_NUMBER_TABLE
303: , p5_a2 JTF_VARCHAR2_TABLE_100
304: , p5_a3 JTF_NUMBER_TABLE
305: , p5_a4 JTF_DATE_TABLE
306: , p5_a5 JTF_DATE_TABLE
307: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 307: , p5_a6 JTF_VARCHAR2_TABLE_100

303: , p5_a2 JTF_VARCHAR2_TABLE_100
304: , p5_a3 JTF_NUMBER_TABLE
305: , p5_a4 JTF_DATE_TABLE
306: , p5_a5 JTF_DATE_TABLE
307: , p5_a6 JTF_VARCHAR2_TABLE_100
308: , p5_a7 JTF_NUMBER_TABLE
309: , p5_a8 JTF_NUMBER_TABLE
310: , p5_a9 JTF_NUMBER_TABLE
311: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 311: , p5_a10 JTF_VARCHAR2_TABLE_100

307: , p5_a6 JTF_VARCHAR2_TABLE_100
308: , p5_a7 JTF_NUMBER_TABLE
309: , p5_a8 JTF_NUMBER_TABLE
310: , p5_a9 JTF_NUMBER_TABLE
311: , p5_a10 JTF_VARCHAR2_TABLE_100
312: , p5_a11 JTF_NUMBER_TABLE
313: , p5_a12 JTF_NUMBER_TABLE
314: , p5_a13 JTF_VARCHAR2_TABLE_100
315: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 314: , p5_a13 JTF_VARCHAR2_TABLE_100

310: , p5_a9 JTF_NUMBER_TABLE
311: , p5_a10 JTF_VARCHAR2_TABLE_100
312: , p5_a11 JTF_NUMBER_TABLE
313: , p5_a12 JTF_NUMBER_TABLE
314: , p5_a13 JTF_VARCHAR2_TABLE_100
315: , p5_a14 JTF_VARCHAR2_TABLE_500
316: , p5_a15 JTF_VARCHAR2_TABLE_500
317: , p5_a16 JTF_VARCHAR2_TABLE_500
318: , p5_a17 JTF_VARCHAR2_TABLE_500

Line 337: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

333: , p5_a32 JTF_DATE_TABLE
334: , p5_a33 JTF_NUMBER_TABLE
335: , p6_a0 out nocopy JTF_NUMBER_TABLE
336: , p6_a1 out nocopy JTF_NUMBER_TABLE
337: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a3 out nocopy JTF_NUMBER_TABLE
339: , p6_a4 out nocopy JTF_DATE_TABLE
340: , p6_a5 out nocopy JTF_DATE_TABLE
341: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 341: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

337: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
338: , p6_a3 out nocopy JTF_NUMBER_TABLE
339: , p6_a4 out nocopy JTF_DATE_TABLE
340: , p6_a5 out nocopy JTF_DATE_TABLE
341: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
342: , p6_a7 out nocopy JTF_NUMBER_TABLE
343: , p6_a8 out nocopy JTF_NUMBER_TABLE
344: , p6_a9 out nocopy JTF_NUMBER_TABLE
345: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 345: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

341: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
342: , p6_a7 out nocopy JTF_NUMBER_TABLE
343: , p6_a8 out nocopy JTF_NUMBER_TABLE
344: , p6_a9 out nocopy JTF_NUMBER_TABLE
345: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
346: , p6_a11 out nocopy JTF_NUMBER_TABLE
347: , p6_a12 out nocopy JTF_NUMBER_TABLE
348: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
349: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 348: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

344: , p6_a9 out nocopy JTF_NUMBER_TABLE
345: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
346: , p6_a11 out nocopy JTF_NUMBER_TABLE
347: , p6_a12 out nocopy JTF_NUMBER_TABLE
348: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
349: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
350: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
351: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
352: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500

Line 417: , p5_a2 JTF_VARCHAR2_TABLE_100

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

Line 421: , p5_a6 JTF_VARCHAR2_TABLE_100

417: , p5_a2 JTF_VARCHAR2_TABLE_100
418: , p5_a3 JTF_NUMBER_TABLE
419: , p5_a4 JTF_DATE_TABLE
420: , p5_a5 JTF_DATE_TABLE
421: , p5_a6 JTF_VARCHAR2_TABLE_100
422: , p5_a7 JTF_NUMBER_TABLE
423: , p5_a8 JTF_NUMBER_TABLE
424: , p5_a9 JTF_NUMBER_TABLE
425: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 425: , p5_a10 JTF_VARCHAR2_TABLE_100

421: , p5_a6 JTF_VARCHAR2_TABLE_100
422: , p5_a7 JTF_NUMBER_TABLE
423: , p5_a8 JTF_NUMBER_TABLE
424: , p5_a9 JTF_NUMBER_TABLE
425: , p5_a10 JTF_VARCHAR2_TABLE_100
426: , p5_a11 JTF_NUMBER_TABLE
427: , p5_a12 JTF_NUMBER_TABLE
428: , p5_a13 JTF_VARCHAR2_TABLE_100
429: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 428: , p5_a13 JTF_VARCHAR2_TABLE_100

424: , p5_a9 JTF_NUMBER_TABLE
425: , p5_a10 JTF_VARCHAR2_TABLE_100
426: , p5_a11 JTF_NUMBER_TABLE
427: , p5_a12 JTF_NUMBER_TABLE
428: , p5_a13 JTF_VARCHAR2_TABLE_100
429: , p5_a14 JTF_VARCHAR2_TABLE_500
430: , p5_a15 JTF_VARCHAR2_TABLE_500
431: , p5_a16 JTF_VARCHAR2_TABLE_500
432: , p5_a17 JTF_VARCHAR2_TABLE_500