eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_EXPENSE_WF dependencies on WF_USERS

Line 225: l_preparer_name wf_users.name%type;

221: p_event_raised IN VARCHAR2 DEFAULT 'N') IS
222: ---------------------------------------------------------------------------
223: l_item_type VARCHAR2(100) := 'APEXP';
224: l_item_key VARCHAR2(100) := to_char(p_report_header_id);
225: l_preparer_name wf_users.name%type;
226: l_preparer_display_name wf_users.display_name%type;
227: l_employee_display_name wf_users.display_name%type;
228: l_approver_name wf_users.name%type;
229: l_approver_display_name wf_users.display_name%type;

Line 226: l_preparer_display_name wf_users.display_name%type;

222: ---------------------------------------------------------------------------
223: l_item_type VARCHAR2(100) := 'APEXP';
224: l_item_key VARCHAR2(100) := to_char(p_report_header_id);
225: l_preparer_name wf_users.name%type;
226: l_preparer_display_name wf_users.display_name%type;
227: l_employee_display_name wf_users.display_name%type;
228: l_approver_name wf_users.name%type;
229: l_approver_display_name wf_users.display_name%type;
230: l_emp_cost_center VARCHAR2(240);

Line 227: l_employee_display_name wf_users.display_name%type;

223: l_item_type VARCHAR2(100) := 'APEXP';
224: l_item_key VARCHAR2(100) := to_char(p_report_header_id);
225: l_preparer_name wf_users.name%type;
226: l_preparer_display_name wf_users.display_name%type;
227: l_employee_display_name wf_users.display_name%type;
228: l_approver_name wf_users.name%type;
229: l_approver_display_name wf_users.display_name%type;
230: l_emp_cost_center VARCHAR2(240);
231: l_dummy_emp_name VARCHAR2(240);

Line 228: l_approver_name wf_users.name%type;

224: l_item_key VARCHAR2(100) := to_char(p_report_header_id);
225: l_preparer_name wf_users.name%type;
226: l_preparer_display_name wf_users.display_name%type;
227: l_employee_display_name wf_users.display_name%type;
228: l_approver_name wf_users.name%type;
229: l_approver_display_name wf_users.display_name%type;
230: l_emp_cost_center VARCHAR2(240);
231: l_dummy_emp_name VARCHAR2(240);
232: l_emp_num VARCHAR2(30);

Line 229: l_approver_display_name wf_users.display_name%type;

225: l_preparer_name wf_users.name%type;
226: l_preparer_display_name wf_users.display_name%type;
227: l_employee_display_name wf_users.display_name%type;
228: l_approver_name wf_users.name%type;
229: l_approver_display_name wf_users.display_name%type;
230: l_emp_cost_center VARCHAR2(240);
231: l_dummy_emp_name VARCHAR2(240);
232: l_emp_num VARCHAR2(30);
233: l_emp_name wf_users.name%type;

Line 233: l_emp_name wf_users.name%type;

229: l_approver_display_name wf_users.display_name%type;
230: l_emp_cost_center VARCHAR2(240);
231: l_dummy_emp_name VARCHAR2(240);
232: l_emp_num VARCHAR2(30);
233: l_emp_name wf_users.name%type;
234: l_total NUMBER;
235: l_total_dsp VARCHAR2(50);
236: l_new_total_dsp VARCHAR2(50);
237: l_credit_total_dsp VARCHAR2(50);

Line 5351: l_preparer_name wf_users.name%type;

5347: p_result OUT NOCOPY VARCHAR2) IS
5348: -----------------------------------------------------------------
5349: l_item_key VARCHAR2(100);
5350: l_preparer_id NUMBER;
5351: l_preparer_name wf_users.name%type;
5352: l_preparer_display_name wf_users.display_name%type;
5353: l_employee_id NUMBER;
5354: l_employee_name wf_users.name%type;
5355: l_employee_display_name wf_users.display_name%type;

Line 5352: l_preparer_display_name wf_users.display_name%type;

5348: -----------------------------------------------------------------
5349: l_item_key VARCHAR2(100);
5350: l_preparer_id NUMBER;
5351: l_preparer_name wf_users.name%type;
5352: l_preparer_display_name wf_users.display_name%type;
5353: l_employee_id NUMBER;
5354: l_employee_name wf_users.name%type;
5355: l_employee_display_name wf_users.display_name%type;
5356: l_report_header_id NUMBER;

Line 5354: l_employee_name wf_users.name%type;

5350: l_preparer_id NUMBER;
5351: l_preparer_name wf_users.name%type;
5352: l_preparer_display_name wf_users.display_name%type;
5353: l_employee_id NUMBER;
5354: l_employee_name wf_users.name%type;
5355: l_employee_display_name wf_users.display_name%type;
5356: l_report_header_id NUMBER;
5357: l_document_number VARCHAR2(50);
5358: l_emp_cost_center VARCHAR2(240);

Line 5355: l_employee_display_name wf_users.display_name%type;

5351: l_preparer_name wf_users.name%type;
5352: l_preparer_display_name wf_users.display_name%type;
5353: l_employee_id NUMBER;
5354: l_employee_name wf_users.name%type;
5355: l_employee_display_name wf_users.display_name%type;
5356: l_report_header_id NUMBER;
5357: l_document_number VARCHAR2(50);
5358: l_emp_cost_center VARCHAR2(240);
5359: l_doc_cost_center VARCHAR2(240);

Line 6128: l_preparer_name wf_users.name%type;

6124: -----------------------------------------------------------------
6125: l_item_type VARCHAR2(100) := 'APEXP'; -- Bug 996020
6126: l_item_key VARCHAR2(100);
6127: l_preparer_id NUMBER;
6128: l_preparer_name wf_users.name%type;
6129: l_preparer_display_name wf_users.display_name%type;
6130: l_employee_id NUMBER;
6131: l_employee_name wf_users.name%type;
6132: l_employee_display_name wf_users.display_name%type;

Line 6129: l_preparer_display_name wf_users.display_name%type;

6125: l_item_type VARCHAR2(100) := 'APEXP'; -- Bug 996020
6126: l_item_key VARCHAR2(100);
6127: l_preparer_id NUMBER;
6128: l_preparer_name wf_users.name%type;
6129: l_preparer_display_name wf_users.display_name%type;
6130: l_employee_id NUMBER;
6131: l_employee_name wf_users.name%type;
6132: l_employee_display_name wf_users.display_name%type;
6133: l_orig_expense_report_num VARCHAR2(50);

Line 6131: l_employee_name wf_users.name%type;

6127: l_preparer_id NUMBER;
6128: l_preparer_name wf_users.name%type;
6129: l_preparer_display_name wf_users.display_name%type;
6130: l_employee_id NUMBER;
6131: l_employee_name wf_users.name%type;
6132: l_employee_display_name wf_users.display_name%type;
6133: l_orig_expense_report_num VARCHAR2(50);
6134: l_report_header_id NUMBER;
6135: l_document_number VARCHAR2(50);

Line 6132: l_employee_display_name wf_users.display_name%type;

6128: l_preparer_name wf_users.name%type;
6129: l_preparer_display_name wf_users.display_name%type;
6130: l_employee_id NUMBER;
6131: l_employee_name wf_users.name%type;
6132: l_employee_display_name wf_users.display_name%type;
6133: l_orig_expense_report_num VARCHAR2(50);
6134: l_report_header_id NUMBER;
6135: l_document_number VARCHAR2(50);
6136: l_emp_cost_center VARCHAR2(240);

Line 6148: l_approver_name wf_users.name%type;

6144: l_payment_due VARCHAR2(10) := C_IndividualPay;
6145:
6146: l_purpose VARCHAR2(2400);
6147: l_approver_id NUMBER;
6148: l_approver_name wf_users.name%type;
6149: l_approver_display_name wf_users.display_name%type;
6150: l_submit_from_oie VARCHAR2(1);
6151:
6152: C_CreditLineVersion CONSTANT NUMBER := 1;

Line 6149: l_approver_display_name wf_users.display_name%type;

6145:
6146: l_purpose VARCHAR2(2400);
6147: l_approver_id NUMBER;
6148: l_approver_name wf_users.name%type;
6149: l_approver_display_name wf_users.display_name%type;
6150: l_submit_from_oie VARCHAR2(1);
6151:
6152: C_CreditLineVersion CONSTANT NUMBER := 1;
6153: C_WF_Version NUMBER := 0;

Line 6700: l_preparer_name wf_users.name%type;

6696: l_item_type VARCHAR2(100) := 'APEXP'; -- Bug 996020
6697:
6698: l_item_key VARCHAR2(100);
6699: l_preparer_id NUMBER;
6700: l_preparer_name wf_users.name%type;
6701: l_preparer_display_name wf_users.display_name%type;
6702: l_employee_id NUMBER;
6703: l_employee_name wf_users.name%type;
6704: l_employee_display_name wf_users.display_name%type;

Line 6701: l_preparer_display_name wf_users.display_name%type;

6697:
6698: l_item_key VARCHAR2(100);
6699: l_preparer_id NUMBER;
6700: l_preparer_name wf_users.name%type;
6701: l_preparer_display_name wf_users.display_name%type;
6702: l_employee_id NUMBER;
6703: l_employee_name wf_users.name%type;
6704: l_employee_display_name wf_users.display_name%type;
6705: l_report_header_id NUMBER;

Line 6703: l_employee_name wf_users.name%type;

6699: l_preparer_id NUMBER;
6700: l_preparer_name wf_users.name%type;
6701: l_preparer_display_name wf_users.display_name%type;
6702: l_employee_id NUMBER;
6703: l_employee_name wf_users.name%type;
6704: l_employee_display_name wf_users.display_name%type;
6705: l_report_header_id NUMBER;
6706: l_document_number VARCHAR2(50);
6707: l_orig_expense_report_num VARCHAR2(50);

Line 6704: l_employee_display_name wf_users.display_name%type;

6700: l_preparer_name wf_users.name%type;
6701: l_preparer_display_name wf_users.display_name%type;
6702: l_employee_id NUMBER;
6703: l_employee_name wf_users.name%type;
6704: l_employee_display_name wf_users.display_name%type;
6705: l_report_header_id NUMBER;
6706: l_document_number VARCHAR2(50);
6707: l_orig_expense_report_num VARCHAR2(50);
6708: l_emp_cost_center VARCHAR2(240);

Line 6711: l_approver_name wf_users.name%type;

6707: l_orig_expense_report_num VARCHAR2(50);
6708: l_emp_cost_center VARCHAR2(240);
6709: l_doc_cost_center VARCHAR2(240);
6710: l_override_approver_id AP_WEB_DB_EXPRPT_PKG.expHdr_overrideApprID;
6711: l_approver_name wf_users.name%type;
6712: l_approver_display_name wf_users.display_name%type;
6713: l_total NUMBER;
6714: l_credit_total NUMBER;
6715: l_new_exp_total NUMBER;

Line 6712: l_approver_display_name wf_users.display_name%type;

6708: l_emp_cost_center VARCHAR2(240);
6709: l_doc_cost_center VARCHAR2(240);
6710: l_override_approver_id AP_WEB_DB_EXPRPT_PKG.expHdr_overrideApprID;
6711: l_approver_name wf_users.name%type;
6712: l_approver_display_name wf_users.display_name%type;
6713: l_total NUMBER;
6714: l_credit_total NUMBER;
6715: l_new_exp_total NUMBER;
6716: l_currency VARCHAR2(25);

Line 7321: l_preparer_name wf_users.name%type;

7317: p_result OUT NOCOPY VARCHAR2) IS
7318: ---------------------------------------------------------------------
7319: l_item_key VARCHAR2(100);
7320: l_preparer_id NUMBER;
7321: l_preparer_name wf_users.name%type;
7322: l_preparer_display_name wf_users.display_name%type;
7323: l_employee_id NUMBER;
7324: l_employee_name wf_users.name%type;
7325: l_employee_display_name wf_users.display_name%type;

Line 7322: l_preparer_display_name wf_users.display_name%type;

7318: ---------------------------------------------------------------------
7319: l_item_key VARCHAR2(100);
7320: l_preparer_id NUMBER;
7321: l_preparer_name wf_users.name%type;
7322: l_preparer_display_name wf_users.display_name%type;
7323: l_employee_id NUMBER;
7324: l_employee_name wf_users.name%type;
7325: l_employee_display_name wf_users.display_name%type;
7326: l_report_header_id AP_WEB_DB_EXPLINE_PKG.expLines_headerID;

Line 7324: l_employee_name wf_users.name%type;

7320: l_preparer_id NUMBER;
7321: l_preparer_name wf_users.name%type;
7322: l_preparer_display_name wf_users.display_name%type;
7323: l_employee_id NUMBER;
7324: l_employee_name wf_users.name%type;
7325: l_employee_display_name wf_users.display_name%type;
7326: l_report_header_id AP_WEB_DB_EXPLINE_PKG.expLines_headerID;
7327: l_document_number VARCHAR2(50);
7328: l_total NUMBER;

Line 7325: l_employee_display_name wf_users.display_name%type;

7321: l_preparer_name wf_users.name%type;
7322: l_preparer_display_name wf_users.display_name%type;
7323: l_employee_id NUMBER;
7324: l_employee_name wf_users.name%type;
7325: l_employee_display_name wf_users.display_name%type;
7326: l_report_header_id AP_WEB_DB_EXPLINE_PKG.expLines_headerID;
7327: l_document_number VARCHAR2(50);
7328: l_total NUMBER;
7329: l_emp_cost_center VARCHAR2(240);

Line 7630: l_manager_name wf_users.name%type;

7626: p_item_type IN VARCHAR2,
7627: p_item_key IN VARCHAR2,
7628: p_manager_target IN VARCHAR2) IS
7629: --------------------------------------------------------
7630: l_manager_name wf_users.name%type;
7631: l_manager_display_name wf_users.display_name%type;
7632: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
7633: l_debug_info VARCHAR2(200);
7634: BEGIN

Line 7631: l_manager_display_name wf_users.display_name%type;

7627: p_item_key IN VARCHAR2,
7628: p_manager_target IN VARCHAR2) IS
7629: --------------------------------------------------------
7630: l_manager_name wf_users.name%type;
7631: l_manager_display_name wf_users.display_name%type;
7632: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
7633: l_debug_info VARCHAR2(200);
7634: BEGIN
7635:

Line 8087: l_manager_name wf_users.name%type;

8083: p_funmode IN VARCHAR2,
8084: p_result OUT NOCOPY VARCHAR2) IS
8085: ----------------------------------------------------------------------
8086: l_manager_id NUMBER;
8087: l_manager_name wf_users.name%type;
8088: l_manager_display_name wf_users.display_name%type;
8089: l_debug_info VARCHAR2(200);
8090: BEGIN
8091:

Line 8088: l_manager_display_name wf_users.display_name%type;

8084: p_result OUT NOCOPY VARCHAR2) IS
8085: ----------------------------------------------------------------------
8086: l_manager_id NUMBER;
8087: l_manager_name wf_users.name%type;
8088: l_manager_display_name wf_users.display_name%type;
8089: l_debug_info VARCHAR2(200);
8090: BEGIN
8091:
8092: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start SetApproverEqualManager');

Line 8155: l_approver_name wf_users.name%type;

8151: p_funmode IN VARCHAR2,
8152: p_result OUT NOCOPY VARCHAR2) IS
8153: ----------------------------------------------------------------------
8154: l_approver_id NUMBER;
8155: l_approver_name wf_users.name%type;
8156: l_approver_display_name wf_users.display_name%type;
8157: l_debug_info VARCHAR2(200);
8158: BEGIN
8159:

Line 8156: l_approver_display_name wf_users.display_name%type;

8152: p_result OUT NOCOPY VARCHAR2) IS
8153: ----------------------------------------------------------------------
8154: l_approver_id NUMBER;
8155: l_approver_name wf_users.name%type;
8156: l_approver_display_name wf_users.display_name%type;
8157: l_debug_info VARCHAR2(200);
8158: BEGIN
8159:
8160: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start RecordForwardFromInfo');

Line 8529: l_emp_name wf_users.name%type;

8525: p_funmode IN VARCHAR2,
8526: p_result OUT NOCOPY VARCHAR2) IS
8527: ---------------------------------------------------------
8528: l_preparer_id NUMBER;
8529: l_emp_name wf_users.name%type;
8530: l_emp_num VARCHAR2(30);
8531: l_emp_cost_center VARCHAR2(240);
8532: l_debug_info VARCHAR2(200);
8533: BEGIN

Line 8822: V_employee_name wf_users.name%type;

8818: -- employee in the third party case.
8819: --
8820:
8821: V_employee_id NUMBER;
8822: V_employee_name wf_users.name%type;
8823: V_employee_display_name wf_users.display_name%type;
8824: l_debug_info VARCHAR2(200);
8825:
8826: BEGIN

Line 8823: V_employee_display_name wf_users.display_name%type;

8819: --
8820:
8821: V_employee_id NUMBER;
8822: V_employee_name wf_users.name%type;
8823: V_employee_display_name wf_users.display_name%type;
8824: l_debug_info VARCHAR2(200);
8825:
8826: BEGIN
8827:

Line 9871: l_Transferee wf_users.name%type;

9867:
9868: l_notificationID NUMBER;
9869: l_TransferNotificationID NUMBER;
9870: l_TransferToID NUMBER;
9871: l_Transferee wf_users.name%type;
9872: l_TransferToName wf_users.name%type;
9873: l_preparer_id NUMBER;
9874: l_preparer_name wf_users.name%type;
9875: l_preparer_display_name wf_users.display_name%type;

Line 9872: l_TransferToName wf_users.name%type;

9868: l_notificationID NUMBER;
9869: l_TransferNotificationID NUMBER;
9870: l_TransferToID NUMBER;
9871: l_Transferee wf_users.name%type;
9872: l_TransferToName wf_users.name%type;
9873: l_preparer_id NUMBER;
9874: l_preparer_name wf_users.name%type;
9875: l_preparer_display_name wf_users.display_name%type;
9876: l_AMEEnabled VARCHAR2(1);

Line 9874: l_preparer_name wf_users.name%type;

9870: l_TransferToID NUMBER;
9871: l_Transferee wf_users.name%type;
9872: l_TransferToName wf_users.name%type;
9873: l_preparer_id NUMBER;
9874: l_preparer_name wf_users.name%type;
9875: l_preparer_display_name wf_users.display_name%type;
9876: l_AMEEnabled VARCHAR2(1);
9877: l_forwarder AME_UTIL.approverRecord2;
9878: l_forwardee AME_UTIL.approverRecord2;

Line 9875: l_preparer_display_name wf_users.display_name%type;

9871: l_Transferee wf_users.name%type;
9872: l_TransferToName wf_users.name%type;
9873: l_preparer_id NUMBER;
9874: l_preparer_name wf_users.name%type;
9875: l_preparer_display_name wf_users.display_name%type;
9876: l_AMEEnabled VARCHAR2(1);
9877: l_forwarder AME_UTIL.approverRecord2;
9878: l_forwardee AME_UTIL.approverRecord2;
9879: l_approver_id NUMBER;

Line 15210: l_manager_name wf_users.name%type;

15206: l_childItemKeySeq number;
15207: l_childItemKey wf_items.item_key%type;
15208: l_masterUserKey wf_items.user_key%type;
15209:
15210: l_manager_name wf_users.name%type;
15211: l_manager_display_name wf_users.display_name%type;
15212:
15213: l_master_report_id number;
15214:

Line 15211: l_manager_display_name wf_users.display_name%type;

15207: l_childItemKey wf_items.item_key%type;
15208: l_masterUserKey wf_items.user_key%type;
15209:
15210: l_manager_name wf_users.name%type;
15211: l_manager_display_name wf_users.display_name%type;
15212:
15213: l_master_report_id number;
15214:
15215: fixable_exception EXCEPTION;