[Home] [Help]
PACKAGE BODY: APPS.IRC_SEARCH_CRITERIA_API
Source
4 -- Package Variables
1 Package Body IRC_SEARCH_CRITERIA_API as
2 /* $Header: iriscapi.pkb 120.0 2005/07/26 15:10:47 mbocutt noship $ */
3 --
5 --
6 g_package varchar2(33) := ' IRC_SEARCH_CRITERIA_API.';
7 --
8 -- ----------------------------------------------------------------------------
9 -- |--------------------------< CREATE_SAVED_SEARCH >--------------------------|
10 -- ----------------------------------------------------------------------------
11 --
12 procedure CREATE_SAVED_SEARCH
13 (p_validate in boolean default false
14 ,p_effective_date in date
15 ,p_person_id in number
16 ,p_search_name in varchar2
17 ,p_location in varchar2 default null
18 ,p_distance_to_location in varchar2 default null
19 ,p_geocode_location in varchar2 default null
20 ,p_geocode_country in varchar2 default null
21 ,p_derived_location in varchar2 default null
22 ,p_location_id in number default null
23 ,p_longitude in number default null
24 ,p_latitude in number default null
25 ,p_employee in varchar2 default null
26 ,p_contractor in varchar2 default null
27 ,p_employment_category in varchar2 default 'EITHER'
28 ,p_keywords in varchar2 default null
29 ,p_travel_percentage in number default null
30 ,p_min_salary in number default null
31 ,p_salary_currency in varchar2 default null
32 ,p_salary_period in varchar2 default null
33 ,p_match_competence in varchar2 default 'N'
34 ,p_match_qualification in varchar2 default 'N'
35 ,p_work_at_home in varchar2 default 'POSSIBLE'
36 ,p_job_title in varchar2 default null
37 ,p_department in varchar2 default null
38 ,p_professional_area in varchar2 default null
39 ,p_use_for_matching in varchar2 default 'N'
40 ,p_description in varchar2 default null
41 ,p_attribute_category in varchar2 default null
42 ,p_attribute1 in varchar2 default null
43 ,p_attribute2 in varchar2 default null
44 ,p_attribute3 in varchar2 default null
45 ,p_attribute4 in varchar2 default null
46 ,p_attribute5 in varchar2 default null
47 ,p_attribute6 in varchar2 default null
48 ,p_attribute7 in varchar2 default null
49 ,p_attribute8 in varchar2 default null
50 ,p_attribute9 in varchar2 default null
51 ,p_attribute10 in varchar2 default null
52 ,p_attribute11 in varchar2 default null
53 ,p_attribute12 in varchar2 default null
54 ,p_attribute13 in varchar2 default null
55 ,p_attribute14 in varchar2 default null
56 ,p_attribute15 in varchar2 default null
57 ,p_attribute16 in varchar2 default null
58 ,p_attribute17 in varchar2 default null
59 ,p_attribute18 in varchar2 default null
60 ,p_attribute19 in varchar2 default null
61 ,p_attribute20 in varchar2 default null
62 ,p_attribute21 in varchar2 default null
63 ,p_attribute22 in varchar2 default null
64 ,p_attribute23 in varchar2 default null
65 ,p_attribute24 in varchar2 default null
66 ,p_attribute25 in varchar2 default null
67 ,p_attribute26 in varchar2 default null
68 ,p_attribute27 in varchar2 default null
69 ,p_attribute28 in varchar2 default null
70 ,p_attribute29 in varchar2 default null
71 ,p_attribute30 in varchar2 default null
72 ,p_isc_information_category in varchar2 default null
73 ,p_isc_information1 in varchar2 default null
74 ,p_isc_information2 in varchar2 default null
75 ,p_isc_information3 in varchar2 default null
76 ,p_isc_information4 in varchar2 default null
77 ,p_isc_information5 in varchar2 default null
78 ,p_isc_information6 in varchar2 default null
79 ,p_isc_information7 in varchar2 default null
80 ,p_isc_information8 in varchar2 default null
81 ,p_isc_information9 in varchar2 default null
82 ,p_isc_information10 in varchar2 default null
83 ,p_isc_information11 in varchar2 default null
84 ,p_isc_information12 in varchar2 default null
85 ,p_isc_information13 in varchar2 default null
86 ,p_isc_information14 in varchar2 default null
87 ,p_isc_information15 in varchar2 default null
88 ,p_isc_information16 in varchar2 default null
89 ,p_isc_information17 in varchar2 default null
90 ,p_isc_information18 in varchar2 default null
91 ,p_isc_information19 in varchar2 default null
92 ,p_isc_information20 in varchar2 default null
93 ,p_isc_information21 in varchar2 default null
94 ,p_isc_information22 in varchar2 default null
95 ,p_isc_information23 in varchar2 default null
96 ,p_isc_information24 in varchar2 default null
97 ,p_isc_information25 in varchar2 default null
98 ,p_isc_information26 in varchar2 default null
99 ,p_isc_information27 in varchar2 default null
100 ,p_isc_information28 in varchar2 default null
101 ,p_isc_information29 in varchar2 default null
102 ,p_isc_information30 in varchar2 default null
103 ,p_date_posted in varchar2 default null
104 ,p_object_version_number out nocopy number
105 ,p_search_criteria_id out nocopy number
106 ) is
107 --
108 -- Declare cursors and local variables
109 --
110
111 l_proc varchar2(72) := g_package||'CREATE_SAVED_SEARCH';
112 l_effective_date date;
113 l_object_version_number irc_search_criteria.object_version_number%TYPE;
114 l_search_criteria_id irc_search_criteria.search_criteria_id%TYPE;
115
116 begin
117 hr_utility.set_location('Entering:'|| l_proc, 10);
118 --
119 -- Issue a savepoint
120 --
121 savepoint CREATE_SAVED_SEARCH;
122 --
123 -- Truncate the time portion from all IN date parameters
124 --
125 l_effective_date := trunc(p_effective_date);
126 --
127 -- Call Before Process User Hook
128 --
129 begin
130 IRC_SEARCH_CRITERIA_BK1.CREATE_SAVED_SEARCH_B
131 (p_effective_date => l_effective_date
132 ,p_person_id => p_person_id
133 ,p_search_name => p_search_name
134 ,p_location => p_location
135 ,p_distance_to_location => p_distance_to_location
136 ,p_geocode_location => p_geocode_location
137 ,p_geocode_country => p_geocode_country
141 ,p_latitude => p_latitude
138 ,p_derived_location => p_derived_location
139 ,p_location_id => p_location_id
140 ,p_longitude => p_longitude
142 ,p_employee => p_employee
143 ,p_contractor => p_contractor
144 ,p_employment_category => p_employment_category
145 ,p_keywords => p_keywords
146 ,p_travel_percentage => p_travel_percentage
147 ,p_min_salary => p_min_salary
148 ,p_salary_currency => p_salary_currency
149 ,p_salary_period => p_salary_period
150 ,p_match_competence => p_match_competence
151 ,p_match_qualification => p_match_qualification
152 ,p_work_at_home => p_work_at_home
153 ,p_job_title => p_job_title
154 ,p_department => p_department
155 ,p_professional_area => p_professional_area
156 ,p_use_for_matching => p_use_for_matching
157 ,p_description => p_description
158 ,p_attribute_category => p_attribute_category
159 ,p_attribute1 => p_attribute1
160 ,p_attribute2 => p_attribute2
161 ,p_attribute3 => p_attribute3
162 ,p_attribute4 => p_attribute4
163 ,p_attribute5 => p_attribute5
164 ,p_attribute6 => p_attribute6
165 ,p_attribute7 => p_attribute7
166 ,p_attribute8 => p_attribute8
167 ,p_attribute9 => p_attribute9
168 ,p_attribute10 => p_attribute10
169 ,p_attribute11 => p_attribute11
170 ,p_attribute12 => p_attribute12
171 ,p_attribute13 => p_attribute13
172 ,p_attribute14 => p_attribute14
173 ,p_attribute15 => p_attribute15
174 ,p_attribute16 => p_attribute16
175 ,p_attribute17 => p_attribute17
176 ,p_attribute18 => p_attribute18
177 ,p_attribute19 => p_attribute19
178 ,p_attribute20 => p_attribute20
179 ,p_attribute21 => p_attribute21
180 ,p_attribute22 => p_attribute22
181 ,p_attribute23 => p_attribute23
182 ,p_attribute24 => p_attribute24
183 ,p_attribute25 => p_attribute25
184 ,p_attribute26 => p_attribute26
185 ,p_attribute27 => p_attribute27
186 ,p_attribute28 => p_attribute28
187 ,p_attribute29 => p_attribute29
188 ,p_attribute30 => p_attribute30
189 ,p_isc_information_category => p_isc_information_category
190 ,p_isc_information1 => p_isc_information1
191 ,p_isc_information2 => p_isc_information2
192 ,p_isc_information3 => p_isc_information3
193 ,p_isc_information4 => p_isc_information4
194 ,p_isc_information5 => p_isc_information5
195 ,p_isc_information6 => p_isc_information6
196 ,p_isc_information7 => p_isc_information7
197 ,p_isc_information8 => p_isc_information8
198 ,p_isc_information9 => p_isc_information9
199 ,p_isc_information10 => p_isc_information10
200 ,p_isc_information11 => p_isc_information11
201 ,p_isc_information12 => p_isc_information12
202 ,p_isc_information13 => p_isc_information13
203 ,p_isc_information14 => p_isc_information14
204 ,p_isc_information15 => p_isc_information15
205 ,p_isc_information16 => p_isc_information16
206 ,p_isc_information17 => p_isc_information17
207 ,p_isc_information18 => p_isc_information18
208 ,p_isc_information19 => p_isc_information19
209 ,p_isc_information20 => p_isc_information20
210 ,p_isc_information21 => p_isc_information21
211 ,p_isc_information22 => p_isc_information22
212 ,p_isc_information23 => p_isc_information23
213 ,p_isc_information24 => p_isc_information24
214 ,p_isc_information25 => p_isc_information25
215 ,p_isc_information26 => p_isc_information26
216 ,p_isc_information27 => p_isc_information27
217 ,p_isc_information28 => p_isc_information28
218 ,p_isc_information29 => p_isc_information29
219 ,p_isc_information30 => p_isc_information30
220 ,p_date_posted => p_date_posted
221 );
222 exception
223 when hr_api.cannot_find_prog_unit then
224 hr_api.cannot_find_prog_unit_error
225 (p_module_name => 'CREATE_SAVED_SEARCH'
226 ,p_hook_type => 'BP'
227 );
228 end;
229 --
230 -- Validation in addition to Row Handlers
231 --
232 -- Process Logic
233 --
234 irc_isc_ins.ins(
235 p_effective_date => l_effective_date
236 ,p_object_id => p_person_id
237 ,p_object_type => 'PERSON'
238 ,p_search_name => p_search_name
239 ,p_location => p_location
240 ,p_distance_to_location => p_distance_to_location
241 ,p_geocode_location => p_geocode_location
242 ,p_geocode_country => p_geocode_country
243 ,p_derived_location => p_derived_location
244 ,p_location_id => p_location_id
245 ,p_longitude => p_longitude
246 ,p_latitude => p_latitude
247 ,p_contractor => p_contractor
248 ,p_employee => p_employee
249 ,p_employment_category => p_employment_category
250 ,p_keywords => p_keywords
251 ,p_travel_percentage => p_travel_percentage
252 ,p_min_salary => p_min_salary
253 ,p_salary_currency => p_salary_currency
254 ,p_salary_period => p_salary_period
255 ,p_match_competence => p_match_competence
256 ,p_match_qualification => p_match_qualification
257 ,p_work_at_home => p_work_at_home
258 ,p_job_title => p_job_title
259 ,p_department => p_department
260 ,p_professional_area => p_professional_area
261 ,p_use_for_matching => p_use_for_matching
262 ,p_description => p_description
263 ,p_attribute_category => p_attribute_category
264 ,p_attribute1 => p_attribute1
265 ,p_attribute2 => p_attribute2
266 ,p_attribute3 => p_attribute3
267 ,p_attribute4 => p_attribute4
268 ,p_attribute5 => p_attribute5
269 ,p_attribute6 => p_attribute6
270 ,p_attribute7 => p_attribute7
271 ,p_attribute8 => p_attribute8
272 ,p_attribute9 => p_attribute9
273 ,p_attribute10 => p_attribute10
274 ,p_attribute11 => p_attribute11
275 ,p_attribute12 => p_attribute12
276 ,p_attribute13 => p_attribute13
277 ,p_attribute14 => p_attribute14
278 ,p_attribute15 => p_attribute15
279 ,p_attribute16 => p_attribute16
280 ,p_attribute17 => p_attribute17
281 ,p_attribute18 => p_attribute18
282 ,p_attribute19 => p_attribute19
283 ,p_attribute20 => p_attribute20
284 ,p_attribute21 => p_attribute21
285 ,p_attribute22 => p_attribute22
286 ,p_attribute23 => p_attribute23
287 ,p_attribute24 => p_attribute24
288 ,p_attribute25 => p_attribute25
289 ,p_attribute26 => p_attribute26
290 ,p_attribute27 => p_attribute27
291 ,p_attribute28 => p_attribute28
292 ,p_attribute29 => p_attribute29
293 ,p_attribute30 => p_attribute30
294 ,p_isc_information_category => p_isc_information_category
295 ,p_isc_information1 => p_isc_information1
296 ,p_isc_information2 => p_isc_information2
297 ,p_isc_information3 => p_isc_information3
298 ,p_isc_information4 => p_isc_information4
299 ,p_isc_information5 => p_isc_information5
300 ,p_isc_information6 => p_isc_information6
301 ,p_isc_information7 => p_isc_information7
302 ,p_isc_information8 => p_isc_information8
303 ,p_isc_information9 => p_isc_information9
304 ,p_isc_information10 => p_isc_information10
305 ,p_isc_information11 => p_isc_information11
306 ,p_isc_information12 => p_isc_information12
307 ,p_isc_information13 => p_isc_information13
308 ,p_isc_information14 => p_isc_information14
309 ,p_isc_information15 => p_isc_information15
310 ,p_isc_information16 => p_isc_information16
311 ,p_isc_information17 => p_isc_information17
312 ,p_isc_information18 => p_isc_information18
313 ,p_isc_information19 => p_isc_information19
314 ,p_isc_information20 => p_isc_information20
315 ,p_isc_information21 => p_isc_information21
316 ,p_isc_information22 => p_isc_information22
317 ,p_isc_information23 => p_isc_information23
318 ,p_isc_information24 => p_isc_information24
319 ,p_isc_information25 => p_isc_information25
320 ,p_isc_information26 => p_isc_information26
321 ,p_isc_information27 => p_isc_information27
322 ,p_isc_information28 => p_isc_information28
323 ,p_isc_information29 => p_isc_information29
324 ,p_isc_information30 => p_isc_information30
325 ,p_object_version_number => l_object_version_number
326 ,p_date_posted => p_date_posted
327 ,p_search_criteria_id => l_search_criteria_id
328 );
329 --
330 -- Call After Process User Hook
331 --
332 begin
333 IRC_SEARCH_CRITERIA_BK1.CREATE_SAVED_SEARCH_A
334 (p_effective_date => l_effective_date
335 ,p_person_id => p_person_id
336 ,p_search_name => p_search_name
337 ,p_location => p_location
338 ,p_distance_to_location => p_distance_to_location
339 ,p_geocode_location => p_geocode_location
340 ,p_geocode_country => p_geocode_country
341 ,p_derived_location => p_derived_location
342 ,p_location_id => p_location_id
343 ,p_longitude => p_longitude
344 ,p_latitude => p_latitude
345 ,p_contractor => p_contractor
346 ,p_employee => p_employee
347 ,p_employment_category => p_employment_category
348 ,p_keywords => p_keywords
349 ,p_travel_percentage => p_travel_percentage
350 ,p_min_salary => p_min_salary
351 ,p_salary_currency => p_salary_currency
352 ,p_salary_period => p_salary_period
353 ,p_match_competence => p_match_competence
354 ,p_match_qualification => p_match_qualification
355 ,p_work_at_home => p_work_at_home
356 ,p_job_title => p_job_title
357 ,p_department => p_department
358 ,p_professional_area => p_professional_area
359 ,p_use_for_matching => p_use_for_matching
360 ,p_description => p_description
361 ,p_attribute_category => p_attribute_category
362 ,p_attribute1 => p_attribute1
363 ,p_attribute2 => p_attribute2
364 ,p_attribute3 => p_attribute3
365 ,p_attribute4 => p_attribute4
366 ,p_attribute5 => p_attribute5
367 ,p_attribute6 => p_attribute6
368 ,p_attribute7 => p_attribute7
369 ,p_attribute8 => p_attribute8
370 ,p_attribute9 => p_attribute9
371 ,p_attribute10 => p_attribute10
372 ,p_attribute11 => p_attribute11
373 ,p_attribute12 => p_attribute12
374 ,p_attribute13 => p_attribute13
375 ,p_attribute14 => p_attribute14
376 ,p_attribute15 => p_attribute15
377 ,p_attribute16 => p_attribute16
378 ,p_attribute17 => p_attribute17
379 ,p_attribute18 => p_attribute18
380 ,p_attribute19 => p_attribute19
381 ,p_attribute20 => p_attribute20
382 ,p_attribute21 => p_attribute21
383 ,p_attribute22 => p_attribute22
384 ,p_attribute23 => p_attribute23
385 ,p_attribute24 => p_attribute24
386 ,p_attribute25 => p_attribute25
387 ,p_attribute26 => p_attribute26
388 ,p_attribute27 => p_attribute27
389 ,p_attribute28 => p_attribute28
390 ,p_attribute29 => p_attribute29
391 ,p_attribute30 => p_attribute30
392 ,p_isc_information_category => p_isc_information_category
393 ,p_isc_information1 => p_isc_information1
394 ,p_isc_information2 => p_isc_information2
395 ,p_isc_information3 => p_isc_information3
396 ,p_isc_information4 => p_isc_information4
397 ,p_isc_information5 => p_isc_information5
398 ,p_isc_information6 => p_isc_information6
399 ,p_isc_information7 => p_isc_information7
400 ,p_isc_information8 => p_isc_information8
401 ,p_isc_information9 => p_isc_information9
402 ,p_isc_information10 => p_isc_information10
403 ,p_isc_information11 => p_isc_information11
404 ,p_isc_information12 => p_isc_information12
405 ,p_isc_information13 => p_isc_information13
406 ,p_isc_information14 => p_isc_information14
407 ,p_isc_information15 => p_isc_information15
408 ,p_isc_information16 => p_isc_information16
409 ,p_isc_information17 => p_isc_information17
410 ,p_isc_information18 => p_isc_information18
411 ,p_isc_information19 => p_isc_information19
412 ,p_isc_information20 => p_isc_information20
413 ,p_isc_information21 => p_isc_information21
414 ,p_isc_information22 => p_isc_information22
415 ,p_isc_information23 => p_isc_information23
416 ,p_isc_information24 => p_isc_information24
417 ,p_isc_information25 => p_isc_information25
418 ,p_isc_information26 => p_isc_information26
419 ,p_isc_information27 => p_isc_information27
420 ,p_isc_information28 => p_isc_information28
421 ,p_isc_information29 => p_isc_information29
422 ,p_isc_information30 => p_isc_information30
423 ,p_date_posted => p_date_posted
424 ,p_object_version_number => l_object_version_number
425 ,p_search_criteria_id => l_search_criteria_id
426 );
427 exception
428 when hr_api.cannot_find_prog_unit then
429 hr_api.cannot_find_prog_unit_error
430 (p_module_name => 'CREATE_SAVED_SEARCH'
431 ,p_hook_type => 'AP'
432 );
433 end;
434 --
435 -- When in validation only mode raise the Validate_Enabled exception
436 --
437 if p_validate then
438 raise hr_api.validate_enabled;
439 end if;
440 --
441 -- Set all output arguments
442 --
443 p_search_criteria_id := l_search_criteria_id;
444 p_object_version_number := l_object_version_number;
445 --
446 hr_utility.set_location(' Leaving:'||l_proc, 70);
447 exception
448 when hr_api.validate_enabled then
449 --
450 -- As the Validate_Enabled exception has been raised
451 -- we must rollback to the savepoint
452 --
453 rollback to CREATE_SAVED_SEARCH;
454 --
455 -- Only set output warning arguments
456 -- (Any key or derived arguments must be set to null
457 -- when validation only mode is being used.)
458 --
459 p_search_criteria_id := null;
460 p_object_version_number := null;
461 hr_utility.set_location(' Leaving:'||l_proc, 80);
462 when others then
463 --
464 -- A validation or unexpected error has occured
465 --
466 p_search_criteria_id := null;
467 p_object_version_number := null;
468 rollback to CREATE_SAVED_SEARCH;
469 hr_utility.set_location(' Leaving:'||l_proc, 90);
470 raise;
471 end CREATE_SAVED_SEARCH;
472 --
473 -- ----------------------------------------------------------------------------
474 -- |--------------------------< UPDATE_SAVED_SEARCH >--------------------------|
475 -- ----------------------------------------------------------------------------
476 --
477 procedure UPDATE_SAVED_SEARCH
478 (p_validate in boolean default false
479 ,p_effective_date in date
480 ,p_search_criteria_id in number
481 ,p_person_id in number default hr_api.g_number
482 ,p_search_name in varchar2 default hr_api.g_varchar2
483 ,p_location in varchar2 default hr_api.g_varchar2
484 ,p_distance_to_location in varchar2 default hr_api.g_varchar2
485 ,p_geocode_location in varchar2 default hr_api.g_varchar2
486 ,p_geocode_country in varchar2 default hr_api.g_varchar2
487 ,p_derived_location in varchar2 default hr_api.g_varchar2
488 ,p_location_id in number default hr_api.g_number
489 ,p_longitude in number default hr_api.g_number
490 ,p_latitude in number default hr_api.g_number
491 ,p_employee in varchar2 default hr_api.g_varchar2
492 ,p_contractor in varchar2 default hr_api.g_varchar2
493 ,p_employment_category in varchar2 default hr_api.g_varchar2
494 ,p_keywords in varchar2 default hr_api.g_varchar2
495 ,p_travel_percentage in number default hr_api.g_number
496 ,p_min_salary in number default hr_api.g_number
497 ,p_salary_currency in varchar2 default hr_api.g_varchar2
498 ,p_salary_period in varchar2 default hr_api.g_varchar2
499 ,p_match_competence in varchar2 default hr_api.g_varchar2
500 ,p_match_qualification in varchar2 default hr_api.g_varchar2
501 ,p_work_at_home in varchar2 default hr_api.g_varchar2
502 ,p_job_title in varchar2 default hr_api.g_varchar2
503 ,p_department in varchar2 default hr_api.g_varchar2
504 ,p_professional_area in varchar2 default hr_api.g_varchar2
505 ,p_use_for_matching in varchar2 default hr_api.g_varchar2
506 ,p_description in varchar2 default hr_api.g_varchar2
507 ,p_attribute_category in varchar2 default hr_api.g_varchar2
508 ,p_attribute1 in varchar2 default hr_api.g_varchar2
509 ,p_attribute2 in varchar2 default hr_api.g_varchar2
510 ,p_attribute3 in varchar2 default hr_api.g_varchar2
514 ,p_attribute7 in varchar2 default hr_api.g_varchar2
511 ,p_attribute4 in varchar2 default hr_api.g_varchar2
512 ,p_attribute5 in varchar2 default hr_api.g_varchar2
513 ,p_attribute6 in varchar2 default hr_api.g_varchar2
515 ,p_attribute8 in varchar2 default hr_api.g_varchar2
516 ,p_attribute9 in varchar2 default hr_api.g_varchar2
517 ,p_attribute10 in varchar2 default hr_api.g_varchar2
518 ,p_attribute11 in varchar2 default hr_api.g_varchar2
519 ,p_attribute12 in varchar2 default hr_api.g_varchar2
520 ,p_attribute13 in varchar2 default hr_api.g_varchar2
521 ,p_attribute14 in varchar2 default hr_api.g_varchar2
522 ,p_attribute15 in varchar2 default hr_api.g_varchar2
523 ,p_attribute16 in varchar2 default hr_api.g_varchar2
524 ,p_attribute17 in varchar2 default hr_api.g_varchar2
525 ,p_attribute18 in varchar2 default hr_api.g_varchar2
526 ,p_attribute19 in varchar2 default hr_api.g_varchar2
527 ,p_attribute20 in varchar2 default hr_api.g_varchar2
528 ,p_attribute21 in varchar2 default hr_api.g_varchar2
529 ,p_attribute22 in varchar2 default hr_api.g_varchar2
530 ,p_attribute23 in varchar2 default hr_api.g_varchar2
531 ,p_attribute24 in varchar2 default hr_api.g_varchar2
532 ,p_attribute25 in varchar2 default hr_api.g_varchar2
533 ,p_attribute26 in varchar2 default hr_api.g_varchar2
534 ,p_attribute27 in varchar2 default hr_api.g_varchar2
535 ,p_attribute28 in varchar2 default hr_api.g_varchar2
536 ,p_attribute29 in varchar2 default hr_api.g_varchar2
537 ,p_attribute30 in varchar2 default hr_api.g_varchar2
538 ,p_isc_information_category in varchar2 default hr_api.g_varchar2
539 ,p_isc_information1 in varchar2 default hr_api.g_varchar2
540 ,p_isc_information2 in varchar2 default hr_api.g_varchar2
541 ,p_isc_information3 in varchar2 default hr_api.g_varchar2
542 ,p_isc_information4 in varchar2 default hr_api.g_varchar2
543 ,p_isc_information5 in varchar2 default hr_api.g_varchar2
544 ,p_isc_information6 in varchar2 default hr_api.g_varchar2
545 ,p_isc_information7 in varchar2 default hr_api.g_varchar2
546 ,p_isc_information8 in varchar2 default hr_api.g_varchar2
547 ,p_isc_information9 in varchar2 default hr_api.g_varchar2
548 ,p_isc_information10 in varchar2 default hr_api.g_varchar2
549 ,p_isc_information11 in varchar2 default hr_api.g_varchar2
550 ,p_isc_information12 in varchar2 default hr_api.g_varchar2
551 ,p_isc_information13 in varchar2 default hr_api.g_varchar2
552 ,p_isc_information14 in varchar2 default hr_api.g_varchar2
553 ,p_isc_information15 in varchar2 default hr_api.g_varchar2
554 ,p_isc_information16 in varchar2 default hr_api.g_varchar2
555 ,p_isc_information17 in varchar2 default hr_api.g_varchar2
556 ,p_isc_information18 in varchar2 default hr_api.g_varchar2
557 ,p_isc_information19 in varchar2 default hr_api.g_varchar2
558 ,p_isc_information20 in varchar2 default hr_api.g_varchar2
559 ,p_isc_information21 in varchar2 default hr_api.g_varchar2
560 ,p_isc_information22 in varchar2 default hr_api.g_varchar2
561 ,p_isc_information23 in varchar2 default hr_api.g_varchar2
562 ,p_isc_information24 in varchar2 default hr_api.g_varchar2
563 ,p_isc_information25 in varchar2 default hr_api.g_varchar2
564 ,p_isc_information26 in varchar2 default hr_api.g_varchar2
565 ,p_isc_information27 in varchar2 default hr_api.g_varchar2
566 ,p_isc_information28 in varchar2 default hr_api.g_varchar2
567 ,p_isc_information29 in varchar2 default hr_api.g_varchar2
568 ,p_isc_information30 in varchar2 default hr_api.g_varchar2
569 ,p_date_posted in varchar2 default hr_api.g_varchar2
570 ,p_object_version_number in out nocopy number
571 ) is
572 --
573 -- Declare cursors and local variables
574 --
575
576 l_proc varchar2(72) := g_package||'UPDATE_SAVED_SEARCH';
577 l_effective_date date;
578 l_object_version_number irc_search_criteria.object_version_number%TYPE
579 := p_object_version_number;
580
581 begin
582 hr_utility.set_location('Entering:'|| l_proc, 10);
583 --
584 -- Issue a savepoint
585 --
586 savepoint UPDATE_SAVED_SEARCH;
587 --
588 -- Truncate the time portion from all IN date parameters
589 --
590 l_effective_date := trunc(p_effective_date);
591 --
592 -- Call Before Process User Hook
593 --
594 begin
595 IRC_SEARCH_CRITERIA_BK2.UPDATE_SAVED_SEARCH_B
596 (p_effective_date => l_effective_date
597 ,p_search_criteria_id => p_search_criteria_id
598 ,p_person_id => p_person_id
599 ,p_search_name => p_search_name
600 ,p_location => p_location
601 ,p_distance_to_location => p_distance_to_location
602 ,p_geocode_location => p_geocode_location
603 ,p_geocode_country => p_geocode_country
604 ,p_derived_location => p_derived_location
605 ,p_location_id => p_location_id
606 ,p_longitude => p_longitude
607 ,p_latitude => p_latitude
608 ,p_contractor => p_contractor
609 ,p_employee => p_employee
610 ,p_employment_category => p_employment_category
611 ,p_keywords => p_keywords
612 ,p_travel_percentage => p_travel_percentage
613 ,p_min_salary => p_min_salary
614 ,p_salary_currency => p_salary_currency
615 ,p_salary_period => p_salary_period
616 ,p_match_competence => p_match_competence
617 ,p_match_qualification => p_match_qualification
618 ,p_work_at_home => p_work_at_home
619 ,p_job_title => p_job_title
620 ,p_department => p_department
621 ,p_professional_area => p_professional_area
622 ,p_use_for_matching => p_use_for_matching
623 ,p_description => p_description
624 ,p_attribute_category => p_attribute_category
625 ,p_attribute1 => p_attribute1
626 ,p_attribute2 => p_attribute2
627 ,p_attribute3 => p_attribute3
628 ,p_attribute4 => p_attribute4
629 ,p_attribute5 => p_attribute5
630 ,p_attribute6 => p_attribute6
631 ,p_attribute7 => p_attribute7
632 ,p_attribute8 => p_attribute8
633 ,p_attribute9 => p_attribute9
634 ,p_attribute10 => p_attribute10
635 ,p_attribute11 => p_attribute11
636 ,p_attribute12 => p_attribute12
637 ,p_attribute13 => p_attribute13
638 ,p_attribute14 => p_attribute14
639 ,p_attribute15 => p_attribute15
640 ,p_attribute16 => p_attribute16
641 ,p_attribute17 => p_attribute17
642 ,p_attribute18 => p_attribute18
643 ,p_attribute19 => p_attribute19
644 ,p_attribute20 => p_attribute20
645 ,p_attribute21 => p_attribute21
646 ,p_attribute22 => p_attribute22
647 ,p_attribute23 => p_attribute23
648 ,p_attribute24 => p_attribute24
652 ,p_attribute28 => p_attribute28
649 ,p_attribute25 => p_attribute25
650 ,p_attribute26 => p_attribute26
651 ,p_attribute27 => p_attribute27
653 ,p_attribute29 => p_attribute29
654 ,p_attribute30 => p_attribute30
655 ,p_isc_information_category => p_isc_information_category
656 ,p_isc_information1 => p_isc_information1
657 ,p_isc_information2 => p_isc_information2
658 ,p_isc_information3 => p_isc_information3
659 ,p_isc_information4 => p_isc_information4
660 ,p_isc_information5 => p_isc_information5
661 ,p_isc_information6 => p_isc_information6
662 ,p_isc_information7 => p_isc_information7
663 ,p_isc_information8 => p_isc_information8
664 ,p_isc_information9 => p_isc_information9
665 ,p_isc_information10 => p_isc_information10
666 ,p_isc_information11 => p_isc_information11
667 ,p_isc_information12 => p_isc_information12
668 ,p_isc_information13 => p_isc_information13
669 ,p_isc_information14 => p_isc_information14
670 ,p_isc_information15 => p_isc_information15
671 ,p_isc_information16 => p_isc_information16
672 ,p_isc_information17 => p_isc_information17
673 ,p_isc_information18 => p_isc_information18
674 ,p_isc_information19 => p_isc_information19
675 ,p_isc_information20 => p_isc_information20
676 ,p_isc_information21 => p_isc_information21
677 ,p_isc_information22 => p_isc_information22
678 ,p_isc_information23 => p_isc_information23
679 ,p_isc_information24 => p_isc_information24
680 ,p_isc_information25 => p_isc_information25
681 ,p_isc_information26 => p_isc_information26
682 ,p_isc_information27 => p_isc_information27
683 ,p_isc_information28 => p_isc_information28
684 ,p_isc_information29 => p_isc_information29
685 ,p_isc_information30 => p_isc_information30
686 ,p_date_posted => p_date_posted
687 ,p_object_version_number => l_object_version_number
688 );
689 exception
690 when hr_api.cannot_find_prog_unit then
691 hr_api.cannot_find_prog_unit_error
692 (p_module_name => 'UPDATE_SAVED_SEARCH'
693 ,p_hook_type => 'BP'
694 );
695 end;
696 --
697 -- Validation in addition to Row Handlers
698 --
699 -- Process Logic
700 --
701 irc_isc_upd.upd(
702 p_effective_date => l_effective_date
703 ,p_search_criteria_id => p_search_criteria_id
704 ,p_object_id => p_person_id
705 ,p_object_type => 'PERSON'
706 ,p_search_name => p_search_name
707 ,p_location => p_location
708 ,p_distance_to_location => p_distance_to_location
709 ,p_geocode_location => p_geocode_location
710 ,p_geocode_country => p_geocode_country
711 ,p_derived_location => p_derived_location
712 ,p_location_id => p_location_id
713 ,p_longitude => p_longitude
714 ,p_latitude => p_latitude
715 ,p_contractor => p_contractor
716 ,p_employee => p_employee
717 ,p_employment_category => p_employment_category
718 ,p_keywords => p_keywords
719 ,p_travel_percentage => p_travel_percentage
720 ,p_min_salary => p_min_salary
721 ,p_salary_currency => p_salary_currency
722 ,p_salary_period => p_salary_period
723 ,p_match_competence => p_match_competence
724 ,p_match_qualification => p_match_qualification
725 ,p_work_at_home => p_work_at_home
726 ,p_job_title => p_job_title
727 ,p_department => p_department
728 ,p_professional_area => p_professional_area
729 ,p_use_for_matching => p_use_for_matching
730 ,p_description => p_description
731 ,p_attribute_category => p_attribute_category
732 ,p_attribute1 => p_attribute1
733 ,p_attribute2 => p_attribute2
734 ,p_attribute3 => p_attribute3
735 ,p_attribute4 => p_attribute4
736 ,p_attribute5 => p_attribute5
737 ,p_attribute6 => p_attribute6
738 ,p_attribute7 => p_attribute7
739 ,p_attribute8 => p_attribute8
740 ,p_attribute9 => p_attribute9
741 ,p_attribute10 => p_attribute10
742 ,p_attribute11 => p_attribute11
743 ,p_attribute12 => p_attribute12
744 ,p_attribute13 => p_attribute13
745 ,p_attribute14 => p_attribute14
746 ,p_attribute15 => p_attribute15
747 ,p_attribute16 => p_attribute16
748 ,p_attribute17 => p_attribute17
749 ,p_attribute18 => p_attribute18
750 ,p_attribute19 => p_attribute19
751 ,p_attribute20 => p_attribute20
752 ,p_attribute21 => p_attribute21
753 ,p_attribute22 => p_attribute22
754 ,p_attribute23 => p_attribute23
755 ,p_attribute24 => p_attribute24
756 ,p_attribute25 => p_attribute25
757 ,p_attribute26 => p_attribute26
758 ,p_attribute27 => p_attribute27
759 ,p_attribute28 => p_attribute28
760 ,p_attribute29 => p_attribute29
761 ,p_attribute30 => p_attribute30
762 ,p_isc_information_category => p_isc_information_category
763 ,p_isc_information1 => p_isc_information1
764 ,p_isc_information2 => p_isc_information2
765 ,p_isc_information3 => p_isc_information3
766 ,p_isc_information4 => p_isc_information4
767 ,p_isc_information5 => p_isc_information5
768 ,p_isc_information6 => p_isc_information6
769 ,p_isc_information7 => p_isc_information7
770 ,p_isc_information8 => p_isc_information8
771 ,p_isc_information9 => p_isc_information9
772 ,p_isc_information10 => p_isc_information10
773 ,p_isc_information11 => p_isc_information11
774 ,p_isc_information12 => p_isc_information12
775 ,p_isc_information13 => p_isc_information13
776 ,p_isc_information14 => p_isc_information14
777 ,p_isc_information15 => p_isc_information15
778 ,p_isc_information16 => p_isc_information16
779 ,p_isc_information17 => p_isc_information17
780 ,p_isc_information18 => p_isc_information18
781 ,p_isc_information19 => p_isc_information19
782 ,p_isc_information20 => p_isc_information20
783 ,p_isc_information21 => p_isc_information21
784 ,p_isc_information22 => p_isc_information22
785 ,p_isc_information23 => p_isc_information23
786 ,p_isc_information24 => p_isc_information24
787 ,p_isc_information25 => p_isc_information25
788 ,p_isc_information26 => p_isc_information26
789 ,p_isc_information27 => p_isc_information27
790 ,p_isc_information28 => p_isc_information28
791 ,p_isc_information29 => p_isc_information29
792 ,p_isc_information30 => p_isc_information30
793 ,p_date_posted => p_date_posted
794 ,p_object_version_number => l_object_version_number
795 );
796 --
797 -- Call After Process User Hook
798 --
799 begin
800 IRC_SEARCH_CRITERIA_BK2.UPDATE_SAVED_SEARCH_A
801 (p_effective_date => l_effective_date
802 ,p_search_criteria_id => p_search_criteria_id
803 ,p_person_id => p_person_id
804 ,p_search_name => p_search_name
805 ,p_location => p_location
806 ,p_distance_to_location => p_distance_to_location
807 ,p_geocode_location => p_geocode_location
808 ,p_geocode_country => p_geocode_country
809 ,p_derived_location => p_derived_location
810 ,p_location_id => p_location_id
811 ,p_longitude => p_longitude
812 ,p_latitude => p_latitude
813 ,p_contractor => p_contractor
814 ,p_employee => p_employee
815 ,p_employment_category => p_employment_category
816 ,p_keywords => p_keywords
817 ,p_travel_percentage => p_travel_percentage
818 ,p_min_salary => p_min_salary
819 ,p_salary_currency => p_salary_currency
820 ,p_salary_period => p_salary_period
821 ,p_match_competence => p_match_competence
822 ,p_match_qualification => p_match_qualification
823 ,p_work_at_home => p_work_at_home
824 ,p_job_title => p_job_title
825 ,p_department => p_department
826 ,p_professional_area => p_professional_area
827 ,p_use_for_matching => p_use_for_matching
828 ,p_description => p_description
829 ,p_attribute_category => p_attribute_category
830 ,p_attribute1 => p_attribute1
831 ,p_attribute2 => p_attribute2
832 ,p_attribute3 => p_attribute3
833 ,p_attribute4 => p_attribute4
834 ,p_attribute5 => p_attribute5
835 ,p_attribute6 => p_attribute6
836 ,p_attribute7 => p_attribute7
837 ,p_attribute8 => p_attribute8
838 ,p_attribute9 => p_attribute9
839 ,p_attribute10 => p_attribute10
840 ,p_attribute11 => p_attribute11
841 ,p_attribute12 => p_attribute12
842 ,p_attribute13 => p_attribute13
843 ,p_attribute14 => p_attribute14
844 ,p_attribute15 => p_attribute15
845 ,p_attribute16 => p_attribute16
846 ,p_attribute17 => p_attribute17
847 ,p_attribute18 => p_attribute18
848 ,p_attribute19 => p_attribute19
849 ,p_attribute20 => p_attribute20
850 ,p_attribute21 => p_attribute21
851 ,p_attribute22 => p_attribute22
852 ,p_attribute23 => p_attribute23
853 ,p_attribute24 => p_attribute24
854 ,p_attribute25 => p_attribute25
855 ,p_attribute26 => p_attribute26
856 ,p_attribute27 => p_attribute27
857 ,p_attribute28 => p_attribute28
858 ,p_attribute29 => p_attribute29
859 ,p_attribute30 => p_attribute30
860 ,p_isc_information_category => p_isc_information_category
861 ,p_isc_information1 => p_isc_information1
862 ,p_isc_information2 => p_isc_information2
863 ,p_isc_information3 => p_isc_information3
864 ,p_isc_information4 => p_isc_information4
865 ,p_isc_information5 => p_isc_information5
866 ,p_isc_information6 => p_isc_information6
867 ,p_isc_information7 => p_isc_information7
868 ,p_isc_information8 => p_isc_information8
869 ,p_isc_information9 => p_isc_information9
870 ,p_isc_information10 => p_isc_information10
871 ,p_isc_information11 => p_isc_information11
872 ,p_isc_information12 => p_isc_information12
873 ,p_isc_information13 => p_isc_information13
874 ,p_isc_information14 => p_isc_information14
875 ,p_isc_information15 => p_isc_information15
876 ,p_isc_information16 => p_isc_information16
877 ,p_isc_information17 => p_isc_information17
878 ,p_isc_information18 => p_isc_information18
879 ,p_isc_information19 => p_isc_information19
880 ,p_isc_information20 => p_isc_information20
881 ,p_isc_information21 => p_isc_information21
882 ,p_isc_information22 => p_isc_information22
883 ,p_isc_information23 => p_isc_information23
884 ,p_isc_information24 => p_isc_information24
885 ,p_isc_information25 => p_isc_information25
886 ,p_isc_information26 => p_isc_information26
887 ,p_isc_information27 => p_isc_information27
888 ,p_isc_information28 => p_isc_information28
889 ,p_isc_information29 => p_isc_information29
890 ,p_isc_information30 => p_isc_information30
891 ,p_date_posted => p_date_posted
892 ,p_object_version_number => l_object_version_number
893 );
894 exception
895 when hr_api.cannot_find_prog_unit then
896 hr_api.cannot_find_prog_unit_error
897 (p_module_name => 'UPDATE_SAVED_SEARCH'
898 ,p_hook_type => 'AP'
899 );
900 end;
901 --
902 -- When in validation only mode raise the Validate_Enabled exception
903 --
904 if p_validate then
905 raise hr_api.validate_enabled;
906 end if;
907 --
908 -- Set all output arguments
909 --
910 p_object_version_number := l_object_version_number;
911 --
912 hr_utility.set_location(' Leaving:'||l_proc, 70);
913 exception
914 when hr_api.validate_enabled then
915 --
916 -- As the Validate_Enabled exception has been raised
917 -- we must rollback to the savepoint
918 --
919 rollback to UPDATE_SAVED_SEARCH;
920 --
921 -- Only set output warning arguments
922 -- (Any key or derived arguments must be set to null
923 -- when validation only mode is being used.)
924 --
925 --
926 -- Reset IN OUT parameters and set OUT parameters
927 --
928 p_object_version_number := l_object_version_number;
929 hr_utility.set_location(' Leaving:'||l_proc, 80);
930 when others then
931 --
932 -- A validation or unexpected error has occured
933 --
934 rollback to UPDATE_SAVED_SEARCH;
935 --
936 -- Reset IN OUT parameters and set OUT parameters
937 --
938 p_object_version_number := l_object_version_number;
939 hr_utility.set_location(' Leaving:'||l_proc, 90);
940 raise;
941 end UPDATE_SAVED_SEARCH;
942 --
943 -- ----------------------------------------------------------------------------
944 -- |--------------------------< DELETE_SAVED_SEARCH >--------------------------|
945 -- ----------------------------------------------------------------------------
946 --
947 procedure DELETE_SAVED_SEARCH
948 (p_validate in boolean default false
949 ,p_search_criteria_id in number
950 ,p_object_version_number in number
951 ) is
952 --
956 l_proc varchar2(72) := g_package||'DELETE_SAVED_SEARCH';
953 -- Declare cursors and local variables
954 --
955
957
958 begin
959 hr_utility.set_location('Entering:'|| l_proc, 10);
960 --
961 -- Issue a savepoint
962 --
963 savepoint DELETE_SAVED_SEARCH;
964 --
965 -- Truncate the time portion from all IN date parameters
966 --
967 -- Call Before Process User Hook
968 --
969 begin
970 IRC_SEARCH_CRITERIA_BK3.DELETE_SAVED_SEARCH_B
971 (p_search_criteria_id => p_search_criteria_id
972 ,p_object_version_number => p_object_version_number
973 );
974 exception
975 when hr_api.cannot_find_prog_unit then
976 hr_api.cannot_find_prog_unit_error
977 (p_module_name => 'DELETE_SAVED_SEARCH'
978 ,p_hook_type => 'BP'
979 );
980 end;
981 --
982 -- Validation in addition to Row Handlers
983 --
984 -- Process Logic
985 --
986 irc_isc_del.del(
987 p_search_criteria_id => p_search_criteria_id
988 ,p_object_version_number => p_object_version_number
989 );
990 --
991 -- Call After Process User Hook
992 --
993 begin
994 IRC_SEARCH_CRITERIA_BK3.DELETE_SAVED_SEARCH_A
995 (p_search_criteria_id => p_search_criteria_id
996 ,p_object_version_number => p_object_version_number
997 );
998 exception
999 when hr_api.cannot_find_prog_unit then
1000 hr_api.cannot_find_prog_unit_error
1001 (p_module_name => 'DELETE_SAVED_SEARCH'
1002 ,p_hook_type => 'AP'
1003 );
1004 end;
1005 --
1006 -- When in validation only mode raise the Validate_Enabled exception
1007 --
1008 if p_validate then
1009 raise hr_api.validate_enabled;
1010 end if;
1011 --
1012 -- Set all output arguments
1013 --
1014 --
1015 hr_utility.set_location(' Leaving:'||l_proc, 70);
1016 exception
1017 when hr_api.validate_enabled then
1018 --
1019 -- As the Validate_Enabled exception has been raised
1020 -- we must rollback to the savepoint
1021 --
1022 rollback to DELETE_SAVED_SEARCH;
1023 --
1024 -- Only set output warning arguments
1025 -- (Any key or derived arguments must be set to null
1026 -- when validation only mode is being used.)
1027 --
1028 hr_utility.set_location(' Leaving:'||l_proc, 80);
1029 when others then
1030 --
1031 -- A validation or unexpected error has occured
1032 --
1033 rollback to DELETE_SAVED_SEARCH;
1034 hr_utility.set_location(' Leaving:'||l_proc, 90);
1035 raise;
1036 end DELETE_SAVED_SEARCH;
1037 --
1038 -- ----------------------------------------------------------------------------
1039 -- |------------------------< CREATE_VACANCY_CRITERIA >------------------------|
1040 -- ----------------------------------------------------------------------------
1041 --
1042 procedure CREATE_VACANCY_CRITERIA
1043 (p_validate in boolean default false
1044 ,p_vacancy_id in number
1045 ,p_effective_date in date
1046 ,p_location in varchar2 default null
1047 ,p_employee in varchar2 default null
1048 ,p_contractor in varchar2 default null
1049 ,p_employment_category in varchar2 default null
1050 ,p_keywords in varchar2 default null
1051 ,p_travel_percentage in number default null
1052 ,p_min_salary in number default null
1053 ,p_max_salary in number default null
1054 ,p_salary_currency in varchar2 default null
1055 ,p_salary_period in varchar2 default null
1056 ,p_professional_area in varchar2 default null
1057 ,p_work_at_home in varchar2 default null
1058 ,p_min_qual_level in number default null
1059 ,p_max_qual_level in number default null
1060 ,p_description in varchar2 default null
1061 ,p_attribute_category in varchar2 default null
1062 ,p_attribute1 in varchar2 default null
1063 ,p_attribute2 in varchar2 default null
1064 ,p_attribute3 in varchar2 default null
1065 ,p_attribute4 in varchar2 default null
1066 ,p_attribute5 in varchar2 default null
1067 ,p_attribute6 in varchar2 default null
1068 ,p_attribute7 in varchar2 default null
1069 ,p_attribute8 in varchar2 default null
1070 ,p_attribute9 in varchar2 default null
1071 ,p_attribute10 in varchar2 default null
1072 ,p_attribute11 in varchar2 default null
1073 ,p_attribute12 in varchar2 default null
1074 ,p_attribute13 in varchar2 default null
1075 ,p_attribute14 in varchar2 default null
1076 ,p_attribute15 in varchar2 default null
1077 ,p_attribute16 in varchar2 default null
1078 ,p_attribute17 in varchar2 default null
1079 ,p_attribute18 in varchar2 default null
1080 ,p_attribute19 in varchar2 default null
1081 ,p_attribute20 in varchar2 default null
1082 ,p_attribute21 in varchar2 default null
1083 ,p_attribute22 in varchar2 default null
1084 ,p_attribute23 in varchar2 default null
1085 ,p_attribute24 in varchar2 default null
1089 ,p_attribute28 in varchar2 default null
1086 ,p_attribute25 in varchar2 default null
1087 ,p_attribute26 in varchar2 default null
1088 ,p_attribute27 in varchar2 default null
1090 ,p_attribute29 in varchar2 default null
1091 ,p_attribute30 in varchar2 default null
1092 ,p_isc_information_category in varchar2 default null
1093 ,p_isc_information1 in varchar2 default null
1094 ,p_isc_information2 in varchar2 default null
1095 ,p_isc_information3 in varchar2 default null
1096 ,p_isc_information4 in varchar2 default null
1097 ,p_isc_information5 in varchar2 default null
1098 ,p_isc_information6 in varchar2 default null
1099 ,p_isc_information7 in varchar2 default null
1100 ,p_isc_information8 in varchar2 default null
1101 ,p_isc_information9 in varchar2 default null
1102 ,p_isc_information10 in varchar2 default null
1103 ,p_isc_information11 in varchar2 default null
1104 ,p_isc_information12 in varchar2 default null
1105 ,p_isc_information13 in varchar2 default null
1106 ,p_isc_information14 in varchar2 default null
1107 ,p_isc_information15 in varchar2 default null
1108 ,p_isc_information16 in varchar2 default null
1109 ,p_isc_information17 in varchar2 default null
1110 ,p_isc_information18 in varchar2 default null
1111 ,p_isc_information19 in varchar2 default null
1112 ,p_isc_information20 in varchar2 default null
1113 ,p_isc_information21 in varchar2 default null
1114 ,p_isc_information22 in varchar2 default null
1115 ,p_isc_information23 in varchar2 default null
1116 ,p_isc_information24 in varchar2 default null
1117 ,p_isc_information25 in varchar2 default null
1118 ,p_isc_information26 in varchar2 default null
1119 ,p_isc_information27 in varchar2 default null
1120 ,p_isc_information28 in varchar2 default null
1121 ,p_isc_information29 in varchar2 default null
1122 ,p_isc_information30 in varchar2 default null
1123 ,p_object_version_number out nocopy number
1124 ,p_search_criteria_id out nocopy number
1125 ) is
1126 --
1127 -- Declare cursors and local variables
1128 --
1129
1130 l_proc varchar2(72) := g_package||'CREATE_VACANCY_CRITERIA';
1131 l_object_version_number irc_search_criteria.object_version_number%TYPE;
1132 l_search_criteria_id irc_search_criteria.search_criteria_id%TYPE;
1133 l_effective_date date;
1134 begin
1135 hr_utility.set_location('Entering:'|| l_proc, 10);
1136 --
1137 -- Issue a savepoint
1138 --
1139 savepoint CREATE_VACANCY_CRITERIA;
1140 --
1141 -- Truncate the time portion from all IN date parameters
1142 l_effective_date := trunc(p_effective_date);
1143 --
1144 --
1145 -- Call Before Process User Hook
1146 --
1147 begin
1148 IRC_SEARCH_CRITERIA_BK4.CREATE_VACANCY_CRITERIA_B
1149 (p_vacancy_id => p_vacancy_id
1150 ,p_effective_date => l_effective_date
1151 ,p_location => p_location
1152 ,p_contractor => p_contractor
1153 ,p_employee => p_employee
1154 ,p_employment_category => p_employment_category
1155 ,p_keywords => p_keywords
1156 ,p_travel_percentage => p_travel_percentage
1157 ,p_min_salary => p_min_salary
1158 ,p_max_salary => p_max_salary
1159 ,p_salary_currency => p_salary_currency
1160 ,p_salary_period => p_salary_period
1161 ,p_professional_area => p_professional_area
1162 ,p_work_at_home => p_work_at_home
1163 ,p_min_qual_level => p_min_qual_level
1164 ,p_max_qual_level => p_max_qual_level
1165 ,p_description => p_description
1166 ,p_attribute_category => p_attribute_category
1167 ,p_attribute1 => p_attribute1
1168 ,p_attribute2 => p_attribute2
1169 ,p_attribute3 => p_attribute3
1170 ,p_attribute4 => p_attribute4
1171 ,p_attribute5 => p_attribute5
1172 ,p_attribute6 => p_attribute6
1173 ,p_attribute7 => p_attribute7
1174 ,p_attribute8 => p_attribute8
1175 ,p_attribute9 => p_attribute9
1176 ,p_attribute10 => p_attribute10
1177 ,p_attribute11 => p_attribute11
1178 ,p_attribute12 => p_attribute12
1179 ,p_attribute13 => p_attribute13
1180 ,p_attribute14 => p_attribute14
1181 ,p_attribute15 => p_attribute15
1182 ,p_attribute16 => p_attribute16
1183 ,p_attribute17 => p_attribute17
1184 ,p_attribute18 => p_attribute18
1185 ,p_attribute19 => p_attribute19
1186 ,p_attribute20 => p_attribute20
1187 ,p_attribute21 => p_attribute21
1188 ,p_attribute22 => p_attribute22
1189 ,p_attribute23 => p_attribute23
1193 ,p_attribute27 => p_attribute27
1190 ,p_attribute24 => p_attribute24
1191 ,p_attribute25 => p_attribute25
1192 ,p_attribute26 => p_attribute26
1194 ,p_attribute28 => p_attribute28
1195 ,p_attribute29 => p_attribute29
1196 ,p_attribute30 => p_attribute30
1197 ,p_isc_information_category => p_isc_information_category
1198 ,p_isc_information1 => p_isc_information1
1199 ,p_isc_information2 => p_isc_information2
1200 ,p_isc_information3 => p_isc_information3
1201 ,p_isc_information4 => p_isc_information4
1202 ,p_isc_information5 => p_isc_information5
1203 ,p_isc_information6 => p_isc_information6
1204 ,p_isc_information7 => p_isc_information7
1205 ,p_isc_information8 => p_isc_information8
1206 ,p_isc_information9 => p_isc_information9
1207 ,p_isc_information10 => p_isc_information10
1208 ,p_isc_information11 => p_isc_information11
1209 ,p_isc_information12 => p_isc_information12
1210 ,p_isc_information13 => p_isc_information13
1211 ,p_isc_information14 => p_isc_information14
1212 ,p_isc_information15 => p_isc_information15
1213 ,p_isc_information16 => p_isc_information16
1214 ,p_isc_information17 => p_isc_information17
1215 ,p_isc_information18 => p_isc_information18
1216 ,p_isc_information19 => p_isc_information19
1217 ,p_isc_information20 => p_isc_information20
1218 ,p_isc_information21 => p_isc_information21
1219 ,p_isc_information22 => p_isc_information22
1220 ,p_isc_information23 => p_isc_information23
1221 ,p_isc_information24 => p_isc_information24
1222 ,p_isc_information25 => p_isc_information25
1223 ,p_isc_information26 => p_isc_information26
1224 ,p_isc_information27 => p_isc_information27
1225 ,p_isc_information28 => p_isc_information28
1226 ,p_isc_information29 => p_isc_information29
1227 ,p_isc_information30 => p_isc_information30
1228 );
1229 exception
1230 when hr_api.cannot_find_prog_unit then
1231 hr_api.cannot_find_prog_unit_error
1232 (p_module_name => 'CREATE_VACANCY_CRITERIA'
1233 ,p_hook_type => 'BP'
1234 );
1235 end;
1236 --
1237 -- Validation in addition to Row Handlers
1238 --
1239 -- Process Logic
1240 --
1241 irc_isc_ins.ins(
1242 p_effective_date => l_effective_date
1243 ,p_object_id => p_vacancy_id
1244 ,p_object_type => 'VACANCY'
1245 ,p_location => p_location
1246 ,p_contractor => p_contractor
1247 ,p_employee => p_employee
1248 ,p_employment_category => p_employment_category
1249 ,p_keywords => p_keywords
1250 ,p_travel_percentage => p_travel_percentage
1251 ,p_min_salary => p_min_salary
1252 ,p_max_salary => p_max_salary
1253 ,p_salary_currency => p_salary_currency
1254 ,p_salary_period => p_salary_period
1255 ,p_professional_area => p_professional_area
1256 ,p_work_at_home => p_work_at_home
1257 ,p_min_qual_level => p_min_qual_level
1258 ,p_max_qual_level => p_max_qual_level
1259 ,p_description => p_description
1260 ,p_attribute_category => p_attribute_category
1261 ,p_attribute1 => p_attribute1
1262 ,p_attribute2 => p_attribute2
1263 ,p_attribute3 => p_attribute3
1264 ,p_attribute4 => p_attribute4
1265 ,p_attribute5 => p_attribute5
1266 ,p_attribute6 => p_attribute6
1267 ,p_attribute7 => p_attribute7
1268 ,p_attribute8 => p_attribute8
1269 ,p_attribute9 => p_attribute9
1270 ,p_attribute10 => p_attribute10
1271 ,p_attribute11 => p_attribute11
1272 ,p_attribute12 => p_attribute12
1273 ,p_attribute13 => p_attribute13
1274 ,p_attribute14 => p_attribute14
1275 ,p_attribute15 => p_attribute15
1276 ,p_attribute16 => p_attribute16
1277 ,p_attribute17 => p_attribute17
1278 ,p_attribute18 => p_attribute18
1279 ,p_attribute19 => p_attribute19
1280 ,p_attribute20 => p_attribute20
1281 ,p_attribute21 => p_attribute21
1282 ,p_attribute22 => p_attribute22
1283 ,p_attribute23 => p_attribute23
1284 ,p_attribute24 => p_attribute24
1285 ,p_attribute25 => p_attribute25
1286 ,p_attribute26 => p_attribute26
1287 ,p_attribute27 => p_attribute27
1288 ,p_attribute28 => p_attribute28
1289 ,p_attribute29 => p_attribute29
1290 ,p_attribute30 => p_attribute30
1291 ,p_isc_information_category => p_isc_information_category
1292 ,p_isc_information1 => p_isc_information1
1293 ,p_isc_information2 => p_isc_information2
1294 ,p_isc_information3 => p_isc_information3
1295 ,p_isc_information4 => p_isc_information4
1296 ,p_isc_information5 => p_isc_information5
1300 ,p_isc_information9 => p_isc_information9
1297 ,p_isc_information6 => p_isc_information6
1298 ,p_isc_information7 => p_isc_information7
1299 ,p_isc_information8 => p_isc_information8
1301 ,p_isc_information10 => p_isc_information10
1302 ,p_isc_information11 => p_isc_information11
1303 ,p_isc_information12 => p_isc_information12
1304 ,p_isc_information13 => p_isc_information13
1305 ,p_isc_information14 => p_isc_information14
1306 ,p_isc_information15 => p_isc_information15
1307 ,p_isc_information16 => p_isc_information16
1308 ,p_isc_information17 => p_isc_information17
1309 ,p_isc_information18 => p_isc_information18
1310 ,p_isc_information19 => p_isc_information19
1311 ,p_isc_information20 => p_isc_information20
1312 ,p_isc_information21 => p_isc_information21
1313 ,p_isc_information22 => p_isc_information22
1314 ,p_isc_information23 => p_isc_information23
1315 ,p_isc_information24 => p_isc_information24
1316 ,p_isc_information25 => p_isc_information25
1317 ,p_isc_information26 => p_isc_information26
1318 ,p_isc_information27 => p_isc_information27
1319 ,p_isc_information28 => p_isc_information28
1320 ,p_isc_information29 => p_isc_information29
1321 ,p_isc_information30 => p_isc_information30
1322 ,p_object_version_number => l_object_version_number
1323 ,p_search_criteria_id => l_search_criteria_id
1324 );
1325 --
1326 -- Call After Process User Hook
1327 --
1328 begin
1329 IRC_SEARCH_CRITERIA_BK4.CREATE_VACANCY_CRITERIA_A
1330 (p_vacancy_id => p_vacancy_id
1331 ,p_effective_date => l_effective_date
1332 ,p_location => p_location
1333 ,p_contractor => p_contractor
1334 ,p_employee => p_employee
1335 ,p_employment_category => p_employment_category
1336 ,p_keywords => p_keywords
1337 ,p_travel_percentage => p_travel_percentage
1338 ,p_min_salary => p_min_salary
1339 ,p_max_salary => p_max_salary
1340 ,p_salary_currency => p_salary_currency
1341 ,p_salary_period => p_salary_period
1342 ,p_professional_area => p_professional_area
1343 ,p_work_at_home => p_work_at_home
1344 ,p_min_qual_level => p_min_qual_level
1345 ,p_max_qual_level => p_max_qual_level
1346 ,p_description => p_description
1347 ,p_attribute_category => p_attribute_category
1348 ,p_attribute1 => p_attribute1
1349 ,p_attribute2 => p_attribute2
1350 ,p_attribute3 => p_attribute3
1351 ,p_attribute4 => p_attribute4
1352 ,p_attribute5 => p_attribute5
1353 ,p_attribute6 => p_attribute6
1354 ,p_attribute7 => p_attribute7
1355 ,p_attribute8 => p_attribute8
1356 ,p_attribute9 => p_attribute9
1357 ,p_attribute10 => p_attribute10
1358 ,p_attribute11 => p_attribute11
1359 ,p_attribute12 => p_attribute12
1360 ,p_attribute13 => p_attribute13
1361 ,p_attribute14 => p_attribute14
1362 ,p_attribute15 => p_attribute15
1363 ,p_attribute16 => p_attribute16
1364 ,p_attribute17 => p_attribute17
1365 ,p_attribute18 => p_attribute18
1366 ,p_attribute19 => p_attribute19
1367 ,p_attribute20 => p_attribute20
1368 ,p_attribute21 => p_attribute21
1369 ,p_attribute22 => p_attribute22
1370 ,p_attribute23 => p_attribute23
1371 ,p_attribute24 => p_attribute24
1372 ,p_attribute25 => p_attribute25
1373 ,p_attribute26 => p_attribute26
1374 ,p_attribute27 => p_attribute27
1375 ,p_attribute28 => p_attribute28
1376 ,p_attribute29 => p_attribute29
1377 ,p_attribute30 => p_attribute30
1378 ,p_isc_information_category => p_isc_information_category
1379 ,p_isc_information1 => p_isc_information1
1380 ,p_isc_information2 => p_isc_information2
1381 ,p_isc_information3 => p_isc_information3
1382 ,p_isc_information4 => p_isc_information4
1383 ,p_isc_information5 => p_isc_information5
1384 ,p_isc_information6 => p_isc_information6
1385 ,p_isc_information7 => p_isc_information7
1386 ,p_isc_information8 => p_isc_information8
1387 ,p_isc_information9 => p_isc_information9
1388 ,p_isc_information10 => p_isc_information10
1389 ,p_isc_information11 => p_isc_information11
1390 ,p_isc_information12 => p_isc_information12
1391 ,p_isc_information13 => p_isc_information13
1392 ,p_isc_information14 => p_isc_information14
1393 ,p_isc_information15 => p_isc_information15
1394 ,p_isc_information16 => p_isc_information16
1395 ,p_isc_information17 => p_isc_information17
1396 ,p_isc_information18 => p_isc_information18
1400 ,p_isc_information22 => p_isc_information22
1397 ,p_isc_information19 => p_isc_information19
1398 ,p_isc_information20 => p_isc_information20
1399 ,p_isc_information21 => p_isc_information21
1401 ,p_isc_information23 => p_isc_information23
1402 ,p_isc_information24 => p_isc_information24
1403 ,p_isc_information25 => p_isc_information25
1404 ,p_isc_information26 => p_isc_information26
1405 ,p_isc_information27 => p_isc_information27
1406 ,p_isc_information28 => p_isc_information28
1407 ,p_isc_information29 => p_isc_information29
1408 ,p_isc_information30 => p_isc_information30
1409 ,p_object_version_number => l_object_version_number
1410 ,p_search_criteria_id => l_search_criteria_id
1411 );
1412 exception
1413 when hr_api.cannot_find_prog_unit then
1414 hr_api.cannot_find_prog_unit_error
1415 (p_module_name => 'CREATE_VACANCY_CRITERIA'
1416 ,p_hook_type => 'AP'
1417 );
1418 end;
1419 --
1420 -- When in validation only mode raise the Validate_Enabled exception
1421 --
1422 if p_validate then
1423 raise hr_api.validate_enabled;
1424 end if;
1425 --
1426 -- Set all output arguments
1427 --
1428 p_search_criteria_id := l_search_criteria_id;
1429 p_object_version_number := l_object_version_number;
1430 --
1431 hr_utility.set_location(' Leaving:'||l_proc, 70);
1432 exception
1433 when hr_api.validate_enabled then
1434 --
1435 -- As the Validate_Enabled exception has been raised
1436 -- we must rollback to the savepoint
1437 --
1438 rollback to CREATE_VACANCY_CRITERIA;
1439 --
1440 -- Only set output warning arguments
1441 -- (Any key or derived arguments must be set to null
1442 -- when validation only mode is being used.)
1443 --
1444 p_search_criteria_id := null;
1445 p_object_version_number := null;
1446 hr_utility.set_location(' Leaving:'||l_proc, 80);
1447 when others then
1448 --
1449 -- A validation or unexpected error has occured
1450 --
1451 p_search_criteria_id := null;
1452 p_object_version_number := null;
1453 rollback to CREATE_VACANCY_CRITERIA;
1454 hr_utility.set_location(' Leaving:'||l_proc, 90);
1455 raise;
1456 end CREATE_VACANCY_CRITERIA;
1457 --
1458 -- ----------------------------------------------------------------------------
1459 -- |------------------------< UPDATE_VACANCY_CRITERIA >------------------------|
1460 -- ----------------------------------------------------------------------------
1461 --
1462 procedure UPDATE_VACANCY_CRITERIA
1463 (p_validate in boolean default false
1464 ,p_search_criteria_id in number
1465 ,p_vacancy_id in number default hr_api.g_number
1466 ,p_effective_date in date
1467 ,p_location in varchar2 default hr_api.g_varchar2
1468 ,p_employee in varchar2 default hr_api.g_varchar2
1469 ,p_contractor in varchar2 default hr_api.g_varchar2
1470 ,p_employment_category in varchar2 default hr_api.g_varchar2
1471 ,p_keywords in varchar2 default hr_api.g_varchar2
1472 ,p_travel_percentage in number default hr_api.g_number
1473 ,p_min_salary in number default hr_api.g_number
1474 ,p_max_salary in number default hr_api.g_number
1475 ,p_salary_currency in varchar2 default hr_api.g_varchar2
1476 ,p_salary_period in varchar2 default hr_api.g_varchar2
1477 ,p_professional_area in varchar2 default hr_api.g_varchar2
1478 ,p_work_at_home in varchar2 default hr_api.g_varchar2
1479 ,p_min_qual_level in number default hr_api.g_number
1480 ,p_max_qual_level in number default hr_api.g_number
1481 ,p_description in varchar2 default hr_api.g_varchar2
1482 ,p_attribute_category in varchar2 default hr_api.g_varchar2
1483 ,p_attribute1 in varchar2 default hr_api.g_varchar2
1484 ,p_attribute2 in varchar2 default hr_api.g_varchar2
1485 ,p_attribute3 in varchar2 default hr_api.g_varchar2
1486 ,p_attribute4 in varchar2 default hr_api.g_varchar2
1487 ,p_attribute5 in varchar2 default hr_api.g_varchar2
1488 ,p_attribute6 in varchar2 default hr_api.g_varchar2
1489 ,p_attribute7 in varchar2 default hr_api.g_varchar2
1490 ,p_attribute8 in varchar2 default hr_api.g_varchar2
1491 ,p_attribute9 in varchar2 default hr_api.g_varchar2
1492 ,p_attribute10 in varchar2 default hr_api.g_varchar2
1493 ,p_attribute11 in varchar2 default hr_api.g_varchar2
1494 ,p_attribute12 in varchar2 default hr_api.g_varchar2
1495 ,p_attribute13 in varchar2 default hr_api.g_varchar2
1496 ,p_attribute14 in varchar2 default hr_api.g_varchar2
1497 ,p_attribute15 in varchar2 default hr_api.g_varchar2
1498 ,p_attribute16 in varchar2 default hr_api.g_varchar2
1499 ,p_attribute17 in varchar2 default hr_api.g_varchar2
1500 ,p_attribute18 in varchar2 default hr_api.g_varchar2
1501 ,p_attribute19 in varchar2 default hr_api.g_varchar2
1502 ,p_attribute20 in varchar2 default hr_api.g_varchar2
1503 ,p_attribute21 in varchar2 default hr_api.g_varchar2
1504 ,p_attribute22 in varchar2 default hr_api.g_varchar2
1505 ,p_attribute23 in varchar2 default hr_api.g_varchar2
1506 ,p_attribute24 in varchar2 default hr_api.g_varchar2
1507 ,p_attribute25 in varchar2 default hr_api.g_varchar2
1508 ,p_attribute26 in varchar2 default hr_api.g_varchar2
1509 ,p_attribute27 in varchar2 default hr_api.g_varchar2
1510 ,p_attribute28 in varchar2 default hr_api.g_varchar2
1511 ,p_attribute29 in varchar2 default hr_api.g_varchar2
1512 ,p_attribute30 in varchar2 default hr_api.g_varchar2
1513 ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1514 ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1515 ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1516 ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1517 ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1518 ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1519 ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1520 ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1521 ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1522 ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1523 ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1524 ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1525 ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1526 ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1527 ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1528 ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1529 ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1530 ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1531 ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1532 ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1533 ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1534 ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1535 ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1536 ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1537 ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1538 ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1539 ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1540 ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1541 ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1542 ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1543 ,p_isc_information30 in varchar2 default hr_api.g_varchar2
1544 ,p_object_version_number in out nocopy number
1545 ) is
1546 --
1547 -- Declare cursors and local variables
1548 --
1549
1550 l_proc varchar2(72) := g_package||'UPDATE_VACANCY_CRITERIA';
1551 l_object_version_number irc_search_criteria.object_version_number%TYPE
1552 := p_object_version_number;
1553 l_effective_date date;
1554
1555 begin
1556 hr_utility.set_location('Entering:'|| l_proc, 10);
1557 --
1558 -- Issue a savepoint
1559 --
1560 savepoint UPDATE_VACANCY_CRITERIA;
1561 --
1562 -- Truncate the time portion from all IN date parameters
1563 --
1564 l_effective_date := trunc(p_effective_date);
1565 --
1566 -- Call Before Process User Hook
1567 --
1568 begin
1569 IRC_SEARCH_CRITERIA_BK5.UPDATE_VACANCY_CRITERIA_B
1570 (p_vacancy_id => p_vacancy_id
1571 ,p_search_criteria_id => p_search_criteria_id
1572 ,p_effective_date => l_effective_date
1573 ,p_location => p_location
1574 ,p_contractor => p_contractor
1575 ,p_employee => p_employee
1576 ,p_employment_category => p_employment_category
1577 ,p_keywords => p_keywords
1578 ,p_travel_percentage => p_travel_percentage
1579 ,p_min_salary => p_min_salary
1580 ,p_max_salary => p_max_salary
1581 ,p_salary_currency => p_salary_currency
1582 ,p_salary_period => p_salary_period
1583 ,p_professional_area => p_professional_area
1584 ,p_work_at_home => p_work_at_home
1585 ,p_min_qual_level => p_min_qual_level
1586 ,p_max_qual_level => p_max_qual_level
1587 ,p_description => p_description
1588 ,p_attribute_category => p_attribute_category
1589 ,p_attribute1 => p_attribute1
1590 ,p_attribute2 => p_attribute2
1591 ,p_attribute3 => p_attribute3
1592 ,p_attribute4 => p_attribute4
1593 ,p_attribute5 => p_attribute5
1594 ,p_attribute6 => p_attribute6
1595 ,p_attribute7 => p_attribute7
1596 ,p_attribute8 => p_attribute8
1597 ,p_attribute9 => p_attribute9
1598 ,p_attribute10 => p_attribute10
1599 ,p_attribute11 => p_attribute11
1600 ,p_attribute12 => p_attribute12
1601 ,p_attribute13 => p_attribute13
1602 ,p_attribute14 => p_attribute14
1603 ,p_attribute15 => p_attribute15
1604 ,p_attribute16 => p_attribute16
1605 ,p_attribute17 => p_attribute17
1606 ,p_attribute18 => p_attribute18
1607 ,p_attribute19 => p_attribute19
1608 ,p_attribute20 => p_attribute20
1609 ,p_attribute21 => p_attribute21
1610 ,p_attribute22 => p_attribute22
1611 ,p_attribute23 => p_attribute23
1612 ,p_attribute24 => p_attribute24
1613 ,p_attribute25 => p_attribute25
1614 ,p_attribute26 => p_attribute26
1615 ,p_attribute27 => p_attribute27
1616 ,p_attribute28 => p_attribute28
1617 ,p_attribute29 => p_attribute29
1618 ,p_attribute30 => p_attribute30
1619 ,p_isc_information_category => p_isc_information_category
1620 ,p_isc_information1 => p_isc_information1
1621 ,p_isc_information2 => p_isc_information2
1622 ,p_isc_information3 => p_isc_information3
1623 ,p_isc_information4 => p_isc_information4
1624 ,p_isc_information5 => p_isc_information5
1625 ,p_isc_information6 => p_isc_information6
1626 ,p_isc_information7 => p_isc_information7
1627 ,p_isc_information8 => p_isc_information8
1628 ,p_isc_information9 => p_isc_information9
1629 ,p_isc_information10 => p_isc_information10
1630 ,p_isc_information11 => p_isc_information11
1631 ,p_isc_information12 => p_isc_information12
1632 ,p_isc_information13 => p_isc_information13
1633 ,p_isc_information14 => p_isc_information14
1634 ,p_isc_information15 => p_isc_information15
1635 ,p_isc_information16 => p_isc_information16
1636 ,p_isc_information17 => p_isc_information17
1637 ,p_isc_information18 => p_isc_information18
1638 ,p_isc_information19 => p_isc_information19
1639 ,p_isc_information20 => p_isc_information20
1640 ,p_isc_information21 => p_isc_information21
1641 ,p_isc_information22 => p_isc_information22
1642 ,p_isc_information23 => p_isc_information23
1643 ,p_isc_information24 => p_isc_information24
1644 ,p_isc_information25 => p_isc_information25
1645 ,p_isc_information26 => p_isc_information26
1646 ,p_isc_information27 => p_isc_information27
1647 ,p_isc_information28 => p_isc_information28
1648 ,p_isc_information29 => p_isc_information29
1649 ,p_isc_information30 => p_isc_information30
1650 ,p_object_version_number => l_object_version_number
1651 );
1652 exception
1653 when hr_api.cannot_find_prog_unit then
1654 hr_api.cannot_find_prog_unit_error
1655 (p_module_name => 'UPDATE_VACANCY_CRITERIA'
1656 ,p_hook_type => 'BP'
1657 );
1658 end;
1659 --
1660 -- Validation in addition to Row Handlers
1661 --
1662 -- Process Logic
1663 --
1664 irc_isc_upd.upd(
1665 p_effective_date => l_effective_date
1666 ,p_search_criteria_id => p_search_criteria_id
1667 ,p_object_id => p_vacancy_id
1668 ,p_object_type => 'VACANCY'
1669 ,p_location => p_location
1670 ,p_contractor => p_contractor
1674 ,p_travel_percentage => p_travel_percentage
1671 ,p_employee => p_employee
1672 ,p_employment_category => p_employment_category
1673 ,p_keywords => p_keywords
1675 ,p_min_salary => p_min_salary
1676 ,p_max_salary => p_max_salary
1677 ,p_salary_currency => p_salary_currency
1678 ,p_salary_period => p_salary_period
1679 ,p_professional_area => p_professional_area
1680 ,p_work_at_home => p_work_at_home
1681 ,p_min_qual_level => p_min_qual_level
1682 ,p_max_qual_level => p_max_qual_level
1683 ,p_description => p_description
1684 ,p_attribute_category => p_attribute_category
1685 ,p_attribute1 => p_attribute1
1686 ,p_attribute2 => p_attribute2
1687 ,p_attribute3 => p_attribute3
1688 ,p_attribute4 => p_attribute4
1689 ,p_attribute5 => p_attribute5
1690 ,p_attribute6 => p_attribute6
1691 ,p_attribute7 => p_attribute7
1692 ,p_attribute8 => p_attribute8
1693 ,p_attribute9 => p_attribute9
1694 ,p_attribute10 => p_attribute10
1695 ,p_attribute11 => p_attribute11
1696 ,p_attribute12 => p_attribute12
1697 ,p_attribute13 => p_attribute13
1698 ,p_attribute14 => p_attribute14
1699 ,p_attribute15 => p_attribute15
1700 ,p_attribute16 => p_attribute16
1701 ,p_attribute17 => p_attribute17
1702 ,p_attribute18 => p_attribute18
1703 ,p_attribute19 => p_attribute19
1704 ,p_attribute20 => p_attribute20
1705 ,p_attribute21 => p_attribute21
1706 ,p_attribute22 => p_attribute22
1707 ,p_attribute23 => p_attribute23
1708 ,p_attribute24 => p_attribute24
1709 ,p_attribute25 => p_attribute25
1710 ,p_attribute26 => p_attribute26
1711 ,p_attribute27 => p_attribute27
1712 ,p_attribute28 => p_attribute28
1713 ,p_attribute29 => p_attribute29
1714 ,p_attribute30 => p_attribute30
1715 ,p_isc_information_category => p_isc_information_category
1716 ,p_isc_information1 => p_isc_information1
1717 ,p_isc_information2 => p_isc_information2
1718 ,p_isc_information3 => p_isc_information3
1719 ,p_isc_information4 => p_isc_information4
1720 ,p_isc_information5 => p_isc_information5
1721 ,p_isc_information6 => p_isc_information6
1722 ,p_isc_information7 => p_isc_information7
1723 ,p_isc_information8 => p_isc_information8
1724 ,p_isc_information9 => p_isc_information9
1725 ,p_isc_information10 => p_isc_information10
1726 ,p_isc_information11 => p_isc_information11
1727 ,p_isc_information12 => p_isc_information12
1728 ,p_isc_information13 => p_isc_information13
1729 ,p_isc_information14 => p_isc_information14
1730 ,p_isc_information15 => p_isc_information15
1731 ,p_isc_information16 => p_isc_information16
1732 ,p_isc_information17 => p_isc_information17
1733 ,p_isc_information18 => p_isc_information18
1734 ,p_isc_information19 => p_isc_information19
1735 ,p_isc_information20 => p_isc_information20
1736 ,p_isc_information21 => p_isc_information21
1737 ,p_isc_information22 => p_isc_information22
1738 ,p_isc_information23 => p_isc_information23
1739 ,p_isc_information24 => p_isc_information24
1740 ,p_isc_information25 => p_isc_information25
1741 ,p_isc_information26 => p_isc_information26
1742 ,p_isc_information27 => p_isc_information27
1743 ,p_isc_information28 => p_isc_information28
1744 ,p_isc_information29 => p_isc_information29
1745 ,p_isc_information30 => p_isc_information30
1746 ,p_object_version_number => l_object_version_number
1747 );
1748 --
1749 -- Call After Process User Hook
1750 --
1751 begin
1752 IRC_SEARCH_CRITERIA_BK5.UPDATE_VACANCY_CRITERIA_A
1753 (p_vacancy_id => p_vacancy_id
1754 ,p_search_criteria_id => p_search_criteria_id
1755 ,p_effective_date => l_effective_date
1756 ,p_location => p_location
1757 ,p_contractor => p_contractor
1758 ,p_employee => p_employee
1759 ,p_employment_category => p_employment_category
1760 ,p_keywords => p_keywords
1761 ,p_travel_percentage => p_travel_percentage
1762 ,p_min_salary => p_min_salary
1763 ,p_max_salary => p_max_salary
1764 ,p_salary_currency => p_salary_currency
1765 ,p_salary_period => p_salary_period
1766 ,p_professional_area => p_professional_area
1767 ,p_work_at_home => p_work_at_home
1768 ,p_min_qual_level => p_min_qual_level
1769 ,p_max_qual_level => p_max_qual_level
1770 ,p_description => p_description
1771 ,p_attribute_category => p_attribute_category
1772 ,p_attribute1 => p_attribute1
1773 ,p_attribute2 => p_attribute2
1774 ,p_attribute3 => p_attribute3
1778 ,p_attribute7 => p_attribute7
1775 ,p_attribute4 => p_attribute4
1776 ,p_attribute5 => p_attribute5
1777 ,p_attribute6 => p_attribute6
1779 ,p_attribute8 => p_attribute8
1780 ,p_attribute9 => p_attribute9
1781 ,p_attribute10 => p_attribute10
1782 ,p_attribute11 => p_attribute11
1783 ,p_attribute12 => p_attribute12
1784 ,p_attribute13 => p_attribute13
1785 ,p_attribute14 => p_attribute14
1786 ,p_attribute15 => p_attribute15
1787 ,p_attribute16 => p_attribute16
1788 ,p_attribute17 => p_attribute17
1789 ,p_attribute18 => p_attribute18
1790 ,p_attribute19 => p_attribute19
1791 ,p_attribute20 => p_attribute20
1792 ,p_attribute21 => p_attribute21
1793 ,p_attribute22 => p_attribute22
1794 ,p_attribute23 => p_attribute23
1795 ,p_attribute24 => p_attribute24
1796 ,p_attribute25 => p_attribute25
1797 ,p_attribute26 => p_attribute26
1798 ,p_attribute27 => p_attribute27
1799 ,p_attribute28 => p_attribute28
1800 ,p_attribute29 => p_attribute29
1801 ,p_attribute30 => p_attribute30
1802 ,p_isc_information_category => p_isc_information_category
1803 ,p_isc_information1 => p_isc_information1
1804 ,p_isc_information2 => p_isc_information2
1805 ,p_isc_information3 => p_isc_information3
1806 ,p_isc_information4 => p_isc_information4
1807 ,p_isc_information5 => p_isc_information5
1808 ,p_isc_information6 => p_isc_information6
1809 ,p_isc_information7 => p_isc_information7
1810 ,p_isc_information8 => p_isc_information8
1811 ,p_isc_information9 => p_isc_information9
1812 ,p_isc_information10 => p_isc_information10
1813 ,p_isc_information11 => p_isc_information11
1814 ,p_isc_information12 => p_isc_information12
1815 ,p_isc_information13 => p_isc_information13
1816 ,p_isc_information14 => p_isc_information14
1817 ,p_isc_information15 => p_isc_information15
1818 ,p_isc_information16 => p_isc_information16
1819 ,p_isc_information17 => p_isc_information17
1820 ,p_isc_information18 => p_isc_information18
1821 ,p_isc_information19 => p_isc_information19
1822 ,p_isc_information20 => p_isc_information20
1823 ,p_isc_information21 => p_isc_information21
1824 ,p_isc_information22 => p_isc_information22
1825 ,p_isc_information23 => p_isc_information23
1826 ,p_isc_information24 => p_isc_information24
1827 ,p_isc_information25 => p_isc_information25
1828 ,p_isc_information26 => p_isc_information26
1829 ,p_isc_information27 => p_isc_information27
1830 ,p_isc_information28 => p_isc_information28
1831 ,p_isc_information29 => p_isc_information29
1832 ,p_isc_information30 => p_isc_information30
1833 ,p_object_version_number => l_object_version_number
1834 );
1835 exception
1836 when hr_api.cannot_find_prog_unit then
1837 hr_api.cannot_find_prog_unit_error
1838 (p_module_name => 'UPDATE_VACANCY_CRITERIA'
1839 ,p_hook_type => 'AP'
1840 );
1841 end;
1842 --
1843 -- When in validation only mode raise the Validate_Enabled exception
1844 --
1845 if p_validate then
1846 raise hr_api.validate_enabled;
1847 end if;
1848 --
1849 -- Set all output arguments
1850 --
1851 p_object_version_number := l_object_version_number;
1852 --
1853 hr_utility.set_location(' Leaving:'||l_proc, 70);
1854 exception
1855 when hr_api.validate_enabled then
1856 --
1857 -- As the Validate_Enabled exception has been raised
1858 -- we must rollback to the savepoint
1859 --
1860 rollback to UPDATE_VACANCY_CRITERIA;
1861 --
1862 -- Only set output warning arguments
1863 -- (Any key or derived arguments must be set to null
1864 -- when validation only mode is being used.)
1865 --
1866 --
1867 -- Reset IN OUT parameters and set OUT parameters
1868 --
1869 p_object_version_number := l_object_version_number;
1870 hr_utility.set_location(' Leaving:'||l_proc, 80);
1871 when others then
1872 --
1873 -- A validation or unexpected error has occured
1874 --
1875 rollback to UPDATE_VACANCY_CRITERIA;
1876 --
1877 -- Reset IN OUT parameters and set OUT parameters
1878 --
1879 p_object_version_number := l_object_version_number;
1880 hr_utility.set_location(' Leaving:'||l_proc, 90);
1881 raise;
1882 end UPDATE_VACANCY_CRITERIA;
1883 --
1884 -- ----------------------------------------------------------------------------
1885 -- |-----------------------< DELETE_VACANCY_CRITERIA >------------------------|
1886 -- ----------------------------------------------------------------------------
1887 --
1888 procedure DELETE_VACANCY_CRITERIA
1889 (p_validate in boolean default false
1890 ,p_search_criteria_id in number
1891 ,p_object_version_number in number
1892 ) is
1893 --
1894 -- Declare cursors and local variables
1895 --
1896
1897 l_proc varchar2(72) := g_package||'DELETE_VACANCY_CRITERIA';
1898
1899 begin
1900 hr_utility.set_location('Entering:'|| l_proc, 10);
1901 --
1902 -- Issue a savepoint
1903 --
1904 savepoint DELETE_VACANCY_CRITERIA;
1905 --
1906 -- Truncate the time portion from all IN date parameters
1907 --
1908 -- Call Before Process User Hook
1909 --
1910 begin
1911 IRC_SEARCH_CRITERIA_BK6.DELETE_VACANCY_CRITERIA_B
1912 (p_search_criteria_id => p_search_criteria_id
1913 ,p_object_version_number => p_object_version_number
1914 );
1915 exception
1916 when hr_api.cannot_find_prog_unit then
1917 hr_api.cannot_find_prog_unit_error
1918 (p_module_name => 'DELETE_VACANCY_CRITERIA'
1919 ,p_hook_type => 'BP'
1920 );
1921 end;
1922 --
1923 -- Validation in addition to Row Handlers
1924 --
1925 -- Process Logic
1926 --
1927 irc_isc_del.del(
1928 p_search_criteria_id => p_search_criteria_id
1929 ,p_object_version_number => p_object_version_number
1930 );
1931 --
1932 -- Call After Process User Hook
1933 --
1934 begin
1935 IRC_SEARCH_CRITERIA_BK6.DELETE_VACANCY_CRITERIA_A
1936 (p_search_criteria_id => p_search_criteria_id
1937 ,p_object_version_number => p_object_version_number
1938 );
1939 exception
1940 when hr_api.cannot_find_prog_unit then
1941 hr_api.cannot_find_prog_unit_error
1942 (p_module_name => 'DELETE_VACANCY_CRITERIA'
1943 ,p_hook_type => 'AP'
1944 );
1945 end;
1946 --
1947 -- When in validation only mode raise the Validate_Enabled exception
1948 --
1949 if p_validate then
1950 raise hr_api.validate_enabled;
1951 end if;
1952 --
1953 -- Set all output arguments
1954 --
1955 --
1956 hr_utility.set_location(' Leaving:'||l_proc, 70);
1957 exception
1958 when hr_api.validate_enabled then
1959 --
1960 -- As the Validate_Enabled exception has been raised
1961 -- we must rollback to the savepoint
1965 -- Only set output warning arguments
1962 --
1963 rollback to DELETE_VACANCY_CRITERIA;
1964 --
1966 -- (Any key or derived arguments must be set to null
1967 -- when validation only mode is being used.)
1968 --
1969 hr_utility.set_location(' Leaving:'||l_proc, 80);
1970 when others then
1971 --
1972 -- A validation or unexpected error has occured
1973 --
1974 rollback to DELETE_VACANCY_CRITERIA;
1975 hr_utility.set_location(' Leaving:'||l_proc, 90);
1976 raise;
1977 end DELETE_VACANCY_CRITERIA;
1978 --
1979 --
1980 -- ----------------------------------------------------------------------------
1981 -- |--------------------------< CREATE_WORK_CHOICES >--------------------------|
1982 -- ----------------------------------------------------------------------------
1983 --
1984 procedure CREATE_WORK_CHOICES
1985 (p_validate in boolean default false
1986 ,p_effective_date in date
1987 ,p_person_id in number
1988 ,p_location in varchar2 default null
1989 ,p_distance_to_location in varchar2 default null
1990 ,p_geocode_location in varchar2 default null
1991 ,p_geocode_country in varchar2 default null
1992 ,p_derived_location in varchar2 default null
1993 ,p_location_id in number default null
1994 ,p_longitude in number default null
1995 ,p_latitude in number default null
1996 ,p_employee in varchar2 default null
1997 ,p_contractor in varchar2 default null
1998 ,p_employment_category in varchar2 default 'EITHER'
1999 ,p_keywords in varchar2 default null
2000 ,p_travel_percentage in number default null
2001 ,p_min_salary in number default null
2002 ,p_salary_currency in varchar2 default null
2003 ,p_salary_period in varchar2 default null
2004 ,p_match_competence in varchar2 default 'N'
2005 ,p_match_qualification in varchar2 default 'N'
2006 ,p_work_at_home in varchar2 default 'POSSIBLE'
2007 ,p_job_title in varchar2 default null
2008 ,p_department in varchar2 default null
2009 ,p_professional_area in varchar2 default null
2010 ,p_description in varchar2 default null
2011 ,p_attribute_category in varchar2 default null
2012 ,p_attribute1 in varchar2 default null
2013 ,p_attribute2 in varchar2 default null
2014 ,p_attribute3 in varchar2 default null
2015 ,p_attribute4 in varchar2 default null
2016 ,p_attribute5 in varchar2 default null
2017 ,p_attribute6 in varchar2 default null
2018 ,p_attribute7 in varchar2 default null
2019 ,p_attribute8 in varchar2 default null
2020 ,p_attribute9 in varchar2 default null
2021 ,p_attribute10 in varchar2 default null
2022 ,p_attribute11 in varchar2 default null
2023 ,p_attribute12 in varchar2 default null
2024 ,p_attribute13 in varchar2 default null
2025 ,p_attribute14 in varchar2 default null
2026 ,p_attribute15 in varchar2 default null
2027 ,p_attribute16 in varchar2 default null
2028 ,p_attribute17 in varchar2 default null
2029 ,p_attribute18 in varchar2 default null
2030 ,p_attribute19 in varchar2 default null
2031 ,p_attribute20 in varchar2 default null
2032 ,p_attribute21 in varchar2 default null
2033 ,p_attribute22 in varchar2 default null
2034 ,p_attribute23 in varchar2 default null
2035 ,p_attribute24 in varchar2 default null
2036 ,p_attribute25 in varchar2 default null
2037 ,p_attribute26 in varchar2 default null
2038 ,p_attribute27 in varchar2 default null
2039 ,p_attribute28 in varchar2 default null
2040 ,p_attribute29 in varchar2 default null
2041 ,p_attribute30 in varchar2 default null
2042 ,p_isc_information_category in varchar2 default null
2043 ,p_isc_information1 in varchar2 default null
2044 ,p_isc_information2 in varchar2 default null
2045 ,p_isc_information3 in varchar2 default null
2046 ,p_isc_information4 in varchar2 default null
2047 ,p_isc_information5 in varchar2 default null
2048 ,p_isc_information6 in varchar2 default null
2049 ,p_isc_information7 in varchar2 default null
2050 ,p_isc_information8 in varchar2 default null
2051 ,p_isc_information9 in varchar2 default null
2052 ,p_isc_information10 in varchar2 default null
2053 ,p_isc_information11 in varchar2 default null
2054 ,p_isc_information12 in varchar2 default null
2055 ,p_isc_information13 in varchar2 default null
2056 ,p_isc_information14 in varchar2 default null
2057 ,p_isc_information15 in varchar2 default null
2058 ,p_isc_information16 in varchar2 default null
2059 ,p_isc_information17 in varchar2 default null
2060 ,p_isc_information18 in varchar2 default null
2061 ,p_isc_information19 in varchar2 default null
2062 ,p_isc_information20 in varchar2 default null
2066 ,p_isc_information24 in varchar2 default null
2063 ,p_isc_information21 in varchar2 default null
2064 ,p_isc_information22 in varchar2 default null
2065 ,p_isc_information23 in varchar2 default null
2067 ,p_isc_information25 in varchar2 default null
2068 ,p_isc_information26 in varchar2 default null
2069 ,p_isc_information27 in varchar2 default null
2070 ,p_isc_information28 in varchar2 default null
2071 ,p_isc_information29 in varchar2 default null
2072 ,p_isc_information30 in varchar2 default null
2073 ,p_object_version_number out nocopy number
2074 ,p_search_criteria_id out nocopy number
2075 ) is
2076 --
2077 -- Declare cursors and local variables
2078 --
2079
2080 l_proc varchar2(72) := g_package||'CREATE_WORK_CHOICES';
2081 l_effective_date date;
2082 l_object_version_number irc_search_criteria.object_version_number%TYPE;
2083 l_search_criteria_id irc_search_criteria.search_criteria_id%TYPE;
2084
2085 begin
2086 hr_utility.set_location('Entering:'|| l_proc, 10);
2087 --
2088 -- Issue a savepoint
2089 --
2090 savepoint CREATE_WORK_CHOICES;
2091 --
2092 -- Truncate the time portion from all IN date parameters
2093 --
2094 l_effective_date := trunc(p_effective_date);
2095 --
2096 -- Call Before Process User Hook
2097 --
2098 begin
2099 IRC_SEARCH_CRITERIA_BK7.CREATE_WORK_CHOICES_B
2100 (p_effective_date => l_effective_date
2101 ,p_person_id => p_person_id
2102 ,p_location => p_location
2103 ,p_distance_to_location => p_distance_to_location
2104 ,p_geocode_location => p_geocode_location
2105 ,p_geocode_country => p_geocode_country
2106 ,p_derived_location => p_derived_location
2107 ,p_location_id => p_location_id
2108 ,p_longitude => p_longitude
2109 ,p_latitude => p_latitude
2110 ,p_employee => p_employee
2111 ,p_contractor => p_contractor
2112 ,p_employment_category => p_employment_category
2113 ,p_keywords => p_keywords
2114 ,p_travel_percentage => p_travel_percentage
2115 ,p_min_salary => p_min_salary
2116 ,p_salary_currency => p_salary_currency
2117 ,p_salary_period => p_salary_period
2118 ,p_match_competence => p_match_competence
2119 ,p_match_qualification => p_match_qualification
2120 ,p_work_at_home => p_work_at_home
2121 ,p_job_title => p_job_title
2122 ,p_department => p_department
2123 ,p_professional_area => p_professional_area
2124 ,p_description => p_description
2125 ,p_attribute_category => p_attribute_category
2126 ,p_attribute1 => p_attribute1
2127 ,p_attribute2 => p_attribute2
2128 ,p_attribute3 => p_attribute3
2129 ,p_attribute4 => p_attribute4
2130 ,p_attribute5 => p_attribute5
2131 ,p_attribute6 => p_attribute6
2132 ,p_attribute7 => p_attribute7
2133 ,p_attribute8 => p_attribute8
2134 ,p_attribute9 => p_attribute9
2135 ,p_attribute10 => p_attribute10
2136 ,p_attribute11 => p_attribute11
2137 ,p_attribute12 => p_attribute12
2138 ,p_attribute13 => p_attribute13
2139 ,p_attribute14 => p_attribute14
2140 ,p_attribute15 => p_attribute15
2141 ,p_attribute16 => p_attribute16
2142 ,p_attribute17 => p_attribute17
2143 ,p_attribute18 => p_attribute18
2144 ,p_attribute19 => p_attribute19
2145 ,p_attribute20 => p_attribute20
2146 ,p_attribute21 => p_attribute21
2147 ,p_attribute22 => p_attribute22
2148 ,p_attribute23 => p_attribute23
2149 ,p_attribute24 => p_attribute24
2150 ,p_attribute25 => p_attribute25
2151 ,p_attribute26 => p_attribute26
2152 ,p_attribute27 => p_attribute27
2153 ,p_attribute28 => p_attribute28
2154 ,p_attribute29 => p_attribute29
2155 ,p_attribute30 => p_attribute30
2156 ,p_isc_information_category => p_isc_information_category
2157 ,p_isc_information1 => p_isc_information1
2158 ,p_isc_information2 => p_isc_information2
2159 ,p_isc_information3 => p_isc_information3
2160 ,p_isc_information4 => p_isc_information4
2161 ,p_isc_information5 => p_isc_information5
2162 ,p_isc_information6 => p_isc_information6
2163 ,p_isc_information7 => p_isc_information7
2164 ,p_isc_information8 => p_isc_information8
2165 ,p_isc_information9 => p_isc_information9
2166 ,p_isc_information10 => p_isc_information10
2167 ,p_isc_information11 => p_isc_information11
2168 ,p_isc_information12 => p_isc_information12
2169 ,p_isc_information13 => p_isc_information13
2170 ,p_isc_information14 => p_isc_information14
2171 ,p_isc_information15 => p_isc_information15
2172 ,p_isc_information16 => p_isc_information16
2176 ,p_isc_information20 => p_isc_information20
2173 ,p_isc_information17 => p_isc_information17
2174 ,p_isc_information18 => p_isc_information18
2175 ,p_isc_information19 => p_isc_information19
2177 ,p_isc_information21 => p_isc_information21
2178 ,p_isc_information22 => p_isc_information22
2179 ,p_isc_information23 => p_isc_information23
2180 ,p_isc_information24 => p_isc_information24
2181 ,p_isc_information25 => p_isc_information25
2182 ,p_isc_information26 => p_isc_information26
2183 ,p_isc_information27 => p_isc_information27
2184 ,p_isc_information28 => p_isc_information28
2185 ,p_isc_information29 => p_isc_information29
2186 ,p_isc_information30 => p_isc_information30
2187 );
2188 exception
2189 when hr_api.cannot_find_prog_unit then
2190 hr_api.cannot_find_prog_unit_error
2191 (p_module_name => 'CREATE_WORK_CHOICES'
2192 ,p_hook_type => 'BP'
2193 );
2194 end;
2195 --
2196 -- Validation in addition to Row Handlers
2197 --
2198 -- Process Logic
2199 --
2200 irc_isc_ins.ins(
2201 p_effective_date => l_effective_date
2202 ,p_object_id => p_person_id
2203 ,p_object_type => 'WPREF'
2204 ,p_location => p_location
2205 ,p_distance_to_location => p_distance_to_location
2206 ,p_geocode_location => p_geocode_location
2207 ,p_geocode_country => p_geocode_country
2208 ,p_derived_location => p_derived_location
2209 ,p_location_id => p_location_id
2210 ,p_longitude => p_longitude
2211 ,p_latitude => p_latitude
2212 ,p_contractor => p_contractor
2213 ,p_employee => p_employee
2214 ,p_employment_category => p_employment_category
2215 ,p_keywords => p_keywords
2216 ,p_travel_percentage => p_travel_percentage
2217 ,p_min_salary => p_min_salary
2218 ,p_salary_currency => p_salary_currency
2219 ,p_salary_period => p_salary_period
2220 ,p_match_competence => p_match_competence
2221 ,p_match_qualification => p_match_qualification
2222 ,p_work_at_home => p_work_at_home
2223 ,p_job_title => p_job_title
2224 ,p_department => p_department
2225 ,p_professional_area => p_professional_area
2226 ,p_use_for_matching => 'Y'
2227 ,p_description => p_description
2228 ,p_attribute_category => p_attribute_category
2229 ,p_attribute1 => p_attribute1
2230 ,p_attribute2 => p_attribute2
2231 ,p_attribute3 => p_attribute3
2232 ,p_attribute4 => p_attribute4
2233 ,p_attribute5 => p_attribute5
2234 ,p_attribute6 => p_attribute6
2235 ,p_attribute7 => p_attribute7
2236 ,p_attribute8 => p_attribute8
2237 ,p_attribute9 => p_attribute9
2238 ,p_attribute10 => p_attribute10
2239 ,p_attribute11 => p_attribute11
2240 ,p_attribute12 => p_attribute12
2241 ,p_attribute13 => p_attribute13
2242 ,p_attribute14 => p_attribute14
2243 ,p_attribute15 => p_attribute15
2244 ,p_attribute16 => p_attribute16
2245 ,p_attribute17 => p_attribute17
2246 ,p_attribute18 => p_attribute18
2247 ,p_attribute19 => p_attribute19
2248 ,p_attribute20 => p_attribute20
2249 ,p_attribute21 => p_attribute21
2250 ,p_attribute22 => p_attribute22
2251 ,p_attribute23 => p_attribute23
2252 ,p_attribute24 => p_attribute24
2253 ,p_attribute25 => p_attribute25
2254 ,p_attribute26 => p_attribute26
2255 ,p_attribute27 => p_attribute27
2256 ,p_attribute28 => p_attribute28
2257 ,p_attribute29 => p_attribute29
2258 ,p_attribute30 => p_attribute30
2259 ,p_isc_information_category => p_isc_information_category
2260 ,p_isc_information1 => p_isc_information1
2261 ,p_isc_information2 => p_isc_information2
2262 ,p_isc_information3 => p_isc_information3
2263 ,p_isc_information4 => p_isc_information4
2264 ,p_isc_information5 => p_isc_information5
2265 ,p_isc_information6 => p_isc_information6
2266 ,p_isc_information7 => p_isc_information7
2267 ,p_isc_information8 => p_isc_information8
2268 ,p_isc_information9 => p_isc_information9
2269 ,p_isc_information10 => p_isc_information10
2270 ,p_isc_information11 => p_isc_information11
2271 ,p_isc_information12 => p_isc_information12
2272 ,p_isc_information13 => p_isc_information13
2273 ,p_isc_information14 => p_isc_information14
2274 ,p_isc_information15 => p_isc_information15
2275 ,p_isc_information16 => p_isc_information16
2276 ,p_isc_information17 => p_isc_information17
2277 ,p_isc_information18 => p_isc_information18
2278 ,p_isc_information19 => p_isc_information19
2279 ,p_isc_information20 => p_isc_information20
2280 ,p_isc_information21 => p_isc_information21
2281 ,p_isc_information22 => p_isc_information22
2285 ,p_isc_information26 => p_isc_information26
2282 ,p_isc_information23 => p_isc_information23
2283 ,p_isc_information24 => p_isc_information24
2284 ,p_isc_information25 => p_isc_information25
2286 ,p_isc_information27 => p_isc_information27
2287 ,p_isc_information28 => p_isc_information28
2288 ,p_isc_information29 => p_isc_information29
2289 ,p_isc_information30 => p_isc_information30
2290 ,p_object_version_number => l_object_version_number
2291 ,p_search_criteria_id => l_search_criteria_id
2292 );
2293 --
2294 -- Call After Process User Hook
2295 --
2296 begin
2297 IRC_SEARCH_CRITERIA_BK7.CREATE_WORK_CHOICES_A
2298 (p_effective_date => l_effective_date
2299 ,p_person_id => p_person_id
2300 ,p_location => p_location
2301 ,p_distance_to_location => p_distance_to_location
2302 ,p_geocode_location => p_geocode_location
2303 ,p_geocode_country => p_geocode_country
2304 ,p_derived_location => p_derived_location
2305 ,p_location_id => p_location_id
2306 ,p_longitude => p_longitude
2307 ,p_latitude => p_latitude
2308 ,p_contractor => p_contractor
2309 ,p_employee => p_employee
2310 ,p_employment_category => p_employment_category
2311 ,p_keywords => p_keywords
2312 ,p_travel_percentage => p_travel_percentage
2313 ,p_min_salary => p_min_salary
2314 ,p_salary_currency => p_salary_currency
2315 ,p_salary_period => p_salary_period
2316 ,p_match_competence => p_match_competence
2317 ,p_match_qualification => p_match_qualification
2318 ,p_work_at_home => p_work_at_home
2319 ,p_job_title => p_job_title
2320 ,p_department => p_department
2321 ,p_professional_area => p_professional_area
2322 ,p_description => p_description
2323 ,p_attribute_category => p_attribute_category
2324 ,p_attribute1 => p_attribute1
2325 ,p_attribute2 => p_attribute2
2326 ,p_attribute3 => p_attribute3
2327 ,p_attribute4 => p_attribute4
2328 ,p_attribute5 => p_attribute5
2329 ,p_attribute6 => p_attribute6
2330 ,p_attribute7 => p_attribute7
2331 ,p_attribute8 => p_attribute8
2332 ,p_attribute9 => p_attribute9
2333 ,p_attribute10 => p_attribute10
2334 ,p_attribute11 => p_attribute11
2335 ,p_attribute12 => p_attribute12
2336 ,p_attribute13 => p_attribute13
2337 ,p_attribute14 => p_attribute14
2338 ,p_attribute15 => p_attribute15
2339 ,p_attribute16 => p_attribute16
2340 ,p_attribute17 => p_attribute17
2341 ,p_attribute18 => p_attribute18
2342 ,p_attribute19 => p_attribute19
2343 ,p_attribute20 => p_attribute20
2344 ,p_attribute21 => p_attribute21
2345 ,p_attribute22 => p_attribute22
2346 ,p_attribute23 => p_attribute23
2347 ,p_attribute24 => p_attribute24
2348 ,p_attribute25 => p_attribute25
2349 ,p_attribute26 => p_attribute26
2350 ,p_attribute27 => p_attribute27
2351 ,p_attribute28 => p_attribute28
2352 ,p_attribute29 => p_attribute29
2353 ,p_attribute30 => p_attribute30
2354 ,p_isc_information_category => p_isc_information_category
2355 ,p_isc_information1 => p_isc_information1
2356 ,p_isc_information2 => p_isc_information2
2357 ,p_isc_information3 => p_isc_information3
2358 ,p_isc_information4 => p_isc_information4
2359 ,p_isc_information5 => p_isc_information5
2360 ,p_isc_information6 => p_isc_information6
2361 ,p_isc_information7 => p_isc_information7
2362 ,p_isc_information8 => p_isc_information8
2363 ,p_isc_information9 => p_isc_information9
2364 ,p_isc_information10 => p_isc_information10
2365 ,p_isc_information11 => p_isc_information11
2366 ,p_isc_information12 => p_isc_information12
2367 ,p_isc_information13 => p_isc_information13
2368 ,p_isc_information14 => p_isc_information14
2369 ,p_isc_information15 => p_isc_information15
2370 ,p_isc_information16 => p_isc_information16
2371 ,p_isc_information17 => p_isc_information17
2372 ,p_isc_information18 => p_isc_information18
2373 ,p_isc_information19 => p_isc_information19
2374 ,p_isc_information20 => p_isc_information20
2375 ,p_isc_information21 => p_isc_information21
2376 ,p_isc_information22 => p_isc_information22
2377 ,p_isc_information23 => p_isc_information23
2378 ,p_isc_information24 => p_isc_information24
2379 ,p_isc_information25 => p_isc_information25
2380 ,p_isc_information26 => p_isc_information26
2381 ,p_isc_information27 => p_isc_information27
2382 ,p_isc_information28 => p_isc_information28
2386 ,p_search_criteria_id => l_search_criteria_id
2383 ,p_isc_information29 => p_isc_information29
2384 ,p_isc_information30 => p_isc_information30
2385 ,p_object_version_number => l_object_version_number
2387 );
2388 exception
2389 when hr_api.cannot_find_prog_unit then
2390 hr_api.cannot_find_prog_unit_error
2391 (p_module_name => 'CREATE_WORK_CHOICES'
2392 ,p_hook_type => 'AP'
2393 );
2394 end;
2395 --
2396 -- When in validation only mode raise the Validate_Enabled exception
2397 --
2398 if p_validate then
2399 raise hr_api.validate_enabled;
2400 end if;
2401 --
2402 -- Set all output arguments
2403 --
2404 p_search_criteria_id := l_search_criteria_id;
2405 p_object_version_number := l_object_version_number;
2406 --
2407 hr_utility.set_location(' Leaving:'||l_proc, 70);
2408 exception
2409 when hr_api.validate_enabled then
2410 --
2411 -- As the Validate_Enabled exception has been raised
2412 -- we must rollback to the savepoint
2413 --
2414 rollback to CREATE_WORK_CHOICES;
2415 --
2416 -- Only set output warning arguments
2417 -- (Any key or derived arguments must be set to null
2418 -- when validation only mode is being used.)
2419 --
2420 p_search_criteria_id := null;
2421 p_object_version_number := null;
2422 hr_utility.set_location(' Leaving:'||l_proc, 80);
2423 when others then
2424 --
2425 -- A validation or unexpected error has occured
2426 --
2427 p_search_criteria_id := null;
2428 p_object_version_number := null;
2429 rollback to CREATE_WORK_CHOICES;
2430 hr_utility.set_location(' Leaving:'||l_proc, 90);
2431 raise;
2432 end CREATE_WORK_CHOICES;
2433 --
2434 -- ----------------------------------------------------------------------------
2435 -- |--------------------------< UPDATE_WORK_CHOICES >--------------------------|
2436 -- ----------------------------------------------------------------------------
2437 --
2438 procedure UPDATE_WORK_CHOICES
2439 (p_validate in boolean default false
2440 ,p_effective_date in date
2441 ,p_search_criteria_id in number
2442 ,p_location in varchar2 default hr_api.g_varchar2
2443 ,p_distance_to_location in varchar2 default hr_api.g_varchar2
2444 ,p_geocode_location in varchar2 default hr_api.g_varchar2
2445 ,p_geocode_country in varchar2 default hr_api.g_varchar2
2446 ,p_derived_location in varchar2 default hr_api.g_varchar2
2447 ,p_location_id in number default hr_api.g_number
2448 ,p_longitude in number default hr_api.g_number
2449 ,p_latitude in number default hr_api.g_number
2450 ,p_employee in varchar2 default hr_api.g_varchar2
2451 ,p_contractor in varchar2 default hr_api.g_varchar2
2452 ,p_employment_category in varchar2 default hr_api.g_varchar2
2453 ,p_keywords in varchar2 default hr_api.g_varchar2
2454 ,p_travel_percentage in number default hr_api.g_number
2455 ,p_min_salary in number default hr_api.g_number
2456 ,p_salary_currency in varchar2 default hr_api.g_varchar2
2457 ,p_salary_period in varchar2 default hr_api.g_varchar2
2458 ,p_match_competence in varchar2 default hr_api.g_varchar2
2459 ,p_match_qualification in varchar2 default hr_api.g_varchar2
2460 ,p_work_at_home in varchar2 default hr_api.g_varchar2
2461 ,p_job_title in varchar2 default hr_api.g_varchar2
2462 ,p_department in varchar2 default hr_api.g_varchar2
2463 ,p_professional_area in varchar2 default hr_api.g_varchar2
2464 ,p_description in varchar2 default hr_api.g_varchar2
2465 ,p_attribute_category in varchar2 default hr_api.g_varchar2
2466 ,p_attribute1 in varchar2 default hr_api.g_varchar2
2467 ,p_attribute2 in varchar2 default hr_api.g_varchar2
2468 ,p_attribute3 in varchar2 default hr_api.g_varchar2
2469 ,p_attribute4 in varchar2 default hr_api.g_varchar2
2470 ,p_attribute5 in varchar2 default hr_api.g_varchar2
2471 ,p_attribute6 in varchar2 default hr_api.g_varchar2
2472 ,p_attribute7 in varchar2 default hr_api.g_varchar2
2473 ,p_attribute8 in varchar2 default hr_api.g_varchar2
2474 ,p_attribute9 in varchar2 default hr_api.g_varchar2
2475 ,p_attribute10 in varchar2 default hr_api.g_varchar2
2476 ,p_attribute11 in varchar2 default hr_api.g_varchar2
2477 ,p_attribute12 in varchar2 default hr_api.g_varchar2
2478 ,p_attribute13 in varchar2 default hr_api.g_varchar2
2479 ,p_attribute14 in varchar2 default hr_api.g_varchar2
2480 ,p_attribute15 in varchar2 default hr_api.g_varchar2
2481 ,p_attribute16 in varchar2 default hr_api.g_varchar2
2482 ,p_attribute17 in varchar2 default hr_api.g_varchar2
2483 ,p_attribute18 in varchar2 default hr_api.g_varchar2
2484 ,p_attribute19 in varchar2 default hr_api.g_varchar2
2485 ,p_attribute20 in varchar2 default hr_api.g_varchar2
2486 ,p_attribute21 in varchar2 default hr_api.g_varchar2
2487 ,p_attribute22 in varchar2 default hr_api.g_varchar2
2488 ,p_attribute23 in varchar2 default hr_api.g_varchar2
2492 ,p_attribute27 in varchar2 default hr_api.g_varchar2
2489 ,p_attribute24 in varchar2 default hr_api.g_varchar2
2490 ,p_attribute25 in varchar2 default hr_api.g_varchar2
2491 ,p_attribute26 in varchar2 default hr_api.g_varchar2
2493 ,p_attribute28 in varchar2 default hr_api.g_varchar2
2494 ,p_attribute29 in varchar2 default hr_api.g_varchar2
2495 ,p_attribute30 in varchar2 default hr_api.g_varchar2
2496 ,p_isc_information_category in varchar2 default hr_api.g_varchar2
2497 ,p_isc_information1 in varchar2 default hr_api.g_varchar2
2498 ,p_isc_information2 in varchar2 default hr_api.g_varchar2
2499 ,p_isc_information3 in varchar2 default hr_api.g_varchar2
2500 ,p_isc_information4 in varchar2 default hr_api.g_varchar2
2501 ,p_isc_information5 in varchar2 default hr_api.g_varchar2
2502 ,p_isc_information6 in varchar2 default hr_api.g_varchar2
2503 ,p_isc_information7 in varchar2 default hr_api.g_varchar2
2504 ,p_isc_information8 in varchar2 default hr_api.g_varchar2
2505 ,p_isc_information9 in varchar2 default hr_api.g_varchar2
2506 ,p_isc_information10 in varchar2 default hr_api.g_varchar2
2507 ,p_isc_information11 in varchar2 default hr_api.g_varchar2
2508 ,p_isc_information12 in varchar2 default hr_api.g_varchar2
2509 ,p_isc_information13 in varchar2 default hr_api.g_varchar2
2510 ,p_isc_information14 in varchar2 default hr_api.g_varchar2
2511 ,p_isc_information15 in varchar2 default hr_api.g_varchar2
2512 ,p_isc_information16 in varchar2 default hr_api.g_varchar2
2513 ,p_isc_information17 in varchar2 default hr_api.g_varchar2
2514 ,p_isc_information18 in varchar2 default hr_api.g_varchar2
2515 ,p_isc_information19 in varchar2 default hr_api.g_varchar2
2516 ,p_isc_information20 in varchar2 default hr_api.g_varchar2
2517 ,p_isc_information21 in varchar2 default hr_api.g_varchar2
2518 ,p_isc_information22 in varchar2 default hr_api.g_varchar2
2519 ,p_isc_information23 in varchar2 default hr_api.g_varchar2
2520 ,p_isc_information24 in varchar2 default hr_api.g_varchar2
2521 ,p_isc_information25 in varchar2 default hr_api.g_varchar2
2522 ,p_isc_information26 in varchar2 default hr_api.g_varchar2
2523 ,p_isc_information27 in varchar2 default hr_api.g_varchar2
2524 ,p_isc_information28 in varchar2 default hr_api.g_varchar2
2525 ,p_isc_information29 in varchar2 default hr_api.g_varchar2
2526 ,p_isc_information30 in varchar2 default hr_api.g_varchar2
2527 ,p_object_version_number in out nocopy number
2528 ) is
2529 --
2530 -- Declare cursors and local variables
2531 --
2532
2533 l_proc varchar2(72) := g_package||'UPDATE_WORK_CHOICES';
2534 l_effective_date date;
2535 l_object_version_number irc_search_criteria.object_version_number%TYPE
2536 := p_object_version_number;
2537
2538 begin
2539 hr_utility.set_location('Entering:'|| l_proc, 10);
2540 --
2541 -- Issue a savepoint
2542 --
2543 savepoint UPDATE_WORK_CHOICES;
2544 --
2545 -- Truncate the time portion from all IN date parameters
2546 --
2547 l_effective_date := trunc(p_effective_date);
2548 --
2549 -- Call Before Process User Hook
2550 --
2551 begin
2552 IRC_SEARCH_CRITERIA_BK8.UPDATE_WORK_CHOICES_B
2553 (p_effective_date => l_effective_date
2554 ,p_search_criteria_id => p_search_criteria_id
2555 ,p_location => p_location
2556 ,p_distance_to_location => p_distance_to_location
2557 ,p_geocode_location => p_geocode_location
2558 ,p_geocode_country => p_geocode_country
2559 ,p_derived_location => p_derived_location
2560 ,p_location_id => p_location_id
2561 ,p_longitude => p_longitude
2562 ,p_latitude => p_latitude
2563 ,p_contractor => p_contractor
2564 ,p_employee => p_employee
2565 ,p_employment_category => p_employment_category
2566 ,p_keywords => p_keywords
2567 ,p_travel_percentage => p_travel_percentage
2568 ,p_min_salary => p_min_salary
2569 ,p_salary_currency => p_salary_currency
2570 ,p_salary_period => p_salary_period
2571 ,p_match_competence => p_match_competence
2572 ,p_match_qualification => p_match_qualification
2573 ,p_work_at_home => p_work_at_home
2574 ,p_job_title => p_job_title
2575 ,p_department => p_department
2576 ,p_professional_area => p_professional_area
2577 ,p_description => p_description
2578 ,p_attribute_category => p_attribute_category
2579 ,p_attribute1 => p_attribute1
2580 ,p_attribute2 => p_attribute2
2581 ,p_attribute3 => p_attribute3
2582 ,p_attribute4 => p_attribute4
2583 ,p_attribute5 => p_attribute5
2584 ,p_attribute6 => p_attribute6
2585 ,p_attribute7 => p_attribute7
2586 ,p_attribute8 => p_attribute8
2587 ,p_attribute9 => p_attribute9
2588 ,p_attribute10 => p_attribute10
2589 ,p_attribute11 => p_attribute11
2590 ,p_attribute12 => p_attribute12
2594 ,p_attribute16 => p_attribute16
2591 ,p_attribute13 => p_attribute13
2592 ,p_attribute14 => p_attribute14
2593 ,p_attribute15 => p_attribute15
2595 ,p_attribute17 => p_attribute17
2596 ,p_attribute18 => p_attribute18
2597 ,p_attribute19 => p_attribute19
2598 ,p_attribute20 => p_attribute20
2599 ,p_attribute21 => p_attribute21
2600 ,p_attribute22 => p_attribute22
2601 ,p_attribute23 => p_attribute23
2602 ,p_attribute24 => p_attribute24
2603 ,p_attribute25 => p_attribute25
2604 ,p_attribute26 => p_attribute26
2605 ,p_attribute27 => p_attribute27
2606 ,p_attribute28 => p_attribute28
2607 ,p_attribute29 => p_attribute29
2608 ,p_attribute30 => p_attribute30
2609 ,p_isc_information_category => p_isc_information_category
2610 ,p_isc_information1 => p_isc_information1
2611 ,p_isc_information2 => p_isc_information2
2612 ,p_isc_information3 => p_isc_information3
2613 ,p_isc_information4 => p_isc_information4
2614 ,p_isc_information5 => p_isc_information5
2615 ,p_isc_information6 => p_isc_information6
2616 ,p_isc_information7 => p_isc_information7
2617 ,p_isc_information8 => p_isc_information8
2618 ,p_isc_information9 => p_isc_information9
2619 ,p_isc_information10 => p_isc_information10
2620 ,p_isc_information11 => p_isc_information11
2621 ,p_isc_information12 => p_isc_information12
2622 ,p_isc_information13 => p_isc_information13
2623 ,p_isc_information14 => p_isc_information14
2624 ,p_isc_information15 => p_isc_information15
2625 ,p_isc_information16 => p_isc_information16
2626 ,p_isc_information17 => p_isc_information17
2627 ,p_isc_information18 => p_isc_information18
2628 ,p_isc_information19 => p_isc_information19
2629 ,p_isc_information20 => p_isc_information20
2630 ,p_isc_information21 => p_isc_information21
2631 ,p_isc_information22 => p_isc_information22
2632 ,p_isc_information23 => p_isc_information23
2633 ,p_isc_information24 => p_isc_information24
2634 ,p_isc_information25 => p_isc_information25
2635 ,p_isc_information26 => p_isc_information26
2636 ,p_isc_information27 => p_isc_information27
2637 ,p_isc_information28 => p_isc_information28
2638 ,p_isc_information29 => p_isc_information29
2639 ,p_isc_information30 => p_isc_information30
2640 ,p_object_version_number => l_object_version_number
2641 );
2642 exception
2643 when hr_api.cannot_find_prog_unit then
2644 hr_api.cannot_find_prog_unit_error
2645 (p_module_name => 'UPDATE_WORK_CHOICES'
2646 ,p_hook_type => 'BP'
2647 );
2648 end;
2649 --
2650 -- Validation in addition to Row Handlers
2651 --
2652 -- Process Logic
2653 --
2654 irc_isc_upd.upd(
2655 p_effective_date => l_effective_date
2656 ,p_search_criteria_id => p_search_criteria_id
2657 ,p_object_type => 'WPREF'
2658 ,p_location => p_location
2659 ,p_distance_to_location => p_distance_to_location
2660 ,p_geocode_location => p_geocode_location
2661 ,p_geocode_country => p_geocode_country
2662 ,p_derived_location => p_derived_location
2663 ,p_location_id => p_location_id
2664 ,p_longitude => p_longitude
2665 ,p_latitude => p_latitude
2666 ,p_contractor => p_contractor
2667 ,p_employee => p_employee
2668 ,p_employment_category => p_employment_category
2669 ,p_keywords => p_keywords
2670 ,p_travel_percentage => p_travel_percentage
2671 ,p_min_salary => p_min_salary
2672 ,p_salary_currency => p_salary_currency
2673 ,p_salary_period => p_salary_period
2674 ,p_match_competence => p_match_competence
2675 ,p_match_qualification => p_match_qualification
2676 ,p_work_at_home => p_work_at_home
2677 ,p_job_title => p_job_title
2678 ,p_department => p_department
2679 ,p_professional_area => p_professional_area
2680 ,p_description => p_description
2681 ,p_attribute_category => p_attribute_category
2682 ,p_attribute1 => p_attribute1
2683 ,p_attribute2 => p_attribute2
2684 ,p_attribute3 => p_attribute3
2685 ,p_attribute4 => p_attribute4
2686 ,p_attribute5 => p_attribute5
2687 ,p_attribute6 => p_attribute6
2688 ,p_attribute7 => p_attribute7
2689 ,p_attribute8 => p_attribute8
2690 ,p_attribute9 => p_attribute9
2691 ,p_attribute10 => p_attribute10
2692 ,p_attribute11 => p_attribute11
2693 ,p_attribute12 => p_attribute12
2694 ,p_attribute13 => p_attribute13
2695 ,p_attribute14 => p_attribute14
2696 ,p_attribute15 => p_attribute15
2700 ,p_attribute19 => p_attribute19
2697 ,p_attribute16 => p_attribute16
2698 ,p_attribute17 => p_attribute17
2699 ,p_attribute18 => p_attribute18
2701 ,p_attribute20 => p_attribute20
2702 ,p_attribute21 => p_attribute21
2703 ,p_attribute22 => p_attribute22
2704 ,p_attribute23 => p_attribute23
2705 ,p_attribute24 => p_attribute24
2706 ,p_attribute25 => p_attribute25
2707 ,p_attribute26 => p_attribute26
2708 ,p_attribute27 => p_attribute27
2709 ,p_attribute28 => p_attribute28
2710 ,p_attribute29 => p_attribute29
2711 ,p_attribute30 => p_attribute30
2712 ,p_isc_information_category => p_isc_information_category
2713 ,p_isc_information1 => p_isc_information1
2714 ,p_isc_information2 => p_isc_information2
2715 ,p_isc_information3 => p_isc_information3
2716 ,p_isc_information4 => p_isc_information4
2717 ,p_isc_information5 => p_isc_information5
2718 ,p_isc_information6 => p_isc_information6
2719 ,p_isc_information7 => p_isc_information7
2720 ,p_isc_information8 => p_isc_information8
2721 ,p_isc_information9 => p_isc_information9
2722 ,p_isc_information10 => p_isc_information10
2723 ,p_isc_information11 => p_isc_information11
2724 ,p_isc_information12 => p_isc_information12
2725 ,p_isc_information13 => p_isc_information13
2726 ,p_isc_information14 => p_isc_information14
2727 ,p_isc_information15 => p_isc_information15
2728 ,p_isc_information16 => p_isc_information16
2729 ,p_isc_information17 => p_isc_information17
2730 ,p_isc_information18 => p_isc_information18
2731 ,p_isc_information19 => p_isc_information19
2732 ,p_isc_information20 => p_isc_information20
2733 ,p_isc_information21 => p_isc_information21
2734 ,p_isc_information22 => p_isc_information22
2735 ,p_isc_information23 => p_isc_information23
2736 ,p_isc_information24 => p_isc_information24
2737 ,p_isc_information25 => p_isc_information25
2738 ,p_isc_information26 => p_isc_information26
2739 ,p_isc_information27 => p_isc_information27
2740 ,p_isc_information28 => p_isc_information28
2741 ,p_isc_information29 => p_isc_information29
2742 ,p_isc_information30 => p_isc_information30
2743 ,p_object_version_number => l_object_version_number
2744 );
2745 --
2746 -- Call After Process User Hook
2747 --
2748 begin
2749 IRC_SEARCH_CRITERIA_BK8.UPDATE_WORK_CHOICES_A
2750 (p_effective_date => l_effective_date
2751 ,p_search_criteria_id => p_search_criteria_id
2752 ,p_location => p_location
2753 ,p_distance_to_location => p_distance_to_location
2754 ,p_geocode_location => p_geocode_location
2755 ,p_geocode_country => p_geocode_country
2756 ,p_derived_location => p_derived_location
2757 ,p_location_id => p_location_id
2758 ,p_longitude => p_longitude
2759 ,p_latitude => p_latitude
2760 ,p_contractor => p_contractor
2761 ,p_employee => p_employee
2762 ,p_employment_category => p_employment_category
2763 ,p_keywords => p_keywords
2764 ,p_travel_percentage => p_travel_percentage
2765 ,p_min_salary => p_min_salary
2766 ,p_salary_currency => p_salary_currency
2767 ,p_salary_period => p_salary_period
2768 ,p_match_competence => p_match_competence
2769 ,p_match_qualification => p_match_qualification
2770 ,p_work_at_home => p_work_at_home
2771 ,p_job_title => p_job_title
2772 ,p_department => p_department
2773 ,p_professional_area => p_professional_area
2774 ,p_description => p_description
2775 ,p_attribute_category => p_attribute_category
2776 ,p_attribute1 => p_attribute1
2777 ,p_attribute2 => p_attribute2
2778 ,p_attribute3 => p_attribute3
2779 ,p_attribute4 => p_attribute4
2780 ,p_attribute5 => p_attribute5
2781 ,p_attribute6 => p_attribute6
2782 ,p_attribute7 => p_attribute7
2783 ,p_attribute8 => p_attribute8
2784 ,p_attribute9 => p_attribute9
2785 ,p_attribute10 => p_attribute10
2786 ,p_attribute11 => p_attribute11
2787 ,p_attribute12 => p_attribute12
2788 ,p_attribute13 => p_attribute13
2789 ,p_attribute14 => p_attribute14
2790 ,p_attribute15 => p_attribute15
2791 ,p_attribute16 => p_attribute16
2792 ,p_attribute17 => p_attribute17
2793 ,p_attribute18 => p_attribute18
2794 ,p_attribute19 => p_attribute19
2795 ,p_attribute20 => p_attribute20
2796 ,p_attribute21 => p_attribute21
2800 ,p_attribute25 => p_attribute25
2797 ,p_attribute22 => p_attribute22
2798 ,p_attribute23 => p_attribute23
2799 ,p_attribute24 => p_attribute24
2801 ,p_attribute26 => p_attribute26
2802 ,p_attribute27 => p_attribute27
2803 ,p_attribute28 => p_attribute28
2804 ,p_attribute29 => p_attribute29
2805 ,p_attribute30 => p_attribute30
2806 ,p_isc_information_category => p_isc_information_category
2807 ,p_isc_information1 => p_isc_information1
2808 ,p_isc_information2 => p_isc_information2
2809 ,p_isc_information3 => p_isc_information3
2810 ,p_isc_information4 => p_isc_information4
2811 ,p_isc_information5 => p_isc_information5
2812 ,p_isc_information6 => p_isc_information6
2813 ,p_isc_information7 => p_isc_information7
2814 ,p_isc_information8 => p_isc_information8
2815 ,p_isc_information9 => p_isc_information9
2816 ,p_isc_information10 => p_isc_information10
2817 ,p_isc_information11 => p_isc_information11
2818 ,p_isc_information12 => p_isc_information12
2819 ,p_isc_information13 => p_isc_information13
2820 ,p_isc_information14 => p_isc_information14
2821 ,p_isc_information15 => p_isc_information15
2822 ,p_isc_information16 => p_isc_information16
2823 ,p_isc_information17 => p_isc_information17
2824 ,p_isc_information18 => p_isc_information18
2825 ,p_isc_information19 => p_isc_information19
2826 ,p_isc_information20 => p_isc_information20
2827 ,p_isc_information21 => p_isc_information21
2828 ,p_isc_information22 => p_isc_information22
2829 ,p_isc_information23 => p_isc_information23
2830 ,p_isc_information24 => p_isc_information24
2831 ,p_isc_information25 => p_isc_information25
2832 ,p_isc_information26 => p_isc_information26
2833 ,p_isc_information27 => p_isc_information27
2834 ,p_isc_information28 => p_isc_information28
2835 ,p_isc_information29 => p_isc_information29
2836 ,p_isc_information30 => p_isc_information30
2837 ,p_object_version_number => l_object_version_number
2838 );
2839 exception
2840 when hr_api.cannot_find_prog_unit then
2841 hr_api.cannot_find_prog_unit_error
2842 (p_module_name => 'UPDATE_WORK_CHOICES'
2843 ,p_hook_type => 'AP'
2844 );
2845 end;
2846 --
2847 -- When in validation only mode raise the Validate_Enabled exception
2848 --
2849 if p_validate then
2850 raise hr_api.validate_enabled;
2851 end if;
2852 --
2853 -- Set all output arguments
2854 --
2855 p_object_version_number := l_object_version_number;
2856 --
2857 hr_utility.set_location(' Leaving:'||l_proc, 70);
2858 exception
2859 when hr_api.validate_enabled then
2860 --
2861 -- As the Validate_Enabled exception has been raised
2862 -- we must rollback to the savepoint
2863 --
2864 rollback to UPDATE_WORK_CHOICES;
2865 --
2866 -- Only set output warning arguments
2867 -- (Any key or derived arguments must be set to null
2868 -- when validation only mode is being used.)
2869 --
2870 --
2871 -- Reset IN OUT parameters and set OUT parameters
2872 --
2873 p_object_version_number := l_object_version_number;
2874 hr_utility.set_location(' Leaving:'||l_proc, 80);
2875 when others then
2876 --
2877 -- A validation or unexpected error has occured
2878 --
2879 rollback to UPDATE_WORK_CHOICES;
2880 --
2881 -- Reset IN OUT parameters and set OUT parameters
2882 --
2883 p_object_version_number := l_object_version_number;
2884 hr_utility.set_location(' Leaving:'||l_proc, 90);
2885 raise;
2886 end UPDATE_WORK_CHOICES;
2887 --
2888 -- ----------------------------------------------------------------------------
2889 -- |--------------------------< DELETE_WORK_CHOICES >--------------------------|
2890 -- ----------------------------------------------------------------------------
2891 --
2892 procedure DELETE_WORK_CHOICES
2893 (p_validate in boolean default false
2894 ,p_search_criteria_id in number
2895 ,p_object_version_number in number
2896 ) is
2897 --
2898 -- Declare cursors and local variables
2899 --
2900
2901 l_proc varchar2(72) := g_package||'DELETE_WORK_CHOICES';
2902
2903 begin
2904 hr_utility.set_location('Entering:'|| l_proc, 10);
2905 --
2906 -- Issue a savepoint
2907 --
2908 savepoint DELETE_WORK_CHOICES;
2909 --
2910 -- Truncate the time portion from all IN date parameters
2911 --
2912 -- Call Before Process User Hook
2913 --
2914 begin
2915 IRC_SEARCH_CRITERIA_BK9.DELETE_WORK_CHOICES_B
2916 (p_search_criteria_id => p_search_criteria_id
2917 ,p_object_version_number => p_object_version_number
2918 );
2919 exception
2920 when hr_api.cannot_find_prog_unit then
2921 hr_api.cannot_find_prog_unit_error
2922 (p_module_name => 'DELETE_WORK_CHOICES'
2923 ,p_hook_type => 'BP'
2924 );
2925 end;
2926 --
2927 -- Validation in addition to Row Handlers
2928 --
2929 -- Process Logic
2930 --
2931 irc_isc_del.del(
2932 p_search_criteria_id => p_search_criteria_id
2933 ,p_object_version_number => p_object_version_number
2934 );
2935 --
2936 -- Call After Process User Hook
2937 --
2938 begin
2939 IRC_SEARCH_CRITERIA_BK9.DELETE_WORK_CHOICES_A
2940 (p_search_criteria_id => p_search_criteria_id
2941 ,p_object_version_number => p_object_version_number
2942 );
2943 exception
2944 when hr_api.cannot_find_prog_unit then
2945 hr_api.cannot_find_prog_unit_error
2946 (p_module_name => 'DELETE_WORK_CHOICES'
2947 ,p_hook_type => 'AP'
2948 );
2949 end;
2950 --
2951 -- When in validation only mode raise the Validate_Enabled exception
2952 --
2953 if p_validate then
2954 raise hr_api.validate_enabled;
2955 end if;
2956 --
2957 -- Set all output arguments
2958 --
2959 --
2960 hr_utility.set_location(' Leaving:'||l_proc, 70);
2961 exception
2962 when hr_api.validate_enabled then
2963 --
2964 -- As the Validate_Enabled exception has been raised
2965 -- we must rollback to the savepoint
2966 --
2967 rollback to DELETE_WORK_CHOICES;
2968 --
2969 -- Only set output warning arguments
2970 -- (Any key or derived arguments must be set to null
2971 -- when validation only mode is being used.)
2972 --
2973 hr_utility.set_location(' Leaving:'||l_proc, 80);
2974 when others then
2975 --
2976 -- A validation or unexpected error has occured
2977 --
2978 rollback to DELETE_WORK_CHOICES;
2979 hr_utility.set_location(' Leaving:'||l_proc, 90);
2980 raise;
2981 end DELETE_WORK_CHOICES;
2982 --
2983 end IRC_SEARCH_CRITERIA_API;