APPS.HZ_MATCH_RULE_8 dependencies on HZ_CONTACT_POINTS

Line 470: FROM HZ_CONTACT_POINTS

466: END IF;
467: IF p_attribute = 'EMAIL_ADDRESS' THEN
468: BEGIN
469: SELECT EMAIL_ADDRESS INTO l_matched_value
470: FROM HZ_CONTACT_POINTS
471: WHERE contact_point_id = p_record_id and rownum=1;
472: EXCEPTION
473: WHEN NO_DATA_FOUND THEN
474: l_matched_value := 'Err';

Line 481: FROM HZ_CONTACT_POINTS

477: END IF;
478: IF p_attribute = 'URL' THEN
479: BEGIN
480: SELECT URL INTO l_matched_value
481: FROM HZ_CONTACT_POINTS
482: WHERE contact_point_id = p_record_id and rownum=1;
483: EXCEPTION
484: WHEN NO_DATA_FOUND THEN
485: l_matched_value := 'Err';

Line 4490: from hz_contact_points

4486: p_party_site_list HZ_PARTY_SEARCH.IDList;
4487: p_contact_ids HZ_PARTY_SEARCH.IDList;
4488: l_match_idx NUMBER;
4489: cursor get_cpts_for_party_sites is select contact_point_id
4490: from hz_contact_points
4491: where owner_table_name = 'HZ_PARTY_SITES'
4492: and primary_flag='Y'
4493: and owner_table_id = p_party_site_id;
4494: BEGIN

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

4571: p_party_site_list HZ_PARTY_SEARCH.IDList;
4572: p_contact_ids HZ_PARTY_SEARCH.IDList;
4573: l_match_idx NUMBER;
4574: cursor get_cpt_for_contact_id is select contact_point_id
4575: from hz_org_contacts a, hz_relationships b, hz_contact_points c
4576: where a.party_relationship_id = b.relationship_id
4577: and c.owner_table_name = 'HZ_PARTIES'
4578: and c.primary_flag='Y'
4579: and c.owner_table_id = b.party_id

Line 5993: FROM HZ_CONTACT_POINTS

5989: ct := ct+1;
5990: END LOOP;
5991: FOR CONTACT_POINTS IN (
5992: SELECT CONTACT_POINT_ID
5993: FROM HZ_CONTACT_POINTS
5994: WHERE PRIMARY_FLAG = 'Y'
5995: AND owner_table_name = 'HZ_PARTIES'
5996: AND owner_table_id = p_party_id
5997:

Line 6001: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

5997:
5998: UNION
5999:
6000: SELECT CONTACT_POINT_ID
6001: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6002: WHERE PRIMARY_FLAG = 'Y'
6003: AND owner_table_name = 'HZ_PARTIES'
6004: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
6005: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 6014: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

6010: AND ROWNUM<6
6011: UNION
6012:
6013: SELECT CONTACT_POINT_ID
6014: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6015: WHERE PRIMARY_FLAG = 'Y'
6016: AND owner_table_name = 'HZ_PARTY_SITES'
6017: AND owner_table_id = party_site_id
6018: AND PARTY_ID = p_party_id

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

6269:
6270: -- Cursor to fetch primary contact points for party
6271: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
6272: SELECT contact_point_id, contact_point_type
6273: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
6274: ,translate(HZ_CONTACT_POINTS.URL, '%',' ')
6275: FROM HZ_CONTACT_POINTS
6276: WHERE contact_point_id = cp_contact_point_id;
6277:

Line 6274: ,translate(HZ_CONTACT_POINTS.URL, '%',' ')

6270: -- Cursor to fetch primary contact points for party
6271: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
6272: SELECT contact_point_id, contact_point_type
6273: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
6274: ,translate(HZ_CONTACT_POINTS.URL, '%',' ')
6275: FROM HZ_CONTACT_POINTS
6276: WHERE contact_point_id = cp_contact_point_id;
6277:
6278: I NUMBER;

Line 6275: FROM HZ_CONTACT_POINTS

6271: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
6272: SELECT contact_point_id, contact_point_type
6273: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
6274: ,translate(HZ_CONTACT_POINTS.URL, '%',' ')
6275: FROM HZ_CONTACT_POINTS
6276: WHERE contact_point_id = cp_contact_point_id;
6277:
6278: I NUMBER;
6279: l_contact_point_id NUMBER;