APPS.ENG_CHANGE_ACTIONS_PKG dependencies on ENG_CHANGE_ACTIONS_TL

Line 105: insert into ENG_CHANGE_ACTIONS_TL (

101: X_IMPLEMENTATION_REQ_ID,
102: X_LOCAL_ORGANIZATION_ID -- Bug 4704384
103: );
104:
105: insert into ENG_CHANGE_ACTIONS_TL (
106: LAST_UPDATED_BY,
107: LAST_UPDATE_LOGIN,
108: LAST_UPDATE_DATE,
109: CREATED_BY,

Line 129: from ENG_CHANGE_ACTIONS_TL T

125: from FND_LANGUAGES L
126: where L.INSTALLED_FLAG in ('I', 'B')
127: and not exists
128: (select NULL
129: from ENG_CHANGE_ACTIONS_TL T
130: where T.ACTION_ID = X_ACTION_ID
131: and T.LANGUAGE = L.LANGUAGE_CODE);
132:
133: open c;

Line 215: from ENG_CHANGE_ACTIONS_TL

211:
212: cursor c1 is select
213: DESCRIPTION,
214: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
215: from ENG_CHANGE_ACTIONS_TL
216: where ACTION_ID = X_ACTION_ID
217: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
218: for update of ACTION_ID nowait;
219: begin

Line 364: update ENG_CHANGE_ACTIONS_TL set

360: if (sql%notfound) then
361: raise no_data_found;
362: end if;
363:
364: update ENG_CHANGE_ACTIONS_TL set
365: DESCRIPTION = X_DESCRIPTION,
366: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
367: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
368: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 382: delete from ENG_CHANGE_ACTIONS_TL

378: procedure DELETE_ROW (
379: X_ACTION_ID in NUMBER
380: ) is
381: begin
382: delete from ENG_CHANGE_ACTIONS_TL
383: where ACTION_ID = X_ACTION_ID;
384:
385: if (sql%notfound) then
386: raise no_data_found;

Line 400: delete from ENG_CHANGE_ACTIONS_TL T

396:
397: procedure ADD_LANGUAGE
398: is
399: begin
400: delete from ENG_CHANGE_ACTIONS_TL T
401: where not exists
402: (select NULL
403: from ENG_CHANGE_ACTIONS B
404: where B.ACTION_ID = T.ACTION_ID

Line 407: update ENG_CHANGE_ACTIONS_TL T set (

403: from ENG_CHANGE_ACTIONS B
404: where B.ACTION_ID = T.ACTION_ID
405: );
406:
407: update ENG_CHANGE_ACTIONS_TL T set (
408: DESCRIPTION
409: ) = (select
410: B.DESCRIPTION
411: from ENG_CHANGE_ACTIONS_TL B

Line 411: from ENG_CHANGE_ACTIONS_TL B

407: update ENG_CHANGE_ACTIONS_TL T set (
408: DESCRIPTION
409: ) = (select
410: B.DESCRIPTION
411: from ENG_CHANGE_ACTIONS_TL B
412: where B.ACTION_ID = T.ACTION_ID
413: and B.LANGUAGE = T.SOURCE_LANG)
414: where (
415: T.ACTION_ID,

Line 420: from ENG_CHANGE_ACTIONS_TL SUBB, ENG_CHANGE_ACTIONS_TL SUBT

416: T.LANGUAGE
417: ) in (select
418: SUBT.ACTION_ID,
419: SUBT.LANGUAGE
420: from ENG_CHANGE_ACTIONS_TL SUBB, ENG_CHANGE_ACTIONS_TL SUBT
421: where SUBB.ACTION_ID = SUBT.ACTION_ID
422: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
423: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
424: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)

Line 428: insert into ENG_CHANGE_ACTIONS_TL (

424: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
425: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
426: ));
427:
428: insert into ENG_CHANGE_ACTIONS_TL (
429: LAST_UPDATED_BY,
430: LAST_UPDATE_LOGIN,
431: LAST_UPDATE_DATE,
432: CREATED_BY,

Line 448: from ENG_CHANGE_ACTIONS_TL B, FND_LANGUAGES L

444: B.CREATION_DATE,
445: B.ACTION_ID,
446: L.LANGUAGE_CODE,
447: B.SOURCE_LANG
448: from ENG_CHANGE_ACTIONS_TL B, FND_LANGUAGES L
449: where L.INSTALLED_FLAG in ('I', 'B')
450: and B.LANGUAGE = userenv('LANG')
451: and not exists
452: (select NULL

Line 453: from ENG_CHANGE_ACTIONS_TL T

449: where L.INSTALLED_FLAG in ('I', 'B')
450: and B.LANGUAGE = userenv('LANG')
451: and not exists
452: (select NULL
453: from ENG_CHANGE_ACTIONS_TL T
454: where T.ACTION_ID = B.ACTION_ID
455: and T.LANGUAGE = L.LANGUAGE_CODE);
456: end ADD_LANGUAGE;
457: