APPS.PER_SSL_DEL SQL Statements

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

Line: 51

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

Line: 60

  delete from per_salary_survey_lines
  where salary_survey_line_id = p_rec.salary_survey_line_id;

Line: 72

End delete_dml;

Line: 106

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

Line: 114

End pre_delete;

Line: 148

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

Line: 156

    per_ssl_rkd.after_delete
      (p_salary_survey_line_id
         => p_rec.salary_survey_line_id,
       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: 331

End post_delete;

Line: 356

  per_ssl_bus.delete_validate(p_rec);

Line: 360

  pre_delete(p_rec);

Line: 364

  delete_dml(p_rec);

Line: 368

  post_delete(p_rec);