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 2084: WSH_LOCATIONS_PKG.Process_Locations(

2080:
2081: END LOOP;
2082:
2083:
2084: WSH_LOCATIONS_PKG.Process_Locations(
2085: p_location_type => 'EXTERNAL'
2086: , p_from_location => p_location_id
2087: , p_to_location => p_location_id
2088: , p_start_date => NULL

Line 2100: l_pkg_name := 'WSH_LOCATIONS_PKG';

2096: END IF;
2097:
2098: IF ( l_return_status1 NOT IN
2099: (WSH_UTIL_CORE.G_RET_STS_SUCCESS, WSH_UTIL_CORE.G_RET_STS_WARNING) ) THEN
2100: l_pkg_name := 'WSH_LOCATIONS_PKG';
2101: l_proc_name := 'Process_Locations';
2102: raise e_loc;
2103: END IF;
2104:

Line 2331: WSH_LOCATIONS_PKG.Process_Locations (

2327: IF l_debug_on THEN
2328: WSH_DEBUG_SV.log(l_module_name,'-----------------------------');
2329: WSH_DEBUG_SV.log(l_module_name,'Calling procedure Process_Locations');
2330: END IF;
2331: WSH_LOCATIONS_PKG.Process_Locations (
2332: p_location_type => l_location_source_type,
2333: p_from_location => p_source_location_id,
2334: p_to_location => p_source_location_id,
2335: p_start_date => NULL,

Line 2530: WSH_LOCATIONS_PKG.Process_Locations(

2526:
2527: -- Should update only
2528: -- if caller is 'HR' and company is not found
2529: -- should not create
2530: WSH_LOCATIONS_PKG.Process_Locations(
2531: p_location_type => 'INTERNAL'
2532: , p_from_location => p_location_id
2533: , p_to_location => p_location_id
2534: , p_start_date => NULL