DBA Data[Home] [Help]

PACKAGE: APPS.JTF_TASKS_PUB_W

Source


1 package jtf_tasks_pub_w AUTHID CURRENT_USER as
2   /* $Header: jtfbtkts.pls 120.7 2006/04/26 04:33 knayyar ship $ */
3   procedure rosetta_table_copy_in_p6(t out nocopy jtf_tasks_pub.task_assign_tbl, a0 JTF_VARCHAR2_TABLE_100
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_DATE_TABLE
6     , a3 JTF_DATE_TABLE
7     , a4 JTF_NUMBER_TABLE
11     , a8 JTF_VARCHAR2_TABLE_100
8     , a5 JTF_VARCHAR2_TABLE_100
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_NUMBER_TABLE
12     , a9 JTF_NUMBER_TABLE
13     , a10 JTF_NUMBER_TABLE
14     , a11 JTF_VARCHAR2_TABLE_100
15     , a12 JTF_VARCHAR2_TABLE_100
16     , a13 JTF_VARCHAR2_TABLE_100
17     , a14 JTF_VARCHAR2_TABLE_200
18     , a15 JTF_VARCHAR2_TABLE_100
19     , a16 JTF_VARCHAR2_TABLE_100
20     , a17 JTF_VARCHAR2_TABLE_100
21     , a18 JTF_VARCHAR2_TABLE_100
22     , a19 JTF_VARCHAR2_TABLE_100
23     , a20 JTF_VARCHAR2_TABLE_100
24     , a21 JTF_NUMBER_TABLE
25     , a22 JTF_NUMBER_TABLE
26     , a23 JTF_NUMBER_TABLE
27     , a24 JTF_VARCHAR2_TABLE_100
28     , a25 JTF_NUMBER_TABLE
29     );
30   procedure rosetta_table_copy_out_p6(t jtf_tasks_pub.task_assign_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
31     , a1 out nocopy JTF_NUMBER_TABLE
32     , a2 out nocopy JTF_DATE_TABLE
33     , a3 out nocopy JTF_DATE_TABLE
34     , a4 out nocopy JTF_NUMBER_TABLE
35     , a5 out nocopy JTF_VARCHAR2_TABLE_100
36     , a6 out nocopy JTF_NUMBER_TABLE
37     , a7 out nocopy JTF_NUMBER_TABLE
38     , a8 out nocopy JTF_VARCHAR2_TABLE_100
39     , a9 out nocopy JTF_NUMBER_TABLE
40     , a10 out nocopy JTF_NUMBER_TABLE
41     , a11 out nocopy JTF_VARCHAR2_TABLE_100
42     , a12 out nocopy JTF_VARCHAR2_TABLE_100
43     , a13 out nocopy JTF_VARCHAR2_TABLE_100
44     , a14 out nocopy JTF_VARCHAR2_TABLE_200
45     , a15 out nocopy JTF_VARCHAR2_TABLE_100
46     , a16 out nocopy JTF_VARCHAR2_TABLE_100
47     , a17 out nocopy JTF_VARCHAR2_TABLE_100
48     , a18 out nocopy JTF_VARCHAR2_TABLE_100
49     , a19 out nocopy JTF_VARCHAR2_TABLE_100
50     , a20 out nocopy JTF_VARCHAR2_TABLE_100
51     , a21 out nocopy JTF_NUMBER_TABLE
52     , a22 out nocopy JTF_NUMBER_TABLE
53     , a23 out nocopy JTF_NUMBER_TABLE
54     , a24 out nocopy JTF_VARCHAR2_TABLE_100
55     , a25 out nocopy JTF_NUMBER_TABLE
56     );
57 
58   procedure rosetta_table_copy_in_p9(t out nocopy jtf_tasks_pub.task_depends_tbl, a0 JTF_NUMBER_TABLE
59     , a1 JTF_NUMBER_TABLE
60     , a2 JTF_VARCHAR2_TABLE_100
61     , a3 JTF_NUMBER_TABLE
62     , a4 JTF_VARCHAR2_TABLE_100
63     , a5 JTF_VARCHAR2_TABLE_100
64     );
65   procedure rosetta_table_copy_out_p9(t jtf_tasks_pub.task_depends_tbl, a0 out nocopy JTF_NUMBER_TABLE
66     , a1 out nocopy JTF_NUMBER_TABLE
67     , a2 out nocopy JTF_VARCHAR2_TABLE_100
68     , a3 out nocopy JTF_NUMBER_TABLE
69     , a4 out nocopy JTF_VARCHAR2_TABLE_100
70     , a5 out nocopy JTF_VARCHAR2_TABLE_100
71     );
72 
73   procedure rosetta_table_copy_in_p12(t out nocopy jtf_tasks_pub.task_rsrc_req_tbl, a0 JTF_VARCHAR2_TABLE_100
74     , a1 JTF_NUMBER_TABLE
75     , a2 JTF_VARCHAR2_TABLE_100
76     );
77   procedure rosetta_table_copy_out_p12(t jtf_tasks_pub.task_rsrc_req_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
78     , a1 out nocopy JTF_NUMBER_TABLE
79     , a2 out nocopy JTF_VARCHAR2_TABLE_100
80     );
81 
82   procedure rosetta_table_copy_in_p15(t out nocopy jtf_tasks_pub.task_refer_tbl, a0 JTF_VARCHAR2_TABLE_100
83     , a1 JTF_VARCHAR2_TABLE_100
84     , a2 JTF_VARCHAR2_TABLE_100
85     , a3 JTF_NUMBER_TABLE
86     , a4 JTF_VARCHAR2_TABLE_2000
87     , a5 JTF_VARCHAR2_TABLE_100
88     , a6 JTF_VARCHAR2_TABLE_2000
89     );
90   procedure rosetta_table_copy_out_p15(t jtf_tasks_pub.task_refer_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
91     , a1 out nocopy JTF_VARCHAR2_TABLE_100
92     , a2 out nocopy JTF_VARCHAR2_TABLE_100
93     , a3 out nocopy JTF_NUMBER_TABLE
94     , a4 out nocopy JTF_VARCHAR2_TABLE_2000
95     , a5 out nocopy JTF_VARCHAR2_TABLE_100
96     , a6 out nocopy JTF_VARCHAR2_TABLE_2000
97     );
98 
99   procedure rosetta_table_copy_in_p20(t out nocopy jtf_tasks_pub.task_dates_tbl, a0 JTF_NUMBER_TABLE
100     , a1 JTF_VARCHAR2_TABLE_100
101     , a2 JTF_VARCHAR2_TABLE_100
102     , a3 JTF_DATE_TABLE
103     );
104   procedure rosetta_table_copy_out_p20(t jtf_tasks_pub.task_dates_tbl, a0 out nocopy JTF_NUMBER_TABLE
105     , a1 out nocopy JTF_VARCHAR2_TABLE_100
106     , a2 out nocopy JTF_VARCHAR2_TABLE_100
107     , a3 out nocopy JTF_DATE_TABLE
108     );
109 
110   procedure rosetta_table_copy_in_p23(t out nocopy jtf_tasks_pub.task_notes_tbl, a0 JTF_NUMBER_TABLE
111     , a1 JTF_NUMBER_TABLE
112     , a2 JTF_VARCHAR2_TABLE_4000
113     , a3 JTF_VARCHAR2_TABLE_32767
114     , a4 JTF_VARCHAR2_TABLE_100
115     , a5 JTF_NUMBER_TABLE
116     , a6 JTF_DATE_TABLE
117     , a7 JTF_VARCHAR2_TABLE_100
118     , a8 JTF_NUMBER_TABLE
119     , a9 JTF_VARCHAR2_TABLE_200
120     , a10 JTF_VARCHAR2_TABLE_200
121     , a11 JTF_VARCHAR2_TABLE_200
122     , a12 JTF_VARCHAR2_TABLE_200
123     , a13 JTF_VARCHAR2_TABLE_200
124     , a14 JTF_VARCHAR2_TABLE_200
125     , a15 JTF_VARCHAR2_TABLE_200
126     , a16 JTF_VARCHAR2_TABLE_200
127     , a17 JTF_VARCHAR2_TABLE_200
128     , a18 JTF_VARCHAR2_TABLE_200
129     , a19 JTF_VARCHAR2_TABLE_200
130     , a20 JTF_VARCHAR2_TABLE_200
131     , a21 JTF_VARCHAR2_TABLE_200
132     , a22 JTF_VARCHAR2_TABLE_200
133     , a23 JTF_VARCHAR2_TABLE_200
134     , a24 JTF_VARCHAR2_TABLE_100
135     );
136   procedure rosetta_table_copy_out_p23(t jtf_tasks_pub.task_notes_tbl, a0 out nocopy JTF_NUMBER_TABLE
137     , a1 out nocopy JTF_NUMBER_TABLE
138     , a2 out nocopy JTF_VARCHAR2_TABLE_4000
139     , a3 out nocopy JTF_VARCHAR2_TABLE_32767
140     , a4 out nocopy JTF_VARCHAR2_TABLE_100
141     , a5 out nocopy JTF_NUMBER_TABLE
142     , a6 out nocopy JTF_DATE_TABLE
143     , a7 out nocopy JTF_VARCHAR2_TABLE_100
144     , a8 out nocopy JTF_NUMBER_TABLE
145     , a9 out nocopy JTF_VARCHAR2_TABLE_200
146     , a10 out nocopy JTF_VARCHAR2_TABLE_200
147     , a11 out nocopy JTF_VARCHAR2_TABLE_200
148     , a12 out nocopy JTF_VARCHAR2_TABLE_200
149     , a13 out nocopy JTF_VARCHAR2_TABLE_200
150     , a14 out nocopy JTF_VARCHAR2_TABLE_200
151     , a15 out nocopy JTF_VARCHAR2_TABLE_200
152     , a16 out nocopy JTF_VARCHAR2_TABLE_200
153     , a17 out nocopy JTF_VARCHAR2_TABLE_200
154     , a18 out nocopy JTF_VARCHAR2_TABLE_200
155     , a19 out nocopy JTF_VARCHAR2_TABLE_200
156     , a20 out nocopy JTF_VARCHAR2_TABLE_200
157     , a21 out nocopy JTF_VARCHAR2_TABLE_200
158     , a22 out nocopy JTF_VARCHAR2_TABLE_200
159     , a23 out nocopy JTF_VARCHAR2_TABLE_200
160     , a24 out nocopy JTF_VARCHAR2_TABLE_100
161     );
162 
163   procedure rosetta_table_copy_in_p26(t out nocopy jtf_tasks_pub.task_contacts_tbl, a0 JTF_NUMBER_TABLE
164     , a1 JTF_VARCHAR2_TABLE_100
165     , a2 JTF_VARCHAR2_TABLE_100
166     , a3 JTF_VARCHAR2_TABLE_100
167     );
168   procedure rosetta_table_copy_out_p26(t jtf_tasks_pub.task_contacts_tbl, a0 out nocopy JTF_NUMBER_TABLE
169     , a1 out nocopy JTF_VARCHAR2_TABLE_100
170     , a2 out nocopy JTF_VARCHAR2_TABLE_100
171     , a3 out nocopy JTF_VARCHAR2_TABLE_100
172     );
173 
174   procedure rosetta_table_copy_in_p31(t out nocopy jtf_tasks_pub.task_table_type, a0 JTF_NUMBER_TABLE
175     , a1 JTF_VARCHAR2_TABLE_100
176     , a2 JTF_VARCHAR2_TABLE_100
177     , a3 JTF_VARCHAR2_TABLE_4000
178     , a4 JTF_NUMBER_TABLE
179     , a5 JTF_VARCHAR2_TABLE_100
180     , a6 JTF_NUMBER_TABLE
181     , a7 JTF_VARCHAR2_TABLE_100
182     , a8 JTF_NUMBER_TABLE
183     , a9 JTF_VARCHAR2_TABLE_100
184     , a10 JTF_VARCHAR2_TABLE_100
185     , a11 JTF_NUMBER_TABLE
186     , a12 JTF_VARCHAR2_TABLE_4000
187     , a13 JTF_NUMBER_TABLE
188     , a14 JTF_VARCHAR2_TABLE_4000
189     , a15 JTF_NUMBER_TABLE
190     , a16 JTF_VARCHAR2_TABLE_400
191     , a17 JTF_VARCHAR2_TABLE_100
192     , a18 JTF_VARCHAR2_TABLE_100
193     , a19 JTF_NUMBER_TABLE
194     , a20 JTF_NUMBER_TABLE
195     , a21 JTF_DATE_TABLE
196     , a22 JTF_DATE_TABLE
197     , a23 JTF_DATE_TABLE
198     , a24 JTF_DATE_TABLE
199     , a25 JTF_DATE_TABLE
200     , a26 JTF_DATE_TABLE
201     , a27 JTF_VARCHAR2_TABLE_100
202     , a28 JTF_NUMBER_TABLE
203     , a29 JTF_VARCHAR2_TABLE_100
204     , a30 JTF_NUMBER_TABLE
205     , a31 JTF_VARCHAR2_TABLE_100
206     , a32 JTF_NUMBER_TABLE
207     , a33 JTF_VARCHAR2_TABLE_100
208     , a34 JTF_NUMBER_TABLE
209     , a35 JTF_VARCHAR2_TABLE_100
210     , a36 JTF_NUMBER_TABLE
211     , a37 JTF_VARCHAR2_TABLE_100
212     , a38 JTF_VARCHAR2_TABLE_100
213     , a39 JTF_VARCHAR2_TABLE_100
214     , a40 JTF_VARCHAR2_TABLE_100
215     , a41 JTF_VARCHAR2_TABLE_100
216     , a42 JTF_VARCHAR2_TABLE_100
217     , a43 JTF_NUMBER_TABLE
218     , a44 JTF_VARCHAR2_TABLE_100
219     , a45 JTF_NUMBER_TABLE
220     , a46 JTF_VARCHAR2_TABLE_100
221     , a47 JTF_NUMBER_TABLE
222     , a48 JTF_NUMBER_TABLE
223     , a49 JTF_VARCHAR2_TABLE_100
224     , a50 JTF_VARCHAR2_TABLE_100
225     , a51 JTF_NUMBER_TABLE
226     , a52 JTF_NUMBER_TABLE
227     , a53 JTF_NUMBER_TABLE
228     , a54 JTF_VARCHAR2_TABLE_100
229     , a55 JTF_VARCHAR2_TABLE_200
230     , a56 JTF_VARCHAR2_TABLE_200
231     , a57 JTF_VARCHAR2_TABLE_200
232     , a58 JTF_VARCHAR2_TABLE_200
233     , a59 JTF_VARCHAR2_TABLE_200
234     , a60 JTF_VARCHAR2_TABLE_200
235     , a61 JTF_VARCHAR2_TABLE_200
236     , a62 JTF_VARCHAR2_TABLE_200
237     , a63 JTF_VARCHAR2_TABLE_200
238     , a64 JTF_VARCHAR2_TABLE_200
239     , a65 JTF_VARCHAR2_TABLE_200
240     , a66 JTF_VARCHAR2_TABLE_200
241     , a67 JTF_VARCHAR2_TABLE_200
242     , a68 JTF_VARCHAR2_TABLE_200
243     , a69 JTF_VARCHAR2_TABLE_200
244     , a70 JTF_VARCHAR2_TABLE_200
245     , a71 JTF_NUMBER_TABLE
246     , a72 JTF_DATE_TABLE
247     , a73 JTF_VARCHAR2_TABLE_4000
248     , a74 JTF_NUMBER_TABLE
249     , a75 JTF_DATE_TABLE
250     , a76 JTF_DATE_TABLE
251     , a77 JTF_VARCHAR2_TABLE_100
252     , a78 JTF_VARCHAR2_TABLE_100
253     , a79 JTF_VARCHAR2_TABLE_100
254     , a80 JTF_NUMBER_TABLE
255     , a81 JTF_NUMBER_TABLE
256     );
257   procedure rosetta_table_copy_out_p31(t jtf_tasks_pub.task_table_type, a0 out nocopy JTF_NUMBER_TABLE
258     , a1 out nocopy JTF_VARCHAR2_TABLE_100
259     , a2 out nocopy JTF_VARCHAR2_TABLE_100
260     , a3 out nocopy JTF_VARCHAR2_TABLE_4000
261     , a4 out nocopy JTF_NUMBER_TABLE
262     , a5 out nocopy JTF_VARCHAR2_TABLE_100
263     , a6 out nocopy JTF_NUMBER_TABLE
264     , a7 out nocopy JTF_VARCHAR2_TABLE_100
265     , a8 out nocopy JTF_NUMBER_TABLE
266     , a9 out nocopy JTF_VARCHAR2_TABLE_100
267     , a10 out nocopy JTF_VARCHAR2_TABLE_100
268     , a11 out nocopy JTF_NUMBER_TABLE
269     , a12 out nocopy JTF_VARCHAR2_TABLE_4000
270     , a13 out nocopy JTF_NUMBER_TABLE
271     , a14 out nocopy JTF_VARCHAR2_TABLE_4000
272     , a15 out nocopy JTF_NUMBER_TABLE
273     , a16 out nocopy JTF_VARCHAR2_TABLE_400
274     , a17 out nocopy JTF_VARCHAR2_TABLE_100
275     , a18 out nocopy JTF_VARCHAR2_TABLE_100
276     , a19 out nocopy JTF_NUMBER_TABLE
277     , a20 out nocopy JTF_NUMBER_TABLE
278     , a21 out nocopy JTF_DATE_TABLE
279     , a22 out nocopy JTF_DATE_TABLE
280     , a23 out nocopy JTF_DATE_TABLE
281     , a24 out nocopy JTF_DATE_TABLE
282     , a25 out nocopy JTF_DATE_TABLE
283     , a26 out nocopy JTF_DATE_TABLE
284     , a27 out nocopy JTF_VARCHAR2_TABLE_100
285     , a28 out nocopy JTF_NUMBER_TABLE
286     , a29 out nocopy JTF_VARCHAR2_TABLE_100
287     , a30 out nocopy JTF_NUMBER_TABLE
288     , a31 out nocopy JTF_VARCHAR2_TABLE_100
289     , a32 out nocopy JTF_NUMBER_TABLE
290     , a33 out nocopy JTF_VARCHAR2_TABLE_100
291     , a34 out nocopy JTF_NUMBER_TABLE
292     , a35 out nocopy JTF_VARCHAR2_TABLE_100
293     , a36 out nocopy JTF_NUMBER_TABLE
294     , a37 out nocopy JTF_VARCHAR2_TABLE_100
295     , a38 out nocopy JTF_VARCHAR2_TABLE_100
296     , a39 out nocopy JTF_VARCHAR2_TABLE_100
297     , a40 out nocopy JTF_VARCHAR2_TABLE_100
298     , a41 out nocopy JTF_VARCHAR2_TABLE_100
299     , a42 out nocopy JTF_VARCHAR2_TABLE_100
300     , a43 out nocopy JTF_NUMBER_TABLE
301     , a44 out nocopy JTF_VARCHAR2_TABLE_100
302     , a45 out nocopy JTF_NUMBER_TABLE
303     , a46 out nocopy JTF_VARCHAR2_TABLE_100
304     , a47 out nocopy JTF_NUMBER_TABLE
305     , a48 out nocopy JTF_NUMBER_TABLE
306     , a49 out nocopy JTF_VARCHAR2_TABLE_100
307     , a50 out nocopy JTF_VARCHAR2_TABLE_100
308     , a51 out nocopy JTF_NUMBER_TABLE
309     , a52 out nocopy JTF_NUMBER_TABLE
310     , a53 out nocopy JTF_NUMBER_TABLE
311     , a54 out nocopy JTF_VARCHAR2_TABLE_100
312     , a55 out nocopy JTF_VARCHAR2_TABLE_200
313     , a56 out nocopy JTF_VARCHAR2_TABLE_200
314     , a57 out nocopy JTF_VARCHAR2_TABLE_200
315     , a58 out nocopy JTF_VARCHAR2_TABLE_200
316     , a59 out nocopy JTF_VARCHAR2_TABLE_200
317     , a60 out nocopy JTF_VARCHAR2_TABLE_200
318     , a61 out nocopy JTF_VARCHAR2_TABLE_200
319     , a62 out nocopy JTF_VARCHAR2_TABLE_200
320     , a63 out nocopy JTF_VARCHAR2_TABLE_200
321     , a64 out nocopy JTF_VARCHAR2_TABLE_200
322     , a65 out nocopy JTF_VARCHAR2_TABLE_200
323     , a66 out nocopy JTF_VARCHAR2_TABLE_200
324     , a67 out nocopy JTF_VARCHAR2_TABLE_200
325     , a68 out nocopy JTF_VARCHAR2_TABLE_200
326     , a69 out nocopy JTF_VARCHAR2_TABLE_200
327     , a70 out nocopy JTF_VARCHAR2_TABLE_200
328     , a71 out nocopy JTF_NUMBER_TABLE
329     , a72 out nocopy JTF_DATE_TABLE
330     , a73 out nocopy JTF_VARCHAR2_TABLE_4000
331     , a74 out nocopy JTF_NUMBER_TABLE
332     , a75 out nocopy JTF_DATE_TABLE
333     , a76 out nocopy JTF_DATE_TABLE
334     , a77 out nocopy JTF_VARCHAR2_TABLE_100
335     , a78 out nocopy JTF_VARCHAR2_TABLE_100
336     , a79 out nocopy JTF_VARCHAR2_TABLE_100
337     , a80 out nocopy JTF_NUMBER_TABLE
338     , a81 out nocopy JTF_NUMBER_TABLE
339     );
340 
341   procedure rosetta_table_copy_in_p34(t out nocopy jtf_tasks_pub.sort_data, a0 JTF_VARCHAR2_TABLE_100
342     , a1 JTF_VARCHAR2_TABLE_100
343     );
344   procedure rosetta_table_copy_out_p34(t jtf_tasks_pub.sort_data, a0 out nocopy JTF_VARCHAR2_TABLE_100
345     , a1 out nocopy JTF_VARCHAR2_TABLE_100
346     );
347 
348   procedure rosetta_table_copy_in_p53(t out nocopy jtf_tasks_pub.task_details_tbl, a0 JTF_NUMBER_TABLE
349     , a1 JTF_NUMBER_TABLE
350     );
351   procedure rosetta_table_copy_out_p53(t jtf_tasks_pub.task_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
352     , a1 out nocopy JTF_NUMBER_TABLE
353     );
354 
355   procedure create_task(p_api_version  NUMBER
356     , p_init_msg_list  VARCHAR2
357     , p_commit  VARCHAR2
358     , p_task_id  NUMBER
359     , p_task_name  VARCHAR2
360     , p_task_type_name  VARCHAR2
361     , p_task_type_id  NUMBER
362     , p_description  VARCHAR2
363     , p_task_status_name  VARCHAR2
364     , p_task_status_id  NUMBER
365     , p_task_priority_name  VARCHAR2
366     , p_task_priority_id  NUMBER
367     , p_owner_type_name  VARCHAR2
368     , p_owner_type_code  VARCHAR2
369     , p_owner_id  NUMBER
370     , p_owner_territory_id  NUMBER
371     , p_assigned_by_name  VARCHAR2
372     , p_assigned_by_id  NUMBER
373     , p_customer_number  VARCHAR2
374     , p_customer_id  NUMBER
375     , p_cust_account_number  VARCHAR2
376     , p_cust_account_id  NUMBER
377     , p_address_id  NUMBER
378     , p_address_number  VARCHAR2
379     , p_planned_start_date  date
380     , p_planned_end_date  date
381     , p_scheduled_start_date  date
382     , p_scheduled_end_date  date
383     , p_actual_start_date  date
384     , p_actual_end_date  date
385     , p_timezone_id  NUMBER
386     , p_timezone_name  VARCHAR2
387     , p_source_object_type_code  VARCHAR2
388     , p_source_object_id  NUMBER
389     , p_source_object_name  VARCHAR2
390     , p_duration  NUMBER
391     , p_duration_uom  VARCHAR2
392     , p_planned_effort  NUMBER
393     , p_planned_effort_uom  VARCHAR2
394     , p_actual_effort  NUMBER
395     , p_actual_effort_uom  VARCHAR2
396     , p_percentage_complete  NUMBER
397     , p_reason_code  VARCHAR2
398     , p_private_flag  VARCHAR2
399     , p_publish_flag  VARCHAR2
400     , p_restrict_closure_flag  VARCHAR2
401     , p_multi_booked_flag  VARCHAR2
402     , p_milestone_flag  VARCHAR2
403     , p_holiday_flag  VARCHAR2
404     , p_billable_flag  VARCHAR2
405     , p_bound_mode_code  VARCHAR2
406     , p_soft_bound_flag  VARCHAR2
407     , p_workflow_process_id  NUMBER
408     , p_notification_flag  VARCHAR2
409     , p_notification_period  NUMBER
410     , p_notification_period_uom  VARCHAR2
411     , p_parent_task_number  VARCHAR2
412     , p_parent_task_id  NUMBER
413     , p_alarm_start  NUMBER
414     , p_alarm_start_uom  VARCHAR2
415     , p_alarm_on  VARCHAR2
416     , p_alarm_count  NUMBER
417     , p_alarm_interval  NUMBER
418     , p_alarm_interval_uom  VARCHAR2
419     , p_palm_flag  VARCHAR2
420     , p_wince_flag  VARCHAR2
421     , p_laptop_flag  VARCHAR2
422     , p_device1_flag  VARCHAR2
423     , p_device2_flag  VARCHAR2
424     , p_device3_flag  VARCHAR2
425     , p_costs  NUMBER
426     , p_currency_code  VARCHAR2
427     , p_escalation_level  VARCHAR2
428     , p73_a0 JTF_VARCHAR2_TABLE_100
429     , p73_a1 JTF_NUMBER_TABLE
430     , p73_a2 JTF_DATE_TABLE
431     , p73_a3 JTF_DATE_TABLE
432     , p73_a4 JTF_NUMBER_TABLE
433     , p73_a5 JTF_VARCHAR2_TABLE_100
434     , p73_a6 JTF_NUMBER_TABLE
435     , p73_a7 JTF_NUMBER_TABLE
436     , p73_a8 JTF_VARCHAR2_TABLE_100
437     , p73_a9 JTF_NUMBER_TABLE
438     , p73_a10 JTF_NUMBER_TABLE
439     , p73_a11 JTF_VARCHAR2_TABLE_100
440     , p73_a12 JTF_VARCHAR2_TABLE_100
441     , p73_a13 JTF_VARCHAR2_TABLE_100
442     , p73_a14 JTF_VARCHAR2_TABLE_200
443     , p73_a15 JTF_VARCHAR2_TABLE_100
444     , p73_a16 JTF_VARCHAR2_TABLE_100
445     , p73_a17 JTF_VARCHAR2_TABLE_100
446     , p73_a18 JTF_VARCHAR2_TABLE_100
447     , p73_a19 JTF_VARCHAR2_TABLE_100
448     , p73_a20 JTF_VARCHAR2_TABLE_100
449     , p73_a21 JTF_NUMBER_TABLE
450     , p73_a22 JTF_NUMBER_TABLE
451     , p73_a23 JTF_NUMBER_TABLE
452     , p73_a24 JTF_VARCHAR2_TABLE_100
453     , p73_a25 JTF_NUMBER_TABLE
454     , p74_a0 JTF_NUMBER_TABLE
455     , p74_a1 JTF_NUMBER_TABLE
456     , p74_a2 JTF_VARCHAR2_TABLE_100
457     , p74_a3 JTF_NUMBER_TABLE
458     , p74_a4 JTF_VARCHAR2_TABLE_100
459     , p74_a5 JTF_VARCHAR2_TABLE_100
460     , p75_a0 JTF_VARCHAR2_TABLE_100
461     , p75_a1 JTF_NUMBER_TABLE
462     , p75_a2 JTF_VARCHAR2_TABLE_100
463     , p76_a0 JTF_VARCHAR2_TABLE_100
464     , p76_a1 JTF_VARCHAR2_TABLE_100
465     , p76_a2 JTF_VARCHAR2_TABLE_100
466     , p76_a3 JTF_NUMBER_TABLE
467     , p76_a4 JTF_VARCHAR2_TABLE_2000
468     , p76_a5 JTF_VARCHAR2_TABLE_100
469     , p76_a6 JTF_VARCHAR2_TABLE_2000
470     , p77_a0 JTF_NUMBER_TABLE
471     , p77_a1 JTF_VARCHAR2_TABLE_100
472     , p77_a2 JTF_VARCHAR2_TABLE_100
473     , p77_a3 JTF_DATE_TABLE
474     , p78_a0 JTF_NUMBER_TABLE
475     , p78_a1 JTF_NUMBER_TABLE
476     , p78_a2 JTF_VARCHAR2_TABLE_4000
477     , p78_a3 JTF_VARCHAR2_TABLE_32767
478     , p78_a4 JTF_VARCHAR2_TABLE_100
479     , p78_a5 JTF_NUMBER_TABLE
480     , p78_a6 JTF_DATE_TABLE
481     , p78_a7 JTF_VARCHAR2_TABLE_100
482     , p78_a8 JTF_NUMBER_TABLE
483     , p78_a9 JTF_VARCHAR2_TABLE_200
484     , p78_a10 JTF_VARCHAR2_TABLE_200
485     , p78_a11 JTF_VARCHAR2_TABLE_200
486     , p78_a12 JTF_VARCHAR2_TABLE_200
487     , p78_a13 JTF_VARCHAR2_TABLE_200
488     , p78_a14 JTF_VARCHAR2_TABLE_200
489     , p78_a15 JTF_VARCHAR2_TABLE_200
490     , p78_a16 JTF_VARCHAR2_TABLE_200
491     , p78_a17 JTF_VARCHAR2_TABLE_200
492     , p78_a18 JTF_VARCHAR2_TABLE_200
493     , p78_a19 JTF_VARCHAR2_TABLE_200
494     , p78_a20 JTF_VARCHAR2_TABLE_200
495     , p78_a21 JTF_VARCHAR2_TABLE_200
496     , p78_a22 JTF_VARCHAR2_TABLE_200
497     , p78_a23 JTF_VARCHAR2_TABLE_200
498     , p78_a24 JTF_VARCHAR2_TABLE_100
499     , p79_a0  NUMBER
500     , p79_a1  NUMBER
501     , p79_a2  NUMBER
502     , p79_a3  NUMBER
503     , p79_a4  VARCHAR2
504     , p79_a5  NUMBER
505     , p79_a6  NUMBER
506     , p79_a7  DATE
507     , p79_a8  DATE
508     , p80_a0 JTF_NUMBER_TABLE
509     , p80_a1 JTF_VARCHAR2_TABLE_100
510     , p80_a2 JTF_VARCHAR2_TABLE_100
511     , p80_a3 JTF_VARCHAR2_TABLE_100
512     , x_return_status out nocopy  VARCHAR2
513     , x_msg_count out nocopy  NUMBER
514     , x_msg_data out nocopy  VARCHAR2
515     , x_task_id out nocopy  NUMBER
516     , p_attribute1  VARCHAR2
517     , p_attribute2  VARCHAR2
518     , p_attribute3  VARCHAR2
519     , p_attribute4  VARCHAR2
520     , p_attribute5  VARCHAR2
521     , p_attribute6  VARCHAR2
522     , p_attribute7  VARCHAR2
523     , p_attribute8  VARCHAR2
524     , p_attribute9  VARCHAR2
525     , p_attribute10  VARCHAR2
526     , p_attribute11  VARCHAR2
530     , p_attribute15  VARCHAR2
527     , p_attribute12  VARCHAR2
528     , p_attribute13  VARCHAR2
529     , p_attribute14  VARCHAR2
531     , p_attribute_category  VARCHAR2
532     , p_date_selected  VARCHAR2
533     , p_category_id  NUMBER
534     , p_show_on_calendar  VARCHAR2
535     , p_owner_status_id  NUMBER
536     , p_template_id  NUMBER
537     , p_template_group_id  NUMBER
538     , p_enable_workflow  VARCHAR2
539     , p_abort_workflow  VARCHAR2
540     , p_task_split_flag  VARCHAR2
541     , p_reference_flag  VARCHAR2
542     , p_child_position  VARCHAR2
543     , p_child_sequence_num  NUMBER
544     , p_location_id  NUMBER
545   );
546   procedure create_task(p_api_version  NUMBER
547     , p_init_msg_list  VARCHAR2
548     , p_commit  VARCHAR2
549     , p_task_id  NUMBER
550     , p_task_name  VARCHAR2
551     , p_task_type_name  VARCHAR2
552     , p_task_type_id  NUMBER
553     , p_description  VARCHAR2
554     , p_task_status_name  VARCHAR2
555     , p_task_status_id  NUMBER
556     , p_task_priority_name  VARCHAR2
557     , p_task_priority_id  NUMBER
558     , p_owner_type_name  VARCHAR2
559     , p_owner_type_code  VARCHAR2
560     , p_owner_id  NUMBER
561     , p_owner_territory_id  NUMBER
562     , p_assigned_by_name  VARCHAR2
563     , p_assigned_by_id  NUMBER
564     , p_customer_number  VARCHAR2
565     , p_customer_id  NUMBER
566     , p_cust_account_number  VARCHAR2
567     , p_cust_account_id  NUMBER
568     , p_address_id  NUMBER
569     , p_address_number  VARCHAR2
570     , p_planned_start_date  date
571     , p_planned_end_date  date
572     , p_scheduled_start_date  date
573     , p_scheduled_end_date  date
574     , p_actual_start_date  date
575     , p_actual_end_date  date
576     , p_timezone_id  NUMBER
577     , p_timezone_name  VARCHAR2
578     , p_source_object_type_code  VARCHAR2
579     , p_source_object_id  NUMBER
580     , p_source_object_name  VARCHAR2
581     , p_duration  NUMBER
582     , p_duration_uom  VARCHAR2
583     , p_planned_effort  NUMBER
584     , p_planned_effort_uom  VARCHAR2
585     , p_actual_effort  NUMBER
586     , p_actual_effort_uom  VARCHAR2
587     , p_percentage_complete  NUMBER
588     , p_reason_code  VARCHAR2
589     , p_private_flag  VARCHAR2
590     , p_publish_flag  VARCHAR2
591     , p_restrict_closure_flag  VARCHAR2
592     , p_multi_booked_flag  VARCHAR2
593     , p_milestone_flag  VARCHAR2
594     , p_holiday_flag  VARCHAR2
595     , p_billable_flag  VARCHAR2
596     , p_bound_mode_code  VARCHAR2
597     , p_soft_bound_flag  VARCHAR2
598     , p_workflow_process_id  NUMBER
599     , p_notification_flag  VARCHAR2
600     , p_notification_period  NUMBER
601     , p_notification_period_uom  VARCHAR2
602     , p_parent_task_number  VARCHAR2
603     , p_parent_task_id  NUMBER
604     , p_alarm_start  NUMBER
605     , p_alarm_start_uom  VARCHAR2
606     , p_alarm_on  VARCHAR2
607     , p_alarm_count  NUMBER
608     , p_alarm_interval  NUMBER
609     , p_alarm_interval_uom  VARCHAR2
610     , p_palm_flag  VARCHAR2
611     , p_wince_flag  VARCHAR2
612     , p_laptop_flag  VARCHAR2
613     , p_device1_flag  VARCHAR2
614     , p_device2_flag  VARCHAR2
615     , p_device3_flag  VARCHAR2
616     , p_costs  NUMBER
617     , p_currency_code  VARCHAR2
618     , p_escalation_level  VARCHAR2
619     , x_return_status out nocopy  VARCHAR2
620     , x_msg_count out nocopy  NUMBER
621     , x_msg_data out nocopy  VARCHAR2
622     , x_task_id out nocopy  NUMBER
623     , p_attribute1  VARCHAR2
624     , p_attribute2  VARCHAR2
625     , p_attribute3  VARCHAR2
626     , p_attribute4  VARCHAR2
627     , p_attribute5  VARCHAR2
628     , p_attribute6  VARCHAR2
629     , p_attribute7  VARCHAR2
630     , p_attribute8  VARCHAR2
631     , p_attribute9  VARCHAR2
632     , p_attribute10  VARCHAR2
633     , p_attribute11  VARCHAR2
634     , p_attribute12  VARCHAR2
635     , p_attribute13  VARCHAR2
636     , p_attribute14  VARCHAR2
637     , p_attribute15  VARCHAR2
638     , p_attribute_category  VARCHAR2
639     , p_date_selected  VARCHAR2
640     , p_category_id  NUMBER
641     , p_show_on_calendar  VARCHAR2
642     , p_owner_status_id  NUMBER
643     , p_template_id  NUMBER
644     , p_template_group_id  NUMBER
645     , p_enable_workflow  VARCHAR2
646     , p_abort_workflow  VARCHAR2
647     , p_task_split_flag  VARCHAR2
648     , p_reference_flag  VARCHAR2
649     , p_child_position  VARCHAR2
650     , p_child_sequence_num  NUMBER
651   );
652   procedure create_task(p_api_version  NUMBER
653     , p_init_msg_list  VARCHAR2
654     , p_commit  VARCHAR2
655     , p_task_id  NUMBER
656     , p_task_name  VARCHAR2
657     , p_task_type_name  VARCHAR2
658     , p_task_type_id  NUMBER
659     , p_description  VARCHAR2
660     , p_task_status_name  VARCHAR2
661     , p_task_status_id  NUMBER
662     , p_task_priority_name  VARCHAR2
663     , p_task_priority_id  NUMBER
664     , p_owner_type_name  VARCHAR2
665     , p_owner_type_code  VARCHAR2
666     , p_owner_id  NUMBER
667     , p_owner_territory_id  NUMBER
668     , p_assigned_by_name  VARCHAR2
669     , p_assigned_by_id  NUMBER
670     , p_customer_number  VARCHAR2
671     , p_customer_id  NUMBER
672     , p_cust_account_number  VARCHAR2
673     , p_cust_account_id  NUMBER
674     , p_address_id  NUMBER
675     , p_address_number  VARCHAR2
676     , p_planned_start_date  date
677     , p_planned_end_date  date
678     , p_scheduled_start_date  date
679     , p_scheduled_end_date  date
680     , p_actual_start_date  date
681     , p_actual_end_date  date
682     , p_timezone_id  NUMBER
683     , p_timezone_name  VARCHAR2
684     , p_source_object_type_code  VARCHAR2
685     , p_source_object_id  NUMBER
686     , p_source_object_name  VARCHAR2
687     , p_duration  NUMBER
688     , p_duration_uom  VARCHAR2
689     , p_planned_effort  NUMBER
690     , p_planned_effort_uom  VARCHAR2
691     , p_actual_effort  NUMBER
692     , p_actual_effort_uom  VARCHAR2
693     , p_percentage_complete  NUMBER
694     , p_reason_code  VARCHAR2
695     , p_private_flag  VARCHAR2
696     , p_publish_flag  VARCHAR2
697     , p_restrict_closure_flag  VARCHAR2
698     , p_multi_booked_flag  VARCHAR2
699     , p_milestone_flag  VARCHAR2
700     , p_holiday_flag  VARCHAR2
701     , p_billable_flag  VARCHAR2
702     , p_bound_mode_code  VARCHAR2
703     , p_soft_bound_flag  VARCHAR2
704     , p_workflow_process_id  NUMBER
705     , p_notification_flag  VARCHAR2
706     , p_notification_period  NUMBER
707     , p_notification_period_uom  VARCHAR2
708     , p_parent_task_number  VARCHAR2
709     , p_parent_task_id  NUMBER
710     , p_alarm_start  NUMBER
711     , p_alarm_start_uom  VARCHAR2
712     , p_alarm_on  VARCHAR2
713     , p_alarm_count  NUMBER
714     , p_alarm_interval  NUMBER
715     , p_alarm_interval_uom  VARCHAR2
716     , p_palm_flag  VARCHAR2
717     , p_wince_flag  VARCHAR2
718     , p_laptop_flag  VARCHAR2
719     , p_device1_flag  VARCHAR2
720     , p_device2_flag  VARCHAR2
721     , p_device3_flag  VARCHAR2
722     , p_costs  NUMBER
723     , p_currency_code  VARCHAR2
724     , p_escalation_level  VARCHAR2
725     , x_return_status out nocopy  VARCHAR2
726     , x_msg_count out nocopy  NUMBER
727     , x_msg_data out nocopy  VARCHAR2
728     , x_task_id out nocopy  NUMBER
729     , p_attribute1  VARCHAR2
730     , p_attribute2  VARCHAR2
731     , p_attribute3  VARCHAR2
732     , p_attribute4  VARCHAR2
733     , p_attribute5  VARCHAR2
734     , p_attribute6  VARCHAR2
735     , p_attribute7  VARCHAR2
736     , p_attribute8  VARCHAR2
737     , p_attribute9  VARCHAR2
738     , p_attribute10  VARCHAR2
739     , p_attribute11  VARCHAR2
740     , p_attribute12  VARCHAR2
741     , p_attribute13  VARCHAR2
742     , p_attribute14  VARCHAR2
743     , p_attribute15  VARCHAR2
744     , p_attribute_category  VARCHAR2
745     , p_date_selected  VARCHAR2
746     , p_category_id  NUMBER
747     , p_show_on_calendar  VARCHAR2
748     , p_owner_status_id  NUMBER
749     , p_template_id  NUMBER
750     , p_template_group_id  NUMBER
751     , p_enable_workflow  VARCHAR2
752     , p_abort_workflow  VARCHAR2
753   );
754   procedure create_task(p_api_version  NUMBER
755     , p_init_msg_list  VARCHAR2
756     , p_commit  VARCHAR2
757     , p_task_id  NUMBER
758     , p_task_name  VARCHAR2
759     , p_task_type_name  VARCHAR2
760     , p_task_type_id  NUMBER
761     , p_description  VARCHAR2
762     , p_task_status_name  VARCHAR2
763     , p_task_status_id  NUMBER
764     , p_task_priority_name  VARCHAR2
765     , p_task_priority_id  NUMBER
766     , p_owner_type_name  VARCHAR2
767     , p_owner_type_code  VARCHAR2
768     , p_owner_id  NUMBER
769     , p_owner_territory_id  NUMBER
770     , p_assigned_by_name  VARCHAR2
771     , p_assigned_by_id  NUMBER
772     , p_customer_number  VARCHAR2
773     , p_customer_id  NUMBER
774     , p_cust_account_number  VARCHAR2
775     , p_cust_account_id  NUMBER
776     , p_address_id  NUMBER
777     , p_address_number  VARCHAR2
778     , p_planned_start_date  date
779     , p_planned_end_date  date
780     , p_scheduled_start_date  date
781     , p_scheduled_end_date  date
782     , p_actual_start_date  date
783     , p_actual_end_date  date
784     , p_timezone_id  NUMBER
785     , p_timezone_name  VARCHAR2
786     , p_source_object_type_code  VARCHAR2
787     , p_source_object_id  NUMBER
788     , p_source_object_name  VARCHAR2
789     , p_duration  NUMBER
790     , p_duration_uom  VARCHAR2
791     , p_planned_effort  NUMBER
792     , p_planned_effort_uom  VARCHAR2
793     , p_actual_effort  NUMBER
794     , p_actual_effort_uom  VARCHAR2
795     , p_percentage_complete  NUMBER
796     , p_reason_code  VARCHAR2
797     , p_private_flag  VARCHAR2
798     , p_publish_flag  VARCHAR2
799     , p_restrict_closure_flag  VARCHAR2
800     , p_multi_booked_flag  VARCHAR2
801     , p_milestone_flag  VARCHAR2
802     , p_holiday_flag  VARCHAR2
803     , p_billable_flag  VARCHAR2
804     , p_bound_mode_code  VARCHAR2
808     , p_notification_period  NUMBER
805     , p_soft_bound_flag  VARCHAR2
806     , p_workflow_process_id  NUMBER
807     , p_notification_flag  VARCHAR2
809     , p_notification_period_uom  VARCHAR2
810     , p_parent_task_number  VARCHAR2
811     , p_parent_task_id  NUMBER
812     , p_alarm_start  NUMBER
813     , p_alarm_start_uom  VARCHAR2
814     , p_alarm_on  VARCHAR2
815     , p_alarm_count  NUMBER
816     , p_alarm_interval  NUMBER
817     , p_alarm_interval_uom  VARCHAR2
818     , p_palm_flag  VARCHAR2
819     , p_wince_flag  VARCHAR2
820     , p_laptop_flag  VARCHAR2
821     , p_device1_flag  VARCHAR2
822     , p_device2_flag  VARCHAR2
823     , p_device3_flag  VARCHAR2
824     , p_costs  NUMBER
825     , p_currency_code  VARCHAR2
826     , p_escalation_level  VARCHAR2
827     , p73_a0 JTF_VARCHAR2_TABLE_100
828     , p73_a1 JTF_NUMBER_TABLE
829     , p73_a2 JTF_DATE_TABLE
830     , p73_a3 JTF_DATE_TABLE
831     , p73_a4 JTF_NUMBER_TABLE
832     , p73_a5 JTF_VARCHAR2_TABLE_100
833     , p73_a6 JTF_NUMBER_TABLE
834     , p73_a7 JTF_NUMBER_TABLE
835     , p73_a8 JTF_VARCHAR2_TABLE_100
836     , p73_a9 JTF_NUMBER_TABLE
837     , p73_a10 JTF_NUMBER_TABLE
838     , p73_a11 JTF_VARCHAR2_TABLE_100
839     , p73_a12 JTF_VARCHAR2_TABLE_100
840     , p73_a13 JTF_VARCHAR2_TABLE_100
841     , p73_a14 JTF_VARCHAR2_TABLE_200
842     , p73_a15 JTF_VARCHAR2_TABLE_100
843     , p73_a16 JTF_VARCHAR2_TABLE_100
844     , p73_a17 JTF_VARCHAR2_TABLE_100
845     , p73_a18 JTF_VARCHAR2_TABLE_100
846     , p73_a19 JTF_VARCHAR2_TABLE_100
847     , p73_a20 JTF_VARCHAR2_TABLE_100
848     , p73_a21 JTF_NUMBER_TABLE
849     , p73_a22 JTF_NUMBER_TABLE
850     , p73_a23 JTF_NUMBER_TABLE
851     , p73_a24 JTF_VARCHAR2_TABLE_100
852     , p73_a25 JTF_NUMBER_TABLE
853     , p74_a0 JTF_NUMBER_TABLE
854     , p74_a1 JTF_NUMBER_TABLE
855     , p74_a2 JTF_VARCHAR2_TABLE_100
856     , p74_a3 JTF_NUMBER_TABLE
857     , p74_a4 JTF_VARCHAR2_TABLE_100
858     , p74_a5 JTF_VARCHAR2_TABLE_100
859     , p75_a0 JTF_VARCHAR2_TABLE_100
860     , p75_a1 JTF_NUMBER_TABLE
861     , p75_a2 JTF_VARCHAR2_TABLE_100
862     , p76_a0 JTF_VARCHAR2_TABLE_100
863     , p76_a1 JTF_VARCHAR2_TABLE_100
864     , p76_a2 JTF_VARCHAR2_TABLE_100
865     , p76_a3 JTF_NUMBER_TABLE
866     , p76_a4 JTF_VARCHAR2_TABLE_2000
867     , p76_a5 JTF_VARCHAR2_TABLE_100
868     , p76_a6 JTF_VARCHAR2_TABLE_2000
869     , p77_a0 JTF_NUMBER_TABLE
870     , p77_a1 JTF_VARCHAR2_TABLE_100
871     , p77_a2 JTF_VARCHAR2_TABLE_100
872     , p77_a3 JTF_DATE_TABLE
873     , p78_a0 JTF_NUMBER_TABLE
874     , p78_a1 JTF_NUMBER_TABLE
875     , p78_a2 JTF_VARCHAR2_TABLE_4000
876     , p78_a3 JTF_VARCHAR2_TABLE_32767
877     , p78_a4 JTF_VARCHAR2_TABLE_100
878     , p78_a5 JTF_NUMBER_TABLE
879     , p78_a6 JTF_DATE_TABLE
880     , p78_a7 JTF_VARCHAR2_TABLE_100
881     , p78_a8 JTF_NUMBER_TABLE
882     , p78_a9 JTF_VARCHAR2_TABLE_200
883     , p78_a10 JTF_VARCHAR2_TABLE_200
884     , p78_a11 JTF_VARCHAR2_TABLE_200
885     , p78_a12 JTF_VARCHAR2_TABLE_200
886     , p78_a13 JTF_VARCHAR2_TABLE_200
887     , p78_a14 JTF_VARCHAR2_TABLE_200
888     , p78_a15 JTF_VARCHAR2_TABLE_200
889     , p78_a16 JTF_VARCHAR2_TABLE_200
890     , p78_a17 JTF_VARCHAR2_TABLE_200
891     , p78_a18 JTF_VARCHAR2_TABLE_200
892     , p78_a19 JTF_VARCHAR2_TABLE_200
893     , p78_a20 JTF_VARCHAR2_TABLE_200
894     , p78_a21 JTF_VARCHAR2_TABLE_200
895     , p78_a22 JTF_VARCHAR2_TABLE_200
896     , p78_a23 JTF_VARCHAR2_TABLE_200
897     , p78_a24 JTF_VARCHAR2_TABLE_100
898     , p79_a0  NUMBER
899     , p79_a1  NUMBER
900     , p79_a2  NUMBER
901     , p79_a3  NUMBER
902     , p79_a4  VARCHAR2
903     , p79_a5  NUMBER
904     , p79_a6  NUMBER
905     , p79_a7  DATE
906     , p79_a8  DATE
907     , p80_a0 JTF_NUMBER_TABLE
908     , p80_a1 JTF_VARCHAR2_TABLE_100
909     , p80_a2 JTF_VARCHAR2_TABLE_100
910     , p80_a3 JTF_VARCHAR2_TABLE_100
911     , x_return_status out nocopy  VARCHAR2
912     , x_msg_count out nocopy  NUMBER
913     , x_msg_data out nocopy  VARCHAR2
914     , x_task_id out nocopy  NUMBER
915     , p_attribute1  VARCHAR2
916     , p_attribute2  VARCHAR2
917     , p_attribute3  VARCHAR2
918     , p_attribute4  VARCHAR2
919     , p_attribute5  VARCHAR2
920     , p_attribute6  VARCHAR2
921     , p_attribute7  VARCHAR2
922     , p_attribute8  VARCHAR2
923     , p_attribute9  VARCHAR2
924     , p_attribute10  VARCHAR2
925     , p_attribute11  VARCHAR2
926     , p_attribute12  VARCHAR2
927     , p_attribute13  VARCHAR2
928     , p_attribute14  VARCHAR2
929     , p_attribute15  VARCHAR2
930     , p_attribute_category  VARCHAR2
931     , p_date_selected  VARCHAR2
932     , p_category_id  NUMBER
933     , p_show_on_calendar  VARCHAR2
934     , p_owner_status_id  NUMBER
935     , p_template_id  NUMBER
936     , p_template_group_id  NUMBER
937   );
938   procedure update_task(p_api_version  NUMBER
939     , p_init_msg_list  VARCHAR2
940     , p_commit  VARCHAR2
941     , p_object_version_number in out nocopy  NUMBER
942     , p_task_id  NUMBER
943     , p_task_number  VARCHAR2
944     , p_task_name  VARCHAR2
945     , p_task_type_name  VARCHAR2
946     , p_task_type_id  NUMBER
947     , p_description  VARCHAR2
948     , p_task_status_name  VARCHAR2
949     , p_task_status_id  NUMBER
950     , p_task_priority_name  VARCHAR2
951     , p_task_priority_id  NUMBER
952     , p_owner_type_name  VARCHAR2
953     , p_owner_type_code  VARCHAR2
954     , p_owner_id  NUMBER
955     , p_owner_territory_id  NUMBER
956     , p_assigned_by_name  VARCHAR2
957     , p_assigned_by_id  NUMBER
961     , p_cust_account_id  NUMBER
958     , p_customer_number  VARCHAR2
959     , p_customer_id  NUMBER
960     , p_cust_account_number  VARCHAR2
962     , p_address_id  NUMBER
963     , p_address_number  VARCHAR2
964     , p_planned_start_date  date
965     , p_planned_end_date  date
966     , p_scheduled_start_date  date
967     , p_scheduled_end_date  date
968     , p_actual_start_date  date
969     , p_actual_end_date  date
970     , p_timezone_id  NUMBER
971     , p_timezone_name  VARCHAR2
972     , p_source_object_type_code  VARCHAR2
973     , p_source_object_id  NUMBER
974     , p_source_object_name  VARCHAR2
975     , p_duration  NUMBER
976     , p_duration_uom  VARCHAR2
977     , p_planned_effort  NUMBER
978     , p_planned_effort_uom  VARCHAR2
979     , p_actual_effort  NUMBER
980     , p_actual_effort_uom  VARCHAR2
981     , p_percentage_complete  NUMBER
982     , p_reason_code  VARCHAR2
983     , p_private_flag  VARCHAR2
984     , p_publish_flag  VARCHAR2
985     , p_restrict_closure_flag  VARCHAR2
986     , p_multi_booked_flag  VARCHAR2
987     , p_milestone_flag  VARCHAR2
988     , p_holiday_flag  VARCHAR2
989     , p_billable_flag  VARCHAR2
990     , p_bound_mode_code  VARCHAR2
991     , p_soft_bound_flag  VARCHAR2
992     , p_workflow_process_id  NUMBER
993     , p_notification_flag  VARCHAR2
994     , p_notification_period  NUMBER
995     , p_notification_period_uom  VARCHAR2
996     , p_alarm_start  NUMBER
997     , p_alarm_start_uom  VARCHAR2
998     , p_alarm_on  VARCHAR2
999     , p_alarm_count  NUMBER
1000     , p_alarm_fired_count  NUMBER
1001     , p_alarm_interval  NUMBER
1002     , p_alarm_interval_uom  VARCHAR2
1003     , p_palm_flag  VARCHAR2
1004     , p_wince_flag  VARCHAR2
1005     , p_laptop_flag  VARCHAR2
1006     , p_device1_flag  VARCHAR2
1007     , p_device2_flag  VARCHAR2
1008     , p_device3_flag  VARCHAR2
1009     , p_costs  NUMBER
1010     , p_currency_code  VARCHAR2
1011     , p_escalation_level  VARCHAR2
1012     , x_return_status out nocopy  VARCHAR2
1013     , x_msg_count out nocopy  NUMBER
1014     , x_msg_data out nocopy  VARCHAR2
1015     , p_attribute1  VARCHAR2
1016     , p_attribute2  VARCHAR2
1017     , p_attribute3  VARCHAR2
1018     , p_attribute4  VARCHAR2
1019     , p_attribute5  VARCHAR2
1020     , p_attribute6  VARCHAR2
1021     , p_attribute7  VARCHAR2
1022     , p_attribute8  VARCHAR2
1023     , p_attribute9  VARCHAR2
1024     , p_attribute10  VARCHAR2
1025     , p_attribute11  VARCHAR2
1026     , p_attribute12  VARCHAR2
1027     , p_attribute13  VARCHAR2
1028     , p_attribute14  VARCHAR2
1029     , p_attribute15  VARCHAR2
1030     , p_attribute_category  VARCHAR2
1031     , p_date_selected  VARCHAR2
1032     , p_category_id  NUMBER
1033     , p_show_on_calendar  VARCHAR2
1034     , p_owner_status_id  NUMBER
1035     , p_parent_task_id  NUMBER
1036     , p_parent_task_number  VARCHAR2
1037     , p_enable_workflow  VARCHAR2
1038     , p_abort_workflow  VARCHAR2
1039     , p_task_split_flag  VARCHAR2
1040     , p_child_position  VARCHAR2
1041     , p_child_sequence_num  NUMBER
1042     , p_location_id  NUMBER
1043   );
1044   procedure update_task(p_api_version  NUMBER
1045     , p_init_msg_list  VARCHAR2
1046     , p_commit  VARCHAR2
1047     , p_object_version_number in out nocopy  NUMBER
1048     , p_task_id  NUMBER
1049     , p_task_number  VARCHAR2
1050     , p_task_name  VARCHAR2
1051     , p_task_type_name  VARCHAR2
1052     , p_task_type_id  NUMBER
1053     , p_description  VARCHAR2
1054     , p_task_status_name  VARCHAR2
1055     , p_task_status_id  NUMBER
1056     , p_task_priority_name  VARCHAR2
1057     , p_task_priority_id  NUMBER
1058     , p_owner_type_name  VARCHAR2
1059     , p_owner_type_code  VARCHAR2
1060     , p_owner_id  NUMBER
1061     , p_owner_territory_id  NUMBER
1062     , p_assigned_by_name  VARCHAR2
1063     , p_assigned_by_id  NUMBER
1064     , p_customer_number  VARCHAR2
1065     , p_customer_id  NUMBER
1066     , p_cust_account_number  VARCHAR2
1067     , p_cust_account_id  NUMBER
1068     , p_address_id  NUMBER
1069     , p_address_number  VARCHAR2
1070     , p_planned_start_date  date
1071     , p_planned_end_date  date
1072     , p_scheduled_start_date  date
1073     , p_scheduled_end_date  date
1074     , p_actual_start_date  date
1075     , p_actual_end_date  date
1076     , p_timezone_id  NUMBER
1077     , p_timezone_name  VARCHAR2
1078     , p_source_object_type_code  VARCHAR2
1079     , p_source_object_id  NUMBER
1080     , p_source_object_name  VARCHAR2
1081     , p_duration  NUMBER
1082     , p_duration_uom  VARCHAR2
1083     , p_planned_effort  NUMBER
1084     , p_planned_effort_uom  VARCHAR2
1085     , p_actual_effort  NUMBER
1086     , p_actual_effort_uom  VARCHAR2
1087     , p_percentage_complete  NUMBER
1088     , p_reason_code  VARCHAR2
1089     , p_private_flag  VARCHAR2
1090     , p_publish_flag  VARCHAR2
1091     , p_restrict_closure_flag  VARCHAR2
1092     , p_multi_booked_flag  VARCHAR2
1093     , p_milestone_flag  VARCHAR2
1094     , p_holiday_flag  VARCHAR2
1095     , p_billable_flag  VARCHAR2
1096     , p_bound_mode_code  VARCHAR2
1097     , p_soft_bound_flag  VARCHAR2
1098     , p_workflow_process_id  NUMBER
1099     , p_notification_flag  VARCHAR2
1100     , p_notification_period  NUMBER
1101     , p_notification_period_uom  VARCHAR2
1102     , p_alarm_start  NUMBER
1103     , p_alarm_start_uom  VARCHAR2
1104     , p_alarm_on  VARCHAR2
1105     , p_alarm_count  NUMBER
1106     , p_alarm_fired_count  NUMBER
1107     , p_alarm_interval  NUMBER
1108     , p_alarm_interval_uom  VARCHAR2
1109     , p_palm_flag  VARCHAR2
1110     , p_wince_flag  VARCHAR2
1114     , p_device3_flag  VARCHAR2
1111     , p_laptop_flag  VARCHAR2
1112     , p_device1_flag  VARCHAR2
1113     , p_device2_flag  VARCHAR2
1115     , p_costs  NUMBER
1116     , p_currency_code  VARCHAR2
1117     , p_escalation_level  VARCHAR2
1118     , x_return_status out nocopy  VARCHAR2
1119     , x_msg_count out nocopy  NUMBER
1120     , x_msg_data out nocopy  VARCHAR2
1121     , p_attribute1  VARCHAR2
1122     , p_attribute2  VARCHAR2
1123     , p_attribute3  VARCHAR2
1124     , p_attribute4  VARCHAR2
1125     , p_attribute5  VARCHAR2
1126     , p_attribute6  VARCHAR2
1127     , p_attribute7  VARCHAR2
1128     , p_attribute8  VARCHAR2
1129     , p_attribute9  VARCHAR2
1130     , p_attribute10  VARCHAR2
1131     , p_attribute11  VARCHAR2
1132     , p_attribute12  VARCHAR2
1133     , p_attribute13  VARCHAR2
1134     , p_attribute14  VARCHAR2
1135     , p_attribute15  VARCHAR2
1136     , p_attribute_category  VARCHAR2
1137     , p_date_selected  VARCHAR2
1138     , p_category_id  NUMBER
1139     , p_show_on_calendar  VARCHAR2
1140     , p_owner_status_id  NUMBER
1141     , p_parent_task_id  NUMBER
1142     , p_parent_task_number  VARCHAR2
1143     , p_enable_workflow  VARCHAR2
1144     , p_abort_workflow  VARCHAR2
1145     , p_task_split_flag  VARCHAR2
1146     , p_child_position  VARCHAR2
1147     , p_child_sequence_num  NUMBER
1148   );
1149   procedure update_task(p_api_version  NUMBER
1150     , p_init_msg_list  VARCHAR2
1151     , p_commit  VARCHAR2
1152     , p_object_version_number in out nocopy  NUMBER
1153     , p_task_id  NUMBER
1154     , p_task_number  VARCHAR2
1155     , p_task_name  VARCHAR2
1156     , p_task_type_name  VARCHAR2
1157     , p_task_type_id  NUMBER
1158     , p_description  VARCHAR2
1159     , p_task_status_name  VARCHAR2
1160     , p_task_status_id  NUMBER
1161     , p_task_priority_name  VARCHAR2
1162     , p_task_priority_id  NUMBER
1163     , p_owner_type_name  VARCHAR2
1164     , p_owner_type_code  VARCHAR2
1165     , p_owner_id  NUMBER
1166     , p_owner_territory_id  NUMBER
1167     , p_assigned_by_name  VARCHAR2
1168     , p_assigned_by_id  NUMBER
1169     , p_customer_number  VARCHAR2
1170     , p_customer_id  NUMBER
1171     , p_cust_account_number  VARCHAR2
1172     , p_cust_account_id  NUMBER
1173     , p_address_id  NUMBER
1174     , p_address_number  VARCHAR2
1175     , p_planned_start_date  date
1176     , p_planned_end_date  date
1177     , p_scheduled_start_date  date
1178     , p_scheduled_end_date  date
1179     , p_actual_start_date  date
1180     , p_actual_end_date  date
1181     , p_timezone_id  NUMBER
1182     , p_timezone_name  VARCHAR2
1183     , p_source_object_type_code  VARCHAR2
1184     , p_source_object_id  NUMBER
1185     , p_source_object_name  VARCHAR2
1186     , p_duration  NUMBER
1187     , p_duration_uom  VARCHAR2
1188     , p_planned_effort  NUMBER
1189     , p_planned_effort_uom  VARCHAR2
1190     , p_actual_effort  NUMBER
1191     , p_actual_effort_uom  VARCHAR2
1192     , p_percentage_complete  NUMBER
1193     , p_reason_code  VARCHAR2
1194     , p_private_flag  VARCHAR2
1195     , p_publish_flag  VARCHAR2
1196     , p_restrict_closure_flag  VARCHAR2
1197     , p_multi_booked_flag  VARCHAR2
1198     , p_milestone_flag  VARCHAR2
1199     , p_holiday_flag  VARCHAR2
1200     , p_billable_flag  VARCHAR2
1201     , p_bound_mode_code  VARCHAR2
1202     , p_soft_bound_flag  VARCHAR2
1203     , p_workflow_process_id  NUMBER
1204     , p_notification_flag  VARCHAR2
1205     , p_notification_period  NUMBER
1206     , p_notification_period_uom  VARCHAR2
1207     , p_alarm_start  NUMBER
1208     , p_alarm_start_uom  VARCHAR2
1209     , p_alarm_on  VARCHAR2
1210     , p_alarm_count  NUMBER
1211     , p_alarm_fired_count  NUMBER
1212     , p_alarm_interval  NUMBER
1213     , p_alarm_interval_uom  VARCHAR2
1214     , p_palm_flag  VARCHAR2
1215     , p_wince_flag  VARCHAR2
1216     , p_laptop_flag  VARCHAR2
1217     , p_device1_flag  VARCHAR2
1218     , p_device2_flag  VARCHAR2
1219     , p_device3_flag  VARCHAR2
1220     , p_costs  NUMBER
1221     , p_currency_code  VARCHAR2
1222     , p_escalation_level  VARCHAR2
1223     , x_return_status out nocopy  VARCHAR2
1224     , x_msg_count out nocopy  NUMBER
1225     , x_msg_data out nocopy  VARCHAR2
1226     , p_attribute1  VARCHAR2
1227     , p_attribute2  VARCHAR2
1228     , p_attribute3  VARCHAR2
1229     , p_attribute4  VARCHAR2
1230     , p_attribute5  VARCHAR2
1231     , p_attribute6  VARCHAR2
1232     , p_attribute7  VARCHAR2
1233     , p_attribute8  VARCHAR2
1234     , p_attribute9  VARCHAR2
1235     , p_attribute10  VARCHAR2
1236     , p_attribute11  VARCHAR2
1237     , p_attribute12  VARCHAR2
1238     , p_attribute13  VARCHAR2
1239     , p_attribute14  VARCHAR2
1240     , p_attribute15  VARCHAR2
1241     , p_attribute_category  VARCHAR2
1242     , p_date_selected  VARCHAR2
1243     , p_category_id  NUMBER
1244     , p_show_on_calendar  VARCHAR2
1245     , p_owner_status_id  NUMBER
1246     , p_parent_task_id  NUMBER
1247     , p_parent_task_number  VARCHAR2
1248     , p_enable_workflow  VARCHAR2
1249     , p_abort_workflow  VARCHAR2
1250   );
1251   procedure update_task(p_api_version  NUMBER
1252     , p_init_msg_list  VARCHAR2
1253     , p_commit  VARCHAR2
1254     , p_object_version_number in out nocopy  NUMBER
1255     , p_task_id  NUMBER
1256     , p_task_number  VARCHAR2
1257     , p_task_name  VARCHAR2
1258     , p_task_type_name  VARCHAR2
1259     , p_task_type_id  NUMBER
1260     , p_description  VARCHAR2
1261     , p_task_status_name  VARCHAR2
1262     , p_task_status_id  NUMBER
1263     , p_task_priority_name  VARCHAR2
1264     , p_task_priority_id  NUMBER
1265     , p_owner_type_name  VARCHAR2
1266     , p_owner_type_code  VARCHAR2
1267     , p_owner_id  NUMBER
1268     , p_owner_territory_id  NUMBER
1269     , p_assigned_by_name  VARCHAR2
1270     , p_assigned_by_id  NUMBER
1271     , p_customer_number  VARCHAR2
1272     , p_customer_id  NUMBER
1273     , p_cust_account_number  VARCHAR2
1274     , p_cust_account_id  NUMBER
1275     , p_address_id  NUMBER
1276     , p_address_number  VARCHAR2
1277     , p_planned_start_date  date
1278     , p_planned_end_date  date
1279     , p_scheduled_start_date  date
1280     , p_scheduled_end_date  date
1281     , p_actual_start_date  date
1282     , p_actual_end_date  date
1283     , p_timezone_id  NUMBER
1284     , p_timezone_name  VARCHAR2
1285     , p_source_object_type_code  VARCHAR2
1286     , p_source_object_id  NUMBER
1287     , p_source_object_name  VARCHAR2
1288     , p_duration  NUMBER
1289     , p_duration_uom  VARCHAR2
1290     , p_planned_effort  NUMBER
1291     , p_planned_effort_uom  VARCHAR2
1292     , p_actual_effort  NUMBER
1293     , p_actual_effort_uom  VARCHAR2
1294     , p_percentage_complete  NUMBER
1295     , p_reason_code  VARCHAR2
1296     , p_private_flag  VARCHAR2
1297     , p_publish_flag  VARCHAR2
1298     , p_restrict_closure_flag  VARCHAR2
1299     , p_multi_booked_flag  VARCHAR2
1300     , p_milestone_flag  VARCHAR2
1301     , p_holiday_flag  VARCHAR2
1302     , p_billable_flag  VARCHAR2
1303     , p_bound_mode_code  VARCHAR2
1304     , p_soft_bound_flag  VARCHAR2
1305     , p_workflow_process_id  NUMBER
1306     , p_notification_flag  VARCHAR2
1307     , p_notification_period  NUMBER
1308     , p_notification_period_uom  VARCHAR2
1309     , p_alarm_start  NUMBER
1310     , p_alarm_start_uom  VARCHAR2
1311     , p_alarm_on  VARCHAR2
1312     , p_alarm_count  NUMBER
1313     , p_alarm_fired_count  NUMBER
1314     , p_alarm_interval  NUMBER
1315     , p_alarm_interval_uom  VARCHAR2
1316     , p_palm_flag  VARCHAR2
1317     , p_wince_flag  VARCHAR2
1318     , p_laptop_flag  VARCHAR2
1319     , p_device1_flag  VARCHAR2
1320     , p_device2_flag  VARCHAR2
1321     , p_device3_flag  VARCHAR2
1322     , p_costs  NUMBER
1323     , p_currency_code  VARCHAR2
1324     , p_escalation_level  VARCHAR2
1325     , x_return_status out nocopy  VARCHAR2
1326     , x_msg_count out nocopy  NUMBER
1327     , x_msg_data out nocopy  VARCHAR2
1328     , p_attribute1  VARCHAR2
1329     , p_attribute2  VARCHAR2
1330     , p_attribute3  VARCHAR2
1331     , p_attribute4  VARCHAR2
1332     , p_attribute5  VARCHAR2
1333     , p_attribute6  VARCHAR2
1334     , p_attribute7  VARCHAR2
1335     , p_attribute8  VARCHAR2
1336     , p_attribute9  VARCHAR2
1337     , p_attribute10  VARCHAR2
1338     , p_attribute11  VARCHAR2
1339     , p_attribute12  VARCHAR2
1340     , p_attribute13  VARCHAR2
1341     , p_attribute14  VARCHAR2
1342     , p_attribute15  VARCHAR2
1343     , p_attribute_category  VARCHAR2
1344     , p_date_selected  VARCHAR2
1345     , p_category_id  NUMBER
1346     , p_show_on_calendar  VARCHAR2
1347     , p_owner_status_id  NUMBER
1348     , p_parent_task_id  NUMBER
1349     , p_parent_task_number  VARCHAR2
1350   );
1351   procedure export_query_task(p_api_version  NUMBER
1352     , p_init_msg_list  VARCHAR2
1353     , p_validate_level  VARCHAR2
1354     , p_file_name  VARCHAR2
1355     , p_task_number  VARCHAR2
1356     , p_task_id  NUMBER
1357     , p_task_name  VARCHAR2
1358     , p_description  VARCHAR2
1359     , p_task_type_name  VARCHAR2
1360     , p_task_type_id  NUMBER
1361     , p_task_status_name  VARCHAR2
1362     , p_task_status_id  NUMBER
1363     , p_task_priority_name  VARCHAR2
1364     , p_task_priority_id  NUMBER
1365     , p_owner_type_code  VARCHAR2
1366     , p_owner_id  NUMBER
1367     , p_assigned_name  VARCHAR2
1368     , p_assigned_by_id  NUMBER
1369     , p_address_id  NUMBER
1370     , p_owner_territory_id  NUMBER
1371     , p_customer_id  NUMBER
1372     , p_customer_name  VARCHAR2
1373     , p_customer_number  VARCHAR2
1374     , p_cust_account_number  VARCHAR2
1375     , p_cust_account_id  NUMBER
1376     , p_planned_start_date  date
1377     , p_planned_end_date  date
1378     , p_scheduled_start_date  date
1379     , p_scheduled_end_date  date
1380     , p_actual_start_date  date
1381     , p_actual_end_date  date
1382     , p_object_type_code  VARCHAR2
1383     , p_object_name  VARCHAR2
1384     , p_source_object_id  NUMBER
1385     , p_percentage_complete  NUMBER
1386     , p_reason_code  VARCHAR2
1387     , p_private_flag  VARCHAR2
1388     , p_restrict_closure_flag  VARCHAR2
1389     , p_multi_booked_flag  VARCHAR2
1390     , p_milestone_flag  VARCHAR2
1391     , p_holiday_flag  VARCHAR2
1392     , p_workflow_process_id  NUMBER
1393     , p_notification_flag  VARCHAR2
1394     , p_parent_task_id  NUMBER
1395     , p_alarm_on  VARCHAR2
1396     , p_alarm_count  NUMBER
1397     , p_alarm_fired_count  NUMBER
1398     , p_ref_object_id  NUMBER
1399     , p_ref_object_type_code  VARCHAR2
1400     , p49_a0 JTF_VARCHAR2_TABLE_100
1401     , p49_a1 JTF_VARCHAR2_TABLE_100
1402     , p_start_pointer  NUMBER
1403     , p_rec_wanted  NUMBER
1404     , p_show_all  VARCHAR2
1405     , p_query_or_next_code  VARCHAR2
1406     , p54_a0 out nocopy JTF_NUMBER_TABLE
1407     , p54_a1 out nocopy JTF_VARCHAR2_TABLE_100
1408     , p54_a2 out nocopy JTF_VARCHAR2_TABLE_100
1409     , p54_a3 out nocopy JTF_VARCHAR2_TABLE_4000
1410     , p54_a4 out nocopy JTF_NUMBER_TABLE
1411     , p54_a5 out nocopy JTF_VARCHAR2_TABLE_100
1412     , p54_a6 out nocopy JTF_NUMBER_TABLE
1413     , p54_a7 out nocopy JTF_VARCHAR2_TABLE_100
1414     , p54_a8 out nocopy JTF_NUMBER_TABLE
1415     , p54_a9 out nocopy JTF_VARCHAR2_TABLE_100
1416     , p54_a10 out nocopy JTF_VARCHAR2_TABLE_100
1417     , p54_a11 out nocopy JTF_NUMBER_TABLE
1418     , p54_a12 out nocopy JTF_VARCHAR2_TABLE_4000
1419     , p54_a13 out nocopy JTF_NUMBER_TABLE
1420     , p54_a14 out nocopy JTF_VARCHAR2_TABLE_4000
1421     , p54_a15 out nocopy JTF_NUMBER_TABLE
1422     , p54_a16 out nocopy JTF_VARCHAR2_TABLE_400
1423     , p54_a17 out nocopy JTF_VARCHAR2_TABLE_100
1424     , p54_a18 out nocopy JTF_VARCHAR2_TABLE_100
1425     , p54_a19 out nocopy JTF_NUMBER_TABLE
1426     , p54_a20 out nocopy JTF_NUMBER_TABLE
1427     , p54_a21 out nocopy JTF_DATE_TABLE
1428     , p54_a22 out nocopy JTF_DATE_TABLE
1429     , p54_a23 out nocopy JTF_DATE_TABLE
1430     , p54_a24 out nocopy JTF_DATE_TABLE
1431     , p54_a25 out nocopy JTF_DATE_TABLE
1432     , p54_a26 out nocopy JTF_DATE_TABLE
1433     , p54_a27 out nocopy JTF_VARCHAR2_TABLE_100
1434     , p54_a28 out nocopy JTF_NUMBER_TABLE
1435     , p54_a29 out nocopy JTF_VARCHAR2_TABLE_100
1436     , p54_a30 out nocopy JTF_NUMBER_TABLE
1437     , p54_a31 out nocopy JTF_VARCHAR2_TABLE_100
1438     , p54_a32 out nocopy JTF_NUMBER_TABLE
1439     , p54_a33 out nocopy JTF_VARCHAR2_TABLE_100
1440     , p54_a34 out nocopy JTF_NUMBER_TABLE
1441     , p54_a35 out nocopy JTF_VARCHAR2_TABLE_100
1442     , p54_a36 out nocopy JTF_NUMBER_TABLE
1443     , p54_a37 out nocopy JTF_VARCHAR2_TABLE_100
1444     , p54_a38 out nocopy JTF_VARCHAR2_TABLE_100
1445     , p54_a39 out nocopy JTF_VARCHAR2_TABLE_100
1446     , p54_a40 out nocopy JTF_VARCHAR2_TABLE_100
1447     , p54_a41 out nocopy JTF_VARCHAR2_TABLE_100
1448     , p54_a42 out nocopy JTF_VARCHAR2_TABLE_100
1449     , p54_a43 out nocopy JTF_NUMBER_TABLE
1450     , p54_a44 out nocopy JTF_VARCHAR2_TABLE_100
1451     , p54_a45 out nocopy JTF_NUMBER_TABLE
1452     , p54_a46 out nocopy JTF_VARCHAR2_TABLE_100
1453     , p54_a47 out nocopy JTF_NUMBER_TABLE
1454     , p54_a48 out nocopy JTF_NUMBER_TABLE
1455     , p54_a49 out nocopy JTF_VARCHAR2_TABLE_100
1456     , p54_a50 out nocopy JTF_VARCHAR2_TABLE_100
1457     , p54_a51 out nocopy JTF_NUMBER_TABLE
1458     , p54_a52 out nocopy JTF_NUMBER_TABLE
1459     , p54_a53 out nocopy JTF_NUMBER_TABLE
1460     , p54_a54 out nocopy JTF_VARCHAR2_TABLE_100
1461     , p54_a55 out nocopy JTF_VARCHAR2_TABLE_200
1462     , p54_a56 out nocopy JTF_VARCHAR2_TABLE_200
1463     , p54_a57 out nocopy JTF_VARCHAR2_TABLE_200
1464     , p54_a58 out nocopy JTF_VARCHAR2_TABLE_200
1465     , p54_a59 out nocopy JTF_VARCHAR2_TABLE_200
1466     , p54_a60 out nocopy JTF_VARCHAR2_TABLE_200
1467     , p54_a61 out nocopy JTF_VARCHAR2_TABLE_200
1468     , p54_a62 out nocopy JTF_VARCHAR2_TABLE_200
1469     , p54_a63 out nocopy JTF_VARCHAR2_TABLE_200
1470     , p54_a64 out nocopy JTF_VARCHAR2_TABLE_200
1471     , p54_a65 out nocopy JTF_VARCHAR2_TABLE_200
1472     , p54_a66 out nocopy JTF_VARCHAR2_TABLE_200
1473     , p54_a67 out nocopy JTF_VARCHAR2_TABLE_200
1474     , p54_a68 out nocopy JTF_VARCHAR2_TABLE_200
1475     , p54_a69 out nocopy JTF_VARCHAR2_TABLE_200
1476     , p54_a70 out nocopy JTF_VARCHAR2_TABLE_200
1477     , p54_a71 out nocopy JTF_NUMBER_TABLE
1478     , p54_a72 out nocopy JTF_DATE_TABLE
1479     , p54_a73 out nocopy JTF_VARCHAR2_TABLE_4000
1480     , p54_a74 out nocopy JTF_NUMBER_TABLE
1481     , p54_a75 out nocopy JTF_DATE_TABLE
1482     , p54_a76 out nocopy JTF_DATE_TABLE
1483     , p54_a77 out nocopy JTF_VARCHAR2_TABLE_100
1484     , p54_a78 out nocopy JTF_VARCHAR2_TABLE_100
1485     , p54_a79 out nocopy JTF_VARCHAR2_TABLE_100
1486     , p54_a80 out nocopy JTF_NUMBER_TABLE
1487     , p54_a81 out nocopy JTF_NUMBER_TABLE
1488     , x_total_retrieved out nocopy  NUMBER
1489     , x_total_returned out nocopy  NUMBER
1490     , x_return_status out nocopy  VARCHAR2
1491     , x_msg_count out nocopy  NUMBER
1492     , x_msg_data out nocopy  VARCHAR2
1493     , x_object_version_number in out nocopy  NUMBER
1494     , p_location_id  NUMBER
1495   );
1496   procedure export_query_task(p_api_version  NUMBER
1497     , p_init_msg_list  VARCHAR2
1498     , p_validate_level  VARCHAR2
1499     , p_file_name  VARCHAR2
1500     , p_task_number  VARCHAR2
1501     , p_task_id  NUMBER
1502     , p_task_name  VARCHAR2
1503     , p_description  VARCHAR2
1504     , p_task_type_name  VARCHAR2
1505     , p_task_type_id  NUMBER
1506     , p_task_status_name  VARCHAR2
1507     , p_task_status_id  NUMBER
1508     , p_task_priority_name  VARCHAR2
1509     , p_task_priority_id  NUMBER
1510     , p_owner_type_code  VARCHAR2
1511     , p_owner_id  NUMBER
1512     , p_assigned_name  VARCHAR2
1513     , p_assigned_by_id  NUMBER
1514     , p_address_id  NUMBER
1515     , p_owner_territory_id  NUMBER
1516     , p_customer_id  NUMBER
1517     , p_customer_name  VARCHAR2
1518     , p_customer_number  VARCHAR2
1519     , p_cust_account_number  VARCHAR2
1520     , p_cust_account_id  NUMBER
1521     , p_planned_start_date  date
1522     , p_planned_end_date  date
1523     , p_scheduled_start_date  date
1524     , p_scheduled_end_date  date
1525     , p_actual_start_date  date
1526     , p_actual_end_date  date
1527     , p_object_type_code  VARCHAR2
1528     , p_object_name  VARCHAR2
1529     , p_source_object_id  NUMBER
1530     , p_percentage_complete  NUMBER
1531     , p_reason_code  VARCHAR2
1532     , p_private_flag  VARCHAR2
1533     , p_restrict_closure_flag  VARCHAR2
1534     , p_multi_booked_flag  VARCHAR2
1535     , p_milestone_flag  VARCHAR2
1536     , p_holiday_flag  VARCHAR2
1537     , p_workflow_process_id  NUMBER
1538     , p_notification_flag  VARCHAR2
1539     , p_parent_task_id  NUMBER
1540     , p_alarm_on  VARCHAR2
1541     , p_alarm_count  NUMBER
1542     , p_alarm_fired_count  NUMBER
1543     , p_ref_object_id  NUMBER
1544     , p_ref_object_type_code  VARCHAR2
1545     , p49_a0 JTF_VARCHAR2_TABLE_100
1546     , p49_a1 JTF_VARCHAR2_TABLE_100
1547     , p_start_pointer  NUMBER
1548     , p_rec_wanted  NUMBER
1549     , p_show_all  VARCHAR2
1550     , p_query_or_next_code  VARCHAR2
1551     , p54_a0 out nocopy JTF_NUMBER_TABLE
1552     , p54_a1 out nocopy JTF_VARCHAR2_TABLE_100
1553     , p54_a2 out nocopy JTF_VARCHAR2_TABLE_100
1554     , p54_a3 out nocopy JTF_VARCHAR2_TABLE_4000
1555     , p54_a4 out nocopy JTF_NUMBER_TABLE
1556     , p54_a5 out nocopy JTF_VARCHAR2_TABLE_100
1557     , p54_a6 out nocopy JTF_NUMBER_TABLE
1558     , p54_a7 out nocopy JTF_VARCHAR2_TABLE_100
1559     , p54_a8 out nocopy JTF_NUMBER_TABLE
1560     , p54_a9 out nocopy JTF_VARCHAR2_TABLE_100
1561     , p54_a10 out nocopy JTF_VARCHAR2_TABLE_100
1562     , p54_a11 out nocopy JTF_NUMBER_TABLE
1563     , p54_a12 out nocopy JTF_VARCHAR2_TABLE_4000
1564     , p54_a13 out nocopy JTF_NUMBER_TABLE
1565     , p54_a14 out nocopy JTF_VARCHAR2_TABLE_4000
1566     , p54_a15 out nocopy JTF_NUMBER_TABLE
1567     , p54_a16 out nocopy JTF_VARCHAR2_TABLE_400
1568     , p54_a17 out nocopy JTF_VARCHAR2_TABLE_100
1569     , p54_a18 out nocopy JTF_VARCHAR2_TABLE_100
1570     , p54_a19 out nocopy JTF_NUMBER_TABLE
1571     , p54_a20 out nocopy JTF_NUMBER_TABLE
1572     , p54_a21 out nocopy JTF_DATE_TABLE
1573     , p54_a22 out nocopy JTF_DATE_TABLE
1574     , p54_a23 out nocopy JTF_DATE_TABLE
1575     , p54_a24 out nocopy JTF_DATE_TABLE
1576     , p54_a25 out nocopy JTF_DATE_TABLE
1577     , p54_a26 out nocopy JTF_DATE_TABLE
1578     , p54_a27 out nocopy JTF_VARCHAR2_TABLE_100
1579     , p54_a28 out nocopy JTF_NUMBER_TABLE
1580     , p54_a29 out nocopy JTF_VARCHAR2_TABLE_100
1581     , p54_a30 out nocopy JTF_NUMBER_TABLE
1582     , p54_a31 out nocopy JTF_VARCHAR2_TABLE_100
1583     , p54_a32 out nocopy JTF_NUMBER_TABLE
1584     , p54_a33 out nocopy JTF_VARCHAR2_TABLE_100
1585     , p54_a34 out nocopy JTF_NUMBER_TABLE
1586     , p54_a35 out nocopy JTF_VARCHAR2_TABLE_100
1587     , p54_a36 out nocopy JTF_NUMBER_TABLE
1588     , p54_a37 out nocopy JTF_VARCHAR2_TABLE_100
1589     , p54_a38 out nocopy JTF_VARCHAR2_TABLE_100
1590     , p54_a39 out nocopy JTF_VARCHAR2_TABLE_100
1591     , p54_a40 out nocopy JTF_VARCHAR2_TABLE_100
1592     , p54_a41 out nocopy JTF_VARCHAR2_TABLE_100
1593     , p54_a42 out nocopy JTF_VARCHAR2_TABLE_100
1594     , p54_a43 out nocopy JTF_NUMBER_TABLE
1595     , p54_a44 out nocopy JTF_VARCHAR2_TABLE_100
1596     , p54_a45 out nocopy JTF_NUMBER_TABLE
1597     , p54_a46 out nocopy JTF_VARCHAR2_TABLE_100
1598     , p54_a47 out nocopy JTF_NUMBER_TABLE
1599     , p54_a48 out nocopy JTF_NUMBER_TABLE
1600     , p54_a49 out nocopy JTF_VARCHAR2_TABLE_100
1601     , p54_a50 out nocopy JTF_VARCHAR2_TABLE_100
1602     , p54_a51 out nocopy JTF_NUMBER_TABLE
1603     , p54_a52 out nocopy JTF_NUMBER_TABLE
1604     , p54_a53 out nocopy JTF_NUMBER_TABLE
1605     , p54_a54 out nocopy JTF_VARCHAR2_TABLE_100
1606     , p54_a55 out nocopy JTF_VARCHAR2_TABLE_200
1607     , p54_a56 out nocopy JTF_VARCHAR2_TABLE_200
1608     , p54_a57 out nocopy JTF_VARCHAR2_TABLE_200
1609     , p54_a58 out nocopy JTF_VARCHAR2_TABLE_200
1610     , p54_a59 out nocopy JTF_VARCHAR2_TABLE_200
1611     , p54_a60 out nocopy JTF_VARCHAR2_TABLE_200
1612     , p54_a61 out nocopy JTF_VARCHAR2_TABLE_200
1613     , p54_a62 out nocopy JTF_VARCHAR2_TABLE_200
1614     , p54_a63 out nocopy JTF_VARCHAR2_TABLE_200
1615     , p54_a64 out nocopy JTF_VARCHAR2_TABLE_200
1616     , p54_a65 out nocopy JTF_VARCHAR2_TABLE_200
1617     , p54_a66 out nocopy JTF_VARCHAR2_TABLE_200
1618     , p54_a67 out nocopy JTF_VARCHAR2_TABLE_200
1619     , p54_a68 out nocopy JTF_VARCHAR2_TABLE_200
1620     , p54_a69 out nocopy JTF_VARCHAR2_TABLE_200
1621     , p54_a70 out nocopy JTF_VARCHAR2_TABLE_200
1622     , p54_a71 out nocopy JTF_NUMBER_TABLE
1623     , p54_a72 out nocopy JTF_DATE_TABLE
1624     , p54_a73 out nocopy JTF_VARCHAR2_TABLE_4000
1625     , p54_a74 out nocopy JTF_NUMBER_TABLE
1626     , p54_a75 out nocopy JTF_DATE_TABLE
1627     , p54_a76 out nocopy JTF_DATE_TABLE
1628     , p54_a77 out nocopy JTF_VARCHAR2_TABLE_100
1629     , p54_a78 out nocopy JTF_VARCHAR2_TABLE_100
1630     , p54_a79 out nocopy JTF_VARCHAR2_TABLE_100
1631     , p54_a80 out nocopy JTF_NUMBER_TABLE
1632     , p54_a81 out nocopy JTF_NUMBER_TABLE
1633     , x_total_retrieved out nocopy  NUMBER
1634     , x_total_returned out nocopy  NUMBER
1635     , x_return_status out nocopy  VARCHAR2
1636     , x_msg_count out nocopy  NUMBER
1637     , x_msg_data out nocopy  VARCHAR2
1638     , x_object_version_number in out nocopy  NUMBER
1639   );
1640   procedure query_task(p_api_version  NUMBER
1641     , p_init_msg_list  VARCHAR2
1642     , p_validate_level  VARCHAR2
1643     , p_task_number  VARCHAR2
1644     , p_task_id  NUMBER
1645     , p_task_name  VARCHAR2
1646     , p_description  VARCHAR2
1647     , p_task_type_name  VARCHAR2
1648     , p_task_type_id  NUMBER
1649     , p_task_status_name  VARCHAR2
1650     , p_task_status_id  NUMBER
1651     , p_task_priority_name  VARCHAR2
1652     , p_task_priority_id  NUMBER
1653     , p_owner_type_code  VARCHAR2
1654     , p_owner_id  NUMBER
1655     , p_assigned_name  VARCHAR2
1656     , p_assigned_by_id  NUMBER
1657     , p_address_id  NUMBER
1658     , p_owner_territory_id  NUMBER
1659     , p_customer_id  NUMBER
1660     , p_customer_name  VARCHAR2
1661     , p_customer_number  VARCHAR2
1662     , p_cust_account_number  VARCHAR2
1663     , p_cust_account_id  NUMBER
1664     , p_planned_start_date  date
1665     , p_planned_end_date  date
1666     , p_scheduled_start_date  date
1667     , p_scheduled_end_date  date
1668     , p_actual_start_date  date
1669     , p_actual_end_date  date
1670     , p_object_type_code  VARCHAR2
1671     , p_object_name  VARCHAR2
1672     , p_source_object_id  NUMBER
1673     , p_percentage_complete  NUMBER
1674     , p_reason_code  VARCHAR2
1675     , p_private_flag  VARCHAR2
1676     , p_restrict_closure_flag  VARCHAR2
1677     , p_multi_booked_flag  VARCHAR2
1678     , p_milestone_flag  VARCHAR2
1679     , p_holiday_flag  VARCHAR2
1680     , p_workflow_process_id  NUMBER
1681     , p_notification_flag  VARCHAR2
1682     , p_parent_task_id  NUMBER
1683     , p_alarm_on  VARCHAR2
1684     , p_alarm_count  NUMBER
1685     , p_alarm_fired_count  NUMBER
1686     , p_ref_object_id  NUMBER
1687     , p_ref_object_type_code  VARCHAR2
1688     , p48_a0 JTF_VARCHAR2_TABLE_100
1689     , p48_a1 JTF_VARCHAR2_TABLE_100
1690     , p_start_pointer  NUMBER
1691     , p_rec_wanted  NUMBER
1692     , p_show_all  VARCHAR2
1693     , p_query_or_next_code  VARCHAR2
1694     , p53_a0 out nocopy JTF_NUMBER_TABLE
1695     , p53_a1 out nocopy JTF_VARCHAR2_TABLE_100
1696     , p53_a2 out nocopy JTF_VARCHAR2_TABLE_100
1697     , p53_a3 out nocopy JTF_VARCHAR2_TABLE_4000
1698     , p53_a4 out nocopy JTF_NUMBER_TABLE
1699     , p53_a5 out nocopy JTF_VARCHAR2_TABLE_100
1700     , p53_a6 out nocopy JTF_NUMBER_TABLE
1701     , p53_a7 out nocopy JTF_VARCHAR2_TABLE_100
1702     , p53_a8 out nocopy JTF_NUMBER_TABLE
1703     , p53_a9 out nocopy JTF_VARCHAR2_TABLE_100
1704     , p53_a10 out nocopy JTF_VARCHAR2_TABLE_100
1705     , p53_a11 out nocopy JTF_NUMBER_TABLE
1706     , p53_a12 out nocopy JTF_VARCHAR2_TABLE_4000
1707     , p53_a13 out nocopy JTF_NUMBER_TABLE
1708     , p53_a14 out nocopy JTF_VARCHAR2_TABLE_4000
1709     , p53_a15 out nocopy JTF_NUMBER_TABLE
1710     , p53_a16 out nocopy JTF_VARCHAR2_TABLE_400
1711     , p53_a17 out nocopy JTF_VARCHAR2_TABLE_100
1712     , p53_a18 out nocopy JTF_VARCHAR2_TABLE_100
1713     , p53_a19 out nocopy JTF_NUMBER_TABLE
1714     , p53_a20 out nocopy JTF_NUMBER_TABLE
1715     , p53_a21 out nocopy JTF_DATE_TABLE
1716     , p53_a22 out nocopy JTF_DATE_TABLE
1717     , p53_a23 out nocopy JTF_DATE_TABLE
1718     , p53_a24 out nocopy JTF_DATE_TABLE
1719     , p53_a25 out nocopy JTF_DATE_TABLE
1720     , p53_a26 out nocopy JTF_DATE_TABLE
1721     , p53_a27 out nocopy JTF_VARCHAR2_TABLE_100
1722     , p53_a28 out nocopy JTF_NUMBER_TABLE
1723     , p53_a29 out nocopy JTF_VARCHAR2_TABLE_100
1724     , p53_a30 out nocopy JTF_NUMBER_TABLE
1725     , p53_a31 out nocopy JTF_VARCHAR2_TABLE_100
1726     , p53_a32 out nocopy JTF_NUMBER_TABLE
1727     , p53_a33 out nocopy JTF_VARCHAR2_TABLE_100
1728     , p53_a34 out nocopy JTF_NUMBER_TABLE
1729     , p53_a35 out nocopy JTF_VARCHAR2_TABLE_100
1730     , p53_a36 out nocopy JTF_NUMBER_TABLE
1731     , p53_a37 out nocopy JTF_VARCHAR2_TABLE_100
1732     , p53_a38 out nocopy JTF_VARCHAR2_TABLE_100
1736     , p53_a42 out nocopy JTF_VARCHAR2_TABLE_100
1733     , p53_a39 out nocopy JTF_VARCHAR2_TABLE_100
1734     , p53_a40 out nocopy JTF_VARCHAR2_TABLE_100
1735     , p53_a41 out nocopy JTF_VARCHAR2_TABLE_100
1737     , p53_a43 out nocopy JTF_NUMBER_TABLE
1738     , p53_a44 out nocopy JTF_VARCHAR2_TABLE_100
1739     , p53_a45 out nocopy JTF_NUMBER_TABLE
1740     , p53_a46 out nocopy JTF_VARCHAR2_TABLE_100
1741     , p53_a47 out nocopy JTF_NUMBER_TABLE
1742     , p53_a48 out nocopy JTF_NUMBER_TABLE
1743     , p53_a49 out nocopy JTF_VARCHAR2_TABLE_100
1744     , p53_a50 out nocopy JTF_VARCHAR2_TABLE_100
1745     , p53_a51 out nocopy JTF_NUMBER_TABLE
1746     , p53_a52 out nocopy JTF_NUMBER_TABLE
1747     , p53_a53 out nocopy JTF_NUMBER_TABLE
1748     , p53_a54 out nocopy JTF_VARCHAR2_TABLE_100
1749     , p53_a55 out nocopy JTF_VARCHAR2_TABLE_200
1750     , p53_a56 out nocopy JTF_VARCHAR2_TABLE_200
1751     , p53_a57 out nocopy JTF_VARCHAR2_TABLE_200
1752     , p53_a58 out nocopy JTF_VARCHAR2_TABLE_200
1753     , p53_a59 out nocopy JTF_VARCHAR2_TABLE_200
1754     , p53_a60 out nocopy JTF_VARCHAR2_TABLE_200
1755     , p53_a61 out nocopy JTF_VARCHAR2_TABLE_200
1756     , p53_a62 out nocopy JTF_VARCHAR2_TABLE_200
1757     , p53_a63 out nocopy JTF_VARCHAR2_TABLE_200
1758     , p53_a64 out nocopy JTF_VARCHAR2_TABLE_200
1759     , p53_a65 out nocopy JTF_VARCHAR2_TABLE_200
1760     , p53_a66 out nocopy JTF_VARCHAR2_TABLE_200
1761     , p53_a67 out nocopy JTF_VARCHAR2_TABLE_200
1762     , p53_a68 out nocopy JTF_VARCHAR2_TABLE_200
1763     , p53_a69 out nocopy JTF_VARCHAR2_TABLE_200
1764     , p53_a70 out nocopy JTF_VARCHAR2_TABLE_200
1765     , p53_a71 out nocopy JTF_NUMBER_TABLE
1766     , p53_a72 out nocopy JTF_DATE_TABLE
1767     , p53_a73 out nocopy JTF_VARCHAR2_TABLE_4000
1768     , p53_a74 out nocopy JTF_NUMBER_TABLE
1769     , p53_a75 out nocopy JTF_DATE_TABLE
1770     , p53_a76 out nocopy JTF_DATE_TABLE
1771     , p53_a77 out nocopy JTF_VARCHAR2_TABLE_100
1772     , p53_a78 out nocopy JTF_VARCHAR2_TABLE_100
1773     , p53_a79 out nocopy JTF_VARCHAR2_TABLE_100
1774     , p53_a80 out nocopy JTF_NUMBER_TABLE
1775     , p53_a81 out nocopy JTF_NUMBER_TABLE
1776     , x_total_retrieved out nocopy  NUMBER
1777     , x_total_returned out nocopy  NUMBER
1778     , x_return_status out nocopy  VARCHAR2
1779     , x_msg_count out nocopy  NUMBER
1780     , x_msg_data out nocopy  VARCHAR2
1781     , x_object_version_number in out nocopy  NUMBER
1782     , p_location_id  NUMBER
1783   );
1784   procedure query_task(p_api_version  NUMBER
1785     , p_init_msg_list  VARCHAR2
1786     , p_validate_level  VARCHAR2
1787     , p_task_number  VARCHAR2
1788     , p_task_id  NUMBER
1789     , p_task_name  VARCHAR2
1790     , p_description  VARCHAR2
1791     , p_task_type_name  VARCHAR2
1792     , p_task_type_id  NUMBER
1793     , p_task_status_name  VARCHAR2
1794     , p_task_status_id  NUMBER
1795     , p_task_priority_name  VARCHAR2
1796     , p_task_priority_id  NUMBER
1797     , p_owner_type_code  VARCHAR2
1798     , p_owner_id  NUMBER
1799     , p_assigned_name  VARCHAR2
1800     , p_assigned_by_id  NUMBER
1801     , p_address_id  NUMBER
1802     , p_owner_territory_id  NUMBER
1803     , p_customer_id  NUMBER
1804     , p_customer_name  VARCHAR2
1805     , p_customer_number  VARCHAR2
1806     , p_cust_account_number  VARCHAR2
1807     , p_cust_account_id  NUMBER
1808     , p_planned_start_date  date
1809     , p_planned_end_date  date
1810     , p_scheduled_start_date  date
1811     , p_scheduled_end_date  date
1812     , p_actual_start_date  date
1813     , p_actual_end_date  date
1814     , p_object_type_code  VARCHAR2
1815     , p_object_name  VARCHAR2
1816     , p_source_object_id  NUMBER
1817     , p_percentage_complete  NUMBER
1818     , p_reason_code  VARCHAR2
1819     , p_private_flag  VARCHAR2
1820     , p_restrict_closure_flag  VARCHAR2
1821     , p_multi_booked_flag  VARCHAR2
1822     , p_milestone_flag  VARCHAR2
1823     , p_holiday_flag  VARCHAR2
1824     , p_workflow_process_id  NUMBER
1825     , p_notification_flag  VARCHAR2
1826     , p_parent_task_id  NUMBER
1827     , p_alarm_on  VARCHAR2
1828     , p_alarm_count  NUMBER
1829     , p_alarm_fired_count  NUMBER
1830     , p_ref_object_id  NUMBER
1831     , p_ref_object_type_code  VARCHAR2
1832     , p48_a0 JTF_VARCHAR2_TABLE_100
1833     , p48_a1 JTF_VARCHAR2_TABLE_100
1834     , p_start_pointer  NUMBER
1835     , p_rec_wanted  NUMBER
1836     , p_show_all  VARCHAR2
1837     , p_query_or_next_code  VARCHAR2
1838     , p53_a0 out nocopy JTF_NUMBER_TABLE
1839     , p53_a1 out nocopy JTF_VARCHAR2_TABLE_100
1840     , p53_a2 out nocopy JTF_VARCHAR2_TABLE_100
1841     , p53_a3 out nocopy JTF_VARCHAR2_TABLE_4000
1842     , p53_a4 out nocopy JTF_NUMBER_TABLE
1843     , p53_a5 out nocopy JTF_VARCHAR2_TABLE_100
1844     , p53_a6 out nocopy JTF_NUMBER_TABLE
1845     , p53_a7 out nocopy JTF_VARCHAR2_TABLE_100
1846     , p53_a8 out nocopy JTF_NUMBER_TABLE
1847     , p53_a9 out nocopy JTF_VARCHAR2_TABLE_100
1848     , p53_a10 out nocopy JTF_VARCHAR2_TABLE_100
1849     , p53_a11 out nocopy JTF_NUMBER_TABLE
1850     , p53_a12 out nocopy JTF_VARCHAR2_TABLE_4000
1851     , p53_a13 out nocopy JTF_NUMBER_TABLE
1852     , p53_a14 out nocopy JTF_VARCHAR2_TABLE_4000
1853     , p53_a15 out nocopy JTF_NUMBER_TABLE
1854     , p53_a16 out nocopy JTF_VARCHAR2_TABLE_400
1855     , p53_a17 out nocopy JTF_VARCHAR2_TABLE_100
1856     , p53_a18 out nocopy JTF_VARCHAR2_TABLE_100
1857     , p53_a19 out nocopy JTF_NUMBER_TABLE
1858     , p53_a20 out nocopy JTF_NUMBER_TABLE
1859     , p53_a21 out nocopy JTF_DATE_TABLE
1860     , p53_a22 out nocopy JTF_DATE_TABLE
1861     , p53_a23 out nocopy JTF_DATE_TABLE
1862     , p53_a24 out nocopy JTF_DATE_TABLE
1863     , p53_a25 out nocopy JTF_DATE_TABLE
1864     , p53_a26 out nocopy JTF_DATE_TABLE
1865     , p53_a27 out nocopy JTF_VARCHAR2_TABLE_100
1866     , p53_a28 out nocopy JTF_NUMBER_TABLE
1867     , p53_a29 out nocopy JTF_VARCHAR2_TABLE_100
1868     , p53_a30 out nocopy JTF_NUMBER_TABLE
1869     , p53_a31 out nocopy JTF_VARCHAR2_TABLE_100
1870     , p53_a32 out nocopy JTF_NUMBER_TABLE
1871     , p53_a33 out nocopy JTF_VARCHAR2_TABLE_100
1872     , p53_a34 out nocopy JTF_NUMBER_TABLE
1873     , p53_a35 out nocopy JTF_VARCHAR2_TABLE_100
1874     , p53_a36 out nocopy JTF_NUMBER_TABLE
1875     , p53_a37 out nocopy JTF_VARCHAR2_TABLE_100
1876     , p53_a38 out nocopy JTF_VARCHAR2_TABLE_100
1877     , p53_a39 out nocopy JTF_VARCHAR2_TABLE_100
1878     , p53_a40 out nocopy JTF_VARCHAR2_TABLE_100
1879     , p53_a41 out nocopy JTF_VARCHAR2_TABLE_100
1880     , p53_a42 out nocopy JTF_VARCHAR2_TABLE_100
1881     , p53_a43 out nocopy JTF_NUMBER_TABLE
1882     , p53_a44 out nocopy JTF_VARCHAR2_TABLE_100
1883     , p53_a45 out nocopy JTF_NUMBER_TABLE
1884     , p53_a46 out nocopy JTF_VARCHAR2_TABLE_100
1885     , p53_a47 out nocopy JTF_NUMBER_TABLE
1886     , p53_a48 out nocopy JTF_NUMBER_TABLE
1887     , p53_a49 out nocopy JTF_VARCHAR2_TABLE_100
1888     , p53_a50 out nocopy JTF_VARCHAR2_TABLE_100
1889     , p53_a51 out nocopy JTF_NUMBER_TABLE
1890     , p53_a52 out nocopy JTF_NUMBER_TABLE
1891     , p53_a53 out nocopy JTF_NUMBER_TABLE
1892     , p53_a54 out nocopy JTF_VARCHAR2_TABLE_100
1893     , p53_a55 out nocopy JTF_VARCHAR2_TABLE_200
1894     , p53_a56 out nocopy JTF_VARCHAR2_TABLE_200
1895     , p53_a57 out nocopy JTF_VARCHAR2_TABLE_200
1896     , p53_a58 out nocopy JTF_VARCHAR2_TABLE_200
1897     , p53_a59 out nocopy JTF_VARCHAR2_TABLE_200
1898     , p53_a60 out nocopy JTF_VARCHAR2_TABLE_200
1899     , p53_a61 out nocopy JTF_VARCHAR2_TABLE_200
1900     , p53_a62 out nocopy JTF_VARCHAR2_TABLE_200
1901     , p53_a63 out nocopy JTF_VARCHAR2_TABLE_200
1902     , p53_a64 out nocopy JTF_VARCHAR2_TABLE_200
1903     , p53_a65 out nocopy JTF_VARCHAR2_TABLE_200
1904     , p53_a66 out nocopy JTF_VARCHAR2_TABLE_200
1905     , p53_a67 out nocopy JTF_VARCHAR2_TABLE_200
1906     , p53_a68 out nocopy JTF_VARCHAR2_TABLE_200
1907     , p53_a69 out nocopy JTF_VARCHAR2_TABLE_200
1908     , p53_a70 out nocopy JTF_VARCHAR2_TABLE_200
1909     , p53_a71 out nocopy JTF_NUMBER_TABLE
1910     , p53_a72 out nocopy JTF_DATE_TABLE
1911     , p53_a73 out nocopy JTF_VARCHAR2_TABLE_4000
1912     , p53_a74 out nocopy JTF_NUMBER_TABLE
1913     , p53_a75 out nocopy JTF_DATE_TABLE
1914     , p53_a76 out nocopy JTF_DATE_TABLE
1915     , p53_a77 out nocopy JTF_VARCHAR2_TABLE_100
1916     , p53_a78 out nocopy JTF_VARCHAR2_TABLE_100
1917     , p53_a79 out nocopy JTF_VARCHAR2_TABLE_100
1918     , p53_a80 out nocopy JTF_NUMBER_TABLE
1919     , p53_a81 out nocopy JTF_NUMBER_TABLE
1920     , x_total_retrieved out nocopy  NUMBER
1921     , x_total_returned out nocopy  NUMBER
1922     , x_return_status out nocopy  VARCHAR2
1923     , x_msg_count out nocopy  NUMBER
1924     , x_msg_data out nocopy  VARCHAR2
1925     , x_object_version_number in out nocopy  NUMBER
1926   );
1927   procedure query_next_task(p_api_version  NUMBER
1928     , p_init_msg_list  VARCHAR2
1929     , p_validate_level  VARCHAR2
1930     , p_task_id  NUMBER
1931     , p_query_type  VARCHAR2
1932     , p_date_type  VARCHAR2
1933     , p_date_start_or_end  VARCHAR2
1934     , p_owner_id  NUMBER
1935     , p_owner_type_code  VARCHAR2
1936     , p_assigned_by  NUMBER
1937     , p10_a0 JTF_VARCHAR2_TABLE_100
1938     , p10_a1 JTF_VARCHAR2_TABLE_100
1939     , p_start_pointer  NUMBER
1940     , p_rec_wanted  NUMBER
1941     , p_show_all  VARCHAR2
1942     , p_query_or_next_code  VARCHAR2
1943     , p15_a0 out nocopy JTF_NUMBER_TABLE
1944     , p15_a1 out nocopy JTF_VARCHAR2_TABLE_100
1945     , p15_a2 out nocopy JTF_VARCHAR2_TABLE_100
1946     , p15_a3 out nocopy JTF_VARCHAR2_TABLE_4000
1947     , p15_a4 out nocopy JTF_NUMBER_TABLE
1948     , p15_a5 out nocopy JTF_VARCHAR2_TABLE_100
1949     , p15_a6 out nocopy JTF_NUMBER_TABLE
1950     , p15_a7 out nocopy JTF_VARCHAR2_TABLE_100
1951     , p15_a8 out nocopy JTF_NUMBER_TABLE
1952     , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100
1953     , p15_a10 out nocopy JTF_VARCHAR2_TABLE_100
1954     , p15_a11 out nocopy JTF_NUMBER_TABLE
1955     , p15_a12 out nocopy JTF_VARCHAR2_TABLE_4000
1956     , p15_a13 out nocopy JTF_NUMBER_TABLE
1957     , p15_a14 out nocopy JTF_VARCHAR2_TABLE_4000
1958     , p15_a15 out nocopy JTF_NUMBER_TABLE
1959     , p15_a16 out nocopy JTF_VARCHAR2_TABLE_400
1960     , p15_a17 out nocopy JTF_VARCHAR2_TABLE_100
1961     , p15_a18 out nocopy JTF_VARCHAR2_TABLE_100
1962     , p15_a19 out nocopy JTF_NUMBER_TABLE
1963     , p15_a20 out nocopy JTF_NUMBER_TABLE
1964     , p15_a21 out nocopy JTF_DATE_TABLE
1965     , p15_a22 out nocopy JTF_DATE_TABLE
1966     , p15_a23 out nocopy JTF_DATE_TABLE
1967     , p15_a24 out nocopy JTF_DATE_TABLE
1968     , p15_a25 out nocopy JTF_DATE_TABLE
1969     , p15_a26 out nocopy JTF_DATE_TABLE
1970     , p15_a27 out nocopy JTF_VARCHAR2_TABLE_100
1971     , p15_a28 out nocopy JTF_NUMBER_TABLE
1972     , p15_a29 out nocopy JTF_VARCHAR2_TABLE_100
1973     , p15_a30 out nocopy JTF_NUMBER_TABLE
1974     , p15_a31 out nocopy JTF_VARCHAR2_TABLE_100
1975     , p15_a32 out nocopy JTF_NUMBER_TABLE
1976     , p15_a33 out nocopy JTF_VARCHAR2_TABLE_100
1977     , p15_a34 out nocopy JTF_NUMBER_TABLE
1978     , p15_a35 out nocopy JTF_VARCHAR2_TABLE_100
1979     , p15_a36 out nocopy JTF_NUMBER_TABLE
1980     , p15_a37 out nocopy JTF_VARCHAR2_TABLE_100
1981     , p15_a38 out nocopy JTF_VARCHAR2_TABLE_100
1982     , p15_a39 out nocopy JTF_VARCHAR2_TABLE_100
1983     , p15_a40 out nocopy JTF_VARCHAR2_TABLE_100
1984     , p15_a41 out nocopy JTF_VARCHAR2_TABLE_100
1985     , p15_a42 out nocopy JTF_VARCHAR2_TABLE_100
1986     , p15_a43 out nocopy JTF_NUMBER_TABLE
1987     , p15_a44 out nocopy JTF_VARCHAR2_TABLE_100
1988     , p15_a45 out nocopy JTF_NUMBER_TABLE
1989     , p15_a46 out nocopy JTF_VARCHAR2_TABLE_100
1990     , p15_a47 out nocopy JTF_NUMBER_TABLE
1991     , p15_a48 out nocopy JTF_NUMBER_TABLE
1992     , p15_a49 out nocopy JTF_VARCHAR2_TABLE_100
1993     , p15_a50 out nocopy JTF_VARCHAR2_TABLE_100
1994     , p15_a51 out nocopy JTF_NUMBER_TABLE
1995     , p15_a52 out nocopy JTF_NUMBER_TABLE
1996     , p15_a53 out nocopy JTF_NUMBER_TABLE
1997     , p15_a54 out nocopy JTF_VARCHAR2_TABLE_100
1998     , p15_a55 out nocopy JTF_VARCHAR2_TABLE_200
1999     , p15_a56 out nocopy JTF_VARCHAR2_TABLE_200
2000     , p15_a57 out nocopy JTF_VARCHAR2_TABLE_200
2001     , p15_a58 out nocopy JTF_VARCHAR2_TABLE_200
2002     , p15_a59 out nocopy JTF_VARCHAR2_TABLE_200
2003     , p15_a60 out nocopy JTF_VARCHAR2_TABLE_200
2004     , p15_a61 out nocopy JTF_VARCHAR2_TABLE_200
2005     , p15_a62 out nocopy JTF_VARCHAR2_TABLE_200
2006     , p15_a63 out nocopy JTF_VARCHAR2_TABLE_200
2007     , p15_a64 out nocopy JTF_VARCHAR2_TABLE_200
2008     , p15_a65 out nocopy JTF_VARCHAR2_TABLE_200
2009     , p15_a66 out nocopy JTF_VARCHAR2_TABLE_200
2010     , p15_a67 out nocopy JTF_VARCHAR2_TABLE_200
2011     , p15_a68 out nocopy JTF_VARCHAR2_TABLE_200
2012     , p15_a69 out nocopy JTF_VARCHAR2_TABLE_200
2013     , p15_a70 out nocopy JTF_VARCHAR2_TABLE_200
2014     , p15_a71 out nocopy JTF_NUMBER_TABLE
2015     , p15_a72 out nocopy JTF_DATE_TABLE
2016     , p15_a73 out nocopy JTF_VARCHAR2_TABLE_4000
2017     , p15_a74 out nocopy JTF_NUMBER_TABLE
2018     , p15_a75 out nocopy JTF_DATE_TABLE
2019     , p15_a76 out nocopy JTF_DATE_TABLE
2020     , p15_a77 out nocopy JTF_VARCHAR2_TABLE_100
2021     , p15_a78 out nocopy JTF_VARCHAR2_TABLE_100
2022     , p15_a79 out nocopy JTF_VARCHAR2_TABLE_100
2023     , p15_a80 out nocopy JTF_NUMBER_TABLE
2024     , p15_a81 out nocopy JTF_NUMBER_TABLE
2025     , x_total_retrieved out nocopy  NUMBER
2026     , x_total_returned out nocopy  NUMBER
2027     , x_return_status out nocopy  VARCHAR2
2028     , x_msg_count out nocopy  NUMBER
2029     , x_msg_data out nocopy  VARCHAR2
2030     , x_object_version_number in out nocopy  NUMBER
2031   );
2032   procedure export_file(p_api_version  NUMBER
2033     , p_init_msg_list  VARCHAR2
2034     , p_validate_level  VARCHAR2
2035     , p_file_name  VARCHAR2
2036     , p4_a0 JTF_NUMBER_TABLE
2037     , p4_a1 JTF_VARCHAR2_TABLE_100
2038     , p4_a2 JTF_VARCHAR2_TABLE_100
2039     , p4_a3 JTF_VARCHAR2_TABLE_4000
2040     , p4_a4 JTF_NUMBER_TABLE
2041     , p4_a5 JTF_VARCHAR2_TABLE_100
2042     , p4_a6 JTF_NUMBER_TABLE
2043     , p4_a7 JTF_VARCHAR2_TABLE_100
2044     , p4_a8 JTF_NUMBER_TABLE
2045     , p4_a9 JTF_VARCHAR2_TABLE_100
2046     , p4_a10 JTF_VARCHAR2_TABLE_100
2047     , p4_a11 JTF_NUMBER_TABLE
2048     , p4_a12 JTF_VARCHAR2_TABLE_4000
2049     , p4_a13 JTF_NUMBER_TABLE
2050     , p4_a14 JTF_VARCHAR2_TABLE_4000
2051     , p4_a15 JTF_NUMBER_TABLE
2052     , p4_a16 JTF_VARCHAR2_TABLE_400
2053     , p4_a17 JTF_VARCHAR2_TABLE_100
2054     , p4_a18 JTF_VARCHAR2_TABLE_100
2055     , p4_a19 JTF_NUMBER_TABLE
2056     , p4_a20 JTF_NUMBER_TABLE
2057     , p4_a21 JTF_DATE_TABLE
2058     , p4_a22 JTF_DATE_TABLE
2059     , p4_a23 JTF_DATE_TABLE
2060     , p4_a24 JTF_DATE_TABLE
2061     , p4_a25 JTF_DATE_TABLE
2062     , p4_a26 JTF_DATE_TABLE
2063     , p4_a27 JTF_VARCHAR2_TABLE_100
2064     , p4_a28 JTF_NUMBER_TABLE
2065     , p4_a29 JTF_VARCHAR2_TABLE_100
2066     , p4_a30 JTF_NUMBER_TABLE
2067     , p4_a31 JTF_VARCHAR2_TABLE_100
2068     , p4_a32 JTF_NUMBER_TABLE
2069     , p4_a33 JTF_VARCHAR2_TABLE_100
2070     , p4_a34 JTF_NUMBER_TABLE
2071     , p4_a35 JTF_VARCHAR2_TABLE_100
2072     , p4_a36 JTF_NUMBER_TABLE
2073     , p4_a37 JTF_VARCHAR2_TABLE_100
2074     , p4_a38 JTF_VARCHAR2_TABLE_100
2075     , p4_a39 JTF_VARCHAR2_TABLE_100
2076     , p4_a40 JTF_VARCHAR2_TABLE_100
2077     , p4_a41 JTF_VARCHAR2_TABLE_100
2078     , p4_a42 JTF_VARCHAR2_TABLE_100
2079     , p4_a43 JTF_NUMBER_TABLE
2080     , p4_a44 JTF_VARCHAR2_TABLE_100
2081     , p4_a45 JTF_NUMBER_TABLE
2082     , p4_a46 JTF_VARCHAR2_TABLE_100
2083     , p4_a47 JTF_NUMBER_TABLE
2084     , p4_a48 JTF_NUMBER_TABLE
2085     , p4_a49 JTF_VARCHAR2_TABLE_100
2086     , p4_a50 JTF_VARCHAR2_TABLE_100
2087     , p4_a51 JTF_NUMBER_TABLE
2088     , p4_a52 JTF_NUMBER_TABLE
2089     , p4_a53 JTF_NUMBER_TABLE
2090     , p4_a54 JTF_VARCHAR2_TABLE_100
2091     , p4_a55 JTF_VARCHAR2_TABLE_200
2092     , p4_a56 JTF_VARCHAR2_TABLE_200
2093     , p4_a57 JTF_VARCHAR2_TABLE_200
2094     , p4_a58 JTF_VARCHAR2_TABLE_200
2095     , p4_a59 JTF_VARCHAR2_TABLE_200
2096     , p4_a60 JTF_VARCHAR2_TABLE_200
2097     , p4_a61 JTF_VARCHAR2_TABLE_200
2098     , p4_a62 JTF_VARCHAR2_TABLE_200
2099     , p4_a63 JTF_VARCHAR2_TABLE_200
2100     , p4_a64 JTF_VARCHAR2_TABLE_200
2101     , p4_a65 JTF_VARCHAR2_TABLE_200
2102     , p4_a66 JTF_VARCHAR2_TABLE_200
2103     , p4_a67 JTF_VARCHAR2_TABLE_200
2104     , p4_a68 JTF_VARCHAR2_TABLE_200
2105     , p4_a69 JTF_VARCHAR2_TABLE_200
2106     , p4_a70 JTF_VARCHAR2_TABLE_200
2107     , p4_a71 JTF_NUMBER_TABLE
2108     , p4_a72 JTF_DATE_TABLE
2109     , p4_a73 JTF_VARCHAR2_TABLE_4000
2110     , p4_a74 JTF_NUMBER_TABLE
2111     , p4_a75 JTF_DATE_TABLE
2112     , p4_a76 JTF_DATE_TABLE
2113     , p4_a77 JTF_VARCHAR2_TABLE_100
2114     , p4_a78 JTF_VARCHAR2_TABLE_100
2115     , p4_a79 JTF_VARCHAR2_TABLE_100
2116     , p4_a80 JTF_NUMBER_TABLE
2117     , p4_a81 JTF_NUMBER_TABLE
2118     , x_return_status out nocopy  VARCHAR2
2119     , x_msg_count out nocopy  NUMBER
2120     , x_msg_data out nocopy  VARCHAR2
2121     , x_object_version_number in out nocopy  NUMBER
2122   );
2123   procedure create_task_from_template(p_api_version  NUMBER
2124     , p_init_msg_list  VARCHAR2
2125     , p_commit  VARCHAR2
2126     , p_task_template_group_id  NUMBER
2127     , p_task_template_group_name  VARCHAR2
2128     , p_owner_type_code  VARCHAR2
2129     , p_owner_id  NUMBER
2130     , p_source_object_id  NUMBER
2131     , p_source_object_name  VARCHAR2
2132     , x_return_status out nocopy  VARCHAR2
2133     , x_msg_count out nocopy  NUMBER
2134     , x_msg_data out nocopy  VARCHAR2
2135     , p12_a0 out nocopy JTF_NUMBER_TABLE
2136     , p12_a1 out nocopy JTF_NUMBER_TABLE
2137     , p_assigned_by_id  NUMBER
2138     , p_cust_account_id  NUMBER
2139     , p_customer_id  NUMBER
2140     , p_address_id  NUMBER
2141     , p_actual_start_date  date
2142     , p_actual_end_date  date
2143     , p_planned_start_date  date
2144     , p_planned_end_date  date
2145     , p_scheduled_start_date  date
2146     , p_scheduled_end_date  date
2147     , p_palm_flag  VARCHAR2
2148     , p_wince_flag  VARCHAR2
2149     , p_laptop_flag  VARCHAR2
2150     , p_device1_flag  VARCHAR2
2151     , p_device2_flag  VARCHAR2
2152     , p_device3_flag  VARCHAR2
2153     , p_parent_task_id  NUMBER
2154     , p_percentage_complete  NUMBER
2155     , p_timezone_id  NUMBER
2156     , p_actual_effort  NUMBER
2157     , p_actual_effort_uom  VARCHAR2
2158     , p_reason_code  VARCHAR2
2159     , p_bound_mode_code  VARCHAR2
2160     , p_soft_bound_flag  VARCHAR2
2161     , p_workflow_process_id  NUMBER
2162     , p_owner_territory_id  NUMBER
2163     , p_costs  NUMBER
2164     , p_currency_code  VARCHAR2
2165     , p_attribute1  VARCHAR2
2166     , p_attribute2  VARCHAR2
2167     , p_attribute3  VARCHAR2
2168     , p_attribute4  VARCHAR2
2169     , p_attribute5  VARCHAR2
2170     , p_attribute6  VARCHAR2
2171     , p_attribute7  VARCHAR2
2172     , p_attribute8  VARCHAR2
2173     , p_attribute9  VARCHAR2
2174     , p_attribute10  VARCHAR2
2175     , p_attribute11  VARCHAR2
2176     , p_attribute12  VARCHAR2
2177     , p_attribute13  VARCHAR2
2178     , p_attribute14  VARCHAR2
2179     , p_attribute15  VARCHAR2
2180     , p_attribute_category  VARCHAR2
2181     , p_date_selected  VARCHAR2
2182     , p_location_id  NUMBER
2183   );
2184   procedure create_task_from_template(p_api_version  NUMBER
2185     , p_init_msg_list  VARCHAR2
2186     , p_commit  VARCHAR2
2187     , p_task_template_group_id  NUMBER
2188     , p_task_template_group_name  VARCHAR2
2189     , p_owner_type_code  VARCHAR2
2190     , p_owner_id  NUMBER
2191     , p_source_object_id  NUMBER
2192     , p_source_object_name  VARCHAR2
2193     , x_return_status out nocopy  VARCHAR2
2194     , x_msg_count out nocopy  NUMBER
2195     , x_msg_data out nocopy  VARCHAR2
2196     , p12_a0 out nocopy JTF_NUMBER_TABLE
2197     , p12_a1 out nocopy JTF_NUMBER_TABLE
2198     , p_assigned_by_id  NUMBER
2199     , p_cust_account_id  NUMBER
2200     , p_customer_id  NUMBER
2201     , p_address_id  NUMBER
2202     , p_actual_start_date  date
2203     , p_actual_end_date  date
2204     , p_planned_start_date  date
2205     , p_planned_end_date  date
2206     , p_scheduled_start_date  date
2207     , p_scheduled_end_date  date
2208     , p_palm_flag  VARCHAR2
2209     , p_wince_flag  VARCHAR2
2210     , p_laptop_flag  VARCHAR2
2211     , p_device1_flag  VARCHAR2
2212     , p_device2_flag  VARCHAR2
2213     , p_device3_flag  VARCHAR2
2214     , p_parent_task_id  NUMBER
2215     , p_percentage_complete  NUMBER
2216     , p_timezone_id  NUMBER
2217     , p_actual_effort  NUMBER
2218     , p_actual_effort_uom  VARCHAR2
2219     , p_reason_code  VARCHAR2
2220     , p_bound_mode_code  VARCHAR2
2221     , p_soft_bound_flag  VARCHAR2
2222     , p_workflow_process_id  NUMBER
2223     , p_owner_territory_id  NUMBER
2224     , p_costs  NUMBER
2225     , p_currency_code  VARCHAR2
2226     , p_attribute1  VARCHAR2
2227     , p_attribute2  VARCHAR2
2228     , p_attribute3  VARCHAR2
2229     , p_attribute4  VARCHAR2
2230     , p_attribute5  VARCHAR2
2231     , p_attribute6  VARCHAR2
2232     , p_attribute7  VARCHAR2
2233     , p_attribute8  VARCHAR2
2234     , p_attribute9  VARCHAR2
2235     , p_attribute10  VARCHAR2
2236     , p_attribute11  VARCHAR2
2237     , p_attribute12  VARCHAR2
2238     , p_attribute13  VARCHAR2
2239     , p_attribute14  VARCHAR2
2240     , p_attribute15  VARCHAR2
2241     , p_attribute_category  VARCHAR2
2242     , p_date_selected  VARCHAR2
2243   );
2244 end jtf_tasks_pub_w;