1 PACKAGE jtf_tasks_pub AUTHID CURRENT_USER AS
2 /* $Header: jtfptkts.pls 120.17.12010000.3 2009/09/07 13:07:50 anangupt ship $ */
3 /*#
4 * A public interface for Tasks that can be used to create, update and delete tasks.
5 * Tasks can be standalone tasks or tasks associated with a specific business entity
6 * such as Opportunity, Service Request, Customer, etc. Do not use these APIs
7 * for managing Field Service tasks related to service requests.
8 *
9 * @rep:scope public
10 * @rep:product CAC
11 * @rep:lifecycle active
12 * @rep:displayname Task Management
13 * @rep:compatibility S
14 * @rep:category BUSINESS_ENTITY CAC_CAL_TASK
15 */
16 g_pkg_name CONSTANT VARCHAR2(30) := 'JTF_TASKS_PUB';
17 g_user CONSTANT VARCHAR2(30) := fnd_global.user_id;
18 g_false CONSTANT VARCHAR2(30) := fnd_api.g_false;
19 g_true CONSTANT VARCHAR2(30) := fnd_api.g_true;
20
21 TYPE task_details_rec IS RECORD(
22 task_id NUMBER
23 , task_template_id NUMBER
24 );
25
26 TYPE task_assign_rec IS RECORD(
27 resource_type_code jtf_task_assignments.resource_type_code%TYPE
28 , resource_id jtf_task_assignments.resource_id%TYPE
29 , actual_start_date DATE := NULL
30 , actual_end_date DATE := NULL
31 , actual_effort jtf_task_assignments.actual_effort%TYPE := NULL
32 , actual_effort_uom jtf_task_assignments.actual_effort_uom%TYPE := NULL
33 , sched_travel_distance jtf_task_assignments.sched_travel_distance%TYPE := NULL
34 , sched_travel_duration jtf_task_assignments.sched_travel_duration%TYPE := NULL
35 , sched_travel_duration_uom jtf_task_assignments.sched_travel_duration_uom%TYPE := NULL
36 , actual_travel_distance jtf_task_assignments.actual_travel_distance%TYPE := NULL
37 , actual_travel_duration jtf_task_assignments.actual_travel_duration%TYPE := NULL
38 , actual_travel_duration_uom jtf_task_assignments.actual_travel_duration_uom%TYPE := NULL
39 , schedule_flag jtf_task_assignments.schedule_flag%TYPE := NULL
40 , alarm_type_code jtf_task_assignments.alarm_type_code%TYPE := NULL
41 , alarm_contact jtf_task_assignments.alarm_contact%TYPE := NULL
42 , palm_flag jtf_task_assignments.palm_flag%TYPE := NULL
43 , wince_flag jtf_task_assignments.wince_flag%TYPE := NULL
44 , laptop_flag jtf_task_assignments.laptop_flag%TYPE := NULL
45 , device1_flag jtf_task_assignments.device1_flag%TYPE := NULL
46 , device2_flag jtf_task_assignments.device2_flag%TYPE := NULL
47 , device3_flag jtf_task_assignments.device3_flag%TYPE := NULL
48 , resource_territory_id jtf_task_assignments.resource_territory_id%TYPE := NULL
49 , assignment_status_id jtf_task_assignments.assignment_status_id%TYPE := NULL
50 , shift_construct_id jtf_task_assignments.shift_construct_id%TYPE := NULL
51 , show_on_calendar jtf_task_assignments.show_on_calendar%TYPE := NULL
52 , category_id jtf_task_assignments.category_id%TYPE := NULL
53 );
54
55 TYPE task_assign_tbl IS TABLE OF task_assign_rec
56 INDEX BY BINARY_INTEGER;
57
58 g_miss_task_assign_tbl task_assign_tbl;
59
60 TYPE task_depends_rec IS RECORD(
61 dependent_on_task_id NUMBER := NULL
62 , dependent_on_task_number NUMBER := NULL
63 , dependency_type_code VARCHAR2(30)
64 , adjustment_time NUMBER := NULL
65 , adjustment_time_uom VARCHAR2(3) := NULL
66 , validated_flag VARCHAR2(1) := NULL
67 );
68
69 TYPE task_depends_tbl IS TABLE OF task_depends_rec
70 INDEX BY BINARY_INTEGER;
71
72 g_miss_task_depends_tbl task_depends_tbl;
73
74 TYPE task_rsrc_req_rec IS RECORD(
75 resource_type_code jtf_task_rsc_reqs.resource_type_code%TYPE
76 , required_units jtf_task_rsc_reqs.required_units%TYPE
77 , enabled_flag jtf_task_rsc_reqs.enabled_flag%TYPE := jtf_task_utl.g_no
78 );
79
80 TYPE task_rsrc_req_tbl IS TABLE OF task_rsrc_req_rec
81 INDEX BY BINARY_INTEGER;
82
83 g_miss_task_rsrc_req_tbl task_rsrc_req_tbl;
84
85 TYPE task_refer_rec IS RECORD(
86 object_type_code jtf_objects_b.object_code%TYPE
87 , object_type_name jtf_objects_tl.NAME%TYPE
88 , object_name VARCHAR2(80)
89 , object_id NUMBER
90 , object_details VARCHAR2(2000)
91 , reference_code VARCHAR2(30)
92 , USAGE VARCHAR2(2000)
93 );
94
95 TYPE task_refer_tbl IS TABLE OF task_refer_rec
96 INDEX BY BINARY_INTEGER;
97
98 g_miss_task_refer_tbl task_refer_tbl;
99
100 TYPE task_recur_rec IS RECORD(
101 occurs_which NUMBER := NULL
102 , day_of_week NUMBER := NULL
103 , date_of_month NUMBER := NULL
104 , occurs_month NUMBER := NULL
105 , occurs_uom VARCHAR2(3)
106 , occurs_every NUMBER := NULL
107 , occurs_number NUMBER := NULL
108 , start_date_active DATE := NULL
109 , end_date_active DATE := NULL
110 );
111
112 g_miss_task_recur_rec task_recur_rec;
113
114 TYPE task_dates_rec IS RECORD(
115 date_type_id NUMBER DEFAULT NULL
116 , date_type_name VARCHAR2(30) DEFAULT NULL
117 , date_type VARCHAR2(30) DEFAULT NULL
118 , date_value DATE
119 );
120
121 TYPE task_dates_tbl IS TABLE OF task_dates_rec
122 INDEX BY BINARY_INTEGER;
123
124 g_miss_task_dates_tbl task_dates_tbl;
125
126 TYPE task_notes_rec IS RECORD(
127 parent_note_id NUMBER
128 , org_id NUMBER
129 , notes VARCHAR2(4000)
130 , notes_detail VARCHAR2(32767)
131 , note_status VARCHAR2(1)
132 , entered_by NUMBER
133 , entered_date DATE
134 , note_type VARCHAR2(30)
135 , jtf_note_id NUMBER
136 , attribute1 VARCHAR2(150)
137 , attribute2 VARCHAR2(150)
138 , attribute3 VARCHAR2(150)
139 , attribute4 VARCHAR2(150)
140 , attribute5 VARCHAR2(150)
141 , attribute6 VARCHAR2(150)
142 , attribute7 VARCHAR2(150)
143 , attribute8 VARCHAR2(150)
144 , attribute9 VARCHAR2(150)
145 , attribute10 VARCHAR2(150)
146 , attribute11 VARCHAR2(150)
147 , attribute12 VARCHAR2(150)
148 , attribute13 VARCHAR2(150)
149 , attribute14 VARCHAR2(150)
150 , attribute15 VARCHAR2(150)
151 , CONTEXT VARCHAR2(30)
152 );
153
154 TYPE task_notes_tbl IS TABLE OF task_notes_rec
155 INDEX BY BINARY_INTEGER;
156
157 g_miss_task_notes_tbl task_notes_tbl;
158
159 TYPE task_contacts_rec IS RECORD(
160 contact_id NUMBER DEFAULT NULL
161 , contact_type_code VARCHAR2(30) DEFAULT NULL
162 , escalation_notify_flag VARCHAR2(1) DEFAULT NULL
163 , escalation_requester_flag VARCHAR2(1) DEFAULT NULL
164 );
165
166 TYPE task_contacts_tbl IS TABLE OF task_contacts_rec
167 INDEX BY BINARY_INTEGER;
168
169 g_miss_task_contacts_tbl task_contacts_tbl;
170
171 TYPE task_user_hooks IS RECORD(
172 task_id NUMBER
173 , task_name VARCHAR2(80)
174 , task_type_name VARCHAR2(80)
175 , task_type_id NUMBER
176 , description VARCHAR2(4000)
177 , task_status_name VARCHAR2(80)
178 , task_status_id NUMBER
179 , task_priority_name VARCHAR2(80)
180 , task_priority_id NUMBER
181 , owner_type_name VARCHAR2(80)
182 , owner_type_code VARCHAR2(80)
183 , owner_id NUMBER
184 , owner_territory_id NUMBER
185 , assigned_by_name VARCHAR2(80)
186 , assigned_by_id NUMBER
187 , customer_number VARCHAR2(30)
188 , customer_id NUMBER
189 , cust_account_number VARCHAR2(30)
190 , cust_account_id NUMBER
191 , address_id NUMBER
192 , address_number VARCHAR2(30)
193 , planned_start_date DATE
194 , planned_end_date DATE
195 , scheduled_start_date DATE
196 , scheduled_end_date DATE
197 , actual_start_date DATE
198 , actual_end_date DATE
199 , timezone_id NUMBER
200 , timezone_name VARCHAR2(50)
201 , source_object_type_code VARCHAR2(30)
202 , source_object_id NUMBER
203 , source_object_name VARCHAR2(80)
204 , duration NUMBER
205 , duration_uom VARCHAR2(3)
206 , planned_effort NUMBER
207 , planned_effort_uom VARCHAR2(3)
208 , actual_effort NUMBER
209 , actual_effort_uom VARCHAR2(3)
210 , percentage_complete NUMBER
211 , reason_code VARCHAR2(30)
212 , private_flag VARCHAR2(1)
213 , publish_flag VARCHAR2(1)
214 , restrict_closure_flag VARCHAR2(1)
215 , multi_booked_flag VARCHAR2(1)
219 , bound_mode_code VARCHAR2(30)
216 , milestone_flag VARCHAR2(1)
217 , holiday_flag VARCHAR2(1)
218 , billable_flag VARCHAR2(1)
220 , soft_bound_flag VARCHAR2(1)
221 , workflow_process_id NUMBER
222 , notification_flag VARCHAR2(1)
223 , notification_period NUMBER
224 , notification_period_uom VARCHAR2(3)
225 , parent_task_number VARCHAR2(30)
226 , parent_task_id NUMBER
227 , alarm_start NUMBER
228 , alarm_start_uom VARCHAR2(3)
229 , alarm_on VARCHAR2(1)
230 , alarm_count NUMBER
234 , wince_flag VARCHAR2(1)
231 , alarm_interval NUMBER
232 , alarm_interval_uom VARCHAR2(3)
233 , palm_flag VARCHAR2(1)
235 , laptop_flag VARCHAR2(1)
236 , device1_flag VARCHAR2(1)
237 , device2_flag VARCHAR2(1)
238 , device3_flag VARCHAR2(1)
239 , costs NUMBER
240 , currency_code VARCHAR2(3)
241 , escalation_level VARCHAR2(30)
242 , date_selected VARCHAR2(1)
243 , template_id NUMBER
244 , template_group_id NUMBER
245 , task_number VARCHAR2(30)
246 , attribute1 VARCHAR2(150)
247 , attribute2 VARCHAR2(150)
248 , attribute3 VARCHAR2(150)
249 , attribute4 VARCHAR2(150)
250 , attribute5 VARCHAR2(150)
251 , attribute6 VARCHAR2(150)
252 , attribute7 VARCHAR2(150)
253 , attribute8 VARCHAR2(150)
254 , attribute9 VARCHAR2(150)
255 , attribute10 VARCHAR2(150)
256 , attribute11 VARCHAR2(150)
257 , attribute12 VARCHAR2(150)
258 , attribute13 VARCHAR2(150)
259 , attribute14 VARCHAR2(150)
260 , attribute15 VARCHAR2(150)
261 , attribute_category VARCHAR2(150)
262 , entity VARCHAR2(30)
263 , task_split_flag VARCHAR2(1)
264 , child_position VARCHAR2(1)
265 , child_sequence_num NUMBER
266 , task_confirmation_status VARCHAR2(1)
267 , task_confirmation_counter NUMBER
268 , open_flag VARCHAR2(1)
269 , location_id NUMBER
270 , copied_from_task_id NUMBER
271 );
272
273 p_task_user_hooks task_user_hooks;
274
275 TYPE task_rec IS RECORD(
276 task_id jtf_tasks_v.task_id%TYPE
277 , task_number jtf_tasks_v.task_number%TYPE
278 , task_name jtf_tasks_v.task_name%TYPE
279 , description jtf_tasks_v.description%TYPE
280 , task_type_id jtf_tasks_v.task_type_id%TYPE
281 , task_type jtf_tasks_v.task_type%TYPE
282 , task_status_id jtf_tasks_v.task_status_id%TYPE
283 , task_status jtf_tasks_v.task_status%TYPE
284 , task_priority_id jtf_tasks_v.task_priority_id%TYPE
285 , task_priority jtf_tasks_v.task_priority%TYPE
286 , owner_type_code jtf_tasks_v.owner_type_code%TYPE
287 , owner_id jtf_tasks_v.owner_id%TYPE
288 , owner jtf_tasks_v.owner%TYPE
289 , assigned_by_id jtf_tasks_v.assigned_by_id%TYPE
290 , assigned_by_name jtf_tasks_v.assigned_by_name%TYPE
291 , customer_id jtf_tasks_v.customer_id%TYPE
292 , customer_name jtf_tasks_v.customer_name%TYPE
293 , customer_number jtf_tasks_v.customer_number%TYPE
294 , cust_account_number jtf_tasks_v.cust_account_number%TYPE
295 , cust_account_id jtf_tasks_v.cust_account_id%TYPE
296 , address_id jtf_tasks_v.address_id%TYPE
297 , planned_start_date jtf_tasks_v.planned_start_date%TYPE
298 , planned_end_date jtf_tasks_v.planned_end_date%TYPE
299 , scheduled_start_date jtf_tasks_v.scheduled_start_date%TYPE
300 , scheduled_end_date jtf_tasks_v.scheduled_end_date%TYPE
301 , actual_start_date jtf_tasks_v.actual_start_date%TYPE
302 , actual_end_date jtf_tasks_v.actual_end_date%TYPE
303 , object_type_code jtf_tasks_v.source_object_type_code%TYPE
304 , object_id jtf_tasks_v.source_object_id%TYPE
305 , obect_name jtf_tasks_v.source_object_name%TYPE
306 , DURATION jtf_tasks_v.DURATION%TYPE
307 , duration_uom jtf_tasks_v.duration_uom%TYPE
308 , planned_effort jtf_tasks_v.planned_effort%TYPE
309 , planned_effort_uom jtf_tasks_v.planned_effort_uom%TYPE
310 , actual_effort jtf_tasks_v.actual_effort%TYPE
311 , actual_effort_uom jtf_tasks_v.actual_effort_uom%TYPE
312 , percentage_complete jtf_tasks_v.percentage_complete%TYPE
313 , reason_code jtf_tasks_v.reason_code%TYPE
314 , private_flag jtf_tasks_v.private_flag%TYPE
315 , publish_flag jtf_tasks_v.publish_flag%TYPE
316 , multi_booked_flag jtf_tasks_v.multi_booked_flag%TYPE
317 , milestone_flag jtf_tasks_v.milestone_flag%TYPE
318 , holiday_flag jtf_tasks_v.holiday_flag%TYPE
319 , workflow_process_id jtf_tasks_v.workflow_process_id%TYPE
320 , notification_flag jtf_tasks_v.notification_flag%TYPE
321 , notification_period jtf_tasks_v.notification_period%TYPE
322 , notification_period_uom jtf_tasks_v.notification_period_uom%TYPE
323 , parent_task_id jtf_tasks_v.parent_task_id%TYPE
324 , alarm_start jtf_tasks_v.alarm_start%TYPE
325 , alarm_start_uom jtf_tasks_v.alarm_start_uom%TYPE
326 , alarm_on jtf_tasks_v.alarm_on%TYPE
327 , alarm_count jtf_tasks_v.alarm_count%TYPE
328 , alarm_fired_count jtf_tasks_v.alarm_fired_count%TYPE
329 , alarm_interval jtf_tasks_v.alarm_interval%TYPE
330 , alarm_interval_uom jtf_tasks_v.alarm_interval_uom%TYPE
331 , attribute1 jtf_tasks_v.attribute1%TYPE
332 , attribute2 jtf_tasks_v.attribute2%TYPE
333 , attribute3 jtf_tasks_v.attribute3%TYPE
334 , attribute4 jtf_tasks_v.attribute4%TYPE
335 , attribute5 jtf_tasks_v.attribute5%TYPE
336 , attribute6 jtf_tasks_v.attribute6%TYPE
337 , attribute7 jtf_tasks_v.attribute7%TYPE
338 , attribute8 jtf_tasks_v.attribute8%TYPE
339 , attribute9 jtf_tasks_v.attribute9%TYPE
340 , attribute10 jtf_tasks_v.attribute10%TYPE
341 , attribute11 jtf_tasks_v.attribute11%TYPE
342 , attribute12 jtf_tasks_v.attribute12%TYPE
343 , attribute13 jtf_tasks_v.attribute13%TYPE
344 , attribute14 jtf_tasks_v.attribute14%TYPE
345 , attribute15 jtf_tasks_v.attribute15%TYPE
346 , attribute_category jtf_tasks_v.attribute_category%TYPE
347 , owner_territory_id jtf_tasks_v.owner_territory_id%TYPE
348 , creation_date jtf_tasks_v.creation_date%TYPE
349 , escalation_level jtf_tasks_v.escalation_level%TYPE
350 , object_version_number jtf_tasks_v.object_version_number%TYPE
351 , calendar_start_date jtf_tasks_b.calendar_start_date%TYPE
352 , calendar_end_date jtf_tasks_b.calendar_end_date%TYPE
353 , date_selected jtf_tasks_b.date_selected%TYPE
354 , task_split_flag jtf_tasks_v.task_split_flag%TYPE
355 , child_position jtf_tasks_vl.child_position%TYPE
356 , child_sequence_num jtf_tasks_vl.child_sequence_num%TYPE
357 , location_id jtf_tasks_vl.location_id%TYPE
358 );
359
360 TYPE task_table_type IS TABLE OF task_rec
361 INDEX BY BINARY_INTEGER;
362
363 task_tbl task_table_type;
364
365 TYPE sort_rec IS RECORD(
366 field_name VARCHAR2(30)
367 , asc_dsc_flag CHAR(1) DEFAULT 'A'
368 );
369
370 TYPE sort_data IS TABLE OF sort_rec
371 INDEX BY BINARY_INTEGER;
372
373 /*#
374 * Creates a standalone task or a task associated with a specific business entity.
375 *
376 * @param p_api_version Standard API version number. See "Standard IN Parameters", Oracle Common Application Calendar API Reference Guide.
377 * @rep:paraminfo {@rep:required}
378 * @param p_init_msg_list Standard API flag allows API callers to request that the API does the initialization of the message list on their behalf. By default, the message list will not be initialized.
379 * See "Standard IN Parameters", Oracle Common Application Calendar API Reference Guide.
380 * @param p_commit Standard API flag is used by API callers to ask the API to commit on their behalf after performing its function. By default, the commit will not be performed.
381 * See "Standard IN Parameters", Oracle Common Application Calendar API Reference Guide.
382 * @param x_return_status Result of all the operations performed by the API. This will have one of the following values:
383 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code> - If the API processed the data successfully.
384 * <LI><Code>FND_API.G_RET_STS_ERROR</Code> - If there was an expected error in API processing.
385 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code> If there was an unexpected error in API processing.
386 * @param x_msg_count Number of messages returned in the API message list.
387 * @param x_msg_data Returned message data in an encoded format if <code>x_msg_count</code> returns non-zero value.
388 * @param x_task_id Unique task identifier of the task being created.
389 * @param p_task_id Unique task identifier. It will be generated from the sequence <code>jtf_tasks_s</code> when not passed.
390 * @param p_task_name Subject of the task.
391 * @paraminfo {@rep:precision 80} {@rep:required}
392 * @param p_task_type_name Task type name. Either type name or <code>p_task_type_id</code> must be passed.
393 * @rep:paraminfo {@rep:required}
394 * @param p_task_type_id Unique task type identifier. This is a foreign key to <code>jtf_task_types_b.task_type_id</code>.
395 * @rep:paraminfo {@rep:required}
396 * @param p_description Optional task description.
397 * @paraminfo {@rep:precision 4000}
398 * @param p_task_status_name Task status name. Either status name or <code>p_task_status_id</code> must be passed.
399 * @rep:paraminfo {@rep:required}
400 * @param p_task_status_id Unique task status identifier. This is a foreign key to <code>jtf_task_statuses_b.task_status_id</code>.
401 * @rep:paraminfo {@rep:required}
402 * @param p_task_priority_name Task priority name. Either priority name or <code>p_task_priority_id</code> can be passed.
403 * @param p_task_priority_id Unique task priority identifier. This is a foreign key to <code>jtf_task_priorities_b.task_priority_id</code>.
404 * @param p_owner_type_name No longer in use.
405 * @param p_owner_type_code Resource type code for the task owner. A task owner is identified with the task resource type code and task resource identifier, therefore this should be used along with <code>p_owner_id</code>.
406 * @rep:paraminfo {@rep:required}
407 * @param p_owner_id Resource identifier for the task owner. Should be used along with <code>p_owner_type_code</code>.
408 * @rep:paraminfo {@rep:required}
409 * @param p_owner_territory_id Territory identification of the task owner.
410 * @param p_assigned_by_name No longer in use.
411 * @param p_assigned_by_id No longer in use.
412 * @param p_customer_number Unique customer number. Either customer number or <code>p_customer_id</code> can be passed to associate the customer with the task.
413 * This is validated against <code>hz_parties.party_number</code>.
414 * @param p_customer_id Unique customer identifier. Either customer identifier or <code>p_customer_number</code> can be passed to associate the customer with the task.
415 * This is validated against <code>hz_parties.party_id</code>.
416 * @param p_cust_account_number Customer account number that can be set on a task with an associated customer. Either customer account number or <code>p_customer_account_id</code> can be passed.
417 * This is validated against <code>hz_cust_accounts.account_number</code>.
418 * @param p_cust_account_id Unique customer account identifier that can be set on a task with an associated customer. Either customer account identifier or <code>p_customer_account_number</code> can be passed.
419 * This is validated against <code>hz_cust_accounts.cust_account_id</code>.
420 * @param p_address_number Customer address number that can be set on a task with an associated customer. Either customer address number or <code>p_address_id</code> can be passed.
424 * @param p_planned_start_date Planned start date for this task.
421 * This is validated against <code>hz_party_sites.party_site_number</code>.
422 * @param p_address_id Unique customer address identifier that can be set on a task with an associated customer. Either customer address identifier or <code>p_address_number</code> can be passed.
423 * This is validated against <code>hz_party_sites.party_site_id</code>.
425 * @param p_planned_end_date Planned end date for this task.
426 * @param p_scheduled_start_date Scheduled start date for this task.
427 * @param p_scheduled_end_date Scheduled end date for this task.
428 * @param p_actual_start_date Actual start date for this task.
429 * @param p_actual_end_date Actual end date for this task.
430 * @param p_timezone_id Timezone identifier used for this task dates. Either timezone identifier or <code>p_timezone_name</code> can be passed. This is validated against <code>hz_timezones.timezone_id</code>.
431 * @param p_timezone_name Timezone name used for this task dates. Either timezone name or <code>p_timezone_id</code> can be passed. This is validated against <code>hz_timezones.global_timezone_name</code>.
432 * @param p_source_object_type_code Object code used as the source type for this task. The object code can be either <code>'TASK'</code> for standalone tasks or a registered object with usage of <code>'TASK'</code> for contextual tasks.
433 * This is a foreign key to <code>jtf_objects_b.object_code</code>.
434 * @param p_source_object_id Unique source object identifier used to identify and validate the task source. This must be provided for any contextual task.
435 * @param p_source_object_name No longer in use.
436 * @param p_duration Duration of this task. Should be used along with <code>p_duration_uom</code>.
437 * @param p_duration_uom Unit of measure for the duration. Should be used along with <code>p_duration</code>.
438 * @param p_planned_effort Planned effort for this task. Should be used along with <code>p_planned_effort_uom</code>.
439 * @param p_planned_effort_uom Unit of Measure for the planned effort. Should be used along with <code>p_planned_effort</code>.
440 * @param p_actual_effort Actual effort exerted for this task. Should be used along with <code>p_actual_effort_uom</code>.
441 * @param p_actual_effort_uom Unit of Measure for the actual effort. Should be used along with <code>p_actual_effort</code>.
442 * @param p_percentage_complete Percentage of this task completion.
443 * @param p_reason_code Reserved for internal use only. Reason code is used to check if the task is automated.
444 * @param p_private_flag Flag used to mark this task as a private task. This flag is used by task user interface to limit the task visibility to the task owner and assignee only.
445 * @param p_publish_flag Flag used to mark this task as a published task. This flag is used by task user interface to set the task for publishing.
446 * @param p_restrict_closure_flag Reserved for internal use only.
447 * @param p_multi_booked_flag Reserved for internal use only.
448 * @param p_milestone_flag Flag used to mark this task as milestone.
449 * @param p_holiday_flag Flag used to mark this task execution during holidays.
450 * @param p_billable_flag Flag used to mark this task for billing.
451 * @param p_bound_mode_code Reserved for internal use only.
452 * @param p_soft_bound_flag Reserved for internal use only.
453 * @param p_workflow_process_id Process identifier of last workflow launched.
454 * @param p_notification_flag Notification flag used to automatically launch workflow.
455 * @param p_notification_period Notification period is the time period after which workflow is sent to the task assignees. Should be used along with <code>p_notification_period_uom</code>.
456 * @param p_notification_period_uom Unit of measure for notification period. Should be used along with <code>p_notification_period</code>.
457 * @param p_parent_task_number Parent task number for this tasks. Either parent task number or <code>p_parent_task_number</code> can be passed.
458 * @param p_parent_task_id Parent task identifier for this tasks. Either parent task identifier or <code>p_parent_task_id</code> can be passed.
459 * @param p_alarm_start Time when the first alarm is fired. Should be used along with <code>p_alarm_start_uom</code>.
460 * @param p_alarm_start_uom Unit of measure for alarm start. Should be used along with <code>p_alarm_start</code>.
461 * @param p_alarm_on Indicates that alarm is turned on.
462 * @param p_alarm_count Total number of alarms.
463 * @param p_alarm_interval Alarm firing interval. Should be used along with <code>p_alarm_interval_uom</code>.
464 * @param p_alarm_interval_uom Unit of measure for alarm interval. Should be used along with <code>p_alarm_interval</code>.
465 * @param p_palm_flag Reserved for internal use only.
466 * @param p_wince_flag Reserved for internal use only.
467 * @param p_laptop_flag Reserved for internal use only.
468 * @param p_device1_flag Reserved for internal use only.
469 * @param p_device2_flag Reserved for internal use only.
470 * @param p_device3_flag Reserved for internal use only.
471 * @param p_costs Reserved for internal use only.
472 * @param p_currency_code Reserved for internal use only.
473 * @param p_escalation_level Level of escalation used by Escalation Module.
474 * @param p_task_assign_tbl Table of task assignment records. For details see: Oracle Common Application Calendar - API Reference Guide.
475 * @param p_task_depends_tbl Table of dependent task records. For details see: Oracle Common Application Calendar - API Reference Guide.
476 * @param p_task_rsrc_req_tbl Table of task resource requirement records. For details see: Oracle Common Application Calendar - API Reference Guide.
477 * @param p_task_refer_tbl Table of task reference records. For details see: Oracle Common Application Calendar - API Reference Guide.
481 * @param p_task_contacts_tbl Table of task customer contact records. For details see: Oracle Common Application Calendar - API Reference Guide.
478 * @param p_task_dates_tbl Table of task dates records. For details see: Oracle Common Application Calendar - API Reference Guide.
479 * @param p_task_notes_tbl Table of task notes records. For details see: Oracle Common Application Calendar - API Reference Guide.
480 * @param p_task_recur_rec Task recurrence record. For details see: Oracle Common Application Calendar - API Reference Guide.
482 * @param p_attribute1 Attribute1 of customer flex fields.
483 * @param p_attribute2 Attribute2 of customer flex fields.
484 * @param p_attribute3 Attribute3 of customer flex fields.
485 * @param p_attribute4 Attribute4 of customer flex fields.
486 * @param p_attribute5 Attribute5 of customer flex fields.
487 * @param p_attribute6 Attribute6 of customer flex fields.
488 * @param p_attribute7 Attribute7 of customer flex fields.
489 * @param p_attribute8 Attribute8 of customer flex fields.
490 * @param p_attribute9 Attribute9 of customer flex fields.
491 * @param p_attribute10 Attribute10 of customer flex fields.
492 * @param p_attribute11 Attribute11 of customer flex fields.
493 * @param p_attribute12 Attribute12 of customer flex fields.
494 * @param p_attribute13 Attribute13 of customer flex fields.
495 * @param p_attribute14 Attribute14 of customer flex fields.
496 * @param p_attribute15 Attribute15 of customer flex fields.
497 * @param p_attribute_category Attribute category for the customer flex fields.
498 * @param p_date_selected Flag used to select which date pair (Planned, Scheduled, or Actual) will be used as calendar date. The default value is set by profile option, if not passed.
499 * @param p_category_id Reserved unique identifier for personal category defined by resource in their calendar. This is a foreign key to <code>jtf_perz_data.perz_date_id</code>.
500 * @param p_show_on_calendar Flag to show task on resource's calendar. The task will only show up on Resource's calendar if this flag is set to <code>'Y'</code> and there is a set of date with time present on task level.
501 * This flag is defaulted to <code>'Y'</code> if not passed.
502 * @param p_owner_status_id No longer in use.
503 * @param p_template_id Unique template identifier of task template used for creating this task.
504 * @param p_template_group_id Unique template group identifier of template group that contains the task template used for creating this task.
505 * @param p_enable_workflow Flag to enable workflow passed as-is to <code>oracle.apps.jtf.cac.task.createTask</code> business event.
506 * @param p_abort_workflow Flag to abort workflow passed as-is to <code>oracle.apps.jtf.cac.task.createTask</code> business event.
507 * @param p_task_split_flag Reserved for internal use only. This flag is used to denote split tasks created by Field Service.
508 * The following two values are currently used:
509 * <LI><code>'M'</code> - for a master (parent) task
510 * <LI><code>'D'</code> - for a dependent (child) task.
511 * @param p_reference_flag Reserved for internal use only. It is used to note API about references that are already created.
512 * @param p_child_position Reserved for internal use only. This flag is used by Field Service to mark child position for split tasks
513 * @param p_child_sequence_num Reserved for internal use only. It is used by Field Service to mark child sequence for split tasks
514 * @param p_location_id Reserved for internal use only. It is used by Field Service to store location id in task table
515 * @rep:paraminfo {@rep:required}
516 *
517 * @rep:primaryinstance
518 * @rep:scope public
519 * @rep:lifecycle active
520 * @rep:displayname Create Task
521 * @rep:compatibility S
522 * @rep:businessevent oracle.apps.jtf.cac.task.createTask
523 * @rep:metalink 249665.1 Oracle Common Application Calendar - API Reference Guide
524 * @rep:category BUSINESS_ENTITY CS_SERVICE_REQUEST
525 * @rep:category BUSINESS_ENTITY AS_OPPORTUNITY
526 * @rep:category BUSINESS_ENTITY AMS_LEAD
527 */
528 PROCEDURE create_task(
529 p_api_version IN NUMBER
530 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
531 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
532 , p_task_id IN NUMBER DEFAULT NULL
533 , p_task_name IN VARCHAR2
534 , p_task_type_name IN VARCHAR2 DEFAULT NULL
535 , p_task_type_id IN NUMBER DEFAULT NULL
536 , p_description IN VARCHAR2 DEFAULT NULL
537 , p_task_status_name IN VARCHAR2 DEFAULT NULL
538 , p_task_status_id IN NUMBER DEFAULT NULL
539 , p_task_priority_name IN VARCHAR2 DEFAULT NULL
540 , p_task_priority_id IN NUMBER DEFAULT NULL
541 , p_owner_type_name IN VARCHAR2 DEFAULT NULL
542 , p_owner_type_code IN VARCHAR2 DEFAULT NULL
543 , p_owner_id IN NUMBER DEFAULT NULL
544 , p_owner_territory_id IN NUMBER DEFAULT NULL
545 , p_assigned_by_name IN VARCHAR2 DEFAULT NULL
546 , p_assigned_by_id IN NUMBER DEFAULT NULL
547 , p_customer_number IN VARCHAR2 DEFAULT NULL
548 , -- from hz_parties
549 p_customer_id IN NUMBER DEFAULT NULL
550 , p_cust_account_number IN VARCHAR2 DEFAULT NULL
551 , p_cust_account_id IN NUMBER DEFAULT NULL
552 , p_address_id IN NUMBER DEFAULT NULL
553 , ---- hz_party_sites
554 p_address_number IN VARCHAR2 DEFAULT NULL
555 , p_planned_start_date IN DATE DEFAULT NULL
556 , p_planned_end_date IN DATE DEFAULT NULL
557 , p_scheduled_start_date IN DATE DEFAULT NULL
558 , p_scheduled_end_date IN DATE DEFAULT NULL
559 , p_actual_start_date IN DATE DEFAULT NULL
560 , p_actual_end_date IN DATE DEFAULT NULL
561 , p_timezone_id IN NUMBER DEFAULT NULL
562 , p_timezone_name IN VARCHAR2 DEFAULT NULL
563 , p_source_object_type_code IN VARCHAR2 DEFAULT NULL
564 , p_source_object_id IN NUMBER DEFAULT NULL
565 , p_source_object_name IN VARCHAR2 DEFAULT NULL
566 , p_duration IN NUMBER DEFAULT NULL
567 , p_duration_uom IN VARCHAR2 DEFAULT NULL
568 , p_planned_effort IN NUMBER DEFAULT NULL
569 , p_planned_effort_uom IN VARCHAR2 DEFAULT NULL
570 , p_actual_effort IN NUMBER DEFAULT NULL
571 , p_actual_effort_uom IN VARCHAR2 DEFAULT NULL
572 , p_percentage_complete IN NUMBER DEFAULT NULL
573 , p_reason_code IN VARCHAR2 DEFAULT NULL
574 , p_private_flag IN VARCHAR2 DEFAULT NULL
575 , p_publish_flag IN VARCHAR2 DEFAULT NULL
576 , p_restrict_closure_flag IN VARCHAR2 DEFAULT NULL
577 , p_multi_booked_flag IN VARCHAR2 DEFAULT NULL
578 , p_milestone_flag IN VARCHAR2 DEFAULT NULL
579 , p_holiday_flag IN VARCHAR2 DEFAULT NULL
580 , p_billable_flag IN VARCHAR2 DEFAULT NULL
581 , p_bound_mode_code IN VARCHAR2 DEFAULT NULL
582 , p_soft_bound_flag IN VARCHAR2 DEFAULT NULL
583 , p_workflow_process_id IN NUMBER DEFAULT NULL
584 , p_notification_flag IN VARCHAR2 DEFAULT NULL
585 , p_notification_period IN NUMBER DEFAULT NULL
586 , p_notification_period_uom IN VARCHAR2 DEFAULT NULL
587 , p_parent_task_number IN VARCHAR2 DEFAULT NULL
588 , p_parent_task_id IN NUMBER DEFAULT NULL
589 , p_alarm_start IN NUMBER DEFAULT NULL
590 , p_alarm_start_uom IN VARCHAR2 DEFAULT NULL
591 , p_alarm_on IN VARCHAR2 DEFAULT NULL
592 , p_alarm_count IN NUMBER DEFAULT NULL
593 , p_alarm_interval IN NUMBER DEFAULT NULL
594 , p_alarm_interval_uom IN VARCHAR2 DEFAULT NULL
595 , p_palm_flag IN VARCHAR2 DEFAULT NULL
596 , p_wince_flag IN VARCHAR2 DEFAULT NULL
597 , p_laptop_flag IN VARCHAR2 DEFAULT NULL
598 , p_device1_flag IN VARCHAR2 DEFAULT NULL
599 , p_device2_flag IN VARCHAR2 DEFAULT NULL
600 , p_device3_flag IN VARCHAR2 DEFAULT NULL
601 , p_costs IN NUMBER DEFAULT NULL
602 , p_currency_code IN VARCHAR2 DEFAULT NULL
603 , p_escalation_level IN VARCHAR2 DEFAULT NULL
604 , p_task_assign_tbl IN task_assign_tbl DEFAULT g_miss_task_assign_tbl
605 , p_task_depends_tbl IN task_depends_tbl DEFAULT g_miss_task_depends_tbl
606 , p_task_rsrc_req_tbl IN task_rsrc_req_tbl DEFAULT g_miss_task_rsrc_req_tbl
607 , p_task_refer_tbl IN task_refer_tbl DEFAULT g_miss_task_refer_tbl
608 , p_task_dates_tbl IN task_dates_tbl DEFAULT g_miss_task_dates_tbl
609 , p_task_notes_tbl IN task_notes_tbl DEFAULT g_miss_task_notes_tbl
610 , p_task_recur_rec IN task_recur_rec DEFAULT g_miss_task_recur_rec
611 , p_task_contacts_tbl IN task_contacts_tbl DEFAULT g_miss_task_contacts_tbl
612 , x_return_status OUT NOCOPY VARCHAR2
613 , x_msg_count OUT NOCOPY NUMBER
614 , x_msg_data OUT NOCOPY VARCHAR2
615 , x_task_id OUT NOCOPY NUMBER
616 , p_attribute1 IN VARCHAR2 DEFAULT NULL
617 , p_attribute2 IN VARCHAR2 DEFAULT NULL
618 , p_attribute3 IN VARCHAR2 DEFAULT NULL
619 , p_attribute4 IN VARCHAR2 DEFAULT NULL
620 , p_attribute5 IN VARCHAR2 DEFAULT NULL
621 , p_attribute6 IN VARCHAR2 DEFAULT NULL
622 , p_attribute7 IN VARCHAR2 DEFAULT NULL
623 , p_attribute8 IN VARCHAR2 DEFAULT NULL
624 , p_attribute9 IN VARCHAR2 DEFAULT NULL
625 , p_attribute10 IN VARCHAR2 DEFAULT NULL
626 , p_attribute11 IN VARCHAR2 DEFAULT NULL
627 , p_attribute12 IN VARCHAR2 DEFAULT NULL
628 , p_attribute13 IN VARCHAR2 DEFAULT NULL
629 , p_attribute14 IN VARCHAR2 DEFAULT NULL
630 , p_attribute15 IN VARCHAR2 DEFAULT NULL
631 , p_attribute_category IN VARCHAR2 DEFAULT NULL
632 , p_date_selected IN VARCHAR2 DEFAULT NULL
633 , p_category_id IN NUMBER DEFAULT NULL
634 , p_show_on_calendar IN VARCHAR2 DEFAULT NULL
635 , p_owner_status_id IN NUMBER DEFAULT NULL
636 , p_template_id IN NUMBER DEFAULT NULL
637 , p_template_group_id IN NUMBER DEFAULT NULL
638 , p_enable_workflow IN VARCHAR2
639 DEFAULT fnd_profile.VALUE('JTF_TASK_ENABLE_WORKFLOW')
640 , p_abort_workflow IN VARCHAR2
641 DEFAULT fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
642 , p_task_split_flag IN VARCHAR2 DEFAULT NULL
643 , p_reference_flag IN VARCHAR2 DEFAULT NULL
644 , p_child_position IN VARCHAR2 DEFAULT NULL
645 , p_child_sequence_num IN NUMBER DEFAULT NULL
646 , p_location_id IN NUMBER
647 );
648
649 PROCEDURE create_task(
650 p_api_version IN NUMBER
651 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
652 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
653 , p_task_id IN NUMBER DEFAULT NULL
654 , p_task_name IN VARCHAR2
655 , p_task_type_name IN VARCHAR2 DEFAULT NULL
656 , p_task_type_id IN NUMBER DEFAULT NULL
657 , p_description IN VARCHAR2 DEFAULT NULL
658 , p_task_status_name IN VARCHAR2 DEFAULT NULL
659 , p_task_status_id IN NUMBER DEFAULT NULL
660 , p_task_priority_name IN VARCHAR2 DEFAULT NULL
661 , p_task_priority_id IN NUMBER DEFAULT NULL
662 , p_owner_type_name IN VARCHAR2 DEFAULT NULL
663 , p_owner_type_code IN VARCHAR2 DEFAULT NULL
664 , p_owner_id IN NUMBER DEFAULT NULL
665 , p_owner_territory_id IN NUMBER DEFAULT NULL
666 , p_assigned_by_name IN VARCHAR2 DEFAULT NULL
667 , p_assigned_by_id IN NUMBER DEFAULT NULL
668 , p_customer_number IN VARCHAR2 DEFAULT NULL
669 , -- from hz_parties
670 p_customer_id IN NUMBER DEFAULT NULL
671 , p_cust_account_number IN VARCHAR2 DEFAULT NULL
672 , p_cust_account_id IN NUMBER DEFAULT NULL
673 , p_address_id IN NUMBER DEFAULT NULL
674 , ---- hz_party_sites
675 p_address_number IN VARCHAR2 DEFAULT NULL
676 , p_planned_start_date IN DATE DEFAULT NULL
677 , p_planned_end_date IN DATE DEFAULT NULL
678 , p_scheduled_start_date IN DATE DEFAULT NULL
679 , p_scheduled_end_date IN DATE DEFAULT NULL
680 , p_actual_start_date IN DATE DEFAULT NULL
681 , p_actual_end_date IN DATE DEFAULT NULL
682 , p_timezone_id IN NUMBER DEFAULT NULL
683 , p_timezone_name IN VARCHAR2 DEFAULT NULL
684 , p_source_object_type_code IN VARCHAR2 DEFAULT NULL
685 , p_source_object_id IN NUMBER DEFAULT NULL
686 , p_source_object_name IN VARCHAR2 DEFAULT NULL
687 , p_duration IN NUMBER DEFAULT NULL
688 , p_duration_uom IN VARCHAR2 DEFAULT NULL
689 , p_planned_effort IN NUMBER DEFAULT NULL
690 , p_planned_effort_uom IN VARCHAR2 DEFAULT NULL
691 , p_actual_effort IN NUMBER DEFAULT NULL
692 , p_actual_effort_uom IN VARCHAR2 DEFAULT NULL
693 , p_percentage_complete IN NUMBER DEFAULT NULL
694 , p_reason_code IN VARCHAR2 DEFAULT NULL
695 , p_private_flag IN VARCHAR2 DEFAULT NULL
696 , p_publish_flag IN VARCHAR2 DEFAULT NULL
697 , p_restrict_closure_flag IN VARCHAR2 DEFAULT NULL
698 , p_multi_booked_flag IN VARCHAR2 DEFAULT NULL
699 , p_milestone_flag IN VARCHAR2 DEFAULT NULL
700 , p_holiday_flag IN VARCHAR2 DEFAULT NULL
701 , p_billable_flag IN VARCHAR2 DEFAULT NULL
702 , p_bound_mode_code IN VARCHAR2 DEFAULT NULL
703 , p_soft_bound_flag IN VARCHAR2 DEFAULT NULL
704 , p_workflow_process_id IN NUMBER DEFAULT NULL
705 , p_notification_flag IN VARCHAR2 DEFAULT NULL
706 , p_notification_period IN NUMBER DEFAULT NULL
707 , p_notification_period_uom IN VARCHAR2 DEFAULT NULL
708 , p_parent_task_number IN VARCHAR2 DEFAULT NULL
709 , p_parent_task_id IN NUMBER DEFAULT NULL
710 , p_alarm_start IN NUMBER DEFAULT NULL
711 , p_alarm_start_uom IN VARCHAR2 DEFAULT NULL
712 , p_alarm_on IN VARCHAR2 DEFAULT NULL
713 , p_alarm_count IN NUMBER DEFAULT NULL
714 , p_alarm_interval IN NUMBER DEFAULT NULL
715 , p_alarm_interval_uom IN VARCHAR2 DEFAULT NULL
716 , p_palm_flag IN VARCHAR2 DEFAULT NULL
717 , p_wince_flag IN VARCHAR2 DEFAULT NULL
718 , p_laptop_flag IN VARCHAR2 DEFAULT NULL
719 , p_device1_flag IN VARCHAR2 DEFAULT NULL
720 , p_device2_flag IN VARCHAR2 DEFAULT NULL
721 , p_device3_flag IN VARCHAR2 DEFAULT NULL
722 , p_costs IN NUMBER DEFAULT NULL
723 , p_currency_code IN VARCHAR2 DEFAULT NULL
724 , p_escalation_level IN VARCHAR2 DEFAULT NULL
725 , x_return_status OUT NOCOPY VARCHAR2
726 , x_msg_count OUT NOCOPY NUMBER
727 , x_msg_data OUT NOCOPY VARCHAR2
728 , x_task_id OUT NOCOPY NUMBER
729 , p_attribute1 IN VARCHAR2 DEFAULT NULL
730 , p_attribute2 IN VARCHAR2 DEFAULT NULL
731 , p_attribute3 IN VARCHAR2 DEFAULT NULL
732 , p_attribute4 IN VARCHAR2 DEFAULT NULL
733 , p_attribute5 IN VARCHAR2 DEFAULT NULL
734 , p_attribute6 IN VARCHAR2 DEFAULT NULL
735 , p_attribute7 IN VARCHAR2 DEFAULT NULL
736 , p_attribute8 IN VARCHAR2 DEFAULT NULL
737 , p_attribute9 IN VARCHAR2 DEFAULT NULL
738 , p_attribute10 IN VARCHAR2 DEFAULT NULL
739 , p_attribute11 IN VARCHAR2 DEFAULT NULL
740 , p_attribute12 IN VARCHAR2 DEFAULT NULL
741 , p_attribute13 IN VARCHAR2 DEFAULT NULL
742 , p_attribute14 IN VARCHAR2 DEFAULT NULL
743 , p_attribute15 IN VARCHAR2 DEFAULT NULL
744 , p_attribute_category IN VARCHAR2 DEFAULT NULL
745 , p_date_selected IN VARCHAR2 DEFAULT NULL
746 , p_category_id IN NUMBER DEFAULT NULL
747 , p_show_on_calendar IN VARCHAR2 DEFAULT NULL
748 , p_owner_status_id IN NUMBER DEFAULT NULL
749 , p_template_id IN NUMBER DEFAULT NULL
750 , p_template_group_id IN NUMBER DEFAULT NULL
751 , p_enable_workflow IN VARCHAR2
755 , p_child_position IN VARCHAR2 DEFAULT NULL
752 , p_abort_workflow IN VARCHAR2
753 , p_task_split_flag IN VARCHAR2
754 , p_reference_flag IN VARCHAR2 DEFAULT NULL
756 , p_child_sequence_num IN NUMBER DEFAULT NULL
757 );
758
759 PROCEDURE create_task(
760 p_api_version IN NUMBER
761 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
762 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
763 , p_task_id IN NUMBER DEFAULT NULL
764 , p_task_name IN VARCHAR2
765 , p_task_type_name IN VARCHAR2 DEFAULT NULL
766 , p_task_type_id IN NUMBER DEFAULT NULL
767 , p_description IN VARCHAR2 DEFAULT NULL
768 , p_task_status_name IN VARCHAR2 DEFAULT NULL
769 , p_task_status_id IN NUMBER DEFAULT NULL
770 , p_task_priority_name IN VARCHAR2 DEFAULT NULL
771 , p_task_priority_id IN NUMBER DEFAULT NULL
772 , p_owner_type_name IN VARCHAR2 DEFAULT NULL
773 , p_owner_type_code IN VARCHAR2 DEFAULT NULL
774 , p_owner_id IN NUMBER DEFAULT NULL
775 , p_owner_territory_id IN NUMBER DEFAULT NULL
776 , p_assigned_by_name IN VARCHAR2 DEFAULT NULL
777 , p_assigned_by_id IN NUMBER DEFAULT NULL
778 , p_customer_number IN VARCHAR2 DEFAULT NULL
779 , -- from hz_parties
780 p_customer_id IN NUMBER DEFAULT NULL
781 , p_cust_account_number IN VARCHAR2 DEFAULT NULL
782 , p_cust_account_id IN NUMBER DEFAULT NULL
783 , p_address_id IN NUMBER DEFAULT NULL
784 , ---- hz_party_sites
785 p_address_number IN VARCHAR2 DEFAULT NULL
786 , p_planned_start_date IN DATE DEFAULT NULL
787 , p_planned_end_date IN DATE DEFAULT NULL
788 , p_scheduled_start_date IN DATE DEFAULT NULL
789 , p_scheduled_end_date IN DATE DEFAULT NULL
790 , p_actual_start_date IN DATE DEFAULT NULL
791 , p_actual_end_date IN DATE DEFAULT NULL
792 , p_timezone_id IN NUMBER DEFAULT NULL
793 , p_timezone_name IN VARCHAR2 DEFAULT NULL
794 , p_source_object_type_code IN VARCHAR2 DEFAULT NULL
795 , p_source_object_id IN NUMBER DEFAULT NULL
796 , p_source_object_name IN VARCHAR2 DEFAULT NULL
797 , p_duration IN NUMBER DEFAULT NULL
798 , p_duration_uom IN VARCHAR2 DEFAULT NULL
799 , p_planned_effort IN NUMBER DEFAULT NULL
800 , p_planned_effort_uom IN VARCHAR2 DEFAULT NULL
801 , p_actual_effort IN NUMBER DEFAULT NULL
802 , p_actual_effort_uom IN VARCHAR2 DEFAULT NULL
803 , p_percentage_complete IN NUMBER DEFAULT NULL
804 , p_reason_code IN VARCHAR2 DEFAULT NULL
805 , p_private_flag IN VARCHAR2 DEFAULT NULL
806 , p_publish_flag IN VARCHAR2 DEFAULT NULL
807 , p_restrict_closure_flag IN VARCHAR2 DEFAULT NULL
808 , p_multi_booked_flag IN VARCHAR2 DEFAULT NULL
809 , p_milestone_flag IN VARCHAR2 DEFAULT NULL
810 , p_holiday_flag IN VARCHAR2 DEFAULT NULL
811 , p_billable_flag IN VARCHAR2 DEFAULT NULL
812 , p_bound_mode_code IN VARCHAR2 DEFAULT NULL
813 , p_soft_bound_flag IN VARCHAR2 DEFAULT NULL
814 , p_workflow_process_id IN NUMBER DEFAULT NULL
815 , p_notification_flag IN VARCHAR2 DEFAULT NULL
816 , p_notification_period IN NUMBER DEFAULT NULL
817 , p_notification_period_uom IN VARCHAR2 DEFAULT NULL
818 , p_parent_task_number IN VARCHAR2 DEFAULT NULL
819 , p_parent_task_id IN NUMBER DEFAULT NULL
820 , p_alarm_start IN NUMBER DEFAULT NULL
821 , p_alarm_start_uom IN VARCHAR2 DEFAULT NULL
822 , p_alarm_on IN VARCHAR2 DEFAULT NULL
823 , p_alarm_count IN NUMBER DEFAULT NULL
824 , p_alarm_interval IN NUMBER DEFAULT NULL
825 , p_alarm_interval_uom IN VARCHAR2 DEFAULT NULL
826 , p_palm_flag IN VARCHAR2 DEFAULT NULL
827 , p_wince_flag IN VARCHAR2 DEFAULT NULL
828 , p_laptop_flag IN VARCHAR2 DEFAULT NULL
829 , p_device1_flag IN VARCHAR2 DEFAULT NULL
830 , p_device2_flag IN VARCHAR2 DEFAULT NULL
831 , p_device3_flag IN VARCHAR2 DEFAULT NULL
832 , p_costs IN NUMBER DEFAULT NULL
833 , p_currency_code IN VARCHAR2 DEFAULT NULL
834 , p_escalation_level IN VARCHAR2 DEFAULT NULL
835 , x_return_status OUT NOCOPY VARCHAR2
836 , x_msg_count OUT NOCOPY NUMBER
837 , x_msg_data OUT NOCOPY VARCHAR2
838 , x_task_id OUT NOCOPY NUMBER
839 , p_attribute1 IN VARCHAR2 DEFAULT NULL
840 , p_attribute2 IN VARCHAR2 DEFAULT NULL
841 , p_attribute3 IN VARCHAR2 DEFAULT NULL
842 , p_attribute4 IN VARCHAR2 DEFAULT NULL
843 , p_attribute5 IN VARCHAR2 DEFAULT NULL
844 , p_attribute6 IN VARCHAR2 DEFAULT NULL
845 , p_attribute7 IN VARCHAR2 DEFAULT NULL
846 , p_attribute8 IN VARCHAR2 DEFAULT NULL
847 , p_attribute9 IN VARCHAR2 DEFAULT NULL
848 , p_attribute10 IN VARCHAR2 DEFAULT NULL
849 , p_attribute11 IN VARCHAR2 DEFAULT NULL
850 , p_attribute12 IN VARCHAR2 DEFAULT NULL
851 , p_attribute13 IN VARCHAR2 DEFAULT NULL
852 , p_attribute14 IN VARCHAR2 DEFAULT NULL
853 , p_attribute15 IN VARCHAR2 DEFAULT NULL
854 , p_attribute_category IN VARCHAR2 DEFAULT NULL
855 , p_date_selected IN VARCHAR2 DEFAULT NULL
856 , p_category_id IN NUMBER DEFAULT NULL
857 , p_show_on_calendar IN VARCHAR2 DEFAULT NULL
858 , p_owner_status_id IN NUMBER DEFAULT NULL
859 , p_template_id IN NUMBER DEFAULT NULL
860 , p_template_group_id IN NUMBER DEFAULT NULL
861 , p_enable_workflow IN VARCHAR2
862 , p_abort_workflow IN VARCHAR2
863 );
864
865 PROCEDURE create_task(
866 p_api_version IN NUMBER
867 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
868 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
869 , p_task_id IN NUMBER DEFAULT NULL
870 , p_task_name IN VARCHAR2
871 , p_task_type_name IN VARCHAR2 DEFAULT NULL
872 , p_task_type_id IN NUMBER DEFAULT NULL
873 , p_description IN VARCHAR2 DEFAULT NULL
874 , p_task_status_name IN VARCHAR2 DEFAULT NULL
875 , p_task_status_id IN NUMBER DEFAULT NULL
876 , p_task_priority_name IN VARCHAR2 DEFAULT NULL
877 , p_task_priority_id IN NUMBER DEFAULT NULL
878 , p_owner_type_name IN VARCHAR2 DEFAULT NULL
879 , p_owner_type_code IN VARCHAR2 DEFAULT NULL
880 , p_owner_id IN NUMBER DEFAULT NULL
881 , p_owner_territory_id IN NUMBER DEFAULT NULL
882 , p_assigned_by_name IN VARCHAR2 DEFAULT NULL
883 , p_assigned_by_id IN NUMBER DEFAULT NULL
884 , p_customer_number IN VARCHAR2 DEFAULT NULL
885 , -- from hz_parties
886 p_customer_id IN NUMBER DEFAULT NULL
887 , p_cust_account_number IN VARCHAR2 DEFAULT NULL
888 , p_cust_account_id IN NUMBER DEFAULT NULL
889 , p_address_id IN NUMBER DEFAULT NULL
890 , ---- hz_party_sites
891 p_address_number IN VARCHAR2 DEFAULT NULL
892 , p_planned_start_date IN DATE DEFAULT NULL
893 , p_planned_end_date IN DATE DEFAULT NULL
894 , p_scheduled_start_date IN DATE DEFAULT NULL
895 , p_scheduled_end_date IN DATE DEFAULT NULL
896 , p_actual_start_date IN DATE DEFAULT NULL
897 , p_actual_end_date IN DATE DEFAULT NULL
898 , p_timezone_id IN NUMBER DEFAULT NULL
899 , p_timezone_name IN VARCHAR2 DEFAULT NULL
900 , p_source_object_type_code IN VARCHAR2 DEFAULT NULL
901 , p_source_object_id IN NUMBER DEFAULT NULL
902 , p_source_object_name IN VARCHAR2 DEFAULT NULL
903 , p_duration IN NUMBER DEFAULT NULL
904 , p_duration_uom IN VARCHAR2 DEFAULT NULL
905 , p_planned_effort IN NUMBER DEFAULT NULL
906 , p_planned_effort_uom IN VARCHAR2 DEFAULT NULL
907 , p_actual_effort IN NUMBER DEFAULT NULL
908 , p_actual_effort_uom IN VARCHAR2 DEFAULT NULL
909 , p_percentage_complete IN NUMBER DEFAULT NULL
910 , p_reason_code IN VARCHAR2 DEFAULT NULL
911 , p_private_flag IN VARCHAR2 DEFAULT NULL
912 , p_publish_flag IN VARCHAR2 DEFAULT NULL
913 , p_restrict_closure_flag IN VARCHAR2 DEFAULT NULL
914 , p_multi_booked_flag IN VARCHAR2 DEFAULT NULL
915 , p_milestone_flag IN VARCHAR2 DEFAULT NULL
916 , p_holiday_flag IN VARCHAR2 DEFAULT NULL
917 , p_billable_flag IN VARCHAR2 DEFAULT NULL
918 , p_bound_mode_code IN VARCHAR2 DEFAULT NULL
919 , p_soft_bound_flag IN VARCHAR2 DEFAULT NULL
920 , p_workflow_process_id IN NUMBER DEFAULT NULL
921 , p_notification_flag IN VARCHAR2 DEFAULT NULL
922 , p_notification_period IN NUMBER DEFAULT NULL
923 , p_notification_period_uom IN VARCHAR2 DEFAULT NULL
924 , p_parent_task_number IN VARCHAR2 DEFAULT NULL
925 , p_parent_task_id IN NUMBER DEFAULT NULL
926 , p_alarm_start IN NUMBER DEFAULT NULL
927 , p_alarm_start_uom IN VARCHAR2 DEFAULT NULL
928 , p_alarm_on IN VARCHAR2 DEFAULT NULL
929 , p_alarm_count IN NUMBER DEFAULT NULL
930 , p_alarm_interval IN NUMBER DEFAULT NULL
931 , p_alarm_interval_uom IN VARCHAR2 DEFAULT NULL
932 , p_palm_flag IN VARCHAR2 DEFAULT NULL
933 , p_wince_flag IN VARCHAR2 DEFAULT NULL
934 , p_laptop_flag IN VARCHAR2 DEFAULT NULL
935 , p_device1_flag IN VARCHAR2 DEFAULT NULL
936 , p_device2_flag IN VARCHAR2 DEFAULT NULL
937 , p_device3_flag IN VARCHAR2 DEFAULT NULL
938 , p_costs IN NUMBER DEFAULT NULL
939 , p_currency_code IN VARCHAR2 DEFAULT NULL
940 , p_escalation_level IN VARCHAR2 DEFAULT NULL
941 , p_task_assign_tbl IN task_assign_tbl DEFAULT g_miss_task_assign_tbl
942 , p_task_depends_tbl IN task_depends_tbl DEFAULT g_miss_task_depends_tbl
943 , p_task_rsrc_req_tbl IN task_rsrc_req_tbl DEFAULT g_miss_task_rsrc_req_tbl
944 , p_task_refer_tbl IN task_refer_tbl DEFAULT g_miss_task_refer_tbl
945 , p_task_dates_tbl IN task_dates_tbl DEFAULT g_miss_task_dates_tbl
946 , p_task_notes_tbl IN task_notes_tbl DEFAULT g_miss_task_notes_tbl
947 , p_task_recur_rec IN task_recur_rec DEFAULT g_miss_task_recur_rec
948 , p_task_contacts_tbl IN task_contacts_tbl DEFAULT g_miss_task_contacts_tbl
949 , x_return_status OUT NOCOPY VARCHAR2
950 , x_msg_count OUT NOCOPY NUMBER
951 , x_msg_data OUT NOCOPY VARCHAR2
952 , x_task_id OUT NOCOPY NUMBER
953 , p_attribute1 IN VARCHAR2 DEFAULT NULL
954 , p_attribute2 IN VARCHAR2 DEFAULT NULL
955 , p_attribute3 IN VARCHAR2 DEFAULT NULL
956 , p_attribute4 IN VARCHAR2 DEFAULT NULL
957 , p_attribute5 IN VARCHAR2 DEFAULT NULL
958 , p_attribute6 IN VARCHAR2 DEFAULT NULL
959 , p_attribute7 IN VARCHAR2 DEFAULT NULL
960 , p_attribute8 IN VARCHAR2 DEFAULT NULL
961 , p_attribute9 IN VARCHAR2 DEFAULT NULL
962 , p_attribute10 IN VARCHAR2 DEFAULT NULL
963 , p_attribute11 IN VARCHAR2 DEFAULT NULL
964 , p_attribute12 IN VARCHAR2 DEFAULT NULL
965 , p_attribute13 IN VARCHAR2 DEFAULT NULL
966 , p_attribute14 IN VARCHAR2 DEFAULT NULL
967 , p_attribute15 IN VARCHAR2 DEFAULT NULL
968 , p_attribute_category IN VARCHAR2 DEFAULT NULL
969 , p_date_selected IN VARCHAR2 DEFAULT NULL
970 , p_category_id IN NUMBER DEFAULT NULL
971 , p_show_on_calendar IN VARCHAR2 DEFAULT NULL
972 , p_owner_status_id IN NUMBER DEFAULT NULL
973 , p_template_id IN NUMBER DEFAULT NULL
974 , p_template_group_id IN NUMBER DEFAULT NULL
975 );
976
977 /*#
978 * Updates an existing task.
979 *
980 * @param p_api_version Standard API version number. See "Standard IN Parameters", Oracle Common Application Calendar API Reference Guide.
981 * @rep:paraminfo {@rep:required}
982 * @param p_init_msg_list Standard API flag allows API callers to request that the API does the initialization of the message list on their behalf. By default, the message list will not be initialized.
983 * See "Standard IN Parameters", Oracle Common Application Calendar API Reference Guide.
984 * @param p_commit Standard API flag is used by API callers to ask the API to commit on their behalf after performing its function. By default, the commit will not be performed.
988 * <LI><Code>FND_API.G_RET_STS_ERROR</Code> - If there was an expected error in API processing.
985 * See "Standard IN Parameters", Oracle Common Application Calendar API Reference Guide.
986 * @param x_return_status Result of all the operations performed by the API. This will have one of the following values:
987 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code> - If the API processed the data successfully.
989 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code> If there was an unexpected error in API processing.
990 * @param x_msg_count Number of messages returned in the API message list.
991 * @param x_msg_data Returned message data in an encoded format if <code>x_msg_count</code> returns non-zero value.
992 * @param p_object_version_number Object version number of the current task record.
993 * @rep:paraminfo {@rep:required}
994 * @param p_task_id Unique task identifier of task to be updated. Either <code>p_task_id</code> or <code>p_task_number</code> must be passed.
995 * @rep:paraminfo {@rep:required}
996 * @param p_task_number Unique task number of task to be updated. Either <code>p_task_id</code> or <code>p_task_number</code> must be passed.
997 * @rep:paraminfo {@rep:required}
998 * @param p_task_name Subject of the task.
999 * @paraminfo {@rep:precision 80}
1000 * @param p_task_type_name Task type name. Either type name or <code>p_task_type_id</code> can be passed.
1001 * @param p_task_type_id Unique task type identifier. This is a foreign key to <code>jtf_task_types_b.task_type_id</code>.
1002 * @param p_description Optional task description.
1003 * @paraminfo {@rep:precision 4000}
1004 * @param p_task_status_name Task status name. Either status name or <code>p_task_status_id</code> can be passed.
1005 * @param p_task_status_id Unique task status identifier. This is a foreign key to <code>jtf_task_statuses_b.task_status_id</code>.
1006 * @param p_task_priority_name Task priority name. Either priority name or <code>p_task_priority_id</code> can be passed.
1007 * @param p_task_priority_id Unique task priority identifier. This is a foreign key to <code>jtf_task_priorities_b.task_priority_id</code>.
1008 * @param p_owner_type_name No longer in use.
1009 * @param p_owner_type_code Resource type code for the task owner. A task owner is identified with the task resource type code and task resource identifier, therefore this should be used along with <code>p_owner_id</code>.
1010 * @param p_owner_id Resource identifier for the task owner. Should be used along with <code>p_owner_type_code</code>.
1011 * @param p_owner_territory_id Territory identification of the task owner.
1012 * @param p_assigned_by_name No longer in use.
1013 * @param p_assigned_by_id No longer in use.
1014 * @param p_customer_number Unique customer number. Either customer number or <code>p_customer_id</code> can be passed to associate the customer with the task.
1015 * This is validated against <code>hz_parties.party_number</code>.
1016 * @param p_customer_id Unique customer identifier. Either customer identifier or <code>p_customer_number</code> can be passed to associate the customer with the task.
1017 * This is validated against <code>hz_parties.party_id</code>.
1018 * @param p_cust_account_number Customer account number that can be set on a task with an associated customer. Either customer account number or <code>p_customer_account_id</code> can be passed.
1019 * This is validated against <code>hz_cust_accounts.account_number</code>.
1020 * @param p_cust_account_id Unique customer account identifier that can be set on a task with an associated customer. Either customer account identifier or <code>p_customer_account_number</code> can be passed.
1021 * This is validated against <code>hz_cust_accounts.cust_account_id</code>.
1022 * @param p_address_number Customer address number that can be set on a task with an associated customer. Either customer address number or <code>p_address_id</code> can be passed.
1023 * This is validated against <code>hz_party_sites.party_site_number</code>.
1024 * @param p_address_id Unique customer address identifier that can be set on a task with an associated customer. Either customer address identifier or <code>p_address_number</code> can be passed.
1025 * This is validated against <code>hz_party_sites.party_site_id</code>.
1026 * @param p_planned_start_date Planned start date for this task.
1027 * @param p_planned_end_date Planned end date for this task.
1028 * @param p_scheduled_start_date Scheduled start date for this task.
1029 * @param p_scheduled_end_date Scheduled end date for this task.
1030 * @param p_actual_start_date Actual start date for this task.
1031 * @param p_actual_end_date Actual end date for this task.
1032 * @param p_timezone_id Timezone identifier used for this task dates. Either timezone identifier or <code>p_timezone_name</code> can be passed. This is validated against <code>hz_timezones.timezone_id</code>.
1033 * @param p_timezone_name Timezone name used for this task dates. Either timezone name or <code>p_timezone_id</code> can be passed. This is validated against <code>hz_timezones.global_timezone_name</code>.
1034 * @param p_source_object_type_code Object code used as the source type for this task. The object code can be either <code>'TASK'</code> for standalone tasks or a registered object with usage of <code>'TASK'</code> for contextual tasks.
1035 * This is a foreign key to <code>jtf_objects_b.object_code</code>.
1036 * @param p_source_object_id Unique source object identifier used to identify and validate the task source. This must be provided for any contextual task.
1037 * @param p_source_object_name No longer in use.
1038 * @param p_duration Duration of this task. Should be used along with <code>p_duration_uom</code>.
1039 * @param p_duration_uom Unit of measure for the duration. Should be used along with <code>p_duration</code>.
1040 * @param p_planned_effort Planned effort for this task. Should be used along with <code>p_planned_effort_uom</code>.
1041 * @param p_planned_effort_uom Unit of Measure for the planned effort. Should be used along with <code>p_planned_effort</code>.
1042 * @param p_actual_effort Actual effort exerted for this task. Should be used along with <code>p_actual_effort_uom</code>.
1043 * @param p_actual_effort_uom Unit of Measure for the actual effort. Should be used along with <code>p_actual_effort</code>.
1044 * @param p_percentage_complete Percentage of this task completion.
1045 * @param p_reason_code Reserved for internal use only. Reason code is used to check if the task is automated.
1046 * @param p_private_flag Flag used to mark this task as a private task. This flag is used by task user interface to limit the task visibility to the task owner and assignee only.
1047 * @param p_publish_flag Flag used to mark this task as a published task. This flag is used by task user interface to set the task for publishing.
1048 * @param p_restrict_closure_flag Reserved for internal use only.
1049 * @param p_multi_booked_flag Reserved for internal use only.
1050 * @param p_milestone_flag Flag used to mark this task as milestone.
1051 * @param p_holiday_flag Flag used to mark this task execution during holidays.
1052 * @param p_billable_flag Flag used to mark this task for billing.
1053 * @param p_bound_mode_code Reserved for internal use only.
1054 * @param p_soft_bound_flag Reserved for internal use only.
1055 * @param p_workflow_process_id Process identifier of last workflow launched.
1056 * @param p_notification_flag Notification flag used to automatically launch workflow.
1057 * @param p_notification_period Notification period is the time period after which workflow is sent to the task assignees. Should be used along with <code>p_notification_period_uom</code>.
1058 * @param p_notification_period_uom Unit of measure for notification period. Should be used along with <code>p_notification_period</code>.
1059 * @param p_parent_task_number Parent task number for this tasks. Either parent task number or <code>p_parent_task_number</code> can be passed.
1060 * @param p_parent_task_id Parent task identifier for this tasks. Either parent task identifier or <code>p_parent_task_id</code> can be passed.
1061 * @param p_alarm_start Time when the first alarm is fired. Should be used along with <code>p_alarm_start_uom</code>.
1062 * @param p_alarm_start_uom Unit of measure for alarm start. Should be used along with <code>p_alarm_start</code>.
1063 * @param p_alarm_on Indicates is alarm turned on.
1064 * @param p_alarm_count Total number of alarms.
1065 * @param p_alarm_fired_count Total number of alarms has been fired.
1066 * @param p_alarm_interval Alarm firing interval. Should be used along with <code>p_alarm_interval_uom</code>.
1067 * @param p_alarm_interval_uom Unit of measure for alarm interval. Should be used along with <code>p_alarm_interval</code>.
1068 * @param p_palm_flag Reserved for internal use only.
1069 * @param p_wince_flag Reserved for internal use only.
1070 * @param p_laptop_flag Reserved for internal use only.
1071 * @param p_device1_flag Reserved for internal use only.
1072 * @param p_device2_flag Reserved for internal use only.
1073 * @param p_device3_flag Reserved for internal use only.
1074 * @param p_costs Reserved for internal use only.
1075 * @param p_currency_code Reserved for internal use only.
1076 * @param p_escalation_level Level of escalation used by Escalation Module.
1077 * @param p_attribute1 Attribute1 of customer flex fields.
1078 * @param p_attribute2 Attribute2 of customer flex fields.
1079 * @param p_attribute3 Attribute3 of customer flex fields.
1080 * @param p_attribute4 Attribute4 of customer flex fields.
1081 * @param p_attribute5 Attribute5 of customer flex fields.
1082 * @param p_attribute6 Attribute6 of customer flex fields.
1083 * @param p_attribute7 Attribute7 of customer flex fields.
1084 * @param p_attribute8 Attribute8 of customer flex fields.
1085 * @param p_attribute9 Attribute9 of customer flex fields.
1086 * @param p_attribute10 Attribute10 of customer flex fields.
1087 * @param p_attribute11 Attribute11 of customer flex fields.
1088 * @param p_attribute12 Attribute12 of customer flex fields.
1089 * @param p_attribute13 Attribute13 of customer flex fields.
1090 * @param p_attribute14 Attribute14 of customer flex fields.
1091 * @param p_attribute15 Attribute15 of customer flex fields.
1092 * @param p_attribute_category Attribute category for the customer flex fields.
1093 * @param p_date_selected Flag used to select which date pair (Planned, Scheduled, or Actual) will be used as calendar date. The default value is set by profile options.
1094 * @param p_category_id Reserved unique identifier for personal category defined by resource in their calendar. This is a foreign key to <code>jtf_perz_data.perz_date_id</code>.
1095 * @param p_show_on_calendar Flag to show task on resource's calendar. The task will only show up on Resource's calendar if this flag is set to <code>'Y'</code> and there is a set of date with time present on task level.
1096 * This flag is defaulted to <code>'Y'</code> if not passed.
1097 * @param p_owner_status_id No longer in use.
1098 * @param p_enable_workflow Flag to enable workflow passed as-is to <code>oracle.apps.jtf.cac.task.updateTask</code> business event.
1099 * @rep:paraminfo {@rep:required}
1100 * @param p_abort_workflow Flag to abort workflow passed as-is to <code>oracle.apps.jtf.cac.task.updateTask</code> business event.
1101 * @rep:paraminfo {@rep:required}
1102 * @param p_task_split_flag Reserved for internal use only. This flag is used to denote split tasks created by Field Service.
1103 * @rep:paraminfo {@rep:required}
1104 * The following two values are currently used:
1105 * <LI><code>'M'</code> - for a master (parent) task
1106 * <LI><code>'D'</code> - for a dependent (child) task.
1107 * @param p_child_position Reserved for internal use only. This flag is used by Field Service to mark child position for split tasks
1108 * @param p_child_sequence_num Reserved for internal use only. It is used by Field Service to mark child sequence for split tasks
1109 * @param p_location_id Reserved for internal use only. It is used by Field Service to modify location id in task table
1110 * @rep:paraminfo {@rep:required}
1111 *
1112 * @rep:primaryinstance
1113 * @rep:scope public
1114 * @rep:lifecycle active
1115 * @rep:displayname Update Task
1116 * @rep:compatibility S
1117 * @rep:businessevent oracle.apps.jtf.cac.task.updateTask
1118 * @rep:metalink 249665.1 Oracle Common Application Calendar - API Reference Guide
1119 * @rep:category BUSINESS_ENTITY CS_SERVICE_REQUEST
1120 * @rep:category BUSINESS_ENTITY AS_OPPORTUNITY
1121 * @rep:category BUSINESS_ENTITY AMS_LEAD
1122 */
1123 PROCEDURE update_task(
1124 p_api_version IN NUMBER
1125 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1126 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
1127 , p_object_version_number IN OUT NOCOPY NUMBER
1128 , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
1129 , p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1130 , p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1131 , p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1132 , p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
1133 , p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1134 , p_task_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1135 , p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
1136 , p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1137 , p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num
1138 , p_owner_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1139 , p_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1140 , p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num
1141 , p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num
1142 , p_assigned_by_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1143 , p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num
1144 , p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1145 , -- from hz_parties
1146 p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num
1147 , p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1148 , p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num
1149 , p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num
1150 , ---- hz_party_sites
1151 p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1152 , p_planned_start_date IN DATE DEFAULT fnd_api.g_miss_date
1153 , p_planned_end_date IN DATE DEFAULT fnd_api.g_miss_date
1154 , p_scheduled_start_date IN DATE DEFAULT fnd_api.g_miss_date
1155 , p_scheduled_end_date IN DATE DEFAULT fnd_api.g_miss_date
1156 , p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date
1157 , p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date
1158 , p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num
1159 , p_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1160 , p_source_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1161 , p_source_object_id IN NUMBER DEFAULT fnd_api.g_miss_num
1162 , p_source_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1163 , p_duration IN NUMBER DEFAULT fnd_api.g_miss_num
1164 , p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1165 , p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num
1169 , p_percentage_complete IN NUMBER DEFAULT fnd_api.g_miss_num
1166 , p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1167 , p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num
1168 , p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1170 , p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1171 , p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1172 , p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1173 , p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1174 , p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1175 , p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1176 , p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1177 , p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1178 , p_bound_mode_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1179 , p_soft_bound_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1180 , p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num
1181 , p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1182 , p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num
1183 , p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1184 , p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num
1185 , p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1186 , p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1187 , p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num
1188 , p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num
1189 , p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num
1190 , p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1191 , p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1192 , p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1193 , p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1194 , p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1195 , p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1196 , p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1197 , p_costs IN NUMBER DEFAULT fnd_api.g_miss_num
1198 , p_currency_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1199 , p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1200 , x_return_status OUT NOCOPY VARCHAR2
1201 , x_msg_count OUT NOCOPY NUMBER
1202 , x_msg_data OUT NOCOPY VARCHAR2
1203 , p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1204 , p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1205 , p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1206 , p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1207 , p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1208 , p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1209 , p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1210 , p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1211 , p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1212 , p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1213 , p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1214 , p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1215 , p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1216 , p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1217 , p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1218 , p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1219 , p_date_selected IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1220 , p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
1221 , p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1222 , p_owner_status_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
1223 , p_parent_task_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
1224 , p_parent_task_number IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1225 , p_enable_workflow IN VARCHAR2
1226 , p_abort_workflow IN VARCHAR2
1227 , p_task_split_flag IN VARCHAR2
1228 , p_child_position IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1229 , p_child_sequence_num IN NUMBER DEFAULT jtf_task_utl.g_miss_number
1230 , p_location_id IN NUMBER
1231 );
1232
1233 -- Simplex Enhancements ..
1234 PROCEDURE update_task(
1235 p_api_version IN NUMBER
1236 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1237 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
1238 , p_object_version_number IN OUT NOCOPY NUMBER
1239 , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
1240 , p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1241 , p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1242 , p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1243 , p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
1244 , p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1245 , p_task_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1246 , p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
1247 , p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1248 , p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num
1249 , p_owner_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1250 , p_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1251 , p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num
1252 , p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num
1253 , p_assigned_by_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1254 , p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num
1255 , p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1256 , -- from hz_parties
1257 p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num
1258 , p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1259 , p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num
1260 , p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num
1261 , ---- hz_party_sites
1262 p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1263 , p_planned_start_date IN DATE DEFAULT fnd_api.g_miss_date
1264 , p_planned_end_date IN DATE DEFAULT fnd_api.g_miss_date
1265 , p_scheduled_start_date IN DATE DEFAULT fnd_api.g_miss_date
1266 , p_scheduled_end_date IN DATE DEFAULT fnd_api.g_miss_date
1267 , p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date
1268 , p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date
1269 , p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num
1270 , p_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1271 , p_source_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1272 , p_source_object_id IN NUMBER DEFAULT fnd_api.g_miss_num
1273 , p_source_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1274 , p_duration IN NUMBER DEFAULT fnd_api.g_miss_num
1275 , p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1276 , p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num
1277 , p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1278 , p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num
1279 , p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1280 , p_percentage_complete IN NUMBER DEFAULT fnd_api.g_miss_num
1281 , p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1282 , p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1283 , p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1284 , p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1285 , p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1286 , p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1287 , p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1288 , p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1289 , p_bound_mode_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1290 , p_soft_bound_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1291 , p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num
1292 , p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1293 , p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num
1294 , p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1295 , p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num
1296 , p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1297 , p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1298 , p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num
1299 , p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num
1300 , p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num
1301 , p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1302 , p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1303 , p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1304 , p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1305 , p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1306 , p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1307 , p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1308 , p_costs IN NUMBER DEFAULT fnd_api.g_miss_num
1309 , p_currency_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1310 , p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1311 , x_return_status OUT NOCOPY VARCHAR2
1312 , x_msg_count OUT NOCOPY NUMBER
1313 , x_msg_data OUT NOCOPY VARCHAR2
1314 , p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1315 , p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1316 , p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1317 , p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1318 , p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1319 , p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1323 , p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1320 , p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1321 , p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1322 , p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1324 , p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1325 , p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1326 , p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1327 , p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1328 , p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1329 , p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1330 , p_date_selected IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1331 , p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
1332 , p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1333 , p_owner_status_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
1334 , p_parent_task_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
1335 , p_parent_task_number IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1336 , p_enable_workflow IN VARCHAR2
1337 , p_abort_workflow IN VARCHAR2
1338 , p_task_split_flag IN VARCHAR2
1339 , p_child_position IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1340 , p_child_sequence_num IN NUMBER DEFAULT jtf_task_utl.g_miss_number
1341 );
1342
1343 PROCEDURE update_task(
1344 p_api_version IN NUMBER
1345 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1346 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
1347 , p_object_version_number IN OUT NOCOPY NUMBER
1348 , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
1349 , p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1350 , p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1351 , p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1352 , p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
1353 , p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1354 , p_task_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1355 , p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
1356 , p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1357 , p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num
1358 , p_owner_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1359 , p_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1360 , p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num
1361 , p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num
1362 , p_assigned_by_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1363 , p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num
1364 , p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1365 , -- from hz_parties
1366 p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num
1367 , p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1368 , p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num
1369 , p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num
1370 , ---- hz_party_sites
1371 p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1372 , p_planned_start_date IN DATE DEFAULT fnd_api.g_miss_date
1373 , p_planned_end_date IN DATE DEFAULT fnd_api.g_miss_date
1374 , p_scheduled_start_date IN DATE DEFAULT fnd_api.g_miss_date
1375 , p_scheduled_end_date IN DATE DEFAULT fnd_api.g_miss_date
1376 , p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date
1377 , p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date
1378 , p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num
1379 , p_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1380 , p_source_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1381 , p_source_object_id IN NUMBER DEFAULT fnd_api.g_miss_num
1382 , p_source_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1383 , p_duration IN NUMBER DEFAULT fnd_api.g_miss_num
1384 , p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1385 , p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num
1386 , p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1387 , p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num
1388 , p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1389 , p_percentage_complete IN NUMBER DEFAULT fnd_api.g_miss_num
1390 , p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1391 , p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1392 , p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1393 , p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1394 , p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1395 , p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1396 , p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1397 , p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1398 , p_bound_mode_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1399 , p_soft_bound_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1403 , p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1400 , p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num
1401 , p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1402 , p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num
1404 , p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num
1405 , p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1406 , p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1407 , p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num
1408 , p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num
1409 , p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num
1410 , p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1411 , p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1412 , p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1413 , p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1414 , p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1415 , p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1416 , p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1417 , p_costs IN NUMBER DEFAULT fnd_api.g_miss_num
1418 , p_currency_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1419 , p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1420 , x_return_status OUT NOCOPY VARCHAR2
1421 , x_msg_count OUT NOCOPY NUMBER
1422 , x_msg_data OUT NOCOPY VARCHAR2
1423 , p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1424 , p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1425 , p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1426 , p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1427 , p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1428 , p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1429 , p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1430 , p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1431 , p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1432 , p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1433 , p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1434 , p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1435 , p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1436 , p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1437 , p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1438 , p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1439 , p_date_selected IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1440 , p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
1441 , p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1442 , p_owner_status_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
1443 , p_parent_task_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
1444 , p_parent_task_number IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1445 , p_enable_workflow IN VARCHAR2
1446 , p_abort_workflow IN VARCHAR2
1447 );
1448
1449 PROCEDURE update_task(
1450 p_api_version IN NUMBER
1451 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1452 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
1453 , p_object_version_number IN OUT NOCOPY NUMBER
1454 , p_task_id IN NUMBER DEFAULT fnd_api.g_miss_num
1458 , p_task_type_id IN NUMBER DEFAULT fnd_api.g_miss_num
1455 , p_task_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1456 , p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1457 , p_task_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1459 , p_description IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1460 , p_task_status_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1461 , p_task_status_id IN NUMBER DEFAULT fnd_api.g_miss_num
1462 , p_task_priority_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1463 , p_task_priority_id IN NUMBER DEFAULT fnd_api.g_miss_num
1464 , p_owner_type_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1465 , p_owner_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1466 , p_owner_id IN NUMBER DEFAULT fnd_api.g_miss_num
1467 , p_owner_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num
1468 , p_assigned_by_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1469 , p_assigned_by_id IN NUMBER DEFAULT fnd_api.g_miss_num
1470 , p_customer_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1471 , -- from hz_parties
1472 p_customer_id IN NUMBER DEFAULT fnd_api.g_miss_num
1473 , p_cust_account_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1474 , p_cust_account_id IN NUMBER DEFAULT fnd_api.g_miss_num
1475 , p_address_id IN NUMBER DEFAULT fnd_api.g_miss_num
1476 , ---- hz_party_sites
1477 p_address_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1478 , p_planned_start_date IN DATE DEFAULT fnd_api.g_miss_date
1479 , p_planned_end_date IN DATE DEFAULT fnd_api.g_miss_date
1480 , p_scheduled_start_date IN DATE DEFAULT fnd_api.g_miss_date
1481 , p_scheduled_end_date IN DATE DEFAULT fnd_api.g_miss_date
1482 , p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date
1483 , p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date
1484 , p_timezone_id IN NUMBER DEFAULT fnd_api.g_miss_num
1485 , p_timezone_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1486 , p_source_object_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1487 , p_source_object_id IN NUMBER DEFAULT fnd_api.g_miss_num
1488 , p_source_object_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1489 , p_duration IN NUMBER DEFAULT fnd_api.g_miss_num
1490 , p_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1491 , p_planned_effort IN NUMBER DEFAULT fnd_api.g_miss_num
1492 , p_planned_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1493 , p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num
1494 , p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1495 , p_percentage_complete IN NUMBER DEFAULT fnd_api.g_miss_num
1496 , p_reason_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1497 , p_private_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1498 , p_publish_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1499 , p_restrict_closure_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1500 , p_multi_booked_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1501 , p_milestone_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1502 , p_holiday_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1503 , p_billable_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1504 , p_bound_mode_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1505 , p_soft_bound_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1506 , p_workflow_process_id IN NUMBER DEFAULT fnd_api.g_miss_num
1507 , p_notification_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1508 , p_notification_period IN NUMBER DEFAULT fnd_api.g_miss_num
1509 , p_notification_period_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1510 , p_alarm_start IN NUMBER DEFAULT fnd_api.g_miss_num
1511 , p_alarm_start_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1512 , p_alarm_on IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1513 , p_alarm_count IN NUMBER DEFAULT fnd_api.g_miss_num
1514 , p_alarm_fired_count IN NUMBER DEFAULT fnd_api.g_miss_num
1515 , p_alarm_interval IN NUMBER DEFAULT fnd_api.g_miss_num
1516 , p_alarm_interval_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1517 , p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1518 , p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1519 , p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1520 , p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1521 , p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1522 , p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1523 , p_costs IN NUMBER DEFAULT fnd_api.g_miss_num
1524 , p_currency_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1525 , p_escalation_level IN VARCHAR2 DEFAULT fnd_api.g_miss_char
1526 , x_return_status OUT NOCOPY VARCHAR2
1527 , x_msg_count OUT NOCOPY NUMBER
1528 , x_msg_data OUT NOCOPY VARCHAR2
1529 , p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1530 , p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1531 , p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1532 , p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1533 , p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1534 , p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1535 , p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1536 , p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1537 , p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1538 , p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1539 , p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1540 , p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1541 , p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1542 , p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1543 , p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1544 , p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1545 , p_date_selected IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1546 , p_category_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
1547 , p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1548 , p_owner_status_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
1549 , p_parent_task_id IN NUMBER DEFAULT jtf_task_utl.g_miss_number
1550 , p_parent_task_number IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
1551 );
1552
1553 -- Removed '#' to de-annotate this procedure. irep parser
1554 -- will not pick up this annotation. Bug# 5406214
1555
1556 /*
1557 * Locks a task.
1558 *
1559 * @param p_api_version Standard API version number.
1560 * @rep:paraminfo {@rep:required}
1561 * @param p_init_msg_list Standard API flag allows API callers to request that the API does the initialization of the message list on their behalf. By default, the message list will not be initialized.
1562 * @param p_commit Standard API flag is used by API callers to ask the API to commit on their behalf after performing its function. By default, the commit will not be performed.
1563 * @param x_return_status Result of all the operations performed by the API. This will have one of the following values:
1564 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code> - If the API processed the data successfully.
1565 * <LI><Code>FND_API.G_RET_STS_ERROR</Code> - If there was an expected error in API processing.
1566 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code> If there was an unexpected error in API processing.
1567 * @param x_msg_count Number of messages returned in the API message list.
1568 * @param x_msg_data Returned message data in an encoded format if <code>x_msg_count</code> returns non-zero value.
1569 * @param p_object_version_number Object version number of the current task record.
1570 * @rep:paraminfo {@rep:required}
1571 * @param p_task_id Unique task identifier of task to be locked.
1572 * @rep:paraminfo {@rep:required}
1573 *
1574 * @rep:scope public
1575 * @rep:lifecycle active
1576 * @rep:displayname Lock Task
1577 * @rep:compatibility S
1578 */
1579 PROCEDURE lock_task(
1580 p_api_version IN NUMBER
1581 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1582 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
1583 , p_task_id IN NUMBER
1584 , p_object_version_number IN NUMBER
1585 , x_return_status OUT NOCOPY VARCHAR2
1586 , x_msg_data OUT NOCOPY VARCHAR2
1587 , x_msg_count OUT NOCOPY NUMBER
1588 );
1589
1590 PROCEDURE delete_task(
1591 p_api_version IN NUMBER
1592 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1593 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
1594 , p_object_version_number IN NUMBER
1595 , p_task_id IN NUMBER DEFAULT NULL
1596 , p_task_number IN VARCHAR2 DEFAULT NULL
1597 , p_delete_future_recurrences IN VARCHAR2 DEFAULT fnd_api.g_false
1598 , x_return_status OUT NOCOPY VARCHAR2
1599 , x_msg_count OUT NOCOPY NUMBER
1600 , x_msg_data OUT NOCOPY VARCHAR2
1601 );
1602
1603 -- New version
1604
1605 /*# Deletes an existing task. This API cannot be used to delete tasks that are associated with service requests. Please note that this is a "soft" deletion where records are marked as deleted but not physically removed from the database.
1606 *
1607 * @param p_api_version Standard API version number. See "Standard IN Parameters", Oracle Common Application Calendar API Reference Guide.
1608 * @rep:paraminfo {@rep:required}
1609 * @param p_init_msg_list Standard API flag allows API callers to request that the API does the initialization of the message list on their behalf. By default, the message list will not be initialized.
1610 * See "Standard IN Parameters", Oracle Common Application Calendar API Reference Guide.
1611 * @param p_commit Standard API flag is used by API callers to ask the API to commit on their behalf after performing its function. By default, the commit will not be performed.
1612 * See "Standard IN Parameters", Oracle Common Application Calendar API Reference Guide.
1613 * @param x_return_status Result of all the operations performed by the API. This will have one of the following values:
1614 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code> - If the API processed the data successfully.
1615 * <LI><Code>FND_API.G_RET_STS_ERROR</Code> - If there was an expected error in API processing.
1616 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code> If there was an unexpected error in API processing.
1617 * @param x_msg_count Number of messages returned in the API message list.
1618 * @param x_msg_data Returned message data in an encoded format if <code>x_msg_count</code> returns non-zero value.
1619 * @param p_object_version_number Object version number of the current task record.
1623 * @param p_task_number Unique task number of task to be deleted. Either <code>p_task_id</code> or <code>p_task_number</code> must be passed.
1620 * @rep:paraminfo {@rep:required}
1621 * @param p_task_id Unique task identifier of task to be deleted. Either <code>p_task_id</code> or <code>p_task_number</code> must be passed.
1622 * @rep:paraminfo {@rep:required}
1624 * @rep:paraminfo {@rep:required}
1625 * @param p_delete_future_recurrences For internal use only. This flag is used to mark future recurrences to be deleted for repeating appointments.
1626 * @param p_enable_workflow Flag to enable workflow passed as-is to <code>oracle.apps.jtf.cac.task.deleteTask</code> business event.
1627 * @rep:paraminfo {@rep:required}
1628 * @param p_abort_workflow Flag to abort workflow passed as-is to <code>oracle.apps.jtf.cac.task.deleteTask</code> business event.
1629 * @rep:paraminfo {@rep:required}
1630 *
1631 * @rep:primaryinstance
1632 * @rep:scope public
1633 * @rep:lifecycle active
1634 * @rep:displayname Delete Task
1635 * @rep:compatibility S
1636 * @rep:businessevent oracle.apps.jtf.cac.task.deleteTask
1637 * @rep:metalink 249665.1 Oracle Common Application Calendar - API Reference Guide
1638 * @rep:category BUSINESS_ENTITY CS_SERVICE_REQUEST
1639 * @rep:category BUSINESS_ENTITY AS_OPPORTUNITY
1640 * @rep:category BUSINESS_ENTITY AMS_LEAD
1641 */
1642 PROCEDURE delete_task(
1643 p_api_version IN NUMBER
1644 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1645 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
1646 , p_object_version_number IN NUMBER
1647 , p_task_id IN NUMBER DEFAULT NULL
1648 , p_task_number IN VARCHAR2 DEFAULT NULL
1649 , p_delete_future_recurrences IN VARCHAR2 DEFAULT fnd_api.g_false
1650 , x_return_status OUT NOCOPY VARCHAR2
1651 , x_msg_count OUT NOCOPY NUMBER
1652 , x_msg_data OUT NOCOPY VARCHAR2
1653 , p_enable_workflow IN VARCHAR2
1654 , p_abort_workflow IN VARCHAR2
1655 );
1656
1657 -- Removed '#' to de-annotate this procedure. irep parser
1658 -- will not pick up this annotation. Bug# 5406214
1659
1660 /*
1661 * Exports the Task's query.
1662 *
1663 * @param p_api_version the standard API version number
1664 * @param p_init_msg_list the standard API flag allows API callers to request
1665 * that the API does the initialization of the message list on their behalf.
1666 * By default, the message list will not be initialized.
1667 * @param p_validate_level the standard API validation level
1668 * @param x_return_status returns the result of all the operations performed
1669 * by the API and must have one of the following values:
1670 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code>
1671 * <LI><Code>FND_API.G_RET_STS_ERROR</Code>
1672 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code>
1673 * @param x_msg_count returns the number of messages in the API message list
1674 * @param x_msg_data returns the message in an encoded format if
1675 * <code>x_msg_count</code> returns number one.
1676 * @param p_file_name is the file name for exporting task data
1677 * @param p_task_id is the task id of the task to be queried.
1678 * @param p_task_number is the task number of the task to be queried.
1679 * @param p_task_name is the name of the task to be queried.
1680 * @param p_task_type_name is the type name of the task to be queried
1681 * @param p_task_type_id is the type id of the task to be queried
1682 * @param p_description is the description of the task to be queried
1683 * @param p_task_status_name is the status name of the task to be queried
1684 * @param p_task_status_id is the status id the of task to be queried
1685 * @param p_task_priority_name is the priority name of the task to be queried
1686 * @param p_task_priority_id is the priority id of the task to be queried
1687 * @param p_owner_type_code is the owner type code of the task to be queried
1691 * @param p_assigned_name is the name of the assignee of the task to be queried
1688 * @param p_owner_id is the owner id of the task to be queried
1689 * @param p_owner_territory_id is owner's territory id of the task to be queried
1690 * @param p_assigned_by_id is the id of the assignee of the task to be queried
1692 * @param p_address_id is the customer address id of the task to be queried
1693 * @param p_customer_number is the customer number of the task to be queried
1694 * @param p_customer_name is the customer name of the task to be queried
1695 * @param p_customer_id is the customer id of the task to be queried
1696 * @param p_cust_account_number is the customer account number of the task to be queried
1697 * @param p_cust_account_id is the customer account id of the task to be queried
1698 * @param p_planned_start_date is planned start date of the task to be queried
1699 * @param p_planned_end_date is planned end date of the task to be queried
1700 * @param p_scheduled_start_date is scheduled start date of the task to be queried
1701 * @param p_scheduled_end_date is scheduled end date of the task to be queried
1702 * @param p_actual_start_date is actual start date of the task to be queried
1703 * @param p_actual_end_date is actual end date of the task to be queried
1704 * @param p_object_type_code is the source object type code of the task to be queried
1705 * @param p_source_object_id is the source object id of the task to be queried
1706 * @param p_object_name is source object name of the task to be queried
1707 * @param p_percentage_complete is percent completion of the task to be queried
1708 * @param p_reason_code is used to check if the task is automated
1709 * @param p_private_flag is used check if the task created is private
1710 * @param p_restrict_closure_flag is used for closing purposes by field service
1711 * @param p_multi_booked_flag is to check multiple bookings by field service
1712 * @param p_milestone_flag is for setting milestones by field service
1713 * @param p_holiday_flag is used for setting holidays by field service
1714 * @param p_workflow_process_id is id of last workflow launched
1715 * @param p_notification_flag is used for automatically launching workflow
1716 * @param p_parent_task_id is the task id of parent task of the task being created
1717 * @param p_alarm_on indicates whether the alarm is on
1718 * @param p_alarm_count is the total number of alarms
1719 * @param p_alarm_fired_count is the total number of alarms being fired
1720 * @param p_ref_object_id is used internally
1721 * @param p_ref_object_type_code is used internally
1722 * @param p_sort_data is used internally
1723 * @param p_start_pointer is used internally
1724 * @param p_rec_wanted is used internally
1725 * @param p_show_all is used internally
1726 * @param p_query_or_next_code is used internally
1727 * @param x_task_table is used internally
1728 * @param x_total_retrieved is used internally
1729 * @param x_total_returned is used internally
1730 * @param x_object_version_number is the object version number of the current record.
1731 * @param p_location_id is the location id of the task to be queried.
1732 *
1733 * @rep:scope private
1734 * @rep:lifecycle active
1735 * @rep:displayname Export Task Query
1736 * @rep:compatibility N
1737 */
1738 PROCEDURE export_query_task(
1739 p_api_version IN NUMBER
1740 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1741 , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
1742 , p_file_name IN VARCHAR2
1743 , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
1744 , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
1745 , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
1746 , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1747 , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1748 , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1749 , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1750 , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1751 , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1752 , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1753 , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1754 , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1755 , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1756 , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1757 , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1758 , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1759 , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1760 , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1761 , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1762 , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1763 , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1764 , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1765 , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1766 , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1767 , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1768 , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1769 , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1770 , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1771 , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1775 , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1772 , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1773 , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1774 , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1776 , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1777 , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1778 , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1779 , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1780 , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1781 , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1782 , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
1783 , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
1784 , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
1785 , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
1786 , p_ref_object_id IN NUMBER DEFAULT NULL
1787 , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
1788 , p_sort_data IN sort_data
1789 , p_start_pointer IN NUMBER
1790 , p_rec_wanted IN NUMBER
1791 , p_show_all IN VARCHAR2
1792 , p_query_or_next_code IN VARCHAR2 DEFAULT 'Q'
1793 , x_task_table OUT NOCOPY task_table_type
1794 , x_total_retrieved OUT NOCOPY NUMBER
1795 , x_total_returned OUT NOCOPY NUMBER
1796 , x_return_status OUT NOCOPY VARCHAR2
1797 , x_msg_count OUT NOCOPY NUMBER
1798 , x_msg_data OUT NOCOPY VARCHAR2
1799 , x_object_version_number IN OUT NOCOPY NUMBER
1800 , p_location_id IN NUMBER
1801 );
1802
1803 PROCEDURE export_query_task(
1804 p_api_version IN NUMBER
1805 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1806 , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
1807 , p_file_name IN VARCHAR2
1808 , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
1809 , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
1810 , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
1811 , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1812 , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1813 , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1814 , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1815 , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1816 , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1817 , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1818 , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1819 , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1820 , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1821 , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1822 , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1823 , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1824 , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1825 , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1826 , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1827 , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1828 , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1829 , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1830 , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1831 , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1832 , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1833 , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1834 , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1835 , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1836 , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1837 , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1838 , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1839 , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1840 , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1841 , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1842 , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1843 , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1844 , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1845 , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1846 , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1847 , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
1848 , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
1849 , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
1850 , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
1851 , p_ref_object_id IN NUMBER DEFAULT NULL
1852 , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
1853 , p_sort_data IN sort_data
1854 , p_start_pointer IN NUMBER
1855 , p_rec_wanted IN NUMBER
1856 , p_show_all IN VARCHAR2
1857 , p_query_or_next_code IN VARCHAR2 DEFAULT 'Q'
1858 , x_task_table OUT NOCOPY task_table_type
1859 , x_total_retrieved OUT NOCOPY NUMBER
1860 , x_total_returned OUT NOCOPY NUMBER
1861 , x_return_status OUT NOCOPY VARCHAR2
1862 , x_msg_count OUT NOCOPY NUMBER
1863 , x_msg_data OUT NOCOPY VARCHAR2
1864 , x_object_version_number IN OUT NOCOPY NUMBER
1865 );
1866
1867 -- Removed '#' to de-annotate this procedure. irep parser
1868 -- will not pick up this annotation. Bug# 5406214
1869
1870 /*
1871 * Querys the Task.
1872 *
1873 * @param p_api_version the standard API version number
1874 * @param p_init_msg_list the standard API flag allows API callers to request
1875 * that the API does the initialization of the message list on their behalf.
1876 * By default, the message list will not be initialized.
1877 * @param p_validate_level the standard API validation level.
1878 * @param x_return_status returns the result of all the operations performed
1879 * by the API and must have one of the following values:
1880 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code>
1881 * <LI><Code>FND_API.G_RET_STS_ERROR</Code>
1882 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code>
1883 * @param x_msg_count returns the number of messages in the API message list
1884 * @param x_msg_data returns the message in an encoded format if
1885 * <code>x_msg_count</code> returns number one.
1886 * @param p_task_id is the task id of the task to be queried.
1887 * @param p_task_number is the task number of the task to be queried.
1888 * @param p_task_name is the name of the task to be queried.
1889 * @param p_task_type_name is the type name of the task to be queried
1890 * @param p_task_type_id is the type id of the task to be queried
1891 * @param p_description is the description of the task to be queried
1892 * @param p_task_status_name is the status name of the task to be queried
1893 * @param p_task_status_id is the status id the of task to be queried
1894 * @param p_task_priority_name is the priority name of the task to be queried
1895 * @param p_task_priority_id is the priority id of the task to be queried
1896 * @param p_owner_type_code is the owner type code of the task to be queried
1897 * @param p_owner_id is the owner id of the task to be queried
1898 * @param p_owner_territory_id is owner's territory id of the task to be queried
1899 * @param p_assigned_by_id is the id of the assignee of the task to be queried
1900 * @param p_assigned_name is the name of the assignee of the task to be queried
1901 * @param p_address_id is the customer address id of the task to be queried
1902 * @param p_customer_number is the customer number of the task to be queried
1903 * @param p_customer_id is the customer id of the task to be queried
1904 * @param p_customer_name is the customer name of the task to be queried
1905 * @param p_cust_account_number is the customer account number of the task to be queried
1906 * @param p_cust_account_id is the customer account id of the task to be queried
1907 * @param p_planned_start_date is planned start date of the task to be queried
1908 * @param p_planned_end_date is planned end date of the task to be queried
1909 * @param p_scheduled_start_date is scheduled start date of the task to be queried
1910 * @param p_scheduled_end_date is scheduled end date of the task to be queried
1911 * @param p_actual_start_date is actual start date of the task to be queried
1912 * @param p_actual_end_date is actual end date of the task to be queried
1913 * @param p_object_type_code is the source object type code of the task to be queried
1914 * @param p_source_object_id is the source object id of the task to be queried
1915 * @param p_object_name is source object name of the task to be queried
1916 * @param p_percentage_complete is percent completion of the task to be queried
1917 * @param p_reason_code is used to check if the task is automated
1918 * @param p_private_flag is used to flag a private task
1919 * @param p_restrict_closure_flag is used for closing purposes by field service
1920 * @param p_multi_booked_flag is to check multiple bookings by field service
1921 * @param p_milestone_flag is for setting milestones by field service
1922 * @param p_holiday_flag is used for setting holidays by field service
1923 * @param p_workflow_process_id is id of last workflow launched
1924 * @param p_notification_flag is used for automatically launching workflow
1925 * @param p_parent_task_id is the task id of parent task of the task being created
1926 * @param p_alarm_on indicates whether the alarm is on
1927 * @param p_alarm_count is the total number of alarms
1928 * @param p_alarm_fired_count is the total number of alarms being fired
1929 * @param p_ref_object_id is used internally
1930 * @param p_ref_object_type_code is used internally
1931 * @param p_sort_data is used internally
1932 * @param p_start_pointer is used internally
1933 * @param p_rec_wanted is used internally
1934 * @param p_show_all is used internally
1935 * @param p_query_or_next_code is used internally
1936 * @param x_task_table is used internally
1937 * @param x_total_retrieved is used internally
1938 * @param x_total_returned is used internally
1939 * @param x_object_version_number is the object version number of the current record.
1940 * @param p_location_id is the location id of the task to be queried
1941 *
1942 * @rep:scope private
1943 * @rep:lifecycle active
1944 * @rep:displayname Query Task
1945 * @rep:compatibility N
1946 */
1947 PROCEDURE query_task(
1948 p_api_version IN NUMBER
1949 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1950 , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
1951 , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
1952 , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
1953 , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
1954 , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
1955 , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
1956 , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
1957 , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
1958 , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
1959 , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
1960 , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
1961 , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
1962 , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
1963 , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
1964 , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
1965 , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
1966 , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
1967 , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
1968 , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
1969 , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
1970 , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
1971 , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
1972 , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
1973 , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
1974 , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
1975 , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
1976 , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
1977 , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
1978 , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
1979 , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
1980 , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
1981 , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
1982 , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
1983 , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
1984 , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
1985 , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
1986 , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
1987 , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
1988 , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
1989 , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
1990 , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
1991 , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
1992 , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
1993 , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
1994 , p_ref_object_id IN NUMBER DEFAULT NULL
1995 , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
1996 , p_sort_data IN sort_data
1997 , p_start_pointer IN NUMBER
1998 , p_rec_wanted IN NUMBER
1999 , p_show_all IN VARCHAR2
2000 , p_query_or_next_code IN VARCHAR2 DEFAULT 'Q'
2001 , x_task_table OUT NOCOPY task_table_type
2002 , x_total_retrieved OUT NOCOPY NUMBER
2003 , x_total_returned OUT NOCOPY NUMBER
2004 , x_return_status OUT NOCOPY VARCHAR2
2005 , x_msg_count OUT NOCOPY NUMBER
2006 , x_msg_data OUT NOCOPY VARCHAR2
2007 , x_object_version_number IN OUT NOCOPY NUMBER
2008 , p_location_id IN NUMBER
2009 );
2010
2011 PROCEDURE query_task(
2012 p_api_version IN NUMBER
2013 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
2014 , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
2015 , p_task_number IN jtf_tasks_v.task_number%TYPE DEFAULT NULL
2016 , p_task_id IN jtf_tasks_v.task_id%TYPE DEFAULT NULL
2017 , p_task_name IN jtf_tasks_v.task_name%TYPE DEFAULT NULL
2018 , p_description IN jtf_tasks_v.description%TYPE DEFAULT NULL
2019 , p_task_type_name IN jtf_tasks_v.task_type%TYPE DEFAULT NULL
2020 , p_task_type_id IN jtf_tasks_v.task_type_id%TYPE DEFAULT NULL
2021 , p_task_status_name IN jtf_tasks_v.task_status%TYPE DEFAULT NULL
2022 , p_task_status_id IN jtf_tasks_v.task_status_id%TYPE DEFAULT NULL
2023 , p_task_priority_name IN jtf_tasks_v.task_priority%TYPE DEFAULT NULL
2024 , p_task_priority_id IN jtf_tasks_v.task_priority_id%TYPE DEFAULT NULL
2025 , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
2026 , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
2027 , p_assigned_name IN jtf_tasks_v.assigned_by_name%TYPE DEFAULT NULL
2031 , p_customer_id IN jtf_tasks_v.customer_id%TYPE DEFAULT NULL
2028 , p_assigned_by_id IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
2029 , p_address_id IN jtf_tasks_v.address_id%TYPE DEFAULT NULL
2030 , p_owner_territory_id IN jtf_tasks_v.owner_territory_id%TYPE DEFAULT NULL
2032 , p_customer_name IN jtf_tasks_v.customer_name%TYPE DEFAULT NULL
2033 , p_customer_number IN jtf_tasks_v.customer_number%TYPE DEFAULT NULL
2034 , p_cust_account_number IN jtf_tasks_v.cust_account_number%TYPE DEFAULT NULL
2035 , p_cust_account_id IN jtf_tasks_v.cust_account_id%TYPE DEFAULT NULL
2036 , p_planned_start_date IN jtf_tasks_v.planned_start_date%TYPE DEFAULT NULL
2037 , p_planned_end_date IN jtf_tasks_v.planned_end_date%TYPE DEFAULT NULL
2038 , p_scheduled_start_date IN jtf_tasks_v.scheduled_start_date%TYPE DEFAULT NULL
2039 , p_scheduled_end_date IN jtf_tasks_v.scheduled_end_date%TYPE DEFAULT NULL
2040 , p_actual_start_date IN jtf_tasks_v.actual_start_date%TYPE DEFAULT NULL
2041 , p_actual_end_date IN jtf_tasks_v.actual_end_date%TYPE DEFAULT NULL
2042 , p_object_type_code IN jtf_tasks_v.source_object_type_code%TYPE DEFAULT NULL
2043 , p_object_name IN jtf_tasks_v.source_object_name%TYPE DEFAULT NULL
2044 , p_source_object_id IN jtf_tasks_v.source_object_id%TYPE DEFAULT NULL
2045 , p_percentage_complete IN jtf_tasks_v.percentage_complete%TYPE DEFAULT NULL
2046 , p_reason_code IN jtf_tasks_v.reason_code%TYPE DEFAULT NULL
2047 , p_private_flag IN jtf_tasks_v.private_flag%TYPE DEFAULT NULL
2048 , p_restrict_closure_flag IN jtf_tasks_v.restrict_closure_flag%TYPE DEFAULT NULL
2049 , p_multi_booked_flag IN jtf_tasks_v.multi_booked_flag%TYPE DEFAULT NULL
2050 , p_milestone_flag IN jtf_tasks_v.milestone_flag%TYPE DEFAULT NULL
2051 , p_holiday_flag IN jtf_tasks_v.holiday_flag%TYPE DEFAULT NULL
2052 , p_workflow_process_id IN jtf_tasks_v.workflow_process_id%TYPE DEFAULT NULL
2053 , p_notification_flag IN jtf_tasks_v.notification_flag%TYPE DEFAULT NULL
2054 , p_parent_task_id IN jtf_tasks_v.parent_task_id%TYPE DEFAULT NULL
2055 , p_alarm_on IN jtf_tasks_v.alarm_on%TYPE DEFAULT NULL
2056 , p_alarm_count IN jtf_tasks_v.alarm_count%TYPE DEFAULT NULL
2057 , p_alarm_fired_count IN jtf_tasks_v.alarm_fired_count%TYPE DEFAULT NULL
2058 , p_ref_object_id IN NUMBER DEFAULT NULL
2059 , p_ref_object_type_code IN VARCHAR2 DEFAULT NULL
2060 , p_sort_data IN sort_data
2061 , p_start_pointer IN NUMBER
2062 , p_rec_wanted IN NUMBER
2063 , p_show_all IN VARCHAR2
2064 , p_query_or_next_code IN VARCHAR2 DEFAULT 'Q'
2065 , x_task_table OUT NOCOPY task_table_type
2066 , x_total_retrieved OUT NOCOPY NUMBER
2067 , x_total_returned OUT NOCOPY NUMBER
2068 , x_return_status OUT NOCOPY VARCHAR2
2069 , x_msg_count OUT NOCOPY NUMBER
2070 , x_msg_data OUT NOCOPY VARCHAR2
2071 , x_object_version_number IN OUT NOCOPY NUMBER
2072 );
2073
2074 -- Removed '#' to de-annotate this procedure. irep parser
2075 -- will not pick up this annotation. Bug# 5406214
2076
2077 /*
2078 * Querys the next Task.
2079 *
2080 * @param p_api_version the standard API version number
2081 * @param p_init_msg_list the standard API flag allows API callers to request
2082 * that the API does the initialization of the message list on their behalf.
2083 * By default, the message list will not be initialized.
2084 * @param p_validate_level the standard validation level used by this API.
2085 * @param x_return_status returns the result of all the operations performed
2086 * by the API and must have one of the following values:
2087 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code>
2088 * <LI><Code>FND_API.G_RET_STS_ERROR</Code>
2089 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code>
2090 * @param x_msg_count returns the number of messages in the API message list
2091 * @param x_msg_data returns the message in an encoded format if
2092 * <code>x_msg_count</code> returns number one.
2093 * @param p_task_id is the task id of the task to be queried.
2094 * @p_validate_level is used internally
2095 * @param p_query_type is the name of the task to be queried.
2096 * @param p_date_type is the type name of the task to be queried
2097 * @param p_date_start_or_end is the type id of the task to be queried
2098 * @param p_owner_type_code is the owner type code of the task to be queried
2099 * @param p_owner_id is the owner id of the task to be queried
2100 * @param p_assigned_by is the assignee id of the task to be queried
2101 * @param p_sort_data is used internally
2102 * @param p_start_pointer is used internally
2103 * @param p_rec_wanted is used internally
2104 * @param p_show_all is used internally
2105 * @param p_query_or_next_code is used internally
2106 * @param x_task_table is used internally
2107 * @param x_total_retrieved is used internally
2108 * @param x_total_returned is used internally
2109 * @param x_object_version_number is the object version number of the current record.
2110 *
2111 * @rep:scope private
2112 * @rep:lifecycle active
2113 * @rep:displayname Query Next Task
2114 * @rep:compatibility N
2115 */
2116 PROCEDURE query_next_task(
2117 p_api_version IN NUMBER
2118 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
2119 , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
2120 , p_task_id IN jtf_tasks_v.task_id%TYPE
2121 , -- current task id
2122 p_query_type IN VARCHAR2 DEFAULT 'Dependency'
2123 , -- values Dependency or Date
2124 p_date_type IN VARCHAR2 DEFAULT NULL
2125 , p_date_start_or_end IN VARCHAR2 DEFAULT NULL
2126 , p_owner_id IN jtf_tasks_v.owner_id%TYPE DEFAULT NULL
2127 , p_owner_type_code IN jtf_tasks_v.owner_type_code%TYPE DEFAULT NULL
2128 , p_assigned_by IN jtf_tasks_v.assigned_by_id%TYPE DEFAULT NULL
2129 , p_sort_data IN sort_data
2130 , p_start_pointer IN NUMBER
2131 , p_rec_wanted IN NUMBER
2132 , p_show_all IN VARCHAR2 DEFAULT 'Y'
2133 , p_query_or_next_code IN VARCHAR2 DEFAULT 'Q'
2134 , x_task_table OUT NOCOPY task_table_type
2135 , x_total_retrieved OUT NOCOPY NUMBER
2136 , x_total_returned OUT NOCOPY NUMBER
2137 , x_return_status OUT NOCOPY VARCHAR2
2138 , x_msg_count OUT NOCOPY NUMBER
2139 , x_msg_data OUT NOCOPY VARCHAR2
2140 , x_object_version_number IN OUT NOCOPY NUMBER
2141 );
2142
2143 -- Removed '#' to de-annotate this procedure. irep parser
2144 -- will not pick up this annotation. Bug# 5406214
2145
2146 /*
2147 * Exports the Task to file.
2148 *
2149 * @param p_api_version the standard API version number
2150 * @param p_init_msg_list the standard API flag allows API callers to request
2151 * that the API does the initialization of the message list on their behalf.
2152 * By default, the message list will not be initialized.
2153 * @param p_validate_level the standard validation level used by this API.
2154 * @param x_return_status returns the result of all the operations performed
2155 * by the API and must have one of the following values:
2156 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code>
2157 * <LI><Code>FND_API.G_RET_STS_ERROR</Code>
2158 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code>
2159 * @param x_msg_count returns the number of messages in the API message list
2160 * @param x_msg_data returns the message in an encoded format if
2161 * <code>x_msg_count</code> returns number one.
2162 * @p_validate_level is used internally
2163 * @param p_file_name is the name of the file data is exported to
2164 * @param p_task_table is the table of tasks
2165 * @param x_object_version_number is the object version number of the current record.
2166 *
2167 * @rep:scope private
2168 * @rep:lifecycle active
2169 * @rep:displayname Task Export
2170 * @rep:compatibility N
2171 */
2172 PROCEDURE export_file(
2173 p_api_version IN NUMBER
2174 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
2175 , p_validate_level IN VARCHAR2 DEFAULT fnd_api.g_valid_level_full
2176 , p_file_name IN VARCHAR2
2177 , p_task_table IN jtf_tasks_pub.task_table_type
2178 , x_return_status OUT NOCOPY VARCHAR2
2179 , x_msg_count OUT NOCOPY NUMBER
2180 , x_msg_data OUT NOCOPY VARCHAR2
2181 , x_object_version_number IN OUT NOCOPY NUMBER
2182 );
2183
2184 -- Removed '#' to de-annotate this procedure. irep parser
2185 -- will not pick up this annotation. Bug# 5406214
2186
2187 /*
2188 * Copys the Task data into another Task.
2189 *
2190 * @param p_api_version the standard API version number
2191 * @param p_init_msg_list the standard API flag allows API callers to request
2192 * that the API does the initialization of the message list on their behalf.
2193 * By default, the message list will not be initialized.
2194 * @param p_commit the standard API flag is used by API callers to ask
2195 * the API to commit on their behalf after performing its function
2196 * By default, the commit will not be performed.
2197 * @param x_return_status returns the result of all the operations performed
2198 * by the API and must have one of the following values:
2199 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code>
2200 * <LI><Code>FND_API.G_RET_STS_ERROR</Code>
2201 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code>
2202 * @param x_msg_count returns the number of messages in the API message list
2203 * @param x_msg_data returns the message in an encoded format if
2204 * <code>x_msg_count</code> returns number one.
2205 * @param p_source_task_id is the source id of the task
2206 * @param p_source_task_number is the source number of the task
2207 * @param p_target_task_id is used internally
2208 * @param p_copy_task_assignments is used internally
2209 * @param p_copy_task_rsc_reqs is used internally
2210 * @param p_copy_task_depends is used internally
2211 * @param p_create_recurrences is used internally
2212 * @param p_copy_task_references is used internally
2213 * @param p_copy_task_dates is used internally
2214 * @param p_copy_notes is used internally
2215 * @param p_resource_id is resource id of the task owner
2216 * @param p_resource_type is resource type code of the owner of the task
2217 * @param x_task_id returns a created task id.
2218 * @param p_copy_task_contacts is used internally
2219 * @param p_copy_task_contact_points is used internally
2220 *
2221 * @rep:scope private
2222 * @rep:lifecycle active
2223 * @rep:displayname Copy Task
2224 * @rep:compatibility N
2225 */
2226 PROCEDURE copy_task(
2227 p_api_version IN NUMBER
2228 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
2229 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
2230 , p_source_task_id IN NUMBER DEFAULT NULL
2231 , p_source_task_number IN VARCHAR2 DEFAULT NULL
2232 , p_target_task_id IN NUMBER DEFAULT NULL
2233 , p_copy_task_assignments IN VARCHAR2 DEFAULT fnd_api.g_false
2234 , p_copy_task_rsc_reqs IN VARCHAR2 DEFAULT fnd_api.g_false
2235 , p_copy_task_depends IN VARCHAR2 DEFAULT fnd_api.g_false
2236 , p_create_recurrences IN VARCHAR2 DEFAULT fnd_api.g_false
2237 , p_copy_task_references IN VARCHAR2 DEFAULT fnd_api.g_false
2238 , p_copy_task_dates IN VARCHAR2 DEFAULT fnd_api.g_false
2239 , x_return_status OUT NOCOPY VARCHAR2
2240 , p_copy_notes IN VARCHAR2 DEFAULT fnd_api.g_false
2241 , p_resource_id IN NUMBER DEFAULT NULL
2242 , p_resource_type IN VARCHAR2 DEFAULT NULL
2243 , x_msg_count OUT NOCOPY NUMBER
2244 , x_msg_data OUT NOCOPY VARCHAR2
2245 , x_task_id OUT NOCOPY NUMBER
2246 , p_copy_task_contacts IN VARCHAR2 DEFAULT jtf_task_utl.g_false_char
2247 , p_copy_task_contact_points IN VARCHAR2 DEFAULT jtf_task_utl.g_false_char
2248 );
2249
2250 TYPE task_details_tbl IS TABLE OF task_details_rec
2251 INDEX BY BINARY_INTEGER;
2252
2253 -- Removed '#' to de-annotate this procedure. irep parser
2254 -- will not pick up this annotation. Bug# 5406214
2255
2256 /*
2257 * Creates a Task by using the Task Template.
2258 * This method is deperecated and will be soon obsolete.
2259 * Please use jtf_task_inst_templates_pub.create_task_from_template instead.
2260 *
2261 * @param p_api_version The standard API version number.
2262 * @param p_init_msg_list The standard API flag allows API callers to request
2263 * that the API does the initialization of the message list on their behalf.
2264 * By default, the message list will not be initialized.
2265 * @param p_commit The standard API flag is used by API callers to ask
2266 * the API to commit on their behalf after performing its function.
2267 * By default, the commit will not be performed.
2268 * @param x_return_status Returns the result of all the operations performed
2269 * by the API and must have one of the following values:
2270 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code>
2271 * <LI><Code>FND_API.G_RET_STS_ERROR</Code>
2272 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code>.
2273 * @param x_msg_count Returns the number of messages in the API message list.
2274 * @param x_msg_data Returns the message in an encoded format if
2275 * <code>x_msg_count</code> returns number one.
2276 * @param x_task_details_tbl Returns the Task Ids of the tasks created.
2277 * @param p_task_template_group_id This is group id of Task Templates used for creating tasks.
2278 * @param p_task_template_group_name This is group name of Task Templates used for creating tasks.
2279 * @param p_owner_type_code This is the owner type code of the task to be created.
2280 * @param p_owner_id This is the owner id of the task to be created.
2281 * @param p_assigned_by_id This is the id of the assignee of the task to be created.
2282 * @param p_customer_id This is the customer id of the task to be created.
2283 * @param p_cust_account_id This is the customer account id of the task to be created.
2284 * @param p_address_id This is the address id of the customer of the task to be created.
2285 * @param p_planned_start_date This is planned start date of the task to be created.
2286 * @param p_planned_end_date This is planned end date of the task to be created.
2287 * @param p_scheduled_start_date This is scheduled start date of the task to be created.
2288 * @param p_scheduled_end_date This is scheduled end date of the task to be created.
2289 * @param p_actual_start_date This is actual start date of the task to be created.
2290 * @param p_actual_end_date This is actual end date of the task to be created.
2291 * @param p_timezone_id This is timezone id of the task to be created.
2292 * @param p_source_object_id This is the source object id of the task to be created.
2293 * @param p_source_object_name This is source object name of the task to be created.
2294 * @param p_actual_effort This is actual effort of the task to be created.
2295 * @param p_actual_effort_uom This is the unit of measure of the actual effort of the task to be created.
2296 * @param p_percentage_complete This is percent completion of the task to be created.
2297 * @param p_reason_code This is used to check if the task is automated.
2298 * @param p_bound_mode_code This is used internally.
2299 * @param p_soft_bound_flag This is used internally.
2300 * @param p_workflow_process_id This is id of last workflow launched.
2301 * @param p_parent_task_id This is the task id of parent task of the task being created.
2302 * @param p_palm_flag This is used by Mobile Services.
2303 * @param p_wince_flag This is used by Mobile Services.
2304 * @param p_laptop_flag This is used by Mobile Services.
2305 * @param p_device1_flag This is used by Mobile Services.
2306 * @param p_device2_flag This is used by Mobile Services.
2307 * @param p_device3_flag This is used by Mobile Services.
2308 * @param P_OWNER_TERRITORY_ID This is a territory of the task owner.
2309 * @param p_costs This is for internal use only.
2310 * @param p_currency_code This is for internal use only.
2311 * @param p_attribute1 This is used for descriptive felxfield column.
2312 * @param p_attribute2 This is used for descriptive felxfield column.
2313 * @param p_attribute3 This is used for descriptive felxfield column.
2314 * @param p_attribute4 This is used for descriptive felxfield column.
2315 * @param p_attribute5 This is used for descriptive felxfield column.
2316 * @param p_attribute6 This is used for descriptive felxfield column.
2317 * @param p_attribute7 This is used for descriptive felxfield column.
2318 * @param p_attribute8 This is used for descriptive felxfield column.
2322 * @param p_attribute12 This is used for descriptive felxfield column.
2319 * @param p_attribute9 This is used for descriptive felxfield column.
2320 * @param p_attribute10 This is used for descriptive felxfield column.
2321 * @param p_attribute11 This is used for descriptive felxfield column.
2323 * @param p_attribute13 This is used for descriptive felxfield column.
2324 * @param p_attribute14 This is used for descriptive felxfield column.
2325 * @param p_attribute15 This is used for descriptive felxfield column.
2326 * @param p_attribute_category This is used for descriptive felxfield column.
2327 * @param p_date_selected This is populated from profile options to update Calendar dates.
2328 * @param p_location_id Reserved for internal use only. It is used by Field Service to store location id in task table.
2329 *
2330 * @rep:scope public
2331 * @rep:lifecycle deprecated
2332 * @rep:displayname Create Task From Template
2333 * @rep:compatibility N
2334 */
2335 PROCEDURE create_task_from_template(
2336 p_api_version IN NUMBER
2337 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
2338 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
2339 , p_task_template_group_id IN NUMBER DEFAULT NULL
2340 , p_task_template_group_name IN VARCHAR2 DEFAULT NULL
2341 , p_owner_type_code IN VARCHAR2 DEFAULT NULL
2342 , p_owner_id IN NUMBER DEFAULT NULL
2343 , p_source_object_id IN NUMBER DEFAULT NULL
2344 , p_source_object_name IN VARCHAR2 DEFAULT NULL
2345 , x_return_status OUT NOCOPY VARCHAR2
2346 , x_msg_count OUT NOCOPY NUMBER
2347 , x_msg_data OUT NOCOPY VARCHAR2
2348 , x_task_details_tbl OUT NOCOPY task_details_tbl
2349 , p_assigned_by_id IN NUMBER DEFAULT NULL
2350 , p_cust_account_id IN NUMBER DEFAULT NULL
2351 , p_customer_id IN NUMBER DEFAULT NULL
2352 , p_address_id IN NUMBER DEFAULT NULL
2353 , p_actual_start_date IN DATE DEFAULT NULL
2354 , p_actual_end_date IN DATE DEFAULT NULL
2355 , p_planned_start_date IN DATE DEFAULT NULL
2356 , p_planned_end_date IN DATE DEFAULT NULL
2357 , p_scheduled_start_date IN DATE DEFAULT NULL
2358 , p_scheduled_end_date IN DATE DEFAULT NULL
2359 , p_palm_flag IN VARCHAR2 DEFAULT NULL
2360 , p_wince_flag IN VARCHAR2 DEFAULT NULL
2361 , p_laptop_flag IN VARCHAR2 DEFAULT NULL
2362 , p_device1_flag IN VARCHAR2 DEFAULT NULL
2363 , p_device2_flag IN VARCHAR2 DEFAULT NULL
2364 , p_device3_flag IN VARCHAR2 DEFAULT NULL
2365 , p_parent_task_id IN NUMBER DEFAULT NULL
2366 , p_percentage_complete IN NUMBER DEFAULT NULL
2367 , p_timezone_id IN NUMBER DEFAULT NULL
2368 , p_actual_effort IN NUMBER DEFAULT NULL
2369 , p_actual_effort_uom IN VARCHAR2 DEFAULT NULL
2370 , p_reason_code IN VARCHAR2 DEFAULT NULL
2371 , p_bound_mode_code IN VARCHAR2 DEFAULT NULL
2372 , p_soft_bound_flag IN VARCHAR2 DEFAULT NULL
2373 , p_workflow_process_id IN NUMBER DEFAULT NULL
2374 , p_owner_territory_id IN NUMBER DEFAULT NULL
2375 , p_costs IN NUMBER DEFAULT NULL
2376 , p_currency_code IN VARCHAR2 DEFAULT NULL
2377 , p_attribute1 IN VARCHAR2 DEFAULT NULL
2378 , p_attribute2 IN VARCHAR2 DEFAULT NULL
2379 , p_attribute3 IN VARCHAR2 DEFAULT NULL
2380 , p_attribute4 IN VARCHAR2 DEFAULT NULL
2381 , p_attribute5 IN VARCHAR2 DEFAULT NULL
2382 , p_attribute6 IN VARCHAR2 DEFAULT NULL
2383 , p_attribute7 IN VARCHAR2 DEFAULT NULL
2384 , p_attribute8 IN VARCHAR2 DEFAULT NULL
2385 , p_attribute9 IN VARCHAR2 DEFAULT NULL
2386 , p_attribute10 IN VARCHAR2 DEFAULT NULL
2387 , p_attribute11 IN VARCHAR2 DEFAULT NULL
2388 , p_attribute12 IN VARCHAR2 DEFAULT NULL
2389 , p_attribute13 IN VARCHAR2 DEFAULT NULL
2390 , p_attribute14 IN VARCHAR2 DEFAULT NULL
2391 , p_attribute15 IN VARCHAR2 DEFAULT NULL
2392 , p_attribute_category IN VARCHAR2 DEFAULT NULL
2393 , p_date_selected IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
2394 , p_location_id IN NUMBER
2395 );
2396
2397 PROCEDURE create_task_from_template(
2398 p_api_version IN NUMBER
2399 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
2400 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
2401 , p_task_template_group_id IN NUMBER DEFAULT NULL
2402 , p_task_template_group_name IN VARCHAR2 DEFAULT NULL
2403 , p_owner_type_code IN VARCHAR2 DEFAULT NULL
2404 , p_owner_id IN NUMBER DEFAULT NULL
2405 , p_source_object_id IN NUMBER DEFAULT NULL
2406 , p_source_object_name IN VARCHAR2 DEFAULT NULL
2407 , x_return_status OUT NOCOPY VARCHAR2
2408 , x_msg_count OUT NOCOPY NUMBER
2409 , x_msg_data OUT NOCOPY VARCHAR2
2410 , x_task_details_tbl OUT NOCOPY task_details_tbl
2411 , p_assigned_by_id IN NUMBER DEFAULT NULL
2412 , p_cust_account_id IN NUMBER DEFAULT NULL
2413 , p_customer_id IN NUMBER DEFAULT NULL
2414 , p_address_id IN NUMBER DEFAULT NULL
2415 , p_actual_start_date IN DATE DEFAULT NULL
2416 , p_actual_end_date IN DATE DEFAULT NULL
2417 , p_planned_start_date IN DATE DEFAULT NULL
2418 , p_planned_end_date IN DATE DEFAULT NULL
2419 , p_scheduled_start_date IN DATE DEFAULT NULL
2420 , p_scheduled_end_date IN DATE DEFAULT NULL
2421 , p_palm_flag IN VARCHAR2 DEFAULT NULL
2422 , p_wince_flag IN VARCHAR2 DEFAULT NULL
2423 , p_laptop_flag IN VARCHAR2 DEFAULT NULL
2424 , p_device1_flag IN VARCHAR2 DEFAULT NULL
2425 , p_device2_flag IN VARCHAR2 DEFAULT NULL
2426 , p_device3_flag IN VARCHAR2 DEFAULT NULL
2427 , p_parent_task_id IN NUMBER DEFAULT NULL
2428 , p_percentage_complete IN NUMBER DEFAULT NULL
2429 , p_timezone_id IN NUMBER DEFAULT NULL
2430 , p_actual_effort IN NUMBER DEFAULT NULL
2431 , p_actual_effort_uom IN VARCHAR2 DEFAULT NULL
2432 , p_reason_code IN VARCHAR2 DEFAULT NULL
2433 , p_bound_mode_code IN VARCHAR2 DEFAULT NULL
2434 , p_soft_bound_flag IN VARCHAR2 DEFAULT NULL
2435 , p_workflow_process_id IN NUMBER DEFAULT NULL
2436 , p_owner_territory_id IN NUMBER DEFAULT NULL
2437 , p_costs IN NUMBER DEFAULT NULL
2438 , p_currency_code IN VARCHAR2 DEFAULT NULL
2439 , p_attribute1 IN VARCHAR2 DEFAULT NULL
2440 , p_attribute2 IN VARCHAR2 DEFAULT NULL
2441 , p_attribute3 IN VARCHAR2 DEFAULT NULL
2442 , p_attribute4 IN VARCHAR2 DEFAULT NULL
2443 , p_attribute5 IN VARCHAR2 DEFAULT NULL
2444 , p_attribute6 IN VARCHAR2 DEFAULT NULL
2445 , p_attribute7 IN VARCHAR2 DEFAULT NULL
2446 , p_attribute8 IN VARCHAR2 DEFAULT NULL
2447 , p_attribute9 IN VARCHAR2 DEFAULT NULL
2448 , p_attribute10 IN VARCHAR2 DEFAULT NULL
2449 , p_attribute11 IN VARCHAR2 DEFAULT NULL
2450 , p_attribute12 IN VARCHAR2 DEFAULT NULL
2451 , p_attribute13 IN VARCHAR2 DEFAULT NULL
2452 , p_attribute14 IN VARCHAR2 DEFAULT NULL
2453 , p_attribute15 IN VARCHAR2 DEFAULT NULL
2454 , p_attribute_category IN VARCHAR2 DEFAULT NULL
2455 , p_date_selected IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char
2456 );
2457
2458 -- Removed '#' to de-annotate this function. irep parser
2459 -- will no longer pick up this annotation. Bug# 5406214
2460
2461 /*
2462 * Checks task name length when it is used as a parameter.
2463 *
2464 * @param p_task_name is the name of the task
2465 * @param p_message_name is used internally
2466 * @param p_length is used internally
2467 * @return p_task_name or error.
2468 *
2469 * @rep:scope private
2470 * @rep:lifecycle active
2471 * @rep:displayname Check Parameter Length
2472 * @rep:compatibility N
2473 */
2474 FUNCTION check_param_length(
2475 p_task_name IN VARCHAR2
2476 , p_message_name IN VARCHAR2 DEFAULT NULL
2477 , p_length IN NUMBER DEFAULT 80
2478 )
2479 RETURN VARCHAR2;
2480
2481 -- Removed '#' to de-annotate this procedure. irep parser
2482 -- will not pick up this annotation. Bug# 5406214
2483
2484 /* Deletes split task(s). This method can be used only for split tasks. When a master (parent) task is provided, it will delete all dependent tasks (chuildren) along with the master task
2485 *
2486 * @param p_api_version the standard API version number
2487 * @param p_init_msg_list the standard API flag allows API callers to request
2488 * that the API does the initialization of the message list on their behalf.
2489 * By default, the message list will not be initialized.
2490 * @param p_commit the standard API flag is used by API callers to ask
2491 * the API to commit on their behalf after performing its function
2492 * By default, the commit will not be performed.
2493 * @param x_return_status returns the result of all the operations performed
2494 * by the API and must have one of the following values:
2495 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code>
2496 * <LI><Code>FND_API.G_RET_STS_ERROR</Code>
2497 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code>
2498 * @param x_msg_count returns the number of messages in the API message list
2499 * @param x_msg_data returns the message in an encoded format if
2500 * <code>x_msg_count</code> returns number one.
2501 * @param p_task_id is the Task Id of the task being deleted
2502 * @param p_object_version_number is the object version number of the current record.
2503 * @param p_try_to_reconnect_flag when this flag is set to Y, the API will try to reconnect tasks after deleting. It should be used only for dependent tasks.
2504 * @param p_task_split_flag the flag that is used to distinguish between a master (M) and dependent (D) tasks.
2505 * @param p_template_flag the flag that should be used if provided p_task_id is a template
2506 *
2507 * @rep:scope internal
2508 * @rep:lifecycle active
2509 * @rep:displayname Delete Split Tasks
2510 * @rep:compatibility S
2511 */
2512 PROCEDURE delete_split_tasks(
2513 p_api_version IN NUMBER
2514 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
2515 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
2516 , p_object_version_number IN NUMBER
2517 , p_task_id IN NUMBER DEFAULT NULL
2518 , p_task_split_flag IN VARCHAR2 DEFAULT NULL
2519 , p_try_to_reconnect_flag IN VARCHAR2 DEFAULT 'N'
2520 , p_template_flag IN VARCHAR2 DEFAULT 'N'
2521 , x_return_status OUT NOCOPY VARCHAR2
2522 , x_msg_count OUT NOCOPY NUMBER
2523 , x_msg_data OUT NOCOPY VARCHAR2
2524 );
2525
2526 PROCEDURE MASS_TASK_UPDATE (
2527 P_API_VERSION IN NUMBER
2528 ,P_INIT_MSG_LIST IN VARCHAR2
2529 ,P_COMMIT IN VARCHAR2
2530 ,P_TASK_ID_LIST IN JTF_NUMBER_TABLE
2531 ,P_NEW_TASK_STATUS_ID IN NUMBER
2532 ,P_NEW_SOURCE_TYPE_CODE IN VARCHAR2
2533 ,P_NEW_SOURCE_VALUE IN VARCHAR2
2534 ,P_NEW_SOURCE_ID IN VARCHAR2
2535 ,P_NEW_TASK_OWNER_TYPE_CODE IN VARCHAR2
2536 ,P_NEW_TASK_OWNER_ID IN NUMBER
2537 ,P_NEW_PLANNED_START_DATE IN DATE
2538 ,P_NEW_PLANNED_END_DATE IN DATE
2539 ,P_NEW_ACTUAL_START_DATE IN DATE
2540 ,P_NEW_ACTUAL_END_DATE IN DATE
2541 ,P_NEW_SCHEDULED_START_DATE IN DATE
2542 ,P_NEW_SCHEDULED_END_DATE IN DATE
2543 ,P_NEW_CALENDAR_START_DATE IN DATE
2544 ,P_NEW_CALENDAR_END_DATE IN DATE
2545 ,P_NOTE_TYPE IN VARCHAR2
2546 ,P_NOTE_STATUS IN VARCHAR2
2547 ,P_NOTE IN VARCHAR2
2548 ,P_REMOVE_ASSIGNMENT_FLAG IN VARCHAR2
2549 ,X_RETURN_STATUS OUT NOCOPY VARCHAR2
2550 ,X_MSG_COUNT OUT NOCOPY NUMBER
2551 ,X_MSG_DATA OUT NOCOPY VARCHAR2
2552 ,X_SUCC_TASK_ID_LIST OUT NOCOPY JTF_NUMBER_TABLE
2553 ,X_FAILED_TASK_ID_LIST OUT NOCOPY JTF_NUMBER_TABLE
2554 ,X_FAILED_REASON_LIST OUT NOCOPY JTF_VARCHAR2_TABLE_2000
2555 );
2556 END;