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 547: FROM pn_index_lease_periods_all pilp

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

Line 653: FROM pn_index_lease_periods_all pilp

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

Line 656: FROM pn_index_lease_periods_all pilp

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

Line 686: v_index_period_id pn_index_lease_periods.index_period_id%TYPE;

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

Line 706: FROM pn_index_lease_periods_all pilp

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

Line 736: FROM pn_index_lease_periods_all pilp

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

Line 739: FROM pn_index_lease_periods_all pilp

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

Line 767: v_annual_basis_amount pn_index_lease_periods.current_basis%TYPE;

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

Line 830: FROM pn_payment_terms_all ppt, pn_index_lease_periods_all ppi

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

Line 834: FROM pn_index_lease_periods_all

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

Line 871: FROM pn_index_lease_periods_all pilp

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

Line 940: FROM pn_index_lease_periods_all ppilx

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

Line 980: FROM pn_index_lease_periods_all ppilx

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

Line 1313: v_prev_index_amt pn_index_lease_periods.constraint_rent_due%TYPE;

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

Line 1315: v_basis_amount pn_index_lease_periods.current_basis%TYPE;

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

Line 1316: v_previous_basis_amount pn_index_lease_periods.current_basis%TYPE;

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

Line 1317: v_previous_index_id pn_index_lease_periods.index_period_id%TYPE;

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

Line 1504: FROM pn_index_leases_all pil, pn_index_lease_periods_all pilp

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

Line 1510: v_basis_amt_oper_expenses pn_index_lease_periods.current_basis%TYPE;

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

Line 1511: v_basis_amt_base_rent pn_index_lease_periods.current_basis%TYPE;

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

Line 1513: v_basis_amount pn_index_lease_periods.current_basis%TYPE;

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

Line 1515: v_annual_basis_amt pn_index_lease_periods.current_basis%TYPE;

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

Line 1592: v_annual_basis_amt pn_index_lease_periods.current_basis%TYPE;

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

Line 1595: v_index_rent_amount pn_index_lease_periods.unconstraint_rent_due%TYPE;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2086: v_current_cpi_value pn_index_lease_periods.current_index_line_value%TYPE;

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

Line 2087: v_current_cpi_id pn_index_lease_periods.current_index_line_id%TYPE;

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

Line 2088: v_previous_cpi_value pn_index_lease_periods.previous_index_line_value%TYPE;

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

Line 2089: v_previous_cpi_id pn_index_lease_periods.previous_index_line_id%TYPE;

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

Line 2090: v_prev_assessment_date pn_index_lease_periods.assessment_date%TYPE;

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

Line 2091: v_prev_period_id pn_index_lease_periods.index_period_id%TYPE;

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

Line 2096: v_current_finder_date pn_index_lease_periods.index_finder_date%TYPE;

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

Line 2097: v_previous_finder_date pn_index_lease_periods.index_finder_date%TYPE;

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

Line 2103: FROM pn_index_lease_periods_all

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

Line 2262: FROM pn_index_lease_periods_all pilp

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

Line 2323: FROM pn_index_lease_periods_all

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

Line 2759: FROM pn_index_lease_periods_all

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

Line 3038: FROM pn_index_lease_periods_all plpx

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

Line 3106: FROM pn_index_lease_periods_all plpx

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

Line 3242: v_basis_start_date pn_index_lease_periods.basis_start_date%type;

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

Line 3243: v_basis_end_date pn_index_lease_periods.basis_end_date%type;

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

Line 4279: v_index_amount pn_index_lease_periods.constraint_rent_due%TYPE;

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

Line 4306: v_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type;

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

Line 4307: v_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type;

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

Line 4308: v_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type;

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

Line 4309: v_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;

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

Line 4435: FROM pn_index_lease_periods_all pilp

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

Line 5167: FROM pn_index_lease_periods_all

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

Line 5181: FROM pn_index_lease_periods_all

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

Line 5451: FROM pn_index_lease_periods_all pilp

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

Line 5932: v_basis_amount pn_index_lease_periods.current_basis%TYPE;

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

Line 5933: v_index_percent_change pn_index_lease_periods.index_percent_change%TYPE;

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

Line 5934: v_uncontrained_index_amount pn_index_lease_periods.unconstraint_rent_due%TYPE;

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

Line 5938: v_constrained_rent_amount pn_index_lease_periods.constraint_rent_due%TYPE;

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

Line 5939: v_current_cpi_value pn_index_lease_periods.current_index_line_value%TYPE;

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

Line 5940: v_current_cpi_id pn_index_lease_periods.current_index_line_id%TYPE;

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

Line 5941: v_previous_cpi_value pn_index_lease_periods.previous_index_line_value%TYPE;

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

Line 5942: v_previous_cpi_id pn_index_lease_periods.previous_index_line_id%TYPE;

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

Line 5945: v_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type;

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

Line 5946: v_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type;

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

Line 5947: v_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type;

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

Line 5948: v_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;

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

Line 6009: pn_index_lease_periods_all pilp,

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

Line 6552: v_constraint_applied_amount pn_index_lease_periods.constraint_applied_amount%type;

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

Line 6553: v_carry_forward_amount pn_index_lease_periods.carry_forward_amount%type;

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

Line 6554: v_constraint_applied_percent pn_index_lease_periods.constraint_applied_percent%type;

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

Line 6555: v_carry_forward_percent pn_index_lease_periods.carry_forward_percent%type;

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

Line 6569: FROM pn_index_leases_all pil, pn_index_lease_periods_all pilp

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

Line 6583: FROM pn_index_leases_all pil, pn_index_lease_periods_all pilp

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

Line 6661: UPDATE pn_index_lease_periods_all

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

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

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

Line 6859: FROM pn_index_lease_periods_all pilp

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

Line 6935: FROM pn_index_lease_periods_all pilp

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

Line 7031: UPDATE pn_index_lease_periods_all

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

Line 7262: ,pn_index_lease_periods_all pilp

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

Line 7553: FROM pn_index_lease_periods_all pilp

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

Line 7556: FROM pn_index_lease_periods_all pilp

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

Line 7596: FROM pn_index_lease_periods_all

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

Line 7677: FROM pn_index_lease_periods_all

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

Line 7714: FROM pn_index_lease_periods_all

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