2661: WF_CORE.Token('NAME', p_super_name);
2662: WF_CORE.Raise('WF_NO_ROLE');
2663: end;
2664:
2665: -- Obtain the relationship_id from WF_ROLE_HIERARCHIES_S.
2666: select WF_ROLE_HIERARCHIES_S.NEXTVAL
2667: into l_RelationshipID
2668: from dual;
2669:
2662: WF_CORE.Raise('WF_NO_ROLE');
2663: end;
2664:
2665: -- Obtain the relationship_id from WF_ROLE_HIERARCHIES_S.
2666: select WF_ROLE_HIERARCHIES_S.NEXTVAL
2667: into l_RelationshipID
2668: from dual;
2669:
2670: -- Perform the insert
2734: g_modulePkg||
2735: '.AddRelationship.Insert.DUP_VAL_ON_INDEX',
2736: 'Updating expired relationship');
2737: end if;
2738: update WF_ROLE_HIERARCHIES set
2739: LAST_UPDATED_BY = WFA_SEC.USER_ID,
2740: LAST_UPDATE_DATE = sysdate,
2741: LAST_UPDATE_LOGIN= WFA_SEC.USER_ID,
2742: ENABLED_FLAG = 'Y',