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;
309: BEGIN
310:
311: -- Get formula id if it was not provided
312: IF (x_allocation_formula_id IS NULL) THEN
313: x_allocation_formula_id := gl_alloc_formulas_pkg.get_unique_id;
314: END IF;
315:
316: INSERT INTO GL_ALLOC_FORMULA_LINES(
317: allocation_formula_id,