[Home] [Help]
PACKAGE BODY: APPS.HR_PERSON_BUSINESS_EVENT
Source
1 Package Body HR_PERSON_BUSINESS_EVENT as
2 /* $Header: peperbev.pkb 120.1.12010000.2 2008/08/27 14:59:58 srgnanas ship $ */
3
4 procedure person_business_event(
5 p_event in varchar2,
6 p_datetrack_update_mode in varchar2 default hr_api.g_update,
7 p_system_person_type in varchar2,
8 p_effective_date in date,
9 p_person_id in number,
10 p_object_version_number in number,
11 p_person_type_id in number default hr_api.g_number,
12 p_last_name in varchar2 default hr_api.g_varchar2,
13 p_applicant_number in varchar2 default hr_api.g_varchar2,
14 p_comments in varchar2 default hr_api.g_varchar2,
15 p_date_employee_data_verified in date default hr_api.g_date,
16 p_date_of_birth in date default hr_api.g_date,
17 p_email_address in varchar2 default hr_api.g_varchar2,
18 p_employee_number in varchar2 default hr_api.g_varchar2,
19 p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2,
20 p_first_name in varchar2 default hr_api.g_varchar2,
21 p_known_as in varchar2 default hr_api.g_varchar2,
22 p_marital_status in varchar2 default hr_api.g_varchar2,
23 p_middle_names in varchar2 default hr_api.g_varchar2,
24 p_nationality in varchar2 default hr_api.g_varchar2,
25 p_national_identifier in varchar2 default hr_api.g_varchar2,
26 p_previous_last_name in varchar2 default hr_api.g_varchar2,
27 p_registered_disabled_flag in varchar2 default hr_api.g_varchar2,
28 p_sex in varchar2 default hr_api.g_varchar2,
29 p_title in varchar2 default hr_api.g_varchar2,
30 p_vendor_id in number default hr_api.g_number,
31 p_attribute_category in varchar2 default hr_api.g_varchar2,
32 p_attribute1 in varchar2 default hr_api.g_varchar2,
33 p_attribute2 in varchar2 default hr_api.g_varchar2,
34 p_attribute3 in varchar2 default hr_api.g_varchar2,
35 p_attribute4 in varchar2 default hr_api.g_varchar2,
36 p_attribute5 in varchar2 default hr_api.g_varchar2,
37 p_attribute6 in varchar2 default hr_api.g_varchar2,
38 p_attribute7 in varchar2 default hr_api.g_varchar2,
39 p_attribute8 in varchar2 default hr_api.g_varchar2,
40 p_attribute9 in varchar2 default hr_api.g_varchar2,
41 p_attribute10 in varchar2 default hr_api.g_varchar2,
42 p_attribute11 in varchar2 default hr_api.g_varchar2,
43 p_attribute12 in varchar2 default hr_api.g_varchar2,
44 p_attribute13 in varchar2 default hr_api.g_varchar2,
45 p_attribute14 in varchar2 default hr_api.g_varchar2,
46 p_attribute15 in varchar2 default hr_api.g_varchar2,
47 p_attribute16 in varchar2 default hr_api.g_varchar2,
48 p_attribute17 in varchar2 default hr_api.g_varchar2,
49 p_attribute18 in varchar2 default hr_api.g_varchar2,
50 p_attribute19 in varchar2 default hr_api.g_varchar2,
51 p_attribute20 in varchar2 default hr_api.g_varchar2,
52 p_attribute21 in varchar2 default hr_api.g_varchar2,
53 p_attribute22 in varchar2 default hr_api.g_varchar2,
54 p_attribute23 in varchar2 default hr_api.g_varchar2,
55 p_attribute24 in varchar2 default hr_api.g_varchar2,
56 p_attribute25 in varchar2 default hr_api.g_varchar2,
57 p_attribute26 in varchar2 default hr_api.g_varchar2,
58 p_attribute27 in varchar2 default hr_api.g_varchar2,
59 p_attribute28 in varchar2 default hr_api.g_varchar2,
60 p_attribute29 in varchar2 default hr_api.g_varchar2,
61 p_attribute30 in varchar2 default hr_api.g_varchar2,
62 p_per_information_category in varchar2 default hr_api.g_varchar2,
63 p_per_information1 in varchar2 default hr_api.g_varchar2,
64 p_per_information2 in varchar2 default hr_api.g_varchar2,
65 p_per_information3 in varchar2 default hr_api.g_varchar2,
66 p_per_information4 in varchar2 default hr_api.g_varchar2,
67 p_per_information5 in varchar2 default hr_api.g_varchar2,
68 p_per_information6 in varchar2 default hr_api.g_varchar2,
69 p_per_information7 in varchar2 default hr_api.g_varchar2,
70 p_per_information8 in varchar2 default hr_api.g_varchar2,
71 p_per_information9 in varchar2 default hr_api.g_varchar2,
72 p_per_information10 in varchar2 default hr_api.g_varchar2,
73 p_per_information11 in varchar2 default hr_api.g_varchar2,
74 p_per_information12 in varchar2 default hr_api.g_varchar2,
75 p_per_information13 in varchar2 default hr_api.g_varchar2,
76 p_per_information14 in varchar2 default hr_api.g_varchar2,
77 p_per_information15 in varchar2 default hr_api.g_varchar2,
78 p_per_information16 in varchar2 default hr_api.g_varchar2,
79 p_per_information17 in varchar2 default hr_api.g_varchar2,
80 p_per_information18 in varchar2 default hr_api.g_varchar2,
81 p_per_information19 in varchar2 default hr_api.g_varchar2,
82 p_per_information20 in varchar2 default hr_api.g_varchar2,
83 p_per_information21 in varchar2 default hr_api.g_varchar2,
84 p_per_information22 in varchar2 default hr_api.g_varchar2,
85 p_per_information23 in varchar2 default hr_api.g_varchar2,
86 p_per_information24 in varchar2 default hr_api.g_varchar2,
87 p_per_information25 in varchar2 default hr_api.g_varchar2,
88 p_per_information26 in varchar2 default hr_api.g_varchar2,
89 p_per_information27 in varchar2 default hr_api.g_varchar2,
90 p_per_information28 in varchar2 default hr_api.g_varchar2,
91 p_per_information29 in varchar2 default hr_api.g_varchar2,
92 p_per_information30 in varchar2 default hr_api.g_varchar2,
93 p_date_of_death in date default hr_api.g_date,
94 p_background_check_status in varchar2 default hr_api.g_varchar2,
95 p_background_date_check in date default hr_api.g_date,
96 p_blood_type in varchar2 default hr_api.g_varchar2,
97 p_correspondence_language in varchar2 default hr_api.g_varchar2,
98 p_fast_path_employee in varchar2 default hr_api.g_varchar2,
99 p_fte_capacity in number default hr_api.g_number,
100 p_hold_applicant_date_until in date default hr_api.g_date,
101 p_honors in varchar2 default hr_api.g_varchar2,
102 p_internal_location in varchar2 default hr_api.g_varchar2,
103 p_last_medical_test_by in varchar2 default hr_api.g_varchar2,
104 p_last_medical_test_date in date default hr_api.g_date,
105 p_mailstop in varchar2 default hr_api.g_varchar2,
106 p_office_number in varchar2 default hr_api.g_varchar2,
107 p_on_military_service in varchar2 default hr_api.g_varchar2,
108 p_pre_name_adjunct in varchar2 default hr_api.g_varchar2,
109 p_projected_start_date in date default hr_api.g_date,
110 p_rehire_authorizor in varchar2 default hr_api.g_varchar2,
111 p_rehire_recommendation in varchar2 default hr_api.g_varchar2,
112 p_resume_exists in varchar2 default hr_api.g_varchar2,
113 p_resume_last_updated in date default hr_api.g_date,
114 p_second_passport_exists in varchar2 default hr_api.g_varchar2,
115 p_student_status in varchar2 default hr_api.g_varchar2,
116 p_work_schedule in varchar2 default hr_api.g_varchar2,
117 p_rehire_reason in varchar2 default hr_api.g_varchar2,
118 p_suffix in varchar2 default hr_api.g_varchar2,
119 p_benefit_group_id in number default hr_api.g_number,
120 p_receipt_of_death_cert_date in date default hr_api.g_date,
121 p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2,
122 p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2,
123 p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2,
124 p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2,
125 p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2,
126 p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2,
127 p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date,
128 p_coord_ben_med_cvg_end_dt in date default hr_api.g_date,
129 p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2,
130 p_dpdnt_adoption_date in date default hr_api.g_date,
131 p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2,
132 p_original_date_of_hire in date default hr_api.g_date,
133 p_adjusted_svc_date in date default hr_api.g_date,
134 p_effective_start_date in date default hr_api.g_date,
135 p_effective_end_date in date default hr_api.g_date,
136 p_full_name in varchar2 default hr_api.g_varchar2,
137 p_comment_id in number default hr_api.g_number,
138 p_town_of_birth in varchar2 default hr_api.g_varchar2,
139 p_region_of_birth in varchar2 default hr_api.g_varchar2,
140 p_country_of_birth in varchar2 default hr_api.g_varchar2,
141 p_global_person_id in varchar2 default hr_api.g_varchar2,
142 p_party_id in number default hr_api.g_number,
143 p_npw_number in varchar2 default hr_api.g_varchar2,
144 p_name_combination_warning in boolean default false,
145 p_assign_payroll_warning in boolean default false,
146 p_orig_hire_warning in boolean default false
147 )
148 is
149
150 l_proc varchar2(72) := 'raise_person_business_event';
151
152 begin
153 hr_utility.set_location('Entering: raise_person_business_event:'|| l_proc, 10);
154 if p_event = 'UPDATE' then
155 hr_utility.set_location('Entering: p_event=UPDATE:'|| l_proc, 20);
156 hr_person_be1.update_person_a(
157 p_effective_date => p_effective_date
158 ,p_person_id => p_person_id
159 ,p_person_type_id => p_person_type_id
160 ,p_last_name => p_last_name
161 ,p_comments => p_comments
162 ,p_date_employee_data_verified => p_date_employee_data_verified
163 ,p_date_of_birth => p_date_of_birth
164 ,p_email_address => p_email_address
165 ,p_applicant_number => p_applicant_number
166 ,p_expense_check_send_to_addres => p_expense_check_send_to_addres
167 ,p_first_name => p_first_name
168 ,p_known_as => p_known_as
169 ,p_marital_status => p_marital_status
170 ,p_middle_names => p_middle_names
171 ,p_nationality => p_nationality
172 ,p_national_identifier => p_national_identifier
173 ,p_previous_last_name => p_previous_last_name
174 ,p_datetrack_update_mode => p_datetrack_update_mode
175 ,p_registered_disabled_flag => p_registered_disabled_flag
176 ,p_npw_number => p_npw_number
177 ,p_sex => p_sex
178 ,p_title => p_title
179 ,p_vendor_id => p_vendor_id
180 ,p_attribute_category => p_attribute_category
181 ,p_attribute1 => p_attribute1
182 ,p_attribute2 => p_attribute2
183 ,p_attribute3 => p_attribute3
184 ,p_attribute4 => p_attribute4
185 ,p_attribute5 => p_attribute5
186 ,p_attribute6 => p_attribute6
187 ,p_attribute7 => p_attribute7
188 ,p_attribute8 => p_attribute8
189 ,p_attribute9 => p_attribute9
190 ,p_attribute10 => p_attribute10
191 ,p_attribute11 => p_attribute11
192 ,p_attribute12 => p_attribute12
193 ,p_attribute13 => p_attribute13
194 ,p_attribute14 => p_attribute14
195 ,p_attribute15 => p_attribute15
196 ,p_attribute16 => p_attribute16
197 ,p_attribute17 => p_attribute17
198 ,p_attribute18 => p_attribute18
199 ,p_attribute19 => p_attribute19
200 ,p_attribute20 => p_attribute20
201 ,p_attribute21 => p_attribute21
202 ,p_attribute22 => p_attribute22
203 ,p_attribute23 => p_attribute23
204 ,p_attribute24 => p_attribute24
205 ,p_attribute25 => p_attribute25
206 ,p_attribute26 => p_attribute26
207 ,p_attribute27 => p_attribute27
208 ,p_attribute28 => p_attribute28
209 ,p_attribute29 => p_attribute29
210 ,p_attribute30 => p_attribute30
211 ,p_per_information_category => p_per_information_category
212 ,p_per_information1 => p_per_information1
213 ,p_per_information2 => p_per_information2
214 ,p_per_information3 => p_per_information3
215 ,p_per_information4 => p_per_information4
216 ,p_per_information5 => p_per_information5
217 ,p_per_information6 => p_per_information6
218 ,p_per_information7 => p_per_information7
219 ,p_per_information8 => p_per_information8
220 ,p_per_information9 => p_per_information9
221 ,p_per_information10 => p_per_information10
222 ,p_per_information11 => p_per_information11
223 ,p_per_information12 => p_per_information12
224 ,p_per_information13 => p_per_information13
225 ,p_per_information14 => p_per_information14
226 ,p_per_information15 => p_per_information15
227 ,p_per_information16 => p_per_information16
228 ,p_per_information17 => p_per_information17
229 ,p_per_information18 => p_per_information18
230 ,p_per_information19 => p_per_information19
231 ,p_per_information20 => p_per_information20
232 ,p_per_information21 => p_per_information21
233 ,p_per_information22 => p_per_information22
234 ,p_per_information23 => p_per_information23
235 ,p_per_information24 => p_per_information24
236 ,p_per_information25 => p_per_information25
237 ,p_per_information26 => p_per_information26
238 ,p_per_information27 => p_per_information27
239 ,p_per_information28 => p_per_information28
240 ,p_per_information29 => p_per_information29
241 ,p_per_information30 => p_per_information30
242 ,p_date_of_death => p_date_of_death
243 ,p_background_check_status => p_background_check_status
244 ,p_background_date_check => p_background_date_check
245 ,p_blood_type => p_blood_type
246 ,p_correspondence_language => p_correspondence_language
247 ,p_fast_path_employee => p_fast_path_employee
248 ,p_fte_capacity => p_fte_capacity
249 ,p_honors => p_honors
250 ,p_internal_location => p_internal_location
251 ,p_last_medical_test_by => p_last_medical_test_by
252 ,p_last_medical_test_date => p_last_medical_test_date
253 ,p_adjusted_svc_date => p_adjusted_svc_date
254 ,p_mailstop => p_mailstop
255 ,p_office_number => p_office_number
256 ,p_on_military_service => p_on_military_service
257 ,p_pre_name_adjunct => p_pre_name_adjunct
258 ,p_projected_start_date => p_projected_start_date
259 ,p_rehire_recommendation => p_rehire_recommendation
260 ,p_resume_exists => p_resume_exists
261 ,p_resume_last_updated => p_resume_last_updated
262 ,p_second_passport_exists => p_second_passport_exists
263 ,p_student_status => p_student_status
264 ,p_work_schedule => p_work_schedule
265 ,p_suffix => p_suffix
266 ,p_benefit_group_id => p_benefit_group_id
267 ,p_receipt_of_death_cert_date => p_receipt_of_death_cert_date
268 ,p_coord_ben_med_pln_no => p_coord_ben_med_pln_no
269 ,p_coord_ben_no_cvg_flag => p_coord_ben_no_cvg_flag
270 ,p_coord_ben_med_ext_er => p_coord_ben_med_ext_er
271 ,p_coord_ben_med_pl_name => p_coord_ben_med_pl_name
272 ,p_coord_ben_med_insr_crr_name => p_coord_ben_med_insr_crr_name
273 ,p_coord_ben_med_insr_crr_ident => p_coord_ben_med_insr_crr_ident
274 ,p_coord_ben_med_cvg_strt_dt => p_coord_ben_med_cvg_strt_dt
275 ,p_coord_ben_med_cvg_end_dt => p_coord_ben_med_cvg_end_dt
276 ,p_uses_tobacco_flag => p_uses_tobacco_flag
277 ,p_dpdnt_adoption_date => p_dpdnt_adoption_date
278 ,p_dpdnt_vlntry_svce_flag => p_dpdnt_vlntry_svce_flag
279 ,p_original_date_of_hire => p_original_date_of_hire
280 ,p_rehire_reason => p_rehire_reason
281 ,p_rehire_authorizor => p_rehire_authorizor
282 ,p_town_of_birth => p_town_of_birth
283 ,p_region_of_birth => p_region_of_birth
284 ,p_country_of_birth => p_country_of_birth
285 ,p_global_person_id => p_global_person_id
286 ,p_party_id => p_party_id
287 ,p_employee_number => p_employee_number
288 ,p_hold_applicant_date_until => p_hold_applicant_date_until
289 ,p_effective_start_date => p_effective_start_date
290 ,p_effective_end_date => p_effective_end_date
291 ,p_comment_id => p_comment_id
292 ,p_full_name => p_full_name
293 ,p_object_version_number => p_object_version_number
294 ,p_name_combination_warning => p_name_combination_warning
295 ,p_assign_payroll_warning => p_assign_payroll_warning
296 ,p_orig_hire_warning => p_orig_hire_warning
297 );
298 hr_utility.set_location('Leaving: p_event=UPDATE:'|| l_proc, 30);
299
300 end if;
301 hr_utility.set_location('Leaving:'|| l_proc, 40);
302 end person_business_event;
303
304
305 procedure create_cwk_business_event(
306 P_START_DATE in DATE
307 ,P_BUSINESS_GROUP_ID in NUMBER
308 ,P_LAST_NAME in VARCHAR2
309 ,P_PERSON_TYPE_ID in NUMBER default hr_api.g_number
310 ,P_NPW_NUMBER in VARCHAR2 default hr_api.g_varchar2
311 ,P_BACKGROUND_CHECK_STATUS in VARCHAR2 default hr_api.g_varchar2
312 ,P_BACKGROUND_DATE_CHECK in DATE
313 ,P_BLOOD_TYPE in VARCHAR2
314 ,P_COMMENTS in VARCHAR2
315 ,P_CORRESPONDENCE_LANGUAGE in VARCHAR2
316 ,P_COUNTRY_OF_BIRTH in VARCHAR2
317 ,P_DATE_OF_BIRTH in DATE
318 ,P_DATE_OF_DEATH in DATE
319 ,P_DPDNT_ADOPTION_DATE in DATE
320 ,P_DPDNT_VLNTRY_SVCE_FLAG in VARCHAR2
321 ,P_EMAIL_ADDRESS in VARCHAR2
322 ,P_FIRST_NAME in VARCHAR2
323 ,P_FTE_CAPACITY in NUMBER
324 ,P_HONORS in VARCHAR2
325 ,P_INTERNAL_LOCATION in VARCHAR2
326 ,P_KNOWN_AS in VARCHAR2
327 ,P_LAST_MEDICAL_TEST_BY in VARCHAR2
328 ,P_LAST_MEDICAL_TEST_DATE in DATE
329 ,P_MAILSTOP in VARCHAR2
330 ,P_MARITAL_STATUS in VARCHAR2
331 ,P_MIDDLE_NAMES in VARCHAR2
332 ,P_NATIONAL_IDENTIFIER in VARCHAR2
333 ,P_NATIONALITY in VARCHAR2
334 ,P_OFFICE_NUMBER in VARCHAR2
335 ,P_ON_MILITARY_SERVICE in VARCHAR2
336 ,P_PARTY_ID in NUMBER
337 ,P_PRE_NAME_ADJUNCT in VARCHAR2
338 ,P_PREVIOUS_LAST_NAME in VARCHAR2
339 ,P_PROJECTED_PLACEMENT_END in DATE
340 ,P_RECEIPT_OF_DEATH_CERT_DATE in DATE
341 ,P_REGION_OF_BIRTH in VARCHAR2
342 ,P_REGISTERED_DISABLED_FLAG in VARCHAR2
343 ,P_RESUME_EXISTS in VARCHAR2
344 ,P_RESUME_LAST_UPDATED in DATE
345 ,P_SECOND_PASSPORT_EXISTS in VARCHAR2
346 ,P_SEX in VARCHAR2
347 ,P_STUDENT_STATUS in VARCHAR2
348 ,P_SUFFIX in VARCHAR2
349 ,P_TITLE in VARCHAR2
350 ,P_TOWN_OF_BIRTH in VARCHAR2
351 ,P_USES_TOBACCO_FLAG in VARCHAR2
352 ,P_VENDOR_ID in NUMBER
353 ,P_WORK_SCHEDULE in VARCHAR2
354 ,P_WORK_TELEPHONE in VARCHAR2
355 ,P_EXP_CHECK_SEND_TO_ADDRESS in VARCHAR2
356 ,P_HOLD_APPLICANT_DATE_UNTIL in DATE
357 ,P_DATE_EMPLOYEE_DATA_VERIFIED in DATE
358 ,P_BENEFIT_GROUP_ID in NUMBER
359 ,P_COORD_BEN_MED_PLN_NO in VARCHAR2
360 ,P_COORD_BEN_NO_CVG_FLAG in VARCHAR2
361 ,P_ORIGINAL_DATE_OF_HIRE in DATE
362 ,P_ATTRIBUTE_CATEGORY in VARCHAR2 default hr_api.g_varchar2
363 ,P_ATTRIBUTE1 in VARCHAR2 default hr_api.g_varchar2
364 ,P_ATTRIBUTE2 in VARCHAR2 default hr_api.g_varchar2
365 ,P_ATTRIBUTE3 in VARCHAR2 default hr_api.g_varchar2
366 ,P_ATTRIBUTE4 in VARCHAR2 default hr_api.g_varchar2
367 ,P_ATTRIBUTE5 in VARCHAR2 default hr_api.g_varchar2
368 ,P_ATTRIBUTE6 in VARCHAR2 default hr_api.g_varchar2
369 ,P_ATTRIBUTE7 in VARCHAR2 default hr_api.g_varchar2
370 ,P_ATTRIBUTE8 in VARCHAR2 default hr_api.g_varchar2
371 ,P_ATTRIBUTE9 in VARCHAR2 default hr_api.g_varchar2
372 ,P_ATTRIBUTE10 in VARCHAR2 default hr_api.g_varchar2
373 ,P_ATTRIBUTE11 in VARCHAR2 default hr_api.g_varchar2
374 ,P_ATTRIBUTE12 in VARCHAR2 default hr_api.g_varchar2
375 ,P_ATTRIBUTE13 in VARCHAR2 default hr_api.g_varchar2
376 ,P_ATTRIBUTE14 in VARCHAR2 default hr_api.g_varchar2
377 ,P_ATTRIBUTE15 in VARCHAR2 default hr_api.g_varchar2
378 ,P_ATTRIBUTE16 in VARCHAR2 default hr_api.g_varchar2
379 ,P_ATTRIBUTE17 in VARCHAR2 default hr_api.g_varchar2
380 ,P_ATTRIBUTE18 in VARCHAR2 default hr_api.g_varchar2
381 ,P_ATTRIBUTE19 in VARCHAR2 default hr_api.g_varchar2
382 ,P_ATTRIBUTE20 in VARCHAR2 default hr_api.g_varchar2
383 ,P_ATTRIBUTE21 in VARCHAR2 default hr_api.g_varchar2
384 ,P_ATTRIBUTE22 in VARCHAR2 default hr_api.g_varchar2
385 ,P_ATTRIBUTE23 in VARCHAR2 default hr_api.g_varchar2
386 ,P_ATTRIBUTE24 in VARCHAR2 default hr_api.g_varchar2
387 ,P_ATTRIBUTE25 in VARCHAR2 default hr_api.g_varchar2
388 ,P_ATTRIBUTE26 in VARCHAR2 default hr_api.g_varchar2
389 ,P_ATTRIBUTE27 in VARCHAR2 default hr_api.g_varchar2
390 ,P_ATTRIBUTE28 in VARCHAR2 default hr_api.g_varchar2
391 ,P_ATTRIBUTE29 in VARCHAR2 default hr_api.g_varchar2
392 ,P_ATTRIBUTE30 in VARCHAR2 default hr_api.g_varchar2
393 ,P_PER_INFORMATION_CATEGORY in VARCHAR2 default hr_api.g_varchar2
394 ,P_PER_INFORMATION1 in VARCHAR2 default hr_api.g_varchar2
395 ,P_PER_INFORMATION2 in VARCHAR2 default hr_api.g_varchar2
396 ,P_PER_INFORMATION3 in VARCHAR2 default hr_api.g_varchar2
397 ,P_PER_INFORMATION4 in VARCHAR2 default hr_api.g_varchar2
398 ,P_PER_INFORMATION5 in VARCHAR2 default hr_api.g_varchar2
399 ,P_PER_INFORMATION6 in VARCHAR2 default hr_api.g_varchar2
400 ,P_PER_INFORMATION7 in VARCHAR2 default hr_api.g_varchar2
401 ,P_PER_INFORMATION8 in VARCHAR2 default hr_api.g_varchar2
402 ,P_PER_INFORMATION9 in VARCHAR2 default hr_api.g_varchar2
403 ,P_PER_INFORMATION10 in VARCHAR2 default hr_api.g_varchar2
404 ,P_PER_INFORMATION11 in VARCHAR2 default hr_api.g_varchar2
405 ,P_PER_INFORMATION12 in VARCHAR2 default hr_api.g_varchar2
406 ,P_PER_INFORMATION13 in VARCHAR2 default hr_api.g_varchar2
407 ,P_PER_INFORMATION14 in VARCHAR2 default hr_api.g_varchar2
408 ,P_PER_INFORMATION15 in VARCHAR2 default hr_api.g_varchar2
409 ,P_PER_INFORMATION16 in VARCHAR2 default hr_api.g_varchar2
410 ,P_PER_INFORMATION17 in VARCHAR2 default hr_api.g_varchar2
411 ,P_PER_INFORMATION18 in VARCHAR2 default hr_api.g_varchar2
412 ,P_PER_INFORMATION19 in VARCHAR2 default hr_api.g_varchar2
413 ,P_PER_INFORMATION20 in VARCHAR2 default hr_api.g_varchar2
414 ,P_PER_INFORMATION21 in VARCHAR2 default hr_api.g_varchar2
415 ,P_PER_INFORMATION22 in VARCHAR2 default hr_api.g_varchar2
416 ,P_PER_INFORMATION23 in VARCHAR2 default hr_api.g_varchar2
417 ,P_PER_INFORMATION24 in VARCHAR2 default hr_api.g_varchar2
418 ,P_PER_INFORMATION25 in VARCHAR2 default hr_api.g_varchar2
419 ,P_PER_INFORMATION26 in VARCHAR2 default hr_api.g_varchar2
420 ,P_PER_INFORMATION27 in VARCHAR2 default hr_api.g_varchar2
421 ,P_PER_INFORMATION28 in VARCHAR2 default hr_api.g_varchar2
422 ,P_PER_INFORMATION29 in VARCHAR2 default hr_api.g_varchar2
423 ,P_PER_INFORMATION30 in VARCHAR2 default hr_api.g_varchar2
424 ,P_PERSON_ID in NUMBER
425 ,P_PER_OBJECT_VERSION_NUMBER in NUMBER
426 ,P_PER_EFFECTIVE_START_DATE in DATE
427 ,P_PER_EFFECTIVE_END_DATE in DATE
428 ,P_PDP_OBJECT_VERSION_NUMBER in NUMBER
429 ,P_FULL_NAME in VARCHAR2
430 ,P_COMMENT_ID in NUMBER
431 ,P_ASSIGNMENT_ID in NUMBER
432 ,P_ASG_OBJECT_VERSION_NUMBER in NUMBER
433 ,P_ASSIGNMENT_SEQUENCE in NUMBER
434 ,P_ASSIGNMENT_NUMBER in VARCHAR2
435 ,P_NAME_COMBINATION_WARNING in BOOLEAN
436 )
437 is
438 l_proc varchar2(72) := 'raise_create_cwk_business_event';
439
440 begin
441 hr_utility.set_location('Entering: '|| l_proc, 20);
442 HR_CONTINGENT_WORKER_BE1.CREATE_CWK_A
443 (
444 P_START_DATE => P_START_DATE
445 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
446 ,P_LAST_NAME => P_LAST_NAME
447 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
448 ,P_NPW_NUMBER => P_NPW_NUMBER
449 ,P_BACKGROUND_CHECK_STATUS => P_BACKGROUND_CHECK_STATUS
450 ,P_BACKGROUND_DATE_CHECK => P_BACKGROUND_DATE_CHECK
451 ,P_BLOOD_TYPE => P_BLOOD_TYPE
452 ,P_COMMENTS => P_COMMENTS
453 ,P_CORRESPONDENCE_LANGUAGE => P_CORRESPONDENCE_LANGUAGE
454 ,P_COUNTRY_OF_BIRTH => P_COUNTRY_OF_BIRTH
455 ,P_DATE_OF_BIRTH => P_DATE_OF_BIRTH
456 ,P_DATE_OF_DEATH => P_DATE_OF_DEATH
457 ,P_DPDNT_ADOPTION_DATE => P_DPDNT_ADOPTION_DATE
458 ,P_DPDNT_VLNTRY_SVCE_FLAG => P_DPDNT_VLNTRY_SVCE_FLAG
459 ,P_EMAIL_ADDRESS => P_EMAIL_ADDRESS
460 ,P_FIRST_NAME => P_FIRST_NAME
461 ,P_FTE_CAPACITY => P_FTE_CAPACITY
462 ,P_HONORS => P_HONORS
463 ,P_INTERNAL_LOCATION => P_INTERNAL_LOCATION
464 ,P_KNOWN_AS => P_KNOWN_AS
465 ,P_LAST_MEDICAL_TEST_BY => P_LAST_MEDICAL_TEST_BY
466 ,P_LAST_MEDICAL_TEST_DATE => P_LAST_MEDICAL_TEST_DATE
467 ,P_MAILSTOP => P_MAILSTOP
468 ,P_MARITAL_STATUS => P_MARITAL_STATUS
469 ,P_MIDDLE_NAMES => P_MIDDLE_NAMES
470 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
471 ,P_NATIONALITY => P_NATIONALITY
472 ,P_OFFICE_NUMBER => P_OFFICE_NUMBER
473 ,P_ON_MILITARY_SERVICE => P_ON_MILITARY_SERVICE
474 ,P_PARTY_ID => P_PARTY_ID
475 ,P_PRE_NAME_ADJUNCT => P_PRE_NAME_ADJUNCT
476 ,P_PREVIOUS_LAST_NAME => P_PREVIOUS_LAST_NAME
477 ,P_PROJECTED_PLACEMENT_END => P_PROJECTED_PLACEMENT_END
478 ,P_RECEIPT_OF_DEATH_CERT_DATE => P_RECEIPT_OF_DEATH_CERT_DATE
479 ,P_REGION_OF_BIRTH => P_REGION_OF_BIRTH
480 ,P_REGISTERED_DISABLED_FLAG => P_REGISTERED_DISABLED_FLAG
481 ,P_RESUME_EXISTS => P_RESUME_EXISTS
482 ,P_RESUME_LAST_UPDATED => P_RESUME_LAST_UPDATED
483 ,P_SECOND_PASSPORT_EXISTS => P_SECOND_PASSPORT_EXISTS
484 ,P_SEX => P_SEX
485 ,P_STUDENT_STATUS => P_STUDENT_STATUS
486 ,P_SUFFIX => P_SUFFIX
487 ,P_TITLE => P_TITLE
488 ,P_TOWN_OF_BIRTH => P_TOWN_OF_BIRTH
489 ,P_USES_TOBACCO_FLAG => P_USES_TOBACCO_FLAG
490 ,P_VENDOR_ID => P_VENDOR_ID
491 ,P_WORK_SCHEDULE => P_WORK_SCHEDULE
492 ,P_WORK_TELEPHONE => P_WORK_TELEPHONE
493 ,P_EXP_CHECK_SEND_TO_ADDRESS => P_EXP_CHECK_SEND_TO_ADDRESS
494 ,P_HOLD_APPLICANT_DATE_UNTIL => P_HOLD_APPLICANT_DATE_UNTIL
495 ,P_DATE_EMPLOYEE_DATA_VERIFIED => P_DATE_EMPLOYEE_DATA_VERIFIED
496 ,P_BENEFIT_GROUP_ID => P_BENEFIT_GROUP_ID
497 ,P_COORD_BEN_MED_PLN_NO => P_COORD_BEN_MED_PLN_NO
498 ,P_COORD_BEN_NO_CVG_FLAG => P_COORD_BEN_NO_CVG_FLAG
499 ,P_ORIGINAL_DATE_OF_HIRE => P_ORIGINAL_DATE_OF_HIRE
500 ,P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
501 ,P_ATTRIBUTE1 => P_ATTRIBUTE1
502 ,P_ATTRIBUTE2 => P_ATTRIBUTE2
503 ,P_ATTRIBUTE3 => P_ATTRIBUTE3
504 ,P_ATTRIBUTE4 => P_ATTRIBUTE4
505 ,P_ATTRIBUTE5 => P_ATTRIBUTE5
506 ,P_ATTRIBUTE6 => P_ATTRIBUTE6
507 ,P_ATTRIBUTE7 => P_ATTRIBUTE7
508 ,P_ATTRIBUTE8 => P_ATTRIBUTE8
509 ,P_ATTRIBUTE9 => P_ATTRIBUTE9
510 ,P_ATTRIBUTE10 => P_ATTRIBUTE10
511 ,P_ATTRIBUTE11 => P_ATTRIBUTE11
512 ,P_ATTRIBUTE12 => P_ATTRIBUTE12
513 ,P_ATTRIBUTE13 => P_ATTRIBUTE13
514 ,P_ATTRIBUTE14 => P_ATTRIBUTE14
515 ,P_ATTRIBUTE15 => P_ATTRIBUTE15
516 ,P_ATTRIBUTE16 => P_ATTRIBUTE16
517 ,P_ATTRIBUTE17 => P_ATTRIBUTE17
518 ,P_ATTRIBUTE18 => P_ATTRIBUTE18
519 ,P_ATTRIBUTE19 => P_ATTRIBUTE19
520 ,P_ATTRIBUTE20 => P_ATTRIBUTE20
521 ,P_ATTRIBUTE21 => P_ATTRIBUTE21
522 ,P_ATTRIBUTE22 => P_ATTRIBUTE22
523 ,P_ATTRIBUTE23 => P_ATTRIBUTE23
524 ,P_ATTRIBUTE24 => P_ATTRIBUTE24
525 ,P_ATTRIBUTE25 => P_ATTRIBUTE25
526 ,P_ATTRIBUTE26 => P_ATTRIBUTE26
527 ,P_ATTRIBUTE27 => P_ATTRIBUTE27
528 ,P_ATTRIBUTE28 => P_ATTRIBUTE28
529 ,P_ATTRIBUTE29 => P_ATTRIBUTE29
530 ,P_ATTRIBUTE30 => P_ATTRIBUTE30
531 ,P_PER_INFORMATION_CATEGORY => P_PER_INFORMATION_CATEGORY
532 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
533 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
534 ,P_PER_INFORMATION3 => P_PER_INFORMATION3
535 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
536 ,P_PER_INFORMATION5 => P_PER_INFORMATION5
537 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
538 ,P_PER_INFORMATION7 => P_PER_INFORMATION7
539 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
540 ,P_PER_INFORMATION9 => P_PER_INFORMATION9
541 ,P_PER_INFORMATION10 => P_PER_INFORMATION10
542 ,P_PER_INFORMATION11 => P_PER_INFORMATION11
543 ,P_PER_INFORMATION12 => P_PER_INFORMATION12
544 ,P_PER_INFORMATION13 => P_PER_INFORMATION13
545 ,P_PER_INFORMATION14 => P_PER_INFORMATION14
546 ,P_PER_INFORMATION15 => P_PER_INFORMATION15
547 ,P_PER_INFORMATION16 => P_PER_INFORMATION16
548 ,P_PER_INFORMATION17 => P_PER_INFORMATION17
549 ,P_PER_INFORMATION18 => P_PER_INFORMATION18
550 ,P_PER_INFORMATION19 => P_PER_INFORMATION19
551 ,P_PER_INFORMATION20 => P_PER_INFORMATION20
552 ,P_PER_INFORMATION21 => P_PER_INFORMATION21
553 ,P_PER_INFORMATION22 => P_PER_INFORMATION22
554 ,P_PER_INFORMATION23 => P_PER_INFORMATION23
555 ,P_PER_INFORMATION24 => P_PER_INFORMATION24
556 ,P_PER_INFORMATION25 => P_PER_INFORMATION25
557 ,P_PER_INFORMATION26 => P_PER_INFORMATION26
558 ,P_PER_INFORMATION27 => P_PER_INFORMATION27
559 ,P_PER_INFORMATION28 => P_PER_INFORMATION28
560 ,P_PER_INFORMATION29 => P_PER_INFORMATION29
561 ,P_PER_INFORMATION30 => P_PER_INFORMATION30
562 ,P_PERSON_ID => P_PERSON_ID
563 ,P_PER_OBJECT_VERSION_NUMBER => P_PER_OBJECT_VERSION_NUMBER
564 ,P_PER_EFFECTIVE_START_DATE => P_PER_EFFECTIVE_START_DATE
565 ,P_PER_EFFECTIVE_END_DATE => P_PER_EFFECTIVE_END_DATE
566 ,P_PDP_OBJECT_VERSION_NUMBER => P_PDP_OBJECT_VERSION_NUMBER
567 ,P_FULL_NAME => P_FULL_NAME
568 ,P_COMMENT_ID => P_COMMENT_ID
569 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
570 ,P_ASG_OBJECT_VERSION_NUMBER => P_ASG_OBJECT_VERSION_NUMBER
571 ,P_ASSIGNMENT_SEQUENCE => P_ASSIGNMENT_SEQUENCE
572 ,P_ASSIGNMENT_NUMBER => P_ASSIGNMENT_NUMBER
573 ,P_NAME_COMBINATION_WARNING => P_NAME_COMBINATION_WARNING
574 );
575 hr_utility.set_location('Leaving: '|| l_proc, 10);
576 end create_cwk_business_event;
577
578
579 procedure create_appl_business_event(
580 p_date_received in date
581 ,p_business_group_id in number
582 ,p_last_name in varchar2
583 ,p_person_type_id in number
584 ,p_applicant_number in varchar2
585 ,p_per_comments in varchar2
586 ,p_date_employee_data_verified in date
587 ,p_date_of_birth in date
588 ,p_email_address in varchar2
589 ,p_expense_check_send_to_addres in varchar2
590 ,p_first_name in varchar2
591 ,p_known_as in varchar2
592 ,p_marital_status in varchar2
593 ,p_middle_names in varchar2
594 ,p_nationality in varchar2
595 ,p_national_identifier in varchar2
596 ,p_previous_last_name in varchar2
597 ,p_registered_disabled_flag in varchar2
598 ,p_sex in varchar2
599 ,p_title in varchar2
600 ,p_work_telephone in varchar2
601 ,p_attribute_category in varchar2
602 ,p_attribute1 in varchar2
603 ,p_attribute2 in varchar2
604 ,p_attribute3 in varchar2
605 ,p_attribute4 in varchar2
606 ,p_attribute5 in varchar2
607 ,p_attribute6 in varchar2
608 ,p_attribute7 in varchar2
609 ,p_attribute8 in varchar2
610 ,p_attribute9 in varchar2
611 ,p_attribute10 in varchar2
612 ,p_attribute11 in varchar2
613 ,p_attribute12 in varchar2
614 ,p_attribute13 in varchar2
615 ,p_attribute14 in varchar2
616 ,p_attribute15 in varchar2
617 ,p_attribute16 in varchar2
618 ,p_attribute17 in varchar2
619 ,p_attribute18 in varchar2
620 ,p_attribute19 in varchar2
621 ,p_attribute20 in varchar2
622 ,p_attribute21 in varchar2
623 ,p_attribute22 in varchar2
624 ,p_attribute23 in varchar2
625 ,p_attribute24 in varchar2
626 ,p_attribute25 in varchar2
627 ,p_attribute26 in varchar2
628 ,p_attribute27 in varchar2
629 ,p_attribute28 in varchar2
630 ,p_attribute29 in varchar2
631 ,p_attribute30 in varchar2
632 ,p_per_information_category in varchar2
633 ,p_per_information1 in varchar2
634 ,p_per_information2 in varchar2
635 ,p_per_information3 in varchar2
636 ,p_per_information4 in varchar2
637 ,p_per_information5 in varchar2
638 ,p_per_information6 in varchar2
639 ,p_per_information7 in varchar2
640 ,p_per_information8 in varchar2
641 ,p_per_information9 in varchar2
642 ,p_per_information10 in varchar2
643 ,p_per_information11 in varchar2
644 ,p_per_information12 in varchar2
645 ,p_per_information13 in varchar2
646 ,p_per_information14 in varchar2
647 ,p_per_information15 in varchar2
648 ,p_per_information16 in varchar2
649 ,p_per_information17 in varchar2
650 ,p_per_information18 in varchar2
651 ,p_per_information19 in varchar2
652 ,p_per_information20 in varchar2
653 ,p_per_information21 in varchar2
654 ,p_per_information22 in varchar2
655 ,p_per_information23 in varchar2
656 ,p_per_information24 in varchar2
657 ,p_per_information25 in varchar2
658 ,p_per_information26 in varchar2
659 ,p_per_information27 in varchar2
660 ,p_per_information28 in varchar2
661 ,p_per_information29 in varchar2
662 ,p_per_information30 in varchar2
663 ,p_background_check_status in varchar2
664 ,p_background_date_check in date
665 ,p_correspondence_language in varchar2
666 ,p_fte_capacity in number
667 ,p_hold_applicant_date_until in date
668 ,p_honors in varchar2
669 ,p_mailstop in varchar2
670 ,p_office_number in varchar2
671 ,p_on_military_service in varchar2
672 ,p_pre_name_adjunct in varchar2
673 ,p_projected_start_date in date
674 ,p_resume_exists in varchar2
675 ,p_resume_last_updated in date
676 ,p_student_status in varchar2
677 ,p_work_schedule in varchar2
678 ,p_suffix in varchar2
679 ,p_date_of_death in date
680 ,p_benefit_group_id in number
681 ,p_receipt_of_death_cert_date in date
682 ,p_coord_ben_med_pln_no in varchar2
683 ,p_coord_ben_no_cvg_flag in varchar2
684 ,p_uses_tobacco_flag in varchar2
685 ,p_dpdnt_adoption_date in date
686 ,p_dpdnt_vlntry_svce_flag in varchar2
687 ,p_original_date_of_hire in date
688 ,p_person_id in number
689 ,p_assignment_id in number
690 ,p_application_id in number
691 ,p_per_object_version_number in number
692 ,p_asg_object_version_number in number
693 ,p_apl_object_version_number in number
694 ,p_per_effective_start_date in date
695 ,p_per_effective_end_date in date
696 ,p_full_name in varchar2
697 ,p_per_comment_id in number
698 ,p_assignment_sequence in number
699 ,p_name_combination_warning in boolean
700 ,p_orig_hire_warning in boolean
701 ,p_town_of_birth in varchar2
702 ,p_region_of_birth in varchar2
703 ,p_country_of_birth in varchar2
704 ,p_global_person_id in varchar2
705 ,p_party_id in varchar2
706 ,p_vacancy_id in number
707 )
708 is
709 l_proc varchar2(72) := 'create_appl_business_event';
710 begin
711 hr_utility.set_location('Entering: '|| l_proc, 20);
712 HR_APPLICANT_BK1.create_applicant_a(
713 p_date_received => p_date_received
714 ,p_business_group_id => p_business_group_id
715 ,p_last_name => p_last_name
716 ,p_person_type_id => p_person_type_id
717 ,p_applicant_number => p_applicant_number
718 ,p_per_comments => p_per_comments
719 ,p_date_employee_data_verified => p_date_employee_data_verified
720 ,p_date_of_birth => p_date_of_birth
721 ,p_email_address => p_email_address
722 ,p_expense_check_send_to_addres => p_expense_check_send_to_addres
723 ,p_first_name => p_first_name
724 ,p_known_as => p_known_as
725 ,p_marital_status => p_marital_status
726 ,p_middle_names => p_middle_names
727 ,p_nationality => p_nationality
728 ,p_national_identifier => p_national_identifier
729 ,p_previous_last_name => p_previous_last_name
730 ,p_registered_disabled_flag => p_registered_disabled_flag
731 ,p_sex => p_sex
732 ,p_title => p_title
733 ,p_work_telephone => p_work_telephone
734 ,p_attribute_category => p_attribute_category
735 ,p_attribute1 => p_attribute1
736 ,p_attribute2 => p_attribute2
737 ,p_attribute3 => p_attribute3
738 ,p_attribute4 => p_attribute4
739 ,p_attribute5 => p_attribute5
740 ,p_attribute6 => p_attribute6
741 ,p_attribute7 => p_attribute7
742 ,p_attribute8 => p_attribute8
743 ,p_attribute9 => p_attribute9
744 ,p_attribute10 => p_attribute10
745 ,p_attribute11 => p_attribute11
746 ,p_attribute12 => p_attribute12
747 ,p_attribute13 => p_attribute13
748 ,p_attribute14 => p_attribute14
749 ,p_attribute15 => p_attribute15
750 ,p_attribute16 => p_attribute16
751 ,p_attribute17 => p_attribute17
752 ,p_attribute18 => p_attribute18
753 ,p_attribute19 => p_attribute19
754 ,p_attribute20 => p_attribute20
755 ,p_attribute21 => p_attribute21
756 ,p_attribute22 => p_attribute22
757 ,p_attribute23 => p_attribute23
758 ,p_attribute24 => p_attribute24
759 ,p_attribute25 => p_attribute25
760 ,p_attribute26 => p_attribute26
761 ,p_attribute27 => p_attribute27
762 ,p_attribute28 => p_attribute28
763 ,p_attribute29 => p_attribute29
764 ,p_attribute30 => p_attribute30
765 ,p_per_information_category => p_per_information_category
766 ,p_per_information1 => p_per_information1
767 ,p_per_information2 => p_per_information2
768 ,p_per_information3 => p_per_information3
769 ,p_per_information4 => p_per_information4
770 ,p_per_information5 => p_per_information5
771 ,p_per_information6 => p_per_information6
772 ,p_per_information7 => p_per_information7
773 ,p_per_information8 => p_per_information8
774 ,p_per_information9 => p_per_information9
775 ,p_per_information10 => p_per_information10
776 ,p_per_information11 => p_per_information11
777 ,p_per_information12 => p_per_information12
778 ,p_per_information13 => p_per_information13
779 ,p_per_information14 => p_per_information14
780 ,p_per_information15 => p_per_information15
781 ,p_per_information16 => p_per_information16
782 ,p_per_information17 => p_per_information17
783 ,p_per_information18 => p_per_information18
784 ,p_per_information19 => p_per_information19
785 ,p_per_information20 => p_per_information20
786 ,p_per_information21 => p_per_information21
787 ,p_per_information22 => p_per_information22
788 ,p_per_information23 => p_per_information23
789 ,p_per_information24 => p_per_information24
790 ,p_per_information25 => p_per_information25
791 ,p_per_information26 => p_per_information26
792 ,p_per_information27 => p_per_information27
793 ,p_per_information28 => p_per_information28
794 ,p_per_information29 => p_per_information29
795 ,p_per_information30 => p_per_information30
796 ,p_background_check_status => p_background_check_status
797 ,p_background_date_check => p_background_date_check
798 ,p_correspondence_language => p_correspondence_language
799 ,p_fte_capacity => p_fte_capacity
800 ,p_hold_applicant_date_until => p_hold_applicant_date_until
801 ,p_honors => p_honors
802 ,p_mailstop => p_mailstop
803 ,p_office_number => p_office_number
804 ,p_on_military_service => p_on_military_service
805 ,p_pre_name_adjunct => p_pre_name_adjunct
806 ,p_projected_start_date => p_projected_start_date
807 ,p_resume_exists => p_resume_exists
808 ,p_resume_last_updated => p_resume_last_updated
809 ,p_student_status => p_student_status
810 ,p_work_schedule => p_work_schedule
811 ,p_suffix => p_suffix
812 ,p_date_of_death => p_date_of_death
813 ,p_benefit_group_id => p_benefit_group_id
814 ,p_receipt_of_death_cert_date => p_receipt_of_death_cert_date
815 ,p_coord_ben_med_pln_no => p_coord_ben_med_pln_no
816 ,p_coord_ben_no_cvg_flag => p_coord_ben_no_cvg_flag
817 ,p_uses_tobacco_flag => p_uses_tobacco_flag
818 ,p_dpdnt_adoption_date => p_dpdnt_adoption_date
819 ,p_dpdnt_vlntry_svce_flag => p_dpdnt_vlntry_svce_flag
820 ,p_original_date_of_hire => p_original_date_of_hire
821 ,p_person_id => p_person_id
822 ,p_assignment_id => p_assignment_id
823 ,p_application_id => p_application_id
824 ,p_per_object_version_number => p_per_object_version_number
825 ,p_asg_object_version_number => p_asg_object_version_number
826 ,p_apl_object_version_number => p_apl_object_version_number
827 ,p_per_effective_start_date => p_per_effective_start_date
828 ,p_per_effective_end_date => p_per_effective_end_date
829 ,p_full_name => p_full_name
830 ,p_per_comment_id => p_per_comment_id
831 ,p_assignment_sequence => p_assignment_sequence
832 ,p_name_combination_warning => p_name_combination_warning
833 ,p_orig_hire_warning => p_orig_hire_warning
834 ,p_town_of_birth => p_town_of_birth
835 ,p_region_of_birth => p_region_of_birth
836 ,p_country_of_birth => p_country_of_birth
837 ,p_global_person_id => p_global_person_id
838 ,p_party_id => p_party_id
839 ,p_vacancy_id => p_vacancy_id
840 );
841 hr_utility.set_location('Leaving: '|| l_proc, 20);
842 end create_appl_business_event;
843
844 procedure create_emp_business_event(
845 p_hire_date in date
846 ,p_business_group_id in number
847 ,p_last_name in varchar2
848 ,p_sex in varchar2
849 ,p_person_type_id in number
850 ,p_per_comments in varchar2
851 ,p_date_employee_data_verified in date
852 ,p_date_of_birth in date
853 ,p_email_address in varchar2
854 ,p_employee_number in varchar2
855 ,p_expense_check_send_to_addres in varchar2
856 ,p_first_name in varchar2
857 ,p_known_as in varchar2
858 ,p_marital_status in varchar2
859 ,p_middle_names in varchar2
860 ,p_nationality in varchar2
861 ,p_national_identifier in varchar2
862 ,p_previous_last_name in varchar2
863 ,p_registered_disabled_flag in varchar2
864 ,p_title in varchar2
865 ,p_vendor_id in number
866 ,p_work_telephone in varchar2
867 ,p_attribute_category in varchar2
868 ,p_attribute1 in varchar2
869 ,p_attribute2 in varchar2
870 ,p_attribute3 in varchar2
871 ,p_attribute4 in varchar2
872 ,p_attribute5 in varchar2
873 ,p_attribute6 in varchar2
874 ,p_attribute7 in varchar2
875 ,p_attribute8 in varchar2
876 ,p_attribute9 in varchar2
877 ,p_attribute10 in varchar2
878 ,p_attribute11 in varchar2
879 ,p_attribute12 in varchar2
880 ,p_attribute13 in varchar2
881 ,p_attribute14 in varchar2
882 ,p_attribute15 in varchar2
883 ,p_attribute16 in varchar2
884 ,p_attribute17 in varchar2
885 ,p_attribute18 in varchar2
886 ,p_attribute19 in varchar2
887 ,p_attribute20 in varchar2
888 ,p_attribute21 in varchar2
889 ,p_attribute22 in varchar2
890 ,p_attribute23 in varchar2
891 ,p_attribute24 in varchar2
892 ,p_attribute25 in varchar2
893 ,p_attribute26 in varchar2
894 ,p_attribute27 in varchar2
895 ,p_attribute28 in varchar2
896 ,p_attribute29 in varchar2
897 ,p_attribute30 in varchar2
898 ,p_per_information_category in varchar2
899 ,p_per_information1 in varchar2
900 ,p_per_information2 in varchar2
901 ,p_per_information3 in varchar2
902 ,p_per_information4 in varchar2
903 ,p_per_information5 in varchar2
904 ,p_per_information6 in varchar2
905 ,p_per_information7 in varchar2
906 ,p_per_information8 in varchar2
907 ,p_per_information9 in varchar2
908 ,p_per_information10 in varchar2
909 ,p_per_information11 in varchar2
910 ,p_per_information12 in varchar2
911 ,p_per_information13 in varchar2
912 ,p_per_information14 in varchar2
913 ,p_per_information15 in varchar2
914 ,p_per_information16 in varchar2
915 ,p_per_information17 in varchar2
916 ,p_per_information18 in varchar2
917 ,p_per_information19 in varchar2
918 ,p_per_information20 in varchar2
919 ,p_per_information21 in varchar2
920 ,p_per_information22 in varchar2
921 ,p_per_information23 in varchar2
922 ,p_per_information24 in varchar2
923 ,p_per_information25 in varchar2
924 ,p_per_information26 in varchar2
925 ,p_per_information27 in varchar2
926 ,p_per_information28 in varchar2
927 ,p_per_information29 in varchar2
928 ,p_per_information30 in varchar2
929 ,p_date_of_death in date
930 ,p_background_check_status in varchar2
931 ,p_background_date_check in date
932 ,p_blood_type in varchar2
933 ,p_correspondence_language in varchar2
934 ,p_fast_path_employee in varchar2
935 ,p_fte_capacity in number
936 ,p_honors in varchar2
937 ,p_internal_location in varchar2
938 ,p_last_medical_test_by in varchar2
939 ,p_last_medical_test_date in date
940 ,p_mailstop in varchar2
941 ,p_office_number in varchar2
942 ,p_on_military_service in varchar2
943 ,p_pre_name_adjunct in varchar2
944 ,p_rehire_recommendation in varchar2
945 ,p_projected_start_date in date
946 ,p_resume_exists in varchar2
947 ,p_resume_last_updated in date
948 ,p_second_passport_exists in varchar2
949 ,p_student_status in varchar2
950 ,p_work_schedule in varchar2
951 ,p_suffix in varchar2
952 ,p_benefit_group_id in number
953 ,p_receipt_of_death_cert_date in date
954 ,p_coord_ben_med_pln_no in varchar2
955 ,p_coord_ben_no_cvg_flag in varchar2
956 ,p_coord_ben_med_ext_er in varchar2
957 ,p_coord_ben_med_pl_name in varchar2
958 ,p_coord_ben_med_insr_crr_name in varchar2
959 ,p_coord_ben_med_insr_crr_ident in varchar2
960 ,p_coord_ben_med_cvg_strt_dt in date
961 ,p_coord_ben_med_cvg_end_dt in date
962 ,p_uses_tobacco_flag in varchar2
963 ,p_dpdnt_adoption_date in date
964 ,p_dpdnt_vlntry_svce_flag in varchar2
965 ,p_original_date_of_hire in date
966 ,p_adjusted_svc_date in date
967 ,p_person_id in number
968 ,p_assignment_id in number
969 ,p_per_object_version_number in number
970 ,p_asg_object_version_number in number
971 ,p_per_effective_start_date in date
972 ,p_per_effective_end_date in date
973 ,p_full_name in varchar2
974 ,p_per_comment_id in number
975 ,p_assignment_sequence in number
976 ,p_assignment_number in varchar2
977 ,p_town_of_birth in varchar2
978 ,p_region_of_birth in varchar2
979 ,p_country_of_birth in varchar2
980 ,p_global_person_id in varchar2
981 ,p_party_id in number
982 ,p_name_combination_warning in boolean
983 ,p_assign_payroll_warning in boolean
984 ,p_orig_hire_warning in boolean
985 )
986 is
987 l_proc varchar2(72) := 'create_emp_business_event';
988 begin
989 hr_utility.set_location('Entering: '|| l_proc, 20);
990 HR_EMPLOYEE_BK1.create_employee_a(
991 p_hire_date => p_hire_date
992 ,p_business_group_id => p_business_group_id
993 ,p_last_name => p_last_name
994 ,p_sex => p_sex
995 ,p_person_type_id => p_person_type_id
996 ,p_per_comments => p_per_comments
997 ,p_date_employee_data_verified => p_date_employee_data_verified
998 ,p_date_of_birth => p_date_of_birth
999 ,p_email_address => p_email_address
1000 ,p_employee_number => p_employee_number
1001 ,p_expense_check_send_to_addres => p_expense_check_send_to_addres
1002 ,p_first_name => p_first_name
1003 ,p_known_as => p_known_as
1004 ,p_marital_status => p_marital_status
1005 ,p_middle_names => p_middle_names
1006 ,p_nationality => p_nationality
1007 ,p_national_identifier => p_national_identifier
1008 ,p_previous_last_name => p_previous_last_name
1009 ,p_registered_disabled_flag => p_registered_disabled_flag
1010 ,p_title => p_title
1011 ,p_vendor_id => p_vendor_id
1012 ,p_work_telephone => p_work_telephone
1013 ,p_attribute_category => p_attribute_category
1014 ,p_attribute1 => p_attribute1
1015 ,p_attribute2 => p_attribute2
1016 ,p_attribute3 => p_attribute3
1017 ,p_attribute4 => p_attribute4
1018 ,p_attribute5 => p_attribute5
1019 ,p_attribute6 => p_attribute6
1020 ,p_attribute7 => p_attribute7
1021 ,p_attribute8 => p_attribute8
1022 ,p_attribute9 => p_attribute9
1023 ,p_attribute10 => p_attribute10
1024 ,p_attribute11 => p_attribute11
1025 ,p_attribute12 => p_attribute12
1026 ,p_attribute13 => p_attribute13
1027 ,p_attribute14 => p_attribute14
1028 ,p_attribute15 => p_attribute15
1029 ,p_attribute16 => p_attribute16
1030 ,p_attribute17 => p_attribute17
1031 ,p_attribute18 => p_attribute18
1032 ,p_attribute19 => p_attribute19
1033 ,p_attribute20 => p_attribute20
1034 ,p_attribute21 => p_attribute21
1035 ,p_attribute22 => p_attribute22
1036 ,p_attribute23 => p_attribute23
1037 ,p_attribute24 => p_attribute24
1038 ,p_attribute25 => p_attribute25
1039 ,p_attribute26 => p_attribute26
1040 ,p_attribute27 => p_attribute27
1041 ,p_attribute28 => p_attribute28
1042 ,p_attribute29 => p_attribute29
1043 ,p_attribute30 => p_attribute30
1044 ,p_per_information_category => p_per_information_category
1045 ,p_per_information1 => p_per_information1
1046 ,p_per_information2 => p_per_information2
1047 ,p_per_information3 => p_per_information3
1048 ,p_per_information4 => p_per_information4
1049 ,p_per_information5 => p_per_information5
1050 ,p_per_information6 => p_per_information6
1051 ,p_per_information7 => p_per_information7
1052 ,p_per_information8 => p_per_information8
1053 ,p_per_information9 => p_per_information9
1054 ,p_per_information10 => p_per_information10
1055 ,p_per_information11 => p_per_information11
1056 ,p_per_information12 => p_per_information12
1057 ,p_per_information13 => p_per_information13
1058 ,p_per_information14 => p_per_information14
1059 ,p_per_information15 => p_per_information15
1060 ,p_per_information16 => p_per_information16
1061 ,p_per_information17 => p_per_information17
1062 ,p_per_information18 => p_per_information18
1063 ,p_per_information19 => p_per_information19
1064 ,p_per_information20 => p_per_information20
1065 ,p_per_information21 => p_per_information21
1066 ,p_per_information22 => p_per_information22
1067 ,p_per_information23 => p_per_information23
1068 ,p_per_information24 => p_per_information24
1069 ,p_per_information25 => p_per_information25
1070 ,p_per_information26 => p_per_information26
1071 ,p_per_information27 => p_per_information27
1072 ,p_per_information28 => p_per_information28
1073 ,p_per_information29 => p_per_information29
1074 ,p_per_information30 => p_per_information30
1075 ,p_date_of_death => p_date_of_death
1076 ,p_background_check_status => p_background_check_status
1077 ,p_background_date_check => p_background_date_check
1078 ,p_blood_type => p_blood_type
1079 ,p_correspondence_language => p_correspondence_language
1080 ,p_fast_path_employee => p_fast_path_employee
1081 ,p_fte_capacity => p_fte_capacity
1082 ,p_honors => p_honors
1083 ,p_internal_location => p_internal_location
1084 ,p_last_medical_test_by => p_last_medical_test_by
1085 ,p_last_medical_test_date => p_last_medical_test_date
1086 ,p_mailstop => p_mailstop
1087 ,p_office_number => p_office_number
1088 ,p_on_military_service => p_on_military_service
1089 ,p_pre_name_adjunct => p_pre_name_adjunct
1090 ,p_rehire_recommendation => p_rehire_recommendation
1091 ,p_projected_start_date => p_projected_start_date
1092 ,p_resume_exists => p_resume_exists
1093 ,p_resume_last_updated => p_resume_last_updated
1094 ,p_second_passport_exists => p_second_passport_exists
1095 ,p_student_status => p_student_status
1096 ,p_work_schedule => p_work_schedule
1097 ,p_suffix => p_suffix
1098 ,p_benefit_group_id => p_benefit_group_id
1099 ,p_receipt_of_death_cert_date => p_receipt_of_death_cert_date
1100 ,p_coord_ben_med_pln_no => p_coord_ben_med_pln_no
1101 ,p_coord_ben_no_cvg_flag => p_coord_ben_no_cvg_flag
1102 ,p_coord_ben_med_ext_er => p_coord_ben_med_ext_er
1103 ,p_coord_ben_med_pl_name => p_coord_ben_med_pl_name
1104 ,p_coord_ben_med_insr_crr_name => p_coord_ben_med_insr_crr_name
1105 ,p_coord_ben_med_insr_crr_ident => p_coord_ben_med_insr_crr_ident
1106 ,p_coord_ben_med_cvg_strt_dt => p_coord_ben_med_cvg_strt_dt
1107 ,p_coord_ben_med_cvg_end_dt => p_coord_ben_med_cvg_end_dt
1108 ,p_uses_tobacco_flag => p_uses_tobacco_flag
1109 ,p_dpdnt_adoption_date => p_dpdnt_adoption_date
1110 ,p_dpdnt_vlntry_svce_flag => p_dpdnt_vlntry_svce_flag
1111 ,p_original_date_of_hire => p_original_date_of_hire
1112 ,p_adjusted_svc_date => p_adjusted_svc_date
1113 ,p_person_id => p_person_id
1114 ,p_assignment_id => p_assignment_id
1115 ,p_per_object_version_number => p_per_object_version_number
1116 ,p_asg_object_version_number => p_asg_object_version_number
1117 ,p_per_effective_start_date => p_per_effective_start_date
1118 ,p_per_effective_end_date => p_per_effective_end_date
1119 ,p_full_name => p_full_name
1120 ,p_per_comment_id => p_per_comment_id
1121 ,p_assignment_sequence => p_assignment_sequence
1122 ,p_assignment_number => p_assignment_number
1123 ,p_town_of_birth => p_town_of_birth
1124 ,p_region_of_birth => p_region_of_birth
1125 ,p_country_of_birth => p_country_of_birth
1126 ,p_global_person_id => p_global_person_id
1127 ,p_party_id => p_party_id
1128 ,p_name_combination_warning => p_name_combination_warning
1129 ,p_assign_payroll_warning => p_assign_payroll_warning
1130 ,p_orig_hire_warning => p_orig_hire_warning
1131 );
1132 hr_utility.set_location('Leaving: '|| l_proc, 20);
1133 end create_emp_business_event;
1134
1135 end HR_PERSON_BUSINESS_EVENT;