54: BEGIN
55: DELETE gl_alloc_formula_lines
56: WHERE allocation_formula_id IN
57: (SELECT allocation_formula_id
58: FROM gl_alloc_formulas
59: WHERE allocation_batch_id = batch_id);
60: EXCEPTION
61: WHEN NO_DATA_FOUND THEN
62: null;
310: BEGIN
311:
312: -- Get formula id if it was not provided
313: IF (x_allocation_formula_id IS NULL) THEN
314: x_allocation_formula_id := gl_alloc_formulas_pkg.get_unique_id;
315: END IF;
316:
317: INSERT INTO GL_ALLOC_FORMULA_LINES(
318: allocation_formula_id,