APPS.ARP_CMERGE_ARCUS dependencies on HZ_CONTACT_POINTS

Line 3771: | hz_contact_points.owner_table_name = 'HZ_PARTIES'

3767: | MODIFICATION HISTORY
3768: |
3769: | Jianying Huang 25-OCT-00 Remove parameter orgContactId. from_party_id
3770: | should be used by cursor. Add new condition:
3771: | hz_contact_points.owner_table_name = 'HZ_PARTIES'
3772: | Jianying Huang 25-OCT-00 After call create_contact_point API,
3773: | if return_status is not 'success', we need to
3774: | populate an exception.
3775: | Jianying Huang 27-OCT-00 Since contacts of 'phone' type also goes

Line 3816: FROM hz_contact_points

3812: --in case of data model changes
3813:
3814: CURSOR c IS
3815: SELECT contact_point_id
3816: FROM hz_contact_points
3817: WHERE owner_table_name = p_owner_table_name
3818: AND owner_table_id = p_from_id;
3819:
3820: l_dup_exists VARCHAR2(10) := fnd_api.g_false;

Line 4120: FROM HZ_CONTACT_POINTS

4116:
4117: CURSOR dupcheck IS
4118: SELECT
4119: MIN(CONTACT_POINT_ID)
4120: FROM HZ_CONTACT_POINTS
4121: WHERE OWNER_TABLE_ID = p_to_owner_table_id
4122: AND
4123: OWNER_TABLE_NAME ||
4124: CONTACT_POINT_TYPE ||

Line 4177: FROM HZ_CONTACT_POINTS

4173: PHONE_LINE_TYPE ||
4174: TELEX_NUMBER ||
4175: CONTENT_SOURCE_TYPE ||
4176: WEB_TYPE
4177: FROM HZ_CONTACT_POINTS
4178: WHERE CONTACT_POINT_ID = p_from_contact_point_id)
4179: AND nvl(EMAIL_ADDRESS,'NOEMAIL') = (
4180: SELECT nvl(EMAIL_ADDRESS,'NOEMAIL')
4181: FROM HZ_CONTACT_POINTS

Line 4181: FROM HZ_CONTACT_POINTS

4177: FROM HZ_CONTACT_POINTS
4178: WHERE CONTACT_POINT_ID = p_from_contact_point_id)
4179: AND nvl(EMAIL_ADDRESS,'NOEMAIL') = (
4180: SELECT nvl(EMAIL_ADDRESS,'NOEMAIL')
4181: FROM HZ_CONTACT_POINTS
4182: WHERE CONTACT_POINT_ID = p_from_contact_point_id)
4183: AND nvl(URL, 'NOURL') = (
4184: SELECT nvl(URL, 'NOURL')
4185: FROM HZ_CONTACT_POINTS

Line 4185: FROM HZ_CONTACT_POINTS

4181: FROM HZ_CONTACT_POINTS
4182: WHERE CONTACT_POINT_ID = p_from_contact_point_id)
4183: AND nvl(URL, 'NOURL') = (
4184: SELECT nvl(URL, 'NOURL')
4185: FROM HZ_CONTACT_POINTS
4186: WHERE CONTACT_POINT_ID = p_from_contact_point_id)
4187: AND CONTACT_POINT_ID <> p_from_contact_point_id;
4188:
4189: l_record_id NUMBER;

Line 4770: | and 'UPDATE hz_contact_points..' part. We should

4766: | Jianying Huang 27-NOV-00 After call create_* API,
4767: | if return_status is not 'success', we need to
4768: | populate an exception.
4769: | Jianying Huang 27-NOV-00 Remove 'UPDATE hz_org_contacts ..'
4770: | and 'UPDATE hz_contact_points..' part. We should
4771: | not modify contacts data in party level. Instead,
4772: | we should migrate those data during merge process.
4773: | Jianying Huang 27-NOV-00 Added condition that we create profile amts
4774: | if only if there is profile exist for the site use.