DBA Data[Home] [Help]

APPS.WF_ROLE_HIERARCHY dependencies on WF_ROLE_HIERARCHIES_S

Line 2665: -- Obtain the relationship_id from WF_ROLE_HIERARCHIES_S.

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:

Line 2666: select WF_ROLE_HIERARCHIES_S.NEXTVAL

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

Line 2738: update WF_ROLE_HIERARCHIES set

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',