APPS.AMW_CTRL_EXT_PKG dependencies on AMW_CTRL_EXT_TL

Line 8: delete from AMW_CTRL_EXT_TL T

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

Line 15: update AMW_CTRL_EXT_TL T set (

11: from AMW_CTRL_EXT_B B
12: where B.EXTENSION_ID = T.EXTENSION_ID
13: );
14:
15: update AMW_CTRL_EXT_TL T set (
16: TL_EXT_ATTR1,TL_EXT_ATTR2,TL_EXT_ATTR3,TL_EXT_ATTR4,TL_EXT_ATTR5,
17: TL_EXT_ATTR6,TL_EXT_ATTR7,TL_EXT_ATTR8,TL_EXT_ATTR9,TL_EXT_ATTR10,
18: TL_EXT_ATTR11,TL_EXT_ATTR12,TL_EXT_ATTR13,TL_EXT_ATTR14,TL_EXT_ATTR15,
19: TL_EXT_ATTR16,TL_EXT_ATTR17,TL_EXT_ATTR18,TL_EXT_ATTR19,TL_EXT_ATTR20,

Line 33: from AMW_CTRL_EXT_TL B

29: B.TL_EXT_ATTR21,B.TL_EXT_ATTR22,B.TL_EXT_ATTR23,B.TL_EXT_ATTR24,B.TL_EXT_ATTR25,
30: B.TL_EXT_ATTR26,B.TL_EXT_ATTR27,B.TL_EXT_ATTR28,B.TL_EXT_ATTR29,B.TL_EXT_ATTR30,
31: B.TL_EXT_ATTR31,B.TL_EXT_ATTR32,B.TL_EXT_ATTR33,B.TL_EXT_ATTR34,B.TL_EXT_ATTR35,
32: B.TL_EXT_ATTR36,B.TL_EXT_ATTR37,B.TL_EXT_ATTR38,B.TL_EXT_ATTR39,B.TL_EXT_ATTR40
33: from AMW_CTRL_EXT_TL B
34: where B.EXTENSION_ID = T.EXTENSION_ID
35: and B.LANGUAGE = T.SOURCE_LANG)
36: where (
37: T.EXTENSION_ID,

Line 42: from AMW_CTRL_EXT_TL SUBB, AMW_CTRL_EXT_TL SUBT

38: T.LANGUAGE
39: ) in (select
40: SUBT.EXTENSION_ID,
41: SUBT.LANGUAGE
42: from AMW_CTRL_EXT_TL SUBB, AMW_CTRL_EXT_TL SUBT
43: where SUBB.EXTENSION_ID = SUBT.EXTENSION_ID
44: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
45: and (SUBB.TL_EXT_ATTR1 <> SUBT.TL_EXT_ATTR1
46: or (SUBB.TL_EXT_ATTR1 is null and SUBT.TL_EXT_ATTR1 is not null)

Line 167: insert into AMW_CTRL_EXT_TL (

163: or (SUBB.TL_EXT_ATTR40 is null and SUBT.TL_EXT_ATTR40 is not null)
164: or (SUBB.TL_EXT_ATTR40 is not null and SUBT.TL_EXT_ATTR40 is null)
165: ));
166:
167: insert into AMW_CTRL_EXT_TL (
168: LANGUAGE,
169: SOURCE_LANG,
170: LAST_UPDATED_BY,
171: LAST_UPDATE_DATE,

Line 211: from AMW_CTRL_EXT_TL B, FND_LANGUAGES L

207: B.TL_EXT_ATTR21,B.TL_EXT_ATTR22,B.TL_EXT_ATTR23,B.TL_EXT_ATTR24,B.TL_EXT_ATTR25,
208: B.TL_EXT_ATTR26,B.TL_EXT_ATTR27,B.TL_EXT_ATTR28,B.TL_EXT_ATTR29,B.TL_EXT_ATTR30,
209: B.TL_EXT_ATTR31,B.TL_EXT_ATTR32,B.TL_EXT_ATTR33,B.TL_EXT_ATTR34,B.TL_EXT_ATTR35,
210: B.TL_EXT_ATTR36,B.TL_EXT_ATTR37,B.TL_EXT_ATTR38,B.TL_EXT_ATTR39,B.TL_EXT_ATTR40
211: from AMW_CTRL_EXT_TL B, FND_LANGUAGES L
212: where L.INSTALLED_FLAG in ('I', 'B')
213: and B.LANGUAGE = userenv('LANG')
214: and not exists
215: (select NULL

Line 216: from AMW_CTRL_EXT_TL T

212: where L.INSTALLED_FLAG in ('I', 'B')
213: and B.LANGUAGE = userenv('LANG')
214: and not exists
215: (select NULL
216: from AMW_CTRL_EXT_TL T
217: where T.EXTENSION_ID = B.EXTENSION_ID
218: and T.LANGUAGE = L.LANGUAGE_CODE);
219: end ADD_LANGUAGE;
220: