APPS.HXT_TIME_SUMMARY dependencies on HXT_ERRORS

Line 2322: l_location hxt_errors.location%TYPE;

2318: WHERE tim_id=g_tim_id
2319: AND pay_status = 'C';
2320:
2321: l_completed_time_card VARCHAR2(1) := 'N';
2322: l_location hxt_errors.location%TYPE;
2323:
2324: BEGIN
2325:
2326: if g_debug then

Line 2341: DELETE from hxt_errors_f where --SPR C153

2337: end if;
2338: DELETE from hxt_det_hours_worked_f
2339: WHERE parent_id = g_id;
2340:
2341: DELETE from hxt_errors_f where --SPR C153
2342: hrw_id = g_id; --SPR C153
2343: ELSE
2344: if g_debug then
2345: hr_utility.set_location('hxt_time_summary.Delete_Details',30);

Line 2370: UPDATE hxt_errors_f

2366: AND g_sum_session_date BETWEEN effective_start_date
2367: AND effective_end_date ;
2368:
2369:
2370: UPDATE hxt_errors_f
2371: SET effective_end_date = g_effective_start_date - 1
2372: WHERE rowid in (
2373: SELECT rowid
2374: FROM hxt_errors

Line 2374: FROM hxt_errors

2370: UPDATE hxt_errors_f
2371: SET effective_end_date = g_effective_start_date - 1
2372: WHERE rowid in (
2373: SELECT rowid
2374: FROM hxt_errors
2375: WHERE hrw_id = g_id);
2376:
2377: END IF;--absence and not in include group or not
2378:

Line 2489: l_location hxt_errors.location%TYPE;

2485: --Rebuilds details for a person for this summary record.
2486:
2487: --Define local variables
2488: l_error_code NUMBER := 0;
2489: l_location hxt_errors.location%TYPE;
2490: l_shift_adjusted_time_in DATE;
2491: l_shift_adjusted_time_out DATE;
2492: original_record_id NUMBER := g_ID;
2493: change_warning_flag NUMBER := 0;