1 PACKAGE hr_cal_abs_dur_pkg AUTHID CURRENT_USER AS
2 /* $Header: peabsdur.pkh 115.2 2002/12/12 11:55:40 raranjan noship $ */
3 -- --------------- calculate_absence_duration ---------------------
4 --
5 -- computes the employee's absence duration
6 --
7 PROCEDURE calculate_absence_duration
8 ( p_days_or_hours IN VARCHAR2,
9 p_date_start IN DATE,
10 p_date_end IN DATE,
11 p_time_start IN VARCHAR2,
12 p_time_end IN VARCHAR2,
13 p_business_group_id IN NUMBER,
14 p_legislation_code IN VARCHAR2,
15 p_session_date IN DATE,
16 p_assignment_id IN NUMBER,
17 p_element_type_id IN NUMBER,
18 p_invalid_message IN OUT NOCOPY VARCHAR2,
19 p_duration IN OUT NOCOPY NUMBER,
20 p_use_formula IN OUT NOCOPY VARCHAR2);
21 --
22 -- --------------------- count_working_days -----------------------
23 --
24 -- This function is called from the formula and its used to
25 -- count the number of working days (Monday to Friday) for the
26 -- duration of the absence.
27 --
28 function count_working_days(starting_date DATE, total_days NUMBER)
29 return NUMBER;
30 --
31 --
32 end hr_cal_abs_dur_pkg;
[Home] [Help]