APPS.AP_WEB_RECEIPTS_WF dependencies on AP_EXPENSE_PARAMS

Line 2050: l_orig_language_code ap_expense_params.note_language_code%type := null;

2046: l_type_display_name varchar2(240);
2047: l_code_display_name varchar2(240);
2048: l_note_prefix varchar2(2000);
2049:
2050: l_orig_language_code ap_expense_params.note_language_code%type := null;
2051: l_orig_language fnd_languages.nls_language%type := null;
2052: l_new_language_code ap_expense_params.note_language_code%type := null;
2053: l_new_language fnd_languages.nls_language%type := null;
2054:

Line 2052: l_new_language_code ap_expense_params.note_language_code%type := null;

2048: l_note_prefix varchar2(2000);
2049:
2050: l_orig_language_code ap_expense_params.note_language_code%type := null;
2051: l_orig_language fnd_languages.nls_language%type := null;
2052: l_new_language_code ap_expense_params.note_language_code%type := null;
2053: l_new_language fnd_languages.nls_language%type := null;
2054:
2055: l_created_by number;
2056: --l_preparer_id number;

Line 2058: l_org_id ap_expense_params_all.org_id%type;

2054:
2055: l_created_by number;
2056: --l_preparer_id number;
2057:
2058: l_org_id ap_expense_params_all.org_id%type;
2059: l_received_date ap_expense_report_headers_all.receipts_received_date%type;
2060: BEGIN
2061:
2062: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start StoreNote');

Line 2080: l_debug_info := 'Check AP_EXPENSE_PARAMS.NOTE_LANGUAGE_CODE';

2076: from fnd_languages
2077: where language_code = l_orig_language_code;
2078:
2079: -------------------------------------------------------------------
2080: l_debug_info := 'Check AP_EXPENSE_PARAMS.NOTE_LANGUAGE_CODE';
2081: -------------------------------------------------------------------
2082: l_org_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
2083: p_item_key,
2084: 'ORG_ID');

Line 2088: from ap_expense_params_all

2084: 'ORG_ID');
2085: begin
2086: select note_language_code
2087: into l_new_language_code
2088: from ap_expense_params_all
2089: where org_id = l_org_id;
2090:
2091: exception
2092: when no_data_found then