The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_last_update_date date;
** Get the last update date from hz_location
*/
--fnd_client_info.set_org_context(204);
** Get the last update date from hz_location
*/
-- it doesn't make sense to change the payment API signature
-- for the OVN. we are assuming that no body has changed the
-- hz_location record since the user for our transaction read
-- the record. otherwise the change will simply be overwritten
select last_update_date, object_version_number into p_last_update_date, l_ovn
from hz_locations
where location_id = l_hz_location_v2_rec.location_id;
hz_location_v2pub.update_location(
p_location_rec => l_hz_location_v2_rec,
p_object_version_number => l_ovn,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data
);
HZ_LOCATION_PUB.update_location(
p_api_version,
p_init_msg_list,
p_commit,
location_rec,
p_last_update_date,
l_return_status,
l_msg_count,
l_msg_data);