DBA Data[Home] [Help]

APPS.AP_WEB_EXPENSE_WF dependencies on AP_EXPENSE_PARAMS

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

10197: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
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:

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

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
10207:

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

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';
10227: -------------------------------------------------------------------
10228: begin
10229: select note_language_code
10230: into l_new_language_code

Line 10231: from ap_expense_params;

10227: -------------------------------------------------------------------
10228: begin
10229: select note_language_code
10230: into l_new_language_code
10231: from ap_expense_params;
10232:
10233: exception
10234: when no_data_found then
10235: null;

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

10333: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
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:

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

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;
10343:

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

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';
10473: -------------------------------------------------------------------
10474: begin
10475: select note_language_code
10476: into l_new_language_code

Line 10477: from ap_expense_params;

10473: -------------------------------------------------------------------
10474: begin
10475: select note_language_code
10476: into l_new_language_code
10477: from ap_expense_params;
10478:
10479: exception
10480: when no_data_found then
10481: null;

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

11660: l_entered_by NUMBER := fnd_global.user_id;
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:

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

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';
11670: C_WF_Version NUMBER := 0;

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

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';
11872: -------------------------------------------------------------------
11873: begin
11874: select note_language_code
11875: into l_new_language_code

Line 11876: from ap_expense_params;

11872: -------------------------------------------------------------------
11873: begin
11874: select note_language_code
11875: into l_new_language_code
11876: from ap_expense_params;
11877:
11878: exception
11879: when no_data_found then
11880: null;

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

15222: l_type_display_name varchar2(80);
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:

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

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;
15232: l_user_name fnd_user.user_name%TYPE := null;

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

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';
15259: -------------------------------------------------------------------
15260: begin
15261: select note_language_code
15262: into l_new_language_code

Line 15263: from ap_expense_params;

15259: -------------------------------------------------------------------
15260: begin
15261: select note_language_code
15262: into l_new_language_code
15263: from ap_expense_params;
15264:
15265: exception
15266: when no_data_found then
15267: null;