APPS.EGO_ITEM_GTN_CHG_ATTRS_PKG dependencies on EGO_GTN_ATTR_CHG_TL

Line 8: delete from EGO_GTN_ATTR_CHG_TL T

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

Line 15: update EGO_GTN_ATTR_CHG_TL T set (

11: from EGO_GTN_ATTR_CHG_B B
12: where B.EXTENSION_ID = T.EXTENSION_ID
13: );
14:
15: update EGO_GTN_ATTR_CHG_TL T set (
16: INVOICE_NAME,
17: DESCRIPTIVE_SIZE,
18: FUNCTIONAL_NAME,
19: TRADE_ITEM_FORM_DESCRIPTION,

Line 31: from EGO_GTN_ATTR_CHG_TL B

27: B.TRADE_ITEM_FORM_DESCRIPTION,
28: B.WARRANTY_DESCRIPTION,
29: B.TRADE_ITEM_FINISH_DESCRIPTION,
30: B.DESCRIPTION_SHORT
31: from EGO_GTN_ATTR_CHG_TL B
32: where B.EXTENSION_ID = T.EXTENSION_ID
33: and B.LANGUAGE = T.SOURCE_LANG)
34: where (
35: T.EXTENSION_ID,

Line 40: from EGO_GTN_ATTR_CHG_TL SUBB, EGO_GTN_ATTR_CHG_TL SUBT

36: T.LANGUAGE
37: ) in (select
38: SUBT.EXTENSION_ID,
39: SUBT.LANGUAGE
40: from EGO_GTN_ATTR_CHG_TL SUBB, EGO_GTN_ATTR_CHG_TL SUBT
41: where SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
42: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
43: and (SUBB.INVOICE_NAME <> SUBT.INVOICE_NAME
44: or (SUBB.INVOICE_NAME is null and SUBT.INVOICE_NAME is not null)

Line 66: insert into EGO_GTN_ATTR_CHG_TL (

62: or (SUBB.DESCRIPTION_SHORT is null and SUBT.DESCRIPTION_SHORT is not null)
63: or (SUBB.DESCRIPTION_SHORT is not null and SUBT.DESCRIPTION_SHORT is null)
64: ));
65:
66: insert into EGO_GTN_ATTR_CHG_TL (
67: EXTENSION_ID,
68: INVENTORY_ITEM_ID,
69: ORGANIZATION_ID,
70: CREATED_BY,

Line 114: from EGO_GTN_ATTR_CHG_TL B, FND_LANGUAGES L

110: B.CHANGE_ID,
111: B.CHANGE_LINE_ID,
112: B.IMPLEMENTATION_DATE,
113: B.ACD_TYPE
114: from EGO_GTN_ATTR_CHG_TL B, FND_LANGUAGES L
115: where L.INSTALLED_FLAG in ('I', 'B')
116: and B.LANGUAGE = userenv('LANG')
117: and not exists
118: (select NULL

Line 119: from EGO_GTN_ATTR_CHG_TL T

115: where L.INSTALLED_FLAG in ('I', 'B')
116: and B.LANGUAGE = userenv('LANG')
117: and not exists
118: (select NULL
119: from EGO_GTN_ATTR_CHG_TL T
120: where T.EXTENSION_ID = B.EXTENSION_ID
121: and T.LANGUAGE = L.LANGUAGE_CODE);
122: end ADD_LANGUAGE;
123: