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

2204: county,
2205: city,
2206: postal_code,
2207: inactive_date
2208: FROM wsh_locations
2209: WHERE source_location_id = p_source_location_id;
2210:
2211:
2212: CURSOR Get_Location_Data1 IS

Line 2229: FROM wsh_locations

2225: county,
2226: city,
2227: postal_code,
2228: inactive_date
2229: FROM wsh_locations
2230: WHERE wsh_location_id = p_source_location_id;
2231:
2232: l_return_status VARCHAR2(20);
2233: l_sqlcode NUMBER;

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

2316: END IF;
2317:
2318: --
2319: -- If a location is not found and if p_transfer_location
2320: -- is true, then create the location record in WSH_LOCATIONS
2321: -- table.
2322: --
2323:
2324: IF ((p_source_location_id IS NOT NULL) AND

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

2450: | DESCRIPTION |
2451: | This API is called by Create_Location/Update_Location |
2452: | Business Process - After Process User Hook. |
2453: | This ensures that the whenever HR location is created or |
2454: | updated, corresponding changes in WSH_LOCATIONS and |
2455: | WSH_REGION_LOCATIONS happens |
2456: +===========================================================================*/
2457:
2458: PROCEDURE Location_User_Hook_API(

Line 2512: FROM wsh_locations

2508: --Bug 6940375
2509:
2510: CURSOR check_wsh_loc(c_loc_id IN NUMBER) IS
2511: SELECT wsh_location_id
2512: FROM wsh_locations
2513: WHERE source_location_id = c_loc_id
2514: AND location_source_code = 'HR';
2515:
2516: CURSOR check_company(c_loc_id IN NUMBER) IS

Line 2528: -- Create a record in WSH_LOCATIONS

2524:
2525: l_location_source := 'HR';
2526:
2527: --
2528: -- Create a record in WSH_LOCATIONS
2529: --
2530: --Bug 6940375 Start (Check if the HR location is deleted,
2531: --then delete location from wsh_locations)
2532: OPEN Get_Internal_Loc;

Line 2531: --then delete location from wsh_locations)

2527: --
2528: -- Create a record in WSH_LOCATIONS
2529: --
2530: --Bug 6940375 Start (Check if the HR location is deleted,
2531: --then delete location from wsh_locations)
2532: OPEN Get_Internal_Loc;
2533: FETCH Get_Internal_Loc INTO
2534: l_wsh_loc_id;
2535: IF Get_Internal_Loc%NOTFOUND THEN

Line 2537: DELETE FROM wsh_locations

2533: FETCH Get_Internal_Loc INTO
2534: l_wsh_loc_id;
2535: IF Get_Internal_Loc%NOTFOUND THEN
2536: CLOSE Get_Internal_Loc;
2537: DELETE FROM wsh_locations
2538: WHERE wsh_location_id = p_location_id;
2539: RETURN ;
2540: END IF;
2541: CLOSE Get_Internal_Loc;

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

Line 3135: FROM WSH_CALENDAR_ASSIGNMENTS WCA, WSH_LOCATIONS WSH

3131: END IF;
3132: v_delete_permitted := NULL;
3133: SELECT 'N'
3134: INTO v_delete_permitted
3135: FROM WSH_CALENDAR_ASSIGNMENTS WCA, WSH_LOCATIONS WSH
3136: WHERE WCA.LOCATION_ID = P_LOCATION_ID
3137: AND WSH.WSH_LOCATION_ID = WCA.LOCATION_ID
3138: AND WSH.LOCATION_SOURCE_CODE = 'HR'
3139: AND ROWNUM = 1;

Line 3161: FROM WSH_DOC_SEQUENCE_CATEGORIES WDO, WSH_LOCATIONS WSH

3157: END IF;
3158: v_delete_permitted := NULL;
3159: SELECT 'N'
3160: INTO v_delete_permitted
3161: FROM WSH_DOC_SEQUENCE_CATEGORIES WDO, WSH_LOCATIONS WSH
3162: WHERE WDO.LOCATION_ID = P_LOCATION_ID
3163: AND WSH.WSH_LOCATION_ID = WDO.LOCATION_ID
3164: AND WSH.LOCATION_SOURCE_CODE = 'HR'
3165: AND ROWNUM = 1;