[Home] [Help]
PACKAGE BODY: APPS.HXT_DML
Source
1 PACKAGE BODY HXT_DML AS
2 /* $Header: hxtdml.pkb 120.1 2005/07/12 03:01:32 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 ) IS
55
56 CURSOR c2 IS SELECT rowid
57 FROM hxt_timecards_f
58 WHERE effective_start_date = p_effective_start_date
59 AND effective_end_date = p_effective_end_date
60 AND id = p_id;
61 begin
62 p_object_version_number := 1;
63
64 insert into HXT_TIMECARDS_F(
65 id,
66 for_person_id,
67 time_period_id,
68 auto_gen_flag,
69 batch_id,
70 approv_person_id,
71 approved_timestamp,
72 created_by,
73 creation_date,
74 last_updated_by,
75 last_update_date,
76 last_update_login,
77 payroll_id,
78 --status,
79 effective_start_date,
80 effective_end_date,
81 attribute1,
82 attribute2,
83 attribute3,
84 attribute4,
85 attribute5,
86 attribute6,
87 attribute7,
88 attribute8,
89 attribute9,
90 attribute10,
91 attribute11,
92 attribute12,
93 attribute13,
94 attribute14,
95 attribute15,
96 attribute16,
97 attribute17,
98 attribute18,
99 attribute19,
100 attribute20,
101 attribute21,
102 attribute22,
103 attribute23,
104 attribute24,
105 attribute25,
106 attribute26,
107 attribute27,
108 attribute28,
109 attribute29,
110 attribute30,
111 attribute_category,
112 object_version_number)
113 VALUES(p_id,
114 p_for_person_id,
115 p_time_period_id,
116 p_auto_gen_flag,
117 p_batch_id,
118 p_approv_person_id,
119 p_approved_timestamp,
120 p_created_by,
121 p_creation_date,
122 p_last_updated_by,
123 p_last_update_date,
124 p_last_update_login,
125 p_payroll_id,
126 --p_status,
127 p_effective_start_date,
128 p_effective_end_date,
129 p_attribute1,
130 p_attribute2,
131 p_attribute3,
132 p_attribute4,
133 p_attribute5,
134 p_attribute6,
135 p_attribute7,
136 p_attribute8,
137 p_attribute9,
138 p_attribute10,
139 p_attribute11,
140 p_attribute12,
141 p_attribute13,
142 p_attribute14,
143 p_attribute15,
144 p_attribute16,
145 p_attribute17,
146 p_attribute18,
147 p_attribute19,
148 p_attribute20,
149 p_attribute21,
150 p_attribute22,
151 p_attribute23,
152 p_attribute24,
153 p_attribute25,
154 p_attribute26,
155 p_attribute27,
156 p_attribute28,
157 p_attribute29,
158 p_attribute30,
159 p_attribute_category,
160 p_object_version_number);
161
162 open c2;
163 fetch c2 into p_rowid;
164 close c2;
165 null;
166
167 end insert_HXT_TIMECARDS;
168
169 procedure insert_HXT_SUM_HOURS_WORKED(
170 p_rowid IN OUT NOCOPY VARCHAR2,
171 p_id NUMBER,
172 -- p_group_id NUMBER, --HXT11i1
173 p_tim_id NUMBER,
174 p_date_worked DATE,
175 p_assignment_id NUMBER,
176 p_hours NUMBER,
177 p_time_in DATE,
178 p_time_out DATE,
179 p_element_type_id NUMBER,
180 p_fcl_earn_reason_code VARCHAR2,
181 p_ffv_cost_center_id NUMBER,
182 p_ffv_labor_account_id NUMBER,
183 p_tas_id NUMBER,
184 p_location_id NUMBER,
185 p_sht_id NUMBER,
186 p_hrw_comment VARCHAR2,
187 p_ffv_rate_code_id NUMBER,
188 p_rate_multiple NUMBER,
189 p_hourly_rate NUMBER,
190 p_amount NUMBER,
191 p_fcl_tax_rule_code VARCHAR2,
192 p_separate_check_flag VARCHAR2,
193 p_seqno NUMBER,
194 p_created_by NUMBER,
195 p_creation_date DATE,
196 p_last_updated_by NUMBER,
197 p_last_update_date DATE,
198 p_last_update_login NUMBER,
199 p_actual_time_in DATE,
200 p_actual_time_out DATE,
201 p_effective_start_date DATE,
202 p_effective_end_date DATE,
203 p_project_id NUMBER, /*PROJACCT */
204 p_prev_wage_code VARCHAR2,
205 p_job_id NUMBER, /*TA35 */
206 p_earn_pol_id NUMBER, /*OVEREARN */
207 p_attribute1 VARCHAR2 DEFAULT NULL,
208 p_attribute2 VARCHAR2 DEFAULT NULL,
209 p_attribute3 VARCHAR2 DEFAULT NULL,
210 p_attribute4 VARCHAR2 DEFAULT NULL,
211 p_attribute5 VARCHAR2 DEFAULT NULL,
212 p_attribute6 VARCHAR2 DEFAULT NULL,
213 p_attribute7 VARCHAR2 DEFAULT NULL,
214 p_attribute8 VARCHAR2 DEFAULT NULL,
215 p_attribute9 VARCHAR2 DEFAULT NULL,
216 p_attribute10 VARCHAR2 DEFAULT NULL,
217 p_attribute11 VARCHAR2 DEFAULT NULL,
218 p_attribute12 VARCHAR2 DEFAULT NULL,
219 p_attribute13 VARCHAR2 DEFAULT NULL,
220 p_attribute14 VARCHAR2 DEFAULT NULL,
221 p_attribute15 VARCHAR2 DEFAULT NULL,
222 p_attribute16 VARCHAR2 DEFAULT NULL,
223 p_attribute17 VARCHAR2 DEFAULT NULL,
224 p_attribute18 VARCHAR2 DEFAULT NULL,
225 p_attribute19 VARCHAR2 DEFAULT NULL,
226 p_attribute20 VARCHAR2 DEFAULT NULL,
227 p_attribute21 VARCHAR2 DEFAULT NULL,
228 p_attribute22 VARCHAR2 DEFAULT NULL,
229 p_attribute23 VARCHAR2 DEFAULT NULL,
230 p_attribute24 VARCHAR2 DEFAULT NULL,
231 p_attribute25 VARCHAR2 DEFAULT NULL,
232 p_attribute26 VARCHAR2 DEFAULT NULL,
233 p_attribute27 VARCHAR2 DEFAULT NULL,
234 p_attribute28 VARCHAR2 DEFAULT NULL,
235 p_attribute29 VARCHAR2 DEFAULT NULL,
236 p_attribute30 VARCHAR2 DEFAULT NULL,
237 p_attribute_category VARCHAR2 DEFAULT NULL,
238 p_time_building_block_id NUMBER DEFAULT NULL,
239 p_time_building_block_ovn NUMBER DEFAULT NULL,
240 p_object_version_number out nocopy number,
241 p_STATE_NAME VARCHAR2 DEFAULT NULL,
242 p_COUNTY_NAME VARCHAR2 DEFAULT NULL,
243 p_CITY_NAME VARCHAR2 DEFAULT NULL,
244 p_ZIP_CODE VARCHAR2 DEFAULT NULL
245 ) is
246
247 cursor c2 is select rowid
248 from hxt_sum_hours_worked_f
249 where effective_start_date = p_effective_start_date
250 and effective_end_date = p_effective_end_date
251 and id = p_id;
252
253 begin
254
255 p_object_version_number := 1;
256
257 insert into HXT_SUM_HOURS_WORKED_F(
258 id,
259 -- group_id, --HXT11i1
260 tim_id,
261 date_worked,
262 assignment_id,
263 hours,
264 time_in,
265 time_out,
266 element_type_id,
267 fcl_earn_reason_code,
268 ffv_cost_center_id,
269 /*TA36ffv_labor_account_id,*/
270 tas_id,
271 location_id,
272 sht_id,
273 hrw_comment,
274 ffv_rate_code_id,
275 rate_multiple,
276 hourly_rate,
277 amount,
278 fcl_tax_rule_code,
279 separate_check_flag,
280 seqno,
281 created_by,
282 creation_date,
283 last_updated_by,
284 last_update_date,
285 last_update_login,
286 actual_time_in,
287 actual_time_out,
288 effective_start_date,
289 effective_end_date,
290 project_id, /*PROJACCT */
291 prev_wage_code,
292 job_id, /*TA35 */
293 earn_pol_id, /*OVEREARN */
294 attribute1,
295 attribute2,
296 attribute3,
297 attribute4,
298 attribute5,
299 attribute6,
300 attribute7,
301 attribute8,
302 attribute9,
303 attribute10,
304 attribute11,
305 attribute12,
306 attribute13,
307 attribute14,
308 attribute15,
309 attribute16,
310 attribute17,
311 attribute18,
312 attribute19,
313 attribute20,
314 attribute21,
315 attribute22,
316 attribute23,
317 attribute24,
318 attribute25,
319 attribute26,
320 attribute27,
321 attribute28,
322 attribute29,
323 attribute30,
324 attribute_category,
325 time_building_block_id,
326 time_building_block_ovn,
327 object_version_number,
328 STATE_NAME,
329 COUNTY_NAME ,
330 CITY_NAME,
331 ZIP_CODE)
332 VALUES(p_id,
333 -- p_group_id, --HXT11i1
334 p_tim_id,
335 p_date_worked,
336 p_assignment_id,
337 p_hours,
338 p_time_in,
339 p_time_out,
340 p_element_type_id,
341 p_fcl_earn_reason_code,
342 p_ffv_cost_center_id,
343 /*TA36p_ffv_labor_account_id,*/
344 p_tas_id,
345 p_location_id,
346 p_sht_id,
347 p_hrw_comment,
348 p_ffv_rate_code_id,
349 p_rate_multiple,
350 p_hourly_rate,
351 p_amount,
352 p_fcl_tax_rule_code,
353 p_separate_check_flag,
354 p_seqno,
355 p_created_by,
356 p_creation_date,
357 p_last_updated_by,
358 p_last_update_date,
359 p_last_update_login,
360 p_actual_time_in,
361 p_actual_time_out,
362 p_effective_start_date,
363 p_effective_end_date,
364 p_project_id, /*PROJACCT */
365 p_prev_wage_code,
366 p_job_id, /*TA35 */
367 p_earn_pol_id, /*OVEREARN */
368 p_attribute1,
369 p_attribute2,
370 p_attribute3,
371 p_attribute4,
372 p_attribute5,
373 p_attribute6,
374 p_attribute7,
375 p_attribute8,
376 p_attribute9,
377 p_attribute10,
378 p_attribute11,
379 p_attribute12,
380 p_attribute13,
381 p_attribute14,
382 p_attribute15,
383 p_attribute16,
384 p_attribute17,
385 p_attribute18,
386 p_attribute19,
387 p_attribute20,
388 p_attribute21,
389 p_attribute22,
390 p_attribute23,
391 p_attribute24,
392 p_attribute25,
393 p_attribute26,
394 p_attribute27,
395 p_attribute28,
396 p_attribute29,
397 p_attribute30,
398 p_attribute_category,
399 p_time_building_block_id,
400 p_time_building_block_ovn,
401 p_object_version_number,
402 p_STATE_NAME,
403 p_COUNTY_NAME ,
404 p_CITY_NAME ,
405 p_ZIP_CODE);
406
407 open c2;
408 fetch c2 into p_rowid;
409 close c2;
410 null;
411
412 end insert_HXT_SUM_HOURS_WORKED;
413
414 procedure insert_HXT_DET_HOURS_WORKED(
415 p_rowid IN OUT NOCOPY VARCHAR2,
416 p_id NUMBER,
417 p_parent_id NUMBER,
418 p_tim_id NUMBER,
419 p_date_worked DATE,
420 p_assignment_id NUMBER,
421 p_hours NUMBER,
422 p_time_in DATE,
423 p_time_out DATE,
424 p_element_type_id NUMBER,
425 p_fcl_earn_reason_code VARCHAR2,
426 p_ffv_cost_center_id NUMBER,
427 p_ffv_labor_account_id NUMBER,
428 p_tas_id NUMBER,
429 p_location_id NUMBER,
430 p_sht_id NUMBER,
431 p_hrw_comment VARCHAR2,
432 p_ffv_rate_code_id NUMBER,
433 p_rate_multiple NUMBER,
434 p_hourly_rate NUMBER,
435 p_amount NUMBER,
436 p_fcl_tax_rule_code VARCHAR2,
437 p_separate_check_flag VARCHAR2,
438 p_seqno NUMBER,
439 p_created_by NUMBER,
440 p_creation_date DATE,
441 p_last_updated_by NUMBER,
442 p_last_update_date DATE,
443 p_last_update_login NUMBER,
444 p_actual_time_in DATE,
445 p_actual_time_out DATE,
446 p_effective_start_date DATE,
447 p_effective_end_date DATE,
448 p_project_id NUMBER, /*PROJACCT */
449 p_job_id NUMBER, /*TA35 */
450 p_earn_pol_id NUMBER, /*OVEREARN */
451 p_retro_batch_id NUMBER, /*RETROPAY */
452 p_pa_status VARCHAR2, /*RETROPA */
453 p_pay_status VARCHAR2, /*RETROPAY */
454 -- p_group_id NUMBER,
455 p_object_version_number out nocopy number,
456 p_STATE_NAME VARCHAR2 DEFAULT NULL,
457 p_COUNTY_NAME VARCHAR2 DEFAULT NULL,
458 p_CITY_NAME VARCHAR2 DEFAULT NULL,
459 p_ZIP_CODE VARCHAR2 DEFAULT NULL
460 ) is
461
462 cursor c2 is select rowid
463 from hxt_det_hours_worked_f
464 where effective_start_date = p_effective_start_date
468 begin
465 and effective_end_date = p_effective_end_date
466 and id = p_id;
467
469
470 p_object_version_number := 1;
471
472 insert into HXT_DET_HOURS_WORKED_F(
473 id,
474 parent_id,
475 tim_id,
476 date_worked,
477 assignment_id,
478 hours,
479 time_in,
480 time_out,
481 element_type_id,
482 fcl_earn_reason_code,
483 ffv_cost_center_id,
484 /*TA36ffv_labor_account_id,*/
485 tas_id,
486 location_id,
487 sht_id,
488 hrw_comment,
489 ffv_rate_code_id,
490 rate_multiple,
491 hourly_rate,
492 amount,
493 fcl_tax_rule_code,
494 separate_check_flag,
495 seqno,
496 created_by,
497 creation_date,
498 last_updated_by,
499 last_update_date,
500 last_update_login,
501 actual_time_in,
502 actual_time_out,
503 effective_start_date,
504 effective_end_date,
505 project_id, /*PROJACCT */
506 job_id, /*TA35 */
507 earn_pol_id, /*OVEREARN */
508 retro_batch_id, /*RETROPAY */
509 pa_status, /*RETROPA */
510 pay_status, /*RETROPAY */
511 -- group_id,
512 object_version_number,
513 STATE_NAME ,
514 COUNTY_NAME ,
515 CITY_NAME ,
516 ZIP_CODE
517 )
518 VALUES(
519 p_id,
520 p_parent_id,
521 p_tim_id,
522 p_date_worked,
523 p_assignment_id,
524 p_hours,
525 p_time_in,
526 p_time_out,
527 p_element_type_id,
528 p_fcl_earn_reason_code,
529 p_ffv_cost_center_id,
530 /*TA36p_ffv_labor_account_id,*/
531 p_tas_id,
532 p_location_id,
533 p_sht_id,
534 p_hrw_comment,
535 p_ffv_rate_code_id,
536 p_rate_multiple,
537 p_hourly_rate,
538 p_amount,
539 p_fcl_tax_rule_code,
540 p_separate_check_flag,
541 p_seqno,
542 p_created_by,
543 p_creation_date,
544 p_last_updated_by,
545 p_last_update_date,
546 p_last_update_login,
547 p_actual_time_in,
548 p_actual_time_out,
549 p_effective_start_date,
550 p_effective_end_date,
551 p_project_id, /*PROJACCT */
552 p_job_id, /*TA35 */
553 p_earn_pol_id, /*OVEREARN */
554 p_retro_batch_id, /*RETROPAY */
555 p_pa_status, /*RETROPA */
556 p_pay_status, /*RETROPAY */
557 -- p_group_id,
558 p_object_version_number,
559 p_STATE_NAME ,
560 p_COUNTY_NAME,
561 p_CITY_NAME ,
562 p_ZIP_CODE
563 );
564
565 open c2;
566 fetch c2 into p_rowid;
567 close c2;
568 null;
569
570 end insert_HXT_DET_HOURS_WORKED;
571
572
573 procedure update_HXT_TIMECARDS(
574 p_rowid IN VARCHAR2,
575 p_id NUMBER,
576 p_for_person_id NUMBER,
577 p_time_period_id NUMBER,
578 p_auto_gen_flag VARCHAR2,
579 p_batch_id NUMBER,
580 p_approv_person_id NUMBER,
581 p_approved_timestamp DATE,
582 p_created_by NUMBER,
583 p_creation_date DATE,
584 p_last_updated_by NUMBER,
585 p_last_update_date DATE,
586 p_last_update_login NUMBER,
587 p_payroll_id NUMBER,
588 p_status VARCHAR2,
589 p_effective_start_date DATE,
590 p_effective_end_date DATE,
591 p_attribute1 VARCHAR2 DEFAULT NULL,
592 p_attribute2 VARCHAR2 DEFAULT NULL,
593 p_attribute3 VARCHAR2 DEFAULT NULL,
594 p_attribute4 VARCHAR2 DEFAULT NULL,
595 p_attribute5 VARCHAR2 DEFAULT NULL,
596 p_attribute6 VARCHAR2 DEFAULT NULL,
597 p_attribute7 VARCHAR2 DEFAULT NULL,
598 p_attribute8 VARCHAR2 DEFAULT NULL,
599 p_attribute9 VARCHAR2 DEFAULT NULL,
600 p_attribute10 VARCHAR2 DEFAULT NULL,
601 p_attribute11 VARCHAR2 DEFAULT NULL,
602 p_attribute12 VARCHAR2 DEFAULT NULL,
603 p_attribute13 VARCHAR2 DEFAULT NULL,
604 p_attribute14 VARCHAR2 DEFAULT NULL,
605 p_attribute15 VARCHAR2 DEFAULT NULL,
606 p_attribute16 VARCHAR2 DEFAULT NULL,
607 p_attribute17 VARCHAR2 DEFAULT NULL,
608 p_attribute18 VARCHAR2 DEFAULT NULL,
609 p_attribute19 VARCHAR2 DEFAULT NULL,
610 p_attribute20 VARCHAR2 DEFAULT NULL,
611 p_attribute21 VARCHAR2 DEFAULT NULL,
612 p_attribute22 VARCHAR2 DEFAULT NULL,
613 p_attribute23 VARCHAR2 DEFAULT NULL,
614 p_attribute24 VARCHAR2 DEFAULT NULL,
615 p_attribute25 VARCHAR2 DEFAULT NULL,
616 p_attribute26 VARCHAR2 DEFAULT NULL,
617 p_attribute27 VARCHAR2 DEFAULT NULL,
618 p_attribute28 VARCHAR2 DEFAULT NULL,
619 p_attribute29 VARCHAR2 DEFAULT NULL,
620 p_attribute30 VARCHAR2 DEFAULT NULL,
621 p_attribute_category VARCHAR2 DEFAULT NULL,
622 p_object_version_number in out nocopy number
623 ) is
624
625 begin
626
627 p_object_version_number := p_object_version_number + 1;
628
629 update HXT_TIMECARDS_F
630 set
631 for_person_id = p_for_person_id,
632 time_period_id = p_time_period_id,
633 auto_gen_flag = p_auto_gen_flag,
634 batch_id = p_batch_id,
635 approv_person_id = p_approv_person_id,
639 last_updated_by = p_last_updated_by,
636 approved_timestamp = p_approved_timestamp,
637 created_by = p_created_by,
638 creation_date = p_creation_date,
640 last_update_date = p_last_update_date,
641 last_update_login = p_last_update_login,
642 payroll_id = p_payroll_id,
643 --status = p_status,
644 effective_start_date = p_effective_start_date,
645 effective_end_date = p_effective_end_date,
646 attribute1 = p_attribute1,
647 attribute2 = p_attribute2,
648 attribute3 = p_attribute3,
649 attribute4 = p_attribute4,
650 attribute5 = p_attribute5,
651 attribute6 = p_attribute6,
652 attribute7 = p_attribute7,
653 attribute8 = p_attribute8,
654 attribute9 = p_attribute9,
655 attribute10 = p_attribute10,
656 attribute11 = p_attribute11,
657 attribute12 = p_attribute12,
658 attribute13 = p_attribute13,
659 attribute14 = p_attribute14,
660 attribute15 = p_attribute15,
661 attribute16 = p_attribute16,
662 attribute17 = p_attribute17,
663 attribute18 = p_attribute18,
664 attribute19 = p_attribute19,
665 attribute20 = p_attribute20,
666 attribute21 = p_attribute21,
667 attribute22 = p_attribute22,
668 attribute23 = p_attribute23,
669 attribute24 = p_attribute24,
670 attribute25 = p_attribute25,
671 attribute26 = p_attribute26,
672 attribute27 = p_attribute27,
673 attribute28 = p_attribute28,
674 attribute29 = p_attribute29,
675 attribute30 = p_attribute30,
676 attribute_category = p_attribute_category,
677 object_version_number = p_object_version_number
678 where rowid = p_rowid;
679
680 end update_HXT_TIMECARDS;
681
682 procedure update_HXT_SUM_HOURS_WORKED(
683 p_rowid IN VARCHAR2,
684 p_id NUMBER,
685 -- p_group_id NUMBER, --HXT11i1
686 p_tim_id NUMBER,
687 p_date_worked DATE,
688 p_assignment_id NUMBER,
689 p_hours NUMBER,
690 p_time_in DATE,
691 p_time_out DATE,
692 p_element_type_id NUMBER,
693 p_fcl_earn_reason_code VARCHAR2,
694 p_ffv_cost_center_id NUMBER,
695 p_ffv_labor_account_id NUMBER,
696 p_tas_id NUMBER,
697 p_location_id NUMBER,
698 p_sht_id NUMBER,
699 p_hrw_comment VARCHAR2,
700 p_ffv_rate_code_id NUMBER,
701 p_rate_multiple NUMBER,
702 p_hourly_rate NUMBER,
703 p_amount NUMBER,
704 p_fcl_tax_rule_code VARCHAR2,
705 p_separate_check_flag VARCHAR2,
706 p_seqno NUMBER,
707 p_created_by NUMBER,
708 p_creation_date DATE,
709 p_last_updated_by NUMBER,
710 p_last_update_date DATE,
711 p_last_update_login NUMBER,
712 p_actual_time_in DATE,
713 p_actual_time_out DATE,
714 p_effective_start_date DATE,
715 p_effective_end_date DATE,
716 p_project_id NUMBER, /*PROJACCT */
717 p_prev_wage_code VARCHAR2,
718 p_job_id NUMBER, /*TA35 */
719 p_earn_pol_id NUMBER, /*OVEREARN */
720 p_attribute1 VARCHAR2 DEFAULT NULL,
721 p_attribute2 VARCHAR2 DEFAULT NULL,
722 p_attribute3 VARCHAR2 DEFAULT NULL,
723 p_attribute4 VARCHAR2 DEFAULT NULL,
724 p_attribute5 VARCHAR2 DEFAULT NULL,
725 p_attribute6 VARCHAR2 DEFAULT NULL,
726 p_attribute7 VARCHAR2 DEFAULT NULL,
727 p_attribute8 VARCHAR2 DEFAULT NULL,
728 p_attribute9 VARCHAR2 DEFAULT NULL,
729 p_attribute10 VARCHAR2 DEFAULT NULL,
730 p_attribute11 VARCHAR2 DEFAULT NULL,
731 p_attribute12 VARCHAR2 DEFAULT NULL,
732 p_attribute13 VARCHAR2 DEFAULT NULL,
733 p_attribute14 VARCHAR2 DEFAULT NULL,
734 p_attribute15 VARCHAR2 DEFAULT NULL,
735 p_attribute16 VARCHAR2 DEFAULT NULL,
736 p_attribute17 VARCHAR2 DEFAULT NULL,
737 p_attribute18 VARCHAR2 DEFAULT NULL,
738 p_attribute19 VARCHAR2 DEFAULT NULL,
739 p_attribute20 VARCHAR2 DEFAULT NULL,
740 p_attribute21 VARCHAR2 DEFAULT NULL,
741 p_attribute22 VARCHAR2 DEFAULT NULL,
742 p_attribute23 VARCHAR2 DEFAULT NULL,
743 p_attribute24 VARCHAR2 DEFAULT NULL,
744 p_attribute25 VARCHAR2 DEFAULT NULL,
745 p_attribute26 VARCHAR2 DEFAULT NULL,
746 p_attribute27 VARCHAR2 DEFAULT NULL,
747 p_attribute28 VARCHAR2 DEFAULT NULL,
748 p_attribute29 VARCHAR2 DEFAULT NULL,
749 p_attribute30 VARCHAR2 DEFAULT NULL,
750 p_attribute_category VARCHAR2 DEFAULT NULL,
751 p_time_building_block_id NUMBER DEFAULT NULL,
752 p_time_building_block_ovn NUMBER DEFAULT NULL,
753 p_object_version_number in out nocopy number,
754 p_STATE_NAME VARCHAR2 DEFAULT NULL,
755 p_COUNTY_NAME VARCHAR2 DEFAULT NULL,
756 p_CITY_NAME VARCHAR2 DEFAULT NULL,
757 p_ZIP_CODE VARCHAR2 DEFAULT NULL
758 ) is
759
760 begin
761
762 p_object_version_number := p_object_version_number + 1;
763
764 update HXT_SUM_HOURS_WORKED_F
765 set
766 -- group_id = p_group_id, --HXT11i1
767 date_worked = p_date_worked,
768 assignment_id = p_assignment_id,
769 hours = p_hours,
770 time_in = p_time_in,
774 ffv_cost_center_id = p_ffv_cost_center_id,
771 time_out = p_time_out,
772 element_type_id = p_element_type_id,
773 fcl_earn_reason_code = p_fcl_earn_reason_code,
775 tas_id = p_tas_id,
776 location_id = p_location_id,
777 sht_id = p_sht_id,
778 hrw_comment = p_hrw_comment,
779 ffv_rate_code_id = p_ffv_rate_code_id,
780 rate_multiple = p_rate_multiple,
781 hourly_rate = p_hourly_rate,
782 amount = p_amount,
783 fcl_tax_rule_code = p_fcl_tax_rule_code,
784 separate_check_flag = p_separate_check_flag,
785 seqno = p_seqno,
786 created_by = p_created_by,
787 creation_date = p_creation_date,
788 last_updated_by = p_last_updated_by,
789 last_update_date = p_last_update_date,
790 last_update_login = p_last_update_login,
791 actual_time_in = p_actual_time_in,
792 actual_time_out = p_actual_time_out,
793 effective_start_date = p_effective_start_date,
794 effective_end_date = p_effective_end_date,
795 project_id = p_project_id, /*PROJACCT */
796 prev_wage_code = p_prev_wage_code,
797 job_id = p_job_id, /*TA35 */
798 earn_pol_id = p_earn_pol_id, /*OVEREARN */
799 attribute1 = p_attribute1,
800 attribute2 = p_attribute2,
801 attribute3 = p_attribute3,
802 attribute4 = p_attribute4,
803 attribute5 = p_attribute5,
804 attribute6 = p_attribute6,
805 attribute7 = p_attribute7,
806 attribute8 = p_attribute8,
807 attribute9 = p_attribute9,
808 attribute10 = p_attribute10,
809 attribute11 = p_attribute11,
810 attribute12 = p_attribute12,
811 attribute13 = p_attribute13,
812 attribute14 = p_attribute14,
813 attribute15 = p_attribute15,
814 attribute16 = p_attribute16,
815 attribute17 = p_attribute17,
816 attribute18 = p_attribute18,
817 attribute19 = p_attribute19,
818 attribute20 = p_attribute20,
819 attribute21 = p_attribute21,
820 attribute22 = p_attribute22,
821 attribute23 = p_attribute23,
822 attribute24 = p_attribute24,
823 attribute25 = p_attribute25,
824 attribute26 = p_attribute26,
825 attribute27 = p_attribute27,
826 attribute28 = p_attribute28,
827 attribute29 = p_attribute29,
828 attribute30 = p_attribute30,
829 attribute_category = p_attribute_category,
830 time_building_block_id = nvl(p_time_building_block_id, time_building_block_id),
831 time_building_block_ovn = nvl(p_time_building_block_ovn, time_building_block_ovn),
832 object_version_number = p_object_version_number,
833 STATE_NAME = p_STATE_NAME,
834 COUNTY_NAME=p_COUNTY_NAME,
835 CITY_NAME =p_CITY_NAME ,
836 ZIP_CODE=p_ZIP_CODE
837 where rowid = p_rowid;
838
839 end update_HXT_SUM_HOURS_WORKED;
840
841 procedure update_HXT_DET_HOURS_WORKED(
842 p_rowid IN VARCHAR2,
843 p_id NUMBER,
844 p_parent_id NUMBER,
845 p_tim_id NUMBER,
846 p_date_worked DATE,
847 p_assignment_id NUMBER,
848 p_hours NUMBER,
849 p_time_in DATE,
850 p_time_out DATE,
851 p_element_type_id NUMBER,
852 p_fcl_earn_reason_code VARCHAR2,
853 p_ffv_cost_center_id NUMBER,
854 p_ffv_labor_account_id NUMBER,
855 p_tas_id NUMBER,
856 p_location_id NUMBER,
857 p_sht_id NUMBER,
858 p_hrw_comment VARCHAR2,
859 p_ffv_rate_code_id NUMBER,
860 p_rate_multiple NUMBER,
861 p_hourly_rate NUMBER,
862 p_amount NUMBER,
863 p_fcl_tax_rule_code VARCHAR2,
864 p_separate_check_flag VARCHAR2,
865 p_seqno NUMBER,
866 p_created_by NUMBER,
867 p_creation_date DATE,
868 p_last_updated_by NUMBER,
869 p_last_update_date DATE,
870 p_last_update_login NUMBER,
871 p_actual_time_in DATE,
872 p_actual_time_out DATE,
873 p_effective_start_date DATE,
874 p_effective_end_date DATE,
875 p_project_id NUMBER, /*PROJACCT */
876 p_job_id NUMBER,
877 p_earn_pol_id NUMBER, /*OVEREARN */
878 p_retro_batch_id NUMBER, /*RETROPAY */
879 p_pa_status VARCHAR2, /*RETROPA */
880 p_pay_status VARCHAR2, /*RETROPAY */
881 -- p_group_id NUMBER,
882 p_object_version_number in out nocopy number,
883 p_STATE_NAME VARCHAR2 DEFAULT NULL,
884 p_COUNTY_NAME VARCHAR2 DEFAULT NULL,
885 p_CITY_NAME VARCHAR2 DEFAULT NULL,
886 p_ZIP_CODE VARCHAR2 DEFAULT NULL
887 ) is
888
889 BEGIN
890
891 p_object_version_number := p_object_version_number + 1;
892
893 UPDATE hxt_det_hours_worked_f
894 SET
895 date_worked = p_date_worked,
896 assignment_id = p_assignment_id,
897 hours = p_hours,
898 time_in = p_time_in,
899 time_out = p_time_out,
900 element_type_id = p_element_type_id,
901 fcl_earn_reason_code = p_fcl_earn_reason_code,
902 ffv_cost_center_id = p_ffv_cost_center_id,
903 tas_id = p_tas_id,
904 location_id = p_location_id,
905 sht_id = p_sht_id,
906 hrw_comment = p_hrw_comment,
907 ffv_rate_code_id = p_ffv_rate_code_id,
908 rate_multiple = p_rate_multiple,
909 hourly_rate = p_hourly_rate,
910 amount = p_amount,
911 fcl_tax_rule_code = p_fcl_tax_rule_code,
912 separate_check_flag = p_separate_check_flag,
913 seqno = p_seqno,
914 created_by = p_created_by,
915 creation_date = p_creation_date,
916 last_updated_by = p_last_updated_by,
917 last_update_date = p_last_update_date,
918 last_update_login = p_last_update_login,
919 actual_time_in = p_actual_time_in,
920 actual_time_out = p_actual_time_out,
921 effective_start_date = p_effective_start_date,
922 effective_end_date = p_effective_end_date,
923 project_id = p_project_id, /*PROJACCT */
924 job_id = p_job_id,
925 earn_pol_id = p_earn_pol_id, /*OVEREARN */
926 retro_batch_id = p_retro_batch_id, /*RETROPAY */
927 pa_status = p_pa_status, /*RETROPA */
928 pay_status = p_pay_status, /*RETROPAY */
929 -- group_id = p_group_id,
930 object_version_number = p_object_version_number,
931 STATE_NAME =p_STATE_NAME,
932 COUNTY_NAME =p_COUNTY_NAME,
933 CITY_NAME =p_CITY_NAME,
934 ZIP_CODE =p_ZIP_CODE
935 WHERE rowid = p_rowid;
936
937 END update_HXT_DET_HOURS_WORKED;
938
939
940 procedure delete_HXT_TIMECARDS(p_rowid VARCHAR2) is
941 begin
942 delete from HXT_TIMECARDS_F
943 where rowid=chartorowid(p_rowid);
944 end delete_HXT_TIMECARDS;
945
946 procedure delete_HXT_SUM_HOURS_WORKED(p_rowid VARCHAR2) is
947 begin
948 delete from HXT_SUM_HOURS_WORKED_F
949 where rowid=chartorowid(p_rowid);
950 end delete_HXT_SUM_HOURS_WORKED;
951
952 procedure delete_HXT_DET_HOURS_WORKED(p_rowid VARCHAR2) is
953 begin
954 delete from HXT_DET_HOURS_WORKED_F
955 where rowid=chartorowid(p_rowid);
956 end delete_HXT_DET_HOURS_WORKED;
957
958
959 procedure lock_HXT_TIMECARDS(p_rowid VARCHAR2) is
960 vnull number;
961 begin
962 if p_rowid is not null then
963 select FOR_PERSON_ID into vnull
964 from hxt_timecards_f
965 where rowid = p_rowid
966 for update of hxt_timecards_f.FOR_PERSON_ID nowait;
967
968 end if;
969 end lock_HXT_TIMECARDS;
970
971 procedure lock_HXT_SUM_HOURS_WORKED(p_rowid VARCHAR2) is
972 vnull number;
973 begin
974 if p_rowid is not null then
975 select ASSIGNMENT_ID into vnull
976 from hxt_sum_hours_worked_f
977 where rowid = p_rowid
978 for update of hxt_sum_hours_worked_f.ASSIGNMENT_ID nowait;
979
980 end if;
981 end lock_HXT_SUM_HOURS_WORKED;
982
983 procedure lock_HXT_DET_HOURS_WORKED(p_rowid VARCHAR2) is
984 vnull number;
985 begin
986 if p_rowid is not null then
987 select ASSIGNMENT_ID into vnull
988 from hxt_det_hours_worked_f
989 where rowid = p_rowid
990 for update of hxt_det_hours_worked_f.ASSIGNMENT_ID nowait;
991
992 end if;
993 end lock_HXT_DET_HOURS_WORKED;
994
995 end HXT_DML;