APPS.FND_REQUEST dependencies on FND_LANGUAGES

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

828: -- modified by ddhulla to check if the language passed by user is valid language
829: -- if the language specified is invalid raise nls_error
830: begin
831:
832: Select count(*) into lang_exists from FND_LANGUAGES L
833: where NLS_LANGUAGE = P_LANGUAGE and
834: L.INSTALLED_FLAG in ('I', 'B');
835:
836: if ( lang_exists = 0 ) then

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

858:
859: -- modified by ddhulla to check if the language passed by user is valid language
860: begin
861:
862: Select count(*) into lang_exists from FND_LANGUAGES L
863: where NLS_LANGUAGE = P_LANGUAGE and
864: L.INSTALLED_FLAG in ('I', 'B');
865:
866: if ( lang_exists = 0 ) then

Line 1987: from FND_LANGUAGES L

1983: 'Request - '|| cur_request_id,
1984: Sysdate,
1985: submit.user_id, loginid,
1986: Sysdate, submit.user_id
1987: from FND_LANGUAGES L
1988: where L.INSTALLED_FLAG in ('I', 'B');
1989:
1990: if (sql%rowcount = 0) then
1991: raise relclass_insert_error;

Line 2683: from fnd_languages

2679: if ( language is not null ) then
2680: begin
2681: select nls_language
2682: into dummy_val
2683: from fnd_languages
2684: where nls_language = upper(language);
2685: exception
2686: when no_data_found then
2687: raise nls_error;

Line 4531: FROM FND_LANGUAGES L

4527: SELECT P_RELEASE_CLASS_APP_ID, P_RELEASE_CLASS_ID,
4528: L.LANGUAGE_CODE, USERENV('LANG'), P_RELEASE_CLASS_NAME,
4529: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID,
4530: SYSDATE, FND_GLOBAL.USER_ID, P_DESCRIPTION
4531: FROM FND_LANGUAGES L
4532: WHERE L.INSTALLED_FLAG in ('I', 'B');
4533:
4534: if (sql%rowcount = 0) then
4535: raise RELCLASS_INSERT_ERROR;