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.PER_QH_ACTION dependencies on PER_ALL_PEOPLE_F

Line 10: p_person_id in per_all_people_f.person_id%TYPE,

6: g_package varchar2(33) := ' per_qh_action.';
7: procedure quick_hire_applicant
8: (p_validate in boolean default false,
9: p_hire_date in date,
10: p_person_id in per_all_people_f.person_id%TYPE,
11: p_assignment_id in number default null,
12: p_primary_assignment_id in number default null,
13: p_overwrite_primary in varchar2 default 'N',
14: p_person_type_id in number default null,

Line 15: p_national_identifier in per_all_people_f.national_identifier%type default hr_api.g_varchar2,

11: p_assignment_id in number default null,
12: p_primary_assignment_id in number default null,
13: p_overwrite_primary in varchar2 default 'N',
14: p_person_type_id in number default null,
15: p_national_identifier in per_all_people_f.national_identifier%type default hr_api.g_varchar2,
16: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
17: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
18: p_per_effective_start_date out nocopy date,
19: p_per_effective_end_date out nocopy date,

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

12: p_primary_assignment_id in number default null,
13: p_overwrite_primary in varchar2 default 'N',
14: p_person_type_id in number default null,
15: p_national_identifier in per_all_people_f.national_identifier%type default hr_api.g_varchar2,
16: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
17: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
18: p_per_effective_start_date out nocopy date,
19: p_per_effective_end_date out nocopy date,
20: p_unaccepted_asg_del_warning out nocopy boolean,

Line 17: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,

13: p_overwrite_primary in varchar2 default 'N',
14: p_person_type_id in number default null,
15: p_national_identifier in per_all_people_f.national_identifier%type default hr_api.g_varchar2,
16: p_per_object_version_number in out nocopy per_all_people_f.object_version_number%TYPE,
17: p_employee_number in out nocopy per_all_people_f.employee_number%TYPE,
18: p_per_effective_start_date out nocopy date,
19: p_per_effective_end_date out nocopy date,
20: p_unaccepted_asg_del_warning out nocopy boolean,
21: p_assign_payroll_warning out nocopy boolean,

Line 32: l_business_group_id per_all_people_f.business_group_id%TYPE;

28: l_proc varchar2(72) := g_package||'quick_hire_applicant';
29: l_dummy number;
30: l_system_person_type per_person_types.system_person_type%TYPE;
31: l_system_person_type2 per_person_types.system_person_type%TYPE;
32: l_business_group_id per_all_people_f.business_group_id%TYPE;
33: l_legislation_code per_business_groups.legislation_code%TYPE;
34: l_application_id per_applications.application_id%TYPE;
35: l_apl_object_version_number per_applications.application_id%TYPE;
36: l_per_effective_start_date per_all_people_f.effective_start_date%type;

Line 36: l_per_effective_start_date per_all_people_f.effective_start_date%type;

32: l_business_group_id per_all_people_f.business_group_id%TYPE;
33: l_legislation_code per_business_groups.legislation_code%TYPE;
34: l_application_id per_applications.application_id%TYPE;
35: l_apl_object_version_number per_applications.application_id%TYPE;
36: l_per_effective_start_date per_all_people_f.effective_start_date%type;
37: l_per_effective_start_date2 per_all_people_f.effective_start_date%type;
38: l_per_effective_end_date per_all_people_f.effective_end_date%type;
39: l_asg_effective_start_date per_all_assignments_f.effective_start_date%type;
40: l_asg_effective_end_date per_all_assignments_f.effective_end_date%type;

Line 37: l_per_effective_start_date2 per_all_people_f.effective_start_date%type;

33: l_legislation_code per_business_groups.legislation_code%TYPE;
34: l_application_id per_applications.application_id%TYPE;
35: l_apl_object_version_number per_applications.application_id%TYPE;
36: l_per_effective_start_date per_all_people_f.effective_start_date%type;
37: l_per_effective_start_date2 per_all_people_f.effective_start_date%type;
38: l_per_effective_end_date per_all_people_f.effective_end_date%type;
39: l_asg_effective_start_date per_all_assignments_f.effective_start_date%type;
40: l_asg_effective_end_date per_all_assignments_f.effective_end_date%type;
41: l_comment_id per_all_people_f.comment_id%type;

Line 38: l_per_effective_end_date per_all_people_f.effective_end_date%type;

34: l_application_id per_applications.application_id%TYPE;
35: l_apl_object_version_number per_applications.application_id%TYPE;
36: l_per_effective_start_date per_all_people_f.effective_start_date%type;
37: l_per_effective_start_date2 per_all_people_f.effective_start_date%type;
38: l_per_effective_end_date per_all_people_f.effective_end_date%type;
39: l_asg_effective_start_date per_all_assignments_f.effective_start_date%type;
40: l_asg_effective_end_date per_all_assignments_f.effective_end_date%type;
41: l_comment_id per_all_people_f.comment_id%type;
42: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;

Line 41: l_comment_id per_all_people_f.comment_id%type;

37: l_per_effective_start_date2 per_all_people_f.effective_start_date%type;
38: l_per_effective_end_date per_all_people_f.effective_end_date%type;
39: l_asg_effective_start_date per_all_assignments_f.effective_start_date%type;
40: l_asg_effective_end_date per_all_assignments_f.effective_end_date%type;
41: l_comment_id per_all_people_f.comment_id%type;
42: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;
43: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%type;
44: l_current_employee_flag per_all_people_f.current_employee_flag%type;
45: l_full_name per_all_people_f.full_name%type;

Line 42: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;

38: l_per_effective_end_date per_all_people_f.effective_end_date%type;
39: l_asg_effective_start_date per_all_assignments_f.effective_start_date%type;
40: l_asg_effective_end_date per_all_assignments_f.effective_end_date%type;
41: l_comment_id per_all_people_f.comment_id%type;
42: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;
43: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%type;
44: l_current_employee_flag per_all_people_f.current_employee_flag%type;
45: l_full_name per_all_people_f.full_name%type;
46: l_per_object_version_number per_all_people_f.object_version_number%type;

Line 43: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%type;

39: l_asg_effective_start_date per_all_assignments_f.effective_start_date%type;
40: l_asg_effective_end_date per_all_assignments_f.effective_end_date%type;
41: l_comment_id per_all_people_f.comment_id%type;
42: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;
43: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%type;
44: l_current_employee_flag per_all_people_f.current_employee_flag%type;
45: l_full_name per_all_people_f.full_name%type;
46: l_per_object_version_number per_all_people_f.object_version_number%type;
47: l_per_object_version_number2 per_all_people_f.object_version_number%type;

Line 44: l_current_employee_flag per_all_people_f.current_employee_flag%type;

40: l_asg_effective_end_date per_all_assignments_f.effective_end_date%type;
41: l_comment_id per_all_people_f.comment_id%type;
42: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;
43: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%type;
44: l_current_employee_flag per_all_people_f.current_employee_flag%type;
45: l_full_name per_all_people_f.full_name%type;
46: l_per_object_version_number per_all_people_f.object_version_number%type;
47: l_per_object_version_number2 per_all_people_f.object_version_number%type;
48: l_asg_object_version_number per_all_assignments_f.object_version_number%type;

Line 45: l_full_name per_all_people_f.full_name%type;

41: l_comment_id per_all_people_f.comment_id%type;
42: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;
43: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%type;
44: l_current_employee_flag per_all_people_f.current_employee_flag%type;
45: l_full_name per_all_people_f.full_name%type;
46: l_per_object_version_number per_all_people_f.object_version_number%type;
47: l_per_object_version_number2 per_all_people_f.object_version_number%type;
48: l_asg_object_version_number per_all_assignments_f.object_version_number%type;
49: l_per_system_status per_assignment_status_types.per_system_status%type;

Line 46: l_per_object_version_number per_all_people_f.object_version_number%type;

42: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;
43: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%type;
44: l_current_employee_flag per_all_people_f.current_employee_flag%type;
45: l_full_name per_all_people_f.full_name%type;
46: l_per_object_version_number per_all_people_f.object_version_number%type;
47: l_per_object_version_number2 per_all_people_f.object_version_number%type;
48: l_asg_object_version_number per_all_assignments_f.object_version_number%type;
49: l_per_system_status per_assignment_status_types.per_system_status%type;
50: l_employee_number per_all_people_f.employee_number%type;

Line 47: l_per_object_version_number2 per_all_people_f.object_version_number%type;

43: l_current_emp_or_apl_flag per_all_people_f.current_emp_or_apl_flag%type;
44: l_current_employee_flag per_all_people_f.current_employee_flag%type;
45: l_full_name per_all_people_f.full_name%type;
46: l_per_object_version_number per_all_people_f.object_version_number%type;
47: l_per_object_version_number2 per_all_people_f.object_version_number%type;
48: l_asg_object_version_number per_all_assignments_f.object_version_number%type;
49: l_per_system_status per_assignment_status_types.per_system_status%type;
50: l_employee_number per_all_people_f.employee_number%type;
51: l_applicant_number per_all_people_f.applicant_number%type;

Line 50: l_employee_number per_all_people_f.employee_number%type;

46: l_per_object_version_number per_all_people_f.object_version_number%type;
47: l_per_object_version_number2 per_all_people_f.object_version_number%type;
48: l_asg_object_version_number per_all_assignments_f.object_version_number%type;
49: l_per_system_status per_assignment_status_types.per_system_status%type;
50: l_employee_number per_all_people_f.employee_number%type;
51: l_applicant_number per_all_people_f.applicant_number%type;
52: l_datetrack_update_mode varchar2(30);
53: l_dummyb boolean;
54: --

Line 51: l_applicant_number per_all_people_f.applicant_number%type;

47: l_per_object_version_number2 per_all_people_f.object_version_number%type;
48: l_asg_object_version_number per_all_assignments_f.object_version_number%type;
49: l_per_system_status per_assignment_status_types.per_system_status%type;
50: l_employee_number per_all_people_f.employee_number%type;
51: l_applicant_number per_all_people_f.applicant_number%type;
52: l_datetrack_update_mode varchar2(30);
53: l_dummyb boolean;
54: --
55: l_hire_date date;

Line 69: from per_all_people_f per,

65: cursor csr_get_per_details(p_date date) is
66: select ppt.system_person_type,
67: per.effective_start_date,
68: per.object_version_number
69: from per_all_people_f per,
70: per_person_types ppt
71: where per.person_type_id = ppt.person_type_id
72: and per.person_id = p_person_id
73: and p_date between per.effective_start_date

Line 190: update per_all_people_f

186: hr_utility.set_location(l_proc,70);
187: --
188: -- there is no record on the previous day, so move everything back 1 day
189: --
190: update per_all_people_f
191: set
192: effective_start_date=l_hire_date-1
193: ,start_date=l_hire_date-1
194: ,original_date_of_hire=decode(original_date_of_hire

Line 548: update per_all_people_f

544: hr_utility.set_location(l_proc,270);
545: --
546: -- they weren't an emp-apl yesterday, but there is room to move that backwards
547: --
548: update per_all_people_f
549: set effective_start_date=l_hire_date-1
550: where person_id=p_person_id
551: and effective_start_date=l_hire_date;
552: --

Line 555: update per_all_people_f

551: and effective_start_date=l_hire_date;
552: --
553: l_per_object_version_number:=l_per_object_version_number+1;
554: --
555: update per_all_people_f
556: set effective_end_date=l_hire_date-2
557: where person_id=p_person_id
558: and effective_end_date=l_hire_date-1;
559: --

Line 752: ,p_person_id per_all_people_f.person_id%type

748: function set_notification
749: (p_notification wf_messages.name%type
750: ,p_wf_name wf_item_types.name%type
751: ,p_role varchar2 --wf_roles.name%type Fix for bug 2741492
752: ,p_person_id per_all_people_f.person_id%type
753: ,p_assignment_id per_all_assignments_f.assignment_id%type
754: ,p_effective_date date
755: ,p_hire_date per_periods_of_service.date_start%type
756: ,p_full_name per_all_people_f.full_name%type

Line 756: ,p_full_name per_all_people_f.full_name%type

752: ,p_person_id per_all_people_f.person_id%type
753: ,p_assignment_id per_all_assignments_f.assignment_id%type
754: ,p_effective_date date
755: ,p_hire_date per_periods_of_service.date_start%type
756: ,p_full_name per_all_people_f.full_name%type
757: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
758: ,p_title per_alL_people_f.title%type
759: ,p_first_name per_all_people_f.first_name%type
760: ,p_last_name per_all_people_f.last_name%type

Line 757: ,p_per_effective_start_date per_all_people_f.effective_start_date%type

753: ,p_assignment_id per_all_assignments_f.assignment_id%type
754: ,p_effective_date date
755: ,p_hire_date per_periods_of_service.date_start%type
756: ,p_full_name per_all_people_f.full_name%type
757: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
758: ,p_title per_alL_people_f.title%type
759: ,p_first_name per_all_people_f.first_name%type
760: ,p_last_name per_all_people_f.last_name%type
761: ,p_employee_number per_all_people_f.employee_number%type

Line 758: ,p_title per_alL_people_f.title%type

754: ,p_effective_date date
755: ,p_hire_date per_periods_of_service.date_start%type
756: ,p_full_name per_all_people_f.full_name%type
757: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
758: ,p_title per_alL_people_f.title%type
759: ,p_first_name per_all_people_f.first_name%type
760: ,p_last_name per_all_people_f.last_name%type
761: ,p_employee_number per_all_people_f.employee_number%type
762: ,p_applicant_number per_all_people_f.applicant_number%type

Line 759: ,p_first_name per_all_people_f.first_name%type

755: ,p_hire_date per_periods_of_service.date_start%type
756: ,p_full_name per_all_people_f.full_name%type
757: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
758: ,p_title per_alL_people_f.title%type
759: ,p_first_name per_all_people_f.first_name%type
760: ,p_last_name per_all_people_f.last_name%type
761: ,p_employee_number per_all_people_f.employee_number%type
762: ,p_applicant_number per_all_people_f.applicant_number%type
763: ,p_national_identifier per_all_people_f.national_identifier%type

Line 760: ,p_last_name per_all_people_f.last_name%type

756: ,p_full_name per_all_people_f.full_name%type
757: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
758: ,p_title per_alL_people_f.title%type
759: ,p_first_name per_all_people_f.first_name%type
760: ,p_last_name per_all_people_f.last_name%type
761: ,p_employee_number per_all_people_f.employee_number%type
762: ,p_applicant_number per_all_people_f.applicant_number%type
763: ,p_national_identifier per_all_people_f.national_identifier%type
764: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%type

Line 761: ,p_employee_number per_all_people_f.employee_number%type

757: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
758: ,p_title per_alL_people_f.title%type
759: ,p_first_name per_all_people_f.first_name%type
760: ,p_last_name per_all_people_f.last_name%type
761: ,p_employee_number per_all_people_f.employee_number%type
762: ,p_applicant_number per_all_people_f.applicant_number%type
763: ,p_national_identifier per_all_people_f.national_identifier%type
764: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%type
765: ,p_organization hr_all_organization_units.name%type

Line 762: ,p_applicant_number per_all_people_f.applicant_number%type

758: ,p_title per_alL_people_f.title%type
759: ,p_first_name per_all_people_f.first_name%type
760: ,p_last_name per_all_people_f.last_name%type
761: ,p_employee_number per_all_people_f.employee_number%type
762: ,p_applicant_number per_all_people_f.applicant_number%type
763: ,p_national_identifier per_all_people_f.national_identifier%type
764: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%type
765: ,p_organization hr_all_organization_units.name%type
766: ,p_grade per_grades.name%type

Line 763: ,p_national_identifier per_all_people_f.national_identifier%type

759: ,p_first_name per_all_people_f.first_name%type
760: ,p_last_name per_all_people_f.last_name%type
761: ,p_employee_number per_all_people_f.employee_number%type
762: ,p_applicant_number per_all_people_f.applicant_number%type
763: ,p_national_identifier per_all_people_f.national_identifier%type
764: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%type
765: ,p_organization hr_all_organization_units.name%type
766: ,p_grade per_grades.name%type
767: ,p_job per_jobs.name%type

Line 771: ,p_supervisor per_all_people_f.full_name%type

767: ,p_job per_jobs.name%type
768: ,p_position hr_all_positions_f.name%type
769: ,p_payroll pay_all_payrolls_f.payroll_name%type
770: ,p_vacancy per_vacancies.name%type
771: ,p_supervisor per_all_people_f.full_name%type
772: ,p_location hr_locations.location_code%type
773: ,p_salary per_pay_proposals.proposed_salary_n%type
774: ,p_salary_currency pay_element_types_f.input_currency_code%type
775: ,p_pay_basis hr_lookups.meaning%type

Line 777: ,p_npw_number per_all_people_f.npw_number%type

773: ,p_salary per_pay_proposals.proposed_salary_n%type
774: ,p_salary_currency pay_element_types_f.input_currency_code%type
775: ,p_pay_basis hr_lookups.meaning%type
776: ,p_date_probation_end per_all_assignments_f.date_probation_end%type
777: ,p_npw_number per_all_people_f.npw_number%type
778: ,p_vendor po_vendors.vendor_name%type
779: ,p_supplier_reference per_all_assignments_f.vendor_employee_number%type
780: ,p_placement_date_start per_all_assignments_f.period_of_placement_date_start%type
781: ,p_grade_ladder ben_pgm_f.name%type

Line 942: ,p_person_id per_all_people_f.person_id%type

938: procedure send_notification
939: (p_notification wf_messages.name%type
940: ,p_wf_name wf_item_types.name%type
941: ,p_role varchar2 --wf_roles.name%type Fix for bug 2741492
942: ,p_person_id per_all_people_f.person_id%type
943: ,p_assignment_id per_all_assignments_f.assignment_id%type
944: ,p_effective_date date
945: ,p_hire_date per_periods_of_service.date_start%type
946: ,p_full_name per_all_people_f.full_name%type

Line 946: ,p_full_name per_all_people_f.full_name%type

942: ,p_person_id per_all_people_f.person_id%type
943: ,p_assignment_id per_all_assignments_f.assignment_id%type
944: ,p_effective_date date
945: ,p_hire_date per_periods_of_service.date_start%type
946: ,p_full_name per_all_people_f.full_name%type
947: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
948: ,p_title per_alL_people_f.title%type
949: ,p_first_name per_all_people_f.first_name%type
950: ,p_last_name per_all_people_f.last_name%type

Line 947: ,p_per_effective_start_date per_all_people_f.effective_start_date%type

943: ,p_assignment_id per_all_assignments_f.assignment_id%type
944: ,p_effective_date date
945: ,p_hire_date per_periods_of_service.date_start%type
946: ,p_full_name per_all_people_f.full_name%type
947: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
948: ,p_title per_alL_people_f.title%type
949: ,p_first_name per_all_people_f.first_name%type
950: ,p_last_name per_all_people_f.last_name%type
951: ,p_employee_number per_all_people_f.employee_number%type

Line 948: ,p_title per_alL_people_f.title%type

944: ,p_effective_date date
945: ,p_hire_date per_periods_of_service.date_start%type
946: ,p_full_name per_all_people_f.full_name%type
947: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
948: ,p_title per_alL_people_f.title%type
949: ,p_first_name per_all_people_f.first_name%type
950: ,p_last_name per_all_people_f.last_name%type
951: ,p_employee_number per_all_people_f.employee_number%type
952: ,p_applicant_number per_all_people_f.applicant_number%type

Line 949: ,p_first_name per_all_people_f.first_name%type

945: ,p_hire_date per_periods_of_service.date_start%type
946: ,p_full_name per_all_people_f.full_name%type
947: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
948: ,p_title per_alL_people_f.title%type
949: ,p_first_name per_all_people_f.first_name%type
950: ,p_last_name per_all_people_f.last_name%type
951: ,p_employee_number per_all_people_f.employee_number%type
952: ,p_applicant_number per_all_people_f.applicant_number%type
953: ,p_national_identifier per_all_people_f.national_identifier%type

Line 950: ,p_last_name per_all_people_f.last_name%type

946: ,p_full_name per_all_people_f.full_name%type
947: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
948: ,p_title per_alL_people_f.title%type
949: ,p_first_name per_all_people_f.first_name%type
950: ,p_last_name per_all_people_f.last_name%type
951: ,p_employee_number per_all_people_f.employee_number%type
952: ,p_applicant_number per_all_people_f.applicant_number%type
953: ,p_national_identifier per_all_people_f.national_identifier%type
954: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%type

Line 951: ,p_employee_number per_all_people_f.employee_number%type

947: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
948: ,p_title per_alL_people_f.title%type
949: ,p_first_name per_all_people_f.first_name%type
950: ,p_last_name per_all_people_f.last_name%type
951: ,p_employee_number per_all_people_f.employee_number%type
952: ,p_applicant_number per_all_people_f.applicant_number%type
953: ,p_national_identifier per_all_people_f.national_identifier%type
954: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%type
955: ,p_organization hr_all_organization_units.name%type

Line 952: ,p_applicant_number per_all_people_f.applicant_number%type

948: ,p_title per_alL_people_f.title%type
949: ,p_first_name per_all_people_f.first_name%type
950: ,p_last_name per_all_people_f.last_name%type
951: ,p_employee_number per_all_people_f.employee_number%type
952: ,p_applicant_number per_all_people_f.applicant_number%type
953: ,p_national_identifier per_all_people_f.national_identifier%type
954: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%type
955: ,p_organization hr_all_organization_units.name%type
956: ,p_grade per_grades.name%type

Line 953: ,p_national_identifier per_all_people_f.national_identifier%type

949: ,p_first_name per_all_people_f.first_name%type
950: ,p_last_name per_all_people_f.last_name%type
951: ,p_employee_number per_all_people_f.employee_number%type
952: ,p_applicant_number per_all_people_f.applicant_number%type
953: ,p_national_identifier per_all_people_f.national_identifier%type
954: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%type
955: ,p_organization hr_all_organization_units.name%type
956: ,p_grade per_grades.name%type
957: ,p_job per_jobs.name%type

Line 961: ,p_supervisor per_all_people_f.full_name%type

957: ,p_job per_jobs.name%type
958: ,p_position hr_all_positions_f.name%type
959: ,p_payroll pay_all_payrolls_f.payroll_name%type
960: ,p_vacancy per_vacancies.name%type
961: ,p_supervisor per_all_people_f.full_name%type
962: ,p_location hr_locations.location_code%type
963: ,p_salary per_pay_proposals.proposed_salary_n%type
964: ,p_salary_currency pay_element_types_f.input_currency_code%type
965: ,p_pay_basis hr_lookups.meaning%type

Line 967: ,p_npw_number per_all_people_f.npw_number%type

963: ,p_salary per_pay_proposals.proposed_salary_n%type
964: ,p_salary_currency pay_element_types_f.input_currency_code%type
965: ,p_pay_basis hr_lookups.meaning%type
966: ,p_date_probation_end per_all_assignments_f.date_probation_end%type
967: ,p_npw_number per_all_people_f.npw_number%type
968: ,p_vendor po_vendors.vendor_name%type
969: ,p_supplier_reference per_all_assignments_f.vendor_employee_number%type
970: ,p_placement_date_start per_all_assignments_f.period_of_placement_date_start%type
971: ,p_grade_ladder ben_pgm_f.name%type

Line 1029: ,p_person_id in per_all_people_f.person_id%type

1025: procedure get_notification_preview
1026: (p_notification in wf_messages.name%type
1027: ,p_wf_name in wf_item_types.name%type
1028: ,p_role in varchar2 --wf_roles.name%type Fix for bug 2741492
1029: ,p_person_id in per_all_people_f.person_id%type
1030: ,p_assignment_id in per_all_assignments_f.assignment_id%type
1031: ,p_effective_date in date
1032: ,p_hire_date in per_periods_of_service.date_start%type
1033: ,p_full_name in per_all_people_f.full_name%type

Line 1033: ,p_full_name in per_all_people_f.full_name%type

1029: ,p_person_id in per_all_people_f.person_id%type
1030: ,p_assignment_id in per_all_assignments_f.assignment_id%type
1031: ,p_effective_date in date
1032: ,p_hire_date in per_periods_of_service.date_start%type
1033: ,p_full_name in per_all_people_f.full_name%type
1034: ,p_per_effective_start_date in per_all_people_f.effective_start_date%type
1035: ,p_title in per_alL_people_f.title%type
1036: ,p_first_name in per_all_people_f.first_name%type
1037: ,p_last_name in per_all_people_f.last_name%type

Line 1034: ,p_per_effective_start_date in per_all_people_f.effective_start_date%type

1030: ,p_assignment_id in per_all_assignments_f.assignment_id%type
1031: ,p_effective_date in date
1032: ,p_hire_date in per_periods_of_service.date_start%type
1033: ,p_full_name in per_all_people_f.full_name%type
1034: ,p_per_effective_start_date in per_all_people_f.effective_start_date%type
1035: ,p_title in per_alL_people_f.title%type
1036: ,p_first_name in per_all_people_f.first_name%type
1037: ,p_last_name in per_all_people_f.last_name%type
1038: ,p_employee_number in per_all_people_f.employee_number%type

Line 1035: ,p_title in per_alL_people_f.title%type

1031: ,p_effective_date in date
1032: ,p_hire_date in per_periods_of_service.date_start%type
1033: ,p_full_name in per_all_people_f.full_name%type
1034: ,p_per_effective_start_date in per_all_people_f.effective_start_date%type
1035: ,p_title in per_alL_people_f.title%type
1036: ,p_first_name in per_all_people_f.first_name%type
1037: ,p_last_name in per_all_people_f.last_name%type
1038: ,p_employee_number in per_all_people_f.employee_number%type
1039: ,p_applicant_number in per_all_people_f.applicant_number%type

Line 1036: ,p_first_name in per_all_people_f.first_name%type

1032: ,p_hire_date in per_periods_of_service.date_start%type
1033: ,p_full_name in per_all_people_f.full_name%type
1034: ,p_per_effective_start_date in per_all_people_f.effective_start_date%type
1035: ,p_title in per_alL_people_f.title%type
1036: ,p_first_name in per_all_people_f.first_name%type
1037: ,p_last_name in per_all_people_f.last_name%type
1038: ,p_employee_number in per_all_people_f.employee_number%type
1039: ,p_applicant_number in per_all_people_f.applicant_number%type
1040: ,p_national_identifier in per_all_people_f.national_identifier%type

Line 1037: ,p_last_name in per_all_people_f.last_name%type

1033: ,p_full_name in per_all_people_f.full_name%type
1034: ,p_per_effective_start_date in per_all_people_f.effective_start_date%type
1035: ,p_title in per_alL_people_f.title%type
1036: ,p_first_name in per_all_people_f.first_name%type
1037: ,p_last_name in per_all_people_f.last_name%type
1038: ,p_employee_number in per_all_people_f.employee_number%type
1039: ,p_applicant_number in per_all_people_f.applicant_number%type
1040: ,p_national_identifier in per_all_people_f.national_identifier%type
1041: ,p_asg_effective_start_date in per_all_assignments_f.effective_start_date%type

Line 1038: ,p_employee_number in per_all_people_f.employee_number%type

1034: ,p_per_effective_start_date in per_all_people_f.effective_start_date%type
1035: ,p_title in per_alL_people_f.title%type
1036: ,p_first_name in per_all_people_f.first_name%type
1037: ,p_last_name in per_all_people_f.last_name%type
1038: ,p_employee_number in per_all_people_f.employee_number%type
1039: ,p_applicant_number in per_all_people_f.applicant_number%type
1040: ,p_national_identifier in per_all_people_f.national_identifier%type
1041: ,p_asg_effective_start_date in per_all_assignments_f.effective_start_date%type
1042: ,p_organization in hr_all_organization_units.name%type

Line 1039: ,p_applicant_number in per_all_people_f.applicant_number%type

1035: ,p_title in per_alL_people_f.title%type
1036: ,p_first_name in per_all_people_f.first_name%type
1037: ,p_last_name in per_all_people_f.last_name%type
1038: ,p_employee_number in per_all_people_f.employee_number%type
1039: ,p_applicant_number in per_all_people_f.applicant_number%type
1040: ,p_national_identifier in per_all_people_f.national_identifier%type
1041: ,p_asg_effective_start_date in per_all_assignments_f.effective_start_date%type
1042: ,p_organization in hr_all_organization_units.name%type
1043: ,p_grade in per_grades.name%type

Line 1040: ,p_national_identifier in per_all_people_f.national_identifier%type

1036: ,p_first_name in per_all_people_f.first_name%type
1037: ,p_last_name in per_all_people_f.last_name%type
1038: ,p_employee_number in per_all_people_f.employee_number%type
1039: ,p_applicant_number in per_all_people_f.applicant_number%type
1040: ,p_national_identifier in per_all_people_f.national_identifier%type
1041: ,p_asg_effective_start_date in per_all_assignments_f.effective_start_date%type
1042: ,p_organization in hr_all_organization_units.name%type
1043: ,p_grade in per_grades.name%type
1044: ,p_job in per_jobs.name%type

Line 1048: ,p_supervisor in per_all_people_f.full_name%type

1044: ,p_job in per_jobs.name%type
1045: ,p_position in hr_all_positions_f.name%type
1046: ,p_payroll in pay_all_payrolls_f.payroll_name%type
1047: ,p_vacancy in per_vacancies.name%type
1048: ,p_supervisor in per_all_people_f.full_name%type
1049: ,p_location in hr_locations.location_code%type
1050: ,p_salary in per_pay_proposals.proposed_salary_n%type
1051: ,p_salary_currency in pay_element_types_f.input_currency_code%type
1052: ,p_pay_basis in hr_lookups.meaning%type

Line 1054: ,p_npw_number in per_all_people_f.npw_number%type

1050: ,p_salary in per_pay_proposals.proposed_salary_n%type
1051: ,p_salary_currency in pay_element_types_f.input_currency_code%type
1052: ,p_pay_basis in hr_lookups.meaning%type
1053: ,p_date_probation_end in per_all_assignments_f.date_probation_end%type
1054: ,p_npw_number in per_all_people_f.npw_number%type
1055: ,p_vendor in po_vendors.vendor_name%type
1056: ,p_supplier_reference in per_all_assignments_f.vendor_employee_number%type
1057: ,p_placement_date_start in per_all_assignments_f.period_of_placement_date_start%type
1058: ,p_grade_ladder in ben_pgm_f.name%type