[Home] [Help]
2192: SELECT TO_NUMBER (TO_CHAR (p_index_finder_date, 'YYYYMM'))
2193: ,TO_NUMBER (TO_CHAR (ADD_MONTHS (p_index_finder_date, -12), 'YYYYMM'))
2194: INTO v_upper_index_date_code
2195: ,v_lower_index_date_code
2196: FROM DUAL;
2197: --
2198: -- second, derive the finder date to be used.
2199: --
2200: SELECT MAX (phl.index_date)
2438: ,c_spread_frequency_annually, 1
2439: ,1
2440: )
2441: INTO v_multiplier
2442: FROM DUAL;
2443: op_normalize_amount_annual := (v_normalized_amount * v_multiplier)
2444: + op_normalize_amount_annual;
2445: END LOOP;
2446:
2487: ,c_spread_frequency_annually, 1
2488: ,1
2489: )
2490: INTO v_multiplier
2491: FROM DUAL;
2492: v_all_approved_amounts := (cursor_rec.actual_amount * v_multiplier)
2493: + v_all_approved_amounts;
2494: END LOOP;
2495:
2608: ,c_spread_frequency_annually, 1
2609: ,1
2610: )
2611: INTO v_multiplier
2612: FROM DUAL;
2613: v_all_approved_amounts := (cursor_rec.actual_amount * v_multiplier)
2614: + v_all_approved_amounts;
2615: END LOOP;
2616:
2677: ,c_spread_frequency_annually, 12
2678: ,1
2679: )
2680: INTO v_num_months_bet_payments
2681: FROM DUAL;
2682: v_recurring_payment_start_date := p_assessment_date;
2683:
2684: FOR rec IN get_index_finder LOOP
2685: l_index_finder_method := rec.index_finder_method;
2819:
2820:
2821: ------------------------------------------------------------------------
2822: -- PROCEDURE : insert_inter_term
2823: -- DESCRIPTION: This procedure will store information of individual terms contribution
2824: -- toward a particular rent increase.
2825: --
2826: ------------------------------------------------------------------------
2827:
2847:
2848: begin
2849:
2850: /* From the Pl/SQL table which contains the payment term id and the annualized amounts of the
2851: payment terms contained in an aggregation combination, find out NOCOPY their individual contribution
2852: towards the rent of the aggregation combination. */
2853:
2854: FOR i in 1..item_amt_tab.count
2855: loop
3338: := pn_mo_cache_utils.get_profile_value('PN_CALC_ANNUALIZED_BASIS', l_org_id);
3339:
3340: SELECT NVL (p_increase_on, c_increase_on_gross)
3341: INTO v_type_code
3342: FROM DUAL;
3343:
3344: v_basis_start_date := p_basis_start_date;
3345: v_basis_end_date := p_basis_end_date;
3346:
3436: ,c_spread_frequency_semiannual, 2
3437: ,c_spread_frequency_annually, 1
3438: ,1 )
3439: INTO v_payments_per_year
3440: FROM DUAL;
3441:
3442: IF p_index_finder_type in ( c_index_finder_backbill, c_index_finder_most_recent) AND
3443: NVL (v_num_pymt_since_assmt_dt, 0) <> 0 THEN
3444:
3447: c_index_pay_term_type_atlst_bb,
3448: c_index_pay_term_type_recur,
3449: c_index_pay_term_type_backbill)
3450: INTO p_backbill_term_indicator
3451: FROM DUAL;
3452:
3453: END IF;
3454:
3455:
4564: ,c_spread_frequency_annually, 1
4565: ,1
4566: )
4567: INTO v_payments_per_year
4568: FROM DUAL;
4569:
4570: chk_approved_amount (
4571: p_index_period_id => p_index_period_id
4572: ,p_index_term_indicator => c_index_pay_term_type_atlst_bb
4743: ,c_spread_frequency_annually, 1
4744: ,1
4745: )
4746: INTO v_payments_per_year
4747: FROM DUAL;
4748:
4749:
4750: /* deriving the start date of the recurring payment */
4751:
4851: ,c_spread_frequency_annually, 1
4852: ,1
4853: )
4854: INTO v_payments_per_year
4855: FROM DUAL;
4856:
4857: chk_approved_amount (
4858: p_index_period_id => p_index_period_id
4859: ,p_index_term_indicator => c_index_pay_term_type_backbill
6595:
6596:
6597: /* for performance reasons, one of two cursors can be executed..
6598: cursor c1 is need when all periods of an index rent is processed (IP_INDEX_PERIOD_ID IS NULL)
6599: cursor c2 is need when all an individual period is processed */
6600:
6601:
6602: IF ip_index_lease_period_id IS NULL THEN
6603: OPEN c1 (ip_index_lease_id);
7307:
7308: CURSOR bkhd_exists_cur
7309: IS
7310: select 'x'
7311: FROM DUAL
7312: where exists (select BKHD_DEFAULT_ID
7313: from pn_var_bkpts_head_all
7314: where period_id IN (select PERIOD_ID
7315: FROM pn_var_periods_all