1: package okl_vrr_pvt_w as
2: /* $Header: OKLIVRRS.pls 120.0 2005/08/03 07:54:05 sjalasut noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vrr_pvt.vrrv_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_VARCHAR2_TABLE_400
1: package okl_vrr_pvt_w as
2: /* $Header: OKLIVRRS.pls 120.0 2005/08/03 07:54:05 sjalasut noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vrr_pvt.vrrv_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_VARCHAR2_TABLE_400
8: , a5 JTF_VARCHAR2_TABLE_2000
1: package okl_vrr_pvt_w as
2: /* $Header: OKLIVRRS.pls 120.0 2005/08/03 07:54:05 sjalasut noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_vrr_pvt.vrrv_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_VARCHAR2_TABLE_400
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_VARCHAR2_TABLE_100
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_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
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_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_DATE_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_NUMBER_TABLE
26: , a23 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
25: , a22 JTF_NUMBER_TABLE
26: , a23 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: , a29 JTF_DATE_TABLE
33: , a30 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: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_vrr_pvt.vrrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_DATE_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_vrr_pvt.vrrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_NUMBER_TABLE
37: , a2 out nocopy JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_vrr_pvt.vrrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_NUMBER_TABLE
37: , a2 out nocopy JTF_NUMBER_TABLE
38: , a3 out nocopy JTF_VARCHAR2_TABLE_100
39: , a4 out nocopy JTF_VARCHAR2_TABLE_400
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_vrr_pvt.vrrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_NUMBER_TABLE
37: , a2 out nocopy JTF_NUMBER_TABLE
38: , a3 out nocopy JTF_VARCHAR2_TABLE_100
39: , a4 out nocopy JTF_VARCHAR2_TABLE_400
40: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
33: , a30 JTF_NUMBER_TABLE
34: );
35: procedure rosetta_table_copy_out_p2(t okl_vrr_pvt.vrrv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
36: , a1 out nocopy JTF_NUMBER_TABLE
37: , a2 out nocopy JTF_NUMBER_TABLE
38: , a3 out nocopy JTF_VARCHAR2_TABLE_100
39: , a4 out nocopy JTF_VARCHAR2_TABLE_400
40: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
41: , a6 out nocopy JTF_VARCHAR2_TABLE_100
53: , a18 out nocopy JTF_VARCHAR2_TABLE_500
54: , a19 out nocopy JTF_VARCHAR2_TABLE_500
55: , a20 out nocopy JTF_VARCHAR2_TABLE_500
56: , a21 out nocopy JTF_VARCHAR2_TABLE_500
57: , a22 out nocopy JTF_NUMBER_TABLE
58: , a23 out nocopy JTF_NUMBER_TABLE
59: , a24 out nocopy JTF_NUMBER_TABLE
60: , a25 out nocopy JTF_DATE_TABLE
61: , a26 out nocopy JTF_NUMBER_TABLE
54: , a19 out nocopy JTF_VARCHAR2_TABLE_500
55: , a20 out nocopy JTF_VARCHAR2_TABLE_500
56: , a21 out nocopy JTF_VARCHAR2_TABLE_500
57: , a22 out nocopy JTF_NUMBER_TABLE
58: , a23 out nocopy JTF_NUMBER_TABLE
59: , a24 out nocopy JTF_NUMBER_TABLE
60: , a25 out nocopy JTF_DATE_TABLE
61: , a26 out nocopy JTF_NUMBER_TABLE
62: , a27 out nocopy JTF_DATE_TABLE
55: , a20 out nocopy JTF_VARCHAR2_TABLE_500
56: , a21 out nocopy JTF_VARCHAR2_TABLE_500
57: , a22 out nocopy JTF_NUMBER_TABLE
58: , a23 out nocopy JTF_NUMBER_TABLE
59: , a24 out nocopy JTF_NUMBER_TABLE
60: , a25 out nocopy JTF_DATE_TABLE
61: , a26 out nocopy JTF_NUMBER_TABLE
62: , a27 out nocopy JTF_DATE_TABLE
63: , a28 out nocopy JTF_NUMBER_TABLE
57: , a22 out nocopy JTF_NUMBER_TABLE
58: , a23 out nocopy JTF_NUMBER_TABLE
59: , a24 out nocopy JTF_NUMBER_TABLE
60: , a25 out nocopy JTF_DATE_TABLE
61: , a26 out nocopy JTF_NUMBER_TABLE
62: , a27 out nocopy JTF_DATE_TABLE
63: , a28 out nocopy JTF_NUMBER_TABLE
64: , a29 out nocopy JTF_DATE_TABLE
65: , a30 out nocopy JTF_NUMBER_TABLE
59: , a24 out nocopy JTF_NUMBER_TABLE
60: , a25 out nocopy JTF_DATE_TABLE
61: , a26 out nocopy JTF_NUMBER_TABLE
62: , a27 out nocopy JTF_DATE_TABLE
63: , a28 out nocopy JTF_NUMBER_TABLE
64: , a29 out nocopy JTF_DATE_TABLE
65: , a30 out nocopy JTF_NUMBER_TABLE
66: );
67:
61: , a26 out nocopy JTF_NUMBER_TABLE
62: , a27 out nocopy JTF_DATE_TABLE
63: , a28 out nocopy JTF_NUMBER_TABLE
64: , a29 out nocopy JTF_DATE_TABLE
65: , a30 out nocopy JTF_NUMBER_TABLE
66: );
67:
68: procedure rosetta_table_copy_in_p5(t out nocopy okl_vrr_pvt.vrr_tbl_type, a0 JTF_NUMBER_TABLE
69: , a1 JTF_NUMBER_TABLE
64: , a29 out nocopy JTF_DATE_TABLE
65: , a30 out nocopy JTF_NUMBER_TABLE
66: );
67:
68: procedure rosetta_table_copy_in_p5(t out nocopy okl_vrr_pvt.vrr_tbl_type, a0 JTF_NUMBER_TABLE
69: , a1 JTF_NUMBER_TABLE
70: , a2 JTF_NUMBER_TABLE
71: , a3 JTF_VARCHAR2_TABLE_100
72: , a4 JTF_VARCHAR2_TABLE_400
65: , a30 out nocopy JTF_NUMBER_TABLE
66: );
67:
68: procedure rosetta_table_copy_in_p5(t out nocopy okl_vrr_pvt.vrr_tbl_type, a0 JTF_NUMBER_TABLE
69: , a1 JTF_NUMBER_TABLE
70: , a2 JTF_NUMBER_TABLE
71: , a3 JTF_VARCHAR2_TABLE_100
72: , a4 JTF_VARCHAR2_TABLE_400
73: , a5 JTF_VARCHAR2_TABLE_2000
66: );
67:
68: procedure rosetta_table_copy_in_p5(t out nocopy okl_vrr_pvt.vrr_tbl_type, a0 JTF_NUMBER_TABLE
69: , a1 JTF_NUMBER_TABLE
70: , a2 JTF_NUMBER_TABLE
71: , a3 JTF_VARCHAR2_TABLE_100
72: , a4 JTF_VARCHAR2_TABLE_400
73: , a5 JTF_VARCHAR2_TABLE_2000
74: , a6 JTF_VARCHAR2_TABLE_100
86: , a18 JTF_VARCHAR2_TABLE_500
87: , a19 JTF_VARCHAR2_TABLE_500
88: , a20 JTF_VARCHAR2_TABLE_500
89: , a21 JTF_VARCHAR2_TABLE_500
90: , a22 JTF_NUMBER_TABLE
91: , a23 JTF_NUMBER_TABLE
92: , a24 JTF_NUMBER_TABLE
93: , a25 JTF_DATE_TABLE
94: , a26 JTF_NUMBER_TABLE
87: , a19 JTF_VARCHAR2_TABLE_500
88: , a20 JTF_VARCHAR2_TABLE_500
89: , a21 JTF_VARCHAR2_TABLE_500
90: , a22 JTF_NUMBER_TABLE
91: , a23 JTF_NUMBER_TABLE
92: , a24 JTF_NUMBER_TABLE
93: , a25 JTF_DATE_TABLE
94: , a26 JTF_NUMBER_TABLE
95: , a27 JTF_DATE_TABLE
88: , a20 JTF_VARCHAR2_TABLE_500
89: , a21 JTF_VARCHAR2_TABLE_500
90: , a22 JTF_NUMBER_TABLE
91: , a23 JTF_NUMBER_TABLE
92: , a24 JTF_NUMBER_TABLE
93: , a25 JTF_DATE_TABLE
94: , a26 JTF_NUMBER_TABLE
95: , a27 JTF_DATE_TABLE
96: , a28 JTF_NUMBER_TABLE
90: , a22 JTF_NUMBER_TABLE
91: , a23 JTF_NUMBER_TABLE
92: , a24 JTF_NUMBER_TABLE
93: , a25 JTF_DATE_TABLE
94: , a26 JTF_NUMBER_TABLE
95: , a27 JTF_DATE_TABLE
96: , a28 JTF_NUMBER_TABLE
97: , a29 JTF_DATE_TABLE
98: , a30 JTF_NUMBER_TABLE
92: , a24 JTF_NUMBER_TABLE
93: , a25 JTF_DATE_TABLE
94: , a26 JTF_NUMBER_TABLE
95: , a27 JTF_DATE_TABLE
96: , a28 JTF_NUMBER_TABLE
97: , a29 JTF_DATE_TABLE
98: , a30 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_vrr_pvt.vrr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a26 JTF_NUMBER_TABLE
95: , a27 JTF_DATE_TABLE
96: , a28 JTF_NUMBER_TABLE
97: , a29 JTF_DATE_TABLE
98: , a30 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_vrr_pvt.vrr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_NUMBER_TABLE
102: , a2 out nocopy JTF_NUMBER_TABLE
96: , a28 JTF_NUMBER_TABLE
97: , a29 JTF_DATE_TABLE
98: , a30 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_vrr_pvt.vrr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_NUMBER_TABLE
102: , a2 out nocopy JTF_NUMBER_TABLE
103: , a3 out nocopy JTF_VARCHAR2_TABLE_100
104: , a4 out nocopy JTF_VARCHAR2_TABLE_400
97: , a29 JTF_DATE_TABLE
98: , a30 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_vrr_pvt.vrr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_NUMBER_TABLE
102: , a2 out nocopy JTF_NUMBER_TABLE
103: , a3 out nocopy JTF_VARCHAR2_TABLE_100
104: , a4 out nocopy JTF_VARCHAR2_TABLE_400
105: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
98: , a30 JTF_NUMBER_TABLE
99: );
100: procedure rosetta_table_copy_out_p5(t okl_vrr_pvt.vrr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
101: , a1 out nocopy JTF_NUMBER_TABLE
102: , a2 out nocopy JTF_NUMBER_TABLE
103: , a3 out nocopy JTF_VARCHAR2_TABLE_100
104: , a4 out nocopy JTF_VARCHAR2_TABLE_400
105: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
106: , a6 out nocopy JTF_VARCHAR2_TABLE_100
118: , a18 out nocopy JTF_VARCHAR2_TABLE_500
119: , a19 out nocopy JTF_VARCHAR2_TABLE_500
120: , a20 out nocopy JTF_VARCHAR2_TABLE_500
121: , a21 out nocopy JTF_VARCHAR2_TABLE_500
122: , a22 out nocopy JTF_NUMBER_TABLE
123: , a23 out nocopy JTF_NUMBER_TABLE
124: , a24 out nocopy JTF_NUMBER_TABLE
125: , a25 out nocopy JTF_DATE_TABLE
126: , a26 out nocopy JTF_NUMBER_TABLE
119: , a19 out nocopy JTF_VARCHAR2_TABLE_500
120: , a20 out nocopy JTF_VARCHAR2_TABLE_500
121: , a21 out nocopy JTF_VARCHAR2_TABLE_500
122: , a22 out nocopy JTF_NUMBER_TABLE
123: , a23 out nocopy JTF_NUMBER_TABLE
124: , a24 out nocopy JTF_NUMBER_TABLE
125: , a25 out nocopy JTF_DATE_TABLE
126: , a26 out nocopy JTF_NUMBER_TABLE
127: , a27 out nocopy JTF_DATE_TABLE
120: , a20 out nocopy JTF_VARCHAR2_TABLE_500
121: , a21 out nocopy JTF_VARCHAR2_TABLE_500
122: , a22 out nocopy JTF_NUMBER_TABLE
123: , a23 out nocopy JTF_NUMBER_TABLE
124: , a24 out nocopy JTF_NUMBER_TABLE
125: , a25 out nocopy JTF_DATE_TABLE
126: , a26 out nocopy JTF_NUMBER_TABLE
127: , a27 out nocopy JTF_DATE_TABLE
128: , a28 out nocopy JTF_NUMBER_TABLE
122: , a22 out nocopy JTF_NUMBER_TABLE
123: , a23 out nocopy JTF_NUMBER_TABLE
124: , a24 out nocopy JTF_NUMBER_TABLE
125: , a25 out nocopy JTF_DATE_TABLE
126: , a26 out nocopy JTF_NUMBER_TABLE
127: , a27 out nocopy JTF_DATE_TABLE
128: , a28 out nocopy JTF_NUMBER_TABLE
129: , a29 out nocopy JTF_DATE_TABLE
130: , a30 out nocopy JTF_NUMBER_TABLE
124: , a24 out nocopy JTF_NUMBER_TABLE
125: , a25 out nocopy JTF_DATE_TABLE
126: , a26 out nocopy JTF_NUMBER_TABLE
127: , a27 out nocopy JTF_DATE_TABLE
128: , a28 out nocopy JTF_NUMBER_TABLE
129: , a29 out nocopy JTF_DATE_TABLE
130: , a30 out nocopy JTF_NUMBER_TABLE
131: );
132:
126: , a26 out nocopy JTF_NUMBER_TABLE
127: , a27 out nocopy JTF_DATE_TABLE
128: , a28 out nocopy JTF_NUMBER_TABLE
129: , a29 out nocopy JTF_DATE_TABLE
130: , a30 out nocopy JTF_NUMBER_TABLE
131: );
132:
133: procedure insert_row(p_api_version NUMBER
134: , p_init_msg_list VARCHAR2
202: , p_init_msg_list VARCHAR2
203: , x_return_status out nocopy VARCHAR2
204: , x_msg_count out nocopy NUMBER
205: , x_msg_data out nocopy VARCHAR2
206: , p5_a0 JTF_NUMBER_TABLE
207: , p5_a1 JTF_NUMBER_TABLE
208: , p5_a2 JTF_NUMBER_TABLE
209: , p5_a3 JTF_VARCHAR2_TABLE_100
210: , p5_a4 JTF_VARCHAR2_TABLE_400
203: , x_return_status out nocopy VARCHAR2
204: , x_msg_count out nocopy NUMBER
205: , x_msg_data out nocopy VARCHAR2
206: , p5_a0 JTF_NUMBER_TABLE
207: , p5_a1 JTF_NUMBER_TABLE
208: , p5_a2 JTF_NUMBER_TABLE
209: , p5_a3 JTF_VARCHAR2_TABLE_100
210: , p5_a4 JTF_VARCHAR2_TABLE_400
211: , p5_a5 JTF_VARCHAR2_TABLE_2000
204: , x_msg_count out nocopy NUMBER
205: , x_msg_data out nocopy VARCHAR2
206: , p5_a0 JTF_NUMBER_TABLE
207: , p5_a1 JTF_NUMBER_TABLE
208: , p5_a2 JTF_NUMBER_TABLE
209: , p5_a3 JTF_VARCHAR2_TABLE_100
210: , p5_a4 JTF_VARCHAR2_TABLE_400
211: , p5_a5 JTF_VARCHAR2_TABLE_2000
212: , p5_a6 JTF_VARCHAR2_TABLE_100
224: , p5_a18 JTF_VARCHAR2_TABLE_500
225: , p5_a19 JTF_VARCHAR2_TABLE_500
226: , p5_a20 JTF_VARCHAR2_TABLE_500
227: , p5_a21 JTF_VARCHAR2_TABLE_500
228: , p5_a22 JTF_NUMBER_TABLE
229: , p5_a23 JTF_NUMBER_TABLE
230: , p5_a24 JTF_NUMBER_TABLE
231: , p5_a25 JTF_DATE_TABLE
232: , p5_a26 JTF_NUMBER_TABLE
225: , p5_a19 JTF_VARCHAR2_TABLE_500
226: , p5_a20 JTF_VARCHAR2_TABLE_500
227: , p5_a21 JTF_VARCHAR2_TABLE_500
228: , p5_a22 JTF_NUMBER_TABLE
229: , p5_a23 JTF_NUMBER_TABLE
230: , p5_a24 JTF_NUMBER_TABLE
231: , p5_a25 JTF_DATE_TABLE
232: , p5_a26 JTF_NUMBER_TABLE
233: , p5_a27 JTF_DATE_TABLE
226: , p5_a20 JTF_VARCHAR2_TABLE_500
227: , p5_a21 JTF_VARCHAR2_TABLE_500
228: , p5_a22 JTF_NUMBER_TABLE
229: , p5_a23 JTF_NUMBER_TABLE
230: , p5_a24 JTF_NUMBER_TABLE
231: , p5_a25 JTF_DATE_TABLE
232: , p5_a26 JTF_NUMBER_TABLE
233: , p5_a27 JTF_DATE_TABLE
234: , p5_a28 JTF_NUMBER_TABLE
228: , p5_a22 JTF_NUMBER_TABLE
229: , p5_a23 JTF_NUMBER_TABLE
230: , p5_a24 JTF_NUMBER_TABLE
231: , p5_a25 JTF_DATE_TABLE
232: , p5_a26 JTF_NUMBER_TABLE
233: , p5_a27 JTF_DATE_TABLE
234: , p5_a28 JTF_NUMBER_TABLE
235: , p5_a29 JTF_DATE_TABLE
236: , p5_a30 JTF_NUMBER_TABLE
230: , p5_a24 JTF_NUMBER_TABLE
231: , p5_a25 JTF_DATE_TABLE
232: , p5_a26 JTF_NUMBER_TABLE
233: , p5_a27 JTF_DATE_TABLE
234: , p5_a28 JTF_NUMBER_TABLE
235: , p5_a29 JTF_DATE_TABLE
236: , p5_a30 JTF_NUMBER_TABLE
237: , p6_a0 out nocopy JTF_NUMBER_TABLE
238: , p6_a1 out nocopy JTF_NUMBER_TABLE
232: , p5_a26 JTF_NUMBER_TABLE
233: , p5_a27 JTF_DATE_TABLE
234: , p5_a28 JTF_NUMBER_TABLE
235: , p5_a29 JTF_DATE_TABLE
236: , p5_a30 JTF_NUMBER_TABLE
237: , p6_a0 out nocopy JTF_NUMBER_TABLE
238: , p6_a1 out nocopy JTF_NUMBER_TABLE
239: , p6_a2 out nocopy JTF_NUMBER_TABLE
240: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
233: , p5_a27 JTF_DATE_TABLE
234: , p5_a28 JTF_NUMBER_TABLE
235: , p5_a29 JTF_DATE_TABLE
236: , p5_a30 JTF_NUMBER_TABLE
237: , p6_a0 out nocopy JTF_NUMBER_TABLE
238: , p6_a1 out nocopy JTF_NUMBER_TABLE
239: , p6_a2 out nocopy JTF_NUMBER_TABLE
240: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
234: , p5_a28 JTF_NUMBER_TABLE
235: , p5_a29 JTF_DATE_TABLE
236: , p5_a30 JTF_NUMBER_TABLE
237: , p6_a0 out nocopy JTF_NUMBER_TABLE
238: , p6_a1 out nocopy JTF_NUMBER_TABLE
239: , p6_a2 out nocopy JTF_NUMBER_TABLE
240: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
242: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
235: , p5_a29 JTF_DATE_TABLE
236: , p5_a30 JTF_NUMBER_TABLE
237: , p6_a0 out nocopy JTF_NUMBER_TABLE
238: , p6_a1 out nocopy JTF_NUMBER_TABLE
239: , p6_a2 out nocopy JTF_NUMBER_TABLE
240: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
242: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
243: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
255: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
256: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
257: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
258: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
259: , p6_a22 out nocopy JTF_NUMBER_TABLE
260: , p6_a23 out nocopy JTF_NUMBER_TABLE
261: , p6_a24 out nocopy JTF_NUMBER_TABLE
262: , p6_a25 out nocopy JTF_DATE_TABLE
263: , p6_a26 out nocopy JTF_NUMBER_TABLE
256: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
257: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
258: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
259: , p6_a22 out nocopy JTF_NUMBER_TABLE
260: , p6_a23 out nocopy JTF_NUMBER_TABLE
261: , p6_a24 out nocopy JTF_NUMBER_TABLE
262: , p6_a25 out nocopy JTF_DATE_TABLE
263: , p6_a26 out nocopy JTF_NUMBER_TABLE
264: , p6_a27 out nocopy JTF_DATE_TABLE
257: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
258: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
259: , p6_a22 out nocopy JTF_NUMBER_TABLE
260: , p6_a23 out nocopy JTF_NUMBER_TABLE
261: , p6_a24 out nocopy JTF_NUMBER_TABLE
262: , p6_a25 out nocopy JTF_DATE_TABLE
263: , p6_a26 out nocopy JTF_NUMBER_TABLE
264: , p6_a27 out nocopy JTF_DATE_TABLE
265: , p6_a28 out nocopy JTF_NUMBER_TABLE
259: , p6_a22 out nocopy JTF_NUMBER_TABLE
260: , p6_a23 out nocopy JTF_NUMBER_TABLE
261: , p6_a24 out nocopy JTF_NUMBER_TABLE
262: , p6_a25 out nocopy JTF_DATE_TABLE
263: , p6_a26 out nocopy JTF_NUMBER_TABLE
264: , p6_a27 out nocopy JTF_DATE_TABLE
265: , p6_a28 out nocopy JTF_NUMBER_TABLE
266: , p6_a29 out nocopy JTF_DATE_TABLE
267: , p6_a30 out nocopy JTF_NUMBER_TABLE
261: , p6_a24 out nocopy JTF_NUMBER_TABLE
262: , p6_a25 out nocopy JTF_DATE_TABLE
263: , p6_a26 out nocopy JTF_NUMBER_TABLE
264: , p6_a27 out nocopy JTF_DATE_TABLE
265: , p6_a28 out nocopy JTF_NUMBER_TABLE
266: , p6_a29 out nocopy JTF_DATE_TABLE
267: , p6_a30 out nocopy JTF_NUMBER_TABLE
268: , p7_a0 in out nocopy JTF_NUMBER_TABLE
269: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
263: , p6_a26 out nocopy JTF_NUMBER_TABLE
264: , p6_a27 out nocopy JTF_DATE_TABLE
265: , p6_a28 out nocopy JTF_NUMBER_TABLE
266: , p6_a29 out nocopy JTF_DATE_TABLE
267: , p6_a30 out nocopy JTF_NUMBER_TABLE
268: , p7_a0 in out nocopy JTF_NUMBER_TABLE
269: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
270: , p7_a2 in out nocopy JTF_NUMBER_TABLE
271: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
264: , p6_a27 out nocopy JTF_DATE_TABLE
265: , p6_a28 out nocopy JTF_NUMBER_TABLE
266: , p6_a29 out nocopy JTF_DATE_TABLE
267: , p6_a30 out nocopy JTF_NUMBER_TABLE
268: , p7_a0 in out nocopy JTF_NUMBER_TABLE
269: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
270: , p7_a2 in out nocopy JTF_NUMBER_TABLE
271: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
272: , p7_a4 in out nocopy JTF_NUMBER_TABLE
266: , p6_a29 out nocopy JTF_DATE_TABLE
267: , p6_a30 out nocopy JTF_NUMBER_TABLE
268: , p7_a0 in out nocopy JTF_NUMBER_TABLE
269: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
270: , p7_a2 in out nocopy JTF_NUMBER_TABLE
271: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
272: , p7_a4 in out nocopy JTF_NUMBER_TABLE
273: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
274: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
268: , p7_a0 in out nocopy JTF_NUMBER_TABLE
269: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
270: , p7_a2 in out nocopy JTF_NUMBER_TABLE
271: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
272: , p7_a4 in out nocopy JTF_NUMBER_TABLE
273: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
274: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
275: );
276: procedure insert_row(p_api_version NUMBER
277: , p_init_msg_list VARCHAR2
278: , x_return_status out nocopy VARCHAR2
279: , x_msg_count out nocopy NUMBER
280: , x_msg_data out nocopy VARCHAR2
281: , p5_a0 JTF_NUMBER_TABLE
282: , p5_a1 JTF_NUMBER_TABLE
283: , p5_a2 JTF_NUMBER_TABLE
284: , p5_a3 JTF_VARCHAR2_TABLE_100
285: , p5_a4 JTF_VARCHAR2_TABLE_400
278: , x_return_status out nocopy VARCHAR2
279: , x_msg_count out nocopy NUMBER
280: , x_msg_data out nocopy VARCHAR2
281: , p5_a0 JTF_NUMBER_TABLE
282: , p5_a1 JTF_NUMBER_TABLE
283: , p5_a2 JTF_NUMBER_TABLE
284: , p5_a3 JTF_VARCHAR2_TABLE_100
285: , p5_a4 JTF_VARCHAR2_TABLE_400
286: , p5_a5 JTF_VARCHAR2_TABLE_2000
279: , x_msg_count out nocopy NUMBER
280: , x_msg_data out nocopy VARCHAR2
281: , p5_a0 JTF_NUMBER_TABLE
282: , p5_a1 JTF_NUMBER_TABLE
283: , p5_a2 JTF_NUMBER_TABLE
284: , p5_a3 JTF_VARCHAR2_TABLE_100
285: , p5_a4 JTF_VARCHAR2_TABLE_400
286: , p5_a5 JTF_VARCHAR2_TABLE_2000
287: , p5_a6 JTF_VARCHAR2_TABLE_100
299: , p5_a18 JTF_VARCHAR2_TABLE_500
300: , p5_a19 JTF_VARCHAR2_TABLE_500
301: , p5_a20 JTF_VARCHAR2_TABLE_500
302: , p5_a21 JTF_VARCHAR2_TABLE_500
303: , p5_a22 JTF_NUMBER_TABLE
304: , p5_a23 JTF_NUMBER_TABLE
305: , p5_a24 JTF_NUMBER_TABLE
306: , p5_a25 JTF_DATE_TABLE
307: , p5_a26 JTF_NUMBER_TABLE
300: , p5_a19 JTF_VARCHAR2_TABLE_500
301: , p5_a20 JTF_VARCHAR2_TABLE_500
302: , p5_a21 JTF_VARCHAR2_TABLE_500
303: , p5_a22 JTF_NUMBER_TABLE
304: , p5_a23 JTF_NUMBER_TABLE
305: , p5_a24 JTF_NUMBER_TABLE
306: , p5_a25 JTF_DATE_TABLE
307: , p5_a26 JTF_NUMBER_TABLE
308: , p5_a27 JTF_DATE_TABLE
301: , p5_a20 JTF_VARCHAR2_TABLE_500
302: , p5_a21 JTF_VARCHAR2_TABLE_500
303: , p5_a22 JTF_NUMBER_TABLE
304: , p5_a23 JTF_NUMBER_TABLE
305: , p5_a24 JTF_NUMBER_TABLE
306: , p5_a25 JTF_DATE_TABLE
307: , p5_a26 JTF_NUMBER_TABLE
308: , p5_a27 JTF_DATE_TABLE
309: , p5_a28 JTF_NUMBER_TABLE
303: , p5_a22 JTF_NUMBER_TABLE
304: , p5_a23 JTF_NUMBER_TABLE
305: , p5_a24 JTF_NUMBER_TABLE
306: , p5_a25 JTF_DATE_TABLE
307: , p5_a26 JTF_NUMBER_TABLE
308: , p5_a27 JTF_DATE_TABLE
309: , p5_a28 JTF_NUMBER_TABLE
310: , p5_a29 JTF_DATE_TABLE
311: , p5_a30 JTF_NUMBER_TABLE
305: , p5_a24 JTF_NUMBER_TABLE
306: , p5_a25 JTF_DATE_TABLE
307: , p5_a26 JTF_NUMBER_TABLE
308: , p5_a27 JTF_DATE_TABLE
309: , p5_a28 JTF_NUMBER_TABLE
310: , p5_a29 JTF_DATE_TABLE
311: , p5_a30 JTF_NUMBER_TABLE
312: , p6_a0 out nocopy JTF_NUMBER_TABLE
313: , p6_a1 out nocopy JTF_NUMBER_TABLE
307: , p5_a26 JTF_NUMBER_TABLE
308: , p5_a27 JTF_DATE_TABLE
309: , p5_a28 JTF_NUMBER_TABLE
310: , p5_a29 JTF_DATE_TABLE
311: , p5_a30 JTF_NUMBER_TABLE
312: , p6_a0 out nocopy JTF_NUMBER_TABLE
313: , p6_a1 out nocopy JTF_NUMBER_TABLE
314: , p6_a2 out nocopy JTF_NUMBER_TABLE
315: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
308: , p5_a27 JTF_DATE_TABLE
309: , p5_a28 JTF_NUMBER_TABLE
310: , p5_a29 JTF_DATE_TABLE
311: , p5_a30 JTF_NUMBER_TABLE
312: , p6_a0 out nocopy JTF_NUMBER_TABLE
313: , p6_a1 out nocopy JTF_NUMBER_TABLE
314: , p6_a2 out nocopy JTF_NUMBER_TABLE
315: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
316: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
309: , p5_a28 JTF_NUMBER_TABLE
310: , p5_a29 JTF_DATE_TABLE
311: , p5_a30 JTF_NUMBER_TABLE
312: , p6_a0 out nocopy JTF_NUMBER_TABLE
313: , p6_a1 out nocopy JTF_NUMBER_TABLE
314: , p6_a2 out nocopy JTF_NUMBER_TABLE
315: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
316: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
317: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
310: , p5_a29 JTF_DATE_TABLE
311: , p5_a30 JTF_NUMBER_TABLE
312: , p6_a0 out nocopy JTF_NUMBER_TABLE
313: , p6_a1 out nocopy JTF_NUMBER_TABLE
314: , p6_a2 out nocopy JTF_NUMBER_TABLE
315: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
316: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
317: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
318: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
330: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
331: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
332: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
333: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
334: , p6_a22 out nocopy JTF_NUMBER_TABLE
335: , p6_a23 out nocopy JTF_NUMBER_TABLE
336: , p6_a24 out nocopy JTF_NUMBER_TABLE
337: , p6_a25 out nocopy JTF_DATE_TABLE
338: , p6_a26 out nocopy JTF_NUMBER_TABLE
331: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
332: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
333: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
334: , p6_a22 out nocopy JTF_NUMBER_TABLE
335: , p6_a23 out nocopy JTF_NUMBER_TABLE
336: , p6_a24 out nocopy JTF_NUMBER_TABLE
337: , p6_a25 out nocopy JTF_DATE_TABLE
338: , p6_a26 out nocopy JTF_NUMBER_TABLE
339: , p6_a27 out nocopy JTF_DATE_TABLE
332: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
333: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
334: , p6_a22 out nocopy JTF_NUMBER_TABLE
335: , p6_a23 out nocopy JTF_NUMBER_TABLE
336: , p6_a24 out nocopy JTF_NUMBER_TABLE
337: , p6_a25 out nocopy JTF_DATE_TABLE
338: , p6_a26 out nocopy JTF_NUMBER_TABLE
339: , p6_a27 out nocopy JTF_DATE_TABLE
340: , p6_a28 out nocopy JTF_NUMBER_TABLE
334: , p6_a22 out nocopy JTF_NUMBER_TABLE
335: , p6_a23 out nocopy JTF_NUMBER_TABLE
336: , p6_a24 out nocopy JTF_NUMBER_TABLE
337: , p6_a25 out nocopy JTF_DATE_TABLE
338: , p6_a26 out nocopy JTF_NUMBER_TABLE
339: , p6_a27 out nocopy JTF_DATE_TABLE
340: , p6_a28 out nocopy JTF_NUMBER_TABLE
341: , p6_a29 out nocopy JTF_DATE_TABLE
342: , p6_a30 out nocopy JTF_NUMBER_TABLE
336: , p6_a24 out nocopy JTF_NUMBER_TABLE
337: , p6_a25 out nocopy JTF_DATE_TABLE
338: , p6_a26 out nocopy JTF_NUMBER_TABLE
339: , p6_a27 out nocopy JTF_DATE_TABLE
340: , p6_a28 out nocopy JTF_NUMBER_TABLE
341: , p6_a29 out nocopy JTF_DATE_TABLE
342: , p6_a30 out nocopy JTF_NUMBER_TABLE
343: );
344: procedure lock_row(p_api_version NUMBER
338: , p6_a26 out nocopy JTF_NUMBER_TABLE
339: , p6_a27 out nocopy JTF_DATE_TABLE
340: , p6_a28 out nocopy JTF_NUMBER_TABLE
341: , p6_a29 out nocopy JTF_DATE_TABLE
342: , p6_a30 out nocopy JTF_NUMBER_TABLE
343: );
344: procedure lock_row(p_api_version NUMBER
345: , p_init_msg_list VARCHAR2
346: , x_return_status out nocopy VARCHAR2
382: , p_init_msg_list VARCHAR2
383: , x_return_status out nocopy VARCHAR2
384: , x_msg_count out nocopy NUMBER
385: , x_msg_data out nocopy VARCHAR2
386: , p5_a0 JTF_NUMBER_TABLE
387: , p5_a1 JTF_NUMBER_TABLE
388: , p5_a2 JTF_NUMBER_TABLE
389: , p5_a3 JTF_VARCHAR2_TABLE_100
390: , p5_a4 JTF_VARCHAR2_TABLE_400
383: , x_return_status out nocopy VARCHAR2
384: , x_msg_count out nocopy NUMBER
385: , x_msg_data out nocopy VARCHAR2
386: , p5_a0 JTF_NUMBER_TABLE
387: , p5_a1 JTF_NUMBER_TABLE
388: , p5_a2 JTF_NUMBER_TABLE
389: , p5_a3 JTF_VARCHAR2_TABLE_100
390: , p5_a4 JTF_VARCHAR2_TABLE_400
391: , p5_a5 JTF_VARCHAR2_TABLE_2000
384: , x_msg_count out nocopy NUMBER
385: , x_msg_data out nocopy VARCHAR2
386: , p5_a0 JTF_NUMBER_TABLE
387: , p5_a1 JTF_NUMBER_TABLE
388: , p5_a2 JTF_NUMBER_TABLE
389: , p5_a3 JTF_VARCHAR2_TABLE_100
390: , p5_a4 JTF_VARCHAR2_TABLE_400
391: , p5_a5 JTF_VARCHAR2_TABLE_2000
392: , p5_a6 JTF_VARCHAR2_TABLE_100
404: , p5_a18 JTF_VARCHAR2_TABLE_500
405: , p5_a19 JTF_VARCHAR2_TABLE_500
406: , p5_a20 JTF_VARCHAR2_TABLE_500
407: , p5_a21 JTF_VARCHAR2_TABLE_500
408: , p5_a22 JTF_NUMBER_TABLE
409: , p5_a23 JTF_NUMBER_TABLE
410: , p5_a24 JTF_NUMBER_TABLE
411: , p5_a25 JTF_DATE_TABLE
412: , p5_a26 JTF_NUMBER_TABLE
405: , p5_a19 JTF_VARCHAR2_TABLE_500
406: , p5_a20 JTF_VARCHAR2_TABLE_500
407: , p5_a21 JTF_VARCHAR2_TABLE_500
408: , p5_a22 JTF_NUMBER_TABLE
409: , p5_a23 JTF_NUMBER_TABLE
410: , p5_a24 JTF_NUMBER_TABLE
411: , p5_a25 JTF_DATE_TABLE
412: , p5_a26 JTF_NUMBER_TABLE
413: , p5_a27 JTF_DATE_TABLE
406: , p5_a20 JTF_VARCHAR2_TABLE_500
407: , p5_a21 JTF_VARCHAR2_TABLE_500
408: , p5_a22 JTF_NUMBER_TABLE
409: , p5_a23 JTF_NUMBER_TABLE
410: , p5_a24 JTF_NUMBER_TABLE
411: , p5_a25 JTF_DATE_TABLE
412: , p5_a26 JTF_NUMBER_TABLE
413: , p5_a27 JTF_DATE_TABLE
414: , p5_a28 JTF_NUMBER_TABLE
408: , p5_a22 JTF_NUMBER_TABLE
409: , p5_a23 JTF_NUMBER_TABLE
410: , p5_a24 JTF_NUMBER_TABLE
411: , p5_a25 JTF_DATE_TABLE
412: , p5_a26 JTF_NUMBER_TABLE
413: , p5_a27 JTF_DATE_TABLE
414: , p5_a28 JTF_NUMBER_TABLE
415: , p5_a29 JTF_DATE_TABLE
416: , p5_a30 JTF_NUMBER_TABLE
410: , p5_a24 JTF_NUMBER_TABLE
411: , p5_a25 JTF_DATE_TABLE
412: , p5_a26 JTF_NUMBER_TABLE
413: , p5_a27 JTF_DATE_TABLE
414: , p5_a28 JTF_NUMBER_TABLE
415: , p5_a29 JTF_DATE_TABLE
416: , p5_a30 JTF_NUMBER_TABLE
417: , p6_a0 in out nocopy JTF_NUMBER_TABLE
418: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
412: , p5_a26 JTF_NUMBER_TABLE
413: , p5_a27 JTF_DATE_TABLE
414: , p5_a28 JTF_NUMBER_TABLE
415: , p5_a29 JTF_DATE_TABLE
416: , p5_a30 JTF_NUMBER_TABLE
417: , p6_a0 in out nocopy JTF_NUMBER_TABLE
418: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
419: , p6_a2 in out nocopy JTF_NUMBER_TABLE
420: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
413: , p5_a27 JTF_DATE_TABLE
414: , p5_a28 JTF_NUMBER_TABLE
415: , p5_a29 JTF_DATE_TABLE
416: , p5_a30 JTF_NUMBER_TABLE
417: , p6_a0 in out nocopy JTF_NUMBER_TABLE
418: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
419: , p6_a2 in out nocopy JTF_NUMBER_TABLE
420: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
421: , p6_a4 in out nocopy JTF_NUMBER_TABLE
415: , p5_a29 JTF_DATE_TABLE
416: , p5_a30 JTF_NUMBER_TABLE
417: , p6_a0 in out nocopy JTF_NUMBER_TABLE
418: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
419: , p6_a2 in out nocopy JTF_NUMBER_TABLE
420: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
421: , p6_a4 in out nocopy JTF_NUMBER_TABLE
422: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
417: , p6_a0 in out nocopy JTF_NUMBER_TABLE
418: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
419: , p6_a2 in out nocopy JTF_NUMBER_TABLE
420: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
421: , p6_a4 in out nocopy JTF_NUMBER_TABLE
422: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
423: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
424: );
425: procedure lock_row(p_api_version NUMBER
426: , p_init_msg_list VARCHAR2
427: , x_return_status out nocopy VARCHAR2
428: , x_msg_count out nocopy NUMBER
429: , x_msg_data out nocopy VARCHAR2
430: , p5_a0 JTF_NUMBER_TABLE
431: , p5_a1 JTF_NUMBER_TABLE
432: , p5_a2 JTF_NUMBER_TABLE
433: , p5_a3 JTF_VARCHAR2_TABLE_100
434: , p5_a4 JTF_VARCHAR2_TABLE_400
427: , x_return_status out nocopy VARCHAR2
428: , x_msg_count out nocopy NUMBER
429: , x_msg_data out nocopy VARCHAR2
430: , p5_a0 JTF_NUMBER_TABLE
431: , p5_a1 JTF_NUMBER_TABLE
432: , p5_a2 JTF_NUMBER_TABLE
433: , p5_a3 JTF_VARCHAR2_TABLE_100
434: , p5_a4 JTF_VARCHAR2_TABLE_400
435: , p5_a5 JTF_VARCHAR2_TABLE_2000
428: , x_msg_count out nocopy NUMBER
429: , x_msg_data out nocopy VARCHAR2
430: , p5_a0 JTF_NUMBER_TABLE
431: , p5_a1 JTF_NUMBER_TABLE
432: , p5_a2 JTF_NUMBER_TABLE
433: , p5_a3 JTF_VARCHAR2_TABLE_100
434: , p5_a4 JTF_VARCHAR2_TABLE_400
435: , p5_a5 JTF_VARCHAR2_TABLE_2000
436: , p5_a6 JTF_VARCHAR2_TABLE_100
448: , p5_a18 JTF_VARCHAR2_TABLE_500
449: , p5_a19 JTF_VARCHAR2_TABLE_500
450: , p5_a20 JTF_VARCHAR2_TABLE_500
451: , p5_a21 JTF_VARCHAR2_TABLE_500
452: , p5_a22 JTF_NUMBER_TABLE
453: , p5_a23 JTF_NUMBER_TABLE
454: , p5_a24 JTF_NUMBER_TABLE
455: , p5_a25 JTF_DATE_TABLE
456: , p5_a26 JTF_NUMBER_TABLE
449: , p5_a19 JTF_VARCHAR2_TABLE_500
450: , p5_a20 JTF_VARCHAR2_TABLE_500
451: , p5_a21 JTF_VARCHAR2_TABLE_500
452: , p5_a22 JTF_NUMBER_TABLE
453: , p5_a23 JTF_NUMBER_TABLE
454: , p5_a24 JTF_NUMBER_TABLE
455: , p5_a25 JTF_DATE_TABLE
456: , p5_a26 JTF_NUMBER_TABLE
457: , p5_a27 JTF_DATE_TABLE
450: , p5_a20 JTF_VARCHAR2_TABLE_500
451: , p5_a21 JTF_VARCHAR2_TABLE_500
452: , p5_a22 JTF_NUMBER_TABLE
453: , p5_a23 JTF_NUMBER_TABLE
454: , p5_a24 JTF_NUMBER_TABLE
455: , p5_a25 JTF_DATE_TABLE
456: , p5_a26 JTF_NUMBER_TABLE
457: , p5_a27 JTF_DATE_TABLE
458: , p5_a28 JTF_NUMBER_TABLE
452: , p5_a22 JTF_NUMBER_TABLE
453: , p5_a23 JTF_NUMBER_TABLE
454: , p5_a24 JTF_NUMBER_TABLE
455: , p5_a25 JTF_DATE_TABLE
456: , p5_a26 JTF_NUMBER_TABLE
457: , p5_a27 JTF_DATE_TABLE
458: , p5_a28 JTF_NUMBER_TABLE
459: , p5_a29 JTF_DATE_TABLE
460: , p5_a30 JTF_NUMBER_TABLE
454: , p5_a24 JTF_NUMBER_TABLE
455: , p5_a25 JTF_DATE_TABLE
456: , p5_a26 JTF_NUMBER_TABLE
457: , p5_a27 JTF_DATE_TABLE
458: , p5_a28 JTF_NUMBER_TABLE
459: , p5_a29 JTF_DATE_TABLE
460: , p5_a30 JTF_NUMBER_TABLE
461: );
462: procedure update_row(p_api_version NUMBER
456: , p5_a26 JTF_NUMBER_TABLE
457: , p5_a27 JTF_DATE_TABLE
458: , p5_a28 JTF_NUMBER_TABLE
459: , p5_a29 JTF_DATE_TABLE
460: , p5_a30 JTF_NUMBER_TABLE
461: );
462: procedure update_row(p_api_version NUMBER
463: , p_init_msg_list VARCHAR2
464: , x_return_status out nocopy VARCHAR2
531: , p_init_msg_list VARCHAR2
532: , x_return_status out nocopy VARCHAR2
533: , x_msg_count out nocopy NUMBER
534: , x_msg_data out nocopy VARCHAR2
535: , p5_a0 JTF_NUMBER_TABLE
536: , p5_a1 JTF_NUMBER_TABLE
537: , p5_a2 JTF_NUMBER_TABLE
538: , p5_a3 JTF_VARCHAR2_TABLE_100
539: , p5_a4 JTF_VARCHAR2_TABLE_400
532: , x_return_status out nocopy VARCHAR2
533: , x_msg_count out nocopy NUMBER
534: , x_msg_data out nocopy VARCHAR2
535: , p5_a0 JTF_NUMBER_TABLE
536: , p5_a1 JTF_NUMBER_TABLE
537: , p5_a2 JTF_NUMBER_TABLE
538: , p5_a3 JTF_VARCHAR2_TABLE_100
539: , p5_a4 JTF_VARCHAR2_TABLE_400
540: , p5_a5 JTF_VARCHAR2_TABLE_2000
533: , x_msg_count out nocopy NUMBER
534: , x_msg_data out nocopy VARCHAR2
535: , p5_a0 JTF_NUMBER_TABLE
536: , p5_a1 JTF_NUMBER_TABLE
537: , p5_a2 JTF_NUMBER_TABLE
538: , p5_a3 JTF_VARCHAR2_TABLE_100
539: , p5_a4 JTF_VARCHAR2_TABLE_400
540: , p5_a5 JTF_VARCHAR2_TABLE_2000
541: , p5_a6 JTF_VARCHAR2_TABLE_100
553: , p5_a18 JTF_VARCHAR2_TABLE_500
554: , p5_a19 JTF_VARCHAR2_TABLE_500
555: , p5_a20 JTF_VARCHAR2_TABLE_500
556: , p5_a21 JTF_VARCHAR2_TABLE_500
557: , p5_a22 JTF_NUMBER_TABLE
558: , p5_a23 JTF_NUMBER_TABLE
559: , p5_a24 JTF_NUMBER_TABLE
560: , p5_a25 JTF_DATE_TABLE
561: , p5_a26 JTF_NUMBER_TABLE
554: , p5_a19 JTF_VARCHAR2_TABLE_500
555: , p5_a20 JTF_VARCHAR2_TABLE_500
556: , p5_a21 JTF_VARCHAR2_TABLE_500
557: , p5_a22 JTF_NUMBER_TABLE
558: , p5_a23 JTF_NUMBER_TABLE
559: , p5_a24 JTF_NUMBER_TABLE
560: , p5_a25 JTF_DATE_TABLE
561: , p5_a26 JTF_NUMBER_TABLE
562: , p5_a27 JTF_DATE_TABLE
555: , p5_a20 JTF_VARCHAR2_TABLE_500
556: , p5_a21 JTF_VARCHAR2_TABLE_500
557: , p5_a22 JTF_NUMBER_TABLE
558: , p5_a23 JTF_NUMBER_TABLE
559: , p5_a24 JTF_NUMBER_TABLE
560: , p5_a25 JTF_DATE_TABLE
561: , p5_a26 JTF_NUMBER_TABLE
562: , p5_a27 JTF_DATE_TABLE
563: , p5_a28 JTF_NUMBER_TABLE
557: , p5_a22 JTF_NUMBER_TABLE
558: , p5_a23 JTF_NUMBER_TABLE
559: , p5_a24 JTF_NUMBER_TABLE
560: , p5_a25 JTF_DATE_TABLE
561: , p5_a26 JTF_NUMBER_TABLE
562: , p5_a27 JTF_DATE_TABLE
563: , p5_a28 JTF_NUMBER_TABLE
564: , p5_a29 JTF_DATE_TABLE
565: , p5_a30 JTF_NUMBER_TABLE
559: , p5_a24 JTF_NUMBER_TABLE
560: , p5_a25 JTF_DATE_TABLE
561: , p5_a26 JTF_NUMBER_TABLE
562: , p5_a27 JTF_DATE_TABLE
563: , p5_a28 JTF_NUMBER_TABLE
564: , p5_a29 JTF_DATE_TABLE
565: , p5_a30 JTF_NUMBER_TABLE
566: , p6_a0 out nocopy JTF_NUMBER_TABLE
567: , p6_a1 out nocopy JTF_NUMBER_TABLE
561: , p5_a26 JTF_NUMBER_TABLE
562: , p5_a27 JTF_DATE_TABLE
563: , p5_a28 JTF_NUMBER_TABLE
564: , p5_a29 JTF_DATE_TABLE
565: , p5_a30 JTF_NUMBER_TABLE
566: , p6_a0 out nocopy JTF_NUMBER_TABLE
567: , p6_a1 out nocopy JTF_NUMBER_TABLE
568: , p6_a2 out nocopy JTF_NUMBER_TABLE
569: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
562: , p5_a27 JTF_DATE_TABLE
563: , p5_a28 JTF_NUMBER_TABLE
564: , p5_a29 JTF_DATE_TABLE
565: , p5_a30 JTF_NUMBER_TABLE
566: , p6_a0 out nocopy JTF_NUMBER_TABLE
567: , p6_a1 out nocopy JTF_NUMBER_TABLE
568: , p6_a2 out nocopy JTF_NUMBER_TABLE
569: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
570: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
563: , p5_a28 JTF_NUMBER_TABLE
564: , p5_a29 JTF_DATE_TABLE
565: , p5_a30 JTF_NUMBER_TABLE
566: , p6_a0 out nocopy JTF_NUMBER_TABLE
567: , p6_a1 out nocopy JTF_NUMBER_TABLE
568: , p6_a2 out nocopy JTF_NUMBER_TABLE
569: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
570: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
571: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
564: , p5_a29 JTF_DATE_TABLE
565: , p5_a30 JTF_NUMBER_TABLE
566: , p6_a0 out nocopy JTF_NUMBER_TABLE
567: , p6_a1 out nocopy JTF_NUMBER_TABLE
568: , p6_a2 out nocopy JTF_NUMBER_TABLE
569: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
570: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
571: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
572: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
584: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
585: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
586: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
587: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
588: , p6_a22 out nocopy JTF_NUMBER_TABLE
589: , p6_a23 out nocopy JTF_NUMBER_TABLE
590: , p6_a24 out nocopy JTF_NUMBER_TABLE
591: , p6_a25 out nocopy JTF_DATE_TABLE
592: , p6_a26 out nocopy JTF_NUMBER_TABLE
585: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
586: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
587: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
588: , p6_a22 out nocopy JTF_NUMBER_TABLE
589: , p6_a23 out nocopy JTF_NUMBER_TABLE
590: , p6_a24 out nocopy JTF_NUMBER_TABLE
591: , p6_a25 out nocopy JTF_DATE_TABLE
592: , p6_a26 out nocopy JTF_NUMBER_TABLE
593: , p6_a27 out nocopy JTF_DATE_TABLE
586: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
587: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
588: , p6_a22 out nocopy JTF_NUMBER_TABLE
589: , p6_a23 out nocopy JTF_NUMBER_TABLE
590: , p6_a24 out nocopy JTF_NUMBER_TABLE
591: , p6_a25 out nocopy JTF_DATE_TABLE
592: , p6_a26 out nocopy JTF_NUMBER_TABLE
593: , p6_a27 out nocopy JTF_DATE_TABLE
594: , p6_a28 out nocopy JTF_NUMBER_TABLE
588: , p6_a22 out nocopy JTF_NUMBER_TABLE
589: , p6_a23 out nocopy JTF_NUMBER_TABLE
590: , p6_a24 out nocopy JTF_NUMBER_TABLE
591: , p6_a25 out nocopy JTF_DATE_TABLE
592: , p6_a26 out nocopy JTF_NUMBER_TABLE
593: , p6_a27 out nocopy JTF_DATE_TABLE
594: , p6_a28 out nocopy JTF_NUMBER_TABLE
595: , p6_a29 out nocopy JTF_DATE_TABLE
596: , p6_a30 out nocopy JTF_NUMBER_TABLE
590: , p6_a24 out nocopy JTF_NUMBER_TABLE
591: , p6_a25 out nocopy JTF_DATE_TABLE
592: , p6_a26 out nocopy JTF_NUMBER_TABLE
593: , p6_a27 out nocopy JTF_DATE_TABLE
594: , p6_a28 out nocopy JTF_NUMBER_TABLE
595: , p6_a29 out nocopy JTF_DATE_TABLE
596: , p6_a30 out nocopy JTF_NUMBER_TABLE
597: , p7_a0 in out nocopy JTF_NUMBER_TABLE
598: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
592: , p6_a26 out nocopy JTF_NUMBER_TABLE
593: , p6_a27 out nocopy JTF_DATE_TABLE
594: , p6_a28 out nocopy JTF_NUMBER_TABLE
595: , p6_a29 out nocopy JTF_DATE_TABLE
596: , p6_a30 out nocopy JTF_NUMBER_TABLE
597: , p7_a0 in out nocopy JTF_NUMBER_TABLE
598: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
599: , p7_a2 in out nocopy JTF_NUMBER_TABLE
600: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
593: , p6_a27 out nocopy JTF_DATE_TABLE
594: , p6_a28 out nocopy JTF_NUMBER_TABLE
595: , p6_a29 out nocopy JTF_DATE_TABLE
596: , p6_a30 out nocopy JTF_NUMBER_TABLE
597: , p7_a0 in out nocopy JTF_NUMBER_TABLE
598: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
599: , p7_a2 in out nocopy JTF_NUMBER_TABLE
600: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
601: , p7_a4 in out nocopy JTF_NUMBER_TABLE
595: , p6_a29 out nocopy JTF_DATE_TABLE
596: , p6_a30 out nocopy JTF_NUMBER_TABLE
597: , p7_a0 in out nocopy JTF_NUMBER_TABLE
598: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
599: , p7_a2 in out nocopy JTF_NUMBER_TABLE
600: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
601: , p7_a4 in out nocopy JTF_NUMBER_TABLE
602: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
603: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
597: , p7_a0 in out nocopy JTF_NUMBER_TABLE
598: , p7_a1 in out nocopy JTF_VARCHAR2_TABLE_100
599: , p7_a2 in out nocopy JTF_NUMBER_TABLE
600: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
601: , p7_a4 in out nocopy JTF_NUMBER_TABLE
602: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
603: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
604: );
605: procedure update_row(p_api_version NUMBER
606: , p_init_msg_list VARCHAR2
607: , x_return_status out nocopy VARCHAR2
608: , x_msg_count out nocopy NUMBER
609: , x_msg_data out nocopy VARCHAR2
610: , p5_a0 JTF_NUMBER_TABLE
611: , p5_a1 JTF_NUMBER_TABLE
612: , p5_a2 JTF_NUMBER_TABLE
613: , p5_a3 JTF_VARCHAR2_TABLE_100
614: , p5_a4 JTF_VARCHAR2_TABLE_400
607: , x_return_status out nocopy VARCHAR2
608: , x_msg_count out nocopy NUMBER
609: , x_msg_data out nocopy VARCHAR2
610: , p5_a0 JTF_NUMBER_TABLE
611: , p5_a1 JTF_NUMBER_TABLE
612: , p5_a2 JTF_NUMBER_TABLE
613: , p5_a3 JTF_VARCHAR2_TABLE_100
614: , p5_a4 JTF_VARCHAR2_TABLE_400
615: , p5_a5 JTF_VARCHAR2_TABLE_2000
608: , x_msg_count out nocopy NUMBER
609: , x_msg_data out nocopy VARCHAR2
610: , p5_a0 JTF_NUMBER_TABLE
611: , p5_a1 JTF_NUMBER_TABLE
612: , p5_a2 JTF_NUMBER_TABLE
613: , p5_a3 JTF_VARCHAR2_TABLE_100
614: , p5_a4 JTF_VARCHAR2_TABLE_400
615: , p5_a5 JTF_VARCHAR2_TABLE_2000
616: , p5_a6 JTF_VARCHAR2_TABLE_100
628: , p5_a18 JTF_VARCHAR2_TABLE_500
629: , p5_a19 JTF_VARCHAR2_TABLE_500
630: , p5_a20 JTF_VARCHAR2_TABLE_500
631: , p5_a21 JTF_VARCHAR2_TABLE_500
632: , p5_a22 JTF_NUMBER_TABLE
633: , p5_a23 JTF_NUMBER_TABLE
634: , p5_a24 JTF_NUMBER_TABLE
635: , p5_a25 JTF_DATE_TABLE
636: , p5_a26 JTF_NUMBER_TABLE
629: , p5_a19 JTF_VARCHAR2_TABLE_500
630: , p5_a20 JTF_VARCHAR2_TABLE_500
631: , p5_a21 JTF_VARCHAR2_TABLE_500
632: , p5_a22 JTF_NUMBER_TABLE
633: , p5_a23 JTF_NUMBER_TABLE
634: , p5_a24 JTF_NUMBER_TABLE
635: , p5_a25 JTF_DATE_TABLE
636: , p5_a26 JTF_NUMBER_TABLE
637: , p5_a27 JTF_DATE_TABLE
630: , p5_a20 JTF_VARCHAR2_TABLE_500
631: , p5_a21 JTF_VARCHAR2_TABLE_500
632: , p5_a22 JTF_NUMBER_TABLE
633: , p5_a23 JTF_NUMBER_TABLE
634: , p5_a24 JTF_NUMBER_TABLE
635: , p5_a25 JTF_DATE_TABLE
636: , p5_a26 JTF_NUMBER_TABLE
637: , p5_a27 JTF_DATE_TABLE
638: , p5_a28 JTF_NUMBER_TABLE
632: , p5_a22 JTF_NUMBER_TABLE
633: , p5_a23 JTF_NUMBER_TABLE
634: , p5_a24 JTF_NUMBER_TABLE
635: , p5_a25 JTF_DATE_TABLE
636: , p5_a26 JTF_NUMBER_TABLE
637: , p5_a27 JTF_DATE_TABLE
638: , p5_a28 JTF_NUMBER_TABLE
639: , p5_a29 JTF_DATE_TABLE
640: , p5_a30 JTF_NUMBER_TABLE
634: , p5_a24 JTF_NUMBER_TABLE
635: , p5_a25 JTF_DATE_TABLE
636: , p5_a26 JTF_NUMBER_TABLE
637: , p5_a27 JTF_DATE_TABLE
638: , p5_a28 JTF_NUMBER_TABLE
639: , p5_a29 JTF_DATE_TABLE
640: , p5_a30 JTF_NUMBER_TABLE
641: , p6_a0 out nocopy JTF_NUMBER_TABLE
642: , p6_a1 out nocopy JTF_NUMBER_TABLE
636: , p5_a26 JTF_NUMBER_TABLE
637: , p5_a27 JTF_DATE_TABLE
638: , p5_a28 JTF_NUMBER_TABLE
639: , p5_a29 JTF_DATE_TABLE
640: , p5_a30 JTF_NUMBER_TABLE
641: , p6_a0 out nocopy JTF_NUMBER_TABLE
642: , p6_a1 out nocopy JTF_NUMBER_TABLE
643: , p6_a2 out nocopy JTF_NUMBER_TABLE
644: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
637: , p5_a27 JTF_DATE_TABLE
638: , p5_a28 JTF_NUMBER_TABLE
639: , p5_a29 JTF_DATE_TABLE
640: , p5_a30 JTF_NUMBER_TABLE
641: , p6_a0 out nocopy JTF_NUMBER_TABLE
642: , p6_a1 out nocopy JTF_NUMBER_TABLE
643: , p6_a2 out nocopy JTF_NUMBER_TABLE
644: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
645: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
638: , p5_a28 JTF_NUMBER_TABLE
639: , p5_a29 JTF_DATE_TABLE
640: , p5_a30 JTF_NUMBER_TABLE
641: , p6_a0 out nocopy JTF_NUMBER_TABLE
642: , p6_a1 out nocopy JTF_NUMBER_TABLE
643: , p6_a2 out nocopy JTF_NUMBER_TABLE
644: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
645: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
646: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
639: , p5_a29 JTF_DATE_TABLE
640: , p5_a30 JTF_NUMBER_TABLE
641: , p6_a0 out nocopy JTF_NUMBER_TABLE
642: , p6_a1 out nocopy JTF_NUMBER_TABLE
643: , p6_a2 out nocopy JTF_NUMBER_TABLE
644: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
645: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
646: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
647: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
659: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
660: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
661: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
662: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
663: , p6_a22 out nocopy JTF_NUMBER_TABLE
664: , p6_a23 out nocopy JTF_NUMBER_TABLE
665: , p6_a24 out nocopy JTF_NUMBER_TABLE
666: , p6_a25 out nocopy JTF_DATE_TABLE
667: , p6_a26 out nocopy JTF_NUMBER_TABLE
660: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
661: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
662: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
663: , p6_a22 out nocopy JTF_NUMBER_TABLE
664: , p6_a23 out nocopy JTF_NUMBER_TABLE
665: , p6_a24 out nocopy JTF_NUMBER_TABLE
666: , p6_a25 out nocopy JTF_DATE_TABLE
667: , p6_a26 out nocopy JTF_NUMBER_TABLE
668: , p6_a27 out nocopy JTF_DATE_TABLE
661: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
662: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
663: , p6_a22 out nocopy JTF_NUMBER_TABLE
664: , p6_a23 out nocopy JTF_NUMBER_TABLE
665: , p6_a24 out nocopy JTF_NUMBER_TABLE
666: , p6_a25 out nocopy JTF_DATE_TABLE
667: , p6_a26 out nocopy JTF_NUMBER_TABLE
668: , p6_a27 out nocopy JTF_DATE_TABLE
669: , p6_a28 out nocopy JTF_NUMBER_TABLE
663: , p6_a22 out nocopy JTF_NUMBER_TABLE
664: , p6_a23 out nocopy JTF_NUMBER_TABLE
665: , p6_a24 out nocopy JTF_NUMBER_TABLE
666: , p6_a25 out nocopy JTF_DATE_TABLE
667: , p6_a26 out nocopy JTF_NUMBER_TABLE
668: , p6_a27 out nocopy JTF_DATE_TABLE
669: , p6_a28 out nocopy JTF_NUMBER_TABLE
670: , p6_a29 out nocopy JTF_DATE_TABLE
671: , p6_a30 out nocopy JTF_NUMBER_TABLE
665: , p6_a24 out nocopy JTF_NUMBER_TABLE
666: , p6_a25 out nocopy JTF_DATE_TABLE
667: , p6_a26 out nocopy JTF_NUMBER_TABLE
668: , p6_a27 out nocopy JTF_DATE_TABLE
669: , p6_a28 out nocopy JTF_NUMBER_TABLE
670: , p6_a29 out nocopy JTF_DATE_TABLE
671: , p6_a30 out nocopy JTF_NUMBER_TABLE
672: );
673: procedure delete_row(p_api_version NUMBER
667: , p6_a26 out nocopy JTF_NUMBER_TABLE
668: , p6_a27 out nocopy JTF_DATE_TABLE
669: , p6_a28 out nocopy JTF_NUMBER_TABLE
670: , p6_a29 out nocopy JTF_DATE_TABLE
671: , p6_a30 out nocopy JTF_NUMBER_TABLE
672: );
673: procedure delete_row(p_api_version NUMBER
674: , p_init_msg_list VARCHAR2
675: , x_return_status out nocopy VARCHAR2
711: , p_init_msg_list VARCHAR2
712: , x_return_status out nocopy VARCHAR2
713: , x_msg_count out nocopy NUMBER
714: , x_msg_data out nocopy VARCHAR2
715: , p5_a0 JTF_NUMBER_TABLE
716: , p5_a1 JTF_NUMBER_TABLE
717: , p5_a2 JTF_NUMBER_TABLE
718: , p5_a3 JTF_VARCHAR2_TABLE_100
719: , p5_a4 JTF_VARCHAR2_TABLE_400
712: , x_return_status out nocopy VARCHAR2
713: , x_msg_count out nocopy NUMBER
714: , x_msg_data out nocopy VARCHAR2
715: , p5_a0 JTF_NUMBER_TABLE
716: , p5_a1 JTF_NUMBER_TABLE
717: , p5_a2 JTF_NUMBER_TABLE
718: , p5_a3 JTF_VARCHAR2_TABLE_100
719: , p5_a4 JTF_VARCHAR2_TABLE_400
720: , p5_a5 JTF_VARCHAR2_TABLE_2000
713: , x_msg_count out nocopy NUMBER
714: , x_msg_data out nocopy VARCHAR2
715: , p5_a0 JTF_NUMBER_TABLE
716: , p5_a1 JTF_NUMBER_TABLE
717: , p5_a2 JTF_NUMBER_TABLE
718: , p5_a3 JTF_VARCHAR2_TABLE_100
719: , p5_a4 JTF_VARCHAR2_TABLE_400
720: , p5_a5 JTF_VARCHAR2_TABLE_2000
721: , p5_a6 JTF_VARCHAR2_TABLE_100
733: , p5_a18 JTF_VARCHAR2_TABLE_500
734: , p5_a19 JTF_VARCHAR2_TABLE_500
735: , p5_a20 JTF_VARCHAR2_TABLE_500
736: , p5_a21 JTF_VARCHAR2_TABLE_500
737: , p5_a22 JTF_NUMBER_TABLE
738: , p5_a23 JTF_NUMBER_TABLE
739: , p5_a24 JTF_NUMBER_TABLE
740: , p5_a25 JTF_DATE_TABLE
741: , p5_a26 JTF_NUMBER_TABLE
734: , p5_a19 JTF_VARCHAR2_TABLE_500
735: , p5_a20 JTF_VARCHAR2_TABLE_500
736: , p5_a21 JTF_VARCHAR2_TABLE_500
737: , p5_a22 JTF_NUMBER_TABLE
738: , p5_a23 JTF_NUMBER_TABLE
739: , p5_a24 JTF_NUMBER_TABLE
740: , p5_a25 JTF_DATE_TABLE
741: , p5_a26 JTF_NUMBER_TABLE
742: , p5_a27 JTF_DATE_TABLE
735: , p5_a20 JTF_VARCHAR2_TABLE_500
736: , p5_a21 JTF_VARCHAR2_TABLE_500
737: , p5_a22 JTF_NUMBER_TABLE
738: , p5_a23 JTF_NUMBER_TABLE
739: , p5_a24 JTF_NUMBER_TABLE
740: , p5_a25 JTF_DATE_TABLE
741: , p5_a26 JTF_NUMBER_TABLE
742: , p5_a27 JTF_DATE_TABLE
743: , p5_a28 JTF_NUMBER_TABLE
737: , p5_a22 JTF_NUMBER_TABLE
738: , p5_a23 JTF_NUMBER_TABLE
739: , p5_a24 JTF_NUMBER_TABLE
740: , p5_a25 JTF_DATE_TABLE
741: , p5_a26 JTF_NUMBER_TABLE
742: , p5_a27 JTF_DATE_TABLE
743: , p5_a28 JTF_NUMBER_TABLE
744: , p5_a29 JTF_DATE_TABLE
745: , p5_a30 JTF_NUMBER_TABLE
739: , p5_a24 JTF_NUMBER_TABLE
740: , p5_a25 JTF_DATE_TABLE
741: , p5_a26 JTF_NUMBER_TABLE
742: , p5_a27 JTF_DATE_TABLE
743: , p5_a28 JTF_NUMBER_TABLE
744: , p5_a29 JTF_DATE_TABLE
745: , p5_a30 JTF_NUMBER_TABLE
746: , p6_a0 in out nocopy JTF_NUMBER_TABLE
747: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
741: , p5_a26 JTF_NUMBER_TABLE
742: , p5_a27 JTF_DATE_TABLE
743: , p5_a28 JTF_NUMBER_TABLE
744: , p5_a29 JTF_DATE_TABLE
745: , p5_a30 JTF_NUMBER_TABLE
746: , p6_a0 in out nocopy JTF_NUMBER_TABLE
747: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
748: , p6_a2 in out nocopy JTF_NUMBER_TABLE
749: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
742: , p5_a27 JTF_DATE_TABLE
743: , p5_a28 JTF_NUMBER_TABLE
744: , p5_a29 JTF_DATE_TABLE
745: , p5_a30 JTF_NUMBER_TABLE
746: , p6_a0 in out nocopy JTF_NUMBER_TABLE
747: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
748: , p6_a2 in out nocopy JTF_NUMBER_TABLE
749: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
750: , p6_a4 in out nocopy JTF_NUMBER_TABLE
744: , p5_a29 JTF_DATE_TABLE
745: , p5_a30 JTF_NUMBER_TABLE
746: , p6_a0 in out nocopy JTF_NUMBER_TABLE
747: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
748: , p6_a2 in out nocopy JTF_NUMBER_TABLE
749: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
750: , p6_a4 in out nocopy JTF_NUMBER_TABLE
751: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
752: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
746: , p6_a0 in out nocopy JTF_NUMBER_TABLE
747: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
748: , p6_a2 in out nocopy JTF_NUMBER_TABLE
749: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
750: , p6_a4 in out nocopy JTF_NUMBER_TABLE
751: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
752: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
753: );
754: procedure delete_row(p_api_version NUMBER
755: , p_init_msg_list VARCHAR2
756: , x_return_status out nocopy VARCHAR2
757: , x_msg_count out nocopy NUMBER
758: , x_msg_data out nocopy VARCHAR2
759: , p5_a0 JTF_NUMBER_TABLE
760: , p5_a1 JTF_NUMBER_TABLE
761: , p5_a2 JTF_NUMBER_TABLE
762: , p5_a3 JTF_VARCHAR2_TABLE_100
763: , p5_a4 JTF_VARCHAR2_TABLE_400
756: , x_return_status out nocopy VARCHAR2
757: , x_msg_count out nocopy NUMBER
758: , x_msg_data out nocopy VARCHAR2
759: , p5_a0 JTF_NUMBER_TABLE
760: , p5_a1 JTF_NUMBER_TABLE
761: , p5_a2 JTF_NUMBER_TABLE
762: , p5_a3 JTF_VARCHAR2_TABLE_100
763: , p5_a4 JTF_VARCHAR2_TABLE_400
764: , p5_a5 JTF_VARCHAR2_TABLE_2000
757: , x_msg_count out nocopy NUMBER
758: , x_msg_data out nocopy VARCHAR2
759: , p5_a0 JTF_NUMBER_TABLE
760: , p5_a1 JTF_NUMBER_TABLE
761: , p5_a2 JTF_NUMBER_TABLE
762: , p5_a3 JTF_VARCHAR2_TABLE_100
763: , p5_a4 JTF_VARCHAR2_TABLE_400
764: , p5_a5 JTF_VARCHAR2_TABLE_2000
765: , p5_a6 JTF_VARCHAR2_TABLE_100
777: , p5_a18 JTF_VARCHAR2_TABLE_500
778: , p5_a19 JTF_VARCHAR2_TABLE_500
779: , p5_a20 JTF_VARCHAR2_TABLE_500
780: , p5_a21 JTF_VARCHAR2_TABLE_500
781: , p5_a22 JTF_NUMBER_TABLE
782: , p5_a23 JTF_NUMBER_TABLE
783: , p5_a24 JTF_NUMBER_TABLE
784: , p5_a25 JTF_DATE_TABLE
785: , p5_a26 JTF_NUMBER_TABLE
778: , p5_a19 JTF_VARCHAR2_TABLE_500
779: , p5_a20 JTF_VARCHAR2_TABLE_500
780: , p5_a21 JTF_VARCHAR2_TABLE_500
781: , p5_a22 JTF_NUMBER_TABLE
782: , p5_a23 JTF_NUMBER_TABLE
783: , p5_a24 JTF_NUMBER_TABLE
784: , p5_a25 JTF_DATE_TABLE
785: , p5_a26 JTF_NUMBER_TABLE
786: , p5_a27 JTF_DATE_TABLE
779: , p5_a20 JTF_VARCHAR2_TABLE_500
780: , p5_a21 JTF_VARCHAR2_TABLE_500
781: , p5_a22 JTF_NUMBER_TABLE
782: , p5_a23 JTF_NUMBER_TABLE
783: , p5_a24 JTF_NUMBER_TABLE
784: , p5_a25 JTF_DATE_TABLE
785: , p5_a26 JTF_NUMBER_TABLE
786: , p5_a27 JTF_DATE_TABLE
787: , p5_a28 JTF_NUMBER_TABLE
781: , p5_a22 JTF_NUMBER_TABLE
782: , p5_a23 JTF_NUMBER_TABLE
783: , p5_a24 JTF_NUMBER_TABLE
784: , p5_a25 JTF_DATE_TABLE
785: , p5_a26 JTF_NUMBER_TABLE
786: , p5_a27 JTF_DATE_TABLE
787: , p5_a28 JTF_NUMBER_TABLE
788: , p5_a29 JTF_DATE_TABLE
789: , p5_a30 JTF_NUMBER_TABLE
783: , p5_a24 JTF_NUMBER_TABLE
784: , p5_a25 JTF_DATE_TABLE
785: , p5_a26 JTF_NUMBER_TABLE
786: , p5_a27 JTF_DATE_TABLE
787: , p5_a28 JTF_NUMBER_TABLE
788: , p5_a29 JTF_DATE_TABLE
789: , p5_a30 JTF_NUMBER_TABLE
790: );
791: procedure validate_row(p_api_version NUMBER
785: , p5_a26 JTF_NUMBER_TABLE
786: , p5_a27 JTF_DATE_TABLE
787: , p5_a28 JTF_NUMBER_TABLE
788: , p5_a29 JTF_DATE_TABLE
789: , p5_a30 JTF_NUMBER_TABLE
790: );
791: procedure validate_row(p_api_version NUMBER
792: , p_init_msg_list VARCHAR2
793: , x_return_status out nocopy VARCHAR2
829: , p_init_msg_list VARCHAR2
830: , x_return_status out nocopy VARCHAR2
831: , x_msg_count out nocopy NUMBER
832: , x_msg_data out nocopy VARCHAR2
833: , p5_a0 JTF_NUMBER_TABLE
834: , p5_a1 JTF_NUMBER_TABLE
835: , p5_a2 JTF_NUMBER_TABLE
836: , p5_a3 JTF_VARCHAR2_TABLE_100
837: , p5_a4 JTF_VARCHAR2_TABLE_400
830: , x_return_status out nocopy VARCHAR2
831: , x_msg_count out nocopy NUMBER
832: , x_msg_data out nocopy VARCHAR2
833: , p5_a0 JTF_NUMBER_TABLE
834: , p5_a1 JTF_NUMBER_TABLE
835: , p5_a2 JTF_NUMBER_TABLE
836: , p5_a3 JTF_VARCHAR2_TABLE_100
837: , p5_a4 JTF_VARCHAR2_TABLE_400
838: , p5_a5 JTF_VARCHAR2_TABLE_2000
831: , x_msg_count out nocopy NUMBER
832: , x_msg_data out nocopy VARCHAR2
833: , p5_a0 JTF_NUMBER_TABLE
834: , p5_a1 JTF_NUMBER_TABLE
835: , p5_a2 JTF_NUMBER_TABLE
836: , p5_a3 JTF_VARCHAR2_TABLE_100
837: , p5_a4 JTF_VARCHAR2_TABLE_400
838: , p5_a5 JTF_VARCHAR2_TABLE_2000
839: , p5_a6 JTF_VARCHAR2_TABLE_100
851: , p5_a18 JTF_VARCHAR2_TABLE_500
852: , p5_a19 JTF_VARCHAR2_TABLE_500
853: , p5_a20 JTF_VARCHAR2_TABLE_500
854: , p5_a21 JTF_VARCHAR2_TABLE_500
855: , p5_a22 JTF_NUMBER_TABLE
856: , p5_a23 JTF_NUMBER_TABLE
857: , p5_a24 JTF_NUMBER_TABLE
858: , p5_a25 JTF_DATE_TABLE
859: , p5_a26 JTF_NUMBER_TABLE
852: , p5_a19 JTF_VARCHAR2_TABLE_500
853: , p5_a20 JTF_VARCHAR2_TABLE_500
854: , p5_a21 JTF_VARCHAR2_TABLE_500
855: , p5_a22 JTF_NUMBER_TABLE
856: , p5_a23 JTF_NUMBER_TABLE
857: , p5_a24 JTF_NUMBER_TABLE
858: , p5_a25 JTF_DATE_TABLE
859: , p5_a26 JTF_NUMBER_TABLE
860: , p5_a27 JTF_DATE_TABLE
853: , p5_a20 JTF_VARCHAR2_TABLE_500
854: , p5_a21 JTF_VARCHAR2_TABLE_500
855: , p5_a22 JTF_NUMBER_TABLE
856: , p5_a23 JTF_NUMBER_TABLE
857: , p5_a24 JTF_NUMBER_TABLE
858: , p5_a25 JTF_DATE_TABLE
859: , p5_a26 JTF_NUMBER_TABLE
860: , p5_a27 JTF_DATE_TABLE
861: , p5_a28 JTF_NUMBER_TABLE
855: , p5_a22 JTF_NUMBER_TABLE
856: , p5_a23 JTF_NUMBER_TABLE
857: , p5_a24 JTF_NUMBER_TABLE
858: , p5_a25 JTF_DATE_TABLE
859: , p5_a26 JTF_NUMBER_TABLE
860: , p5_a27 JTF_DATE_TABLE
861: , p5_a28 JTF_NUMBER_TABLE
862: , p5_a29 JTF_DATE_TABLE
863: , p5_a30 JTF_NUMBER_TABLE
857: , p5_a24 JTF_NUMBER_TABLE
858: , p5_a25 JTF_DATE_TABLE
859: , p5_a26 JTF_NUMBER_TABLE
860: , p5_a27 JTF_DATE_TABLE
861: , p5_a28 JTF_NUMBER_TABLE
862: , p5_a29 JTF_DATE_TABLE
863: , p5_a30 JTF_NUMBER_TABLE
864: , p6_a0 in out nocopy JTF_NUMBER_TABLE
865: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
859: , p5_a26 JTF_NUMBER_TABLE
860: , p5_a27 JTF_DATE_TABLE
861: , p5_a28 JTF_NUMBER_TABLE
862: , p5_a29 JTF_DATE_TABLE
863: , p5_a30 JTF_NUMBER_TABLE
864: , p6_a0 in out nocopy JTF_NUMBER_TABLE
865: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
866: , p6_a2 in out nocopy JTF_NUMBER_TABLE
867: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
860: , p5_a27 JTF_DATE_TABLE
861: , p5_a28 JTF_NUMBER_TABLE
862: , p5_a29 JTF_DATE_TABLE
863: , p5_a30 JTF_NUMBER_TABLE
864: , p6_a0 in out nocopy JTF_NUMBER_TABLE
865: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
866: , p6_a2 in out nocopy JTF_NUMBER_TABLE
867: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
868: , p6_a4 in out nocopy JTF_NUMBER_TABLE
862: , p5_a29 JTF_DATE_TABLE
863: , p5_a30 JTF_NUMBER_TABLE
864: , p6_a0 in out nocopy JTF_NUMBER_TABLE
865: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
866: , p6_a2 in out nocopy JTF_NUMBER_TABLE
867: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
868: , p6_a4 in out nocopy JTF_NUMBER_TABLE
869: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
870: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
864: , p6_a0 in out nocopy JTF_NUMBER_TABLE
865: , p6_a1 in out nocopy JTF_VARCHAR2_TABLE_100
866: , p6_a2 in out nocopy JTF_NUMBER_TABLE
867: , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_2000
868: , p6_a4 in out nocopy JTF_NUMBER_TABLE
869: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
870: , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_100
871: );
872: procedure validate_row(p_api_version NUMBER
873: , p_init_msg_list VARCHAR2
874: , x_return_status out nocopy VARCHAR2
875: , x_msg_count out nocopy NUMBER
876: , x_msg_data out nocopy VARCHAR2
877: , p5_a0 JTF_NUMBER_TABLE
878: , p5_a1 JTF_NUMBER_TABLE
879: , p5_a2 JTF_NUMBER_TABLE
880: , p5_a3 JTF_VARCHAR2_TABLE_100
881: , p5_a4 JTF_VARCHAR2_TABLE_400
874: , x_return_status out nocopy VARCHAR2
875: , x_msg_count out nocopy NUMBER
876: , x_msg_data out nocopy VARCHAR2
877: , p5_a0 JTF_NUMBER_TABLE
878: , p5_a1 JTF_NUMBER_TABLE
879: , p5_a2 JTF_NUMBER_TABLE
880: , p5_a3 JTF_VARCHAR2_TABLE_100
881: , p5_a4 JTF_VARCHAR2_TABLE_400
882: , p5_a5 JTF_VARCHAR2_TABLE_2000
875: , x_msg_count out nocopy NUMBER
876: , x_msg_data out nocopy VARCHAR2
877: , p5_a0 JTF_NUMBER_TABLE
878: , p5_a1 JTF_NUMBER_TABLE
879: , p5_a2 JTF_NUMBER_TABLE
880: , p5_a3 JTF_VARCHAR2_TABLE_100
881: , p5_a4 JTF_VARCHAR2_TABLE_400
882: , p5_a5 JTF_VARCHAR2_TABLE_2000
883: , p5_a6 JTF_VARCHAR2_TABLE_100
895: , p5_a18 JTF_VARCHAR2_TABLE_500
896: , p5_a19 JTF_VARCHAR2_TABLE_500
897: , p5_a20 JTF_VARCHAR2_TABLE_500
898: , p5_a21 JTF_VARCHAR2_TABLE_500
899: , p5_a22 JTF_NUMBER_TABLE
900: , p5_a23 JTF_NUMBER_TABLE
901: , p5_a24 JTF_NUMBER_TABLE
902: , p5_a25 JTF_DATE_TABLE
903: , p5_a26 JTF_NUMBER_TABLE
896: , p5_a19 JTF_VARCHAR2_TABLE_500
897: , p5_a20 JTF_VARCHAR2_TABLE_500
898: , p5_a21 JTF_VARCHAR2_TABLE_500
899: , p5_a22 JTF_NUMBER_TABLE
900: , p5_a23 JTF_NUMBER_TABLE
901: , p5_a24 JTF_NUMBER_TABLE
902: , p5_a25 JTF_DATE_TABLE
903: , p5_a26 JTF_NUMBER_TABLE
904: , p5_a27 JTF_DATE_TABLE
897: , p5_a20 JTF_VARCHAR2_TABLE_500
898: , p5_a21 JTF_VARCHAR2_TABLE_500
899: , p5_a22 JTF_NUMBER_TABLE
900: , p5_a23 JTF_NUMBER_TABLE
901: , p5_a24 JTF_NUMBER_TABLE
902: , p5_a25 JTF_DATE_TABLE
903: , p5_a26 JTF_NUMBER_TABLE
904: , p5_a27 JTF_DATE_TABLE
905: , p5_a28 JTF_NUMBER_TABLE
899: , p5_a22 JTF_NUMBER_TABLE
900: , p5_a23 JTF_NUMBER_TABLE
901: , p5_a24 JTF_NUMBER_TABLE
902: , p5_a25 JTF_DATE_TABLE
903: , p5_a26 JTF_NUMBER_TABLE
904: , p5_a27 JTF_DATE_TABLE
905: , p5_a28 JTF_NUMBER_TABLE
906: , p5_a29 JTF_DATE_TABLE
907: , p5_a30 JTF_NUMBER_TABLE
901: , p5_a24 JTF_NUMBER_TABLE
902: , p5_a25 JTF_DATE_TABLE
903: , p5_a26 JTF_NUMBER_TABLE
904: , p5_a27 JTF_DATE_TABLE
905: , p5_a28 JTF_NUMBER_TABLE
906: , p5_a29 JTF_DATE_TABLE
907: , p5_a30 JTF_NUMBER_TABLE
908: );
909: end okl_vrr_pvt_w;
903: , p5_a26 JTF_NUMBER_TABLE
904: , p5_a27 JTF_DATE_TABLE
905: , p5_a28 JTF_NUMBER_TABLE
906: , p5_a29 JTF_DATE_TABLE
907: , p5_a30 JTF_NUMBER_TABLE
908: );
909: end okl_vrr_pvt_w;