52: X_LAST_UPDATED_BY,
53: X_LAST_UPDATE_LOGIN
54: );
55:
56: insert into IBY_SETUP_TASKS_TL (
57: TASK_CODE,
58: TASK_NAME,
59: CREATED_BY,
60: CREATION_DATE,
80: from FND_LANGUAGES L
81: where L.INSTALLED_FLAG in ('I', 'B')
82: and not exists
83: (select NULL
84: from IBY_SETUP_TASKS_TL T
85: where T.TASK_CODE = X_TASK_CODE
86: and T.LANGUAGE = L.LANGUAGE_CODE);
87:
88: open c;
123: cursor c1 is select
124: TASK_NAME,
125: DESCRIPTION,
126: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
127: from IBY_SETUP_TASKS_TL
128: where TASK_CODE = X_TASK_CODE
129: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
130: for update of TASK_CODE nowait;
131: begin
205: if (sql%notfound) then
206: raise no_data_found;
207: end if;
208:
209: update IBY_SETUP_TASKS_TL set
210: TASK_NAME = X_TASK_NAME,
211: DESCRIPTION = X_DESCRIPTION,
212: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
213: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
252: if (sql%notfound) then
253: raise no_data_found;
254: end if;
255:
256: update IBY_SETUP_TASKS_TL set
257: TASK_NAME = X_TASK_NAME,
258: DESCRIPTION = X_DESCRIPTION,
259: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
260: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
271: procedure DELETE_ROW (
272: X_TASK_CODE in VARCHAR2
273: ) is
274: begin
275: delete from IBY_SETUP_TASKS_TL
276: where TASK_CODE = X_TASK_CODE;
277:
278: if (sql%notfound) then
279: raise no_data_found;
289:
290: procedure ADD_LANGUAGE
291: is
292: begin
293: delete from IBY_SETUP_TASKS_TL T
294: where not exists
295: (select NULL
296: from IBY_SETUP_TASKS_B B
297: where B.TASK_CODE = T.TASK_CODE
296: from IBY_SETUP_TASKS_B B
297: where B.TASK_CODE = T.TASK_CODE
298: );
299:
300: update IBY_SETUP_TASKS_TL T set (
301: TASK_NAME,
302: DESCRIPTION
303: ) = (select
304: B.TASK_NAME,
302: DESCRIPTION
303: ) = (select
304: B.TASK_NAME,
305: B.DESCRIPTION
306: from IBY_SETUP_TASKS_TL B
307: where B.TASK_CODE = T.TASK_CODE
308: and B.LANGUAGE = T.SOURCE_LANG)
309: where (
310: T.TASK_CODE,
311: T.LANGUAGE
312: ) in (select
313: SUBT.TASK_CODE,
314: SUBT.LANGUAGE
315: from IBY_SETUP_TASKS_TL SUBB, IBY_SETUP_TASKS_TL SUBT
316: where SUBB.TASK_CODE = SUBT.TASK_CODE
317: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
318: and (SUBB.TASK_NAME <> SUBT.TASK_NAME
319: or (SUBB.TASK_NAME is null and SUBT.TASK_NAME is not null)
322: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
323: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
324: ));
325:
326: insert into IBY_SETUP_TASKS_TL (
327: TASK_CODE,
328: TASK_NAME,
329: CREATED_BY,
330: CREATION_DATE,
346: B.OBJECT_VERSION_NUMBER,
347: B.DESCRIPTION,
348: L.LANGUAGE_CODE,
349: B.SOURCE_LANG
350: from IBY_SETUP_TASKS_TL B, FND_LANGUAGES L
351: where L.INSTALLED_FLAG in ('I', 'B')
352: and B.LANGUAGE = userenv('LANG')
353: and not exists
354: (select NULL
351: where L.INSTALLED_FLAG in ('I', 'B')
352: and B.LANGUAGE = userenv('LANG')
353: and not exists
354: (select NULL
355: from IBY_SETUP_TASKS_TL T
356: where T.TASK_CODE = B.TASK_CODE
357: and T.LANGUAGE = L.LANGUAGE_CODE);
358: end ADD_LANGUAGE;
359:
424: X_OBJECT_VERSION_NUMBER in NUMBER,
425: X_OWNER in VARCHAR2)
426: is
427: begin
428: update iby_setup_tasks_tl set
429: TASK_NAME = X_TASK_NAME,
430: DESCRIPTION = X_DESCRIPTION,
431: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
432: LAST_UPDATED_BY = fnd_load_util.owner_id(X_OWNER),