APPS.FND_OAM_DSCRAM dependencies on FND_LANGUAGES

Line 65: from FND_LANGUAGES L

61: select
62: policyid,insert_policy.pname,insert_policy.l_description, insert_policy.l_created_by,
63: sysdate, insert_policy.l_last_updated_by, sysdate, insert_policy.l_last_update_login,
64: l.language_code, userenv('LANG')
65: from FND_LANGUAGES L
66: where L.INSTALLED_FLAG in ('I', 'B')
67: and not exists
68: (select NULL
69: from FND_OAM_DS_POLICIES_TL T

Line 108: from fnd_languages l

104: /* Make sure no bad data in tl table */
105: delete from FND_OAM_DS_POLICIES_TL
106: where policy_id = policyid
107: and language in (select l.language_code
108: from fnd_languages l
109: where l.installed_flag in ('I', 'B'));
110:
111:
112: insert into FND_OAM_DS_POLICIES_TL (

Line 128: from FND_LANGUAGES L

124: select
125: update_policy.policyid,update_policy.pname,update_policy.l_description, update_policy.l_last_update_login,
126: sysdate, update_policy.l_last_updated_by, sysdate, update_policy.l_last_update_login,
127: l.language_code, userenv('LANG')
128: from FND_LANGUAGES L
129: where L.INSTALLED_FLAG in ('I', 'B')
130: and not exists
131: (select NULL
132: from FND_OAM_DS_POLICIES_TL T

Line 201: from FND_LANGUAGES L

197: insert_policyset.l_created_by,
198: sysdate, insert_policyset.l_last_updated_by, sysdate,
199: insert_policyset.l_last_update_login,
200: l.language_code, userenv('LANG')
201: from FND_LANGUAGES L
202: where L.INSTALLED_FLAG in ('I', 'B')
203: and not exists
204: (select NULL
205: from FND_OAM_DS_PSETS_TL T

Line 243: from fnd_languages l

239: /* Make sure no bad data in tl table */
240: delete from FND_OAM_DS_PSETS_TL
241: where policyset_id = psetid
242: and language in (select l.language_code
243: from fnd_languages l
244: where l.installed_flag in ('I', 'B'));
245:
246:
247: insert into FND_OAM_DS_PSETS_TL (

Line 265: from FND_LANGUAGES L

261: update_policyset.l_last_update_login,
262: sysdate, update_policyset.l_last_updated_by, sysdate,
263: update_policyset.l_last_update_login,
264: l.language_code, userenv('LANG')
265: from FND_LANGUAGES L
266: where L.INSTALLED_FLAG in ('I', 'B')
267: and not exists
268: (select NULL
269: from FND_OAM_DS_PSETS_TL T

Line 775: from FND_LANGUAGES L

771: sysdate,
772: insert_pii_attribute.l_last_update_login,
773: l.language_code,
774: userenv('LANG')
775: from FND_LANGUAGES L
776: where L.INSTALLED_FLAG in ('I', 'B')
777: and not exists
778: (select NULL
779: from FND_PRIVACY_ATTRIBUTES_TL T

Line 876: from FND_LANGUAGES L

872: sysdate,
873: update_pii_attribute.l_last_update_login,
874: l.language_code,
875: userenv('LANG')
876: from FND_LANGUAGES L
877: where L.INSTALLED_FLAG in ('I', 'B')
878: and not exists
879: (select NULL
880: from FND_PRIVACY_ATTRIBUTES_TL T