eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.JTF_TASK_ASSIGNMENTS_PKG

Source


1 PACKAGE body JTF_TASK_ASSIGNMENTS_PKG as
2 /* $Header: jtftkasb.pls 120.3 2006/02/22 00:28:09 sbarat 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_assignee_role            jtf_task_all_assignments.assignee_role%TYPE
65                := x_assignee_role;
66 begin
67 if l_assignee_role is null then
68    l_assignee_role := 'ASSIGNEE';
69 end if;
70 
71 -- Added by SBARAT on 27/01/2006 for bug# 4661006
72 jtf_task_assignments_pub.p_task_assignments_user_hooks:=NULL;
73 
74 jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id:=x_task_assignment_id ;
75 jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id:=x_task_id ;
76 jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code:=x_resource_type_code ;
77 jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id:=x_resource_id ;
78 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_effort:=x_actual_effort ;
79 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_effort_uom:=x_actual_effort_uom ;
80 jtf_task_assignments_pub.p_task_assignments_user_hooks.schedule_flag:=x_schedule_flag ;
81 jtf_task_assignments_pub.p_task_assignments_user_hooks.alarm_type_code:=x_alarm_type_code;
82 jtf_task_assignments_pub.p_task_assignments_user_hooks.alarm_contact:=x_alarm_contact ;
83 jtf_task_assignments_pub.p_task_assignments_user_hooks.sched_travel_distance:=x_sched_travel_distance ;
84 jtf_task_assignments_pub.p_task_assignments_user_hooks.sched_travel_duration:=x_sched_travel_duration ;
85 jtf_task_assignments_pub.p_task_assignments_user_hooks.sched_travel_duration_uom:=x_sched_travel_duration_uom ;
86 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_travel_distance:=x_actual_travel_distance ;
87 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_travel_duration:=x_actual_travel_duration ;
88 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_travel_duration_uom:=x_actual_travel_duration_uom ;
89 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_start_date:=x_actual_start_date ;
90 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_end_date:=x_actual_end_date;
91 jtf_task_assignments_pub.p_task_assignments_user_hooks.palm_flag:=x_palm_flag ;
92 jtf_task_assignments_pub.p_task_assignments_user_hooks.wince_flag:=x_wince_flag ;
93 jtf_task_assignments_pub.p_task_assignments_user_hooks.laptop_flag:=x_laptop_flag ;
94 jtf_task_assignments_pub.p_task_assignments_user_hooks.device1_flag:=x_device1_flag ;
95 jtf_task_assignments_pub.p_task_assignments_user_hooks.device2_flag:=x_device2_flag ;
96 jtf_task_assignments_pub.p_task_assignments_user_hooks.device3_flag:=x_device3_flag ;
97 jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_territory_id:=x_resource_territory_id ;
98 jtf_task_assignments_pub.p_task_assignments_user_hooks.assignment_status_id:=x_assignment_status_id ;
99 jtf_task_assignments_pub.p_task_assignments_user_hooks.shift_construct_id:=x_shift_construct_id ;
100 jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role:=l_assignee_role ;
101 
102 -- Added by SBARAT on 22/02/2006 for bug# 4650129
103 jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_start_date:=x_booking_start_date;
104 jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date:=x_booking_end_date;
105 
106 jtf_task_assignments_iuhk.create_task_assignment_pre(x_return_status );
107 
108       IF NOT (x_return_status = fnd_api.g_ret_sts_success)
109       THEN
110          x_return_status := fnd_api.g_ret_sts_unexp_error;
111          RAISE fnd_api.g_exc_unexpected_error;
112       END IF;
113 
114 
115 
116 
117   insert into jtf_task_all_assignments (
118     SCHED_TRAVEL_DURATION_UOM,
119     ACTUAL_TRAVEL_DISTANCE,
120     ACTUAL_TRAVEL_DURATION,
121     ACTUAL_TRAVEL_DURATION_UOM,
122     ACTUAL_START_DATE,
123     ACTUAL_END_DATE,
124     PALM_FLAG,
125     WINCE_FLAG,
126     LAPTOP_FLAG,
127     DEVICE1_FLAG,
128     DEVICE2_FLAG,
129     DEVICE3_FLAG,
130     ATTRIBUTE1,
131     ATTRIBUTE2,
132     ATTRIBUTE3,
133     ATTRIBUTE4,
134     ATTRIBUTE5,
135     ATTRIBUTE6,
136     ATTRIBUTE7,
137     ATTRIBUTE8,
138     ATTRIBUTE9,
139     ATTRIBUTE10,
140     ATTRIBUTE11,
141     ATTRIBUTE12,
142     ATTRIBUTE13,
143     ATTRIBUTE14,
144     ATTRIBUTE15,
145     ATTRIBUTE_CATEGORY,
146     TASK_ASSIGNMENT_ID,
147     CREATED_BY,
148     CREATION_DATE,
149     LAST_UPDATED_BY,
150     LAST_UPDATE_DATE,
151     LAST_UPDATE_LOGIN,
152     TASK_ID,
153     RESOURCE_TYPE_CODE,
154     RESOURCE_ID,
155     ACTUAL_EFFORT,
156     ACTUAL_EFFORT_UOM,
157     SCHEDULE_FLAG,
158     ALARM_TYPE_CODE,
159     ALARM_CONTACT,
160     SCHED_TRAVEL_DISTANCE,
161     SCHED_TRAVEL_DURATION,
162     OBJECT_VERSION_NUMBER,
163     RESOURCE_TERRITORY_ID,
164     ASSIGNMENT_STATUS_ID,
165     SHIFT_CONSTRUCT_ID,
166     ASSIGNEE_ROLE,
167     SHOW_ON_CALENDAR,
168     CATEGORY_ID,
169     FREE_BUSY_TYPE,
170     BOOKING_START_DATE,
171     BOOKING_END_DATE,
172     OBJECT_CAPACITY_ID
173  ) values(
174     X_SCHED_TRAVEL_DURATION_UOM,
175     X_ACTUAL_TRAVEL_DISTANCE,
176     X_ACTUAL_TRAVEL_DURATION,
177     X_ACTUAL_TRAVEL_DURATION_UOM,
178     X_ACTUAL_START_DATE,
179     X_ACTUAL_END_DATE,
180     X_PALM_FLAG,
181     X_WINCE_FLAG,
182     X_LAPTOP_FLAG,
183     X_DEVICE1_FLAG,
184     X_DEVICE2_FLAG,
185     X_DEVICE3_FLAG,
186     X_ATTRIBUTE1,
187     X_ATTRIBUTE2,
188     X_ATTRIBUTE3,
189     X_ATTRIBUTE4,
190     X_ATTRIBUTE5,
191     X_ATTRIBUTE6,
192     X_ATTRIBUTE7,
193     X_ATTRIBUTE8,
194     X_ATTRIBUTE9,
195     X_ATTRIBUTE10,
196     X_ATTRIBUTE11,
197     X_ATTRIBUTE12,
198     X_ATTRIBUTE13,
199     X_ATTRIBUTE14,
200     X_ATTRIBUTE15,
201     X_ATTRIBUTE_CATEGORY,
202     X_TASK_ASSIGNMENT_ID,
203     X_CREATED_BY,
204     X_CREATION_DATE,
205     X_LAST_UPDATED_BY,
206     X_LAST_UPDATE_DATE,
207     X_LAST_UPDATE_LOGIN,
208     X_TASK_ID,
209     X_RESOURCE_TYPE_CODE,
210     X_RESOURCE_ID,
211     X_ACTUAL_EFFORT,
212     X_ACTUAL_EFFORT_UOM,
213     X_SCHEDULE_FLAG,
214     X_ALARM_TYPE_CODE,
215     X_ALARM_CONTACT,
216     X_SCHED_TRAVEL_DISTANCE,
217     X_SCHED_TRAVEL_DURATION,
218     1 ,
219     X_RESOURCE_TERRITORY_ID,
220     X_ASSIGNMENT_STATUS_ID,
221     X_SHIFT_CONSTRUCT_ID,
222     L_ASSIGNEE_ROLE,
223     X_SHOW_ON_CALENDAR,
224     X_CATEGORY_ID,
225     X_FREE_BUSY_TYPE,
226     X_BOOKING_START_DATE,
227     X_BOOKING_END_DATE,
228     X_OBJECT_CAPACITY_ID
229     );
230 
231   open c;
232   fetch c into X_ROWID;
233   if (c%notfound) then
234     close c;
235     raise no_data_found;
236   end if;
237   close c;
238 
239 jtf_task_assignments_iuhk.create_task_assignment_post(x_return_status );
240 
241   IF NOT (x_return_status = fnd_api.g_ret_sts_success)
242   THEN
243      x_return_status := fnd_api.g_ret_sts_unexp_error;
244      RAISE fnd_api.g_exc_unexpected_error;
245   END IF;
246 
247 
248 end INSERT_ROW;
249 
250 procedure LOCK_ROW (
251   X_TASK_ASSIGNMENT_ID in NUMBER,
252   X_OBJECT_VERSION_NUMBER in NUMBER
253 ) is
254   cursor c1 is select
255         OBJECT_VERSION_NUMBER
256     from jtf_task_all_assignments
257     where TASK_ASSIGNMENT_ID = X_TASK_ASSIGNMENT_ID
258     for update of TASK_ASSIGNMENT_ID nowait;
259     tlinfo c1%rowtype ;
260 
261 begin
262 	open c1;
263 	fetch c1 into tlinfo;
264 	if (c1%notfound) then
265 		close c1;
266 		fnd_message.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
267 		fnd_msg_pub.add;
268 		app_exception.raise_exception;
269 	 end if;
270 	 close c1;
271 
272   if (tlinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER)
273   then
274     null;
275   else
276     fnd_message.set_name('JTF', 'JTF_API_RECORD_NOT_FOUND');
277     fnd_msg_pub.add;
278     app_exception.raise_exception;
279   end if;
280 
281 
282 end LOCK_ROW;
283 
284 procedure UPDATE_ROW (
285   X_TASK_ASSIGNMENT_ID in NUMBER,
286   X_OBJECT_VERSION_NUMBER in NUMBER,
287   X_SCHED_TRAVEL_DURATION_UOM in VARCHAR2,
288   X_ACTUAL_TRAVEL_DISTANCE in NUMBER,
289   X_ACTUAL_TRAVEL_DURATION in NUMBER,
290   X_ACTUAL_TRAVEL_DURATION_UOM in VARCHAR2,
291   X_ACTUAL_START_DATE in DATE,
292   X_ACTUAL_END_DATE in DATE,
293   X_PALM_FLAG in VARCHAR2,
294   X_WINCE_FLAG in VARCHAR2,
295   X_LAPTOP_FLAG in VARCHAR2,
296   X_DEVICE1_FLAG in VARCHAR2,
297   X_DEVICE2_FLAG in VARCHAR2,
298   X_DEVICE3_FLAG in VARCHAR2,
299   X_ATTRIBUTE1 in VARCHAR2,
300   X_ATTRIBUTE2 in VARCHAR2,
301   X_ATTRIBUTE3 in VARCHAR2,
302   X_ATTRIBUTE4 in VARCHAR2,
303   X_ATTRIBUTE5 in VARCHAR2,
304   X_ATTRIBUTE6 in VARCHAR2,
305   X_ATTRIBUTE7 in VARCHAR2,
306   X_ATTRIBUTE8 in VARCHAR2,
307   X_ATTRIBUTE9 in VARCHAR2,
308   X_ATTRIBUTE10 in VARCHAR2,
309   X_ATTRIBUTE11 in VARCHAR2,
310   X_ATTRIBUTE12 in VARCHAR2,
311   X_ATTRIBUTE13 in VARCHAR2,
312   X_ATTRIBUTE14 in VARCHAR2,
313   X_ATTRIBUTE15 in VARCHAR2,
314   X_ATTRIBUTE_CATEGORY in VARCHAR2,
315   X_TASK_ID in NUMBER,
316   X_RESOURCE_ID in NUMBER,
317   X_ACTUAL_EFFORT in NUMBER,
318   X_ACTUAL_EFFORT_UOM in VARCHAR2,
319   X_SCHEDULE_FLAG in VARCHAR2,
320   X_ALARM_TYPE_CODE in VARCHAR2,
321   X_ALARM_CONTACT in VARCHAR2,
322   X_SCHED_TRAVEL_DISTANCE in NUMBER,
323   X_SCHED_TRAVEL_DURATION in NUMBER,
324   X_RESOURCE_TYPE_CODE in VARCHAR2,
325   X_LAST_UPDATE_DATE in DATE,
326   X_LAST_UPDATED_BY in NUMBER,
327   X_LAST_UPDATE_LOGIN in NUMBER,
328   X_RESOURCE_TERRITORY_ID in NUMBER,
329   X_ASSIGNMENT_STATUS_ID in NUMBER,
330   X_SHIFT_CONSTRUCT_ID in NUMBER,
331   X_ASSIGNEE_ROLE in VARCHAR2,
332   X_SHOW_ON_CALENDAR in VARCHAR2,
333   X_CATEGORY_ID in NUMBER,
334   X_FREE_BUSY_TYPE in VARCHAR2,
335   X_BOOKING_START_DATE in DATE,
336   X_BOOKING_END_DATE in DATE,
337   X_OBJECT_CAPACITY_ID in NUMBER
338   ) is
339 x_return_status         varchar2(1);
340 l_assignee_role            jtf_task_all_assignments.assignee_role%TYPE
341                := x_assignee_role;
342 begin
343 if l_assignee_role is null or l_assignee_role = fnd_api.g_miss_char then
344    l_assignee_role := 'ASSIGNEE';
345 end if;
346 
347 -- Added by SBARAT on 27/01/2006 for bug# 4661006
348 jtf_task_assignments_pub.p_task_assignments_user_hooks:=NULL;
349 
350 jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id:=x_task_assignment_id ;
351 jtf_task_assignments_pub.p_task_assignments_user_hooks.task_id:=x_task_id ;
352 jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_type_code:=x_resource_type_code ;
353 jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_id:=x_resource_id ;
354 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_effort:=x_actual_effort ;
355 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_effort_uom:=x_actual_effort_uom ;
356 jtf_task_assignments_pub.p_task_assignments_user_hooks.schedule_flag:=x_schedule_flag ;
357 jtf_task_assignments_pub.p_task_assignments_user_hooks.alarm_type_code:=x_alarm_type_code;
358 jtf_task_assignments_pub.p_task_assignments_user_hooks.alarm_contact:=x_alarm_contact ;
359 jtf_task_assignments_pub.p_task_assignments_user_hooks.sched_travel_distance:=x_sched_travel_distance ;
360 jtf_task_assignments_pub.p_task_assignments_user_hooks.sched_travel_duration:=x_sched_travel_duration ;
361 jtf_task_assignments_pub.p_task_assignments_user_hooks.sched_travel_duration_uom:=x_sched_travel_duration_uom ;
362 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_travel_distance:=x_actual_travel_distance ;
363 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_travel_duration:=x_actual_travel_duration ;
364 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_travel_duration_uom:=x_actual_travel_duration_uom ;
365 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_start_date:=x_actual_start_date ;
366 jtf_task_assignments_pub.p_task_assignments_user_hooks.actual_end_date:=x_actual_end_date;
367 jtf_task_assignments_pub.p_task_assignments_user_hooks.palm_flag:=x_palm_flag ;
368 jtf_task_assignments_pub.p_task_assignments_user_hooks.wince_flag:=x_wince_flag ;
369 jtf_task_assignments_pub.p_task_assignments_user_hooks.laptop_flag:=x_laptop_flag ;
370 jtf_task_assignments_pub.p_task_assignments_user_hooks.device1_flag:=x_device1_flag ;
371 jtf_task_assignments_pub.p_task_assignments_user_hooks.device2_flag:=x_device2_flag ;
372 jtf_task_assignments_pub.p_task_assignments_user_hooks.device3_flag:=x_device3_flag ;
373 jtf_task_assignments_pub.p_task_assignments_user_hooks.resource_territory_id:=x_resource_territory_id ;
374 jtf_task_assignments_pub.p_task_assignments_user_hooks.assignment_status_id:=x_assignment_status_id ;
375 jtf_task_assignments_pub.p_task_assignments_user_hooks.shift_construct_id:=x_shift_construct_id ;
376 jtf_task_assignments_pub.p_task_assignments_user_hooks.assignee_role:=l_assignee_role ;
377 
378 -- Added by SBARAT on 22/02/2006 for bug# 4650129
379 jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_start_date:=x_booking_start_date;
380 jtf_task_assignments_pub.p_task_assignments_user_hooks.booking_end_date:=x_booking_end_date;
381 
382 jtf_task_assignments_iuhk.update_task_assignment_pre(x_return_status );
383 
384       IF NOT (x_return_status = fnd_api.g_ret_sts_success)
385       THEN
386          x_return_status := fnd_api.g_ret_sts_unexp_error;
387          RAISE fnd_api.g_exc_unexpected_error;
388       END IF;
389 
390   update jtf_task_all_assignments set
391     SCHED_TRAVEL_DURATION_UOM = X_SCHED_TRAVEL_DURATION_UOM,
392     OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
393     ACTUAL_TRAVEL_DISTANCE = X_ACTUAL_TRAVEL_DISTANCE,
394     ACTUAL_TRAVEL_DURATION = X_ACTUAL_TRAVEL_DURATION,
395     ACTUAL_TRAVEL_DURATION_UOM = X_ACTUAL_TRAVEL_DURATION_UOM,
396     ACTUAL_START_DATE = X_ACTUAL_START_DATE,
397     ACTUAL_END_DATE = X_ACTUAL_END_DATE,
398     PALM_FLAG = X_PALM_FLAG,
399     WINCE_FLAG = X_WINCE_FLAG,
400     LAPTOP_FLAG = X_LAPTOP_FLAG,
401     DEVICE1_FLAG = X_DEVICE1_FLAG,
402     DEVICE2_FLAG = X_DEVICE2_FLAG,
403     DEVICE3_FLAG = X_DEVICE3_FLAG,
404     ATTRIBUTE1 = X_ATTRIBUTE1,
405     ATTRIBUTE2 = X_ATTRIBUTE2,
406     ATTRIBUTE3 = X_ATTRIBUTE3,
407     ATTRIBUTE4 = X_ATTRIBUTE4,
408     ATTRIBUTE5 = X_ATTRIBUTE5,
409     ATTRIBUTE6 = X_ATTRIBUTE6,
410     ATTRIBUTE7 = X_ATTRIBUTE7,
411     ATTRIBUTE8 = X_ATTRIBUTE8,
412     ATTRIBUTE9 = X_ATTRIBUTE9,
413     ATTRIBUTE10 = X_ATTRIBUTE10,
414     ATTRIBUTE11 = X_ATTRIBUTE11,
415     ATTRIBUTE12 = X_ATTRIBUTE12,
416     ATTRIBUTE13 = X_ATTRIBUTE13,
417     ATTRIBUTE14 = X_ATTRIBUTE14,
418     ATTRIBUTE15 = X_ATTRIBUTE15,
419     ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
420     TASK_ID = X_TASK_ID,
421     RESOURCE_ID = X_RESOURCE_ID,
422     ACTUAL_EFFORT = X_ACTUAL_EFFORT,
423     ACTUAL_EFFORT_UOM = X_ACTUAL_EFFORT_UOM,
424     SCHEDULE_FLAG = X_SCHEDULE_FLAG,
425     ALARM_TYPE_CODE = X_ALARM_TYPE_CODE,
426     ALARM_CONTACT = X_ALARM_CONTACT,
427     SCHED_TRAVEL_DISTANCE = X_SCHED_TRAVEL_DISTANCE,
428     SCHED_TRAVEL_DURATION = X_SCHED_TRAVEL_DURATION,
429     RESOURCE_TYPE_CODE = X_RESOURCE_TYPE_CODE,
430     LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
431     LAST_UPDATED_BY = X_LAST_UPDATED_BY,
432     LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
433     RESOURCE_TERRITORY_ID = X_RESOURCE_TERRITORY_ID,
434     ASSIGNMENT_STATUS_ID = X_ASSIGNMENT_STATUS_ID,
435     SHIFT_CONSTRUCT_ID  = X_SHIFT_CONSTRUCT_ID,
436     ASSIGNEE_ROLE = L_ASSIGNEE_ROLE,
437     SHOW_ON_CALENDAR = decode(X_SHOW_ON_CALENDAR,fnd_api.g_miss_char,SHOW_ON_CALENDAR,X_SHOW_ON_CALENDAR),
438     CATEGORY_ID = decode(X_CATEGORY_ID ,fnd_api.g_miss_num,category_id,x_category_id ),
439     FREE_BUSY_TYPE = X_FREE_BUSY_TYPE,
440     BOOKING_START_DATE = X_BOOKING_START_DATE,
441     BOOKING_END_DATE  = X_BOOKING_END_DATE,
442     OBJECT_CAPACITY_ID = X_OBJECT_CAPACITY_ID
443   where TASK_ASSIGNMENT_ID = X_TASK_ASSIGNMENT_ID ;
444 
445   if (sql%notfound) then
446     raise no_data_found;
447   end if;
448 
449 jtf_task_assignments_iuhk.update_task_assignment_post(x_return_status );
450 
451       IF NOT (x_return_status = fnd_api.g_ret_sts_success)
452       THEN
453          x_return_status := fnd_api.g_ret_sts_unexp_error;
454          RAISE fnd_api.g_exc_unexpected_error;
455       END IF;
456 
457 
458 end UPDATE_ROW;
459 
460 procedure DELETE_ROW (
461   X_TASK_ASSIGNMENT_ID in NUMBER
462 ) is
463 x_return_status         varchar2(1);
464 begin
465 
466 -- Added by SBARAT on 27/01/2006 for bug# 4661006
467 jtf_task_assignments_pub.p_task_assignments_user_hooks:=NULL;
468 
469   jtf_task_assignments_pub.p_task_assignments_user_hooks.task_assignment_id:=x_task_assignment_id ;
470   jtf_task_assignments_iuhk.delete_task_assignment_pre(x_return_status );
471         IF NOT (x_return_status = fnd_api.g_ret_sts_success)
472       THEN
473          x_return_status := fnd_api.g_ret_sts_unexp_error;
474          RAISE fnd_api.g_exc_unexpected_error;
475       END IF;
476   delete from jtf_task_all_assignments
477   where TASK_ASSIGNMENT_ID = X_TASK_ASSIGNMENT_ID ;
478 
479   if (sql%notfound) then
480     raise no_data_found;
481   end if;
482   jtf_task_assignments_iuhk.delete_task_assignment_post(x_return_status );
483     IF NOT (x_return_status = fnd_api.g_ret_sts_success)
484       THEN
485          x_return_status := fnd_api.g_ret_sts_unexp_error;
486          RAISE fnd_api.g_exc_unexpected_error;
487       END IF;
488 
489 end DELETE_ROW;
490 end ;