[Home] [Help]
PACKAGE: APPS.PER_QH_ACTION
Source
1 PACKAGE per_qh_action AUTHID CURRENT_USER as
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,
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,
18 p_oversubscribed_vacancy_id out nocopy number
19 );
20 --
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
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
39 ,p_grade per_grades.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
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
55 );
56 --
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
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
75 ,p_grade in per_grades.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
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
91 ,p_subject out nocopy varchar2
92 ,p_body out nocopy varchar2
93 );
94 --
95 end per_qh_action;