1 PACKAGE PAY_MISC_DYT_INCIDENT_PKG AS
2 /* $Header: paymiscdytincpkg.pkh 120.4 2006/12/08 14:49:22 susivasu noship $ */
3 /* Global definitions */
4 --
5 ------------------------------------------------------------------------------------
6 -- Here are all the trigger point procedures for Core
7 ------------------------------------------------------------------------------------
8 --
9 --
10 procedure per_performance_reviews_aru(
11 p_business_group_id in number,
12 p_legislation_code in varchar2,
13 p_effective_date in date ,
14 p_old_ATTRIBUTE1 in VARCHAR2,
15 p_new_ATTRIBUTE1 in VARCHAR2 ,
16 p_old_ATTRIBUTE10 in VARCHAR2,
17 p_new_ATTRIBUTE10 in VARCHAR2 ,
18 p_old_ATTRIBUTE11 in VARCHAR2,
19 p_new_ATTRIBUTE11 in VARCHAR2 ,
20 p_old_ATTRIBUTE12 in VARCHAR2,
21 p_new_ATTRIBUTE12 in VARCHAR2 ,
22 p_old_ATTRIBUTE13 in VARCHAR2,
23 p_new_ATTRIBUTE13 in VARCHAR2 ,
24 p_old_ATTRIBUTE14 in VARCHAR2,
25 p_new_ATTRIBUTE14 in VARCHAR2 ,
26 p_old_ATTRIBUTE15 in VARCHAR2,
27 p_new_ATTRIBUTE15 in VARCHAR2 ,
28 p_old_ATTRIBUTE16 in VARCHAR2,
29 p_new_ATTRIBUTE16 in VARCHAR2 ,
30 p_old_ATTRIBUTE17 in VARCHAR2,
31 p_new_ATTRIBUTE17 in VARCHAR2 ,
32 p_old_ATTRIBUTE18 in VARCHAR2,
33 p_new_ATTRIBUTE18 in VARCHAR2 ,
34 p_old_ATTRIBUTE19 in VARCHAR2,
35 p_new_ATTRIBUTE19 in VARCHAR2 ,
36 p_old_ATTRIBUTE2 in VARCHAR2,
37 p_new_ATTRIBUTE2 in VARCHAR2 ,
38 p_old_ATTRIBUTE20 in VARCHAR2,
39 p_new_ATTRIBUTE20 in VARCHAR2 ,
40 p_old_ATTRIBUTE21 in VARCHAR2,
41 p_new_ATTRIBUTE21 in VARCHAR2 ,
42 p_old_ATTRIBUTE22 in VARCHAR2,
43 p_new_ATTRIBUTE22 in VARCHAR2 ,
44 p_old_ATTRIBUTE23 in VARCHAR2,
45 p_new_ATTRIBUTE23 in VARCHAR2 ,
46 p_old_ATTRIBUTE24 in VARCHAR2,
47 p_new_ATTRIBUTE24 in VARCHAR2,
48 p_old_ATTRIBUTE25 in VARCHAR2,
49 p_new_ATTRIBUTE25 in VARCHAR2 ,
50 p_old_ATTRIBUTE26 in VARCHAR2,
51 p_new_ATTRIBUTE26 in VARCHAR2 ,
52 p_old_ATTRIBUTE27 in VARCHAR2,
53 p_new_ATTRIBUTE27 in VARCHAR2 ,
54 p_old_ATTRIBUTE28 in VARCHAR2,
55 p_new_ATTRIBUTE28 in VARCHAR2 ,
56 p_old_ATTRIBUTE29 in VARCHAR2,
57 p_new_ATTRIBUTE29 in VARCHAR2 ,
58 p_old_ATTRIBUTE3 in VARCHAR2,
59 p_new_ATTRIBUTE3 in VARCHAR2 ,
60 p_old_ATTRIBUTE30 in VARCHAR2,
61 p_new_ATTRIBUTE30 in VARCHAR2 ,
62 p_old_ATTRIBUTE4 in VARCHAR2,
63 p_new_ATTRIBUTE4 in VARCHAR2 ,
64 p_old_ATTRIBUTE5 in VARCHAR2,
65 p_new_ATTRIBUTE5 in VARCHAR2 ,
66 p_old_ATTRIBUTE6 in VARCHAR2,
67 p_new_ATTRIBUTE6 in VARCHAR2 ,
68 p_old_ATTRIBUTE7 in VARCHAR2,
69 p_new_ATTRIBUTE7 in VARCHAR2 ,
70 p_old_ATTRIBUTE8 in VARCHAR2,
71 p_new_ATTRIBUTE8 in VARCHAR2 ,
72 p_old_ATTRIBUTE9 in VARCHAR2,
73 p_new_ATTRIBUTE9 in VARCHAR2 ,
74 p_old_ATTRIBUTE_CATEGORY in VARCHAR2,
75 p_new_ATTRIBUTE_CATEGORY in VARCHAR2 ,
76 p_old_EVENT_ID in NUMBER,
77 p_new_EVENT_ID in NUMBER ,
78 p_old_NEXT_PERF_REVIEW_DATE in DATE,
79 p_new_NEXT_PERF_REVIEW_DATE in DATE ,
80 p_old_PERFORMANCE_RATING in VARCHAR2,
81 p_new_PERFORMANCE_RATING in VARCHAR2 ,
82 p_old_PERFORMANCE_REVIEW_ID in NUMBER,
83 p_new_PERFORMANCE_REVIEW_ID in NUMBER ,
84 p_old_PERSON_ID in NUMBER,
85 p_new_PERSON_ID in NUMBER ,
86 p_old_REVIEW_DATE in DATE,
87 p_new_REVIEW_DATE in DATE
88 ) ;
89
90 procedure PER_PERFORMANCE_REVIEWS_ari(
91 p_business_group_id in number,
92 p_legislation_code in varchar2,
93 p_person_id in number,
94 p_performance_review_id in number,
95 p_effective_start_date in date
96 );
97 --
98 procedure per_performance_reviews_ard(
99 p_business_group_id in number,
100 p_legislation_code in varchar2,
101 p_person_id in number,
102 p_effective_start_date in date,
103 p_performance_review_id in number
104 );
105 --
106 procedure per_appraisals_ari(
107 p_business_group_id in number,
108 p_legislation_code in varchar2,
109 p_appraisee_person_id in number,
110 p_appraisal_id in number,
111 p_effective_start_date in date
112 );
113 --
114 procedure per_appraisals_aru(
115 p_business_group_id in number,
116 p_legislation_code in varchar2,
117 p_effective_date in date,
118 p_old_APPRAISAL_ID in NUMBER,
119 p_new_APPRAISAL_ID in NUMBER,
120 p_old_APPRAISAL_PERIOD_END_DAT in DATE,
121 p_new_APPRAISAL_PERIOD_END_DAT in DATE,
122 p_old_APPRAISAL_PERIOD_START_D in DATE,
123 p_new_APPRAISAL_PERIOD_START_D in DATE,
124 p_old_APPRAISAL_TEMPLATE_ID in NUMBER,
125 p_new_APPRAISAL_TEMPLATE_ID in NUMBER,
126 p_old_APPRAISEE_PERSON_ID in NUMBER,
127 p_new_APPRAISEE_PERSON_ID in NUMBER,
128 p_old_APPRAISER_PERSON_ID in NUMBER,
129 p_new_APPRAISER_PERSON_ID in NUMBER,
130 p_old_ATTRIBUTE1 in VARCHAR2,
131 p_new_ATTRIBUTE1 in VARCHAR2,
132 p_old_ATTRIBUTE2 in VARCHAR2,
133 p_new_ATTRIBUTE2 in VARCHAR2,
134 p_old_ATTRIBUTE3 in VARCHAR2,
135 p_new_ATTRIBUTE3 in VARCHAR2,
136 p_old_ATTRIBUTE4 in VARCHAR2,
137 p_new_ATTRIBUTE4 in VARCHAR2,
138 p_old_ATTRIBUTE5 in VARCHAR2,
139 p_new_ATTRIBUTE5 in VARCHAR2,
140 p_old_ATTRIBUTE6 in VARCHAR2,
141 p_new_ATTRIBUTE6 in VARCHAR2,
142 p_old_ATTRIBUTE7 in VARCHAR2,
143 p_new_ATTRIBUTE7 in VARCHAR2,
144 p_old_ATTRIBUTE8 in VARCHAR2,
145 p_new_ATTRIBUTE8 in VARCHAR2,
146 p_old_ATTRIBUTE9 in VARCHAR2,
147 p_new_ATTRIBUTE9 in VARCHAR2,
148 p_old_ATTRIBUTE10 in VARCHAR2,
149 p_new_ATTRIBUTE10 in VARCHAR2,
150 p_old_ATTRIBUTE11 in VARCHAR2,
151 p_new_ATTRIBUTE11 in VARCHAR2,
152 p_old_ATTRIBUTE12 in VARCHAR2,
153 p_new_ATTRIBUTE12 in VARCHAR2,
154 p_old_ATTRIBUTE13 in VARCHAR2,
155 p_new_ATTRIBUTE13 in VARCHAR2,
156 p_old_ATTRIBUTE14 in VARCHAR2,
157 p_new_ATTRIBUTE14 in VARCHAR2,
158 p_old_ATTRIBUTE15 in VARCHAR2,
159 p_new_ATTRIBUTE15 in VARCHAR2,
160 p_old_ATTRIBUTE16 in VARCHAR2,
161 p_new_ATTRIBUTE16 in VARCHAR2,
162 p_old_ATTRIBUTE17 in VARCHAR2,
163 p_new_ATTRIBUTE17 in VARCHAR2,
164 p_old_ATTRIBUTE18 in VARCHAR2,
165 p_new_ATTRIBUTE18 in VARCHAR2,
166 p_old_ATTRIBUTE19 in VARCHAR2,
167 p_new_ATTRIBUTE19 in VARCHAR2,
168 p_old_ATTRIBUTE20 in VARCHAR2,
169 p_new_ATTRIBUTE20 in VARCHAR2,
170 p_old_ATTRIBUTE_CATEGORY in VARCHAR2,
171 p_new_ATTRIBUTE_CATEGORY in VARCHAR2,
172 p_old_BUSINESS_GROUP_ID in NUMBER,
173 p_new_BUSINESS_GROUP_ID in NUMBER,
174 p_old_COMMENTS in VARCHAR2,
175 p_new_COMMENTS in VARCHAR2,
176 p_old_GROUP_DATE in DATE,
177 p_new_GROUP_DATE in DATE,
178 p_old_GROUP_INITIATOR_ID in NUMBER,
179 p_new_GROUP_INITIATOR_ID in NUMBER,
180 p_old_NEXT_APPRAISAL_DATE in DATE,
181 p_new_NEXT_APPRAISAL_DATE in DATE,
182 p_old_OPEN in VARCHAR2,
183 p_new_OPEN in VARCHAR2,
184 p_old_OVERALL_PERFORMANCE_LEVE in NUMBER,
185 p_new_OVERALL_PERFORMANCE_LEVE in NUMBER,
186 p_old_STATUS in VARCHAR2,
187 p_new_STATUS in VARCHAR2,
188 p_old_TYPE in VARCHAR2,
189 p_new_TYPE in VARCHAR2,
190 p_old_APPRAISAL_DATE in DATE,
191 p_new_APPRAISAL_DATE in DATE,
192 --
193 -- Added by vikash
194 --
195 p_new_SYSTEM_TYPE in VARCHAR2,
196 p_old_SYSTEM_TYPE in VARCHAR2,
197 p_new_APPRAISAL_SYSTEM_STATUS in VARCHAR2,
198 p_old_APPRAISAL_SYSTEM_STATUS in VARCHAR2,
199 p_new_SYSTEM_PARAMS in VARCHAR2,
200 p_old_SYSTEM_PARAMS in VARCHAR2,
201 p_new_APPRAISEE_ACCESS in VARCHAR2,
202 p_old_APPRAISEE_ACCESS in VARCHAR2,
203 p_new_MAIN_APPRAISER_ID in NUMBER,
204 p_old_MAIN_APPRAISER_ID in NUMBER,
205 p_new_ASSIGNMENT_ID in NUMBER,
206 p_old_ASSIGNMENT_ID in NUMBER,
207 p_new_ASSIGNMENT_START_DATE in DATE,
208 p_old_ASSIGNMENT_START_DATE in DATE,
209 p_new_ASG_BUSINESS_GROUP_ID in NUMBER,
210 p_old_ASG_BUSINESS_GROUP_ID in NUMBER,
211 p_new_ASG_ORGANIZATION_ID in NUMBER,
212 p_old_ASG_ORGANIZATION_ID in NUMBER,
213 p_new_ASSIGNMENT_JOB_ID in NUMBER,
214 p_old_ASSIGNMENT_JOB_ID in NUMBER,
215 p_new_ASSIGNMENT_POSITION_ID in NUMBER,
216 p_old_ASSIGNMENT_POSITION_ID in NUMBER,
217 p_new_ASSIGNMENT_GRADE_ID in NUMBER,
218 p_old_ASSIGNMENT_GRADE_ID in NUMBER,
219 p_new_PTNTL_READINESS_LEVEL in VARCHAR2,
220 p_old_PTNTL_READINESS_LEVEL in VARCHAR2,
221 p_new_PTNTL_SHORT_TERM_WORKOPP in VARCHAR2,
222 p_old_PTNTL_SHORT_TERM_WORKOPP in VARCHAR2,
223 p_new_PTNTL_LONG_TERM_WORKOPP in VARCHAR2,
224 p_old_PTNTL_LONG_TERM_WORKOPP in VARCHAR2,
225 p_new_POTENTIAL_DETAILS in VARCHAR2,
226 p_old_POTENTIAL_DETAILS in VARCHAR2,
227 p_new_EVENT_ID in NUMBER,
228 p_old_EVENT_ID in NUMBER
229 );
230
231 --
232 procedure per_appraisals_ard(
233 p_business_group_id in number,
234 p_legislation_code in varchar2,
235 p_appraisee_person_id in number,
236 p_effective_start_date in date,
237 p_appraisal_id in number
238 );
239 --
240 PROCEDURE per_person_type_usages_f_ari( p_business_group_id in number,
241 p_legislation_code in varchar2,
242 p_person_id in number,
243 p_person_type_usage_id in number,
244 p_effective_start_date in date
245 );
246 --
247 PROCEDURE per_person_type_usages_f_aru(
248 p_business_group_id in number,
249 p_legislation_code in varchar2,
250 p_effective_date in date,
251 p_old_ATTRIBUTE1 in VARCHAR2,
252 p_new_ATTRIBUTE1 in VARCHAR2,
253 p_old_ATTRIBUTE2 in VARCHAR2,
254 p_new_ATTRIBUTE2 in VARCHAR2,
255 p_old_ATTRIBUTE3 in VARCHAR2,
256 p_new_ATTRIBUTE3 in VARCHAR2,
257 p_old_ATTRIBUTE4 in VARCHAR2,
258 p_new_ATTRIBUTE4 in VARCHAR2,
259 p_old_ATTRIBUTE5 in VARCHAR2,
260 p_new_ATTRIBUTE5 in VARCHAR2,
261 p_old_ATTRIBUTE6 in VARCHAR2,
262 p_new_ATTRIBUTE6 in VARCHAR2,
263 p_old_ATTRIBUTE7 in VARCHAR2,
264 p_new_ATTRIBUTE7 in VARCHAR2,
265 p_old_ATTRIBUTE8 in VARCHAR2,
266 p_new_ATTRIBUTE8 in VARCHAR2,
267 p_old_ATTRIBUTE9 in VARCHAR2,
268 p_new_ATTRIBUTE9 in VARCHAR2,
269 p_old_ATTRIBUTE10 in VARCHAR2,
270 p_new_ATTRIBUTE10 in VARCHAR2,
271 p_old_ATTRIBUTE11 in VARCHAR2,
272 p_new_ATTRIBUTE11 in VARCHAR2,
273 p_old_ATTRIBUTE12 in VARCHAR2,
274 p_new_ATTRIBUTE12 in VARCHAR2,
275 p_old_ATTRIBUTE13 in VARCHAR2,
276 p_new_ATTRIBUTE13 in VARCHAR2,
277 p_old_ATTRIBUTE14 in VARCHAR2,
278 p_new_ATTRIBUTE14 in VARCHAR2,
279 p_old_ATTRIBUTE15 in VARCHAR2,
280 p_new_ATTRIBUTE15 in VARCHAR2,
281 p_old_ATTRIBUTE16 in VARCHAR2,
282 p_new_ATTRIBUTE16 in VARCHAR2,
283 p_old_ATTRIBUTE17 in VARCHAR2,
284 p_new_ATTRIBUTE17 in VARCHAR2,
285 p_old_ATTRIBUTE18 in VARCHAR2,
286 p_new_ATTRIBUTE18 in VARCHAR2,
287 p_old_ATTRIBUTE19 in VARCHAR2,
288 p_new_ATTRIBUTE19 in VARCHAR2,
289 p_old_ATTRIBUTE20 in VARCHAR2,
290 p_new_ATTRIBUTE20 in VARCHAR2,
291 p_old_ATTRIBUTE_CATEGORY in VARCHAR2,
292 p_new_ATTRIBUTE_CATEGORY in VARCHAR2,
293 p_old_PERSON_ID in NUMBER,
294 p_new_PERSON_ID in NUMBER,
295 p_old_PERSON_TYPE_ID in NUMBER,
296 p_new_PERSON_TYPE_ID in NUMBER,
297 p_old_PERSON_TYPE_USAGE_ID in NUMBER,
298 p_new_PERSON_TYPE_USAGE_ID in NUMBER,
299 p_old_PROGRAM_APPLICATION_ID in NUMBER,
300 p_new_PROGRAM_APPLICATION_ID in NUMBER,
301 p_old_PROGRAM_ID in NUMBER,
302 p_new_PROGRAM_ID in NUMBER,
303 p_old_PROGRAM_UPDATE_DATE in DATE,
304 p_new_PROGRAM_UPDATE_DATE in DATE,
305 p_old_REQUEST_ID in NUMBER,
306 p_new_REQUEST_ID in NUMBER,
307 p_old_EFFECTIVE_END_DATE in DATE,
308 p_new_EFFECTIVE_END_DATE in DATE,
309 p_old_EFFECTIVE_START_DATE in DATE,
310 p_new_EFFECTIVE_START_DATE in DATE);
311 --
312 PROCEDURE per_person_type_usages_f_ard(
313 p_business_group_id in number,
314 p_legislation_code in varchar2,
315 p_person_id in number,
316 p_effective_start_date in date,
317 p_person_type_usage_id in number);
318 --
319 procedure PER_ASSIGNMENT_EXTRA_INFO_aru(
320 p_business_group_id in number,
321 p_legislation_code in varchar2,
322 p_effective_date in date ,
323 p_old_AEI_ATTRIBUTE1 in VARCHAR2,
324 p_new_AEI_ATTRIBUTE1 in VARCHAR2 ,
325 p_old_AEI_ATTRIBUTE10 in VARCHAR2,
326 p_new_AEI_ATTRIBUTE10 in VARCHAR2 ,
327 p_old_AEI_ATTRIBUTE11 in VARCHAR2,
328 p_new_AEI_ATTRIBUTE11 in VARCHAR2 ,
329 p_old_AEI_ATTRIBUTE12 in VARCHAR2,
330 p_new_AEI_ATTRIBUTE12 in VARCHAR2 ,
331 p_old_AEI_ATTRIBUTE13 in VARCHAR2,
332 p_new_AEI_ATTRIBUTE13 in VARCHAR2 ,
333 p_old_AEI_ATTRIBUTE14 in VARCHAR2,
334 p_new_AEI_ATTRIBUTE14 in VARCHAR2 ,
335 p_old_AEI_ATTRIBUTE15 in VARCHAR2,
336 p_new_AEI_ATTRIBUTE15 in VARCHAR2 ,
337 p_old_AEI_ATTRIBUTE16 in VARCHAR2,
338 p_new_AEI_ATTRIBUTE16 in VARCHAR2 ,
339 p_old_AEI_ATTRIBUTE17 in VARCHAR2,
340 p_new_AEI_ATTRIBUTE17 in VARCHAR2 ,
341 p_old_AEI_ATTRIBUTE18 in VARCHAR2,
342 p_new_AEI_ATTRIBUTE18 in VARCHAR2 ,
343 p_old_AEI_ATTRIBUTE19 in VARCHAR2,
344 p_new_AEI_ATTRIBUTE19 in VARCHAR2 ,
345 p_old_AEI_ATTRIBUTE2 in VARCHAR2,
346 p_new_AEI_ATTRIBUTE2 in VARCHAR2 ,
347 p_old_AEI_ATTRIBUTE20 in VARCHAR2,
348 p_new_AEI_ATTRIBUTE20 in VARCHAR2 ,
349 p_old_AEI_ATTRIBUTE3 in VARCHAR2,
350 p_new_AEI_ATTRIBUTE3 in VARCHAR2 ,
351 p_old_AEI_ATTRIBUTE4 in VARCHAR2,
352 p_new_AEI_ATTRIBUTE4 in VARCHAR2 ,
353 p_old_AEI_ATTRIBUTE5 in VARCHAR2,
354 p_new_AEI_ATTRIBUTE5 in VARCHAR2 ,
355 p_old_AEI_ATTRIBUTE6 in VARCHAR2,
356 p_new_AEI_ATTRIBUTE6 in VARCHAR2 ,
357 p_old_AEI_ATTRIBUTE7 in VARCHAR2,
358 p_new_AEI_ATTRIBUTE7 in VARCHAR2 ,
359 p_old_AEI_ATTRIBUTE8 in VARCHAR2,
360 p_new_AEI_ATTRIBUTE8 in VARCHAR2 ,
361 p_old_AEI_ATTRIBUTE9 in VARCHAR2,
362 p_new_AEI_ATTRIBUTE9 in VARCHAR2 ,
363 p_old_AEI_ATTRIBUTE_CATEGORY in VARCHAR2,
364 p_new_AEI_ATTRIBUTE_CATEGORY in VARCHAR2 ,
365 p_old_AEI_INFORMATION1 in VARCHAR2,
366 p_new_AEI_INFORMATION1 in VARCHAR2 ,
367 p_old_AEI_INFORMATION10 in VARCHAR2,
368 p_new_AEI_INFORMATION10 in VARCHAR2 ,
369 p_old_AEI_INFORMATION11 in VARCHAR2,
370 p_new_AEI_INFORMATION11 in VARCHAR2 ,
371 p_old_AEI_INFORMATION12 in VARCHAR2,
372 p_new_AEI_INFORMATION12 in VARCHAR2 ,
373 p_old_AEI_INFORMATION13 in VARCHAR2,
374 p_new_AEI_INFORMATION13 in VARCHAR2 ,
375 p_old_AEI_INFORMATION14 in VARCHAR2,
376 p_new_AEI_INFORMATION14 in VARCHAR2 ,
377 p_old_AEI_INFORMATION15 in VARCHAR2,
378 p_new_AEI_INFORMATION15 in VARCHAR2 ,
379 p_old_AEI_INFORMATION16 in VARCHAR2,
380 p_new_AEI_INFORMATION16 in VARCHAR2 ,
381 p_old_AEI_INFORMATION17 in VARCHAR2,
382 p_new_AEI_INFORMATION17 in VARCHAR2 ,
383 p_old_AEI_INFORMATION18 in VARCHAR2,
384 p_new_AEI_INFORMATION18 in VARCHAR2 ,
385 p_old_AEI_INFORMATION19 in VARCHAR2,
386 p_new_AEI_INFORMATION19 in VARCHAR2 ,
387 p_old_AEI_INFORMATION2 in VARCHAR2,
388 p_new_AEI_INFORMATION2 in VARCHAR2 ,
389 p_old_AEI_INFORMATION20 in VARCHAR2,
390 p_new_AEI_INFORMATION20 in VARCHAR2 ,
391 p_old_AEI_INFORMATION21 in VARCHAR2,
392 p_new_AEI_INFORMATION21 in VARCHAR2 ,
393 p_old_AEI_INFORMATION22 in VARCHAR2,
394 p_new_AEI_INFORMATION22 in VARCHAR2 ,
395 p_old_AEI_INFORMATION23 in VARCHAR2,
396 p_new_AEI_INFORMATION23 in VARCHAR2 ,
397 p_old_AEI_INFORMATION24 in VARCHAR2,
398 p_new_AEI_INFORMATION24 in VARCHAR2 ,
399 p_old_AEI_INFORMATION25 in VARCHAR2,
400 p_new_AEI_INFORMATION25 in VARCHAR2 ,
401 p_old_AEI_INFORMATION26 in VARCHAR2,
402 p_new_AEI_INFORMATION26 in VARCHAR2 ,
403 p_old_AEI_INFORMATION27 in VARCHAR2,
404 p_new_AEI_INFORMATION27 in VARCHAR2 ,
405 p_old_AEI_INFORMATION28 in VARCHAR2,
406 p_new_AEI_INFORMATION28 in VARCHAR2 ,
407 p_old_AEI_INFORMATION29 in VARCHAR2,
408 p_new_AEI_INFORMATION29 in VARCHAR2 ,
409 p_old_AEI_INFORMATION3 in VARCHAR2,
410 p_new_AEI_INFORMATION3 in VARCHAR2 ,
411 p_old_AEI_INFORMATION30 in VARCHAR2,
412 p_new_AEI_INFORMATION30 in VARCHAR2 ,
413 p_old_AEI_INFORMATION4 in VARCHAR2,
414 p_new_AEI_INFORMATION4 in VARCHAR2 ,
415 p_old_AEI_INFORMATION5 in VARCHAR2,
416 p_new_AEI_INFORMATION5 in VARCHAR2 ,
417 p_old_AEI_INFORMATION6 in VARCHAR2,
418 p_new_AEI_INFORMATION6 in VARCHAR2 ,
419 p_old_AEI_INFORMATION7 in VARCHAR2,
420 p_new_AEI_INFORMATION7 in VARCHAR2 ,
421 p_old_AEI_INFORMATION8 in VARCHAR2,
422 p_new_AEI_INFORMATION8 in VARCHAR2 ,
423 p_old_AEI_INFORMATION9 in VARCHAR2,
424 p_new_AEI_INFORMATION9 in VARCHAR2 ,
425 p_old_AEI_INFORMATION_CATEGORY in VARCHAR2,
426 p_new_AEI_INFORMATION_CATEGORY in VARCHAR2 ,
427 p_old_ASSIGNMENT_EXTRA_INFO_ID in NUMBER,
428 p_new_ASSIGNMENT_EXTRA_INFO_ID in NUMBER ,
429 p_old_ASSIGNMENT_ID in NUMBER,
430 p_new_ASSIGNMENT_ID in NUMBER ,
431 p_old_INFORMATION_TYPE in VARCHAR2,
432 p_new_INFORMATION_TYPE in VARCHAR2
433 );
434 --
435 PROCEDURE PER_ASSIGNMENT_EXTRA_INFO_ard(
436 p_business_group_id in number,
437 p_legislation_code in varchar2,
438 p_assignment_id in number,
439 p_effective_start_date in date,
440 p_assignment_extra_info_id in number);
441 --
442 PROCEDURE PER_ASSIGNMENT_EXTRA_INFO_ari( p_business_group_id in number,
443 p_legislation_code in varchar2,
444 p_assignment_id in number,
445 p_assignment_extra_info_id in number,
446 p_effective_start_date in date
447 );
448 --
449 procedure PER_PERIODS_OF_PLACEMENT_aru(
450 p_business_group_id in number,
451 p_legislation_code in varchar2,
452 p_effective_date in date,
453 p_old_ACTUAL_TERMINATION_DATE in DATE,
454 p_new_ACTUAL_TERMINATION_DATE in DATE,
455 p_old_ATTRIBUTE1 in VARCHAR2,
456 p_new_ATTRIBUTE1 in VARCHAR2,
457 p_old_ATTRIBUTE10 in VARCHAR2,
458 p_new_ATTRIBUTE10 in VARCHAR2,
459 p_old_ATTRIBUTE11 in VARCHAR2,
460 p_new_ATTRIBUTE11 in VARCHAR2,
461 p_old_ATTRIBUTE12 in VARCHAR2,
462 p_new_ATTRIBUTE12 in VARCHAR2,
463 p_old_ATTRIBUTE13 in VARCHAR2,
464 p_new_ATTRIBUTE13 in VARCHAR2,
465 p_old_ATTRIBUTE14 in VARCHAR2,
466 p_new_ATTRIBUTE14 in VARCHAR2,
467 p_old_ATTRIBUTE15 in VARCHAR2,
468 p_new_ATTRIBUTE15 in VARCHAR2,
469 p_old_ATTRIBUTE16 in VARCHAR2,
470 p_new_ATTRIBUTE16 in VARCHAR2,
471 p_old_ATTRIBUTE17 in VARCHAR2,
472 p_new_ATTRIBUTE17 in VARCHAR2,
473 p_old_ATTRIBUTE18 in VARCHAR2,
474 p_new_ATTRIBUTE18 in VARCHAR2,
475 p_old_ATTRIBUTE19 in VARCHAR2,
476 p_new_ATTRIBUTE19 in VARCHAR2,
477 p_old_ATTRIBUTE2 in VARCHAR2,
478 p_new_ATTRIBUTE2 in VARCHAR2,
479 p_old_ATTRIBUTE20 in VARCHAR2,
480 p_new_ATTRIBUTE20 in VARCHAR2,
481 p_old_ATTRIBUTE21 in VARCHAR2,
482 p_new_ATTRIBUTE21 in VARCHAR2,
483 p_old_ATTRIBUTE22 in VARCHAR2,
484 p_new_ATTRIBUTE22 in VARCHAR2,
485 p_old_ATTRIBUTE23 in VARCHAR2,
486 p_new_ATTRIBUTE23 in VARCHAR2,
487 p_old_ATTRIBUTE24 in VARCHAR2,
488 p_new_ATTRIBUTE24 in VARCHAR2,
489 p_old_ATTRIBUTE25 in VARCHAR2,
490 p_new_ATTRIBUTE25 in VARCHAR2,
491 p_old_ATTRIBUTE26 in VARCHAR2,
492 p_new_ATTRIBUTE26 in VARCHAR2,
493 p_old_ATTRIBUTE27 in VARCHAR2,
494 p_new_ATTRIBUTE27 in VARCHAR2,
495 p_old_ATTRIBUTE28 in VARCHAR2,
496 p_new_ATTRIBUTE28 in VARCHAR2,
497 p_old_ATTRIBUTE29 in VARCHAR2,
498 p_new_ATTRIBUTE29 in VARCHAR2,
499 p_old_ATTRIBUTE3 in VARCHAR2,
500 p_new_ATTRIBUTE3 in VARCHAR2,
501 p_old_ATTRIBUTE30 in VARCHAR2,
502 p_new_ATTRIBUTE30 in VARCHAR2,
503 p_old_ATTRIBUTE4 in VARCHAR2,
504 p_new_ATTRIBUTE4 in VARCHAR2,
505 p_old_ATTRIBUTE5 in VARCHAR2,
506 p_new_ATTRIBUTE5 in VARCHAR2,
507 p_old_ATTRIBUTE6 in VARCHAR2,
508 p_new_ATTRIBUTE6 in VARCHAR2,
509 p_old_ATTRIBUTE7 in VARCHAR2,
510 p_new_ATTRIBUTE7 in VARCHAR2,
511 p_old_ATTRIBUTE8 in VARCHAR2,
512 p_new_ATTRIBUTE8 in VARCHAR2,
513 p_old_ATTRIBUTE9 in VARCHAR2,
514 p_new_ATTRIBUTE9 in VARCHAR2,
515 p_old_ATTRIBUTE_CATEGORY in VARCHAR2,
516 p_new_ATTRIBUTE_CATEGORY in VARCHAR2,
517 p_old_BUSINESS_GROUP_ID in NUMBER,
518 p_new_BUSINESS_GROUP_ID in NUMBER,
519 p_old_FINAL_PROCESS_DATE in DATE,
520 p_new_FINAL_PROCESS_DATE in DATE,
521 p_old_INFORMATION1 in VARCHAR2,
522 p_new_INFORMATION1 in VARCHAR2,
523 p_old_INFORMATION10 in VARCHAR2,
524 p_new_INFORMATION10 in VARCHAR2,
525 p_old_INFORMATION11 in VARCHAR2,
526 p_new_INFORMATION11 in VARCHAR2,
527 p_old_INFORMATION12 in VARCHAR2,
528 p_new_INFORMATION12 in VARCHAR2,
529 p_old_INFORMATION13 in VARCHAR2,
530 p_new_INFORMATION13 in VARCHAR2,
531 p_old_INFORMATION14 in VARCHAR2,
532 p_new_INFORMATION14 in VARCHAR2,
533 p_old_INFORMATION15 in VARCHAR2,
534 p_new_INFORMATION15 in VARCHAR2,
535 p_old_INFORMATION16 in VARCHAR2,
536 p_new_INFORMATION16 in VARCHAR2,
537 p_old_INFORMATION17 in VARCHAR2,
538 p_new_INFORMATION17 in VARCHAR2,
539 p_old_INFORMATION18 in VARCHAR2,
540 p_new_INFORMATION18 in VARCHAR2,
541 p_old_INFORMATION19 in VARCHAR2,
542 p_new_INFORMATION19 in VARCHAR2,
543 p_old_INFORMATION2 in VARCHAR2,
544 p_new_INFORMATION2 in VARCHAR2,
545 p_old_INFORMATION20 in VARCHAR2,
546 p_new_INFORMATION20 in VARCHAR2,
547 p_old_INFORMATION21 in VARCHAR2,
548 p_new_INFORMATION21 in VARCHAR2,
549 p_old_INFORMATION22 in VARCHAR2,
550 p_new_INFORMATION22 in VARCHAR2,
551 p_old_INFORMATION23 in VARCHAR2,
552 p_new_INFORMATION23 in VARCHAR2,
553 p_old_INFORMATION24 in VARCHAR2,
554 p_new_INFORMATION24 in VARCHAR2,
555 p_old_INFORMATION25 in VARCHAR2,
556 p_new_INFORMATION25 in VARCHAR2,
557 p_old_INFORMATION26 in VARCHAR2,
558 p_new_INFORMATION26 in VARCHAR2,
559 p_old_INFORMATION27 in VARCHAR2,
560 p_new_INFORMATION27 in VARCHAR2,
561 p_old_INFORMATION28 in VARCHAR2,
562 p_new_INFORMATION28 in VARCHAR2,
563 p_old_INFORMATION29 in VARCHAR2,
564 p_new_INFORMATION29 in VARCHAR2,
565 p_old_INFORMATION3 in VARCHAR2,
566 p_new_INFORMATION3 in VARCHAR2,
567 p_old_INFORMATION30 in VARCHAR2,
568 p_new_INFORMATION30 in VARCHAR2,
572 p_new_INFORMATION5 in VARCHAR2,
569 p_old_INFORMATION4 in VARCHAR2,
570 p_new_INFORMATION4 in VARCHAR2,
571 p_old_INFORMATION5 in VARCHAR2,
573 p_old_INFORMATION6 in VARCHAR2,
574 p_new_INFORMATION6 in VARCHAR2,
575 p_old_INFORMATION7 in VARCHAR2,
576 p_new_INFORMATION7 in VARCHAR2,
577 p_old_INFORMATION8 in VARCHAR2,
578 p_new_INFORMATION8 in VARCHAR2,
579 p_old_INFORMATION9 in VARCHAR2,
580 p_new_INFORMATION9 in VARCHAR2,
581 p_old_INFORMATION_CATEGORY in VARCHAR2,
582 p_new_INFORMATION_CATEGORY in VARCHAR2,
583 p_old_LAST_STANDARD_PROCESS_DA in DATE,
584 p_new_LAST_STANDARD_PROCESS_DA in DATE,
585 p_old_PERIOD_OF_PLACEMENT_ID in NUMBER,
586 p_new_PERIOD_OF_PLACEMENT_ID in NUMBER,
587 p_old_PERSON_ID in NUMBER,
588 p_new_PERSON_ID in NUMBER,
589 p_old_PROJECTED_TERMINATION_DA in DATE,
590 p_new_PROJECTED_TERMINATION_DA in DATE,
591 p_old_TERMINATION_REASON in VARCHAR2,
592 p_new_TERMINATION_REASON in VARCHAR2,
593 p_old_DATE_START in DATE,
594 p_new_DATE_START in DATE
595 );
596 --
597 procedure PER_ABSENCE_ATTENDANCES_aru(
598 p_business_group_id in number,
599 p_legislation_code in varchar2,
600 p_effective_date in date,
601 p_old_ABSENCE_ATTENDANCE_ID in NUMBER,
602 p_new_ABSENCE_ATTENDANCE_ID in NUMBER,
603 p_old_PERSON_ID in NUMBER,
604 p_new_PERSON_ID in NUMBER,
605 p_old_ABS_ATTENDANCE_REASON_ID in NUMBER,
606 p_new_ABS_ATTENDANCE_REASON_ID in NUMBER,
607 p_old_AUTHORISING_PERSON_ID in NUMBER,
608 p_new_AUTHORISING_PERSON_ID in NUMBER,
609 p_old_REPLACEMENT_PERSON_ID in NUMBER,
610 p_new_REPLACEMENT_PERSON_ID in NUMBER,
611 p_old_PERIOD_OF_INCAPACITY_ID in NUMBER,
612 p_new_PERIOD_OF_INCAPACITY_ID in NUMBER,
613 p_old_ABSENCE_DAYS in NUMBER,
614 p_new_ABSENCE_DAYS in NUMBER,
615 p_old_ABSENCE_HOURS in NUMBER,
616 p_new_ABSENCE_HOURS in NUMBER,
617 p_old_DATE_END in DATE,
618 p_new_DATE_END in DATE,
619 p_old_DATE_NOTIFICATION in DATE,
620 p_new_DATE_NOTIFICATION in DATE,
621 p_old_DATE_PROJECTED_END in DATE,
622 p_new_DATE_PROJECTED_END in DATE,
623 p_old_DATE_PROJECTED_START in DATE,
624 p_new_DATE_PROJECTED_START in DATE,
625 p_old_DATE_START in DATE,
626 p_new_DATE_START in DATE,
627 p_old_SSP1_ISSUED in VARCHAR2,
628 p_new_SSP1_ISSUED in VARCHAR2,
629 p_old_TIME_END in VARCHAR2,
630 p_new_TIME_END in VARCHAR2,
631 p_old_TIME_PROJECTED_END in VARCHAR2,
632 p_new_TIME_PROJECTED_END in VARCHAR2,
633 p_old_TIME_PROJECTED_START in VARCHAR2,
634 p_new_TIME_PROJECTED_START in VARCHAR2,
635 p_old_TIME_START in VARCHAR2,
636 p_new_TIME_START in VARCHAR2,
637 p_old_MATERNITY_ID in NUMBER,
638 p_new_MATERNITY_ID in NUMBER,
639 p_old_SICKNESS_START_DATE in DATE,
640 p_new_SICKNESS_START_DATE in DATE,
641 p_old_SICKNESS_END_DATE in DATE,
642 p_new_SICKNESS_END_DATE in DATE,
643 p_old_LINKED_ABSENCE_ID in NUMBER,
644 p_new_LINKED_ABSENCE_ID in NUMBER,
645 p_old_ATTRIBUTE1 in VARCHAR2,
646 p_new_ATTRIBUTE1 in VARCHAR2,
647 p_old_ATTRIBUTE2 in VARCHAR2,
648 p_new_ATTRIBUTE2 in VARCHAR2,
649 p_old_ATTRIBUTE3 in VARCHAR2,
650 p_new_ATTRIBUTE3 in VARCHAR2,
651 p_old_ATTRIBUTE4 in VARCHAR2,
652 p_new_ATTRIBUTE4 in VARCHAR2,
653 p_old_ATTRIBUTE5 in VARCHAR2,
654 p_new_ATTRIBUTE5 in VARCHAR2,
655 p_old_ATTRIBUTE6 in VARCHAR2,
656 p_new_ATTRIBUTE6 in VARCHAR2,
657 p_old_ATTRIBUTE7 in VARCHAR2,
658 p_new_ATTRIBUTE7 in VARCHAR2,
659 p_old_ATTRIBUTE8 in VARCHAR2,
660 p_new_ATTRIBUTE8 in VARCHAR2,
661 p_old_ATTRIBUTE9 in VARCHAR2,
662 p_new_ATTRIBUTE9 in VARCHAR2,
663 p_old_ATTRIBUTE10 in VARCHAR2,
664 p_new_ATTRIBUTE10 in VARCHAR2,
665 p_old_ATTRIBUTE11 in VARCHAR2,
666 p_new_ATTRIBUTE11 in VARCHAR2,
667 p_old_ATTRIBUTE12 in VARCHAR2,
668 p_new_ATTRIBUTE12 in VARCHAR2,
669 p_old_ATTRIBUTE13 in VARCHAR2,
670 p_new_ATTRIBUTE13 in VARCHAR2,
671 p_old_ATTRIBUTE14 in VARCHAR2,
672 p_new_ATTRIBUTE14 in VARCHAR2,
673 p_old_ATTRIBUTE15 in VARCHAR2,
674 p_new_ATTRIBUTE15 in VARCHAR2,
675 p_old_ATTRIBUTE16 in VARCHAR2,
676 p_new_ATTRIBUTE16 in VARCHAR2,
677 p_old_ATTRIBUTE17 in VARCHAR2,
678 p_new_ATTRIBUTE17 in VARCHAR2,
679 p_old_ATTRIBUTE18 in VARCHAR2,
680 p_new_ATTRIBUTE18 in VARCHAR2,
681 p_old_ATTRIBUTE19 in VARCHAR2,
682 p_new_ATTRIBUTE19 in VARCHAR2,
683 p_old_ATTRIBUTE20 in VARCHAR2,
684 p_new_ATTRIBUTE20 in VARCHAR2,
685 p_old_ATTRIBUTE_CATEGORY in VARCHAR2,
686 p_new_ATTRIBUTE_CATEGORY in VARCHAR2
687 );
688 --
689 procedure PER_ABSENCE_ATTENDANCES_ari
690 (p_business_group_id in number,
691 p_legislation_code in varchar2,
692 p_person_id in number,
693 p_absence_attendance_id in number,
694 p_effective_start_date in date);
695 --
696 procedure PER_ABSENCE_ATTENDANCES_ard
697 (p_business_group_id in number,
698 p_legislation_code in varchar2,
699 p_person_id in number,
700 p_effective_start_date in date,
701 p_absence_attendance_id in number);
702
703
704 procedure PQP_GAP_DURATION_SUMMARY_ari
705 (p_business_group_id in number ,
706 p_legislation_code in varchar2,
707 p_assignment_id in number,
708 p_gap_duration_summary_id in number,
709 p_effective_start_date in date);
710 --
711
712 procedure PQP_GAP_DURATION_SUMMARY_aru(
713 p_business_group_id IN NUMBER,
714 p_legislation_code IN VARCHAR2,
715 P_GAP_DURATION_SUMMARY_ID IN NUMBER,
716 P_ASSIGNMENT_ID IN NUMBER,
717 p_new_DURATION_IN_DAYS IN NUMBER,
718 p_old_DURATION_IN_DAYS IN NUMBER,
719 p_new_DURATION_IN_HOURS IN NUMBER,
720 p_old_DURATION_IN_HOURS IN NUMBER,
721 p_new_DATE_END IN DATE,
722 p_old_DATE_END IN DATE,
723 p_new_DATE_START IN DATE,
724 p_old_DATE_START IN DATE,
725 p_effective_date IN DATE
726 );
727 --
728 procedure PQP_GAP_DURATION_SUMMARY_ard
729 (p_business_group_id IN NUMBER,
730 p_legislation_code IN VARCHAR2,
731 P_GAP_DURATION_SUMMARY_ID IN NUMBER,
732 P_ASSIGNMENT_ID IN NUMBER,
733 p_effective_start_date IN DATE
734 );
735 --
736 end PAY_MISC_DYT_INCIDENT_PKG;