49: Procedure chk_unique_key
50: (p_salary_survey_line_id in number,
51: p_object_version_number in number,
52: p_salary_survey_id in number,
53: p_survey_job_name_code in per_salary_survey_lines.survey_job_name_code%TYPE,
54: p_survey_region_code in per_salary_survey_lines.survey_region_code%TYPE,
55: p_survey_seniority_code in per_salary_survey_lines.survey_seniority_code%TYPE,
56: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,
57: p_industry_code in per_salary_survey_lines.industry_code%TYPE,
50: (p_salary_survey_line_id in number,
51: p_object_version_number in number,
52: p_salary_survey_id in number,
53: p_survey_job_name_code in per_salary_survey_lines.survey_job_name_code%TYPE,
54: p_survey_region_code in per_salary_survey_lines.survey_region_code%TYPE,
55: p_survey_seniority_code in per_salary_survey_lines.survey_seniority_code%TYPE,
56: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,
57: p_industry_code in per_salary_survey_lines.industry_code%TYPE,
58: p_survey_age_code in per_salary_survey_lines.survey_age_code%TYPE,
51: p_object_version_number in number,
52: p_salary_survey_id in number,
53: p_survey_job_name_code in per_salary_survey_lines.survey_job_name_code%TYPE,
54: p_survey_region_code in per_salary_survey_lines.survey_region_code%TYPE,
55: p_survey_seniority_code in per_salary_survey_lines.survey_seniority_code%TYPE,
56: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,
57: p_industry_code in per_salary_survey_lines.industry_code%TYPE,
58: p_survey_age_code in per_salary_survey_lines.survey_age_code%TYPE,
59: p_start_date in per_salary_survey_lines.start_date%TYPE,
52: p_salary_survey_id in number,
53: p_survey_job_name_code in per_salary_survey_lines.survey_job_name_code%TYPE,
54: p_survey_region_code in per_salary_survey_lines.survey_region_code%TYPE,
55: p_survey_seniority_code in per_salary_survey_lines.survey_seniority_code%TYPE,
56: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,
57: p_industry_code in per_salary_survey_lines.industry_code%TYPE,
58: p_survey_age_code in per_salary_survey_lines.survey_age_code%TYPE,
59: p_start_date in per_salary_survey_lines.start_date%TYPE,
60: p_end_date in per_salary_survey_lines.end_date%TYPE);
53: p_survey_job_name_code in per_salary_survey_lines.survey_job_name_code%TYPE,
54: p_survey_region_code in per_salary_survey_lines.survey_region_code%TYPE,
55: p_survey_seniority_code in per_salary_survey_lines.survey_seniority_code%TYPE,
56: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,
57: p_industry_code in per_salary_survey_lines.industry_code%TYPE,
58: p_survey_age_code in per_salary_survey_lines.survey_age_code%TYPE,
59: p_start_date in per_salary_survey_lines.start_date%TYPE,
60: p_end_date in per_salary_survey_lines.end_date%TYPE);
61:
54: p_survey_region_code in per_salary_survey_lines.survey_region_code%TYPE,
55: p_survey_seniority_code in per_salary_survey_lines.survey_seniority_code%TYPE,
56: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,
57: p_industry_code in per_salary_survey_lines.industry_code%TYPE,
58: p_survey_age_code in per_salary_survey_lines.survey_age_code%TYPE,
59: p_start_date in per_salary_survey_lines.start_date%TYPE,
60: p_end_date in per_salary_survey_lines.end_date%TYPE);
61:
62:
55: p_survey_seniority_code in per_salary_survey_lines.survey_seniority_code%TYPE,
56: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,
57: p_industry_code in per_salary_survey_lines.industry_code%TYPE,
58: p_survey_age_code in per_salary_survey_lines.survey_age_code%TYPE,
59: p_start_date in per_salary_survey_lines.start_date%TYPE,
60: p_end_date in per_salary_survey_lines.end_date%TYPE);
61:
62:
63: --
56: p_company_size_code in per_salary_survey_lines.company_size_code%TYPE,
57: p_industry_code in per_salary_survey_lines.industry_code%TYPE,
58: p_survey_age_code in per_salary_survey_lines.survey_age_code%TYPE,
59: p_start_date in per_salary_survey_lines.start_date%TYPE,
60: p_end_date in per_salary_survey_lines.end_date%TYPE);
61:
62:
63: --
64: -- ---------------------------------------------------------------
115: in number,
116: p_object_version_number
117: in number,
118: p_currency_code
119: in per_salary_survey_lines.currency_code%TYPE,
120: p_minimum_pay
121: in per_salary_survey_lines.minimum_pay%TYPE,
122: p_mean_pay
123: in per_salary_survey_lines.mean_pay%TYPE,
117: in number,
118: p_currency_code
119: in per_salary_survey_lines.currency_code%TYPE,
120: p_minimum_pay
121: in per_salary_survey_lines.minimum_pay%TYPE,
122: p_mean_pay
123: in per_salary_survey_lines.mean_pay%TYPE,
124: p_maximum_pay
125: in per_salary_survey_lines.maximum_pay%TYPE,
119: in per_salary_survey_lines.currency_code%TYPE,
120: p_minimum_pay
121: in per_salary_survey_lines.minimum_pay%TYPE,
122: p_mean_pay
123: in per_salary_survey_lines.mean_pay%TYPE,
124: p_maximum_pay
125: in per_salary_survey_lines.maximum_pay%TYPE,
126: p_graduate_pay
127: in per_salary_survey_lines.graduate_pay%TYPE,
121: in per_salary_survey_lines.minimum_pay%TYPE,
122: p_mean_pay
123: in per_salary_survey_lines.mean_pay%TYPE,
124: p_maximum_pay
125: in per_salary_survey_lines.maximum_pay%TYPE,
126: p_graduate_pay
127: in per_salary_survey_lines.graduate_pay%TYPE,
128: p_starting_pay
129: in per_salary_survey_lines.starting_pay%TYPE,
123: in per_salary_survey_lines.mean_pay%TYPE,
124: p_maximum_pay
125: in per_salary_survey_lines.maximum_pay%TYPE,
126: p_graduate_pay
127: in per_salary_survey_lines.graduate_pay%TYPE,
128: p_starting_pay
129: in per_salary_survey_lines.starting_pay%TYPE,
130: p_percentage_change
131: in per_salary_survey_lines.percentage_change%TYPE,
125: in per_salary_survey_lines.maximum_pay%TYPE,
126: p_graduate_pay
127: in per_salary_survey_lines.graduate_pay%TYPE,
128: p_starting_pay
129: in per_salary_survey_lines.starting_pay%TYPE,
130: p_percentage_change
131: in per_salary_survey_lines.percentage_change%TYPE,
132: p_job_first_quartile
133: in per_salary_survey_lines.job_first_quartile%TYPE,
127: in per_salary_survey_lines.graduate_pay%TYPE,
128: p_starting_pay
129: in per_salary_survey_lines.starting_pay%TYPE,
130: p_percentage_change
131: in per_salary_survey_lines.percentage_change%TYPE,
132: p_job_first_quartile
133: in per_salary_survey_lines.job_first_quartile%TYPE,
134: p_job_median_quartile
135: in per_salary_survey_lines.job_median_quartile%TYPE,
129: in per_salary_survey_lines.starting_pay%TYPE,
130: p_percentage_change
131: in per_salary_survey_lines.percentage_change%TYPE,
132: p_job_first_quartile
133: in per_salary_survey_lines.job_first_quartile%TYPE,
134: p_job_median_quartile
135: in per_salary_survey_lines.job_median_quartile%TYPE,
136: p_job_third_quartile
137: in per_salary_survey_lines.job_third_quartile%TYPE,
131: in per_salary_survey_lines.percentage_change%TYPE,
132: p_job_first_quartile
133: in per_salary_survey_lines.job_first_quartile%TYPE,
134: p_job_median_quartile
135: in per_salary_survey_lines.job_median_quartile%TYPE,
136: p_job_third_quartile
137: in per_salary_survey_lines.job_third_quartile%TYPE,
138: p_job_fourth_quartile
139: in per_salary_survey_lines.job_fourth_quartile%TYPE,
133: in per_salary_survey_lines.job_first_quartile%TYPE,
134: p_job_median_quartile
135: in per_salary_survey_lines.job_median_quartile%TYPE,
136: p_job_third_quartile
137: in per_salary_survey_lines.job_third_quartile%TYPE,
138: p_job_fourth_quartile
139: in per_salary_survey_lines.job_fourth_quartile%TYPE,
140: p_minimum_total_compensation
141: in per_salary_survey_lines.minimum_total_compensation%TYPE,
135: in per_salary_survey_lines.job_median_quartile%TYPE,
136: p_job_third_quartile
137: in per_salary_survey_lines.job_third_quartile%TYPE,
138: p_job_fourth_quartile
139: in per_salary_survey_lines.job_fourth_quartile%TYPE,
140: p_minimum_total_compensation
141: in per_salary_survey_lines.minimum_total_compensation%TYPE,
142: p_mean_total_compensation
143: in per_salary_survey_lines.mean_total_compensation%TYPE,
137: in per_salary_survey_lines.job_third_quartile%TYPE,
138: p_job_fourth_quartile
139: in per_salary_survey_lines.job_fourth_quartile%TYPE,
140: p_minimum_total_compensation
141: in per_salary_survey_lines.minimum_total_compensation%TYPE,
142: p_mean_total_compensation
143: in per_salary_survey_lines.mean_total_compensation%TYPE,
144: p_maximum_total_compensation
145: in per_salary_survey_lines.maximum_total_compensation%TYPE,
139: in per_salary_survey_lines.job_fourth_quartile%TYPE,
140: p_minimum_total_compensation
141: in per_salary_survey_lines.minimum_total_compensation%TYPE,
142: p_mean_total_compensation
143: in per_salary_survey_lines.mean_total_compensation%TYPE,
144: p_maximum_total_compensation
145: in per_salary_survey_lines.maximum_total_compensation%TYPE,
146: p_compnstn_first_quartile
147: in per_salary_survey_lines.compnstn_first_quartile%TYPE,
141: in per_salary_survey_lines.minimum_total_compensation%TYPE,
142: p_mean_total_compensation
143: in per_salary_survey_lines.mean_total_compensation%TYPE,
144: p_maximum_total_compensation
145: in per_salary_survey_lines.maximum_total_compensation%TYPE,
146: p_compnstn_first_quartile
147: in per_salary_survey_lines.compnstn_first_quartile%TYPE,
148: p_compnstn_median_quartile
149: in per_salary_survey_lines.compnstn_median_quartile%TYPE,
143: in per_salary_survey_lines.mean_total_compensation%TYPE,
144: p_maximum_total_compensation
145: in per_salary_survey_lines.maximum_total_compensation%TYPE,
146: p_compnstn_first_quartile
147: in per_salary_survey_lines.compnstn_first_quartile%TYPE,
148: p_compnstn_median_quartile
149: in per_salary_survey_lines.compnstn_median_quartile%TYPE,
150: p_compnstn_third_quartile
151: in per_salary_survey_lines.compnstn_third_quartile%TYPE,
145: in per_salary_survey_lines.maximum_total_compensation%TYPE,
146: p_compnstn_first_quartile
147: in per_salary_survey_lines.compnstn_first_quartile%TYPE,
148: p_compnstn_median_quartile
149: in per_salary_survey_lines.compnstn_median_quartile%TYPE,
150: p_compnstn_third_quartile
151: in per_salary_survey_lines.compnstn_third_quartile%TYPE,
152: p_compnstn_fourth_quartile
153: in per_salary_survey_lines.compnstn_fourth_quartile%TYPE
147: in per_salary_survey_lines.compnstn_first_quartile%TYPE,
148: p_compnstn_median_quartile
149: in per_salary_survey_lines.compnstn_median_quartile%TYPE,
150: p_compnstn_third_quartile
151: in per_salary_survey_lines.compnstn_third_quartile%TYPE,
152: p_compnstn_fourth_quartile
153: in per_salary_survey_lines.compnstn_fourth_quartile%TYPE
154: );
155:
149: in per_salary_survey_lines.compnstn_median_quartile%TYPE,
150: p_compnstn_third_quartile
151: in per_salary_survey_lines.compnstn_third_quartile%TYPE,
152: p_compnstn_fourth_quartile
153: in per_salary_survey_lines.compnstn_fourth_quartile%TYPE
154: );
155:
156:
157: --