DBA Data[Home] [Help]

APPS.GHR_SF52_DO_UPDATE dependencies on HR_PERSON_ADDRESS_API

Line 4460: hr_person_address_api.update_us_person_address

4456: hr_utility.set_location(l_proc,145);
4457: --- End dating all the secondary addresses for existing primary address
4458: for sec_address in c_sec_address loop
4459:
4460: hr_person_address_api.update_us_person_address
4461: (p_effective_date => g_effective_date
4462: ,p_date_to => g_effective_date
4463: ,p_address_id => sec_address.address_id
4464: ,p_object_version_number => sec_address.object_version_number

Line 4469: hr_person_address_api.update_us_person_address

4465: );
4466: end loop;
4467: hr_utility.set_location('l_address_id'||l_address_id,1000);
4468: -- End dating the existing primary address
4469: hr_person_address_api.update_us_person_address
4470: (p_effective_date => g_effective_date
4471: ,p_date_to => g_effective_date
4472: ,p_address_id => l_address_id
4473: ,p_object_version_number => l_add_object_version_number

Line 4477: hr_person_address_api.create_us_person_address

4473: ,p_object_version_number => l_add_object_version_number
4474: );
4475: End If; -- l_address_id is not null
4476: -- Creating new primary address for forwarding address
4477: hr_person_address_api.create_us_person_address
4478: (p_effective_date => g_effective_date
4479: ,p_person_id => p_pa_request_rec.person_id
4480: ,p_primary_flag => 'Y'
4481: ,p_date_from => g_effective_date + 1

Line 4495: hr_person_address_api.create_us_person_address

4491: ,p_object_version_number => l_per_add_ovr_number
4492: );
4493: --Creating new secondary addresses
4494: for sec_address in c_sec_address loop
4495: hr_person_address_api.create_us_person_address
4496: (p_effective_date => g_effective_date
4497: ,p_person_id => p_pa_request_rec.person_id
4498: ,p_primary_flag => 'N'
4499: ,p_date_from => g_effective_date + 1

Line 4519: hr_person_address_api.update_us_person_address

4515: --Update address -- In case of a correction, may be updating some entry in the address
4516:
4517: If l_update_address = 'Y' then
4518: hr_utility.set_location(l_proc,150);
4519: hr_person_address_api.update_us_person_address
4520: (p_address_id => l_address_id
4521: ,p_object_version_number => l_add_object_version_number
4522: ,p_effective_date => g_effective_date
4523: ,p_address_line1 => p_pa_request_rec.forwarding_address_line1

Line 4547: hr_person_address_api.update_person_address

4543: If l_address_id is not null then
4544: hr_utility.set_location(l_proc,145);
4545: --- End dating all the secondary addresses for existing primary address
4546: for sec_address in c_sec_address loop
4547: hr_person_address_api.update_person_address
4548: (p_effective_date => g_effective_date
4549: ,p_date_to => g_effective_date
4550: ,p_address_id => sec_address.address_id
4551: ,p_object_version_number => sec_address.object_version_number

Line 4555: hr_person_address_api.update_person_address

4551: ,p_object_version_number => sec_address.object_version_number
4552: );
4553: end loop;
4554: -- End dating the existing primary address
4555: hr_person_address_api.update_person_address
4556: (p_effective_date => g_effective_date
4557: ,p_date_to => g_effective_date
4558: ,p_address_id => l_address_id
4559: ,p_object_version_number => l_add_object_version_number

Line 4563: hr_person_address_api.create_person_address

4559: ,p_object_version_number => l_add_object_version_number
4560: );
4561: End If;
4562: -- Creating new primary address for forwarding address
4563: hr_person_address_api.create_person_address
4564: (p_effective_date => g_effective_date
4565: ,p_person_id => p_pa_request_rec.person_id
4566: ,p_primary_flag => 'Y'
4567: ,p_style => 'US_GLB_FED' -- Bug# 4725292

Line 4582: hr_person_address_api.create_person_address

4578: ,p_object_version_number => l_per_add_ovr_number
4579: );
4580: --Creating new secondary addresses
4581: for sec_address in c_sec_address loop
4582: hr_person_address_api.create_person_address
4583: (p_effective_date => g_effective_date
4584: ,p_person_id => p_pa_request_rec.person_id
4585: ,p_primary_flag => 'N'
4586: ,p_style => 'US_GLB_FED' -- Bug# 4725292

Line 4607: hr_person_address_api.update_person_address

4603: --Update address -- In case of a correction, may be updating some entry in the address
4604:
4605: If l_update_address = 'Y' then
4606: hr_utility.set_location(l_proc,150);
4607: hr_person_address_api.update_person_address
4608: (p_address_id => l_address_id
4609: ,p_object_version_number => l_add_object_version_number
4610: ,p_effective_date => g_effective_date
4611: ,p_address_line1 => p_pa_request_rec.forwarding_address_line1