APPS.AP_WEB_HOLDS_WF dependencies on FND_LANGUAGES

Line 834: l_orig_language fnd_languages.nls_language%type := null;

830: l_note_text varchar2(2000);
831: l_holding_invoice_num ap_expense_report_headers.invoice_num%type;
832:
833: l_orig_language_code ap_expense_params.note_language_code%type := null;
834: l_orig_language fnd_languages.nls_language%type := null;
835: l_new_language_code ap_expense_params.note_language_code%type := null;
836: l_new_language fnd_languages.nls_language%type := null;
837:
838: l_org_id ap_expense_params_all.org_id%type;

Line 836: l_new_language fnd_languages.nls_language%type := null;

832:
833: l_orig_language_code ap_expense_params.note_language_code%type := null;
834: l_orig_language fnd_languages.nls_language%type := null;
835: l_new_language_code ap_expense_params.note_language_code%type := null;
836: l_new_language fnd_languages.nls_language%type := null;
837:
838: l_org_id ap_expense_params_all.org_id%type;
839:
840: BEGIN

Line 856: from fnd_languages

852: -------------------------------------------------------------------
853: l_orig_language_code := userenv('LANG');
854: select nls_language
855: into l_orig_language
856: from fnd_languages
857: where language_code = l_orig_language_code;
858:
859: -------------------------------------------------------------------
860: l_debug_info := 'Check AP_EXPENSE_PARAMS.NOTE_LANGUAGE_CODE';

Line 882: from fnd_languages

878: -------------------------------------------------------------------
879: if (l_new_language_code is null) then
880: select language_code
881: into l_new_language_code
882: from fnd_languages
883: where installed_flag in ('B');
884: end if;
885:
886: -------------------------------------------------------------------

Line 891: from fnd_languages

887: l_debug_info := 'Set nls context to new language';
888: -------------------------------------------------------------------
889: select nls_language
890: into l_new_language
891: from fnd_languages
892: where language_code = l_new_language_code;
893:
894: fnd_global.set_nls_context(p_nls_language => l_new_language);
895: