[Home] [Help]
525:
526: d_position := 40;
527:
528: FORALL i IN 1..l_po_line_id_tbl.COUNT
529: DELETE FROM po_price_diff_draft
530: WHERE draft_id = p_draft_id
531: AND entity_id = l_po_line_id_tbl(i)
532: AND entity_type = 'BLANKET LINE';
533:
533:
534: d_position := 50;
535:
536: FORALL i IN 1..l_po_line_id_tbl.COUNT
537: DELETE FROM po_price_diff_draft PPDD
538: WHERE draft_id = p_draft_id
539: AND entity_type = 'PRICE BREAK'
540: AND EXISTS (SELECT 1
541: FROM po_line_locations_draft_all PLLD