[Home] [Help]
PACKAGE BODY: APPS.IRC_ISC_UPD
Source
1 Package Body irc_isc_upd 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_upd.'; -- Global package name
9 g_description boolean;
10 --
11 -- ----------------------------------------------------------------------------
12 -- |------------------------------< update_dml >------------------------------|
13 -- ----------------------------------------------------------------------------
14 -- {Start Of Comments}
15 --
16 -- Description:
17 -- This procedure controls the actual dml update logic. The processing of
18 -- this procedure is:
19 -- 1) Increment the object_version_number by 1 if the object_version_number
20 -- is defined as an attribute for this entity.
21 -- 2) To set and unset the g_api_dml status as required (as we are about to
22 -- perform dml).
23 -- 3) To update the specified row in the schema using the primary key in
24 -- the predicates.
25 -- 4) To trap any constraint violations that may have occurred.
26 -- 5) To raise any other errors.
27 --
28 -- Prerequisites:
29 -- This is an internal private procedure which must be called from the upd
30 -- procedure.
31 --
32 -- In Parameters:
33 -- A Pl/Sql record structre.
34 --
35 -- Post Success:
36 -- The specified row will be updated in the schema.
37 --
38 -- Post Failure:
39 -- On the update dml failure it is important to note that we always reset the
40 -- g_api_dml status to false.
41 -- If a check, unique or parent integrity constraint violation is raised the
42 -- constraint_error procedure will be called.
43 -- If any other error is reported, the error will be raised after the
44 -- g_api_dml status is reset.
45 --
46 -- Developer Implementation Notes:
47 -- The update 'set' attribute list should be modified if any of your
48 -- attributes are not updateable.
49 --
50 -- Access Status:
51 -- Internal Row Handler Use Only.
52 --
53 -- {End Of Comments}
54 -- ----------------------------------------------------------------------------
55 Procedure update_dml
56 (p_rec in out nocopy irc_isc_shd.g_rec_type
57 ) is
58 --
59 l_proc varchar2(72) := g_package||'update_dml';
60 l_description clob;
61 l_geometry mdsys.sdo_geometry:=null;
62 --
63 Begin
64 hr_utility.set_location('Entering:'||l_proc, 5);
65 --
66 -- Increment the object version
67 p_rec.object_version_number := p_rec.object_version_number + 1;
68 --
69 if p_rec.longitude is not null and p_rec.latitude is not null then
70 l_geometry:=mdsys.sdo_geometry(2001,8307
71 ,mdsys.sdo_point_type(p_rec.longitude,p_rec.latitude,null),null,null);
72 end if;
73 --
74 irc_isc_shd.g_api_dml := true; -- Set the api dml status
75 --
76 -- Update the irc_search_criteria Row
77 --
78 update irc_search_criteria
79 set
80 search_criteria_id = p_rec.search_criteria_id
81 ,object_id = p_rec.object_id
82 ,object_type = p_rec.object_type
83 ,search_name = p_rec.search_name
84 ,search_type = p_rec.search_type
85 ,location = p_rec.location
86 ,distance_to_location = p_rec.distance_to_location
87 ,geocode_location = p_rec.geocode_location
88 ,geocode_country = p_rec.geocode_country
89 ,derived_location = p_rec.derived_location
90 ,location_id = p_rec.location_id
91 ,geometry = l_geometry
92 ,employee = p_rec.employee
93 ,contractor = p_rec.contractor
94 ,employment_category = p_rec.employment_category
95 ,keywords = p_rec.keywords
96 ,travel_percentage = p_rec.travel_percentage
97 ,min_salary = p_rec.min_salary
98 ,max_salary = p_rec.max_salary
99 ,salary_currency = p_rec.salary_currency
100 ,salary_period = p_rec.salary_period
101 ,match_competence = p_rec.match_competence
102 ,match_qualification = p_rec.match_qualification
103 ,job_title = p_rec.job_title
104 ,department = p_rec.department
105 ,professional_area = p_rec.professional_area
106 ,work_at_home = p_rec.work_at_home
107 ,min_qual_level = p_rec.min_qual_level
108 ,max_qual_level = p_rec.max_qual_level
109 ,use_for_matching = p_rec.use_for_matching
110 ,attribute_category = p_rec.attribute_category
111 ,attribute1 = p_rec.attribute1
112 ,attribute2 = p_rec.attribute2
113 ,attribute3 = p_rec.attribute3
114 ,attribute4 = p_rec.attribute4
115 ,attribute5 = p_rec.attribute5
116 ,attribute6 = p_rec.attribute6
117 ,attribute7 = p_rec.attribute7
118 ,attribute8 = p_rec.attribute8
119 ,attribute9 = p_rec.attribute9
120 ,attribute10 = p_rec.attribute10
121 ,attribute11 = p_rec.attribute11
122 ,attribute12 = p_rec.attribute12
123 ,attribute13 = p_rec.attribute13
124 ,attribute14 = p_rec.attribute14
125 ,attribute15 = p_rec.attribute15
126 ,attribute16 = p_rec.attribute16
127 ,attribute17 = p_rec.attribute17
128 ,attribute18 = p_rec.attribute18
129 ,attribute19 = p_rec.attribute19
130 ,attribute20 = p_rec.attribute20
131 ,attribute21 = p_rec.attribute21
132 ,attribute22 = p_rec.attribute22
133 ,attribute23 = p_rec.attribute23
134 ,attribute24 = p_rec.attribute24
135 ,attribute25 = p_rec.attribute25
136 ,attribute26 = p_rec.attribute26
137 ,attribute27 = p_rec.attribute27
138 ,attribute28 = p_rec.attribute28
139 ,attribute29 = p_rec.attribute29
140 ,attribute30 = p_rec.attribute30
141 ,isc_information_category = p_rec.isc_information_category
142 ,isc_information1 = p_rec.isc_information1
143 ,isc_information2 = p_rec.isc_information2
144 ,isc_information3 = p_rec.isc_information3
145 ,isc_information4 = p_rec.isc_information4
146 ,isc_information5 = p_rec.isc_information5
147 ,isc_information6 = p_rec.isc_information6
148 ,isc_information7 = p_rec.isc_information7
149 ,isc_information8 = p_rec.isc_information8
150 ,isc_information9 = p_rec.isc_information9
151 ,isc_information10 = p_rec.isc_information10
152 ,isc_information11 = p_rec.isc_information11
153 ,isc_information12 = p_rec.isc_information12
154 ,isc_information13 = p_rec.isc_information13
155 ,isc_information14 = p_rec.isc_information14
156 ,isc_information15 = p_rec.isc_information15
157 ,isc_information16 = p_rec.isc_information16
158 ,isc_information17 = p_rec.isc_information17
159 ,isc_information18 = p_rec.isc_information18
160 ,isc_information19 = p_rec.isc_information19
161 ,isc_information20 = p_rec.isc_information20
162 ,isc_information21 = p_rec.isc_information21
163 ,isc_information22 = p_rec.isc_information22
164 ,isc_information23 = p_rec.isc_information23
165 ,isc_information24 = p_rec.isc_information24
166 ,isc_information25 = p_rec.isc_information25
167 ,isc_information26 = p_rec.isc_information26
168 ,isc_information27 = p_rec.isc_information27
169 ,isc_information28 = p_rec.isc_information28
170 ,isc_information29 = p_rec.isc_information29
171 ,isc_information30 = p_rec.isc_information30
172 ,object_version_number = p_rec.object_version_number
173 ,date_posted = p_rec.date_posted
174 where search_criteria_id = p_rec.search_criteria_id
175 returning description into l_description;
176 --
177 if (g_description
178 and dbms_lob.getlength(l_description)<=32767
179 and dbms_lob.instr(l_description,p_rec.description)<>1)
183 dbms_lob.write(l_description
180 then
181 hr_utility.set_location(l_proc, 10);
182 dbms_lob.trim(l_description,0);
184 ,length(p_rec.description)
185 ,1
186 ,p_rec.description);
187 end if;
188 --
189 irc_isc_shd.g_api_dml := false; -- Unset the api dml status
190 --
191 hr_utility.set_location(' Leaving:'||l_proc, 20);
192 --
193 Exception
194 When hr_api.check_integrity_violated Then
195 -- A check constraint has been violated
196 irc_isc_shd.g_api_dml := false; -- Unset the api dml status
197 --
198 irc_isc_shd.constraint_error
199 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200 When hr_api.parent_integrity_violated Then
201 -- Parent integrity has been violated
202 irc_isc_shd.g_api_dml := false; -- Unset the api dml status
203 --
204 irc_isc_shd.constraint_error
205 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
206 When hr_api.unique_integrity_violated Then
207 -- Unique integrity has been violated
208 irc_isc_shd.g_api_dml := false; -- Unset the api dml status
209 --
210 irc_isc_shd.constraint_error
211 (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
212 When Others Then
213 irc_isc_shd.g_api_dml := false; -- Unset the api dml status
214 --
215 Raise;
216 End update_dml;
217 --
218 -- ----------------------------------------------------------------------------
219 -- |------------------------------< pre_update >------------------------------|
220 -- ----------------------------------------------------------------------------
221 -- {Start Of Comments}
222 --
223 -- Description:
224 -- This private procedure contains any processing which is required before
225 -- the update dml.
226 --
227 -- Prerequisites:
228 -- This is an internal procedure which is called from the upd procedure.
229 --
230 -- In Parameters:
231 -- A Pl/Sql record structure.
232 --
233 -- Post Success:
234 -- Processing continues.
235 --
236 -- Post Failure:
237 -- If an error has occurred, an error message and exception wil be raised
238 -- but not handled.
239 --
240 -- Developer Implementation Notes:
241 -- Any pre-processing required before the update dml is issued should be
242 -- coded within this procedure. It is important to note that any 3rd party
243 -- maintenance should be reviewed before placing in this procedure.
244 --
245 -- Access Status:
246 -- Internal Row Handler Use Only.
247 --
248 -- {End Of Comments}
249 -- ----------------------------------------------------------------------------
250 Procedure pre_update
251 (p_rec in irc_isc_shd.g_rec_type
252 ) is
253 --
254 l_proc varchar2(72) := g_package||'pre_update';
255 --
256 Begin
257 hr_utility.set_location('Entering:'||l_proc, 5);
258 --
259 hr_utility.set_location(' Leaving:'||l_proc, 10);
260 End pre_update;
261 --
262 -- ----------------------------------------------------------------------------
263 -- |-----------------------------< post_update >------------------------------|
264 -- ----------------------------------------------------------------------------
265 -- {Start Of Comments}
266 --
267 -- Description:
268 -- This private procedure contains any processing which is required after
269 -- the update dml.
270 --
271 -- Prerequisites:
272 -- This is an internal procedure which is called from the upd procedure.
273 --
274 -- In Parameters:
275 -- A Pl/Sql record structure.
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 post-processing required after the update dml is issued should be
286 -- coded within this procedure. It is important to note that any 3rd party
287 -- maintenance should be reviewed before placing in this procedure.
288 --
289 -- Access Status:
290 -- Internal Row Handler Use Only.
291 --
292 -- {End Of Comments}
293 -- ----------------------------------------------------------------------------
294 Procedure post_update
295 (p_effective_date in date
296 ,p_rec in irc_isc_shd.g_rec_type
297 ) is
298 --
299 l_proc varchar2(72) := g_package||'post_update';
300 --
301 Begin
302 hr_utility.set_location('Entering:'||l_proc, 5);
303 begin
304 --
305 irc_isc_rku.after_update
306 (p_effective_date => p_effective_date
307 ,p_search_criteria_id
308 => p_rec.search_criteria_id
309 ,p_object_id
310 => p_rec.object_id
311 ,p_object_type
312 => p_rec.object_type
313 ,p_search_name
314 => p_rec.search_name
315 ,p_search_type
316 => p_rec.search_type
317 ,p_location
318 => p_rec.location
319 ,p_distance_to_location
320 => p_rec.distance_to_location
321 ,p_geocode_location
322 =>p_rec.geocode_location
323 ,p_geocode_country
324 =>p_rec.geocode_country
325 ,p_derived_location
326 =>p_rec.derived_location
327 ,p_location_id
328 =>p_rec.location_id
329 ,p_longitude
330 =>p_rec.longitude
331 ,p_latitude
332 =>p_rec.latitude
333 ,p_employee
334 => p_rec.employee
335 ,p_contractor
336 => p_rec.contractor
337 ,p_employment_category
338 => p_rec.employment_category
339 ,p_keywords
340 => p_rec.keywords
341 ,p_travel_percentage
342 => p_rec.travel_percentage
343 ,p_min_salary
344 => p_rec.min_salary
345 ,p_max_salary
346 => p_rec.max_salary
347 ,p_salary_currency
348 => p_rec.salary_currency
349 ,p_salary_period
350 => p_rec.salary_period
351 ,p_match_competence
352 => p_rec.match_competence
353 ,p_match_qualification
354 => p_rec.match_qualification
355 ,p_job_title
356 => p_rec.job_title
357 ,p_department
358 => p_rec.department
359 ,p_professional_area
360 => p_rec.professional_area
361 ,p_work_at_home
362 => p_rec.work_at_home
363 ,p_min_qual_level
364 => p_rec.min_qual_level
365 ,p_max_qual_level
366 => p_rec.max_qual_level
367 ,p_use_for_matching
368 => p_rec.use_for_matching
369 ,p_description
370 => p_rec.description
371 ,p_attribute_category
372 => p_rec.attribute_category
373 ,p_attribute1
374 => p_rec.attribute1
375 ,p_attribute2
376 => p_rec.attribute2
377 ,p_attribute3
378 => p_rec.attribute3
379 ,p_attribute4
380 => p_rec.attribute4
381 ,p_attribute5
382 => p_rec.attribute5
383 ,p_attribute6
384 => p_rec.attribute6
385 ,p_attribute7
386 => p_rec.attribute7
387 ,p_attribute8
388 => p_rec.attribute8
389 ,p_attribute9
390 => p_rec.attribute9
391 ,p_attribute10
392 => p_rec.attribute10
393 ,p_attribute11
394 => p_rec.attribute11
395 ,p_attribute12
396 => p_rec.attribute12
397 ,p_attribute13
398 => p_rec.attribute13
399 ,p_attribute14
400 => p_rec.attribute14
401 ,p_attribute15
402 => p_rec.attribute15
403 ,p_attribute16
404 => p_rec.attribute16
405 ,p_attribute17
406 => p_rec.attribute17
407 ,p_attribute18
408 => p_rec.attribute18
409 ,p_attribute19
410 => p_rec.attribute19
411 ,p_attribute20
412 => p_rec.attribute20
413 ,p_attribute21
414 => p_rec.attribute21
415 ,p_attribute22
416 => p_rec.attribute22
417 ,p_attribute23
418 => p_rec.attribute23
419 ,p_attribute24
420 => p_rec.attribute24
421 ,p_attribute25
422 => p_rec.attribute25
423 ,p_attribute26
424 => p_rec.attribute26
425 ,p_attribute27
426 => p_rec.attribute27
427 ,p_attribute28
428 => p_rec.attribute28
429 ,p_attribute29
430 => p_rec.attribute29
431 ,p_attribute30
432 => p_rec.attribute30
433 ,p_isc_information_category
434 => p_rec.isc_information_category
435 ,p_isc_information1
436 => p_rec.isc_information1
437 ,p_isc_information2
438 => p_rec.isc_information2
439 ,p_isc_information3
440 => p_rec.isc_information3
441 ,p_isc_information4
442 => p_rec.isc_information4
443 ,p_isc_information5
444 => p_rec.isc_information5
445 ,p_isc_information6
446 => p_rec.isc_information6
447 ,p_isc_information7
448 => p_rec.isc_information7
449 ,p_isc_information8
450 => p_rec.isc_information8
451 ,p_isc_information9
452 => p_rec.isc_information9
453 ,p_isc_information10
454 => p_rec.isc_information10
455 ,p_isc_information11
456 => p_rec.isc_information11
457 ,p_isc_information12
458 => p_rec.isc_information12
459 ,p_isc_information13
460 => p_rec.isc_information13
461 ,p_isc_information14
462 => p_rec.isc_information14
463 ,p_isc_information15
464 => p_rec.isc_information15
465 ,p_isc_information16
466 => p_rec.isc_information16
467 ,p_isc_information17
468 => p_rec.isc_information17
469 ,p_isc_information18
470 => p_rec.isc_information18
471 ,p_isc_information19
472 => p_rec.isc_information19
473 ,p_isc_information20
474 => p_rec.isc_information20
475 ,p_isc_information21
476 => p_rec.isc_information21
477 ,p_isc_information22
478 => p_rec.isc_information22
479 ,p_isc_information23
480 => p_rec.isc_information23
481 ,p_isc_information24
482 => p_rec.isc_information24
483 ,p_isc_information25
484 => p_rec.isc_information25
485 ,p_isc_information26
486 => p_rec.isc_information26
487 ,p_isc_information27
488 => p_rec.isc_information27
489 ,p_isc_information28
490 => p_rec.isc_information28
491 ,p_isc_information29
492 => p_rec.isc_information29
493 ,p_isc_information30
494 => p_rec.isc_information30
495 ,p_object_version_number
496 => p_rec.object_version_number
497 ,p_date_posted
498 => p_rec.date_posted
499 ,p_object_id_o
500 => irc_isc_shd.g_old_rec.object_id
501 ,p_object_type_o
502 => irc_isc_shd.g_old_rec.object_type
503 ,p_search_name_o
504 => irc_isc_shd.g_old_rec.search_name
505 ,p_search_type_o
506 => irc_isc_shd.g_old_rec.search_type
507 ,p_location_o
508 => irc_isc_shd.g_old_rec.location
509 ,p_distance_to_location_o
510 => irc_isc_shd.g_old_rec.distance_to_location
511 ,p_geocode_location_o
512 =>irc_isc_shd.g_old_rec.geocode_location
513 ,p_geocode_country_o
514 =>irc_isc_shd.g_old_rec.geocode_country
515 ,p_derived_location_o
516 =>irc_isc_shd.g_old_rec.derived_location
517 ,p_location_id_o
518 =>irc_isc_shd.g_old_rec.location_id
519 ,p_longitude_o
520 =>irc_isc_shd.g_old_rec.longitude
521 ,p_latitude_o
522 =>irc_isc_shd.g_old_rec.latitude
523 ,p_employee_o
524 => irc_isc_shd.g_old_rec.employee
525 ,p_contractor_o
526 => irc_isc_shd.g_old_rec.contractor
527 ,p_employment_category_o
528 => irc_isc_shd.g_old_rec.employment_category
529 ,p_keywords_o
530 => irc_isc_shd.g_old_rec.keywords
531 ,p_travel_percentage_o
532 => irc_isc_shd.g_old_rec.travel_percentage
533 ,p_min_salary_o
534 => irc_isc_shd.g_old_rec.min_salary
535 ,p_max_salary_o
536 => irc_isc_shd.g_old_rec.max_salary
537 ,p_salary_currency_o
538 => irc_isc_shd.g_old_rec.salary_currency
539 ,p_salary_period_o
540 => irc_isc_shd.g_old_rec.salary_period
541 ,p_match_competence_o
542 => irc_isc_shd.g_old_rec.match_competence
543 ,p_match_qualification_o
544 => irc_isc_shd.g_old_rec.match_qualification
545 ,p_job_title_o
546 => irc_isc_shd.g_old_rec.job_title
547 ,p_department_o
548 => irc_isc_shd.g_old_rec.department
549 ,p_professional_area_o
550 => irc_isc_shd.g_old_rec.professional_area
551 ,p_work_at_home_o
552 => irc_isc_shd.g_old_rec.work_at_home
553 ,p_min_qual_level_o
554 => irc_isc_shd.g_old_rec.min_qual_level
555 ,p_max_qual_level_o
556 => irc_isc_shd.g_old_rec.max_qual_level
557 ,p_use_for_matching_o
558 => irc_isc_shd.g_old_rec.use_for_matching
559 ,p_description_o
560 => irc_isc_shd.g_old_rec.description
561 ,p_attribute_category_o
562 => irc_isc_shd.g_old_rec.attribute_category
563 ,p_attribute1_o
564 => irc_isc_shd.g_old_rec.attribute1
565 ,p_attribute2_o
566 => irc_isc_shd.g_old_rec.attribute2
567 ,p_attribute3_o
568 => irc_isc_shd.g_old_rec.attribute3
569 ,p_attribute4_o
570 => irc_isc_shd.g_old_rec.attribute4
571 ,p_attribute5_o
572 => irc_isc_shd.g_old_rec.attribute5
573 ,p_attribute6_o
574 => irc_isc_shd.g_old_rec.attribute6
575 ,p_attribute7_o
576 => irc_isc_shd.g_old_rec.attribute7
577 ,p_attribute8_o
578 => irc_isc_shd.g_old_rec.attribute8
579 ,p_attribute9_o
580 => irc_isc_shd.g_old_rec.attribute9
581 ,p_attribute10_o
582 => irc_isc_shd.g_old_rec.attribute10
583 ,p_attribute11_o
584 => irc_isc_shd.g_old_rec.attribute11
585 ,p_attribute12_o
586 => irc_isc_shd.g_old_rec.attribute12
587 ,p_attribute13_o
588 => irc_isc_shd.g_old_rec.attribute13
589 ,p_attribute14_o
590 => irc_isc_shd.g_old_rec.attribute14
591 ,p_attribute15_o
592 => irc_isc_shd.g_old_rec.attribute15
593 ,p_attribute16_o
594 => irc_isc_shd.g_old_rec.attribute16
595 ,p_attribute17_o
596 => irc_isc_shd.g_old_rec.attribute17
597 ,p_attribute18_o
598 => irc_isc_shd.g_old_rec.attribute18
599 ,p_attribute19_o
600 => irc_isc_shd.g_old_rec.attribute19
601 ,p_attribute20_o
602 => irc_isc_shd.g_old_rec.attribute20
603 ,p_attribute21_o
604 => irc_isc_shd.g_old_rec.attribute21
605 ,p_attribute22_o
606 => irc_isc_shd.g_old_rec.attribute22
607 ,p_attribute23_o
608 => irc_isc_shd.g_old_rec.attribute23
609 ,p_attribute24_o
610 => irc_isc_shd.g_old_rec.attribute24
611 ,p_attribute25_o
612 => irc_isc_shd.g_old_rec.attribute25
613 ,p_attribute26_o
614 => irc_isc_shd.g_old_rec.attribute26
615 ,p_attribute27_o
616 => irc_isc_shd.g_old_rec.attribute27
617 ,p_attribute28_o
618 => irc_isc_shd.g_old_rec.attribute28
619 ,p_attribute29_o
620 => irc_isc_shd.g_old_rec.attribute29
621 ,p_attribute30_o
622 => irc_isc_shd.g_old_rec.attribute30
623 ,p_isc_information_category_o
624 => irc_isc_shd.g_old_rec.isc_information_category
625 ,p_isc_information1_o
626 => irc_isc_shd.g_old_rec.isc_information1
627 ,p_isc_information2_o
628 => irc_isc_shd.g_old_rec.isc_information2
629 ,p_isc_information3_o
630 => irc_isc_shd.g_old_rec.isc_information3
631 ,p_isc_information4_o
632 => irc_isc_shd.g_old_rec.isc_information4
633 ,p_isc_information5_o
634 => irc_isc_shd.g_old_rec.isc_information5
635 ,p_isc_information6_o
636 => irc_isc_shd.g_old_rec.isc_information6
637 ,p_isc_information7_o
638 => irc_isc_shd.g_old_rec.isc_information7
639 ,p_isc_information8_o
640 => irc_isc_shd.g_old_rec.isc_information8
641 ,p_isc_information9_o
642 => irc_isc_shd.g_old_rec.isc_information9
643 ,p_isc_information10_o
644 => irc_isc_shd.g_old_rec.isc_information10
645 ,p_isc_information11_o
646 => irc_isc_shd.g_old_rec.isc_information11
647 ,p_isc_information12_o
648 => irc_isc_shd.g_old_rec.isc_information12
649 ,p_isc_information13_o
650 => irc_isc_shd.g_old_rec.isc_information13
651 ,p_isc_information14_o
652 => irc_isc_shd.g_old_rec.isc_information14
653 ,p_isc_information15_o
654 => irc_isc_shd.g_old_rec.isc_information15
655 ,p_isc_information16_o
656 => irc_isc_shd.g_old_rec.isc_information16
657 ,p_isc_information17_o
658 => irc_isc_shd.g_old_rec.isc_information17
659 ,p_isc_information18_o
660 => irc_isc_shd.g_old_rec.isc_information18
661 ,p_isc_information19_o
662 => irc_isc_shd.g_old_rec.isc_information19
663 ,p_isc_information20_o
664 => irc_isc_shd.g_old_rec.isc_information20
665 ,p_isc_information21_o
666 => irc_isc_shd.g_old_rec.isc_information21
667 ,p_isc_information22_o
668 => irc_isc_shd.g_old_rec.isc_information22
669 ,p_isc_information23_o
670 => irc_isc_shd.g_old_rec.isc_information23
671 ,p_isc_information24_o
672 => irc_isc_shd.g_old_rec.isc_information24
673 ,p_isc_information25_o
674 => irc_isc_shd.g_old_rec.isc_information25
675 ,p_isc_information26_o
676 => irc_isc_shd.g_old_rec.isc_information26
677 ,p_isc_information27_o
678 => irc_isc_shd.g_old_rec.isc_information27
679 ,p_isc_information28_o
680 => irc_isc_shd.g_old_rec.isc_information28
681 ,p_isc_information29_o
682 => irc_isc_shd.g_old_rec.isc_information29
683 ,p_isc_information30_o
684 => irc_isc_shd.g_old_rec.isc_information30
685 ,p_object_version_number_o
686 => irc_isc_shd.g_old_rec.object_version_number
687 ,p_date_posted_o
688 => irc_isc_shd.g_old_rec.date_posted
689 );
690 --
691 exception
692 --
693 when hr_api.cannot_find_prog_unit then
694 --
695 hr_api.cannot_find_prog_unit_error
696 (p_module_name => 'IRC_SEARCH_CRITERIA'
697 ,p_hook_type => 'AU');
698 --
699 end;
700 --
704 -- ----------------------------------------------------------------------------
701 hr_utility.set_location(' Leaving:'||l_proc, 10);
702 End post_update;
703 --
705 -- |-----------------------------< convert_defs >-----------------------------|
706 -- ----------------------------------------------------------------------------
707 -- {Start Of Comments}
708 --
709 -- Description:
710 -- The Convert_Defs procedure has one very important function:
711 -- It must return the record structure for the row with all system defaulted
712 -- values converted into its corresponding parameter value for update. When
713 -- we attempt to update a row through the Upd process , certain
714 -- parameters can be defaulted which enables flexibility in the calling of
715 -- the upd process (e.g. only attributes which need to be updated need to be
716 -- specified). For the upd process to determine which attributes
717 -- have NOT been specified we need to check if the parameter has a reserved
718 -- system default value. Therefore, for all parameters which have a
719 -- corresponding reserved system default mechanism specified we need to
720 -- check if a system default is being used. If a system default is being
721 -- used then we convert the defaulted value into its corresponding attribute
722 -- value held in the g_old_rec data structure.
723 --
724 -- Prerequisites:
725 -- This private function can only be called from the upd process.
726 --
727 -- In Parameters:
728 -- A Pl/Sql record structure.
729 --
730 -- Post Success:
731 -- The record structure will be returned with all system defaulted parameter
732 -- values converted into its current row attribute value.
733 --
734 -- Post Failure:
735 -- No direct error handling is required within this function. Any possible
736 -- errors within this procedure will be a PL/SQL value error due to
737 -- conversion of datatypes or data lengths.
738 --
739 -- Developer Implementation Notes:
740 -- None.
741 --
742 -- Access Status:
743 -- Internal Row Handler Use Only.
744 --
745 -- {End Of Comments}
746 -- ----------------------------------------------------------------------------
747 Procedure convert_defs
748 (p_rec in out nocopy irc_isc_shd.g_rec_type
749 ) is
750 --
751 Begin
752 --
753 -- We must now examine each argument value in the
754 -- p_rec plsql record structure
755 -- to see if a system default is being used. If a system default
756 -- is being used then we must set to the 'current' argument value.
757 --
758 If (p_rec.object_id = hr_api.g_number) then
759 p_rec.object_id :=
760 irc_isc_shd.g_old_rec.object_id;
761 End If;
762 If (p_rec.object_type = hr_api.g_varchar2) then
763 p_rec.object_type :=
764 irc_isc_shd.g_old_rec.object_type;
765 End If;
766 If (p_rec.search_name = hr_api.g_varchar2) then
767 p_rec.search_name :=
768 irc_isc_shd.g_old_rec.search_name;
769 End If;
770 If (p_rec.search_type = hr_api.g_varchar2) then
771 p_rec.search_type :=
772 irc_isc_shd.g_old_rec.search_type;
773 End If;
774 If (p_rec.location = hr_api.g_varchar2) then
775 p_rec.location :=
776 irc_isc_shd.g_old_rec.location;
777 End If;
778 If (p_rec.distance_to_location = hr_api.g_varchar2) then
779 p_rec.distance_to_location :=
780 irc_isc_shd.g_old_rec.distance_to_location;
781 End If;
782 If (p_rec.geocode_location = hr_api.g_varchar2) then
783 p_rec.geocode_location :=
784 irc_isc_shd.g_old_rec.geocode_location;
785 End If;
786 If (p_rec.geocode_country = hr_api.g_varchar2) then
787 p_rec.geocode_country :=
788 irc_isc_shd.g_old_rec.geocode_country;
789 End If;
790 If (p_rec.derived_location = hr_api.g_varchar2) then
791 p_rec.derived_location :=
792 irc_isc_shd.g_old_rec.derived_location;
793 End If;
794 If (p_rec.location_id = hr_api.g_number) then
795 p_rec.location_id :=
796 irc_isc_shd.g_old_rec.location_id;
797 End If;
798 If (p_rec.longitude = hr_api.g_number) then
799 p_rec.longitude :=
800 irc_isc_shd.g_old_rec.longitude;
801 End If;
802 If (p_rec.latitude = hr_api.g_number) then
803 p_rec.latitude :=
804 irc_isc_shd.g_old_rec.latitude;
805 End If;
806 If (p_rec.employee = hr_api.g_varchar2) then
807 p_rec.employee :=
808 irc_isc_shd.g_old_rec.employee;
809 End If;
810 If (p_rec.contractor = hr_api.g_varchar2) then
811 p_rec.contractor :=
812 irc_isc_shd.g_old_rec.contractor;
813 End If;
814 If (p_rec.employment_category = hr_api.g_varchar2) then
815 p_rec.employment_category :=
816 irc_isc_shd.g_old_rec.employment_category;
817 End If;
818 If (p_rec.keywords = hr_api.g_varchar2) then
819 p_rec.keywords :=
820 irc_isc_shd.g_old_rec.keywords;
821 End If;
822 If (p_rec.travel_percentage = hr_api.g_number) then
823 p_rec.travel_percentage :=
824 irc_isc_shd.g_old_rec.travel_percentage;
825 End If;
826 If (p_rec.min_salary = hr_api.g_number) then
827 p_rec.min_salary :=
828 irc_isc_shd.g_old_rec.min_salary;
829 End If;
830 If (p_rec.max_salary = hr_api.g_number) then
831 p_rec.max_salary :=
832 irc_isc_shd.g_old_rec.max_salary;
833 End If;
834 If (p_rec.salary_currency = hr_api.g_varchar2) then
835 p_rec.salary_currency :=
836 irc_isc_shd.g_old_rec.salary_currency;
837 End If;
838 If (p_rec.salary_period = hr_api.g_varchar2) then
839 p_rec.salary_period :=
840 irc_isc_shd.g_old_rec.salary_period;
841 End If;
842 If (p_rec.match_competence = hr_api.g_varchar2) then
843 p_rec.match_competence :=
844 irc_isc_shd.g_old_rec.match_competence;
845 End If;
846 If (p_rec.match_qualification = hr_api.g_varchar2) then
847 p_rec.match_qualification :=
848 irc_isc_shd.g_old_rec.match_qualification;
849 End If;
850 If (p_rec.job_title = hr_api.g_varchar2) then
851 p_rec.job_title :=
852 irc_isc_shd.g_old_rec.job_title;
853 End If;
854 If (p_rec.department = hr_api.g_varchar2) then
855 p_rec.department :=
856 irc_isc_shd.g_old_rec.department;
857 End If;
858 If (p_rec.professional_area = hr_api.g_varchar2) then
859 p_rec.professional_area :=
860 irc_isc_shd.g_old_rec.professional_area;
861 End If;
862 If (p_rec.work_at_home = hr_api.g_varchar2) then
863 p_rec.work_at_home :=
864 irc_isc_shd.g_old_rec.work_at_home;
865 End If;
866 If (p_rec.min_qual_level = hr_api.g_number) then
867 p_rec.min_qual_level :=
868 irc_isc_shd.g_old_rec.min_qual_level;
869 End If;
870 If (p_rec.max_qual_level = hr_api.g_number) then
871 p_rec.max_qual_level :=
872 irc_isc_shd.g_old_rec.max_qual_level;
873 End If;
874 If (p_rec.use_for_matching = hr_api.g_varchar2) then
875 p_rec.use_for_matching :=
876 irc_isc_shd.g_old_rec.use_for_matching;
877 End If;
878 If (p_rec.description = hr_api.g_varchar2) then
879 p_rec.description :=
880 irc_isc_shd.g_old_rec.description;
881 g_description:=false;
882 Else
883 g_description:=true;
884 End If;
885 If (p_rec.attribute_category = hr_api.g_varchar2) then
886 p_rec.attribute_category :=
887 irc_isc_shd.g_old_rec.attribute_category;
888 End If;
889 If (p_rec.attribute1 = hr_api.g_varchar2) then
890 p_rec.attribute1 :=
891 irc_isc_shd.g_old_rec.attribute1;
892 End If;
893 If (p_rec.attribute2 = hr_api.g_varchar2) then
894 p_rec.attribute2 :=
895 irc_isc_shd.g_old_rec.attribute2;
896 End If;
897 If (p_rec.attribute3 = hr_api.g_varchar2) then
898 p_rec.attribute3 :=
899 irc_isc_shd.g_old_rec.attribute3;
900 End If;
901 If (p_rec.attribute4 = hr_api.g_varchar2) then
902 p_rec.attribute4 :=
903 irc_isc_shd.g_old_rec.attribute4;
904 End If;
905 If (p_rec.attribute5 = hr_api.g_varchar2) then
906 p_rec.attribute5 :=
907 irc_isc_shd.g_old_rec.attribute5;
908 End If;
909 If (p_rec.attribute6 = hr_api.g_varchar2) then
910 p_rec.attribute6 :=
911 irc_isc_shd.g_old_rec.attribute6;
912 End If;
913 If (p_rec.attribute7 = hr_api.g_varchar2) then
914 p_rec.attribute7 :=
915 irc_isc_shd.g_old_rec.attribute7;
916 End If;
917 If (p_rec.attribute8 = hr_api.g_varchar2) then
918 p_rec.attribute8 :=
919 irc_isc_shd.g_old_rec.attribute8;
920 End If;
921 If (p_rec.attribute9 = hr_api.g_varchar2) then
922 p_rec.attribute9 :=
923 irc_isc_shd.g_old_rec.attribute9;
924 End If;
925 If (p_rec.attribute10 = hr_api.g_varchar2) then
926 p_rec.attribute10 :=
927 irc_isc_shd.g_old_rec.attribute10;
928 End If;
929 If (p_rec.attribute11 = hr_api.g_varchar2) then
930 p_rec.attribute11 :=
931 irc_isc_shd.g_old_rec.attribute11;
932 End If;
933 If (p_rec.attribute12 = hr_api.g_varchar2) then
934 p_rec.attribute12 :=
935 irc_isc_shd.g_old_rec.attribute12;
936 End If;
937 If (p_rec.attribute13 = hr_api.g_varchar2) then
938 p_rec.attribute13 :=
939 irc_isc_shd.g_old_rec.attribute13;
940 End If;
941 If (p_rec.attribute14 = hr_api.g_varchar2) then
942 p_rec.attribute14 :=
943 irc_isc_shd.g_old_rec.attribute14;
944 End If;
945 If (p_rec.attribute15 = hr_api.g_varchar2) then
946 p_rec.attribute15 :=
947 irc_isc_shd.g_old_rec.attribute15;
948 End If;
949 If (p_rec.attribute16 = hr_api.g_varchar2) then
950 p_rec.attribute16 :=
951 irc_isc_shd.g_old_rec.attribute16;
952 End If;
953 If (p_rec.attribute17 = hr_api.g_varchar2) then
954 p_rec.attribute17 :=
955 irc_isc_shd.g_old_rec.attribute17;
956 End If;
957 If (p_rec.attribute18 = hr_api.g_varchar2) then
958 p_rec.attribute18 :=
959 irc_isc_shd.g_old_rec.attribute18;
960 End If;
961 If (p_rec.attribute19 = hr_api.g_varchar2) then
962 p_rec.attribute19 :=
963 irc_isc_shd.g_old_rec.attribute19;
964 End If;
965 If (p_rec.attribute20 = hr_api.g_varchar2) then
966 p_rec.attribute20 :=
967 irc_isc_shd.g_old_rec.attribute20;
968 End If;
969 If (p_rec.attribute21 = hr_api.g_varchar2) then
970 p_rec.attribute21 :=
971 irc_isc_shd.g_old_rec.attribute21;
972 End If;
973 If (p_rec.attribute22 = hr_api.g_varchar2) then
974 p_rec.attribute22 :=
975 irc_isc_shd.g_old_rec.attribute22;
976 End If;
977 If (p_rec.attribute23 = hr_api.g_varchar2) then
978 p_rec.attribute23 :=
979 irc_isc_shd.g_old_rec.attribute23;
980 End If;
981 If (p_rec.attribute24 = hr_api.g_varchar2) then
982 p_rec.attribute24 :=
983 irc_isc_shd.g_old_rec.attribute24;
984 End If;
985 If (p_rec.attribute25 = hr_api.g_varchar2) then
986 p_rec.attribute25 :=
987 irc_isc_shd.g_old_rec.attribute25;
988 End If;
989 If (p_rec.attribute26 = hr_api.g_varchar2) then
990 p_rec.attribute26 :=
991 irc_isc_shd.g_old_rec.attribute26;
992 End If;
993 If (p_rec.attribute27 = hr_api.g_varchar2) then
994 p_rec.attribute27 :=
995 irc_isc_shd.g_old_rec.attribute27;
996 End If;
997 If (p_rec.attribute28 = hr_api.g_varchar2) then
998 p_rec.attribute28 :=
999 irc_isc_shd.g_old_rec.attribute28;
1000 End If;
1001 If (p_rec.attribute29 = hr_api.g_varchar2) then
1002 p_rec.attribute29 :=
1003 irc_isc_shd.g_old_rec.attribute29;
1004 End If;
1005 If (p_rec.attribute30 = hr_api.g_varchar2) then
1006 p_rec.attribute30 :=
1007 irc_isc_shd.g_old_rec.attribute30;
1008 End If;
1009 If (p_rec.isc_information_category = hr_api.g_varchar2) then
1010 p_rec.isc_information_category :=
1011 irc_isc_shd.g_old_rec.isc_information_category;
1012 End If;
1013 If (p_rec.isc_information1 = hr_api.g_varchar2) then
1014 p_rec.isc_information1 :=
1015 irc_isc_shd.g_old_rec.isc_information1;
1016 End If;
1017 If (p_rec.isc_information2 = hr_api.g_varchar2) then
1018 p_rec.isc_information2 :=
1019 irc_isc_shd.g_old_rec.isc_information2;
1020 End If;
1021 If (p_rec.isc_information3 = hr_api.g_varchar2) then
1022 p_rec.isc_information3 :=
1023 irc_isc_shd.g_old_rec.isc_information3;
1024 End If;
1025 If (p_rec.isc_information4 = hr_api.g_varchar2) then
1026 p_rec.isc_information4 :=
1027 irc_isc_shd.g_old_rec.isc_information4;
1028 End If;
1029 If (p_rec.isc_information5 = hr_api.g_varchar2) then
1030 p_rec.isc_information5 :=
1031 irc_isc_shd.g_old_rec.isc_information5;
1032 End If;
1033 If (p_rec.isc_information6 = hr_api.g_varchar2) then
1034 p_rec.isc_information6 :=
1035 irc_isc_shd.g_old_rec.isc_information6;
1036 End If;
1037 If (p_rec.isc_information7 = hr_api.g_varchar2) then
1038 p_rec.isc_information7 :=
1039 irc_isc_shd.g_old_rec.isc_information7;
1040 End If;
1041 If (p_rec.isc_information8 = hr_api.g_varchar2) then
1042 p_rec.isc_information8 :=
1043 irc_isc_shd.g_old_rec.isc_information8;
1044 End If;
1045 If (p_rec.isc_information9 = hr_api.g_varchar2) then
1046 p_rec.isc_information9 :=
1047 irc_isc_shd.g_old_rec.isc_information9;
1048 End If;
1049 If (p_rec.isc_information10 = hr_api.g_varchar2) then
1050 p_rec.isc_information10 :=
1051 irc_isc_shd.g_old_rec.isc_information10;
1052 End If;
1053 If (p_rec.isc_information11 = hr_api.g_varchar2) then
1054 p_rec.isc_information11 :=
1055 irc_isc_shd.g_old_rec.isc_information11;
1056 End If;
1057 If (p_rec.isc_information12 = hr_api.g_varchar2) then
1058 p_rec.isc_information12 :=
1059 irc_isc_shd.g_old_rec.isc_information12;
1060 End If;
1061 If (p_rec.isc_information13 = hr_api.g_varchar2) then
1062 p_rec.isc_information13 :=
1063 irc_isc_shd.g_old_rec.isc_information13;
1064 End If;
1065 If (p_rec.isc_information14 = hr_api.g_varchar2) then
1066 p_rec.isc_information14 :=
1067 irc_isc_shd.g_old_rec.isc_information14;
1068 End If;
1069 If (p_rec.isc_information15 = hr_api.g_varchar2) then
1070 p_rec.isc_information15 :=
1071 irc_isc_shd.g_old_rec.isc_information15;
1072 End If;
1073 If (p_rec.isc_information16 = hr_api.g_varchar2) then
1074 p_rec.isc_information16 :=
1075 irc_isc_shd.g_old_rec.isc_information16;
1076 End If;
1077 If (p_rec.isc_information17 = hr_api.g_varchar2) then
1078 p_rec.isc_information17 :=
1079 irc_isc_shd.g_old_rec.isc_information17;
1080 End If;
1081 If (p_rec.isc_information18 = hr_api.g_varchar2) then
1082 p_rec.isc_information18 :=
1083 irc_isc_shd.g_old_rec.isc_information18;
1084 End If;
1088 End If;
1085 If (p_rec.isc_information19 = hr_api.g_varchar2) then
1086 p_rec.isc_information19 :=
1087 irc_isc_shd.g_old_rec.isc_information19;
1089 If (p_rec.isc_information20 = hr_api.g_varchar2) then
1090 p_rec.isc_information20 :=
1091 irc_isc_shd.g_old_rec.isc_information20;
1092 End If;
1093 If (p_rec.isc_information21 = hr_api.g_varchar2) then
1094 p_rec.isc_information21 :=
1095 irc_isc_shd.g_old_rec.isc_information21;
1096 End If;
1097 If (p_rec.isc_information22 = hr_api.g_varchar2) then
1098 p_rec.isc_information22 :=
1099 irc_isc_shd.g_old_rec.isc_information22;
1100 End If;
1101 If (p_rec.isc_information23 = hr_api.g_varchar2) then
1102 p_rec.isc_information23 :=
1103 irc_isc_shd.g_old_rec.isc_information23;
1104 End If;
1105 If (p_rec.isc_information24 = hr_api.g_varchar2) then
1106 p_rec.isc_information24 :=
1107 irc_isc_shd.g_old_rec.isc_information24;
1108 End If;
1109 If (p_rec.isc_information25 = hr_api.g_varchar2) then
1110 p_rec.isc_information25 :=
1111 irc_isc_shd.g_old_rec.isc_information25;
1112 End If;
1113 If (p_rec.isc_information26 = hr_api.g_varchar2) then
1114 p_rec.isc_information26 :=
1115 irc_isc_shd.g_old_rec.isc_information26;
1116 End If;
1117 If (p_rec.isc_information27 = hr_api.g_varchar2) then
1118 p_rec.isc_information27 :=
1119 irc_isc_shd.g_old_rec.isc_information27;
1120 End If;
1121 If (p_rec.isc_information28 = hr_api.g_varchar2) then
1122 p_rec.isc_information28 :=
1123 irc_isc_shd.g_old_rec.isc_information28;
1124 End If;
1125 If (p_rec.isc_information29 = hr_api.g_varchar2) then
1126 p_rec.isc_information29 :=
1127 irc_isc_shd.g_old_rec.isc_information29;
1128 End If;
1129 If (p_rec.isc_information30 = hr_api.g_varchar2) then
1130 p_rec.isc_information30 :=
1131 irc_isc_shd.g_old_rec.isc_information30;
1132 End If;
1133 If (p_rec.date_posted = hr_api.g_varchar2) then
1134 p_rec.date_posted :=
1135 irc_isc_shd.g_old_rec.date_posted;
1136 End If;
1137 --
1138 End convert_defs;
1139 --
1140 -- ----------------------------------------------------------------------------
1141 -- |---------------------------------< upd >----------------------------------|
1142 -- ----------------------------------------------------------------------------
1143 Procedure upd
1144 (p_effective_date in date
1145 ,p_rec in out nocopy irc_isc_shd.g_rec_type
1146 ) is
1147 --
1148 l_proc varchar2(72) := g_package||'upd';
1149 --
1150 Begin
1151 hr_utility.set_location('Entering:'||l_proc, 5);
1152 --
1153 -- We must lock the row which we need to update.
1154 --
1155 irc_isc_shd.lck
1156 (p_rec.search_criteria_id
1157 ,p_rec.object_version_number
1158 );
1159 --
1160 -- 1. During an update system defaults are used to determine if
1161 -- arguments have been defaulted or not. We must therefore
1162 -- derive the full record structure values to be updated.
1163 --
1164 -- 2. Call the supporting update validate operations.
1165 --
1166 convert_defs(p_rec);
1167 irc_isc_bus.update_validate
1168 (p_effective_date
1169 ,p_rec
1170 );
1171 --
1172 -- Call to raise any errors on multi-message list
1173 hr_multi_message.end_validation_set;
1174 --
1175 -- Call the supporting pre-update operation
1176 --
1177 irc_isc_upd.pre_update(p_rec);
1178 --
1179 -- Update the row.
1180 --
1181 irc_isc_upd.update_dml(p_rec);
1182 --
1183 -- Call the supporting post-update operation
1184 --
1185 irc_isc_upd.post_update
1186 (p_effective_date
1187 ,p_rec
1188 );
1189 --
1190 -- Call to raise any errors on multi-message list
1191 hr_multi_message.end_validation_set;
1192 End upd;
1193 --
1194 -- ----------------------------------------------------------------------------
1195 -- |---------------------------------< upd >----------------------------------|
1196 -- ----------------------------------------------------------------------------
1197 Procedure upd
1198 (p_effective_date in date
1199 ,p_search_criteria_id in number
1200 ,p_object_version_number in out nocopy number
1201 ,p_object_id in number default hr_api.g_number
1202 ,p_object_type in varchar2 default hr_api.g_varchar2
1203 ,p_search_name in varchar2 default hr_api.g_varchar2
1204 ,p_search_type in varchar2 default hr_api.g_varchar2
1205 ,p_location in varchar2 default hr_api.g_varchar2
1206 ,p_distance_to_location in varchar2 default hr_api.g_varchar2
1207 ,p_geocode_location in varchar2 default hr_api.g_varchar2
1208 ,p_geocode_country in varchar2 default hr_api.g_varchar2
1209 ,p_derived_location in varchar2 default hr_api.g_varchar2
1210 ,p_location_id in number default hr_api.g_number
1211 ,p_longitude in number default hr_api.g_number
1212 ,p_latitude in number default hr_api.g_number
1213 ,p_employee in varchar2 default hr_api.g_varchar2
1214 ,p_contractor in varchar2 default hr_api.g_varchar2
1215 ,p_employment_category in varchar2 default hr_api.g_varchar2
1216 ,p_keywords in varchar2 default hr_api.g_varchar2
1217 ,p_travel_percentage in number default hr_api.g_number
1218 ,p_min_salary in number default hr_api.g_number
1219 ,p_max_salary in number default hr_api.g_number
1223 ,p_match_qualification in varchar2 default hr_api.g_varchar2
1220 ,p_salary_currency in varchar2 default hr_api.g_varchar2
1221 ,p_salary_period in varchar2 default hr_api.g_varchar2
1222 ,p_match_competence in varchar2 default hr_api.g_varchar2
1224 ,p_job_title in varchar2 default hr_api.g_varchar2
1225 ,p_department in varchar2 default hr_api.g_varchar2
1226 ,p_professional_area in varchar2 default hr_api.g_varchar2
1227 ,p_work_at_home in varchar2 default hr_api.g_varchar2
1228 ,p_min_qual_level in number default hr_api.g_number
1229 ,p_max_qual_level in number default hr_api.g_number
1230 ,p_use_for_matching in varchar2 default hr_api.g_varchar2
1231 ,p_description in varchar2 default hr_api.g_varchar2
1232 ,p_attribute_category in varchar2 default hr_api.g_varchar2
1233 ,p_attribute1 in varchar2 default hr_api.g_varchar2
1234 ,p_attribute2 in varchar2 default hr_api.g_varchar2
1235 ,p_attribute3 in varchar2 default hr_api.g_varchar2
1236 ,p_attribute4 in varchar2 default hr_api.g_varchar2
1237 ,p_attribute5 in varchar2 default hr_api.g_varchar2
1238 ,p_attribute6 in varchar2 default hr_api.g_varchar2
1239 ,p_attribute7 in varchar2 default hr_api.g_varchar2
1240 ,p_attribute8 in varchar2 default hr_api.g_varchar2
1241 ,p_attribute9 in varchar2 default hr_api.g_varchar2
1242 ,p_attribute10 in varchar2 default hr_api.g_varchar2
1243 ,p_attribute11 in varchar2 default hr_api.g_varchar2
1244 ,p_attribute12 in varchar2 default hr_api.g_varchar2
1245 ,p_attribute13 in varchar2 default hr_api.g_varchar2
1246 ,p_attribute14 in varchar2 default hr_api.g_varchar2
1247 ,p_attribute15 in varchar2 default hr_api.g_varchar2
1248 ,p_attribute16 in varchar2 default hr_api.g_varchar2
1249 ,p_attribute17 in varchar2 default hr_api.g_varchar2
1250 ,p_attribute18 in varchar2 default hr_api.g_varchar2
1251 ,p_attribute19 in varchar2 default hr_api.g_varchar2
1252 ,p_attribute20 in varchar2 default hr_api.g_varchar2
1253 ,p_attribute21 in varchar2 default hr_api.g_varchar2
1254 ,p_attribute22 in varchar2 default hr_api.g_varchar2
1255 ,p_attribute23 in varchar2 default hr_api.g_varchar2
1256 ,p_attribute24 in varchar2 default hr_api.g_varchar2
1257 ,p_attribute25 in varchar2 default hr_api.g_varchar2
1258 ,p_attribute26 in varchar2 default hr_api.g_varchar2
1259 ,p_attribute27 in varchar2 default hr_api.g_varchar2
1260 ,p_attribute28 in varchar2 default hr_api.g_varchar2
1261 ,p_attribute29 in varchar2 default hr_api.g_varchar2
1262 ,p_attribute30 in varchar2 default hr_api.g_varchar2
1263 ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1264 ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1265 ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1266 ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1267 ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1268 ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1269 ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1270 ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1271 ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1272 ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1273 ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1274 ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1275 ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1276 ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1277 ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1278 ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1279 ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1280 ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1281 ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1282 ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1283 ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1284 ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1285 ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1286 ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1287 ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1288 ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1289 ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1290 ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1291 ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1292 ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1293 ,p_isc_information30 in varchar2 default hr_api.g_varchar2
1294 ,p_date_posted in varchar2 default hr_api.g_varchar2
1295 ) is
1296 --
1297 l_rec irc_isc_shd.g_rec_type;
1298 l_proc varchar2(72) := g_package||'upd';
1299 --
1300 Begin
1301 hr_utility.set_location('Entering:'||l_proc, 5);
1302 --
1303 -- Call conversion function to turn arguments into the
1304 -- l_rec structure.
1305 --
1306 l_rec :=
1307 irc_isc_shd.convert_args
1308 (p_search_criteria_id
1309 ,p_object_id
1310 ,p_object_type
1311 ,p_search_name
1312 ,p_search_type
1313 ,p_location
1314 ,p_distance_to_location
1315 ,p_geocode_location
1316 ,p_geocode_country
1317 ,p_derived_location
1318 ,p_location_id
1319 ,p_longitude
1320 ,p_latitude
1321 ,p_employee
1322 ,p_contractor
1323 ,p_employment_category
1324 ,p_keywords
1325 ,p_travel_percentage
1326 ,p_min_salary
1327 ,p_max_salary
1328 ,p_salary_currency
1329 ,p_salary_period
1330 ,p_match_competence
1331 ,p_match_qualification
1332 ,p_job_title
1333 ,p_department
1334 ,p_professional_area
1335 ,p_work_at_home
1336 ,p_min_qual_level
1337 ,p_max_qual_level
1338 ,p_use_for_matching
1339 ,p_description
1340 ,p_attribute_category
1341 ,p_attribute1
1342 ,p_attribute2
1343 ,p_attribute3
1344 ,p_attribute4
1345 ,p_attribute5
1346 ,p_attribute6
1347 ,p_attribute7
1348 ,p_attribute8
1349 ,p_attribute9
1350 ,p_attribute10
1351 ,p_attribute11
1352 ,p_attribute12
1353 ,p_attribute13
1354 ,p_attribute14
1355 ,p_attribute15
1356 ,p_attribute16
1357 ,p_attribute17
1358 ,p_attribute18
1359 ,p_attribute19
1360 ,p_attribute20
1361 ,p_attribute21
1362 ,p_attribute22
1363 ,p_attribute23
1364 ,p_attribute24
1365 ,p_attribute25
1366 ,p_attribute26
1367 ,p_attribute27
1368 ,p_attribute28
1369 ,p_attribute29
1370 ,p_attribute30
1371 ,p_isc_information_category
1372 ,p_isc_information1
1373 ,p_isc_information2
1374 ,p_isc_information3
1375 ,p_isc_information4
1376 ,p_isc_information5
1377 ,p_isc_information6
1378 ,p_isc_information7
1379 ,p_isc_information8
1380 ,p_isc_information9
1381 ,p_isc_information10
1382 ,p_isc_information11
1383 ,p_isc_information12
1384 ,p_isc_information13
1385 ,p_isc_information14
1386 ,p_isc_information15
1387 ,p_isc_information16
1388 ,p_isc_information17
1389 ,p_isc_information18
1390 ,p_isc_information19
1391 ,p_isc_information20
1392 ,p_isc_information21
1393 ,p_isc_information22
1394 ,p_isc_information23
1395 ,p_isc_information24
1396 ,p_isc_information25
1397 ,p_isc_information26
1398 ,p_isc_information27
1399 ,p_isc_information28
1400 ,p_isc_information29
1401 ,p_isc_information30
1402 ,p_object_version_number
1403 ,p_date_posted
1404 );
1405 --
1406 -- Having converted the arguments into the
1407 -- plsql record structure we call the corresponding record
1408 -- business process.
1409 --
1410 irc_isc_upd.upd
1411 (p_effective_date
1412 ,l_rec
1413 );
1414 p_object_version_number := l_rec.object_version_number;
1415 --
1416 hr_utility.set_location(' Leaving:'||l_proc, 10);
1417 End upd;
1418 --
1419 end irc_isc_upd;