[Home] [Help]
PACKAGE: APPS.JTF_TASKS_PVT
Source
1 PACKAGE jtf_tasks_pvt AS
2 /* $Header: jtfvtkts.pls 120.4 2008/03/26 08:14:10 venjayar ship $ */
3 g_enable_workflow CONSTANT VARCHAR2(1) := fnd_profile.VALUE('JTF_TASK_ENABLE_WORKFLOW');
4 g_abort_workflow CONSTANT VARCHAR2(1) := fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF');
5
6 --Created for BES enh 2391065
7 TYPE task_rec_type IS RECORD(
8 task_id jtf_tasks_b.task_id%TYPE := NULL
9 , template_id jtf_tasks_b.template_id%TYPE := NULL
10 , task_audit_id jtf_task_audits_b.task_audit_id%TYPE := NULL
11 , task_type_id jtf_tasks_b.task_type_id%TYPE := NULL
12 , task_status_id jtf_tasks_b.task_status_id%TYPE := NULL
13 , task_priority_id jtf_tasks_b.task_priority_id%TYPE := NULL
14 , planned_start_date jtf_tasks_b.planned_start_date%TYPE := NULL
15 , planned_end_date jtf_tasks_b.planned_end_date%TYPE := NULL
16 , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := NULL
17 , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := NULL
18 , actual_start_date jtf_tasks_b.actual_start_date%TYPE := NULL
19 , actual_end_date jtf_tasks_b.actual_end_date%TYPE := NULL
20 , source_object_type_code jtf_tasks_b.source_object_type_code%TYPE := NULL
21 , source_object_id jtf_tasks_b.source_object_id%TYPE := NULL
22 , enable_workflow VARCHAR2(1) := NULL
23 , abort_workflow VARCHAR2(1) := NULL
24 );
25
26 -- The overloaded version which added p_enable_workflow and p_abort_workflow
27 PROCEDURE create_task(
28 p_api_version IN NUMBER
29 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
30 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
31 , p_task_id IN NUMBER DEFAULT NULL
32 , p_task_name IN VARCHAR2
33 , p_task_type_id IN NUMBER DEFAULT NULL
34 , p_description IN VARCHAR2 DEFAULT NULL
35 , p_task_status_id IN NUMBER DEFAULT NULL
36 , p_task_priority_id IN NUMBER DEFAULT NULL
37 , p_owner_type_code IN VARCHAR2 DEFAULT NULL
38 , p_owner_id IN NUMBER DEFAULT NULL
39 , p_owner_territory_id IN NUMBER DEFAULT NULL
40 , p_assigned_by_id IN NUMBER DEFAULT NULL
41 , p_customer_id IN NUMBER DEFAULT NULL
42 , p_cust_account_id IN NUMBER DEFAULT NULL
43 , p_address_id IN NUMBER DEFAULT NULL
44 , ---- hz_party_sites
45 p_planned_start_date IN DATE DEFAULT NULL
46 , p_planned_end_date IN DATE DEFAULT NULL
47 , p_scheduled_start_date IN DATE DEFAULT NULL
48 , p_scheduled_end_date IN DATE DEFAULT NULL
49 , p_actual_start_date IN DATE DEFAULT NULL
50 , p_actual_end_date IN DATE DEFAULT NULL
51 , p_timezone_id IN NUMBER DEFAULT NULL
52 , p_source_object_type_code IN VARCHAR2 DEFAULT NULL
53 , p_source_object_id IN NUMBER DEFAULT NULL
54 , p_source_object_name IN VARCHAR2 DEFAULT NULL
55 , p_duration IN NUMBER DEFAULT NULL
56 , p_duration_uom IN VARCHAR2 DEFAULT NULL
57 , p_planned_effort IN NUMBER DEFAULT NULL
58 , p_planned_effort_uom IN VARCHAR2 DEFAULT NULL
59 , p_actual_effort IN NUMBER DEFAULT NULL
60 , p_actual_effort_uom IN VARCHAR2 DEFAULT NULL
61 , p_percentage_complete IN NUMBER DEFAULT NULL
62 , p_reason_code IN VARCHAR2 DEFAULT NULL
63 , p_private_flag IN VARCHAR2 DEFAULT NULL
64 , p_publish_flag IN VARCHAR2 DEFAULT NULL
65 , p_restrict_closure_flag IN VARCHAR2 DEFAULT NULL
66 , p_multi_booked_flag IN VARCHAR2 DEFAULT NULL
67 , p_milestone_flag IN VARCHAR2 DEFAULT NULL
68 , p_holiday_flag IN VARCHAR2 DEFAULT NULL
69 , p_billable_flag IN VARCHAR2 DEFAULT NULL
70 , p_bound_mode_code IN VARCHAR2 DEFAULT NULL
71 , p_soft_bound_flag IN VARCHAR2 DEFAULT NULL
72 , p_workflow_process_id IN NUMBER DEFAULT NULL
73 , p_notification_flag IN VARCHAR2 DEFAULT NULL
74 , p_notification_period IN NUMBER DEFAULT NULL
75 , p_notification_period_uom IN VARCHAR2 DEFAULT NULL
76 , p_parent_task_id IN NUMBER DEFAULT NULL
77 , p_alarm_start IN NUMBER DEFAULT NULL
78 , p_alarm_start_uom IN VARCHAR2 DEFAULT NULL
79 , p_alarm_on IN VARCHAR2 DEFAULT NULL
80 , p_alarm_count IN NUMBER DEFAULT NULL
81 , p_alarm_interval IN NUMBER DEFAULT NULL
82 , p_alarm_interval_uom IN VARCHAR2 DEFAULT NULL
83 , p_palm_flag IN VARCHAR2 DEFAULT NULL
84 , p_wince_flag IN VARCHAR2 DEFAULT NULL
85 , p_laptop_flag IN VARCHAR2 DEFAULT NULL
86 , p_device1_flag IN VARCHAR2 DEFAULT NULL
87 , p_device2_flag IN VARCHAR2 DEFAULT NULL
88 , p_device3_flag IN VARCHAR2 DEFAULT NULL
89 , p_costs IN NUMBER DEFAULT NULL
90 , p_currency_code IN VARCHAR2 DEFAULT NULL
91 , p_escalation_level IN VARCHAR2 DEFAULT NULL
92 , x_return_status OUT NOCOPY VARCHAR2
93 , x_msg_count OUT NOCOPY NUMBER
94 , x_msg_data OUT NOCOPY VARCHAR2
95 , x_task_id OUT NOCOPY NUMBER
96 , p_attribute1 IN VARCHAR2 DEFAULT NULL
97 , p_attribute2 IN VARCHAR2 DEFAULT NULL
98 , p_attribute3 IN VARCHAR2 DEFAULT NULL
99 , p_attribute4 IN VARCHAR2 DEFAULT NULL
100 , p_attribute5 IN VARCHAR2 DEFAULT NULL
101 , p_attribute6 IN VARCHAR2 DEFAULT NULL
102 , p_attribute7 IN VARCHAR2 DEFAULT NULL
103 , p_attribute8 IN VARCHAR2 DEFAULT NULL
104 , p_attribute9 IN VARCHAR2 DEFAULT NULL
105 , p_attribute10 IN VARCHAR2 DEFAULT NULL
106 , p_attribute11 IN VARCHAR2 DEFAULT NULL
107 , p_attribute12 IN VARCHAR2 DEFAULT NULL
108 , p_attribute13 IN VARCHAR2 DEFAULT NULL
109 , p_attribute14 IN VARCHAR2 DEFAULT NULL
110 , p_attribute15 IN VARCHAR2 DEFAULT NULL
111 , p_attribute_category IN VARCHAR2 DEFAULT NULL
112 , p_date_selected IN VARCHAR2 DEFAULT NULL
113 , p_category_id IN NUMBER DEFAULT NULL
114 , p_show_on_calendar IN VARCHAR2 DEFAULT NULL
115 , p_owner_status_id IN NUMBER DEFAULT NULL
116 , p_template_id IN NUMBER DEFAULT NULL
117 , p_template_group_id IN NUMBER DEFAULT NULL
118 , p_enable_workflow IN VARCHAR2
119 , p_abort_workflow IN VARCHAR2
120 );
121
122 -- The overloaded version which added p_entity and p_free_busy_type
123 PROCEDURE create_task(
124 p_api_version IN NUMBER
125 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
126 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
127 , p_task_id IN NUMBER DEFAULT NULL
128 , p_task_name IN VARCHAR2
129 , p_task_type_id IN NUMBER DEFAULT NULL
130 , p_description IN VARCHAR2 DEFAULT NULL
131 , p_task_status_id IN NUMBER DEFAULT NULL
132 , p_task_priority_id IN NUMBER DEFAULT NULL
133 , p_owner_type_code IN VARCHAR2 DEFAULT NULL
134 , p_owner_id IN NUMBER DEFAULT NULL
135 , p_owner_territory_id IN NUMBER DEFAULT NULL
136 , p_assigned_by_id IN NUMBER DEFAULT NULL
137 , p_customer_id IN NUMBER DEFAULT NULL
138 , p_cust_account_id IN NUMBER DEFAULT NULL
139 , p_address_id IN NUMBER DEFAULT NULL
140 , ---- hz_party_sites
141 p_planned_start_date IN DATE DEFAULT NULL
142 , p_planned_end_date IN DATE DEFAULT NULL
143 , p_scheduled_start_date IN DATE DEFAULT NULL
144 , p_scheduled_end_date IN DATE DEFAULT NULL
145 , p_actual_start_date IN DATE DEFAULT NULL
146 , p_actual_end_date IN DATE DEFAULT NULL
147 , p_timezone_id IN NUMBER DEFAULT NULL
148 , p_source_object_type_code IN VARCHAR2 DEFAULT NULL
149 , p_source_object_id IN NUMBER DEFAULT NULL
150 , p_source_object_name IN VARCHAR2 DEFAULT NULL
151 , p_duration IN NUMBER DEFAULT NULL
152 , p_duration_uom IN VARCHAR2 DEFAULT NULL
153 , p_planned_effort IN NUMBER DEFAULT NULL
154 , p_planned_effort_uom IN VARCHAR2 DEFAULT NULL
155 , p_actual_effort IN NUMBER DEFAULT NULL
156 , p_actual_effort_uom IN VARCHAR2 DEFAULT NULL
157 , p_percentage_complete IN NUMBER DEFAULT NULL
158 , p_reason_code IN VARCHAR2 DEFAULT NULL
159 , p_private_flag IN VARCHAR2 DEFAULT NULL
160 , p_publish_flag IN VARCHAR2 DEFAULT NULL
161 , p_restrict_closure_flag IN VARCHAR2 DEFAULT NULL
162 , p_multi_booked_flag IN VARCHAR2 DEFAULT NULL
163 , p_milestone_flag IN VARCHAR2 DEFAULT NULL
164 , p_holiday_flag IN VARCHAR2 DEFAULT NULL
165 , p_billable_flag IN VARCHAR2 DEFAULT NULL
166 , p_bound_mode_code IN VARCHAR2 DEFAULT NULL
167 , p_soft_bound_flag IN VARCHAR2 DEFAULT NULL
168 , p_workflow_process_id IN NUMBER DEFAULT NULL
169 , p_notification_flag IN VARCHAR2 DEFAULT NULL
170 , p_notification_period IN NUMBER DEFAULT NULL
171 , p_notification_period_uom IN VARCHAR2 DEFAULT NULL
172 , p_parent_task_id IN NUMBER DEFAULT NULL
173 , p_alarm_start IN NUMBER DEFAULT NULL
174 , p_alarm_start_uom IN VARCHAR2 DEFAULT NULL
175 , p_alarm_on IN VARCHAR2 DEFAULT NULL
176 , p_alarm_count IN NUMBER DEFAULT NULL
177 , p_alarm_interval IN NUMBER DEFAULT NULL
178 , p_alarm_interval_uom IN VARCHAR2 DEFAULT NULL
179 , p_palm_flag IN VARCHAR2 DEFAULT NULL
180 , p_wince_flag IN VARCHAR2 DEFAULT NULL
181 , p_laptop_flag IN VARCHAR2 DEFAULT NULL
182 , p_device1_flag IN VARCHAR2 DEFAULT NULL
183 , p_device2_flag IN VARCHAR2 DEFAULT NULL
184 , p_device3_flag IN VARCHAR2 DEFAULT NULL
185 , p_costs IN NUMBER DEFAULT NULL
186 , p_currency_code IN VARCHAR2 DEFAULT NULL
187 , p_escalation_level IN VARCHAR2 DEFAULT NULL
188 , x_return_status OUT NOCOPY VARCHAR2
189 , x_msg_count OUT NOCOPY NUMBER
190 , x_msg_data OUT NOCOPY VARCHAR2
191 , x_task_id OUT NOCOPY NUMBER
192 , p_attribute1 IN VARCHAR2 DEFAULT NULL
193 , p_attribute2 IN VARCHAR2 DEFAULT NULL
194 , p_attribute3 IN VARCHAR2 DEFAULT NULL
195 , p_attribute4 IN VARCHAR2 DEFAULT NULL
196 , p_attribute5 IN VARCHAR2 DEFAULT NULL
197 , p_attribute6 IN VARCHAR2 DEFAULT NULL
198 , p_attribute7 IN VARCHAR2 DEFAULT NULL
199 , p_attribute8 IN VARCHAR2 DEFAULT NULL
200 , p_attribute9 IN VARCHAR2 DEFAULT NULL
201 , p_attribute10 IN VARCHAR2 DEFAULT NULL
202 , p_attribute11 IN VARCHAR2 DEFAULT NULL
203 , p_attribute12 IN VARCHAR2 DEFAULT NULL
204 , p_attribute13 IN VARCHAR2 DEFAULT NULL
205 , p_attribute14 IN VARCHAR2 DEFAULT NULL
206 , p_attribute15 IN VARCHAR2 DEFAULT NULL
207 , p_attribute_category IN VARCHAR2 DEFAULT NULL
208 , p_date_selected IN VARCHAR2 DEFAULT NULL
209 , p_category_id IN NUMBER DEFAULT NULL
210 , p_show_on_calendar IN VARCHAR2 DEFAULT NULL
211 , p_owner_status_id IN NUMBER DEFAULT NULL
212 , p_template_id IN NUMBER DEFAULT NULL
213 , p_template_group_id IN NUMBER DEFAULT NULL
214 , p_enable_workflow IN VARCHAR2
215 , p_abort_workflow IN VARCHAR2
216 , p_entity IN VARCHAR2
217 , p_free_busy_type IN VARCHAR2
218 );
219
220 -- The overloaded version with Location Id.
221 PROCEDURE create_task(
222 p_api_version IN NUMBER
223 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
224 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
225 , p_task_id IN NUMBER DEFAULT NULL
226 , p_task_name IN VARCHAR2
227 , p_task_type_id IN NUMBER DEFAULT NULL
228 , p_description IN VARCHAR2 DEFAULT NULL
229 , p_task_status_id IN NUMBER DEFAULT NULL
230 , p_task_priority_id IN NUMBER DEFAULT NULL
231 , p_owner_type_code IN VARCHAR2 DEFAULT NULL
232 , p_owner_id IN NUMBER DEFAULT NULL
233 , p_owner_territory_id IN NUMBER DEFAULT NULL
234 , p_assigned_by_id IN NUMBER DEFAULT NULL
235 , p_customer_id IN NUMBER DEFAULT NULL
236 , p_cust_account_id IN NUMBER DEFAULT NULL
237 , p_address_id IN NUMBER DEFAULT NULL
238 , ---- hz_party_sites
239 p_planned_start_date IN DATE DEFAULT NULL
240 , p_planned_end_date IN DATE DEFAULT NULL
241 , p_scheduled_start_date IN DATE DEFAULT NULL
242 , p_scheduled_end_date IN DATE DEFAULT NULL
243 , p_actual_start_date IN DATE DEFAULT NULL
244 , p_actual_end_date IN DATE DEFAULT NULL
245 , p_timezone_id IN NUMBER DEFAULT NULL
246 , p_source_object_type_code IN VARCHAR2 DEFAULT NULL
247 , p_source_object_id IN NUMBER DEFAULT NULL
248 , p_source_object_name IN VARCHAR2 DEFAULT NULL
249 , p_duration IN NUMBER DEFAULT NULL
250 , p_duration_uom IN VARCHAR2 DEFAULT NULL
251 , p_planned_effort IN NUMBER DEFAULT NULL
252 , p_planned_effort_uom IN VARCHAR2 DEFAULT NULL
253 , p_actual_effort IN NUMBER DEFAULT NULL
254 , p_actual_effort_uom IN VARCHAR2 DEFAULT NULL
255 , p_percentage_complete IN NUMBER DEFAULT NULL
256 , p_reason_code IN VARCHAR2 DEFAULT NULL
257 , p_private_flag IN VARCHAR2 DEFAULT NULL
258 , p_publish_flag IN VARCHAR2 DEFAULT NULL
259 , p_restrict_closure_flag IN VARCHAR2 DEFAULT NULL
260 , p_multi_booked_flag IN VARCHAR2 DEFAULT NULL
261 , p_milestone_flag IN VARCHAR2 DEFAULT NULL
262 , p_holiday_flag IN VARCHAR2 DEFAULT NULL
263 , p_billable_flag IN VARCHAR2 DEFAULT NULL
264 , p_bound_mode_code IN VARCHAR2 DEFAULT NULL
265 , p_soft_bound_flag IN VARCHAR2 DEFAULT NULL
269 , p_notification_period_uom IN VARCHAR2 DEFAULT NULL
266 , p_workflow_process_id IN NUMBER DEFAULT NULL
267 , p_notification_flag IN VARCHAR2 DEFAULT NULL
268 , p_notification_period IN NUMBER DEFAULT NULL
270 , p_parent_task_id IN NUMBER DEFAULT NULL
271 , p_alarm_start IN NUMBER DEFAULT NULL
272 , p_alarm_start_uom IN VARCHAR2 DEFAULT NULL
273 , p_alarm_on IN VARCHAR2 DEFAULT NULL
274 , p_alarm_count IN NUMBER DEFAULT NULL
275 , p_alarm_interval IN NUMBER DEFAULT NULL
276 , p_alarm_interval_uom IN VARCHAR2 DEFAULT NULL
277 , p_palm_flag IN VARCHAR2 DEFAULT NULL
278 , p_wince_flag IN VARCHAR2 DEFAULT NULL
279 , p_laptop_flag IN VARCHAR2 DEFAULT NULL
280 , p_device1_flag IN VARCHAR2 DEFAULT NULL
281 , p_device2_flag IN VARCHAR2 DEFAULT NULL
282 , p_device3_flag IN VARCHAR2 DEFAULT NULL
283 , p_costs IN NUMBER DEFAULT NULL
284 , p_currency_code IN VARCHAR2 DEFAULT NULL
285 , p_escalation_level IN VARCHAR2 DEFAULT NULL
286 , x_return_status OUT NOCOPY VARCHAR2
287 , x_msg_count OUT NOCOPY NUMBER
288 , x_msg_data OUT NOCOPY VARCHAR2
289 , x_task_id OUT NOCOPY NUMBER
290 , p_attribute1 IN VARCHAR2 DEFAULT NULL
291 , p_attribute2 IN VARCHAR2 DEFAULT NULL
292 , p_attribute3 IN VARCHAR2 DEFAULT NULL
293 , p_attribute4 IN VARCHAR2 DEFAULT NULL
294 , p_attribute5 IN VARCHAR2 DEFAULT NULL
295 , p_attribute6 IN VARCHAR2 DEFAULT NULL
296 , p_attribute7 IN VARCHAR2 DEFAULT NULL
297 , p_attribute8 IN VARCHAR2 DEFAULT NULL
298 , p_attribute9 IN VARCHAR2 DEFAULT NULL
299 , p_attribute10 IN VARCHAR2 DEFAULT NULL
300 , p_attribute11 IN VARCHAR2 DEFAULT NULL
301 , p_attribute12 IN VARCHAR2 DEFAULT NULL
302 , p_attribute13 IN VARCHAR2 DEFAULT NULL
303 , p_attribute14 IN VARCHAR2 DEFAULT NULL
304 , p_attribute15 IN VARCHAR2 DEFAULT NULL
305 , p_attribute_category IN VARCHAR2 DEFAULT NULL
306 , p_date_selected IN VARCHAR2 DEFAULT NULL
307 , p_category_id IN NUMBER DEFAULT NULL
308 , p_show_on_calendar IN VARCHAR2 DEFAULT NULL
309 , p_owner_status_id IN NUMBER DEFAULT NULL
310 , p_template_id IN NUMBER DEFAULT NULL
311 , p_template_group_id IN NUMBER DEFAULT NULL
312 , p_enable_workflow IN VARCHAR2
313 , p_abort_workflow IN VARCHAR2
314 , p_entity IN VARCHAR2
315 , p_free_busy_type IN VARCHAR2
316 , p_task_confirmation_status IN VARCHAR2
317 , p_task_confirmation_counter IN NUMBER
318 , p_task_split_flag IN VARCHAR2
319 , p_reference_flag IN VARCHAR2 DEFAULT NULL
320 , p_child_position IN VARCHAR2 DEFAULT NULL
321 , p_child_sequence_num IN NUMBER DEFAULT NULL
322 , p_location_id IN NUMBER
323 , p_copied_from_task_id IN NUMBER DEFAULT NULL
324 );
325
326 -- The overloaded version with Simplex Changes.
327 PROCEDURE create_task(
328 p_api_version IN NUMBER
329 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
330 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
331 , p_task_id IN NUMBER DEFAULT NULL
332 , p_task_name IN VARCHAR2
333 , p_task_type_id IN NUMBER DEFAULT NULL
334 , p_description IN VARCHAR2 DEFAULT NULL
335 , p_task_status_id IN NUMBER DEFAULT NULL
336 , p_task_priority_id IN NUMBER DEFAULT NULL
337 , p_owner_type_code IN VARCHAR2 DEFAULT NULL
338 , p_owner_id IN NUMBER DEFAULT NULL
339 , p_owner_territory_id IN NUMBER DEFAULT NULL
340 , p_assigned_by_id IN NUMBER DEFAULT NULL
341 , p_customer_id IN NUMBER DEFAULT NULL
342 , p_cust_account_id IN NUMBER DEFAULT NULL
343 , p_address_id IN NUMBER DEFAULT NULL
344 , ---- hz_party_sites
345 p_planned_start_date IN DATE DEFAULT NULL
346 , p_planned_end_date IN DATE DEFAULT NULL
347 , p_scheduled_start_date IN DATE DEFAULT NULL
348 , p_scheduled_end_date IN DATE DEFAULT NULL
349 , p_actual_start_date IN DATE DEFAULT NULL
350 , p_actual_end_date IN DATE DEFAULT NULL
351 , p_timezone_id IN NUMBER DEFAULT NULL
352 , p_source_object_type_code IN VARCHAR2 DEFAULT NULL
353 , p_source_object_id IN NUMBER DEFAULT NULL
354 , p_source_object_name IN VARCHAR2 DEFAULT NULL
358 , p_planned_effort_uom IN VARCHAR2 DEFAULT NULL
355 , p_duration IN NUMBER DEFAULT NULL
356 , p_duration_uom IN VARCHAR2 DEFAULT NULL
357 , p_planned_effort IN NUMBER DEFAULT NULL
359 , p_actual_effort IN NUMBER DEFAULT NULL
360 , p_actual_effort_uom IN VARCHAR2 DEFAULT NULL
361 , p_percentage_complete IN NUMBER DEFAULT NULL
362 , p_reason_code IN VARCHAR2 DEFAULT NULL
363 , p_private_flag IN VARCHAR2 DEFAULT NULL
364 , p_publish_flag IN VARCHAR2 DEFAULT NULL
365 , p_restrict_closure_flag IN VARCHAR2 DEFAULT NULL
366 , p_multi_booked_flag IN VARCHAR2 DEFAULT NULL
367 , p_milestone_flag IN VARCHAR2 DEFAULT NULL
368 , p_holiday_flag IN VARCHAR2 DEFAULT NULL
369 , p_billable_flag IN VARCHAR2 DEFAULT NULL
370 , p_bound_mode_code IN VARCHAR2 DEFAULT NULL
371 , p_soft_bound_flag IN VARCHAR2 DEFAULT NULL
372 , p_workflow_process_id IN NUMBER DEFAULT NULL
373 , p_notification_flag IN VARCHAR2 DEFAULT NULL
374 , p_notification_period IN NUMBER DEFAULT NULL
375 , p_notification_period_uom IN VARCHAR2 DEFAULT NULL
376 , p_parent_task_id IN NUMBER DEFAULT NULL
377 , p_alarm_start IN NUMBER DEFAULT NULL
378 , p_alarm_start_uom IN VARCHAR2 DEFAULT NULL
379 , p_alarm_on IN VARCHAR2 DEFAULT NULL
380 , p_alarm_count IN NUMBER DEFAULT NULL
381 , p_alarm_interval IN NUMBER DEFAULT NULL
382 , p_alarm_interval_uom IN VARCHAR2 DEFAULT NULL
383 , p_palm_flag IN VARCHAR2 DEFAULT NULL
384 , p_wince_flag IN VARCHAR2 DEFAULT NULL
385 , p_laptop_flag IN VARCHAR2 DEFAULT NULL
386 , p_device1_flag IN VARCHAR2 DEFAULT NULL
387 , p_device2_flag IN VARCHAR2 DEFAULT NULL
388 , p_device3_flag IN VARCHAR2 DEFAULT NULL
389 , p_costs IN NUMBER DEFAULT NULL
390 , p_currency_code IN VARCHAR2 DEFAULT NULL
391 , p_escalation_level IN VARCHAR2 DEFAULT NULL
392 , x_return_status OUT NOCOPY VARCHAR2
393 , x_msg_count OUT NOCOPY NUMBER
394 , x_msg_data OUT NOCOPY VARCHAR2
395 , x_task_id OUT NOCOPY NUMBER
396 , p_attribute1 IN VARCHAR2 DEFAULT NULL
397 , p_attribute2 IN VARCHAR2 DEFAULT NULL
398 , p_attribute3 IN VARCHAR2 DEFAULT NULL
399 , p_attribute4 IN VARCHAR2 DEFAULT NULL
400 , p_attribute5 IN VARCHAR2 DEFAULT NULL
401 , p_attribute6 IN VARCHAR2 DEFAULT NULL
402 , p_attribute7 IN VARCHAR2 DEFAULT NULL
403 , p_attribute8 IN VARCHAR2 DEFAULT NULL
404 , p_attribute9 IN VARCHAR2 DEFAULT NULL
405 , p_attribute10 IN VARCHAR2 DEFAULT NULL
406 , p_attribute11 IN VARCHAR2 DEFAULT NULL
407 , p_attribute12 IN VARCHAR2 DEFAULT NULL
408 , p_attribute13 IN VARCHAR2 DEFAULT NULL
409 , p_attribute14 IN VARCHAR2 DEFAULT NULL
410 , p_attribute15 IN VARCHAR2 DEFAULT NULL
411 , p_attribute_category IN VARCHAR2 DEFAULT NULL
412 , p_date_selected IN VARCHAR2 DEFAULT NULL
413 , p_category_id IN NUMBER DEFAULT NULL
414 , p_show_on_calendar IN VARCHAR2 DEFAULT NULL
415 , p_owner_status_id IN NUMBER DEFAULT NULL
416 , p_template_id IN NUMBER DEFAULT NULL
417 , p_template_group_id IN NUMBER DEFAULT NULL
418 , p_enable_workflow IN VARCHAR2
419 , p_abort_workflow IN VARCHAR2
420 , p_entity IN VARCHAR2
421 , p_free_busy_type IN VARCHAR2
422 , p_task_confirmation_status IN VARCHAR2
423 , p_task_confirmation_counter IN NUMBER
424 , p_task_split_flag IN VARCHAR2
425 , p_reference_flag IN VARCHAR2 DEFAULT NULL
426 , p_child_position IN VARCHAR2 DEFAULT NULL
427 , p_child_sequence_num IN NUMBER DEFAULT NULL
428 );
429
430 -- old version
431 PROCEDURE create_task(
432 p_api_version IN NUMBER
433 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
434 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
435 , p_task_id IN NUMBER DEFAULT NULL
436 , p_task_name IN VARCHAR2
437 , p_task_type_id IN NUMBER DEFAULT NULL
438 , p_description IN VARCHAR2 DEFAULT NULL
439 , p_task_status_id IN NUMBER DEFAULT NULL
440 , p_task_priority_id IN NUMBER DEFAULT NULL
441 , p_owner_type_code IN VARCHAR2 DEFAULT NULL
442 , p_owner_id IN NUMBER DEFAULT NULL
446 , p_cust_account_id IN NUMBER DEFAULT NULL
443 , p_owner_territory_id IN NUMBER DEFAULT NULL
444 , p_assigned_by_id IN NUMBER DEFAULT NULL
445 , p_customer_id IN NUMBER DEFAULT NULL
447 , p_address_id IN NUMBER DEFAULT NULL
448 , ---- hz_party_sites
449 p_planned_start_date IN DATE DEFAULT NULL
450 , p_planned_end_date IN DATE DEFAULT NULL
451 , p_scheduled_start_date IN DATE DEFAULT NULL
452 , p_scheduled_end_date IN DATE DEFAULT NULL
453 , p_actual_start_date IN DATE DEFAULT NULL
454 , p_actual_end_date IN DATE DEFAULT NULL
455 , p_timezone_id IN NUMBER DEFAULT NULL
456 , p_source_object_type_code IN VARCHAR2 DEFAULT NULL
457 , p_source_object_id IN NUMBER DEFAULT NULL
458 , p_source_object_name IN VARCHAR2 DEFAULT NULL
459 , p_duration IN NUMBER DEFAULT NULL
460 , p_duration_uom IN VARCHAR2 DEFAULT NULL
461 , p_planned_effort IN NUMBER DEFAULT NULL
462 , p_planned_effort_uom IN VARCHAR2 DEFAULT NULL
463 , p_actual_effort IN NUMBER DEFAULT NULL
464 , p_actual_effort_uom IN VARCHAR2 DEFAULT NULL
465 , p_percentage_complete IN NUMBER DEFAULT NULL
466 , p_reason_code IN VARCHAR2 DEFAULT NULL
467 , p_private_flag IN VARCHAR2 DEFAULT NULL
468 , p_publish_flag IN VARCHAR2 DEFAULT NULL
469 , p_restrict_closure_flag IN VARCHAR2 DEFAULT NULL
470 , p_multi_booked_flag IN VARCHAR2 DEFAULT NULL
471 , p_milestone_flag IN VARCHAR2 DEFAULT NULL
472 , p_holiday_flag IN VARCHAR2 DEFAULT NULL
473 , p_billable_flag IN VARCHAR2 DEFAULT NULL
474 , p_bound_mode_code IN VARCHAR2 DEFAULT NULL
475 , p_soft_bound_flag IN VARCHAR2 DEFAULT NULL
476 , p_workflow_process_id IN NUMBER DEFAULT NULL
477 , p_notification_flag IN VARCHAR2 DEFAULT NULL
478 , p_notification_period IN NUMBER DEFAULT NULL
479 , p_notification_period_uom IN VARCHAR2 DEFAULT NULL
480 , p_parent_task_id IN NUMBER DEFAULT NULL
481 , p_alarm_start IN NUMBER DEFAULT NULL
482 , p_alarm_start_uom IN VARCHAR2 DEFAULT NULL
483 , p_alarm_on IN VARCHAR2 DEFAULT NULL
484 , p_alarm_count IN NUMBER DEFAULT NULL
485 , p_alarm_interval IN NUMBER DEFAULT NULL
486 , p_alarm_interval_uom IN VARCHAR2 DEFAULT NULL
487 , p_palm_flag IN VARCHAR2 DEFAULT NULL
488 , p_wince_flag IN VARCHAR2 DEFAULT NULL
489 , p_laptop_flag IN VARCHAR2 DEFAULT NULL
490 , p_device1_flag IN VARCHAR2 DEFAULT NULL
491 , p_device2_flag IN VARCHAR2 DEFAULT NULL
492 , p_device3_flag IN VARCHAR2 DEFAULT NULL
493 , p_costs IN NUMBER DEFAULT NULL
494 , p_currency_code IN VARCHAR2 DEFAULT NULL
495 , p_escalation_level IN VARCHAR2 DEFAULT NULL
496 , x_return_status OUT NOCOPY VARCHAR2
497 , x_msg_count OUT NOCOPY NUMBER
498 , x_msg_data OUT NOCOPY VARCHAR2
499 , x_task_id OUT NOCOPY NUMBER
500 , p_attribute1 IN VARCHAR2 DEFAULT NULL
501 , p_attribute2 IN VARCHAR2 DEFAULT NULL
502 , p_attribute3 IN VARCHAR2 DEFAULT NULL
503 , p_attribute4 IN VARCHAR2 DEFAULT NULL
504 , p_attribute5 IN VARCHAR2 DEFAULT NULL
505 , p_attribute6 IN VARCHAR2 DEFAULT NULL
506 , p_attribute7 IN VARCHAR2 DEFAULT NULL
507 , p_attribute8 IN VARCHAR2 DEFAULT NULL
508 , p_attribute9 IN VARCHAR2 DEFAULT NULL
509 , p_attribute10 IN VARCHAR2 DEFAULT NULL
510 , p_attribute11 IN VARCHAR2 DEFAULT NULL
511 , p_attribute12 IN VARCHAR2 DEFAULT NULL
512 , p_attribute13 IN VARCHAR2 DEFAULT NULL
513 , p_attribute14 IN VARCHAR2 DEFAULT NULL
514 , p_attribute15 IN VARCHAR2 DEFAULT NULL
515 , p_attribute_category IN VARCHAR2 DEFAULT NULL
516 , p_date_selected IN VARCHAR2 DEFAULT NULL
517 , p_category_id IN NUMBER DEFAULT NULL
518 , p_show_on_calendar IN VARCHAR2 DEFAULT NULL
519 , p_owner_status_id IN NUMBER DEFAULT NULL
520 , p_template_id IN NUMBER DEFAULT NULL
521 , p_template_group_id IN NUMBER DEFAULT NULL
522 );
523
524 -- This now supports to update the repeating appointments
525 PROCEDURE update_task(
526 p_api_version IN NUMBER
527 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
528 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
529 , p_object_version_number IN OUT NOCOPY NUMBER
530 , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
531 , p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
535 , p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num
532 , p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
533 , p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char
534 , p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
536 , p_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
537 , p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num
538 , p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num
539 , p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num
540 , p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num
541 , p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num
542 , p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num
543 , ---- hz_party_sites
544 p_planned_start_date IN DATE DEFAULT fnd_api.g_miss_date
545 , p_planned_end_date IN DATE DEFAULT fnd_api.g_miss_date
546 , p_scheduled_start_date IN DATE DEFAULT fnd_api.g_miss_date
547 , p_scheduled_end_date IN DATE DEFAULT fnd_api.g_miss_date
548 , p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date
549 , p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date
550 , p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num
551 , p_source_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
552 , p_source_object_id IN NUMBER DEFAULT fnd_api.g_miss_num
553 , p_source_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
554 , p_duration IN NUMBER DEFAULT fnd_api.g_miss_num
555 , p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
556 , p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num
557 , p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
558 , p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num
559 , p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
560 , p_percentage_complete IN NUMBER DEFAULT fnd_api.g_miss_num
561 , p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
562 , p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
563 , p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
564 , p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
565 , p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
566 , p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
567 , p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
568 , p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
569 , p_bound_mode_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
570 , p_soft_bound_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
571 , p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num
572 , p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
573 , p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num
574 , p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
575 , p_parent_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
576 , p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num
577 , p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
578 , p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char
579 , p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num
580 , p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num
581 , p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num
582 , p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
583 , p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
584 , p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
585 , p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
586 , p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
587 , p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
588 , p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
589 , p_costs IN NUMBER DEFAULT fnd_api.g_miss_num
590 , p_currency_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
591 , p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char
592 , x_return_status OUT NOCOPY VARCHAR2
593 , x_msg_count OUT NOCOPY NUMBER
594 , x_msg_data OUT NOCOPY VARCHAR2
595 , p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
596 , p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
597 , p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
598 , p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
599 , p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
600 , p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
601 , p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
602 , p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
603 , p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
604 , p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
605 , p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
609 , p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
606 , p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
607 , p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
608 , p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
610 , p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
611 , p_date_selected IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
612 , p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
613 , p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
614 , p_owner_status_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
615 , p_enable_workflow IN VARCHAR2
616 , p_abort_workflow IN VARCHAR2
617 , p_change_mode IN VARCHAR2
618 );
619
620 -- The overloaded version which added p_enable_workflow and p_abort_workflow
621 PROCEDURE update_task(
622 p_api_version IN NUMBER
623 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
624 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
625 , p_object_version_number IN OUT NOCOPY NUMBER
626 , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
627 , p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
628 , p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
629 , p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char
630 , p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
631 , p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num
632 , p_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
633 , p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num
634 , p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num
635 , p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num
636 , p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num
637 , p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num
638 , p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num
639 , ---- hz_party_sites
640 p_planned_start_date IN DATE DEFAULT fnd_api.g_miss_date
641 , p_planned_end_date IN DATE DEFAULT fnd_api.g_miss_date
642 , p_scheduled_start_date IN DATE DEFAULT fnd_api.g_miss_date
643 , p_scheduled_end_date IN DATE DEFAULT fnd_api.g_miss_date
644 , p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date
645 , p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date
646 , p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num
647 , p_source_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
648 , p_source_object_id IN NUMBER DEFAULT fnd_api.g_miss_num
649 , p_source_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
650 , p_duration IN NUMBER DEFAULT fnd_api.g_miss_num
651 , p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
652 , p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num
653 , p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
654 , p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num
655 , p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
656 , p_percentage_complete IN NUMBER DEFAULT fnd_api.g_miss_num
657 , p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
658 , p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
659 , p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
660 , p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
661 , p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
662 , p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
663 , p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
664 , p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
665 , p_bound_mode_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
666 , p_soft_bound_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
667 , p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num
668 , p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
669 , p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num
670 , p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
671 , p_parent_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
672 , p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num
673 , p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
674 , p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char
675 , p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num
676 , p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num
677 , p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num
678 , p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
679 , p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
680 , p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
684 , p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
681 , p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
682 , p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
683 , p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
685 , p_costs IN NUMBER DEFAULT fnd_api.g_miss_num
686 , p_currency_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
687 , p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char
688 , x_return_status OUT NOCOPY VARCHAR2
689 , x_msg_count OUT NOCOPY NUMBER
690 , x_msg_data OUT NOCOPY VARCHAR2
691 , p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
692 , p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
693 , p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
694 , p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
695 , p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
696 , p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
697 , p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
698 , p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
699 , p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
700 , p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
701 , p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
702 , p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
703 , p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
704 , p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
705 , p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
706 , p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
707 , p_date_selected IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
708 , p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
709 , p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
710 , p_owner_status_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
711 , p_enable_workflow IN VARCHAR2
712 , p_abort_workflow IN VARCHAR2
713 , p_change_mode IN VARCHAR2
714 , p_free_busy_type IN VARCHAR2
715 );
716
717 --Location Id Enhancements....
718 PROCEDURE update_task(
719 p_api_version IN NUMBER
720 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
721 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
722 , p_object_version_number IN OUT NOCOPY NUMBER
723 , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
724 , p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
725 , p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
726 , p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char
727 , p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
728 , p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num
729 , p_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
730 , p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num
731 , p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num
732 , p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num
733 , p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num
734 , p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num
735 , p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num
736 , ---- hz_party_sites
737 p_planned_start_date IN DATE DEFAULT fnd_api.g_miss_date
738 , p_planned_end_date IN DATE DEFAULT fnd_api.g_miss_date
739 , p_scheduled_start_date IN DATE DEFAULT fnd_api.g_miss_date
740 , p_scheduled_end_date IN DATE DEFAULT fnd_api.g_miss_date
741 , p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date
742 , p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date
743 , p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num
744 , p_source_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
745 , p_source_object_id IN NUMBER DEFAULT fnd_api.g_miss_num
746 , p_source_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
747 , p_duration IN NUMBER DEFAULT fnd_api.g_miss_num
748 , p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
749 , p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num
750 , p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
751 , p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num
752 , p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
753 , p_percentage_complete IN NUMBER DEFAULT fnd_api.g_miss_num
754 , p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
755 , p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
756 , p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
760 , p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
757 , p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
758 , p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
759 , p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
761 , p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
762 , p_bound_mode_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
763 , p_soft_bound_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
764 , p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num
765 , p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
766 , p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num
767 , p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
768 , p_parent_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
769 , p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num
770 , p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
771 , p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char
772 , p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num
773 , p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num
774 , p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num
775 , p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
776 , p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
777 , p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
778 , p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
779 , p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
780 , p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
781 , p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
782 , p_costs IN NUMBER DEFAULT fnd_api.g_miss_num
783 , p_currency_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
784 , p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char
785 , x_return_status OUT NOCOPY VARCHAR2
786 , x_msg_count OUT NOCOPY NUMBER
787 , x_msg_data OUT NOCOPY VARCHAR2
788 , p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
789 , p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
790 , p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
791 , p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
792 , p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
793 , p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
794 , p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
795 , p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
796 , p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
797 , p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
798 , p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
799 , p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
800 , p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
801 , p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
802 , p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
803 , p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
804 , p_date_selected IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
805 , p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
806 , p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
807 , p_owner_status_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
808 , p_enable_workflow IN VARCHAR2
809 , p_abort_workflow IN VARCHAR2
810 , p_change_mode IN VARCHAR2
811 , p_free_busy_type IN VARCHAR2
812 , p_task_confirmation_status IN VARCHAR2
813 , p_task_confirmation_counter IN NUMBER
814 , p_task_split_flag IN VARCHAR2
815 , p_child_position IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
816 , p_child_sequence_num IN NUMBER DEFAULT jtf_task_utl.g_miss_number
817 , p_location_id IN NUMBER
818 );
819
820 --Simplex Enhancements....
821 PROCEDURE update_task(
822 p_api_version IN NUMBER
823 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
824 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
825 , p_object_version_number IN OUT NOCOPY NUMBER
826 , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
827 , p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
828 , p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
829 , p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char
830 , p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
831 , p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num
832 , p_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
833 , p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num
834 , p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num
835 , p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num
836 , p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num
837 , p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num
838 , p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num
839 , ---- hz_party_sites
840 p_planned_start_date IN DATE DEFAULT fnd_api.g_miss_date
841 , p_planned_end_date IN DATE DEFAULT fnd_api.g_miss_date
842 , p_scheduled_start_date IN DATE DEFAULT fnd_api.g_miss_date
843 , p_scheduled_end_date IN DATE DEFAULT fnd_api.g_miss_date
844 , p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date
845 , p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date
846 , p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num
847 , p_source_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
848 , p_source_object_id IN NUMBER DEFAULT fnd_api.g_miss_num
849 , p_source_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
850 , p_duration IN NUMBER DEFAULT fnd_api.g_miss_num
851 , p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
852 , p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num
853 , p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
854 , p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num
855 , p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
856 , p_percentage_complete IN NUMBER DEFAULT fnd_api.g_miss_num
857 , p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
858 , p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
859 , p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
860 , p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
861 , p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
862 , p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
863 , p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
864 , p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
865 , p_bound_mode_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
866 , p_soft_bound_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
867 , p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num
868 , p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
869 , p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num
870 , p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
871 , p_parent_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
872 , p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num
873 , p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
874 , p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char
875 , p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num
876 , p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num
877 , p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num
878 , p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
879 , p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
880 , p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
881 , p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
882 , p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
883 , p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
884 , p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
885 , p_costs IN NUMBER DEFAULT fnd_api.g_miss_num
886 , p_currency_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
887 , p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char
891 , p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
888 , x_return_status OUT NOCOPY VARCHAR2
889 , x_msg_count OUT NOCOPY NUMBER
890 , x_msg_data OUT NOCOPY VARCHAR2
892 , p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
893 , p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
894 , p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
895 , p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
896 , p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
897 , p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
898 , p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
899 , p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
900 , p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
901 , p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
902 , p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
903 , p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
904 , p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
905 , p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
906 , p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
907 , p_date_selected IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
908 , p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
909 , p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
910 , p_owner_status_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
911 , p_enable_workflow IN VARCHAR2
912 , p_abort_workflow IN VARCHAR2
913 , p_change_mode IN VARCHAR2
914 , p_free_busy_type IN VARCHAR2
915 , p_task_confirmation_status IN VARCHAR2
916 , p_task_confirmation_counter IN NUMBER
917 , p_task_split_flag IN VARCHAR2
918 , p_child_position IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
919 , p_child_sequence_num IN NUMBER DEFAULT jtf_task_utl.g_miss_number
920 );
921
922 PROCEDURE update_task(
923 p_api_version IN NUMBER
924 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
925 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
926 , p_object_version_number IN OUT NOCOPY NUMBER
927 , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
928 , p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
929 , p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
930 , p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char
931 , p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
932 , p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num
933 , p_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
934 , p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num
935 , p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num
936 , p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num
937 , p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num
938 , p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num
939 , p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num
940 , ---- hz_party_sites
941 p_planned_start_date IN DATE DEFAULT fnd_api.g_miss_date
942 , p_planned_end_date IN DATE DEFAULT fnd_api.g_miss_date
943 , p_scheduled_start_date IN DATE DEFAULT fnd_api.g_miss_date
944 , p_scheduled_end_date IN DATE DEFAULT fnd_api.g_miss_date
945 , p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date
946 , p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date
947 , p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num
948 , p_source_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
949 , p_source_object_id IN NUMBER DEFAULT fnd_api.g_miss_num
950 , p_source_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
951 , p_duration IN NUMBER DEFAULT fnd_api.g_miss_num
952 , p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
953 , p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num
954 , p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
955 , p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num
956 , p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
957 , p_percentage_complete IN NUMBER DEFAULT fnd_api.g_miss_num
958 , p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
959 , p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
960 , p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
961 , p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
962 , p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
963 , p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
964 , p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
965 , p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
966 , p_bound_mode_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
967 , p_soft_bound_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
968 , p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num
969 , p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
970 , p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num
971 , p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
972 , p_parent_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
973 , p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num
974 , p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
975 , p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char
976 , p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num
977 , p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num
978 , p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num
982 , p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
979 , p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
980 , p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
981 , p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
983 , p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
984 , p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
985 , p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
986 , p_costs IN NUMBER DEFAULT fnd_api.g_miss_num
987 , p_currency_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
988 , p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char
989 , x_return_status OUT NOCOPY VARCHAR2
990 , x_msg_count OUT NOCOPY NUMBER
991 , x_msg_data OUT NOCOPY VARCHAR2
992 , p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
993 , p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
997 , p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
994 , p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
995 , p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
996 , p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
998 , p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
999 , p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1000 , p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1001 , p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1002 , p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1003 , p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1004 , p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1005 , p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1006 , p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1007 , p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1008 , p_date_selected IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1009 , p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
1010 , p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1011 , p_owner_status_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
1012 , p_enable_workflow IN VARCHAR2
1013 , p_abort_workflow IN VARCHAR2
1014 );
1015
1016 -- old version
1017 PROCEDURE update_task(
1018 p_api_version IN NUMBER
1019 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1020 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
1021 , p_object_version_number IN OUT NOCOPY NUMBER
1022 , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
1023 , p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1024 , p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
1025 , p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1026 , p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
1027 , p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num
1028 , p_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1029 , p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num
1030 , p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num
1031 , p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num
1032 , p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num
1033 , p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num
1034 , p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num
1035 , ---- hz_party_sites
1036 p_planned_start_date IN DATE DEFAULT fnd_api.g_miss_date
1037 , p_planned_end_date IN DATE DEFAULT fnd_api.g_miss_date
1038 , p_scheduled_start_date IN DATE DEFAULT fnd_api.g_miss_date
1039 , p_scheduled_end_date IN DATE DEFAULT fnd_api.g_miss_date
1040 , p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date
1041 , p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date
1042 , p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num
1043 , p_source_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1044 , p_source_object_id IN NUMBER DEFAULT fnd_api.g_miss_num
1045 , p_source_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1046 , p_duration IN NUMBER DEFAULT fnd_api.g_miss_num
1047 , p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1048 , p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num
1049 , p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1050 , p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num
1051 , p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1052 , p_percentage_complete IN NUMBER DEFAULT fnd_api.g_miss_num
1053 , p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1054 , p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1055 , p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1056 , p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1057 , p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1061 , p_bound_mode_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1058 , p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1059 , p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1060 , p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1062 , p_soft_bound_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1063 , p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num
1064 , p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1065 , p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num
1066 , p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1067 , p_parent_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
1068 , p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num
1069 , p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1070 , p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1071 , p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num
1072 , p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num
1073 , p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num
1074 , p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1075 , p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1076 , p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1077 , p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1078 , p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1079 , p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1080 , p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1081 , p_costs IN NUMBER DEFAULT fnd_api.g_miss_num
1082 , p_currency_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1083 , p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1084 , x_return_status OUT NOCOPY VARCHAR2
1085 , x_msg_count OUT NOCOPY NUMBER
1086 , x_msg_data OUT NOCOPY VARCHAR2
1087 , p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1088 , p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1089 , p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1090 , p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1091 , p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1092 , p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1093 , p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1094 , p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1095 , p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1096 , p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1097 , p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1098 , p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1099 , p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1100 , p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1101 , p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1102 , p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1103 , p_date_selected IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1104 , p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
1105 , p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1106 , p_owner_status_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
1107 );
1108
1109 -- The overloaded version which added p_enable_workflow and p_abort_workflow
1110 PROCEDURE delete_task(
1111 p_api_version IN NUMBER
1112 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1113 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
1114 , p_object_version_number IN NUMBER
1115 , p_task_id IN NUMBER
1116 , p_delete_future_recurrences IN VARCHAR2 DEFAULT fnd_api.g_false
1117 , x_return_status OUT NOCOPY VARCHAR2
1118 , x_msg_count OUT NOCOPY NUMBER
1119 , x_msg_data OUT NOCOPY VARCHAR2
1120 , p_enable_workflow IN VARCHAR2
1121 , p_abort_workflow IN VARCHAR2
1122 );
1123
1124 -- Old version
1125 PROCEDURE delete_task(
1126 p_api_version IN NUMBER
1127 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1128 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
1129 , p_object_version_number IN NUMBER
1130 , p_task_id IN NUMBER
1131 , p_delete_future_recurrences IN VARCHAR2 DEFAULT fnd_api.g_false
1132 , x_return_status OUT NOCOPY VARCHAR2
1133 , x_msg_count OUT NOCOPY NUMBER
1134 , x_msg_data OUT NOCOPY VARCHAR2
1135 );
1136
1137 PROCEDURE export_file(
1138 p_path IN VARCHAR2
1139 , p_file_name IN VARCHAR2
1140 , p_task_table IN jtf_tasks_pub.task_table_type
1141 , x_return_status OUT NOCOPY VARCHAR2
1142 , x_msg_count OUT NOCOPY NUMBER
1143 , x_msg_data OUT NOCOPY VARCHAR2
1144 );
1145
1146 PROCEDURE query_task(
1147 p_object_version_number IN NUMBER
1148 , p_task_id IN jtf_tasks_v.task_id%TYPE
1149 , p_description IN jtf_tasks_v.description%TYPE
1153 , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
1150 , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
1151 , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
1152 , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
1154 , p_owner_id IN jtf_tasks_v.owner_id%TYPE
1155 , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
1156 , p_address_id IN jtf_tasks_v.address_id%TYPE
1157 , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1158 , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1159 , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1160 , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
1161 , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
1162 , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
1163 , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
1164 , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
1165 , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
1166 , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
1167 , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
1168 , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
1169 , p_reason_code IN jtf_tasks_v.reason_code%TYPE
1170 , p_private_flag IN jtf_tasks_v.private_flag%TYPE
1171 , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
1172 , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
1173 , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
1174 , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
1175 , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
1176 , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
1177 , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
1178 , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
1179 , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
1180 , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
1181 , p_ref_object_id IN NUMBER
1182 , p_ref_object_type_code IN VARCHAR2
1183 , p_task_name IN jtf_tasks_v.task_name%TYPE
1184 , p_sort_data IN jtf_tasks_pub.sort_data
1185 , p_start_pointer IN NUMBER
1186 , p_rec_wanted IN NUMBER
1187 , p_show_all IN VARCHAR2
1188 , p_query_or_next_code IN VARCHAR2 DEFAULT 'Q'
1189 , x_task_table OUT NOCOPY jtf_tasks_pub.task_table_type
1190 , x_total_retrieved OUT NOCOPY NUMBER
1191 , x_total_returned OUT NOCOPY NUMBER
1192 , x_return_status OUT NOCOPY VARCHAR2
1193 , x_msg_count OUT NOCOPY NUMBER
1194 , x_msg_data OUT NOCOPY VARCHAR2
1195 , p_location_id IN NUMBER
1196 );
1197
1198 PROCEDURE query_task(
1199 p_object_version_number IN NUMBER
1200 , p_task_id IN jtf_tasks_v.task_id%TYPE
1201 , p_description IN jtf_tasks_v.description%TYPE
1202 , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE
1203 , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE
1204 , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE
1205 , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE
1206 , p_owner_id IN jtf_tasks_v.owner_id%TYPE
1207 , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE
1208 , p_address_id IN jtf_tasks_v.address_id%TYPE
1209 , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1210 , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1211 , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1212 , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE
1213 , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE
1214 , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE
1215 , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE
1216 , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE
1217 , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE
1218 , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE
1219 , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE
1220 , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE
1224 , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE
1221 , p_reason_code IN jtf_tasks_v.reason_code%TYPE
1222 , p_private_flag IN jtf_tasks_v.private_flag%TYPE
1223 , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE
1225 , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE
1226 , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE
1227 , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE
1228 , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE
1229 , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE
1230 , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE
1231 , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE
1232 , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE
1233 , p_ref_object_id IN NUMBER
1234 , p_ref_object_type_code IN VARCHAR2
1235 , p_task_name IN jtf_tasks_v.task_name%TYPE
1236 , p_sort_data IN jtf_tasks_pub.sort_data
1237 , p_start_pointer IN NUMBER
1238 , p_rec_wanted IN NUMBER
1239 , p_show_all IN VARCHAR2
1240 , p_query_or_next_code IN VARCHAR2 DEFAULT 'Q'
1241 , x_task_table OUT NOCOPY jtf_tasks_pub.task_table_type
1242 , x_total_retrieved OUT NOCOPY NUMBER
1243 , x_total_returned OUT NOCOPY NUMBER
1244 , x_return_status OUT NOCOPY VARCHAR2
1245 , x_msg_count OUT NOCOPY NUMBER
1246 , x_msg_data OUT NOCOPY VARCHAR2
1247 );
1248
1249 PROCEDURE query_next_task(
1250 p_object_version_number IN NUMBER
1251 , p_task_id IN jtf_tasks_v.task_id%TYPE
1252 , -- current task id
1253 p_query_type IN VARCHAR2 DEFAULT 'Dependency'
1254 , -- values Dependency, Owner, assigned
1255 p_date_type IN VARCHAR2 DEFAULT NULL
1256 , p_date_start_or_end IN VARCHAR2 DEFAULT NULL
1257 , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1258 , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1259 , p_assigned_by IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1260 , p_sort_data IN jtf_tasks_pub.sort_data
1261 , p_start_pointer IN NUMBER
1262 , p_rec_wanted IN NUMBER
1263 , p_show_all IN VARCHAR2 DEFAULT 'Y'
1264 , p_query_or_next_code IN VARCHAR2 DEFAULT 'Q'
1265 , x_task_table OUT NOCOPY jtf_tasks_pub.task_table_type
1266 , x_total_retrieved OUT NOCOPY NUMBER
1267 , x_total_returned OUT NOCOPY NUMBER
1268 , x_return_status OUT NOCOPY VARCHAR2
1269 , x_msg_count OUT NOCOPY NUMBER
1270 , x_msg_data OUT NOCOPY VARCHAR2
1271 );
1272
1273 -- Created for Enh 2797666
1274 TYPE sub_task_rec IS RECORD(
1275 task_id jtf_tasks_b.task_id%TYPE := fnd_api.g_miss_num
1276 , task_type_id jtf_tasks_b.task_type_id%TYPE := fnd_api.g_miss_num
1277 , task_status_id jtf_tasks_b.task_status_id%TYPE := fnd_api.g_miss_num
1278 , task_priority_id jtf_tasks_b.task_priority_id%TYPE := fnd_api.g_miss_num
1279 , planned_start_date jtf_tasks_b.planned_start_date%TYPE := fnd_api.g_miss_date
1280 , planned_end_date jtf_tasks_b.planned_end_date%TYPE := fnd_api.g_miss_date
1281 , scheduled_start_date jtf_tasks_b.scheduled_start_date%TYPE := fnd_api.g_miss_date
1282 , scheduled_end_date jtf_tasks_b.scheduled_end_date%TYPE := fnd_api.g_miss_date
1283 , actual_start_date jtf_tasks_b.actual_start_date%TYPE := fnd_api.g_miss_date
1284 , actual_end_date jtf_tasks_b.actual_end_date%TYPE := fnd_api.g_miss_date
1285 , p_enable_workflow VARCHAR2(1)
1286 , abort_workflow VARCHAR2(1)
1287 );
1288 END; -- Package spec