APPS.EGO_ITM_GTN_MUL_CHG_ATTRS_PKG dependencies on EGO_GTN_MUL_ATTR_CHG_TL

Line 7: delete from EGO_GTN_MUL_ATTR_CHG_TL T

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

Line 14: update EGO_GTN_MUL_ATTR_CHG_TL T set (

10: from EGO_GTN_MUL_ATTR_CHG_B B
11: where B.EXTENSION_ID = T.EXTENSION_ID
12: );
13:
14: update EGO_GTN_MUL_ATTR_CHG_TL T set (
15: HANDLING_INSTRUCTIONS_CODE,
16: DANGEROUS_GOODS_TECHNICAL_NAME
17: ) = (select
18: B.HANDLING_INSTRUCTIONS_CODE,

Line 20: from EGO_GTN_MUL_ATTR_CHG_TL B

16: DANGEROUS_GOODS_TECHNICAL_NAME
17: ) = (select
18: B.HANDLING_INSTRUCTIONS_CODE,
19: B.DANGEROUS_GOODS_TECHNICAL_NAME
20: from EGO_GTN_MUL_ATTR_CHG_TL B
21: where B.EXTENSION_ID = T.EXTENSION_ID
22: and B.LANGUAGE = T.SOURCE_LANG)
23: where (
24: T.EXTENSION_ID,

Line 29: from EGO_GTN_MUL_ATTR_CHG_TL SUBB, EGO_GTN_MUL_ATTR_CHG_TL SUBT

25: T.LANGUAGE
26: ) in (select
27: SUBT.EXTENSION_ID,
28: SUBT.LANGUAGE
29: from EGO_GTN_MUL_ATTR_CHG_TL SUBB, EGO_GTN_MUL_ATTR_CHG_TL SUBT
30: where SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
31: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
32: and (SUBB.HANDLING_INSTRUCTIONS_CODE <> SUBT.HANDLING_INSTRUCTIONS_CODE
33: or (SUBB.HANDLING_INSTRUCTIONS_CODE is null and SUBT.HANDLING_INSTRUCTIONS_CODE is not null)

Line 40: insert into EGO_GTN_MUL_ATTR_CHG_TL (

36: or (SUBB.DANGEROUS_GOODS_TECHNICAL_NAME is null and SUBT.DANGEROUS_GOODS_TECHNICAL_NAME is not null)
37: or (SUBB.DANGEROUS_GOODS_TECHNICAL_NAME is not null and SUBT.DANGEROUS_GOODS_TECHNICAL_NAME is null)
38: ));
39:
40: insert into EGO_GTN_MUL_ATTR_CHG_TL (
41: EXTENSION_ID,
42: INVENTORY_ITEM_ID,
43: ORGANIZATION_ID,
44: ATTR_GROUP_ID,

Line 80: from EGO_GTN_MUL_ATTR_CHG_TL B, FND_LANGUAGES L

76: B.CHANGE_ID,
77: B.CHANGE_LINE_ID,
78: B.IMPLEMENTATION_DATE,
79: B.ACD_TYPE
80: from EGO_GTN_MUL_ATTR_CHG_TL B, FND_LANGUAGES L
81: where L.INSTALLED_FLAG in ('I', 'B')
82: and B.LANGUAGE = userenv('LANG')
83: and not exists
84: (select NULL

Line 85: from EGO_GTN_MUL_ATTR_CHG_TL T

81: where L.INSTALLED_FLAG in ('I', 'B')
82: and B.LANGUAGE = userenv('LANG')
83: and not exists
84: (select NULL
85: from EGO_GTN_MUL_ATTR_CHG_TL T
86: where T.EXTENSION_ID = B.EXTENSION_ID
87: and T.LANGUAGE = L.LANGUAGE_CODE);
88: end ADD_LANGUAGE;
89: