eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_H2PI_PERSON_UPLOAD dependencies on PER_ALL_PEOPLE_F

Line 700: FROM per_all_people_f per

696:
697: CURSOR csr_ed_person_ovn (p_per_id NUMBER,
698: p_esd DATE) IS
699: SELECT per.object_version_number
700: FROM per_all_people_f per
701: WHERE per.person_id = p_per_id
702: AND p_esd BETWEEN per.effective_start_date
703: AND per.effective_end_date;
704:

Line 712: l_ud_person_id per_all_people_f.person_id%TYPE;

708: l_proc VARCHAR2(72) := g_package||'upload_person';
709:
710: v_ud_per hr_h2pi_employees%ROWTYPE;
711:
712: l_ud_person_id per_all_people_f.person_id%TYPE;
713: l_ud_assignment_id per_all_assignments_f.assignment_id%TYPE;
714: l_ud_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
715:
716: l_person_id per_all_people_f.person_id%TYPE;

Line 716: l_person_id per_all_people_f.person_id%TYPE;

712: l_ud_person_id per_all_people_f.person_id%TYPE;
713: l_ud_assignment_id per_all_assignments_f.assignment_id%TYPE;
714: l_ud_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
715:
716: l_person_id per_all_people_f.person_id%TYPE;
717: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
718: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
719: l_person_type per_person_types.system_person_type%TYPE;
720: l_ovn per_all_people_f.object_version_number%TYPE;

Line 720: l_ovn per_all_people_f.object_version_number%TYPE;

716: l_person_id per_all_people_f.person_id%TYPE;
717: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
718: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
719: l_person_type per_person_types.system_person_type%TYPE;
720: l_ovn per_all_people_f.object_version_number%TYPE;
721: l_asg_ovn per_all_people_f.object_version_number%TYPE;
722: l_esd per_all_people_f.effective_start_date%TYPE;
723: l_eed per_all_people_f.effective_end_date%TYPE;
724: l_comment_id per_all_people_f.comment_id%TYPE;

Line 721: l_asg_ovn per_all_people_f.object_version_number%TYPE;

717: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
718: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
719: l_person_type per_person_types.system_person_type%TYPE;
720: l_ovn per_all_people_f.object_version_number%TYPE;
721: l_asg_ovn per_all_people_f.object_version_number%TYPE;
722: l_esd per_all_people_f.effective_start_date%TYPE;
723: l_eed per_all_people_f.effective_end_date%TYPE;
724: l_comment_id per_all_people_f.comment_id%TYPE;
725: l_full_name per_all_people_f.full_name%TYPE;

Line 722: l_esd per_all_people_f.effective_start_date%TYPE;

718: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
719: l_person_type per_person_types.system_person_type%TYPE;
720: l_ovn per_all_people_f.object_version_number%TYPE;
721: l_asg_ovn per_all_people_f.object_version_number%TYPE;
722: l_esd per_all_people_f.effective_start_date%TYPE;
723: l_eed per_all_people_f.effective_end_date%TYPE;
724: l_comment_id per_all_people_f.comment_id%TYPE;
725: l_full_name per_all_people_f.full_name%TYPE;
726: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

Line 723: l_eed per_all_people_f.effective_end_date%TYPE;

719: l_person_type per_person_types.system_person_type%TYPE;
720: l_ovn per_all_people_f.object_version_number%TYPE;
721: l_asg_ovn per_all_people_f.object_version_number%TYPE;
722: l_esd per_all_people_f.effective_start_date%TYPE;
723: l_eed per_all_people_f.effective_end_date%TYPE;
724: l_comment_id per_all_people_f.comment_id%TYPE;
725: l_full_name per_all_people_f.full_name%TYPE;
726: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
727: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

Line 724: l_comment_id per_all_people_f.comment_id%TYPE;

720: l_ovn per_all_people_f.object_version_number%TYPE;
721: l_asg_ovn per_all_people_f.object_version_number%TYPE;
722: l_esd per_all_people_f.effective_start_date%TYPE;
723: l_eed per_all_people_f.effective_end_date%TYPE;
724: l_comment_id per_all_people_f.comment_id%TYPE;
725: l_full_name per_all_people_f.full_name%TYPE;
726: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
727: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
728: l_name_combination_warning BOOLEAN;

Line 725: l_full_name per_all_people_f.full_name%TYPE;

721: l_asg_ovn per_all_people_f.object_version_number%TYPE;
722: l_esd per_all_people_f.effective_start_date%TYPE;
723: l_eed per_all_people_f.effective_end_date%TYPE;
724: l_comment_id per_all_people_f.comment_id%TYPE;
725: l_full_name per_all_people_f.full_name%TYPE;
726: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
727: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
728: l_name_combination_warning BOOLEAN;
729: l_assign_payroll_warning BOOLEAN;

Line 732: l_max_eed per_all_people_f.effective_end_date%TYPE;

728: l_name_combination_warning BOOLEAN;
729: l_assign_payroll_warning BOOLEAN;
730: l_orig_hire_warning BOOLEAN;
731:
732: l_max_eed per_all_people_f.effective_end_date%TYPE;
733: l_del_ovn per_all_people_f.object_version_number%TYPE;
734: l_del_esd per_all_people_f.effective_start_date%TYPE;
735: l_del_eed per_all_people_f.effective_end_date%TYPE;
736:

Line 733: l_del_ovn per_all_people_f.object_version_number%TYPE;

729: l_assign_payroll_warning BOOLEAN;
730: l_orig_hire_warning BOOLEAN;
731:
732: l_max_eed per_all_people_f.effective_end_date%TYPE;
733: l_del_ovn per_all_people_f.object_version_number%TYPE;
734: l_del_esd per_all_people_f.effective_start_date%TYPE;
735: l_del_eed per_all_people_f.effective_end_date%TYPE;
736:
737: l_records_same BOOLEAN;

Line 734: l_del_esd per_all_people_f.effective_start_date%TYPE;

730: l_orig_hire_warning BOOLEAN;
731:
732: l_max_eed per_all_people_f.effective_end_date%TYPE;
733: l_del_ovn per_all_people_f.object_version_number%TYPE;
734: l_del_esd per_all_people_f.effective_start_date%TYPE;
735: l_del_eed per_all_people_f.effective_end_date%TYPE;
736:
737: l_records_same BOOLEAN;
738: l_future_records BOOLEAN;

Line 735: l_del_eed per_all_people_f.effective_end_date%TYPE;

731:
732: l_max_eed per_all_people_f.effective_end_date%TYPE;
733: l_del_ovn per_all_people_f.object_version_number%TYPE;
734: l_del_esd per_all_people_f.effective_start_date%TYPE;
735: l_del_eed per_all_people_f.effective_end_date%TYPE;
736:
737: l_records_same BOOLEAN;
738: l_future_records BOOLEAN;
739: l_update_mode VARCHAR2(30);

Line 750: (p_table_name => 'PER_ALL_PEOPLE_F',

746: p_effective_start_date);
747: FETCH csr_ud_person INTO v_ud_per;
748:
749: l_person_id := hr_h2pi_map.get_to_id
750: (p_table_name => 'PER_ALL_PEOPLE_F',
751: p_from_id => p_person_id);
752:
753: IF l_person_id = -1 THEN
754: hr_utility.set_location(l_proc, 20);

Line 857: (p_table_name => 'PER_ALL_PEOPLE_F',

853: );
854:
855: hr_utility.set_location(l_proc, 30);
856: hr_h2pi_map.create_id_mapping
857: (p_table_name => 'PER_ALL_PEOPLE_F',
858: p_from_id => p_person_id,
859: p_to_id => l_person_id);
860:
861: SELECT asg.assignment_id

Line 938: FROM per_all_people_f per

934: l_records_same := FALSE;
935:
936: SELECT MAX(per.effective_end_date)
937: INTO l_max_eed
938: FROM per_all_people_f per
939: WHERE per.person_id = l_person_id;
940:
941: IF l_max_eed > l_eed THEN
942: hr_utility.set_location(l_proc, 100);

Line 1313: (p_table_name => 'PER_ALL_PEOPLE_F',

1309: BEGIN
1310: hr_utility.set_location('Entering:'|| l_proc, 10);
1311:
1312: l_person_id := hr_h2pi_map.get_to_id
1313: (p_table_name => 'PER_ALL_PEOPLE_F',
1314: p_from_id => p_person_id);
1315:
1316: IF l_person_id <> -1 THEN
1317:

Line 1391: l_per_start_date per_all_people_f.effective_start_date%TYPE;

1387: l_person_id per_addresses.person_id%TYPE;
1388: l_address_id per_addresses.address_id%TYPE;
1389: l_ovn per_addresses.object_version_number%TYPE;
1390: v_ud_adr hr_h2pi_addresses%ROWTYPE;
1391: l_per_start_date per_all_people_f.effective_start_date%TYPE;
1392: l_date_from per_addresses.date_from%TYPE;
1393:
1394: BEGIN
1395: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1401: (p_table_name => 'PER_ALL_PEOPLE_F',

1397: OPEN csr_ud_address(p_address_id);
1398: FETCH csr_ud_address INTO v_ud_adr;
1399:
1400: l_person_id := hr_h2pi_map.get_to_id
1401: (p_table_name => 'PER_ALL_PEOPLE_F',
1402: p_from_id => v_ud_adr.person_id,
1403: p_report_error => TRUE);
1404:
1405: hr_utility.set_location(l_proc, 20);

Line 1417: FROM per_all_people_f per

1413: * Check that the employee exists for the date range
1414: */
1415: SELECT MIN(per.effective_start_date)
1416: INTO l_per_start_date
1417: FROM per_all_people_f per
1418: WHERE per.person_id = l_person_id;
1419: IF NVL(v_ud_adr.date_to, l_per_start_date) >= l_per_start_date THEN
1420: IF v_ud_adr.date_from < l_per_start_date THEN
1421: l_date_from := l_per_start_date;

Line 1608: per_all_people_f per,

1604: p_esd DATE) IS
1605: SELECT pos.object_version_number,
1606: pos.period_of_service_id
1607: FROM per_all_assignments_f asg,
1608: per_all_people_f per,
1609: per_periods_of_service pos
1610: WHERE asg.assignment_id = p_asg_id
1611: AND p_esd BETWEEN asg.effective_start_date
1612: AND asg.effective_end_date

Line 1654: l_person_id per_all_people_f.person_id%TYPE;

1650: v_ud_asg hr_h2pi_assignments%ROWTYPE;
1651: v_ed_asg hr_h2pi_assignments_v%ROWTYPE;
1652: v_ud_pos hr_h2pi_periods_of_service%ROWTYPE;
1653:
1654: l_person_id per_all_people_f.person_id%TYPE;
1655: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1656: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
1657: l_ovn per_all_people_f.object_version_number%TYPE;
1658: l_pos_ovn per_all_people_f.object_version_number%TYPE;

Line 1657: l_ovn per_all_people_f.object_version_number%TYPE;

1653:
1654: l_person_id per_all_people_f.person_id%TYPE;
1655: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1656: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
1657: l_ovn per_all_people_f.object_version_number%TYPE;
1658: l_pos_ovn per_all_people_f.object_version_number%TYPE;
1659: l_esd per_all_people_f.effective_start_date%TYPE;
1660: l_eed per_all_people_f.effective_end_date%TYPE;
1661: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

Line 1658: l_pos_ovn per_all_people_f.object_version_number%TYPE;

1654: l_person_id per_all_people_f.person_id%TYPE;
1655: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1656: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
1657: l_ovn per_all_people_f.object_version_number%TYPE;
1658: l_pos_ovn per_all_people_f.object_version_number%TYPE;
1659: l_esd per_all_people_f.effective_start_date%TYPE;
1660: l_eed per_all_people_f.effective_end_date%TYPE;
1661: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
1662: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

Line 1659: l_esd per_all_people_f.effective_start_date%TYPE;

1655: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1656: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
1657: l_ovn per_all_people_f.object_version_number%TYPE;
1658: l_pos_ovn per_all_people_f.object_version_number%TYPE;
1659: l_esd per_all_people_f.effective_start_date%TYPE;
1660: l_eed per_all_people_f.effective_end_date%TYPE;
1661: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
1662: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
1663:

Line 1660: l_eed per_all_people_f.effective_end_date%TYPE;

1656: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
1657: l_ovn per_all_people_f.object_version_number%TYPE;
1658: l_pos_ovn per_all_people_f.object_version_number%TYPE;
1659: l_esd per_all_people_f.effective_start_date%TYPE;
1660: l_eed per_all_people_f.effective_end_date%TYPE;
1661: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
1662: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
1663:
1664: l_max_eed per_all_assignments_f.effective_end_date%TYPE;

Line 1785: (p_table_name => 'PER_ALL_PEOPLE_F',

1781: ELSE
1782:
1783: hr_utility.set_location(l_proc, 70);
1784: l_person_id := hr_h2pi_map.get_to_id
1785: (p_table_name => 'PER_ALL_PEOPLE_F',
1786: p_from_id => v_ud_asg.person_id,
1787: p_report_error => TRUE);
1788:
1789: l_organization_id := hr_h2pi_map.get_to_id

Line 2064: (p_table_name => 'PER_ALL_PEOPLE_F',

2060: IF v_ud_asg.primary_flag = 'Y' AND
2061: v_ed_asg.primary_flag = 'N' THEN
2062: hr_utility.set_location(l_proc, 160);
2063: l_person_id := hr_h2pi_map.get_to_id
2064: (p_table_name => 'PER_ALL_PEOPLE_F',
2065: p_from_id => v_ud_asg.person_id,
2066: p_report_error => TRUE);
2067:
2068: hr_utility.set_location(l_proc, 170);

Line 5145: l_person_id per_all_people_f.person_id%TYPE;

5141: l_input_value_id2 pay_input_values_f.input_value_id%TYPE;
5142: l_ud_input_value_id1 pay_input_values_f.input_value_id%TYPE;
5143: l_ud_input_value_id2 pay_input_values_f.input_value_id%TYPE;
5144: l_ud_assignment_id per_all_assignments_f.assignment_id%TYPE;
5145: l_person_id per_all_people_f.person_id%TYPE;
5146:
5147: l_effective_date DATE;
5148:
5149: begin

Line 5152: (p_table_name => 'PER_ALL_PEOPLE_F',

5148:
5149: begin
5150: hr_utility.set_location('Entering:'|| l_proc, 10);
5151: l_person_id := hr_h2pi_map.get_to_id
5152: (p_table_name => 'PER_ALL_PEOPLE_F',
5153: p_from_id => p_person_id,
5154: p_report_error => TRUE);
5155:
5156: FOR v_asg IN csr_ed_assignment(l_person_id) LOOP