Previous	Next		Contents	Index	Glossary

function AddRelationship

     (p_sub_name in varchar2,

      p_super_name in varchar2,

      p_deferMode in boolean default FALSE,

      p_enabled in varchar2 default 'Y')

     return number;

Description

Creates a hierarchical relationship between two roles in the WF_ROLE_HIERARCHIES table and returns the relationship ID.

Arguments (input)

p_sub_name	The internal name of the subordinate role.
p_super_name	The internal name of the superior role.
p_deferMode	Specify TRUE or FALSE to determine whether to defer propagation of the new relationship. If you specify FALSE, existing user and role assignments are updated according to the new relationship, without deferral.
p_enabled	Specify 'Y' if the relationship is initially enabled or 'N' if the relationship is initially disabled.