APPS.ECX_TP_MERGE_PKG dependencies on ECX_OUTBOUND_LOGS

Line 44: -- update ECX_OUTBOUND_LOGS for the merge

40: SET partyid = to_char(p_To_FK_id)
41: WHERE partyid = to_char(p_From_FK_id)
42: AND party_type in ('C', 'E', 'CARRIER');
43:
44: -- update ECX_OUTBOUND_LOGS for the merge
45: UPDATE ECX_OUTBOUND_LOGS
46: SET party_id = to_char(p_To_FK_id)
47: WHERE party_id = to_char(p_From_FK_id)
48: AND party_type in ('C', 'E', 'CARRIER');

Line 45: UPDATE ECX_OUTBOUND_LOGS

41: WHERE partyid = to_char(p_From_FK_id)
42: AND party_type in ('C', 'E', 'CARRIER');
43:
44: -- update ECX_OUTBOUND_LOGS for the merge
45: UPDATE ECX_OUTBOUND_LOGS
46: SET party_id = to_char(p_To_FK_id)
47: WHERE party_id = to_char(p_From_FK_id)
48: AND party_type in ('C', 'E', 'CARRIER');
49:

Line 94: -- update ECX_OUTBOUND_LOGS for the merge

90: SET party_site_id = to_char(p_To_FK_id)
91: WHERE party_site_id = to_char(p_From_FK_id)
92: AND party_type in ('C', 'E', 'CARRIER');
93:
94: -- update ECX_OUTBOUND_LOGS for the merge
95: UPDATE ECX_OUTBOUND_LOGS
96: SET party_site_id = to_char(p_To_FK_id)
97: WHERE party_site_id = to_char(p_From_FK_id)
98: AND party_type in ('C', 'E', 'CARRIER');

Line 95: UPDATE ECX_OUTBOUND_LOGS

91: WHERE party_site_id = to_char(p_From_FK_id)
92: AND party_type in ('C', 'E', 'CARRIER');
93:
94: -- update ECX_OUTBOUND_LOGS for the merge
95: UPDATE ECX_OUTBOUND_LOGS
96: SET party_site_id = to_char(p_To_FK_id)
97: WHERE party_site_id = to_char(p_From_FK_id)
98: AND party_type in ('C', 'E', 'CARRIER');
99: