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.

[Home] [Help]

APPS.WF_ROLE_HIERARCHY dependencies on WF_ROLE_HIERARCHY

Line 1: PACKAGE BODY WF_ROLE_HIERARCHY as

1: PACKAGE BODY WF_ROLE_HIERARCHY as
2: /*$Header: WFRHIERB.pls 120.35.12020000.2 2012/07/12 19:50:22 alsosa ship $*/
3:
4: ----
5: -- Private Globals

Line 74: WF_CORE.Context('WF_ROLE_HIERARCHY', 'RaiseEvent', p_eventName,

70: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
71: g_modulePkg||'.RaiseEvent',
72: 'Exception: '||sqlerrm);
73: end if;
74: WF_CORE.Context('WF_ROLE_HIERARCHY', 'RaiseEvent', p_eventName,
75: p_relationshipID, p_superName, p_subName);
76: raise;
77: end RaiseEvent;
78:

Line 167: WF_CORE.Context('WF_ROLE_HIERARCHY', 'HierarchyEnabled', p_origSystem);

163: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
164: g_modulePkg||'.HierarchyEnabled',
165: 'Exception: '||sqlerrm);
166: end if;
167: WF_CORE.Context('WF_ROLE_HIERARCHY', 'HierarchyEnabled', p_origSystem);
168: raise;
169:
170: end HierarchyEnabled;
171:

Line 256: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Calculate_Effective_Dates',

252: g_modulePkg||'.Calculate_Effective_Dates',
253: 'Exception: '||sqlerrm);
254: end if;
255:
256: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Calculate_Effective_Dates',
257: to_char(p_startDate,WF_CORE.canonical_date_mask),
258: to_char(p_endDate,WF_CORE.canonical_date_mask),
259: to_char(p_userStartDate,WF_CORE.canonical_date_mask),
260: to_char(p_userEndDate,WF_CORE.canonical_date_mask),

Line 382: l_subordinates WF_ROLE_HIERARCHY.relTAB;

378: TYPE dateTab IS TABLE OF DATE INDEX BY BINARY_INTEGER;
379: TYPE idTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
380:
381:
382: l_subordinates WF_ROLE_HIERARCHY.relTAB;
383: l_superiors WF_ROLE_HIERARCHY.relTAB;
384: l_rowIDTAB idTab;
385: l_roleStartTAB dateTab;
386: l_roleEndTAB dateTab;

Line 383: l_superiors WF_ROLE_HIERARCHY.relTAB;

379: TYPE idTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
380:
381:
382: l_subordinates WF_ROLE_HIERARCHY.relTAB;
383: l_superiors WF_ROLE_HIERARCHY.relTAB;
384: l_rowIDTAB idTab;
385: l_roleStartTAB dateTab;
386: l_roleEndTAB dateTab;
387: l_effStartTAB dateTab;

Line 640: WF_ROLE_HIERARCHY.Calculate_Effective_Dates

636: end if;
637:
638: -- Bug 8337430, a self reference.
639: if (l_UserName = l_RoleName) then
640: WF_ROLE_HIERARCHY.Calculate_Effective_Dates
641: (l_StartDate, l_EndDate, l_StartDate, l_EndDate, l_StartDate, l_EndDate,
642: null, null, l_effStartDate, l_effEndDate);
643: update WF_USER_ROLE_ASSIGNMENTS
644: set USER_START_DATE = l_StartDate,

Line 970: WF_CORE.Context('WF_ROLE_HIERARCHY','Cascade_RF',

966: assignment_type=>'X',
967: updateWho=>UpdateWho);
968:
969: else
970: WF_CORE.Context('WF_ROLE_HIERARCHY','Cascade_RF',
971: p_event.getEventName( ), p_sub_guid);
972:
973: WF_EVENT.setErrorInfo(p_event, 'ERROR');
974:

Line 1850: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Denormalize_UR_Assignments',

1846: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
1847: g_modulePkg||'.Denormalize_UR_Assignments',
1848: 'Exception: '||sqlerrm);
1849: end if;
1850: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Denormalize_UR_Assignments',
1851: p_event.getEventName);
1852: raise;
1853:
1854:

Line 2334: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Aggregate_User_Roles_RF',

2330: elsif c_UserRoleAssignments_r%ISOPEN then
2331: close c_UserRoleAssignments_r;
2332: end if;
2333:
2334: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Aggregate_User_Roles_RF',
2335: p_event.getEventName( ), p_sub_guid);
2336:
2337: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2338: return 'ERROR';

Line 2356: -- p_superiors (WF_ROLE_HIERARCHY.relTAB)

2352: -- GetRelationships (PUBLIC)
2353: -- Retrieves the hierarchies for a given role.
2354: -- IN
2355: -- p_name (VARCHAR2)
2356: -- p_superiors (WF_ROLE_HIERARCHY.relTAB)
2357: -- p_subordinates (WF_ROLE_HIERARCHY.relTAB)
2358:
2359: procedure GetRelationships (p_name in VARCHAR2,
2360: p_superiors out NOCOPY WF_ROLE_HIERARCHY.relTAB,

Line 2357: -- p_subordinates (WF_ROLE_HIERARCHY.relTAB)

2353: -- Retrieves the hierarchies for a given role.
2354: -- IN
2355: -- p_name (VARCHAR2)
2356: -- p_superiors (WF_ROLE_HIERARCHY.relTAB)
2357: -- p_subordinates (WF_ROLE_HIERARCHY.relTAB)
2358:
2359: procedure GetRelationships (p_name in VARCHAR2,
2360: p_superiors out NOCOPY WF_ROLE_HIERARCHY.relTAB,
2361: p_subordinates out NOCOPY WF_ROLE_HIERARCHY.relTAB,

Line 2360: p_superiors out NOCOPY WF_ROLE_HIERARCHY.relTAB,

2356: -- p_superiors (WF_ROLE_HIERARCHY.relTAB)
2357: -- p_subordinates (WF_ROLE_HIERARCHY.relTAB)
2358:
2359: procedure GetRelationships (p_name in VARCHAR2,
2360: p_superiors out NOCOPY WF_ROLE_HIERARCHY.relTAB,
2361: p_subordinates out NOCOPY WF_ROLE_HIERARCHY.relTAB,
2362: p_direction in VARCHAR2 )
2363: is
2364:

Line 2361: p_subordinates out NOCOPY WF_ROLE_HIERARCHY.relTAB,

2357: -- p_subordinates (WF_ROLE_HIERARCHY.relTAB)
2358:
2359: procedure GetRelationships (p_name in VARCHAR2,
2360: p_superiors out NOCOPY WF_ROLE_HIERARCHY.relTAB,
2361: p_subordinates out NOCOPY WF_ROLE_HIERARCHY.relTAB,
2362: p_direction in VARCHAR2 )
2363: is
2364:
2365: begin

Line 2420: WF_CORE.Context('WF_ROLE_HIERARCHY', 'GetRelationships', p_name);

2416: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
2417: g_modulePkg||'.GetRelationships', 'Exception: '||
2418: sqlerrm);
2419: end if;
2420: WF_CORE.Context('WF_ROLE_HIERARCHY', 'GetRelationships', p_name);
2421: raise;
2422:
2423: end GetRelationships;
2424:

Line 2430: -- p_superiors (WF_ROLE_HIERARCHY.relTAB)

2426: -- GetAllRelationships (PUBLIC)
2427: -- Retrieves both enabled and disabled hierarchies for a given role..
2428: -- IN
2429: -- p_name (VARCHAR2)
2430: -- p_superiors (WF_ROLE_HIERARCHY.relTAB)
2431: -- p_subordinates (WF_ROLE_HIERARCHY.relTAB)
2432:
2433: procedure GetAllRelationships (p_name in VARCHAR2,
2434: p_superiors out NOCOPY WF_ROLE_HIERARCHY.relTAB,

Line 2431: -- p_subordinates (WF_ROLE_HIERARCHY.relTAB)

2427: -- Retrieves both enabled and disabled hierarchies for a given role..
2428: -- IN
2429: -- p_name (VARCHAR2)
2430: -- p_superiors (WF_ROLE_HIERARCHY.relTAB)
2431: -- p_subordinates (WF_ROLE_HIERARCHY.relTAB)
2432:
2433: procedure GetAllRelationships (p_name in VARCHAR2,
2434: p_superiors out NOCOPY WF_ROLE_HIERARCHY.relTAB,
2435: p_subordinates out NOCOPY WF_ROLE_HIERARCHY.relTAB,

Line 2434: p_superiors out NOCOPY WF_ROLE_HIERARCHY.relTAB,

2430: -- p_superiors (WF_ROLE_HIERARCHY.relTAB)
2431: -- p_subordinates (WF_ROLE_HIERARCHY.relTAB)
2432:
2433: procedure GetAllRelationships (p_name in VARCHAR2,
2434: p_superiors out NOCOPY WF_ROLE_HIERARCHY.relTAB,
2435: p_subordinates out NOCOPY WF_ROLE_HIERARCHY.relTAB,
2436: p_direction in VARCHAR2)
2437: is
2438: --<8i Support>

Line 2435: p_subordinates out NOCOPY WF_ROLE_HIERARCHY.relTAB,

2431: -- p_subordinates (WF_ROLE_HIERARCHY.relTAB)
2432:
2433: procedure GetAllRelationships (p_name in VARCHAR2,
2434: p_superiors out NOCOPY WF_ROLE_HIERARCHY.relTAB,
2435: p_subordinates out NOCOPY WF_ROLE_HIERARCHY.relTAB,
2436: p_direction in VARCHAR2)
2437: is
2438: --<8i Support>
2439: TYPE super_name_Tab is TABLE of VARCHAR2(320);

Line 2545: WF_CORE.Context('WF_ROLE_HIERARCHY', 'GetAllRelationships', p_name);

2541: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
2542: g_modulePkg||'.GetAllRelationships', 'Exception: '||
2543: sqlerrm);
2544: end if;
2545: WF_CORE.Context('WF_ROLE_HIERARCHY', 'GetAllRelationships', p_name);
2546: raise;
2547:
2548: end GetAllRelationships;
2549:

Line 2570: l_superiors WF_ROLE_HIERARCHY.relTAB;

2566: l_sub_origSys VARCHAR2(30);
2567: l_super_origSys VARCHAR2(30);
2568: l_roleView VARCHAR2(30);
2569:
2570: l_superiors WF_ROLE_HIERARCHY.relTAB;
2571: l_subordinates WF_ROLE_HIERARCHY.relTAB;
2572:
2573: HierarchyLoop EXCEPTION;
2574: pragma exception_init(HierarchyLoop, -01436);

Line 2571: l_subordinates WF_ROLE_HIERARCHY.relTAB;

2567: l_super_origSys VARCHAR2(30);
2568: l_roleView VARCHAR2(30);
2569:
2570: l_superiors WF_ROLE_HIERARCHY.relTAB;
2571: l_subordinates WF_ROLE_HIERARCHY.relTAB;
2572:
2573: HierarchyLoop EXCEPTION;
2574: pragma exception_init(HierarchyLoop, -01436);
2575:

Line 2599: g_trustTimeStamp := WF_ROLE_HIERARCHY.CreateSession;

2595: p_sub_name||', '||p_super_name||')');
2596: end if;
2597: --need to serialize here to prevent potential circular loops
2598:
2599: g_trustTimeStamp := WF_ROLE_HIERARCHY.CreateSession;
2600: -- Validating Roles
2601: begin
2602: begin
2603: SELECT ORIG_SYSTEM, PARTITION_ID

Line 2781: WF_CORE.Context('WF_ROLE_HIERARCHY', 'AddRelationship', p_sub_name,

2777: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
2778: g_modulePkg||'.AddRelationship', 'Exception: '||
2779: sqlerrm);
2780: end if;
2781: WF_CORE.Context('WF_ROLE_HIERARCHY', 'AddRelationship', p_sub_name,
2782: p_super_name);
2783: WF_CORE.Raise('WFDS_HIERARCHY_LOOP');
2784:
2785: when OTHERS then

Line 2791: WF_CORE.Context('WF_ROLE_HIERARCHY', 'AddRelationship', p_sub_name,

2787: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
2788: g_modulePkg||'.AddRelationship', 'Exception: '||
2789: sqlerrm);
2790: end if;
2791: WF_CORE.Context('WF_ROLE_HIERARCHY', 'AddRelationship', p_sub_name,
2792: p_super_name);
2793: raise;
2794: end AddRelationship;
2795:

Line 2877: WF_CORE.Context('WF_ROLE_HIERARCHY', 'ExpireRelationship', p_sub_name,

2873: WF_LOG_PKG.String(WF_LOG_PKG.LEVEL_UNEXPECTED,
2874: g_modulePkg||'.ExpireRelationship', 'Exception: '||
2875: sqlerrm);
2876: end if;
2877: WF_CORE.Context('WF_ROLE_HIERARCHY', 'ExpireRelationship', p_sub_name,
2878: p_super_name);
2879: raise;
2880: end ExpireRelationship;
2881:

Line 2910: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Denormalize_User_Role_RF',

2906:
2907: exception
2908: when OTHERS then
2909:
2910: WF_CORE.Context('WF_ROLE_HIERARCHY', 'Denormalize_User_Role_RF',
2911: p_event.getEventName( ), p_sub_guid);
2912:
2913: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2914: return 'ERROR';

Line 3054: end WF_ROLE_HIERARCHY;

3050: raise;
3051:
3052: end removeRelationship;
3053:
3054: end WF_ROLE_HIERARCHY;