[Home] [Help]
PACKAGE BODY: APPS.PER_SSL_INS
Source
1 Package Body per_ssl_ins 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_ins.'; -- Global package name
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------------< insert_dml >------------------------------|
12 -- ----------------------------------------------------------------------------
13 -- {Start Of Comments}
14 --
15 -- Description:
16 -- This Procedure controls the actual dml insert logic. The processing of
17 -- this Procedure are as follows:
18 -- 1) Initialise the object_version_number to 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 insert the row into the schema.
23 -- 4) To trap any constraint violations that may have occurred.
24 -- 5) To raise any other errors.
25 --
26 -- Prerequisites:
27 -- This is an internal private Procedure which must be called from the ins
28 -- Procedure and must have all mandatory attributes set (except the
29 -- object_version_number which is initialised within this Procedure).
30 --
31 -- In Parameters:
32 -- A Pl/Sql record structre.
33 --
34 -- Post Success:
35 -- The specIfied row will be inserted into the schema.
36 --
37 -- Post Failure:
38 -- On the insert 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 -- None.
47 --
48 -- Access Status:
49 -- Internal Row Handler Use Only.
50 --
51 -- {End Of Comments}
52 -- ----------------------------------------------------------------------------
53 Procedure insert_dml(p_rec in out nocopy per_ssl_shd.g_rec_type) is
54 --
55 l_proc varchar2(72) := g_package||'insert_dml';
56 --
57 Begin
58 hr_utility.set_location('Entering:'||l_proc, 5);
59 hr_utility.set_location('SS id '||to_char(p_rec.salary_survey_id), 5);
60 p_rec.object_version_number := 1; -- Initialise the object version
61 --
62 --
63 -- Insert the row into: per_salary_survey_lines
64 --
65 insert into per_salary_survey_lines
66 ( salary_survey_line_id,
67 object_version_number,
68 salary_survey_id,
69 survey_job_name_code,
70 survey_region_code,
71 survey_seniority_code,
72 company_size_code,
73 industry_code,
74 survey_age_code,
75 start_date,
76 end_date,
77 currency_code,
78 differential,
79 minimum_pay,
80 mean_pay,
81 maximum_pay,
82 graduate_pay,
83 starting_pay,
84 percentage_change,
85 job_first_quartile,
86 job_median_quartile,
87 job_third_quartile,
88 job_fourth_quartile,
89 minimum_total_compensation,
90 mean_total_compensation,
91 maximum_total_compensation,
92 compnstn_first_quartile,
93 compnstn_median_quartile,
94 compnstn_third_quartile,
95 compnstn_fourth_quartile,
96 /*Added for Enhancement 4021737 */
97 tenth_percentile,
98 twenty_fifth_percentile,
99 fiftieth_percentile,
100 seventy_fifth_percentile,
101 ninetieth_percentile,
102 minimum_bonus,
103 mean_bonus,
104 maximum_bonus,
105 minimum_salary_increase,
106 mean_salary_increase,
107 maximum_salary_increase,
108 min_variable_compensation,
109 mean_variable_compensation,
110 max_variable_compensation,
111 minimum_stock,
112 mean_stock,
113 maximum_stock,
114 stock_display_type,
115 /*End Enhancement 4021737 */
116 attribute_category,
117 attribute1,
118 attribute2,
119 attribute3,
120 attribute4,
121 attribute5,
122 attribute6,
123 attribute7,
124 attribute8,
125 attribute9,
126 attribute10,
127 attribute11,
128 attribute12,
129 attribute13,
130 attribute14,
131 attribute15,
132 attribute16,
133 attribute17,
134 attribute18,
135 attribute19,
136 attribute20,
137 /*Added for Enhancement 4021737 */
138 attribute21,
139 attribute22,
140 attribute23,
141 attribute24,
142 attribute25,
143 attribute26,
144 attribute27,
145 attribute28,
146 attribute29,
147 attribute30
148 /*End Enhancement 4021737 */
149 )
150 Values
151 ( p_rec.salary_survey_line_id,
152 p_rec.object_version_number,
153 p_rec.salary_survey_id,
154 p_rec.survey_job_name_code,
155 p_rec.survey_region_code,
156 p_rec.survey_seniority_code,
157 p_rec.company_size_code,
158 p_rec.industry_code,
159 p_rec.survey_age_code,
160 p_rec.start_date,
161 p_rec.end_date,
162 p_rec.currency_code,
163 p_rec.differential,
164 p_rec.minimum_pay,
165 p_rec.mean_pay,
166 p_rec.maximum_pay,
167 p_rec.graduate_pay,
168 p_rec.starting_pay,
169 p_rec.percentage_change,
170 p_rec.job_first_quartile,
171 p_rec.job_median_quartile,
172 p_rec.job_third_quartile,
173 p_rec.job_fourth_quartile,
174 p_rec.minimum_total_compensation,
175 p_rec.mean_total_compensation,
176 p_rec.maximum_total_compensation,
177 p_rec.compnstn_first_quartile,
178 p_rec.compnstn_median_quartile,
179 p_rec.compnstn_third_quartile,
180 p_rec.compnstn_fourth_quartile,
181 /*Added for Enhancement 4021737 */
182 p_rec.tenth_percentile,
183 p_rec.twenty_fifth_percentile,
184 p_rec.fiftieth_percentile,
185 p_rec.seventy_fifth_percentile,
186 p_rec.ninetieth_percentile,
187 p_rec.minimum_bonus,
188 p_rec.mean_bonus,
189 p_rec.maximum_bonus,
190 p_rec.minimum_salary_increase,
191 p_rec.mean_salary_increase,
192 p_rec.maximum_salary_increase,
193 p_rec.min_variable_compensation,
194 p_rec.mean_variable_compensation,
195 p_rec.max_variable_compensation,
196 p_rec.minimum_stock,
197 p_rec.mean_stock,
198 p_rec.maximum_stock,
199 p_rec.stock_display_type,
200 /*End Enhancement 4021737 */
201 p_rec.attribute_category,
202 p_rec.attribute1,
203 p_rec.attribute2,
204 p_rec.attribute3,
205 p_rec.attribute4,
206 p_rec.attribute5,
207 p_rec.attribute6,
208 p_rec.attribute7,
209 p_rec.attribute8,
210 p_rec.attribute9,
211 p_rec.attribute10,
212 p_rec.attribute11,
213 p_rec.attribute12,
214 p_rec.attribute13,
215 p_rec.attribute14,
216 p_rec.attribute15,
217 p_rec.attribute16,
218 p_rec.attribute17,
219 p_rec.attribute18,
220 p_rec.attribute19,
221 p_rec.attribute20,
222 /*Added for Enhancement 4021737 */
223 p_rec.attribute21,
224 p_rec.attribute22,
225 p_rec.attribute23,
226 p_rec.attribute24,
227 p_rec.attribute25,
228 p_rec.attribute26,
229 p_rec.attribute27,
230 p_rec.attribute28,
231 p_rec.attribute29,
232 p_rec.attribute30
233 /*End Enhancement 4021737 */
234 );
235 --
236 --
237 hr_utility.set_location(' Leaving:'||l_proc, 10);
238 Exception
239 When hr_api.check_integrity_violated Then
240 -- A check constraint has been violated
241 hr_utility.set_location('check integrity constraint',11);
242 per_ssl_shd.constraint_error
243 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
244 When hr_api.parent_integrity_violated Then
245 -- Parent integrity has been violated
246 hr_utility.set_location('parent integrity constraint',11);
247 per_ssl_shd.constraint_error
248 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
249 When hr_api.unique_integrity_violated Then
250 -- Unique integrity has been violated
251 hr_utility.set_location('unique integrity constraint ',11);
252 hr_utility.set_location(SQLERRM,12);
253 per_ssl_shd.constraint_error
254 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
255 When Others Then
256 Raise;
257 End insert_dml;
258 --
259 -- ----------------------------------------------------------------------------
260 -- |------------------------------< pre_insert >------------------------------|
261 -- ----------------------------------------------------------------------------
262 -- {Start Of Comments}
263 --
264 -- Description:
265 -- This private Procedure contains any processing which is required before
266 -- the insert dml. Presently, If the entity has a corresponding primary
267 -- key which is maintained by an associating sequence, the primary key for
268 -- the entity will be populated with the next sequence value in
269 -- preparation for the insert dml.
270 --
271 -- Prerequisites:
272 -- This is an internal Procedure which is called from the ins Procedure.
273 --
274 -- In Parameters:
275 -- A Pl/Sql record structre.
276 --
277 -- Post Success:
278 -- Processing continues.
279 --
280 -- Post Failure:
281 -- If an error has occurred, an error message and exception will be raised
282 -- but not handled.
283 --
284 -- Developer Implementation Notes:
285 -- Any pre-processing required before the insert dml is issued should be
286 -- coded within this Procedure. As stated above, a good example is the
287 -- generation of a primary key number via a corresponding sequence.
288 -- It is important to note that any 3rd party maintenance should be reviewed
289 -- before placing in this Procedure.
290 --
291 -- Access Status:
292 -- Internal Row Handler Use Only.
293 --
294 -- {End Of Comments}
295 -- ----------------------------------------------------------------------------
296 Procedure pre_insert(p_rec in out nocopy per_ssl_shd.g_rec_type) is
297 --
298 l_proc varchar2(72) := g_package||'pre_insert';
299 --
300 Cursor C_Sel1 is select per_salary_survey_lines_s.nextval from sys.dual;
301 --
302 Begin
303 hr_utility.set_location('Entering:'||l_proc, 5);
304 --
305 --
306 -- Select the next sequence number
307 --
308 Open C_Sel1;
309 Fetch C_Sel1 Into p_rec.salary_survey_line_id;
310 Close C_Sel1;
311 --
312 hr_utility.set_location(' Leaving:'||l_proc, 10);
313 End pre_insert;
314 --
315 -- ----------------------------------------------------------------------------
316 -- |-----------------------------< post_insert >------------------------------|
317 -- ----------------------------------------------------------------------------
318 -- {Start Of Comments}
319 --
320 -- Description:
321 -- This private Procedure contains any processing which is required after the
322 -- insert dml.
323 --
324 -- Prerequisites:
325 -- This is an internal Procedure which is called from the ins Procedure.
326 --
327 -- In Parameters:
328 -- A Pl/Sql record structre.
329 --
330 -- Post Success:
331 -- Processing continues.
332 --
333 -- Post Failure:
334 -- If an error has occurred, an error message and exception will be raised
335 -- but not handled.
336 --
337 -- Developer Implementation Notes:
338 -- Any post-processing required after the insert dml is issued should be
339 -- coded within this Procedure. It is important to note that any 3rd party
340 -- maintenance should be reviewed before placing in this Procedure.
341 --
342 -- Access Status:
343 -- Internal Row Handler Use Only.
344 --
345 -- {End Of Comments}
346 -- ----------------------------------------------------------------------------
347 Procedure post_insert(p_rec in per_ssl_shd.g_rec_type,
348 p_effective_date in date) is
349 --
350 l_proc varchar2(72) := g_package||'post_insert';
351 --
352 Begin
353 hr_utility.set_location('Entering:'||l_proc, 5);
354 --
355 begin
356 per_ssl_rki.after_insert
357 (p_salary_survey_line_id
358 => p_rec.salary_survey_line_id,
359 p_object_version_number
360 => p_rec.object_version_number,
361 p_salary_survey_id
362 => p_rec.salary_survey_id,
363 p_survey_job_name_code
364 => p_rec.survey_job_name_code,
365 p_survey_region_code
366 => p_rec.survey_region_code,
367 p_survey_seniority_code
368 => p_rec.survey_seniority_code,
369 p_company_size_code
370 => p_rec.company_size_code,
371 p_industry_code
372 => p_rec.industry_code,
373 p_survey_age_code
374 => p_rec.survey_age_code,
375 p_start_date
376 => p_rec.start_date,
377 p_end_date
378 => p_rec.end_date,
379 p_currency_code
380 => p_rec.currency_code,
381 p_differential
382 => p_rec.differential,
383 p_minimum_pay
384 => p_rec.minimum_pay,
385 p_mean_pay
386 => p_rec.mean_pay,
387 p_maximum_pay
388 => p_rec.maximum_pay,
389 p_graduate_pay
390 => p_rec.graduate_pay,
391 p_starting_pay
392 => p_rec.starting_pay,
393 p_percentage_change
394 => p_rec.percentage_change,
395 p_job_first_quartile
396 => p_rec.job_first_quartile,
397 p_job_median_quartile
398 => p_rec.job_median_quartile,
399 p_job_third_quartile
400 => p_rec.job_third_quartile,
401 p_job_fourth_quartile
402 => p_rec.job_fourth_quartile,
403 p_minimum_total_compensation
404 => p_rec.minimum_total_compensation,
405 p_mean_total_compensation
406 => p_rec.mean_total_compensation,
407 p_maximum_total_compensation
408 => p_rec.maximum_total_compensation,
409 p_compnstn_first_quartile
410 => p_rec.compnstn_first_quartile,
411 p_compnstn_median_quartile
412 => p_rec.compnstn_median_quartile,
413 p_compnstn_third_quartile
414 => p_rec.compnstn_third_quartile,
415 p_compnstn_fourth_quartile
416 => p_rec.compnstn_fourth_quartile,
417 /*Added for Enhancement 4021737 */
418 p_tenth_percentile
419 => p_rec.tenth_percentile,
420 p_twenty_fifth_percentile
421 => p_rec.twenty_fifth_percentile,
422 p_fiftieth_percentile
423 => p_rec.fiftieth_percentile,
424 p_seventy_fifth_percentile
425 => p_rec.seventy_fifth_percentile,
426 p_ninetieth_percentile
427 => p_rec.ninetieth_percentile,
428 p_minimum_bonus
429 => p_rec.minimum_bonus,
430 p_mean_bonus
431 => p_rec.mean_bonus,
432 p_maximum_bonus
433 => p_rec.maximum_bonus,
434 p_minimum_salary_increase
435 => p_rec.minimum_salary_increase,
436 p_mean_salary_increase
437 => p_rec.mean_salary_increase,
438 p_maximum_salary_increase
439 => p_rec.maximum_salary_increase,
440 p_min_variable_compensation
441 => p_rec.min_variable_compensation,
442 p_mean_variable_compensation
443 => p_rec.mean_variable_compensation,
444 p_max_variable_compensation
445 => p_rec.max_variable_compensation,
446 p_minimum_stock
447 => p_rec.minimum_stock,
448 p_mean_stock
449 => p_rec.mean_stock,
450 p_maximum_stock
451 => p_rec.maximum_stock,
452 p_stock_display_type
453 => p_rec.stock_display_type,
454 /*End Enhancement 4021737 */
455 p_effective_date
456 => p_effective_date,
457 p_attribute_category
458 => p_rec.attribute_category,
459 p_attribute1
460 => p_rec.attribute1,
461 p_attribute2
462 => p_rec.attribute2,
463 p_attribute3
464 => p_rec.attribute3,
465 p_attribute4
466 => p_rec.attribute4,
467 p_attribute5
468 => p_rec.attribute5,
469 p_attribute6
470 => p_rec.attribute6,
471 p_attribute7
472 => p_rec.attribute7,
473 p_attribute8
474 => p_rec.attribute8,
475 p_attribute9
476 => p_rec.attribute9,
477 p_attribute10
478 => p_rec.attribute10,
479 p_attribute11
480 => p_rec.attribute11,
481 p_attribute12
482 => p_rec.attribute12,
483 p_attribute13
484 => p_rec.attribute13,
485 p_attribute14
486 => p_rec.attribute14,
487 p_attribute15
488 => p_rec.attribute15,
489 p_attribute16
490 => p_rec.attribute16,
491 p_attribute17
492 => p_rec.attribute17,
493 p_attribute18
494 => p_rec.attribute18,
495 p_attribute19
496 => p_rec.attribute19,
497 p_attribute20
498 => p_rec.attribute20,
499 /*Added for Enhancement 4021737 */
500 p_attribute21
501 => p_rec.attribute21,
502 p_attribute22
503 => p_rec.attribute22,
504 p_attribute23
505 => p_rec.attribute23,
506 p_attribute24
507 => p_rec.attribute24,
508 p_attribute25
509 => p_rec.attribute25,
510 p_attribute26
511 => p_rec.attribute26,
512 p_attribute27
513 => p_rec.attribute27,
514 p_attribute28
515 => p_rec.attribute28,
519 => p_rec.attribute30
516 p_attribute29
517 => p_rec.attribute29,
518 p_attribute30
520 /*End Enhancement 4021737 */
521
522 );
523
524 exception
525 when hr_api.cannot_find_prog_unit then
526 hr_api.cannot_find_prog_unit_error
527 (p_module_name => 'PER_SALARY_SURVEY_LINES'
528 ,p_hook_type => 'AI'
529 );
530 end;
531
532 --
533 hr_utility.set_location(' Leaving:'||l_proc, 10);
534 End post_insert;
535 --
536 -- ----------------------------------------------------------------------------
537 -- |---------------------------------< ins >----------------------------------|
538 -- ----------------------------------------------------------------------------
539 Procedure ins
540 (
541 p_rec in out nocopy per_ssl_shd.g_rec_type,
542 p_effective_date in date
543 ) is
544 --
545 l_proc varchar2(72) := g_package||'ins';
546 --
547 Begin
548 hr_utility.set_location('Entering:'||l_proc, 5);
549 --
550 -- Call the supporting insert validate operations
551 --
552 per_ssl_bus.insert_validate(p_rec, p_effective_date);
553 --
554 -- Call the supporting pre-insert operation
555 --
556 pre_insert(p_rec);
557 --
558 -- Insert the row
559 --
560 insert_dml(p_rec);
561 --
562 -- Call the supporting post-insert operation
563 --
564 post_insert(p_rec,p_effective_date);
565 End ins;
566 --
567 -- ----------------------------------------------------------------------------
568 -- |---------------------------------< ins >----------------------------------|
569 -- ----------------------------------------------------------------------------
570 Procedure ins
571 (
572 p_salary_survey_line_id out nocopy number,
573 p_object_version_number out nocopy number,
574 p_salary_survey_id in number,
575 p_survey_job_name_code in varchar2,
576 p_survey_region_code in varchar2 default null,
577 p_survey_seniority_code in varchar2 default null,
578 p_company_size_code in varchar2 default null,
579 p_industry_code in varchar2 default null,
580 p_survey_age_code in varchar2 default null,
581 p_start_date in date,
582 p_end_date in date default null,
583 p_currency_code in varchar2,
584 p_differential in number default null,
585 p_minimum_pay in number default null,
586 p_mean_pay in number default null,
587 p_maximum_pay in number default null,
588 p_graduate_pay in number default null,
589 p_starting_pay in number default null,
590 p_percentage_change in number default null,
591 p_job_first_quartile in number default null,
592 p_job_median_quartile in number default null,
593 p_job_third_quartile in number default null,
594 p_job_fourth_quartile in number default null,
595 p_minimum_total_compensation in number default null,
596 p_mean_total_compensation in number default null,
597 p_maximum_total_compensation in number default null,
598 p_compnstn_first_quartile in number default null,
599 p_compnstn_median_quartile in number default null,
600 p_compnstn_third_quartile in number default null,
601 p_compnstn_fourth_quartile in number default null,
602 /*Added for Enhancement 4021737 */
603 p_tenth_percentile in number default null,
604 p_twenty_fifth_percentile in number default null,
605 p_fiftieth_percentile in number default null,
606 p_seventy_fifth_percentile in number default null,
607 p_ninetieth_percentile in number default null,
608 p_minimum_bonus in number default null,
609 p_mean_bonus in number default null,
610 p_maximum_bonus in number default null,
611 p_minimum_salary_increase in number default null,
612 p_mean_salary_increase in number default null,
613 p_maximum_salary_increase in number default null,
614 p_min_variable_compensation in number default null,
615 p_mean_variable_compensation in number default null,
616 p_max_variable_compensation in number default null,
617 p_minimum_stock in number default null,
618 p_mean_stock in number default null,
619 p_maximum_stock in number default null,
620 p_stock_display_type in varchar2 default null,
621 /*End Enhancement 4021737 */
622 p_attribute_category in varchar2 default null,
623 p_attribute1 in varchar2 default null,
624 p_attribute2 in varchar2 default null,
625 p_attribute3 in varchar2 default null,
626 p_attribute4 in varchar2 default null,
627 p_attribute5 in varchar2 default null,
628 p_attribute6 in varchar2 default null,
629 p_attribute7 in varchar2 default null,
630 p_attribute8 in varchar2 default null,
631 p_attribute9 in varchar2 default null,
632 p_attribute10 in varchar2 default null,
633 p_attribute11 in varchar2 default null,
634 p_attribute12 in varchar2 default null,
635 p_attribute13 in varchar2 default null,
636 p_attribute14 in varchar2 default null,
637 p_attribute15 in varchar2 default null,
638 p_attribute16 in varchar2 default null,
639 p_attribute17 in varchar2 default null,
640 p_attribute18 in varchar2 default null,
641 p_attribute19 in varchar2 default null,
642 p_attribute20 in varchar2 default null,
643 /*Added for Enhancement 4021737 */
644 p_attribute21 in varchar2 default null,
645 p_attribute22 in varchar2 default null,
646 p_attribute23 in varchar2 default null,
647 p_attribute24 in varchar2 default null,
648 p_attribute25 in varchar2 default null,
649 p_attribute26 in varchar2 default null,
650 p_attribute27 in varchar2 default null,
651 p_attribute28 in varchar2 default null,
652 p_attribute29 in varchar2 default null,
653 p_attribute30 in varchar2 default null,
654 /*End Enhancement 4021737 */
655 p_effective_date in date default null
656 ) is
657 --
658 l_rec per_ssl_shd.g_rec_type;
659 l_proc varchar2(72) := g_package||'ins';
660 --
661 Begin
662 hr_utility.set_location('Entering:'||l_proc, 5);
663 --
664 -- Call conversion function to turn arguments into the
665 -- p_rec structure.
666 --
667 l_rec :=
668 per_ssl_shd.convert_args
669 (
670 null,
671 null,
672 p_salary_survey_id,
673 p_survey_job_name_code,
674 p_survey_region_code,
675 p_survey_seniority_code,
676 p_company_size_code,
677 p_industry_code,
678 p_survey_age_code,
679 p_start_date,
680 p_end_date,
681 p_currency_code,
682 p_differential,
683 p_minimum_pay,
684 p_mean_pay,
685 p_maximum_pay,
686 p_graduate_pay,
687 p_starting_pay,
688 p_percentage_change,
689 p_job_first_quartile,
690 p_job_median_quartile,
691 p_job_third_quartile,
692 p_job_fourth_quartile,
693 p_minimum_total_compensation,
694 p_mean_total_compensation,
695 p_maximum_total_compensation,
696 p_compnstn_first_quartile,
697 p_compnstn_median_quartile,
698 p_compnstn_third_quartile,
699 p_compnstn_fourth_quartile,
700 /*Added for Enhancement 4021737 */
701 p_tenth_percentile,
702 p_twenty_fifth_percentile,
703 p_fiftieth_percentile,
704 p_seventy_fifth_percentile,
705 p_ninetieth_percentile,
706 p_minimum_bonus,
707 p_mean_bonus,
708 p_maximum_bonus,
709 p_minimum_salary_increase,
710 p_mean_salary_increase,
711 p_maximum_salary_increase,
712 p_min_variable_compensation,
713 p_mean_variable_compensation,
714 p_max_variable_compensation,
715 p_minimum_stock,
716 p_mean_stock,
717 p_maximum_stock,
718 p_stock_display_type,
719 /*End Enhancement 4021737 */
720 p_attribute_category,
721 p_attribute1,
722 p_attribute2,
723 p_attribute3,
724 p_attribute4,
725 p_attribute5,
726 p_attribute6,
727 p_attribute7,
728 p_attribute8,
729 p_attribute9,
730 p_attribute10,
731 p_attribute11,
732 p_attribute12,
733 p_attribute13,
734 p_attribute14,
735 p_attribute15,
736 p_attribute16,
737 p_attribute17,
738 p_attribute18,
739 p_attribute19,
740 p_attribute20,
741 /*Added for Enhancement 4021737 */
742 p_attribute21,
743 p_attribute22,
744 p_attribute23,
745 p_attribute24,
746 p_attribute25,
747 p_attribute26,
748 p_attribute27,
749 p_attribute28,
750 p_attribute29,
751 p_attribute30
752 /*End Enhancement 4021737 */
753 );
754 --
755 -- Having converted the arguments into the per_ssl_rec
756 -- plsql record structure we call the corresponding record business process.
757 --
758 ins(l_rec, p_effective_date);
759 --
760 -- As the primary key argument(s)
761 -- are specIfied as an OUT's we must set these values.
762 --
763 p_salary_survey_line_id := l_rec.salary_survey_line_id;
764 p_object_version_number := l_rec.object_version_number;
765 --
766 hr_utility.set_location(' Leaving:'||l_proc, 10);
767 End ins;
768 --
769 End per_ssl_ins;