[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;
976: aname => 'FIRST_AUTHORITY_APPROVER_ID');
977: END IF;
978: IF( l_person_id IS NULL OR l_person_id = -1 ) THEN
979: SELECT person_id into l_person_id FROM (
980: SELECT person.person_id FROM per_all_people_f person, per_all_assignments_f asg
981: WHERE asg.position_id = l_next_approver.orig_system_id and trunc(sysdate) between person.effective_start_date
982: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
983: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
984: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )
1467: aname => 'FIRST_AUTHORITY_APPROVER_ID');
1468: END IF;
1469: IF( l_person_id IS NULL OR l_person_id = -1 ) THEN
1470: SELECT person_id into l_person_id FROM (
1471: SELECT person.person_id FROM per_all_people_f person, per_all_assignments_f asg
1472: WHERE asg.position_id = l_approver.orig_system_id and trunc(sysdate) between person.effective_start_date
1473: and nvl(person.effective_end_date, trunc(sysdate)) and person.person_id = asg.person_id
1474: and asg.primary_flag = 'Y' and asg.assignment_type in ('E','C')
1475: and ( person.current_employee_flag = 'Y' or person.current_npw_flag = 'Y' )
1618: l_forwardee.api_insertion := ame_util.apiInsertion;
1619: END IF;
1620:
1621: IF l_forwardee.orig_system = 'POS' THEN
1622: 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;
1623: BEGIN
1624: SELECT position_id into l_forwardee.orig_system_id FROM PER_ALL_ASSIGNMENTS_F pa
1625: WHERE pa.person_id = l_forwardee.orig_system_id and pa.primary_flag = 'Y' and pa.assignment_type in ('E','C')
1626: and pa.position_id is not null and pa.assignment_status_type_id not in (
2011: log_string(l_statement_log_level, l_current_log_level, l_module_name, ' ---- Position Record. So trying to find out the position details ---- ');
2012:
2013: l_approver.orig_system := 'POS';
2014: IF l_approver.orig_system_id IS NOT NULL THEN
2015: 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 ;
2016: BEGIN
2017: SELECT position_id into l_approver.orig_system_id FROM PER_ALL_ASSIGNMENTS_F pa
2018: WHERE pa.person_id = l_approver.orig_system_id and pa.primary_flag = 'Y' and pa.assignment_type in ('E','C')
2019: and pa.position_id is not null and pa.assignment_status_type_id not in (
2912: -- if the full name is null, use the user name
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
2939: -- if the full name is null, use the user name
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
2964:
2965: BEGIN
2966: SELECT full_name
2967: INTO l_display_name
2968: FROM per_all_people_f
2969: WHERE person_id = p_person_id;
2970: EXCEPTION
2971: WHEN no_data_found OR too_many_rows THEN
2972: NULL;