APPS.ARP_CMERGE_ARCUS dependencies on HZ_CONTACT_POINTS

Line 4079: | hz_contact_points.owner_table_name = 'HZ_PARTIES'

4075: | MODIFICATION HISTORY
4076: |
4077: | Jianying Huang 25-OCT-00 Remove parameter orgContactId. from_party_id
4078: | should be used by cursor. Add new condition:
4079: | hz_contact_points.owner_table_name = 'HZ_PARTIES'
4080: | Jianying Huang 25-OCT-00 After call create_contact_point API,
4081: | if return_status is not 'success', we need to
4082: | populate an exception.
4083: | Jianying Huang 27-OCT-00 Since contacts of 'phone' type also goes

Line 4124: FROM hz_contact_points

4120: --in case of data model changes
4121:
4122: CURSOR c IS
4123: SELECT contact_point_id
4124: FROM hz_contact_points
4125: WHERE owner_table_name = p_owner_table_name
4126: AND owner_table_id = p_from_id;
4127:
4128: l_dup_exists VARCHAR2(10) := fnd_api.g_false;

Line 4428: FROM HZ_CONTACT_POINTS

4424:
4425: CURSOR dupcheck IS
4426: SELECT
4427: MIN(CONTACT_POINT_ID)
4428: FROM HZ_CONTACT_POINTS
4429: WHERE OWNER_TABLE_ID = p_to_owner_table_id
4430: AND
4431: OWNER_TABLE_NAME ||
4432: CONTACT_POINT_TYPE ||

Line 4487: FROM HZ_CONTACT_POINTS

4483: TELEX_NUMBER ||
4484: CONTENT_SOURCE_TYPE ||
4485: WEB_TYPE ||
4486: CONTACT_POINT_PURPOSE
4487: FROM HZ_CONTACT_POINTS
4488: WHERE CONTACT_POINT_ID = p_from_contact_point_id)
4489: AND nvl(EMAIL_ADDRESS,'NOEMAIL') = (
4490: SELECT nvl(EMAIL_ADDRESS,'NOEMAIL')
4491: FROM HZ_CONTACT_POINTS

Line 4491: FROM HZ_CONTACT_POINTS

4487: FROM HZ_CONTACT_POINTS
4488: WHERE CONTACT_POINT_ID = p_from_contact_point_id)
4489: AND nvl(EMAIL_ADDRESS,'NOEMAIL') = (
4490: SELECT nvl(EMAIL_ADDRESS,'NOEMAIL')
4491: FROM HZ_CONTACT_POINTS
4492: WHERE CONTACT_POINT_ID = p_from_contact_point_id)
4493: AND nvl(URL, 'NOURL') = (
4494: SELECT nvl(URL, 'NOURL')
4495: FROM HZ_CONTACT_POINTS

Line 4495: FROM HZ_CONTACT_POINTS

4491: FROM HZ_CONTACT_POINTS
4492: WHERE CONTACT_POINT_ID = p_from_contact_point_id)
4493: AND nvl(URL, 'NOURL') = (
4494: SELECT nvl(URL, 'NOURL')
4495: FROM HZ_CONTACT_POINTS
4496: WHERE CONTACT_POINT_ID = p_from_contact_point_id)
4497: AND CONTACT_POINT_ID <> p_from_contact_point_id;
4498:
4499: l_record_id NUMBER;

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

5076: | Jianying Huang 27-NOV-00 After call create_* API,
5077: | if return_status is not 'success', we need to
5078: | populate an exception.
5079: | Jianying Huang 27-NOV-00 Remove 'UPDATE hz_org_contacts ..'
5080: | and 'UPDATE hz_contact_points..' part. We should
5081: | not modify contacts data in party level. Instead,
5082: | we should migrate those data during merge process.
5083: | Jianying Huang 27-NOV-00 Added condition that we create profile amts
5084: | if only if there is profile exist for the site use.