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