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_TASK_CST_PR_PVT_W

Source


1 package ahl_vwp_task_cst_pr_pvt_w AUTHID CURRENT_USER as
2   /* $Header: AHLWTCPS.pls 120.2.12020000.2 2012/12/14 06:52:19 shnatu ship $ */
3   procedure get_task_cost_details(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     , p5_a0 in out nocopy  NUMBER
9     , p5_a1 in out nocopy  NUMBER
10     , p5_a2 in out nocopy  NUMBER
11     , p5_a3 in out nocopy  NUMBER
12     , p5_a4 in out nocopy  NUMBER
13     , p5_a5 in out nocopy  NUMBER
14     , p5_a6 in out nocopy  NUMBER
15     , p5_a7 in out nocopy  VARCHAR2
16     , p5_a8 in out nocopy  NUMBER
17     , p5_a9 in out nocopy  NUMBER
18     , p5_a10 in out nocopy  NUMBER
19     , p5_a11 in out nocopy  NUMBER
20     , p5_a12 in out nocopy  VARCHAR2
21     , p5_a13 in out nocopy  VARCHAR2
22     , p5_a14 in out nocopy  VARCHAR2
23     , p5_a15 in out nocopy  VARCHAR2
24     , p5_a16 in out nocopy  NUMBER
25     , p5_a17 in out nocopy  VARCHAR2
26     , p5_a18 in out nocopy  NUMBER
27     , p5_a19 in out nocopy  NUMBER
28     , p5_a20 in out nocopy  NUMBER
29     , p5_a21 in out nocopy  DATE
30     , p5_a22 in out nocopy  DATE
31     , p5_a23 in out nocopy  DATE
32     , p5_a24 in out nocopy  DATE
33     , p5_a25 in out nocopy  DATE
34     , p5_a26 in out nocopy  DATE
35     , p5_a27 in out nocopy  VARCHAR2
36     , p5_a28 in out nocopy  NUMBER
37     , p5_a29 in out nocopy  VARCHAR2
38     , p5_a30 in out nocopy  VARCHAR2
39     , p5_a31 in out nocopy  NUMBER
40     , p5_a32 in out nocopy  VARCHAR2
41     , p5_a33 in out nocopy  VARCHAR2
42     , p5_a34 in out nocopy  VARCHAR2
43     , p5_a35 in out nocopy  NUMBER
44     , p5_a36 in out nocopy  VARCHAR2
45     , p5_a37 in out nocopy  NUMBER
46     , p5_a38 in out nocopy  NUMBER
47     , p5_a39 in out nocopy  NUMBER
48     , p5_a40 in out nocopy  VARCHAR2
49     , p5_a41 in out nocopy  VARCHAR2
50     , p5_a42 in out nocopy  VARCHAR2
51     , p5_a43 in out nocopy  DATE
52     , p5_a44 in out nocopy  NUMBER
53     , p5_a45 in out nocopy  DATE
54     , p5_a46 in out nocopy  NUMBER
55     , p5_a47 in out nocopy  DATE
56     , p5_a48 in out nocopy  NUMBER
57     , p5_a49 in out nocopy  VARCHAR2
58     , p5_a50 in out nocopy  VARCHAR2
59     , p5_a51 in out nocopy  VARCHAR2
60     , p5_a52 in out nocopy  VARCHAR2
61     , p5_a53 in out nocopy  VARCHAR2
62     , p5_a54 in out nocopy  VARCHAR2
63     , p5_a55 in out nocopy  VARCHAR2
64     , p5_a56 in out nocopy  VARCHAR2
65     , p5_a57 in out nocopy  VARCHAR2
66     , p5_a58 in out nocopy  VARCHAR2
67     , p5_a59 in out nocopy  VARCHAR2
68     , p5_a60 in out nocopy  VARCHAR2
69     , p5_a61 in out nocopy  VARCHAR2
70     , p5_a62 in out nocopy  VARCHAR2
71     , p5_a63 in out nocopy  VARCHAR2
72     , p5_a64 in out nocopy  VARCHAR2
73     , x_return_status out nocopy  VARCHAR2
74     , x_msg_count out nocopy  NUMBER
75     , x_msg_data out nocopy  VARCHAR2
76   );
77   procedure estimate_task_cost(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     , p5_a0 in out nocopy  NUMBER
83     , p5_a1 in out nocopy  NUMBER
84     , p5_a2 in out nocopy  NUMBER
85     , p5_a3 in out nocopy  NUMBER
86     , p5_a4 in out nocopy  NUMBER
87     , p5_a5 in out nocopy  NUMBER
88     , p5_a6 in out nocopy  NUMBER
89     , p5_a7 in out nocopy  VARCHAR2
90     , p5_a8 in out nocopy  NUMBER
91     , p5_a9 in out nocopy  NUMBER
92     , p5_a10 in out nocopy  NUMBER
93     , p5_a11 in out nocopy  NUMBER
94     , p5_a12 in out nocopy  VARCHAR2
95     , p5_a13 in out nocopy  VARCHAR2
96     , p5_a14 in out nocopy  VARCHAR2
97     , p5_a15 in out nocopy  VARCHAR2
98     , p5_a16 in out nocopy  NUMBER
99     , p5_a17 in out nocopy  VARCHAR2
100     , p5_a18 in out nocopy  NUMBER
101     , p5_a19 in out nocopy  NUMBER
102     , p5_a20 in out nocopy  NUMBER
103     , p5_a21 in out nocopy  DATE
104     , p5_a22 in out nocopy  DATE
105     , p5_a23 in out nocopy  DATE
106     , p5_a24 in out nocopy  DATE
107     , p5_a25 in out nocopy  DATE
108     , p5_a26 in out nocopy  DATE
109     , p5_a27 in out nocopy  VARCHAR2
110     , p5_a28 in out nocopy  NUMBER
111     , p5_a29 in out nocopy  VARCHAR2
112     , p5_a30 in out nocopy  VARCHAR2
113     , p5_a31 in out nocopy  NUMBER
114     , p5_a32 in out nocopy  VARCHAR2
115     , p5_a33 in out nocopy  VARCHAR2
116     , p5_a34 in out nocopy  VARCHAR2
117     , p5_a35 in out nocopy  NUMBER
118     , p5_a36 in out nocopy  VARCHAR2
119     , p5_a37 in out nocopy  NUMBER
120     , p5_a38 in out nocopy  NUMBER
121     , p5_a39 in out nocopy  NUMBER
122     , p5_a40 in out nocopy  VARCHAR2
123     , p5_a41 in out nocopy  VARCHAR2
124     , p5_a42 in out nocopy  VARCHAR2
125     , p5_a43 in out nocopy  DATE
126     , p5_a44 in out nocopy  NUMBER
127     , p5_a45 in out nocopy  DATE
128     , p5_a46 in out nocopy  NUMBER
129     , p5_a47 in out nocopy  DATE
130     , p5_a48 in out nocopy  NUMBER
131     , p5_a49 in out nocopy  VARCHAR2
132     , p5_a50 in out nocopy  VARCHAR2
133     , p5_a51 in out nocopy  VARCHAR2
134     , p5_a52 in out nocopy  VARCHAR2
135     , p5_a53 in out nocopy  VARCHAR2
136     , p5_a54 in out nocopy  VARCHAR2
137     , p5_a55 in out nocopy  VARCHAR2
138     , p5_a56 in out nocopy  VARCHAR2
139     , p5_a57 in out nocopy  VARCHAR2
140     , p5_a58 in out nocopy  VARCHAR2
141     , p5_a59 in out nocopy  VARCHAR2
142     , p5_a60 in out nocopy  VARCHAR2
143     , p5_a61 in out nocopy  VARCHAR2
144     , p5_a62 in out nocopy  VARCHAR2
145     , p5_a63 in out nocopy  VARCHAR2
146     , p5_a64 in out nocopy  VARCHAR2
147     , x_return_status out nocopy  VARCHAR2
148     , x_msg_count out nocopy  NUMBER
149     , x_msg_data out nocopy  VARCHAR2
150   );
151   procedure estimate_task_price(p_api_version  NUMBER
152     , p_init_msg_list  VARCHAR2
153     , p_commit  VARCHAR2
154     , p_validation_level  NUMBER
155     , p_module_type  VARCHAR2
156     , p5_a0 in out nocopy  NUMBER
157     , p5_a1 in out nocopy  NUMBER
158     , p5_a2 in out nocopy  NUMBER
159     , p5_a3 in out nocopy  NUMBER
160     , p5_a4 in out nocopy  NUMBER
161     , p5_a5 in out nocopy  NUMBER
162     , p5_a6 in out nocopy  NUMBER
163     , p5_a7 in out nocopy  VARCHAR2
164     , p5_a8 in out nocopy  NUMBER
165     , p5_a9 in out nocopy  NUMBER
166     , p5_a10 in out nocopy  NUMBER
167     , p5_a11 in out nocopy  NUMBER
168     , p5_a12 in out nocopy  VARCHAR2
169     , p5_a13 in out nocopy  VARCHAR2
170     , p5_a14 in out nocopy  VARCHAR2
171     , p5_a15 in out nocopy  VARCHAR2
172     , p5_a16 in out nocopy  NUMBER
173     , p5_a17 in out nocopy  VARCHAR2
174     , p5_a18 in out nocopy  NUMBER
175     , p5_a19 in out nocopy  NUMBER
176     , p5_a20 in out nocopy  NUMBER
177     , p5_a21 in out nocopy  DATE
178     , p5_a22 in out nocopy  DATE
179     , p5_a23 in out nocopy  DATE
180     , p5_a24 in out nocopy  DATE
181     , p5_a25 in out nocopy  DATE
182     , p5_a26 in out nocopy  DATE
183     , p5_a27 in out nocopy  VARCHAR2
184     , p5_a28 in out nocopy  NUMBER
185     , p5_a29 in out nocopy  VARCHAR2
186     , p5_a30 in out nocopy  VARCHAR2
187     , p5_a31 in out nocopy  NUMBER
188     , p5_a32 in out nocopy  VARCHAR2
189     , p5_a33 in out nocopy  VARCHAR2
190     , p5_a34 in out nocopy  VARCHAR2
191     , p5_a35 in out nocopy  NUMBER
192     , p5_a36 in out nocopy  VARCHAR2
193     , p5_a37 in out nocopy  NUMBER
194     , p5_a38 in out nocopy  NUMBER
195     , p5_a39 in out nocopy  NUMBER
196     , p5_a40 in out nocopy  VARCHAR2
197     , p5_a41 in out nocopy  VARCHAR2
198     , p5_a42 in out nocopy  VARCHAR2
199     , p5_a43 in out nocopy  DATE
200     , p5_a44 in out nocopy  NUMBER
201     , p5_a45 in out nocopy  DATE
202     , p5_a46 in out nocopy  NUMBER
203     , p5_a47 in out nocopy  DATE
204     , p5_a48 in out nocopy  NUMBER
205     , p5_a49 in out nocopy  VARCHAR2
206     , p5_a50 in out nocopy  VARCHAR2
207     , p5_a51 in out nocopy  VARCHAR2
208     , p5_a52 in out nocopy  VARCHAR2
209     , p5_a53 in out nocopy  VARCHAR2
210     , p5_a54 in out nocopy  VARCHAR2
211     , p5_a55 in out nocopy  VARCHAR2
212     , p5_a56 in out nocopy  VARCHAR2
213     , p5_a57 in out nocopy  VARCHAR2
214     , p5_a58 in out nocopy  VARCHAR2
215     , p5_a59 in out nocopy  VARCHAR2
216     , p5_a60 in out nocopy  VARCHAR2
217     , p5_a61 in out nocopy  VARCHAR2
218     , p5_a62 in out nocopy  VARCHAR2
219     , p5_a63 in out nocopy  VARCHAR2
220     , p5_a64 in out nocopy  VARCHAR2
221     , x_return_status out nocopy  VARCHAR2
222     , x_msg_count out nocopy  NUMBER
223     , x_msg_data out nocopy  VARCHAR2
224   );
225   procedure update_task_cost_details(p_api_version  NUMBER
226     , p_init_msg_list  VARCHAR2
227     , p_commit  VARCHAR2
228     , p_validation_level  NUMBER
229     , p_module_type  VARCHAR2
230     , p5_a0  NUMBER
231     , p5_a1  NUMBER
232     , p5_a2  NUMBER
233     , p5_a3  NUMBER
234     , p5_a4  NUMBER
235     , p5_a5  NUMBER
236     , p5_a6  NUMBER
237     , p5_a7  VARCHAR2
238     , p5_a8  NUMBER
239     , p5_a9  NUMBER
240     , p5_a10  NUMBER
241     , p5_a11  NUMBER
242     , p5_a12  VARCHAR2
243     , p5_a13  VARCHAR2
244     , p5_a14  VARCHAR2
245     , p5_a15  VARCHAR2
246     , p5_a16  NUMBER
247     , p5_a17  VARCHAR2
248     , p5_a18  NUMBER
249     , p5_a19  NUMBER
250     , p5_a20  NUMBER
251     , p5_a21  DATE
252     , p5_a22  DATE
253     , p5_a23  DATE
254     , p5_a24  DATE
255     , p5_a25  DATE
256     , p5_a26  DATE
257     , p5_a27  VARCHAR2
258     , p5_a28  NUMBER
259     , p5_a29  VARCHAR2
260     , p5_a30  VARCHAR2
261     , p5_a31  NUMBER
262     , p5_a32  VARCHAR2
263     , p5_a33  VARCHAR2
264     , p5_a34  VARCHAR2
265     , p5_a35  NUMBER
266     , p5_a36  VARCHAR2
267     , p5_a37  NUMBER
268     , p5_a38  NUMBER
269     , p5_a39  NUMBER
270     , p5_a40  VARCHAR2
271     , p5_a41  VARCHAR2
272     , p5_a42  VARCHAR2
273     , p5_a43  DATE
274     , p5_a44  NUMBER
275     , p5_a45  DATE
276     , p5_a46  NUMBER
277     , p5_a47  DATE
278     , p5_a48  NUMBER
279     , p5_a49  VARCHAR2
280     , p5_a50  VARCHAR2
281     , p5_a51  VARCHAR2
282     , p5_a52  VARCHAR2
283     , p5_a53  VARCHAR2
284     , p5_a54  VARCHAR2
285     , p5_a55  VARCHAR2
286     , p5_a56  VARCHAR2
287     , p5_a57  VARCHAR2
288     , p5_a58  VARCHAR2
289     , p5_a59  VARCHAR2
290     , p5_a60  VARCHAR2
291     , p5_a61  VARCHAR2
292     , p5_a62  VARCHAR2
293     , p5_a63  VARCHAR2
294     , p5_a64  VARCHAR2
295     , x_return_status out nocopy  VARCHAR2
296     , x_msg_count out nocopy  NUMBER
297     , x_msg_data out nocopy  VARCHAR2
298   );
299   procedure get_node_cost_details(p_api_version  NUMBER
300     , p_init_msg_list  VARCHAR2
301     , p_commit  VARCHAR2
302     , p_validation_level  NUMBER
303     , p_module_type  VARCHAR2
304     , x_return_status out nocopy  VARCHAR2
305     , x_msg_count out nocopy  NUMBER
306     , x_msg_data out nocopy  VARCHAR2
307     , p8_a0 in out nocopy  NUMBER
308     , p8_a1 in out nocopy  NUMBER
309     , p8_a2 in out nocopy  NUMBER
310     , p8_a3 in out nocopy  NUMBER
311     , p8_a4 in out nocopy  NUMBER
312     , p8_a5 in out nocopy  NUMBER
313     , p8_a6 in out nocopy  NUMBER
314     , p8_a7 in out nocopy  VARCHAR2
315     , p8_a8 in out nocopy  NUMBER
316     , p8_a9 in out nocopy  NUMBER
317     , p8_a10 in out nocopy  NUMBER
318     , p8_a11 in out nocopy  NUMBER
319     , p8_a12 in out nocopy  VARCHAR2
320     , p8_a13 in out nocopy  VARCHAR2
321     , p8_a14 in out nocopy  VARCHAR2
322     , p8_a15 in out nocopy  VARCHAR2
323     , p8_a16 in out nocopy  NUMBER
324     , p8_a17 in out nocopy  VARCHAR2
325     , p8_a18 in out nocopy  NUMBER
326     , p8_a19 in out nocopy  NUMBER
327     , p8_a20 in out nocopy  NUMBER
328     , p8_a21 in out nocopy  DATE
329     , p8_a22 in out nocopy  DATE
330     , p8_a23 in out nocopy  DATE
331     , p8_a24 in out nocopy  DATE
332     , p8_a25 in out nocopy  DATE
333     , p8_a26 in out nocopy  DATE
334     , p8_a27 in out nocopy  VARCHAR2
335     , p8_a28 in out nocopy  NUMBER
336     , p8_a29 in out nocopy  VARCHAR2
337     , p8_a30 in out nocopy  VARCHAR2
338     , p8_a31 in out nocopy  NUMBER
339     , p8_a32 in out nocopy  VARCHAR2
340     , p8_a33 in out nocopy  VARCHAR2
341     , p8_a34 in out nocopy  VARCHAR2
342     , p8_a35 in out nocopy  NUMBER
343     , p8_a36 in out nocopy  VARCHAR2
344     , p8_a37 in out nocopy  NUMBER
345     , p8_a38 in out nocopy  NUMBER
346     , p8_a39 in out nocopy  NUMBER
347     , p8_a40 in out nocopy  VARCHAR2
348     , p8_a41 in out nocopy  VARCHAR2
349     , p8_a42 in out nocopy  VARCHAR2
350     , p8_a43 in out nocopy  DATE
351     , p8_a44 in out nocopy  NUMBER
352     , p8_a45 in out nocopy  DATE
353     , p8_a46 in out nocopy  NUMBER
354     , p8_a47 in out nocopy  DATE
355     , p8_a48 in out nocopy  NUMBER
356     , p8_a49 in out nocopy  VARCHAR2
357     , p8_a50 in out nocopy  VARCHAR2
358     , p8_a51 in out nocopy  VARCHAR2
359     , p8_a52 in out nocopy  VARCHAR2
360     , p8_a53 in out nocopy  VARCHAR2
361     , p8_a54 in out nocopy  VARCHAR2
362     , p8_a55 in out nocopy  VARCHAR2
363     , p8_a56 in out nocopy  VARCHAR2
364     , p8_a57 in out nocopy  VARCHAR2
365     , p8_a58 in out nocopy  VARCHAR2
366     , p8_a59 in out nocopy  VARCHAR2
367     , p8_a60 in out nocopy  VARCHAR2
368     , p8_a61 in out nocopy  VARCHAR2
369     , p8_a62 in out nocopy  VARCHAR2
370     , p8_a63 in out nocopy  VARCHAR2
371     , p8_a64 in out nocopy  VARCHAR2
372   );
373   procedure get_task_items_no_price(p_api_version  NUMBER
374     , p_init_msg_list  VARCHAR2
375     , p_commit  VARCHAR2
376     , p_validation_level  NUMBER
377     , p_module_type  VARCHAR2
378     , x_return_status out nocopy  VARCHAR2
379     , x_msg_count out nocopy  NUMBER
380     , x_msg_data out nocopy  VARCHAR2
381     , p8_a0  NUMBER
382     , p8_a1  NUMBER
383     , p8_a2  NUMBER
384     , p8_a3  NUMBER
385     , p8_a4  NUMBER
386     , p8_a5  NUMBER
387     , p8_a6  NUMBER
388     , p8_a7  VARCHAR2
389     , p8_a8  NUMBER
390     , p8_a9  NUMBER
391     , p8_a10  NUMBER
392     , p8_a11  NUMBER
393     , p8_a12  VARCHAR2
394     , p8_a13  VARCHAR2
395     , p8_a14  VARCHAR2
396     , p8_a15  VARCHAR2
397     , p8_a16  NUMBER
398     , p8_a17  VARCHAR2
399     , p8_a18  NUMBER
400     , p8_a19  NUMBER
401     , p8_a20  NUMBER
402     , p8_a21  DATE
403     , p8_a22  DATE
404     , p8_a23  DATE
405     , p8_a24  DATE
406     , p8_a25  DATE
407     , p8_a26  DATE
408     , p8_a27  VARCHAR2
409     , p8_a28  NUMBER
410     , p8_a29  VARCHAR2
411     , p8_a30  VARCHAR2
412     , p8_a31  NUMBER
413     , p8_a32  VARCHAR2
414     , p8_a33  VARCHAR2
415     , p8_a34  VARCHAR2
416     , p8_a35  NUMBER
417     , p8_a36  VARCHAR2
418     , p8_a37  NUMBER
419     , p8_a38  NUMBER
420     , p8_a39  NUMBER
421     , p8_a40  VARCHAR2
422     , p8_a41  VARCHAR2
423     , p8_a42  VARCHAR2
424     , p8_a43  DATE
425     , p8_a44  NUMBER
426     , p8_a45  DATE
427     , p8_a46  NUMBER
428     , p8_a47  DATE
429     , p8_a48  NUMBER
430     , p8_a49  VARCHAR2
431     , p8_a50  VARCHAR2
432     , p8_a51  VARCHAR2
433     , p8_a52  VARCHAR2
434     , p8_a53  VARCHAR2
435     , p8_a54  VARCHAR2
436     , p8_a55  VARCHAR2
437     , p8_a56  VARCHAR2
438     , p8_a57  VARCHAR2
439     , p8_a58  VARCHAR2
440     , p8_a59  VARCHAR2
441     , p8_a60  VARCHAR2
442     , p8_a61  VARCHAR2
443     , p8_a62  VARCHAR2
444     , p8_a63  VARCHAR2
445     , p8_a64  VARCHAR2
446     , p9_a0 out nocopy JTF_NUMBER_TABLE
447     , p9_a1 out nocopy JTF_NUMBER_TABLE
448     , p9_a2 out nocopy JTF_NUMBER_TABLE
449     , p9_a3 out nocopy JTF_NUMBER_TABLE
450     , p9_a4 out nocopy JTF_NUMBER_TABLE
451     , p9_a5 out nocopy JTF_NUMBER_TABLE
452     , p9_a6 out nocopy JTF_NUMBER_TABLE
453     , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
454     , p9_a8 out nocopy JTF_NUMBER_TABLE
455     , p9_a9 out nocopy JTF_NUMBER_TABLE
456     , p9_a10 out nocopy JTF_NUMBER_TABLE
457     , p9_a11 out nocopy JTF_NUMBER_TABLE
458     , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
459     , p9_a13 out nocopy JTF_VARCHAR2_TABLE_100
460     , p9_a14 out nocopy JTF_VARCHAR2_TABLE_100
461     , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
462     , p9_a16 out nocopy JTF_NUMBER_TABLE
463     , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
464     , p9_a18 out nocopy JTF_NUMBER_TABLE
465     , p9_a19 out nocopy JTF_NUMBER_TABLE
466     , p9_a20 out nocopy JTF_NUMBER_TABLE
467     , p9_a21 out nocopy JTF_DATE_TABLE
468     , p9_a22 out nocopy JTF_DATE_TABLE
469     , p9_a23 out nocopy JTF_DATE_TABLE
470     , p9_a24 out nocopy JTF_DATE_TABLE
471     , p9_a25 out nocopy JTF_DATE_TABLE
472     , p9_a26 out nocopy JTF_DATE_TABLE
473     , p9_a27 out nocopy JTF_VARCHAR2_TABLE_100
474     , p9_a28 out nocopy JTF_NUMBER_TABLE
475     , p9_a29 out nocopy JTF_VARCHAR2_TABLE_100
476     , p9_a30 out nocopy JTF_VARCHAR2_TABLE_2000
477     , p9_a31 out nocopy JTF_NUMBER_TABLE
478     , p9_a32 out nocopy JTF_VARCHAR2_TABLE_400
479     , p9_a33 out nocopy JTF_VARCHAR2_TABLE_300
480     , p9_a34 out nocopy JTF_VARCHAR2_TABLE_300
481     , p9_a35 out nocopy JTF_NUMBER_TABLE
482     , p9_a36 out nocopy JTF_VARCHAR2_TABLE_100
483     , p9_a37 out nocopy JTF_NUMBER_TABLE
484     , p9_a38 out nocopy JTF_NUMBER_TABLE
485     , p9_a39 out nocopy JTF_NUMBER_TABLE
486     , p9_a40 out nocopy JTF_VARCHAR2_TABLE_100
487     , p9_a41 out nocopy JTF_VARCHAR2_TABLE_100
488     , p9_a42 out nocopy JTF_VARCHAR2_TABLE_100
489     , p9_a43 out nocopy JTF_DATE_TABLE
490     , p9_a44 out nocopy JTF_NUMBER_TABLE
491     , p9_a45 out nocopy JTF_DATE_TABLE
492     , p9_a46 out nocopy JTF_NUMBER_TABLE
493     , p9_a47 out nocopy JTF_DATE_TABLE
494     , p9_a48 out nocopy JTF_NUMBER_TABLE
495     , p9_a49 out nocopy JTF_VARCHAR2_TABLE_100
496     , p9_a50 out nocopy JTF_VARCHAR2_TABLE_200
497     , p9_a51 out nocopy JTF_VARCHAR2_TABLE_200
498     , p9_a52 out nocopy JTF_VARCHAR2_TABLE_200
499     , p9_a53 out nocopy JTF_VARCHAR2_TABLE_200
500     , p9_a54 out nocopy JTF_VARCHAR2_TABLE_200
501     , p9_a55 out nocopy JTF_VARCHAR2_TABLE_200
502     , p9_a56 out nocopy JTF_VARCHAR2_TABLE_200
503     , p9_a57 out nocopy JTF_VARCHAR2_TABLE_200
504     , p9_a58 out nocopy JTF_VARCHAR2_TABLE_200
505     , p9_a59 out nocopy JTF_VARCHAR2_TABLE_200
506     , p9_a60 out nocopy JTF_VARCHAR2_TABLE_200
507     , p9_a61 out nocopy JTF_VARCHAR2_TABLE_200
508     , p9_a62 out nocopy JTF_VARCHAR2_TABLE_200
509     , p9_a63 out nocopy JTF_VARCHAR2_TABLE_200
510     , p9_a64 out nocopy JTF_VARCHAR2_TABLE_200
511   );
512 end ahl_vwp_task_cst_pr_pvt_w;