17: l_no_details EXCEPTION;
18: l_batch_state EXCEPTION;
19: l_conc_error_flag BOOLEAN DEFAULT FALSE;
20: l_any_timecards BOOLEAN DEFAULT FALSE;
21: l_sum_start_date hxt_sum_hours_worked_f.effective_start_date%TYPE;
22: l_sum_end_date hxt_sum_hours_worked_f.effective_end_date%TYPE;
23: l_sum_id hxt_sum_hours_worked_f.id%TYPE;
24:
25:
18: l_batch_state EXCEPTION;
19: l_conc_error_flag BOOLEAN DEFAULT FALSE;
20: l_any_timecards BOOLEAN DEFAULT FALSE;
21: l_sum_start_date hxt_sum_hours_worked_f.effective_start_date%TYPE;
22: l_sum_end_date hxt_sum_hours_worked_f.effective_end_date%TYPE;
23: l_sum_id hxt_sum_hours_worked_f.id%TYPE;
24:
25:
26: -- Cursor to select each timecard within
19: l_conc_error_flag BOOLEAN DEFAULT FALSE;
20: l_any_timecards BOOLEAN DEFAULT FALSE;
21: l_sum_start_date hxt_sum_hours_worked_f.effective_start_date%TYPE;
22: l_sum_end_date hxt_sum_hours_worked_f.effective_end_date%TYPE;
23: l_sum_id hxt_sum_hours_worked_f.id%TYPE;
24:
25:
26: -- Cursor to select each timecard within
27: -- the payroll/time-period requested