DBA Data[Home] [Help]

APPS.OKL_SRM_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package okl_srm_pvt_w as
2: /* $Header: OKLISRMS.pls 120.1 2005/07/15 07:39:05 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_srm_pvt.srm_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_VARCHAR2_TABLE_1000
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_VARCHAR2_TABLE_100

Line 7: , a4 JTF_VARCHAR2_TABLE_1000

3: procedure rosetta_table_copy_in_p2(t out nocopy okl_srm_pvt.srm_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_VARCHAR2_TABLE_1000
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_VARCHAR2_TABLE_500

Line 9: , a6 JTF_VARCHAR2_TABLE_100

5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_VARCHAR2_TABLE_1000
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_2000
11: , a8 JTF_VARCHAR2_TABLE_500
12: , a9 JTF_VARCHAR2_TABLE_500
13: , a10 JTF_VARCHAR2_TABLE_500

Line 35: , a2 out nocopy JTF_VARCHAR2_TABLE_100

31: , a28 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p2(t okl_srm_pvt.srm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_VARCHAR2_TABLE_100
36: , a3 out nocopy JTF_VARCHAR2_TABLE_300
37: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
38: , a5 out nocopy JTF_VARCHAR2_TABLE_200
39: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 37: , a4 out nocopy JTF_VARCHAR2_TABLE_1000

33: procedure rosetta_table_copy_out_p2(t okl_srm_pvt.srm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_VARCHAR2_TABLE_100
36: , a3 out nocopy JTF_VARCHAR2_TABLE_300
37: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
38: , a5 out nocopy JTF_VARCHAR2_TABLE_200
39: , a6 out nocopy JTF_VARCHAR2_TABLE_100
40: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
41: , a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 39: , a6 out nocopy JTF_VARCHAR2_TABLE_100

35: , a2 out nocopy JTF_VARCHAR2_TABLE_100
36: , a3 out nocopy JTF_VARCHAR2_TABLE_300
37: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
38: , a5 out nocopy JTF_VARCHAR2_TABLE_200
39: , a6 out nocopy JTF_VARCHAR2_TABLE_100
40: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
41: , a8 out nocopy JTF_VARCHAR2_TABLE_500
42: , a9 out nocopy JTF_VARCHAR2_TABLE_500
43: , a10 out nocopy JTF_VARCHAR2_TABLE_500

Line 65: , a1 JTF_VARCHAR2_TABLE_100

61: , a28 out nocopy JTF_NUMBER_TABLE
62: );
63:
64: procedure rosetta_table_copy_in_p5(t out nocopy okl_srm_pvt.srmv_tbl_type, a0 JTF_NUMBER_TABLE
65: , a1 JTF_VARCHAR2_TABLE_100
66: , a2 JTF_VARCHAR2_TABLE_2000
67: , a3 JTF_VARCHAR2_TABLE_200
68: , a4 JTF_VARCHAR2_TABLE_1000
69: , a5 JTF_NUMBER_TABLE

Line 68: , a4 JTF_VARCHAR2_TABLE_1000

64: procedure rosetta_table_copy_in_p5(t out nocopy okl_srm_pvt.srmv_tbl_type, a0 JTF_NUMBER_TABLE
65: , a1 JTF_VARCHAR2_TABLE_100
66: , a2 JTF_VARCHAR2_TABLE_2000
67: , a3 JTF_VARCHAR2_TABLE_200
68: , a4 JTF_VARCHAR2_TABLE_1000
69: , a5 JTF_NUMBER_TABLE
70: , a6 JTF_VARCHAR2_TABLE_300
71: , a7 JTF_VARCHAR2_TABLE_100
72: , a8 JTF_VARCHAR2_TABLE_500

Line 71: , a7 JTF_VARCHAR2_TABLE_100

67: , a3 JTF_VARCHAR2_TABLE_200
68: , a4 JTF_VARCHAR2_TABLE_1000
69: , a5 JTF_NUMBER_TABLE
70: , a6 JTF_VARCHAR2_TABLE_300
71: , a7 JTF_VARCHAR2_TABLE_100
72: , a8 JTF_VARCHAR2_TABLE_500
73: , a9 JTF_VARCHAR2_TABLE_500
74: , a10 JTF_VARCHAR2_TABLE_500
75: , a11 JTF_VARCHAR2_TABLE_500

Line 95: , a1 out nocopy JTF_VARCHAR2_TABLE_100

91: , a27 JTF_DATE_TABLE
92: , a28 JTF_NUMBER_TABLE
93: );
94: procedure rosetta_table_copy_out_p5(t okl_srm_pvt.srmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_VARCHAR2_TABLE_100
96: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
97: , a3 out nocopy JTF_VARCHAR2_TABLE_200
98: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
99: , a5 out nocopy JTF_NUMBER_TABLE

Line 98: , a4 out nocopy JTF_VARCHAR2_TABLE_1000

94: procedure rosetta_table_copy_out_p5(t okl_srm_pvt.srmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_VARCHAR2_TABLE_100
96: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
97: , a3 out nocopy JTF_VARCHAR2_TABLE_200
98: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
99: , a5 out nocopy JTF_NUMBER_TABLE
100: , a6 out nocopy JTF_VARCHAR2_TABLE_300
101: , a7 out nocopy JTF_VARCHAR2_TABLE_100
102: , a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 101: , a7 out nocopy JTF_VARCHAR2_TABLE_100

97: , a3 out nocopy JTF_VARCHAR2_TABLE_200
98: , a4 out nocopy JTF_VARCHAR2_TABLE_1000
99: , a5 out nocopy JTF_NUMBER_TABLE
100: , a6 out nocopy JTF_VARCHAR2_TABLE_300
101: , a7 out nocopy JTF_VARCHAR2_TABLE_100
102: , a8 out nocopy JTF_VARCHAR2_TABLE_500
103: , a9 out nocopy JTF_VARCHAR2_TABLE_500
104: , a10 out nocopy JTF_VARCHAR2_TABLE_500
105: , a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 195: , p5_a1 JTF_VARCHAR2_TABLE_100

191: , x_return_status out nocopy VARCHAR2
192: , x_msg_count out nocopy NUMBER
193: , x_msg_data out nocopy VARCHAR2
194: , p5_a0 JTF_NUMBER_TABLE
195: , p5_a1 JTF_VARCHAR2_TABLE_100
196: , p5_a2 JTF_VARCHAR2_TABLE_2000
197: , p5_a3 JTF_VARCHAR2_TABLE_200
198: , p5_a4 JTF_VARCHAR2_TABLE_1000
199: , p5_a5 JTF_NUMBER_TABLE

Line 198: , p5_a4 JTF_VARCHAR2_TABLE_1000

194: , p5_a0 JTF_NUMBER_TABLE
195: , p5_a1 JTF_VARCHAR2_TABLE_100
196: , p5_a2 JTF_VARCHAR2_TABLE_2000
197: , p5_a3 JTF_VARCHAR2_TABLE_200
198: , p5_a4 JTF_VARCHAR2_TABLE_1000
199: , p5_a5 JTF_NUMBER_TABLE
200: , p5_a6 JTF_VARCHAR2_TABLE_300
201: , p5_a7 JTF_VARCHAR2_TABLE_100
202: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 201: , p5_a7 JTF_VARCHAR2_TABLE_100

197: , p5_a3 JTF_VARCHAR2_TABLE_200
198: , p5_a4 JTF_VARCHAR2_TABLE_1000
199: , p5_a5 JTF_NUMBER_TABLE
200: , p5_a6 JTF_VARCHAR2_TABLE_300
201: , p5_a7 JTF_VARCHAR2_TABLE_100
202: , p5_a8 JTF_VARCHAR2_TABLE_500
203: , p5_a9 JTF_VARCHAR2_TABLE_500
204: , p5_a10 JTF_VARCHAR2_TABLE_500
205: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 224: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

220: , p5_a26 JTF_DATE_TABLE
221: , p5_a27 JTF_DATE_TABLE
222: , p5_a28 JTF_NUMBER_TABLE
223: , p6_a0 out nocopy JTF_NUMBER_TABLE
224: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
225: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
226: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
227: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_1000
228: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 227: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_1000

223: , p6_a0 out nocopy JTF_NUMBER_TABLE
224: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
225: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
226: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
227: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_1000
228: , p6_a5 out nocopy JTF_NUMBER_TABLE
229: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
230: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
231: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 230: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

226: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
227: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_1000
228: , p6_a5 out nocopy JTF_NUMBER_TABLE
229: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
230: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
231: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
232: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
233: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
234: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 294: , p5_a1 JTF_VARCHAR2_TABLE_100

290: , x_return_status out nocopy VARCHAR2
291: , x_msg_count out nocopy NUMBER
292: , x_msg_data out nocopy VARCHAR2
293: , p5_a0 JTF_NUMBER_TABLE
294: , p5_a1 JTF_VARCHAR2_TABLE_100
295: , p5_a2 JTF_VARCHAR2_TABLE_2000
296: , p5_a3 JTF_VARCHAR2_TABLE_200
297: , p5_a4 JTF_VARCHAR2_TABLE_1000
298: , p5_a5 JTF_NUMBER_TABLE

Line 297: , p5_a4 JTF_VARCHAR2_TABLE_1000

293: , p5_a0 JTF_NUMBER_TABLE
294: , p5_a1 JTF_VARCHAR2_TABLE_100
295: , p5_a2 JTF_VARCHAR2_TABLE_2000
296: , p5_a3 JTF_VARCHAR2_TABLE_200
297: , p5_a4 JTF_VARCHAR2_TABLE_1000
298: , p5_a5 JTF_NUMBER_TABLE
299: , p5_a6 JTF_VARCHAR2_TABLE_300
300: , p5_a7 JTF_VARCHAR2_TABLE_100
301: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 300: , p5_a7 JTF_VARCHAR2_TABLE_100

296: , p5_a3 JTF_VARCHAR2_TABLE_200
297: , p5_a4 JTF_VARCHAR2_TABLE_1000
298: , p5_a5 JTF_NUMBER_TABLE
299: , p5_a6 JTF_VARCHAR2_TABLE_300
300: , p5_a7 JTF_VARCHAR2_TABLE_100
301: , p5_a8 JTF_VARCHAR2_TABLE_500
302: , p5_a9 JTF_VARCHAR2_TABLE_500
303: , p5_a10 JTF_VARCHAR2_TABLE_500
304: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 393: , p5_a1 JTF_VARCHAR2_TABLE_100

389: , x_return_status out nocopy VARCHAR2
390: , x_msg_count out nocopy NUMBER
391: , x_msg_data out nocopy VARCHAR2
392: , p5_a0 JTF_NUMBER_TABLE
393: , p5_a1 JTF_VARCHAR2_TABLE_100
394: , p5_a2 JTF_VARCHAR2_TABLE_2000
395: , p5_a3 JTF_VARCHAR2_TABLE_200
396: , p5_a4 JTF_VARCHAR2_TABLE_1000
397: , p5_a5 JTF_NUMBER_TABLE

Line 396: , p5_a4 JTF_VARCHAR2_TABLE_1000

392: , p5_a0 JTF_NUMBER_TABLE
393: , p5_a1 JTF_VARCHAR2_TABLE_100
394: , p5_a2 JTF_VARCHAR2_TABLE_2000
395: , p5_a3 JTF_VARCHAR2_TABLE_200
396: , p5_a4 JTF_VARCHAR2_TABLE_1000
397: , p5_a5 JTF_NUMBER_TABLE
398: , p5_a6 JTF_VARCHAR2_TABLE_300
399: , p5_a7 JTF_VARCHAR2_TABLE_100
400: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 399: , p5_a7 JTF_VARCHAR2_TABLE_100

395: , p5_a3 JTF_VARCHAR2_TABLE_200
396: , p5_a4 JTF_VARCHAR2_TABLE_1000
397: , p5_a5 JTF_NUMBER_TABLE
398: , p5_a6 JTF_VARCHAR2_TABLE_300
399: , p5_a7 JTF_VARCHAR2_TABLE_100
400: , p5_a8 JTF_VARCHAR2_TABLE_500
401: , p5_a9 JTF_VARCHAR2_TABLE_500
402: , p5_a10 JTF_VARCHAR2_TABLE_500
403: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 422: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

418: , p5_a26 JTF_DATE_TABLE
419: , p5_a27 JTF_DATE_TABLE
420: , p5_a28 JTF_NUMBER_TABLE
421: , p6_a0 out nocopy JTF_NUMBER_TABLE
422: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
424: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
425: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_1000
426: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 425: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_1000

421: , p6_a0 out nocopy JTF_NUMBER_TABLE
422: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_2000
424: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
425: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_1000
426: , p6_a5 out nocopy JTF_NUMBER_TABLE
427: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
428: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
429: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500

Line 428: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

424: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
425: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_1000
426: , p6_a5 out nocopy JTF_NUMBER_TABLE
427: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_300
428: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
429: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
430: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
431: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
432: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500

Line 492: , p5_a1 JTF_VARCHAR2_TABLE_100

488: , x_return_status out nocopy VARCHAR2
489: , x_msg_count out nocopy NUMBER
490: , x_msg_data out nocopy VARCHAR2
491: , p5_a0 JTF_NUMBER_TABLE
492: , p5_a1 JTF_VARCHAR2_TABLE_100
493: , p5_a2 JTF_VARCHAR2_TABLE_2000
494: , p5_a3 JTF_VARCHAR2_TABLE_200
495: , p5_a4 JTF_VARCHAR2_TABLE_1000
496: , p5_a5 JTF_NUMBER_TABLE

Line 495: , p5_a4 JTF_VARCHAR2_TABLE_1000

491: , p5_a0 JTF_NUMBER_TABLE
492: , p5_a1 JTF_VARCHAR2_TABLE_100
493: , p5_a2 JTF_VARCHAR2_TABLE_2000
494: , p5_a3 JTF_VARCHAR2_TABLE_200
495: , p5_a4 JTF_VARCHAR2_TABLE_1000
496: , p5_a5 JTF_NUMBER_TABLE
497: , p5_a6 JTF_VARCHAR2_TABLE_300
498: , p5_a7 JTF_VARCHAR2_TABLE_100
499: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 498: , p5_a7 JTF_VARCHAR2_TABLE_100

494: , p5_a3 JTF_VARCHAR2_TABLE_200
495: , p5_a4 JTF_VARCHAR2_TABLE_1000
496: , p5_a5 JTF_NUMBER_TABLE
497: , p5_a6 JTF_VARCHAR2_TABLE_300
498: , p5_a7 JTF_VARCHAR2_TABLE_100
499: , p5_a8 JTF_VARCHAR2_TABLE_500
500: , p5_a9 JTF_VARCHAR2_TABLE_500
501: , p5_a10 JTF_VARCHAR2_TABLE_500
502: , p5_a11 JTF_VARCHAR2_TABLE_500

Line 562: , p5_a1 JTF_VARCHAR2_TABLE_100

558: , x_return_status out nocopy VARCHAR2
559: , x_msg_count out nocopy NUMBER
560: , x_msg_data out nocopy VARCHAR2
561: , p5_a0 JTF_NUMBER_TABLE
562: , p5_a1 JTF_VARCHAR2_TABLE_100
563: , p5_a2 JTF_VARCHAR2_TABLE_2000
564: , p5_a3 JTF_VARCHAR2_TABLE_200
565: , p5_a4 JTF_VARCHAR2_TABLE_1000
566: , p5_a5 JTF_NUMBER_TABLE

Line 565: , p5_a4 JTF_VARCHAR2_TABLE_1000

561: , p5_a0 JTF_NUMBER_TABLE
562: , p5_a1 JTF_VARCHAR2_TABLE_100
563: , p5_a2 JTF_VARCHAR2_TABLE_2000
564: , p5_a3 JTF_VARCHAR2_TABLE_200
565: , p5_a4 JTF_VARCHAR2_TABLE_1000
566: , p5_a5 JTF_NUMBER_TABLE
567: , p5_a6 JTF_VARCHAR2_TABLE_300
568: , p5_a7 JTF_VARCHAR2_TABLE_100
569: , p5_a8 JTF_VARCHAR2_TABLE_500

Line 568: , p5_a7 JTF_VARCHAR2_TABLE_100

564: , p5_a3 JTF_VARCHAR2_TABLE_200
565: , p5_a4 JTF_VARCHAR2_TABLE_1000
566: , p5_a5 JTF_NUMBER_TABLE
567: , p5_a6 JTF_VARCHAR2_TABLE_300
568: , p5_a7 JTF_VARCHAR2_TABLE_100
569: , p5_a8 JTF_VARCHAR2_TABLE_500
570: , p5_a9 JTF_VARCHAR2_TABLE_500
571: , p5_a10 JTF_VARCHAR2_TABLE_500
572: , p5_a11 JTF_VARCHAR2_TABLE_500