APPS.JTF_SE_AUTHPERMS dependencies on JTF_AUTH_PERMISSIONS_TL

Line 7: delete from JTF_AUTH_PERMISSIONS_TL T

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

Line 14: update JTF_AUTH_PERMISSIONS_TL T set (

10: from JTF_AUTH_PERMISSIONS_B B
11: where B.PERMISSION_DESC_ID = T.PERMISSION_DESC_ID
12: );
13:
14: update JTF_AUTH_PERMISSIONS_TL T set (
15: PERMISSION_DESC,
16: LAST_UPDATED_BY,
17: LAST_UPDATE_DATE,
18: LAST_UPDATE_LOGIN

Line 24: from JTF_AUTH_PERMISSIONS_TL B

20: B.PERMISSION_DESC,
21: FND_GLOBAL.user_id,
22: sysdate,
23: FND_GLOBAL.user_id
24: from JTF_AUTH_PERMISSIONS_TL B
25: where B.PERMISSION_DESC_ID = T.PERMISSION_DESC_ID
26: and B.LANGUAGE = T.SOURCE_LANG
27: )
28: where (

Line 34: from JTF_AUTH_PERMISSIONS_TL SUBB, JTF_AUTH_PERMISSIONS_TL SUBT

30: T.LANGUAGE
31: ) in (select
32: SUBT.PERMISSION_DESC_ID,
33: SUBT.LANGUAGE
34: from JTF_AUTH_PERMISSIONS_TL SUBB, JTF_AUTH_PERMISSIONS_TL SUBT
35: where SUBB.PERMISSION_DESC_ID = SUBT.PERMISSION_DESC_ID
36: and SUBB.LANGUAGE = SUBT.SOURCE_LANG );
37:
38: insert into JTF_AUTH_PERMISSIONS_TL (

Line 38: insert into JTF_AUTH_PERMISSIONS_TL (

34: from JTF_AUTH_PERMISSIONS_TL SUBB, JTF_AUTH_PERMISSIONS_TL SUBT
35: where SUBB.PERMISSION_DESC_ID = SUBT.PERMISSION_DESC_ID
36: and SUBB.LANGUAGE = SUBT.SOURCE_LANG );
37:
38: insert into JTF_AUTH_PERMISSIONS_TL (
39: PERMISSION_DESC_ID,
40: PERMISSION_DESC,
41: LAST_UPDATE_DATE,
42: LAST_UPDATED_BY,

Line 58: from JTF_AUTH_PERMISSIONS_TL B, FND_LANGUAGES L

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

Line 63: from JTF_AUTH_PERMISSIONS_TL T

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