[Home] [Help]
Skip to content
PACKAGE: APPS.HXT_TD_UTIL
Source
1 PACKAGE hxt_td_util AUTHID CURRENT_USER AS
2 /* $Header: hxttdutl.pkh 120.4 2011/08/12 06:52:03 asrajago ship $ */
3
4
5
6
7 TYPE rre_details IS RECORD
8 ( session_date DATE,
9 upd_mode VARCHAR2(15),
10 ret_code NUMBER
11 );
12
13 TYPE rre_details_assoc_array IS TABLE OF RRE_DETAILS INDEX BY VARCHAR2(25);
14
15 g_rre_details_tab RRE_DETAILS_ASSOC_ARRAY;
16
17 g_td_session_date DATE;
18
19
20
21 FUNCTION get_weekly_total (
22 a_location IN VARCHAR2,
23 a_date_worked IN DATE,
24 a_start_day_of_week IN VARCHAR2,
25 a_tim_id IN NUMBER,
26 a_base_element_type_id IN NUMBER,
27 a_ep_id IN NUMBER,
28
29 -- Added the following parameter for
30 -- OTLR Recurring Period Preference Support.
31 a_for_person_id IN NUMBER
32 )
33 RETURN NUMBER;
34
35 FUNCTION get_weekly_total_prev_days (
36 a_location IN VARCHAR2,
37 a_date_worked IN DATE,
38 a_start_day_of_week IN VARCHAR2,
39 a_tim_id IN NUMBER,
40 a_base_element_type_id IN NUMBER,
41 a_ep_id IN NUMBER,
42
43 -- Added the following parameter for
44 -- OTLR Recurring Period Preference Support.
45 a_for_person_id IN NUMBER
46 )
47 RETURN NUMBER;
48
49 FUNCTION include_for_ot_cap (
50 a_earn_group IN NUMBER,
51 a_element_type IN NUMBER,
52 a_base_element IN NUMBER,
53 a_date_worked IN DATE
54 )
55 RETURN BOOLEAN;
56
57 FUNCTION load_changed_status (a_hrw_id IN NUMBER)
58 RETURN VARCHAR2;
59
60 FUNCTION load_error_status (a_hrw_id IN NUMBER)
61 RETURN VARCHAR2;
62
63 FUNCTION determine_fixed_premium (
64 p_tim_id NUMBER,
65 p_id NUMBER,
66 p_hours NUMBER,
67 p_element_type_id NUMBER,
68 p_effective_start_date DATE,
69 p_effective_end_date DATE,
70 p_return_code OUT NOCOPY NUMBER
71 )
72 RETURN NUMBER;
73
74 FUNCTION get_hourly_rate (
75 p_eff_date DATE,
76 p_ptp_id NUMBER,
77 p_assignment_id NUMBER,
78 p_hourly_rate OUT NOCOPY NUMBER
79 )
80 RETURN NUMBER;
81
82 PROCEDURE retro_restrict_edit (
83 p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,
84 p_session_date IN DATE,
85 o_dt_update_mod OUT NOCOPY VARCHAR2,
86 o_error_message OUT NOCOPY VARCHAR2,
87 o_return_code OUT NOCOPY NUMBER,
88 p_parent_id IN hxt_det_hours_worked_f.parent_id%TYPE
89 DEFAULT NULL
90 );
91
92
93 -- Bug 12850901
94 -- New signature with an additional Parameter.
95 PROCEDURE retro_restrict_edit (
96 p_tim_id IN hxt_det_hours_worked_f.tim_id%TYPE,
97 p_session_date IN DATE,
98 o_dt_update_mod OUT NOCOPY VARCHAR2,
99 o_error_message OUT NOCOPY VARCHAR2,
100 o_return_code OUT NOCOPY NUMBER,
101 p_parent_id IN hxt_det_hours_worked_f.parent_id%TYPE
102 DEFAULT NULL,
103 p_do_intg_check IN VARCHAR2
104 );
105
106 FUNCTION load_tim_error_status (p_tim_id IN NUMBER)
107 RETURN VARCHAR2;
108
109 FUNCTION load_hrw_error_change_status (
110 p_hrw_id IN NUMBER,
111 p_tim_status IN VARCHAR2
112 )
113 RETURN VARCHAR2;
114
115 FUNCTION get_sum_hours_worked (
116 p_tim_id IN NUMBER, -- p_hrw_group_id IN NUMBER,
117 p_date_worked IN DATE
118 )
119 RETURN NUMBER;
120
121 PROCEDURE get_contig_hrs_and_start (
122 p_date_worked IN DATE,
123 p_person_id IN NUMBER,
124 p_current_time_in IN DATE,
125 p_egt_id IN NUMBER,
126 p_tim_id IN NUMBER,
127 o_first_time_in OUT NOCOPY DATE,
128 o_contig_hrs OUT NOCOPY NUMBER
129 );
130 END;