eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.HR_APPLICANT_BK1

Source


1 package body HR_APPLICANT_BK1 as
2 /* $Header: peappapi.pkb 120.39.12020000.6 2013/02/27 10:40:14 generated ship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2013/08/13 18:42:20 (YYYY/MM/DD HH24:MI:SS)
5 procedure CREATE_APPLICANT_A
6 (P_DATE_RECEIVED in DATE
7 ,P_BUSINESS_GROUP_ID in NUMBER
8 ,P_LAST_NAME in VARCHAR2
9 ,P_PERSON_TYPE_ID in NUMBER
10 ,P_APPLICANT_NUMBER in VARCHAR2
11 ,P_PER_COMMENTS in VARCHAR2
12 ,P_DATE_EMPLOYEE_DATA_VERIFIED in DATE
13 ,P_DATE_OF_BIRTH in DATE
14 ,P_EMAIL_ADDRESS in VARCHAR2
15 ,P_EXPENSE_CHECK_SEND_TO_ADDRES in VARCHAR2
16 ,P_FIRST_NAME in VARCHAR2
17 ,P_KNOWN_AS in VARCHAR2
18 ,P_MARITAL_STATUS in VARCHAR2
19 ,P_MIDDLE_NAMES in VARCHAR2
20 ,P_NATIONALITY in VARCHAR2
21 ,P_NATIONAL_IDENTIFIER in VARCHAR2
22 ,P_PREVIOUS_LAST_NAME in VARCHAR2
23 ,P_REGISTERED_DISABLED_FLAG in VARCHAR2
24 ,P_SEX in VARCHAR2
25 ,P_TITLE in VARCHAR2
26 ,P_WORK_TELEPHONE in VARCHAR2
27 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
28 ,P_ATTRIBUTE1 in VARCHAR2
29 ,P_ATTRIBUTE2 in VARCHAR2
30 ,P_ATTRIBUTE3 in VARCHAR2
31 ,P_ATTRIBUTE4 in VARCHAR2
32 ,P_ATTRIBUTE5 in VARCHAR2
33 ,P_ATTRIBUTE6 in VARCHAR2
34 ,P_ATTRIBUTE7 in VARCHAR2
35 ,P_ATTRIBUTE8 in VARCHAR2
36 ,P_ATTRIBUTE9 in VARCHAR2
37 ,P_ATTRIBUTE10 in VARCHAR2
38 ,P_ATTRIBUTE11 in VARCHAR2
39 ,P_ATTRIBUTE12 in VARCHAR2
40 ,P_ATTRIBUTE13 in VARCHAR2
41 ,P_ATTRIBUTE14 in VARCHAR2
42 ,P_ATTRIBUTE15 in VARCHAR2
43 ,P_ATTRIBUTE16 in VARCHAR2
44 ,P_ATTRIBUTE17 in VARCHAR2
45 ,P_ATTRIBUTE18 in VARCHAR2
46 ,P_ATTRIBUTE19 in VARCHAR2
47 ,P_ATTRIBUTE20 in VARCHAR2
48 ,P_ATTRIBUTE21 in VARCHAR2
49 ,P_ATTRIBUTE22 in VARCHAR2
50 ,P_ATTRIBUTE23 in VARCHAR2
51 ,P_ATTRIBUTE24 in VARCHAR2
52 ,P_ATTRIBUTE25 in VARCHAR2
53 ,P_ATTRIBUTE26 in VARCHAR2
54 ,P_ATTRIBUTE27 in VARCHAR2
55 ,P_ATTRIBUTE28 in VARCHAR2
56 ,P_ATTRIBUTE29 in VARCHAR2
57 ,P_ATTRIBUTE30 in VARCHAR2
58 ,P_PER_INFORMATION_CATEGORY in VARCHAR2
59 ,P_PER_INFORMATION1 in VARCHAR2
60 ,P_PER_INFORMATION2 in VARCHAR2
61 ,P_PER_INFORMATION3 in VARCHAR2
62 ,P_PER_INFORMATION4 in VARCHAR2
63 ,P_PER_INFORMATION5 in VARCHAR2
64 ,P_PER_INFORMATION6 in VARCHAR2
65 ,P_PER_INFORMATION7 in VARCHAR2
66 ,P_PER_INFORMATION8 in VARCHAR2
67 ,P_PER_INFORMATION9 in VARCHAR2
68 ,P_PER_INFORMATION10 in VARCHAR2
69 ,P_PER_INFORMATION11 in VARCHAR2
70 ,P_PER_INFORMATION12 in VARCHAR2
71 ,P_PER_INFORMATION13 in VARCHAR2
72 ,P_PER_INFORMATION14 in VARCHAR2
73 ,P_PER_INFORMATION15 in VARCHAR2
74 ,P_PER_INFORMATION16 in VARCHAR2
75 ,P_PER_INFORMATION17 in VARCHAR2
76 ,P_PER_INFORMATION18 in VARCHAR2
77 ,P_PER_INFORMATION19 in VARCHAR2
78 ,P_PER_INFORMATION20 in VARCHAR2
79 ,P_PER_INFORMATION21 in VARCHAR2
80 ,P_PER_INFORMATION22 in VARCHAR2
81 ,P_PER_INFORMATION23 in VARCHAR2
82 ,P_PER_INFORMATION24 in VARCHAR2
83 ,P_PER_INFORMATION25 in VARCHAR2
84 ,P_PER_INFORMATION26 in VARCHAR2
85 ,P_PER_INFORMATION27 in VARCHAR2
86 ,P_PER_INFORMATION28 in VARCHAR2
87 ,P_PER_INFORMATION29 in VARCHAR2
88 ,P_PER_INFORMATION30 in VARCHAR2
89 ,P_BACKGROUND_CHECK_STATUS in VARCHAR2
90 ,P_BACKGROUND_DATE_CHECK in DATE
91 ,P_CORRESPONDENCE_LANGUAGE in VARCHAR2
92 ,P_FTE_CAPACITY in NUMBER
93 ,P_HOLD_APPLICANT_DATE_UNTIL in DATE
94 ,P_HONORS in VARCHAR2
95 ,P_MAILSTOP in VARCHAR2
96 ,P_OFFICE_NUMBER in VARCHAR2
97 ,P_ON_MILITARY_SERVICE in VARCHAR2
98 ,P_PRE_NAME_ADJUNCT in VARCHAR2
99 ,P_PROJECTED_START_DATE in DATE
100 ,P_RESUME_EXISTS in VARCHAR2
101 ,P_RESUME_LAST_UPDATED in DATE
102 ,P_STUDENT_STATUS in VARCHAR2
103 ,P_WORK_SCHEDULE in VARCHAR2
104 ,P_SUFFIX in VARCHAR2
105 ,P_DATE_OF_DEATH in DATE
106 ,P_BENEFIT_GROUP_ID in NUMBER
107 ,P_RECEIPT_OF_DEATH_CERT_DATE in DATE
108 ,P_COORD_BEN_MED_PLN_NO in VARCHAR2
109 ,P_COORD_BEN_NO_CVG_FLAG in VARCHAR2
110 ,P_USES_TOBACCO_FLAG in VARCHAR2
111 ,P_DPDNT_ADOPTION_DATE in DATE
112 ,P_DPDNT_VLNTRY_SVCE_FLAG in VARCHAR2
113 ,P_ORIGINAL_DATE_OF_HIRE in DATE
114 ,P_PERSON_ID in NUMBER
115 ,P_ASSIGNMENT_ID in NUMBER
116 ,P_APPLICATION_ID in NUMBER
117 ,P_PER_OBJECT_VERSION_NUMBER in NUMBER
118 ,P_ASG_OBJECT_VERSION_NUMBER in NUMBER
119 ,P_APL_OBJECT_VERSION_NUMBER in NUMBER
120 ,P_PER_EFFECTIVE_START_DATE in DATE
121 ,P_PER_EFFECTIVE_END_DATE in DATE
122 ,P_FULL_NAME in VARCHAR2
123 ,P_PER_COMMENT_ID in NUMBER
124 ,P_ASSIGNMENT_SEQUENCE in NUMBER
125 ,P_NAME_COMBINATION_WARNING in BOOLEAN
126 ,P_ORIG_HIRE_WARNING in BOOLEAN
127 ,P_TOWN_OF_BIRTH in VARCHAR2
128 ,P_REGION_OF_BIRTH in VARCHAR2
129 ,P_COUNTRY_OF_BIRTH in VARCHAR2
130 ,P_GLOBAL_PERSON_ID in VARCHAR2
131 ,P_PARTY_ID in VARCHAR2
132 ,P_VACANCY_ID in NUMBER
133 )is
134 l_commit_unit_number number;
135 l_legislation_code   varchar2(30);
136 begin
137 hr_utility.set_location('Entering: HR_APPLICANT_BK1.CREATE_APPLICANT_A', 10);
138 l_commit_unit_number := hr_api.return_commit_unit;
139 if hr_api.call_app_hooks then
140 hr_applicant_be1.CREATE_APPLICANT_A
141 (P_DATE_RECEIVED => P_DATE_RECEIVED
142 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
143 ,P_LAST_NAME => P_LAST_NAME
144 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
145 ,P_APPLICANT_NUMBER => P_APPLICANT_NUMBER
146 ,P_PER_COMMENTS => P_PER_COMMENTS
147 ,P_DATE_EMPLOYEE_DATA_VERIFIED => P_DATE_EMPLOYEE_DATA_VERIFIED
148 ,P_DATE_OF_BIRTH => P_DATE_OF_BIRTH
149 ,P_EMAIL_ADDRESS => P_EMAIL_ADDRESS
150 ,P_EXPENSE_CHECK_SEND_TO_ADDRES => P_EXPENSE_CHECK_SEND_TO_ADDRES
151 ,P_FIRST_NAME => P_FIRST_NAME
152 ,P_KNOWN_AS => P_KNOWN_AS
153 ,P_MARITAL_STATUS => P_MARITAL_STATUS
154 ,P_MIDDLE_NAMES => P_MIDDLE_NAMES
155 ,P_NATIONALITY => P_NATIONALITY
156 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
157 ,P_PREVIOUS_LAST_NAME => P_PREVIOUS_LAST_NAME
158 ,P_REGISTERED_DISABLED_FLAG => P_REGISTERED_DISABLED_FLAG
159 ,P_SEX => P_SEX
160 ,P_TITLE => P_TITLE
161 ,P_WORK_TELEPHONE => P_WORK_TELEPHONE
162 ,P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
163 ,P_ATTRIBUTE1 => P_ATTRIBUTE1
164 ,P_ATTRIBUTE2 => P_ATTRIBUTE2
165 ,P_ATTRIBUTE3 => P_ATTRIBUTE3
166 ,P_ATTRIBUTE4 => P_ATTRIBUTE4
167 ,P_ATTRIBUTE5 => P_ATTRIBUTE5
168 ,P_ATTRIBUTE6 => P_ATTRIBUTE6
169 ,P_ATTRIBUTE7 => P_ATTRIBUTE7
170 ,P_ATTRIBUTE8 => P_ATTRIBUTE8
171 ,P_ATTRIBUTE9 => P_ATTRIBUTE9
172 ,P_ATTRIBUTE10 => P_ATTRIBUTE10
173 ,P_ATTRIBUTE11 => P_ATTRIBUTE11
174 ,P_ATTRIBUTE12 => P_ATTRIBUTE12
175 ,P_ATTRIBUTE13 => P_ATTRIBUTE13
176 ,P_ATTRIBUTE14 => P_ATTRIBUTE14
177 ,P_ATTRIBUTE15 => P_ATTRIBUTE15
178 ,P_ATTRIBUTE16 => P_ATTRIBUTE16
179 ,P_ATTRIBUTE17 => P_ATTRIBUTE17
180 ,P_ATTRIBUTE18 => P_ATTRIBUTE18
181 ,P_ATTRIBUTE19 => P_ATTRIBUTE19
182 ,P_ATTRIBUTE20 => P_ATTRIBUTE20
183 ,P_ATTRIBUTE21 => P_ATTRIBUTE21
184 ,P_ATTRIBUTE22 => P_ATTRIBUTE22
185 ,P_ATTRIBUTE23 => P_ATTRIBUTE23
186 ,P_ATTRIBUTE24 => P_ATTRIBUTE24
187 ,P_ATTRIBUTE25 => P_ATTRIBUTE25
188 ,P_ATTRIBUTE26 => P_ATTRIBUTE26
189 ,P_ATTRIBUTE27 => P_ATTRIBUTE27
190 ,P_ATTRIBUTE28 => P_ATTRIBUTE28
191 ,P_ATTRIBUTE29 => P_ATTRIBUTE29
192 ,P_ATTRIBUTE30 => P_ATTRIBUTE30
193 ,P_PER_INFORMATION_CATEGORY => P_PER_INFORMATION_CATEGORY
194 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
195 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
196 ,P_PER_INFORMATION3 => P_PER_INFORMATION3
197 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
198 ,P_PER_INFORMATION5 => P_PER_INFORMATION5
199 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
200 ,P_PER_INFORMATION7 => P_PER_INFORMATION7
201 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
202 ,P_PER_INFORMATION9 => P_PER_INFORMATION9
203 ,P_PER_INFORMATION10 => P_PER_INFORMATION10
204 ,P_PER_INFORMATION11 => P_PER_INFORMATION11
205 ,P_PER_INFORMATION12 => P_PER_INFORMATION12
206 ,P_PER_INFORMATION13 => P_PER_INFORMATION13
207 ,P_PER_INFORMATION14 => P_PER_INFORMATION14
208 ,P_PER_INFORMATION15 => P_PER_INFORMATION15
209 ,P_PER_INFORMATION16 => P_PER_INFORMATION16
210 ,P_PER_INFORMATION17 => P_PER_INFORMATION17
211 ,P_PER_INFORMATION18 => P_PER_INFORMATION18
212 ,P_PER_INFORMATION19 => P_PER_INFORMATION19
213 ,P_PER_INFORMATION20 => P_PER_INFORMATION20
214 ,P_PER_INFORMATION21 => P_PER_INFORMATION21
215 ,P_PER_INFORMATION22 => P_PER_INFORMATION22
216 ,P_PER_INFORMATION23 => P_PER_INFORMATION23
217 ,P_PER_INFORMATION24 => P_PER_INFORMATION24
218 ,P_PER_INFORMATION25 => P_PER_INFORMATION25
219 ,P_PER_INFORMATION26 => P_PER_INFORMATION26
220 ,P_PER_INFORMATION27 => P_PER_INFORMATION27
221 ,P_PER_INFORMATION28 => P_PER_INFORMATION28
222 ,P_PER_INFORMATION29 => P_PER_INFORMATION29
223 ,P_PER_INFORMATION30 => P_PER_INFORMATION30
224 ,P_BACKGROUND_CHECK_STATUS => P_BACKGROUND_CHECK_STATUS
225 ,P_BACKGROUND_DATE_CHECK => P_BACKGROUND_DATE_CHECK
226 ,P_CORRESPONDENCE_LANGUAGE => P_CORRESPONDENCE_LANGUAGE
227 ,P_FTE_CAPACITY => P_FTE_CAPACITY
228 ,P_HOLD_APPLICANT_DATE_UNTIL => P_HOLD_APPLICANT_DATE_UNTIL
229 ,P_HONORS => P_HONORS
230 ,P_MAILSTOP => P_MAILSTOP
231 ,P_OFFICE_NUMBER => P_OFFICE_NUMBER
232 ,P_ON_MILITARY_SERVICE => P_ON_MILITARY_SERVICE
233 ,P_PRE_NAME_ADJUNCT => P_PRE_NAME_ADJUNCT
234 ,P_PROJECTED_START_DATE => P_PROJECTED_START_DATE
235 ,P_RESUME_EXISTS => P_RESUME_EXISTS
236 ,P_RESUME_LAST_UPDATED => P_RESUME_LAST_UPDATED
237 ,P_STUDENT_STATUS => P_STUDENT_STATUS
238 ,P_WORK_SCHEDULE => P_WORK_SCHEDULE
239 ,P_SUFFIX => P_SUFFIX
240 ,P_DATE_OF_DEATH => P_DATE_OF_DEATH
241 ,P_BENEFIT_GROUP_ID => P_BENEFIT_GROUP_ID
242 ,P_RECEIPT_OF_DEATH_CERT_DATE => P_RECEIPT_OF_DEATH_CERT_DATE
243 ,P_COORD_BEN_MED_PLN_NO => P_COORD_BEN_MED_PLN_NO
244 ,P_COORD_BEN_NO_CVG_FLAG => P_COORD_BEN_NO_CVG_FLAG
245 ,P_USES_TOBACCO_FLAG => P_USES_TOBACCO_FLAG
246 ,P_DPDNT_ADOPTION_DATE => P_DPDNT_ADOPTION_DATE
247 ,P_DPDNT_VLNTRY_SVCE_FLAG => P_DPDNT_VLNTRY_SVCE_FLAG
248 ,P_ORIGINAL_DATE_OF_HIRE => P_ORIGINAL_DATE_OF_HIRE
249 ,P_PERSON_ID => P_PERSON_ID
250 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
251 ,P_APPLICATION_ID => P_APPLICATION_ID
252 ,P_PER_OBJECT_VERSION_NUMBER => P_PER_OBJECT_VERSION_NUMBER
253 ,P_ASG_OBJECT_VERSION_NUMBER => P_ASG_OBJECT_VERSION_NUMBER
254 ,P_APL_OBJECT_VERSION_NUMBER => P_APL_OBJECT_VERSION_NUMBER
255 ,P_PER_EFFECTIVE_START_DATE => P_PER_EFFECTIVE_START_DATE
256 ,P_PER_EFFECTIVE_END_DATE => P_PER_EFFECTIVE_END_DATE
257 ,P_FULL_NAME => P_FULL_NAME
258 ,P_PER_COMMENT_ID => P_PER_COMMENT_ID
259 ,P_ASSIGNMENT_SEQUENCE => P_ASSIGNMENT_SEQUENCE
260 ,P_NAME_COMBINATION_WARNING => P_NAME_COMBINATION_WARNING
261 ,P_ORIG_HIRE_WARNING => P_ORIG_HIRE_WARNING
262 ,P_TOWN_OF_BIRTH => P_TOWN_OF_BIRTH
263 ,P_REGION_OF_BIRTH => P_REGION_OF_BIRTH
264 ,P_COUNTRY_OF_BIRTH => P_COUNTRY_OF_BIRTH
265 ,P_GLOBAL_PERSON_ID => P_GLOBAL_PERSON_ID
266 ,P_PARTY_ID => P_PARTY_ID
267 ,P_VACANCY_ID => P_VACANCY_ID
268 );
269 end if;
270 if hr_api.call_leg_hooks then
271 l_legislation_code := hr_api.return_legislation_code(p_business_group_id => P_BUSINESS_GROUP_ID);
272 if l_legislation_code = 'MX' then
273 PER_MX_VALIDATE_ID.VALIDATE_RFC_ID
274 (P_PER_INFORMATION2 => P_PER_INFORMATION2
275 ,P_PERSON_ID => P_PERSON_ID
276 );
277 PER_MX_VALIDATE_ID.VALIDATE_SS_ID
278 (P_PER_INFORMATION3 => P_PER_INFORMATION3
279 ,P_PERSON_ID => P_PERSON_ID
280 );
281 PER_MX_VALIDATE_ID.VALIDATE_FGA_ID
282 (P_PER_INFORMATION5 => P_PER_INFORMATION5
283 ,P_PERSON_ID => P_PERSON_ID
284 );
285 PER_MX_VALIDATE_ID.VALIDATE_MS_ID
286 (P_PER_INFORMATION6 => P_PER_INFORMATION6
287 ,P_PERSON_ID => P_PERSON_ID
288 );
289 PER_MX_VALIDATE_ID.VALIDATE_IMC_ID
290 (P_PER_INFORMATION4 => P_PER_INFORMATION4
291 );
292 end if;
293 end if;
294 hr_multi_message.end_validation_set;
295 hr_api.validate_commit_unit(l_commit_unit_number, 'CREATE_APPLICANT', 'AP');
296 hr_utility.set_location(' Leaving: HR_APPLICANT_BK1.CREATE_APPLICANT_A', 20);
297 end CREATE_APPLICANT_A;
298 procedure CREATE_APPLICANT_B
299 (P_DATE_RECEIVED in DATE
300 ,P_BUSINESS_GROUP_ID in NUMBER
301 ,P_LAST_NAME in VARCHAR2
302 ,P_PERSON_TYPE_ID in NUMBER
303 ,P_APPLICANT_NUMBER in VARCHAR2
304 ,P_PER_COMMENTS in VARCHAR2
305 ,P_DATE_EMPLOYEE_DATA_VERIFIED in DATE
306 ,P_DATE_OF_BIRTH in DATE
307 ,P_EMAIL_ADDRESS in VARCHAR2
308 ,P_EXPENSE_CHECK_SEND_TO_ADDRES in VARCHAR2
309 ,P_FIRST_NAME in VARCHAR2
310 ,P_KNOWN_AS in VARCHAR2
311 ,P_MARITAL_STATUS in VARCHAR2
312 ,P_MIDDLE_NAMES in VARCHAR2
313 ,P_NATIONALITY in VARCHAR2
314 ,P_NATIONAL_IDENTIFIER in VARCHAR2
315 ,P_PREVIOUS_LAST_NAME in VARCHAR2
316 ,P_REGISTERED_DISABLED_FLAG in VARCHAR2
317 ,P_SEX in VARCHAR2
318 ,P_TITLE in VARCHAR2
319 ,P_WORK_TELEPHONE in VARCHAR2
320 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
321 ,P_ATTRIBUTE1 in VARCHAR2
322 ,P_ATTRIBUTE2 in VARCHAR2
323 ,P_ATTRIBUTE3 in VARCHAR2
324 ,P_ATTRIBUTE4 in VARCHAR2
325 ,P_ATTRIBUTE5 in VARCHAR2
326 ,P_ATTRIBUTE6 in VARCHAR2
327 ,P_ATTRIBUTE7 in VARCHAR2
328 ,P_ATTRIBUTE8 in VARCHAR2
329 ,P_ATTRIBUTE9 in VARCHAR2
330 ,P_ATTRIBUTE10 in VARCHAR2
331 ,P_ATTRIBUTE11 in VARCHAR2
332 ,P_ATTRIBUTE12 in VARCHAR2
333 ,P_ATTRIBUTE13 in VARCHAR2
334 ,P_ATTRIBUTE14 in VARCHAR2
335 ,P_ATTRIBUTE15 in VARCHAR2
336 ,P_ATTRIBUTE16 in VARCHAR2
337 ,P_ATTRIBUTE17 in VARCHAR2
338 ,P_ATTRIBUTE18 in VARCHAR2
339 ,P_ATTRIBUTE19 in VARCHAR2
340 ,P_ATTRIBUTE20 in VARCHAR2
341 ,P_ATTRIBUTE21 in VARCHAR2
342 ,P_ATTRIBUTE22 in VARCHAR2
343 ,P_ATTRIBUTE23 in VARCHAR2
344 ,P_ATTRIBUTE24 in VARCHAR2
345 ,P_ATTRIBUTE25 in VARCHAR2
346 ,P_ATTRIBUTE26 in VARCHAR2
347 ,P_ATTRIBUTE27 in VARCHAR2
348 ,P_ATTRIBUTE28 in VARCHAR2
349 ,P_ATTRIBUTE29 in VARCHAR2
350 ,P_ATTRIBUTE30 in VARCHAR2
351 ,P_PER_INFORMATION_CATEGORY in VARCHAR2
352 ,P_PER_INFORMATION1 in VARCHAR2
353 ,P_PER_INFORMATION2 in VARCHAR2
354 ,P_PER_INFORMATION3 in VARCHAR2
355 ,P_PER_INFORMATION4 in VARCHAR2
356 ,P_PER_INFORMATION5 in VARCHAR2
357 ,P_PER_INFORMATION6 in VARCHAR2
358 ,P_PER_INFORMATION7 in VARCHAR2
359 ,P_PER_INFORMATION8 in VARCHAR2
360 ,P_PER_INFORMATION9 in VARCHAR2
361 ,P_PER_INFORMATION10 in VARCHAR2
362 ,P_PER_INFORMATION11 in VARCHAR2
363 ,P_PER_INFORMATION12 in VARCHAR2
364 ,P_PER_INFORMATION13 in VARCHAR2
365 ,P_PER_INFORMATION14 in VARCHAR2
366 ,P_PER_INFORMATION15 in VARCHAR2
367 ,P_PER_INFORMATION16 in VARCHAR2
368 ,P_PER_INFORMATION17 in VARCHAR2
369 ,P_PER_INFORMATION18 in VARCHAR2
370 ,P_PER_INFORMATION19 in VARCHAR2
371 ,P_PER_INFORMATION20 in VARCHAR2
372 ,P_PER_INFORMATION21 in VARCHAR2
373 ,P_PER_INFORMATION22 in VARCHAR2
374 ,P_PER_INFORMATION23 in VARCHAR2
375 ,P_PER_INFORMATION24 in VARCHAR2
376 ,P_PER_INFORMATION25 in VARCHAR2
377 ,P_PER_INFORMATION26 in VARCHAR2
378 ,P_PER_INFORMATION27 in VARCHAR2
379 ,P_PER_INFORMATION28 in VARCHAR2
380 ,P_PER_INFORMATION29 in VARCHAR2
381 ,P_PER_INFORMATION30 in VARCHAR2
382 ,P_BACKGROUND_CHECK_STATUS in VARCHAR2
383 ,P_BACKGROUND_DATE_CHECK in DATE
384 ,P_CORRESPONDENCE_LANGUAGE in VARCHAR2
385 ,P_FTE_CAPACITY in NUMBER
386 ,P_HOLD_APPLICANT_DATE_UNTIL in DATE
387 ,P_HONORS in VARCHAR2
388 ,P_MAILSTOP in VARCHAR2
389 ,P_OFFICE_NUMBER in VARCHAR2
390 ,P_ON_MILITARY_SERVICE in VARCHAR2
391 ,P_PRE_NAME_ADJUNCT in VARCHAR2
392 ,P_PROJECTED_START_DATE in DATE
393 ,P_RESUME_EXISTS in VARCHAR2
394 ,P_RESUME_LAST_UPDATED in DATE
395 ,P_STUDENT_STATUS in VARCHAR2
396 ,P_WORK_SCHEDULE in VARCHAR2
397 ,P_SUFFIX in VARCHAR2
398 ,P_DATE_OF_DEATH in DATE
399 ,P_BENEFIT_GROUP_ID in NUMBER
400 ,P_RECEIPT_OF_DEATH_CERT_DATE in DATE
401 ,P_COORD_BEN_MED_PLN_NO in VARCHAR2
402 ,P_COORD_BEN_NO_CVG_FLAG in VARCHAR2
403 ,P_USES_TOBACCO_FLAG in VARCHAR2
404 ,P_DPDNT_ADOPTION_DATE in DATE
405 ,P_DPDNT_VLNTRY_SVCE_FLAG in VARCHAR2
406 ,P_ORIGINAL_DATE_OF_HIRE in DATE
407 ,P_TOWN_OF_BIRTH in VARCHAR2
408 ,P_REGION_OF_BIRTH in VARCHAR2
409 ,P_COUNTRY_OF_BIRTH in VARCHAR2
410 ,P_GLOBAL_PERSON_ID in VARCHAR2
411 ,P_PARTY_ID in VARCHAR2
412 ,P_VACANCY_ID in NUMBER
413 )is
414 l_commit_unit_number number;
415 l_legislation_code   varchar2(30);
416 begin
417 hr_utility.set_location('Entering: HR_APPLICANT_BK1.CREATE_APPLICANT_B', 10);
418 l_commit_unit_number := hr_api.return_commit_unit;
419 if hr_api.call_leg_hooks then
420 l_legislation_code := hr_api.return_legislation_code(p_business_group_id => P_BUSINESS_GROUP_ID);
421 if l_legislation_code = 'AE' then
422 HR_AE_VALIDATE_PKG.APPLICANT_VALIDATE
423 (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
424 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
425 ,P_DATE_RECEIVED => P_DATE_RECEIVED
426 ,P_SEX => P_SEX
427 ,P_FIRST_NAME => P_FIRST_NAME
428 ,P_LAST_NAME => P_LAST_NAME
429 ,P_NATIONALITY => P_NATIONALITY
430 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
431 ,P_TITLE => P_TITLE
432 ,P_MARITAL_STATUS => P_MARITAL_STATUS
433 ,P_PER_INFORMATION_CATEGORY => P_PER_INFORMATION_CATEGORY
434 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
435 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
436 ,P_PER_INFORMATION3 => P_PER_INFORMATION3
437 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
438 ,P_PER_INFORMATION5 => P_PER_INFORMATION5
439 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
440 ,P_PER_INFORMATION7 => P_PER_INFORMATION7
441 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
442 ,P_PER_INFORMATION9 => P_PER_INFORMATION9
443 ,P_PER_INFORMATION10 => P_PER_INFORMATION10
444 ,P_PER_INFORMATION11 => P_PER_INFORMATION11
445 ,P_PER_INFORMATION12 => P_PER_INFORMATION12
446 ,P_PER_INFORMATION13 => P_PER_INFORMATION13
447 ,P_PER_INFORMATION14 => P_PER_INFORMATION14
448 ,P_PER_INFORMATION15 => P_PER_INFORMATION15
449 ,P_PER_INFORMATION16 => P_PER_INFORMATION16
450 ,P_PER_INFORMATION17 => P_PER_INFORMATION17
451 ,P_PER_INFORMATION18 => P_PER_INFORMATION18
452 ,P_PER_INFORMATION19 => P_PER_INFORMATION19
453 ,P_PER_INFORMATION20 => P_PER_INFORMATION20
454 );
455 elsif l_legislation_code = 'CN' then
456 PER_CN_EMP_LEG_HOOK.CHECK_APPLICANT
457 (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
458 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
459 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
460 ,P_DATE_RECEIVED => P_DATE_RECEIVED
461 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
462 ,P_PER_INFORMATION5 => P_PER_INFORMATION5
463 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
464 ,P_PER_INFORMATION7 => P_PER_INFORMATION7
465 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
466 ,P_PER_INFORMATION10 => P_PER_INFORMATION10
467 ,P_PER_INFORMATION11 => P_PER_INFORMATION11
468 ,P_PER_INFORMATION12 => P_PER_INFORMATION12
469 ,P_PER_INFORMATION17 => P_PER_INFORMATION17
470 );
471 elsif l_legislation_code = 'DK' then
472 HR_DK_VALIDATE_PKG.APPLICANT_VALIDATE
473 (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
474 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
475 ,P_FIRST_NAME => P_FIRST_NAME
476 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
477 );
478 elsif l_legislation_code = 'ES' then
479 PER_ES_CREATE_APPLICANT.CREATE_ES_APPLICANT
480 (P_LAST_NAME => P_LAST_NAME
481 ,P_FIRST_NAME => P_FIRST_NAME
482 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
483 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
484 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
485 ,P_PER_INFORMATION3 => P_PER_INFORMATION3
486 );
487 elsif l_legislation_code = 'FI' then
488 HR_FI_VALIDATE_PKG.APPLICANT_VALIDATE
489 (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
490 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
491 ,P_FIRST_NAME => P_FIRST_NAME
492 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
493 ,P_DATE_OF_BIRTH => P_DATE_OF_BIRTH
494 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
495 );
496 elsif l_legislation_code = 'HU' then
497 PER_HU_CREATE_APPLICANT.CREATE_HU_APPLICANT
498 (P_LAST_NAME => P_LAST_NAME
499 ,P_FIRST_NAME => P_FIRST_NAME
500 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
501 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
502 );
503 elsif l_legislation_code = 'IT' then
504 HR_IT_EXTRA_PERSON_RULES.EXTRA_CREATE_PERSON_CHECKS
505 (P_PER_INFORMATION2 => P_PER_INFORMATION2
506 ,P_USES_TOBACCO_FLAG => P_USES_TOBACCO_FLAG
507 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
508 );
509 elsif l_legislation_code = 'KW' then
510 HR_KW_VALIDATE_PKG.APPLICANT_VALIDATE
511 (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
512 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
513 ,P_DATE_RECEIVED => P_DATE_RECEIVED
514 ,P_SEX => P_SEX
515 ,P_FIRST_NAME => P_FIRST_NAME
516 ,P_NATIONALITY => P_NATIONALITY
517 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
518 ,P_TITLE => P_TITLE
519 ,P_PER_INFORMATION_CATEGORY => P_PER_INFORMATION_CATEGORY
520 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
521 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
522 ,P_PER_INFORMATION3 => P_PER_INFORMATION3
523 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
524 ,P_PER_INFORMATION5 => P_PER_INFORMATION5
525 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
526 ,P_PER_INFORMATION7 => P_PER_INFORMATION7
527 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
528 ,P_PER_INFORMATION9 => P_PER_INFORMATION9
529 ,P_PER_INFORMATION10 => P_PER_INFORMATION10
530 );
531 elsif l_legislation_code = 'NO' then
532 HR_NO_VALIDATE_PKG.APPLICANT_VALIDATE
533 (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
534 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
535 ,P_FIRST_NAME => P_FIRST_NAME
536 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
537 );
538 elsif l_legislation_code = 'PL' then
539 PER_PL_CREATE_APPLICANT.CREATE_PL_APPLICANT
540 (P_LAST_NAME => P_LAST_NAME
541 ,P_FIRST_NAME => P_FIRST_NAME
542 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
543 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
544 ,P_NATIONALITY => P_NATIONALITY
545 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
546 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
547 ,P_PER_INFORMATION3 => P_PER_INFORMATION3
548 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
549 ,P_PER_INFORMATION5 => P_PER_INFORMATION5
550 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
551 ,P_PER_INFORMATION7 => P_PER_INFORMATION7
552 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
553 );
554 elsif l_legislation_code = 'RU' then
555 HR_RU_PEOPLE_LEG_HOOK.CREATE_RU_APPLICANT
556 (P_FIRST_NAME => P_FIRST_NAME
557 ,P_DATE_RECEIVED => P_DATE_RECEIVED
558 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
559 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
560 ,P_PER_INFORMATION5 => P_PER_INFORMATION5
561 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
562 ,P_PER_INFORMATION7 => P_PER_INFORMATION7
563 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
564 ,P_PER_INFORMATION9 => P_PER_INFORMATION9
565 ,P_PER_INFORMATION10 => P_PER_INFORMATION10
566 ,P_PER_INFORMATION11 => P_PER_INFORMATION11
567 ,P_PER_INFORMATION12 => P_PER_INFORMATION12
568 ,P_PER_INFORMATION13 => P_PER_INFORMATION13
569 ,P_PER_INFORMATION14 => P_PER_INFORMATION14
570 ,P_PER_INFORMATION15 => P_PER_INFORMATION15
571 ,P_PER_INFORMATION18 => P_PER_INFORMATION18
572 );
573 elsif l_legislation_code = 'SA' then
574 HR_SA_VALIDATE_PKG.APPLICANT_VALIDATE
575 (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
576 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
577 ,P_DATE_RECEIVED => P_DATE_RECEIVED
578 ,P_SEX => P_SEX
579 ,P_FIRST_NAME => P_FIRST_NAME
580 ,P_NATIONALITY => P_NATIONALITY
581 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
582 ,P_TITLE => P_TITLE
583 ,P_PER_INFORMATION_CATEGORY => P_PER_INFORMATION_CATEGORY
584 ,P_PER_INFORMATION1 => P_PER_INFORMATION1
585 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
586 ,P_PER_INFORMATION3 => P_PER_INFORMATION3
587 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
588 ,P_PER_INFORMATION5 => P_PER_INFORMATION5
589 ,P_PER_INFORMATION6 => P_PER_INFORMATION6
590 ,P_PER_INFORMATION7 => P_PER_INFORMATION7
591 ,P_PER_INFORMATION8 => P_PER_INFORMATION8
592 ,P_PER_INFORMATION9 => P_PER_INFORMATION9
593 ,P_PER_INFORMATION10 => P_PER_INFORMATION10
594 );
595 elsif l_legislation_code = 'SE' then
596 HR_SE_VALIDATE_PKG.APPLICANT_VALIDATE
597 (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
598 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
599 ,P_FIRST_NAME => P_FIRST_NAME
600 ,P_NATIONAL_IDENTIFIER => P_NATIONAL_IDENTIFIER
601 );
602 elsif l_legislation_code = 'ZA' then
603 PER_ZA_USER_HOOK_PKG.VALIDATE_APPLICANT
604 (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
605 ,P_DATE_RECEIVED => P_DATE_RECEIVED
606 ,P_PERSON_TYPE_ID => P_PERSON_TYPE_ID
607 ,P_PER_INFORMATION_CATEGORY => P_PER_INFORMATION_CATEGORY
608 ,P_PER_INFORMATION2 => P_PER_INFORMATION2
609 ,P_PER_INFORMATION4 => P_PER_INFORMATION4
610 ,P_PER_INFORMATION10 => P_PER_INFORMATION10
611 ,P_EMAIL_ADDRESS => P_EMAIL_ADDRESS
612 );
613 end if;
614 end if;
615 hr_api.validate_commit_unit(l_commit_unit_number, 'CREATE_APPLICANT', 'BP');
616 hr_utility.set_location(' Leaving: HR_APPLICANT_BK1.CREATE_APPLICANT_B', 20);
617 end CREATE_APPLICANT_B;
618 end HR_APPLICANT_BK1;