APPS.ECX_TP_MERGE_PKG dependencies on HZ_UTILITY_PUB

Line 33: last_updated_by = hz_utility_pub.user_id,

29:
30: -- update ECX_TP_HEADERS for the merge
31: UPDATE ECX_TP_HEADERS
32: SET party_id = p_To_FK_id,
33: last_updated_by = hz_utility_pub.user_id,
34: last_update_login = hz_utility_pub.last_update_login
35: WHERE party_id = p_From_FK_id
36: AND party_type in ('C', 'E', 'CARRIER');
37:

Line 34: last_update_login = hz_utility_pub.last_update_login

30: -- update ECX_TP_HEADERS for the merge
31: UPDATE ECX_TP_HEADERS
32: SET party_id = p_To_FK_id,
33: last_updated_by = hz_utility_pub.user_id,
34: last_update_login = hz_utility_pub.last_update_login
35: WHERE party_id = p_From_FK_id
36: AND party_type in ('C', 'E', 'CARRIER');
37:
38: -- update ECX_DOCLOGS for the merge

Line 83: last_updated_by = hz_utility_pub.user_id,

79:
80: -- update ECX_TP_HEADERS for the merge
81: UPDATE ECX_TP_HEADERS
82: SET party_site_id = p_To_FK_id,
83: last_updated_by = hz_utility_pub.user_id,
84: last_update_login = hz_utility_pub.last_update_login
85: WHERE party_site_id = p_From_FK_id
86: AND party_type in ('C', 'E', 'CARRIER');
87:

Line 84: last_update_login = hz_utility_pub.last_update_login

80: -- update ECX_TP_HEADERS for the merge
81: UPDATE ECX_TP_HEADERS
82: SET party_site_id = p_To_FK_id,
83: last_updated_by = hz_utility_pub.user_id,
84: last_update_login = hz_utility_pub.last_update_login
85: WHERE party_site_id = p_From_FK_id
86: AND party_type in ('C', 'E', 'CARRIER');
87:
88: -- update ECX_DOCLOGS for the merge