APPS.PER_SSL_DEL dependencies on PER_SSL_SHD

Line 51: Procedure delete_dml(p_rec in per_ssl_shd.g_rec_type) is

47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in per_ssl_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin

Line 68: per_ssl_shd.constraint_error

64: --
65: Exception
66: When hr_api.child_integrity_violated Then
67: -- Child integrity has been violated
68: per_ssl_shd.constraint_error
69: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
70: When Others Then
71: Raise;
72: End delete_dml;

Line 106: Procedure pre_delete(p_rec in per_ssl_shd.g_rec_type) is

102: -- Internal Row Handler Use Only.
103: --
104: -- {End Of Comments}
105: -- ----------------------------------------------------------------------------
106: Procedure pre_delete(p_rec in per_ssl_shd.g_rec_type) is
107: --
108: l_proc varchar2(72) := g_package||'pre_delete';
109: --
110: Begin

Line 148: Procedure post_delete(p_rec in per_ssl_shd.g_rec_type) is

144: -- Internal table Handler Use Only.
145: --
146: -- {End Of Comments}
147: -- ----------------------------------------------------------------------------
148: Procedure post_delete(p_rec in per_ssl_shd.g_rec_type) is
149: --
150: l_proc varchar2(72) := g_package||'post_delete';
151: --
152: Begin

Line 160: => per_ssl_shd.g_old_rec.object_version_number,

156: per_ssl_rkd.after_delete
157: (p_salary_survey_line_id
158: => p_rec.salary_survey_line_id,
159: p_object_version_number_o
160: => per_ssl_shd.g_old_rec.object_version_number,
161: p_salary_survey_id_o
162: => per_ssl_shd.g_old_rec.salary_survey_id,
163: p_survey_job_name_code_o
164: => per_ssl_shd.g_old_rec.survey_job_name_code,

Line 162: => per_ssl_shd.g_old_rec.salary_survey_id,

158: => p_rec.salary_survey_line_id,
159: p_object_version_number_o
160: => per_ssl_shd.g_old_rec.object_version_number,
161: p_salary_survey_id_o
162: => per_ssl_shd.g_old_rec.salary_survey_id,
163: p_survey_job_name_code_o
164: => per_ssl_shd.g_old_rec.survey_job_name_code,
165: p_survey_region_code_o
166: => per_ssl_shd.g_old_rec.survey_region_code,

Line 164: => per_ssl_shd.g_old_rec.survey_job_name_code,

160: => per_ssl_shd.g_old_rec.object_version_number,
161: p_salary_survey_id_o
162: => per_ssl_shd.g_old_rec.salary_survey_id,
163: p_survey_job_name_code_o
164: => per_ssl_shd.g_old_rec.survey_job_name_code,
165: p_survey_region_code_o
166: => per_ssl_shd.g_old_rec.survey_region_code,
167: p_survey_seniority_code_o
168: => per_ssl_shd.g_old_rec.survey_seniority_code,

Line 166: => per_ssl_shd.g_old_rec.survey_region_code,

162: => per_ssl_shd.g_old_rec.salary_survey_id,
163: p_survey_job_name_code_o
164: => per_ssl_shd.g_old_rec.survey_job_name_code,
165: p_survey_region_code_o
166: => per_ssl_shd.g_old_rec.survey_region_code,
167: p_survey_seniority_code_o
168: => per_ssl_shd.g_old_rec.survey_seniority_code,
169: p_company_size_code_o
170: => per_ssl_shd.g_old_rec.company_size_code,

Line 168: => per_ssl_shd.g_old_rec.survey_seniority_code,

164: => per_ssl_shd.g_old_rec.survey_job_name_code,
165: p_survey_region_code_o
166: => per_ssl_shd.g_old_rec.survey_region_code,
167: p_survey_seniority_code_o
168: => per_ssl_shd.g_old_rec.survey_seniority_code,
169: p_company_size_code_o
170: => per_ssl_shd.g_old_rec.company_size_code,
171: p_industry_code_o
172: => per_ssl_shd.g_old_rec.industry_code,

Line 170: => per_ssl_shd.g_old_rec.company_size_code,

166: => per_ssl_shd.g_old_rec.survey_region_code,
167: p_survey_seniority_code_o
168: => per_ssl_shd.g_old_rec.survey_seniority_code,
169: p_company_size_code_o
170: => per_ssl_shd.g_old_rec.company_size_code,
171: p_industry_code_o
172: => per_ssl_shd.g_old_rec.industry_code,
173: p_survey_age_code_o
174: => per_ssl_shd.g_old_rec.survey_age_code,

Line 172: => per_ssl_shd.g_old_rec.industry_code,

168: => per_ssl_shd.g_old_rec.survey_seniority_code,
169: p_company_size_code_o
170: => per_ssl_shd.g_old_rec.company_size_code,
171: p_industry_code_o
172: => per_ssl_shd.g_old_rec.industry_code,
173: p_survey_age_code_o
174: => per_ssl_shd.g_old_rec.survey_age_code,
175: p_start_date_o
176: => per_ssl_shd.g_old_rec.start_date,

Line 174: => per_ssl_shd.g_old_rec.survey_age_code,

170: => per_ssl_shd.g_old_rec.company_size_code,
171: p_industry_code_o
172: => per_ssl_shd.g_old_rec.industry_code,
173: p_survey_age_code_o
174: => per_ssl_shd.g_old_rec.survey_age_code,
175: p_start_date_o
176: => per_ssl_shd.g_old_rec.start_date,
177: p_end_date_o
178: => per_ssl_shd.g_old_rec.end_date,

Line 176: => per_ssl_shd.g_old_rec.start_date,

172: => per_ssl_shd.g_old_rec.industry_code,
173: p_survey_age_code_o
174: => per_ssl_shd.g_old_rec.survey_age_code,
175: p_start_date_o
176: => per_ssl_shd.g_old_rec.start_date,
177: p_end_date_o
178: => per_ssl_shd.g_old_rec.end_date,
179: p_currency_code_o
180: => per_ssl_shd.g_old_rec.currency_code,

Line 178: => per_ssl_shd.g_old_rec.end_date,

174: => per_ssl_shd.g_old_rec.survey_age_code,
175: p_start_date_o
176: => per_ssl_shd.g_old_rec.start_date,
177: p_end_date_o
178: => per_ssl_shd.g_old_rec.end_date,
179: p_currency_code_o
180: => per_ssl_shd.g_old_rec.currency_code,
181: p_differential_o
182: => per_ssl_shd.g_old_rec.differential,

Line 180: => per_ssl_shd.g_old_rec.currency_code,

176: => per_ssl_shd.g_old_rec.start_date,
177: p_end_date_o
178: => per_ssl_shd.g_old_rec.end_date,
179: p_currency_code_o
180: => per_ssl_shd.g_old_rec.currency_code,
181: p_differential_o
182: => per_ssl_shd.g_old_rec.differential,
183: p_minimum_pay_o
184: => per_ssl_shd.g_old_rec.minimum_pay,

Line 182: => per_ssl_shd.g_old_rec.differential,

178: => per_ssl_shd.g_old_rec.end_date,
179: p_currency_code_o
180: => per_ssl_shd.g_old_rec.currency_code,
181: p_differential_o
182: => per_ssl_shd.g_old_rec.differential,
183: p_minimum_pay_o
184: => per_ssl_shd.g_old_rec.minimum_pay,
185: p_mean_pay_o
186: => per_ssl_shd.g_old_rec.mean_pay,

Line 184: => per_ssl_shd.g_old_rec.minimum_pay,

180: => per_ssl_shd.g_old_rec.currency_code,
181: p_differential_o
182: => per_ssl_shd.g_old_rec.differential,
183: p_minimum_pay_o
184: => per_ssl_shd.g_old_rec.minimum_pay,
185: p_mean_pay_o
186: => per_ssl_shd.g_old_rec.mean_pay,
187: p_maximum_pay_o
188: => per_ssl_shd.g_old_rec.maximum_pay,

Line 186: => per_ssl_shd.g_old_rec.mean_pay,

182: => per_ssl_shd.g_old_rec.differential,
183: p_minimum_pay_o
184: => per_ssl_shd.g_old_rec.minimum_pay,
185: p_mean_pay_o
186: => per_ssl_shd.g_old_rec.mean_pay,
187: p_maximum_pay_o
188: => per_ssl_shd.g_old_rec.maximum_pay,
189: p_graduate_pay_o
190: => per_ssl_shd.g_old_rec.graduate_pay,

Line 188: => per_ssl_shd.g_old_rec.maximum_pay,

184: => per_ssl_shd.g_old_rec.minimum_pay,
185: p_mean_pay_o
186: => per_ssl_shd.g_old_rec.mean_pay,
187: p_maximum_pay_o
188: => per_ssl_shd.g_old_rec.maximum_pay,
189: p_graduate_pay_o
190: => per_ssl_shd.g_old_rec.graduate_pay,
191: p_starting_pay_o
192: => per_ssl_shd.g_old_rec.starting_pay,

Line 190: => per_ssl_shd.g_old_rec.graduate_pay,

186: => per_ssl_shd.g_old_rec.mean_pay,
187: p_maximum_pay_o
188: => per_ssl_shd.g_old_rec.maximum_pay,
189: p_graduate_pay_o
190: => per_ssl_shd.g_old_rec.graduate_pay,
191: p_starting_pay_o
192: => per_ssl_shd.g_old_rec.starting_pay,
193: p_percentage_change_o
194: => per_ssl_shd.g_old_rec.percentage_change,

Line 192: => per_ssl_shd.g_old_rec.starting_pay,

188: => per_ssl_shd.g_old_rec.maximum_pay,
189: p_graduate_pay_o
190: => per_ssl_shd.g_old_rec.graduate_pay,
191: p_starting_pay_o
192: => per_ssl_shd.g_old_rec.starting_pay,
193: p_percentage_change_o
194: => per_ssl_shd.g_old_rec.percentage_change,
195: p_job_first_quartile_o
196: => per_ssl_shd.g_old_rec.job_first_quartile,

Line 194: => per_ssl_shd.g_old_rec.percentage_change,

190: => per_ssl_shd.g_old_rec.graduate_pay,
191: p_starting_pay_o
192: => per_ssl_shd.g_old_rec.starting_pay,
193: p_percentage_change_o
194: => per_ssl_shd.g_old_rec.percentage_change,
195: p_job_first_quartile_o
196: => per_ssl_shd.g_old_rec.job_first_quartile,
197: p_job_median_quartile_o
198: => per_ssl_shd.g_old_rec.job_median_quartile,

Line 196: => per_ssl_shd.g_old_rec.job_first_quartile,

192: => per_ssl_shd.g_old_rec.starting_pay,
193: p_percentage_change_o
194: => per_ssl_shd.g_old_rec.percentage_change,
195: p_job_first_quartile_o
196: => per_ssl_shd.g_old_rec.job_first_quartile,
197: p_job_median_quartile_o
198: => per_ssl_shd.g_old_rec.job_median_quartile,
199: p_job_third_quartile_o
200: => per_ssl_shd.g_old_rec.job_third_quartile,

Line 198: => per_ssl_shd.g_old_rec.job_median_quartile,

194: => per_ssl_shd.g_old_rec.percentage_change,
195: p_job_first_quartile_o
196: => per_ssl_shd.g_old_rec.job_first_quartile,
197: p_job_median_quartile_o
198: => per_ssl_shd.g_old_rec.job_median_quartile,
199: p_job_third_quartile_o
200: => per_ssl_shd.g_old_rec.job_third_quartile,
201: p_job_fourth_quartile_o
202: => per_ssl_shd.g_old_rec.job_fourth_quartile,

Line 200: => per_ssl_shd.g_old_rec.job_third_quartile,

196: => per_ssl_shd.g_old_rec.job_first_quartile,
197: p_job_median_quartile_o
198: => per_ssl_shd.g_old_rec.job_median_quartile,
199: p_job_third_quartile_o
200: => per_ssl_shd.g_old_rec.job_third_quartile,
201: p_job_fourth_quartile_o
202: => per_ssl_shd.g_old_rec.job_fourth_quartile,
203: p_minimum_total_compensation_o
204: => per_ssl_shd.g_old_rec.minimum_total_compensation,

Line 202: => per_ssl_shd.g_old_rec.job_fourth_quartile,

198: => per_ssl_shd.g_old_rec.job_median_quartile,
199: p_job_third_quartile_o
200: => per_ssl_shd.g_old_rec.job_third_quartile,
201: p_job_fourth_quartile_o
202: => per_ssl_shd.g_old_rec.job_fourth_quartile,
203: p_minimum_total_compensation_o
204: => per_ssl_shd.g_old_rec.minimum_total_compensation,
205: p_mean_total_compensation_o
206: => per_ssl_shd.g_old_rec.mean_total_compensation,

Line 204: => per_ssl_shd.g_old_rec.minimum_total_compensation,

200: => per_ssl_shd.g_old_rec.job_third_quartile,
201: p_job_fourth_quartile_o
202: => per_ssl_shd.g_old_rec.job_fourth_quartile,
203: p_minimum_total_compensation_o
204: => per_ssl_shd.g_old_rec.minimum_total_compensation,
205: p_mean_total_compensation_o
206: => per_ssl_shd.g_old_rec.mean_total_compensation,
207: p_maximum_total_compensation_o
208: => per_ssl_shd.g_old_rec.maximum_total_compensation,

Line 206: => per_ssl_shd.g_old_rec.mean_total_compensation,

202: => per_ssl_shd.g_old_rec.job_fourth_quartile,
203: p_minimum_total_compensation_o
204: => per_ssl_shd.g_old_rec.minimum_total_compensation,
205: p_mean_total_compensation_o
206: => per_ssl_shd.g_old_rec.mean_total_compensation,
207: p_maximum_total_compensation_o
208: => per_ssl_shd.g_old_rec.maximum_total_compensation,
209: p_compnstn_first_quartile_o
210: => per_ssl_shd.g_old_rec.compnstn_first_quartile,

Line 208: => per_ssl_shd.g_old_rec.maximum_total_compensation,

204: => per_ssl_shd.g_old_rec.minimum_total_compensation,
205: p_mean_total_compensation_o
206: => per_ssl_shd.g_old_rec.mean_total_compensation,
207: p_maximum_total_compensation_o
208: => per_ssl_shd.g_old_rec.maximum_total_compensation,
209: p_compnstn_first_quartile_o
210: => per_ssl_shd.g_old_rec.compnstn_first_quartile,
211: p_compnstn_median_quartile_o
212: => per_ssl_shd.g_old_rec.compnstn_median_quartile,

Line 210: => per_ssl_shd.g_old_rec.compnstn_first_quartile,

206: => per_ssl_shd.g_old_rec.mean_total_compensation,
207: p_maximum_total_compensation_o
208: => per_ssl_shd.g_old_rec.maximum_total_compensation,
209: p_compnstn_first_quartile_o
210: => per_ssl_shd.g_old_rec.compnstn_first_quartile,
211: p_compnstn_median_quartile_o
212: => per_ssl_shd.g_old_rec.compnstn_median_quartile,
213: p_compnstn_third_quartile_o
214: => per_ssl_shd.g_old_rec.compnstn_third_quartile,

Line 212: => per_ssl_shd.g_old_rec.compnstn_median_quartile,

208: => per_ssl_shd.g_old_rec.maximum_total_compensation,
209: p_compnstn_first_quartile_o
210: => per_ssl_shd.g_old_rec.compnstn_first_quartile,
211: p_compnstn_median_quartile_o
212: => per_ssl_shd.g_old_rec.compnstn_median_quartile,
213: p_compnstn_third_quartile_o
214: => per_ssl_shd.g_old_rec.compnstn_third_quartile,
215: p_compnstn_fourth_quartile_o
216: => per_ssl_shd.g_old_rec.compnstn_fourth_quartile,

Line 214: => per_ssl_shd.g_old_rec.compnstn_third_quartile,

210: => per_ssl_shd.g_old_rec.compnstn_first_quartile,
211: p_compnstn_median_quartile_o
212: => per_ssl_shd.g_old_rec.compnstn_median_quartile,
213: p_compnstn_third_quartile_o
214: => per_ssl_shd.g_old_rec.compnstn_third_quartile,
215: p_compnstn_fourth_quartile_o
216: => per_ssl_shd.g_old_rec.compnstn_fourth_quartile,
217: /*Added for Enhancement 4021737 */
218: p_tenth_percentile_o

Line 216: => per_ssl_shd.g_old_rec.compnstn_fourth_quartile,

212: => per_ssl_shd.g_old_rec.compnstn_median_quartile,
213: p_compnstn_third_quartile_o
214: => per_ssl_shd.g_old_rec.compnstn_third_quartile,
215: p_compnstn_fourth_quartile_o
216: => per_ssl_shd.g_old_rec.compnstn_fourth_quartile,
217: /*Added for Enhancement 4021737 */
218: p_tenth_percentile_o
219: => per_ssl_shd.g_old_rec.tenth_percentile,
220: p_twenty_fifth_percentile_o

Line 219: => per_ssl_shd.g_old_rec.tenth_percentile,

215: p_compnstn_fourth_quartile_o
216: => per_ssl_shd.g_old_rec.compnstn_fourth_quartile,
217: /*Added for Enhancement 4021737 */
218: p_tenth_percentile_o
219: => per_ssl_shd.g_old_rec.tenth_percentile,
220: p_twenty_fifth_percentile_o
221: => per_ssl_shd.g_old_rec.twenty_fifth_percentile,
222: p_fiftieth_percentile_o
223: => per_ssl_shd.g_old_rec.fiftieth_percentile,

Line 221: => per_ssl_shd.g_old_rec.twenty_fifth_percentile,

217: /*Added for Enhancement 4021737 */
218: p_tenth_percentile_o
219: => per_ssl_shd.g_old_rec.tenth_percentile,
220: p_twenty_fifth_percentile_o
221: => per_ssl_shd.g_old_rec.twenty_fifth_percentile,
222: p_fiftieth_percentile_o
223: => per_ssl_shd.g_old_rec.fiftieth_percentile,
224: p_seventy_fifth_percentile_o
225: => per_ssl_shd.g_old_rec.seventy_fifth_percentile,

Line 223: => per_ssl_shd.g_old_rec.fiftieth_percentile,

219: => per_ssl_shd.g_old_rec.tenth_percentile,
220: p_twenty_fifth_percentile_o
221: => per_ssl_shd.g_old_rec.twenty_fifth_percentile,
222: p_fiftieth_percentile_o
223: => per_ssl_shd.g_old_rec.fiftieth_percentile,
224: p_seventy_fifth_percentile_o
225: => per_ssl_shd.g_old_rec.seventy_fifth_percentile,
226: p_ninetieth_percentile_o
227: => per_ssl_shd.g_old_rec.ninetieth_percentile,

Line 225: => per_ssl_shd.g_old_rec.seventy_fifth_percentile,

221: => per_ssl_shd.g_old_rec.twenty_fifth_percentile,
222: p_fiftieth_percentile_o
223: => per_ssl_shd.g_old_rec.fiftieth_percentile,
224: p_seventy_fifth_percentile_o
225: => per_ssl_shd.g_old_rec.seventy_fifth_percentile,
226: p_ninetieth_percentile_o
227: => per_ssl_shd.g_old_rec.ninetieth_percentile,
228: p_minimum_bonus_o
229: => per_ssl_shd.g_old_rec.minimum_bonus,

Line 227: => per_ssl_shd.g_old_rec.ninetieth_percentile,

223: => per_ssl_shd.g_old_rec.fiftieth_percentile,
224: p_seventy_fifth_percentile_o
225: => per_ssl_shd.g_old_rec.seventy_fifth_percentile,
226: p_ninetieth_percentile_o
227: => per_ssl_shd.g_old_rec.ninetieth_percentile,
228: p_minimum_bonus_o
229: => per_ssl_shd.g_old_rec.minimum_bonus,
230: p_mean_bonus_o
231: => per_ssl_shd.g_old_rec.mean_bonus,

Line 229: => per_ssl_shd.g_old_rec.minimum_bonus,

225: => per_ssl_shd.g_old_rec.seventy_fifth_percentile,
226: p_ninetieth_percentile_o
227: => per_ssl_shd.g_old_rec.ninetieth_percentile,
228: p_minimum_bonus_o
229: => per_ssl_shd.g_old_rec.minimum_bonus,
230: p_mean_bonus_o
231: => per_ssl_shd.g_old_rec.mean_bonus,
232: p_maximum_bonus_o
233: => per_ssl_shd.g_old_rec.maximum_bonus,

Line 231: => per_ssl_shd.g_old_rec.mean_bonus,

227: => per_ssl_shd.g_old_rec.ninetieth_percentile,
228: p_minimum_bonus_o
229: => per_ssl_shd.g_old_rec.minimum_bonus,
230: p_mean_bonus_o
231: => per_ssl_shd.g_old_rec.mean_bonus,
232: p_maximum_bonus_o
233: => per_ssl_shd.g_old_rec.maximum_bonus,
234: p_minimum_salary_increase_o
235: => per_ssl_shd.g_old_rec.minimum_salary_increase,

Line 233: => per_ssl_shd.g_old_rec.maximum_bonus,

229: => per_ssl_shd.g_old_rec.minimum_bonus,
230: p_mean_bonus_o
231: => per_ssl_shd.g_old_rec.mean_bonus,
232: p_maximum_bonus_o
233: => per_ssl_shd.g_old_rec.maximum_bonus,
234: p_minimum_salary_increase_o
235: => per_ssl_shd.g_old_rec.minimum_salary_increase,
236: p_mean_salary_increase_o
237: => per_ssl_shd.g_old_rec.mean_salary_increase,

Line 235: => per_ssl_shd.g_old_rec.minimum_salary_increase,

231: => per_ssl_shd.g_old_rec.mean_bonus,
232: p_maximum_bonus_o
233: => per_ssl_shd.g_old_rec.maximum_bonus,
234: p_minimum_salary_increase_o
235: => per_ssl_shd.g_old_rec.minimum_salary_increase,
236: p_mean_salary_increase_o
237: => per_ssl_shd.g_old_rec.mean_salary_increase,
238: p_maximum_salary_increase_o
239: => per_ssl_shd.g_old_rec.maximum_salary_increase,

Line 237: => per_ssl_shd.g_old_rec.mean_salary_increase,

233: => per_ssl_shd.g_old_rec.maximum_bonus,
234: p_minimum_salary_increase_o
235: => per_ssl_shd.g_old_rec.minimum_salary_increase,
236: p_mean_salary_increase_o
237: => per_ssl_shd.g_old_rec.mean_salary_increase,
238: p_maximum_salary_increase_o
239: => per_ssl_shd.g_old_rec.maximum_salary_increase,
240: p_min_variable_compensation_o
241: => per_ssl_shd.g_old_rec.min_variable_compensation,

Line 239: => per_ssl_shd.g_old_rec.maximum_salary_increase,

235: => per_ssl_shd.g_old_rec.minimum_salary_increase,
236: p_mean_salary_increase_o
237: => per_ssl_shd.g_old_rec.mean_salary_increase,
238: p_maximum_salary_increase_o
239: => per_ssl_shd.g_old_rec.maximum_salary_increase,
240: p_min_variable_compensation_o
241: => per_ssl_shd.g_old_rec.min_variable_compensation,
242: p_mean_variable_compensation_o
243: => per_ssl_shd.g_old_rec.mean_variable_compensation,

Line 241: => per_ssl_shd.g_old_rec.min_variable_compensation,

237: => per_ssl_shd.g_old_rec.mean_salary_increase,
238: p_maximum_salary_increase_o
239: => per_ssl_shd.g_old_rec.maximum_salary_increase,
240: p_min_variable_compensation_o
241: => per_ssl_shd.g_old_rec.min_variable_compensation,
242: p_mean_variable_compensation_o
243: => per_ssl_shd.g_old_rec.mean_variable_compensation,
244: p_max_variable_compensation_o
245: => per_ssl_shd.g_old_rec.max_variable_compensation,

Line 243: => per_ssl_shd.g_old_rec.mean_variable_compensation,

239: => per_ssl_shd.g_old_rec.maximum_salary_increase,
240: p_min_variable_compensation_o
241: => per_ssl_shd.g_old_rec.min_variable_compensation,
242: p_mean_variable_compensation_o
243: => per_ssl_shd.g_old_rec.mean_variable_compensation,
244: p_max_variable_compensation_o
245: => per_ssl_shd.g_old_rec.max_variable_compensation,
246: p_minimum_stock_o
247: => per_ssl_shd.g_old_rec.minimum_stock,

Line 245: => per_ssl_shd.g_old_rec.max_variable_compensation,

241: => per_ssl_shd.g_old_rec.min_variable_compensation,
242: p_mean_variable_compensation_o
243: => per_ssl_shd.g_old_rec.mean_variable_compensation,
244: p_max_variable_compensation_o
245: => per_ssl_shd.g_old_rec.max_variable_compensation,
246: p_minimum_stock_o
247: => per_ssl_shd.g_old_rec.minimum_stock,
248: p_mean_stock_o
249: => per_ssl_shd.g_old_rec.mean_stock,

Line 247: => per_ssl_shd.g_old_rec.minimum_stock,

243: => per_ssl_shd.g_old_rec.mean_variable_compensation,
244: p_max_variable_compensation_o
245: => per_ssl_shd.g_old_rec.max_variable_compensation,
246: p_minimum_stock_o
247: => per_ssl_shd.g_old_rec.minimum_stock,
248: p_mean_stock_o
249: => per_ssl_shd.g_old_rec.mean_stock,
250: p_maximum_stock_o
251: => per_ssl_shd.g_old_rec.maximum_stock,

Line 249: => per_ssl_shd.g_old_rec.mean_stock,

245: => per_ssl_shd.g_old_rec.max_variable_compensation,
246: p_minimum_stock_o
247: => per_ssl_shd.g_old_rec.minimum_stock,
248: p_mean_stock_o
249: => per_ssl_shd.g_old_rec.mean_stock,
250: p_maximum_stock_o
251: => per_ssl_shd.g_old_rec.maximum_stock,
252: p_stock_display_type_o
253: => per_ssl_shd.g_old_rec.stock_display_type,

Line 251: => per_ssl_shd.g_old_rec.maximum_stock,

247: => per_ssl_shd.g_old_rec.minimum_stock,
248: p_mean_stock_o
249: => per_ssl_shd.g_old_rec.mean_stock,
250: p_maximum_stock_o
251: => per_ssl_shd.g_old_rec.maximum_stock,
252: p_stock_display_type_o
253: => per_ssl_shd.g_old_rec.stock_display_type,
254: /*End Enhancement 4021737 */
255: p_attribute_category_o

Line 253: => per_ssl_shd.g_old_rec.stock_display_type,

249: => per_ssl_shd.g_old_rec.mean_stock,
250: p_maximum_stock_o
251: => per_ssl_shd.g_old_rec.maximum_stock,
252: p_stock_display_type_o
253: => per_ssl_shd.g_old_rec.stock_display_type,
254: /*End Enhancement 4021737 */
255: p_attribute_category_o
256: => per_ssl_shd.g_old_rec.attribute_category,
257: p_attribute1_o

Line 256: => per_ssl_shd.g_old_rec.attribute_category,

252: p_stock_display_type_o
253: => per_ssl_shd.g_old_rec.stock_display_type,
254: /*End Enhancement 4021737 */
255: p_attribute_category_o
256: => per_ssl_shd.g_old_rec.attribute_category,
257: p_attribute1_o
258: => per_ssl_shd.g_old_rec.attribute1,
259: p_attribute2_o
260: => per_ssl_shd.g_old_rec.attribute2,

Line 258: => per_ssl_shd.g_old_rec.attribute1,

254: /*End Enhancement 4021737 */
255: p_attribute_category_o
256: => per_ssl_shd.g_old_rec.attribute_category,
257: p_attribute1_o
258: => per_ssl_shd.g_old_rec.attribute1,
259: p_attribute2_o
260: => per_ssl_shd.g_old_rec.attribute2,
261: p_attribute3_o
262: => per_ssl_shd.g_old_rec.attribute3,

Line 260: => per_ssl_shd.g_old_rec.attribute2,

256: => per_ssl_shd.g_old_rec.attribute_category,
257: p_attribute1_o
258: => per_ssl_shd.g_old_rec.attribute1,
259: p_attribute2_o
260: => per_ssl_shd.g_old_rec.attribute2,
261: p_attribute3_o
262: => per_ssl_shd.g_old_rec.attribute3,
263: p_attribute4_o
264: => per_ssl_shd.g_old_rec.attribute4,

Line 262: => per_ssl_shd.g_old_rec.attribute3,

258: => per_ssl_shd.g_old_rec.attribute1,
259: p_attribute2_o
260: => per_ssl_shd.g_old_rec.attribute2,
261: p_attribute3_o
262: => per_ssl_shd.g_old_rec.attribute3,
263: p_attribute4_o
264: => per_ssl_shd.g_old_rec.attribute4,
265: p_attribute5_o
266: => per_ssl_shd.g_old_rec.attribute5,

Line 264: => per_ssl_shd.g_old_rec.attribute4,

260: => per_ssl_shd.g_old_rec.attribute2,
261: p_attribute3_o
262: => per_ssl_shd.g_old_rec.attribute3,
263: p_attribute4_o
264: => per_ssl_shd.g_old_rec.attribute4,
265: p_attribute5_o
266: => per_ssl_shd.g_old_rec.attribute5,
267: p_attribute6_o
268: => per_ssl_shd.g_old_rec.attribute6,

Line 266: => per_ssl_shd.g_old_rec.attribute5,

262: => per_ssl_shd.g_old_rec.attribute3,
263: p_attribute4_o
264: => per_ssl_shd.g_old_rec.attribute4,
265: p_attribute5_o
266: => per_ssl_shd.g_old_rec.attribute5,
267: p_attribute6_o
268: => per_ssl_shd.g_old_rec.attribute6,
269: p_attribute7_o
270: => per_ssl_shd.g_old_rec.attribute7,

Line 268: => per_ssl_shd.g_old_rec.attribute6,

264: => per_ssl_shd.g_old_rec.attribute4,
265: p_attribute5_o
266: => per_ssl_shd.g_old_rec.attribute5,
267: p_attribute6_o
268: => per_ssl_shd.g_old_rec.attribute6,
269: p_attribute7_o
270: => per_ssl_shd.g_old_rec.attribute7,
271: p_attribute8_o
272: => per_ssl_shd.g_old_rec.attribute8,

Line 270: => per_ssl_shd.g_old_rec.attribute7,

266: => per_ssl_shd.g_old_rec.attribute5,
267: p_attribute6_o
268: => per_ssl_shd.g_old_rec.attribute6,
269: p_attribute7_o
270: => per_ssl_shd.g_old_rec.attribute7,
271: p_attribute8_o
272: => per_ssl_shd.g_old_rec.attribute8,
273: p_attribute9_o
274: => per_ssl_shd.g_old_rec.attribute9,

Line 272: => per_ssl_shd.g_old_rec.attribute8,

268: => per_ssl_shd.g_old_rec.attribute6,
269: p_attribute7_o
270: => per_ssl_shd.g_old_rec.attribute7,
271: p_attribute8_o
272: => per_ssl_shd.g_old_rec.attribute8,
273: p_attribute9_o
274: => per_ssl_shd.g_old_rec.attribute9,
275: p_attribute10_o
276: => per_ssl_shd.g_old_rec.attribute10,

Line 274: => per_ssl_shd.g_old_rec.attribute9,

270: => per_ssl_shd.g_old_rec.attribute7,
271: p_attribute8_o
272: => per_ssl_shd.g_old_rec.attribute8,
273: p_attribute9_o
274: => per_ssl_shd.g_old_rec.attribute9,
275: p_attribute10_o
276: => per_ssl_shd.g_old_rec.attribute10,
277: p_attribute11_o
278: => per_ssl_shd.g_old_rec.attribute11,

Line 276: => per_ssl_shd.g_old_rec.attribute10,

272: => per_ssl_shd.g_old_rec.attribute8,
273: p_attribute9_o
274: => per_ssl_shd.g_old_rec.attribute9,
275: p_attribute10_o
276: => per_ssl_shd.g_old_rec.attribute10,
277: p_attribute11_o
278: => per_ssl_shd.g_old_rec.attribute11,
279: p_attribute12_o
280: => per_ssl_shd.g_old_rec.attribute12,

Line 278: => per_ssl_shd.g_old_rec.attribute11,

274: => per_ssl_shd.g_old_rec.attribute9,
275: p_attribute10_o
276: => per_ssl_shd.g_old_rec.attribute10,
277: p_attribute11_o
278: => per_ssl_shd.g_old_rec.attribute11,
279: p_attribute12_o
280: => per_ssl_shd.g_old_rec.attribute12,
281: p_attribute13_o
282: => per_ssl_shd.g_old_rec.attribute13,

Line 280: => per_ssl_shd.g_old_rec.attribute12,

276: => per_ssl_shd.g_old_rec.attribute10,
277: p_attribute11_o
278: => per_ssl_shd.g_old_rec.attribute11,
279: p_attribute12_o
280: => per_ssl_shd.g_old_rec.attribute12,
281: p_attribute13_o
282: => per_ssl_shd.g_old_rec.attribute13,
283: p_attribute14_o
284: => per_ssl_shd.g_old_rec.attribute14,

Line 282: => per_ssl_shd.g_old_rec.attribute13,

278: => per_ssl_shd.g_old_rec.attribute11,
279: p_attribute12_o
280: => per_ssl_shd.g_old_rec.attribute12,
281: p_attribute13_o
282: => per_ssl_shd.g_old_rec.attribute13,
283: p_attribute14_o
284: => per_ssl_shd.g_old_rec.attribute14,
285: p_attribute15_o
286: => per_ssl_shd.g_old_rec.attribute15,

Line 284: => per_ssl_shd.g_old_rec.attribute14,

280: => per_ssl_shd.g_old_rec.attribute12,
281: p_attribute13_o
282: => per_ssl_shd.g_old_rec.attribute13,
283: p_attribute14_o
284: => per_ssl_shd.g_old_rec.attribute14,
285: p_attribute15_o
286: => per_ssl_shd.g_old_rec.attribute15,
287: p_attribute16_o
288: => per_ssl_shd.g_old_rec.attribute16,

Line 286: => per_ssl_shd.g_old_rec.attribute15,

282: => per_ssl_shd.g_old_rec.attribute13,
283: p_attribute14_o
284: => per_ssl_shd.g_old_rec.attribute14,
285: p_attribute15_o
286: => per_ssl_shd.g_old_rec.attribute15,
287: p_attribute16_o
288: => per_ssl_shd.g_old_rec.attribute16,
289: p_attribute17_o
290: => per_ssl_shd.g_old_rec.attribute17,

Line 288: => per_ssl_shd.g_old_rec.attribute16,

284: => per_ssl_shd.g_old_rec.attribute14,
285: p_attribute15_o
286: => per_ssl_shd.g_old_rec.attribute15,
287: p_attribute16_o
288: => per_ssl_shd.g_old_rec.attribute16,
289: p_attribute17_o
290: => per_ssl_shd.g_old_rec.attribute17,
291: p_attribute18_o
292: => per_ssl_shd.g_old_rec.attribute18,

Line 290: => per_ssl_shd.g_old_rec.attribute17,

286: => per_ssl_shd.g_old_rec.attribute15,
287: p_attribute16_o
288: => per_ssl_shd.g_old_rec.attribute16,
289: p_attribute17_o
290: => per_ssl_shd.g_old_rec.attribute17,
291: p_attribute18_o
292: => per_ssl_shd.g_old_rec.attribute18,
293: p_attribute19_o
294: => per_ssl_shd.g_old_rec.attribute19,

Line 292: => per_ssl_shd.g_old_rec.attribute18,

288: => per_ssl_shd.g_old_rec.attribute16,
289: p_attribute17_o
290: => per_ssl_shd.g_old_rec.attribute17,
291: p_attribute18_o
292: => per_ssl_shd.g_old_rec.attribute18,
293: p_attribute19_o
294: => per_ssl_shd.g_old_rec.attribute19,
295: p_attribute20_o
296: => per_ssl_shd.g_old_rec.attribute20,

Line 294: => per_ssl_shd.g_old_rec.attribute19,

290: => per_ssl_shd.g_old_rec.attribute17,
291: p_attribute18_o
292: => per_ssl_shd.g_old_rec.attribute18,
293: p_attribute19_o
294: => per_ssl_shd.g_old_rec.attribute19,
295: p_attribute20_o
296: => per_ssl_shd.g_old_rec.attribute20,
297: /*Added for Enhancement 4021737 */
298: p_attribute21_o

Line 296: => per_ssl_shd.g_old_rec.attribute20,

292: => per_ssl_shd.g_old_rec.attribute18,
293: p_attribute19_o
294: => per_ssl_shd.g_old_rec.attribute19,
295: p_attribute20_o
296: => per_ssl_shd.g_old_rec.attribute20,
297: /*Added for Enhancement 4021737 */
298: p_attribute21_o
299: => per_ssl_shd.g_old_rec.attribute21,
300: p_attribute22_o

Line 299: => per_ssl_shd.g_old_rec.attribute21,

295: p_attribute20_o
296: => per_ssl_shd.g_old_rec.attribute20,
297: /*Added for Enhancement 4021737 */
298: p_attribute21_o
299: => per_ssl_shd.g_old_rec.attribute21,
300: p_attribute22_o
301: => per_ssl_shd.g_old_rec.attribute22,
302: p_attribute23_o
303: => per_ssl_shd.g_old_rec.attribute23,

Line 301: => per_ssl_shd.g_old_rec.attribute22,

297: /*Added for Enhancement 4021737 */
298: p_attribute21_o
299: => per_ssl_shd.g_old_rec.attribute21,
300: p_attribute22_o
301: => per_ssl_shd.g_old_rec.attribute22,
302: p_attribute23_o
303: => per_ssl_shd.g_old_rec.attribute23,
304: p_attribute24_o
305: => per_ssl_shd.g_old_rec.attribute24,

Line 303: => per_ssl_shd.g_old_rec.attribute23,

299: => per_ssl_shd.g_old_rec.attribute21,
300: p_attribute22_o
301: => per_ssl_shd.g_old_rec.attribute22,
302: p_attribute23_o
303: => per_ssl_shd.g_old_rec.attribute23,
304: p_attribute24_o
305: => per_ssl_shd.g_old_rec.attribute24,
306: p_attribute25_o
307: => per_ssl_shd.g_old_rec.attribute25,

Line 305: => per_ssl_shd.g_old_rec.attribute24,

301: => per_ssl_shd.g_old_rec.attribute22,
302: p_attribute23_o
303: => per_ssl_shd.g_old_rec.attribute23,
304: p_attribute24_o
305: => per_ssl_shd.g_old_rec.attribute24,
306: p_attribute25_o
307: => per_ssl_shd.g_old_rec.attribute25,
308: p_attribute26_o
309: => per_ssl_shd.g_old_rec.attribute26,

Line 307: => per_ssl_shd.g_old_rec.attribute25,

303: => per_ssl_shd.g_old_rec.attribute23,
304: p_attribute24_o
305: => per_ssl_shd.g_old_rec.attribute24,
306: p_attribute25_o
307: => per_ssl_shd.g_old_rec.attribute25,
308: p_attribute26_o
309: => per_ssl_shd.g_old_rec.attribute26,
310: p_attribute27_o
311: => per_ssl_shd.g_old_rec.attribute27,

Line 309: => per_ssl_shd.g_old_rec.attribute26,

305: => per_ssl_shd.g_old_rec.attribute24,
306: p_attribute25_o
307: => per_ssl_shd.g_old_rec.attribute25,
308: p_attribute26_o
309: => per_ssl_shd.g_old_rec.attribute26,
310: p_attribute27_o
311: => per_ssl_shd.g_old_rec.attribute27,
312: p_attribute28_o
313: => per_ssl_shd.g_old_rec.attribute28,

Line 311: => per_ssl_shd.g_old_rec.attribute27,

307: => per_ssl_shd.g_old_rec.attribute25,
308: p_attribute26_o
309: => per_ssl_shd.g_old_rec.attribute26,
310: p_attribute27_o
311: => per_ssl_shd.g_old_rec.attribute27,
312: p_attribute28_o
313: => per_ssl_shd.g_old_rec.attribute28,
314: p_attribute29_o
315: => per_ssl_shd.g_old_rec.attribute29,

Line 313: => per_ssl_shd.g_old_rec.attribute28,

309: => per_ssl_shd.g_old_rec.attribute26,
310: p_attribute27_o
311: => per_ssl_shd.g_old_rec.attribute27,
312: p_attribute28_o
313: => per_ssl_shd.g_old_rec.attribute28,
314: p_attribute29_o
315: => per_ssl_shd.g_old_rec.attribute29,
316: p_attribute30_o
317: => per_ssl_shd.g_old_rec.attribute30

Line 315: => per_ssl_shd.g_old_rec.attribute29,

311: => per_ssl_shd.g_old_rec.attribute27,
312: p_attribute28_o
313: => per_ssl_shd.g_old_rec.attribute28,
314: p_attribute29_o
315: => per_ssl_shd.g_old_rec.attribute29,
316: p_attribute30_o
317: => per_ssl_shd.g_old_rec.attribute30
318: /*End Enhancement 4021737 */
319: );

Line 317: => per_ssl_shd.g_old_rec.attribute30

313: => per_ssl_shd.g_old_rec.attribute28,
314: p_attribute29_o
315: => per_ssl_shd.g_old_rec.attribute29,
316: p_attribute30_o
317: => per_ssl_shd.g_old_rec.attribute30
318: /*End Enhancement 4021737 */
319: );
320:
321: exception

Line 338: p_rec in per_ssl_shd.g_rec_type

334: -- |---------------------------------< del >----------------------------------|
335: -- ----------------------------------------------------------------------------
336: Procedure del
337: (
338: p_rec in per_ssl_shd.g_rec_type
339: ) is
340: --
341: l_proc varchar2(72) := g_package||'del';
342: --

Line 348: per_ssl_shd.lck

344: hr_utility.set_location('Entering:'||l_proc, 5);
345: --
346: -- We must lock the row which we need to delete.
347: --
348: per_ssl_shd.lck
349: (
350: p_rec.salary_survey_line_id,
351: p_rec.object_version_number
352: );

Line 380: l_rec per_ssl_shd.g_rec_type;

376: p_salary_survey_line_id in number,
377: p_object_version_number in number
378: ) is
379: --
380: l_rec per_ssl_shd.g_rec_type;
381: l_proc varchar2(72) := g_package||'del';
382: --
383: Begin
384: hr_utility.set_location('Entering:'||l_proc, 5);