APPS.ENG_CHANGE_LINES_EXT_PKG dependencies on ENG_CHANGE_LINES_EXT_TL

Line 8: delete from ENG_CHANGE_LINES_EXT_TL T

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

Line 11: from ENG_CHANGE_LINES_EXT_TL B

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

Line 20: update ENG_CHANGE_LINES_EXT_TL T set (

16: and B.ATTR_GROUP_ID = T.ATTR_GROUP_ID
17:
18: );
19:
20: update ENG_CHANGE_LINES_EXT_TL T set (
21: TL_EXT_ATTR1,
22: TL_EXT_ATTR2,
23: TL_EXT_ATTR3,
24: TL_EXT_ATTR4,

Line 102: from ENG_CHANGE_LINES_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_CHANGE_LINES_EXT_TL B
103: where B.EXTENSION_ID = T.EXTENSION_ID
104: and B.CHANGE_LINE_ID = T.CHANGE_LINE_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_CHANGE_LINES_EXT_TL SUBB, ENG_CHANGE_LINES_EXT_TL SUBT

116: SUBT.CHANGE_LINE_ID,
117: SUBT.CHANGE_TYPE_ID,
118: SUBT.ATTR_GROUP_ID,
119: SUBT.LANGUAGE
120: from ENG_CHANGE_LINES_EXT_TL SUBB, ENG_CHANGE_LINES_EXT_TL SUBT
121: where SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
122: and SUBB.CHANGE_LINE_ID = SUBT.CHANGE_LINE_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_CHANGE_LINES_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_CHANGE_LINES_EXT_TL (
249: TL_EXT_ATTR6,
250: TL_EXT_ATTR7,
251: TL_EXT_ATTR8,
252: TL_EXT_ATTR9,

Line 352: from ENG_CHANGE_LINES_EXT_TL B, FND_LANGUAGES L

348: B.TL_EXT_ATTR4,
349: B.TL_EXT_ATTR5,
350: L.LANGUAGE_CODE,
351: B.SOURCE_LANG
352: from ENG_CHANGE_LINES_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_CHANGE_LINES_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_CHANGE_LINES_EXT_TL T
358: where T.EXTENSION_ID = B.EXTENSION_ID
359: and T.CHANGE_LINE_ID = B.CHANGE_LINE_ID
360: and T.CHANGE_TYPE_ID = B.CHANGE_TYPE_ID
361: and T.ATTR_GROUP_ID = B.ATTR_GROUP_ID