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.PN_INDEX_RENT_PERIODS_PKG dependencies on PN_PAYMENT_TERMS_ALL

Line 347: FROM pn_index_lease_periods_all pilp, pn_payment_terms_all ppt

343: ,ip_index_period_id IN NUMBER) IS
344: SELECT pilp.index_period_id
345: ,ppt.payment_term_id
346: ,ppt.lease_id
347: FROM pn_index_lease_periods_all pilp, pn_payment_terms_all ppt
348: WHERE pilp.index_lease_id = ip_index_lease_id
349: AND pilp.index_period_id = ppt.index_period_id
350: AND pilp.index_period_id = ip_index_period_id;
351: var number;

Line 404: FROM pn_payment_terms_all

400: --DBMS_OUTPUT.put_line ('deleting only non-approved payment terms...');
401: DELETE FROM pn_distributions_all
402: WHERE payment_term_id IN
403: (SELECT payment_term_id
404: FROM pn_payment_terms_all
405: WHERE payment_term_id = il_rec.payment_term_id
406: AND status<>
407: pn_index_amount_pkg.c_payment_term_status_approved);
408:

Line 409: DELETE FROM pn_payment_terms_all

405: WHERE payment_term_id = il_rec.payment_term_id
406: AND status<>
407: pn_index_amount_pkg.c_payment_term_status_approved);
408:
409: DELETE FROM pn_payment_terms_all
410: WHERE payment_term_id = il_rec.payment_term_id
411: AND status <> pn_index_amount_pkg.c_payment_term_status_approved;
412:
413: DELETE FROM pn_index_lease_terms_all

Line 433: UPDATE pn_payment_terms_all

429: l_latest_period_id := last_period_rec.index_period_id;
430: EXIT;
431: END LOOP;
432:
433: UPDATE pn_payment_terms_all
434: SET index_period_id = l_latest_period_id,
435: index_term_indicator = 'REVERSED'
436: WHERE payment_term_id = il_rec.payment_term_id;
437:

Line 462: DELETE FROM pn_payment_terms_all

458: DELETE FROM pn_distributions_all
459: WHERE payment_term_id = il_rec.payment_term_id;
460:
461:
462: DELETE FROM pn_payment_terms_all
463: WHERE payment_term_id = il_rec.payment_term_id;
464:
465: DELETE FROM pn_index_lease_terms_all
466: where rent_increase_term_id = il_rec.payment_term_id;

Line 471: DELETE FROM pn_payment_terms_all

467: END IF;
468:
469: ELSE
470:
471: DELETE FROM pn_payment_terms_all
472: WHERE payment_term_id = il_rec.payment_term_id;
473:
474: DELETE FROM pn_distributions_all
475: WHERE payment_term_id = il_rec.payment_term_id;

Line 1112: pn_payment_terms_all term,

1108: CURSOR approved_sched_exist(p_index_lease_id IN NUMBER) IS
1109: SELECT term.payment_term_id
1110: FROM pn_payment_schedules_all sched,
1111: pn_index_leases_all ilease,
1112: pn_payment_terms_all term,
1113: pn_payment_items_all item,
1114: pn_index_lease_periods_all period
1115: WHERE sched.lease_id = ilease.lease_id
1116: AND sched.payment_schedule_id = item.payment_schedule_id

Line 1149: FROM pn_payment_terms_all term,pn_index_lease_periods_all iperiod

1145: WHERE index_lease_id = p_index_lease_id ;
1146:
1147: DELETE FROM pn_payment_items_all
1148: WHERE payment_term_id IN ( SELECT term.payment_term_id
1149: FROM pn_payment_terms_all term,pn_index_lease_periods_all iperiod
1150: WHERE term.index_period_id = iperiod.index_period_id
1151: AND iperiod.index_lease_id = p_index_lease_id
1152: AND term.index_period_id IS NOT NULL);
1153:

Line 1162: FROM pn_payment_terms_all term,pn_index_lease_periods_all period

1158: WHERE item.payment_schedule_id = sched.payment_schedule_id);
1159:
1160: DELETE FROM pn_distributions_all
1161: WHERE payment_term_id IN (SELECT payment_term_id
1162: FROM pn_payment_terms_all term,pn_index_lease_periods_all period
1163: WHERE term.index_period_id = period.index_period_id
1164: AND period.index_lease_id = p_index_lease_id);
1165:
1166: DELETE FROM pn_payment_terms_all

Line 1166: DELETE FROM pn_payment_terms_all

1162: FROM pn_payment_terms_all term,pn_index_lease_periods_all period
1163: WHERE term.index_period_id = period.index_period_id
1164: AND period.index_lease_id = p_index_lease_id);
1165:
1166: DELETE FROM pn_payment_terms_all
1167: WHERE index_period_id IN (SELECT index_period_id
1168: FROM pn_index_lease_periods_all
1169: WHERE index_lease_id = p_index_lease_id);
1170:

Line 1436: FROM pn_payment_terms_all ppt,

1432: ppt.estimated_amount,
1433: decode(ppt.actual_amount,null,ppt.estimated_amount,ppt.actual_amount) term_amount,
1434: ppt.org_id,
1435: ppt.norm_end_date
1436: FROM pn_payment_terms_all ppt,
1437: pn_index_lease_periods_all pilp
1438: WHERE ppt.index_period_id = pilp.index_period_id
1439: AND pilp.index_lease_id = p_index_lease_id
1440: AND ppt.frequency_code = pn_index_amount_pkg.c_spread_frequency_one_time

Line 1583: UPDATE pn_payment_terms_all

1579: l_min_acct_unit);
1580: v_new_amount := ROUND(v_new_amount, l_precision);
1581:
1582: IF rec_payment_terms.actual_amount IS NOT NULL THEN
1583: UPDATE pn_payment_terms_all
1584: SET actual_amount = v_new_amount,
1585: last_update_date = SYSDATE,
1586: last_updated_by = fnd_global.user_id,
1587: last_update_login = fnd_global.login_id

Line 1607: UPDATE pn_payment_terms_all

1603: END;
1604:
1605: ELSIF rec_payment_terms.estimated_amount IS NOT NULL THEN
1606:
1607: UPDATE pn_payment_terms_all
1608: SET estimated_amount = v_new_amount,
1609: last_update_date = SYSDATE,
1610: last_updated_by = fnd_global.user_id,
1611: last_update_login = fnd_global.login_id

Line 1772: FROM pn_payment_terms_all term,pn_index_lease_periods_all period

1768:
1769: CURSOR get_term_4_mtm_update(p_index_lease_id NUMBER) IS
1770: SELECT term.payment_term_id payment_term_id,
1771: NVL(term.normalize,'N') normalize
1772: FROM pn_payment_terms_all term,pn_index_lease_periods_all period
1773: WHERE term.index_period_id = period.index_period_id
1774: AND period.index_lease_id = p_index_lease_id
1775: AND term.frequency_code <> pn_index_amount_pkg.c_spread_frequency_one_time
1776: AND term.end_date = p_old_main_lease_term_date;

Line 1780: FROM pn_payment_terms_all

1776: AND term.end_date = p_old_main_lease_term_date;
1777:
1778: CURSOR get_term_details ( p_term_id NUMBER) IS
1779: SELECT *
1780: FROM pn_payment_terms_all
1781: WHERE payment_term_id = p_term_id;
1782:
1783: CURSOR get_old_ls_end_date IS
1784: SELECT NVL(plh.lease_extension_end_date, plh.lease_termination_date) old_ls_end_date

Line 1802: FROM pn_payment_terms_all

1798: WHERE lease_id = p_lease_id;
1799:
1800: CURSOR get_appr_terms_to_extend(p_index_lease_id IN NUMBER) IS
1801: SELECT *
1802: FROM pn_payment_terms_all
1803: WHERE payment_term_id IN ( SELECT payment_term_id
1804: FROM pn_payment_terms_all terms, pn_index_lease_periods_all period
1805: WHERE terms.index_period_id = period.index_period_id
1806: AND period.index_lease_id = p_index_lease_id)

Line 1804: FROM pn_payment_terms_all terms, pn_index_lease_periods_all period

1800: CURSOR get_appr_terms_to_extend(p_index_lease_id IN NUMBER) IS
1801: SELECT *
1802: FROM pn_payment_terms_all
1803: WHERE payment_term_id IN ( SELECT payment_term_id
1804: FROM pn_payment_terms_all terms, pn_index_lease_periods_all period
1805: WHERE terms.index_period_id = period.index_period_id
1806: AND period.index_lease_id = p_index_lease_id)
1807: AND status ='APPROVED'
1808: AND frequency_code <>'OT'

Line 1813: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp

1809: AND end_date = p_old_main_lease_term_date;
1810:
1811: CURSOR get_ri_terms_to_extend(p_index_lease_id IN NUMBER) IS --Bug16243330
1812: SELECT ppt.*
1813: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp
1814: WHERE pilp.index_period_id = ppt.index_period_id
1815: AND pilp.index_lease_id = p_index_lease_id
1816: AND p_lease_context <> 'CON'
1817: AND ppt.frequency_code <>

Line 1823: l_term_rec pn_payment_terms_all%ROWTYPE;

1819: AND ppt.end_date > p_cutoff_date
1820: AND ppt.end_date = p_old_main_lease_term_date;
1821:
1822:
1823: l_term_rec pn_payment_terms_all%ROWTYPE;
1824: l_return_status VARCHAR2(100);
1825: l_schd_date DATE := NULL;
1826: l_schd_day NUMBER := NULL;
1827: l_extended BOOLEAN := FALSE;

Line 1834: l_ri_term_rec pn_payment_terms_all%ROWTYPE;

1830: l_ls_comm_dt DATE ;
1831: l_mths NUMBER;
1832: l_requestId NUMBER := NULL;
1833: l_lease_num PN_LEASES_ALL.lease_num%TYPE;
1834: l_ri_term_rec pn_payment_terms_all%ROWTYPE;
1835: v_end_date DATE; -- added for bug #11671285
1836: l_period_id pn_payment_terms_all.index_period_id%TYPE; /* 9263195 */ -- added for bug #11671285
1837: l_basis_type PN_INDEX_LEASES_ALL.BASIS_TYPE%TYPE; -- added for bug #11671285
1838: l_ref_period PN_INDEX_LEASES_ALL.reference_period%TYPE; -- added for bug #11671285

Line 1836: l_period_id pn_payment_terms_all.index_period_id%TYPE; /* 9263195 */ -- added for bug #11671285

1832: l_requestId NUMBER := NULL;
1833: l_lease_num PN_LEASES_ALL.lease_num%TYPE;
1834: l_ri_term_rec pn_payment_terms_all%ROWTYPE;
1835: v_end_date DATE; -- added for bug #11671285
1836: l_period_id pn_payment_terms_all.index_period_id%TYPE; /* 9263195 */ -- added for bug #11671285
1837: l_basis_type PN_INDEX_LEASES_ALL.BASIS_TYPE%TYPE; -- added for bug #11671285
1838: l_ref_period PN_INDEX_LEASES_ALL.reference_period%TYPE; -- added for bug #11671285
1839: TYPE rec is record(index_id NUMBER,term_id NUMBER,period_id NUMBER); -- added for bug #11671285
1840: TYPE tab is table of rec INDEX BY BINARY_INTEGER; -- added for bug #11671285

Line 1843: l_status pn_payment_terms_all.status%TYPE; -- added for bug 12406073

1839: TYPE rec is record(index_id NUMBER,term_id NUMBER,period_id NUMBER); -- added for bug #11671285
1840: TYPE tab is table of rec INDEX BY BINARY_INTEGER; -- added for bug #11671285
1841: l_term tab; -- added for bug #11671285
1842: l_term_index NUMBER := 1; -- added for bug #11671285
1843: l_status pn_payment_terms_all.status%TYPE; -- added for bug 12406073
1844:
1845: BEGIN
1846: put_log('Processing Main Lease Termination Date for Index Rent increases');
1847: put_log('Parameters ');

Line 1938: UPDATE pn_payment_terms_all

1934: For appr_terms_rec in get_ri_terms_to_extend(c_rec.index_lease_id)
1935: loop
1936: l_ri_term_rec := appr_terms_rec;
1937:
1938: UPDATE pn_payment_terms_all
1939: SET end_date = p_new_main_lease_term_date,
1940: last_update_date = SYSDATE,
1941: last_updated_by = fnd_global.user_id,
1942: last_update_login = fnd_global.login_id

Line 1947: from pn_payment_terms_all

1943: WHERE payment_term_id = l_ri_term_rec.payment_term_id;
1944:
1945:
1946: select status into l_status
1947: from pn_payment_terms_all
1948: where payment_term_id = l_ri_term_rec.payment_term_id;
1949:
1950: IF l_status <> 'DRAFT' then
1951:

Line 1968: UPDATE pn_payment_terms_all

1964:
1965: /*--Bug16243330 */
1966:
1967: ELSIF p_lease_context='CON' THEN
1968: UPDATE pn_payment_terms_all
1969: SET end_date = NVL(p_term_end_dt,p_new_main_lease_term_date),
1970: last_update_date = SYSDATE,
1971: last_updated_by = fnd_global.user_id,
1972: last_update_login = fnd_global.login_id

Line 1975: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp

1971: last_updated_by = fnd_global.user_id,
1972: last_update_login = fnd_global.login_id
1973: WHERE payment_term_id IN
1974: (SELECT ppt.payment_term_id
1975: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp
1976: WHERE pilp.index_period_id = ppt.index_period_id
1977: AND pilp.index_lease_id = c_rec.index_lease_id
1978: AND (ppt.status = pn_index_amount_pkg.c_payment_term_status_draft AND
1979: p_lease_context = 'CON')

Line 1993: UPDATE pn_payment_terms_all

1989: v_max_index_period_id := get_last_index_period_rec.last_index_period_id;
1990: v_max_assessment_date := get_last_index_period_rec.last_assessment_date;
1991: END LOOP;
1992: v_last_period_assess_end_date := add_months(v_max_assessment_date, 12*(c_rec.assessment_interval)) -1;
1993: UPDATE pn_payment_terms_all
1994: SET end_date = least(NVL(p_term_end_dt,p_new_main_lease_term_date), v_last_period_assess_end_date),
1995: last_update_date = SYSDATE,
1996: last_updated_by = fnd_global.user_id,
1997: last_update_login = fnd_global.login_id

Line 2000: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp

1996: last_updated_by = fnd_global.user_id,
1997: last_update_login = fnd_global.login_id
1998: WHERE payment_term_id IN
1999: (SELECT ppt.payment_term_id
2000: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp
2001: WHERE pilp.index_period_id = ppt.index_period_id
2002: AND pilp.index_lease_id = c_rec.index_lease_id
2003: AND (ppt.status = pn_index_amount_pkg.c_payment_term_status_draft AND
2004: p_lease_context = 'CON')

Line 2085: UPDATE pn_payment_terms_all

2081: l_term(l_term_index).term_id := l_term_rec.payment_term_id;
2082: l_term(l_term_index).period_id := l_term_rec.index_period_id;
2083: l_term_index := l_term_index + 1;
2084: ELSE
2085: UPDATE pn_payment_terms_all
2086: SET end_date = p_new_main_lease_term_date,
2087: last_update_date = SYSDATE,
2088: last_updated_by = fnd_global.user_id,
2089: last_update_login = fnd_global.login_id

Line 2091: select status into l_status from pn_payment_terms_all where payment_term_id = terms_rec.payment_term_id;

2087: last_update_date = SYSDATE,
2088: last_updated_by = fnd_global.user_id,
2089: last_update_login = fnd_global.login_id
2090: WHERE payment_term_id = terms_rec.payment_term_id;
2091: select status into l_status from pn_payment_terms_all where payment_term_id = terms_rec.payment_term_id;
2092: if l_status <> 'DRAFT' then
2093:
2094: pn_schedules_items.Extend_Payment_Term
2095: (p_payment_term_rec => l_term_rec,

Line 2156: UPDATE pn_payment_terms_all

2152: ,ip_main_lease_termination_date => p_new_main_lease_term_date
2153: ,op_term_end_date => v_end_date);
2154:
2155:
2156: UPDATE pn_payment_terms_all
2157: SET end_date = v_end_date, --p_new_main_lease_term_date,
2158: last_update_date = SYSDATE,
2159: last_updated_by = fnd_global.user_id,
2160: last_update_login = fnd_global.login_id

Line 2165: from pn_payment_terms_all

2161: WHERE payment_term_id = l_term(i).term_id;
2162:
2163: select *
2164: into l_ri_term_rec
2165: from pn_payment_terms_all
2166: where payment_term_id = l_term(i).term_id;
2167:
2168: select status into l_status from pn_payment_terms_all where payment_term_id = l_term(i).term_id;
2169: if l_status <> 'DRAFT' then

Line 2168: select status into l_status from pn_payment_terms_all where payment_term_id = l_term(i).term_id;

2164: into l_ri_term_rec
2165: from pn_payment_terms_all
2166: where payment_term_id = l_term(i).term_id;
2167:
2168: select status into l_status from pn_payment_terms_all where payment_term_id = l_term(i).term_id;
2169: if l_status <> 'DRAFT' then
2170:
2171: pn_schedules_items.Extend_Payment_Term
2172: (p_payment_term_rec => l_ri_term_rec,

Line 2195: FROM PN_PAYMENT_TERMS_ALL PP,PN_INDEX_LEASES_ALL PI

2191: l_ri_term_rec := appr_terms_rec;
2192: /* added for bug #11671285*/
2193: select INDEX_PERIOD_ID,basis_type,reference_period
2194: into l_period_id,l_basis_type,l_ref_period
2195: FROM PN_PAYMENT_TERMS_ALL PP,PN_INDEX_LEASES_ALL PI
2196: WHERE PP.PAYMENT_TERM_ID = l_ri_term_rec.payment_term_id
2197: and pp.LEASE_ID = pi.LEASE_ID
2198: and rownum=1;
2199:

Line 2210: UPDATE pn_payment_terms_all

2206: ,ip_main_lease_termination_date => p_new_main_lease_term_date
2207: ,op_term_end_date => v_end_date);
2208:
2209: END IF; /* added for bug #11671285*/
2210: UPDATE pn_payment_terms_all
2211: SET end_date = v_end_date, --p_new_main_lease_term_date, /* bug # 11671285*/
2212: last_update_date = SYSDATE,
2213: last_updated_by = fnd_global.user_id,
2214: last_update_login = fnd_global.login_id

Line 2217: select status into l_status from pn_payment_terms_all where payment_term_id = l_ri_term_rec.payment_term_id;

2213: last_updated_by = fnd_global.user_id,
2214: last_update_login = fnd_global.login_id
2215: WHERE payment_term_id = l_ri_term_rec.payment_term_id;
2216:
2217: select status into l_status from pn_payment_terms_all where payment_term_id = l_ri_term_rec.payment_term_id;
2218: if l_status <> 'DRAFT' then
2219:
2220: pn_schedules_items.Extend_Payment_Term
2221: (p_payment_term_rec => l_ri_term_rec,

Line 2407: l_term_rec pn_payment_terms_all%ROWTYPE;

2403: l_lease_comm_date DATE;
2404: l_lease_term_date DATE;
2405: l_lease_ext_end_date DATE;
2406: l_amd_comm_date DATE;
2407: l_term_rec pn_payment_terms_all%ROWTYPE;
2408: l_term_st_date DATE;
2409: v_msg VARCHAR2(100);
2410: l_schd_date DATE;
2411: l_schd_day NUMBER := NULL;

Line 2441: FROM pn_payment_terms_all terms

2437: AND pps.lease_id = p_lease_id;
2438:
2439: CURSOR get_mtm_terms( p_lease_id NUMBER,p_term_end_date DATE) IS
2440: SELECT *
2441: FROM pn_payment_terms_all terms
2442: WHERE index_period_id IN ( SELECT index_period_id
2443: FROM pn_index_leases_all
2444: WHERE lease_id = p_lease_id)
2445: AND end_date = p_term_end_date

Line 2454: pn_payment_terms_all terms

2450: SELECT basis_type,
2451: reference_period
2452: FROM pn_index_leases_all ileases,
2453: pn_index_lease_periods_all periods,
2454: pn_payment_terms_all terms
2455: WHERE ileases.index_lease_id = periods.index_lease_id
2456: AND periods.index_period_id = terms.index_period_id
2457: AND terms.payment_term_id = p_payment_term_id;
2458:

Line 2551: UPDATE pn_payment_terms_all

2547: p_extended := TRUE;
2548:
2549: ELSE
2550:
2551: UPDATE pn_payment_terms_all
2552: SET end_date = l_lease_term_date,
2553: lease_change_id = l_lease_change_id,
2554: last_update_date = SYSDATE,
2555: last_updated_by = fnd_global.user_id,

Line 2597: l_payment_term_rec pn_payment_terms_all%ROWTYPE;

2593: ,p_new_termination_date IN DATE
2594: ,p_msg OUT NOCOPY VARCHAR2)
2595: IS
2596:
2597: l_payment_term_rec pn_payment_terms_all%ROWTYPE;
2598: x_return_message VARCHAR2(2000);
2599: x_return_status VARCHAR2(2000);
2600: l_lease_comm_date DATE;
2601: l_lease_term_date DATE;

Line 2616: FROM pn_payment_terms_all

2612: WHERE index_lease_id = p_index_lease_id;
2613:
2614: CURSOR get_ri_terms_to_modify IS
2615: SELECT *
2616: FROM pn_payment_terms_all
2617: WHERE ((index_period_id IN (SELECT index_period_id
2618: FROM pn_index_lease_periods_all
2619: WHERE index_lease_id = p_index_lease_id))
2620: /* -- OR commented for bug 16223906

Line 2629: FROM pn_payment_terms_all

2625: AND status = 'APPROVED';
2626:
2627: CURSOR get_ri_terms_to_exp IS
2628: SELECT *
2629: FROM pn_payment_terms_all
2630: WHERE ((index_period_id IN (SELECT index_period_id
2631: FROM pn_index_lease_periods_all
2632: WHERE index_lease_id = p_index_lease_id))
2633: /* -- OR commented for bug 16223906

Line 2655: FROM pn_payment_terms_all

2651: IS
2652: SELECT payment_schedule_id
2653: FROM pn_payment_schedules_all
2654: WHERE lease_id IN ( SELECT lease_id
2655: FROM pn_payment_terms_all
2656: WHERE payment_term_id = p_payment_term_id)
2657: AND payment_status_lookup_code = 'APPROVED'
2658: AND payment_schedule_id IN (SELECT payment_schedule_id
2659: FROM pn_payment_items_all

Line 2693: FROM PN_PAYMENT_TERMS_ALL

2689:
2690: CURSOR terms_cur (p1_lease_id IN NUMBER)
2691: IS
2692: SELECT UPDATE_NBP_FLAG
2693: FROM PN_PAYMENT_TERMS_ALL
2694: WHERE lease_id = p1_lease_id
2695: FOR UPDATE NOWAIT;
2696:
2697: CURSOR bkhd_exists_cur

Line 2740: UPDATE pn_payment_terms_all

2736: IF nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'LEASE_END' THEN
2737: FOR ri_terms_rec IN get_ri_terms_to_exp LOOP
2738: l_payment_term_rec := ri_terms_rec;
2739:
2740: UPDATE pn_payment_terms_all
2741: SET end_date = p_new_termination_date
2742: WHERE payment_term_id = l_payment_term_rec.payment_term_id;
2743:
2744: UPDATE pn_payment_terms_all

Line 2744: UPDATE pn_payment_terms_all

2740: UPDATE pn_payment_terms_all
2741: SET end_date = p_new_termination_date
2742: WHERE payment_term_id = l_payment_term_rec.payment_term_id;
2743:
2744: UPDATE pn_payment_terms_all
2745: SET UPDATE_NBP_FLAG = 'Y'
2746: WHERE payment_term_id = l_payment_term_rec.payment_term_id
2747: AND INCLUDE_IN_VAR_RENT IN ('BASETERM', 'INCLUDE_RI');
2748:

Line 2791: UPDATE pn_payment_terms_all

2787: END LOOP;
2788:
2789: IF l_appr_sched_exists THEN
2790:
2791: UPDATE pn_payment_terms_all
2792: SET end_date = p_new_termination_date,
2793: start_date = p_new_termination_date,
2794: actual_amount = 0
2795: WHERE payment_term_id = l_payment_term_rec.payment_term_id;

Line 2797: UPDATE pn_payment_terms_all

2793: start_date = p_new_termination_date,
2794: actual_amount = 0
2795: WHERE payment_term_id = l_payment_term_rec.payment_term_id;
2796:
2797: UPDATE pn_payment_terms_all
2798: SET UPDATE_NBP_FLAG = 'Y'
2799: WHERE payment_term_id = l_payment_term_rec.payment_term_id
2800: AND INCLUDE_IN_VAR_RENT IN ('BASETERM', 'INCLUDE_RI');
2801:

Line 2806: WHERE lease_id IN (SELECT lease_id FROM pn_payment_terms_all

2802: DELETE pn_payment_items_all
2803: WHERE payment_schedule_id IN
2804: (SELECT payment_schedule_id
2805: FROM pn_payment_schedules_all
2806: WHERE lease_id IN (SELECT lease_id FROM pn_payment_terms_all
2807: WHERE payment_term_id = l_payment_term_rec.payment_term_id)
2808: AND schedule_date > p_new_termination_date
2809: AND payment_status_lookup_code IN ('DRAFT', 'ON_HOLD'))
2810: AND payment_term_id = l_payment_term_rec.payment_term_id;

Line 2903: DELETE pn_payment_terms_all

2899:
2900: DELETE pn_distributions_all
2901: WHERE payment_term_id = l_payment_term_rec.payment_term_id;
2902:
2903: DELETE pn_payment_terms_all
2904: WHERE payment_term_id = l_payment_term_rec.payment_term_id;
2905:
2906: END IF;
2907:

Line 2912: UPDATE pn_payment_terms_all

2908: ELSIF l_payment_term_rec.start_date <= p_new_termination_date AND
2909: l_payment_term_rec.end_date >= p_new_termination_date
2910: THEN
2911:
2912: UPDATE pn_payment_terms_all
2913: SET end_date = p_new_termination_date
2914: WHERE payment_term_id = l_payment_term_rec.payment_term_id;
2915:
2916: DELETE pn_payment_items_all

Line 2920: WHERE lease_id IN (SELECT lease_id FROM pn_payment_terms_all

2916: DELETE pn_payment_items_all
2917: WHERE payment_schedule_id IN
2918: (SELECT payment_schedule_id
2919: FROM pn_payment_schedules_all
2920: WHERE lease_id IN (SELECT lease_id FROM pn_payment_terms_all
2921: WHERE payment_term_id = l_payment_term_rec.payment_term_id)
2922: AND schedule_date > p_new_termination_date
2923: AND payment_status_lookup_code IN ('DRAFT', 'ON_HOLD'))
2924: AND payment_term_id = l_payment_term_rec.payment_term_id;

Line 3051: UPDATE pn_payment_terms_all

3047:
3048:
3049: END LOOP;
3050:
3051: UPDATE pn_payment_terms_all
3052: SET UPDATE_NBP_FLAG = NULL
3053: WHERE lease_id = l_lease_id;
3054:
3055: END IF;