1 PACKAGE hr_wrk_sch_pkg AUTHID CURRENT_USER AS
2 -- $Header: pewrksch.pkh 120.1.12010000.1 2008/07/28 06:08:03 appldev ship $
3
4 --
5 -----------------------------------------------------------------------------
6 --------------------------< get_per_asg_schedule >---------------------------
7 -----------------------------------------------------------------------------
8 --
9 -- This procedure can be invoked by downstream products wishing to use the
10 -- the Absences Availability functionality to retreive availability data
11 -- for a person assignment.
12 --
13 PROCEDURE get_per_asg_schedule(p_person_assignment_id IN NUMBER
14 ,p_period_start_date IN DATE
15 ,p_period_end_date IN DATE
16 ,p_schedule_category IN VARCHAR2
17 ,p_include_exceptions IN VARCHAR2
18 ,p_busy_tentative_as IN VARCHAR2
19 ,x_schedule_source IN OUT NOCOPY VARCHAR2
20 ,x_schedule IN OUT NOCOPY cac_avlblty_time_varray
21 ,x_return_status OUT NOCOPY NUMBER
22 ,x_return_message OUT NOCOPY VARCHAR2
23 );
24
25 --
26 -----------------------------------------------------------------------------
27 --------------------------< get_working_day >--------------------------------
28 -----------------------------------------------------------------------------
29 --
30 -- This procedure can be invoked by downstream products wishing to use the
31 -- Absences Availability functionality to retrieve the next/previous working
32 -- day after a leave.
33
34 function get_working_day
35 (
36 p_person_assignment_id IN NUMBER
37 ,loa_start_date in DATE
38 ,loa_end_date in DATE
39 ,prev_next_flag in VARCHAR2 default 'N'
40
41 ) return DATE;
42
43 END hr_wrk_sch_pkg;