APPS.FND_MLS_REQUEST dependencies on FND_LANGUAGES

Line 363: fnd_languages, otherwise use user environment */

359: -- 12.1 NEW MLS Function Str with optional territory and num char
360: -- Use the New Str if present otherwise keep as before
361: for i in 1..P_LCOUNT loop
362: /* if program is nls_compliant then use the default territory from
363: fnd_languages, otherwise use user environment */
364: if ( nls_comp = 'Y' ) then
365: if (chkstrloc = 0 ) then
366: begin
367: select nls_language, nls_territory

Line 369: from fnd_languages

365: if (chkstrloc = 0 ) then
366: begin
367: select nls_language, nls_territory
368: into P_LANG(i).nls_language, P_LANG(i).nls_territory
369: from fnd_languages
370: where language_code = P_LANG(i).lang_code;
371: exception
372: when no_data_found then
373: fnd_message.set_name('FND', 'CONC-Invalid Language Code');

Line 384: from fnd_languages

380: if ( P_LANG(i).terr_code is NULL ) then
381: begin
382: select nls_language, nls_territory
383: into P_LANG(i).nls_language, P_LANG(i).nls_territory
384: from fnd_languages
385: where language_code = P_LANG(i).lang_code;
386: exception
387: when no_data_found then
388: fnd_message.set_name('FND', 'CONC-Invalid LangTerr Code');

Line 399: from fnd_languages a, fnd_territories b

395: else
396: begin
397: select nls_language, b.nls_territory
398: into P_LANG(i).nls_language, P_LANG(i).nls_territory
399: from fnd_languages a, fnd_territories b
400: where language_code = P_LANG(i).lang_code
401: and territory_code = P_LANG(i).terr_code;
402: exception
403: when no_data_found then

Line 422: from fnd_languages

418: -- Use the New Str if present otherwise keep as before
419: begin
420: select nls_language
421: into P_LANG(i).nls_language
422: from fnd_languages
423: where language_code = P_LANG(i).lang_code;
424: exception
425: when no_data_found then
426: fnd_message.set_name('FND', 'CONC-Invalid Language Code');

Line 603: from fnd_languages

599:
600: /* Change the language and terr */
601: select iso_language, iso_territory
602: into t_language, t_territory
603: from fnd_languages
604: where nls_language = P_LANG(ind).nls_language;
605:
606: -- 12.1 NEW MLS Function Str with optional territory and num char
607: if ( chkstrloc > 0 ) then

Line 853: from fnd_languages

849:
850: function standard_languages return varchar2 is
851: cursor langs_c is
852: select language_code
853: from fnd_languages
854: where installed_flag in ('B','I')
855: order by language_id;
856: lang_str varchar2(240);
857: ret_val varchar2(240);