APPS.FND_MLS_REQUEST dependencies on FND_LANGUAGES

Line 384: fnd_languages, otherwise use user environment */

380: -- 12.1 NEW MLS Function Str with optional territory and num char
381: -- Use the New Str if present otherwise keep as before
382: for i in 1..P_LCOUNT loop
383: /* if program is nls_compliant then use the default territory from
384: fnd_languages, otherwise use user environment */
385: if ( nls_comp = 'Y' ) then
386: if (chkstrloc = 0 ) then
387: begin
388: select nls_language, nls_territory

Line 390: from fnd_languages

386: if (chkstrloc = 0 ) then
387: begin
388: select nls_language, nls_territory
389: into P_LANG(i).nls_language, P_LANG(i).nls_territory
390: from fnd_languages
391: where language_code = P_LANG(i).lang_code;
392: exception
393: when no_data_found then
394: fnd_message.set_name('FND', 'CONC-Invalid Language Code');

Line 405: from fnd_languages

401: if ( P_LANG(i).terr_code is NULL ) then
402: begin
403: select nls_language, nls_territory
404: into P_LANG(i).nls_language, P_LANG(i).nls_territory
405: from fnd_languages
406: where language_code = P_LANG(i).lang_code;
407: exception
408: when no_data_found then
409: fnd_message.set_name('FND', 'CONC-Invalid LangTerr Code');

Line 420: from fnd_languages a, fnd_territories b

416: else
417: begin
418: select nls_language, b.nls_territory
419: into P_LANG(i).nls_language, P_LANG(i).nls_territory
420: from fnd_languages a, fnd_territories b
421: where language_code = P_LANG(i).lang_code
422: and territory_code = P_LANG(i).terr_code;
423: exception
424: when no_data_found then

Line 443: from fnd_languages

439: -- Use the New Str if present otherwise keep as before
440: begin
441: select nls_language
442: into P_LANG(i).nls_language
443: from fnd_languages
444: where language_code = P_LANG(i).lang_code;
445: exception
446: when no_data_found then
447: fnd_message.set_name('FND', 'CONC-Invalid Language Code');

Line 632: from fnd_languages

628:
629: /* Change the language and terr */
630: select iso_language, iso_territory
631: into t_language, t_territory
632: from fnd_languages
633: where nls_language = P_LANG(ind).nls_language;
634:
635: -- 12.1 NEW MLS Function Str with optional territory and num char
636: if ( chkstrloc > 0 ) then

Line 743: from fnd_languages

739:
740: -- Get ISO language, default territory
741: select ISO_LANGUAGE, ISO_TERRITORY
742: into iso_lang, iso_terr
743: from fnd_languages
744: where nls_language = P_LANG(ind).nls_language;
745:
746: -- If a territory was specified, use it
747: -- else use the default for the language

Line 934: from fnd_languages

930:
931: function standard_languages return varchar2 is
932: cursor langs_c is
933: select language_code
934: from fnd_languages
935: where installed_flag in ('B','I')
936: order by language_id;
937: lang_str varchar2(240);
938: ret_val varchar2(240);