[Home] [Help]
PACKAGE BODY: APPS.IRC_ISC_INS
Source
1 Package Body irc_isc_ins as
2 /* $Header: iriscrhi.pkb 120.1 2010/12/17 05:32:56 prasashe ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' irc_isc_ins.'; -- Global package name
9 --
10 -- The following global variables are only to be used by
11 -- the set_base_key_value and pre_insert procedures.
12 --
13 g_search_criteria_id_i number default null;
14 --
15 -- ----------------------------------------------------------------------------
16 -- |------------------------< set_base_key_value >----------------------------|
17 -- ----------------------------------------------------------------------------
18 procedure set_base_key_value
19 (p_search_criteria_id in number) is
20 --
21 l_proc varchar2(72) := g_package||'set_base_key_value';
22 --
23 Begin
24 hr_utility.set_location('Entering:'||l_proc, 10);
25 --
26 irc_isc_ins.g_search_criteria_id_i := p_search_criteria_id;
27 --
28 hr_utility.set_location(' Leaving:'||l_proc, 20);
29 End set_base_key_value;
30 --
31 --
32 -- ----------------------------------------------------------------------------
33 -- |------------------------------< insert_dml >------------------------------|
34 -- ----------------------------------------------------------------------------
35 -- {Start Of Comments}
36 --
37 -- Description:
38 -- This procedure controls the actual dml insert logic. The processing of
39 -- this procedure are as follows:
40 -- 1) Initialise the object_version_number to 1 if the object_version_number
41 -- is defined as an attribute for this entity.
42 -- 2) To set and unset the g_api_dml status as required (as we are about to
43 -- perform dml).
44 -- 3) To insert the row into the schema.
45 -- 4) To trap any constraint violations that may have occurred.
46 -- 5) To raise any other errors.
47 --
48 -- Prerequisites:
49 -- This is an internal private procedure which must be called from the ins
50 -- procedure and must have all mandatory attributes set (except the
51 -- object_version_number which is initialised within this procedure).
52 --
53 -- In Parameters:
54 -- A Pl/Sql record structre.
55 --
56 -- Post Success:
57 -- The specified row will be inserted into the schema.
58 --
59 -- Post Failure:
60 -- On the insert dml failure it is important to note that we always reset the
61 -- g_api_dml status to false.
62 -- If a check, unique or parent integrity constraint violation is raised the
63 -- constraint_error procedure will be called.
64 -- If any other error is reported, the error will be raised after the
65 -- g_api_dml status is reset.
66 --
67 -- Developer Implementation Notes:
68 -- None.
69 --
70 -- Access Status:
71 -- Internal Row Handler Use Only.
72 --
73 -- {End Of Comments}
74 -- ----------------------------------------------------------------------------
75 Procedure insert_dml
76 (p_rec in out nocopy irc_isc_shd.g_rec_type
77 ) is
78 --
79 l_proc varchar2(72) := g_package||'insert_dml';
80 l_description clob;
81 l_geometry mdsys.sdo_geometry :=null;
82 --
83 Begin
84 hr_utility.set_location('Entering:'||l_proc, 5);
85 p_rec.object_version_number := 1; -- Initialise the object version
86 --
87 irc_isc_shd.g_api_dml := true; -- Set the api dml status
88 --
89 -- Insert the row into: irc_search_criteria
90 --
91 if p_rec.longitude is not null and p_rec.latitude is not null then
92 l_geometry:=mdsys.sdo_geometry(2001,8307
93 ,mdsys.sdo_point_type(p_rec.longitude,p_rec.latitude,null),null,null);
94 end if;
95 --
96 insert into irc_search_criteria
97 (search_criteria_id
98 ,object_id
99 ,object_type
100 ,search_name
101 ,search_type
102 ,location
103 ,distance_to_location
104 ,geocode_location
105 ,geocode_country
106 ,derived_location
107 ,location_id
108 ,geometry
109 ,employee
110 ,contractor
111 ,employment_category
112 ,keywords
113 ,travel_percentage
114 ,min_salary
115 ,max_salary
116 ,salary_currency
117 ,salary_period
118 ,match_competence
119 ,match_qualification
120 ,job_title
121 ,department
122 ,professional_area
123 ,work_at_home
124 ,min_qual_level
125 ,max_qual_level
126 ,use_for_matching
127 ,description
128 ,attribute_category
129 ,attribute1
130 ,attribute2
131 ,attribute3
132 ,attribute4
133 ,attribute5
134 ,attribute6
135 ,attribute7
136 ,attribute8
137 ,attribute9
138 ,attribute10
139 ,attribute11
140 ,attribute12
141 ,attribute13
142 ,attribute14
143 ,attribute15
144 ,attribute16
145 ,attribute17
146 ,attribute18
147 ,attribute19
148 ,attribute20
149 ,attribute21
150 ,attribute22
151 ,attribute23
152 ,attribute24
153 ,attribute25
154 ,attribute26
155 ,attribute27
156 ,attribute28
157 ,attribute29
158 ,attribute30
159 ,isc_information_category
160 ,isc_information1
161 ,isc_information2
162 ,isc_information3
163 ,isc_information4
164 ,isc_information5
165 ,isc_information6
166 ,isc_information7
167 ,isc_information8
168 ,isc_information9
169 ,isc_information10
170 ,isc_information11
171 ,isc_information12
172 ,isc_information13
173 ,isc_information14
174 ,isc_information15
175 ,isc_information16
176 ,isc_information17
177 ,isc_information18
178 ,isc_information19
179 ,isc_information20
180 ,isc_information21
181 ,isc_information22
182 ,isc_information23
183 ,isc_information24
184 ,isc_information25
185 ,isc_information26
186 ,isc_information27
187 ,isc_information28
188 ,isc_information29
189 ,isc_information30
190 ,object_version_number
191 ,date_posted
192 )
193 Values
194 (p_rec.search_criteria_id
195 ,p_rec.object_id
196 ,p_rec.object_type
197 ,p_rec.search_name
198 ,p_rec.search_type
199 ,p_rec.location
200 ,p_rec.distance_to_location
201 ,p_rec.geocode_location
202 ,p_rec.geocode_country
203 ,p_rec.derived_location
204 ,p_rec.location_id
205 ,l_geometry
206 ,p_rec.employee
207 ,p_rec.contractor
208 ,p_rec.employment_category
209 ,p_rec.keywords
210 ,p_rec.travel_percentage
211 ,p_rec.min_salary
212 ,p_rec.max_salary
213 ,p_rec.salary_currency
214 ,p_rec.salary_period
215 ,p_rec.match_competence
216 ,p_rec.match_qualification
217 ,p_rec.job_title
218 ,p_rec.department
219 ,p_rec.professional_area
220 ,p_rec.work_at_home
221 ,p_rec.min_qual_level
222 ,p_rec.max_qual_level
223 ,p_rec.use_for_matching
224 ,empty_clob()
225 ,p_rec.attribute_category
226 ,p_rec.attribute1
227 ,p_rec.attribute2
228 ,p_rec.attribute3
229 ,p_rec.attribute4
230 ,p_rec.attribute5
231 ,p_rec.attribute6
232 ,p_rec.attribute7
233 ,p_rec.attribute8
234 ,p_rec.attribute9
235 ,p_rec.attribute10
236 ,p_rec.attribute11
237 ,p_rec.attribute12
238 ,p_rec.attribute13
239 ,p_rec.attribute14
240 ,p_rec.attribute15
241 ,p_rec.attribute16
242 ,p_rec.attribute17
243 ,p_rec.attribute18
244 ,p_rec.attribute19
245 ,p_rec.attribute20
246 ,p_rec.attribute21
247 ,p_rec.attribute22
248 ,p_rec.attribute23
249 ,p_rec.attribute24
250 ,p_rec.attribute25
251 ,p_rec.attribute26
252 ,p_rec.attribute27
253 ,p_rec.attribute28
254 ,p_rec.attribute29
255 ,p_rec.attribute30
256 ,p_rec.isc_information_category
257 ,p_rec.isc_information1
258 ,p_rec.isc_information2
259 ,p_rec.isc_information3
260 ,p_rec.isc_information4
261 ,p_rec.isc_information5
262 ,p_rec.isc_information6
263 ,p_rec.isc_information7
264 ,p_rec.isc_information8
265 ,p_rec.isc_information9
266 ,p_rec.isc_information10
267 ,p_rec.isc_information11
268 ,p_rec.isc_information12
269 ,p_rec.isc_information13
270 ,p_rec.isc_information14
271 ,p_rec.isc_information15
272 ,p_rec.isc_information16
273 ,p_rec.isc_information17
274 ,p_rec.isc_information18
275 ,p_rec.isc_information19
276 ,p_rec.isc_information20
277 ,p_rec.isc_information21
278 ,p_rec.isc_information22
279 ,p_rec.isc_information23
280 ,p_rec.isc_information24
281 ,p_rec.isc_information25
282 ,p_rec.isc_information26
283 ,p_rec.isc_information27
284 ,p_rec.isc_information28
285 ,p_rec.isc_information29
286 ,p_rec.isc_information30
287 ,p_rec.object_version_number
288 ,p_rec.date_posted
289 )
290 returning description into l_description;
291 --
292 if (p_rec.description is not null) then
293 hr_utility.set_location(l_proc, 10);
294 dbms_lob.write(l_description
295 ,length(p_rec.description)
296 ,1
297 ,p_rec.description);
298 end if;
299
300 irc_isc_shd.g_api_dml := false; -- Unset the api dml status
301 --
302 hr_utility.set_location(' Leaving:'||l_proc, 20);
303 Exception
304 When hr_api.check_integrity_violated Then
305 -- A check constraint has been violated
306 irc_isc_shd.g_api_dml := false; -- Unset the api dml status
307 --
308 irc_isc_shd.constraint_error
309 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
310 When hr_api.parent_integrity_violated Then
311 -- Parent integrity has been violated
312 irc_isc_shd.g_api_dml := false; -- Unset the api dml status
313 --
314 irc_isc_shd.constraint_error
315 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
316 When hr_api.unique_integrity_violated Then
317 -- Unique integrity has been violated
318 irc_isc_shd.g_api_dml := false; -- Unset the api dml status
319 --
320 irc_isc_shd.constraint_error
321 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
322 When Others Then
323 irc_isc_shd.g_api_dml := false; -- Unset the api dml status
324 --
325 Raise;
326 End insert_dml;
327 --
328 -- ----------------------------------------------------------------------------
329 -- |------------------------------< pre_insert >------------------------------|
330 -- ----------------------------------------------------------------------------
331 -- {Start Of Comments}
332 --
333 -- Description:
334 -- This private procedure contains any processing which is required before
335 -- the insert dml. Presently, if the entity has a corresponding primary
336 -- key which is maintained by an associating sequence, the primary key for
337 -- the entity will be populated with the next sequence value in
338 -- preparation for the insert dml.
339 --
340 -- Prerequisites:
341 -- This is an internal procedure which is called from the ins procedure.
342 --
343 -- In Parameters:
344 -- A Pl/Sql record structure.
345 --
346 -- Post Success:
347 -- Processing continues.
348 --
349 -- Post Failure:
350 -- If an error has occurred, an error message and exception will be raised
351 -- but not handled.
352 --
353 -- Developer Implementation Notes:
354 -- Any pre-processing required before the insert dml is issued should be
355 -- coded within this procedure. As stated above, a good example is the
356 -- generation of a primary key number via a corresponding sequence.
357 -- It is important to note that any 3rd party maintenance should be reviewed
358 -- before placing in this procedure.
359 --
360 -- Access Status:
361 -- Internal Row Handler Use Only.
362 --
363 -- {End Of Comments}
364 -- ----------------------------------------------------------------------------
365 Procedure pre_insert
366 (p_rec in out nocopy irc_isc_shd.g_rec_type
367 ) is
368 --
369 Cursor C_Sel1 is select irc_search_criteria_s.nextval from sys.dual;
370 --
371 Cursor C_Sel2 is
372 Select null
373 from irc_search_criteria
374 where search_criteria_id =
375 irc_isc_ins.g_search_criteria_id_i;
376 --
377 l_proc varchar2(72) := g_package||'pre_insert';
378 l_exists varchar2(1);
379 --
380 Begin
381 hr_utility.set_location('Entering:'||l_proc, 5);
382 --
383 If (irc_isc_ins.g_search_criteria_id_i is not null) Then
384 --
385 -- Verify registered primary key values not already in use
386 --
387 Open C_Sel2;
388 Fetch C_Sel2 into l_exists;
389 If C_Sel2%found Then
390 Close C_Sel2;
391 --
392 -- The primary key values are already in use.
393 --
394 fnd_message.set_name('PER','PER_289391_KEY_ALREADY_USED');
395 fnd_message.set_token('TABLE_NAME','irc_search_criteria');
396 fnd_message.raise_error;
397 End If;
398 Close C_Sel2;
399 --
400 -- Use registered key values and clear globals
401 --
402 p_rec.search_criteria_id :=
403 irc_isc_ins.g_search_criteria_id_i;
404 irc_isc_ins.g_search_criteria_id_i := null;
405 Else
406 --
407 -- No registerd key values, so select the next sequence number
408 --
409 --
410 -- Select the next sequence number
411 --
412 Open C_Sel1;
413 Fetch C_Sel1 Into p_rec.search_criteria_id;
414 Close C_Sel1;
415 End If;
416 --
417 hr_utility.set_location(' Leaving:'||l_proc, 10);
418 End pre_insert;
419 --
420 -- ----------------------------------------------------------------------------
421 -- |-----------------------------< post_insert >------------------------------|
422 -- ----------------------------------------------------------------------------
423 -- {Start Of Comments}
424 --
425 -- Description:
426 -- This private procedure contains any processing which is required after
427 -- the insert dml.
428 --
429 -- Prerequisites:
430 -- This is an internal procedure which is called from the ins procedure.
431 --
432 -- In Parameters:
433 -- A Pl/Sql record structre.
434 --
435 -- Post Success:
436 -- Processing continues.
437 --
438 -- Post Failure:
439 -- If an error has occurred, an error message and exception will be raised
440 -- but not handled.
441 --
442 -- Developer Implementation Notes:
443 -- Any post-processing required after the insert dml is issued should be
444 -- coded within this procedure. It is important to note that any 3rd party
445 -- maintenance should be reviewed before placing in this procedure.
446 --
447 -- Access Status:
448 -- Internal Row Handler Use Only.
449 --
450 -- {End Of Comments}
451 -- ----------------------------------------------------------------------------
452 Procedure post_insert
453 (p_effective_date in date
454 ,p_rec in irc_isc_shd.g_rec_type
455 ) is
456 --
457 l_proc varchar2(72) := g_package||'post_insert';
458 --
459 Begin
460 hr_utility.set_location('Entering:'||l_proc, 5);
461 begin
462 --
463 irc_isc_rki.after_insert
464 (p_effective_date => p_effective_date
465 ,p_search_criteria_id
466 => p_rec.search_criteria_id
467 ,p_object_id
468 => p_rec.object_id
469 ,p_object_type
470 => p_rec.object_type
471 ,p_search_name
472 => p_rec.search_name
473 ,p_search_type
474 => p_rec.search_type
475 ,p_location
476 => p_rec.location
477 ,p_distance_to_location
478 => p_rec.distance_to_location
479 ,p_geocode_location
480 =>p_rec.geocode_location
481 ,p_geocode_country
482 =>p_rec.geocode_country
483 ,p_derived_location
484 =>p_rec.derived_location
485 ,p_location_id
486 =>p_rec.location_id
487 ,p_longitude
488 =>p_rec.longitude
489 ,p_latitude
490 =>p_rec.latitude
491 ,p_employee
492 => p_rec.employee
493 ,p_contractor
494 => p_rec.contractor
495 ,p_employment_category
496 => p_rec.employment_category
497 ,p_keywords
498 => p_rec.keywords
499 ,p_travel_percentage
500 => p_rec.travel_percentage
501 ,p_min_salary
502 => p_rec.min_salary
503 ,p_max_salary
504 => p_rec.max_salary
505 ,p_salary_currency
506 => p_rec.salary_currency
507 ,p_salary_period
508 => p_rec.salary_period
509 ,p_match_competence
510 => p_rec.match_competence
511 ,p_match_qualification
512 => p_rec.match_qualification
513 ,p_job_title
514 => p_rec.job_title
515 ,p_department
516 => p_rec.department
517 ,p_professional_area
518 => p_rec.professional_area
519 ,p_work_at_home
520 => p_rec.work_at_home
521 ,p_min_qual_level
522 => p_rec.min_qual_level
523 ,p_max_qual_level
524 => p_rec.max_qual_level
525 ,p_use_for_matching
526 => p_rec.use_for_matching
527 ,p_description
528 => p_rec.description
529 ,p_attribute_category
530 => p_rec.attribute_category
531 ,p_attribute1
532 => p_rec.attribute1
533 ,p_attribute2
534 => p_rec.attribute2
535 ,p_attribute3
536 => p_rec.attribute3
537 ,p_attribute4
538 => p_rec.attribute4
539 ,p_attribute5
540 => p_rec.attribute5
541 ,p_attribute6
542 => p_rec.attribute6
543 ,p_attribute7
544 => p_rec.attribute7
545 ,p_attribute8
546 => p_rec.attribute8
547 ,p_attribute9
548 => p_rec.attribute9
549 ,p_attribute10
550 => p_rec.attribute10
551 ,p_attribute11
552 => p_rec.attribute11
553 ,p_attribute12
554 => p_rec.attribute12
555 ,p_attribute13
556 => p_rec.attribute13
557 ,p_attribute14
558 => p_rec.attribute14
559 ,p_attribute15
560 => p_rec.attribute15
561 ,p_attribute16
562 => p_rec.attribute16
563 ,p_attribute17
564 => p_rec.attribute17
565 ,p_attribute18
566 => p_rec.attribute18
567 ,p_attribute19
568 => p_rec.attribute19
569 ,p_attribute20
570 => p_rec.attribute20
571 ,p_attribute21
572 => p_rec.attribute21
573 ,p_attribute22
574 => p_rec.attribute22
575 ,p_attribute23
576 => p_rec.attribute23
577 ,p_attribute24
578 => p_rec.attribute24
579 ,p_attribute25
580 => p_rec.attribute25
581 ,p_attribute26
582 => p_rec.attribute26
583 ,p_attribute27
584 => p_rec.attribute27
585 ,p_attribute28
586 => p_rec.attribute28
587 ,p_attribute29
588 => p_rec.attribute29
589 ,p_attribute30
590 => p_rec.attribute30
591 ,p_isc_information_category
592 => p_rec.isc_information_category
593 ,p_isc_information1
594 => p_rec.isc_information1
595 ,p_isc_information2
596 => p_rec.isc_information2
597 ,p_isc_information3
598 => p_rec.isc_information3
599 ,p_isc_information4
600 => p_rec.isc_information4
601 ,p_isc_information5
602 => p_rec.isc_information5
603 ,p_isc_information6
604 => p_rec.isc_information6
605 ,p_isc_information7
606 => p_rec.isc_information7
607 ,p_isc_information8
608 => p_rec.isc_information8
609 ,p_isc_information9
610 => p_rec.isc_information9
611 ,p_isc_information10
612 => p_rec.isc_information10
613 ,p_isc_information11
614 => p_rec.isc_information11
615 ,p_isc_information12
616 => p_rec.isc_information12
617 ,p_isc_information13
618 => p_rec.isc_information13
619 ,p_isc_information14
620 => p_rec.isc_information14
621 ,p_isc_information15
622 => p_rec.isc_information15
623 ,p_isc_information16
624 => p_rec.isc_information16
625 ,p_isc_information17
626 => p_rec.isc_information17
627 ,p_isc_information18
628 => p_rec.isc_information18
629 ,p_isc_information19
630 => p_rec.isc_information19
631 ,p_isc_information20
632 => p_rec.isc_information20
633 ,p_isc_information21
634 => p_rec.isc_information21
635 ,p_isc_information22
636 => p_rec.isc_information22
637 ,p_isc_information23
638 => p_rec.isc_information23
639 ,p_isc_information24
640 => p_rec.isc_information24
641 ,p_isc_information25
642 => p_rec.isc_information25
643 ,p_isc_information26
644 => p_rec.isc_information26
645 ,p_isc_information27
646 => p_rec.isc_information27
647 ,p_isc_information28
648 => p_rec.isc_information28
649 ,p_isc_information29
650 => p_rec.isc_information29
651 ,p_isc_information30
652 => p_rec.isc_information30
653 ,p_object_version_number
654 => p_rec.object_version_number
655 ,p_date_posted
656 => p_rec.date_posted
657 );
658 --
659 exception
660 --
661 when hr_api.cannot_find_prog_unit then
662 --
663 hr_api.cannot_find_prog_unit_error
664 (p_module_name => 'IRC_SEARCH_CRITERIA'
665 ,p_hook_type => 'AI');
666 --
667 end;
668 --
669 hr_utility.set_location(' Leaving:'||l_proc, 10);
670 End post_insert;
671 --
672 -- ----------------------------------------------------------------------------
673 -- |---------------------------------< ins >----------------------------------|
674 -- ----------------------------------------------------------------------------
675 Procedure ins
676 (p_effective_date in date
677 ,p_rec in out nocopy irc_isc_shd.g_rec_type
678 ) is
679 --
680 l_proc varchar2(72) := g_package||'ins';
681 --
682 Begin
683 hr_utility.set_location('Entering:'||l_proc, 5);
684 --
685 -- Call the supporting insert validate operations
686 --
687 irc_isc_bus.insert_validate
688 (p_effective_date
689 ,p_rec
690 );
691 --
692 -- Call to raise any errors on multi-message list
693 hr_multi_message.end_validation_set;
694 --
695 -- Call the supporting pre-insert operation
696 --
697 irc_isc_ins.pre_insert(p_rec);
698 --
699 -- Insert the row
700 --
701 irc_isc_ins.insert_dml(p_rec);
702 --
703 -- Call the supporting post-insert operation
704 --
705 irc_isc_ins.post_insert
706 (p_effective_date
707 ,p_rec
708 );
709 --
710 -- Call to raise any errors on multi-message list
711 hr_multi_message.end_validation_set;
712 --
713 hr_utility.set_location('Leaving:'||l_proc, 20);
714 end ins;
715 --
716 -- ----------------------------------------------------------------------------
717 -- |---------------------------------< ins >----------------------------------|
718 -- ----------------------------------------------------------------------------
719 Procedure ins
720 (p_effective_date in date
721 ,p_object_id in number
722 ,p_object_type in varchar2
723 ,p_search_name in varchar2 default null
724 ,p_search_type in varchar2 default null
725 ,p_location in varchar2 default null
726 ,p_distance_to_location in varchar2 default null
727 ,p_geocode_location in varchar2 default null
728 ,p_geocode_country in varchar2 default null
729 ,p_derived_location in varchar2 default null
730 ,p_location_id in number default null
731 ,p_longitude in number default null
732 ,p_latitude in number default null
733 ,p_employee in varchar2 default null
734 ,p_contractor in varchar2 default null
735 ,p_employment_category in varchar2 default null
736 ,p_keywords in varchar2 default null
737 ,p_travel_percentage in number default null
738 ,p_min_salary in number default null
739 ,p_max_salary in number default null
740 ,p_salary_currency in varchar2 default null
741 ,p_salary_period in varchar2 default null
742 ,p_match_competence in varchar2 default null
743 ,p_match_qualification in varchar2 default null
744 ,p_job_title in varchar2 default null
745 ,p_department in varchar2 default null
746 ,p_professional_area in varchar2 default null
747 ,p_work_at_home in varchar2 default null
748 ,p_min_qual_level in number default null
749 ,p_max_qual_level in number default null
750 ,p_use_for_matching in varchar2 default null
751 ,p_description in varchar2 default null
752 ,p_attribute_category in varchar2 default null
753 ,p_attribute1 in varchar2 default null
754 ,p_attribute2 in varchar2 default null
755 ,p_attribute3 in varchar2 default null
756 ,p_attribute4 in varchar2 default null
757 ,p_attribute5 in varchar2 default null
758 ,p_attribute6 in varchar2 default null
759 ,p_attribute7 in varchar2 default null
760 ,p_attribute8 in varchar2 default null
761 ,p_attribute9 in varchar2 default null
762 ,p_attribute10 in varchar2 default null
763 ,p_attribute11 in varchar2 default null
764 ,p_attribute12 in varchar2 default null
765 ,p_attribute13 in varchar2 default null
766 ,p_attribute14 in varchar2 default null
767 ,p_attribute15 in varchar2 default null
768 ,p_attribute16 in varchar2 default null
769 ,p_attribute17 in varchar2 default null
770 ,p_attribute18 in varchar2 default null
771 ,p_attribute19 in varchar2 default null
772 ,p_attribute20 in varchar2 default null
773 ,p_attribute21 in varchar2 default null
774 ,p_attribute22 in varchar2 default null
775 ,p_attribute23 in varchar2 default null
776 ,p_attribute24 in varchar2 default null
777 ,p_attribute25 in varchar2 default null
778 ,p_attribute26 in varchar2 default null
779 ,p_attribute27 in varchar2 default null
780 ,p_attribute28 in varchar2 default null
781 ,p_attribute29 in varchar2 default null
782 ,p_attribute30 in varchar2 default null
783 ,p_isc_information_category in varchar2 default null
784 ,p_isc_information1 in varchar2 default null
785 ,p_isc_information2 in varchar2 default null
786 ,p_isc_information3 in varchar2 default null
787 ,p_isc_information4 in varchar2 default null
788 ,p_isc_information5 in varchar2 default null
789 ,p_isc_information6 in varchar2 default null
790 ,p_isc_information7 in varchar2 default null
791 ,p_isc_information8 in varchar2 default null
792 ,p_isc_information9 in varchar2 default null
793 ,p_isc_information10 in varchar2 default null
794 ,p_isc_information11 in varchar2 default null
795 ,p_isc_information12 in varchar2 default null
796 ,p_isc_information13 in varchar2 default null
797 ,p_isc_information14 in varchar2 default null
798 ,p_isc_information15 in varchar2 default null
799 ,p_isc_information16 in varchar2 default null
800 ,p_isc_information17 in varchar2 default null
801 ,p_isc_information18 in varchar2 default null
802 ,p_isc_information19 in varchar2 default null
803 ,p_isc_information20 in varchar2 default null
804 ,p_isc_information21 in varchar2 default null
805 ,p_isc_information22 in varchar2 default null
806 ,p_isc_information23 in varchar2 default null
807 ,p_isc_information24 in varchar2 default null
808 ,p_isc_information25 in varchar2 default null
809 ,p_isc_information26 in varchar2 default null
810 ,p_isc_information27 in varchar2 default null
811 ,p_isc_information28 in varchar2 default null
812 ,p_isc_information29 in varchar2 default null
813 ,p_isc_information30 in varchar2 default null
814 ,p_date_posted in varchar2 default null
815 ,p_search_criteria_id out nocopy number
816 ,p_object_version_number out nocopy number
817 ) is
818 --
819 l_rec irc_isc_shd.g_rec_type;
820 l_proc varchar2(72) := g_package||'ins';
821 --
822 Begin
823 hr_utility.set_location('Entering:'||l_proc, 5);
824 --
825 -- Call conversion function to turn arguments into the
826 -- p_rec structure.
827 --
828 l_rec :=
829 irc_isc_shd.convert_args
830 (null
831 ,p_object_id
832 ,p_object_type
833 ,p_search_name
834 ,p_search_type
835 ,p_location
836 ,p_distance_to_location
837 ,p_geocode_location
838 ,p_geocode_country
839 ,p_derived_location
840 ,p_location_id
841 ,p_longitude
842 ,p_latitude
843 ,p_employee
844 ,p_contractor
845 ,p_employment_category
846 ,p_keywords
847 ,p_travel_percentage
848 ,p_min_salary
849 ,p_max_salary
850 ,p_salary_currency
851 ,p_salary_period
852 ,p_match_competence
853 ,p_match_qualification
854 ,p_job_title
855 ,p_department
856 ,p_professional_area
857 ,p_work_at_home
858 ,p_min_qual_level
859 ,p_max_qual_level
860 ,p_use_for_matching
861 ,p_description
862 ,p_attribute_category
863 ,p_attribute1
864 ,p_attribute2
865 ,p_attribute3
866 ,p_attribute4
867 ,p_attribute5
868 ,p_attribute6
869 ,p_attribute7
870 ,p_attribute8
871 ,p_attribute9
872 ,p_attribute10
873 ,p_attribute11
874 ,p_attribute12
875 ,p_attribute13
876 ,p_attribute14
877 ,p_attribute15
878 ,p_attribute16
879 ,p_attribute17
880 ,p_attribute18
881 ,p_attribute19
882 ,p_attribute20
883 ,p_attribute21
884 ,p_attribute22
885 ,p_attribute23
886 ,p_attribute24
887 ,p_attribute25
888 ,p_attribute26
889 ,p_attribute27
890 ,p_attribute28
891 ,p_attribute29
892 ,p_attribute30
893 ,p_isc_information_category
894 ,p_isc_information1
895 ,p_isc_information2
896 ,p_isc_information3
897 ,p_isc_information4
898 ,p_isc_information5
899 ,p_isc_information6
900 ,p_isc_information7
901 ,p_isc_information8
902 ,p_isc_information9
903 ,p_isc_information10
904 ,p_isc_information11
905 ,p_isc_information12
906 ,p_isc_information13
907 ,p_isc_information14
908 ,p_isc_information15
909 ,p_isc_information16
910 ,p_isc_information17
911 ,p_isc_information18
912 ,p_isc_information19
913 ,p_isc_information20
914 ,p_isc_information21
915 ,p_isc_information22
916 ,p_isc_information23
917 ,p_isc_information24
918 ,p_isc_information25
919 ,p_isc_information26
920 ,p_isc_information27
921 ,p_isc_information28
922 ,p_isc_information29
923 ,p_isc_information30
924 ,null
925 ,p_date_posted
926 );
927 --
928 -- Having converted the arguments into the irc_isc_rec
929 -- plsql record structure we call the corresponding record business process.
930 --
931 irc_isc_ins.ins
932 (p_effective_date
933 ,l_rec
934 );
935 --
936 -- As the primary key argument(s)
937 -- are specified as an OUT's we must set these values.
938 --
939 p_search_criteria_id := l_rec.search_criteria_id;
940 p_object_version_number := l_rec.object_version_number;
941 --
942 hr_utility.set_location(' Leaving:'||l_proc, 10);
943 End ins;
944 --
945 end irc_isc_ins;