DBA Data[Home] [Help]

APPS.GHR_SF52_DO_UPDATE dependencies on HR_PERSON_ADDRESS_API

Line 4719: hr_person_address_api.update_us_person_address

4715: hr_utility.set_location(l_proc,145);
4716: --- End dating all the secondary addresses for existing primary address
4717: for sec_address in c_sec_address loop
4718:
4719: hr_person_address_api.update_us_person_address
4720: (p_effective_date => g_effective_date
4721: ,p_date_to => g_effective_date
4722: ,p_address_id => sec_address.address_id
4723: ,p_object_version_number => sec_address.object_version_number

Line 4728: hr_person_address_api.update_us_person_address

4724: );
4725: end loop;
4726: hr_utility.set_location('l_address_id'||l_address_id,1000);
4727: -- End dating the existing primary address
4728: hr_person_address_api.update_us_person_address
4729: (p_effective_date => g_effective_date
4730: ,p_date_to => g_effective_date
4731: ,p_address_id => l_address_id
4732: ,p_object_version_number => l_add_object_version_number

Line 4736: hr_person_address_api.create_us_person_address

4732: ,p_object_version_number => l_add_object_version_number
4733: );
4734: End If; -- l_address_id is not null
4735: -- Creating new primary address for forwarding address
4736: hr_person_address_api.create_us_person_address
4737: (p_effective_date => g_effective_date
4738: ,p_person_id => p_pa_request_rec.person_id
4739: ,p_primary_flag => 'Y'
4740: ,p_date_from => g_effective_date + 1

Line 4754: hr_person_address_api.create_us_person_address

4750: ,p_object_version_number => l_per_add_ovr_number
4751: );
4752: --Creating new secondary addresses
4753: for sec_address in c_sec_address loop
4754: hr_person_address_api.create_us_person_address
4755: (p_effective_date => g_effective_date
4756: ,p_person_id => p_pa_request_rec.person_id
4757: ,p_primary_flag => 'N'
4758: ,p_date_from => g_effective_date + 1

Line 4778: hr_person_address_api.update_us_person_address

4774: --Update address -- In case of a correction, may be updating some entry in the address
4775:
4776: If l_update_address = 'Y' then
4777: hr_utility.set_location(l_proc,150);
4778: hr_person_address_api.update_us_person_address
4779: (p_address_id => l_address_id
4780: ,p_object_version_number => l_add_object_version_number
4781: ,p_effective_date => g_effective_date
4782: ,p_address_line1 => p_pa_request_rec.forwarding_address_line1

Line 4806: hr_person_address_api.update_person_address

4802: If l_address_id is not null then
4803: hr_utility.set_location(l_proc,145);
4804: --- End dating all the secondary addresses for existing primary address
4805: for sec_address in c_sec_address loop
4806: hr_person_address_api.update_person_address
4807: (p_effective_date => g_effective_date
4808: ,p_date_to => g_effective_date
4809: ,p_address_id => sec_address.address_id
4810: ,p_object_version_number => sec_address.object_version_number

Line 4814: hr_person_address_api.update_person_address

4810: ,p_object_version_number => sec_address.object_version_number
4811: );
4812: end loop;
4813: -- End dating the existing primary address
4814: hr_person_address_api.update_person_address
4815: (p_effective_date => g_effective_date
4816: ,p_date_to => g_effective_date
4817: ,p_address_id => l_address_id
4818: ,p_object_version_number => l_add_object_version_number

Line 4822: hr_person_address_api.create_person_address

4818: ,p_object_version_number => l_add_object_version_number
4819: );
4820: End If;
4821: -- Creating new primary address for forwarding address
4822: hr_person_address_api.create_person_address
4823: (p_effective_date => g_effective_date
4824: ,p_person_id => p_pa_request_rec.person_id
4825: ,p_primary_flag => 'Y'
4826: ,p_style => 'US_GLB_FED' -- Bug# 4725292

Line 4841: hr_person_address_api.create_person_address

4837: ,p_object_version_number => l_per_add_ovr_number
4838: );
4839: --Creating new secondary addresses
4840: for sec_address in c_sec_address loop
4841: hr_person_address_api.create_person_address
4842: (p_effective_date => g_effective_date
4843: ,p_person_id => p_pa_request_rec.person_id
4844: ,p_primary_flag => 'N'
4845: ,p_style => 'US_GLB_FED' -- Bug# 4725292

Line 4866: hr_person_address_api.update_person_address

4862: --Update address -- In case of a correction, may be updating some entry in the address
4863:
4864: If l_update_address = 'Y' then
4865: hr_utility.set_location(l_proc,150);
4866: hr_person_address_api.update_person_address
4867: (p_address_id => l_address_id
4868: ,p_object_version_number => l_add_object_version_number
4869: ,p_effective_date => g_effective_date
4870: ,p_address_line1 => p_pa_request_rec.forwarding_address_line1