PACKAGE: APPS.HXT_TD_UTIL

Source

1 PACKAGE hxt_td_util AUTHID CURRENT_USER AS
2 /* $Header: hxttdutl.pkh 115.11 2003/03/08 22:09:26 mvilrokx ship $ */
3 
4    FUNCTION get_weekly_total (
5       a_location               IN   VARCHAR2,
6       a_date_worked            IN   DATE,
7       a_start_day_of_week      IN   VARCHAR2,
8       a_tim_id                 IN   NUMBER,
9       a_base_element_type_id   IN   NUMBER,
10       a_ep_id                  IN   NUMBER,
11 
12    -- Added the following parameter for
13    -- OTLR Recurring Period Preference Support.
14       a_for_person_id          IN   NUMBER
15    )
16       RETURN NUMBER;
17 
18    FUNCTION get_weekly_total_prev_days (
19       a_location               IN   VARCHAR2,
20       a_date_worked            IN   DATE,
21       a_start_day_of_week      IN   VARCHAR2,
22       a_tim_id                 IN   NUMBER,
23       a_base_element_type_id   IN   NUMBER,
24       a_ep_id                  IN   NUMBER,
25 
26    -- Added the following parameter for
27    -- OTLR Recurring Period Preference Support.
28       a_for_person_id          IN   NUMBER
29    )
30       RETURN NUMBER;
31 
32    FUNCTION include_for_ot_cap (
33       a_earn_group     IN   NUMBER,
34       a_element_type   IN   NUMBER,
35       a_base_element   IN   NUMBER,
36       a_date_worked    IN   DATE
37    )
38       RETURN BOOLEAN;
39 
40    FUNCTION load_changed_status (a_hrw_id IN NUMBER)
41       RETURN VARCHAR2;
42 
43    FUNCTION load_error_status (a_hrw_id IN NUMBER)
44       RETURN VARCHAR2;
45 
46    FUNCTION determine_fixed_premium (
47       p_tim_id                              NUMBER,
48       p_id                                  NUMBER,
49       p_hours                               NUMBER,
50       p_element_type_id                     NUMBER,
51       p_effective_start_date                DATE,
52       p_effective_end_date                  DATE,
53       p_return_code            OUT NOCOPY   NUMBER
54    )
55       RETURN NUMBER;
56 
57    FUNCTION get_hourly_rate (
58       p_eff_date                     DATE,
59       p_ptp_id                       NUMBER,
60       p_assignment_id                NUMBER,
61       p_hourly_rate     OUT NOCOPY   NUMBER
62    )
63       RETURN NUMBER;
64 
65    PROCEDURE retro_restrict_edit (
66       p_tim_id          IN              hxt_det_hours_worked_f.tim_id%TYPE,
67       p_session_date    IN              DATE,
68       o_dt_update_mod   OUT NOCOPY      VARCHAR2,
69       o_error_message   OUT NOCOPY      VARCHAR2,
70       o_return_code     OUT NOCOPY      NUMBER,
71       p_parent_id       IN              hxt_det_hours_worked_f.parent_id%TYPE
72             DEFAULT NULL
73    );
74 
75    FUNCTION load_tim_error_status (p_tim_id IN NUMBER)
76       RETURN VARCHAR2;
77 
78    FUNCTION load_hrw_error_change_status (
79       p_hrw_id       IN   NUMBER,
80       p_tim_status   IN   VARCHAR2
81    )
82       RETURN VARCHAR2;
83 
84    FUNCTION get_sum_hours_worked (
85       p_tim_id        IN   NUMBER, -- p_hrw_group_id IN NUMBER,
86       p_date_worked   IN   DATE
87    )
88       RETURN NUMBER;
89 
90    PROCEDURE get_contig_hrs_and_start (
91       p_date_worked       IN              DATE,
92       p_person_id         IN              NUMBER,
93       p_current_time_in   IN              DATE,
94       p_egt_id            IN              NUMBER,
95       p_tim_id            IN              NUMBER,
96       o_first_time_in     OUT NOCOPY      DATE,
97       o_contig_hrs        OUT NOCOPY      NUMBER
98    );
99 END;