APPS.POR_LOAD_FND_USER SQL Statements

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

Line: 4

PROCEDURE insert_update_user_info (
        x_employee_number IN VARCHAR2,
	x_user_name  IN VARCHAR2,
        x_password IN VARCHAR2,
        x_email_address IN VARCHAR2)
IS

 l_return_status VARCHAR2(20);

Line: 39

	  ,p_last_updated_by => 0
	  ,p_last_update_date => sysdate
	  ,p_user_id => l_user_id
	);

Line: 44

          update_employee_id(l_employee_id, l_user_id);

Line: 52

         FND_USER_RESP_GROUPS_API.INSERT_ASSIGNMENT (
            USER_ID  => l_user_id,
            RESPONSIBILITY_ID => l_ssp_resp_id,
            RESPONSIBILITY_APPLICATION_ID => 178,
            START_DATE => sysdate,
            END_DATE => NULL,
            DESCRIPTION	=> 'Default'
         );

Line: 66

   	FND_User_PVT.Update_user(
	   p_api_version_number => l_api_version_number
	  ,p_return_status => l_return_status
	  ,p_msg_count => l_msg_count
	  ,p_msg_data => l_msg_data
	  ,p_email_address => x_email_address
	  ,p_language   => 'US'
	  ,p_host_port => NULL
	  ,p_last_updated_by => 0
	  ,p_last_update_date => sysdate
	  ,p_user_id => l_user_id
	);

Line: 91

END insert_update_user_info;

Line: 98

   SELECT responsibility_id INTO p_resp_id
   FROM fnd_responsibility
   WHERE responsibility_key = p_resp_key
   AND application_id = 178;

Line: 113

   SELECT 1 INTO l_fnd_user_exists FROM fnd_user
   WHERE user_name = upper(p_user_name);

Line: 130

  SELECT person_id INTO l_person_id
  FROM per_all_people_f
  WHERE employee_number = p_employee_number;

Line: 142

PROCEDURE update_employee_id(p_employee_id IN NUMBER,p_user_id IN NUMBER)
IS
BEGIN


  UPDATE fnd_user
  SET employee_id = p_employee_id
  WHERE user_id = p_user_id;

Line: 155

END update_employee_id;