678: end application_short_name;
679:
680: -- BASE_LANGUAGE -
681: function base_language return varchar2 is
682: buffer fnd_languages.language_code%type := get(FND_CONST.BASE_LANGUAGE);
683: begin
684: if buffer is null then
685:
686: select language_code
684: if buffer is null then
685:
686: select language_code
687: into buffer
688: from fnd_languages
689: where installed_flag = 'B';
690:
691: put_nosys(FND_CONST.BASE_LANGUAGE,buffer);
692: end if;
769: if buffer is null then
770:
771: select count(1)
772: into buffer
773: from fnd_languages
774: where installed_flag in ('I', 'B');
775:
776: put_nosys(FND_CONST.LANGUAGE_COUNT,to_char(buffer));
777: end if;
1279: /*
1280: select nls_date_language
1281: into v_nls_date_language
1282: from (select utf8_date_language nls_date_language
1283: from fnd_languages
1284: where nls_charset_name(nls_charset_id('CHAR_CS'))
1285: in ('UTF8', 'AL32UTF8')
1286: and installed_flag <>'D'
1287: and nls_language = t_nls_date_language
1286: and installed_flag <>'D'
1287: and nls_language = t_nls_date_language
1288: union
1289: select local_date_language nls_date_language
1290: from fnd_languages
1291: where nls_charset_name(nls_charset_id('CHAR_CS'))
1292: not in ('UTF8', 'AL32UTF8')
1293: and installed_flag <>'D'
1294: and nls_language = t_nls_date_language);
1307: 'AL32UTF8', fl.utf8_date_language,
1308: fl.local_date_language
1309: ) data_rtn
1310: into v_nls_date_language
1311: from fnd_languages fl
1312: where fl.nls_language = t_nls_date_language
1313: and fl.installed_flag <>'D' ;
1314:
1315: if debug_to_core then