1 Package IRC_SEARCH_CRITERIA_API AUTHID CURRENT_USER as
2 /* $Header: iriscapi.pkh 120.2 2008/02/21 14:24:29 viviswan noship $ */
3 /*#
4 * This package contains APIs for work preferences, job searches and vacancy
5 * criteria.
6 * @rep:scope public
7 * @rep:product irc
8 * @rep:displayname Search Criteria
9 */
10 --
11 -- ----------------------------------------------------------------------------
12 -- |---------------------------< create_saved_search >------------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- {Start Of Comments}
16 /*#
17 * This API stores a saved job search for a candidate.
18 *
19 * The saved search may be used by the candidate to repeatedly search for jobs
20 * with the same criteria.
21 *
22 * <p><b>Licensing</b><br>
23 * This API is licensed for use with iRecruitment.
24 *
25 * <p><b>Prerequisites</b><br>
26 * The person must exist
27 *
28 * <p><b>Post Success</b><br>
29 * The saved search will be created in the database
30 *
31 * <p><b>Post Failure</b><br>
32 * The saved search will not be created in the database and an error will be
33 * raised
34 * @param p_validate If true, then validation alone will be performed and the
35 * database will remain unchanged. If false and all validation checks pass,
36 * then the database will be modified.
37 * @param p_effective_date Reference date for validating lookup values are
38 * applicable during the start to end active date range. This date does not
39 * determine when the changes take effect.
40 * @param p_person_id Identifies the person for whom you create the saved job
41 * search record.
42 * @param p_search_name Name of saved search
43 * @param p_location Free text location a person is interested in
44 * @param p_distance_to_location Distance in miles the user is willing to
45 * travel to work.
46 * @param p_geocode_location Location for a geocode search
47 * @param p_geocode_country Country for a geocode search
48 * @param p_derived_location Exact derived locale to match on
49 * @param p_location_id Identifies a location to match on
50 * @param p_longitude Longitude for a geocode search
51 * @param p_latitude Latitude for a geocode search
52 * @param p_employee Indicates that the candidate is looking for an employee
53 * job (Y or N)
54 * @param p_contractor Indicates that the candidate is looking for a contract
55 * job (Y or N)
56 * @param p_employment_category Indicates whether the candidate is looking for
57 * a full time or part time job (FULLTIME, PARTTIME or EITHER)
58 * @param p_keywords Free text keywords for the search
59 * @param p_travel_percentage Percentage of time a person is willing to spend
60 * travelling. Valid values are defined by 'IRC_TRAVEL_PERCENTAGE' lookup type.
61 * @param p_min_salary Minimum salary user is willing to accept.
62 * @param p_salary_currency Salary currency
63 * @param p_salary_period Salary period. Valid values are defined by
64 * 'PAY_BASIS' lookup type.
65 * @param p_match_competence Identifies if user wishes to match jobs against
66 * the competencies he has entered (Y or N)
67 * @param p_match_qualification Identifies if user wishes to match jobs against
68 * the qualification he has entered (Y or N)
69 * @param p_work_at_home Indicates how desirable it is to work at home. Valid
70 * values are defined by 'IRC_WORK_AT_HOME' lookup type.
71 * @param p_job_title Title of job the user wishes to be included in search.
72 * @param p_department Reserved for future use
73 * @param p_professional_area Professional area user wishes to work in. Valid
77 * @param p_description Search Description
74 * values are defined by 'IRC_PROFESSIONAL_AREA' lookup type.
75 * @param p_use_for_matching Indicated whether a saved search is to be used for
76 * job matching purposes (Y or N)
78 * @param p_attribute_category This context value determines which flexfield
79 * structure to use with the descriptive flexfield segments.
80 * @param p_attribute1 Descriptive flexfield segment.
81 * @param p_attribute2 Descriptive flexfield segment.
82 * @param p_attribute3 Descriptive flexfield segment.
83 * @param p_attribute4 Descriptive flexfield segment.
84 * @param p_attribute5 Descriptive flexfield segment.
85 * @param p_attribute6 Descriptive flexfield segment.
86 * @param p_attribute7 Descriptive flexfield segment.
87 * @param p_attribute8 Descriptive flexfield segment.
88 * @param p_attribute9 Descriptive flexfield segment.
89 * @param p_attribute10 Descriptive flexfield segment.
90 * @param p_attribute11 Descriptive flexfield segment.
91 * @param p_attribute12 Descriptive flexfield segment.
92 * @param p_attribute13 Descriptive flexfield segment.
93 * @param p_attribute14 Descriptive flexfield segment.
94 * @param p_attribute15 Descriptive flexfield segment.
95 * @param p_attribute16 Descriptive flexfield segment.
96 * @param p_attribute17 Descriptive flexfield segment.
97 * @param p_attribute18 Descriptive flexfield segment.
98 * @param p_attribute19 Descriptive flexfield segment.
99 * @param p_attribute20 Descriptive flexfield segment.
100 * @param p_attribute21 Descriptive flexfield segment.
101 * @param p_attribute22 Descriptive flexfield segment.
102 * @param p_attribute23 Descriptive flexfield segment.
103 * @param p_attribute24 Descriptive flexfield segment.
104 * @param p_attribute25 Descriptive flexfield segment.
105 * @param p_attribute26 Descriptive flexfield segment.
106 * @param p_attribute27 Descriptive flexfield segment.
107 * @param p_attribute28 Descriptive flexfield segment.
108 * @param p_attribute29 Descriptive flexfield segment.
109 * @param p_attribute30 Descriptive flexfield segment.
110 * @param p_isc_information_category Developer Descriptive flexfield segment.
111 * @param p_isc_information1 Developer Descriptive flexfield segment.
112 * @param p_isc_information2 Developer Descriptive flexfield segment.
113 * @param p_isc_information3 Developer Descriptive flexfield segment.
114 * @param p_isc_information4 Developer Descriptive flexfield segment.
115 * @param p_isc_information5 Developer Descriptive flexfield segment.
116 * @param p_isc_information6 Developer Descriptive flexfield segment.
117 * @param p_isc_information7 Developer Descriptive flexfield segment.
118 * @param p_isc_information8 Developer Descriptive flexfield segment.
119 * @param p_isc_information9 Developer Descriptive flexfield segment.
120 * @param p_isc_information10 Developer Descriptive flexfield segment.
121 * @param p_isc_information11 Developer Descriptive flexfield segment.
122 * @param p_isc_information12 Developer Descriptive flexfield segment.
123 * @param p_isc_information13 Developer Descriptive flexfield segment.
124 * @param p_isc_information14 Developer Descriptive flexfield segment.
125 * @param p_isc_information15 Developer Descriptive flexfield segment.
126 * @param p_isc_information16 Developer Descriptive flexfield segment.
127 * @param p_isc_information17 Developer Descriptive flexfield segment.
128 * @param p_isc_information18 Developer Descriptive flexfield segment.
129 * @param p_isc_information19 Developer Descriptive flexfield segment.
130 * @param p_isc_information20 Developer Descriptive flexfield segment.
131 * @param p_isc_information21 Developer Descriptive flexfield segment.
132 * @param p_isc_information22 Developer Descriptive flexfield segment.
133 * @param p_isc_information23 Developer Descriptive flexfield segment.
134 * @param p_isc_information24 Developer Descriptive flexfield segment.
135 * @param p_isc_information25 Developer Descriptive flexfield segment.
136 * @param p_isc_information26 Developer Descriptive flexfield segment.
137 * @param p_isc_information27 Developer Descriptive flexfield segment.
138 * @param p_isc_information28 Developer Descriptive flexfield segment.
139 * @param p_isc_information29 Developer Descriptive flexfield segment.
140 * @param p_isc_information30 Developer Descriptive flexfield segment.
141 * @param p_date_posted Indicates how old jobs may be to be included in the
142 * search
143 * @param p_object_version_number If p_validate is false, then set to the
144 * version number of the created saved search. If p_validate is true, then the
145 * value will be null.
146 * @param p_search_criteria_id If p_validate is false, then this uniquely
147 * identifies the saved search created. If p_validate is true, then set to
148 * null.
149 * @rep:displayname Create Saved Search
150 * @rep:category BUSINESS_ENTITY IRC_CANDIDATE_SAVED_SEARCH
151 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
152 * @rep:scope public
153 * @rep:lifecycle active
154 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
155 */
156 --
157 -- {End Of Comments}
158 --
159 procedure create_saved_search
160 (p_validate in boolean default false
161 ,p_effective_date in date
162 ,p_person_id in number
163 ,p_search_name in varchar2
164 ,p_location in varchar2 default null
165 ,p_distance_to_location in varchar2 default null
166 ,p_geocode_location in varchar2 default null
167 ,p_geocode_country in varchar2 default null
168 ,p_derived_location in varchar2 default null
169 ,p_location_id in number default null
170 ,p_longitude in number default null
174 ,p_employment_category in varchar2 default 'EITHER'
171 ,p_latitude in number default null
172 ,p_employee in varchar2 default null
173 ,p_contractor in varchar2 default null
175 ,p_keywords in varchar2 default null
176 ,p_travel_percentage in number default null
177 ,p_min_salary in number default null
178 ,p_salary_currency in varchar2 default null
179 ,p_salary_period in varchar2 default null
180 ,p_match_competence in varchar2 default 'N'
181 ,p_match_qualification in varchar2 default 'N'
182 ,p_work_at_home in varchar2 default 'POSSIBLE'
183 ,p_job_title in varchar2 default null
184 ,p_department in varchar2 default null
185 ,p_professional_area in varchar2 default null
186 ,p_use_for_matching in varchar2 default 'N'
187 ,p_description in varchar2 default null
188 ,p_attribute_category in varchar2 default null
189 ,p_attribute1 in varchar2 default null
190 ,p_attribute2 in varchar2 default null
191 ,p_attribute3 in varchar2 default null
192 ,p_attribute4 in varchar2 default null
193 ,p_attribute5 in varchar2 default null
194 ,p_attribute6 in varchar2 default null
195 ,p_attribute7 in varchar2 default null
196 ,p_attribute8 in varchar2 default null
197 ,p_attribute9 in varchar2 default null
198 ,p_attribute10 in varchar2 default null
199 ,p_attribute11 in varchar2 default null
200 ,p_attribute12 in varchar2 default null
201 ,p_attribute13 in varchar2 default null
202 ,p_attribute14 in varchar2 default null
203 ,p_attribute15 in varchar2 default null
204 ,p_attribute16 in varchar2 default null
205 ,p_attribute17 in varchar2 default null
206 ,p_attribute18 in varchar2 default null
207 ,p_attribute19 in varchar2 default null
208 ,p_attribute20 in varchar2 default null
209 ,p_attribute21 in varchar2 default null
210 ,p_attribute22 in varchar2 default null
211 ,p_attribute23 in varchar2 default null
212 ,p_attribute24 in varchar2 default null
213 ,p_attribute25 in varchar2 default null
214 ,p_attribute26 in varchar2 default null
215 ,p_attribute27 in varchar2 default null
216 ,p_attribute28 in varchar2 default null
217 ,p_attribute29 in varchar2 default null
218 ,p_attribute30 in varchar2 default null
219 ,p_isc_information_category in varchar2 default null
220 ,p_isc_information1 in varchar2 default null
221 ,p_isc_information2 in varchar2 default null
222 ,p_isc_information3 in varchar2 default null
223 ,p_isc_information4 in varchar2 default null
224 ,p_isc_information5 in varchar2 default null
225 ,p_isc_information6 in varchar2 default null
226 ,p_isc_information7 in varchar2 default null
227 ,p_isc_information8 in varchar2 default null
228 ,p_isc_information9 in varchar2 default null
229 ,p_isc_information10 in varchar2 default null
230 ,p_isc_information11 in varchar2 default null
231 ,p_isc_information12 in varchar2 default null
232 ,p_isc_information13 in varchar2 default null
233 ,p_isc_information14 in varchar2 default null
234 ,p_isc_information15 in varchar2 default null
235 ,p_isc_information16 in varchar2 default null
236 ,p_isc_information17 in varchar2 default null
237 ,p_isc_information18 in varchar2 default null
238 ,p_isc_information19 in varchar2 default null
239 ,p_isc_information20 in varchar2 default null
240 ,p_isc_information21 in varchar2 default null
241 ,p_isc_information22 in varchar2 default null
242 ,p_isc_information23 in varchar2 default null
243 ,p_isc_information24 in varchar2 default null
244 ,p_isc_information25 in varchar2 default null
245 ,p_isc_information26 in varchar2 default null
246 ,p_isc_information27 in varchar2 default null
247 ,p_isc_information28 in varchar2 default null
248 ,p_isc_information29 in varchar2 default null
249 ,p_isc_information30 in varchar2 default null
250 ,p_date_posted in varchar2 default null
251 ,p_object_version_number out nocopy number
252 ,p_search_criteria_id out nocopy number
253 );
254 --
255 -- ----------------------------------------------------------------------------
256 -- |---------------------------< update_saved_search >------------------------|
257 -- ----------------------------------------------------------------------------
258 --
259 -- {Start Of Comments}
260 /*#
261 * This API updates a saved job search for a candidate.
262 *
266 * <p><b>Licensing</b><br>
263 * The saved search may be used by the candidate to repeatedly search for jobs
264 * with the same criteria.
265 *
267 * This API is licensed for use with iRecruitment.
268 *
269 * <p><b>Prerequisites</b><br>
270 * The saved search must exist in the database
271 *
272 * <p><b>Post Success</b><br>
273 * The saved search criteria will be updated
274 *
275 * <p><b>Post Failure</b><br>
276 * The saved search criteria will not be updated and error will be raised.
277 * @param p_validate If true, then validation alone will be performed and the
278 * database will remain unchanged. If false and all validation checks pass,
279 * then the database will be modified.
280 * @param p_effective_date Reference date for validating lookup values are
281 * applicable during the start to end active date range. This date does not
282 * determine when the changes take effect.
283 * @param p_search_criteria_id Identifies the saved search to be updated
284 * @param p_person_id Identifies the person for whom you update the saved
285 * search record.
286 * @param p_search_name Name of saved search
287 * @param p_location Free text location a person is interested in
288 * @param p_distance_to_location Distance in miles the user is willing to
289 * travel to work.
290 * @param p_geocode_location Location for a geocode search
291 * @param p_geocode_country Country for a geocode search
292 * @param p_derived_location Exact derived locale to match on
293 * @param p_location_id Identifies a location to match on
294 * @param p_longitude Longitude for a geocode search
295 * @param p_latitude Latitude for a geocode search
296 * @param p_employee Indicates that the candidate is looking for an employee
297 * job (Y or N)
298 * @param p_contractor Indicates that the candidate is looking for a contract
299 * job (Y or N)
300 * @param p_employment_category Indicates whether the candidate is looking for
301 * a full time or part time job (FULLTIME, PARTTIME or EITHER)
302 * @param p_keywords Free text keywords for the search
303 * @param p_travel_percentage Percentage of time a person is willing to spend
304 * travelling. Valid values are defined by 'IRC_TRAVEL_PERCENTAGE' lookup type.
305 * @param p_min_salary Minimum salary user is willing to accept.
306 * @param p_salary_currency Salary currency
307 * @param p_salary_period Salary period. Valid values are defined by
308 * 'PAY_BASIS' lookup type.
309 * @param p_match_competence Identifies if user wishes to match jobs against
310 * the competencies he has entered (Y or N)
311 * @param p_match_qualification Identifies if user wishes to match jobs against
312 * the qualification he has entered (Y or N)
313 * @param p_work_at_home Indicates how desirable it is to work at home. Valid
314 * values are defined by 'IRC_WORK_AT_HOME' lookup type.
315 * @param p_job_title Title of job the user wishes to be included in search.
316 * @param p_department Reserved for future use
317 * @param p_professional_area Professional area user wishes to work in. Valid
318 * values are defined by 'IRC_PROFESSIONAL_AREA' lookup type.
319 * @param p_use_for_matching Indicated whether a saved search is to be used for
320 * job matching purposes (Y or N)
321 * @param p_description Search Description
322 * @param p_attribute_category This context value determines which flexfield
323 * structure to use with the descriptive flexfield segments.
324 * @param p_attribute1 Descriptive flexfield segment.
325 * @param p_attribute2 Descriptive flexfield segment.
326 * @param p_attribute3 Descriptive flexfield segment.
327 * @param p_attribute4 Descriptive flexfield segment.
328 * @param p_attribute5 Descriptive flexfield segment.
329 * @param p_attribute6 Descriptive flexfield segment.
330 * @param p_attribute7 Descriptive flexfield segment.
331 * @param p_attribute8 Descriptive flexfield segment.
332 * @param p_attribute9 Descriptive flexfield segment.
333 * @param p_attribute10 Descriptive flexfield segment.
334 * @param p_attribute11 Descriptive flexfield segment.
335 * @param p_attribute12 Descriptive flexfield segment.
336 * @param p_attribute13 Descriptive flexfield segment.
337 * @param p_attribute14 Descriptive flexfield segment.
338 * @param p_attribute15 Descriptive flexfield segment.
339 * @param p_attribute16 Descriptive flexfield segment.
340 * @param p_attribute17 Descriptive flexfield segment.
341 * @param p_attribute18 Descriptive flexfield segment.
342 * @param p_attribute19 Descriptive flexfield segment.
343 * @param p_attribute20 Descriptive flexfield segment.
344 * @param p_attribute21 Descriptive flexfield segment.
345 * @param p_attribute22 Descriptive flexfield segment.
346 * @param p_attribute23 Descriptive flexfield segment.
347 * @param p_attribute24 Descriptive flexfield segment.
348 * @param p_attribute25 Descriptive flexfield segment.
349 * @param p_attribute26 Descriptive flexfield segment.
350 * @param p_attribute27 Descriptive flexfield segment.
351 * @param p_attribute28 Descriptive flexfield segment.
352 * @param p_attribute29 Descriptive flexfield segment.
353 * @param p_attribute30 Descriptive flexfield segment.
354 * @param p_isc_information_category Developer Descriptive flexfield segment.
355 * @param p_isc_information1 Developer Descriptive flexfield segment.
356 * @param p_isc_information2 Developer Descriptive flexfield segment.
357 * @param p_isc_information3 Developer Descriptive flexfield segment.
358 * @param p_isc_information4 Developer Descriptive flexfield segment.
359 * @param p_isc_information5 Developer Descriptive flexfield segment.
360 * @param p_isc_information6 Developer Descriptive flexfield segment.
361 * @param p_isc_information7 Developer Descriptive flexfield segment.
365 * @param p_isc_information11 Developer Descriptive flexfield segment.
362 * @param p_isc_information8 Developer Descriptive flexfield segment.
363 * @param p_isc_information9 Developer Descriptive flexfield segment.
364 * @param p_isc_information10 Developer Descriptive flexfield segment.
366 * @param p_isc_information12 Developer Descriptive flexfield segment.
367 * @param p_isc_information13 Developer Descriptive flexfield segment.
368 * @param p_isc_information14 Developer Descriptive flexfield segment.
369 * @param p_isc_information15 Developer Descriptive flexfield segment.
370 * @param p_isc_information16 Developer Descriptive flexfield segment.
371 * @param p_isc_information17 Developer Descriptive flexfield segment.
372 * @param p_isc_information18 Developer Descriptive flexfield segment.
373 * @param p_isc_information19 Developer Descriptive flexfield segment.
374 * @param p_isc_information20 Developer Descriptive flexfield segment.
375 * @param p_isc_information21 Developer Descriptive flexfield segment.
376 * @param p_isc_information22 Developer Descriptive flexfield segment.
377 * @param p_isc_information23 Developer Descriptive flexfield segment.
378 * @param p_isc_information24 Developer Descriptive flexfield segment.
379 * @param p_isc_information25 Developer Descriptive flexfield segment.
380 * @param p_isc_information26 Developer Descriptive flexfield segment.
381 * @param p_isc_information27 Developer Descriptive flexfield segment.
382 * @param p_isc_information28 Developer Descriptive flexfield segment.
383 * @param p_isc_information29 Developer Descriptive flexfield segment.
384 * @param p_isc_information30 Developer Descriptive flexfield segment.
385 * @param p_date_posted Indicates how old jobs may be to be included in the
386 * search
387 * @param p_object_version_number Pass in the current version number of the
388 * saved search to be updated. When the API completes if p_validate is false,
389 * will be set to the new version number of the updated saved search. If
390 * p_validate is true will be set to the same value which was passed in.
391 * @rep:displayname Update Saved Search
392 * @rep:category BUSINESS_ENTITY IRC_CANDIDATE_SAVED_SEARCH
393 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
394 * @rep:scope public
395 * @rep:lifecycle active
396 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
397 */
398 --
399 -- {End Of Comments}
400 --
401 procedure update_saved_search
402 (p_validate in boolean default false
403 ,p_effective_date in date
404 ,p_search_criteria_id in number
405 ,p_person_id in number default hr_api.g_number
406 ,p_search_name in varchar2 default hr_api.g_varchar2
407 ,p_location in varchar2 default hr_api.g_varchar2
408 ,p_distance_to_location in varchar2 default hr_api.g_varchar2
409 ,p_geocode_location in varchar2 default hr_api.g_varchar2
410 ,p_geocode_country in varchar2 default hr_api.g_varchar2
411 ,p_derived_location in varchar2 default hr_api.g_varchar2
412 ,p_location_id in number default hr_api.g_number
413 ,p_longitude in number default hr_api.g_number
414 ,p_latitude in number default hr_api.g_number
415 ,p_employee in varchar2 default hr_api.g_varchar2
416 ,p_contractor in varchar2 default hr_api.g_varchar2
417 ,p_employment_category in varchar2 default hr_api.g_varchar2
418 ,p_keywords in varchar2 default hr_api.g_varchar2
419 ,p_travel_percentage in number default hr_api.g_number
420 ,p_min_salary in number default hr_api.g_number
421 ,p_salary_currency in varchar2 default hr_api.g_varchar2
422 ,p_salary_period in varchar2 default hr_api.g_varchar2
423 ,p_match_competence in varchar2 default hr_api.g_varchar2
424 ,p_match_qualification in varchar2 default hr_api.g_varchar2
425 ,p_work_at_home in varchar2 default hr_api.g_varchar2
426 ,p_job_title in varchar2 default hr_api.g_varchar2
427 ,p_department in varchar2 default hr_api.g_varchar2
428 ,p_professional_area in varchar2 default hr_api.g_varchar2
429 ,p_use_for_matching in varchar2 default hr_api.g_varchar2
430 ,p_description in varchar2 default hr_api.g_varchar2
431 ,p_attribute_category in varchar2 default hr_api.g_varchar2
432 ,p_attribute1 in varchar2 default hr_api.g_varchar2
433 ,p_attribute2 in varchar2 default hr_api.g_varchar2
434 ,p_attribute3 in varchar2 default hr_api.g_varchar2
435 ,p_attribute4 in varchar2 default hr_api.g_varchar2
436 ,p_attribute5 in varchar2 default hr_api.g_varchar2
437 ,p_attribute6 in varchar2 default hr_api.g_varchar2
438 ,p_attribute7 in varchar2 default hr_api.g_varchar2
439 ,p_attribute8 in varchar2 default hr_api.g_varchar2
440 ,p_attribute9 in varchar2 default hr_api.g_varchar2
441 ,p_attribute10 in varchar2 default hr_api.g_varchar2
442 ,p_attribute11 in varchar2 default hr_api.g_varchar2
443 ,p_attribute12 in varchar2 default hr_api.g_varchar2
444 ,p_attribute13 in varchar2 default hr_api.g_varchar2
445 ,p_attribute14 in varchar2 default hr_api.g_varchar2
446 ,p_attribute15 in varchar2 default hr_api.g_varchar2
447 ,p_attribute16 in varchar2 default hr_api.g_varchar2
451 ,p_attribute20 in varchar2 default hr_api.g_varchar2
448 ,p_attribute17 in varchar2 default hr_api.g_varchar2
449 ,p_attribute18 in varchar2 default hr_api.g_varchar2
450 ,p_attribute19 in varchar2 default hr_api.g_varchar2
452 ,p_attribute21 in varchar2 default hr_api.g_varchar2
453 ,p_attribute22 in varchar2 default hr_api.g_varchar2
454 ,p_attribute23 in varchar2 default hr_api.g_varchar2
455 ,p_attribute24 in varchar2 default hr_api.g_varchar2
456 ,p_attribute25 in varchar2 default hr_api.g_varchar2
457 ,p_attribute26 in varchar2 default hr_api.g_varchar2
458 ,p_attribute27 in varchar2 default hr_api.g_varchar2
459 ,p_attribute28 in varchar2 default hr_api.g_varchar2
460 ,p_attribute29 in varchar2 default hr_api.g_varchar2
461 ,p_attribute30 in varchar2 default hr_api.g_varchar2
462 ,p_isc_information_category in varchar2 default hr_api.g_varchar2
463 ,p_isc_information1 in varchar2 default hr_api.g_varchar2
464 ,p_isc_information2 in varchar2 default hr_api.g_varchar2
465 ,p_isc_information3 in varchar2 default hr_api.g_varchar2
466 ,p_isc_information4 in varchar2 default hr_api.g_varchar2
467 ,p_isc_information5 in varchar2 default hr_api.g_varchar2
468 ,p_isc_information6 in varchar2 default hr_api.g_varchar2
469 ,p_isc_information7 in varchar2 default hr_api.g_varchar2
470 ,p_isc_information8 in varchar2 default hr_api.g_varchar2
471 ,p_isc_information9 in varchar2 default hr_api.g_varchar2
472 ,p_isc_information10 in varchar2 default hr_api.g_varchar2
473 ,p_isc_information11 in varchar2 default hr_api.g_varchar2
474 ,p_isc_information12 in varchar2 default hr_api.g_varchar2
475 ,p_isc_information13 in varchar2 default hr_api.g_varchar2
476 ,p_isc_information14 in varchar2 default hr_api.g_varchar2
477 ,p_isc_information15 in varchar2 default hr_api.g_varchar2
478 ,p_isc_information16 in varchar2 default hr_api.g_varchar2
479 ,p_isc_information17 in varchar2 default hr_api.g_varchar2
480 ,p_isc_information18 in varchar2 default hr_api.g_varchar2
481 ,p_isc_information19 in varchar2 default hr_api.g_varchar2
482 ,p_isc_information20 in varchar2 default hr_api.g_varchar2
483 ,p_isc_information21 in varchar2 default hr_api.g_varchar2
484 ,p_isc_information22 in varchar2 default hr_api.g_varchar2
485 ,p_isc_information23 in varchar2 default hr_api.g_varchar2
486 ,p_isc_information24 in varchar2 default hr_api.g_varchar2
487 ,p_isc_information25 in varchar2 default hr_api.g_varchar2
488 ,p_isc_information26 in varchar2 default hr_api.g_varchar2
489 ,p_isc_information27 in varchar2 default hr_api.g_varchar2
490 ,p_isc_information28 in varchar2 default hr_api.g_varchar2
491 ,p_isc_information29 in varchar2 default hr_api.g_varchar2
492 ,p_isc_information30 in varchar2 default hr_api.g_varchar2
493 ,p_date_posted in varchar2 default hr_api.g_varchar2
494 ,p_object_version_number in out nocopy number
495 );
496 --
497 -- ----------------------------------------------------------------------------
498 -- |---------------------------< delete_saved_search >------------------------|
499 -- ----------------------------------------------------------------------------
500 --
501 -- {Start Of Comments}
502 /*#
503 * This API deletes a saved search.
504 *
505 * The saved search will no longer be available to the user for searching or
506 * automatic job matching.
507 *
508 * <p><b>Licensing</b><br>
509 * This API is licensed for use with iRecruitment.
510 *
511 * <p><b>Prerequisites</b><br>
512 * The saved search must exist in the database
513 *
514 * <p><b>Post Success</b><br>
515 * The saved search will be deleted from the database
516 *
517 * <p><b>Post Failure</b><br>
518 * The saved search will not be deleted and an error will be raised
519 * @param p_validate If true, then validation alone will be performed and the
520 * database will remain unchanged. If false and all validation checks pass,
521 * then the database will be modified.
522 * @param p_search_criteria_id Identifies the saved search to be deleted
523 * @param p_object_version_number Current version number of the saved search to
524 * be deleted.
525 * @rep:displayname Delete Saved Search
526 * @rep:category BUSINESS_ENTITY IRC_CANDIDATE_SAVED_SEARCH
527 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
528 * @rep:scope public
529 * @rep:lifecycle active
530 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
531 */
532 --
533 -- {End Of Comments}
534 --
535 procedure delete_saved_search
536 (p_validate in boolean default false
537 ,p_search_criteria_id in number
538 ,p_object_version_number in number
539 );
540 --
541 -- ----------------------------------------------------------------------------
542 -- |-------------------------< create_vacancy_criteria >----------------------|
543 -- ----------------------------------------------------------------------------
544 --
545 -- {Start Of Comments}
546 /*#
547 * This API creates search criteria for a vacancy.
548 *
549 * The vacancy search criteria will be used for matching candidates to
553 * This API is licensed for use with iRecruitment.
550 * vacancies.
551 *
552 * <p><b>Licensing</b><br>
554 *
555 * <p><b>Prerequisites</b><br>
556 * The vacancy must exist
557 *
558 * <p><b>Post Success</b><br>
559 * The vacancy search criteria will be created in the database
560 *
561 * <p><b>Post Failure</b><br>
562 * The vacancy search criteria will not be created in the database and an error
563 * will be raised
564 * @param p_validate If true, then validation alone will be performed and the
565 * database will remain unchanged. If false and all validation checks pass,
566 * then the database will be modified.
567 * @param p_vacancy_id Identifies the vacancy that these criteria apply to
568 * @param p_effective_date Reference date for validating lookup values are
569 * applicable during the start to end active date range. This date does not
570 * determine when the changes take effect.
571 * @param p_location Reserved for future use
572 * @param p_employee Indicates that the vacancy is for an employee job (Y or N)
573 * @param p_contractor Indicates that the vacancy is for a contract job (Y or
574 * N)
575 * @param p_employment_category Indicates whether the vacancy is for a full
576 * time or part time job (FULLTIME, PARTTIME or EITHER)
577 * @param p_keywords Reserved for future use
578 * @param p_travel_percentage Percentage of time travelling that the vacancy
579 * may involve. Valid values are defined by 'IRC_TRAVEL_PERCENTAGE' lookup
580 * type.
581 * @param p_min_salary Minimum salary for the vacancy
582 * @param p_max_salary Maximum salary for the vacancy
583 * @param p_salary_currency Salary Currency
584 * @param p_salary_period Salary period. Valid values are defined by
585 * 'PAY_BASIS' lookup type.
586 * @param p_professional_area Professional area of the vacancy. Valid values
587 * are defined by 'IRC_PROFESSIONAL_AREA' lookup type.
588 * @param p_work_at_home Indicates how desirable it is to work at home. Valid
589 * values are defined by 'IRC_WORK_AT_HOME' lookup type.
590 * @param p_min_qual_level Minimum qualification level required for the
591 * vacancy. Compared against the rank on PER_QUALIFICATION_TYPES
592 * @param p_max_qual_level Maximum qualification level required for the
593 * vacancy. Compared against the rank on PER_QUALIFICATION_TYPES
594 * @param p_description Reserved for future use
595 * @param p_attribute_category This context value determines which flexfield
596 * structure to use with the descriptive flexfield segments.
597 * @param p_attribute1 Descriptive flexfield segment.
598 * @param p_attribute2 Descriptive flexfield segment.
599 * @param p_attribute3 Descriptive flexfield segment.
600 * @param p_attribute4 Descriptive flexfield segment.
601 * @param p_attribute5 Descriptive flexfield segment.
602 * @param p_attribute6 Descriptive flexfield segment.
603 * @param p_attribute7 Descriptive flexfield segment.
604 * @param p_attribute8 Descriptive flexfield segment.
605 * @param p_attribute9 Descriptive flexfield segment.
606 * @param p_attribute10 Descriptive flexfield segment.
607 * @param p_attribute11 Descriptive flexfield segment.
608 * @param p_attribute12 Descriptive flexfield segment.
609 * @param p_attribute13 Descriptive flexfield segment.
610 * @param p_attribute14 Descriptive flexfield segment.
611 * @param p_attribute15 Descriptive flexfield segment.
612 * @param p_attribute16 Descriptive flexfield segment.
613 * @param p_attribute17 Descriptive flexfield segment.
614 * @param p_attribute18 Descriptive flexfield segment.
615 * @param p_attribute19 Descriptive flexfield segment.
616 * @param p_attribute20 Descriptive flexfield segment.
617 * @param p_attribute21 Descriptive flexfield segment.
618 * @param p_attribute22 Descriptive flexfield segment.
619 * @param p_attribute23 Descriptive flexfield segment.
620 * @param p_attribute24 Descriptive flexfield segment.
621 * @param p_attribute25 Descriptive flexfield segment.
622 * @param p_attribute26 Descriptive flexfield segment.
623 * @param p_attribute27 Descriptive flexfield segment.
624 * @param p_attribute28 Descriptive flexfield segment.
625 * @param p_attribute29 Descriptive flexfield segment.
626 * @param p_attribute30 Descriptive flexfield segment.
627 * @param p_isc_information_category Developer Descriptive flexfield segment.
628 * @param p_isc_information1 Developer Descriptive flexfield segment.
629 * @param p_isc_information2 Developer Descriptive flexfield segment.
630 * @param p_isc_information3 Developer Descriptive flexfield segment.
631 * @param p_isc_information4 Developer Descriptive flexfield segment.
632 * @param p_isc_information5 Developer Descriptive flexfield segment.
633 * @param p_isc_information6 Developer Descriptive flexfield segment.
634 * @param p_isc_information7 Developer Descriptive flexfield segment.
635 * @param p_isc_information8 Developer Descriptive flexfield segment.
636 * @param p_isc_information9 Developer Descriptive flexfield segment.
637 * @param p_isc_information10 Developer Descriptive flexfield segment.
638 * @param p_isc_information11 Developer Descriptive flexfield segment.
639 * @param p_isc_information12 Developer Descriptive flexfield segment.
640 * @param p_isc_information13 Developer Descriptive flexfield segment.
641 * @param p_isc_information14 Developer Descriptive flexfield segment.
642 * @param p_isc_information15 Developer Descriptive flexfield segment.
643 * @param p_isc_information16 Developer Descriptive flexfield segment.
644 * @param p_isc_information17 Developer Descriptive flexfield segment.
645 * @param p_isc_information18 Developer Descriptive flexfield segment.
646 * @param p_isc_information19 Developer Descriptive flexfield segment.
647 * @param p_isc_information20 Developer Descriptive flexfield segment.
648 * @param p_isc_information21 Developer Descriptive flexfield segment.
652 * @param p_isc_information25 Developer Descriptive flexfield segment.
649 * @param p_isc_information22 Developer Descriptive flexfield segment.
650 * @param p_isc_information23 Developer Descriptive flexfield segment.
651 * @param p_isc_information24 Developer Descriptive flexfield segment.
653 * @param p_isc_information26 Developer Descriptive flexfield segment.
654 * @param p_isc_information27 Developer Descriptive flexfield segment.
655 * @param p_isc_information28 Developer Descriptive flexfield segment.
656 * @param p_isc_information29 Developer Descriptive flexfield segment.
657 * @param p_isc_information30 Developer Descriptive flexfield segment.
658 * @param p_object_version_number If p_validate is false, then set to the
659 * version number of the created vacancy criteria. If p_validate is true, then
660 * the value will be null.
661 * @param p_search_criteria_id If p_validate is false, then this uniquely
662 * identifies the vacancy criteria created. If p_validate is true, then set to
663 * null.
664 * @rep:displayname Create Vacancy Criteria
665 * @rep:category BUSINESS_ENTITY PER_VACANCY
666 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
667 * @rep:scope public
668 * @rep:lifecycle active
669 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
670 */
671 --
672 -- {End Of Comments}
673 --
674 procedure create_vacancy_criteria
675 (p_validate in boolean default false
676 ,p_vacancy_id in number
677 ,p_effective_date in date
678 ,p_location in varchar2 default null
679 ,p_employee in varchar2 default null
680 ,p_contractor in varchar2 default null
681 ,p_employment_category in varchar2 default null
682 ,p_keywords in varchar2 default null
683 ,p_travel_percentage in number default null
684 ,p_min_salary in number default null
685 ,p_max_salary in number default null
686 ,p_salary_currency in varchar2 default null
687 ,p_salary_period in varchar2 default null
688 ,p_professional_area in varchar2 default null
689 ,p_work_at_home in varchar2 default null
690 ,p_min_qual_level in number default null
691 ,p_max_qual_level in number default null
692 ,p_description in varchar2 default null
693 ,p_attribute_category in varchar2 default null
694 ,p_attribute1 in varchar2 default null
695 ,p_attribute2 in varchar2 default null
696 ,p_attribute3 in varchar2 default null
697 ,p_attribute4 in varchar2 default null
698 ,p_attribute5 in varchar2 default null
699 ,p_attribute6 in varchar2 default null
700 ,p_attribute7 in varchar2 default null
701 ,p_attribute8 in varchar2 default null
702 ,p_attribute9 in varchar2 default null
703 ,p_attribute10 in varchar2 default null
704 ,p_attribute11 in varchar2 default null
705 ,p_attribute12 in varchar2 default null
706 ,p_attribute13 in varchar2 default null
707 ,p_attribute14 in varchar2 default null
708 ,p_attribute15 in varchar2 default null
709 ,p_attribute16 in varchar2 default null
710 ,p_attribute17 in varchar2 default null
711 ,p_attribute18 in varchar2 default null
712 ,p_attribute19 in varchar2 default null
713 ,p_attribute20 in varchar2 default null
714 ,p_attribute21 in varchar2 default null
715 ,p_attribute22 in varchar2 default null
716 ,p_attribute23 in varchar2 default null
717 ,p_attribute24 in varchar2 default null
718 ,p_attribute25 in varchar2 default null
719 ,p_attribute26 in varchar2 default null
720 ,p_attribute27 in varchar2 default null
721 ,p_attribute28 in varchar2 default null
722 ,p_attribute29 in varchar2 default null
723 ,p_attribute30 in varchar2 default null
724 ,p_isc_information_category in varchar2 default null
725 ,p_isc_information1 in varchar2 default null
726 ,p_isc_information2 in varchar2 default null
727 ,p_isc_information3 in varchar2 default null
728 ,p_isc_information4 in varchar2 default null
729 ,p_isc_information5 in varchar2 default null
730 ,p_isc_information6 in varchar2 default null
731 ,p_isc_information7 in varchar2 default null
732 ,p_isc_information8 in varchar2 default null
733 ,p_isc_information9 in varchar2 default null
734 ,p_isc_information10 in varchar2 default null
735 ,p_isc_information11 in varchar2 default null
736 ,p_isc_information12 in varchar2 default null
737 ,p_isc_information13 in varchar2 default null
738 ,p_isc_information14 in varchar2 default null
739 ,p_isc_information15 in varchar2 default null
740 ,p_isc_information16 in varchar2 default null
741 ,p_isc_information17 in varchar2 default null
742 ,p_isc_information18 in varchar2 default null
743 ,p_isc_information19 in varchar2 default null
744 ,p_isc_information20 in varchar2 default null
745 ,p_isc_information21 in varchar2 default null
749 ,p_isc_information25 in varchar2 default null
746 ,p_isc_information22 in varchar2 default null
747 ,p_isc_information23 in varchar2 default null
748 ,p_isc_information24 in varchar2 default null
750 ,p_isc_information26 in varchar2 default null
751 ,p_isc_information27 in varchar2 default null
752 ,p_isc_information28 in varchar2 default null
753 ,p_isc_information29 in varchar2 default null
754 ,p_isc_information30 in varchar2 default null
755 ,p_object_version_number out nocopy number
756 ,p_search_criteria_id out nocopy number
757 );
758 --
759 -- ----------------------------------------------------------------------------
760 -- |-------------------------< update_vacancy_criteria >----------------------|
761 -- ----------------------------------------------------------------------------
762 --
763 -- {Start Of Comments}
764 /*#
765 * This API updates search criteria for a vacancy.
766 *
767 * The vacancy search criteria will be used for matching candidates to
768 * vacancies.
769 *
770 * <p><b>Licensing</b><br>
771 * This API is licensed for use with iRecruitment.
772 *
773 * <p><b>Prerequisites</b><br>
774 * The vacancy search criteria must exist in the database
775 *
776 * <p><b>Post Success</b><br>
777 * The vacancy criteria will be updated
778 *
779 * <p><b>Post Failure</b><br>
780 * The vacancy criteria will not be updated and error will be raised
781 * @param p_validate If true, then validation alone will be performed and the
782 * database will remain unchanged. If false and all validation checks pass,
783 * then the database will be modified.
784 * @param p_search_criteria_id Identifies the vacancy criteria to be updated
785 * @param p_vacancy_id Identifies the vacancy that these criteria apply to
786 * @param p_effective_date Reference date for validating lookup values are
787 * applicable during the start to end active date range. This date does not
788 * determine when the changes take effect.
789 * @param p_location Reserved for future use
790 * @param p_employee Indicates that the vacancy is for an employee job (Y or N)
791 * @param p_contractor Indicates that the vacancy is for a contract job (Y or
792 * N)
793 * @param p_employment_category Indicates whether the vacancy is for a full
794 * time or part time job (FULLTIME, PARTTIME or EITHER)
795 * @param p_keywords Reserved for future use
796 * @param p_travel_percentage Percentage of time travelling that the vacancy
797 * may involve. Valid values are defined by 'IRC_TRAVEL_PERCENTAGE' lookup
798 * type.
799 * @param p_min_salary Minimum salary for the vacancy
800 * @param p_max_salary Maximum salary for the vacancy
801 * @param p_salary_currency Salary Currency
802 * @param p_salary_period Salary period. Valid values are defined by
803 * 'PAY_BASIS' lookup type.
804 * @param p_professional_area Professional area of the vacancy. Valid values
805 * are defined by 'IRC_PROFESSIONAL_AREA' lookup type.
806 * @param p_work_at_home Indicates how desirable it is to work at home. Valid
807 * values are defined by 'IRC_WORK_AT_HOME' lookup type.
808 * @param p_min_qual_level Minimum qualification level required for the
809 * vacancy. Compared against the rank on PER_QUALIFICATION_TYPES
810 * @param p_max_qual_level Maximum qualification level required for the
811 * vacancy. Compared against the rank on PER_QUALIFICATION_TYPES
812 * @param p_description Reserved for future use
813 * @param p_attribute_category This context value determines which flexfield
814 * structure to use with the descriptive flexfield segments.
815 * @param p_attribute1 Descriptive flexfield segment.
816 * @param p_attribute2 Descriptive flexfield segment.
817 * @param p_attribute3 Descriptive flexfield segment.
818 * @param p_attribute4 Descriptive flexfield segment.
819 * @param p_attribute5 Descriptive flexfield segment.
820 * @param p_attribute6 Descriptive flexfield segment.
821 * @param p_attribute7 Descriptive flexfield segment.
822 * @param p_attribute8 Descriptive flexfield segment.
823 * @param p_attribute9 Descriptive flexfield segment.
824 * @param p_attribute10 Descriptive flexfield segment.
825 * @param p_attribute11 Descriptive flexfield segment.
826 * @param p_attribute12 Descriptive flexfield segment.
827 * @param p_attribute13 Descriptive flexfield segment.
828 * @param p_attribute14 Descriptive flexfield segment.
829 * @param p_attribute15 Descriptive flexfield segment.
830 * @param p_attribute16 Descriptive flexfield segment.
831 * @param p_attribute17 Descriptive flexfield segment.
832 * @param p_attribute18 Descriptive flexfield segment.
833 * @param p_attribute19 Descriptive flexfield segment.
834 * @param p_attribute20 Descriptive flexfield segment.
835 * @param p_attribute21 Descriptive flexfield segment.
836 * @param p_attribute22 Descriptive flexfield segment.
837 * @param p_attribute23 Descriptive flexfield segment.
838 * @param p_attribute24 Descriptive flexfield segment.
839 * @param p_attribute25 Descriptive flexfield segment.
840 * @param p_attribute26 Descriptive flexfield segment.
841 * @param p_attribute27 Descriptive flexfield segment.
842 * @param p_attribute28 Descriptive flexfield segment.
843 * @param p_attribute29 Descriptive flexfield segment.
844 * @param p_attribute30 Descriptive flexfield segment.
845 * @param p_isc_information_category Developer Descriptive flexfield segment.
846 * @param p_isc_information1 Developer Descriptive flexfield segment.
847 * @param p_isc_information2 Developer Descriptive flexfield segment.
848 * @param p_isc_information3 Developer Descriptive flexfield segment.
849 * @param p_isc_information4 Developer Descriptive flexfield segment.
850 * @param p_isc_information5 Developer Descriptive flexfield segment.
851 * @param p_isc_information6 Developer Descriptive flexfield segment.
855 * @param p_isc_information10 Developer Descriptive flexfield segment.
852 * @param p_isc_information7 Developer Descriptive flexfield segment.
853 * @param p_isc_information8 Developer Descriptive flexfield segment.
854 * @param p_isc_information9 Developer Descriptive flexfield segment.
856 * @param p_isc_information11 Developer Descriptive flexfield segment.
857 * @param p_isc_information12 Developer Descriptive flexfield segment.
858 * @param p_isc_information13 Developer Descriptive flexfield segment.
859 * @param p_isc_information14 Developer Descriptive flexfield segment.
860 * @param p_isc_information15 Developer Descriptive flexfield segment.
861 * @param p_isc_information16 Developer Descriptive flexfield segment.
862 * @param p_isc_information17 Developer Descriptive flexfield segment.
863 * @param p_isc_information18 Developer Descriptive flexfield segment.
864 * @param p_isc_information19 Developer Descriptive flexfield segment.
865 * @param p_isc_information20 Developer Descriptive flexfield segment.
866 * @param p_isc_information21 Developer Descriptive flexfield segment.
867 * @param p_isc_information22 Developer Descriptive flexfield segment.
868 * @param p_isc_information23 Developer Descriptive flexfield segment.
869 * @param p_isc_information24 Developer Descriptive flexfield segment.
870 * @param p_isc_information25 Developer Descriptive flexfield segment.
871 * @param p_isc_information26 Developer Descriptive flexfield segment.
872 * @param p_isc_information27 Developer Descriptive flexfield segment.
873 * @param p_isc_information28 Developer Descriptive flexfield segment.
874 * @param p_isc_information29 Developer Descriptive flexfield segment.
875 * @param p_isc_information30 Developer Descriptive flexfield segment.
876 * @param p_object_version_number Pass in the current version number of the
877 * vacancy criteria to be updated. When the API completes if p_validate is
878 * false, will be set to the new version number of the updated vacancy
879 * criteria. If p_validate is true will be set to the same value which was
880 * passed in.
881 * @rep:displayname Update Vacancy Criteria
882 * @rep:category BUSINESS_ENTITY PER_VACANCY
883 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
884 * @rep:scope public
885 * @rep:lifecycle active
886 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
887 */
888 --
889 -- {End Of Comments}
890 --
891 procedure update_vacancy_criteria
892 (p_validate in boolean default false
893 ,p_search_criteria_id in number
894 ,p_vacancy_id in number default hr_api.g_number
895 ,p_effective_date in date
896 ,p_location in varchar2 default hr_api.g_varchar2
897 ,p_employee in varchar2 default hr_api.g_varchar2
898 ,p_contractor in varchar2 default hr_api.g_varchar2
899 ,p_employment_category in varchar2 default hr_api.g_varchar2
900 ,p_keywords in varchar2 default hr_api.g_varchar2
901 ,p_travel_percentage in number default hr_api.g_number
902 ,p_min_salary in number default hr_api.g_number
903 ,p_max_salary in number default hr_api.g_number
904 ,p_salary_currency in varchar2 default hr_api.g_varchar2
905 ,p_salary_period in varchar2 default hr_api.g_varchar2
906 ,p_professional_area in varchar2 default hr_api.g_varchar2
907 ,p_work_at_home in varchar2 default hr_api.g_varchar2
908 ,p_min_qual_level in number default hr_api.g_number
909 ,p_max_qual_level in number default hr_api.g_number
910 ,p_description in varchar2 default hr_api.g_varchar2
911 ,p_attribute_category in varchar2 default hr_api.g_varchar2
912 ,p_attribute1 in varchar2 default hr_api.g_varchar2
913 ,p_attribute2 in varchar2 default hr_api.g_varchar2
914 ,p_attribute3 in varchar2 default hr_api.g_varchar2
915 ,p_attribute4 in varchar2 default hr_api.g_varchar2
916 ,p_attribute5 in varchar2 default hr_api.g_varchar2
917 ,p_attribute6 in varchar2 default hr_api.g_varchar2
918 ,p_attribute7 in varchar2 default hr_api.g_varchar2
919 ,p_attribute8 in varchar2 default hr_api.g_varchar2
920 ,p_attribute9 in varchar2 default hr_api.g_varchar2
921 ,p_attribute10 in varchar2 default hr_api.g_varchar2
922 ,p_attribute11 in varchar2 default hr_api.g_varchar2
923 ,p_attribute12 in varchar2 default hr_api.g_varchar2
924 ,p_attribute13 in varchar2 default hr_api.g_varchar2
925 ,p_attribute14 in varchar2 default hr_api.g_varchar2
926 ,p_attribute15 in varchar2 default hr_api.g_varchar2
927 ,p_attribute16 in varchar2 default hr_api.g_varchar2
928 ,p_attribute17 in varchar2 default hr_api.g_varchar2
929 ,p_attribute18 in varchar2 default hr_api.g_varchar2
930 ,p_attribute19 in varchar2 default hr_api.g_varchar2
931 ,p_attribute20 in varchar2 default hr_api.g_varchar2
932 ,p_attribute21 in varchar2 default hr_api.g_varchar2
933 ,p_attribute22 in varchar2 default hr_api.g_varchar2
934 ,p_attribute23 in varchar2 default hr_api.g_varchar2
935 ,p_attribute24 in varchar2 default hr_api.g_varchar2
936 ,p_attribute25 in varchar2 default hr_api.g_varchar2
937 ,p_attribute26 in varchar2 default hr_api.g_varchar2
938 ,p_attribute27 in varchar2 default hr_api.g_varchar2
939 ,p_attribute28 in varchar2 default hr_api.g_varchar2
943 ,p_isc_information1 in varchar2 default hr_api.g_varchar2
940 ,p_attribute29 in varchar2 default hr_api.g_varchar2
941 ,p_attribute30 in varchar2 default hr_api.g_varchar2
942 ,p_isc_information_category in varchar2 default hr_api.g_varchar2
944 ,p_isc_information2 in varchar2 default hr_api.g_varchar2
945 ,p_isc_information3 in varchar2 default hr_api.g_varchar2
946 ,p_isc_information4 in varchar2 default hr_api.g_varchar2
947 ,p_isc_information5 in varchar2 default hr_api.g_varchar2
948 ,p_isc_information6 in varchar2 default hr_api.g_varchar2
949 ,p_isc_information7 in varchar2 default hr_api.g_varchar2
950 ,p_isc_information8 in varchar2 default hr_api.g_varchar2
951 ,p_isc_information9 in varchar2 default hr_api.g_varchar2
952 ,p_isc_information10 in varchar2 default hr_api.g_varchar2
953 ,p_isc_information11 in varchar2 default hr_api.g_varchar2
954 ,p_isc_information12 in varchar2 default hr_api.g_varchar2
955 ,p_isc_information13 in varchar2 default hr_api.g_varchar2
956 ,p_isc_information14 in varchar2 default hr_api.g_varchar2
957 ,p_isc_information15 in varchar2 default hr_api.g_varchar2
958 ,p_isc_information16 in varchar2 default hr_api.g_varchar2
959 ,p_isc_information17 in varchar2 default hr_api.g_varchar2
960 ,p_isc_information18 in varchar2 default hr_api.g_varchar2
961 ,p_isc_information19 in varchar2 default hr_api.g_varchar2
962 ,p_isc_information20 in varchar2 default hr_api.g_varchar2
963 ,p_isc_information21 in varchar2 default hr_api.g_varchar2
964 ,p_isc_information22 in varchar2 default hr_api.g_varchar2
965 ,p_isc_information23 in varchar2 default hr_api.g_varchar2
966 ,p_isc_information24 in varchar2 default hr_api.g_varchar2
967 ,p_isc_information25 in varchar2 default hr_api.g_varchar2
968 ,p_isc_information26 in varchar2 default hr_api.g_varchar2
969 ,p_isc_information27 in varchar2 default hr_api.g_varchar2
970 ,p_isc_information28 in varchar2 default hr_api.g_varchar2
971 ,p_isc_information29 in varchar2 default hr_api.g_varchar2
972 ,p_isc_information30 in varchar2 default hr_api.g_varchar2
973 ,p_object_version_number in out nocopy number
974 );
975 --
976 -- ----------------------------------------------------------------------------
977 -- |-------------------------< delete_vacancy_criteria >----------------------|
978 -- ----------------------------------------------------------------------------
979 --
980 -- {Start Of Comments}
981 /*#
982 * This API deletes the vacancy search criteria.
983 *
984 *
985 * <p><b>Licensing</b><br>
986 * This API is licensed for use with iRecruitment.
987 *
988 * <p><b>Prerequisites</b><br>
989 * The vacancy criteria must exist
990 *
991 * <p><b>Post Success</b><br>
992 * The vacancy criteria will be deleted from the database
993 *
994 * <p><b>Post Failure</b><br>
995 * Vacancy criteria will not be deleted from the database and an error will be
996 * raised.
997 * @param p_validate If true, then validation alone will be performed and the
998 * database will remain unchanged. If false and all validation checks pass,
999 * then the database will be modified.
1000 * @param p_search_criteria_id Identifies the vacancy search criteria to be
1001 * deleted
1002 * @param p_object_version_number Current version number of the vacancy
1003 * criteria to be deleted.
1004 * @rep:displayname Delete Vacancy Criteria
1005 * @rep:category BUSINESS_ENTITY PER_VACANCY
1006 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1007 * @rep:scope public
1008 * @rep:lifecycle active
1009 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1010 */
1011 --
1012 -- {End Of Comments}
1013 --
1014 procedure delete_vacancy_criteria
1015 (p_validate in boolean default false
1016 ,p_search_criteria_id in number
1017 ,p_object_version_number in number
1018 );
1019 --
1020 -- ----------------------------------------------------------------------------
1021 -- |---------------------------< create_work_choices >------------------------|
1022 -- ----------------------------------------------------------------------------
1023 --
1024 -- {Start Of Comments}
1025 /*#
1026 * This API creates work preferences for a candidate.
1027 *
1028 * The work preferences for a candidate are used to indicate to a manager the
1029 * kind of vacancy that a candidate is looking for.
1030 *
1031 * <p><b>Licensing</b><br>
1032 * This API is licensed for use with iRecruitment.
1033 *
1034 * <p><b>Prerequisites</b><br>
1035 * The person must exist
1036 *
1037 * <p><b>Post Success</b><br>
1038 * The work preferences will be created in the database
1039 *
1040 * <p><b>Post Failure</b><br>
1041 * The work preferences will not be created in the database and an error will
1042 * be raised
1043 * @param p_validate If true, then validation alone will be performed and the
1044 * database will remain unchanged. If false and all validation checks pass,
1045 * then the database will be modified.
1046 * @param p_effective_date Reference date for validating lookup values are
1047 * applicable during the start to end active date range. This date does not
1048 * determine when the changes take effect.
1049 * @param p_person_id Identifies the person for whom you create the work
1050 * preferences record.
1051 * @param p_location Free text location a person is interested in
1052 * @param p_distance_to_location Distance in miles the user is willing to
1056 * @param p_derived_location Exact derived locale to match on
1053 * travel to work.
1054 * @param p_geocode_location Location for a geocode search
1055 * @param p_geocode_country Country for a geocode search
1057 * @param p_location_id Identifies a location to match on
1058 * @param p_longitude Longitude for a geocode search
1059 * @param p_latitude Latitude for a geocode search
1060 * @param p_employee Indicates that the candidate is looking for an employee
1061 * job (Y or N)
1062 * @param p_contractor Indicates that the candidate is looking for a contract
1063 * job (Y or N)
1064 * @param p_employment_category Indicates whether the candidate is looking for
1065 * a full time or part time job (FULLTIME, PARTTIME or EITHER)
1066 * @param p_keywords Free text keywords for the search
1067 * @param p_travel_percentage Percentage of time a person is willing to spend
1068 * travelling. Valid values are defined by 'IRC_TRAVEL_PERCENTAGE' lookup type.
1069 * @param p_min_salary Minimum salary user is willing to accept.
1070 * @param p_salary_currency Salary currency
1071 * @param p_salary_period Salary period. Valid values are defined by
1072 * 'PAY_BASIS' lookup type.
1073 * @param p_match_competence Identifies if user wishes to match jobs against
1074 * the competencies he has entered (Y or N)
1075 * @param p_match_qualification Identifies if user wishes to match jobs against
1076 * the qualification he has entered (Y or N)
1077 * @param p_work_at_home Indicates how desirable it is to work at home. Valid
1078 * values are defined by 'IRC_WORK_AT_HOME' lookup type.
1079 * @param p_job_title Title of job the user wishes to be included in search.
1080 * @param p_department Reserved for future use
1081 * @param p_professional_area Professional area user wishes to work in. Valid
1082 * values are defined by 'IRC_PROFESSIONAL_AREA' lookup type.
1083 * @param p_description Reserved for future use
1084 * @param p_attribute_category This context value determines which flexfield
1085 * structure to use with the descriptive flexfield segments.
1086 * @param p_attribute1 Descriptive flexfield segment.
1087 * @param p_attribute2 Descriptive flexfield segment.
1088 * @param p_attribute3 Descriptive flexfield segment.
1089 * @param p_attribute4 Descriptive flexfield segment.
1090 * @param p_attribute5 Descriptive flexfield segment.
1091 * @param p_attribute6 Descriptive flexfield segment.
1092 * @param p_attribute7 Descriptive flexfield segment.
1093 * @param p_attribute8 Descriptive flexfield segment.
1094 * @param p_attribute9 Descriptive flexfield segment.
1095 * @param p_attribute10 Descriptive flexfield segment.
1096 * @param p_attribute11 Descriptive flexfield segment.
1097 * @param p_attribute12 Descriptive flexfield segment.
1098 * @param p_attribute13 Descriptive flexfield segment.
1099 * @param p_attribute14 Descriptive flexfield segment.
1100 * @param p_attribute15 Descriptive flexfield segment.
1101 * @param p_attribute16 Descriptive flexfield segment.
1102 * @param p_attribute17 Descriptive flexfield segment.
1103 * @param p_attribute18 Descriptive flexfield segment.
1104 * @param p_attribute19 Descriptive flexfield segment.
1105 * @param p_attribute20 Descriptive flexfield segment.
1106 * @param p_attribute21 Descriptive flexfield segment.
1107 * @param p_attribute22 Descriptive flexfield segment.
1108 * @param p_attribute23 Descriptive flexfield segment.
1109 * @param p_attribute24 Descriptive flexfield segment.
1110 * @param p_attribute25 Descriptive flexfield segment.
1111 * @param p_attribute26 Descriptive flexfield segment.
1112 * @param p_attribute27 Descriptive flexfield segment.
1113 * @param p_attribute28 Descriptive flexfield segment.
1114 * @param p_attribute29 Descriptive flexfield segment.
1115 * @param p_attribute30 Descriptive flexfield segment.
1116 * @param p_isc_information_category Developer Descriptive flexfield segment.
1117 * @param p_isc_information1 Developer Descriptive flexfield segment.
1118 * @param p_isc_information2 Developer Descriptive flexfield segment.
1119 * @param p_isc_information3 Developer Descriptive flexfield segment.
1120 * @param p_isc_information4 Developer Descriptive flexfield segment.
1121 * @param p_isc_information5 Developer Descriptive flexfield segment.
1122 * @param p_isc_information6 Developer Descriptive flexfield segment.
1123 * @param p_isc_information7 Developer Descriptive flexfield segment.
1124 * @param p_isc_information8 Developer Descriptive flexfield segment.
1125 * @param p_isc_information9 Developer Descriptive flexfield segment.
1126 * @param p_isc_information10 Developer Descriptive flexfield segment.
1127 * @param p_isc_information11 Developer Descriptive flexfield segment.
1128 * @param p_isc_information12 Developer Descriptive flexfield segment.
1129 * @param p_isc_information13 Developer Descriptive flexfield segment.
1130 * @param p_isc_information14 Developer Descriptive flexfield segment.
1131 * @param p_isc_information15 Developer Descriptive flexfield segment.
1132 * @param p_isc_information16 Developer Descriptive flexfield segment.
1133 * @param p_isc_information17 Developer Descriptive flexfield segment.
1134 * @param p_isc_information18 Developer Descriptive flexfield segment.
1135 * @param p_isc_information19 Developer Descriptive flexfield segment.
1136 * @param p_isc_information20 Developer Descriptive flexfield segment.
1137 * @param p_isc_information21 Developer Descriptive flexfield segment.
1138 * @param p_isc_information22 Developer Descriptive flexfield segment.
1139 * @param p_isc_information23 Developer Descriptive flexfield segment.
1140 * @param p_isc_information24 Developer Descriptive flexfield segment.
1141 * @param p_isc_information25 Developer Descriptive flexfield segment.
1142 * @param p_isc_information26 Developer Descriptive flexfield segment.
1143 * @param p_isc_information27 Developer Descriptive flexfield segment.
1144 * @param p_isc_information28 Developer Descriptive flexfield segment.
1145 * @param p_isc_information29 Developer Descriptive flexfield segment.
1146 * @param p_isc_information30 Developer Descriptive flexfield segment.
1147 * @param p_object_version_number If p_validate is false, then set to the
1151 * identifies the work preferences created. If p_validate is true, then set to
1148 * version number of the created work preferences. If p_validate is true, then
1149 * the value will be null.
1150 * @param p_search_criteria_id If p_validate is false, then this uniquely
1152 * null.
1153 * @rep:displayname Create Work Preferences
1154 * @rep:category BUSINESS_ENTITY IRC_CANDIDATE_WORK_PREFERENCES
1155 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1156 * @rep:scope public
1157 * @rep:lifecycle active
1158 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1159 */
1160 --
1161 -- {End Of Comments}
1162 --
1163 procedure create_work_choices
1164 (p_validate in boolean default false
1165 ,p_effective_date in date
1166 ,p_person_id in number
1167 ,p_location in varchar2 default null
1168 ,p_distance_to_location in varchar2 default null
1169 ,p_geocode_location in varchar2 default null
1170 ,p_geocode_country in varchar2 default null
1171 ,p_derived_location in varchar2 default null
1172 ,p_location_id in number default null
1173 ,p_longitude in number default null
1174 ,p_latitude in number default null
1175 ,p_employee in varchar2 default null
1176 ,p_contractor in varchar2 default null
1177 ,p_employment_category in varchar2 default 'EITHER'
1178 ,p_keywords in varchar2 default null
1179 ,p_travel_percentage in number default null
1180 ,p_min_salary in number default null
1181 ,p_salary_currency in varchar2 default null
1182 ,p_salary_period in varchar2 default null
1183 ,p_match_competence in varchar2 default 'N'
1184 ,p_match_qualification in varchar2 default 'N'
1185 ,p_work_at_home in varchar2 default 'POSSIBLE'
1186 ,p_job_title in varchar2 default null
1187 ,p_department in varchar2 default null
1188 ,p_professional_area in varchar2 default null
1189 ,p_description in varchar2 default null
1190 ,p_attribute_category in varchar2 default null
1191 ,p_attribute1 in varchar2 default null
1192 ,p_attribute2 in varchar2 default null
1193 ,p_attribute3 in varchar2 default null
1194 ,p_attribute4 in varchar2 default null
1195 ,p_attribute5 in varchar2 default null
1196 ,p_attribute6 in varchar2 default null
1197 ,p_attribute7 in varchar2 default null
1198 ,p_attribute8 in varchar2 default null
1199 ,p_attribute9 in varchar2 default null
1200 ,p_attribute10 in varchar2 default null
1201 ,p_attribute11 in varchar2 default null
1202 ,p_attribute12 in varchar2 default null
1203 ,p_attribute13 in varchar2 default null
1204 ,p_attribute14 in varchar2 default null
1205 ,p_attribute15 in varchar2 default null
1206 ,p_attribute16 in varchar2 default null
1207 ,p_attribute17 in varchar2 default null
1208 ,p_attribute18 in varchar2 default null
1209 ,p_attribute19 in varchar2 default null
1210 ,p_attribute20 in varchar2 default null
1211 ,p_attribute21 in varchar2 default null
1212 ,p_attribute22 in varchar2 default null
1213 ,p_attribute23 in varchar2 default null
1214 ,p_attribute24 in varchar2 default null
1215 ,p_attribute25 in varchar2 default null
1216 ,p_attribute26 in varchar2 default null
1217 ,p_attribute27 in varchar2 default null
1218 ,p_attribute28 in varchar2 default null
1219 ,p_attribute29 in varchar2 default null
1220 ,p_attribute30 in varchar2 default null
1221 ,p_isc_information_category in varchar2 default null
1222 ,p_isc_information1 in varchar2 default null
1223 ,p_isc_information2 in varchar2 default null
1224 ,p_isc_information3 in varchar2 default null
1225 ,p_isc_information4 in varchar2 default null
1226 ,p_isc_information5 in varchar2 default null
1227 ,p_isc_information6 in varchar2 default null
1228 ,p_isc_information7 in varchar2 default null
1229 ,p_isc_information8 in varchar2 default null
1230 ,p_isc_information9 in varchar2 default null
1231 ,p_isc_information10 in varchar2 default null
1232 ,p_isc_information11 in varchar2 default null
1233 ,p_isc_information12 in varchar2 default null
1234 ,p_isc_information13 in varchar2 default null
1235 ,p_isc_information14 in varchar2 default null
1236 ,p_isc_information15 in varchar2 default null
1237 ,p_isc_information16 in varchar2 default null
1238 ,p_isc_information17 in varchar2 default null
1239 ,p_isc_information18 in varchar2 default null
1240 ,p_isc_information19 in varchar2 default null
1241 ,p_isc_information20 in varchar2 default null
1242 ,p_isc_information21 in varchar2 default null
1243 ,p_isc_information22 in varchar2 default null
1244 ,p_isc_information23 in varchar2 default null
1245 ,p_isc_information24 in varchar2 default null
1249 ,p_isc_information28 in varchar2 default null
1246 ,p_isc_information25 in varchar2 default null
1247 ,p_isc_information26 in varchar2 default null
1248 ,p_isc_information27 in varchar2 default null
1250 ,p_isc_information29 in varchar2 default null
1251 ,p_isc_information30 in varchar2 default null
1252 ,p_object_version_number out nocopy number
1253 ,p_search_criteria_id out nocopy number
1254 );
1255 --
1256 -- ----------------------------------------------------------------------------
1257 -- |---------------------------< update_work_choices >------------------------|
1258 -- ----------------------------------------------------------------------------
1259 --
1260 -- {Start Of Comments}
1261 /*#
1262 * This API updates work preferences for a candidate.
1263 *
1264 * The work preferences for a candidate are used to indicate to a manager the
1265 * kind of vacancy that a candidate is looking for.
1266 *
1267 * <p><b>Licensing</b><br>
1268 * This API is licensed for use with iRecruitment.
1269 *
1270 * <p><b>Prerequisites</b><br>
1271 * The work preferences must exist in the database
1272 *
1273 * <p><b>Post Success</b><br>
1274 * The work preferences will be updated
1275 *
1276 * <p><b>Post Failure</b><br>
1277 * The work preferences will not be updated and an error will be raised.
1278 * @param p_validate If true, then validation alone will be performed and the
1279 * database will remain unchanged. If false and all validation checks pass,
1280 * then the database will be modified.
1281 * @param p_effective_date Reference date for validating lookup values are
1282 * applicable during the start to end active date range. This date does not
1283 * determine when the changes take effect.
1284 * @param p_search_criteria_id Identifies the work preferences to be updated
1285 * @param p_location Free text location a person is interested in
1286 * @param p_distance_to_location Distance in miles the user is willing to
1287 * travel to work.
1288 * @param p_geocode_location Location for a geocode search
1289 * @param p_geocode_country Country for a geocode search
1290 * @param p_derived_location Exact derived locale to match on
1291 * @param p_location_id Identifies a location to match on
1292 * @param p_longitude Longitude for a geocode search
1293 * @param p_latitude Latitude for a geocode search
1294 * @param p_employee Indicates that the candidate is looking for an employee
1295 * job (Y or N)
1296 * @param p_contractor Indicates that the candidate is looking for a contract
1297 * job (Y or N)
1298 * @param p_employment_category Indicates whether the candidate is looking for
1299 * a full time or part time job (FULLTIME, PARTTIME or EITHER)
1300 * @param p_keywords Free text keywords for the search
1301 * @param p_travel_percentage Percentage of time a person is willing to spend
1302 * travelling. Valid values are defined by 'IRC_TRAVEL_PERCENTAGE' lookup type.
1303 * @param p_min_salary Minimum salary user is willing to accept.
1304 * @param p_salary_currency Salary currency
1305 * @param p_salary_period Salary period. Valid values are defined by
1306 * 'PAY_BASIS' lookup type.
1307 * @param p_match_competence Identifies if user wishes to match jobs against
1308 * the competencies he has entered (Y or N)
1309 * @param p_match_qualification Identifies if user wishes to match jobs against
1310 * the qualification he has entered (Y or N)
1311 * @param p_work_at_home Indicates how desirable it is to work at home. Valid
1312 * values are defined by 'IRC_WORK_AT_HOME' lookup type.
1313 * @param p_job_title Title of job the user wishes to be included in search.
1314 * @param p_department Reserved for future use
1315 * @param p_professional_area Professional area user wishes to work in. Valid
1316 * values are defined by 'IRC_PROFESSIONAL_AREA' lookup type.
1317 * @param p_description Reserved for future use
1318 * @param p_attribute_category This context value determines which flexfield
1319 * structure to use with the descriptive flexfield segments.
1320 * @param p_attribute1 Descriptive flexfield segment.
1321 * @param p_attribute2 Descriptive flexfield segment.
1322 * @param p_attribute3 Descriptive flexfield segment.
1323 * @param p_attribute4 Descriptive flexfield segment.
1324 * @param p_attribute5 Descriptive flexfield segment.
1325 * @param p_attribute6 Descriptive flexfield segment.
1326 * @param p_attribute7 Descriptive flexfield segment.
1327 * @param p_attribute8 Descriptive flexfield segment.
1328 * @param p_attribute9 Descriptive flexfield segment.
1329 * @param p_attribute10 Descriptive flexfield segment.
1330 * @param p_attribute11 Descriptive flexfield segment.
1331 * @param p_attribute12 Descriptive flexfield segment.
1332 * @param p_attribute13 Descriptive flexfield segment.
1333 * @param p_attribute14 Descriptive flexfield segment.
1334 * @param p_attribute15 Descriptive flexfield segment.
1335 * @param p_attribute16 Descriptive flexfield segment.
1336 * @param p_attribute17 Descriptive flexfield segment.
1337 * @param p_attribute18 Descriptive flexfield segment.
1338 * @param p_attribute19 Descriptive flexfield segment.
1339 * @param p_attribute20 Descriptive flexfield segment.
1340 * @param p_attribute21 Descriptive flexfield segment.
1341 * @param p_attribute22 Descriptive flexfield segment.
1342 * @param p_attribute23 Descriptive flexfield segment.
1343 * @param p_attribute24 Descriptive flexfield segment.
1344 * @param p_attribute25 Descriptive flexfield segment.
1345 * @param p_attribute26 Descriptive flexfield segment.
1346 * @param p_attribute27 Descriptive flexfield segment.
1347 * @param p_attribute28 Descriptive flexfield segment.
1348 * @param p_attribute29 Descriptive flexfield segment.
1349 * @param p_attribute30 Descriptive flexfield segment.
1350 * @param p_isc_information_category Developer Descriptive flexfield segment.
1354 * @param p_isc_information4 Developer Descriptive flexfield segment.
1351 * @param p_isc_information1 Developer Descriptive flexfield segment.
1352 * @param p_isc_information2 Developer Descriptive flexfield segment.
1353 * @param p_isc_information3 Developer Descriptive flexfield segment.
1355 * @param p_isc_information5 Developer Descriptive flexfield segment.
1356 * @param p_isc_information6 Developer Descriptive flexfield segment.
1357 * @param p_isc_information7 Developer Descriptive flexfield segment.
1358 * @param p_isc_information8 Developer Descriptive flexfield segment.
1359 * @param p_isc_information9 Developer Descriptive flexfield segment.
1360 * @param p_isc_information10 Developer Descriptive flexfield segment.
1361 * @param p_isc_information11 Developer Descriptive flexfield segment.
1362 * @param p_isc_information12 Developer Descriptive flexfield segment.
1363 * @param p_isc_information13 Developer Descriptive flexfield segment.
1364 * @param p_isc_information14 Developer Descriptive flexfield segment.
1365 * @param p_isc_information15 Developer Descriptive flexfield segment.
1366 * @param p_isc_information16 Developer Descriptive flexfield segment.
1367 * @param p_isc_information17 Developer Descriptive flexfield segment.
1368 * @param p_isc_information18 Developer Descriptive flexfield segment.
1369 * @param p_isc_information19 Developer Descriptive flexfield segment.
1370 * @param p_isc_information20 Developer Descriptive flexfield segment.
1371 * @param p_isc_information21 Developer Descriptive flexfield segment.
1372 * @param p_isc_information22 Developer Descriptive flexfield segment.
1373 * @param p_isc_information23 Developer Descriptive flexfield segment.
1374 * @param p_isc_information24 Developer Descriptive flexfield segment.
1375 * @param p_isc_information25 Developer Descriptive flexfield segment.
1376 * @param p_isc_information26 Developer Descriptive flexfield segment.
1377 * @param p_isc_information27 Developer Descriptive flexfield segment.
1378 * @param p_isc_information28 Developer Descriptive flexfield segment.
1379 * @param p_isc_information29 Developer Descriptive flexfield segment.
1380 * @param p_isc_information30 Developer Descriptive flexfield segment.
1381 * @param p_object_version_number Pass in the current version number of the
1382 * work preferences to be updated. When the API completes if p_validate is
1383 * false, will be set to the new version number of the updated work
1384 * preferences. If p_validate is true will be set to the same value which was
1385 * passed in.
1386 * @rep:displayname Update Work Preferences
1387 * @rep:category BUSINESS_ENTITY IRC_CANDIDATE_WORK_PREFERENCES
1388 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1389 * @rep:scope public
1390 * @rep:lifecycle active
1391 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1392 */
1393 --
1394 -- {End Of Comments}
1395 --
1396 procedure update_work_choices
1397 (p_validate in boolean default false
1398 ,p_effective_date in date
1399 ,p_search_criteria_id in number
1400 ,p_location in varchar2 default hr_api.g_varchar2
1401 ,p_distance_to_location in varchar2 default hr_api.g_varchar2
1402 ,p_geocode_location in varchar2 default hr_api.g_varchar2
1403 ,p_geocode_country in varchar2 default hr_api.g_varchar2
1404 ,p_derived_location in varchar2 default hr_api.g_varchar2
1405 ,p_location_id in number default hr_api.g_number
1406 ,p_longitude in number default hr_api.g_number
1407 ,p_latitude in number default hr_api.g_number
1408 ,p_employee in varchar2 default hr_api.g_varchar2
1409 ,p_contractor in varchar2 default hr_api.g_varchar2
1410 ,p_employment_category in varchar2 default hr_api.g_varchar2
1411 ,p_keywords in varchar2 default hr_api.g_varchar2
1412 ,p_travel_percentage in number default hr_api.g_number
1413 ,p_min_salary in number default hr_api.g_number
1414 ,p_salary_currency in varchar2 default hr_api.g_varchar2
1415 ,p_salary_period in varchar2 default hr_api.g_varchar2
1416 ,p_match_competence in varchar2 default hr_api.g_varchar2
1417 ,p_match_qualification in varchar2 default hr_api.g_varchar2
1418 ,p_work_at_home in varchar2 default hr_api.g_varchar2
1419 ,p_job_title in varchar2 default hr_api.g_varchar2
1420 ,p_department in varchar2 default hr_api.g_varchar2
1421 ,p_professional_area in varchar2 default hr_api.g_varchar2
1422 ,p_description in varchar2 default hr_api.g_varchar2
1423 ,p_attribute_category in varchar2 default hr_api.g_varchar2
1424 ,p_attribute1 in varchar2 default hr_api.g_varchar2
1425 ,p_attribute2 in varchar2 default hr_api.g_varchar2
1426 ,p_attribute3 in varchar2 default hr_api.g_varchar2
1427 ,p_attribute4 in varchar2 default hr_api.g_varchar2
1428 ,p_attribute5 in varchar2 default hr_api.g_varchar2
1429 ,p_attribute6 in varchar2 default hr_api.g_varchar2
1430 ,p_attribute7 in varchar2 default hr_api.g_varchar2
1431 ,p_attribute8 in varchar2 default hr_api.g_varchar2
1432 ,p_attribute9 in varchar2 default hr_api.g_varchar2
1433 ,p_attribute10 in varchar2 default hr_api.g_varchar2
1434 ,p_attribute11 in varchar2 default hr_api.g_varchar2
1435 ,p_attribute12 in varchar2 default hr_api.g_varchar2
1436 ,p_attribute13 in varchar2 default hr_api.g_varchar2
1437 ,p_attribute14 in varchar2 default hr_api.g_varchar2
1438 ,p_attribute15 in varchar2 default hr_api.g_varchar2
1439 ,p_attribute16 in varchar2 default hr_api.g_varchar2
1440 ,p_attribute17 in varchar2 default hr_api.g_varchar2
1441 ,p_attribute18 in varchar2 default hr_api.g_varchar2
1442 ,p_attribute19 in varchar2 default hr_api.g_varchar2
1443 ,p_attribute20 in varchar2 default hr_api.g_varchar2
1444 ,p_attribute21 in varchar2 default hr_api.g_varchar2
1445 ,p_attribute22 in varchar2 default hr_api.g_varchar2
1446 ,p_attribute23 in varchar2 default hr_api.g_varchar2
1447 ,p_attribute24 in varchar2 default hr_api.g_varchar2
1448 ,p_attribute25 in varchar2 default hr_api.g_varchar2
1449 ,p_attribute26 in varchar2 default hr_api.g_varchar2
1450 ,p_attribute27 in varchar2 default hr_api.g_varchar2
1451 ,p_attribute28 in varchar2 default hr_api.g_varchar2
1452 ,p_attribute29 in varchar2 default hr_api.g_varchar2
1453 ,p_attribute30 in varchar2 default hr_api.g_varchar2
1454 ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1455 ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1456 ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1457 ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1458 ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1459 ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1460 ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1461 ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1462 ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1463 ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1464 ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1465 ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1466 ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1467 ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1468 ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1469 ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1470 ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1471 ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1472 ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1473 ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1474 ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1475 ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1476 ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1477 ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1478 ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1479 ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1480 ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1481 ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1482 ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1483 ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1484 ,p_isc_information30 in varchar2 default hr_api.g_varchar2
1485 ,p_object_version_number in out nocopy number
1486 );
1487 --
1488 -- ----------------------------------------------------------------------------
1489 -- |---------------------------< delete_work_choices >------------------------|
1490 -- ----------------------------------------------------------------------------
1491 --
1492 -- {Start Of Comments}
1493 /*#
1494 * This API deletes a candidate's work preferences.
1495 *
1496 * The work preferences will no longer be available for the manager to view.
1497 *
1498 * <p><b>Licensing</b><br>
1499 * This API is licensed for use with iRecruitment.
1500 *
1501 * <p><b>Prerequisites</b><br>
1502 * The work preferences must exist in the database
1503 *
1504 * <p><b>Post Success</b><br>
1505 * The work preferences will be deleted from the database
1506 *
1507 * <p><b>Post Failure</b><br>
1508 * The work preferences will not be deleted and an error will be raised.
1509 * @param p_validate If true, then validation alone will be performed and the
1510 * database will remain unchanged. If false and all validation checks pass,
1511 * then the database will be modified.
1512 * @param p_search_criteria_id Identifies the work preferences to be deleted
1513 * @param p_object_version_number Current version number of the work
1514 * preferences to be deleted.
1515 * @rep:displayname Delete Work Preferences
1516 * @rep:category BUSINESS_ENTITY IRC_CANDIDATE_WORK_PREFERENCES
1517 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1518 * @rep:scope public
1519 * @rep:lifecycle active
1520 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1521 */
1522 --
1523 -- {End Of Comments}
1524 --
1525 procedure delete_work_choices
1526 (p_validate in boolean default false
1527 ,p_search_criteria_id in number
1528 ,p_object_version_number in number
1529 );
1530 --
1531 end IRC_SEARCH_CRITERIA_API;