APPS.AR_AME_CMWF_API dependencies on FND_USER

Line 292: FROM fnd_user

288: FUNCTION get_employee_id (p_user_id NUMBER) RETURN NUMBER IS
289:
290: CURSOR c IS
291: SELECT employee_id
292: FROM fnd_user
293: WHERE user_id = p_user_id;
294:
295: l_employee_id NUMBER;
296:

Line 337: FROM fnd_user

333: FUNCTION get_user_id (p_employee_id IN NUMBER) RETURN NUMBER IS
334:
335: CURSOR c IS
336: SELECT user_id
337: FROM fnd_user
338: WHERE employee_id = p_employee_id
339: AND NVL(end_date,sysdate) >= sysdate ;
340:
341: l_user_id NUMBER;

Line 523: FROM fnd_user

519: p_result OUT NOCOPY VARCHAR2) IS
520:
521: CURSOR c (p_user_name VARCHAR2) IS
522: SELECT user_id
523: FROM fnd_user
524: WHERE user_name = p_user_name;
525:
526: l_document_id NUMBER;
527: l_customer_trx_id NUMBER;

Line 880: l_manager_employee_id fnd_user.employee_id%TYPE;

876: p_approver_employee_id IN VARCHAR2,
877: x_approver_user_id OUT NOCOPY NUMBER,
878: x_approver_employee_id OUT NOCOPY NUMBER) IS
879:
880: l_manager_employee_id fnd_user.employee_id%TYPE;
881:
882: BEGIN
883:
884: l_manager_employee_id := wf_engine.getitemattrnumber(

Line 2353: l_approver_id fnd_user.user_id%TYPE;

2349: p_actid IN NUMBER,
2350: p_funcmode IN VARCHAR2,
2351: p_result OUT NOCOPY VARCHAR2) IS
2352:
2353: l_approver_id fnd_user.user_id%TYPE;
2354: l_employee_id fnd_user.employee_id%TYPE;
2355: l_approver_user_name wf_item_attribute_values.text_value%TYPE;
2356:
2357: CURSOR c (p_user_name VARCHAR2) IS

Line 2354: l_employee_id fnd_user.employee_id%TYPE;

2350: p_funcmode IN VARCHAR2,
2351: p_result OUT NOCOPY VARCHAR2) IS
2352:
2353: l_approver_id fnd_user.user_id%TYPE;
2354: l_employee_id fnd_user.employee_id%TYPE;
2355: l_approver_user_name wf_item_attribute_values.text_value%TYPE;
2356:
2357: CURSOR c (p_user_name VARCHAR2) IS
2358: SELECT employee_id, user_id

Line 2359: FROM fnd_user

2355: l_approver_user_name wf_item_attribute_values.text_value%TYPE;
2356:
2357: CURSOR c (p_user_name VARCHAR2) IS
2358: SELECT employee_id, user_id
2359: FROM fnd_user
2360: WHERE user_name = p_user_name;
2361:
2362: BEGIN
2363:

Line 2786: l_nonresponsive_employee_id fnd_user.employee_id%TYPE;

2782: AND effective_end_date;
2783:
2784:
2785: l_approval_path wf_item_attribute_values.text_value%TYPE;
2786: l_nonresponsive_employee_id fnd_user.employee_id%TYPE;
2787: l_nonresponsive_user_id fnd_user.user_id%TYPE;
2788: l_nonresponsive_user_name wf_users.name%TYPE;
2789: l_nonresponsive_display_name wf_users.display_name%TYPE;
2790: l_manager_employee_id fnd_user.employee_id%TYPE;

Line 2787: l_nonresponsive_user_id fnd_user.user_id%TYPE;

2783:
2784:
2785: l_approval_path wf_item_attribute_values.text_value%TYPE;
2786: l_nonresponsive_employee_id fnd_user.employee_id%TYPE;
2787: l_nonresponsive_user_id fnd_user.user_id%TYPE;
2788: l_nonresponsive_user_name wf_users.name%TYPE;
2789: l_nonresponsive_display_name wf_users.display_name%TYPE;
2790: l_manager_employee_id fnd_user.employee_id%TYPE;
2791: l_manager_user_name wf_users.name%TYPE;

Line 2790: l_manager_employee_id fnd_user.employee_id%TYPE;

2786: l_nonresponsive_employee_id fnd_user.employee_id%TYPE;
2787: l_nonresponsive_user_id fnd_user.user_id%TYPE;
2788: l_nonresponsive_user_name wf_users.name%TYPE;
2789: l_nonresponsive_display_name wf_users.display_name%TYPE;
2790: l_manager_employee_id fnd_user.employee_id%TYPE;
2791: l_manager_user_name wf_users.name%TYPE;
2792: l_manager_display_name wf_users.display_name%TYPE;
2793: l_escalation_count NUMBER;
2794: l_transaction_type VARCHAR2(30);