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.PER_SSL_UPD SQL Statements

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

Line: 54


Procedure update_dml(p_rec in out nocopy per_ssl_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_dml';

Line: 68


  update per_salary_survey_lines
  set
  salary_survey_line_id             = p_rec.salary_survey_line_id,
  object_version_number             = p_rec.object_version_number,
  survey_job_name_code              = p_rec.survey_job_name_code,
  survey_region_code                = p_rec.survey_region_code,
  survey_seniority_code             = p_rec.survey_seniority_code,
  company_size_code                 = p_rec.company_size_code,
  industry_code                     = p_rec.industry_code,
  survey_age_code                   = p_rec.survey_age_code,
  start_date                        = p_rec.start_date,
  end_date                          = p_rec.end_date,
  currency_code                     = p_rec.currency_code,
  differential                      = p_rec.differential,
  minimum_pay                       = p_rec.minimum_pay,
  mean_pay                          = p_rec.mean_pay,
  maximum_pay                       = p_rec.maximum_pay,
  graduate_pay                      = p_rec.graduate_pay,
  starting_pay                      = p_rec.starting_pay,
  percentage_change                 = p_rec.percentage_change,
  job_first_quartile                = p_rec.job_first_quartile,
  job_median_quartile               = p_rec.job_median_quartile,
  job_third_quartile                = p_rec.job_third_quartile,
  job_fourth_quartile               = p_rec.job_fourth_quartile,
  minimum_total_compensation        = p_rec.minimum_total_compensation,
  mean_total_compensation           = p_rec.mean_total_compensation,
  maximum_total_compensation        = p_rec.maximum_total_compensation,
  compnstn_first_quartile           = p_rec.compnstn_first_quartile,
  compnstn_median_quartile          = p_rec.compnstn_median_quartile,
  compnstn_third_quartile           = p_rec.compnstn_third_quartile,
  compnstn_fourth_quartile          = p_rec.compnstn_fourth_quartile,
/*Added for Enhancement 4021737 */
  tenth_percentile                  = p_rec.tenth_percentile,
  twenty_fifth_percentile           = p_rec.twenty_fifth_percentile,
  fiftieth_percentile               = p_rec.fiftieth_percentile,
  seventy_fifth_percentile          = p_rec.seventy_fifth_percentile,
  ninetieth_percentile              = p_rec.ninetieth_percentile,
  minimum_bonus                     = p_rec.minimum_bonus,
  mean_bonus                        = p_rec.mean_bonus,
  maximum_bonus                     = p_rec.maximum_bonus,
  minimum_salary_increase           = p_rec.minimum_salary_increase,
  mean_salary_increase              = p_rec.mean_salary_increase,
  maximum_salary_increase           = p_rec.maximum_salary_increase,
  min_variable_compensation         = p_rec.min_variable_compensation,
  mean_variable_compensation        = p_rec.mean_variable_compensation,
  max_variable_compensation         = p_rec.max_variable_compensation,
  minimum_stock                     = p_rec.minimum_stock,
  mean_stock                        = p_rec.mean_stock,
  maximum_stock                     = p_rec.maximum_stock,
  stock_display_type                = p_rec.stock_display_type,
/*End Enhancement 4021737 */
  attribute_category                = p_rec.attribute_category,
  attribute1                        = p_rec.attribute1,
  attribute2                        = p_rec.attribute2,
  attribute3                        = p_rec.attribute3,
  attribute4                        = p_rec.attribute4,
  attribute5                        = p_rec.attribute5,
  attribute6                        = p_rec.attribute6,
  attribute7                        = p_rec.attribute7,
  attribute8                        = p_rec.attribute8,
  attribute9                        = p_rec.attribute9,
  attribute10                       = p_rec.attribute10,
  attribute11                       = p_rec.attribute11,
  attribute12                       = p_rec.attribute12,
  attribute13                       = p_rec.attribute13,
  attribute14                       = p_rec.attribute14,
  attribute15                       = p_rec.attribute15,
  attribute16                       = p_rec.attribute16,
  attribute17                       = p_rec.attribute17,
  attribute18                       = p_rec.attribute18,
  attribute19                       = p_rec.attribute19,
  attribute20                       = p_rec.attribute20,
/* Added for Enhancement 4021737 */
  attribute21                       = p_rec.attribute21,
  attribute22                       = p_rec.attribute22,
  attribute23                       = p_rec.attribute23,
  attribute24                       = p_rec.attribute24,
  attribute25                       = p_rec.attribute25,
  attribute26                       = p_rec.attribute26,
  attribute27                       = p_rec.attribute27,
  attribute28                       = p_rec.attribute28,
  attribute29                       = p_rec.attribute29,
  attribute30                       = p_rec.attribute30
/*End Enhancement 4021737 */
  where salary_survey_line_id       = p_rec.salary_survey_line_id;

Line: 171


End update_dml;

Line: 205


Procedure pre_update(p_rec in per_ssl_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'pre_update';

Line: 213


End pre_update;

Line: 247


Procedure post_update(p_rec            in per_ssl_shd.g_rec_type,
                      p_effective_date in date) is
--
  l_proc  varchar2(72) := g_package||'post_update';

Line: 256


    per_ssl_rku.after_update
      (p_salary_survey_line_id
         => p_rec.salary_survey_line_id,
       p_object_version_number
         => p_rec.object_version_number,
       p_salary_survey_id => p_rec.salary_survey_id,
       p_survey_job_name_code
         => p_rec.survey_job_name_code,
       p_survey_region_code
         => p_rec.survey_region_code,
       p_survey_seniority_code
         => p_rec.survey_seniority_code,
       p_company_size_code
         => p_rec.company_size_code,
       p_industry_code
         => p_rec.industry_code,
       p_survey_age_code
         => p_rec.survey_age_code,
       p_start_date
         => p_rec.start_date,
       p_end_date
         => p_rec.end_date,
       p_currency_code
         => p_rec.currency_code,
       p_differential
          => p_rec.differential,
       p_minimum_pay
          => p_rec.minimum_pay,
       p_mean_pay
          => p_rec.mean_pay,
       p_maximum_pay
          => p_rec.maximum_pay,
       p_graduate_pay
          => p_rec.graduate_pay,
       p_starting_pay
          => p_rec.starting_pay,
       p_percentage_change
          => p_rec.percentage_change,
       p_job_first_quartile
          => p_rec.job_first_quartile,
       p_job_median_quartile
          => p_rec.job_median_quartile,
       p_job_third_quartile
          => p_rec.job_third_quartile,
       p_job_fourth_quartile
          => p_rec.job_fourth_quartile,
       p_minimum_total_compensation
          => p_rec.minimum_total_compensation,
       p_mean_total_compensation
          => p_rec.mean_total_compensation,
       p_maximum_total_compensation
          => p_rec.maximum_total_compensation,
       p_compnstn_first_quartile
          => p_rec.compnstn_first_quartile,
       p_compnstn_median_quartile
           => p_rec.compnstn_median_quartile,
       p_compnstn_third_quartile
           => p_rec.compnstn_third_quartile,
       p_compnstn_fourth_quartile
           => p_rec.compnstn_fourth_quartile,
/*Added for Enhancement 4021737 */
       p_tenth_percentile
          => p_rec.tenth_percentile,
       p_twenty_fifth_percentile
          => p_rec.twenty_fifth_percentile,
       p_fiftieth_percentile
          => p_rec.fiftieth_percentile,
       p_seventy_fifth_percentile
          => p_rec.seventy_fifth_percentile,
       p_ninetieth_percentile
          => p_rec.ninetieth_percentile,
       p_minimum_bonus
          => p_rec.minimum_bonus,
       p_mean_bonus
          => p_rec.mean_bonus,
       p_maximum_bonus
          => p_rec.maximum_bonus,
       p_minimum_salary_increase
          => p_rec.minimum_salary_increase,
       p_mean_salary_increase
          => p_rec.mean_salary_increase,
       p_maximum_salary_increase
          => p_rec.maximum_salary_increase,
       p_min_variable_compensation
          => p_rec.min_variable_compensation,
       p_mean_variable_compensation
          => p_rec.mean_variable_compensation,
       p_max_variable_compensation
          => p_rec.max_variable_compensation,
       p_minimum_stock
          => p_rec.minimum_stock,
       p_mean_stock
          => p_rec.mean_stock,
       p_maximum_stock
          => p_rec.maximum_stock,
       p_stock_display_type
          => p_rec.stock_display_type,
/*End Enhancement 4021737 */
       p_effective_date
           => p_effective_date,
       p_attribute_category
           => p_rec.attribute_category,
       p_attribute1
           => p_rec.attribute1,
       p_attribute2
           => p_rec.attribute2,
       p_attribute3
           => p_rec.attribute3,
       p_attribute4
           => p_rec.attribute4,
       p_attribute5
           => p_rec.attribute5,
       p_attribute6
           => p_rec.attribute6,
       p_attribute7
           => p_rec.attribute7,
       p_attribute8
           => p_rec.attribute8,
       p_attribute9
           => p_rec.attribute9,
       p_attribute10
           => p_rec.attribute10,
       p_attribute11
           => p_rec.attribute11,
       p_attribute12
           => p_rec.attribute12,
       p_attribute13
           => p_rec.attribute13,
       p_attribute14
           => p_rec.attribute14,
       p_attribute15
           => p_rec.attribute15,
       p_attribute16
           => p_rec.attribute16,
       p_attribute17
           => p_rec.attribute17,
       p_attribute18
           => p_rec.attribute18,
       p_attribute19
           => p_rec.attribute19,
       p_attribute20
           => p_rec.attribute20,
/*Added for Enhancement 4021737 */
       p_attribute21
           => p_rec.attribute21,
       p_attribute22
           => p_rec.attribute22,
       p_attribute23
           => p_rec.attribute23,
       p_attribute24
           => p_rec.attribute24,
       p_attribute25
           => p_rec.attribute25,
       p_attribute26
           => p_rec.attribute26,
       p_attribute27
           => p_rec.attribute27,
       p_attribute28
           => p_rec.attribute28,
       p_attribute29
           => p_rec.attribute29,
       p_attribute30
           => p_rec.attribute30,
/*End Enhancement 4021737 */
       p_object_version_number_o
         => per_ssl_shd.g_old_rec.object_version_number,
       p_salary_survey_id_o
         => per_ssl_shd.g_old_rec.salary_survey_id,
       p_survey_job_name_code_o
         => per_ssl_shd.g_old_rec.survey_job_name_code,
       p_survey_region_code_o
         => per_ssl_shd.g_old_rec.survey_region_code,
       p_survey_seniority_code_o
         => per_ssl_shd.g_old_rec.survey_seniority_code,
       p_company_size_code_o
         => per_ssl_shd.g_old_rec.company_size_code,
       p_industry_code_o
         => per_ssl_shd.g_old_rec.industry_code,
       p_survey_age_code_o
         => per_ssl_shd.g_old_rec.survey_age_code,
       p_start_date_o
         => per_ssl_shd.g_old_rec.start_date,
       p_end_date_o
         => per_ssl_shd.g_old_rec.end_date,
       p_currency_code_o
         => per_ssl_shd.g_old_rec.currency_code,
       p_differential_o
          => per_ssl_shd.g_old_rec.differential,
       p_minimum_pay_o
          => per_ssl_shd.g_old_rec.minimum_pay,
       p_mean_pay_o
          => per_ssl_shd.g_old_rec.mean_pay,
       p_maximum_pay_o
          => per_ssl_shd.g_old_rec.maximum_pay,
       p_graduate_pay_o
          => per_ssl_shd.g_old_rec.graduate_pay,
       p_starting_pay_o
          => per_ssl_shd.g_old_rec.starting_pay,
       p_percentage_change_o
          => per_ssl_shd.g_old_rec.percentage_change,
       p_job_first_quartile_o
          => per_ssl_shd.g_old_rec.job_first_quartile,
       p_job_median_quartile_o
          => per_ssl_shd.g_old_rec.job_median_quartile,
       p_job_third_quartile_o
          => per_ssl_shd.g_old_rec.job_third_quartile,
       p_job_fourth_quartile_o
          => per_ssl_shd.g_old_rec.job_fourth_quartile,
       p_minimum_total_compensation_o
          => per_ssl_shd.g_old_rec.minimum_total_compensation,
       p_mean_total_compensation_o
          => per_ssl_shd.g_old_rec.mean_total_compensation,
       p_maximum_total_compensation_o
          => per_ssl_shd.g_old_rec.maximum_total_compensation,
       p_compnstn_first_quartile_o
          => per_ssl_shd.g_old_rec.compnstn_first_quartile,
       p_compnstn_median_quartile_o
           => per_ssl_shd.g_old_rec.compnstn_median_quartile,
       p_compnstn_third_quartile_o
           => per_ssl_shd.g_old_rec.compnstn_third_quartile,
       p_compnstn_fourth_quartile_o
           => per_ssl_shd.g_old_rec.compnstn_fourth_quartile,
/*Added for Enhancement 4021737 */
        p_tenth_percentile_o
          => per_ssl_shd.g_old_rec.tenth_percentile,
        p_twenty_fifth_percentile_o
          => per_ssl_shd.g_old_rec.twenty_fifth_percentile,
        p_fiftieth_percentile_o
          => per_ssl_shd.g_old_rec.fiftieth_percentile,
        p_seventy_fifth_percentile_o
          => per_ssl_shd.g_old_rec.seventy_fifth_percentile,
        p_ninetieth_percentile_o
          => per_ssl_shd.g_old_rec.ninetieth_percentile,
        p_minimum_bonus_o
          => per_ssl_shd.g_old_rec.minimum_bonus,
        p_mean_bonus_o
          => per_ssl_shd.g_old_rec.mean_bonus,
        p_maximum_bonus_o
          => per_ssl_shd.g_old_rec.maximum_bonus,
        p_minimum_salary_increase_o
          => per_ssl_shd.g_old_rec.minimum_salary_increase,
        p_mean_salary_increase_o
          => per_ssl_shd.g_old_rec.mean_salary_increase,
        p_maximum_salary_increase_o
          => per_ssl_shd.g_old_rec.maximum_salary_increase,
        p_min_variable_compensation_o
          => per_ssl_shd.g_old_rec.min_variable_compensation,
        p_mean_variable_compensation_o
          => per_ssl_shd.g_old_rec.mean_variable_compensation,
        p_max_variable_compensation_o
          => per_ssl_shd.g_old_rec.max_variable_compensation,
        p_minimum_stock_o
          => per_ssl_shd.g_old_rec.minimum_stock,
        p_mean_stock_o
          => per_ssl_shd.g_old_rec.mean_stock,
        p_maximum_stock_o
          => per_ssl_shd.g_old_rec.maximum_stock,
        p_stock_display_type_o
          => per_ssl_shd.g_old_rec.stock_display_type,
/*End Enhancement 4021737 */
       p_attribute_category_o
           => per_ssl_shd.g_old_rec.attribute_category,
       p_attribute1_o
           => per_ssl_shd.g_old_rec.attribute1,
       p_attribute2_o
           => per_ssl_shd.g_old_rec.attribute2,
       p_attribute3_o
           => per_ssl_shd.g_old_rec.attribute3,
       p_attribute4_o
           => per_ssl_shd.g_old_rec.attribute4,
       p_attribute5_o
           => per_ssl_shd.g_old_rec.attribute5,
       p_attribute6_o
           => per_ssl_shd.g_old_rec.attribute6,
       p_attribute7_o
           => per_ssl_shd.g_old_rec.attribute7,
       p_attribute8_o
           => per_ssl_shd.g_old_rec.attribute8,
       p_attribute9_o
           => per_ssl_shd.g_old_rec.attribute9,
       p_attribute10_o
           => per_ssl_shd.g_old_rec.attribute10,
       p_attribute11_o
           => per_ssl_shd.g_old_rec.attribute11,
       p_attribute12_o
           => per_ssl_shd.g_old_rec.attribute12,
       p_attribute13_o
           => per_ssl_shd.g_old_rec.attribute13,
       p_attribute14_o
           => per_ssl_shd.g_old_rec.attribute14,
       p_attribute15_o
           => per_ssl_shd.g_old_rec.attribute15,
       p_attribute16_o
           => per_ssl_shd.g_old_rec.attribute16,
       p_attribute17_o
           => per_ssl_shd.g_old_rec.attribute17,
       p_attribute18_o
           => per_ssl_shd.g_old_rec.attribute18,
       p_attribute19_o
           => per_ssl_shd.g_old_rec.attribute19,
       p_attribute20_o
           => per_ssl_shd.g_old_rec.attribute20,
/*Added for Enhancement 4021737 */
       p_attribute21_o
           => per_ssl_shd.g_old_rec.attribute21,
       p_attribute22_o
           => per_ssl_shd.g_old_rec.attribute22,
       p_attribute23_o
           => per_ssl_shd.g_old_rec.attribute23,
       p_attribute24_o
           => per_ssl_shd.g_old_rec.attribute24,
       p_attribute25_o
           => per_ssl_shd.g_old_rec.attribute25,
       p_attribute26_o
           => per_ssl_shd.g_old_rec.attribute26,
       p_attribute27_o
           => per_ssl_shd.g_old_rec.attribute27,
       p_attribute28_o
           => per_ssl_shd.g_old_rec.attribute28,
       p_attribute29_o
           => per_ssl_shd.g_old_rec.attribute29,
       p_attribute30_o
           => per_ssl_shd.g_old_rec.attribute30
/*End Enhancement 4021737 */
      );

Line: 591


End post_update;

Line: 997


  per_ssl_bus.update_validate(p_rec, p_effective_date);

Line: 1001


  pre_update(p_rec);

Line: 1005


  update_dml(p_rec);

Line: 1009


  post_update(p_rec,p_effective_date);