[Home] [Help]
156: X_VALIDATION_END_DATE,
157: X_RESTRICT_UPDATES_FLAG
158: );
159:
160: insert into JTF_TASK_STATUSES_TL (
161: TASK_STATUS_ID,
162: NAME,
163: DESCRIPTION,
164: CREATED_BY,
182: from FND_LANGUAGES L
183: where L.INSTALLED_FLAG in ('I', 'B')
184: and not exists
185: (select NULL
186: from JTF_TASK_STATUSES_TL T
187: where T.TASK_STATUS_ID = X_TASK_STATUS_ID
188: and T.LANGUAGE = L.LANGUAGE_CODE);
189:
190: open c;
333: raise no_data_found;
334: end if;
335:
336: -- Added Index Hint on 30/05/2006 for bug# 5213367
337: update /*+ INDEX(a JTF_TASK_STATUSES_TL_U1) */ JTF_TASK_STATUSES_TL a set
338: a.NAME = X_NAME,
339: a.DESCRIPTION = X_DESCRIPTION,
340: a.LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
341: a.LAST_UPDATED_BY = X_LAST_UPDATED_BY,
352: procedure DELETE_ROW (
353: X_TASK_STATUS_ID in NUMBER
354: ) is
355: begin
356: delete from JTF_TASK_STATUSES_TL
357: where TASK_STATUS_ID = X_TASK_STATUS_ID;
358:
359: if (sql%notfound) then
360: raise no_data_found;
375: /* Solving Perf. Bug 3723927 */
376: /* The following delete and update statements are commented out */
377: /* as a quick workaround to fix the time-consuming table handler issue */
378:
379: /* delete from JTF_TASK_STATUSES_TL T
380: where not exists
381: (select NULL
382: from JTF_TASK_STATUSES_B B
383: where B.TASK_STATUS_ID = T.TASK_STATUS_ID
382: from JTF_TASK_STATUSES_B B
383: where B.TASK_STATUS_ID = T.TASK_STATUS_ID
384: );
385:
386: update JTF_TASK_STATUSES_TL T set (
387: NAME,
388: DESCRIPTION
389: ) = (select
390: B.NAME,
388: DESCRIPTION
389: ) = (select
390: B.NAME,
391: B.DESCRIPTION
392: from JTF_TASK_STATUSES_TL B
393: where B.TASK_STATUS_ID = T.TASK_STATUS_ID
394: and B.LANGUAGE = T.SOURCE_LANG)
395: where (
396: T.TASK_STATUS_ID,
397: T.LANGUAGE
398: ) in (select
399: SUBT.TASK_STATUS_ID,
400: SUBT.LANGUAGE
401: from JTF_TASK_STATUSES_TL SUBB, JTF_TASK_STATUSES_TL SUBT
402: where SUBB.TASK_STATUS_ID = SUBT.TASK_STATUS_ID
403: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
404: and (SUBB.NAME <> SUBT.NAME
405: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
406: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
407: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
408: )); */
409:
410: insert into JTF_TASK_STATUSES_TL (
411: TASK_STATUS_ID,
412: NAME,
413: DESCRIPTION,
414: CREATED_BY,
417: LAST_UPDATE_DATE,
418: LAST_UPDATE_LOGIN,
419: LANGUAGE,
420: SOURCE_LANG
421: ) select /*+ INDEX(b JTF_TASK_STATUSES_TL_U1) INDEX (l FND_LANGUAGES_N1) */ -- Added Index Hint on 30/05/2006 for bug# 5213367
422: B.TASK_STATUS_ID,
423: B.NAME,
424: B.DESCRIPTION,
425: B.CREATED_BY,
428: B.LAST_UPDATE_DATE,
429: B.LAST_UPDATE_LOGIN,
430: L.LANGUAGE_CODE,
431: B.SOURCE_LANG
432: from JTF_TASK_STATUSES_TL B, FND_LANGUAGES L
433: where L.INSTALLED_FLAG in ('I', 'B')
434: and B.LANGUAGE = userenv('LANG')
435: and not exists
436: (select NULL
433: where L.INSTALLED_FLAG in ('I', 'B')
434: and B.LANGUAGE = userenv('LANG')
435: and not exists
436: (select NULL
437: from JTF_TASK_STATUSES_TL T
438: where T.TASK_STATUS_ID = B.TASK_STATUS_ID
439: and T.LANGUAGE = L.LANGUAGE_CODE);
440: end ADD_LANGUAGE;
441:
451: l_user_id := 1;
452: END IF;
453:
454: -- Added Index Hint on 30/05/2006 for bug# 5213367
455: update /*+ INDEX(a JTF_TASK_STATUSES_TL_U1) */ jtf_task_statuses_tl a set
456: a.NAME= nvl(X_NAME, a.name) ,
457: a.DESCRIPTION= nvl(X_DESCRIPTION, a.description),
458: a.LAST_UPDATE_DATE = sysdate,
459: a.LAST_UPDATE_LOGIN = 0,
558: PLANNED_FLAG = X_PLANNED_FLAG
559: where TASK_STATUS_ID = l_task_status_id ;
560:
561: -- Added Index Hint on 30/05/2006 for bug# 5213367
562: update /*+ INDEX(a JTF_TASK_STATUSES_TL_U1) */ JTF_TASK_STATUSES_TL a set
563: a.NAME = X_NAME,
564: a.DESCRIPTION = X_DESCRIPTION,
565: a.LAST_UPDATE_DATE = sysdate,
566: a.LAST_UPDATED_BY = l_user_id,