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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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