DBA Data[Home] [Help]

APPS.ECX_TP_MERGE_PKG dependencies on ECX_DOCLOGS

Line 38: -- update ECX_DOCLOGS for the merge

34: last_update_login = hz_utility_pub.last_update_login
35: WHERE party_id = p_From_FK_id
36: AND party_type in ('C', 'E', 'CARRIER');
37:
38: -- update ECX_DOCLOGS for the merge
39: UPDATE ECX_DOCLOGS
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');

Line 39: UPDATE ECX_DOCLOGS

35: WHERE party_id = p_From_FK_id
36: AND party_type in ('C', 'E', 'CARRIER');
37:
38: -- update ECX_DOCLOGS for the merge
39: UPDATE ECX_DOCLOGS
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:

Line 88: -- update ECX_DOCLOGS for the merge

84: last_update_login = hz_utility_pub.last_update_login
85: WHERE party_site_id = p_From_FK_id
86: AND party_type in ('C', 'E', 'CARRIER');
87:
88: -- update ECX_DOCLOGS for the merge
89: UPDATE ECX_DOCLOGS
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');

Line 89: UPDATE ECX_DOCLOGS

85: WHERE party_site_id = p_From_FK_id
86: AND party_type in ('C', 'E', 'CARRIER');
87:
88: -- update ECX_DOCLOGS for the merge
89: UPDATE ECX_DOCLOGS
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: