APPS.AMW_AUDIT_PROJECTS_PKG dependencies on AMW_AUDIT_PROJECTS_TL

Line 8: delete from AMW_AUDIT_PROJECTS_TL T

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

Line 15: update AMW_AUDIT_PROJECTS_TL T set (

11: from AMW_AUDIT_PROJECTS B
12: where B.AUDIT_PROJECT_ID = T.AUDIT_PROJECT_ID
13: );
14:
15: update AMW_AUDIT_PROJECTS_TL T set (
16: NAME,
17: DESCRIPTION
18: ) = (select
19: B.NAME,

Line 21: from AMW_AUDIT_PROJECTS_TL B

17: DESCRIPTION
18: ) = (select
19: B.NAME,
20: B.DESCRIPTION
21: from AMW_AUDIT_PROJECTS_TL B
22: where B.AUDIT_PROJECT_ID = T.AUDIT_PROJECT_ID
23: and B.LANGUAGE = T.SOURCE_LANG)
24: where (
25: T.AUDIT_PROJECT_ID,

Line 30: from AMW_AUDIT_PROJECTS_TL SUBB, AMW_AUDIT_PROJECTS_TL SUBT

26: T.LANGUAGE
27: ) in (select
28: SUBT.AUDIT_PROJECT_ID,
29: SUBT.LANGUAGE
30: from AMW_AUDIT_PROJECTS_TL SUBB, AMW_AUDIT_PROJECTS_TL SUBT
31: where SUBB.AUDIT_PROJECT_ID = SUBT.AUDIT_PROJECT_ID
32: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
33: and (SUBB.NAME <> SUBT.NAME
34: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 39: insert into AMW_AUDIT_PROJECTS_TL (

35: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
36: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
37: ));
38:
39: insert into AMW_AUDIT_PROJECTS_TL (
40: OBJECT_VERSION_NUMBER,
41: LAST_UPDATED_BY,
42: LAST_UPDATE_DATE,
43: CREATED_BY,

Line 63: from AMW_AUDIT_PROJECTS_TL B, FND_LANGUAGES L

59: B.LAST_UPDATE_LOGIN,
60: B.AUDIT_PROJECT_ID,
61: B.NAME,
62: L.LANGUAGE_CODE
63: from AMW_AUDIT_PROJECTS_TL B, FND_LANGUAGES L
64: where L.INSTALLED_FLAG in ('I', 'B')
65: and B.LANGUAGE = userenv('LANG')
66: and not exists
67: (select NULL

Line 68: from AMW_AUDIT_PROJECTS_TL T

64: where L.INSTALLED_FLAG in ('I', 'B')
65: and B.LANGUAGE = userenv('LANG')
66: and not exists
67: (select NULL
68: from AMW_AUDIT_PROJECTS_TL T
69: where T.AUDIT_PROJECT_ID = B.AUDIT_PROJECT_ID
70: and T.LANGUAGE = L.LANGUAGE_CODE);
71: end ADD_LANGUAGE;
72: