1 PACKAGE HXT_UTIL AUTHID CURRENT_USER AS
2 /* $Header: hxtutl.pkh 120.2.12010000.1 2008/07/25 09:51:39 appldev ship $ */
3
4 Procedure DEBUG(p_string IN VARCHAR2);
5
6 PROCEDURE GEN_ERROR (p_PPB_ID IN NUMBER
7 ,p_TIM_ID IN NUMBER
8 , p_HRW_ID IN NUMBER
9 , p_PTP_ID IN NUMBER
10 , p_ERROR_MSG IN VARCHAR2
11 , p_LOCATION IN VARCHAR2
12 , p_ORA_MSG IN VARCHAR2
13 , p_EFFECTIVE_START_DATE IN DATE
14 , p_EFFECTIVE_END_DATE IN DATE
15 , p_TYPE IN VARCHAR2);
16
17 --------------------------------Procedure GEN ERRORS-----------------------------
18 PROCEDURE GEN_ERROR (p_TIM_ID IN NUMBER
19 , p_HRW_ID IN NUMBER
20 , p_PTP_ID IN NUMBER
21 , p_ERROR_MSG IN VARCHAR2
22 , p_LOCATION IN VARCHAR2
23 , p_ORA_MSG IN VARCHAR2
24 , p_EFFECTIVE_START_DATE IN DATE
25 , p_EFFECTIVE_END_DATE IN DATE
26 , p_TYPE IN VARCHAR2);
27
28
29 PROCEDURE chk_absence(P_assignment_id IN NUMBER,
30 P_period_id IN NUMBER,
31 P_calculation_date IN DATE,
32 P_element_type_id IN NUMBER,
33 P_hours IN NUMBER,
34 P_net_amt OUT NOCOPY NUMBER,
35 P_period_amt OUT NOCOPY NUMBER,
36 P_available_amt OUT NOCOPY NUMBER,
37 P_abs_status OUT NOCOPY NUMBER);
38 ----------------------------Function Submit Req ---------------------
39 FUNCTION submit_req
40 (p_program varchar2,
41 p_desc varchar2,
42 p_msg varchar2,
43 p_loc varchar2,
44 p_1 varchar2,p_2 varchar2,p_3 varchar2,p_4 varchar2,
45 p_5 varchar2,p_6 varchar2,p_7 varchar2,p_8 varchar2,p_9 varchar2,p_10 varchar2,
46 p_11 varchar2,p_12 varchar2,p_13 varchar2,p_14 varchar2,p_15 varchar2,p_16 varchar2,
47 p_17 varchar2,p_18 varchar2,p_19 varchar2,p_20 varchar2,p_21 varchar2,p_22 varchar2,
48 p_23 varchar2,p_24 varchar2,p_25 varchar2,p_26 varchar2,p_27 varchar2,p_28 varchar2,
49 p_29 varchar2,p_30 varchar2,p_31 varchar2,p_32 varchar2,p_33 varchar2,p_34 varchar2,
50 p_35 varchar2,p_36 varchar2,p_37 varchar2,p_38 varchar2,p_39 varchar2,p_40 varchar2,
51 p_41 varchar2,p_42 varchar2,p_43 varchar2,p_44 varchar2,p_45 varchar2,p_46 varchar2,
52 p_47 varchar2,p_48 varchar2,p_49 varchar2,p_50 varchar2,p_51 varchar2,p_52 varchar2,
53 p_53 varchar2,p_54 varchar2,p_55 varchar2,p_56 varchar2,p_57 varchar2,p_58 varchar2,
54 p_59 varchar2,p_60 varchar2,p_61 varchar2,p_62 varchar2,p_63 varchar2,p_64 varchar2,
55 p_65 varchar2,p_66 varchar2,p_67 varchar2,p_68 varchar2,p_69 varchar2,p_70 varchar2,
56 p_71 varchar2,p_72 varchar2,p_73 varchar2,p_74 varchar2,p_75 varchar2,p_76 varchar2,
57 p_77 varchar2,p_78 varchar2,p_79 varchar2,p_80 varchar2,p_81 varchar2,p_82 varchar2,
58 p_83 varchar2,p_84 varchar2,p_85 varchar2,p_86 varchar2,p_87 varchar2,p_88 varchar2,
59 p_89 varchar2,p_90 varchar2,p_91 varchar2,p_92 varchar2,p_93 varchar2,p_94 varchar2,
60 p_95 varchar2,p_96 varchar2,p_97 varchar2,p_98 varchar2,p_99 varchar2,p_100 varchar2
61 ) RETURN number;
62
63 --
64 PROCEDURE check_for_holiday (p_date in DATE
65 ,p_hol_id in NUMBER
66 ,p_day_id OUT NOCOPY NUMBER
67 ,p_hours OUT NOCOPY NUMBER
68 ,p_retcode OUT NOCOPY NUMBER);
69
70 FUNCTION Fnd_Username( a_user_id NUMBER ) RETURN VARCHAR2;
71 --
72
73 FUNCTION element_cat(p_element_type_id IN NUMBER,
74 p_date_worked IN DATE) RETURN varchar2;
75
76 FUNCTION CHECK_POLICY_USE (p_policy_id in number,
77 p_policy_name in varchar2,
78 p_policy_end_date in date) RETURN BOOLEAN;
79 PROCEDURE get_policies(p_earn_pol_id IN NUMBER
80 ,p_assignment_id IN NUMBER
81 ,p_date IN DATE
82 ,p_work_plan OUT NOCOPY NUMBER
83 ,p_rotation_plan OUT NOCOPY NUMBER
84 ,p_ep_id OUT NOCOPY NUMBER
85 ,p_hdp_id OUT NOCOPY NUMBER
86 ,p_sdp_id OUT NOCOPY NUMBER
87 ,p_ep_type OUT NOCOPY VARCHAR2
88 ,p_egt_id OUT NOCOPY NUMBER
89 ,p_pep_id OUT NOCOPY NUMBER
90 ,p_pip_id OUT NOCOPY NUMBER
91 ,p_hcl_id OUT NOCOPY NUMBER
92 ,p_min_tcard_intvl OUT NOCOPY NUMBER
93 ,p_round_up OUT NOCOPY NUMBER
94 ,p_hcl_element_type_id OUT NOCOPY NUMBER
95 ,p_error OUT NOCOPY NUMBER);
96
97
98 PROCEDURE get_shift_info( p_date IN DATE
99 , p_work_id IN OUT NOCOPY NUMBER
100 , p_rotation_id IN NUMBER
101 , p_osp_id OUT NOCOPY NUMBER
102 , p_sdf_id OUT NOCOPY NUMBER
103 , p_standard_start OUT NOCOPY NUMBER
104 , p_standard_stop OUT NOCOPY NUMBER
105 , p_early_start OUT NOCOPY NUMBER
106 , p_late_stop OUT NOCOPY NUMBER
107 , p_hours OUT NOCOPY NUMBER
108 , p_error OUT NOCOPY NUMBER) ;
109
110 FUNCTION round_time (p_time DATE
111 , p_interval NUMBER
112 , p_round_up NUMBER) RETURN DATE;
113
114 FUNCTION time_to_hours(
115 P_TIME IN NUMBER ) RETURN NUMBER;
116
117
118 FUNCTION Get_Next_Seqno(a_timecard_id IN NUMBER, a_date_worked IN DATE) RETURN NUMBER;
119
120 FUNCTION Get_Period_End(a_period_id IN NUMBER) RETURN DATE;
121
122 FUNCTION Get_Period_Start(a_period_id IN NUMBER) RETURN DATE;
123
124 --
125 FUNCTION date_range
126 (start_date_in IN DATE,
127 end_date_in IN DATE,
128 check_time_in IN VARCHAR2 := 'NOTIME')RETURN VARCHAR2;
129
130 FUNCTION Get_Retro_Batch_Id(p_tim_id IN NUMBER
131 ,p_batch_name IN VARCHAR2 DEFAULT NULL
132 ,p_batch_ref IN VARCHAR2 DEFAULT NULL) RETURN NUMBER;
133
134 FUNCTION create_batch( i_source IN VARCHAR2,
135 p_batch_name IN VARCHAR2 DEFAULT NULL,
136 p_batch_ref IN VARCHAR2 DEFAULT NULL,
137 i_payroll_id IN NUMBER,
138 i_time_period_id IN NUMBER,
139 i_assignment_id IN NUMBER,
140 i_person_id IN NUMBER,
141 o_batch_id OUT NOCOPY NUMBER) RETURN NUMBER;
142
143 PROCEDURE GEN_EXCEPTION
144 (p_LOCATION IN VARCHAR2
145 ,p_HXT_ERROR_MSG IN VARCHAR2
146 ,p_ORACLE_ERROR_MSG IN VARCHAR2
147 ,p_RESOLUTION IN VARCHAR2);
148
149
150 --Begin COSTIN
151 FUNCTION build_cost_alloc_flex_entry(i_segment1 IN VARCHAR2,
152 i_segment2 IN VARCHAR2,
153 i_segment3 IN VARCHAR2,
154 i_segment4 IN VARCHAR2,
155 i_segment5 IN VARCHAR2,
156 i_segment6 IN VARCHAR2,
157 i_segment7 IN VARCHAR2,
158 i_segment8 IN VARCHAR2,
159 i_segment9 IN VARCHAR2,
160 i_segment10 IN VARCHAR2,
161 i_segment11 IN VARCHAR2,
162 i_segment12 IN VARCHAR2,
163 i_segment13 IN VARCHAR2,
164 i_segment14 IN VARCHAR2,
165 i_segment15 IN VARCHAR2,
166 i_segment16 IN VARCHAR2,
167 i_segment17 IN VARCHAR2,
168 i_segment18 IN VARCHAR2,
169 i_segment19 IN VARCHAR2,
170 i_segment20 IN VARCHAR2,
171 i_segment21 IN VARCHAR2,
172 i_segment22 IN VARCHAR2,
173 i_segment23 IN VARCHAR2,
174 i_segment24 IN VARCHAR2,
175 i_segment25 IN VARCHAR2,
176 i_segment26 IN VARCHAR2,
177 i_segment27 IN VARCHAR2,
178 i_segment28 IN VARCHAR2,
179 i_segment29 IN VARCHAR2,
180 i_segment30 IN VARCHAR2,
181 i_business_group_id IN NUMBER,
182 io_keyflex_id IN OUT NOCOPY NUMBER,
183 o_error_msg OUT NOCOPY VARCHAR2) RETURN NUMBER;
184 --------------------------------------------PROCEDURE check_absence------------------------------------
185 -- added 07/31/97 RDB
186 PROCEDURE check_absence(
187 P_assignment_id IN NUMBER,
188 P_period_id IN NUMBER,
189 P_tim_id IN NUMBER,
190 P_calculation_date IN DATE,
191 P_element_type_id IN NUMBER,
192 P_hours IN NUMBER,
193 P_net_amt OUT NOCOPY NUMBER,
194 P_period_amt OUT NOCOPY NUMBER,
195 P_available_amt OUT NOCOPY NUMBER,
196 P_abs_status OUT NOCOPY NUMBER);
197 FUNCTION accrual_exceeded( p_tim_id IN NUMBER,
198 P_calculation_date IN DATE,
199 P_accrual_plan_name OUT NOCOPY VARCHAR2,
200 P_accrued_hrs OUT NOCOPY NUMBER,
201 P_charged_hrs OUT NOCOPY NUMBER) return BOOLEAN;
202
203 FUNCTION get_costable_type(p_element_type_id IN NUMBER,
204 p_date_worked IN DATE,
205 p_assignment_id IN NUMBER) return VARCHAR2;
206
207 FUNCTION get_period_end_date(p_batch_id IN NUMBER) return VARCHAR2;
208 FUNCTION get_week_day(p_date IN DATE) return VARCHAR2;
209 Procedure SET_TIMECARD_ERROR (p_PPB_ID IN NUMBER,
210 p_TIM_ID IN NUMBER,
211 p_HRW_ID IN NUMBER,
212 p_PTP_ID IN NUMBER,
213 p_ERROR_MSG IN OUT NOCOPY VARCHAR2,
214 p_LOCATION IN VARCHAR2,
215 p_ORA_MSG IN VARCHAR2,
216 p_LOOKUP_CODE IN VARCHAR2,
217 p_valid OUT NOCOPY VARCHAR,
218 p_msg_level OUT NOCOPY VARCHAR2);
219
220 Procedure GET_QUICK_CODES(p_lookup_code IN VARCHAR2,
221 p_lookup_type IN VARCHAR2,
222 p_application_id IN NUMBER,
223 p_lookup_meaning OUT NOCOPY VARCHAR2,
224 p_lookup_description OUT NOCOPY VARCHAR2);
225 PROCEDURE check_batch_states(P_BATCH_ID IN NUMBER); --3739107
226
227 FUNCTION is_valid_time_entry (
228 p_raw_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
229 p_rounded_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
230 p_raw_time_out IN hxt_det_hours_worked_f.time_in%TYPE,
231 p_rounded_time_out IN hxt_det_hours_worked_f.time_in%TYPE
232 )
233 RETURN BOOLEAN ;
234
235 PROCEDURE check_timecard_exists (p_person_id IN NUMBER);
236
237 --END HXT11i1
238 END hxt_util;