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.PNT_PAYMENT_TERMS_PKG dependencies on PN_PAYMENT_ITEMS

Line 9: (p_pnt_term_id IN pn_payment_items.payment_term_id%TYPE,

5: -------------------------------------------------------------------
6: -- PROCEDURE UPDATE_PNT_ITEMS_AMT
7: -------------------------------------------------------------------
8: PROCEDURE UPDATE_PNT_ITEMS_AMT
9: (p_pnt_term_id IN pn_payment_items.payment_term_id%TYPE,
10: p_old_est_amt IN pn_payment_items.estimated_amount%TYPE,
11: p_new_est_amt IN pn_payment_items.estimated_amount%TYPE,
12: p_lease_id IN pn_payment_terms.lease_id%TYPE,
13: p_trm_str_dt IN DATE,

Line 10: p_old_est_amt IN pn_payment_items.estimated_amount%TYPE,

6: -- PROCEDURE UPDATE_PNT_ITEMS_AMT
7: -------------------------------------------------------------------
8: PROCEDURE UPDATE_PNT_ITEMS_AMT
9: (p_pnt_term_id IN pn_payment_items.payment_term_id%TYPE,
10: p_old_est_amt IN pn_payment_items.estimated_amount%TYPE,
11: p_new_est_amt IN pn_payment_items.estimated_amount%TYPE,
12: p_lease_id IN pn_payment_terms.lease_id%TYPE,
13: p_trm_str_dt IN DATE,
14: p_trm_end_dt IN DATE,

Line 11: p_new_est_amt IN pn_payment_items.estimated_amount%TYPE,

7: -------------------------------------------------------------------
8: PROCEDURE UPDATE_PNT_ITEMS_AMT
9: (p_pnt_term_id IN pn_payment_items.payment_term_id%TYPE,
10: p_old_est_amt IN pn_payment_items.estimated_amount%TYPE,
11: p_new_est_amt IN pn_payment_items.estimated_amount%TYPE,
12: p_lease_id IN pn_payment_terms.lease_id%TYPE,
13: p_trm_str_dt IN DATE,
14: p_trm_end_dt IN DATE,
15: p_freq_code IN pn_payment_terms.frequency_code%TYPE);

Line 20: PROCEDURE UPDATE_PNT_ITEMS_RATE(p_pnt_term_id pn_payment_items.payment_item_id%TYPE,

16:
17: -------------------------------------------------------------------
18: -- PROCEDURE UPDATE_PNT_ITEMS_RATE
19: -------------------------------------------------------------------
20: PROCEDURE UPDATE_PNT_ITEMS_RATE(p_pnt_term_id pn_payment_items.payment_item_id%TYPE,
21: p_new_rate pn_payment_items.rate%TYPE);
22:
23: -------------------------------------------------------------------
24: -- PROCEDURE : CHECK_PAYMENT_AMOUNTS

Line 21: p_new_rate pn_payment_items.rate%TYPE);

17: -------------------------------------------------------------------
18: -- PROCEDURE UPDATE_PNT_ITEMS_RATE
19: -------------------------------------------------------------------
20: PROCEDURE UPDATE_PNT_ITEMS_RATE(p_pnt_term_id pn_payment_items.payment_item_id%TYPE,
21: p_new_rate pn_payment_items.rate%TYPE);
22:
23: -------------------------------------------------------------------
24: -- PROCEDURE : CHECK_PAYMENT_AMOUNTS
25: -------------------------------------------------------------------

Line 1499: -- 05-JUL-05 sdmahesh o Bug 4284035 - Replaced pn_payment_items with _ALL

1495: -- PROCDURE : UPDATE_VENDOR_AND_CUST
1496: -- INVOKED FROM :
1497: -- PURPOSE : UPDATE each item with the new vendor AND vendor site
1498: -- HISTORY :
1499: -- 05-JUL-05 sdmahesh o Bug 4284035 - Replaced pn_payment_items with _ALL
1500: -- table.
1501: -------------------------------------------------------------------------------
1502: PROCEDURE UPDATE_VENDOR_AND_CUST
1503: (

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 1554: -- pn_payment_items and pn_leases. (bug#3140238)

1550: -- 23-SEP-03 ATUPPAD o Changed the procedure to handle the One Time terms as in
1551: -- this case start and end dates are the same.
1552: -- Also, the query now executes through Cursor.
1553: -- Also, optmized the query by not joining with tables
1554: -- pn_payment_items and pn_leases. (bug#3140238)
1555: -- 05-JUL-05 sdmahesh o Bug 4284035 - Replaced pn_leases with _ALL table.
1556: -------------------------------------------------------------------------------
1557: PROCEDURE Check_Approved_Schedule_Exists (
1558: x_return_status IN OUT NOCOPY VARCHAR2

Line 1629: -- 05-JUL-05 sdmahesh o Bug 4284035 - Replaced pn_payment_items,

1625: -- 28-DEC-01 FTANUDJA o Created
1626: -- 11-OCT-04 STripathi o Fixed for BUG# 3942284. Changed paramater p_freq
1627: -- to p_freq_code. For OT terms, update amount with
1628: -- the p_new_est_amt.
1629: -- 05-JUL-05 sdmahesh o Bug 4284035 - Replaced pn_payment_items,
1630: -- pn_payment_schedules, pn_leases with _ALL table.
1631: -- 24-NOV-05 Kiran o rounding for amounts done based on currency precision
1632: --------------------------------------------------------------------------------
1633:

Line 1635: p_pnt_term_id IN pn_payment_items.payment_term_id%TYPE,

1631: -- 24-NOV-05 Kiran o rounding for amounts done based on currency precision
1632: --------------------------------------------------------------------------------
1633:
1634: PROCEDURE UPDATE_PNT_ITEMS_AMT (
1635: p_pnt_term_id IN pn_payment_items.payment_term_id%TYPE,
1636: p_old_est_amt IN pn_payment_items.estimated_amount%TYPE,
1637: p_new_est_amt IN pn_payment_items.estimated_amount%TYPE,
1638: p_lease_id IN pn_payment_terms.lease_id%TYPE,
1639: p_trm_str_dt IN DATE,

Line 1636: p_old_est_amt IN pn_payment_items.estimated_amount%TYPE,

1632: --------------------------------------------------------------------------------
1633:
1634: PROCEDURE UPDATE_PNT_ITEMS_AMT (
1635: p_pnt_term_id IN pn_payment_items.payment_term_id%TYPE,
1636: p_old_est_amt IN pn_payment_items.estimated_amount%TYPE,
1637: p_new_est_amt IN pn_payment_items.estimated_amount%TYPE,
1638: p_lease_id IN pn_payment_terms.lease_id%TYPE,
1639: p_trm_str_dt IN DATE,
1640: p_trm_end_dt IN DATE,

Line 1637: p_new_est_amt IN pn_payment_items.estimated_amount%TYPE,

1633:
1634: PROCEDURE UPDATE_PNT_ITEMS_AMT (
1635: p_pnt_term_id IN pn_payment_items.payment_term_id%TYPE,
1636: p_old_est_amt IN pn_payment_items.estimated_amount%TYPE,
1637: p_new_est_amt IN pn_payment_items.estimated_amount%TYPE,
1638: p_lease_id IN pn_payment_terms.lease_id%TYPE,
1639: p_trm_str_dt IN DATE,
1640: p_trm_end_dt IN DATE,
1641: p_freq_code IN pn_payment_terms.frequency_code%TYPE

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 1827: -- 05-JUL-05 sdmahesh o Bug 4284035 - Replaced pn_payment_items with _ALL

1823: -- o Implicit: item IS not exported
1824: -- o Implicit: term has been finalized
1825: -- HISTORY:
1826: -- 15-MAY-02 ftanudja o Created
1827: -- 05-JUL-05 sdmahesh o Bug 4284035 - Replaced pn_payment_items with _ALL
1828: -- table.
1829: -------------------------------------------------------------------------------
1830:
1831: PROCEDURE UPDATE_PNT_ITEMS_RATE(p_pnt_term_id pn_payment_items.payment_item_id%TYPE,

Line 1831: PROCEDURE UPDATE_PNT_ITEMS_RATE(p_pnt_term_id pn_payment_items.payment_item_id%TYPE,

1827: -- 05-JUL-05 sdmahesh o Bug 4284035 - Replaced pn_payment_items with _ALL
1828: -- table.
1829: -------------------------------------------------------------------------------
1830:
1831: PROCEDURE UPDATE_PNT_ITEMS_RATE(p_pnt_term_id pn_payment_items.payment_item_id%TYPE,
1832: p_new_rate pn_payment_items.rate%TYPE)
1833: IS
1834: l_context VARCHAR2(240);
1835:

Line 1832: p_new_rate pn_payment_items.rate%TYPE)

1828: -- table.
1829: -------------------------------------------------------------------------------
1830:
1831: PROCEDURE UPDATE_PNT_ITEMS_RATE(p_pnt_term_id pn_payment_items.payment_item_id%TYPE,
1832: p_new_rate pn_payment_items.rate%TYPE)
1833: IS
1834: l_context VARCHAR2(240);
1835:
1836: CURSOR pnt_cursor IS

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;