1 PACKAGE jtf_task_assignments_pvt AUTHID CURRENT_USER AS
2 /* $Header: jtfvtkas.pls 120.1.12000000.2 2007/07/06 08:37:14 lokumar ship $ */
3
4 ---------------------------------------------------------------------------
5 --Define Global Variables
6 ---------------------------------------------------------------------------
7 G_PKG_NAME CONSTANT VARCHAR2(30):='JTF_TASK_ASSIGNMENTS_PVT' ;
8 G_USER CONSTANT VARCHAR2(30):=FND_GLOBAL.USER_ID;
9 G_ENABLE_WORKFLOW CONSTANT VARCHAR2(1) := fnd_profile.value('JTF_TASK_ENABLE_WORKFLOW');
10 G_ABORT_WORKFLOW CONSTANT VARCHAR2(1) := fnd_profile.value('JTF_TASK_ABORT_PREV_WF');
11
12 G_RESPONSE_FLAG VARCHAR2(1) := jtf_task_utl.g_no_char;
13 ---------------------------------------------------------------------------
14
15 PROCEDURE create_task_assignment (
16 p_api_version IN NUMBER,
17 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
18 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
19 p_task_assignment_id IN NUMBER DEFAULT NULL,
20 p_task_id IN NUMBER DEFAULT NULL,
21 p_resource_type_code IN VARCHAR2,
22 p_resource_id IN NUMBER,
23 p_actual_effort IN NUMBER DEFAULT NULL,
24 p_actual_effort_uom IN VARCHAR2 DEFAULT NULL,
25 p_schedule_flag IN VARCHAR2 DEFAULT NULL,
26 p_alarm_type_code IN VARCHAR2 DEFAULT NULL,
27 p_alarm_contact IN VARCHAR2 DEFAULT NULL,
28 p_sched_travel_distance IN NUMBER DEFAULT NULL,
29 p_sched_travel_duration IN NUMBER DEFAULT NULL,
30 p_sched_travel_duration_uom IN VARCHAR2 DEFAULT NULL,
31 p_actual_travel_distance IN NUMBER DEFAULT NULL,
32 p_actual_travel_duration IN NUMBER DEFAULT NULL,
33 p_actual_travel_duration_uom IN VARCHAR2 DEFAULT NULL,
34 p_actual_start_date IN DATE DEFAULT NULL,
35 p_actual_end_date IN DATE DEFAULT NULL,
36 p_palm_flag IN VARCHAR2 DEFAULT NULL,
37 p_wince_flag IN VARCHAR2 DEFAULT NULL,
38 p_laptop_flag IN VARCHAR2 DEFAULT NULL,
39 p_device1_flag IN VARCHAR2 DEFAULT NULL,
40 p_device2_flag IN VARCHAR2 DEFAULT NULL,
41 p_device3_flag IN VARCHAR2 DEFAULT NULL,
42 p_resource_territory_id IN NUMBER DEFAULT NULL,
43 p_assignment_status_id IN NUMBER,
44 p_shift_construct_id IN NUMBER DEFAULT NULL,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2,
48 x_task_assignment_id OUT NOCOPY NUMBER,
49 p_attribute1 IN VARCHAR2 DEFAULT null ,
50 p_attribute2 IN VARCHAR2 DEFAULT null ,
51 p_attribute3 IN VARCHAR2 DEFAULT null ,
52 p_attribute4 IN VARCHAR2 DEFAULT null ,
53 p_attribute5 IN VARCHAR2 DEFAULT null ,
54 p_attribute6 IN VARCHAR2 DEFAULT null ,
55 p_attribute7 IN VARCHAR2 DEFAULT null ,
56 p_attribute8 IN VARCHAR2 DEFAULT null ,
57 p_attribute9 IN VARCHAR2 DEFAULT null ,
58 p_attribute10 IN VARCHAR2 DEFAULT null ,
59 p_attribute11 IN VARCHAR2 DEFAULT null ,
60 p_attribute12 IN VARCHAR2 DEFAULT null ,
61 p_attribute13 IN VARCHAR2 DEFAULT null ,
62 p_attribute14 IN VARCHAR2 DEFAULT null ,
63 p_attribute15 IN VARCHAR2 DEFAULT null ,
64 p_attribute_category IN VARCHAR2 DEFAULT null ,
65 p_assignee_role IN VARCHAR2 DEFAULT 'ASSIGNEE',
66 p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_yes_char,
67 p_category_id IN NUMBER DEFAULT null,
68 p_enable_workflow IN VARCHAR2,
69 p_abort_workflow IN VARCHAR2,
70 p_add_option IN VARCHAR2,
71 p_free_busy_type IN VARCHAR2
72 ) ;
73
74 PROCEDURE create_task_assignment (
75 p_api_version IN NUMBER,
76 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
77 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
78 p_task_assignment_id IN NUMBER DEFAULT NULL,
79 p_task_id IN NUMBER DEFAULT NULL,
80 p_resource_type_code IN VARCHAR2,
81 p_resource_id IN NUMBER,
82 p_actual_effort IN NUMBER DEFAULT NULL,
83 p_actual_effort_uom IN VARCHAR2 DEFAULT NULL,
84 p_schedule_flag IN VARCHAR2 DEFAULT NULL,
85 p_alarm_type_code IN VARCHAR2 DEFAULT NULL,
86 p_alarm_contact IN VARCHAR2 DEFAULT NULL,
87 p_sched_travel_distance IN NUMBER DEFAULT NULL,
88 p_sched_travel_duration IN NUMBER DEFAULT NULL,
89 p_sched_travel_duration_uom IN VARCHAR2 DEFAULT NULL,
90 p_actual_travel_distance IN NUMBER DEFAULT NULL,
91 p_actual_travel_duration IN NUMBER DEFAULT NULL,
92 p_actual_travel_duration_uom IN VARCHAR2 DEFAULT NULL,
93 p_actual_start_date IN DATE DEFAULT NULL,
94 p_actual_end_date IN DATE DEFAULT NULL,
95 p_palm_flag IN VARCHAR2 DEFAULT NULL,
96 p_wince_flag IN VARCHAR2 DEFAULT NULL,
97 p_laptop_flag IN VARCHAR2 DEFAULT NULL,
98 p_device1_flag IN VARCHAR2 DEFAULT NULL,
99 p_device2_flag IN VARCHAR2 DEFAULT NULL,
100 p_device3_flag IN VARCHAR2 DEFAULT NULL,
101 p_resource_territory_id IN NUMBER DEFAULT NULL,
102 p_assignment_status_id IN NUMBER,
103 p_shift_construct_id IN NUMBER DEFAULT NULL,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107 x_task_assignment_id OUT NOCOPY NUMBER,
108 p_attribute1 IN VARCHAR2 DEFAULT null ,
109 p_attribute2 IN VARCHAR2 DEFAULT null ,
110 p_attribute3 IN VARCHAR2 DEFAULT null ,
111 p_attribute4 IN VARCHAR2 DEFAULT null ,
112 p_attribute5 IN VARCHAR2 DEFAULT null ,
113 p_attribute6 IN VARCHAR2 DEFAULT null ,
114 p_attribute7 IN VARCHAR2 DEFAULT null ,
115 p_attribute8 IN VARCHAR2 DEFAULT null ,
116 p_attribute9 IN VARCHAR2 DEFAULT null ,
117 p_attribute10 IN VARCHAR2 DEFAULT null ,
118 p_attribute11 IN VARCHAR2 DEFAULT null ,
119 p_attribute12 IN VARCHAR2 DEFAULT null ,
120 p_attribute13 IN VARCHAR2 DEFAULT null ,
121 p_attribute14 IN VARCHAR2 DEFAULT null ,
122 p_attribute15 IN VARCHAR2 DEFAULT null ,
123 p_attribute_category IN VARCHAR2 DEFAULT null ,
124 p_assignee_role IN VARCHAR2 DEFAULT 'ASSIGNEE',
125 p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_yes_char,
126 p_category_id IN NUMBER DEFAULT null,
127 p_enable_workflow IN VARCHAR2,
128 p_abort_workflow IN VARCHAR2,
129 p_add_option IN VARCHAR2,
130 p_free_busy_type IN VARCHAR2,
131 p_object_capacity_id IN NUMBER
132 ) ;
133
134 PROCEDURE create_task_assignment (
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
137 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
138 p_task_assignment_id IN NUMBER DEFAULT NULL,
139 p_task_id IN NUMBER DEFAULT NULL,
140 p_resource_type_code IN VARCHAR2,
141 p_resource_id IN NUMBER,
142 p_actual_effort IN NUMBER DEFAULT NULL,
143 p_actual_effort_uom IN VARCHAR2 DEFAULT NULL,
144 p_schedule_flag IN VARCHAR2 DEFAULT NULL,
145 p_alarm_type_code IN VARCHAR2 DEFAULT NULL,
146 p_alarm_contact IN VARCHAR2 DEFAULT NULL,
147 p_sched_travel_distance IN NUMBER DEFAULT NULL,
148 p_sched_travel_duration IN NUMBER DEFAULT NULL,
149 p_sched_travel_duration_uom IN VARCHAR2 DEFAULT NULL,
150 p_actual_travel_distance IN NUMBER DEFAULT NULL,
151 p_actual_travel_duration IN NUMBER DEFAULT NULL,
152 p_actual_travel_duration_uom IN VARCHAR2 DEFAULT NULL,
153 p_actual_start_date IN DATE DEFAULT NULL,
154 p_actual_end_date IN DATE DEFAULT NULL,
155 p_palm_flag IN VARCHAR2 DEFAULT NULL,
156 p_wince_flag IN VARCHAR2 DEFAULT NULL,
157 p_laptop_flag IN VARCHAR2 DEFAULT NULL,
158 p_device1_flag IN VARCHAR2 DEFAULT NULL,
159 p_device2_flag IN VARCHAR2 DEFAULT NULL,
160 p_device3_flag IN VARCHAR2 DEFAULT NULL,
161 p_resource_territory_id IN NUMBER DEFAULT NULL,
162 p_assignment_status_id IN NUMBER,
163 p_shift_construct_id IN NUMBER DEFAULT NULL,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2,
167 x_task_assignment_id OUT NOCOPY NUMBER,
168 p_attribute1 IN VARCHAR2 DEFAULT null ,
169 p_attribute2 IN VARCHAR2 DEFAULT null ,
170 p_attribute3 IN VARCHAR2 DEFAULT null ,
171 p_attribute4 IN VARCHAR2 DEFAULT null ,
172 p_attribute5 IN VARCHAR2 DEFAULT null ,
173 p_attribute6 IN VARCHAR2 DEFAULT null ,
174 p_attribute7 IN VARCHAR2 DEFAULT null ,
175 p_attribute8 IN VARCHAR2 DEFAULT null ,
176 p_attribute9 IN VARCHAR2 DEFAULT null ,
177 p_attribute10 IN VARCHAR2 DEFAULT null ,
178 p_attribute11 IN VARCHAR2 DEFAULT null ,
179 p_attribute12 IN VARCHAR2 DEFAULT null ,
180 p_attribute13 IN VARCHAR2 DEFAULT null ,
181 p_attribute14 IN VARCHAR2 DEFAULT null ,
182 p_attribute15 IN VARCHAR2 DEFAULT null ,
183 p_attribute_category IN VARCHAR2 DEFAULT null ,
184 p_assignee_role IN VARCHAR2 DEFAULT 'ASSIGNEE',
185 p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_yes_char,
186 p_category_id IN NUMBER DEFAULT null,
187 p_enable_workflow IN VARCHAR2,
188 p_abort_workflow IN VARCHAR2,
189 p_add_option IN VARCHAR2
190 ) ;
191
192 PROCEDURE create_task_assignment (
193 p_api_version IN NUMBER,
194 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
195 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
196 p_task_assignment_id IN NUMBER DEFAULT NULL,
197 p_task_id IN NUMBER DEFAULT NULL,
198 p_resource_type_code IN VARCHAR2,
199 p_resource_id IN NUMBER,
200 p_actual_effort IN NUMBER DEFAULT NULL,
201 p_actual_effort_uom IN VARCHAR2 DEFAULT NULL,
202 p_schedule_flag IN VARCHAR2 DEFAULT NULL,
203 p_alarm_type_code IN VARCHAR2 DEFAULT NULL,
204 p_alarm_contact IN VARCHAR2 DEFAULT NULL,
205 p_sched_travel_distance IN NUMBER DEFAULT NULL,
206 p_sched_travel_duration IN NUMBER DEFAULT NULL,
207 p_sched_travel_duration_uom IN VARCHAR2 DEFAULT NULL,
208 p_actual_travel_distance IN NUMBER DEFAULT NULL,
209 p_actual_travel_duration IN NUMBER DEFAULT NULL,
210 p_actual_travel_duration_uom IN VARCHAR2 DEFAULT NULL,
211 p_actual_start_date IN DATE DEFAULT NULL,
212 p_actual_end_date IN DATE DEFAULT NULL,
213 p_palm_flag IN VARCHAR2 DEFAULT NULL,
214 p_wince_flag IN VARCHAR2 DEFAULT NULL,
215 p_laptop_flag IN VARCHAR2 DEFAULT NULL,
216 p_device1_flag IN VARCHAR2 DEFAULT NULL,
217 p_device2_flag IN VARCHAR2 DEFAULT NULL,
218 p_device3_flag IN VARCHAR2 DEFAULT NULL,
219 p_resource_territory_id IN NUMBER DEFAULT NULL,
220 p_assignment_status_id IN NUMBER,
221 p_shift_construct_id IN NUMBER DEFAULT NULL,
222 x_return_status OUT NOCOPY VARCHAR2,
223 x_msg_count OUT NOCOPY NUMBER,
224 x_msg_data OUT NOCOPY VARCHAR2,
225 x_task_assignment_id OUT NOCOPY NUMBER,
226 p_attribute1 IN VARCHAR2 DEFAULT null ,
227 p_attribute2 IN VARCHAR2 DEFAULT null ,
228 p_attribute3 IN VARCHAR2 DEFAULT null ,
229 p_attribute4 IN VARCHAR2 DEFAULT null ,
230 p_attribute5 IN VARCHAR2 DEFAULT null ,
231 p_attribute6 IN VARCHAR2 DEFAULT null ,
232 p_attribute7 IN VARCHAR2 DEFAULT null ,
233 p_attribute8 IN VARCHAR2 DEFAULT null ,
234 p_attribute9 IN VARCHAR2 DEFAULT null ,
235 p_attribute10 IN VARCHAR2 DEFAULT null ,
236 p_attribute11 IN VARCHAR2 DEFAULT null ,
237 p_attribute12 IN VARCHAR2 DEFAULT null ,
238 p_attribute13 IN VARCHAR2 DEFAULT null ,
239 p_attribute14 IN VARCHAR2 DEFAULT null ,
240 p_attribute15 IN VARCHAR2 DEFAULT null ,
241 p_attribute_category IN VARCHAR2 DEFAULT null ,
242 p_assignee_role IN VARCHAR2 DEFAULT 'ASSIGNEE',
243 p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_yes_char,
244 p_category_id IN NUMBER DEFAULT null,
245 p_enable_workflow IN VARCHAR2,
246 p_abort_workflow IN VARCHAR2
247 ) ;
248
249 PROCEDURE create_task_assignment (
250 p_api_version IN NUMBER,
251 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
252 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
253 p_task_assignment_id IN NUMBER DEFAULT NULL,
254 p_task_id IN NUMBER DEFAULT NULL,
255 p_resource_type_code IN VARCHAR2,
256 p_resource_id IN NUMBER,
257 p_actual_effort IN NUMBER DEFAULT NULL,
258 p_actual_effort_uom IN VARCHAR2 DEFAULT NULL,
259 p_schedule_flag IN VARCHAR2 DEFAULT NULL,
260 p_alarm_type_code IN VARCHAR2 DEFAULT NULL,
261 p_alarm_contact IN VARCHAR2 DEFAULT NULL,
262 p_sched_travel_distance IN NUMBER DEFAULT NULL,
263 p_sched_travel_duration IN NUMBER DEFAULT NULL,
264 p_sched_travel_duration_uom IN VARCHAR2 DEFAULT NULL,
265 p_actual_travel_distance IN NUMBER DEFAULT NULL,
266 p_actual_travel_duration IN NUMBER DEFAULT NULL,
267 p_actual_travel_duration_uom IN VARCHAR2 DEFAULT NULL,
268 p_actual_start_date IN DATE DEFAULT NULL,
269 p_actual_end_date IN DATE DEFAULT NULL,
270 p_palm_flag IN VARCHAR2 DEFAULT NULL,
271 p_wince_flag IN VARCHAR2 DEFAULT NULL,
272 p_laptop_flag IN VARCHAR2 DEFAULT NULL,
273 p_device1_flag IN VARCHAR2 DEFAULT NULL,
274 p_device2_flag IN VARCHAR2 DEFAULT NULL,
275 p_device3_flag IN VARCHAR2 DEFAULT NULL,
276 p_resource_territory_id IN NUMBER DEFAULT NULL,
277 p_assignment_status_id IN NUMBER,
278 p_shift_construct_id IN NUMBER DEFAULT NULL,
279 x_return_status OUT NOCOPY VARCHAR2,
280 x_msg_count OUT NOCOPY NUMBER,
281 x_msg_data OUT NOCOPY VARCHAR2,
282 x_task_assignment_id OUT NOCOPY NUMBER,
283 p_attribute1 IN VARCHAR2 DEFAULT null ,
284 p_attribute2 IN VARCHAR2 DEFAULT null ,
285 p_attribute3 IN VARCHAR2 DEFAULT null ,
286 p_attribute4 IN VARCHAR2 DEFAULT null ,
287 p_attribute5 IN VARCHAR2 DEFAULT null ,
288 p_attribute6 IN VARCHAR2 DEFAULT null ,
289 p_attribute7 IN VARCHAR2 DEFAULT null ,
290 p_attribute8 IN VARCHAR2 DEFAULT null ,
291 p_attribute9 IN VARCHAR2 DEFAULT null ,
292 p_attribute10 IN VARCHAR2 DEFAULT null ,
293 p_attribute11 IN VARCHAR2 DEFAULT null ,
294 p_attribute12 IN VARCHAR2 DEFAULT null ,
295 p_attribute13 IN VARCHAR2 DEFAULT null ,
296 p_attribute14 IN VARCHAR2 DEFAULT null ,
297 p_attribute15 IN VARCHAR2 DEFAULT null ,
298 p_attribute_category IN VARCHAR2 DEFAULT null ,
299 p_assignee_role IN VARCHAR2 DEFAULT 'ASSIGNEE',
300 p_show_on_calendar IN VARCHAR2 DEFAULT jtf_task_utl.g_yes_char,
301 p_category_id IN NUMBER DEFAULT null
302 ) ;
303
304 Procedure Delete_Task_Assignment
305 (P_API_VERSION IN NUMBER,
306 P_OBJECT_VERSION_NUMBER IN NUMBER,
307 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
308 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
309 P_TASK_ASSIGNMENT_ID IN NUMBER,
310 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
311 X_MSG_COUNT OUT NOCOPY NUMBER,
312 X_MSG_DATA OUT NOCOPY VARCHAR2,
313 p_enable_workflow IN VARCHAR2,
314 p_abort_workflow IN VARCHAR2,
315 p_delete_option IN VARCHAR2);
316
317 Procedure Delete_Task_Assignment
318 (P_API_VERSION IN NUMBER,
319 P_OBJECT_VERSION_NUMBER IN NUMBER,
320 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
321 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
322 P_TASK_ASSIGNMENT_ID IN NUMBER,
323 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
324 X_MSG_COUNT OUT NOCOPY NUMBER,
325 X_MSG_DATA OUT NOCOPY VARCHAR2,
326 p_enable_workflow IN VARCHAR2,
327 p_abort_workflow IN VARCHAR2);
328
329 Procedure Delete_Task_Assignment
330 (P_API_VERSION IN NUMBER,
331 P_OBJECT_VERSION_NUMBER IN NUMBER,
332 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
333 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
334 P_TASK_ASSIGNMENT_ID IN NUMBER,
335 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
336 X_MSG_COUNT OUT NOCOPY NUMBER,
337 X_MSG_DATA OUT NOCOPY VARCHAR2);
338
339 PROCEDURE update_task_assignment (
340 p_api_version IN NUMBER,
341 p_object_version_number IN OUT NOCOPY NUMBER,
342 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
343 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
344 p_task_assignment_id IN NUMBER DEFAULT fnd_api.g_miss_num,
345 p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
346 p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num,
347 p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
348 p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
349 p_schedule_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
350 p_alarm_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
351 p_alarm_contact IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
352 p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
353 p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
354 p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
355 p_actual_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
356 p_actual_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
357 p_actual_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
358 p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
359 p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
360 p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
361 p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
362 p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
363 p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
364 p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
365 p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
366 p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
367 p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
368 p_shift_construct_id IN NUMBER DEFAULT fnd_api.g_miss_num,
369 x_return_status OUT NOCOPY VARCHAR2,
370 x_msg_count OUT NOCOPY NUMBER,
371 x_msg_data OUT NOCOPY VARCHAR2,
372 p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
373 p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
374 p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
375 p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
376 p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
377 p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
378 p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
379 p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
380 p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
381 p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
382 p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
383 p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
384 p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
385 p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
386 p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
387 p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
388 p_assignee_role IN VARCHAR2 default jtf_task_utl.g_miss_char,
389 p_show_on_calendar IN VARCHAR2 default jtf_task_utl.g_miss_char,
390 p_category_id IN NUMBER default jtf_task_utl.g_miss_number,
391 p_enable_workflow IN VARCHAR2,
392 p_abort_workflow IN VARCHAR2,
393 p_free_busy_type IN VARCHAR2
394 );
395
396
397 PROCEDURE update_task_assignment (
398 p_api_version IN NUMBER,
399 p_object_version_number IN OUT NOCOPY NUMBER,
400 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
401 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
402 p_task_assignment_id IN NUMBER DEFAULT fnd_api.g_miss_num,
403 p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
404 p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num,
405 p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
406 p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
407 p_schedule_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
408 p_alarm_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
409 p_alarm_contact IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
410 p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
411 p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
412 p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
413 p_actual_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
414 p_actual_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
415 p_actual_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
416 p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
417 p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
418 p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
419 p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
420 p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
421 p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
422 p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
423 p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
424 p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
425 p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
426 p_shift_construct_id IN NUMBER DEFAULT fnd_api.g_miss_num,
427 x_return_status OUT NOCOPY VARCHAR2,
428 x_msg_count OUT NOCOPY NUMBER,
429 x_msg_data OUT NOCOPY VARCHAR2,
430 p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
431 p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
432 p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
433 p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
434 p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
435 p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
436 p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
437 p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
438 p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
439 p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
440 p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
441 p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
442 p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
443 p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
444 p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
445 p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
446 p_assignee_role IN VARCHAR2 default jtf_task_utl.g_miss_char,
447 p_show_on_calendar IN VARCHAR2 default jtf_task_utl.g_miss_char,
448 p_category_id IN NUMBER default jtf_task_utl.g_miss_number,
449 p_enable_workflow IN VARCHAR2,
450 p_abort_workflow IN VARCHAR2,
451 p_free_busy_type IN VARCHAR2,
452 p_object_capacity_id IN NUMBER
453 ) ;
454
455 PROCEDURE update_task_assignment (
456 p_api_version IN NUMBER,
457 p_object_version_number IN OUT NOCOPY NUMBER,
458 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
459 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
460 p_task_assignment_id IN NUMBER DEFAULT fnd_api.g_miss_num,
461 p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
462 p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num,
463 p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
464 p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
465 p_schedule_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
466 p_alarm_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
467 p_alarm_contact IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
468 p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
469 p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
470 p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
471 p_actual_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
472 p_actual_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
473 p_actual_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
474 p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
475 p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
476 p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
477 p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
478 p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
479 p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
480 p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
481 p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
482 p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
483 p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
484 p_shift_construct_id IN NUMBER DEFAULT fnd_api.g_miss_num,
485 x_return_status OUT NOCOPY VARCHAR2,
486 x_msg_count OUT NOCOPY NUMBER,
487 x_msg_data OUT NOCOPY VARCHAR2,
488 p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
489 p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
490 p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
491 p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
492 p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
493 p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
494 p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
495 p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
496 p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
497 p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
498 p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
499 p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
500 p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
501 p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
502 p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
503 p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
504 p_assignee_role IN VARCHAR2 default jtf_task_utl.g_miss_char,
505 p_show_on_calendar IN VARCHAR2 default jtf_task_utl.g_miss_char,
506 p_category_id IN NUMBER default jtf_task_utl.g_miss_number,
507 p_enable_workflow IN VARCHAR2,
508 p_abort_workflow IN VARCHAR2
509 ) ;
510
511 PROCEDURE update_task_assignment (
512 p_api_version IN NUMBER,
513 p_object_version_number IN OUT NOCOPY NUMBER,
514 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
515 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
516 p_task_assignment_id IN NUMBER DEFAULT fnd_api.g_miss_num,
517 p_resource_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
518 p_resource_id IN NUMBER DEFAULT fnd_api.g_miss_num,
519 p_actual_effort IN NUMBER DEFAULT fnd_api.g_miss_num,
520 p_actual_effort_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
521 p_schedule_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
522 p_alarm_type_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
523 p_alarm_contact IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
524 p_sched_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
525 p_sched_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
526 p_sched_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
527 p_actual_travel_distance IN NUMBER DEFAULT fnd_api.g_miss_num,
528 p_actual_travel_duration IN NUMBER DEFAULT fnd_api.g_miss_num,
529 p_actual_travel_duration_uom IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
530 p_actual_start_date IN DATE DEFAULT fnd_api.g_miss_date,
531 p_actual_end_date IN DATE DEFAULT fnd_api.g_miss_date,
532 p_palm_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
533 p_wince_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
534 p_laptop_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
535 p_device1_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
536 p_device2_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
537 p_device3_flag IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
538 p_resource_territory_id IN NUMBER DEFAULT fnd_api.g_miss_num,
539 p_assignment_status_id IN NUMBER DEFAULT fnd_api.g_miss_num,
540 p_shift_construct_id IN NUMBER DEFAULT fnd_api.g_miss_num,
541 x_return_status OUT NOCOPY VARCHAR2,
542 x_msg_count OUT NOCOPY NUMBER,
543 x_msg_data OUT NOCOPY VARCHAR2,
544 p_attribute1 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
545 p_attribute2 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
546 p_attribute3 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
547 p_attribute4 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
548 p_attribute5 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
549 p_attribute6 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
550 p_attribute7 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
551 p_attribute8 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
552 p_attribute9 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
553 p_attribute10 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
554 p_attribute11 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
555 p_attribute12 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
556 p_attribute13 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
557 p_attribute14 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
558 p_attribute15 IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
559 p_attribute_category IN VARCHAR2 DEFAULT jtf_task_utl.g_miss_char,
560 p_assignee_role IN VARCHAR2 default jtf_task_utl.g_miss_char,
561 p_show_on_calendar IN VARCHAR2 default jtf_task_utl.g_miss_char,
562 p_category_id IN NUMBER default jtf_task_utl.g_miss_number
563 ) ;
564
565 -- Added this procedure in the spec as part of bug# 6067036
566 -- so that it can be called from other APIs
567 PROCEDURE populate_booking_dates
568 (
569 p_calendar_start_date IN DATE,
570 p_calendar_end_date IN DATE,
571 p_actual_start_date IN DATE,
572 p_actual_end_date IN DATE,
573 p_actual_travel_duration IN NUMBER,
574 p_actual_travel_duration_uom IN VARCHAR2,
575 p_planned_effort IN NUMBER,
576 p_planned_effort_uom IN VARCHAR2,
577 p_actual_effort IN NUMBER,
578 p_actual_effort_uom IN VARCHAR2,
579 x_booking_start_date OUT NOCOPY DATE,
580 x_booking_end_date OUT NOCOPY DATE
581 ) ;
582
583
584 -- Business Event System Enhancement # 2391065
585 TYPE task_assignments_rec IS RECORD (
586 task_assignment_id jtf_task_all_assignments. task_assignment_id %type,
587 task_id jtf_tasks_b.task_id%type,
588 resource_type_code jtf_task_all_assignments. resource_type_code %type,
589 resource_id jtf_task_all_assignments. resource_id %type,
590 assignment_status_id jtf_task_all_assignments. assignment_status_id %type,
591 actual_start_date jtf_task_all_assignments. actual_start_date %type,
592 actual_end_date jtf_task_all_assignments. actual_end_date %type,
593 assignee_role jtf_task_all_assignments. assignee_role %type,
594 show_on_calendar jtf_task_all_assignments. show_on_calendar %type,
595 category_id jtf_task_all_assignments. category_id %type,
596 object_version_number jtf_task_all_assignments. object_version_number %type,
597 enable_workflow varchar2(1) := fnd_api.g_miss_char,
598 abort_workflow varchar2(1) := fnd_api.g_miss_char
599 );
600
601 End;