[Home] [Help]
97: ,bus.business_group_id
98: ,bus.legislation_code
99: FROM per_people_f per
100: ,per_business_groups bus
101: ,per_person_types pet
102: WHERE per.person_type_id = pet.person_type_id
103: AND per.business_group_id+0 = bus.business_group_id
104: AND per.person_id = csr_per_details.p_person_id
105: AND csr_per_details.p_effective_date BETWEEN per.effective_start_date
632: (p_validate IN BOOLEAN DEFAULT FALSE
633: ,p_hire_date IN DATE
634: ,p_person_id IN per_all_people_f.person_id%TYPE
635: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
636: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
637: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
638: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
639: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
640: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
696: (p_validate IN BOOLEAN DEFAULT FALSE
697: ,p_hire_date IN DATE
698: ,p_person_id IN per_all_people_f.person_id%TYPE
699: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
700: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
701: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
702: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
703: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
704: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
761: (p_validate IN BOOLEAN DEFAULT FALSE
762: ,p_hire_date IN DATE
763: ,p_person_id IN per_all_people_f.person_id%TYPE
764: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
765: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
766: ,p_hire_all_accepted_asgs IN VARCHAR2
767: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
768: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
769: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
809: (p_validate IN BOOLEAN DEFAULT FALSE
810: ,p_hire_date IN DATE
811: ,p_person_id IN per_all_people_f.person_id%TYPE
812: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
813: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
814: ,p_hire_all_accepted_asgs IN VARCHAR2
815: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
816: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
817: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
828: l_proc VARCHAR2(72) := g_package||'hire_to_employee_applicant';
829: --
830: l_hire_date DATE;
831: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
832: l_person_type_id per_person_types.person_type_id%TYPE := p_person_type_id;
833: l_person_type_id1 per_person_types.person_type_id%TYPE;
834: --
835: l_new_primary_asg_id per_all_assignments_f.assignment_id%TYPE;
836: l_hire_all_accepted_asgs VARCHAR2(1);
829: --
830: l_hire_date DATE;
831: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
832: l_person_type_id per_person_types.person_type_id%TYPE := p_person_type_id;
833: l_person_type_id1 per_person_types.person_type_id%TYPE;
834: --
835: l_new_primary_asg_id per_all_assignments_f.assignment_id%TYPE;
836: l_hire_all_accepted_asgs VARCHAR2(1);
837: l_hire_single_asg_id per_all_assignments_f.assignment_id%TYPE;
843: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
844: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
845: l_assign_payroll_warning BOOLEAN;
846: --
847: l_system_person_type per_person_types.system_person_type%TYPE;
848: l_future_asgs_count INTEGER;
849: l_nonaccepted_asgs_count INTEGER;
850: l_accepted_asgs_count INTEGER;
851: l_primary_asgs_count INTEGER;
1328: -- PTU : Following Code has been added
1329: --
1330: begin
1331: select ptuf.person_type_id into l_person_type_id1
1332: from per_person_type_usages_f ptuf, per_person_types ppt
1333: where ptuf.person_id = p_person_id
1334: and l_hire_date between ptuf.effective_start_date and ptuf.effective_end_date
1335: and ppt.person_type_id = ptuf.person_type_id
1336: and ppt.system_person_type = 'EMP';
1716: l_unaccepted_asg_del_warning boolean;
1717: --
1718: l_primary_assignment_id number:=p_primary_assignment_id;
1719: --
1720: l_system_person_type per_person_types.system_person_type%TYPE;
1721: l_business_group_id per_all_people_f.business_group_id%TYPE;
1722: l_legislation_code per_business_groups.legislation_code%TYPE;
1723: l_application_id per_applications.application_id%TYPE;
1724: l_apl_object_version_number per_applications.application_id%TYPE;
1804: pap.application_id,
1805: pap.object_version_number
1806: from per_all_people_f per,
1807: per_business_groups bus,
1808: per_person_types ppt,
1809: per_applications pap
1810: where per.person_type_id = ppt.person_type_id
1811: and per.business_group_id = bus.business_group_id
1812: and per.person_id = pap.person_id
4181: l_unaccepted_asg_del_warning boolean;
4182: --
4183: l_primary_assignment_id number:=p_primary_assignment_id;
4184: --
4185: l_system_person_type per_person_types.system_person_type%TYPE;
4186: l_business_group_id per_all_people_f.business_group_id%TYPE;
4187: l_legislation_code per_business_groups.legislation_code%TYPE;
4188: l_application_id per_applications.application_id%TYPE;
4189: l_apl_object_version_number per_applications.application_id%TYPE;
4277: pap.application_id,
4278: pap.object_version_number
4279: from per_all_people_f per,
4280: per_business_groups bus,
4281: per_person_types ppt,
4282: per_applications pap
4283: where per.person_type_id = ppt.person_type_id
4284: and per.business_group_id = bus.business_group_id
4285: and per.person_id = pap.person_id