DBA Data[Home] [Help]

APPS.IBW_CONTEXT_INTERFACE_PVT dependencies on IBW_CONTEXT_INTERFACE_TL

Line 11: delete from IBW_CONTEXT_INTERFACE_TL T

7:
8: procedure ADD_LANGUAGE
9: is
10: begin
11: delete from IBW_CONTEXT_INTERFACE_TL T
12: where not exists
13: (select NULL
14: from IBW_CONTEXT_INTERFACE_B B
15: where B.CONTEXT_INTERFACE_ID = T.CONTEXT_INTERFACE_ID

Line 18: update IBW_CONTEXT_INTERFACE_TL T set (

14: from IBW_CONTEXT_INTERFACE_B B
15: where B.CONTEXT_INTERFACE_ID = T.CONTEXT_INTERFACE_ID
16: );
17:
18: update IBW_CONTEXT_INTERFACE_TL T set (
19: CONTEXT_INSTANCE_NAME
20: ) = (select
21: B.CONTEXT_INSTANCE_NAME
22: from IBW_CONTEXT_INTERFACE_TL B

Line 22: from IBW_CONTEXT_INTERFACE_TL B

18: update IBW_CONTEXT_INTERFACE_TL T set (
19: CONTEXT_INSTANCE_NAME
20: ) = (select
21: B.CONTEXT_INSTANCE_NAME
22: from IBW_CONTEXT_INTERFACE_TL B
23: where B.CONTEXT_INTERFACE_ID = T.CONTEXT_INTERFACE_ID
24: and B.LANGUAGE = T.SOURCE_LANG)
25: where (
26: T.CONTEXT_INTERFACE_ID,

Line 31: from IBW_CONTEXT_INTERFACE_TL SUBB, IBW_CONTEXT_INTERFACE_TL SUBT

27: T.LANGUAGE
28: ) in (select
29: SUBT.CONTEXT_INTERFACE_ID,
30: SUBT.LANGUAGE
31: from IBW_CONTEXT_INTERFACE_TL SUBB, IBW_CONTEXT_INTERFACE_TL SUBT
32: where SUBB.CONTEXT_INTERFACE_ID = SUBT.CONTEXT_INTERFACE_ID
33: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
34: and (SUBB.CONTEXT_INSTANCE_NAME <> SUBT.CONTEXT_INSTANCE_NAME
35: ));

Line 37: insert into IBW_CONTEXT_INTERFACE_TL (

33: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
34: and (SUBB.CONTEXT_INSTANCE_NAME <> SUBT.CONTEXT_INSTANCE_NAME
35: ));
36:
37: insert into IBW_CONTEXT_INTERFACE_TL (
38: LAST_UPDATE_DATE,
39: LAST_UPDATE_LOGIN,
40: PROGRAM_ID,
41: PROGRAM_LOGIN_ID,

Line 67: from IBW_CONTEXT_INTERFACE_TL B, FND_LANGUAGES L

63: B.CREATION_DATE,
64: B.CONTEXT_INTERFACE_ID,
65: L.LANGUAGE_CODE,
66: B.SOURCE_LANG
67: from IBW_CONTEXT_INTERFACE_TL B, FND_LANGUAGES L
68: where L.INSTALLED_FLAG in ('I', 'B')
69: and B.LANGUAGE = userenv('LANG')
70: and not exists
71: (select NULL

Line 72: from IBW_CONTEXT_INTERFACE_TL T

68: where L.INSTALLED_FLAG in ('I', 'B')
69: and B.LANGUAGE = userenv('LANG')
70: and not exists
71: (select NULL
72: from IBW_CONTEXT_INTERFACE_TL T
73: where T.CONTEXT_INTERFACE_ID = B.CONTEXT_INTERFACE_ID
74: and T.LANGUAGE = L.LANGUAGE_CODE);
75: end ADD_LANGUAGE;
76: