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 1123: from WF_ROLE_HIERARCHIES WRH1

1119: --relationships from the active hierarchy leaving the relationship(s)
1120: --that should be expired.
1121: cursor expiredRelationships(p_subName in VARCHAR2) is
1122: select WRH1.RELATIONSHIP_ID REL_ID
1123: from WF_ROLE_HIERARCHIES WRH1
1124: connect by
1125: nocycle prior SUPER_NAME = SUB_NAME
1126: start with SUB_NAME = p_subName
1127: minus

Line 1129: from WF_ROLE_HIERARCHIES WRH2

1125: nocycle prior SUPER_NAME = SUB_NAME
1126: start with SUB_NAME = p_subName
1127: minus
1128: select WRH2.RELATIONSHIP_ID REL_ID
1129: from WF_ROLE_HIERARCHIES WRH2
1130: where ENABLED_FLAG = 'Y'
1131: connect by prior SUPER_NAME = SUB_NAME
1132: and prior ENABLED_FLAG = 'Y'
1133: start with SUB_NAME = p_subName;

Line 1138: from WF_ROLE_HIERARCHIES

1134:
1135: -- Bug 7308460
1136: cursor relationships (p_subName in VARCHAR2, p_superName in VARCHAR2) is
1137: select SUPER_NAME, RELATIONSHIP_ID
1138: from WF_ROLE_HIERARCHIES
1139: where ENABLED_FLAG = 'Y'
1140: connect by
1141: nocycle prior SUPER_NAME = SUB_NAME
1142: and prior ENABLED_FLAG = 'Y'

Line 1149: from WF_ROLE_HIERARCHIES

1145: begin
1146: --Retrieve the relationship
1147: select SUPER_NAME, SUB_NAME, ENABLED_FLAG
1148: into l_superName, l_subName, l_enabledFlag
1149: from WF_ROLE_HIERARCHIES
1150: where RELATIONSHIP_ID = p_relationship_id;
1151:
1152: --Update the propagate timestamp
1153: update WF_ROLE_HIERARCHIES

Line 1153: update WF_ROLE_HIERARCHIES

1149: from WF_ROLE_HIERARCHIES
1150: where RELATIONSHIP_ID = p_relationship_id;
1151:
1152: --Update the propagate timestamp
1153: update WF_ROLE_HIERARCHIES
1154: set PROPAGATE_DATE = p_propagateDate
1155: where RELATIONSHIP_ID = p_relationship_id
1156: and SUPER_NAME = l_superName
1157: and SUB_NAME = l_subName;

Line 1169: from WF_ROLE_HIERARCHIES

1165: --relationships.
1166: --Retrieve the subordinates
1167: select SUB_NAME
1168: bulk collect into l_assignTAB
1169: from WF_ROLE_HIERARCHIES
1170: connect by
1171: nocycle prior SUB_NAME = SUPER_NAME
1172: start with SUPER_NAME = l_superName;
1173:

Line 1547: FROM WF_ROLE_HIERARCHIES

1543: l_propagateDate := sysdate;
1544: if (p_relationship_id = 'ALL') then
1545: SELECT relationship_id
1546: BULK COLLECT INTO relIDTAB
1547: FROM WF_ROLE_HIERARCHIES
1548: WHERE (PROPAGATE_DATE is NULL or
1549: ((PROPAGATE_DATE is NOT NULL) and
1550: (PROPAGATE_DATE < LAST_UPDATE_DATE)));
1551:

Line 2385: FROM WF_ROLE_HIERARCHIES

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

Line 2401: FROM WF_ROLE_HIERARCHIES

2397: end if;
2398: SELECT RELATIONSHIP_ID, SUB_NAME, SUPER_NAME,
2399: ENABLED_FLAG
2400: BULK COLLECT INTO p_subordinates
2401: FROM WF_ROLE_HIERARCHIES
2402: WHERE ENABLED_FLAG = 'Y'
2403: CONNECT BY PRIOR SUB_NAME = SUPER_NAME
2404: START WITH SUPER_NAME = upper(p_name);
2405: end if;

Line 2464: FROM WF_ROLE_HIERARCHIES

2460: if (p_direction in ('SUPERIORS', 'BOTH')) then
2461: SELECT RELATIONSHIP_ID, SUB_NAME, SUPER_NAME,
2462: ENABLED_FLAG
2463: BULK COLLECT INTO relIDTab, subTab, superTab, enabledTab
2464: FROM WF_ROLE_HIERARCHIES
2465: CONNECT BY PRIOR SUPER_NAME = SUB_NAME
2466: START WITH SUB_NAME = upper(p_name);
2467:
2468: if (relIDTab.COUNT > 0) then

Line 2487: FROM WF_ROLE_HIERARCHIES

2483: end if;
2484: SELECT RELATIONSHIP_ID, SUB_NAME, SUPER_NAME,
2485: ENABLED_FLAG
2486: BULK COLLECT INTO relIDTab, subTab, superTab, enabledTab
2487: FROM WF_ROLE_HIERARCHIES
2488: CONNECT BY PRIOR SUB_NAME = SUPER_NAME
2489: START WITH SUPER_NAME = upper(p_name);
2490:
2491: if (relIDTab.COUNT > 0) then

Line 2512: FROM WF_ROLE_HIERARCHIES

2508: end if;
2509: SELECT RELATIONSHIP_ID, SUB_NAME, SUPER_NAME,
2510: ENABLED_FLAG
2511: BULK COLLECT INTO p_superiors
2512: FROM WF_ROLE_HIERARCHIES
2513: CONNECT BY PRIOR SUPER_NAME = SUB_NAME
2514: START WITH SUB_NAME = upper(p_name);
2515: end if;
2516:

Line 2526: FROM WF_ROLE_HIERARCHIES

2522: end if;
2523: SELECT RELATIONSHIP_ID, SUB_NAME, SUPER_NAME,
2524: ENABLED_FLAG
2525: BULK COLLECT INTO p_subordinates
2526: FROM WF_ROLE_HIERARCHIES
2527: CONNECT BY PRIOR SUB_NAME = SUPER_NAME
2528: START WITH SUPER_NAME = upper(p_name);
2529: end if;
2530: end;

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

2547:
2548: end GetAllRelationships;
2549:
2550: -- AddRelationship (PUBLIC)
2551: -- Creates a super/sub role hierarchy relationship in WF_ROLE_HIERARCHIES.
2552: -- IN
2553: -- p_sub_name (VARCHAR2)
2554: -- p_super_name (VARCHAR2)
2555: -- p_deferMode (BOOLEAN)

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

2657: if (p_enabled <> 'Y') then
2658: l_enabled := 'N';
2659: end if;
2660:
2661: insert into WF_ROLE_HIERARCHIES
2662: (RELATIONSHIP_ID,
2663: SUB_NAME,
2664: SUPER_NAME,
2665: CREATED_BY,

Line 2698: from WF_ROLE_HIERARCHIES

2694: '.AddRelationship.Insert.DUP_VAL_ON_INDEX',
2695: 'Updating existing relationship');
2696: end if;
2697: select ENABLED_FLAG into l_enabled_flag
2698: from WF_ROLE_HIERARCHIES
2699: where SUB_NAME = p_sub_name and
2700: SUPER_NAME = p_super_name;
2701: if (l_enabled_flag='Y' and l_enabled='Y') then
2702: --We already encountered a dup_val_on_index and the relationship is

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,

Line 2828: update WF_ROLE_HIERARCHIES

2824: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_STATEMENT,
2825: g_modulePkg||'.ExpireRelationship.Update',
2826: 'Updating record');
2827: end if;
2828: update WF_ROLE_HIERARCHIES
2829: set LAST_UPDATED_BY = WFA_SEC.USER_ID,
2830: LAST_UPDATE_DATE = sysdate,
2831: LAST_UPDATE_LOGIN= WFA_SEC.USER_ID,
2832: ENABLED_FLAG = 'N'

Line 3024: from wf_role_hierarchies

3020: --check the relationship status
3021:
3022: select enabled_flag,sub_name,super_name
3023: into l_enabled, l_subName , l_superName
3024: from wf_role_hierarchies
3025: where relationship_id=p_relationshipID;
3026:
3027: if (l_enabled='Y') then
3028: if (p_forceRemove is null or not p_forceRemove) then

Line 3043: Delete from WF_ROLE_HIERARCHIES

3039: end if;
3040:
3041: --now remove the realtionship from the table
3042:
3043: Delete from WF_ROLE_HIERARCHIES
3044: where relationship_id=p_relationshipID;
3045:
3046:
3047: