1 Package irc_party_swi As
2 /* $Header: irhzpswi.pkh 120.3 2007/12/21 07:32:54 vmummidi noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |------------------------< create_candidate_internal >---------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: irc_party_api.create_candidate_internal
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_candidate_internal
27 (p_validate in number default hr_api.g_false_num
28 ,p_person_id in number
29 ,p_business_group_id in number
30 ,p_last_name in varchar2
31 ,p_first_name in varchar2 default null
32 ,p_date_of_birth in date default null
33 ,p_email_address in varchar2 default null
34 ,p_title in varchar2 default null
35 ,p_gender in varchar2 default null
36 ,p_marital_status in varchar2 default null
37 ,p_previous_last_name in varchar2 default null
38 ,p_middle_name in varchar2 default null
39 ,p_name_suffix in varchar2 default null
40 ,p_known_as in varchar2 default null
41 ,p_first_name_phonetic in varchar2 default null
42 ,p_last_name_phonetic in varchar2 default null
43 ,p_attribute_category in varchar2 default null
44 ,p_attribute1 in varchar2 default null
45 ,p_attribute2 in varchar2 default null
46 ,p_attribute3 in varchar2 default null
47 ,p_attribute4 in varchar2 default null
48 ,p_attribute5 in varchar2 default null
49 ,p_attribute6 in varchar2 default null
50 ,p_attribute7 in varchar2 default null
51 ,p_attribute8 in varchar2 default null
52 ,p_attribute9 in varchar2 default null
53 ,p_attribute10 in varchar2 default null
54 ,p_attribute11 in varchar2 default null
55 ,p_attribute12 in varchar2 default null
56 ,p_attribute13 in varchar2 default null
57 ,p_attribute14 in varchar2 default null
58 ,p_attribute15 in varchar2 default null
59 ,p_attribute16 in varchar2 default null
60 ,p_attribute17 in varchar2 default null
61 ,p_attribute18 in varchar2 default null
62 ,p_attribute19 in varchar2 default null
63 ,p_attribute20 in varchar2 default null
64 ,p_attribute21 in varchar2 default null
65 ,p_attribute22 in varchar2 default null
66 ,p_attribute23 in varchar2 default null
67 ,p_attribute24 in varchar2 default null
68 ,p_attribute25 in varchar2 default null
69 ,p_attribute26 in varchar2 default null
70 ,p_attribute27 in varchar2 default null
71 ,p_attribute28 in varchar2 default null
72 ,p_attribute29 in varchar2 default null
73 ,p_attribute30 in varchar2 default null
74 ,p_per_information_category in varchar2 default null
75 ,p_per_information1 in varchar2 default null
76 ,p_per_information2 in varchar2 default null
77 ,p_per_information3 in varchar2 default null
78 ,p_per_information4 in varchar2 default null
79 ,p_per_information5 in varchar2 default null
80 ,p_per_information6 in varchar2 default null
81 ,p_per_information7 in varchar2 default null
82 ,p_per_information8 in varchar2 default null
83 ,p_per_information9 in varchar2 default null
84 ,p_per_information10 in varchar2 default null
85 ,p_per_information11 in varchar2 default null
86 ,p_per_information12 in varchar2 default null
87 ,p_per_information13 in varchar2 default null
88 ,p_per_information14 in varchar2 default null
89 ,p_per_information15 in varchar2 default null
90 ,p_per_information16 in varchar2 default null
91 ,p_per_information17 in varchar2 default null
92 ,p_per_information18 in varchar2 default null
93 ,p_per_information19 in varchar2 default null
94 ,p_per_information20 in varchar2 default null
95 ,p_per_information21 in varchar2 default null
96 ,p_per_information22 in varchar2 default null
97 ,p_per_information23 in varchar2 default null
98 ,p_per_information24 in varchar2 default null
99 ,p_per_information25 in varchar2 default null
100 ,p_per_information26 in varchar2 default null
101 ,p_per_information27 in varchar2 default null
102 ,p_per_information28 in varchar2 default null
103 ,p_per_information29 in varchar2 default null
104 ,p_per_information30 in varchar2 default null
105 ,p_effective_start_date out NOCOPY date
106 ,p_effective_end_date out NOCOPY date
107 ,p_object_version_number out nocopy number
108 ,p_return_status out nocopy varchar2
109 );
110 -- ----------------------------------------------------------------------------
111 -- |------------------------< create_registered_user >------------------------|
112 -- ----------------------------------------------------------------------------
113 -- {Start of comments}
114 --
115 -- Description:
116 -- This procedure is the self-service wrapper procedure to the following
117 -- API: irc_party_api.create_registered_user
118 --
119 -- Pre-requisites
120 -- All 'IN' parameters to this procedure have been appropriately derived.
121 --
122 -- Post Success:
123 -- p_return_status will return value indicating success.
124 --
125 -- Post Failure:
126 -- p_return_status will return value indication failure.
127 --
128 -- Access Status:
129 -- Internal Development use only.
130 --
131 -- {End of comments}
132 -- ----------------------------------------------------------------------------
133 PROCEDURE create_registered_user
134 (p_validate in number default hr_api.g_false_num
135 ,p_last_name in varchar2
136 ,p_first_name in varchar2 default null
137 ,p_date_of_birth in date default null
138 ,p_title in varchar2 default null
139 ,p_gender in varchar2 default null
140 ,p_marital_status in varchar2 default null
141 ,p_previous_last_name in varchar2 default null
142 ,p_middle_name in varchar2 default null
143 ,p_name_suffix in varchar2 default null
144 ,p_known_as in varchar2 default null
145 ,p_first_name_phonetic in varchar2 default null
146 ,p_last_name_phonetic in varchar2 default null
147 ,p_attribute_category in varchar2 default null
148 ,p_attribute1 in varchar2 default null
149 ,p_attribute2 in varchar2 default null
150 ,p_attribute3 in varchar2 default null
151 ,p_attribute4 in varchar2 default null
152 ,p_attribute5 in varchar2 default null
153 ,p_attribute6 in varchar2 default null
154 ,p_attribute7 in varchar2 default null
155 ,p_attribute8 in varchar2 default null
156 ,p_attribute9 in varchar2 default null
157 ,p_attribute10 in varchar2 default null
158 ,p_attribute11 in varchar2 default null
159 ,p_attribute12 in varchar2 default null
160 ,p_attribute13 in varchar2 default null
161 ,p_attribute14 in varchar2 default null
162 ,p_attribute15 in varchar2 default null
163 ,p_attribute16 in varchar2 default null
164 ,p_attribute17 in varchar2 default null
165 ,p_attribute18 in varchar2 default null
166 ,p_attribute19 in varchar2 default null
167 ,p_attribute20 in varchar2 default null
168 ,p_attribute21 in varchar2 default null
169 ,p_attribute22 in varchar2 default null
170 ,p_attribute23 in varchar2 default null
171 ,p_attribute24 in varchar2 default null
172 ,p_attribute25 in varchar2 default null
173 ,p_attribute26 in varchar2 default null
174 ,p_attribute27 in varchar2 default null
175 ,p_attribute28 in varchar2 default null
176 ,p_attribute29 in varchar2 default null
177 ,p_attribute30 in varchar2 default null
178 ,p_per_information_category in varchar2 default null
179 ,p_per_information1 in varchar2 default null
180 ,p_per_information2 in varchar2 default null
181 ,p_per_information3 in varchar2 default null
182 ,p_per_information4 in varchar2 default null
183 ,p_per_information5 in varchar2 default null
184 ,p_per_information6 in varchar2 default null
185 ,p_per_information7 in varchar2 default null
186 ,p_per_information8 in varchar2 default null
187 ,p_per_information9 in varchar2 default null
188 ,p_per_information10 in varchar2 default null
189 ,p_per_information11 in varchar2 default null
190 ,p_per_information12 in varchar2 default null
191 ,p_per_information13 in varchar2 default null
192 ,p_per_information14 in varchar2 default null
193 ,p_per_information15 in varchar2 default null
194 ,p_per_information16 in varchar2 default null
195 ,p_per_information17 in varchar2 default null
196 ,p_per_information18 in varchar2 default null
197 ,p_per_information19 in varchar2 default null
198 ,p_per_information20 in varchar2 default null
199 ,p_per_information21 in varchar2 default null
200 ,p_per_information22 in varchar2 default null
201 ,p_per_information23 in varchar2 default null
202 ,p_per_information24 in varchar2 default null
203 ,p_per_information25 in varchar2 default null
204 ,p_per_information26 in varchar2 default null
205 ,p_per_information27 in varchar2 default null
206 ,p_per_information28 in varchar2 default null
207 ,p_per_information29 in varchar2 default null
208 ,p_per_information30 in varchar2 default null
209 ,p_effective_start_date out NOCOPY date
210 ,p_effective_end_date out NOCOPY date
211 ,p_person_id out NOCOPY number
212 ,p_return_status out nocopy varchar2
213 );
214 -- ----------------------------------------------------------------------------
215 -- |----------------------< registered_user_application >---------------------|
216 -- ----------------------------------------------------------------------------
217 -- {Start of comments}
218 --
219 -- Description:
220 -- This procedure is the self-service wrapper procedure to the following
221 -- API: irc_party_api.registered_user_application
222 --
223 -- Pre-requisites
224 -- All 'IN' parameters to this procedure have been appropriately derived.
225 --
226 -- Post Success:
227 -- p_return_status will return value indicating success.
228 --
229 -- Post Failure:
230 -- p_return_status will return value indication failure.
231 --
232 -- Access Status:
233 -- Internal Development use only.
234 --
235 -- {End of comments}
236 -- ----------------------------------------------------------------------------
237 PROCEDURE registered_user_application
238 (p_validate in number default hr_api.g_false_num
239 ,p_effective_date in date
240 ,p_recruitment_person_id in number
241 ,p_person_id in number
242 ,p_assignment_id in number
243 ,p_application_received_date in date default null
244 ,p_vacancy_id in number default null
245 ,p_posting_content_id in number default null
246 ,p_per_object_version_number out nocopy number
247 ,p_asg_object_version_number out nocopy number
248 ,p_recruitment_person_ovn out nocopy number
249 ,p_applicant_number out nocopy varchar2
250 ,p_return_status out nocopy varchar2
251 );
252 -- ----------------------------------------------------------------------------
253 -- |------------------------< update_registered_user >------------------------|
254 -- ----------------------------------------------------------------------------
255 -- {Start of comments}
256 --
257 -- Description:
258 -- This procedure is the self-service wrapper procedure to the following
259 -- API: irc_party_api.update_registered_user
260 --
261 -- Pre-requisites
262 -- All 'IN' parameters to this procedure have been appropriately derived.
263 --
264 -- Post Success:
265 -- p_return_status will return value indicating success.
266 --
267 -- Post Failure:
268 -- p_return_status will return value indication failure.
269 --
270 -- Access Status:
271 -- Internal Development use only.
272 --
273 -- {End of comments}
274 -- ----------------------------------------------------------------------------
275 PROCEDURE update_registered_user
276 (p_validate in number default hr_api.g_false_num
277 ,p_effective_date in date
278 ,p_person_id in number
279 ,p_first_name in varchar2 default hr_api.g_varchar2
280 ,p_last_name in varchar2 default hr_api.g_varchar2
281 ,p_date_of_birth in date default hr_api.g_date
282 ,p_title in varchar2 default hr_api.g_varchar2
283 ,p_gender in varchar2 default hr_api.g_varchar2
284 ,p_marital_status in varchar2 default hr_api.g_varchar2
285 ,p_previous_last_name in varchar2 default hr_api.g_varchar2
286 ,p_middle_name in varchar2 default hr_api.g_varchar2
287 ,p_name_suffix in varchar2 default hr_api.g_varchar2
288 ,p_known_as in varchar2 default hr_api.g_varchar2
289 ,p_first_name_phonetic in varchar2 default hr_api.g_varchar2
290 ,p_last_name_phonetic in varchar2 default hr_api.g_varchar2
291 ,p_attribute_category in varchar2 default hr_api.g_varchar2
292 ,p_attribute1 in varchar2 default hr_api.g_varchar2
293 ,p_attribute2 in varchar2 default hr_api.g_varchar2
294 ,p_attribute3 in varchar2 default hr_api.g_varchar2
295 ,p_attribute4 in varchar2 default hr_api.g_varchar2
296 ,p_attribute5 in varchar2 default hr_api.g_varchar2
297 ,p_attribute6 in varchar2 default hr_api.g_varchar2
298 ,p_attribute7 in varchar2 default hr_api.g_varchar2
299 ,p_attribute8 in varchar2 default hr_api.g_varchar2
300 ,p_attribute9 in varchar2 default hr_api.g_varchar2
304 ,p_attribute13 in varchar2 default hr_api.g_varchar2
301 ,p_attribute10 in varchar2 default hr_api.g_varchar2
302 ,p_attribute11 in varchar2 default hr_api.g_varchar2
303 ,p_attribute12 in varchar2 default hr_api.g_varchar2
305 ,p_attribute14 in varchar2 default hr_api.g_varchar2
306 ,p_attribute15 in varchar2 default hr_api.g_varchar2
307 ,p_attribute16 in varchar2 default hr_api.g_varchar2
308 ,p_attribute17 in varchar2 default hr_api.g_varchar2
309 ,p_attribute18 in varchar2 default hr_api.g_varchar2
310 ,p_attribute19 in varchar2 default hr_api.g_varchar2
311 ,p_attribute20 in varchar2 default hr_api.g_varchar2
312 ,p_attribute21 in varchar2 default hr_api.g_varchar2
313 ,p_attribute22 in varchar2 default hr_api.g_varchar2
314 ,p_attribute23 in varchar2 default hr_api.g_varchar2
315 ,p_attribute24 in varchar2 default hr_api.g_varchar2
316 ,p_attribute25 in varchar2 default hr_api.g_varchar2
317 ,p_attribute26 in varchar2 default hr_api.g_varchar2
318 ,p_attribute27 in varchar2 default hr_api.g_varchar2
319 ,p_attribute28 in varchar2 default hr_api.g_varchar2
320 ,p_attribute29 in varchar2 default hr_api.g_varchar2
321 ,p_attribute30 in varchar2 default hr_api.g_varchar2
322 ,p_per_information_category in varchar2 default hr_api.g_varchar2
323 ,p_per_information1 in varchar2 default hr_api.g_varchar2
324 ,p_per_information2 in varchar2 default hr_api.g_varchar2
325 ,p_per_information3 in varchar2 default hr_api.g_varchar2
326 ,p_per_information4 in varchar2 default hr_api.g_varchar2
327 ,p_per_information5 in varchar2 default hr_api.g_varchar2
328 ,p_per_information6 in varchar2 default hr_api.g_varchar2
329 ,p_per_information7 in varchar2 default hr_api.g_varchar2
330 ,p_per_information8 in varchar2 default hr_api.g_varchar2
331 ,p_per_information9 in varchar2 default hr_api.g_varchar2
332 ,p_per_information10 in varchar2 default hr_api.g_varchar2
333 ,p_per_information11 in varchar2 default hr_api.g_varchar2
334 ,p_per_information12 in varchar2 default hr_api.g_varchar2
335 ,p_per_information13 in varchar2 default hr_api.g_varchar2
336 ,p_per_information14 in varchar2 default hr_api.g_varchar2
337 ,p_per_information15 in varchar2 default hr_api.g_varchar2
338 ,p_per_information16 in varchar2 default hr_api.g_varchar2
339 ,p_per_information17 in varchar2 default hr_api.g_varchar2
340 ,p_per_information18 in varchar2 default hr_api.g_varchar2
341 ,p_per_information19 in varchar2 default hr_api.g_varchar2
342 ,p_per_information20 in varchar2 default hr_api.g_varchar2
343 ,p_per_information21 in varchar2 default hr_api.g_varchar2
344 ,p_per_information22 in varchar2 default hr_api.g_varchar2
345 ,p_per_information23 in varchar2 default hr_api.g_varchar2
346 ,p_per_information24 in varchar2 default hr_api.g_varchar2
347 ,p_per_information25 in varchar2 default hr_api.g_varchar2
348 ,p_per_information26 in varchar2 default hr_api.g_varchar2
349 ,p_per_information27 in varchar2 default hr_api.g_varchar2
350 ,p_per_information28 in varchar2 default hr_api.g_varchar2
351 ,p_per_information29 in varchar2 default hr_api.g_varchar2
352 ,p_per_information30 in varchar2 default hr_api.g_varchar2
353 ,p_person_ovn out nocopy number
354 ,p_return_status out nocopy varchar2
355 );
356 -- ----------------------------------------------------------------------------
357 -- |------------------------< create_user >-----------------------------------|
358 -- ----------------------------------------------------------------------------
359 -- {Start of comments}
360 --
361 -- Description:
362 -- This procedure is the self-service wrapper procedure to the following
363 -- API: irc_party_api.create_user
364 --
365 -- Pre-requisites
366 -- All 'IN' parameters to this procedure have been appropriately derived.
367 --
368 -- Post Success:
369 -- p_return_status will return value indicating success.
370 --
371 -- Post Failure:
372 -- p_return_status will return value indication failure.
373 --
374 -- Access Status:
375 -- Internal Development use only.
376 --
377 -- {End of comments}
378 -- ----------------------------------------------------------------------------
379 PROCEDURE create_user
380 (p_user_name IN varchar2
381 ,p_password IN varchar2
382 ,p_start_date IN date
383 ,p_responsibility_id IN number
384 ,p_resp_appl_id IN number
385 ,p_security_group_id IN number
386 ,p_email IN varchar2 default null
387 ,p_language IN varchar2 default null
388 ,p_last_name in varchar2 default null
389 ,p_first_name in varchar2 default null
393 ,p_per_information3 in varchar2 default null
390 ,p_per_information_category in varchar2 default null
391 ,p_per_information1 in varchar2 default null
392 ,p_per_information2 in varchar2 default null
394 ,p_per_information4 in varchar2 default null
395 ,p_per_information5 in varchar2 default null
396 ,p_per_information6 in varchar2 default null
397 ,p_per_information7 in varchar2 default null
398 ,p_per_information8 in varchar2 default null
399 ,p_per_information9 in varchar2 default null
400 ,p_per_information10 in varchar2 default null
401 ,p_per_information11 in varchar2 default null
402 ,p_per_information12 in varchar2 default null
403 ,p_per_information13 in varchar2 default null
404 ,p_per_information14 in varchar2 default null
405 ,p_per_information15 in varchar2 default null
406 ,p_per_information16 in varchar2 default null
407 ,p_per_information17 in varchar2 default null
408 ,p_per_information18 in varchar2 default null
409 ,p_per_information19 in varchar2 default null
410 ,p_per_information20 in varchar2 default null
411 ,p_per_information21 in varchar2 default null
412 ,p_per_information22 in varchar2 default null
413 ,p_per_information23 in varchar2 default null
414 ,p_per_information24 in varchar2 default null
415 ,p_per_information25 in varchar2 default null
416 ,p_per_information26 in varchar2 default null
417 ,p_per_information27 in varchar2 default null
418 ,p_per_information28 in varchar2 default null
419 ,p_per_information29 in varchar2 default null
420 ,p_per_information30 in varchar2 default null
421 ,p_return_status OUT nocopy varchar2
422 );
423 -- -------------------------------------------------------------------------
424 -- |------------------------< self_register_user >-------------------------|
425 -- -------------------------------------------------------------------------
426 -- {Start Of Comments}
427 --
428 -- Description:
429 -- This API is used to allow ex-employees, and other non-employee users
430 -- to self-identify with the system and get an iRecruitment login
431 -- e-mailed to them.
432 --
433 -- In Parameters:
434 -- Name Reqd Type Description
435 -- p_current_email_address Y varchar2 The current e-mail address of
436 -- the user
437 -- p_responsibility_id Y number The responsibility that the
438 -- user will be granted
439 -- p_resp_appl_id Y number The application for the
440 -- responsibility that the user
441 -- will be granted
442 -- p_security_group_id Y number The security group for the
443 -- responsibility that the user
444 -- will be granted
445 -- p_first_name N varchar2 The first name that the user
446 -- self identifies with
447 -- p_last_name N varchar2 The last name that the user
448 -- self identifies with
449 -- p_middle_names N varchar2 The middle name that the user
450 -- self identifies with
451 -- p_previous_last_name N varchar2 The previous last name that the
452 -- user self identifies with
453 -- p_employee_number N varchar2 The employee number that the user
454 -- self identifies with
455 -- p_national_identifier N varchar2 The national identifier that the
456 -- user self identifies with
457 -- p_date_of_birth N date The date of birth that the
458 -- user self identifies with
459 -- p_email_address N varchar2 The e-mail address that the
460 -- user self identifies with
461 -- p_home_phone_number N varchar2 The home phone number that the
462 -- user self identifies with
463 -- p_work_phone_number N varchar2 The work phone number that the
464 -- user self identifies with
465 -- p_address_line_1 N varchar2 The first line of their home
466 -- address that the user
467 -- self identifies with
468 -- p_manager_last_name N varchar2 The last name of their
469 -- manager that the user
470 -- self identifies with
471 -- p_allow_access N varchar2 Indicates if the user wants their
472 -- account to be searchable by
473 -- recruiters
474 -- p_language N varchar2 The default language for the
475 -- new account
479 -- If an user name is not provided, a new user account will be created for the
476 -- p_user_name N varchar2 Application username
477 --
478 -- Post Success:
480 -- user with their new e-mail address and a notification will be sent to the
481 -- user with their new password in it.
482 -- If an user name is provided, it will be associated with the person and a
483 -- confirmation notification is sent to the user.
484 -- In either case any old user accounts will be disabled. Their e-mail address
485 -- will be updated on their person record. Notification preferences and work
486 -- preferences records will be created if they do not already exist.
487 --
488 -- Post Failure:
489 -- No records will be updated, and an appropriate error message will be raised.
490 --
491 -- Access Status:
492 -- Public.
493 --
494 -- {End Of Comments}
495 procedure self_register_user
496 (p_validate IN number default hr_api.g_false_num
497 ,p_current_email_address IN varchar2
498 ,p_responsibility_id IN number
499 ,p_resp_appl_id IN number
500 ,p_security_group_id IN number
501 ,p_first_name IN varchar2 default null
502 ,p_last_name IN varchar2 default null
503 ,p_middle_names IN varchar2 default null
504 ,p_previous_last_name IN varchar2 default null
505 ,p_employee_number IN varchar2 default null
506 ,p_national_identifier IN varchar2 default null
507 ,p_date_of_birth IN date default null
508 ,p_email_address IN varchar2 default null
509 ,p_home_phone_number IN varchar2 default null
510 ,p_work_phone_number IN varchar2 default null
511 ,p_address_line_1 IN varchar2 default null
512 ,p_manager_last_name IN varchar2 default null
513 ,p_allow_access IN varchar2 default 'N'
514 ,p_language IN varchar2 default null
515 ,p_user_name IN varchar2 default null
516 ,p_return_status OUT nocopy varchar2
517 );
518 -- -------------------------------------------------------------------
519 -- |------------------------< get_first_page >-----------------------|
520 -- -------------------------------------------------------------------
521 -- {Start of comments}
522 --
523 -- Description:
524 -- This procedure gets the menu name of the menu type home page
525 -- and the function defined at the top of this menu tree for a given
526 -- responsibility key
527 --
528 -- Pre-requisites
529 -- p_responsibility_key - the responsibility key
530 --
531 -- Post Success:
532 -- p_oasf will return function name at top of home page menu tree
533 -- p_oahp will return menu name of the menu of type home page
534 --
535 -- Post Failure:
536 --
537 -- Access Status:
538 -- Internal Development use only.
539 --
540 -- {End of comments}
541 -- ----------------------------------------------------------------------------
542 procedure get_first_page(p_responsibility_key in varchar2
543 ,p_oasf out nocopy varchar2
544 ,p_oahp out nocopy varchar2);
545 -- -------------------------------------------------------------------------
546 -- |------------------------< create_partial_user >------------------------|
547 -- -------------------------------------------------------------------------
548 PROCEDURE create_partial_user
549 (p_user_name IN varchar2
550 ,p_start_date IN date default null
551 ,p_email IN varchar2 default null
552 ,p_language IN varchar2 default null
553 ,p_last_name IN varchar2 default null
554 ,p_first_name IN varchar2 default null
555 ,p_reg_bg_id IN number
556 ,p_responsibility_id IN number
557 ,p_resp_appl_id IN number
558 ,p_security_group_id IN number
559 ,p_allow_access IN varchar2 default null
560 ,p_return_status OUT nocopy varchar2
561 );
562 --
563 -- ----------------------------------------------------------------------------
564 -- |------------------------< create_user_byReferral >-----------------------------------|
565 -- ----------------------------------------------------------------------------
566 PROCEDURE create_user_byReferral
567 (p_user_name IN varchar2
568 ,p_password IN varchar2
569 ,p_start_date IN date
570 ,p_responsibility_id IN number
571 ,p_resp_appl_id IN number
572 ,p_security_group_id IN number
573 ,p_email IN varchar2 default null
574 ,p_language IN varchar2 default null
575 ,p_last_name in varchar2 default null
576 ,p_first_name in varchar2 default null
577 ,p_per_information_category in varchar2 default null
578 ,p_per_information1 in varchar2 default null
579 ,p_per_information2 in varchar2 default null
580 ,p_per_information3 in varchar2 default null
581 ,p_per_information4 in varchar2 default null
582 ,p_per_information5 in varchar2 default null
583 ,p_per_information6 in varchar2 default null
584 ,p_per_information7 in varchar2 default null
585 ,p_per_information8 in varchar2 default null
586 ,p_per_information9 in varchar2 default null
587 ,p_per_information10 in varchar2 default null
588 ,p_per_information11 in varchar2 default null
589 ,p_per_information12 in varchar2 default null
590 ,p_per_information13 in varchar2 default null
591 ,p_per_information14 in varchar2 default null
592 ,p_per_information15 in varchar2 default null
593 ,p_per_information16 in varchar2 default null
594 ,p_per_information17 in varchar2 default null
595 ,p_per_information18 in varchar2 default null
596 ,p_per_information19 in varchar2 default null
597 ,p_per_information20 in varchar2 default null
598 ,p_per_information21 in varchar2 default null
599 ,p_per_information22 in varchar2 default null
600 ,p_per_information23 in varchar2 default null
601 ,p_per_information24 in varchar2 default null
602 ,p_per_information25 in varchar2 default null
603 ,p_per_information26 in varchar2 default null
604 ,p_per_information27 in varchar2 default null
605 ,p_per_information28 in varchar2 default null
606 ,p_per_information29 in varchar2 default null
607 ,p_per_information30 in varchar2 default null
608 ,p_person_id in number default null
609 ,p_return_status OUT nocopy varchar2
610 );
611 --
612 end irc_party_swi;