eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.HXT_DML

Source


1 PACKAGE  HXT_DML AUTHID CURRENT_USER AS
2 /* $Header: hxtdml.pkh 120.1 2005/07/12 03:01:14 vikgarg noship $ */
3 
4 procedure insert_HXT_TIMECARDS(
5 p_rowid  IN OUT NOCOPY  VARCHAR2,
6 p_id                 NUMBER,
7 p_for_person_id      NUMBER,
8 p_time_period_id     NUMBER,
9 p_auto_gen_flag      VARCHAR2,
10 p_batch_id           NUMBER,
11 p_approv_person_id   NUMBER,
12 p_approved_timestamp DATE,
13 p_created_by         NUMBER,
14 p_creation_date      DATE,
15 p_last_updated_by    NUMBER,
16 p_last_update_date   DATE,
17 p_last_update_login  NUMBER,
18 p_payroll_id         NUMBER,
19 p_status             VARCHAR2,
20 p_effective_start_date DATE,
21 p_effective_end_date   DATE,
22 p_attribute1         VARCHAR2 DEFAULT NULL,
23 p_attribute2         VARCHAR2 DEFAULT NULL,
24 p_attribute3         VARCHAR2 DEFAULT NULL,
25 p_attribute4         VARCHAR2 DEFAULT NULL,
26 p_attribute5         VARCHAR2 DEFAULT NULL,
27 p_attribute6         VARCHAR2 DEFAULT NULL,
28 p_attribute7         VARCHAR2 DEFAULT NULL,
29 p_attribute8         VARCHAR2 DEFAULT NULL,
30 p_attribute9         VARCHAR2 DEFAULT NULL,
31 p_attribute10        VARCHAR2 DEFAULT NULL,
32 p_attribute11        VARCHAR2 DEFAULT NULL,
33 p_attribute12        VARCHAR2 DEFAULT NULL,
34 p_attribute13        VARCHAR2 DEFAULT NULL,
35 p_attribute14        VARCHAR2 DEFAULT NULL,
36 p_attribute15        VARCHAR2 DEFAULT NULL,
37 p_attribute16        VARCHAR2 DEFAULT NULL,
38 p_attribute17        VARCHAR2 DEFAULT NULL,
39 p_attribute18        VARCHAR2 DEFAULT NULL,
40 p_attribute19        VARCHAR2 DEFAULT NULL,
41 p_attribute20        VARCHAR2 DEFAULT NULL,
42 p_attribute21        VARCHAR2 DEFAULT NULL,
43 p_attribute22        VARCHAR2 DEFAULT NULL,
44 p_attribute23        VARCHAR2 DEFAULT NULL,
45 p_attribute24        VARCHAR2 DEFAULT NULL,
46 p_attribute25        VARCHAR2 DEFAULT NULL,
47 p_attribute26        VARCHAR2 DEFAULT NULL,
48 p_attribute27        VARCHAR2 DEFAULT NULL,
49 p_attribute28        VARCHAR2 DEFAULT NULL,
50 p_attribute29        VARCHAR2 DEFAULT NULL,
51 p_attribute30        VARCHAR2 DEFAULT NULL,
52 p_attribute_category VARCHAR2 DEFAULT NULL,
53 p_object_version_number    OUT NOCOPY    NUMBER
54 );
55 
56 procedure insert_HXT_SUM_HOURS_WORKED(
57 p_rowid        IN OUT NOCOPY  VARCHAR2,
58 p_id                     NUMBER,
59 -- p_group_id               NUMBER,      --HXT11i1
60 p_tim_id                 NUMBER,
61 p_date_worked            DATE,
62 p_assignment_id          NUMBER,
63 p_hours                  NUMBER,
64 p_time_in                DATE,
65 p_time_out               DATE,
66 p_element_type_id        NUMBER,
67 p_fcl_earn_reason_code   VARCHAR2,
68 p_ffv_cost_center_id     NUMBER,
69 p_ffv_labor_account_id   NUMBER,
70 p_tas_id                 NUMBER,
71 p_location_id            NUMBER,
72 p_sht_id                 NUMBER,
73 p_hrw_comment            VARCHAR2,
74 p_ffv_rate_code_id       NUMBER,
75 p_rate_multiple          NUMBER,
76 p_hourly_rate            NUMBER,
77 p_amount                 NUMBER,
78 p_fcl_tax_rule_code      VARCHAR2,
79 p_separate_check_flag    VARCHAR2,
80 p_seqno                  NUMBER,
81 p_created_by             NUMBER,
82 p_creation_date          DATE,
83 p_last_updated_by        NUMBER,
84 p_last_update_date       DATE,
85 p_last_update_login      NUMBER,
86 p_actual_time_in         DATE,
87 p_actual_time_out        DATE,
88 p_effective_start_date   DATE,
89 p_effective_end_date     DATE,
90 p_project_id             NUMBER,
91 p_prev_wage_code	 VARCHAR2,
92 p_job_id                 NUMBER,
93 p_earn_pol_id		 NUMBER,
94 p_attribute1         VARCHAR2 DEFAULT NULL,
95 p_attribute2         VARCHAR2 DEFAULT NULL,
96 p_attribute3         VARCHAR2 DEFAULT NULL,
97 p_attribute4         VARCHAR2 DEFAULT NULL,
98 p_attribute5         VARCHAR2 DEFAULT NULL,
99 p_attribute6         VARCHAR2 DEFAULT NULL,
100 p_attribute7         VARCHAR2 DEFAULT NULL,
101 p_attribute8         VARCHAR2 DEFAULT NULL,
102 p_attribute9         VARCHAR2 DEFAULT NULL,
103 p_attribute10        VARCHAR2 DEFAULT NULL,
104 p_attribute11        VARCHAR2 DEFAULT NULL,
105 p_attribute12        VARCHAR2 DEFAULT NULL,
106 p_attribute13        VARCHAR2 DEFAULT NULL,
107 p_attribute14        VARCHAR2 DEFAULT NULL,
108 p_attribute15        VARCHAR2 DEFAULT NULL,
109 p_attribute16        VARCHAR2 DEFAULT NULL,
110 p_attribute17        VARCHAR2 DEFAULT NULL,
111 p_attribute18        VARCHAR2 DEFAULT NULL,
112 p_attribute19        VARCHAR2 DEFAULT NULL,
113 p_attribute20        VARCHAR2 DEFAULT NULL,
114 p_attribute21        VARCHAR2 DEFAULT NULL,
115 p_attribute22        VARCHAR2 DEFAULT NULL,
116 p_attribute23        VARCHAR2 DEFAULT NULL,
117 p_attribute24        VARCHAR2 DEFAULT NULL,
118 p_attribute25        VARCHAR2 DEFAULT NULL,
119 p_attribute26        VARCHAR2 DEFAULT NULL,
120 p_attribute27        VARCHAR2 DEFAULT NULL,
121 p_attribute28        VARCHAR2 DEFAULT NULL,
122 p_attribute29        VARCHAR2 DEFAULT NULL,
123 p_attribute30        VARCHAR2 DEFAULT NULL,
124 p_attribute_category VARCHAR2 DEFAULT NULL,
125 p_time_building_block_id  NUMBER DEFAULT NULL,
126 p_time_building_block_ovn NUMBER DEFAULT NULL,
127 p_object_version_number  out nocopy number,
128 p_STATE_NAME              VARCHAR2 DEFAULT NULL,
129 p_COUNTY_NAME             VARCHAR2 DEFAULT NULL,
130 p_CITY_NAME               VARCHAR2 DEFAULT NULL,
131 p_ZIP_CODE                VARCHAR2 DEFAULT NULL
132 );
133 
134 
135 procedure insert_HXT_DET_HOURS_WORKED(
136 p_rowid        IN OUT NOCOPY  VARCHAR2,
137 p_id                     NUMBER,
138 p_parent_id              NUMBER,
139 p_tim_id                 NUMBER,
140 p_date_worked            DATE,
141 p_assignment_id          NUMBER,
142 p_hours                  NUMBER,
143 p_time_in                DATE,
144 p_time_out               DATE,
145 p_element_type_id        NUMBER,
146 p_fcl_earn_reason_code   VARCHAR2,
147 p_ffv_cost_center_id     NUMBER,
148 p_ffv_labor_account_id   NUMBER,
149 p_tas_id                 NUMBER,
150 p_location_id            NUMBER,
151 p_sht_id                 NUMBER,
152 p_hrw_comment            VARCHAR2,
153 p_ffv_rate_code_id       NUMBER,
154 p_rate_multiple          NUMBER,
155 p_hourly_rate            NUMBER,
156 p_amount                 NUMBER,
157 p_fcl_tax_rule_code      VARCHAR2,
158 p_separate_check_flag    VARCHAR2,
159 p_seqno                  NUMBER,
160 p_created_by             NUMBER,
161 p_creation_date          DATE,
162 p_last_updated_by        NUMBER,
163 p_last_update_date       DATE,
164 p_last_update_login      NUMBER,
165 p_actual_time_in         DATE,
166 p_actual_time_out        DATE,
167 p_effective_start_date   DATE,
168 p_effective_end_date     DATE,
169 p_project_id             NUMBER,
170 p_job_id                 NUMBER,
171 p_earn_pol_id		 NUMBER,
172 p_retro_batch_id         NUMBER,
173 p_pa_status              VARCHAR2,
174 p_pay_status             VARCHAR2,
175 -- p_group_id               NUMBER,
176 p_object_version_number  out nocopy number,
177 p_STATE_NAME              VARCHAR2 DEFAULT NULL,
178 p_COUNTY_NAME             VARCHAR2 DEFAULT NULL,
179 p_CITY_NAME               VARCHAR2 DEFAULT NULL,
180 p_ZIP_CODE                VARCHAR2 DEFAULT NULL
181 );
182 
183 procedure update_HXT_TIMECARDS(
184 p_rowid  IN      VARCHAR2,
185 p_id                 NUMBER,
186 p_for_person_id      NUMBER,
187 p_time_period_id     NUMBER,
188 p_auto_gen_flag      VARCHAR2,
189 p_batch_id           NUMBER,
190 p_approv_person_id   NUMBER,
191 p_approved_timestamp DATE,
192 p_created_by         NUMBER,
193 p_creation_date      DATE,
194 p_last_updated_by    NUMBER,
195 p_last_update_date   DATE,
196 p_last_update_login  NUMBER,
197 p_payroll_id         NUMBER,
198 p_status             VARCHAR2,
199 p_effective_start_date DATE,
200 p_effective_end_date   DATE,
201 p_attribute1         VARCHAR2 DEFAULT NULL,
202 p_attribute2         VARCHAR2 DEFAULT NULL,
203 p_attribute3         VARCHAR2 DEFAULT NULL,
204 p_attribute4         VARCHAR2 DEFAULT NULL,
205 p_attribute5         VARCHAR2 DEFAULT NULL,
206 p_attribute6         VARCHAR2 DEFAULT NULL,
207 p_attribute7         VARCHAR2 DEFAULT NULL,
208 p_attribute8         VARCHAR2 DEFAULT NULL,
209 p_attribute9         VARCHAR2 DEFAULT NULL,
210 p_attribute10        VARCHAR2 DEFAULT NULL,
211 p_attribute11        VARCHAR2 DEFAULT NULL,
212 p_attribute12        VARCHAR2 DEFAULT NULL,
213 p_attribute13        VARCHAR2 DEFAULT NULL,
214 p_attribute14        VARCHAR2 DEFAULT NULL,
215 p_attribute15        VARCHAR2 DEFAULT NULL,
216 p_attribute16        VARCHAR2 DEFAULT NULL,
217 p_attribute17        VARCHAR2 DEFAULT NULL,
218 p_attribute18        VARCHAR2 DEFAULT NULL,
219 p_attribute19        VARCHAR2 DEFAULT NULL,
220 p_attribute20        VARCHAR2 DEFAULT NULL,
221 p_attribute21        VARCHAR2 DEFAULT NULL,
222 p_attribute22        VARCHAR2 DEFAULT NULL,
223 p_attribute23        VARCHAR2 DEFAULT NULL,
224 p_attribute24        VARCHAR2 DEFAULT NULL,
225 p_attribute25        VARCHAR2 DEFAULT NULL,
226 p_attribute26        VARCHAR2 DEFAULT NULL,
227 p_attribute27        VARCHAR2 DEFAULT NULL,
228 p_attribute28        VARCHAR2 DEFAULT NULL,
229 p_attribute29        VARCHAR2 DEFAULT NULL,
230 p_attribute30        VARCHAR2 DEFAULT NULL,
231 p_attribute_category VARCHAR2 DEFAULT NULL,
232 p_object_version_number        in out nocopy number
233 );
234 
235 procedure update_HXT_SUM_HOURS_WORKED(
236 p_rowid        IN      VARCHAR2,
237 p_id                     NUMBER,
238 -- p_group_id               NUMBER,      --HXT11i1
239 p_tim_id                 NUMBER,
240 p_date_worked            DATE,
241 p_assignment_id          NUMBER,
242 p_hours                  NUMBER,
243 p_time_in                DATE,
244 p_time_out               DATE,
245 p_element_type_id        NUMBER,
246 p_fcl_earn_reason_code   VARCHAR2,
247 p_ffv_cost_center_id     NUMBER,
248 p_ffv_labor_account_id   NUMBER,
249 p_tas_id                 NUMBER,
250 p_location_id            NUMBER,
251 p_sht_id                 NUMBER,
252 p_hrw_comment            VARCHAR2,
253 p_ffv_rate_code_id       NUMBER,
254 p_rate_multiple          NUMBER,
255 p_hourly_rate            NUMBER,
256 p_amount                 NUMBER,
257 p_fcl_tax_rule_code      VARCHAR2,
258 p_separate_check_flag    VARCHAR2,
259 p_seqno                  NUMBER,
260 p_created_by             NUMBER,
261 p_creation_date          DATE,
262 p_last_updated_by        NUMBER,
263 p_last_update_date       DATE,
264 p_last_update_login      NUMBER,
265 p_actual_time_in         DATE,
266 p_actual_time_out        DATE,
267 p_effective_start_date   DATE,
268 p_effective_end_date     DATE,
269 p_project_id             NUMBER,
270 p_prev_wage_code	 VARCHAR2,
271 p_job_id                 NUMBER,
272 p_earn_pol_id		 NUMBER,
273 p_attribute1         VARCHAR2 DEFAULT NULL,
274 p_attribute2         VARCHAR2 DEFAULT NULL,
275 p_attribute3         VARCHAR2 DEFAULT NULL,
276 p_attribute4         VARCHAR2 DEFAULT NULL,
277 p_attribute5         VARCHAR2 DEFAULT NULL,
278 p_attribute6         VARCHAR2 DEFAULT NULL,
279 p_attribute7         VARCHAR2 DEFAULT NULL,
280 p_attribute8         VARCHAR2 DEFAULT NULL,
281 p_attribute9         VARCHAR2 DEFAULT NULL,
282 p_attribute10        VARCHAR2 DEFAULT NULL,
283 p_attribute11        VARCHAR2 DEFAULT NULL,
284 p_attribute12        VARCHAR2 DEFAULT NULL,
285 p_attribute13        VARCHAR2 DEFAULT NULL,
286 p_attribute14        VARCHAR2 DEFAULT NULL,
287 p_attribute15        VARCHAR2 DEFAULT NULL,
288 p_attribute16        VARCHAR2 DEFAULT NULL,
289 p_attribute17        VARCHAR2 DEFAULT NULL,
290 p_attribute18        VARCHAR2 DEFAULT NULL,
291 p_attribute19        VARCHAR2 DEFAULT NULL,
292 p_attribute20        VARCHAR2 DEFAULT NULL,
293 p_attribute21        VARCHAR2 DEFAULT NULL,
294 p_attribute22        VARCHAR2 DEFAULT NULL,
295 p_attribute23        VARCHAR2 DEFAULT NULL,
296 p_attribute24        VARCHAR2 DEFAULT NULL,
297 p_attribute25        VARCHAR2 DEFAULT NULL,
298 p_attribute26        VARCHAR2 DEFAULT NULL,
299 p_attribute27        VARCHAR2 DEFAULT NULL,
300 p_attribute28        VARCHAR2 DEFAULT NULL,
301 p_attribute29        VARCHAR2 DEFAULT NULL,
302 p_attribute30        VARCHAR2 DEFAULT NULL,
303 p_attribute_category VARCHAR2 DEFAULT NULL,
304 p_time_building_block_id  NUMBER DEFAULT NULL,
305 p_time_building_block_ovn NUMBER DEFAULT NULL,
306 p_object_version_number        in out nocopy number,
307 p_STATE_NAME              VARCHAR2 DEFAULT NULL,
308 p_COUNTY_NAME             VARCHAR2 DEFAULT NULL,
309 p_CITY_NAME               VARCHAR2 DEFAULT NULL,
310 p_ZIP_CODE                VARCHAR2 DEFAULT NULL
311 );
312 
313 procedure update_HXT_DET_HOURS_WORKED(
314 p_rowid        IN      VARCHAR2,
315 p_id                     NUMBER,
316 p_parent_id              NUMBER,
317 p_tim_id                 NUMBER,
318 p_date_worked            DATE,
319 p_assignment_id          NUMBER,
320 p_hours                  NUMBER,
321 p_time_in                DATE,
322 p_time_out               DATE,
323 p_element_type_id        NUMBER,
324 p_fcl_earn_reason_code   VARCHAR2,
325 p_ffv_cost_center_id     NUMBER,
326 p_ffv_labor_account_id   NUMBER,
327 p_tas_id                 NUMBER,
328 p_location_id            NUMBER,
329 p_sht_id                 NUMBER,
330 p_hrw_comment            VARCHAR2,
331 p_ffv_rate_code_id       NUMBER,
332 p_rate_multiple          NUMBER,
333 p_hourly_rate            NUMBER,
334 p_amount                 NUMBER,
335 p_fcl_tax_rule_code      VARCHAR2,
336 p_separate_check_flag    VARCHAR2,
337 p_seqno                  NUMBER,
338 p_created_by             NUMBER,
339 p_creation_date          DATE,
340 p_last_updated_by        NUMBER,
341 p_last_update_date       DATE,
342 p_last_update_login      NUMBER,
343 p_actual_time_in         DATE,
344 p_actual_time_out        DATE,
345 p_effective_start_date   DATE,
346 p_effective_end_date     DATE,
347 p_project_id             NUMBER,
348 p_job_id                 NUMBER,
349 p_earn_pol_id		 NUMBER,
350 p_retro_batch_id         NUMBER,
351 p_pa_status              VARCHAR2,
352 p_pay_status             VARCHAR2,
353 -- p_group_id               NUMBER,
354 p_object_version_number  in out nocopy number,
355 p_STATE_NAME              VARCHAR2 DEFAULT NULL,
356 p_COUNTY_NAME             VARCHAR2 DEFAULT NULL,
357 p_CITY_NAME               VARCHAR2 DEFAULT NULL,
358 p_ZIP_CODE                VARCHAR2 DEFAULT NULL
359 );
360 
361 procedure delete_HXT_TIMECARDS(p_rowid VARCHAR2);
362 
363 procedure delete_HXT_SUM_HOURS_WORKED(p_rowid VARCHAR2);
364 
365 procedure delete_HXT_DET_HOURS_WORKED(p_rowid VARCHAR2);
366 
367 procedure lock_HXT_TIMECARDS(p_rowid VARCHAR2);
368 procedure lock_HXT_SUM_HOURS_WORKED(p_rowid VARCHAR2);
369 procedure lock_HXT_DET_HOURS_WORKED(p_rowid VARCHAR2);
370 
371 END HXT_DML;