[Home] [Help]
979: );
980: END IF;
981:
982: -- delete market segment data
983: DELETE FROM ams_act_market_segments
984: WHERE arc_act_market_segment_used_by = 'FUND'
985: AND act_market_segment_used_by_id = p_object_id;
986: -- dbms_output.put_line('Remove ' || SQL%ROWCOUNT || ' market segment records with budget ' || l_fund_rec.short_name);
987: IF SQL%ROWCOUNT > 0 THEN