1 PACKAGE PER_PEOPLE3_PKG AUTHID CURRENT_USER AS
2 /* $Header: peper03t.pkh 120.3.12020000.2 2013/01/18 07:22:43 srannama ship $ */
3 --
4 procedure get_number_generation_property(
5 p_business_group_id NUMBER
6 ,p_property_on NUMBER
7 ,p_property_off NUMBER
8 ,p_employee_property in out nocopy NUMBER
9 ,p_applicant_property in out nocopy NUMBER);
10 --
11 procedure get_legislative_ages(p_business_group_id NUMBER
12 ,p_minimum_age IN OUT NOCOPY NUMBER
13 ,p_maximum_age IN OUT NOCOPY NUMBER);
14 --
15 procedure get_default_person_type(p_required_type VARCHAR2
16 ,p_business_group_id NUMBER
17 ,p_legislation_code VARCHAR2
18 ,p_person_type IN OUT NOCOPY NUMBER);
19 procedure get_ddf_exists(p_legislation_code VARCHAR2
20 ,p_ddf_exists IN OUT NOCOPY VARCHAR2);
21 --
22 -- #1799586
23 procedure get_people_ddf_exists(p_legislation_code VARCHAR2
24 ,p_people_ddf_exists IN OUT NOCOPY VARCHAR2);
25 --
26 procedure initialize(p_business_group_id NUMBER
27 ,p_legislation_code VARCHAR2
28 ,p_ddf_exists IN OUT NOCOPY VARCHAR2
29 ,p_property_on NUMBER
30 ,p_property_off NUMBER
31 ,p_employee_property in out nocopy NUMBER
32 ,p_applicant_property in out nocopy NUMBER
33 ,p_required_emp_type VARCHAR2
34 ,p_required_app_type VARCHAR2
35 ,p_emp_person_type IN OUT NOCOPY NUMBER
36 ,p_app_person_type IN OUT NOCOPY NUMBER);
37 --
41 ,p_property_on NUMBER
38 procedure initialize(p_business_group_id NUMBER
39 ,p_legislation_code VARCHAR2
40 ,p_ddf_exists IN OUT NOCOPY VARCHAR2
42 ,p_property_off NUMBER
43 ,p_employee_property in out nocopy NUMBER
44 ,p_applicant_property in out nocopy NUMBER
45 ,p_required_emp_type VARCHAR2
46 ,p_required_app_type VARCHAR2
47 ,p_emp_person_type IN OUT NOCOPY NUMBER
48 ,p_app_person_type IN OUT NOCOPY NUMBER
49 ,p_minimum_age IN OUT NOCOPY NUMBER
50 ,p_maximum_age IN OUT NOCOPY NUMBER);
51 --
52 procedure initialize(p_business_group_id NUMBER
53 ,p_legislation_code VARCHAR2
54 ,p_ddf_exists IN OUT NOCOPY VARCHAR2
55 ,p_property_on NUMBER
56 ,p_property_off NUMBER
57 ,p_employee_property in out nocopy NUMBER
58 ,p_applicant_property in out nocopy NUMBER
59 ,p_required_emp_type VARCHAR2
60 ,p_required_app_type VARCHAR2
61 ,p_emp_person_type IN OUT NOCOPY NUMBER
62 ,p_app_person_type IN OUT NOCOPY NUMBER
63 ,p_minimum_age IN OUT NOCOPY NUMBER
64 ,p_maximum_age IN OUT NOCOPY NUMBER
65 ,p_people_ddf_exists IN OUT NOCOPY VARCHAR2);
66 --
67 procedure check_future_apl(p_person_id NUMBER
68 ,p_hire_date DATE);
69 --added for bug 5403222
70 procedure check_future_apl(p_person_id NUMBER
71 ,p_hire_date DATE
72 ,p_table HR_EMPLOYEE_APPLICANT_API.t_ApplTable );
73 -- ER FPT
74 procedure fpt_check_future_apl(p_person_id NUMBER
75 ,p_hire_date DATE
76 ,p_assignment_id NUMBER default NULL);
77
78 procedure fpt_check_future_apl(p_person_id NUMBER
79 ,p_hire_date DATE
80 ,p_table HR_EMPLOYEE_APPLICANT_API.t_ApplTable );
81 -- ER FPT
82 --
83 procedure update_period(p_person_id number
84 ,p_hire_date date
85 ,p_new_hire_date date
86 ,p_adjusted_svc_date in date default hr_api.g_date);
87 --
88 procedure run_alu_ee(p_alu_mode VARCHAR2
89 ,p_business_group_id NUMBER
90 ,p_person_id NUMBER
91 ,p_old_start DATE
92 ,p_start_date date);
93 --
94 procedure vacancy_chk (p_person_id NUMBER
95 ,p_fire_warning in out nocopy VARCHAR2
96 ,p_vacancy_id in out nocopy NUMBER
97 -- #2381925
98 ,p_table IN HR_EMPLOYEE_APPLICANT_API.t_ApplTable
99 default HR_EMPLOYEE_APPLICANT_API.T_EmptyAPPL
100 --
101 );
102 --
103 procedure get_accepted_appls(p_person_id NUMBER
104 ,p_num_accepted_appls in out nocopy NUMBER
105 ,p_new_primary_id in out nocopy NUMBER);
106 --
107 procedure get_all_current_appls(p_person_id NUMBER
108 ,p_num_appls in out nocopy NUMBER);
109 --
110 procedure get_date_range(p_person_id in number
111 ,p_min_start in out nocopy date
112 ,p_max_end in out nocopy date);
113 --
114 procedure get_asg_date_range(p_assignment_id in number
115 ,p_min_start in out nocopy date
116 ,p_max_end in out nocopy date);
117 --
118 procedure form_post_query(p_ethnic_code IN VARCHAR2
119 ,p_ethnic_meaning IN OUT NOCOPY VARCHAR2
120 ,p_visa_code IN VARCHAR2
121 ,p_visa_meaning IN OUT NOCOPY VARCHAR2
122 ,p_veteran_code IN VARCHAR2
123 ,p_veteran_meaning IN OUT NOCOPY VARCHAR2
124 ,p_i9_code IN VARCHAR2
125 ,p_i9_meaning IN OUT NOCOPY VARCHAR2
126 ,p_legislation_code IN VARCHAR2);
127 --
128 procedure form_post_query(p_ethnic_code IN VARCHAR2
129 ,p_ethnic_meaning IN OUT NOCOPY VARCHAR2
130 ,p_visa_code IN VARCHAR2
131 ,p_visa_meaning IN OUT NOCOPY VARCHAR2
132 ,p_veteran_code IN VARCHAR2
133 ,p_veteran_meaning IN OUT NOCOPY VARCHAR2
134 ,p_i9_code IN VARCHAR2
135 ,p_i9_meaning IN OUT NOCOPY VARCHAR2
136 ,p_new_hire_code IN VARCHAR2
137 ,p_new_hire_meaning IN OUT NOCOPY VARCHAR2
138 ,p_reason_for_code IN VARCHAR2
139 ,p_reason_for_meaning IN OUT NOCOPY VARCHAR2
140 ,p_legislation_code IN VARCHAR2);
141 --
142 procedure form_post_query(p_ethnic_code IN VARCHAR2
143 ,p_ethnic_meaning IN OUT NOCOPY VARCHAR2
144 ,p_visa_code IN VARCHAR2
145 ,p_visa_meaning IN OUT NOCOPY VARCHAR2
146 ,p_veteran_code IN VARCHAR2
147 ,p_veteran_meaning IN OUT NOCOPY VARCHAR2
148 ,p_i9_code IN VARCHAR2
149 ,p_i9_meaning IN OUT NOCOPY VARCHAR2
150 ,p_new_hire_code IN VARCHAR2
151 ,p_new_hire_meaning IN OUT NOCOPY VARCHAR2
152 ,p_reason_for_code IN VARCHAR2
153 ,p_reason_for_meaning IN OUT NOCOPY VARCHAR2
154 ,p_ethnic_disc_code IN VARCHAR2
155 ,p_ethnic_disc_meaning IN OUT NOCOPY VARCHAR2
156 ,p_legislation_code IN VARCHAR2);
157 --
158 -- Overloaded procedure for bug --bug7608613
159 procedure form_post_query(p_ethnic_code IN VARCHAR2
160 ,p_ethnic_meaning IN OUT NOCOPY VARCHAR2
161 ,p_visa_code IN VARCHAR2
162 ,p_visa_meaning IN OUT NOCOPY VARCHAR2
163 ,p_veteran_code IN VARCHAR2
164 ,p_veteran_meaning IN OUT NOCOPY VARCHAR2
165 ,p_i9_code IN VARCHAR2
166 ,p_i9_meaning IN OUT NOCOPY VARCHAR2
167 ,p_new_hire_code IN VARCHAR2
168 ,p_new_hire_meaning IN OUT NOCOPY VARCHAR2
169 ,p_reason_for_code IN VARCHAR2
170 ,p_reason_for_meaning IN OUT NOCOPY VARCHAR2
171 ,p_ethnic_disc_code IN VARCHAR2
172 ,p_ethnic_disc_meaning IN OUT NOCOPY VARCHAR2
173 ,p_vets100A_code IN VARCHAR2
174 ,p_vets100A_meaning IN OUT NOCOPY VARCHAR2
175 ,p_legislation_code IN VARCHAR2);
176 --
177 function chk_events_exist(p_person_id number
178 ,p_business_group_id number
179 ,p_hire_date date )return boolean;
180 --
181 END PER_PEOPLE3_PKG;