APPS.PO_MOD_SYNC_PROCESS_PVT dependencies on PO_ATTRIBUTE_VALUES_DRAFT

Line 1563: l_change_status_tbl Po_Tbl_Varchar30; -- change_status of po_attribute_values_draft/po_attribute_values_tlp_draft/po_price_diff_draft

1559: l_attribute_values_id_tbl PO_TBL_NUMBER;
1560: l_attribute_values_tlp_id_tbl PO_TBL_NUMBER;
1561: l_price_differential_id_tbl PO_TBL_NUMBER;
1562: l_change_status_lines_tbl Po_Tbl_Varchar30; -- chnage_status of po_lines_draft_all
1563: l_change_status_tbl Po_Tbl_Varchar30; -- change_status of po_attribute_values_draft/po_attribute_values_tlp_draft/po_price_diff_draft
1564: --UCA Project - CLM R4 Changes Begin.
1565: l_base_CLM_UNDEF_FLAG_tbl Po_Tbl_varchar1;
1566: l_base_CLM_APP_UNDEF_AMT_tbl Po_tbl_number;
1567: l_draft_CLM_UNDEF_ACTION_CODE po_tbl_varchar30;

Line 1754: -- 7. Sync po_attribute_values_draft

1750: IF (PO_LOG.d_stmt) THEN
1751: PO_LOG.stmt(d_module,d_position ,'sync_lines_ext');
1752: END IF;
1753:
1754: -- 7. Sync po_attribute_values_draft
1755: --delete the recored from po_attribute_values_draft for the given header_id and draft_id
1756: -- and then insert the data from the base table
1757: l_draft_id_tbl.DELETE;
1758: l_delete_flag_tbl.DELETE;

Line 1755: --delete the recored from po_attribute_values_draft for the given header_id and draft_id

1751: PO_LOG.stmt(d_module,d_position ,'sync_lines_ext');
1752: END IF;
1753:
1754: -- 7. Sync po_attribute_values_draft
1755: --delete the recored from po_attribute_values_draft for the given header_id and draft_id
1756: -- and then insert the data from the base table
1757: l_draft_id_tbl.DELETE;
1758: l_delete_flag_tbl.DELETE;
1759:

Line 1768: FROM po_attribute_values_draft pavd

1764: BULK COLLECT INTO l_attribute_values_id_tbl,
1765: l_draft_id_tbl,
1766: l_delete_flag_tbl,
1767: l_change_status_tbl
1768: FROM po_attribute_values_draft pavd
1769: WHERE pavd.po_line_id in ( select * from table(l_po_line_s_no_lck_tbl))
1770: AND pavd.draft_id= p_draft_id;
1771:
1772: FORALL i in 1..l_attribute_values_id_tbl.COUNT

Line 1773: DELETE FROM po_attribute_values_draft pavd

1769: WHERE pavd.po_line_id in ( select * from table(l_po_line_s_no_lck_tbl))
1770: AND pavd.draft_id= p_draft_id;
1771:
1772: FORALL i in 1..l_attribute_values_id_tbl.COUNT
1773: DELETE FROM po_attribute_values_draft pavd
1774: WHERE pavd.attribute_values_id=l_attribute_values_id_tbl(i)
1775: AND pavd.draft_id = p_draft_id ;
1776:
1777: PO_ATTR_VALUES_DRAFT_PKG.sync_draft_from_txn

Line 1785: UPDATE po_attribute_values_draft pavd

1781: x_record_already_exist_tbl => l_record_already_exists
1782: );
1783:
1784: FORALL i in 1..l_attribute_values_id_tbl.COUNT
1785: UPDATE po_attribute_values_draft pavd
1786: SET pavd.change_status = l_change_status_tbl(i)
1787: WHERE pavd.attribute_values_id=l_attribute_values_id_tbl(i)
1788: AND pavd.draft_id = p_draft_id ;
1789: