APPS.WSH_GEOCODING dependencies on WSH_LOCATION_DATA_EXT

Line 141: FROM wsh_location_data_ext c

137: x_begin_dst_day_of_week, x_begin_dst_hour,
138: x_end_dst_month, x_end_dst_day,
139: x_end_dst_week_of_month, x_end_dst_day_of_week,
140: x_end_dst_hour, x_geometry
141: FROM wsh_location_data_ext c
142: WHERE c.ZIP_CODE = upper(l_location.postal_code) AND
143: c.CITY = upper(l_location.city);
144:
145:

Line 181: FROM wsh_location_data_ext c

177: x_begin_dst_day_of_week, x_begin_dst_hour,
178: x_end_dst_month, x_end_dst_day,
179: x_end_dst_week_of_month, x_end_dst_day_of_week,
180: x_end_dst_hour, x_geometry
181: FROM wsh_location_data_ext c
182: WHERE c.ZIP_CODE = upper(l_location.postal_code);
183:
184: EXCEPTION
185: WHEN NO_DATA_FOUND THEN

Line 226: FROM wsh_location_data_ext c

222: x_begin_dst_day_of_week, x_begin_dst_hour,
223: x_end_dst_month, x_end_dst_day,
224: x_end_dst_week_of_month, x_end_dst_day_of_week,
225: x_end_dst_hour
226: FROM wsh_location_data_ext c
227: WHERE c.CITY = upper(l_location.city) AND
228: c.COUNTY = upper(l_location.county);
229:
230: EXCEPTION

Line 269: FROM wsh_location_data_ext c

265: x_begin_dst_day_of_week, x_begin_dst_hour,
266: x_end_dst_month, x_end_dst_day,
267: x_end_dst_week_of_month, x_end_dst_day_of_week,
268: x_end_dst_hour
269: FROM wsh_location_data_ext c
270: WHERE c.CITY = upper(l_location.city) AND
271: c.STATE = upper(l_location.state);
272:
273: EXCEPTION

Line 315: FROM wsh_location_data_ext c

311: x_begin_dst_day_of_week, x_begin_dst_hour,
312: x_end_dst_month, x_end_dst_day,
313: x_end_dst_week_of_month, x_end_dst_day_of_week,
314: x_end_dst_hour
315: FROM wsh_location_data_ext c
316: WHERE c.STATE = upper(l_location.state) AND
317: c.COUNTY = upper(l_location.county);
318:
319: EXCEPTION

Line 356: FROM wsh_location_data_ext c

352: x_begin_dst_day_of_week, x_begin_dst_hour,
353: x_end_dst_month, x_end_dst_day,
354: x_end_dst_week_of_month, x_end_dst_day_of_week,
355: x_end_dst_hour
356: FROM wsh_location_data_ext c
357: WHERE c.STATE = upper(l_location.state);
358:
359: EXCEPTION
360: WHEN NO_DATA_FOUND THEN

Line 413: WSH_DEBUG_SV.log(l_module_name,'No record found in wsh_location_data_ext');

409: x_msg_count,
410: x_msg_data );
411: ELSE
412: IF l_debug_on THEN
413: WSH_DEBUG_SV.log(l_module_name,'No record found in wsh_location_data_ext');
414: END IF;
415: END IF;
416: l_location.latitude := x_latitude;
417: l_location.longitude := x_longitude;

Line 430: WSH_DEBUG_SV.log(l_module_name,'No record found in wsh_location_data_ext');

426:
427: ELSE
428:
429: IF l_debug_on THEN
430: WSH_DEBUG_SV.log(l_module_name,'No record found in wsh_location_data_ext');
431: END IF;
432:
433: END IF;
434: