587: FND_GLOBAL.conc_login_id,
588: USERENV('LANG'),
589: l_deliv_rec.deliverable_name,
590: l_deliv_rec.description
591: FROM fnd_languages l
592: WHERE l.installed_flag in ('I', 'B')
593: AND NOT EXISTS(
594: SELECT NULL
595: FROM ams_deliverables_all_tl t
2770: IF p_deliv_rec.language_code <> FND_API.g_miss_char
2771: AND p_deliv_rec.language_code IS NOT NULL
2772: THEN
2773: IF AMS_Utility_PVT.check_fk_exists(
2774: 'fnd_languages',
2775: 'language_code',
2776: p_deliv_rec.language_code,
2777: AMS_Utility_PVT.g_varchar2,
2778: NULL