APPS.FEM_REFRESH_ENG_PKG dependencies on FND_LANGUAGES

Line 387: v_base_lang FND_LANGUAGES.language_code%type;

383: -- name being processed - used by the exception
384: -- handler
385:
386: -- language variables
387: v_base_lang FND_LANGUAGES.language_code%type;
388: v_lang_start NUMBER;
389: v_subdir_length NUMBER;
390: v_subdir_lang FND_LANGUAGES.language_code%type;
391: v_subdir_lang_length NUMBER;

Line 390: v_subdir_lang FND_LANGUAGES.language_code%type;

386: -- language variables
387: v_base_lang FND_LANGUAGES.language_code%type;
388: v_lang_start NUMBER;
389: v_subdir_length NUMBER;
390: v_subdir_lang FND_LANGUAGES.language_code%type;
391: v_subdir_lang_length NUMBER;
392:
393: -- output variables for the wait_for_request function
394: f_req_wait BOOLEAN; -- return of the wait_for_request function

Line 438: -- if there is some error with FND_LANGUAGES, we will

434: BEGIN
435: x_execution_status := 'SUCCESS';
436:
437: -- Identify the base language
438: -- if there is some error with FND_LANGUAGES, we will
439: -- set the base langauge = to the env language of the
440: -- user running the refresh
441: BEGIN
442:

Line 445: FROM fnd_languages

441: BEGIN
442:
443: SELECT language_code
444: INTO v_base_lang
445: FROM fnd_languages
446: WHERE installed_flag = 'B';
447: EXCEPTION
448: WHEN OTHERS THEN
449: SELECT userenv('LANG')