1: package okl_eth_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIETHS.pls 120.0 2005/07/07 10:38:30 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eth_pvt.okl_ethv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_NUMBER_TABLE
1: package okl_eth_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIETHS.pls 120.0 2005/07/07 10:38:30 viselvar noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eth_pvt.okl_ethv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_eth_pvt.okl_ethv_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_DATE_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_500
29: , a26 JTF_VARCHAR2_TABLE_500
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_VARCHAR2_TABLE_500
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_500
31: , a28 JTF_VARCHAR2_TABLE_500
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p1(t okl_eth_pvt.okl_ethv_tbl, a0 out nocopy JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_DATE_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p1(t okl_eth_pvt.okl_ethv_tbl, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_VARCHAR2_TABLE_300
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p1(t okl_eth_pvt.okl_ethv_tbl, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_VARCHAR2_TABLE_300
41: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
42: , a4 out nocopy JTF_NUMBER_TABLE
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p1(t okl_eth_pvt.okl_ethv_tbl, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_VARCHAR2_TABLE_300
41: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
42: , a4 out nocopy JTF_NUMBER_TABLE
43: , a5 out nocopy JTF_VARCHAR2_TABLE_100
38: procedure rosetta_table_copy_out_p1(t okl_eth_pvt.okl_ethv_tbl, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_VARCHAR2_TABLE_300
41: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
42: , a4 out nocopy JTF_NUMBER_TABLE
43: , a5 out nocopy JTF_VARCHAR2_TABLE_100
44: , a6 out nocopy JTF_VARCHAR2_TABLE_100
45: , a7 out nocopy JTF_NUMBER_TABLE
46: , a8 out nocopy JTF_VARCHAR2_TABLE_100
41: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
42: , a4 out nocopy JTF_NUMBER_TABLE
43: , a5 out nocopy JTF_VARCHAR2_TABLE_100
44: , a6 out nocopy JTF_VARCHAR2_TABLE_100
45: , a7 out nocopy JTF_NUMBER_TABLE
46: , a8 out nocopy JTF_VARCHAR2_TABLE_100
47: , a9 out nocopy JTF_NUMBER_TABLE
48: , a10 out nocopy JTF_VARCHAR2_TABLE_100
49: , a11 out nocopy JTF_DATE_TABLE
43: , a5 out nocopy JTF_VARCHAR2_TABLE_100
44: , a6 out nocopy JTF_VARCHAR2_TABLE_100
45: , a7 out nocopy JTF_NUMBER_TABLE
46: , a8 out nocopy JTF_VARCHAR2_TABLE_100
47: , a9 out nocopy JTF_NUMBER_TABLE
48: , a10 out nocopy JTF_VARCHAR2_TABLE_100
49: , a11 out nocopy JTF_DATE_TABLE
50: , a12 out nocopy JTF_DATE_TABLE
51: , a13 out nocopy JTF_VARCHAR2_TABLE_100
63: , a25 out nocopy JTF_VARCHAR2_TABLE_500
64: , a26 out nocopy JTF_VARCHAR2_TABLE_500
65: , a27 out nocopy JTF_VARCHAR2_TABLE_500
66: , a28 out nocopy JTF_VARCHAR2_TABLE_500
67: , a29 out nocopy JTF_NUMBER_TABLE
68: , a30 out nocopy JTF_DATE_TABLE
69: , a31 out nocopy JTF_NUMBER_TABLE
70: , a32 out nocopy JTF_DATE_TABLE
71: , a33 out nocopy JTF_NUMBER_TABLE
65: , a27 out nocopy JTF_VARCHAR2_TABLE_500
66: , a28 out nocopy JTF_VARCHAR2_TABLE_500
67: , a29 out nocopy JTF_NUMBER_TABLE
68: , a30 out nocopy JTF_DATE_TABLE
69: , a31 out nocopy JTF_NUMBER_TABLE
70: , a32 out nocopy JTF_DATE_TABLE
71: , a33 out nocopy JTF_NUMBER_TABLE
72: );
73:
67: , a29 out nocopy JTF_NUMBER_TABLE
68: , a30 out nocopy JTF_DATE_TABLE
69: , a31 out nocopy JTF_NUMBER_TABLE
70: , a32 out nocopy JTF_DATE_TABLE
71: , a33 out nocopy JTF_NUMBER_TABLE
72: );
73:
74: procedure rosetta_table_copy_in_p3(t out nocopy okl_eth_pvt.okl_ethb_tbl, a0 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE
70: , a32 out nocopy JTF_DATE_TABLE
71: , a33 out nocopy JTF_NUMBER_TABLE
72: );
73:
74: procedure rosetta_table_copy_in_p3(t out nocopy okl_eth_pvt.okl_ethb_tbl, a0 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_VARCHAR2_TABLE_300
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_VARCHAR2_TABLE_100
71: , a33 out nocopy JTF_NUMBER_TABLE
72: );
73:
74: procedure rosetta_table_copy_in_p3(t out nocopy okl_eth_pvt.okl_ethb_tbl, a0 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_VARCHAR2_TABLE_300
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_VARCHAR2_TABLE_100
79: , a5 JTF_VARCHAR2_TABLE_100
73:
74: procedure rosetta_table_copy_in_p3(t out nocopy okl_eth_pvt.okl_ethb_tbl, a0 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_VARCHAR2_TABLE_300
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_VARCHAR2_TABLE_100
79: , a5 JTF_VARCHAR2_TABLE_100
80: , a6 JTF_NUMBER_TABLE
81: , a7 JTF_VARCHAR2_TABLE_100
76: , a2 JTF_VARCHAR2_TABLE_300
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_VARCHAR2_TABLE_100
79: , a5 JTF_VARCHAR2_TABLE_100
80: , a6 JTF_NUMBER_TABLE
81: , a7 JTF_VARCHAR2_TABLE_100
82: , a8 JTF_NUMBER_TABLE
83: , a9 JTF_VARCHAR2_TABLE_100
84: , a10 JTF_DATE_TABLE
78: , a4 JTF_VARCHAR2_TABLE_100
79: , a5 JTF_VARCHAR2_TABLE_100
80: , a6 JTF_NUMBER_TABLE
81: , a7 JTF_VARCHAR2_TABLE_100
82: , a8 JTF_NUMBER_TABLE
83: , a9 JTF_VARCHAR2_TABLE_100
84: , a10 JTF_DATE_TABLE
85: , a11 JTF_DATE_TABLE
86: , a12 JTF_VARCHAR2_TABLE_100
98: , a24 JTF_VARCHAR2_TABLE_500
99: , a25 JTF_VARCHAR2_TABLE_500
100: , a26 JTF_VARCHAR2_TABLE_500
101: , a27 JTF_VARCHAR2_TABLE_500
102: , a28 JTF_NUMBER_TABLE
103: , a29 JTF_DATE_TABLE
104: , a30 JTF_NUMBER_TABLE
105: , a31 JTF_DATE_TABLE
106: , a32 JTF_NUMBER_TABLE
100: , a26 JTF_VARCHAR2_TABLE_500
101: , a27 JTF_VARCHAR2_TABLE_500
102: , a28 JTF_NUMBER_TABLE
103: , a29 JTF_DATE_TABLE
104: , a30 JTF_NUMBER_TABLE
105: , a31 JTF_DATE_TABLE
106: , a32 JTF_NUMBER_TABLE
107: );
108: procedure rosetta_table_copy_out_p3(t okl_eth_pvt.okl_ethb_tbl, a0 out nocopy JTF_NUMBER_TABLE
102: , a28 JTF_NUMBER_TABLE
103: , a29 JTF_DATE_TABLE
104: , a30 JTF_NUMBER_TABLE
105: , a31 JTF_DATE_TABLE
106: , a32 JTF_NUMBER_TABLE
107: );
108: procedure rosetta_table_copy_out_p3(t okl_eth_pvt.okl_ethb_tbl, a0 out nocopy JTF_NUMBER_TABLE
109: , a1 out nocopy JTF_NUMBER_TABLE
110: , a2 out nocopy JTF_VARCHAR2_TABLE_300
104: , a30 JTF_NUMBER_TABLE
105: , a31 JTF_DATE_TABLE
106: , a32 JTF_NUMBER_TABLE
107: );
108: procedure rosetta_table_copy_out_p3(t okl_eth_pvt.okl_ethb_tbl, a0 out nocopy JTF_NUMBER_TABLE
109: , a1 out nocopy JTF_NUMBER_TABLE
110: , a2 out nocopy JTF_VARCHAR2_TABLE_300
111: , a3 out nocopy JTF_NUMBER_TABLE
112: , a4 out nocopy JTF_VARCHAR2_TABLE_100
105: , a31 JTF_DATE_TABLE
106: , a32 JTF_NUMBER_TABLE
107: );
108: procedure rosetta_table_copy_out_p3(t okl_eth_pvt.okl_ethb_tbl, a0 out nocopy JTF_NUMBER_TABLE
109: , a1 out nocopy JTF_NUMBER_TABLE
110: , a2 out nocopy JTF_VARCHAR2_TABLE_300
111: , a3 out nocopy JTF_NUMBER_TABLE
112: , a4 out nocopy JTF_VARCHAR2_TABLE_100
113: , a5 out nocopy JTF_VARCHAR2_TABLE_100
107: );
108: procedure rosetta_table_copy_out_p3(t okl_eth_pvt.okl_ethb_tbl, a0 out nocopy JTF_NUMBER_TABLE
109: , a1 out nocopy JTF_NUMBER_TABLE
110: , a2 out nocopy JTF_VARCHAR2_TABLE_300
111: , a3 out nocopy JTF_NUMBER_TABLE
112: , a4 out nocopy JTF_VARCHAR2_TABLE_100
113: , a5 out nocopy JTF_VARCHAR2_TABLE_100
114: , a6 out nocopy JTF_NUMBER_TABLE
115: , a7 out nocopy JTF_VARCHAR2_TABLE_100
110: , a2 out nocopy JTF_VARCHAR2_TABLE_300
111: , a3 out nocopy JTF_NUMBER_TABLE
112: , a4 out nocopy JTF_VARCHAR2_TABLE_100
113: , a5 out nocopy JTF_VARCHAR2_TABLE_100
114: , a6 out nocopy JTF_NUMBER_TABLE
115: , a7 out nocopy JTF_VARCHAR2_TABLE_100
116: , a8 out nocopy JTF_NUMBER_TABLE
117: , a9 out nocopy JTF_VARCHAR2_TABLE_100
118: , a10 out nocopy JTF_DATE_TABLE
112: , a4 out nocopy JTF_VARCHAR2_TABLE_100
113: , a5 out nocopy JTF_VARCHAR2_TABLE_100
114: , a6 out nocopy JTF_NUMBER_TABLE
115: , a7 out nocopy JTF_VARCHAR2_TABLE_100
116: , a8 out nocopy JTF_NUMBER_TABLE
117: , a9 out nocopy JTF_VARCHAR2_TABLE_100
118: , a10 out nocopy JTF_DATE_TABLE
119: , a11 out nocopy JTF_DATE_TABLE
120: , a12 out nocopy JTF_VARCHAR2_TABLE_100
132: , a24 out nocopy JTF_VARCHAR2_TABLE_500
133: , a25 out nocopy JTF_VARCHAR2_TABLE_500
134: , a26 out nocopy JTF_VARCHAR2_TABLE_500
135: , a27 out nocopy JTF_VARCHAR2_TABLE_500
136: , a28 out nocopy JTF_NUMBER_TABLE
137: , a29 out nocopy JTF_DATE_TABLE
138: , a30 out nocopy JTF_NUMBER_TABLE
139: , a31 out nocopy JTF_DATE_TABLE
140: , a32 out nocopy JTF_NUMBER_TABLE
134: , a26 out nocopy JTF_VARCHAR2_TABLE_500
135: , a27 out nocopy JTF_VARCHAR2_TABLE_500
136: , a28 out nocopy JTF_NUMBER_TABLE
137: , a29 out nocopy JTF_DATE_TABLE
138: , a30 out nocopy JTF_NUMBER_TABLE
139: , a31 out nocopy JTF_DATE_TABLE
140: , a32 out nocopy JTF_NUMBER_TABLE
141: );
142:
136: , a28 out nocopy JTF_NUMBER_TABLE
137: , a29 out nocopy JTF_DATE_TABLE
138: , a30 out nocopy JTF_NUMBER_TABLE
139: , a31 out nocopy JTF_DATE_TABLE
140: , a32 out nocopy JTF_NUMBER_TABLE
141: );
142:
143: procedure rosetta_table_copy_in_p5(t out nocopy okl_eth_pvt.okl_ethtl_tbl, a0 JTF_NUMBER_TABLE
144: , a1 JTF_VARCHAR2_TABLE_2000
139: , a31 out nocopy JTF_DATE_TABLE
140: , a32 out nocopy JTF_NUMBER_TABLE
141: );
142:
143: procedure rosetta_table_copy_in_p5(t out nocopy okl_eth_pvt.okl_ethtl_tbl, a0 JTF_NUMBER_TABLE
144: , a1 JTF_VARCHAR2_TABLE_2000
145: , a2 JTF_VARCHAR2_TABLE_100
146: , a3 JTF_VARCHAR2_TABLE_100
147: , a4 JTF_VARCHAR2_TABLE_100
144: , a1 JTF_VARCHAR2_TABLE_2000
145: , a2 JTF_VARCHAR2_TABLE_100
146: , a3 JTF_VARCHAR2_TABLE_100
147: , a4 JTF_VARCHAR2_TABLE_100
148: , a5 JTF_NUMBER_TABLE
149: , a6 JTF_DATE_TABLE
150: , a7 JTF_NUMBER_TABLE
151: , a8 JTF_DATE_TABLE
152: , a9 JTF_NUMBER_TABLE
146: , a3 JTF_VARCHAR2_TABLE_100
147: , a4 JTF_VARCHAR2_TABLE_100
148: , a5 JTF_NUMBER_TABLE
149: , a6 JTF_DATE_TABLE
150: , a7 JTF_NUMBER_TABLE
151: , a8 JTF_DATE_TABLE
152: , a9 JTF_NUMBER_TABLE
153: );
154: procedure rosetta_table_copy_out_p5(t okl_eth_pvt.okl_ethtl_tbl, a0 out nocopy JTF_NUMBER_TABLE
148: , a5 JTF_NUMBER_TABLE
149: , a6 JTF_DATE_TABLE
150: , a7 JTF_NUMBER_TABLE
151: , a8 JTF_DATE_TABLE
152: , a9 JTF_NUMBER_TABLE
153: );
154: procedure rosetta_table_copy_out_p5(t okl_eth_pvt.okl_ethtl_tbl, a0 out nocopy JTF_NUMBER_TABLE
155: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
156: , a2 out nocopy JTF_VARCHAR2_TABLE_100
150: , a7 JTF_NUMBER_TABLE
151: , a8 JTF_DATE_TABLE
152: , a9 JTF_NUMBER_TABLE
153: );
154: procedure rosetta_table_copy_out_p5(t okl_eth_pvt.okl_ethtl_tbl, a0 out nocopy JTF_NUMBER_TABLE
155: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
156: , a2 out nocopy JTF_VARCHAR2_TABLE_100
157: , a3 out nocopy JTF_VARCHAR2_TABLE_100
158: , a4 out nocopy JTF_VARCHAR2_TABLE_100
155: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
156: , a2 out nocopy JTF_VARCHAR2_TABLE_100
157: , a3 out nocopy JTF_VARCHAR2_TABLE_100
158: , a4 out nocopy JTF_VARCHAR2_TABLE_100
159: , a5 out nocopy JTF_NUMBER_TABLE
160: , a6 out nocopy JTF_DATE_TABLE
161: , a7 out nocopy JTF_NUMBER_TABLE
162: , a8 out nocopy JTF_DATE_TABLE
163: , a9 out nocopy JTF_NUMBER_TABLE
157: , a3 out nocopy JTF_VARCHAR2_TABLE_100
158: , a4 out nocopy JTF_VARCHAR2_TABLE_100
159: , a5 out nocopy JTF_NUMBER_TABLE
160: , a6 out nocopy JTF_DATE_TABLE
161: , a7 out nocopy JTF_NUMBER_TABLE
162: , a8 out nocopy JTF_DATE_TABLE
163: , a9 out nocopy JTF_NUMBER_TABLE
164: );
165:
159: , a5 out nocopy JTF_NUMBER_TABLE
160: , a6 out nocopy JTF_DATE_TABLE
161: , a7 out nocopy JTF_NUMBER_TABLE
162: , a8 out nocopy JTF_DATE_TABLE
163: , a9 out nocopy JTF_NUMBER_TABLE
164: );
165:
166: procedure insert_row(p_api_version NUMBER
167: , p_init_msg_list VARCHAR2
241: , p_init_msg_list VARCHAR2
242: , x_return_status out nocopy VARCHAR2
243: , x_msg_count out nocopy NUMBER
244: , x_msg_data out nocopy VARCHAR2
245: , p5_a0 JTF_NUMBER_TABLE
246: , p5_a1 JTF_NUMBER_TABLE
247: , p5_a2 JTF_VARCHAR2_TABLE_300
248: , p5_a3 JTF_VARCHAR2_TABLE_2000
249: , p5_a4 JTF_NUMBER_TABLE
242: , x_return_status out nocopy VARCHAR2
243: , x_msg_count out nocopy NUMBER
244: , x_msg_data out nocopy VARCHAR2
245: , p5_a0 JTF_NUMBER_TABLE
246: , p5_a1 JTF_NUMBER_TABLE
247: , p5_a2 JTF_VARCHAR2_TABLE_300
248: , p5_a3 JTF_VARCHAR2_TABLE_2000
249: , p5_a4 JTF_NUMBER_TABLE
250: , p5_a5 JTF_VARCHAR2_TABLE_100
245: , p5_a0 JTF_NUMBER_TABLE
246: , p5_a1 JTF_NUMBER_TABLE
247: , p5_a2 JTF_VARCHAR2_TABLE_300
248: , p5_a3 JTF_VARCHAR2_TABLE_2000
249: , p5_a4 JTF_NUMBER_TABLE
250: , p5_a5 JTF_VARCHAR2_TABLE_100
251: , p5_a6 JTF_VARCHAR2_TABLE_100
252: , p5_a7 JTF_NUMBER_TABLE
253: , p5_a8 JTF_VARCHAR2_TABLE_100
248: , p5_a3 JTF_VARCHAR2_TABLE_2000
249: , p5_a4 JTF_NUMBER_TABLE
250: , p5_a5 JTF_VARCHAR2_TABLE_100
251: , p5_a6 JTF_VARCHAR2_TABLE_100
252: , p5_a7 JTF_NUMBER_TABLE
253: , p5_a8 JTF_VARCHAR2_TABLE_100
254: , p5_a9 JTF_NUMBER_TABLE
255: , p5_a10 JTF_VARCHAR2_TABLE_100
256: , p5_a11 JTF_DATE_TABLE
250: , p5_a5 JTF_VARCHAR2_TABLE_100
251: , p5_a6 JTF_VARCHAR2_TABLE_100
252: , p5_a7 JTF_NUMBER_TABLE
253: , p5_a8 JTF_VARCHAR2_TABLE_100
254: , p5_a9 JTF_NUMBER_TABLE
255: , p5_a10 JTF_VARCHAR2_TABLE_100
256: , p5_a11 JTF_DATE_TABLE
257: , p5_a12 JTF_DATE_TABLE
258: , p5_a13 JTF_VARCHAR2_TABLE_100
270: , p5_a25 JTF_VARCHAR2_TABLE_500
271: , p5_a26 JTF_VARCHAR2_TABLE_500
272: , p5_a27 JTF_VARCHAR2_TABLE_500
273: , p5_a28 JTF_VARCHAR2_TABLE_500
274: , p5_a29 JTF_NUMBER_TABLE
275: , p5_a30 JTF_DATE_TABLE
276: , p5_a31 JTF_NUMBER_TABLE
277: , p5_a32 JTF_DATE_TABLE
278: , p5_a33 JTF_NUMBER_TABLE
272: , p5_a27 JTF_VARCHAR2_TABLE_500
273: , p5_a28 JTF_VARCHAR2_TABLE_500
274: , p5_a29 JTF_NUMBER_TABLE
275: , p5_a30 JTF_DATE_TABLE
276: , p5_a31 JTF_NUMBER_TABLE
277: , p5_a32 JTF_DATE_TABLE
278: , p5_a33 JTF_NUMBER_TABLE
279: , p6_a0 out nocopy JTF_NUMBER_TABLE
280: , p6_a1 out nocopy JTF_NUMBER_TABLE
274: , p5_a29 JTF_NUMBER_TABLE
275: , p5_a30 JTF_DATE_TABLE
276: , p5_a31 JTF_NUMBER_TABLE
277: , p5_a32 JTF_DATE_TABLE
278: , p5_a33 JTF_NUMBER_TABLE
279: , p6_a0 out nocopy JTF_NUMBER_TABLE
280: , p6_a1 out nocopy JTF_NUMBER_TABLE
281: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
282: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
275: , p5_a30 JTF_DATE_TABLE
276: , p5_a31 JTF_NUMBER_TABLE
277: , p5_a32 JTF_DATE_TABLE
278: , p5_a33 JTF_NUMBER_TABLE
279: , p6_a0 out nocopy JTF_NUMBER_TABLE
280: , p6_a1 out nocopy JTF_NUMBER_TABLE
281: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
282: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
283: , p6_a4 out nocopy JTF_NUMBER_TABLE
276: , p5_a31 JTF_NUMBER_TABLE
277: , p5_a32 JTF_DATE_TABLE
278: , p5_a33 JTF_NUMBER_TABLE
279: , p6_a0 out nocopy JTF_NUMBER_TABLE
280: , p6_a1 out nocopy JTF_NUMBER_TABLE
281: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
282: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
283: , p6_a4 out nocopy JTF_NUMBER_TABLE
284: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
279: , p6_a0 out nocopy JTF_NUMBER_TABLE
280: , p6_a1 out nocopy JTF_NUMBER_TABLE
281: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
282: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
283: , p6_a4 out nocopy JTF_NUMBER_TABLE
284: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
285: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
286: , p6_a7 out nocopy JTF_NUMBER_TABLE
287: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
282: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
283: , p6_a4 out nocopy JTF_NUMBER_TABLE
284: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
285: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
286: , p6_a7 out nocopy JTF_NUMBER_TABLE
287: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
288: , p6_a9 out nocopy JTF_NUMBER_TABLE
289: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
290: , p6_a11 out nocopy JTF_DATE_TABLE
284: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
285: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
286: , p6_a7 out nocopy JTF_NUMBER_TABLE
287: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
288: , p6_a9 out nocopy JTF_NUMBER_TABLE
289: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
290: , p6_a11 out nocopy JTF_DATE_TABLE
291: , p6_a12 out nocopy JTF_DATE_TABLE
292: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
304: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
305: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
306: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
307: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
308: , p6_a29 out nocopy JTF_NUMBER_TABLE
309: , p6_a30 out nocopy JTF_DATE_TABLE
310: , p6_a31 out nocopy JTF_NUMBER_TABLE
311: , p6_a32 out nocopy JTF_DATE_TABLE
312: , p6_a33 out nocopy JTF_NUMBER_TABLE
306: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
307: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
308: , p6_a29 out nocopy JTF_NUMBER_TABLE
309: , p6_a30 out nocopy JTF_DATE_TABLE
310: , p6_a31 out nocopy JTF_NUMBER_TABLE
311: , p6_a32 out nocopy JTF_DATE_TABLE
312: , p6_a33 out nocopy JTF_NUMBER_TABLE
313: );
314: procedure update_row(p_api_version NUMBER
308: , p6_a29 out nocopy JTF_NUMBER_TABLE
309: , p6_a30 out nocopy JTF_DATE_TABLE
310: , p6_a31 out nocopy JTF_NUMBER_TABLE
311: , p6_a32 out nocopy JTF_DATE_TABLE
312: , p6_a33 out nocopy JTF_NUMBER_TABLE
313: );
314: procedure update_row(p_api_version NUMBER
315: , p_init_msg_list VARCHAR2
316: , x_return_status out nocopy VARCHAR2
389: , p_init_msg_list VARCHAR2
390: , x_return_status out nocopy VARCHAR2
391: , x_msg_count out nocopy NUMBER
392: , x_msg_data out nocopy VARCHAR2
393: , p5_a0 JTF_NUMBER_TABLE
394: , p5_a1 JTF_NUMBER_TABLE
395: , p5_a2 JTF_VARCHAR2_TABLE_300
396: , p5_a3 JTF_VARCHAR2_TABLE_2000
397: , p5_a4 JTF_NUMBER_TABLE
390: , x_return_status out nocopy VARCHAR2
391: , x_msg_count out nocopy NUMBER
392: , x_msg_data out nocopy VARCHAR2
393: , p5_a0 JTF_NUMBER_TABLE
394: , p5_a1 JTF_NUMBER_TABLE
395: , p5_a2 JTF_VARCHAR2_TABLE_300
396: , p5_a3 JTF_VARCHAR2_TABLE_2000
397: , p5_a4 JTF_NUMBER_TABLE
398: , p5_a5 JTF_VARCHAR2_TABLE_100
393: , p5_a0 JTF_NUMBER_TABLE
394: , p5_a1 JTF_NUMBER_TABLE
395: , p5_a2 JTF_VARCHAR2_TABLE_300
396: , p5_a3 JTF_VARCHAR2_TABLE_2000
397: , p5_a4 JTF_NUMBER_TABLE
398: , p5_a5 JTF_VARCHAR2_TABLE_100
399: , p5_a6 JTF_VARCHAR2_TABLE_100
400: , p5_a7 JTF_NUMBER_TABLE
401: , p5_a8 JTF_VARCHAR2_TABLE_100
396: , p5_a3 JTF_VARCHAR2_TABLE_2000
397: , p5_a4 JTF_NUMBER_TABLE
398: , p5_a5 JTF_VARCHAR2_TABLE_100
399: , p5_a6 JTF_VARCHAR2_TABLE_100
400: , p5_a7 JTF_NUMBER_TABLE
401: , p5_a8 JTF_VARCHAR2_TABLE_100
402: , p5_a9 JTF_NUMBER_TABLE
403: , p5_a10 JTF_VARCHAR2_TABLE_100
404: , p5_a11 JTF_DATE_TABLE
398: , p5_a5 JTF_VARCHAR2_TABLE_100
399: , p5_a6 JTF_VARCHAR2_TABLE_100
400: , p5_a7 JTF_NUMBER_TABLE
401: , p5_a8 JTF_VARCHAR2_TABLE_100
402: , p5_a9 JTF_NUMBER_TABLE
403: , p5_a10 JTF_VARCHAR2_TABLE_100
404: , p5_a11 JTF_DATE_TABLE
405: , p5_a12 JTF_DATE_TABLE
406: , p5_a13 JTF_VARCHAR2_TABLE_100
418: , p5_a25 JTF_VARCHAR2_TABLE_500
419: , p5_a26 JTF_VARCHAR2_TABLE_500
420: , p5_a27 JTF_VARCHAR2_TABLE_500
421: , p5_a28 JTF_VARCHAR2_TABLE_500
422: , p5_a29 JTF_NUMBER_TABLE
423: , p5_a30 JTF_DATE_TABLE
424: , p5_a31 JTF_NUMBER_TABLE
425: , p5_a32 JTF_DATE_TABLE
426: , p5_a33 JTF_NUMBER_TABLE
420: , p5_a27 JTF_VARCHAR2_TABLE_500
421: , p5_a28 JTF_VARCHAR2_TABLE_500
422: , p5_a29 JTF_NUMBER_TABLE
423: , p5_a30 JTF_DATE_TABLE
424: , p5_a31 JTF_NUMBER_TABLE
425: , p5_a32 JTF_DATE_TABLE
426: , p5_a33 JTF_NUMBER_TABLE
427: , p6_a0 out nocopy JTF_NUMBER_TABLE
428: , p6_a1 out nocopy JTF_NUMBER_TABLE
422: , p5_a29 JTF_NUMBER_TABLE
423: , p5_a30 JTF_DATE_TABLE
424: , p5_a31 JTF_NUMBER_TABLE
425: , p5_a32 JTF_DATE_TABLE
426: , p5_a33 JTF_NUMBER_TABLE
427: , p6_a0 out nocopy JTF_NUMBER_TABLE
428: , p6_a1 out nocopy JTF_NUMBER_TABLE
429: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
430: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
423: , p5_a30 JTF_DATE_TABLE
424: , p5_a31 JTF_NUMBER_TABLE
425: , p5_a32 JTF_DATE_TABLE
426: , p5_a33 JTF_NUMBER_TABLE
427: , p6_a0 out nocopy JTF_NUMBER_TABLE
428: , p6_a1 out nocopy JTF_NUMBER_TABLE
429: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
430: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
431: , p6_a4 out nocopy JTF_NUMBER_TABLE
424: , p5_a31 JTF_NUMBER_TABLE
425: , p5_a32 JTF_DATE_TABLE
426: , p5_a33 JTF_NUMBER_TABLE
427: , p6_a0 out nocopy JTF_NUMBER_TABLE
428: , p6_a1 out nocopy JTF_NUMBER_TABLE
429: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
430: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
431: , p6_a4 out nocopy JTF_NUMBER_TABLE
432: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
427: , p6_a0 out nocopy JTF_NUMBER_TABLE
428: , p6_a1 out nocopy JTF_NUMBER_TABLE
429: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_300
430: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
431: , p6_a4 out nocopy JTF_NUMBER_TABLE
432: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
433: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
434: , p6_a7 out nocopy JTF_NUMBER_TABLE
435: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
430: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
431: , p6_a4 out nocopy JTF_NUMBER_TABLE
432: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
433: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
434: , p6_a7 out nocopy JTF_NUMBER_TABLE
435: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
436: , p6_a9 out nocopy JTF_NUMBER_TABLE
437: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
438: , p6_a11 out nocopy JTF_DATE_TABLE
432: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
433: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
434: , p6_a7 out nocopy JTF_NUMBER_TABLE
435: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
436: , p6_a9 out nocopy JTF_NUMBER_TABLE
437: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
438: , p6_a11 out nocopy JTF_DATE_TABLE
439: , p6_a12 out nocopy JTF_DATE_TABLE
440: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
452: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
453: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_500
454: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
455: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
456: , p6_a29 out nocopy JTF_NUMBER_TABLE
457: , p6_a30 out nocopy JTF_DATE_TABLE
458: , p6_a31 out nocopy JTF_NUMBER_TABLE
459: , p6_a32 out nocopy JTF_DATE_TABLE
460: , p6_a33 out nocopy JTF_NUMBER_TABLE
454: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
455: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
456: , p6_a29 out nocopy JTF_NUMBER_TABLE
457: , p6_a30 out nocopy JTF_DATE_TABLE
458: , p6_a31 out nocopy JTF_NUMBER_TABLE
459: , p6_a32 out nocopy JTF_DATE_TABLE
460: , p6_a33 out nocopy JTF_NUMBER_TABLE
461: );
462: procedure delete_row(p_api_version NUMBER
456: , p6_a29 out nocopy JTF_NUMBER_TABLE
457: , p6_a30 out nocopy JTF_DATE_TABLE
458: , p6_a31 out nocopy JTF_NUMBER_TABLE
459: , p6_a32 out nocopy JTF_DATE_TABLE
460: , p6_a33 out nocopy JTF_NUMBER_TABLE
461: );
462: procedure delete_row(p_api_version NUMBER
463: , p_init_msg_list VARCHAR2
464: , x_return_status out nocopy VARCHAR2
503: , p_init_msg_list VARCHAR2
504: , x_return_status out nocopy VARCHAR2
505: , x_msg_count out nocopy NUMBER
506: , x_msg_data out nocopy VARCHAR2
507: , p5_a0 JTF_NUMBER_TABLE
508: , p5_a1 JTF_NUMBER_TABLE
509: , p5_a2 JTF_VARCHAR2_TABLE_300
510: , p5_a3 JTF_VARCHAR2_TABLE_2000
511: , p5_a4 JTF_NUMBER_TABLE
504: , x_return_status out nocopy VARCHAR2
505: , x_msg_count out nocopy NUMBER
506: , x_msg_data out nocopy VARCHAR2
507: , p5_a0 JTF_NUMBER_TABLE
508: , p5_a1 JTF_NUMBER_TABLE
509: , p5_a2 JTF_VARCHAR2_TABLE_300
510: , p5_a3 JTF_VARCHAR2_TABLE_2000
511: , p5_a4 JTF_NUMBER_TABLE
512: , p5_a5 JTF_VARCHAR2_TABLE_100
507: , p5_a0 JTF_NUMBER_TABLE
508: , p5_a1 JTF_NUMBER_TABLE
509: , p5_a2 JTF_VARCHAR2_TABLE_300
510: , p5_a3 JTF_VARCHAR2_TABLE_2000
511: , p5_a4 JTF_NUMBER_TABLE
512: , p5_a5 JTF_VARCHAR2_TABLE_100
513: , p5_a6 JTF_VARCHAR2_TABLE_100
514: , p5_a7 JTF_NUMBER_TABLE
515: , p5_a8 JTF_VARCHAR2_TABLE_100
510: , p5_a3 JTF_VARCHAR2_TABLE_2000
511: , p5_a4 JTF_NUMBER_TABLE
512: , p5_a5 JTF_VARCHAR2_TABLE_100
513: , p5_a6 JTF_VARCHAR2_TABLE_100
514: , p5_a7 JTF_NUMBER_TABLE
515: , p5_a8 JTF_VARCHAR2_TABLE_100
516: , p5_a9 JTF_NUMBER_TABLE
517: , p5_a10 JTF_VARCHAR2_TABLE_100
518: , p5_a11 JTF_DATE_TABLE
512: , p5_a5 JTF_VARCHAR2_TABLE_100
513: , p5_a6 JTF_VARCHAR2_TABLE_100
514: , p5_a7 JTF_NUMBER_TABLE
515: , p5_a8 JTF_VARCHAR2_TABLE_100
516: , p5_a9 JTF_NUMBER_TABLE
517: , p5_a10 JTF_VARCHAR2_TABLE_100
518: , p5_a11 JTF_DATE_TABLE
519: , p5_a12 JTF_DATE_TABLE
520: , p5_a13 JTF_VARCHAR2_TABLE_100
532: , p5_a25 JTF_VARCHAR2_TABLE_500
533: , p5_a26 JTF_VARCHAR2_TABLE_500
534: , p5_a27 JTF_VARCHAR2_TABLE_500
535: , p5_a28 JTF_VARCHAR2_TABLE_500
536: , p5_a29 JTF_NUMBER_TABLE
537: , p5_a30 JTF_DATE_TABLE
538: , p5_a31 JTF_NUMBER_TABLE
539: , p5_a32 JTF_DATE_TABLE
540: , p5_a33 JTF_NUMBER_TABLE
534: , p5_a27 JTF_VARCHAR2_TABLE_500
535: , p5_a28 JTF_VARCHAR2_TABLE_500
536: , p5_a29 JTF_NUMBER_TABLE
537: , p5_a30 JTF_DATE_TABLE
538: , p5_a31 JTF_NUMBER_TABLE
539: , p5_a32 JTF_DATE_TABLE
540: , p5_a33 JTF_NUMBER_TABLE
541: );
542: end okl_eth_pvt_w;
536: , p5_a29 JTF_NUMBER_TABLE
537: , p5_a30 JTF_DATE_TABLE
538: , p5_a31 JTF_NUMBER_TABLE
539: , p5_a32 JTF_DATE_TABLE
540: , p5_a33 JTF_NUMBER_TABLE
541: );
542: end okl_eth_pvt_w;