44: , p_init_msg_list VARCHAR2
45: , x_return_status out nocopy VARCHAR2
46: , x_msg_count out nocopy NUMBER
47: , x_msg_data out nocopy VARCHAR2
48: , p5_a0 JTF_NUMBER_TABLE
49: , p5_a1 JTF_NUMBER_TABLE
50: , p5_a2 JTF_NUMBER_TABLE
51: , p5_a3 JTF_VARCHAR2_TABLE_100
52: , p5_a4 JTF_VARCHAR2_TABLE_2000
45: , x_return_status out nocopy VARCHAR2
46: , x_msg_count out nocopy NUMBER
47: , x_msg_data out nocopy VARCHAR2
48: , p5_a0 JTF_NUMBER_TABLE
49: , p5_a1 JTF_NUMBER_TABLE
50: , p5_a2 JTF_NUMBER_TABLE
51: , p5_a3 JTF_VARCHAR2_TABLE_100
52: , p5_a4 JTF_VARCHAR2_TABLE_2000
53: , p5_a5 JTF_NUMBER_TABLE
46: , x_msg_count out nocopy NUMBER
47: , x_msg_data out nocopy VARCHAR2
48: , p5_a0 JTF_NUMBER_TABLE
49: , p5_a1 JTF_NUMBER_TABLE
50: , p5_a2 JTF_NUMBER_TABLE
51: , p5_a3 JTF_VARCHAR2_TABLE_100
52: , p5_a4 JTF_VARCHAR2_TABLE_2000
53: , p5_a5 JTF_NUMBER_TABLE
54: , p5_a6 JTF_NUMBER_TABLE
49: , p5_a1 JTF_NUMBER_TABLE
50: , p5_a2 JTF_NUMBER_TABLE
51: , p5_a3 JTF_VARCHAR2_TABLE_100
52: , p5_a4 JTF_VARCHAR2_TABLE_2000
53: , p5_a5 JTF_NUMBER_TABLE
54: , p5_a6 JTF_NUMBER_TABLE
55: , p5_a7 JTF_NUMBER_TABLE
56: , p5_a8 JTF_NUMBER_TABLE
57: , p5_a9 JTF_DATE_TABLE
50: , p5_a2 JTF_NUMBER_TABLE
51: , p5_a3 JTF_VARCHAR2_TABLE_100
52: , p5_a4 JTF_VARCHAR2_TABLE_2000
53: , p5_a5 JTF_NUMBER_TABLE
54: , p5_a6 JTF_NUMBER_TABLE
55: , p5_a7 JTF_NUMBER_TABLE
56: , p5_a8 JTF_NUMBER_TABLE
57: , p5_a9 JTF_DATE_TABLE
58: , p5_a10 JTF_DATE_TABLE
51: , p5_a3 JTF_VARCHAR2_TABLE_100
52: , p5_a4 JTF_VARCHAR2_TABLE_2000
53: , p5_a5 JTF_NUMBER_TABLE
54: , p5_a6 JTF_NUMBER_TABLE
55: , p5_a7 JTF_NUMBER_TABLE
56: , p5_a8 JTF_NUMBER_TABLE
57: , p5_a9 JTF_DATE_TABLE
58: , p5_a10 JTF_DATE_TABLE
59: , p5_a11 JTF_DATE_TABLE
52: , p5_a4 JTF_VARCHAR2_TABLE_2000
53: , p5_a5 JTF_NUMBER_TABLE
54: , p5_a6 JTF_NUMBER_TABLE
55: , p5_a7 JTF_NUMBER_TABLE
56: , p5_a8 JTF_NUMBER_TABLE
57: , p5_a9 JTF_DATE_TABLE
58: , p5_a10 JTF_DATE_TABLE
59: , p5_a11 JTF_DATE_TABLE
60: , p5_a12 JTF_NUMBER_TABLE
56: , p5_a8 JTF_NUMBER_TABLE
57: , p5_a9 JTF_DATE_TABLE
58: , p5_a10 JTF_DATE_TABLE
59: , p5_a11 JTF_DATE_TABLE
60: , p5_a12 JTF_NUMBER_TABLE
61: , p5_a13 JTF_DATE_TABLE
62: , p5_a14 JTF_NUMBER_TABLE
63: , p5_a15 JTF_DATE_TABLE
64: , p5_a16 JTF_NUMBER_TABLE
58: , p5_a10 JTF_DATE_TABLE
59: , p5_a11 JTF_DATE_TABLE
60: , p5_a12 JTF_NUMBER_TABLE
61: , p5_a13 JTF_DATE_TABLE
62: , p5_a14 JTF_NUMBER_TABLE
63: , p5_a15 JTF_DATE_TABLE
64: , p5_a16 JTF_NUMBER_TABLE
65: , p6_a0 out nocopy JTF_NUMBER_TABLE
66: , p6_a1 out nocopy JTF_NUMBER_TABLE
60: , p5_a12 JTF_NUMBER_TABLE
61: , p5_a13 JTF_DATE_TABLE
62: , p5_a14 JTF_NUMBER_TABLE
63: , p5_a15 JTF_DATE_TABLE
64: , p5_a16 JTF_NUMBER_TABLE
65: , p6_a0 out nocopy JTF_NUMBER_TABLE
66: , p6_a1 out nocopy JTF_NUMBER_TABLE
67: , p6_a2 out nocopy JTF_NUMBER_TABLE
68: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
61: , p5_a13 JTF_DATE_TABLE
62: , p5_a14 JTF_NUMBER_TABLE
63: , p5_a15 JTF_DATE_TABLE
64: , p5_a16 JTF_NUMBER_TABLE
65: , p6_a0 out nocopy JTF_NUMBER_TABLE
66: , p6_a1 out nocopy JTF_NUMBER_TABLE
67: , p6_a2 out nocopy JTF_NUMBER_TABLE
68: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
69: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
62: , p5_a14 JTF_NUMBER_TABLE
63: , p5_a15 JTF_DATE_TABLE
64: , p5_a16 JTF_NUMBER_TABLE
65: , p6_a0 out nocopy JTF_NUMBER_TABLE
66: , p6_a1 out nocopy JTF_NUMBER_TABLE
67: , p6_a2 out nocopy JTF_NUMBER_TABLE
68: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
69: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
70: , p6_a5 out nocopy JTF_NUMBER_TABLE
63: , p5_a15 JTF_DATE_TABLE
64: , p5_a16 JTF_NUMBER_TABLE
65: , p6_a0 out nocopy JTF_NUMBER_TABLE
66: , p6_a1 out nocopy JTF_NUMBER_TABLE
67: , p6_a2 out nocopy JTF_NUMBER_TABLE
68: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
69: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
70: , p6_a5 out nocopy JTF_NUMBER_TABLE
71: , p6_a6 out nocopy JTF_NUMBER_TABLE
66: , p6_a1 out nocopy JTF_NUMBER_TABLE
67: , p6_a2 out nocopy JTF_NUMBER_TABLE
68: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
69: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
70: , p6_a5 out nocopy JTF_NUMBER_TABLE
71: , p6_a6 out nocopy JTF_NUMBER_TABLE
72: , p6_a7 out nocopy JTF_NUMBER_TABLE
73: , p6_a8 out nocopy JTF_NUMBER_TABLE
74: , p6_a9 out nocopy JTF_DATE_TABLE
67: , p6_a2 out nocopy JTF_NUMBER_TABLE
68: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
69: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
70: , p6_a5 out nocopy JTF_NUMBER_TABLE
71: , p6_a6 out nocopy JTF_NUMBER_TABLE
72: , p6_a7 out nocopy JTF_NUMBER_TABLE
73: , p6_a8 out nocopy JTF_NUMBER_TABLE
74: , p6_a9 out nocopy JTF_DATE_TABLE
75: , p6_a10 out nocopy JTF_DATE_TABLE
68: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
69: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
70: , p6_a5 out nocopy JTF_NUMBER_TABLE
71: , p6_a6 out nocopy JTF_NUMBER_TABLE
72: , p6_a7 out nocopy JTF_NUMBER_TABLE
73: , p6_a8 out nocopy JTF_NUMBER_TABLE
74: , p6_a9 out nocopy JTF_DATE_TABLE
75: , p6_a10 out nocopy JTF_DATE_TABLE
76: , p6_a11 out nocopy JTF_DATE_TABLE
69: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
70: , p6_a5 out nocopy JTF_NUMBER_TABLE
71: , p6_a6 out nocopy JTF_NUMBER_TABLE
72: , p6_a7 out nocopy JTF_NUMBER_TABLE
73: , p6_a8 out nocopy JTF_NUMBER_TABLE
74: , p6_a9 out nocopy JTF_DATE_TABLE
75: , p6_a10 out nocopy JTF_DATE_TABLE
76: , p6_a11 out nocopy JTF_DATE_TABLE
77: , p6_a12 out nocopy JTF_NUMBER_TABLE
73: , p6_a8 out nocopy JTF_NUMBER_TABLE
74: , p6_a9 out nocopy JTF_DATE_TABLE
75: , p6_a10 out nocopy JTF_DATE_TABLE
76: , p6_a11 out nocopy JTF_DATE_TABLE
77: , p6_a12 out nocopy JTF_NUMBER_TABLE
78: , p6_a13 out nocopy JTF_DATE_TABLE
79: , p6_a14 out nocopy JTF_NUMBER_TABLE
80: , p6_a15 out nocopy JTF_DATE_TABLE
81: , p6_a16 out nocopy JTF_NUMBER_TABLE
75: , p6_a10 out nocopy JTF_DATE_TABLE
76: , p6_a11 out nocopy JTF_DATE_TABLE
77: , p6_a12 out nocopy JTF_NUMBER_TABLE
78: , p6_a13 out nocopy JTF_DATE_TABLE
79: , p6_a14 out nocopy JTF_NUMBER_TABLE
80: , p6_a15 out nocopy JTF_DATE_TABLE
81: , p6_a16 out nocopy JTF_NUMBER_TABLE
82: );
83: procedure lock_buckets(p_api_version NUMBER
77: , p6_a12 out nocopy JTF_NUMBER_TABLE
78: , p6_a13 out nocopy JTF_DATE_TABLE
79: , p6_a14 out nocopy JTF_NUMBER_TABLE
80: , p6_a15 out nocopy JTF_DATE_TABLE
81: , p6_a16 out nocopy JTF_NUMBER_TABLE
82: );
83: procedure lock_buckets(p_api_version NUMBER
84: , p_init_msg_list VARCHAR2
85: , x_return_status out nocopy VARCHAR2
107: , p_init_msg_list VARCHAR2
108: , x_return_status out nocopy VARCHAR2
109: , x_msg_count out nocopy NUMBER
110: , x_msg_data out nocopy VARCHAR2
111: , p5_a0 JTF_NUMBER_TABLE
112: , p5_a1 JTF_NUMBER_TABLE
113: , p5_a2 JTF_NUMBER_TABLE
114: , p5_a3 JTF_VARCHAR2_TABLE_100
115: , p5_a4 JTF_VARCHAR2_TABLE_2000
108: , x_return_status out nocopy VARCHAR2
109: , x_msg_count out nocopy NUMBER
110: , x_msg_data out nocopy VARCHAR2
111: , p5_a0 JTF_NUMBER_TABLE
112: , p5_a1 JTF_NUMBER_TABLE
113: , p5_a2 JTF_NUMBER_TABLE
114: , p5_a3 JTF_VARCHAR2_TABLE_100
115: , p5_a4 JTF_VARCHAR2_TABLE_2000
116: , p5_a5 JTF_NUMBER_TABLE
109: , x_msg_count out nocopy NUMBER
110: , x_msg_data out nocopy VARCHAR2
111: , p5_a0 JTF_NUMBER_TABLE
112: , p5_a1 JTF_NUMBER_TABLE
113: , p5_a2 JTF_NUMBER_TABLE
114: , p5_a3 JTF_VARCHAR2_TABLE_100
115: , p5_a4 JTF_VARCHAR2_TABLE_2000
116: , p5_a5 JTF_NUMBER_TABLE
117: , p5_a6 JTF_NUMBER_TABLE
112: , p5_a1 JTF_NUMBER_TABLE
113: , p5_a2 JTF_NUMBER_TABLE
114: , p5_a3 JTF_VARCHAR2_TABLE_100
115: , p5_a4 JTF_VARCHAR2_TABLE_2000
116: , p5_a5 JTF_NUMBER_TABLE
117: , p5_a6 JTF_NUMBER_TABLE
118: , p5_a7 JTF_NUMBER_TABLE
119: , p5_a8 JTF_NUMBER_TABLE
120: , p5_a9 JTF_DATE_TABLE
113: , p5_a2 JTF_NUMBER_TABLE
114: , p5_a3 JTF_VARCHAR2_TABLE_100
115: , p5_a4 JTF_VARCHAR2_TABLE_2000
116: , p5_a5 JTF_NUMBER_TABLE
117: , p5_a6 JTF_NUMBER_TABLE
118: , p5_a7 JTF_NUMBER_TABLE
119: , p5_a8 JTF_NUMBER_TABLE
120: , p5_a9 JTF_DATE_TABLE
121: , p5_a10 JTF_DATE_TABLE
114: , p5_a3 JTF_VARCHAR2_TABLE_100
115: , p5_a4 JTF_VARCHAR2_TABLE_2000
116: , p5_a5 JTF_NUMBER_TABLE
117: , p5_a6 JTF_NUMBER_TABLE
118: , p5_a7 JTF_NUMBER_TABLE
119: , p5_a8 JTF_NUMBER_TABLE
120: , p5_a9 JTF_DATE_TABLE
121: , p5_a10 JTF_DATE_TABLE
122: , p5_a11 JTF_DATE_TABLE
115: , p5_a4 JTF_VARCHAR2_TABLE_2000
116: , p5_a5 JTF_NUMBER_TABLE
117: , p5_a6 JTF_NUMBER_TABLE
118: , p5_a7 JTF_NUMBER_TABLE
119: , p5_a8 JTF_NUMBER_TABLE
120: , p5_a9 JTF_DATE_TABLE
121: , p5_a10 JTF_DATE_TABLE
122: , p5_a11 JTF_DATE_TABLE
123: , p5_a12 JTF_NUMBER_TABLE
119: , p5_a8 JTF_NUMBER_TABLE
120: , p5_a9 JTF_DATE_TABLE
121: , p5_a10 JTF_DATE_TABLE
122: , p5_a11 JTF_DATE_TABLE
123: , p5_a12 JTF_NUMBER_TABLE
124: , p5_a13 JTF_DATE_TABLE
125: , p5_a14 JTF_NUMBER_TABLE
126: , p5_a15 JTF_DATE_TABLE
127: , p5_a16 JTF_NUMBER_TABLE
121: , p5_a10 JTF_DATE_TABLE
122: , p5_a11 JTF_DATE_TABLE
123: , p5_a12 JTF_NUMBER_TABLE
124: , p5_a13 JTF_DATE_TABLE
125: , p5_a14 JTF_NUMBER_TABLE
126: , p5_a15 JTF_DATE_TABLE
127: , p5_a16 JTF_NUMBER_TABLE
128: );
129: procedure update_buckets(p_api_version NUMBER
123: , p5_a12 JTF_NUMBER_TABLE
124: , p5_a13 JTF_DATE_TABLE
125: , p5_a14 JTF_NUMBER_TABLE
126: , p5_a15 JTF_DATE_TABLE
127: , p5_a16 JTF_NUMBER_TABLE
128: );
129: procedure update_buckets(p_api_version NUMBER
130: , p_init_msg_list VARCHAR2
131: , x_return_status out nocopy VARCHAR2
170: , p_init_msg_list VARCHAR2
171: , x_return_status out nocopy VARCHAR2
172: , x_msg_count out nocopy NUMBER
173: , x_msg_data out nocopy VARCHAR2
174: , p5_a0 JTF_NUMBER_TABLE
175: , p5_a1 JTF_NUMBER_TABLE
176: , p5_a2 JTF_NUMBER_TABLE
177: , p5_a3 JTF_VARCHAR2_TABLE_100
178: , p5_a4 JTF_VARCHAR2_TABLE_2000
171: , x_return_status out nocopy VARCHAR2
172: , x_msg_count out nocopy NUMBER
173: , x_msg_data out nocopy VARCHAR2
174: , p5_a0 JTF_NUMBER_TABLE
175: , p5_a1 JTF_NUMBER_TABLE
176: , p5_a2 JTF_NUMBER_TABLE
177: , p5_a3 JTF_VARCHAR2_TABLE_100
178: , p5_a4 JTF_VARCHAR2_TABLE_2000
179: , p5_a5 JTF_NUMBER_TABLE
172: , x_msg_count out nocopy NUMBER
173: , x_msg_data out nocopy VARCHAR2
174: , p5_a0 JTF_NUMBER_TABLE
175: , p5_a1 JTF_NUMBER_TABLE
176: , p5_a2 JTF_NUMBER_TABLE
177: , p5_a3 JTF_VARCHAR2_TABLE_100
178: , p5_a4 JTF_VARCHAR2_TABLE_2000
179: , p5_a5 JTF_NUMBER_TABLE
180: , p5_a6 JTF_NUMBER_TABLE
175: , p5_a1 JTF_NUMBER_TABLE
176: , p5_a2 JTF_NUMBER_TABLE
177: , p5_a3 JTF_VARCHAR2_TABLE_100
178: , p5_a4 JTF_VARCHAR2_TABLE_2000
179: , p5_a5 JTF_NUMBER_TABLE
180: , p5_a6 JTF_NUMBER_TABLE
181: , p5_a7 JTF_NUMBER_TABLE
182: , p5_a8 JTF_NUMBER_TABLE
183: , p5_a9 JTF_DATE_TABLE
176: , p5_a2 JTF_NUMBER_TABLE
177: , p5_a3 JTF_VARCHAR2_TABLE_100
178: , p5_a4 JTF_VARCHAR2_TABLE_2000
179: , p5_a5 JTF_NUMBER_TABLE
180: , p5_a6 JTF_NUMBER_TABLE
181: , p5_a7 JTF_NUMBER_TABLE
182: , p5_a8 JTF_NUMBER_TABLE
183: , p5_a9 JTF_DATE_TABLE
184: , p5_a10 JTF_DATE_TABLE
177: , p5_a3 JTF_VARCHAR2_TABLE_100
178: , p5_a4 JTF_VARCHAR2_TABLE_2000
179: , p5_a5 JTF_NUMBER_TABLE
180: , p5_a6 JTF_NUMBER_TABLE
181: , p5_a7 JTF_NUMBER_TABLE
182: , p5_a8 JTF_NUMBER_TABLE
183: , p5_a9 JTF_DATE_TABLE
184: , p5_a10 JTF_DATE_TABLE
185: , p5_a11 JTF_DATE_TABLE
178: , p5_a4 JTF_VARCHAR2_TABLE_2000
179: , p5_a5 JTF_NUMBER_TABLE
180: , p5_a6 JTF_NUMBER_TABLE
181: , p5_a7 JTF_NUMBER_TABLE
182: , p5_a8 JTF_NUMBER_TABLE
183: , p5_a9 JTF_DATE_TABLE
184: , p5_a10 JTF_DATE_TABLE
185: , p5_a11 JTF_DATE_TABLE
186: , p5_a12 JTF_NUMBER_TABLE
182: , p5_a8 JTF_NUMBER_TABLE
183: , p5_a9 JTF_DATE_TABLE
184: , p5_a10 JTF_DATE_TABLE
185: , p5_a11 JTF_DATE_TABLE
186: , p5_a12 JTF_NUMBER_TABLE
187: , p5_a13 JTF_DATE_TABLE
188: , p5_a14 JTF_NUMBER_TABLE
189: , p5_a15 JTF_DATE_TABLE
190: , p5_a16 JTF_NUMBER_TABLE
184: , p5_a10 JTF_DATE_TABLE
185: , p5_a11 JTF_DATE_TABLE
186: , p5_a12 JTF_NUMBER_TABLE
187: , p5_a13 JTF_DATE_TABLE
188: , p5_a14 JTF_NUMBER_TABLE
189: , p5_a15 JTF_DATE_TABLE
190: , p5_a16 JTF_NUMBER_TABLE
191: , p6_a0 out nocopy JTF_NUMBER_TABLE
192: , p6_a1 out nocopy JTF_NUMBER_TABLE
186: , p5_a12 JTF_NUMBER_TABLE
187: , p5_a13 JTF_DATE_TABLE
188: , p5_a14 JTF_NUMBER_TABLE
189: , p5_a15 JTF_DATE_TABLE
190: , p5_a16 JTF_NUMBER_TABLE
191: , p6_a0 out nocopy JTF_NUMBER_TABLE
192: , p6_a1 out nocopy JTF_NUMBER_TABLE
193: , p6_a2 out nocopy JTF_NUMBER_TABLE
194: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
187: , p5_a13 JTF_DATE_TABLE
188: , p5_a14 JTF_NUMBER_TABLE
189: , p5_a15 JTF_DATE_TABLE
190: , p5_a16 JTF_NUMBER_TABLE
191: , p6_a0 out nocopy JTF_NUMBER_TABLE
192: , p6_a1 out nocopy JTF_NUMBER_TABLE
193: , p6_a2 out nocopy JTF_NUMBER_TABLE
194: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
195: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
188: , p5_a14 JTF_NUMBER_TABLE
189: , p5_a15 JTF_DATE_TABLE
190: , p5_a16 JTF_NUMBER_TABLE
191: , p6_a0 out nocopy JTF_NUMBER_TABLE
192: , p6_a1 out nocopy JTF_NUMBER_TABLE
193: , p6_a2 out nocopy JTF_NUMBER_TABLE
194: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
195: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
196: , p6_a5 out nocopy JTF_NUMBER_TABLE
189: , p5_a15 JTF_DATE_TABLE
190: , p5_a16 JTF_NUMBER_TABLE
191: , p6_a0 out nocopy JTF_NUMBER_TABLE
192: , p6_a1 out nocopy JTF_NUMBER_TABLE
193: , p6_a2 out nocopy JTF_NUMBER_TABLE
194: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
195: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
196: , p6_a5 out nocopy JTF_NUMBER_TABLE
197: , p6_a6 out nocopy JTF_NUMBER_TABLE
192: , p6_a1 out nocopy JTF_NUMBER_TABLE
193: , p6_a2 out nocopy JTF_NUMBER_TABLE
194: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
195: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
196: , p6_a5 out nocopy JTF_NUMBER_TABLE
197: , p6_a6 out nocopy JTF_NUMBER_TABLE
198: , p6_a7 out nocopy JTF_NUMBER_TABLE
199: , p6_a8 out nocopy JTF_NUMBER_TABLE
200: , p6_a9 out nocopy JTF_DATE_TABLE
193: , p6_a2 out nocopy JTF_NUMBER_TABLE
194: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
195: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
196: , p6_a5 out nocopy JTF_NUMBER_TABLE
197: , p6_a6 out nocopy JTF_NUMBER_TABLE
198: , p6_a7 out nocopy JTF_NUMBER_TABLE
199: , p6_a8 out nocopy JTF_NUMBER_TABLE
200: , p6_a9 out nocopy JTF_DATE_TABLE
201: , p6_a10 out nocopy JTF_DATE_TABLE
194: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
195: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
196: , p6_a5 out nocopy JTF_NUMBER_TABLE
197: , p6_a6 out nocopy JTF_NUMBER_TABLE
198: , p6_a7 out nocopy JTF_NUMBER_TABLE
199: , p6_a8 out nocopy JTF_NUMBER_TABLE
200: , p6_a9 out nocopy JTF_DATE_TABLE
201: , p6_a10 out nocopy JTF_DATE_TABLE
202: , p6_a11 out nocopy JTF_DATE_TABLE
195: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_2000
196: , p6_a5 out nocopy JTF_NUMBER_TABLE
197: , p6_a6 out nocopy JTF_NUMBER_TABLE
198: , p6_a7 out nocopy JTF_NUMBER_TABLE
199: , p6_a8 out nocopy JTF_NUMBER_TABLE
200: , p6_a9 out nocopy JTF_DATE_TABLE
201: , p6_a10 out nocopy JTF_DATE_TABLE
202: , p6_a11 out nocopy JTF_DATE_TABLE
203: , p6_a12 out nocopy JTF_NUMBER_TABLE
199: , p6_a8 out nocopy JTF_NUMBER_TABLE
200: , p6_a9 out nocopy JTF_DATE_TABLE
201: , p6_a10 out nocopy JTF_DATE_TABLE
202: , p6_a11 out nocopy JTF_DATE_TABLE
203: , p6_a12 out nocopy JTF_NUMBER_TABLE
204: , p6_a13 out nocopy JTF_DATE_TABLE
205: , p6_a14 out nocopy JTF_NUMBER_TABLE
206: , p6_a15 out nocopy JTF_DATE_TABLE
207: , p6_a16 out nocopy JTF_NUMBER_TABLE
201: , p6_a10 out nocopy JTF_DATE_TABLE
202: , p6_a11 out nocopy JTF_DATE_TABLE
203: , p6_a12 out nocopy JTF_NUMBER_TABLE
204: , p6_a13 out nocopy JTF_DATE_TABLE
205: , p6_a14 out nocopy JTF_NUMBER_TABLE
206: , p6_a15 out nocopy JTF_DATE_TABLE
207: , p6_a16 out nocopy JTF_NUMBER_TABLE
208: );
209: procedure delete_buckets(p_api_version NUMBER
203: , p6_a12 out nocopy JTF_NUMBER_TABLE
204: , p6_a13 out nocopy JTF_DATE_TABLE
205: , p6_a14 out nocopy JTF_NUMBER_TABLE
206: , p6_a15 out nocopy JTF_DATE_TABLE
207: , p6_a16 out nocopy JTF_NUMBER_TABLE
208: );
209: procedure delete_buckets(p_api_version NUMBER
210: , p_init_msg_list VARCHAR2
211: , x_return_status out nocopy VARCHAR2
233: , p_init_msg_list VARCHAR2
234: , x_return_status out nocopy VARCHAR2
235: , x_msg_count out nocopy NUMBER
236: , x_msg_data out nocopy VARCHAR2
237: , p5_a0 JTF_NUMBER_TABLE
238: , p5_a1 JTF_NUMBER_TABLE
239: , p5_a2 JTF_NUMBER_TABLE
240: , p5_a3 JTF_VARCHAR2_TABLE_100
241: , p5_a4 JTF_VARCHAR2_TABLE_2000
234: , x_return_status out nocopy VARCHAR2
235: , x_msg_count out nocopy NUMBER
236: , x_msg_data out nocopy VARCHAR2
237: , p5_a0 JTF_NUMBER_TABLE
238: , p5_a1 JTF_NUMBER_TABLE
239: , p5_a2 JTF_NUMBER_TABLE
240: , p5_a3 JTF_VARCHAR2_TABLE_100
241: , p5_a4 JTF_VARCHAR2_TABLE_2000
242: , p5_a5 JTF_NUMBER_TABLE
235: , x_msg_count out nocopy NUMBER
236: , x_msg_data out nocopy VARCHAR2
237: , p5_a0 JTF_NUMBER_TABLE
238: , p5_a1 JTF_NUMBER_TABLE
239: , p5_a2 JTF_NUMBER_TABLE
240: , p5_a3 JTF_VARCHAR2_TABLE_100
241: , p5_a4 JTF_VARCHAR2_TABLE_2000
242: , p5_a5 JTF_NUMBER_TABLE
243: , p5_a6 JTF_NUMBER_TABLE
238: , p5_a1 JTF_NUMBER_TABLE
239: , p5_a2 JTF_NUMBER_TABLE
240: , p5_a3 JTF_VARCHAR2_TABLE_100
241: , p5_a4 JTF_VARCHAR2_TABLE_2000
242: , p5_a5 JTF_NUMBER_TABLE
243: , p5_a6 JTF_NUMBER_TABLE
244: , p5_a7 JTF_NUMBER_TABLE
245: , p5_a8 JTF_NUMBER_TABLE
246: , p5_a9 JTF_DATE_TABLE
239: , p5_a2 JTF_NUMBER_TABLE
240: , p5_a3 JTF_VARCHAR2_TABLE_100
241: , p5_a4 JTF_VARCHAR2_TABLE_2000
242: , p5_a5 JTF_NUMBER_TABLE
243: , p5_a6 JTF_NUMBER_TABLE
244: , p5_a7 JTF_NUMBER_TABLE
245: , p5_a8 JTF_NUMBER_TABLE
246: , p5_a9 JTF_DATE_TABLE
247: , p5_a10 JTF_DATE_TABLE
240: , p5_a3 JTF_VARCHAR2_TABLE_100
241: , p5_a4 JTF_VARCHAR2_TABLE_2000
242: , p5_a5 JTF_NUMBER_TABLE
243: , p5_a6 JTF_NUMBER_TABLE
244: , p5_a7 JTF_NUMBER_TABLE
245: , p5_a8 JTF_NUMBER_TABLE
246: , p5_a9 JTF_DATE_TABLE
247: , p5_a10 JTF_DATE_TABLE
248: , p5_a11 JTF_DATE_TABLE
241: , p5_a4 JTF_VARCHAR2_TABLE_2000
242: , p5_a5 JTF_NUMBER_TABLE
243: , p5_a6 JTF_NUMBER_TABLE
244: , p5_a7 JTF_NUMBER_TABLE
245: , p5_a8 JTF_NUMBER_TABLE
246: , p5_a9 JTF_DATE_TABLE
247: , p5_a10 JTF_DATE_TABLE
248: , p5_a11 JTF_DATE_TABLE
249: , p5_a12 JTF_NUMBER_TABLE
245: , p5_a8 JTF_NUMBER_TABLE
246: , p5_a9 JTF_DATE_TABLE
247: , p5_a10 JTF_DATE_TABLE
248: , p5_a11 JTF_DATE_TABLE
249: , p5_a12 JTF_NUMBER_TABLE
250: , p5_a13 JTF_DATE_TABLE
251: , p5_a14 JTF_NUMBER_TABLE
252: , p5_a15 JTF_DATE_TABLE
253: , p5_a16 JTF_NUMBER_TABLE
247: , p5_a10 JTF_DATE_TABLE
248: , p5_a11 JTF_DATE_TABLE
249: , p5_a12 JTF_NUMBER_TABLE
250: , p5_a13 JTF_DATE_TABLE
251: , p5_a14 JTF_NUMBER_TABLE
252: , p5_a15 JTF_DATE_TABLE
253: , p5_a16 JTF_NUMBER_TABLE
254: );
255: procedure validate_buckets(p_api_version NUMBER
249: , p5_a12 JTF_NUMBER_TABLE
250: , p5_a13 JTF_DATE_TABLE
251: , p5_a14 JTF_NUMBER_TABLE
252: , p5_a15 JTF_DATE_TABLE
253: , p5_a16 JTF_NUMBER_TABLE
254: );
255: procedure validate_buckets(p_api_version NUMBER
256: , p_init_msg_list VARCHAR2
257: , x_return_status out nocopy VARCHAR2
279: , p_init_msg_list VARCHAR2
280: , x_return_status out nocopy VARCHAR2
281: , x_msg_count out nocopy NUMBER
282: , x_msg_data out nocopy VARCHAR2
283: , p5_a0 JTF_NUMBER_TABLE
284: , p5_a1 JTF_NUMBER_TABLE
285: , p5_a2 JTF_NUMBER_TABLE
286: , p5_a3 JTF_VARCHAR2_TABLE_100
287: , p5_a4 JTF_VARCHAR2_TABLE_2000
280: , x_return_status out nocopy VARCHAR2
281: , x_msg_count out nocopy NUMBER
282: , x_msg_data out nocopy VARCHAR2
283: , p5_a0 JTF_NUMBER_TABLE
284: , p5_a1 JTF_NUMBER_TABLE
285: , p5_a2 JTF_NUMBER_TABLE
286: , p5_a3 JTF_VARCHAR2_TABLE_100
287: , p5_a4 JTF_VARCHAR2_TABLE_2000
288: , p5_a5 JTF_NUMBER_TABLE
281: , x_msg_count out nocopy NUMBER
282: , x_msg_data out nocopy VARCHAR2
283: , p5_a0 JTF_NUMBER_TABLE
284: , p5_a1 JTF_NUMBER_TABLE
285: , p5_a2 JTF_NUMBER_TABLE
286: , p5_a3 JTF_VARCHAR2_TABLE_100
287: , p5_a4 JTF_VARCHAR2_TABLE_2000
288: , p5_a5 JTF_NUMBER_TABLE
289: , p5_a6 JTF_NUMBER_TABLE
284: , p5_a1 JTF_NUMBER_TABLE
285: , p5_a2 JTF_NUMBER_TABLE
286: , p5_a3 JTF_VARCHAR2_TABLE_100
287: , p5_a4 JTF_VARCHAR2_TABLE_2000
288: , p5_a5 JTF_NUMBER_TABLE
289: , p5_a6 JTF_NUMBER_TABLE
290: , p5_a7 JTF_NUMBER_TABLE
291: , p5_a8 JTF_NUMBER_TABLE
292: , p5_a9 JTF_DATE_TABLE
285: , p5_a2 JTF_NUMBER_TABLE
286: , p5_a3 JTF_VARCHAR2_TABLE_100
287: , p5_a4 JTF_VARCHAR2_TABLE_2000
288: , p5_a5 JTF_NUMBER_TABLE
289: , p5_a6 JTF_NUMBER_TABLE
290: , p5_a7 JTF_NUMBER_TABLE
291: , p5_a8 JTF_NUMBER_TABLE
292: , p5_a9 JTF_DATE_TABLE
293: , p5_a10 JTF_DATE_TABLE
286: , p5_a3 JTF_VARCHAR2_TABLE_100
287: , p5_a4 JTF_VARCHAR2_TABLE_2000
288: , p5_a5 JTF_NUMBER_TABLE
289: , p5_a6 JTF_NUMBER_TABLE
290: , p5_a7 JTF_NUMBER_TABLE
291: , p5_a8 JTF_NUMBER_TABLE
292: , p5_a9 JTF_DATE_TABLE
293: , p5_a10 JTF_DATE_TABLE
294: , p5_a11 JTF_DATE_TABLE
287: , p5_a4 JTF_VARCHAR2_TABLE_2000
288: , p5_a5 JTF_NUMBER_TABLE
289: , p5_a6 JTF_NUMBER_TABLE
290: , p5_a7 JTF_NUMBER_TABLE
291: , p5_a8 JTF_NUMBER_TABLE
292: , p5_a9 JTF_DATE_TABLE
293: , p5_a10 JTF_DATE_TABLE
294: , p5_a11 JTF_DATE_TABLE
295: , p5_a12 JTF_NUMBER_TABLE
291: , p5_a8 JTF_NUMBER_TABLE
292: , p5_a9 JTF_DATE_TABLE
293: , p5_a10 JTF_DATE_TABLE
294: , p5_a11 JTF_DATE_TABLE
295: , p5_a12 JTF_NUMBER_TABLE
296: , p5_a13 JTF_DATE_TABLE
297: , p5_a14 JTF_NUMBER_TABLE
298: , p5_a15 JTF_DATE_TABLE
299: , p5_a16 JTF_NUMBER_TABLE
293: , p5_a10 JTF_DATE_TABLE
294: , p5_a11 JTF_DATE_TABLE
295: , p5_a12 JTF_NUMBER_TABLE
296: , p5_a13 JTF_DATE_TABLE
297: , p5_a14 JTF_NUMBER_TABLE
298: , p5_a15 JTF_DATE_TABLE
299: , p5_a16 JTF_NUMBER_TABLE
300: );
301: end okl_buckets_pub_w;
295: , p5_a12 JTF_NUMBER_TABLE
296: , p5_a13 JTF_DATE_TABLE
297: , p5_a14 JTF_NUMBER_TABLE
298: , p5_a15 JTF_DATE_TABLE
299: , p5_a16 JTF_NUMBER_TABLE
300: );
301: end okl_buckets_pub_w;