eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.AHL_VWP_TASKS_PVT_W

Source


1 package ahl_vwp_tasks_pvt_w as
2   /* $Header: AHLWTSKS.pls 120.2 2008/01/09 08:33:43 rnahata ship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy ahl_vwp_tasks_pvt.srch_task_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_DATE_TABLE
5     , a2 JTF_DATE_TABLE
6     );
7   procedure rosetta_table_copy_out_p1(t ahl_vwp_tasks_pvt.srch_task_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
8     , a1 out nocopy JTF_DATE_TABLE
9     , a2 out nocopy JTF_DATE_TABLE
10     );
11 
12   procedure get_task_details(p_api_version  NUMBER
13     , p_init_msg_list  VARCHAR2
14     , p_commit  VARCHAR2
15     , p_validation_level  NUMBER
16     , p_module_type  VARCHAR2
17     , p_task_id  NUMBER
18     , p6_a0 out nocopy  NUMBER
19     , p6_a1 out nocopy  NUMBER
20     , p6_a2 out nocopy  NUMBER
21     , p6_a3 out nocopy  VARCHAR2
22     , p6_a4 out nocopy  NUMBER
23     , p6_a5 out nocopy  NUMBER
24     , p6_a6 out nocopy  VARCHAR2
25     , p6_a7 out nocopy  NUMBER
26     , p6_a8 out nocopy  NUMBER
27     , p6_a9 out nocopy  NUMBER
28     , p6_a10 out nocopy  VARCHAR2
29     , p6_a11 out nocopy  NUMBER
30     , p6_a12 out nocopy  VARCHAR2
31     , p6_a13 out nocopy  NUMBER
32     , p6_a14 out nocopy  NUMBER
33     , p6_a15 out nocopy  VARCHAR2
34     , p6_a16 out nocopy  NUMBER
35     , p6_a17 out nocopy  VARCHAR2
36     , p6_a18 out nocopy  NUMBER
37     , p6_a19 out nocopy  NUMBER
38     , p6_a20 out nocopy  NUMBER
39     , p6_a21 out nocopy  VARCHAR2
40     , p6_a22 out nocopy  NUMBER
41     , p6_a23 out nocopy  NUMBER
42     , p6_a24 out nocopy  NUMBER
43     , p6_a25 out nocopy  NUMBER
44     , p6_a26 out nocopy  NUMBER
45     , p6_a27 out nocopy  VARCHAR2
46     , p6_a28 out nocopy  VARCHAR2
47     , p6_a29 out nocopy  VARCHAR2
48     , p6_a30 out nocopy  VARCHAR2
49     , p6_a31 out nocopy  VARCHAR2
50     , p6_a32 out nocopy  VARCHAR2
51     , p6_a33 out nocopy  NUMBER
52     , p6_a34 out nocopy  DATE
53     , p6_a35 out nocopy  NUMBER
54     , p6_a36 out nocopy  DATE
55     , p6_a37 out nocopy  NUMBER
56     , p6_a38 out nocopy  NUMBER
57     , p6_a39 out nocopy  VARCHAR2
58     , p6_a40 out nocopy  VARCHAR2
59     , p6_a41 out nocopy  VARCHAR2
60     , p6_a42 out nocopy  VARCHAR2
61     , p6_a43 out nocopy  VARCHAR2
62     , p6_a44 out nocopy  VARCHAR2
63     , p6_a45 out nocopy  VARCHAR2
64     , p6_a46 out nocopy  VARCHAR2
65     , p6_a47 out nocopy  VARCHAR2
66     , p6_a48 out nocopy  VARCHAR2
67     , p6_a49 out nocopy  VARCHAR2
68     , p6_a50 out nocopy  VARCHAR2
69     , p6_a51 out nocopy  VARCHAR2
70     , p6_a52 out nocopy  VARCHAR2
71     , p6_a53 out nocopy  VARCHAR2
72     , p6_a54 out nocopy  VARCHAR2
73     , p6_a55 out nocopy  DATE
74     , p6_a56 out nocopy  DATE
75     , p6_a57 out nocopy  DATE
76     , p6_a58 out nocopy  VARCHAR2
77     , p6_a59 out nocopy  VARCHAR2
78     , p6_a60 out nocopy  NUMBER
79     , p6_a61 out nocopy  NUMBER
80     , p6_a62 out nocopy  VARCHAR2
81     , p6_a63 out nocopy  NUMBER
82     , p6_a64 out nocopy  VARCHAR2
83     , p6_a65 out nocopy  VARCHAR2
84     , p6_a66 out nocopy  DATE
85     , p6_a67 out nocopy  DATE
86     , p6_a68 out nocopy  VARCHAR2
87     , p6_a69 out nocopy  VARCHAR2
88     , p6_a70 out nocopy  VARCHAR2
89     , p6_a71 out nocopy  NUMBER
90     , p6_a72 out nocopy  VARCHAR2
91     , p6_a73 out nocopy  NUMBER
92     , p6_a74 out nocopy  VARCHAR2
93     , p6_a75 out nocopy  VARCHAR2
94     , x_return_status out nocopy  VARCHAR2
95     , x_msg_count out nocopy  NUMBER
96     , x_msg_data out nocopy  VARCHAR2
97   );
98   procedure create_task(p_api_version  NUMBER
99     , p_init_msg_list  VARCHAR2
100     , p_commit  VARCHAR2
101     , p_validation_level  NUMBER
102     , p_module_type  VARCHAR2
103     , p5_a0 in out nocopy  NUMBER
104     , p5_a1 in out nocopy  NUMBER
105     , p5_a2 in out nocopy  NUMBER
106     , p5_a3 in out nocopy  VARCHAR2
107     , p5_a4 in out nocopy  NUMBER
108     , p5_a5 in out nocopy  NUMBER
109     , p5_a6 in out nocopy  VARCHAR2
110     , p5_a7 in out nocopy  NUMBER
111     , p5_a8 in out nocopy  NUMBER
112     , p5_a9 in out nocopy  NUMBER
113     , p5_a10 in out nocopy  VARCHAR2
114     , p5_a11 in out nocopy  NUMBER
115     , p5_a12 in out nocopy  VARCHAR2
116     , p5_a13 in out nocopy  NUMBER
117     , p5_a14 in out nocopy  NUMBER
118     , p5_a15 in out nocopy  VARCHAR2
119     , p5_a16 in out nocopy  NUMBER
120     , p5_a17 in out nocopy  VARCHAR2
121     , p5_a18 in out nocopy  NUMBER
122     , p5_a19 in out nocopy  NUMBER
123     , p5_a20 in out nocopy  NUMBER
124     , p5_a21 in out nocopy  VARCHAR2
125     , p5_a22 in out nocopy  NUMBER
126     , p5_a23 in out nocopy  NUMBER
127     , p5_a24 in out nocopy  NUMBER
128     , p5_a25 in out nocopy  NUMBER
129     , p5_a26 in out nocopy  NUMBER
130     , p5_a27 in out nocopy  VARCHAR2
131     , p5_a28 in out nocopy  VARCHAR2
132     , p5_a29 in out nocopy  VARCHAR2
133     , p5_a30 in out nocopy  VARCHAR2
134     , p5_a31 in out nocopy  VARCHAR2
135     , p5_a32 in out nocopy  VARCHAR2
136     , p5_a33 in out nocopy  NUMBER
137     , p5_a34 in out nocopy  DATE
138     , p5_a35 in out nocopy  NUMBER
139     , p5_a36 in out nocopy  DATE
140     , p5_a37 in out nocopy  NUMBER
141     , p5_a38 in out nocopy  NUMBER
142     , p5_a39 in out nocopy  VARCHAR2
143     , p5_a40 in out nocopy  VARCHAR2
144     , p5_a41 in out nocopy  VARCHAR2
145     , p5_a42 in out nocopy  VARCHAR2
146     , p5_a43 in out nocopy  VARCHAR2
147     , p5_a44 in out nocopy  VARCHAR2
148     , p5_a45 in out nocopy  VARCHAR2
149     , p5_a46 in out nocopy  VARCHAR2
150     , p5_a47 in out nocopy  VARCHAR2
151     , p5_a48 in out nocopy  VARCHAR2
152     , p5_a49 in out nocopy  VARCHAR2
153     , p5_a50 in out nocopy  VARCHAR2
154     , p5_a51 in out nocopy  VARCHAR2
155     , p5_a52 in out nocopy  VARCHAR2
156     , p5_a53 in out nocopy  VARCHAR2
157     , p5_a54 in out nocopy  VARCHAR2
158     , p5_a55 in out nocopy  DATE
159     , p5_a56 in out nocopy  DATE
160     , p5_a57 in out nocopy  DATE
161     , p5_a58 in out nocopy  VARCHAR2
162     , p5_a59 in out nocopy  VARCHAR2
163     , p5_a60 in out nocopy  NUMBER
164     , p5_a61 in out nocopy  NUMBER
165     , p5_a62 in out nocopy  VARCHAR2
166     , p5_a63 in out nocopy  NUMBER
167     , p5_a64 in out nocopy  VARCHAR2
168     , p5_a65 in out nocopy  VARCHAR2
169     , p5_a66 in out nocopy  DATE
170     , p5_a67 in out nocopy  DATE
171     , p5_a68 in out nocopy  VARCHAR2
172     , p5_a69 in out nocopy  VARCHAR2
173     , p5_a70 in out nocopy  VARCHAR2
174     , p5_a71 in out nocopy  NUMBER
175     , p5_a72 in out nocopy  VARCHAR2
176     , p5_a73 in out nocopy  NUMBER
177     , p5_a74 in out nocopy  VARCHAR2
178     , p5_a75 in out nocopy  VARCHAR2
179     , x_return_status out nocopy  VARCHAR2
180     , x_msg_count out nocopy  NUMBER
181     , x_msg_data out nocopy  VARCHAR2
182   );
183   procedure update_task(p_api_version  NUMBER
184     , p_init_msg_list  VARCHAR2
185     , p_commit  VARCHAR2
186     , p_validation_level  NUMBER
187     , p_module_type  VARCHAR2
188     , p5_a0 in out nocopy  NUMBER
189     , p5_a1 in out nocopy  NUMBER
190     , p5_a2 in out nocopy  NUMBER
191     , p5_a3 in out nocopy  VARCHAR2
192     , p5_a4 in out nocopy  NUMBER
193     , p5_a5 in out nocopy  NUMBER
194     , p5_a6 in out nocopy  VARCHAR2
195     , p5_a7 in out nocopy  NUMBER
196     , p5_a8 in out nocopy  NUMBER
197     , p5_a9 in out nocopy  NUMBER
198     , p5_a10 in out nocopy  VARCHAR2
199     , p5_a11 in out nocopy  NUMBER
200     , p5_a12 in out nocopy  VARCHAR2
201     , p5_a13 in out nocopy  NUMBER
202     , p5_a14 in out nocopy  NUMBER
203     , p5_a15 in out nocopy  VARCHAR2
204     , p5_a16 in out nocopy  NUMBER
205     , p5_a17 in out nocopy  VARCHAR2
206     , p5_a18 in out nocopy  NUMBER
207     , p5_a19 in out nocopy  NUMBER
208     , p5_a20 in out nocopy  NUMBER
209     , p5_a21 in out nocopy  VARCHAR2
210     , p5_a22 in out nocopy  NUMBER
211     , p5_a23 in out nocopy  NUMBER
212     , p5_a24 in out nocopy  NUMBER
213     , p5_a25 in out nocopy  NUMBER
214     , p5_a26 in out nocopy  NUMBER
215     , p5_a27 in out nocopy  VARCHAR2
216     , p5_a28 in out nocopy  VARCHAR2
217     , p5_a29 in out nocopy  VARCHAR2
218     , p5_a30 in out nocopy  VARCHAR2
219     , p5_a31 in out nocopy  VARCHAR2
220     , p5_a32 in out nocopy  VARCHAR2
221     , p5_a33 in out nocopy  NUMBER
222     , p5_a34 in out nocopy  DATE
223     , p5_a35 in out nocopy  NUMBER
224     , p5_a36 in out nocopy  DATE
225     , p5_a37 in out nocopy  NUMBER
226     , p5_a38 in out nocopy  NUMBER
227     , p5_a39 in out nocopy  VARCHAR2
228     , p5_a40 in out nocopy  VARCHAR2
229     , p5_a41 in out nocopy  VARCHAR2
230     , p5_a42 in out nocopy  VARCHAR2
231     , p5_a43 in out nocopy  VARCHAR2
232     , p5_a44 in out nocopy  VARCHAR2
233     , p5_a45 in out nocopy  VARCHAR2
234     , p5_a46 in out nocopy  VARCHAR2
235     , p5_a47 in out nocopy  VARCHAR2
236     , p5_a48 in out nocopy  VARCHAR2
237     , p5_a49 in out nocopy  VARCHAR2
238     , p5_a50 in out nocopy  VARCHAR2
239     , p5_a51 in out nocopy  VARCHAR2
240     , p5_a52 in out nocopy  VARCHAR2
241     , p5_a53 in out nocopy  VARCHAR2
242     , p5_a54 in out nocopy  VARCHAR2
243     , p5_a55 in out nocopy  DATE
244     , p5_a56 in out nocopy  DATE
245     , p5_a57 in out nocopy  DATE
246     , p5_a58 in out nocopy  VARCHAR2
247     , p5_a59 in out nocopy  VARCHAR2
248     , p5_a60 in out nocopy  NUMBER
249     , p5_a61 in out nocopy  NUMBER
250     , p5_a62 in out nocopy  VARCHAR2
251     , p5_a63 in out nocopy  NUMBER
252     , p5_a64 in out nocopy  VARCHAR2
253     , p5_a65 in out nocopy  VARCHAR2
254     , p5_a66 in out nocopy  DATE
255     , p5_a67 in out nocopy  DATE
256     , p5_a68 in out nocopy  VARCHAR2
257     , p5_a69 in out nocopy  VARCHAR2
258     , p5_a70 in out nocopy  VARCHAR2
259     , p5_a71 in out nocopy  NUMBER
260     , p5_a72 in out nocopy  VARCHAR2
261     , p5_a73 in out nocopy  NUMBER
262     , p5_a74 in out nocopy  VARCHAR2
263     , p5_a75 in out nocopy  VARCHAR2
264     , x_return_status out nocopy  VARCHAR2
265     , x_msg_count out nocopy  NUMBER
266     , x_msg_data out nocopy  VARCHAR2
267   );
268   procedure search_task(p_api_version  NUMBER
269     , p_init_msg_list  VARCHAR2
270     , p_commit  VARCHAR2
271     , p_validation_level  NUMBER
272     , p_module_type  VARCHAR2
273     , p_visit_id  NUMBER
274     , p6_a0 in out nocopy JTF_NUMBER_TABLE
275     , p6_a1 in out nocopy JTF_DATE_TABLE
276     , p6_a2 in out nocopy JTF_DATE_TABLE
277     , x_return_status out nocopy  VARCHAR2
278     , x_msg_count out nocopy  NUMBER
279     , x_msg_data out nocopy  VARCHAR2
280   );
281   procedure create_pup_tasks(p_api_version  NUMBER
282     , p_init_msg_list  VARCHAR2
283     , p_commit  VARCHAR2
284     , p_validation_level  NUMBER
285     , p_module_type  VARCHAR2
286     , p5_a0 in out nocopy JTF_NUMBER_TABLE
287     , p5_a1 in out nocopy JTF_NUMBER_TABLE
288     , p5_a2 in out nocopy JTF_NUMBER_TABLE
289     , p5_a3 in out nocopy JTF_VARCHAR2_TABLE_100
290     , p5_a4 in out nocopy JTF_NUMBER_TABLE
291     , p5_a5 in out nocopy JTF_NUMBER_TABLE
292     , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
293     , p5_a7 in out nocopy JTF_NUMBER_TABLE
294     , p5_a8 in out nocopy JTF_NUMBER_TABLE
295     , p5_a9 in out nocopy JTF_NUMBER_TABLE
296     , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_100
297     , p5_a11 in out nocopy JTF_NUMBER_TABLE
298     , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_100
299     , p5_a13 in out nocopy JTF_NUMBER_TABLE
300     , p5_a14 in out nocopy JTF_NUMBER_TABLE
301     , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_300
302     , p5_a16 in out nocopy JTF_NUMBER_TABLE
303     , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_100
304     , p5_a18 in out nocopy JTF_NUMBER_TABLE
305     , p5_a19 in out nocopy JTF_NUMBER_TABLE
306     , p5_a20 in out nocopy JTF_NUMBER_TABLE
307     , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_100
308     , p5_a22 in out nocopy JTF_NUMBER_TABLE
309     , p5_a23 in out nocopy JTF_NUMBER_TABLE
310     , p5_a24 in out nocopy JTF_NUMBER_TABLE
311     , p5_a25 in out nocopy JTF_NUMBER_TABLE
312     , p5_a26 in out nocopy JTF_NUMBER_TABLE
313     , p5_a27 in out nocopy JTF_VARCHAR2_TABLE_100
314     , p5_a28 in out nocopy JTF_VARCHAR2_TABLE_100
315     , p5_a29 in out nocopy JTF_VARCHAR2_TABLE_100
316     , p5_a30 in out nocopy JTF_VARCHAR2_TABLE_4000
317     , p5_a31 in out nocopy JTF_VARCHAR2_TABLE_100
318     , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
319     , p5_a33 in out nocopy JTF_NUMBER_TABLE
320     , p5_a34 in out nocopy JTF_DATE_TABLE
321     , p5_a35 in out nocopy JTF_NUMBER_TABLE
322     , p5_a36 in out nocopy JTF_DATE_TABLE
323     , p5_a37 in out nocopy JTF_NUMBER_TABLE
324     , p5_a38 in out nocopy JTF_NUMBER_TABLE
325     , p5_a39 in out nocopy JTF_VARCHAR2_TABLE_100
326     , p5_a40 in out nocopy JTF_VARCHAR2_TABLE_200
327     , p5_a41 in out nocopy JTF_VARCHAR2_TABLE_200
328     , p5_a42 in out nocopy JTF_VARCHAR2_TABLE_200
329     , p5_a43 in out nocopy JTF_VARCHAR2_TABLE_200
330     , p5_a44 in out nocopy JTF_VARCHAR2_TABLE_200
331     , p5_a45 in out nocopy JTF_VARCHAR2_TABLE_200
332     , p5_a46 in out nocopy JTF_VARCHAR2_TABLE_200
333     , p5_a47 in out nocopy JTF_VARCHAR2_TABLE_200
334     , p5_a48 in out nocopy JTF_VARCHAR2_TABLE_200
335     , p5_a49 in out nocopy JTF_VARCHAR2_TABLE_200
336     , p5_a50 in out nocopy JTF_VARCHAR2_TABLE_200
337     , p5_a51 in out nocopy JTF_VARCHAR2_TABLE_200
338     , p5_a52 in out nocopy JTF_VARCHAR2_TABLE_200
339     , p5_a53 in out nocopy JTF_VARCHAR2_TABLE_200
340     , p5_a54 in out nocopy JTF_VARCHAR2_TABLE_200
341     , p5_a55 in out nocopy JTF_DATE_TABLE
342     , p5_a56 in out nocopy JTF_DATE_TABLE
343     , p5_a57 in out nocopy JTF_DATE_TABLE
344     , p5_a58 in out nocopy JTF_VARCHAR2_TABLE_100
345     , p5_a59 in out nocopy JTF_VARCHAR2_TABLE_100
346     , p5_a60 in out nocopy JTF_NUMBER_TABLE
347     , p5_a61 in out nocopy JTF_NUMBER_TABLE
348     , p5_a62 in out nocopy JTF_VARCHAR2_TABLE_100
349     , p5_a63 in out nocopy JTF_NUMBER_TABLE
350     , p5_a64 in out nocopy JTF_VARCHAR2_TABLE_300
351     , p5_a65 in out nocopy JTF_VARCHAR2_TABLE_100
352     , p5_a66 in out nocopy JTF_DATE_TABLE
353     , p5_a67 in out nocopy JTF_DATE_TABLE
354     , p5_a68 in out nocopy JTF_VARCHAR2_TABLE_100
355     , p5_a69 in out nocopy JTF_VARCHAR2_TABLE_100
356     , p5_a70 in out nocopy JTF_VARCHAR2_TABLE_100
357     , p5_a71 in out nocopy JTF_NUMBER_TABLE
358     , p5_a72 in out nocopy JTF_VARCHAR2_TABLE_100
359     , p5_a73 in out nocopy JTF_NUMBER_TABLE
360     , p5_a74 in out nocopy JTF_VARCHAR2_TABLE_100
361     , p5_a75 in out nocopy JTF_VARCHAR2_TABLE_100
362     , x_return_status out nocopy  VARCHAR2
363     , x_msg_count out nocopy  NUMBER
364     , x_msg_data out nocopy  VARCHAR2
365   );
366   procedure associate_default_mrs(p_api_version  NUMBER
367     , p_init_msg_list  VARCHAR2
368     , p_commit  VARCHAR2
369     , p_validation_level  NUMBER
370     , p_module_type  VARCHAR2
371     , x_return_status out nocopy  VARCHAR2
372     , x_msg_count out nocopy  NUMBER
373     , x_msg_data out nocopy  VARCHAR2
374     , p8_a0  NUMBER
375     , p8_a1  VARCHAR2
376     , p8_a2  NUMBER
377     , p8_a3  NUMBER
378     , p8_a4  DATE
379     , p8_a5  NUMBER
380     , p8_a6  DATE
381     , p8_a7  NUMBER
382     , p8_a8  NUMBER
386     , p8_a12  VARCHAR2
383     , p8_a9  NUMBER
384     , p8_a10  VARCHAR2
385     , p8_a11  NUMBER
387     , p8_a13  NUMBER
388     , p8_a14  VARCHAR2
389     , p8_a15  VARCHAR2
390     , p8_a16  VARCHAR2
391     , p8_a17  DATE
392     , p8_a18  NUMBER
393     , p8_a19  NUMBER
394     , p8_a20  DATE
395     , p8_a21  NUMBER
396     , p8_a22  NUMBER
397     , p8_a23  DATE
398     , p8_a24  DATE
399     , p8_a25  VARCHAR2
400     , p8_a26  VARCHAR2
401     , p8_a27  VARCHAR2
402     , p8_a28  VARCHAR2
403     , p8_a29  NUMBER
404     , p8_a30  VARCHAR2
405     , p8_a31  NUMBER
406     , p8_a32  VARCHAR2
407     , p8_a33  NUMBER
408     , p8_a34  VARCHAR2
409     , p8_a35  NUMBER
410     , p8_a36  NUMBER
411     , p8_a37  VARCHAR2
412     , p8_a38  VARCHAR2
413     , p8_a39  VARCHAR2
414     , p8_a40  VARCHAR2
415     , p8_a41  VARCHAR2
416     , p8_a42  VARCHAR2
417     , p8_a43  NUMBER
418     , p8_a44  NUMBER
419     , p8_a45  VARCHAR2
420     , p8_a46  NUMBER
421     , p8_a47  VARCHAR2
422     , p8_a48  VARCHAR2
423     , p8_a49  VARCHAR2
424     , p8_a50  VARCHAR2
425     , p8_a51  VARCHAR2
426     , p8_a52  VARCHAR2
427     , p8_a53  VARCHAR2
428     , p8_a54  VARCHAR2
429     , p8_a55  VARCHAR2
430     , p8_a56  VARCHAR2
431     , p8_a57  VARCHAR2
432     , p8_a58  VARCHAR2
433     , p8_a59  VARCHAR2
434     , p8_a60  VARCHAR2
435     , p8_a61  VARCHAR2
436     , p8_a62  VARCHAR2
437     , p8_a63  VARCHAR2
438     , p8_a64  VARCHAR2
439     , p8_a65  VARCHAR2
440     , p8_a66  VARCHAR2
441     , p8_a67  NUMBER
442     , p8_a68  VARCHAR2
443     , p8_a69  VARCHAR2
444     , p8_a70  NUMBER
445     , p8_a71  VARCHAR2
446     , p8_a72  VARCHAR2
447     , p8_a73  NUMBER
448     , p8_a74  VARCHAR2
449   );
450 end ahl_vwp_tasks_pvt_w;