DBA Data[Home] [Help]

PACKAGE: APPS.PAY_MISC_DYT_INCIDENT_PKG

Source


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;