APPS.PNT_PAYMENT_TERMS_PKG dependencies on PN_PAYMENT_ITEMS_ALL

Line 1517: FROM pn_payment_items_all ppi

1513: )
1514: IS
1515: CURSOR c1 IS
1516: SELECT ppi.payment_item_id
1517: FROM pn_payment_items_all ppi
1518: WHERE ppi.payment_term_id = X_PAYMENT_TERM_ID
1519: AND ppi.transferred_to_ap_flag IS NULL
1520: AND ppi.transferred_to_ar_flag IS NULL
1521: FOR UPDATE OF ppi.payment_item_id NOWAIT;

Line 1528: UPDATE pn_payment_items_all

1524: pnp_debug_pkg.debug('PNT_PAYMENT_TERMS_PKG.UPDATE_VENDOR_AND_CUST (+)');
1525: -- UPDATE each item with the new vendor AND vendor site
1526: FOR eachItem IN c1 LOOP
1527:
1528: UPDATE pn_payment_items_all
1529: SET VENDOR_ID = X_VENDOR_ID
1530: ,VENDOR_SITE_ID = X_VENDOR_SITE_ID
1531: ,LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
1532: ,LAST_UPDATED_BY = X_LAST_UPDATED_BY

Line 1662: FROM pn_payment_items_all ppi,

1658: , ppi.actual_amount
1659: , ppi.estimated_amount
1660: , pps.schedule_date
1661: , ppi.currency_code
1662: FROM pn_payment_items_all ppi,
1663: pn_payment_schedules_all pps
1664: WHERE ppi.payment_term_id = p_pnt_term_id
1665: AND ppi.payment_item_type_lookup_code = 'CASH'
1666: AND pps.payment_schedule_id = ppi.payment_schedule_id

Line 1695: UPDATE pn_payment_items_all

1691: ,min_acct_unit => l_min_acct_unit);
1692: l_first := FALSE;
1693: END IF;
1694:
1695: UPDATE pn_payment_items_all
1696: SET estimated_amount = ROUND(l_est_amt, l_precision)
1697: ,actual_amount = ROUND(l_act_amt, l_precision)
1698: ,export_currency_amount = ROUND(l_act_amt, l_precision)
1699: ,last_update_date = SYSDATE

Line 1794: UPDATE pn_payment_items_all

1790:
1791: /** updates estimated amount AND actual amount accordingly in the items table */
1792: l_context := 'updates items table';
1793:
1794: UPDATE pn_payment_items_all
1795: SET estimated_amount = ROUND(l_est_amt, l_precision)
1796: ,actual_amount = ROUND(l_act_amt, l_precision)
1797: ,export_currency_amount = ROUND(l_act_amt, l_precision)
1798: ,last_update_date = SYSDATE

Line 1838: FROM pn_payment_items_all ppi

1834: l_context VARCHAR2(240);
1835:
1836: CURSOR pnt_cursor IS
1837: SELECT payment_item_id
1838: FROM pn_payment_items_all ppi
1839: WHERE ppi.payment_term_id = p_pnt_term_id
1840: AND ppi.export_to_ap_flag IS NULL
1841: AND ppi.export_to_ar_flag IS NULL;
1842:

Line 1851: UPDATE pn_payment_items_all

1847:
1848: FOR pnt_rec IN pnt_cursor LOOP
1849:
1850: l_context := 'updating payment item ID: '||pnt_rec.payment_item_id||' with new rate';
1851: UPDATE pn_payment_items_all
1852: SET rate = p_new_rate
1853: WHERE payment_item_id = pnt_rec.payment_item_id;
1854:
1855: END LOOP;