[Home] [Help]
PACKAGE: APPS.JTF_TASKS_PVT_W
Source
1 package jtf_tasks_pvt_w AUTHID CURRENT_USER as
2 /* $Header: jtfrtkts.pls 120.4 2006/04/26 04:38 knayyar ship $ */
3 procedure create_task(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , p_commit VARCHAR2
6 , p_task_id NUMBER
7 , p_task_name VARCHAR2
8 , p_task_type_id NUMBER
9 , p_description VARCHAR2
10 , p_task_status_id NUMBER
11 , p_task_priority_id NUMBER
12 , p_owner_type_code VARCHAR2
13 , p_owner_id NUMBER
14 , p_owner_territory_id NUMBER
15 , p_assigned_by_id NUMBER
16 , p_customer_id NUMBER
17 , p_cust_account_id NUMBER
18 , p_address_id NUMBER
19 , p_planned_start_date date
20 , p_planned_end_date date
21 , p_scheduled_start_date date
22 , p_scheduled_end_date date
23 , p_actual_start_date date
24 , p_actual_end_date date
25 , p_timezone_id NUMBER
26 , p_source_object_type_code VARCHAR2
27 , p_source_object_id NUMBER
28 , p_source_object_name VARCHAR2
29 , p_duration NUMBER
30 , p_duration_uom VARCHAR2
31 , p_planned_effort NUMBER
32 , p_planned_effort_uom VARCHAR2
33 , p_actual_effort NUMBER
34 , p_actual_effort_uom VARCHAR2
35 , p_percentage_complete NUMBER
36 , p_reason_code VARCHAR2
37 , p_private_flag VARCHAR2
38 , p_publish_flag VARCHAR2
39 , p_restrict_closure_flag VARCHAR2
40 , p_multi_booked_flag VARCHAR2
41 , p_milestone_flag VARCHAR2
42 , p_holiday_flag VARCHAR2
43 , p_billable_flag VARCHAR2
44 , p_bound_mode_code VARCHAR2
45 , p_soft_bound_flag VARCHAR2
46 , p_workflow_process_id NUMBER
47 , p_notification_flag VARCHAR2
48 , p_notification_period NUMBER
49 , p_notification_period_uom VARCHAR2
50 , p_parent_task_id NUMBER
51 , p_alarm_start NUMBER
52 , p_alarm_start_uom VARCHAR2
53 , p_alarm_on VARCHAR2
54 , p_alarm_count NUMBER
55 , p_alarm_interval NUMBER
56 , p_alarm_interval_uom VARCHAR2
57 , p_palm_flag VARCHAR2
58 , p_wince_flag VARCHAR2
59 , p_laptop_flag VARCHAR2
60 , p_device1_flag VARCHAR2
61 , p_device2_flag VARCHAR2
62 , p_device3_flag VARCHAR2
63 , p_costs NUMBER
64 , p_currency_code VARCHAR2
65 , p_escalation_level VARCHAR2
66 , x_return_status out nocopy VARCHAR2
67 , x_msg_count out nocopy NUMBER
68 , x_msg_data out nocopy VARCHAR2
69 , x_task_id out nocopy NUMBER
70 , p_attribute1 VARCHAR2
71 , p_attribute2 VARCHAR2
72 , p_attribute3 VARCHAR2
73 , p_attribute4 VARCHAR2
74 , p_attribute5 VARCHAR2
75 , p_attribute6 VARCHAR2
76 , p_attribute7 VARCHAR2
77 , p_attribute8 VARCHAR2
78 , p_attribute9 VARCHAR2
79 , p_attribute10 VARCHAR2
80 , p_attribute11 VARCHAR2
81 , p_attribute12 VARCHAR2
82 , p_attribute13 VARCHAR2
83 , p_attribute14 VARCHAR2
84 , p_attribute15 VARCHAR2
85 , p_attribute_category VARCHAR2
86 , p_date_selected VARCHAR2
87 , p_category_id NUMBER
88 , p_show_on_calendar VARCHAR2
89 , p_owner_status_id NUMBER
90 , p_template_id NUMBER
91 , p_template_group_id NUMBER
92 , p_enable_workflow VARCHAR2
93 , p_abort_workflow VARCHAR2
94 );
95 procedure create_task(p_api_version NUMBER
96 , p_init_msg_list VARCHAR2
97 , p_commit VARCHAR2
98 , p_task_id NUMBER
99 , p_task_name VARCHAR2
100 , p_task_type_id NUMBER
101 , p_description VARCHAR2
102 , p_task_status_id NUMBER
103 , p_task_priority_id NUMBER
104 , p_owner_type_code VARCHAR2
105 , p_owner_id NUMBER
106 , p_owner_territory_id NUMBER
107 , p_assigned_by_id NUMBER
108 , p_customer_id NUMBER
109 , p_cust_account_id NUMBER
110 , p_address_id NUMBER
111 , p_planned_start_date date
112 , p_planned_end_date date
113 , p_scheduled_start_date date
114 , p_scheduled_end_date date
115 , p_actual_start_date date
116 , p_actual_end_date date
117 , p_timezone_id NUMBER
118 , p_source_object_type_code VARCHAR2
119 , p_source_object_id NUMBER
120 , p_source_object_name VARCHAR2
121 , p_duration NUMBER
122 , p_duration_uom VARCHAR2
123 , p_planned_effort NUMBER
124 , p_planned_effort_uom VARCHAR2
125 , p_actual_effort NUMBER
126 , p_actual_effort_uom VARCHAR2
127 , p_percentage_complete NUMBER
128 , p_reason_code VARCHAR2
129 , p_private_flag VARCHAR2
130 , p_publish_flag VARCHAR2
131 , p_restrict_closure_flag VARCHAR2
132 , p_multi_booked_flag VARCHAR2
133 , p_milestone_flag VARCHAR2
134 , p_holiday_flag VARCHAR2
135 , p_billable_flag VARCHAR2
136 , p_bound_mode_code VARCHAR2
137 , p_soft_bound_flag VARCHAR2
138 , p_workflow_process_id NUMBER
139 , p_notification_flag VARCHAR2
140 , p_notification_period NUMBER
141 , p_notification_period_uom VARCHAR2
142 , p_parent_task_id NUMBER
143 , p_alarm_start NUMBER
144 , p_alarm_start_uom VARCHAR2
145 , p_alarm_on VARCHAR2
146 , p_alarm_count NUMBER
147 , p_alarm_interval NUMBER
148 , p_alarm_interval_uom VARCHAR2
149 , p_palm_flag VARCHAR2
150 , p_wince_flag VARCHAR2
151 , p_laptop_flag VARCHAR2
152 , p_device1_flag VARCHAR2
153 , p_device2_flag VARCHAR2
154 , p_device3_flag VARCHAR2
155 , p_costs NUMBER
156 , p_currency_code VARCHAR2
157 , p_escalation_level VARCHAR2
158 , x_return_status out nocopy VARCHAR2
159 , x_msg_count out nocopy NUMBER
160 , x_msg_data out nocopy VARCHAR2
161 , x_task_id out nocopy NUMBER
162 , p_attribute1 VARCHAR2
163 , p_attribute2 VARCHAR2
164 , p_attribute3 VARCHAR2
165 , p_attribute4 VARCHAR2
166 , p_attribute5 VARCHAR2
167 , p_attribute6 VARCHAR2
168 , p_attribute7 VARCHAR2
169 , p_attribute8 VARCHAR2
170 , p_attribute9 VARCHAR2
171 , p_attribute10 VARCHAR2
172 , p_attribute11 VARCHAR2
173 , p_attribute12 VARCHAR2
174 , p_attribute13 VARCHAR2
175 , p_attribute14 VARCHAR2
176 , p_attribute15 VARCHAR2
177 , p_attribute_category VARCHAR2
178 , p_date_selected VARCHAR2
179 , p_category_id NUMBER
180 , p_show_on_calendar VARCHAR2
181 , p_owner_status_id NUMBER
182 , p_template_id NUMBER
183 , p_template_group_id NUMBER
184 , p_enable_workflow VARCHAR2
185 , p_abort_workflow VARCHAR2
186 , p_entity VARCHAR2
187 , p_free_busy_type VARCHAR2
188 );
189 procedure create_task(p_api_version NUMBER
190 , p_init_msg_list VARCHAR2
191 , p_commit VARCHAR2
192 , p_task_id NUMBER
193 , p_task_name VARCHAR2
194 , p_task_type_id NUMBER
195 , p_description VARCHAR2
196 , p_task_status_id NUMBER
197 , p_task_priority_id NUMBER
198 , p_owner_type_code VARCHAR2
199 , p_owner_id NUMBER
200 , p_owner_territory_id NUMBER
201 , p_assigned_by_id NUMBER
202 , p_customer_id NUMBER
203 , p_cust_account_id NUMBER
204 , p_address_id NUMBER
205 , p_planned_start_date date
206 , p_planned_end_date date
207 , p_scheduled_start_date date
208 , p_scheduled_end_date date
209 , p_actual_start_date date
210 , p_actual_end_date date
211 , p_timezone_id NUMBER
212 , p_source_object_type_code VARCHAR2
213 , p_source_object_id NUMBER
214 , p_source_object_name VARCHAR2
215 , p_duration NUMBER
216 , p_duration_uom VARCHAR2
217 , p_planned_effort NUMBER
218 , p_planned_effort_uom VARCHAR2
219 , p_actual_effort NUMBER
220 , p_actual_effort_uom VARCHAR2
221 , p_percentage_complete NUMBER
222 , p_reason_code VARCHAR2
223 , p_private_flag VARCHAR2
224 , p_publish_flag VARCHAR2
225 , p_restrict_closure_flag VARCHAR2
226 , p_multi_booked_flag VARCHAR2
227 , p_milestone_flag VARCHAR2
228 , p_holiday_flag VARCHAR2
229 , p_billable_flag VARCHAR2
230 , p_bound_mode_code VARCHAR2
231 , p_soft_bound_flag VARCHAR2
232 , p_workflow_process_id NUMBER
233 , p_notification_flag VARCHAR2
234 , p_notification_period NUMBER
235 , p_notification_period_uom VARCHAR2
236 , p_parent_task_id NUMBER
237 , p_alarm_start NUMBER
238 , p_alarm_start_uom VARCHAR2
239 , p_alarm_on VARCHAR2
240 , p_alarm_count NUMBER
241 , p_alarm_interval NUMBER
242 , p_alarm_interval_uom VARCHAR2
243 , p_palm_flag VARCHAR2
244 , p_wince_flag VARCHAR2
245 , p_laptop_flag VARCHAR2
246 , p_device1_flag VARCHAR2
247 , p_device2_flag VARCHAR2
248 , p_device3_flag VARCHAR2
249 , p_costs NUMBER
250 , p_currency_code VARCHAR2
251 , p_escalation_level VARCHAR2
252 , x_return_status out nocopy VARCHAR2
253 , x_msg_count out nocopy NUMBER
254 , x_msg_data out nocopy VARCHAR2
255 , x_task_id out nocopy NUMBER
256 , p_attribute1 VARCHAR2
257 , p_attribute2 VARCHAR2
258 , p_attribute3 VARCHAR2
259 , p_attribute4 VARCHAR2
260 , p_attribute5 VARCHAR2
261 , p_attribute6 VARCHAR2
262 , p_attribute7 VARCHAR2
263 , p_attribute8 VARCHAR2
264 , p_attribute9 VARCHAR2
265 , p_attribute10 VARCHAR2
266 , p_attribute11 VARCHAR2
267 , p_attribute12 VARCHAR2
268 , p_attribute13 VARCHAR2
269 , p_attribute14 VARCHAR2
270 , p_attribute15 VARCHAR2
271 , p_attribute_category VARCHAR2
272 , p_date_selected VARCHAR2
273 , p_category_id NUMBER
274 , p_show_on_calendar VARCHAR2
275 , p_owner_status_id NUMBER
276 , p_template_id NUMBER
277 , p_template_group_id NUMBER
278 , p_enable_workflow VARCHAR2
279 , p_abort_workflow VARCHAR2
280 , p_entity VARCHAR2
281 , p_free_busy_type VARCHAR2
282 , p_task_confirmation_status VARCHAR2
283 , p_task_confirmation_counter NUMBER
284 , p_task_split_flag VARCHAR2
285 , p_reference_flag VARCHAR2
286 , p_child_position VARCHAR2
287 , p_child_sequence_num NUMBER
288 , p_location_id NUMBER
289 );
290 procedure create_task(p_api_version NUMBER
291 , p_init_msg_list VARCHAR2
292 , p_commit VARCHAR2
293 , p_task_id NUMBER
294 , p_task_name VARCHAR2
295 , p_task_type_id NUMBER
296 , p_description VARCHAR2
297 , p_task_status_id NUMBER
298 , p_task_priority_id NUMBER
299 , p_owner_type_code VARCHAR2
300 , p_owner_id NUMBER
301 , p_owner_territory_id NUMBER
302 , p_assigned_by_id NUMBER
303 , p_customer_id NUMBER
304 , p_cust_account_id NUMBER
305 , p_address_id NUMBER
306 , p_planned_start_date date
307 , p_planned_end_date date
308 , p_scheduled_start_date date
309 , p_scheduled_end_date date
310 , p_actual_start_date date
311 , p_actual_end_date date
312 , p_timezone_id NUMBER
313 , p_source_object_type_code VARCHAR2
314 , p_source_object_id NUMBER
315 , p_source_object_name VARCHAR2
316 , p_duration NUMBER
317 , p_duration_uom VARCHAR2
318 , p_planned_effort NUMBER
319 , p_planned_effort_uom VARCHAR2
320 , p_actual_effort NUMBER
321 , p_actual_effort_uom VARCHAR2
322 , p_percentage_complete NUMBER
323 , p_reason_code VARCHAR2
324 , p_private_flag VARCHAR2
325 , p_publish_flag VARCHAR2
326 , p_restrict_closure_flag VARCHAR2
327 , p_multi_booked_flag VARCHAR2
328 , p_milestone_flag VARCHAR2
329 , p_holiday_flag VARCHAR2
330 , p_billable_flag VARCHAR2
331 , p_bound_mode_code VARCHAR2
332 , p_soft_bound_flag VARCHAR2
333 , p_workflow_process_id NUMBER
334 , p_notification_flag VARCHAR2
335 , p_notification_period NUMBER
336 , p_notification_period_uom VARCHAR2
337 , p_parent_task_id NUMBER
338 , p_alarm_start NUMBER
339 , p_alarm_start_uom VARCHAR2
340 , p_alarm_on VARCHAR2
341 , p_alarm_count NUMBER
342 , p_alarm_interval NUMBER
343 , p_alarm_interval_uom VARCHAR2
344 , p_palm_flag VARCHAR2
345 , p_wince_flag VARCHAR2
346 , p_laptop_flag VARCHAR2
347 , p_device1_flag VARCHAR2
348 , p_device2_flag VARCHAR2
349 , p_device3_flag VARCHAR2
350 , p_costs NUMBER
351 , p_currency_code VARCHAR2
352 , p_escalation_level VARCHAR2
353 , x_return_status out nocopy VARCHAR2
354 , x_msg_count out nocopy NUMBER
355 , x_msg_data out nocopy VARCHAR2
356 , x_task_id out nocopy NUMBER
357 , p_attribute1 VARCHAR2
358 , p_attribute2 VARCHAR2
359 , p_attribute3 VARCHAR2
360 , p_attribute4 VARCHAR2
361 , p_attribute5 VARCHAR2
362 , p_attribute6 VARCHAR2
363 , p_attribute7 VARCHAR2
364 , p_attribute8 VARCHAR2
365 , p_attribute9 VARCHAR2
366 , p_attribute10 VARCHAR2
367 , p_attribute11 VARCHAR2
368 , p_attribute12 VARCHAR2
369 , p_attribute13 VARCHAR2
370 , p_attribute14 VARCHAR2
371 , p_attribute15 VARCHAR2
372 , p_attribute_category VARCHAR2
373 , p_date_selected VARCHAR2
374 , p_category_id NUMBER
375 , p_show_on_calendar VARCHAR2
376 , p_owner_status_id NUMBER
377 , p_template_id NUMBER
378 , p_template_group_id NUMBER
379 , p_enable_workflow VARCHAR2
380 , p_abort_workflow VARCHAR2
381 , p_entity VARCHAR2
382 , p_free_busy_type VARCHAR2
383 , p_task_confirmation_status VARCHAR2
384 , p_task_confirmation_counter NUMBER
385 , p_task_split_flag VARCHAR2
386 , p_reference_flag VARCHAR2
387 , p_child_position VARCHAR2
388 , p_child_sequence_num NUMBER
389 );
390 procedure create_task(p_api_version NUMBER
391 , p_init_msg_list VARCHAR2
392 , p_commit VARCHAR2
393 , p_task_id NUMBER
394 , p_task_name VARCHAR2
395 , p_task_type_id NUMBER
396 , p_description VARCHAR2
397 , p_task_status_id NUMBER
398 , p_task_priority_id NUMBER
399 , p_owner_type_code VARCHAR2
400 , p_owner_id NUMBER
401 , p_owner_territory_id NUMBER
402 , p_assigned_by_id NUMBER
403 , p_customer_id NUMBER
404 , p_cust_account_id NUMBER
405 , p_address_id NUMBER
406 , p_planned_start_date date
407 , p_planned_end_date date
408 , p_scheduled_start_date date
409 , p_scheduled_end_date date
410 , p_actual_start_date date
411 , p_actual_end_date date
412 , p_timezone_id NUMBER
413 , p_source_object_type_code VARCHAR2
414 , p_source_object_id NUMBER
415 , p_source_object_name VARCHAR2
416 , p_duration NUMBER
417 , p_duration_uom VARCHAR2
418 , p_planned_effort NUMBER
419 , p_planned_effort_uom VARCHAR2
420 , p_actual_effort NUMBER
421 , p_actual_effort_uom VARCHAR2
422 , p_percentage_complete NUMBER
423 , p_reason_code VARCHAR2
424 , p_private_flag VARCHAR2
425 , p_publish_flag VARCHAR2
426 , p_restrict_closure_flag VARCHAR2
427 , p_multi_booked_flag VARCHAR2
428 , p_milestone_flag VARCHAR2
429 , p_holiday_flag VARCHAR2
430 , p_billable_flag VARCHAR2
431 , p_bound_mode_code VARCHAR2
432 , p_soft_bound_flag VARCHAR2
433 , p_workflow_process_id NUMBER
434 , p_notification_flag VARCHAR2
438 , p_alarm_start NUMBER
435 , p_notification_period NUMBER
436 , p_notification_period_uom VARCHAR2
437 , p_parent_task_id NUMBER
439 , p_alarm_start_uom VARCHAR2
440 , p_alarm_on VARCHAR2
441 , p_alarm_count NUMBER
442 , p_alarm_interval NUMBER
443 , p_alarm_interval_uom VARCHAR2
444 , p_palm_flag VARCHAR2
445 , p_wince_flag VARCHAR2
446 , p_laptop_flag VARCHAR2
447 , p_device1_flag VARCHAR2
448 , p_device2_flag VARCHAR2
449 , p_device3_flag VARCHAR2
450 , p_costs NUMBER
451 , p_currency_code VARCHAR2
452 , p_escalation_level VARCHAR2
453 , x_return_status out nocopy VARCHAR2
454 , x_msg_count out nocopy NUMBER
455 , x_msg_data out nocopy VARCHAR2
456 , x_task_id out nocopy NUMBER
457 , p_attribute1 VARCHAR2
458 , p_attribute2 VARCHAR2
459 , p_attribute3 VARCHAR2
460 , p_attribute4 VARCHAR2
461 , p_attribute5 VARCHAR2
462 , p_attribute6 VARCHAR2
463 , p_attribute7 VARCHAR2
464 , p_attribute8 VARCHAR2
465 , p_attribute9 VARCHAR2
466 , p_attribute10 VARCHAR2
467 , p_attribute11 VARCHAR2
468 , p_attribute12 VARCHAR2
469 , p_attribute13 VARCHAR2
470 , p_attribute14 VARCHAR2
471 , p_attribute15 VARCHAR2
472 , p_attribute_category VARCHAR2
473 , p_date_selected VARCHAR2
474 , p_category_id NUMBER
475 , p_show_on_calendar VARCHAR2
476 , p_owner_status_id NUMBER
477 , p_template_id NUMBER
478 , p_template_group_id NUMBER
479 );
480 procedure update_task(p_api_version NUMBER
481 , p_init_msg_list VARCHAR2
482 , p_commit VARCHAR2
483 , p_object_version_number in out nocopy NUMBER
484 , p_task_id NUMBER
485 , p_task_name VARCHAR2
486 , p_task_type_id NUMBER
487 , p_description VARCHAR2
488 , p_task_status_id NUMBER
489 , p_task_priority_id NUMBER
490 , p_owner_type_code VARCHAR2
491 , p_owner_id NUMBER
492 , p_owner_territory_id NUMBER
493 , p_assigned_by_id NUMBER
494 , p_customer_id NUMBER
495 , p_cust_account_id NUMBER
496 , p_address_id NUMBER
497 , p_planned_start_date date
498 , p_planned_end_date date
499 , p_scheduled_start_date date
500 , p_scheduled_end_date date
501 , p_actual_start_date date
502 , p_actual_end_date date
503 , p_timezone_id NUMBER
504 , p_source_object_type_code VARCHAR2
505 , p_source_object_id NUMBER
506 , p_source_object_name VARCHAR2
507 , p_duration NUMBER
508 , p_duration_uom VARCHAR2
509 , p_planned_effort NUMBER
510 , p_planned_effort_uom VARCHAR2
511 , p_actual_effort NUMBER
512 , p_actual_effort_uom VARCHAR2
513 , p_percentage_complete NUMBER
514 , p_reason_code VARCHAR2
515 , p_private_flag VARCHAR2
516 , p_publish_flag VARCHAR2
517 , p_restrict_closure_flag VARCHAR2
518 , p_multi_booked_flag VARCHAR2
519 , p_milestone_flag VARCHAR2
520 , p_holiday_flag VARCHAR2
521 , p_billable_flag VARCHAR2
522 , p_bound_mode_code VARCHAR2
523 , p_soft_bound_flag VARCHAR2
524 , p_workflow_process_id NUMBER
525 , p_notification_flag VARCHAR2
526 , p_notification_period NUMBER
527 , p_notification_period_uom VARCHAR2
528 , p_parent_task_id NUMBER
529 , p_alarm_start NUMBER
530 , p_alarm_start_uom VARCHAR2
531 , p_alarm_on VARCHAR2
532 , p_alarm_count NUMBER
533 , p_alarm_fired_count NUMBER
534 , p_alarm_interval NUMBER
535 , p_alarm_interval_uom VARCHAR2
536 , p_palm_flag VARCHAR2
537 , p_wince_flag VARCHAR2
538 , p_laptop_flag VARCHAR2
539 , p_device1_flag VARCHAR2
540 , p_device2_flag VARCHAR2
541 , p_device3_flag VARCHAR2
542 , p_costs NUMBER
543 , p_currency_code VARCHAR2
544 , p_escalation_level VARCHAR2
545 , x_return_status out nocopy VARCHAR2
546 , x_msg_count out nocopy NUMBER
547 , x_msg_data out nocopy VARCHAR2
548 , p_attribute1 VARCHAR2
549 , p_attribute2 VARCHAR2
550 , p_attribute3 VARCHAR2
551 , p_attribute4 VARCHAR2
552 , p_attribute5 VARCHAR2
553 , p_attribute6 VARCHAR2
554 , p_attribute7 VARCHAR2
555 , p_attribute8 VARCHAR2
556 , p_attribute9 VARCHAR2
557 , p_attribute10 VARCHAR2
558 , p_attribute11 VARCHAR2
559 , p_attribute12 VARCHAR2
560 , p_attribute13 VARCHAR2
561 , p_attribute14 VARCHAR2
562 , p_attribute15 VARCHAR2
563 , p_attribute_category VARCHAR2
564 , p_date_selected VARCHAR2
565 , p_category_id NUMBER
566 , p_show_on_calendar VARCHAR2
567 , p_owner_status_id NUMBER
568 , p_enable_workflow VARCHAR2
569 , p_abort_workflow VARCHAR2
570 , p_change_mode VARCHAR2
571 );
572 procedure update_task(p_api_version NUMBER
573 , p_init_msg_list VARCHAR2
574 , p_commit VARCHAR2
575 , p_object_version_number in out nocopy NUMBER
576 , p_task_id NUMBER
577 , p_task_name VARCHAR2
578 , p_task_type_id NUMBER
582 , p_owner_type_code VARCHAR2
579 , p_description VARCHAR2
580 , p_task_status_id NUMBER
581 , p_task_priority_id NUMBER
583 , p_owner_id NUMBER
584 , p_owner_territory_id NUMBER
585 , p_assigned_by_id NUMBER
586 , p_customer_id NUMBER
587 , p_cust_account_id NUMBER
588 , p_address_id NUMBER
589 , p_planned_start_date date
590 , p_planned_end_date date
591 , p_scheduled_start_date date
592 , p_scheduled_end_date date
593 , p_actual_start_date date
594 , p_actual_end_date date
595 , p_timezone_id NUMBER
596 , p_source_object_type_code VARCHAR2
597 , p_source_object_id NUMBER
598 , p_source_object_name VARCHAR2
599 , p_duration NUMBER
600 , p_duration_uom VARCHAR2
601 , p_planned_effort NUMBER
602 , p_planned_effort_uom VARCHAR2
603 , p_actual_effort NUMBER
604 , p_actual_effort_uom VARCHAR2
605 , p_percentage_complete NUMBER
606 , p_reason_code VARCHAR2
607 , p_private_flag VARCHAR2
608 , p_publish_flag VARCHAR2
609 , p_restrict_closure_flag VARCHAR2
610 , p_multi_booked_flag VARCHAR2
611 , p_milestone_flag VARCHAR2
612 , p_holiday_flag VARCHAR2
613 , p_billable_flag VARCHAR2
614 , p_bound_mode_code VARCHAR2
615 , p_soft_bound_flag VARCHAR2
616 , p_workflow_process_id NUMBER
617 , p_notification_flag VARCHAR2
618 , p_notification_period NUMBER
619 , p_notification_period_uom VARCHAR2
620 , p_parent_task_id NUMBER
621 , p_alarm_start NUMBER
622 , p_alarm_start_uom VARCHAR2
623 , p_alarm_on VARCHAR2
624 , p_alarm_count NUMBER
625 , p_alarm_fired_count NUMBER
626 , p_alarm_interval NUMBER
627 , p_alarm_interval_uom VARCHAR2
628 , p_palm_flag VARCHAR2
629 , p_wince_flag VARCHAR2
630 , p_laptop_flag VARCHAR2
631 , p_device1_flag VARCHAR2
632 , p_device2_flag VARCHAR2
633 , p_device3_flag VARCHAR2
634 , p_costs NUMBER
635 , p_currency_code VARCHAR2
636 , p_escalation_level VARCHAR2
637 , x_return_status out nocopy VARCHAR2
638 , x_msg_count out nocopy NUMBER
639 , x_msg_data out nocopy VARCHAR2
640 , p_attribute1 VARCHAR2
641 , p_attribute2 VARCHAR2
642 , p_attribute3 VARCHAR2
643 , p_attribute4 VARCHAR2
644 , p_attribute5 VARCHAR2
645 , p_attribute6 VARCHAR2
646 , p_attribute7 VARCHAR2
647 , p_attribute8 VARCHAR2
648 , p_attribute9 VARCHAR2
649 , p_attribute10 VARCHAR2
650 , p_attribute11 VARCHAR2
651 , p_attribute12 VARCHAR2
652 , p_attribute13 VARCHAR2
653 , p_attribute14 VARCHAR2
654 , p_attribute15 VARCHAR2
655 , p_attribute_category VARCHAR2
656 , p_date_selected VARCHAR2
657 , p_category_id NUMBER
658 , p_show_on_calendar VARCHAR2
659 , p_owner_status_id NUMBER
660 , p_enable_workflow VARCHAR2
661 , p_abort_workflow VARCHAR2
662 , p_change_mode VARCHAR2
663 , p_free_busy_type VARCHAR2
664 );
665 procedure update_task(p_api_version NUMBER
666 , p_init_msg_list VARCHAR2
667 , p_commit VARCHAR2
668 , p_object_version_number in out nocopy NUMBER
669 , p_task_id NUMBER
670 , p_task_name VARCHAR2
671 , p_task_type_id NUMBER
672 , p_description VARCHAR2
673 , p_task_status_id NUMBER
674 , p_task_priority_id NUMBER
675 , p_owner_type_code VARCHAR2
676 , p_owner_id NUMBER
677 , p_owner_territory_id NUMBER
678 , p_assigned_by_id NUMBER
679 , p_customer_id NUMBER
680 , p_cust_account_id NUMBER
681 , p_address_id NUMBER
682 , p_planned_start_date date
683 , p_planned_end_date date
684 , p_scheduled_start_date date
685 , p_scheduled_end_date date
686 , p_actual_start_date date
687 , p_actual_end_date date
688 , p_timezone_id NUMBER
689 , p_source_object_type_code VARCHAR2
690 , p_source_object_id NUMBER
691 , p_source_object_name VARCHAR2
692 , p_duration NUMBER
693 , p_duration_uom VARCHAR2
694 , p_planned_effort NUMBER
695 , p_planned_effort_uom VARCHAR2
696 , p_actual_effort NUMBER
697 , p_actual_effort_uom VARCHAR2
698 , p_percentage_complete NUMBER
699 , p_reason_code VARCHAR2
700 , p_private_flag VARCHAR2
701 , p_publish_flag VARCHAR2
702 , p_restrict_closure_flag VARCHAR2
703 , p_multi_booked_flag VARCHAR2
704 , p_milestone_flag VARCHAR2
705 , p_holiday_flag VARCHAR2
706 , p_billable_flag VARCHAR2
707 , p_bound_mode_code VARCHAR2
708 , p_soft_bound_flag VARCHAR2
709 , p_workflow_process_id NUMBER
710 , p_notification_flag VARCHAR2
711 , p_notification_period NUMBER
712 , p_notification_period_uom VARCHAR2
713 , p_parent_task_id NUMBER
714 , p_alarm_start NUMBER
715 , p_alarm_start_uom VARCHAR2
716 , p_alarm_on VARCHAR2
717 , p_alarm_count NUMBER
718 , p_alarm_fired_count NUMBER
719 , p_alarm_interval NUMBER
720 , p_alarm_interval_uom VARCHAR2
724 , p_device1_flag VARCHAR2
721 , p_palm_flag VARCHAR2
722 , p_wince_flag VARCHAR2
723 , p_laptop_flag VARCHAR2
725 , p_device2_flag VARCHAR2
726 , p_device3_flag VARCHAR2
727 , p_costs NUMBER
728 , p_currency_code VARCHAR2
729 , p_escalation_level VARCHAR2
730 , x_return_status out nocopy VARCHAR2
731 , x_msg_count out nocopy NUMBER
732 , x_msg_data out nocopy VARCHAR2
733 , p_attribute1 VARCHAR2
734 , p_attribute2 VARCHAR2
735 , p_attribute3 VARCHAR2
736 , p_attribute4 VARCHAR2
737 , p_attribute5 VARCHAR2
738 , p_attribute6 VARCHAR2
739 , p_attribute7 VARCHAR2
740 , p_attribute8 VARCHAR2
741 , p_attribute9 VARCHAR2
742 , p_attribute10 VARCHAR2
743 , p_attribute11 VARCHAR2
744 , p_attribute12 VARCHAR2
745 , p_attribute13 VARCHAR2
746 , p_attribute14 VARCHAR2
747 , p_attribute15 VARCHAR2
748 , p_attribute_category VARCHAR2
749 , p_date_selected VARCHAR2
750 , p_category_id NUMBER
751 , p_show_on_calendar VARCHAR2
752 , p_owner_status_id NUMBER
753 , p_enable_workflow VARCHAR2
754 , p_abort_workflow VARCHAR2
755 , p_change_mode VARCHAR2
756 , p_free_busy_type VARCHAR2
757 , p_task_confirmation_status VARCHAR2
758 , p_task_confirmation_counter NUMBER
759 , p_task_split_flag VARCHAR2
760 , p_child_position VARCHAR2
761 , p_child_sequence_num NUMBER
762 , p_location_id NUMBER
763 );
764 procedure update_task(p_api_version NUMBER
765 , p_init_msg_list VARCHAR2
766 , p_commit VARCHAR2
767 , p_object_version_number in out nocopy NUMBER
768 , p_task_id NUMBER
769 , p_task_name VARCHAR2
770 , p_task_type_id NUMBER
771 , p_description VARCHAR2
772 , p_task_status_id NUMBER
773 , p_task_priority_id NUMBER
774 , p_owner_type_code VARCHAR2
775 , p_owner_id NUMBER
776 , p_owner_territory_id NUMBER
777 , p_assigned_by_id NUMBER
778 , p_customer_id NUMBER
779 , p_cust_account_id NUMBER
780 , p_address_id NUMBER
781 , p_planned_start_date date
782 , p_planned_end_date date
783 , p_scheduled_start_date date
784 , p_scheduled_end_date date
785 , p_actual_start_date date
786 , p_actual_end_date date
787 , p_timezone_id NUMBER
788 , p_source_object_type_code VARCHAR2
789 , p_source_object_id NUMBER
790 , p_source_object_name VARCHAR2
791 , p_duration NUMBER
792 , p_duration_uom VARCHAR2
793 , p_planned_effort NUMBER
794 , p_planned_effort_uom VARCHAR2
795 , p_actual_effort NUMBER
796 , p_actual_effort_uom VARCHAR2
797 , p_percentage_complete NUMBER
798 , p_reason_code VARCHAR2
799 , p_private_flag VARCHAR2
800 , p_publish_flag VARCHAR2
801 , p_restrict_closure_flag VARCHAR2
802 , p_multi_booked_flag VARCHAR2
803 , p_milestone_flag VARCHAR2
804 , p_holiday_flag VARCHAR2
805 , p_billable_flag VARCHAR2
806 , p_bound_mode_code VARCHAR2
807 , p_soft_bound_flag VARCHAR2
808 , p_workflow_process_id NUMBER
809 , p_notification_flag VARCHAR2
810 , p_notification_period NUMBER
811 , p_notification_period_uom VARCHAR2
812 , p_parent_task_id NUMBER
813 , p_alarm_start NUMBER
814 , p_alarm_start_uom VARCHAR2
815 , p_alarm_on VARCHAR2
816 , p_alarm_count NUMBER
817 , p_alarm_fired_count NUMBER
818 , p_alarm_interval NUMBER
819 , p_alarm_interval_uom VARCHAR2
820 , p_palm_flag VARCHAR2
821 , p_wince_flag VARCHAR2
822 , p_laptop_flag VARCHAR2
823 , p_device1_flag VARCHAR2
824 , p_device2_flag VARCHAR2
825 , p_device3_flag VARCHAR2
826 , p_costs NUMBER
827 , p_currency_code VARCHAR2
828 , p_escalation_level VARCHAR2
829 , x_return_status out nocopy VARCHAR2
830 , x_msg_count out nocopy NUMBER
831 , x_msg_data out nocopy VARCHAR2
832 , p_attribute1 VARCHAR2
833 , p_attribute2 VARCHAR2
834 , p_attribute3 VARCHAR2
835 , p_attribute4 VARCHAR2
836 , p_attribute5 VARCHAR2
837 , p_attribute6 VARCHAR2
838 , p_attribute7 VARCHAR2
839 , p_attribute8 VARCHAR2
840 , p_attribute9 VARCHAR2
841 , p_attribute10 VARCHAR2
842 , p_attribute11 VARCHAR2
843 , p_attribute12 VARCHAR2
844 , p_attribute13 VARCHAR2
845 , p_attribute14 VARCHAR2
846 , p_attribute15 VARCHAR2
847 , p_attribute_category VARCHAR2
848 , p_date_selected VARCHAR2
849 , p_category_id NUMBER
850 , p_show_on_calendar VARCHAR2
851 , p_owner_status_id NUMBER
852 , p_enable_workflow VARCHAR2
853 , p_abort_workflow VARCHAR2
854 , p_change_mode VARCHAR2
855 , p_free_busy_type VARCHAR2
856 , p_task_confirmation_status VARCHAR2
857 , p_task_confirmation_counter NUMBER
858 , p_task_split_flag VARCHAR2
859 , p_child_position VARCHAR2
860 , p_child_sequence_num NUMBER
861 );
862 procedure update_task(p_api_version NUMBER
866 , p_task_id NUMBER
863 , p_init_msg_list VARCHAR2
864 , p_commit VARCHAR2
865 , p_object_version_number in out nocopy NUMBER
867 , p_task_name VARCHAR2
868 , p_task_type_id NUMBER
869 , p_description VARCHAR2
870 , p_task_status_id NUMBER
871 , p_task_priority_id NUMBER
872 , p_owner_type_code VARCHAR2
873 , p_owner_id NUMBER
874 , p_owner_territory_id NUMBER
875 , p_assigned_by_id NUMBER
876 , p_customer_id NUMBER
877 , p_cust_account_id NUMBER
878 , p_address_id NUMBER
879 , p_planned_start_date date
880 , p_planned_end_date date
881 , p_scheduled_start_date date
882 , p_scheduled_end_date date
883 , p_actual_start_date date
884 , p_actual_end_date date
885 , p_timezone_id NUMBER
886 , p_source_object_type_code VARCHAR2
887 , p_source_object_id NUMBER
888 , p_source_object_name VARCHAR2
889 , p_duration NUMBER
890 , p_duration_uom VARCHAR2
891 , p_planned_effort NUMBER
892 , p_planned_effort_uom VARCHAR2
893 , p_actual_effort NUMBER
894 , p_actual_effort_uom VARCHAR2
895 , p_percentage_complete NUMBER
896 , p_reason_code VARCHAR2
897 , p_private_flag VARCHAR2
898 , p_publish_flag VARCHAR2
899 , p_restrict_closure_flag VARCHAR2
900 , p_multi_booked_flag VARCHAR2
901 , p_milestone_flag VARCHAR2
902 , p_holiday_flag VARCHAR2
903 , p_billable_flag VARCHAR2
904 , p_bound_mode_code VARCHAR2
905 , p_soft_bound_flag VARCHAR2
906 , p_workflow_process_id NUMBER
907 , p_notification_flag VARCHAR2
908 , p_notification_period NUMBER
909 , p_notification_period_uom VARCHAR2
910 , p_parent_task_id NUMBER
911 , p_alarm_start NUMBER
912 , p_alarm_start_uom VARCHAR2
913 , p_alarm_on VARCHAR2
914 , p_alarm_count NUMBER
915 , p_alarm_fired_count NUMBER
916 , p_alarm_interval NUMBER
917 , p_alarm_interval_uom VARCHAR2
918 , p_palm_flag VARCHAR2
919 , p_wince_flag VARCHAR2
920 , p_laptop_flag VARCHAR2
921 , p_device1_flag VARCHAR2
922 , p_device2_flag VARCHAR2
923 , p_device3_flag VARCHAR2
924 , p_costs NUMBER
925 , p_currency_code VARCHAR2
926 , p_escalation_level VARCHAR2
927 , x_return_status out nocopy VARCHAR2
928 , x_msg_count out nocopy NUMBER
929 , x_msg_data out nocopy VARCHAR2
930 , p_attribute1 VARCHAR2
931 , p_attribute2 VARCHAR2
932 , p_attribute3 VARCHAR2
933 , p_attribute4 VARCHAR2
934 , p_attribute5 VARCHAR2
935 , p_attribute6 VARCHAR2
936 , p_attribute7 VARCHAR2
937 , p_attribute8 VARCHAR2
938 , p_attribute9 VARCHAR2
939 , p_attribute10 VARCHAR2
940 , p_attribute11 VARCHAR2
941 , p_attribute12 VARCHAR2
942 , p_attribute13 VARCHAR2
943 , p_attribute14 VARCHAR2
944 , p_attribute15 VARCHAR2
945 , p_attribute_category VARCHAR2
946 , p_date_selected VARCHAR2
947 , p_category_id NUMBER
948 , p_show_on_calendar VARCHAR2
949 , p_owner_status_id NUMBER
950 , p_enable_workflow VARCHAR2
951 , p_abort_workflow VARCHAR2
952 );
953 procedure update_task(p_api_version NUMBER
954 , p_init_msg_list VARCHAR2
955 , p_commit VARCHAR2
956 , p_object_version_number in out nocopy NUMBER
957 , p_task_id NUMBER
958 , p_task_name VARCHAR2
959 , p_task_type_id NUMBER
960 , p_description VARCHAR2
961 , p_task_status_id NUMBER
962 , p_task_priority_id NUMBER
963 , p_owner_type_code VARCHAR2
964 , p_owner_id NUMBER
965 , p_owner_territory_id NUMBER
966 , p_assigned_by_id NUMBER
967 , p_customer_id NUMBER
968 , p_cust_account_id NUMBER
969 , p_address_id NUMBER
970 , p_planned_start_date date
971 , p_planned_end_date date
972 , p_scheduled_start_date date
973 , p_scheduled_end_date date
974 , p_actual_start_date date
975 , p_actual_end_date date
976 , p_timezone_id NUMBER
977 , p_source_object_type_code VARCHAR2
978 , p_source_object_id NUMBER
979 , p_source_object_name VARCHAR2
980 , p_duration NUMBER
981 , p_duration_uom VARCHAR2
982 , p_planned_effort NUMBER
983 , p_planned_effort_uom VARCHAR2
984 , p_actual_effort NUMBER
985 , p_actual_effort_uom VARCHAR2
986 , p_percentage_complete NUMBER
987 , p_reason_code VARCHAR2
988 , p_private_flag VARCHAR2
989 , p_publish_flag VARCHAR2
990 , p_restrict_closure_flag VARCHAR2
991 , p_multi_booked_flag VARCHAR2
992 , p_milestone_flag VARCHAR2
993 , p_holiday_flag VARCHAR2
994 , p_billable_flag VARCHAR2
995 , p_bound_mode_code VARCHAR2
996 , p_soft_bound_flag VARCHAR2
997 , p_workflow_process_id NUMBER
998 , p_notification_flag VARCHAR2
999 , p_notification_period NUMBER
1000 , p_notification_period_uom VARCHAR2
1001 , p_parent_task_id NUMBER
1002 , p_alarm_start NUMBER
1003 , p_alarm_start_uom VARCHAR2
1004 , p_alarm_on VARCHAR2
1008 , p_alarm_interval_uom VARCHAR2
1005 , p_alarm_count NUMBER
1006 , p_alarm_fired_count NUMBER
1007 , p_alarm_interval NUMBER
1009 , p_palm_flag VARCHAR2
1010 , p_wince_flag VARCHAR2
1011 , p_laptop_flag VARCHAR2
1012 , p_device1_flag VARCHAR2
1013 , p_device2_flag VARCHAR2
1014 , p_device3_flag VARCHAR2
1015 , p_costs NUMBER
1016 , p_currency_code VARCHAR2
1017 , p_escalation_level VARCHAR2
1018 , x_return_status out nocopy VARCHAR2
1019 , x_msg_count out nocopy NUMBER
1020 , x_msg_data out nocopy VARCHAR2
1021 , p_attribute1 VARCHAR2
1022 , p_attribute2 VARCHAR2
1023 , p_attribute3 VARCHAR2
1024 , p_attribute4 VARCHAR2
1025 , p_attribute5 VARCHAR2
1026 , p_attribute6 VARCHAR2
1027 , p_attribute7 VARCHAR2
1028 , p_attribute8 VARCHAR2
1029 , p_attribute9 VARCHAR2
1030 , p_attribute10 VARCHAR2
1031 , p_attribute11 VARCHAR2
1032 , p_attribute12 VARCHAR2
1033 , p_attribute13 VARCHAR2
1034 , p_attribute14 VARCHAR2
1035 , p_attribute15 VARCHAR2
1036 , p_attribute_category VARCHAR2
1037 , p_date_selected VARCHAR2
1038 , p_category_id NUMBER
1039 , p_show_on_calendar VARCHAR2
1040 , p_owner_status_id NUMBER
1041 );
1042 end jtf_tasks_pvt_w;