APPS.IEX_APP_PREFERENCES_PKG dependencies on IEX_APP_PREFERENCES_TL

Line 9: delete from IEX_APP_PREFERENCES_TL T

5:
6: procedure ADD_LANGUAGE
7: is
8: begin
9: delete from IEX_APP_PREFERENCES_TL T
10: where not exists
11: (select NULL
12: from IEX_APP_PREFERENCES_B B
13: where B.PREFERENCE_ID = T.PREFERENCE_ID

Line 16: update IEX_APP_PREFERENCES_TL T

12: from IEX_APP_PREFERENCES_B B
13: where B.PREFERENCE_ID = T.PREFERENCE_ID
14: );
15:
16: update IEX_APP_PREFERENCES_TL T
17: set (USER_NAME) =
18: (select B.USER_NAME
19: from IEX_APP_PREFERENCES_TL B
20: where B.PREFERENCE_ID = T.PREFERENCE_ID

Line 19: from IEX_APP_PREFERENCES_TL B

15:
16: update IEX_APP_PREFERENCES_TL T
17: set (USER_NAME) =
18: (select B.USER_NAME
19: from IEX_APP_PREFERENCES_TL B
20: where B.PREFERENCE_ID = T.PREFERENCE_ID
21: and B.LANGUAGE = T.SOURCE_LANG)
22: where (
23: T.PREFERENCE_ID,T.LANGUAGE

Line 27: from IEX_APP_PREFERENCES_TL SUBB,

23: T.PREFERENCE_ID,T.LANGUAGE
24: ) in (select
25: SUBT.PREFERENCE_ID,
26: SUBT.LANGUAGE
27: from IEX_APP_PREFERENCES_TL SUBB,
28: IEX_APP_PREFERENCES_TL SUBT
29: where SUBB.PREFERENCE_ID = SUBT.PREFERENCE_ID
30: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
31: and SUBB.USER_NAME<> SUBT.USER_NAME

Line 28: IEX_APP_PREFERENCES_TL SUBT

24: ) in (select
25: SUBT.PREFERENCE_ID,
26: SUBT.LANGUAGE
27: from IEX_APP_PREFERENCES_TL SUBB,
28: IEX_APP_PREFERENCES_TL SUBT
29: where SUBB.PREFERENCE_ID = SUBT.PREFERENCE_ID
30: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
31: and SUBB.USER_NAME<> SUBT.USER_NAME
32: OR (SUBB.USER_NAME IS NULL AND SUBT.USER_NAME IS NOT NULL)

Line 36: insert into IEX_APP_PREFERENCES_TL (

32: OR (SUBB.USER_NAME IS NULL AND SUBT.USER_NAME IS NOT NULL)
33: OR (SUBB.USER_NAME IS NOT NULL AND SUBT.USER_NAME IS NULL)
34: );
35:
36: insert into IEX_APP_PREFERENCES_TL (
37: PREFERENCE_ID,
38: USER_NAME,
39: LAST_UPDATE_DATE,
40: LAST_UPDATED_BY,

Line 56: from IEX_APP_PREFERENCES_TL B, FND_LANGUAGES L

52: B.CREATED_BY,
53: B.LAST_UPDATE_LOGIN,
54: L.LANGUAGE_CODE,
55: B.SOURCE_LANG
56: from IEX_APP_PREFERENCES_TL B, FND_LANGUAGES L
57: where L.INSTALLED_FLAG in ('I', 'B')
58: and B.LANGUAGE = userenv('LANG')
59: and not exists
60: (select NULL

Line 61: from IEX_APP_PREFERENCES_TL T

57: where L.INSTALLED_FLAG in ('I', 'B')
58: and B.LANGUAGE = userenv('LANG')
59: and not exists
60: (select NULL
61: from IEX_APP_PREFERENCES_TL T
62: where T.PREFERENCE_ID = B.PREFERENCE_ID
63: and T.LANGUAGE = L.LANGUAGE_CODE);
64:
65: end ADD_LANGUAGE;

Line 76: UPDATE IEX_APP_PREFERENCES_TL SET

72: X_OWNER in VARCHAR2
73: ) IS
74:
75: begin
76: UPDATE IEX_APP_PREFERENCES_TL SET
77: USER_NAME=X_USER_NAME,
78: last_update_date = sysdate,
79: last_updated_by = decode(X_OWNER, 'SEED', 1, 0),
80: last_update_login = 0,