APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on WSH_LOCATIONS

Line 128: wsh_locations wl

124: --
125: SELECT 1
126: INTO l_query_count
127: FROM wsh_delivery_details wdd,
128: wsh_locations wl
129: WHERE wdd.ship_from_location_id = wl.wsh_location_id
130: AND wl.source_location_id = get_party_site_rec.location_id
131: AND wdd.party_id = p_party_id
132: AND rownum=1;

Line 182: WSH_LOCATIONS_PKG.Process_Locations

178: IF l_debug_on THEN
179: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Process_Location API', WSH_DEBUG_SV.C_PROC_LEVEL);
180: END IF;
181: --
182: WSH_LOCATIONS_PKG.Process_Locations
183: (
184: p_location_type => 'EXTERNAL',
185: p_from_location => get_party_site_rec.location_id,
186: p_to_location => get_party_site_rec.location_id,

Line 419: l_LocationIdTbl WSH_LOCATIONS_PKG.ID_Tbl_Type;

415: l_num_errors NUMBER :=0;
416: l_sql_code NUMBER;
417: l_sql_err VARCHAR2(32767);
418: l_party_site_use_id NUMBER;
419: l_LocationIdTbl WSH_LOCATIONS_PKG.ID_Tbl_Type;
420: l_count NUMBER;
421: --
422: BEGIN
423: --{

Line 697: WSH_LOCATIONS_PKG.Insert_Location_Owners

693: --
694: l_LocationIdTbl.DELETE;
695: l_LocationIdTbl(l_LocationIdTbl.COUNT+1) := l_location_id;
696: --
697: WSH_LOCATIONS_PKG.Insert_Location_Owners
698: (
699: pLocationIdTbl => l_LocationIdTbl,
700: p_location_source_code => 'HZ',
701: x_return_status => l_return_status

Line 1003: FROM wsh_locations

999:
1000: IF p_location_id IS NOT NULL THEN
1001: --{
1002: SELECT source_location_id INTO l_location_id
1003: FROM wsh_locations
1004: WHERE wsh_location_id = p_location_id;
1005:
1006: IF l_debug_on THEN
1007: --{