APPS.PO_MOD_SYNC_PROCESS_PVT dependencies on PO_PRICE_DIFF_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 1852: FROM po_price_diff_draft ppdr

1848: BULK COLLECT INTO l_price_differential_id_tbl,
1849: l_draft_id_tbl,
1850: l_delete_flag_tbl,
1851: l_change_status_tbl
1852: FROM po_price_diff_draft ppdr
1853: WHERE ppdr.entity_id in ( select * from table(l_po_line_s_no_lck_tbl))
1854: AND ppdr.draft_id = p_draft_id;
1855:
1856: FORALL i in 1..l_price_differential_id_tbl.COUNT

Line 1857: DELETE FROM po_price_diff_draft ppdr

1853: WHERE ppdr.entity_id in ( select * from table(l_po_line_s_no_lck_tbl))
1854: AND ppdr.draft_id = p_draft_id;
1855:
1856: FORALL i in 1..l_price_differential_id_tbl.COUNT
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

Line 1861: PO_PRICE_DIFF_DRAFT_PKG.sync_draft_from_txn

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

Line 1869: UPDATE po_price_diff_draft ppdr

1865: x_record_already_exist_tbl => l_record_already_exists
1866: );
1867:
1868: FORALL i in 1..l_price_differential_id_tbl.COUNT
1869: UPDATE po_price_diff_draft ppdr
1870: SET ppdr.change_status = l_change_status_tbl(i)
1871: WHERE ppdr.price_differential_id=l_price_differential_id_tbl(i)
1872: AND ppdr.draft_id = p_draft_id ;
1873:

Line 1876: PO_LOG.stmt(d_module,d_position ,'PO_PRICE_DIFF_DRAFT_PKG.sync_draft_from_txn');

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