[Home] [Help]
4056: THEN
4057: hr_utility.set_location (l_proc, 50);
4058: END IF;
4059:
4060: hxt_util.get_shift_info (l_hol_rec.holiday_date,
4061: l_work_id,
4062: i_hxt_rotation_plan,
4063: l_osp_id,
4064: l_sdf_id,
4380: hr_utility.set_location (l_proc, 20);
4381: END IF;
4382:
4383: p_egp_id := p_summ_earn_pol_id;
4384: hxt_util.get_policies (p_egp_id,
4385: p_summ_assignment_id,
4386: p_summ_date_worked,
4387: p_work_plan,
4388: p_rotation_plan,
4436: hr_utility.set_location (l_proc, 70);
4437: END IF;
4438:
4439: -- Get premiums for shift
4440: hxt_util.get_shift_info (p_summ_date_worked,
4441: p_work_plan,
4442: p_rotation_plan,
4443: p_osp_id,
4444: p_sdf_id,
4479: END;
4480: -- Get holiday earning, day before/after, etc
4481: /* BEGIN
4482:
4483: HXT_UTIL.Check_For_Holiday
4484: (p_summ_date_worked
4485: , p_hcl_id
4486: , p_hdy_id
4487: , p_hours
4959: END IF;
4960:
4961: /*Obtain the next sequence number for hours worked on this day*/
4962: l_sequence_number :=
4963: hxt_util.get_next_seqno (i_timecard_id, i_date_worked);
4964:
4965: IF g_debug
4966: THEN
4967: hr_utility.TRACE ('l_sequence_number :' || l_sequence_number);
6062: OR i_cost_segment29 IS NOT NULL
6063: OR i_cost_segment30 IS NOT NULL
6064: THEN
6065: l_retcode :=
6066: hxt_util.build_cost_alloc_flex_entry (i_cost_segment1,
6067: i_cost_segment2,
6068: i_cost_segment3,
6069: i_cost_segment4,
6070: i_cost_segment5,
6519: THEN
6520: hr_utility.set_location (l_proc, 40);
6521: END IF;
6522:
6523: hxt_util.get_shift_info (p_date_worked,
6524: l_work_id,
6525: l_rot_id,
6526: l_osp_id,
6527: l_sdf_id,
6568: 'MI'
6569: );*/
6570: l_early_date :=
6571: TRUNC (p_date_worked)
6572: + hxt_util.time_to_hours (l_early_start) / 24;
6573: /* TO_DATE (
6574: TO_CHAR (p_date_worked, 'DD-MM-YYYY ')
6575: || TO_CHAR (l_early_start, '0009'),
6576: 'DD-MM-YYYY HH24MI'
6576: 'DD-MM-YYYY HH24MI'
6577: );*/
6578: l_std_date_start :=
6579: TRUNC (p_date_worked)
6580: + hxt_util.time_to_hours (l_standard_start) / 24;
6581:
6582: /* TO_DATE (
6583: TO_CHAR (
6584: p_date_worked,
6661: IF l_late_stop IS NOT NULL
6662: THEN
6663: l_late_date :=
6664: TRUNC (p_date_worked)
6665: + hxt_util.time_to_hours (l_late_stop) / 24;
6666:
6667: IF g_debug
6668: THEN
6669: hr_utility.TRACE ( 'l_late_date :'
6680: 'DD-MM-YYYY HH24MI'
6681: );*/
6682: l_std_date_stop :=
6683: TRUNC (p_date_worked)
6684: + hxt_util.time_to_hours (l_standard_stop) / 24;
6685:
6686: /* TO_DATE (
6687: TO_CHAR (p_date_worked, 'DD-MM-YYYY ')
6688: || TO_CHAR (l_standard_stop, '0009'),
6732: IF l_late_stop IS NOT NULL
6733: THEN
6734: l_late_date :=
6735: TRUNC (l_time_out_date)
6736: + hxt_util.time_to_hours (l_late_stop) / 24;
6737:
6738: IF g_debug
6739: THEN
6740: hr_utility.TRACE
6748: END IF;
6749:
6750: l_std_date_stop :=
6751: TRUNC (l_time_out_date)
6752: + hxt_util.time_to_hours (l_standard_stop) / 24;
6753:
6754: IF g_debug
6755: THEN
6756: hr_utility.TRACE ( 'l_time_out_date :'
6807: END IF;
6808:
6809: l_late_date :=
6810: TRUNC (l_time_out_date)
6811: + hxt_util.time_to_hours (l_late_stop) / 24;
6812: l_std_date_stop :=
6813: TRUNC (l_time_out_date)
6814: + hxt_util.time_to_hours (l_standard_stop) / 24;
6815:
6810: TRUNC (l_time_out_date)
6811: + hxt_util.time_to_hours (l_late_stop) / 24;
6812: l_std_date_stop :=
6813: TRUNC (l_time_out_date)
6814: + hxt_util.time_to_hours (l_standard_stop) / 24;
6815:
6816: IF g_debug
6817: THEN
6818: hr_utility.TRACE ( 'l_time_out_date :'
7117:
7118: IF p_timecard_source = 'Time Store'
7119: THEN
7120: l_valid_entry :=
7121: hxt_util.is_valid_time_entry
7122: (l_time_in_actual, -- p_actual_time_in,
7123: p_time_in,
7124: l_time_out_actual, -- p_actual_time_out,
7125: p_time_out