eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_MAP_LOCATION_REGION_PKG dependencies on WSH_LOCATIONS

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 850: wsh_locations l,

846: l.city city,
847: l.postal_code,
848: l.inactive_date
849: FROM
850: wsh_locations l,
851: fnd_territories_tl t
852: WHERE
853: t.territory_code = l.country and
854: t.language = userenv('LANG') and

Line 871: wsh_locations l,

867: l.city city,
868: l.postal_code,
869: l.inactive_date
870: FROM
871: wsh_locations l,
872: fnd_territories_tl t
873: WHERE
874: t.territory_code = l.country and
875: t.language = userenv('LANG') and

Line 893: wsh_locations l,

889: l.postal_code,
890: l.location_source_code source,
891: l.inactive_date
892: FROM
893: wsh_locations l,
894: fnd_territories_tl t
895: WHERE
896: t.territory_code = l.country and
897: t.language = userenv('LANG') and

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 2192: FROM wsh_locations

2188: county,
2189: city,
2190: postal_code,
2191: inactive_date
2192: FROM wsh_locations
2193: WHERE source_location_id = p_source_location_id;
2194:
2195:
2196: CURSOR Get_Location_Data1 IS

Line 2213: FROM wsh_locations

2209: county,
2210: city,
2211: postal_code,
2212: inactive_date
2213: FROM wsh_locations
2214: WHERE wsh_location_id = p_source_location_id;
2215:
2216: l_return_status VARCHAR2(20);
2217: l_sqlcode NUMBER;

Line 2304: -- is true, then create the location record in WSH_LOCATIONS

2300: END IF;
2301:
2302: --
2303: -- If a location is not found and if p_transfer_location
2304: -- is true, then create the location record in WSH_LOCATIONS
2305: -- table.
2306: --
2307:
2308: IF ((p_source_location_id IS NOT NULL) AND

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 2438: | updated, corresponding changes in WSH_LOCATIONS and |

2434: | DESCRIPTION |
2435: | This API is called by Create_Location/Update_Location |
2436: | Business Process - After Process User Hook. |
2437: | This ensures that the whenever HR location is created or |
2438: | updated, corresponding changes in WSH_LOCATIONS and |
2439: | WSH_REGION_LOCATIONS happens |
2440: +===========================================================================*/
2441:
2442: PROCEDURE Location_User_Hook_API(

Line 2496: FROM wsh_locations

2492: --Bug 6940375
2493:
2494: CURSOR check_wsh_loc(c_loc_id IN NUMBER) IS
2495: SELECT wsh_location_id
2496: FROM wsh_locations
2497: WHERE source_location_id = c_loc_id
2498: AND location_source_code = 'HR';
2499:
2500: CURSOR check_company(c_loc_id IN NUMBER) IS

Line 2512: -- Create a record in WSH_LOCATIONS

2508:
2509: l_location_source := 'HR';
2510:
2511: --
2512: -- Create a record in WSH_LOCATIONS
2513: --
2514: --Bug 6940375 Start (Check if the HR location is deleted,
2515: --then delete location from wsh_locations)
2516: OPEN Get_Internal_Loc;

Line 2515: --then delete location from wsh_locations)

2511: --
2512: -- Create a record in WSH_LOCATIONS
2513: --
2514: --Bug 6940375 Start (Check if the HR location is deleted,
2515: --then delete location from wsh_locations)
2516: OPEN Get_Internal_Loc;
2517: FETCH Get_Internal_Loc INTO
2518: l_wsh_loc_id;
2519: IF Get_Internal_Loc%NOTFOUND THEN

Line 2521: DELETE FROM wsh_locations

2517: FETCH Get_Internal_Loc INTO
2518: l_wsh_loc_id;
2519: IF Get_Internal_Loc%NOTFOUND THEN
2520: CLOSE Get_Internal_Loc;
2521: DELETE FROM wsh_locations
2522: WHERE wsh_location_id = p_location_id;
2523: RETURN ;
2524: END IF;
2525: CLOSE Get_Internal_Loc;

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

Line 3119: FROM WSH_CALENDAR_ASSIGNMENTS WCA, WSH_LOCATIONS WSH

3115: END IF;
3116: v_delete_permitted := NULL;
3117: SELECT 'N'
3118: INTO v_delete_permitted
3119: FROM WSH_CALENDAR_ASSIGNMENTS WCA, WSH_LOCATIONS WSH
3120: WHERE WCA.LOCATION_ID = P_LOCATION_ID
3121: AND WSH.WSH_LOCATION_ID = WCA.LOCATION_ID
3122: AND WSH.LOCATION_SOURCE_CODE = 'HR'
3123: AND ROWNUM = 1;

Line 3145: FROM WSH_DOC_SEQUENCE_CATEGORIES WDO, WSH_LOCATIONS WSH

3141: END IF;
3142: v_delete_permitted := NULL;
3143: SELECT 'N'
3144: INTO v_delete_permitted
3145: FROM WSH_DOC_SEQUENCE_CATEGORIES WDO, WSH_LOCATIONS WSH
3146: WHERE WDO.LOCATION_ID = P_LOCATION_ID
3147: AND WSH.WSH_LOCATION_ID = WDO.LOCATION_ID
3148: AND WSH.LOCATION_SOURCE_CODE = 'HR'
3149: AND ROWNUM = 1;