1 PACKAGE hr_loc_absence AS
2 /* $Header: hrabsloc.pkh 120.7 2007/04/11 11:28:32 saurai noship $ */
3
4 /* pgopal- Added p_original_entry_id parameter*/
5 procedure get_element_details
6 (p_absence_attendance_id in number
7 ,p_assignment_id in number
8 ,p_element_type_id out nocopy number
9 ,p_create_entry out nocopy varchar2
10 ,p_original_entry_id OUT NOCOPY NUMBER --gpopal
11 ,p_input_value_id1 out nocopy number
12 ,p_entry_value1 out nocopy VARCHAR2
13 ,p_input_value_id2 out nocopy number
14 ,p_entry_value2 out nocopy VARCHAR2
15 ,p_input_value_id3 out nocopy number
16 ,p_entry_value3 out nocopy VARCHAR2
17 ,p_input_value_id4 out nocopy number
18 ,p_entry_value4 out nocopy VARCHAR2
19 ,p_input_value_id5 out nocopy number
20 ,p_entry_value5 out nocopy VARCHAR2
21 ,p_input_value_id6 out nocopy number
22 ,p_entry_value6 out nocopy VARCHAR2
23 ,p_input_value_id7 out nocopy number
24 ,p_entry_value7 out nocopy VARCHAR2
25 ,p_input_value_id8 out nocopy number
26 ,p_entry_value8 out nocopy VARCHAR2
27 ,p_input_value_id9 out nocopy number
28 ,p_entry_value9 out nocopy VARCHAR2
29 ,p_input_value_id10 out nocopy number
30 ,p_entry_value10 out nocopy VARCHAR2
31 ,p_input_value_id11 out nocopy number
32 ,p_entry_value11 out nocopy VARCHAR2
33 ,p_input_value_id12 out nocopy number
34 ,p_entry_value12 out nocopy VARCHAR2
35 ,p_input_value_id13 out nocopy number
36 ,p_entry_value13 out nocopy VARCHAR2
37 ,p_input_value_id14 out nocopy number
38 ,p_entry_value14 out nocopy VARCHAR2
39 ,p_input_value_id15 out nocopy number
40 ,p_entry_value15 out nocopy VARCHAR2
41 );
42
43 PROCEDURE create_absence (p_absence_attendance_id NUMBER
44 ,p_effective_date DATE
45 ,p_date_start DATE
46 ,p_date_end DATE);
47
48 function get_element_for_category (p_absence_attendance_id NUMBER) return NUMBER;
49
50 function get_package_for_category (p_absence_attendance_id NUMBER) return VARCHAR2;
51
52 procedure get_absence_element
53 (p_absence_attendance_id in number
54 ,p_assignment_id in number
55 ,p_effective_date in date
56 ,p_processing_type out nocopy varchar2
57 ,p_element_entry_id out nocopy number
58 ,p_effective_start_date out nocopy date
59 ,p_effective_end_date out nocopy date);
60
61 procedure delete_absence_element
62 (p_dt_delete_mode in varchar2
63 ,p_session_date in date
64 ,p_element_entry_id in number
65 );
66
67 procedure update_absence_element
68 (p_dt_update_mode in varchar2
69 ,p_assignment_id in number
70 ,p_session_date in date
71 ,p_element_entry_id in number
72 ,p_absence_attendance_id in number
73 ) ;
74
75 procedure insert_absence_element
76 (p_date_start in date
77 ,p_assignment_id in number
78 ,p_absence_attendance_id in number
79 ,p_element_entry_id out nocopy number
80 );
81
82 PROCEDURE update_absence(p_absence_attendance_id NUMBER,
83 p_date_start DATE,
84 p_date_end DATE,
85 P_EFFECTIVE_DATE DATE);
86
87
88 procedure delete_absence
89 (p_absence_attendance_id in number
90 );
91
92 end hr_loc_absence;