DBA Data[Home] [Help]

APPS.AP_WEB_EXPENSE_WF dependencies on FND_LANGUAGES

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

9752: l_entered_by NUMBER := fnd_global.user_id;
9753: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;
9754:
9755: l_orig_language_code ap_expense_params.note_language_code%type := null;
9756: l_orig_language fnd_languages.nls_language%type := null;
9757: l_new_language_code ap_expense_params.note_language_code%type := null;
9758: l_new_language fnd_languages.nls_language%type := null;
9759:
9760: BEGIN

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

9754:
9755: l_orig_language_code ap_expense_params.note_language_code%type := null;
9756: l_orig_language fnd_languages.nls_language%type := null;
9757: l_new_language_code ap_expense_params.note_language_code%type := null;
9758: l_new_language fnd_languages.nls_language%type := null;
9759:
9760: BEGIN
9761:
9762: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start IsPreparerToAuditorTransferred');

Line 9776: from fnd_languages

9772: -------------------------------------------------------------------
9773: l_orig_language_code := userenv('LANG');
9774: select nls_language
9775: into l_orig_language
9776: from fnd_languages
9777: where language_code = l_orig_language_code;
9778:
9779: -------------------------------------------------------------------
9780: l_debug_info := 'Check AP_EXPENSE_PARAMS.NOTE_LANGUAGE_CODE';

Line 9798: from fnd_languages

9794: -------------------------------------------------------------------
9795: if (l_new_language_code is null) then
9796: select language_code
9797: into l_new_language_code
9798: from fnd_languages
9799: where installed_flag in ('B');
9800: end if;
9801:
9802: -------------------------------------------------------------------

Line 9807: from fnd_languages

9803: l_debug_info := 'Set nls context to new language';
9804: -------------------------------------------------------------------
9805: select nls_language
9806: into l_new_language
9807: from fnd_languages
9808: where language_code = l_new_language_code;
9809:
9810: fnd_global.set_nls_context(p_nls_language => l_new_language);
9811:

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

9883: l_entered_by NUMBER := fnd_global.user_id;
9884: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;
9885:
9886: l_orig_language_code ap_expense_params.note_language_code%type := null;
9887: l_orig_language fnd_languages.nls_language%type := null;
9888: l_new_language_code ap_expense_params.note_language_code%type := null;
9889: l_new_language fnd_languages.nls_language%type := null;
9890:
9891: C_WF_Version NUMBER := 0;

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

9885:
9886: l_orig_language_code ap_expense_params.note_language_code%type := null;
9887: l_orig_language fnd_languages.nls_language%type := null;
9888: l_new_language_code ap_expense_params.note_language_code%type := null;
9889: l_new_language fnd_languages.nls_language%type := null;
9890:
9891: C_WF_Version NUMBER := 0;
9892:
9893: l_itemkey wf_items.item_key%TYPE;

Line 9921: from fnd_languages

9917: -------------------------------------------------------------------
9918: l_orig_language_code := userenv('LANG');
9919: select nls_language
9920: into l_orig_language
9921: from fnd_languages
9922: where language_code = l_orig_language_code;
9923:
9924: -------------------------------------------------------------------
9925: l_debug_info := 'Check AP_EXPENSE_PARAMS.NOTE_LANGUAGE_CODE';

Line 9943: from fnd_languages

9939: -------------------------------------------------------------------
9940: if (l_new_language_code is null) then
9941: select language_code
9942: into l_new_language_code
9943: from fnd_languages
9944: where installed_flag in ('B');
9945: end if;
9946:
9947: -------------------------------------------------------------------

Line 9952: from fnd_languages

9948: l_debug_info := 'Set nls context to new language';
9949: -------------------------------------------------------------------
9950: select nls_language
9951: into l_new_language
9952: from fnd_languages
9953: where language_code = l_new_language_code;
9954:
9955: fnd_global.set_nls_context(p_nls_language => l_new_language);
9956:

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

10907: l_note varchar2(2000);
10908: l_message_name fnd_new_messages.message_name%type := 'OIE_WITHDRAWN_NOTE';
10909:
10910: l_orig_language_code ap_expense_params.note_language_code%type := null;
10911: l_orig_language fnd_languages.nls_language%type := null;
10912: l_new_language_code ap_expense_params.note_language_code%type := null;
10913: l_new_language fnd_languages.nls_language%type := null;
10914:
10915: l_No VARCHAR2(1) := 'N';

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

10909:
10910: l_orig_language_code ap_expense_params.note_language_code%type := null;
10911: l_orig_language fnd_languages.nls_language%type := null;
10912: l_new_language_code ap_expense_params.note_language_code%type := null;
10913: l_new_language fnd_languages.nls_language%type := null;
10914:
10915: l_No VARCHAR2(1) := 'N';
10916: C_WF_Version NUMBER := 0;
10917: l_n_resp_id NUMBER;

Line 11104: from fnd_languages

11100: -------------------------------------------------------------------
11101: l_orig_language_code := userenv('LANG');
11102: select nls_language
11103: into l_orig_language
11104: from fnd_languages
11105: where language_code = l_orig_language_code;
11106:
11107: -------------------------------------------------------------------
11108: l_debug_info := 'Check AP_EXPENSE_PARAMS.NOTE_LANGUAGE_CODE';

Line 11126: from fnd_languages

11122: -------------------------------------------------------------------
11123: if (l_new_language_code is null) then
11124: select language_code
11125: into l_new_language_code
11126: from fnd_languages
11127: where installed_flag in ('B');
11128: end if;
11129:
11130: -------------------------------------------------------------------

Line 11135: from fnd_languages

11131: l_debug_info := 'Set nls context to new language';
11132: -------------------------------------------------------------------
11133: select nls_language
11134: into l_new_language
11135: from fnd_languages
11136: where language_code = l_new_language_code;
11137:
11138: fnd_global.set_nls_context(p_nls_language => l_new_language);
11139:

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

14335: l_code_display_name varchar2(80);
14336: l_note_prefix varchar2(2000);
14337:
14338: l_orig_language_code ap_expense_params.note_language_code%type := null;
14339: l_orig_language fnd_languages.nls_language%type := null;
14340: l_new_language_code ap_expense_params.note_language_code%type := null;
14341: l_new_language fnd_languages.nls_language%type := null;
14342:
14343: l_entered_by NUMBER := fnd_global.user_id;

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

14337:
14338: l_orig_language_code ap_expense_params.note_language_code%type := null;
14339: l_orig_language fnd_languages.nls_language%type := null;
14340: l_new_language_code ap_expense_params.note_language_code%type := null;
14341: l_new_language fnd_languages.nls_language%type := null;
14342:
14343: l_entered_by NUMBER := fnd_global.user_id;
14344: l_user_name fnd_user.user_name%TYPE := null;
14345: l_ame_enabled varchar2(1) := 'N';

Line 14363: from fnd_languages

14359: -------------------------------------------------------------------
14360: l_orig_language_code := userenv('LANG');
14361: select nls_language
14362: into l_orig_language
14363: from fnd_languages
14364: where language_code = l_orig_language_code;
14365:
14366: -------------------------------------------------------------------
14367: l_debug_info := 'Check AP_EXPENSE_PARAMS.NOTE_LANGUAGE_CODE';

Line 14385: from fnd_languages

14381: -------------------------------------------------------------------
14382: if (l_new_language_code is null) then
14383: select language_code
14384: into l_new_language_code
14385: from fnd_languages
14386: where installed_flag in ('B');
14387: end if;
14388:
14389: -------------------------------------------------------------------

Line 14394: from fnd_languages

14390: l_debug_info := 'Set nls context to new language';
14391: -------------------------------------------------------------------
14392: select nls_language
14393: into l_new_language
14394: from fnd_languages
14395: where language_code = l_new_language_code;
14396:
14397: fnd_global.set_nls_context(p_nls_language => l_new_language);
14398: