1 PACKAGE PAY_FR_SICKNESS_ABSENCE AS
2 /* $Header: perfrabs.pkh 120.1.12000000.1 2007/01/22 03:13:59 appldev ship $ */
3 --
4 PROCEDURE PERSON_ABSENCE_CREATE(
5 p_business_group_id IN number
6 ,p_abs_information_category IN varchar2
7 ,p_person_id IN Number
8 ,p_date_start IN Date
9 ,p_date_end IN Date
10 ,p_abs_information1 IN Varchar2 default NULL
11 ,p_abs_information4 IN Varchar2 default NULL
12 ,p_abs_information5 IN Varchar2 default NULL
13 ,p_abs_information6 IN Varchar2 default NULL
14 ,p_abs_information7 IN Varchar2 default NULL
15 ,p_abs_information8 IN Varchar2 default NULL
16 ,p_abs_information9 IN Varchar2 default NULL
17 ,p_abs_information10 IN Varchar2 default NULL
18 ,p_abs_information11 IN Varchar2 default NULL
19 ,p_abs_information12 IN Varchar2 default NULL
20 );
21 --
22 procedure PERSON_ABSENCE_UPDATE(
23 p_absence_attendance_id IN Number
24 ,p_abs_information_category IN varchar2
25 ,p_date_start IN Date
26 ,p_date_end IN Date
27 ,p_abs_information1 IN Varchar2 default NULL
28 ,p_abs_information4 IN Varchar2 default NULL
29 ,p_abs_information5 IN Varchar2 default NULL
30 ,p_abs_information6 IN Varchar2 default NULL
31 ,p_abs_information7 IN Varchar2 default NULL
32 ,p_abs_information8 IN Varchar2 default NULL
33 ,p_abs_information9 IN Varchar2 default NULL
34 ,p_abs_information10 IN Varchar2 default NULL
35 ,p_abs_information11 IN Varchar2 default NULL
36 ,p_abs_information12 IN Varchar2 default NULL
37 );
38 --
39 procedure PERSON_ENTRY_CREATE(
40 p_business_group_id IN Number
41 ,p_absence_attendance_id IN Number
42 ,p_abs_information_category IN varchar2
43 ,p_date_start IN Date
44 );
45 --
46 procedure PERSON_ENTRY_UPDATE(
47 p_absence_attendance_id IN Number
48 ,p_abs_information_category IN varchar2
49 ,p_date_start IN Date
50 );
51 -- Added for additional holidays
52 PROCEDURE check_add_abs_ent_create(p_absence_days in number,
53 p_absence_attendance_type_id in number,
54 p_date_start in date,
55 p_person_id in number);
56 --
57 PROCEDURE check_add_abs_ent_update(p_absence_days in number,
58 p_absence_attendance_id in number,
59 p_date_start in date);
60
61
62
63 PROCEDURE CHK_TRG_CATG_HRS(
64 p_abs_information_category IN varchar2
65 ,p_abs_information1 IN Varchar2
66 -- added for bug#4104220
67 ,p_abs_information5 IN Varchar2
68 ,p_abs_information6 IN Varchar2
69 ,p_abs_information7 IN Varchar2
70 ,p_abs_information8 IN Varchar2
71 ,p_abs_information9 IN Varchar2
72 ,p_abs_information10 IN Varchar2
73 ,p_abs_information11 IN Varchar2
74 ,p_abs_information12 IN Varchar2
75 ,p_abs_information13 IN Varchar2
76 ,p_abs_information14 IN Varchar2
77 ,p_abs_information15 IN Varchar2
78 ,p_abs_information16 IN Varchar2
79 ,p_abs_information18 IN Varchar2
80 ,p_abs_information19 IN Varchar2
81 --
82 ,p_abs_information20 IN Varchar2
83 -- Added for bug 5218081
84 ,p_abs_information21 IN Varchar2
85 ,p_abs_information22 IN Varchar2
86 -- added for validating leave category
87 ,p_date_start IN Date);
88
89 --
90 END PAY_FR_SICKNESS_ABSENCE;