Skip Headers

Oracle Workflow API Reference
Release 2.6.3.5

Part Number B12163-02
Previous Next       Contents Index Glossary
         Previous  Next          Contents  Index  Glossary

GetAllRelationships

Syntax

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');

Description

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.

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.


         Previous  Next          Contents  Index  Glossary



Oracle Logo
Copyright © 2003, 2004, Oracle. All rights reserved.