procedure GetAllRelationships (p_name in varchar2, p_superiors out WF_ROLE_HIERARCHY.relTAB, p_subordinates out WF_ROLE_HIERARCHY.relTAB, p_direction in VARCHAR2 default 'BOTH');
Retrieves the hierarchical relationships for the specified role and returns a table of superior roles and a table of subordinate roles. GetAllRelationships() retrieves all hierarchical relationships, whether they are enabled or disabled.
| p_name | The internal name of the role. |
| p_direction | Specify 'SUPERIORS' to retrieve superior roles for this role, 'SUBORDINATES' to retrieve subordinate roles for this role, or 'BOTH' to retrieve both superior and subordinate roles. |