1: package okl_clh_pvt_w as
2: /* $Header: OKLICLHS.pls 120.3 2005/09/23 12:15:11 varangan noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_clh_pvt.clhv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_VARCHAR2_TABLE_600
1: package okl_clh_pvt_w as
2: /* $Header: OKLICLHS.pls 120.3 2005/09/23 12:15:11 varangan noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_clh_pvt.clhv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_200
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_VARCHAR2_TABLE_600
8: , a5 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
27: , a24 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_DATE_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_NUMBER_TABLE
43: );
44: procedure rosetta_table_copy_out_p2(t okl_clh_pvt.clhv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_NUMBER_TABLE
43: );
44: procedure rosetta_table_copy_out_p2(t okl_clh_pvt.clhv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_VARCHAR2_TABLE_200
40: , a37 JTF_NUMBER_TABLE
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_NUMBER_TABLE
43: );
44: procedure rosetta_table_copy_out_p2(t okl_clh_pvt.clhv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_VARCHAR2_TABLE_200
47: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
48: , a4 out nocopy JTF_VARCHAR2_TABLE_600
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_NUMBER_TABLE
43: );
44: procedure rosetta_table_copy_out_p2(t okl_clh_pvt.clhv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_VARCHAR2_TABLE_200
47: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
48: , a4 out nocopy JTF_VARCHAR2_TABLE_600
49: , a5 out nocopy JTF_VARCHAR2_TABLE_100
65: , a21 out nocopy JTF_VARCHAR2_TABLE_500
66: , a22 out nocopy JTF_VARCHAR2_TABLE_500
67: , a23 out nocopy JTF_VARCHAR2_TABLE_500
68: , a24 out nocopy JTF_VARCHAR2_TABLE_500
69: , a25 out nocopy JTF_NUMBER_TABLE
70: , a26 out nocopy JTF_NUMBER_TABLE
71: , a27 out nocopy JTF_NUMBER_TABLE
72: , a28 out nocopy JTF_NUMBER_TABLE
73: , a29 out nocopy JTF_DATE_TABLE
66: , a22 out nocopy JTF_VARCHAR2_TABLE_500
67: , a23 out nocopy JTF_VARCHAR2_TABLE_500
68: , a24 out nocopy JTF_VARCHAR2_TABLE_500
69: , a25 out nocopy JTF_NUMBER_TABLE
70: , a26 out nocopy JTF_NUMBER_TABLE
71: , a27 out nocopy JTF_NUMBER_TABLE
72: , a28 out nocopy JTF_NUMBER_TABLE
73: , a29 out nocopy JTF_DATE_TABLE
74: , a30 out nocopy JTF_NUMBER_TABLE
67: , a23 out nocopy JTF_VARCHAR2_TABLE_500
68: , a24 out nocopy JTF_VARCHAR2_TABLE_500
69: , a25 out nocopy JTF_NUMBER_TABLE
70: , a26 out nocopy JTF_NUMBER_TABLE
71: , a27 out nocopy JTF_NUMBER_TABLE
72: , a28 out nocopy JTF_NUMBER_TABLE
73: , a29 out nocopy JTF_DATE_TABLE
74: , a30 out nocopy JTF_NUMBER_TABLE
75: , a31 out nocopy JTF_DATE_TABLE
68: , a24 out nocopy JTF_VARCHAR2_TABLE_500
69: , a25 out nocopy JTF_NUMBER_TABLE
70: , a26 out nocopy JTF_NUMBER_TABLE
71: , a27 out nocopy JTF_NUMBER_TABLE
72: , a28 out nocopy JTF_NUMBER_TABLE
73: , a29 out nocopy JTF_DATE_TABLE
74: , a30 out nocopy JTF_NUMBER_TABLE
75: , a31 out nocopy JTF_DATE_TABLE
76: , a32 out nocopy JTF_NUMBER_TABLE
70: , a26 out nocopy JTF_NUMBER_TABLE
71: , a27 out nocopy JTF_NUMBER_TABLE
72: , a28 out nocopy JTF_NUMBER_TABLE
73: , a29 out nocopy JTF_DATE_TABLE
74: , a30 out nocopy JTF_NUMBER_TABLE
75: , a31 out nocopy JTF_DATE_TABLE
76: , a32 out nocopy JTF_NUMBER_TABLE
77: , a33 out nocopy JTF_DATE_TABLE
78: , a34 out nocopy JTF_NUMBER_TABLE
72: , a28 out nocopy JTF_NUMBER_TABLE
73: , a29 out nocopy JTF_DATE_TABLE
74: , a30 out nocopy JTF_NUMBER_TABLE
75: , a31 out nocopy JTF_DATE_TABLE
76: , a32 out nocopy JTF_NUMBER_TABLE
77: , a33 out nocopy JTF_DATE_TABLE
78: , a34 out nocopy JTF_NUMBER_TABLE
79: , a35 out nocopy JTF_VARCHAR2_TABLE_100
80: , a36 out nocopy JTF_DATE_TABLE
74: , a30 out nocopy JTF_NUMBER_TABLE
75: , a31 out nocopy JTF_DATE_TABLE
76: , a32 out nocopy JTF_NUMBER_TABLE
77: , a33 out nocopy JTF_DATE_TABLE
78: , a34 out nocopy JTF_NUMBER_TABLE
79: , a35 out nocopy JTF_VARCHAR2_TABLE_100
80: , a36 out nocopy JTF_DATE_TABLE
81: , a37 out nocopy JTF_NUMBER_TABLE
82: , a38 out nocopy JTF_VARCHAR2_TABLE_100
77: , a33 out nocopy JTF_DATE_TABLE
78: , a34 out nocopy JTF_NUMBER_TABLE
79: , a35 out nocopy JTF_VARCHAR2_TABLE_100
80: , a36 out nocopy JTF_DATE_TABLE
81: , a37 out nocopy JTF_NUMBER_TABLE
82: , a38 out nocopy JTF_VARCHAR2_TABLE_100
83: , a39 out nocopy JTF_NUMBER_TABLE
84: );
85:
79: , a35 out nocopy JTF_VARCHAR2_TABLE_100
80: , a36 out nocopy JTF_DATE_TABLE
81: , a37 out nocopy JTF_NUMBER_TABLE
82: , a38 out nocopy JTF_VARCHAR2_TABLE_100
83: , a39 out nocopy JTF_NUMBER_TABLE
84: );
85:
86: procedure rosetta_table_copy_in_p5(t out nocopy okl_clh_pvt.clh_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_NUMBER_TABLE
82: , a38 out nocopy JTF_VARCHAR2_TABLE_100
83: , a39 out nocopy JTF_NUMBER_TABLE
84: );
85:
86: procedure rosetta_table_copy_in_p5(t out nocopy okl_clh_pvt.clh_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_NUMBER_TABLE
88: , a2 JTF_VARCHAR2_TABLE_200
89: , a3 JTF_VARCHAR2_TABLE_2000
90: , a4 JTF_VARCHAR2_TABLE_600
83: , a39 out nocopy JTF_NUMBER_TABLE
84: );
85:
86: procedure rosetta_table_copy_in_p5(t out nocopy okl_clh_pvt.clh_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_NUMBER_TABLE
88: , a2 JTF_VARCHAR2_TABLE_200
89: , a3 JTF_VARCHAR2_TABLE_2000
90: , a4 JTF_VARCHAR2_TABLE_600
91: , a5 JTF_VARCHAR2_TABLE_100
107: , a21 JTF_VARCHAR2_TABLE_500
108: , a22 JTF_VARCHAR2_TABLE_500
109: , a23 JTF_VARCHAR2_TABLE_500
110: , a24 JTF_VARCHAR2_TABLE_500
111: , a25 JTF_NUMBER_TABLE
112: , a26 JTF_NUMBER_TABLE
113: , a27 JTF_NUMBER_TABLE
114: , a28 JTF_NUMBER_TABLE
115: , a29 JTF_DATE_TABLE
108: , a22 JTF_VARCHAR2_TABLE_500
109: , a23 JTF_VARCHAR2_TABLE_500
110: , a24 JTF_VARCHAR2_TABLE_500
111: , a25 JTF_NUMBER_TABLE
112: , a26 JTF_NUMBER_TABLE
113: , a27 JTF_NUMBER_TABLE
114: , a28 JTF_NUMBER_TABLE
115: , a29 JTF_DATE_TABLE
116: , a30 JTF_NUMBER_TABLE
109: , a23 JTF_VARCHAR2_TABLE_500
110: , a24 JTF_VARCHAR2_TABLE_500
111: , a25 JTF_NUMBER_TABLE
112: , a26 JTF_NUMBER_TABLE
113: , a27 JTF_NUMBER_TABLE
114: , a28 JTF_NUMBER_TABLE
115: , a29 JTF_DATE_TABLE
116: , a30 JTF_NUMBER_TABLE
117: , a31 JTF_DATE_TABLE
110: , a24 JTF_VARCHAR2_TABLE_500
111: , a25 JTF_NUMBER_TABLE
112: , a26 JTF_NUMBER_TABLE
113: , a27 JTF_NUMBER_TABLE
114: , a28 JTF_NUMBER_TABLE
115: , a29 JTF_DATE_TABLE
116: , a30 JTF_NUMBER_TABLE
117: , a31 JTF_DATE_TABLE
118: , a32 JTF_NUMBER_TABLE
112: , a26 JTF_NUMBER_TABLE
113: , a27 JTF_NUMBER_TABLE
114: , a28 JTF_NUMBER_TABLE
115: , a29 JTF_DATE_TABLE
116: , a30 JTF_NUMBER_TABLE
117: , a31 JTF_DATE_TABLE
118: , a32 JTF_NUMBER_TABLE
119: , a33 JTF_DATE_TABLE
120: , a34 JTF_NUMBER_TABLE
114: , a28 JTF_NUMBER_TABLE
115: , a29 JTF_DATE_TABLE
116: , a30 JTF_NUMBER_TABLE
117: , a31 JTF_DATE_TABLE
118: , a32 JTF_NUMBER_TABLE
119: , a33 JTF_DATE_TABLE
120: , a34 JTF_NUMBER_TABLE
121: , a35 JTF_VARCHAR2_TABLE_100
122: , a36 JTF_DATE_TABLE
116: , a30 JTF_NUMBER_TABLE
117: , a31 JTF_DATE_TABLE
118: , a32 JTF_NUMBER_TABLE
119: , a33 JTF_DATE_TABLE
120: , a34 JTF_NUMBER_TABLE
121: , a35 JTF_VARCHAR2_TABLE_100
122: , a36 JTF_DATE_TABLE
123: , a37 JTF_NUMBER_TABLE
124: , a38 JTF_VARCHAR2_TABLE_100
119: , a33 JTF_DATE_TABLE
120: , a34 JTF_NUMBER_TABLE
121: , a35 JTF_VARCHAR2_TABLE_100
122: , a36 JTF_DATE_TABLE
123: , a37 JTF_NUMBER_TABLE
124: , a38 JTF_VARCHAR2_TABLE_100
125: , a39 JTF_NUMBER_TABLE
126: );
127: procedure rosetta_table_copy_out_p5(t okl_clh_pvt.clh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
121: , a35 JTF_VARCHAR2_TABLE_100
122: , a36 JTF_DATE_TABLE
123: , a37 JTF_NUMBER_TABLE
124: , a38 JTF_VARCHAR2_TABLE_100
125: , a39 JTF_NUMBER_TABLE
126: );
127: procedure rosetta_table_copy_out_p5(t okl_clh_pvt.clh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
128: , a1 out nocopy JTF_NUMBER_TABLE
129: , a2 out nocopy JTF_VARCHAR2_TABLE_200
123: , a37 JTF_NUMBER_TABLE
124: , a38 JTF_VARCHAR2_TABLE_100
125: , a39 JTF_NUMBER_TABLE
126: );
127: procedure rosetta_table_copy_out_p5(t okl_clh_pvt.clh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
128: , a1 out nocopy JTF_NUMBER_TABLE
129: , a2 out nocopy JTF_VARCHAR2_TABLE_200
130: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
131: , a4 out nocopy JTF_VARCHAR2_TABLE_600
124: , a38 JTF_VARCHAR2_TABLE_100
125: , a39 JTF_NUMBER_TABLE
126: );
127: procedure rosetta_table_copy_out_p5(t okl_clh_pvt.clh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
128: , a1 out nocopy JTF_NUMBER_TABLE
129: , a2 out nocopy JTF_VARCHAR2_TABLE_200
130: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
131: , a4 out nocopy JTF_VARCHAR2_TABLE_600
132: , a5 out nocopy JTF_VARCHAR2_TABLE_100
148: , a21 out nocopy JTF_VARCHAR2_TABLE_500
149: , a22 out nocopy JTF_VARCHAR2_TABLE_500
150: , a23 out nocopy JTF_VARCHAR2_TABLE_500
151: , a24 out nocopy JTF_VARCHAR2_TABLE_500
152: , a25 out nocopy JTF_NUMBER_TABLE
153: , a26 out nocopy JTF_NUMBER_TABLE
154: , a27 out nocopy JTF_NUMBER_TABLE
155: , a28 out nocopy JTF_NUMBER_TABLE
156: , a29 out nocopy JTF_DATE_TABLE
149: , a22 out nocopy JTF_VARCHAR2_TABLE_500
150: , a23 out nocopy JTF_VARCHAR2_TABLE_500
151: , a24 out nocopy JTF_VARCHAR2_TABLE_500
152: , a25 out nocopy JTF_NUMBER_TABLE
153: , a26 out nocopy JTF_NUMBER_TABLE
154: , a27 out nocopy JTF_NUMBER_TABLE
155: , a28 out nocopy JTF_NUMBER_TABLE
156: , a29 out nocopy JTF_DATE_TABLE
157: , a30 out nocopy JTF_NUMBER_TABLE
150: , a23 out nocopy JTF_VARCHAR2_TABLE_500
151: , a24 out nocopy JTF_VARCHAR2_TABLE_500
152: , a25 out nocopy JTF_NUMBER_TABLE
153: , a26 out nocopy JTF_NUMBER_TABLE
154: , a27 out nocopy JTF_NUMBER_TABLE
155: , a28 out nocopy JTF_NUMBER_TABLE
156: , a29 out nocopy JTF_DATE_TABLE
157: , a30 out nocopy JTF_NUMBER_TABLE
158: , a31 out nocopy JTF_DATE_TABLE
151: , a24 out nocopy JTF_VARCHAR2_TABLE_500
152: , a25 out nocopy JTF_NUMBER_TABLE
153: , a26 out nocopy JTF_NUMBER_TABLE
154: , a27 out nocopy JTF_NUMBER_TABLE
155: , a28 out nocopy JTF_NUMBER_TABLE
156: , a29 out nocopy JTF_DATE_TABLE
157: , a30 out nocopy JTF_NUMBER_TABLE
158: , a31 out nocopy JTF_DATE_TABLE
159: , a32 out nocopy JTF_NUMBER_TABLE
153: , a26 out nocopy JTF_NUMBER_TABLE
154: , a27 out nocopy JTF_NUMBER_TABLE
155: , a28 out nocopy JTF_NUMBER_TABLE
156: , a29 out nocopy JTF_DATE_TABLE
157: , a30 out nocopy JTF_NUMBER_TABLE
158: , a31 out nocopy JTF_DATE_TABLE
159: , a32 out nocopy JTF_NUMBER_TABLE
160: , a33 out nocopy JTF_DATE_TABLE
161: , a34 out nocopy JTF_NUMBER_TABLE
155: , a28 out nocopy JTF_NUMBER_TABLE
156: , a29 out nocopy JTF_DATE_TABLE
157: , a30 out nocopy JTF_NUMBER_TABLE
158: , a31 out nocopy JTF_DATE_TABLE
159: , a32 out nocopy JTF_NUMBER_TABLE
160: , a33 out nocopy JTF_DATE_TABLE
161: , a34 out nocopy JTF_NUMBER_TABLE
162: , a35 out nocopy JTF_VARCHAR2_TABLE_100
163: , a36 out nocopy JTF_DATE_TABLE
157: , a30 out nocopy JTF_NUMBER_TABLE
158: , a31 out nocopy JTF_DATE_TABLE
159: , a32 out nocopy JTF_NUMBER_TABLE
160: , a33 out nocopy JTF_DATE_TABLE
161: , a34 out nocopy JTF_NUMBER_TABLE
162: , a35 out nocopy JTF_VARCHAR2_TABLE_100
163: , a36 out nocopy JTF_DATE_TABLE
164: , a37 out nocopy JTF_NUMBER_TABLE
165: , a38 out nocopy JTF_VARCHAR2_TABLE_100
160: , a33 out nocopy JTF_DATE_TABLE
161: , a34 out nocopy JTF_NUMBER_TABLE
162: , a35 out nocopy JTF_VARCHAR2_TABLE_100
163: , a36 out nocopy JTF_DATE_TABLE
164: , a37 out nocopy JTF_NUMBER_TABLE
165: , a38 out nocopy JTF_VARCHAR2_TABLE_100
166: , a39 out nocopy JTF_NUMBER_TABLE
167: );
168:
162: , a35 out nocopy JTF_VARCHAR2_TABLE_100
163: , a36 out nocopy JTF_DATE_TABLE
164: , a37 out nocopy JTF_NUMBER_TABLE
165: , a38 out nocopy JTF_VARCHAR2_TABLE_100
166: , a39 out nocopy JTF_NUMBER_TABLE
167: );
168:
169: procedure insert_row(p_api_version NUMBER
170: , p_init_msg_list VARCHAR2
256: , p_init_msg_list VARCHAR2
257: , x_return_status out nocopy VARCHAR2
258: , x_msg_count out nocopy NUMBER
259: , x_msg_data out nocopy VARCHAR2
260: , p5_a0 JTF_NUMBER_TABLE
261: , p5_a1 JTF_NUMBER_TABLE
262: , p5_a2 JTF_VARCHAR2_TABLE_200
263: , p5_a3 JTF_VARCHAR2_TABLE_2000
264: , p5_a4 JTF_VARCHAR2_TABLE_600
257: , x_return_status out nocopy VARCHAR2
258: , x_msg_count out nocopy NUMBER
259: , x_msg_data out nocopy VARCHAR2
260: , p5_a0 JTF_NUMBER_TABLE
261: , p5_a1 JTF_NUMBER_TABLE
262: , p5_a2 JTF_VARCHAR2_TABLE_200
263: , p5_a3 JTF_VARCHAR2_TABLE_2000
264: , p5_a4 JTF_VARCHAR2_TABLE_600
265: , p5_a5 JTF_VARCHAR2_TABLE_100
281: , p5_a21 JTF_VARCHAR2_TABLE_500
282: , p5_a22 JTF_VARCHAR2_TABLE_500
283: , p5_a23 JTF_VARCHAR2_TABLE_500
284: , p5_a24 JTF_VARCHAR2_TABLE_500
285: , p5_a25 JTF_NUMBER_TABLE
286: , p5_a26 JTF_NUMBER_TABLE
287: , p5_a27 JTF_NUMBER_TABLE
288: , p5_a28 JTF_NUMBER_TABLE
289: , p5_a29 JTF_DATE_TABLE
282: , p5_a22 JTF_VARCHAR2_TABLE_500
283: , p5_a23 JTF_VARCHAR2_TABLE_500
284: , p5_a24 JTF_VARCHAR2_TABLE_500
285: , p5_a25 JTF_NUMBER_TABLE
286: , p5_a26 JTF_NUMBER_TABLE
287: , p5_a27 JTF_NUMBER_TABLE
288: , p5_a28 JTF_NUMBER_TABLE
289: , p5_a29 JTF_DATE_TABLE
290: , p5_a30 JTF_NUMBER_TABLE
283: , p5_a23 JTF_VARCHAR2_TABLE_500
284: , p5_a24 JTF_VARCHAR2_TABLE_500
285: , p5_a25 JTF_NUMBER_TABLE
286: , p5_a26 JTF_NUMBER_TABLE
287: , p5_a27 JTF_NUMBER_TABLE
288: , p5_a28 JTF_NUMBER_TABLE
289: , p5_a29 JTF_DATE_TABLE
290: , p5_a30 JTF_NUMBER_TABLE
291: , p5_a31 JTF_DATE_TABLE
284: , p5_a24 JTF_VARCHAR2_TABLE_500
285: , p5_a25 JTF_NUMBER_TABLE
286: , p5_a26 JTF_NUMBER_TABLE
287: , p5_a27 JTF_NUMBER_TABLE
288: , p5_a28 JTF_NUMBER_TABLE
289: , p5_a29 JTF_DATE_TABLE
290: , p5_a30 JTF_NUMBER_TABLE
291: , p5_a31 JTF_DATE_TABLE
292: , p5_a32 JTF_NUMBER_TABLE
286: , p5_a26 JTF_NUMBER_TABLE
287: , p5_a27 JTF_NUMBER_TABLE
288: , p5_a28 JTF_NUMBER_TABLE
289: , p5_a29 JTF_DATE_TABLE
290: , p5_a30 JTF_NUMBER_TABLE
291: , p5_a31 JTF_DATE_TABLE
292: , p5_a32 JTF_NUMBER_TABLE
293: , p5_a33 JTF_DATE_TABLE
294: , p5_a34 JTF_NUMBER_TABLE
288: , p5_a28 JTF_NUMBER_TABLE
289: , p5_a29 JTF_DATE_TABLE
290: , p5_a30 JTF_NUMBER_TABLE
291: , p5_a31 JTF_DATE_TABLE
292: , p5_a32 JTF_NUMBER_TABLE
293: , p5_a33 JTF_DATE_TABLE
294: , p5_a34 JTF_NUMBER_TABLE
295: , p5_a35 JTF_VARCHAR2_TABLE_100
296: , p5_a36 JTF_DATE_TABLE
290: , p5_a30 JTF_NUMBER_TABLE
291: , p5_a31 JTF_DATE_TABLE
292: , p5_a32 JTF_NUMBER_TABLE
293: , p5_a33 JTF_DATE_TABLE
294: , p5_a34 JTF_NUMBER_TABLE
295: , p5_a35 JTF_VARCHAR2_TABLE_100
296: , p5_a36 JTF_DATE_TABLE
297: , p5_a37 JTF_NUMBER_TABLE
298: , p5_a38 JTF_VARCHAR2_TABLE_100
293: , p5_a33 JTF_DATE_TABLE
294: , p5_a34 JTF_NUMBER_TABLE
295: , p5_a35 JTF_VARCHAR2_TABLE_100
296: , p5_a36 JTF_DATE_TABLE
297: , p5_a37 JTF_NUMBER_TABLE
298: , p5_a38 JTF_VARCHAR2_TABLE_100
299: , p5_a39 JTF_NUMBER_TABLE
300: , p6_a0 out nocopy JTF_NUMBER_TABLE
301: , p6_a1 out nocopy JTF_NUMBER_TABLE
295: , p5_a35 JTF_VARCHAR2_TABLE_100
296: , p5_a36 JTF_DATE_TABLE
297: , p5_a37 JTF_NUMBER_TABLE
298: , p5_a38 JTF_VARCHAR2_TABLE_100
299: , p5_a39 JTF_NUMBER_TABLE
300: , p6_a0 out nocopy JTF_NUMBER_TABLE
301: , p6_a1 out nocopy JTF_NUMBER_TABLE
302: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
303: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
296: , p5_a36 JTF_DATE_TABLE
297: , p5_a37 JTF_NUMBER_TABLE
298: , p5_a38 JTF_VARCHAR2_TABLE_100
299: , p5_a39 JTF_NUMBER_TABLE
300: , p6_a0 out nocopy JTF_NUMBER_TABLE
301: , p6_a1 out nocopy JTF_NUMBER_TABLE
302: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
303: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
304: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
297: , p5_a37 JTF_NUMBER_TABLE
298: , p5_a38 JTF_VARCHAR2_TABLE_100
299: , p5_a39 JTF_NUMBER_TABLE
300: , p6_a0 out nocopy JTF_NUMBER_TABLE
301: , p6_a1 out nocopy JTF_NUMBER_TABLE
302: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
303: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
304: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
305: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
321: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
322: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
323: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
324: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
325: , p6_a25 out nocopy JTF_NUMBER_TABLE
326: , p6_a26 out nocopy JTF_NUMBER_TABLE
327: , p6_a27 out nocopy JTF_NUMBER_TABLE
328: , p6_a28 out nocopy JTF_NUMBER_TABLE
329: , p6_a29 out nocopy JTF_DATE_TABLE
322: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
323: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
324: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
325: , p6_a25 out nocopy JTF_NUMBER_TABLE
326: , p6_a26 out nocopy JTF_NUMBER_TABLE
327: , p6_a27 out nocopy JTF_NUMBER_TABLE
328: , p6_a28 out nocopy JTF_NUMBER_TABLE
329: , p6_a29 out nocopy JTF_DATE_TABLE
330: , p6_a30 out nocopy JTF_NUMBER_TABLE
323: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
324: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
325: , p6_a25 out nocopy JTF_NUMBER_TABLE
326: , p6_a26 out nocopy JTF_NUMBER_TABLE
327: , p6_a27 out nocopy JTF_NUMBER_TABLE
328: , p6_a28 out nocopy JTF_NUMBER_TABLE
329: , p6_a29 out nocopy JTF_DATE_TABLE
330: , p6_a30 out nocopy JTF_NUMBER_TABLE
331: , p6_a31 out nocopy JTF_DATE_TABLE
324: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
325: , p6_a25 out nocopy JTF_NUMBER_TABLE
326: , p6_a26 out nocopy JTF_NUMBER_TABLE
327: , p6_a27 out nocopy JTF_NUMBER_TABLE
328: , p6_a28 out nocopy JTF_NUMBER_TABLE
329: , p6_a29 out nocopy JTF_DATE_TABLE
330: , p6_a30 out nocopy JTF_NUMBER_TABLE
331: , p6_a31 out nocopy JTF_DATE_TABLE
332: , p6_a32 out nocopy JTF_NUMBER_TABLE
326: , p6_a26 out nocopy JTF_NUMBER_TABLE
327: , p6_a27 out nocopy JTF_NUMBER_TABLE
328: , p6_a28 out nocopy JTF_NUMBER_TABLE
329: , p6_a29 out nocopy JTF_DATE_TABLE
330: , p6_a30 out nocopy JTF_NUMBER_TABLE
331: , p6_a31 out nocopy JTF_DATE_TABLE
332: , p6_a32 out nocopy JTF_NUMBER_TABLE
333: , p6_a33 out nocopy JTF_DATE_TABLE
334: , p6_a34 out nocopy JTF_NUMBER_TABLE
328: , p6_a28 out nocopy JTF_NUMBER_TABLE
329: , p6_a29 out nocopy JTF_DATE_TABLE
330: , p6_a30 out nocopy JTF_NUMBER_TABLE
331: , p6_a31 out nocopy JTF_DATE_TABLE
332: , p6_a32 out nocopy JTF_NUMBER_TABLE
333: , p6_a33 out nocopy JTF_DATE_TABLE
334: , p6_a34 out nocopy JTF_NUMBER_TABLE
335: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
336: , p6_a36 out nocopy JTF_DATE_TABLE
330: , p6_a30 out nocopy JTF_NUMBER_TABLE
331: , p6_a31 out nocopy JTF_DATE_TABLE
332: , p6_a32 out nocopy JTF_NUMBER_TABLE
333: , p6_a33 out nocopy JTF_DATE_TABLE
334: , p6_a34 out nocopy JTF_NUMBER_TABLE
335: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
336: , p6_a36 out nocopy JTF_DATE_TABLE
337: , p6_a37 out nocopy JTF_NUMBER_TABLE
338: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
333: , p6_a33 out nocopy JTF_DATE_TABLE
334: , p6_a34 out nocopy JTF_NUMBER_TABLE
335: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
336: , p6_a36 out nocopy JTF_DATE_TABLE
337: , p6_a37 out nocopy JTF_NUMBER_TABLE
338: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
339: , p6_a39 out nocopy JTF_NUMBER_TABLE
340: );
341: procedure lock_row(p_api_version NUMBER
335: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
336: , p6_a36 out nocopy JTF_DATE_TABLE
337: , p6_a37 out nocopy JTF_NUMBER_TABLE
338: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
339: , p6_a39 out nocopy JTF_NUMBER_TABLE
340: );
341: procedure lock_row(p_api_version NUMBER
342: , p_init_msg_list VARCHAR2
343: , x_return_status out nocopy VARCHAR2
388: , p_init_msg_list VARCHAR2
389: , x_return_status out nocopy VARCHAR2
390: , x_msg_count out nocopy NUMBER
391: , x_msg_data out nocopy VARCHAR2
392: , p5_a0 JTF_NUMBER_TABLE
393: , p5_a1 JTF_NUMBER_TABLE
394: , p5_a2 JTF_VARCHAR2_TABLE_200
395: , p5_a3 JTF_VARCHAR2_TABLE_2000
396: , p5_a4 JTF_VARCHAR2_TABLE_600
389: , x_return_status out nocopy VARCHAR2
390: , x_msg_count out nocopy NUMBER
391: , x_msg_data out nocopy VARCHAR2
392: , p5_a0 JTF_NUMBER_TABLE
393: , p5_a1 JTF_NUMBER_TABLE
394: , p5_a2 JTF_VARCHAR2_TABLE_200
395: , p5_a3 JTF_VARCHAR2_TABLE_2000
396: , p5_a4 JTF_VARCHAR2_TABLE_600
397: , p5_a5 JTF_VARCHAR2_TABLE_100
413: , p5_a21 JTF_VARCHAR2_TABLE_500
414: , p5_a22 JTF_VARCHAR2_TABLE_500
415: , p5_a23 JTF_VARCHAR2_TABLE_500
416: , p5_a24 JTF_VARCHAR2_TABLE_500
417: , p5_a25 JTF_NUMBER_TABLE
418: , p5_a26 JTF_NUMBER_TABLE
419: , p5_a27 JTF_NUMBER_TABLE
420: , p5_a28 JTF_NUMBER_TABLE
421: , p5_a29 JTF_DATE_TABLE
414: , p5_a22 JTF_VARCHAR2_TABLE_500
415: , p5_a23 JTF_VARCHAR2_TABLE_500
416: , p5_a24 JTF_VARCHAR2_TABLE_500
417: , p5_a25 JTF_NUMBER_TABLE
418: , p5_a26 JTF_NUMBER_TABLE
419: , p5_a27 JTF_NUMBER_TABLE
420: , p5_a28 JTF_NUMBER_TABLE
421: , p5_a29 JTF_DATE_TABLE
422: , p5_a30 JTF_NUMBER_TABLE
415: , p5_a23 JTF_VARCHAR2_TABLE_500
416: , p5_a24 JTF_VARCHAR2_TABLE_500
417: , p5_a25 JTF_NUMBER_TABLE
418: , p5_a26 JTF_NUMBER_TABLE
419: , p5_a27 JTF_NUMBER_TABLE
420: , p5_a28 JTF_NUMBER_TABLE
421: , p5_a29 JTF_DATE_TABLE
422: , p5_a30 JTF_NUMBER_TABLE
423: , p5_a31 JTF_DATE_TABLE
416: , p5_a24 JTF_VARCHAR2_TABLE_500
417: , p5_a25 JTF_NUMBER_TABLE
418: , p5_a26 JTF_NUMBER_TABLE
419: , p5_a27 JTF_NUMBER_TABLE
420: , p5_a28 JTF_NUMBER_TABLE
421: , p5_a29 JTF_DATE_TABLE
422: , p5_a30 JTF_NUMBER_TABLE
423: , p5_a31 JTF_DATE_TABLE
424: , p5_a32 JTF_NUMBER_TABLE
418: , p5_a26 JTF_NUMBER_TABLE
419: , p5_a27 JTF_NUMBER_TABLE
420: , p5_a28 JTF_NUMBER_TABLE
421: , p5_a29 JTF_DATE_TABLE
422: , p5_a30 JTF_NUMBER_TABLE
423: , p5_a31 JTF_DATE_TABLE
424: , p5_a32 JTF_NUMBER_TABLE
425: , p5_a33 JTF_DATE_TABLE
426: , p5_a34 JTF_NUMBER_TABLE
420: , p5_a28 JTF_NUMBER_TABLE
421: , p5_a29 JTF_DATE_TABLE
422: , p5_a30 JTF_NUMBER_TABLE
423: , p5_a31 JTF_DATE_TABLE
424: , p5_a32 JTF_NUMBER_TABLE
425: , p5_a33 JTF_DATE_TABLE
426: , p5_a34 JTF_NUMBER_TABLE
427: , p5_a35 JTF_VARCHAR2_TABLE_100
428: , p5_a36 JTF_DATE_TABLE
422: , p5_a30 JTF_NUMBER_TABLE
423: , p5_a31 JTF_DATE_TABLE
424: , p5_a32 JTF_NUMBER_TABLE
425: , p5_a33 JTF_DATE_TABLE
426: , p5_a34 JTF_NUMBER_TABLE
427: , p5_a35 JTF_VARCHAR2_TABLE_100
428: , p5_a36 JTF_DATE_TABLE
429: , p5_a37 JTF_NUMBER_TABLE
430: , p5_a38 JTF_VARCHAR2_TABLE_100
425: , p5_a33 JTF_DATE_TABLE
426: , p5_a34 JTF_NUMBER_TABLE
427: , p5_a35 JTF_VARCHAR2_TABLE_100
428: , p5_a36 JTF_DATE_TABLE
429: , p5_a37 JTF_NUMBER_TABLE
430: , p5_a38 JTF_VARCHAR2_TABLE_100
431: , p5_a39 JTF_NUMBER_TABLE
432: );
433: procedure update_row(p_api_version NUMBER
427: , p5_a35 JTF_VARCHAR2_TABLE_100
428: , p5_a36 JTF_DATE_TABLE
429: , p5_a37 JTF_NUMBER_TABLE
430: , p5_a38 JTF_VARCHAR2_TABLE_100
431: , p5_a39 JTF_NUMBER_TABLE
432: );
433: procedure update_row(p_api_version NUMBER
434: , p_init_msg_list VARCHAR2
435: , x_return_status out nocopy VARCHAR2
520: , p_init_msg_list VARCHAR2
521: , x_return_status out nocopy VARCHAR2
522: , x_msg_count out nocopy NUMBER
523: , x_msg_data out nocopy VARCHAR2
524: , p5_a0 JTF_NUMBER_TABLE
525: , p5_a1 JTF_NUMBER_TABLE
526: , p5_a2 JTF_VARCHAR2_TABLE_200
527: , p5_a3 JTF_VARCHAR2_TABLE_2000
528: , p5_a4 JTF_VARCHAR2_TABLE_600
521: , x_return_status out nocopy VARCHAR2
522: , x_msg_count out nocopy NUMBER
523: , x_msg_data out nocopy VARCHAR2
524: , p5_a0 JTF_NUMBER_TABLE
525: , p5_a1 JTF_NUMBER_TABLE
526: , p5_a2 JTF_VARCHAR2_TABLE_200
527: , p5_a3 JTF_VARCHAR2_TABLE_2000
528: , p5_a4 JTF_VARCHAR2_TABLE_600
529: , p5_a5 JTF_VARCHAR2_TABLE_100
545: , p5_a21 JTF_VARCHAR2_TABLE_500
546: , p5_a22 JTF_VARCHAR2_TABLE_500
547: , p5_a23 JTF_VARCHAR2_TABLE_500
548: , p5_a24 JTF_VARCHAR2_TABLE_500
549: , p5_a25 JTF_NUMBER_TABLE
550: , p5_a26 JTF_NUMBER_TABLE
551: , p5_a27 JTF_NUMBER_TABLE
552: , p5_a28 JTF_NUMBER_TABLE
553: , p5_a29 JTF_DATE_TABLE
546: , p5_a22 JTF_VARCHAR2_TABLE_500
547: , p5_a23 JTF_VARCHAR2_TABLE_500
548: , p5_a24 JTF_VARCHAR2_TABLE_500
549: , p5_a25 JTF_NUMBER_TABLE
550: , p5_a26 JTF_NUMBER_TABLE
551: , p5_a27 JTF_NUMBER_TABLE
552: , p5_a28 JTF_NUMBER_TABLE
553: , p5_a29 JTF_DATE_TABLE
554: , p5_a30 JTF_NUMBER_TABLE
547: , p5_a23 JTF_VARCHAR2_TABLE_500
548: , p5_a24 JTF_VARCHAR2_TABLE_500
549: , p5_a25 JTF_NUMBER_TABLE
550: , p5_a26 JTF_NUMBER_TABLE
551: , p5_a27 JTF_NUMBER_TABLE
552: , p5_a28 JTF_NUMBER_TABLE
553: , p5_a29 JTF_DATE_TABLE
554: , p5_a30 JTF_NUMBER_TABLE
555: , p5_a31 JTF_DATE_TABLE
548: , p5_a24 JTF_VARCHAR2_TABLE_500
549: , p5_a25 JTF_NUMBER_TABLE
550: , p5_a26 JTF_NUMBER_TABLE
551: , p5_a27 JTF_NUMBER_TABLE
552: , p5_a28 JTF_NUMBER_TABLE
553: , p5_a29 JTF_DATE_TABLE
554: , p5_a30 JTF_NUMBER_TABLE
555: , p5_a31 JTF_DATE_TABLE
556: , p5_a32 JTF_NUMBER_TABLE
550: , p5_a26 JTF_NUMBER_TABLE
551: , p5_a27 JTF_NUMBER_TABLE
552: , p5_a28 JTF_NUMBER_TABLE
553: , p5_a29 JTF_DATE_TABLE
554: , p5_a30 JTF_NUMBER_TABLE
555: , p5_a31 JTF_DATE_TABLE
556: , p5_a32 JTF_NUMBER_TABLE
557: , p5_a33 JTF_DATE_TABLE
558: , p5_a34 JTF_NUMBER_TABLE
552: , p5_a28 JTF_NUMBER_TABLE
553: , p5_a29 JTF_DATE_TABLE
554: , p5_a30 JTF_NUMBER_TABLE
555: , p5_a31 JTF_DATE_TABLE
556: , p5_a32 JTF_NUMBER_TABLE
557: , p5_a33 JTF_DATE_TABLE
558: , p5_a34 JTF_NUMBER_TABLE
559: , p5_a35 JTF_VARCHAR2_TABLE_100
560: , p5_a36 JTF_DATE_TABLE
554: , p5_a30 JTF_NUMBER_TABLE
555: , p5_a31 JTF_DATE_TABLE
556: , p5_a32 JTF_NUMBER_TABLE
557: , p5_a33 JTF_DATE_TABLE
558: , p5_a34 JTF_NUMBER_TABLE
559: , p5_a35 JTF_VARCHAR2_TABLE_100
560: , p5_a36 JTF_DATE_TABLE
561: , p5_a37 JTF_NUMBER_TABLE
562: , p5_a38 JTF_VARCHAR2_TABLE_100
557: , p5_a33 JTF_DATE_TABLE
558: , p5_a34 JTF_NUMBER_TABLE
559: , p5_a35 JTF_VARCHAR2_TABLE_100
560: , p5_a36 JTF_DATE_TABLE
561: , p5_a37 JTF_NUMBER_TABLE
562: , p5_a38 JTF_VARCHAR2_TABLE_100
563: , p5_a39 JTF_NUMBER_TABLE
564: , p6_a0 out nocopy JTF_NUMBER_TABLE
565: , p6_a1 out nocopy JTF_NUMBER_TABLE
559: , p5_a35 JTF_VARCHAR2_TABLE_100
560: , p5_a36 JTF_DATE_TABLE
561: , p5_a37 JTF_NUMBER_TABLE
562: , p5_a38 JTF_VARCHAR2_TABLE_100
563: , p5_a39 JTF_NUMBER_TABLE
564: , p6_a0 out nocopy JTF_NUMBER_TABLE
565: , p6_a1 out nocopy JTF_NUMBER_TABLE
566: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
567: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
560: , p5_a36 JTF_DATE_TABLE
561: , p5_a37 JTF_NUMBER_TABLE
562: , p5_a38 JTF_VARCHAR2_TABLE_100
563: , p5_a39 JTF_NUMBER_TABLE
564: , p6_a0 out nocopy JTF_NUMBER_TABLE
565: , p6_a1 out nocopy JTF_NUMBER_TABLE
566: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
567: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
568: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
561: , p5_a37 JTF_NUMBER_TABLE
562: , p5_a38 JTF_VARCHAR2_TABLE_100
563: , p5_a39 JTF_NUMBER_TABLE
564: , p6_a0 out nocopy JTF_NUMBER_TABLE
565: , p6_a1 out nocopy JTF_NUMBER_TABLE
566: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
567: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_2000
568: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
569: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
585: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
586: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
587: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
588: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
589: , p6_a25 out nocopy JTF_NUMBER_TABLE
590: , p6_a26 out nocopy JTF_NUMBER_TABLE
591: , p6_a27 out nocopy JTF_NUMBER_TABLE
592: , p6_a28 out nocopy JTF_NUMBER_TABLE
593: , p6_a29 out nocopy JTF_DATE_TABLE
586: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
587: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
588: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
589: , p6_a25 out nocopy JTF_NUMBER_TABLE
590: , p6_a26 out nocopy JTF_NUMBER_TABLE
591: , p6_a27 out nocopy JTF_NUMBER_TABLE
592: , p6_a28 out nocopy JTF_NUMBER_TABLE
593: , p6_a29 out nocopy JTF_DATE_TABLE
594: , p6_a30 out nocopy JTF_NUMBER_TABLE
587: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
588: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
589: , p6_a25 out nocopy JTF_NUMBER_TABLE
590: , p6_a26 out nocopy JTF_NUMBER_TABLE
591: , p6_a27 out nocopy JTF_NUMBER_TABLE
592: , p6_a28 out nocopy JTF_NUMBER_TABLE
593: , p6_a29 out nocopy JTF_DATE_TABLE
594: , p6_a30 out nocopy JTF_NUMBER_TABLE
595: , p6_a31 out nocopy JTF_DATE_TABLE
588: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
589: , p6_a25 out nocopy JTF_NUMBER_TABLE
590: , p6_a26 out nocopy JTF_NUMBER_TABLE
591: , p6_a27 out nocopy JTF_NUMBER_TABLE
592: , p6_a28 out nocopy JTF_NUMBER_TABLE
593: , p6_a29 out nocopy JTF_DATE_TABLE
594: , p6_a30 out nocopy JTF_NUMBER_TABLE
595: , p6_a31 out nocopy JTF_DATE_TABLE
596: , p6_a32 out nocopy JTF_NUMBER_TABLE
590: , p6_a26 out nocopy JTF_NUMBER_TABLE
591: , p6_a27 out nocopy JTF_NUMBER_TABLE
592: , p6_a28 out nocopy JTF_NUMBER_TABLE
593: , p6_a29 out nocopy JTF_DATE_TABLE
594: , p6_a30 out nocopy JTF_NUMBER_TABLE
595: , p6_a31 out nocopy JTF_DATE_TABLE
596: , p6_a32 out nocopy JTF_NUMBER_TABLE
597: , p6_a33 out nocopy JTF_DATE_TABLE
598: , p6_a34 out nocopy JTF_NUMBER_TABLE
592: , p6_a28 out nocopy JTF_NUMBER_TABLE
593: , p6_a29 out nocopy JTF_DATE_TABLE
594: , p6_a30 out nocopy JTF_NUMBER_TABLE
595: , p6_a31 out nocopy JTF_DATE_TABLE
596: , p6_a32 out nocopy JTF_NUMBER_TABLE
597: , p6_a33 out nocopy JTF_DATE_TABLE
598: , p6_a34 out nocopy JTF_NUMBER_TABLE
599: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
600: , p6_a36 out nocopy JTF_DATE_TABLE
594: , p6_a30 out nocopy JTF_NUMBER_TABLE
595: , p6_a31 out nocopy JTF_DATE_TABLE
596: , p6_a32 out nocopy JTF_NUMBER_TABLE
597: , p6_a33 out nocopy JTF_DATE_TABLE
598: , p6_a34 out nocopy JTF_NUMBER_TABLE
599: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
600: , p6_a36 out nocopy JTF_DATE_TABLE
601: , p6_a37 out nocopy JTF_NUMBER_TABLE
602: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
597: , p6_a33 out nocopy JTF_DATE_TABLE
598: , p6_a34 out nocopy JTF_NUMBER_TABLE
599: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
600: , p6_a36 out nocopy JTF_DATE_TABLE
601: , p6_a37 out nocopy JTF_NUMBER_TABLE
602: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
603: , p6_a39 out nocopy JTF_NUMBER_TABLE
604: );
605: procedure delete_row(p_api_version NUMBER
599: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
600: , p6_a36 out nocopy JTF_DATE_TABLE
601: , p6_a37 out nocopy JTF_NUMBER_TABLE
602: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
603: , p6_a39 out nocopy JTF_NUMBER_TABLE
604: );
605: procedure delete_row(p_api_version NUMBER
606: , p_init_msg_list VARCHAR2
607: , x_return_status out nocopy VARCHAR2
652: , p_init_msg_list VARCHAR2
653: , x_return_status out nocopy VARCHAR2
654: , x_msg_count out nocopy NUMBER
655: , x_msg_data out nocopy VARCHAR2
656: , p5_a0 JTF_NUMBER_TABLE
657: , p5_a1 JTF_NUMBER_TABLE
658: , p5_a2 JTF_VARCHAR2_TABLE_200
659: , p5_a3 JTF_VARCHAR2_TABLE_2000
660: , p5_a4 JTF_VARCHAR2_TABLE_600
653: , x_return_status out nocopy VARCHAR2
654: , x_msg_count out nocopy NUMBER
655: , x_msg_data out nocopy VARCHAR2
656: , p5_a0 JTF_NUMBER_TABLE
657: , p5_a1 JTF_NUMBER_TABLE
658: , p5_a2 JTF_VARCHAR2_TABLE_200
659: , p5_a3 JTF_VARCHAR2_TABLE_2000
660: , p5_a4 JTF_VARCHAR2_TABLE_600
661: , p5_a5 JTF_VARCHAR2_TABLE_100
677: , p5_a21 JTF_VARCHAR2_TABLE_500
678: , p5_a22 JTF_VARCHAR2_TABLE_500
679: , p5_a23 JTF_VARCHAR2_TABLE_500
680: , p5_a24 JTF_VARCHAR2_TABLE_500
681: , p5_a25 JTF_NUMBER_TABLE
682: , p5_a26 JTF_NUMBER_TABLE
683: , p5_a27 JTF_NUMBER_TABLE
684: , p5_a28 JTF_NUMBER_TABLE
685: , p5_a29 JTF_DATE_TABLE
678: , p5_a22 JTF_VARCHAR2_TABLE_500
679: , p5_a23 JTF_VARCHAR2_TABLE_500
680: , p5_a24 JTF_VARCHAR2_TABLE_500
681: , p5_a25 JTF_NUMBER_TABLE
682: , p5_a26 JTF_NUMBER_TABLE
683: , p5_a27 JTF_NUMBER_TABLE
684: , p5_a28 JTF_NUMBER_TABLE
685: , p5_a29 JTF_DATE_TABLE
686: , p5_a30 JTF_NUMBER_TABLE
679: , p5_a23 JTF_VARCHAR2_TABLE_500
680: , p5_a24 JTF_VARCHAR2_TABLE_500
681: , p5_a25 JTF_NUMBER_TABLE
682: , p5_a26 JTF_NUMBER_TABLE
683: , p5_a27 JTF_NUMBER_TABLE
684: , p5_a28 JTF_NUMBER_TABLE
685: , p5_a29 JTF_DATE_TABLE
686: , p5_a30 JTF_NUMBER_TABLE
687: , p5_a31 JTF_DATE_TABLE
680: , p5_a24 JTF_VARCHAR2_TABLE_500
681: , p5_a25 JTF_NUMBER_TABLE
682: , p5_a26 JTF_NUMBER_TABLE
683: , p5_a27 JTF_NUMBER_TABLE
684: , p5_a28 JTF_NUMBER_TABLE
685: , p5_a29 JTF_DATE_TABLE
686: , p5_a30 JTF_NUMBER_TABLE
687: , p5_a31 JTF_DATE_TABLE
688: , p5_a32 JTF_NUMBER_TABLE
682: , p5_a26 JTF_NUMBER_TABLE
683: , p5_a27 JTF_NUMBER_TABLE
684: , p5_a28 JTF_NUMBER_TABLE
685: , p5_a29 JTF_DATE_TABLE
686: , p5_a30 JTF_NUMBER_TABLE
687: , p5_a31 JTF_DATE_TABLE
688: , p5_a32 JTF_NUMBER_TABLE
689: , p5_a33 JTF_DATE_TABLE
690: , p5_a34 JTF_NUMBER_TABLE
684: , p5_a28 JTF_NUMBER_TABLE
685: , p5_a29 JTF_DATE_TABLE
686: , p5_a30 JTF_NUMBER_TABLE
687: , p5_a31 JTF_DATE_TABLE
688: , p5_a32 JTF_NUMBER_TABLE
689: , p5_a33 JTF_DATE_TABLE
690: , p5_a34 JTF_NUMBER_TABLE
691: , p5_a35 JTF_VARCHAR2_TABLE_100
692: , p5_a36 JTF_DATE_TABLE
686: , p5_a30 JTF_NUMBER_TABLE
687: , p5_a31 JTF_DATE_TABLE
688: , p5_a32 JTF_NUMBER_TABLE
689: , p5_a33 JTF_DATE_TABLE
690: , p5_a34 JTF_NUMBER_TABLE
691: , p5_a35 JTF_VARCHAR2_TABLE_100
692: , p5_a36 JTF_DATE_TABLE
693: , p5_a37 JTF_NUMBER_TABLE
694: , p5_a38 JTF_VARCHAR2_TABLE_100
689: , p5_a33 JTF_DATE_TABLE
690: , p5_a34 JTF_NUMBER_TABLE
691: , p5_a35 JTF_VARCHAR2_TABLE_100
692: , p5_a36 JTF_DATE_TABLE
693: , p5_a37 JTF_NUMBER_TABLE
694: , p5_a38 JTF_VARCHAR2_TABLE_100
695: , p5_a39 JTF_NUMBER_TABLE
696: );
697: procedure validate_row(p_api_version NUMBER
691: , p5_a35 JTF_VARCHAR2_TABLE_100
692: , p5_a36 JTF_DATE_TABLE
693: , p5_a37 JTF_NUMBER_TABLE
694: , p5_a38 JTF_VARCHAR2_TABLE_100
695: , p5_a39 JTF_NUMBER_TABLE
696: );
697: procedure validate_row(p_api_version NUMBER
698: , p_init_msg_list VARCHAR2
699: , x_return_status out nocopy VARCHAR2
744: , p_init_msg_list VARCHAR2
745: , x_return_status out nocopy VARCHAR2
746: , x_msg_count out nocopy NUMBER
747: , x_msg_data out nocopy VARCHAR2
748: , p5_a0 JTF_NUMBER_TABLE
749: , p5_a1 JTF_NUMBER_TABLE
750: , p5_a2 JTF_VARCHAR2_TABLE_200
751: , p5_a3 JTF_VARCHAR2_TABLE_2000
752: , p5_a4 JTF_VARCHAR2_TABLE_600
745: , x_return_status out nocopy VARCHAR2
746: , x_msg_count out nocopy NUMBER
747: , x_msg_data out nocopy VARCHAR2
748: , p5_a0 JTF_NUMBER_TABLE
749: , p5_a1 JTF_NUMBER_TABLE
750: , p5_a2 JTF_VARCHAR2_TABLE_200
751: , p5_a3 JTF_VARCHAR2_TABLE_2000
752: , p5_a4 JTF_VARCHAR2_TABLE_600
753: , p5_a5 JTF_VARCHAR2_TABLE_100
769: , p5_a21 JTF_VARCHAR2_TABLE_500
770: , p5_a22 JTF_VARCHAR2_TABLE_500
771: , p5_a23 JTF_VARCHAR2_TABLE_500
772: , p5_a24 JTF_VARCHAR2_TABLE_500
773: , p5_a25 JTF_NUMBER_TABLE
774: , p5_a26 JTF_NUMBER_TABLE
775: , p5_a27 JTF_NUMBER_TABLE
776: , p5_a28 JTF_NUMBER_TABLE
777: , p5_a29 JTF_DATE_TABLE
770: , p5_a22 JTF_VARCHAR2_TABLE_500
771: , p5_a23 JTF_VARCHAR2_TABLE_500
772: , p5_a24 JTF_VARCHAR2_TABLE_500
773: , p5_a25 JTF_NUMBER_TABLE
774: , p5_a26 JTF_NUMBER_TABLE
775: , p5_a27 JTF_NUMBER_TABLE
776: , p5_a28 JTF_NUMBER_TABLE
777: , p5_a29 JTF_DATE_TABLE
778: , p5_a30 JTF_NUMBER_TABLE
771: , p5_a23 JTF_VARCHAR2_TABLE_500
772: , p5_a24 JTF_VARCHAR2_TABLE_500
773: , p5_a25 JTF_NUMBER_TABLE
774: , p5_a26 JTF_NUMBER_TABLE
775: , p5_a27 JTF_NUMBER_TABLE
776: , p5_a28 JTF_NUMBER_TABLE
777: , p5_a29 JTF_DATE_TABLE
778: , p5_a30 JTF_NUMBER_TABLE
779: , p5_a31 JTF_DATE_TABLE
772: , p5_a24 JTF_VARCHAR2_TABLE_500
773: , p5_a25 JTF_NUMBER_TABLE
774: , p5_a26 JTF_NUMBER_TABLE
775: , p5_a27 JTF_NUMBER_TABLE
776: , p5_a28 JTF_NUMBER_TABLE
777: , p5_a29 JTF_DATE_TABLE
778: , p5_a30 JTF_NUMBER_TABLE
779: , p5_a31 JTF_DATE_TABLE
780: , p5_a32 JTF_NUMBER_TABLE
774: , p5_a26 JTF_NUMBER_TABLE
775: , p5_a27 JTF_NUMBER_TABLE
776: , p5_a28 JTF_NUMBER_TABLE
777: , p5_a29 JTF_DATE_TABLE
778: , p5_a30 JTF_NUMBER_TABLE
779: , p5_a31 JTF_DATE_TABLE
780: , p5_a32 JTF_NUMBER_TABLE
781: , p5_a33 JTF_DATE_TABLE
782: , p5_a34 JTF_NUMBER_TABLE
776: , p5_a28 JTF_NUMBER_TABLE
777: , p5_a29 JTF_DATE_TABLE
778: , p5_a30 JTF_NUMBER_TABLE
779: , p5_a31 JTF_DATE_TABLE
780: , p5_a32 JTF_NUMBER_TABLE
781: , p5_a33 JTF_DATE_TABLE
782: , p5_a34 JTF_NUMBER_TABLE
783: , p5_a35 JTF_VARCHAR2_TABLE_100
784: , p5_a36 JTF_DATE_TABLE
778: , p5_a30 JTF_NUMBER_TABLE
779: , p5_a31 JTF_DATE_TABLE
780: , p5_a32 JTF_NUMBER_TABLE
781: , p5_a33 JTF_DATE_TABLE
782: , p5_a34 JTF_NUMBER_TABLE
783: , p5_a35 JTF_VARCHAR2_TABLE_100
784: , p5_a36 JTF_DATE_TABLE
785: , p5_a37 JTF_NUMBER_TABLE
786: , p5_a38 JTF_VARCHAR2_TABLE_100
781: , p5_a33 JTF_DATE_TABLE
782: , p5_a34 JTF_NUMBER_TABLE
783: , p5_a35 JTF_VARCHAR2_TABLE_100
784: , p5_a36 JTF_DATE_TABLE
785: , p5_a37 JTF_NUMBER_TABLE
786: , p5_a38 JTF_VARCHAR2_TABLE_100
787: , p5_a39 JTF_NUMBER_TABLE
788: );
789: end okl_clh_pvt_w;
783: , p5_a35 JTF_VARCHAR2_TABLE_100
784: , p5_a36 JTF_DATE_TABLE
785: , p5_a37 JTF_NUMBER_TABLE
786: , p5_a38 JTF_VARCHAR2_TABLE_100
787: , p5_a39 JTF_NUMBER_TABLE
788: );
789: end okl_clh_pvt_w;