DBA Data[Home] [Help]

APPS.HR_APPLICANT_API dependencies on PER_PER_SHD

Line 2197: per_per_shd.lck

2193: -- Lock the person record in PER_ALL_PEOPLE_F ready for UPDATE at a later point.
2194: -- (Note: This is necessary because calling the table handlers in locking
2195: -- ladder order invokes an error in per_apl_upd.upd due to the person
2196: -- being modified by the per_per_upd.upd table handler.)
2197: per_per_shd.lck
2198: (p_effective_date => l_hire_date
2199: --bug no 5105005
2200: ,p_datetrack_mode => l_datetrack_mode
2201: --bug no 5105005

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

2209: --
2210: --start changes for i-rec enhancement ww bug # 2675202
2211: --
2212: if (p_migrate) then
2213: for add_rec in csr_add(per_per_shd.g_old_rec.party_id) loop
2214: l_add_ovn:=add_rec.object_version_number;
2215: per_add_upd.upd(p_address_id => add_rec.address_id
2216: ,p_person_id => per_per_shd.g_old_rec.person_id
2217: ,p_business_group_id => l_business_group_id

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

2212: if (p_migrate) then
2213: for add_rec in csr_add(per_per_shd.g_old_rec.party_id) loop
2214: l_add_ovn:=add_rec.object_version_number;
2215: per_add_upd.upd(p_address_id => add_rec.address_id
2216: ,p_person_id => per_per_shd.g_old_rec.person_id
2217: ,p_business_group_id => l_business_group_id
2218: ,p_object_version_number => l_add_ovn
2219: ,p_effective_date => l_hire_date);
2220: end loop;

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

2220: end loop;
2221: --
2222: hr_utility.set_location(l_proc,181);
2223: --
2224: for phn_rec in csr_phn(per_per_shd.g_old_rec.party_id) loop
2225: l_phn_ovn:=phn_rec.object_version_number;
2226: l_parent_table := 'PER_ALL_PEOPLE_F';
2227: per_phn_upd.upd(p_phone_id => phn_rec.phone_id
2228: ,p_parent_id => per_per_shd.g_old_rec.person_id

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

2224: for phn_rec in csr_phn(per_per_shd.g_old_rec.party_id) loop
2225: l_phn_ovn:=phn_rec.object_version_number;
2226: l_parent_table := 'PER_ALL_PEOPLE_F';
2227: per_phn_upd.upd(p_phone_id => phn_rec.phone_id
2228: ,p_parent_id => per_per_shd.g_old_rec.person_id
2229: ,p_parent_table => l_parent_table
2230: ,p_object_version_number => l_phn_ovn
2231: ,p_effective_date => l_hire_date);
2232: end loop;

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

2232: end loop;
2233: --
2234: hr_utility.set_location(l_proc,182);
2235: --
2236: for pem_rec in csr_pem(per_per_shd.g_old_rec.party_id) loop
2237: l_pem_ovn:=pem_rec.object_version_number;
2238: per_pem_upd.upd(p_previous_employer_id => pem_rec.previous_employer_id
2239: ,p_person_id => per_per_shd.g_old_rec.person_id
2240: ,p_business_group_id => l_business_group_id

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

2235: --
2236: for pem_rec in csr_pem(per_per_shd.g_old_rec.party_id) loop
2237: l_pem_ovn:=pem_rec.object_version_number;
2238: per_pem_upd.upd(p_previous_employer_id => pem_rec.previous_employer_id
2239: ,p_person_id => per_per_shd.g_old_rec.person_id
2240: ,p_business_group_id => l_business_group_id
2241: ,p_object_version_number => l_pem_ovn
2242: ,p_effective_date => l_hire_date);
2243: end loop;

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

2243: end loop;
2244: --
2245: hr_utility.set_location(l_proc,183);
2246: --
2247: for qua_rec in csr_qua(per_per_shd.g_old_rec.party_id) loop
2248: l_qua_ovn:=qua_rec.object_version_number;
2249: per_qua_upd.upd(p_qualification_id => qua_rec.qualification_id
2250: ,p_person_id => per_per_shd.g_old_rec.person_id
2251: ,p_business_group_id => l_business_group_id

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

2246: --
2247: for qua_rec in csr_qua(per_per_shd.g_old_rec.party_id) loop
2248: l_qua_ovn:=qua_rec.object_version_number;
2249: per_qua_upd.upd(p_qualification_id => qua_rec.qualification_id
2250: ,p_person_id => per_per_shd.g_old_rec.person_id
2251: ,p_business_group_id => l_business_group_id
2252: ,p_object_version_number => l_qua_ovn
2253: ,p_effective_date => l_hire_date);
2254: end loop;

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

2254: end loop;
2255: --
2256: hr_utility.set_location(l_proc,184);
2257: --
2258: for esa_rec in csr_esa(per_per_shd.g_old_rec.party_id) loop
2259: l_esa_ovn:=esa_rec.object_version_number;
2260: per_esa_upd.upd(p_attendance_id => esa_rec.attendance_id
2261: ,p_person_id => per_per_shd.g_old_rec.person_id
2262: ,p_business_group_id => l_business_group_id

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

2257: --
2258: for esa_rec in csr_esa(per_per_shd.g_old_rec.party_id) loop
2259: l_esa_ovn:=esa_rec.object_version_number;
2260: per_esa_upd.upd(p_attendance_id => esa_rec.attendance_id
2261: ,p_person_id => per_per_shd.g_old_rec.person_id
2262: ,p_business_group_id => l_business_group_id
2263: ,p_object_version_number => l_esa_ovn
2264: ,p_effective_date => l_hire_date);
2265: end loop;

Line 3391: per_per_shd.lck

3387: --
3388: open csr_lock_ptu(p_person_id, l_effective_date);
3389: close csr_lock_ptu;
3390: /*
3391: per_per_shd.lck
3392: (p_effective_date => l_effective_date + 1
3393: ,p_datetrack_mode => hr_api.g_update
3394: ,p_person_id => p_person_id
3395: ,p_object_version_number => p_object_version_number