APPS.PON_AWARD_APPROVAL_PKG dependencies on FND_USER

Line 43: user_id fnd_user.user_id%TYPE,

39: ERROR_FOR_ADMIN CONSTANT INTEGER := 5;
40:
41: -- a record that stores information about an employee
42: TYPE employeeRecord IS RECORD (
43: user_id fnd_user.user_id%TYPE,
44: user_name fnd_user.user_name%TYPE,
45: person_id per_all_people_f.person_id%TYPE
46: );
47:

Line 44: user_name fnd_user.user_name%TYPE,

40:
41: -- a record that stores information about an employee
42: TYPE employeeRecord IS RECORD (
43: user_id fnd_user.user_id%TYPE,
44: user_name fnd_user.user_name%TYPE,
45: person_id per_all_people_f.person_id%TYPE
46: );
47:
48: -- a null employee

Line 837: FROM fnd_user

833: aname => 'PREPARER_TP_CONTACT_NAME');
834:
835: SELECT user_id
836: INTO l_tp_contact_user_id
837: FROM fnd_user
838: WHERE user_name = l_tp_contact_user_name;
839:
840: -- update previous transaction id column with current transaction id
841: UPDATE pon_auction_headers_all

Line 1023: ELSE -- FND USER setup in AME.

1019: ELSIF l_next_approver.orig_system = 'PER' THEN -- Emp-Supervisor Hierarchy setup in AME.
1020:
1021: get_employee_info_for_person(l_next_approver.orig_system_id, l_next_approver_employee);
1022:
1023: ELSE -- FND USER setup in AME.
1024:
1025: get_employee_info_for_user(l_next_approver.orig_system_id, l_next_approver_employee);
1026:
1027: END IF;

Line 1140: FROM fnd_user

1136: aname => 'APPLICATION_ERROR');
1137:
1138: SELECT user_id
1139: INTO l_tp_contact_user_id
1140: FROM fnd_user
1141: WHERE user_name = l_tp_contact_user_name;
1142:
1143: -- record that document as been rejected (as a result of an error)
1144: add_action_history(l_auction_header_id,

Line 1221: FROM fnd_user

1217: IF l_admin_approver.orig_system_id IS NOT NULL THEN
1218: BEGIN
1219: SELECT user_name
1220: INTO l_oam_admin_user_name
1221: FROM fnd_user
1222: WHERE employee_id = l_admin_approver.orig_system_id;
1223: EXCEPTION
1224: WHEN no_data_found OR too_many_rows THEN
1225: NULL;

Line 1513: ELSE -- FND USER setup in AME.

1509: ELSIF l_approver.orig_system = 'PER' THEN -- Emp-Supervisor Hierarchy setup in AME.
1510:
1511: get_employee_info_for_person(l_approver.orig_system_id, l_approver_employee);
1512:
1513: ELSE -- FND USER setup in AME.
1514:
1515: get_employee_info_for_user(l_approver.orig_system_id, l_approver_employee);
1516:
1517: END IF;

Line 2917: fnd_user users

2913: SELECT NVL(persons.full_name, users.user_name)
2914: INTO l_display_name
2915: FROM
2916: per_all_people_f persons,
2917: fnd_user users
2918: WHERE
2919: users.employee_id = persons.person_id(+)
2920: AND users.user_id = p_user_id
2921: AND TRUNC(sysdate) between persons.effective_start_date and persons.effective_end_date;

Line 2944: fnd_user users

2940: SELECT NVL(persons.full_name, users.user_name)
2941: INTO l_display_name
2942: FROM
2943: per_all_people_f persons,
2944: fnd_user users
2945: WHERE
2946: users.employee_id = persons.person_id(+)
2947: AND users.user_name = p_user_name
2948: AND TRUNC(sysdate) between persons.effective_start_date and persons.effective_end_date;

Line 2997: fnd_user users

2993: p_employee.user_name,
2994: p_employee.person_id
2995: FROM
2996: pon_employees_current_v emp,
2997: fnd_user users
2998: WHERE
2999: emp.person_id = users.employee_id
3000: AND users.user_id = p_user_id
3001: AND users.start_date <= SYSDATE

Line 3027: fnd_user users

3023: p_employee.user_name,
3024: p_employee.person_id
3025: FROM
3026: pon_employees_current_v emp,
3027: fnd_user users
3028: WHERE
3029: emp.person_id = users.employee_id
3030: AND users.user_name = p_user_name
3031: AND users.start_date <= SYSDATE

Line 3057: fnd_user users

3053: p_employee.user_name,
3054: p_employee.person_id
3055: FROM
3056: pon_employees_current_v emp,
3057: fnd_user users
3058: WHERE
3059: emp.person_id = users.employee_id
3060: AND emp.person_id = p_person_id
3061: AND users.start_date <= SYSDATE