APPS.ECX_TP_MERGE_PKG dependencies on HZ_UTILITY_PUB

Line 29: last_updated_by = hz_utility_pub.user_id,

25: end if;
26: -- update ECX_TP_HEADERS for the merge
27: update ecx_tp_headers
28: set party_id = p_to_fk_id,
29: last_updated_by = hz_utility_pub.user_id,
30: last_update_login = hz_utility_pub.last_update_login
31: where party_id = p_from_fk_id
32: and party_type in ('C', 'E', 'CARRIER');
33: -- update ecx_doclogs for the merge

Line 30: last_update_login = hz_utility_pub.last_update_login

26: -- update ECX_TP_HEADERS for the merge
27: update ecx_tp_headers
28: set party_id = p_to_fk_id,
29: last_updated_by = hz_utility_pub.user_id,
30: last_update_login = hz_utility_pub.last_update_login
31: where party_id = p_from_fk_id
32: and party_type in ('C', 'E', 'CARRIER');
33: -- update ecx_doclogs for the merge
34: update ecx_doclogs

Line 147: last_updated_by = hz_utility_pub.user_id,

143: else
144: -- update ecx_tp_headers for the merge
145: update ecx_tp_headers
146: set party_site_id = p_to_fk_id,
147: last_updated_by = hz_utility_pub.user_id,
148: last_update_login = hz_utility_pub.last_update_login
149: where party_site_id = p_from_fk_id
150: and party_type in ('C', 'E', 'CARRIER');
151: end if;

Line 148: last_update_login = hz_utility_pub.last_update_login

144: -- update ecx_tp_headers for the merge
145: update ecx_tp_headers
146: set party_site_id = p_to_fk_id,
147: last_updated_by = hz_utility_pub.user_id,
148: last_update_login = hz_utility_pub.last_update_login
149: where party_site_id = p_from_fk_id
150: and party_type in ('C', 'E', 'CARRIER');
151: end if;
152: -- update ecx_doclogs for the merge