APPS.HZ_HIERARCHY_PUB dependencies on HZ_RELATIONSHIP_TYPES

Line 1936: FROM HZ_RELATIONSHIP_TYPES

1932: p_subject_type VARCHAR2,
1933: p_object_type VARCHAR2)
1934: IS
1935: SELECT *
1936: FROM HZ_RELATIONSHIP_TYPES
1937: WHERE RELATIONSHIP_TYPE = p_rel_type
1938: AND FORWARD_REL_CODE = p_forward_rel_code
1939: AND SUBJECT_TYPE = p_subject_type
1940: AND OBJECT_TYPE = p_object_type;

Line 2160: UPDATE HZ_RELATIONSHIP_TYPES

2156: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2157: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Conversion of relationship type to hierarchical failed. ');
2158: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2159: ELSE
2160: UPDATE HZ_RELATIONSHIP_TYPES
2161: SET HIERARCHICAL_FLAG = 'Y',
2162: MULTIPLE_PARENT_ALLOWED = NVL(p_multi_parent_allowed, 'N'),
2163: INCL_UNRELATED_ENTITIES = NVL(p_incl_unrelated_entities, 'N')
2164: WHERE RELATIONSHIP_TYPE = p_rel_type;