1 PACKAGE WSH_CALENDAR_ACTIONS AS
2 /* $Header: WSHCAACS.pls 120.2 2005/08/12 14:22:06 sperera noship $ */
3 -------------------------------------------------------------------------------------------
4 -- Start of comments
5 -- API name : Get_Shift_Times
6 -- Type : public
7 -- Function : get the earliest shift times from
8 -- calendars greater than a given date/time
9 -- for a given location
10 -- Version : Initial version 1.0
11 -- Parameters : IN: p_location_id: Location for which we need the
12 -- shift times.
13 -- p_date : Date for which we need the
14 -- shift times.
15 -- : OUT: x_from_time : The start time of the earliest
16 -- shift that ends after the given
17 -- date time
18 -- : x_to_time : The end time of the earliest
19 -- shift that ends after the given
20 -- date time
21 -- Notes : It is possible that a shift extends past midnight.
22 -- In this case the x_to_time will be less than the x_from_time.
23 -- If there are no shifts remaing after the date/time or
24 -- Calendar not defined for the location, NULL will be
25 -- returned for both the out dates.
26 -- End of comments
27 -- ------------------------------------------------------------------------------------------
28
29
30 Procedure Get_Shift_Times(p_location_id IN NUMBER,
31 p_date IN DATE,
32 x_from_time OUT NOCOPY NUMBER,
33 x_to_time OUT NOCOPY NUMBER,
34 x_return_status OUT NOCOPY VARCHAR2);
35
36
37 END WSH_CALENDAR_ACTIONS;
38