[Home] [Help]
326: --
327: IF g_debug THEN
328: hr_utility.set_location(g_package || l_proc, 80);
329: END IF;
330: per_people3_pkg.check_future_apl(p_person_id => p_person_id
331: ,p_hire_date => greatest(p_hire_date
332: ,p_effective_start_date));
333: --
334: -- Insert the default applicant row and applicant
385: --
386: IF g_debug THEN
387: hr_utility.set_location(g_package || l_proc, 110);
388: END IF;
389: per_people3_pkg.check_future_apl(p_person_id => p_person_id
390: ,p_hire_date => greatest(p_hire_date
391: ,p_effective_start_date));
392: --
393: -- Insert the default period_of service and assignment
438: --
439: IF g_debug THEN
440: hr_utility.set_location(g_package || l_proc, 130);
441: END IF;
442: per_people3_pkg.check_future_apl(p_person_id => p_person_id
443: ,p_hire_date => greatest(p_hire_date
444: ,p_effective_start_date));
445: --
446: -- Check if the person have open term_assignment records. These can be
466: --
467: IF g_debug THEN
468: hr_utility.set_location(g_package || l_proc, 150);
469: END IF;
470: per_people3_pkg.vacancy_chk(p_person_id => p_person_id
471: ,p_fire_warning => l_fire_warning
472: ,p_vacancy_id => p_vacancy_id);
473: if l_fire_warning = 'Y' then
474: return;
479: end if; -- End of VACANCY_CHECK
480: --
481: if p_status = 'BOOKINGS_EXIST' then
482: -- VT 09/18/96 #288087, #380280, #2172590
483: if (per_people3_pkg.chk_events_exist(p_person_id =>p_person_id
484: ,p_business_group_id =>p_business_group_id
485: ,p_hire_date => greatest(p_hire_date,p_session_date))) then
486: return;
487: else
504: --
505: IF g_debug THEN
506: hr_utility.set_location(g_package || l_proc, 170);
507: END IF;
508: per_people3_pkg.get_accepted_appls(p_person_id => p_person_id
509: ,p_num_accepted_appls => l_num_accepted_appls
510: ,p_new_primary_id =>p_new_primary_id);
511: --
512: -- Get all current applicant assignments.
513: --
514: IF g_debug THEN
515: hr_utility.set_location(g_package || l_proc, 180);
516: END IF;
517: per_people3_pkg.get_all_current_appls(p_person_id => p_person_id
518: ,p_num_appls => l_num_appls);
519: --
520: if p_system_person_type = 'EMP_APL' then
521: --
755: --
756: IF g_debug THEN
757: hr_utility.set_location(g_package || l_proc, 220);
758: END IF;
759: per_people3_pkg.run_alu_ee(p_alu_mode => 'CHANGE_PQC'
760: ,p_business_group_id=>p_business_group_id
761: ,p_person_id =>p_person_id
762: ,p_old_start =>p_s_hire_date
763: ,p_start_date => p_last_update_date
777: --
778: IF g_debug THEN
779: hr_utility.set_location(g_package || l_proc, 230);
780: END IF;
781: per_people3_pkg.update_period(p_person_id =>p_person_id
782: ,p_hire_date => p_s_hire_date
783: ,p_new_hire_date =>p_hire_date);
784: --
785: hr_utility.set_location('update_row - after update',3);
843: --
844: IF g_debug THEN
845: hr_utility.set_location(g_package || l_proc, 270);
846: END IF;
847: per_people3_pkg.run_alu_ee(p_alu_mode => 'ASG_CRITERIA'
848: ,p_business_group_id=>p_business_group_id
849: ,p_person_id =>p_person_id
850: ,p_old_start =>p_s_hire_date
851: ,p_start_date => p_hire_date);