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