DBA Data[Home] [Help]

APPS.HXT_BATCH_VAL dependencies on HXT_ERRORS_X

Line 187: DELETE FROM hxt_errors_x

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:'

Line 207: DELETE FROM hxt_errors_x

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:'

Line 224: FROM hxt_errors_x

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;