APPS.ECX_TP_MERGE_PKG dependencies on ECX_OUTBOUND_LOGS

Line 38: -- update ECX_OUTBOUND_LOGS 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
39: update ecx_outbound_logs
40: set party_id = to_char(p_to_fk_id)
41: where party_id = to_char(p_from_fk_id)
42: and party_type in ('C', 'E', 'CARRIER');

Line 39: update ecx_outbound_logs

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
39: update ecx_outbound_logs
40: set party_id = to_char(p_to_fk_id)
41: where party_id = to_char(p_from_fk_id)
42: and party_type in ('C', 'E', 'CARRIER');
43: exception

Line 157: -- update ecx_outbound_logs 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
158: update ecx_outbound_logs
159: set party_site_id = to_char(p_to_fk_id)
160: where party_site_id = to_char(p_from_fk_id)
161: and party_type in ('C', 'E', 'CARRIER');

Line 158: update ecx_outbound_logs

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
158: update ecx_outbound_logs
159: set party_site_id = to_char(p_to_fk_id)
160: where party_site_id = to_char(p_from_fk_id)
161: and party_type in ('C', 'E', 'CARRIER');
162: exception