PACKAGE: APPS.HXC_TIMECARD_HOURS_PKG

Source

1 package hxc_timecard_hours_pkg AUTHID CURRENT_USER as
2 /* $Header: hxchours.pkh 115.4 2002/06/10 00:37:13 pkm ship    $ */
3 --  get_hours
4 --
5 -- procedure
6 --  Gets the sum for a particular type of Hours
7 --
8 -- description
9 --
10 -- parameters
11 --       p_timecard_id    - timecard Id
12 --       p_timecard_ovn   - timecard  Ovn
13 --       p_lookup_type    - Hours Type Lookup
14 --
15 FUNCTION get_hours
16             (
17               p_timecard_id number,
18               p_timecard_ovn number,
19               p_lookup_type varchar2
20             ) RETURN NUMBER;
21 
22 
23 FUNCTION get_hours(
24   p_period_start_time  IN DATE,
25   p_period_stop_time   IN DATE,
26   p_resource_id        IN NUMBER,
27   p_lookup_type        IN VARCHAR2
28 )
29 RETURN NUMBER;
30 
31 FUNCTION get_total_hours(
32   p_period_start_time  IN DATE,
33   p_period_stop_time   IN DATE,
34   p_resource_id        IN NUMBER,
35   p_mode               IN VARCHAR2 DEFAULT 'DAYS_INCLUSIVE'
36 )
37 RETURN NUMBER;
38 
39 
40 
41 --  get_total_hours
42 --
43 -- procedure
44 --  Gets the sum for a total Hours
45 --
46 -- description
47 --
48 -- parameters
49 --       p_timecard_id    - timecard Id
50 --       p_timecard_ovn   - timecard  Ovn
51 --
52 
53 FUNCTION get_total_hours
54             (
55               p_timecard_id number,
56               p_timecard_ovn number
57             ) RETURN NUMBER;
58 
59 
60 END hxc_timecard_hours_pkg;