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_INDEX_AMOUNT_PKG

Line 407: pn_index_amount_pkg.c_payment_term_status_approved);

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:
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;

Line 411: AND status <> pn_index_amount_pkg.c_payment_term_status_approved;

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
414: WHERE rent_increase_term_id = il_rec.payment_term_id
415: AND approved_flag <> pn_index_amount_pkg.c_payment_term_status_approved;

Line 415: AND approved_flag <> pn_index_amount_pkg.c_payment_term_status_approved;

411: AND status <> pn_index_amount_pkg.c_payment_term_status_approved;
412:
413: DELETE FROM pn_index_lease_terms_all
414: WHERE rent_increase_term_id = il_rec.payment_term_id
415: AND approved_flag <> pn_index_amount_pkg.c_payment_term_status_approved;
416:
417: ELSIF p_ignore_approved_terms = 'ALL' THEN
418: --since we are also deleting approved payment terms, schedules and items
419: --associated with those approved terms would have to be deleted too.

Line 1440: AND ppt.frequency_code = pn_index_amount_pkg.c_spread_frequency_one_time

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
1441: AND ppt.index_term_indicator not in(pn_index_amount_pkg.c_index_pay_term_type_atlst_bb,
1442: pn_index_amount_pkg.c_index_pay_term_type_backbill)
1443: AND ppt.start_date = ppt.end_date
1444: AND NVL( decode(ppt.actual_amount,null,ppt.estimated_amount,ppt.actual_amount),0 ) <> 0;

Line 1441: AND ppt.index_term_indicator not in(pn_index_amount_pkg.c_index_pay_term_type_atlst_bb,

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
1441: AND ppt.index_term_indicator not in(pn_index_amount_pkg.c_index_pay_term_type_atlst_bb,
1442: pn_index_amount_pkg.c_index_pay_term_type_backbill)
1443: AND ppt.start_date = ppt.end_date
1444: AND NVL( decode(ppt.actual_amount,null,ppt.estimated_amount,ppt.actual_amount),0 ) <> 0;
1445:

Line 1442: pn_index_amount_pkg.c_index_pay_term_type_backbill)

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
1441: AND ppt.index_term_indicator not in(pn_index_amount_pkg.c_index_pay_term_type_atlst_bb,
1442: pn_index_amount_pkg.c_index_pay_term_type_backbill)
1443: AND ppt.start_date = ppt.end_date
1444: AND NVL( decode(ppt.actual_amount,null,ppt.estimated_amount,ppt.actual_amount),0 ) <> 0;
1445:
1446: CURSOR cur_total_amount(p_payment_term_id IN NUMBER)

Line 1485: IF rec_payment_terms.status = pn_index_amount_pkg.c_payment_term_status_approved THEN

1481: put_log('Payment term id : '||rec_payment_terms.payment_term_id);
1482:
1483: v_total_amount := 0;
1484: v_new_amount := 0;
1485: IF rec_payment_terms.status = pn_index_amount_pkg.c_payment_term_status_approved THEN
1486:
1487: FOR rec_total_amount in cur_total_amount(rec_payment_terms.payment_term_id)
1488: LOOP
1489: v_total_amount := rec_total_amount.total_amount;

Line 1495: l_calculate_date := pn_index_amount_pkg.Get_Calculate_Date(

1491: ELSE
1492: v_total_amount := rec_payment_terms.term_amount;
1493: END IF;
1494:
1495: l_calculate_date := pn_index_amount_pkg.Get_Calculate_Date(
1496: p_assessment_date => rec_payment_terms.assessment_date
1497: ,p_period_str_date => rec_payment_terms.basis_start_date
1498: ,p_org_id => rec_payment_terms.org_id
1499: );

Line 1533: pn_index_amount_pkg.create_payment_term_record (

1529: v_exp_amount := v_new_amount - v_total_amount;
1530: v_start_date := trunc(ip_old_main_lease_term_date) + 1;
1531:
1532: IF v_exp_amount <> 0 THEN
1533: pn_index_amount_pkg.create_payment_term_record (
1534: p_lease_id => ip_lease_id
1535: ,p_location_id => rec_payment_terms.location_id
1536: ,p_purpose_code => rec_payment_terms.payment_purpose_code
1537: ,p_index_period_id => rec_payment_terms.index_period_id

Line 1634: pn_index_amount_pkg.create_payment_term_record (

1630: END IF; -- v_actual_amount is not null
1631: ELSE
1632: v_con_amount := v_new_amount - v_total_amount ;
1633:
1634: pn_index_amount_pkg.create_payment_term_record (
1635: p_lease_id => ip_lease_id
1636: ,p_location_id => rec_payment_terms.location_id
1637: ,p_purpose_code => rec_payment_terms.payment_purpose_code
1638: ,p_index_period_id => rec_payment_terms.index_period_id

Line 1775: AND term.frequency_code <> pn_index_amount_pkg.c_spread_frequency_one_time

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;
1777:
1778: CURSOR get_term_details ( p_term_id NUMBER) IS
1779: SELECT *

Line 1818: pn_index_amount_pkg.c_spread_frequency_one_time

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 <>
1818: pn_index_amount_pkg.c_spread_frequency_one_time
1819: AND ppt.end_date > p_cutoff_date
1820: AND ppt.end_date = p_old_main_lease_term_date;
1821:
1822:

Line 1978: AND (ppt.status = pn_index_amount_pkg.c_payment_term_status_draft AND

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')
1980: AND ppt.frequency_code <>
1981: pn_index_amount_pkg.c_spread_frequency_one_time);
1982: END IF;

Line 1981: pn_index_amount_pkg.c_spread_frequency_one_time);

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')
1980: AND ppt.frequency_code <>
1981: pn_index_amount_pkg.c_spread_frequency_one_time);
1982: END IF;
1983:
1984: ELSIF nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'PERIOD_END' AND
1985: (c_rec.basis_type = 'FIXED' AND c_rec.reference_period = 'BASE_YEAR') AND

Line 2003: AND (ppt.status = pn_index_amount_pkg.c_payment_term_status_draft AND

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')
2005: AND ppt.frequency_code <>
2006: pn_index_amount_pkg.c_spread_frequency_one_time)
2007: AND index_period_id = v_max_index_period_id;

Line 2006: pn_index_amount_pkg.c_spread_frequency_one_time)

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')
2005: AND ppt.frequency_code <>
2006: pn_index_amount_pkg.c_spread_frequency_one_time)
2007: AND index_period_id = v_max_index_period_id;
2008:
2009: END IF;
2010: END IF;

Line 2149: pn_index_amount_pkg.derive_term_end_date(

2145: LOOP
2146:
2147: IF l_term(i).index_id = index_leases_rec.index_lease_id THEN
2148:
2149: pn_index_amount_pkg.derive_term_end_date(
2150: ip_index_lease_id => index_leases_rec.index_lease_id
2151: ,ip_index_period_id => l_term(i).period_id
2152: ,ip_main_lease_termination_date => p_new_main_lease_term_date
2153: ,op_term_end_date => v_end_date);

Line 2203: pn_index_amount_pkg.derive_term_end_date(

2199:
2200:
2201: IF nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'PERIOD_END' AND
2202: (l_basis_type = 'FIXED' AND l_ref_period = 'BASE_YEAR') THEN
2203: pn_index_amount_pkg.derive_term_end_date(
2204: ip_index_lease_id => index_leases_rec.index_lease_id
2205: ,ip_index_period_id => l_period_id
2206: ,ip_main_lease_termination_date => p_new_main_lease_term_date
2207: ,op_term_end_date => v_end_date);

Line 2363: pn_index_amount_pkg.calculate_initial_basis (

2359: rec1.basis_end_date IS NOT NULL AND
2360: ((rec1.initial_basis IS NULL) OR (nvl(rec1.retain_initial_basis_flag,'N') = 'N')) AND
2361: rec1.line_number = 1 THEN
2362:
2363: pn_index_amount_pkg.calculate_initial_basis (
2364: p_index_lease_id => rec1.index_lease_id
2365: ,op_basis_amount => v_initial_basis_amt
2366: ,op_msg => v_msg);
2367:

Line 2375: pn_index_amount_pkg.calculate (

2371: ,last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
2372: WHERE index_lease_id = rec1.index_lease_id;
2373: END IF;
2374:
2375: pn_index_amount_pkg.calculate (
2376: ip_index_lease_id => rec1.index_lease_id
2377: ,ip_index_lease_period_id => rec1.index_period_id
2378: ,ip_recalculate => 'Y'
2379: ,op_msg => v_msg