APPS.IEX_MERGE_PVT dependencies on IEX_CASE_CONTACTS

Line 1694: iex_case_contacts

1690:
1691: /* Begin raverma 02032003 add new party_merge entities
1692: IEX_REPOSSESIONS
1693: iex_del_third_parties
1694: iex_case_contacts
1695: iex_cases_all_b
1696: iex_writeoffs
1697: iex_bankruptcies
1698: iex_litigations

Line 1776: UPDATE IEX_CASE_CONTACTS

1772: program_id = HZ_UTILITY_V2PUB.program_id,
1773: program_update_date = sysdate
1774: WHERE THIRD_PARTY_ID = p_from_fk_id;
1775:
1776: UPDATE IEX_CASE_CONTACTS
1777: SET CONTACT_PARTY_ID = p_To_FK_ID,
1778: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1779: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1780: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

Line 2008: UPDATE IEX_CASE_CONTACTS

2004:
2005: IF p_from_fk_id <> p_to_fk_id THEN
2006: BEGIN
2007: IF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site
2008: UPDATE IEX_CASE_CONTACTS
2009: set address_id = p_to_fk_id,
2010: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
2011: last_updated_by = HZ_UTILITY_V2PUB.user_id,
2012: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

Line 2019: UPDATE IEX_CASE_CONTACTS

2015: program_id = HZ_UTILITY_V2PUB.program_id,
2016: program_update_date = sysdate
2017: where address_id = p_from_fk_id;
2018: ELSIF p_parent_entity_name = 'HZ_CONTACT_POINTS' THEN -- merge contact_points
2019: UPDATE IEX_CASE_CONTACTS
2020: set phone_id = p_to_fk_id,
2021: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
2022: last_updated_by = HZ_UTILITY_V2PUB.user_id,
2023: last_update_login = HZ_UTILITY_V2PUB.last_update_login,