[Home] [Help]
1274: else
1275: close csr_future_per_changes;
1276: end if;
1277: --
1278: per_per_upd.upd
1279: (p_person_id => p_person_id
1280: ,p_effective_start_date => l_per_effective_start_date
1281: ,p_effective_end_date => l_per_effective_end_date
1282: ,p_person_type_id => l_person_type_id1
2292: --
2293: -- Lock the person record in PER_ALL_PEOPLE_F ready for UPDATE at a later point.
2294: -- (Note: This is necessary because calling the table handlers in locking
2295: -- ladder order invokes an error in per_apl_upd.upd due to the person
2296: -- being modified by the per_per_upd.upd table handler.)
2297: if l_per_effective_start_date=l_hire_date then
2298: l_datetrack_update_mode:='CORRECTION';
2299: else
2300: l_datetrack_update_mode:='UPDATE';
2389: -- the per_all_people_f table.
2390: --
2391: l_applicant_number:=hr_api.g_varchar2;
2392: l_employee_number:=hr_api.g_varchar2;
2393: per_per_upd.upd
2394: (p_person_id => p_person_id
2395: ,p_effective_date => l_hire_date
2396: ,p_applicant_number => l_applicant_number
2397: ,p_employee_number => l_employee_number
3792: and apl.date_received between effective_start_date and effective_end_date;
3793:
3794: -- creating EMP_APL records in PER table
3795:
3796: per_per_upd.upd
3797: (p_person_id => p_person_id
3798: ,p_effective_date => apl.date_received
3799: ,p_applicant_number => l_applicant_number
3800: ,p_employee_number => l_employee_number
3843: (l_business_group_id,'EMP');
3844:
3845:
3846: -- creating EMP records in PER table
3847: per_per_upd.upd
3848: (p_person_id => p_person_id
3849: ,p_effective_date => apl.date_end + 1
3850: ,p_applicant_number => l_applicant_number
3851: ,p_employee_number => l_employee_number
4822:
4823: -- Lock the person record in PER_ALL_PEOPLE_F ready for UPDATE at a later point.
4824: -- (Note: This is necessary because calling the table handlers in locking
4825: -- ladder order invokes an error in per_apl_upd.upd due to the person
4826: -- being modified by the per_per_upd.upd table handler.)
4827: if l_per_effective_start_date=l_hire_date then
4828: l_datetrack_update_mode:='CORRECTION';
4829: else
4830: l_datetrack_update_mode:='UPDATE';
4967: -- If there are no aaplication other than the one into which we are hiring
4968: -- then need to change the person_type. Added the below IF.
4969: if not l_appl_present then
4970:
4971: per_per_upd.upd
4972: (p_person_id => p_person_id
4973: ,p_effective_date => l_hire_date
4974: ,p_applicant_number => l_applicant_number
4975: ,p_employee_number => l_employee_number
6637: and apl.date_received between effective_start_date and effective_end_date;
6638:
6639: -- creating EMP_APL records in PER table
6640:
6641: per_per_upd.upd
6642: (p_person_id => p_person_id
6643: ,p_effective_date => apl.date_received
6644: ,p_applicant_number => l_applicant_number
6645: ,p_employee_number => l_employee_number
6687: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id
6688: (l_business_group_id,'EMP');
6689:
6690: -- creating EMP records in PER table
6691: per_per_upd.upd
6692: (p_person_id => p_person_id
6693: ,p_effective_date => apl.date_end + 1
6694: ,p_applicant_number => l_applicant_number
6695: ,p_employee_number => l_employee_number