APPS.ENG_CHANGES_EXT_PKG dependencies on ENG_CHANGES_EXT_TL

Line 7: delete from ENG_CHANGES_EXT_TL T

3: procedure ADD_LANGUAGE
4: is
5: begin
6:
7: delete from ENG_CHANGES_EXT_TL T
8: where not exists
9: (select NULL
10: from ENG_CHANGES_EXT_TL B
11: where

Line 10: from ENG_CHANGES_EXT_TL B

6:
7: delete from ENG_CHANGES_EXT_TL T
8: where not exists
9: (select NULL
10: from ENG_CHANGES_EXT_TL B
11: where
12: B.EXTENSION_ID = T.EXTENSION_ID
13: and B.CHANGE_ID = T.CHANGE_ID
14: and B.CHANGE_TYPE_ID = T.CHANGE_TYPE_ID

Line 20: update ENG_CHANGES_EXT_TL T set (

16:
17: );
18:
19:
20: update ENG_CHANGES_EXT_TL T set (
21: TL_EXT_ATTR1,
22: TL_EXT_ATTR2,
23: TL_EXT_ATTR3,
24: TL_EXT_ATTR4,

Line 102: from ENG_CHANGES_EXT_TL B

98: B.TL_EXT_ATTR37,
99: B.TL_EXT_ATTR38,
100: B.TL_EXT_ATTR39,
101: B.TL_EXT_ATTR40
102: from ENG_CHANGES_EXT_TL B
103: where B.EXTENSION_ID = T.EXTENSION_ID
104: and B.CHANGE_ID = T.CHANGE_ID
105: and B.CHANGE_TYPE_ID = T.CHANGE_TYPE_ID
106: and B.ATTR_GROUP_ID = T.ATTR_GROUP_ID

Line 120: from ENG_CHANGES_EXT_TL SUBB, ENG_CHANGES_EXT_TL SUBT

116: SUBT.CHANGE_ID,
117: SUBT.CHANGE_TYPE_ID,
118: SUBT.ATTR_GROUP_ID,
119: SUBT.LANGUAGE
120: from ENG_CHANGES_EXT_TL SUBB, ENG_CHANGES_EXT_TL SUBT
121: where SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
122: and SUBB.CHANGE_ID = SUBT.CHANGE_ID
123: and SUBB.CHANGE_TYPE_ID = SUBT.CHANGE_TYPE_ID
124: and SUBB.ATTR_GROUP_ID = SUBT.ATTR_GROUP_ID

Line 248: insert into ENG_CHANGES_EXT_TL (

244: or (SUBB.TL_EXT_ATTR40 is null and SUBT.TL_EXT_ATTR40 is not null)
245: or (SUBB.TL_EXT_ATTR40 is not null and SUBT.TL_EXT_ATTR40 is null)
246: ));
247:
248: insert into ENG_CHANGES_EXT_TL (
249: EXTENSION_ID,
250: CHANGE_ID,
251: CHANGE_TYPE_ID,
252: ATTR_GROUP_ID,

Line 352: from ENG_CHANGES_EXT_TL B, FND_LANGUAGES L

348: B.TL_EXT_ATTR39,
349: B.TL_EXT_ATTR40,
350: L.LANGUAGE_CODE,
351: B.SOURCE_LANG
352: from ENG_CHANGES_EXT_TL B, FND_LANGUAGES L
353: where L.INSTALLED_FLAG in ('I', 'B')
354: and B.LANGUAGE = userenv('LANG')
355: and not exists
356: (select NULL

Line 357: from ENG_CHANGES_EXT_TL T

353: where L.INSTALLED_FLAG in ('I', 'B')
354: and B.LANGUAGE = userenv('LANG')
355: and not exists
356: (select NULL
357: from ENG_CHANGES_EXT_TL T
358: where T.EXTENSION_ID = B.EXTENSION_ID
359: and T.CHANGE_ID = B.CHANGE_ID
360: and T.CHANGE_TYPE_ID = B.CHANGE_TYPE_ID
361: and T.ATTR_GROUP_ID = B.ATTR_GROUP_ID