DBA Data[Home] [Help]

APPS.AP_WEB_HOLDS_WF dependencies on AP_EXPENSE_PARAMS

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

829: l_fnd_message fnd_new_messages.message_name%type;
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:

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

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: l_org_id ap_expense_params_all.org_id%type;
839:

Line 838: l_org_id ap_expense_params_all.org_id%type;

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: l_org_id ap_expense_params_all.org_id%type;
839:
840: BEGIN
841:
842: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start StoreNote');

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

856: from fnd_languages
857: where language_code = l_orig_language_code;
858:
859: -------------------------------------------------------------------
860: l_debug_info := 'Check AP_EXPENSE_PARAMS.NOTE_LANGUAGE_CODE';
861: -------------------------------------------------------------------
862: l_org_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
863: p_item_key,
864: 'ORG_ID');

Line 868: from ap_expense_params_all

864: 'ORG_ID');
865: begin
866: select note_language_code
867: into l_new_language_code
868: from ap_expense_params_all
869: where org_id = l_org_id;
870:
871: exception
872: when no_data_found then