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: BEGIN

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: BEGIN
839:
840: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start StoreNote');

Line 854: from fnd_languages

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

Line 876: from fnd_languages

872: -------------------------------------------------------------------
873: if (l_new_language_code is null) then
874: select language_code
875: into l_new_language_code
876: from fnd_languages
877: where installed_flag in ('B');
878: end if;
879:
880: -------------------------------------------------------------------

Line 885: from fnd_languages

881: l_debug_info := 'Set nls context to new language';
882: -------------------------------------------------------------------
883: select nls_language
884: into l_new_language
885: from fnd_languages
886: where language_code = l_new_language_code;
887:
888: fnd_global.set_nls_context(p_nls_language => l_new_language);
889: