APPS.FTE_COMP_CONSTRAINT_UTIL dependencies on WSH_REGIONS_TL

Line 199: l_country WSH_REGIONS_TL.COUNTRY%TYPE;

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;

Line 200: l_state WSH_REGIONS_TL.STATE%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

Line 201: l_city WSH_REGIONS_TL.CITY%TYPE;

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:

Line 202: l_postal_code_from WSH_REGIONS_TL.POSTAL_CODE_FROM%TYPE;

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;

Line 203: l_postal_code_to WSH_REGIONS_TL.POSTAL_CODE_TO%TYPE;

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