APPS.UMX_ACCESS_ROLES_PVT dependencies on WF_ROLE_HIERARCHY

Line 52: l_superiors WF_ROLE_HIERARCHY.relTAB;

48: end populateRecord;
49:
50: function getParentRoles(p_role_name varchar2) return varchar2 is
51:
52: l_superiors WF_ROLE_HIERARCHY.relTAB;
53: l_subordinates WF_ROLE_HIERARCHY.relTAB;
54: length_sup number :=0;
55: l_role_name WF_ALL_ROLES_VL.NAME%TYPE;
56: l_role_display_name WF_ALL_ROLES_VL.DISPLAY_NAME%TYPE;

Line 53: l_subordinates WF_ROLE_HIERARCHY.relTAB;

49:
50: function getParentRoles(p_role_name varchar2) return varchar2 is
51:
52: l_superiors WF_ROLE_HIERARCHY.relTAB;
53: l_subordinates WF_ROLE_HIERARCHY.relTAB;
54: length_sup number :=0;
55: l_role_name WF_ALL_ROLES_VL.NAME%TYPE;
56: l_role_display_name WF_ALL_ROLES_VL.DISPLAY_NAME%TYPE;
57: i number :=1;

Line 68: WF_ROLE_HIERARCHY.GetRelationships(p_name => p_role_name,

64: IF p_role_name IS NULL THEN
65: RETURN NULL;
66: END IF;
67:
68: WF_ROLE_HIERARCHY.GetRelationships(p_name => p_role_name,
69: p_superiors => l_superiors,
70: p_subordinates => l_subordinates);
71:
72: length_sup := l_superiors.count;

Line 104: l_superiors WF_ROLE_HIERARCHY.relTAB;

100: end getParentRoles;
101:
102: function getAffectedRoles(p_role_name varchar2) return varchar2 is
103:
104: l_superiors WF_ROLE_HIERARCHY.relTAB;
105: l_subordinates WF_ROLE_HIERARCHY.relTAB;
106: length_sup number :=0;
107: l_role_name WF_ALL_ROLES_VL.NAME%TYPE;
108: l_role_display_name WF_ALL_ROLES_VL.DISPLAY_NAME%TYPE;

Line 105: l_subordinates WF_ROLE_HIERARCHY.relTAB;

101:
102: function getAffectedRoles(p_role_name varchar2) return varchar2 is
103:
104: l_superiors WF_ROLE_HIERARCHY.relTAB;
105: l_subordinates WF_ROLE_HIERARCHY.relTAB;
106: length_sup number :=0;
107: l_role_name WF_ALL_ROLES_VL.NAME%TYPE;
108: l_role_display_name WF_ALL_ROLES_VL.DISPLAY_NAME%TYPE;
109: i number :=1;

Line 120: WF_ROLE_HIERARCHY.GetRelationships(p_name => p_role_name,

116: IF p_role_name IS NULL THEN
117: RETURN NULL;
118: END IF;
119:
120: WF_ROLE_HIERARCHY.GetRelationships(p_name => p_role_name,
121: p_superiors => l_superiors,
122: p_subordinates => l_subordinates);
123:
124: length_sup := l_subordinates.count;

Line 263: -- Wrapper on top of WF_ROLE_HIERARCHY.HierarchyEnabled

259: -- RETURNS
260: -- 'Y' - if orig system is hierarchy enabled, 'N' otherwise
261: --
262: -- NOTES
263: -- Wrapper on top of WF_ROLE_HIERARCHY.HierarchyEnabled
264: --
265: function HierarchyEnabled (p_origSystem in VARCHAR2) return varchar2
266: is
267: l_result boolean;

Line 276: l_result := WF_ROLE_HIERARCHY.HierarchyEnabled( p_origSystem);

272: if( (p_origSystem = 'UMX') or ( p_origSystem = 'FND_RESP' ) ) then
273: return 'Y';
274: end if;
275:
276: l_result := WF_ROLE_HIERARCHY.HierarchyEnabled( p_origSystem);
277:
278: if( l_result = TRUE ) then
279: return 'Y';
280: else