[Home] [Help]
1857: DELETE FROM po_price_diff_draft ppdr
1858: WHERE ppdr.price_differential_id=l_price_differential_id_tbl(i)
1859: AND ppdr.draft_id = p_draft_id ;
1860:
1861: PO_PRICE_DIFF_DRAFT_PKG.sync_draft_from_txn
1862: ( p_price_differential_id_tbl => l_price_differential_id_tbl,
1863: p_draft_id_tbl => l_draft_id_tbl,
1864: p_delete_flag_tbl => l_delete_flag_tbl,
1865: x_record_already_exist_tbl => l_record_already_exists
1872: AND ppdr.draft_id = p_draft_id ;
1873:
1874: d_position := 100;
1875: IF (PO_LOG.d_stmt) THEN
1876: PO_LOG.stmt(d_module,d_position ,'PO_PRICE_DIFF_DRAFT_PKG.sync_draft_from_txn');
1877: END IF;
1878:
1879: FORALL i in 1.. l_po_line_id_tbl.COUNT
1880: UPDATE po_lines_draft_all