-- apps_master.sp_UpdateOutletLocation_HA (PROCEDURE)
BEGIN 
	UPDATE 	apps_master.outlet_location
	SET	OutletLatitude = latitude,
		OutletLongitude = longitude,
		OutletAddress = address,
		OutletCity = city,
		OutletPostalCode = postalCode,
		OutletProvince = province,
		LastUpdated = NOW(),
		UpdatedBy = userID
	WHERE 	OutletID = id;
end