183: || 'delete_prev_val_errors';
184: hr_utility.set_location ( 'Entering:'
185: || l_proc, 10);
186: end if;
187: DELETE FROM hxt_errors_x
188: WHERE ppb_id = p_batch_id AND location LIKE 'Validate%';
189:
190: if g_debug then
191: hr_utility.set_location ( 'Leaving:'
203: || 'delete_prev_val_errors';
204: hr_utility.set_location ( 'Entering:'
205: || l_proc, 10);
206: end if;
207: DELETE FROM hxt_errors_x
208: WHERE tim_id = p_tim_id AND location LIKE 'Validate%';
209:
210: if g_debug then
211: hr_utility.set_location ( 'Leaving:'
220:
221: CURSOR find_errors (p_tim_id hxt_timecards.id%TYPE)
222: IS
223: SELECT 1
224: FROM hxt_errors_x
225: WHERE tim_id = p_tim_id;
226:
227: l_find_error NUMBER;
228: l_error_exist BOOLEAN;