APPS.EGO_ITEM_TP_ATTRS_PKG dependencies on EGO_ITEM_TP_ATTRS_EXT_TL

Line 16: delete from EGO_ITEM_TP_ATTRS_EXT_TL T

12: ----------------------------------------------------------------------
13: PROCEDURE ADD_LANGUAGE
14: IS
15: BEGIN
16: delete from EGO_ITEM_TP_ATTRS_EXT_TL T
17: where not exists
18: (select NULL
19: from EGO_ITEM_TP_ATTRS_EXT_B B
20: where B.EXTENSION_ID = T.EXTENSION_ID

Line 23: update EGO_ITEM_TP_ATTRS_EXT_TL T set (

19: from EGO_ITEM_TP_ATTRS_EXT_B B
20: where B.EXTENSION_ID = T.EXTENSION_ID
21: );
22:
23: update EGO_ITEM_TP_ATTRS_EXT_TL T set (
24: TL_EXT_ATTR1,
25: TL_EXT_ATTR2,
26: TL_EXT_ATTR3,
27: TL_EXT_ATTR4,

Line 106: from EGO_ITEM_TP_ATTRS_EXT_TL B

102: B.TL_EXT_ATTR37,
103: B.TL_EXT_ATTR38,
104: B.TL_EXT_ATTR39,
105: B.TL_EXT_ATTR40
106: from EGO_ITEM_TP_ATTRS_EXT_TL B
107: where B.EXTENSION_ID = T.EXTENSION_ID
108: and B.LANGUAGE = T.SOURCE_LANG)
109: where (
110: T.EXTENSION_ID,

Line 115: from EGO_ITEM_TP_ATTRS_EXT_TL SUBB, EGO_ITEM_TP_ATTRS_EXT_TL SUBT

111: T.LANGUAGE
112: ) in (select
113: SUBT.EXTENSION_ID,
114: SUBT.LANGUAGE
115: from EGO_ITEM_TP_ATTRS_EXT_TL SUBB, EGO_ITEM_TP_ATTRS_EXT_TL SUBT
116: where SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
117: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
118: and (SUBB.TL_EXT_ATTR1 <> SUBT.TL_EXT_ATTR1
119: or (SUBB.TL_EXT_ATTR1 is null and SUBT.TL_EXT_ATTR1 is not null)

Line 240: insert into EGO_ITEM_TP_ATTRS_EXT_TL (

236: or (SUBB.TL_EXT_ATTR40 is null and SUBT.TL_EXT_ATTR40 is not null)
237: or (SUBB.TL_EXT_ATTR40 is not null and SUBT.TL_EXT_ATTR40 is null)
238: ));
239:
240: insert into EGO_ITEM_TP_ATTRS_EXT_TL (
241: TL_EXT_ATTR23,
242: TL_EXT_ATTR24,
243: TL_EXT_ATTR25,
244: TL_EXT_ATTR26,

Line 346: from EGO_ITEM_TP_ATTRS_EXT_TL B, FND_LANGUAGES L

342: B.TL_EXT_ATTR21,
343: B.TL_EXT_ATTR22,
344: L.LANGUAGE_CODE,
345: B.SOURCE_LANG
346: from EGO_ITEM_TP_ATTRS_EXT_TL B, FND_LANGUAGES L
347: where L.INSTALLED_FLAG in ('I', 'B')
348: and B.LANGUAGE = userenv('LANG')
349: and not exists
350: (select NULL

Line 351: from EGO_ITEM_TP_ATTRS_EXT_TL T

347: where L.INSTALLED_FLAG in ('I', 'B')
348: and B.LANGUAGE = userenv('LANG')
349: and not exists
350: (select NULL
351: from EGO_ITEM_TP_ATTRS_EXT_TL T
352: where T.EXTENSION_ID = B.EXTENSION_ID
353: and T.LANGUAGE = L.LANGUAGE_CODE);
354: END ADD_LANGUAGE;
355: