24: , p6_a16 out nocopy NUMBER
25: , p5_a0 NUMBER := 0-1962.0724
26: , p5_a1 NUMBER := 0-1962.0724
27: , p5_a2 NUMBER := 0-1962.0724
28: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
29: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
30: , p5_a5 NUMBER := 0-1962.0724
31: , p5_a6 NUMBER := 0-1962.0724
32: , p5_a7 NUMBER := 0-1962.0724
25: , p5_a0 NUMBER := 0-1962.0724
26: , p5_a1 NUMBER := 0-1962.0724
27: , p5_a2 NUMBER := 0-1962.0724
28: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
29: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
30: , p5_a5 NUMBER := 0-1962.0724
31: , p5_a6 NUMBER := 0-1962.0724
32: , p5_a7 NUMBER := 0-1962.0724
33: , p5_a8 NUMBER := 0-1962.0724
30: , p5_a5 NUMBER := 0-1962.0724
31: , p5_a6 NUMBER := 0-1962.0724
32: , p5_a7 NUMBER := 0-1962.0724
33: , p5_a8 NUMBER := 0-1962.0724
34: , p5_a9 DATE := fnd_api.g_miss_date
35: , p5_a10 DATE := fnd_api.g_miss_date
36: , p5_a11 DATE := fnd_api.g_miss_date
37: , p5_a12 NUMBER := 0-1962.0724
38: , p5_a13 DATE := fnd_api.g_miss_date
31: , p5_a6 NUMBER := 0-1962.0724
32: , p5_a7 NUMBER := 0-1962.0724
33: , p5_a8 NUMBER := 0-1962.0724
34: , p5_a9 DATE := fnd_api.g_miss_date
35: , p5_a10 DATE := fnd_api.g_miss_date
36: , p5_a11 DATE := fnd_api.g_miss_date
37: , p5_a12 NUMBER := 0-1962.0724
38: , p5_a13 DATE := fnd_api.g_miss_date
39: , p5_a14 NUMBER := 0-1962.0724
32: , p5_a7 NUMBER := 0-1962.0724
33: , p5_a8 NUMBER := 0-1962.0724
34: , p5_a9 DATE := fnd_api.g_miss_date
35: , p5_a10 DATE := fnd_api.g_miss_date
36: , p5_a11 DATE := fnd_api.g_miss_date
37: , p5_a12 NUMBER := 0-1962.0724
38: , p5_a13 DATE := fnd_api.g_miss_date
39: , p5_a14 NUMBER := 0-1962.0724
40: , p5_a15 DATE := fnd_api.g_miss_date
34: , p5_a9 DATE := fnd_api.g_miss_date
35: , p5_a10 DATE := fnd_api.g_miss_date
36: , p5_a11 DATE := fnd_api.g_miss_date
37: , p5_a12 NUMBER := 0-1962.0724
38: , p5_a13 DATE := fnd_api.g_miss_date
39: , p5_a14 NUMBER := 0-1962.0724
40: , p5_a15 DATE := fnd_api.g_miss_date
41: , p5_a16 NUMBER := 0-1962.0724
42: );
36: , p5_a11 DATE := fnd_api.g_miss_date
37: , p5_a12 NUMBER := 0-1962.0724
38: , p5_a13 DATE := fnd_api.g_miss_date
39: , p5_a14 NUMBER := 0-1962.0724
40: , p5_a15 DATE := fnd_api.g_miss_date
41: , p5_a16 NUMBER := 0-1962.0724
42: );
43: procedure insert_buckets(p_api_version NUMBER
44: , p_init_msg_list VARCHAR2
87: , x_msg_data out nocopy VARCHAR2
88: , p5_a0 NUMBER := 0-1962.0724
89: , p5_a1 NUMBER := 0-1962.0724
90: , p5_a2 NUMBER := 0-1962.0724
91: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a5 NUMBER := 0-1962.0724
94: , p5_a6 NUMBER := 0-1962.0724
95: , p5_a7 NUMBER := 0-1962.0724
88: , p5_a0 NUMBER := 0-1962.0724
89: , p5_a1 NUMBER := 0-1962.0724
90: , p5_a2 NUMBER := 0-1962.0724
91: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
92: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
93: , p5_a5 NUMBER := 0-1962.0724
94: , p5_a6 NUMBER := 0-1962.0724
95: , p5_a7 NUMBER := 0-1962.0724
96: , p5_a8 NUMBER := 0-1962.0724
93: , p5_a5 NUMBER := 0-1962.0724
94: , p5_a6 NUMBER := 0-1962.0724
95: , p5_a7 NUMBER := 0-1962.0724
96: , p5_a8 NUMBER := 0-1962.0724
97: , p5_a9 DATE := fnd_api.g_miss_date
98: , p5_a10 DATE := fnd_api.g_miss_date
99: , p5_a11 DATE := fnd_api.g_miss_date
100: , p5_a12 NUMBER := 0-1962.0724
101: , p5_a13 DATE := fnd_api.g_miss_date
94: , p5_a6 NUMBER := 0-1962.0724
95: , p5_a7 NUMBER := 0-1962.0724
96: , p5_a8 NUMBER := 0-1962.0724
97: , p5_a9 DATE := fnd_api.g_miss_date
98: , p5_a10 DATE := fnd_api.g_miss_date
99: , p5_a11 DATE := fnd_api.g_miss_date
100: , p5_a12 NUMBER := 0-1962.0724
101: , p5_a13 DATE := fnd_api.g_miss_date
102: , p5_a14 NUMBER := 0-1962.0724
95: , p5_a7 NUMBER := 0-1962.0724
96: , p5_a8 NUMBER := 0-1962.0724
97: , p5_a9 DATE := fnd_api.g_miss_date
98: , p5_a10 DATE := fnd_api.g_miss_date
99: , p5_a11 DATE := fnd_api.g_miss_date
100: , p5_a12 NUMBER := 0-1962.0724
101: , p5_a13 DATE := fnd_api.g_miss_date
102: , p5_a14 NUMBER := 0-1962.0724
103: , p5_a15 DATE := fnd_api.g_miss_date
97: , p5_a9 DATE := fnd_api.g_miss_date
98: , p5_a10 DATE := fnd_api.g_miss_date
99: , p5_a11 DATE := fnd_api.g_miss_date
100: , p5_a12 NUMBER := 0-1962.0724
101: , p5_a13 DATE := fnd_api.g_miss_date
102: , p5_a14 NUMBER := 0-1962.0724
103: , p5_a15 DATE := fnd_api.g_miss_date
104: , p5_a16 NUMBER := 0-1962.0724
105: );
99: , p5_a11 DATE := fnd_api.g_miss_date
100: , p5_a12 NUMBER := 0-1962.0724
101: , p5_a13 DATE := fnd_api.g_miss_date
102: , p5_a14 NUMBER := 0-1962.0724
103: , p5_a15 DATE := fnd_api.g_miss_date
104: , p5_a16 NUMBER := 0-1962.0724
105: );
106: procedure lock_buckets(p_api_version NUMBER
107: , p_init_msg_list VARCHAR2
150: , p6_a16 out nocopy NUMBER
151: , p5_a0 NUMBER := 0-1962.0724
152: , p5_a1 NUMBER := 0-1962.0724
153: , p5_a2 NUMBER := 0-1962.0724
154: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
155: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a5 NUMBER := 0-1962.0724
157: , p5_a6 NUMBER := 0-1962.0724
158: , p5_a7 NUMBER := 0-1962.0724
151: , p5_a0 NUMBER := 0-1962.0724
152: , p5_a1 NUMBER := 0-1962.0724
153: , p5_a2 NUMBER := 0-1962.0724
154: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
155: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
156: , p5_a5 NUMBER := 0-1962.0724
157: , p5_a6 NUMBER := 0-1962.0724
158: , p5_a7 NUMBER := 0-1962.0724
159: , p5_a8 NUMBER := 0-1962.0724
156: , p5_a5 NUMBER := 0-1962.0724
157: , p5_a6 NUMBER := 0-1962.0724
158: , p5_a7 NUMBER := 0-1962.0724
159: , p5_a8 NUMBER := 0-1962.0724
160: , p5_a9 DATE := fnd_api.g_miss_date
161: , p5_a10 DATE := fnd_api.g_miss_date
162: , p5_a11 DATE := fnd_api.g_miss_date
163: , p5_a12 NUMBER := 0-1962.0724
164: , p5_a13 DATE := fnd_api.g_miss_date
157: , p5_a6 NUMBER := 0-1962.0724
158: , p5_a7 NUMBER := 0-1962.0724
159: , p5_a8 NUMBER := 0-1962.0724
160: , p5_a9 DATE := fnd_api.g_miss_date
161: , p5_a10 DATE := fnd_api.g_miss_date
162: , p5_a11 DATE := fnd_api.g_miss_date
163: , p5_a12 NUMBER := 0-1962.0724
164: , p5_a13 DATE := fnd_api.g_miss_date
165: , p5_a14 NUMBER := 0-1962.0724
158: , p5_a7 NUMBER := 0-1962.0724
159: , p5_a8 NUMBER := 0-1962.0724
160: , p5_a9 DATE := fnd_api.g_miss_date
161: , p5_a10 DATE := fnd_api.g_miss_date
162: , p5_a11 DATE := fnd_api.g_miss_date
163: , p5_a12 NUMBER := 0-1962.0724
164: , p5_a13 DATE := fnd_api.g_miss_date
165: , p5_a14 NUMBER := 0-1962.0724
166: , p5_a15 DATE := fnd_api.g_miss_date
160: , p5_a9 DATE := fnd_api.g_miss_date
161: , p5_a10 DATE := fnd_api.g_miss_date
162: , p5_a11 DATE := fnd_api.g_miss_date
163: , p5_a12 NUMBER := 0-1962.0724
164: , p5_a13 DATE := fnd_api.g_miss_date
165: , p5_a14 NUMBER := 0-1962.0724
166: , p5_a15 DATE := fnd_api.g_miss_date
167: , p5_a16 NUMBER := 0-1962.0724
168: );
162: , p5_a11 DATE := fnd_api.g_miss_date
163: , p5_a12 NUMBER := 0-1962.0724
164: , p5_a13 DATE := fnd_api.g_miss_date
165: , p5_a14 NUMBER := 0-1962.0724
166: , p5_a15 DATE := fnd_api.g_miss_date
167: , p5_a16 NUMBER := 0-1962.0724
168: );
169: procedure update_buckets(p_api_version NUMBER
170: , p_init_msg_list VARCHAR2
213: , x_msg_data out nocopy VARCHAR2
214: , p5_a0 NUMBER := 0-1962.0724
215: , p5_a1 NUMBER := 0-1962.0724
216: , p5_a2 NUMBER := 0-1962.0724
217: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
218: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
219: , p5_a5 NUMBER := 0-1962.0724
220: , p5_a6 NUMBER := 0-1962.0724
221: , p5_a7 NUMBER := 0-1962.0724
214: , p5_a0 NUMBER := 0-1962.0724
215: , p5_a1 NUMBER := 0-1962.0724
216: , p5_a2 NUMBER := 0-1962.0724
217: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
218: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
219: , p5_a5 NUMBER := 0-1962.0724
220: , p5_a6 NUMBER := 0-1962.0724
221: , p5_a7 NUMBER := 0-1962.0724
222: , p5_a8 NUMBER := 0-1962.0724
219: , p5_a5 NUMBER := 0-1962.0724
220: , p5_a6 NUMBER := 0-1962.0724
221: , p5_a7 NUMBER := 0-1962.0724
222: , p5_a8 NUMBER := 0-1962.0724
223: , p5_a9 DATE := fnd_api.g_miss_date
224: , p5_a10 DATE := fnd_api.g_miss_date
225: , p5_a11 DATE := fnd_api.g_miss_date
226: , p5_a12 NUMBER := 0-1962.0724
227: , p5_a13 DATE := fnd_api.g_miss_date
220: , p5_a6 NUMBER := 0-1962.0724
221: , p5_a7 NUMBER := 0-1962.0724
222: , p5_a8 NUMBER := 0-1962.0724
223: , p5_a9 DATE := fnd_api.g_miss_date
224: , p5_a10 DATE := fnd_api.g_miss_date
225: , p5_a11 DATE := fnd_api.g_miss_date
226: , p5_a12 NUMBER := 0-1962.0724
227: , p5_a13 DATE := fnd_api.g_miss_date
228: , p5_a14 NUMBER := 0-1962.0724
221: , p5_a7 NUMBER := 0-1962.0724
222: , p5_a8 NUMBER := 0-1962.0724
223: , p5_a9 DATE := fnd_api.g_miss_date
224: , p5_a10 DATE := fnd_api.g_miss_date
225: , p5_a11 DATE := fnd_api.g_miss_date
226: , p5_a12 NUMBER := 0-1962.0724
227: , p5_a13 DATE := fnd_api.g_miss_date
228: , p5_a14 NUMBER := 0-1962.0724
229: , p5_a15 DATE := fnd_api.g_miss_date
223: , p5_a9 DATE := fnd_api.g_miss_date
224: , p5_a10 DATE := fnd_api.g_miss_date
225: , p5_a11 DATE := fnd_api.g_miss_date
226: , p5_a12 NUMBER := 0-1962.0724
227: , p5_a13 DATE := fnd_api.g_miss_date
228: , p5_a14 NUMBER := 0-1962.0724
229: , p5_a15 DATE := fnd_api.g_miss_date
230: , p5_a16 NUMBER := 0-1962.0724
231: );
225: , p5_a11 DATE := fnd_api.g_miss_date
226: , p5_a12 NUMBER := 0-1962.0724
227: , p5_a13 DATE := fnd_api.g_miss_date
228: , p5_a14 NUMBER := 0-1962.0724
229: , p5_a15 DATE := fnd_api.g_miss_date
230: , p5_a16 NUMBER := 0-1962.0724
231: );
232: procedure delete_buckets(p_api_version NUMBER
233: , p_init_msg_list VARCHAR2
259: , x_msg_data out nocopy VARCHAR2
260: , p5_a0 NUMBER := 0-1962.0724
261: , p5_a1 NUMBER := 0-1962.0724
262: , p5_a2 NUMBER := 0-1962.0724
263: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
264: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
265: , p5_a5 NUMBER := 0-1962.0724
266: , p5_a6 NUMBER := 0-1962.0724
267: , p5_a7 NUMBER := 0-1962.0724
260: , p5_a0 NUMBER := 0-1962.0724
261: , p5_a1 NUMBER := 0-1962.0724
262: , p5_a2 NUMBER := 0-1962.0724
263: , p5_a3 VARCHAR2 := fnd_api.g_miss_char
264: , p5_a4 VARCHAR2 := fnd_api.g_miss_char
265: , p5_a5 NUMBER := 0-1962.0724
266: , p5_a6 NUMBER := 0-1962.0724
267: , p5_a7 NUMBER := 0-1962.0724
268: , p5_a8 NUMBER := 0-1962.0724
265: , p5_a5 NUMBER := 0-1962.0724
266: , p5_a6 NUMBER := 0-1962.0724
267: , p5_a7 NUMBER := 0-1962.0724
268: , p5_a8 NUMBER := 0-1962.0724
269: , p5_a9 DATE := fnd_api.g_miss_date
270: , p5_a10 DATE := fnd_api.g_miss_date
271: , p5_a11 DATE := fnd_api.g_miss_date
272: , p5_a12 NUMBER := 0-1962.0724
273: , p5_a13 DATE := fnd_api.g_miss_date
266: , p5_a6 NUMBER := 0-1962.0724
267: , p5_a7 NUMBER := 0-1962.0724
268: , p5_a8 NUMBER := 0-1962.0724
269: , p5_a9 DATE := fnd_api.g_miss_date
270: , p5_a10 DATE := fnd_api.g_miss_date
271: , p5_a11 DATE := fnd_api.g_miss_date
272: , p5_a12 NUMBER := 0-1962.0724
273: , p5_a13 DATE := fnd_api.g_miss_date
274: , p5_a14 NUMBER := 0-1962.0724
267: , p5_a7 NUMBER := 0-1962.0724
268: , p5_a8 NUMBER := 0-1962.0724
269: , p5_a9 DATE := fnd_api.g_miss_date
270: , p5_a10 DATE := fnd_api.g_miss_date
271: , p5_a11 DATE := fnd_api.g_miss_date
272: , p5_a12 NUMBER := 0-1962.0724
273: , p5_a13 DATE := fnd_api.g_miss_date
274: , p5_a14 NUMBER := 0-1962.0724
275: , p5_a15 DATE := fnd_api.g_miss_date
269: , p5_a9 DATE := fnd_api.g_miss_date
270: , p5_a10 DATE := fnd_api.g_miss_date
271: , p5_a11 DATE := fnd_api.g_miss_date
272: , p5_a12 NUMBER := 0-1962.0724
273: , p5_a13 DATE := fnd_api.g_miss_date
274: , p5_a14 NUMBER := 0-1962.0724
275: , p5_a15 DATE := fnd_api.g_miss_date
276: , p5_a16 NUMBER := 0-1962.0724
277: );
271: , p5_a11 DATE := fnd_api.g_miss_date
272: , p5_a12 NUMBER := 0-1962.0724
273: , p5_a13 DATE := fnd_api.g_miss_date
274: , p5_a14 NUMBER := 0-1962.0724
275: , p5_a15 DATE := fnd_api.g_miss_date
276: , p5_a16 NUMBER := 0-1962.0724
277: );
278: procedure validate_buckets(p_api_version NUMBER
279: , p_init_msg_list VARCHAR2