1 package pay_fr_schedule_calculation AUTHID CURRENT_USER as
2 /* $Header: pyfrwktm.pkh 115.1 2002/05/27 09:45:19 pkm ship $ */
3 --
4 procedure initialise(p_assignment_id number
5 ,p_effective_date date);
6 procedure derive_schedule(p_assignment_id number
7 ,p_date_start date
8 ,p_date_end date);
9 function holiday_days(p_assignment_id number
10 ,p_effective_date date
11 ,p_date_start date
12 ,p_date_end date
13 ) return number;
14 function protected_days(p_assignment_id number
15 ,p_effective_date date
16 ,p_date_start date
17 ,p_date_end date
18 ) return number;
19 function scheduled_working_days(p_assignment_id number
20 ,p_effective_date date
21 ,p_date_start date
22 ,p_date_end date
23 ) return number;
24 function scheduled_working_hours(p_assignment_id number
25 ,p_effective_date date
26 ,p_date_start date
27 ,p_date_end date
28 ) return number;
29 function get_last_working_day(p_assignment_id number
30 ,p_effective_date date
31 ,p_date date
32 ,p_limit_date date default null
33 ) return date;
34 function get_next_working_day(p_assignment_id number
35 ,p_effective_date date
36 ,p_date date
37 ,p_limit_date date default null
38 ) return date;
39 end pay_fr_schedule_calculation;
[Home] [Help]