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_EX_EMPLOYEE_API dependencies on PER_PEOPLE_F

Line 649: l_applicant_number per_people_f.applicant_number%TYPE;

645: l_effective_date date;
646: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
647: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
648: l_employee_number per_all_people_f.employee_number%TYPE;
649: l_applicant_number per_people_f.applicant_number%TYPE;
650: l_npw_number per_people_f.npw_number%TYPE;
651: l_exists varchar2(1);
652: l_full_name per_all_people_f.full_name%TYPE;
653: l_legislation_code per_business_groups.legislation_code%TYPE;

Line 650: l_npw_number per_people_f.npw_number%TYPE;

646: l_effective_end_date per_assignments_f.effective_end_date%TYPE;
647: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
648: l_employee_number per_all_people_f.employee_number%TYPE;
649: l_applicant_number per_people_f.applicant_number%TYPE;
650: l_npw_number per_people_f.npw_number%TYPE;
651: l_exists varchar2(1);
652: l_full_name per_all_people_f.full_name%TYPE;
653: l_legislation_code per_business_groups.legislation_code%TYPE;
654: l_max_tpe_end_date per_assignments_f.effective_end_date%TYPE;

Line 666: l_per_effective_start_date per_people_f.effective_start_date%TYPE;

662: l_proc varchar2(72)
663: := g_package || 'actual_termination_emp';
664: l_system_person_type per_person_types.system_person_type%TYPE;
665: l_system_person_type1 per_person_types.system_person_type%TYPE;
666: l_per_effective_start_date per_people_f.effective_start_date%TYPE;
667: l_datetrack_mode varchar2(30);
668: l_validation_start_date date;
669: l_validation_end_date date;
670: l_actual_termination_date date;

Line 1573: -- Lock the person record in PER_PEOPLE_F ready for UPDATE at a later point.

1569: l_datetrack_mode := 'UPDATE';
1570: end if;
1571:
1572:
1573: -- Lock the person record in PER_PEOPLE_F ready for UPDATE at a later point.
1574: -- (Note: This is necessary because calling the table handlers in locking
1575: -- ladder order invokes an error in per_pds_upd.upd due to the person
1576: -- being modified by the per_per_upd.upd table handler.)
1577: --