1 PACKAGE PAY_SE_ABSENCE_USER AUTHID CURRENT_USER AS
2 /*$Header: pyseabsence.pkh 120.1 2007/06/28 13:19:02 rravi noship $*/
3 Function Element_populate (p_assignment_id in number,
4 p_person_id in number,
5 p_absence_attendance_id in number,
6 p_element_type_id in number,
7 p_absence_category in varchar2,
8 p_original_entry_id OUT NOCOPY NUMBER,
9 p_input_value_name1 OUT NOCOPY VARCHAR2,
10 p_input_value1 OUT NOCOPY VARCHAR2,
11 p_input_value_name2 OUT NOCOPY VARCHAR2,
12 p_input_value2 OUT NOCOPY VARCHAR2,
13 p_input_value_name3 OUT NOCOPY VARCHAR2,
14 p_input_value3 OUT NOCOPY VARCHAR2,
15 p_input_value_name4 OUT NOCOPY VARCHAR2,
16 p_input_value4 OUT NOCOPY VARCHAR2,
17 p_input_value_name5 OUT NOCOPY VARCHAR2,
18 p_input_value5 OUT NOCOPY VARCHAR2,
19 p_input_value_name6 OUT NOCOPY VARCHAR2,
20 p_input_value6 OUT NOCOPY VARCHAR2,
21 p_input_value_name7 OUT NOCOPY VARCHAR2,
22 p_input_value7 OUT NOCOPY VARCHAR2,
23 p_input_value_name8 OUT NOCOPY VARCHAR2,
24 p_input_value8 OUT NOCOPY VARCHAR2,
25 p_input_value_name9 OUT NOCOPY VARCHAR2,
26 p_input_value9 OUT NOCOPY VARCHAR2,
27 p_input_value_name10 OUT NOCOPY VARCHAR2,
28 p_input_value10 OUT NOCOPY VARCHAR2,
29 p_input_value_name11 OUT NOCOPY VARCHAR2,
30 p_input_value11 OUT NOCOPY VARCHAR2,
31 p_input_value_name12 OUT NOCOPY VARCHAR2,
32 p_input_value12 OUT NOCOPY VARCHAR2,
33 p_input_value_name13 OUT NOCOPY VARCHAR2,
34 p_input_value13 OUT NOCOPY VARCHAR2,
35 p_input_value_name14 OUT NOCOPY VARCHAR2,
36 p_input_value14 OUT NOCOPY VARCHAR2,
37 p_input_value_name15 OUT NOCOPY VARCHAR2,
38 p_input_value15 OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2;
39
40 PROCEDURE GET_WEEKEND_PUBLIC_HOLIDAYS(p_assignment_id in number,
41 P_START_DATE in varchar2,
42 P_END_DATE in varchar2,
43 p_start_time in varchar2,
44 p_end_time in varchar2,
45 p_weekends OUT NOCOPY NUMBER,
46 p_public_holidays OUT NOCOPY NUMBER,
47 p_Total_holidays OUT NOCOPY NUMBER
48 );
49
50 Function holiday_Element_populate (p_assignment_id in number,
51 p_person_id in number,
52 p_absence_attendance_id in number,
53 p_element_type_id in number,
54 p_absence_category in varchar2,
55 p_original_entry_id OUT NOCOPY NUMBER,
56 p_input_value_name1 OUT NOCOPY VARCHAR2,
57 p_input_value1 OUT NOCOPY VARCHAR2,
58 p_input_value_name2 OUT NOCOPY VARCHAR2,
59 p_input_value2 OUT NOCOPY VARCHAR2,
60 p_input_value_name3 OUT NOCOPY VARCHAR2,
61 p_input_value3 OUT NOCOPY VARCHAR2,
62 p_input_value_name4 OUT NOCOPY VARCHAR2,
63 p_input_value4 OUT NOCOPY VARCHAR2,
64 p_input_value_name5 OUT NOCOPY VARCHAR2,
65 p_input_value5 OUT NOCOPY VARCHAR2,
66 p_input_value_name6 OUT NOCOPY VARCHAR2,
67 p_input_value6 OUT NOCOPY VARCHAR2,
68 p_input_value_name7 OUT NOCOPY VARCHAR2,
69 p_input_value7 OUT NOCOPY VARCHAR2,
70 p_input_value_name8 OUT NOCOPY VARCHAR2,
71 p_input_value8 OUT NOCOPY VARCHAR2,
72 p_input_value_name9 OUT NOCOPY VARCHAR2,
73 p_input_value9 OUT NOCOPY VARCHAR2,
74 p_input_value_name10 OUT NOCOPY VARCHAR2,
75 p_input_value10 OUT NOCOPY VARCHAR2,
76 p_input_value_name11 OUT NOCOPY VARCHAR2,
77 p_input_value11 OUT NOCOPY VARCHAR2,
78 p_input_value_name12 OUT NOCOPY VARCHAR2,
79 p_input_value12 OUT NOCOPY VARCHAR2,
80 p_input_value_name13 OUT NOCOPY VARCHAR2,
81 p_input_value13 OUT NOCOPY VARCHAR2,
82 p_input_value_name14 OUT NOCOPY VARCHAR2,
83 p_input_value14 OUT NOCOPY VARCHAR2,
84 p_input_value_name15 OUT NOCOPY VARCHAR2,
85 p_input_value15 OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2;
86
87 FUNCTION GET_DAYS_WITH_ABS_PERCENTAGE(
88 p_date_earned in date,
89 p_tax_unit_id in Number,
90 p_assignment_action_id IN NUMBER,
91 p_assignment_id IN NUMBER,
92 p_business_group_id in NUMBER,
93 p_days IN NUMBER,
94 p_Absence_percentage IN Number,
95 p_category_code IN VARCHAR2
96 )
97
98 RETURN NUMBER;
99
100 FUNCTION CHECK_SICK_INTERUPTED(p_date_earned IN date,
101 p_assignment_id IN NUMBER,
102 p_tax_unit_id IN NUMBER,
103 p_business_group_id in NUMBER,
104 p_category_code IN VARCHAR2
105 )
106 RETURN VARCHAR2;
107 END PAY_SE_ABSENCE_USER;
108