294: x_return_status IN OUT NOCOPY VARCHAR2
295: ) IS
296:
297: -- this cursor will uniquely identify a record
298: -- in hz_relationship_types package
299: CURSOR c_rel_type
300: IS
301: SELECT RELATIONSHIP_TYPE,
302: FORWARD_REL_CODE,
307: ALLOW_CIRCULAR_RELATIONSHIPS,
308: DIRECTION_CODE,
309: RELATIONSHIP_TYPE_ID,
310: MULTIPLE_PARENT_ALLOWED
311: FROM HZ_RELATIONSHIP_TYPES
312: WHERE RELATIONSHIP_TYPE = p_relationship_rec.relationship_type
313: AND FORWARD_REL_CODE = p_relationship_rec.relationship_code
314: AND SUBJECT_TYPE = p_relationship_rec.subject_type
315: AND OBJECT_TYPE = p_relationship_rec.object_type