APPS.UMX_ACCESS_ROLES_PVT SQL Statements

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

Line: 59

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

Line: 111

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

Line: 154

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: 179

end insert_role;

Line: 181

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: 199

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

Line: 215

end update_role;