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