1 PACKAGE PAY_CALC_HOURS_WORKED AUTHID CURRENT_USER as
2 /* $Header: paycalchrswork.pkh 120.0 2005/05/29 11:19 appldev noship $ */
3 /*
4 +======================================================================+
5 | Copyright (c) 1994 Oracle Corporation |
6 | Redwood Shores, California, USA |
7 | All rights reserved. |
8 +======================================================================+
9
10 Name : PAY_CALC_HOURS_WORKED
11 Filename : paycalchrswork.pkh
12 Change List
13 -----------
14 Date Name Vers Bug No Description
15 ---- ---- ---- ------ -----------
16 28-APR-2005 sodhingr 115.0 4338404 Package to deliver new
17 functioanlity to calculate
18 hours worked
19 */
20 FUNCTION calculate_actual_hours_worked
21 (assignment_action_id IN number --Context
22 ,assignment_id IN number --Context
23 ,business_group_id IN number --Context
24 ,element_entry_id IN number --Context
25 ,date_earned IN date --Context
26 ,p_period_start_date IN date
27 ,p_period_end_date IN date
28 ,p_schedule_category IN varchar2 -- 'WORK'/'PAGER'
29 ,p_include_exceptions IN varchar2
30 ,p_busy_tentative_as IN varchar2 -- 'BUSY'/FREE/NULL
31 ,p_legislation_code IN varchar2
32 ,p_schedule_source IN OUT nocopy varchar2 -- 'PER_ASG' for asg
33 ,p_schedule IN OUT nocopy varchar2 -- schedule
34 ,p_return_status OUT nocopy number
35 ,p_return_message OUT nocopy varchar2)
36 RETURN NUMBER;
37
38 FUNCTION standard_hours_worked(
39 p_std_hrs in NUMBER,
40 p_range_start in DATE,
41 p_range_end in DATE,
42 p_std_freq in VARCHAR2) RETURN NUMBER;
43
44 END pay_calc_hours_worked;
45