1 PACKAGE hr_process_person_ss AUTHID CURRENT_USER AS
2 /* $Header: hrperwrs.pkh 120.7.12020000.1 2012/06/29 00:12:07 appldev ship $*/
3 g_date_format constant varchar2(10):='RRRR-MM-DD';
4 g_correct constant varchar2(10) := 'CORRECT';
5 g_change constant varchar2(10) := 'CHANGE';
6 g_attribute_update constant varchar2(100) := 'UPDATE';
7 g_attribute_correct constant varchar2(100) := 'CORRECTION';
8 g_update_for_approval constant varchar2(100) := 'UPDATE_FOR_APPROVAL';
9 g_update_basic_details constant varchar2(100) := 'UPDATE_BASIC_DETAILS';
10 g_trans_actvty_result_code constant varchar2(100) := 'NEXT';
11
12 --Start Registration
13 g_session_id number;
14 g_person_id number;
15 g_assignment_id number;
16 g_asg_object_version_number number;
17
18 --End Registration
19 --applicant_hire
20 g_is_applicant boolean := false;
21 --
22 -- ----------------------------------------------------------------------------
23 -- Following global variables will hold the Function Attribute
24 -- Internal Name. ( For Workflow )
25 -- ----------------------------------------------------------------------------
26 g_basic_details VARCHAR2(100) := 'BASIC_DETAILS';
27 g_contacts VARCHAR2(100) := 'CONTACTS';
28 g_phone_numbers VARCHAR2(100) := 'PHONE_NUMBERS';
29 g_main_address VARCHAR2(100) := 'MAIN_ADDRESS';
30 g_secondary_address VARCHAR2(100) := 'SECONDARY_ADDRESS';
31 --
32 --
33 -- ------------------------------------------------------------------------
34 -- -------------------------<get_hr_lookup_meaning>------------------------
35 -- ------------------------------------------------------------------------
36 -- Purpose: This procedure retrieves the lookup meaning from hr_lookups for the
37 -- lookup_type and lookup_code passed in.
38 -- ------------------------------------------------------------------------
39 Function get_hr_lookup_meaning(p_lookup_type in varchar2
40 ,p_lookup_code in varchar2)
41 return varchar2;
42
43
44 --
45 --
46 -- ------------------------------------------------------------------------
47 -- -------------------------<get_max_effective_date>------------------------
48 -- ------------------------------------------------------------------------
49 -- Purpose: This procedure retrieves the lookup meaning from hr_lookups for the
50 -- lookup_type and lookup_code passed in.
51 -- ------------------------------------------------------------------------
52 Function get_max_effective_date(p_person_id in number)
53 return Date;
54
55 --
56 --
57 -- ---------------------------------------------------------------------------
58 -- ---------------------- < get_person_data_from_tt> -------------------------
59 -- ---------------------------------------------------------------------------
60 -- Purpose: This procedure will get transaction data which are saved earlier
61 -- in the current transaction. This is invoked when a user click BACK
62 -- button to go back from the Review page to Update page to correct
63 -- typos or make further changes. Hence, we need to use the item_type
64 -- item_key passed in to retrieve the transaction record.
65 -- This is an overloaded version.
66 -- ---------------------------------------------------------------------------
67 PROCEDURE get_person_data_from_tt
68 (p_item_type in varchar2
69 ,p_item_key in varchar2
70 ,p_activity_id in number
71 ,p_trans_rec_count out nocopy number
72 ,p_effective_date out nocopy date
73 ,p_attribute_update_mode out nocopy varchar2
74 ,p_person_id out nocopy number
75 ,p_object_version_number out nocopy number
76 ,p_person_type_id out nocopy number
77 ,p_last_name out nocopy varchar2
78 ,p_applicant_number out nocopy varchar2
79 ,p_comments out nocopy varchar2
80 ,p_date_employee_data_verified out nocopy date
81 ,p_original_date_of_hire out nocopy date
82 ,p_date_of_birth out nocopy date
83 ,p_town_of_birth out nocopy varchar2
84 ,p_region_of_birth out nocopy varchar2
85 ,p_country_of_birth out nocopy varchar2
86 ,p_global_person_id out nocopy varchar2
87 ,p_email_address out nocopy varchar2
88 ,p_employee_number out nocopy varchar2
89 ,p_npw_number out nocopy varchar2
90 ,p_expense_check_send_to_addres out nocopy varchar2
91 ,p_first_name out nocopy varchar2
92 ,p_known_as out nocopy varchar2
93 ,p_marital_status out nocopy varchar2
94 ,p_middle_names out nocopy varchar2
95 ,p_nationality out nocopy varchar2
96 ,p_national_identifier out nocopy varchar2
97 ,p_previous_last_name out nocopy varchar2
98 ,p_registered_disabled_flag out nocopy varchar2
99 ,p_sex out nocopy varchar2
100 ,p_title out nocopy varchar2
101 ,p_vendor_id out nocopy number
102 ,p_work_telephone out nocopy varchar2
103 ,p_suffix out nocopy varchar2
104 ,p_date_of_death out nocopy date
105 ,p_background_check_status out nocopy varchar2
106 ,p_background_date_check out nocopy date
107 ,p_blood_type out nocopy varchar2
108 ,p_correspondence_language out nocopy varchar2
109 ,p_fast_path_employee out nocopy varchar2
110 ,p_fte_capacity out nocopy number
111 ,p_hold_applicant_date_until out nocopy date
112 ,p_honors out nocopy varchar2
113 ,p_internal_location out nocopy varchar2
114 ,p_last_medical_test_by out nocopy varchar2
115 ,p_last_medical_test_date out nocopy date
116 ,p_mailstop out nocopy varchar2
117 ,p_office_number out nocopy varchar2
118 ,p_on_military_service out nocopy varchar2
119 ,p_pre_name_adjunct out nocopy varchar2
120 ,p_projected_start_date out nocopy date
121 ,p_rehire_authorizor out nocopy varchar2
122 ,p_rehire_recommendation out nocopy varchar2
123 ,p_resume_exists out nocopy varchar2
124 ,p_resume_last_updated out nocopy date
125 ,p_second_passport_exists out nocopy varchar2
126 ,p_student_status out nocopy varchar2
127 ,p_work_schedule out nocopy varchar2
128 ,p_rehire_reason out nocopy varchar2
129 ,p_benefit_group_id out nocopy number
130 ,p_receipt_of_death_cert_date out nocopy date
131 ,p_coord_ben_med_pln_no out nocopy varchar2
132 ,p_coord_ben_no_cvg_flag out nocopy varchar2
133 ,p_uses_tobacco_flag out nocopy varchar2
134 ,p_dpdnt_adoption_date out nocopy varchar2
135 ,p_dpdnt_vlntry_svce_flag out nocopy varchar2
136 -- StartRegistration.
137 ,p_adjusted_svc_date out nocopy date
138 ,p_date_start out nocopy date
139 -- EndRegistration.
140 ,p_attribute_category out nocopy varchar2
141 ,p_attribute1 out nocopy varchar2
142 ,p_attribute2 out nocopy varchar2
143 ,p_attribute3 out nocopy varchar2
144 ,p_attribute4 out nocopy varchar2
145 ,p_attribute5 out nocopy varchar2
146 ,p_attribute6 out nocopy varchar2
147 ,p_attribute7 out nocopy varchar2
148 ,p_attribute8 out nocopy varchar2
149 ,p_attribute9 out nocopy varchar2
150 ,p_attribute10 out nocopy varchar2
151 ,p_attribute11 out nocopy varchar2
152 ,p_attribute12 out nocopy varchar2
153 ,p_attribute13 out nocopy varchar2
154 ,p_attribute14 out nocopy varchar2
155 ,p_attribute15 out nocopy varchar2
156 ,p_attribute16 out nocopy varchar2
157 ,p_attribute17 out nocopy varchar2
158 ,p_attribute18 out nocopy varchar2
159 ,p_attribute19 out nocopy varchar2
160 ,p_attribute20 out nocopy varchar2
161 ,p_attribute21 out nocopy varchar2
162 ,p_attribute22 out nocopy varchar2
163 ,p_attribute23 out nocopy varchar2
164 ,p_attribute24 out nocopy varchar2
165 ,p_attribute25 out nocopy varchar2
166 ,p_attribute26 out nocopy varchar2
167 ,p_attribute27 out nocopy varchar2
168 ,p_attribute28 out nocopy varchar2
169 ,p_attribute29 out nocopy varchar2
170 ,p_attribute30 out nocopy varchar2
171 ,p_per_information_category out nocopy varchar2
172 ,p_per_information1 out nocopy varchar2
173 ,p_per_information2 out nocopy varchar2
174 ,p_per_information3 out nocopy varchar2
175 ,p_per_information4 out nocopy varchar2
176 ,p_per_information5 out nocopy varchar2
177 ,p_per_information6 out nocopy varchar2
178 ,p_per_information7 out nocopy varchar2
179 ,p_per_information8 out nocopy varchar2
180 ,p_per_information9 out nocopy varchar2
181 ,p_per_information10 out nocopy varchar2
182 ,p_per_information11 out nocopy varchar2
183 ,p_per_information12 out nocopy varchar2
184 ,p_per_information13 out nocopy varchar2
185 ,p_per_information14 out nocopy varchar2
186 ,p_per_information15 out nocopy varchar2
187 ,p_per_information16 out nocopy varchar2
188 ,p_per_information17 out nocopy varchar2
189 ,p_per_information18 out nocopy varchar2
190 ,p_per_information19 out nocopy varchar2
191 ,p_per_information20 out nocopy varchar2
192 ,p_per_information21 out nocopy varchar2
193 ,p_per_information22 out nocopy varchar2
194 ,p_per_information23 out nocopy varchar2
195 ,p_per_information24 out nocopy varchar2
196 ,p_per_information25 out nocopy varchar2
197 ,p_per_information26 out nocopy varchar2
198 ,p_per_information27 out nocopy varchar2
199 ,p_per_information28 out nocopy varchar2
200 ,p_per_information29 out nocopy varchar2
201 ,p_per_information30 out nocopy varchar2
202 ,p_title_meaning out nocopy varchar2
203 ,p_marital_status_meaning out nocopy varchar2
204 ,p_full_name out nocopy varchar2
205 ,p_business_group_id out nocopy number
206 ,p_review_proc_call out nocopy varchar2
207 ,p_action_type out nocopy varchar2
208 );
209 --
210 --
211 -- ---------------------------------------------------------------------------
212 -- ---------------------- < get_person_data_from_tt> -------------------------
213 -- ---------------------------------------------------------------------------
214 -- Purpose: This procedure will get transaction data which are pending for
215 -- approval in workflow for a transaction step id.
216 -- This is the procedure which does the actual work.
217 -- ---------------------------------------------------------------------------
218 procedure get_person_data_from_tt
219 (p_transaction_step_id in number
220 ,p_effective_date out nocopy date
221 ,p_attribute_update_mode out nocopy varchar2
222 ,p_person_id out nocopy number
223 ,p_object_version_number out nocopy number
224 ,p_person_type_id out nocopy number
225 ,p_last_name out nocopy varchar2
226 ,p_applicant_number out nocopy varchar2
227 ,p_comments out nocopy varchar2
228 ,p_date_employee_data_verified out nocopy date
229 ,p_original_date_of_hire out nocopy date
230 ,p_date_of_birth out nocopy date
231 ,p_town_of_birth out nocopy varchar2
232 ,p_region_of_birth out nocopy varchar2
233 ,p_country_of_birth out nocopy varchar2
234 ,p_global_person_id out nocopy varchar2
235 ,p_email_address out nocopy varchar2
236 ,p_employee_number out nocopy varchar2
237 ,p_npw_number out nocopy varchar2
238 ,p_expense_check_send_to_addres out nocopy varchar2
239 ,p_first_name out nocopy varchar2
240 ,p_known_as out nocopy varchar2
241 ,p_marital_status out nocopy varchar2
242 ,p_middle_names out nocopy varchar2
243 ,p_nationality out nocopy varchar2
244 ,p_national_identifier out nocopy varchar2
245 ,p_previous_last_name out nocopy varchar2
246 ,p_registered_disabled_flag out nocopy varchar2
247 ,p_sex out nocopy varchar2
248 ,p_title out nocopy varchar2
249 ,p_vendor_id out nocopy number
250 ,p_work_telephone out nocopy varchar2
251 ,p_suffix out nocopy varchar2
252 ,p_date_of_death out nocopy date
253 ,p_background_check_status out nocopy varchar2
254 ,p_background_date_check out nocopy date
255 ,p_blood_type out nocopy varchar2
256 ,p_correspondence_language out nocopy varchar2
257 ,p_fast_path_employee out nocopy varchar2
258 ,p_fte_capacity out nocopy number
259 ,p_hold_applicant_date_until out nocopy date
260 ,p_honors out nocopy varchar2
261 ,p_internal_location out nocopy varchar2
262 ,p_last_medical_test_by out nocopy varchar2
263 ,p_last_medical_test_date out nocopy date
264 ,p_mailstop out nocopy varchar2
265 ,p_office_number out nocopy varchar2
266 ,p_on_military_service out nocopy varchar2
267 ,p_pre_name_adjunct out nocopy varchar2
268 ,p_projected_start_date out nocopy date
269 ,p_rehire_authorizor out nocopy varchar2
270 ,p_rehire_recommendation out nocopy varchar2
271 ,p_resume_exists out nocopy varchar2
272 ,p_resume_last_updated out nocopy date
273 ,p_second_passport_exists out nocopy varchar2
274 ,p_student_status out nocopy varchar2
275 ,p_work_schedule out nocopy varchar2
276 ,p_rehire_reason out nocopy varchar2
277 ,p_benefit_group_id out nocopy number
278 ,p_receipt_of_death_cert_date out nocopy date
279 ,p_coord_ben_med_pln_no out nocopy varchar2
280 ,p_coord_ben_no_cvg_flag out nocopy varchar2
281 ,p_uses_tobacco_flag out nocopy varchar2
282 ,p_dpdnt_adoption_date out nocopy date
283 ,p_dpdnt_vlntry_svce_flag out nocopy varchar2
284 -- StartRegistration.
285 ,p_adjusted_svc_date out nocopy date
286 ,p_date_start out nocopy date
287 -- EndRegistration.
288 ,p_attribute_category out nocopy varchar2
289 ,p_attribute1 out nocopy varchar2
290 ,p_attribute2 out nocopy varchar2
291 ,p_attribute3 out nocopy varchar2
292 ,p_attribute4 out nocopy varchar2
293 ,p_attribute5 out nocopy varchar2
294 ,p_attribute6 out nocopy varchar2
295 ,p_attribute7 out nocopy varchar2
296 ,p_attribute8 out nocopy varchar2
297 ,p_attribute9 out nocopy varchar2
298 ,p_attribute10 out nocopy varchar2
299 ,p_attribute11 out nocopy varchar2
300 ,p_attribute12 out nocopy varchar2
301 ,p_attribute13 out nocopy varchar2
302 ,p_attribute14 out nocopy varchar2
303 ,p_attribute15 out nocopy varchar2
304 ,p_attribute16 out nocopy varchar2
305 ,p_attribute17 out nocopy varchar2
306 ,p_attribute18 out nocopy varchar2
307 ,p_attribute19 out nocopy varchar2
308 ,p_attribute20 out nocopy varchar2
309 ,p_attribute21 out nocopy varchar2
310 ,p_attribute22 out nocopy varchar2
311 ,p_attribute23 out nocopy varchar2
312 ,p_attribute24 out nocopy varchar2
313 ,p_attribute25 out nocopy varchar2
314 ,p_attribute26 out nocopy varchar2
315 ,p_attribute27 out nocopy varchar2
316 ,p_attribute28 out nocopy varchar2
317 ,p_attribute29 out nocopy varchar2
318 ,p_attribute30 out nocopy varchar2
319 ,p_per_information_category out nocopy varchar2
320 ,p_per_information1 out nocopy varchar2
321 ,p_per_information2 out nocopy varchar2
322 ,p_per_information3 out nocopy varchar2
323 ,p_per_information4 out nocopy varchar2
324 ,p_per_information5 out nocopy varchar2
325 ,p_per_information6 out nocopy varchar2
326 ,p_per_information7 out nocopy varchar2
327 ,p_per_information8 out nocopy varchar2
328 ,p_per_information9 out nocopy varchar2
329 ,p_per_information10 out nocopy varchar2
330 ,p_per_information11 out nocopy varchar2
331 ,p_per_information12 out nocopy varchar2
332 ,p_per_information13 out nocopy varchar2
333 ,p_per_information14 out nocopy varchar2
334 ,p_per_information15 out nocopy varchar2
335 ,p_per_information16 out nocopy varchar2
336 ,p_per_information17 out nocopy varchar2
337 ,p_per_information18 out nocopy varchar2
338 ,p_per_information19 out nocopy varchar2
339 ,p_per_information20 out nocopy varchar2
340 ,p_per_information21 out nocopy varchar2
341 ,p_per_information22 out nocopy varchar2
342 ,p_per_information23 out nocopy varchar2
343 ,p_per_information24 out nocopy varchar2
344 ,p_per_information25 out nocopy varchar2
345 ,p_per_information26 out nocopy varchar2
346 ,p_per_information27 out nocopy varchar2
347 ,p_per_information28 out nocopy varchar2
348 ,p_per_information29 out nocopy varchar2
349 ,p_per_information30 out nocopy varchar2
350 ,p_title_meaning out nocopy varchar2
351 ,p_marital_status_meaning out nocopy varchar2
352 ,p_full_name out nocopy varchar2
353 ,p_business_group_id out nocopy number
354 ,p_review_proc_call out nocopy varchar2
355 ,p_action_type out nocopy varchar2
356 );
357
358 --
359 -- ---------------------------------------------------------------------------
360 -- ---------------------------- < update_person> ------------------------------
361 -- ---------------------------------------------------------------------------
362 -- Purpose: This procedure will perform validations when a user presses Next
363 -- on Update Basic Details entry page or on the Review page.
364 -- Either case, the data will be saved to the transaction table.
365 -- If this procedure is invoked from Review page, it will first check
366 -- that if a transaction already exists. If it does, it will update
367 -- the current transaction record.
368 -- ---------------------------------------------------------------------------
369 procedure update_person
370 (p_item_type in varchar2
371 ,p_item_key in varchar2
372 ,p_actid in number
373 ,p_login_person_id in number
374 ,p_process_section_name in varchar2
375 ,p_action_type in varchar2
376 ,p_validate_mode in varchar2 default 'Y'
377 ,p_review_page_region_code in varchar2 default hr_api.g_varchar2
378 ,p_effective_date in date
379 ,p_business_group_id in number
380 ,p_person_id in number
381 ,p_object_version_number in out nocopy number
382 ,p_person_type_id in number default hr_api.g_number
383 ,p_last_name in varchar2 default hr_api.g_varchar2
384 ,p_applicant_number in varchar2 default hr_api.g_varchar2
385 ,p_comments in varchar2 default hr_api.g_varchar2
386 ,p_date_employee_data_verified in date default hr_api.g_date
387 ,p_original_date_of_hire in date default hr_api.g_date
388 ,p_date_of_birth in date default hr_api.g_date
389 ,p_town_of_birth in varchar2 default hr_api.g_varchar2
390 ,p_region_of_birth in varchar2 default hr_api.g_varchar2
391 ,p_country_of_birth in varchar2 default hr_api.g_varchar2
392 ,p_global_person_id in varchar2 default hr_api.g_varchar2
393 ,p_email_address in varchar2 default hr_api.g_varchar2
394 ,p_employee_number in out nocopy varchar2
395 ,p_npw_number in varchar2 default hr_api.g_varchar2
396 ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
397 ,p_first_name in varchar2 default hr_api.g_varchar2
398 ,p_known_as in varchar2 default hr_api.g_varchar2
399 ,p_marital_status in varchar2 default hr_api.g_varchar2
400 ,p_middle_names in varchar2 default hr_api.g_varchar2
401 ,p_nationality in varchar2 default hr_api.g_varchar2
402 ,p_national_identifier in varchar2 default hr_api.g_varchar2
403 ,p_previous_last_name in varchar2 default hr_api.g_varchar2
404 ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
405 ,p_sex in varchar2 default hr_api.g_varchar2
406 ,p_title in varchar2 default hr_api.g_varchar2
407 ,p_vendor_id in number default hr_api.g_number
408 ,p_work_telephone in varchar2 default hr_api.g_varchar2
409 ,p_suffix in varchar2 default hr_api.g_varchar2
410 ,p_date_of_death in date default hr_api.g_date
411 ,p_background_check_status in varchar2 default hr_api.g_varchar2
412 ,p_background_date_check in date default hr_api.g_date
413 ,p_blood_type in varchar2 default hr_api.g_varchar2
414 ,p_correspondence_language in varchar2 default hr_api.g_varchar2
415 ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
416 ,p_fte_capacity in number default hr_api.g_number
417 ,p_hold_applicant_date_until in date default hr_api.g_date
418 ,p_honors in varchar2 default hr_api.g_varchar2
419 ,p_internal_location in varchar2 default hr_api.g_varchar2
420 ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
421 ,p_last_medical_test_date in date default hr_api.g_date
422 ,p_mailstop in varchar2 default hr_api.g_varchar2
423 ,p_office_number in varchar2 default hr_api.g_varchar2
424 ,p_on_military_service in varchar2 default hr_api.g_varchar2
425 ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
426 ,p_projected_start_date in date default hr_api.g_date
427 ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
428 ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
429 ,p_resume_exists in varchar2 default hr_api.g_varchar2
430 ,p_resume_last_updated in date default hr_api.g_date
431 ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
432 ,p_student_status in varchar2 default hr_api.g_varchar2
433 ,p_work_schedule in varchar2 default hr_api.g_varchar2
434 ,p_rehire_reason in varchar2 default hr_api.g_varchar2
435 ,p_benefit_group_id in number default hr_api.g_number
436 ,p_receipt_of_death_cert_date in date default hr_api.g_date
437 ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
438 ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
439 ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
440 ,p_dpdnt_adoption_date in date default hr_api.g_date
441 ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
442 ,p_adjusted_svc_date in date default hr_api.g_date
443 ,p_attribute_category in varchar2 default hr_api.g_varchar2
444 ,p_attribute1 in varchar2 default hr_api.g_varchar2
445 ,p_attribute2 in varchar2 default hr_api.g_varchar2
446 ,p_attribute3 in varchar2 default hr_api.g_varchar2
447 ,p_attribute4 in varchar2 default hr_api.g_varchar2
448 ,p_attribute5 in varchar2 default hr_api.g_varchar2
449 ,p_attribute6 in varchar2 default hr_api.g_varchar2
450 ,p_attribute7 in varchar2 default hr_api.g_varchar2
451 ,p_attribute8 in varchar2 default hr_api.g_varchar2
452 ,p_attribute9 in varchar2 default hr_api.g_varchar2
453 ,p_attribute10 in varchar2 default hr_api.g_varchar2
454 ,p_attribute11 in varchar2 default hr_api.g_varchar2
455 ,p_attribute12 in varchar2 default hr_api.g_varchar2
456 ,p_attribute13 in varchar2 default hr_api.g_varchar2
457 ,p_attribute14 in varchar2 default hr_api.g_varchar2
458 ,p_attribute15 in varchar2 default hr_api.g_varchar2
459 ,p_attribute16 in varchar2 default hr_api.g_varchar2
460 ,p_attribute17 in varchar2 default hr_api.g_varchar2
461 ,p_attribute18 in varchar2 default hr_api.g_varchar2
462 ,p_attribute19 in varchar2 default hr_api.g_varchar2
463 ,p_attribute20 in varchar2 default hr_api.g_varchar2
464 ,p_attribute21 in varchar2 default hr_api.g_varchar2
465 ,p_attribute22 in varchar2 default hr_api.g_varchar2
466 ,p_attribute23 in varchar2 default hr_api.g_varchar2
467 ,p_attribute24 in varchar2 default hr_api.g_varchar2
468 ,p_attribute25 in varchar2 default hr_api.g_varchar2
469 ,p_attribute26 in varchar2 default hr_api.g_varchar2
470 ,p_attribute27 in varchar2 default hr_api.g_varchar2
471 ,p_attribute28 in varchar2 default hr_api.g_varchar2
472 ,p_attribute29 in varchar2 default hr_api.g_varchar2
473 ,p_attribute30 in varchar2 default hr_api.g_varchar2
474 ,p_per_information_category in varchar2 default hr_api.g_varchar2
475 ,p_per_information1 in varchar2 default hr_api.g_varchar2
476 ,p_per_information2 in varchar2 default hr_api.g_varchar2
477 ,p_per_information3 in varchar2 default hr_api.g_varchar2
478 ,p_per_information4 in varchar2 default hr_api.g_varchar2
479 ,p_per_information5 in varchar2 default hr_api.g_varchar2
480 ,p_per_information6 in varchar2 default hr_api.g_varchar2
481 ,p_per_information7 in varchar2 default hr_api.g_varchar2
482 ,p_per_information8 in varchar2 default hr_api.g_varchar2
483 ,p_per_information9 in varchar2 default hr_api.g_varchar2
484 ,p_per_information10 in varchar2 default hr_api.g_varchar2
485 ,p_per_information11 in varchar2 default hr_api.g_varchar2
486 ,p_per_information12 in varchar2 default hr_api.g_varchar2
487 ,p_per_information13 in varchar2 default hr_api.g_varchar2
488 ,p_per_information14 in varchar2 default hr_api.g_varchar2
489 ,p_per_information15 in varchar2 default hr_api.g_varchar2
490 ,p_per_information16 in varchar2 default hr_api.g_varchar2
491 ,p_per_information17 in varchar2 default hr_api.g_varchar2
492 ,p_per_information18 in varchar2 default hr_api.g_varchar2
493 ,p_per_information19 in varchar2 default hr_api.g_varchar2
494 ,p_per_information20 in varchar2 default hr_api.g_varchar2
495 ,p_per_information21 in varchar2 default hr_api.g_varchar2
496 ,p_per_information22 in varchar2 default hr_api.g_varchar2
497 ,p_per_information23 in varchar2 default hr_api.g_varchar2
498 ,p_per_information24 in varchar2 default hr_api.g_varchar2
499 ,p_per_information25 in varchar2 default hr_api.g_varchar2
500 ,p_per_information26 in varchar2 default hr_api.g_varchar2
501 ,p_per_information27 in varchar2 default hr_api.g_varchar2
502 ,p_per_information28 in varchar2 default hr_api.g_varchar2
503 ,p_per_information29 in varchar2 default hr_api.g_varchar2
504 ,p_per_information30 in varchar2 default hr_api.g_varchar2
505 ,p_effective_start_date out nocopy date
506 ,p_effective_end_date out nocopy date
507 ,p_full_name in out nocopy varchar2
508 ,p_comment_id out nocopy number
509 ,p_name_combination_warning out nocopy varchar2
510 ,p_assign_payroll_warning in out nocopy varchar2
511 ,p_orig_hire_warning out nocopy varchar2
512 ,p_save_mode in varchar2 default null
513 ,p_asgn_change_mode in varchar2 default null
514 ,p_appl_assign_id in number default null
515 ,p_error_message out nocopy long
516 ,p_ni_duplicate_warn_or_err in out nocopy varchar2
517 ,p_validate_ni in out nocopy varchar2
518 );
519
520 --
521 -- ---------------------------------------------------------------------------
522 -- ---------------------- < validate_basic_details> -------------------------
523 -- ---------------------------------------------------------------------------
524 -- Purpose: This procedure will perform field validation and then call the api.
525 -- This procedure is invoked from Update Basic Details page.
526 -- ---------------------------------------------------------------------------
527 PROCEDURE validate_basic_details
528 (p_validate_mode in boolean default false
529 ,p_attribute_update_mode in varchar2
530 ,p_effective_date in date
531 ,p_person_id in number
532 ,p_object_version_number in out nocopy number
533 ,p_person_type_id in number default hr_api.g_number
534 ,p_last_name in varchar2 default hr_api.g_varchar2
535 ,p_applicant_number in varchar2 default hr_api.g_varchar2
536 ,p_comments in varchar2 default hr_api.g_varchar2
537 ,p_date_employee_data_verified in date default hr_api.g_date
538 ,p_original_date_of_hire in date default hr_api.g_date
539 ,p_date_of_birth in date default hr_api.g_date
540 ,p_town_of_birth in varchar2 default hr_api.g_varchar2
541 ,p_region_of_birth in varchar2 default hr_api.g_varchar2
542 ,p_country_of_birth in varchar2 default hr_api.g_varchar2
543 ,p_global_person_id in varchar2 default hr_api.g_varchar2
544 ,p_email_address in varchar2 default hr_api.g_varchar2
545 ,p_employee_number in out nocopy varchar2
546 ,p_npw_number in varchar2 default hr_api.g_varchar2
547 ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
548 ,p_first_name in varchar2 default hr_api.g_varchar2
549 ,p_known_as in varchar2 default hr_api.g_varchar2
550 ,p_marital_status in varchar2 default hr_api.g_varchar2
551 ,p_middle_names in varchar2 default hr_api.g_varchar2
552 ,p_nationality in varchar2 default hr_api.g_varchar2
553 ,p_national_identifier in varchar2 default hr_api.g_varchar2
554 ,p_previous_last_name in varchar2 default hr_api.g_varchar2
555 ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
556 ,p_sex in varchar2 default hr_api.g_varchar2
557 ,p_title in varchar2 default hr_api.g_varchar2
558 ,p_vendor_id in number default hr_api.g_number
559 ,p_work_telephone in varchar2 default hr_api.g_varchar2
560 ,p_suffix in varchar2 default hr_api.g_varchar2
561 ,p_date_of_death in date default hr_api.g_date
562 ,p_background_check_status in varchar2 default hr_api.g_varchar2
563 ,p_background_date_check in date default hr_api.g_date
564 ,p_blood_type in varchar2 default hr_api.g_varchar2
565 ,p_correspondence_language in varchar2 default hr_api.g_varchar2
566 ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
567 ,p_fte_capacity in number default hr_api.g_number
568 ,p_hold_applicant_date_until in date default hr_api.g_date
569 ,p_honors in varchar2 default hr_api.g_varchar2
570 ,p_internal_location in varchar2 default hr_api.g_varchar2
571 ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
572 ,p_last_medical_test_date in date default hr_api.g_date
573 ,p_mailstop in varchar2 default hr_api.g_varchar2
574 ,p_office_number in varchar2 default hr_api.g_varchar2
575 ,p_on_military_service in varchar2 default hr_api.g_varchar2
576 ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
577 ,p_projected_start_date in date default hr_api.g_date
578 ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
579 ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
580 ,p_resume_exists in varchar2 default hr_api.g_varchar2
581 ,p_resume_last_updated in date default hr_api.g_date
582 ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
583 ,p_student_status in varchar2 default hr_api.g_varchar2
584 ,p_work_schedule in varchar2 default hr_api.g_varchar2
585 ,p_rehire_reason in varchar2 default hr_api.g_varchar2
586 ,p_benefit_group_id in number default hr_api.g_number
587 ,p_receipt_of_death_cert_date in date default hr_api.g_date
588 ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
589 ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
590 ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
591 ,p_dpdnt_adoption_date in date default hr_api.g_date
592 ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
593 ,p_adjusted_svc_date in date default hr_api.g_date
594 ,p_attribute_category in varchar2 default hr_api.g_varchar2
595 ,p_attribute1 in varchar2 default hr_api.g_varchar2
596 ,p_attribute2 in varchar2 default hr_api.g_varchar2
597 ,p_attribute3 in varchar2 default hr_api.g_varchar2
598 ,p_attribute4 in varchar2 default hr_api.g_varchar2
599 ,p_attribute5 in varchar2 default hr_api.g_varchar2
600 ,p_attribute6 in varchar2 default hr_api.g_varchar2
601 ,p_attribute7 in varchar2 default hr_api.g_varchar2
602 ,p_attribute8 in varchar2 default hr_api.g_varchar2
603 ,p_attribute9 in varchar2 default hr_api.g_varchar2
604 ,p_attribute10 in varchar2 default hr_api.g_varchar2
605 ,p_attribute11 in varchar2 default hr_api.g_varchar2
606 ,p_attribute12 in varchar2 default hr_api.g_varchar2
607 ,p_attribute13 in varchar2 default hr_api.g_varchar2
608 ,p_attribute14 in varchar2 default hr_api.g_varchar2
609 ,p_attribute15 in varchar2 default hr_api.g_varchar2
610 ,p_attribute16 in varchar2 default hr_api.g_varchar2
611 ,p_attribute17 in varchar2 default hr_api.g_varchar2
612 ,p_attribute18 in varchar2 default hr_api.g_varchar2
613 ,p_attribute19 in varchar2 default hr_api.g_varchar2
614 ,p_attribute20 in varchar2 default hr_api.g_varchar2
615 ,p_attribute21 in varchar2 default hr_api.g_varchar2
616 ,p_attribute22 in varchar2 default hr_api.g_varchar2
617 ,p_attribute23 in varchar2 default hr_api.g_varchar2
618 ,p_attribute24 in varchar2 default hr_api.g_varchar2
619 ,p_attribute25 in varchar2 default hr_api.g_varchar2
620 ,p_attribute26 in varchar2 default hr_api.g_varchar2
621 ,p_attribute27 in varchar2 default hr_api.g_varchar2
622 ,p_attribute28 in varchar2 default hr_api.g_varchar2
623 ,p_attribute29 in varchar2 default hr_api.g_varchar2
624 ,p_attribute30 in varchar2 default hr_api.g_varchar2
625 ,p_per_information_category in varchar2 default hr_api.g_varchar2
626 ,p_per_information1 in varchar2 default hr_api.g_varchar2
627 ,p_per_information2 in varchar2 default hr_api.g_varchar2
628 ,p_per_information3 in varchar2 default hr_api.g_varchar2
629 ,p_per_information4 in varchar2 default hr_api.g_varchar2
630 ,p_per_information5 in varchar2 default hr_api.g_varchar2
631 ,p_per_information6 in varchar2 default hr_api.g_varchar2
632 ,p_per_information7 in varchar2 default hr_api.g_varchar2
633 ,p_per_information8 in varchar2 default hr_api.g_varchar2
634 ,p_per_information9 in varchar2 default hr_api.g_varchar2
635 ,p_per_information10 in varchar2 default hr_api.g_varchar2
636 ,p_per_information11 in varchar2 default hr_api.g_varchar2
637 ,p_per_information12 in varchar2 default hr_api.g_varchar2
638 ,p_per_information13 in varchar2 default hr_api.g_varchar2
639 ,p_per_information14 in varchar2 default hr_api.g_varchar2
640 ,p_per_information15 in varchar2 default hr_api.g_varchar2
641 ,p_per_information16 in varchar2 default hr_api.g_varchar2
642 ,p_per_information17 in varchar2 default hr_api.g_varchar2
643 ,p_per_information18 in varchar2 default hr_api.g_varchar2
644 ,p_per_information19 in varchar2 default hr_api.g_varchar2
645 ,p_per_information20 in varchar2 default hr_api.g_varchar2
646 ,p_per_information21 in varchar2 default hr_api.g_varchar2
647 ,p_per_information22 in varchar2 default hr_api.g_varchar2
648 ,p_per_information23 in varchar2 default hr_api.g_varchar2
649 ,p_per_information24 in varchar2 default hr_api.g_varchar2
650 ,p_per_information25 in varchar2 default hr_api.g_varchar2
651 ,p_per_information26 in varchar2 default hr_api.g_varchar2
652 ,p_per_information27 in varchar2 default hr_api.g_varchar2
653 ,p_per_information28 in varchar2 default hr_api.g_varchar2
654 ,p_per_information29 in varchar2 default hr_api.g_varchar2
655 ,p_per_information30 in varchar2 default hr_api.g_varchar2
656 ,p_effective_start_date out nocopy date
657 ,p_effective_end_date out nocopy date
658 ,p_full_name out nocopy varchar2
659 ,p_comment_id out nocopy number
660 ,p_name_combination_warning out nocopy boolean
661 ,p_assign_payroll_warning in out nocopy boolean
662 ,p_orig_hire_warning out nocopy boolean
663 ,p_error_message out nocopy long
664 );
665
666 --
667 --
668 -- ---------------------------------------------------------------------------
669 -- ---------------------------- < is_rec_changed > ---------------------------
670 -- ---------------------------------------------------------------------------
671 -- Purpose: This function will check field by field to determine if there
672 -- are any changes made to the record.
673 -- ---------------------------------------------------------------------------
674 FUNCTION is_rec_changed
675 (p_effective_date in date
676 ,p_person_id in number
677 ,p_object_version_number in number
678 ,p_person_type_id in number default hr_api.g_number
679 ,p_last_name in varchar2 default hr_api.g_varchar2
680 ,p_applicant_number in varchar2 default hr_api.g_varchar2
681 ,p_comments in varchar2 default hr_api.g_varchar2
682 ,p_date_employee_data_verified in date default hr_api.g_date
683 ,p_original_date_of_hire in date default hr_api.g_date
684 ,p_date_of_birth in date default hr_api.g_date
685 ,p_town_of_birth in varchar2 default hr_api.g_varchar2
686 ,p_region_of_birth in varchar2 default hr_api.g_varchar2
687 ,p_country_of_birth in varchar2 default hr_api.g_varchar2
688 ,p_global_person_id in varchar2 default hr_api.g_varchar2
689 ,p_email_address in varchar2 default hr_api.g_varchar2
690 ,p_employee_number in varchar2 default hr_api.g_varchar2
691 ,p_npw_number in varchar2 default hr_api.g_varchar2
692 ,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
693 ,p_first_name in varchar2 default hr_api.g_varchar2
694 ,p_known_as in varchar2 default hr_api.g_varchar2
695 ,p_marital_status in varchar2 default hr_api.g_varchar2
696 ,p_middle_names in varchar2 default hr_api.g_varchar2
697 ,p_nationality in varchar2 default hr_api.g_varchar2
698 ,p_national_identifier in varchar2 default hr_api.g_varchar2
699 ,p_previous_last_name in varchar2 default hr_api.g_varchar2
700 ,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
701 ,p_sex in varchar2 default hr_api.g_varchar2
702 ,p_title in varchar2 default hr_api.g_varchar2
703 ,p_vendor_id in number default hr_api.g_number
704 ,p_work_telephone in varchar2 default hr_api.g_varchar2
705 ,p_suffix in varchar2 default hr_api.g_varchar2
706 ,p_date_of_death in date default hr_api.g_date
707 ,p_background_check_status in varchar2 default hr_api.g_varchar2
708 ,p_background_date_check in date default hr_api.g_date
709 ,p_blood_type in varchar2 default hr_api.g_varchar2
710 ,p_correspondence_language in varchar2 default hr_api.g_varchar2
711 ,p_fast_path_employee in varchar2 default hr_api.g_varchar2
712 ,p_fte_capacity in number default hr_api.g_number
713 ,p_hold_applicant_date_until in date default hr_api.g_date
714 ,p_honors in varchar2 default hr_api.g_varchar2
715 ,p_internal_location in varchar2 default hr_api.g_varchar2
716 ,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
717 ,p_last_medical_test_date in date default hr_api.g_date
718 ,p_mailstop in varchar2 default hr_api.g_varchar2
719 ,p_office_number in varchar2 default hr_api.g_varchar2
720 ,p_on_military_service in varchar2 default hr_api.g_varchar2
721 ,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
722 ,p_projected_start_date in date default hr_api.g_date
723 ,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
724 ,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
725 ,p_resume_exists in varchar2 default hr_api.g_varchar2
726 ,p_resume_last_updated in date default hr_api.g_date
727 ,p_second_passport_exists in varchar2 default hr_api.g_varchar2
728 ,p_student_status in varchar2 default hr_api.g_varchar2
729 ,p_work_schedule in varchar2 default hr_api.g_varchar2
730 ,p_rehire_reason in varchar2 default hr_api.g_varchar2
731 ,p_benefit_group_id in number default hr_api.g_number
732 ,p_receipt_of_death_cert_date in date default hr_api.g_date
733 ,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
734 ,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
735 ,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
736 ,p_dpdnt_adoption_date in date default hr_api.g_date
737 ,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
738 ,p_adjusted_svc_date in date default hr_api.g_date
739 ,p_attribute_category in varchar2 default hr_api.g_varchar2
740 ,p_attribute1 in varchar2 default hr_api.g_varchar2
741 ,p_attribute2 in varchar2 default hr_api.g_varchar2
742 ,p_attribute3 in varchar2 default hr_api.g_varchar2
743 ,p_attribute4 in varchar2 default hr_api.g_varchar2
744 ,p_attribute5 in varchar2 default hr_api.g_varchar2
745 ,p_attribute6 in varchar2 default hr_api.g_varchar2
746 ,p_attribute7 in varchar2 default hr_api.g_varchar2
747 ,p_attribute8 in varchar2 default hr_api.g_varchar2
748 ,p_attribute9 in varchar2 default hr_api.g_varchar2
749 ,p_attribute10 in varchar2 default hr_api.g_varchar2
750 ,p_attribute11 in varchar2 default hr_api.g_varchar2
751 ,p_attribute12 in varchar2 default hr_api.g_varchar2
752 ,p_attribute13 in varchar2 default hr_api.g_varchar2
753 ,p_attribute14 in varchar2 default hr_api.g_varchar2
754 ,p_attribute15 in varchar2 default hr_api.g_varchar2
755 ,p_attribute16 in varchar2 default hr_api.g_varchar2
756 ,p_attribute17 in varchar2 default hr_api.g_varchar2
757 ,p_attribute18 in varchar2 default hr_api.g_varchar2
758 ,p_attribute19 in varchar2 default hr_api.g_varchar2
759 ,p_attribute20 in varchar2 default hr_api.g_varchar2
760 ,p_attribute21 in varchar2 default hr_api.g_varchar2
761 ,p_attribute22 in varchar2 default hr_api.g_varchar2
762 ,p_attribute23 in varchar2 default hr_api.g_varchar2
763 ,p_attribute24 in varchar2 default hr_api.g_varchar2
764 ,p_attribute25 in varchar2 default hr_api.g_varchar2
765 ,p_attribute26 in varchar2 default hr_api.g_varchar2
766 ,p_attribute27 in varchar2 default hr_api.g_varchar2
767 ,p_attribute28 in varchar2 default hr_api.g_varchar2
768 ,p_attribute29 in varchar2 default hr_api.g_varchar2
769 ,p_attribute30 in varchar2 default hr_api.g_varchar2
770 ,p_per_information_category in varchar2 default hr_api.g_varchar2
771 ,p_per_information1 in varchar2 default hr_api.g_varchar2
772 ,p_per_information2 in varchar2 default hr_api.g_varchar2
773 ,p_per_information3 in varchar2 default hr_api.g_varchar2
774 ,p_per_information4 in varchar2 default hr_api.g_varchar2
775 ,p_per_information5 in varchar2 default hr_api.g_varchar2
776 ,p_per_information6 in varchar2 default hr_api.g_varchar2
777 ,p_per_information7 in varchar2 default hr_api.g_varchar2
778 ,p_per_information8 in varchar2 default hr_api.g_varchar2
779 ,p_per_information9 in varchar2 default hr_api.g_varchar2
780 ,p_per_information10 in varchar2 default hr_api.g_varchar2
781 ,p_per_information11 in varchar2 default hr_api.g_varchar2
782 ,p_per_information12 in varchar2 default hr_api.g_varchar2
783 ,p_per_information13 in varchar2 default hr_api.g_varchar2
784 ,p_per_information14 in varchar2 default hr_api.g_varchar2
785 ,p_per_information15 in varchar2 default hr_api.g_varchar2
786 ,p_per_information16 in varchar2 default hr_api.g_varchar2
787 ,p_per_information17 in varchar2 default hr_api.g_varchar2
788 ,p_per_information18 in varchar2 default hr_api.g_varchar2
789 ,p_per_information19 in varchar2 default hr_api.g_varchar2
790 ,p_per_information20 in varchar2 default hr_api.g_varchar2
791 ,p_per_information21 in varchar2 default hr_api.g_varchar2
792 ,p_per_information22 in varchar2 default hr_api.g_varchar2
793 ,p_per_information23 in varchar2 default hr_api.g_varchar2
794 ,p_per_information24 in varchar2 default hr_api.g_varchar2
795 ,p_per_information25 in varchar2 default hr_api.g_varchar2
796 ,p_per_information26 in varchar2 default hr_api.g_varchar2
797 ,p_per_information27 in varchar2 default hr_api.g_varchar2
798 ,p_per_information28 in varchar2 default hr_api.g_varchar2
799 ,p_per_information29 in varchar2 default hr_api.g_varchar2
800 ,p_per_information30 in varchar2 default hr_api.g_varchar2
801 )
802 return boolean;
803
804 --
805 -- ---------------------------------------------------------------------------
806 -- ----------------------------- < process_api > -----------------------------
807 -- ---------------------------------------------------------------------------
808 -- Purpose: This procedure will be invoked in workflow notification
809 -- when an approver approves all the changes. This procedure
810 -- will call the api to update to the database with p_validate
811 -- equal to false.
812 -- ---------------------------------------------------------------------------
813 procedure process_api
814 (p_validate in boolean default false
815 ,p_transaction_step_id in number
816 ,p_effective_date in varchar2 default null
817 );
818
819 procedure process_dummy_api
820 (p_validate in boolean default false
821 ,p_transaction_step_id in number
822 ,p_effective_date in varchar2 default null
823 );
824
825 --
826 --Start Registration
827
828 -------------------------------------------------------------------------------
829 -- ---------------------------------------------------------------------------
830 -- Purpose: This procedure will perform validations when a user presses Next
831 -- on Insert Basic Details entry page the data will be saved to the
832 -- transaction table.
833 -- ---------------------------------------------------------------------------
834 --
835 procedure create_person
836 (p_item_type in varchar2
837 ,p_item_key in varchar2
838 ,p_actid in number
839 ,p_login_person_id in number
840 ,p_process_section_name in varchar2
841 ,p_action_type in varchar2
842 ,p_validate in varchar2 default 'Y'
843 --boolean default false
844 ,p_hire_date in date
845 ,p_business_group_id in number
846 ,p_last_name in varchar2
847 ,p_sex in varchar2
848 ,p_review_page_region_code in varchar2 default hr_api.g_varchar2
849 ,p_person_type_id in number default null
850 ,p_per_comments in varchar2 default null
851 ,p_date_employee_data_verified in date default null
852 ,p_date_of_birth in date default null
853 ,p_email_address in varchar2 default null
854 ,p_employee_number in out nocopy varchar2
855 ,p_npw_number in out nocopy varchar2
856 ,p_expense_check_send_to_addres in varchar2 default null
857 ,p_first_name in varchar2 default null
858 ,p_known_as in varchar2 default null
859 ,p_marital_status in varchar2 default null
860 ,p_middle_names in varchar2 default null
861 ,p_nationality in varchar2 default null
862 ,p_national_identifier in varchar2 default null
863 ,p_previous_last_name in varchar2 default null
864 ,p_registered_disabled_flag in varchar2 default null
865 ,p_title in varchar2 default null
866 ,p_vendor_id in number default null
867 ,p_work_telephone in varchar2 default null
868 ,p_attribute_category in varchar2 default null
869 ,p_attribute1 in varchar2 default null
870 ,p_attribute2 in varchar2 default null
871 ,p_attribute3 in varchar2 default null
872 ,p_attribute4 in varchar2 default null
873 ,p_attribute5 in varchar2 default null
874 ,p_attribute6 in varchar2 default null
875 ,p_attribute7 in varchar2 default null
876 ,p_attribute8 in varchar2 default null
877 ,p_attribute9 in varchar2 default null
878 ,p_attribute10 in varchar2 default null
879 ,p_attribute11 in varchar2 default null
880 ,p_attribute12 in varchar2 default null
881 ,p_attribute13 in varchar2 default null
882 ,p_attribute14 in varchar2 default null
883 ,p_attribute15 in varchar2 default null
884 ,p_attribute16 in varchar2 default null
885 ,p_attribute17 in varchar2 default null
886 ,p_attribute18 in varchar2 default null
887 ,p_attribute19 in varchar2 default null
888 ,p_attribute20 in varchar2 default null
889 ,p_attribute21 in varchar2 default null
890 ,p_attribute22 in varchar2 default null
891 ,p_attribute23 in varchar2 default null
892 ,p_attribute24 in varchar2 default null
893 ,p_attribute25 in varchar2 default null
894 ,p_attribute26 in varchar2 default null
895 ,p_attribute27 in varchar2 default null
896 ,p_attribute28 in varchar2 default null
897 ,p_attribute29 in varchar2 default null
898 ,p_attribute30 in varchar2 default null
899 ,p_per_information_category in varchar2 default null
900 ,p_per_information1 in varchar2 default null
901 ,p_per_information2 in varchar2 default null
902 ,p_per_information3 in varchar2 default null
903 ,p_per_information4 in varchar2 default null
904 ,p_per_information5 in varchar2 default null
905 ,p_per_information6 in varchar2 default null
906 ,p_per_information7 in varchar2 default null
907 ,p_per_information8 in varchar2 default null
908 ,p_per_information9 in varchar2 default null
909 ,p_per_information10 in varchar2 default null
910 ,p_per_information11 in varchar2 default null
911 ,p_per_information12 in varchar2 default null
912 ,p_per_information13 in varchar2 default null
913 ,p_per_information14 in varchar2 default null
914 ,p_per_information15 in varchar2 default null
915 ,p_per_information16 in varchar2 default null
916 ,p_per_information17 in varchar2 default null
917 ,p_per_information18 in varchar2 default null
918 ,p_per_information19 in varchar2 default null
919 ,p_per_information20 in varchar2 default null
920 ,p_per_information21 in varchar2 default null
921 ,p_per_information22 in varchar2 default null
922 ,p_per_information23 in varchar2 default null
923 ,p_per_information24 in varchar2 default null
924 ,p_per_information25 in varchar2 default null
925 ,p_per_information26 in varchar2 default null
926 ,p_per_information27 in varchar2 default null
927 ,p_per_information28 in varchar2 default null
928 ,p_per_information29 in varchar2 default null
929 ,p_per_information30 in varchar2 default null
930 ,p_date_of_death in date default null
931 ,p_background_check_status in varchar2 default null
932 ,p_background_date_check in date default null
933 ,p_blood_type in varchar2 default null
934 ,p_correspondence_language in varchar2 default null
935 ,p_fast_path_employee in varchar2 default null
936 ,p_fte_capacity in number default null
937 ,p_honors in varchar2 default null
938 ,p_internal_location in varchar2 default null
939 ,p_last_medical_test_by in varchar2 default null
940 ,p_last_medical_test_date in date default null
941 ,p_mailstop in varchar2 default null
942 ,p_office_number in varchar2 default null
943 ,p_on_military_service in varchar2 default null
944 ,p_pre_name_adjunct in varchar2 default null
945 ,p_projected_start_date in date default null
946 ,p_resume_exists in varchar2 default null
947 ,p_resume_last_updated in date default null
948 ,p_second_passport_exists in varchar2 default null
949 ,p_student_status in varchar2 default null
950 ,p_work_schedule in varchar2 default null
951 ,p_suffix in varchar2 default null
952 ,p_benefit_group_id in number default null
953 ,p_receipt_of_death_cert_date in date default null
954 ,p_coord_ben_med_pln_no in varchar2 default null
955 ,p_coord_ben_no_cvg_flag in varchar2 default 'N'
956 ,p_uses_tobacco_flag in varchar2 default null
957 ,p_dpdnt_adoption_date in date default null
958 ,p_dpdnt_vlntry_svce_flag in varchar2 default 'N'
959 ,p_original_date_of_hire in date default null
960 ,p_adjusted_svc_date in date default null
961 ,p_town_of_birth in varchar2 default null
962 ,p_region_of_birth in varchar2 default null
963 ,p_country_of_birth in varchar2 default null
964 ,p_global_person_id in varchar2 default null
965 ,p_effective_date in date default sysdate
966 ,p_attribute_update_mode in varchar2 default null
967 ,p_object_version_number in number default null
968 ,p_applicant_number in varchar2 default null
969 ,p_comments in varchar2 default null
970 ,p_rehire_authorizor in varchar2 default null
971 ,p_rehire_recommendation in varchar2 default null
972 ,p_hold_applicant_date_until in date default null
973 ,p_rehire_reason in varchar2 default null
974 ,p_flow_name in varchar2 default null
975 ,p_person_id out nocopy number
976 ,p_assignment_id out nocopy number
977 ,p_per_object_version_number out nocopy number
978 ,p_asg_object_version_number out nocopy number
979 ,p_per_effective_start_date out nocopy date
980 ,p_per_effective_end_date out nocopy date
981 ,p_full_name out nocopy varchar2
982 ,p_per_comment_id out nocopy number
983 ,p_assignment_sequence out nocopy number
984 ,p_assignment_number out nocopy varchar2
985 ,p_name_combination_warning out nocopy varchar2
986 ,p_assign_payroll_warning out nocopy varchar2
987 ,p_orig_hire_warning out nocopy varchar2
988 ,p_party_id in number default null
989 ,p_save_mode in varchar2 default null
990 ,p_error_message out nocopy long
991 ,p_ni_duplicate_warn_or_err in out nocopy varchar2
992 ,p_validate_ni in out nocopy varchar2
993 );
994
995 /* When we try to hire an applicant with payroll and no DOB or address we get error.
996 This happens because when we hire applicant the payroll validation fails. Now before
997 hiring set his payroll to null.
998 In process_api reverted it back to original value after hiring. */
999
1000 procedure process_applicant(
1001 p_effective_date in date
1002 ,p_person_id in number
1003 ,p_business_group_id in number
1004 ,p_assignment_id in number
1005 ,p_soft_coding_keyflex_id in number default null
1006 ,p_is_payroll_upd out nocopy boolean);
1007
1008 --
1009 --End Start Registration
1010 --
1011 END hr_process_person_ss;
1012 --
1013 --
[Home] [Help]