1 PACKAGE JTF_TASK_ASSIGNMENTS_PUB AUTHID CURRENT_USER AS
2 /* $Header: jtfptkas.pls 120.9 2006/07/27 11:22:35 sbarat ship $ */
3 /*#
4 * A public interface for Tasks that can be used to create, update, and delete task assignments.
5 *
6 * @rep:scope public
7 * @rep:product CAC
8 * @rep:displayname Task Assignment Management
9 * @rep:lifecycle active
10 * @rep:compatibility S
14
11 * @rep:category BUSINESS_ENTITY CAC_CAL_TASK
12 */
13
15 ---------------------------------------------------------------------------
16 --Define Global Variables
17 ---------------------------------------------------------------------------
18 G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TASK_ASSIGNMENT_PUB';
19 G_USER CONSTANT VARCHAR2(30):=FND_GLOBAL.USER_ID;
20 ---------------------------------------------------------------------------
21
22
23 TYPE task_assignments_rec IS RECORD (
24 task_assignment_id NUMBER,
25 object_version_number NUMBER,
26 task_id NUMBER,
27 resource_type_code VARCHAR2(30),
28 resource_id NUMBER,
29 assignment_status_id NUMBER,
30 actual_effort NUMBER,
31 resource_territory_id NUMBER,
32 actual_effort_uom VARCHAR2(3),
33 schedule_flag VARCHAR2(1),
34 alarm_type_code VARCHAR2(30),
35 alarm_contact VARCHAR2(200),
36 shift_construct_id NUMBER,
37 sched_travel_distance NUMBER,
38 sched_travel_duration NUMBER,
39 sched_travel_duration_uom VARCHAR2(3),
40 actual_travel_distance NUMBER,
41 actual_travel_duration NUMBER,
42 actual_travel_duration_uom VARCHAR2(3),
43 actual_start_date DATE,
44 actual_end_date DATE,
45 palm_flag VARCHAR2(1),
46 wince_flag VARCHAR2(1),
47 laptop_flag VARCHAR2(1),
48 device1_flag VARCHAR2(1),
49 device2_flag VARCHAR2(1),
50 device3_flag VARCHAR2(1),
51 attribute1 VARCHAR2(150),
52 attribute2 VARCHAR2(150),
53 attribute3 VARCHAR2(150),
54 attribute4 VARCHAR2(150),
55 attribute5 VARCHAR2(150),
56 attribute6 VARCHAR2(150),
57 attribute7 VARCHAR2(150),
58 attribute8 VARCHAR2(150),
59 attribute9 VARCHAR2(150),
60 attribute10 VARCHAR2(150),
61 attribute11 VARCHAR2(150),
62 attribute12 VARCHAR2(150),
63 attribute13 VARCHAR2(150),
64 attribute14 VARCHAR2(150),
65 attribute15 VARCHAR2(150),
66 attribute_category VARCHAR2(30),
67 SHOW_ON_CALENDAR VARCHAR2(1),
68 CATEGORY_ID NUMBER
69 );
70
71 p_task_assignments_rec task_assignments_rec;
72
73 type task_assignments_user_hooks is Record
74 (
75 task_assignment_id NUMBER,
76 task_id NUMBER ,
77 task_number VARCHAR2(30) ,
78 resource_type_code VARCHAR2(30),
79 resource_id NUMBER,
80 actual_effort NUMBER ,
81 actual_effort_uom VARCHAR2(3) ,
82 schedule_flag VARCHAR2(1) ,
83 alarm_type_code VARCHAR2(30) ,
84 alarm_contact VARCHAR2(200) ,
85 sched_travel_distance NUMBER ,
86 sched_travel_duration NUMBER ,
87 sched_travel_duration_uom VARCHAR2(3) ,
88 actual_travel_distance NUMBER ,
89 actual_travel_duration NUMBER ,
90 actual_travel_duration_uom VARCHAR2(3) ,
91 actual_start_date DATE ,
92 actual_end_date DATE ,
93 palm_flag VARCHAR2(1) ,
94 wince_flag VARCHAR2(1) ,
95 laptop_flag VARCHAR2(1) ,
96 device1_flag VARCHAR2(1) ,
97 device2_flag VARCHAR2(1) ,
98 device3_flag VARCHAR2(1) ,
99 resource_territory_id NUMBER ,
100 assignment_status_id NUMBER,
101 shift_construct_id NUMBER,
102 SHOW_ON_CALENDAR VARCHAR2(1),
103 CATEGORY_ID NUMBER,
104 assignee_role VARCHAR2(10),
105 booking_start_date DATE,
106 booking_end_date DATE
107 );
108
109 p_task_assignments_user_hooks task_assignments_user_hooks ;
110
111
112
113 /*#
114 * Creates a Task Assignment.
115 *
116 * @param p_api_version Standard API version number. See "Standard IN Parameters", Oracle Common Application Calendar API Reference Guide.
117 * @rep:paraminfo {@rep:required}
118 * @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.
119 * See "Standard IN Parameters", Oracle Common Application Calendar API Reference Guide.
120 * @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.
121 * See "Standard IN Parameters", Oracle Common Application Calendar API Reference Guide.
122 * @param p_task_assignment_id Unique task assignment id. It will be generated from the sequence <code>jtf_task_assignments_s</code> when not passed.
123 * @param p_task_id Unique Identifier for the task to be used for assignment creation. Either <code>p_task_id</code> or <code>p_task_number</code> must be passed.
124 * @rep:paraminfo {@rep:required}
125 * @param p_task_number Unique task number to be used for assignment creation. Either <code>p_task_id</code> or <code>p_task_number</code> must be passed.
126 * @rep:paraminfo {@rep:required}
127 * @param p_task_name No longer in use.
128 * @param p_resource_type_code Resource type code for assignment creation. A task assignment resource is identified with the resource type code and resource identifier therefore this should be used along with <code>p_resource_id</code>.
129 * @rep:paraminfo {@rep:required}
130 * @param p_resource_id Resource identifier for assignment creation. Should be used along with <code>p_resource_type_code</code>.
131 * @rep:paraminfo {@rep:required}
132 * @param p_resource_name No longer in use.
133 * @param p_actual_effort Actual effort exerted by the resource. Should be used along with <code>p_actual_effort_uom</code>.
137 * @param p_alarm_contact Alarm contact for assignment creation - Reserved for future use.
134 * @param p_actual_effort_uom Unit of Measure for the actual effort. Should be used along with <code>p_actual_effort</code>.
135 * @param p_schedule_flag Flag to denote if the assignment needs to be scheduled - Not currently used.
136 * @param p_alarm_type_code Alarm type code for assignment creation - Reserved for future use.
138 * @param p_sched_travel_distance Scheduled travel distance for this assignment.
139 * @param p_sched_travel_duration Scheduled travel duration for this assignment. Should be passed along with <code>p_sched_travel_duration_uom</code>.
140 * @param p_sched_travel_duration_uom Unit of measure for scheduled travel duration. Should be passed along with <code>p_sched_travel_duration</code>.
141 * @param p_actual_travel_distance Actual distance traveled, logged by the resource.
142 * @param p_actual_travel_duration Actual travel duration, logged by the resource. Should be used along with <code>p_actual_travel_duration_uom</code>.
143 * @param p_actual_travel_duration_uom Unit of measure for the actual travel duration. Should be used along with <code>p_actual_travel_duration</code>.
144 * @param p_actual_start_date Actual start date and time for this assignment.
145 * @param p_actual_end_date Actual end date and time for this assignment.
146 * @param p_palm_flag Reserved for internal use only.
147 * @param p_wince_flag Reserved for internal use only.
148 * @param p_laptop_flag Reserved for internal use only.
149 * @param p_device1_flag Reserved for internal use only.
150 * @param p_device2_flag Reserved for internal use only.
151 * @param p_device3_flag Reserved for internal use only.
152 * @param p_resource_territory_id Unique territory identifier for the task assignment resource.
153 * @param p_assignment_status_id Unique assignment status identifier for this assignment.
154 * @rep:paraminfo {@rep:required}
155 * @param p_shift_construct_id Unique identifier for the shift used to schedule this assignment - Reserved for internal use only.
156 * @param x_return_status Result of all the operations performed by the API. This will have one of the following values:
157 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code> - If the API processed the data successfully.
158 * <LI><Code>FND_API.G_RET_STS_ERROR</Code> - If there was an expected error in API processing.
159 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code> If there was an unexpected error in API processing.
160 * @param x_msg_count Number of messages returned in the API message list.
161 * @param x_msg_data Returned message data in an encoded format if <code>x_msg_count</code> returns non-zero value.
162 * @param x_task_assignment_id The unique identifier returned for the task assignment record created.
163 * @param p_attribute1 Attribute1 of customer flex fields.
164 * @param p_attribute2 Attribute2 of customer flex fields.
165 * @param p_attribute3 Attribute3 of customer flex fields.
166 * @param p_attribute4 Attribute4 of customer flex fields.
167 * @param p_attribute5 Attribute5 of customer flex fields.
168 * @param p_attribute6 Attribute6 of customer flex fields.
169 * @param p_attribute7 Attribute7 of customer flex fields.
170 * @param p_attribute8 Attribute8 of customer flex fields.
171 * @param p_attribute9 Attribute9 of customer flex fields.
172 * @param p_attribute10 Attribute10 of customer flex fields.
173 * @param p_attribute11 Attribute11 of customer flex fields.
174 * @param p_attribute12 Attribute12 of customer flex fields.
175 * @param p_attribute13 Attribute13 of customer flex fields.
176 * @param p_attribute14 Attribute14 of customer flex fields.
177 * @param p_attribute15 Attribute15 of customer flex fields.
178 * @param p_attribute_category Attribute category for the customer flex fields.
179 * @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.
180 * This flag is defaulted to <code>'Y'</code> if not passed.
181 * @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>.
182 * @param p_enable_workflow Flag to enable workflow passed as-is to <code>oracle.apps.jtf.cac.task.createTaskAssignment</code> business event.
183 * @rep:paraminfo {@rep:required}
184 * @param p_abort_workflow Flag to abort workflow passed as-is to <code>oracle.apps.jtf.cac.task.createTaskAssignment</code> business event.
185 * @rep:paraminfo {@rep:required}
186 * @param p_object_capacity_id Unique identifier for the object capacity for this assignment. This is a foreign key to <code>cac_object_capacity.object_capacity_id</code>.
187 * @rep:paraminfo {@rep:required}
188 * @param p_free_busy_type Unique identifier for the free_busy_type for this assignment.
189 * @rep:paraminfo {@rep:required}
190 *
191 * @rep:primaryinstance
192 * @rep:scope public
193 * @rep:lifecycle active
194 * @rep:displayname Create Task Assignment
195 * @rep:compatibility S
196 * @rep:businessevent oracle.apps.jtf.cac.task.createTaskAssignment
197 */
198 procedure create_task_assignment(
199 P_API_VERSION IN NUMBER,
200 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
201 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
202 P_TASK_ASSIGNMENT_ID IN NUMBER DEFAULT NULL,
203 P_TASK_ID IN NUMBER DEFAULT NULL,
204 P_TASK_NUMBER IN VARCHAR2 DEFAULT NULL,
205 P_TASK_NAME IN VARCHAR2 DEFAULT NULL,
206 P_RESOURCE_TYPE_CODE IN VARCHAR2,
207 P_RESOURCE_ID IN NUMBER,
208 P_RESOURCE_NAME IN NUMBER DEFAULT NULL,
209 P_ACTUAL_EFFORT IN NUMBER DEFAULT NULL,
210 P_ACTUAL_EFFORT_UOM IN VARCHAR2 DEFAULT NULL,
211 P_SCHEDULE_FLAG IN VARCHAR2 DEFAULT NULL,
215 P_SCHED_TRAVEL_DURATION IN NUMBER DEFAULT NULL,
212 P_ALARM_TYPE_CODE IN VARCHAR2 DEFAULT NULL,
213 P_ALARM_CONTACT IN VARCHAR2 DEFAULT NULL,
214 P_SCHED_TRAVEL_DISTANCE IN NUMBER DEFAULT NULL,
216 P_SCHED_TRAVEL_DURATION_UOM IN VARCHAR2 DEFAULT NULL,
217 P_ACTUAL_TRAVEL_DISTANCE IN NUMBER DEFAULT NULL,
218 P_ACTUAL_TRAVEL_DURATION IN NUMBER DEFAULT NULL,
219 P_ACTUAL_TRAVEL_DURATION_UOM IN VARCHAR2 DEFAULT NULL,
220 P_ACTUAL_START_DATE IN DATE DEFAULT NULL,
221 P_ACTUAL_END_DATE IN DATE DEFAULT NULL,
222 P_PALM_FLAG IN VARCHAR2 DEFAULT NULL,
223 P_WINCE_FLAG IN VARCHAR2 DEFAULT NULL,
224 P_LAPTOP_FLAG IN VARCHAR2 DEFAULT NULL,
225 P_DEVICE1_FLAG IN VARCHAR2 DEFAULT NULL,
226 P_DEVICE2_FLAG IN VARCHAR2 DEFAULT NULL,
227 P_DEVICE3_FLAG IN VARCHAR2 DEFAULT NULL,
228 P_RESOURCE_TERRITORY_ID IN NUMBER DEFAULT NULL,
229 P_ASSIGNMENT_STATUS_ID IN NUMBER,
230 P_SHIFT_CONSTRUCT_ID IN NUMBER DEFAULT NULL,
231 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
232 X_MSG_COUNT OUT NOCOPY NUMBER,
233 X_MSG_DATA OUT NOCOPY VARCHAR2,
234 X_TASK_ASSIGNMENT_ID OUT NOCOPY NUMBER,
235 p_attribute1 IN VARCHAR2 DEFAULT null,
236 p_attribute2 IN VARCHAR2 DEFAULT null,
237 p_attribute3 IN VARCHAR2 DEFAULT null,
238 p_attribute4 IN VARCHAR2 DEFAULT null,
239 p_attribute5 IN VARCHAR2 DEFAULT null,
240 p_attribute6 IN VARCHAR2 DEFAULT null,
241 p_attribute7 IN VARCHAR2 DEFAULT null,
242 p_attribute8 IN VARCHAR2 DEFAULT null,
243 p_attribute9 IN VARCHAR2 DEFAULT null,
244 p_attribute10 IN VARCHAR2 DEFAULT null,
245 p_attribute11 IN VARCHAR2 DEFAULT null,
246 p_attribute12 IN VARCHAR2 DEFAULT null,
247 p_attribute13 IN VARCHAR2 DEFAULT null,
248 p_attribute14 IN VARCHAR2 DEFAULT null,
249 p_attribute15 IN VARCHAR2 DEFAULT null,
250 p_attribute_category IN VARCHAR2 DEFAULT null,
251 P_SHOW_ON_CALENDAR IN VARCHAR2 DEFAULT jtf_task_utl.g_yes_char,
252 P_CATEGORY_ID IN NUMBER DEFAULT null,
253 p_enable_workflow IN VARCHAR2,
254 p_abort_workflow IN VARCHAR2,
255 p_object_capacity_id IN NUMBER ,
256 p_free_busy_type IN VARCHAR2
257 );
258
259
260
261 procedure create_task_assignment(
262 P_API_VERSION IN NUMBER,
263 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
264 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
265 P_TASK_ASSIGNMENT_ID IN NUMBER DEFAULT NULL,
266 P_TASK_ID IN NUMBER DEFAULT NULL,
267 P_TASK_NUMBER IN VARCHAR2 DEFAULT NULL,
268 P_TASK_NAME IN VARCHAR2 DEFAULT NULL,
269 P_RESOURCE_TYPE_CODE IN VARCHAR2,
270 P_RESOURCE_ID IN NUMBER,
271 P_RESOURCE_NAME IN NUMBER DEFAULT NULL,
272 P_ACTUAL_EFFORT IN NUMBER DEFAULT NULL,
273 P_ACTUAL_EFFORT_UOM IN VARCHAR2 DEFAULT NULL,
274 P_SCHEDULE_FLAG IN VARCHAR2 DEFAULT NULL,
275 P_ALARM_TYPE_CODE IN VARCHAR2 DEFAULT NULL,
276 P_ALARM_CONTACT IN VARCHAR2 DEFAULT NULL,
277 P_SCHED_TRAVEL_DISTANCE IN NUMBER DEFAULT NULL,
278 P_SCHED_TRAVEL_DURATION IN NUMBER DEFAULT NULL,
279 P_SCHED_TRAVEL_DURATION_UOM IN VARCHAR2 DEFAULT NULL,
280 P_ACTUAL_TRAVEL_DISTANCE IN NUMBER DEFAULT NULL,
281 P_ACTUAL_TRAVEL_DURATION IN NUMBER DEFAULT NULL,
282 P_ACTUAL_TRAVEL_DURATION_UOM IN VARCHAR2 DEFAULT NULL,
283 P_ACTUAL_START_DATE IN DATE DEFAULT NULL,
284 P_ACTUAL_END_DATE IN DATE DEFAULT NULL,
285 P_PALM_FLAG IN VARCHAR2 DEFAULT NULL,
286 P_WINCE_FLAG IN VARCHAR2 DEFAULT NULL,
287 P_LAPTOP_FLAG IN VARCHAR2 DEFAULT NULL,
288 P_DEVICE1_FLAG IN VARCHAR2 DEFAULT NULL,
289 P_DEVICE2_FLAG IN VARCHAR2 DEFAULT NULL,
290 P_DEVICE3_FLAG IN VARCHAR2 DEFAULT NULL,
291 P_RESOURCE_TERRITORY_ID IN NUMBER DEFAULT NULL,
292 P_ASSIGNMENT_STATUS_ID IN NUMBER,
293 P_SHIFT_CONSTRUCT_ID IN NUMBER DEFAULT NULL,
294 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
295 X_MSG_COUNT OUT NOCOPY NUMBER,
296 X_MSG_DATA OUT NOCOPY VARCHAR2,
297 X_TASK_ASSIGNMENT_ID OUT NOCOPY NUMBER,
298 p_attribute1 IN VARCHAR2 DEFAULT null,
299 p_attribute2 IN VARCHAR2 DEFAULT null,
300 p_attribute3 IN VARCHAR2 DEFAULT null,
301 p_attribute4 IN VARCHAR2 DEFAULT null,
302 p_attribute5 IN VARCHAR2 DEFAULT null,
303 p_attribute6 IN VARCHAR2 DEFAULT null,
304 p_attribute7 IN VARCHAR2 DEFAULT null,
305 p_attribute8 IN VARCHAR2 DEFAULT null,
306 p_attribute9 IN VARCHAR2 DEFAULT null,
307 p_attribute10 IN VARCHAR2 DEFAULT null,
308 p_attribute11 IN VARCHAR2 DEFAULT null,
309 p_attribute12 IN VARCHAR2 DEFAULT null,
310 p_attribute13 IN VARCHAR2 DEFAULT null,
311 p_attribute14 IN VARCHAR2 DEFAULT null,
312 p_attribute15 IN VARCHAR2 DEFAULT null,
313 p_attribute_category IN VARCHAR2 DEFAULT null,
314 P_SHOW_ON_CALENDAR IN VARCHAR2 DEFAULT jtf_task_utl.g_yes_char,
315 P_CATEGORY_ID IN NUMBER DEFAULT null,
316 p_enable_workflow IN VARCHAR2,
317 p_abort_workflow IN VARCHAR2,
318 p_object_capacity_id IN NUMBER
319 );
320
321
322
323 Procedure Create_Task_Assignment
324 (P_API_VERSION IN NUMBER ,
325 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
326 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
330 p_task_name IN varchar2 DEFAULT NULL,
327 p_task_assignment_id IN NUMBER DEFAULT NULL,
328 P_TASK_ID IN NUMBER DEFAULT NULL ,
329 P_TASK_NUMBER IN VARCHAR2 DEFAULT NULL ,
331 P_RESOURCE_TYPE_CODE IN VARCHAR2 ,
332 P_RESOURCE_ID IN NUMBER,
333 p_resource_name IN NUMBER DEFAULT NULL,
334 P_ACTUAL_EFFORT IN NUMBER DEFAULT NULL ,
335 P_ACTUAL_EFFORT_UOM IN VARCHAR2 DEFAULT NULL ,
336 P_SCHEDULE_FLAG IN VARCHAR2 DEFAULT NULL ,
337 P_ALARM_TYPE_CODE IN VARCHAR2 DEFAULT NULL ,
338 P_ALARM_CONTACT IN VARCHAR2 DEFAULT NULL ,
339 P_SCHED_TRAVEL_DISTANCE IN NUMBER DEFAULT NULL ,
340 P_SCHED_TRAVEL_DURATION IN NUMBER DEFAULT NULL ,
341 P_SCHED_TRAVEL_DURATION_UOM IN VARCHAR2 DEFAULT NULL ,
342 P_ACTUAL_TRAVEL_DISTANCE IN NUMBER DEFAULT NULL ,
343 P_ACTUAL_TRAVEL_DURATION IN NUMBER DEFAULT NULL ,
344 P_ACTUAL_TRAVEL_DURATION_UOM IN VARCHAR2 DEFAULT NULL ,
345 P_ACTUAL_START_DATE IN DATE DEFAULT NULL ,
346 P_ACTUAL_END_DATE IN DATE DEFAULT NULL ,
347 P_PALM_FLAG IN VARCHAR2 DEFAULT NULL,
348 P_WINCE_FLAG IN VARCHAR2 DEFAULT NULL,
349 P_LAPTOP_FLAG IN VARCHAR2 DEFAULT NULL,
350 P_DEVICE1_FLAG IN VARCHAR2 DEFAULT NULL,
351 P_DEVICE2_FLAG IN VARCHAR2 DEFAULT NULL,
352 P_DEVICE3_FLAG IN VARCHAR2 DEFAULT NULL,
353 P_RESOURCE_TERRITORY_ID IN NUMBER DEFAULT NULL ,
354 P_ASSIGNMENT_STATUS_ID IN NUMBER ,
355 P_SHIFT_CONSTRUCT_ID IN NUMBER DEFAULT NULL ,
356 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
357 X_MSG_COUNT OUT NOCOPY NUMBER ,
358 X_MSG_DATA OUT NOCOPY VARCHAR2 ,
359 X_TASK_ASSIGNMENT_ID OUT NOCOPY NUMBER ,
360 p_attribute1 IN VARCHAR2 DEFAULT null ,
361 p_attribute2 IN VARCHAR2 DEFAULT null ,
362 p_attribute3 IN VARCHAR2 DEFAULT null ,
363 p_attribute4 IN VARCHAR2 DEFAULT null ,
364 p_attribute5 IN VARCHAR2 DEFAULT null ,
365 p_attribute6 IN VARCHAR2 DEFAULT null ,
366 p_attribute7 IN VARCHAR2 DEFAULT null ,
367 p_attribute8 IN VARCHAR2 DEFAULT null ,
368 p_attribute9 IN VARCHAR2 DEFAULT null ,
369 p_attribute10 IN VARCHAR2 DEFAULT null ,
370 p_attribute11 IN VARCHAR2 DEFAULT null ,
371 p_attribute12 IN VARCHAR2 DEFAULT null ,
372 p_attribute13 IN VARCHAR2 DEFAULT null ,
373 p_attribute14 IN VARCHAR2 DEFAULT null ,
374 p_attribute15 IN VARCHAR2 DEFAULT null ,
375 p_attribute_category IN VARCHAR2 DEFAULT null ,
376 P_SHOW_ON_CALENDAR in VARCHAR2 DEFAULT jtf_task_utl.g_yes_char,
377 P_CATEGORY_ID in NUMBER DEFAULT null,
378 p_enable_workflow IN VARCHAR2,
379 p_abort_workflow IN VARCHAR2 ) ;
380
381
382
383 Procedure Create_Task_Assignment
384 (P_API_VERSION IN NUMBER ,
385 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
386 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
387 p_task_assignment_id IN NUMBER DEFAULT NULL,
388 P_TASK_ID IN NUMBER DEFAULT NULL ,
389 P_TASK_NUMBER IN VARCHAR2 DEFAULT NULL ,
390 p_task_name IN varchar2 DEFAULT NULL,
391 P_RESOURCE_TYPE_CODE IN VARCHAR2 ,
392 P_RESOURCE_ID IN NUMBER,
393 p_resource_name IN NUMBER DEFAULT NULL,
394 P_ACTUAL_EFFORT IN NUMBER DEFAULT NULL ,
395 P_ACTUAL_EFFORT_UOM IN VARCHAR2 DEFAULT NULL ,
396 P_SCHEDULE_FLAG IN VARCHAR2 DEFAULT NULL ,
397 P_ALARM_TYPE_CODE IN VARCHAR2 DEFAULT NULL ,
398 P_ALARM_CONTACT IN VARCHAR2 DEFAULT NULL ,
399 P_SCHED_TRAVEL_DISTANCE IN NUMBER DEFAULT NULL ,
400 P_SCHED_TRAVEL_DURATION IN NUMBER DEFAULT NULL ,
401 P_SCHED_TRAVEL_DURATION_UOM IN VARCHAR2 DEFAULT NULL ,
402 P_ACTUAL_TRAVEL_DISTANCE IN NUMBER DEFAULT NULL ,
403 P_ACTUAL_TRAVEL_DURATION IN NUMBER DEFAULT NULL ,
404 P_ACTUAL_TRAVEL_DURATION_UOM IN VARCHAR2 DEFAULT NULL ,
405 P_ACTUAL_START_DATE IN DATE DEFAULT NULL ,
406 P_ACTUAL_END_DATE IN DATE DEFAULT NULL ,
407 P_PALM_FLAG IN VARCHAR2 DEFAULT NULL,
408 P_WINCE_FLAG IN VARCHAR2 DEFAULT NULL,
409 P_LAPTOP_FLAG IN VARCHAR2 DEFAULT NULL,
410 P_DEVICE1_FLAG IN VARCHAR2 DEFAULT NULL,
411 P_DEVICE2_FLAG IN VARCHAR2 DEFAULT NULL,
412 P_DEVICE3_FLAG IN VARCHAR2 DEFAULT NULL,
413 P_RESOURCE_TERRITORY_ID IN NUMBER DEFAULT NULL ,
414 P_ASSIGNMENT_STATUS_ID IN NUMBER ,
415 P_SHIFT_CONSTRUCT_ID IN NUMBER DEFAULT NULL ,
416 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
417 X_MSG_COUNT OUT NOCOPY NUMBER ,
418 X_MSG_DATA OUT NOCOPY VARCHAR2 ,
419 X_TASK_ASSIGNMENT_ID OUT NOCOPY NUMBER ,
420 p_attribute1 IN VARCHAR2 DEFAULT null ,
421 p_attribute2 IN VARCHAR2 DEFAULT null ,
422 p_attribute3 IN VARCHAR2 DEFAULT null ,
423 p_attribute4 IN VARCHAR2 DEFAULT null ,
424 p_attribute5 IN VARCHAR2 DEFAULT null ,
425 p_attribute6 IN VARCHAR2 DEFAULT null ,
426 p_attribute7 IN VARCHAR2 DEFAULT null ,
427 p_attribute8 IN VARCHAR2 DEFAULT null ,
428 p_attribute9 IN VARCHAR2 DEFAULT null ,
429 p_attribute10 IN VARCHAR2 DEFAULT null ,
430 p_attribute11 IN VARCHAR2 DEFAULT null ,
431 p_attribute12 IN VARCHAR2 DEFAULT null ,
432 p_attribute13 IN VARCHAR2 DEFAULT null ,
436 P_SHOW_ON_CALENDAR in VARCHAR2 DEFAULT jtf_task_utl.g_yes_char,
433 p_attribute14 IN VARCHAR2 DEFAULT null ,
434 p_attribute15 IN VARCHAR2 DEFAULT null ,
435 p_attribute_category IN VARCHAR2 DEFAULT null ,
437 P_CATEGORY_ID in NUMBER DEFAULT null ) ;
438
439 /*#
440 * Deletes an existing Task Assignment.
441 *
442 * @param p_api_version Standard API version number. See "Standard IN Parameters", Oracle Common Application Calendar API Reference Guide.
443 * @rep:paraminfo {@rep:required}
444 * @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.
445 * See "Standard IN Parameters", Oracle Common Application Calendar API Reference Guide.
446 * @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.
447 * See "Standard IN Parameters", Oracle Common Application Calendar API Reference Guide.
448 * @param p_task_assignment_id Unique task assignment identifier of the assignment to be deleted.
449 * @rep:paraminfo {@rep:required}
450 * @param p_object_version_number Object version number of the current assignment record.
451 * @rep:paraminfo {@rep:required}
452 * @param x_return_status Result of all the operations performed by the API. This will have one of the following values:
453 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code> - If the API processed the data successfully.
454 * <LI><Code>FND_API.G_RET_STS_ERROR</Code> - If there was an expected error in API processing.
455 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code> If there was an unexpected error in API processing.
456 * @param x_msg_count Number of messages returned in the API message list.
457 * @param x_msg_data Returned message data in an encoded format if <code>x_msg_count</code> returns non-zero value.
458 * @param p_enable_workflow Flag to enable workflow passed as-is to <code>oracle.apps.jtf.cac.task.deleteTaskAssignment</code> business event.
459 * @rep:paraminfo {@rep:required}
460 * @param p_abort_workflow Flag to abort workflow passed as-is to <code>oracle.apps.jtf.cac.task.deleteTaskAssignment</code> business event.
461 * @rep:paraminfo {@rep:required}
462 *
463 * @rep:primaryinstance
464 * @rep:scope public
465 * @rep:lifecycle active
466 * @rep:displayname Delete Task Assignment
467 * @rep:compatibility S
468 * @rep:businessevent oracle.apps.jtf.cac.task.deleteTaskAssignment
469 */
470 Procedure Delete_Task_Assignment(
471 P_API_VERSION IN NUMBER ,
472 P_OBJECT_VERSION_NUMBER IN NUMBER ,
473 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
474 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
475 P_TASK_ASSIGNMENT_ID IN NUMBER ,
476 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
477 X_MSG_COUNT OUT NOCOPY NUMBER ,
478 X_MSG_DATA OUT NOCOPY VARCHAR2,
479 p_enable_workflow IN VARCHAR2,
480 p_abort_workflow IN VARCHAR2
481 );
482
483
484 Procedure Delete_Task_Assignment
485 (P_API_VERSION IN NUMBER ,
486 P_OBJECT_VERSION_NUMBER IN NUMBER ,
487 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
488 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE ,
489 P_TASK_ASSIGNMENT_ID IN NUMBER ,
490 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
491 X_MSG_COUNT OUT NOCOPY NUMBER ,
492 X_MSG_DATA OUT NOCOPY VARCHAR2 ) ;
493
494 --Procedure to Lock Task Assignment
495
496 -- Removed '#', so that it is not considered by irep. Bug# 5406214
497
498 /*
499 * Locks a Task assignment.
500 *
501 * @param p_api_version Standard API version number.
502 * @rep:paraminfo {@rep:required}
503 * @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.
504 * @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.
505 * @param p_task_assignment_id Unique task assignment identifier of the assignment to be locked.
506 * @rep:paraminfo {@rep:required}
507 * @param p_object_version_number Object version number of the current assignment record.
508 * @rep:paraminfo {@rep:required}
509 * @param x_return_status Result of all the operations performed by the API. This will have one of the following values:
510 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code> - If the API processed the data successfully.
511 * <LI><Code>FND_API.G_RET_STS_ERROR</Code> - If there was an expected error in API processing.
512 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code> If there was an unexpected error in API processing.
513 * @param x_msg_count Number of messages returned in the API message list.
514 * @param x_msg_data Returned message data in an encoded format if <code>x_msg_count</code> returns non-zero value.
515 *
516 * @rep:scope public
517 * @rep:lifecycle active
518 * @rep:displayname Lock Task Assignment
519 * @rep:compatibility S
520 */
521
522 PROCEDURE LOCK_TASK_ASSIGNMENT (
523 P_API_VERSION IN NUMBER,
524 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT fnd_api.g_false,
525 P_COMMIT IN VARCHAR2 DEFAULT fnd_api.g_false,
526 P_TASK_ASSIGNMENT_ID IN NUMBER,
527 P_OBJECT_VERSION_NUMBER IN NUMBER ,
528 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
529 X_MSG_DATA OUT NOCOPY VARCHAR2,
530 X_MSG_COUNT OUT NOCOPY NUMBER
531 );
532
533
534 --Procedure to Update the Task Assignment
535 /*#
536 * Updates an existing Task Assignment.
537 *
538 * @param p_api_version Standard API version number. See "Standard IN Parameters", Oracle Common Application Calendar API Reference Guide.
539 * @rep:paraminfo {@rep:required}
540 * @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.
541 * See "Standard IN Parameters", Oracle Common Application Calendar API Reference Guide.
542 * @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.
543 * See "Standard IN Parameters", Oracle Common Application Calendar API Reference Guide.
544 * @param p_object_version_number Object version number of the current assignment record.
545 * @rep:paraminfo {@rep:required}
546 * @param p_task_assignment_id Unique task assignment identifier of the assignment to be updated.
547 * @rep:paraminfo {@rep:required}
548 * @param p_task_id No longer in use.
549 * @param p_task_number No longer in use.
550 * @param p_task_name No longer in use.
551 * @param p_resource_type_code Resource type code for resource reassignment. A task assignment resource is identified with the resource type code and resource identifier therefore this should be used along with <code>p_resource_id</code>.
552 * @param p_resource_id Resource identifier for resource reassignment. Should be used along with <code>p_resource_type_code</code>.
553 * @param p_resource_name No longer in use.
554 * @param p_actual_effort Actual effort exerted by the resource. Should be used along with <code>p_actual_effort_uom</code>.
555 * @param p_actual_effort_uom Unit of Measure for the actual effort. Should be used along with <code>p_actual_effort</code>.
556 * @param p_schedule_flag Flag to denote if the assignment needs to be scheduled - Not currently used.
557 * @param p_alarm_type_code Alarm type code - Reserved for future use.
558 * @param p_alarm_contact Alarm contact - Reserved for future use.
559 * @param p_sched_travel_distance Scheduled travel distance for this assignment.
560 * @param p_sched_travel_duration Scheduled travel duration for this assignment. Should be passed along with <code>p_sched_travel_duration_uom</code>.
561 * @param p_sched_travel_duration_uom Unit of measure for scheduled travel duration. Should be passed along with <code>p_sched_travel_duration</code>.
562 * @param p_actual_travel_distance Actual distance traveled, logged by the resource.
563 * @param p_actual_travel_duration Actual travel duration, logged by the resource. Should be used along with <code>p_actual_travel_duration_uom</code>.
564 * @param p_actual_travel_duration_uom Unit of measure for the actual travel duration. Should be used along with <code>p_actual_travel_duration</code>.
565 * @param p_actual_start_date Actual start date and time for this assignment.
566 * @param p_actual_end_date Actual end date and time for this assignment.
567 * @param p_palm_flag Reserved for internal use only.
568 * @param p_wince_flag Reserved for internal use only.
569 * @param p_laptop_flag Reserved for internal use only.
570 * @param p_device1_flag Reserved for internal use only.
571 * @param p_device2_flag Reserved for internal use only.
572 * @param p_device3_flag Reserved for internal use only.
573 * @param p_resource_territory_id Unique territory identifier for the task assignment resource.
574 * @param p_assignment_status_id Unique assignment status identifier for this assignment.
575 * @param p_shift_construct_id Unique identifier for the shift used to schedule this assignment - Reserved for internal use only.
576 * @param x_return_status Result of all the operations performed by the API. This will have one of the following values:
577 * <LI><Code>FND_API.G_RET_STS_SUCCESS</Code> - If the API processed the data successfully.
578 * <LI><Code>FND_API.G_RET_STS_ERROR</Code> - If there was an expected error in API processing.
579 * <LI><Code>FND_API.G_RET_STS_UNEXP_ERROR</Code> If there was an unexpected error in API processing.
580 * @param x_msg_count Number of messages returned in the API message list.
581 * @param x_msg_data Returned message data in an encoded format if <code>x_msg_count</code> returns non-zero value.
582 * @param p_attribute1 Attribute1 of customer flex fields.
583 * @param p_attribute2 Attribute2 of customer flex fields.
584 * @param p_attribute3 Attribute3 of customer flex fields.
585 * @param p_attribute4 Attribute4 of customer flex fields.
586 * @param p_attribute5 Attribute5 of customer flex fields.
587 * @param p_attribute6 Attribute6 of customer flex fields.
588 * @param p_attribute7 Attribute7 of customer flex fields.
589 * @param p_attribute8 Attribute8 of customer flex fields.
590 * @param p_attribute9 Attribute9 of customer flex fields.
591 * @param p_attribute10 Attribute10 of customer flex fields.
592 * @param p_attribute11 Attribute11 of customer flex fields.
593 * @param p_attribute12 Attribute12 of customer flex fields.
594 * @param p_attribute13 Attribute13 of customer flex fields.
595 * @param p_attribute14 Attribute14 of customer flex fields.
596 * @param p_attribute15 Attribute15 of customer flex fields.
597 * @param p_attribute_category Attribute category for the customer flex fields.
598 * @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.
599 * This flag is defaulted to <code>'Y'</code> if not passed.
600 * @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>.
601 * @param p_enable_workflow Flag to enable workflow; passed as-is to <code>oracle.apps.jtf.cac.task.updateTaskAssignment</code> business event.
602 * @rep:paraminfo {@rep:required}
603 * @param p_abort_workflow Flag to abort workflow; passed as-is to <code>oracle.apps.jtf.cac.task.updateTaskAssignment</code> business event.
604 * @rep:paraminfo {@rep:required}
605 * @param p_object_capacity_id Unique identifier for the object capacity for this assignment. This is a foreign key to <code>cac_object_capacity.object_capacity_id</code>.
606 * @rep:paraminfo {@rep:required}
607 *
608 * @rep:primaryinstance
609 * @rep:scope public
610 * @rep:lifecycle active
611 * @rep:displayname Update Task Assignment
612 * @rep:compatibility S
613 * @rep:businessevent oracle.apps.jtf.cac.task.updateTaskAssignment
614 */
615 PROCEDURE update_task_assignment (
616 p_api_version IN NUMBER,
617 p_object_version_number IN OUT NOCOPY NUMBER,
618 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
619 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
620 p_task_assignment_id IN NUMBER,
621 P_TASK_ID IN NUMBER DEFAULT fnd_api.g_miss_num,
622 P_TASK_NUMBER IN varchar2 DEFAULT fnd_api.g_miss_char,
623 p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
624 p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
625 p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num,
626 P_RESOURCE_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char ,
627 p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
628 p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
629 p_schedule_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
630 p_alarm_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
631 p_alarm_contact IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
632 p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
633 p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
634 p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
635 p_actual_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
636 p_actual_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
637 p_actual_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
638 p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
639 p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
640 p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
641 p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
642 p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
643 p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
644 p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
645 p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
646 p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
647 p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
648 p_shift_construct_id IN NUMBER DEFAULT fnd_api.g_miss_num,
649 x_return_status OUT NOCOPY VARCHAR2,
650 x_msg_count OUT NOCOPY NUMBER,
651 x_msg_data OUT NOCOPY VARCHAR2,
652 p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
653 p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
654 p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
655 p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
656 p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
657 p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
658 p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
659 p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
660 p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
661 p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
662 p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
663 p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
664 p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
665 p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
666 p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
667 p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
668 P_SHOW_ON_CALENDAR in VARCHAR2 default jtf_task_utl.g_miss_char,
669 P_CATEGORY_ID in NUMBER default jtf_task_utl.g_miss_number,
670 p_enable_workflow IN VARCHAR2,
671 p_abort_workflow IN VARCHAR2,
672 p_object_capacity_id IN NUMBER
673 ) ;
674
675
676 PROCEDURE update_task_assignment (
677 p_api_version IN NUMBER,
678 p_object_version_number IN OUT NOCOPY NUMBER,
679 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
680 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
681 p_task_assignment_id IN NUMBER,
682 P_TASK_ID IN NUMBER DEFAULT fnd_api.g_miss_num,
683 P_TASK_NUMBER IN varchar2 DEFAULT fnd_api.g_miss_char,
684 p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
685 p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
686 p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num,
687 P_RESOURCE_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char ,
688 p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
689 p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
690 p_schedule_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
691 p_alarm_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
692 p_alarm_contact IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
693 p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
694 p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
695 p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
696 p_actual_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
697 p_actual_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
698 p_actual_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
699 p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
700 p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
701 p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
702 p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
703 p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
704 p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
705 p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
706 p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
707 p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
708 p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
709 p_shift_construct_id IN NUMBER DEFAULT fnd_api.g_miss_num,
710 x_return_status OUT NOCOPY VARCHAR2,
711 x_msg_count OUT NOCOPY NUMBER,
712 x_msg_data OUT NOCOPY VARCHAR2,
713 p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
714 p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
715 p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
716 p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
717 p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
718 p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
719 p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
720 p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
721 p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
722 p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
723 p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
724 p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
725 p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
726 p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
727 p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
728 p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
729 P_SHOW_ON_CALENDAR in VARCHAR2 default jtf_task_utl.g_miss_char,
730 P_CATEGORY_ID in NUMBER default jtf_task_utl.g_miss_number,
731 p_enable_workflow IN VARCHAR2,
732 p_abort_workflow IN VARCHAR2
733 ) ;
734
735
736 PROCEDURE update_task_assignment (
737 p_api_version IN NUMBER,
738 p_object_version_number IN OUT NOCOPY NUMBER,
739 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
740 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
741 p_task_assignment_id IN NUMBER,
742 P_TASK_ID IN NUMBER DEFAULT fnd_api.g_miss_num,
743 P_TASK_NUMBER IN varchar2 DEFAULT fnd_api.g_miss_char,
744 p_task_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
745 p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
746 p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num,
747 P_RESOURCE_name IN VARCHAR2 DEFAULT fnd_api.g_miss_char ,
748 p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
749 p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
750 p_schedule_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
751 p_alarm_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
752 p_alarm_contact IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
753 p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
754 p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
755 p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
756 p_actual_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
757 p_actual_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
758 p_actual_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
759 p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
760 p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
761 p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
762 p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
763 p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
764 p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
765 p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
766 p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
767 p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
768 p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
769 p_shift_construct_id IN NUMBER DEFAULT fnd_api.g_miss_num,
770 x_return_status OUT NOCOPY VARCHAR2,
771 x_msg_count OUT NOCOPY NUMBER,
772 x_msg_data OUT NOCOPY VARCHAR2,
773 p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
774 p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
775 p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
776 p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
777 p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
778 p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
779 p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
780 p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
781 p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
782 p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
783 p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
784 p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
785 p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
786 p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
787 p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
788 p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
789 P_SHOW_ON_CALENDAR in VARCHAR2 default jtf_task_utl.g_miss_char,
790 P_CATEGORY_ID in NUMBER default jtf_task_utl.g_miss_number
791 ) ;
792
793 End ;
[Home] [Help]