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_ALL_PEOPLE_F

Line 846: ,p_parent_table => 'PER_ALL_PEOPLE_F'

842: ,p_date_to => null
843: ,p_phone_type => 'W1'
844: ,p_phone_number => p_work_telephone
845: ,p_parent_id => l_person_id
846: ,p_parent_table => 'PER_ALL_PEOPLE_F'
847: ,p_validate => FALSE
848: ,p_effective_date => l_start_date
849: ,p_object_version_number => l_phn_object_version_number --out
850: ,p_phone_id => l_phone_id --out

Line 1012: FROM per_all_people_f

1008: --
1009: begin
1010: SELECT object_version_number
1011: INTO p_per_object_Version_number
1012: FROM per_all_people_f
1013: WHERE person_id = l_person_id
1014: And effective_start_Date = l_per_effective_start_date
1015: and effective_end_Date = l_per_effective_end_date;
1016: exception

Line 1128: l_full_name per_all_people_f.full_name%TYPE;

1124: l_comment_id number;
1125: l_current_applicant_flag varchar2(1);
1126: l_current_emp_or_apl_flag varchar2(1);
1127: l_current_employee_flag varchar2(1);
1128: l_full_name per_all_people_f.full_name%TYPE;
1129: l_name_combination_warning boolean;
1130: l_dob_null_warning boolean;
1131: l_orig_hire_warning boolean;
1132: l_pdp_object_version_number number;

Line 1149: FROM per_all_people_f ppf

1145: ,ppt.system_person_type
1146: ,ppf.npw_number
1147: ,ppf.applicant_number
1148: ,ppf.employee_number
1149: FROM per_all_people_f ppf
1150: ,per_person_types ppt
1151: WHERE ppt.person_type_id = ppf.person_type_id
1152: AND ppf.person_id = p_person_id
1153: AND p_effective_date between ppf.effective_start_date and ppf.effective_end_date;

Line 1412: hr_utility.set_location('Updating future per_all_people_f rows',105);

1408: -- ER FPT
1409:
1410: for ptu_rec in fpt_ptu_details loop
1411:
1412: hr_utility.set_location('Updating future per_all_people_f rows',105);
1413:
1414: select object_version_number,effective_start_date,applicant_number
1415: into l_ovn,l_effective_start_date,l_applicant_number
1416: from per_all_people_f

Line 1416: from per_all_people_f

1412: hr_utility.set_location('Updating future per_all_people_f rows',105);
1413:
1414: select object_version_number,effective_start_date,applicant_number
1415: into l_ovn,l_effective_start_date,l_applicant_number
1416: from per_all_people_f
1417: where person_id = p_person_id
1418: and ptu_rec.effective_start_date between effective_start_date and effective_end_date;
1419:
1420:

Line 1576: l_full_name per_all_people_f.full_name%TYPE;

1572: l_comment_id number;
1573: l_current_applicant_flag varchar2(1);
1574: l_current_emp_or_apl_flag varchar2(1);
1575: l_current_employee_flag varchar2(1);
1576: l_full_name per_all_people_f.full_name%TYPE;
1577: l_name_combination_warning boolean;
1578: l_dob_null_warning boolean;
1579: l_orig_hire_warning boolean;
1580: l_per_effective_start_date date;

Line 1602: FROM per_all_people_f ppf

1598: ,ppt.system_person_type
1599: ,ppf.npw_number
1600: ,ppf.applicant_number
1601: ,ppf.employee_number
1602: FROM per_all_people_f ppf
1603: ,per_person_types ppt
1604: WHERE ppt.person_type_id = ppf.person_type_id
1605: AND ppf.person_id = p_person_id
1606: AND p_effective_date between ppf.effective_start_date and ppf.effective_end_date;

Line 2089: l_full_name per_all_people_f.full_name%TYPE;

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;
2092: l_name_combination_warning boolean;
2093: l_orig_hire_warning boolean;

Line 2113: l_applicant_number per_all_people_f.applicant_number%TYPE;

2109: l_current_dod date;
2110: l_date_of_death date;
2111: l_ptu_object_version_number number;
2112: l_person_type_usage_id number;
2113: l_applicant_number per_all_people_f.applicant_number%TYPE;
2114: l_employee_number per_all_people_f.employee_number%TYPE := hr_api.g_varchar2;
2115: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
2116: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
2117: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;

Line 2114: l_employee_number per_all_people_f.employee_number%TYPE := hr_api.g_varchar2;

2110: l_date_of_death date;
2111: l_ptu_object_version_number number;
2112: l_person_type_usage_id number;
2113: l_applicant_number per_all_people_f.applicant_number%TYPE;
2114: l_employee_number per_all_people_f.employee_number%TYPE := hr_api.g_varchar2;
2115: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
2116: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
2117: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
2118: --

Line 2115: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;

2111: l_ptu_object_version_number number;
2112: l_person_type_usage_id number;
2113: l_applicant_number per_all_people_f.applicant_number%TYPE;
2114: l_employee_number per_all_people_f.employee_number%TYPE := hr_api.g_varchar2;
2115: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
2116: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
2117: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
2118: --
2119:

Line 2116: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;

2112: l_person_type_usage_id number;
2113: l_applicant_number per_all_people_f.applicant_number%TYPE;
2114: l_employee_number per_all_people_f.employee_number%TYPE := hr_api.g_varchar2;
2115: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
2116: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
2117: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
2118: --
2119:
2120: cursor csr_future_per_changes is

Line 2117: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;

2113: l_applicant_number per_all_people_f.applicant_number%TYPE;
2114: l_employee_number per_all_people_f.employee_number%TYPE := hr_api.g_varchar2;
2115: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
2116: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
2117: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
2118: --
2119:
2120: cursor csr_future_per_changes is
2121: select null

Line 2122: from per_all_people_f per

2118: --
2119:
2120: cursor csr_future_per_changes is
2121: select null
2122: from per_all_people_f per
2123: where per.person_id = l_person_id
2124: and per.effective_start_date > l_actual_termination_date;
2125: --
2126: cursor csr_get_asgs_to_terminate is

Line 2144: from per_all_people_f per

2140: , per.effective_start_date
2141: , per.object_version_number
2142: , per.npw_number
2143: , per.applicant_number
2144: from per_all_people_f per
2145: , per_business_groups bus
2146: , per_periods_of_placement pdp
2147: where pdp.person_id = p_person_id
2148: and pdp.date_start = p_date_start

Line 2169: from per_all_people_f

2165: and tpe.end_date;
2166: --
2167: cursor csr_date_of_death is
2168: select date_of_death
2169: from per_all_people_f
2170: where person_id = l_person_id;
2171: -- ER FPT
2172: l_start_date date;
2173: cursor csr_fpt_ptu_changes is

Line 2182: from per_all_people_f

2178: and ptu.person_type_id = ppt.person_type_id
2179: and ppt.system_person_type in ('EMP','CWK');
2180: cursor csr_future_per_date is
2181: select min(effective_start_date)
2182: from per_all_people_f
2183: where person_id = p_person_id
2184: and effective_start_date > l_actual_termination_date;
2185: -- ER FPT
2186: --

Line 2438: per_all_people_f where person_id = p_person_id

2434: if l_start_date is not null then
2435: if l_start_date = l_actual_termination_date + 1 then
2436: l_datetrack_mode := 'CORRECTION';
2437: select applicant_number into l_applicant_number from
2438: per_all_people_f where person_id = p_person_id
2439: and effective_start_date = l_start_date;
2440: else
2441: l_datetrack_mode := 'UPDATE_CHANGE_INSERT';
2442: end if;

Line 2515: update per_all_people_f

2511: ,p_dob_null_warning => l_dob_null_warning
2512: ,p_orig_hire_warning => l_orig_hire_warning
2513: );
2514:
2515: update per_all_people_f
2516: set current_npw_flag = null
2517: where person_id = p_person_id
2518: and effective_start_date > l_actual_termination_date;
2519: --

Line 3741: from per_all_people_f per, per_person_types ppt

3737: -- ER FPT
3738: l_eff_start_date date;
3739: cursor get_min_eff_start_date is
3740: select min(effective_start_date)
3741: from per_all_people_f per, per_person_types ppt
3742: where per.person_id = p_person_id
3743: and effective_start_date > p_actual_termination_date
3744: and per.person_type_id = ppt.person_type_id
3745: and ppt.system_person_type in ('EX_APL','APL');

Line 3913: update per_all_people_f

3909: open get_min_eff_start_date;
3910: fetch get_min_eff_start_date into l_eff_start_date;
3911: if l_eff_start_date is not null then
3912:
3913: update per_all_people_f
3914: set effective_end_date = l_eff_start_date - 1
3915: where person_id = p_person_id
3916: and p_actual_termination_date between effective_start_date and effective_end_date;
3917:

Line 3918: delete from per_all_people_f

3914: set effective_end_date = l_eff_start_date - 1
3915: where person_id = p_person_id
3916: and p_actual_termination_date between effective_start_date and effective_end_date;
3917:
3918: delete from per_all_people_f
3919: where person_id = p_person_id
3920: and effective_start_date > p_actual_termination_date
3921: and effective_start_date < l_eff_start_date;
3922:

Line 3923: update per_all_people_f

3919: where person_id = p_person_id
3920: and effective_start_date > p_actual_termination_date
3921: and effective_start_date < l_eff_start_date;
3922:
3923: update per_all_people_f
3924: set current_npw_flag = 'Y'
3925: where person_id = p_person_id
3926: and effective_start_date > p_actual_termination_date;
3927: