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

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

Line 1513: FROM pn_payment_items_all ppi

1509: )
1510: IS
1511: CURSOR c1 IS
1512: SELECT ppi.payment_item_id
1513: FROM pn_payment_items_all ppi
1514: WHERE ppi.payment_term_id = X_PAYMENT_TERM_ID
1515: AND ppi.transferred_to_ap_flag IS NULL
1516: AND ppi.transferred_to_ar_flag IS NULL
1517: FOR UPDATE OF ppi.payment_item_id NOWAIT;

Line 1524: UPDATE pn_payment_items_all

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

Line 1550: -- pn_payment_items and pn_leases. (bug#3140238)

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

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

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

Line 1631: p_pnt_term_id IN pn_payment_items.payment_term_id%TYPE,

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

Line 1632: p_old_est_amt IN pn_payment_items.estimated_amount%TYPE,

1628: --------------------------------------------------------------------------------
1629:
1630: PROCEDURE UPDATE_PNT_ITEMS_AMT (
1631: p_pnt_term_id IN pn_payment_items.payment_term_id%TYPE,
1632: p_old_est_amt IN pn_payment_items.estimated_amount%TYPE,
1633: p_new_est_amt IN pn_payment_items.estimated_amount%TYPE,
1634: p_lease_id IN pn_payment_terms.lease_id%TYPE,
1635: p_trm_str_dt IN DATE,
1636: p_trm_end_dt IN DATE,

Line 1633: p_new_est_amt IN pn_payment_items.estimated_amount%TYPE,

1629:
1630: PROCEDURE UPDATE_PNT_ITEMS_AMT (
1631: p_pnt_term_id IN pn_payment_items.payment_term_id%TYPE,
1632: p_old_est_amt IN pn_payment_items.estimated_amount%TYPE,
1633: p_new_est_amt IN pn_payment_items.estimated_amount%TYPE,
1634: p_lease_id IN pn_payment_terms.lease_id%TYPE,
1635: p_trm_str_dt IN DATE,
1636: p_trm_end_dt IN DATE,
1637: p_freq_code IN pn_payment_terms.frequency_code%TYPE

Line 1658: FROM pn_payment_items_all ppi,

1654: , ppi.actual_amount
1655: , ppi.estimated_amount
1656: , pps.schedule_date
1657: , ppi.currency_code
1658: FROM pn_payment_items_all ppi,
1659: pn_payment_schedules_all pps
1660: WHERE ppi.payment_term_id = p_pnt_term_id
1661: AND ppi.payment_item_type_lookup_code = 'CASH'
1662: AND pps.payment_schedule_id = ppi.payment_schedule_id

Line 1691: UPDATE pn_payment_items_all

1687: ,min_acct_unit => l_min_acct_unit);
1688: l_first := FALSE;
1689: END IF;
1690:
1691: UPDATE pn_payment_items_all
1692: SET estimated_amount = ROUND(l_est_amt, l_precision)
1693: ,actual_amount = ROUND(l_act_amt, l_precision)
1694: ,export_currency_amount = ROUND(l_act_amt, l_precision)
1695: ,last_update_date = SYSDATE

Line 1790: UPDATE pn_payment_items_all

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

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

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

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

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

Line 1828: p_new_rate pn_payment_items.rate%TYPE)

1824: -- table.
1825: -------------------------------------------------------------------------------
1826:
1827: PROCEDURE UPDATE_PNT_ITEMS_RATE(p_pnt_term_id pn_payment_items.payment_item_id%TYPE,
1828: p_new_rate pn_payment_items.rate%TYPE)
1829: IS
1830: l_context VARCHAR2(240);
1831:
1832: CURSOR pnt_cursor IS

Line 1834: FROM pn_payment_items_all ppi

1830: l_context VARCHAR2(240);
1831:
1832: CURSOR pnt_cursor IS
1833: SELECT payment_item_id
1834: FROM pn_payment_items_all ppi
1835: WHERE ppi.payment_term_id = p_pnt_term_id
1836: AND ppi.export_to_ap_flag IS NULL
1837: AND ppi.export_to_ar_flag IS NULL;
1838:

Line 1847: UPDATE pn_payment_items_all

1843:
1844: FOR pnt_rec IN pnt_cursor LOOP
1845:
1846: l_context := 'updating payment item ID: '||pnt_rec.payment_item_id||' with new rate';
1847: UPDATE pn_payment_items_all
1848: SET rate = p_new_rate
1849: WHERE payment_item_id = pnt_rec.payment_item_id;
1850:
1851: END LOOP;