[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure insert_dml(p_rec in out nocopy per_ssl_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'insert_dml';
insert into per_salary_survey_lines
( salary_survey_line_id,
object_version_number,
salary_survey_id,
survey_job_name_code,
survey_region_code,
survey_seniority_code,
company_size_code,
industry_code,
survey_age_code,
start_date,
end_date,
currency_code,
differential,
minimum_pay,
mean_pay,
maximum_pay,
graduate_pay,
starting_pay,
percentage_change,
job_first_quartile,
job_median_quartile,
job_third_quartile,
job_fourth_quartile,
minimum_total_compensation,
mean_total_compensation,
maximum_total_compensation,
compnstn_first_quartile,
compnstn_median_quartile,
compnstn_third_quartile,
compnstn_fourth_quartile,
/*Added for Enhancement 4021737 */
tenth_percentile,
twenty_fifth_percentile,
fiftieth_percentile,
seventy_fifth_percentile,
ninetieth_percentile,
minimum_bonus,
mean_bonus,
maximum_bonus,
minimum_salary_increase,
mean_salary_increase,
maximum_salary_increase,
min_variable_compensation,
mean_variable_compensation,
max_variable_compensation,
minimum_stock,
mean_stock,
maximum_stock,
stock_display_type,
/*End Enhancement 4021737 */
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute16,
attribute17,
attribute18,
attribute19,
attribute20,
/*Added for Enhancement 4021737 */
attribute21,
attribute22,
attribute23,
attribute24,
attribute25,
attribute26,
attribute27,
attribute28,
attribute29,
attribute30
/*End Enhancement 4021737 */
)
Values
( p_rec.salary_survey_line_id,
p_rec.object_version_number,
p_rec.salary_survey_id,
p_rec.survey_job_name_code,
p_rec.survey_region_code,
p_rec.survey_seniority_code,
p_rec.company_size_code,
p_rec.industry_code,
p_rec.survey_age_code,
p_rec.start_date,
p_rec.end_date,
p_rec.currency_code,
p_rec.differential,
p_rec.minimum_pay,
p_rec.mean_pay,
p_rec.maximum_pay,
p_rec.graduate_pay,
p_rec.starting_pay,
p_rec.percentage_change,
p_rec.job_first_quartile,
p_rec.job_median_quartile,
p_rec.job_third_quartile,
p_rec.job_fourth_quartile,
p_rec.minimum_total_compensation,
p_rec.mean_total_compensation,
p_rec.maximum_total_compensation,
p_rec.compnstn_first_quartile,
p_rec.compnstn_median_quartile,
p_rec.compnstn_third_quartile,
p_rec.compnstn_fourth_quartile,
/*Added for Enhancement 4021737 */
p_rec.tenth_percentile,
p_rec.twenty_fifth_percentile,
p_rec.fiftieth_percentile,
p_rec.seventy_fifth_percentile,
p_rec.ninetieth_percentile,
p_rec.minimum_bonus,
p_rec.mean_bonus,
p_rec.maximum_bonus,
p_rec.minimum_salary_increase,
p_rec.mean_salary_increase,
p_rec.maximum_salary_increase,
p_rec.min_variable_compensation,
p_rec.mean_variable_compensation,
p_rec.max_variable_compensation,
p_rec.minimum_stock,
p_rec.mean_stock,
p_rec.maximum_stock,
p_rec.stock_display_type,
/*End Enhancement 4021737 */
p_rec.attribute_category,
p_rec.attribute1,
p_rec.attribute2,
p_rec.attribute3,
p_rec.attribute4,
p_rec.attribute5,
p_rec.attribute6,
p_rec.attribute7,
p_rec.attribute8,
p_rec.attribute9,
p_rec.attribute10,
p_rec.attribute11,
p_rec.attribute12,
p_rec.attribute13,
p_rec.attribute14,
p_rec.attribute15,
p_rec.attribute16,
p_rec.attribute17,
p_rec.attribute18,
p_rec.attribute19,
p_rec.attribute20,
/*Added for Enhancement 4021737 */
p_rec.attribute21,
p_rec.attribute22,
p_rec.attribute23,
p_rec.attribute24,
p_rec.attribute25,
p_rec.attribute26,
p_rec.attribute27,
p_rec.attribute28,
p_rec.attribute29,
p_rec.attribute30
/*End Enhancement 4021737 */
);
End insert_dml;
Procedure pre_insert(p_rec in out nocopy per_ssl_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_insert';
Cursor C_Sel1 is select per_salary_survey_lines_s.nextval from sys.dual;
End pre_insert;
Procedure post_insert(p_rec in per_ssl_shd.g_rec_type,
p_effective_date in date) is
--
l_proc varchar2(72) := g_package||'post_insert';
per_ssl_rki.after_insert
(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 */
);
End post_insert;
per_ssl_bus.insert_validate(p_rec, p_effective_date);
pre_insert(p_rec);
insert_dml(p_rec);
post_insert(p_rec,p_effective_date);