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.

[Home] [Help]

APPS.PN_INDEX_RENT_PERIODS_PKG dependencies on PN_PAYMENT_TERMS_ALL

Line 342: FROM pn_index_lease_periods_all pilp, pn_payment_terms_all ppt

338: ,ip_index_period_id IN NUMBER) IS
339: SELECT pilp.index_period_id
340: ,ppt.payment_term_id
341: ,ppt.lease_id
342: FROM pn_index_lease_periods_all pilp, pn_payment_terms_all ppt
343: WHERE pilp.index_lease_id = ip_index_lease_id
344: AND pilp.index_period_id = ppt.index_period_id
345: AND pilp.index_period_id = ip_index_period_id;
346: var number;

Line 399: FROM pn_payment_terms_all

395: --DBMS_OUTPUT.put_line ('deleting only non-approved payment terms...');
396: DELETE FROM pn_distributions_all
397: WHERE payment_term_id IN
398: (SELECT payment_term_id
399: FROM pn_payment_terms_all
400: WHERE payment_term_id = il_rec.payment_term_id
401: AND status<>
402: pn_index_amount_pkg.c_payment_term_status_approved);
403:

Line 404: DELETE FROM pn_payment_terms_all

400: WHERE payment_term_id = il_rec.payment_term_id
401: AND status<>
402: pn_index_amount_pkg.c_payment_term_status_approved);
403:
404: DELETE FROM pn_payment_terms_all
405: WHERE payment_term_id = il_rec.payment_term_id
406: AND status <> pn_index_amount_pkg.c_payment_term_status_approved;
407:
408: DELETE FROM pn_index_lease_terms_all

Line 428: UPDATE pn_payment_terms_all

424: l_latest_period_id := last_period_rec.index_period_id;
425: EXIT;
426: END LOOP;
427:
428: UPDATE pn_payment_terms_all
429: SET index_period_id = l_latest_period_id,
430: index_term_indicator = 'REVERSED'
431: WHERE payment_term_id = il_rec.payment_term_id;
432:

Line 457: DELETE FROM pn_payment_terms_all

453: DELETE FROM pn_distributions_all
454: WHERE payment_term_id = il_rec.payment_term_id;
455:
456:
457: DELETE FROM pn_payment_terms_all
458: WHERE payment_term_id = il_rec.payment_term_id;
459:
460: DELETE FROM pn_index_lease_terms_all
461: where rent_increase_term_id = il_rec.payment_term_id;

Line 466: DELETE FROM pn_payment_terms_all

462: END IF;
463:
464: ELSE
465:
466: DELETE FROM pn_payment_terms_all
467: WHERE payment_term_id = il_rec.payment_term_id;
468:
469: DELETE FROM pn_distributions_all
470: WHERE payment_term_id = il_rec.payment_term_id;

Line 1104: pn_payment_terms_all term,

1100: CURSOR approved_sched_exist(p_index_lease_id IN NUMBER) IS
1101: SELECT term.payment_term_id
1102: FROM pn_payment_schedules_all sched,
1103: pn_index_leases_all ilease,
1104: pn_payment_terms_all term,
1105: pn_payment_items_all item,
1106: pn_index_lease_periods_all period
1107: WHERE sched.lease_id = ilease.lease_id
1108: AND sched.payment_schedule_id = item.payment_schedule_id

Line 1141: FROM pn_payment_terms_all term,pn_index_lease_periods_all iperiod

1137: WHERE index_lease_id = p_index_lease_id ;
1138:
1139: DELETE FROM pn_payment_items_all
1140: WHERE payment_term_id IN ( SELECT term.payment_term_id
1141: FROM pn_payment_terms_all term,pn_index_lease_periods_all iperiod
1142: WHERE term.index_period_id = iperiod.index_period_id
1143: AND iperiod.index_lease_id = p_index_lease_id
1144: AND term.index_period_id IS NOT NULL);
1145:

Line 1154: FROM pn_payment_terms_all term,pn_index_lease_periods_all period

1150: WHERE item.payment_schedule_id = sched.payment_schedule_id);
1151:
1152: DELETE FROM pn_distributions_all
1153: WHERE payment_term_id IN (SELECT payment_term_id
1154: FROM pn_payment_terms_all term,pn_index_lease_periods_all period
1155: WHERE term.index_period_id = period.index_period_id
1156: AND period.index_lease_id = p_index_lease_id);
1157:
1158: DELETE FROM pn_payment_terms_all

Line 1158: DELETE FROM pn_payment_terms_all

1154: FROM pn_payment_terms_all term,pn_index_lease_periods_all period
1155: WHERE term.index_period_id = period.index_period_id
1156: AND period.index_lease_id = p_index_lease_id);
1157:
1158: DELETE FROM pn_payment_terms_all
1159: WHERE index_period_id IN (SELECT index_period_id
1160: FROM pn_index_lease_periods_all
1161: WHERE index_lease_id = p_index_lease_id);
1162:

Line 1428: FROM pn_payment_terms_all ppt,

1424: ppt.estimated_amount,
1425: decode(ppt.actual_amount,null,ppt.estimated_amount,ppt.actual_amount) term_amount,
1426: ppt.org_id,
1427: ppt.norm_end_date
1428: FROM pn_payment_terms_all ppt,
1429: pn_index_lease_periods_all pilp
1430: WHERE ppt.index_period_id = pilp.index_period_id
1431: AND pilp.index_lease_id = p_index_lease_id
1432: AND ppt.frequency_code = pn_index_amount_pkg.c_spread_frequency_one_time

Line 1575: UPDATE pn_payment_terms_all

1571: l_min_acct_unit);
1572: v_new_amount := ROUND(v_new_amount, l_precision);
1573:
1574: IF rec_payment_terms.actual_amount IS NOT NULL THEN
1575: UPDATE pn_payment_terms_all
1576: SET actual_amount = v_new_amount,
1577: last_update_date = SYSDATE,
1578: last_updated_by = fnd_global.user_id,
1579: last_update_login = fnd_global.login_id

Line 1599: UPDATE pn_payment_terms_all

1595: END;
1596:
1597: ELSIF rec_payment_terms.estimated_amount IS NOT NULL THEN
1598:
1599: UPDATE pn_payment_terms_all
1600: SET estimated_amount = v_new_amount,
1601: last_update_date = SYSDATE,
1602: last_updated_by = fnd_global.user_id,
1603: last_update_login = fnd_global.login_id

Line 1761: FROM pn_payment_terms_all term,pn_index_lease_periods_all period

1757:
1758: CURSOR get_term_4_mtm_update(p_index_lease_id NUMBER) IS
1759: SELECT term.payment_term_id payment_term_id,
1760: NVL(term.normalize,'N') normalize
1761: FROM pn_payment_terms_all term,pn_index_lease_periods_all period
1762: WHERE term.index_period_id = period.index_period_id
1763: AND period.index_lease_id = p_index_lease_id
1764: AND term.frequency_code <> pn_index_amount_pkg.c_spread_frequency_one_time
1765: AND term.end_date = p_old_main_lease_term_date;

Line 1769: FROM pn_payment_terms_all

1765: AND term.end_date = p_old_main_lease_term_date;
1766:
1767: CURSOR get_term_details ( p_term_id NUMBER) IS
1768: SELECT *
1769: FROM pn_payment_terms_all
1770: WHERE payment_term_id = p_term_id;
1771:
1772: CURSOR get_old_ls_end_date IS
1773: SELECT NVL(plh.lease_extension_end_date, plh.lease_termination_date) old_ls_end_date

Line 1791: FROM pn_payment_terms_all

1787: WHERE lease_id = p_lease_id;
1788:
1789: CURSOR get_appr_terms_to_extend(p_index_lease_id IN NUMBER) IS
1790: SELECT *
1791: FROM pn_payment_terms_all
1792: WHERE payment_term_id IN ( SELECT payment_term_id
1793: FROM pn_payment_terms_all terms, pn_index_lease_periods_all period
1794: WHERE terms.index_period_id = period.index_period_id
1795: AND period.index_lease_id = p_index_lease_id)

Line 1793: FROM pn_payment_terms_all terms, pn_index_lease_periods_all period

1789: CURSOR get_appr_terms_to_extend(p_index_lease_id IN NUMBER) IS
1790: SELECT *
1791: FROM pn_payment_terms_all
1792: WHERE payment_term_id IN ( SELECT payment_term_id
1793: FROM pn_payment_terms_all terms, pn_index_lease_periods_all period
1794: WHERE terms.index_period_id = period.index_period_id
1795: AND period.index_lease_id = p_index_lease_id)
1796: AND status ='APPROVED'
1797: AND frequency_code <>'OT'

Line 1800: l_term_rec pn_payment_terms_all%ROWTYPE;

1796: AND status ='APPROVED'
1797: AND frequency_code <>'OT'
1798: AND end_date = p_old_main_lease_term_date;
1799:
1800: l_term_rec pn_payment_terms_all%ROWTYPE;
1801: l_return_status VARCHAR2(100);
1802: l_schd_date DATE := NULL;
1803: l_schd_day NUMBER := NULL;
1804: l_extended BOOLEAN := FALSE;

Line 1811: l_ri_term_rec pn_payment_terms_all%ROWTYPE;

1807: l_ls_comm_dt DATE ;
1808: l_mths NUMBER;
1809: l_requestId NUMBER := NULL;
1810: l_lease_num PN_LEASES_ALL.lease_num%TYPE;
1811: l_ri_term_rec pn_payment_terms_all%ROWTYPE;
1812:
1813: BEGIN
1814: put_log('Processing Main Lease Termination Date for Index Rent increases');
1815: put_log('Parameters ');

Line 1900: UPDATE pn_payment_terms_all

1896:
1897: IF p_lease_context='EXP' AND NOT(l_extended) AND
1898: NVL(fnd_profile.value('PN_RENT_INCREASE_TERM_END_DATE'),'END_LEASE') ='END_LEASE'
1899: THEN
1900: UPDATE pn_payment_terms_all
1901: SET end_date = p_new_main_lease_term_date,
1902: last_update_date = SYSDATE,
1903: last_updated_by = fnd_global.user_id,
1904: last_update_login = fnd_global.login_id

Line 1907: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp

1903: last_updated_by = fnd_global.user_id,
1904: last_update_login = fnd_global.login_id
1905: WHERE payment_term_id IN
1906: (SELECT ppt.payment_term_id
1907: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp
1908: WHERE pilp.index_period_id = ppt.index_period_id
1909: AND pilp.index_lease_id = c_rec.index_lease_id
1910: AND p_lease_context <> 'CON'
1911: AND ppt.frequency_code <>

Line 1917: UPDATE pn_payment_terms_all

1913: AND ppt.end_date > p_cutoff_date)
1914: AND end_date = p_old_main_lease_term_date;
1915:
1916: ELSIF p_lease_context='CON' THEN
1917: UPDATE pn_payment_terms_all
1918: SET end_date = NVL(p_term_end_dt,p_new_main_lease_term_date),
1919: last_update_date = SYSDATE,
1920: last_updated_by = fnd_global.user_id,
1921: last_update_login = fnd_global.login_id

Line 1924: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp

1920: last_updated_by = fnd_global.user_id,
1921: last_update_login = fnd_global.login_id
1922: WHERE payment_term_id IN
1923: (SELECT ppt.payment_term_id
1924: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp
1925: WHERE pilp.index_period_id = ppt.index_period_id
1926: AND pilp.index_lease_id = c_rec.index_lease_id
1927: AND (ppt.status = pn_index_amount_pkg.c_payment_term_status_draft AND
1928: p_lease_context = 'CON')

Line 1942: UPDATE pn_payment_terms_all

1938: v_max_index_period_id := get_last_index_period_rec.last_index_period_id;
1939: v_max_assessment_date := get_last_index_period_rec.last_assessment_date;
1940: END LOOP;
1941: v_last_period_assess_end_date := add_months(v_max_assessment_date, 12*(c_rec.assessment_interval)) -1;
1942: UPDATE pn_payment_terms_all
1943: SET end_date = least(NVL(p_term_end_dt,p_new_main_lease_term_date), v_last_period_assess_end_date),
1944: last_update_date = SYSDATE,
1945: last_updated_by = fnd_global.user_id,
1946: last_update_login = fnd_global.login_id

Line 1949: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp

1945: last_updated_by = fnd_global.user_id,
1946: last_update_login = fnd_global.login_id
1947: WHERE payment_term_id IN
1948: (SELECT ppt.payment_term_id
1949: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all pilp
1950: WHERE pilp.index_period_id = ppt.index_period_id
1951: AND pilp.index_lease_id = c_rec.index_lease_id
1952: AND (ppt.status = pn_index_amount_pkg.c_payment_term_status_draft AND
1953: p_lease_context = 'CON')

Line 2026: UPDATE pn_payment_terms_all

2022: ELSE
2023:
2024: l_term_rec.end_date := p_new_main_lease_term_date;
2025:
2026: UPDATE pn_payment_terms_all
2027: SET end_date = p_new_main_lease_term_date,
2028: last_update_date = SYSDATE,
2029: last_updated_by = fnd_global.user_id,
2030: last_update_login = fnd_global.login_id

Line 2088: UPDATE pn_payment_terms_all

2084: FOR appr_terms_rec IN get_appr_terms_to_extend( index_leases_rec.index_lease_id) LOOP
2085:
2086: l_ri_term_rec := appr_terms_rec;
2087:
2088: UPDATE pn_payment_terms_all
2089: SET end_date = p_new_main_lease_term_date,
2090: last_update_date = SYSDATE,
2091: last_updated_by = fnd_global.user_id,
2092: last_update_login = fnd_global.login_id

Line 2281: l_term_rec pn_payment_terms_all%ROWTYPE;

2277: l_lease_comm_date DATE;
2278: l_lease_term_date DATE;
2279: l_lease_ext_end_date DATE;
2280: l_amd_comm_date DATE;
2281: l_term_rec pn_payment_terms_all%ROWTYPE;
2282: l_term_st_date DATE;
2283: v_msg VARCHAR2(100);
2284: l_schd_date DATE;
2285: l_schd_day NUMBER := NULL;

Line 2315: FROM pn_payment_terms_all terms

2311: AND pps.lease_id = p_lease_id;
2312:
2313: CURSOR get_mtm_terms( p_lease_id NUMBER,p_term_end_date DATE) IS
2314: SELECT *
2315: FROM pn_payment_terms_all terms
2316: WHERE index_period_id IN ( SELECT index_period_id
2317: FROM pn_index_leases_all
2318: WHERE lease_id = p_lease_id)
2319: AND end_date = p_term_end_date

Line 2328: pn_payment_terms_all terms

2324: SELECT basis_type,
2325: reference_period
2326: FROM pn_index_leases_all ileases,
2327: pn_index_lease_periods_all periods,
2328: pn_payment_terms_all terms
2329: WHERE ileases.index_lease_id = periods.index_lease_id
2330: AND periods.index_period_id = terms.index_period_id
2331: AND terms.payment_term_id = p_payment_term_id;
2332:

Line 2425: UPDATE pn_payment_terms_all

2421: p_extended := TRUE;
2422:
2423: ELSE
2424:
2425: UPDATE pn_payment_terms_all
2426: SET end_date = l_lease_term_date,
2427: lease_change_id = l_lease_change_id,
2428: last_update_date = SYSDATE,
2429: last_updated_by = fnd_global.user_id,

Line 2468: l_payment_term_rec pn_payment_terms_all%ROWTYPE;

2464: ,p_new_termination_date IN DATE
2465: ,p_msg OUT NOCOPY VARCHAR2)
2466: IS
2467:
2468: l_payment_term_rec pn_payment_terms_all%ROWTYPE;
2469: x_return_message VARCHAR2(2000);
2470: x_return_status VARCHAR2(2000);
2471: l_lease_comm_date DATE;
2472: l_lease_term_date DATE;

Line 2487: FROM pn_payment_terms_all

2483: WHERE index_lease_id = p_index_lease_id;
2484:
2485: CURSOR get_ri_terms_to_modify IS
2486: SELECT *
2487: FROM pn_payment_terms_all
2488: WHERE ((index_period_id IN (SELECT index_period_id
2489: FROM pn_index_lease_periods_all
2490: WHERE index_lease_id = p_index_lease_id))
2491: OR

Line 2511: FROM pn_payment_terms_all

2507: IS
2508: SELECT payment_schedule_id
2509: FROM pn_payment_schedules_all
2510: WHERE lease_id IN ( SELECT lease_id
2511: FROM pn_payment_terms_all
2512: WHERE payment_term_id = p_payment_term_id)
2513: AND payment_status_lookup_code = 'APPROVED'
2514: AND payment_schedule_id IN (SELECT payment_schedule_id
2515: FROM pn_payment_items_all

Line 2549: FROM PN_PAYMENT_TERMS_ALL

2545:
2546: CURSOR terms_cur (p1_lease_id IN NUMBER)
2547: IS
2548: SELECT UPDATE_NBP_FLAG
2549: FROM PN_PAYMENT_TERMS_ALL
2550: WHERE lease_id = p1_lease_id
2551: FOR UPDATE NOWAIT;
2552:
2553: CURSOR bkhd_exists_cur

Line 2595: UPDATE pn_payment_terms_all

2591:
2592: FOR ri_terms_rec IN get_ri_terms_to_modify LOOP
2593: l_payment_term_rec := ri_terms_rec;
2594:
2595: UPDATE pn_payment_terms_all
2596: SET end_date = p_new_termination_date
2597: WHERE payment_term_id = l_payment_term_rec.payment_term_id;
2598:
2599: UPDATE pn_payment_terms_all

Line 2599: UPDATE pn_payment_terms_all

2595: UPDATE pn_payment_terms_all
2596: SET end_date = p_new_termination_date
2597: WHERE payment_term_id = l_payment_term_rec.payment_term_id;
2598:
2599: UPDATE pn_payment_terms_all
2600: SET UPDATE_NBP_FLAG = 'Y'
2601: WHERE payment_term_id = l_payment_term_rec.payment_term_id
2602: AND INCLUDE_IN_VAR_RENT IN ('BASETERM', 'INCLUDE_RI');
2603:

Line 2646: UPDATE pn_payment_terms_all

2642: END LOOP;
2643:
2644: IF l_appr_sched_exists THEN
2645:
2646: UPDATE pn_payment_terms_all
2647: SET end_date = p_new_termination_date,
2648: start_date = p_new_termination_date,
2649: actual_amount = 0
2650: WHERE payment_term_id = l_payment_term_rec.payment_term_id;

Line 2652: UPDATE pn_payment_terms_all

2648: start_date = p_new_termination_date,
2649: actual_amount = 0
2650: WHERE payment_term_id = l_payment_term_rec.payment_term_id;
2651:
2652: UPDATE pn_payment_terms_all
2653: SET UPDATE_NBP_FLAG = 'Y'
2654: WHERE payment_term_id = l_payment_term_rec.payment_term_id
2655: AND INCLUDE_IN_VAR_RENT IN ('BASETERM', 'INCLUDE_RI');
2656:

Line 2661: WHERE lease_id IN (SELECT lease_id FROM pn_payment_terms_all

2657: DELETE pn_payment_items_all
2658: WHERE payment_schedule_id IN
2659: (SELECT payment_schedule_id
2660: FROM pn_payment_schedules_all
2661: WHERE lease_id IN (SELECT lease_id FROM pn_payment_terms_all
2662: WHERE payment_term_id = l_payment_term_rec.payment_term_id)
2663: AND schedule_date > p_new_termination_date
2664: AND payment_status_lookup_code IN ('DRAFT', 'ON_HOLD'))
2665: AND payment_term_id = l_payment_term_rec.payment_term_id;

Line 2757: DELETE pn_payment_terms_all

2753:
2754: DELETE pn_distributions_all
2755: WHERE payment_term_id = l_payment_term_rec.payment_term_id;
2756:
2757: DELETE pn_payment_terms_all
2758: WHERE payment_term_id = l_payment_term_rec.payment_term_id;
2759:
2760: END IF;
2761:

Line 2766: UPDATE pn_payment_terms_all

2762: ELSIF l_payment_term_rec.start_date <= p_new_termination_date AND
2763: l_payment_term_rec.end_date >= p_new_termination_date
2764: THEN
2765:
2766: UPDATE pn_payment_terms_all
2767: SET end_date = p_new_termination_date
2768: WHERE payment_term_id = l_payment_term_rec.payment_term_id;
2769:
2770: DELETE pn_payment_items_all

Line 2774: WHERE lease_id IN (SELECT lease_id FROM pn_payment_terms_all

2770: DELETE pn_payment_items_all
2771: WHERE payment_schedule_id IN
2772: (SELECT payment_schedule_id
2773: FROM pn_payment_schedules_all
2774: WHERE lease_id IN (SELECT lease_id FROM pn_payment_terms_all
2775: WHERE payment_term_id = l_payment_term_rec.payment_term_id)
2776: AND schedule_date > p_new_termination_date
2777: AND payment_status_lookup_code IN ('DRAFT', 'ON_HOLD'))
2778: AND payment_term_id = l_payment_term_rec.payment_term_id;

Line 2904: UPDATE pn_payment_terms_all

2900:
2901:
2902: END LOOP;
2903:
2904: UPDATE pn_payment_terms_all
2905: SET UPDATE_NBP_FLAG = NULL
2906: WHERE lease_id = l_lease_id;
2907:
2908: END IF;