1: package okl_avl_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIAVLS.pls 115.5 2003/03/26 19:48:12 hkpatel noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_avl_pvt.avl_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
1: package okl_avl_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLIAVLS.pls 115.5 2003/03/26 19:48:12 hkpatel noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_avl_pvt.avl_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
2: /* $Header: OKLIAVLS.pls 115.5 2003/03/26 19:48:12 hkpatel noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_avl_pvt.avl_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_avl_pvt.avl_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 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_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_2000
20: , a17 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_2000
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_DATE_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_VARCHAR2_TABLE_500
36: , a33 JTF_VARCHAR2_TABLE_500
37: , a34 JTF_VARCHAR2_TABLE_500
38: , a35 JTF_VARCHAR2_TABLE_500
39: , a36 JTF_VARCHAR2_TABLE_500
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_DATE_TABLE
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_DATE_TABLE
44: , a41 JTF_NUMBER_TABLE
38: , a35 JTF_VARCHAR2_TABLE_500
39: , a36 JTF_VARCHAR2_TABLE_500
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_DATE_TABLE
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_DATE_TABLE
44: , a41 JTF_NUMBER_TABLE
45: , a42 JTF_VARCHAR2_TABLE_100
46: );
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_DATE_TABLE
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_DATE_TABLE
44: , a41 JTF_NUMBER_TABLE
45: , a42 JTF_VARCHAR2_TABLE_100
46: );
47: procedure rosetta_table_copy_out_p2(t okl_avl_pvt.avl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
48: , a1 out nocopy JTF_VARCHAR2_TABLE_200
43: , a40 JTF_DATE_TABLE
44: , a41 JTF_NUMBER_TABLE
45: , a42 JTF_VARCHAR2_TABLE_100
46: );
47: procedure rosetta_table_copy_out_p2(t okl_avl_pvt.avl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
48: , a1 out nocopy JTF_VARCHAR2_TABLE_200
49: , a2 out nocopy JTF_NUMBER_TABLE
50: , a3 out nocopy JTF_NUMBER_TABLE
51: , a4 out nocopy JTF_NUMBER_TABLE
45: , a42 JTF_VARCHAR2_TABLE_100
46: );
47: procedure rosetta_table_copy_out_p2(t okl_avl_pvt.avl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
48: , a1 out nocopy JTF_VARCHAR2_TABLE_200
49: , a2 out nocopy JTF_NUMBER_TABLE
50: , a3 out nocopy JTF_NUMBER_TABLE
51: , a4 out nocopy JTF_NUMBER_TABLE
52: , a5 out nocopy JTF_NUMBER_TABLE
53: , a6 out nocopy JTF_VARCHAR2_TABLE_100
46: );
47: procedure rosetta_table_copy_out_p2(t okl_avl_pvt.avl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
48: , a1 out nocopy JTF_VARCHAR2_TABLE_200
49: , a2 out nocopy JTF_NUMBER_TABLE
50: , a3 out nocopy JTF_NUMBER_TABLE
51: , a4 out nocopy JTF_NUMBER_TABLE
52: , a5 out nocopy JTF_NUMBER_TABLE
53: , a6 out nocopy JTF_VARCHAR2_TABLE_100
54: , a7 out nocopy JTF_VARCHAR2_TABLE_100
47: procedure rosetta_table_copy_out_p2(t okl_avl_pvt.avl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
48: , a1 out nocopy JTF_VARCHAR2_TABLE_200
49: , a2 out nocopy JTF_NUMBER_TABLE
50: , a3 out nocopy JTF_NUMBER_TABLE
51: , a4 out nocopy JTF_NUMBER_TABLE
52: , a5 out nocopy JTF_NUMBER_TABLE
53: , a6 out nocopy JTF_VARCHAR2_TABLE_100
54: , a7 out nocopy JTF_VARCHAR2_TABLE_100
55: , a8 out nocopy JTF_NUMBER_TABLE
48: , a1 out nocopy JTF_VARCHAR2_TABLE_200
49: , a2 out nocopy JTF_NUMBER_TABLE
50: , a3 out nocopy JTF_NUMBER_TABLE
51: , a4 out nocopy JTF_NUMBER_TABLE
52: , a5 out nocopy JTF_NUMBER_TABLE
53: , a6 out nocopy JTF_VARCHAR2_TABLE_100
54: , a7 out nocopy JTF_VARCHAR2_TABLE_100
55: , a8 out nocopy JTF_NUMBER_TABLE
56: , a9 out nocopy JTF_VARCHAR2_TABLE_100
51: , a4 out nocopy JTF_NUMBER_TABLE
52: , a5 out nocopy JTF_NUMBER_TABLE
53: , a6 out nocopy JTF_VARCHAR2_TABLE_100
54: , a7 out nocopy JTF_VARCHAR2_TABLE_100
55: , a8 out nocopy JTF_NUMBER_TABLE
56: , a9 out nocopy JTF_VARCHAR2_TABLE_100
57: , a10 out nocopy JTF_VARCHAR2_TABLE_100
58: , a11 out nocopy JTF_VARCHAR2_TABLE_100
59: , a12 out nocopy JTF_DATE_TABLE
56: , a9 out nocopy JTF_VARCHAR2_TABLE_100
57: , a10 out nocopy JTF_VARCHAR2_TABLE_100
58: , a11 out nocopy JTF_VARCHAR2_TABLE_100
59: , a12 out nocopy JTF_DATE_TABLE
60: , a13 out nocopy JTF_NUMBER_TABLE
61: , a14 out nocopy JTF_VARCHAR2_TABLE_100
62: , a15 out nocopy JTF_VARCHAR2_TABLE_100
63: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
64: , a17 out nocopy JTF_VARCHAR2_TABLE_100
63: , a16 out nocopy JTF_VARCHAR2_TABLE_2000
64: , a17 out nocopy JTF_VARCHAR2_TABLE_100
65: , a18 out nocopy JTF_DATE_TABLE
66: , a19 out nocopy JTF_VARCHAR2_TABLE_100
67: , a20 out nocopy JTF_NUMBER_TABLE
68: , a21 out nocopy JTF_VARCHAR2_TABLE_100
69: , a22 out nocopy JTF_VARCHAR2_TABLE_500
70: , a23 out nocopy JTF_VARCHAR2_TABLE_500
71: , a24 out nocopy JTF_VARCHAR2_TABLE_500
80: , a33 out nocopy JTF_VARCHAR2_TABLE_500
81: , a34 out nocopy JTF_VARCHAR2_TABLE_500
82: , a35 out nocopy JTF_VARCHAR2_TABLE_500
83: , a36 out nocopy JTF_VARCHAR2_TABLE_500
84: , a37 out nocopy JTF_NUMBER_TABLE
85: , a38 out nocopy JTF_DATE_TABLE
86: , a39 out nocopy JTF_NUMBER_TABLE
87: , a40 out nocopy JTF_DATE_TABLE
88: , a41 out nocopy JTF_NUMBER_TABLE
82: , a35 out nocopy JTF_VARCHAR2_TABLE_500
83: , a36 out nocopy JTF_VARCHAR2_TABLE_500
84: , a37 out nocopy JTF_NUMBER_TABLE
85: , a38 out nocopy JTF_DATE_TABLE
86: , a39 out nocopy JTF_NUMBER_TABLE
87: , a40 out nocopy JTF_DATE_TABLE
88: , a41 out nocopy JTF_NUMBER_TABLE
89: , a42 out nocopy JTF_VARCHAR2_TABLE_100
90: );
84: , a37 out nocopy JTF_NUMBER_TABLE
85: , a38 out nocopy JTF_DATE_TABLE
86: , a39 out nocopy JTF_NUMBER_TABLE
87: , a40 out nocopy JTF_DATE_TABLE
88: , a41 out nocopy JTF_NUMBER_TABLE
89: , a42 out nocopy JTF_VARCHAR2_TABLE_100
90: );
91:
92: procedure rosetta_table_copy_in_p5(t out nocopy okl_avl_pvt.avlv_tbl_type, a0 JTF_NUMBER_TABLE
88: , a41 out nocopy JTF_NUMBER_TABLE
89: , a42 out nocopy JTF_VARCHAR2_TABLE_100
90: );
91:
92: procedure rosetta_table_copy_in_p5(t out nocopy okl_avl_pvt.avlv_tbl_type, a0 JTF_NUMBER_TABLE
93: , a1 JTF_NUMBER_TABLE
94: , a2 JTF_NUMBER_TABLE
95: , a3 JTF_NUMBER_TABLE
96: , a4 JTF_NUMBER_TABLE
89: , a42 out nocopy JTF_VARCHAR2_TABLE_100
90: );
91:
92: procedure rosetta_table_copy_in_p5(t out nocopy okl_avl_pvt.avlv_tbl_type, a0 JTF_NUMBER_TABLE
93: , a1 JTF_NUMBER_TABLE
94: , a2 JTF_NUMBER_TABLE
95: , a3 JTF_NUMBER_TABLE
96: , a4 JTF_NUMBER_TABLE
97: , a5 JTF_NUMBER_TABLE
90: );
91:
92: procedure rosetta_table_copy_in_p5(t out nocopy okl_avl_pvt.avlv_tbl_type, a0 JTF_NUMBER_TABLE
93: , a1 JTF_NUMBER_TABLE
94: , a2 JTF_NUMBER_TABLE
95: , a3 JTF_NUMBER_TABLE
96: , a4 JTF_NUMBER_TABLE
97: , a5 JTF_NUMBER_TABLE
98: , a6 JTF_NUMBER_TABLE
91:
92: procedure rosetta_table_copy_in_p5(t out nocopy okl_avl_pvt.avlv_tbl_type, a0 JTF_NUMBER_TABLE
93: , a1 JTF_NUMBER_TABLE
94: , a2 JTF_NUMBER_TABLE
95: , a3 JTF_NUMBER_TABLE
96: , a4 JTF_NUMBER_TABLE
97: , a5 JTF_NUMBER_TABLE
98: , a6 JTF_NUMBER_TABLE
99: , a7 JTF_VARCHAR2_TABLE_100
92: procedure rosetta_table_copy_in_p5(t out nocopy okl_avl_pvt.avlv_tbl_type, a0 JTF_NUMBER_TABLE
93: , a1 JTF_NUMBER_TABLE
94: , a2 JTF_NUMBER_TABLE
95: , a3 JTF_NUMBER_TABLE
96: , a4 JTF_NUMBER_TABLE
97: , a5 JTF_NUMBER_TABLE
98: , a6 JTF_NUMBER_TABLE
99: , a7 JTF_VARCHAR2_TABLE_100
100: , a8 JTF_VARCHAR2_TABLE_100
93: , a1 JTF_NUMBER_TABLE
94: , a2 JTF_NUMBER_TABLE
95: , a3 JTF_NUMBER_TABLE
96: , a4 JTF_NUMBER_TABLE
97: , a5 JTF_NUMBER_TABLE
98: , a6 JTF_NUMBER_TABLE
99: , a7 JTF_VARCHAR2_TABLE_100
100: , a8 JTF_VARCHAR2_TABLE_100
101: , a9 JTF_VARCHAR2_TABLE_100
94: , a2 JTF_NUMBER_TABLE
95: , a3 JTF_NUMBER_TABLE
96: , a4 JTF_NUMBER_TABLE
97: , a5 JTF_NUMBER_TABLE
98: , a6 JTF_NUMBER_TABLE
99: , a7 JTF_VARCHAR2_TABLE_100
100: , a8 JTF_VARCHAR2_TABLE_100
101: , a9 JTF_VARCHAR2_TABLE_100
102: , a10 JTF_VARCHAR2_TABLE_100
124: , a32 JTF_VARCHAR2_TABLE_500
125: , a33 JTF_VARCHAR2_TABLE_500
126: , a34 JTF_VARCHAR2_TABLE_500
127: , a35 JTF_VARCHAR2_TABLE_500
128: , a36 JTF_NUMBER_TABLE
129: , a37 JTF_NUMBER_TABLE
130: , a38 JTF_DATE_TABLE
131: , a39 JTF_NUMBER_TABLE
132: , a40 JTF_DATE_TABLE
125: , a33 JTF_VARCHAR2_TABLE_500
126: , a34 JTF_VARCHAR2_TABLE_500
127: , a35 JTF_VARCHAR2_TABLE_500
128: , a36 JTF_NUMBER_TABLE
129: , a37 JTF_NUMBER_TABLE
130: , a38 JTF_DATE_TABLE
131: , a39 JTF_NUMBER_TABLE
132: , a40 JTF_DATE_TABLE
133: , a41 JTF_NUMBER_TABLE
127: , a35 JTF_VARCHAR2_TABLE_500
128: , a36 JTF_NUMBER_TABLE
129: , a37 JTF_NUMBER_TABLE
130: , a38 JTF_DATE_TABLE
131: , a39 JTF_NUMBER_TABLE
132: , a40 JTF_DATE_TABLE
133: , a41 JTF_NUMBER_TABLE
134: , a42 JTF_VARCHAR2_TABLE_100
135: );
129: , a37 JTF_NUMBER_TABLE
130: , a38 JTF_DATE_TABLE
131: , a39 JTF_NUMBER_TABLE
132: , a40 JTF_DATE_TABLE
133: , a41 JTF_NUMBER_TABLE
134: , a42 JTF_VARCHAR2_TABLE_100
135: );
136: procedure rosetta_table_copy_out_p5(t okl_avl_pvt.avlv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
137: , a1 out nocopy JTF_NUMBER_TABLE
132: , a40 JTF_DATE_TABLE
133: , a41 JTF_NUMBER_TABLE
134: , a42 JTF_VARCHAR2_TABLE_100
135: );
136: procedure rosetta_table_copy_out_p5(t okl_avl_pvt.avlv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
137: , a1 out nocopy JTF_NUMBER_TABLE
138: , a2 out nocopy JTF_NUMBER_TABLE
139: , a3 out nocopy JTF_NUMBER_TABLE
140: , a4 out nocopy JTF_NUMBER_TABLE
133: , a41 JTF_NUMBER_TABLE
134: , a42 JTF_VARCHAR2_TABLE_100
135: );
136: procedure rosetta_table_copy_out_p5(t okl_avl_pvt.avlv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
137: , a1 out nocopy JTF_NUMBER_TABLE
138: , a2 out nocopy JTF_NUMBER_TABLE
139: , a3 out nocopy JTF_NUMBER_TABLE
140: , a4 out nocopy JTF_NUMBER_TABLE
141: , a5 out nocopy JTF_NUMBER_TABLE
134: , a42 JTF_VARCHAR2_TABLE_100
135: );
136: procedure rosetta_table_copy_out_p5(t okl_avl_pvt.avlv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
137: , a1 out nocopy JTF_NUMBER_TABLE
138: , a2 out nocopy JTF_NUMBER_TABLE
139: , a3 out nocopy JTF_NUMBER_TABLE
140: , a4 out nocopy JTF_NUMBER_TABLE
141: , a5 out nocopy JTF_NUMBER_TABLE
142: , a6 out nocopy JTF_NUMBER_TABLE
135: );
136: procedure rosetta_table_copy_out_p5(t okl_avl_pvt.avlv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
137: , a1 out nocopy JTF_NUMBER_TABLE
138: , a2 out nocopy JTF_NUMBER_TABLE
139: , a3 out nocopy JTF_NUMBER_TABLE
140: , a4 out nocopy JTF_NUMBER_TABLE
141: , a5 out nocopy JTF_NUMBER_TABLE
142: , a6 out nocopy JTF_NUMBER_TABLE
143: , a7 out nocopy JTF_VARCHAR2_TABLE_100
136: procedure rosetta_table_copy_out_p5(t okl_avl_pvt.avlv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
137: , a1 out nocopy JTF_NUMBER_TABLE
138: , a2 out nocopy JTF_NUMBER_TABLE
139: , a3 out nocopy JTF_NUMBER_TABLE
140: , a4 out nocopy JTF_NUMBER_TABLE
141: , a5 out nocopy JTF_NUMBER_TABLE
142: , a6 out nocopy JTF_NUMBER_TABLE
143: , a7 out nocopy JTF_VARCHAR2_TABLE_100
144: , a8 out nocopy JTF_VARCHAR2_TABLE_100
137: , a1 out nocopy JTF_NUMBER_TABLE
138: , a2 out nocopy JTF_NUMBER_TABLE
139: , a3 out nocopy JTF_NUMBER_TABLE
140: , a4 out nocopy JTF_NUMBER_TABLE
141: , a5 out nocopy JTF_NUMBER_TABLE
142: , a6 out nocopy JTF_NUMBER_TABLE
143: , a7 out nocopy JTF_VARCHAR2_TABLE_100
144: , a8 out nocopy JTF_VARCHAR2_TABLE_100
145: , a9 out nocopy JTF_VARCHAR2_TABLE_100
138: , a2 out nocopy JTF_NUMBER_TABLE
139: , a3 out nocopy JTF_NUMBER_TABLE
140: , a4 out nocopy JTF_NUMBER_TABLE
141: , a5 out nocopy JTF_NUMBER_TABLE
142: , a6 out nocopy JTF_NUMBER_TABLE
143: , a7 out nocopy JTF_VARCHAR2_TABLE_100
144: , a8 out nocopy JTF_VARCHAR2_TABLE_100
145: , a9 out nocopy JTF_VARCHAR2_TABLE_100
146: , a10 out nocopy JTF_VARCHAR2_TABLE_100
168: , a32 out nocopy JTF_VARCHAR2_TABLE_500
169: , a33 out nocopy JTF_VARCHAR2_TABLE_500
170: , a34 out nocopy JTF_VARCHAR2_TABLE_500
171: , a35 out nocopy JTF_VARCHAR2_TABLE_500
172: , a36 out nocopy JTF_NUMBER_TABLE
173: , a37 out nocopy JTF_NUMBER_TABLE
174: , a38 out nocopy JTF_DATE_TABLE
175: , a39 out nocopy JTF_NUMBER_TABLE
176: , a40 out nocopy JTF_DATE_TABLE
169: , a33 out nocopy JTF_VARCHAR2_TABLE_500
170: , a34 out nocopy JTF_VARCHAR2_TABLE_500
171: , a35 out nocopy JTF_VARCHAR2_TABLE_500
172: , a36 out nocopy JTF_NUMBER_TABLE
173: , a37 out nocopy JTF_NUMBER_TABLE
174: , a38 out nocopy JTF_DATE_TABLE
175: , a39 out nocopy JTF_NUMBER_TABLE
176: , a40 out nocopy JTF_DATE_TABLE
177: , a41 out nocopy JTF_NUMBER_TABLE
171: , a35 out nocopy JTF_VARCHAR2_TABLE_500
172: , a36 out nocopy JTF_NUMBER_TABLE
173: , a37 out nocopy JTF_NUMBER_TABLE
174: , a38 out nocopy JTF_DATE_TABLE
175: , a39 out nocopy JTF_NUMBER_TABLE
176: , a40 out nocopy JTF_DATE_TABLE
177: , a41 out nocopy JTF_NUMBER_TABLE
178: , a42 out nocopy JTF_VARCHAR2_TABLE_100
179: );
173: , a37 out nocopy JTF_NUMBER_TABLE
174: , a38 out nocopy JTF_DATE_TABLE
175: , a39 out nocopy JTF_NUMBER_TABLE
176: , a40 out nocopy JTF_DATE_TABLE
177: , a41 out nocopy JTF_NUMBER_TABLE
178: , a42 out nocopy JTF_VARCHAR2_TABLE_100
179: );
180:
181: procedure insert_row(p_api_version NUMBER
274: , p_init_msg_list VARCHAR2
275: , x_return_status out nocopy VARCHAR2
276: , x_msg_count out nocopy NUMBER
277: , x_msg_data out nocopy VARCHAR2
278: , p5_a0 JTF_NUMBER_TABLE
279: , p5_a1 JTF_NUMBER_TABLE
280: , p5_a2 JTF_NUMBER_TABLE
281: , p5_a3 JTF_NUMBER_TABLE
282: , p5_a4 JTF_NUMBER_TABLE
275: , x_return_status out nocopy VARCHAR2
276: , x_msg_count out nocopy NUMBER
277: , x_msg_data out nocopy VARCHAR2
278: , p5_a0 JTF_NUMBER_TABLE
279: , p5_a1 JTF_NUMBER_TABLE
280: , p5_a2 JTF_NUMBER_TABLE
281: , p5_a3 JTF_NUMBER_TABLE
282: , p5_a4 JTF_NUMBER_TABLE
283: , p5_a5 JTF_NUMBER_TABLE
276: , x_msg_count out nocopy NUMBER
277: , x_msg_data out nocopy VARCHAR2
278: , p5_a0 JTF_NUMBER_TABLE
279: , p5_a1 JTF_NUMBER_TABLE
280: , p5_a2 JTF_NUMBER_TABLE
281: , p5_a3 JTF_NUMBER_TABLE
282: , p5_a4 JTF_NUMBER_TABLE
283: , p5_a5 JTF_NUMBER_TABLE
284: , p5_a6 JTF_NUMBER_TABLE
277: , x_msg_data out nocopy VARCHAR2
278: , p5_a0 JTF_NUMBER_TABLE
279: , p5_a1 JTF_NUMBER_TABLE
280: , p5_a2 JTF_NUMBER_TABLE
281: , p5_a3 JTF_NUMBER_TABLE
282: , p5_a4 JTF_NUMBER_TABLE
283: , p5_a5 JTF_NUMBER_TABLE
284: , p5_a6 JTF_NUMBER_TABLE
285: , p5_a7 JTF_VARCHAR2_TABLE_100
278: , p5_a0 JTF_NUMBER_TABLE
279: , p5_a1 JTF_NUMBER_TABLE
280: , p5_a2 JTF_NUMBER_TABLE
281: , p5_a3 JTF_NUMBER_TABLE
282: , p5_a4 JTF_NUMBER_TABLE
283: , p5_a5 JTF_NUMBER_TABLE
284: , p5_a6 JTF_NUMBER_TABLE
285: , p5_a7 JTF_VARCHAR2_TABLE_100
286: , p5_a8 JTF_VARCHAR2_TABLE_100
279: , p5_a1 JTF_NUMBER_TABLE
280: , p5_a2 JTF_NUMBER_TABLE
281: , p5_a3 JTF_NUMBER_TABLE
282: , p5_a4 JTF_NUMBER_TABLE
283: , p5_a5 JTF_NUMBER_TABLE
284: , p5_a6 JTF_NUMBER_TABLE
285: , p5_a7 JTF_VARCHAR2_TABLE_100
286: , p5_a8 JTF_VARCHAR2_TABLE_100
287: , p5_a9 JTF_VARCHAR2_TABLE_100
280: , p5_a2 JTF_NUMBER_TABLE
281: , p5_a3 JTF_NUMBER_TABLE
282: , p5_a4 JTF_NUMBER_TABLE
283: , p5_a5 JTF_NUMBER_TABLE
284: , p5_a6 JTF_NUMBER_TABLE
285: , p5_a7 JTF_VARCHAR2_TABLE_100
286: , p5_a8 JTF_VARCHAR2_TABLE_100
287: , p5_a9 JTF_VARCHAR2_TABLE_100
288: , p5_a10 JTF_VARCHAR2_TABLE_100
310: , p5_a32 JTF_VARCHAR2_TABLE_500
311: , p5_a33 JTF_VARCHAR2_TABLE_500
312: , p5_a34 JTF_VARCHAR2_TABLE_500
313: , p5_a35 JTF_VARCHAR2_TABLE_500
314: , p5_a36 JTF_NUMBER_TABLE
315: , p5_a37 JTF_NUMBER_TABLE
316: , p5_a38 JTF_DATE_TABLE
317: , p5_a39 JTF_NUMBER_TABLE
318: , p5_a40 JTF_DATE_TABLE
311: , p5_a33 JTF_VARCHAR2_TABLE_500
312: , p5_a34 JTF_VARCHAR2_TABLE_500
313: , p5_a35 JTF_VARCHAR2_TABLE_500
314: , p5_a36 JTF_NUMBER_TABLE
315: , p5_a37 JTF_NUMBER_TABLE
316: , p5_a38 JTF_DATE_TABLE
317: , p5_a39 JTF_NUMBER_TABLE
318: , p5_a40 JTF_DATE_TABLE
319: , p5_a41 JTF_NUMBER_TABLE
313: , p5_a35 JTF_VARCHAR2_TABLE_500
314: , p5_a36 JTF_NUMBER_TABLE
315: , p5_a37 JTF_NUMBER_TABLE
316: , p5_a38 JTF_DATE_TABLE
317: , p5_a39 JTF_NUMBER_TABLE
318: , p5_a40 JTF_DATE_TABLE
319: , p5_a41 JTF_NUMBER_TABLE
320: , p5_a42 JTF_VARCHAR2_TABLE_100
321: , p6_a0 out nocopy JTF_NUMBER_TABLE
315: , p5_a37 JTF_NUMBER_TABLE
316: , p5_a38 JTF_DATE_TABLE
317: , p5_a39 JTF_NUMBER_TABLE
318: , p5_a40 JTF_DATE_TABLE
319: , p5_a41 JTF_NUMBER_TABLE
320: , p5_a42 JTF_VARCHAR2_TABLE_100
321: , p6_a0 out nocopy JTF_NUMBER_TABLE
322: , p6_a1 out nocopy JTF_NUMBER_TABLE
323: , p6_a2 out nocopy JTF_NUMBER_TABLE
317: , p5_a39 JTF_NUMBER_TABLE
318: , p5_a40 JTF_DATE_TABLE
319: , p5_a41 JTF_NUMBER_TABLE
320: , p5_a42 JTF_VARCHAR2_TABLE_100
321: , p6_a0 out nocopy JTF_NUMBER_TABLE
322: , p6_a1 out nocopy JTF_NUMBER_TABLE
323: , p6_a2 out nocopy JTF_NUMBER_TABLE
324: , p6_a3 out nocopy JTF_NUMBER_TABLE
325: , p6_a4 out nocopy JTF_NUMBER_TABLE
318: , p5_a40 JTF_DATE_TABLE
319: , p5_a41 JTF_NUMBER_TABLE
320: , p5_a42 JTF_VARCHAR2_TABLE_100
321: , p6_a0 out nocopy JTF_NUMBER_TABLE
322: , p6_a1 out nocopy JTF_NUMBER_TABLE
323: , p6_a2 out nocopy JTF_NUMBER_TABLE
324: , p6_a3 out nocopy JTF_NUMBER_TABLE
325: , p6_a4 out nocopy JTF_NUMBER_TABLE
326: , p6_a5 out nocopy JTF_NUMBER_TABLE
319: , p5_a41 JTF_NUMBER_TABLE
320: , p5_a42 JTF_VARCHAR2_TABLE_100
321: , p6_a0 out nocopy JTF_NUMBER_TABLE
322: , p6_a1 out nocopy JTF_NUMBER_TABLE
323: , p6_a2 out nocopy JTF_NUMBER_TABLE
324: , p6_a3 out nocopy JTF_NUMBER_TABLE
325: , p6_a4 out nocopy JTF_NUMBER_TABLE
326: , p6_a5 out nocopy JTF_NUMBER_TABLE
327: , p6_a6 out nocopy JTF_NUMBER_TABLE
320: , p5_a42 JTF_VARCHAR2_TABLE_100
321: , p6_a0 out nocopy JTF_NUMBER_TABLE
322: , p6_a1 out nocopy JTF_NUMBER_TABLE
323: , p6_a2 out nocopy JTF_NUMBER_TABLE
324: , p6_a3 out nocopy JTF_NUMBER_TABLE
325: , p6_a4 out nocopy JTF_NUMBER_TABLE
326: , p6_a5 out nocopy JTF_NUMBER_TABLE
327: , p6_a6 out nocopy JTF_NUMBER_TABLE
328: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
321: , p6_a0 out nocopy JTF_NUMBER_TABLE
322: , p6_a1 out nocopy JTF_NUMBER_TABLE
323: , p6_a2 out nocopy JTF_NUMBER_TABLE
324: , p6_a3 out nocopy JTF_NUMBER_TABLE
325: , p6_a4 out nocopy JTF_NUMBER_TABLE
326: , p6_a5 out nocopy JTF_NUMBER_TABLE
327: , p6_a6 out nocopy JTF_NUMBER_TABLE
328: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
329: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
322: , p6_a1 out nocopy JTF_NUMBER_TABLE
323: , p6_a2 out nocopy JTF_NUMBER_TABLE
324: , p6_a3 out nocopy JTF_NUMBER_TABLE
325: , p6_a4 out nocopy JTF_NUMBER_TABLE
326: , p6_a5 out nocopy JTF_NUMBER_TABLE
327: , p6_a6 out nocopy JTF_NUMBER_TABLE
328: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
329: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
330: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
323: , p6_a2 out nocopy JTF_NUMBER_TABLE
324: , p6_a3 out nocopy JTF_NUMBER_TABLE
325: , p6_a4 out nocopy JTF_NUMBER_TABLE
326: , p6_a5 out nocopy JTF_NUMBER_TABLE
327: , p6_a6 out nocopy JTF_NUMBER_TABLE
328: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
329: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
330: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
331: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
353: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
354: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
355: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
356: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
357: , p6_a36 out nocopy JTF_NUMBER_TABLE
358: , p6_a37 out nocopy JTF_NUMBER_TABLE
359: , p6_a38 out nocopy JTF_DATE_TABLE
360: , p6_a39 out nocopy JTF_NUMBER_TABLE
361: , p6_a40 out nocopy JTF_DATE_TABLE
354: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
355: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
356: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
357: , p6_a36 out nocopy JTF_NUMBER_TABLE
358: , p6_a37 out nocopy JTF_NUMBER_TABLE
359: , p6_a38 out nocopy JTF_DATE_TABLE
360: , p6_a39 out nocopy JTF_NUMBER_TABLE
361: , p6_a40 out nocopy JTF_DATE_TABLE
362: , p6_a41 out nocopy JTF_NUMBER_TABLE
356: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
357: , p6_a36 out nocopy JTF_NUMBER_TABLE
358: , p6_a37 out nocopy JTF_NUMBER_TABLE
359: , p6_a38 out nocopy JTF_DATE_TABLE
360: , p6_a39 out nocopy JTF_NUMBER_TABLE
361: , p6_a40 out nocopy JTF_DATE_TABLE
362: , p6_a41 out nocopy JTF_NUMBER_TABLE
363: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
364: );
358: , p6_a37 out nocopy JTF_NUMBER_TABLE
359: , p6_a38 out nocopy JTF_DATE_TABLE
360: , p6_a39 out nocopy JTF_NUMBER_TABLE
361: , p6_a40 out nocopy JTF_DATE_TABLE
362: , p6_a41 out nocopy JTF_NUMBER_TABLE
363: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
364: );
365: procedure lock_row(p_api_version NUMBER
366: , p_init_msg_list VARCHAR2
415: , p_init_msg_list VARCHAR2
416: , x_return_status out nocopy VARCHAR2
417: , x_msg_count out nocopy NUMBER
418: , x_msg_data out nocopy VARCHAR2
419: , p5_a0 JTF_NUMBER_TABLE
420: , p5_a1 JTF_NUMBER_TABLE
421: , p5_a2 JTF_NUMBER_TABLE
422: , p5_a3 JTF_NUMBER_TABLE
423: , p5_a4 JTF_NUMBER_TABLE
416: , x_return_status out nocopy VARCHAR2
417: , x_msg_count out nocopy NUMBER
418: , x_msg_data out nocopy VARCHAR2
419: , p5_a0 JTF_NUMBER_TABLE
420: , p5_a1 JTF_NUMBER_TABLE
421: , p5_a2 JTF_NUMBER_TABLE
422: , p5_a3 JTF_NUMBER_TABLE
423: , p5_a4 JTF_NUMBER_TABLE
424: , p5_a5 JTF_NUMBER_TABLE
417: , x_msg_count out nocopy NUMBER
418: , x_msg_data out nocopy VARCHAR2
419: , p5_a0 JTF_NUMBER_TABLE
420: , p5_a1 JTF_NUMBER_TABLE
421: , p5_a2 JTF_NUMBER_TABLE
422: , p5_a3 JTF_NUMBER_TABLE
423: , p5_a4 JTF_NUMBER_TABLE
424: , p5_a5 JTF_NUMBER_TABLE
425: , p5_a6 JTF_NUMBER_TABLE
418: , x_msg_data out nocopy VARCHAR2
419: , p5_a0 JTF_NUMBER_TABLE
420: , p5_a1 JTF_NUMBER_TABLE
421: , p5_a2 JTF_NUMBER_TABLE
422: , p5_a3 JTF_NUMBER_TABLE
423: , p5_a4 JTF_NUMBER_TABLE
424: , p5_a5 JTF_NUMBER_TABLE
425: , p5_a6 JTF_NUMBER_TABLE
426: , p5_a7 JTF_VARCHAR2_TABLE_100
419: , p5_a0 JTF_NUMBER_TABLE
420: , p5_a1 JTF_NUMBER_TABLE
421: , p5_a2 JTF_NUMBER_TABLE
422: , p5_a3 JTF_NUMBER_TABLE
423: , p5_a4 JTF_NUMBER_TABLE
424: , p5_a5 JTF_NUMBER_TABLE
425: , p5_a6 JTF_NUMBER_TABLE
426: , p5_a7 JTF_VARCHAR2_TABLE_100
427: , p5_a8 JTF_VARCHAR2_TABLE_100
420: , p5_a1 JTF_NUMBER_TABLE
421: , p5_a2 JTF_NUMBER_TABLE
422: , p5_a3 JTF_NUMBER_TABLE
423: , p5_a4 JTF_NUMBER_TABLE
424: , p5_a5 JTF_NUMBER_TABLE
425: , p5_a6 JTF_NUMBER_TABLE
426: , p5_a7 JTF_VARCHAR2_TABLE_100
427: , p5_a8 JTF_VARCHAR2_TABLE_100
428: , p5_a9 JTF_VARCHAR2_TABLE_100
421: , p5_a2 JTF_NUMBER_TABLE
422: , p5_a3 JTF_NUMBER_TABLE
423: , p5_a4 JTF_NUMBER_TABLE
424: , p5_a5 JTF_NUMBER_TABLE
425: , p5_a6 JTF_NUMBER_TABLE
426: , p5_a7 JTF_VARCHAR2_TABLE_100
427: , p5_a8 JTF_VARCHAR2_TABLE_100
428: , p5_a9 JTF_VARCHAR2_TABLE_100
429: , p5_a10 JTF_VARCHAR2_TABLE_100
451: , p5_a32 JTF_VARCHAR2_TABLE_500
452: , p5_a33 JTF_VARCHAR2_TABLE_500
453: , p5_a34 JTF_VARCHAR2_TABLE_500
454: , p5_a35 JTF_VARCHAR2_TABLE_500
455: , p5_a36 JTF_NUMBER_TABLE
456: , p5_a37 JTF_NUMBER_TABLE
457: , p5_a38 JTF_DATE_TABLE
458: , p5_a39 JTF_NUMBER_TABLE
459: , p5_a40 JTF_DATE_TABLE
452: , p5_a33 JTF_VARCHAR2_TABLE_500
453: , p5_a34 JTF_VARCHAR2_TABLE_500
454: , p5_a35 JTF_VARCHAR2_TABLE_500
455: , p5_a36 JTF_NUMBER_TABLE
456: , p5_a37 JTF_NUMBER_TABLE
457: , p5_a38 JTF_DATE_TABLE
458: , p5_a39 JTF_NUMBER_TABLE
459: , p5_a40 JTF_DATE_TABLE
460: , p5_a41 JTF_NUMBER_TABLE
454: , p5_a35 JTF_VARCHAR2_TABLE_500
455: , p5_a36 JTF_NUMBER_TABLE
456: , p5_a37 JTF_NUMBER_TABLE
457: , p5_a38 JTF_DATE_TABLE
458: , p5_a39 JTF_NUMBER_TABLE
459: , p5_a40 JTF_DATE_TABLE
460: , p5_a41 JTF_NUMBER_TABLE
461: , p5_a42 JTF_VARCHAR2_TABLE_100
462: );
456: , p5_a37 JTF_NUMBER_TABLE
457: , p5_a38 JTF_DATE_TABLE
458: , p5_a39 JTF_NUMBER_TABLE
459: , p5_a40 JTF_DATE_TABLE
460: , p5_a41 JTF_NUMBER_TABLE
461: , p5_a42 JTF_VARCHAR2_TABLE_100
462: );
463: procedure update_row(p_api_version NUMBER
464: , p_init_msg_list VARCHAR2
556: , p_init_msg_list VARCHAR2
557: , x_return_status out nocopy VARCHAR2
558: , x_msg_count out nocopy NUMBER
559: , x_msg_data out nocopy VARCHAR2
560: , p5_a0 JTF_NUMBER_TABLE
561: , p5_a1 JTF_NUMBER_TABLE
562: , p5_a2 JTF_NUMBER_TABLE
563: , p5_a3 JTF_NUMBER_TABLE
564: , p5_a4 JTF_NUMBER_TABLE
557: , x_return_status out nocopy VARCHAR2
558: , x_msg_count out nocopy NUMBER
559: , x_msg_data out nocopy VARCHAR2
560: , p5_a0 JTF_NUMBER_TABLE
561: , p5_a1 JTF_NUMBER_TABLE
562: , p5_a2 JTF_NUMBER_TABLE
563: , p5_a3 JTF_NUMBER_TABLE
564: , p5_a4 JTF_NUMBER_TABLE
565: , p5_a5 JTF_NUMBER_TABLE
558: , x_msg_count out nocopy NUMBER
559: , x_msg_data out nocopy VARCHAR2
560: , p5_a0 JTF_NUMBER_TABLE
561: , p5_a1 JTF_NUMBER_TABLE
562: , p5_a2 JTF_NUMBER_TABLE
563: , p5_a3 JTF_NUMBER_TABLE
564: , p5_a4 JTF_NUMBER_TABLE
565: , p5_a5 JTF_NUMBER_TABLE
566: , p5_a6 JTF_NUMBER_TABLE
559: , x_msg_data out nocopy VARCHAR2
560: , p5_a0 JTF_NUMBER_TABLE
561: , p5_a1 JTF_NUMBER_TABLE
562: , p5_a2 JTF_NUMBER_TABLE
563: , p5_a3 JTF_NUMBER_TABLE
564: , p5_a4 JTF_NUMBER_TABLE
565: , p5_a5 JTF_NUMBER_TABLE
566: , p5_a6 JTF_NUMBER_TABLE
567: , p5_a7 JTF_VARCHAR2_TABLE_100
560: , p5_a0 JTF_NUMBER_TABLE
561: , p5_a1 JTF_NUMBER_TABLE
562: , p5_a2 JTF_NUMBER_TABLE
563: , p5_a3 JTF_NUMBER_TABLE
564: , p5_a4 JTF_NUMBER_TABLE
565: , p5_a5 JTF_NUMBER_TABLE
566: , p5_a6 JTF_NUMBER_TABLE
567: , p5_a7 JTF_VARCHAR2_TABLE_100
568: , p5_a8 JTF_VARCHAR2_TABLE_100
561: , p5_a1 JTF_NUMBER_TABLE
562: , p5_a2 JTF_NUMBER_TABLE
563: , p5_a3 JTF_NUMBER_TABLE
564: , p5_a4 JTF_NUMBER_TABLE
565: , p5_a5 JTF_NUMBER_TABLE
566: , p5_a6 JTF_NUMBER_TABLE
567: , p5_a7 JTF_VARCHAR2_TABLE_100
568: , p5_a8 JTF_VARCHAR2_TABLE_100
569: , p5_a9 JTF_VARCHAR2_TABLE_100
562: , p5_a2 JTF_NUMBER_TABLE
563: , p5_a3 JTF_NUMBER_TABLE
564: , p5_a4 JTF_NUMBER_TABLE
565: , p5_a5 JTF_NUMBER_TABLE
566: , p5_a6 JTF_NUMBER_TABLE
567: , p5_a7 JTF_VARCHAR2_TABLE_100
568: , p5_a8 JTF_VARCHAR2_TABLE_100
569: , p5_a9 JTF_VARCHAR2_TABLE_100
570: , p5_a10 JTF_VARCHAR2_TABLE_100
592: , p5_a32 JTF_VARCHAR2_TABLE_500
593: , p5_a33 JTF_VARCHAR2_TABLE_500
594: , p5_a34 JTF_VARCHAR2_TABLE_500
595: , p5_a35 JTF_VARCHAR2_TABLE_500
596: , p5_a36 JTF_NUMBER_TABLE
597: , p5_a37 JTF_NUMBER_TABLE
598: , p5_a38 JTF_DATE_TABLE
599: , p5_a39 JTF_NUMBER_TABLE
600: , p5_a40 JTF_DATE_TABLE
593: , p5_a33 JTF_VARCHAR2_TABLE_500
594: , p5_a34 JTF_VARCHAR2_TABLE_500
595: , p5_a35 JTF_VARCHAR2_TABLE_500
596: , p5_a36 JTF_NUMBER_TABLE
597: , p5_a37 JTF_NUMBER_TABLE
598: , p5_a38 JTF_DATE_TABLE
599: , p5_a39 JTF_NUMBER_TABLE
600: , p5_a40 JTF_DATE_TABLE
601: , p5_a41 JTF_NUMBER_TABLE
595: , p5_a35 JTF_VARCHAR2_TABLE_500
596: , p5_a36 JTF_NUMBER_TABLE
597: , p5_a37 JTF_NUMBER_TABLE
598: , p5_a38 JTF_DATE_TABLE
599: , p5_a39 JTF_NUMBER_TABLE
600: , p5_a40 JTF_DATE_TABLE
601: , p5_a41 JTF_NUMBER_TABLE
602: , p5_a42 JTF_VARCHAR2_TABLE_100
603: , p6_a0 out nocopy JTF_NUMBER_TABLE
597: , p5_a37 JTF_NUMBER_TABLE
598: , p5_a38 JTF_DATE_TABLE
599: , p5_a39 JTF_NUMBER_TABLE
600: , p5_a40 JTF_DATE_TABLE
601: , p5_a41 JTF_NUMBER_TABLE
602: , p5_a42 JTF_VARCHAR2_TABLE_100
603: , p6_a0 out nocopy JTF_NUMBER_TABLE
604: , p6_a1 out nocopy JTF_NUMBER_TABLE
605: , p6_a2 out nocopy JTF_NUMBER_TABLE
599: , p5_a39 JTF_NUMBER_TABLE
600: , p5_a40 JTF_DATE_TABLE
601: , p5_a41 JTF_NUMBER_TABLE
602: , p5_a42 JTF_VARCHAR2_TABLE_100
603: , p6_a0 out nocopy JTF_NUMBER_TABLE
604: , p6_a1 out nocopy JTF_NUMBER_TABLE
605: , p6_a2 out nocopy JTF_NUMBER_TABLE
606: , p6_a3 out nocopy JTF_NUMBER_TABLE
607: , p6_a4 out nocopy JTF_NUMBER_TABLE
600: , p5_a40 JTF_DATE_TABLE
601: , p5_a41 JTF_NUMBER_TABLE
602: , p5_a42 JTF_VARCHAR2_TABLE_100
603: , p6_a0 out nocopy JTF_NUMBER_TABLE
604: , p6_a1 out nocopy JTF_NUMBER_TABLE
605: , p6_a2 out nocopy JTF_NUMBER_TABLE
606: , p6_a3 out nocopy JTF_NUMBER_TABLE
607: , p6_a4 out nocopy JTF_NUMBER_TABLE
608: , p6_a5 out nocopy JTF_NUMBER_TABLE
601: , p5_a41 JTF_NUMBER_TABLE
602: , p5_a42 JTF_VARCHAR2_TABLE_100
603: , p6_a0 out nocopy JTF_NUMBER_TABLE
604: , p6_a1 out nocopy JTF_NUMBER_TABLE
605: , p6_a2 out nocopy JTF_NUMBER_TABLE
606: , p6_a3 out nocopy JTF_NUMBER_TABLE
607: , p6_a4 out nocopy JTF_NUMBER_TABLE
608: , p6_a5 out nocopy JTF_NUMBER_TABLE
609: , p6_a6 out nocopy JTF_NUMBER_TABLE
602: , p5_a42 JTF_VARCHAR2_TABLE_100
603: , p6_a0 out nocopy JTF_NUMBER_TABLE
604: , p6_a1 out nocopy JTF_NUMBER_TABLE
605: , p6_a2 out nocopy JTF_NUMBER_TABLE
606: , p6_a3 out nocopy JTF_NUMBER_TABLE
607: , p6_a4 out nocopy JTF_NUMBER_TABLE
608: , p6_a5 out nocopy JTF_NUMBER_TABLE
609: , p6_a6 out nocopy JTF_NUMBER_TABLE
610: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
603: , p6_a0 out nocopy JTF_NUMBER_TABLE
604: , p6_a1 out nocopy JTF_NUMBER_TABLE
605: , p6_a2 out nocopy JTF_NUMBER_TABLE
606: , p6_a3 out nocopy JTF_NUMBER_TABLE
607: , p6_a4 out nocopy JTF_NUMBER_TABLE
608: , p6_a5 out nocopy JTF_NUMBER_TABLE
609: , p6_a6 out nocopy JTF_NUMBER_TABLE
610: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
611: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
604: , p6_a1 out nocopy JTF_NUMBER_TABLE
605: , p6_a2 out nocopy JTF_NUMBER_TABLE
606: , p6_a3 out nocopy JTF_NUMBER_TABLE
607: , p6_a4 out nocopy JTF_NUMBER_TABLE
608: , p6_a5 out nocopy JTF_NUMBER_TABLE
609: , p6_a6 out nocopy JTF_NUMBER_TABLE
610: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
611: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
612: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
605: , p6_a2 out nocopy JTF_NUMBER_TABLE
606: , p6_a3 out nocopy JTF_NUMBER_TABLE
607: , p6_a4 out nocopy JTF_NUMBER_TABLE
608: , p6_a5 out nocopy JTF_NUMBER_TABLE
609: , p6_a6 out nocopy JTF_NUMBER_TABLE
610: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
611: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
612: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
613: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
635: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
636: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
637: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
638: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
639: , p6_a36 out nocopy JTF_NUMBER_TABLE
640: , p6_a37 out nocopy JTF_NUMBER_TABLE
641: , p6_a38 out nocopy JTF_DATE_TABLE
642: , p6_a39 out nocopy JTF_NUMBER_TABLE
643: , p6_a40 out nocopy JTF_DATE_TABLE
636: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
637: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
638: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
639: , p6_a36 out nocopy JTF_NUMBER_TABLE
640: , p6_a37 out nocopy JTF_NUMBER_TABLE
641: , p6_a38 out nocopy JTF_DATE_TABLE
642: , p6_a39 out nocopy JTF_NUMBER_TABLE
643: , p6_a40 out nocopy JTF_DATE_TABLE
644: , p6_a41 out nocopy JTF_NUMBER_TABLE
638: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_500
639: , p6_a36 out nocopy JTF_NUMBER_TABLE
640: , p6_a37 out nocopy JTF_NUMBER_TABLE
641: , p6_a38 out nocopy JTF_DATE_TABLE
642: , p6_a39 out nocopy JTF_NUMBER_TABLE
643: , p6_a40 out nocopy JTF_DATE_TABLE
644: , p6_a41 out nocopy JTF_NUMBER_TABLE
645: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
646: );
640: , p6_a37 out nocopy JTF_NUMBER_TABLE
641: , p6_a38 out nocopy JTF_DATE_TABLE
642: , p6_a39 out nocopy JTF_NUMBER_TABLE
643: , p6_a40 out nocopy JTF_DATE_TABLE
644: , p6_a41 out nocopy JTF_NUMBER_TABLE
645: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_100
646: );
647: procedure delete_row(p_api_version NUMBER
648: , p_init_msg_list VARCHAR2
697: , p_init_msg_list VARCHAR2
698: , x_return_status out nocopy VARCHAR2
699: , x_msg_count out nocopy NUMBER
700: , x_msg_data out nocopy VARCHAR2
701: , p5_a0 JTF_NUMBER_TABLE
702: , p5_a1 JTF_NUMBER_TABLE
703: , p5_a2 JTF_NUMBER_TABLE
704: , p5_a3 JTF_NUMBER_TABLE
705: , p5_a4 JTF_NUMBER_TABLE
698: , x_return_status out nocopy VARCHAR2
699: , x_msg_count out nocopy NUMBER
700: , x_msg_data out nocopy VARCHAR2
701: , p5_a0 JTF_NUMBER_TABLE
702: , p5_a1 JTF_NUMBER_TABLE
703: , p5_a2 JTF_NUMBER_TABLE
704: , p5_a3 JTF_NUMBER_TABLE
705: , p5_a4 JTF_NUMBER_TABLE
706: , p5_a5 JTF_NUMBER_TABLE
699: , x_msg_count out nocopy NUMBER
700: , x_msg_data out nocopy VARCHAR2
701: , p5_a0 JTF_NUMBER_TABLE
702: , p5_a1 JTF_NUMBER_TABLE
703: , p5_a2 JTF_NUMBER_TABLE
704: , p5_a3 JTF_NUMBER_TABLE
705: , p5_a4 JTF_NUMBER_TABLE
706: , p5_a5 JTF_NUMBER_TABLE
707: , p5_a6 JTF_NUMBER_TABLE
700: , x_msg_data out nocopy VARCHAR2
701: , p5_a0 JTF_NUMBER_TABLE
702: , p5_a1 JTF_NUMBER_TABLE
703: , p5_a2 JTF_NUMBER_TABLE
704: , p5_a3 JTF_NUMBER_TABLE
705: , p5_a4 JTF_NUMBER_TABLE
706: , p5_a5 JTF_NUMBER_TABLE
707: , p5_a6 JTF_NUMBER_TABLE
708: , p5_a7 JTF_VARCHAR2_TABLE_100
701: , p5_a0 JTF_NUMBER_TABLE
702: , p5_a1 JTF_NUMBER_TABLE
703: , p5_a2 JTF_NUMBER_TABLE
704: , p5_a3 JTF_NUMBER_TABLE
705: , p5_a4 JTF_NUMBER_TABLE
706: , p5_a5 JTF_NUMBER_TABLE
707: , p5_a6 JTF_NUMBER_TABLE
708: , p5_a7 JTF_VARCHAR2_TABLE_100
709: , p5_a8 JTF_VARCHAR2_TABLE_100
702: , p5_a1 JTF_NUMBER_TABLE
703: , p5_a2 JTF_NUMBER_TABLE
704: , p5_a3 JTF_NUMBER_TABLE
705: , p5_a4 JTF_NUMBER_TABLE
706: , p5_a5 JTF_NUMBER_TABLE
707: , p5_a6 JTF_NUMBER_TABLE
708: , p5_a7 JTF_VARCHAR2_TABLE_100
709: , p5_a8 JTF_VARCHAR2_TABLE_100
710: , p5_a9 JTF_VARCHAR2_TABLE_100
703: , p5_a2 JTF_NUMBER_TABLE
704: , p5_a3 JTF_NUMBER_TABLE
705: , p5_a4 JTF_NUMBER_TABLE
706: , p5_a5 JTF_NUMBER_TABLE
707: , p5_a6 JTF_NUMBER_TABLE
708: , p5_a7 JTF_VARCHAR2_TABLE_100
709: , p5_a8 JTF_VARCHAR2_TABLE_100
710: , p5_a9 JTF_VARCHAR2_TABLE_100
711: , p5_a10 JTF_VARCHAR2_TABLE_100
733: , p5_a32 JTF_VARCHAR2_TABLE_500
734: , p5_a33 JTF_VARCHAR2_TABLE_500
735: , p5_a34 JTF_VARCHAR2_TABLE_500
736: , p5_a35 JTF_VARCHAR2_TABLE_500
737: , p5_a36 JTF_NUMBER_TABLE
738: , p5_a37 JTF_NUMBER_TABLE
739: , p5_a38 JTF_DATE_TABLE
740: , p5_a39 JTF_NUMBER_TABLE
741: , p5_a40 JTF_DATE_TABLE
734: , p5_a33 JTF_VARCHAR2_TABLE_500
735: , p5_a34 JTF_VARCHAR2_TABLE_500
736: , p5_a35 JTF_VARCHAR2_TABLE_500
737: , p5_a36 JTF_NUMBER_TABLE
738: , p5_a37 JTF_NUMBER_TABLE
739: , p5_a38 JTF_DATE_TABLE
740: , p5_a39 JTF_NUMBER_TABLE
741: , p5_a40 JTF_DATE_TABLE
742: , p5_a41 JTF_NUMBER_TABLE
736: , p5_a35 JTF_VARCHAR2_TABLE_500
737: , p5_a36 JTF_NUMBER_TABLE
738: , p5_a37 JTF_NUMBER_TABLE
739: , p5_a38 JTF_DATE_TABLE
740: , p5_a39 JTF_NUMBER_TABLE
741: , p5_a40 JTF_DATE_TABLE
742: , p5_a41 JTF_NUMBER_TABLE
743: , p5_a42 JTF_VARCHAR2_TABLE_100
744: );
738: , p5_a37 JTF_NUMBER_TABLE
739: , p5_a38 JTF_DATE_TABLE
740: , p5_a39 JTF_NUMBER_TABLE
741: , p5_a40 JTF_DATE_TABLE
742: , p5_a41 JTF_NUMBER_TABLE
743: , p5_a42 JTF_VARCHAR2_TABLE_100
744: );
745: procedure validate_row(p_api_version NUMBER
746: , p_init_msg_list VARCHAR2
795: , p_init_msg_list VARCHAR2
796: , x_return_status out nocopy VARCHAR2
797: , x_msg_count out nocopy NUMBER
798: , x_msg_data out nocopy VARCHAR2
799: , p5_a0 JTF_NUMBER_TABLE
800: , p5_a1 JTF_NUMBER_TABLE
801: , p5_a2 JTF_NUMBER_TABLE
802: , p5_a3 JTF_NUMBER_TABLE
803: , p5_a4 JTF_NUMBER_TABLE
796: , x_return_status out nocopy VARCHAR2
797: , x_msg_count out nocopy NUMBER
798: , x_msg_data out nocopy VARCHAR2
799: , p5_a0 JTF_NUMBER_TABLE
800: , p5_a1 JTF_NUMBER_TABLE
801: , p5_a2 JTF_NUMBER_TABLE
802: , p5_a3 JTF_NUMBER_TABLE
803: , p5_a4 JTF_NUMBER_TABLE
804: , p5_a5 JTF_NUMBER_TABLE
797: , x_msg_count out nocopy NUMBER
798: , x_msg_data out nocopy VARCHAR2
799: , p5_a0 JTF_NUMBER_TABLE
800: , p5_a1 JTF_NUMBER_TABLE
801: , p5_a2 JTF_NUMBER_TABLE
802: , p5_a3 JTF_NUMBER_TABLE
803: , p5_a4 JTF_NUMBER_TABLE
804: , p5_a5 JTF_NUMBER_TABLE
805: , p5_a6 JTF_NUMBER_TABLE
798: , x_msg_data out nocopy VARCHAR2
799: , p5_a0 JTF_NUMBER_TABLE
800: , p5_a1 JTF_NUMBER_TABLE
801: , p5_a2 JTF_NUMBER_TABLE
802: , p5_a3 JTF_NUMBER_TABLE
803: , p5_a4 JTF_NUMBER_TABLE
804: , p5_a5 JTF_NUMBER_TABLE
805: , p5_a6 JTF_NUMBER_TABLE
806: , p5_a7 JTF_VARCHAR2_TABLE_100
799: , p5_a0 JTF_NUMBER_TABLE
800: , p5_a1 JTF_NUMBER_TABLE
801: , p5_a2 JTF_NUMBER_TABLE
802: , p5_a3 JTF_NUMBER_TABLE
803: , p5_a4 JTF_NUMBER_TABLE
804: , p5_a5 JTF_NUMBER_TABLE
805: , p5_a6 JTF_NUMBER_TABLE
806: , p5_a7 JTF_VARCHAR2_TABLE_100
807: , p5_a8 JTF_VARCHAR2_TABLE_100
800: , p5_a1 JTF_NUMBER_TABLE
801: , p5_a2 JTF_NUMBER_TABLE
802: , p5_a3 JTF_NUMBER_TABLE
803: , p5_a4 JTF_NUMBER_TABLE
804: , p5_a5 JTF_NUMBER_TABLE
805: , p5_a6 JTF_NUMBER_TABLE
806: , p5_a7 JTF_VARCHAR2_TABLE_100
807: , p5_a8 JTF_VARCHAR2_TABLE_100
808: , p5_a9 JTF_VARCHAR2_TABLE_100
801: , p5_a2 JTF_NUMBER_TABLE
802: , p5_a3 JTF_NUMBER_TABLE
803: , p5_a4 JTF_NUMBER_TABLE
804: , p5_a5 JTF_NUMBER_TABLE
805: , p5_a6 JTF_NUMBER_TABLE
806: , p5_a7 JTF_VARCHAR2_TABLE_100
807: , p5_a8 JTF_VARCHAR2_TABLE_100
808: , p5_a9 JTF_VARCHAR2_TABLE_100
809: , p5_a10 JTF_VARCHAR2_TABLE_100
831: , p5_a32 JTF_VARCHAR2_TABLE_500
832: , p5_a33 JTF_VARCHAR2_TABLE_500
833: , p5_a34 JTF_VARCHAR2_TABLE_500
834: , p5_a35 JTF_VARCHAR2_TABLE_500
835: , p5_a36 JTF_NUMBER_TABLE
836: , p5_a37 JTF_NUMBER_TABLE
837: , p5_a38 JTF_DATE_TABLE
838: , p5_a39 JTF_NUMBER_TABLE
839: , p5_a40 JTF_DATE_TABLE
832: , p5_a33 JTF_VARCHAR2_TABLE_500
833: , p5_a34 JTF_VARCHAR2_TABLE_500
834: , p5_a35 JTF_VARCHAR2_TABLE_500
835: , p5_a36 JTF_NUMBER_TABLE
836: , p5_a37 JTF_NUMBER_TABLE
837: , p5_a38 JTF_DATE_TABLE
838: , p5_a39 JTF_NUMBER_TABLE
839: , p5_a40 JTF_DATE_TABLE
840: , p5_a41 JTF_NUMBER_TABLE
834: , p5_a35 JTF_VARCHAR2_TABLE_500
835: , p5_a36 JTF_NUMBER_TABLE
836: , p5_a37 JTF_NUMBER_TABLE
837: , p5_a38 JTF_DATE_TABLE
838: , p5_a39 JTF_NUMBER_TABLE
839: , p5_a40 JTF_DATE_TABLE
840: , p5_a41 JTF_NUMBER_TABLE
841: , p5_a42 JTF_VARCHAR2_TABLE_100
842: );
836: , p5_a37 JTF_NUMBER_TABLE
837: , p5_a38 JTF_DATE_TABLE
838: , p5_a39 JTF_NUMBER_TABLE
839: , p5_a40 JTF_DATE_TABLE
840: , p5_a41 JTF_NUMBER_TABLE
841: , p5_a42 JTF_VARCHAR2_TABLE_100
842: );
843: end okl_avl_pvt_w;