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');
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:
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');
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: