DBA Data[Home] [Help]

APPS.HR_APPLICANT_API dependencies on PER_PER_SHD

Line 2765: per_per_shd.lck

2761: -- Lock the person record in PER_ALL_PEOPLE_F ready for UPDATE at a later point.
2762: -- (Note: This is necessary because calling the table handlers in locking
2763: -- ladder order invokes an error in per_apl_upd.upd due to the person
2764: -- being modified by the per_per_upd.upd table handler.)
2765: per_per_shd.lck
2766: (p_effective_date => l_hire_date
2767: --bug no 5105005
2768: ,p_datetrack_mode => l_datetrack_mode
2769: --bug no 5105005

Line 2781: for add_rec in csr_add(per_per_shd.g_old_rec.party_id) loop

2777: --
2778: --start changes for i-rec enhancement ww bug # 2675202
2779: --
2780: if (p_migrate) then
2781: for add_rec in csr_add(per_per_shd.g_old_rec.party_id) loop
2782: l_add_ovn:=add_rec.object_version_number;
2783: per_add_upd.upd(p_address_id => add_rec.address_id
2784: ,p_person_id => per_per_shd.g_old_rec.person_id
2785: ,p_business_group_id => l_business_group_id

Line 2784: ,p_person_id => per_per_shd.g_old_rec.person_id

2780: if (p_migrate) then
2781: for add_rec in csr_add(per_per_shd.g_old_rec.party_id) loop
2782: l_add_ovn:=add_rec.object_version_number;
2783: per_add_upd.upd(p_address_id => add_rec.address_id
2784: ,p_person_id => per_per_shd.g_old_rec.person_id
2785: ,p_business_group_id => l_business_group_id
2786: ,p_object_version_number => l_add_ovn
2787: ,p_effective_date => l_hire_date);
2788: end loop;

Line 2792: for phn_rec in csr_phn(per_per_shd.g_old_rec.party_id) loop

2788: end loop;
2789: --
2790: hr_utility.set_location(l_proc,181);
2791: --
2792: for phn_rec in csr_phn(per_per_shd.g_old_rec.party_id) loop
2793: l_phn_ovn:=phn_rec.object_version_number;
2794: l_parent_table := 'PER_ALL_PEOPLE_F';
2795: per_phn_upd.upd(p_phone_id => phn_rec.phone_id
2796: ,p_parent_id => per_per_shd.g_old_rec.person_id

Line 2796: ,p_parent_id => per_per_shd.g_old_rec.person_id

2792: for phn_rec in csr_phn(per_per_shd.g_old_rec.party_id) loop
2793: l_phn_ovn:=phn_rec.object_version_number;
2794: l_parent_table := 'PER_ALL_PEOPLE_F';
2795: per_phn_upd.upd(p_phone_id => phn_rec.phone_id
2796: ,p_parent_id => per_per_shd.g_old_rec.person_id
2797: ,p_parent_table => l_parent_table
2798: ,p_object_version_number => l_phn_ovn
2799: ,p_effective_date => l_hire_date);
2800: end loop;

Line 2804: for pem_rec in csr_pem(per_per_shd.g_old_rec.party_id) loop

2800: end loop;
2801: --
2802: hr_utility.set_location(l_proc,182);
2803: --
2804: for pem_rec in csr_pem(per_per_shd.g_old_rec.party_id) loop
2805: l_pem_ovn:=pem_rec.object_version_number;
2806: per_pem_upd.upd(p_previous_employer_id => pem_rec.previous_employer_id
2807: ,p_person_id => per_per_shd.g_old_rec.person_id
2808: ,p_business_group_id => l_business_group_id

Line 2807: ,p_person_id => per_per_shd.g_old_rec.person_id

2803: --
2804: for pem_rec in csr_pem(per_per_shd.g_old_rec.party_id) loop
2805: l_pem_ovn:=pem_rec.object_version_number;
2806: per_pem_upd.upd(p_previous_employer_id => pem_rec.previous_employer_id
2807: ,p_person_id => per_per_shd.g_old_rec.person_id
2808: ,p_business_group_id => l_business_group_id
2809: ,p_object_version_number => l_pem_ovn
2810: ,p_effective_date => l_hire_date);
2811: end loop;

Line 2815: for qua_rec in csr_qua(per_per_shd.g_old_rec.party_id) loop

2811: end loop;
2812: --
2813: hr_utility.set_location(l_proc,183);
2814: --
2815: for qua_rec in csr_qua(per_per_shd.g_old_rec.party_id) loop
2816: l_qua_ovn:=qua_rec.object_version_number;
2817: per_qua_upd.upd(p_qualification_id => qua_rec.qualification_id
2818: ,p_person_id => per_per_shd.g_old_rec.person_id
2819: ,p_business_group_id => l_business_group_id

Line 2818: ,p_person_id => per_per_shd.g_old_rec.person_id

2814: --
2815: for qua_rec in csr_qua(per_per_shd.g_old_rec.party_id) loop
2816: l_qua_ovn:=qua_rec.object_version_number;
2817: per_qua_upd.upd(p_qualification_id => qua_rec.qualification_id
2818: ,p_person_id => per_per_shd.g_old_rec.person_id
2819: ,p_business_group_id => l_business_group_id
2820: ,p_object_version_number => l_qua_ovn
2821: ,p_effective_date => l_hire_date);
2822: end loop;

Line 2826: for esa_rec in csr_esa(per_per_shd.g_old_rec.party_id) loop

2822: end loop;
2823: --
2824: hr_utility.set_location(l_proc,184);
2825: --
2826: for esa_rec in csr_esa(per_per_shd.g_old_rec.party_id) loop
2827: l_esa_ovn:=esa_rec.object_version_number;
2828: per_esa_upd.upd(p_attendance_id => esa_rec.attendance_id
2829: ,p_person_id => per_per_shd.g_old_rec.person_id
2830: ,p_business_group_id => l_business_group_id

Line 2829: ,p_person_id => per_per_shd.g_old_rec.person_id

2825: --
2826: for esa_rec in csr_esa(per_per_shd.g_old_rec.party_id) loop
2827: l_esa_ovn:=esa_rec.object_version_number;
2828: per_esa_upd.upd(p_attendance_id => esa_rec.attendance_id
2829: ,p_person_id => per_per_shd.g_old_rec.person_id
2830: ,p_business_group_id => l_business_group_id
2831: ,p_object_version_number => l_esa_ovn
2832: ,p_effective_date => l_hire_date);
2833: end loop;

Line 4460: per_per_shd.lck

4456: --
4457: open csr_lock_ptu(p_person_id, l_effective_date);
4458: close csr_lock_ptu;
4459: /*
4460: per_per_shd.lck
4461: (p_effective_date => l_effective_date + 1
4462: ,p_datetrack_mode => hr_api.g_update
4463: ,p_person_id => p_person_id
4464: ,p_object_version_number => p_object_version_number