[Home] [Help]
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
49: nullEmployeeRecord employeeRecord;
990: aname => 'FIRST_AUTHORITY_APPROVER_ID');
991: END IF;
992: IF( l_person_id IS NULL OR l_person_id = -1 ) THEN
993: SELECT person_id into l_person_id FROM (
994: SELECT person.person_id FROM per_all_people_f person, per_all_assignments_f asg
995: WHERE asg.position_id = l_next_approver.orig_system_id and trunc(sysdate) between person.effective_start_date
996: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
997: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
998: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )
1502: aname => 'FIRST_AUTHORITY_APPROVER_ID');
1503: END IF;
1504: IF( l_person_id IS NULL OR l_person_id = -1 ) THEN
1505: SELECT person_id into l_person_id FROM (
1506: SELECT person.person_id FROM per_all_people_f person, per_all_assignments_f asg
1507: WHERE asg.position_id = l_approver.orig_system_id and trunc(sysdate) between person.effective_start_date
1508: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
1509: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
1510: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )
1653: l_forwardee.api_insertion := ame_util.apiInsertion;
1654: END IF;
1655:
1656: IF l_forwardee.orig_system = 'POS' THEN
1657: select full_name into l_forwardee.display_name from per_all_people_f where person_id = l_forwardee.orig_system_id and TRUNC(sysdate) between effective_start_date and effective_end_date;
1658: BEGIN
1659: SELECT position_id into l_forwardee.orig_system_id FROM PER_ALL_ASSIGNMENTS_F pa
1660: WHERE pa.person_id = l_forwardee.orig_system_id and pa.primary_flag = 'Y' and pa.assignment_type in ('E','C')
1661: and pa.position_id is not null and pa.assignment_status_type_id not in (
2046: log_string(l_statement_log_level, l_current_log_level, l_module_name, ' ---- Position Record. So trying to find out the position details ---- ');
2047:
2048: l_approver.orig_system := 'POS';
2049: IF l_approver.orig_system_id IS NOT NULL THEN
2050: select full_name into l_approver.display_name from per_all_people_f where person_id = l_approver.orig_system_id and TRUNC(sysdate) between effective_start_date and effective_end_date ;
2051: BEGIN
2052: SELECT position_id into l_approver.orig_system_id FROM PER_ALL_ASSIGNMENTS_F pa
2053: WHERE pa.person_id = l_approver.orig_system_id and pa.primary_flag = 'Y' and pa.assignment_type in ('E','C')
2054: and pa.position_id is not null and pa.assignment_status_type_id not in (
2969: -- if the full name is null, use the user name
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
2996: -- if the full name is null, use the user name
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
3021:
3022: BEGIN
3023: SELECT full_name
3024: INTO l_display_name
3025: FROM per_all_people_f
3026: WHERE person_id = p_person_id;
3027: EXCEPTION
3028: WHEN no_data_found OR too_many_rows THEN
3029: NULL;