DBA Data[Home] [Help]

APPS.OKL_CLM_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 5: , a2 JTF_VARCHAR2_TABLE_300

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

Line 13: , a10 JTF_VARCHAR2_TABLE_300

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

Line 14: , a11 JTF_VARCHAR2_TABLE_300

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

Line 46: , a2 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 54: , a10 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 55: , a11 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 95: , a9 JTF_VARCHAR2_TABLE_300

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

Line 133: , a9 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 164: , a1 JTF_VARCHAR2_TABLE_300

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

Line 166: , a3 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

Line 168: , a5 JTF_VARCHAR2_TABLE_300

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

Line 169: , a6 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
173: , a10 JTF_DATE_TABLE

Line 177: , a1 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 179: , a3 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

Line 181: , a5 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 182: , a6 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
186: , a10 out nocopy JTF_DATE_TABLE

Line 283: , p5_a2 JTF_VARCHAR2_TABLE_300

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

Line 291: , p5_a10 JTF_VARCHAR2_TABLE_300

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

Line 292: , p5_a11 JTF_VARCHAR2_TABLE_300

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

Line 323: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 331: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 332: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 415: , p5_a2 JTF_VARCHAR2_TABLE_300

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

Line 423: , p5_a10 JTF_VARCHAR2_TABLE_300

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

Line 424: , p5_a11 JTF_VARCHAR2_TABLE_300

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

Line 547: , p5_a2 JTF_VARCHAR2_TABLE_300

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

Line 555: , p5_a10 JTF_VARCHAR2_TABLE_300

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

Line 556: , p5_a11 JTF_VARCHAR2_TABLE_300

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

Line 587: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 595: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 596: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300

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

Line 679: , p5_a2 JTF_VARCHAR2_TABLE_300

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

Line 687: , p5_a10 JTF_VARCHAR2_TABLE_300

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

Line 688: , p5_a11 JTF_VARCHAR2_TABLE_300

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

Line 771: , p5_a2 JTF_VARCHAR2_TABLE_300

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

Line 779: , p5_a10 JTF_VARCHAR2_TABLE_300

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

Line 780: , p5_a11 JTF_VARCHAR2_TABLE_300

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