[Home] [Help]
PACKAGE BODY: APPS.PER_SSL_UPD
Source
1 Package Body per_ssl_upd as
2 /* $Header: pesslrhi.pkb 120.0.12010000.2 2008/09/09 11:18:51 pchowdav ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' per_ssl_upd.'; -- Global package name
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------------< update_dml >------------------------------|
12 -- ----------------------------------------------------------------------------
13 -- {Start Of Comments}
14 --
15 -- Description:
16 -- This Procedure controls the actual dml update logic. The processing of
17 -- this Procedure is:
18 -- 1) Increment the object_version_number by 1 If the object_version_number
19 -- is defined as an attribute for this entity.
20 -- 2) To set and unset the g_api_dml status as required (as we are about to
21 -- perform dml).
22 -- 3) To update the specIfied row in the schema using the primary key in
23 -- the predicates.
24 -- 4) To trap any constraint violations that may have occurred.
25 -- 5) To raise any other errors.
26 --
27 -- Prerequisites:
28 -- This is an internal private Procedure which must be called from the upd
29 -- Procedure.
30 --
31 -- In Parameters:
32 -- A Pl/Sql record structre.
33 --
34 -- Post Success:
35 -- The specIfied row will be updated in the schema.
36 --
37 -- Post Failure:
38 -- On the update dml failure it is important to note that we always reset the
39 -- g_api_dml status to false.
40 -- If a check, unique or parent integrity constraint violation is raised the
41 -- constraint_error Procedure will be called.
42 -- If any other error is reported, the error will be raised after the
43 -- g_api_dml status is reset.
44 --
45 -- Developer Implementation Notes:
46 -- The update 'set' attribute list should be modIfied If any of your
47 -- attributes are not updateable.
48 --
49 -- Access Status:
50 -- Internal Row Handler Use Only.
51 --
52 -- {End Of Comments}
53 -- ----------------------------------------------------------------------------
54 Procedure update_dml(p_rec in out nocopy per_ssl_shd.g_rec_type) is
55 --
56 l_proc varchar2(72) := g_package||'update_dml';
57 --
58 Begin
59 hr_utility.set_location('Entering:'||l_proc, 5);
60 --
61 -- Increment the object version
62 --
63 p_rec.object_version_number := p_rec.object_version_number + 1;
64 --
65 --
66 -- Update the per_salary_survey_lines Row
67 --
68 update per_salary_survey_lines
69 set
70 salary_survey_line_id = p_rec.salary_survey_line_id,
71 object_version_number = p_rec.object_version_number,
72 survey_job_name_code = p_rec.survey_job_name_code,
73 survey_region_code = p_rec.survey_region_code,
74 survey_seniority_code = p_rec.survey_seniority_code,
75 company_size_code = p_rec.company_size_code,
76 industry_code = p_rec.industry_code,
77 survey_age_code = p_rec.survey_age_code,
78 start_date = p_rec.start_date,
79 end_date = p_rec.end_date,
80 currency_code = p_rec.currency_code,
81 differential = p_rec.differential,
82 minimum_pay = p_rec.minimum_pay,
83 mean_pay = p_rec.mean_pay,
84 maximum_pay = p_rec.maximum_pay,
85 graduate_pay = p_rec.graduate_pay,
86 starting_pay = p_rec.starting_pay,
87 percentage_change = p_rec.percentage_change,
88 job_first_quartile = p_rec.job_first_quartile,
89 job_median_quartile = p_rec.job_median_quartile,
90 job_third_quartile = p_rec.job_third_quartile,
91 job_fourth_quartile = p_rec.job_fourth_quartile,
92 minimum_total_compensation = p_rec.minimum_total_compensation,
93 mean_total_compensation = p_rec.mean_total_compensation,
94 maximum_total_compensation = p_rec.maximum_total_compensation,
95 compnstn_first_quartile = p_rec.compnstn_first_quartile,
96 compnstn_median_quartile = p_rec.compnstn_median_quartile,
97 compnstn_third_quartile = p_rec.compnstn_third_quartile,
98 compnstn_fourth_quartile = p_rec.compnstn_fourth_quartile,
99 /*Added for Enhancement 4021737 */
100 tenth_percentile = p_rec.tenth_percentile,
101 twenty_fifth_percentile = p_rec.twenty_fifth_percentile,
102 fiftieth_percentile = p_rec.fiftieth_percentile,
103 seventy_fifth_percentile = p_rec.seventy_fifth_percentile,
104 ninetieth_percentile = p_rec.ninetieth_percentile,
105 minimum_bonus = p_rec.minimum_bonus,
106 mean_bonus = p_rec.mean_bonus,
107 maximum_bonus = p_rec.maximum_bonus,
108 minimum_salary_increase = p_rec.minimum_salary_increase,
109 mean_salary_increase = p_rec.mean_salary_increase,
110 maximum_salary_increase = p_rec.maximum_salary_increase,
111 min_variable_compensation = p_rec.min_variable_compensation,
112 mean_variable_compensation = p_rec.mean_variable_compensation,
113 max_variable_compensation = p_rec.max_variable_compensation,
114 minimum_stock = p_rec.minimum_stock,
115 mean_stock = p_rec.mean_stock,
116 maximum_stock = p_rec.maximum_stock,
117 stock_display_type = p_rec.stock_display_type,
118 /*End Enhancement 4021737 */
119 attribute_category = p_rec.attribute_category,
120 attribute1 = p_rec.attribute1,
121 attribute2 = p_rec.attribute2,
122 attribute3 = p_rec.attribute3,
123 attribute4 = p_rec.attribute4,
124 attribute5 = p_rec.attribute5,
125 attribute6 = p_rec.attribute6,
126 attribute7 = p_rec.attribute7,
127 attribute8 = p_rec.attribute8,
128 attribute9 = p_rec.attribute9,
129 attribute10 = p_rec.attribute10,
130 attribute11 = p_rec.attribute11,
131 attribute12 = p_rec.attribute12,
132 attribute13 = p_rec.attribute13,
133 attribute14 = p_rec.attribute14,
134 attribute15 = p_rec.attribute15,
135 attribute16 = p_rec.attribute16,
136 attribute17 = p_rec.attribute17,
137 attribute18 = p_rec.attribute18,
138 attribute19 = p_rec.attribute19,
139 attribute20 = p_rec.attribute20,
140 /* Added for Enhancement 4021737 */
141 attribute21 = p_rec.attribute21,
142 attribute22 = p_rec.attribute22,
143 attribute23 = p_rec.attribute23,
144 attribute24 = p_rec.attribute24,
145 attribute25 = p_rec.attribute25,
146 attribute26 = p_rec.attribute26,
147 attribute27 = p_rec.attribute27,
148 attribute28 = p_rec.attribute28,
149 attribute29 = p_rec.attribute29,
150 attribute30 = p_rec.attribute30
151 /*End Enhancement 4021737 */
152 where salary_survey_line_id = p_rec.salary_survey_line_id;
153 --
154 hr_utility.set_location(' Leaving:'||l_proc, 10);
155 --
156 Exception
157 When hr_api.check_integrity_violated Then
158 -- A check constraint has been violated
159 per_ssl_shd.constraint_error
160 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161 When hr_api.parent_integrity_violated Then
162 -- Parent integrity has been violated
163 per_ssl_shd.constraint_error
164 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
165 When hr_api.unique_integrity_violated Then
166 -- Unique integrity has been violated
167 per_ssl_shd.constraint_error
168 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
169 When Others Then
170 Raise;
171 End update_dml;
172 --
173 -- ----------------------------------------------------------------------------
174 -- |------------------------------< pre_update >------------------------------|
175 -- ----------------------------------------------------------------------------
176 -- {Start Of Comments}
177 --
178 -- Description:
179 -- This private Procedure contains any processing which is required before
180 -- the update dml.
181 --
182 -- Prerequisites:
183 -- This is an internal Procedure which is called from the upd Procedure.
184 --
185 -- In Parameters:
186 -- A Pl/Sql record structre.
187 --
188 -- Post Success:
189 -- Processing continues.
190 --
191 -- Post Failure:
192 -- If an error has occurred, an error message and exception will be raised
193 -- but not handled.
194 --
195 -- Developer Implementation Notes:
196 -- Any pre-processing required before the update dml is issued should be
197 -- coded within this Procedure. It is important to note that any 3rd party
198 -- maintenance should be reviewed before placing in this Procedure.
199 --
200 -- Access Status:
201 -- Internal Row Handler Use Only.
202 --
203 -- {End Of Comments}
204 -- ----------------------------------------------------------------------------
205 Procedure pre_update(p_rec in per_ssl_shd.g_rec_type) is
206 --
207 l_proc varchar2(72) := g_package||'pre_update';
208 --
209 Begin
210 hr_utility.set_location('Entering:'||l_proc, 5);
211 --
212 hr_utility.set_location(' Leaving:'||l_proc, 10);
213 End pre_update;
214 --
215 -- ----------------------------------------------------------------------------
216 -- |-----------------------------< post_update >------------------------------|
217 -- ----------------------------------------------------------------------------
218 -- {Start Of Comments}
219 --
220 -- Description:
221 -- This private Procedure contains any processing which is required after the
222 -- update dml.
223 --
224 -- Prerequisites:
225 -- This is an internal Procedure which is called from the upd Procedure.
226 --
227 -- In Parameters:
228 -- A Pl/Sql record structre.
229 --
230 -- Post Success:
231 -- Processing continues.
232 --
233 -- Post Failure:
234 -- If an error has occurred, an error message and exception will be raised
235 -- but not handled.
236 --
237 -- Developer Implementation Notes:
238 -- Any post-processing required after the update dml is issued should be
239 -- coded within this Procedure. It is important to note that any 3rd party
240 -- maintenance should be reviewed before placing in this Procedure.
241 --
242 -- Access Status:
243 -- Internal Row Handler Use Only.
244 --
245 -- {End Of Comments}
246 -- ----------------------------------------------------------------------------
247 Procedure post_update(p_rec in per_ssl_shd.g_rec_type,
248 p_effective_date in date) is
249 --
250 l_proc varchar2(72) := g_package||'post_update';
251 --
252 Begin
253 hr_utility.set_location('Entering:'||l_proc, 5);
254 --
255 begin
256 per_ssl_rku.after_update
257 (p_salary_survey_line_id
258 => p_rec.salary_survey_line_id,
259 p_object_version_number
260 => p_rec.object_version_number,
261 p_salary_survey_id => p_rec.salary_survey_id,
262 p_survey_job_name_code
263 => p_rec.survey_job_name_code,
264 p_survey_region_code
265 => p_rec.survey_region_code,
266 p_survey_seniority_code
267 => p_rec.survey_seniority_code,
268 p_company_size_code
269 => p_rec.company_size_code,
270 p_industry_code
271 => p_rec.industry_code,
272 p_survey_age_code
273 => p_rec.survey_age_code,
274 p_start_date
275 => p_rec.start_date,
276 p_end_date
277 => p_rec.end_date,
278 p_currency_code
279 => p_rec.currency_code,
280 p_differential
281 => p_rec.differential,
282 p_minimum_pay
283 => p_rec.minimum_pay,
284 p_mean_pay
285 => p_rec.mean_pay,
286 p_maximum_pay
287 => p_rec.maximum_pay,
288 p_graduate_pay
289 => p_rec.graduate_pay,
290 p_starting_pay
291 => p_rec.starting_pay,
292 p_percentage_change
293 => p_rec.percentage_change,
294 p_job_first_quartile
295 => p_rec.job_first_quartile,
296 p_job_median_quartile
297 => p_rec.job_median_quartile,
298 p_job_third_quartile
299 => p_rec.job_third_quartile,
300 p_job_fourth_quartile
301 => p_rec.job_fourth_quartile,
302 p_minimum_total_compensation
303 => p_rec.minimum_total_compensation,
304 p_mean_total_compensation
305 => p_rec.mean_total_compensation,
306 p_maximum_total_compensation
307 => p_rec.maximum_total_compensation,
308 p_compnstn_first_quartile
309 => p_rec.compnstn_first_quartile,
310 p_compnstn_median_quartile
311 => p_rec.compnstn_median_quartile,
312 p_compnstn_third_quartile
313 => p_rec.compnstn_third_quartile,
314 p_compnstn_fourth_quartile
315 => p_rec.compnstn_fourth_quartile,
316 /*Added for Enhancement 4021737 */
317 p_tenth_percentile
318 => p_rec.tenth_percentile,
319 p_twenty_fifth_percentile
320 => p_rec.twenty_fifth_percentile,
321 p_fiftieth_percentile
322 => p_rec.fiftieth_percentile,
323 p_seventy_fifth_percentile
324 => p_rec.seventy_fifth_percentile,
325 p_ninetieth_percentile
326 => p_rec.ninetieth_percentile,
327 p_minimum_bonus
328 => p_rec.minimum_bonus,
329 p_mean_bonus
330 => p_rec.mean_bonus,
331 p_maximum_bonus
332 => p_rec.maximum_bonus,
333 p_minimum_salary_increase
334 => p_rec.minimum_salary_increase,
335 p_mean_salary_increase
336 => p_rec.mean_salary_increase,
337 p_maximum_salary_increase
338 => p_rec.maximum_salary_increase,
339 p_min_variable_compensation
340 => p_rec.min_variable_compensation,
341 p_mean_variable_compensation
342 => p_rec.mean_variable_compensation,
343 p_max_variable_compensation
344 => p_rec.max_variable_compensation,
345 p_minimum_stock
346 => p_rec.minimum_stock,
347 p_mean_stock
348 => p_rec.mean_stock,
349 p_maximum_stock
350 => p_rec.maximum_stock,
351 p_stock_display_type
352 => p_rec.stock_display_type,
353 /*End Enhancement 4021737 */
354 p_effective_date
355 => p_effective_date,
356 p_attribute_category
357 => p_rec.attribute_category,
358 p_attribute1
359 => p_rec.attribute1,
360 p_attribute2
361 => p_rec.attribute2,
362 p_attribute3
363 => p_rec.attribute3,
364 p_attribute4
365 => p_rec.attribute4,
366 p_attribute5
367 => p_rec.attribute5,
368 p_attribute6
369 => p_rec.attribute6,
370 p_attribute7
371 => p_rec.attribute7,
372 p_attribute8
373 => p_rec.attribute8,
374 p_attribute9
375 => p_rec.attribute9,
376 p_attribute10
377 => p_rec.attribute10,
378 p_attribute11
379 => p_rec.attribute11,
380 p_attribute12
381 => p_rec.attribute12,
382 p_attribute13
383 => p_rec.attribute13,
384 p_attribute14
385 => p_rec.attribute14,
386 p_attribute15
387 => p_rec.attribute15,
388 p_attribute16
389 => p_rec.attribute16,
390 p_attribute17
391 => p_rec.attribute17,
392 p_attribute18
393 => p_rec.attribute18,
394 p_attribute19
395 => p_rec.attribute19,
396 p_attribute20
397 => p_rec.attribute20,
398 /*Added for Enhancement 4021737 */
399 p_attribute21
400 => p_rec.attribute21,
401 p_attribute22
402 => p_rec.attribute22,
403 p_attribute23
404 => p_rec.attribute23,
405 p_attribute24
406 => p_rec.attribute24,
407 p_attribute25
408 => p_rec.attribute25,
409 p_attribute26
410 => p_rec.attribute26,
411 p_attribute27
412 => p_rec.attribute27,
413 p_attribute28
414 => p_rec.attribute28,
415 p_attribute29
416 => p_rec.attribute29,
417 p_attribute30
418 => p_rec.attribute30,
419 /*End Enhancement 4021737 */
420 p_object_version_number_o
421 => per_ssl_shd.g_old_rec.object_version_number,
422 p_salary_survey_id_o
423 => per_ssl_shd.g_old_rec.salary_survey_id,
424 p_survey_job_name_code_o
425 => per_ssl_shd.g_old_rec.survey_job_name_code,
426 p_survey_region_code_o
427 => per_ssl_shd.g_old_rec.survey_region_code,
428 p_survey_seniority_code_o
429 => per_ssl_shd.g_old_rec.survey_seniority_code,
430 p_company_size_code_o
431 => per_ssl_shd.g_old_rec.company_size_code,
432 p_industry_code_o
433 => per_ssl_shd.g_old_rec.industry_code,
434 p_survey_age_code_o
435 => per_ssl_shd.g_old_rec.survey_age_code,
436 p_start_date_o
437 => per_ssl_shd.g_old_rec.start_date,
438 p_end_date_o
439 => per_ssl_shd.g_old_rec.end_date,
440 p_currency_code_o
441 => per_ssl_shd.g_old_rec.currency_code,
442 p_differential_o
443 => per_ssl_shd.g_old_rec.differential,
444 p_minimum_pay_o
445 => per_ssl_shd.g_old_rec.minimum_pay,
446 p_mean_pay_o
447 => per_ssl_shd.g_old_rec.mean_pay,
448 p_maximum_pay_o
449 => per_ssl_shd.g_old_rec.maximum_pay,
450 p_graduate_pay_o
451 => per_ssl_shd.g_old_rec.graduate_pay,
452 p_starting_pay_o
453 => per_ssl_shd.g_old_rec.starting_pay,
454 p_percentage_change_o
455 => per_ssl_shd.g_old_rec.percentage_change,
456 p_job_first_quartile_o
457 => per_ssl_shd.g_old_rec.job_first_quartile,
458 p_job_median_quartile_o
459 => per_ssl_shd.g_old_rec.job_median_quartile,
460 p_job_third_quartile_o
461 => per_ssl_shd.g_old_rec.job_third_quartile,
462 p_job_fourth_quartile_o
463 => per_ssl_shd.g_old_rec.job_fourth_quartile,
464 p_minimum_total_compensation_o
465 => per_ssl_shd.g_old_rec.minimum_total_compensation,
466 p_mean_total_compensation_o
467 => per_ssl_shd.g_old_rec.mean_total_compensation,
468 p_maximum_total_compensation_o
469 => per_ssl_shd.g_old_rec.maximum_total_compensation,
470 p_compnstn_first_quartile_o
471 => per_ssl_shd.g_old_rec.compnstn_first_quartile,
472 p_compnstn_median_quartile_o
473 => per_ssl_shd.g_old_rec.compnstn_median_quartile,
474 p_compnstn_third_quartile_o
475 => per_ssl_shd.g_old_rec.compnstn_third_quartile,
476 p_compnstn_fourth_quartile_o
477 => per_ssl_shd.g_old_rec.compnstn_fourth_quartile,
478 /*Added for Enhancement 4021737 */
479 p_tenth_percentile_o
480 => per_ssl_shd.g_old_rec.tenth_percentile,
481 p_twenty_fifth_percentile_o
482 => per_ssl_shd.g_old_rec.twenty_fifth_percentile,
483 p_fiftieth_percentile_o
484 => per_ssl_shd.g_old_rec.fiftieth_percentile,
485 p_seventy_fifth_percentile_o
486 => per_ssl_shd.g_old_rec.seventy_fifth_percentile,
487 p_ninetieth_percentile_o
488 => per_ssl_shd.g_old_rec.ninetieth_percentile,
489 p_minimum_bonus_o
490 => per_ssl_shd.g_old_rec.minimum_bonus,
491 p_mean_bonus_o
492 => per_ssl_shd.g_old_rec.mean_bonus,
493 p_maximum_bonus_o
494 => per_ssl_shd.g_old_rec.maximum_bonus,
495 p_minimum_salary_increase_o
496 => per_ssl_shd.g_old_rec.minimum_salary_increase,
497 p_mean_salary_increase_o
498 => per_ssl_shd.g_old_rec.mean_salary_increase,
499 p_maximum_salary_increase_o
500 => per_ssl_shd.g_old_rec.maximum_salary_increase,
501 p_min_variable_compensation_o
502 => per_ssl_shd.g_old_rec.min_variable_compensation,
503 p_mean_variable_compensation_o
504 => per_ssl_shd.g_old_rec.mean_variable_compensation,
505 p_max_variable_compensation_o
506 => per_ssl_shd.g_old_rec.max_variable_compensation,
507 p_minimum_stock_o
508 => per_ssl_shd.g_old_rec.minimum_stock,
509 p_mean_stock_o
510 => per_ssl_shd.g_old_rec.mean_stock,
511 p_maximum_stock_o
512 => per_ssl_shd.g_old_rec.maximum_stock,
513 p_stock_display_type_o
514 => per_ssl_shd.g_old_rec.stock_display_type,
515 /*End Enhancement 4021737 */
516 p_attribute_category_o
517 => per_ssl_shd.g_old_rec.attribute_category,
518 p_attribute1_o
519 => per_ssl_shd.g_old_rec.attribute1,
520 p_attribute2_o
521 => per_ssl_shd.g_old_rec.attribute2,
522 p_attribute3_o
523 => per_ssl_shd.g_old_rec.attribute3,
524 p_attribute4_o
525 => per_ssl_shd.g_old_rec.attribute4,
526 p_attribute5_o
527 => per_ssl_shd.g_old_rec.attribute5,
528 p_attribute6_o
529 => per_ssl_shd.g_old_rec.attribute6,
530 p_attribute7_o
531 => per_ssl_shd.g_old_rec.attribute7,
532 p_attribute8_o
533 => per_ssl_shd.g_old_rec.attribute8,
534 p_attribute9_o
535 => per_ssl_shd.g_old_rec.attribute9,
536 p_attribute10_o
537 => per_ssl_shd.g_old_rec.attribute10,
538 p_attribute11_o
539 => per_ssl_shd.g_old_rec.attribute11,
540 p_attribute12_o
541 => per_ssl_shd.g_old_rec.attribute12,
542 p_attribute13_o
543 => per_ssl_shd.g_old_rec.attribute13,
544 p_attribute14_o
545 => per_ssl_shd.g_old_rec.attribute14,
546 p_attribute15_o
547 => per_ssl_shd.g_old_rec.attribute15,
548 p_attribute16_o
549 => per_ssl_shd.g_old_rec.attribute16,
550 p_attribute17_o
551 => per_ssl_shd.g_old_rec.attribute17,
552 p_attribute18_o
553 => per_ssl_shd.g_old_rec.attribute18,
554 p_attribute19_o
555 => per_ssl_shd.g_old_rec.attribute19,
556 p_attribute20_o
557 => per_ssl_shd.g_old_rec.attribute20,
558 /*Added for Enhancement 4021737 */
559 p_attribute21_o
560 => per_ssl_shd.g_old_rec.attribute21,
561 p_attribute22_o
562 => per_ssl_shd.g_old_rec.attribute22,
563 p_attribute23_o
564 => per_ssl_shd.g_old_rec.attribute23,
565 p_attribute24_o
566 => per_ssl_shd.g_old_rec.attribute24,
567 p_attribute25_o
568 => per_ssl_shd.g_old_rec.attribute25,
569 p_attribute26_o
570 => per_ssl_shd.g_old_rec.attribute26,
571 p_attribute27_o
572 => per_ssl_shd.g_old_rec.attribute27,
573 p_attribute28_o
574 => per_ssl_shd.g_old_rec.attribute28,
575 p_attribute29_o
576 => per_ssl_shd.g_old_rec.attribute29,
577 p_attribute30_o
578 => per_ssl_shd.g_old_rec.attribute30
579 /*End Enhancement 4021737 */
580 );
581
582 exception
583 when hr_api.cannot_find_prog_unit then
584 hr_api.cannot_find_prog_unit_error
585 (p_module_name => 'PER_SALARY_SURVEY_LINES'
586 ,p_hook_type => 'AU'
587 );
588 end;
589 --
590 hr_utility.set_location(' Leaving:'||l_proc, 10);
591 End post_update;
592
593 --
594 -- ----------------------------------------------------------------------------
595 -- |-----------------------------< convert_defs >-----------------------------|
596 -- ----------------------------------------------------------------------------
597 -- {Start Of Comments}
598 --
599 -- Description:
600 -- The Convert_Defs Procedure has one very important function:
601 -- It must return the record structure for the row with all system defaulted
602 -- values converted into its corresponding parameter value for update. When
603 -- we attempt to update a row through the Upd process , certain
604 -- parameters can be defaulted which enables flexibility in the calling of
605 -- the upd process (e.g. only attributes which need to be updated need to be
606 -- specIfied). For the upd process to determine which attributes
607 -- have NOT been specIfied we need to check If the parameter has a reserved
608 -- system default value. Therefore, for all parameters which have a
609 -- corresponding reserved system default mechanism specIfied we need to
610 -- check If a system default is being used. If a system default is being
611 -- used Then we convert the defaulted value into its corresponding attribute
612 -- value held in the g_old_rec data structure.
613 --
614 -- Prerequisites:
615 -- This private function can only be called from the upd process.
616 --
617 -- In Parameters:
618 -- A Pl/Sql record structre.
619 --
620 -- Post Success:
621 -- The record structure will be returned with all system defaulted parameter
622 -- values converted into its current row attribute value.
623 --
624 -- Post Failure:
625 -- No direct error handling is required within this function. Any possible
626 -- errors within this Procedure will be a PL/SQL value error due to conversion
627
628 -- of datatypes or data lengths.
629 --
630 -- Developer Implementation Notes:
631 -- None.
632 --
633 -- Access Status:
634 -- Internal Row Handler Use Only.
635 --
636 -- {End Of Comments}
637 -- ----------------------------------------------------------------------------
638 Procedure convert_defs(p_rec in out nocopy per_ssl_shd.g_rec_type) is
639 --
640 l_proc varchar2(72) := g_package||'convert_defs';
641 --
642 Begin
643 --
644 hr_utility.set_location('Entering:'||l_proc, 5);
645 --
646 -- We must now examine each argument value in the
647 -- p_rec plsql record structure
648 -- to see If a system default is being used. If a system default
649 -- is being used Then we must set to the 'current' argument value.
650 --
651 If (p_rec.salary_survey_id = hr_api.g_number) Then
652 p_rec.salary_survey_id :=
653 per_ssl_shd.g_old_rec.salary_survey_id;
654 End If;
655 If (p_rec.survey_job_name_code = hr_api.g_varchar2) Then
656 p_rec.survey_job_name_code :=
657 per_ssl_shd.g_old_rec.survey_job_name_code;
658 End If;
659 If (p_rec.survey_region_code = hr_api.g_varchar2) Then
660 p_rec.survey_region_code :=
661 per_ssl_shd.g_old_rec.survey_region_code;
662 End If;
663 If (p_rec.survey_seniority_code = hr_api.g_varchar2) Then
664 p_rec.survey_seniority_code :=
665 per_ssl_shd.g_old_rec.survey_seniority_code;
666 End If;
667 If (p_rec.company_size_code = hr_api.g_varchar2) Then
668 p_rec.company_size_code :=
669 per_ssl_shd.g_old_rec.company_size_code;
670 End If;
671 If (p_rec.industry_code = hr_api.g_varchar2) Then
672 p_rec.industry_code :=
673 per_ssl_shd.g_old_rec.industry_code;
674 End If;
675 If (p_rec.survey_age_code = hr_api.g_varchar2) Then
676 p_rec.survey_age_code :=
677 per_ssl_shd.g_old_rec.survey_age_code;
678 End If;
679 If (p_rec.start_date = hr_api.g_date) Then
680 p_rec.start_date :=
681 per_ssl_shd.g_old_rec.start_date;
682 End If;
683 If (p_rec.end_date = hr_api.g_date) Then
684 p_rec.end_date :=
685 per_ssl_shd.g_old_rec.end_date;
686 End If;
687 If (p_rec.currency_code = hr_api.g_varchar2) then
688 p_rec.currency_code :=
689 per_ssl_shd.g_old_rec.currency_code;
690 End If;
691 If (p_rec.differential = hr_api.g_number) Then
692 p_rec.differential :=
693 per_ssl_shd.g_old_rec.differential;
694 End If;
695 If (p_rec.minimum_pay = hr_api.g_number ) Then
696 p_rec.minimum_pay :=
697 per_ssl_shd.g_old_rec.minimum_pay;
698 End If;
699 If (p_rec.mean_pay = hr_api.g_number ) Then
700 p_rec.mean_pay :=
701 per_ssl_shd.g_old_rec.mean_pay;
702 End If;
703 If (p_rec.maximum_pay = hr_api.g_number ) Then
704 p_rec.maximum_pay :=
705 per_ssl_shd.g_old_rec.maximum_pay;
706 End If;
707 If (p_rec.graduate_pay = hr_api.g_number ) Then
708 p_rec.graduate_pay :=
709 per_ssl_shd.g_old_rec.graduate_pay;
710 End If;
711 If (p_rec.starting_pay = hr_api.g_number ) Then
712 p_rec.starting_pay :=
713 per_ssl_shd.g_old_rec.starting_pay;
714 End If;
715 If (p_rec.percentage_change = hr_api.g_number ) Then
716 p_rec.percentage_change :=
717 per_ssl_shd.g_old_rec.percentage_change;
718 End If;
719 If (p_rec.job_first_quartile = hr_api.g_number ) Then
720 p_rec.job_first_quartile :=
721 per_ssl_shd.g_old_rec.job_first_quartile;
722 End If;
723 If (p_rec.job_median_quartile = hr_api.g_number ) Then
724 p_rec.job_median_quartile :=
725 per_ssl_shd.g_old_rec.job_median_quartile;
726 End If;
727 If (p_rec.job_third_quartile = hr_api.g_number ) Then
728 p_rec.job_third_quartile :=
729 per_ssl_shd.g_old_rec.job_third_quartile;
730 End If;
731 If (p_rec.job_fourth_quartile = hr_api.g_number ) Then
732 p_rec.job_fourth_quartile :=
733 per_ssl_shd.g_old_rec.job_fourth_quartile;
734 End If;
735 If (p_rec.minimum_total_compensation = hr_api.g_number ) Then
736 p_rec.minimum_total_compensation :=
737 per_ssl_shd.g_old_rec.minimum_total_compensation;
738 End If;
739 If (p_rec.mean_total_compensation = hr_api.g_number ) Then
740 p_rec.mean_total_compensation :=
741 per_ssl_shd.g_old_rec.mean_total_compensation;
742 End If;
743 If (p_rec.maximum_total_compensation = hr_api.g_number ) Then
744 p_rec.maximum_total_compensation :=
745 per_ssl_shd.g_old_rec.maximum_total_compensation;
746 End If;
747 If (p_rec.compnstn_first_quartile = hr_api.g_number ) Then
748 p_rec.compnstn_first_quartile :=
749 per_ssl_shd.g_old_rec.compnstn_first_quartile;
750 End If;
751 If (p_rec.compnstn_median_quartile = hr_api.g_number ) Then
752 p_rec.compnstn_median_quartile :=
753 per_ssl_shd.g_old_rec.compnstn_median_quartile;
754 End If;
755 If (p_rec.compnstn_third_quartile = hr_api.g_number ) Then
756 p_rec.compnstn_third_quartile :=
757 per_ssl_shd.g_old_rec.compnstn_third_quartile;
758 End If;
759 If (p_rec.compnstn_fourth_quartile = hr_api.g_number ) Then
760 p_rec.compnstn_fourth_quartile :=
761 per_ssl_shd.g_old_rec.compnstn_fourth_quartile;
762 End If;
763 /*Added for Enhancement 4021737 */
764 If (p_rec.tenth_percentile = hr_api.g_number ) Then
765 p_rec.tenth_percentile :=
766 per_ssl_shd.g_old_rec.tenth_percentile;
767 End If;
768 If (p_rec.twenty_fifth_percentile = hr_api.g_number ) Then
769 p_rec.twenty_fifth_percentile :=
770 per_ssl_shd.g_old_rec.twenty_fifth_percentile;
771 End If;
772 If (p_rec.fiftieth_percentile = hr_api.g_number ) Then
773 p_rec.fiftieth_percentile :=
774 per_ssl_shd.g_old_rec.fiftieth_percentile;
775 End If;
776 If (p_rec.seventy_fifth_percentile = hr_api.g_number ) Then
777 p_rec.seventy_fifth_percentile :=
778 per_ssl_shd.g_old_rec.seventy_fifth_percentile;
779 End If;
780 If (p_rec.ninetieth_percentile = hr_api.g_number ) Then
781 p_rec.ninetieth_percentile :=
782 per_ssl_shd.g_old_rec.ninetieth_percentile;
783 End If;
784 If (p_rec.minimum_bonus = hr_api.g_number ) Then
785 p_rec.minimum_bonus :=
786 per_ssl_shd.g_old_rec.minimum_bonus;
787 End If;
788 If (p_rec.mean_bonus = hr_api.g_number ) Then
789 p_rec.mean_bonus :=
790 per_ssl_shd.g_old_rec.mean_bonus;
791 End If;
792 If (p_rec.maximum_bonus = hr_api.g_number ) Then
793 p_rec.maximum_bonus :=
794 per_ssl_shd.g_old_rec.maximum_bonus;
795 End If;
796 If (p_rec.minimum_salary_increase = hr_api.g_number ) Then
797 p_rec.minimum_salary_increase :=
798 per_ssl_shd.g_old_rec.minimum_salary_increase;
799 End If;
800 If (p_rec.mean_salary_increase = hr_api.g_number ) Then
801 p_rec.mean_salary_increase :=
802 per_ssl_shd.g_old_rec.mean_salary_increase;
803 End If;
804 If (p_rec.maximum_salary_increase = hr_api.g_number ) Then
805 p_rec.maximum_salary_increase :=
806 per_ssl_shd.g_old_rec.maximum_salary_increase;
807 End If;
808 If (p_rec.min_variable_compensation = hr_api.g_number ) Then
809 p_rec.min_variable_compensation :=
810 per_ssl_shd.g_old_rec.min_variable_compensation;
811 End If;
812 If (p_rec.mean_variable_compensation = hr_api.g_number ) Then
813 p_rec.mean_variable_compensation :=
814 per_ssl_shd.g_old_rec.mean_variable_compensation;
815 End If;
816 If (p_rec.max_variable_compensation = hr_api.g_number ) Then
817 p_rec.max_variable_compensation :=
818 per_ssl_shd.g_old_rec.max_variable_compensation;
819 End If;
820 If (p_rec.minimum_stock = hr_api.g_number ) Then
821 p_rec.minimum_stock :=
822 per_ssl_shd.g_old_rec.minimum_stock;
823 End If;
824 If (p_rec.mean_stock = hr_api.g_number ) Then
825 p_rec.mean_stock :=
826 per_ssl_shd.g_old_rec.mean_stock;
827 End If;
828 If (p_rec.maximum_stock = hr_api.g_number ) Then
829 p_rec.maximum_stock :=
830 per_ssl_shd.g_old_rec.maximum_stock;
831 End If;
832 If (p_rec.stock_display_type = hr_api.g_varchar2) Then
833 p_rec.stock_display_type :=
834 per_ssl_shd.g_old_rec.stock_display_type;
835 End If;
836 /*End Enhancement 4021737 */
837 If (p_rec.attribute_category = hr_api.g_varchar2 ) Then
838 p_rec.attribute_category :=
839 per_ssl_shd.g_old_rec.attribute_category;
840 End If;
841 If (p_rec.attribute1 = hr_api.g_varchar2) Then
842 p_rec.attribute1 :=
843 per_ssl_shd.g_old_rec.attribute1;
844 End If;
845 If (p_rec.attribute2 = hr_api.g_varchar2) Then
846 p_rec.attribute2 :=
847 per_ssl_shd.g_old_rec.attribute2;
848 End If;
849 If (p_rec.attribute3 = hr_api.g_varchar2) Then
850 p_rec.attribute3 :=
851 per_ssl_shd.g_old_rec.attribute3;
852 End If;
853 If (p_rec.attribute4 = hr_api.g_varchar2) Then
854 p_rec.attribute4 :=
855 per_ssl_shd.g_old_rec.attribute4;
856 End If;
857 If (p_rec.attribute5 = hr_api.g_varchar2) Then
858 p_rec.attribute5 :=
859 per_ssl_shd.g_old_rec.attribute5;
860 End If;
861 If (p_rec.attribute6 = hr_api.g_varchar2) Then
862 p_rec.attribute6 :=
863 per_ssl_shd.g_old_rec.attribute6;
864 End If;
865 If (p_rec.attribute7 = hr_api.g_varchar2) Then
866 p_rec.attribute7 :=
867 per_ssl_shd.g_old_rec.attribute7;
868 End If;
869 If (p_rec.attribute8 = hr_api.g_varchar2) Then
870 p_rec.attribute8 :=
871 per_ssl_shd.g_old_rec.attribute8;
872 End If;
873 If (p_rec.attribute9 = hr_api.g_varchar2) Then
874 p_rec.attribute9 :=
875 per_ssl_shd.g_old_rec.attribute9;
876 End If;
877 If (p_rec.attribute10 = hr_api.g_varchar2) Then
878 p_rec.attribute10 :=
879 per_ssl_shd.g_old_rec.attribute10;
880 End If;
881 If (p_rec.attribute11 = hr_api.g_varchar2) Then
882 p_rec.attribute11 :=
883 per_ssl_shd.g_old_rec.attribute11;
884 End If;
885 If (p_rec.attribute12 = hr_api.g_varchar2) Then
886 p_rec.attribute12 :=
887 per_ssl_shd.g_old_rec.attribute12;
888 End If;
889 If (p_rec.attribute13 = hr_api.g_varchar2) Then
890 p_rec.attribute13 :=
891 per_ssl_shd.g_old_rec.attribute13;
892 End If;
893 If (p_rec.attribute14 = hr_api.g_varchar2) Then
894 p_rec.attribute14 :=
895 per_ssl_shd.g_old_rec.attribute14;
896 End If;
897 If (p_rec.attribute15 = hr_api.g_varchar2) Then
898 p_rec.attribute15 :=
899 per_ssl_shd.g_old_rec.attribute15;
900 End If;
901 If (p_rec.attribute16 = hr_api.g_varchar2) Then
902 p_rec.attribute16 :=
903 per_ssl_shd.g_old_rec.attribute16;
904 End If;
905 If (p_rec.attribute17 = hr_api.g_varchar2) Then
906 p_rec.attribute17 :=
907 per_ssl_shd.g_old_rec.attribute17;
908 End If;
909 If (p_rec.attribute18 = hr_api.g_varchar2) Then
910 p_rec.attribute18 :=
911 per_ssl_shd.g_old_rec.attribute18;
912 End If;
913 If (p_rec.attribute19 = hr_api.g_varchar2) Then
914 p_rec.attribute19 :=
915 per_ssl_shd.g_old_rec.attribute19;
916 End If;
917 If (p_rec.attribute20 = hr_api.g_varchar2) Then
918 p_rec.attribute20 :=
919 per_ssl_shd.g_old_rec.attribute20;
920 End If;
921 /*Added for Enhancement 4021737 */
922 If (p_rec.attribute21 = hr_api.g_varchar2) Then
923 p_rec.attribute21 :=
924 per_ssl_shd.g_old_rec.attribute21;
925 End If;
926 If (p_rec.attribute22 = hr_api.g_varchar2) Then
927 p_rec.attribute22 :=
928 per_ssl_shd.g_old_rec.attribute22;
929 End If;
930 If (p_rec.attribute23 = hr_api.g_varchar2) Then
931 p_rec.attribute23 :=
932 per_ssl_shd.g_old_rec.attribute23;
933 End If;
934 If (p_rec.attribute24 = hr_api.g_varchar2) Then
935 p_rec.attribute24 :=
936 per_ssl_shd.g_old_rec.attribute24;
937 End If;
938 If (p_rec.attribute25 = hr_api.g_varchar2) Then
939 p_rec.attribute25 :=
940 per_ssl_shd.g_old_rec.attribute25;
941 End If;
942 If (p_rec.attribute26 = hr_api.g_varchar2) Then
943 p_rec.attribute26 :=
944 per_ssl_shd.g_old_rec.attribute26;
945 End If;
946 If (p_rec.attribute27 = hr_api.g_varchar2) Then
947 p_rec.attribute27 :=
948 per_ssl_shd.g_old_rec.attribute27;
949 End If;
950 If (p_rec.attribute28 = hr_api.g_varchar2) Then
951 p_rec.attribute28 :=
952 per_ssl_shd.g_old_rec.attribute28;
953 End If;
954 If (p_rec.attribute29 = hr_api.g_varchar2) Then
955 p_rec.attribute29 :=
956 per_ssl_shd.g_old_rec.attribute29;
957 End If;
958 If (p_rec.attribute30 = hr_api.g_varchar2) Then
959 p_rec.attribute30 :=
960 per_ssl_shd.g_old_rec.attribute30;
961 End If;
962 /*End Enhancement 4021737 */
963 --
964 hr_utility.set_location(' Leaving:'||l_proc, 10);
965 --
966 End convert_defs;
967 --
968 -- ----------------------------------------------------------------------------
969 -- |---------------------------------< upd >----------------------------------|
970 -- ----------------------------------------------------------------------------
971 Procedure upd
972 (
973 p_rec in out nocopy per_ssl_shd.g_rec_type,
974 p_effective_date in date
975 ) is
976 --
977 l_proc varchar2(72) := g_package||'upd';
978 --
979 Begin
980 hr_utility.set_location('Entering:'||l_proc, 5);
981 --
982 -- We must lock the row which we need to update.
983 --
984 per_ssl_shd.lck
985 (
986 p_rec.salary_survey_line_id,
987 p_rec.object_version_number
988 );
989 --
990 -- 1. During an update system defaults are used to determine If
991 -- arguments have been defaulted or not. We must therefore
992 -- derive the full record structure values to be updated.
993 --
994 -- 2. Call the supporting update validate operations.
995 --
996 convert_defs(p_rec);
997 per_ssl_bus.update_validate(p_rec, p_effective_date);
998 --
999 -- Call the supporting pre-update operation
1000 --
1001 pre_update(p_rec);
1002 --
1003 -- Update the row.
1004 --
1005 update_dml(p_rec);
1006 --
1007 -- Call the supporting post-update operation
1008 --
1009 post_update(p_rec,p_effective_date);
1010 End upd;
1011 --
1012 -- ----------------------------------------------------------------------------
1013 -- |---------------------------------< upd >----------------------------------|
1014 -- ----------------------------------------------------------------------------
1015 Procedure upd
1016 (
1017 p_salary_survey_line_id in number,
1018 p_object_version_number in out nocopy number,
1019 p_survey_job_name_code in varchar2 default hr_api.g_varchar2,
1020 p_survey_region_code in varchar2 default hr_api.g_varchar2,
1021 p_survey_seniority_code in varchar2 default hr_api.g_varchar2,
1022 p_company_size_code in varchar2 default hr_api.g_varchar2,
1023 p_industry_code in varchar2 default hr_api.g_varchar2,
1024 p_survey_age_code in varchar2 default hr_api.g_varchar2,
1025 p_start_date in date default hr_api.g_date,
1026 p_end_date in date default hr_api.g_date,
1027 p_currency_code in varchar2 default hr_api.g_varchar2,
1028 p_differential in number default hr_api.g_number,
1029 p_minimum_pay in number default hr_api.g_number,
1030 p_mean_pay in number default hr_api.g_number,
1031 p_maximum_pay in number default hr_api.g_number,
1032 p_graduate_pay in number default hr_api.g_number,
1033 p_starting_pay in number default hr_api.g_number,
1034 p_percentage_change in number default hr_api.g_number,
1035 p_job_first_quartile in number default hr_api.g_number,
1036 p_job_median_quartile in number default hr_api.g_number,
1037 p_job_third_quartile in number default hr_api.g_number,
1038 p_job_fourth_quartile in number default hr_api.g_number,
1039 p_minimum_total_compensation in number default hr_api.g_number,
1040 p_mean_total_compensation in number default hr_api.g_number,
1041 p_maximum_total_compensation in number default hr_api.g_number,
1042 p_compnstn_first_quartile in number default hr_api.g_number,
1043 p_compnstn_median_quartile in number default hr_api.g_number,
1044 p_compnstn_third_quartile in number default hr_api.g_number,
1045 p_compnstn_fourth_quartile in number default hr_api.g_number,
1046 /*Added for Enhancement 4021737 */
1047 p_tenth_percentile in number default hr_api.g_number,
1048 p_twenty_fifth_percentile in number default hr_api.g_number,
1049 p_fiftieth_percentile in number default hr_api.g_number,
1050 p_seventy_fifth_percentile in number default hr_api.g_number,
1051 p_ninetieth_percentile in number default hr_api.g_number,
1052 p_minimum_bonus in number default hr_api.g_number,
1053 p_mean_bonus in number default hr_api.g_number,
1054 p_maximum_bonus in number default hr_api.g_number,
1055 p_minimum_salary_increase in number default hr_api.g_number,
1056 p_mean_salary_increase in number default hr_api.g_number,
1057 p_maximum_salary_increase in number default hr_api.g_number,
1058 p_min_variable_compensation in number default hr_api.g_number,
1059 p_mean_variable_compensation in number default hr_api.g_number,
1060 p_max_variable_compensation in number default hr_api.g_number,
1061 p_minimum_stock in number default hr_api.g_number,
1062 p_mean_stock in number default hr_api.g_number,
1063 p_maximum_stock in number default hr_api.g_number,
1064 p_stock_display_type in varchar2 default hr_api.g_varchar2,
1065 /*End Enhancement 4021737 */
1066 p_attribute_category in varchar2 default hr_api.g_varchar2,
1067 p_attribute1 in varchar2 default hr_api.g_varchar2,
1068 p_attribute2 in varchar2 default hr_api.g_varchar2,
1069 p_attribute3 in varchar2 default hr_api.g_varchar2,
1070 p_attribute4 in varchar2 default hr_api.g_varchar2,
1071 p_attribute5 in varchar2 default hr_api.g_varchar2,
1072 p_attribute6 in varchar2 default hr_api.g_varchar2,
1073 p_attribute7 in varchar2 default hr_api.g_varchar2,
1074 p_attribute8 in varchar2 default hr_api.g_varchar2,
1075 p_attribute9 in varchar2 default hr_api.g_varchar2,
1076 p_attribute10 in varchar2 default hr_api.g_varchar2,
1077 p_attribute11 in varchar2 default hr_api.g_varchar2,
1078 p_attribute12 in varchar2 default hr_api.g_varchar2,
1079 p_attribute13 in varchar2 default hr_api.g_varchar2,
1080 p_attribute14 in varchar2 default hr_api.g_varchar2,
1081 p_attribute15 in varchar2 default hr_api.g_varchar2,
1082 p_attribute16 in varchar2 default hr_api.g_varchar2,
1083 p_attribute17 in varchar2 default hr_api.g_varchar2,
1084 p_attribute18 in varchar2 default hr_api.g_varchar2,
1085 p_attribute19 in varchar2 default hr_api.g_varchar2,
1086 p_attribute20 in varchar2 default hr_api.g_varchar2,
1087 /*Added for Enhancement 4021737 */
1088 p_attribute21 in varchar2 default hr_api.g_varchar2,
1089 p_attribute22 in varchar2 default hr_api.g_varchar2,
1090 p_attribute23 in varchar2 default hr_api.g_varchar2,
1091 p_attribute24 in varchar2 default hr_api.g_varchar2,
1092 p_attribute25 in varchar2 default hr_api.g_varchar2,
1093 p_attribute26 in varchar2 default hr_api.g_varchar2,
1094 p_attribute27 in varchar2 default hr_api.g_varchar2,
1095 p_attribute28 in varchar2 default hr_api.g_varchar2,
1096 p_attribute29 in varchar2 default hr_api.g_varchar2,
1097 p_attribute30 in varchar2 default hr_api.g_varchar2,
1098 /*End Enhancement 4021737 */
1099 p_effective_date in date
1100 ) is
1101 --
1102 l_rec per_ssl_shd.g_rec_type;
1103 l_proc varchar2(72) := g_package||'upd';
1104 --
1105 Begin
1106 hr_utility.set_location('Entering:'||l_proc, 5);
1107 --
1108 -- Call conversion function to turn arguments into the
1109 -- l_rec structure.
1110 --
1111 l_rec :=
1112 per_ssl_shd.convert_args
1113 (
1114 p_salary_survey_line_id,
1115 p_object_version_number,
1116 hr_api.g_number,
1117 p_survey_job_name_code,
1118 p_survey_region_code,
1119 p_survey_seniority_code,
1120 p_company_size_code,
1121 p_industry_code,
1122 p_survey_age_code,
1123 p_start_date,
1124 p_end_date,
1125 p_currency_code,
1126 p_differential,
1127 p_minimum_pay,
1128 p_mean_pay,
1129 p_maximum_pay,
1130 p_graduate_pay,
1131 p_starting_pay,
1132 p_percentage_change,
1133 p_job_first_quartile,
1134 p_job_median_quartile,
1135 p_job_third_quartile,
1136 p_job_fourth_quartile,
1137 p_minimum_total_compensation,
1138 p_mean_total_compensation,
1139 p_maximum_total_compensation,
1140 p_compnstn_first_quartile,
1141 p_compnstn_median_quartile,
1142 p_compnstn_third_quartile,
1143 p_compnstn_fourth_quartile,
1144 /*Added for Enhancement 4021737 */
1145 p_tenth_percentile,
1146 p_twenty_fifth_percentile,
1147 p_fiftieth_percentile,
1148 p_seventy_fifth_percentile,
1149 p_ninetieth_percentile,
1150 p_minimum_bonus,
1151 p_mean_bonus,
1152 p_maximum_bonus,
1153 p_minimum_salary_increase,
1154 p_mean_salary_increase,
1155 p_maximum_salary_increase,
1156 p_min_variable_compensation,
1157 p_mean_variable_compensation,
1158 p_max_variable_compensation,
1159 p_minimum_stock,
1160 p_mean_stock,
1161 p_maximum_stock,
1162 p_stock_display_type,
1163 /*End Enhancement 4021737 */
1164 p_attribute_category,
1165 p_attribute1,
1166 p_attribute2,
1167 p_attribute3,
1168 p_attribute4,
1169 p_attribute5,
1170 p_attribute6,
1171 p_attribute7,
1172 p_attribute8,
1173 p_attribute9,
1174 p_attribute10,
1175 p_attribute11,
1176 p_attribute12,
1177 p_attribute13,
1178 p_attribute14,
1179 p_attribute15,
1180 p_attribute16,
1181 p_attribute17,
1182 p_attribute18,
1183 p_attribute19,
1184 p_attribute20,
1185 /*Added for Enhancement 4021737 */
1186 p_attribute21,
1187 p_attribute22,
1188 p_attribute23,
1189 p_attribute24,
1190 p_attribute25,
1191 p_attribute26,
1192 p_attribute27,
1193 p_attribute28,
1194 p_attribute29,
1195 p_attribute30
1196 /*End Enhancement 4021737 */
1197 );
1198 --
1199 -- Having converted the arguments into the
1200 -- plsql record structure we call the corresponding record
1201 -- business process.
1202 --
1203 upd(l_rec, p_effective_date);
1204 p_object_version_number := l_rec.object_version_number;
1205 --
1206 hr_utility.set_location(' Leaving:'||l_proc, 10);
1207 End upd;
1208 --
1209 End per_ssl_upd;