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

APPS.HR_EMPLOYEE_APPLICANT_API dependencies on PER_ALL_PEOPLE_F

Line 18: (p_person_id IN per_all_people_f.person_id%TYPE

14: --
15: -- Package cursors
16: --
17: CURSOR csr_future_asgs
18: (p_person_id IN per_all_people_f.person_id%TYPE
19: ,p_effective_date IN DATE
20: ,p_assignment_id IN per_all_assignments_f.assignment_id%type --2264191 added
21: )
22: IS

Line 33: (p_person_id IN per_all_people_f.person_id%TYPE

29: (p_assignment_id is not null AND
30: p_assignment_id = asg.assignment_id));
31: --
32: CURSOR csr_nonaccepted_asgs
33: (p_person_id IN per_all_people_f.person_id%TYPE
34: ,p_effective_date IN DATE
35: )
36: IS
37: SELECT asg.assignment_id

Line 49: (p_person_id IN per_all_people_f.person_id%TYPE

45: AND asg.assignment_type = 'A'
46: AND ast.per_system_status <> 'ACCEPTED';
47: --
48: CURSOR csr_accepted_asgs
49: (p_person_id IN per_all_people_f.person_id%TYPE
50: ,p_effective_date IN DATE
51: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT hr_api.g_number
52: )
53: IS

Line 69: (p_person_id IN per_all_people_f.person_id%TYPE

65: AND asg.assignment_type = 'A'
66: AND ast.per_system_status = 'ACCEPTED';
67: --
68: CURSOR csr_primary_asgs
69: (p_person_id IN per_all_people_f.person_id%TYPE
70: ,p_effective_date IN DATE
71: )
72: IS
73: SELECT asg.assignment_id

Line 86: (p_person_id IN per_all_people_f.person_id%TYPE

82: AND asg.primary_flag = 'Y'
83: AND ast.per_system_status = 'ACTIVE_ASSIGN';
84: --
85: CURSOR csr_per_details
86: (p_person_id IN per_all_people_f.person_id%TYPE
87: ,p_effective_date IN DATE
88: )
89: IS
90: SELECT pet.person_type_id

Line 109: (p_person_id IN per_all_people_f.person_id%TYPE

105: AND csr_per_details.p_effective_date BETWEEN per.effective_start_date
106: AND per.effective_end_date;
107: --
108: CURSOR csr_apl_details
109: (p_person_id IN per_all_people_f.person_id%TYPE
110: ,p_effective_date IN DATE
111: )
112: IS
113: SELECT apl.application_id

Line 121: (p_person_id IN per_all_people_f.person_id%TYPE

117: AND csr_apl_details.p_effective_date BETWEEN apl.date_received
118: AND NVL(apl.date_end,hr_api.g_eot);
119: --
120: CURSOR csr_pds_details
121: (p_person_id IN per_all_people_f.person_id%TYPE
122: ,p_effective_date IN DATE
123: )
124: IS
125: SELECT pds.period_of_service_id

Line 165: (p_person_id IN per_all_people_f.person_id%TYPE

161: --
162: -- {End Of Comments}
163: --
164: FUNCTION future_asgs_count
165: (p_person_id IN per_all_people_f.person_id%TYPE
166: ,p_effective_date IN DATE
167: ,p_assignment_id IN per_all_assignments_f.assignment_id%type DEFAULT NULL --2264191 added
168: )
169: RETURN INTEGER

Line 238: (p_person_id IN per_all_people_f.person_id%TYPE

234: --
235: -- {End Of Comments}
236: --
237: FUNCTION nonaccepted_asgs_count
238: (p_person_id IN per_all_people_f.person_id%TYPE
239: ,p_effective_date IN DATE
240: )
241: RETURN INTEGER
242: IS

Line 309: (p_person_id IN per_all_people_f.person_id%TYPE

305: --
306: -- {End Of Comments}
307: --
308: FUNCTION accepted_asgs_count
309: (p_person_id IN per_all_people_f.person_id%TYPE
310: ,p_effective_date IN DATE
311: )
312: RETURN INTEGER
313: IS

Line 380: (p_person_id IN per_all_people_f.person_id%TYPE

376: --
377: -- {End Of Comments}
378: --
379: FUNCTION primary_asgs_count
380: (p_person_id IN per_all_people_f.person_id%TYPE
381: ,p_effective_date IN DATE
382: )
383: RETURN INTEGER
384: IS

Line 449: (p_person_id IN per_all_people_f.person_id%TYPE

445: --
446: -- {End Of Comments}
447: --
448: FUNCTION per_details
449: (p_person_id IN per_all_people_f.person_id%TYPE
450: ,p_effective_date IN DATE
451: )
452: RETURN csr_per_details%ROWTYPE
453: IS

Line 522: (p_person_id IN per_all_people_f.person_id%TYPE

518: --
519: -- {End Of Comments}
520: --
521: FUNCTION apl_details
522: (p_person_id IN per_all_people_f.person_id%TYPE
523: ,p_effective_date IN DATE
524: )
525: RETURN csr_apl_details%ROWTYPE
526: IS

Line 588: (p_person_id IN per_all_people_f.person_id%TYPE

584: --
585: -- {End Of Comments}
586: --
587: FUNCTION pds_details
588: (p_person_id IN per_all_people_f.person_id%TYPE
589: ,p_effective_date IN DATE
590: )
591: RETURN csr_pds_details%ROWTYPE
592: IS

Line 634: ,p_person_id IN per_all_people_f.person_id%TYPE

630: --
631: PROCEDURE hire_to_employee_applicant
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

Line 635: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE

631: PROCEDURE hire_to_employee_applicant
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

Line 638: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE

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
641: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
642: )

Line 639: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%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
641: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
642: )
643: IS

Line 640: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%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
641: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
642: )
643: IS
644: --

Line 649: l_per_object_version_number per_all_people_f.object_version_number%TYPE;

645: -- Local variables
646: --
647: l_proc VARCHAR2(72) := g_package||'hire__to_employee_applicant';
648: --
649: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
650: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
651: l_employee_number per_all_people_f.employee_number%TYPE;
652: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
653: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;

Line 650: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;

646: --
647: l_proc VARCHAR2(72) := g_package||'hire__to_employee_applicant';
648: --
649: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
650: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
651: l_employee_number per_all_people_f.employee_number%TYPE;
652: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
653: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
654: l_assign_payroll_warning BOOLEAN;

Line 651: l_employee_number per_all_people_f.employee_number%TYPE;

647: l_proc VARCHAR2(72) := g_package||'hire__to_employee_applicant';
648: --
649: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
650: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
651: l_employee_number per_all_people_f.employee_number%TYPE;
652: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
653: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
654: l_assign_payroll_warning BOOLEAN;
655: l_oversubscribed_vacancy_id number;

Line 652: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;

648: --
649: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
650: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
651: l_employee_number per_all_people_f.employee_number%TYPE;
652: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
653: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
654: l_assign_payroll_warning BOOLEAN;
655: l_oversubscribed_vacancy_id number;
656: --

Line 653: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;

649: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
650: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
651: l_employee_number per_all_people_f.employee_number%TYPE;
652: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
653: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
654: l_assign_payroll_warning BOOLEAN;
655: l_oversubscribed_vacancy_id number;
656: --
657: BEGIN

Line 698: ,p_person_id IN per_all_people_f.person_id%TYPE

694: --
695: PROCEDURE hire_to_employee_applicant
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

Line 699: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE

695: PROCEDURE hire_to_employee_applicant
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

Line 702: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE

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
705: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
706: ,p_oversubscribed_vacancy_id out nocopy number

Line 703: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%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
705: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
706: ,p_oversubscribed_vacancy_id out nocopy number
707: )

Line 704: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%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
705: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
706: ,p_oversubscribed_vacancy_id out nocopy number
707: )
708: IS

Line 714: l_per_object_version_number per_all_people_f.object_version_number%TYPE;

710: -- Local variables
711: --
712: l_proc VARCHAR2(72) := g_package||'hire__to_employee_applicant';
713: --
714: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
715: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
716: l_employee_number per_all_people_f.employee_number%TYPE;
717: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
718: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;

Line 715: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;

711: --
712: l_proc VARCHAR2(72) := g_package||'hire__to_employee_applicant';
713: --
714: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
715: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
716: l_employee_number per_all_people_f.employee_number%TYPE;
717: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
718: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
719: l_assign_payroll_warning BOOLEAN;

Line 716: l_employee_number per_all_people_f.employee_number%TYPE;

712: l_proc VARCHAR2(72) := g_package||'hire__to_employee_applicant';
713: --
714: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
715: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
716: l_employee_number per_all_people_f.employee_number%TYPE;
717: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
718: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
719: l_assign_payroll_warning BOOLEAN;
720: l_oversubscribed_vacancy_id number;

Line 717: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;

713: --
714: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
715: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
716: l_employee_number per_all_people_f.employee_number%TYPE;
717: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
718: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
719: l_assign_payroll_warning BOOLEAN;
720: l_oversubscribed_vacancy_id number;
721: --

Line 718: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;

714: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
715: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
716: l_employee_number per_all_people_f.employee_number%TYPE;
717: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
718: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
719: l_assign_payroll_warning BOOLEAN;
720: l_oversubscribed_vacancy_id number;
721: --
722: BEGIN

Line 761: ,p_person_id IN per_all_people_f.person_id%TYPE

757: --
758: PROCEDURE hire_to_employee_applicant
759: (p_validate IN BOOLEAN DEFAULT FALSE
760: ,p_hire_date IN DATE
761: ,p_person_id IN per_all_people_f.person_id%TYPE
762: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
763: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
764: ,p_hire_all_accepted_asgs IN VARCHAR2
765: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL

Line 762: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE

758: PROCEDURE hire_to_employee_applicant
759: (p_validate IN BOOLEAN DEFAULT FALSE
760: ,p_hire_date IN DATE
761: ,p_person_id IN per_all_people_f.person_id%TYPE
762: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
763: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
764: ,p_hire_all_accepted_asgs IN VARCHAR2
765: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
766: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2

Line 766: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2

762: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
763: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
764: ,p_hire_all_accepted_asgs IN VARCHAR2
765: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
766: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
767: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
768: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
769: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
770: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN

Line 767: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE

763: ,p_person_type_id IN per_person_types.person_type_id%TYPE DEFAULT NULL
764: ,p_hire_all_accepted_asgs IN VARCHAR2
765: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
766: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
767: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
768: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
769: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
770: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
771: ,p_oversubscribed_vacancy_id out nocopy number

Line 768: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE

764: ,p_hire_all_accepted_asgs IN VARCHAR2
765: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
766: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
767: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
768: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
769: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
770: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
771: ,p_oversubscribed_vacancy_id out nocopy number
772: )

Line 769: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE

765: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
766: ,p_national_identifier IN per_all_people_f.national_identifier%TYPE DEFAULT hr_api.g_varchar2
767: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_number%TYPE
768: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
769: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
770: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
771: ,p_oversubscribed_vacancy_id out nocopy number
772: )
773: IS

Line 780: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;

776: --
777: l_proc VARCHAR2(72) := g_package||'hire_to_employee_applicant';
778: --
779: l_hire_date DATE;
780: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
781: l_person_type_id per_person_types.person_type_id%TYPE := p_person_type_id;
782: l_person_type_id1 per_person_types.person_type_id%TYPE;
783: --
784: l_new_primary_asg_id per_all_assignments_f.assignment_id%TYPE;

Line 788: l_per_object_version_number CONSTANT per_all_people_f.object_version_number%TYPE := p_per_object_version_number;

784: l_new_primary_asg_id per_all_assignments_f.assignment_id%TYPE;
785: l_hire_all_accepted_asgs VARCHAR2(1);
786: l_hire_single_asg_id per_all_assignments_f.assignment_id%TYPE;
787: --
788: l_per_object_version_number CONSTANT per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
789: l_employee_number CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;
790: l_emp_num CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;
791: --
792: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;

Line 789: l_employee_number CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;

785: l_hire_all_accepted_asgs VARCHAR2(1);
786: l_hire_single_asg_id per_all_assignments_f.assignment_id%TYPE;
787: --
788: l_per_object_version_number CONSTANT per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
789: l_employee_number CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;
790: l_emp_num CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;
791: --
792: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
793: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;

Line 790: l_emp_num CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;

786: l_hire_single_asg_id per_all_assignments_f.assignment_id%TYPE;
787: --
788: l_per_object_version_number CONSTANT per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
789: l_employee_number CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;
790: l_emp_num CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;
791: --
792: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
793: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
794: l_assign_payroll_warning BOOLEAN;

Line 792: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;

788: l_per_object_version_number CONSTANT per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
789: l_employee_number CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;
790: l_emp_num CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;
791: --
792: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
793: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
794: l_assign_payroll_warning BOOLEAN;
795: --
796: l_system_person_type per_person_types.system_person_type%TYPE;

Line 793: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;

789: l_employee_number CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;
790: l_emp_num CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;
791: --
792: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
793: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
794: l_assign_payroll_warning BOOLEAN;
795: --
796: l_system_person_type per_person_types.system_person_type%TYPE;
797: l_future_asgs_count INTEGER;

Line 810: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;

806: l_validation_start_date DATE;
807: l_validation_end_date DATE;
808: l_business_group_id hr_all_organization_units.organization_id%TYPE;
809: l_comment_id hr_comments.comment_id%TYPE;
810: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
811: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
812: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
813: l_full_name per_all_people_f.full_name%TYPE;
814: l_name_combination_warning BOOLEAN;

Line 811: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;

807: l_validation_end_date DATE;
808: l_business_group_id hr_all_organization_units.organization_id%TYPE;
809: l_comment_id hr_comments.comment_id%TYPE;
810: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
811: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
812: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
813: l_full_name per_all_people_f.full_name%TYPE;
814: l_name_combination_warning BOOLEAN;
815: l_orig_hire_warning BOOLEAN;

Line 812: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;

808: l_business_group_id hr_all_organization_units.organization_id%TYPE;
809: l_comment_id hr_comments.comment_id%TYPE;
810: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
811: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
812: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
813: l_full_name per_all_people_f.full_name%TYPE;
814: l_name_combination_warning BOOLEAN;
815: l_orig_hire_warning BOOLEAN;
816: l_payroll_id_updated BOOLEAN;

Line 813: l_full_name per_all_people_f.full_name%TYPE;

809: l_comment_id hr_comments.comment_id%TYPE;
810: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
811: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
812: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
813: l_full_name per_all_people_f.full_name%TYPE;
814: l_name_combination_warning BOOLEAN;
815: l_orig_hire_warning BOOLEAN;
816: l_payroll_id_updated BOOLEAN;
817: l_other_manager_warning BOOLEAN;

Line 844: from per_all_people_f

840: --
841: cursor csr_future_per_changes(p_effective_date DATE) is
842: select 1 from dual where exists
843: (select 1
844: from per_all_people_f
845: where person_id = p_person_id
846: and effective_start_date >= p_effective_date);
847: --
848: BEGIN

Line 1420: p_person_id in per_all_people_f.person_id%TYPE,

1416: --
1417: procedure hire_employee_applicant
1418: (p_validate in boolean default false,
1419: p_hire_date in date,
1420: p_person_id in per_all_people_f.person_id%TYPE,
1421: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1422: p_person_type_id in number default null,
1423: p_assignment_id in number default null,
1424: p_per_effective_start_date out nocopy date,

Line 1421: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,

1417: procedure hire_employee_applicant
1418: (p_validate in boolean default false,
1419: p_hire_date in date,
1420: p_person_id in per_all_people_f.person_id%TYPE,
1421: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1422: p_person_type_id in number default null,
1423: p_assignment_id in number default null,
1424: p_per_effective_start_date out nocopy date,
1425: p_per_effective_end_date out nocopy date,

Line 1435: l_per_object_version_number per_all_people_f.object_version_number%TYPE;

1431: -- Declare cursors and local variables
1432: --
1433: l_proc varchar2(72) := g_package||'hire__employee_applicant';
1434: --
1435: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
1436: l_per_effective_start_date date;
1437: l_per_effective_end_date date;
1438: l_unaccepted_asg_del_warning boolean;
1439: l_assign_payroll_warning boolean;

Line 1478: p_person_id in per_all_people_f.person_id%TYPE,

1474: --
1475: procedure hire_employee_applicant
1476: (p_validate in boolean default false,
1477: p_hire_date in date,
1478: p_person_id in per_all_people_f.person_id%TYPE,
1479: p_primary_assignment_id in number default null,
1480: p_person_type_id in number default null,
1481: p_overwrite_primary in varchar2 default 'N',
1482: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,

Line 1482: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,

1478: p_person_id in per_all_people_f.person_id%TYPE,
1479: p_primary_assignment_id in number default null,
1480: p_person_type_id in number default null,
1481: p_overwrite_primary in varchar2 default 'N',
1482: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1483: p_per_effective_start_date out nocopy date,
1484: p_per_effective_end_date out nocopy date,
1485: p_unaccepted_asg_del_warning out nocopy boolean,
1486: p_assign_payroll_warning out nocopy boolean

Line 1498: l_chk_person_id per_all_people_f.person_id%TYPE;

1494: --
1495: l_exists varchar2(1);
1496: l_count number;
1497: l_chk_system_status per_assignment_status_types.per_system_status%TYPE;
1498: l_chk_person_id per_all_people_f.person_id%TYPE;
1499: --
1500: l_person_type_id number := p_person_type_id;
1501: l_person_type_id1 number;
1502: l_unaccepted_asg_del_warning boolean;

Line 1507: l_business_group_id per_all_people_f.business_group_id%TYPE;

1503: --
1504: l_primary_assignment_id number:=p_primary_assignment_id;
1505: --
1506: l_system_person_type per_person_types.system_person_type%TYPE;
1507: l_business_group_id per_all_people_f.business_group_id%TYPE;
1508: l_legislation_code per_business_groups.legislation_code%TYPE;
1509: l_application_id per_applications.application_id%TYPE;
1510: l_apl_object_version_number per_applications.application_id%TYPE;
1511: --

Line 1518: l_per_object_version_number per_all_people_f.object_version_number%TYPE;

1514: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
1515: l_assignment_id per_assignments_f.assignment_id%TYPE;
1516: l_asg_object_version_number per_assignments_f.object_version_number%TYPE;
1517: --
1518: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
1519: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
1520: l_employee_number per_all_people_f.employee_number%TYPE;
1521: l_applicant_number per_all_people_f.applicant_number%TYPE;
1522: l_npw_number per_all_people_f.npw_number%TYPE;

Line 1519: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;

1515: l_assignment_id per_assignments_f.assignment_id%TYPE;
1516: l_asg_object_version_number per_assignments_f.object_version_number%TYPE;
1517: --
1518: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
1519: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
1520: l_employee_number per_all_people_f.employee_number%TYPE;
1521: l_applicant_number per_all_people_f.applicant_number%TYPE;
1522: l_npw_number per_all_people_f.npw_number%TYPE;
1523: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;

Line 1520: l_employee_number per_all_people_f.employee_number%TYPE;

1516: l_asg_object_version_number per_assignments_f.object_version_number%TYPE;
1517: --
1518: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
1519: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
1520: l_employee_number per_all_people_f.employee_number%TYPE;
1521: l_applicant_number per_all_people_f.applicant_number%TYPE;
1522: l_npw_number per_all_people_f.npw_number%TYPE;
1523: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
1524: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;

Line 1521: l_applicant_number per_all_people_f.applicant_number%TYPE;

1517: --
1518: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
1519: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
1520: l_employee_number per_all_people_f.employee_number%TYPE;
1521: l_applicant_number per_all_people_f.applicant_number%TYPE;
1522: l_npw_number per_all_people_f.npw_number%TYPE;
1523: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
1524: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
1525: l_comment_id per_assignments_f.comment_id%TYPE;

Line 1522: l_npw_number per_all_people_f.npw_number%TYPE;

1518: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
1519: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
1520: l_employee_number per_all_people_f.employee_number%TYPE;
1521: l_applicant_number per_all_people_f.applicant_number%TYPE;
1522: l_npw_number per_all_people_f.npw_number%TYPE;
1523: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
1524: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
1525: l_comment_id per_assignments_f.comment_id%TYPE;
1526: l_current_applicant_flag varchar2(1);

Line 1523: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;

1519: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
1520: l_employee_number per_all_people_f.employee_number%TYPE;
1521: l_applicant_number per_all_people_f.applicant_number%TYPE;
1522: l_npw_number per_all_people_f.npw_number%TYPE;
1523: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
1524: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
1525: l_comment_id per_assignments_f.comment_id%TYPE;
1526: l_current_applicant_flag varchar2(1);
1527: l_current_emp_or_apl_flag varchar2(1);

Line 1524: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;

1520: l_employee_number per_all_people_f.employee_number%TYPE;
1521: l_applicant_number per_all_people_f.applicant_number%TYPE;
1522: l_npw_number per_all_people_f.npw_number%TYPE;
1523: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
1524: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
1525: l_comment_id per_assignments_f.comment_id%TYPE;
1526: l_current_applicant_flag varchar2(1);
1527: l_current_emp_or_apl_flag varchar2(1);
1528: l_current_employee_flag varchar2(1);

Line 1529: l_full_name per_all_people_f.full_name%TYPE;

1525: l_comment_id per_assignments_f.comment_id%TYPE;
1526: l_current_applicant_flag varchar2(1);
1527: l_current_emp_or_apl_flag varchar2(1);
1528: l_current_employee_flag varchar2(1);
1529: l_full_name per_all_people_f.full_name%TYPE;
1530: l_name_combination_warning boolean;
1531: l_assign_payroll_warning boolean;
1532: l_orig_hire_warning boolean;
1533: l_oversubscribed_vacancy_id number;

Line 1585: from per_all_people_f per,

1581: per.employee_number,
1582: per.npw_number,
1583: pap.application_id,
1584: pap.object_version_number
1585: from per_all_people_f per,
1586: per_business_groups bus,
1587: per_person_types ppt,
1588: per_applications pap
1589: where per.person_type_id = ppt.person_type_id

Line 1611: from per_all_people_f per,

1607: --
1608: cursor csr_chk_assignment_id is
1609: select per.person_id,
1610: pas.per_system_status
1611: from per_all_people_f per,
1612: per_assignments_f asg,
1613: per_assignment_status_types pas
1614: where asg.assignment_status_type_id = pas.assignment_status_type_id
1615: and per.person_id = asg.person_id

Line 1994: -- Lock the person record in PER_ALL_PEOPLE_F ready for UPDATE at a later point.

1990: end if;
1991: --
1992: hr_utility.set_location(l_proc,170);
1993: --
1994: -- Lock the person record in PER_ALL_PEOPLE_F ready for UPDATE at a later point.
1995: -- (Note: This is necessary because calling the table handlers in locking
1996: -- ladder order invokes an error in per_apl_upd.upd due to the person
1997: -- being modified by the per_per_upd.upd table handler.)
1998: if l_per_effective_start_date=l_hire_date then

Line 2075: -- the per_all_people_f table.

2071: hr_utility.set_location(l_proc, 225);
2072:
2073: --
2074: -- Update the person details by calling upd procedure in
2075: -- the per_all_people_f table.
2076: --
2077: l_applicant_number:=hr_api.g_varchar2;
2078: l_employee_number:=hr_api.g_varchar2;
2079: per_per_upd.upd