1: package okl_eto_pvt_w as
2: /* $Header: OKLIETOS.pls 120.0 2005/07/07 10:38:50 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eto_pvt.okl_eto_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
1: package okl_eto_pvt_w as
2: /* $Header: OKLIETOS.pls 120.0 2005/07/07 10:38:50 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eto_pvt.okl_eto_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
1: package okl_eto_pvt_w as
2: /* $Header: OKLIETOS.pls 120.0 2005/07/07 10:38:50 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eto_pvt.okl_eto_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
2: /* $Header: OKLIETOS.pls 120.0 2005/07/07 10:38:50 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eto_pvt.okl_eto_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eto_pvt.okl_eto_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_500
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_500
13: , a10 JTF_VARCHAR2_TABLE_500
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_500
13: , a10 JTF_VARCHAR2_TABLE_500
14: , a11 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p1(t okl_eto_pvt.okl_eto_tbl, a0 out nocopy JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p1(t okl_eto_pvt.okl_eto_tbl, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p1(t okl_eto_pvt.okl_eto_tbl, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p1(t okl_eto_pvt.okl_eto_tbl, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p1(t okl_eto_pvt.okl_eto_tbl, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_NUMBER_TABLE
32: );
33: procedure rosetta_table_copy_out_p1(t okl_eto_pvt.okl_eto_tbl, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_NUMBER_TABLE
40: , a7 out nocopy JTF_NUMBER_TABLE
33: procedure rosetta_table_copy_out_p1(t okl_eto_pvt.okl_eto_tbl, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_NUMBER_TABLE
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_VARCHAR2_TABLE_100
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_NUMBER_TABLE
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_VARCHAR2_TABLE_100
42: , a9 out nocopy JTF_VARCHAR2_TABLE_500
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_NUMBER_TABLE
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_VARCHAR2_TABLE_100
42: , a9 out nocopy JTF_VARCHAR2_TABLE_500
43: , a10 out nocopy JTF_VARCHAR2_TABLE_500
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_NUMBER_TABLE
38: , a5 out nocopy JTF_NUMBER_TABLE
39: , a6 out nocopy JTF_NUMBER_TABLE
40: , a7 out nocopy JTF_NUMBER_TABLE
41: , a8 out nocopy JTF_VARCHAR2_TABLE_100
42: , a9 out nocopy JTF_VARCHAR2_TABLE_500
43: , a10 out nocopy JTF_VARCHAR2_TABLE_500
44: , a11 out nocopy JTF_VARCHAR2_TABLE_500
53: , a20 out nocopy JTF_VARCHAR2_TABLE_500
54: , a21 out nocopy JTF_VARCHAR2_TABLE_500
55: , a22 out nocopy JTF_VARCHAR2_TABLE_500
56: , a23 out nocopy JTF_VARCHAR2_TABLE_500
57: , a24 out nocopy JTF_NUMBER_TABLE
58: , a25 out nocopy JTF_DATE_TABLE
59: , a26 out nocopy JTF_NUMBER_TABLE
60: , a27 out nocopy JTF_DATE_TABLE
61: , a28 out nocopy JTF_NUMBER_TABLE
55: , a22 out nocopy JTF_VARCHAR2_TABLE_500
56: , a23 out nocopy JTF_VARCHAR2_TABLE_500
57: , a24 out nocopy JTF_NUMBER_TABLE
58: , a25 out nocopy JTF_DATE_TABLE
59: , a26 out nocopy JTF_NUMBER_TABLE
60: , a27 out nocopy JTF_DATE_TABLE
61: , a28 out nocopy JTF_NUMBER_TABLE
62: );
63:
57: , a24 out nocopy JTF_NUMBER_TABLE
58: , a25 out nocopy JTF_DATE_TABLE
59: , a26 out nocopy JTF_NUMBER_TABLE
60: , a27 out nocopy JTF_DATE_TABLE
61: , a28 out nocopy JTF_NUMBER_TABLE
62: );
63:
64: procedure insert_row(p_api_version NUMBER
65: , p_init_msg_list VARCHAR2
129: , p_init_msg_list VARCHAR2
130: , x_return_status out nocopy VARCHAR2
131: , x_msg_count out nocopy NUMBER
132: , x_msg_data out nocopy VARCHAR2
133: , p5_a0 JTF_NUMBER_TABLE
134: , p5_a1 JTF_NUMBER_TABLE
135: , p5_a2 JTF_NUMBER_TABLE
136: , p5_a3 JTF_NUMBER_TABLE
137: , p5_a4 JTF_NUMBER_TABLE
130: , x_return_status out nocopy VARCHAR2
131: , x_msg_count out nocopy NUMBER
132: , x_msg_data out nocopy VARCHAR2
133: , p5_a0 JTF_NUMBER_TABLE
134: , p5_a1 JTF_NUMBER_TABLE
135: , p5_a2 JTF_NUMBER_TABLE
136: , p5_a3 JTF_NUMBER_TABLE
137: , p5_a4 JTF_NUMBER_TABLE
138: , p5_a5 JTF_NUMBER_TABLE
131: , x_msg_count out nocopy NUMBER
132: , x_msg_data out nocopy VARCHAR2
133: , p5_a0 JTF_NUMBER_TABLE
134: , p5_a1 JTF_NUMBER_TABLE
135: , p5_a2 JTF_NUMBER_TABLE
136: , p5_a3 JTF_NUMBER_TABLE
137: , p5_a4 JTF_NUMBER_TABLE
138: , p5_a5 JTF_NUMBER_TABLE
139: , p5_a6 JTF_NUMBER_TABLE
132: , x_msg_data out nocopy VARCHAR2
133: , p5_a0 JTF_NUMBER_TABLE
134: , p5_a1 JTF_NUMBER_TABLE
135: , p5_a2 JTF_NUMBER_TABLE
136: , p5_a3 JTF_NUMBER_TABLE
137: , p5_a4 JTF_NUMBER_TABLE
138: , p5_a5 JTF_NUMBER_TABLE
139: , p5_a6 JTF_NUMBER_TABLE
140: , p5_a7 JTF_NUMBER_TABLE
133: , p5_a0 JTF_NUMBER_TABLE
134: , p5_a1 JTF_NUMBER_TABLE
135: , p5_a2 JTF_NUMBER_TABLE
136: , p5_a3 JTF_NUMBER_TABLE
137: , p5_a4 JTF_NUMBER_TABLE
138: , p5_a5 JTF_NUMBER_TABLE
139: , p5_a6 JTF_NUMBER_TABLE
140: , p5_a7 JTF_NUMBER_TABLE
141: , p5_a8 JTF_VARCHAR2_TABLE_100
134: , p5_a1 JTF_NUMBER_TABLE
135: , p5_a2 JTF_NUMBER_TABLE
136: , p5_a3 JTF_NUMBER_TABLE
137: , p5_a4 JTF_NUMBER_TABLE
138: , p5_a5 JTF_NUMBER_TABLE
139: , p5_a6 JTF_NUMBER_TABLE
140: , p5_a7 JTF_NUMBER_TABLE
141: , p5_a8 JTF_VARCHAR2_TABLE_100
142: , p5_a9 JTF_VARCHAR2_TABLE_500
135: , p5_a2 JTF_NUMBER_TABLE
136: , p5_a3 JTF_NUMBER_TABLE
137: , p5_a4 JTF_NUMBER_TABLE
138: , p5_a5 JTF_NUMBER_TABLE
139: , p5_a6 JTF_NUMBER_TABLE
140: , p5_a7 JTF_NUMBER_TABLE
141: , p5_a8 JTF_VARCHAR2_TABLE_100
142: , p5_a9 JTF_VARCHAR2_TABLE_500
143: , p5_a10 JTF_VARCHAR2_TABLE_500
136: , p5_a3 JTF_NUMBER_TABLE
137: , p5_a4 JTF_NUMBER_TABLE
138: , p5_a5 JTF_NUMBER_TABLE
139: , p5_a6 JTF_NUMBER_TABLE
140: , p5_a7 JTF_NUMBER_TABLE
141: , p5_a8 JTF_VARCHAR2_TABLE_100
142: , p5_a9 JTF_VARCHAR2_TABLE_500
143: , p5_a10 JTF_VARCHAR2_TABLE_500
144: , p5_a11 JTF_VARCHAR2_TABLE_500
153: , p5_a20 JTF_VARCHAR2_TABLE_500
154: , p5_a21 JTF_VARCHAR2_TABLE_500
155: , p5_a22 JTF_VARCHAR2_TABLE_500
156: , p5_a23 JTF_VARCHAR2_TABLE_500
157: , p5_a24 JTF_NUMBER_TABLE
158: , p5_a25 JTF_DATE_TABLE
159: , p5_a26 JTF_NUMBER_TABLE
160: , p5_a27 JTF_DATE_TABLE
161: , p5_a28 JTF_NUMBER_TABLE
155: , p5_a22 JTF_VARCHAR2_TABLE_500
156: , p5_a23 JTF_VARCHAR2_TABLE_500
157: , p5_a24 JTF_NUMBER_TABLE
158: , p5_a25 JTF_DATE_TABLE
159: , p5_a26 JTF_NUMBER_TABLE
160: , p5_a27 JTF_DATE_TABLE
161: , p5_a28 JTF_NUMBER_TABLE
162: , p6_a0 out nocopy JTF_NUMBER_TABLE
163: , p6_a1 out nocopy JTF_NUMBER_TABLE
157: , p5_a24 JTF_NUMBER_TABLE
158: , p5_a25 JTF_DATE_TABLE
159: , p5_a26 JTF_NUMBER_TABLE
160: , p5_a27 JTF_DATE_TABLE
161: , p5_a28 JTF_NUMBER_TABLE
162: , p6_a0 out nocopy JTF_NUMBER_TABLE
163: , p6_a1 out nocopy JTF_NUMBER_TABLE
164: , p6_a2 out nocopy JTF_NUMBER_TABLE
165: , p6_a3 out nocopy JTF_NUMBER_TABLE
158: , p5_a25 JTF_DATE_TABLE
159: , p5_a26 JTF_NUMBER_TABLE
160: , p5_a27 JTF_DATE_TABLE
161: , p5_a28 JTF_NUMBER_TABLE
162: , p6_a0 out nocopy JTF_NUMBER_TABLE
163: , p6_a1 out nocopy JTF_NUMBER_TABLE
164: , p6_a2 out nocopy JTF_NUMBER_TABLE
165: , p6_a3 out nocopy JTF_NUMBER_TABLE
166: , p6_a4 out nocopy JTF_NUMBER_TABLE
159: , p5_a26 JTF_NUMBER_TABLE
160: , p5_a27 JTF_DATE_TABLE
161: , p5_a28 JTF_NUMBER_TABLE
162: , p6_a0 out nocopy JTF_NUMBER_TABLE
163: , p6_a1 out nocopy JTF_NUMBER_TABLE
164: , p6_a2 out nocopy JTF_NUMBER_TABLE
165: , p6_a3 out nocopy JTF_NUMBER_TABLE
166: , p6_a4 out nocopy JTF_NUMBER_TABLE
167: , p6_a5 out nocopy JTF_NUMBER_TABLE
160: , p5_a27 JTF_DATE_TABLE
161: , p5_a28 JTF_NUMBER_TABLE
162: , p6_a0 out nocopy JTF_NUMBER_TABLE
163: , p6_a1 out nocopy JTF_NUMBER_TABLE
164: , p6_a2 out nocopy JTF_NUMBER_TABLE
165: , p6_a3 out nocopy JTF_NUMBER_TABLE
166: , p6_a4 out nocopy JTF_NUMBER_TABLE
167: , p6_a5 out nocopy JTF_NUMBER_TABLE
168: , p6_a6 out nocopy JTF_NUMBER_TABLE
161: , p5_a28 JTF_NUMBER_TABLE
162: , p6_a0 out nocopy JTF_NUMBER_TABLE
163: , p6_a1 out nocopy JTF_NUMBER_TABLE
164: , p6_a2 out nocopy JTF_NUMBER_TABLE
165: , p6_a3 out nocopy JTF_NUMBER_TABLE
166: , p6_a4 out nocopy JTF_NUMBER_TABLE
167: , p6_a5 out nocopy JTF_NUMBER_TABLE
168: , p6_a6 out nocopy JTF_NUMBER_TABLE
169: , p6_a7 out nocopy JTF_NUMBER_TABLE
162: , p6_a0 out nocopy JTF_NUMBER_TABLE
163: , p6_a1 out nocopy JTF_NUMBER_TABLE
164: , p6_a2 out nocopy JTF_NUMBER_TABLE
165: , p6_a3 out nocopy JTF_NUMBER_TABLE
166: , p6_a4 out nocopy JTF_NUMBER_TABLE
167: , p6_a5 out nocopy JTF_NUMBER_TABLE
168: , p6_a6 out nocopy JTF_NUMBER_TABLE
169: , p6_a7 out nocopy JTF_NUMBER_TABLE
170: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
163: , p6_a1 out nocopy JTF_NUMBER_TABLE
164: , p6_a2 out nocopy JTF_NUMBER_TABLE
165: , p6_a3 out nocopy JTF_NUMBER_TABLE
166: , p6_a4 out nocopy JTF_NUMBER_TABLE
167: , p6_a5 out nocopy JTF_NUMBER_TABLE
168: , p6_a6 out nocopy JTF_NUMBER_TABLE
169: , p6_a7 out nocopy JTF_NUMBER_TABLE
170: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
171: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
164: , p6_a2 out nocopy JTF_NUMBER_TABLE
165: , p6_a3 out nocopy JTF_NUMBER_TABLE
166: , p6_a4 out nocopy JTF_NUMBER_TABLE
167: , p6_a5 out nocopy JTF_NUMBER_TABLE
168: , p6_a6 out nocopy JTF_NUMBER_TABLE
169: , p6_a7 out nocopy JTF_NUMBER_TABLE
170: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
171: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
172: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
165: , p6_a3 out nocopy JTF_NUMBER_TABLE
166: , p6_a4 out nocopy JTF_NUMBER_TABLE
167: , p6_a5 out nocopy JTF_NUMBER_TABLE
168: , p6_a6 out nocopy JTF_NUMBER_TABLE
169: , p6_a7 out nocopy JTF_NUMBER_TABLE
170: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
171: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
172: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
173: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
182: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
183: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
184: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
185: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
186: , p6_a24 out nocopy JTF_NUMBER_TABLE
187: , p6_a25 out nocopy JTF_DATE_TABLE
188: , p6_a26 out nocopy JTF_NUMBER_TABLE
189: , p6_a27 out nocopy JTF_DATE_TABLE
190: , p6_a28 out nocopy JTF_NUMBER_TABLE
184: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
185: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
186: , p6_a24 out nocopy JTF_NUMBER_TABLE
187: , p6_a25 out nocopy JTF_DATE_TABLE
188: , p6_a26 out nocopy JTF_NUMBER_TABLE
189: , p6_a27 out nocopy JTF_DATE_TABLE
190: , p6_a28 out nocopy JTF_NUMBER_TABLE
191: );
192: procedure update_row(p_api_version NUMBER
186: , p6_a24 out nocopy JTF_NUMBER_TABLE
187: , p6_a25 out nocopy JTF_DATE_TABLE
188: , p6_a26 out nocopy JTF_NUMBER_TABLE
189: , p6_a27 out nocopy JTF_DATE_TABLE
190: , p6_a28 out nocopy JTF_NUMBER_TABLE
191: );
192: procedure update_row(p_api_version NUMBER
193: , p_init_msg_list VARCHAR2
194: , x_return_status out nocopy VARCHAR2
257: , p_init_msg_list VARCHAR2
258: , x_return_status out nocopy VARCHAR2
259: , x_msg_count out nocopy NUMBER
260: , x_msg_data out nocopy VARCHAR2
261: , p5_a0 JTF_NUMBER_TABLE
262: , p5_a1 JTF_NUMBER_TABLE
263: , p5_a2 JTF_NUMBER_TABLE
264: , p5_a3 JTF_NUMBER_TABLE
265: , p5_a4 JTF_NUMBER_TABLE
258: , x_return_status out nocopy VARCHAR2
259: , x_msg_count out nocopy NUMBER
260: , x_msg_data out nocopy VARCHAR2
261: , p5_a0 JTF_NUMBER_TABLE
262: , p5_a1 JTF_NUMBER_TABLE
263: , p5_a2 JTF_NUMBER_TABLE
264: , p5_a3 JTF_NUMBER_TABLE
265: , p5_a4 JTF_NUMBER_TABLE
266: , p5_a5 JTF_NUMBER_TABLE
259: , x_msg_count out nocopy NUMBER
260: , x_msg_data out nocopy VARCHAR2
261: , p5_a0 JTF_NUMBER_TABLE
262: , p5_a1 JTF_NUMBER_TABLE
263: , p5_a2 JTF_NUMBER_TABLE
264: , p5_a3 JTF_NUMBER_TABLE
265: , p5_a4 JTF_NUMBER_TABLE
266: , p5_a5 JTF_NUMBER_TABLE
267: , p5_a6 JTF_NUMBER_TABLE
260: , x_msg_data out nocopy VARCHAR2
261: , p5_a0 JTF_NUMBER_TABLE
262: , p5_a1 JTF_NUMBER_TABLE
263: , p5_a2 JTF_NUMBER_TABLE
264: , p5_a3 JTF_NUMBER_TABLE
265: , p5_a4 JTF_NUMBER_TABLE
266: , p5_a5 JTF_NUMBER_TABLE
267: , p5_a6 JTF_NUMBER_TABLE
268: , p5_a7 JTF_NUMBER_TABLE
261: , p5_a0 JTF_NUMBER_TABLE
262: , p5_a1 JTF_NUMBER_TABLE
263: , p5_a2 JTF_NUMBER_TABLE
264: , p5_a3 JTF_NUMBER_TABLE
265: , p5_a4 JTF_NUMBER_TABLE
266: , p5_a5 JTF_NUMBER_TABLE
267: , p5_a6 JTF_NUMBER_TABLE
268: , p5_a7 JTF_NUMBER_TABLE
269: , p5_a8 JTF_VARCHAR2_TABLE_100
262: , p5_a1 JTF_NUMBER_TABLE
263: , p5_a2 JTF_NUMBER_TABLE
264: , p5_a3 JTF_NUMBER_TABLE
265: , p5_a4 JTF_NUMBER_TABLE
266: , p5_a5 JTF_NUMBER_TABLE
267: , p5_a6 JTF_NUMBER_TABLE
268: , p5_a7 JTF_NUMBER_TABLE
269: , p5_a8 JTF_VARCHAR2_TABLE_100
270: , p5_a9 JTF_VARCHAR2_TABLE_500
263: , p5_a2 JTF_NUMBER_TABLE
264: , p5_a3 JTF_NUMBER_TABLE
265: , p5_a4 JTF_NUMBER_TABLE
266: , p5_a5 JTF_NUMBER_TABLE
267: , p5_a6 JTF_NUMBER_TABLE
268: , p5_a7 JTF_NUMBER_TABLE
269: , p5_a8 JTF_VARCHAR2_TABLE_100
270: , p5_a9 JTF_VARCHAR2_TABLE_500
271: , p5_a10 JTF_VARCHAR2_TABLE_500
264: , p5_a3 JTF_NUMBER_TABLE
265: , p5_a4 JTF_NUMBER_TABLE
266: , p5_a5 JTF_NUMBER_TABLE
267: , p5_a6 JTF_NUMBER_TABLE
268: , p5_a7 JTF_NUMBER_TABLE
269: , p5_a8 JTF_VARCHAR2_TABLE_100
270: , p5_a9 JTF_VARCHAR2_TABLE_500
271: , p5_a10 JTF_VARCHAR2_TABLE_500
272: , p5_a11 JTF_VARCHAR2_TABLE_500
281: , p5_a20 JTF_VARCHAR2_TABLE_500
282: , p5_a21 JTF_VARCHAR2_TABLE_500
283: , p5_a22 JTF_VARCHAR2_TABLE_500
284: , p5_a23 JTF_VARCHAR2_TABLE_500
285: , p5_a24 JTF_NUMBER_TABLE
286: , p5_a25 JTF_DATE_TABLE
287: , p5_a26 JTF_NUMBER_TABLE
288: , p5_a27 JTF_DATE_TABLE
289: , p5_a28 JTF_NUMBER_TABLE
283: , p5_a22 JTF_VARCHAR2_TABLE_500
284: , p5_a23 JTF_VARCHAR2_TABLE_500
285: , p5_a24 JTF_NUMBER_TABLE
286: , p5_a25 JTF_DATE_TABLE
287: , p5_a26 JTF_NUMBER_TABLE
288: , p5_a27 JTF_DATE_TABLE
289: , p5_a28 JTF_NUMBER_TABLE
290: , p6_a0 out nocopy JTF_NUMBER_TABLE
291: , p6_a1 out nocopy JTF_NUMBER_TABLE
285: , p5_a24 JTF_NUMBER_TABLE
286: , p5_a25 JTF_DATE_TABLE
287: , p5_a26 JTF_NUMBER_TABLE
288: , p5_a27 JTF_DATE_TABLE
289: , p5_a28 JTF_NUMBER_TABLE
290: , p6_a0 out nocopy JTF_NUMBER_TABLE
291: , p6_a1 out nocopy JTF_NUMBER_TABLE
292: , p6_a2 out nocopy JTF_NUMBER_TABLE
293: , p6_a3 out nocopy JTF_NUMBER_TABLE
286: , p5_a25 JTF_DATE_TABLE
287: , p5_a26 JTF_NUMBER_TABLE
288: , p5_a27 JTF_DATE_TABLE
289: , p5_a28 JTF_NUMBER_TABLE
290: , p6_a0 out nocopy JTF_NUMBER_TABLE
291: , p6_a1 out nocopy JTF_NUMBER_TABLE
292: , p6_a2 out nocopy JTF_NUMBER_TABLE
293: , p6_a3 out nocopy JTF_NUMBER_TABLE
294: , p6_a4 out nocopy JTF_NUMBER_TABLE
287: , p5_a26 JTF_NUMBER_TABLE
288: , p5_a27 JTF_DATE_TABLE
289: , p5_a28 JTF_NUMBER_TABLE
290: , p6_a0 out nocopy JTF_NUMBER_TABLE
291: , p6_a1 out nocopy JTF_NUMBER_TABLE
292: , p6_a2 out nocopy JTF_NUMBER_TABLE
293: , p6_a3 out nocopy JTF_NUMBER_TABLE
294: , p6_a4 out nocopy JTF_NUMBER_TABLE
295: , p6_a5 out nocopy JTF_NUMBER_TABLE
288: , p5_a27 JTF_DATE_TABLE
289: , p5_a28 JTF_NUMBER_TABLE
290: , p6_a0 out nocopy JTF_NUMBER_TABLE
291: , p6_a1 out nocopy JTF_NUMBER_TABLE
292: , p6_a2 out nocopy JTF_NUMBER_TABLE
293: , p6_a3 out nocopy JTF_NUMBER_TABLE
294: , p6_a4 out nocopy JTF_NUMBER_TABLE
295: , p6_a5 out nocopy JTF_NUMBER_TABLE
296: , p6_a6 out nocopy JTF_NUMBER_TABLE
289: , p5_a28 JTF_NUMBER_TABLE
290: , p6_a0 out nocopy JTF_NUMBER_TABLE
291: , p6_a1 out nocopy JTF_NUMBER_TABLE
292: , p6_a2 out nocopy JTF_NUMBER_TABLE
293: , p6_a3 out nocopy JTF_NUMBER_TABLE
294: , p6_a4 out nocopy JTF_NUMBER_TABLE
295: , p6_a5 out nocopy JTF_NUMBER_TABLE
296: , p6_a6 out nocopy JTF_NUMBER_TABLE
297: , p6_a7 out nocopy JTF_NUMBER_TABLE
290: , p6_a0 out nocopy JTF_NUMBER_TABLE
291: , p6_a1 out nocopy JTF_NUMBER_TABLE
292: , p6_a2 out nocopy JTF_NUMBER_TABLE
293: , p6_a3 out nocopy JTF_NUMBER_TABLE
294: , p6_a4 out nocopy JTF_NUMBER_TABLE
295: , p6_a5 out nocopy JTF_NUMBER_TABLE
296: , p6_a6 out nocopy JTF_NUMBER_TABLE
297: , p6_a7 out nocopy JTF_NUMBER_TABLE
298: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
291: , p6_a1 out nocopy JTF_NUMBER_TABLE
292: , p6_a2 out nocopy JTF_NUMBER_TABLE
293: , p6_a3 out nocopy JTF_NUMBER_TABLE
294: , p6_a4 out nocopy JTF_NUMBER_TABLE
295: , p6_a5 out nocopy JTF_NUMBER_TABLE
296: , p6_a6 out nocopy JTF_NUMBER_TABLE
297: , p6_a7 out nocopy JTF_NUMBER_TABLE
298: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
299: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
292: , p6_a2 out nocopy JTF_NUMBER_TABLE
293: , p6_a3 out nocopy JTF_NUMBER_TABLE
294: , p6_a4 out nocopy JTF_NUMBER_TABLE
295: , p6_a5 out nocopy JTF_NUMBER_TABLE
296: , p6_a6 out nocopy JTF_NUMBER_TABLE
297: , p6_a7 out nocopy JTF_NUMBER_TABLE
298: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
299: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
300: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
293: , p6_a3 out nocopy JTF_NUMBER_TABLE
294: , p6_a4 out nocopy JTF_NUMBER_TABLE
295: , p6_a5 out nocopy JTF_NUMBER_TABLE
296: , p6_a6 out nocopy JTF_NUMBER_TABLE
297: , p6_a7 out nocopy JTF_NUMBER_TABLE
298: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
299: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
300: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
301: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
310: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
311: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
312: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
313: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
314: , p6_a24 out nocopy JTF_NUMBER_TABLE
315: , p6_a25 out nocopy JTF_DATE_TABLE
316: , p6_a26 out nocopy JTF_NUMBER_TABLE
317: , p6_a27 out nocopy JTF_DATE_TABLE
318: , p6_a28 out nocopy JTF_NUMBER_TABLE
312: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
313: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
314: , p6_a24 out nocopy JTF_NUMBER_TABLE
315: , p6_a25 out nocopy JTF_DATE_TABLE
316: , p6_a26 out nocopy JTF_NUMBER_TABLE
317: , p6_a27 out nocopy JTF_DATE_TABLE
318: , p6_a28 out nocopy JTF_NUMBER_TABLE
319: );
320: procedure delete_row(p_api_version NUMBER
314: , p6_a24 out nocopy JTF_NUMBER_TABLE
315: , p6_a25 out nocopy JTF_DATE_TABLE
316: , p6_a26 out nocopy JTF_NUMBER_TABLE
317: , p6_a27 out nocopy JTF_DATE_TABLE
318: , p6_a28 out nocopy JTF_NUMBER_TABLE
319: );
320: procedure delete_row(p_api_version NUMBER
321: , p_init_msg_list VARCHAR2
322: , x_return_status out nocopy VARCHAR2
356: , p_init_msg_list VARCHAR2
357: , x_return_status out nocopy VARCHAR2
358: , x_msg_count out nocopy NUMBER
359: , x_msg_data out nocopy VARCHAR2
360: , p5_a0 JTF_NUMBER_TABLE
361: , p5_a1 JTF_NUMBER_TABLE
362: , p5_a2 JTF_NUMBER_TABLE
363: , p5_a3 JTF_NUMBER_TABLE
364: , p5_a4 JTF_NUMBER_TABLE
357: , x_return_status out nocopy VARCHAR2
358: , x_msg_count out nocopy NUMBER
359: , x_msg_data out nocopy VARCHAR2
360: , p5_a0 JTF_NUMBER_TABLE
361: , p5_a1 JTF_NUMBER_TABLE
362: , p5_a2 JTF_NUMBER_TABLE
363: , p5_a3 JTF_NUMBER_TABLE
364: , p5_a4 JTF_NUMBER_TABLE
365: , p5_a5 JTF_NUMBER_TABLE
358: , x_msg_count out nocopy NUMBER
359: , x_msg_data out nocopy VARCHAR2
360: , p5_a0 JTF_NUMBER_TABLE
361: , p5_a1 JTF_NUMBER_TABLE
362: , p5_a2 JTF_NUMBER_TABLE
363: , p5_a3 JTF_NUMBER_TABLE
364: , p5_a4 JTF_NUMBER_TABLE
365: , p5_a5 JTF_NUMBER_TABLE
366: , p5_a6 JTF_NUMBER_TABLE
359: , x_msg_data out nocopy VARCHAR2
360: , p5_a0 JTF_NUMBER_TABLE
361: , p5_a1 JTF_NUMBER_TABLE
362: , p5_a2 JTF_NUMBER_TABLE
363: , p5_a3 JTF_NUMBER_TABLE
364: , p5_a4 JTF_NUMBER_TABLE
365: , p5_a5 JTF_NUMBER_TABLE
366: , p5_a6 JTF_NUMBER_TABLE
367: , p5_a7 JTF_NUMBER_TABLE
360: , p5_a0 JTF_NUMBER_TABLE
361: , p5_a1 JTF_NUMBER_TABLE
362: , p5_a2 JTF_NUMBER_TABLE
363: , p5_a3 JTF_NUMBER_TABLE
364: , p5_a4 JTF_NUMBER_TABLE
365: , p5_a5 JTF_NUMBER_TABLE
366: , p5_a6 JTF_NUMBER_TABLE
367: , p5_a7 JTF_NUMBER_TABLE
368: , p5_a8 JTF_VARCHAR2_TABLE_100
361: , p5_a1 JTF_NUMBER_TABLE
362: , p5_a2 JTF_NUMBER_TABLE
363: , p5_a3 JTF_NUMBER_TABLE
364: , p5_a4 JTF_NUMBER_TABLE
365: , p5_a5 JTF_NUMBER_TABLE
366: , p5_a6 JTF_NUMBER_TABLE
367: , p5_a7 JTF_NUMBER_TABLE
368: , p5_a8 JTF_VARCHAR2_TABLE_100
369: , p5_a9 JTF_VARCHAR2_TABLE_500
362: , p5_a2 JTF_NUMBER_TABLE
363: , p5_a3 JTF_NUMBER_TABLE
364: , p5_a4 JTF_NUMBER_TABLE
365: , p5_a5 JTF_NUMBER_TABLE
366: , p5_a6 JTF_NUMBER_TABLE
367: , p5_a7 JTF_NUMBER_TABLE
368: , p5_a8 JTF_VARCHAR2_TABLE_100
369: , p5_a9 JTF_VARCHAR2_TABLE_500
370: , p5_a10 JTF_VARCHAR2_TABLE_500
363: , p5_a3 JTF_NUMBER_TABLE
364: , p5_a4 JTF_NUMBER_TABLE
365: , p5_a5 JTF_NUMBER_TABLE
366: , p5_a6 JTF_NUMBER_TABLE
367: , p5_a7 JTF_NUMBER_TABLE
368: , p5_a8 JTF_VARCHAR2_TABLE_100
369: , p5_a9 JTF_VARCHAR2_TABLE_500
370: , p5_a10 JTF_VARCHAR2_TABLE_500
371: , p5_a11 JTF_VARCHAR2_TABLE_500
380: , p5_a20 JTF_VARCHAR2_TABLE_500
381: , p5_a21 JTF_VARCHAR2_TABLE_500
382: , p5_a22 JTF_VARCHAR2_TABLE_500
383: , p5_a23 JTF_VARCHAR2_TABLE_500
384: , p5_a24 JTF_NUMBER_TABLE
385: , p5_a25 JTF_DATE_TABLE
386: , p5_a26 JTF_NUMBER_TABLE
387: , p5_a27 JTF_DATE_TABLE
388: , p5_a28 JTF_NUMBER_TABLE
382: , p5_a22 JTF_VARCHAR2_TABLE_500
383: , p5_a23 JTF_VARCHAR2_TABLE_500
384: , p5_a24 JTF_NUMBER_TABLE
385: , p5_a25 JTF_DATE_TABLE
386: , p5_a26 JTF_NUMBER_TABLE
387: , p5_a27 JTF_DATE_TABLE
388: , p5_a28 JTF_NUMBER_TABLE
389: );
390: end okl_eto_pvt_w;
384: , p5_a24 JTF_NUMBER_TABLE
385: , p5_a25 JTF_DATE_TABLE
386: , p5_a26 JTF_NUMBER_TABLE
387: , p5_a27 JTF_DATE_TABLE
388: , p5_a28 JTF_NUMBER_TABLE
389: );
390: end okl_eto_pvt_w;