600: FROM po_line_locations_draft_all
601: WHERE po_header_id = p_entity_id
602: AND draft_id = p_draft_id);
603:
604: DELETE FROM po_line_locations_all_ext_tl
605: WHERE draft_id = p_draft_id
606: AND line_location_id IN(SELECT line_location_id
607: FROM po_line_locations_draft_all
608: WHERE po_header_id = p_entity_id
636: OR ( draft_id = -1 -- old record for complex pricing
637: AND po_line_id = p_entity_id
638: AND pk1_value = p_draft_id);
639:
640: DELETE FROM po_line_locations_all_ext_tl
641: WHERE draft_id = p_draft_id
642: AND line_location_id IN (SELECT line_location_id
643: FROM po_line_locations_draft_all
644: WHERE po_line_id = p_entity_id
649: DELETE FROM po_line_locations_all_ext_b
650: WHERE draft_id = p_draft_id
651: AND line_location_id = p_entity_id;
652:
653: DELETE FROM po_line_locations_all_ext_tl
654: WHERE draft_id = p_draft_id
655: AND line_location_id = p_entity_id;
656:
657: END IF;