[Home] [Help]
PACKAGE BODY: APPS.JTF_TASK_ASSIGNMENTS_PKG
Source
1 PACKAGE body JTF_TASK_ASSIGNMENTS_PKG as
2 /* $Header: jtftkasb.pls 120.3.12010000.4 2010/04/20 09:09:32 anangupt ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out NOCOPY VARCHAR2,
5 X_TASK_ASSIGNMENT_ID in NUMBER,
6 X_SCHED_TRAVEL_DURATION_UOM in VARCHAR2,
7 X_ACTUAL_TRAVEL_DISTANCE in NUMBER,
8 X_ACTUAL_TRAVEL_DURATION in NUMBER,
9 X_ACTUAL_TRAVEL_DURATION_UOM in VARCHAR2,
10 X_ACTUAL_START_DATE in DATE,
11 X_ACTUAL_END_DATE in DATE,
12 X_PALM_FLAG in VARCHAR2,
13 X_WINCE_FLAG in VARCHAR2,
14 X_LAPTOP_FLAG in VARCHAR2,
15 X_DEVICE1_FLAG in VARCHAR2,
16 X_DEVICE2_FLAG in VARCHAR2,
17 X_DEVICE3_FLAG in VARCHAR2,
18 X_ATTRIBUTE1 in VARCHAR2,
19 X_ATTRIBUTE2 in VARCHAR2,
20 X_ATTRIBUTE3 in VARCHAR2,
21 X_ATTRIBUTE4 in VARCHAR2,
22 X_ATTRIBUTE5 in VARCHAR2,
23 X_ATTRIBUTE6 in VARCHAR2,
24 X_ATTRIBUTE7 in VARCHAR2,
25 X_ATTRIBUTE8 in VARCHAR2,
26 X_ATTRIBUTE9 in VARCHAR2,
27 X_ATTRIBUTE10 in VARCHAR2,
28 X_ATTRIBUTE11 in VARCHAR2,
29 X_ATTRIBUTE12 in VARCHAR2,
30 X_ATTRIBUTE13 in VARCHAR2,
31 X_ATTRIBUTE14 in VARCHAR2,
32 X_ATTRIBUTE15 in VARCHAR2,
33 X_ATTRIBUTE_CATEGORY in VARCHAR2,
34 X_TASK_ID in NUMBER,
35 X_RESOURCE_ID in NUMBER,
36 X_ACTUAL_EFFORT in NUMBER,
37 X_ACTUAL_EFFORT_UOM in VARCHAR2,
38 X_SCHEDULE_FLAG in VARCHAR2,
39 X_ALARM_TYPE_CODE in VARCHAR2,
40 X_ALARM_CONTACT in VARCHAR2,
41 X_SCHED_TRAVEL_DISTANCE in NUMBER,
42 X_SCHED_TRAVEL_DURATION in NUMBER,
43 X_RESOURCE_TYPE_CODE in VARCHAR2,
44 X_CREATION_DATE in DATE,
45 X_CREATED_BY in NUMBER,
46 X_LAST_UPDATE_DATE in DATE,
47 X_LAST_UPDATED_BY in NUMBER,
48 X_LAST_UPDATE_LOGIN in NUMBER,
49 X_RESOURCE_TERRITORY_ID in NUMBER,
50 X_ASSIGNMENT_STATUS_ID in NUMBER,
51 X_SHIFT_CONSTRUCT_ID in NUMBER,
52 X_ASSIGNEE_ROLE in VARCHAR2,
53 X_SHOW_ON_CALENDAR in VARCHAR2,
54 X_CATEGORY_ID in NUMBER,
55 X_FREE_BUSY_TYPE in VARCHAR2,
56 X_BOOKING_START_DATE in DATE,
57 X_BOOKING_END_DATE in DATE,
58 X_OBJECT_CAPACITY_ID in NUMBER
59 ) is
60 cursor C is select ROWID from jtf_task_all_assignments
61 where TASK_ASSIGNMENT_ID = X_TASK_ASSIGNMENT_ID ;
62
63 x_return_status varchar2(1) ;
64 l_msg_count NUMBER;
65 l_msg_data VARCHAR2(2000);
66 l_enable_audit varchar2(5);
67 l_assignee_role jtf_task_all_assignments.assignee_role%TYPE
68 := x_assignee_role;
69 begin
70 if l_assignee_role is null then
71 l_assignee_role := 'ASSIGNEE';
72 end if;
73
74 -- Added by SBARAT on 27/01/2006 for bug# 4661006
75 jtf_task_assignments_pub.p_task_assignments_user_hooks:=NULL;
76
77 jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id:=x_task_assignment_id ;
78 jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id:=x_task_id ;
79 jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code:=x_resource_type_code ;
80 jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id:=x_resource_id ;
81 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_effort:=x_actual_effort ;
82 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_effort_uom:=x_actual_effort_uom ;
83 jtf_task_assignments_pub.p_task_assignments_user_hooks.schedule_flag:=x_schedule_flag ;
84 jtf_task_assignments_pub.p_task_assignments_user_hooks.alarm_type_code:=x_alarm_type_code;
85 jtf_task_assignments_pub.p_task_assignments_user_hooks.alarm_contact:=x_alarm_contact ;
86 jtf_task_assignments_pub.p_task_assignments_user_hooks.sched_travel_distance:=x_sched_travel_distance ;
87 jtf_task_assignments_pub.p_task_assignments_user_hooks.sched_travel_duration:=x_sched_travel_duration ;
88 jtf_task_assignments_pub.p_task_assignments_user_hooks.sched_travel_duration_uom:=x_sched_travel_duration_uom ;
89 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_travel_distance:=x_actual_travel_distance ;
90 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_travel_duration:=x_actual_travel_duration ;
91 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_travel_duration_uom:=x_actual_travel_duration_uom ;
92 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_start_date:=x_actual_start_date ;
93 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_end_date:=x_actual_end_date;
94 jtf_task_assignments_pub.p_task_assignments_user_hooks.palm_flag:=x_palm_flag ;
95 jtf_task_assignments_pub.p_task_assignments_user_hooks.wince_flag:=x_wince_flag ;
96 jtf_task_assignments_pub.p_task_assignments_user_hooks.laptop_flag:=x_laptop_flag ;
97 jtf_task_assignments_pub.p_task_assignments_user_hooks.device1_flag:=x_device1_flag ;
98 jtf_task_assignments_pub.p_task_assignments_user_hooks.device2_flag:=x_device2_flag ;
99 jtf_task_assignments_pub.p_task_assignments_user_hooks.device3_flag:=x_device3_flag ;
100 jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_territory_id:=x_resource_territory_id ;
101 jtf_task_assignments_pub.p_task_assignments_user_hooks.assignment_status_id:=x_assignment_status_id ;
102 jtf_task_assignments_pub.p_task_assignments_user_hooks.shift_construct_id:=x_shift_construct_id ;
103 jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role:=l_assignee_role ;
104
105 -- Added by SBARAT on 22/02/2006 for bug# 4650129
106 jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_start_date:=x_booking_start_date;
107 jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date:=x_booking_end_date;
108
109 jtf_task_assignments_iuhk.create_task_assignment_pre(x_return_status );
110
111 IF NOT (x_return_status = fnd_api.g_ret_sts_success)
112 THEN
113 x_return_status := fnd_api.g_ret_sts_unexp_error;
114 RAISE fnd_api.g_exc_unexpected_error;
115 END IF;
116 l_enable_audit := Upper(nvl(fnd_profile.Value('JTF_TASK_ENABLE_AUDIT'),'Y'));
117 IF(l_enable_audit = 'Y') THEN
118 jtf_task_assignment_audit_pkg.create_task_assignment_audit(
119 p_api_version => 1,
120 p_init_msg_list => fnd_api.g_false,
121 p_commit => fnd_api.g_false,
122 p_object_version_number => 1,
123 p_task_id => x_task_id,
124 p_task_assignment_id => x_task_assignment_id,
125 p_new_resource_type_code => x_resource_type_code,
126 p_new_resource_id => x_resource_id,
127 p_new_assignment_status => x_assignment_status_id,
128 p_new_actual_effort => x_actual_effort,
129 p_new_actual_effort_uom => x_actual_effort_uom,
130 p_new_res_territory_id => x_resource_territory_id,
131 p_new_assignee_role => l_assignee_role,
132 p_new_schedule_flag => x_schedule_flag,
133 p_new_alarm_type => x_alarm_type_code,
134 p_new_alarm_contact => x_alarm_contact,
135 p_new_update_status_flag => null,
136 p_new_show_on_cal_flag => X_SHOW_ON_CALENDAR,
137 p_new_category_id => x_category_id,
138 p_new_free_busy_type => x_free_busy_type,
139 p_new_booking_start_date => x_booking_start_date,
140 p_new_booking_end_date => x_booking_end_date,
141 p_new_actual_travel_distance => x_actual_travel_distance,
142 p_new_actual_travel_duration => x_actual_travel_duration,
143 p_new_actual_travel_DUR_UOM => x_actual_travel_duration_uom,
144 p_new_sched_travel_distance => x_sched_travel_distance,
145 p_new_sched_travel_duration => x_sched_travel_duration,
146 p_new_sched_travel_DUR_UOM => x_sched_travel_duration_uom,
147 p_new_actual_start_date => x_actual_start_date,
148 p_new_actual_end_date => x_actual_end_date,
149 x_return_status => x_return_status,
150 x_msg_count => l_msg_count,
151 x_msg_data => l_msg_data
152 );
153 END IF;
154
155
156 insert into jtf_task_all_assignments (
157 SCHED_TRAVEL_DURATION_UOM,
158 ACTUAL_TRAVEL_DISTANCE,
159 ACTUAL_TRAVEL_DURATION,
160 ACTUAL_TRAVEL_DURATION_UOM,
161 ACTUAL_START_DATE,
162 ACTUAL_END_DATE,
163 PALM_FLAG,
164 WINCE_FLAG,
165 LAPTOP_FLAG,
166 DEVICE1_FLAG,
167 DEVICE2_FLAG,
168 DEVICE3_FLAG,
169 ATTRIBUTE1,
170 ATTRIBUTE2,
171 ATTRIBUTE3,
172 ATTRIBUTE4,
173 ATTRIBUTE5,
174 ATTRIBUTE6,
175 ATTRIBUTE7,
176 ATTRIBUTE8,
177 ATTRIBUTE9,
178 ATTRIBUTE10,
179 ATTRIBUTE11,
180 ATTRIBUTE12,
181 ATTRIBUTE13,
182 ATTRIBUTE14,
183 ATTRIBUTE15,
184 ATTRIBUTE_CATEGORY,
185 TASK_ASSIGNMENT_ID,
186 CREATED_BY,
187 CREATION_DATE,
188 LAST_UPDATED_BY,
189 LAST_UPDATE_DATE,
190 LAST_UPDATE_LOGIN,
191 TASK_ID,
192 RESOURCE_TYPE_CODE,
193 RESOURCE_ID,
194 ACTUAL_EFFORT,
195 ACTUAL_EFFORT_UOM,
196 SCHEDULE_FLAG,
197 ALARM_TYPE_CODE,
198 ALARM_CONTACT,
199 SCHED_TRAVEL_DISTANCE,
200 SCHED_TRAVEL_DURATION,
201 OBJECT_VERSION_NUMBER,
202 RESOURCE_TERRITORY_ID,
203 ASSIGNMENT_STATUS_ID,
204 SHIFT_CONSTRUCT_ID,
205 ASSIGNEE_ROLE,
206 SHOW_ON_CALENDAR,
207 CATEGORY_ID,
208 FREE_BUSY_TYPE,
209 BOOKING_START_DATE,
210 BOOKING_END_DATE,
211 OBJECT_CAPACITY_ID
212 ) values(
213 X_SCHED_TRAVEL_DURATION_UOM,
214 X_ACTUAL_TRAVEL_DISTANCE,
215 X_ACTUAL_TRAVEL_DURATION,
216 X_ACTUAL_TRAVEL_DURATION_UOM,
217 X_ACTUAL_START_DATE,
218 X_ACTUAL_END_DATE,
219 X_PALM_FLAG,
220 X_WINCE_FLAG,
221 X_LAPTOP_FLAG,
222 X_DEVICE1_FLAG,
223 X_DEVICE2_FLAG,
224 X_DEVICE3_FLAG,
225 X_ATTRIBUTE1,
226 X_ATTRIBUTE2,
227 X_ATTRIBUTE3,
228 X_ATTRIBUTE4,
229 X_ATTRIBUTE5,
230 X_ATTRIBUTE6,
231 X_ATTRIBUTE7,
232 X_ATTRIBUTE8,
233 X_ATTRIBUTE9,
234 X_ATTRIBUTE10,
235 X_ATTRIBUTE11,
236 X_ATTRIBUTE12,
237 X_ATTRIBUTE13,
238 X_ATTRIBUTE14,
239 X_ATTRIBUTE15,
240 X_ATTRIBUTE_CATEGORY,
241 X_TASK_ASSIGNMENT_ID,
242 X_CREATED_BY,
243 X_CREATION_DATE,
244 X_LAST_UPDATED_BY,
245 X_LAST_UPDATE_DATE,
246 X_LAST_UPDATE_LOGIN,
247 X_TASK_ID,
248 X_RESOURCE_TYPE_CODE,
249 X_RESOURCE_ID,
250 X_ACTUAL_EFFORT,
251 X_ACTUAL_EFFORT_UOM,
252 X_SCHEDULE_FLAG,
253 X_ALARM_TYPE_CODE,
254 X_ALARM_CONTACT,
255 X_SCHED_TRAVEL_DISTANCE,
256 X_SCHED_TRAVEL_DURATION,
257 1 ,
258 X_RESOURCE_TERRITORY_ID,
259 X_ASSIGNMENT_STATUS_ID,
260 X_SHIFT_CONSTRUCT_ID,
261 L_ASSIGNEE_ROLE,
262 X_SHOW_ON_CALENDAR,
263 X_CATEGORY_ID,
264 X_FREE_BUSY_TYPE,
265 X_BOOKING_START_DATE,
266 X_BOOKING_END_DATE,
267 X_OBJECT_CAPACITY_ID
268 );
269
270 open c;
271 fetch c into X_ROWID;
272 if (c%notfound) then
273 close c;
274 raise no_data_found;
275 end if;
276 close c;
277
278 jtf_task_assignments_iuhk.create_task_assignment_post(x_return_status );
279
280 IF NOT (x_return_status = fnd_api.g_ret_sts_success)
281 THEN
282 x_return_status := fnd_api.g_ret_sts_unexp_error;
283 RAISE fnd_api.g_exc_unexpected_error;
284 END IF;
285
286
287 end INSERT_ROW;
288
289 procedure LOCK_ROW (
290 X_TASK_ASSIGNMENT_ID in NUMBER,
291 X_OBJECT_VERSION_NUMBER in NUMBER
292 ) is
293 cursor c1 is select
294 OBJECT_VERSION_NUMBER
295 from jtf_task_all_assignments
296 where TASK_ASSIGNMENT_ID = X_TASK_ASSIGNMENT_ID
297 for update of TASK_ASSIGNMENT_ID nowait;
298 tlinfo c1%rowtype ;
299
300 begin
301 open c1;
302 fetch c1 into tlinfo;
303 if (c1%notfound) then
304 close c1;
305 fnd_message.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
306 fnd_msg_pub.add;
307 app_exception.raise_exception;
308 end if;
309 close c1;
310
311 if (tlinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER)
312 then
313 null;
314 else
315 fnd_message.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
316 fnd_msg_pub.add;
317 app_exception.raise_exception;
318 end if;
319
320
321 end LOCK_ROW;
322
323 procedure UPDATE_ROW (
324 X_TASK_ASSIGNMENT_ID in NUMBER,
325 X_OBJECT_VERSION_NUMBER in NUMBER,
326 X_SCHED_TRAVEL_DURATION_UOM in VARCHAR2,
327 X_ACTUAL_TRAVEL_DISTANCE in NUMBER,
328 X_ACTUAL_TRAVEL_DURATION in NUMBER,
329 X_ACTUAL_TRAVEL_DURATION_UOM in VARCHAR2,
330 X_ACTUAL_START_DATE in DATE,
331 X_ACTUAL_END_DATE in DATE,
332 X_PALM_FLAG in VARCHAR2,
333 X_WINCE_FLAG in VARCHAR2,
334 X_LAPTOP_FLAG in VARCHAR2,
335 X_DEVICE1_FLAG in VARCHAR2,
336 X_DEVICE2_FLAG in VARCHAR2,
337 X_DEVICE3_FLAG in VARCHAR2,
338 X_ATTRIBUTE1 in VARCHAR2,
339 X_ATTRIBUTE2 in VARCHAR2,
340 X_ATTRIBUTE3 in VARCHAR2,
341 X_ATTRIBUTE4 in VARCHAR2,
342 X_ATTRIBUTE5 in VARCHAR2,
343 X_ATTRIBUTE6 in VARCHAR2,
344 X_ATTRIBUTE7 in VARCHAR2,
345 X_ATTRIBUTE8 in VARCHAR2,
346 X_ATTRIBUTE9 in VARCHAR2,
347 X_ATTRIBUTE10 in VARCHAR2,
348 X_ATTRIBUTE11 in VARCHAR2,
349 X_ATTRIBUTE12 in VARCHAR2,
350 X_ATTRIBUTE13 in VARCHAR2,
351 X_ATTRIBUTE14 in VARCHAR2,
352 X_ATTRIBUTE15 in VARCHAR2,
353 X_ATTRIBUTE_CATEGORY in VARCHAR2,
354 X_TASK_ID in NUMBER,
355 X_RESOURCE_ID in NUMBER,
356 X_ACTUAL_EFFORT in NUMBER,
357 X_ACTUAL_EFFORT_UOM in VARCHAR2,
358 X_SCHEDULE_FLAG in VARCHAR2,
359 X_ALARM_TYPE_CODE in VARCHAR2,
360 X_ALARM_CONTACT in VARCHAR2,
361 X_SCHED_TRAVEL_DISTANCE in NUMBER,
362 X_SCHED_TRAVEL_DURATION in NUMBER,
363 X_RESOURCE_TYPE_CODE in VARCHAR2,
364 X_LAST_UPDATE_DATE in DATE,
365 X_LAST_UPDATED_BY in NUMBER,
366 X_LAST_UPDATE_LOGIN in NUMBER,
367 X_RESOURCE_TERRITORY_ID in NUMBER,
368 X_ASSIGNMENT_STATUS_ID in NUMBER,
369 X_SHIFT_CONSTRUCT_ID in NUMBER,
370 X_ASSIGNEE_ROLE in VARCHAR2,
371 X_SHOW_ON_CALENDAR in VARCHAR2,
372 X_CATEGORY_ID in NUMBER,
373 X_FREE_BUSY_TYPE in VARCHAR2,
374 X_BOOKING_START_DATE in DATE,
375 X_BOOKING_END_DATE in DATE,
376 X_OBJECT_CAPACITY_ID in NUMBER
377 ) is
378 x_return_status varchar2(1);
379 l_msg_count NUMBER;
380 l_msg_data VARCHAR2(2000);
381 l_enable_audit varchar2(5);
382 l_assignee_role jtf_task_all_assignments.assignee_role%TYPE
383 := x_assignee_role;
384 begin
385 if l_assignee_role is null or l_assignee_role = fnd_api.g_miss_char then
386 l_assignee_role := 'ASSIGNEE';
387 end if;
388
389 -- Added by SBARAT on 27/01/2006 for bug# 4661006
390 jtf_task_assignments_pub.p_task_assignments_user_hooks:=NULL;
391
392 jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id:=x_task_assignment_id ;
393 jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id:=x_task_id ;
394 jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code:=x_resource_type_code ;
395 jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id:=x_resource_id ;
396 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_effort:=x_actual_effort ;
397 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_effort_uom:=x_actual_effort_uom ;
398 jtf_task_assignments_pub.p_task_assignments_user_hooks.schedule_flag:=x_schedule_flag ;
399 jtf_task_assignments_pub.p_task_assignments_user_hooks.alarm_type_code:=x_alarm_type_code;
400 jtf_task_assignments_pub.p_task_assignments_user_hooks.alarm_contact:=x_alarm_contact ;
401 jtf_task_assignments_pub.p_task_assignments_user_hooks.sched_travel_distance:=x_sched_travel_distance ;
402 jtf_task_assignments_pub.p_task_assignments_user_hooks.sched_travel_duration:=x_sched_travel_duration ;
403 jtf_task_assignments_pub.p_task_assignments_user_hooks.sched_travel_duration_uom:=x_sched_travel_duration_uom ;
404 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_travel_distance:=x_actual_travel_distance ;
405 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_travel_duration:=x_actual_travel_duration ;
406 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_travel_duration_uom:=x_actual_travel_duration_uom ;
407 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_start_date:=x_actual_start_date ;
408 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_end_date:=x_actual_end_date;
409 jtf_task_assignments_pub.p_task_assignments_user_hooks.palm_flag:=x_palm_flag ;
410 jtf_task_assignments_pub.p_task_assignments_user_hooks.wince_flag:=x_wince_flag ;
411 jtf_task_assignments_pub.p_task_assignments_user_hooks.laptop_flag:=x_laptop_flag ;
412 jtf_task_assignments_pub.p_task_assignments_user_hooks.device1_flag:=x_device1_flag ;
413 jtf_task_assignments_pub.p_task_assignments_user_hooks.device2_flag:=x_device2_flag ;
414 jtf_task_assignments_pub.p_task_assignments_user_hooks.device3_flag:=x_device3_flag ;
415 jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_territory_id:=x_resource_territory_id ;
416 jtf_task_assignments_pub.p_task_assignments_user_hooks.assignment_status_id:=x_assignment_status_id ;
417 jtf_task_assignments_pub.p_task_assignments_user_hooks.shift_construct_id:=x_shift_construct_id ;
418 jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role:=l_assignee_role ;
419
420 -- Added by SBARAT on 22/02/2006 for bug# 4650129
421 jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_start_date:=x_booking_start_date;
422 jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date:=x_booking_end_date;
423
424 jtf_task_assignments_iuhk.update_task_assignment_pre(x_return_status );
425
426 IF NOT (x_return_status = fnd_api.g_ret_sts_success)
427 THEN
428 x_return_status := fnd_api.g_ret_sts_unexp_error;
429 RAISE fnd_api.g_exc_unexpected_error;
430 END IF;
431
432 l_enable_audit := Upper(nvl(fnd_profile.Value('JTF_TASK_ENABLE_AUDIT'),'Y'));
433 IF(l_enable_audit = 'Y') THEN
434 jtf_task_assignment_audit_pkg.create_task_assignment_audit(
435 p_api_version => 1,
436 p_init_msg_list => fnd_api.g_false,
437 p_commit => fnd_api.g_false,
438 p_object_version_number => 1,
439 p_task_id => x_task_id,
440 p_task_assignment_id => x_task_assignment_id,
441 p_new_resource_type_code => x_resource_type_code,
442 p_new_resource_id => x_resource_id,
443 p_new_assignment_status => x_assignment_status_id,
444 p_new_actual_effort => x_actual_effort,
445 p_new_actual_effort_uom => x_actual_effort_uom,
446 p_new_res_territory_id => x_resource_territory_id,
447 p_new_assignee_role => l_assignee_role,
448 p_new_schedule_flag => x_schedule_flag,
449 p_new_alarm_type => x_alarm_type_code,
450 p_new_alarm_contact => x_alarm_contact,
451 p_new_update_status_flag => null,
452 p_new_show_on_cal_flag => X_SHOW_ON_CALENDAR,
453 p_new_category_id => x_category_id,
454 p_new_free_busy_type => x_free_busy_type,
455 p_new_booking_start_date => x_booking_start_date,
456 p_new_booking_end_date => x_booking_end_date,
457 p_new_actual_travel_distance => x_actual_travel_distance,
458 p_new_actual_travel_duration => x_actual_travel_duration,
459 p_new_actual_travel_DUR_UOM => x_actual_travel_duration_uom,
460 p_new_sched_travel_distance => x_sched_travel_distance,
461 p_new_sched_travel_duration => x_sched_travel_duration,
462 p_new_sched_travel_DUR_UOM => x_sched_travel_duration_uom,
463 p_new_actual_start_date => x_actual_start_date,
464 p_new_actual_end_date => x_actual_end_date,
465 x_return_status => x_return_status,
466 x_msg_count => l_msg_count,
467 x_msg_data => l_msg_data
468 );
469 END IF;
470
471
472 update jtf_task_all_assignments set
473 SCHED_TRAVEL_DURATION_UOM = X_SCHED_TRAVEL_DURATION_UOM,
474 OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
475 ACTUAL_TRAVEL_DISTANCE = X_ACTUAL_TRAVEL_DISTANCE,
476 ACTUAL_TRAVEL_DURATION = X_ACTUAL_TRAVEL_DURATION,
477 ACTUAL_TRAVEL_DURATION_UOM = X_ACTUAL_TRAVEL_DURATION_UOM,
478 ACTUAL_START_DATE = X_ACTUAL_START_DATE,
479 ACTUAL_END_DATE = X_ACTUAL_END_DATE,
480 PALM_FLAG = X_PALM_FLAG,
481 WINCE_FLAG = X_WINCE_FLAG,
482 LAPTOP_FLAG = X_LAPTOP_FLAG,
483 DEVICE1_FLAG = X_DEVICE1_FLAG,
484 DEVICE2_FLAG = X_DEVICE2_FLAG,
485 DEVICE3_FLAG = X_DEVICE3_FLAG,
486 ATTRIBUTE1 = X_ATTRIBUTE1,
487 ATTRIBUTE2 = X_ATTRIBUTE2,
488 ATTRIBUTE3 = X_ATTRIBUTE3,
489 ATTRIBUTE4 = X_ATTRIBUTE4,
490 ATTRIBUTE5 = X_ATTRIBUTE5,
491 ATTRIBUTE6 = X_ATTRIBUTE6,
492 ATTRIBUTE7 = X_ATTRIBUTE7,
493 ATTRIBUTE8 = X_ATTRIBUTE8,
494 ATTRIBUTE9 = X_ATTRIBUTE9,
495 ATTRIBUTE10 = X_ATTRIBUTE10,
496 ATTRIBUTE11 = X_ATTRIBUTE11,
497 ATTRIBUTE12 = X_ATTRIBUTE12,
498 ATTRIBUTE13 = X_ATTRIBUTE13,
499 ATTRIBUTE14 = X_ATTRIBUTE14,
500 ATTRIBUTE15 = X_ATTRIBUTE15,
501 ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
502 TASK_ID = X_TASK_ID,
503 RESOURCE_ID = X_RESOURCE_ID,
504 ACTUAL_EFFORT = X_ACTUAL_EFFORT,
505 ACTUAL_EFFORT_UOM = X_ACTUAL_EFFORT_UOM,
506 SCHEDULE_FLAG = X_SCHEDULE_FLAG,
507 ALARM_TYPE_CODE = X_ALARM_TYPE_CODE,
508 ALARM_CONTACT = X_ALARM_CONTACT,
509 SCHED_TRAVEL_DISTANCE = X_SCHED_TRAVEL_DISTANCE,
510 SCHED_TRAVEL_DURATION = X_SCHED_TRAVEL_DURATION,
511 RESOURCE_TYPE_CODE = X_RESOURCE_TYPE_CODE,
512 LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
513 LAST_UPDATED_BY = X_LAST_UPDATED_BY,
514 LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
515 RESOURCE_TERRITORY_ID = X_RESOURCE_TERRITORY_ID,
516 ASSIGNMENT_STATUS_ID = X_ASSIGNMENT_STATUS_ID,
517 SHIFT_CONSTRUCT_ID = X_SHIFT_CONSTRUCT_ID,
518 ASSIGNEE_ROLE = L_ASSIGNEE_ROLE,
519 SHOW_ON_CALENDAR = decode(X_SHOW_ON_CALENDAR,fnd_api.g_miss_char,SHOW_ON_CALENDAR,X_SHOW_ON_CALENDAR),
520 CATEGORY_ID = decode(X_CATEGORY_ID ,fnd_api.g_miss_num,category_id,x_category_id ),
521 FREE_BUSY_TYPE = X_FREE_BUSY_TYPE,
522 BOOKING_START_DATE = X_BOOKING_START_DATE,
523 BOOKING_END_DATE = X_BOOKING_END_DATE,
524 OBJECT_CAPACITY_ID = X_OBJECT_CAPACITY_ID
525 where TASK_ASSIGNMENT_ID = X_TASK_ASSIGNMENT_ID ;
526
527 if (sql%notfound) then
528 raise no_data_found;
529 end if;
530
531 jtf_task_assignments_iuhk.update_task_assignment_post(x_return_status );
532
533 IF NOT (x_return_status = fnd_api.g_ret_sts_success)
534 THEN
535 x_return_status := fnd_api.g_ret_sts_unexp_error;
536 RAISE fnd_api.g_exc_unexpected_error;
537 END IF;
538
539
540 end UPDATE_ROW;
541
542 procedure DELETE_ROW (
543 X_TASK_ASSIGNMENT_ID in NUMBER
544 ) is
545 x_return_status varchar2(1);
546 l_enable_audit varchar2(5);
547 begin
548
549 -- Added by SBARAT on 27/01/2006 for bug# 4661006
550 jtf_task_assignments_pub.p_task_assignments_user_hooks:=NULL;
551
552 jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id:=x_task_assignment_id ;
553 jtf_task_assignments_iuhk.delete_task_assignment_pre(x_return_status );
554 IF NOT (x_return_status = fnd_api.g_ret_sts_success)
555 THEN
556 x_return_status := fnd_api.g_ret_sts_unexp_error;
557 RAISE fnd_api.g_exc_unexpected_error;
558 END IF;
559 delete from jtf_task_all_assignments
560 where TASK_ASSIGNMENT_ID = X_TASK_ASSIGNMENT_ID ;
561
562 if (sql%notfound) then
563 raise no_data_found;
564 end if;
565
566 l_enable_audit := Upper(nvl(fnd_profile.Value('JTF_TASK_ENABLE_AUDIT'),'Y'));
567 IF(l_enable_audit = 'Y') THEN
568 jtf_task_assignment_audit_pkg.DELETE_ROW(
569 X_ASSIGNMENT_ID =>x_task_assignment_id
570 );
571 END IF;
572
573 jtf_task_assignments_iuhk.delete_task_assignment_post(x_return_status );
574 IF NOT (x_return_status = fnd_api.g_ret_sts_success)
575 THEN
576 x_return_status := fnd_api.g_ret_sts_unexp_error;
577 RAISE fnd_api.g_exc_unexpected_error;
578 END IF;
579
580 end DELETE_ROW;
581 end ;