DBA Data[Home] [Help]

APPS.AP_WEB_EXPENSE_WF dependencies on FND_LANGUAGES

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

10198: l_entered_by NUMBER := fnd_global.user_id;
10199: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;
10200:
10201: l_orig_language_code ap_expense_params.note_language_code%type := null;
10202: l_orig_language fnd_languages.nls_language%type := null;
10203: l_new_language_code ap_expense_params.note_language_code%type := null;
10204: l_new_language fnd_languages.nls_language%type := null;
10205:
10206: BEGIN

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

10200:
10201: l_orig_language_code ap_expense_params.note_language_code%type := null;
10202: l_orig_language fnd_languages.nls_language%type := null;
10203: l_new_language_code ap_expense_params.note_language_code%type := null;
10204: l_new_language fnd_languages.nls_language%type := null;
10205:
10206: BEGIN
10207:
10208: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start IsPreparerToAuditorTransferred');

Line 10222: from fnd_languages

10218: -------------------------------------------------------------------
10219: l_orig_language_code := userenv('LANG');
10220: select nls_language
10221: into l_orig_language
10222: from fnd_languages
10223: where language_code = l_orig_language_code;
10224:
10225: -------------------------------------------------------------------
10226: l_debug_info := 'Check AP_EXPENSE_PARAMS.NOTE_LANGUAGE_CODE';

Line 10244: from fnd_languages

10240: -------------------------------------------------------------------
10241: if (l_new_language_code is null) then
10242: select language_code
10243: into l_new_language_code
10244: from fnd_languages
10245: where installed_flag in ('B');
10246: end if;
10247:
10248: -------------------------------------------------------------------

Line 10253: from fnd_languages

10249: l_debug_info := 'Set nls context to new language';
10250: -------------------------------------------------------------------
10251: select nls_language
10252: into l_new_language
10253: from fnd_languages
10254: where language_code = l_new_language_code;
10255:
10256: fnd_global.set_nls_context(p_nls_language => l_new_language);
10257:

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

10334: l_entered_by NUMBER := fnd_global.user_id;
10335: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;
10336:
10337: l_orig_language_code ap_expense_params.note_language_code%type := null;
10338: l_orig_language fnd_languages.nls_language%type := null;
10339: l_new_language_code ap_expense_params.note_language_code%type := null;
10340: l_new_language fnd_languages.nls_language%type := null;
10341:
10342: C_WF_Version NUMBER := 0;

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

10336:
10337: l_orig_language_code ap_expense_params.note_language_code%type := null;
10338: l_orig_language fnd_languages.nls_language%type := null;
10339: l_new_language_code ap_expense_params.note_language_code%type := null;
10340: l_new_language fnd_languages.nls_language%type := null;
10341:
10342: C_WF_Version NUMBER := 0;
10343:
10344: l_itemkey wf_items.item_key%TYPE;

Line 10468: from fnd_languages

10464: -------------------------------------------------------------------
10465: l_orig_language_code := userenv('LANG');
10466: select nls_language
10467: into l_orig_language
10468: from fnd_languages
10469: where language_code = l_orig_language_code;
10470:
10471: -------------------------------------------------------------------
10472: l_debug_info := 'Check AP_EXPENSE_PARAMS.NOTE_LANGUAGE_CODE';

Line 10490: from fnd_languages

10486: -------------------------------------------------------------------
10487: if (l_new_language_code is null) then
10488: select language_code
10489: into l_new_language_code
10490: from fnd_languages
10491: where installed_flag in ('B');
10492: end if;
10493:
10494: -------------------------------------------------------------------

Line 10499: from fnd_languages

10495: l_debug_info := 'Set nls context to new language';
10496: -------------------------------------------------------------------
10497: select nls_language
10498: into l_new_language
10499: from fnd_languages
10500: where language_code = l_new_language_code;
10501:
10502: fnd_global.set_nls_context(p_nls_language => l_new_language);
10503:

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

11661: l_note varchar2(2000);
11662: l_message_name fnd_new_messages.message_name%type := 'OIE_WITHDRAWN_NOTE';
11663:
11664: l_orig_language_code ap_expense_params.note_language_code%type := null;
11665: l_orig_language fnd_languages.nls_language%type := null;
11666: l_new_language_code ap_expense_params.note_language_code%type := null;
11667: l_new_language fnd_languages.nls_language%type := null;
11668:
11669: l_No VARCHAR2(1) := 'N';

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

11663:
11664: l_orig_language_code ap_expense_params.note_language_code%type := null;
11665: l_orig_language fnd_languages.nls_language%type := null;
11666: l_new_language_code ap_expense_params.note_language_code%type := null;
11667: l_new_language fnd_languages.nls_language%type := null;
11668:
11669: l_No VARCHAR2(1) := 'N';
11670: C_WF_Version NUMBER := 0;
11671: l_n_resp_id NUMBER := 0;

Line 11867: from fnd_languages

11863: -------------------------------------------------------------------
11864: l_orig_language_code := userenv('LANG');
11865: select nls_language
11866: into l_orig_language
11867: from fnd_languages
11868: where language_code = l_orig_language_code;
11869:
11870: -------------------------------------------------------------------
11871: l_debug_info := 'Check AP_EXPENSE_PARAMS.NOTE_LANGUAGE_CODE';

Line 11889: from fnd_languages

11885: -------------------------------------------------------------------
11886: if (l_new_language_code is null) then
11887: select language_code
11888: into l_new_language_code
11889: from fnd_languages
11890: where installed_flag in ('B');
11891: end if;
11892:
11893: -------------------------------------------------------------------

Line 11898: from fnd_languages

11894: l_debug_info := 'Set nls context to new language';
11895: -------------------------------------------------------------------
11896: select nls_language
11897: into l_new_language
11898: from fnd_languages
11899: where language_code = l_new_language_code;
11900:
11901: fnd_global.set_nls_context(p_nls_language => l_new_language);
11902:

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

15223: l_code_display_name varchar2(80);
15224: l_note_prefix varchar2(2000);
15225:
15226: l_orig_language_code ap_expense_params.note_language_code%type := null;
15227: l_orig_language fnd_languages.nls_language%type := null;
15228: l_new_language_code ap_expense_params.note_language_code%type := null;
15229: l_new_language fnd_languages.nls_language%type := null;
15230:
15231: l_entered_by NUMBER := fnd_global.user_id;

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

15225:
15226: l_orig_language_code ap_expense_params.note_language_code%type := null;
15227: l_orig_language fnd_languages.nls_language%type := null;
15228: l_new_language_code ap_expense_params.note_language_code%type := null;
15229: l_new_language fnd_languages.nls_language%type := null;
15230:
15231: l_entered_by NUMBER := fnd_global.user_id;
15232: l_user_name fnd_user.user_name%TYPE := null;
15233: l_ame_enabled varchar2(1) := 'N';

Line 15254: from fnd_languages

15250: -------------------------------------------------------------------
15251: l_orig_language_code := userenv('LANG');
15252: select nls_language
15253: into l_orig_language
15254: from fnd_languages
15255: where language_code = l_orig_language_code;
15256:
15257: -------------------------------------------------------------------
15258: l_debug_info := 'Check AP_EXPENSE_PARAMS.NOTE_LANGUAGE_CODE';

Line 15276: from fnd_languages

15272: -------------------------------------------------------------------
15273: if (l_new_language_code is null) then
15274: select language_code
15275: into l_new_language_code
15276: from fnd_languages
15277: where installed_flag in ('B');
15278: end if;
15279:
15280: -------------------------------------------------------------------

Line 15285: from fnd_languages

15281: l_debug_info := 'Set nls context to new language';
15282: -------------------------------------------------------------------
15283: select nls_language
15284: into l_new_language
15285: from fnd_languages
15286: where language_code = l_new_language_code;
15287:
15288: fnd_global.set_nls_context(p_nls_language => l_new_language);
15289: