APPS.WF_ROLE_HIERARCHY dependencies on WF_ROLE_HIERARCHIES_S

Line 2624: -- Obtain the relationship_id from WF_ROLE_HIERARCHIES_S.

2620: WF_CORE.Token('NAME', p_super_name);
2621: WF_CORE.Raise('WF_NO_ROLE');
2622: end;
2623:
2624: -- Obtain the relationship_id from WF_ROLE_HIERARCHIES_S.
2625: select WF_ROLE_HIERARCHIES_S.NEXTVAL
2626: into l_RelationshipID
2627: from dual;
2628:

Line 2625: select WF_ROLE_HIERARCHIES_S.NEXTVAL

2621: WF_CORE.Raise('WF_NO_ROLE');
2622: end;
2623:
2624: -- Obtain the relationship_id from WF_ROLE_HIERARCHIES_S.
2625: select WF_ROLE_HIERARCHIES_S.NEXTVAL
2626: into l_RelationshipID
2627: from dual;
2628:
2629: -- Perform the insert

Line 2714: update WF_ROLE_HIERARCHIES set

2710: WF_CORE.Token('P_SUPER_NAME', p_super_name);
2711: WF_CORE.Raise('WFDS_DUP_HIERARCHY');
2712: end if;
2713: -- If we are here then the ENABLED_FLAG is being changed, so we update
2714: update WF_ROLE_HIERARCHIES set
2715: LAST_UPDATED_BY = WFA_SEC.USER_ID,
2716: LAST_UPDATE_DATE = sysdate,
2717: LAST_UPDATE_LOGIN= WFA_SEC.USER_ID,
2718: ENABLED_FLAG = l_enabled,