1 package HR_PERSON_BUSINESS_EVENT as
2 /* $Header: peperbev.pkh 120.0.12010000.2 2008/08/27 14:58:05 srgnanas ship $ */
3
4
5 --
6 -- -----------------------------------------------------------------------------------
7 -- |--------------------------< person_business_event >--------------------------|
8 -- -----------------------------------------------------------------------------------
9 -- {Start Of Comments}
10 --
11 -- Description:
12 -- This package raises a business event.
13 --
14 -- Prerequisites:
15 -- None
16 -- In Parameters:
17 -- Name Reqd Type Description
18 -- p_event Y varchar2
19 -- p_datetrack_update_mode N varchar2
20 -- p_system_person_type Y varchar2
21 -- p_effective_date Y date
22 -- p_person_id Y number
23 -- p_object_version_number Y number
24 -- p_person_type_id N number
25 -- p_last_name N varchar2
26 -- p_applicant_number N varchar2
27 -- p_comments N varchar2
28 -- p_date_employee_data_verified N date
29 -- p_date_of_birth N date
30 -- p_email_address N varchar2
31 -- p_employee_number N varchar2
32 -- p_expense_check_send_to_addres N varchar2
33 -- p_first_name N varchar2
34 -- p_known_as N varchar2
35 -- p_marital_status N varchar2
36 -- p_middle_names N varchar2
37 -- p_nationality N varchar2
38 -- p_national_identifier N varchar2
39 -- p_previous_last_name N varchar2
40 -- p_registered_disabled_flag N varchar2
41 -- p_sex N varchar2
42 -- p_title N varchar2
43 -- p_vendor_id N number
44 -- p_attribute_category N varchar2
45 -- p_attribute1 N varchar2
46 -- p_attribute2 N varchar2
47 -- p_attribute3 N varchar2
48 -- p_attribute4 N varchar2
49 -- p_attribute5 N varchar2
50 -- p_attribute6 N varchar2
51 -- p_attribute7 N varchar2
52 -- p_attribute8 N varchar2
53 -- p_attribute9 N varchar2
54 -- p_attribute10 N varchar2
55 -- p_attribute11 N varchar2
56 -- p_attribute12 N varchar2
57 -- p_attribute13 N varchar2
58 -- p_attribute14 N varchar2
59 -- p_attribute15 N varchar2
60 -- p_attribute16 N varchar2
61 -- p_attribute17 N varchar2
62 -- p_attribute18 N varchar2
63 -- p_attribute19 N varchar2
64 -- p_attribute20 N varchar2
65 -- p_attribute21 N varchar2
66 -- p_attribute22 N varchar2
67 -- p_attribute23 N varchar2
68 -- p_attribute24 N varchar2
69 -- p_attribute25 N varchar2
70 -- p_attribute26 N varchar2
71 -- p_attribute27 N varchar2
72 -- p_attribute28 N varchar2
73 -- p_attribute29 N varchar2
74 -- p_attribute30 N varchar2
75 -- p_per_information_category N varchar2
76 -- p_per_information1 N varchar2
77 -- p_per_information2 N varchar2
78 -- p_per_information3 N varchar2
79 -- p_per_information4 N varchar2
80 -- p_per_information5 N varchar2
81 -- p_per_information6 N varchar2
82 -- p_per_information7 N varchar2
83 -- p_per_information8 N varchar2
84 -- p_per_information9 N varchar2
85 -- p_per_information10 N varchar2
86 -- p_per_information11 N varchar2
87 -- p_per_information12 N varchar2
88 -- p_per_information13 N varchar2
89 -- p_per_information14 N varchar2
90 -- p_per_information15 N varchar2
91 -- p_per_information16 N varchar2
92 -- p_per_information17 N varchar2
93 -- p_per_information18 N varchar2
94 -- p_per_information19 N varchar2
95 -- p_per_information20 N varchar2
96 -- p_per_information21 N varchar2
97 -- p_per_information22 N varchar2
98 -- p_per_information23 N varchar2
99 -- p_per_information24 N varchar2
100 -- p_per_information25 N varchar2
101 -- p_per_information26 N varchar2
102 -- p_per_information27 N varchar2
103 -- p_per_information28 N varchar2
104 -- p_per_information29 N varchar2
105 -- p_per_information30 N varchar2
106 -- p_date_of_death N date
107 -- p_background_check_status N varchar2
108 -- p_background_date_check N date
109 -- p_blood_type N varchar2
110 -- p_correspondence_language N varchar2
111 -- p_fast_path_employee N varchar2
112 -- p_fte_capacity N number
113 -- p_hold_applicant_date_until N date
114 -- p_honors N varchar2
115 -- p_internal_location N varchar2
116 -- p_last_medical_test_by N varchar2
117 -- p_last_medical_test_date N date
118 -- p_mailstop N varchar2
119 -- p_office_number N varchar2
120 -- p_on_military_service N varchar2
121 -- p_pre_name_adjunct N varchar2
122 -- p_projected_start_date N date
123 -- p_rehire_authorizor N varchar2
124 -- p_rehire_recommendation N varchar2
125 -- p_resume_exists N varchar2
126 -- p_resume_last_updated N date
127 -- p_second_passport_exists N varchar2
128 -- p_student_status N varchar2
129 -- p_work_schedule N varchar2
130 -- p_rehire_reason N varchar2
131 -- p_suffix N varchar2
132 -- p_benefit_group_id N number
133 -- p_receipt_of_death_cert_date N date
134 -- p_coord_ben_med_pln_no N varchar2
135 -- p_coord_ben_no_cvg_flag N varchar2
136 -- p_coord_ben_med_ext_er N varchar2
137 -- p_coord_ben_med_pl_name N varchar2
138 -- p_coord_ben_med_insr_crr_name N varchar2
139 -- p_coord_ben_med_insr_crr_ident N varchar2
140 -- p_coord_ben_med_cvg_strt_dt N date
141 -- p_coord_ben_med_cvg_end_dt N date
142 -- p_uses_tobacco_flag N varchar2
143 -- p_dpdnt_adoption_date N date
144 -- p_dpdnt_vlntry_svce_flag N varchar2
145 -- p_original_date_of_hire N date
146 -- p_adjusted_svc_date N date
147 -- p_effective_start_date N date
148 -- p_effective_end_date N date
149 -- p_full_name N varchar2
150 -- p_comment_id N number
151 -- p_town_of_birth N varchar2
152 -- p_region_of_birth N varchar2
153 -- p_country_of_birth N varchar2
154 -- p_global_person_id N varchar2
155 -- p_party_id N number
156 -- p_npw_number N varchar2
157 -- p_name_combination_warning N boolean
158 -- p_assign_payroll_warning N boolean
159 -- p_orig_hire_warning N boolean
160 -- Post Success:
161 -- A Business Event will be raised on update of Person.
162 --
163 --
164 -- Post Failure:
165 -- Business Event will not be raised and an error will be raised.
166 --
167 -- Access Status:
168 -- Public.
169 --
170 -- {End Of Comments}
171
172
173 procedure person_business_event(
174 p_event in varchar2,
175 p_datetrack_update_mode in varchar2 default hr_api.g_update,
176 p_system_person_type in varchar2,
177 p_effective_date in date,
178 p_person_id in number,
179 p_object_version_number in number,
180 p_person_type_id in number default hr_api.g_number,
181 p_last_name in varchar2 default hr_api.g_varchar2,
182 p_applicant_number in varchar2 default hr_api.g_varchar2,
183 p_comments in varchar2 default hr_api.g_varchar2,
184 p_date_employee_data_verified in date default hr_api.g_date,
185 p_date_of_birth in date default hr_api.g_date,
186 p_email_address in varchar2 default hr_api.g_varchar2,
187 p_employee_number in varchar2 default hr_api.g_varchar2,
188 p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2,
189 p_first_name in varchar2 default hr_api.g_varchar2,
190 p_known_as in varchar2 default hr_api.g_varchar2,
191 p_marital_status in varchar2 default hr_api.g_varchar2,
192 p_middle_names in varchar2 default hr_api.g_varchar2,
193 p_nationality in varchar2 default hr_api.g_varchar2,
194 p_national_identifier in varchar2 default hr_api.g_varchar2,
195 p_previous_last_name in varchar2 default hr_api.g_varchar2,
196 p_registered_disabled_flag in varchar2 default hr_api.g_varchar2,
197 p_sex in varchar2 default hr_api.g_varchar2,
198 p_title in varchar2 default hr_api.g_varchar2,
199 p_vendor_id in number default hr_api.g_number,
200 p_attribute_category in varchar2 default hr_api.g_varchar2,
201 p_attribute1 in varchar2 default hr_api.g_varchar2,
202 p_attribute2 in varchar2 default hr_api.g_varchar2,
203 p_attribute3 in varchar2 default hr_api.g_varchar2,
204 p_attribute4 in varchar2 default hr_api.g_varchar2,
205 p_attribute5 in varchar2 default hr_api.g_varchar2,
206 p_attribute6 in varchar2 default hr_api.g_varchar2,
207 p_attribute7 in varchar2 default hr_api.g_varchar2,
208 p_attribute8 in varchar2 default hr_api.g_varchar2,
209 p_attribute9 in varchar2 default hr_api.g_varchar2,
210 p_attribute10 in varchar2 default hr_api.g_varchar2,
211 p_attribute11 in varchar2 default hr_api.g_varchar2,
212 p_attribute12 in varchar2 default hr_api.g_varchar2,
213 p_attribute13 in varchar2 default hr_api.g_varchar2,
214 p_attribute14 in varchar2 default hr_api.g_varchar2,
215 p_attribute15 in varchar2 default hr_api.g_varchar2,
216 p_attribute16 in varchar2 default hr_api.g_varchar2,
217 p_attribute17 in varchar2 default hr_api.g_varchar2,
218 p_attribute18 in varchar2 default hr_api.g_varchar2,
219 p_attribute19 in varchar2 default hr_api.g_varchar2,
220 p_attribute20 in varchar2 default hr_api.g_varchar2,
221 p_attribute21 in varchar2 default hr_api.g_varchar2,
222 p_attribute22 in varchar2 default hr_api.g_varchar2,
223 p_attribute23 in varchar2 default hr_api.g_varchar2,
224 p_attribute24 in varchar2 default hr_api.g_varchar2,
225 p_attribute25 in varchar2 default hr_api.g_varchar2,
226 p_attribute26 in varchar2 default hr_api.g_varchar2,
227 p_attribute27 in varchar2 default hr_api.g_varchar2,
228 p_attribute28 in varchar2 default hr_api.g_varchar2,
229 p_attribute29 in varchar2 default hr_api.g_varchar2,
230 p_attribute30 in varchar2 default hr_api.g_varchar2,
231 p_per_information_category in varchar2 default hr_api.g_varchar2,
232 p_per_information1 in varchar2 default hr_api.g_varchar2,
233 p_per_information2 in varchar2 default hr_api.g_varchar2,
234 p_per_information3 in varchar2 default hr_api.g_varchar2,
235 p_per_information4 in varchar2 default hr_api.g_varchar2,
236 p_per_information5 in varchar2 default hr_api.g_varchar2,
237 p_per_information6 in varchar2 default hr_api.g_varchar2,
238 p_per_information7 in varchar2 default hr_api.g_varchar2,
239 p_per_information8 in varchar2 default hr_api.g_varchar2,
240 p_per_information9 in varchar2 default hr_api.g_varchar2,
241 p_per_information10 in varchar2 default hr_api.g_varchar2,
242 p_per_information11 in varchar2 default hr_api.g_varchar2,
243 p_per_information12 in varchar2 default hr_api.g_varchar2,
244 p_per_information13 in varchar2 default hr_api.g_varchar2,
245 p_per_information14 in varchar2 default hr_api.g_varchar2,
246 p_per_information15 in varchar2 default hr_api.g_varchar2,
247 p_per_information16 in varchar2 default hr_api.g_varchar2,
248 p_per_information17 in varchar2 default hr_api.g_varchar2,
249 p_per_information18 in varchar2 default hr_api.g_varchar2,
250 p_per_information19 in varchar2 default hr_api.g_varchar2,
251 p_per_information20 in varchar2 default hr_api.g_varchar2,
252 p_per_information21 in varchar2 default hr_api.g_varchar2,
253 p_per_information22 in varchar2 default hr_api.g_varchar2,
254 p_per_information23 in varchar2 default hr_api.g_varchar2,
255 p_per_information24 in varchar2 default hr_api.g_varchar2,
256 p_per_information25 in varchar2 default hr_api.g_varchar2,
257 p_per_information26 in varchar2 default hr_api.g_varchar2,
258 p_per_information27 in varchar2 default hr_api.g_varchar2,
259 p_per_information28 in varchar2 default hr_api.g_varchar2,
260 p_per_information29 in varchar2 default hr_api.g_varchar2,
261 p_per_information30 in varchar2 default hr_api.g_varchar2,
262 p_date_of_death in date default hr_api.g_date,
263 p_background_check_status in varchar2 default hr_api.g_varchar2,
264 p_background_date_check in date default hr_api.g_date,
265 p_blood_type in varchar2 default hr_api.g_varchar2,
266 p_correspondence_language in varchar2 default hr_api.g_varchar2,
267 p_fast_path_employee in varchar2 default hr_api.g_varchar2,
268 p_fte_capacity in number default hr_api.g_number,
269 p_hold_applicant_date_until in date default hr_api.g_date,
270 p_honors in varchar2 default hr_api.g_varchar2,
271 p_internal_location in varchar2 default hr_api.g_varchar2,
272 p_last_medical_test_by in varchar2 default hr_api.g_varchar2,
273 p_last_medical_test_date in date default hr_api.g_date,
274 p_mailstop in varchar2 default hr_api.g_varchar2,
275 p_office_number in varchar2 default hr_api.g_varchar2,
276 p_on_military_service in varchar2 default hr_api.g_varchar2,
277 p_pre_name_adjunct in varchar2 default hr_api.g_varchar2,
278 p_projected_start_date in date default hr_api.g_date,
279 p_rehire_authorizor in varchar2 default hr_api.g_varchar2,
280 p_rehire_recommendation in varchar2 default hr_api.g_varchar2,
281 p_resume_exists in varchar2 default hr_api.g_varchar2,
282 p_resume_last_updated in date default hr_api.g_date,
283 p_second_passport_exists in varchar2 default hr_api.g_varchar2,
284 p_student_status in varchar2 default hr_api.g_varchar2,
285 p_work_schedule in varchar2 default hr_api.g_varchar2,
286 p_rehire_reason in varchar2 default hr_api.g_varchar2,
287 p_suffix in varchar2 default hr_api.g_varchar2,
288 p_benefit_group_id in number default hr_api.g_number,
289 p_receipt_of_death_cert_date in date default hr_api.g_date,
290 p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2,
291 p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2,
292 p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2,
293 p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2,
294 p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2,
295 p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2,
296 p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date,
297 p_coord_ben_med_cvg_end_dt in date default hr_api.g_date,
298 p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2,
302 p_adjusted_svc_date in date default hr_api.g_date,
299 p_dpdnt_adoption_date in date default hr_api.g_date,
300 p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2,
301 p_original_date_of_hire in date default hr_api.g_date,
303 p_effective_start_date in date default hr_api.g_date,
304 p_effective_end_date in date default hr_api.g_date,
305 p_full_name in varchar2 default hr_api.g_varchar2,
306 p_comment_id in number default hr_api.g_number,
307 p_town_of_birth in varchar2 default hr_api.g_varchar2,
308 p_region_of_birth in varchar2 default hr_api.g_varchar2,
309 p_country_of_birth in varchar2 default hr_api.g_varchar2,
310 p_global_person_id in varchar2 default hr_api.g_varchar2,
311 p_party_id in number default hr_api.g_number,
312 p_npw_number in varchar2 default hr_api.g_varchar2,
313 p_name_combination_warning in boolean default false,
314 p_assign_payroll_warning in boolean default false,
315 p_orig_hire_warning in boolean default false
316 );
317
318
319 procedure create_cwk_business_event(
320 P_START_DATE in DATE
321 ,P_BUSINESS_GROUP_ID in NUMBER
322 ,P_LAST_NAME in VARCHAR2
323 ,P_PERSON_TYPE_ID in NUMBER default hr_api.g_number
324 ,P_NPW_NUMBER in VARCHAR2 default hr_api.g_varchar2
325 ,P_BACKGROUND_CHECK_STATUS in VARCHAR2 default hr_api.g_varchar2
326 ,P_BACKGROUND_DATE_CHECK in DATE
327 ,P_BLOOD_TYPE in VARCHAR2
328 ,P_COMMENTS in VARCHAR2
329 ,P_CORRESPONDENCE_LANGUAGE in VARCHAR2
330 ,P_COUNTRY_OF_BIRTH in VARCHAR2
331 ,P_DATE_OF_BIRTH in DATE
332 ,P_DATE_OF_DEATH in DATE
336 ,P_FIRST_NAME in VARCHAR2
333 ,P_DPDNT_ADOPTION_DATE in DATE
334 ,P_DPDNT_VLNTRY_SVCE_FLAG in VARCHAR2
335 ,P_EMAIL_ADDRESS in VARCHAR2
337 ,P_FTE_CAPACITY in NUMBER
338 ,P_HONORS in VARCHAR2
339 ,P_INTERNAL_LOCATION in VARCHAR2
340 ,P_KNOWN_AS in VARCHAR2
341 ,P_LAST_MEDICAL_TEST_BY in VARCHAR2
342 ,P_LAST_MEDICAL_TEST_DATE in DATE
343 ,P_MAILSTOP in VARCHAR2
344 ,P_MARITAL_STATUS in VARCHAR2
345 ,P_MIDDLE_NAMES in VARCHAR2
346 ,P_NATIONAL_IDENTIFIER in VARCHAR2
347 ,P_NATIONALITY in VARCHAR2
348 ,P_OFFICE_NUMBER in VARCHAR2
349 ,P_ON_MILITARY_SERVICE in VARCHAR2
350 ,P_PARTY_ID in NUMBER
351 ,P_PRE_NAME_ADJUNCT in VARCHAR2
352 ,P_PREVIOUS_LAST_NAME in VARCHAR2
353 ,P_PROJECTED_PLACEMENT_END in DATE
354 ,P_RECEIPT_OF_DEATH_CERT_DATE in DATE
355 ,P_REGION_OF_BIRTH in VARCHAR2
356 ,P_REGISTERED_DISABLED_FLAG in VARCHAR2
357 ,P_RESUME_EXISTS in VARCHAR2
358 ,P_RESUME_LAST_UPDATED in DATE
359 ,P_SECOND_PASSPORT_EXISTS in VARCHAR2
360 ,P_SEX in VARCHAR2
361 ,P_STUDENT_STATUS in VARCHAR2
362 ,P_SUFFIX in VARCHAR2
363 ,P_TITLE in VARCHAR2
364 ,P_TOWN_OF_BIRTH in VARCHAR2
365 ,P_USES_TOBACCO_FLAG in VARCHAR2
366 ,P_VENDOR_ID in NUMBER
367 ,P_WORK_SCHEDULE in VARCHAR2
368 ,P_WORK_TELEPHONE in VARCHAR2
369 ,P_EXP_CHECK_SEND_TO_ADDRESS in VARCHAR2
370 ,P_HOLD_APPLICANT_DATE_UNTIL in DATE
371 ,P_DATE_EMPLOYEE_DATA_VERIFIED in DATE
372 ,P_BENEFIT_GROUP_ID in NUMBER
373 ,P_COORD_BEN_MED_PLN_NO in VARCHAR2
374 ,P_COORD_BEN_NO_CVG_FLAG in VARCHAR2
375 ,P_ORIGINAL_DATE_OF_HIRE in DATE
376 ,P_ATTRIBUTE_CATEGORY in VARCHAR2 default hr_api.g_varchar2
377 ,P_ATTRIBUTE1 in VARCHAR2 default hr_api.g_varchar2
378 ,P_ATTRIBUTE2 in VARCHAR2 default hr_api.g_varchar2
382 ,P_ATTRIBUTE6 in VARCHAR2 default hr_api.g_varchar2
379 ,P_ATTRIBUTE3 in VARCHAR2 default hr_api.g_varchar2
380 ,P_ATTRIBUTE4 in VARCHAR2 default hr_api.g_varchar2
381 ,P_ATTRIBUTE5 in VARCHAR2 default hr_api.g_varchar2
383 ,P_ATTRIBUTE7 in VARCHAR2 default hr_api.g_varchar2
384 ,P_ATTRIBUTE8 in VARCHAR2 default hr_api.g_varchar2
385 ,P_ATTRIBUTE9 in VARCHAR2 default hr_api.g_varchar2
386 ,P_ATTRIBUTE10 in VARCHAR2 default hr_api.g_varchar2
387 ,P_ATTRIBUTE11 in VARCHAR2 default hr_api.g_varchar2
388 ,P_ATTRIBUTE12 in VARCHAR2 default hr_api.g_varchar2
389 ,P_ATTRIBUTE13 in VARCHAR2 default hr_api.g_varchar2
390 ,P_ATTRIBUTE14 in VARCHAR2 default hr_api.g_varchar2
391 ,P_ATTRIBUTE15 in VARCHAR2 default hr_api.g_varchar2
392 ,P_ATTRIBUTE16 in VARCHAR2 default hr_api.g_varchar2
393 ,P_ATTRIBUTE17 in VARCHAR2 default hr_api.g_varchar2
394 ,P_ATTRIBUTE18 in VARCHAR2 default hr_api.g_varchar2
395 ,P_ATTRIBUTE19 in VARCHAR2 default hr_api.g_varchar2
396 ,P_ATTRIBUTE20 in VARCHAR2 default hr_api.g_varchar2
397 ,P_ATTRIBUTE21 in VARCHAR2 default hr_api.g_varchar2
398 ,P_ATTRIBUTE22 in VARCHAR2 default hr_api.g_varchar2
399 ,P_ATTRIBUTE23 in VARCHAR2 default hr_api.g_varchar2
400 ,P_ATTRIBUTE24 in VARCHAR2 default hr_api.g_varchar2
401 ,P_ATTRIBUTE25 in VARCHAR2 default hr_api.g_varchar2
402 ,P_ATTRIBUTE26 in VARCHAR2 default hr_api.g_varchar2
403 ,P_ATTRIBUTE27 in VARCHAR2 default hr_api.g_varchar2
404 ,P_ATTRIBUTE28 in VARCHAR2 default hr_api.g_varchar2
405 ,P_ATTRIBUTE29 in VARCHAR2 default hr_api.g_varchar2
406 ,P_ATTRIBUTE30 in VARCHAR2 default hr_api.g_varchar2
407 ,P_PER_INFORMATION_CATEGORY in VARCHAR2 default hr_api.g_varchar2
408 ,P_PER_INFORMATION1 in VARCHAR2 default hr_api.g_varchar2
409 ,P_PER_INFORMATION2 in VARCHAR2 default hr_api.g_varchar2
410 ,P_PER_INFORMATION3 in VARCHAR2 default hr_api.g_varchar2
411 ,P_PER_INFORMATION4 in VARCHAR2 default hr_api.g_varchar2
412 ,P_PER_INFORMATION5 in VARCHAR2 default hr_api.g_varchar2
413 ,P_PER_INFORMATION6 in VARCHAR2 default hr_api.g_varchar2
414 ,P_PER_INFORMATION7 in VARCHAR2 default hr_api.g_varchar2
415 ,P_PER_INFORMATION8 in VARCHAR2 default hr_api.g_varchar2
416 ,P_PER_INFORMATION9 in VARCHAR2 default hr_api.g_varchar2
417 ,P_PER_INFORMATION10 in VARCHAR2 default hr_api.g_varchar2
418 ,P_PER_INFORMATION11 in VARCHAR2 default hr_api.g_varchar2
419 ,P_PER_INFORMATION12 in VARCHAR2 default hr_api.g_varchar2
420 ,P_PER_INFORMATION13 in VARCHAR2 default hr_api.g_varchar2
424 ,P_PER_INFORMATION17 in VARCHAR2 default hr_api.g_varchar2
421 ,P_PER_INFORMATION14 in VARCHAR2 default hr_api.g_varchar2
422 ,P_PER_INFORMATION15 in VARCHAR2 default hr_api.g_varchar2
423 ,P_PER_INFORMATION16 in VARCHAR2 default hr_api.g_varchar2
425 ,P_PER_INFORMATION18 in VARCHAR2 default hr_api.g_varchar2
429 ,P_PER_INFORMATION22 in VARCHAR2 default hr_api.g_varchar2
426 ,P_PER_INFORMATION19 in VARCHAR2 default hr_api.g_varchar2
427 ,P_PER_INFORMATION20 in VARCHAR2 default hr_api.g_varchar2
428 ,P_PER_INFORMATION21 in VARCHAR2 default hr_api.g_varchar2
430 ,P_PER_INFORMATION23 in VARCHAR2 default hr_api.g_varchar2
431 ,P_PER_INFORMATION24 in VARCHAR2 default hr_api.g_varchar2
432 ,P_PER_INFORMATION25 in VARCHAR2 default hr_api.g_varchar2
433 ,P_PER_INFORMATION26 in VARCHAR2 default hr_api.g_varchar2
434 ,P_PER_INFORMATION27 in VARCHAR2 default hr_api.g_varchar2
435 ,P_PER_INFORMATION28 in VARCHAR2 default hr_api.g_varchar2
436 ,P_PER_INFORMATION29 in VARCHAR2 default hr_api.g_varchar2
437 ,P_PER_INFORMATION30 in VARCHAR2 default hr_api.g_varchar2
438 ,P_PERSON_ID in NUMBER
439 ,P_PER_OBJECT_VERSION_NUMBER in NUMBER
440 ,P_PER_EFFECTIVE_START_DATE in DATE
441 ,P_PER_EFFECTIVE_END_DATE in DATE
442 ,P_PDP_OBJECT_VERSION_NUMBER in NUMBER
443 ,P_FULL_NAME in VARCHAR2
444 ,P_COMMENT_ID in NUMBER
445 ,P_ASSIGNMENT_ID in NUMBER
446 ,P_ASG_OBJECT_VERSION_NUMBER in NUMBER
447 ,P_ASSIGNMENT_SEQUENCE in NUMBER
448 ,P_ASSIGNMENT_NUMBER in VARCHAR2
449 ,P_NAME_COMBINATION_WARNING in BOOLEAN
450 );
451
452
456 ,p_last_name in varchar2
453 procedure create_appl_business_event(
454 p_date_received in date
455 ,p_business_group_id in number
457 ,p_person_type_id in number
458 ,p_applicant_number in varchar2
459 ,p_per_comments in varchar2
460 ,p_date_employee_data_verified in date
461 ,p_date_of_birth in date
462 ,p_email_address in varchar2
463 ,p_expense_check_send_to_addres in varchar2
464 ,p_first_name in varchar2
465 ,p_known_as in varchar2
466 ,p_marital_status in varchar2
467 ,p_middle_names in varchar2
468 ,p_nationality in varchar2
469 ,p_national_identifier in varchar2
470 ,p_previous_last_name in varchar2
471 ,p_registered_disabled_flag in varchar2
472 ,p_sex in varchar2
473 ,p_title in varchar2
474 ,p_work_telephone in varchar2
475 ,p_attribute_category in varchar2
476 ,p_attribute1 in varchar2
477 ,p_attribute2 in varchar2
478 ,p_attribute3 in varchar2
479 ,p_attribute4 in varchar2
480 ,p_attribute5 in varchar2
481 ,p_attribute6 in varchar2
482 ,p_attribute7 in varchar2
483 ,p_attribute8 in varchar2
484 ,p_attribute9 in varchar2
485 ,p_attribute10 in varchar2
486 ,p_attribute11 in varchar2
487 ,p_attribute12 in varchar2
488 ,p_attribute13 in varchar2
489 ,p_attribute14 in varchar2
490 ,p_attribute15 in varchar2
491 ,p_attribute16 in varchar2
492 ,p_attribute17 in varchar2
493 ,p_attribute18 in varchar2
494 ,p_attribute19 in varchar2
495 ,p_attribute20 in varchar2
496 ,p_attribute21 in varchar2
497 ,p_attribute22 in varchar2
498 ,p_attribute23 in varchar2
499 ,p_attribute24 in varchar2
500 ,p_attribute25 in varchar2
501 ,p_attribute26 in varchar2
502 ,p_attribute27 in varchar2
503 ,p_attribute28 in varchar2
504 ,p_attribute29 in varchar2
505 ,p_attribute30 in varchar2
506 ,p_per_information_category in varchar2
507 ,p_per_information1 in varchar2
508 ,p_per_information2 in varchar2
509 ,p_per_information3 in varchar2
510 ,p_per_information4 in varchar2
511 ,p_per_information5 in varchar2
512 ,p_per_information6 in varchar2
513 ,p_per_information7 in varchar2
514 ,p_per_information8 in varchar2
515 ,p_per_information9 in varchar2
516 ,p_per_information10 in varchar2
517 ,p_per_information11 in varchar2
518 ,p_per_information12 in varchar2
519 ,p_per_information13 in varchar2
520 ,p_per_information14 in varchar2
521 ,p_per_information15 in varchar2
522 ,p_per_information16 in varchar2
523 ,p_per_information17 in varchar2
524 ,p_per_information18 in varchar2
525 ,p_per_information19 in varchar2
526 ,p_per_information20 in varchar2
527 ,p_per_information21 in varchar2
528 ,p_per_information22 in varchar2
529 ,p_per_information23 in varchar2
530 ,p_per_information24 in varchar2
531 ,p_per_information25 in varchar2
532 ,p_per_information26 in varchar2
533 ,p_per_information27 in varchar2
534 ,p_per_information28 in varchar2
535 ,p_per_information29 in varchar2
536 ,p_per_information30 in varchar2
537 ,p_background_check_status in varchar2
538 ,p_background_date_check in date
539 ,p_correspondence_language in varchar2
540 ,p_fte_capacity in number
541 ,p_hold_applicant_date_until in date
542 ,p_honors in varchar2
543 ,p_mailstop in varchar2
544 ,p_office_number in varchar2
545 ,p_on_military_service in varchar2
546 ,p_pre_name_adjunct in varchar2
547 ,p_projected_start_date in date
548 ,p_resume_exists in varchar2
549 ,p_resume_last_updated in date
550 ,p_student_status in varchar2
551 ,p_work_schedule in varchar2
552 ,p_suffix in varchar2
553 ,p_date_of_death in date
554 ,p_benefit_group_id in number
555 ,p_receipt_of_death_cert_date in date
556 ,p_coord_ben_med_pln_no in varchar2
557 ,p_coord_ben_no_cvg_flag in varchar2
558 ,p_uses_tobacco_flag in varchar2
559 ,p_dpdnt_adoption_date in date
560 ,p_dpdnt_vlntry_svce_flag in varchar2
561 ,p_original_date_of_hire in date
562 ,p_person_id in number
563 ,p_assignment_id in number
564 ,p_application_id in number
565 ,p_per_object_version_number in number
569 ,p_per_effective_end_date in date
566 ,p_asg_object_version_number in number
567 ,p_apl_object_version_number in number
568 ,p_per_effective_start_date in date
570 ,p_full_name in varchar2
571 ,p_per_comment_id in number
572 ,p_assignment_sequence in number
573 ,p_name_combination_warning in boolean
574 ,p_orig_hire_warning in boolean
575 ,p_town_of_birth in varchar2
576 ,p_region_of_birth in varchar2
577 ,p_country_of_birth in varchar2
578 ,p_global_person_id in varchar2
579 ,p_party_id in varchar2
580 ,p_vacancy_id in number
581 );
582
583
584 procedure create_emp_business_event(
585 p_hire_date in date
586 ,p_business_group_id in number
587 ,p_last_name in varchar2
588 ,p_sex in varchar2
589 ,p_person_type_id in number
590 ,p_per_comments in varchar2
591 ,p_date_employee_data_verified in date
592 ,p_date_of_birth in date
593 ,p_email_address in varchar2
594 ,p_employee_number in varchar2
595 ,p_expense_check_send_to_addres in varchar2
596 ,p_first_name in varchar2
597 ,p_known_as in varchar2
598 ,p_marital_status in varchar2
599 ,p_middle_names in varchar2
600 ,p_nationality in varchar2
601 ,p_national_identifier in varchar2
602 ,p_previous_last_name in varchar2
603 ,p_registered_disabled_flag in varchar2
604 ,p_title in varchar2
605 ,p_vendor_id in number
606 ,p_work_telephone in varchar2
607 ,p_attribute_category in varchar2
608 ,p_attribute1 in varchar2
609 ,p_attribute2 in varchar2
610 ,p_attribute3 in varchar2
611 ,p_attribute4 in varchar2
612 ,p_attribute5 in varchar2
613 ,p_attribute6 in varchar2
614 ,p_attribute7 in varchar2
615 ,p_attribute8 in varchar2
616 ,p_attribute9 in varchar2
617 ,p_attribute10 in varchar2
618 ,p_attribute11 in varchar2
619 ,p_attribute12 in varchar2
620 ,p_attribute13 in varchar2
621 ,p_attribute14 in varchar2
622 ,p_attribute15 in varchar2
623 ,p_attribute16 in varchar2
624 ,p_attribute17 in varchar2
625 ,p_attribute18 in varchar2
626 ,p_attribute19 in varchar2
627 ,p_attribute20 in varchar2
628 ,p_attribute21 in varchar2
629 ,p_attribute22 in varchar2
630 ,p_attribute23 in varchar2
631 ,p_attribute24 in varchar2
632 ,p_attribute25 in varchar2
633 ,p_attribute26 in varchar2
634 ,p_attribute27 in varchar2
635 ,p_attribute28 in varchar2
636 ,p_attribute29 in varchar2
637 ,p_attribute30 in varchar2
638 ,p_per_information_category in varchar2
639 ,p_per_information1 in varchar2
640 ,p_per_information2 in varchar2
641 ,p_per_information3 in varchar2
642 ,p_per_information4 in varchar2
643 ,p_per_information5 in varchar2
644 ,p_per_information6 in varchar2
645 ,p_per_information7 in varchar2
646 ,p_per_information8 in varchar2
647 ,p_per_information9 in varchar2
648 ,p_per_information10 in varchar2
649 ,p_per_information11 in varchar2
650 ,p_per_information12 in varchar2
651 ,p_per_information13 in varchar2
652 ,p_per_information14 in varchar2
653 ,p_per_information15 in varchar2
654 ,p_per_information16 in varchar2
655 ,p_per_information17 in varchar2
656 ,p_per_information18 in varchar2
657 ,p_per_information19 in varchar2
658 ,p_per_information20 in varchar2
659 ,p_per_information21 in varchar2
660 ,p_per_information22 in varchar2
661 ,p_per_information23 in varchar2
662 ,p_per_information24 in varchar2
663 ,p_per_information25 in varchar2
664 ,p_per_information26 in varchar2
665 ,p_per_information27 in varchar2
666 ,p_per_information28 in varchar2
667 ,p_per_information29 in varchar2
668 ,p_per_information30 in varchar2
669 ,p_date_of_death in date
670 ,p_background_check_status in varchar2
671 ,p_background_date_check in date
672 ,p_blood_type in varchar2
673 ,p_correspondence_language in varchar2
674 ,p_fast_path_employee in varchar2
675 ,p_fte_capacity in number
676 ,p_honors in varchar2
677 ,p_internal_location in varchar2
678 ,p_last_medical_test_by in varchar2
679 ,p_last_medical_test_date in date
680 ,p_mailstop in varchar2
681 ,p_office_number in varchar2
682 ,p_on_military_service in varchar2
683 ,p_pre_name_adjunct in varchar2
684 ,p_rehire_recommendation in varchar2 -- Bug 3210500
685 ,p_projected_start_date in date
686 ,p_resume_exists in varchar2
687 ,p_resume_last_updated in date
688 ,p_second_passport_exists in varchar2
689 ,p_student_status in varchar2
690 ,p_work_schedule in varchar2
691 ,p_suffix in varchar2
692 ,p_benefit_group_id in number
693 ,p_receipt_of_death_cert_date in date
694 ,p_coord_ben_med_pln_no in varchar2
695 ,p_coord_ben_no_cvg_flag in varchar2
696 ,p_coord_ben_med_ext_er in varchar2
697 ,p_coord_ben_med_pl_name in varchar2
698 ,p_coord_ben_med_insr_crr_name in varchar2
699 ,p_coord_ben_med_insr_crr_ident in varchar2
700 ,p_coord_ben_med_cvg_strt_dt in date
701 ,p_coord_ben_med_cvg_end_dt in date
702 ,p_uses_tobacco_flag in varchar2
703 ,p_dpdnt_adoption_date in date
704 ,p_dpdnt_vlntry_svce_flag in varchar2
705 ,p_original_date_of_hire in date
706 ,p_adjusted_svc_date in date
707 ,p_person_id in number
708 ,p_assignment_id in number
709 ,p_per_object_version_number in number
710 ,p_asg_object_version_number in number
711 ,p_per_effective_start_date in date
712 ,p_per_effective_end_date in date
713 ,p_full_name in varchar2
714 ,p_per_comment_id in number
715 ,p_assignment_sequence in number
716 ,p_assignment_number in varchar2
717 ,p_town_of_birth in varchar2
718 ,p_region_of_birth in varchar2
719 ,p_country_of_birth in varchar2
720 ,p_global_person_id in varchar2
721 ,p_party_id in number
722 ,p_name_combination_warning in boolean
723 ,p_assign_payroll_warning in boolean
724 ,p_orig_hire_warning in boolean
725 );
726
727 end HR_PERSON_BUSINESS_EVENT;
[Home] [Help]