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 402: pn_index_amount_pkg.c_payment_term_status_approved);

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

Line 406: AND status <> pn_index_amount_pkg.c_payment_term_status_approved;

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

Line 410: AND approved_flag <> pn_index_amount_pkg.c_payment_term_status_approved;

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

Line 1432: AND ppt.frequency_code = pn_index_amount_pkg.c_spread_frequency_one_time

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
1433: AND ppt.index_term_indicator not in(pn_index_amount_pkg.c_index_pay_term_type_atlst_bb,
1434: pn_index_amount_pkg.c_index_pay_term_type_backbill)
1435: AND ppt.start_date = ppt.end_date
1436: AND NVL( decode(ppt.actual_amount,null,ppt.estimated_amount,ppt.actual_amount),0 ) <> 0;

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

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
1433: AND ppt.index_term_indicator not in(pn_index_amount_pkg.c_index_pay_term_type_atlst_bb,
1434: pn_index_amount_pkg.c_index_pay_term_type_backbill)
1435: AND ppt.start_date = ppt.end_date
1436: AND NVL( decode(ppt.actual_amount,null,ppt.estimated_amount,ppt.actual_amount),0 ) <> 0;
1437:

Line 1434: pn_index_amount_pkg.c_index_pay_term_type_backbill)

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
1433: AND ppt.index_term_indicator not in(pn_index_amount_pkg.c_index_pay_term_type_atlst_bb,
1434: pn_index_amount_pkg.c_index_pay_term_type_backbill)
1435: AND ppt.start_date = ppt.end_date
1436: AND NVL( decode(ppt.actual_amount,null,ppt.estimated_amount,ppt.actual_amount),0 ) <> 0;
1437:
1438: CURSOR cur_total_amount(p_payment_term_id IN NUMBER)

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

1473: put_log('Payment term id : '||rec_payment_terms.payment_term_id);
1474:
1475: v_total_amount := 0;
1476: v_new_amount := 0;
1477: IF rec_payment_terms.status = pn_index_amount_pkg.c_payment_term_status_approved THEN
1478:
1479: FOR rec_total_amount in cur_total_amount(rec_payment_terms.payment_term_id)
1480: LOOP
1481: v_total_amount := rec_total_amount.total_amount;

Line 1487: l_calculate_date := pn_index_amount_pkg.Get_Calculate_Date(

1483: ELSE
1484: v_total_amount := rec_payment_terms.term_amount;
1485: END IF;
1486:
1487: l_calculate_date := pn_index_amount_pkg.Get_Calculate_Date(
1488: p_assessment_date => rec_payment_terms.assessment_date
1489: ,p_period_str_date => rec_payment_terms.basis_start_date
1490: ,p_org_id => rec_payment_terms.org_id
1491: );

Line 1525: pn_index_amount_pkg.create_payment_term_record (

1521: v_exp_amount := v_new_amount - v_total_amount;
1522: v_start_date := trunc(ip_old_main_lease_term_date) + 1;
1523:
1524: IF v_exp_amount <> 0 THEN
1525: pn_index_amount_pkg.create_payment_term_record (
1526: p_lease_id => ip_lease_id
1527: ,p_location_id => rec_payment_terms.location_id
1528: ,p_purpose_code => rec_payment_terms.payment_purpose_code
1529: ,p_index_period_id => rec_payment_terms.index_period_id

Line 1626: pn_index_amount_pkg.create_payment_term_record (

1622: END IF; -- v_actual_amount is not null
1623: ELSE
1624: v_con_amount := v_new_amount - v_total_amount ;
1625:
1626: pn_index_amount_pkg.create_payment_term_record (
1627: p_lease_id => ip_lease_id
1628: ,p_location_id => rec_payment_terms.location_id
1629: ,p_purpose_code => rec_payment_terms.payment_purpose_code
1630: ,p_index_period_id => rec_payment_terms.index_period_id

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

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;
1766:
1767: CURSOR get_term_details ( p_term_id NUMBER) IS
1768: SELECT *

Line 1912: pn_index_amount_pkg.c_spread_frequency_one_time

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 <>
1912: pn_index_amount_pkg.c_spread_frequency_one_time
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

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

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')
1929: AND ppt.frequency_code <>
1930: pn_index_amount_pkg.c_spread_frequency_one_time);
1931: END IF;

Line 1930: pn_index_amount_pkg.c_spread_frequency_one_time);

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')
1929: AND ppt.frequency_code <>
1930: pn_index_amount_pkg.c_spread_frequency_one_time);
1931: END IF;
1932:
1933: ELSIF nvl(fnd_profile.value('PN_IR_TERM_END_DATE'),'LEASE_END') = 'PERIOD_END' AND
1934: (c_rec.basis_type = 'FIXED' AND c_rec.reference_period = 'BASE_YEAR') AND

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

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')
1954: AND ppt.frequency_code <>
1955: pn_index_amount_pkg.c_spread_frequency_one_time)
1956: AND index_period_id = v_max_index_period_id;

Line 1955: pn_index_amount_pkg.c_spread_frequency_one_time)

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')
1954: AND ppt.frequency_code <>
1955: pn_index_amount_pkg.c_spread_frequency_one_time)
1956: AND index_period_id = v_max_index_period_id;
1957:
1958: END IF;
1959: END IF;

Line 2237: pn_index_amount_pkg.calculate_initial_basis (

2233: rec1.basis_end_date IS NOT NULL AND
2234: ((rec1.initial_basis IS NULL) OR (nvl(rec1.retain_initial_basis_flag,'N') = 'N')) AND
2235: rec1.line_number = 1 THEN
2236:
2237: pn_index_amount_pkg.calculate_initial_basis (
2238: p_index_lease_id => rec1.index_lease_id
2239: ,op_basis_amount => v_initial_basis_amt
2240: ,op_msg => v_msg);
2241:

Line 2249: pn_index_amount_pkg.calculate (

2245: ,last_updated_by = NVL (fnd_profile.VALUE ('USER_ID'), 0)
2246: WHERE index_lease_id = rec1.index_lease_id;
2247: END IF;
2248:
2249: pn_index_amount_pkg.calculate (
2250: ip_index_lease_id => rec1.index_lease_id
2251: ,ip_index_lease_period_id => rec1.index_period_id
2252: ,ip_recalculate => 'Y'
2253: ,op_msg => v_msg