APPS.FND_REQUEST dependencies on FND_LANGUAGES

Line 788: Select count(*) into lang_exists from FND_LANGUAGES L

784: -- modified by ddhulla to check if the language passed by user is valid language
785: -- if the language specified is invalid raise nls_error
786: begin
787:
788: Select count(*) into lang_exists from FND_LANGUAGES L
789: where NLS_LANGUAGE = P_LANGUAGE and
790: L.INSTALLED_FLAG in ('I', 'B');
791:
792: if ( lang_exists = 0 ) then

Line 818: Select count(*) into lang_exists from FND_LANGUAGES L

814:
815: -- modified by ddhulla to check if the language passed by user is valid language
816: begin
817:
818: Select count(*) into lang_exists from FND_LANGUAGES L
819: where NLS_LANGUAGE = P_LANGUAGE and
820: L.INSTALLED_FLAG in ('I', 'B');
821:
822: if ( lang_exists = 0 ) then

Line 1882: from FND_LANGUAGES L

1878: 'Request - '|| cur_request_id,
1879: Sysdate,
1880: submit.user_id, loginid,
1881: Sysdate, submit.user_id
1882: from FND_LANGUAGES L
1883: where L.INSTALLED_FLAG in ('I', 'B');
1884:
1885: if (sql%rowcount = 0) then
1886: raise relclass_insert_error;

Line 2139: from fnd_languages

2135: if ( language is not null ) then
2136: begin
2137: select nls_language
2138: into dummy_val
2139: from fnd_languages
2140: where nls_language = upper(language);
2141: exception
2142: when no_data_found then
2143: raise nls_error;

Line 3843: FROM FND_LANGUAGES L

3839: SELECT P_RELEASE_CLASS_APP_ID, P_RELEASE_CLASS_ID,
3840: L.LANGUAGE_CODE, USERENV('LANG'), P_RELEASE_CLASS_NAME,
3841: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
3842: SYSDATE, FND_GLOBAL.USER_ID, P_DESCRIPTION
3843: FROM FND_LANGUAGES L
3844: WHERE L.INSTALLED_FLAG in ('I', 'B');
3845:
3846: if (sql%rowcount = 0) then
3847: raise RELCLASS_INSERT_ERROR;