APPS.HXT_BATCH_VAL dependencies on HXT_ERRORS_X

Line 193: DELETE FROM hxt_errors_x

189: || 'delete_prev_val_errors';
190: hr_utility.set_location ( 'Entering:'
191: || l_proc, 10);
192: end if;
193: DELETE FROM hxt_errors_x
194: WHERE ppb_id = p_batch_id AND location LIKE 'Validate%';
195:
196: if g_debug then
197: hr_utility.set_location ( 'Leaving:'

Line 213: DELETE FROM hxt_errors_x

209: || 'delete_prev_val_errors';
210: hr_utility.set_location ( 'Entering:'
211: || l_proc, 10);
212: end if;
213: DELETE FROM hxt_errors_x
214: WHERE tim_id = p_tim_id AND location LIKE 'Validate%';
215:
216: if g_debug then
217: hr_utility.set_location ( 'Leaving:'

Line 230: FROM hxt_errors_x

226:
227: CURSOR find_errors (p_tim_id hxt_timecards.id%TYPE)
228: IS
229: SELECT 1
230: FROM hxt_errors_x
231: WHERE tim_id = p_tim_id;
232:
233: l_find_error NUMBER;
234: l_error_exist BOOLEAN;