APPS.IBY_ADDRESS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 131

p_last_update_date	date;

Line: 135

** Get the last update date from hz_location
*/
--fnd_client_info.set_org_context(204);

Line: 149

** 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;

Line: 159

      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
      );

Line: 167

    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);