APPS.PO_MOD_SYNC_PROCESS_PVT dependencies on PO_ATTRIBUTE_VALUES_TLP_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 1795: -- 8. Sync po_attribute_values_tlp_draft

1791: IF (PO_LOG.d_stmt) THEN
1792: PO_LOG.stmt(d_module,d_position ,'PO_ATTR_VALUES_DRAFT_PKG.sync_draft_from_txn');
1793: END IF;
1794:
1795: -- 8. Sync po_attribute_values_tlp_draft
1796: --delete the recored from po_attribute_values_tlp_draft for the given header_id and draft_id
1797: -- and then insert the data from the base table
1798: l_draft_id_tbl.DELETE;
1799: l_delete_flag_tbl.DELETE;

Line 1796: --delete the recored from po_attribute_values_tlp_draft for the given header_id and draft_id

1792: PO_LOG.stmt(d_module,d_position ,'PO_ATTR_VALUES_DRAFT_PKG.sync_draft_from_txn');
1793: END IF;
1794:
1795: -- 8. Sync po_attribute_values_tlp_draft
1796: --delete the recored from po_attribute_values_tlp_draft for the given header_id and draft_id
1797: -- and then insert the data from the base table
1798: l_draft_id_tbl.DELETE;
1799: l_delete_flag_tbl.DELETE;
1800: l_change_status_tbl.DELETE;

Line 1810: FROM po_attribute_values_tlp_draft pavtd

1806: BULK COLLECT INTO l_attribute_values_tlp_id_tbl,
1807: l_draft_id_tbl,
1808: l_delete_flag_tbl,
1809: l_change_status_tbl
1810: FROM po_attribute_values_tlp_draft pavtd
1811: WHERE pavtd.po_line_id in ( select * from table(l_po_line_s_no_lck_tbl))
1812: AND pavtd.draft_id = p_draft_id;
1813:
1814: FORALL i in 1..l_attribute_values_tlp_id_tbl.COUNT

Line 1815: DELETE FROM po_attribute_values_tlp_draft pavd

1811: WHERE pavtd.po_line_id in ( select * from table(l_po_line_s_no_lck_tbl))
1812: AND pavtd.draft_id = p_draft_id;
1813:
1814: FORALL i in 1..l_attribute_values_tlp_id_tbl.COUNT
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

Line 1827: UPDATE po_attribute_values_tlp_draft pavd

1823: x_record_already_exist_tbl => l_record_already_exists
1824: );
1825:
1826: FORALL i in 1..l_attribute_values_tlp_id_tbl.COUNT
1827: UPDATE po_attribute_values_tlp_draft pavd
1828: SET pavd.change_status = l_change_status_tbl(i)
1829: WHERE pavd.attribute_values_tlp_id=l_attribute_values_tlp_id_tbl(i)
1830: AND pavd.draft_id = p_draft_id ;
1831: