APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_ORG_CONTACT_ROLES

Line 1244: FROM HZ_ORG_CONTACT_ROLES

1240: x_object_version_number OUT NOCOPY NUMBER
1241: ) IS
1242: CURSOR is_org_contact_role_id_exist(l_role_id NUMBER)IS
1243: SELECT nvl(object_version_number,1), org_contact_id
1244: FROM HZ_ORG_CONTACT_ROLES
1245: WHERE org_contact_role_id = l_role_id
1246: AND rownum = 1;
1247:
1248: CURSOR is_org_contact_role_exist(l_org_contact_id NUMBER, l_role_type VARCHAR2)IS

Line 1250: FROM HZ_ORG_CONTACT_ROLES

1246: AND rownum = 1;
1247:
1248: CURSOR is_org_contact_role_exist(l_org_contact_id NUMBER, l_role_type VARCHAR2)IS
1249: SELECT nvl(object_version_number,1), org_contact_role_id
1250: FROM HZ_ORG_CONTACT_ROLES
1251: WHERE org_contact_id = l_org_contact_id
1252: AND role_type = l_role_type
1253: AND status in ('A','I')
1254: AND rownum = 1;

Line 3121: -- HZ_ORG_CONTACT_ROLES

3117: END IF;
3118:
3119: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
3120: -- get all entities of org contact, for org contact, the possible entites are
3121: -- HZ_ORG_CONTACT_ROLES
3122: IF(p_bus_object.tca_mandated_flag(i) = 'N' AND
3123: p_bus_object.user_mandated_flag(i) = 'Y' AND
3124: p_bus_object.business_object_code(i) = 'ORG_CONTACT' AND
3125: p_bus_object.child_bo_code(i) IS NULL) THEN

Line 3126: IF(p_bus_object.entity_name(i) = 'HZ_ORG_CONTACT_ROLES') THEN

3122: IF(p_bus_object.tca_mandated_flag(i) = 'N' AND
3123: p_bus_object.user_mandated_flag(i) = 'Y' AND
3124: p_bus_object.business_object_code(i) = 'ORG_CONTACT' AND
3125: p_bus_object.child_bo_code(i) IS NULL) THEN
3126: IF(p_bus_object.entity_name(i) = 'HZ_ORG_CONTACT_ROLES') THEN
3127: l_ocr := TRUE;
3128: ELSIF(p_bus_object.entity_name(i) = 'HZ_CONTACT_PREFERENCES') THEN
3129: l_cpref := TRUE;
3130: END IF;