153: );
154:
155: FUNCTION sum_unexploded_hours (
156: p_tim_id IN hxt_timecards.id%TYPE,
157: p_day IN hxt_det_hours_worked_f.date_worked%TYPE,
158: p_hours_type IN hxt_det_hours_worked_f.hours%TYPE DEFAULT NULL
159: )
160: RETURN NUMBER;
161:
154:
155: FUNCTION sum_unexploded_hours (
156: p_tim_id IN hxt_timecards.id%TYPE,
157: p_day IN hxt_det_hours_worked_f.date_worked%TYPE,
158: p_hours_type IN hxt_det_hours_worked_f.hours%TYPE DEFAULT NULL
159: )
160: RETURN NUMBER;
161:
162: PROCEDURE holiday_mismatch (