APPS.WSH_MAP_LOCATION_REGION_PKG dependencies on WSH_LOCATIONS_PKG

Line 385: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LOCATIONS_PKG.Process_Locations',WSH_DEBUG_SV.C_PROC_LEVEL);

381:
382: l_completion_status := 'NORMAL';
383:
384: IF l_debug_on THEN
385: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LOCATIONS_PKG.Process_Locations',WSH_DEBUG_SV.C_PROC_LEVEL);
386: END IF;
387: WSH_LOCATIONS_PKG.Process_Locations (
388: p_location_type => p_location_type,
389: p_from_location => p_from_location,

Line 387: WSH_LOCATIONS_PKG.Process_Locations (

383:
384: IF l_debug_on THEN
385: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LOCATIONS_PKG.Process_Locations',WSH_DEBUG_SV.C_PROC_LEVEL);
386: END IF;
387: WSH_LOCATIONS_PKG.Process_Locations (
388: p_location_type => p_location_type,
389: p_from_location => p_from_location,
390: p_to_location => p_to_location,
391: p_start_date => p_start_date,

Line 399: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from WSH_LOCATIONS_PKG.Process_Locations : '|| l_return_status);

395: x_sqlcode => l_sqlcode,
396: x_sqlerr => l_sqlerr);
397:
398: IF l_debug_on THEN
399: WSH_DEBUG_SV.logmsg(l_module_name,'Return Status from WSH_LOCATIONS_PKG.Process_Locations : '|| l_return_status);
400: END IF;
401:
402:
403: IF l_return_status NOT IN

Line 2100: WSH_LOCATIONS_PKG.Process_Locations(

2096:
2097: END LOOP;
2098:
2099:
2100: WSH_LOCATIONS_PKG.Process_Locations(
2101: p_location_type => 'EXTERNAL'
2102: , p_from_location => p_location_id
2103: , p_to_location => p_location_id
2104: , p_start_date => NULL

Line 2116: l_pkg_name := 'WSH_LOCATIONS_PKG';

2112: END IF;
2113:
2114: IF ( l_return_status1 NOT IN
2115: (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING) ) THEN
2116: l_pkg_name := 'WSH_LOCATIONS_PKG';
2117: l_proc_name := 'Process_Locations';
2118: raise e_loc;
2119: END IF;
2120:

Line 2347: WSH_LOCATIONS_PKG.Process_Locations (

2343: IF l_debug_on THEN
2344: WSH_DEBUG_SV.log(l_module_name,'-----------------------------');
2345: WSH_DEBUG_SV.log(l_module_name,'Calling procedure Process_Locations');
2346: END IF;
2347: WSH_LOCATIONS_PKG.Process_Locations (
2348: p_location_type => l_location_source_type,
2349: p_from_location => p_source_location_id,
2350: p_to_location => p_source_location_id,
2351: p_start_date => NULL,

Line 2546: WSH_LOCATIONS_PKG.Process_Locations(

2542:
2543: -- Should update only
2544: -- if caller is 'HR' and company is not found
2545: -- should not create
2546: WSH_LOCATIONS_PKG.Process_Locations(
2547: p_location_type => 'INTERNAL'
2548: , p_from_location => p_location_id
2549: , p_to_location => p_location_id
2550: , p_start_date => NULL