Previous	Next		Contents	Index	Glossary

procedure GetRelationships

     (p_name in varchar2, 

      p_superiors out WF_ROLE_HIERARCHY.relTAB, 

      p_subordinates out WF_ROLE_HIERARCHY.relTAB, 

      p_direction in VARCHAR2 default 'BOTH');

Description

Retrieves the hierarchical relationships for the specified role and returns a table of superior roles and a table of subordinate roles. GetRelationships() stops retrieving relationships in a hierarchy when it encounters a disabled relationship.

Arguments (input)

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.