The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_location
(p_validate in number default hr_api.g_false_num
,p_location_id in number
,p_configuration_code in varchar2
,p_configuration_context in varchar2
,p_location_code in varchar2
,p_description in varchar2 default hr_api.g_varchar2
,p_style in varchar2 default hr_api.g_varchar2
,p_address_line_1 in varchar2 default hr_api.g_varchar2
,p_address_line_2 in varchar2 default hr_api.g_varchar2
,p_address_line_3 in varchar2 default hr_api.g_varchar2
,p_town_or_city in varchar2 default hr_api.g_varchar2
,p_country in varchar2 default hr_api.g_varchar2
,p_postal_code 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_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_loc_information13 in varchar2 default hr_api.g_varchar2
,p_loc_information14 in varchar2 default hr_api.g_varchar2
,p_loc_information15 in varchar2 default hr_api.g_varchar2
,p_loc_information16 in varchar2 default hr_api.g_varchar2
,p_loc_information17 in varchar2 default hr_api.g_varchar2
,p_loc_information18 in varchar2 default hr_api.g_varchar2
,p_loc_information19 in varchar2 default hr_api.g_varchar2
,p_loc_information20 in varchar2 default hr_api.g_varchar2
,p_language_code in varchar2 default hr_api.g_varchar2
,p_effective_date in date
,p_object_version_number in out nocopy number
,p_return_status out nocopy varchar2
) is
--
-- Variables for API Boolean parameters
l_validate boolean;
l_proc varchar2(72) := g_package ||'update_location';
savepoint update_location_swi;
per_ri_config_location_api.update_location
(p_validate => l_validate
,p_location_id => p_location_id
,p_configuration_code => p_configuration_code
,p_configuration_context => p_configuration_context
,p_location_code => p_location_code
,p_description => p_description
,p_style => p_style
,p_address_line_1 => p_address_line_1
,p_address_line_2 => p_address_line_2
,p_address_line_3 => p_address_line_3
,p_town_or_city => p_town_or_city
,p_country => p_country
,p_postal_code => p_postal_code
,p_region_1 => p_region_1
,p_region_2 => p_region_2
,p_region_3 => p_region_3
,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_loc_information13 => p_loc_information13
,p_loc_information14 => p_loc_information14
,p_loc_information15 => p_loc_information15
,p_loc_information16 => p_loc_information16
,p_loc_information17 => p_loc_information17
,p_loc_information18 => p_loc_information18
,p_loc_information19 => p_loc_information19
,p_loc_information20 => p_loc_information20
,p_language_code => p_language_code
,p_effective_date => p_effective_date
,p_object_version_number => p_object_version_number
);
rollback to update_location_swi;
rollback to update_location_swi;
end update_location;
PROCEDURE delete_location
(p_validate in number default hr_api.g_false_num
,p_location_id in number
,p_object_version_number in number
,p_return_status out nocopy varchar2
) is
--
-- Variables for API Boolean parameters
l_validate boolean;
l_proc varchar2(72) := g_package ||'delete_location';
savepoint delete_location_swi;
per_ri_config_location_api.delete_location
(p_validate => l_validate
,p_location_id => p_location_id
,p_object_version_number => p_object_version_number
);
rollback to delete_location_swi;
rollback to delete_location_swi;
end delete_location;