195: l_veh_org_id NUMBER;
196: l_veh_class_code VARCHAR2(30);
197: l_vehicle_meaning VARCHAR2(80);
198: --#REG-ZON
199: l_country WSH_REGIONS_TL.COUNTRY%TYPE;
200: l_state WSH_REGIONS_TL.STATE%TYPE;
201: l_city WSH_REGIONS_TL.CITY%TYPE;
202: l_postal_code_from WSH_REGIONS_TL.POSTAL_CODE_FROM%TYPE;
203: l_postal_code_to WSH_REGIONS_TL.POSTAL_CODE_TO%TYPE;
196: l_veh_class_code VARCHAR2(30);
197: l_vehicle_meaning VARCHAR2(80);
198: --#REG-ZON
199: l_country WSH_REGIONS_TL.COUNTRY%TYPE;
200: l_state WSH_REGIONS_TL.STATE%TYPE;
201: l_city WSH_REGIONS_TL.CITY%TYPE;
202: l_postal_code_from WSH_REGIONS_TL.POSTAL_CODE_FROM%TYPE;
203: l_postal_code_to WSH_REGIONS_TL.POSTAL_CODE_TO%TYPE;
204: --#REG-ZON
197: l_vehicle_meaning VARCHAR2(80);
198: --#REG-ZON
199: l_country WSH_REGIONS_TL.COUNTRY%TYPE;
200: l_state WSH_REGIONS_TL.STATE%TYPE;
201: l_city WSH_REGIONS_TL.CITY%TYPE;
202: l_postal_code_from WSH_REGIONS_TL.POSTAL_CODE_FROM%TYPE;
203: l_postal_code_to WSH_REGIONS_TL.POSTAL_CODE_TO%TYPE;
204: --#REG-ZON
205:
198: --#REG-ZON
199: l_country WSH_REGIONS_TL.COUNTRY%TYPE;
200: l_state WSH_REGIONS_TL.STATE%TYPE;
201: l_city WSH_REGIONS_TL.CITY%TYPE;
202: l_postal_code_from WSH_REGIONS_TL.POSTAL_CODE_FROM%TYPE;
203: l_postal_code_to WSH_REGIONS_TL.POSTAL_CODE_TO%TYPE;
204: --#REG-ZON
205:
206: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
199: l_country WSH_REGIONS_TL.COUNTRY%TYPE;
200: l_state WSH_REGIONS_TL.STATE%TYPE;
201: l_city WSH_REGIONS_TL.CITY%TYPE;
202: l_postal_code_from WSH_REGIONS_TL.POSTAL_CODE_FROM%TYPE;
203: l_postal_code_to WSH_REGIONS_TL.POSTAL_CODE_TO%TYPE;
204: --#REG-ZON
205:
206: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
207: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || 'get_object_name';