1: package okl_sta_pvt_w as
2: /* $Header: OKLISTAS.pls 120.1 2005/08/11 11:06:55 dkagrawa noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sta_pvt.sta_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
1: package okl_sta_pvt_w as
2: /* $Header: OKLISTAS.pls 120.1 2005/08/11 11:06:55 dkagrawa noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sta_pvt.sta_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
1: package okl_sta_pvt_w as
2: /* $Header: OKLISTAS.pls 120.1 2005/08/11 11:06:55 dkagrawa noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sta_pvt.sta_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sta_pvt.sta_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_500
11: , a8 JTF_VARCHAR2_TABLE_500
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_500
11: , a8 JTF_VARCHAR2_TABLE_500
12: , a9 JTF_VARCHAR2_TABLE_500
21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: );
31: procedure rosetta_table_copy_out_p2(t okl_sta_pvt.sta_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_DATE_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: );
31: procedure rosetta_table_copy_out_p2(t okl_sta_pvt.sta_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32: , a1 out nocopy JTF_NUMBER_TABLE
33: , a2 out nocopy JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: );
31: procedure rosetta_table_copy_out_p2(t okl_sta_pvt.sta_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32: , a1 out nocopy JTF_NUMBER_TABLE
33: , a2 out nocopy JTF_NUMBER_TABLE
34: , a3 out nocopy JTF_VARCHAR2_TABLE_100
35: , a4 out nocopy JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: );
31: procedure rosetta_table_copy_out_p2(t okl_sta_pvt.sta_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32: , a1 out nocopy JTF_NUMBER_TABLE
33: , a2 out nocopy JTF_NUMBER_TABLE
34: , a3 out nocopy JTF_VARCHAR2_TABLE_100
35: , a4 out nocopy JTF_NUMBER_TABLE
36: , a5 out nocopy JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: );
31: procedure rosetta_table_copy_out_p2(t okl_sta_pvt.sta_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32: , a1 out nocopy JTF_NUMBER_TABLE
33: , a2 out nocopy JTF_NUMBER_TABLE
34: , a3 out nocopy JTF_VARCHAR2_TABLE_100
35: , a4 out nocopy JTF_NUMBER_TABLE
36: , a5 out nocopy JTF_NUMBER_TABLE
37: , a6 out nocopy JTF_VARCHAR2_TABLE_100
31: procedure rosetta_table_copy_out_p2(t okl_sta_pvt.sta_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32: , a1 out nocopy JTF_NUMBER_TABLE
33: , a2 out nocopy JTF_NUMBER_TABLE
34: , a3 out nocopy JTF_VARCHAR2_TABLE_100
35: , a4 out nocopy JTF_NUMBER_TABLE
36: , a5 out nocopy JTF_NUMBER_TABLE
37: , a6 out nocopy JTF_VARCHAR2_TABLE_100
38: , a7 out nocopy JTF_VARCHAR2_TABLE_500
39: , a8 out nocopy JTF_VARCHAR2_TABLE_500
32: , a1 out nocopy JTF_NUMBER_TABLE
33: , a2 out nocopy JTF_NUMBER_TABLE
34: , a3 out nocopy JTF_VARCHAR2_TABLE_100
35: , a4 out nocopy JTF_NUMBER_TABLE
36: , a5 out nocopy JTF_NUMBER_TABLE
37: , a6 out nocopy JTF_VARCHAR2_TABLE_100
38: , a7 out nocopy JTF_VARCHAR2_TABLE_500
39: , a8 out nocopy JTF_VARCHAR2_TABLE_500
40: , a9 out nocopy JTF_VARCHAR2_TABLE_500
49: , a18 out nocopy JTF_VARCHAR2_TABLE_500
50: , a19 out nocopy JTF_VARCHAR2_TABLE_500
51: , a20 out nocopy JTF_VARCHAR2_TABLE_500
52: , a21 out nocopy JTF_VARCHAR2_TABLE_500
53: , a22 out nocopy JTF_NUMBER_TABLE
54: , a23 out nocopy JTF_DATE_TABLE
55: , a24 out nocopy JTF_NUMBER_TABLE
56: , a25 out nocopy JTF_DATE_TABLE
57: , a26 out nocopy JTF_NUMBER_TABLE
51: , a20 out nocopy JTF_VARCHAR2_TABLE_500
52: , a21 out nocopy JTF_VARCHAR2_TABLE_500
53: , a22 out nocopy JTF_NUMBER_TABLE
54: , a23 out nocopy JTF_DATE_TABLE
55: , a24 out nocopy JTF_NUMBER_TABLE
56: , a25 out nocopy JTF_DATE_TABLE
57: , a26 out nocopy JTF_NUMBER_TABLE
58: );
59:
53: , a22 out nocopy JTF_NUMBER_TABLE
54: , a23 out nocopy JTF_DATE_TABLE
55: , a24 out nocopy JTF_NUMBER_TABLE
56: , a25 out nocopy JTF_DATE_TABLE
57: , a26 out nocopy JTF_NUMBER_TABLE
58: );
59:
60: procedure rosetta_table_copy_in_p5(t out nocopy okl_sta_pvt.stav_tbl_type, a0 JTF_NUMBER_TABLE
61: , a1 JTF_NUMBER_TABLE
56: , a25 out nocopy JTF_DATE_TABLE
57: , a26 out nocopy JTF_NUMBER_TABLE
58: );
59:
60: procedure rosetta_table_copy_in_p5(t out nocopy okl_sta_pvt.stav_tbl_type, a0 JTF_NUMBER_TABLE
61: , a1 JTF_NUMBER_TABLE
62: , a2 JTF_NUMBER_TABLE
63: , a3 JTF_NUMBER_TABLE
64: , a4 JTF_NUMBER_TABLE
57: , a26 out nocopy JTF_NUMBER_TABLE
58: );
59:
60: procedure rosetta_table_copy_in_p5(t out nocopy okl_sta_pvt.stav_tbl_type, a0 JTF_NUMBER_TABLE
61: , a1 JTF_NUMBER_TABLE
62: , a2 JTF_NUMBER_TABLE
63: , a3 JTF_NUMBER_TABLE
64: , a4 JTF_NUMBER_TABLE
65: , a5 JTF_VARCHAR2_TABLE_100
58: );
59:
60: procedure rosetta_table_copy_in_p5(t out nocopy okl_sta_pvt.stav_tbl_type, a0 JTF_NUMBER_TABLE
61: , a1 JTF_NUMBER_TABLE
62: , a2 JTF_NUMBER_TABLE
63: , a3 JTF_NUMBER_TABLE
64: , a4 JTF_NUMBER_TABLE
65: , a5 JTF_VARCHAR2_TABLE_100
66: , a6 JTF_VARCHAR2_TABLE_500
59:
60: procedure rosetta_table_copy_in_p5(t out nocopy okl_sta_pvt.stav_tbl_type, a0 JTF_NUMBER_TABLE
61: , a1 JTF_NUMBER_TABLE
62: , a2 JTF_NUMBER_TABLE
63: , a3 JTF_NUMBER_TABLE
64: , a4 JTF_NUMBER_TABLE
65: , a5 JTF_VARCHAR2_TABLE_100
66: , a6 JTF_VARCHAR2_TABLE_500
67: , a7 JTF_VARCHAR2_TABLE_500
60: procedure rosetta_table_copy_in_p5(t out nocopy okl_sta_pvt.stav_tbl_type, a0 JTF_NUMBER_TABLE
61: , a1 JTF_NUMBER_TABLE
62: , a2 JTF_NUMBER_TABLE
63: , a3 JTF_NUMBER_TABLE
64: , a4 JTF_NUMBER_TABLE
65: , a5 JTF_VARCHAR2_TABLE_100
66: , a6 JTF_VARCHAR2_TABLE_500
67: , a7 JTF_VARCHAR2_TABLE_500
68: , a8 JTF_VARCHAR2_TABLE_500
78: , a18 JTF_VARCHAR2_TABLE_500
79: , a19 JTF_VARCHAR2_TABLE_500
80: , a20 JTF_VARCHAR2_TABLE_500
81: , a21 JTF_VARCHAR2_TABLE_100
82: , a22 JTF_NUMBER_TABLE
83: , a23 JTF_DATE_TABLE
84: , a24 JTF_NUMBER_TABLE
85: , a25 JTF_DATE_TABLE
86: , a26 JTF_NUMBER_TABLE
80: , a20 JTF_VARCHAR2_TABLE_500
81: , a21 JTF_VARCHAR2_TABLE_100
82: , a22 JTF_NUMBER_TABLE
83: , a23 JTF_DATE_TABLE
84: , a24 JTF_NUMBER_TABLE
85: , a25 JTF_DATE_TABLE
86: , a26 JTF_NUMBER_TABLE
87: );
88: procedure rosetta_table_copy_out_p5(t okl_sta_pvt.stav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
82: , a22 JTF_NUMBER_TABLE
83: , a23 JTF_DATE_TABLE
84: , a24 JTF_NUMBER_TABLE
85: , a25 JTF_DATE_TABLE
86: , a26 JTF_NUMBER_TABLE
87: );
88: procedure rosetta_table_copy_out_p5(t okl_sta_pvt.stav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
89: , a1 out nocopy JTF_NUMBER_TABLE
90: , a2 out nocopy JTF_NUMBER_TABLE
84: , a24 JTF_NUMBER_TABLE
85: , a25 JTF_DATE_TABLE
86: , a26 JTF_NUMBER_TABLE
87: );
88: procedure rosetta_table_copy_out_p5(t okl_sta_pvt.stav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
89: , a1 out nocopy JTF_NUMBER_TABLE
90: , a2 out nocopy JTF_NUMBER_TABLE
91: , a3 out nocopy JTF_NUMBER_TABLE
92: , a4 out nocopy JTF_NUMBER_TABLE
85: , a25 JTF_DATE_TABLE
86: , a26 JTF_NUMBER_TABLE
87: );
88: procedure rosetta_table_copy_out_p5(t okl_sta_pvt.stav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
89: , a1 out nocopy JTF_NUMBER_TABLE
90: , a2 out nocopy JTF_NUMBER_TABLE
91: , a3 out nocopy JTF_NUMBER_TABLE
92: , a4 out nocopy JTF_NUMBER_TABLE
93: , a5 out nocopy JTF_VARCHAR2_TABLE_100
86: , a26 JTF_NUMBER_TABLE
87: );
88: procedure rosetta_table_copy_out_p5(t okl_sta_pvt.stav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
89: , a1 out nocopy JTF_NUMBER_TABLE
90: , a2 out nocopy JTF_NUMBER_TABLE
91: , a3 out nocopy JTF_NUMBER_TABLE
92: , a4 out nocopy JTF_NUMBER_TABLE
93: , a5 out nocopy JTF_VARCHAR2_TABLE_100
94: , a6 out nocopy JTF_VARCHAR2_TABLE_500
87: );
88: procedure rosetta_table_copy_out_p5(t okl_sta_pvt.stav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
89: , a1 out nocopy JTF_NUMBER_TABLE
90: , a2 out nocopy JTF_NUMBER_TABLE
91: , a3 out nocopy JTF_NUMBER_TABLE
92: , a4 out nocopy JTF_NUMBER_TABLE
93: , a5 out nocopy JTF_VARCHAR2_TABLE_100
94: , a6 out nocopy JTF_VARCHAR2_TABLE_500
95: , a7 out nocopy JTF_VARCHAR2_TABLE_500
88: procedure rosetta_table_copy_out_p5(t okl_sta_pvt.stav_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
89: , a1 out nocopy JTF_NUMBER_TABLE
90: , a2 out nocopy JTF_NUMBER_TABLE
91: , a3 out nocopy JTF_NUMBER_TABLE
92: , a4 out nocopy JTF_NUMBER_TABLE
93: , a5 out nocopy JTF_VARCHAR2_TABLE_100
94: , a6 out nocopy JTF_VARCHAR2_TABLE_500
95: , a7 out nocopy JTF_VARCHAR2_TABLE_500
96: , a8 out nocopy JTF_VARCHAR2_TABLE_500
106: , a18 out nocopy JTF_VARCHAR2_TABLE_500
107: , a19 out nocopy JTF_VARCHAR2_TABLE_500
108: , a20 out nocopy JTF_VARCHAR2_TABLE_500
109: , a21 out nocopy JTF_VARCHAR2_TABLE_100
110: , a22 out nocopy JTF_NUMBER_TABLE
111: , a23 out nocopy JTF_DATE_TABLE
112: , a24 out nocopy JTF_NUMBER_TABLE
113: , a25 out nocopy JTF_DATE_TABLE
114: , a26 out nocopy JTF_NUMBER_TABLE
108: , a20 out nocopy JTF_VARCHAR2_TABLE_500
109: , a21 out nocopy JTF_VARCHAR2_TABLE_100
110: , a22 out nocopy JTF_NUMBER_TABLE
111: , a23 out nocopy JTF_DATE_TABLE
112: , a24 out nocopy JTF_NUMBER_TABLE
113: , a25 out nocopy JTF_DATE_TABLE
114: , a26 out nocopy JTF_NUMBER_TABLE
115: );
116:
110: , a22 out nocopy JTF_NUMBER_TABLE
111: , a23 out nocopy JTF_DATE_TABLE
112: , a24 out nocopy JTF_NUMBER_TABLE
113: , a25 out nocopy JTF_DATE_TABLE
114: , a26 out nocopy JTF_NUMBER_TABLE
115: );
116:
117: procedure insert_row(p_api_version NUMBER
118: , p_init_msg_list VARCHAR2
178: , p_init_msg_list VARCHAR2
179: , x_return_status out nocopy VARCHAR2
180: , x_msg_count out nocopy NUMBER
181: , x_msg_data out nocopy VARCHAR2
182: , p5_a0 JTF_NUMBER_TABLE
183: , p5_a1 JTF_NUMBER_TABLE
184: , p5_a2 JTF_NUMBER_TABLE
185: , p5_a3 JTF_NUMBER_TABLE
186: , p5_a4 JTF_NUMBER_TABLE
179: , x_return_status out nocopy VARCHAR2
180: , x_msg_count out nocopy NUMBER
181: , x_msg_data out nocopy VARCHAR2
182: , p5_a0 JTF_NUMBER_TABLE
183: , p5_a1 JTF_NUMBER_TABLE
184: , p5_a2 JTF_NUMBER_TABLE
185: , p5_a3 JTF_NUMBER_TABLE
186: , p5_a4 JTF_NUMBER_TABLE
187: , p5_a5 JTF_VARCHAR2_TABLE_100
180: , x_msg_count out nocopy NUMBER
181: , x_msg_data out nocopy VARCHAR2
182: , p5_a0 JTF_NUMBER_TABLE
183: , p5_a1 JTF_NUMBER_TABLE
184: , p5_a2 JTF_NUMBER_TABLE
185: , p5_a3 JTF_NUMBER_TABLE
186: , p5_a4 JTF_NUMBER_TABLE
187: , p5_a5 JTF_VARCHAR2_TABLE_100
188: , p5_a6 JTF_VARCHAR2_TABLE_500
181: , x_msg_data out nocopy VARCHAR2
182: , p5_a0 JTF_NUMBER_TABLE
183: , p5_a1 JTF_NUMBER_TABLE
184: , p5_a2 JTF_NUMBER_TABLE
185: , p5_a3 JTF_NUMBER_TABLE
186: , p5_a4 JTF_NUMBER_TABLE
187: , p5_a5 JTF_VARCHAR2_TABLE_100
188: , p5_a6 JTF_VARCHAR2_TABLE_500
189: , p5_a7 JTF_VARCHAR2_TABLE_500
182: , p5_a0 JTF_NUMBER_TABLE
183: , p5_a1 JTF_NUMBER_TABLE
184: , p5_a2 JTF_NUMBER_TABLE
185: , p5_a3 JTF_NUMBER_TABLE
186: , p5_a4 JTF_NUMBER_TABLE
187: , p5_a5 JTF_VARCHAR2_TABLE_100
188: , p5_a6 JTF_VARCHAR2_TABLE_500
189: , p5_a7 JTF_VARCHAR2_TABLE_500
190: , p5_a8 JTF_VARCHAR2_TABLE_500
200: , p5_a18 JTF_VARCHAR2_TABLE_500
201: , p5_a19 JTF_VARCHAR2_TABLE_500
202: , p5_a20 JTF_VARCHAR2_TABLE_500
203: , p5_a21 JTF_VARCHAR2_TABLE_100
204: , p5_a22 JTF_NUMBER_TABLE
205: , p5_a23 JTF_DATE_TABLE
206: , p5_a24 JTF_NUMBER_TABLE
207: , p5_a25 JTF_DATE_TABLE
208: , p5_a26 JTF_NUMBER_TABLE
202: , p5_a20 JTF_VARCHAR2_TABLE_500
203: , p5_a21 JTF_VARCHAR2_TABLE_100
204: , p5_a22 JTF_NUMBER_TABLE
205: , p5_a23 JTF_DATE_TABLE
206: , p5_a24 JTF_NUMBER_TABLE
207: , p5_a25 JTF_DATE_TABLE
208: , p5_a26 JTF_NUMBER_TABLE
209: , p6_a0 out nocopy JTF_NUMBER_TABLE
210: , p6_a1 out nocopy JTF_NUMBER_TABLE
204: , p5_a22 JTF_NUMBER_TABLE
205: , p5_a23 JTF_DATE_TABLE
206: , p5_a24 JTF_NUMBER_TABLE
207: , p5_a25 JTF_DATE_TABLE
208: , p5_a26 JTF_NUMBER_TABLE
209: , p6_a0 out nocopy JTF_NUMBER_TABLE
210: , p6_a1 out nocopy JTF_NUMBER_TABLE
211: , p6_a2 out nocopy JTF_NUMBER_TABLE
212: , p6_a3 out nocopy JTF_NUMBER_TABLE
205: , p5_a23 JTF_DATE_TABLE
206: , p5_a24 JTF_NUMBER_TABLE
207: , p5_a25 JTF_DATE_TABLE
208: , p5_a26 JTF_NUMBER_TABLE
209: , p6_a0 out nocopy JTF_NUMBER_TABLE
210: , p6_a1 out nocopy JTF_NUMBER_TABLE
211: , p6_a2 out nocopy JTF_NUMBER_TABLE
212: , p6_a3 out nocopy JTF_NUMBER_TABLE
213: , p6_a4 out nocopy JTF_NUMBER_TABLE
206: , p5_a24 JTF_NUMBER_TABLE
207: , p5_a25 JTF_DATE_TABLE
208: , p5_a26 JTF_NUMBER_TABLE
209: , p6_a0 out nocopy JTF_NUMBER_TABLE
210: , p6_a1 out nocopy JTF_NUMBER_TABLE
211: , p6_a2 out nocopy JTF_NUMBER_TABLE
212: , p6_a3 out nocopy JTF_NUMBER_TABLE
213: , p6_a4 out nocopy JTF_NUMBER_TABLE
214: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
207: , p5_a25 JTF_DATE_TABLE
208: , p5_a26 JTF_NUMBER_TABLE
209: , p6_a0 out nocopy JTF_NUMBER_TABLE
210: , p6_a1 out nocopy JTF_NUMBER_TABLE
211: , p6_a2 out nocopy JTF_NUMBER_TABLE
212: , p6_a3 out nocopy JTF_NUMBER_TABLE
213: , p6_a4 out nocopy JTF_NUMBER_TABLE
214: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
215: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
208: , p5_a26 JTF_NUMBER_TABLE
209: , p6_a0 out nocopy JTF_NUMBER_TABLE
210: , p6_a1 out nocopy JTF_NUMBER_TABLE
211: , p6_a2 out nocopy JTF_NUMBER_TABLE
212: , p6_a3 out nocopy JTF_NUMBER_TABLE
213: , p6_a4 out nocopy JTF_NUMBER_TABLE
214: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
215: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
216: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
209: , p6_a0 out nocopy JTF_NUMBER_TABLE
210: , p6_a1 out nocopy JTF_NUMBER_TABLE
211: , p6_a2 out nocopy JTF_NUMBER_TABLE
212: , p6_a3 out nocopy JTF_NUMBER_TABLE
213: , p6_a4 out nocopy JTF_NUMBER_TABLE
214: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
215: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
216: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
217: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
227: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
228: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
229: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
230: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
231: , p6_a22 out nocopy JTF_NUMBER_TABLE
232: , p6_a23 out nocopy JTF_DATE_TABLE
233: , p6_a24 out nocopy JTF_NUMBER_TABLE
234: , p6_a25 out nocopy JTF_DATE_TABLE
235: , p6_a26 out nocopy JTF_NUMBER_TABLE
229: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
230: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
231: , p6_a22 out nocopy JTF_NUMBER_TABLE
232: , p6_a23 out nocopy JTF_DATE_TABLE
233: , p6_a24 out nocopy JTF_NUMBER_TABLE
234: , p6_a25 out nocopy JTF_DATE_TABLE
235: , p6_a26 out nocopy JTF_NUMBER_TABLE
236: );
237: procedure lock_row(p_api_version NUMBER
231: , p6_a22 out nocopy JTF_NUMBER_TABLE
232: , p6_a23 out nocopy JTF_DATE_TABLE
233: , p6_a24 out nocopy JTF_NUMBER_TABLE
234: , p6_a25 out nocopy JTF_DATE_TABLE
235: , p6_a26 out nocopy JTF_NUMBER_TABLE
236: );
237: procedure lock_row(p_api_version NUMBER
238: , p_init_msg_list VARCHAR2
239: , x_return_status out nocopy VARCHAR2
271: , p_init_msg_list VARCHAR2
272: , x_return_status out nocopy VARCHAR2
273: , x_msg_count out nocopy NUMBER
274: , x_msg_data out nocopy VARCHAR2
275: , p5_a0 JTF_NUMBER_TABLE
276: , p5_a1 JTF_NUMBER_TABLE
277: , p5_a2 JTF_NUMBER_TABLE
278: , p5_a3 JTF_NUMBER_TABLE
279: , p5_a4 JTF_NUMBER_TABLE
272: , x_return_status out nocopy VARCHAR2
273: , x_msg_count out nocopy NUMBER
274: , x_msg_data out nocopy VARCHAR2
275: , p5_a0 JTF_NUMBER_TABLE
276: , p5_a1 JTF_NUMBER_TABLE
277: , p5_a2 JTF_NUMBER_TABLE
278: , p5_a3 JTF_NUMBER_TABLE
279: , p5_a4 JTF_NUMBER_TABLE
280: , p5_a5 JTF_VARCHAR2_TABLE_100
273: , x_msg_count out nocopy NUMBER
274: , x_msg_data out nocopy VARCHAR2
275: , p5_a0 JTF_NUMBER_TABLE
276: , p5_a1 JTF_NUMBER_TABLE
277: , p5_a2 JTF_NUMBER_TABLE
278: , p5_a3 JTF_NUMBER_TABLE
279: , p5_a4 JTF_NUMBER_TABLE
280: , p5_a5 JTF_VARCHAR2_TABLE_100
281: , p5_a6 JTF_VARCHAR2_TABLE_500
274: , x_msg_data out nocopy VARCHAR2
275: , p5_a0 JTF_NUMBER_TABLE
276: , p5_a1 JTF_NUMBER_TABLE
277: , p5_a2 JTF_NUMBER_TABLE
278: , p5_a3 JTF_NUMBER_TABLE
279: , p5_a4 JTF_NUMBER_TABLE
280: , p5_a5 JTF_VARCHAR2_TABLE_100
281: , p5_a6 JTF_VARCHAR2_TABLE_500
282: , p5_a7 JTF_VARCHAR2_TABLE_500
275: , p5_a0 JTF_NUMBER_TABLE
276: , p5_a1 JTF_NUMBER_TABLE
277: , p5_a2 JTF_NUMBER_TABLE
278: , p5_a3 JTF_NUMBER_TABLE
279: , p5_a4 JTF_NUMBER_TABLE
280: , p5_a5 JTF_VARCHAR2_TABLE_100
281: , p5_a6 JTF_VARCHAR2_TABLE_500
282: , p5_a7 JTF_VARCHAR2_TABLE_500
283: , p5_a8 JTF_VARCHAR2_TABLE_500
293: , p5_a18 JTF_VARCHAR2_TABLE_500
294: , p5_a19 JTF_VARCHAR2_TABLE_500
295: , p5_a20 JTF_VARCHAR2_TABLE_500
296: , p5_a21 JTF_VARCHAR2_TABLE_100
297: , p5_a22 JTF_NUMBER_TABLE
298: , p5_a23 JTF_DATE_TABLE
299: , p5_a24 JTF_NUMBER_TABLE
300: , p5_a25 JTF_DATE_TABLE
301: , p5_a26 JTF_NUMBER_TABLE
295: , p5_a20 JTF_VARCHAR2_TABLE_500
296: , p5_a21 JTF_VARCHAR2_TABLE_100
297: , p5_a22 JTF_NUMBER_TABLE
298: , p5_a23 JTF_DATE_TABLE
299: , p5_a24 JTF_NUMBER_TABLE
300: , p5_a25 JTF_DATE_TABLE
301: , p5_a26 JTF_NUMBER_TABLE
302: );
303: procedure update_row(p_api_version NUMBER
297: , p5_a22 JTF_NUMBER_TABLE
298: , p5_a23 JTF_DATE_TABLE
299: , p5_a24 JTF_NUMBER_TABLE
300: , p5_a25 JTF_DATE_TABLE
301: , p5_a26 JTF_NUMBER_TABLE
302: );
303: procedure update_row(p_api_version NUMBER
304: , p_init_msg_list VARCHAR2
305: , x_return_status out nocopy VARCHAR2
364: , p_init_msg_list VARCHAR2
365: , x_return_status out nocopy VARCHAR2
366: , x_msg_count out nocopy NUMBER
367: , x_msg_data out nocopy VARCHAR2
368: , p5_a0 JTF_NUMBER_TABLE
369: , p5_a1 JTF_NUMBER_TABLE
370: , p5_a2 JTF_NUMBER_TABLE
371: , p5_a3 JTF_NUMBER_TABLE
372: , p5_a4 JTF_NUMBER_TABLE
365: , x_return_status out nocopy VARCHAR2
366: , x_msg_count out nocopy NUMBER
367: , x_msg_data out nocopy VARCHAR2
368: , p5_a0 JTF_NUMBER_TABLE
369: , p5_a1 JTF_NUMBER_TABLE
370: , p5_a2 JTF_NUMBER_TABLE
371: , p5_a3 JTF_NUMBER_TABLE
372: , p5_a4 JTF_NUMBER_TABLE
373: , p5_a5 JTF_VARCHAR2_TABLE_100
366: , x_msg_count out nocopy NUMBER
367: , x_msg_data out nocopy VARCHAR2
368: , p5_a0 JTF_NUMBER_TABLE
369: , p5_a1 JTF_NUMBER_TABLE
370: , p5_a2 JTF_NUMBER_TABLE
371: , p5_a3 JTF_NUMBER_TABLE
372: , p5_a4 JTF_NUMBER_TABLE
373: , p5_a5 JTF_VARCHAR2_TABLE_100
374: , p5_a6 JTF_VARCHAR2_TABLE_500
367: , x_msg_data out nocopy VARCHAR2
368: , p5_a0 JTF_NUMBER_TABLE
369: , p5_a1 JTF_NUMBER_TABLE
370: , p5_a2 JTF_NUMBER_TABLE
371: , p5_a3 JTF_NUMBER_TABLE
372: , p5_a4 JTF_NUMBER_TABLE
373: , p5_a5 JTF_VARCHAR2_TABLE_100
374: , p5_a6 JTF_VARCHAR2_TABLE_500
375: , p5_a7 JTF_VARCHAR2_TABLE_500
368: , p5_a0 JTF_NUMBER_TABLE
369: , p5_a1 JTF_NUMBER_TABLE
370: , p5_a2 JTF_NUMBER_TABLE
371: , p5_a3 JTF_NUMBER_TABLE
372: , p5_a4 JTF_NUMBER_TABLE
373: , p5_a5 JTF_VARCHAR2_TABLE_100
374: , p5_a6 JTF_VARCHAR2_TABLE_500
375: , p5_a7 JTF_VARCHAR2_TABLE_500
376: , p5_a8 JTF_VARCHAR2_TABLE_500
386: , p5_a18 JTF_VARCHAR2_TABLE_500
387: , p5_a19 JTF_VARCHAR2_TABLE_500
388: , p5_a20 JTF_VARCHAR2_TABLE_500
389: , p5_a21 JTF_VARCHAR2_TABLE_100
390: , p5_a22 JTF_NUMBER_TABLE
391: , p5_a23 JTF_DATE_TABLE
392: , p5_a24 JTF_NUMBER_TABLE
393: , p5_a25 JTF_DATE_TABLE
394: , p5_a26 JTF_NUMBER_TABLE
388: , p5_a20 JTF_VARCHAR2_TABLE_500
389: , p5_a21 JTF_VARCHAR2_TABLE_100
390: , p5_a22 JTF_NUMBER_TABLE
391: , p5_a23 JTF_DATE_TABLE
392: , p5_a24 JTF_NUMBER_TABLE
393: , p5_a25 JTF_DATE_TABLE
394: , p5_a26 JTF_NUMBER_TABLE
395: , p6_a0 out nocopy JTF_NUMBER_TABLE
396: , p6_a1 out nocopy JTF_NUMBER_TABLE
390: , p5_a22 JTF_NUMBER_TABLE
391: , p5_a23 JTF_DATE_TABLE
392: , p5_a24 JTF_NUMBER_TABLE
393: , p5_a25 JTF_DATE_TABLE
394: , p5_a26 JTF_NUMBER_TABLE
395: , p6_a0 out nocopy JTF_NUMBER_TABLE
396: , p6_a1 out nocopy JTF_NUMBER_TABLE
397: , p6_a2 out nocopy JTF_NUMBER_TABLE
398: , p6_a3 out nocopy JTF_NUMBER_TABLE
391: , p5_a23 JTF_DATE_TABLE
392: , p5_a24 JTF_NUMBER_TABLE
393: , p5_a25 JTF_DATE_TABLE
394: , p5_a26 JTF_NUMBER_TABLE
395: , p6_a0 out nocopy JTF_NUMBER_TABLE
396: , p6_a1 out nocopy JTF_NUMBER_TABLE
397: , p6_a2 out nocopy JTF_NUMBER_TABLE
398: , p6_a3 out nocopy JTF_NUMBER_TABLE
399: , p6_a4 out nocopy JTF_NUMBER_TABLE
392: , p5_a24 JTF_NUMBER_TABLE
393: , p5_a25 JTF_DATE_TABLE
394: , p5_a26 JTF_NUMBER_TABLE
395: , p6_a0 out nocopy JTF_NUMBER_TABLE
396: , p6_a1 out nocopy JTF_NUMBER_TABLE
397: , p6_a2 out nocopy JTF_NUMBER_TABLE
398: , p6_a3 out nocopy JTF_NUMBER_TABLE
399: , p6_a4 out nocopy JTF_NUMBER_TABLE
400: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
393: , p5_a25 JTF_DATE_TABLE
394: , p5_a26 JTF_NUMBER_TABLE
395: , p6_a0 out nocopy JTF_NUMBER_TABLE
396: , p6_a1 out nocopy JTF_NUMBER_TABLE
397: , p6_a2 out nocopy JTF_NUMBER_TABLE
398: , p6_a3 out nocopy JTF_NUMBER_TABLE
399: , p6_a4 out nocopy JTF_NUMBER_TABLE
400: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
401: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
394: , p5_a26 JTF_NUMBER_TABLE
395: , p6_a0 out nocopy JTF_NUMBER_TABLE
396: , p6_a1 out nocopy JTF_NUMBER_TABLE
397: , p6_a2 out nocopy JTF_NUMBER_TABLE
398: , p6_a3 out nocopy JTF_NUMBER_TABLE
399: , p6_a4 out nocopy JTF_NUMBER_TABLE
400: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
401: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
402: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
395: , p6_a0 out nocopy JTF_NUMBER_TABLE
396: , p6_a1 out nocopy JTF_NUMBER_TABLE
397: , p6_a2 out nocopy JTF_NUMBER_TABLE
398: , p6_a3 out nocopy JTF_NUMBER_TABLE
399: , p6_a4 out nocopy JTF_NUMBER_TABLE
400: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
401: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
402: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
403: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
413: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
414: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
415: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
416: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
417: , p6_a22 out nocopy JTF_NUMBER_TABLE
418: , p6_a23 out nocopy JTF_DATE_TABLE
419: , p6_a24 out nocopy JTF_NUMBER_TABLE
420: , p6_a25 out nocopy JTF_DATE_TABLE
421: , p6_a26 out nocopy JTF_NUMBER_TABLE
415: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
416: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
417: , p6_a22 out nocopy JTF_NUMBER_TABLE
418: , p6_a23 out nocopy JTF_DATE_TABLE
419: , p6_a24 out nocopy JTF_NUMBER_TABLE
420: , p6_a25 out nocopy JTF_DATE_TABLE
421: , p6_a26 out nocopy JTF_NUMBER_TABLE
422: );
423: procedure delete_row(p_api_version NUMBER
417: , p6_a22 out nocopy JTF_NUMBER_TABLE
418: , p6_a23 out nocopy JTF_DATE_TABLE
419: , p6_a24 out nocopy JTF_NUMBER_TABLE
420: , p6_a25 out nocopy JTF_DATE_TABLE
421: , p6_a26 out nocopy JTF_NUMBER_TABLE
422: );
423: procedure delete_row(p_api_version NUMBER
424: , p_init_msg_list VARCHAR2
425: , x_return_status out nocopy VARCHAR2
457: , p_init_msg_list VARCHAR2
458: , x_return_status out nocopy VARCHAR2
459: , x_msg_count out nocopy NUMBER
460: , x_msg_data out nocopy VARCHAR2
461: , p5_a0 JTF_NUMBER_TABLE
462: , p5_a1 JTF_NUMBER_TABLE
463: , p5_a2 JTF_NUMBER_TABLE
464: , p5_a3 JTF_NUMBER_TABLE
465: , p5_a4 JTF_NUMBER_TABLE
458: , x_return_status out nocopy VARCHAR2
459: , x_msg_count out nocopy NUMBER
460: , x_msg_data out nocopy VARCHAR2
461: , p5_a0 JTF_NUMBER_TABLE
462: , p5_a1 JTF_NUMBER_TABLE
463: , p5_a2 JTF_NUMBER_TABLE
464: , p5_a3 JTF_NUMBER_TABLE
465: , p5_a4 JTF_NUMBER_TABLE
466: , p5_a5 JTF_VARCHAR2_TABLE_100
459: , x_msg_count out nocopy NUMBER
460: , x_msg_data out nocopy VARCHAR2
461: , p5_a0 JTF_NUMBER_TABLE
462: , p5_a1 JTF_NUMBER_TABLE
463: , p5_a2 JTF_NUMBER_TABLE
464: , p5_a3 JTF_NUMBER_TABLE
465: , p5_a4 JTF_NUMBER_TABLE
466: , p5_a5 JTF_VARCHAR2_TABLE_100
467: , p5_a6 JTF_VARCHAR2_TABLE_500
460: , x_msg_data out nocopy VARCHAR2
461: , p5_a0 JTF_NUMBER_TABLE
462: , p5_a1 JTF_NUMBER_TABLE
463: , p5_a2 JTF_NUMBER_TABLE
464: , p5_a3 JTF_NUMBER_TABLE
465: , p5_a4 JTF_NUMBER_TABLE
466: , p5_a5 JTF_VARCHAR2_TABLE_100
467: , p5_a6 JTF_VARCHAR2_TABLE_500
468: , p5_a7 JTF_VARCHAR2_TABLE_500
461: , p5_a0 JTF_NUMBER_TABLE
462: , p5_a1 JTF_NUMBER_TABLE
463: , p5_a2 JTF_NUMBER_TABLE
464: , p5_a3 JTF_NUMBER_TABLE
465: , p5_a4 JTF_NUMBER_TABLE
466: , p5_a5 JTF_VARCHAR2_TABLE_100
467: , p5_a6 JTF_VARCHAR2_TABLE_500
468: , p5_a7 JTF_VARCHAR2_TABLE_500
469: , p5_a8 JTF_VARCHAR2_TABLE_500
479: , p5_a18 JTF_VARCHAR2_TABLE_500
480: , p5_a19 JTF_VARCHAR2_TABLE_500
481: , p5_a20 JTF_VARCHAR2_TABLE_500
482: , p5_a21 JTF_VARCHAR2_TABLE_100
483: , p5_a22 JTF_NUMBER_TABLE
484: , p5_a23 JTF_DATE_TABLE
485: , p5_a24 JTF_NUMBER_TABLE
486: , p5_a25 JTF_DATE_TABLE
487: , p5_a26 JTF_NUMBER_TABLE
481: , p5_a20 JTF_VARCHAR2_TABLE_500
482: , p5_a21 JTF_VARCHAR2_TABLE_100
483: , p5_a22 JTF_NUMBER_TABLE
484: , p5_a23 JTF_DATE_TABLE
485: , p5_a24 JTF_NUMBER_TABLE
486: , p5_a25 JTF_DATE_TABLE
487: , p5_a26 JTF_NUMBER_TABLE
488: );
489: procedure validate_row(p_api_version NUMBER
483: , p5_a22 JTF_NUMBER_TABLE
484: , p5_a23 JTF_DATE_TABLE
485: , p5_a24 JTF_NUMBER_TABLE
486: , p5_a25 JTF_DATE_TABLE
487: , p5_a26 JTF_NUMBER_TABLE
488: );
489: procedure validate_row(p_api_version NUMBER
490: , p_init_msg_list VARCHAR2
491: , x_return_status out nocopy VARCHAR2
523: , p_init_msg_list VARCHAR2
524: , x_return_status out nocopy VARCHAR2
525: , x_msg_count out nocopy NUMBER
526: , x_msg_data out nocopy VARCHAR2
527: , p5_a0 JTF_NUMBER_TABLE
528: , p5_a1 JTF_NUMBER_TABLE
529: , p5_a2 JTF_NUMBER_TABLE
530: , p5_a3 JTF_NUMBER_TABLE
531: , p5_a4 JTF_NUMBER_TABLE
524: , x_return_status out nocopy VARCHAR2
525: , x_msg_count out nocopy NUMBER
526: , x_msg_data out nocopy VARCHAR2
527: , p5_a0 JTF_NUMBER_TABLE
528: , p5_a1 JTF_NUMBER_TABLE
529: , p5_a2 JTF_NUMBER_TABLE
530: , p5_a3 JTF_NUMBER_TABLE
531: , p5_a4 JTF_NUMBER_TABLE
532: , p5_a5 JTF_VARCHAR2_TABLE_100
525: , x_msg_count out nocopy NUMBER
526: , x_msg_data out nocopy VARCHAR2
527: , p5_a0 JTF_NUMBER_TABLE
528: , p5_a1 JTF_NUMBER_TABLE
529: , p5_a2 JTF_NUMBER_TABLE
530: , p5_a3 JTF_NUMBER_TABLE
531: , p5_a4 JTF_NUMBER_TABLE
532: , p5_a5 JTF_VARCHAR2_TABLE_100
533: , p5_a6 JTF_VARCHAR2_TABLE_500
526: , x_msg_data out nocopy VARCHAR2
527: , p5_a0 JTF_NUMBER_TABLE
528: , p5_a1 JTF_NUMBER_TABLE
529: , p5_a2 JTF_NUMBER_TABLE
530: , p5_a3 JTF_NUMBER_TABLE
531: , p5_a4 JTF_NUMBER_TABLE
532: , p5_a5 JTF_VARCHAR2_TABLE_100
533: , p5_a6 JTF_VARCHAR2_TABLE_500
534: , p5_a7 JTF_VARCHAR2_TABLE_500
527: , p5_a0 JTF_NUMBER_TABLE
528: , p5_a1 JTF_NUMBER_TABLE
529: , p5_a2 JTF_NUMBER_TABLE
530: , p5_a3 JTF_NUMBER_TABLE
531: , p5_a4 JTF_NUMBER_TABLE
532: , p5_a5 JTF_VARCHAR2_TABLE_100
533: , p5_a6 JTF_VARCHAR2_TABLE_500
534: , p5_a7 JTF_VARCHAR2_TABLE_500
535: , p5_a8 JTF_VARCHAR2_TABLE_500
545: , p5_a18 JTF_VARCHAR2_TABLE_500
546: , p5_a19 JTF_VARCHAR2_TABLE_500
547: , p5_a20 JTF_VARCHAR2_TABLE_500
548: , p5_a21 JTF_VARCHAR2_TABLE_100
549: , p5_a22 JTF_NUMBER_TABLE
550: , p5_a23 JTF_DATE_TABLE
551: , p5_a24 JTF_NUMBER_TABLE
552: , p5_a25 JTF_DATE_TABLE
553: , p5_a26 JTF_NUMBER_TABLE
547: , p5_a20 JTF_VARCHAR2_TABLE_500
548: , p5_a21 JTF_VARCHAR2_TABLE_100
549: , p5_a22 JTF_NUMBER_TABLE
550: , p5_a23 JTF_DATE_TABLE
551: , p5_a24 JTF_NUMBER_TABLE
552: , p5_a25 JTF_DATE_TABLE
553: , p5_a26 JTF_NUMBER_TABLE
554: );
555: end okl_sta_pvt_w;
549: , p5_a22 JTF_NUMBER_TABLE
550: , p5_a23 JTF_DATE_TABLE
551: , p5_a24 JTF_NUMBER_TABLE
552: , p5_a25 JTF_DATE_TABLE
553: , p5_a26 JTF_NUMBER_TABLE
554: );
555: end okl_sta_pvt_w;