eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_ROLE_HIERARCHY dependencies on WF_ROLE_HIERARCHIES

Line 143: from WF_ROLE_HIERARCHIES

139: select 'NOBS'
140: into l_viewName
141: from dual
142: where EXISTS (select NULL
143: from WF_ROLE_HIERARCHIES
144: where PARTITION_ID = l_partitionID
145: or SUPERIOR_PARTITION_ID = l_partitionID);
146:
147: l_hierarchyEnabled := TRUE;

Line 1101: from WF_ROLE_HIERARCHIES WRH1

1097: --relationships from the active hierarchy leaving the relationship(s)
1098: --that should be expired.
1099: cursor expiredRelationships(p_subName in VARCHAR2) is
1100: select WRH1.RELATIONSHIP_ID REL_ID
1101: from WF_ROLE_HIERARCHIES WRH1
1102: connect by prior SUPER_NAME = SUB_NAME
1103: start with SUB_NAME = p_subName
1104: minus
1105: select WRH2.RELATIONSHIP_ID REL_ID

Line 1106: from WF_ROLE_HIERARCHIES WRH2

1102: connect by prior SUPER_NAME = SUB_NAME
1103: start with SUB_NAME = p_subName
1104: minus
1105: select WRH2.RELATIONSHIP_ID REL_ID
1106: from WF_ROLE_HIERARCHIES WRH2
1107: where ENABLED_FLAG = 'Y'
1108: connect by prior SUPER_NAME = SUB_NAME
1109: and prior ENABLED_FLAG = 'Y'
1110: start with SUB_NAME = p_subName;

Line 1114: from WF_ROLE_HIERARCHIES

1110: start with SUB_NAME = p_subName;
1111:
1112: cursor relationships (p_subName in VARCHAR2) is
1113: select SUPER_NAME, RELATIONSHIP_ID
1114: from WF_ROLE_HIERARCHIES
1115: where ENABLED_FLAG = 'Y'
1116: connect by prior SUPER_NAME = SUB_NAME
1117: and prior ENABLED_FLAG = 'Y'
1118: start with SUB_NAME = p_subName;

Line 1124: from WF_ROLE_HIERARCHIES

1120: begin
1121: --Retrieve the relationship
1122: select SUPER_NAME, SUB_NAME, ENABLED_FLAG
1123: into l_superName, l_subName, l_enabledFlag
1124: from WF_ROLE_HIERARCHIES
1125: where RELATIONSHIP_ID = p_relationship_id;
1126:
1127: --Update the propagate timestamp
1128: update WF_ROLE_HIERARCHIES

Line 1128: update WF_ROLE_HIERARCHIES

1124: from WF_ROLE_HIERARCHIES
1125: where RELATIONSHIP_ID = p_relationship_id;
1126:
1127: --Update the propagate timestamp
1128: update WF_ROLE_HIERARCHIES
1129: set PROPAGATE_DATE = p_propagateDate
1130: where RELATIONSHIP_ID = p_relationship_id
1131: and SUPER_NAME = l_superName
1132: and SUB_NAME = l_subName;

Line 1144: from WF_ROLE_HIERARCHIES

1140: --relationships.
1141: --Retrieve the subordinates
1142: select SUB_NAME
1143: bulk collect into l_assignTAB
1144: from WF_ROLE_HIERARCHIES
1145: connect by prior SUB_NAME = SUPER_NAME
1146: start with SUPER_NAME = l_superName;
1147:
1148: --Outer loop to traverse down the subordinates in the hierarchy.

Line 1519: FROM WF_ROLE_HIERARCHIES

1515: l_propagateDate := sysdate;
1516: if (p_relationship_id = 'ALL') then
1517: SELECT relationship_id
1518: BULK COLLECT INTO relIDTAB
1519: FROM WF_ROLE_HIERARCHIES
1520: WHERE (PROPAGATE_DATE is NULL or
1521: ((PROPAGATE_DATE is NOT NULL) and
1522: (PROPAGATE_DATE < LAST_UPDATE_DATE)));
1523:

Line 2370: FROM WF_ROLE_HIERARCHIES

2366: end if;
2367: SELECT RELATIONSHIP_ID, SUB_NAME, SUPER_NAME,
2368: ENABLED_FLAG
2369: BULK COLLECT INTO p_superiors
2370: FROM WF_ROLE_HIERARCHIES
2371: WHERE ENABLED_FLAG = 'Y'
2372: CONNECT BY PRIOR SUPER_NAME = SUB_NAME
2373: AND ENABLED_FLAG = 'Y'
2374: START WITH SUB_NAME = upper(p_name);

Line 2387: FROM WF_ROLE_HIERARCHIES

2383: end if;
2384: SELECT RELATIONSHIP_ID, SUB_NAME, SUPER_NAME,
2385: ENABLED_FLAG
2386: BULK COLLECT INTO p_subordinates
2387: FROM WF_ROLE_HIERARCHIES
2388: WHERE ENABLED_FLAG = 'Y'
2389: CONNECT BY PRIOR SUB_NAME = SUPER_NAME
2390: AND ENABLED_FLAG = 'Y'
2391: START WITH SUPER_NAME = upper(p_name);

Line 2405: FROM WF_ROLE_HIERARCHIES

2401: end if;
2402: SELECT RELATIONSHIP_ID, SUB_NAME, SUPER_NAME,
2403: ENABLED_FLAG
2404: BULK COLLECT INTO relIDTab, subTab, superTab, enabledTab
2405: FROM WF_ROLE_HIERARCHIES
2406: WHERE ENABLED_FLAG = 'Y'
2407: CONNECT BY PRIOR SUPER_NAME = SUB_NAME
2408: AND PRIOR ENABLED_FLAG = 'Y'
2409: START WITH SUB_NAME = upper(p_name);

Line 2430: FROM WF_ROLE_HIERARCHIES

2426: end if;
2427: SELECT RELATIONSHIP_ID, SUB_NAME, SUPER_NAME,
2428: ENABLED_FLAG
2429: BULK COLLECT INTO relIDTab, subTab, superTab, enabledTab
2430: FROM WF_ROLE_HIERARCHIES
2431: WHERE ENABLED_FLAG = 'Y'
2432: CONNECT BY PRIOR SUB_NAME = SUPER_NAME
2433: AND PRIOR ENABLED_FLAG = 'Y'
2434: START WITH SUPER_NAME = upper(p_name);

Line 2506: FROM WF_ROLE_HIERARCHIES

2502: if (p_direction in ('SUPERIORS', 'BOTH')) then
2503: SELECT RELATIONSHIP_ID, SUB_NAME, SUPER_NAME,
2504: ENABLED_FLAG
2505: BULK COLLECT INTO relIDTab, subTab, superTab, enabledTab
2506: FROM WF_ROLE_HIERARCHIES
2507: CONNECT BY PRIOR SUPER_NAME = SUB_NAME
2508: START WITH SUB_NAME = upper(p_name);
2509:
2510: if (relIDTab.COUNT > 0) then

Line 2529: FROM WF_ROLE_HIERARCHIES

2525: end if;
2526: SELECT RELATIONSHIP_ID, SUB_NAME, SUPER_NAME,
2527: ENABLED_FLAG
2528: BULK COLLECT INTO relIDTab, subTab, superTab, enabledTab
2529: FROM WF_ROLE_HIERARCHIES
2530: CONNECT BY PRIOR SUB_NAME = SUPER_NAME
2531: START WITH SUPER_NAME = upper(p_name);
2532:
2533: if (relIDTab.COUNT > 0) then

Line 2554: FROM WF_ROLE_HIERARCHIES

2550: end if;
2551: SELECT RELATIONSHIP_ID, SUB_NAME, SUPER_NAME,
2552: ENABLED_FLAG
2553: BULK COLLECT INTO p_superiors
2554: FROM WF_ROLE_HIERARCHIES
2555: CONNECT BY PRIOR SUPER_NAME = SUB_NAME
2556: START WITH SUB_NAME = upper(p_name);
2557: end if;
2558:

Line 2568: FROM WF_ROLE_HIERARCHIES

2564: end if;
2565: SELECT RELATIONSHIP_ID, SUB_NAME, SUPER_NAME,
2566: ENABLED_FLAG
2567: BULK COLLECT INTO p_subordinates
2568: FROM WF_ROLE_HIERARCHIES
2569: CONNECT BY PRIOR SUB_NAME = SUPER_NAME
2570: START WITH SUPER_NAME = upper(p_name);
2571: end if;
2572: end;

Line 2593: -- Creates a super/sub role hierarchy relationship in WF_ROLE_HIERARCHIES.

2589:
2590: end GetAllRelationships;
2591:
2592: -- AddRelationship (PUBLIC)
2593: -- Creates a super/sub role hierarchy relationship in WF_ROLE_HIERARCHIES.
2594: -- IN
2595: -- p_sub_name (VARCHAR2)
2596: -- p_super_name (VARCHAR2)
2597: -- p_deferMode (BOOLEAN)

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 2702: insert into WF_ROLE_HIERARCHIES

2698: if (p_enabled <> 'Y') then
2699: l_enabled := 'N';
2700: end if;
2701:
2702: insert into WF_ROLE_HIERARCHIES
2703: (RELATIONSHIP_ID,
2704: SUB_NAME,
2705: SUPER_NAME,
2706: CREATED_BY,

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

Line 2868: update WF_ROLE_HIERARCHIES

2864: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
2865: g_modulePkg||'.ExpireRelationship.Update',
2866: 'Updating record');
2867: end if;
2868: update WF_ROLE_HIERARCHIES
2869: set LAST_UPDATED_BY = WFA_SEC.USER_ID,
2870: LAST_UPDATE_DATE = sysdate,
2871: LAST_UPDATE_LOGIN= WFA_SEC.USER_ID,
2872: ENABLED_FLAG = 'N'

Line 3064: from wf_role_hierarchies

3060: --check the relationship status
3061:
3062: select enabled_flag,sub_name,super_name
3063: into l_enabled, l_subName , l_superName
3064: from wf_role_hierarchies
3065: where relationship_id=p_relationshipID;
3066:
3067: if (l_enabled='Y') then
3068: if (p_forceRemove is null or not p_forceRemove) then

Line 3083: Delete from WF_ROLE_HIERARCHIES

3079: end if;
3080:
3081: --now remove the realtionship from the table
3082:
3083: Delete from WF_ROLE_HIERARCHIES
3084: where relationship_id=p_relationshipID;
3085:
3086:
3087: