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 4494: from hz_contact_points

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

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

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

Line 5998: FROM HZ_CONTACT_POINTS

5994: ct := ct+1;
5995: END LOOP;
5996: FOR CONTACT_POINTS IN (
5997: SELECT CONTACT_POINT_ID
5998: FROM HZ_CONTACT_POINTS
5999: WHERE PRIMARY_FLAG = 'Y'
6000: AND owner_table_name = 'HZ_PARTIES'
6001: AND owner_table_id = p_party_id
6002:

Line 6006: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS

6002:
6003: UNION
6004:
6005: SELECT CONTACT_POINT_ID
6006: FROM HZ_CONTACT_POINTS,HZ_ORG_CONTACTS, HZ_RELATIONSHIPS
6007: WHERE PRIMARY_FLAG = 'Y'
6008: AND owner_table_name = 'HZ_PARTIES'
6009: AND OWNER_TABLE_ID = HZ_RELATIONSHIPS.party_id
6010: AND HZ_RELATIONSHIPS.object_id = p_party_id

Line 6019: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

6015: AND ROWNUM<6
6016: UNION
6017:
6018: SELECT CONTACT_POINT_ID
6019: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
6020: WHERE PRIMARY_FLAG = 'Y'
6021: AND owner_table_name = 'HZ_PARTY_SITES'
6022: AND owner_table_id = party_site_id
6023: AND PARTY_ID = p_party_id

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

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

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

6275: -- Cursor to fetch primary contact points for party
6276: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
6277: SELECT contact_point_id, contact_point_type
6278: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
6279: ,translate(HZ_CONTACT_POINTS.URL, '%',' ')
6280: FROM HZ_CONTACT_POINTS
6281: WHERE contact_point_id = cp_contact_point_id;
6282:
6283: I NUMBER;

Line 6280: FROM HZ_CONTACT_POINTS

6276: CURSOR c_cpts(cp_contact_point_id NUMBER) IS
6277: SELECT contact_point_id, contact_point_type
6278: ,translate(HZ_CONTACT_POINTS.EMAIL_ADDRESS, '%',' ')
6279: ,translate(HZ_CONTACT_POINTS.URL, '%',' ')
6280: FROM HZ_CONTACT_POINTS
6281: WHERE contact_point_id = cp_contact_point_id;
6282:
6283: I NUMBER;
6284: l_contact_point_id NUMBER;