[Home] [Help]
PACKAGE BODY: APPS.IRC_SEARCH_CRITERIA_SWI
Source
1 Package Body irc_search_criteria_swi As
2 /* $Header: iriscswi.pkb 120.1 2006/03/13 02:34:15 cnholmes noship $ */
3 --
4 -- Package variables
5 --
6 g_package varchar2(33) := 'irc_search_criteria_swi.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |--------------------------< create_saved_search >-------------------------|
10 -- ----------------------------------------------------------------------------
11 PROCEDURE create_saved_search
12 (p_validate in number default hr_api.g_false_num
13 ,p_effective_date in date
14 ,p_person_id in number
15 ,p_search_name in varchar2
16 ,p_location in varchar2 default null
17 ,p_distance_to_location in varchar2 default null
18 ,p_geocode_location in varchar2 default null
19 ,p_geocode_country in varchar2 default null
20 ,p_derived_location in varchar2 default null
21 ,p_location_id in number default null
22 ,p_longitude in number default null
23 ,p_latitude in number default null
24 ,p_employee in varchar2 default null
25 ,p_contractor in varchar2 default null
26 ,p_employment_category in varchar2 default null
27 ,p_keywords in varchar2 default null
28 ,p_travel_percentage in number default null
29 ,p_min_salary in number default null
30 ,p_salary_currency in varchar2 default null
31 ,p_salary_period in varchar2 default null
32 ,p_match_competence in varchar2 default null
33 ,p_match_qualification in varchar2 default null
34 ,p_work_at_home in varchar2 default null
35 ,p_job_title in varchar2 default null
36 ,p_department in varchar2 default null
37 ,p_professional_area in varchar2 default null
38 ,p_use_for_matching in varchar2 default null
39 ,p_description in varchar2 default null
40 ,p_attribute_category in varchar2 default null
41 ,p_attribute1 in varchar2 default null
42 ,p_attribute2 in varchar2 default null
43 ,p_attribute3 in varchar2 default null
44 ,p_attribute4 in varchar2 default null
45 ,p_attribute5 in varchar2 default null
46 ,p_attribute6 in varchar2 default null
47 ,p_attribute7 in varchar2 default null
48 ,p_attribute8 in varchar2 default null
49 ,p_attribute9 in varchar2 default null
50 ,p_attribute10 in varchar2 default null
51 ,p_attribute11 in varchar2 default null
52 ,p_attribute12 in varchar2 default null
53 ,p_attribute13 in varchar2 default null
54 ,p_attribute14 in varchar2 default null
55 ,p_attribute15 in varchar2 default null
56 ,p_attribute16 in varchar2 default null
57 ,p_attribute17 in varchar2 default null
58 ,p_attribute18 in varchar2 default null
59 ,p_attribute19 in varchar2 default null
60 ,p_attribute20 in varchar2 default null
61 ,p_attribute21 in varchar2 default null
62 ,p_attribute22 in varchar2 default null
63 ,p_attribute23 in varchar2 default null
64 ,p_attribute24 in varchar2 default null
65 ,p_attribute25 in varchar2 default null
66 ,p_attribute26 in varchar2 default null
67 ,p_attribute27 in varchar2 default null
68 ,p_attribute28 in varchar2 default null
69 ,p_attribute29 in varchar2 default null
70 ,p_attribute30 in varchar2 default null
71 ,p_isc_information_category in varchar2 default null
72 ,p_isc_information1 in varchar2 default null
73 ,p_isc_information2 in varchar2 default null
74 ,p_isc_information3 in varchar2 default null
75 ,p_isc_information4 in varchar2 default null
76 ,p_isc_information5 in varchar2 default null
77 ,p_isc_information6 in varchar2 default null
78 ,p_isc_information7 in varchar2 default null
79 ,p_isc_information8 in varchar2 default null
80 ,p_isc_information9 in varchar2 default null
81 ,p_isc_information10 in varchar2 default null
82 ,p_isc_information11 in varchar2 default null
83 ,p_isc_information12 in varchar2 default null
84 ,p_isc_information13 in varchar2 default null
85 ,p_isc_information14 in varchar2 default null
86 ,p_isc_information15 in varchar2 default null
87 ,p_isc_information16 in varchar2 default null
88 ,p_isc_information17 in varchar2 default null
89 ,p_isc_information18 in varchar2 default null
90 ,p_isc_information19 in varchar2 default null
91 ,p_isc_information20 in varchar2 default null
92 ,p_isc_information21 in varchar2 default null
93 ,p_isc_information22 in varchar2 default null
94 ,p_isc_information23 in varchar2 default null
95 ,p_isc_information24 in varchar2 default null
96 ,p_isc_information25 in varchar2 default null
97 ,p_isc_information26 in varchar2 default null
98 ,p_isc_information27 in varchar2 default null
99 ,p_isc_information28 in varchar2 default null
100 ,p_isc_information29 in varchar2 default null
101 ,p_isc_information30 in varchar2 default null
102 ,p_date_posted in varchar2 default null
103 ,p_object_version_number out nocopy number
104 ,p_search_criteria_id in number
105 ,p_return_status out nocopy varchar2
106 ) is
107 --
108 -- Variables for API Boolean parameters
109 l_validate boolean;
110 --
111 -- Variables for IN/OUT parameters
112 --
113 -- Other variables
114 l_search_criteria_id number;
115 l_proc varchar2(72) := g_package ||'create_saved_search';
116 Begin
117 hr_utility.set_location(' Entering:' || l_proc,10);
118 --
119 -- Issue a savepoint
120 --
121 savepoint create_saved_search_swi;
122 --
123 -- Initialise Multiple Message Detection
124 --
125 hr_multi_message.enable_message_list;
126 --
127 -- Remember IN OUT parameter IN values
128 --
129 --
130 -- Convert constant values to their corresponding boolean value
131 --
132 l_validate :=
133 hr_api.constant_to_boolean
134 (p_constant_value => p_validate);
135 --
136 -- Register Surrogate ID or user key values
137 --
138 irc_isc_ins.set_base_key_value
139 (p_search_criteria_id => p_search_criteria_id
140 );
141 --
142 -- Call API
143 --
144 irc_search_criteria_api.create_saved_search
145 (p_validate => l_validate
146 ,p_effective_date => p_effective_date
147 ,p_person_id => p_person_id
148 ,p_search_name => p_search_name
149 ,p_location => p_location
150 ,p_distance_to_location => p_distance_to_location
151 ,p_geocode_location => p_geocode_location
152 ,p_geocode_country => p_geocode_country
153 ,p_derived_location => p_derived_location
154 ,p_location_id => p_location_id
155 ,p_longitude => p_longitude
156 ,p_latitude => p_latitude
157 ,p_employee => p_employee
158 ,p_contractor => p_contractor
159 ,p_employment_category => p_employment_category
160 ,p_keywords => p_keywords
161 ,p_travel_percentage => p_travel_percentage
162 ,p_min_salary => p_min_salary
163 ,p_salary_currency => p_salary_currency
164 ,p_salary_period => p_salary_period
165 ,p_match_competence => p_match_competence
166 ,p_match_qualification => p_match_qualification
167 ,p_work_at_home => p_work_at_home
168 ,p_job_title => p_job_title
169 ,p_department => p_department
170 ,p_professional_area => p_professional_area
171 ,p_use_for_matching => p_use_for_matching
172 ,p_description => p_description
173 ,p_attribute_category => p_attribute_category
174 ,p_attribute1 => p_attribute1
175 ,p_attribute2 => p_attribute2
176 ,p_attribute3 => p_attribute3
177 ,p_attribute4 => p_attribute4
178 ,p_attribute5 => p_attribute5
179 ,p_attribute6 => p_attribute6
180 ,p_attribute7 => p_attribute7
181 ,p_attribute8 => p_attribute8
182 ,p_attribute9 => p_attribute9
183 ,p_attribute10 => p_attribute10
184 ,p_attribute11 => p_attribute11
185 ,p_attribute12 => p_attribute12
186 ,p_attribute13 => p_attribute13
187 ,p_attribute14 => p_attribute14
188 ,p_attribute15 => p_attribute15
189 ,p_attribute16 => p_attribute16
190 ,p_attribute17 => p_attribute17
191 ,p_attribute18 => p_attribute18
192 ,p_attribute19 => p_attribute19
193 ,p_attribute20 => p_attribute20
194 ,p_attribute21 => p_attribute21
195 ,p_attribute22 => p_attribute22
196 ,p_attribute23 => p_attribute23
197 ,p_attribute24 => p_attribute24
198 ,p_attribute25 => p_attribute25
199 ,p_attribute26 => p_attribute26
200 ,p_attribute27 => p_attribute27
201 ,p_attribute28 => p_attribute28
202 ,p_attribute29 => p_attribute29
203 ,p_attribute30 => p_attribute30
204 ,p_isc_information_category => p_isc_information_category
205 ,p_isc_information1 => p_isc_information1
206 ,p_isc_information2 => p_isc_information2
207 ,p_isc_information3 => p_isc_information3
208 ,p_isc_information4 => p_isc_information4
209 ,p_isc_information5 => p_isc_information5
210 ,p_isc_information6 => p_isc_information6
211 ,p_isc_information7 => p_isc_information7
212 ,p_isc_information8 => p_isc_information8
213 ,p_isc_information9 => p_isc_information9
214 ,p_isc_information10 => p_isc_information10
215 ,p_isc_information11 => p_isc_information11
216 ,p_isc_information12 => p_isc_information12
217 ,p_isc_information13 => p_isc_information13
218 ,p_isc_information14 => p_isc_information14
219 ,p_isc_information15 => p_isc_information15
220 ,p_isc_information16 => p_isc_information16
221 ,p_isc_information17 => p_isc_information17
222 ,p_isc_information18 => p_isc_information18
223 ,p_isc_information19 => p_isc_information19
224 ,p_isc_information20 => p_isc_information20
225 ,p_isc_information21 => p_isc_information21
226 ,p_isc_information22 => p_isc_information22
227 ,p_isc_information23 => p_isc_information23
228 ,p_isc_information24 => p_isc_information24
229 ,p_isc_information25 => p_isc_information25
230 ,p_isc_information26 => p_isc_information26
231 ,p_isc_information27 => p_isc_information27
232 ,p_isc_information28 => p_isc_information28
233 ,p_isc_information29 => p_isc_information29
234 ,p_isc_information30 => p_isc_information30
235 ,p_date_posted => p_date_posted
236 ,p_object_version_number => p_object_version_number
237 ,p_search_criteria_id => l_search_criteria_id
238 );
239 --
240 -- Convert API warning boolean parameter values to specific
241 -- messages and add them to Multiple Message List
242 --
243 --
244 -- Convert API non-warning boolean parameter values
245 --
246 --
247 -- Derive the API return status value based on whether
248 -- messages of any type exist in the Multiple Message List.
249 -- Also disable Multiple Message Detection.
250 --
251 p_return_status := hr_multi_message.get_return_status_disable;
252 hr_utility.set_location(' Leaving:' || l_proc,20);
253 --
254 exception
255 when hr_multi_message.error_message_exist then
256 --
257 -- Catch the Multiple Message List exception which
258 -- indicates API processing has been aborted because
259 -- at least one message exists in the list.
260 --
261 rollback to create_saved_search_swi;
262 --
263 -- Reset IN OUT parameters and set OUT parameters
264 --
265 p_object_version_number := null;
266 p_return_status := hr_multi_message.get_return_status_disable;
267 hr_utility.set_location(' Leaving:' || l_proc, 30);
268 when others then
269 --
270 -- When Multiple Message Detection is enabled catch
271 -- any Application specific or other unexpected
272 -- exceptions. Adding appropriate details to the
273 -- Multiple Message List. Otherwise re-raise the
274 -- error.
275 --
276 rollback to create_saved_search_swi;
277 if hr_multi_message.unexpected_error_add(l_proc) then
278 hr_utility.set_location(' Leaving:' || l_proc,40);
279 raise;
280 end if;
281 --
282 -- Reset IN OUT and set OUT parameters
283 --
284 p_object_version_number := null;
285 p_return_status := hr_multi_message.get_return_status_disable;
286 hr_utility.set_location(' Leaving:' || l_proc,50);
287 end create_saved_search;
288 -- ----------------------------------------------------------------------------
289 -- |------------------------< create_vacancy_criteria >-----------------------|
290 -- ----------------------------------------------------------------------------
291 PROCEDURE create_vacancy_criteria
292 (p_validate in number default hr_api.g_false_num
293 ,p_vacancy_id in number
294 ,p_effective_date in date
295 ,p_location in varchar2 default null
296 ,p_employee in varchar2 default null
297 ,p_contractor in varchar2 default null
298 ,p_employment_category in varchar2 default null
299 ,p_keywords in varchar2 default null
300 ,p_travel_percentage in number default null
301 ,p_min_salary in number default null
302 ,p_max_salary in number default null
303 ,p_salary_currency in varchar2 default null
304 ,p_salary_period in varchar2 default null
305 ,p_professional_area in varchar2 default null
306 ,p_work_at_home in varchar2 default null
307 ,p_min_qual_level in number default null
308 ,p_max_qual_level in number default null
309 ,p_description in varchar2 default null
310 ,p_attribute_category in varchar2 default null
311 ,p_attribute1 in varchar2 default null
312 ,p_attribute2 in varchar2 default null
313 ,p_attribute3 in varchar2 default null
314 ,p_attribute4 in varchar2 default null
315 ,p_attribute5 in varchar2 default null
316 ,p_attribute6 in varchar2 default null
317 ,p_attribute7 in varchar2 default null
318 ,p_attribute8 in varchar2 default null
319 ,p_attribute9 in varchar2 default null
320 ,p_attribute10 in varchar2 default null
321 ,p_attribute11 in varchar2 default null
322 ,p_attribute12 in varchar2 default null
323 ,p_attribute13 in varchar2 default null
324 ,p_attribute14 in varchar2 default null
325 ,p_attribute15 in varchar2 default null
326 ,p_attribute16 in varchar2 default null
327 ,p_attribute17 in varchar2 default null
328 ,p_attribute18 in varchar2 default null
329 ,p_attribute19 in varchar2 default null
330 ,p_attribute20 in varchar2 default null
331 ,p_attribute21 in varchar2 default null
332 ,p_attribute22 in varchar2 default null
333 ,p_attribute23 in varchar2 default null
334 ,p_attribute24 in varchar2 default null
335 ,p_attribute25 in varchar2 default null
336 ,p_attribute26 in varchar2 default null
337 ,p_attribute27 in varchar2 default null
338 ,p_attribute28 in varchar2 default null
339 ,p_attribute29 in varchar2 default null
340 ,p_attribute30 in varchar2 default null
341 ,p_isc_information_category in varchar2 default null
342 ,p_isc_information1 in varchar2 default null
343 ,p_isc_information2 in varchar2 default null
344 ,p_isc_information3 in varchar2 default null
345 ,p_isc_information4 in varchar2 default null
346 ,p_isc_information5 in varchar2 default null
347 ,p_isc_information6 in varchar2 default null
348 ,p_isc_information7 in varchar2 default null
349 ,p_isc_information8 in varchar2 default null
350 ,p_isc_information9 in varchar2 default null
351 ,p_isc_information10 in varchar2 default null
352 ,p_isc_information11 in varchar2 default null
353 ,p_isc_information12 in varchar2 default null
354 ,p_isc_information13 in varchar2 default null
355 ,p_isc_information14 in varchar2 default null
356 ,p_isc_information15 in varchar2 default null
357 ,p_isc_information16 in varchar2 default null
358 ,p_isc_information17 in varchar2 default null
359 ,p_isc_information18 in varchar2 default null
360 ,p_isc_information19 in varchar2 default null
361 ,p_isc_information20 in varchar2 default null
362 ,p_isc_information21 in varchar2 default null
363 ,p_isc_information22 in varchar2 default null
364 ,p_isc_information23 in varchar2 default null
365 ,p_isc_information24 in varchar2 default null
366 ,p_isc_information25 in varchar2 default null
367 ,p_isc_information26 in varchar2 default null
368 ,p_isc_information27 in varchar2 default null
369 ,p_isc_information28 in varchar2 default null
370 ,p_isc_information29 in varchar2 default null
371 ,p_isc_information30 in varchar2 default null
372 ,p_object_version_number out nocopy number
373 ,p_search_criteria_id in number
374 ,p_return_status out nocopy varchar2
375 ) is
376 --
377 -- Variables for API Boolean parameters
378 l_validate boolean;
379 --
380 -- Variables for IN/OUT parameters
381 l_search_criteria_id number;
382 --
383 -- Other variables
384 l_proc varchar2(72) := g_package ||'create_vacancy_criteria';
385 Begin
386 hr_utility.set_location(' Entering:' || l_proc,10);
387 --
388 -- Issue a savepoint
389 --
390 savepoint create_vacancy_criteria_swi;
391 --
392 -- Initialise Multiple Message Detection
393 --
394 hr_multi_message.enable_message_list;
395 --
396 -- Remember IN OUT parameter IN values
397 --
398 --
399 -- Convert constant values to their corresponding boolean value
400 --
401 l_validate :=
402 hr_api.constant_to_boolean
403 (p_constant_value => p_validate);
404 --
405 -- Register Surrogate ID or user key values
406 --
407 --
408 irc_isc_ins.set_base_key_value
409 (p_search_criteria_id => p_search_criteria_id
410 );
411 --
412 -- Call API
413 --
414 irc_search_criteria_api.create_vacancy_criteria
415 (p_validate => l_validate
416 ,p_vacancy_id => p_vacancy_id
417 ,p_effective_date => p_effective_date
418 ,p_location => p_location
419 ,p_employee => p_employee
420 ,p_contractor => p_contractor
421 ,p_employment_category => p_employment_category
422 ,p_keywords => p_keywords
423 ,p_travel_percentage => p_travel_percentage
424 ,p_min_salary => p_min_salary
425 ,p_max_salary => p_max_salary
426 ,p_salary_currency => p_salary_currency
427 ,p_salary_period => p_salary_period
428 ,p_professional_area => p_professional_area
429 ,p_work_at_home => p_work_at_home
430 ,p_min_qual_level => p_min_qual_level
431 ,p_max_qual_level => p_max_qual_level
432 ,p_description => p_description
433 ,p_attribute_category => p_attribute_category
434 ,p_attribute1 => p_attribute1
435 ,p_attribute2 => p_attribute2
436 ,p_attribute3 => p_attribute3
437 ,p_attribute4 => p_attribute4
438 ,p_attribute5 => p_attribute5
439 ,p_attribute6 => p_attribute6
440 ,p_attribute7 => p_attribute7
441 ,p_attribute8 => p_attribute8
442 ,p_attribute9 => p_attribute9
443 ,p_attribute10 => p_attribute10
444 ,p_attribute11 => p_attribute11
445 ,p_attribute12 => p_attribute12
446 ,p_attribute13 => p_attribute13
447 ,p_attribute14 => p_attribute14
448 ,p_attribute15 => p_attribute15
449 ,p_attribute16 => p_attribute16
450 ,p_attribute17 => p_attribute17
451 ,p_attribute18 => p_attribute18
452 ,p_attribute19 => p_attribute19
453 ,p_attribute20 => p_attribute20
454 ,p_attribute21 => p_attribute21
455 ,p_attribute22 => p_attribute22
456 ,p_attribute23 => p_attribute23
457 ,p_attribute24 => p_attribute24
458 ,p_attribute25 => p_attribute25
459 ,p_attribute26 => p_attribute26
460 ,p_attribute27 => p_attribute27
461 ,p_attribute28 => p_attribute28
462 ,p_attribute29 => p_attribute29
463 ,p_attribute30 => p_attribute30
464 ,p_isc_information_category => p_isc_information_category
465 ,p_isc_information1 => p_isc_information1
466 ,p_isc_information2 => p_isc_information2
467 ,p_isc_information3 => p_isc_information3
468 ,p_isc_information4 => p_isc_information4
469 ,p_isc_information5 => p_isc_information5
470 ,p_isc_information6 => p_isc_information6
471 ,p_isc_information7 => p_isc_information7
472 ,p_isc_information8 => p_isc_information8
473 ,p_isc_information9 => p_isc_information9
474 ,p_isc_information10 => p_isc_information10
475 ,p_isc_information11 => p_isc_information11
476 ,p_isc_information12 => p_isc_information12
477 ,p_isc_information13 => p_isc_information13
478 ,p_isc_information14 => p_isc_information14
479 ,p_isc_information15 => p_isc_information15
480 ,p_isc_information16 => p_isc_information16
481 ,p_isc_information17 => p_isc_information17
482 ,p_isc_information18 => p_isc_information18
483 ,p_isc_information19 => p_isc_information19
484 ,p_isc_information20 => p_isc_information20
485 ,p_isc_information21 => p_isc_information21
486 ,p_isc_information22 => p_isc_information22
487 ,p_isc_information23 => p_isc_information23
488 ,p_isc_information24 => p_isc_information24
489 ,p_isc_information25 => p_isc_information25
490 ,p_isc_information26 => p_isc_information26
491 ,p_isc_information27 => p_isc_information27
492 ,p_isc_information28 => p_isc_information28
493 ,p_isc_information29 => p_isc_information29
494 ,p_isc_information30 => p_isc_information30
495 ,p_object_version_number => p_object_version_number
496 ,p_search_criteria_id => l_search_criteria_id
497 );
498 --
499 -- Convert API warning boolean parameter values to specific
500 -- messages and add them to Multiple Message List
501 --
502 --
503 -- Convert API non-warning boolean parameter values
504 --
505 --
506 -- Derive the API return status value based on whether
507 -- messages of any type exist in the Multiple Message List.
508 -- Also disable Multiple Message Detection.
509 --
510 p_return_status := hr_multi_message.get_return_status_disable;
511 hr_utility.set_location(' Leaving:' || l_proc,20);
512 --
513 exception
514 when hr_multi_message.error_message_exist then
515 --
516 -- Catch the Multiple Message List exception which
517 -- indicates API processing has been aborted because
518 -- at least one message exists in the list.
519 --
520 rollback to create_vacancy_criteria_swi;
521 --
522 -- Reset IN OUT parameters and set OUT parameters
523 --
524 p_object_version_number := null;
525 p_return_status := hr_multi_message.get_return_status_disable;
526 hr_utility.set_location(' Leaving:' || l_proc, 30);
527 when others then
528 --
529 -- When Multiple Message Detection is enabled catch
530 -- any Application specific or other unexpected
531 -- exceptions. Adding appropriate details to the
532 -- Multiple Message List. Otherwise re-raise the
533 -- error.
534 --
535 rollback to create_vacancy_criteria_swi;
536 if hr_multi_message.unexpected_error_add(l_proc) then
537 hr_utility.set_location(' Leaving:' || l_proc,40);
538 raise;
539 end if;
540 --
541 -- Reset IN OUT and set OUT parameters
542 --
543 p_object_version_number := null;
544 p_return_status := hr_multi_message.get_return_status_disable;
545 hr_utility.set_location(' Leaving:' || l_proc,50);
546 end create_vacancy_criteria;
547 -- ----------------------------------------------------------------------------
548 -- |--------------------------< delete_saved_search >-------------------------|
549 -- ----------------------------------------------------------------------------
550 PROCEDURE delete_saved_search
551 (p_validate in number default hr_api.g_false_num
552 ,p_search_criteria_id in number
553 ,p_object_version_number in number
554 ,p_return_status out nocopy varchar2
555 ) is
556 --
557 -- Variables for API Boolean parameters
558 l_validate boolean;
559 --
560 -- Variables for IN/OUT parameters
561 --
562 -- Other variables
563 l_proc varchar2(72) := g_package ||'delete_saved_search';
564 Begin
565 hr_utility.set_location(' Entering:' || l_proc,10);
566 --
567 -- Issue a savepoint
568 --
569 savepoint delete_saved_search_swi;
570 --
571 -- Initialise Multiple Message Detection
572 --
573 hr_multi_message.enable_message_list;
574 --
575 -- Remember IN OUT parameter IN values
576 --
577 --
578 -- Convert constant values to their corresponding boolean value
579 --
580 l_validate :=
581 hr_api.constant_to_boolean
582 (p_constant_value => p_validate);
583 --
584 -- Register Surrogate ID or user key values
585 --
586 --
587 -- Call API
588 --
589 irc_search_criteria_api.delete_saved_search
590 (p_validate => l_validate
591 ,p_search_criteria_id => p_search_criteria_id
592 ,p_object_version_number => p_object_version_number
593 );
594 --
595 -- Convert API warning boolean parameter values to specific
596 -- messages and add them to Multiple Message List
597 --
598 --
599 -- Convert API non-warning boolean parameter values
600 --
601 --
602 -- Derive the API return status value based on whether
603 -- messages of any type exist in the Multiple Message List.
604 -- Also disable Multiple Message Detection.
605 --
606 p_return_status := hr_multi_message.get_return_status_disable;
607 hr_utility.set_location(' Leaving:' || l_proc,20);
608 --
609 exception
610 when hr_multi_message.error_message_exist then
611 --
612 -- Catch the Multiple Message List exception which
613 -- indicates API processing has been aborted because
614 -- at least one message exists in the list.
615 --
616 rollback to delete_saved_search_swi;
617 --
618 -- Reset IN OUT parameters and set OUT parameters
619 --
620 p_return_status := hr_multi_message.get_return_status_disable;
621 hr_utility.set_location(' Leaving:' || l_proc, 30);
622 when others then
623 --
624 -- When Multiple Message Detection is enabled catch
625 -- any Application specific or other unexpected
626 -- exceptions. Adding appropriate details to the
627 -- Multiple Message List. Otherwise re-raise the
628 -- error.
629 --
630 rollback to delete_saved_search_swi;
631 if hr_multi_message.unexpected_error_add(l_proc) then
632 hr_utility.set_location(' Leaving:' || l_proc,40);
633 raise;
634 end if;
635 --
636 -- Reset IN OUT and set OUT parameters
637 --
638 p_return_status := hr_multi_message.get_return_status_disable;
639 hr_utility.set_location(' Leaving:' || l_proc,50);
640 end delete_saved_search;
641 -- ----------------------------------------------------------------------------
642 -- |------------------------< delete_vacancy_criteria >-----------------------|
643 -- ----------------------------------------------------------------------------
644 PROCEDURE delete_vacancy_criteria
645 (p_validate in number default hr_api.g_false_num
646 ,p_search_criteria_id in number
647 ,p_object_version_number in number
648 ,p_return_status out nocopy varchar2
649 ) is
650 --
651 -- Variables for API Boolean parameters
652 l_validate boolean;
653 --
654 -- Variables for IN/OUT parameters
655 --
656 -- Other variables
657 l_proc varchar2(72) := g_package ||'delete_vacancy_criteria';
658 Begin
659 hr_utility.set_location(' Entering:' || l_proc,10);
660 --
661 -- Issue a savepoint
662 --
663 savepoint delete_vacancy_criteria_swi;
664 --
665 -- Initialise Multiple Message Detection
666 --
667 hr_multi_message.enable_message_list;
668 --
669 -- Remember IN OUT parameter IN values
670 --
671 --
672 -- Convert constant values to their corresponding boolean value
673 --
674 l_validate :=
675 hr_api.constant_to_boolean
676 (p_constant_value => p_validate);
677 --
678 -- Register Surrogate ID or user key values
679 --
680 --
681 -- Call API
682 --
683 irc_search_criteria_api.delete_vacancy_criteria
684 (p_validate => l_validate
685 ,p_search_criteria_id => p_search_criteria_id
686 ,p_object_version_number => p_object_version_number
687 );
688 --
689 -- Convert API warning boolean parameter values to specific
690 -- messages and add them to Multiple Message List
691 --
692 --
693 -- Convert API non-warning boolean parameter values
694 --
695 --
696 -- Derive the API return status value based on whether
697 -- messages of any type exist in the Multiple Message List.
698 -- Also disable Multiple Message Detection.
699 --
700 p_return_status := hr_multi_message.get_return_status_disable;
701 hr_utility.set_location(' Leaving:' || l_proc,20);
702 --
703 exception
704 when hr_multi_message.error_message_exist then
705 --
706 -- Catch the Multiple Message List exception which
707 -- indicates API processing has been aborted because
708 -- at least one message exists in the list.
709 --
710 rollback to delete_vacancy_criteria_swi;
711 --
712 -- Reset IN OUT parameters and set OUT parameters
713 --
714 p_return_status := hr_multi_message.get_return_status_disable;
715 hr_utility.set_location(' Leaving:' || l_proc, 30);
716 when others then
717 --
718 -- When Multiple Message Detection is enabled catch
719 -- any Application specific or other unexpected
720 -- exceptions. Adding appropriate details to the
721 -- Multiple Message List. Otherwise re-raise the
722 -- error.
723 --
724 rollback to delete_vacancy_criteria_swi;
725 if hr_multi_message.unexpected_error_add(l_proc) then
726 hr_utility.set_location(' Leaving:' || l_proc,40);
727 raise;
728 end if;
729 --
730 -- Reset IN OUT and set OUT parameters
731 --
732 p_return_status := hr_multi_message.get_return_status_disable;
733 hr_utility.set_location(' Leaving:' || l_proc,50);
734 end delete_vacancy_criteria;
735 -- ----------------------------------------------------------------------------
736 -- |--------------------------< update_saved_search >-------------------------|
737 -- ----------------------------------------------------------------------------
738 PROCEDURE update_saved_search
739 (p_validate in number default hr_api.g_false_num
740 ,p_effective_date in date
741 ,p_search_criteria_id in number
742 ,p_person_id in number default hr_api.g_number
743 ,p_search_name in varchar2 default hr_api.g_varchar2
744 ,p_location in varchar2 default hr_api.g_varchar2
745 ,p_distance_to_location in varchar2 default hr_api.g_varchar2
746 ,p_geocode_location in varchar2 default hr_api.g_varchar2
747 ,p_geocode_country in varchar2 default hr_api.g_varchar2
748 ,p_derived_location in varchar2 default hr_api.g_varchar2
749 ,p_location_id in number default hr_api.g_number
750 ,p_longitude in number default hr_api.g_number
751 ,p_latitude in number default hr_api.g_number
752 ,p_employee in varchar2 default hr_api.g_varchar2
753 ,p_contractor in varchar2 default hr_api.g_varchar2
754 ,p_employment_category in varchar2 default hr_api.g_varchar2
755 ,p_keywords in varchar2 default hr_api.g_varchar2
756 ,p_travel_percentage in number default hr_api.g_number
757 ,p_min_salary in number default hr_api.g_number
758 ,p_salary_currency in varchar2 default hr_api.g_varchar2
759 ,p_salary_period in varchar2 default hr_api.g_varchar2
760 ,p_match_competence in varchar2 default hr_api.g_varchar2
761 ,p_match_qualification in varchar2 default hr_api.g_varchar2
762 ,p_work_at_home in varchar2 default hr_api.g_varchar2
763 ,p_job_title in varchar2 default hr_api.g_varchar2
764 ,p_department in varchar2 default hr_api.g_varchar2
765 ,p_professional_area in varchar2 default hr_api.g_varchar2
766 ,p_use_for_matching in varchar2 default hr_api.g_varchar2
767 ,p_description in varchar2 default hr_api.g_varchar2
768 ,p_attribute_category in varchar2 default hr_api.g_varchar2
769 ,p_attribute1 in varchar2 default hr_api.g_varchar2
770 ,p_attribute2 in varchar2 default hr_api.g_varchar2
771 ,p_attribute3 in varchar2 default hr_api.g_varchar2
772 ,p_attribute4 in varchar2 default hr_api.g_varchar2
773 ,p_attribute5 in varchar2 default hr_api.g_varchar2
774 ,p_attribute6 in varchar2 default hr_api.g_varchar2
775 ,p_attribute7 in varchar2 default hr_api.g_varchar2
776 ,p_attribute8 in varchar2 default hr_api.g_varchar2
777 ,p_attribute9 in varchar2 default hr_api.g_varchar2
778 ,p_attribute10 in varchar2 default hr_api.g_varchar2
779 ,p_attribute11 in varchar2 default hr_api.g_varchar2
780 ,p_attribute12 in varchar2 default hr_api.g_varchar2
781 ,p_attribute13 in varchar2 default hr_api.g_varchar2
782 ,p_attribute14 in varchar2 default hr_api.g_varchar2
783 ,p_attribute15 in varchar2 default hr_api.g_varchar2
784 ,p_attribute16 in varchar2 default hr_api.g_varchar2
785 ,p_attribute17 in varchar2 default hr_api.g_varchar2
786 ,p_attribute18 in varchar2 default hr_api.g_varchar2
787 ,p_attribute19 in varchar2 default hr_api.g_varchar2
788 ,p_attribute20 in varchar2 default hr_api.g_varchar2
789 ,p_attribute21 in varchar2 default hr_api.g_varchar2
790 ,p_attribute22 in varchar2 default hr_api.g_varchar2
791 ,p_attribute23 in varchar2 default hr_api.g_varchar2
792 ,p_attribute24 in varchar2 default hr_api.g_varchar2
793 ,p_attribute25 in varchar2 default hr_api.g_varchar2
794 ,p_attribute26 in varchar2 default hr_api.g_varchar2
795 ,p_attribute27 in varchar2 default hr_api.g_varchar2
796 ,p_attribute28 in varchar2 default hr_api.g_varchar2
797 ,p_attribute29 in varchar2 default hr_api.g_varchar2
798 ,p_attribute30 in varchar2 default hr_api.g_varchar2
799 ,p_isc_information_category in varchar2 default hr_api.g_varchar2
800 ,p_isc_information1 in varchar2 default hr_api.g_varchar2
801 ,p_isc_information2 in varchar2 default hr_api.g_varchar2
802 ,p_isc_information3 in varchar2 default hr_api.g_varchar2
803 ,p_isc_information4 in varchar2 default hr_api.g_varchar2
804 ,p_isc_information5 in varchar2 default hr_api.g_varchar2
805 ,p_isc_information6 in varchar2 default hr_api.g_varchar2
806 ,p_isc_information7 in varchar2 default hr_api.g_varchar2
807 ,p_isc_information8 in varchar2 default hr_api.g_varchar2
808 ,p_isc_information9 in varchar2 default hr_api.g_varchar2
809 ,p_isc_information10 in varchar2 default hr_api.g_varchar2
810 ,p_isc_information11 in varchar2 default hr_api.g_varchar2
811 ,p_isc_information12 in varchar2 default hr_api.g_varchar2
812 ,p_isc_information13 in varchar2 default hr_api.g_varchar2
813 ,p_isc_information14 in varchar2 default hr_api.g_varchar2
814 ,p_isc_information15 in varchar2 default hr_api.g_varchar2
815 ,p_isc_information16 in varchar2 default hr_api.g_varchar2
816 ,p_isc_information17 in varchar2 default hr_api.g_varchar2
817 ,p_isc_information18 in varchar2 default hr_api.g_varchar2
818 ,p_isc_information19 in varchar2 default hr_api.g_varchar2
819 ,p_isc_information20 in varchar2 default hr_api.g_varchar2
820 ,p_isc_information21 in varchar2 default hr_api.g_varchar2
821 ,p_isc_information22 in varchar2 default hr_api.g_varchar2
822 ,p_isc_information23 in varchar2 default hr_api.g_varchar2
823 ,p_isc_information24 in varchar2 default hr_api.g_varchar2
824 ,p_isc_information25 in varchar2 default hr_api.g_varchar2
825 ,p_isc_information26 in varchar2 default hr_api.g_varchar2
826 ,p_isc_information27 in varchar2 default hr_api.g_varchar2
827 ,p_isc_information28 in varchar2 default hr_api.g_varchar2
828 ,p_isc_information29 in varchar2 default hr_api.g_varchar2
829 ,p_isc_information30 in varchar2 default hr_api.g_varchar2
830 ,p_date_posted in varchar2 default hr_api.g_varchar2
831 ,p_object_version_number in out nocopy number
832 ,p_return_status out nocopy varchar2
833 ) is
834 --
835 -- Variables for API Boolean parameters
836 l_validate boolean;
837 --
838 -- Variables for IN/OUT parameters
839 l_object_version_number number;
840 --
841 -- Other variables
842 l_proc varchar2(72) := g_package ||'update_saved_search';
843 Begin
844 hr_utility.set_location(' Entering:' || l_proc,10);
845 --
846 -- Issue a savepoint
847 --
848 savepoint update_saved_search_swi;
849 --
850 -- Initialise Multiple Message Detection
851 --
852 hr_multi_message.enable_message_list;
853 --
854 -- Remember IN OUT parameter IN values
855 --
856 l_object_version_number := p_object_version_number;
857 --
858 -- Convert constant values to their corresponding boolean value
859 --
860 l_validate :=
861 hr_api.constant_to_boolean
862 (p_constant_value => p_validate);
863 --
864 -- Register Surrogate ID or user key values
865 --
866 --
867 -- Call API
868 --
869 irc_search_criteria_api.update_saved_search
870 (p_validate => l_validate
871 ,p_effective_date => p_effective_date
872 ,p_search_criteria_id => p_search_criteria_id
873 ,p_person_id => p_person_id
874 ,p_search_name => p_search_name
875 ,p_location => p_location
876 ,p_distance_to_location => p_distance_to_location
877 ,p_geocode_location => p_geocode_location
878 ,p_geocode_country => p_geocode_country
879 ,p_derived_location => p_derived_location
880 ,p_location_id => p_location_id
881 ,p_longitude => p_longitude
882 ,p_latitude => p_latitude
883 ,p_employee => p_employee
884 ,p_contractor => p_contractor
885 ,p_employment_category => p_employment_category
886 ,p_keywords => p_keywords
887 ,p_travel_percentage => p_travel_percentage
888 ,p_min_salary => p_min_salary
889 ,p_salary_currency => p_salary_currency
890 ,p_salary_period => p_salary_period
891 ,p_match_competence => p_match_competence
892 ,p_match_qualification => p_match_qualification
893 ,p_work_at_home => p_work_at_home
894 ,p_job_title => p_job_title
895 ,p_department => p_department
896 ,p_professional_area => p_professional_area
897 ,p_use_for_matching => p_use_for_matching
898 ,p_description => p_description
899 ,p_attribute_category => p_attribute_category
900 ,p_attribute1 => p_attribute1
901 ,p_attribute2 => p_attribute2
902 ,p_attribute3 => p_attribute3
903 ,p_attribute4 => p_attribute4
904 ,p_attribute5 => p_attribute5
905 ,p_attribute6 => p_attribute6
906 ,p_attribute7 => p_attribute7
907 ,p_attribute8 => p_attribute8
908 ,p_attribute9 => p_attribute9
909 ,p_attribute10 => p_attribute10
910 ,p_attribute11 => p_attribute11
911 ,p_attribute12 => p_attribute12
912 ,p_attribute13 => p_attribute13
913 ,p_attribute14 => p_attribute14
914 ,p_attribute15 => p_attribute15
915 ,p_attribute16 => p_attribute16
916 ,p_attribute17 => p_attribute17
917 ,p_attribute18 => p_attribute18
918 ,p_attribute19 => p_attribute19
919 ,p_attribute20 => p_attribute20
920 ,p_attribute21 => p_attribute21
921 ,p_attribute22 => p_attribute22
922 ,p_attribute23 => p_attribute23
923 ,p_attribute24 => p_attribute24
924 ,p_attribute25 => p_attribute25
925 ,p_attribute26 => p_attribute26
926 ,p_attribute27 => p_attribute27
927 ,p_attribute28 => p_attribute28
928 ,p_attribute29 => p_attribute29
929 ,p_attribute30 => p_attribute30
930 ,p_isc_information_category => p_isc_information_category
931 ,p_isc_information1 => p_isc_information1
932 ,p_isc_information2 => p_isc_information2
933 ,p_isc_information3 => p_isc_information3
934 ,p_isc_information4 => p_isc_information4
935 ,p_isc_information5 => p_isc_information5
936 ,p_isc_information6 => p_isc_information6
937 ,p_isc_information7 => p_isc_information7
938 ,p_isc_information8 => p_isc_information8
939 ,p_isc_information9 => p_isc_information9
940 ,p_isc_information10 => p_isc_information10
941 ,p_isc_information11 => p_isc_information11
942 ,p_isc_information12 => p_isc_information12
943 ,p_isc_information13 => p_isc_information13
944 ,p_isc_information14 => p_isc_information14
945 ,p_isc_information15 => p_isc_information15
946 ,p_isc_information16 => p_isc_information16
947 ,p_isc_information17 => p_isc_information17
948 ,p_isc_information18 => p_isc_information18
949 ,p_isc_information19 => p_isc_information19
950 ,p_isc_information20 => p_isc_information20
951 ,p_isc_information21 => p_isc_information21
952 ,p_isc_information22 => p_isc_information22
953 ,p_isc_information23 => p_isc_information23
954 ,p_isc_information24 => p_isc_information24
955 ,p_isc_information25 => p_isc_information25
956 ,p_isc_information26 => p_isc_information26
957 ,p_isc_information27 => p_isc_information27
958 ,p_isc_information28 => p_isc_information28
959 ,p_isc_information29 => p_isc_information29
960 ,p_isc_information30 => p_isc_information30
961 ,p_date_posted => p_date_posted
962 ,p_object_version_number => p_object_version_number
963 );
964 --
965 -- Convert API warning boolean parameter values to specific
966 -- messages and add them to Multiple Message List
967 --
968 --
969 -- Convert API non-warning boolean parameter values
970 --
971 --
972 -- Derive the API return status value based on whether
973 -- messages of any type exist in the Multiple Message List.
974 -- Also disable Multiple Message Detection.
975 --
976 p_return_status := hr_multi_message.get_return_status_disable;
977 hr_utility.set_location(' Leaving:' || l_proc,20);
978 --
979 exception
980 when hr_multi_message.error_message_exist then
981 --
982 -- Catch the Multiple Message List exception which
983 -- indicates API processing has been aborted because
984 -- at least one message exists in the list.
985 --
986 rollback to update_saved_search_swi;
987 --
988 -- Reset IN OUT parameters and set OUT parameters
989 --
990 p_object_version_number := l_object_version_number;
991 p_return_status := hr_multi_message.get_return_status_disable;
992 hr_utility.set_location(' Leaving:' || l_proc, 30);
993 when others then
994 --
995 -- When Multiple Message Detection is enabled catch
996 -- any Application specific or other unexpected
997 -- exceptions. Adding appropriate details to the
998 -- Multiple Message List. Otherwise re-raise the
999 -- error.
1000 --
1001 rollback to update_saved_search_swi;
1002 if hr_multi_message.unexpected_error_add(l_proc) then
1003 hr_utility.set_location(' Leaving:' || l_proc,40);
1004 raise;
1005 end if;
1006 --
1007 -- Reset IN OUT and set OUT parameters
1008 --
1009 p_object_version_number := l_object_version_number;
1010 p_return_status := hr_multi_message.get_return_status_disable;
1011 hr_utility.set_location(' Leaving:' || l_proc,50);
1012 end update_saved_search;
1013 -- ----------------------------------------------------------------------------
1014 -- |------------------------< update_vacancy_criteria >-----------------------|
1015 -- ----------------------------------------------------------------------------
1016 PROCEDURE update_vacancy_criteria
1017 (p_validate in number default hr_api.g_false_num
1018 ,p_search_criteria_id in number
1019 ,p_vacancy_id in number default hr_api.g_number
1020 ,p_effective_date in date
1021 ,p_location in varchar2 default hr_api.g_varchar2
1022 ,p_employee in varchar2 default hr_api.g_varchar2
1023 ,p_contractor in varchar2 default hr_api.g_varchar2
1024 ,p_employment_category in varchar2 default hr_api.g_varchar2
1025 ,p_keywords in varchar2 default hr_api.g_varchar2
1026 ,p_travel_percentage in number default hr_api.g_number
1027 ,p_min_salary in number default hr_api.g_number
1028 ,p_max_salary in number default hr_api.g_number
1029 ,p_salary_currency in varchar2 default hr_api.g_varchar2
1030 ,p_salary_period in varchar2 default hr_api.g_varchar2
1031 ,p_professional_area in varchar2 default hr_api.g_varchar2
1032 ,p_work_at_home in varchar2 default hr_api.g_varchar2
1033 ,p_min_qual_level in number default hr_api.g_number
1034 ,p_max_qual_level in number default hr_api.g_number
1035 ,p_description in varchar2 default hr_api.g_varchar2
1036 ,p_attribute_category in varchar2 default hr_api.g_varchar2
1037 ,p_attribute1 in varchar2 default hr_api.g_varchar2
1038 ,p_attribute2 in varchar2 default hr_api.g_varchar2
1039 ,p_attribute3 in varchar2 default hr_api.g_varchar2
1040 ,p_attribute4 in varchar2 default hr_api.g_varchar2
1041 ,p_attribute5 in varchar2 default hr_api.g_varchar2
1042 ,p_attribute6 in varchar2 default hr_api.g_varchar2
1043 ,p_attribute7 in varchar2 default hr_api.g_varchar2
1044 ,p_attribute8 in varchar2 default hr_api.g_varchar2
1045 ,p_attribute9 in varchar2 default hr_api.g_varchar2
1046 ,p_attribute10 in varchar2 default hr_api.g_varchar2
1047 ,p_attribute11 in varchar2 default hr_api.g_varchar2
1048 ,p_attribute12 in varchar2 default hr_api.g_varchar2
1049 ,p_attribute13 in varchar2 default hr_api.g_varchar2
1050 ,p_attribute14 in varchar2 default hr_api.g_varchar2
1051 ,p_attribute15 in varchar2 default hr_api.g_varchar2
1052 ,p_attribute16 in varchar2 default hr_api.g_varchar2
1053 ,p_attribute17 in varchar2 default hr_api.g_varchar2
1054 ,p_attribute18 in varchar2 default hr_api.g_varchar2
1055 ,p_attribute19 in varchar2 default hr_api.g_varchar2
1056 ,p_attribute20 in varchar2 default hr_api.g_varchar2
1057 ,p_attribute21 in varchar2 default hr_api.g_varchar2
1058 ,p_attribute22 in varchar2 default hr_api.g_varchar2
1059 ,p_attribute23 in varchar2 default hr_api.g_varchar2
1060 ,p_attribute24 in varchar2 default hr_api.g_varchar2
1061 ,p_attribute25 in varchar2 default hr_api.g_varchar2
1062 ,p_attribute26 in varchar2 default hr_api.g_varchar2
1063 ,p_attribute27 in varchar2 default hr_api.g_varchar2
1064 ,p_attribute28 in varchar2 default hr_api.g_varchar2
1065 ,p_attribute29 in varchar2 default hr_api.g_varchar2
1066 ,p_attribute30 in varchar2 default hr_api.g_varchar2
1067 ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1068 ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1069 ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1070 ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1071 ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1072 ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1073 ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1074 ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1075 ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1076 ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1077 ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1078 ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1079 ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1080 ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1081 ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1082 ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1083 ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1084 ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1085 ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1086 ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1087 ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1088 ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1089 ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1090 ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1091 ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1092 ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1093 ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1094 ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1095 ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1096 ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1097 ,p_isc_information30 in varchar2 default hr_api.g_varchar2
1098 ,p_object_version_number in out nocopy number
1099 ,p_return_status out nocopy varchar2
1100 ) is
1101 --
1102 -- Variables for API Boolean parameters
1103 l_validate boolean;
1104 --
1105 -- Variables for IN/OUT parameters
1106 l_object_version_number number;
1107 --
1108 -- Other variables
1109 l_proc varchar2(72) := g_package ||'update_vacancy_criteria';
1110 Begin
1111 hr_utility.set_location(' Entering:' || l_proc,10);
1112 --
1113 -- Issue a savepoint
1114 --
1115 savepoint update_vacancy_criteria_swi;
1116 --
1117 -- Initialise Multiple Message Detection
1118 --
1119 hr_multi_message.enable_message_list;
1120 --
1121 -- Remember IN OUT parameter IN values
1122 --
1123 l_object_version_number := p_object_version_number;
1124 --
1125 -- Convert constant values to their corresponding boolean value
1126 --
1127 l_validate :=
1128 hr_api.constant_to_boolean
1129 (p_constant_value => p_validate);
1130 --
1131 -- Register Surrogate ID or user key values
1132 --
1133 --
1134 -- Call API
1135 --
1136 irc_search_criteria_api.update_vacancy_criteria
1137 (p_validate => l_validate
1138 ,p_search_criteria_id => p_search_criteria_id
1139 ,p_vacancy_id => p_vacancy_id
1140 ,p_effective_date => p_effective_date
1141 ,p_location => p_location
1142 ,p_employee => p_employee
1143 ,p_contractor => p_contractor
1144 ,p_employment_category => p_employment_category
1145 ,p_keywords => p_keywords
1146 ,p_travel_percentage => p_travel_percentage
1147 ,p_min_salary => p_min_salary
1148 ,p_max_salary => p_max_salary
1149 ,p_salary_currency => p_salary_currency
1150 ,p_salary_period => p_salary_period
1151 ,p_professional_area => p_professional_area
1152 ,p_work_at_home => p_work_at_home
1153 ,p_min_qual_level => p_min_qual_level
1154 ,p_max_qual_level => p_max_qual_level
1155 ,p_description => p_description
1156 ,p_attribute_category => p_attribute_category
1157 ,p_attribute1 => p_attribute1
1158 ,p_attribute2 => p_attribute2
1159 ,p_attribute3 => p_attribute3
1160 ,p_attribute4 => p_attribute4
1161 ,p_attribute5 => p_attribute5
1162 ,p_attribute6 => p_attribute6
1163 ,p_attribute7 => p_attribute7
1164 ,p_attribute8 => p_attribute8
1165 ,p_attribute9 => p_attribute9
1166 ,p_attribute10 => p_attribute10
1167 ,p_attribute11 => p_attribute11
1168 ,p_attribute12 => p_attribute12
1169 ,p_attribute13 => p_attribute13
1170 ,p_attribute14 => p_attribute14
1171 ,p_attribute15 => p_attribute15
1172 ,p_attribute16 => p_attribute16
1173 ,p_attribute17 => p_attribute17
1174 ,p_attribute18 => p_attribute18
1175 ,p_attribute19 => p_attribute19
1176 ,p_attribute20 => p_attribute20
1177 ,p_attribute21 => p_attribute21
1178 ,p_attribute22 => p_attribute22
1179 ,p_attribute23 => p_attribute23
1180 ,p_attribute24 => p_attribute24
1181 ,p_attribute25 => p_attribute25
1182 ,p_attribute26 => p_attribute26
1183 ,p_attribute27 => p_attribute27
1184 ,p_attribute28 => p_attribute28
1185 ,p_attribute29 => p_attribute29
1186 ,p_attribute30 => p_attribute30
1187 ,p_isc_information_category => p_isc_information_category
1188 ,p_isc_information1 => p_isc_information1
1189 ,p_isc_information2 => p_isc_information2
1190 ,p_isc_information3 => p_isc_information3
1191 ,p_isc_information4 => p_isc_information4
1192 ,p_isc_information5 => p_isc_information5
1193 ,p_isc_information6 => p_isc_information6
1194 ,p_isc_information7 => p_isc_information7
1195 ,p_isc_information8 => p_isc_information8
1196 ,p_isc_information9 => p_isc_information9
1197 ,p_isc_information10 => p_isc_information10
1198 ,p_isc_information11 => p_isc_information11
1199 ,p_isc_information12 => p_isc_information12
1200 ,p_isc_information13 => p_isc_information13
1201 ,p_isc_information14 => p_isc_information14
1202 ,p_isc_information15 => p_isc_information15
1203 ,p_isc_information16 => p_isc_information16
1204 ,p_isc_information17 => p_isc_information17
1205 ,p_isc_information18 => p_isc_information18
1206 ,p_isc_information19 => p_isc_information19
1207 ,p_isc_information20 => p_isc_information20
1208 ,p_isc_information21 => p_isc_information21
1209 ,p_isc_information22 => p_isc_information22
1210 ,p_isc_information23 => p_isc_information23
1211 ,p_isc_information24 => p_isc_information24
1212 ,p_isc_information25 => p_isc_information25
1213 ,p_isc_information26 => p_isc_information26
1214 ,p_isc_information27 => p_isc_information27
1215 ,p_isc_information28 => p_isc_information28
1216 ,p_isc_information29 => p_isc_information29
1217 ,p_isc_information30 => p_isc_information30
1218 ,p_object_version_number => p_object_version_number
1219 );
1220 --
1221 -- Convert API warning boolean parameter values to specific
1222 -- messages and add them to Multiple Message List
1223 --
1224 --
1225 -- Convert API non-warning boolean parameter values
1226 --
1227 --
1228 -- Derive the API return status value based on whether
1229 -- messages of any type exist in the Multiple Message List.
1230 -- Also disable Multiple Message Detection.
1231 --
1232 p_return_status := hr_multi_message.get_return_status_disable;
1233 hr_utility.set_location(' Leaving:' || l_proc,20);
1234 --
1235 exception
1236 when hr_multi_message.error_message_exist then
1237 --
1238 -- Catch the Multiple Message List exception which
1239 -- indicates API processing has been aborted because
1240 -- at least one message exists in the list.
1241 --
1242 rollback to update_vacancy_criteria_swi;
1243 --
1244 -- Reset IN OUT parameters and set OUT parameters
1245 --
1246 p_object_version_number := l_object_version_number;
1247 p_return_status := hr_multi_message.get_return_status_disable;
1248 hr_utility.set_location(' Leaving:' || l_proc, 30);
1249 when others then
1250 --
1251 -- When Multiple Message Detection is enabled catch
1252 -- any Application specific or other unexpected
1253 -- exceptions. Adding appropriate details to the
1254 -- Multiple Message List. Otherwise re-raise the
1255 -- error.
1256 --
1257 rollback to update_vacancy_criteria_swi;
1258 if hr_multi_message.unexpected_error_add(l_proc) then
1259 hr_utility.set_location(' Leaving:' || l_proc,40);
1260 raise;
1261 end if;
1262 --
1263 -- Reset IN OUT and set OUT parameters
1264 --
1265 p_object_version_number := l_object_version_number;
1266 p_return_status := hr_multi_message.get_return_status_disable;
1267 hr_utility.set_location(' Leaving:' || l_proc,50);
1268 end update_vacancy_criteria;
1269 --
1270 -- ----------------------------------------------------------------------------
1271 -- |--------------------------< create_work_choices >-------------------------|
1272 -- ----------------------------------------------------------------------------
1273 PROCEDURE create_work_choices
1274 (p_validate in number default hr_api.g_false_num
1275 ,p_effective_date in date
1276 ,p_person_id in number
1277 ,p_location in varchar2 default null
1278 ,p_distance_to_location in varchar2 default null
1279 ,p_geocode_location in varchar2 default null
1280 ,p_geocode_country in varchar2 default null
1281 ,p_derived_location in varchar2 default null
1282 ,p_location_id in number default null
1283 ,p_longitude in number default null
1284 ,p_latitude in number default null
1285 ,p_employee in varchar2 default null
1286 ,p_contractor in varchar2 default null
1287 ,p_employment_category in varchar2 default null
1288 ,p_keywords in varchar2 default null
1289 ,p_travel_percentage in number default null
1290 ,p_min_salary in number default null
1291 ,p_salary_currency in varchar2 default null
1292 ,p_salary_period in varchar2 default null
1293 ,p_match_competence in varchar2 default null
1294 ,p_match_qualification in varchar2 default null
1295 ,p_work_at_home in varchar2 default null
1296 ,p_job_title in varchar2 default null
1297 ,p_department in varchar2 default null
1298 ,p_professional_area in varchar2 default null
1299 ,p_description in varchar2 default null
1300 ,p_attribute_category in varchar2 default null
1301 ,p_attribute1 in varchar2 default null
1302 ,p_attribute2 in varchar2 default null
1303 ,p_attribute3 in varchar2 default null
1304 ,p_attribute4 in varchar2 default null
1305 ,p_attribute5 in varchar2 default null
1306 ,p_attribute6 in varchar2 default null
1307 ,p_attribute7 in varchar2 default null
1308 ,p_attribute8 in varchar2 default null
1309 ,p_attribute9 in varchar2 default null
1310 ,p_attribute10 in varchar2 default null
1311 ,p_attribute11 in varchar2 default null
1312 ,p_attribute12 in varchar2 default null
1313 ,p_attribute13 in varchar2 default null
1314 ,p_attribute14 in varchar2 default null
1315 ,p_attribute15 in varchar2 default null
1316 ,p_attribute16 in varchar2 default null
1317 ,p_attribute17 in varchar2 default null
1318 ,p_attribute18 in varchar2 default null
1319 ,p_attribute19 in varchar2 default null
1320 ,p_attribute20 in varchar2 default null
1321 ,p_attribute21 in varchar2 default null
1322 ,p_attribute22 in varchar2 default null
1323 ,p_attribute23 in varchar2 default null
1324 ,p_attribute24 in varchar2 default null
1325 ,p_attribute25 in varchar2 default null
1326 ,p_attribute26 in varchar2 default null
1327 ,p_attribute27 in varchar2 default null
1328 ,p_attribute28 in varchar2 default null
1329 ,p_attribute29 in varchar2 default null
1330 ,p_attribute30 in varchar2 default null
1331 ,p_isc_information_category in varchar2 default null
1332 ,p_isc_information1 in varchar2 default null
1333 ,p_isc_information2 in varchar2 default null
1334 ,p_isc_information3 in varchar2 default null
1335 ,p_isc_information4 in varchar2 default null
1336 ,p_isc_information5 in varchar2 default null
1337 ,p_isc_information6 in varchar2 default null
1338 ,p_isc_information7 in varchar2 default null
1339 ,p_isc_information8 in varchar2 default null
1340 ,p_isc_information9 in varchar2 default null
1341 ,p_isc_information10 in varchar2 default null
1342 ,p_isc_information11 in varchar2 default null
1343 ,p_isc_information12 in varchar2 default null
1344 ,p_isc_information13 in varchar2 default null
1345 ,p_isc_information14 in varchar2 default null
1346 ,p_isc_information15 in varchar2 default null
1347 ,p_isc_information16 in varchar2 default null
1348 ,p_isc_information17 in varchar2 default null
1349 ,p_isc_information18 in varchar2 default null
1350 ,p_isc_information19 in varchar2 default null
1351 ,p_isc_information20 in varchar2 default null
1352 ,p_isc_information21 in varchar2 default null
1353 ,p_isc_information22 in varchar2 default null
1354 ,p_isc_information23 in varchar2 default null
1355 ,p_isc_information24 in varchar2 default null
1356 ,p_isc_information25 in varchar2 default null
1357 ,p_isc_information26 in varchar2 default null
1358 ,p_isc_information27 in varchar2 default null
1359 ,p_isc_information28 in varchar2 default null
1360 ,p_isc_information29 in varchar2 default null
1361 ,p_isc_information30 in varchar2 default null
1362 ,p_object_version_number out nocopy number
1363 ,p_search_criteria_id in number
1364 ,p_return_status out nocopy varchar2
1365 ) is
1366 --
1367 -- Variables for API Boolean parameters
1368 l_validate boolean;
1369 --
1370 -- Variables for IN/OUT parameters
1371 --
1372 -- Other variables
1373 l_search_criteria_id number;
1374 l_proc varchar2(72) := g_package ||'create_work_choices';
1375 Begin
1376 hr_utility.set_location(' Entering:' || l_proc,10);
1377 --
1378 -- Issue a savepoint
1379 --
1380 savepoint create_work_choices_swi;
1381 --
1382 -- Initialise Multiple Message Detection
1383 --
1384 hr_multi_message.enable_message_list;
1385 --
1386 -- Remember IN OUT parameter IN values
1387 --
1388 --
1389 -- Convert constant values to their corresponding boolean value
1390 --
1391 l_validate :=
1392 hr_api.constant_to_boolean
1393 (p_constant_value => p_validate);
1394 --
1395 -- Register Surrogate ID or user key values
1396 --
1397 irc_isc_ins.set_base_key_value
1398 (p_search_criteria_id => p_search_criteria_id
1399 );
1400 --
1401 -- Call API
1402 --
1403 irc_search_criteria_api.create_work_choices
1404 (p_validate => l_validate
1405 ,p_effective_date => p_effective_date
1406 ,p_person_id => p_person_id
1407 ,p_location => p_location
1408 ,p_distance_to_location => p_distance_to_location
1409 ,p_geocode_location => p_geocode_location
1410 ,p_geocode_country => p_geocode_country
1411 ,p_derived_location => p_derived_location
1412 ,p_location_id => p_location_id
1413 ,p_longitude => p_longitude
1414 ,p_latitude => p_latitude
1415 ,p_employee => p_employee
1416 ,p_contractor => p_contractor
1417 ,p_employment_category => p_employment_category
1418 ,p_keywords => p_keywords
1419 ,p_travel_percentage => p_travel_percentage
1420 ,p_min_salary => p_min_salary
1421 ,p_salary_currency => p_salary_currency
1422 ,p_salary_period => p_salary_period
1423 ,p_match_competence => p_match_competence
1424 ,p_match_qualification => p_match_qualification
1425 ,p_work_at_home => p_work_at_home
1426 ,p_job_title => p_job_title
1427 ,p_department => p_department
1428 ,p_professional_area => p_professional_area
1429 ,p_description => p_description
1430 ,p_attribute_category => p_attribute_category
1431 ,p_attribute1 => p_attribute1
1432 ,p_attribute2 => p_attribute2
1433 ,p_attribute3 => p_attribute3
1434 ,p_attribute4 => p_attribute4
1435 ,p_attribute5 => p_attribute5
1436 ,p_attribute6 => p_attribute6
1437 ,p_attribute7 => p_attribute7
1438 ,p_attribute8 => p_attribute8
1439 ,p_attribute9 => p_attribute9
1440 ,p_attribute10 => p_attribute10
1441 ,p_attribute11 => p_attribute11
1442 ,p_attribute12 => p_attribute12
1443 ,p_attribute13 => p_attribute13
1444 ,p_attribute14 => p_attribute14
1445 ,p_attribute15 => p_attribute15
1446 ,p_attribute16 => p_attribute16
1447 ,p_attribute17 => p_attribute17
1448 ,p_attribute18 => p_attribute18
1449 ,p_attribute19 => p_attribute19
1450 ,p_attribute20 => p_attribute20
1451 ,p_attribute21 => p_attribute21
1452 ,p_attribute22 => p_attribute22
1453 ,p_attribute23 => p_attribute23
1454 ,p_attribute24 => p_attribute24
1455 ,p_attribute25 => p_attribute25
1456 ,p_attribute26 => p_attribute26
1457 ,p_attribute27 => p_attribute27
1458 ,p_attribute28 => p_attribute28
1459 ,p_attribute29 => p_attribute29
1460 ,p_attribute30 => p_attribute30
1461 ,p_isc_information_category => p_isc_information_category
1462 ,p_isc_information1 => p_isc_information1
1463 ,p_isc_information2 => p_isc_information2
1464 ,p_isc_information3 => p_isc_information3
1465 ,p_isc_information4 => p_isc_information4
1466 ,p_isc_information5 => p_isc_information5
1467 ,p_isc_information6 => p_isc_information6
1468 ,p_isc_information7 => p_isc_information7
1469 ,p_isc_information8 => p_isc_information8
1470 ,p_isc_information9 => p_isc_information9
1471 ,p_isc_information10 => p_isc_information10
1472 ,p_isc_information11 => p_isc_information11
1473 ,p_isc_information12 => p_isc_information12
1474 ,p_isc_information13 => p_isc_information13
1475 ,p_isc_information14 => p_isc_information14
1476 ,p_isc_information15 => p_isc_information15
1477 ,p_isc_information16 => p_isc_information16
1478 ,p_isc_information17 => p_isc_information17
1479 ,p_isc_information18 => p_isc_information18
1480 ,p_isc_information19 => p_isc_information19
1481 ,p_isc_information20 => p_isc_information20
1482 ,p_isc_information21 => p_isc_information21
1483 ,p_isc_information22 => p_isc_information22
1484 ,p_isc_information23 => p_isc_information23
1485 ,p_isc_information24 => p_isc_information24
1486 ,p_isc_information25 => p_isc_information25
1487 ,p_isc_information26 => p_isc_information26
1488 ,p_isc_information27 => p_isc_information27
1489 ,p_isc_information28 => p_isc_information28
1490 ,p_isc_information29 => p_isc_information29
1491 ,p_isc_information30 => p_isc_information30
1492 ,p_object_version_number => p_object_version_number
1493 ,p_search_criteria_id => l_search_criteria_id
1494 );
1495 --
1496 -- Convert API warning boolean parameter values to specific
1497 -- messages and add them to Multiple Message List
1498 --
1499 --
1500 -- Convert API non-warning boolean parameter values
1501 --
1502 --
1503 -- Derive the API return status value based on whether
1504 -- messages of any type exist in the Multiple Message List.
1505 -- Also disable Multiple Message Detection.
1506 --
1507 p_return_status := hr_multi_message.get_return_status_disable;
1508 hr_utility.set_location(' Leaving:' || l_proc,20);
1509 --
1510 exception
1511 when hr_multi_message.error_message_exist then
1512 --
1513 -- Catch the Multiple Message List exception which
1514 -- indicates API processing has been aborted because
1515 -- at least one message exists in the list.
1516 --
1517 rollback to create_work_choices_swi;
1518 --
1519 -- Reset IN OUT parameters and set OUT parameters
1520 --
1521 p_object_version_number := null;
1522 p_return_status := hr_multi_message.get_return_status_disable;
1523 hr_utility.set_location(' Leaving:' || l_proc, 30);
1524 when others then
1525 --
1526 -- When Multiple Message Detection is enabled catch
1527 -- any Application specific or other unexpected
1528 -- exceptions. Adding appropriate details to the
1529 -- Multiple Message List. Otherwise re-raise the
1530 -- error.
1531 --
1532 rollback to create_work_choices_swi;
1533 if hr_multi_message.unexpected_error_add(l_proc) then
1534 hr_utility.set_location(' Leaving:' || l_proc,40);
1535 raise;
1536 end if;
1537 --
1538 -- Reset IN OUT and set OUT parameters
1539 --
1540 p_object_version_number := null;
1541 p_return_status := hr_multi_message.get_return_status_disable;
1542 hr_utility.set_location(' Leaving:' || l_proc,50);
1543 end create_work_choices;
1544 -- ----------------------------------------------------------------------------
1545 -- |--------------------------< delete_work_choices >-------------------------|
1546 -- ----------------------------------------------------------------------------
1547 PROCEDURE delete_work_choices
1548 (p_validate in number default hr_api.g_false_num
1549 ,p_search_criteria_id in number
1550 ,p_object_version_number in number
1551 ,p_return_status out nocopy varchar2
1552 ) is
1553 --
1554 -- Variables for API Boolean parameters
1555 l_validate boolean;
1556 --
1557 -- Variables for IN/OUT parameters
1558 --
1559 -- Other variables
1560 l_proc varchar2(72) := g_package ||'delete_work_choices';
1561 Begin
1562 hr_utility.set_location(' Entering:' || l_proc,10);
1563 --
1564 -- Issue a savepoint
1565 --
1566 savepoint delete_work_choices_swi;
1567 --
1568 -- Initialise Multiple Message Detection
1569 --
1570 hr_multi_message.enable_message_list;
1571 --
1572 -- Remember IN OUT parameter IN values
1573 --
1574 --
1575 -- Convert constant values to their corresponding boolean value
1576 --
1577 l_validate :=
1578 hr_api.constant_to_boolean
1579 (p_constant_value => p_validate);
1580 --
1581 -- Register Surrogate ID or user key values
1582 --
1583 --
1584 -- Call API
1585 --
1586 irc_search_criteria_api.delete_work_choices
1587 (p_validate => l_validate
1588 ,p_search_criteria_id => p_search_criteria_id
1589 ,p_object_version_number => p_object_version_number
1590 );
1591 --
1592 -- Convert API warning boolean parameter values to specific
1593 -- messages and add them to Multiple Message List
1594 --
1595 --
1596 -- Convert API non-warning boolean parameter values
1597 --
1598 --
1599 -- Derive the API return status value based on whether
1600 -- messages of any type exist in the Multiple Message List.
1601 -- Also disable Multiple Message Detection.
1602 --
1603 p_return_status := hr_multi_message.get_return_status_disable;
1604 hr_utility.set_location(' Leaving:' || l_proc,20);
1605 --
1606 exception
1607 when hr_multi_message.error_message_exist then
1608 --
1609 -- Catch the Multiple Message List exception which
1610 -- indicates API processing has been aborted because
1611 -- at least one message exists in the list.
1612 --
1613 rollback to delete_work_choices_swi;
1614 --
1615 -- Reset IN OUT parameters and set OUT parameters
1616 --
1617 p_return_status := hr_multi_message.get_return_status_disable;
1618 hr_utility.set_location(' Leaving:' || l_proc, 30);
1619 when others then
1620 --
1621 -- When Multiple Message Detection is enabled catch
1622 -- any Application specific or other unexpected
1623 -- exceptions. Adding appropriate details to the
1624 -- Multiple Message List. Otherwise re-raise the
1625 -- error.
1626 --
1627 rollback to delete_work_choices_swi;
1628 if hr_multi_message.unexpected_error_add(l_proc) then
1629 hr_utility.set_location(' Leaving:' || l_proc,40);
1630 raise;
1631 end if;
1632 --
1633 -- Reset IN OUT and set OUT parameters
1634 --
1635 p_return_status := hr_multi_message.get_return_status_disable;
1636 hr_utility.set_location(' Leaving:' || l_proc,50);
1637 end delete_work_choices;
1638 -- ----------------------------------------------------------------------------
1639 -- |--------------------------< update_work_choices >-------------------------|
1640 -- ----------------------------------------------------------------------------
1641 PROCEDURE update_work_choices
1642 (p_validate in number default hr_api.g_false_num
1643 ,p_effective_date in date
1644 ,p_search_criteria_id in number
1645 ,p_location in varchar2 default hr_api.g_varchar2
1646 ,p_distance_to_location in varchar2 default hr_api.g_varchar2
1647 ,p_geocode_location in varchar2 default hr_api.g_varchar2
1648 ,p_geocode_country in varchar2 default hr_api.g_varchar2
1649 ,p_derived_location in varchar2 default hr_api.g_varchar2
1650 ,p_location_id in number default hr_api.g_number
1651 ,p_longitude in number default hr_api.g_number
1652 ,p_latitude in number default hr_api.g_number
1653 ,p_employee in varchar2 default hr_api.g_varchar2
1654 ,p_contractor in varchar2 default hr_api.g_varchar2
1655 ,p_employment_category in varchar2 default hr_api.g_varchar2
1656 ,p_keywords in varchar2 default hr_api.g_varchar2
1657 ,p_travel_percentage in number default hr_api.g_number
1658 ,p_min_salary in number default hr_api.g_number
1659 ,p_salary_currency in varchar2 default hr_api.g_varchar2
1660 ,p_salary_period in varchar2 default hr_api.g_varchar2
1661 ,p_match_competence in varchar2 default hr_api.g_varchar2
1662 ,p_match_qualification in varchar2 default hr_api.g_varchar2
1663 ,p_work_at_home in varchar2 default hr_api.g_varchar2
1664 ,p_job_title in varchar2 default hr_api.g_varchar2
1665 ,p_department in varchar2 default hr_api.g_varchar2
1666 ,p_professional_area in varchar2 default hr_api.g_varchar2
1667 ,p_description in varchar2 default hr_api.g_varchar2
1668 ,p_attribute_category in varchar2 default hr_api.g_varchar2
1669 ,p_attribute1 in varchar2 default hr_api.g_varchar2
1670 ,p_attribute2 in varchar2 default hr_api.g_varchar2
1671 ,p_attribute3 in varchar2 default hr_api.g_varchar2
1672 ,p_attribute4 in varchar2 default hr_api.g_varchar2
1673 ,p_attribute5 in varchar2 default hr_api.g_varchar2
1674 ,p_attribute6 in varchar2 default hr_api.g_varchar2
1675 ,p_attribute7 in varchar2 default hr_api.g_varchar2
1676 ,p_attribute8 in varchar2 default hr_api.g_varchar2
1677 ,p_attribute9 in varchar2 default hr_api.g_varchar2
1678 ,p_attribute10 in varchar2 default hr_api.g_varchar2
1679 ,p_attribute11 in varchar2 default hr_api.g_varchar2
1680 ,p_attribute12 in varchar2 default hr_api.g_varchar2
1681 ,p_attribute13 in varchar2 default hr_api.g_varchar2
1682 ,p_attribute14 in varchar2 default hr_api.g_varchar2
1683 ,p_attribute15 in varchar2 default hr_api.g_varchar2
1684 ,p_attribute16 in varchar2 default hr_api.g_varchar2
1685 ,p_attribute17 in varchar2 default hr_api.g_varchar2
1686 ,p_attribute18 in varchar2 default hr_api.g_varchar2
1687 ,p_attribute19 in varchar2 default hr_api.g_varchar2
1688 ,p_attribute20 in varchar2 default hr_api.g_varchar2
1689 ,p_attribute21 in varchar2 default hr_api.g_varchar2
1690 ,p_attribute22 in varchar2 default hr_api.g_varchar2
1691 ,p_attribute23 in varchar2 default hr_api.g_varchar2
1692 ,p_attribute24 in varchar2 default hr_api.g_varchar2
1693 ,p_attribute25 in varchar2 default hr_api.g_varchar2
1694 ,p_attribute26 in varchar2 default hr_api.g_varchar2
1695 ,p_attribute27 in varchar2 default hr_api.g_varchar2
1696 ,p_attribute28 in varchar2 default hr_api.g_varchar2
1697 ,p_attribute29 in varchar2 default hr_api.g_varchar2
1698 ,p_attribute30 in varchar2 default hr_api.g_varchar2
1699 ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1700 ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1701 ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1702 ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1703 ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1704 ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1705 ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1706 ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1707 ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1708 ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1709 ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1710 ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1711 ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1712 ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1713 ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1714 ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1715 ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1716 ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1717 ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1718 ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1719 ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1720 ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1721 ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1722 ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1723 ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1724 ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1725 ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1726 ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1727 ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1728 ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1729 ,p_isc_information30 in varchar2 default hr_api.g_varchar2
1730 ,p_object_version_number in out nocopy number
1731 ,p_return_status out nocopy varchar2
1732 ) is
1733 --
1734 -- Variables for API Boolean parameters
1735 l_validate boolean;
1736 --
1737 -- Variables for IN/OUT parameters
1738 l_object_version_number number;
1739 --
1740 -- Other variables
1741 l_proc varchar2(72) := g_package ||'update_work_choices';
1742 Begin
1743 hr_utility.set_location(' Entering:' || l_proc,10);
1744 --
1745 -- Issue a savepoint
1746 --
1747 savepoint update_work_choices_swi;
1748 --
1749 -- Initialise Multiple Message Detection
1750 --
1751 hr_multi_message.enable_message_list;
1752 --
1753 -- Remember IN OUT parameter IN values
1754 --
1755 l_object_version_number := p_object_version_number;
1756 --
1757 -- Convert constant values to their corresponding boolean value
1758 --
1759 l_validate :=
1760 hr_api.constant_to_boolean
1761 (p_constant_value => p_validate);
1762 --
1763 -- Register Surrogate ID or user key values
1764 --
1765 --
1766 -- Call API
1767 --
1768 irc_search_criteria_api.update_work_choices
1769 (p_validate => l_validate
1770 ,p_effective_date => p_effective_date
1771 ,p_search_criteria_id => p_search_criteria_id
1772 ,p_location => p_location
1773 ,p_distance_to_location => p_distance_to_location
1774 ,p_geocode_location => p_geocode_location
1775 ,p_geocode_country => p_geocode_country
1776 ,p_derived_location => p_derived_location
1777 ,p_location_id => p_location_id
1778 ,p_longitude => p_longitude
1779 ,p_latitude => p_latitude
1780 ,p_employee => p_employee
1781 ,p_contractor => p_contractor
1782 ,p_employment_category => p_employment_category
1783 ,p_keywords => p_keywords
1784 ,p_travel_percentage => p_travel_percentage
1785 ,p_min_salary => p_min_salary
1786 ,p_salary_currency => p_salary_currency
1787 ,p_salary_period => p_salary_period
1788 ,p_match_competence => p_match_competence
1789 ,p_match_qualification => p_match_qualification
1790 ,p_work_at_home => p_work_at_home
1791 ,p_job_title => p_job_title
1792 ,p_department => p_department
1793 ,p_professional_area => p_professional_area
1794 ,p_description => p_description
1795 ,p_attribute_category => p_attribute_category
1796 ,p_attribute1 => p_attribute1
1797 ,p_attribute2 => p_attribute2
1798 ,p_attribute3 => p_attribute3
1799 ,p_attribute4 => p_attribute4
1800 ,p_attribute5 => p_attribute5
1801 ,p_attribute6 => p_attribute6
1802 ,p_attribute7 => p_attribute7
1803 ,p_attribute8 => p_attribute8
1804 ,p_attribute9 => p_attribute9
1805 ,p_attribute10 => p_attribute10
1806 ,p_attribute11 => p_attribute11
1807 ,p_attribute12 => p_attribute12
1808 ,p_attribute13 => p_attribute13
1809 ,p_attribute14 => p_attribute14
1810 ,p_attribute15 => p_attribute15
1811 ,p_attribute16 => p_attribute16
1812 ,p_attribute17 => p_attribute17
1813 ,p_attribute18 => p_attribute18
1814 ,p_attribute19 => p_attribute19
1815 ,p_attribute20 => p_attribute20
1816 ,p_attribute21 => p_attribute21
1817 ,p_attribute22 => p_attribute22
1818 ,p_attribute23 => p_attribute23
1819 ,p_attribute24 => p_attribute24
1820 ,p_attribute25 => p_attribute25
1821 ,p_attribute26 => p_attribute26
1822 ,p_attribute27 => p_attribute27
1823 ,p_attribute28 => p_attribute28
1824 ,p_attribute29 => p_attribute29
1825 ,p_attribute30 => p_attribute30
1826 ,p_isc_information_category => p_isc_information_category
1827 ,p_isc_information1 => p_isc_information1
1828 ,p_isc_information2 => p_isc_information2
1829 ,p_isc_information3 => p_isc_information3
1830 ,p_isc_information4 => p_isc_information4
1831 ,p_isc_information5 => p_isc_information5
1832 ,p_isc_information6 => p_isc_information6
1833 ,p_isc_information7 => p_isc_information7
1834 ,p_isc_information8 => p_isc_information8
1835 ,p_isc_information9 => p_isc_information9
1836 ,p_isc_information10 => p_isc_information10
1837 ,p_isc_information11 => p_isc_information11
1838 ,p_isc_information12 => p_isc_information12
1839 ,p_isc_information13 => p_isc_information13
1840 ,p_isc_information14 => p_isc_information14
1841 ,p_isc_information15 => p_isc_information15
1842 ,p_isc_information16 => p_isc_information16
1843 ,p_isc_information17 => p_isc_information17
1844 ,p_isc_information18 => p_isc_information18
1845 ,p_isc_information19 => p_isc_information19
1846 ,p_isc_information20 => p_isc_information20
1847 ,p_isc_information21 => p_isc_information21
1848 ,p_isc_information22 => p_isc_information22
1849 ,p_isc_information23 => p_isc_information23
1850 ,p_isc_information24 => p_isc_information24
1851 ,p_isc_information25 => p_isc_information25
1852 ,p_isc_information26 => p_isc_information26
1853 ,p_isc_information27 => p_isc_information27
1854 ,p_isc_information28 => p_isc_information28
1855 ,p_isc_information29 => p_isc_information29
1856 ,p_isc_information30 => p_isc_information30
1857 ,p_object_version_number => p_object_version_number
1858 );
1859 --
1860 -- Convert API warning boolean parameter values to specific
1861 -- messages and add them to Multiple Message List
1862 --
1863 --
1864 -- Convert API non-warning boolean parameter values
1865 --
1866 --
1867 -- Derive the API return status value based on whether
1868 -- messages of any type exist in the Multiple Message List.
1869 -- Also disable Multiple Message Detection.
1870 --
1871 p_return_status := hr_multi_message.get_return_status_disable;
1872 hr_utility.set_location(' Leaving:' || l_proc,20);
1873 --
1874 exception
1875 when hr_multi_message.error_message_exist then
1876 --
1877 -- Catch the Multiple Message List exception which
1878 -- indicates API processing has been aborted because
1879 -- at least one message exists in the list.
1880 --
1881 rollback to update_work_choices_swi;
1882 --
1883 -- Reset IN OUT parameters and set OUT parameters
1884 --
1885 p_object_version_number := l_object_version_number;
1886 p_return_status := hr_multi_message.get_return_status_disable;
1887 hr_utility.set_location(' Leaving:' || l_proc, 30);
1888 when others then
1889 --
1890 -- When Multiple Message Detection is enabled catch
1891 -- any Application specific or other unexpected
1892 -- exceptions. Adding appropriate details to the
1893 -- Multiple Message List. Otherwise re-raise the
1894 -- error.
1895 --
1896 rollback to update_work_choices_swi;
1897 if hr_multi_message.unexpected_error_add(l_proc) then
1898 hr_utility.set_location(' Leaving:' || l_proc,40);
1899 raise;
1900 end if;
1901 --
1902 -- Reset IN OUT and set OUT parameters
1903 --
1904 p_object_version_number := l_object_version_number;
1905 p_return_status := hr_multi_message.get_return_status_disable;
1906 hr_utility.set_location(' Leaving:' || l_proc,50);
1907 end update_work_choices;
1908
1909 -- ----------------------------------------------------------------------------
1910 -- |------------------------< process_vacancy_api >---------------------------|
1911 -- ----------------------------------------------------------------------------
1912
1913 procedure process_vacancy_api
1914 (
1915 p_document in CLOB
1916 ,p_return_status out nocopy VARCHAR2
1917 ,p_validate in number default hr_api.g_false_num
1918 ,p_effective_date in date default null
1919 )
1920 IS
1921 l_postState VARCHAR2(2);
1922 l_return_status VARCHAR2(1);
1923 l_object_version_number number;
1924 l_search_criteria_id number;
1925 l_commitElement xmldom.DOMElement;
1926 l_parser xmlparser.Parser;
1927 l_CommitNode xmldom.DOMNode;
1928
1929 l_proc varchar2(72) := g_package || 'process_offers_api';
1930 l_effective_date date := trunc(sysdate);
1931
1932 BEGIN
1933 --
1934 hr_utility.set_location(' Entering:' || l_proc,10);
1935 hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
1936 --
1937 l_parser := xmlparser.newParser;
1938 xmlparser.ParseCLOB(l_parser,p_document);
1939 l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
1940 --
1941 hr_utility.set_location('Extracting the PostState:' || l_proc,20);
1942
1943 l_commitElement := xmldom.makeElement(l_CommitNode);
1944 l_postState := xmldom.getAttribute(l_commitElement, 'PS');
1945 --
1946 --Get the values for in/out parameters
1947 --
1948 l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
1949 l_search_criteria_id := hr_transaction_swi.getNumberValue(l_CommitNode,'SearchCriteriaId');
1950 --
1951 if p_effective_date is null then
1952 l_effective_date := trunc(sysdate);
1953 else
1954 l_effective_date := p_effective_date;
1955 end if;
1956 --
1957 if l_postState = '0' then
1958 --
1959 hr_utility.set_location('creating :' || l_proc,30);
1960 --
1961 create_vacancy_criteria
1962 (p_validate => p_validate
1963 ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectId',NULL)
1964 ,p_effective_date => l_effective_date
1965 ,p_location => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Location',NULL)
1966 ,p_employee => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Employee',NULL)
1967 ,p_contractor => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Contractor',NULL)
1968 ,p_employment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmploymentCategory',NULL)
1969 ,p_keywords => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Keywords',NULL)
1970 ,p_travel_percentage => hr_transaction_swi.getNumberValue(l_CommitNode,'TravelPercentage',NULL)
1971 ,p_min_salary => hr_transaction_swi.getNumberValue(l_CommitNode,'MinSalary',NULL)
1972 ,p_max_salary => hr_transaction_swi.getNumberValue(l_CommitNode,'MaxSalary',NULL)
1973 ,p_salary_currency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SalaryCurrency',NULL)
1974 ,p_salary_period => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SalaryPeriod',NULL)
1975 ,p_professional_area => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProfessionalArea',NULL)
1976 ,p_work_at_home => hr_transaction_swi.getVarchar2Value(l_CommitNode,'WorkAtHome',NULL)
1977 ,p_min_qual_level => hr_transaction_swi.getNumberValue(l_CommitNode,'MinQualLevel',NULL)
1978 ,p_max_qual_level => hr_transaction_swi.getNumberValue(l_CommitNode,'MaxQualLevel',NULL)
1979 ,p_description => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Description',NULL)
1980 ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',NULL)
1981 ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',NULL)
1982 ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',NULL)
1983 ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',NULL)
1984 ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',NULL)
1985 ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',NULL)
1986 ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',NULL)
1987 ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',NULL)
1988 ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',NULL)
1989 ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',NULL)
1990 ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',NULL)
1991 ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',NULL)
1992 ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',NULL)
1993 ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',NULL)
1994 ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',NULL)
1995 ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',NULL)
1996 ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',NULL)
1997 ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',NULL)
1998 ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',NULL)
1999 ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',NULL)
2000 ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',NULL)
2001 ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21',NULL)
2002 ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22',NULL)
2003 ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23',NULL)
2004 ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24',NULL)
2005 ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25',NULL)
2006 ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26',NULL)
2007 ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27',NULL)
2008 ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28',NULL)
2009 ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29',NULL)
2010 ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30',NULL)
2011 ,p_isc_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformationCategory',NULL)
2012 ,p_isc_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation1',NULL)
2013 ,p_isc_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation2',NULL)
2014 ,p_isc_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation3',NULL)
2015 ,p_isc_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation4',NULL)
2016 ,p_isc_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation5',NULL)
2017 ,p_isc_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation6',NULL)
2018 ,p_isc_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation7',NULL)
2019 ,p_isc_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation8',NULL)
2020 ,p_isc_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation9',NULL)
2021 ,p_isc_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation10',NULL)
2022 ,p_isc_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation11',NULL)
2023 ,p_isc_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation12',NULL)
2024 ,p_isc_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation13',NULL)
2025 ,p_isc_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation14',NULL)
2026 ,p_isc_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation15',NULL)
2027 ,p_isc_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation16',NULL)
2028 ,p_isc_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation17',NULL)
2029 ,p_isc_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation18',NULL)
2030 ,p_isc_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation19',NULL)
2031 ,p_isc_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation20',NULL)
2032 ,p_isc_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation21',NULL)
2033 ,p_isc_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation22',NULL)
2034 ,p_isc_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation23',NULL)
2035 ,p_isc_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation24',NULL)
2036 ,p_isc_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation25',NULL)
2037 ,p_isc_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation26',NULL)
2038 ,p_isc_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation27',NULL)
2039 ,p_isc_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation28',NULL)
2040 ,p_isc_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation29',NULL)
2041 ,p_isc_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation30',NULL)
2042 ,p_search_criteria_id => l_search_criteria_id
2043 ,p_object_version_number => l_object_version_number
2044 ,p_return_status => l_return_status
2045 );
2046 --
2047 elsif l_postState = '2' then
2048 --
2049 hr_utility.set_location('updating :' || l_proc,32);
2050 --
2051 update_vacancy_criteria
2052 (p_validate => p_validate
2053 ,p_effective_date => l_effective_date
2054 ,p_search_criteria_id => l_search_criteria_id
2055 ,p_vacancy_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectId',NULL)
2056 ,p_location => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Location',NULL)
2057 ,p_employee => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Employee',NULL)
2058 ,p_contractor => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Contractor',NULL)
2059 ,p_employment_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'EmploymentCategory',NULL)
2060 ,p_keywords => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Keywords',NULL)
2061 ,p_travel_percentage => hr_transaction_swi.getNumberValue(l_CommitNode,'TravelPercentage',NULL)
2062 ,p_min_salary => hr_transaction_swi.getNumberValue(l_CommitNode,'MinSalary',NULL)
2063 ,p_max_salary => hr_transaction_swi.getNumberValue(l_CommitNode,'MaxSalary',NULL)
2064 ,p_salary_currency => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SalaryCurrency',NULL)
2065 ,p_salary_period => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SalaryPeriod',NULL)
2066 ,p_professional_area => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ProfessionalArea',NULL)
2067 ,p_work_at_home => hr_transaction_swi.getVarchar2Value(l_CommitNode,'WorkAtHome',NULL)
2068 ,p_min_qual_level => hr_transaction_swi.getNumberValue(l_CommitNode,'MinQualLevel',NULL)
2069 ,p_max_qual_level => hr_transaction_swi.getNumberValue(l_CommitNode,'MaxQualLevel',NULL)
2070 ,p_description => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Description',NULL)
2071 ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',NULL)
2072 ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',NULL)
2073 ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',NULL)
2074 ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',NULL)
2075 ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',NULL)
2076 ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',NULL)
2077 ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',NULL)
2078 ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',NULL)
2079 ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',NULL)
2080 ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',NULL)
2081 ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',NULL)
2082 ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',NULL)
2083 ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',NULL)
2084 ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',NULL)
2085 ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',NULL)
2086 ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',NULL)
2087 ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',NULL)
2088 ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',NULL)
2089 ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',NULL)
2090 ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',NULL)
2091 ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',NULL)
2092 ,p_attribute21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute21',NULL)
2093 ,p_attribute22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute22',NULL)
2094 ,p_attribute23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute23',NULL)
2095 ,p_attribute24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute24',NULL)
2096 ,p_attribute25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute25',NULL)
2097 ,p_attribute26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute26',NULL)
2098 ,p_attribute27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute27',NULL)
2099 ,p_attribute28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute28',NULL)
2100 ,p_attribute29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute29',NULL)
2101 ,p_attribute30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute30',NULL)
2102 ,p_isc_information_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformationCategory',NULL)
2103 ,p_isc_information1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation1',NULL)
2104 ,p_isc_information2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation2',NULL)
2105 ,p_isc_information3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation3',NULL)
2106 ,p_isc_information4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation4',NULL)
2107 ,p_isc_information5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation5',NULL)
2108 ,p_isc_information6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation6',NULL)
2109 ,p_isc_information7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation7',NULL)
2110 ,p_isc_information8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation8',NULL)
2111 ,p_isc_information9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation9',NULL)
2112 ,p_isc_information10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation10',NULL)
2113 ,p_isc_information11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation11',NULL)
2114 ,p_isc_information12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation12',NULL)
2115 ,p_isc_information13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation13',NULL)
2116 ,p_isc_information14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation14',NULL)
2117 ,p_isc_information15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation15',NULL)
2118 ,p_isc_information16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation16',NULL)
2119 ,p_isc_information17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation17',NULL)
2120 ,p_isc_information18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation18',NULL)
2121 ,p_isc_information19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation19',NULL)
2122 ,p_isc_information20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation20',NULL)
2123 ,p_isc_information21 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation21',NULL)
2124 ,p_isc_information22 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation22',NULL)
2125 ,p_isc_information23 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation23',NULL)
2126 ,p_isc_information24 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation24',NULL)
2127 ,p_isc_information25 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation25',NULL)
2128 ,p_isc_information26 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation26',NULL)
2129 ,p_isc_information27 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation27',NULL)
2130 ,p_isc_information28 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation28',NULL)
2131 ,p_isc_information29 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation29',NULL)
2132 ,p_isc_information30 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'IscInformation30',NULL)
2133 ,p_object_version_number => l_object_version_number
2134 ,p_return_status => l_return_status
2135 );
2136 --
2137 elsif l_postState = '3' then
2138 --
2139 hr_utility.set_location('deleting :' || l_proc,33);
2140 --
2141 delete_vacancy_criteria
2142 (p_validate => p_validate
2143 ,p_object_version_number => l_object_version_number
2144 ,p_search_criteria_id => l_search_criteria_id
2145 ,p_return_status => l_return_status
2146 );
2147 --
2148 end if;
2149 p_return_status := l_return_status;
2150
2151 hr_utility.set_location
2152 ('Exiting :'|| l_proc || ': return status :'|| l_return_status || ':',40);
2153 --
2154 end process_vacancy_api;
2155 --
2156 end irc_search_criteria_swi;