APPS.OKS_RENEW_UTIL_PVT dependencies on FND_LANGUAGES

Line 1551: Returns fnd_languages's language code.

1547: so that external api call is avoided.
1548: : p_template_language IN VARCHAR2 Required
1549: Language defined in GCD if availble to avoid api call
1550: OUT : x_fnd_language OUT VARCHAR2
1551: Returns fnd_languages's language code.
1552: : x_fnd_iso_language OUT VARCHAR2
1553: Returns fnd_language's iso_language
1554: : x_fnd_iso_territory OUT VARCHAR2
1555: Returns fnd_language's iso_territory

Line 1588: FROM fnd_languages

1584: l_api_name CONSTANT VARCHAR2(50) := 'get_language_info';
1585:
1586: CURSOR l_fnd_lang_terr_csr (p_lang VARCHAR2) IS
1587: SELECT lower(iso_language), iso_territory
1588: FROM fnd_languages
1589: WHERE language_code = p_lang;
1590:
1591: --cgopinee bugfix for 6802038
1592: CURSOR l_template_def_lang_csr (p_template_id NUMBER) IS

Line 1596: FROM fnd_languages a, xdo_templates_b b

1592: CURSOR l_template_def_lang_csr (p_template_id NUMBER) IS
1593: SELECT CASE WHEN a.installed_flag = 'D' THEN 'US' ELSE a.language_code END language_code,
1594: CASE WHEN a.installed_flag = 'D' THEN 'en' ELSE b.default_language END default_language,
1595: CASE WHEN a.installed_flag = 'D' THEN '00' ELSE b.default_territory END default_territory
1596: FROM fnd_languages a, xdo_templates_b b
1597: WHERE a.iso_language = upper(b.default_language)
1598: AND b.template_id = p_template_id
1599: AND (a.iso_territory = b.default_territory
1600: OR (b.default_territory = '00' and a.installed_flag IN ('B','I','D')))