APPS.IEX_MERGE_PVT dependencies on IEX_CASE_CONTACTS

Line 1572: iex_case_contacts

1568:
1569: /* Begin raverma 02032003 add new party_merge entities
1570: IEX_REPOSSESIONS
1571: iex_del_third_parties
1572: iex_case_contacts
1573: iex_cases_all_b
1574: iex_writeoffs
1575: iex_bankruptcies
1576: iex_litigations

Line 1654: UPDATE IEX_CASE_CONTACTS

1650: program_id = HZ_UTILITY_V2PUB.program_id,
1651: program_update_date = sysdate
1652: WHERE THIRD_PARTY_ID = p_from_fk_id;
1653:
1654: UPDATE IEX_CASE_CONTACTS
1655: SET CONTACT_PARTY_ID = p_To_FK_ID,
1656: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1657: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1658: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

Line 1886: UPDATE IEX_CASE_CONTACTS

1882:
1883: IF p_from_fk_id <> p_to_fk_id THEN
1884: BEGIN
1885: IF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site
1886: UPDATE IEX_CASE_CONTACTS
1887: set address_id = p_to_fk_id,
1888: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1889: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1890: last_update_login = HZ_UTILITY_V2PUB.last_update_login,

Line 1897: UPDATE IEX_CASE_CONTACTS

1893: program_id = HZ_UTILITY_V2PUB.program_id,
1894: program_update_date = sysdate
1895: where address_id = p_from_fk_id;
1896: ELSIF p_parent_entity_name = 'HZ_CONTACT_POINTS' THEN -- merge contact_points
1897: UPDATE IEX_CASE_CONTACTS
1898: set phone_id = p_to_fk_id,
1899: last_update_date = HZ_UTILITY_V2PUB.last_update_date,
1900: last_updated_by = HZ_UTILITY_V2PUB.user_id,
1901: last_update_login = HZ_UTILITY_V2PUB.last_update_login,