APPS.HXT_TIME_SUMMARY dependencies on HXT_ERRORS

Line 1045: l_location hxt_errors.location%TYPE;

1041: WHERE tim_id=g_tim_id
1042: AND pay_status = 'C';
1043:
1044: l_completed_time_card VARCHAR2(1) := 'N';
1045: l_location hxt_errors.location%TYPE;
1046:
1047: BEGIN
1048:
1049: if g_debug then

Line 1064: DELETE from hxt_errors_f where --SPR C153

1060: end if;
1061: DELETE from hxt_det_hours_worked_f
1062: WHERE parent_id = g_id;
1063:
1064: DELETE from hxt_errors_f where --SPR C153
1065: hrw_id = g_id; --SPR C153
1066: ELSE
1067: if g_debug then
1068: hr_utility.set_location('hxt_time_summary.Delete_Details',30);

Line 1080: UPDATE hxt_errors_f

1076: WHERE rowid in (
1077: SELECT rowid
1078: FROM hxt_det_hours_worked
1079: WHERE parent_id = g_id);
1080: UPDATE hxt_errors_f
1081: SET effective_end_date = g_effective_start_date - 1
1082: WHERE rowid in (
1083: SELECT rowid
1084: FROM hxt_errors

Line 1084: FROM hxt_errors

1080: UPDATE hxt_errors_f
1081: SET effective_end_date = g_effective_start_date - 1
1082: WHERE rowid in (
1083: SELECT rowid
1084: FROM hxt_errors
1085: WHERE hrw_id = g_id);
1086:
1087: END IF;--absence and not in include group or not
1088:

Line 1198: l_location hxt_errors.location%TYPE;

1194: --Rebuilds details for a person for this summary record.
1195:
1196: --Define local variables
1197: l_error_code NUMBER := 0;
1198: l_location hxt_errors.location%TYPE;
1199: l_shift_adjusted_time_in DATE;
1200: l_shift_adjusted_time_out DATE;
1201: original_record_id NUMBER := g_ID;
1202: change_warning_flag NUMBER := 0;