DBA Data[Home] [Help]

APPS.JTF_MSITE_GRP dependencies on FND_LANGUAGES

Line 141: select language_code from fnd_languages_vl where

137: RETURN BOOLEAN
138: IS
139: CURSOR valid_language_cur(p_language varchar2) IS
140: select 1 from dual where exists (
141: select language_code from fnd_languages_vl where
142: language_code = p_language);
143: l_exists NUMBER;
144: l_return_status Boolean := true;
145:

Line 615: from FND_LANGUAGES L

611: p_msite_rec.Display_name,
612: p_msite_rec.description,
613: L.LANGUAGE_CODE,
614: userenv('LANG')
615: from FND_LANGUAGES L
616: where L.INSTALLED_FLAG in ('I', 'B')
617: and not exists(
618: select NULL
619: from JTF_MSITES_TL T

Line 1895: from FND_LANGUAGES L

1891: X_MSITE_NAME,
1892: X_MSITE_DESCRIPTION,
1893: L.LANGUAGE_CODE,
1894: userenv('LANG')
1895: from FND_LANGUAGES L
1896: where L.INSTALLED_FLAG in ('I', 'B')
1897: and not exists
1898: (select NULL
1899: from JTF_MSITES_TL T

Line 2492: from JTF_MSITES_TL B, FND_LANGUAGES L

2488: B.MSITE_NAME,
2489: B.MSITE_DESCRIPTION,
2490: L.LANGUAGE_CODE,
2491: B.SOURCE_LANG
2492: from JTF_MSITES_TL B, FND_LANGUAGES L
2493: where L.INSTALLED_FLAG in ('I', 'B')
2494: and B.LANGUAGE = userenv('LANG')
2495: and not exists
2496: (select NULL