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 1980: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r

1976: WHERE party_id = l_party_id;
1977:
1978: CURSOR is_org_contact_exist(l_org_contact_id NUMBER) IS
1979: SELECT r.object_id
1980: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
1981: WHERE oc.org_contact_id = l_org_contact_id
1982: AND oc.party_relationship_id = r.relationship_id
1983: AND r.object_type = 'ORGANIZATION'
1984: AND r.subject_type = 'PERSON'

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

2058: ELSIF(p_entity_type = 'HZ_PARTIES') THEN
2059: OPEN is_party_exist(p_entity_id);
2060: FETCH is_party_exist INTO l_dummy;
2061: CLOSE is_party_exist;
2062: ELSIF(p_entity_type = 'HZ_ORG_CONTACTS') THEN
2063: OPEN is_org_contact_exist(p_entity_id);
2064: FETCH is_org_contact_exist INTO l_parent_id;
2065: CLOSE is_org_contact_exist;
2066: IF(l_parent_id IS NULL OR l_parent_id <> p_parent_id) THEN