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 444: l_current_npw_flag per_people_f.current_npw_flag%type;

440: l_dpdnt_adoption_date date;
441: l_per_object_version_number number;
442: l_per_effective_start_date date;
443: l_per_effective_end_date date;
444: l_current_npw_flag per_people_f.current_npw_flag%type;
445: l_current_applicant_flag per_people_f.current_applicant_flag%type;
446: l_current_employee_flag per_people_f.current_employee_flag%type;
447: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
448: l_employee_number per_people_f.employee_number%TYPE;

Line 445: l_current_applicant_flag per_people_f.current_applicant_flag%type;

441: l_per_object_version_number number;
442: l_per_effective_start_date date;
443: l_per_effective_end_date date;
444: l_current_npw_flag per_people_f.current_npw_flag%type;
445: l_current_applicant_flag per_people_f.current_applicant_flag%type;
446: l_current_employee_flag per_people_f.current_employee_flag%type;
447: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
448: l_employee_number per_people_f.employee_number%TYPE;
449: l_applicant_number per_people_f.applicant_number%TYPE;

Line 446: l_current_employee_flag per_people_f.current_employee_flag%type;

442: l_per_effective_start_date date;
443: l_per_effective_end_date date;
444: l_current_npw_flag per_people_f.current_npw_flag%type;
445: l_current_applicant_flag per_people_f.current_applicant_flag%type;
446: l_current_employee_flag per_people_f.current_employee_flag%type;
447: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
448: l_employee_number per_people_f.employee_number%TYPE;
449: l_applicant_number per_people_f.applicant_number%TYPE;
450: l_npw_number per_people_f.npw_number%TYPE;

Line 447: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;

443: l_per_effective_end_date date;
444: l_current_npw_flag per_people_f.current_npw_flag%type;
445: l_current_applicant_flag per_people_f.current_applicant_flag%type;
446: l_current_employee_flag per_people_f.current_employee_flag%type;
447: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
448: l_employee_number per_people_f.employee_number%TYPE;
449: l_applicant_number per_people_f.applicant_number%TYPE;
450: l_npw_number per_people_f.npw_number%TYPE;
451: l_full_name per_people_f.full_name%type;

Line 448: l_employee_number per_people_f.employee_number%TYPE;

444: l_current_npw_flag per_people_f.current_npw_flag%type;
445: l_current_applicant_flag per_people_f.current_applicant_flag%type;
446: l_current_employee_flag per_people_f.current_employee_flag%type;
447: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
448: l_employee_number per_people_f.employee_number%TYPE;
449: l_applicant_number per_people_f.applicant_number%TYPE;
450: l_npw_number per_people_f.npw_number%TYPE;
451: l_full_name per_people_f.full_name%type;
452: l_comment_id number;

Line 449: l_applicant_number per_people_f.applicant_number%TYPE;

445: l_current_applicant_flag per_people_f.current_applicant_flag%type;
446: l_current_employee_flag per_people_f.current_employee_flag%type;
447: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
448: l_employee_number per_people_f.employee_number%TYPE;
449: l_applicant_number per_people_f.applicant_number%TYPE;
450: l_npw_number per_people_f.npw_number%TYPE;
451: l_full_name per_people_f.full_name%type;
452: l_comment_id number;
453: l_dob_null_warning boolean;

Line 450: l_npw_number per_people_f.npw_number%TYPE;

446: l_current_employee_flag per_people_f.current_employee_flag%type;
447: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
448: l_employee_number per_people_f.employee_number%TYPE;
449: l_applicant_number per_people_f.applicant_number%TYPE;
450: l_npw_number per_people_f.npw_number%TYPE;
451: l_full_name per_people_f.full_name%type;
452: l_comment_id number;
453: l_dob_null_warning boolean;
454: l_orig_hire_warning boolean;

Line 451: l_full_name per_people_f.full_name%type;

447: l_current_emp_or_apl_flag per_people_f.current_emp_or_apl_flag%type;
448: l_employee_number per_people_f.employee_number%TYPE;
449: l_applicant_number per_people_f.applicant_number%TYPE;
450: l_npw_number per_people_f.npw_number%TYPE;
451: l_full_name per_people_f.full_name%type;
452: l_comment_id number;
453: l_dob_null_warning boolean;
454: l_orig_hire_warning boolean;
455: l_assignment_id number;

Line 1114: l_object_version_number per_people_f.object_version_number%type;

1110: --
1111: -- Declare cursors and local variables
1112: --
1113: l_proc varchar2(72) := g_package||'convert_to_cwk';
1114: l_object_version_number per_people_f.object_version_number%type;
1115: l_npw_number per_people_f.npw_number%type;
1116: l_person_type_id number := p_person_type_id;
1117: l_person_type_id1 number;
1118: l_person_type_id2 number;

Line 1115: l_npw_number per_people_f.npw_number%type;

1111: -- Declare cursors and local variables
1112: --
1113: l_proc varchar2(72) := g_package||'convert_to_cwk';
1114: l_object_version_number per_people_f.object_version_number%type;
1115: l_npw_number per_people_f.npw_number%type;
1116: l_person_type_id number := p_person_type_id;
1117: l_person_type_id1 number;
1118: l_person_type_id2 number;
1119: l_effective_date date;

Line 1588: l_applicant_number per_people_f.applicant_number%type;

1584: l_assignment_id number;
1585: l_asg_object_version_number number;
1586: l_assignment_sequence number;
1587: l_object_version_number number;
1588: l_applicant_number per_people_f.applicant_number%type;
1589: l_dummy varchar2(1);
1590: --
1591: cursor csr_per_details
1592: (p_person_id number

Line 2087: l_npw_number per_people_f.npw_number%TYPE;

2083: l_dob_null_warning boolean;
2084: l_effective_date date;
2085: l_effective_end_date date;
2086: l_effective_start_date date;
2087: l_npw_number per_people_f.npw_number%TYPE;
2088: l_exists varchar2(1);
2089: l_full_name per_all_people_f.full_name%TYPE;
2090: l_legislation_code per_business_groups.legislation_code%TYPE;
2091: l_max_tpe_end_date date;

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

2420: end if;
2421: --
2422: hr_utility.set_location(l_proc, 240);
2423: --
2424: -- Lock the person record in PER_PEOPLE_F ready for UPDATE at a later point.
2425: -- (Note: This is necessary because calling the table handlers in locking
2426: -- ladder order invokes an error in per_pdp_upd.upd due to the person
2427: -- being modified by the per_per_upd.upd table handler.)
2428: --

Line 3931: UPDATE per_people_f pp

3927:
3928: else
3929:
3930:
3931: UPDATE per_people_f pp
3932: SET pp.effective_end_date = hr_api.g_eot
3933: WHERE pp.person_id = p_person_id
3934: AND p_actual_termination_date
3935: BETWEEN pp.effective_start_date

Line 3939: DELETE per_people_f pp

3935: BETWEEN pp.effective_start_date
3936: AND pp.effective_end_date;
3937: --
3938: hr_utility.set_location(l_proc,60);
3939: DELETE per_people_f pp
3940: WHERE pp.person_id = p_person_id
3941: AND pp.effective_start_date > p_actual_termination_date;
3942: --
3943: hr_utility.set_location(l_proc,65);