[Home] [Help]
3860: THEN
3861: hr_utility.set_location (l_proc, 50);
3862: END IF;
3863:
3864: hxt_util.get_shift_info (l_hol_rec.holiday_date,
3865: l_work_id,
3866: i_hxt_rotation_plan,
3867: l_osp_id,
3868: l_sdf_id,
4183: hr_utility.set_location (l_proc, 20);
4184: END IF;
4185:
4186: p_egp_id := p_summ_earn_pol_id;
4187: hxt_util.get_policies (p_egp_id,
4188: p_summ_assignment_id,
4189: p_summ_date_worked,
4190: p_work_plan,
4191: p_rotation_plan,
4239: hr_utility.set_location (l_proc, 70);
4240: END IF;
4241:
4242: -- Get premiums for shift
4243: hxt_util.get_shift_info (p_summ_date_worked,
4244: p_work_plan,
4245: p_rotation_plan,
4246: p_osp_id,
4247: p_sdf_id,
4282: END;
4283: -- Get holiday earning, day before/after, etc
4284: /* BEGIN
4285:
4286: HXT_UTIL.Check_For_Holiday
4287: (p_summ_date_worked
4288: , p_hcl_id
4289: , p_hdy_id
4290: , p_hours
4736: END IF;
4737:
4738: /*Obtain the next sequence number for hours worked on this day*/
4739: l_sequence_number :=
4740: hxt_util.get_next_seqno (i_timecard_id, i_date_worked);
4741:
4742: IF g_debug
4743: THEN
4744: hr_utility.TRACE ('l_sequence_number :' || l_sequence_number);
5748: OR i_cost_segment29 IS NOT NULL
5749: OR i_cost_segment30 IS NOT NULL
5750: THEN
5751: l_retcode :=
5752: hxt_util.build_cost_alloc_flex_entry (i_cost_segment1,
5753: i_cost_segment2,
5754: i_cost_segment3,
5755: i_cost_segment4,
5756: i_cost_segment5,
6138: THEN
6139: hr_utility.set_location (l_proc, 40);
6140: END IF;
6141:
6142: hxt_util.get_shift_info (p_date_worked,
6143: l_work_id,
6144: l_rot_id,
6145: l_osp_id,
6146: l_sdf_id,
6187: 'MI'
6188: );*/
6189: l_early_date :=
6190: TRUNC (p_date_worked)
6191: + hxt_util.time_to_hours (l_early_start) / 24;
6192: /* TO_DATE (
6193: TO_CHAR (p_date_worked, 'DD-MM-YYYY ')
6194: || TO_CHAR (l_early_start, '0009'),
6195: 'DD-MM-YYYY HH24MI'
6195: 'DD-MM-YYYY HH24MI'
6196: );*/
6197: l_std_date_start :=
6198: TRUNC (p_date_worked)
6199: + hxt_util.time_to_hours (l_standard_start) / 24;
6200:
6201: /* TO_DATE (
6202: TO_CHAR (
6203: p_date_worked,
6280: IF l_late_stop IS NOT NULL
6281: THEN
6282: l_late_date :=
6283: TRUNC (p_date_worked)
6284: + hxt_util.time_to_hours (l_late_stop) / 24;
6285:
6286: IF g_debug
6287: THEN
6288: hr_utility.TRACE ( 'l_late_date :'
6299: 'DD-MM-YYYY HH24MI'
6300: );*/
6301: l_std_date_stop :=
6302: TRUNC (p_date_worked)
6303: + hxt_util.time_to_hours (l_standard_stop) / 24;
6304:
6305: /* TO_DATE (
6306: TO_CHAR (p_date_worked, 'DD-MM-YYYY ')
6307: || TO_CHAR (l_standard_stop, '0009'),
6351: IF l_late_stop IS NOT NULL
6352: THEN
6353: l_late_date :=
6354: TRUNC (l_time_out_date)
6355: + hxt_util.time_to_hours (l_late_stop) / 24;
6356:
6357: IF g_debug
6358: THEN
6359: hr_utility.TRACE
6367: END IF;
6368:
6369: l_std_date_stop :=
6370: TRUNC (l_time_out_date)
6371: + hxt_util.time_to_hours (l_standard_stop) / 24;
6372:
6373: IF g_debug
6374: THEN
6375: hr_utility.TRACE ( 'l_time_out_date :'
6426: END IF;
6427:
6428: l_late_date :=
6429: TRUNC (l_time_out_date)
6430: + hxt_util.time_to_hours (l_late_stop) / 24;
6431: l_std_date_stop :=
6432: TRUNC (l_time_out_date)
6433: + hxt_util.time_to_hours (l_standard_stop) / 24;
6434:
6429: TRUNC (l_time_out_date)
6430: + hxt_util.time_to_hours (l_late_stop) / 24;
6431: l_std_date_stop :=
6432: TRUNC (l_time_out_date)
6433: + hxt_util.time_to_hours (l_standard_stop) / 24;
6434:
6435: IF g_debug
6436: THEN
6437: hr_utility.TRACE ( 'l_time_out_date :'
6736:
6737: IF p_timecard_source = 'Time Store'
6738: THEN
6739: l_valid_entry :=
6740: hxt_util.is_valid_time_entry
6741: (l_time_in_actual, -- p_actual_time_in,
6742: p_time_in,
6743: l_time_out_actual, -- p_actual_time_out,
6744: p_time_out