1: package okl_slx_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLISLXS.pls 120.1 2005/07/15 07:38:33 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_slx_pvt.slxv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
1: package okl_slx_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLISLXS.pls 120.1 2005/07/15 07:38:33 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_slx_pvt.slxv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
1: package okl_slx_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLISLXS.pls 120.1 2005/07/15 07:38:33 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_slx_pvt.slxv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_500
2: /* $Header: OKLISLXS.pls 120.1 2005/07/15 07:38:33 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_slx_pvt.slxv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_500
10: , a7 JTF_VARCHAR2_TABLE_500
20: , a17 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_NUMBER_TABLE
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p2(t okl_slx_pvt.slxv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p2(t okl_slx_pvt.slxv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p2(t okl_slx_pvt.slxv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_VARCHAR2_TABLE_100
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p2(t okl_slx_pvt.slxv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_VARCHAR2_TABLE_100
35: , a5 out nocopy JTF_VARCHAR2_TABLE_100
28: , a25 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p2(t okl_slx_pvt.slxv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_VARCHAR2_TABLE_100
35: , a5 out nocopy JTF_VARCHAR2_TABLE_100
36: , a6 out nocopy JTF_VARCHAR2_TABLE_500
29: );
30: procedure rosetta_table_copy_out_p2(t okl_slx_pvt.slxv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_VARCHAR2_TABLE_100
35: , a5 out nocopy JTF_VARCHAR2_TABLE_100
36: , a6 out nocopy JTF_VARCHAR2_TABLE_500
37: , a7 out nocopy JTF_VARCHAR2_TABLE_500
47: , a17 out nocopy JTF_VARCHAR2_TABLE_500
48: , a18 out nocopy JTF_VARCHAR2_TABLE_500
49: , a19 out nocopy JTF_VARCHAR2_TABLE_500
50: , a20 out nocopy JTF_VARCHAR2_TABLE_500
51: , a21 out nocopy JTF_NUMBER_TABLE
52: , a22 out nocopy JTF_DATE_TABLE
53: , a23 out nocopy JTF_NUMBER_TABLE
54: , a24 out nocopy JTF_DATE_TABLE
55: , a25 out nocopy JTF_NUMBER_TABLE
49: , a19 out nocopy JTF_VARCHAR2_TABLE_500
50: , a20 out nocopy JTF_VARCHAR2_TABLE_500
51: , a21 out nocopy JTF_NUMBER_TABLE
52: , a22 out nocopy JTF_DATE_TABLE
53: , a23 out nocopy JTF_NUMBER_TABLE
54: , a24 out nocopy JTF_DATE_TABLE
55: , a25 out nocopy JTF_NUMBER_TABLE
56: );
57:
51: , a21 out nocopy JTF_NUMBER_TABLE
52: , a22 out nocopy JTF_DATE_TABLE
53: , a23 out nocopy JTF_NUMBER_TABLE
54: , a24 out nocopy JTF_DATE_TABLE
55: , a25 out nocopy JTF_NUMBER_TABLE
56: );
57:
58: procedure rosetta_table_copy_in_p5(t out nocopy okl_slx_pvt.slx_tbl_type, a0 JTF_NUMBER_TABLE
59: , a1 JTF_NUMBER_TABLE
54: , a24 out nocopy JTF_DATE_TABLE
55: , a25 out nocopy JTF_NUMBER_TABLE
56: );
57:
58: procedure rosetta_table_copy_in_p5(t out nocopy okl_slx_pvt.slx_tbl_type, a0 JTF_NUMBER_TABLE
59: , a1 JTF_NUMBER_TABLE
60: , a2 JTF_NUMBER_TABLE
61: , a3 JTF_NUMBER_TABLE
62: , a4 JTF_VARCHAR2_TABLE_100
55: , a25 out nocopy JTF_NUMBER_TABLE
56: );
57:
58: procedure rosetta_table_copy_in_p5(t out nocopy okl_slx_pvt.slx_tbl_type, a0 JTF_NUMBER_TABLE
59: , a1 JTF_NUMBER_TABLE
60: , a2 JTF_NUMBER_TABLE
61: , a3 JTF_NUMBER_TABLE
62: , a4 JTF_VARCHAR2_TABLE_100
63: , a5 JTF_VARCHAR2_TABLE_100
56: );
57:
58: procedure rosetta_table_copy_in_p5(t out nocopy okl_slx_pvt.slx_tbl_type, a0 JTF_NUMBER_TABLE
59: , a1 JTF_NUMBER_TABLE
60: , a2 JTF_NUMBER_TABLE
61: , a3 JTF_NUMBER_TABLE
62: , a4 JTF_VARCHAR2_TABLE_100
63: , a5 JTF_VARCHAR2_TABLE_100
64: , a6 JTF_VARCHAR2_TABLE_500
57:
58: procedure rosetta_table_copy_in_p5(t out nocopy okl_slx_pvt.slx_tbl_type, a0 JTF_NUMBER_TABLE
59: , a1 JTF_NUMBER_TABLE
60: , a2 JTF_NUMBER_TABLE
61: , a3 JTF_NUMBER_TABLE
62: , a4 JTF_VARCHAR2_TABLE_100
63: , a5 JTF_VARCHAR2_TABLE_100
64: , a6 JTF_VARCHAR2_TABLE_500
65: , a7 JTF_VARCHAR2_TABLE_500
75: , a17 JTF_VARCHAR2_TABLE_500
76: , a18 JTF_VARCHAR2_TABLE_500
77: , a19 JTF_VARCHAR2_TABLE_500
78: , a20 JTF_VARCHAR2_TABLE_500
79: , a21 JTF_NUMBER_TABLE
80: , a22 JTF_DATE_TABLE
81: , a23 JTF_NUMBER_TABLE
82: , a24 JTF_DATE_TABLE
83: , a25 JTF_NUMBER_TABLE
77: , a19 JTF_VARCHAR2_TABLE_500
78: , a20 JTF_VARCHAR2_TABLE_500
79: , a21 JTF_NUMBER_TABLE
80: , a22 JTF_DATE_TABLE
81: , a23 JTF_NUMBER_TABLE
82: , a24 JTF_DATE_TABLE
83: , a25 JTF_NUMBER_TABLE
84: );
85: procedure rosetta_table_copy_out_p5(t okl_slx_pvt.slx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
79: , a21 JTF_NUMBER_TABLE
80: , a22 JTF_DATE_TABLE
81: , a23 JTF_NUMBER_TABLE
82: , a24 JTF_DATE_TABLE
83: , a25 JTF_NUMBER_TABLE
84: );
85: procedure rosetta_table_copy_out_p5(t okl_slx_pvt.slx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
86: , a1 out nocopy JTF_NUMBER_TABLE
87: , a2 out nocopy JTF_NUMBER_TABLE
81: , a23 JTF_NUMBER_TABLE
82: , a24 JTF_DATE_TABLE
83: , a25 JTF_NUMBER_TABLE
84: );
85: procedure rosetta_table_copy_out_p5(t okl_slx_pvt.slx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
86: , a1 out nocopy JTF_NUMBER_TABLE
87: , a2 out nocopy JTF_NUMBER_TABLE
88: , a3 out nocopy JTF_NUMBER_TABLE
89: , a4 out nocopy JTF_VARCHAR2_TABLE_100
82: , a24 JTF_DATE_TABLE
83: , a25 JTF_NUMBER_TABLE
84: );
85: procedure rosetta_table_copy_out_p5(t okl_slx_pvt.slx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
86: , a1 out nocopy JTF_NUMBER_TABLE
87: , a2 out nocopy JTF_NUMBER_TABLE
88: , a3 out nocopy JTF_NUMBER_TABLE
89: , a4 out nocopy JTF_VARCHAR2_TABLE_100
90: , a5 out nocopy JTF_VARCHAR2_TABLE_100
83: , a25 JTF_NUMBER_TABLE
84: );
85: procedure rosetta_table_copy_out_p5(t okl_slx_pvt.slx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
86: , a1 out nocopy JTF_NUMBER_TABLE
87: , a2 out nocopy JTF_NUMBER_TABLE
88: , a3 out nocopy JTF_NUMBER_TABLE
89: , a4 out nocopy JTF_VARCHAR2_TABLE_100
90: , a5 out nocopy JTF_VARCHAR2_TABLE_100
91: , a6 out nocopy JTF_VARCHAR2_TABLE_500
84: );
85: procedure rosetta_table_copy_out_p5(t okl_slx_pvt.slx_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
86: , a1 out nocopy JTF_NUMBER_TABLE
87: , a2 out nocopy JTF_NUMBER_TABLE
88: , a3 out nocopy JTF_NUMBER_TABLE
89: , a4 out nocopy JTF_VARCHAR2_TABLE_100
90: , a5 out nocopy JTF_VARCHAR2_TABLE_100
91: , a6 out nocopy JTF_VARCHAR2_TABLE_500
92: , a7 out nocopy JTF_VARCHAR2_TABLE_500
102: , a17 out nocopy JTF_VARCHAR2_TABLE_500
103: , a18 out nocopy JTF_VARCHAR2_TABLE_500
104: , a19 out nocopy JTF_VARCHAR2_TABLE_500
105: , a20 out nocopy JTF_VARCHAR2_TABLE_500
106: , a21 out nocopy JTF_NUMBER_TABLE
107: , a22 out nocopy JTF_DATE_TABLE
108: , a23 out nocopy JTF_NUMBER_TABLE
109: , a24 out nocopy JTF_DATE_TABLE
110: , a25 out nocopy JTF_NUMBER_TABLE
104: , a19 out nocopy JTF_VARCHAR2_TABLE_500
105: , a20 out nocopy JTF_VARCHAR2_TABLE_500
106: , a21 out nocopy JTF_NUMBER_TABLE
107: , a22 out nocopy JTF_DATE_TABLE
108: , a23 out nocopy JTF_NUMBER_TABLE
109: , a24 out nocopy JTF_DATE_TABLE
110: , a25 out nocopy JTF_NUMBER_TABLE
111: );
112:
106: , a21 out nocopy JTF_NUMBER_TABLE
107: , a22 out nocopy JTF_DATE_TABLE
108: , a23 out nocopy JTF_NUMBER_TABLE
109: , a24 out nocopy JTF_DATE_TABLE
110: , a25 out nocopy JTF_NUMBER_TABLE
111: );
112:
113: procedure insert_row(p_api_version NUMBER
114: , p_init_msg_list VARCHAR2
172: , p_init_msg_list VARCHAR2
173: , x_return_status out nocopy VARCHAR2
174: , x_msg_count out nocopy NUMBER
175: , x_msg_data out nocopy VARCHAR2
176: , p5_a0 JTF_NUMBER_TABLE
177: , p5_a1 JTF_NUMBER_TABLE
178: , p5_a2 JTF_NUMBER_TABLE
179: , p5_a3 JTF_NUMBER_TABLE
180: , p5_a4 JTF_VARCHAR2_TABLE_100
173: , x_return_status out nocopy VARCHAR2
174: , x_msg_count out nocopy NUMBER
175: , x_msg_data out nocopy VARCHAR2
176: , p5_a0 JTF_NUMBER_TABLE
177: , p5_a1 JTF_NUMBER_TABLE
178: , p5_a2 JTF_NUMBER_TABLE
179: , p5_a3 JTF_NUMBER_TABLE
180: , p5_a4 JTF_VARCHAR2_TABLE_100
181: , p5_a5 JTF_VARCHAR2_TABLE_100
174: , x_msg_count out nocopy NUMBER
175: , x_msg_data out nocopy VARCHAR2
176: , p5_a0 JTF_NUMBER_TABLE
177: , p5_a1 JTF_NUMBER_TABLE
178: , p5_a2 JTF_NUMBER_TABLE
179: , p5_a3 JTF_NUMBER_TABLE
180: , p5_a4 JTF_VARCHAR2_TABLE_100
181: , p5_a5 JTF_VARCHAR2_TABLE_100
182: , p5_a6 JTF_VARCHAR2_TABLE_500
175: , x_msg_data out nocopy VARCHAR2
176: , p5_a0 JTF_NUMBER_TABLE
177: , p5_a1 JTF_NUMBER_TABLE
178: , p5_a2 JTF_NUMBER_TABLE
179: , p5_a3 JTF_NUMBER_TABLE
180: , p5_a4 JTF_VARCHAR2_TABLE_100
181: , p5_a5 JTF_VARCHAR2_TABLE_100
182: , p5_a6 JTF_VARCHAR2_TABLE_500
183: , p5_a7 JTF_VARCHAR2_TABLE_500
193: , p5_a17 JTF_VARCHAR2_TABLE_500
194: , p5_a18 JTF_VARCHAR2_TABLE_500
195: , p5_a19 JTF_VARCHAR2_TABLE_500
196: , p5_a20 JTF_VARCHAR2_TABLE_500
197: , p5_a21 JTF_NUMBER_TABLE
198: , p5_a22 JTF_DATE_TABLE
199: , p5_a23 JTF_NUMBER_TABLE
200: , p5_a24 JTF_DATE_TABLE
201: , p5_a25 JTF_NUMBER_TABLE
195: , p5_a19 JTF_VARCHAR2_TABLE_500
196: , p5_a20 JTF_VARCHAR2_TABLE_500
197: , p5_a21 JTF_NUMBER_TABLE
198: , p5_a22 JTF_DATE_TABLE
199: , p5_a23 JTF_NUMBER_TABLE
200: , p5_a24 JTF_DATE_TABLE
201: , p5_a25 JTF_NUMBER_TABLE
202: , p6_a0 out nocopy JTF_NUMBER_TABLE
203: , p6_a1 out nocopy JTF_NUMBER_TABLE
197: , p5_a21 JTF_NUMBER_TABLE
198: , p5_a22 JTF_DATE_TABLE
199: , p5_a23 JTF_NUMBER_TABLE
200: , p5_a24 JTF_DATE_TABLE
201: , p5_a25 JTF_NUMBER_TABLE
202: , p6_a0 out nocopy JTF_NUMBER_TABLE
203: , p6_a1 out nocopy JTF_NUMBER_TABLE
204: , p6_a2 out nocopy JTF_NUMBER_TABLE
205: , p6_a3 out nocopy JTF_NUMBER_TABLE
198: , p5_a22 JTF_DATE_TABLE
199: , p5_a23 JTF_NUMBER_TABLE
200: , p5_a24 JTF_DATE_TABLE
201: , p5_a25 JTF_NUMBER_TABLE
202: , p6_a0 out nocopy JTF_NUMBER_TABLE
203: , p6_a1 out nocopy JTF_NUMBER_TABLE
204: , p6_a2 out nocopy JTF_NUMBER_TABLE
205: , p6_a3 out nocopy JTF_NUMBER_TABLE
206: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
199: , p5_a23 JTF_NUMBER_TABLE
200: , p5_a24 JTF_DATE_TABLE
201: , p5_a25 JTF_NUMBER_TABLE
202: , p6_a0 out nocopy JTF_NUMBER_TABLE
203: , p6_a1 out nocopy JTF_NUMBER_TABLE
204: , p6_a2 out nocopy JTF_NUMBER_TABLE
205: , p6_a3 out nocopy JTF_NUMBER_TABLE
206: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
207: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
200: , p5_a24 JTF_DATE_TABLE
201: , p5_a25 JTF_NUMBER_TABLE
202: , p6_a0 out nocopy JTF_NUMBER_TABLE
203: , p6_a1 out nocopy JTF_NUMBER_TABLE
204: , p6_a2 out nocopy JTF_NUMBER_TABLE
205: , p6_a3 out nocopy JTF_NUMBER_TABLE
206: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
207: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
208: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
201: , p5_a25 JTF_NUMBER_TABLE
202: , p6_a0 out nocopy JTF_NUMBER_TABLE
203: , p6_a1 out nocopy JTF_NUMBER_TABLE
204: , p6_a2 out nocopy JTF_NUMBER_TABLE
205: , p6_a3 out nocopy JTF_NUMBER_TABLE
206: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
207: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
208: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
209: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
219: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
220: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
221: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
222: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
223: , p6_a21 out nocopy JTF_NUMBER_TABLE
224: , p6_a22 out nocopy JTF_DATE_TABLE
225: , p6_a23 out nocopy JTF_NUMBER_TABLE
226: , p6_a24 out nocopy JTF_DATE_TABLE
227: , p6_a25 out nocopy JTF_NUMBER_TABLE
221: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
222: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
223: , p6_a21 out nocopy JTF_NUMBER_TABLE
224: , p6_a22 out nocopy JTF_DATE_TABLE
225: , p6_a23 out nocopy JTF_NUMBER_TABLE
226: , p6_a24 out nocopy JTF_DATE_TABLE
227: , p6_a25 out nocopy JTF_NUMBER_TABLE
228: );
229: procedure lock_row(p_api_version NUMBER
223: , p6_a21 out nocopy JTF_NUMBER_TABLE
224: , p6_a22 out nocopy JTF_DATE_TABLE
225: , p6_a23 out nocopy JTF_NUMBER_TABLE
226: , p6_a24 out nocopy JTF_DATE_TABLE
227: , p6_a25 out nocopy JTF_NUMBER_TABLE
228: );
229: procedure lock_row(p_api_version NUMBER
230: , p_init_msg_list VARCHAR2
231: , x_return_status out nocopy VARCHAR2
262: , p_init_msg_list VARCHAR2
263: , x_return_status out nocopy VARCHAR2
264: , x_msg_count out nocopy NUMBER
265: , x_msg_data out nocopy VARCHAR2
266: , p5_a0 JTF_NUMBER_TABLE
267: , p5_a1 JTF_NUMBER_TABLE
268: , p5_a2 JTF_NUMBER_TABLE
269: , p5_a3 JTF_NUMBER_TABLE
270: , p5_a4 JTF_VARCHAR2_TABLE_100
263: , x_return_status out nocopy VARCHAR2
264: , x_msg_count out nocopy NUMBER
265: , x_msg_data out nocopy VARCHAR2
266: , p5_a0 JTF_NUMBER_TABLE
267: , p5_a1 JTF_NUMBER_TABLE
268: , p5_a2 JTF_NUMBER_TABLE
269: , p5_a3 JTF_NUMBER_TABLE
270: , p5_a4 JTF_VARCHAR2_TABLE_100
271: , p5_a5 JTF_VARCHAR2_TABLE_100
264: , x_msg_count out nocopy NUMBER
265: , x_msg_data out nocopy VARCHAR2
266: , p5_a0 JTF_NUMBER_TABLE
267: , p5_a1 JTF_NUMBER_TABLE
268: , p5_a2 JTF_NUMBER_TABLE
269: , p5_a3 JTF_NUMBER_TABLE
270: , p5_a4 JTF_VARCHAR2_TABLE_100
271: , p5_a5 JTF_VARCHAR2_TABLE_100
272: , p5_a6 JTF_VARCHAR2_TABLE_500
265: , x_msg_data out nocopy VARCHAR2
266: , p5_a0 JTF_NUMBER_TABLE
267: , p5_a1 JTF_NUMBER_TABLE
268: , p5_a2 JTF_NUMBER_TABLE
269: , p5_a3 JTF_NUMBER_TABLE
270: , p5_a4 JTF_VARCHAR2_TABLE_100
271: , p5_a5 JTF_VARCHAR2_TABLE_100
272: , p5_a6 JTF_VARCHAR2_TABLE_500
273: , p5_a7 JTF_VARCHAR2_TABLE_500
283: , p5_a17 JTF_VARCHAR2_TABLE_500
284: , p5_a18 JTF_VARCHAR2_TABLE_500
285: , p5_a19 JTF_VARCHAR2_TABLE_500
286: , p5_a20 JTF_VARCHAR2_TABLE_500
287: , p5_a21 JTF_NUMBER_TABLE
288: , p5_a22 JTF_DATE_TABLE
289: , p5_a23 JTF_NUMBER_TABLE
290: , p5_a24 JTF_DATE_TABLE
291: , p5_a25 JTF_NUMBER_TABLE
285: , p5_a19 JTF_VARCHAR2_TABLE_500
286: , p5_a20 JTF_VARCHAR2_TABLE_500
287: , p5_a21 JTF_NUMBER_TABLE
288: , p5_a22 JTF_DATE_TABLE
289: , p5_a23 JTF_NUMBER_TABLE
290: , p5_a24 JTF_DATE_TABLE
291: , p5_a25 JTF_NUMBER_TABLE
292: );
293: procedure update_row(p_api_version NUMBER
287: , p5_a21 JTF_NUMBER_TABLE
288: , p5_a22 JTF_DATE_TABLE
289: , p5_a23 JTF_NUMBER_TABLE
290: , p5_a24 JTF_DATE_TABLE
291: , p5_a25 JTF_NUMBER_TABLE
292: );
293: procedure update_row(p_api_version NUMBER
294: , p_init_msg_list VARCHAR2
295: , x_return_status out nocopy VARCHAR2
352: , p_init_msg_list VARCHAR2
353: , x_return_status out nocopy VARCHAR2
354: , x_msg_count out nocopy NUMBER
355: , x_msg_data out nocopy VARCHAR2
356: , p5_a0 JTF_NUMBER_TABLE
357: , p5_a1 JTF_NUMBER_TABLE
358: , p5_a2 JTF_NUMBER_TABLE
359: , p5_a3 JTF_NUMBER_TABLE
360: , p5_a4 JTF_VARCHAR2_TABLE_100
353: , x_return_status out nocopy VARCHAR2
354: , x_msg_count out nocopy NUMBER
355: , x_msg_data out nocopy VARCHAR2
356: , p5_a0 JTF_NUMBER_TABLE
357: , p5_a1 JTF_NUMBER_TABLE
358: , p5_a2 JTF_NUMBER_TABLE
359: , p5_a3 JTF_NUMBER_TABLE
360: , p5_a4 JTF_VARCHAR2_TABLE_100
361: , p5_a5 JTF_VARCHAR2_TABLE_100
354: , x_msg_count out nocopy NUMBER
355: , x_msg_data out nocopy VARCHAR2
356: , p5_a0 JTF_NUMBER_TABLE
357: , p5_a1 JTF_NUMBER_TABLE
358: , p5_a2 JTF_NUMBER_TABLE
359: , p5_a3 JTF_NUMBER_TABLE
360: , p5_a4 JTF_VARCHAR2_TABLE_100
361: , p5_a5 JTF_VARCHAR2_TABLE_100
362: , p5_a6 JTF_VARCHAR2_TABLE_500
355: , x_msg_data out nocopy VARCHAR2
356: , p5_a0 JTF_NUMBER_TABLE
357: , p5_a1 JTF_NUMBER_TABLE
358: , p5_a2 JTF_NUMBER_TABLE
359: , p5_a3 JTF_NUMBER_TABLE
360: , p5_a4 JTF_VARCHAR2_TABLE_100
361: , p5_a5 JTF_VARCHAR2_TABLE_100
362: , p5_a6 JTF_VARCHAR2_TABLE_500
363: , p5_a7 JTF_VARCHAR2_TABLE_500
373: , p5_a17 JTF_VARCHAR2_TABLE_500
374: , p5_a18 JTF_VARCHAR2_TABLE_500
375: , p5_a19 JTF_VARCHAR2_TABLE_500
376: , p5_a20 JTF_VARCHAR2_TABLE_500
377: , p5_a21 JTF_NUMBER_TABLE
378: , p5_a22 JTF_DATE_TABLE
379: , p5_a23 JTF_NUMBER_TABLE
380: , p5_a24 JTF_DATE_TABLE
381: , p5_a25 JTF_NUMBER_TABLE
375: , p5_a19 JTF_VARCHAR2_TABLE_500
376: , p5_a20 JTF_VARCHAR2_TABLE_500
377: , p5_a21 JTF_NUMBER_TABLE
378: , p5_a22 JTF_DATE_TABLE
379: , p5_a23 JTF_NUMBER_TABLE
380: , p5_a24 JTF_DATE_TABLE
381: , p5_a25 JTF_NUMBER_TABLE
382: , p6_a0 out nocopy JTF_NUMBER_TABLE
383: , p6_a1 out nocopy JTF_NUMBER_TABLE
377: , p5_a21 JTF_NUMBER_TABLE
378: , p5_a22 JTF_DATE_TABLE
379: , p5_a23 JTF_NUMBER_TABLE
380: , p5_a24 JTF_DATE_TABLE
381: , p5_a25 JTF_NUMBER_TABLE
382: , p6_a0 out nocopy JTF_NUMBER_TABLE
383: , p6_a1 out nocopy JTF_NUMBER_TABLE
384: , p6_a2 out nocopy JTF_NUMBER_TABLE
385: , p6_a3 out nocopy JTF_NUMBER_TABLE
378: , p5_a22 JTF_DATE_TABLE
379: , p5_a23 JTF_NUMBER_TABLE
380: , p5_a24 JTF_DATE_TABLE
381: , p5_a25 JTF_NUMBER_TABLE
382: , p6_a0 out nocopy JTF_NUMBER_TABLE
383: , p6_a1 out nocopy JTF_NUMBER_TABLE
384: , p6_a2 out nocopy JTF_NUMBER_TABLE
385: , p6_a3 out nocopy JTF_NUMBER_TABLE
386: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
379: , p5_a23 JTF_NUMBER_TABLE
380: , p5_a24 JTF_DATE_TABLE
381: , p5_a25 JTF_NUMBER_TABLE
382: , p6_a0 out nocopy JTF_NUMBER_TABLE
383: , p6_a1 out nocopy JTF_NUMBER_TABLE
384: , p6_a2 out nocopy JTF_NUMBER_TABLE
385: , p6_a3 out nocopy JTF_NUMBER_TABLE
386: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
387: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
380: , p5_a24 JTF_DATE_TABLE
381: , p5_a25 JTF_NUMBER_TABLE
382: , p6_a0 out nocopy JTF_NUMBER_TABLE
383: , p6_a1 out nocopy JTF_NUMBER_TABLE
384: , p6_a2 out nocopy JTF_NUMBER_TABLE
385: , p6_a3 out nocopy JTF_NUMBER_TABLE
386: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
387: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
388: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
381: , p5_a25 JTF_NUMBER_TABLE
382: , p6_a0 out nocopy JTF_NUMBER_TABLE
383: , p6_a1 out nocopy JTF_NUMBER_TABLE
384: , p6_a2 out nocopy JTF_NUMBER_TABLE
385: , p6_a3 out nocopy JTF_NUMBER_TABLE
386: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
387: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
388: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_500
389: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_500
399: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_500
400: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
401: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
402: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
403: , p6_a21 out nocopy JTF_NUMBER_TABLE
404: , p6_a22 out nocopy JTF_DATE_TABLE
405: , p6_a23 out nocopy JTF_NUMBER_TABLE
406: , p6_a24 out nocopy JTF_DATE_TABLE
407: , p6_a25 out nocopy JTF_NUMBER_TABLE
401: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
402: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
403: , p6_a21 out nocopy JTF_NUMBER_TABLE
404: , p6_a22 out nocopy JTF_DATE_TABLE
405: , p6_a23 out nocopy JTF_NUMBER_TABLE
406: , p6_a24 out nocopy JTF_DATE_TABLE
407: , p6_a25 out nocopy JTF_NUMBER_TABLE
408: );
409: procedure delete_row(p_api_version NUMBER
403: , p6_a21 out nocopy JTF_NUMBER_TABLE
404: , p6_a22 out nocopy JTF_DATE_TABLE
405: , p6_a23 out nocopy JTF_NUMBER_TABLE
406: , p6_a24 out nocopy JTF_DATE_TABLE
407: , p6_a25 out nocopy JTF_NUMBER_TABLE
408: );
409: procedure delete_row(p_api_version NUMBER
410: , p_init_msg_list VARCHAR2
411: , x_return_status out nocopy VARCHAR2
442: , p_init_msg_list VARCHAR2
443: , x_return_status out nocopy VARCHAR2
444: , x_msg_count out nocopy NUMBER
445: , x_msg_data out nocopy VARCHAR2
446: , p5_a0 JTF_NUMBER_TABLE
447: , p5_a1 JTF_NUMBER_TABLE
448: , p5_a2 JTF_NUMBER_TABLE
449: , p5_a3 JTF_NUMBER_TABLE
450: , p5_a4 JTF_VARCHAR2_TABLE_100
443: , x_return_status out nocopy VARCHAR2
444: , x_msg_count out nocopy NUMBER
445: , x_msg_data out nocopy VARCHAR2
446: , p5_a0 JTF_NUMBER_TABLE
447: , p5_a1 JTF_NUMBER_TABLE
448: , p5_a2 JTF_NUMBER_TABLE
449: , p5_a3 JTF_NUMBER_TABLE
450: , p5_a4 JTF_VARCHAR2_TABLE_100
451: , p5_a5 JTF_VARCHAR2_TABLE_100
444: , x_msg_count out nocopy NUMBER
445: , x_msg_data out nocopy VARCHAR2
446: , p5_a0 JTF_NUMBER_TABLE
447: , p5_a1 JTF_NUMBER_TABLE
448: , p5_a2 JTF_NUMBER_TABLE
449: , p5_a3 JTF_NUMBER_TABLE
450: , p5_a4 JTF_VARCHAR2_TABLE_100
451: , p5_a5 JTF_VARCHAR2_TABLE_100
452: , p5_a6 JTF_VARCHAR2_TABLE_500
445: , x_msg_data out nocopy VARCHAR2
446: , p5_a0 JTF_NUMBER_TABLE
447: , p5_a1 JTF_NUMBER_TABLE
448: , p5_a2 JTF_NUMBER_TABLE
449: , p5_a3 JTF_NUMBER_TABLE
450: , p5_a4 JTF_VARCHAR2_TABLE_100
451: , p5_a5 JTF_VARCHAR2_TABLE_100
452: , p5_a6 JTF_VARCHAR2_TABLE_500
453: , p5_a7 JTF_VARCHAR2_TABLE_500
463: , p5_a17 JTF_VARCHAR2_TABLE_500
464: , p5_a18 JTF_VARCHAR2_TABLE_500
465: , p5_a19 JTF_VARCHAR2_TABLE_500
466: , p5_a20 JTF_VARCHAR2_TABLE_500
467: , p5_a21 JTF_NUMBER_TABLE
468: , p5_a22 JTF_DATE_TABLE
469: , p5_a23 JTF_NUMBER_TABLE
470: , p5_a24 JTF_DATE_TABLE
471: , p5_a25 JTF_NUMBER_TABLE
465: , p5_a19 JTF_VARCHAR2_TABLE_500
466: , p5_a20 JTF_VARCHAR2_TABLE_500
467: , p5_a21 JTF_NUMBER_TABLE
468: , p5_a22 JTF_DATE_TABLE
469: , p5_a23 JTF_NUMBER_TABLE
470: , p5_a24 JTF_DATE_TABLE
471: , p5_a25 JTF_NUMBER_TABLE
472: );
473: procedure validate_row(p_api_version NUMBER
467: , p5_a21 JTF_NUMBER_TABLE
468: , p5_a22 JTF_DATE_TABLE
469: , p5_a23 JTF_NUMBER_TABLE
470: , p5_a24 JTF_DATE_TABLE
471: , p5_a25 JTF_NUMBER_TABLE
472: );
473: procedure validate_row(p_api_version NUMBER
474: , p_init_msg_list VARCHAR2
475: , x_return_status out nocopy VARCHAR2
506: , p_init_msg_list VARCHAR2
507: , x_return_status out nocopy VARCHAR2
508: , x_msg_count out nocopy NUMBER
509: , x_msg_data out nocopy VARCHAR2
510: , p5_a0 JTF_NUMBER_TABLE
511: , p5_a1 JTF_NUMBER_TABLE
512: , p5_a2 JTF_NUMBER_TABLE
513: , p5_a3 JTF_NUMBER_TABLE
514: , p5_a4 JTF_VARCHAR2_TABLE_100
507: , x_return_status out nocopy VARCHAR2
508: , x_msg_count out nocopy NUMBER
509: , x_msg_data out nocopy VARCHAR2
510: , p5_a0 JTF_NUMBER_TABLE
511: , p5_a1 JTF_NUMBER_TABLE
512: , p5_a2 JTF_NUMBER_TABLE
513: , p5_a3 JTF_NUMBER_TABLE
514: , p5_a4 JTF_VARCHAR2_TABLE_100
515: , p5_a5 JTF_VARCHAR2_TABLE_100
508: , x_msg_count out nocopy NUMBER
509: , x_msg_data out nocopy VARCHAR2
510: , p5_a0 JTF_NUMBER_TABLE
511: , p5_a1 JTF_NUMBER_TABLE
512: , p5_a2 JTF_NUMBER_TABLE
513: , p5_a3 JTF_NUMBER_TABLE
514: , p5_a4 JTF_VARCHAR2_TABLE_100
515: , p5_a5 JTF_VARCHAR2_TABLE_100
516: , p5_a6 JTF_VARCHAR2_TABLE_500
509: , x_msg_data out nocopy VARCHAR2
510: , p5_a0 JTF_NUMBER_TABLE
511: , p5_a1 JTF_NUMBER_TABLE
512: , p5_a2 JTF_NUMBER_TABLE
513: , p5_a3 JTF_NUMBER_TABLE
514: , p5_a4 JTF_VARCHAR2_TABLE_100
515: , p5_a5 JTF_VARCHAR2_TABLE_100
516: , p5_a6 JTF_VARCHAR2_TABLE_500
517: , p5_a7 JTF_VARCHAR2_TABLE_500
527: , p5_a17 JTF_VARCHAR2_TABLE_500
528: , p5_a18 JTF_VARCHAR2_TABLE_500
529: , p5_a19 JTF_VARCHAR2_TABLE_500
530: , p5_a20 JTF_VARCHAR2_TABLE_500
531: , p5_a21 JTF_NUMBER_TABLE
532: , p5_a22 JTF_DATE_TABLE
533: , p5_a23 JTF_NUMBER_TABLE
534: , p5_a24 JTF_DATE_TABLE
535: , p5_a25 JTF_NUMBER_TABLE
529: , p5_a19 JTF_VARCHAR2_TABLE_500
530: , p5_a20 JTF_VARCHAR2_TABLE_500
531: , p5_a21 JTF_NUMBER_TABLE
532: , p5_a22 JTF_DATE_TABLE
533: , p5_a23 JTF_NUMBER_TABLE
534: , p5_a24 JTF_DATE_TABLE
535: , p5_a25 JTF_NUMBER_TABLE
536: );
537: end okl_slx_pvt_w;
531: , p5_a21 JTF_NUMBER_TABLE
532: , p5_a22 JTF_DATE_TABLE
533: , p5_a23 JTF_NUMBER_TABLE
534: , p5_a24 JTF_DATE_TABLE
535: , p5_a25 JTF_NUMBER_TABLE
536: );
537: end okl_slx_pvt_w;