706: begin
707:
708: SELECT formula_id
709: BULK COLLECT INTO l_fast_formula_id_tbl
710: FROM ff_fdi_usages_f
711: WHERE item_name = p_item_name
712: AND usage = 'D';
713:
714: FOR i IN 1..l_fast_formula_id_tbl.count
717: FROM ff_compiled_info_f
718: WHERE formula_id = l_fast_formula_id_tbl(i);
719: END LOOP;
720:
721: delete from ff_fdi_usages_f
722: where item_name = p_item_name
723: and usage = 'D';
724:
725: -- Check whether the ZA database item exists