1 package ahl_ra_setups_pvt_w as
2 /* $Header: AHLWRASS.pls 120.2 2005/09/15 00:13 sagarwal noship $ */
3 procedure create_setup_data(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , p_commit VARCHAR2
6 , p_validation_level NUMBER
7 , p_module_type VARCHAR2
8 , x_return_status out nocopy VARCHAR2
9 , x_msg_count out nocopy NUMBER
10 , x_msg_data out nocopy VARCHAR2
11 , p8_a0 in out nocopy NUMBER
12 , p8_a1 in out nocopy VARCHAR2
13 , p8_a2 in out nocopy NUMBER
14 , p8_a3 in out nocopy VARCHAR2
15 , p8_a4 in out nocopy VARCHAR2
16 , p8_a5 in out nocopy NUMBER
17 , p8_a6 in out nocopy NUMBER
18 , p8_a7 in out nocopy DATE
19 , p8_a8 in out nocopy NUMBER
20 , p8_a9 in out nocopy DATE
21 , p8_a10 in out nocopy NUMBER
22 , p8_a11 in out nocopy NUMBER
23 , p8_a12 in out nocopy VARCHAR2
24 , p8_a13 in out nocopy VARCHAR2
25 , p8_a14 in out nocopy VARCHAR2
26 , p8_a15 in out nocopy VARCHAR2
27 , p8_a16 in out nocopy VARCHAR2
28 , p8_a17 in out nocopy VARCHAR2
29 , p8_a18 in out nocopy VARCHAR2
30 , p8_a19 in out nocopy VARCHAR2
31 , p8_a20 in out nocopy VARCHAR2
32 , p8_a21 in out nocopy VARCHAR2
33 , p8_a22 in out nocopy VARCHAR2
34 , p8_a23 in out nocopy VARCHAR2
35 , p8_a24 in out nocopy VARCHAR2
36 , p8_a25 in out nocopy VARCHAR2
37 , p8_a26 in out nocopy VARCHAR2
38 , p8_a27 in out nocopy VARCHAR2
39 );
40 procedure delete_setup_data(p_api_version NUMBER
41 , p_init_msg_list VARCHAR2
42 , p_commit VARCHAR2
43 , p_validation_level NUMBER
44 , p_module_type VARCHAR2
45 , x_return_status out nocopy VARCHAR2
46 , x_msg_count out nocopy NUMBER
47 , x_msg_data out nocopy VARCHAR2
48 , p8_a0 NUMBER
49 , p8_a1 VARCHAR2
50 , p8_a2 NUMBER
51 , p8_a3 VARCHAR2
52 , p8_a4 VARCHAR2
53 , p8_a5 NUMBER
54 , p8_a6 NUMBER
55 , p8_a7 DATE
56 , p8_a8 NUMBER
57 , p8_a9 DATE
58 , p8_a10 NUMBER
59 , p8_a11 NUMBER
60 , p8_a12 VARCHAR2
61 , p8_a13 VARCHAR2
62 , p8_a14 VARCHAR2
63 , p8_a15 VARCHAR2
64 , p8_a16 VARCHAR2
65 , p8_a17 VARCHAR2
66 , p8_a18 VARCHAR2
67 , p8_a19 VARCHAR2
68 , p8_a20 VARCHAR2
69 , p8_a21 VARCHAR2
70 , p8_a22 VARCHAR2
71 , p8_a23 VARCHAR2
72 , p8_a24 VARCHAR2
73 , p8_a25 VARCHAR2
74 , p8_a26 VARCHAR2
75 , p8_a27 VARCHAR2
76 );
77 procedure create_reliability_data(p_api_version NUMBER
78 , p_init_msg_list VARCHAR2
79 , p_commit VARCHAR2
80 , p_validation_level NUMBER
81 , p_module_type VARCHAR2
82 , x_return_status out nocopy VARCHAR2
83 , x_msg_count out nocopy NUMBER
84 , x_msg_data out nocopy VARCHAR2
85 , p8_a0 in out nocopy NUMBER
86 , p8_a1 in out nocopy NUMBER
87 , p8_a2 in out nocopy NUMBER
88 , p8_a3 in out nocopy NUMBER
89 , p8_a4 in out nocopy VARCHAR2
90 , p8_a5 in out nocopy NUMBER
91 , p8_a6 in out nocopy VARCHAR2
92 , p8_a7 in out nocopy NUMBER
93 , p8_a8 in out nocopy NUMBER
94 , p8_a9 in out nocopy DATE
95 , p8_a10 in out nocopy NUMBER
96 , p8_a11 in out nocopy DATE
97 , p8_a12 in out nocopy NUMBER
98 , p8_a13 in out nocopy NUMBER
99 , p8_a14 in out nocopy VARCHAR2
100 , p8_a15 in out nocopy VARCHAR2
101 , p8_a16 in out nocopy VARCHAR2
102 , p8_a17 in out nocopy VARCHAR2
103 , p8_a18 in out nocopy VARCHAR2
104 , p8_a19 in out nocopy VARCHAR2
105 , p8_a20 in out nocopy VARCHAR2
106 , p8_a21 in out nocopy VARCHAR2
107 , p8_a22 in out nocopy VARCHAR2
108 , p8_a23 in out nocopy VARCHAR2
109 , p8_a24 in out nocopy VARCHAR2
110 , p8_a25 in out nocopy VARCHAR2
111 , p8_a26 in out nocopy VARCHAR2
112 , p8_a27 in out nocopy VARCHAR2
113 , p8_a28 in out nocopy VARCHAR2
114 , p8_a29 in out nocopy VARCHAR2
115 );
116 procedure delete_reliability_data(p_api_version NUMBER
117 , p_init_msg_list VARCHAR2
118 , p_commit VARCHAR2
119 , p_validation_level NUMBER
120 , p_module_type VARCHAR2
121 , x_return_status out nocopy VARCHAR2
122 , x_msg_count out nocopy NUMBER
123 , x_msg_data out nocopy VARCHAR2
124 , p8_a0 NUMBER
125 , p8_a1 NUMBER
126 , p8_a2 NUMBER
127 , p8_a3 NUMBER
128 , p8_a4 VARCHAR2
129 , p8_a5 NUMBER
130 , p8_a6 VARCHAR2
131 , p8_a7 NUMBER
132 , p8_a8 NUMBER
133 , p8_a9 DATE
134 , p8_a10 NUMBER
135 , p8_a11 DATE
136 , p8_a12 NUMBER
137 , p8_a13 NUMBER
138 , p8_a14 VARCHAR2
139 , p8_a15 VARCHAR2
140 , p8_a16 VARCHAR2
141 , p8_a17 VARCHAR2
142 , p8_a18 VARCHAR2
143 , p8_a19 VARCHAR2
144 , p8_a20 VARCHAR2
145 , p8_a21 VARCHAR2
146 , p8_a22 VARCHAR2
147 , p8_a23 VARCHAR2
148 , p8_a24 VARCHAR2
149 , p8_a25 VARCHAR2
150 , p8_a26 VARCHAR2
151 , p8_a27 VARCHAR2
152 , p8_a28 VARCHAR2
153 , p8_a29 VARCHAR2
154 );
155 procedure create_mtbf_data(p_api_version NUMBER
156 , p_init_msg_list VARCHAR2
157 , p_commit VARCHAR2
158 , p_validation_level NUMBER
159 , p_module_type VARCHAR2
160 , x_return_status out nocopy VARCHAR2
161 , x_msg_count out nocopy NUMBER
162 , x_msg_data out nocopy VARCHAR2
163 , p8_a0 in out nocopy NUMBER
164 , p8_a1 in out nocopy NUMBER
165 , p8_a2 in out nocopy NUMBER
166 , p8_a3 in out nocopy NUMBER
167 , p8_a4 in out nocopy VARCHAR2
168 , p8_a5 in out nocopy NUMBER
169 , p8_a6 in out nocopy VARCHAR2
170 , p8_a7 in out nocopy NUMBER
171 , p8_a8 in out nocopy NUMBER
172 , p8_a9 in out nocopy DATE
173 , p8_a10 in out nocopy NUMBER
174 , p8_a11 in out nocopy DATE
175 , p8_a12 in out nocopy NUMBER
176 , p8_a13 in out nocopy NUMBER
177 , p8_a14 in out nocopy VARCHAR2
178 , p8_a15 in out nocopy VARCHAR2
179 , p8_a16 in out nocopy VARCHAR2
180 , p8_a17 in out nocopy VARCHAR2
181 , p8_a18 in out nocopy VARCHAR2
182 , p8_a19 in out nocopy VARCHAR2
183 , p8_a20 in out nocopy VARCHAR2
184 , p8_a21 in out nocopy VARCHAR2
185 , p8_a22 in out nocopy VARCHAR2
186 , p8_a23 in out nocopy VARCHAR2
187 , p8_a24 in out nocopy VARCHAR2
188 , p8_a25 in out nocopy VARCHAR2
189 , p8_a26 in out nocopy VARCHAR2
190 , p8_a27 in out nocopy VARCHAR2
191 , p8_a28 in out nocopy VARCHAR2
192 , p8_a29 in out nocopy VARCHAR2
193 , p9_a0 in out nocopy NUMBER
194 , p9_a1 in out nocopy NUMBER
195 , p9_a2 in out nocopy NUMBER
196 , p9_a3 in out nocopy NUMBER
197 , p9_a4 in out nocopy VARCHAR2
198 , p9_a5 in out nocopy NUMBER
199 , p9_a6 in out nocopy NUMBER
200 , p9_a7 in out nocopy DATE
201 , p9_a8 in out nocopy NUMBER
202 , p9_a9 in out nocopy DATE
203 , p9_a10 in out nocopy NUMBER
204 , p9_a11 in out nocopy NUMBER
205 , p9_a12 in out nocopy VARCHAR2
206 , p9_a13 in out nocopy VARCHAR2
207 , p9_a14 in out nocopy VARCHAR2
208 , p9_a15 in out nocopy VARCHAR2
209 , p9_a16 in out nocopy VARCHAR2
210 , p9_a17 in out nocopy VARCHAR2
211 , p9_a18 in out nocopy VARCHAR2
212 , p9_a19 in out nocopy VARCHAR2
213 , p9_a20 in out nocopy VARCHAR2
214 , p9_a21 in out nocopy VARCHAR2
215 , p9_a22 in out nocopy VARCHAR2
216 , p9_a23 in out nocopy VARCHAR2
217 , p9_a24 in out nocopy VARCHAR2
218 , p9_a25 in out nocopy VARCHAR2
219 , p9_a26 in out nocopy VARCHAR2
220 , p9_a27 in out nocopy VARCHAR2
221 );
222 procedure update_mtbf_data(p_api_version NUMBER
223 , p_init_msg_list VARCHAR2
224 , p_commit VARCHAR2
225 , p_validation_level NUMBER
226 , p_module_type VARCHAR2
227 , x_return_status out nocopy VARCHAR2
228 , x_msg_count out nocopy NUMBER
229 , x_msg_data out nocopy VARCHAR2
230 , p8_a0 in out nocopy NUMBER
231 , p8_a1 in out nocopy NUMBER
232 , p8_a2 in out nocopy NUMBER
233 , p8_a3 in out nocopy NUMBER
234 , p8_a4 in out nocopy VARCHAR2
235 , p8_a5 in out nocopy NUMBER
236 , p8_a6 in out nocopy VARCHAR2
237 , p8_a7 in out nocopy NUMBER
238 , p8_a8 in out nocopy NUMBER
239 , p8_a9 in out nocopy DATE
240 , p8_a10 in out nocopy NUMBER
241 , p8_a11 in out nocopy DATE
242 , p8_a12 in out nocopy NUMBER
243 , p8_a13 in out nocopy NUMBER
244 , p8_a14 in out nocopy VARCHAR2
245 , p8_a15 in out nocopy VARCHAR2
246 , p8_a16 in out nocopy VARCHAR2
247 , p8_a17 in out nocopy VARCHAR2
248 , p8_a18 in out nocopy VARCHAR2
249 , p8_a19 in out nocopy VARCHAR2
250 , p8_a20 in out nocopy VARCHAR2
251 , p8_a21 in out nocopy VARCHAR2
252 , p8_a22 in out nocopy VARCHAR2
253 , p8_a23 in out nocopy VARCHAR2
254 , p8_a24 in out nocopy VARCHAR2
255 , p8_a25 in out nocopy VARCHAR2
256 , p8_a26 in out nocopy VARCHAR2
257 , p8_a27 in out nocopy VARCHAR2
258 , p8_a28 in out nocopy VARCHAR2
259 , p8_a29 in out nocopy VARCHAR2
260 , p9_a0 in out nocopy NUMBER
261 , p9_a1 in out nocopy NUMBER
262 , p9_a2 in out nocopy NUMBER
263 , p9_a3 in out nocopy NUMBER
264 , p9_a4 in out nocopy VARCHAR2
265 , p9_a5 in out nocopy NUMBER
266 , p9_a6 in out nocopy NUMBER
267 , p9_a7 in out nocopy DATE
268 , p9_a8 in out nocopy NUMBER
269 , p9_a9 in out nocopy DATE
270 , p9_a10 in out nocopy NUMBER
271 , p9_a11 in out nocopy NUMBER
272 , p9_a12 in out nocopy VARCHAR2
273 , p9_a13 in out nocopy VARCHAR2
274 , p9_a14 in out nocopy VARCHAR2
275 , p9_a15 in out nocopy VARCHAR2
276 , p9_a16 in out nocopy VARCHAR2
277 , p9_a17 in out nocopy VARCHAR2
278 , p9_a18 in out nocopy VARCHAR2
279 , p9_a19 in out nocopy VARCHAR2
280 , p9_a20 in out nocopy VARCHAR2
281 , p9_a21 in out nocopy VARCHAR2
282 , p9_a22 in out nocopy VARCHAR2
283 , p9_a23 in out nocopy VARCHAR2
284 , p9_a24 in out nocopy VARCHAR2
285 , p9_a25 in out nocopy VARCHAR2
286 , p9_a26 in out nocopy VARCHAR2
287 , p9_a27 in out nocopy VARCHAR2
288 );
289 procedure delete_mtbf_data(p_api_version NUMBER
290 , p_init_msg_list VARCHAR2
291 , p_commit VARCHAR2
292 , p_validation_level NUMBER
293 , p_module_type VARCHAR2
294 , x_return_status out nocopy VARCHAR2
295 , x_msg_count out nocopy NUMBER
296 , x_msg_data out nocopy VARCHAR2
297 , p8_a0 in out nocopy NUMBER
298 , p8_a1 in out nocopy NUMBER
299 , p8_a2 in out nocopy NUMBER
300 , p8_a3 in out nocopy NUMBER
301 , p8_a4 in out nocopy VARCHAR2
302 , p8_a5 in out nocopy NUMBER
303 , p8_a6 in out nocopy VARCHAR2
307 , p8_a10 in out nocopy NUMBER
304 , p8_a7 in out nocopy NUMBER
305 , p8_a8 in out nocopy NUMBER
306 , p8_a9 in out nocopy DATE
308 , p8_a11 in out nocopy DATE
309 , p8_a12 in out nocopy NUMBER
310 , p8_a13 in out nocopy NUMBER
311 , p8_a14 in out nocopy VARCHAR2
312 , p8_a15 in out nocopy VARCHAR2
313 , p8_a16 in out nocopy VARCHAR2
314 , p8_a17 in out nocopy VARCHAR2
315 , p8_a18 in out nocopy VARCHAR2
316 , p8_a19 in out nocopy VARCHAR2
317 , p8_a20 in out nocopy VARCHAR2
318 , p8_a21 in out nocopy VARCHAR2
319 , p8_a22 in out nocopy VARCHAR2
320 , p8_a23 in out nocopy VARCHAR2
321 , p8_a24 in out nocopy VARCHAR2
322 , p8_a25 in out nocopy VARCHAR2
323 , p8_a26 in out nocopy VARCHAR2
324 , p8_a27 in out nocopy VARCHAR2
325 , p8_a28 in out nocopy VARCHAR2
326 , p8_a29 in out nocopy VARCHAR2
327 , p9_a0 NUMBER
328 , p9_a1 NUMBER
329 , p9_a2 NUMBER
330 , p9_a3 NUMBER
331 , p9_a4 VARCHAR2
332 , p9_a5 NUMBER
333 , p9_a6 NUMBER
334 , p9_a7 DATE
335 , p9_a8 NUMBER
336 , p9_a9 DATE
337 , p9_a10 NUMBER
338 , p9_a11 NUMBER
339 , p9_a12 VARCHAR2
340 , p9_a13 VARCHAR2
341 , p9_a14 VARCHAR2
342 , p9_a15 VARCHAR2
343 , p9_a16 VARCHAR2
344 , p9_a17 VARCHAR2
345 , p9_a18 VARCHAR2
346 , p9_a19 VARCHAR2
347 , p9_a20 VARCHAR2
348 , p9_a21 VARCHAR2
349 , p9_a22 VARCHAR2
350 , p9_a23 VARCHAR2
351 , p9_a24 VARCHAR2
352 , p9_a25 VARCHAR2
353 , p9_a26 VARCHAR2
354 , p9_a27 VARCHAR2
355 );
356 procedure create_counter_assoc(p_api_version NUMBER
357 , p_init_msg_list VARCHAR2
358 , p_commit VARCHAR2
359 , p_validation_level NUMBER
360 , p_module_type VARCHAR2
361 , x_return_status out nocopy VARCHAR2
362 , x_msg_count out nocopy NUMBER
363 , x_msg_data out nocopy VARCHAR2
364 , p8_a0 in out nocopy NUMBER
365 , p8_a1 in out nocopy NUMBER
366 , p8_a2 in out nocopy NUMBER
367 , p8_a3 in out nocopy VARCHAR2
368 , p8_a4 in out nocopy VARCHAR2
369 , p8_a5 in out nocopy NUMBER
370 , p8_a6 in out nocopy NUMBER
371 , p8_a7 in out nocopy DATE
372 , p8_a8 in out nocopy NUMBER
373 , p8_a9 in out nocopy DATE
374 , p8_a10 in out nocopy NUMBER
375 , p8_a11 in out nocopy NUMBER
376 , p8_a12 in out nocopy VARCHAR2
377 , p8_a13 in out nocopy VARCHAR2
378 , p8_a14 in out nocopy VARCHAR2
379 , p8_a15 in out nocopy VARCHAR2
380 , p8_a16 in out nocopy VARCHAR2
381 , p8_a17 in out nocopy VARCHAR2
382 , p8_a18 in out nocopy VARCHAR2
383 , p8_a19 in out nocopy VARCHAR2
384 , p8_a20 in out nocopy VARCHAR2
385 , p8_a21 in out nocopy VARCHAR2
386 , p8_a22 in out nocopy VARCHAR2
387 , p8_a23 in out nocopy VARCHAR2
388 , p8_a24 in out nocopy VARCHAR2
389 , p8_a25 in out nocopy VARCHAR2
390 , p8_a26 in out nocopy VARCHAR2
391 , p8_a27 in out nocopy VARCHAR2
392 );
393 procedure delete_counter_assoc(p_api_version NUMBER
394 , p_init_msg_list VARCHAR2
395 , p_commit VARCHAR2
396 , p_validation_level NUMBER
397 , p_module_type VARCHAR2
398 , x_return_status out nocopy VARCHAR2
399 , x_msg_count out nocopy NUMBER
400 , x_msg_data out nocopy VARCHAR2
401 , p8_a0 NUMBER
402 , p8_a1 NUMBER
403 , p8_a2 NUMBER
404 , p8_a3 VARCHAR2
405 , p8_a4 VARCHAR2
406 , p8_a5 NUMBER
407 , p8_a6 NUMBER
408 , p8_a7 DATE
409 , p8_a8 NUMBER
410 , p8_a9 DATE
411 , p8_a10 NUMBER
412 , p8_a11 NUMBER
413 , p8_a12 VARCHAR2
414 , p8_a13 VARCHAR2
415 , p8_a14 VARCHAR2
416 , p8_a15 VARCHAR2
417 , p8_a16 VARCHAR2
418 , p8_a17 VARCHAR2
419 , p8_a18 VARCHAR2
420 , p8_a19 VARCHAR2
421 , p8_a20 VARCHAR2
422 , p8_a21 VARCHAR2
423 , p8_a22 VARCHAR2
424 , p8_a23 VARCHAR2
425 , p8_a24 VARCHAR2
426 , p8_a25 VARCHAR2
427 , p8_a26 VARCHAR2
428 , p8_a27 VARCHAR2
429 );
430 procedure create_fct_assoc_data(p_api_version NUMBER
431 , p_init_msg_list VARCHAR2
432 , p_commit VARCHAR2
433 , p_validation_level NUMBER
434 , p_module_type VARCHAR2
435 , x_return_status out nocopy VARCHAR2
436 , x_msg_count out nocopy NUMBER
437 , x_msg_data out nocopy VARCHAR2
438 , p8_a0 in out nocopy NUMBER
439 , p8_a1 in out nocopy VARCHAR2
440 , p8_a2 in out nocopy VARCHAR2
441 , p8_a3 in out nocopy NUMBER
442 , p8_a4 in out nocopy NUMBER
443 , p8_a5 in out nocopy NUMBER
444 , p8_a6 in out nocopy VARCHAR2
445 , p8_a7 in out nocopy NUMBER
446 , p8_a8 in out nocopy NUMBER
447 , p8_a9 in out nocopy DATE
448 , p8_a10 in out nocopy NUMBER
449 , p8_a11 in out nocopy DATE
450 , p8_a12 in out nocopy NUMBER
451 , p8_a13 in out nocopy NUMBER
452 , p8_a14 in out nocopy VARCHAR2
453 , p8_a15 in out nocopy VARCHAR2
454 , p8_a16 in out nocopy VARCHAR2
455 , p8_a17 in out nocopy VARCHAR2
456 , p8_a18 in out nocopy VARCHAR2
457 , p8_a19 in out nocopy VARCHAR2
458 , p8_a20 in out nocopy VARCHAR2
459 , p8_a21 in out nocopy VARCHAR2
460 , p8_a22 in out nocopy VARCHAR2
461 , p8_a23 in out nocopy VARCHAR2
462 , p8_a24 in out nocopy VARCHAR2
463 , p8_a25 in out nocopy VARCHAR2
464 , p8_a26 in out nocopy VARCHAR2
465 , p8_a27 in out nocopy VARCHAR2
466 , p8_a28 in out nocopy VARCHAR2
467 , p8_a29 in out nocopy VARCHAR2
468 );
469 procedure update_fct_assoc_data(p_api_version NUMBER
470 , p_init_msg_list VARCHAR2
471 , p_commit VARCHAR2
472 , p_validation_level NUMBER
473 , p_module_type VARCHAR2
474 , x_return_status out nocopy VARCHAR2
475 , x_msg_count out nocopy NUMBER
476 , x_msg_data out nocopy VARCHAR2
477 , p8_a0 in out nocopy NUMBER
478 , p8_a1 in out nocopy VARCHAR2
479 , p8_a2 in out nocopy VARCHAR2
480 , p8_a3 in out nocopy NUMBER
481 , p8_a4 in out nocopy NUMBER
482 , p8_a5 in out nocopy NUMBER
483 , p8_a6 in out nocopy VARCHAR2
484 , p8_a7 in out nocopy NUMBER
485 , p8_a8 in out nocopy NUMBER
486 , p8_a9 in out nocopy DATE
487 , p8_a10 in out nocopy NUMBER
488 , p8_a11 in out nocopy DATE
489 , p8_a12 in out nocopy NUMBER
490 , p8_a13 in out nocopy NUMBER
491 , p8_a14 in out nocopy VARCHAR2
492 , p8_a15 in out nocopy VARCHAR2
493 , p8_a16 in out nocopy VARCHAR2
494 , p8_a17 in out nocopy VARCHAR2
495 , p8_a18 in out nocopy VARCHAR2
496 , p8_a19 in out nocopy VARCHAR2
497 , p8_a20 in out nocopy VARCHAR2
498 , p8_a21 in out nocopy VARCHAR2
499 , p8_a22 in out nocopy VARCHAR2
500 , p8_a23 in out nocopy VARCHAR2
501 , p8_a24 in out nocopy VARCHAR2
502 , p8_a25 in out nocopy VARCHAR2
503 , p8_a26 in out nocopy VARCHAR2
504 , p8_a27 in out nocopy VARCHAR2
505 , p8_a28 in out nocopy VARCHAR2
506 , p8_a29 in out nocopy VARCHAR2
507 );
508 procedure delete_fct_assoc_data(p_api_version NUMBER
509 , p_init_msg_list VARCHAR2
510 , p_commit VARCHAR2
511 , p_validation_level NUMBER
512 , p_module_type VARCHAR2
513 , x_return_status out nocopy VARCHAR2
514 , x_msg_count out nocopy NUMBER
515 , x_msg_data out nocopy VARCHAR2
516 , p8_a0 NUMBER
517 , p8_a1 VARCHAR2
518 , p8_a2 VARCHAR2
519 , p8_a3 NUMBER
520 , p8_a4 NUMBER
521 , p8_a5 NUMBER
522 , p8_a6 VARCHAR2
523 , p8_a7 NUMBER
524 , p8_a8 NUMBER
525 , p8_a9 DATE
526 , p8_a10 NUMBER
527 , p8_a11 DATE
528 , p8_a12 NUMBER
529 , p8_a13 NUMBER
530 , p8_a14 VARCHAR2
531 , p8_a15 VARCHAR2
532 , p8_a16 VARCHAR2
533 , p8_a17 VARCHAR2
534 , p8_a18 VARCHAR2
535 , p8_a19 VARCHAR2
536 , p8_a20 VARCHAR2
537 , p8_a21 VARCHAR2
538 , p8_a22 VARCHAR2
539 , p8_a23 VARCHAR2
540 , p8_a24 VARCHAR2
541 , p8_a25 VARCHAR2
542 , p8_a26 VARCHAR2
543 , p8_a27 VARCHAR2
544 , p8_a28 VARCHAR2
545 , p8_a29 VARCHAR2
546 );
547 end ahl_ra_setups_pvt_w;