APPS.POR_LOAD_EMPLOYEE_ASSIGNMENT SQL Statements

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

Line: 4

PROCEDURE insert_update_employee_asg (
        x_person_id IN NUMBER,
        x_business_group_id IN NUMBER,
        x_location_name IN VARCHAR2,
        x_assignment_number IN OUT NOCOPY VARCHAR2,
        x_default_employee_account IN VARCHAR2,
        x_set_of_books_name IN VARCHAR2,
        x_job_name IN VARCHAR2,
        x_supervisor_emp_number IN VARCHAR2,
        x_effective_start_date IN DATE,
        x_effective_end_date IN DATE)

IS

 l_person_id NUMBER;

Line: 45

 l_spp_delete_warning BOOLEAN;

Line: 78

          hr_assignment_api.update_emp_asg (
	    p_validate => FALSE
           ,p_datetrack_update_mode => 'CORRECTION'
	   ,p_effective_date => x_effective_start_date
	   ,p_concatenated_segments  => l_concatenated_segments
	   ,p_cagr_grade_def_id => l_cagr_grade_def_id
	   ,p_cagr_concatenated_segments  => l_cagr_concatenated_segments
	   ,p_assignment_id  => l_assignment_id
	   ,p_soft_coding_keyflex_id  =>  l_soft_coding_keyflex_id
	   ,p_object_version_number => l_object_version_number
	   ,p_assignment_number => x_assignment_number
	   ,p_effective_start_date =>  l_effective_start_date
	   ,p_effective_end_date =>  l_effective_end_date
	   ,p_comment_id  => l_comment_id
	   ,p_other_manager_warning => l_other_manager_warning
           ,p_no_managers_warning => l_no_managers_warning
           ,p_set_of_books_id => l_set_of_books_id
           ,p_default_code_comb_id => l_ccid
	   ,p_supervisor_id => l_supervisor_id
	  );

Line: 100

          hr_assignment_api.update_emp_asg_criteria (
           p_validate => FALSE
          ,p_datetrack_update_mode => 'CORRECTION'
          ,p_assignment_id  => l_assignment_id
          ,p_object_version_number => l_object_version_number
          ,p_special_ceiling_step_id => l_special_ceiling_step_id
	  ,p_effective_date => x_effective_start_date
          ,p_job_id => l_job_id
          ,p_location_id => l_location_id
          ,p_group_name => l_group_name
          ,p_employment_category => l_employment_category
          ,p_effective_start_date => l_effective_start_date
          ,p_effective_end_date =>  l_effective_end_date
          ,p_people_group_id => l_people_group_id
          ,p_org_now_no_manager_warning => l_no_managers_warning
          ,p_other_manager_warning => l_other_manager_warning
          ,p_spp_delete_warning => l_spp_delete_warning
          ,p_entries_changed_warning => l_entries_changed_warning
          ,p_tax_district_changed_warning => l_tax_district_changed_warning
          );

Line: 133

END insert_update_employee_asg;

Line: 140

  SELECT set_of_books_id INTO l_set_of_books_id
  FROM gl_sets_of_books
  WHERE name = p_set_of_books_name;

Line: 156

  SELECT location_id INTO l_location_id
  FROM hr_locations_all
  WHERE location_code = p_location_name;

Line: 173

  SELECT chart_of_accounts_id INTO l_chart_of_accounts_id
  FROM gl_sets_of_books
  WHERE set_of_books_id = p_set_of_books_id;

Line: 212

   SELECT assignment_id, object_version_number INTO l_assignment_id, l_object_version_number FROM per_all_assignments_f
   WHERE person_id = p_person_id and trunc(effective_start_date) <= trunc(p_effective_start_date);

Line: 225

    SELECT job_id INTO l_job_id FROM per_jobs job
    WHERE  job.name  = p_job_name
    AND    job.business_group_id = p_business_group_id;

Line: 242

     SELECT person_id INTO l_supervisor_id FROM per_all_people_f
     WHERE employee_number = x_supervisor_emp_num;

Line: 257

     SELECT address_id INTO l_address_id
     FROM per_addresses
     WHERE person_id = p_person_id
     AND primary_flag = 'Y';