[Home] [Help]
PACKAGE: APPS.IRC_SEARCH_CRITERIA_SWI
Source
1 Package irc_search_criteria_swi As
2 /* $Header: iriscswi.pkh 120.1 2006/03/13 02:33:01 cnholmes noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |--------------------------< create_saved_search >-------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: irc_search_criteria_api.create_saved_search
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_saved_search
27 (p_validate in number default hr_api.g_false_num
28 ,p_effective_date in date
29 ,p_person_id in number
30 ,p_search_name in varchar2
31 ,p_location in varchar2 default null
32 ,p_distance_to_location in varchar2 default null
33 ,p_geocode_location in varchar2 default null
34 ,p_geocode_country in varchar2 default null
35 ,p_derived_location in varchar2 default null
36 ,p_location_id in number default null
37 ,p_longitude in number default null
38 ,p_latitude in number default null
39 ,p_employee in varchar2 default null
40 ,p_contractor in varchar2 default null
41 ,p_employment_category in varchar2 default null
42 ,p_keywords in varchar2 default null
43 ,p_travel_percentage in number default null
44 ,p_min_salary in number default null
45 ,p_salary_currency in varchar2 default null
46 ,p_salary_period in varchar2 default null
47 ,p_match_competence in varchar2 default null
48 ,p_match_qualification in varchar2 default null
49 ,p_work_at_home in varchar2 default null
50 ,p_job_title in varchar2 default null
51 ,p_department in varchar2 default null
52 ,p_professional_area in varchar2 default null
53 ,p_use_for_matching in varchar2 default null
54 ,p_description in varchar2 default null
55 ,p_attribute_category in varchar2 default null
56 ,p_attribute1 in varchar2 default null
57 ,p_attribute2 in varchar2 default null
58 ,p_attribute3 in varchar2 default null
59 ,p_attribute4 in varchar2 default null
60 ,p_attribute5 in varchar2 default null
61 ,p_attribute6 in varchar2 default null
62 ,p_attribute7 in varchar2 default null
63 ,p_attribute8 in varchar2 default null
64 ,p_attribute9 in varchar2 default null
65 ,p_attribute10 in varchar2 default null
66 ,p_attribute11 in varchar2 default null
67 ,p_attribute12 in varchar2 default null
68 ,p_attribute13 in varchar2 default null
69 ,p_attribute14 in varchar2 default null
70 ,p_attribute15 in varchar2 default null
71 ,p_attribute16 in varchar2 default null
72 ,p_attribute17 in varchar2 default null
73 ,p_attribute18 in varchar2 default null
74 ,p_attribute19 in varchar2 default null
75 ,p_attribute20 in varchar2 default null
76 ,p_attribute21 in varchar2 default null
77 ,p_attribute22 in varchar2 default null
78 ,p_attribute23 in varchar2 default null
79 ,p_attribute24 in varchar2 default null
80 ,p_attribute25 in varchar2 default null
81 ,p_attribute26 in varchar2 default null
82 ,p_attribute27 in varchar2 default null
83 ,p_attribute28 in varchar2 default null
84 ,p_attribute29 in varchar2 default null
85 ,p_attribute30 in varchar2 default null
86 ,p_isc_information_category in varchar2 default null
87 ,p_isc_information1 in varchar2 default null
88 ,p_isc_information2 in varchar2 default null
89 ,p_isc_information3 in varchar2 default null
90 ,p_isc_information4 in varchar2 default null
91 ,p_isc_information5 in varchar2 default null
92 ,p_isc_information6 in varchar2 default null
93 ,p_isc_information7 in varchar2 default null
94 ,p_isc_information8 in varchar2 default null
95 ,p_isc_information9 in varchar2 default null
96 ,p_isc_information10 in varchar2 default null
97 ,p_isc_information11 in varchar2 default null
98 ,p_isc_information12 in varchar2 default null
99 ,p_isc_information13 in varchar2 default null
100 ,p_isc_information14 in varchar2 default null
101 ,p_isc_information15 in varchar2 default null
102 ,p_isc_information16 in varchar2 default null
103 ,p_isc_information17 in varchar2 default null
104 ,p_isc_information18 in varchar2 default null
105 ,p_isc_information19 in varchar2 default null
106 ,p_isc_information20 in varchar2 default null
107 ,p_isc_information21 in varchar2 default null
108 ,p_isc_information22 in varchar2 default null
109 ,p_isc_information23 in varchar2 default null
110 ,p_isc_information24 in varchar2 default null
111 ,p_isc_information25 in varchar2 default null
112 ,p_isc_information26 in varchar2 default null
113 ,p_isc_information27 in varchar2 default null
114 ,p_isc_information28 in varchar2 default null
115 ,p_isc_information29 in varchar2 default null
116 ,p_isc_information30 in varchar2 default null
117 ,p_date_posted in varchar2 default null
118 ,p_object_version_number out nocopy number
119 ,p_search_criteria_id in number
120 ,p_return_status out nocopy varchar2
121 );
122 -- ----------------------------------------------------------------------------
123 -- |------------------------< create_vacancy_criteria >-----------------------|
124 -- ----------------------------------------------------------------------------
125 -- {Start of comments}
126 --
127 -- Description:
128 -- This procedure is the self-service wrapper procedure to the following
129 -- API: irc_search_criteria_api.create_vacancy_criteria
130 --
131 -- Pre-requisites
132 -- All 'IN' parameters to this procedure have been appropriately derived.
133 --
134 -- Post Success:
135 -- p_return_status will return value indicating success.
136 --
137 -- Post Failure:
138 -- p_return_status will return value indication failure.
139 --
140 -- Access Status:
141 -- Internal Development use only.
142 --
143 -- {End of comments}
144 -- ----------------------------------------------------------------------------
145 PROCEDURE create_vacancy_criteria
146 (p_validate in number default hr_api.g_false_num
147 ,p_vacancy_id in number
148 ,p_effective_date in date
149 ,p_location in varchar2 default null
150 ,p_employee in varchar2 default null
151 ,p_contractor in varchar2 default null
152 ,p_employment_category in varchar2 default null
153 ,p_keywords in varchar2 default null
154 ,p_travel_percentage in number default null
155 ,p_min_salary in number default null
156 ,p_max_salary in number default null
157 ,p_salary_currency in varchar2 default null
158 ,p_salary_period in varchar2 default null
159 ,p_professional_area in varchar2 default null
160 ,p_work_at_home in varchar2 default null
161 ,p_min_qual_level in number default null
162 ,p_max_qual_level in number default null
163 ,p_description in varchar2 default null
164 ,p_attribute_category in varchar2 default null
165 ,p_attribute1 in varchar2 default null
166 ,p_attribute2 in varchar2 default null
167 ,p_attribute3 in varchar2 default null
168 ,p_attribute4 in varchar2 default null
169 ,p_attribute5 in varchar2 default null
170 ,p_attribute6 in varchar2 default null
171 ,p_attribute7 in varchar2 default null
172 ,p_attribute8 in varchar2 default null
173 ,p_attribute9 in varchar2 default null
174 ,p_attribute10 in varchar2 default null
175 ,p_attribute11 in varchar2 default null
176 ,p_attribute12 in varchar2 default null
177 ,p_attribute13 in varchar2 default null
178 ,p_attribute14 in varchar2 default null
179 ,p_attribute15 in varchar2 default null
180 ,p_attribute16 in varchar2 default null
181 ,p_attribute17 in varchar2 default null
182 ,p_attribute18 in varchar2 default null
183 ,p_attribute19 in varchar2 default null
184 ,p_attribute20 in varchar2 default null
185 ,p_attribute21 in varchar2 default null
186 ,p_attribute22 in varchar2 default null
187 ,p_attribute23 in varchar2 default null
188 ,p_attribute24 in varchar2 default null
189 ,p_attribute25 in varchar2 default null
190 ,p_attribute26 in varchar2 default null
191 ,p_attribute27 in varchar2 default null
192 ,p_attribute28 in varchar2 default null
193 ,p_attribute29 in varchar2 default null
194 ,p_attribute30 in varchar2 default null
195 ,p_isc_information_category in varchar2 default null
196 ,p_isc_information1 in varchar2 default null
197 ,p_isc_information2 in varchar2 default null
198 ,p_isc_information3 in varchar2 default null
199 ,p_isc_information4 in varchar2 default null
200 ,p_isc_information5 in varchar2 default null
201 ,p_isc_information6 in varchar2 default null
202 ,p_isc_information7 in varchar2 default null
203 ,p_isc_information8 in varchar2 default null
204 ,p_isc_information9 in varchar2 default null
205 ,p_isc_information10 in varchar2 default null
206 ,p_isc_information11 in varchar2 default null
207 ,p_isc_information12 in varchar2 default null
208 ,p_isc_information13 in varchar2 default null
209 ,p_isc_information14 in varchar2 default null
210 ,p_isc_information15 in varchar2 default null
211 ,p_isc_information16 in varchar2 default null
212 ,p_isc_information17 in varchar2 default null
213 ,p_isc_information18 in varchar2 default null
214 ,p_isc_information19 in varchar2 default null
215 ,p_isc_information20 in varchar2 default null
216 ,p_isc_information21 in varchar2 default null
217 ,p_isc_information22 in varchar2 default null
218 ,p_isc_information23 in varchar2 default null
219 ,p_isc_information24 in varchar2 default null
220 ,p_isc_information25 in varchar2 default null
221 ,p_isc_information26 in varchar2 default null
222 ,p_isc_information27 in varchar2 default null
223 ,p_isc_information28 in varchar2 default null
224 ,p_isc_information29 in varchar2 default null
225 ,p_isc_information30 in varchar2 default null
226 ,p_object_version_number out nocopy number
227 ,p_search_criteria_id in number
228 ,p_return_status out nocopy varchar2
229 );
230 -- ----------------------------------------------------------------------------
231 -- |--------------------------< delete_saved_search >-------------------------|
232 -- ----------------------------------------------------------------------------
233 -- {Start of comments}
234 --
235 -- Description:
236 -- This procedure is the self-service wrapper procedure to the following
237 -- API: irc_search_criteria_api.delete_saved_search
238 --
239 -- Pre-requisites
240 -- All 'IN' parameters to this procedure have been appropriately derived.
241 --
242 -- Post Success:
243 -- p_return_status will return value indicating success.
244 --
245 -- Post Failure:
246 -- p_return_status will return value indication failure.
247 --
248 -- Access Status:
249 -- Internal Development use only.
250 --
251 -- {End of comments}
252 -- ----------------------------------------------------------------------------
253 PROCEDURE delete_saved_search
254 (p_validate in number default hr_api.g_false_num
255 ,p_search_criteria_id in number
256 ,p_object_version_number in number
257 ,p_return_status out nocopy varchar2
258 );
259 -- ----------------------------------------------------------------------------
260 -- |------------------------< delete_vacancy_criteria >-----------------------|
261 -- ----------------------------------------------------------------------------
262 -- {Start of comments}
263 --
264 -- Description:
265 -- This procedure is the self-service wrapper procedure to the following
266 -- API: irc_search_criteria_api.delete_vacancy_criteria
267 --
268 -- Pre-requisites
269 -- All 'IN' parameters to this procedure have been appropriately derived.
270 --
271 -- Post Success:
272 -- p_return_status will return value indicating success.
273 --
274 -- Post Failure:
275 -- p_return_status will return value indication failure.
276 --
277 -- Access Status:
278 -- Internal Development use only.
279 --
280 -- {End of comments}
281 -- ----------------------------------------------------------------------------
282 PROCEDURE delete_vacancy_criteria
283 (p_validate in number default hr_api.g_false_num
284 ,p_search_criteria_id in number
285 ,p_object_version_number in number
286 ,p_return_status out nocopy varchar2
287 );
288 -- ----------------------------------------------------------------------------
289 -- |--------------------------< update_saved_search >-------------------------|
290 -- ----------------------------------------------------------------------------
291 -- {Start of comments}
292 --
293 -- Description:
294 -- This procedure is the self-service wrapper procedure to the following
295 -- API: irc_search_criteria_api.update_saved_search
296 --
297 -- Pre-requisites
298 -- All 'IN' parameters to this procedure have been appropriately derived.
299 --
300 -- Post Success:
301 -- p_return_status will return value indicating success.
302 --
303 -- Post Failure:
304 -- p_return_status will return value indication failure.
305 --
306 -- Access Status:
307 -- Internal Development use only.
308 --
309 -- {End of comments}
310 -- ----------------------------------------------------------------------------
311 PROCEDURE update_saved_search
315 ,p_person_id in number default hr_api.g_number
312 (p_validate in number default hr_api.g_false_num
313 ,p_effective_date in date
314 ,p_search_criteria_id in number
316 ,p_search_name in varchar2 default hr_api.g_varchar2
317 ,p_location in varchar2 default hr_api.g_varchar2
318 ,p_distance_to_location in varchar2 default hr_api.g_varchar2
319 ,p_geocode_location in varchar2 default hr_api.g_varchar2
320 ,p_geocode_country in varchar2 default hr_api.g_varchar2
321 ,p_derived_location in varchar2 default hr_api.g_varchar2
322 ,p_location_id in number default hr_api.g_number
323 ,p_longitude in number default hr_api.g_number
324 ,p_latitude in number default hr_api.g_number
325 ,p_employee in varchar2 default hr_api.g_varchar2
326 ,p_contractor in varchar2 default hr_api.g_varchar2
327 ,p_employment_category in varchar2 default hr_api.g_varchar2
328 ,p_keywords in varchar2 default hr_api.g_varchar2
329 ,p_travel_percentage in number default hr_api.g_number
330 ,p_min_salary in number default hr_api.g_number
331 ,p_salary_currency in varchar2 default hr_api.g_varchar2
332 ,p_salary_period in varchar2 default hr_api.g_varchar2
333 ,p_match_competence in varchar2 default hr_api.g_varchar2
334 ,p_match_qualification in varchar2 default hr_api.g_varchar2
335 ,p_work_at_home in varchar2 default hr_api.g_varchar2
336 ,p_job_title in varchar2 default hr_api.g_varchar2
337 ,p_department in varchar2 default hr_api.g_varchar2
338 ,p_professional_area in varchar2 default hr_api.g_varchar2
339 ,p_use_for_matching in varchar2 default hr_api.g_varchar2
340 ,p_description in varchar2 default hr_api.g_varchar2
341 ,p_attribute_category in varchar2 default hr_api.g_varchar2
342 ,p_attribute1 in varchar2 default hr_api.g_varchar2
343 ,p_attribute2 in varchar2 default hr_api.g_varchar2
344 ,p_attribute3 in varchar2 default hr_api.g_varchar2
345 ,p_attribute4 in varchar2 default hr_api.g_varchar2
346 ,p_attribute5 in varchar2 default hr_api.g_varchar2
347 ,p_attribute6 in varchar2 default hr_api.g_varchar2
348 ,p_attribute7 in varchar2 default hr_api.g_varchar2
349 ,p_attribute8 in varchar2 default hr_api.g_varchar2
350 ,p_attribute9 in varchar2 default hr_api.g_varchar2
351 ,p_attribute10 in varchar2 default hr_api.g_varchar2
352 ,p_attribute11 in varchar2 default hr_api.g_varchar2
353 ,p_attribute12 in varchar2 default hr_api.g_varchar2
354 ,p_attribute13 in varchar2 default hr_api.g_varchar2
355 ,p_attribute14 in varchar2 default hr_api.g_varchar2
356 ,p_attribute15 in varchar2 default hr_api.g_varchar2
357 ,p_attribute16 in varchar2 default hr_api.g_varchar2
358 ,p_attribute17 in varchar2 default hr_api.g_varchar2
359 ,p_attribute18 in varchar2 default hr_api.g_varchar2
360 ,p_attribute19 in varchar2 default hr_api.g_varchar2
361 ,p_attribute20 in varchar2 default hr_api.g_varchar2
362 ,p_attribute21 in varchar2 default hr_api.g_varchar2
363 ,p_attribute22 in varchar2 default hr_api.g_varchar2
364 ,p_attribute23 in varchar2 default hr_api.g_varchar2
365 ,p_attribute24 in varchar2 default hr_api.g_varchar2
366 ,p_attribute25 in varchar2 default hr_api.g_varchar2
367 ,p_attribute26 in varchar2 default hr_api.g_varchar2
368 ,p_attribute27 in varchar2 default hr_api.g_varchar2
369 ,p_attribute28 in varchar2 default hr_api.g_varchar2
370 ,p_attribute29 in varchar2 default hr_api.g_varchar2
371 ,p_attribute30 in varchar2 default hr_api.g_varchar2
372 ,p_isc_information_category in varchar2 default hr_api.g_varchar2
373 ,p_isc_information1 in varchar2 default hr_api.g_varchar2
374 ,p_isc_information2 in varchar2 default hr_api.g_varchar2
375 ,p_isc_information3 in varchar2 default hr_api.g_varchar2
376 ,p_isc_information4 in varchar2 default hr_api.g_varchar2
377 ,p_isc_information5 in varchar2 default hr_api.g_varchar2
378 ,p_isc_information6 in varchar2 default hr_api.g_varchar2
379 ,p_isc_information7 in varchar2 default hr_api.g_varchar2
380 ,p_isc_information8 in varchar2 default hr_api.g_varchar2
381 ,p_isc_information9 in varchar2 default hr_api.g_varchar2
382 ,p_isc_information10 in varchar2 default hr_api.g_varchar2
383 ,p_isc_information11 in varchar2 default hr_api.g_varchar2
384 ,p_isc_information12 in varchar2 default hr_api.g_varchar2
385 ,p_isc_information13 in varchar2 default hr_api.g_varchar2
386 ,p_isc_information14 in varchar2 default hr_api.g_varchar2
390 ,p_isc_information18 in varchar2 default hr_api.g_varchar2
387 ,p_isc_information15 in varchar2 default hr_api.g_varchar2
388 ,p_isc_information16 in varchar2 default hr_api.g_varchar2
389 ,p_isc_information17 in varchar2 default hr_api.g_varchar2
391 ,p_isc_information19 in varchar2 default hr_api.g_varchar2
392 ,p_isc_information20 in varchar2 default hr_api.g_varchar2
393 ,p_isc_information21 in varchar2 default hr_api.g_varchar2
394 ,p_isc_information22 in varchar2 default hr_api.g_varchar2
395 ,p_isc_information23 in varchar2 default hr_api.g_varchar2
396 ,p_isc_information24 in varchar2 default hr_api.g_varchar2
397 ,p_isc_information25 in varchar2 default hr_api.g_varchar2
398 ,p_isc_information26 in varchar2 default hr_api.g_varchar2
399 ,p_isc_information27 in varchar2 default hr_api.g_varchar2
400 ,p_isc_information28 in varchar2 default hr_api.g_varchar2
401 ,p_isc_information29 in varchar2 default hr_api.g_varchar2
402 ,p_isc_information30 in varchar2 default hr_api.g_varchar2
403 ,p_date_posted in varchar2 default hr_api.g_varchar2
404 ,p_object_version_number in out nocopy number
405 ,p_return_status out nocopy varchar2
406 );
407 -- ----------------------------------------------------------------------------
408 -- |------------------------< update_vacancy_criteria >-----------------------|
409 -- ----------------------------------------------------------------------------
410 -- {Start of comments}
411 --
412 -- Description:
413 -- This procedure is the self-service wrapper procedure to the following
414 -- API: irc_search_criteria_api.update_vacancy_criteria
415 --
416 -- Pre-requisites
417 -- All 'IN' parameters to this procedure have been appropriately derived.
418 --
419 -- Post Success:
420 -- p_return_status will return value indicating success.
421 --
422 -- Post Failure:
423 -- p_return_status will return value indication failure.
424 --
425 -- Access Status:
426 -- Internal Development use only.
427 --
428 -- {End of comments}
429 -- ----------------------------------------------------------------------------
430 PROCEDURE update_vacancy_criteria
431 (p_validate in number default hr_api.g_false_num
432 ,p_search_criteria_id in number
433 ,p_vacancy_id in number default hr_api.g_number
434 ,p_effective_date in date
435 ,p_location in varchar2 default hr_api.g_varchar2
436 ,p_employee in varchar2 default hr_api.g_varchar2
437 ,p_contractor in varchar2 default hr_api.g_varchar2
438 ,p_employment_category in varchar2 default hr_api.g_varchar2
439 ,p_keywords in varchar2 default hr_api.g_varchar2
440 ,p_travel_percentage in number default hr_api.g_number
441 ,p_min_salary in number default hr_api.g_number
442 ,p_max_salary in number default hr_api.g_number
443 ,p_salary_currency in varchar2 default hr_api.g_varchar2
444 ,p_salary_period in varchar2 default hr_api.g_varchar2
445 ,p_professional_area in varchar2 default hr_api.g_varchar2
446 ,p_work_at_home in varchar2 default hr_api.g_varchar2
447 ,p_min_qual_level in number default hr_api.g_number
448 ,p_max_qual_level in number default hr_api.g_number
449 ,p_description in varchar2 default hr_api.g_varchar2
450 ,p_attribute_category in varchar2 default hr_api.g_varchar2
451 ,p_attribute1 in varchar2 default hr_api.g_varchar2
452 ,p_attribute2 in varchar2 default hr_api.g_varchar2
453 ,p_attribute3 in varchar2 default hr_api.g_varchar2
454 ,p_attribute4 in varchar2 default hr_api.g_varchar2
455 ,p_attribute5 in varchar2 default hr_api.g_varchar2
456 ,p_attribute6 in varchar2 default hr_api.g_varchar2
457 ,p_attribute7 in varchar2 default hr_api.g_varchar2
458 ,p_attribute8 in varchar2 default hr_api.g_varchar2
459 ,p_attribute9 in varchar2 default hr_api.g_varchar2
460 ,p_attribute10 in varchar2 default hr_api.g_varchar2
461 ,p_attribute11 in varchar2 default hr_api.g_varchar2
462 ,p_attribute12 in varchar2 default hr_api.g_varchar2
463 ,p_attribute13 in varchar2 default hr_api.g_varchar2
464 ,p_attribute14 in varchar2 default hr_api.g_varchar2
465 ,p_attribute15 in varchar2 default hr_api.g_varchar2
466 ,p_attribute16 in varchar2 default hr_api.g_varchar2
467 ,p_attribute17 in varchar2 default hr_api.g_varchar2
468 ,p_attribute18 in varchar2 default hr_api.g_varchar2
469 ,p_attribute19 in varchar2 default hr_api.g_varchar2
470 ,p_attribute20 in varchar2 default hr_api.g_varchar2
471 ,p_attribute21 in varchar2 default hr_api.g_varchar2
472 ,p_attribute22 in varchar2 default hr_api.g_varchar2
473 ,p_attribute23 in varchar2 default hr_api.g_varchar2
474 ,p_attribute24 in varchar2 default hr_api.g_varchar2
478 ,p_attribute28 in varchar2 default hr_api.g_varchar2
475 ,p_attribute25 in varchar2 default hr_api.g_varchar2
476 ,p_attribute26 in varchar2 default hr_api.g_varchar2
477 ,p_attribute27 in varchar2 default hr_api.g_varchar2
479 ,p_attribute29 in varchar2 default hr_api.g_varchar2
480 ,p_attribute30 in varchar2 default hr_api.g_varchar2
481 ,p_isc_information_category in varchar2 default hr_api.g_varchar2
482 ,p_isc_information1 in varchar2 default hr_api.g_varchar2
483 ,p_isc_information2 in varchar2 default hr_api.g_varchar2
484 ,p_isc_information3 in varchar2 default hr_api.g_varchar2
485 ,p_isc_information4 in varchar2 default hr_api.g_varchar2
486 ,p_isc_information5 in varchar2 default hr_api.g_varchar2
487 ,p_isc_information6 in varchar2 default hr_api.g_varchar2
488 ,p_isc_information7 in varchar2 default hr_api.g_varchar2
489 ,p_isc_information8 in varchar2 default hr_api.g_varchar2
490 ,p_isc_information9 in varchar2 default hr_api.g_varchar2
491 ,p_isc_information10 in varchar2 default hr_api.g_varchar2
492 ,p_isc_information11 in varchar2 default hr_api.g_varchar2
493 ,p_isc_information12 in varchar2 default hr_api.g_varchar2
494 ,p_isc_information13 in varchar2 default hr_api.g_varchar2
495 ,p_isc_information14 in varchar2 default hr_api.g_varchar2
496 ,p_isc_information15 in varchar2 default hr_api.g_varchar2
497 ,p_isc_information16 in varchar2 default hr_api.g_varchar2
498 ,p_isc_information17 in varchar2 default hr_api.g_varchar2
499 ,p_isc_information18 in varchar2 default hr_api.g_varchar2
500 ,p_isc_information19 in varchar2 default hr_api.g_varchar2
501 ,p_isc_information20 in varchar2 default hr_api.g_varchar2
502 ,p_isc_information21 in varchar2 default hr_api.g_varchar2
503 ,p_isc_information22 in varchar2 default hr_api.g_varchar2
504 ,p_isc_information23 in varchar2 default hr_api.g_varchar2
505 ,p_isc_information24 in varchar2 default hr_api.g_varchar2
506 ,p_isc_information25 in varchar2 default hr_api.g_varchar2
507 ,p_isc_information26 in varchar2 default hr_api.g_varchar2
508 ,p_isc_information27 in varchar2 default hr_api.g_varchar2
509 ,p_isc_information28 in varchar2 default hr_api.g_varchar2
510 ,p_isc_information29 in varchar2 default hr_api.g_varchar2
511 ,p_isc_information30 in varchar2 default hr_api.g_varchar2
512 ,p_object_version_number in out nocopy number
513 ,p_return_status out nocopy varchar2
514 );
515 --
516 -- ----------------------------------------------------------------------------
517 -- |--------------------------< create_work_choices >-------------------------|
518 -- ----------------------------------------------------------------------------
519 -- {Start of comments}
520 --
521 -- Description:
522 -- This procedure is the self-service wrapper procedure to the following
523 -- API: irc_search_criteria_api.create_work_choices
524 --
525 -- Pre-requisites
526 -- All 'IN' parameters to this procedure have been appropriately derived.
527 --
528 -- Post Success:
529 -- p_return_status will return value indicating success.
530 --
531 -- Post Failure:
532 -- p_return_status will return value indication failure.
533 --
534 -- Access Status:
535 -- Internal Development use only.
536 --
537 -- {End of comments}
538 -- ----------------------------------------------------------------------------
539 PROCEDURE create_work_choices
540 (p_validate in number default hr_api.g_false_num
541 ,p_effective_date in date
542 ,p_person_id in number
543 ,p_location in varchar2 default null
544 ,p_distance_to_location in varchar2 default null
545 ,p_geocode_location in varchar2 default null
546 ,p_geocode_country in varchar2 default null
547 ,p_derived_location in varchar2 default null
548 ,p_location_id in number default null
549 ,p_longitude in number default null
550 ,p_latitude in number default null
551 ,p_employee in varchar2 default null
552 ,p_contractor in varchar2 default null
553 ,p_employment_category in varchar2 default null
554 ,p_keywords in varchar2 default null
555 ,p_travel_percentage in number default null
556 ,p_min_salary in number default null
557 ,p_salary_currency in varchar2 default null
558 ,p_salary_period in varchar2 default null
559 ,p_match_competence in varchar2 default null
560 ,p_match_qualification in varchar2 default null
561 ,p_work_at_home in varchar2 default null
562 ,p_job_title in varchar2 default null
563 ,p_department in varchar2 default null
564 ,p_professional_area in varchar2 default null
568 ,p_attribute2 in varchar2 default null
565 ,p_description in varchar2 default null
566 ,p_attribute_category in varchar2 default null
567 ,p_attribute1 in varchar2 default null
569 ,p_attribute3 in varchar2 default null
570 ,p_attribute4 in varchar2 default null
571 ,p_attribute5 in varchar2 default null
572 ,p_attribute6 in varchar2 default null
573 ,p_attribute7 in varchar2 default null
574 ,p_attribute8 in varchar2 default null
575 ,p_attribute9 in varchar2 default null
576 ,p_attribute10 in varchar2 default null
577 ,p_attribute11 in varchar2 default null
578 ,p_attribute12 in varchar2 default null
579 ,p_attribute13 in varchar2 default null
580 ,p_attribute14 in varchar2 default null
581 ,p_attribute15 in varchar2 default null
582 ,p_attribute16 in varchar2 default null
583 ,p_attribute17 in varchar2 default null
584 ,p_attribute18 in varchar2 default null
585 ,p_attribute19 in varchar2 default null
586 ,p_attribute20 in varchar2 default null
587 ,p_attribute21 in varchar2 default null
588 ,p_attribute22 in varchar2 default null
589 ,p_attribute23 in varchar2 default null
590 ,p_attribute24 in varchar2 default null
591 ,p_attribute25 in varchar2 default null
592 ,p_attribute26 in varchar2 default null
593 ,p_attribute27 in varchar2 default null
594 ,p_attribute28 in varchar2 default null
595 ,p_attribute29 in varchar2 default null
596 ,p_attribute30 in varchar2 default null
597 ,p_isc_information_category in varchar2 default null
598 ,p_isc_information1 in varchar2 default null
599 ,p_isc_information2 in varchar2 default null
600 ,p_isc_information3 in varchar2 default null
601 ,p_isc_information4 in varchar2 default null
602 ,p_isc_information5 in varchar2 default null
603 ,p_isc_information6 in varchar2 default null
604 ,p_isc_information7 in varchar2 default null
605 ,p_isc_information8 in varchar2 default null
606 ,p_isc_information9 in varchar2 default null
607 ,p_isc_information10 in varchar2 default null
608 ,p_isc_information11 in varchar2 default null
609 ,p_isc_information12 in varchar2 default null
610 ,p_isc_information13 in varchar2 default null
611 ,p_isc_information14 in varchar2 default null
612 ,p_isc_information15 in varchar2 default null
613 ,p_isc_information16 in varchar2 default null
614 ,p_isc_information17 in varchar2 default null
615 ,p_isc_information18 in varchar2 default null
616 ,p_isc_information19 in varchar2 default null
617 ,p_isc_information20 in varchar2 default null
618 ,p_isc_information21 in varchar2 default null
619 ,p_isc_information22 in varchar2 default null
620 ,p_isc_information23 in varchar2 default null
621 ,p_isc_information24 in varchar2 default null
622 ,p_isc_information25 in varchar2 default null
623 ,p_isc_information26 in varchar2 default null
624 ,p_isc_information27 in varchar2 default null
625 ,p_isc_information28 in varchar2 default null
626 ,p_isc_information29 in varchar2 default null
627 ,p_isc_information30 in varchar2 default null
628 ,p_object_version_number out nocopy number
629 ,p_search_criteria_id in number
630 ,p_return_status out nocopy varchar2
631 );
632 -- ----------------------------------------------------------------------------
633 -- |--------------------------< delete_work_choices >-------------------------|
634 -- ----------------------------------------------------------------------------
635 -- {Start of comments}
636 --
637 -- Description:
638 -- This procedure is the self-service wrapper procedure to the following
639 -- API: irc_search_criteria_api.delete_work_choices
640 --
641 -- Pre-requisites
642 -- All 'IN' parameters to this procedure have been appropriately derived.
643 --
644 -- Post Success:
645 -- p_return_status will return value indicating success.
646 --
647 -- Post Failure:
648 -- p_return_status will return value indication failure.
649 --
650 -- Access Status:
651 -- Internal Development use only.
652 --
653 -- {End of comments}
654 -- ----------------------------------------------------------------------------
655 PROCEDURE delete_work_choices
656 (p_validate in number default hr_api.g_false_num
657 ,p_search_criteria_id in number
658 ,p_object_version_number in number
659 ,p_return_status out nocopy varchar2
660 );
661 -- ----------------------------------------------------------------------------
665 --
662 -- |--------------------------< update_work_choices >-------------------------|
663 -- ----------------------------------------------------------------------------
664 -- {Start of comments}
666 -- Description:
667 -- This procedure is the self-service wrapper procedure to the following
668 -- API: irc_search_criteria_api.update_work_choices
669 --
670 -- Pre-requisites
671 -- All 'IN' parameters to this procedure have been appropriately derived.
672 --
673 -- Post Success:
674 -- p_return_status will return value indicating success.
675 --
676 -- Post Failure:
677 -- p_return_status will return value indication failure.
678 --
679 -- Access Status:
680 -- Internal Development use only.
681 --
682 -- {End of comments}
683 -- ----------------------------------------------------------------------------
684 PROCEDURE update_work_choices
685 (p_validate in number default hr_api.g_false_num
686 ,p_effective_date in date
687 ,p_search_criteria_id in number
688 ,p_location in varchar2 default hr_api.g_varchar2
689 ,p_distance_to_location in varchar2 default hr_api.g_varchar2
690 ,p_geocode_location in varchar2 default hr_api.g_varchar2
691 ,p_geocode_country in varchar2 default hr_api.g_varchar2
692 ,p_derived_location in varchar2 default hr_api.g_varchar2
693 ,p_location_id in number default hr_api.g_number
694 ,p_longitude in number default hr_api.g_number
695 ,p_latitude in number default hr_api.g_number
696 ,p_employee in varchar2 default hr_api.g_varchar2
697 ,p_contractor in varchar2 default hr_api.g_varchar2
698 ,p_employment_category in varchar2 default hr_api.g_varchar2
699 ,p_keywords in varchar2 default hr_api.g_varchar2
700 ,p_travel_percentage in number default hr_api.g_number
701 ,p_min_salary in number default hr_api.g_number
702 ,p_salary_currency in varchar2 default hr_api.g_varchar2
703 ,p_salary_period in varchar2 default hr_api.g_varchar2
704 ,p_match_competence in varchar2 default hr_api.g_varchar2
705 ,p_match_qualification in varchar2 default hr_api.g_varchar2
706 ,p_work_at_home in varchar2 default hr_api.g_varchar2
707 ,p_job_title in varchar2 default hr_api.g_varchar2
708 ,p_department in varchar2 default hr_api.g_varchar2
709 ,p_professional_area in varchar2 default hr_api.g_varchar2
710 ,p_description in varchar2 default hr_api.g_varchar2
711 ,p_attribute_category in varchar2 default hr_api.g_varchar2
712 ,p_attribute1 in varchar2 default hr_api.g_varchar2
713 ,p_attribute2 in varchar2 default hr_api.g_varchar2
714 ,p_attribute3 in varchar2 default hr_api.g_varchar2
715 ,p_attribute4 in varchar2 default hr_api.g_varchar2
716 ,p_attribute5 in varchar2 default hr_api.g_varchar2
717 ,p_attribute6 in varchar2 default hr_api.g_varchar2
718 ,p_attribute7 in varchar2 default hr_api.g_varchar2
719 ,p_attribute8 in varchar2 default hr_api.g_varchar2
720 ,p_attribute9 in varchar2 default hr_api.g_varchar2
721 ,p_attribute10 in varchar2 default hr_api.g_varchar2
722 ,p_attribute11 in varchar2 default hr_api.g_varchar2
723 ,p_attribute12 in varchar2 default hr_api.g_varchar2
724 ,p_attribute13 in varchar2 default hr_api.g_varchar2
725 ,p_attribute14 in varchar2 default hr_api.g_varchar2
726 ,p_attribute15 in varchar2 default hr_api.g_varchar2
727 ,p_attribute16 in varchar2 default hr_api.g_varchar2
728 ,p_attribute17 in varchar2 default hr_api.g_varchar2
729 ,p_attribute18 in varchar2 default hr_api.g_varchar2
730 ,p_attribute19 in varchar2 default hr_api.g_varchar2
731 ,p_attribute20 in varchar2 default hr_api.g_varchar2
732 ,p_attribute21 in varchar2 default hr_api.g_varchar2
733 ,p_attribute22 in varchar2 default hr_api.g_varchar2
734 ,p_attribute23 in varchar2 default hr_api.g_varchar2
735 ,p_attribute24 in varchar2 default hr_api.g_varchar2
736 ,p_attribute25 in varchar2 default hr_api.g_varchar2
737 ,p_attribute26 in varchar2 default hr_api.g_varchar2
738 ,p_attribute27 in varchar2 default hr_api.g_varchar2
739 ,p_attribute28 in varchar2 default hr_api.g_varchar2
740 ,p_attribute29 in varchar2 default hr_api.g_varchar2
741 ,p_attribute30 in varchar2 default hr_api.g_varchar2
742 ,p_isc_information_category in varchar2 default hr_api.g_varchar2
743 ,p_isc_information1 in varchar2 default hr_api.g_varchar2
744 ,p_isc_information2 in varchar2 default hr_api.g_varchar2
745 ,p_isc_information3 in varchar2 default hr_api.g_varchar2
746 ,p_isc_information4 in varchar2 default hr_api.g_varchar2
747 ,p_isc_information5 in varchar2 default hr_api.g_varchar2
748 ,p_isc_information6 in varchar2 default hr_api.g_varchar2
749 ,p_isc_information7 in varchar2 default hr_api.g_varchar2
750 ,p_isc_information8 in varchar2 default hr_api.g_varchar2
751 ,p_isc_information9 in varchar2 default hr_api.g_varchar2
752 ,p_isc_information10 in varchar2 default hr_api.g_varchar2
753 ,p_isc_information11 in varchar2 default hr_api.g_varchar2
754 ,p_isc_information12 in varchar2 default hr_api.g_varchar2
755 ,p_isc_information13 in varchar2 default hr_api.g_varchar2
756 ,p_isc_information14 in varchar2 default hr_api.g_varchar2
757 ,p_isc_information15 in varchar2 default hr_api.g_varchar2
758 ,p_isc_information16 in varchar2 default hr_api.g_varchar2
759 ,p_isc_information17 in varchar2 default hr_api.g_varchar2
760 ,p_isc_information18 in varchar2 default hr_api.g_varchar2
761 ,p_isc_information19 in varchar2 default hr_api.g_varchar2
762 ,p_isc_information20 in varchar2 default hr_api.g_varchar2
763 ,p_isc_information21 in varchar2 default hr_api.g_varchar2
764 ,p_isc_information22 in varchar2 default hr_api.g_varchar2
765 ,p_isc_information23 in varchar2 default hr_api.g_varchar2
766 ,p_isc_information24 in varchar2 default hr_api.g_varchar2
767 ,p_isc_information25 in varchar2 default hr_api.g_varchar2
768 ,p_isc_information26 in varchar2 default hr_api.g_varchar2
769 ,p_isc_information27 in varchar2 default hr_api.g_varchar2
770 ,p_isc_information28 in varchar2 default hr_api.g_varchar2
771 ,p_isc_information29 in varchar2 default hr_api.g_varchar2
772 ,p_isc_information30 in varchar2 default hr_api.g_varchar2
773 ,p_object_version_number in out nocopy number
774 ,p_return_status out nocopy varchar2
775 );
776 --
777 procedure process_vacancy_api
778 (
779 p_document in CLOB
780 ,p_return_status out nocopy VARCHAR2
781 ,p_validate in number default hr_api.g_false_num
782 ,p_effective_date in date default null
783 );
784 --
785 end irc_search_criteria_swi;