APPS.HZ_MATCH_RULE_240 dependencies on HZ_CONTACT_POINTS

Line 339: FROM HZ_CONTACT_POINTS

335: IF p_entity = 'CONTACT_POINTS' THEN
336: IF p_attribute = 'PHONE_NUMBER' THEN
337: BEGIN
338: SELECT PHONE_NUMBER INTO l_matched_value
339: FROM HZ_CONTACT_POINTS
340: WHERE contact_point_id = p_record_id and rownum=1;
341: EXCEPTION
342: WHEN NO_DATA_FOUND THEN
343: l_matched_value := 'Err';

Line 350: FROM HZ_CONTACT_POINTS

346: END IF;
347: IF p_attribute = 'EMAIL_ADDRESS' THEN
348: BEGIN
349: SELECT EMAIL_ADDRESS INTO l_matched_value
350: FROM HZ_CONTACT_POINTS
351: WHERE contact_point_id = p_record_id and rownum=1;
352: EXCEPTION
353: WHEN NO_DATA_FOUND THEN
354: l_matched_value := 'Err';

Line 4065: from hz_contact_points

4061: p_party_site_list HZ_PARTY_SEARCH.IDList;
4062: p_contact_ids HZ_PARTY_SEARCH.IDList;
4063: l_match_idx NUMBER;
4064: cursor get_cpts_for_party_sites is select contact_point_id
4065: from hz_contact_points
4066: where owner_table_name = 'HZ_PARTY_SITES'
4067: and primary_flag='Y'
4068: and owner_table_id = p_party_site_id;
4069: BEGIN

Line 4150: from hz_org_contacts a, hz_relationships b, hz_contact_points c

4146: p_party_site_list HZ_PARTY_SEARCH.IDList;
4147: p_contact_ids HZ_PARTY_SEARCH.IDList;
4148: l_match_idx NUMBER;
4149: cursor get_cpt_for_contact_id is select contact_point_id
4150: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4151: where a.party_relationship_id = b.relationship_id
4152: and c.owner_table_name = 'HZ_PARTIES'
4153: and c.primary_flag='Y'
4154: and c.owner_table_id = b.party_id

Line 5464: FROM HZ_CONTACT_POINTS

5460: ps:=ps+1;
5461: END LOOP;
5462: FOR CONTACT_POINTS IN (
5463: SELECT CONTACT_POINT_ID
5464: FROM HZ_CONTACT_POINTS
5465: WHERE PRIMARY_FLAG = 'Y'
5466: AND owner_table_name = 'HZ_PARTIES'
5467: AND owner_table_id = p_party_id
5468:

Line 5472: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

5468:
5469: UNION
5470:
5471: SELECT CONTACT_POINT_ID
5472: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
5473: WHERE PRIMARY_FLAG = 'Y'
5474: AND owner_table_name = 'HZ_PARTIES'
5475: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
5476: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 5485: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

5481: AND ROWNUM<6
5482: UNION
5483:
5484: SELECT CONTACT_POINT_ID
5485: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5486: WHERE PRIMARY_FLAG = 'Y'
5487: AND owner_table_name = 'HZ_PARTY_SITES'
5488: AND owner_table_id = party_site_id
5489: AND PARTY_ID = p_party_id

Line 5737: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')

5733:
5734: -- Cursor to fetch primary contact points for party
5735: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5736: SELECT contact_point_id, contact_point_type
5737: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
5738: ,translate(HZ_CONTACT_POINTS.PHONE_NUMBER, '%',' ')
5739: FROM HZ_CONTACT_POINTS
5740: WHERE contact_point_id = cp_contact_point_id;
5741:

Line 5738: ,translate(HZ_CONTACT_POINTS.PHONE_NUMBER, '%',' ')

5734: -- Cursor to fetch primary contact points for party
5735: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5736: SELECT contact_point_id, contact_point_type
5737: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
5738: ,translate(HZ_CONTACT_POINTS.PHONE_NUMBER, '%',' ')
5739: FROM HZ_CONTACT_POINTS
5740: WHERE contact_point_id = cp_contact_point_id;
5741:
5742: I NUMBER;

Line 5739: FROM HZ_CONTACT_POINTS

5735: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
5736: SELECT contact_point_id, contact_point_type
5737: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
5738: ,translate(HZ_CONTACT_POINTS.PHONE_NUMBER, '%',' ')
5739: FROM HZ_CONTACT_POINTS
5740: WHERE contact_point_id = cp_contact_point_id;
5741:
5742: I NUMBER;
5743: l_contact_point_id NUMBER;