APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_ORG_CONTACT_ROLES

Line 1241: FROM HZ_ORG_CONTACT_ROLES

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

Line 1247: FROM HZ_ORG_CONTACT_ROLES

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

Line 3116: -- HZ_ORG_CONTACT_ROLES

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

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

3117: IF(p_bus_object.tca_mandated_flag(i) = 'N' AND
3118: p_bus_object.user_mandated_flag(i) = 'Y' AND
3119: p_bus_object.business_object_code(i) = 'ORG_CONTACT' AND
3120: p_bus_object.child_bo_code(i) IS NULL) THEN
3121: IF(p_bus_object.entity_name(i) = 'HZ_ORG_CONTACT_ROLES') THEN
3122: l_ocr := TRUE;
3123: ELSIF(p_bus_object.entity_name(i) = 'HZ_CONTACT_PREFERENCES') THEN
3124: l_cpref := TRUE;
3125: END IF;