1815: DELETE FROM po_attribute_values_tlp_draft pavd
1816: WHERE pavd.attribute_values_tlp_id=l_attribute_values_tlp_id_tbl(i)
1817: AND pavd.draft_id = p_draft_id ;
1818:
1819: PO_ATTR_VALUES_TLP_DRAFT_PKG.sync_draft_from_txn
1820: ( p_attribute_values_tlp_id_tbl => l_attribute_values_tlp_id_tbl,
1821: p_draft_id_tbl => l_draft_id_tbl,
1822: p_delete_flag_tbl => l_delete_flag_tbl,
1823: x_record_already_exist_tbl => l_record_already_exists
1830: AND pavd.draft_id = p_draft_id ;
1831:
1832: d_position := 90;
1833: IF (PO_LOG.d_stmt) THEN
1834: PO_LOG.stmt(d_module,d_position ,'PO_ATTR_VALUES_TLP_DRAFT_PKG.sync_draft_from_txn');
1835: END IF;
1836:
1837: -- 9. Sync po_price_differentials
1838: --delete the recored from po_price_differentials for the given header_id and draft_id