APPS.IRC_LOGIN SQL Statements

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

Line: 18

  select function_id
  from fnd_form_functions
  where function_name=p_function_name;

Line: 24

  select user_id
  from fnd_user
  where user_name=substr(FND_WEB_SEC.GET_GUEST_USERNAME_PWD()
                        ,0
                        ,instr(FND_WEB_SEC.GET_GUEST_USERNAME_PWD(),'/')-1);

Line: 32

  select responsibility_id
  from fnd_responsibility
  where responsibility_key=p_responsibility_key;

Line: 38

  select application_id
  from fnd_application
  where application_short_name=p_application_short_name;

Line: 44

  select security_group_id
  from fnd_security_groups
  where security_group_key=p_security_group_key;

Line: 50

  select node_id
  from fnd_nodes
  where lower(node_name)=lower(p_server_name);

Line: 55

  select node_id
  from fnd_nodes
  where lower(webhost)=lower(p_server_name);

Line: 138

      select user_id into userID
      from fnd_user
      where user_name = user AND
      user_id <> 6 and
      (start_date <= sysdate) AND
      (end_date is null or end_date > sysdate);

Line: 172

  FND_USER_PKG.UpdateUser (
               x_user_name       => p_username
              ,x_owner           => null
              ,x_last_logon_date => sysdate
              );

Line: 177

  hr_utility.set_location('update usre:'||p_username||
                          ' with date'||to_char(sysdate,'DD-MON-YYYY hh:mm:ss'),30);