APPS.HXT_RETRO_PA dependencies on HXT_SUM_HOURS_WORKED_F

Line 14: l_sum_start_date hxt_sum_hours_worked_f.effective_start_date%TYPE;

10: l_retcode NUMBER DEFAULT 0;
11: l_error_text VARCHAR2(240) DEFAULT NULL;
12: l_system_text VARCHAR2(120) DEFAULT NULL;
13: l_location VARCHAR2(120) DEFAULT NULL;
14: l_sum_start_date hxt_sum_hours_worked_f.effective_start_date%TYPE;
15: l_sum_end_date hxt_sum_hours_worked_f.effective_end_date%TYPE;
16: l_sum_id hxt_sum_hours_worked_f.id%TYPE;
17: l_ewr_error EXCEPTION;
18: l_non_ewr_error EXCEPTION;

Line 15: l_sum_end_date hxt_sum_hours_worked_f.effective_end_date%TYPE;

11: l_error_text VARCHAR2(240) DEFAULT NULL;
12: l_system_text VARCHAR2(120) DEFAULT NULL;
13: l_location VARCHAR2(120) DEFAULT NULL;
14: l_sum_start_date hxt_sum_hours_worked_f.effective_start_date%TYPE;
15: l_sum_end_date hxt_sum_hours_worked_f.effective_end_date%TYPE;
16: l_sum_id hxt_sum_hours_worked_f.id%TYPE;
17: l_ewr_error EXCEPTION;
18: l_non_ewr_error EXCEPTION;
19: l_conc_error EXCEPTION;

Line 16: l_sum_id hxt_sum_hours_worked_f.id%TYPE;

12: l_system_text VARCHAR2(120) DEFAULT NULL;
13: l_location VARCHAR2(120) DEFAULT NULL;
14: l_sum_start_date hxt_sum_hours_worked_f.effective_start_date%TYPE;
15: l_sum_end_date hxt_sum_hours_worked_f.effective_end_date%TYPE;
16: l_sum_id hxt_sum_hours_worked_f.id%TYPE;
17: l_ewr_error EXCEPTION;
18: l_non_ewr_error EXCEPTION;
19: l_conc_error EXCEPTION;
20: l_no_timecards EXCEPTION;