1: package okl_idx_pvt_w as
2: /* $Header: OKLIIDXS.pls 120.1 2005/07/13 09:26:56 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_idx_pvt.idx_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_NUMBER_TABLE
2: /* $Header: OKLIIDXS.pls 120.1 2005/07/13 09:26:56 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_idx_pvt.idx_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_500
15: , a12 JTF_VARCHAR2_TABLE_500
16: , a13 JTF_VARCHAR2_TABLE_500
17: , a14 JTF_VARCHAR2_TABLE_500
33: , a30 JTF_NUMBER_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_idx_pvt.idx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_VARCHAR2_TABLE_200
37: , a2 out nocopy JTF_VARCHAR2_TABLE_100
38: , a3 out nocopy JTF_VARCHAR2_TABLE_100
39: , a4 out nocopy JTF_NUMBER_TABLE
40: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
41: , a6 out nocopy JTF_NUMBER_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_idx_pvt.idx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_VARCHAR2_TABLE_200
37: , a2 out nocopy JTF_VARCHAR2_TABLE_100
38: , a3 out nocopy JTF_VARCHAR2_TABLE_100
39: , a4 out nocopy JTF_NUMBER_TABLE
40: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
41: , a6 out nocopy JTF_NUMBER_TABLE
42: , a7 out nocopy JTF_NUMBER_TABLE
41: , a6 out nocopy JTF_NUMBER_TABLE
42: , a7 out nocopy JTF_NUMBER_TABLE
43: , a8 out nocopy JTF_NUMBER_TABLE
44: , a9 out nocopy JTF_DATE_TABLE
45: , a10 out nocopy JTF_VARCHAR2_TABLE_100
46: , a11 out nocopy JTF_VARCHAR2_TABLE_500
47: , a12 out nocopy JTF_VARCHAR2_TABLE_500
48: , a13 out nocopy JTF_VARCHAR2_TABLE_500
49: , a14 out nocopy JTF_VARCHAR2_TABLE_500
68: procedure rosetta_table_copy_in_p5(t out nocopy okl_idx_pvt.idxv_tbl_type, a0 JTF_NUMBER_TABLE
69: , a1 JTF_NUMBER_TABLE
70: , a2 JTF_VARCHAR2_TABLE_200
71: , a3 JTF_VARCHAR2_TABLE_2000
72: , a4 JTF_VARCHAR2_TABLE_100
73: , a5 JTF_VARCHAR2_TABLE_500
74: , a6 JTF_VARCHAR2_TABLE_500
75: , a7 JTF_VARCHAR2_TABLE_500
76: , a8 JTF_VARCHAR2_TABLE_500
84: , a16 JTF_VARCHAR2_TABLE_500
85: , a17 JTF_VARCHAR2_TABLE_500
86: , a18 JTF_VARCHAR2_TABLE_500
87: , a19 JTF_VARCHAR2_TABLE_500
88: , a20 JTF_VARCHAR2_TABLE_100
89: , a21 JTF_VARCHAR2_TABLE_100
90: , a22 JTF_NUMBER_TABLE
91: , a23 JTF_NUMBER_TABLE
92: , a24 JTF_NUMBER_TABLE
85: , a17 JTF_VARCHAR2_TABLE_500
86: , a18 JTF_VARCHAR2_TABLE_500
87: , a19 JTF_VARCHAR2_TABLE_500
88: , a20 JTF_VARCHAR2_TABLE_100
89: , a21 JTF_VARCHAR2_TABLE_100
90: , a22 JTF_NUMBER_TABLE
91: , a23 JTF_NUMBER_TABLE
92: , a24 JTF_NUMBER_TABLE
93: , a25 JTF_DATE_TABLE
100: procedure rosetta_table_copy_out_p5(t okl_idx_pvt.idxv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_NUMBER_TABLE
102: , a2 out nocopy JTF_VARCHAR2_TABLE_200
103: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
104: , a4 out nocopy JTF_VARCHAR2_TABLE_100
105: , a5 out nocopy JTF_VARCHAR2_TABLE_500
106: , a6 out nocopy JTF_VARCHAR2_TABLE_500
107: , a7 out nocopy JTF_VARCHAR2_TABLE_500
108: , a8 out nocopy JTF_VARCHAR2_TABLE_500
116: , a16 out nocopy JTF_VARCHAR2_TABLE_500
117: , a17 out nocopy JTF_VARCHAR2_TABLE_500
118: , a18 out nocopy JTF_VARCHAR2_TABLE_500
119: , a19 out nocopy JTF_VARCHAR2_TABLE_500
120: , a20 out nocopy JTF_VARCHAR2_TABLE_100
121: , a21 out nocopy JTF_VARCHAR2_TABLE_100
122: , a22 out nocopy JTF_NUMBER_TABLE
123: , a23 out nocopy JTF_NUMBER_TABLE
124: , a24 out nocopy JTF_NUMBER_TABLE
117: , a17 out nocopy JTF_VARCHAR2_TABLE_500
118: , a18 out nocopy JTF_VARCHAR2_TABLE_500
119: , a19 out nocopy JTF_VARCHAR2_TABLE_500
120: , a20 out nocopy JTF_VARCHAR2_TABLE_100
121: , a21 out nocopy JTF_VARCHAR2_TABLE_100
122: , a22 out nocopy JTF_NUMBER_TABLE
123: , a23 out nocopy JTF_NUMBER_TABLE
124: , a24 out nocopy JTF_NUMBER_TABLE
125: , a25 out nocopy JTF_DATE_TABLE
206: , p5_a0 JTF_NUMBER_TABLE
207: , p5_a1 JTF_NUMBER_TABLE
208: , p5_a2 JTF_VARCHAR2_TABLE_200
209: , p5_a3 JTF_VARCHAR2_TABLE_2000
210: , p5_a4 JTF_VARCHAR2_TABLE_100
211: , p5_a5 JTF_VARCHAR2_TABLE_500
212: , p5_a6 JTF_VARCHAR2_TABLE_500
213: , p5_a7 JTF_VARCHAR2_TABLE_500
214: , p5_a8 JTF_VARCHAR2_TABLE_500
222: , p5_a16 JTF_VARCHAR2_TABLE_500
223: , p5_a17 JTF_VARCHAR2_TABLE_500
224: , p5_a18 JTF_VARCHAR2_TABLE_500
225: , p5_a19 JTF_VARCHAR2_TABLE_500
226: , p5_a20 JTF_VARCHAR2_TABLE_100
227: , p5_a21 JTF_VARCHAR2_TABLE_100
228: , p5_a22 JTF_NUMBER_TABLE
229: , p5_a23 JTF_NUMBER_TABLE
230: , p5_a24 JTF_NUMBER_TABLE
223: , p5_a17 JTF_VARCHAR2_TABLE_500
224: , p5_a18 JTF_VARCHAR2_TABLE_500
225: , p5_a19 JTF_VARCHAR2_TABLE_500
226: , p5_a20 JTF_VARCHAR2_TABLE_100
227: , p5_a21 JTF_VARCHAR2_TABLE_100
228: , p5_a22 JTF_NUMBER_TABLE
229: , p5_a23 JTF_NUMBER_TABLE
230: , p5_a24 JTF_NUMBER_TABLE
231: , p5_a25 JTF_DATE_TABLE
237: , p6_a0 out nocopy JTF_NUMBER_TABLE
238: , p6_a1 out nocopy JTF_NUMBER_TABLE
239: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
240: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
241: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
242: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
243: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
244: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
245: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
253: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
254: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
255: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
256: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
257: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
258: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
259: , p6_a22 out nocopy JTF_NUMBER_TABLE
260: , p6_a23 out nocopy JTF_NUMBER_TABLE
261: , p6_a24 out nocopy JTF_NUMBER_TABLE
254: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
255: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
256: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
257: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
258: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
259: , p6_a22 out nocopy JTF_NUMBER_TABLE
260: , p6_a23 out nocopy JTF_NUMBER_TABLE
261: , p6_a24 out nocopy JTF_NUMBER_TABLE
262: , p6_a25 out nocopy JTF_DATE_TABLE
311: , p5_a0 JTF_NUMBER_TABLE
312: , p5_a1 JTF_NUMBER_TABLE
313: , p5_a2 JTF_VARCHAR2_TABLE_200
314: , p5_a3 JTF_VARCHAR2_TABLE_2000
315: , p5_a4 JTF_VARCHAR2_TABLE_100
316: , p5_a5 JTF_VARCHAR2_TABLE_500
317: , p5_a6 JTF_VARCHAR2_TABLE_500
318: , p5_a7 JTF_VARCHAR2_TABLE_500
319: , p5_a8 JTF_VARCHAR2_TABLE_500
327: , p5_a16 JTF_VARCHAR2_TABLE_500
328: , p5_a17 JTF_VARCHAR2_TABLE_500
329: , p5_a18 JTF_VARCHAR2_TABLE_500
330: , p5_a19 JTF_VARCHAR2_TABLE_500
331: , p5_a20 JTF_VARCHAR2_TABLE_100
332: , p5_a21 JTF_VARCHAR2_TABLE_100
333: , p5_a22 JTF_NUMBER_TABLE
334: , p5_a23 JTF_NUMBER_TABLE
335: , p5_a24 JTF_NUMBER_TABLE
328: , p5_a17 JTF_VARCHAR2_TABLE_500
329: , p5_a18 JTF_VARCHAR2_TABLE_500
330: , p5_a19 JTF_VARCHAR2_TABLE_500
331: , p5_a20 JTF_VARCHAR2_TABLE_100
332: , p5_a21 JTF_VARCHAR2_TABLE_100
333: , p5_a22 JTF_NUMBER_TABLE
334: , p5_a23 JTF_NUMBER_TABLE
335: , p5_a24 JTF_NUMBER_TABLE
336: , p5_a25 JTF_DATE_TABLE
416: , p5_a0 JTF_NUMBER_TABLE
417: , p5_a1 JTF_NUMBER_TABLE
418: , p5_a2 JTF_VARCHAR2_TABLE_200
419: , p5_a3 JTF_VARCHAR2_TABLE_2000
420: , p5_a4 JTF_VARCHAR2_TABLE_100
421: , p5_a5 JTF_VARCHAR2_TABLE_500
422: , p5_a6 JTF_VARCHAR2_TABLE_500
423: , p5_a7 JTF_VARCHAR2_TABLE_500
424: , p5_a8 JTF_VARCHAR2_TABLE_500
432: , p5_a16 JTF_VARCHAR2_TABLE_500
433: , p5_a17 JTF_VARCHAR2_TABLE_500
434: , p5_a18 JTF_VARCHAR2_TABLE_500
435: , p5_a19 JTF_VARCHAR2_TABLE_500
436: , p5_a20 JTF_VARCHAR2_TABLE_100
437: , p5_a21 JTF_VARCHAR2_TABLE_100
438: , p5_a22 JTF_NUMBER_TABLE
439: , p5_a23 JTF_NUMBER_TABLE
440: , p5_a24 JTF_NUMBER_TABLE
433: , p5_a17 JTF_VARCHAR2_TABLE_500
434: , p5_a18 JTF_VARCHAR2_TABLE_500
435: , p5_a19 JTF_VARCHAR2_TABLE_500
436: , p5_a20 JTF_VARCHAR2_TABLE_100
437: , p5_a21 JTF_VARCHAR2_TABLE_100
438: , p5_a22 JTF_NUMBER_TABLE
439: , p5_a23 JTF_NUMBER_TABLE
440: , p5_a24 JTF_NUMBER_TABLE
441: , p5_a25 JTF_DATE_TABLE
447: , p6_a0 out nocopy JTF_NUMBER_TABLE
448: , p6_a1 out nocopy JTF_NUMBER_TABLE
449: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
450: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
451: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
452: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_500
453: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
454: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
455: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
463: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
464: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
465: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
466: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
467: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
468: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
469: , p6_a22 out nocopy JTF_NUMBER_TABLE
470: , p6_a23 out nocopy JTF_NUMBER_TABLE
471: , p6_a24 out nocopy JTF_NUMBER_TABLE
464: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
465: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
466: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
467: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
468: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
469: , p6_a22 out nocopy JTF_NUMBER_TABLE
470: , p6_a23 out nocopy JTF_NUMBER_TABLE
471: , p6_a24 out nocopy JTF_NUMBER_TABLE
472: , p6_a25 out nocopy JTF_DATE_TABLE
521: , p5_a0 JTF_NUMBER_TABLE
522: , p5_a1 JTF_NUMBER_TABLE
523: , p5_a2 JTF_VARCHAR2_TABLE_200
524: , p5_a3 JTF_VARCHAR2_TABLE_2000
525: , p5_a4 JTF_VARCHAR2_TABLE_100
526: , p5_a5 JTF_VARCHAR2_TABLE_500
527: , p5_a6 JTF_VARCHAR2_TABLE_500
528: , p5_a7 JTF_VARCHAR2_TABLE_500
529: , p5_a8 JTF_VARCHAR2_TABLE_500
537: , p5_a16 JTF_VARCHAR2_TABLE_500
538: , p5_a17 JTF_VARCHAR2_TABLE_500
539: , p5_a18 JTF_VARCHAR2_TABLE_500
540: , p5_a19 JTF_VARCHAR2_TABLE_500
541: , p5_a20 JTF_VARCHAR2_TABLE_100
542: , p5_a21 JTF_VARCHAR2_TABLE_100
543: , p5_a22 JTF_NUMBER_TABLE
544: , p5_a23 JTF_NUMBER_TABLE
545: , p5_a24 JTF_NUMBER_TABLE
538: , p5_a17 JTF_VARCHAR2_TABLE_500
539: , p5_a18 JTF_VARCHAR2_TABLE_500
540: , p5_a19 JTF_VARCHAR2_TABLE_500
541: , p5_a20 JTF_VARCHAR2_TABLE_100
542: , p5_a21 JTF_VARCHAR2_TABLE_100
543: , p5_a22 JTF_NUMBER_TABLE
544: , p5_a23 JTF_NUMBER_TABLE
545: , p5_a24 JTF_NUMBER_TABLE
546: , p5_a25 JTF_DATE_TABLE
595: , p5_a0 JTF_NUMBER_TABLE
596: , p5_a1 JTF_NUMBER_TABLE
597: , p5_a2 JTF_VARCHAR2_TABLE_200
598: , p5_a3 JTF_VARCHAR2_TABLE_2000
599: , p5_a4 JTF_VARCHAR2_TABLE_100
600: , p5_a5 JTF_VARCHAR2_TABLE_500
601: , p5_a6 JTF_VARCHAR2_TABLE_500
602: , p5_a7 JTF_VARCHAR2_TABLE_500
603: , p5_a8 JTF_VARCHAR2_TABLE_500
611: , p5_a16 JTF_VARCHAR2_TABLE_500
612: , p5_a17 JTF_VARCHAR2_TABLE_500
613: , p5_a18 JTF_VARCHAR2_TABLE_500
614: , p5_a19 JTF_VARCHAR2_TABLE_500
615: , p5_a20 JTF_VARCHAR2_TABLE_100
616: , p5_a21 JTF_VARCHAR2_TABLE_100
617: , p5_a22 JTF_NUMBER_TABLE
618: , p5_a23 JTF_NUMBER_TABLE
619: , p5_a24 JTF_NUMBER_TABLE
612: , p5_a17 JTF_VARCHAR2_TABLE_500
613: , p5_a18 JTF_VARCHAR2_TABLE_500
614: , p5_a19 JTF_VARCHAR2_TABLE_500
615: , p5_a20 JTF_VARCHAR2_TABLE_100
616: , p5_a21 JTF_VARCHAR2_TABLE_100
617: , p5_a22 JTF_NUMBER_TABLE
618: , p5_a23 JTF_NUMBER_TABLE
619: , p5_a24 JTF_NUMBER_TABLE
620: , p5_a25 JTF_DATE_TABLE