DBA Data[Home] [Help]

PACKAGE: APPS.AHL_UA_UNIT_SCHEDULES_PVT_W

Source


1 package ahl_ua_unit_schedules_pvt_w as
2   /* $Header: AHLWUUSS.pls 120.3 2006/05/17 02:27 amsriniv noship $ */
3   procedure rosetta_table_copy_in_p3(t out nocopy ahl_ua_unit_schedules_pvt.unit_schedules_result_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_NUMBER_TABLE
6     , a3 JTF_VARCHAR2_TABLE_100
7     , a4 JTF_NUMBER_TABLE
8     , a5 JTF_VARCHAR2_TABLE_100
9     );
10   procedure rosetta_table_copy_out_p3(t ahl_ua_unit_schedules_pvt.unit_schedules_result_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
11     , a1 out nocopy JTF_NUMBER_TABLE
12     , a2 out nocopy JTF_NUMBER_TABLE
13     , a3 out nocopy JTF_VARCHAR2_TABLE_100
14     , a4 out nocopy JTF_NUMBER_TABLE
15     , a5 out nocopy JTF_VARCHAR2_TABLE_100
16     );
17 
18   procedure rosetta_table_copy_in_p6(t out nocopy ahl_ua_unit_schedules_pvt.unit_schedule_tbl_type, a0 JTF_NUMBER_TABLE
19     , a1 JTF_NUMBER_TABLE
20     , a2 JTF_VARCHAR2_TABLE_100
21     , a3 JTF_VARCHAR2_TABLE_100
22     , a4 JTF_NUMBER_TABLE
23     , a5 JTF_VARCHAR2_TABLE_300
24     , a6 JTF_NUMBER_TABLE
25     , a7 JTF_VARCHAR2_TABLE_300
26     , a8 JTF_NUMBER_TABLE
27     , a9 JTF_VARCHAR2_TABLE_300
28     , a10 JTF_NUMBER_TABLE
29     , a11 JTF_VARCHAR2_TABLE_300
30     , a12 JTF_DATE_TABLE
31     , a13 JTF_DATE_TABLE
32     , a14 JTF_VARCHAR2_TABLE_100
33     , a15 JTF_NUMBER_TABLE
34     , a16 JTF_NUMBER_TABLE
35     , a17 JTF_VARCHAR2_TABLE_100
36     , a18 JTF_VARCHAR2_TABLE_300
37     , a19 JTF_NUMBER_TABLE
38     , a20 JTF_VARCHAR2_TABLE_300
39     , a21 JTF_DATE_TABLE
40     , a22 JTF_NUMBER_TABLE
41     , a23 JTF_VARCHAR2_TABLE_100
42     , a24 JTF_VARCHAR2_TABLE_100
43     , a25 JTF_VARCHAR2_TABLE_100
44     , a26 JTF_VARCHAR2_TABLE_2000
45     , a27 JTF_VARCHAR2_TABLE_100
46     );
47   procedure rosetta_table_copy_out_p6(t ahl_ua_unit_schedules_pvt.unit_schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
48     , a1 out nocopy JTF_NUMBER_TABLE
49     , a2 out nocopy JTF_VARCHAR2_TABLE_100
50     , a3 out nocopy JTF_VARCHAR2_TABLE_100
51     , a4 out nocopy JTF_NUMBER_TABLE
52     , a5 out nocopy JTF_VARCHAR2_TABLE_300
53     , a6 out nocopy JTF_NUMBER_TABLE
54     , a7 out nocopy JTF_VARCHAR2_TABLE_300
55     , a8 out nocopy JTF_NUMBER_TABLE
56     , a9 out nocopy JTF_VARCHAR2_TABLE_300
57     , a10 out nocopy JTF_NUMBER_TABLE
58     , a11 out nocopy JTF_VARCHAR2_TABLE_300
59     , a12 out nocopy JTF_DATE_TABLE
60     , a13 out nocopy JTF_DATE_TABLE
61     , a14 out nocopy JTF_VARCHAR2_TABLE_100
62     , a15 out nocopy JTF_NUMBER_TABLE
63     , a16 out nocopy JTF_NUMBER_TABLE
64     , a17 out nocopy JTF_VARCHAR2_TABLE_100
65     , a18 out nocopy JTF_VARCHAR2_TABLE_300
66     , a19 out nocopy JTF_NUMBER_TABLE
67     , a20 out nocopy JTF_VARCHAR2_TABLE_300
68     , a21 out nocopy JTF_DATE_TABLE
69     , a22 out nocopy JTF_NUMBER_TABLE
70     , a23 out nocopy JTF_VARCHAR2_TABLE_100
71     , a24 out nocopy JTF_VARCHAR2_TABLE_100
72     , a25 out nocopy JTF_VARCHAR2_TABLE_100
73     , a26 out nocopy JTF_VARCHAR2_TABLE_2000
74     , a27 out nocopy JTF_VARCHAR2_TABLE_100
75     );
76 
77   procedure rosetta_table_copy_in_p8(t out nocopy ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type, a0 JTF_NUMBER_TABLE
78     , a1 JTF_NUMBER_TABLE
79     , a2 JTF_VARCHAR2_TABLE_100
80     , a3 JTF_VARCHAR2_TABLE_100
81     , a4 JTF_VARCHAR2_TABLE_100
82     , a5 JTF_VARCHAR2_TABLE_100
83     , a6 JTF_VARCHAR2_TABLE_100
84     , a7 JTF_NUMBER_TABLE
85     , a8 JTF_VARCHAR2_TABLE_300
86     , a9 JTF_NUMBER_TABLE
87     , a10 JTF_VARCHAR2_TABLE_300
88     , a11 JTF_DATE_TABLE
89     , a12 JTF_DATE_TABLE
90     , a13 JTF_VARCHAR2_TABLE_100
91     , a14 JTF_NUMBER_TABLE
92     , a15 JTF_NUMBER_TABLE
93     , a16 JTF_VARCHAR2_TABLE_100
94     , a17 JTF_VARCHAR2_TABLE_300
95     , a18 JTF_NUMBER_TABLE
96     , a19 JTF_VARCHAR2_TABLE_300
97     , a20 JTF_DATE_TABLE
98     , a21 JTF_NUMBER_TABLE
99     , a22 JTF_VARCHAR2_TABLE_100
100     , a23 JTF_VARCHAR2_TABLE_100
101     , a24 JTF_VARCHAR2_TABLE_100
102     , a25 JTF_VARCHAR2_TABLE_2000
103     , a26 JTF_VARCHAR2_TABLE_100
104     , a27 JTF_VARCHAR2_TABLE_100
105     );
106   procedure rosetta_table_copy_out_p8(t ahl_ua_unit_schedules_pvt.visit_schedule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
107     , a1 out nocopy JTF_NUMBER_TABLE
108     , a2 out nocopy JTF_VARCHAR2_TABLE_100
109     , a3 out nocopy JTF_VARCHAR2_TABLE_100
110     , a4 out nocopy JTF_VARCHAR2_TABLE_100
111     , a5 out nocopy JTF_VARCHAR2_TABLE_100
112     , a6 out nocopy JTF_VARCHAR2_TABLE_100
113     , a7 out nocopy JTF_NUMBER_TABLE
114     , a8 out nocopy JTF_VARCHAR2_TABLE_300
115     , a9 out nocopy JTF_NUMBER_TABLE
116     , a10 out nocopy JTF_VARCHAR2_TABLE_300
117     , a11 out nocopy JTF_DATE_TABLE
118     , a12 out nocopy JTF_DATE_TABLE
119     , a13 out nocopy JTF_VARCHAR2_TABLE_100
120     , a14 out nocopy JTF_NUMBER_TABLE
121     , a15 out nocopy JTF_NUMBER_TABLE
122     , a16 out nocopy JTF_VARCHAR2_TABLE_100
123     , a17 out nocopy JTF_VARCHAR2_TABLE_300
124     , a18 out nocopy JTF_NUMBER_TABLE
125     , a19 out nocopy JTF_VARCHAR2_TABLE_300
126     , a20 out nocopy JTF_DATE_TABLE
127     , a21 out nocopy JTF_NUMBER_TABLE
128     , a22 out nocopy JTF_VARCHAR2_TABLE_100
129     , a23 out nocopy JTF_VARCHAR2_TABLE_100
130     , a24 out nocopy JTF_VARCHAR2_TABLE_100
131     , a25 out nocopy JTF_VARCHAR2_TABLE_2000
132     , a26 out nocopy JTF_VARCHAR2_TABLE_100
133     , a27 out nocopy JTF_VARCHAR2_TABLE_100
134     );
135 
136   procedure search_unit_schedules(p_api_version  NUMBER
137     , x_return_status out nocopy  VARCHAR2
138     , x_msg_count out nocopy  NUMBER
139     , x_msg_data out nocopy  VARCHAR2
140     , p4_a0  VARCHAR2
141     , p4_a1  VARCHAR2
142     , p4_a2  VARCHAR2
143     , p4_a3  DATE
144     , p4_a4  NUMBER
145     , p4_a5  VARCHAR2
146     , p5_a0 out nocopy JTF_NUMBER_TABLE
147     , p5_a1 out nocopy JTF_NUMBER_TABLE
148     , p5_a2 out nocopy JTF_NUMBER_TABLE
149     , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
150     , p5_a4 out nocopy JTF_NUMBER_TABLE
151     , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
152   );
153   procedure get_mevent_details(p_api_version  NUMBER
154     , p_module_type  VARCHAR2
155     , x_return_status out nocopy  VARCHAR2
156     , x_msg_count out nocopy  NUMBER
157     , x_msg_data out nocopy  VARCHAR2
158     , p5_a0 in out nocopy  NUMBER
159     , p5_a1 in out nocopy  VARCHAR2
160     , p5_a2 in out nocopy  DATE
161     , p5_a3 in out nocopy  DATE
162     , p5_a4 in out nocopy  VARCHAR2
163     , p5_a5 in out nocopy  VARCHAR2
164     , p5_a6 in out nocopy  NUMBER
165     , p5_a7 in out nocopy  VARCHAR2
166     , p5_a8 in out nocopy  VARCHAR2
167     , p6_a0 out nocopy JTF_NUMBER_TABLE
168     , p6_a1 out nocopy JTF_NUMBER_TABLE
169     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
170     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
171     , p6_a4 out nocopy JTF_NUMBER_TABLE
172     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
173     , p6_a6 out nocopy JTF_NUMBER_TABLE
174     , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
175     , p6_a8 out nocopy JTF_NUMBER_TABLE
176     , p6_a9 out nocopy JTF_VARCHAR2_TABLE_300
177     , p6_a10 out nocopy JTF_NUMBER_TABLE
178     , p6_a11 out nocopy JTF_VARCHAR2_TABLE_300
179     , p6_a12 out nocopy JTF_DATE_TABLE
180     , p6_a13 out nocopy JTF_DATE_TABLE
181     , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
182     , p6_a15 out nocopy JTF_NUMBER_TABLE
183     , p6_a16 out nocopy JTF_NUMBER_TABLE
184     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
185     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
186     , p6_a19 out nocopy JTF_NUMBER_TABLE
187     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_300
188     , p6_a21 out nocopy JTF_DATE_TABLE
189     , p6_a22 out nocopy JTF_NUMBER_TABLE
190     , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
191     , p6_a24 out nocopy JTF_VARCHAR2_TABLE_100
192     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
193     , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
194     , p6_a27 out nocopy JTF_VARCHAR2_TABLE_100
195     , p7_a0 out nocopy JTF_NUMBER_TABLE
196     , p7_a1 out nocopy JTF_NUMBER_TABLE
197     , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
198     , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
199     , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
200     , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
201     , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
202     , p7_a7 out nocopy JTF_NUMBER_TABLE
203     , p7_a8 out nocopy JTF_VARCHAR2_TABLE_300
204     , p7_a9 out nocopy JTF_NUMBER_TABLE
205     , p7_a10 out nocopy JTF_VARCHAR2_TABLE_300
206     , p7_a11 out nocopy JTF_DATE_TABLE
207     , p7_a12 out nocopy JTF_DATE_TABLE
208     , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
209     , p7_a14 out nocopy JTF_NUMBER_TABLE
210     , p7_a15 out nocopy JTF_NUMBER_TABLE
211     , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
212     , p7_a17 out nocopy JTF_VARCHAR2_TABLE_300
213     , p7_a18 out nocopy JTF_NUMBER_TABLE
214     , p7_a19 out nocopy JTF_VARCHAR2_TABLE_300
215     , p7_a20 out nocopy JTF_DATE_TABLE
216     , p7_a21 out nocopy JTF_NUMBER_TABLE
217     , p7_a22 out nocopy JTF_VARCHAR2_TABLE_100
218     , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
219     , p7_a24 out nocopy JTF_VARCHAR2_TABLE_100
220     , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000
221     , p7_a26 out nocopy JTF_VARCHAR2_TABLE_100
222     , p7_a27 out nocopy JTF_VARCHAR2_TABLE_100
223   );
224   procedure get_prec_succ_event_info(p_api_version  NUMBER
225     , x_return_status out nocopy  VARCHAR2
226     , x_msg_count out nocopy  NUMBER
227     , x_msg_data out nocopy  VARCHAR2
228     , p_unit_config_id  NUMBER
229     , p_start_date_time  date
230     , p_end_date_time  date
231     , p7_a0 out nocopy  NUMBER
232     , p7_a1 out nocopy  VARCHAR2
233     , p7_a2 out nocopy  NUMBER
234     , p7_a3 out nocopy  NUMBER
235     , p7_a4 out nocopy  DATE
236     , p7_a5 out nocopy  NUMBER
237     , p7_a6 out nocopy  DATE
238     , p7_a7 out nocopy  NUMBER
239     , p7_a8 out nocopy  NUMBER
240     , p7_a9 out nocopy  NUMBER
241     , p7_a10 out nocopy  VARCHAR2
242     , p7_a11 out nocopy  NUMBER
243     , p7_a12 out nocopy  VARCHAR2
244     , p7_a13 out nocopy  NUMBER
245     , p7_a14 out nocopy  VARCHAR2
246     , p7_a15 out nocopy  VARCHAR2
247     , p7_a16 out nocopy  VARCHAR2
248     , p7_a17 out nocopy  DATE
249     , p7_a18 out nocopy  NUMBER
250     , p7_a19 out nocopy  NUMBER
251     , p7_a20 out nocopy  DATE
252     , p7_a21 out nocopy  NUMBER
253     , p7_a22 out nocopy  NUMBER
254     , p7_a23 out nocopy  DATE
255     , p7_a24 out nocopy  DATE
256     , p7_a25 out nocopy  VARCHAR2
257     , p7_a26 out nocopy  VARCHAR2
258     , p7_a27 out nocopy  VARCHAR2
259     , p7_a28 out nocopy  VARCHAR2
260     , p7_a29 out nocopy  NUMBER
261     , p7_a30 out nocopy  VARCHAR2
262     , p7_a31 out nocopy  NUMBER
263     , p7_a32 out nocopy  VARCHAR2
264     , p7_a33 out nocopy  NUMBER
265     , p7_a34 out nocopy  VARCHAR2
266     , p7_a35 out nocopy  NUMBER
267     , p7_a36 out nocopy  NUMBER
268     , p7_a37 out nocopy  VARCHAR2
269     , p7_a38 out nocopy  VARCHAR2
270     , p7_a39 out nocopy  VARCHAR2
271     , p7_a40 out nocopy  VARCHAR2
272     , p7_a41 out nocopy  VARCHAR2
273     , p7_a42 out nocopy  VARCHAR2
274     , p7_a43 out nocopy  NUMBER
275     , p7_a44 out nocopy  NUMBER
276     , p7_a45 out nocopy  VARCHAR2
277     , p7_a46 out nocopy  NUMBER
278     , p7_a47 out nocopy  VARCHAR2
279     , p7_a48 out nocopy  VARCHAR2
280     , p7_a49 out nocopy  VARCHAR2
281     , p7_a50 out nocopy  VARCHAR2
282     , p7_a51 out nocopy  VARCHAR2
283     , p7_a52 out nocopy  VARCHAR2
284     , p7_a53 out nocopy  VARCHAR2
285     , p7_a54 out nocopy  VARCHAR2
286     , p7_a55 out nocopy  VARCHAR2
287     , p7_a56 out nocopy  VARCHAR2
288     , p7_a57 out nocopy  VARCHAR2
289     , p7_a58 out nocopy  VARCHAR2
290     , p7_a59 out nocopy  VARCHAR2
291     , p7_a60 out nocopy  VARCHAR2
292     , p7_a61 out nocopy  VARCHAR2
293     , p7_a62 out nocopy  VARCHAR2
294     , p7_a63 out nocopy  VARCHAR2
295     , p7_a64 out nocopy  VARCHAR2
296     , p7_a65 out nocopy  VARCHAR2
297     , p7_a66 out nocopy  VARCHAR2
298     , p7_a67 out nocopy  NUMBER
299     , p7_a68 out nocopy  VARCHAR2
300     , p7_a69 out nocopy  VARCHAR2
301     , p7_a70 out nocopy  NUMBER
302     , p7_a71 out nocopy  VARCHAR2
303     , p7_a72 out nocopy  VARCHAR2
304     , p7_a73 out nocopy  NUMBER
305     , p7_a74 out nocopy  VARCHAR2
306     , p8_a0 out nocopy  NUMBER
307     , p8_a1 out nocopy  VARCHAR2
308     , p8_a2 out nocopy  VARCHAR2
309     , p8_a3 out nocopy  DATE
310     , p8_a4 out nocopy  DATE
311     , p8_a5 out nocopy  NUMBER
312     , p8_a6 out nocopy  VARCHAR2
313     , p8_a7 out nocopy  NUMBER
314     , p8_a8 out nocopy  VARCHAR2
315     , p8_a9 out nocopy  DATE
316     , p8_a10 out nocopy  DATE
317     , p8_a11 out nocopy  NUMBER
318     , p8_a12 out nocopy  VARCHAR2
319     , p8_a13 out nocopy  NUMBER
320     , p8_a14 out nocopy  VARCHAR2
321     , p8_a15 out nocopy  NUMBER
322     , p8_a16 out nocopy  NUMBER
323     , p8_a17 out nocopy  VARCHAR2
324     , p8_a18 out nocopy  NUMBER
325     , p8_a19 out nocopy  VARCHAR2
326     , p8_a20 out nocopy  VARCHAR2
327     , p8_a21 out nocopy  VARCHAR2
328     , p8_a22 out nocopy  VARCHAR2
329     , p8_a23 out nocopy  VARCHAR2
330     , p8_a24 out nocopy  NUMBER
331     , p8_a25 out nocopy  VARCHAR2
332     , p8_a26 out nocopy  VARCHAR2
333     , p8_a27 out nocopy  VARCHAR2
334     , p8_a28 out nocopy  VARCHAR2
335     , p8_a29 out nocopy  VARCHAR2
336     , p8_a30 out nocopy  VARCHAR2
337     , p8_a31 out nocopy  VARCHAR2
338     , p8_a32 out nocopy  VARCHAR2
339     , p8_a33 out nocopy  VARCHAR2
340     , p8_a34 out nocopy  VARCHAR2
341     , p8_a35 out nocopy  VARCHAR2
342     , p8_a36 out nocopy  VARCHAR2
343     , p8_a37 out nocopy  VARCHAR2
344     , p8_a38 out nocopy  VARCHAR2
345     , p8_a39 out nocopy  VARCHAR2
346     , p8_a40 out nocopy  VARCHAR2
347     , p8_a41 out nocopy  VARCHAR2
348     , p8_a42 out nocopy  VARCHAR2
349     , p8_a43 out nocopy  VARCHAR2
350     , p8_a44 out nocopy  VARCHAR2
351     , x_is_prec_conflict out nocopy  VARCHAR2
352     , x_is_prec_org_in_ou out nocopy  VARCHAR2
353     , p11_a0 out nocopy  NUMBER
354     , p11_a1 out nocopy  VARCHAR2
355     , p11_a2 out nocopy  NUMBER
356     , p11_a3 out nocopy  NUMBER
357     , p11_a4 out nocopy  DATE
358     , p11_a5 out nocopy  NUMBER
359     , p11_a6 out nocopy  DATE
360     , p11_a7 out nocopy  NUMBER
361     , p11_a8 out nocopy  NUMBER
362     , p11_a9 out nocopy  NUMBER
363     , p11_a10 out nocopy  VARCHAR2
364     , p11_a11 out nocopy  NUMBER
365     , p11_a12 out nocopy  VARCHAR2
366     , p11_a13 out nocopy  NUMBER
367     , p11_a14 out nocopy  VARCHAR2
368     , p11_a15 out nocopy  VARCHAR2
369     , p11_a16 out nocopy  VARCHAR2
370     , p11_a17 out nocopy  DATE
371     , p11_a18 out nocopy  NUMBER
372     , p11_a19 out nocopy  NUMBER
373     , p11_a20 out nocopy  DATE
374     , p11_a21 out nocopy  NUMBER
375     , p11_a22 out nocopy  NUMBER
376     , p11_a23 out nocopy  DATE
377     , p11_a24 out nocopy  DATE
378     , p11_a25 out nocopy  VARCHAR2
379     , p11_a26 out nocopy  VARCHAR2
380     , p11_a27 out nocopy  VARCHAR2
381     , p11_a28 out nocopy  VARCHAR2
382     , p11_a29 out nocopy  NUMBER
383     , p11_a30 out nocopy  VARCHAR2
384     , p11_a31 out nocopy  NUMBER
385     , p11_a32 out nocopy  VARCHAR2
386     , p11_a33 out nocopy  NUMBER
387     , p11_a34 out nocopy  VARCHAR2
388     , p11_a35 out nocopy  NUMBER
389     , p11_a36 out nocopy  NUMBER
390     , p11_a37 out nocopy  VARCHAR2
391     , p11_a38 out nocopy  VARCHAR2
392     , p11_a39 out nocopy  VARCHAR2
393     , p11_a40 out nocopy  VARCHAR2
394     , p11_a41 out nocopy  VARCHAR2
395     , p11_a42 out nocopy  VARCHAR2
396     , p11_a43 out nocopy  NUMBER
397     , p11_a44 out nocopy  NUMBER
398     , p11_a45 out nocopy  VARCHAR2
399     , p11_a46 out nocopy  NUMBER
400     , p11_a47 out nocopy  VARCHAR2
401     , p11_a48 out nocopy  VARCHAR2
402     , p11_a49 out nocopy  VARCHAR2
403     , p11_a50 out nocopy  VARCHAR2
404     , p11_a51 out nocopy  VARCHAR2
405     , p11_a52 out nocopy  VARCHAR2
406     , p11_a53 out nocopy  VARCHAR2
407     , p11_a54 out nocopy  VARCHAR2
408     , p11_a55 out nocopy  VARCHAR2
409     , p11_a56 out nocopy  VARCHAR2
410     , p11_a57 out nocopy  VARCHAR2
411     , p11_a58 out nocopy  VARCHAR2
412     , p11_a59 out nocopy  VARCHAR2
413     , p11_a60 out nocopy  VARCHAR2
414     , p11_a61 out nocopy  VARCHAR2
415     , p11_a62 out nocopy  VARCHAR2
416     , p11_a63 out nocopy  VARCHAR2
417     , p11_a64 out nocopy  VARCHAR2
418     , p11_a65 out nocopy  VARCHAR2
419     , p11_a66 out nocopy  VARCHAR2
420     , p11_a67 out nocopy  NUMBER
421     , p11_a68 out nocopy  VARCHAR2
422     , p11_a69 out nocopy  VARCHAR2
423     , p11_a70 out nocopy  NUMBER
424     , p11_a71 out nocopy  VARCHAR2
425     , p11_a72 out nocopy  VARCHAR2
426     , p11_a73 out nocopy  NUMBER
427     , p11_a74 out nocopy  VARCHAR2
428     , p12_a0 out nocopy  NUMBER
429     , p12_a1 out nocopy  VARCHAR2
430     , p12_a2 out nocopy  VARCHAR2
431     , p12_a3 out nocopy  DATE
432     , p12_a4 out nocopy  DATE
433     , p12_a5 out nocopy  NUMBER
434     , p12_a6 out nocopy  VARCHAR2
435     , p12_a7 out nocopy  NUMBER
436     , p12_a8 out nocopy  VARCHAR2
437     , p12_a9 out nocopy  DATE
438     , p12_a10 out nocopy  DATE
439     , p12_a11 out nocopy  NUMBER
440     , p12_a12 out nocopy  VARCHAR2
441     , p12_a13 out nocopy  NUMBER
442     , p12_a14 out nocopy  VARCHAR2
443     , p12_a15 out nocopy  NUMBER
444     , p12_a16 out nocopy  NUMBER
445     , p12_a17 out nocopy  VARCHAR2
446     , p12_a18 out nocopy  NUMBER
447     , p12_a19 out nocopy  VARCHAR2
448     , p12_a20 out nocopy  VARCHAR2
449     , p12_a21 out nocopy  VARCHAR2
450     , p12_a22 out nocopy  VARCHAR2
451     , p12_a23 out nocopy  VARCHAR2
452     , p12_a24 out nocopy  NUMBER
453     , p12_a25 out nocopy  VARCHAR2
454     , p12_a26 out nocopy  VARCHAR2
455     , p12_a27 out nocopy  VARCHAR2
456     , p12_a28 out nocopy  VARCHAR2
457     , p12_a29 out nocopy  VARCHAR2
458     , p12_a30 out nocopy  VARCHAR2
459     , p12_a31 out nocopy  VARCHAR2
460     , p12_a32 out nocopy  VARCHAR2
461     , p12_a33 out nocopy  VARCHAR2
462     , p12_a34 out nocopy  VARCHAR2
463     , p12_a35 out nocopy  VARCHAR2
464     , p12_a36 out nocopy  VARCHAR2
465     , p12_a37 out nocopy  VARCHAR2
466     , p12_a38 out nocopy  VARCHAR2
467     , p12_a39 out nocopy  VARCHAR2
468     , p12_a40 out nocopy  VARCHAR2
469     , p12_a41 out nocopy  VARCHAR2
470     , p12_a42 out nocopy  VARCHAR2
471     , p12_a43 out nocopy  VARCHAR2
472     , p12_a44 out nocopy  VARCHAR2
473     , x_is_succ_conflict out nocopy  VARCHAR2
474     , x_is_succ_org_in_ou out nocopy  VARCHAR2
475   );
476 end ahl_ua_unit_schedules_pvt_w;