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,
401: last_update_login = hz_utility_pub.request_id
402: WHERE owner_party_id = p_from_fk_id
403: AND location_owner_id = p_from_id;
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,
401: last_update_login = hz_utility_pub.request_id
402: WHERE owner_party_id = p_from_fk_id
403: AND location_owner_id = p_from_id;
404:
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,
401: last_update_login = hz_utility_pub.request_id
402: WHERE owner_party_id = p_from_fk_id
403: AND location_owner_id = p_from_id;
404:
405: END IF;