APPS.UMX_ACCESS_ROLES_PVT dependencies on WF_ALL_ROLES_VL

Line 55: l_role_name WF_ALL_ROLES_VL.NAME%TYPE;

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

Line 56: l_role_display_name WF_ALL_ROLES_VL.DISPLAY_NAME%TYPE;

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;
58:
59: cursor find_role_disp_name is select display_name from
60: WF_ALL_ROLES_vl where name = l_role_name;

Line 60: WF_ALL_ROLES_vl where name = l_role_name;

56: l_role_display_name WF_ALL_ROLES_VL.DISPLAY_NAME%TYPE;
57: i number :=1;
58:
59: cursor find_role_disp_name is select display_name from
60: WF_ALL_ROLES_vl where name = l_role_name;
61:
62: begin
63:
64: IF p_role_name IS NULL THEN

Line 107: l_role_name WF_ALL_ROLES_VL.NAME%TYPE;

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

Line 108: l_role_display_name WF_ALL_ROLES_VL.DISPLAY_NAME%TYPE;

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;
110:
111: cursor find_role_disp_name is select display_name from
112: WF_ALL_ROLES_vl where name = l_role_name;

Line 112: WF_ALL_ROLES_vl where name = l_role_name;

108: l_role_display_name WF_ALL_ROLES_VL.DISPLAY_NAME%TYPE;
109: i number :=1;
110:
111: cursor find_role_disp_name is select display_name from
112: WF_ALL_ROLES_vl where name = l_role_name;
113:
114: begin
115:
116: IF p_role_name IS NULL THEN