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_AMOUNT_PKG dependencies on PN_INDEX_LEASE_PERIODS

Line 548: FROM pn_index_lease_periods_all pilp

544: ,pilp.current_index_line_value
545: ,pilp.previous_index_line_id
546: ,pilp.previous_index_line_value
547: ,pilp.unconstraint_rent_due
548: FROM pn_index_lease_periods_all pilp
549: WHERE pilp.index_lease_id = ip_index_lease_id
550: AND pilp.index_period_id = ip_index_period_id
551: ORDER BY pilp.line_number;
552:

Line 654: FROM pn_index_lease_periods_all pilp

650: --
651:
652: SELECT pilp.index_period_id
653: INTO op_prev_index_lease_id
654: FROM pn_index_lease_periods_all pilp
655: WHERE pilp.index_lease_id = p_index_lease_id
656: AND pilp.assessment_date = (SELECT MAX (pilp.assessment_date)
657: FROM pn_index_lease_periods_all pilp
658: WHERE pilp.index_lease_id = p_index_lease_id

Line 657: FROM pn_index_lease_periods_all pilp

653: INTO op_prev_index_lease_id
654: FROM pn_index_lease_periods_all pilp
655: WHERE pilp.index_lease_id = p_index_lease_id
656: AND pilp.assessment_date = (SELECT MAX (pilp.assessment_date)
657: FROM pn_index_lease_periods_all pilp
658: WHERE pilp.index_lease_id = p_index_lease_id
659: /*
660: -- if p_assessment_date is null, this will return the
661: -- assessment date of the last index rent period.

Line 687: v_index_period_id pn_index_lease_periods.index_period_id%TYPE;

683: ,p_assessment_date IN DATE
684: ,op_type IN VARCHAR2 -- Type: UNCONSTRAINT OR CONSTRAINT
685: ,op_index_amount OUT NOCOPY NUMBER
686: ) IS
687: v_index_period_id pn_index_lease_periods.index_period_id%TYPE;
688: BEGIN
689: --put_log ('..In derive_prev_index_amount');
690:
691: --

Line 707: FROM pn_index_lease_periods_all pilp

703: ,'UNCONSTRAINT', unconstraint_rent_due
704: ,'CONSTRAINT', constraint_rent_due
705: )
706: INTO op_index_amount
707: FROM pn_index_lease_periods_all pilp
708: WHERE index_period_id = v_index_period_id;
709: END IF;
710: EXCEPTION
711: WHEN OTHERS THEN

Line 737: FROM pn_index_lease_periods_all pilp

733: --put_log ('..In derive_next_peroid_details');
734:
735: SELECT pilp.index_period_id,pilp.basis_start_date,pilp.basis_end_date
736: INTO op_next_index_period_id,op_basis_start_date,op_basis_end_date
737: FROM pn_index_lease_periods_all pilp
738: WHERE pilp.index_lease_id = p_index_lease_id
739: AND pilp.assessment_date = (SELECT MIN (pilp.assessment_date)
740: FROM pn_index_lease_periods_all pilp
741: WHERE pilp.index_lease_id = p_index_lease_id

Line 740: FROM pn_index_lease_periods_all pilp

736: INTO op_next_index_period_id,op_basis_start_date,op_basis_end_date
737: FROM pn_index_lease_periods_all pilp
738: WHERE pilp.index_lease_id = p_index_lease_id
739: AND pilp.assessment_date = (SELECT MIN (pilp.assessment_date)
740: FROM pn_index_lease_periods_all pilp
741: WHERE pilp.index_lease_id = p_index_lease_id
742: AND pilp.assessment_date > p_assessment_date
743: );
744:

Line 768: v_annual_basis_amount pn_index_lease_periods.current_basis%TYPE;

764: ,p_basis_end_date IN DATE
765: ,op_basis_amount_annual OUT NOCOPY NUMBER
766: ) IS
767: v_basis_duration NUMBER;
768: v_annual_basis_amount pn_index_lease_periods.current_basis%TYPE;
769: BEGIN
770: v_basis_duration := CEIL (MONTHS_BETWEEN (p_basis_end_date, p_basis_start_date));
771:
772: --

Line 831: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all ppi

827: ,c_spread_frequency_one_time, 0
828: )
829: )
830: INTO p_prev_index_amount
831: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all ppi
832: WHERE ppt.index_period_id = ppi.index_period_id
833: AND ppi.index_lease_id = p_index_lease_id
834: AND ppi.assessment_date < (SELECT assessment_date
835: FROM pn_index_lease_periods_all

Line 835: FROM pn_index_lease_periods_all

831: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all ppi
832: WHERE ppt.index_period_id = ppi.index_period_id
833: AND ppi.index_lease_id = p_index_lease_id
834: AND ppi.assessment_date < (SELECT assessment_date
835: FROM pn_index_lease_periods_all
836: WHERE index_period_id = p_index_period_id)
837: AND ppt.lease_id = p_lease_id;
838: EXCEPTION
839: WHEN OTHERS THEN

Line 872: FROM pn_index_lease_periods_all pilp

868: ,'CONSTRAINT', constraint_rent_due
869: )
870: )
871: INTO p_sum_prev_index_amts
872: FROM pn_index_lease_periods_all pilp
873: WHERE pilp.index_lease_id = p_index_lease_id
874: AND pilp.assessment_date < p_assessment_date;
875: EXCEPTION
876: WHEN OTHERS THEN

Line 941: FROM pn_index_lease_periods_all ppilx

937: = DECODE(p_payment_type, c_increase_on_gross,
938: ppt.payment_term_type_code, p_payment_type)
939: AND NVL(ppt.index_period_id, -1) NOT IN
940: (SELECT index_period_id
941: FROM pn_index_lease_periods_all ppilx
942: WHERE ppilx.index_lease_id = p_index_lease_id)
943: AND NVL(ppt.status,'-1')
944: = DECODE(ppt.index_period_id, NULL,
945: NVL(ppt.status,'-1'), 'APPROVED')

Line 981: FROM pn_index_lease_periods_all ppilx

977: = DECODE(p_payment_type, c_increase_on_gross,
978: ppt.payment_term_type_code, p_payment_type)
979: AND NVL(ppt.index_period_id, -1) NOT IN
980: (SELECT index_period_id
981: FROM pn_index_lease_periods_all ppilx
982: WHERE ppilx.index_lease_id = p_index_lease_id)
983: AND NVL(ppt.status,'-1')
984: = DECODE(ppt.index_period_id, NULL,
985: NVL(ppt.status,'-1'), 'APPROVED')

Line 1314: v_prev_index_amt pn_index_lease_periods.constraint_rent_due%TYPE;

1310: ) IS
1311:
1312: --v_basis_amt_oper_expenses NUMBER;
1313: --v_basis_amt_base_rent NUMBER;
1314: v_prev_index_amt pn_index_lease_periods.constraint_rent_due%TYPE;
1315: v_msg VARCHAR2 (1000);
1316: v_basis_amount pn_index_lease_periods.current_basis%TYPE;
1317: v_previous_basis_amount pn_index_lease_periods.current_basis%TYPE;
1318: v_previous_index_id pn_index_lease_periods.index_period_id%TYPE;

Line 1316: v_basis_amount pn_index_lease_periods.current_basis%TYPE;

1312: --v_basis_amt_oper_expenses NUMBER;
1313: --v_basis_amt_base_rent NUMBER;
1314: v_prev_index_amt pn_index_lease_periods.constraint_rent_due%TYPE;
1315: v_msg VARCHAR2 (1000);
1316: v_basis_amount pn_index_lease_periods.current_basis%TYPE;
1317: v_previous_basis_amount pn_index_lease_periods.current_basis%TYPE;
1318: v_previous_index_id pn_index_lease_periods.index_period_id%TYPE;
1319: v_sum_prev_index_amts NUMBER;
1320: v_annual_basis_amount NUMBER;

Line 1317: v_previous_basis_amount pn_index_lease_periods.current_basis%TYPE;

1313: --v_basis_amt_base_rent NUMBER;
1314: v_prev_index_amt pn_index_lease_periods.constraint_rent_due%TYPE;
1315: v_msg VARCHAR2 (1000);
1316: v_basis_amount pn_index_lease_periods.current_basis%TYPE;
1317: v_previous_basis_amount pn_index_lease_periods.current_basis%TYPE;
1318: v_previous_index_id pn_index_lease_periods.index_period_id%TYPE;
1319: v_sum_prev_index_amts NUMBER;
1320: v_annual_basis_amount NUMBER;
1321:

Line 1318: v_previous_index_id pn_index_lease_periods.index_period_id%TYPE;

1314: v_prev_index_amt pn_index_lease_periods.constraint_rent_due%TYPE;
1315: v_msg VARCHAR2 (1000);
1316: v_basis_amount pn_index_lease_periods.current_basis%TYPE;
1317: v_previous_basis_amount pn_index_lease_periods.current_basis%TYPE;
1318: v_previous_index_id pn_index_lease_periods.index_period_id%TYPE;
1319: v_sum_prev_index_amts NUMBER;
1320: v_annual_basis_amount NUMBER;
1321:
1322: BEGIN

Line 1505: FROM pn_index_leases_all pil, pn_index_lease_periods_all pilp

1501: ,nvl(pil.increase_on,c_increase_on_gross) "INCREASE_ON"
1502: ,pilp.index_period_id
1503: ,pilp.basis_start_date
1504: ,pilp.basis_end_date
1505: FROM pn_index_leases_all pil, pn_index_lease_periods_all pilp
1506: WHERE pil.index_lease_id = pilp.index_lease_id
1507: AND pil.index_lease_id = p_index_lease_id
1508: AND pilp.line_number = 1;
1509:

Line 1511: v_basis_amt_oper_expenses pn_index_lease_periods.current_basis%TYPE;

1507: AND pil.index_lease_id = p_index_lease_id
1508: AND pilp.line_number = 1;
1509:
1510: ilp_rec ilp_curr%ROWTYPE;
1511: v_basis_amt_oper_expenses pn_index_lease_periods.current_basis%TYPE;
1512: v_basis_amt_base_rent pn_index_lease_periods.current_basis%TYPE;
1513: --v_prev_index_amt NUMBER;
1514: v_basis_amount pn_index_lease_periods.current_basis%TYPE;
1515: v_msg VARCHAR2 (1000);

Line 1512: v_basis_amt_base_rent pn_index_lease_periods.current_basis%TYPE;

1508: AND pilp.line_number = 1;
1509:
1510: ilp_rec ilp_curr%ROWTYPE;
1511: v_basis_amt_oper_expenses pn_index_lease_periods.current_basis%TYPE;
1512: v_basis_amt_base_rent pn_index_lease_periods.current_basis%TYPE;
1513: --v_prev_index_amt NUMBER;
1514: v_basis_amount pn_index_lease_periods.current_basis%TYPE;
1515: v_msg VARCHAR2 (1000);
1516: v_annual_basis_amt pn_index_lease_periods.current_basis%TYPE;

Line 1514: v_basis_amount pn_index_lease_periods.current_basis%TYPE;

1510: ilp_rec ilp_curr%ROWTYPE;
1511: v_basis_amt_oper_expenses pn_index_lease_periods.current_basis%TYPE;
1512: v_basis_amt_base_rent pn_index_lease_periods.current_basis%TYPE;
1513: --v_prev_index_amt NUMBER;
1514: v_basis_amount pn_index_lease_periods.current_basis%TYPE;
1515: v_msg VARCHAR2 (1000);
1516: v_annual_basis_amt pn_index_lease_periods.current_basis%TYPE;
1517: l_include_index_items VARCHAR2(1) := null;
1518:

Line 1516: v_annual_basis_amt pn_index_lease_periods.current_basis%TYPE;

1512: v_basis_amt_base_rent pn_index_lease_periods.current_basis%TYPE;
1513: --v_prev_index_amt NUMBER;
1514: v_basis_amount pn_index_lease_periods.current_basis%TYPE;
1515: v_msg VARCHAR2 (1000);
1516: v_annual_basis_amt pn_index_lease_periods.current_basis%TYPE;
1517: l_include_index_items VARCHAR2(1) := null;
1518:
1519: BEGIN
1520: put_log ('..In calculate_initial_basis');

Line 1593: v_annual_basis_amt pn_index_lease_periods.current_basis%TYPE;

1589: ,p_current_basis IN NUMBER
1590: ,op_index_amount OUT NOCOPY NUMBER
1591: ,op_msg OUT NOCOPY VARCHAR2
1592: ) IS
1593: v_annual_basis_amt pn_index_lease_periods.current_basis%TYPE;
1594: v_percent_multiplier NUMBER;
1595: v_found_all_reqd_fields BOOLEAN;
1596: v_index_rent_amount pn_index_lease_periods.unconstraint_rent_due%TYPE;
1597: v_msg VARCHAR2 (1000);

Line 1596: v_index_rent_amount pn_index_lease_periods.unconstraint_rent_due%TYPE;

1592: ) IS
1593: v_annual_basis_amt pn_index_lease_periods.current_basis%TYPE;
1594: v_percent_multiplier NUMBER;
1595: v_found_all_reqd_fields BOOLEAN;
1596: v_index_rent_amount pn_index_lease_periods.unconstraint_rent_due%TYPE;
1597: v_msg VARCHAR2 (1000);
1598: BEGIN
1599: --put_log ('..In calculate_index_amount');
1600: --

Line 1709: l_prev_period_index_amt pn_index_lease_periods.constraint_rent_due%type:=null;

1705: l_lower_bound_amt NUMBER:=null;
1706: l_upper_bound_amt NUMBER:=null;
1707: l_min_current_period NUMBER:=null;
1708: l_max_current_period NUMBER:=null;
1709: l_prev_period_index_amt pn_index_lease_periods.constraint_rent_due%type:=null;
1710: l_previous_negative_rent pn_index_lease_periods.unconstraint_rent_due%type:=null;
1711: l_constrained_amount pn_index_lease_periods.constraint_rent_due%type:=null;
1712: l_unconstrained_amount pn_index_lease_periods.unconstraint_rent_due%type:=null;
1713: l_last_index_period_id pn_index_lease_periods.index_period_id%type:=null;

Line 1710: l_previous_negative_rent pn_index_lease_periods.unconstraint_rent_due%type:=null;

1706: l_upper_bound_amt NUMBER:=null;
1707: l_min_current_period NUMBER:=null;
1708: l_max_current_period NUMBER:=null;
1709: l_prev_period_index_amt pn_index_lease_periods.constraint_rent_due%type:=null;
1710: l_previous_negative_rent pn_index_lease_periods.unconstraint_rent_due%type:=null;
1711: l_constrained_amount pn_index_lease_periods.constraint_rent_due%type:=null;
1712: l_unconstrained_amount pn_index_lease_periods.unconstraint_rent_due%type:=null;
1713: l_last_index_period_id pn_index_lease_periods.index_period_id%type:=null;
1714: l_min_current_constr_pct pn_index_lease_periods.constraint_applied_percent%type:=null;

Line 1711: l_constrained_amount pn_index_lease_periods.constraint_rent_due%type:=null;

1707: l_min_current_period NUMBER:=null;
1708: l_max_current_period NUMBER:=null;
1709: l_prev_period_index_amt pn_index_lease_periods.constraint_rent_due%type:=null;
1710: l_previous_negative_rent pn_index_lease_periods.unconstraint_rent_due%type:=null;
1711: l_constrained_amount pn_index_lease_periods.constraint_rent_due%type:=null;
1712: l_unconstrained_amount pn_index_lease_periods.unconstraint_rent_due%type:=null;
1713: l_last_index_period_id pn_index_lease_periods.index_period_id%type:=null;
1714: l_min_current_constr_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1715: l_max_current_constr_pct pn_index_lease_periods.constraint_applied_percent%type:=null;

Line 1712: l_unconstrained_amount pn_index_lease_periods.unconstraint_rent_due%type:=null;

1708: l_max_current_period NUMBER:=null;
1709: l_prev_period_index_amt pn_index_lease_periods.constraint_rent_due%type:=null;
1710: l_previous_negative_rent pn_index_lease_periods.unconstraint_rent_due%type:=null;
1711: l_constrained_amount pn_index_lease_periods.constraint_rent_due%type:=null;
1712: l_unconstrained_amount pn_index_lease_periods.unconstraint_rent_due%type:=null;
1713: l_last_index_period_id pn_index_lease_periods.index_period_id%type:=null;
1714: l_min_current_constr_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1715: l_max_current_constr_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1716: l_min_current_constr_amt pn_index_lease_periods.constraint_applied_amount%type:=null;

Line 1713: l_last_index_period_id pn_index_lease_periods.index_period_id%type:=null;

1709: l_prev_period_index_amt pn_index_lease_periods.constraint_rent_due%type:=null;
1710: l_previous_negative_rent pn_index_lease_periods.unconstraint_rent_due%type:=null;
1711: l_constrained_amount pn_index_lease_periods.constraint_rent_due%type:=null;
1712: l_unconstrained_amount pn_index_lease_periods.unconstraint_rent_due%type:=null;
1713: l_last_index_period_id pn_index_lease_periods.index_period_id%type:=null;
1714: l_min_current_constr_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1715: l_max_current_constr_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1716: l_min_current_constr_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1717: l_max_current_constr_amt pn_index_lease_periods.constraint_applied_amount%type:=null;

Line 1714: l_min_current_constr_pct pn_index_lease_periods.constraint_applied_percent%type:=null;

1710: l_previous_negative_rent pn_index_lease_periods.unconstraint_rent_due%type:=null;
1711: l_constrained_amount pn_index_lease_periods.constraint_rent_due%type:=null;
1712: l_unconstrained_amount pn_index_lease_periods.unconstraint_rent_due%type:=null;
1713: l_last_index_period_id pn_index_lease_periods.index_period_id%type:=null;
1714: l_min_current_constr_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1715: l_max_current_constr_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1716: l_min_current_constr_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1717: l_max_current_constr_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1718: l_lower_bound_const_pct pn_index_lease_periods.constraint_applied_percent%type:=null;

Line 1715: l_max_current_constr_pct pn_index_lease_periods.constraint_applied_percent%type:=null;

1711: l_constrained_amount pn_index_lease_periods.constraint_rent_due%type:=null;
1712: l_unconstrained_amount pn_index_lease_periods.unconstraint_rent_due%type:=null;
1713: l_last_index_period_id pn_index_lease_periods.index_period_id%type:=null;
1714: l_min_current_constr_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1715: l_max_current_constr_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1716: l_min_current_constr_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1717: l_max_current_constr_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1718: l_lower_bound_const_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1719: l_lower_bound_const_amt pn_index_lease_periods.constraint_applied_amount%type:=null;

Line 1716: l_min_current_constr_amt pn_index_lease_periods.constraint_applied_amount%type:=null;

1712: l_unconstrained_amount pn_index_lease_periods.unconstraint_rent_due%type:=null;
1713: l_last_index_period_id pn_index_lease_periods.index_period_id%type:=null;
1714: l_min_current_constr_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1715: l_max_current_constr_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1716: l_min_current_constr_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1717: l_max_current_constr_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1718: l_lower_bound_const_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1719: l_lower_bound_const_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1720: l_upper_bound_const_pct pn_index_lease_periods.constraint_applied_percent%type:=null;

Line 1717: l_max_current_constr_amt pn_index_lease_periods.constraint_applied_amount%type:=null;

1713: l_last_index_period_id pn_index_lease_periods.index_period_id%type:=null;
1714: l_min_current_constr_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1715: l_max_current_constr_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1716: l_min_current_constr_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1717: l_max_current_constr_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1718: l_lower_bound_const_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1719: l_lower_bound_const_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1720: l_upper_bound_const_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1721: l_upper_bound_const_amt pn_index_lease_periods.constraint_applied_amount%type:=null;

Line 1718: l_lower_bound_const_pct pn_index_lease_periods.constraint_applied_percent%type:=null;

1714: l_min_current_constr_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1715: l_max_current_constr_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1716: l_min_current_constr_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1717: l_max_current_constr_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1718: l_lower_bound_const_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1719: l_lower_bound_const_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1720: l_upper_bound_const_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1721: l_upper_bound_const_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1722: l_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type:=null;

Line 1719: l_lower_bound_const_amt pn_index_lease_periods.constraint_applied_amount%type:=null;

1715: l_max_current_constr_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1716: l_min_current_constr_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1717: l_max_current_constr_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1718: l_lower_bound_const_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1719: l_lower_bound_const_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1720: l_upper_bound_const_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1721: l_upper_bound_const_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1722: l_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type:=null;
1723: l_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type:=null;

Line 1720: l_upper_bound_const_pct pn_index_lease_periods.constraint_applied_percent%type:=null;

1716: l_min_current_constr_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1717: l_max_current_constr_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1718: l_lower_bound_const_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1719: l_lower_bound_const_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1720: l_upper_bound_const_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1721: l_upper_bound_const_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1722: l_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type:=null;
1723: l_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type:=null;
1724:

Line 1721: l_upper_bound_const_amt pn_index_lease_periods.constraint_applied_amount%type:=null;

1717: l_max_current_constr_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1718: l_lower_bound_const_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1719: l_lower_bound_const_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1720: l_upper_bound_const_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1721: l_upper_bound_const_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1722: l_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type:=null;
1723: l_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type:=null;
1724:
1725: BEGIN

Line 1722: l_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type:=null;

1718: l_lower_bound_const_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1719: l_lower_bound_const_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1720: l_upper_bound_const_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1721: l_upper_bound_const_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1722: l_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type:=null;
1723: l_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type:=null;
1724:
1725: BEGIN
1726:

Line 1723: l_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type:=null;

1719: l_lower_bound_const_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1720: l_upper_bound_const_pct pn_index_lease_periods.constraint_applied_percent%type:=null;
1721: l_upper_bound_const_amt pn_index_lease_periods.constraint_applied_amount%type:=null;
1722: l_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type:=null;
1723: l_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type:=null;
1724:
1725: BEGIN
1726:
1727: put_log ('pn_index_amount_pkg.derive_constrained_rent (+): ');

Line 2087: v_current_cpi_value pn_index_lease_periods.current_index_line_value%TYPE;

2083: ,op_previous_cpi_id IN OUT NOCOPY NUMBER
2084: ,op_index_percent_change OUT NOCOPY NUMBER
2085: ,op_msg OUT NOCOPY VARCHAR2
2086: ) IS
2087: v_current_cpi_value pn_index_lease_periods.current_index_line_value%TYPE;
2088: v_current_cpi_id pn_index_lease_periods.current_index_line_id%TYPE;
2089: v_previous_cpi_value pn_index_lease_periods.previous_index_line_value%TYPE;
2090: v_previous_cpi_id pn_index_lease_periods.previous_index_line_id%TYPE;
2091: v_prev_assessment_date pn_index_lease_periods.assessment_date%TYPE;

Line 2088: v_current_cpi_id pn_index_lease_periods.current_index_line_id%TYPE;

2084: ,op_index_percent_change OUT NOCOPY NUMBER
2085: ,op_msg OUT NOCOPY VARCHAR2
2086: ) IS
2087: v_current_cpi_value pn_index_lease_periods.current_index_line_value%TYPE;
2088: v_current_cpi_id pn_index_lease_periods.current_index_line_id%TYPE;
2089: v_previous_cpi_value pn_index_lease_periods.previous_index_line_value%TYPE;
2090: v_previous_cpi_id pn_index_lease_periods.previous_index_line_id%TYPE;
2091: v_prev_assessment_date pn_index_lease_periods.assessment_date%TYPE;
2092: v_prev_period_id pn_index_lease_periods.index_period_id%TYPE;

Line 2089: v_previous_cpi_value pn_index_lease_periods.previous_index_line_value%TYPE;

2085: ,op_msg OUT NOCOPY VARCHAR2
2086: ) IS
2087: v_current_cpi_value pn_index_lease_periods.current_index_line_value%TYPE;
2088: v_current_cpi_id pn_index_lease_periods.current_index_line_id%TYPE;
2089: v_previous_cpi_value pn_index_lease_periods.previous_index_line_value%TYPE;
2090: v_previous_cpi_id pn_index_lease_periods.previous_index_line_id%TYPE;
2091: v_prev_assessment_date pn_index_lease_periods.assessment_date%TYPE;
2092: v_prev_period_id pn_index_lease_periods.index_period_id%TYPE;
2093: v_num_months_bet_asmnt_date NUMBER;

Line 2090: v_previous_cpi_id pn_index_lease_periods.previous_index_line_id%TYPE;

2086: ) IS
2087: v_current_cpi_value pn_index_lease_periods.current_index_line_value%TYPE;
2088: v_current_cpi_id pn_index_lease_periods.current_index_line_id%TYPE;
2089: v_previous_cpi_value pn_index_lease_periods.previous_index_line_value%TYPE;
2090: v_previous_cpi_id pn_index_lease_periods.previous_index_line_id%TYPE;
2091: v_prev_assessment_date pn_index_lease_periods.assessment_date%TYPE;
2092: v_prev_period_id pn_index_lease_periods.index_period_id%TYPE;
2093: v_num_months_bet_asmnt_date NUMBER;
2094: v_num_days_bet_asmnt_date NUMBER;

Line 2091: v_prev_assessment_date pn_index_lease_periods.assessment_date%TYPE;

2087: v_current_cpi_value pn_index_lease_periods.current_index_line_value%TYPE;
2088: v_current_cpi_id pn_index_lease_periods.current_index_line_id%TYPE;
2089: v_previous_cpi_value pn_index_lease_periods.previous_index_line_value%TYPE;
2090: v_previous_cpi_id pn_index_lease_periods.previous_index_line_id%TYPE;
2091: v_prev_assessment_date pn_index_lease_periods.assessment_date%TYPE;
2092: v_prev_period_id pn_index_lease_periods.index_period_id%TYPE;
2093: v_num_months_bet_asmnt_date NUMBER;
2094: v_num_days_bet_asmnt_date NUMBER;
2095: v_msg VARCHAR2 (1000);

Line 2092: v_prev_period_id pn_index_lease_periods.index_period_id%TYPE;

2088: v_current_cpi_id pn_index_lease_periods.current_index_line_id%TYPE;
2089: v_previous_cpi_value pn_index_lease_periods.previous_index_line_value%TYPE;
2090: v_previous_cpi_id pn_index_lease_periods.previous_index_line_id%TYPE;
2091: v_prev_assessment_date pn_index_lease_periods.assessment_date%TYPE;
2092: v_prev_period_id pn_index_lease_periods.index_period_id%TYPE;
2093: v_num_months_bet_asmnt_date NUMBER;
2094: v_num_days_bet_asmnt_date NUMBER;
2095: v_msg VARCHAR2 (1000);
2096: v_all_msg VARCHAR2 (1000);

Line 2097: v_current_finder_date pn_index_lease_periods.index_finder_date%TYPE;

2093: v_num_months_bet_asmnt_date NUMBER;
2094: v_num_days_bet_asmnt_date NUMBER;
2095: v_msg VARCHAR2 (1000);
2096: v_all_msg VARCHAR2 (1000);
2097: v_current_finder_date pn_index_lease_periods.index_finder_date%TYPE;
2098: v_previous_finder_date pn_index_lease_periods.index_finder_date%TYPE;
2099: v_upper_index_date_code NUMBER;
2100: v_lower_index_date_code NUMBER;
2101:

Line 2098: v_previous_finder_date pn_index_lease_periods.index_finder_date%TYPE;

2094: v_num_days_bet_asmnt_date NUMBER;
2095: v_msg VARCHAR2 (1000);
2096: v_all_msg VARCHAR2 (1000);
2097: v_current_finder_date pn_index_lease_periods.index_finder_date%TYPE;
2098: v_previous_finder_date pn_index_lease_periods.index_finder_date%TYPE;
2099: v_upper_index_date_code NUMBER;
2100: v_lower_index_date_code NUMBER;
2101:
2102: CURSOR get_relationship IS

Line 2104: FROM pn_index_lease_periods_all

2100: v_lower_index_date_code NUMBER;
2101:
2102: CURSOR get_relationship IS
2103: SELECT relationship
2104: FROM pn_index_lease_periods_all
2105: WHERE assessment_date = p_assessment_date
2106: AND index_lease_id = p_index_lease_id;
2107:
2108: v_relationship_default VARCHAR2(30);

Line 2263: FROM pn_index_lease_periods_all pilp

2259: -- Get the latest assessment date before the current assessment date
2260: --
2261: SELECT MAX (pilp.assessment_date)
2262: INTO v_prev_assessment_date
2263: FROM pn_index_lease_periods_all pilp
2264: WHERE pilp.index_lease_id = p_index_lease_id
2265: AND pilp.assessment_date < p_assessment_date;
2266: ELSE
2267: v_prev_assessment_date := p_prev_assessment_date;

Line 2324: FROM pn_index_lease_periods_all

2320: SELECT current_index_line_id
2321: ,current_index_line_value
2322: INTO v_previous_cpi_id
2323: ,v_previous_cpi_value
2324: FROM pn_index_lease_periods_all
2325: WHERE index_period_id = v_prev_period_id;
2326: ELSE
2327: -- Fix for bug # 1873888
2328: -- If no previous CPI is found, then use base index

Line 2760: FROM pn_index_lease_periods_all

2756: WHERE index_lease_id = p_index_lease_id;
2757:
2758: CURSOR assessment_date_cur(p_index_lease_id NUMBER) IS
2759: SELECT assessment_date, index_period_id
2760: FROM pn_index_lease_periods_all
2761: WHERE index_lease_id = p_index_lease_id
2762: ORDER BY assessment_date;
2763:
2764: BEGIN

Line 3039: FROM pn_index_lease_periods_all plpx

3035: )
3036: )
3037: AND (( p_basis_type = c_basis_type_compound AND
3038: not exists( SELECT null
3039: FROM pn_index_lease_periods_all plpx
3040: WHERE plpx.index_period_id = ppt.index_period_id
3041: AND plpx.index_lease_id = p_index_lease_id))
3042: OR p_basis_type <> c_basis_type_compound)
3043: AND ppt.frequency_code <> c_spread_frequency_one_time

Line 3107: FROM pn_index_lease_periods_all plpx

3103: )
3104: )
3105: AND ( ( p_basis_type = c_basis_type_compound AND
3106: not exists( SELECT null
3107: FROM pn_index_lease_periods_all plpx
3108: WHERE plpx.index_period_id = ppt.index_period_id
3109: AND plpx.index_lease_id = p_index_lease_id))
3110: OR p_basis_type <> c_basis_type_compound)
3111: AND ppt.end_date >= ip_basis_start_date AND ppt.start_date <= ip_basis_end_date

Line 3243: v_basis_start_date pn_index_lease_periods.basis_start_date%type;

3239: v_total_backbill_rent_amt NUMBER := 0;
3240: v_backbill_amt NUMBER := 0;
3241: v_total_backbill_amt NUMBER := 0;
3242: v_previous_backbill_amt NUMBER := 0;
3243: v_basis_start_date pn_index_lease_periods.basis_start_date%type;
3244: v_basis_end_date pn_index_lease_periods.basis_end_date%type;
3245: v_msg VARCHAR2(100);
3246: prev_payment_purpose_code pn_payment_terms.payment_purpose_code%type := null;
3247: prev_payment_term_type_code pn_payment_terms.payment_term_type_code%type := null;

Line 3244: v_basis_end_date pn_index_lease_periods.basis_end_date%type;

3240: v_backbill_amt NUMBER := 0;
3241: v_total_backbill_amt NUMBER := 0;
3242: v_previous_backbill_amt NUMBER := 0;
3243: v_basis_start_date pn_index_lease_periods.basis_start_date%type;
3244: v_basis_end_date pn_index_lease_periods.basis_end_date%type;
3245: v_msg VARCHAR2(100);
3246: prev_payment_purpose_code pn_payment_terms.payment_purpose_code%type := null;
3247: prev_payment_term_type_code pn_payment_terms.payment_term_type_code%type := null;
3248: prev_location_id pn_payment_terms.location_id%type := null;

Line 4281: v_index_amount pn_index_lease_periods.constraint_rent_due%TYPE;

4277: ,op_msg OUT NOCOPY VARCHAR2
4278: ) IS
4279: v_msg VARCHAR2 (1000);
4280: v_normalize pn_term_templates.normalize%TYPE;
4281: v_index_amount pn_index_lease_periods.constraint_rent_due%TYPE;
4282: v_uncontrained_index_amount NUMBER;
4283: v_constrained_rent_amount NUMBER := 0;
4284: v_normalized_amount_annual NUMBER;
4285: v_adjusted_amount NUMBER;

Line 4308: v_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type;

4304: v_num_years NUMBER;
4305: v_constrained_backbill_amt NUMBER := 0;
4306: v_ot_amount NUMBER := 0;
4307: v_created_payment_term_id NUMBER;
4308: v_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type;
4309: v_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type;
4310: v_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type;
4311: v_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;
4312: v_end_date DATE;

Line 4309: v_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type;

4305: v_constrained_backbill_amt NUMBER := 0;
4306: v_ot_amount NUMBER := 0;
4307: v_created_payment_term_id NUMBER;
4308: v_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type;
4309: v_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type;
4310: v_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type;
4311: v_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;
4312: v_end_date DATE;
4313: v_reference_period_type VARCHAR2(30);

Line 4310: v_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type;

4306: v_ot_amount NUMBER := 0;
4307: v_created_payment_term_id NUMBER;
4308: v_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type;
4309: v_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type;
4310: v_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type;
4311: v_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;
4312: v_end_date DATE;
4313: v_reference_period_type VARCHAR2(30);
4314:

Line 4311: v_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;

4307: v_created_payment_term_id NUMBER;
4308: v_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type;
4309: v_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type;
4310: v_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type;
4311: v_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;
4312: v_end_date DATE;
4313: v_reference_period_type VARCHAR2(30);
4314:
4315: CURSOR ref_period_cur ( p_index_lease_id NUMBER) IS

Line 4437: FROM pn_index_lease_periods_all pilp

4433: NVL (v_prev_index_amt, 0);
4434: ELSE
4435: SELECT current_basis
4436: INTO v_normalize_basis_amount
4437: FROM pn_index_lease_periods_all pilp
4438: WHERE pilp.index_lease_id = p_index_lease_id
4439: AND line_number = 1;
4440: END IF;
4441:

Line 5169: FROM pn_index_lease_periods_all

5165: SELECT location_id
5166: FROM pn_index_leases_all
5167: WHERE index_lease_id =
5168: (SELECT index_lease_id
5169: FROM pn_index_lease_periods_all
5170: WHERE index_period_id = p_index_period_id);
5171:
5172: CURSOR org_id_cur IS
5173: SELECT org_id

Line 5183: FROM pn_index_lease_periods_all

5179: SELECT vr_nbp_flag
5180: FROM pn_index_leases_all
5181: WHERE index_lease_id =
5182: (SELECT index_lease_id
5183: FROM pn_index_lease_periods_all
5184: WHERE index_period_id = p_index_period_id);
5185:
5186: BEGIN
5187: put_log ('pn_index_amount_pkg.create_payment_term_record (+) :');

Line 5453: FROM pn_index_lease_periods_all pilp

5449:
5450: BEGIN
5451: SELECT trunc(pilp.assessment_date)
5452: INTO v_assessment_date
5453: FROM pn_index_lease_periods_all pilp
5454: WHERE pilp.index_period_id = p_index_period_id;
5455:
5456: EXCEPTION
5457: WHEN TOO_MANY_ROWS THEN

Line 5934: v_basis_amount pn_index_lease_periods.current_basis%TYPE;

5930: ,op_constraint_applied_percent OUT NOCOPY NUMBER
5931: ,op_carry_forward_percent OUT NOCOPY NUMBER
5932: ,op_msg OUT NOCOPY VARCHAR2
5933: ) IS
5934: v_basis_amount pn_index_lease_periods.current_basis%TYPE;
5935: v_index_percent_change pn_index_lease_periods.index_percent_change%TYPE;
5936: v_uncontrained_index_amount pn_index_lease_periods.unconstraint_rent_due%TYPE;
5937: v_msg VARCHAR2 (100);
5938: v_all_msg VARCHAR2 (4000);

Line 5935: v_index_percent_change pn_index_lease_periods.index_percent_change%TYPE;

5931: ,op_carry_forward_percent OUT NOCOPY NUMBER
5932: ,op_msg OUT NOCOPY VARCHAR2
5933: ) IS
5934: v_basis_amount pn_index_lease_periods.current_basis%TYPE;
5935: v_index_percent_change pn_index_lease_periods.index_percent_change%TYPE;
5936: v_uncontrained_index_amount pn_index_lease_periods.unconstraint_rent_due%TYPE;
5937: v_msg VARCHAR2 (100);
5938: v_all_msg VARCHAR2 (4000);
5939: v_period_msg VARCHAR2 (1000); -- messages for current period only

Line 5936: v_uncontrained_index_amount pn_index_lease_periods.unconstraint_rent_due%TYPE;

5932: ,op_msg OUT NOCOPY VARCHAR2
5933: ) IS
5934: v_basis_amount pn_index_lease_periods.current_basis%TYPE;
5935: v_index_percent_change pn_index_lease_periods.index_percent_change%TYPE;
5936: v_uncontrained_index_amount pn_index_lease_periods.unconstraint_rent_due%TYPE;
5937: v_msg VARCHAR2 (100);
5938: v_all_msg VARCHAR2 (4000);
5939: v_period_msg VARCHAR2 (1000); -- messages for current period only
5940: v_constrained_rent_amount pn_index_lease_periods.constraint_rent_due%TYPE;

Line 5940: v_constrained_rent_amount pn_index_lease_periods.constraint_rent_due%TYPE;

5936: v_uncontrained_index_amount pn_index_lease_periods.unconstraint_rent_due%TYPE;
5937: v_msg VARCHAR2 (100);
5938: v_all_msg VARCHAR2 (4000);
5939: v_period_msg VARCHAR2 (1000); -- messages for current period only
5940: v_constrained_rent_amount pn_index_lease_periods.constraint_rent_due%TYPE;
5941: v_current_cpi_value pn_index_lease_periods.current_index_line_value%TYPE;
5942: v_current_cpi_id pn_index_lease_periods.current_index_line_id%TYPE;
5943: v_previous_cpi_value pn_index_lease_periods.previous_index_line_value%TYPE;
5944: v_previous_cpi_id pn_index_lease_periods.previous_index_line_id%TYPE;

Line 5941: v_current_cpi_value pn_index_lease_periods.current_index_line_value%TYPE;

5937: v_msg VARCHAR2 (100);
5938: v_all_msg VARCHAR2 (4000);
5939: v_period_msg VARCHAR2 (1000); -- messages for current period only
5940: v_constrained_rent_amount pn_index_lease_periods.constraint_rent_due%TYPE;
5941: v_current_cpi_value pn_index_lease_periods.current_index_line_value%TYPE;
5942: v_current_cpi_id pn_index_lease_periods.current_index_line_id%TYPE;
5943: v_previous_cpi_value pn_index_lease_periods.previous_index_line_value%TYPE;
5944: v_previous_cpi_id pn_index_lease_periods.previous_index_line_id%TYPE;
5945: v_main_lease_commencement_date pn_lease_details.lease_commencement_date%type;

Line 5942: v_current_cpi_id pn_index_lease_periods.current_index_line_id%TYPE;

5938: v_all_msg VARCHAR2 (4000);
5939: v_period_msg VARCHAR2 (1000); -- messages for current period only
5940: v_constrained_rent_amount pn_index_lease_periods.constraint_rent_due%TYPE;
5941: v_current_cpi_value pn_index_lease_periods.current_index_line_value%TYPE;
5942: v_current_cpi_id pn_index_lease_periods.current_index_line_id%TYPE;
5943: v_previous_cpi_value pn_index_lease_periods.previous_index_line_value%TYPE;
5944: v_previous_cpi_id pn_index_lease_periods.previous_index_line_id%TYPE;
5945: v_main_lease_commencement_date pn_lease_details.lease_commencement_date%type;
5946: v_initial_basis_amt NUMBER := 0;

Line 5943: v_previous_cpi_value pn_index_lease_periods.previous_index_line_value%TYPE;

5939: v_period_msg VARCHAR2 (1000); -- messages for current period only
5940: v_constrained_rent_amount pn_index_lease_periods.constraint_rent_due%TYPE;
5941: v_current_cpi_value pn_index_lease_periods.current_index_line_value%TYPE;
5942: v_current_cpi_id pn_index_lease_periods.current_index_line_id%TYPE;
5943: v_previous_cpi_value pn_index_lease_periods.previous_index_line_value%TYPE;
5944: v_previous_cpi_id pn_index_lease_periods.previous_index_line_id%TYPE;
5945: v_main_lease_commencement_date pn_lease_details.lease_commencement_date%type;
5946: v_initial_basis_amt NUMBER := 0;
5947: v_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type;

Line 5944: v_previous_cpi_id pn_index_lease_periods.previous_index_line_id%TYPE;

5940: v_constrained_rent_amount pn_index_lease_periods.constraint_rent_due%TYPE;
5941: v_current_cpi_value pn_index_lease_periods.current_index_line_value%TYPE;
5942: v_current_cpi_id pn_index_lease_periods.current_index_line_id%TYPE;
5943: v_previous_cpi_value pn_index_lease_periods.previous_index_line_value%TYPE;
5944: v_previous_cpi_id pn_index_lease_periods.previous_index_line_id%TYPE;
5945: v_main_lease_commencement_date pn_lease_details.lease_commencement_date%type;
5946: v_initial_basis_amt NUMBER := 0;
5947: v_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type;
5948: v_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type;

Line 5947: v_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type;

5943: v_previous_cpi_value pn_index_lease_periods.previous_index_line_value%TYPE;
5944: v_previous_cpi_id pn_index_lease_periods.previous_index_line_id%TYPE;
5945: v_main_lease_commencement_date pn_lease_details.lease_commencement_date%type;
5946: v_initial_basis_amt NUMBER := 0;
5947: v_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type;
5948: v_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type;
5949: v_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type;
5950: v_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;
5951: l_err_flag VARCHAR2 (1);

Line 5948: v_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type;

5944: v_previous_cpi_id pn_index_lease_periods.previous_index_line_id%TYPE;
5945: v_main_lease_commencement_date pn_lease_details.lease_commencement_date%type;
5946: v_initial_basis_amt NUMBER := 0;
5947: v_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type;
5948: v_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type;
5949: v_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type;
5950: v_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;
5951: l_err_flag VARCHAR2 (1);
5952: l_pre_index_rent_id NUMBER;

Line 5949: v_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type;

5945: v_main_lease_commencement_date pn_lease_details.lease_commencement_date%type;
5946: v_initial_basis_amt NUMBER := 0;
5947: v_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type;
5948: v_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type;
5949: v_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type;
5950: v_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;
5951: l_err_flag VARCHAR2 (1);
5952: l_pre_index_rent_id NUMBER;
5953: l_calculate_date DATE;

Line 5950: v_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;

5946: v_initial_basis_amt NUMBER := 0;
5947: v_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type;
5948: v_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type;
5949: v_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type;
5950: v_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;
5951: l_err_flag VARCHAR2 (1);
5952: l_pre_index_rent_id NUMBER;
5953: l_calculate_date DATE;
5954: v_adj_index_percent_change NUMBER;

Line 6011: pn_index_lease_periods_all pilp,

6007: ,nvl (pil.proration_rule, 'NO_PRORATION') "PRORATION_RULE"
6008: ,pil.proration_period_start_date
6009: ,pil.assessment_interval
6010: FROM pn_index_leases_all pil,
6011: pn_index_lease_periods_all pilp,
6012: pn_leases_all pl
6013: WHERE pil.index_lease_id = pilp.index_lease_id
6014: AND pil.lease_id = pl.lease_id
6015: AND pilp.index_period_id = p_index_lease_period_id;

Line 6554: v_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type;

6550: v_previous_cpi_id NUMBER;
6551: v_index_lease_id NUMBER;
6552: v_index_period_id NUMBER;
6553: v_lease_id NUMBER;
6554: v_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type;
6555: v_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type;
6556: v_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type;
6557: v_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;
6558: v_initial_basis pn_index_leases.initial_basis%type;

Line 6555: v_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type;

6551: v_index_lease_id NUMBER;
6552: v_index_period_id NUMBER;
6553: v_lease_id NUMBER;
6554: v_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type;
6555: v_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type;
6556: v_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type;
6557: v_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;
6558: v_initial_basis pn_index_leases.initial_basis%type;
6559: v_retain_initial_basis_flag pn_index_leases.retain_initial_basis_flag%type;

Line 6556: v_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type;

6552: v_index_period_id NUMBER;
6553: v_lease_id NUMBER;
6554: v_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type;
6555: v_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type;
6556: v_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type;
6557: v_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;
6558: v_initial_basis pn_index_leases.initial_basis%type;
6559: v_retain_initial_basis_flag pn_index_leases.retain_initial_basis_flag%type;
6560: v_msg VARCHAR2(1000);

Line 6557: v_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;

6553: v_lease_id NUMBER;
6554: v_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type;
6555: v_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type;
6556: v_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type;
6557: v_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;
6558: v_initial_basis pn_index_leases.initial_basis%type;
6559: v_retain_initial_basis_flag pn_index_leases.retain_initial_basis_flag%type;
6560: v_msg VARCHAR2(1000);
6561:

Line 6571: FROM pn_index_leases_all pil, pn_index_lease_periods_all pilp

6567: ,pilp.index_period_id
6568: ,pil.lease_id
6569: ,pil.retain_initial_basis_flag
6570: ,pil.initial_basis
6571: FROM pn_index_leases_all pil, pn_index_lease_periods_all pilp
6572: WHERE pil.index_lease_id = pilp.index_lease_id
6573: AND pil.index_lease_id = p_index_lease_id
6574: ORDER BY pilp.line_number;
6575:

Line 6585: FROM pn_index_leases_all pil, pn_index_lease_periods_all pilp

6581: ,pilp.index_period_id
6582: ,pil.lease_id
6583: ,pil.retain_initial_basis_flag
6584: ,pil.initial_basis
6585: FROM pn_index_leases_all pil, pn_index_lease_periods_all pilp
6586: WHERE pil.index_lease_id = pilp.index_lease_id
6587: AND pil.index_lease_id = p_index_lease_id
6588: AND pilp.index_period_id = p_index_lease_period_id
6589: ORDER BY pilp.line_number;

Line 6663: UPDATE pn_index_lease_periods_all

6659: p_new_msg => v_period_msg
6660: ,p_all_msg => v_all_msg
6661: );
6662:
6663: UPDATE pn_index_lease_periods_all
6664: SET current_basis = v_basis_amount
6665: ,unconstraint_rent_due = v_uncontrained_index_amount
6666: ,constraint_rent_due = v_p_constrained_rent_amount
6667: ,index_percent_change = v_index_percent_change

Line 6758: FROM pn_leases_all pl, pn_index_leases pil, pn_index_lease_periods_all pilp

6754: ,pilp.assessment_date
6755: ,pil.index_lease_number
6756: ,pil.term_template_id
6757: ,pil.org_id
6758: FROM pn_leases_all pl, pn_index_leases pil, pn_index_lease_periods_all pilp
6759: WHERE pl.lease_id = pil.lease_id
6760: AND pil.index_lease_id = pilp.index_lease_id
6761: AND (pil.index_lease_number >= nvl(p_index_rent_number_lower,pil.index_lease_number))
6762: AND (pil.index_lease_number <= nvl(p_index_rent_number_upper,pil.index_lease_number))

Line 6861: FROM pn_index_lease_periods_all pilp

6857: p_index_history_line_id IN NUMBER
6858: ) IS
6859: SELECT pilp.index_lease_id
6860: ,pilp.index_period_id
6861: FROM pn_index_lease_periods_all pilp
6862: WHERE ( pilp.previous_index_line_id = p_index_history_line_id
6863: OR pilp.current_index_line_id = p_index_history_line_id
6864: );
6865:

Line 6937: FROM pn_index_lease_periods_all pilp

6933: ,pilp.current_index_line_id
6934: ,pilp.current_index_line_value
6935: ,pilp.previous_index_line_value
6936: ,pilp.constraint_rent_due
6937: FROM pn_index_lease_periods_all pilp
6938: WHERE ( pilp.previous_index_line_id = p_index_history_line_id
6939: OR pilp.current_index_line_id = p_index_history_line_id
6940: );
6941:

Line 7033: UPDATE pn_index_lease_periods_all

7029: --
7030:
7031: IF ilp_rec.constraint_rent_due IS NULL
7032: OR NVL (ip_recalculate, 'N') = 'Y' THEN
7033: UPDATE pn_index_lease_periods_all
7034: SET index_percent_change = v_index_percent_change
7035: ,current_index_line_value = v_current_cpi_value
7036: ,previous_index_line_value = v_previous_cpi_value
7037: WHERE index_period_id = ilp_rec.index_period_id;

Line 7264: ,pn_index_lease_periods_all pilp

7260: ,DECODE (ppt.normalize, 'Y', 'NORMALIZE') "NORMALIZE"
7261: ,ppt.schedule_day
7262: FROM pn_leases_all pl
7263: ,pn_index_leases pil
7264: ,pn_index_lease_periods_all pilp
7265: ,pn_payment_terms_all ppt
7266: WHERE pl.lease_id = pil.lease_id
7267: AND pil.index_lease_id = pilp.index_lease_id
7268: AND pilp.index_period_id = ppt.index_period_id

Line 7555: FROM pn_index_lease_periods_all pilp

7551: op_carry_forward_percent OUT NOCOPY NUMBER) IS
7552: CURSOR csr_cum_carry_for IS
7553: SELECT pilp.carry_forward_amount,
7554: pilp.carry_forward_percent
7555: FROM pn_index_lease_periods_all pilp
7556: WHERE pilp.index_lease_id = p_index_lease_id
7557: AND pilp.assessment_date = (SELECT MAX (pilp.assessment_date)
7558: FROM pn_index_lease_periods_all pilp
7559: WHERE pilp.index_lease_id = p_index_lease_id

Line 7558: FROM pn_index_lease_periods_all pilp

7554: pilp.carry_forward_percent
7555: FROM pn_index_lease_periods_all pilp
7556: WHERE pilp.index_lease_id = p_index_lease_id
7557: AND pilp.assessment_date = (SELECT MAX (pilp.assessment_date)
7558: FROM pn_index_lease_periods_all pilp
7559: WHERE pilp.index_lease_id = p_index_lease_id
7560: AND pilp.assessment_date < p_assessment_date);
7561:
7562: BEGIN

Line 7598: FROM pn_index_lease_periods_all

7594: RETURN number
7595: IS
7596: CURSOR csr_negative_rent IS
7597: SELECT unconstraint_rent_due, constraint_rent_due
7598: FROM pn_index_lease_periods_all
7599: WHERE index_lease_id = p_index_lease_id
7600: AND assessment_date < p_assessment_date
7601: ORDER BY assessment_date desc;
7602:

Line 7679: FROM pn_index_lease_periods_all

7675: IS
7676: CURSOR csr_get_dt
7677: IS
7678: SELECT max(assessment_date)
7679: FROM pn_index_lease_periods_all
7680: WHERE index_lease_id = p_index_lease_id
7681: AND assessment_date > p_assessment_date
7682: AND constraint_rent_due is not null;
7683:

Line 7716: FROM pn_index_lease_periods_all

7712: CURSOR csr_get_periods is
7713: SELECT index_lease_id,
7714: index_period_id,
7715: assessment_date
7716: FROM pn_index_lease_periods_all
7717: WHERE index_lease_id = p_index_lease_id
7718: AND assessment_date > p_assessment_date
7719: AND assessment_date <= get_max_assessment_dt(index_lease_id,p_assessment_date);
7720: