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_CONTINGENT_WORKER_BK1

Source


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