1 PACKAGE hri_bpl_utilization AS
2 /* $Header: hributl.pkh 120.2.12000000.1 2007/01/15 21:28:48 appldev noship $ */
3
4 FUNCTION convert_days_to_hours(p_assignment_id IN NUMBER,
5 p_business_group_id IN NUMBER,
6 p_effective_date IN DATE,
7 p_session_date IN DATE,
8 p_number_of_days IN NUMBER)
9 RETURN NUMBER;
10
11 FUNCTION convert_hours_to_days(p_assignment_id IN NUMBER,
12 p_business_group_id IN NUMBER,
13 p_effective_date IN DATE,
14 p_session_date IN DATE,
15 p_number_of_hours IN NUMBER)
16 RETURN NUMBER;
17
18 FUNCTION calculate_absence_duration(p_absence_attendance_id IN VARCHAR2,
19 p_uom_code IN VARCHAR2,
20 p_absence_hours IN NUMBER,
21 p_absence_days IN NUMBER,
22 p_assignment_id IN NUMBER,
23 p_business_group_id IN NUMBER,
24 p_primary_flag IN VARCHAR2,
25 p_date_start IN DATE,
26 p_date_end IN DATE,
27 p_time_start IN VARCHAR2,
28 p_time_end IN VARCHAR2)
29 RETURN NUMBER;
30
31 FUNCTION get_abs_durtn_profile_vl
32 RETURN VARCHAR2;
33
34 END hri_bpl_utilization;