APPS.UMX_ACCESS_ROLES_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 51

cursor find_role_disp_name is select display_name from
WF_ALL_ROLES_vl where name = l_role_name;

Line: 103

cursor find_role_disp_name is select display_name from
WF_ALL_ROLES_vl where name = l_role_name;

Line: 146

PROCEDURE  insert_role(p_role_name        in varchar2,
                         p_orig_system      in varchar2,
                         p_orig_system_id   in number,
                         p_start_date       in date,
                         p_expiration_date  in date,
                         p_display_name     in varchar2,
                         p_owner_tag        in varchar2,
                         p_description      in varchar2) IS

l_params wf_parameter_list_t;

Line: 171

end insert_role;

Line: 173

PROCEDURE  update_role(p_role_name        in varchar2,
                         p_orig_system      in varchar2,
                         p_orig_system_id   in number,
                         p_start_date       in date,
                         p_expiration_date  in date,
                         p_display_name     in varchar2,
                         p_owner_tag        in varchar2,
                         p_description      in varchar2) IS

l_params wf_parameter_list_t;

Line: 191

  WF_EVENT.AddParameterToList(p_name          => 'UPDATEONLY',
                              p_value         => 'TRUE',
                              p_parameterlist => l_params);

Line: 207

end update_role;

Line: 223

select ASSIGNMENT_REASON into reason from wf_local_user_roles
where USER_NAME = p_user_name
and ROLE_NAME = p_role_name ;