64: hd.language lang,
65: hd.title title,
66: hd.file_name fn
67: from fnd_help_documents hd,
68: fnd_languages_vl l
69: where hd.file_name = file
70: and hd.application = app
71: and l.language_code = hd.language
72: order by l.description;
161: hd.title title,
162: hd.file_name fn
163: from fnd_help_targets ht,
164: fnd_help_documents hd,
165: fnd_languages_vl l
166: where ht.file_id = hd.file_id
167: and ht.target_name = target
168: and hd.application = app
169: and l.language_code = hd.language
241:
242: begin
243: select lower(iso_language)||'-'||iso_territory
244: into httplang
245: from fnd_languages where language_code = langcode;
246: exception when no_data_found then
247: httplang := langcode;
248: end;
249:
505:
506: -- Set NLS_LANGUAGE if the language code doesn't match userenv('LANG').
507: if (langcode <> userenv('LANG')) then
508: begin
509: select ''''||nls_language||'''' into nlslang from fnd_languages
510: where language_code = langcode;
511: exception
512: when others then
513: nlslang := 'AMERICAN';