1: package okl_clm_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLICLMS.pls 115.2 2003/05/26 07:45:41 arajagop noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_clm_pvt.clmv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_2000
13: , a10 JTF_VARCHAR2_TABLE_300
14: , a11 JTF_VARCHAR2_TABLE_300
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_VARCHAR2_TABLE_500
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_2000
13: , a10 JTF_VARCHAR2_TABLE_300
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
42: , a39 JTF_NUMBER_TABLE
43: );
44: procedure rosetta_table_copy_out_p2(t okl_clm_pvt.clmv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_VARCHAR2_TABLE_300
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_VARCHAR2_TABLE_100
49: , a5 out nocopy JTF_VARCHAR2_TABLE_100
50: , a6 out nocopy JTF_VARCHAR2_TABLE_100
50: , a6 out nocopy JTF_VARCHAR2_TABLE_100
51: , a7 out nocopy JTF_DATE_TABLE
52: , a8 out nocopy JTF_DATE_TABLE
53: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
54: , a10 out nocopy JTF_VARCHAR2_TABLE_300
55: , a11 out nocopy JTF_VARCHAR2_TABLE_300
56: , a12 out nocopy JTF_NUMBER_TABLE
57: , a13 out nocopy JTF_VARCHAR2_TABLE_100
58: , a14 out nocopy JTF_VARCHAR2_TABLE_500
51: , a7 out nocopy JTF_DATE_TABLE
52: , a8 out nocopy JTF_DATE_TABLE
53: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
54: , a10 out nocopy JTF_VARCHAR2_TABLE_300
55: , a11 out nocopy JTF_VARCHAR2_TABLE_300
56: , a12 out nocopy JTF_NUMBER_TABLE
57: , a13 out nocopy JTF_VARCHAR2_TABLE_100
58: , a14 out nocopy JTF_VARCHAR2_TABLE_500
59: , a15 out nocopy JTF_VARCHAR2_TABLE_500
91: , a5 JTF_DATE_TABLE
92: , a6 JTF_DATE_TABLE
93: , a7 JTF_NUMBER_TABLE
94: , a8 JTF_DATE_TABLE
95: , a9 JTF_VARCHAR2_TABLE_300
96: , a10 JTF_NUMBER_TABLE
97: , a11 JTF_NUMBER_TABLE
98: , a12 JTF_NUMBER_TABLE
99: , a13 JTF_NUMBER_TABLE
129: , a5 out nocopy JTF_DATE_TABLE
130: , a6 out nocopy JTF_DATE_TABLE
131: , a7 out nocopy JTF_NUMBER_TABLE
132: , a8 out nocopy JTF_DATE_TABLE
133: , a9 out nocopy JTF_VARCHAR2_TABLE_300
134: , a10 out nocopy JTF_NUMBER_TABLE
135: , a11 out nocopy JTF_NUMBER_TABLE
136: , a12 out nocopy JTF_NUMBER_TABLE
137: , a13 out nocopy JTF_NUMBER_TABLE
160: , a36 out nocopy JTF_NUMBER_TABLE
161: );
162:
163: procedure rosetta_table_copy_in_p8(t out nocopy okl_clm_pvt.okl_ins_claims_tl_tbl_type, a0 JTF_NUMBER_TABLE
164: , a1 JTF_VARCHAR2_TABLE_300
165: , a2 JTF_VARCHAR2_TABLE_2000
166: , a3 JTF_VARCHAR2_TABLE_300
167: , a4 JTF_VARCHAR2_TABLE_2000
168: , a5 JTF_VARCHAR2_TABLE_300
162:
163: procedure rosetta_table_copy_in_p8(t out nocopy okl_clm_pvt.okl_ins_claims_tl_tbl_type, a0 JTF_NUMBER_TABLE
164: , a1 JTF_VARCHAR2_TABLE_300
165: , a2 JTF_VARCHAR2_TABLE_2000
166: , a3 JTF_VARCHAR2_TABLE_300
167: , a4 JTF_VARCHAR2_TABLE_2000
168: , a5 JTF_VARCHAR2_TABLE_300
169: , a6 JTF_VARCHAR2_TABLE_300
170: , a7 JTF_NUMBER_TABLE
164: , a1 JTF_VARCHAR2_TABLE_300
165: , a2 JTF_VARCHAR2_TABLE_2000
166: , a3 JTF_VARCHAR2_TABLE_300
167: , a4 JTF_VARCHAR2_TABLE_2000
168: , a5 JTF_VARCHAR2_TABLE_300
169: , a6 JTF_VARCHAR2_TABLE_300
170: , a7 JTF_NUMBER_TABLE
171: , a8 JTF_DATE_TABLE
172: , a9 JTF_NUMBER_TABLE
165: , a2 JTF_VARCHAR2_TABLE_2000
166: , a3 JTF_VARCHAR2_TABLE_300
167: , a4 JTF_VARCHAR2_TABLE_2000
168: , a5 JTF_VARCHAR2_TABLE_300
169: , a6 JTF_VARCHAR2_TABLE_300
170: , a7 JTF_NUMBER_TABLE
171: , a8 JTF_DATE_TABLE
172: , a9 JTF_NUMBER_TABLE
173: , a10 JTF_DATE_TABLE
173: , a10 JTF_DATE_TABLE
174: , a11 JTF_NUMBER_TABLE
175: );
176: procedure rosetta_table_copy_out_p8(t okl_clm_pvt.okl_ins_claims_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
177: , a1 out nocopy JTF_VARCHAR2_TABLE_300
178: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
179: , a3 out nocopy JTF_VARCHAR2_TABLE_300
180: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
181: , a5 out nocopy JTF_VARCHAR2_TABLE_300
175: );
176: procedure rosetta_table_copy_out_p8(t okl_clm_pvt.okl_ins_claims_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
177: , a1 out nocopy JTF_VARCHAR2_TABLE_300
178: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
179: , a3 out nocopy JTF_VARCHAR2_TABLE_300
180: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
181: , a5 out nocopy JTF_VARCHAR2_TABLE_300
182: , a6 out nocopy JTF_VARCHAR2_TABLE_300
183: , a7 out nocopy JTF_NUMBER_TABLE
177: , a1 out nocopy JTF_VARCHAR2_TABLE_300
178: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
179: , a3 out nocopy JTF_VARCHAR2_TABLE_300
180: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
181: , a5 out nocopy JTF_VARCHAR2_TABLE_300
182: , a6 out nocopy JTF_VARCHAR2_TABLE_300
183: , a7 out nocopy JTF_NUMBER_TABLE
184: , a8 out nocopy JTF_DATE_TABLE
185: , a9 out nocopy JTF_NUMBER_TABLE
178: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
179: , a3 out nocopy JTF_VARCHAR2_TABLE_300
180: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
181: , a5 out nocopy JTF_VARCHAR2_TABLE_300
182: , a6 out nocopy JTF_VARCHAR2_TABLE_300
183: , a7 out nocopy JTF_NUMBER_TABLE
184: , a8 out nocopy JTF_DATE_TABLE
185: , a9 out nocopy JTF_NUMBER_TABLE
186: , a10 out nocopy JTF_DATE_TABLE
279: , x_msg_count out nocopy NUMBER
280: , x_msg_data out nocopy VARCHAR2
281: , p5_a0 JTF_NUMBER_TABLE
282: , p5_a1 JTF_NUMBER_TABLE
283: , p5_a2 JTF_VARCHAR2_TABLE_300
284: , p5_a3 JTF_NUMBER_TABLE
285: , p5_a4 JTF_VARCHAR2_TABLE_100
286: , p5_a5 JTF_VARCHAR2_TABLE_100
287: , p5_a6 JTF_VARCHAR2_TABLE_100
287: , p5_a6 JTF_VARCHAR2_TABLE_100
288: , p5_a7 JTF_DATE_TABLE
289: , p5_a8 JTF_DATE_TABLE
290: , p5_a9 JTF_VARCHAR2_TABLE_2000
291: , p5_a10 JTF_VARCHAR2_TABLE_300
292: , p5_a11 JTF_VARCHAR2_TABLE_300
293: , p5_a12 JTF_NUMBER_TABLE
294: , p5_a13 JTF_VARCHAR2_TABLE_100
295: , p5_a14 JTF_VARCHAR2_TABLE_500
288: , p5_a7 JTF_DATE_TABLE
289: , p5_a8 JTF_DATE_TABLE
290: , p5_a9 JTF_VARCHAR2_TABLE_2000
291: , p5_a10 JTF_VARCHAR2_TABLE_300
292: , p5_a11 JTF_VARCHAR2_TABLE_300
293: , p5_a12 JTF_NUMBER_TABLE
294: , p5_a13 JTF_VARCHAR2_TABLE_100
295: , p5_a14 JTF_VARCHAR2_TABLE_500
296: , p5_a15 JTF_VARCHAR2_TABLE_500
319: , p5_a38 JTF_DATE_TABLE
320: , p5_a39 JTF_NUMBER_TABLE
321: , p6_a0 out nocopy JTF_NUMBER_TABLE
322: , p6_a1 out nocopy JTF_NUMBER_TABLE
323: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
324: , p6_a3 out nocopy JTF_NUMBER_TABLE
325: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
326: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
327: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
327: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
328: , p6_a7 out nocopy JTF_DATE_TABLE
329: , p6_a8 out nocopy JTF_DATE_TABLE
330: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
331: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
332: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
333: , p6_a12 out nocopy JTF_NUMBER_TABLE
334: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
335: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
328: , p6_a7 out nocopy JTF_DATE_TABLE
329: , p6_a8 out nocopy JTF_DATE_TABLE
330: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
331: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
332: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
333: , p6_a12 out nocopy JTF_NUMBER_TABLE
334: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
335: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
336: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
411: , x_msg_count out nocopy NUMBER
412: , x_msg_data out nocopy VARCHAR2
413: , p5_a0 JTF_NUMBER_TABLE
414: , p5_a1 JTF_NUMBER_TABLE
415: , p5_a2 JTF_VARCHAR2_TABLE_300
416: , p5_a3 JTF_NUMBER_TABLE
417: , p5_a4 JTF_VARCHAR2_TABLE_100
418: , p5_a5 JTF_VARCHAR2_TABLE_100
419: , p5_a6 JTF_VARCHAR2_TABLE_100
419: , p5_a6 JTF_VARCHAR2_TABLE_100
420: , p5_a7 JTF_DATE_TABLE
421: , p5_a8 JTF_DATE_TABLE
422: , p5_a9 JTF_VARCHAR2_TABLE_2000
423: , p5_a10 JTF_VARCHAR2_TABLE_300
424: , p5_a11 JTF_VARCHAR2_TABLE_300
425: , p5_a12 JTF_NUMBER_TABLE
426: , p5_a13 JTF_VARCHAR2_TABLE_100
427: , p5_a14 JTF_VARCHAR2_TABLE_500
420: , p5_a7 JTF_DATE_TABLE
421: , p5_a8 JTF_DATE_TABLE
422: , p5_a9 JTF_VARCHAR2_TABLE_2000
423: , p5_a10 JTF_VARCHAR2_TABLE_300
424: , p5_a11 JTF_VARCHAR2_TABLE_300
425: , p5_a12 JTF_NUMBER_TABLE
426: , p5_a13 JTF_VARCHAR2_TABLE_100
427: , p5_a14 JTF_VARCHAR2_TABLE_500
428: , p5_a15 JTF_VARCHAR2_TABLE_500
543: , x_msg_count out nocopy NUMBER
544: , x_msg_data out nocopy VARCHAR2
545: , p5_a0 JTF_NUMBER_TABLE
546: , p5_a1 JTF_NUMBER_TABLE
547: , p5_a2 JTF_VARCHAR2_TABLE_300
548: , p5_a3 JTF_NUMBER_TABLE
549: , p5_a4 JTF_VARCHAR2_TABLE_100
550: , p5_a5 JTF_VARCHAR2_TABLE_100
551: , p5_a6 JTF_VARCHAR2_TABLE_100
551: , p5_a6 JTF_VARCHAR2_TABLE_100
552: , p5_a7 JTF_DATE_TABLE
553: , p5_a8 JTF_DATE_TABLE
554: , p5_a9 JTF_VARCHAR2_TABLE_2000
555: , p5_a10 JTF_VARCHAR2_TABLE_300
556: , p5_a11 JTF_VARCHAR2_TABLE_300
557: , p5_a12 JTF_NUMBER_TABLE
558: , p5_a13 JTF_VARCHAR2_TABLE_100
559: , p5_a14 JTF_VARCHAR2_TABLE_500
552: , p5_a7 JTF_DATE_TABLE
553: , p5_a8 JTF_DATE_TABLE
554: , p5_a9 JTF_VARCHAR2_TABLE_2000
555: , p5_a10 JTF_VARCHAR2_TABLE_300
556: , p5_a11 JTF_VARCHAR2_TABLE_300
557: , p5_a12 JTF_NUMBER_TABLE
558: , p5_a13 JTF_VARCHAR2_TABLE_100
559: , p5_a14 JTF_VARCHAR2_TABLE_500
560: , p5_a15 JTF_VARCHAR2_TABLE_500
583: , p5_a38 JTF_DATE_TABLE
584: , p5_a39 JTF_NUMBER_TABLE
585: , p6_a0 out nocopy JTF_NUMBER_TABLE
586: , p6_a1 out nocopy JTF_NUMBER_TABLE
587: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
588: , p6_a3 out nocopy JTF_NUMBER_TABLE
589: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
590: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
591: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
591: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
592: , p6_a7 out nocopy JTF_DATE_TABLE
593: , p6_a8 out nocopy JTF_DATE_TABLE
594: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
595: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
596: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
597: , p6_a12 out nocopy JTF_NUMBER_TABLE
598: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
599: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
592: , p6_a7 out nocopy JTF_DATE_TABLE
593: , p6_a8 out nocopy JTF_DATE_TABLE
594: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_2000
595: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300
596: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
597: , p6_a12 out nocopy JTF_NUMBER_TABLE
598: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
599: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500
600: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_500
675: , x_msg_count out nocopy NUMBER
676: , x_msg_data out nocopy VARCHAR2
677: , p5_a0 JTF_NUMBER_TABLE
678: , p5_a1 JTF_NUMBER_TABLE
679: , p5_a2 JTF_VARCHAR2_TABLE_300
680: , p5_a3 JTF_NUMBER_TABLE
681: , p5_a4 JTF_VARCHAR2_TABLE_100
682: , p5_a5 JTF_VARCHAR2_TABLE_100
683: , p5_a6 JTF_VARCHAR2_TABLE_100
683: , p5_a6 JTF_VARCHAR2_TABLE_100
684: , p5_a7 JTF_DATE_TABLE
685: , p5_a8 JTF_DATE_TABLE
686: , p5_a9 JTF_VARCHAR2_TABLE_2000
687: , p5_a10 JTF_VARCHAR2_TABLE_300
688: , p5_a11 JTF_VARCHAR2_TABLE_300
689: , p5_a12 JTF_NUMBER_TABLE
690: , p5_a13 JTF_VARCHAR2_TABLE_100
691: , p5_a14 JTF_VARCHAR2_TABLE_500
684: , p5_a7 JTF_DATE_TABLE
685: , p5_a8 JTF_DATE_TABLE
686: , p5_a9 JTF_VARCHAR2_TABLE_2000
687: , p5_a10 JTF_VARCHAR2_TABLE_300
688: , p5_a11 JTF_VARCHAR2_TABLE_300
689: , p5_a12 JTF_NUMBER_TABLE
690: , p5_a13 JTF_VARCHAR2_TABLE_100
691: , p5_a14 JTF_VARCHAR2_TABLE_500
692: , p5_a15 JTF_VARCHAR2_TABLE_500
767: , x_msg_count out nocopy NUMBER
768: , x_msg_data out nocopy VARCHAR2
769: , p5_a0 JTF_NUMBER_TABLE
770: , p5_a1 JTF_NUMBER_TABLE
771: , p5_a2 JTF_VARCHAR2_TABLE_300
772: , p5_a3 JTF_NUMBER_TABLE
773: , p5_a4 JTF_VARCHAR2_TABLE_100
774: , p5_a5 JTF_VARCHAR2_TABLE_100
775: , p5_a6 JTF_VARCHAR2_TABLE_100
775: , p5_a6 JTF_VARCHAR2_TABLE_100
776: , p5_a7 JTF_DATE_TABLE
777: , p5_a8 JTF_DATE_TABLE
778: , p5_a9 JTF_VARCHAR2_TABLE_2000
779: , p5_a10 JTF_VARCHAR2_TABLE_300
780: , p5_a11 JTF_VARCHAR2_TABLE_300
781: , p5_a12 JTF_NUMBER_TABLE
782: , p5_a13 JTF_VARCHAR2_TABLE_100
783: , p5_a14 JTF_VARCHAR2_TABLE_500
776: , p5_a7 JTF_DATE_TABLE
777: , p5_a8 JTF_DATE_TABLE
778: , p5_a9 JTF_VARCHAR2_TABLE_2000
779: , p5_a10 JTF_VARCHAR2_TABLE_300
780: , p5_a11 JTF_VARCHAR2_TABLE_300
781: , p5_a12 JTF_NUMBER_TABLE
782: , p5_a13 JTF_VARCHAR2_TABLE_100
783: , p5_a14 JTF_VARCHAR2_TABLE_500
784: , p5_a15 JTF_VARCHAR2_TABLE_500