DBA Data[Home] [Help]

PACKAGE: APPS.AHL_RA_SETUPS_PVT_W

Source


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;