eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_SALARY_SURVEY_MAPPING_API SQL Statements

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

Line: 251


procedure update_mapping
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_location_id                   in     number
  ,p_grade_id                      in     number
  ,p_company_organization_id       in     number
  ,p_company_age_code              in     varchar2
  ,p_attribute_category            in     varchar2
  ,p_attribute1                    in     varchar2
  ,p_attribute2                    in     varchar2
  ,p_attribute3                    in     varchar2
  ,p_attribute4                    in     varchar2
  ,p_attribute5                    in     varchar2
  ,p_attribute6                    in     varchar2
  ,p_attribute7                    in     varchar2
  ,p_attribute8                    in     varchar2
  ,p_attribute9                    in     varchar2
  ,p_attribute10                   in     varchar2
  ,p_attribute11                   in     varchar2
  ,p_attribute12                   in     varchar2
  ,p_attribute13                   in     varchar2
  ,p_attribute14                   in     varchar2
  ,p_attribute15                   in     varchar2
  ,p_attribute16                   in     varchar2
  ,p_attribute17                   in     varchar2
  ,p_attribute18                   in     varchar2
  ,p_attribute19                   in     varchar2
  ,p_attribute20                   in     varchar2
  ,p_salary_survey_mapping_id      in     number
  ,p_object_version_number         in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --

  l_proc                varchar2(72) := g_package||'update_mapping';

Line: 295


  savepoint update_mapping;

Line: 307


    per_ssm_api_bk2.update_mapping_b
      (p_effective_date                => p_effective_date
      ,p_location_id                   => p_location_id
      ,p_grade_id                      => p_grade_id
      ,p_company_organization_id       => p_company_organization_id
      ,p_company_age_code              => p_company_age_code
      ,p_attribute_category            => p_attribute_category
      ,p_attribute1                    => p_attribute1
      ,p_attribute2                    => p_attribute2
      ,p_attribute3                    => p_attribute3
      ,p_attribute4                    => p_attribute4
      ,p_attribute5                    => p_attribute5
      ,p_attribute6                    => p_attribute6
      ,p_attribute7                    => p_attribute7
      ,p_attribute8                    => p_attribute8
      ,p_attribute9                    => p_attribute9
      ,p_attribute10                   => p_attribute10
      ,p_attribute11                   => p_attribute11
      ,p_attribute12                   => p_attribute12
      ,p_attribute13                   => p_attribute13
      ,p_attribute14                   => p_attribute14
      ,p_attribute15                   => p_attribute15
      ,p_attribute16                   => p_attribute16
      ,p_attribute17                   => p_attribute17
      ,p_attribute18                   => p_attribute18
      ,p_attribute19                   => p_attribute19
      ,p_attribute20                   => p_attribute20
      ,p_salary_survey_mapping_id      => p_salary_survey_mapping_id
      ,p_object_version_number         => l_object_version_number
      );

Line: 340


        (p_module_name => 'update_mapping'
        ,p_hook_type   => 'BP'
        );

Line: 397


    per_ssm_api_bk2.update_mapping_a
      (p_effective_date                => p_effective_date
      ,p_location_id                   => p_location_id
      ,p_grade_id                      => p_grade_id
      ,p_company_organization_id       => p_company_organization_id
      ,p_company_age_code              => p_company_age_code
      ,p_attribute_category            => p_attribute_category
      ,p_attribute1                    => p_attribute1
      ,p_attribute2                    => p_attribute2
      ,p_attribute3                    => p_attribute3
      ,p_attribute4                    => p_attribute4
      ,p_attribute5                    => p_attribute5
      ,p_attribute6                    => p_attribute6
      ,p_attribute7                    => p_attribute7
      ,p_attribute8                    => p_attribute8
      ,p_attribute9                    => p_attribute9
      ,p_attribute10                   => p_attribute10
      ,p_attribute11                   => p_attribute11
      ,p_attribute12                   => p_attribute12
      ,p_attribute13                   => p_attribute13
      ,p_attribute14                   => p_attribute14
      ,p_attribute15                   => p_attribute15
      ,p_attribute16                   => p_attribute16
      ,p_attribute17                   => p_attribute17
      ,p_attribute18                   => p_attribute18
      ,p_attribute19                   => p_attribute19
      ,p_attribute20                   => p_attribute20
      ,p_salary_survey_mapping_id      => p_salary_survey_mapping_id
      ,p_object_version_number         => l_object_version_number
      );

Line: 430


        (p_module_name => 'update_mapping'
        ,p_hook_type   => 'AP'
        );

Line: 454


    rollback to update_mapping;

Line: 467


    rollback to update_mapping;

Line: 470


end update_mapping;

Line: 476


procedure delete_mapping
  (p_validate                      in     boolean  default false
  ,p_salary_survey_mapping_id      in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --

  l_proc                varchar2(72) := g_package||'delete_mapping';

Line: 491


  savepoint delete_mapping;

Line: 501


    per_ssm_api_bk3.delete_mapping_b
      (p_salary_survey_mapping_id      => p_salary_survey_mapping_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 508


        (p_module_name => 'DELETE_MAPPING'
        ,p_hook_type   => 'BP'
        );

Line: 533


    per_ssm_api_bk3.delete_mapping_a
      (p_salary_survey_mapping_id      => p_salary_survey_mapping_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 540


        (p_module_name => 'DELETE_MAPPING'
        ,p_hook_type   => 'AP'
        );

Line: 559


    rollback to delete_mapping;

Line: 565


    rollback to delete_mapping;

Line: 568


end delete_mapping;

Line: 574


procedure mass_update
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_business_group_id		   in     number
  ,p_job_id                        in     number   default null
  ,p_position_id                   in     number   default null
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                	varchar2(72) := g_package||'mass_update';

Line: 601


     select j.date_from, nvl(j.date_to, hr_api.g_eot)
     from per_jobs j
     where j.job_id = p_job_id;

Line: 608


     select p.date_effective, nvl(hr_general.get_position_date_end(p.position_id), hr_general.end_of_time)
     from hr_positions_f p
     where p.position_id = p_position_id
     and   p.effective_end_date = hr_general.end_of_time;

Line: 614


     select ssm.location_id location_id,
	    ssm.grade_id grade_id,
            ssm.company_organization_id company_organization_id,
	    ssm.company_age_code company_age_code,
	    ssl.survey_job_name_code survey_job_name_code,
 	    ssl.survey_region_code survey_region_code,
	    ssl.survey_seniority_code survey_seniority_code,
	    ssl.company_size_code company_size_code,
	    ssl.industry_code industry_code,
	    max(ssl.end_date) max_end_date
     from per_salary_survey_mappings ssm,
	  per_salary_survey_lines ssl
     where nvl(p_job_id,p_position_id) = ssm.parent_id
     and ssl.salary_survey_line_id = ssm.salary_survey_line_id
     and parent_table_name = c_table_name
     group by ssm.location_id,
	      ssm.grade_id,
              ssm.company_organization_id,
	      ssm.company_age_code,
	      ssl.survey_job_name_code,
 	      ssl.survey_region_code,
	      ssl.survey_seniority_code,
	      ssl.company_size_code,
	      ssl.industry_code;

Line: 641


     select g.date_from, nvl(g.date_to,hr_api.g_eot)
     from per_grades g
     where grade_id = c_grade_id;

Line: 646


     select o.date_from, nvl(o.date_to,hr_api.g_eot)
     from hr_all_organization_units o
     where o.organization_id = c_org_id;

Line: 657


     select salary_survey_line_id
     from per_salary_survey_lines ssl
     where ssl.start_date between c_date_from and c_date_to
     and nvl(ssl.survey_job_name_code,hr_api.g_varchar2) = nvl(c_survey_job_name_code,hr_api.g_varchar2)
     and nvl(ssl.survey_region_code,hr_api.g_varchar2) = nvl(c_survey_region_code,hr_api.g_varchar2)
     and nvl(ssl.survey_seniority_code,hr_api.g_varchar2) = nvl(c_survey_seniority_code,hr_api.g_varchar2)
     and nvl(ssl.company_size_code,hr_api.g_varchar2) = nvl(c_company_size_code,hr_api.g_varchar2)
     and nvl(ssl.industry_code,hr_api.g_varchar2) = nvl(c_industry_code,hr_api.g_varchar2);

Line: 672


  savepoint mass_update;

Line: 683


    per_ssm_api_bk4.mass_update_b
      (p_effective_date                => p_effective_date
      ,p_business_group_id             => p_business_group_id
      ,p_job_id                        => p_job_id
      ,p_position_id                   => p_position_id
      );

Line: 692


        (p_module_name => 'MASS_UPDATE'
        ,p_hook_type   => 'BP'
        );

Line: 899


    per_ssm_api_bk4.mass_update_a
      (p_effective_date                => p_effective_date
      ,p_business_group_id             => p_business_group_id
      ,p_job_id                        => p_job_id
      ,p_position_id                   => p_position_id
      );

Line: 908


        (p_module_name => 'MASS_UPDATE'
        ,p_hook_type   => 'AP'
        );

Line: 930


    rollback to mass_update;

Line: 937


    rollback to mass_update;

Line: 940


end mass_update;