APPS.ECX_TP_MERGE_PKG dependencies on ECX_DOCLOGS

Line 33: -- update ecx_doclogs for the merge

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
35: set partyid = to_char(p_to_fk_id)
36: where partyid = to_char(p_from_fk_id)
37: and party_type in ('C', 'E', 'CARRIER');

Line 34: update ecx_doclogs

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
35: set partyid = to_char(p_to_fk_id)
36: where partyid = to_char(p_from_fk_id)
37: and party_type in ('C', 'E', 'CARRIER');
38: -- update ECX_OUTBOUND_LOGS for the merge

Line 152: -- update ecx_doclogs for the merge

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
153: update ecx_doclogs
154: set party_site_id = to_char(p_to_fk_id)
155: where party_site_id = to_char(p_from_fk_id)
156: and party_type in ('C', 'E', 'CARRIER');

Line 153: update ecx_doclogs

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
153: update ecx_doclogs
154: set party_site_id = to_char(p_to_fk_id)
155: where party_site_id = to_char(p_from_fk_id)
156: and party_type in ('C', 'E', 'CARRIER');
157: -- update ecx_outbound_logs for the merge