APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on WSH_LOCATIONS

Line 121: wsh_locations wl

117: --
118: SELECT 1
119: INTO l_query_count
120: FROM wsh_delivery_details wdd,
121: wsh_locations wl
122: WHERE wdd.ship_from_location_id = wl.wsh_location_id
123: AND wl.source_location_id = get_party_site_rec.location_id
124: AND wdd.party_id = p_party_id
125: AND rownum=1;

Line 175: WSH_LOCATIONS_PKG.Process_Locations

171: IF l_debug_on THEN
172: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling Process_Location API', WSH_DEBUG_SV.C_PROC_LEVEL);
173: END IF;
174: --
175: WSH_LOCATIONS_PKG.Process_Locations
176: (
177: p_location_type => 'EXTERNAL',
178: p_from_location => get_party_site_rec.location_id,
179: p_to_location => get_party_site_rec.location_id,

Line 412: l_LocationIdTbl WSH_LOCATIONS_PKG.ID_Tbl_Type;

408: l_num_errors NUMBER :=0;
409: l_sql_code NUMBER;
410: l_sql_err VARCHAR2(32767);
411: l_party_site_use_id NUMBER;
412: l_LocationIdTbl WSH_LOCATIONS_PKG.ID_Tbl_Type;
413: l_count NUMBER;
414: --
415: BEGIN
416: --{

Line 690: WSH_LOCATIONS_PKG.Insert_Location_Owners

686: --
687: l_LocationIdTbl.DELETE;
688: l_LocationIdTbl(l_LocationIdTbl.COUNT+1) := l_location_id;
689: --
690: WSH_LOCATIONS_PKG.Insert_Location_Owners
691: (
692: pLocationIdTbl => l_LocationIdTbl,
693: p_location_source_code => 'HZ',
694: x_return_status => l_return_status

Line 996: FROM wsh_locations

992:
993: IF p_location_id IS NOT NULL THEN
994: --{
995: SELECT source_location_id INTO l_location_id
996: FROM wsh_locations
997: WHERE wsh_location_id = p_location_id;
998:
999: IF l_debug_on THEN
1000: --{