9751: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
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:
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
9761:
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';
9781: -------------------------------------------------------------------
9782: begin
9783: select note_language_code
9784: into l_new_language_code
9781: -------------------------------------------------------------------
9782: begin
9783: select note_language_code
9784: into l_new_language_code
9785: from ap_expense_params;
9786:
9787: exception
9788: when no_data_found then
9789: null;
9882: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
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:
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;
9892:
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';
9926: -------------------------------------------------------------------
9927: begin
9928: select note_language_code
9929: into l_new_language_code
9926: -------------------------------------------------------------------
9927: begin
9928: select note_language_code
9929: into l_new_language_code
9930: from ap_expense_params;
9931:
9932: exception
9933: when no_data_found then
9934: null;
10906: l_entered_by NUMBER := fnd_global.user_id;
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:
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';
10916: C_WF_Version NUMBER := 0;
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';
11109: -------------------------------------------------------------------
11110: begin
11111: select note_language_code
11112: into l_new_language_code
11109: -------------------------------------------------------------------
11110: begin
11111: select note_language_code
11112: into l_new_language_code
11113: from ap_expense_params;
11114:
11115: exception
11116: when no_data_found then
11117: null;
14334: l_type_display_name varchar2(80);
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:
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;
14344: l_user_name fnd_user.user_name%TYPE := null;
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';
14368: -------------------------------------------------------------------
14369: begin
14370: select note_language_code
14371: into l_new_language_code
14368: -------------------------------------------------------------------
14369: begin
14370: select note_language_code
14371: into l_new_language_code
14372: from ap_expense_params;
14373:
14374: exception
14375: when no_data_found then
14376: null;