DBA Data[Home] [Help]

APPS.WSH_GEOCODING dependencies on HZ_TIMEZONE_PUB

Line 372: WSH_DEBUG_SV.log(l_module_name,'Calling program unit HZ_TIMEZONE_PUB.Get_Primary_Zone');

368:
369: IF (x_record_found) THEN
370:
371: IF l_debug_on THEN
372: WSH_DEBUG_SV.log(l_module_name,'Calling program unit HZ_TIMEZONE_PUB.Get_Primary_Zone');
373: END IF;
374:
375: /* Following workaround is because of non availability of NAVTECH data yet */
376: x_begin_dst_hour := 2;

Line 383: -- So need not call HZ_TIMEZONE_PUB.get_primary_zone

379: /* Following is a workaround untill HZ fixes their API, data */
380: x_begin_dst_week_of_month := 1;
381: x_end_dst_week_of_month := -1;
382: -- Bug 5490063. Added below IF condition. For invalid locations or location with no ext setup all the below parameters would be null
383: -- So need not call HZ_TIMEZONE_PUB.get_primary_zone
384: IF(
385: (x_gmt_offset IS NOT NULL) OR (x_dst_flag IS NOT NULL) OR (x_begin_dst_day IS NOT NULL) OR
386: (x_begin_dst_day_of_week IS NOT NULL) OR (x_end_dst_month IS NOT NULL) OR (x_end_dst_day_of_week IS NOT NULL)
387: ) THEN

Line 388: HZ_TIMEZONE_PUB.Get_Primary_Zone (

384: IF(
385: (x_gmt_offset IS NOT NULL) OR (x_dst_flag IS NOT NULL) OR (x_begin_dst_day IS NOT NULL) OR
386: (x_begin_dst_day_of_week IS NOT NULL) OR (x_end_dst_month IS NOT NULL) OR (x_end_dst_day_of_week IS NOT NULL)
387: ) THEN
388: HZ_TIMEZONE_PUB.Get_Primary_Zone (
389: p_api_version,
390: p_init_msg_list,
391: x_gmt_offset,
392: x_dst_flag,