224: p_lookup_description OUT NOCOPY VARCHAR2);
225: PROCEDURE check_batch_states(P_BATCH_ID IN NUMBER); --3739107
226:
227: FUNCTION is_valid_time_entry (
228: p_raw_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
229: p_rounded_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
230: p_raw_time_out IN hxt_det_hours_worked_f.time_in%TYPE,
231: p_rounded_time_out IN hxt_det_hours_worked_f.time_in%TYPE
232: )
225: PROCEDURE check_batch_states(P_BATCH_ID IN NUMBER); --3739107
226:
227: FUNCTION is_valid_time_entry (
228: p_raw_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
229: p_rounded_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
230: p_raw_time_out IN hxt_det_hours_worked_f.time_in%TYPE,
231: p_rounded_time_out IN hxt_det_hours_worked_f.time_in%TYPE
232: )
233: RETURN BOOLEAN ;
226:
227: FUNCTION is_valid_time_entry (
228: p_raw_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
229: p_rounded_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
230: p_raw_time_out IN hxt_det_hours_worked_f.time_in%TYPE,
231: p_rounded_time_out IN hxt_det_hours_worked_f.time_in%TYPE
232: )
233: RETURN BOOLEAN ;
234:
227: FUNCTION is_valid_time_entry (
228: p_raw_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
229: p_rounded_time_in IN hxt_det_hours_worked_f.time_in%TYPE,
230: p_raw_time_out IN hxt_det_hours_worked_f.time_in%TYPE,
231: p_rounded_time_out IN hxt_det_hours_worked_f.time_in%TYPE
232: )
233: RETURN BOOLEAN ;
234:
235: PROCEDURE check_timecard_exists (p_person_id IN NUMBER);