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 763: ,p_person_id IN per_all_people_f.person_id%TYPE

759: --
760: PROCEDURE hire_to_employee_applicant
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

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

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

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

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
770: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
771: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
772: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN

Line 769: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_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
770: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
771: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
772: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
773: ,p_oversubscribed_vacancy_id OUT NOCOPY NUMBER

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

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
770: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
771: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
772: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
773: ,p_oversubscribed_vacancy_id OUT NOCOPY NUMBER
774: ) AS

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

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
770: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
771: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
772: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
773: ,p_oversubscribed_vacancy_id OUT NOCOPY NUMBER
774: ) AS
775:

Line 811: ,p_person_id IN per_all_people_f.person_id%TYPE

807: --
808: PROCEDURE hire_to_employee_applicant
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

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

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

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

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
818: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
819: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
820: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN

Line 817: ,p_employee_number IN OUT NOCOPY per_all_people_f.employee_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
818: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
819: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
820: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
821: ,p_oversubscribed_vacancy_id out nocopy number

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

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
818: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
819: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
820: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
821: ,p_oversubscribed_vacancy_id out nocopy number
822: ,p_upload_irec_docs IN VARCHAR2 --Added for bug 9879782

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

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
818: ,p_per_effective_start_date OUT NOCOPY per_all_people_f.effective_start_date%TYPE
819: ,p_per_effective_end_date OUT NOCOPY per_all_people_f.effective_end_date%TYPE
820: ,p_assign_payroll_warning OUT NOCOPY BOOLEAN
821: ,p_oversubscribed_vacancy_id out nocopy number
822: ,p_upload_irec_docs IN VARCHAR2 --Added for bug 9879782
823: )

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

827: --
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;

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

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;
838: --
839: l_per_object_version_number CONSTANT per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
840: l_employee_number CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;
841: l_emp_num CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;
842: --
843: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;

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

836: l_hire_all_accepted_asgs VARCHAR2(1);
837: l_hire_single_asg_id per_all_assignments_f.assignment_id%TYPE;
838: --
839: l_per_object_version_number CONSTANT per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
840: l_employee_number CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;
841: l_emp_num CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;
842: --
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;

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

837: l_hire_single_asg_id per_all_assignments_f.assignment_id%TYPE;
838: --
839: l_per_object_version_number CONSTANT per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
840: l_employee_number CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;
841: l_emp_num CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;
842: --
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;

Line 843: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;

839: l_per_object_version_number CONSTANT per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
840: l_employee_number CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;
841: l_emp_num CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;
842: --
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;

Line 844: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;

840: l_employee_number CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;
841: l_emp_num CONSTANT per_all_people_f.employee_number%TYPE := p_employee_number;
842: --
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;

Line 861: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;

857: l_validation_start_date DATE;
858: l_validation_end_date DATE;
859: l_business_group_id hr_all_organization_units.organization_id%TYPE;
860: l_comment_id hr_comments.comment_id%TYPE;
861: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
862: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
863: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
864: l_full_name per_all_people_f.full_name%TYPE;
865: l_name_combination_warning BOOLEAN;

Line 862: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;

858: l_validation_end_date DATE;
859: l_business_group_id hr_all_organization_units.organization_id%TYPE;
860: l_comment_id hr_comments.comment_id%TYPE;
861: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
862: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
863: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
864: l_full_name per_all_people_f.full_name%TYPE;
865: l_name_combination_warning BOOLEAN;
866: l_orig_hire_warning BOOLEAN;

Line 863: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;

859: l_business_group_id hr_all_organization_units.organization_id%TYPE;
860: l_comment_id hr_comments.comment_id%TYPE;
861: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
862: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
863: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
864: l_full_name per_all_people_f.full_name%TYPE;
865: l_name_combination_warning BOOLEAN;
866: l_orig_hire_warning BOOLEAN;
867: l_payroll_id_updated BOOLEAN;

Line 864: l_full_name per_all_people_f.full_name%TYPE;

860: l_comment_id hr_comments.comment_id%TYPE;
861: l_current_applicant_flag per_all_people_f.current_applicant_flag%TYPE;
862: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%TYPE;
863: l_current_employee_flag per_all_people_f.current_employee_flag%TYPE;
864: l_full_name per_all_people_f.full_name%TYPE;
865: l_name_combination_warning BOOLEAN;
866: l_orig_hire_warning BOOLEAN;
867: l_payroll_id_updated BOOLEAN;
868: l_other_manager_warning BOOLEAN;

Line 895: from per_all_people_f

891: --
892: cursor csr_future_per_changes(p_effective_date DATE) is
893: select 1 from dual where exists
894: (select 1
895: from per_all_people_f
896: where person_id = p_person_id
897: and effective_start_date >= p_effective_date);
898:
899: -- Start changes for bug 9879782

Line 1584: p_person_id in per_all_people_f.person_id%TYPE,

1580: --
1581: procedure hire_employee_applicant
1582: (p_validate in boolean default false,
1583: p_hire_date in date,
1584: p_person_id in per_all_people_f.person_id%TYPE,
1585: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1586: p_person_type_id in number default null,
1587: p_assignment_id in number default null,
1588: p_per_effective_start_date out nocopy date,

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

1581: procedure hire_employee_applicant
1582: (p_validate in boolean default false,
1583: p_hire_date in date,
1584: p_person_id in per_all_people_f.person_id%TYPE,
1585: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1586: p_person_type_id in number default null,
1587: p_assignment_id in number default null,
1588: p_per_effective_start_date out nocopy date,
1589: p_per_effective_end_date out nocopy date,

Line 1599: l_per_object_version_number per_all_people_f.object_version_number%TYPE;

1595: -- Declare cursors and local variables
1596: --
1597: l_proc varchar2(72) := g_package||'hire__employee_applicant';
1598: --
1599: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
1600: l_per_effective_start_date date;
1601: l_per_effective_end_date date;
1602: l_unaccepted_asg_del_warning boolean;
1603: l_assign_payroll_warning boolean;

Line 1644: p_person_id in per_all_people_f.person_id%TYPE,

1640: --
1641: procedure hire_employee_applicant
1642: (p_validate in boolean default false,
1643: p_hire_date in date,
1644: p_person_id in per_all_people_f.person_id%TYPE,
1645: p_primary_assignment_id in number default null,
1646: p_person_type_id in number default null,
1647: p_overwrite_primary in varchar2 default 'N',
1648: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,

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

1644: p_person_id in per_all_people_f.person_id%TYPE,
1645: p_primary_assignment_id in number default null,
1646: p_person_type_id in number default null,
1647: p_overwrite_primary in varchar2 default 'N',
1648: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1649: p_per_effective_start_date out nocopy date,
1650: p_per_effective_end_date out nocopy date,
1651: p_unaccepted_asg_del_warning out nocopy boolean,
1652: p_assign_payroll_warning out nocopy boolean

Line 1691: p_person_id in per_all_people_f.person_id%TYPE,

1687: --
1688: procedure hire_employee_applicant
1689: (p_validate in boolean default false,
1690: p_hire_date in date,
1691: p_person_id in per_all_people_f.person_id%TYPE,
1692: p_primary_assignment_id in number default null,
1693: p_person_type_id in number default null,
1694: p_overwrite_primary in varchar2 default 'N',
1695: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,

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

1691: p_person_id in per_all_people_f.person_id%TYPE,
1692: p_primary_assignment_id in number default null,
1693: p_person_type_id in number default null,
1694: p_overwrite_primary in varchar2 default 'N',
1695: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
1696: p_per_effective_start_date out nocopy date,
1697: p_per_effective_end_date out nocopy date,
1698: p_unaccepted_asg_del_warning out nocopy boolean,
1699: p_assign_payroll_warning out nocopy boolean,

Line 1712: l_chk_person_id per_all_people_f.person_id%TYPE;

1708: --
1709: l_exists varchar2(1);
1710: l_count number;
1711: l_chk_system_status per_assignment_status_types.per_system_status%TYPE;
1712: l_chk_person_id per_all_people_f.person_id%TYPE;
1713: --
1714: l_person_type_id number := p_person_type_id;
1715: l_person_type_id1 number;
1716: l_unaccepted_asg_del_warning boolean;

Line 1721: l_business_group_id per_all_people_f.business_group_id%TYPE;

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;
1725: --

Line 1732: l_per_object_version_number per_all_people_f.object_version_number%TYPE;

1728: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
1729: l_assignment_id per_assignments_f.assignment_id%TYPE;
1730: l_asg_object_version_number per_assignments_f.object_version_number%TYPE;
1731: --
1732: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
1733: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
1734: l_employee_number per_all_people_f.employee_number%TYPE;
1735: l_applicant_number per_all_people_f.applicant_number%TYPE;
1736: l_npw_number per_all_people_f.npw_number%TYPE;

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

1729: l_assignment_id per_assignments_f.assignment_id%TYPE;
1730: l_asg_object_version_number per_assignments_f.object_version_number%TYPE;
1731: --
1732: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
1733: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
1734: l_employee_number per_all_people_f.employee_number%TYPE;
1735: l_applicant_number per_all_people_f.applicant_number%TYPE;
1736: l_npw_number per_all_people_f.npw_number%TYPE;
1737: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;

Line 1734: l_employee_number per_all_people_f.employee_number%TYPE;

1730: l_asg_object_version_number per_assignments_f.object_version_number%TYPE;
1731: --
1732: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
1733: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
1734: l_employee_number per_all_people_f.employee_number%TYPE;
1735: l_applicant_number per_all_people_f.applicant_number%TYPE;
1736: l_npw_number per_all_people_f.npw_number%TYPE;
1737: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
1738: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;

Line 1735: l_applicant_number per_all_people_f.applicant_number%TYPE;

1731: --
1732: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
1733: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
1734: l_employee_number per_all_people_f.employee_number%TYPE;
1735: l_applicant_number per_all_people_f.applicant_number%TYPE;
1736: l_npw_number per_all_people_f.npw_number%TYPE;
1737: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
1738: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
1739: l_comment_id per_assignments_f.comment_id%TYPE;

Line 1736: l_npw_number per_all_people_f.npw_number%TYPE;

1732: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
1733: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
1734: l_employee_number per_all_people_f.employee_number%TYPE;
1735: l_applicant_number per_all_people_f.applicant_number%TYPE;
1736: l_npw_number per_all_people_f.npw_number%TYPE;
1737: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
1738: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
1739: l_comment_id per_assignments_f.comment_id%TYPE;
1740: l_current_applicant_flag varchar2(1);

Line 1737: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;

1733: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
1734: l_employee_number per_all_people_f.employee_number%TYPE;
1735: l_applicant_number per_all_people_f.applicant_number%TYPE;
1736: l_npw_number per_all_people_f.npw_number%TYPE;
1737: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
1738: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
1739: l_comment_id per_assignments_f.comment_id%TYPE;
1740: l_current_applicant_flag varchar2(1);
1741: l_current_emp_or_apl_flag varchar2(1);

Line 1738: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;

1734: l_employee_number per_all_people_f.employee_number%TYPE;
1735: l_applicant_number per_all_people_f.applicant_number%TYPE;
1736: l_npw_number per_all_people_f.npw_number%TYPE;
1737: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
1738: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
1739: l_comment_id per_assignments_f.comment_id%TYPE;
1740: l_current_applicant_flag varchar2(1);
1741: l_current_emp_or_apl_flag varchar2(1);
1742: l_current_employee_flag varchar2(1);

Line 1743: l_full_name per_all_people_f.full_name%TYPE;

1739: l_comment_id per_assignments_f.comment_id%TYPE;
1740: l_current_applicant_flag varchar2(1);
1741: l_current_emp_or_apl_flag varchar2(1);
1742: l_current_employee_flag varchar2(1);
1743: l_full_name per_all_people_f.full_name%TYPE;
1744: l_name_combination_warning boolean;
1745: l_assign_payroll_warning boolean;
1746: l_orig_hire_warning boolean;
1747: l_oversubscribed_vacancy_id number;

Line 1806: from per_all_people_f per,

1802: per.employee_number,
1803: per.npw_number,
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

Line 1832: from per_all_people_f per,

1828: --
1829: cursor csr_chk_assignment_id is
1830: select per.person_id,
1831: pas.per_system_status
1832: from per_all_people_f per,
1833: per_assignments_f asg,
1834: per_assignment_status_types pas
1835: where asg.assignment_status_type_id = pas.assignment_status_type_id
1836: and per.person_id = asg.person_id

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

2289: end if;
2290: -- End changes for bug 9879782
2291:
2292: --
2293: -- Lock the person record in PER_ALL_PEOPLE_F ready for UPDATE at a later point.
2294: -- (Note: This is necessary because calling the table handlers in locking
2295: -- ladder order invokes an error in per_apl_upd.upd due to the person
2296: -- being modified by the per_per_upd.upd table handler.)
2297: if l_per_effective_start_date=l_hire_date then

Line 2389: -- the per_all_people_f table.

2385: hr_utility.set_location(l_proc, 225);
2386:
2387: --
2388: -- Update the person details by calling upd procedure in
2389: -- the per_all_people_f table.
2390: --
2391: l_applicant_number:=hr_api.g_varchar2;
2392: l_employee_number:=hr_api.g_varchar2;
2393: per_per_upd.upd

Line 3790: from per_all_people_f

3786: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id
3787: (l_business_group_id,'EMP_APL');
3788:
3789: select object_version_number into l_per_object_version_number
3790: from per_all_people_f
3791: where person_id = p_person_id
3792: and apl.date_received between effective_start_date and effective_end_date;
3793:
3794: -- creating EMP_APL records in PER table

Line 3838: from per_all_people_f

3834: ,p_person_type_id => l_person_type_id1
3835: );
3836:
3837: select object_version_number into l_per_object_version_number
3838: from per_all_people_f
3839: where person_id= p_person_id
3840: and apl.date_end between effective_start_date and effective_end_date;
3841:
3842: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id

Line 4156: p_person_id in per_all_people_f.person_id%TYPE,

4152: procedure hire_employee_applicant
4153: (p_validate in boolean default false,
4154: p_hire_date in date,
4155: p_asg_rec in out nocopy per_all_assignments_f%rowtype,
4156: p_person_id in per_all_people_f.person_id%TYPE,
4157: p_primary_assignment_id in number default null,
4158: p_person_type_id in number default null,
4159: p_overwrite_primary in varchar2 default 'N',
4160: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,

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

4156: p_person_id in per_all_people_f.person_id%TYPE,
4157: p_primary_assignment_id in number default null,
4158: p_person_type_id in number default null,
4159: p_overwrite_primary in varchar2 default 'N',
4160: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
4161: p_per_effective_start_date out nocopy date,
4162: p_per_effective_end_date out nocopy date,
4163: p_unaccepted_asg_del_warning out nocopy boolean,
4164: p_assign_payroll_warning out nocopy boolean

Line 4177: l_chk_person_id per_all_people_f.person_id%TYPE;

4173: --
4174: l_exists varchar2(1);
4175: l_count number;
4176: l_chk_system_status per_assignment_status_types.per_system_status%TYPE;
4177: l_chk_person_id per_all_people_f.person_id%TYPE;
4178: --
4179: l_person_type_id number := p_person_type_id;
4180: l_person_type_id1 number;
4181: l_unaccepted_asg_del_warning boolean;

Line 4186: l_business_group_id per_all_people_f.business_group_id%TYPE;

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;
4190: --

Line 4197: l_per_object_version_number per_all_people_f.object_version_number%TYPE;

4193: l_per_system_status per_assignment_status_types.per_system_status%TYPE;
4194: l_assignment_id per_assignments_f.assignment_id%TYPE;
4195: l_asg_object_version_number per_assignments_f.object_version_number%TYPE;
4196: --
4197: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
4198: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
4199: l_employee_number per_all_people_f.employee_number%TYPE;
4200: l_applicant_number per_all_people_f.applicant_number%TYPE;
4201: l_npw_number per_all_people_f.npw_number%TYPE;

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

4194: l_assignment_id per_assignments_f.assignment_id%TYPE;
4195: l_asg_object_version_number per_assignments_f.object_version_number%TYPE;
4196: --
4197: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
4198: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
4199: l_employee_number per_all_people_f.employee_number%TYPE;
4200: l_applicant_number per_all_people_f.applicant_number%TYPE;
4201: l_npw_number per_all_people_f.npw_number%TYPE;
4202: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;

Line 4199: l_employee_number per_all_people_f.employee_number%TYPE;

4195: l_asg_object_version_number per_assignments_f.object_version_number%TYPE;
4196: --
4197: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
4198: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
4199: l_employee_number per_all_people_f.employee_number%TYPE;
4200: l_applicant_number per_all_people_f.applicant_number%TYPE;
4201: l_npw_number per_all_people_f.npw_number%TYPE;
4202: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
4203: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;

Line 4200: l_applicant_number per_all_people_f.applicant_number%TYPE;

4196: --
4197: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
4198: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
4199: l_employee_number per_all_people_f.employee_number%TYPE;
4200: l_applicant_number per_all_people_f.applicant_number%TYPE;
4201: l_npw_number per_all_people_f.npw_number%TYPE;
4202: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
4203: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
4204: l_comment_id per_assignments_f.comment_id%TYPE;

Line 4201: l_npw_number per_all_people_f.npw_number%TYPE;

4197: l_per_object_version_number per_all_people_f.object_version_number%TYPE;
4198: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
4199: l_employee_number per_all_people_f.employee_number%TYPE;
4200: l_applicant_number per_all_people_f.applicant_number%TYPE;
4201: l_npw_number per_all_people_f.npw_number%TYPE;
4202: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
4203: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
4204: l_comment_id per_assignments_f.comment_id%TYPE;
4205: l_current_applicant_flag varchar2(1);

Line 4202: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;

4198: l_ovn per_all_people_f.object_version_number%TYPE := p_per_object_version_number;
4199: l_employee_number per_all_people_f.employee_number%TYPE;
4200: l_applicant_number per_all_people_f.applicant_number%TYPE;
4201: l_npw_number per_all_people_f.npw_number%TYPE;
4202: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
4203: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
4204: l_comment_id per_assignments_f.comment_id%TYPE;
4205: l_current_applicant_flag varchar2(1);
4206: l_current_emp_or_apl_flag varchar2(1);

Line 4203: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;

4199: l_employee_number per_all_people_f.employee_number%TYPE;
4200: l_applicant_number per_all_people_f.applicant_number%TYPE;
4201: l_npw_number per_all_people_f.npw_number%TYPE;
4202: l_per_effective_start_date per_all_people_f.effective_start_date%TYPE;
4203: l_per_effective_end_date per_all_people_f.effective_end_date%TYPE;
4204: l_comment_id per_assignments_f.comment_id%TYPE;
4205: l_current_applicant_flag varchar2(1);
4206: l_current_emp_or_apl_flag varchar2(1);
4207: l_current_employee_flag varchar2(1);

Line 4208: l_full_name per_all_people_f.full_name%TYPE;

4204: l_comment_id per_assignments_f.comment_id%TYPE;
4205: l_current_applicant_flag varchar2(1);
4206: l_current_emp_or_apl_flag varchar2(1);
4207: l_current_employee_flag varchar2(1);
4208: l_full_name per_all_people_f.full_name%TYPE;
4209: l_name_combination_warning boolean;
4210: l_assign_payroll_warning boolean;
4211: l_orig_hire_warning boolean;
4212: l_oversubscribed_vacancy_id number;

Line 4279: from per_all_people_f per,

4275: per.employee_number,
4276: per.npw_number,
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

Line 4305: from per_all_people_f per,

4301: --
4302: cursor csr_chk_assignment_id is
4303: select per.person_id,
4304: pas.per_system_status
4305: from per_all_people_f per,
4306: per_assignments_f asg,
4307: per_assignment_status_types pas
4308: where asg.assignment_status_type_id = pas.assignment_status_type_id
4309: and per.person_id = asg.person_id

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

4819: ------ SSHR Enhancement (Bug # 8536819)-------
4820:
4821:
4822:
4823: -- Lock the person record in PER_ALL_PEOPLE_F ready for UPDATE at a later point.
4824: -- (Note: This is necessary because calling the table handlers in locking
4825: -- ladder order invokes an error in per_apl_upd.upd due to the person
4826: -- being modified by the per_per_upd.upd table handler.)
4827: if l_per_effective_start_date=l_hire_date then

Line 4961: -- the per_all_people_f table.

4957: hr_utility.set_location(l_proc, 225);
4958:
4959: --
4960: -- Update the person details by calling upd procedure in
4961: -- the per_all_people_f table.
4962: --
4963: l_applicant_number:=hr_api.g_varchar2;
4964: l_employee_number:=hr_api.g_varchar2;
4965:

Line 6635: from per_all_people_f

6631: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id
6632: (l_business_group_id,'EMP_APL');
6633:
6634: select object_version_number into l_per_object_version_number
6635: from per_all_people_f
6636: where person_id = p_person_id
6637: and apl.date_received between effective_start_date and effective_end_date;
6638:
6639: -- creating EMP_APL records in PER table

Line 6683: from per_all_people_f

6679: ,p_person_type_id => l_person_type_id1
6680: );
6681:
6682: select object_version_number into l_per_object_version_number
6683: from per_all_people_f
6684: where person_id= p_person_id
6685: and apl.date_end between effective_start_date and effective_end_date;
6686:
6687: l_person_type_id1 := hr_person_type_usage_info.get_default_person_type_id