1 package IRC_PARTY_API AUTHID CURRENT_USER as
2 /* $Header: irhzpapi.pkh 120.23 2011/06/17 10:30:37 amikukum ship $ */
3 /*#
4 * This package contains recruiting candidate APIs.
5 * @rep:scope public
6 * @rep:product irc
7 * @rep:displayname Party
8 */
9 --
10 -- globals to store person_id and ovn of person record that
11 -- has been updated
12 g_person_id number default hr_api.g_number;
13 g_ovn_for_person number default hr_api.g_number;
14 type idList is table of integer index by binary_integer;
15 --
16 -- ----------------------------------------------------------------------------
17 -- |------------------------< create_candidate_internal >---------------------|
18 -- ----------------------------------------------------------------------------
19 --
20 -- {Start Of Comments}
21 /*#
22 * This API creates a person record.
23 *
24 *
25 * <p><b>Licensing</b><br>
26 * This API is licensed for use with iRecruitment.
27 *
28 * <p><b>Prerequisites</b><br>
29 * None
30 *
31 * <p><b>Post Success</b><br>
32 * A person record is created.
33 *
34 * <p><b>Post Failure</b><br>
35 * The API fails to create the person and raises an error.
36 *
37 * @param p_validate If true, then validation alone will be performed and the
38 * database will remain unchanged. If false and all validation checks pass,
39 * then the database will be modified.
43 * @param p_last_name The last name of the registered user
40 * @param p_business_group_id Uniquely identifies the business group in which
41 * the previous employer record is created. It must be the same as the person's
42 * business group.
44 * @param p_first_name The first name of the registered user
45 * @param p_date_of_birth The date of birth of the registered user
46 * @param p_email_address The e-mail address of the registered user
47 * @param p_title The title of the registered user. Valid values are defined by
48 * the 'TITLE' lookup type
49 * @param p_gender The gender of the registered user. Valid values are defined
50 * by the 'SEX' lookup type
51 * @param p_marital_status The marital status of the registered user. Valid
52 * values are defined by the 'MAR_STATUS' lookup type
53 * @param p_previous_last_name The previous last name of the registered user.
54 * @param p_middle_name The middle name of the registered user.
55 * @param p_name_suffix Suffix after the person's last name.
56 * @param p_known_as The name by which the registered user is known.
57 * @param p_first_name_phonetic Obsolete parameter. Do not use
58 * @param p_last_name_phonetic Obsolete parameter. Do not use
59 * @param p_attribute_category This context value determines which flexfield
60 * structure to use with the descriptive flexfield segments.
61 * @param p_attribute1 Descriptive flexfield segment.
62 * @param p_attribute2 Descriptive flexfield segment.
63 * @param p_attribute3 Descriptive flexfield segment.
64 * @param p_attribute4 Descriptive flexfield segment.
65 * @param p_attribute5 Descriptive flexfield segment.
66 * @param p_attribute6 Descriptive flexfield segment.
67 * @param p_attribute7 Descriptive flexfield segment.
68 * @param p_attribute8 Descriptive flexfield segment.
69 * @param p_attribute9 Descriptive flexfield segment.
70 * @param p_attribute10 Descriptive flexfield segment.
71 * @param p_attribute11 Descriptive flexfield segment.
72 * @param p_attribute12 Descriptive flexfield segment.
73 * @param p_attribute13 Descriptive flexfield segment.
74 * @param p_attribute14 Descriptive flexfield segment.
75 * @param p_attribute15 Descriptive flexfield segment.
76 * @param p_attribute16 Descriptive flexfield segment.
77 * @param p_attribute17 Descriptive flexfield segment.
78 * @param p_attribute18 Descriptive flexfield segment.
79 * @param p_attribute19 Descriptive flexfield segment.
80 * @param p_attribute20 Descriptive flexfield segment.
81 * @param p_attribute21 Descriptive flexfield segment.
82 * @param p_attribute22 Descriptive flexfield segment.
83 * @param p_attribute23 Descriptive flexfield segment.
84 * @param p_attribute24 Descriptive flexfield segment.
85 * @param p_attribute25 Descriptive flexfield segment.
86 * @param p_attribute26 Descriptive flexfield segment.
87 * @param p_attribute27 Descriptive flexfield segment.
88 * @param p_attribute28 Descriptive flexfield segment.
89 * @param p_attribute29 Descriptive flexfield segment.
90 * @param p_attribute30 Descriptive flexfield segment.
91 * @param p_per_information_category Obsolete parameter, do not use.
92 * @param p_per_information1 Developer descriptive flexfield segment.
93 * @param p_per_information2 Developer descriptive flexfield segment.
94 * @param p_per_information3 Developer descriptive flexfield segment.
95 * @param p_per_information4 Developer descriptive flexfield segment.
96 * @param p_per_information5 Developer descriptive flexfield segment.
97 * @param p_per_information6 Developer descriptive flexfield segment.
98 * @param p_per_information7 Developer descriptive flexfield segment.
99 * @param p_per_information8 Developer descriptive flexfield segment.
100 * @param p_per_information9 Developer descriptive flexfield segment.
101 * @param p_per_information10 Developer descriptive flexfield segment.
102 * @param p_per_information11 Developer descriptive flexfield segment.
103 * @param p_per_information12 Developer descriptive flexfield segment.
104 * @param p_per_information13 Developer descriptive flexfield segment.
105 * @param p_per_information14 Developer descriptive flexfield segment.
106 * @param p_per_information15 Developer descriptive flexfield segment.
107 * @param p_per_information16 Developer descriptive flexfield segment.
108 * @param p_per_information17 Developer descriptive flexfield segment.
109 * @param p_per_information18 Developer descriptive flexfield segment.
110 * @param p_per_information19 Developer descriptive flexfield segment.
111 * @param p_per_information20 Developer descriptive flexfield segment.
112 * @param p_per_information21 Developer descriptive flexfield segment.
113 * @param p_per_information22 Developer descriptive flexfield segment.
114 * @param p_per_information23 Developer descriptive flexfield segment.
115 * @param p_per_information24 Developer descriptive flexfield segment.
116 * @param p_per_information25 Developer descriptive flexfield segment.
117 * @param p_per_information26 Developer descriptive flexfield segment.
118 * @param p_per_information27 Developer descriptive flexfield segment.
119 * @param p_per_information28 Developer descriptive flexfield segment.
120 * @param p_per_information29 Developer descriptive flexfield segment.
121 * @param p_per_information30 Developer descriptive flexfield segment.
122 * @param p_nationality The nationality of the user
123 * @param p_national_identifier The national identifier of the user
124 * @param p_town_of_birth The town of birth of the user
125 * @param p_region_of_birth The region of birth of the user
126 * @param p_country_of_birth The country of birth of the user
127 * @param p_allow_access Indicates whether the user's details are available to
128 * recruiters when they search for candidates in iRecruitment.
129 * @param p_party_id Party ID for the person.
130 * @param p_start_date The start date of the registered user's account.
131 * @param p_effective_start_date If p_validate is false, then set to the
132 * earliest effective start date for the created registered user. If p_validate
133 * is true, then set to null.
137 * @param p_person_id If p_validate is false, then this uniquely identifies the
134 * @param p_effective_end_date If p_validate is false, then set to the
135 * effective end date for the created registered user. If p_validate is true,
136 * then set to null.
138 * registered user created. If p_validate is true, then set to null.
139 * @rep:displayname Create Candidate Internal
140 * @rep:category BUSINESS_ENTITY IRC_RECRUITMENT_CANDIDATE
141 * @rep:lifecycle active
142 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
143 * @rep:scope public
144 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
145 */
146 --
147 -- {End Of Comments}
148 --
149 procedure create_candidate_internal
150 (p_validate IN boolean default false
151 ,p_business_group_id IN number
152 ,p_last_name IN varchar2
153 ,p_first_name IN varchar2 default null
154 ,p_date_of_birth IN date default null
155 ,p_email_address IN varchar2 default null
156 ,p_title IN varchar2 default null
157 ,p_gender IN varchar2 default null
158 ,p_marital_status IN varchar2 default null
159 ,p_previous_last_name IN varchar2 default null
160 ,p_middle_name IN varchar2 default null
161 ,p_name_suffix IN varchar2 default null
162 ,p_known_as IN varchar2 default null
163 ,p_first_name_phonetic IN varchar2 default null
164 ,p_last_name_phonetic IN varchar2 default null
165 ,p_attribute_category IN varchar2 default null
166 ,p_attribute1 IN varchar2 default null
167 ,p_attribute2 IN varchar2 default null
168 ,p_attribute3 IN varchar2 default null
169 ,p_attribute4 IN varchar2 default null
170 ,p_attribute5 IN varchar2 default null
171 ,p_attribute6 IN varchar2 default null
172 ,p_attribute7 IN varchar2 default null
173 ,p_attribute8 IN varchar2 default null
174 ,p_attribute9 IN varchar2 default null
175 ,p_attribute10 IN varchar2 default null
176 ,p_attribute11 IN varchar2 default null
177 ,p_attribute12 IN varchar2 default null
178 ,p_attribute13 IN varchar2 default null
179 ,p_attribute14 IN varchar2 default null
180 ,p_attribute15 IN varchar2 default null
181 ,p_attribute16 IN varchar2 default null
182 ,p_attribute17 IN varchar2 default null
183 ,p_attribute18 IN varchar2 default null
184 ,p_attribute19 IN varchar2 default null
185 ,p_attribute20 IN varchar2 default null
186 ,p_attribute21 IN varchar2 default null
187 ,p_attribute22 IN varchar2 default null
188 ,p_attribute23 IN varchar2 default null
189 ,p_attribute24 IN varchar2 default null
190 ,p_attribute25 IN varchar2 default null
191 ,p_attribute26 IN varchar2 default null
192 ,p_attribute27 IN varchar2 default null
193 ,p_attribute28 IN varchar2 default null
194 ,p_attribute29 IN varchar2 default null
195 ,p_attribute30 IN varchar2 default null
196 ,p_per_information_category IN varchar2 default null
197 ,p_per_information1 IN varchar2 default null
198 ,p_per_information2 IN varchar2 default null
199 ,p_per_information3 IN varchar2 default null
200 ,p_per_information4 IN varchar2 default null
201 ,p_per_information5 IN varchar2 default null
202 ,p_per_information6 IN varchar2 default null
203 ,p_per_information7 IN varchar2 default null
204 ,p_per_information8 IN varchar2 default null
205 ,p_per_information9 IN varchar2 default null
206 ,p_per_information10 IN varchar2 default null
207 ,p_per_information11 IN varchar2 default null
208 ,p_per_information12 IN varchar2 default null
209 ,p_per_information13 IN varchar2 default null
210 ,p_per_information14 IN varchar2 default null
211 ,p_per_information15 IN varchar2 default null
212 ,p_per_information16 IN varchar2 default null
213 ,p_per_information17 IN varchar2 default null
214 ,p_per_information18 IN varchar2 default null
215 ,p_per_information19 IN varchar2 default null
216 ,p_per_information20 IN varchar2 default null
217 ,p_per_information21 IN varchar2 default null
218 ,p_per_information22 IN varchar2 default null
219 ,p_per_information23 IN varchar2 default null
220 ,p_per_information24 IN varchar2 default null
221 ,p_per_information25 IN varchar2 default null
222 ,p_per_information26 IN varchar2 default null
223 ,p_per_information27 IN varchar2 default null
224 ,p_per_information28 IN varchar2 default null
225 ,p_per_information29 IN varchar2 default null
226 ,p_per_information30 IN varchar2 default null
227 ,p_nationality IN varchar2 default null
228 ,p_national_identifier IN varchar2 default null
229 ,p_town_of_birth IN varchar2 default null
230 ,p_region_of_birth IN varchar2 default null
231 ,p_country_of_birth IN varchar2 default null
232 ,p_allow_access IN varchar2 default null
233 ,p_party_id IN number default null
237 ,p_person_id OUT NOCOPY number
234 ,p_start_date IN date default null
235 ,p_effective_start_date OUT NOCOPY date
236 ,p_effective_end_date OUT NOCOPY date
238 );
239 --
240 -- ----------------------------------------------------------------------------
241 -- |--------------------------< create_registered_user >----------------------|
242 -- ----------------------------------------------------------------------------
243 --
244 -- {Start Of Comments}
245 /*#
246 * This API creates a registered user with work preferences and notification
247 * preferences.
248 *
249 * This API does not create a login for the registered user. To create the
250 * registered user complete with a login, call the create_user API.
251 *
252 * <p><b>Licensing</b><br>
253 * This API is licensed for use with iRecruitment.
254 *
255 * <p><b>Prerequisites</b><br>
256 * None.
257 *
258 * <p><b>Post Success</b><br>
259 * The API successfully creates a registered user.
260 *
261 * <p><b>Post Failure</b><br>
262 * The API fails to create a registered user and raises an error.
263 * @param p_validate If true, then validation alone will be performed and the
264 * database will remain unchanged. If false and all validation checks pass,
265 * then the database will be modified.
266 * @param p_last_name The last name of the registered user.
267 * @param p_first_name The first name of the registered user.
268 * @param p_date_of_birth The date of birth of the registered user.
269 * @param p_email_address The e-mail address of the registered user.
270 * @param p_title The title of the registered user. Valid values are defined by
271 * the 'TITLE' lookup type.
272 * @param p_gender The gender of the registered user. Valid values are defined
273 * by the 'SEX' lookup type.
274 * @param p_marital_status The marital status of the registered user. Valid
275 * values are defined by the 'MAR_STATUS' lookup type.
276 * @param p_previous_last_name The previous last name of the registered user.
277 * @param p_middle_name The middle name of the registered user.
278 * @param p_name_suffix Suffix after the person's last name.
279 * @param p_known_as The name by which the registered user is known.
280 * @param p_first_name_phonetic Obsolete parameter. Do not use.
281 * @param p_last_name_phonetic Obsolete parameter. Do not use.
282 * @param p_attribute_category This context value determines which flexfield
283 * structure to use with the descriptive flexfield segments.
284 * @param p_attribute1 Descriptive flexfield segment.
285 * @param p_attribute2 Descriptive flexfield segment.
286 * @param p_attribute3 Descriptive flexfield segment.
287 * @param p_attribute4 Descriptive flexfield segment.
288 * @param p_attribute5 Descriptive flexfield segment.
289 * @param p_attribute6 Descriptive flexfield segment.
290 * @param p_attribute7 Descriptive flexfield segment.
291 * @param p_attribute8 Descriptive flexfield segment.
292 * @param p_attribute9 Descriptive flexfield segment.
293 * @param p_attribute10 Descriptive flexfield segment.
294 * @param p_attribute11 Descriptive flexfield segment.
295 * @param p_attribute12 Descriptive flexfield segment.
296 * @param p_attribute13 Descriptive flexfield segment.
297 * @param p_attribute14 Descriptive flexfield segment.
298 * @param p_attribute15 Descriptive flexfield segment.
299 * @param p_attribute16 Descriptive flexfield segment.
300 * @param p_attribute17 Descriptive flexfield segment.
301 * @param p_attribute18 Descriptive flexfield segment.
302 * @param p_attribute19 Descriptive flexfield segment.
303 * @param p_attribute20 Descriptive flexfield segment.
304 * @param p_attribute21 Descriptive flexfield segment.
305 * @param p_attribute22 Descriptive flexfield segment.
306 * @param p_attribute23 Descriptive flexfield segment.
307 * @param p_attribute24 Descriptive flexfield segment.
308 * @param p_attribute25 Descriptive flexfield segment.
309 * @param p_attribute26 Descriptive flexfield segment.
310 * @param p_attribute27 Descriptive flexfield segment.
311 * @param p_attribute28 Descriptive flexfield segment.
312 * @param p_attribute29 Descriptive flexfield segment.
313 * @param p_attribute30 Descriptive flexfield segment.
314 * @param p_per_information_category Obsolete parameter, do not use.
315 * @param p_per_information1 Developer descriptive flexfield segment.
316 * @param p_per_information2 Developer descriptive flexfield segment.
317 * @param p_per_information3 Developer descriptive flexfield segment.
318 * @param p_per_information4 Developer descriptive flexfield segment.
319 * @param p_per_information5 Developer descriptive flexfield segment.
320 * @param p_per_information6 Developer descriptive flexfield segment.
321 * @param p_per_information7 Developer descriptive flexfield segment.
322 * @param p_per_information8 Developer descriptive flexfield segment.
323 * @param p_per_information9 Developer descriptive flexfield segment.
324 * @param p_per_information10 Developer descriptive flexfield segment.
325 * @param p_per_information11 Developer descriptive flexfield segment.
326 * @param p_per_information12 Developer descriptive flexfield segment.
327 * @param p_per_information13 Developer descriptive flexfield segment.
328 * @param p_per_information14 Developer descriptive flexfield segment.
329 * @param p_per_information15 Developer descriptive flexfield segment.
330 * @param p_per_information16 Developer descriptive flexfield segment.
331 * @param p_per_information17 Developer descriptive flexfield segment.
332 * @param p_per_information18 Developer descriptive flexfield segment.
333 * @param p_per_information19 Developer descriptive flexfield segment.
334 * @param p_per_information20 Developer descriptive flexfield segment.
335 * @param p_per_information21 Developer descriptive flexfield segment.
336 * @param p_per_information22 Developer descriptive flexfield segment.
337 * @param p_per_information23 Developer descriptive flexfield segment.
341 * @param p_per_information27 Developer descriptive flexfield segment.
338 * @param p_per_information24 Developer descriptive flexfield segment.
339 * @param p_per_information25 Developer descriptive flexfield segment.
340 * @param p_per_information26 Developer descriptive flexfield segment.
342 * @param p_per_information28 Developer descriptive flexfield segment.
343 * @param p_per_information29 Developer descriptive flexfield segment.
344 * @param p_per_information30 Developer descriptive flexfield segment.
345 * @param p_effective_start_date If p_validate is false, then set to the
346 * earliest effective start date for the created registered user. If p_validate
347 * is true, then set to null.
348 * @param p_effective_end_date If p_validate is false, then set to the
349 * effective end date for the created registered user. If p_validate is true,
350 * then set to null.
351 * @param p_person_id If p_validate is false, then this uniquely identifies the
352 * registered user created. If p_validate is true, then set to null.
353 * @param p_allow_access Indicates whether the user's details are available to
354 * recruiters when they search for candidates in iRecruitment.
355 * @param p_start_date The start date of the registered user's account.
356 * @rep:displayname Create Registered User
357 * @rep:category BUSINESS_ENTITY IRC_RECRUITMENT_CANDIDATE
358 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
359 * @rep:scope public
360 * @rep:lifecycle active
361 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
362 */
363 --
364 -- {End Of Comments}
365 --
366 procedure create_registered_user
367 (p_validate IN boolean default false
368 ,p_last_name IN varchar2
369 ,p_first_name IN varchar2 default null
370 ,p_date_of_birth IN date default null
371 ,p_email_address IN varchar2 default null
372 ,p_title IN varchar2 default null
373 ,p_gender IN varchar2 default null
374 ,p_marital_status IN varchar2 default null
375 ,p_previous_last_name IN varchar2 default null
376 ,p_middle_name IN varchar2 default null
377 ,p_name_suffix IN varchar2 default null
378 ,p_known_as IN varchar2 default null
379 ,p_first_name_phonetic IN varchar2 default null
380 ,p_last_name_phonetic IN varchar2 default null
381 ,p_attribute_category IN varchar2 default null
382 ,p_attribute1 IN varchar2 default null
383 ,p_attribute2 IN varchar2 default null
384 ,p_attribute3 IN varchar2 default null
385 ,p_attribute4 IN varchar2 default null
386 ,p_attribute5 IN varchar2 default null
387 ,p_attribute6 IN varchar2 default null
388 ,p_attribute7 IN varchar2 default null
389 ,p_attribute8 IN varchar2 default null
390 ,p_attribute9 IN varchar2 default null
391 ,p_attribute10 IN varchar2 default null
392 ,p_attribute11 IN varchar2 default null
393 ,p_attribute12 IN varchar2 default null
394 ,p_attribute13 IN varchar2 default null
395 ,p_attribute14 IN varchar2 default null
396 ,p_attribute15 IN varchar2 default null
397 ,p_attribute16 IN varchar2 default null
398 ,p_attribute17 IN varchar2 default null
399 ,p_attribute18 IN varchar2 default null
400 ,p_attribute19 IN varchar2 default null
401 ,p_attribute20 IN varchar2 default null
402 ,p_attribute21 IN varchar2 default null
403 ,p_attribute22 IN varchar2 default null
404 ,p_attribute23 IN varchar2 default null
405 ,p_attribute24 IN varchar2 default null
406 ,p_attribute25 IN varchar2 default null
407 ,p_attribute26 IN varchar2 default null
408 ,p_attribute27 IN varchar2 default null
409 ,p_attribute28 IN varchar2 default null
410 ,p_attribute29 IN varchar2 default null
411 ,p_attribute30 IN varchar2 default null
412 ,p_per_information_category IN varchar2 default null
413 ,p_per_information1 IN varchar2 default null
414 ,p_per_information2 IN varchar2 default null
415 ,p_per_information3 IN varchar2 default null
416 ,p_per_information4 IN varchar2 default null
417 ,p_per_information5 IN varchar2 default null
418 ,p_per_information6 IN varchar2 default null
419 ,p_per_information7 IN varchar2 default null
420 ,p_per_information8 IN varchar2 default null
421 ,p_per_information9 IN varchar2 default null
422 ,p_per_information10 IN varchar2 default null
423 ,p_per_information11 IN varchar2 default null
424 ,p_per_information12 IN varchar2 default null
425 ,p_per_information13 IN varchar2 default null
426 ,p_per_information14 IN varchar2 default null
427 ,p_per_information15 IN varchar2 default null
428 ,p_per_information16 IN varchar2 default null
429 ,p_per_information17 IN varchar2 default null
430 ,p_per_information18 IN varchar2 default null
431 ,p_per_information19 IN varchar2 default null
432 ,p_per_information20 IN varchar2 default null
433 ,p_per_information21 IN varchar2 default null
434 ,p_per_information22 IN varchar2 default null
435 ,p_per_information23 IN varchar2 default null
436 ,p_per_information24 IN varchar2 default null
440 ,p_per_information28 IN varchar2 default null
437 ,p_per_information25 IN varchar2 default null
438 ,p_per_information26 IN varchar2 default null
439 ,p_per_information27 IN varchar2 default null
441 ,p_per_information29 IN varchar2 default null
442 ,p_per_information30 IN varchar2 default null
443 ,p_allow_access IN varchar2 default null
444 ,p_start_date IN date default null
445 ,p_effective_start_date OUT NOCOPY date
446 ,p_effective_end_date OUT NOCOPY date
447 ,p_person_id OUT NOCOPY number
448 );
449 --
450 -- ----------------------------------------------------------------------------
451 -- |--------------------------< update_registered_user >----------------------|
452 -- ----------------------------------------------------------------------------
453 --
454 -- {Start Of Comments}
455 /*#
456 * This API updates a registered user's details.
457 *
458 *
459 * <p><b>Licensing</b><br>
460 * This API is licensed for use with iRecruitment.
461 *
462 * <p><b>Prerequisites</b><br>
463 * The registered user must exist in the database.
464 *
465 * <p><b>Post Success</b><br>
466 * The registered user's information will be updated.
467 *
468 * <p><b>Post Failure</b><br>
469 * The registered user's information will not be updated, and an error will be
470 * raised
471 * @param p_validate If true, then validation alone will be performed and the
472 * database will remain unchanged. If false and all validation checks pass,
473 * then the database will be modified.
474 * @param p_effective_date Determines when the DateTrack operation comes
475 * into force.
476 * @param p_person_id Identifies the registered user record to be updated.
477 * @param p_first_name The first name of the registered user.
478 * @param p_last_name The last name of the registered user.
479 * @param p_date_of_birth The date of birth of the registered user.
480 * @param p_title The title of the registered user. Valid values are defined by
481 * the 'TITLE' lookup type.
482 * @param p_gender The gender of the registered user. Valid values are defined
483 * by the 'SEX' lookup type.
484 * @param p_marital_status The marital status of the registered user. Valid
485 * values are defined by the 'MAR_STATUS' lookup type.
486 * @param p_previous_last_name The previous last name of the registered user.
487 * @param p_middle_name The middle name of the registered user.
488 * @param p_name_suffix Suffix after the person's last name.
489 * @param p_known_as The name by which the registered user is known.
490 * @param p_first_name_phonetic Obsolete parameter. Do not use.
491 * @param p_last_name_phonetic Obsolete parameter. Do not use.
492 * @param p_attribute_category This context value determines which flexfield
493 * structure to use with the descriptive flexfield segments.
494 * @param p_attribute1 Descriptive flexfield segment.
495 * @param p_attribute2 Descriptive flexfield segment.
496 * @param p_attribute3 Descriptive flexfield segment.
497 * @param p_attribute4 Descriptive flexfield segment.
498 * @param p_attribute5 Descriptive flexfield segment.
499 * @param p_attribute6 Descriptive flexfield segment.
500 * @param p_attribute7 Descriptive flexfield segment.
501 * @param p_attribute8 Descriptive flexfield segment.
502 * @param p_attribute9 Descriptive flexfield segment.
503 * @param p_attribute10 Descriptive flexfield segment.
504 * @param p_attribute11 Descriptive flexfield segment.
505 * @param p_attribute12 Descriptive flexfield segment.
506 * @param p_attribute13 Descriptive flexfield segment.
507 * @param p_attribute14 Descriptive flexfield segment.
508 * @param p_attribute15 Descriptive flexfield segment.
509 * @param p_attribute16 Descriptive flexfield segment.
510 * @param p_attribute17 Descriptive flexfield segment.
511 * @param p_attribute18 Descriptive flexfield segment.
512 * @param p_attribute19 Descriptive flexfield segment.
513 * @param p_attribute20 Descriptive flexfield segment.
514 * @param p_attribute21 Descriptive flexfield segment.
515 * @param p_attribute22 Descriptive flexfield segment.
516 * @param p_attribute23 Descriptive flexfield segment.
517 * @param p_attribute24 Descriptive flexfield segment.
518 * @param p_attribute25 Descriptive flexfield segment.
519 * @param p_attribute26 Descriptive flexfield segment.
520 * @param p_attribute27 Descriptive flexfield segment.
521 * @param p_attribute28 Descriptive flexfield segment.
522 * @param p_attribute29 Descriptive flexfield segment.
523 * @param p_attribute30 Descriptive flexfield segment.
524 * @param p_per_information_category Obsolete parameter, do not use.
525 * @param p_per_information1 Developer descriptive flexfield segment.
526 * @param p_per_information2 Developer descriptive flexfield segment.
527 * @param p_per_information3 Developer descriptive flexfield segment.
528 * @param p_per_information4 Developer descriptive flexfield segment.
529 * @param p_per_information5 Developer descriptive flexfield segment.
530 * @param p_per_information6 Developer descriptive flexfield segment.
531 * @param p_per_information7 Developer descriptive flexfield segment.
532 * @param p_per_information8 Developer descriptive flexfield segment.
533 * @param p_per_information9 Developer descriptive flexfield segment.
534 * @param p_per_information10 Developer descriptive flexfield segment.
535 * @param p_per_information11 Developer descriptive flexfield segment.
536 * @param p_per_information12 Developer descriptive flexfield segment.
537 * @param p_per_information13 Developer descriptive flexfield segment.
538 * @param p_per_information14 Developer descriptive flexfield segment.
539 * @param p_per_information15 Developer descriptive flexfield segment.
540 * @param p_per_information16 Developer descriptive flexfield segment.
541 * @param p_per_information17 Developer descriptive flexfield segment.
545 * @param p_per_information21 Developer descriptive flexfield segment.
542 * @param p_per_information18 Developer descriptive flexfield segment.
543 * @param p_per_information19 Developer descriptive flexfield segment.
544 * @param p_per_information20 Developer descriptive flexfield segment.
546 * @param p_per_information22 Developer descriptive flexfield segment.
547 * @param p_per_information23 Developer descriptive flexfield segment.
548 * @param p_per_information24 Developer descriptive flexfield segment.
549 * @param p_per_information25 Developer descriptive flexfield segment.
550 * @param p_per_information26 Developer descriptive flexfield segment.
551 * @param p_per_information27 Developer descriptive flexfield segment.
552 * @param p_per_information28 Developer descriptive flexfield segment.
553 * @param p_per_information29 Developer descriptive flexfield segment.
554 * @param p_per_information30 Developer descriptive flexfield segment.
555 * @rep:displayname Update Registered User
556 * @rep:category BUSINESS_ENTITY IRC_RECRUITMENT_CANDIDATE
557 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
558 * @rep:scope public
559 * @rep:lifecycle active
560 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
561 */
562 --
563 -- {End Of Comments}
564 --
565 procedure update_registered_user
566 (p_validate IN boolean default false
567 ,p_effective_date IN date
568 ,p_person_id IN number
569 ,p_first_name IN varchar2 default hr_api.g_varchar2
570 ,p_last_name IN varchar2 default hr_api.g_varchar2
571 ,p_date_of_birth IN date default hr_api.g_date
572 ,p_title IN varchar2 default hr_api.g_varchar2
573 ,p_gender IN varchar2 default hr_api.g_varchar2
574 ,p_marital_status IN varchar2 default hr_api.g_varchar2
575 ,p_previous_last_name IN varchar2 default hr_api.g_varchar2
576 ,p_middle_name IN varchar2 default hr_api.g_varchar2
577 ,p_name_suffix IN varchar2 default hr_api.g_varchar2
578 ,p_known_as IN varchar2 default hr_api.g_varchar2
579 ,p_first_name_phonetic IN varchar2 default hr_api.g_varchar2
580 ,p_last_name_phonetic IN varchar2 default hr_api.g_varchar2
581 ,p_attribute_category IN varchar2 default hr_api.g_varchar2
582 ,p_attribute1 IN varchar2 default hr_api.g_varchar2
583 ,p_attribute2 IN varchar2 default hr_api.g_varchar2
584 ,p_attribute3 IN varchar2 default hr_api.g_varchar2
585 ,p_attribute4 IN varchar2 default hr_api.g_varchar2
586 ,p_attribute5 IN varchar2 default hr_api.g_varchar2
587 ,p_attribute6 IN varchar2 default hr_api.g_varchar2
588 ,p_attribute7 IN varchar2 default hr_api.g_varchar2
589 ,p_attribute8 IN varchar2 default hr_api.g_varchar2
590 ,p_attribute9 IN varchar2 default hr_api.g_varchar2
591 ,p_attribute10 IN varchar2 default hr_api.g_varchar2
592 ,p_attribute11 IN varchar2 default hr_api.g_varchar2
593 ,p_attribute12 IN varchar2 default hr_api.g_varchar2
594 ,p_attribute13 IN varchar2 default hr_api.g_varchar2
595 ,p_attribute14 IN varchar2 default hr_api.g_varchar2
596 ,p_attribute15 IN varchar2 default hr_api.g_varchar2
597 ,p_attribute16 IN varchar2 default hr_api.g_varchar2
598 ,p_attribute17 IN varchar2 default hr_api.g_varchar2
599 ,p_attribute18 IN varchar2 default hr_api.g_varchar2
600 ,p_attribute19 IN varchar2 default hr_api.g_varchar2
601 ,p_attribute20 IN varchar2 default hr_api.g_varchar2
602 ,p_attribute21 IN varchar2 default hr_api.g_varchar2
603 ,p_attribute22 IN varchar2 default hr_api.g_varchar2
604 ,p_attribute23 IN varchar2 default hr_api.g_varchar2
605 ,p_attribute24 IN varchar2 default hr_api.g_varchar2
606 ,p_attribute25 IN varchar2 default hr_api.g_varchar2
607 ,p_attribute26 IN varchar2 default hr_api.g_varchar2
608 ,p_attribute27 IN varchar2 default hr_api.g_varchar2
609 ,p_attribute28 IN varchar2 default hr_api.g_varchar2
610 ,p_attribute29 IN varchar2 default hr_api.g_varchar2
611 ,p_attribute30 IN varchar2 default hr_api.g_varchar2
612 ,p_per_information_category IN varchar2 default hr_api.g_varchar2
613 ,p_per_information1 IN varchar2 default hr_api.g_varchar2
614 ,p_per_information2 IN varchar2 default hr_api.g_varchar2
615 ,p_per_information3 IN varchar2 default hr_api.g_varchar2
616 ,p_per_information4 IN varchar2 default hr_api.g_varchar2
617 ,p_per_information5 IN varchar2 default hr_api.g_varchar2
618 ,p_per_information6 IN varchar2 default hr_api.g_varchar2
619 ,p_per_information7 IN varchar2 default hr_api.g_varchar2
620 ,p_per_information8 IN varchar2 default hr_api.g_varchar2
621 ,p_per_information9 IN varchar2 default hr_api.g_varchar2
622 ,p_per_information10 IN varchar2 default hr_api.g_varchar2
623 ,p_per_information11 IN varchar2 default hr_api.g_varchar2
624 ,p_per_information12 IN varchar2 default hr_api.g_varchar2
625 ,p_per_information13 IN varchar2 default hr_api.g_varchar2
626 ,p_per_information14 IN varchar2 default hr_api.g_varchar2
627 ,p_per_information15 IN varchar2 default hr_api.g_varchar2
628 ,p_per_information16 IN varchar2 default hr_api.g_varchar2
629 ,p_per_information17 IN varchar2 default hr_api.g_varchar2
633 ,p_per_information21 IN varchar2 default hr_api.g_varchar2
630 ,p_per_information18 IN varchar2 default hr_api.g_varchar2
631 ,p_per_information19 IN varchar2 default hr_api.g_varchar2
632 ,p_per_information20 IN varchar2 default hr_api.g_varchar2
634 ,p_per_information22 IN varchar2 default hr_api.g_varchar2
635 ,p_per_information23 IN varchar2 default hr_api.g_varchar2
636 ,p_per_information24 IN varchar2 default hr_api.g_varchar2
637 ,p_per_information25 IN varchar2 default hr_api.g_varchar2
638 ,p_per_information26 IN varchar2 default hr_api.g_varchar2
639 ,p_per_information27 IN varchar2 default hr_api.g_varchar2
640 ,p_per_information28 IN varchar2 default hr_api.g_varchar2
641 ,p_per_information29 IN varchar2 default hr_api.g_varchar2
642 ,p_per_information30 IN varchar2 default hr_api.g_varchar2
643 );
644 --
645 -- ----------------------------------------------------------------------------
646 -- |-----------------------< registered_user_application >--------------------|
647 -- ----------------------------------------------------------------------------
648 --
649 -- {Start Of Comments}
650 /*#
651 * This API creates a job application for a registered user.
652 *
653 *
654 * <p><b>Licensing</b><br>
655 * This API is licensed for use with iRecruitment.
656 *
657 * <p><b>Prerequisites</b><br>
658 * The registered user and the vacancy must exist in the database.
659 *
660 * <p><b>Post Success</b><br>
661 * The API successfully creates an application for the registered user.
662 *
663 * <p><b>Post Failure</b><br>
664 * The API fails to create an application and raises an error.
665 *
666 * @param p_validate If true, then validation alone will be performed and the
667 * database will remain unchanged. If false and all validation checks pass,
668 * then the database will be modified.
669 * @param p_effective_date Determines when the DateTrack operation comes
670 * into force.
671 * @param p_recruitment_person_id Identifies the registered user.
672 * @param p_person_id Identifies the new applicant, who may not be the same
673 * person as the registered user, if the registered user is applying to a
674 * different business group.
675 * @param p_assignment_id Identifies the new applicant assignment.
676 * @param p_application_received_date The date when the application was
677 * received. If not supplied, this value is defaulted to the effective date.
678 * @param p_vacancy_id Identifies the vacancy for which the registered user
679 * has applied.
680 * @param p_posting_content_id Identifies the advert for which the registered
681 * user has applied.
682 * @param p_per_information4 Developer descriptive flexfield segment.
683 * @param p_per_object_version_number If p_validate is false, then set to the
684 * version number of the new applicant record. If p_validate is true, then the
685 * value will be null.
686 * @param p_asg_object_version_number If p_validate is false, then this
687 * parameter is set to the version number of the assignment created. If
688 * p_validate is true, then this parameter is null.
689 * @param p_applicant_number The applicant's identification number.
690 * @rep:displayname Registered User Application
691 * @rep:category BUSINESS_ENTITY IRC_RECRUITMENT_CANDIDATE
692 * @rep:category BUSINESS_ENTITY PER_APPLICANT
693 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
694 * @rep:scope public
695 * @rep:lifecycle active
696 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
697 */
698 --
699 -- {End Of Comments}
700 --
701 procedure registered_user_application
702 (p_validate IN boolean default false
703 ,p_effective_date IN date
704 ,p_recruitment_person_id IN number
705 ,p_person_id IN number
706 ,p_assignment_id IN number
707 ,p_application_received_date IN date default null
708 ,p_vacancy_id IN number default null
709 ,p_posting_content_id IN number default null
710 ,p_per_information4 IN per_all_people_f.per_information4%type default null
711 ,p_per_object_version_number OUT NOCOPY number
712 ,p_asg_object_version_number OUT NOCOPY number
713 ,p_applicant_number OUT NOCOPY varchar2);
714 --
715 -- ----------------------------------------------------------------------------
716 -- |-------------------------------< create_user >----------------------------|
717 -- ----------------------------------------------------------------------------
718 --
719 -- {Start Of Comments}
720 /*#
721 * This API creates a registered user with a login account.
722 *
723 * The API also uses create_registered_user with the default parameters to
724 * create a basic registered user record.
725 *
726 * <p><b>Licensing</b><br>
727 * This API is licensed for use with iRecruitment.
728 *
729 * <p><b>Prerequisites</b><br>
730 * The responsibility, application, and security group must exist.
731 *
732 * <p><b>Post Success</b><br>
733 * The API creates a new user account.
734 *
735 * <p><b>Post Failure</b><br>
736 * The API fails to create a new user account and raises an error.
737 * @param p_user_name The username for the new account. The user name
738 * is same as the e-mail address.
739 * @param p_password The encrypted password for the new account.
740 * @param p_start_date The start date of the registered user's account.
741 * @param p_responsibility_id Identifies the responsibility that will be
742 * assigned to the new user.
743 * @param p_resp_appl_id Identifies the application that the new responsibility
744 * belongs to.
745 * @param p_security_group_id Identifies the security group to be associated
746 * with the new responsibility.
750 * @param p_first_name The first name of the registered user.
747 * @param p_email The e-mail address for the new user.
748 * @param p_language The default language for the new account.
749 * @param p_last_name The last name of the registered user.
751 * @param p_allow_access Indicates whether the user's details are available to
752 * recruiters when they search for candidates in iRecruitment.
753 * @param p_per_information_category Obsolete parameter, do not use.
754 * @param p_per_information1 Developer descriptive flexfield segment.
755 * @param p_per_information2 Developer descriptive flexfield segment.
756 * @param p_per_information3 Developer descriptive flexfield segment.
757 * @param p_per_information4 Developer descriptive flexfield segment.
758 * @param p_per_information5 Developer descriptive flexfield segment.
759 * @param p_per_information6 Developer descriptive flexfield segment.
760 * @param p_per_information7 Developer descriptive flexfield segment.
761 * @param p_per_information8 Developer descriptive flexfield segment.
762 * @param p_per_information9 Developer descriptive flexfield segment.
763 * @param p_per_information10 Developer descriptive flexfield segment.
764 * @param p_per_information11 Developer descriptive flexfield segment.
765 * @param p_per_information12 Developer descriptive flexfield segment.
766 * @param p_per_information13 Developer descriptive flexfield segment.
767 * @param p_per_information14 Developer descriptive flexfield segment.
768 * @param p_per_information15 Developer descriptive flexfield segment.
769 * @param p_per_information16 Developer descriptive flexfield segment.
770 * @param p_per_information17 Developer descriptive flexfield segment.
771 * @param p_per_information18 Developer descriptive flexfield segment.
772 * @param p_per_information19 Developer descriptive flexfield segment.
773 * @param p_per_information20 Developer descriptive flexfield segment.
774 * @param p_per_information21 Developer descriptive flexfield segment.
775 * @param p_per_information22 Developer descriptive flexfield segment.
776 * @param p_per_information23 Developer descriptive flexfield segment.
777 * @param p_per_information24 Developer descriptive flexfield segment.
778 * @param p_per_information25 Developer descriptive flexfield segment.
779 * @param p_per_information26 Developer descriptive flexfield segment.
780 * @param p_per_information27 Developer descriptive flexfield segment.
781 * @param p_per_information28 Developer descriptive flexfield segment.
782 * @param p_per_information29 Developer descriptive flexfield segment.
783 * @param p_per_information30 Developer descriptive flexfield segment.
784 * @rep:displayname Create User
785 * @rep:category BUSINESS_ENTITY IRC_RECRUITMENT_CANDIDATE
786 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
787 * @rep:scope public
788 * @rep:lifecycle active
789 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
790 */
791 --
792 -- {End Of Comments}
793 --
794 procedure create_user
795 (p_user_name IN varchar2
796 ,p_password IN varchar2
797 ,p_start_date IN date
798 ,p_responsibility_id IN number
799 ,p_resp_appl_id IN number
800 ,p_security_group_id IN number
801 ,p_email IN varchar2 default null
802 ,p_language IN varchar2 default null
803 ,p_last_name IN varchar2 default null
804 ,p_first_name IN varchar2 default null
805 ,p_allow_access IN varchar2 default null
806 ,p_per_information_category IN varchar2 default null
807 ,p_per_information1 IN varchar2 default null
808 ,p_per_information2 IN varchar2 default null
809 ,p_per_information3 IN varchar2 default null
810 ,p_per_information4 IN varchar2 default null
811 ,p_per_information5 IN varchar2 default null
812 ,p_per_information6 IN varchar2 default null
813 ,p_per_information7 IN varchar2 default null
814 ,p_per_information8 IN varchar2 default null
815 ,p_per_information9 IN varchar2 default null
816 ,p_per_information10 IN varchar2 default null
817 ,p_per_information11 IN varchar2 default null
818 ,p_per_information12 IN varchar2 default null
819 ,p_per_information13 IN varchar2 default null
820 ,p_per_information14 IN varchar2 default null
821 ,p_per_information15 IN varchar2 default null
822 ,p_per_information16 IN varchar2 default null
823 ,p_per_information17 IN varchar2 default null
824 ,p_per_information18 IN varchar2 default null
825 ,p_per_information19 IN varchar2 default null
826 ,p_per_information20 IN varchar2 default null
827 ,p_per_information21 IN varchar2 default null
828 ,p_per_information22 IN varchar2 default null
829 ,p_per_information23 IN varchar2 default null
830 ,p_per_information24 IN varchar2 default null
831 ,p_per_information25 IN varchar2 default null
832 ,p_per_information26 IN varchar2 default null
833 ,p_per_information27 IN varchar2 default null
834 ,p_per_information28 IN varchar2 default null
835 ,p_per_information29 IN varchar2 default null
836 ,p_per_information30 IN varchar2 default null
837 );
838 --
839 -- ----------------------------------------------------------------------------
840 -- |-------------------------------< update_user >----------------------------|
841 -- ----------------------------------------------------------------------------
842 --
843 -- {Start Of Comments}
844 /*#
845 * This API updates the login account details for a registered user.
846 *
847 *
848 * <p><b>Licensing</b><br>
852 * The login account must exist.
849 * This API is licensed for use with iRecruitment.
850 *
851 * <p><b>Prerequisites</b><br>
853 *
854 * <p><b>Post Success</b><br>
855 * The login information will be updated.
856 *
857 * <p><b>Post Failure</b><br>
858 * The login information will not be updated and an error will be raised
859 * @param p_user_name The username for the new account. The user name
860 * is same as the e-mail address.
861 * @param p_owner Owner name for setting the last_udated_by column. This should
862 * be set to 'CUST'.
863 * @param p_unencrypted_password Plain text new password.
864 * @param p_encrypted_user_password Encrypted password. This must be supplied
865 * when updating the e-mail address.
866 * @param p_session_number The session number of the application user's last
867 * sign-on session.
868 * @param p_start_date The date when the password becomes active.
869 * @param p_end_date The date when the password expires.
870 * @param p_last_logon_date The date when the application user last signed on.
871 * @param p_description Optional description.
872 * @param p_password_date The date when the current password was set.
873 * @param p_password_accesses_left The number of accesses left for the password.
874 * @param p_password_lifespan_accesses The number of accesses allowed for the
875 * password.
876 * @param p_password_lifespan_days Lifespan of the password.
877 * @param p_employee_id Identifier of the employee to whom the application
878 * username is assigned.
879 * @param p_email_address The e-mail address for the user.
880 * @param p_fax The fax number for the user (this will not be used in
881 * iRecruitment).
882 * @param p_customer_id Customer contact identifier.
883 * @param p_supplier_id Supplier contact identifier.
884 * @param p_old_password Old or Existing password used with
885 * p_unencrypted_password to update user password.
886 * @rep:displayname Update User
887 * @rep:category BUSINESS_ENTITY IRC_RECRUITMENT_CANDIDATE
888 * @rep:scope public
889 * @rep:lifecycle active
890 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
891 */
892 --
893 -- {End Of Comments}
894 --
895 procedure update_user (
896 p_user_name in varchar2,
897 p_owner in varchar2,
898 p_unencrypted_password in varchar2 default null,
899 p_encrypted_user_password in varchar2 default null,
900 p_session_number in number default null,
901 p_start_date in date default null,
902 p_end_date in date default null,
903 p_last_logon_date in date default null,
904 p_description in varchar2 default null,
905 p_password_date in date default null,
906 p_password_accesses_left in number default null,
907 p_password_lifespan_accesses in number default null,
908 p_password_lifespan_days in number default null,
909 p_employee_id in number default null,
910 p_email_address in varchar2 default null,
911 p_fax in varchar2 default null,
912 p_customer_id in number default null,
913 p_supplier_id in number default null,
914 p_old_password in varchar2 default null);
915 --
916 -- ----------------------------------------------------------------------------
917 -- |----------------------------< self_register_user >------------------------|
918 -- ----------------------------------------------------------------------------
919 --
920 -- {Start Of Comments}
921 /*#
922 * This API enables ex-employees and other non-employee users to identify
923 * themselves on iRecruitment and receive iRecruitment login details.
924 *
925 *
926 * <p><b>Licensing</b><br>
927 * This API is licensed for use with iRecruitment.
928 *
929 * <p><b>Prerequisites</b><br>
930 * None
931 *
932 * <p><b>Post Success</b><br>
933 * If the user does not provide a user name, then iRecruitment creates a new
934 * account using the new e-mail address and sends a notification about the new
935 * password. If the user name is provided, then the application associates the
936 * user name with the person record and sends a confirmation notification.
937 *
938 * In both the scenarios the application disables the old user accounts. The
939 * e-mail will be updated on the person record. The API creates notification
940 * preferences and work preferences records, if they do not exist.
941 *
942 * <p><b>Post Failure</b><br>
943 * The API does not update any records and will raise an error.
944 *
945 * @param p_validate If true, then validation alone will be performed and the
946 * database will remain unchanged. If false and all validation checks pass,
947 * then the database will be modified.
948 * @param p_current_email_address The current e-mail address of the user.
949 * @param p_responsibility_id Identifies the responsibility that will be
950 * assigned to the new user.
951 * @param p_resp_appl_id The application for the responsibility that the
952 * user will be granted.
953 * @param p_security_group_id The security group for the responsibility that
954 * the user will be granted.
955 * @param p_first_name The first name that the user provides to identify
956 * against an existing user in the database.
957 * @param p_last_name The last name that the user provides to identify against
958 * an existing user in the database.
959 * @param p_middle_names The middle name that the user provides to identify
960 * against an existing user in the database.
961 * @param p_previous_last_name The previous last name of the registered user.
962 * @param p_employee_number The employee number that the user provides to
966 * @param p_date_of_birth The date of birth that the user provides to identify
963 * identify against an existing user in the database.
964 * @param p_national_identifier The national identifier that the user provides
965 * to identify against an existing user in the database.
967 * against an existing user in the database.
968 * @param p_email_address The e-mail address that the user provides to identify
969 * against an existing user in the database.
970 * @param p_home_phone_number The home phone number that the user
971 * provides to identify against an existing user in the database.
972 * @param p_work_phone_number The work phone number that the user provides to
973 * identify against an existing user in the database.
974 * @param p_address_line_1 The first line of their home address that
975 * the user identifies with.
976 * @param p_manager_last_name The last name of their manager that the user
977 * provides to identify against an existing user in the database.
978 * @param p_allow_access Indicates whether the user's details are available to
979 * recruiters when they search for candidates in iRecruitment.
980 * @param p_language The default language for the new account.
981 * @param p_user_name The username for the new account. The user name
982 * is same as the e-mail address.
983 * @rep:displayname Self Register User
984 * @rep:category BUSINESS_ENTITY IRC_RECRUITMENT_CANDIDATE
985 * @rep:lifecycle active
986 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
987 * @rep:scope public
988 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
989 */
990 --
991 -- {End Of Comments}
992 --
993 procedure self_register_user
994 (p_validate IN boolean default false
995 ,p_current_email_address IN varchar2
996 ,p_responsibility_id IN number
997 ,p_resp_appl_id IN number
998 ,p_security_group_id IN number
999 ,p_first_name IN varchar2 default null
1000 ,p_last_name IN varchar2 default null
1001 ,p_middle_names IN varchar2 default null
1002 ,p_previous_last_name IN varchar2 default null
1003 ,p_employee_number IN varchar2 default null
1004 ,p_national_identifier IN varchar2 default null
1005 ,p_date_of_birth IN date default null
1006 ,p_email_address IN varchar2 default null
1007 ,p_home_phone_number IN varchar2 default null
1008 ,p_work_phone_number IN varchar2 default null
1009 ,p_address_line_1 IN varchar2 default null
1010 ,p_manager_last_name IN varchar2 default null
1011 ,p_allow_access IN varchar2 default null
1012 ,p_language IN varchar2 default null
1013 ,p_user_name IN varchar2 default null
1014 );
1015 --
1016 -- ----------------------------------------------------------------------------
1017 -- |---------------------------< create_partial_user >------------------------|
1018 -- ----------------------------------------------------------------------------
1019 --
1020 -- {Start Of Comments}
1021 /*#
1022 * This API creates an iRecruitment profile for a candidate who is not an
1023 * Employee.
1024 *
1025 * The API checks whether the User is associated with the iRecruitment
1026 * Employee Candidate responsibility or the iRecruitment External Candidate
1027 * responsibility. It also checks whether the details such as grant,
1028 * notification preferences, and person record are available for the user in
1029 * the registration business group. If any or all of the information is
1030 * missing, then the API creates the details for the user. You must not use
1031 * this API to create details for an employee user.
1032 *
1033 * <p><b>Licensing</b><br>
1034 * This API is licensed for use with iRecruitment.
1035 *
1036 * <p><b>Prerequisites</b><br>
1037 * The user must exist.
1038 *
1039 * <p><b>Post Success</b><br>
1040 * The API creates a profile for an iRecruitment external candidate.
1041 *
1042 * <p><b>Post Failure</b><br>
1043 * The API fails to create a profile for the user and raises an error.
1044 *
1045 * @param p_user_name The username for the new account. The user name
1046 * is same as the e-mail address.
1047 * @param p_start_date The start date of the registered user's account.
1048 * @param p_email The e-mail address for the new user.
1049 * @param p_language The default language for the new account.
1050 * @param p_last_name The last name of the registered user.
1051 * @param p_first_name The first name of the registered user.
1052 * @param p_reg_bg_id Identifies the registration business group in which
1053 * the candidate's record needs to be created.
1054 * @param p_responsibility_id Identifies the responsibility that will be
1055 * assigned to the new user.
1056 * @param p_resp_appl_id Identifies the application that the new responsibility
1057 * belongs to.
1058 * @param p_security_group_id Identifies the security group to be associated
1059 * with the new responsibility.
1060 * @param p_allow_access Indicates whether the user's details are available to
1061 * recruiters when they search for candidates in iRecruitment.
1062 * @rep:displayname Create Partial User
1063 * @rep:category BUSINESS_ENTITY IRC_RECRUITMENT_CANDIDATE
1064 * @rep:lifecycle active
1065 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1066 * @rep:scope public
1067 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1068 */
1069 --
1070 -- {End Of Comments}
1071 --
1072 PROCEDURE create_partial_user
1073 (p_user_name IN varchar2
1074 ,p_start_date IN date default null
1075 ,p_email IN varchar2 default null
1076 ,p_language IN varchar2 default null
1077 ,p_last_name IN varchar2 default null
1081 ,p_resp_appl_id IN number
1078 ,p_first_name IN varchar2 default null
1079 ,p_reg_bg_id IN number
1080 ,p_responsibility_id IN number
1082 ,p_security_group_id IN number
1083 ,p_allow_access IN varchar2 default null
1084 );
1085 --
1086 -- ----------------------------------------------------------------------------
1087 -- |---------------------------< irec_profile_exists >------------------------|
1088 -- ----------------------------------------------------------------------------
1089 --
1090 -- {Start Of Comments}
1091 /*#
1092 * This API checks if the user has an iRecruitment profile.
1093 *
1094 * The API checks whether the user is associated with the iRecruitment
1095 * Employee Candidate responsibility or the iRecruitment External Candidate
1096 * responsibility. It also checks whether the details such as grant,
1097 * notification preferences, and person record exist for the user in the
1098 * registration business group.
1099 *
1100 * If any or all of the information is missing, then the API returns the value
1101 * NO_PROFILE. If the information exists, then the API returns the value
1102 * PROFILE_EXISTS.
1103 *
1104 * <p><b>Licensing</b><br>
1105 * This API is licensed for use with iRecruitment.
1106 *
1107 * <p><b>Prerequisites</b><br>
1108 * The user must exist.
1109 *
1110 * <p><b>Post Success</b><br>
1111 * The API returns a value indicating whether the user has an iRecruitment
1112 * profile.
1113 *
1114 * <p><b>Post Failure</b><br>
1115 * The API does not create a profile for the user and raises an error.
1116 *
1117 * @param p_user_name The username for the account. The user name
1118 * is same as the e-mail address.
1119 * @param p_reg_bg_id Identifies the registration business group in which
1120 * the candidate's record needs to be created.
1121 * @param p_responsibility_id Identifies the responsibility that will be
1122 * assigned to the new user.
1123 * @param p_resp_appl_id Identifies the application that the new responsibility
1124 * belongs to.
1125 * @param p_security_group_id Identifies the security group to be associated
1126 * with the new responsibility.
1127 * @return VARCHAR2 'PROFILE_EXISTS' is returned if exist else 'NO_PROFILE' is
1128 * returned.
1129 * @rep:displayname iRecruitment Profile Exists
1130 * @rep:category BUSINESS_ENTITY IRC_RECRUITMENT_CANDIDATE
1131 * @rep:lifecycle active
1132 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1133 * @rep:scope public
1134 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1135 */
1136 --
1137 -- {End Of Comments}
1138 --
1139 FUNCTION irec_profile_exists
1140 (p_user_name IN varchar2
1141 ,p_reg_bg_id IN number
1142 ,p_responsibility_id IN number
1143 ,p_resp_appl_id IN number
1144 ,p_security_group_id IN number
1145 ) return VARCHAR2;
1146 --
1147 -- ----------------------------------------------------------------------------
1148 -- |-------------------------< create_ha_processed_user >---------------------|
1149 -- ----------------------------------------------------------------------------
1150 --
1151 -- {Start Of Comments}
1152 /*#
1153 * This API creates an iRecruitment profile for a candidate who has registered
1154 * using the High Availability site.
1155 *
1156 *
1157 * <p><b>Licensing</b><br>
1158 * This API is licensed for use with iRecruitment.
1159 *
1160 * <p><b>Prerequisites</b><br>
1161 * None
1162 *
1163 * <p><b>Post Success</b><br>
1164 * The API creates a profile for an iRecruitment external candidate who
1165 * has registered or applied for a job using the High Availability site.
1166 *
1167 * <p><b>Post Failure</b><br>
1168 * iRecruitment profile is not created for the user, and an error is raised.
1169 *
1170 * @param p_user_name The username for the new account. The user name
1171 * is same as the e-mail address.
1172 * @param p_password Encrypted password for the FND user that was created on
1173 * the High Availability site.
1174 * @param p_email The e-mail address for the new user.
1175 * @param p_start_date The start date of the registered user's account.
1176 * @param p_language The default language for the new account.
1177 * @param p_last_name The last name of the registered user.
1178 * @param p_first_name The first name of the registered user.
1179 * @param p_user_guid GUID of the User that was created using the High
1180 * Availability site.
1181 * @param p_reg_bg_id Identifies the registration business group in which
1182 * the candidate's record needs to be created.
1183 * @param p_responsibility_id Identifies the responsibility that will be
1184 * assigned to the new user.
1185 * @param p_resp_appl_id Identifies the application that the new responsibility
1186 * belongs to.
1187 * @param p_security_group_id Identifies the security group to be associated
1188 * with the new responsibility.
1189 * @param p_allow_access Indicates whether the user's details are available to
1190 * recruiters when they search for candidates in iRecruitment.
1191 * @param p_server_id Indicates the server from which the user is accessing
1192 * the application
1193 * @rep:displayname Create High Availability Processed User
1194 * @rep:category BUSINESS_ENTITY IRC_RECRUITMENT_CANDIDATE
1195 * @rep:lifecycle active
1196 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1197 * @rep:scope public
1198 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1199 */
1200 --
1201 -- {End Of Comments}
1202 --
1203 PROCEDURE create_ha_processed_user
1204 (p_user_name IN varchar2
1205 ,p_password IN varchar2
1206 ,p_email IN varchar2
1207 ,p_start_date IN date
1211 ,p_reg_bg_id IN number
1208 ,p_last_name IN varchar2
1209 ,p_first_name IN varchar2
1210 ,p_user_guid IN RAW
1212 ,p_responsibility_id IN number
1213 ,p_resp_appl_id IN number
1214 ,p_security_group_id IN number
1215 ,p_language IN varchar2 default null
1216 ,p_allow_access IN varchar2 default null
1217 ,p_server_id IN varchar2 default null
1218 );
1219 --
1220 -- ----------------------------------------------------------------------------
1221 -- |-------------------------------< grant_access >---------------------------|
1222 -- ----------------------------------------------------------------------------
1223 --
1224 -- {Start Of Comments}
1225 /*#
1226 * This API creates an iRecruitment candidate grant.
1227 *
1228 * <p><b>Licensing</b><br>
1229 * This API is licensed for use with iRecruitment.
1230 *
1231 * <p><b>Prerequisites</b><br>
1232 * The user must exist.
1233 *
1234 * <p><b>Post Success</b><br>
1235 * The API successfully creates a candidate grant for the user.
1236 *
1237 * <p><b>Post Failure</b><br>
1238 * The API fails to create a candidate grant for the user and raises an error.
1239 *
1240 * @param p_user_name The username for new account. The user name
1241 * is same as the e-mail address.
1242 * @param p_user_id ID of the user.
1243 * @param p_menu_id ID of the menu for which this grant is created.
1244 * @param p_resp_id ID of the responsibility for which the grant is created.
1245 * @param p_resp_appl_id Application ID of the responsibility for which the
1246 * grant is created.
1247 * @param p_sec_group_id Security Group ID for which the grant is created.
1248 * @param p_grant_name Name of the grant.
1249 * @param p_description Description of the grant.
1250 * @rep:displayname Grant Access
1251 * @rep:category BUSINESS_ENTITY IRC_RECRUITMENT_CANDIDATE
1252 * @rep:lifecycle active
1253 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1254 * @rep:scope public
1255 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1256 */
1257 --
1258 -- {End Of Comments}
1259 --
1260 procedure grant_access
1261 (p_user_name IN varchar2
1262 ,p_user_id IN number
1263 ,p_menu_id IN number
1264 ,p_resp_id IN number
1265 ,p_resp_appl_id IN number
1266 ,p_sec_group_id IN number
1267 ,p_grant_name IN varchar2
1268 ,p_description IN varchar2 default null
1269 );
1270 --
1271 -- ----------------------------------------------------------------------------
1272 -- |--------------------------< assign_responsibility >-----------------------|
1273 -- ----------------------------------------------------------------------------
1274 --
1275 -- {Start Of Comments}
1276 /*#
1277 * This API assigns a responsibility to the user.
1278 *
1279 * <p><b>Licensing</b><br>
1280 * This API is licensed for use with iRecruitment.
1281 *
1282 * <p><b>Prerequisites</b><br>
1283 * The user and responsibility should exist.
1284 *
1285 * <p><b>Post Success</b><br>
1286 * The responsibility is successfully assigned to the user.
1287 *
1288 * <p><b>Post Failure</b><br>
1289 * The API does not assign a responsibility to the user and an error is raised.
1290 *
1291 * @param p_user_id ID of the user
1292 * @param p_resp_id Identifies the responsibility to be assigned to the user.
1293 * @param p_resp_appl_id Application ID of the responsibility that the API
1294 * assigns to the user.
1295 * @param p_sec_group_id Identifies the security group to which the API
1296 * assigns the responsibility.
1297 * @rep:displayname Assign Responsibility
1298 * @rep:category BUSINESS_ENTITY IRC_RECRUITMENT_CANDIDATE
1299 * @rep:category BUSINESS_ENTITY FND_USER
1300 * @rep:lifecycle active
1301 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1302 * @rep:scope public
1303 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1304 */
1305 --
1306 -- {End Of Comments}
1307 --
1308 procedure assign_responsibility
1309 (p_user_id IN number
1310 ,p_resp_id IN number
1311 ,p_resp_appl_id IN number
1312 ,p_sec_group_id IN number
1313 );
1314 --
1315 -- ----------------------------------------------------------------------------
1316 -- |-------------------------------< testusername >---------------------------|
1317 -- ----------------------------------------------------------------------------
1318 --
1319 -- {Start Of Comments}
1320 /*#
1321 * This API tests the User Name to validate that it is unique and passes
1322 * validations checks.
1323 *
1324 * The checks are performed against SSO server if the application
1325 * is SSO enabled.
1326 *
1327 * <p><b>Licensing</b><br>
1328 * This API is licensed for use with iRecruitment.
1329 *
1330 * <p><b>Prerequisites</b><br>
1331 * None
1332 *
1333 * <p><b>Post Success</b><br>
1334 * The result of the user name validation is returned.
1335 *
1336 * <p><b>Post Failure</b><br>
1337 * An error is raised.
1338 *
1339 * @param p_user_name User name to be validated.
1340 * @return The API will return a value indicating whether the user name is
1341 * INVALID, or VALID or if a SSO user exists with that name. The API links
1342 * the FND user with the SSO user.
1343 * @rep:displayname Test User Name
1344 * @rep:category BUSINESS_ENTITY IRC_RECRUITMENT_CANDIDATE
1345 * @rep:category BUSINESS_ENTITY FND_USER
1346 * @rep:lifecycle active
1347 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1348 * @rep:scope public
1349 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1350 */
1351 --
1352 -- {End Of Comments}
1353 --
1354 function TestUserName
1355 (
1356 p_user_name IN varchar2
1360 -- |-------------------------< process_ha_resp_check >------------------------|
1357 ) return NUMBER;
1358 --
1359 -- ----------------------------------------------------------------------------
1361 -- ----------------------------------------------------------------------------
1362 --
1363 -- {Start Of Comments}
1364 /*#
1365 * This API checks if the user has the responsibility and if not, assigns the
1366 * responsibility. The procedure does a re-initialization of user's session
1367 * to the new assigned responsibility
1368 *
1369 * <p><b>Licensing</b><br>
1370 * This API is licensed for use with iRecruitment.
1371 *
1372 * <p><b>Prerequisites</b><br>
1373 * None
1374 *
1375 * <p><b>Post Success</b><br>
1376 * This API updates the user's session to refer to the input responsibility.
1377 *
1378 * <p><b>Post Failure</b><br>
1379 * An error is raised.
1380 *
1381 * @param p_user_id ID of the user
1382 * @param p_responsibility_id Identifies the responsibility to be assigned
1383 * to the user.
1384 * @param p_resp_appl_id Application ID of the responsibility that the API
1385 * assigns to the user.
1386 * @param p_security_group_id Identifies the security group to which the API
1387 * assigns the responsibility.
1388 * @param p_start_date The start date of the registered user's account.
1389 * @param p_server_id Identifies the server from which this user is
1390 * accessing the application
1391 * @rep:displayname Assign Responsibility
1392 * @rep:category BUSINESS_ENTITY IRC_RECRUITMENT_CANDIDATE
1393 * @rep:category BUSINESS_ENTITY FND_USER
1394 * @rep:lifecycle active
1395 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
1396 * @rep:scope public
1397 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
1398 */
1399 --
1400 -- {End Of Comments}
1401 --
1402 procedure process_ha_resp_check
1403 (
1404 p_user_id IN number,
1405 p_responsibility_id IN number,
1406 p_resp_appl_id IN number,
1407 p_security_group_id IN number,
1408 p_start_date IN date,
1409 p_server_id IN number default null
1410 );
1411 --
1412 --
1413 -- -------------------------------------------------------------------------
1414 -- |------------------------< create_user_byReferral >--------------------------------|
1415 -- -------------------------------------------------------------------------
1416 --
1417 procedure create_user_byReferral
1418 (p_user_name IN varchar2
1419 ,p_password IN varchar2
1420 ,p_start_date IN date
1421 ,p_responsibility_id IN number
1422 ,p_resp_appl_id IN number
1423 ,p_security_group_id IN number
1424 ,p_email IN varchar2 default null
1425 ,p_language IN varchar2 default null
1426 ,p_last_name IN varchar2 default null
1427 ,p_first_name IN varchar2 default null
1428 ,p_allow_access IN varchar2 default null
1429 ,p_per_information_category IN varchar2 default null
1430 ,p_per_information1 IN varchar2 default null
1431 ,p_per_information2 IN varchar2 default null
1432 ,p_per_information3 IN varchar2 default null
1433 ,p_per_information4 IN varchar2 default null
1434 ,p_per_information5 IN varchar2 default null
1435 ,p_per_information6 IN varchar2 default null
1436 ,p_per_information7 IN varchar2 default null
1437 ,p_per_information8 IN varchar2 default null
1438 ,p_per_information9 IN varchar2 default null
1439 ,p_per_information10 IN varchar2 default null
1440 ,p_per_information11 IN varchar2 default null
1441 ,p_per_information12 IN varchar2 default null
1442 ,p_per_information13 IN varchar2 default null
1443 ,p_per_information14 IN varchar2 default null
1444 ,p_per_information15 IN varchar2 default null
1445 ,p_per_information16 IN varchar2 default null
1446 ,p_per_information17 IN varchar2 default null
1447 ,p_per_information18 IN varchar2 default null
1448 ,p_per_information19 IN varchar2 default null
1449 ,p_per_information20 IN varchar2 default null
1450 ,p_per_information21 IN varchar2 default null
1451 ,p_per_information22 IN varchar2 default null
1452 ,p_per_information23 IN varchar2 default null
1453 ,p_per_information24 IN varchar2 default null
1454 ,p_per_information25 IN varchar2 default null
1455 ,p_per_information26 IN varchar2 default null
1456 ,p_per_information27 IN varchar2 default null
1457 ,p_per_information28 IN varchar2 default null
1458 ,p_per_information29 IN varchar2 default null
1459 ,p_per_information30 IN varchar2 default null
1460 ,p_person_id IN number default null
1461 );
1462 --
1463 --
1464 -- ----------------------------------------------------------------------------
1465 -- |-----------------------------< merge_profile >----------------------------|
1466 -- ----------------------------------------------------------------------------
1467 --
1468 -- {Start Of Comments}
1469 --
1470 -- {End Of Comments}
1471 --
1472 procedure merge_profile
1473 (p_validate IN boolean default false
1474 ,p_target_party_id IN number
1475 ,p_source_party_id IN number
1476 ,p_term_or_purge_s IN varchar2 default null
1477 ,p_disable_user_acc IN varchar2 default null
1478 ,p_create_new_application IN varchar2 default null
1479 );
1480 --
1481 --
1482 --
1483 -- ----------------------------------------------------------------------------
1484 -- |-----------------------< validate_copy_applications >----------------------|
1485 -- ----------------------------------------------------------------------------
1486 --
1487 -- {Start Of Comments}
1488 --
1489 -- {End Of Comments}
1490 --
1491 procedure validate_copy_applications
1492 (p_validate IN boolean default false
1493 ,p_target_party_id IN number
1494 ,p_source_party_list IN varchar2
1495 ,p_return_status OUT NOCOPY varchar2
1496 );
1497 --
1498 -- ----------------------------------------------------------------------------
1499 -- |-----------------------------< ofr_reg_user_application >-----------------|
1500 -- ----------------------------------------------------------------------------
1501 --
1502 -- {Start Of Comments}
1503 --
1504 -- {End Of Comments}
1505 --
1506 procedure ofr_reg_user_application
1507 (p_effective_date IN date
1508 ,p_recruitment_person_id IN number
1509 ,p_business_group_id IN number
1510 ,p_organization_id IN number default null
1511 ,p_manager_id IN number default null
1512 ,p_asg_id OUT NOCOPY number );
1513 --
1514 --
1515 -- ----------------------------------------------------------------------------
1516 -- |-----------------------------< create_linking >----------------------------|
1517 -- ----------------------------------------------------------------------------
1518 --
1519 -- {Start Of Comments}
1520 --
1521 -- {End Of Comments}
1522 --
1523 procedure create_linking
1524 (p_src_apl_asg_id IN number
1525 ,p_tgt_apl_asg_id IN number
1526 ,p_vacancy_id IN number
1527 ,p_link_id OUT NOCOPY number );
1528 --
1529 end IRC_PARTY_API;