11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_NUMBER_TABLE
23: );
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_NUMBER_TABLE
23: );
24: procedure rosetta_table_copy_out_p1(t okl_irh_pvt.okl_irhv_tbl, a0 out nocopy JTF_NUMBER_TABLE
25: , a1 out nocopy JTF_NUMBER_TABLE
32: , a8 out nocopy JTF_VARCHAR2_TABLE_100
33: , a9 out nocopy JTF_VARCHAR2_TABLE_100
34: , a10 out nocopy JTF_VARCHAR2_TABLE_100
35: , a11 out nocopy JTF_VARCHAR2_TABLE_100
36: , a12 out nocopy JTF_DATE_TABLE
37: , a13 out nocopy JTF_DATE_TABLE
38: , a14 out nocopy JTF_NUMBER_TABLE
39: , a15 out nocopy JTF_NUMBER_TABLE
40: , a16 out nocopy JTF_DATE_TABLE
33: , a9 out nocopy JTF_VARCHAR2_TABLE_100
34: , a10 out nocopy JTF_VARCHAR2_TABLE_100
35: , a11 out nocopy JTF_VARCHAR2_TABLE_100
36: , a12 out nocopy JTF_DATE_TABLE
37: , a13 out nocopy JTF_DATE_TABLE
38: , a14 out nocopy JTF_NUMBER_TABLE
39: , a15 out nocopy JTF_NUMBER_TABLE
40: , a16 out nocopy JTF_DATE_TABLE
41: , a17 out nocopy JTF_NUMBER_TABLE
36: , a12 out nocopy JTF_DATE_TABLE
37: , a13 out nocopy JTF_DATE_TABLE
38: , a14 out nocopy JTF_NUMBER_TABLE
39: , a15 out nocopy JTF_NUMBER_TABLE
40: , a16 out nocopy JTF_DATE_TABLE
41: , a17 out nocopy JTF_NUMBER_TABLE
42: , a18 out nocopy JTF_DATE_TABLE
43: , a19 out nocopy JTF_NUMBER_TABLE
44: );
38: , a14 out nocopy JTF_NUMBER_TABLE
39: , a15 out nocopy JTF_NUMBER_TABLE
40: , a16 out nocopy JTF_DATE_TABLE
41: , a17 out nocopy JTF_NUMBER_TABLE
42: , a18 out nocopy JTF_DATE_TABLE
43: , a19 out nocopy JTF_NUMBER_TABLE
44: );
45:
46: procedure rosetta_table_copy_in_p3(t out nocopy okl_irh_pvt.okl_irh_tbl, a0 JTF_NUMBER_TABLE
54: , a8 JTF_VARCHAR2_TABLE_100
55: , a9 JTF_VARCHAR2_TABLE_100
56: , a10 JTF_VARCHAR2_TABLE_100
57: , a11 JTF_VARCHAR2_TABLE_100
58: , a12 JTF_DATE_TABLE
59: , a13 JTF_DATE_TABLE
60: , a14 JTF_NUMBER_TABLE
61: , a15 JTF_NUMBER_TABLE
62: , a16 JTF_DATE_TABLE
55: , a9 JTF_VARCHAR2_TABLE_100
56: , a10 JTF_VARCHAR2_TABLE_100
57: , a11 JTF_VARCHAR2_TABLE_100
58: , a12 JTF_DATE_TABLE
59: , a13 JTF_DATE_TABLE
60: , a14 JTF_NUMBER_TABLE
61: , a15 JTF_NUMBER_TABLE
62: , a16 JTF_DATE_TABLE
63: , a17 JTF_NUMBER_TABLE
58: , a12 JTF_DATE_TABLE
59: , a13 JTF_DATE_TABLE
60: , a14 JTF_NUMBER_TABLE
61: , a15 JTF_NUMBER_TABLE
62: , a16 JTF_DATE_TABLE
63: , a17 JTF_NUMBER_TABLE
64: , a18 JTF_DATE_TABLE
65: , a19 JTF_NUMBER_TABLE
66: );
60: , a14 JTF_NUMBER_TABLE
61: , a15 JTF_NUMBER_TABLE
62: , a16 JTF_DATE_TABLE
63: , a17 JTF_NUMBER_TABLE
64: , a18 JTF_DATE_TABLE
65: , a19 JTF_NUMBER_TABLE
66: );
67: procedure rosetta_table_copy_out_p3(t okl_irh_pvt.okl_irh_tbl, a0 out nocopy JTF_NUMBER_TABLE
68: , a1 out nocopy JTF_NUMBER_TABLE
75: , a8 out nocopy JTF_VARCHAR2_TABLE_100
76: , a9 out nocopy JTF_VARCHAR2_TABLE_100
77: , a10 out nocopy JTF_VARCHAR2_TABLE_100
78: , a11 out nocopy JTF_VARCHAR2_TABLE_100
79: , a12 out nocopy JTF_DATE_TABLE
80: , a13 out nocopy JTF_DATE_TABLE
81: , a14 out nocopy JTF_NUMBER_TABLE
82: , a15 out nocopy JTF_NUMBER_TABLE
83: , a16 out nocopy JTF_DATE_TABLE
76: , a9 out nocopy JTF_VARCHAR2_TABLE_100
77: , a10 out nocopy JTF_VARCHAR2_TABLE_100
78: , a11 out nocopy JTF_VARCHAR2_TABLE_100
79: , a12 out nocopy JTF_DATE_TABLE
80: , a13 out nocopy JTF_DATE_TABLE
81: , a14 out nocopy JTF_NUMBER_TABLE
82: , a15 out nocopy JTF_NUMBER_TABLE
83: , a16 out nocopy JTF_DATE_TABLE
84: , a17 out nocopy JTF_NUMBER_TABLE
79: , a12 out nocopy JTF_DATE_TABLE
80: , a13 out nocopy JTF_DATE_TABLE
81: , a14 out nocopy JTF_NUMBER_TABLE
82: , a15 out nocopy JTF_NUMBER_TABLE
83: , a16 out nocopy JTF_DATE_TABLE
84: , a17 out nocopy JTF_NUMBER_TABLE
85: , a18 out nocopy JTF_DATE_TABLE
86: , a19 out nocopy JTF_NUMBER_TABLE
87: );
81: , a14 out nocopy JTF_NUMBER_TABLE
82: , a15 out nocopy JTF_NUMBER_TABLE
83: , a16 out nocopy JTF_DATE_TABLE
84: , a17 out nocopy JTF_NUMBER_TABLE
85: , a18 out nocopy JTF_DATE_TABLE
86: , a19 out nocopy JTF_NUMBER_TABLE
87: );
88:
89: procedure insert_row(p_api_version NUMBER
148: , p5_a8 JTF_VARCHAR2_TABLE_100
149: , p5_a9 JTF_VARCHAR2_TABLE_100
150: , p5_a10 JTF_VARCHAR2_TABLE_100
151: , p5_a11 JTF_VARCHAR2_TABLE_100
152: , p5_a12 JTF_DATE_TABLE
153: , p5_a13 JTF_DATE_TABLE
154: , p5_a14 JTF_NUMBER_TABLE
155: , p5_a15 JTF_NUMBER_TABLE
156: , p5_a16 JTF_DATE_TABLE
149: , p5_a9 JTF_VARCHAR2_TABLE_100
150: , p5_a10 JTF_VARCHAR2_TABLE_100
151: , p5_a11 JTF_VARCHAR2_TABLE_100
152: , p5_a12 JTF_DATE_TABLE
153: , p5_a13 JTF_DATE_TABLE
154: , p5_a14 JTF_NUMBER_TABLE
155: , p5_a15 JTF_NUMBER_TABLE
156: , p5_a16 JTF_DATE_TABLE
157: , p5_a17 JTF_NUMBER_TABLE
152: , p5_a12 JTF_DATE_TABLE
153: , p5_a13 JTF_DATE_TABLE
154: , p5_a14 JTF_NUMBER_TABLE
155: , p5_a15 JTF_NUMBER_TABLE
156: , p5_a16 JTF_DATE_TABLE
157: , p5_a17 JTF_NUMBER_TABLE
158: , p5_a18 JTF_DATE_TABLE
159: , p5_a19 JTF_NUMBER_TABLE
160: , p6_a0 out nocopy JTF_NUMBER_TABLE
154: , p5_a14 JTF_NUMBER_TABLE
155: , p5_a15 JTF_NUMBER_TABLE
156: , p5_a16 JTF_DATE_TABLE
157: , p5_a17 JTF_NUMBER_TABLE
158: , p5_a18 JTF_DATE_TABLE
159: , p5_a19 JTF_NUMBER_TABLE
160: , p6_a0 out nocopy JTF_NUMBER_TABLE
161: , p6_a1 out nocopy JTF_NUMBER_TABLE
162: , p6_a2 out nocopy JTF_NUMBER_TABLE
168: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
169: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
170: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
171: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
172: , p6_a12 out nocopy JTF_DATE_TABLE
173: , p6_a13 out nocopy JTF_DATE_TABLE
174: , p6_a14 out nocopy JTF_NUMBER_TABLE
175: , p6_a15 out nocopy JTF_NUMBER_TABLE
176: , p6_a16 out nocopy JTF_DATE_TABLE
169: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
170: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
171: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
172: , p6_a12 out nocopy JTF_DATE_TABLE
173: , p6_a13 out nocopy JTF_DATE_TABLE
174: , p6_a14 out nocopy JTF_NUMBER_TABLE
175: , p6_a15 out nocopy JTF_NUMBER_TABLE
176: , p6_a16 out nocopy JTF_DATE_TABLE
177: , p6_a17 out nocopy JTF_NUMBER_TABLE
172: , p6_a12 out nocopy JTF_DATE_TABLE
173: , p6_a13 out nocopy JTF_DATE_TABLE
174: , p6_a14 out nocopy JTF_NUMBER_TABLE
175: , p6_a15 out nocopy JTF_NUMBER_TABLE
176: , p6_a16 out nocopy JTF_DATE_TABLE
177: , p6_a17 out nocopy JTF_NUMBER_TABLE
178: , p6_a18 out nocopy JTF_DATE_TABLE
179: , p6_a19 out nocopy JTF_NUMBER_TABLE
180: );
174: , p6_a14 out nocopy JTF_NUMBER_TABLE
175: , p6_a15 out nocopy JTF_NUMBER_TABLE
176: , p6_a16 out nocopy JTF_DATE_TABLE
177: , p6_a17 out nocopy JTF_NUMBER_TABLE
178: , p6_a18 out nocopy JTF_DATE_TABLE
179: , p6_a19 out nocopy JTF_NUMBER_TABLE
180: );
181: procedure update_row(p_api_version NUMBER
182: , p_init_msg_list VARCHAR2
240: , p5_a8 JTF_VARCHAR2_TABLE_100
241: , p5_a9 JTF_VARCHAR2_TABLE_100
242: , p5_a10 JTF_VARCHAR2_TABLE_100
243: , p5_a11 JTF_VARCHAR2_TABLE_100
244: , p5_a12 JTF_DATE_TABLE
245: , p5_a13 JTF_DATE_TABLE
246: , p5_a14 JTF_NUMBER_TABLE
247: , p5_a15 JTF_NUMBER_TABLE
248: , p5_a16 JTF_DATE_TABLE
241: , p5_a9 JTF_VARCHAR2_TABLE_100
242: , p5_a10 JTF_VARCHAR2_TABLE_100
243: , p5_a11 JTF_VARCHAR2_TABLE_100
244: , p5_a12 JTF_DATE_TABLE
245: , p5_a13 JTF_DATE_TABLE
246: , p5_a14 JTF_NUMBER_TABLE
247: , p5_a15 JTF_NUMBER_TABLE
248: , p5_a16 JTF_DATE_TABLE
249: , p5_a17 JTF_NUMBER_TABLE
244: , p5_a12 JTF_DATE_TABLE
245: , p5_a13 JTF_DATE_TABLE
246: , p5_a14 JTF_NUMBER_TABLE
247: , p5_a15 JTF_NUMBER_TABLE
248: , p5_a16 JTF_DATE_TABLE
249: , p5_a17 JTF_NUMBER_TABLE
250: , p5_a18 JTF_DATE_TABLE
251: , p5_a19 JTF_NUMBER_TABLE
252: , p6_a0 out nocopy JTF_NUMBER_TABLE
246: , p5_a14 JTF_NUMBER_TABLE
247: , p5_a15 JTF_NUMBER_TABLE
248: , p5_a16 JTF_DATE_TABLE
249: , p5_a17 JTF_NUMBER_TABLE
250: , p5_a18 JTF_DATE_TABLE
251: , p5_a19 JTF_NUMBER_TABLE
252: , p6_a0 out nocopy JTF_NUMBER_TABLE
253: , p6_a1 out nocopy JTF_NUMBER_TABLE
254: , p6_a2 out nocopy JTF_NUMBER_TABLE
260: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
261: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
262: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
263: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
264: , p6_a12 out nocopy JTF_DATE_TABLE
265: , p6_a13 out nocopy JTF_DATE_TABLE
266: , p6_a14 out nocopy JTF_NUMBER_TABLE
267: , p6_a15 out nocopy JTF_NUMBER_TABLE
268: , p6_a16 out nocopy JTF_DATE_TABLE
261: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
262: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
263: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
264: , p6_a12 out nocopy JTF_DATE_TABLE
265: , p6_a13 out nocopy JTF_DATE_TABLE
266: , p6_a14 out nocopy JTF_NUMBER_TABLE
267: , p6_a15 out nocopy JTF_NUMBER_TABLE
268: , p6_a16 out nocopy JTF_DATE_TABLE
269: , p6_a17 out nocopy JTF_NUMBER_TABLE
264: , p6_a12 out nocopy JTF_DATE_TABLE
265: , p6_a13 out nocopy JTF_DATE_TABLE
266: , p6_a14 out nocopy JTF_NUMBER_TABLE
267: , p6_a15 out nocopy JTF_NUMBER_TABLE
268: , p6_a16 out nocopy JTF_DATE_TABLE
269: , p6_a17 out nocopy JTF_NUMBER_TABLE
270: , p6_a18 out nocopy JTF_DATE_TABLE
271: , p6_a19 out nocopy JTF_NUMBER_TABLE
272: );
266: , p6_a14 out nocopy JTF_NUMBER_TABLE
267: , p6_a15 out nocopy JTF_NUMBER_TABLE
268: , p6_a16 out nocopy JTF_DATE_TABLE
269: , p6_a17 out nocopy JTF_NUMBER_TABLE
270: , p6_a18 out nocopy JTF_DATE_TABLE
271: , p6_a19 out nocopy JTF_NUMBER_TABLE
272: );
273: procedure delete_row(p_api_version NUMBER
274: , p_init_msg_list VARCHAR2
312: , p5_a8 JTF_VARCHAR2_TABLE_100
313: , p5_a9 JTF_VARCHAR2_TABLE_100
314: , p5_a10 JTF_VARCHAR2_TABLE_100
315: , p5_a11 JTF_VARCHAR2_TABLE_100
316: , p5_a12 JTF_DATE_TABLE
317: , p5_a13 JTF_DATE_TABLE
318: , p5_a14 JTF_NUMBER_TABLE
319: , p5_a15 JTF_NUMBER_TABLE
320: , p5_a16 JTF_DATE_TABLE
313: , p5_a9 JTF_VARCHAR2_TABLE_100
314: , p5_a10 JTF_VARCHAR2_TABLE_100
315: , p5_a11 JTF_VARCHAR2_TABLE_100
316: , p5_a12 JTF_DATE_TABLE
317: , p5_a13 JTF_DATE_TABLE
318: , p5_a14 JTF_NUMBER_TABLE
319: , p5_a15 JTF_NUMBER_TABLE
320: , p5_a16 JTF_DATE_TABLE
321: , p5_a17 JTF_NUMBER_TABLE
316: , p5_a12 JTF_DATE_TABLE
317: , p5_a13 JTF_DATE_TABLE
318: , p5_a14 JTF_NUMBER_TABLE
319: , p5_a15 JTF_NUMBER_TABLE
320: , p5_a16 JTF_DATE_TABLE
321: , p5_a17 JTF_NUMBER_TABLE
322: , p5_a18 JTF_DATE_TABLE
323: , p5_a19 JTF_NUMBER_TABLE
324: );
318: , p5_a14 JTF_NUMBER_TABLE
319: , p5_a15 JTF_NUMBER_TABLE
320: , p5_a16 JTF_DATE_TABLE
321: , p5_a17 JTF_NUMBER_TABLE
322: , p5_a18 JTF_DATE_TABLE
323: , p5_a19 JTF_NUMBER_TABLE
324: );
325: end okl_irh_pvt_w;