[Home] [Help]
PACKAGE: APPS.PER_PERIODS_OF_SERVICE_PKG
Source
1 PACKAGE PER_PERIODS_OF_SERVICE_PKG AUTHID CURRENT_USER AS
2 /* $Header: pepds01t.pkh 120.0.12020000.1 2012/06/29 01:40:39 appldev ship $ */
3 -----------------------------------------------------------------------------
4 procedure delete_per_pay_proposals(p_period_of_service_id number
5 ,p_actual_termination_date date);
6 -----------------------------------------------------------------------------
7 procedure get_years_months(p_session_date IN DATE,
8 p_period_of_service_id IN NUMBER,
9 p_business_group_id IN NUMBER,
10 p_person_id IN NUMBER,
11 p_tp_years IN OUT NOCOPY NUMBER,
12 p_tp_months IN OUT NOCOPY NUMBER,
13 p_total_years IN OUT NOCOPY NUMBER,
14 p_total_months IN OUT NOCOPY NUMBER);
15 -----------------------------------------------------------------------------
16 procedure get_final_dates(p_period_of_service_id NUMBER,
17 p_person_id NUMBER,
18 p_actual_termination_date DATE,
19 p_no_payrolls IN OUT NOCOPY NUMBER,
20 p_final_process_date IN OUT NOCOPY DATE,
21 p_last_standard_process_date IN OUT NOCOPY DATE);
22 -----------------------------------------------------------------------------
23 procedure delete_row(p_row_id VARCHAR2);
24 -----------------------------------------------------------------------------
25 procedure insert_row(p_row_id in out nocopy VARCHAR2
26 ,p_period_of_service_id in out nocopy NUMBER
27 ,p_business_group_id NUMBER
28 ,p_person_id NUMBER
29 ,p_date_start DATE
30 ,p_termination_accepted_per_id NUMBER
31 ,p_accepted_termination_date DATE
32 ,p_actual_termination_date DATE
33 ,p_comments VARCHAR2
34 ,p_final_process_date DATE
35 ,p_last_standard_process_date DATE
36 ,p_leaving_reason VARCHAR2
37 ,p_notified_termination_date DATE
38 ,p_projected_termination_date DATE
39 ,p_request_id NUMBER
40 ,p_program_application_id NUMBER
41 ,p_program_id NUMBER
42 ,p_program_update_date DATE
43 ,p_attribute_category VARCHAR2
44 ,p_attribute1 VARCHAR2
45 ,p_attribute2 VARCHAR2
46 ,p_attribute3 VARCHAR2
47 ,p_attribute4 VARCHAR2
48 ,p_attribute5 VARCHAR2
49 ,p_attribute6 VARCHAR2
50 ,p_attribute7 VARCHAR2
51 ,p_attribute8 VARCHAR2
52 ,p_attribute9 VARCHAR2
53 ,p_attribute10 VARCHAR2
54 ,p_attribute11 VARCHAR2
55 ,p_attribute12 VARCHAR2
56 ,p_attribute13 VARCHAR2
57 ,p_attribute14 VARCHAR2
58 ,p_attribute15 VARCHAR2
59 ,p_attribute16 VARCHAR2
60 ,p_attribute17 VARCHAR2
61 ,p_attribute18 VARCHAR2
62 ,p_attribute19 VARCHAR2
63 ,p_attribute20 VARCHAR2
64 ,p_adjusted_svc_date DATE);
65 -----------------------------------------------------------------------------
66 procedure lock_row(p_row_id VARCHAR2
67 ,p_period_of_service_id NUMBER
68 ,p_business_group_id NUMBER
69 ,p_person_id NUMBER
70 ,p_date_start DATE
71 ,p_termination_accepted_per_id NUMBER
72 ,p_accepted_termination_date DATE
73 ,p_actual_termination_date DATE
74 ,p_comments VARCHAR2
75 ,p_final_process_date DATE
76 ,p_last_standard_process_date DATE
77 ,p_leaving_reason VARCHAR2
78 ,p_notified_termination_date DATE
79 ,p_projected_termination_date DATE
80 ,p_request_id NUMBER
81 ,p_program_application_id NUMBER
82 ,p_program_id NUMBER
83 ,p_program_update_date DATE
84 ,p_attribute_category VARCHAR2
85 ,p_attribute1 VARCHAR2
86 ,p_attribute2 VARCHAR2
87 ,p_attribute3 VARCHAR2
88 ,p_attribute4 VARCHAR2
89 ,p_attribute5 VARCHAR2
90 ,p_attribute6 VARCHAR2
91 ,p_attribute7 VARCHAR2
92 ,p_attribute8 VARCHAR2
93 ,p_attribute9 VARCHAR2
94 ,p_attribute10 VARCHAR2
95 ,p_attribute11 VARCHAR2
96 ,p_attribute12 VARCHAR2
97 ,p_attribute13 VARCHAR2
98 ,p_attribute14 VARCHAR2
99 ,p_attribute15 VARCHAR2
100 ,p_attribute16 VARCHAR2
101 ,p_attribute17 VARCHAR2
102 ,p_attribute18 VARCHAR2
103 ,p_attribute19 VARCHAR2
104 ,p_attribute20 VARCHAR2
105 ,p_pds_information_category VARCHAR2
106 ,p_pds_information1 VARCHAR2
107 ,p_pds_information2 VARCHAR2
108 ,p_pds_information3 VARCHAR2
109 ,p_pds_information4 VARCHAR2
110 ,p_pds_information5 VARCHAR2
111 ,p_pds_information6 VARCHAR2
112 ,p_pds_information7 VARCHAR2
113 ,p_pds_information8 VARCHAR2
114 ,p_pds_information9 VARCHAR2
115 ,p_pds_information10 VARCHAR2
116 ,p_pds_information11 VARCHAR2
117 ,p_pds_information12 VARCHAR2
118 ,p_pds_information13 VARCHAR2
119 ,p_pds_information14 VARCHAR2
120 ,p_pds_information15 VARCHAR2
121 ,p_pds_information16 VARCHAR2
122 ,p_pds_information17 VARCHAR2
123 ,p_pds_information18 VARCHAR2
124 ,p_pds_information19 VARCHAR2
125 ,p_pds_information20 VARCHAR2
126 ,p_pds_information21 VARCHAR2
127 ,p_pds_information22 VARCHAR2
128 ,p_pds_information23 VARCHAR2
129 ,p_pds_information24 VARCHAR2
130 ,p_pds_information25 VARCHAR2
131 ,p_pds_information26 VARCHAR2
132 ,p_pds_information27 VARCHAR2
133 ,p_pds_information28 VARCHAR2
134 ,p_pds_information29 VARCHAR2
135 ,p_pds_information30 VARCHAR2
136 ,p_adjusted_svc_date DATE);
137 -----------------------------------------------------------------------------
138 procedure update_term_row(p_row_id VARCHAR2
139 ,p_period_of_service_id NUMBER
140 ,p_business_group_id NUMBER
141 ,p_person_id NUMBER
142 ,p_date_start DATE
143 ,p_termination_accepted_per_id NUMBER
144 ,p_accepted_termination_date DATE
145 ,p_actual_termination_date DATE
146 ,p_comments VARCHAR2
147 ,p_final_process_date DATE
148 ,p_last_standard_process_date DATE
149 ,p_leaving_reason VARCHAR2
150 ,p_notified_termination_date DATE
151 ,p_projected_termination_date DATE
152 ,p_request_id NUMBER
153 ,p_program_application_id NUMBER
154 ,p_program_id NUMBER
155 ,p_program_update_date DATE
156 ,p_attribute_category VARCHAR2
157 ,p_attribute1 VARCHAR2
158 ,p_attribute2 VARCHAR2
159 ,p_attribute3 VARCHAR2
160 ,p_attribute4 VARCHAR2
161 ,p_attribute5 VARCHAR2
162 ,p_attribute6 VARCHAR2
163 ,p_attribute7 VARCHAR2
164 ,p_attribute8 VARCHAR2
165 ,p_attribute9 VARCHAR2
166 ,p_attribute10 VARCHAR2
167 ,p_attribute11 VARCHAR2
168 ,p_attribute12 VARCHAR2
169 ,p_attribute13 VARCHAR2
170 ,p_attribute14 VARCHAR2
171 ,p_attribute15 VARCHAR2
172 ,p_attribute16 VARCHAR2
173 ,p_attribute17 VARCHAR2
174 ,p_attribute18 VARCHAR2
175 ,p_attribute19 VARCHAR2
176 ,p_attribute20 VARCHAR2
177 ,p_initiate_cancellation VARCHAR2
178 ,p_s_final_process_date IN OUT NOCOPY DATE
179 ,p_s_actual_termination_date IN OUT NOCOPY DATE
180 ,p_c_assignment_status_type_id IN OUT NOCOPY NUMBER
181 ,p_d_status VARCHAR2
182 ,p_requery_required IN OUT NOCOPY VARCHAR2
183 ,p_clear_details VARCHAR2 DEFAULT 'N'
184 ,p_legislation_code VARCHAR2
185 ,p_pds_information_category VARCHAR2
186 ,p_pds_information1 VARCHAR2
187 ,p_pds_information2 VARCHAR2
188 ,p_pds_information3 VARCHAR2
189 ,p_pds_information4 VARCHAR2
190 ,p_pds_information5 VARCHAR2
191 ,p_pds_information6 VARCHAR2
192 ,p_pds_information7 VARCHAR2
193 ,p_pds_information8 VARCHAR2
194 ,p_pds_information9 VARCHAR2
195 ,p_pds_information10 VARCHAR2
196 ,p_pds_information11 VARCHAR2
197 ,p_pds_information12 VARCHAR2
198 ,p_pds_information13 VARCHAR2
199 ,p_pds_information14 VARCHAR2
200 ,p_pds_information15 VARCHAR2
201 ,p_pds_information16 VARCHAR2
202 ,p_pds_information17 VARCHAR2
203 ,p_pds_information18 VARCHAR2
204 ,p_pds_information19 VARCHAR2
205 ,p_pds_information20 VARCHAR2
206 ,p_pds_information21 VARCHAR2
207 ,p_pds_information22 VARCHAR2
208 ,p_pds_information23 VARCHAR2
209 ,p_pds_information24 VARCHAR2
210 ,p_pds_information25 VARCHAR2
211 ,p_pds_information26 VARCHAR2
212 ,p_pds_information27 VARCHAR2
213 ,p_pds_information28 VARCHAR2
214 ,p_pds_information29 VARCHAR2
215 ,p_pds_information30 VARCHAR2
216 ,p_adjusted_svc_date DATE
217 );
218 -----------------------------------------------------------------------------
219 procedure update_term_row(p_row_id VARCHAR2
220 ,p_period_of_service_id NUMBER
221 ,p_business_group_id NUMBER
222 ,p_person_id NUMBER
223 ,p_date_start DATE
224 ,p_termination_accepted_per_id NUMBER
225 ,p_accepted_termination_date DATE
226 ,p_actual_termination_date DATE
227 ,p_comments VARCHAR2
228 ,p_final_process_date DATE
229 ,p_last_standard_process_date DATE
230 ,p_leaving_reason VARCHAR2
231 ,p_notified_termination_date DATE
232 ,p_projected_termination_date DATE
233 ,p_request_id NUMBER
234 ,p_program_application_id NUMBER
235 ,p_program_id NUMBER
236 ,p_program_update_date DATE
237 ,p_attribute_category VARCHAR2
238 ,p_attribute1 VARCHAR2
239 ,p_attribute2 VARCHAR2
240 ,p_attribute3 VARCHAR2
241 ,p_attribute4 VARCHAR2
242 ,p_attribute5 VARCHAR2
243 ,p_attribute6 VARCHAR2
244 ,p_attribute7 VARCHAR2
245 ,p_attribute8 VARCHAR2
246 ,p_attribute9 VARCHAR2
247 ,p_attribute10 VARCHAR2
248 ,p_attribute11 VARCHAR2
249 ,p_attribute12 VARCHAR2
250 ,p_attribute13 VARCHAR2
251 ,p_attribute14 VARCHAR2
252 ,p_attribute15 VARCHAR2
253 ,p_attribute16 VARCHAR2
254 ,p_attribute17 VARCHAR2
255 ,p_attribute18 VARCHAR2
256 ,p_attribute19 VARCHAR2
257 ,p_attribute20 VARCHAR2
258 ,p_initiate_cancellation VARCHAR2
259 ,p_s_final_process_date IN OUT NOCOPY DATE
260 ,p_s_actual_termination_date IN OUT NOCOPY DATE
261 ,p_c_assignment_status_type_id IN OUT NOCOPY NUMBER
262 ,p_d_status VARCHAR2
263 ,p_requery_required IN OUT NOCOPY VARCHAR2
264 ,p_clear_details VARCHAR2 DEFAULT 'N'
265 ,p_legislation_code VARCHAR2
266 ,p_pds_information_category VARCHAR2
267 ,p_pds_information1 VARCHAR2
268 ,p_pds_information2 VARCHAR2
269 ,p_pds_information3 VARCHAR2
270 ,p_pds_information4 VARCHAR2
271 ,p_pds_information5 VARCHAR2
272 ,p_pds_information6 VARCHAR2
273 ,p_pds_information7 VARCHAR2
274 ,p_pds_information8 VARCHAR2
275 ,p_pds_information9 VARCHAR2
276 ,p_pds_information10 VARCHAR2
277 ,p_pds_information11 VARCHAR2
278 ,p_pds_information12 VARCHAR2
279 ,p_pds_information13 VARCHAR2
280 ,p_pds_information14 VARCHAR2
281 ,p_pds_information15 VARCHAR2
282 ,p_pds_information16 VARCHAR2
283 ,p_pds_information17 VARCHAR2
284 ,p_pds_information18 VARCHAR2
285 ,p_pds_information19 VARCHAR2
289 ,p_pds_information23 VARCHAR2
286 ,p_pds_information20 VARCHAR2
287 ,p_pds_information21 VARCHAR2
288 ,p_pds_information22 VARCHAR2
290 ,p_pds_information24 VARCHAR2
291 ,p_pds_information25 VARCHAR2
292 ,p_pds_information26 VARCHAR2
293 ,p_pds_information27 VARCHAR2
294 ,p_pds_information28 VARCHAR2
295 ,p_pds_information29 VARCHAR2
296 ,p_pds_information30 VARCHAR2
297 ,p_adjusted_svc_date DATE
298 ,p_dodwarning OUT NOCOPY VARCHAR2);
299 -----------------------------------------------------------------------------
300 procedure update_row(p_row_id VARCHAR2
301 ,p_period_of_service_id NUMBER
302 ,p_business_group_id NUMBER
303 ,p_person_id NUMBER
304 ,p_date_start DATE
305 ,p_termination_accepted_per_id NUMBER
306 ,p_accepted_termination_date DATE
307 ,p_actual_termination_date DATE
308 ,p_comments VARCHAR2
309 ,p_final_process_date DATE
310 ,p_last_standard_process_date DATE
311 ,p_leaving_reason VARCHAR2
312 ,p_notified_termination_date DATE
313 ,p_projected_termination_date DATE
314 ,p_request_id NUMBER
315 ,p_program_application_id NUMBER
316 ,p_program_id NUMBER
317 ,p_program_update_date DATE
318 ,p_attribute_category VARCHAR2
319 ,p_attribute1 VARCHAR2
320 ,p_attribute2 VARCHAR2
321 ,p_attribute3 VARCHAR2
322 ,p_attribute4 VARCHAR2
323 ,p_attribute5 VARCHAR2
324 ,p_attribute6 VARCHAR2
325 ,p_attribute7 VARCHAR2
326 ,p_attribute8 VARCHAR2
327 ,p_attribute9 VARCHAR2
328 ,p_attribute10 VARCHAR2
329 ,p_attribute11 VARCHAR2
330 ,p_attribute12 VARCHAR2
331 ,p_attribute13 VARCHAR2
332 ,p_attribute14 VARCHAR2
333 ,p_attribute15 VARCHAR2
334 ,p_attribute16 VARCHAR2
335 ,p_attribute17 VARCHAR2
336 ,p_attribute18 VARCHAR2
337 ,p_attribute19 VARCHAR2
338 ,p_attribute20 VARCHAR2
339 ,p_pds_information_category VARCHAR2
340 ,p_pds_information1 VARCHAR2
341 ,p_pds_information2 VARCHAR2
342 ,p_pds_information3 VARCHAR2
343 ,p_pds_information4 VARCHAR2
344 ,p_pds_information5 VARCHAR2
345 ,p_pds_information6 VARCHAR2
346 ,p_pds_information7 VARCHAR2
347 ,p_pds_information8 VARCHAR2
348 ,p_pds_information9 VARCHAR2
349 ,p_pds_information10 VARCHAR2
350 ,p_pds_information11 VARCHAR2
351 ,p_pds_information12 VARCHAR2
352 ,p_pds_information13 VARCHAR2
353 ,p_pds_information14 VARCHAR2
354 ,p_pds_information15 VARCHAR2
355 ,p_pds_information16 VARCHAR2
356 ,p_pds_information17 VARCHAR2
357 ,p_pds_information18 VARCHAR2
358 ,p_pds_information19 VARCHAR2
359 ,p_pds_information20 VARCHAR2
360 ,p_pds_information21 VARCHAR2
361 ,p_pds_information22 VARCHAR2
362 ,p_pds_information23 VARCHAR2
363 ,p_pds_information24 VARCHAR2
364 ,p_pds_information25 VARCHAR2
365 ,p_pds_information26 VARCHAR2
366 ,p_pds_information27 VARCHAR2
367 ,p_pds_information28 VARCHAR2
368 ,p_pds_information29 VARCHAR2
369 ,p_pds_information30 VARCHAR2
370 ,p_adjusted_svc_date DATE);
371 -------------------------------------------------------------------------------
372 procedure populate_status(p_person_id NUMBER
373 ,p_status in out nocopy VARCHAR2
374 ,p_assignment_status_id in out nocopy number);
375 -----------------------------------------------------------------------------
376 procedure form_post_query(p_session_date DATE
377 ,p_period_of_service_id NUMBER
378 ,p_business_group_id NUMBER
379 ,p_person_id NUMBER
380 ,p_tp_years IN OUT NOCOPY NUMBER
381 ,p_tp_months IN OUT NOCOPY NUMBER
382 ,p_total_years IN OUT NOCOPY NUMBER
383 ,p_total_months IN OUT NOCOPY NUMBER
384 ,p_actual_termination_date DATE
385 ,p_status IN OUT NOCOPY VARCHAR2
386 ,p_termination_accepted_id IN NUMBER
387 ,p_terminated_name IN OUT NOCOPY VARCHAR2
388 ,p_terminated_number IN OUT NOCOPY VARCHAR2
389 ,p_assignment_status_id IN OUT NOCOPY NUMBER);
390 -------------------------------------------------------------------------------
391
392 END PER_PERIODS_OF_SERVICE_PKG;