APPS.UMX_ACCESS_ROLES_PVT dependencies on WF_ALL_ROLES_VL

Line 47: l_role_name WF_ALL_ROLES_VL.NAME%TYPE;

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;
50:
51: cursor find_role_disp_name is select display_name from

Line 48: l_role_display_name WF_ALL_ROLES_VL.DISPLAY_NAME%TYPE;

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;
50:
51: cursor find_role_disp_name is select display_name from
52: WF_ALL_ROLES_vl where name = l_role_name;

Line 52: WF_ALL_ROLES_vl where name = l_role_name;

48: l_role_display_name WF_ALL_ROLES_VL.DISPLAY_NAME%TYPE;
49: i number :=1;
50:
51: cursor find_role_disp_name is select display_name from
52: WF_ALL_ROLES_vl where name = l_role_name;
53:
54: begin
55:
56: IF p_role_name IS NULL THEN

Line 99: l_role_name WF_ALL_ROLES_VL.NAME%TYPE;

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;
102:
103: cursor find_role_disp_name is select display_name from

Line 100: l_role_display_name WF_ALL_ROLES_VL.DISPLAY_NAME%TYPE;

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;
102:
103: cursor find_role_disp_name is select display_name from
104: WF_ALL_ROLES_vl where name = l_role_name;

Line 104: WF_ALL_ROLES_vl where name = l_role_name;

100: l_role_display_name WF_ALL_ROLES_VL.DISPLAY_NAME%TYPE;
101: i number :=1;
102:
103: cursor find_role_disp_name is select display_name from
104: WF_ALL_ROLES_vl where name = l_role_name;
105:
106: begin
107:
108: IF p_role_name IS NULL THEN