1 PACKAGE hr_loc_work_schedule AS
2 /* $Header: hrlocwks.pkh 120.0.12000000.1 2007/01/21 17:14:28 appldev ship $ */
3
4 -- Function to retrieve time duration between given 2 dates for given assignment
5 --
6 --parameter p_days_or_hours 'D' to calculate duration in days
7 -- 'H' to calculate duration in hours
8 --parameter p_include_event 'Y' to consider calendar events
9 -- 'N' to not to consider calendar events
10 --
11
12
13 FUNCTION calc_sch_based_dur ( p_assignment_id IN NUMBER,
14 p_days_or_hours IN VARCHAR2,
15 p_include_event IN VARCHAR2,
16 p_date_start IN DATE,
17 p_date_end IN DATE,
18 p_time_start IN VARCHAR2,
19 p_time_end IN VARCHAR2,
20 p_duration IN OUT NOCOPY NUMBER
21 ) RETURN NUMBER;
22
23 -- Function to check whether given parameter is in proper time format
24
25 FUNCTION good_time_format ( p_time IN VARCHAR2 ) RETURN BOOLEAN;
26
27 END hr_loc_work_schedule;
28