Tag Archives: hz_locations

Script to Update Customer Locations – HZ_LOCATION_V2PUB.UPDATE_LOCATION

We can use standard API HZ_LOCATION_V2PUB.UPDATE_LOCATION to update the existing customer address stored in the HZ_LOCATIONS table. /******************************************************************************** *PURPOSE: To Customer Locations information from back-end * *AUTHOR: Shailender Thallam * *********************************************************************************/ SET SERVEROUTPUT ON;   DECLARE — –Cursor to fetch location details — cursor cur_loc IS SELECT location_id, object_version_number, country, state, province FROM hz_locations WHERE… Read More »