APPS.IBY_SETUP_TASKS_PKG dependencies on IBY_SETUP_TASKS_TL

Line 56: insert into IBY_SETUP_TASKS_TL (

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,

Line 84: from IBY_SETUP_TASKS_TL T

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;

Line 127: from IBY_SETUP_TASKS_TL

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

Line 209: update IBY_SETUP_TASKS_TL set

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,

Line 256: update IBY_SETUP_TASKS_TL set

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,

Line 275: delete from IBY_SETUP_TASKS_TL

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;

Line 293: delete from IBY_SETUP_TASKS_TL T

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

Line 300: update IBY_SETUP_TASKS_TL T set (

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,

Line 306: from IBY_SETUP_TASKS_TL B

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,

Line 315: from IBY_SETUP_TASKS_TL SUBB, IBY_SETUP_TASKS_TL SUBT

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)

Line 326: insert into IBY_SETUP_TASKS_TL (

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,

Line 350: from IBY_SETUP_TASKS_TL B, FND_LANGUAGES L

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

Line 355: from IBY_SETUP_TASKS_TL T

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:

Line 428: update iby_setup_tasks_tl set

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),