The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT per.current_applicant_flag,
per.current_employee_flag,
per.current_npw_flag
FROM per_all_people_f per
WHERE per.person_id = p_person_id
AND p_eff_date BETWEEN per.effective_start_date and per.effective_end_date;
hr_new_user_reg_ss.process_selected_transaction(
p_item_type => p_item_type,
p_item_key => p_item_key,
p_api_name => 'HR_PROCESS_PERSON_SS.PROCESS_API');
hr_person_address_api.update_person_address
(p_validate => false
,p_effective_date => p_effective_date
,p_address_id => p_old_address_id
,p_object_version_number => l_old_ovn
,p_date_to => p_date_to);
p_message_name => 'HR_UPDATE_NOT_ALLOWED');
|| PROCEDURE: update_person_address
||---------------------------------------------------------------------------
||
|| Description:
|| This procedure will call the actual API -
|| hr_person_address_api.update_person_address()
||
|| Access Status:
|| Public.
||
||===========================================================================
*/
PROCEDURE update_person_address
(p_validate in number default 0
,p_effective_date in date
,p_validate_county in number default 1
,p_address_id in number
,p_object_version_number in out nocopy number
,p_date_from in date default hr_api.g_date
,p_date_to in date default hr_api.g_date
,p_address_type in varchar2 default hr_api.g_varchar2
,p_address_type_meaning in varchar2 default hr_api.g_varchar2
,p_comments in clob default hr_api.g_varchar2 --Bug#13362792
,p_address_line1 in varchar2 default hr_api.g_varchar2
,p_address_line2 in varchar2 default hr_api.g_varchar2
,p_address_line3 in varchar2 default hr_api.g_varchar2
,p_town_or_city in varchar2 default hr_api.g_varchar2
,p_region_1 in varchar2 default hr_api.g_varchar2
,p_region_2 in varchar2 default hr_api.g_varchar2
,p_region_3 in varchar2 default hr_api.g_varchar2
,p_postal_code in varchar2 default hr_api.g_varchar2
,p_country in varchar2 default hr_api.g_varchar2
,p_country_meaning in varchar2 default hr_api.g_varchar2
,p_telephone_number_1 in varchar2 default hr_api.g_varchar2
,p_telephone_number_2 in varchar2 default hr_api.g_varchar2
,p_telephone_number_3 in varchar2 default hr_api.g_varchar2
,p_addr_attribute_category in varchar2 default hr_api.g_varchar2
,p_addr_attribute1 in varchar2 default hr_api.g_varchar2
,p_addr_attribute2 in varchar2 default hr_api.g_varchar2
,p_addr_attribute3 in varchar2 default hr_api.g_varchar2
,p_addr_attribute4 in varchar2 default hr_api.g_varchar2
,p_addr_attribute5 in varchar2 default hr_api.g_varchar2
,p_addr_attribute6 in varchar2 default hr_api.g_varchar2
,p_addr_attribute7 in varchar2 default hr_api.g_varchar2
,p_addr_attribute8 in varchar2 default hr_api.g_varchar2
,p_addr_attribute9 in varchar2 default hr_api.g_varchar2
,p_addr_attribute10 in varchar2 default hr_api.g_varchar2
,p_addr_attribute11 in varchar2 default hr_api.g_varchar2
,p_addr_attribute12 in varchar2 default hr_api.g_varchar2
,p_addr_attribute13 in varchar2 default hr_api.g_varchar2
,p_addr_attribute14 in varchar2 default hr_api.g_varchar2
,p_addr_attribute15 in varchar2 default hr_api.g_varchar2
,p_addr_attribute16 in varchar2 default hr_api.g_varchar2
,p_addr_attribute17 in varchar2 default hr_api.g_varchar2
,p_addr_attribute18 in varchar2 default hr_api.g_varchar2
,p_addr_attribute19 in varchar2 default hr_api.g_varchar2
,p_addr_attribute20 in varchar2 default hr_api.g_varchar2
,p_add_information13 in varchar2 default hr_api.g_varchar2
,p_add_information14 in varchar2 default hr_api.g_varchar2
,p_add_information15 in varchar2 default hr_api.g_varchar2
,p_add_information16 in varchar2 default hr_api.g_varchar2
,p_add_information17 in varchar2 default hr_api.g_varchar2
,p_add_information18 in varchar2 default hr_api.g_varchar2
,p_add_information19 in varchar2 default hr_api.g_varchar2
,p_add_information20 in varchar2 default hr_api.g_varchar2
,p_item_type in varchar2
,p_item_key in varchar2
,p_activity_id in number
,p_person_id in number
--
-- PB Add :
-- The transaction steps have to be created by the login personid.
-- In case of adding phones for contacts parent_is is contact_person_id.
-- Login person id is say employee who is adding the phones to his contact.
--
--TEST
,p_contact_or_person in varchar2 default null
,p_login_person_id in number default null
,p_primary_flag in varchar2
,p_style in varchar2
,p_action in varchar2
,p_save_mode in varchar2 default null
,p_error_message out nocopy long
, p_contact_relationship_id in number default hr_api.g_number
)
IS
l_proc varchar2(200) := g_package || 'update_person_address';
IF (UPPER(p_action) = 'DELETE') THEN
hr_utility.set_location( l_proc,20);
hr_person_address_api.update_person_address
(p_validate => hr_java_conv_util_ss.get_boolean (
p_number => p_validate
)
,p_effective_date => p_effective_date
,p_validate_county => hr_java_conv_util_ss.get_boolean (
p_number => p_validate_county
)
,p_address_id => p_address_id
,p_object_version_number => p_object_version_number
,p_date_from => p_date_from
,p_date_to => p_date_to
);
hr_person_address_api.update_pers_addr_with_style --Bug#3114508 end
(p_validate => hr_java_conv_util_ss.get_boolean (
p_number => p_validate
)
,p_effective_date => p_effective_date
,p_validate_county => hr_java_conv_util_ss.get_boolean (
p_number => p_validate_county
)
,p_address_id => p_address_id
,p_object_version_number => p_object_version_number
,p_date_from => p_date_from
,p_date_to => p_date_to
,p_address_type => p_address_type
,p_comments => p_comments
,p_address_line1 => p_address_line1
,p_address_line2 => p_address_line2
,p_address_line3 => p_address_line3
,p_town_or_city => p_town_or_city
,p_region_1 => p_region_1
,p_region_2 => p_region_2
,p_region_3 => p_region_3
,p_postal_code => p_postal_code
,p_country => p_country --Bug#3114508 start
,p_style => p_style --Bug#3114508 end
,p_telephone_number_1 => p_telephone_number_1
,p_telephone_number_2 => p_telephone_number_2
,p_telephone_number_3 => p_telephone_number_3
,p_addr_attribute_category => p_addr_attribute_category
,p_addr_attribute1 => p_addr_attribute1
,p_addr_attribute2 => p_addr_attribute2
,p_addr_attribute3 => p_addr_attribute3
,p_addr_attribute4 => p_addr_attribute4
,p_addr_attribute5 => p_addr_attribute5
,p_addr_attribute6 => p_addr_attribute6
,p_addr_attribute7 => p_addr_attribute7
,p_addr_attribute8 => p_addr_attribute8
,p_addr_attribute9 => p_addr_attribute9
,p_addr_attribute10 => p_addr_attribute10
,p_addr_attribute11 => p_addr_attribute11
,p_addr_attribute12 => p_addr_attribute12
,p_addr_attribute13 => p_addr_attribute13
,p_addr_attribute14 => p_addr_attribute14
,p_addr_attribute15 => p_addr_attribute15
,p_addr_attribute16 => p_addr_attribute16
,p_addr_attribute17 => p_addr_attribute17
,p_addr_attribute18 => p_addr_attribute18
,p_addr_attribute19 => p_addr_attribute19
,p_addr_attribute20 => p_addr_attribute20
,p_add_information13 => p_add_information13
,p_add_information14 => p_add_information14
,p_add_information15 => p_add_information15
,p_add_information16 => p_add_information16
,p_add_information17 => p_add_information17
,p_add_information18 => p_add_information18
,p_add_information19 => p_add_information19
,p_add_information20 => p_add_information20
);
p_message_name => 'HR_UPDATE_NOT_ALLOWED');
END update_person_address;
select 'NOT_SFL'
into l_check_for_sfl
from per_all_people_f
where person_id =l_address.person_id;
select nvl(hats1.transaction_step_id,0)
into l_sfl_g_contact_step_id
from hr_api_transaction_steps hats1
where hats1.item_type = 'HRSSA'
and hats1.item_key =
(select hats2.item_key
from hr_api_transaction_steps hats2
where hats2.item_type = 'HRSSA'
and hats2.transaction_step_id = p_transaction_step_id )
and hats1.api_name = 'HR_PROCESS_CONTACT_SS.PROCESS_CREATE_CONTACT_API';
hr_person_address_api.update_person_address
(p_validate => false
,p_effective_date => l_effective_date
,p_address_id => l_old_address_id
,p_object_version_number => l_old_ovn
,p_date_to => l_Address.date_to);
if (hr_process_contact_ss.g_is_address_updated = true) then
l_address.object_version_number := l_address.object_version_number + 1;
hr_person_address_api.update_pers_addr_with_style --Bug#3114508 end
(p_validate => false
,p_effective_date => trunc(sysdate)
,p_address_type => l_address.address_type
,p_address_line1 => l_address.address_line1
,p_address_line2 => l_address.address_line2
,p_address_line3 => l_address.address_line3
,p_town_or_city => l_address.town_or_city
,p_region_1 => l_address.region_1
,p_region_2 => l_address.region_2
,p_region_3 => l_address.region_3
,p_postal_code => l_Address.postal_code
,p_country => l_address.country --Bug#3114508 start
,p_style => l_Address.style --Bug#3114508 end
,p_address_id => l_Address.address_id
,p_object_version_number =>
l_address.object_version_number
,p_telephone_number_1 => l_address.telephone_number_1
,p_telephone_number_2 => l_address.telephone_number_2
,p_telephone_number_3 => l_address.telephone_number_3
,p_addr_attribute_category => l_address.addr_attribute_category
,p_addr_attribute1 => l_address.addr_attribute1
,p_addr_attribute2 => l_address.addr_attribute2
,p_addr_attribute3 => l_address.addr_attribute3
,p_addr_attribute4 => l_address.addr_attribute4
,p_addr_attribute5 => l_address.addr_attribute5
,p_addr_attribute6 => l_address.addr_attribute6
,p_addr_attribute7 => l_address.addr_attribute7
,p_addr_attribute8 => l_address.addr_attribute8
,p_addr_attribute9 => l_address.addr_attribute9
,p_addr_attribute10 => l_address.addr_attribute10
,p_addr_attribute11 => l_address.addr_attribute11
,p_addr_attribute12 => l_address.addr_attribute12
,p_addr_attribute13 => l_address.addr_attribute13
,p_addr_attribute14 => l_address.addr_attribute14
,p_addr_attribute15 => l_address.addr_attribute15
,p_addr_attribute16 => l_address.addr_attribute16
,p_addr_attribute17 => l_address.addr_attribute17
,p_addr_attribute18 => l_address.addr_attribute18
,p_addr_attribute19 => l_address.addr_attribute19
,p_addr_attribute20 => l_address.addr_attribute20
,p_add_information13 => l_address.add_information13
,p_add_information14 => l_address.add_information14
,p_add_information15 => l_address.add_information15
,p_add_information16 => l_address.add_information16
,p_add_information17 => l_address.add_information17
,p_add_information18 => l_address.add_information18
,p_add_information19 => l_address.add_information19
,p_add_information20 => l_address.add_information20);
hr_process_contact_ss.g_is_address_updated := false;
ELSIF UPPER(l_action) = 'DELETE' THEN
hr_utility.set_location( l_proc, 70);
hr_person_address_api.update_person_address
(p_validate => false
,p_address_id => l_address.address_id
,p_object_version_number => l_address.object_version_number
,p_effective_date => l_effective_date
,p_date_from => l_address.date_from
,p_date_to => l_address.date_to);