1 Package hr_ex_employee_internal as
2 /* $Header: peexebsi.pkh 120.4.12010000.1 2008/07/28 04:40:30 appldev ship $ */
3 --
4 -- Package globals
5 --
6 g_mask_pds_ler boolean := FALSE;
7 g_actual_termination_date date;
8 --
9 -- ----------------------------------------------------------------------------
10 -- |--------------------< Terminate_Employee (overloaded) >-------------------|
11 -- ----------------------------------------------------------------------------
12 --
13 -- This version of the API is now out-of-date however it has been provided to
14 -- you for backward compatibility support and will be removed in the future.
15 -- Oracle recommends you to modify existing calling programs in advance of the
16 -- support being withdrawn thus avoiding any potential disruption.
17 --
18 procedure terminate_employee
19 (p_validate in boolean default false
20 ,p_effective_date in date
21 ,p_period_of_service_id in number
22 ,p_object_version_number in out nocopy number
23 ,p_person_type_id in number default hr_api.g_number
24 ,p_assignment_status_type_id in number default hr_api.g_number
25 ,p_termination_accepted_person in number default hr_api.g_number
26 ,p_accepted_termination_date in date default hr_api.g_date
27 ,p_actual_termination_date in date default hr_api.g_date
28 ,p_final_process_date in out nocopy date
29 ,p_last_standard_process_date in out nocopy date
30 ,p_leaving_reason in varchar2 default hr_api.g_varchar2
31 ,p_comments in varchar2 default hr_api.g_varchar2
32 ,p_notified_termination_date in date default hr_api.g_date
33 ,p_projected_termination_date in date default hr_api.g_date
34 ,p_adjusted_svc_date in date default hr_api.g_date
35 ,p_attribute_category in varchar2 default hr_api.g_varchar2
36 ,p_attribute1 in varchar2 default hr_api.g_varchar2
37 ,p_attribute2 in varchar2 default hr_api.g_varchar2
38 ,p_attribute3 in varchar2 default hr_api.g_varchar2
39 ,p_attribute4 in varchar2 default hr_api.g_varchar2
40 ,p_attribute5 in varchar2 default hr_api.g_varchar2
41 ,p_attribute6 in varchar2 default hr_api.g_varchar2
42 ,p_attribute7 in varchar2 default hr_api.g_varchar2
43 ,p_attribute8 in varchar2 default hr_api.g_varchar2
44 ,p_attribute9 in varchar2 default hr_api.g_varchar2
45 ,p_attribute10 in varchar2 default hr_api.g_varchar2
46 ,p_attribute11 in varchar2 default hr_api.g_varchar2
47 ,p_attribute12 in varchar2 default hr_api.g_varchar2
48 ,p_attribute13 in varchar2 default hr_api.g_varchar2
49 ,p_attribute14 in varchar2 default hr_api.g_varchar2
50 ,p_attribute15 in varchar2 default hr_api.g_varchar2
51 ,p_attribute16 in varchar2 default hr_api.g_varchar2
52 ,p_attribute17 in varchar2 default hr_api.g_varchar2
53 ,p_attribute18 in varchar2 default hr_api.g_varchar2
54 ,p_attribute19 in varchar2 default hr_api.g_varchar2
55 ,p_attribute20 in varchar2 default hr_api.g_varchar2
56 ,p_pds_information_category in varchar2 default hr_api.g_varchar2
57 ,p_pds_information1 in varchar2 default hr_api.g_varchar2
58 ,p_pds_information2 in varchar2 default hr_api.g_varchar2
59 ,p_pds_information3 in varchar2 default hr_api.g_varchar2
60 ,p_pds_information4 in varchar2 default hr_api.g_varchar2
61 ,p_pds_information5 in varchar2 default hr_api.g_varchar2
62 ,p_pds_information6 in varchar2 default hr_api.g_varchar2
63 ,p_pds_information7 in varchar2 default hr_api.g_varchar2
64 ,p_pds_information8 in varchar2 default hr_api.g_varchar2
65 ,p_pds_information9 in varchar2 default hr_api.g_varchar2
66 ,p_pds_information10 in varchar2 default hr_api.g_varchar2
67 ,p_pds_information11 in varchar2 default hr_api.g_varchar2
68 ,p_pds_information12 in varchar2 default hr_api.g_varchar2
69 ,p_pds_information13 in varchar2 default hr_api.g_varchar2
70 ,p_pds_information14 in varchar2 default hr_api.g_varchar2
71 ,p_pds_information15 in varchar2 default hr_api.g_varchar2
72 ,p_pds_information16 in varchar2 default hr_api.g_varchar2
73 ,p_pds_information17 in varchar2 default hr_api.g_varchar2
74 ,p_pds_information18 in varchar2 default hr_api.g_varchar2
75 ,p_pds_information19 in varchar2 default hr_api.g_varchar2
76 ,p_pds_information20 in varchar2 default hr_api.g_varchar2
77 ,p_pds_information21 in varchar2 default hr_api.g_varchar2
78 ,p_pds_information22 in varchar2 default hr_api.g_varchar2
79 ,p_pds_information23 in varchar2 default hr_api.g_varchar2
80 ,p_pds_information24 in varchar2 default hr_api.g_varchar2
81 ,p_pds_information25 in varchar2 default hr_api.g_varchar2
82 ,p_pds_information26 in varchar2 default hr_api.g_varchar2
83 ,p_pds_information27 in varchar2 default hr_api.g_varchar2
84 ,p_pds_information28 in varchar2 default hr_api.g_varchar2
85 ,p_pds_information29 in varchar2 default hr_api.g_varchar2
86 ,p_pds_information30 in varchar2 default hr_api.g_varchar2
87 ,p_supervisor_warning out nocopy boolean
88 ,p_event_warning out nocopy boolean
89 ,p_interview_warning out nocopy boolean
90 ,p_review_warning out nocopy boolean
91 ,p_recruiter_warning out nocopy boolean
92 ,p_asg_future_changes_warning out nocopy boolean
93 ,p_entries_changed_warning out nocopy varchar2
94 ,p_pay_proposal_warning out nocopy boolean
95 ,p_dod_warning out nocopy boolean
96 ,p_org_now_no_manager_warning out nocopy boolean
97 ,p_addl_rights_warning out nocopy boolean -- Fix 1370960
98 );
99 --
100 -- ----------------------------------------------------------------------------
101 -- |--------------------------< Terminate_Employee >--------------------------|
102 -- ----------------------------------------------------------------------------
103 -- {Start Of Comments}
104 --
105 -- Description:
106 -- This business support process has been written to provide a single
107 -- call point for the 'End Employment' form when performing employee
108 -- termination which involves calling the following APIs :
109 --
110 -- actual_termination_emp
111 -- final_process_emp
112 -- update_term_details_emp
113 -- update_pds_details
114 --
115 --
116 -- Prerequisites:
117 --
118 -- In Parameters:
119 -- Name Reqd Type Description
120 -- p_validate No boolean If true, the database
121 -- remains unchanged. If false
122 -- then the period of service,
123 -- person, assignment and
124 -- element entries are
125 -- updated.
126 -- p_period_of_service_id Yes number ID of the period of service
127 -- p_object_version_number Yes number Version number of the
128 -- period of service
129 --
130 -- Post Success:
131 -- The API updates the period of service, modifies the person, assignments,
132 -- element entries and sets the following out parameters:
133 --
134 -- Name Type Description
135 -- p_object_version_number number If p_validate is false, set to
136 -- the new version number of the
137 -- updated period of service record.
138 -- If p_validate is true, set to the
139 -- same value you passed in.
140 --
141 -- Post Failure:
142 -- The API does not update the period of service, person, assignments, or
143 -- element entries and raises an error.
144 --
145 -- Access Status:
146 -- Internal.
147 --
148 -- {End Of Comments}
149 --
150 procedure terminate_employee
151 (p_validate in boolean default false
152 ,p_effective_date in date
153 ,p_period_of_service_id in number
154 ,p_object_version_number in out nocopy number
155 ,p_person_type_id in number default hr_api.g_number
156 ,p_assignment_status_type_id in number default hr_api.g_number
157 ,p_termination_accepted_person in number default hr_api.g_number
158 ,p_accepted_termination_date in date default hr_api.g_date
159 ,p_actual_termination_date in date default hr_api.g_date
160 ,p_final_process_date in out nocopy date
161 ,p_last_standard_process_date in out nocopy date
162 ,p_leaving_reason in varchar2 default hr_api.g_varchar2
163 ,p_comments in varchar2 default hr_api.g_varchar2
164 ,p_notified_termination_date in date default hr_api.g_date
165 ,p_projected_termination_date in date default hr_api.g_date
166 ,p_adjusted_svc_date in date default hr_api.g_date
167 ,p_attribute_category in varchar2 default hr_api.g_varchar2
168 ,p_attribute1 in varchar2 default hr_api.g_varchar2
169 ,p_attribute2 in varchar2 default hr_api.g_varchar2
170 ,p_attribute3 in varchar2 default hr_api.g_varchar2
171 ,p_attribute4 in varchar2 default hr_api.g_varchar2
172 ,p_attribute5 in varchar2 default hr_api.g_varchar2
173 ,p_attribute6 in varchar2 default hr_api.g_varchar2
174 ,p_attribute7 in varchar2 default hr_api.g_varchar2
175 ,p_attribute8 in varchar2 default hr_api.g_varchar2
176 ,p_attribute9 in varchar2 default hr_api.g_varchar2
177 ,p_attribute10 in varchar2 default hr_api.g_varchar2
178 ,p_attribute11 in varchar2 default hr_api.g_varchar2
179 ,p_attribute12 in varchar2 default hr_api.g_varchar2
180 ,p_attribute13 in varchar2 default hr_api.g_varchar2
181 ,p_attribute14 in varchar2 default hr_api.g_varchar2
182 ,p_attribute15 in varchar2 default hr_api.g_varchar2
183 ,p_attribute16 in varchar2 default hr_api.g_varchar2
184 ,p_attribute17 in varchar2 default hr_api.g_varchar2
185 ,p_attribute18 in varchar2 default hr_api.g_varchar2
186 ,p_attribute19 in varchar2 default hr_api.g_varchar2
187 ,p_attribute20 in varchar2 default hr_api.g_varchar2
188 ,p_pds_information_category in varchar2 default hr_api.g_varchar2
189 ,p_pds_information1 in varchar2 default hr_api.g_varchar2
190 ,p_pds_information2 in varchar2 default hr_api.g_varchar2
191 ,p_pds_information3 in varchar2 default hr_api.g_varchar2
192 ,p_pds_information4 in varchar2 default hr_api.g_varchar2
193 ,p_pds_information5 in varchar2 default hr_api.g_varchar2
194 ,p_pds_information6 in varchar2 default hr_api.g_varchar2
195 ,p_pds_information7 in varchar2 default hr_api.g_varchar2
196 ,p_pds_information8 in varchar2 default hr_api.g_varchar2
197 ,p_pds_information9 in varchar2 default hr_api.g_varchar2
198 ,p_pds_information10 in varchar2 default hr_api.g_varchar2
199 ,p_pds_information11 in varchar2 default hr_api.g_varchar2
200 ,p_pds_information12 in varchar2 default hr_api.g_varchar2
201 ,p_pds_information13 in varchar2 default hr_api.g_varchar2
202 ,p_pds_information14 in varchar2 default hr_api.g_varchar2
203 ,p_pds_information15 in varchar2 default hr_api.g_varchar2
204 ,p_pds_information16 in varchar2 default hr_api.g_varchar2
205 ,p_pds_information17 in varchar2 default hr_api.g_varchar2
206 ,p_pds_information18 in varchar2 default hr_api.g_varchar2
207 ,p_pds_information19 in varchar2 default hr_api.g_varchar2
208 ,p_pds_information20 in varchar2 default hr_api.g_varchar2
209 ,p_pds_information21 in varchar2 default hr_api.g_varchar2
210 ,p_pds_information22 in varchar2 default hr_api.g_varchar2
211 ,p_pds_information23 in varchar2 default hr_api.g_varchar2
212 ,p_pds_information24 in varchar2 default hr_api.g_varchar2
213 ,p_pds_information25 in varchar2 default hr_api.g_varchar2
214 ,p_pds_information26 in varchar2 default hr_api.g_varchar2
215 ,p_pds_information27 in varchar2 default hr_api.g_varchar2
216 ,p_pds_information28 in varchar2 default hr_api.g_varchar2
217 ,p_pds_information29 in varchar2 default hr_api.g_varchar2
218 ,p_pds_information30 in varchar2 default hr_api.g_varchar2
219 ,p_supervisor_warning out nocopy boolean
220 ,p_event_warning out nocopy boolean
221 ,p_interview_warning out nocopy boolean
222 ,p_review_warning out nocopy boolean
223 ,p_recruiter_warning out nocopy boolean
224 ,p_asg_future_changes_warning out nocopy boolean
225 ,p_entries_changed_warning out nocopy varchar2
226 ,p_pay_proposal_warning out nocopy boolean
227 ,p_dod_warning out nocopy boolean
228 ,p_org_now_no_manager_warning out nocopy boolean
229 ,p_addl_rights_warning out nocopy boolean -- Fix 1370960
230 ,p_alu_change_warning out nocopy varchar2
231 );
232 -- ----------------------------------------------------------------------------
233 -- |-----------------------< reverse_terminate_employee >-------------------------|
234 -- ----------------------------------------------------------------------------
235 --
236 -- {Start Of Comments}
237 --
238 -- Description:
239 -- This business support process is not published, hence not meant for public calls.
240 --
241 -- Prerequisites:
242 -- The employee must exist in the database.
243 --
244 -- In Parameters:
245 -- Name Reqd Type Description
246 -- p_person_id Yes Number person_id
247 -- p_actual_termination_date Yes date Actual termination date
248 -- p_clear_details Yes varchar2
249 --
250 -- Post Success:
251 -- The procedure will raise a Business Event when an employee's termination
252 -- is cancelled.
253 --
254 -- Access Status:
255 -- Internal development use only
256 --
257 -- {End Of Comments}
258
259 procedure reverse_terminate_employee
260 (p_person_id in number
261 ,p_actual_termination_date in date
262 ,p_clear_details in varchar2
263 );
264 --
265 end hr_ex_employee_internal;