259:
260: delete from qp_pricing_attributes qp_prc_att where qp_prc_att.list_header_id = l_list_header_id;
261: delete from qp_list_lines qp_ll where qp_ll.list_header_id = l_list_header_id;
262: delete from qp_qualifiers qp_qual where qp_qual.list_header_id = l_list_header_id;
263: delete from qp_list_headers_b qp_lhdr_b where qp_lhdr_b.list_header_id = l_list_header_id;
264: delete from qp_list_headers_tl qp_lhdr_tl where qp_lhdr_tl.list_header_id = l_list_header_id;
265:
266: /*
267: update fte_lanes set fte_lanes.pricelist_view_flag = NULL WHERE fte_lanes.pricelist_id = l_list_header_id;