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

2: /* $Header: peqhactn.pkh 120.0.12010000.1 2008/07/28 05:30:57 appldev ship $ */
3: procedure quick_hire_applicant
4: (p_validate in boolean default false,
5: p_hire_date in date,
6: p_person_id in per_all_people_f.person_id%TYPE,
7: p_assignment_id in number default null,
8: p_primary_assignment_id in number default null,
9: p_overwrite_primary in varchar2 default 'N',
10: p_person_type_id in number default null,

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

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

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

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

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

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

Line 25: ,p_person_id per_all_people_f.person_id%type

21: procedure send_notification
22: (p_notification wf_messages.name%type
23: ,p_wf_name wf_item_types.name%type
24: ,p_role varchar2 -- wf_roles.name%type Fix for bug 2741492
25: ,p_person_id per_all_people_f.person_id%type
26: ,p_assignment_id per_all_assignments_f.assignment_id%type
27: ,p_effective_date date
28: ,p_hire_date per_periods_of_service.date_start%type
29: ,p_full_name per_all_people_f.full_name%type

Line 29: ,p_full_name per_all_people_f.full_name%type

25: ,p_person_id per_all_people_f.person_id%type
26: ,p_assignment_id per_all_assignments_f.assignment_id%type
27: ,p_effective_date date
28: ,p_hire_date per_periods_of_service.date_start%type
29: ,p_full_name per_all_people_f.full_name%type
30: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
31: ,p_title per_alL_people_f.title%type
32: ,p_first_name per_all_people_f.first_name%type
33: ,p_last_name per_all_people_f.last_name%type

Line 30: ,p_per_effective_start_date per_all_people_f.effective_start_date%type

26: ,p_assignment_id per_all_assignments_f.assignment_id%type
27: ,p_effective_date date
28: ,p_hire_date per_periods_of_service.date_start%type
29: ,p_full_name per_all_people_f.full_name%type
30: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
31: ,p_title per_alL_people_f.title%type
32: ,p_first_name per_all_people_f.first_name%type
33: ,p_last_name per_all_people_f.last_name%type
34: ,p_employee_number per_all_people_f.employee_number%type

Line 31: ,p_title per_alL_people_f.title%type

27: ,p_effective_date date
28: ,p_hire_date per_periods_of_service.date_start%type
29: ,p_full_name per_all_people_f.full_name%type
30: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
31: ,p_title per_alL_people_f.title%type
32: ,p_first_name per_all_people_f.first_name%type
33: ,p_last_name per_all_people_f.last_name%type
34: ,p_employee_number per_all_people_f.employee_number%type
35: ,p_applicant_number per_all_people_f.applicant_number%type

Line 32: ,p_first_name per_all_people_f.first_name%type

28: ,p_hire_date per_periods_of_service.date_start%type
29: ,p_full_name per_all_people_f.full_name%type
30: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
31: ,p_title per_alL_people_f.title%type
32: ,p_first_name per_all_people_f.first_name%type
33: ,p_last_name per_all_people_f.last_name%type
34: ,p_employee_number per_all_people_f.employee_number%type
35: ,p_applicant_number per_all_people_f.applicant_number%type
36: ,p_national_identifier per_all_people_f.national_identifier%type

Line 33: ,p_last_name per_all_people_f.last_name%type

29: ,p_full_name per_all_people_f.full_name%type
30: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
31: ,p_title per_alL_people_f.title%type
32: ,p_first_name per_all_people_f.first_name%type
33: ,p_last_name per_all_people_f.last_name%type
34: ,p_employee_number per_all_people_f.employee_number%type
35: ,p_applicant_number per_all_people_f.applicant_number%type
36: ,p_national_identifier per_all_people_f.national_identifier%type
37: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%type

Line 34: ,p_employee_number per_all_people_f.employee_number%type

30: ,p_per_effective_start_date per_all_people_f.effective_start_date%type
31: ,p_title per_alL_people_f.title%type
32: ,p_first_name per_all_people_f.first_name%type
33: ,p_last_name per_all_people_f.last_name%type
34: ,p_employee_number per_all_people_f.employee_number%type
35: ,p_applicant_number per_all_people_f.applicant_number%type
36: ,p_national_identifier per_all_people_f.national_identifier%type
37: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%type
38: ,p_organization hr_all_organization_units.name%type

Line 35: ,p_applicant_number per_all_people_f.applicant_number%type

31: ,p_title per_alL_people_f.title%type
32: ,p_first_name per_all_people_f.first_name%type
33: ,p_last_name per_all_people_f.last_name%type
34: ,p_employee_number per_all_people_f.employee_number%type
35: ,p_applicant_number per_all_people_f.applicant_number%type
36: ,p_national_identifier per_all_people_f.national_identifier%type
37: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%type
38: ,p_organization hr_all_organization_units.name%type
39: ,p_grade per_grades.name%type

Line 36: ,p_national_identifier per_all_people_f.national_identifier%type

32: ,p_first_name per_all_people_f.first_name%type
33: ,p_last_name per_all_people_f.last_name%type
34: ,p_employee_number per_all_people_f.employee_number%type
35: ,p_applicant_number per_all_people_f.applicant_number%type
36: ,p_national_identifier per_all_people_f.national_identifier%type
37: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%type
38: ,p_organization hr_all_organization_units.name%type
39: ,p_grade per_grades.name%type
40: ,p_job per_jobs.name%type

Line 44: ,p_supervisor per_all_people_f.full_name%type

40: ,p_job per_jobs.name%type
41: ,p_position hr_all_positions_f.name%type
42: ,p_payroll pay_all_payrolls_f.payroll_name%type
43: ,p_vacancy per_vacancies.name%type
44: ,p_supervisor per_all_people_f.full_name%type
45: ,p_location hr_locations.location_code%type
46: ,p_salary per_pay_proposals.proposed_salary_n%type
47: ,p_salary_currency pay_element_types_f.input_currency_code%type
48: ,p_pay_basis hr_lookups.meaning%type

Line 50: ,p_npw_number per_all_people_f.npw_number%type

46: ,p_salary per_pay_proposals.proposed_salary_n%type
47: ,p_salary_currency pay_element_types_f.input_currency_code%type
48: ,p_pay_basis hr_lookups.meaning%type
49: ,p_date_probation_end per_all_assignments_f.date_probation_end%type
50: ,p_npw_number per_all_people_f.npw_number%type
51: ,p_vendor po_vendors.vendor_name%type
52: ,p_supplier_reference per_all_assignments_f.vendor_employee_number%type
53: ,p_placement_date_start per_all_assignments_f.period_of_placement_date_start%type
54: ,p_grade_ladder ben_pgm_f.name%type

Line 61: ,p_person_id in per_all_people_f.person_id%type

57: procedure get_notification_preview
58: (p_notification in wf_messages.name%type
59: ,p_wf_name in wf_item_types.name%type
60: ,p_role in varchar2 -- wf_roles.name%type Fix for bug 2741492
61: ,p_person_id in per_all_people_f.person_id%type
62: ,p_assignment_id in per_all_assignments_f.assignment_id%type
63: ,p_effective_date in date
64: ,p_hire_date in per_periods_of_service.date_start%type
65: ,p_full_name in per_all_people_f.full_name%type

Line 65: ,p_full_name in per_all_people_f.full_name%type

61: ,p_person_id in per_all_people_f.person_id%type
62: ,p_assignment_id in per_all_assignments_f.assignment_id%type
63: ,p_effective_date in date
64: ,p_hire_date in per_periods_of_service.date_start%type
65: ,p_full_name in per_all_people_f.full_name%type
66: ,p_per_effective_start_date in per_all_people_f.effective_start_date%type
67: ,p_title in per_alL_people_f.title%type
68: ,p_first_name in per_all_people_f.first_name%type
69: ,p_last_name in per_all_people_f.last_name%type

Line 66: ,p_per_effective_start_date in per_all_people_f.effective_start_date%type

62: ,p_assignment_id in per_all_assignments_f.assignment_id%type
63: ,p_effective_date in date
64: ,p_hire_date in per_periods_of_service.date_start%type
65: ,p_full_name in per_all_people_f.full_name%type
66: ,p_per_effective_start_date in per_all_people_f.effective_start_date%type
67: ,p_title in per_alL_people_f.title%type
68: ,p_first_name in per_all_people_f.first_name%type
69: ,p_last_name in per_all_people_f.last_name%type
70: ,p_employee_number in per_all_people_f.employee_number%type

Line 67: ,p_title in per_alL_people_f.title%type

63: ,p_effective_date in date
64: ,p_hire_date in per_periods_of_service.date_start%type
65: ,p_full_name in per_all_people_f.full_name%type
66: ,p_per_effective_start_date in per_all_people_f.effective_start_date%type
67: ,p_title in per_alL_people_f.title%type
68: ,p_first_name in per_all_people_f.first_name%type
69: ,p_last_name in per_all_people_f.last_name%type
70: ,p_employee_number in per_all_people_f.employee_number%type
71: ,p_applicant_number in per_all_people_f.applicant_number%type

Line 68: ,p_first_name in per_all_people_f.first_name%type

64: ,p_hire_date in per_periods_of_service.date_start%type
65: ,p_full_name in per_all_people_f.full_name%type
66: ,p_per_effective_start_date in per_all_people_f.effective_start_date%type
67: ,p_title in per_alL_people_f.title%type
68: ,p_first_name in per_all_people_f.first_name%type
69: ,p_last_name in per_all_people_f.last_name%type
70: ,p_employee_number in per_all_people_f.employee_number%type
71: ,p_applicant_number in per_all_people_f.applicant_number%type
72: ,p_national_identifier in per_all_people_f.national_identifier%type

Line 69: ,p_last_name in per_all_people_f.last_name%type

65: ,p_full_name in per_all_people_f.full_name%type
66: ,p_per_effective_start_date in per_all_people_f.effective_start_date%type
67: ,p_title in per_alL_people_f.title%type
68: ,p_first_name in per_all_people_f.first_name%type
69: ,p_last_name in per_all_people_f.last_name%type
70: ,p_employee_number in per_all_people_f.employee_number%type
71: ,p_applicant_number in per_all_people_f.applicant_number%type
72: ,p_national_identifier in per_all_people_f.national_identifier%type
73: ,p_asg_effective_start_date in per_all_assignments_f.effective_start_date%type

Line 70: ,p_employee_number in per_all_people_f.employee_number%type

66: ,p_per_effective_start_date in per_all_people_f.effective_start_date%type
67: ,p_title in per_alL_people_f.title%type
68: ,p_first_name in per_all_people_f.first_name%type
69: ,p_last_name in per_all_people_f.last_name%type
70: ,p_employee_number in per_all_people_f.employee_number%type
71: ,p_applicant_number in per_all_people_f.applicant_number%type
72: ,p_national_identifier in per_all_people_f.national_identifier%type
73: ,p_asg_effective_start_date in per_all_assignments_f.effective_start_date%type
74: ,p_organization in hr_all_organization_units.name%type

Line 71: ,p_applicant_number in per_all_people_f.applicant_number%type

67: ,p_title in per_alL_people_f.title%type
68: ,p_first_name in per_all_people_f.first_name%type
69: ,p_last_name in per_all_people_f.last_name%type
70: ,p_employee_number in per_all_people_f.employee_number%type
71: ,p_applicant_number in per_all_people_f.applicant_number%type
72: ,p_national_identifier in per_all_people_f.national_identifier%type
73: ,p_asg_effective_start_date in per_all_assignments_f.effective_start_date%type
74: ,p_organization in hr_all_organization_units.name%type
75: ,p_grade in per_grades.name%type

Line 72: ,p_national_identifier in per_all_people_f.national_identifier%type

68: ,p_first_name in per_all_people_f.first_name%type
69: ,p_last_name in per_all_people_f.last_name%type
70: ,p_employee_number in per_all_people_f.employee_number%type
71: ,p_applicant_number in per_all_people_f.applicant_number%type
72: ,p_national_identifier in per_all_people_f.national_identifier%type
73: ,p_asg_effective_start_date in per_all_assignments_f.effective_start_date%type
74: ,p_organization in hr_all_organization_units.name%type
75: ,p_grade in per_grades.name%type
76: ,p_job in per_jobs.name%type

Line 80: ,p_supervisor in per_all_people_f.full_name%type

76: ,p_job in per_jobs.name%type
77: ,p_position in hr_all_positions_f.name%type
78: ,p_payroll in pay_all_payrolls_f.payroll_name%type
79: ,p_vacancy in per_vacancies.name%type
80: ,p_supervisor in per_all_people_f.full_name%type
81: ,p_location in hr_locations.location_code%type
82: ,p_salary in per_pay_proposals.proposed_salary_n%type
83: ,p_salary_currency in pay_element_types_f.input_currency_code%type
84: ,p_pay_basis in hr_lookups.meaning%type

Line 86: ,p_npw_number in per_all_people_f.npw_number%type

82: ,p_salary in per_pay_proposals.proposed_salary_n%type
83: ,p_salary_currency in pay_element_types_f.input_currency_code%type
84: ,p_pay_basis in hr_lookups.meaning%type
85: ,p_date_probation_end in per_all_assignments_f.date_probation_end%type
86: ,p_npw_number in per_all_people_f.npw_number%type
87: ,p_vendor in po_vendors.vendor_name%type
88: ,p_supplier_reference in per_all_assignments_f.vendor_employee_number%type
89: ,p_placement_date_start in per_all_assignments_f.period_of_placement_date_start%type
90: ,p_grade_ladder in ben_pgm_f.name%type