DBA Data[Home] [Help]

APPS.WSH_PARTY_MERGE dependencies on HZ_UTILITY_PUB

Line 399: last_update_date = hz_utility_pub.last_update_date,

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;

Line 400: last_updated_by = hz_utility_pub.user_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:

Line 401: last_update_login = hz_utility_pub.request_id

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;