APPS.WSH_PARTY_MERGE dependencies on WSH_LOCATION_OWNERS

Line 225: FROM wsh_location_owners

221: IS
222:
223: CURSOR c_check_duplicate(p_location_id IN NUMBER, p_party_id IN NUMBER) IS
224: SELECT location_owner_id
225: FROM wsh_location_owners
226: WHERE wsh_location_id = p_location_id
227: AND owner_party_id = p_party_id;
228:
229: CURSOR c_populate_data(p_loc_owner_id IN NUMBER) IS

Line 231: FROM wsh_location_owners

227: AND owner_party_id = p_party_id;
228:
229: CURSOR c_populate_data(p_loc_owner_id IN NUMBER) IS
230: SELECT wsh_location_id
231: FROM wsh_location_owners
232: WHERE location_owner_id = p_loc_owner_id;
233:
234: l_location_id NUMBER;
235: --l_owner_type NUMBER;

Line 282: -- Updates OWNER_PARTY_ID and OWNER_TYPE in WSH_LOCATION_OWNERS

278: -- x_return_status Returns the staus of call
279: --
280: -- COMMENT : To merge locations for parties.-Parent Entity is HZ_PARTIES.
281: -- Owner Type can be either Supplier or Customer, Carriers cannot be merged
282: -- Updates OWNER_PARTY_ID and OWNER_TYPE in WSH_LOCATION_OWNERS
283: --========================================================================
284:
285: PROCEDURE merge_party_locations(
286: p_entity_name IN VARCHAR2,

Line 298: FROM wsh_location_owners

294: x_return_status IN OUT NOCOPY VARCHAR2) IS
295:
296: Cursor C_Owner_Type(p_party_id NUMBER) IS
297: SELECT owner_type
298: FROM wsh_location_owners
299: WHERE owner_party_id = p_party_id;
300:
301: CURSOR check_party_carrier_supplier(c_party_id IN NUMBER) IS
302: SELECT 3

Line 318: FROM wsh_location_owners

314: owner_type,
315: last_update_date,
316: last_updated_by,
317: last_update_login
318: FROM wsh_location_owners
319: WHERE location_owner_id = p_from_id
320: AND owner_party_id = p_from_party_id
321: FOR UPDATE NOWAIT;
322:

Line 396: UPDATE wsh_location_owners

392:
393: IF get_loc_owners_for_update%FOUND THEN
394: --No Wait will raise the exception
395:
396: UPDATE wsh_location_owners
397: SET owner_party_id = p_to_fk_id,
398: owner_type = l_owner_type_to,
399: last_update_date = hz_utility_pub.last_update_date,
400: last_updated_by = hz_utility_pub.user_id,