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

Line 161: l_current_npw_flag per_people_f.current_npw_flag%type;

157: l_dpdnt_adoption_date date;
158: l_per_object_version_number number;
159: l_per_effective_start_date date;
160: l_per_effective_end_date date;
161: l_current_npw_flag per_people_f.current_npw_flag%type;
162: l_current_applicant_flag per_people_f.current_applicant_flag%type;
163: l_current_employee_flag per_people_f.current_employee_flag%type;
164: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
165: l_employee_number per_people_f.employee_number%TYPE;

Line 162: l_current_applicant_flag per_people_f.current_applicant_flag%type;

158: l_per_object_version_number number;
159: l_per_effective_start_date date;
160: l_per_effective_end_date date;
161: l_current_npw_flag per_people_f.current_npw_flag%type;
162: l_current_applicant_flag per_people_f.current_applicant_flag%type;
163: l_current_employee_flag per_people_f.current_employee_flag%type;
164: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
165: l_employee_number per_people_f.employee_number%TYPE;
166: l_applicant_number per_people_f.applicant_number%TYPE;

Line 163: l_current_employee_flag per_people_f.current_employee_flag%type;

159: l_per_effective_start_date date;
160: l_per_effective_end_date date;
161: l_current_npw_flag per_people_f.current_npw_flag%type;
162: l_current_applicant_flag per_people_f.current_applicant_flag%type;
163: l_current_employee_flag per_people_f.current_employee_flag%type;
164: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
165: l_employee_number per_people_f.employee_number%TYPE;
166: l_applicant_number per_people_f.applicant_number%TYPE;
167: l_npw_number per_people_f.npw_number%TYPE;

Line 164: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;

160: l_per_effective_end_date date;
161: l_current_npw_flag per_people_f.current_npw_flag%type;
162: l_current_applicant_flag per_people_f.current_applicant_flag%type;
163: l_current_employee_flag per_people_f.current_employee_flag%type;
164: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
165: l_employee_number per_people_f.employee_number%TYPE;
166: l_applicant_number per_people_f.applicant_number%TYPE;
167: l_npw_number per_people_f.npw_number%TYPE;
168: l_full_name per_people_f.full_name%type;

Line 165: l_employee_number per_people_f.employee_number%TYPE;

161: l_current_npw_flag per_people_f.current_npw_flag%type;
162: l_current_applicant_flag per_people_f.current_applicant_flag%type;
163: l_current_employee_flag per_people_f.current_employee_flag%type;
164: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
165: l_employee_number per_people_f.employee_number%TYPE;
166: l_applicant_number per_people_f.applicant_number%TYPE;
167: l_npw_number per_people_f.npw_number%TYPE;
168: l_full_name per_people_f.full_name%type;
169: l_comment_id number;

Line 166: l_applicant_number per_people_f.applicant_number%TYPE;

162: l_current_applicant_flag per_people_f.current_applicant_flag%type;
163: l_current_employee_flag per_people_f.current_employee_flag%type;
164: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
165: l_employee_number per_people_f.employee_number%TYPE;
166: l_applicant_number per_people_f.applicant_number%TYPE;
167: l_npw_number per_people_f.npw_number%TYPE;
168: l_full_name per_people_f.full_name%type;
169: l_comment_id number;
170: l_dob_null_warning boolean;

Line 167: l_npw_number per_people_f.npw_number%TYPE;

163: l_current_employee_flag per_people_f.current_employee_flag%type;
164: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
165: l_employee_number per_people_f.employee_number%TYPE;
166: l_applicant_number per_people_f.applicant_number%TYPE;
167: l_npw_number per_people_f.npw_number%TYPE;
168: l_full_name per_people_f.full_name%type;
169: l_comment_id number;
170: l_dob_null_warning boolean;
171: l_orig_hire_warning boolean;

Line 168: l_full_name per_people_f.full_name%type;

164: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
165: l_employee_number per_people_f.employee_number%TYPE;
166: l_applicant_number per_people_f.applicant_number%TYPE;
167: l_npw_number per_people_f.npw_number%TYPE;
168: l_full_name per_people_f.full_name%type;
169: l_comment_id number;
170: l_dob_null_warning boolean;
171: l_orig_hire_warning boolean;
172: l_assignment_id number;

Line 827: l_object_version_number per_people_f.object_version_number%type;

823: --
824: -- Declare cursors and local variables
825: --
826: l_proc varchar2(72) := g_package||'convert_to_cwk';
827: l_object_version_number per_people_f.object_version_number%type;
828: l_npw_number per_people_f.npw_number%type;
829: l_person_type_id number := p_person_type_id;
830: l_person_type_id1 number;
831: l_effective_date date;

Line 828: l_npw_number per_people_f.npw_number%type;

824: -- Declare cursors and local variables
825: --
826: l_proc varchar2(72) := g_package||'convert_to_cwk';
827: l_object_version_number per_people_f.object_version_number%type;
828: l_npw_number per_people_f.npw_number%type;
829: l_person_type_id number := p_person_type_id;
830: l_person_type_id1 number;
831: l_effective_date date;
832: l_datetrack_update_mode varchar2(30);

Line 1222: l_applicant_number per_people_f.applicant_number%type;

1218: l_assignment_id number;
1219: l_asg_object_version_number number;
1220: l_assignment_sequence number;
1221: l_object_version_number number;
1222: l_applicant_number per_people_f.applicant_number%type;
1223: l_dummy varchar2(1);
1224: --
1225: cursor csr_per_details
1226: (p_person_id number

Line 1714: l_npw_number per_people_f.npw_number%TYPE;

1710: l_dob_null_warning boolean;
1711: l_effective_date date;
1712: l_effective_end_date date;
1713: l_effective_start_date date;
1714: l_npw_number per_people_f.npw_number%TYPE;
1715: l_exists varchar2(1);
1716: l_full_name per_all_people_f.full_name%TYPE;
1717: l_legislation_code per_business_groups.legislation_code%TYPE;
1718: l_max_tpe_end_date date;

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

2020: end if;
2021: --
2022: hr_utility.set_location(l_proc, 240);
2023: --
2024: -- Lock the person record in PER_PEOPLE_F ready for UPDATE at a later point.
2025: -- (Note: This is necessary because calling the table handlers in locking
2026: -- ladder order invokes an error in per_pdp_upd.upd due to the person
2027: -- being modified by the per_per_upd.upd table handler.)
2028: --

Line 3475: UPDATE per_people_f pp

3471:
3472: FPD_FLAG := (l_final_process_date IS NOT NULL);
3473: --
3474: hr_utility.set_location(l_proc,55);
3475: UPDATE per_people_f pp
3476: SET pp.effective_end_date = hr_api.g_eot
3477: WHERE pp.person_id = p_person_id
3478: AND p_actual_termination_date
3479: BETWEEN pp.effective_start_date

Line 3483: DELETE per_people_f pp

3479: BETWEEN pp.effective_start_date
3480: AND pp.effective_end_date;
3481: --
3482: hr_utility.set_location(l_proc,60);
3483: DELETE per_people_f pp
3484: WHERE pp.person_id = p_person_id
3485: AND pp.effective_start_date > p_actual_termination_date;
3486: --
3487: hr_utility.set_location(l_proc,65);