APPS.FND_FUNCTION_SECURITY_CACHE SQL Statements

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

Line: 12

procedure delete_function(p_function_id in number)
is
l_parameters wf_parameter_list_t := wf_parameter_list_t();

Line: 20

  raise_event(p_event_name=>'oracle.apps.fnd.function.delete',
    p_event_key=>to_char(p_function_id));

Line: 24

procedure insert_function(p_function_id in number)
is
l_parameters wf_parameter_list_t := wf_parameter_list_t();

Line: 32

  raise_event(p_event_name=>'oracle.apps.fnd.function.insert',
    p_event_key=>to_char(p_function_id),
    p_parameters => l_parameters);

Line: 37

procedure update_function(p_function_id in number)
is
l_parameters wf_parameter_list_t := wf_parameter_list_t();

Line: 46

  raise_event(p_event_name=>'oracle.apps.fnd.function.update',
    p_event_key=>to_char(p_function_id),
    p_parameters => l_parameters);

Line: 51

procedure delete_grant(p_grant_guid in raw, p_grantee_type in varchar2,
  p_grantee_key in varchar2)
is
l_parameters wf_parameter_list_t := wf_parameter_list_t();

Line: 69

  raise_event(p_event_name=>'oracle.apps.fnd.grant.delete',
    p_event_key=>p_grant_guid||':'||p_grantee_type||':'||p_grantee_key,
    p_parameters => l_parameters);

Line: 74

procedure insert_grant(p_grant_guid in raw, p_grantee_type in varchar2,
  p_grantee_key in varchar2)
is
l_parameters wf_parameter_list_t := wf_parameter_list_t();

Line: 92

  raise_event(p_event_name=>'oracle.apps.fnd.grant.insert',
    p_event_key=>p_grant_guid||':'||p_grantee_type||':'||p_grantee_key,
    p_parameters => l_parameters);

Line: 97

procedure update_grant(p_grant_guid in raw, p_grantee_type in varchar2,
  p_grantee_key in varchar2)
is
l_parameters wf_parameter_list_t := wf_parameter_list_t();

Line: 115

  raise_event(p_event_name=>'oracle.apps.fnd.grant.update',
    p_event_key=>p_grant_guid||':'||p_grantee_type||':'||p_grantee_key,
    p_parameters => l_parameters);

Line: 120

procedure delete_menu(p_menu_id in number)
is
l_parameters wf_parameter_list_t := wf_parameter_list_t();

Line: 129

  raise_event(p_event_name=>'oracle.apps.fnd.menu.delete',
    p_event_key=>to_char(p_menu_id),
    p_parameters => l_parameters);

Line: 134

procedure insert_menu(p_menu_id in number)
is
l_parameters wf_parameter_list_t := wf_parameter_list_t();

Line: 142

  raise_event(p_event_name=>'oracle.apps.fnd.menu.insert',
    p_event_key=>to_char(p_menu_id),
    p_parameters => l_parameters);

Line: 147

procedure update_menu(p_menu_id in number)
is
 l_parameters wf_parameter_list_t := wf_parameter_list_t();

Line: 156

  raise_event(p_event_name=>'oracle.apps.fnd.menu.update',
    p_event_key=>to_char(p_menu_id),
    p_parameters => l_parameters);

Line: 161

procedure delete_menu_entry(p_menu_id in number, p_sub_menu_id in number,
  p_function_id in number)
is
l_parameters wf_parameter_list_t := wf_parameter_list_t();

Line: 166

  update_menu(p_menu_id);

Line: 181

  raise_event(p_event_name=>'oracle.apps.fnd.menu.entry.delete',
    p_event_key=>to_char(p_menu_id)||':'||to_char(p_sub_menu_id)||':'||
      to_char(p_function_id),
      p_parameters => l_parameters);

Line: 187

procedure insert_menu_entry(p_menu_id in number, p_sub_menu_id in number,
  p_function_id in number)
is
l_parameters wf_parameter_list_t := wf_parameter_list_t();

Line: 192

  update_menu(p_menu_id);

Line: 206

  raise_event(p_event_name=>'oracle.apps.fnd.menu.entry.insert',
    p_event_key=>to_char(p_menu_id)||':'||to_char(p_sub_menu_id)||':'||
      to_char(p_function_id),
      p_parameters => l_parameters);

Line: 212

procedure update_menu_entry(p_menu_id in number, p_sub_menu_id in number,
  p_function_id in number)
is
l_parameters wf_parameter_list_t := wf_parameter_list_t();

Line: 217

  update_menu(p_menu_id);

Line: 231

  raise_event(p_event_name=>'oracle.apps.fnd.menu.entry.update',
    p_event_key=>to_char(p_menu_id)||':'||to_char(p_sub_menu_id)||':'||
      to_char(p_function_id),
      p_parameters => l_parameters);

Line: 237

procedure delete_resp(p_resp_id in number, p_resp_appl_id in number)
is
l_parameters wf_parameter_list_t := wf_parameter_list_t();

Line: 250

  raise_event(p_event_name=>'oracle.apps.fnd.resp.delete',
    p_event_key=>p_resp_id||':'||p_resp_appl_id,
    p_parameters => l_parameters);

Line: 255

procedure insert_resp(p_resp_id in number, p_resp_appl_id in number)
is
l_parameters wf_parameter_list_t := wf_parameter_list_t();

Line: 268

  raise_event(p_event_name=>'oracle.apps.fnd.resp.insert',
    p_event_key=>p_resp_id||':'||p_resp_appl_id,
    p_parameters => l_parameters);

Line: 273

procedure update_resp(p_resp_id in number, p_resp_appl_id in number)
is
l_parameters wf_parameter_list_t := wf_parameter_list_t();

Line: 286

  raise_event(p_event_name=>'oracle.apps.fnd.resp.update',
    p_event_key=>p_resp_id||':'||p_resp_appl_id,
    p_parameters => l_parameters);

Line: 291

procedure delete_secgrp(p_security_group_id in number)
is
l_parameters wf_parameter_list_t := wf_parameter_list_t();

Line: 300

  raise_event(p_event_name=>'oracle.apps.fnd.secgrp.delete',
    p_event_key=>to_char(p_security_group_id),
    p_parameters => l_parameters);

Line: 305

procedure insert_secgrp(p_security_group_id in number)
is
l_parameters wf_parameter_list_t := wf_parameter_list_t();

Line: 313

  raise_event(p_event_name=>'oracle.apps.fnd.secgrp.insert',
    p_event_key=>to_char(p_security_group_id),
    p_parameters => l_parameters);

Line: 318

procedure update_secgrp(p_security_group_id in number)
is
l_parameters wf_parameter_list_t := wf_parameter_list_t();

Line: 327

  raise_event(p_event_name=>'oracle.apps.fnd.secgrp.update',
    p_event_key=>to_char(p_security_group_id),
    p_parameters => l_parameters);

Line: 332

procedure delete_user(p_user_id in number)
is
l_parameters wf_parameter_list_t := wf_parameter_list_t();

Line: 340

  raise_event(p_event_name=>'oracle.apps.fnd.user.delete',
    p_event_key=>to_char(p_user_id),
    p_parameters => l_parameters);

Line: 345

procedure insert_user(p_user_id in number)
is
l_parameters wf_parameter_list_t := wf_parameter_list_t();

Line: 349

  raise_event(p_event_name=>'oracle.apps.fnd.user.insert',
    p_event_key=>to_char(p_user_id),
    p_parameters => l_parameters);

Line: 354

procedure update_user(p_user_id in number)
is
l_parameters wf_parameter_list_t := wf_parameter_list_t();

Line: 363

  raise_event(p_event_name=>'oracle.apps.fnd.user.update',
    p_event_key=>to_char(p_user_id),
    p_parameters => l_parameters);

Line: 368

procedure delete_user_resp(p_user_id in number, p_resp_id in number,
  p_resp_appl_id in number)
is
begin
  return;

Line: 375

procedure insert_user_resp(p_user_id in number, p_resp_id in number,
  p_resp_appl_id in number)
is
begin
 return;

Line: 382

procedure update_user_resp(p_user_id in number, p_resp_id in number,
  p_resp_appl_id in number)
is
begin
 return;

Line: 389

procedure delete_user_role(p_user_id in number, p_role_name in varchar2)
is
l_parameters wf_parameter_list_t := wf_parameter_list_t();

Line: 402

  raise_event(p_event_name=>'oracle.apps.fnd.user.role.delete',
    p_event_key=>to_char(p_user_id)||':'||p_role_name,
    p_parameters => l_parameters);

Line: 407

procedure insert_user_role(p_user_id in number, p_role_name in varchar2)
is
l_parameters wf_parameter_list_t := wf_parameter_list_t();

Line: 422

  raise_event(p_event_name=>'oracle.apps.fnd.user.role.insert',
    p_event_key=>to_char(p_user_id)||':'||p_role_name,
    p_parameters => l_parameters);

Line: 427

procedure update_user_role(p_user_id in number, p_role_name in varchar2)
is
l_parameters wf_parameter_list_t := wf_parameter_list_t();

Line: 442

  raise_event(p_event_name=>'oracle.apps.fnd.user.role.update',
              p_event_key=>to_char(p_user_id)||':'||p_role_name,
	      p_parameters => l_parameters);