APPS.AR_AME_CMWF_API dependencies on FND_USER

Line 294: FROM fnd_user

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

Line 339: FROM fnd_user

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

Line 525: FROM fnd_user

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

Line 882: l_manager_employee_id fnd_user.employee_id%TYPE;

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

Line 996: from fnd_user

992: AND orig_system_id = user_id;
993:
994: cursor c3(user_id1 number) is
995: select employee_id
996: from fnd_user
997: where user_id =user_id1;
998:
999: BEGIN
1000:

Line 2394: l_approver_id fnd_user.user_id%TYPE;

2390: p_actid IN NUMBER,
2391: p_funcmode IN VARCHAR2,
2392: p_result OUT NOCOPY VARCHAR2) IS
2393:
2394: l_approver_id fnd_user.user_id%TYPE;
2395: l_employee_id fnd_user.employee_id%TYPE;
2396: l_approver_user_name wf_item_attribute_values.text_value%TYPE;
2397:
2398: CURSOR c (p_user_name VARCHAR2) IS

Line 2395: l_employee_id fnd_user.employee_id%TYPE;

2391: p_funcmode IN VARCHAR2,
2392: p_result OUT NOCOPY VARCHAR2) IS
2393:
2394: l_approver_id fnd_user.user_id%TYPE;
2395: l_employee_id fnd_user.employee_id%TYPE;
2396: l_approver_user_name wf_item_attribute_values.text_value%TYPE;
2397:
2398: CURSOR c (p_user_name VARCHAR2) IS
2399: SELECT employee_id, user_id

Line 2400: FROM fnd_user

2396: l_approver_user_name wf_item_attribute_values.text_value%TYPE;
2397:
2398: CURSOR c (p_user_name VARCHAR2) IS
2399: SELECT employee_id, user_id
2400: FROM fnd_user
2401: WHERE user_name = p_user_name;
2402:
2403: BEGIN
2404:

Line 2827: l_nonresponsive_employee_id fnd_user.employee_id%TYPE;

2823: AND effective_end_date;
2824:
2825:
2826: l_approval_path wf_item_attribute_values.text_value%TYPE;
2827: l_nonresponsive_employee_id fnd_user.employee_id%TYPE;
2828: l_nonresponsive_user_id fnd_user.user_id%TYPE;
2829: l_nonresponsive_user_name wf_users.name%TYPE;
2830: l_nonresponsive_display_name wf_users.display_name%TYPE;
2831: l_manager_employee_id fnd_user.employee_id%TYPE;

Line 2828: l_nonresponsive_user_id fnd_user.user_id%TYPE;

2824:
2825:
2826: l_approval_path wf_item_attribute_values.text_value%TYPE;
2827: l_nonresponsive_employee_id fnd_user.employee_id%TYPE;
2828: l_nonresponsive_user_id fnd_user.user_id%TYPE;
2829: l_nonresponsive_user_name wf_users.name%TYPE;
2830: l_nonresponsive_display_name wf_users.display_name%TYPE;
2831: l_manager_employee_id fnd_user.employee_id%TYPE;
2832: l_manager_user_name wf_users.name%TYPE;

Line 2831: l_manager_employee_id fnd_user.employee_id%TYPE;

2827: l_nonresponsive_employee_id fnd_user.employee_id%TYPE;
2828: l_nonresponsive_user_id fnd_user.user_id%TYPE;
2829: l_nonresponsive_user_name wf_users.name%TYPE;
2830: l_nonresponsive_display_name wf_users.display_name%TYPE;
2831: l_manager_employee_id fnd_user.employee_id%TYPE;
2832: l_manager_user_name wf_users.name%TYPE;
2833: l_manager_display_name wf_users.display_name%TYPE;
2834: l_escalation_count NUMBER;
2835: l_transaction_type VARCHAR2(30);