eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_MOD_SYNC_PROCESS_PVT dependencies on PO_LINES_DRAFT_ALL

Line 1562: l_change_status_lines_tbl Po_Tbl_Varchar30; -- chnage_status of po_lines_draft_all

1558: d_api_version CONSTANT NUMBER := 1.0;
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;

Line 1636: po_lines_draft_all plda

1632: l_base_CLM_APP_UNDEF_AMT_tbl,--UCA Project
1633: l_draft_CLM_UNDEF_ACTION_CODE,--UCA Project
1634: l_draft_CLM_UNDEF_FLAG_tbl --bug 16451273
1635: FROM po_lines_all pla,
1636: po_lines_draft_all plda
1637: WHERE pla.po_line_id = plda.po_line_id
1638: AND plda.draft_id = p_draft_id
1639: AND NVL(pla.revision_num, 0) > NVL(plda.revision_num, 0)
1640: AND NOT EXISTS (SELECT 'F locks'

Line 1667: po_lines_draft_all plda

1663: BULK COLLECT INTO l_po_line_s_no_lck_tbl,
1664: l_draft_id_tbl,
1665: l_delete_flag_tbl
1666: FROM po_lines_all pla,
1667: po_lines_draft_all plda
1668: WHERE plda.draft_id = p_draft_id
1669: AND pla.po_line_id = plda.po_line_id
1670: AND NVL(pla.revision_num, 0) > NVL(plda.revision_num, 0)
1671: AND NOT EXISTS (SELECT 'F/P locks'

Line 1688: FROM po_lines_draft_all plda,

1684: -- : Identify po_line_id for S, No and P locks including comlex pricing attr
1685: SELECT plda.po_line_id
1686: BULK COLLECT
1687: INTO l_po_line_s_no_p_lck_tbl
1688: FROM po_lines_draft_all plda,
1689: po_lines_all pla
1690: WHERE plda.draft_id = p_draft_id
1691: AND pla.po_line_id = plda.po_line_id
1692: AND NVL(pla.revision_num, 0) > NVL(plda.revision_num, 0)

Line 1702: DELETE FROM po_lines_draft_all plda

1698: AND pel.lock_type ='F');
1699:
1700: -- 3. Delete lines identified in #2 above.
1701: FORALL i in 1..l_po_line_s_no_lck_tbl.COUNT
1702: DELETE FROM po_lines_draft_all plda
1703: WHERE plda.po_line_id = l_po_line_s_no_lck_tbl(i)
1704: AND plda.draft_id=p_draft_id;
1705:
1706: d_position := 50;

Line 1726: UPDATE po_lines_draft_all

1722: END IF;
1723:
1724: -- 5. Sync quantity and amount using the values fetched in #1 above
1725: FORALL i in 1.. l_po_line_id_tbl.COUNT
1726: UPDATE po_lines_draft_all
1727: SET old_quantity = l_base_quantity_tbl(i)
1728: ,quantity = l_base_quantity_tbl(i) + (l_draft_quantity_tbl(i)-l_draft_old_quantity_tbl(i))
1729: ,old_amount = l_base_amount_tbl(i)
1730: ,amount = l_base_amount_tbl(i) + (l_draft_amount_tbl(i) - l_draft_old_amount_tbl(i))

Line 1736: PO_LOG.stmt(d_module,d_position ,'update po_lines_draft all for all locks excluding F lock',SQL%ROWCOUNT);

1732: AND draft_id = p_draft_id;
1733:
1734: d_position := 60;
1735: IF (PO_LOG.d_stmt) THEN
1736: PO_LOG.stmt(d_module,d_position ,'update po_lines_draft all for all locks excluding F lock',SQL%ROWCOUNT);
1737: END IF;
1738:
1739: -- 6. If UDA is enabled, then sync uda attributes
1740: IF p_uda_enabled_flag = 'Y'THEN

Line 1880: UPDATE po_lines_draft_all

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
1881: SET revision_num=l_header_base_rev_num(i),
1882: change_status = l_change_status_lines_tbl(i)
1883: WHERE po_line_id = l_po_line_id_tbl(i)
1884: AND draft_id = p_draft_id;

Line 1896: FROM po_lines_draft_all

1892: IF l_po_line_id_tbl.COUNT > 0 THEN
1893: SELECT Nvl(po_core_s.Retrieveoptionvalue(org_id,
1894: po_core_s.g_undef_cont_act_col), 'N')
1895: INTO l_isucaenabled
1896: FROM po_lines_draft_all
1897: WHERE draft_id = p_draft_id
1898: AND rownum = 1;
1899: END IF;
1900:

Line 1904: UPDATE po_lines_draft_all

1900:
1901: -- Sync of CLM_UNDEF_FLAG,CLM_APPROVED_UNDEF_AMOUNT and CLM_UNDEF_ACTION_CODE
1902: IF l_isucaenabled = 'Y' THEN
1903: FORALL i in 1.. l_po_line_id_tbl.COUNT
1904: UPDATE po_lines_draft_all
1905: SET clm_approved_undef_amount = nvl(l_base_clm_app_undef_amt_tbl(i),0)
1906: + nvl((SELECT undef_amount
1907: FROM po_line_ucas
1908: WHERE po_line_id = L_po_line_id_tbl(i)

Line 1928: UPDATE po_lines_draft_all

1924: END IF; --IF l_isucaenabled = 'Y'
1925:
1926: -- Sync of CLM_UDA_PRICING_TOTAL
1927: FORALL i in 1.. l_po_line_id_tbl.COUNT
1928: UPDATE po_lines_draft_all
1929: SET clm_uda_pricing_total =
1930: CASE
1931: WHEN NVL(cost_constraint,'X') IN ('NC','NSP')
1932: THEN 0

Line 2137: PO_LOG.stmt(d_module,d_position ,'update po_lines_draft all for all locks excluding F lock',SQL%ROWCOUNT);

2133: AND draft_id = p_draft_id;
2134:
2135: d_position := 60;
2136: IF (PO_LOG.d_stmt) THEN
2137: PO_LOG.stmt(d_module,d_position ,'update po_lines_draft all for all locks excluding F lock',SQL%ROWCOUNT);
2138: PO_LOG.stmt(d_module,d_position,'revision_num',l_header_base_rev_num);
2139: END IF;
2140:
2141: -- 6. If UDA is enabled, then sync uda attributes