APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_ORG_CONTACTS

Line 365: FROM HZ_ORG_CONTACTS

361: AND contact_point_type = l_cp_type;
362:
363: CURSOR is_oc_valid(l_oc_id NUMBER) IS
364: SELECT 'X'
365: FROM HZ_ORG_CONTACTS
366: WHERE org_contact_id = l_oc_id;
367:
368: CURSOR is_pty_valid(l_pty_id NUMBER, l_pty_type VARCHAR2) IS
369: SELECT 'X'

Line 442: ELSIF(p_obj_type = 'HZ_ORG_CONTACTS') THEN

438: IF(p_obj_type in ('PHONE','TLX','EMAIL','WEB','EFT','EDI','SMS')) THEN
439: OPEN is_cp_valid(px_id, p_obj_type);
440: FETCH is_cp_valid INTO l_valid_id;
441: CLOSE is_cp_valid;
442: ELSIF(p_obj_type = 'HZ_ORG_CONTACTS') THEN
443: OPEN is_oc_valid(px_id);
444: FETCH is_oc_valid INTO l_valid_id;
445: CLOSE is_oc_valid;
446: ELSIF(p_obj_type in ('PERSON','ORGANIZATION','PARTY_RELATIONSHIP')) THEN

Line 1985: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r

1981: WHERE party_id = l_party_id;
1982:
1983: CURSOR is_org_contact_exist(l_org_contact_id NUMBER) IS
1984: SELECT r.object_id
1985: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
1986: WHERE oc.org_contact_id = l_org_contact_id
1987: AND oc.party_relationship_id = r.relationship_id
1988: AND r.object_type = 'ORGANIZATION'
1989: AND r.subject_type = 'PERSON'

Line 2067: ELSIF(p_entity_type = 'HZ_ORG_CONTACTS') THEN

2063: ELSIF(p_entity_type = 'HZ_PARTIES') THEN
2064: OPEN is_party_exist(p_entity_id);
2065: FETCH is_party_exist INTO l_dummy;
2066: CLOSE is_party_exist;
2067: ELSIF(p_entity_type = 'HZ_ORG_CONTACTS') THEN
2068: OPEN is_org_contact_exist(p_entity_id);
2069: FETCH is_org_contact_exist INTO l_parent_id;
2070: CLOSE is_org_contact_exist;
2071: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id) THEN