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 851: FROM fnd_user

847: aname => 'PREPARER_TP_CONTACT_NAME');
848:
849: SELECT user_id
850: INTO l_tp_contact_user_id
851: FROM fnd_user
852: WHERE user_name = l_tp_contact_user_name;
853:
854: -- update previous transaction id column with current transaction id
855: UPDATE pon_auction_headers_all

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

1033: ELSIF l_next_approver.orig_system = 'PER' THEN -- Emp-Supervisor Hierarchy setup in AME.
1034:
1035: get_employee_info_for_person(l_next_approver.orig_system_id, l_next_approver_employee);
1036:
1037: ELSE -- FND USER setup in AME.
1038:
1039: get_employee_info_for_user(l_next_approver.orig_system_id, l_next_approver_employee);
1040:
1041: END IF;

Line 1154: FROM fnd_user

1150: aname => 'APPLICATION_ERROR');
1151:
1152: SELECT user_id
1153: INTO l_tp_contact_user_id
1154: FROM fnd_user
1155: WHERE user_name = l_tp_contact_user_name;
1156:
1157: -- record that document as been rejected (as a result of an error)
1158: add_action_history(l_auction_header_id,

Line 1235: FROM fnd_user

1231: IF l_admin_approver.orig_system_id IS NOT NULL THEN
1232: BEGIN
1233: SELECT user_name
1234: INTO l_oam_admin_user_name
1235: FROM fnd_user
1236: WHERE employee_id = l_admin_approver.orig_system_id;
1237: EXCEPTION
1238: WHEN no_data_found OR too_many_rows THEN
1239: NULL;

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

1544: ELSIF l_approver.orig_system = 'PER' THEN -- Emp-Supervisor Hierarchy setup in AME.
1545:
1546: get_employee_info_for_person(l_approver.orig_system_id, l_approver_employee);
1547:
1548: ELSE -- FND USER setup in AME.
1549:
1550: get_employee_info_for_user(l_approver.orig_system_id, l_approver_employee);
1551:
1552: END IF;

Line 2974: fnd_user users

2970: SELECT NVL(persons.full_name, users.user_name)
2971: INTO l_display_name
2972: FROM
2973: per_all_people_f persons,
2974: fnd_user users
2975: WHERE
2976: users.employee_id = persons.person_id(+)
2977: AND users.user_id = p_user_id
2978: AND TRUNC(sysdate) between persons.effective_start_date and persons.effective_end_date;

Line 3001: fnd_user users

2997: SELECT NVL(persons.full_name, users.user_name)
2998: INTO l_display_name
2999: FROM
3000: per_all_people_f persons,
3001: fnd_user users
3002: WHERE
3003: users.employee_id = persons.person_id(+)
3004: AND users.user_name = p_user_name
3005: AND TRUNC(sysdate) between persons.effective_start_date and persons.effective_end_date;

Line 3055: fnd_user users

3051: p_employee.user_name,
3052: p_employee.person_id
3053: FROM
3054: --pon_employees_current_v emp,
3055: fnd_user users
3056: WHERE
3057: -- emp.person_id = users.employee_id
3058: users.user_id = p_user_id
3059: AND users.start_date <= SYSDATE

Line 3086: fnd_user users

3082: p_employee.user_name,
3083: p_employee.person_id
3084: FROM
3085: -- pon_employees_current_v emp,
3086: fnd_user users
3087: WHERE
3088: -- emp.person_id = users.employee_id
3089: users.user_name = p_user_name
3090: AND users.start_date <= SYSDATE

Line 3117: fnd_user users

3113: p_employee.user_name,
3114: p_employee.person_id
3115: FROM
3116: -- pon_employees_current_v emp,
3117: fnd_user users
3118: WHERE
3119: -- emp.person_id = users.employee_id
3120: users.employee_id = p_person_id
3121: AND users.start_date <= SYSDATE