APPS.UMX_ACCESS_ROLES_PVT dependencies on WF_ROLE_HIERARCHY

Line 44: l_superiors WF_ROLE_HIERARCHY.relTAB;

40: end populateRecord;
41:
42: function getParentRoles(p_role_name varchar2) return varchar2 is
43:
44: l_superiors WF_ROLE_HIERARCHY.relTAB;
45: l_subordinates WF_ROLE_HIERARCHY.relTAB;
46: length_sup number :=0;
47: l_role_name WF_ALL_ROLES_VL.NAME%TYPE;
48: l_role_display_name WF_ALL_ROLES_VL.DISPLAY_NAME%TYPE;

Line 45: l_subordinates WF_ROLE_HIERARCHY.relTAB;

41:
42: function getParentRoles(p_role_name varchar2) return varchar2 is
43:
44: l_superiors WF_ROLE_HIERARCHY.relTAB;
45: l_subordinates WF_ROLE_HIERARCHY.relTAB;
46: length_sup number :=0;
47: l_role_name WF_ALL_ROLES_VL.NAME%TYPE;
48: l_role_display_name WF_ALL_ROLES_VL.DISPLAY_NAME%TYPE;
49: i number :=1;

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

56: IF p_role_name IS NULL THEN
57: RETURN NULL;
58: END IF;
59:
60: WF_ROLE_HIERARCHY.GetRelationships(p_name => p_role_name,
61: p_superiors => l_superiors,
62: p_subordinates => l_subordinates);
63:
64: length_sup := l_superiors.count;

Line 96: l_superiors WF_ROLE_HIERARCHY.relTAB;

92: end getParentRoles;
93:
94: function getAffectedRoles(p_role_name varchar2) return varchar2 is
95:
96: l_superiors WF_ROLE_HIERARCHY.relTAB;
97: l_subordinates WF_ROLE_HIERARCHY.relTAB;
98: length_sup number :=0;
99: l_role_name WF_ALL_ROLES_VL.NAME%TYPE;
100: l_role_display_name WF_ALL_ROLES_VL.DISPLAY_NAME%TYPE;

Line 97: l_subordinates WF_ROLE_HIERARCHY.relTAB;

93:
94: function getAffectedRoles(p_role_name varchar2) return varchar2 is
95:
96: l_superiors WF_ROLE_HIERARCHY.relTAB;
97: l_subordinates WF_ROLE_HIERARCHY.relTAB;
98: length_sup number :=0;
99: l_role_name WF_ALL_ROLES_VL.NAME%TYPE;
100: l_role_display_name WF_ALL_ROLES_VL.DISPLAY_NAME%TYPE;
101: i number :=1;

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

108: IF p_role_name IS NULL THEN
109: RETURN NULL;
110: END IF;
111:
112: WF_ROLE_HIERARCHY.GetRelationships(p_name => p_role_name,
113: p_superiors => l_superiors,
114: p_subordinates => l_subordinates);
115:
116: length_sup := l_subordinates.count;

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

244: -- RETURNS
245: -- 'Y' - if orig system is hierarchy enabled, 'N' otherwise
246: --
247: -- NOTES
248: -- Wrapper on top of WF_ROLE_HIERARCHY.HierarchyEnabled
249: --
250: function HierarchyEnabled (p_origSystem in VARCHAR2) return varchar2
251: is
252: l_result boolean;

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

257: if( (p_origSystem = 'UMX') or ( p_origSystem = 'FND_RESP' ) ) then
258: return 'Y';
259: end if;
260:
261: l_result := WF_ROLE_HIERARCHY.HierarchyEnabled( p_origSystem);
262:
263: if( l_result = TRUE ) then
264: return 'Y';
265: else