2: /* $Header: OKLIIRKS.pls 120.1 2005/07/13 09:28:36 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_irk_pvt.irkv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_300
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_irk_pvt.irkv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_300
11: , a8 JTF_VARCHAR2_TABLE_300
23: , a20 JTF_VARCHAR2_TABLE_300
24: , a21 JTF_VARCHAR2_TABLE_300
25: , a22 JTF_VARCHAR2_TABLE_300
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: );
25: , a22 JTF_VARCHAR2_TABLE_300
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p2(t okl_irk_pvt.irkv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
31: );
32: procedure rosetta_table_copy_out_p2(t okl_irk_pvt.irkv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_DATE_TABLE
36: , a4 out nocopy JTF_DATE_TABLE
37: , a5 out nocopy JTF_NUMBER_TABLE
38: , a6 out nocopy JTF_VARCHAR2_TABLE_100
39: , a7 out nocopy JTF_VARCHAR2_TABLE_300
32: procedure rosetta_table_copy_out_p2(t okl_irk_pvt.irkv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
33: , a1 out nocopy JTF_NUMBER_TABLE
34: , a2 out nocopy JTF_NUMBER_TABLE
35: , a3 out nocopy JTF_DATE_TABLE
36: , a4 out nocopy JTF_DATE_TABLE
37: , a5 out nocopy JTF_NUMBER_TABLE
38: , a6 out nocopy JTF_VARCHAR2_TABLE_100
39: , a7 out nocopy JTF_VARCHAR2_TABLE_300
40: , a8 out nocopy JTF_VARCHAR2_TABLE_300
52: , a20 out nocopy JTF_VARCHAR2_TABLE_300
53: , a21 out nocopy JTF_VARCHAR2_TABLE_300
54: , a22 out nocopy JTF_VARCHAR2_TABLE_300
55: , a23 out nocopy JTF_NUMBER_TABLE
56: , a24 out nocopy JTF_DATE_TABLE
57: , a25 out nocopy JTF_NUMBER_TABLE
58: , a26 out nocopy JTF_DATE_TABLE
59: , a27 out nocopy JTF_NUMBER_TABLE
60: );
54: , a22 out nocopy JTF_VARCHAR2_TABLE_300
55: , a23 out nocopy JTF_NUMBER_TABLE
56: , a24 out nocopy JTF_DATE_TABLE
57: , a25 out nocopy JTF_NUMBER_TABLE
58: , a26 out nocopy JTF_DATE_TABLE
59: , a27 out nocopy JTF_NUMBER_TABLE
60: );
61:
62: procedure rosetta_table_copy_in_p5(t out nocopy okl_irk_pvt.irk_tbl_type, a0 JTF_NUMBER_TABLE
61:
62: procedure rosetta_table_copy_in_p5(t out nocopy okl_irk_pvt.irk_tbl_type, a0 JTF_NUMBER_TABLE
63: , a1 JTF_NUMBER_TABLE
64: , a2 JTF_NUMBER_TABLE
65: , a3 JTF_DATE_TABLE
66: , a4 JTF_DATE_TABLE
67: , a5 JTF_NUMBER_TABLE
68: , a6 JTF_VARCHAR2_TABLE_100
69: , a7 JTF_VARCHAR2_TABLE_300
62: procedure rosetta_table_copy_in_p5(t out nocopy okl_irk_pvt.irk_tbl_type, a0 JTF_NUMBER_TABLE
63: , a1 JTF_NUMBER_TABLE
64: , a2 JTF_NUMBER_TABLE
65: , a3 JTF_DATE_TABLE
66: , a4 JTF_DATE_TABLE
67: , a5 JTF_NUMBER_TABLE
68: , a6 JTF_VARCHAR2_TABLE_100
69: , a7 JTF_VARCHAR2_TABLE_300
70: , a8 JTF_VARCHAR2_TABLE_300
82: , a20 JTF_VARCHAR2_TABLE_300
83: , a21 JTF_VARCHAR2_TABLE_300
84: , a22 JTF_VARCHAR2_TABLE_300
85: , a23 JTF_NUMBER_TABLE
86: , a24 JTF_DATE_TABLE
87: , a25 JTF_NUMBER_TABLE
88: , a26 JTF_DATE_TABLE
89: , a27 JTF_NUMBER_TABLE
90: );
84: , a22 JTF_VARCHAR2_TABLE_300
85: , a23 JTF_NUMBER_TABLE
86: , a24 JTF_DATE_TABLE
87: , a25 JTF_NUMBER_TABLE
88: , a26 JTF_DATE_TABLE
89: , a27 JTF_NUMBER_TABLE
90: );
91: procedure rosetta_table_copy_out_p5(t okl_irk_pvt.irk_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
90: );
91: procedure rosetta_table_copy_out_p5(t okl_irk_pvt.irk_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_NUMBER_TABLE
94: , a3 out nocopy JTF_DATE_TABLE
95: , a4 out nocopy JTF_DATE_TABLE
96: , a5 out nocopy JTF_NUMBER_TABLE
97: , a6 out nocopy JTF_VARCHAR2_TABLE_100
98: , a7 out nocopy JTF_VARCHAR2_TABLE_300
91: procedure rosetta_table_copy_out_p5(t okl_irk_pvt.irk_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
92: , a1 out nocopy JTF_NUMBER_TABLE
93: , a2 out nocopy JTF_NUMBER_TABLE
94: , a3 out nocopy JTF_DATE_TABLE
95: , a4 out nocopy JTF_DATE_TABLE
96: , a5 out nocopy JTF_NUMBER_TABLE
97: , a6 out nocopy JTF_VARCHAR2_TABLE_100
98: , a7 out nocopy JTF_VARCHAR2_TABLE_300
99: , a8 out nocopy JTF_VARCHAR2_TABLE_300
111: , a20 out nocopy JTF_VARCHAR2_TABLE_300
112: , a21 out nocopy JTF_VARCHAR2_TABLE_300
113: , a22 out nocopy JTF_VARCHAR2_TABLE_300
114: , a23 out nocopy JTF_NUMBER_TABLE
115: , a24 out nocopy JTF_DATE_TABLE
116: , a25 out nocopy JTF_NUMBER_TABLE
117: , a26 out nocopy JTF_DATE_TABLE
118: , a27 out nocopy JTF_NUMBER_TABLE
119: );
113: , a22 out nocopy JTF_VARCHAR2_TABLE_300
114: , a23 out nocopy JTF_NUMBER_TABLE
115: , a24 out nocopy JTF_DATE_TABLE
116: , a25 out nocopy JTF_NUMBER_TABLE
117: , a26 out nocopy JTF_DATE_TABLE
118: , a27 out nocopy JTF_NUMBER_TABLE
119: );
120:
121: procedure insert_row(p_api_version NUMBER
187: , x_msg_data out nocopy VARCHAR2
188: , p5_a0 JTF_NUMBER_TABLE
189: , p5_a1 JTF_NUMBER_TABLE
190: , p5_a2 JTF_NUMBER_TABLE
191: , p5_a3 JTF_DATE_TABLE
192: , p5_a4 JTF_DATE_TABLE
193: , p5_a5 JTF_NUMBER_TABLE
194: , p5_a6 JTF_VARCHAR2_TABLE_100
195: , p5_a7 JTF_VARCHAR2_TABLE_300
188: , p5_a0 JTF_NUMBER_TABLE
189: , p5_a1 JTF_NUMBER_TABLE
190: , p5_a2 JTF_NUMBER_TABLE
191: , p5_a3 JTF_DATE_TABLE
192: , p5_a4 JTF_DATE_TABLE
193: , p5_a5 JTF_NUMBER_TABLE
194: , p5_a6 JTF_VARCHAR2_TABLE_100
195: , p5_a7 JTF_VARCHAR2_TABLE_300
196: , p5_a8 JTF_VARCHAR2_TABLE_300
208: , p5_a20 JTF_VARCHAR2_TABLE_300
209: , p5_a21 JTF_VARCHAR2_TABLE_300
210: , p5_a22 JTF_VARCHAR2_TABLE_300
211: , p5_a23 JTF_NUMBER_TABLE
212: , p5_a24 JTF_DATE_TABLE
213: , p5_a25 JTF_NUMBER_TABLE
214: , p5_a26 JTF_DATE_TABLE
215: , p5_a27 JTF_NUMBER_TABLE
216: , p6_a0 out nocopy JTF_NUMBER_TABLE
210: , p5_a22 JTF_VARCHAR2_TABLE_300
211: , p5_a23 JTF_NUMBER_TABLE
212: , p5_a24 JTF_DATE_TABLE
213: , p5_a25 JTF_NUMBER_TABLE
214: , p5_a26 JTF_DATE_TABLE
215: , p5_a27 JTF_NUMBER_TABLE
216: , p6_a0 out nocopy JTF_NUMBER_TABLE
217: , p6_a1 out nocopy JTF_NUMBER_TABLE
218: , p6_a2 out nocopy JTF_NUMBER_TABLE
215: , p5_a27 JTF_NUMBER_TABLE
216: , p6_a0 out nocopy JTF_NUMBER_TABLE
217: , p6_a1 out nocopy JTF_NUMBER_TABLE
218: , p6_a2 out nocopy JTF_NUMBER_TABLE
219: , p6_a3 out nocopy JTF_DATE_TABLE
220: , p6_a4 out nocopy JTF_DATE_TABLE
221: , p6_a5 out nocopy JTF_NUMBER_TABLE
222: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
223: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
216: , p6_a0 out nocopy JTF_NUMBER_TABLE
217: , p6_a1 out nocopy JTF_NUMBER_TABLE
218: , p6_a2 out nocopy JTF_NUMBER_TABLE
219: , p6_a3 out nocopy JTF_DATE_TABLE
220: , p6_a4 out nocopy JTF_DATE_TABLE
221: , p6_a5 out nocopy JTF_NUMBER_TABLE
222: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
223: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
224: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300
236: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_300
237: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_300
238: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300
239: , p6_a23 out nocopy JTF_NUMBER_TABLE
240: , p6_a24 out nocopy JTF_DATE_TABLE
241: , p6_a25 out nocopy JTF_NUMBER_TABLE
242: , p6_a26 out nocopy JTF_DATE_TABLE
243: , p6_a27 out nocopy JTF_NUMBER_TABLE
244: );
238: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300
239: , p6_a23 out nocopy JTF_NUMBER_TABLE
240: , p6_a24 out nocopy JTF_DATE_TABLE
241: , p6_a25 out nocopy JTF_NUMBER_TABLE
242: , p6_a26 out nocopy JTF_DATE_TABLE
243: , p6_a27 out nocopy JTF_NUMBER_TABLE
244: );
245: procedure lock_row(p_api_version NUMBER
246: , p_init_msg_list VARCHAR2
283: , x_msg_data out nocopy VARCHAR2
284: , p5_a0 JTF_NUMBER_TABLE
285: , p5_a1 JTF_NUMBER_TABLE
286: , p5_a2 JTF_NUMBER_TABLE
287: , p5_a3 JTF_DATE_TABLE
288: , p5_a4 JTF_DATE_TABLE
289: , p5_a5 JTF_NUMBER_TABLE
290: , p5_a6 JTF_VARCHAR2_TABLE_100
291: , p5_a7 JTF_VARCHAR2_TABLE_300
284: , p5_a0 JTF_NUMBER_TABLE
285: , p5_a1 JTF_NUMBER_TABLE
286: , p5_a2 JTF_NUMBER_TABLE
287: , p5_a3 JTF_DATE_TABLE
288: , p5_a4 JTF_DATE_TABLE
289: , p5_a5 JTF_NUMBER_TABLE
290: , p5_a6 JTF_VARCHAR2_TABLE_100
291: , p5_a7 JTF_VARCHAR2_TABLE_300
292: , p5_a8 JTF_VARCHAR2_TABLE_300
304: , p5_a20 JTF_VARCHAR2_TABLE_300
305: , p5_a21 JTF_VARCHAR2_TABLE_300
306: , p5_a22 JTF_VARCHAR2_TABLE_300
307: , p5_a23 JTF_NUMBER_TABLE
308: , p5_a24 JTF_DATE_TABLE
309: , p5_a25 JTF_NUMBER_TABLE
310: , p5_a26 JTF_DATE_TABLE
311: , p5_a27 JTF_NUMBER_TABLE
312: );
306: , p5_a22 JTF_VARCHAR2_TABLE_300
307: , p5_a23 JTF_NUMBER_TABLE
308: , p5_a24 JTF_DATE_TABLE
309: , p5_a25 JTF_NUMBER_TABLE
310: , p5_a26 JTF_DATE_TABLE
311: , p5_a27 JTF_NUMBER_TABLE
312: );
313: procedure update_row(p_api_version NUMBER
314: , p_init_msg_list VARCHAR2
379: , x_msg_data out nocopy VARCHAR2
380: , p5_a0 JTF_NUMBER_TABLE
381: , p5_a1 JTF_NUMBER_TABLE
382: , p5_a2 JTF_NUMBER_TABLE
383: , p5_a3 JTF_DATE_TABLE
384: , p5_a4 JTF_DATE_TABLE
385: , p5_a5 JTF_NUMBER_TABLE
386: , p5_a6 JTF_VARCHAR2_TABLE_100
387: , p5_a7 JTF_VARCHAR2_TABLE_300
380: , p5_a0 JTF_NUMBER_TABLE
381: , p5_a1 JTF_NUMBER_TABLE
382: , p5_a2 JTF_NUMBER_TABLE
383: , p5_a3 JTF_DATE_TABLE
384: , p5_a4 JTF_DATE_TABLE
385: , p5_a5 JTF_NUMBER_TABLE
386: , p5_a6 JTF_VARCHAR2_TABLE_100
387: , p5_a7 JTF_VARCHAR2_TABLE_300
388: , p5_a8 JTF_VARCHAR2_TABLE_300
400: , p5_a20 JTF_VARCHAR2_TABLE_300
401: , p5_a21 JTF_VARCHAR2_TABLE_300
402: , p5_a22 JTF_VARCHAR2_TABLE_300
403: , p5_a23 JTF_NUMBER_TABLE
404: , p5_a24 JTF_DATE_TABLE
405: , p5_a25 JTF_NUMBER_TABLE
406: , p5_a26 JTF_DATE_TABLE
407: , p5_a27 JTF_NUMBER_TABLE
408: , p6_a0 out nocopy JTF_NUMBER_TABLE
402: , p5_a22 JTF_VARCHAR2_TABLE_300
403: , p5_a23 JTF_NUMBER_TABLE
404: , p5_a24 JTF_DATE_TABLE
405: , p5_a25 JTF_NUMBER_TABLE
406: , p5_a26 JTF_DATE_TABLE
407: , p5_a27 JTF_NUMBER_TABLE
408: , p6_a0 out nocopy JTF_NUMBER_TABLE
409: , p6_a1 out nocopy JTF_NUMBER_TABLE
410: , p6_a2 out nocopy JTF_NUMBER_TABLE
407: , p5_a27 JTF_NUMBER_TABLE
408: , p6_a0 out nocopy JTF_NUMBER_TABLE
409: , p6_a1 out nocopy JTF_NUMBER_TABLE
410: , p6_a2 out nocopy JTF_NUMBER_TABLE
411: , p6_a3 out nocopy JTF_DATE_TABLE
412: , p6_a4 out nocopy JTF_DATE_TABLE
413: , p6_a5 out nocopy JTF_NUMBER_TABLE
414: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
415: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
408: , p6_a0 out nocopy JTF_NUMBER_TABLE
409: , p6_a1 out nocopy JTF_NUMBER_TABLE
410: , p6_a2 out nocopy JTF_NUMBER_TABLE
411: , p6_a3 out nocopy JTF_DATE_TABLE
412: , p6_a4 out nocopy JTF_DATE_TABLE
413: , p6_a5 out nocopy JTF_NUMBER_TABLE
414: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
415: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
416: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300
428: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_300
429: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_300
430: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300
431: , p6_a23 out nocopy JTF_NUMBER_TABLE
432: , p6_a24 out nocopy JTF_DATE_TABLE
433: , p6_a25 out nocopy JTF_NUMBER_TABLE
434: , p6_a26 out nocopy JTF_DATE_TABLE
435: , p6_a27 out nocopy JTF_NUMBER_TABLE
436: );
430: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300
431: , p6_a23 out nocopy JTF_NUMBER_TABLE
432: , p6_a24 out nocopy JTF_DATE_TABLE
433: , p6_a25 out nocopy JTF_NUMBER_TABLE
434: , p6_a26 out nocopy JTF_DATE_TABLE
435: , p6_a27 out nocopy JTF_NUMBER_TABLE
436: );
437: procedure delete_row(p_api_version NUMBER
438: , p_init_msg_list VARCHAR2
475: , x_msg_data out nocopy VARCHAR2
476: , p5_a0 JTF_NUMBER_TABLE
477: , p5_a1 JTF_NUMBER_TABLE
478: , p5_a2 JTF_NUMBER_TABLE
479: , p5_a3 JTF_DATE_TABLE
480: , p5_a4 JTF_DATE_TABLE
481: , p5_a5 JTF_NUMBER_TABLE
482: , p5_a6 JTF_VARCHAR2_TABLE_100
483: , p5_a7 JTF_VARCHAR2_TABLE_300
476: , p5_a0 JTF_NUMBER_TABLE
477: , p5_a1 JTF_NUMBER_TABLE
478: , p5_a2 JTF_NUMBER_TABLE
479: , p5_a3 JTF_DATE_TABLE
480: , p5_a4 JTF_DATE_TABLE
481: , p5_a5 JTF_NUMBER_TABLE
482: , p5_a6 JTF_VARCHAR2_TABLE_100
483: , p5_a7 JTF_VARCHAR2_TABLE_300
484: , p5_a8 JTF_VARCHAR2_TABLE_300
496: , p5_a20 JTF_VARCHAR2_TABLE_300
497: , p5_a21 JTF_VARCHAR2_TABLE_300
498: , p5_a22 JTF_VARCHAR2_TABLE_300
499: , p5_a23 JTF_NUMBER_TABLE
500: , p5_a24 JTF_DATE_TABLE
501: , p5_a25 JTF_NUMBER_TABLE
502: , p5_a26 JTF_DATE_TABLE
503: , p5_a27 JTF_NUMBER_TABLE
504: );
498: , p5_a22 JTF_VARCHAR2_TABLE_300
499: , p5_a23 JTF_NUMBER_TABLE
500: , p5_a24 JTF_DATE_TABLE
501: , p5_a25 JTF_NUMBER_TABLE
502: , p5_a26 JTF_DATE_TABLE
503: , p5_a27 JTF_NUMBER_TABLE
504: );
505: procedure validate_row(p_api_version NUMBER
506: , p_init_msg_list VARCHAR2
543: , x_msg_data out nocopy VARCHAR2
544: , p5_a0 JTF_NUMBER_TABLE
545: , p5_a1 JTF_NUMBER_TABLE
546: , p5_a2 JTF_NUMBER_TABLE
547: , p5_a3 JTF_DATE_TABLE
548: , p5_a4 JTF_DATE_TABLE
549: , p5_a5 JTF_NUMBER_TABLE
550: , p5_a6 JTF_VARCHAR2_TABLE_100
551: , p5_a7 JTF_VARCHAR2_TABLE_300
544: , p5_a0 JTF_NUMBER_TABLE
545: , p5_a1 JTF_NUMBER_TABLE
546: , p5_a2 JTF_NUMBER_TABLE
547: , p5_a3 JTF_DATE_TABLE
548: , p5_a4 JTF_DATE_TABLE
549: , p5_a5 JTF_NUMBER_TABLE
550: , p5_a6 JTF_VARCHAR2_TABLE_100
551: , p5_a7 JTF_VARCHAR2_TABLE_300
552: , p5_a8 JTF_VARCHAR2_TABLE_300
564: , p5_a20 JTF_VARCHAR2_TABLE_300
565: , p5_a21 JTF_VARCHAR2_TABLE_300
566: , p5_a22 JTF_VARCHAR2_TABLE_300
567: , p5_a23 JTF_NUMBER_TABLE
568: , p5_a24 JTF_DATE_TABLE
569: , p5_a25 JTF_NUMBER_TABLE
570: , p5_a26 JTF_DATE_TABLE
571: , p5_a27 JTF_NUMBER_TABLE
572: );
566: , p5_a22 JTF_VARCHAR2_TABLE_300
567: , p5_a23 JTF_NUMBER_TABLE
568: , p5_a24 JTF_DATE_TABLE
569: , p5_a25 JTF_NUMBER_TABLE
570: , p5_a26 JTF_DATE_TABLE
571: , p5_a27 JTF_NUMBER_TABLE
572: );
573: end okl_irk_pvt_w;