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 228: l_preparer_name wf_users.name%type;

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

Line 229: l_preparer_display_name wf_users.display_name%type;

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

Line 230: l_employee_display_name wf_users.display_name%type;

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

Line 231: l_approver_name wf_users.name%type;

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

Line 232: l_approver_display_name wf_users.display_name%type;

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

Line 236: l_emp_name wf_users.name%type;

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

Line 5709: l_preparer_name wf_users.name%type;

5705: p_result OUT NOCOPY VARCHAR2) IS
5706: -----------------------------------------------------------------
5707: l_item_key VARCHAR2(100);
5708: l_preparer_id NUMBER;
5709: l_preparer_name wf_users.name%type;
5710: l_preparer_display_name wf_users.display_name%type;
5711: l_employee_id NUMBER;
5712: l_employee_name wf_users.name%type;
5713: l_employee_display_name wf_users.display_name%type;

Line 5710: l_preparer_display_name wf_users.display_name%type;

5706: -----------------------------------------------------------------
5707: l_item_key VARCHAR2(100);
5708: l_preparer_id NUMBER;
5709: l_preparer_name wf_users.name%type;
5710: l_preparer_display_name wf_users.display_name%type;
5711: l_employee_id NUMBER;
5712: l_employee_name wf_users.name%type;
5713: l_employee_display_name wf_users.display_name%type;
5714: l_report_header_id NUMBER;

Line 5712: l_employee_name wf_users.name%type;

5708: l_preparer_id NUMBER;
5709: l_preparer_name wf_users.name%type;
5710: l_preparer_display_name wf_users.display_name%type;
5711: l_employee_id NUMBER;
5712: l_employee_name wf_users.name%type;
5713: l_employee_display_name wf_users.display_name%type;
5714: l_report_header_id NUMBER;
5715: l_document_number VARCHAR2(50);
5716: l_emp_cost_center VARCHAR2(240);

Line 5713: l_employee_display_name wf_users.display_name%type;

5709: l_preparer_name wf_users.name%type;
5710: l_preparer_display_name wf_users.display_name%type;
5711: l_employee_id NUMBER;
5712: l_employee_name wf_users.name%type;
5713: l_employee_display_name wf_users.display_name%type;
5714: l_report_header_id NUMBER;
5715: l_document_number VARCHAR2(50);
5716: l_emp_cost_center VARCHAR2(240);
5717: l_doc_cost_center VARCHAR2(240);

Line 6509: l_preparer_name wf_users.name%type;

6505: -----------------------------------------------------------------
6506: l_item_type VARCHAR2(100) := 'APEXP'; -- Bug 996020
6507: l_item_key VARCHAR2(100);
6508: l_preparer_id NUMBER;
6509: l_preparer_name wf_users.name%type;
6510: l_preparer_display_name wf_users.display_name%type;
6511: l_employee_id NUMBER;
6512: l_employee_name wf_users.name%type;
6513: l_employee_display_name wf_users.display_name%type;

Line 6510: l_preparer_display_name wf_users.display_name%type;

6506: l_item_type VARCHAR2(100) := 'APEXP'; -- Bug 996020
6507: l_item_key VARCHAR2(100);
6508: l_preparer_id NUMBER;
6509: l_preparer_name wf_users.name%type;
6510: l_preparer_display_name wf_users.display_name%type;
6511: l_employee_id NUMBER;
6512: l_employee_name wf_users.name%type;
6513: l_employee_display_name wf_users.display_name%type;
6514: l_orig_expense_report_num VARCHAR2(50);

Line 6512: l_employee_name wf_users.name%type;

6508: l_preparer_id NUMBER;
6509: l_preparer_name wf_users.name%type;
6510: l_preparer_display_name wf_users.display_name%type;
6511: l_employee_id NUMBER;
6512: l_employee_name wf_users.name%type;
6513: l_employee_display_name wf_users.display_name%type;
6514: l_orig_expense_report_num VARCHAR2(50);
6515: l_report_header_id NUMBER;
6516: l_document_number VARCHAR2(50);

Line 6513: l_employee_display_name wf_users.display_name%type;

6509: l_preparer_name wf_users.name%type;
6510: l_preparer_display_name wf_users.display_name%type;
6511: l_employee_id NUMBER;
6512: l_employee_name wf_users.name%type;
6513: l_employee_display_name wf_users.display_name%type;
6514: l_orig_expense_report_num VARCHAR2(50);
6515: l_report_header_id NUMBER;
6516: l_document_number VARCHAR2(50);
6517: l_emp_cost_center VARCHAR2(240);

Line 6529: l_approver_name wf_users.name%type;

6525: l_payment_due VARCHAR2(10) := C_IndividualPay;
6526:
6527: l_purpose VARCHAR2(2400);
6528: l_approver_id NUMBER;
6529: l_approver_name wf_users.name%type;
6530: l_approver_display_name wf_users.display_name%type;
6531: l_submit_from_oie VARCHAR2(1);
6532:
6533: C_CreditLineVersion CONSTANT NUMBER := 1;

Line 6530: l_approver_display_name wf_users.display_name%type;

6526:
6527: l_purpose VARCHAR2(2400);
6528: l_approver_id NUMBER;
6529: l_approver_name wf_users.name%type;
6530: l_approver_display_name wf_users.display_name%type;
6531: l_submit_from_oie VARCHAR2(1);
6532:
6533: C_CreditLineVersion CONSTANT NUMBER := 1;
6534: C_WF_Version NUMBER := 0;

Line 7081: l_preparer_name wf_users.name%type;

7077: l_item_type VARCHAR2(100) := 'APEXP'; -- Bug 996020
7078:
7079: l_item_key VARCHAR2(100);
7080: l_preparer_id NUMBER;
7081: l_preparer_name wf_users.name%type;
7082: l_preparer_display_name wf_users.display_name%type;
7083: l_employee_id NUMBER;
7084: l_employee_name wf_users.name%type;
7085: l_employee_display_name wf_users.display_name%type;

Line 7082: l_preparer_display_name wf_users.display_name%type;

7078:
7079: l_item_key VARCHAR2(100);
7080: l_preparer_id NUMBER;
7081: l_preparer_name wf_users.name%type;
7082: l_preparer_display_name wf_users.display_name%type;
7083: l_employee_id NUMBER;
7084: l_employee_name wf_users.name%type;
7085: l_employee_display_name wf_users.display_name%type;
7086: l_report_header_id NUMBER;

Line 7084: l_employee_name wf_users.name%type;

7080: l_preparer_id NUMBER;
7081: l_preparer_name wf_users.name%type;
7082: l_preparer_display_name wf_users.display_name%type;
7083: l_employee_id NUMBER;
7084: l_employee_name wf_users.name%type;
7085: l_employee_display_name wf_users.display_name%type;
7086: l_report_header_id NUMBER;
7087: l_document_number VARCHAR2(50);
7088: l_orig_expense_report_num VARCHAR2(50);

Line 7085: l_employee_display_name wf_users.display_name%type;

7081: l_preparer_name wf_users.name%type;
7082: l_preparer_display_name wf_users.display_name%type;
7083: l_employee_id NUMBER;
7084: l_employee_name wf_users.name%type;
7085: l_employee_display_name wf_users.display_name%type;
7086: l_report_header_id NUMBER;
7087: l_document_number VARCHAR2(50);
7088: l_orig_expense_report_num VARCHAR2(50);
7089: l_emp_cost_center VARCHAR2(240);

Line 7092: l_approver_name wf_users.name%type;

7088: l_orig_expense_report_num VARCHAR2(50);
7089: l_emp_cost_center VARCHAR2(240);
7090: l_doc_cost_center VARCHAR2(240);
7091: l_override_approver_id AP_WEB_DB_EXPRPT_PKG.expHdr_overrideApprID;
7092: l_approver_name wf_users.name%type;
7093: l_approver_display_name wf_users.display_name%type;
7094: l_total NUMBER;
7095: l_credit_total NUMBER;
7096: l_new_exp_total NUMBER;

Line 7093: l_approver_display_name wf_users.display_name%type;

7089: l_emp_cost_center VARCHAR2(240);
7090: l_doc_cost_center VARCHAR2(240);
7091: l_override_approver_id AP_WEB_DB_EXPRPT_PKG.expHdr_overrideApprID;
7092: l_approver_name wf_users.name%type;
7093: l_approver_display_name wf_users.display_name%type;
7094: l_total NUMBER;
7095: l_credit_total NUMBER;
7096: l_new_exp_total NUMBER;
7097: l_currency VARCHAR2(25);

Line 7766: l_preparer_name wf_users.name%type;

7762: p_result OUT NOCOPY VARCHAR2) IS
7763: ---------------------------------------------------------------------
7764: l_item_key VARCHAR2(100);
7765: l_preparer_id NUMBER;
7766: l_preparer_name wf_users.name%type;
7767: l_preparer_display_name wf_users.display_name%type;
7768: l_employee_id NUMBER;
7769: l_employee_name wf_users.name%type;
7770: l_employee_display_name wf_users.display_name%type;

Line 7767: l_preparer_display_name wf_users.display_name%type;

7763: ---------------------------------------------------------------------
7764: l_item_key VARCHAR2(100);
7765: l_preparer_id NUMBER;
7766: l_preparer_name wf_users.name%type;
7767: l_preparer_display_name wf_users.display_name%type;
7768: l_employee_id NUMBER;
7769: l_employee_name wf_users.name%type;
7770: l_employee_display_name wf_users.display_name%type;
7771: l_report_header_id AP_WEB_DB_EXPLINE_PKG.expLines_headerID;

Line 7769: l_employee_name wf_users.name%type;

7765: l_preparer_id NUMBER;
7766: l_preparer_name wf_users.name%type;
7767: l_preparer_display_name wf_users.display_name%type;
7768: l_employee_id NUMBER;
7769: l_employee_name wf_users.name%type;
7770: l_employee_display_name wf_users.display_name%type;
7771: l_report_header_id AP_WEB_DB_EXPLINE_PKG.expLines_headerID;
7772: l_document_number VARCHAR2(50);
7773: l_total NUMBER;

Line 7770: l_employee_display_name wf_users.display_name%type;

7766: l_preparer_name wf_users.name%type;
7767: l_preparer_display_name wf_users.display_name%type;
7768: l_employee_id NUMBER;
7769: l_employee_name wf_users.name%type;
7770: l_employee_display_name wf_users.display_name%type;
7771: l_report_header_id AP_WEB_DB_EXPLINE_PKG.expLines_headerID;
7772: l_document_number VARCHAR2(50);
7773: l_total NUMBER;
7774: l_emp_cost_center VARCHAR2(240);

Line 8075: l_manager_name wf_users.name%type;

8071: p_item_type IN VARCHAR2,
8072: p_item_key IN VARCHAR2,
8073: p_manager_target IN VARCHAR2) IS
8074: --------------------------------------------------------
8075: l_manager_name wf_users.name%type;
8076: l_manager_display_name wf_users.display_name%type;
8077: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
8078: l_debug_info VARCHAR2(200);
8079: BEGIN

Line 8076: l_manager_display_name wf_users.display_name%type;

8072: p_item_key IN VARCHAR2,
8073: p_manager_target IN VARCHAR2) IS
8074: --------------------------------------------------------
8075: l_manager_name wf_users.name%type;
8076: l_manager_display_name wf_users.display_name%type;
8077: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
8078: l_debug_info VARCHAR2(200);
8079: BEGIN
8080:

Line 8533: l_manager_name wf_users.name%type;

8529: p_funmode IN VARCHAR2,
8530: p_result OUT NOCOPY VARCHAR2) IS
8531: ----------------------------------------------------------------------
8532: l_manager_id NUMBER;
8533: l_manager_name wf_users.name%type;
8534: l_manager_display_name wf_users.display_name%type;
8535: l_debug_info VARCHAR2(200);
8536: BEGIN
8537:

Line 8534: l_manager_display_name wf_users.display_name%type;

8530: p_result OUT NOCOPY VARCHAR2) IS
8531: ----------------------------------------------------------------------
8532: l_manager_id NUMBER;
8533: l_manager_name wf_users.name%type;
8534: l_manager_display_name wf_users.display_name%type;
8535: l_debug_info VARCHAR2(200);
8536: BEGIN
8537:
8538: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start SetApproverEqualManager');

Line 8601: l_approver_name wf_users.name%type;

8597: p_funmode IN VARCHAR2,
8598: p_result OUT NOCOPY VARCHAR2) IS
8599: ----------------------------------------------------------------------
8600: l_approver_id NUMBER;
8601: l_approver_name wf_users.name%type;
8602: l_approver_display_name wf_users.display_name%type;
8603: l_debug_info VARCHAR2(200);
8604: BEGIN
8605:

Line 8602: l_approver_display_name wf_users.display_name%type;

8598: p_result OUT NOCOPY VARCHAR2) IS
8599: ----------------------------------------------------------------------
8600: l_approver_id NUMBER;
8601: l_approver_name wf_users.name%type;
8602: l_approver_display_name wf_users.display_name%type;
8603: l_debug_info VARCHAR2(200);
8604: BEGIN
8605:
8606: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start RecordForwardFromInfo');

Line 8975: l_emp_name wf_users.name%type;

8971: p_funmode IN VARCHAR2,
8972: p_result OUT NOCOPY VARCHAR2) IS
8973: ---------------------------------------------------------
8974: l_preparer_id NUMBER;
8975: l_emp_name wf_users.name%type;
8976: l_emp_num VARCHAR2(30);
8977: l_emp_cost_center VARCHAR2(240);
8978: l_debug_info VARCHAR2(200);
8979: BEGIN

Line 9268: V_employee_name wf_users.name%type;

9264: -- employee in the third party case.
9265: --
9266:
9267: V_employee_id NUMBER;
9268: V_employee_name wf_users.name%type;
9269: V_employee_display_name wf_users.display_name%type;
9270: l_debug_info VARCHAR2(200);
9271:
9272: BEGIN

Line 9269: V_employee_display_name wf_users.display_name%type;

9265: --
9266:
9267: V_employee_id NUMBER;
9268: V_employee_name wf_users.name%type;
9269: V_employee_display_name wf_users.display_name%type;
9270: l_debug_info VARCHAR2(200);
9271:
9272: BEGIN
9273:

Line 10317: l_Transferee wf_users.name%type;

10313:
10314: l_notificationID NUMBER;
10315: l_TransferNotificationID NUMBER;
10316: l_TransferToID NUMBER;
10317: l_Transferee wf_users.name%type;
10318: l_TransferToName wf_users.name%type;
10319: l_preparer_id NUMBER;
10320: l_preparer_name wf_users.name%type;
10321: l_preparer_display_name wf_users.display_name%type;

Line 10318: l_TransferToName wf_users.name%type;

10314: l_notificationID NUMBER;
10315: l_TransferNotificationID NUMBER;
10316: l_TransferToID NUMBER;
10317: l_Transferee wf_users.name%type;
10318: l_TransferToName wf_users.name%type;
10319: l_preparer_id NUMBER;
10320: l_preparer_name wf_users.name%type;
10321: l_preparer_display_name wf_users.display_name%type;
10322: l_employee_id NUMBER;

Line 10320: l_preparer_name wf_users.name%type;

10316: l_TransferToID NUMBER;
10317: l_Transferee wf_users.name%type;
10318: l_TransferToName wf_users.name%type;
10319: l_preparer_id NUMBER;
10320: l_preparer_name wf_users.name%type;
10321: l_preparer_display_name wf_users.display_name%type;
10322: l_employee_id NUMBER;
10323: l_AMEEnabled VARCHAR2(1);
10324: l_AmeMasterItemKey VARCHAR2(30);

Line 10321: l_preparer_display_name wf_users.display_name%type;

10317: l_Transferee wf_users.name%type;
10318: l_TransferToName wf_users.name%type;
10319: l_preparer_id NUMBER;
10320: l_preparer_name wf_users.name%type;
10321: l_preparer_display_name wf_users.display_name%type;
10322: l_employee_id NUMBER;
10323: l_AMEEnabled VARCHAR2(1);
10324: l_AmeMasterItemKey VARCHAR2(30);
10325: l_forwarder AME_UTIL.approverRecord2 default ame_util.emptyApproverRecord2;

Line 10929: l_Transferee wf_users.name%type;

10925: ----------------------------------------------------------------------
10926: l_debug_info VARCHAR2(1000);
10927:
10928: l_notificationID NUMBER;
10929: l_Transferee wf_users.name%type;
10930: l_TransferToName wf_users.name%type;
10931:
10932: l_approver_person_id wf_roles.orig_system_id%TYPE;
10933:

Line 10930: l_TransferToName wf_users.name%type;

10926: l_debug_info VARCHAR2(1000);
10927:
10928: l_notificationID NUMBER;
10929: l_Transferee wf_users.name%type;
10930: l_TransferToName wf_users.name%type;
10931:
10932: l_approver_person_id wf_roles.orig_system_id%TYPE;
10933:
10934: BEGIN

Line 16177: l_manager_name wf_users.name%type;

16173: l_childItemKey wf_items.item_key%type;
16174: l_child_item_key wf_items.item_key%type;
16175: l_masterUserKey wf_items.user_key%type;
16176:
16177: l_manager_name wf_users.name%type;
16178: l_manager_display_name wf_users.display_name%type;
16179:
16180: l_master_report_id number;
16181:

Line 16178: l_manager_display_name wf_users.display_name%type;

16174: l_child_item_key wf_items.item_key%type;
16175: l_masterUserKey wf_items.user_key%type;
16176:
16177: l_manager_name wf_users.name%type;
16178: l_manager_display_name wf_users.display_name%type;
16179:
16180: l_master_report_id number;
16181:
16182: fixable_exception EXCEPTION;