[Home] [Help]
PACKAGE BODY: APPS.HR_JPBP_API
Source
1 Package Body HR_JPBP_API as
2 /* $Header: pejpapi.pkb 120.0 2005/05/30 21:10:57 appldev noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' HR_JPBP_API.';
7 --
8 --
9 -- ----------------------------------------------------------------------------
10 -- |------------------------<chk_school_id_school_name_comb >----------------|
11 -- ----------------------------------------------------------------------------
12
13 procedure chk_school_id_school_name_comb(
14 p_school_id in out nocopy per_analysis_criteria.segment2%TYPE,
15 p_school_name in out nocopy per_analysis_criteria.segment3%TYPE,
16 p_school_name_kana in out nocopy per_analysis_criteria.segment4%TYPE,
17 p_major in out nocopy per_analysis_criteria.segment5%TYPE,
18 p_major_kana in out nocopy per_analysis_criteria.segment6%TYPE) is
19
20
21 l_proc varchar2(72) := g_package||'chk_school_id_name_comb';
22 --
23 cursor c1 is
24 select * from per_jp_school_lookups
25 where school_id = p_school_id;
26 --
27 cursor c2 is
28 select * from per_jp_school_lookups
29 where school_name = p_school_name
30 and nvl(major,hr_api.g_varchar2)= nvl(p_major,hr_api.g_varchar2);
31 --
32 jp_school_rec per_jp_school_lookups%rowtype;
33
34
35 begin
36 hr_utility.set_location('Entering:'|| l_proc, 10);
37
38 --
39 -- If school_id is not null, get school info with school_id.
40 --
41 if p_school_id is not null then
42 hr_utility.set_location(l_proc, 20);
43 open c1;
44 fetch c1 into jp_school_rec;
45 if c1%notfound then
46 close c1;
47 hr_utility.set_message(801, 'HR_72011_API_INVALID_SCL_ID');
48 hr_utility.raise_error;
49 end if;
50 close c1;
51
52 --
53 -- If p_school_name is null, set the school name.
54 --
55 if p_school_name is null then
56 p_school_name := jp_school_rec.school_name;
57 end if;
58
59 --
60 -- If p_major is null, set the major.
61 --
62 if p_major is null then
63 p_major := jp_school_rec.major;
64 end if;
65
66 --
67 -- If school_name is not null, get school info
68 -- with p_school_name, p_major.
69 --
70 elsif p_school_name is not null then
71 hr_utility.set_location(l_proc, 30);
72 open c2;
73 fetch c2 into jp_school_rec;
74 if c2%notfound then
75 close c2;
76 hr_utility.set_message(801, 'HR_72014_API_INVALID_NAME_MAJR');
77 hr_utility.raise_error;
78 end if;
79 --
80 -- Check dupulication
81 --
82 fetch c2 into jp_school_rec;
83 if c2%found then
84 close c2;
85 hr_utility.set_message(801, 'HR_72014_API_INVALID_NAME_MAJR');
86 hr_utility.raise_error;
87 end if;
88 close c2;
89
90 --
91 -- Set the school_id since p_school_id is null.
92 --
93 p_school_id := jp_school_rec.school_id;
94
95 --
96 -- both school_id and school_name is null
97 --
98 else
99 hr_utility.set_message(801, 'HR_72015_API_SCL_ID_NAME_NULL');
100 hr_utility.raise_error;
101 end if;
102
103 --
104 -- If p_school_name_kana is null, set the school name kana.
105 --
106 if p_school_name_kana is null then
107 p_school_name_kana := jp_school_rec.school_name_kana;
108 end if;
109
110 --
111 -- If p_major_kana is null, set the major kana.
112 --
113 if p_major_kana is null then
114 p_major_kana := jp_school_rec.major_kana;
115 end if;
116 --
117 --
118 hr_utility.set_location('Leaving:'|| l_proc, 40);
119 end chk_school_id_school_name_comb;
120 --
121 -- ----------------------------------------------------------------------------
122 -- |-----------------------------< create_jp_educ_sit >-----------------------|
123 -- ----------------------------------------------------------------------------
124 procedure create_jp_educ_sit
125 ( p_validate in boolean default false
126 ,p_person_id in number
127 ,p_business_group_id in number
128 ,p_effective_date in date
129 ,p_comments in varchar2 default null
130 ,p_date_from in date default null
131 ,p_date_to in date default null
132 ,p_attribute_category in varchar2 default null
133 ,p_attribute1 in varchar2 default null
134 ,p_attribute2 in varchar2 default null
135 ,p_attribute3 in varchar2 default null
136 ,p_attribute4 in varchar2 default null
137 ,p_attribute5 in varchar2 default null
138 ,p_attribute6 in varchar2 default null
139 ,p_attribute7 in varchar2 default null
140 ,p_attribute8 in varchar2 default null
141 ,p_attribute9 in varchar2 default null
142 ,p_attribute10 in varchar2 default null
143 ,p_attribute11 in varchar2 default null
144 ,p_attribute12 in varchar2 default null
145 ,p_attribute13 in varchar2 default null
146 ,p_attribute14 in varchar2 default null
147 ,p_attribute15 in varchar2 default null
148 ,p_attribute16 in varchar2 default null
149 ,p_attribute17 in varchar2 default null
150 ,p_attribute18 in varchar2 default null
151 ,p_attribute19 in varchar2 default null
152 ,p_attribute20 in varchar2 default null
153 ,p_segment1 in varchar2 default null
154 ,p_segment2 in varchar2 default null
155 ,p_segment3 in varchar2 default null
156 ,p_segment4 in varchar2 default null
157 ,p_segment5 in varchar2 default null
158 ,p_segment6 in varchar2 default null
159 ,p_segment7 in varchar2 default null
160 ,p_segment8 in varchar2 default null
161 ,p_segment9 in varchar2 default null
162 ,p_segment10 in varchar2 default null
163 ,p_segment11 in varchar2 default null
164 ,p_segment12 in varchar2 default null
165 ,p_segment13 in varchar2 default null
166 ,p_segment14 in varchar2 default null
167 ,p_segment15 in varchar2 default null
168 ,p_segment16 in varchar2 default null
169 ,p_segment17 in varchar2 default null
170 ,p_segment18 in varchar2 default null
171 ,p_segment19 in varchar2 default null
172 ,p_segment20 in varchar2 default null
173 ,p_segment21 in varchar2 default null
174 ,p_segment22 in varchar2 default null
175 ,p_segment23 in varchar2 default null
176 ,p_segment24 in varchar2 default null
177 ,p_segment25 in varchar2 default null
178 ,p_segment26 in varchar2 default null
179 ,p_segment27 in varchar2 default null
180 ,p_segment28 in varchar2 default null
181 ,p_segment29 in varchar2 default null
182 ,p_segment30 in varchar2 default null
183 ,p_analysis_criteria_id out nocopy number
184 ,p_person_analysis_id out nocopy number
185 ,p_pea_object_version_number out nocopy number
186 ) is
187 --
188 l_proc varchar2(72) := g_package||'create_jp_educ_sit';
189 l_exists varchar2(2);
190 l_id_flex_num fnd_id_flex_structures.id_flex_num%TYPE := 1;
191 l_legislation_code per_business_groups.legislation_code%TYPE;
192 l_segment2 per_analysis_criteria.segment2%TYPE := p_segment2;
193 l_segment3 per_analysis_criteria.segment3%TYPE := p_segment3;
194 l_segment4 per_analysis_criteria.segment4%TYPE := p_segment4;
195 l_segment5 per_analysis_criteria.segment5%TYPE := p_segment5;
196 l_segment6 per_analysis_criteria.segment6%TYPE := p_segment6;
197 --
198 cursor csr_bg is
199 select legislation_code
200 from per_business_groups pbg
201 where pbg.business_group_id = p_business_group_id;
202 --
203
204 begin
205 hr_utility.set_location('Entering:'|| l_proc, 5);
206 --
207 -- Validation in addition to Table Handlers
208 --
209 -- Check that the specified business group is valid.
210 --
211 hr_utility.set_location(l_proc, 10);
212 open csr_bg;
213 fetch csr_bg into l_legislation_code;
214 if csr_bg%notfound then
215 close csr_bg;
216 hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
217 hr_utility.raise_error;
218 else
219 if l_legislation_code <> 'JP' then
220 hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
221 hr_utility.set_message_token('LEG_CODE','JP');
222 hr_utility.raise_error;
223 end if;
224 end if;
225 close csr_bg;
226
227 --
228 -- Check the validity of the combination for p_segment2 to p_segment6 and
229 -- poplulate them.
230 --
231 if not (l_segment2 is null and l_segment3 is null and
232 l_segment4 is null and l_segment5 is null and
233 l_segment6 is null ) then
234 --
235 chk_school_id_school_name_comb
236 (p_school_id => l_segment2
237 ,p_school_name => l_segment3
238 ,p_school_name_kana => l_segment4
239 ,p_major => l_segment5
240 ,p_major_kana => l_segment6
241 );
242 --
243 end if;
244
245 hr_utility.set_location(l_proc, 40);
246 --
247 -- Call create_sit
248 hr_sit_api.create_sit
249 (p_validate => p_validate
250 ,p_person_id => p_person_id
251 ,p_business_group_id => p_business_group_id
252 ,p_id_flex_num => l_id_flex_num
253 ,p_effective_date => p_effective_date
254 ,p_comments => p_comments
255 ,p_date_from => p_date_from
256 ,p_date_to => p_date_to
257 ,p_attribute_category => p_attribute_category
258 ,p_attribute1 => p_attribute1
259 ,p_attribute2 => p_attribute2
260 ,p_attribute3 => p_attribute3
261 ,p_attribute4 => p_attribute4
262 ,p_attribute5 => p_attribute5
263 ,p_attribute6 => p_attribute6
264 ,p_attribute7 => p_attribute7
265 ,p_attribute8 => p_attribute8
266 ,p_attribute9 => p_attribute9
267 ,p_attribute10 => p_attribute10
268 ,p_attribute11 => p_attribute11
269 ,p_attribute12 => p_attribute12
270 ,p_attribute13 => p_attribute13
271 ,p_attribute14 => p_attribute14
272 ,p_attribute15 => p_attribute15
273 ,p_attribute16 => p_attribute16
274 ,p_attribute17 => p_attribute17
275 ,p_attribute18 => p_attribute18
276 ,p_attribute19 => p_attribute19
277 ,p_attribute20 => p_attribute20
278 ,p_segment1 => p_segment1
279 ,p_segment2 => l_segment2
280 ,p_segment3 => l_segment3
281 ,p_segment4 => l_segment4
282 ,p_segment5 => l_segment5
283 ,p_segment6 => l_segment6
284 ,p_segment7 => p_segment7
285 ,p_segment8 => p_segment8
286 ,p_segment9 => p_segment9
287 ,p_segment10 => p_segment10
288 ,p_segment11 => p_segment11
289 ,p_segment12 => p_segment12
290 ,p_segment13 => p_segment13
291 ,p_segment14 => p_segment14
292 ,p_segment15 => p_segment15
293 ,p_segment16 => p_segment16
294 ,p_segment17 => p_segment17
295 ,p_segment18 => p_segment18
296 ,p_segment19 => p_segment19
297 ,p_segment20 => p_segment20
298 ,p_segment21 => p_segment21
299 ,p_segment22 => p_segment22
300 ,p_segment23 => p_segment23
301 ,p_segment24 => p_segment24
302 ,p_segment25 => p_segment25
303 ,p_segment26 => p_segment26
304 ,p_segment27 => p_segment27
305 ,p_segment28 => p_segment28
306 ,p_segment29 => p_segment29
307 ,p_segment30 => p_segment30
308 ,p_analysis_criteria_id => p_analysis_criteria_id
309 ,p_person_analysis_id => p_person_analysis_id
310 ,p_pea_object_version_number => p_pea_object_version_number
311 );
312 --
313 hr_utility.set_location('Leaving:'|| l_proc, 50);
314 end create_jp_educ_sit;
315 -- ----------------------------------------------------------------------------
316 -- |---------------------< create_jp_employee_with_sit >----------------------|
317 -- ----------------------------------------------------------------------------
318 --
319 procedure create_jp_employee_with_sit
320 (
321 -- for per_people_f
322 --
323 p_validate in boolean default false
324 ,p_hire_date in date
325 ,p_business_group_id in number
326 ,p_last_name in varchar2
327 ,p_last_name_kana in varchar2
328 ,p_sex in varchar2
329 ,p_person_type_id in number default null
330 ,p_per_comments in varchar2 default null
331 ,p_date_employee_data_verified in date default null
332 ,p_date_of_birth in date default null
333 ,p_email_address in varchar2 default null
334 ,p_employee_number in out nocopy varchar2
335 ,p_expense_check_send_to_addres in varchar2 default null
336 ,p_first_name in varchar2 default null
337 ,p_first_name_kana in varchar2 default null
338 ,p_known_as in varchar2 default null
339 ,p_marital_status in varchar2 default null
340 ,p_middle_names in varchar2 default null
341 ,p_nationality in varchar2 default null
342 ,p_national_identifier in varchar2 default null
343 ,p_previous_last_name in varchar2 default null
344 ,p_previous_last_name_kana in varchar2 default null
345 ,p_registered_disabled_flag in varchar2 default null
346 ,p_title in varchar2 default null
347 ,p_vendor_id in number default null
348 ,p_work_telephone in varchar2 default null
349 ,p_per_attribute_category in varchar2 default null
350 ,p_per_attribute1 in varchar2 default null
351 ,p_per_attribute2 in varchar2 default null
352 ,p_per_attribute3 in varchar2 default null
353 ,p_per_attribute4 in varchar2 default null
354 ,p_per_attribute5 in varchar2 default null
355 ,p_per_attribute6 in varchar2 default null
356 ,p_per_attribute7 in varchar2 default null
357 ,p_per_attribute8 in varchar2 default null
358 ,p_per_attribute9 in varchar2 default null
359 ,p_per_attribute10 in varchar2 default null
360 ,p_per_attribute11 in varchar2 default null
361 ,p_per_attribute12 in varchar2 default null
362 ,p_per_attribute13 in varchar2 default null
363 ,p_per_attribute14 in varchar2 default null
364 ,p_per_attribute15 in varchar2 default null
365 ,p_per_attribute16 in varchar2 default null
366 ,p_per_attribute17 in varchar2 default null
367 ,p_per_attribute18 in varchar2 default null
368 ,p_per_attribute19 in varchar2 default null
369 ,p_per_attribute20 in varchar2 default null
370 ,p_per_attribute21 in varchar2 default null
371 ,p_per_attribute22 in varchar2 default null
372 ,p_per_attribute23 in varchar2 default null
373 ,p_per_attribute24 in varchar2 default null
374 ,p_per_attribute25 in varchar2 default null
375 ,p_per_attribute26 in varchar2 default null
376 ,p_per_attribute27 in varchar2 default null
377 ,p_per_attribute28 in varchar2 default null
378 ,p_per_attribute29 in varchar2 default null
379 ,p_per_attribute30 in varchar2 default null
380 ,p_date_of_death in date default null
381 ,p_blood_type in varchar2 default null
382 ,p_correspondence_language in varchar2 default null
383 ,p_fte_capacity in number default null
384 ,p_honors in varchar2 default null
385 ,p_internal_location in varchar2 default null
386 ,p_last_medical_test_by in varchar2 default null
387 ,p_last_medical_test_date in date default null
388 ,p_mailstop in varchar2 default null
389 ,p_office_number in varchar2 default null
390 ,p_on_military_service in varchar2 default null
391 ,p_resume_exists in varchar2 default null
392 ,p_resume_last_updated in date default null
393 ,p_second_passport_exists in varchar2 default null
394 ,p_student_status in varchar2 default null
395 ,p_work_schedule in varchar2 default null
396 ,p_original_date_of_hire in date default null
397 ,p_person_id out nocopy number
398 ,p_assignment_id out nocopy number
399 ,p_per_object_version_number out nocopy number
400 ,p_asg_object_version_number out nocopy number
401 ,p_per_effective_start_date out nocopy date
402 ,p_per_effective_end_date out nocopy date
403 ,p_full_name out nocopy varchar2
404 ,p_per_comment_id out nocopy number
405 ,p_assignment_sequence out nocopy number
406 ,p_assignment_number out nocopy varchar2
407 ,p_name_combination_warning out nocopy boolean
408 ,p_assign_payroll_warning out nocopy boolean
409 ,p_orig_hire_warning out nocopy boolean
410 --
411 -- for special information
412 --
413 ,p_id_flex_num in number
414 ,p_pea_comments in varchar2 default null
415 ,p_date_from in date default null
416 ,p_date_to in date default null
417 ,p_pea_attribute_category in varchar2 default null
418 ,p_pea_attribute1 in varchar2 default null
419 ,p_pea_attribute2 in varchar2 default null
420 ,p_pea_attribute3 in varchar2 default null
421 ,p_pea_attribute4 in varchar2 default null
422 ,p_pea_attribute5 in varchar2 default null
423 ,p_pea_attribute6 in varchar2 default null
424 ,p_pea_attribute7 in varchar2 default null
425 ,p_pea_attribute8 in varchar2 default null
426 ,p_pea_attribute9 in varchar2 default null
427 ,p_pea_attribute10 in varchar2 default null
428 ,p_pea_attribute11 in varchar2 default null
429 ,p_pea_attribute12 in varchar2 default null
430 ,p_pea_attribute13 in varchar2 default null
431 ,p_pea_attribute14 in varchar2 default null
432 ,p_pea_attribute15 in varchar2 default null
433 ,p_pea_attribute16 in varchar2 default null
434 ,p_pea_attribute17 in varchar2 default null
435 ,p_pea_attribute18 in varchar2 default null
436 ,p_pea_attribute19 in varchar2 default null
437 ,p_pea_attribute20 in varchar2 default null
438 ,p_segment1 in varchar2 default null
439 ,p_segment2 in varchar2 default null
440 ,p_segment3 in varchar2 default null
441 ,p_segment4 in varchar2 default null
442 ,p_segment5 in varchar2 default null
443 ,p_segment6 in varchar2 default null
444 ,p_segment7 in varchar2 default null
445 ,p_segment8 in varchar2 default null
446 ,p_segment9 in varchar2 default null
447 ,p_segment10 in varchar2 default null
448 ,p_segment11 in varchar2 default null
449 ,p_segment12 in varchar2 default null
450 ,p_segment13 in varchar2 default null
451 ,p_segment14 in varchar2 default null
452 ,p_segment15 in varchar2 default null
453 ,p_segment16 in varchar2 default null
454 ,p_segment17 in varchar2 default null
455 ,p_segment18 in varchar2 default null
456 ,p_segment19 in varchar2 default null
457 ,p_segment20 in varchar2 default null
458 ,p_segment21 in varchar2 default null
459 ,p_segment22 in varchar2 default null
460 ,p_segment23 in varchar2 default null
461 ,p_segment24 in varchar2 default null
462 ,p_segment25 in varchar2 default null
463 ,p_segment26 in varchar2 default null
464 ,p_segment27 in varchar2 default null
465 ,p_segment28 in varchar2 default null
466 ,p_segment29 in varchar2 default null
467 ,p_segment30 in varchar2 default null
468 ,p_pea_object_version_number out nocopy number
469 ,p_analysis_criteria_id out nocopy number
470 ,p_person_analysis_id out nocopy number
471
472 /* Additional parameters for Bug:4161160 */
473
474 ,p_english_last_name in varchar2 default null
475 ,p_english_first_name in varchar2 default null
476 ,p_per_information23 in varchar2 default null
477 ,p_per_information24 in varchar2 default null
478 ,p_per_information25 in varchar2 default null
479 ,p_per_information26 in varchar2 default null
480 ,p_per_information27 in varchar2 default null
481 ,p_per_information28 in varchar2 default null
482 ,p_per_information29 in varchar2 default null
483 ,p_per_information30 in varchar2 default null
484 ) is
485 --
486 -- Declare cursors and local variables
487 --
488 l_person_id number;
489 l_employee_number per_all_people_f.employee_number%TYPE;
490 l_proc varchar2(72) := g_package||'create_jp_employee_with_sit';
491 l_legislation_code varchar2(150);
492 --
493 cursor csr_bg is
494 select legislation_code
495 from per_business_groups pbg
496 where pbg.business_group_id = p_business_group_id;
497 --
498
499 begin
500 hr_utility.set_location('Entering:'|| l_proc, 5);
501 --
502 -- Issue a savepoint
503 --
504 savepoint create_jp_employee_with_sit;
505
506 hr_utility.set_location(l_proc, 10);
507 --
508 -- Validation in addition to Row Handlers
509 --
510 -- Check that the specified business group is valid.
511 --
512 hr_utility.set_location(l_proc, 20);
513 open csr_bg;
514 fetch csr_bg into l_legislation_code;
515 if csr_bg%notfound then
516 close csr_bg;
517 hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
518 hr_utility.raise_error;
519 else
520 if l_legislation_code <> 'JP' then
521 close csr_bg;
522 hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
523 hr_utility.set_message_token('LEG_CODE','JP');
524 hr_utility.raise_error;
525 end if;
526 end if;
527 close csr_bg;
528
529 l_employee_number := p_employee_number;
530 --
531 hr_utility.set_location(l_proc, 30);
532 --
533 -- Process Logic
534 --
535 -- Call the person business process
536 --
537 hr_employee_api.create_employee
538 (p_validate => false
539 ,p_hire_date => p_hire_date
540 ,p_business_group_id => p_business_group_id
541 ,p_last_name => p_last_name_kana
542 ,p_sex => p_sex
543 ,p_person_type_id => p_person_type_id
544 ,p_per_comments => p_per_comments
545 ,p_date_employee_data_verified => p_date_employee_data_verified
546 ,p_date_of_birth => p_date_of_birth
547 ,p_email_address => p_email_address
548 ,p_employee_number => p_employee_number
549 ,p_expense_check_send_to_addres => p_expense_check_send_to_addres
550 ,p_first_name => p_first_name_kana
551 ,p_known_as => p_known_as
552 ,p_marital_status => p_marital_status
553 ,p_middle_names => p_middle_names
554 ,p_nationality => p_nationality
555 ,p_national_identifier => p_national_identifier
556 ,p_previous_last_name => p_previous_last_name_kana
557 ,p_registered_disabled_flag => p_registered_disabled_flag
558 ,p_title => p_title
559 ,p_vendor_id => p_vendor_id
560 ,p_work_telephone => p_work_telephone
561 ,p_attribute_category => p_per_attribute_category
562 ,p_attribute1 => p_per_attribute1
563 ,p_attribute2 => p_per_attribute2
564 ,p_attribute3 => p_per_attribute3
565 ,p_attribute4 => p_per_attribute4
566 ,p_attribute5 => p_per_attribute5
567 ,p_attribute6 => p_per_attribute6
568 ,p_attribute7 => p_per_attribute7
569 ,p_attribute8 => p_per_attribute8
570 ,p_attribute9 => p_per_attribute9
571 ,p_attribute10 => p_per_attribute10
572 ,p_attribute11 => p_per_attribute11
573 ,p_attribute12 => p_per_attribute12
574 ,p_attribute13 => p_per_attribute13
575 ,p_attribute14 => p_per_attribute14
576 ,p_attribute15 => p_per_attribute15
577 ,p_attribute16 => p_per_attribute16
578 ,p_attribute17 => p_per_attribute17
579 ,p_attribute18 => p_per_attribute18
580 ,p_attribute19 => p_per_attribute19
581 ,p_attribute20 => p_per_attribute20
582 ,p_attribute21 => p_per_attribute21
583 ,p_attribute22 => p_per_attribute22
584 ,p_attribute23 => p_per_attribute23
585 ,p_attribute24 => p_per_attribute24
586 ,p_attribute25 => p_per_attribute25
587 ,p_attribute26 => p_per_attribute26
588 ,p_attribute27 => p_per_attribute27
589 ,p_attribute28 => p_per_attribute28
590 ,p_attribute29 => p_per_attribute29
591 ,p_attribute30 => p_per_attribute30
592 ,p_per_information_category => 'JP'
593 ,p_per_information1 => null
594 ,p_per_information2 => null
595 ,p_per_information3 => null
596 ,p_per_information4 => null
597 ,p_per_information5 => null
598 ,p_per_information6 => null
599 ,p_per_information7 => null
600 ,p_per_information8 => null
601 ,p_per_information9 => null
602 ,p_per_information10 => null
603 ,p_per_information11 => null
604 ,p_per_information12 => null
605 ,p_per_information13 => null
606 ,p_per_information14 => null
607 ,p_per_information15 => null
608 ,p_per_information16 => null
609 ,p_per_information17 => null
610 ,p_per_information18 => p_last_name
611 ,p_per_information19 => p_first_name
612 ,p_per_information20 => p_previous_last_name
613 ,p_date_of_death => p_date_of_death
614 ,p_blood_type => p_blood_type
615 ,p_correspondence_language => p_correspondence_language
616 ,p_fte_capacity => p_fte_capacity
617 ,p_honors => p_honors
618 ,p_internal_location => p_internal_location
619 ,p_last_medical_test_by => p_last_medical_test_by
620 ,p_last_medical_test_date => p_last_medical_test_date
621 ,p_mailstop => p_mailstop
622 ,p_office_number => p_office_number
623 ,p_on_military_service => p_on_military_service
624 ,p_resume_exists => p_resume_exists
625 ,p_resume_last_updated => p_resume_last_updated
626 ,p_second_passport_exists => p_second_passport_exists
627 ,p_student_status => p_student_status
628 ,p_work_schedule => p_work_schedule
629 ,p_original_date_of_hire => p_original_date_of_hire
630 ,p_person_id => l_person_id
631 ,p_assignment_id => p_assignment_id
632 ,p_per_object_version_number => p_per_object_version_number
633 ,p_asg_object_version_number => p_asg_object_version_number
634 ,p_per_effective_start_date => p_per_effective_start_date
635 ,p_per_effective_end_date => p_per_effective_end_date
636 ,p_full_name => p_full_name
637 ,p_per_comment_id => p_per_comment_id
638 ,p_assignment_sequence => p_assignment_sequence
639 ,p_assignment_number => p_assignment_number
640 ,p_name_combination_warning => p_name_combination_warning
641 ,p_assign_payroll_warning => p_assign_payroll_warning
642 ,p_orig_hire_warning => p_orig_hire_warning
643
644 /* Additional parameters for Bug:4161160 */
645
646 ,p_per_information21 => p_english_last_name
647 ,p_per_information22 => p_english_first_name
648 ,p_per_information23 => p_per_information23
649 ,p_per_information24 => p_per_information24
650 ,p_per_information25 => p_per_information25
651 ,p_per_information26 => p_per_information26
652 ,p_per_information27 => p_per_information27
653 ,p_per_information28 => p_per_information28
654 ,p_per_information29 => p_per_information29
655 ,p_per_information30 => p_per_information30
656 );
657 --
658 hr_utility.set_location(' Leaving:'||l_proc, 40);
659 --
660 -- Create SIT if not all params are set to null.
661 --
662 if not (p_id_flex_num is null
663 and p_pea_comments is null
664 and p_date_from is null
665 and p_date_to is null
666 and p_pea_attribute_category is null
667 and p_pea_attribute1 is null
668 and p_pea_attribute2 is null
669 and p_pea_attribute3 is null
670 and p_pea_attribute4 is null
671 and p_pea_attribute5 is null
672 and p_pea_attribute6 is null
673 and p_pea_attribute7 is null
674 and p_pea_attribute8 is null
675 and p_pea_attribute9 is null
676 and p_pea_attribute10 is null
677 and p_pea_attribute11 is null
678 and p_pea_attribute12 is null
679 and p_pea_attribute13 is null
680 and p_pea_attribute14 is null
681 and p_pea_attribute15 is null
682 and p_pea_attribute16 is null
683 and p_pea_attribute17 is null
684 and p_pea_attribute18 is null
685 and p_pea_attribute19 is null
686 and p_pea_attribute20 is null
687 and p_segment1 is null
688 and p_segment2 is null
689 and p_segment3 is null
690 and p_segment4 is null
691 and p_segment5 is null
692 and p_segment6 is null
693 and p_segment7 is null
694 and p_segment8 is null
695 and p_segment9 is null
696 and p_segment10 is null
697 and p_segment11 is null
698 and p_segment12 is null
699 and p_segment13 is null
700 and p_segment14 is null
701 and p_segment15 is null
702 and p_segment16 is null
703 and p_segment17 is null
704 and p_segment18 is null
705 and p_segment19 is null
706 and p_segment20 is null
707 and p_segment21 is null
708 and p_segment22 is null
709 and p_segment23 is null
710 and p_segment24 is null
711 and p_segment25 is null
712 and p_segment26 is null
713 and p_segment27 is null
714 and p_segment28 is null
715 and p_segment29 is null
716 and p_segment30 is null
717 ) then
718 --
719 hr_utility.set_location(l_proc, 50);
720 --
721 hr_sit_api.create_sit
722 (p_validate => false
723 ,p_person_id => l_person_id
724 ,p_business_group_id => p_business_group_id
725 ,p_id_flex_num => p_id_flex_num
726 ,p_effective_date => p_hire_date
727 ,p_comments => p_per_comments
728 ,p_date_from => p_date_from
729 ,p_date_to => p_date_to
730 ,p_attribute_category => p_pea_attribute_category
731 ,p_attribute1 => p_pea_attribute1
732 ,p_attribute2 => p_pea_attribute2
733 ,p_attribute3 => p_pea_attribute3
734 ,p_attribute4 => p_pea_attribute4
735 ,p_attribute5 => p_pea_attribute5
736 ,p_attribute6 => p_pea_attribute6
737 ,p_attribute7 => p_pea_attribute7
738 ,p_attribute8 => p_pea_attribute8
739 ,p_attribute9 => p_pea_attribute9
740 ,p_attribute10 => p_pea_attribute10
741 ,p_attribute11 => p_pea_attribute11
742 ,p_attribute12 => p_pea_attribute12
743 ,p_attribute13 => p_pea_attribute13
744 ,p_attribute14 => p_pea_attribute14
745 ,p_attribute15 => p_pea_attribute15
746 ,p_attribute16 => p_pea_attribute16
747 ,p_attribute17 => p_pea_attribute17
748 ,p_attribute18 => p_pea_attribute18
749 ,p_attribute19 => p_pea_attribute19
750 ,p_attribute20 => p_pea_attribute20
751 ,p_segment1 => p_segment1
752 ,p_segment2 => p_segment2
753 ,p_segment3 => p_segment3
754 ,p_segment4 => p_segment4
755 ,p_segment5 => p_segment5
756 ,p_segment6 => p_segment6
757 ,p_segment7 => p_segment7
758 ,p_segment8 => p_segment8
759 ,p_segment9 => p_segment9
760 ,p_segment10 => p_segment10
761 ,p_segment11 => p_segment11
762 ,p_segment12 => p_segment12
763 ,p_segment13 => p_segment13
764 ,p_segment14 => p_segment14
765 ,p_segment15 => p_segment15
766 ,p_segment16 => p_segment16
767 ,p_segment17 => p_segment17
768 ,p_segment18 => p_segment18
769 ,p_segment19 => p_segment19
770 ,p_segment20 => p_segment20
771 ,p_segment21 => p_segment21
772 ,p_segment22 => p_segment22
773 ,p_segment23 => p_segment23
774 ,p_segment24 => p_segment24
775 ,p_segment25 => p_segment25
776 ,p_segment26 => p_segment26
777 ,p_segment27 => p_segment27
778 ,p_segment28 => p_segment28
779 ,p_segment29 => p_segment29
780 ,p_segment30 => p_segment30
781 ,p_analysis_criteria_id => p_analysis_criteria_id
782 ,p_person_analysis_id => p_person_analysis_id
783 ,p_pea_object_version_number => p_pea_object_version_number
784 );
785 end if;
786 --
787 -- When in validation only mode raise the Validate_Enabled exception
788 --
789 if p_validate then
790 raise hr_api.validate_enabled;
791 end if;
792 --
793 -- Set all output arguments
794 --
795 p_person_id := l_person_id;
796 --
797 hr_utility.set_location(' Leaving:'||l_proc, 60);
798 exception
799 when hr_api.validate_enabled then
800 --
801 -- As the Validate_Enabled exception has been raised
802 -- we must rollback to the savepoint
803 --
804 ROLLBACK TO create_jp_employee_with_sit;
805 --
806 -- Only set output warning arguments
807 -- (Any key or derived arguments must be set to null
808 -- when validation only mode is being used.)
809 --
810 p_person_id := null;
811 p_assignment_id := null;
812 p_per_object_version_number := null;
813 p_asg_object_version_number := null;
814 p_per_effective_start_date := null;
815 p_per_effective_end_date := null;
816 p_full_name := null;
817 p_per_comment_id := null;
818 p_assignment_sequence := null;
819 p_assignment_number := null;
820
821 p_pea_object_version_number := null;
822 p_analysis_criteria_id := null;
823 p_person_analysis_id := null;
824 when others then
825 --
826 -- A validation or unexpected error has occurred
827 --
828 ROLLBACK TO create_jp_employee_with_sit;
829 --
830 -- Reset IN OUT parameters and set OUT parameters
831 --
832 p_employee_number := l_employee_number;
833
834 p_person_id := null;
835 p_assignment_id := null;
836 p_per_object_version_number := null;
837 p_asg_object_version_number := null;
838 p_per_effective_start_date := null;
839 p_per_effective_end_date := null;
840 p_full_name := null;
841 p_per_comment_id := null;
842 p_assignment_sequence := null;
843 p_assignment_number := null;
844 p_name_combination_warning := null;
845 p_assign_payroll_warning := null;
846 p_orig_hire_warning := null;
847
848 p_pea_object_version_number := null;
849 p_analysis_criteria_id := null;
850 p_person_analysis_id := null;
851
852 hr_utility.set_location(' Leaving:'||l_proc, 70);
853 raise;
854 end create_jp_employee_with_sit;
855 --
856 -- ----------------------------------------------------------------------------
857 -- |------------------< create_jp_emp_with_educ_add >-------------------------|
858 -- ----------------------------------------------------------------------------
859 --
860 procedure create_jp_emp_with_educ_add
861 (
862 -- for per_people_f
863 --
864 p_validate in boolean default false
865 ,p_hire_date in date
866 ,p_business_group_id in number
867 ,p_last_name in varchar2
868 ,p_last_name_kana in varchar2
869 ,p_sex in varchar2
870 ,p_person_type_id in number default null
871 ,p_per_comments in varchar2 default null
872 ,p_date_employee_data_verified in date default null
873 ,p_date_of_birth in date default null
874 ,p_email_address in varchar2 default null
875 ,p_employee_number in out nocopy varchar2
876 ,p_expense_check_send_to_addres in varchar2 default null
877 ,p_first_name in varchar2 default null
878 ,p_first_name_kana in varchar2 default null
879 ,p_known_as in varchar2 default null
880 ,p_marital_status in varchar2 default null
881 ,p_middle_names in varchar2 default null
882 ,p_nationality in varchar2 default null
883 ,p_national_identifier in varchar2 default null
884 ,p_previous_last_name_kana in varchar2 default null
885 ,p_previous_last_name in varchar2 default null
886 ,p_registered_disabled_flag in varchar2 default null
887 ,p_title in varchar2 default null
888 ,p_vendor_id in number default null
889 ,p_work_telephone in varchar2 default null
890 ,p_per_attribute_category in varchar2 default null
891 ,p_per_attribute1 in varchar2 default null
892 ,p_per_attribute2 in varchar2 default null
893 ,p_per_attribute3 in varchar2 default null
894 ,p_per_attribute4 in varchar2 default null
895 ,p_per_attribute5 in varchar2 default null
896 ,p_per_attribute6 in varchar2 default null
897 ,p_per_attribute7 in varchar2 default null
898 ,p_per_attribute8 in varchar2 default null
899 ,p_per_attribute9 in varchar2 default null
900 ,p_per_attribute10 in varchar2 default null
901 ,p_per_attribute11 in varchar2 default null
902 ,p_per_attribute12 in varchar2 default null
903 ,p_per_attribute13 in varchar2 default null
904 ,p_per_attribute14 in varchar2 default null
905 ,p_per_attribute15 in varchar2 default null
906 ,p_per_attribute16 in varchar2 default null
907 ,p_per_attribute17 in varchar2 default null
908 ,p_per_attribute18 in varchar2 default null
909 ,p_per_attribute19 in varchar2 default null
910 ,p_per_attribute20 in varchar2 default null
911 ,p_per_attribute21 in varchar2 default null
912 ,p_per_attribute22 in varchar2 default null
913 ,p_per_attribute23 in varchar2 default null
914 ,p_per_attribute24 in varchar2 default null
915 ,p_per_attribute25 in varchar2 default null
916 ,p_per_attribute26 in varchar2 default null
917 ,p_per_attribute27 in varchar2 default null
918 ,p_per_attribute28 in varchar2 default null
919 ,p_per_attribute29 in varchar2 default null
920 ,p_per_attribute30 in varchar2 default null
921 ,p_date_of_death in date default null
922 ,p_blood_type in varchar2 default null
923 ,p_correspondence_language in varchar2 default null
924 ,p_fte_capacity in number default null
925 ,p_honors in varchar2 default null
926 ,p_internal_location in varchar2 default null
927 ,p_last_medical_test_by in varchar2 default null
928 ,p_last_medical_test_date in date default null
929 ,p_mailstop in varchar2 default null
930 ,p_office_number in varchar2 default null
931 ,p_on_military_service in varchar2 default null
932 ,p_resume_exists in varchar2 default null
933 ,p_resume_last_updated in date default null
934 ,p_second_passport_exists in varchar2 default null
935 ,p_student_status in varchar2 default null
936 ,p_work_schedule in varchar2 default null
937 ,p_original_date_of_hire in date default null
938 ,p_person_id out nocopy number
939 ,p_assignment_id out nocopy number
940 ,p_per_object_version_number out nocopy number
941 ,p_asg_object_version_number out nocopy number
942 ,p_per_effective_start_date out nocopy date
943 ,p_per_effective_end_date out nocopy date
944 ,p_full_name out nocopy varchar2
945 ,p_per_comment_id out nocopy number
946 ,p_assignment_sequence out nocopy number
947 ,p_assignment_number out nocopy varchar2
948 ,p_name_combination_warning out nocopy boolean
949 ,p_assign_payroll_warning out nocopy boolean
950 ,p_orig_hire_warning out nocopy boolean
951 --
952 -- for special information
953 --
954 ,p_pea_comments in varchar2 default null
955 ,p_pea_date_from in date default null
956 ,p_pea_date_to in date default null
957 ,p_pea_attribute_category in varchar2 default null
958 ,p_pea_attribute1 in varchar2 default null
959 ,p_pea_attribute2 in varchar2 default null
960 ,p_pea_attribute3 in varchar2 default null
961 ,p_pea_attribute4 in varchar2 default null
962 ,p_pea_attribute5 in varchar2 default null
963 ,p_pea_attribute6 in varchar2 default null
964 ,p_pea_attribute7 in varchar2 default null
965 ,p_pea_attribute8 in varchar2 default null
966 ,p_pea_attribute9 in varchar2 default null
967 ,p_pea_attribute10 in varchar2 default null
968 ,p_pea_attribute11 in varchar2 default null
969 ,p_pea_attribute12 in varchar2 default null
970 ,p_pea_attribute13 in varchar2 default null
971 ,p_pea_attribute14 in varchar2 default null
972 ,p_pea_attribute15 in varchar2 default null
973 ,p_pea_attribute16 in varchar2 default null
974 ,p_pea_attribute17 in varchar2 default null
975 ,p_pea_attribute18 in varchar2 default null
976 ,p_pea_attribute19 in varchar2 default null
977 ,p_pea_attribute20 in varchar2 default null
978 ,p_school_type in varchar2 default null
979 ,p_school_id in varchar2 default null
980 ,p_school_name in varchar2 default null
981 ,p_school_name_kana in varchar2 default null
982 ,p_major in varchar2 default null
983 ,p_major_kana in varchar2 default null
984 ,p_advisor in varchar2 default null
985 ,p_graduation_date in varchar2 default null
986 ,p_note in varchar2 default null
987 ,p_last_flag in varchar2 default null
988 -- ,p_school_flag in varchar2 default null
989 ,p_pea_object_version_number out nocopy number
990 ,p_analysis_criteria_id out nocopy number
991 ,p_person_analysis_id out nocopy number
992 --
993 -- for per_addresses
994 --
995 -- ,p_primary_flag in varchar2
996 ,p_add_date_from in date default null
997 ,p_add_date_to in date default null
998 ,p_address_type in varchar2 default null
999 ,p_add_comments in varchar2 default null
1000 ,p_address_line1 in varchar2 default null
1001 ,p_address_line2 in varchar2 default null
1002 ,p_address_line3 in varchar2 default null
1003 ,p_district_code in varchar2 default null
1004 ,p_address_line1_kana in varchar2 default null
1005 ,p_address_line2_kana in varchar2 default null
1006 ,p_address_line3_kana in varchar2 default null
1007 ,p_postcode in varchar2 default null
1008 ,p_country in varchar2 default null
1009 ,p_telephone_number_1 in varchar2 default null
1010 ,p_telephone_number_2 in varchar2 default null
1011 ,p_fax_number in varchar2 default null
1012 ,p_addr_attribute_category in varchar2 default null
1013 ,p_addr_attribute1 in varchar2 default null
1014 ,p_addr_attribute2 in varchar2 default null
1015 ,p_addr_attribute3 in varchar2 default null
1016 ,p_addr_attribute4 in varchar2 default null
1017 ,p_addr_attribute5 in varchar2 default null
1018 ,p_addr_attribute6 in varchar2 default null
1019 ,p_addr_attribute7 in varchar2 default null
1020 ,p_addr_attribute8 in varchar2 default null
1021 ,p_addr_attribute9 in varchar2 default null
1022 ,p_addr_attribute10 in varchar2 default null
1023 ,p_addr_attribute11 in varchar2 default null
1024 ,p_addr_attribute12 in varchar2 default null
1025 ,p_addr_attribute13 in varchar2 default null
1026 ,p_addr_attribute14 in varchar2 default null
1027 ,p_addr_attribute15 in varchar2 default null
1028 ,p_addr_attribute16 in varchar2 default null
1029 ,p_addr_attribute17 in varchar2 default null
1030 ,p_addr_attribute18 in varchar2 default null
1031 ,p_addr_attribute19 in varchar2 default null
1032 ,p_addr_attribute20 in varchar2 default null
1033 ,p_address_id out nocopy number
1034 ,p_add_object_version_number out nocopy number
1035
1036 /* Additional parameters for Bug:4161160 */
1037
1038 ,p_english_last_name in varchar2 default null
1039 ,p_english_first_name in varchar2 default null
1040 ,p_per_information23 in varchar2 default null
1041 ,p_per_information24 in varchar2 default null
1042 ,p_per_information25 in varchar2 default null
1043 ,p_per_information26 in varchar2 default null
1044 ,p_per_information27 in varchar2 default null
1045 ,p_per_information28 in varchar2 default null
1046 ,p_per_information29 in varchar2 default null
1047 ,p_per_information30 in varchar2 default null
1048 ) is
1049 --
1050 l_person_id number;
1051 l_employee_number per_all_people_f.employee_number%TYPE;
1052 l_exists varchar2(2);
1053 l_found boolean := false;
1054 l_proc varchar2(72) := g_package||'create_jp_emp_with_educ_add';
1055 l_legislation_code varchar2(150);
1056 --
1057 cursor csr_bg is
1058 select legislation_code
1059 from per_business_groups pbg
1060 where pbg.business_group_id = p_business_group_id;
1061 --
1062
1063 begin
1064 --
1065 hr_utility.set_location('Entering:'|| l_proc, 5);
1066 --
1067 -- Issue a savepoint
1068 --
1069 savepoint create_jp_emp_with_educ_add;
1070 --
1071 -- Check that the specified business group is valid.
1072 --
1073 hr_utility.set_location(l_proc, 10);
1074 open csr_bg;
1075 fetch csr_bg into l_legislation_code;
1076 if csr_bg%notfound then
1077 close csr_bg;
1078 hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
1079 hr_utility.raise_error;
1080 else
1081 if l_legislation_code <> 'JP' then
1082 close csr_bg;
1083 hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
1084 hr_utility.set_message_token('LEG_CODE','JP');
1085 hr_utility.raise_error;
1086 end if;
1087 end if;
1088 close csr_bg;
1089
1090 l_employee_number := p_employee_number;
1091 --
1092 hr_utility.set_location(l_proc, 20);
1093 --
1094 hr_employee_api.create_employee
1095 ( p_validate => false
1096 ,p_hire_date => p_hire_date
1097 ,p_business_group_id => p_business_group_id
1098 ,p_last_name => p_last_name_kana
1099 ,p_sex => p_sex
1100 ,p_person_type_id => p_person_type_id
1101 ,p_per_comments => p_per_comments
1102 ,p_date_employee_data_verified => p_date_employee_data_verified
1103 ,p_date_of_birth => p_date_of_birth
1104 ,p_email_address => p_email_address
1105 ,p_employee_number => p_employee_number
1106 ,p_expense_check_send_to_addres => p_expense_check_send_to_addres
1107 ,p_first_name => p_first_name_kana
1108 ,p_known_as => p_known_as
1109 ,p_marital_status => p_marital_status
1110 ,p_middle_names => p_middle_names
1111 ,p_nationality => p_nationality
1112 ,p_national_identifier => p_national_identifier
1113 ,p_previous_last_name => p_previous_last_name_kana
1114 ,p_registered_disabled_flag => p_registered_disabled_flag
1115 ,p_title => p_title
1116 ,p_vendor_id => p_vendor_id
1117 ,p_work_telephone => p_work_telephone
1118 ,p_attribute_category => p_per_attribute_category
1119 ,p_attribute1 => p_per_attribute1
1120 ,p_attribute2 => p_per_attribute2
1121 ,p_attribute3 => p_per_attribute3
1122 ,p_attribute4 => p_per_attribute4
1123 ,p_attribute5 => p_per_attribute5
1124 ,p_attribute6 => p_per_attribute6
1125 ,p_attribute7 => p_per_attribute7
1126 ,p_attribute8 => p_per_attribute8
1127 ,p_attribute9 => p_per_attribute9
1128 ,p_attribute10 => p_per_attribute10
1129 ,p_attribute11 => p_per_attribute11
1130 ,p_attribute12 => p_per_attribute12
1131 ,p_attribute13 => p_per_attribute13
1132 ,p_attribute14 => p_per_attribute14
1133 ,p_attribute15 => p_per_attribute15
1134 ,p_attribute16 => p_per_attribute16
1135 ,p_attribute17 => p_per_attribute17
1136 ,p_attribute18 => p_per_attribute18
1137 ,p_attribute19 => p_per_attribute19
1138 ,p_attribute20 => p_per_attribute20
1139 ,p_attribute21 => p_per_attribute21
1140 ,p_attribute22 => p_per_attribute22
1141 ,p_attribute23 => p_per_attribute23
1142 ,p_attribute24 => p_per_attribute24
1143 ,p_attribute25 => p_per_attribute25
1144 ,p_attribute26 => p_per_attribute26
1145 ,p_attribute27 => p_per_attribute27
1146 ,p_attribute28 => p_per_attribute28
1147 ,p_attribute29 => p_per_attribute29
1148 ,p_attribute30 => p_per_attribute30
1149 ,p_per_information_category => 'JP'
1150 ,p_per_information1 => null
1151 ,p_per_information2 => null
1152 ,p_per_information3 => null
1153 ,p_per_information4 => null
1154 ,p_per_information5 => null
1155 ,p_per_information6 => null
1156 ,p_per_information7 => null
1157 ,p_per_information8 => null
1158 ,p_per_information9 => null
1159 ,p_per_information10 => null
1160 ,p_per_information11 => null
1161 ,p_per_information12 => null
1162 ,p_per_information13 => null
1163 ,p_per_information14 => null
1164 ,p_per_information15 => null
1165 ,p_per_information16 => null
1166 ,p_per_information17 => null
1167 ,p_per_information18 => p_last_name
1168 ,p_per_information19 => p_first_name
1169 ,p_per_information20 => p_previous_last_name
1170 ,p_date_of_death => p_date_of_death
1171 ,p_blood_type => p_blood_type
1172 ,p_correspondence_language => p_correspondence_language
1173 ,p_fte_capacity => p_fte_capacity
1174 ,p_honors => p_honors
1175 ,p_internal_location => p_internal_location
1176 ,p_last_medical_test_by => p_last_medical_test_by
1177 ,p_last_medical_test_date => p_last_medical_test_date
1178 ,p_mailstop => p_mailstop
1179 ,p_office_number => p_office_number
1180 ,p_on_military_service => p_on_military_service
1181 ,p_resume_exists => p_resume_exists
1182 ,p_resume_last_updated => p_resume_last_updated
1183 ,p_second_passport_exists => p_second_passport_exists
1184 ,p_student_status => p_student_status
1185 ,p_work_schedule => p_work_schedule
1186 ,p_original_date_of_hire => p_original_date_of_hire
1187 ,p_person_id => l_person_id
1188 ,p_assignment_id => p_assignment_id
1189 ,p_per_object_version_number => p_per_object_version_number
1190 ,p_asg_object_version_number => p_asg_object_version_number
1191 ,p_per_effective_start_date => p_per_effective_start_date
1192 ,p_per_effective_end_date => p_per_effective_end_date
1193 ,p_full_name => p_full_name
1194 ,p_per_comment_id => p_per_comment_id
1195 ,p_assignment_sequence => p_assignment_sequence
1196 ,p_assignment_number => p_assignment_number
1197 ,p_name_combination_warning => p_name_combination_warning
1198 ,p_assign_payroll_warning => p_assign_payroll_warning
1199 ,p_orig_hire_warning => p_orig_hire_warning
1200
1201 /* Additional parameters for Bug:4161160 */
1202
1203 ,p_per_information21 => p_english_last_name
1204 ,p_per_information22 => p_english_first_name
1205 ,p_per_information23 => p_per_information23
1206 ,p_per_information24 => p_per_information24
1207 ,p_per_information25 => p_per_information25
1208 ,p_per_information26 => p_per_information26
1209 ,p_per_information27 => p_per_information27
1210 ,p_per_information28 => p_per_information28
1211 ,p_per_information29 => p_per_information29
1212 ,p_per_information30 => p_per_information30
1213 );
1214 --
1215 hr_utility.set_location(l_proc, 30);
1216 --
1217 -- Create Educ Bkgrd if not all of the params are set to null.
1218 --
1219 if not (p_pea_comments is null
1220 and p_pea_date_from is null
1221 and p_pea_date_to is null
1222 and p_pea_attribute_category is null
1223 and p_pea_attribute1 is null
1224 and p_pea_attribute2 is null
1225 and p_pea_attribute3 is null
1226 and p_pea_attribute4 is null
1227 and p_pea_attribute5 is null
1228 and p_pea_attribute6 is null
1229 and p_pea_attribute7 is null
1230 and p_pea_attribute8 is null
1231 and p_pea_attribute9 is null
1232 and p_pea_attribute10 is null
1233 and p_pea_attribute11 is null
1234 and p_pea_attribute12 is null
1235 and p_pea_attribute13 is null
1236 and p_pea_attribute14 is null
1237 and p_pea_attribute15 is null
1238 and p_pea_attribute16 is null
1239 and p_pea_attribute17 is null
1240 and p_pea_attribute18 is null
1241 and p_pea_attribute19 is null
1242 and p_pea_attribute20 is null
1243 and p_school_type is null
1244 and p_school_id is null
1245 and p_school_name is null
1246 and p_school_name_kana is null
1247 and p_major is null
1248 and p_major_kana is null
1249 and p_advisor is null
1250 and p_graduation_date is null
1251 and p_note is null
1252 and p_last_flag is null
1253 ) then
1254 --
1255 hr_utility.set_location(l_proc, 40);
1256 --
1257 hr_jpbp_api.create_jp_educ_sit
1258 (p_validate => false
1259 ,p_person_id => l_person_id
1260 ,p_business_group_id => p_business_group_id
1261 ,p_effective_date => p_hire_date
1262 ,p_comments => p_pea_comments
1263 ,p_date_from => p_pea_date_from
1264 ,p_date_to => p_pea_date_to
1265 ,p_attribute_category => p_pea_attribute_category
1266 ,p_attribute1 => p_pea_attribute1
1267 ,p_attribute2 => p_pea_attribute2
1268 ,p_attribute3 => p_pea_attribute3
1269 ,p_attribute4 => p_pea_attribute4
1270 ,p_attribute5 => p_pea_attribute5
1271 ,p_attribute6 => p_pea_attribute6
1272 ,p_attribute7 => p_pea_attribute7
1273 ,p_attribute8 => p_pea_attribute8
1274 ,p_attribute9 => p_pea_attribute9
1275 ,p_attribute10 => p_pea_attribute10
1276 ,p_attribute11 => p_pea_attribute11
1277 ,p_attribute12 => p_pea_attribute12
1278 ,p_attribute13 => p_pea_attribute13
1279 ,p_attribute14 => p_pea_attribute14
1280 ,p_attribute15 => p_pea_attribute15
1281 ,p_attribute16 => p_pea_attribute16
1282 ,p_attribute17 => p_pea_attribute17
1283 ,p_attribute18 => p_pea_attribute18
1284 ,p_attribute19 => p_pea_attribute19
1285 ,p_attribute20 => p_pea_attribute20
1286 ,p_segment1 => p_school_type
1287 ,p_segment2 => p_school_id
1288 ,p_segment3 => p_school_name
1289 ,p_segment4 => p_school_name_kana
1290 ,p_segment5 => p_major
1291 ,p_segment6 => p_major_kana
1292 ,p_segment7 => p_advisor
1293 ,p_segment8 => p_graduation_date
1294 ,p_segment9 => p_note
1295 ,p_segment10 => p_last_flag
1296 ,p_segment11 => null
1297 ,p_segment12 => null
1298 ,p_segment13 => null
1299 ,p_segment14 => null
1300 ,p_segment15 => null
1301 ,p_segment16 => null
1302 ,p_segment17 => null
1303 ,p_segment18 => null
1304 ,p_segment19 => null
1305 ,p_segment20 => null
1306 ,p_segment21 => null
1307 ,p_segment22 => null
1308 ,p_segment23 => null
1309 ,p_segment24 => null
1310 ,p_segment25 => null
1311 ,p_segment26 => null
1312 ,p_segment27 => null
1313 ,p_segment28 => null
1314 ,p_segment29 => null
1315 ,p_segment30 => null
1316 ,p_analysis_criteria_id => p_analysis_criteria_id
1317 ,p_person_analysis_id => p_person_analysis_id
1318 ,p_pea_object_version_number => p_pea_object_version_number
1319 );
1320 --
1321 end if;
1322 --
1323 hr_utility.set_location(l_proc, 50);
1324 --
1325 -- call create_person_address if not all parameters are null.
1326 --
1327 if not
1328 (p_add_date_from is null
1329 and p_add_date_to is null
1330 and p_address_type is null
1331 and p_add_comments is null
1332 and p_address_line1 is null
1333 and p_address_line2 is null
1334 and p_address_line3 is null
1335 and p_district_code is null
1336 and p_address_line1_kana is null
1337 and p_address_line2_kana is null
1338 and p_address_line3_kana is null
1339 and p_postcode is null
1340 and p_country is null
1341 and p_telephone_number_1 is null
1342 and p_telephone_number_2 is null
1343 and p_fax_number is null
1344 and p_addr_attribute_category is null
1345 and p_addr_attribute1 is null
1346 and p_addr_attribute2 is null
1347 and p_addr_attribute3 is null
1348 and p_addr_attribute4 is null
1349 and p_addr_attribute5 is null
1350 and p_addr_attribute6 is null
1351 and p_addr_attribute7 is null
1352 and p_addr_attribute8 is null
1353 and p_addr_attribute9 is null
1354 and p_addr_attribute10 is null
1355 and p_addr_attribute11 is null
1356 and p_addr_attribute12 is null
1357 and p_addr_attribute13 is null
1358 and p_addr_attribute14 is null
1359 and p_addr_attribute15 is null
1360 and p_addr_attribute16 is null
1361 and p_addr_attribute17 is null
1362 and p_addr_attribute18 is null
1363 and p_addr_attribute19 is null
1364 and p_addr_attribute20 is null) then
1365
1366 --
1367 hr_utility.set_location(l_proc, 60);
1368 --
1369
1370 hr_person_address_api.create_person_address
1371 ( p_validate => false
1372 ,p_effective_date => p_hire_date
1373 ,p_person_id => l_person_id
1374 ,p_primary_flag => 'Y'
1375 ,p_style => 'JP'
1376 ,p_date_from => p_add_date_from
1377 ,p_date_to => p_add_date_to
1378 ,p_address_type => p_address_type
1379 ,p_comments => p_add_comments
1380 ,p_address_line1 => p_address_line1
1381 ,p_address_line2 => p_address_line2
1382 ,p_address_line3 => p_address_line3
1383 ,p_town_or_city => p_district_code
1384 ,p_region_1 => p_address_line1_kana
1385 ,p_region_2 => p_address_line2_kana
1386 ,p_region_3 => p_address_line3_kana
1387 ,p_postal_code => p_postcode
1388 ,p_country => p_country
1389 ,p_telephone_number_1 => p_telephone_number_1
1390 ,p_telephone_number_2 => p_telephone_number_2
1391 ,p_telephone_number_3 => p_fax_number
1392 ,p_addr_attribute_category => p_addr_attribute_category
1393 ,p_addr_attribute1 => p_addr_attribute1
1394 ,p_addr_attribute2 => p_addr_attribute2
1395 ,p_addr_attribute3 => p_addr_attribute3
1396 ,p_addr_attribute4 => p_addr_attribute4
1397 ,p_addr_attribute5 => p_addr_attribute5
1398 ,p_addr_attribute6 => p_addr_attribute6
1399 ,p_addr_attribute7 => p_addr_attribute7
1400 ,p_addr_attribute8 => p_addr_attribute8
1401 ,p_addr_attribute9 => p_addr_attribute9
1402 ,p_addr_attribute10 => p_addr_attribute10
1403 ,p_addr_attribute11 => p_addr_attribute11
1404 ,p_addr_attribute12 => p_addr_attribute12
1405 ,p_addr_attribute13 => p_addr_attribute13
1406 ,p_addr_attribute14 => p_addr_attribute14
1407 ,p_addr_attribute15 => p_addr_attribute15
1408 ,p_addr_attribute16 => p_addr_attribute16
1409 ,p_addr_attribute17 => p_addr_attribute17
1410 ,p_addr_attribute18 => p_addr_attribute18
1411 ,p_addr_attribute19 => p_addr_attribute19
1412 ,p_addr_attribute20 => p_addr_attribute20
1413 ,p_address_id => p_address_id
1414 ,p_object_version_number => p_add_object_version_number
1415 );
1416 end if;
1417 --
1418 --
1419 hr_utility.set_location(l_proc, 70);
1420 --
1421 --
1422 if p_validate then
1423 raise hr_api.validate_enabled;
1424 end if;
1425 --
1426 -- Set all output arguments
1427 --
1428 p_person_id := l_person_id;
1429 --
1430 hr_utility.set_location(' Leaving:'||l_proc, 80);
1431 exception
1432 when hr_api.validate_enabled then
1433 --
1434 -- As the Validate_Enabled exception has been raised
1435 -- we must rollback to the savepoint
1436 --
1437 ROLLBACK TO create_jp_emp_with_educ_add;
1438 --
1439 -- Only set output warning arguments
1440 -- (Any key or derived arguments must be set to null
1441 -- when validation only mode is being used.)
1442 --
1443 p_person_id := null;
1444 p_assignment_id := null;
1445 p_per_object_version_number := null;
1446 p_asg_object_version_number := null;
1447 p_per_effective_start_date := null;
1448 p_per_effective_end_date := null;
1449 p_full_name := null;
1450 p_per_comment_id := null;
1451 p_assignment_sequence := null;
1452 p_assignment_number := null;
1453
1454 p_pea_object_version_number := null;
1455 p_analysis_criteria_id := null;
1456 p_person_analysis_id := null;
1457
1458 p_address_id := null;
1459 p_add_object_version_number := null;
1460
1461 hr_utility.set_location(' Leaving:'||l_proc, 90);
1462
1463 when others then
1464 --
1465 -- A validation or unexpected error has occurred
1466 --
1467 ROLLBACK TO create_jp_emp_with_educ_add;
1468 --
1469 -- Reset IN OUT parameters and set OUT parameters
1470 --
1471 p_employee_number := l_employee_number;
1472 p_person_id := null;
1473 p_assignment_id := null;
1474 p_per_object_version_number := null;
1475 p_asg_object_version_number := null;
1476 p_per_effective_start_date := null;
1477 p_per_effective_end_date := null;
1478 p_full_name := null;
1479 p_per_comment_id := null;
1480 p_assignment_sequence := null;
1481 p_assignment_number := null;
1482
1483 p_name_combination_warning := null;
1484 p_assign_payroll_warning := null;
1485 p_orig_hire_warning := null;
1486
1487 p_pea_object_version_number := null;
1488 p_analysis_criteria_id := null;
1489 p_person_analysis_id := null;
1490
1491 hr_utility.set_location(' Leaving:'||l_proc, 100);
1492 raise;
1493 end create_jp_emp_with_educ_add;
1494
1495
1496 -- ----------------------------------------------------------------------------
1497 -- |---------------------< create_jp_applicant_with_sit >---------------------|
1498 -- ----------------------------------------------------------------------------
1499 --
1500 procedure create_jp_applicant_with_sit
1501 (
1502 -- for per_people_f
1503 --
1504 p_validate in boolean default false
1505 ,p_date_received in date
1506 ,p_business_group_id in number
1507 ,p_last_name in varchar2
1508 ,p_last_name_kana in varchar2
1509 ,p_sex in varchar2 default null
1510 ,p_person_type_id in number default null
1511 ,p_per_comments in varchar2 default null
1512 ,p_date_employee_data_verified in date default null
1513 ,p_date_of_birth in date default null
1514 ,p_email_address in varchar2 default null
1515 ,p_applicant_number in out nocopy varchar2
1516 ,p_expense_check_send_to_addres in varchar2 default null
1517 ,p_first_name in varchar2 default null
1518 ,p_first_name_kana in varchar2 default null
1519 ,p_known_as in varchar2 default null
1520 ,p_marital_status in varchar2 default null
1521 ,p_middle_names in varchar2 default null
1522 ,p_nationality in varchar2 default null
1523 ,p_national_identifier in varchar2 default null
1524 ,p_previous_last_name in varchar2 default null
1525 ,p_previous_last_name_kana in varchar2 default null
1526 ,p_registered_disabled_flag in varchar2 default null
1527 ,p_title in varchar2 default null
1528 ,p_work_telephone in varchar2 default null
1529 ,p_per_attribute_category in varchar2 default null
1530 ,p_per_attribute1 in varchar2 default null
1531 ,p_per_attribute2 in varchar2 default null
1532 ,p_per_attribute3 in varchar2 default null
1533 ,p_per_attribute4 in varchar2 default null
1534 ,p_per_attribute5 in varchar2 default null
1535 ,p_per_attribute6 in varchar2 default null
1536 ,p_per_attribute7 in varchar2 default null
1537 ,p_per_attribute8 in varchar2 default null
1538 ,p_per_attribute9 in varchar2 default null
1539 ,p_per_attribute10 in varchar2 default null
1540 ,p_per_attribute11 in varchar2 default null
1541 ,p_per_attribute12 in varchar2 default null
1542 ,p_per_attribute13 in varchar2 default null
1543 ,p_per_attribute14 in varchar2 default null
1544 ,p_per_attribute15 in varchar2 default null
1545 ,p_per_attribute16 in varchar2 default null
1546 ,p_per_attribute17 in varchar2 default null
1547 ,p_per_attribute18 in varchar2 default null
1548 ,p_per_attribute19 in varchar2 default null
1549 ,p_per_attribute20 in varchar2 default null
1550 ,p_per_attribute21 in varchar2 default null
1551 ,p_per_attribute22 in varchar2 default null
1552 ,p_per_attribute23 in varchar2 default null
1553 ,p_per_attribute24 in varchar2 default null
1554 ,p_per_attribute25 in varchar2 default null
1555 ,p_per_attribute26 in varchar2 default null
1556 ,p_per_attribute27 in varchar2 default null
1557 ,p_per_attribute28 in varchar2 default null
1558 ,p_per_attribute29 in varchar2 default null
1559 ,p_per_attribute30 in varchar2 default null
1560 ,p_correspondence_language in varchar2 default null
1561 ,p_fte_capacity in number default null
1562 ,p_hold_applicant_date_until in date default null
1563 ,p_honors in varchar2 default null
1564 ,p_mailstop in varchar2 default null
1565 ,p_office_number in varchar2 default null
1566 ,p_on_military_service in varchar2 default null
1567 ,p_resume_exists in varchar2 default null
1568 ,p_resume_last_updated in date default null
1569 ,p_student_status in varchar2 default null
1570 ,p_work_schedule in varchar2 default null
1571 ,p_date_of_death in date default null
1572 ,p_original_date_of_hire in date default null
1573 ,p_person_id out nocopy number
1574 ,p_assignment_id out nocopy number
1575 ,p_application_id out nocopy number
1576 ,p_per_object_version_number out nocopy number
1577 ,p_asg_object_version_number out nocopy number
1578 ,p_apl_object_version_number out nocopy number
1579 ,p_per_effective_start_date out nocopy date
1580 ,p_per_effective_end_date out nocopy date
1581 ,p_full_name out nocopy varchar2
1582 ,p_per_comment_id out nocopy number
1583 ,p_assignment_sequence out nocopy number
1584 ,p_name_combination_warning out nocopy boolean
1585 ,p_orig_hire_warning out nocopy boolean
1586
1587 /* for special information */
1588
1589 ,p_id_flex_num in number
1590 ,p_pea_comments in varchar2 default null
1591 ,p_date_from in date default null
1592 ,p_date_to in date default null
1593 ,p_pea_attribute_category in varchar2 default null
1594 ,p_pea_attribute1 in varchar2 default null
1595 ,p_pea_attribute2 in varchar2 default null
1596 ,p_pea_attribute3 in varchar2 default null
1597 ,p_pea_attribute4 in varchar2 default null
1598 ,p_pea_attribute5 in varchar2 default null
1599 ,p_pea_attribute6 in varchar2 default null
1600 ,p_pea_attribute7 in varchar2 default null
1601 ,p_pea_attribute8 in varchar2 default null
1602 ,p_pea_attribute9 in varchar2 default null
1603 ,p_pea_attribute10 in varchar2 default null
1604 ,p_pea_attribute11 in varchar2 default null
1605 ,p_pea_attribute12 in varchar2 default null
1606 ,p_pea_attribute13 in varchar2 default null
1607 ,p_pea_attribute14 in varchar2 default null
1608 ,p_pea_attribute15 in varchar2 default null
1609 ,p_pea_attribute16 in varchar2 default null
1610 ,p_pea_attribute17 in varchar2 default null
1611 ,p_pea_attribute18 in varchar2 default null
1612 ,p_pea_attribute19 in varchar2 default null
1613 ,p_pea_attribute20 in varchar2 default null
1614 ,p_segment1 in varchar2 default null
1615 ,p_segment2 in varchar2 default null
1616 ,p_segment3 in varchar2 default null
1617 ,p_segment4 in varchar2 default null
1618 ,p_segment5 in varchar2 default null
1619 ,p_segment6 in varchar2 default null
1620 ,p_segment7 in varchar2 default null
1621 ,p_segment8 in varchar2 default null
1622 ,p_segment9 in varchar2 default null
1623 ,p_segment10 in varchar2 default null
1624 ,p_segment11 in varchar2 default null
1625 ,p_segment12 in varchar2 default null
1626 ,p_segment13 in varchar2 default null
1627 ,p_segment14 in varchar2 default null
1628 ,p_segment15 in varchar2 default null
1629 ,p_segment16 in varchar2 default null
1630 ,p_segment17 in varchar2 default null
1631 ,p_segment18 in varchar2 default null
1632 ,p_segment19 in varchar2 default null
1633 ,p_segment20 in varchar2 default null
1634 ,p_segment21 in varchar2 default null
1635 ,p_segment22 in varchar2 default null
1636 ,p_segment23 in varchar2 default null
1637 ,p_segment24 in varchar2 default null
1638 ,p_segment25 in varchar2 default null
1639 ,p_segment26 in varchar2 default null
1640 ,p_segment27 in varchar2 default null
1641 ,p_segment28 in varchar2 default null
1642 ,p_segment29 in varchar2 default null
1643 ,p_segment30 in varchar2 default null
1644 ,p_pea_object_version_number out nocopy number
1645 ,p_analysis_criteria_id out nocopy number
1646 ,p_person_analysis_id out nocopy number
1647 ) is
1648 --
1649 -- Declare cursors and local variables
1650 --
1651 l_proc varchar2(72) := g_package||'create_jp_applicant_with_sit';
1652 l_legislation_code varchar2(2);
1653 l_person_id per_people_f.person_id%TYPE;
1654 l_application_id number;
1655 l_applicant_number per_all_people_f.applicant_number%TYPE;
1656 l_apl_object_version_number number;
1657 --
1658 cursor csr_bg is
1659 select legislation_code
1660 from per_business_groups pbg
1661 where pbg.business_group_id = p_business_group_id;
1662 --
1663 begin
1664 --
1665 -- Issue a savepoint
1666 --
1667 savepoint create_jp_applicant_with_sit;
1668
1669 hr_utility.set_location('Entering:'|| l_proc, 5);
1670 --
1671 -- Validation in addition to Table Handlers
1672 --
1673 -- Check that the specified business group is valid.
1674 --
1675 open csr_bg;
1676 fetch csr_bg
1677 into l_legislation_code;
1678 if csr_bg%notfound then
1679 close csr_bg;
1680 hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
1681 hr_utility.raise_error;
1682 end if;
1683 close csr_bg;
1684 --
1685 -- Check that the legislation of the specified business group is 'JP'.
1686 --
1687 if l_legislation_code <> 'JP' then
1688 hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
1689 hr_utility.set_message_token('LEG_CODE','JP');
1690 hr_utility.raise_error;
1691 end if;
1692
1693 l_applicant_number := p_applicant_number;
1694 --
1695 hr_utility.set_location(l_proc, 10);
1696 --
1697 -- Call the person business process
1698 --
1699 hr_applicant_api.create_applicant
1700 (p_validate => false
1701 ,p_date_received => p_date_received
1702 ,p_business_group_id => p_business_group_id
1703 ,p_last_name => p_last_name_kana
1704 ,p_sex => p_sex
1705 ,p_person_type_id => p_person_type_id
1706 ,p_per_comments => p_per_comments
1707 ,p_date_employee_data_verified => p_date_employee_data_verified
1708 ,p_date_of_birth => p_date_of_birth
1709 ,p_email_address => p_email_address
1710 ,p_applicant_number => p_applicant_number
1711 ,p_expense_check_send_to_addres => p_expense_check_send_to_addres
1712 ,p_first_name => p_first_name_kana
1713 ,p_known_as => p_known_as
1714 ,p_marital_status => p_marital_status
1715 ,p_middle_names => p_middle_names
1716 ,p_nationality => p_nationality
1717 ,p_national_identifier => p_national_identifier
1718 ,p_previous_last_name => p_previous_last_name_kana
1719 ,p_registered_disabled_flag => p_registered_disabled_flag
1720 ,p_title => p_title
1721 ,p_work_telephone => p_work_telephone
1722 ,p_attribute_category => p_per_attribute_category
1723 ,p_attribute1 => p_per_attribute1
1724 ,p_attribute2 => p_per_attribute2
1725 ,p_attribute3 => p_per_attribute3
1726 ,p_attribute4 => p_per_attribute4
1727 ,p_attribute5 => p_per_attribute5
1728 ,p_attribute6 => p_per_attribute6
1729 ,p_attribute7 => p_per_attribute7
1730 ,p_attribute8 => p_per_attribute8
1731 ,p_attribute9 => p_per_attribute9
1732 ,p_attribute10 => p_per_attribute10
1733 ,p_attribute11 => p_per_attribute11
1734 ,p_attribute12 => p_per_attribute12
1735 ,p_attribute13 => p_per_attribute13
1736 ,p_attribute14 => p_per_attribute14
1737 ,p_attribute15 => p_per_attribute15
1738 ,p_attribute16 => p_per_attribute16
1739 ,p_attribute17 => p_per_attribute17
1740 ,p_attribute18 => p_per_attribute18
1741 ,p_attribute19 => p_per_attribute19
1742 ,p_attribute20 => p_per_attribute20
1743 ,p_attribute21 => p_per_attribute21
1744 ,p_attribute22 => p_per_attribute22
1745 ,p_attribute23 => p_per_attribute23
1746 ,p_attribute24 => p_per_attribute24
1747 ,p_attribute25 => p_per_attribute25
1748 ,p_attribute26 => p_per_attribute26
1749 ,p_attribute27 => p_per_attribute27
1750 ,p_attribute28 => p_per_attribute28
1751 ,p_attribute29 => p_per_attribute29
1752 ,p_attribute30 => p_per_attribute30
1753 ,p_per_information_category => 'JP'
1754 ,p_per_information1 => null
1755 ,p_per_information2 => null
1756 ,p_per_information3 => null
1757 ,p_per_information4 => null
1758 ,p_per_information5 => null
1759 ,p_per_information6 => null
1760 ,p_per_information7 => null
1761 ,p_per_information8 => null
1762 ,p_per_information9 => null
1763 ,p_per_information10 => null
1764 ,p_per_information11 => null
1765 ,p_per_information12 => null
1766 ,p_per_information13 => null
1767 ,p_per_information14 => null
1768 ,p_per_information15 => null
1769 ,p_per_information16 => null
1770 ,p_per_information17 => null
1771 ,p_per_information18 => p_last_name
1772 ,p_per_information19 => p_first_name
1773 ,p_per_information20 => p_previous_last_name
1774 ,p_correspondence_language => p_correspondence_language
1775 ,p_fte_capacity => p_fte_capacity
1776 ,p_hold_applicant_date_until => p_hold_applicant_date_until
1777 ,p_honors => p_honors
1778 ,p_mailstop => p_mailstop
1779 ,p_office_number => p_office_number
1780 ,p_on_military_service => p_on_military_service
1781 ,p_resume_exists => p_resume_exists
1782 ,p_resume_last_updated => p_resume_last_updated
1783 ,p_student_status => p_student_status
1784 ,p_work_schedule => p_work_schedule
1785 ,p_date_of_death => p_date_of_death
1786 ,p_original_date_of_hire => p_original_date_of_hire
1787 ,p_person_id => l_person_id
1788 ,p_assignment_id => p_assignment_id
1789 ,p_application_id => p_application_id
1790 ,p_per_object_version_number => p_per_object_version_number
1791 ,p_asg_object_version_number => p_asg_object_version_number
1792 ,p_apl_object_version_number => p_apl_object_version_number
1793 ,p_per_effective_start_date => p_per_effective_start_date
1794 ,p_per_effective_end_date => p_per_effective_end_date
1795 ,p_full_name => p_full_name
1796 ,p_per_comment_id => p_per_comment_id
1797 ,p_assignment_sequence => p_assignment_sequence
1798 ,p_name_combination_warning => p_name_combination_warning
1799 ,p_orig_hire_warning => p_orig_hire_warning
1800 );
1801 --
1802 hr_utility.set_location(l_proc, 20);
1803 --
1804 -- Create SIT if not all params are set to null.
1805 --
1806 if not (p_id_flex_num is null
1807 and p_pea_comments is null
1808 and p_date_from is null
1809 and p_date_to is null
1810 and p_pea_attribute_category is null
1811 and p_pea_attribute1 is null
1812 and p_pea_attribute2 is null
1813 and p_pea_attribute3 is null
1814 and p_pea_attribute4 is null
1815 and p_pea_attribute5 is null
1816 and p_pea_attribute6 is null
1817 and p_pea_attribute7 is null
1818 and p_pea_attribute8 is null
1819 and p_pea_attribute9 is null
1820 and p_pea_attribute10 is null
1821 and p_pea_attribute11 is null
1822 and p_pea_attribute12 is null
1823 and p_pea_attribute13 is null
1824 and p_pea_attribute14 is null
1825 and p_pea_attribute15 is null
1826 and p_pea_attribute16 is null
1827 and p_pea_attribute17 is null
1828 and p_pea_attribute18 is null
1829 and p_pea_attribute19 is null
1830 and p_pea_attribute20 is null
1831 and p_segment1 is null
1832 and p_segment2 is null
1833 and p_segment3 is null
1834 and p_segment4 is null
1835 and p_segment5 is null
1836 and p_segment6 is null
1837 and p_segment7 is null
1838 and p_segment8 is null
1839 and p_segment9 is null
1840 and p_segment10 is null
1841 and p_segment11 is null
1842 and p_segment12 is null
1843 and p_segment13 is null
1844 and p_segment14 is null
1845 and p_segment15 is null
1846 and p_segment16 is null
1847 and p_segment17 is null
1848 and p_segment18 is null
1849 and p_segment19 is null
1850 and p_segment20 is null
1851 and p_segment21 is null
1852 and p_segment22 is null
1853 and p_segment23 is null
1854 and p_segment24 is null
1855 and p_segment25 is null
1856 and p_segment26 is null
1857 and p_segment27 is null
1858 and p_segment28 is null
1859 and p_segment29 is null
1860 and p_segment30 is null
1861 ) then
1862 --
1863 hr_utility.set_location(l_proc, 30);
1864 --
1865 hr_sit_api.create_sit
1866 (p_validate => false
1867 ,p_person_id => l_person_id
1868 ,p_business_group_id => p_business_group_id
1869 ,p_id_flex_num => p_id_flex_num
1870 ,p_effective_date => p_date_received
1871 ,p_comments => p_per_comments
1872 ,p_date_from => p_date_from
1873 ,p_date_to => p_date_to
1874 ,p_attribute_category => p_pea_attribute_category
1875 ,p_attribute1 => p_pea_attribute1
1876 ,p_attribute2 => p_pea_attribute2
1877 ,p_attribute3 => p_pea_attribute3
1878 ,p_attribute4 => p_pea_attribute4
1879 ,p_attribute5 => p_pea_attribute5
1880 ,p_attribute6 => p_pea_attribute6
1881 ,p_attribute7 => p_pea_attribute7
1882 ,p_attribute8 => p_pea_attribute8
1883 ,p_attribute9 => p_pea_attribute9
1884 ,p_attribute10 => p_pea_attribute10
1885 ,p_attribute11 => p_pea_attribute11
1886 ,p_attribute12 => p_pea_attribute12
1887 ,p_attribute13 => p_pea_attribute13
1888 ,p_attribute14 => p_pea_attribute14
1889 ,p_attribute15 => p_pea_attribute15
1890 ,p_attribute16 => p_pea_attribute16
1891 ,p_attribute17 => p_pea_attribute17
1892 ,p_attribute18 => p_pea_attribute18
1893 ,p_attribute19 => p_pea_attribute19
1894 ,p_attribute20 => p_pea_attribute20
1895 ,p_segment1 => p_segment1
1896 ,p_segment2 => p_segment2
1897 ,p_segment3 => p_segment3
1898 ,p_segment4 => p_segment4
1899 ,p_segment5 => p_segment5
1900 ,p_segment6 => p_segment6
1901 ,p_segment7 => p_segment7
1902 ,p_segment8 => p_segment8
1903 ,p_segment9 => p_segment9
1904 ,p_segment10 => p_segment10
1905 ,p_segment11 => p_segment11
1906 ,p_segment12 => p_segment12
1907 ,p_segment13 => p_segment13
1908 ,p_segment14 => p_segment14
1909 ,p_segment15 => p_segment15
1910 ,p_segment16 => p_segment16
1911 ,p_segment17 => p_segment17
1912 ,p_segment18 => p_segment18
1913 ,p_segment19 => p_segment19
1914 ,p_segment20 => p_segment20
1915 ,p_segment21 => p_segment21
1916 ,p_segment22 => p_segment22
1917 ,p_segment23 => p_segment23
1918 ,p_segment24 => p_segment24
1919 ,p_segment25 => p_segment25
1920 ,p_segment26 => p_segment26
1921 ,p_segment27 => p_segment27
1922 ,p_segment28 => p_segment28
1923 ,p_segment29 => p_segment29
1924 ,p_segment30 => p_segment30
1925 ,p_analysis_criteria_id => p_analysis_criteria_id
1926 ,p_person_analysis_id => p_person_analysis_id
1927 ,p_pea_object_version_number => p_pea_object_version_number
1928 );
1929 end if;
1930
1931 -- When in validation only mode raise the Validate_Enabled exception
1932 --
1933 if p_validate then
1934 raise hr_api.validate_enabled;
1935 end if;
1936 --
1937 -- Set all output arguments
1938 --
1939 p_person_id := l_person_id;
1940 --
1941 hr_utility.set_location(' Leaving:'||l_proc, 40);
1942 exception
1943 when hr_api.validate_enabled then
1944 --
1945 -- As the Validate_Enabled exception has been raised
1946 -- we must rollback to the savepoint
1947 --
1948 ROLLBACK TO create_jp_applicant_with_sit;
1949 --
1950 -- Only set output warning arguments
1951 -- (Any key or derived arguments must be set to null
1952 -- when validation only mode is being used.)
1953 --
1954 p_person_id := null;
1955 p_assignment_id := null;
1956 p_application_id := null;
1957 p_per_object_version_number := null;
1958 p_asg_object_version_number := null;
1959 p_apl_object_version_number := null;
1960 p_per_effective_start_date := null;
1961 p_per_effective_end_date := null;
1962 p_full_name := null;
1963 p_per_comment_id := null;
1964 p_assignment_sequence := null;
1965
1966 p_pea_object_version_number := null;
1967 p_analysis_criteria_id := null;
1968 p_person_analysis_id := null;
1969
1970 when others then
1971 --
1972 -- A validation or unexpected error has occurred
1973 --
1974 ROLLBACK TO create_jp_applicant_with_sit;
1975 --
1976 -- Reset IN OUT parameters and set OUT parameters
1977 --
1978
1979 p_applicant_number := l_applicant_number;
1980
1981 p_person_id := null;
1982 p_assignment_id := null;
1983 p_application_id := null;
1984 p_per_object_version_number := null;
1985 p_asg_object_version_number := null;
1986 p_apl_object_version_number := null;
1987 p_per_effective_start_date := null;
1988 p_per_effective_end_date := null;
1989 p_full_name := null;
1990 p_per_comment_id := null;
1991 p_assignment_sequence := null;
1992 p_name_combination_warning := null;
1993 p_orig_hire_warning := null;
1994
1995 p_pea_object_version_number := null;
1996 p_analysis_criteria_id := null;
1997 p_person_analysis_id := null;
1998
1999 hr_utility.set_location(' Leaving:'||l_proc, 50);
2000 raise;
2001 end create_jp_applicant_with_sit;
2002 --
2003 -- ----------------------------------------------------------------------------
2004 -- |-------------------< create_jp_appl_with_educ_add>------------------------|
2005 -- ----------------------------------------------------------------------------
2006 procedure create_jp_appl_with_educ_add
2007 (
2008 -- for per_people_f
2009 --
2010 p_validate in boolean default false
2011 ,p_date_received in date
2012 ,p_business_group_id in number
2013 ,p_last_name in varchar2
2014 ,p_last_name_kana in varchar2
2015 ,p_sex in varchar2 default null
2016 ,p_person_type_id in number default null
2017 ,p_per_comments in varchar2 default null
2018 ,p_date_employee_data_verified in date default null
2019 ,p_date_of_birth in date default null
2020 ,p_email_address in varchar2 default null
2021 ,p_applicant_number in out nocopy varchar2
2022 ,p_expense_check_send_to_addres in varchar2 default null
2023 ,p_first_name in varchar2 default null
2024 ,p_first_name_kana in varchar2 default null
2025 ,p_known_as in varchar2 default null
2026 ,p_marital_status in varchar2 default null
2027 ,p_middle_names in varchar2 default null
2028 ,p_nationality in varchar2 default null
2029 ,p_national_identifier in varchar2 default null
2030 ,p_previous_last_name in varchar2 default null
2031 ,p_previous_last_name_kana in varchar2 default null
2032 ,p_registered_disabled_flag in varchar2 default null
2033 ,p_title in varchar2 default null
2034 ,p_work_telephone in varchar2 default null
2035 ,p_per_attribute_category in varchar2 default null
2036 ,p_per_attribute1 in varchar2 default null
2037 ,p_per_attribute2 in varchar2 default null
2038 ,p_per_attribute3 in varchar2 default null
2039 ,p_per_attribute4 in varchar2 default null
2040 ,p_per_attribute5 in varchar2 default null
2041 ,p_per_attribute6 in varchar2 default null
2042 ,p_per_attribute7 in varchar2 default null
2043 ,p_per_attribute8 in varchar2 default null
2044 ,p_per_attribute9 in varchar2 default null
2045 ,p_per_attribute10 in varchar2 default null
2046 ,p_per_attribute11 in varchar2 default null
2047 ,p_per_attribute12 in varchar2 default null
2048 ,p_per_attribute13 in varchar2 default null
2049 ,p_per_attribute14 in varchar2 default null
2050 ,p_per_attribute15 in varchar2 default null
2051 ,p_per_attribute16 in varchar2 default null
2052 ,p_per_attribute17 in varchar2 default null
2053 ,p_per_attribute18 in varchar2 default null
2054 ,p_per_attribute19 in varchar2 default null
2055 ,p_per_attribute20 in varchar2 default null
2056 ,p_per_attribute21 in varchar2 default null
2057 ,p_per_attribute22 in varchar2 default null
2058 ,p_per_attribute23 in varchar2 default null
2059 ,p_per_attribute24 in varchar2 default null
2060 ,p_per_attribute25 in varchar2 default null
2061 ,p_per_attribute26 in varchar2 default null
2062 ,p_per_attribute27 in varchar2 default null
2063 ,p_per_attribute28 in varchar2 default null
2064 ,p_per_attribute29 in varchar2 default null
2065 ,p_per_attribute30 in varchar2 default null
2066 ,p_correspondence_language in varchar2 default null
2067 ,p_fte_capacity in number default null
2068 ,p_hold_applicant_date_until in date default null
2069 ,p_honors in varchar2 default null
2070 ,p_mailstop in varchar2 default null
2071 ,p_office_number in varchar2 default null
2072 ,p_on_military_service in varchar2 default null
2073 ,p_resume_exists in varchar2 default null
2074 ,p_resume_last_updated in date default null
2075 ,p_student_status in varchar2 default null
2076 ,p_work_schedule in varchar2 default null
2077 ,p_date_of_death in date default null
2078 ,p_original_date_of_hire in date default null
2079 ,p_person_id out nocopy number
2080 ,p_assignment_id out nocopy number
2081 ,p_application_id out nocopy number
2082 ,p_per_object_version_number out nocopy number
2083 ,p_asg_object_version_number out nocopy number
2084 ,p_apl_object_version_number out nocopy number
2085 ,p_per_effective_start_date out nocopy date
2086 ,p_per_effective_end_date out nocopy date
2087 ,p_full_name out nocopy varchar2
2088 ,p_per_comment_id out nocopy number
2089 ,p_assignment_sequence out nocopy number
2090 ,p_name_combination_warning out nocopy boolean
2091 ,p_orig_hire_warning out nocopy boolean
2092 --
2093 -- for special information
2094 --
2095 ,p_pea_comments in varchar2 default null
2096 ,p_pea_date_from in date default null
2097 ,p_pea_date_to in date default null
2098 ,p_pea_attribute_category in varchar2 default null
2099 ,p_pea_attribute1 in varchar2 default null
2100 ,p_pea_attribute2 in varchar2 default null
2101 ,p_pea_attribute3 in varchar2 default null
2102 ,p_pea_attribute4 in varchar2 default null
2103 ,p_pea_attribute5 in varchar2 default null
2104 ,p_pea_attribute6 in varchar2 default null
2105 ,p_pea_attribute7 in varchar2 default null
2106 ,p_pea_attribute8 in varchar2 default null
2107 ,p_pea_attribute9 in varchar2 default null
2108 ,p_pea_attribute10 in varchar2 default null
2109 ,p_pea_attribute11 in varchar2 default null
2110 ,p_pea_attribute12 in varchar2 default null
2111 ,p_pea_attribute13 in varchar2 default null
2112 ,p_pea_attribute14 in varchar2 default null
2113 ,p_pea_attribute15 in varchar2 default null
2114 ,p_pea_attribute16 in varchar2 default null
2115 ,p_pea_attribute17 in varchar2 default null
2116 ,p_pea_attribute18 in varchar2 default null
2117 ,p_pea_attribute19 in varchar2 default null
2118 ,p_pea_attribute20 in varchar2 default null
2119 ,p_school_type in varchar2 default null
2120 ,p_school_id in varchar2 default null
2121 ,p_school_name in varchar2 default null
2122 ,p_school_name_kana in varchar2 default null
2123 ,p_major in varchar2 default null
2124 ,p_major_kana in varchar2 default null
2125 ,p_advisor in varchar2 default null
2126 ,p_graduation_date in varchar2 default null
2127 ,p_note in varchar2 default null
2128 ,p_last_flag in varchar2 default null
2129 -- ,p_school_flag in varchar2 default null
2130 ,p_pea_object_version_number out nocopy number
2131 ,p_analysis_criteria_id out nocopy number
2132 ,p_person_analysis_id out nocopy number
2133 --
2134 -- for per_addresses
2135 --
2136 -- ,p_primary_flag in varchar2
2137 ,p_add_date_from in date default null
2138 ,p_add_date_to in date default null
2139 ,p_address_type in varchar2 default null
2140 ,p_add_comments in varchar2 default null
2141 ,p_address_line1 in varchar2 default null
2142 ,p_address_line2 in varchar2 default null
2143 ,p_address_line3 in varchar2 default null
2144 ,p_district_code in varchar2 default null
2145 ,p_address_line1_kana in varchar2 default null
2146 ,p_address_line2_kana in varchar2 default null
2147 ,p_address_line3_kana in varchar2 default null
2148 ,p_postcode in varchar2 default null
2149 ,p_country in varchar2 default null
2150 ,p_telephone_number_1 in varchar2 default null
2151 ,p_telephone_number_2 in varchar2 default null
2152 ,p_fax_number in varchar2 default null
2153 ,p_addr_attribute_category in varchar2 default null
2154 ,p_addr_attribute1 in varchar2 default null
2155 ,p_addr_attribute2 in varchar2 default null
2156 ,p_addr_attribute3 in varchar2 default null
2157 ,p_addr_attribute4 in varchar2 default null
2158 ,p_addr_attribute5 in varchar2 default null
2159 ,p_addr_attribute6 in varchar2 default null
2160 ,p_addr_attribute7 in varchar2 default null
2161 ,p_addr_attribute8 in varchar2 default null
2162 ,p_addr_attribute9 in varchar2 default null
2163 ,p_addr_attribute10 in varchar2 default null
2164 ,p_addr_attribute11 in varchar2 default null
2165 ,p_addr_attribute12 in varchar2 default null
2166 ,p_addr_attribute13 in varchar2 default null
2167 ,p_addr_attribute14 in varchar2 default null
2168 ,p_addr_attribute15 in varchar2 default null
2169 ,p_addr_attribute16 in varchar2 default null
2170 ,p_addr_attribute17 in varchar2 default null
2171 ,p_addr_attribute18 in varchar2 default null
2172 ,p_addr_attribute19 in varchar2 default null
2173 ,p_addr_attribute20 in varchar2 default null
2174 ,p_address_id out nocopy number
2175 ,p_add_object_version_number out nocopy number
2176 )is
2177 --
2178 l_person_id number;
2179 l_applicant_number per_all_people_f.applicant_number%TYPE;
2180 l_exists varchar2(2);
2181 l_found boolean := false;
2182 l_proc varchar2(72) := g_package||'create_jp_appl_with_educ_add';
2183 l_legislation_code varchar2(150);
2184 --
2185 cursor csr_bg is
2186 select legislation_code
2187 from per_business_groups pbg
2188 where pbg.business_group_id = p_business_group_id;
2189 --
2190
2191 begin
2192 --
2193 hr_utility.set_location('Entering:'|| l_proc, 5);
2194 --
2195 -- Issue a savepoint
2196 --
2197 savepoint create_jp_appl_with_educ_add;
2198
2199 --
2200 -- Check that the specified business group is valid.
2201 --
2202 hr_utility.set_location(l_proc, 10);
2203 --
2204 open csr_bg;
2205 fetch csr_bg into l_legislation_code;
2206 if csr_bg%notfound then
2207 close csr_bg;
2208 hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
2209 hr_utility.raise_error;
2210 else
2211 if l_legislation_code <> 'JP' then
2212 close csr_bg;
2213 hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
2214 hr_utility.set_message_token('LEG_CODE','JP');
2215 hr_utility.raise_error;
2216 end if;
2217 end if;
2218 close csr_bg;
2219
2220 l_applicant_number := p_applicant_number;
2221 --
2222 -- call create_person_address
2223 --
2224 hr_utility.set_location(l_proc, 20);
2225 --
2226 hr_applicant_api.create_applicant
2227 ( p_validate => false
2228 ,p_date_received => p_date_received
2229 ,p_business_group_id => p_business_group_id
2230 ,p_last_name => p_last_name_kana
2231 ,p_sex => p_sex
2232 ,p_person_type_id => p_person_type_id
2233 ,p_per_comments => p_per_comments
2234 ,p_date_employee_data_verified => p_date_employee_data_verified
2235 ,p_date_of_birth => p_date_of_birth
2236 ,p_email_address => p_email_address
2237 ,p_applicant_number => p_applicant_number
2238 ,p_expense_check_send_to_addres => p_expense_check_send_to_addres
2239 ,p_first_name => p_first_name_kana
2240 ,p_known_as => p_known_as
2241 ,p_marital_status => p_marital_status
2242 ,p_middle_names => p_middle_names
2243 ,p_nationality => p_nationality
2244 ,p_national_identifier => p_national_identifier
2245 ,p_previous_last_name => p_previous_last_name_kana
2246 ,p_registered_disabled_flag => p_registered_disabled_flag
2247 ,p_title => p_title
2248 ,p_work_telephone => p_work_telephone
2249 ,p_attribute_category => p_per_attribute_category
2250 ,p_attribute1 => p_per_attribute1
2251 ,p_attribute2 => p_per_attribute2
2252 ,p_attribute3 => p_per_attribute3
2253 ,p_attribute4 => p_per_attribute4
2254 ,p_attribute5 => p_per_attribute5
2255 ,p_attribute6 => p_per_attribute6
2256 ,p_attribute7 => p_per_attribute7
2257 ,p_attribute8 => p_per_attribute8
2258 ,p_attribute9 => p_per_attribute9
2259 ,p_attribute10 => p_per_attribute10
2260 ,p_attribute11 => p_per_attribute11
2261 ,p_attribute12 => p_per_attribute12
2262 ,p_attribute13 => p_per_attribute13
2263 ,p_attribute14 => p_per_attribute14
2264 ,p_attribute15 => p_per_attribute15
2265 ,p_attribute16 => p_per_attribute16
2266 ,p_attribute17 => p_per_attribute17
2267 ,p_attribute18 => p_per_attribute18
2268 ,p_attribute19 => p_per_attribute19
2269 ,p_attribute20 => p_per_attribute20
2270 ,p_attribute21 => p_per_attribute21
2271 ,p_attribute22 => p_per_attribute22
2272 ,p_attribute23 => p_per_attribute23
2273 ,p_attribute24 => p_per_attribute24
2274 ,p_attribute25 => p_per_attribute25
2275 ,p_attribute26 => p_per_attribute26
2276 ,p_attribute27 => p_per_attribute27
2277 ,p_attribute28 => p_per_attribute28
2278 ,p_attribute29 => p_per_attribute29
2279 ,p_attribute30 => p_per_attribute30
2280 ,p_per_information_category => 'JP'
2281 ,p_per_information1 => null
2282 ,p_per_information2 => null
2283 ,p_per_information3 => null
2284 ,p_per_information4 => null
2285 ,p_per_information5 => null
2286 ,p_per_information6 => null
2287 ,p_per_information7 => null
2288 ,p_per_information8 => null
2289 ,p_per_information9 => null
2290 ,p_per_information10 => null
2291 ,p_per_information11 => null
2292 ,p_per_information12 => null
2293 ,p_per_information13 => null
2294 ,p_per_information14 => null
2295 ,p_per_information15 => null
2296 ,p_per_information16 => null
2297 ,p_per_information17 => null
2298 ,p_per_information18 => p_last_name
2299 ,p_per_information19 => p_first_name
2300 ,p_per_information20 => p_previous_last_name
2301 ,p_correspondence_language => p_correspondence_language
2302 ,p_fte_capacity => p_fte_capacity
2303 ,p_hold_applicant_date_until => p_hold_applicant_date_until
2304 ,p_honors => p_honors
2305 ,p_mailstop => p_mailstop
2306 ,p_office_number => p_office_number
2307 ,p_on_military_service => p_on_military_service
2308 ,p_resume_exists => p_resume_exists
2309 ,p_resume_last_updated => p_resume_last_updated
2310 ,p_student_status => p_student_status
2311 ,p_work_schedule => p_work_schedule
2312 ,p_date_of_death => p_date_of_death
2313 ,p_original_date_of_hire => p_original_date_of_hire
2314 ,p_person_id => l_person_id
2315 ,p_assignment_id => p_assignment_id
2316 ,p_application_id => p_application_id
2317 ,p_per_object_version_number => p_per_object_version_number
2318 ,p_asg_object_version_number => p_asg_object_version_number
2319 ,p_apl_object_version_number => p_apl_object_version_number
2320 ,p_per_effective_start_date => p_per_effective_start_date
2321 ,p_per_effective_end_date => p_per_effective_end_date
2322 ,p_full_name => p_full_name
2323 ,p_per_comment_id => p_per_comment_id
2324 ,p_assignment_sequence => p_assignment_sequence
2325 ,p_name_combination_warning => p_name_combination_warning
2326 ,p_orig_hire_warning => p_orig_hire_warning
2327 );
2328 --
2329 hr_utility.set_location(l_proc, 30);
2330 --
2331 -- Create Educ Bkgrd if not all of the params are set to null.
2332 --
2333 if not (p_pea_comments is null
2334 and p_pea_date_from is null
2335 and p_pea_date_to is null
2336 and p_pea_attribute_category is null
2337 and p_pea_attribute1 is null
2338 and p_pea_attribute2 is null
2339 and p_pea_attribute3 is null
2340 and p_pea_attribute4 is null
2341 and p_pea_attribute5 is null
2342 and p_pea_attribute6 is null
2343 and p_pea_attribute7 is null
2344 and p_pea_attribute8 is null
2345 and p_pea_attribute9 is null
2346 and p_pea_attribute10 is null
2347 and p_pea_attribute11 is null
2348 and p_pea_attribute12 is null
2349 and p_pea_attribute13 is null
2350 and p_pea_attribute14 is null
2351 and p_pea_attribute15 is null
2352 and p_pea_attribute16 is null
2353 and p_pea_attribute17 is null
2354 and p_pea_attribute18 is null
2355 and p_pea_attribute19 is null
2356 and p_pea_attribute20 is null
2357 and p_school_type is null
2358 and p_school_id is null
2359 and p_school_name is null
2360 and p_school_name_kana is null
2361 and p_major is null
2362 and p_major_kana is null
2363 and p_advisor is null
2364 and p_graduation_date is null
2365 and p_note is null
2366 and p_last_flag is null
2367 ) then
2368 --
2369 hr_utility.set_location(l_proc, 40);
2370 --
2371 hr_jpbp_api.create_jp_educ_sit
2372 (p_validate => false
2373 ,p_person_id => l_person_id
2374 ,p_business_group_id => p_business_group_id
2375 ,p_effective_date => p_date_received
2376 ,p_comments => p_pea_comments
2377 ,p_date_from => p_pea_date_from
2378 ,p_date_to => p_pea_date_to
2379 ,p_attribute_category => p_pea_attribute_category
2380 ,p_attribute1 => p_pea_attribute1
2381 ,p_attribute2 => p_pea_attribute2
2382 ,p_attribute3 => p_pea_attribute3
2383 ,p_attribute4 => p_pea_attribute4
2384 ,p_attribute5 => p_pea_attribute5
2385 ,p_attribute6 => p_pea_attribute6
2386 ,p_attribute7 => p_pea_attribute7
2387 ,p_attribute8 => p_pea_attribute8
2388 ,p_attribute9 => p_pea_attribute9
2389 ,p_attribute10 => p_pea_attribute10
2390 ,p_attribute11 => p_pea_attribute11
2391 ,p_attribute12 => p_pea_attribute12
2392 ,p_attribute13 => p_pea_attribute13
2393 ,p_attribute14 => p_pea_attribute14
2394 ,p_attribute15 => p_pea_attribute15
2395 ,p_attribute16 => p_pea_attribute16
2396 ,p_attribute17 => p_pea_attribute17
2397 ,p_attribute18 => p_pea_attribute18
2398 ,p_attribute19 => p_pea_attribute19
2399 ,p_attribute20 => p_pea_attribute20
2400 ,p_segment1 => p_school_type
2401 ,p_segment2 => p_school_id
2402 ,p_segment3 => p_school_name
2403 ,p_segment4 => p_school_name_kana
2404 ,p_segment5 => p_major
2405 ,p_segment6 => p_major_kana
2406 ,p_segment8 => p_graduation_date
2407 ,p_segment7 => p_advisor
2408 ,p_segment9 => p_note
2409 ,p_segment10 => p_last_flag
2410 ,p_segment11 => null
2411 ,p_segment12 => null
2412 ,p_segment13 => null
2413 ,p_segment14 => null
2414 ,p_segment15 => null
2415 ,p_segment16 => null
2416 ,p_segment17 => null
2417 ,p_segment18 => null
2418 ,p_segment19 => null
2419 ,p_segment20 => null
2420 ,p_segment21 => null
2421 ,p_segment22 => null
2422 ,p_segment23 => null
2423 ,p_segment24 => null
2424 ,p_segment25 => null
2425 ,p_segment26 => null
2426 ,p_segment27 => null
2427 ,p_segment28 => null
2428 ,p_segment29 => null
2429 ,p_segment30 => null
2430 ,p_analysis_criteria_id => p_analysis_criteria_id
2431 ,p_person_analysis_id => p_person_analysis_id
2432 ,p_pea_object_version_number => p_pea_object_version_number
2433 );
2434 --
2435 end if;
2436 --
2437 hr_utility.set_location(l_proc, 50);
2438 --
2439 -- call create_person_address if not all parameters are null.
2440 --
2441 if not
2442 (p_add_date_from is null
2443 and p_add_date_to is null
2444 and p_address_type is null
2445 and p_add_comments is null
2446 and p_address_line1 is null
2447 and p_address_line2 is null
2448 and p_address_line3 is null
2449 and p_district_code is null
2450 and p_address_line1_kana is null
2451 and p_address_line2_kana is null
2452 and p_address_line3_kana is null
2453 and p_postcode is null
2454 and p_country is null
2455 and p_telephone_number_1 is null
2456 and p_telephone_number_2 is null
2457 and p_fax_number is null
2458 and p_addr_attribute_category is null
2459 and p_addr_attribute1 is null
2460 and p_addr_attribute2 is null
2461 and p_addr_attribute3 is null
2462 and p_addr_attribute4 is null
2463 and p_addr_attribute5 is null
2464 and p_addr_attribute6 is null
2465 and p_addr_attribute7 is null
2466 and p_addr_attribute8 is null
2467 and p_addr_attribute9 is null
2468 and p_addr_attribute10 is null
2469 and p_addr_attribute11 is null
2470 and p_addr_attribute12 is null
2471 and p_addr_attribute13 is null
2472 and p_addr_attribute14 is null
2473 and p_addr_attribute15 is null
2474 and p_addr_attribute16 is null
2475 and p_addr_attribute17 is null
2476 and p_addr_attribute18 is null
2477 and p_addr_attribute19 is null
2478 and p_addr_attribute20 is null) then
2479 --
2480 hr_utility.set_location(l_proc, 60);
2481 --
2482 hr_person_address_api.create_person_address
2483 ( p_validate => false
2484 ,p_effective_date => p_date_received
2485 ,p_person_id => l_person_id
2486 ,p_primary_flag => 'Y'
2487 ,p_style => 'JP'
2488 ,p_date_from => p_add_date_from
2489 ,p_date_to => p_add_date_to
2490 ,p_address_type => p_address_type
2491 ,p_comments => p_add_comments
2492 ,p_address_line1 => p_address_line1
2493 ,p_address_line2 => p_address_line2
2494 ,p_address_line3 => p_address_line3
2495 ,p_town_or_city => p_district_code
2496 ,p_region_1 => p_address_line1_kana
2497 ,p_region_2 => p_address_line2_kana
2498 ,p_region_3 => p_address_line3_kana
2499 ,p_postal_code => p_postcode
2500 ,p_country => p_country
2501 ,p_telephone_number_1 => p_telephone_number_1
2502 ,p_telephone_number_2 => p_telephone_number_2
2503 ,p_telephone_number_3 => p_fax_number
2504 ,p_addr_attribute_category => p_addr_attribute_category
2505 ,p_addr_attribute1 => p_addr_attribute1
2506 ,p_addr_attribute2 => p_addr_attribute2
2507 ,p_addr_attribute3 => p_addr_attribute3
2508 ,p_addr_attribute4 => p_addr_attribute4
2509 ,p_addr_attribute5 => p_addr_attribute5
2510 ,p_addr_attribute6 => p_addr_attribute6
2511 ,p_addr_attribute7 => p_addr_attribute7
2512 ,p_addr_attribute8 => p_addr_attribute8
2513 ,p_addr_attribute9 => p_addr_attribute9
2514 ,p_addr_attribute10 => p_addr_attribute10
2515 ,p_addr_attribute11 => p_addr_attribute11
2516 ,p_addr_attribute12 => p_addr_attribute12
2517 ,p_addr_attribute13 => p_addr_attribute13
2518 ,p_addr_attribute14 => p_addr_attribute14
2519 ,p_addr_attribute15 => p_addr_attribute15
2520 ,p_addr_attribute16 => p_addr_attribute16
2521 ,p_addr_attribute17 => p_addr_attribute17
2522 ,p_addr_attribute18 => p_addr_attribute18
2523 ,p_addr_attribute19 => p_addr_attribute19
2524 ,p_addr_attribute20 => p_addr_attribute20
2525 ,p_address_id => p_address_id
2526 ,p_object_version_number => p_add_object_version_number
2527 );
2528 end if;
2529 --
2530 --
2531 hr_utility.set_location(l_proc, 70);
2532 --
2533 --
2534 if p_validate then
2535 raise hr_api.validate_enabled;
2536 end if;
2537 --
2538 -- Set all output arguments
2539 --
2540 p_person_id := l_person_id;
2541 --
2542 hr_utility.set_location(' Leaving:'||l_proc, 80);
2543 --
2544 exception
2545 when hr_api.validate_enabled then
2546 --
2547 -- As the Validate_Enabled exception has been raised
2548 -- we must rollback to the savepoint
2549 --
2550 ROLLBACK TO create_jp_appl_with_educ_add;
2551 --
2552 -- Only set output warning arguments
2553 -- (Any key or derived arguments must be set to null
2554 -- when validation only mode is being used.)
2555 --
2556 p_person_id := null;
2557 p_assignment_id := null;
2558 p_application_id := null;
2559 p_per_object_version_number := null;
2560 p_asg_object_version_number := null;
2561 p_apl_object_version_number := null;
2562 p_per_effective_start_date := null;
2563 p_per_effective_end_date := null;
2564 p_full_name := null;
2565 p_per_comment_id := null;
2566 p_assignment_sequence := null;
2567
2568 p_pea_object_version_number := null;
2569 p_analysis_criteria_id := null;
2570 p_person_analysis_id := null;
2571
2572 p_address_id := null;
2573 p_add_object_version_number := null;
2574
2575 hr_utility.set_location(' Leaving:'||l_proc, 90);
2576
2577 when others then
2578 --
2579 -- A validation or unexpected error has occurred
2580 --
2581 ROLLBACK TO create_jp_appl_with_educ_add;
2582 --
2583 -- Reset IN OUT parameters and set OUT parameters
2584 --
2585 p_applicant_number := l_applicant_number;
2586
2587 p_person_id := null;
2588 p_assignment_id := null;
2589 p_application_id := null;
2590 p_per_object_version_number := null;
2591 p_asg_object_version_number := null;
2592 p_apl_object_version_number := null;
2593 p_per_effective_start_date := null;
2594 p_per_effective_end_date := null;
2595 p_full_name := null;
2596 p_per_comment_id := null;
2597 p_assignment_sequence := null;
2598 p_name_combination_warning := null;
2599 p_orig_hire_warning := null;
2600
2601 p_pea_object_version_number := null;
2602 p_analysis_criteria_id := null;
2603 p_person_analysis_id := null;
2604
2605 p_address_id := null;
2606 p_add_object_version_number := null;
2607
2608 hr_utility.set_location(' Leaving:'||l_proc, 100);
2609 raise;
2610 end create_jp_appl_with_educ_add;
2611 --
2612 end HR_JPBP_API;