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_STATUSES_PKG

Source


1 PACKAGE body JTF_TASK_STATUSES_PKG as
2 /* $Header: jtftkstb.pls 120.2 2006/05/30 13:17:01 sbarat ship $ */
3 procedure INSERT_ROW(
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_TASK_STATUS_ID in NUMBER,
6   X_CLOSED_FLAG in VARCHAR2,
7   X_START_DATE_ACTIVE in DATE,
8   X_END_DATE_ACTIVE in DATE,
9   X_SEEDED_FLAG in VARCHAR2,
10   X_ASSIGNED_FLAG in VARCHAR2,
11   X_WORKING_FLAG in VARCHAR2,
12   X_APPROVED_FLAG in VARCHAR2,
13   X_COMPLETED_FLAG in VARCHAR2,
14   X_CANCELLED_FLAG in VARCHAR2,
15   X_REJECTED_FLAG in VARCHAR2,
16   X_ACCEPTED_FLAG in VARCHAR2,
17   X_ON_HOLD_FLAG in VARCHAR2,
18   X_SCHEDULABLE_FLAG in VARCHAR2,
19   X_DELETE_ALLOWED_FLAG in VARCHAR2,
20   X_ATTRIBUTE1 in VARCHAR2,
21   X_ATTRIBUTE2 in VARCHAR2,
22   X_ATTRIBUTE3 in VARCHAR2,
23   X_ATTRIBUTE4 in VARCHAR2,
24   X_ATTRIBUTE5 in VARCHAR2,
25   X_ATTRIBUTE6 in VARCHAR2,
26   X_ATTRIBUTE7 in VARCHAR2,
27   X_ATTRIBUTE8 in VARCHAR2,
28   X_ATTRIBUTE9 in VARCHAR2,
29   X_ATTRIBUTE10 in VARCHAR2,
30   X_ATTRIBUTE11 in VARCHAR2,
31   X_ATTRIBUTE12 in VARCHAR2,
32   X_ATTRIBUTE13 in VARCHAR2,
33   X_ATTRIBUTE14 in VARCHAR2,
34   X_ATTRIBUTE15 in VARCHAR2,
35   X_ATTRIBUTE_CATEGORY in VARCHAR2,
36   X_NAME in VARCHAR2,
37   X_DESCRIPTION in VARCHAR2,
38   X_CREATION_DATE in DATE,
39   X_CREATED_BY in NUMBER,
40   X_LAST_UPDATE_DATE in DATE,
41   X_LAST_UPDATED_BY in NUMBER,
42   X_LAST_UPDATE_LOGIN in NUMBER,
43 --  X_UPDATE in VARCHAR2,
44   X_USAGE in VARCHAR2,
45   X_TASK_STATUS_FLAG in VARCHAR2,
46   X_ASSIGNMENT_STATUS_FLAG in VARCHAR2,
47   X_START_DATE_TYPE IN VARCHAR2,
48   X_END_DATE_TYPE IN VARCHAR2
49 ) is
50   cursor C is select ROWID from JTF_TASK_STATUSES_B
51     where TASK_STATUS_ID = X_TASK_STATUS_ID
52     ;
53 begin
54   insert into JTF_TASK_STATUSES_B (
55     TASK_STATUS_ID,
56     CLOSED_FLAG,
57     START_DATE_ACTIVE,
58     END_DATE_ACTIVE,
59     SEEDED_FLAG,
60     ASSIGNED_FLAG,
61     WORKING_FLAG,
62     APPROVED_FLAG,
63     COMPLETED_FLAG,
64     CANCELLED_FLAG,
65     REJECTED_FLAG,
66     ACCEPTED_FLAG,
67     ON_HOLD_FLAG,
68     SCHEDULABLE_FLAG,
69     DELETE_ALLOWED_FLAG,
70     ATTRIBUTE1,
71     ATTRIBUTE2,
72     ATTRIBUTE3,
73     ATTRIBUTE4,
74     ATTRIBUTE5,
75     ATTRIBUTE6,
76     ATTRIBUTE7,
77     ATTRIBUTE8,
78     ATTRIBUTE9,
79     ATTRIBUTE10,
80     ATTRIBUTE11,
81     ATTRIBUTE12,
82     ATTRIBUTE13,
83     ATTRIBUTE14,
84     ATTRIBUTE15,
85     ATTRIBUTE_CATEGORY,
86     CREATION_DATE,
87     CREATED_BY,
88     LAST_UPDATE_DATE,
89     LAST_UPDATED_BY,
90     LAST_UPDATE_LOGIN,
91     OBJECT_VERSION_NUMBER,
92     USAGE,
93     TASK_STATUS_FLAG,
94     ASSIGNMENT_STATUS_FLAG,
95     START_DATE_TYPE,
96     END_DATE_TYPE
97   ) values (
98     X_TASK_STATUS_ID,
99     X_CLOSED_FLAG,
100     X_START_DATE_ACTIVE,
101     X_END_DATE_ACTIVE,
102     X_SEEDED_FLAG,
103     X_ASSIGNED_FLAG,
104     X_WORKING_FLAG,
105     X_APPROVED_FLAG,
106     X_COMPLETED_FLAG,
107     X_CANCELLED_FLAG,
108     X_REJECTED_FLAG,
109     X_ACCEPTED_FLAG,
110     X_ON_HOLD_FLAG,
111     X_SCHEDULABLE_FLAG,
112     X_DELETE_ALLOWED_FLAG,
113     X_ATTRIBUTE1,
114     X_ATTRIBUTE2,
115     X_ATTRIBUTE3,
116     X_ATTRIBUTE4,
117     X_ATTRIBUTE5,
118     X_ATTRIBUTE6,
119     X_ATTRIBUTE7,
120     X_ATTRIBUTE8,
121     X_ATTRIBUTE9,
122     X_ATTRIBUTE10,
123     X_ATTRIBUTE11,
124     X_ATTRIBUTE12,
125     X_ATTRIBUTE13,
126     X_ATTRIBUTE14,
127     X_ATTRIBUTE15,
128     X_ATTRIBUTE_CATEGORY,
129     X_CREATION_DATE,
130     X_CREATED_BY,
131     X_LAST_UPDATE_DATE,
132     X_LAST_UPDATED_BY,
133     X_LAST_UPDATE_LOGIN,
134     1,
135     X_USAGE,
136     X_TASK_STATUS_FLAG,
137     X_ASSIGNMENT_STATUS_FLAG,
138     X_START_DATE_TYPE,
139     X_END_DATE_TYPE
140   );
141 
142   insert into JTF_TASK_STATUSES_TL (
143     TASK_STATUS_ID,
144     NAME,
145     DESCRIPTION,
146     CREATED_BY,
147     CREATION_DATE,
148     LAST_UPDATED_BY,
149     LAST_UPDATE_DATE,
150     LAST_UPDATE_LOGIN,
151     LANGUAGE,
152     SOURCE_LANG
153   ) select
154     X_TASK_STATUS_ID,
155     X_NAME,
156     X_DESCRIPTION,
157     X_CREATED_BY,
158     X_CREATION_DATE,
159     X_LAST_UPDATED_BY,
160     X_LAST_UPDATE_DATE,
161     X_LAST_UPDATE_LOGIN,
162     L.LANGUAGE_CODE,
163     userenv('LANG')
164   from FND_LANGUAGES L
165   where L.INSTALLED_FLAG in ('I', 'B')
166   and not exists
167     (select NULL
168     from JTF_TASK_STATUSES_TL T
169     where T.TASK_STATUS_ID = X_TASK_STATUS_ID
170     and T.LANGUAGE = L.LANGUAGE_CODE);
171 
172   open c;
173   fetch c into X_ROWID;
174   if (c%notfound) then
175     close c;
176     raise no_data_found;
177   end if;
178   close c;
179 
180 end INSERT_ROW;
181 
182 procedure LOCK_ROW (
183   X_TASK_STATUS_ID in NUMBER,
184   X_OBJECT_VERSION_NUMBER in NUMBER
185 ) is
186   cursor c is select
187         OBJECT_VERSION_NUMBER
188     from JTF_TASK_ALL_STATUSES_VL
189     where TASK_STATUS_ID = X_TASK_STATUS_ID
190     and OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
191     for update of TASK_STATUS_ID nowait;
192   recinfo c%rowtype;
193 
194 
195 begin
196   open c;
197   fetch c into recinfo;
198   if (c%notfound) then
199     close c;
200     fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
201     app_exception.raise_exception;
202   end if;
203   close c;
204 
205   if (recinfo.OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER)
206   then
207     null;
208   else
209     fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
210     app_exception.raise_exception;
211   end if;
212 
213 end LOCK_ROW;
214 
215 procedure UPDATE_ROW (
216   X_TASK_STATUS_ID in NUMBER,
217   X_OBJECT_VERSION_NUMBER in NUMBER,
218   X_CLOSED_FLAG in VARCHAR2,
219   X_START_DATE_ACTIVE in DATE,
220   X_END_DATE_ACTIVE in DATE,
221   X_SEEDED_FLAG in VARCHAR2,
222   X_ASSIGNED_FLAG in VARCHAR2,
223   X_WORKING_FLAG in VARCHAR2,
224   X_APPROVED_FLAG in VARCHAR2,
225   X_COMPLETED_FLAG in VARCHAR2,
226   X_CANCELLED_FLAG in VARCHAR2,
227   X_REJECTED_FLAG in VARCHAR2,
228   X_ACCEPTED_FLAG in VARCHAR2,
229   X_ON_HOLD_FLAG in VARCHAR2,
230   X_SCHEDULABLE_FLAG in VARCHAR2,
231   X_DELETE_ALLOWED_FLAG in VARCHAR2,
232   X_ATTRIBUTE1 in VARCHAR2,
233   X_ATTRIBUTE2 in VARCHAR2,
234   X_ATTRIBUTE3 in VARCHAR2,
235   X_ATTRIBUTE4 in VARCHAR2,
236   X_ATTRIBUTE5 in VARCHAR2,
237   X_ATTRIBUTE6 in VARCHAR2,
238   X_ATTRIBUTE7 in VARCHAR2,
239   X_ATTRIBUTE8 in VARCHAR2,
240   X_ATTRIBUTE9 in VARCHAR2,
241   X_ATTRIBUTE10 in VARCHAR2,
242   X_ATTRIBUTE11 in VARCHAR2,
243   X_ATTRIBUTE12 in VARCHAR2,
244   X_ATTRIBUTE13 in VARCHAR2,
245   X_ATTRIBUTE14 in VARCHAR2,
246   X_ATTRIBUTE15 in VARCHAR2,
247   X_ATTRIBUTE_CATEGORY in VARCHAR2,
248   X_NAME in VARCHAR2,
249   X_DESCRIPTION in VARCHAR2,
250   X_LAST_UPDATE_DATE in DATE,
251   X_LAST_UPDATED_BY in NUMBER,
252   X_LAST_UPDATE_LOGIN in NUMBER,
253   X_USAGE in varchar2,
254   X_TASK_STATUS_FLAG in VARCHAR2,
255   X_ASSIGNMENT_STATUS_FLAG in VARCHAR2,
256   X_START_DATE_TYPE IN VARCHAR2 DEFAULT NULL,
257   X_END_DATE_TYPE IN VARCHAR2 DEFAULT NULL
258 ) is
259 begin
260   update JTF_TASK_STATUSES_B set
261     CLOSED_FLAG = X_CLOSED_FLAG,
262     OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER + 1,
263     START_DATE_ACTIVE = X_START_DATE_ACTIVE,
264     END_DATE_ACTIVE = X_END_DATE_ACTIVE,
265     SEEDED_FLAG = X_SEEDED_FLAG,
266     ASSIGNED_FLAG = X_ASSIGNED_FLAG,
267     WORKING_FLAG = X_WORKING_FLAG,
268     APPROVED_FLAG = X_APPROVED_FLAG,
269     COMPLETED_FLAG = X_COMPLETED_FLAG,
270     CANCELLED_FLAG = X_CANCELLED_FLAG,
271     REJECTED_FLAG = X_REJECTED_FLAG,
272     ACCEPTED_FLAG = X_ACCEPTED_FLAG,
273     ON_HOLD_FLAG = X_ON_HOLD_FLAG,
274     SCHEDULABLE_FLAG = X_SCHEDULABLE_FLAG,
275     DELETE_ALLOWED_FLAG = X_DELETE_ALLOWED_FLAG,
276     ATTRIBUTE1 = X_ATTRIBUTE1,
277     ATTRIBUTE2 = X_ATTRIBUTE2,
278     ATTRIBUTE3 = X_ATTRIBUTE3,
279     ATTRIBUTE4 = X_ATTRIBUTE4,
280     ATTRIBUTE5 = X_ATTRIBUTE5,
281     ATTRIBUTE6 = X_ATTRIBUTE6,
282     ATTRIBUTE7 = X_ATTRIBUTE7,
283     ATTRIBUTE8 = X_ATTRIBUTE8,
284     ATTRIBUTE9 = X_ATTRIBUTE9,
285     ATTRIBUTE10 = X_ATTRIBUTE10,
286     ATTRIBUTE11 = X_ATTRIBUTE11,
287     ATTRIBUTE12 = X_ATTRIBUTE12,
288     ATTRIBUTE13 = X_ATTRIBUTE13,
289     ATTRIBUTE14 = X_ATTRIBUTE14,
290     ATTRIBUTE15 = X_ATTRIBUTE15,
291     ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
292     LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
293     LAST_UPDATED_BY = X_LAST_UPDATED_BY,
294     LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
295     USAGE = X_USAGE,
296     TASK_STATUS_FLAG =  X_TASK_STATUS_FLAG,
297     ASSIGNMENT_STATUS_FLAG = X_ASSIGNMENT_STATUS_FLAG,
298     START_DATE_TYPE = X_START_DATE_TYPE,
299     END_DATE_TYPE = X_END_DATE_TYPE
300   where TASK_STATUS_ID = X_TASK_STATUS_ID ;
301 
302   if (sql%notfound) then
303     raise no_data_found;
304   end if;
305 
306   -- Added Index Hint on 30/05/2006 for bug# 5213367
307   update /*+ INDEX(a JTF_TASK_STATUSES_TL_U1) */ JTF_TASK_STATUSES_TL a set
308     a.NAME = X_NAME,
309     a.DESCRIPTION = X_DESCRIPTION,
310     a.LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
311     a.LAST_UPDATED_BY = X_LAST_UPDATED_BY,
312     a.LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
313     a.SOURCE_LANG = userenv('LANG')
314   where a.TASK_STATUS_ID = X_TASK_STATUS_ID
315   and userenv('LANG') in (a.LANGUAGE, a.SOURCE_LANG);
316 
317   if (sql%notfound) then
318     raise no_data_found;
319   end if;
320 end UPDATE_ROW;
321 
322 procedure DELETE_ROW (
323   X_TASK_STATUS_ID in NUMBER
324 ) is
325 begin
326   delete from JTF_TASK_STATUSES_TL
327   where TASK_STATUS_ID = X_TASK_STATUS_ID;
328 
329   if (sql%notfound) then
330     raise no_data_found;
331   end if;
332 
333   delete from JTF_TASK_STATUSES_B
334   where TASK_STATUS_ID = X_TASK_STATUS_ID  ;
335 
336   if (sql%notfound) then
337     raise no_data_found;
338   end if;
339 end DELETE_ROW;
340 
341 procedure ADD_LANGUAGE
342 is
343 begin
344 
345  /* Solving Perf. Bug 3723927 */
346      /* The following delete and update statements are commented out */
347      /* as a quick workaround to fix the time-consuming table handler issue */
348 
349  /* delete from JTF_TASK_STATUSES_TL T
350   where not exists
351     (select NULL
352     from JTF_TASK_STATUSES_B B
353     where B.TASK_STATUS_ID = T.TASK_STATUS_ID
354     );
355 
356   update JTF_TASK_STATUSES_TL T set (
357       NAME,
358       DESCRIPTION
359     ) = (select
360       B.NAME,
361       B.DESCRIPTION
362     from JTF_TASK_STATUSES_TL B
363     where B.TASK_STATUS_ID = T.TASK_STATUS_ID
364     and B.LANGUAGE = T.SOURCE_LANG)
365   where (
366       T.TASK_STATUS_ID,
367       T.LANGUAGE
368   ) in (select
369       SUBT.TASK_STATUS_ID,
370       SUBT.LANGUAGE
371     from JTF_TASK_STATUSES_TL SUBB, JTF_TASK_STATUSES_TL SUBT
372     where SUBB.TASK_STATUS_ID = SUBT.TASK_STATUS_ID
373     and SUBB.LANGUAGE = SUBT.SOURCE_LANG
374     and (SUBB.NAME <> SUBT.NAME
375       or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
376       or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
377       or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
378   ));  */
379 
380   insert into JTF_TASK_STATUSES_TL (
381     TASK_STATUS_ID,
382     NAME,
383     DESCRIPTION,
384     CREATED_BY,
385     CREATION_DATE,
386     LAST_UPDATED_BY,
387     LAST_UPDATE_DATE,
388     LAST_UPDATE_LOGIN,
389     LANGUAGE,
390     SOURCE_LANG
391   ) select /*+ INDEX(b JTF_TASK_STATUSES_TL_U1) INDEX (l FND_LANGUAGES_N1) */ -- Added Index Hint on 30/05/2006 for bug# 5213367
392     B.TASK_STATUS_ID,
393     B.NAME,
394     B.DESCRIPTION,
395     B.CREATED_BY,
396     B.CREATION_DATE,
397     B.LAST_UPDATED_BY,
398     B.LAST_UPDATE_DATE,
399     B.LAST_UPDATE_LOGIN,
400     L.LANGUAGE_CODE,
401     B.SOURCE_LANG
402   from JTF_TASK_STATUSES_TL B, FND_LANGUAGES L
403   where L.INSTALLED_FLAG in ('I', 'B')
404   and B.LANGUAGE = userenv('LANG')
405   and not exists
406     (select NULL
407     from JTF_TASK_STATUSES_TL T
408     where T.TASK_STATUS_ID = B.TASK_STATUS_ID
409     and T.LANGUAGE = L.LANGUAGE_CODE);
410 end ADD_LANGUAGE;
411 
412 procedure TRANSLATE_ROW(
413   X_TASK_STATUS_ID in varchar2,
414   X_NAME in varchar2,
415   X_DESCRIPTION in varchar2,
416   X_OWNER in varchar2) is
417 l_user_id                 NUMBER := 0;
418    BEGIN
419       IF x_owner = 'SEED'
420       THEN
421          l_user_id := 1;
422       END IF;
423 
424   -- Added Index Hint on 30/05/2006 for bug# 5213367
425   update /*+ INDEX(a JTF_TASK_STATUSES_TL_U1) */ jtf_task_statuses_tl a set
426     a.NAME= nvl(X_NAME, a.name) ,
427     a.DESCRIPTION= nvl(X_DESCRIPTION, a.description),
428     a.LAST_UPDATE_DATE = sysdate,
429     a.LAST_UPDATE_LOGIN = 0,
430     a.SOURCE_LANG = userenv('LANG'),
431     a.LAST_UPDATED_BY = l_user_id
432   where a.task_status_id = X_task_status_id
433   and userenv('LANG') in (a.LANGUAGE, a.SOURCE_LANG);
434 
435   if (sql%notfound) then
436     raise no_data_found;
437   end if;
438 end TRANSLATE_ROW;
439 
440 procedure LOAD_ROW (
441   X_TASK_STATUS_ID in NUMBER,
442   X_CLOSED_FLAG in VARCHAR2,
443   X_START_DATE_ACTIVE in DATE,
444   X_END_DATE_ACTIVE in DATE,
445   X_SEEDED_FLAG in VARCHAR2,
446   X_ASSIGNED_FLAG in VARCHAR2,
447   X_WORKING_FLAG in VARCHAR2,
448   X_APPROVED_FLAG in VARCHAR2,
449   X_COMPLETED_FLAG in VARCHAR2,
450   X_CANCELLED_FLAG in VARCHAR2,
451   X_REJECTED_FLAG in VARCHAR2,
452   X_ACCEPTED_FLAG in VARCHAR2,
453   X_ON_HOLD_FLAG in VARCHAR2,
454   X_SCHEDULABLE_FLAG in VARCHAR2,
455   X_DELETE_ALLOWED_FLAG in VARCHAR2,
456   X_ATTRIBUTE1 in VARCHAR2,
457   X_ATTRIBUTE2 in VARCHAR2,
458   X_ATTRIBUTE3 in VARCHAR2,
459   X_ATTRIBUTE4 in VARCHAR2,
460   X_ATTRIBUTE5 in VARCHAR2,
461   X_ATTRIBUTE6 in VARCHAR2,
462   X_ATTRIBUTE7 in VARCHAR2,
463   X_ATTRIBUTE8 in VARCHAR2,
464   X_ATTRIBUTE9 in VARCHAR2,
465   X_ATTRIBUTE10 in VARCHAR2,
466   X_ATTRIBUTE11 in VARCHAR2,
467   X_ATTRIBUTE12 in VARCHAR2,
468   X_ATTRIBUTE13 in VARCHAR2,
469   X_ATTRIBUTE14 in VARCHAR2,
470   X_ATTRIBUTE15 in VARCHAR2,
471   X_ATTRIBUTE_CATEGORY in VARCHAR2,
472   X_NAME in VARCHAR2,
473   X_DESCRIPTION in VARCHAR2,
474   X_USAGE in VARCHAR2,
475   X_TASK_STATUS_FLAG in VARCHAR2,
476   X_ASSIGNMENT_STATUS_FLAG in VARCHAR2,
477   X_OWNER in VARCHAR2,
478   X_START_DATE_TYPE IN VARCHAR2,
479   X_END_DATE_TYPE IN VARCHAR2
480   ) is
481 
482 l_user_id                 NUMBER := 0;
483       l_task_status_id            NUMBER;
484       l_rowid                   ROWID;
485       l_object_version_number   NUMBER;
486    BEGIN
487 
488       IF x_owner = 'SEED'
489       THEN
490          l_user_id := 1;
491       END IF;
492 
493 
494       SELECT task_status_id, object_version_number
495         INTO l_task_status_id, l_object_version_number
496         FROM jtf_task_all_statuses_vl
497        WHERE task_status_id = x_task_status_id;
498 
499 
500 
501  	update JTF_TASK_STATUSES_B set
502    	 CLOSED_FLAG = X_CLOSED_FLAG,
503          OBJECT_VERSION_NUMBER =  l_object_version_number + 1,
504          START_DATE_ACTIVE = X_START_DATE_ACTIVE,
505          END_DATE_ACTIVE = X_END_DATE_ACTIVE,
506          SEEDED_FLAG = X_SEEDED_FLAG,
507          ASSIGNED_FLAG = X_ASSIGNED_FLAG,
508          WORKING_FLAG = X_WORKING_FLAG,
509          APPROVED_FLAG = X_APPROVED_FLAG,
510          COMPLETED_FLAG = X_COMPLETED_FLAG,
511          CANCELLED_FLAG = X_CANCELLED_FLAG,
512          REJECTED_FLAG = X_REJECTED_FLAG,
513          ACCEPTED_FLAG = X_ACCEPTED_FLAG,
514          ON_HOLD_FLAG = X_ON_HOLD_FLAG,
515          SCHEDULABLE_FLAG = X_SCHEDULABLE_FLAG,
516          DELETE_ALLOWED_FLAG = X_DELETE_ALLOWED_FLAG,
517          LAST_UPDATE_DATE = sysdate,
518          LAST_UPDATED_BY = l_user_id,
519          LAST_UPDATE_LOGIN = 0,
520          USAGE = X_USAGE,
521          TASK_STATUS_FLAG =  X_TASK_STATUS_FLAG,
522          ASSIGNMENT_STATUS_FLAG = X_ASSIGNMENT_STATUS_FLAG,
523          START_DATE_TYPE = X_START_DATE_TYPE,
524          END_DATE_TYPE = X_END_DATE_TYPE
525         where TASK_STATUS_ID = l_task_status_id ;
526 
527     -- Added Index Hint on 30/05/2006 for bug# 5213367
528     update /*+ INDEX(a JTF_TASK_STATUSES_TL_U1) */ JTF_TASK_STATUSES_TL a set
529        a.NAME = X_NAME,
530        a.DESCRIPTION = X_DESCRIPTION,
531        a.LAST_UPDATE_DATE = sysdate,
532        a.LAST_UPDATED_BY = l_user_id,
533        a.LAST_UPDATE_LOGIN = 0,
534        a.SOURCE_LANG = userenv('LANG')
535        where a.TASK_STATUS_ID = l_task_status_id
536        and userenv('LANG') in (a.LANGUAGE, a.SOURCE_LANG);
537 
538 
539 
540 exception
541 when no_data_found then
542 
543     jtf_task_statuses_pkg.insert_row (
544         x_rowid => l_rowid ,
545             x_task_status_id => x_task_status_id,
546             x_closed_flag => x_closed_flag,
547         x_start_date_active => x_start_date_active,
548             x_end_date_active => x_end_date_active,
549             x_seeded_flag => x_seeded_flag,
550             x_assigned_flag => x_assigned_flag,
551             x_working_flag => x_working_flag,
552             x_approved_flag => x_approved_flag,
553             x_completed_flag => x_completed_flag,
554             x_cancelled_flag => x_cancelled_flag,
555             x_rejected_flag => x_rejected_flag,
556             x_accepted_flag => x_accepted_flag,
557             x_on_hold_flag => x_on_hold_flag,
558             x_schedulable_flag => x_schedulable_flag,
559             x_delete_allowed_flag => x_delete_allowed_flag,
560             x_task_status_flag =>  x_task_status_flag,
561             x_assignment_status_flag =>  x_assignment_status_flag,
562             x_usage => x_usage,
563             x_attribute1 => x_attribute1,
564             x_attribute2 => x_attribute2,
565             x_attribute3 => x_attribute3,
566             x_attribute4 => x_attribute4,
567             x_attribute5 => x_attribute5,
568             x_attribute6 => x_attribute6,
569             x_attribute7 => x_attribute7,
570             x_attribute8 => x_attribute8,
571             x_attribute9 => x_attribute9,
572             x_attribute10 => x_attribute10,
573             x_attribute11 => x_attribute11,
574             x_attribute12 => x_attribute12,
575             x_attribute13 => x_attribute13,
576             x_attribute14 => x_attribute14,
577             x_attribute15 => x_attribute15,
578             x_attribute_category => x_attribute_category,
579             x_name => x_name,
580             x_description => x_description,
581             x_last_update_date => SYSDATE,
582             x_last_updated_by => l_user_id,
583             x_last_update_login => 0,
584             x_creation_date => SYSDATE,
585             x_created_by => l_user_id,
586             x_start_date_type => x_start_date_type,
587             x_end_date_type => x_end_date_type
588          );
589 
590 end ;
591 
592 end JTF_TASK_STATUSES_PKG;