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 77: from per_all_people_f per,

73: cursor csr_get_per_details(p_date date) is
74: select ppt.system_person_type,
75: per.effective_start_date,
76: per.object_version_number
77: from per_all_people_f per,
78: per_person_types ppt
79: where per.person_type_id = ppt.person_type_id
80: and per.person_id = p_person_id
81: and p_date between per.effective_start_date

Line 215: update per_all_people_f

211: hr_utility.set_location(l_proc,70);
212: --
213: -- there is no record on the previous day, so move everything back 1 day
214: --
215: update per_all_people_f
216: set
217: effective_start_date=l_hire_date-1
218: ,start_date=l_hire_date-1
219: ,original_date_of_hire=decode(original_date_of_hire

Line 573: update per_all_people_f

569: hr_utility.set_location(l_proc,270);
570: --
571: -- they weren't an emp-apl yesterday, but there is room to move that backwards
572: --
573: update per_all_people_f
574: set effective_start_date=l_hire_date-1
575: where person_id=p_person_id
576: and effective_start_date=l_hire_date;
577: --

Line 580: update per_all_people_f

576: and effective_start_date=l_hire_date;
577: --
578: l_per_object_version_number:=l_per_object_version_number+1;
579: --
580: update per_all_people_f
581: set effective_end_date=l_hire_date-2
582: where person_id=p_person_id
583: and effective_end_date=l_hire_date-1;
584: --

Line 777: ,p_person_id per_all_people_f.person_id%type

773: function set_notification
774: (p_notification wf_messages.name%type
775: ,p_wf_name wf_item_types.name%type
776: ,p_role varchar2 --wf_roles.name%type Fix for bug 2741492
777: ,p_person_id per_all_people_f.person_id%type
778: ,p_assignment_id per_all_assignments_f.assignment_id%type
779: ,p_effective_date date
780: ,p_hire_date per_periods_of_service.date_start%type
781: ,p_full_name per_all_people_f.full_name%type

Line 781: ,p_full_name per_all_people_f.full_name%type

777: ,p_person_id per_all_people_f.person_id%type
778: ,p_assignment_id per_all_assignments_f.assignment_id%type
779: ,p_effective_date date
780: ,p_hire_date per_periods_of_service.date_start%type
781: ,p_full_name per_all_people_f.full_name%type
782: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
783: ,p_title per_alL_people_f.title%type
784: ,p_first_name per_all_people_f.first_name%type
785: ,p_last_name per_all_people_f.last_name%type

Line 782: ,p_per_effective_start_date per_all_people_f.effective_start_date%type

778: ,p_assignment_id per_all_assignments_f.assignment_id%type
779: ,p_effective_date date
780: ,p_hire_date per_periods_of_service.date_start%type
781: ,p_full_name per_all_people_f.full_name%type
782: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
783: ,p_title per_alL_people_f.title%type
784: ,p_first_name per_all_people_f.first_name%type
785: ,p_last_name per_all_people_f.last_name%type
786: ,p_employee_number per_all_people_f.employee_number%type

Line 783: ,p_title per_alL_people_f.title%type

779: ,p_effective_date date
780: ,p_hire_date per_periods_of_service.date_start%type
781: ,p_full_name per_all_people_f.full_name%type
782: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
783: ,p_title per_alL_people_f.title%type
784: ,p_first_name per_all_people_f.first_name%type
785: ,p_last_name per_all_people_f.last_name%type
786: ,p_employee_number per_all_people_f.employee_number%type
787: ,p_applicant_number per_all_people_f.applicant_number%type

Line 784: ,p_first_name per_all_people_f.first_name%type

780: ,p_hire_date per_periods_of_service.date_start%type
781: ,p_full_name per_all_people_f.full_name%type
782: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
783: ,p_title per_alL_people_f.title%type
784: ,p_first_name per_all_people_f.first_name%type
785: ,p_last_name per_all_people_f.last_name%type
786: ,p_employee_number per_all_people_f.employee_number%type
787: ,p_applicant_number per_all_people_f.applicant_number%type
788: ,p_national_identifier per_all_people_f.national_identifier%type

Line 785: ,p_last_name per_all_people_f.last_name%type

781: ,p_full_name per_all_people_f.full_name%type
782: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
783: ,p_title per_alL_people_f.title%type
784: ,p_first_name per_all_people_f.first_name%type
785: ,p_last_name per_all_people_f.last_name%type
786: ,p_employee_number per_all_people_f.employee_number%type
787: ,p_applicant_number per_all_people_f.applicant_number%type
788: ,p_national_identifier per_all_people_f.national_identifier%type
789: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%type

Line 786: ,p_employee_number per_all_people_f.employee_number%type

782: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
783: ,p_title per_alL_people_f.title%type
784: ,p_first_name per_all_people_f.first_name%type
785: ,p_last_name per_all_people_f.last_name%type
786: ,p_employee_number per_all_people_f.employee_number%type
787: ,p_applicant_number per_all_people_f.applicant_number%type
788: ,p_national_identifier per_all_people_f.national_identifier%type
789: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%type
790: ,p_organization hr_all_organization_units.name%type

Line 787: ,p_applicant_number per_all_people_f.applicant_number%type

783: ,p_title per_alL_people_f.title%type
784: ,p_first_name per_all_people_f.first_name%type
785: ,p_last_name per_all_people_f.last_name%type
786: ,p_employee_number per_all_people_f.employee_number%type
787: ,p_applicant_number per_all_people_f.applicant_number%type
788: ,p_national_identifier per_all_people_f.national_identifier%type
789: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%type
790: ,p_organization hr_all_organization_units.name%type
791: ,p_grade per_grades.name%type

Line 788: ,p_national_identifier per_all_people_f.national_identifier%type

784: ,p_first_name per_all_people_f.first_name%type
785: ,p_last_name per_all_people_f.last_name%type
786: ,p_employee_number per_all_people_f.employee_number%type
787: ,p_applicant_number per_all_people_f.applicant_number%type
788: ,p_national_identifier per_all_people_f.national_identifier%type
789: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%type
790: ,p_organization hr_all_organization_units.name%type
791: ,p_grade per_grades.name%type
792: ,p_job per_jobs.name%type

Line 796: ,p_supervisor per_all_people_f.full_name%type

792: ,p_job per_jobs.name%type
793: ,p_position hr_all_positions_f.name%type
794: ,p_payroll pay_all_payrolls_f.payroll_name%type
795: ,p_vacancy per_vacancies.name%type
796: ,p_supervisor per_all_people_f.full_name%type
797: ,p_location hr_locations.location_code%type
798: ,p_salary per_pay_proposals.proposed_salary_n%type
799: ,p_salary_currency pay_element_types_f.input_currency_code%type
800: ,p_pay_basis hr_lookups.meaning%type

Line 802: ,p_npw_number per_all_people_f.npw_number%type

798: ,p_salary per_pay_proposals.proposed_salary_n%type
799: ,p_salary_currency pay_element_types_f.input_currency_code%type
800: ,p_pay_basis hr_lookups.meaning%type
801: ,p_date_probation_end per_all_assignments_f.date_probation_end%type
802: ,p_npw_number per_all_people_f.npw_number%type
803: ,p_vendor po_vendors.vendor_name%type
804: ,p_supplier_reference per_all_assignments_f.vendor_employee_number%type
805: ,p_placement_date_start per_all_assignments_f.period_of_placement_date_start%type
806: ,p_grade_ladder ben_pgm_f.name%type

Line 967: ,p_person_id per_all_people_f.person_id%type

963: procedure send_notification
964: (p_notification wf_messages.name%type
965: ,p_wf_name wf_item_types.name%type
966: ,p_role varchar2 --wf_roles.name%type Fix for bug 2741492
967: ,p_person_id per_all_people_f.person_id%type
968: ,p_assignment_id per_all_assignments_f.assignment_id%type
969: ,p_effective_date date
970: ,p_hire_date per_periods_of_service.date_start%type
971: ,p_full_name per_all_people_f.full_name%type

Line 971: ,p_full_name per_all_people_f.full_name%type

967: ,p_person_id per_all_people_f.person_id%type
968: ,p_assignment_id per_all_assignments_f.assignment_id%type
969: ,p_effective_date date
970: ,p_hire_date per_periods_of_service.date_start%type
971: ,p_full_name per_all_people_f.full_name%type
972: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
973: ,p_title per_alL_people_f.title%type
974: ,p_first_name per_all_people_f.first_name%type
975: ,p_last_name per_all_people_f.last_name%type

Line 972: ,p_per_effective_start_date per_all_people_f.effective_start_date%type

968: ,p_assignment_id per_all_assignments_f.assignment_id%type
969: ,p_effective_date date
970: ,p_hire_date per_periods_of_service.date_start%type
971: ,p_full_name per_all_people_f.full_name%type
972: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
973: ,p_title per_alL_people_f.title%type
974: ,p_first_name per_all_people_f.first_name%type
975: ,p_last_name per_all_people_f.last_name%type
976: ,p_employee_number per_all_people_f.employee_number%type

Line 973: ,p_title per_alL_people_f.title%type

969: ,p_effective_date date
970: ,p_hire_date per_periods_of_service.date_start%type
971: ,p_full_name per_all_people_f.full_name%type
972: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
973: ,p_title per_alL_people_f.title%type
974: ,p_first_name per_all_people_f.first_name%type
975: ,p_last_name per_all_people_f.last_name%type
976: ,p_employee_number per_all_people_f.employee_number%type
977: ,p_applicant_number per_all_people_f.applicant_number%type

Line 974: ,p_first_name per_all_people_f.first_name%type

970: ,p_hire_date per_periods_of_service.date_start%type
971: ,p_full_name per_all_people_f.full_name%type
972: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
973: ,p_title per_alL_people_f.title%type
974: ,p_first_name per_all_people_f.first_name%type
975: ,p_last_name per_all_people_f.last_name%type
976: ,p_employee_number per_all_people_f.employee_number%type
977: ,p_applicant_number per_all_people_f.applicant_number%type
978: ,p_national_identifier per_all_people_f.national_identifier%type

Line 975: ,p_last_name per_all_people_f.last_name%type

971: ,p_full_name per_all_people_f.full_name%type
972: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
973: ,p_title per_alL_people_f.title%type
974: ,p_first_name per_all_people_f.first_name%type
975: ,p_last_name per_all_people_f.last_name%type
976: ,p_employee_number per_all_people_f.employee_number%type
977: ,p_applicant_number per_all_people_f.applicant_number%type
978: ,p_national_identifier per_all_people_f.national_identifier%type
979: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%type

Line 976: ,p_employee_number per_all_people_f.employee_number%type

972: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
973: ,p_title per_alL_people_f.title%type
974: ,p_first_name per_all_people_f.first_name%type
975: ,p_last_name per_all_people_f.last_name%type
976: ,p_employee_number per_all_people_f.employee_number%type
977: ,p_applicant_number per_all_people_f.applicant_number%type
978: ,p_national_identifier per_all_people_f.national_identifier%type
979: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%type
980: ,p_organization hr_all_organization_units.name%type

Line 977: ,p_applicant_number per_all_people_f.applicant_number%type

973: ,p_title per_alL_people_f.title%type
974: ,p_first_name per_all_people_f.first_name%type
975: ,p_last_name per_all_people_f.last_name%type
976: ,p_employee_number per_all_people_f.employee_number%type
977: ,p_applicant_number per_all_people_f.applicant_number%type
978: ,p_national_identifier per_all_people_f.national_identifier%type
979: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%type
980: ,p_organization hr_all_organization_units.name%type
981: ,p_grade per_grades.name%type

Line 978: ,p_national_identifier per_all_people_f.national_identifier%type

974: ,p_first_name per_all_people_f.first_name%type
975: ,p_last_name per_all_people_f.last_name%type
976: ,p_employee_number per_all_people_f.employee_number%type
977: ,p_applicant_number per_all_people_f.applicant_number%type
978: ,p_national_identifier per_all_people_f.national_identifier%type
979: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%type
980: ,p_organization hr_all_organization_units.name%type
981: ,p_grade per_grades.name%type
982: ,p_job per_jobs.name%type

Line 986: ,p_supervisor per_all_people_f.full_name%type

982: ,p_job per_jobs.name%type
983: ,p_position hr_all_positions_f.name%type
984: ,p_payroll pay_all_payrolls_f.payroll_name%type
985: ,p_vacancy per_vacancies.name%type
986: ,p_supervisor per_all_people_f.full_name%type
987: ,p_location hr_locations.location_code%type
988: ,p_salary per_pay_proposals.proposed_salary_n%type
989: ,p_salary_currency pay_element_types_f.input_currency_code%type
990: ,p_pay_basis hr_lookups.meaning%type

Line 992: ,p_npw_number per_all_people_f.npw_number%type

988: ,p_salary per_pay_proposals.proposed_salary_n%type
989: ,p_salary_currency pay_element_types_f.input_currency_code%type
990: ,p_pay_basis hr_lookups.meaning%type
991: ,p_date_probation_end per_all_assignments_f.date_probation_end%type
992: ,p_npw_number per_all_people_f.npw_number%type
993: ,p_vendor po_vendors.vendor_name%type
994: ,p_supplier_reference per_all_assignments_f.vendor_employee_number%type
995: ,p_placement_date_start per_all_assignments_f.period_of_placement_date_start%type
996: ,p_grade_ladder ben_pgm_f.name%type

Line 1054: ,p_person_id in per_all_people_f.person_id%type

1050: procedure get_notification_preview
1051: (p_notification in wf_messages.name%type
1052: ,p_wf_name in wf_item_types.name%type
1053: ,p_role in varchar2 --wf_roles.name%type Fix for bug 2741492
1054: ,p_person_id in per_all_people_f.person_id%type
1055: ,p_assignment_id in per_all_assignments_f.assignment_id%type
1056: ,p_effective_date in date
1057: ,p_hire_date in per_periods_of_service.date_start%type
1058: ,p_full_name in per_all_people_f.full_name%type

Line 1058: ,p_full_name in per_all_people_f.full_name%type

1054: ,p_person_id in per_all_people_f.person_id%type
1055: ,p_assignment_id in per_all_assignments_f.assignment_id%type
1056: ,p_effective_date in date
1057: ,p_hire_date in per_periods_of_service.date_start%type
1058: ,p_full_name in per_all_people_f.full_name%type
1059: ,p_per_effective_start_date in per_all_people_f.effective_start_date%type
1060: ,p_title in per_alL_people_f.title%type
1061: ,p_first_name in per_all_people_f.first_name%type
1062: ,p_last_name in per_all_people_f.last_name%type

Line 1059: ,p_per_effective_start_date in per_all_people_f.effective_start_date%type

1055: ,p_assignment_id in per_all_assignments_f.assignment_id%type
1056: ,p_effective_date in date
1057: ,p_hire_date in per_periods_of_service.date_start%type
1058: ,p_full_name in per_all_people_f.full_name%type
1059: ,p_per_effective_start_date in per_all_people_f.effective_start_date%type
1060: ,p_title in per_alL_people_f.title%type
1061: ,p_first_name in per_all_people_f.first_name%type
1062: ,p_last_name in per_all_people_f.last_name%type
1063: ,p_employee_number in per_all_people_f.employee_number%type

Line 1060: ,p_title in per_alL_people_f.title%type

1056: ,p_effective_date in date
1057: ,p_hire_date in per_periods_of_service.date_start%type
1058: ,p_full_name in per_all_people_f.full_name%type
1059: ,p_per_effective_start_date in per_all_people_f.effective_start_date%type
1060: ,p_title in per_alL_people_f.title%type
1061: ,p_first_name in per_all_people_f.first_name%type
1062: ,p_last_name in per_all_people_f.last_name%type
1063: ,p_employee_number in per_all_people_f.employee_number%type
1064: ,p_applicant_number in per_all_people_f.applicant_number%type

Line 1061: ,p_first_name in per_all_people_f.first_name%type

1057: ,p_hire_date in per_periods_of_service.date_start%type
1058: ,p_full_name in per_all_people_f.full_name%type
1059: ,p_per_effective_start_date in per_all_people_f.effective_start_date%type
1060: ,p_title in per_alL_people_f.title%type
1061: ,p_first_name in per_all_people_f.first_name%type
1062: ,p_last_name in per_all_people_f.last_name%type
1063: ,p_employee_number in per_all_people_f.employee_number%type
1064: ,p_applicant_number in per_all_people_f.applicant_number%type
1065: ,p_national_identifier in per_all_people_f.national_identifier%type

Line 1062: ,p_last_name in per_all_people_f.last_name%type

1058: ,p_full_name in per_all_people_f.full_name%type
1059: ,p_per_effective_start_date in per_all_people_f.effective_start_date%type
1060: ,p_title in per_alL_people_f.title%type
1061: ,p_first_name in per_all_people_f.first_name%type
1062: ,p_last_name in per_all_people_f.last_name%type
1063: ,p_employee_number in per_all_people_f.employee_number%type
1064: ,p_applicant_number in per_all_people_f.applicant_number%type
1065: ,p_national_identifier in per_all_people_f.national_identifier%type
1066: ,p_asg_effective_start_date in per_all_assignments_f.effective_start_date%type

Line 1063: ,p_employee_number in per_all_people_f.employee_number%type

1059: ,p_per_effective_start_date in per_all_people_f.effective_start_date%type
1060: ,p_title in per_alL_people_f.title%type
1061: ,p_first_name in per_all_people_f.first_name%type
1062: ,p_last_name in per_all_people_f.last_name%type
1063: ,p_employee_number in per_all_people_f.employee_number%type
1064: ,p_applicant_number in per_all_people_f.applicant_number%type
1065: ,p_national_identifier in per_all_people_f.national_identifier%type
1066: ,p_asg_effective_start_date in per_all_assignments_f.effective_start_date%type
1067: ,p_organization in hr_all_organization_units.name%type

Line 1064: ,p_applicant_number in per_all_people_f.applicant_number%type

1060: ,p_title in per_alL_people_f.title%type
1061: ,p_first_name in per_all_people_f.first_name%type
1062: ,p_last_name in per_all_people_f.last_name%type
1063: ,p_employee_number in per_all_people_f.employee_number%type
1064: ,p_applicant_number in per_all_people_f.applicant_number%type
1065: ,p_national_identifier in per_all_people_f.national_identifier%type
1066: ,p_asg_effective_start_date in per_all_assignments_f.effective_start_date%type
1067: ,p_organization in hr_all_organization_units.name%type
1068: ,p_grade in per_grades.name%type

Line 1065: ,p_national_identifier in per_all_people_f.national_identifier%type

1061: ,p_first_name in per_all_people_f.first_name%type
1062: ,p_last_name in per_all_people_f.last_name%type
1063: ,p_employee_number in per_all_people_f.employee_number%type
1064: ,p_applicant_number in per_all_people_f.applicant_number%type
1065: ,p_national_identifier in per_all_people_f.national_identifier%type
1066: ,p_asg_effective_start_date in per_all_assignments_f.effective_start_date%type
1067: ,p_organization in hr_all_organization_units.name%type
1068: ,p_grade in per_grades.name%type
1069: ,p_job in per_jobs.name%type

Line 1073: ,p_supervisor in per_all_people_f.full_name%type

1069: ,p_job in per_jobs.name%type
1070: ,p_position in hr_all_positions_f.name%type
1071: ,p_payroll in pay_all_payrolls_f.payroll_name%type
1072: ,p_vacancy in per_vacancies.name%type
1073: ,p_supervisor in per_all_people_f.full_name%type
1074: ,p_location in hr_locations.location_code%type
1075: ,p_salary in per_pay_proposals.proposed_salary_n%type
1076: ,p_salary_currency in pay_element_types_f.input_currency_code%type
1077: ,p_pay_basis in hr_lookups.meaning%type

Line 1079: ,p_npw_number in per_all_people_f.npw_number%type

1075: ,p_salary in per_pay_proposals.proposed_salary_n%type
1076: ,p_salary_currency in pay_element_types_f.input_currency_code%type
1077: ,p_pay_basis in hr_lookups.meaning%type
1078: ,p_date_probation_end in per_all_assignments_f.date_probation_end%type
1079: ,p_npw_number in per_all_people_f.npw_number%type
1080: ,p_vendor in po_vendors.vendor_name%type
1081: ,p_supplier_reference in per_all_assignments_f.vendor_employee_number%type
1082: ,p_placement_date_start in per_all_assignments_f.period_of_placement_date_start%type
1083: ,p_grade_ladder in ben_pgm_f.name%type