DBA Data[Home] [Help]

APPS.AP_WEB_EXPENSE_WF dependencies on AP_EXPENSE_PARAMS

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

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:

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

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:

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

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

Line 9785: from ap_expense_params;

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;

Line 9886: l_orig_language_code ap_expense_params.note_language_code%type := 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:

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

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:

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

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

Line 9930: from ap_expense_params;

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;

Line 10910: l_orig_language_code ap_expense_params.note_language_code%type := 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:

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

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;

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

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

Line 11113: from ap_expense_params;

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;

Line 14338: l_orig_language_code ap_expense_params.note_language_code%type := 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:

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

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;

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

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

Line 14372: from ap_expense_params;

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;