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.

[Home] [Help]

APPS.LNS_FINANCIALS dependencies on LNS_FIN_UTILS

Line 238: if p_installment_number <> lns_fin_utils.getNumberInstallments(p_loan_id => p_loan_id

234: --
235: -- Api body
236: -- ----------------------------------------------------------------
237:
238: if p_installment_number <> lns_fin_utils.getNumberInstallments(p_loan_id => p_loan_id
239: ,p_phase => p_phase) then
240: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - getting next rate change info');
241: l_next_rate_change := lns_fin_utils.getNextDate(p_date => p_period_begin_date
242: ,p_interval_type => p_interest_adjustment_freq

Line 241: l_next_rate_change := lns_fin_utils.getNextDate(p_date => p_period_begin_date

237:
238: if p_installment_number <> lns_fin_utils.getNumberInstallments(p_loan_id => p_loan_id
239: ,p_phase => p_phase) then
240: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - getting next rate change info');
241: l_next_rate_change := lns_fin_utils.getNextDate(p_date => p_period_begin_date
242: ,p_interval_type => p_interest_adjustment_freq
243: ,p_direction => 1);
244: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - updating terms with new date ' || l_next_rate_change);
245: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - updating terms with new rate' || p_annualized_interest_rate);

Line 337: else --else for if p_installment_number <> lns_fin_utils.getNumberInstallments(p_loan_id => p_loan_id

333: p_rate_id := l_new_rate_id ;
334:
335: end if; --end else part for if (l_begin_inst_num = l_end_inst_num = p_installment_number) then
336:
337: else --else for if p_installment_number <> lns_fin_utils.getNumberInstallments(p_loan_id => p_loan_id
338:
339: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - updating the rate schedule LAST ROW ' || p_rate_id);
340: -- update existing rate_schedule row
341: update lns_rate_schedules

Line 346: end if; --end if p_installment_number <> lns_fin_utils.getNumberInstallments(p_loan_id => p_loan_id

342: set current_interest_rate = p_annualized_interest_rate
343: ,index_rate = p_annualized_interest_rate - nvl(spread,0)
344: where rate_id = p_rate_id;
345:
346: end if; --end if p_installment_number <> lns_fin_utils.getNumberInstallments(p_loan_id => p_loan_id
347:
348:
349: --
350: -- End of API body

Line 2025: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;

2021: ,x_msg_data OUT NOCOPY VARCHAR2)
2022: is
2023: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
2024: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
2025: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
2026: l_rate_schedule_tbl LNS_FINANCIALS.RATE_SCHEDULE_TBL;
2027: l_rates_tbl LNS_FINANCIALS.RATE_SCHEDULE_TBL;
2028: l_rate_details LNS_FINANCIALS.INTEREST_RATE_REC;
2029: l_amortization_tbl LNS_FINANCIALS.AMORTIZATION_TBL;

Line 2245: l_rate_date := lns_fin_utils.getNextDate(l_rate_date, p_rate_change_frequency, 1);

2241: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_maturity_date ' || p_maturity_date );
2242: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_index_rate_id ' || p_index_rate_id );
2243:
2244: WHILE l_rate_date <= p_maturity_date LOOP
2245: l_rate_date := lns_fin_utils.getNextDate(l_rate_date, p_rate_change_frequency, 1);
2246: i := i + 1;
2247: l_Rates_tbl(i).begin_date := l_rate_date;
2248: --logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_rate_date ' || l_rate_date);
2249: END LOOP;

Line 2262: function get_remain_num_prin_instal(p_payment_tbl in LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL

2258: end getRatesTable;
2259:
2260:
2261: -- created for bug 6498771
2262: function get_remain_num_prin_instal(p_payment_tbl in LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL
2263: ,p_from_installment in NUMBER) return NUMBER
2264: is
2265: l_num_prin_payments number;
2266: l_total_installments number;

Line 2359: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;

2355:
2356: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
2357: l_amortization_tbl LNS_FINANCIALS.AMORTIZATION_TBL;
2358: l_rate_tbl LNS_FINANCIALS.RATE_SCHEDULE_TBL;
2359: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
2360: l_principal_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
2361: l_loan_start_date date;
2362: l_num_pay_dates number; -- number of dates on installment schedule
2363: l_periodic_payment number;

Line 2360: l_principal_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;

2356: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
2357: l_amortization_tbl LNS_FINANCIALS.AMORTIZATION_TBL;
2358: l_rate_tbl LNS_FINANCIALS.RATE_SCHEDULE_TBL;
2359: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
2360: l_principal_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
2361: l_loan_start_date date;
2362: l_num_pay_dates number; -- number of dates on installment schedule
2363: l_periodic_payment number;
2364: l_periodic_principal number;

Line 2468: l_int_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;

2464: l_early_pay_cr_detail_str varchar2(2000);
2465:
2466: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
2467: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
2468: l_int_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2469: l_prin_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2470: l_PRIN_FREQUENCY_REC LNS_FIN_UTILS.FREQUENCY_SCHEDULE;
2471: l_INT_FREQUENCY_REC LNS_FIN_UTILS.FREQUENCY_SCHEDULE;
2472: l_current_prin_pay_freq varchar2(30);

Line 2469: l_prin_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;

2465:
2466: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
2467: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
2468: l_int_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2469: l_prin_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2470: l_PRIN_FREQUENCY_REC LNS_FIN_UTILS.FREQUENCY_SCHEDULE;
2471: l_INT_FREQUENCY_REC LNS_FIN_UTILS.FREQUENCY_SCHEDULE;
2472: l_current_prin_pay_freq varchar2(30);
2473: l_prev_prin_pay_freq varchar2(30);

Line 2470: l_PRIN_FREQUENCY_REC LNS_FIN_UTILS.FREQUENCY_SCHEDULE;

2466: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
2467: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
2468: l_int_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2469: l_prin_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2470: l_PRIN_FREQUENCY_REC LNS_FIN_UTILS.FREQUENCY_SCHEDULE;
2471: l_INT_FREQUENCY_REC LNS_FIN_UTILS.FREQUENCY_SCHEDULE;
2472: l_current_prin_pay_freq varchar2(30);
2473: l_prev_prin_pay_freq varchar2(30);
2474:

Line 2471: l_INT_FREQUENCY_REC LNS_FIN_UTILS.FREQUENCY_SCHEDULE;

2467: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
2468: l_int_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2469: l_prin_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
2470: l_PRIN_FREQUENCY_REC LNS_FIN_UTILS.FREQUENCY_SCHEDULE;
2471: l_INT_FREQUENCY_REC LNS_FIN_UTILS.FREQUENCY_SCHEDULE;
2472: l_current_prin_pay_freq varchar2(30);
2473: l_prev_prin_pay_freq varchar2(30);
2474:
2475: -- get last bill date

Line 2591: l_int_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(

2587:
2588: -- get payment schedule
2589: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || '- getting payment schedule');
2590:
2591: l_int_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(
2592: P_LOAN_ID => l_loan_id,
2593: P_PHASE => 'TERM',
2594: P_COMPONENT => 'INT');
2595:

Line 2596: l_prin_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(

2592: P_LOAN_ID => l_loan_id,
2593: P_PHASE => 'TERM',
2594: P_COMPONENT => 'INT');
2595:
2596: l_prin_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(
2597: P_LOAN_ID => l_loan_id,
2598: P_PHASE => 'TERM',
2599: P_COMPONENT => 'PRIN');
2600:

Line 2601: l_payment_tbl := LNS_FIN_UTILS.buildSIPPaymentSchedule(

2597: P_LOAN_ID => l_loan_id,
2598: P_PHASE => 'TERM',
2599: P_COMPONENT => 'PRIN');
2600:
2601: l_payment_tbl := LNS_FIN_UTILS.buildSIPPaymentSchedule(
2602: p_loan_start_date => l_loan_start_date,
2603: p_loan_maturity_date => l_maturity_date,
2604: p_prin_freq_schedule_tbl => l_prin_freq_schedule_tbl,
2605: p_int_freq_schedule_tbl => l_int_freq_schedule_tbl);

Line 2607: l_payment_tbl := LNS_FIN_UTILS.buildSIPPaymentSchedule(

2603: p_loan_maturity_date => l_maturity_date,
2604: p_prin_freq_schedule_tbl => l_prin_freq_schedule_tbl,
2605: p_int_freq_schedule_tbl => l_int_freq_schedule_tbl);
2606: /*
2607: l_payment_tbl := LNS_FIN_UTILS.buildSIPPaymentSchedule(
2608: p_loan_start_date => l_loan_start_date
2609: ,p_loan_maturity_date => l_maturity_date
2610: ,p_int_first_pay_date => l_first_payment_date
2611: ,p_int_num_intervals => null --l_intervals

Line 2626: l_principal_tbl := LNS_FIN_UTILS.buildPaymentSchedule(p_loan_start_date => l_loan_start_date

2622:
2623: -- get amortize principal schedule
2624: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || '- getting principal schedule');
2625:
2626: l_principal_tbl := LNS_FIN_UTILS.buildPaymentSchedule(p_loan_start_date => l_loan_start_date
2627: ,p_loan_maturity_date => l_maturity_date
2628: ,p_freq_schedule_tbl => l_prin_freq_schedule_tbl);
2629:
2630: /*

Line 2631: l_principal_tbl := LNS_FIN_UTILS.buildPaymentSchedule(p_loan_start_date => l_loan_start_date

2627: ,p_loan_maturity_date => l_maturity_date
2628: ,p_freq_schedule_tbl => l_prin_freq_schedule_tbl);
2629:
2630: /*
2631: l_principal_tbl := LNS_FIN_UTILS.buildPaymentSchedule(p_loan_start_date => l_loan_start_date
2632: ,p_loan_maturity_date => l_maturity_date
2633: ,p_first_pay_date => l_prin_first_pay_date
2634: ,p_num_intervals => null --l_intervals
2635: ,p_interval_type => l_prin_payment_frequency

Line 2643: l_amortized_maturity_date := LNS_FIN_UTILS.getMaturityDate(p_term => l_amortized_term

2639: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || '- principal schedule count = ' || l_prin_intervals);
2640:
2641: if l_loan_term <> l_amortized_term then
2642: -- get amortize maturity date
2643: l_amortized_maturity_date := LNS_FIN_UTILS.getMaturityDate(p_term => l_amortized_term
2644: ,p_term_period => l_amortized_term_period
2645: ,p_frequency => l_prin_payment_frequency
2646: ,p_start_date => l_loan_start_date);
2647: -- get amortize principal schedule

Line 2649: l_principal_tbl := LNS_FIN_UTILS.buildPaymentSchedule(p_loan_start_date => l_loan_start_date

2645: ,p_frequency => l_prin_payment_frequency
2646: ,p_start_date => l_loan_start_date);
2647: -- get amortize principal schedule
2648: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || '- getting amortize principal schedule');
2649: l_principal_tbl := LNS_FIN_UTILS.buildPaymentSchedule(p_loan_start_date => l_loan_start_date
2650: ,p_loan_maturity_date => l_amortized_maturity_date
2651: ,p_freq_schedule_tbl => l_prin_freq_schedule_tbl);
2652: /*
2653: l_principal_tbl := LNS_FIN_UTILS.buildPaymentSchedule(p_loan_start_date => l_loan_start_date

Line 2653: l_principal_tbl := LNS_FIN_UTILS.buildPaymentSchedule(p_loan_start_date => l_loan_start_date

2649: l_principal_tbl := LNS_FIN_UTILS.buildPaymentSchedule(p_loan_start_date => l_loan_start_date
2650: ,p_loan_maturity_date => l_amortized_maturity_date
2651: ,p_freq_schedule_tbl => l_prin_freq_schedule_tbl);
2652: /*
2653: l_principal_tbl := LNS_FIN_UTILS.buildPaymentSchedule(p_loan_start_date => l_loan_start_date
2654: ,p_loan_maturity_date => l_amortized_maturity_date
2655: ,p_first_pay_date => l_prin_first_pay_date
2656: ,p_num_intervals => null --l_intervals
2657: ,p_interval_type => l_prin_payment_frequency

Line 2852: LNS_FIN_UTILS.fetchPayFreqRecByDate(

2848:
2849: if l_begin = 1 then
2850: l_prev_prin_pay_freq := '';
2851: else
2852: LNS_FIN_UTILS.fetchPayFreqRecByDate(
2853: p_FREQUENCY_SCHEDULE => l_prin_freq_schedule_tbl,
2854: p_DATE => l_payment_tbl(l_begin-1).PERIOD_DUE_DATE,
2855: x_FREQUENCY_REC => l_PRIN_FREQUENCY_REC);
2856: l_prev_prin_pay_freq := l_PRIN_FREQUENCY_REC.FREQUENCY;

Line 3054: LNS_FIN_UTILS.fetchPayFreqRecByDate(

3050: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': l_increased_amount1 = ' || l_increased_amount1);
3051: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': l_increase_amount_instal = ' || l_increase_amount_instal);
3052:
3053: -- getting current frequency record
3054: LNS_FIN_UTILS.fetchPayFreqRecByDate(
3055: p_FREQUENCY_SCHEDULE => l_prin_freq_schedule_tbl,
3056: p_DATE => l_payment_tbl(l_installment_number).PERIOD_DUE_DATE,
3057: x_FREQUENCY_REC => l_PRIN_FREQUENCY_REC);
3058: l_current_prin_pay_freq := l_PRIN_FREQUENCY_REC.FREQUENCY;

Line 3060: LNS_FIN_UTILS.fetchPayFreqRecByDate(

3056: p_DATE => l_payment_tbl(l_installment_number).PERIOD_DUE_DATE,
3057: x_FREQUENCY_REC => l_PRIN_FREQUENCY_REC);
3058: l_current_prin_pay_freq := l_PRIN_FREQUENCY_REC.FREQUENCY;
3059:
3060: LNS_FIN_UTILS.fetchPayFreqRecByDate(
3061: p_FREQUENCY_SCHEDULE => l_int_freq_schedule_tbl,
3062: p_DATE => l_payment_tbl(l_installment_number).PERIOD_DUE_DATE,
3063: x_FREQUENCY_REC => l_INT_FREQUENCY_REC);
3064: l_payment_frequency := l_INT_FREQUENCY_REC.FREQUENCY;

Line 3780: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;

3776:
3777: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
3778: l_amortization_tbl LNS_FINANCIALS.AMORTIZATION_TBL;
3779: l_rate_tbl LNS_FINANCIALS.RATE_SCHEDULE_TBL;
3780: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
3781: l_amortized_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
3782: l_loan_start_date date;
3783: l_num_pay_dates number; -- number of dates on installment schedule
3784: l_periodic_payment number;

Line 3781: l_amortized_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;

3777: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
3778: l_amortization_tbl LNS_FINANCIALS.AMORTIZATION_TBL;
3779: l_rate_tbl LNS_FINANCIALS.RATE_SCHEDULE_TBL;
3780: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
3781: l_amortized_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
3782: l_loan_start_date date;
3783: l_num_pay_dates number; -- number of dates on installment schedule
3784: l_periodic_payment number;
3785: l_periodic_principal number;

Line 3872: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;

3868: l_early_pay_cr_detail_str varchar2(2000);
3869:
3870: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
3871: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
3872: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
3873: l_FREQUENCY_REC LNS_FIN_UTILS.FREQUENCY_SCHEDULE;
3874: l_prev_payment_frequency varchar2(30);
3875:
3876: -- get last bill date

Line 3873: l_FREQUENCY_REC LNS_FIN_UTILS.FREQUENCY_SCHEDULE;

3869:
3870: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
3871: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
3872: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
3873: l_FREQUENCY_REC LNS_FIN_UTILS.FREQUENCY_SCHEDULE;
3874: l_prev_payment_frequency varchar2(30);
3875:
3876: -- get last bill date
3877: cursor c_get_last_bill_date(p_loan_id number, p_installment_number number) is

Line 3978: l_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(

3974:
3975: -- get payment schedule
3976: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || '- getting payment schedule');
3977:
3978: l_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(
3979: P_LOAN_ID => l_loan_id,
3980: P_PHASE => 'TERM',
3981: P_COMPONENT => 'PRIN_INT');
3982:

Line 3983: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(

3979: P_LOAN_ID => l_loan_id,
3980: P_PHASE => 'TERM',
3981: P_COMPONENT => 'PRIN_INT');
3982:
3983: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(
3984: p_loan_start_date => l_loan_start_date,
3985: p_loan_maturity_date => l_maturity_date,
3986: p_freq_schedule_tbl => l_freq_schedule_tbl);
3987: /*

Line 3988: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(p_loan_start_date => l_loan_start_date

3984: p_loan_start_date => l_loan_start_date,
3985: p_loan_maturity_date => l_maturity_date,
3986: p_freq_schedule_tbl => l_freq_schedule_tbl);
3987: /*
3988: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(p_loan_start_date => l_loan_start_date
3989: ,p_loan_maturity_date => l_maturity_date
3990: ,p_first_pay_date => l_first_payment_date
3991: ,p_num_intervals => null --l_intervals
3992: ,p_interval_type => l_payment_frequency

Line 4001: l_amortized_maturity_date := LNS_FIN_UTILS.getMaturityDate(p_term => l_amortized_term

3997:
3998: if l_loan_term <> l_amortized_term then
3999:
4000: -- get amortize maturity date
4001: l_amortized_maturity_date := LNS_FIN_UTILS.getMaturityDate(p_term => l_amortized_term
4002: ,p_term_period => l_amortized_term_period
4003: ,p_frequency => l_payment_frequency
4004: ,p_start_date => l_loan_start_date);
4005: -- get amortize payment schedule

Line 4008: l_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(

4004: ,p_start_date => l_loan_start_date);
4005: -- get amortize payment schedule
4006: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || '- getting amortize payment schedule');
4007:
4008: l_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(
4009: P_LOAN_ID => l_loan_id,
4010: P_PHASE => 'TERM',
4011: P_COMPONENT => 'PRIN_INT');
4012:

Line 4013: l_amortized_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(

4009: P_LOAN_ID => l_loan_id,
4010: P_PHASE => 'TERM',
4011: P_COMPONENT => 'PRIN_INT');
4012:
4013: l_amortized_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(
4014: p_loan_start_date => l_loan_start_date,
4015: p_loan_maturity_date => l_amortized_maturity_date,
4016: p_freq_schedule_tbl => l_freq_schedule_tbl);
4017: /*

Line 4018: l_amortized_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(p_loan_start_date => l_loan_start_date

4014: p_loan_start_date => l_loan_start_date,
4015: p_loan_maturity_date => l_amortized_maturity_date,
4016: p_freq_schedule_tbl => l_freq_schedule_tbl);
4017: /*
4018: l_amortized_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(p_loan_start_date => l_loan_start_date
4019: ,p_loan_maturity_date => l_amortized_maturity_date
4020: ,p_first_pay_date => l_first_payment_date
4021: ,p_num_intervals => null --l_intervals
4022: ,p_interval_type => l_payment_frequency

Line 4210: LNS_FIN_UTILS.fetchPayFreqRecByDate(

4206:
4207: if l_begin = 1 then
4208: l_prev_payment_frequency := '';
4209: else
4210: LNS_FIN_UTILS.fetchPayFreqRecByDate(
4211: p_FREQUENCY_SCHEDULE => l_freq_schedule_tbl,
4212: p_DATE => l_payment_tbl(l_begin-1).PERIOD_DUE_DATE,
4213: x_FREQUENCY_REC => l_FREQUENCY_REC);
4214: l_prev_payment_frequency := l_FREQUENCY_REC.FREQUENCY;

Line 4380: LNS_FIN_UTILS.fetchPayFreqRecByDate(

4376: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': l_increased_amount1 = ' || l_increased_amount1);
4377: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': l_increase_amount_instal = ' || l_increase_amount_instal);
4378:
4379: -- getting current frequency record
4380: LNS_FIN_UTILS.fetchPayFreqRecByDate(
4381: p_FREQUENCY_SCHEDULE => l_freq_schedule_tbl,
4382: p_DATE => l_payment_tbl(l_installment_number).PERIOD_DUE_DATE,
4383: x_FREQUENCY_REC => l_FREQUENCY_REC);
4384: l_payment_frequency := l_FREQUENCY_REC.FREQUENCY;

Line 5006: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;

5002:
5003: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
5004: l_amortization_tbl LNS_FINANCIALS.AMORTIZATION_TBL;
5005: l_rate_tbl LNS_FINANCIALS.RATE_SCHEDULE_TBL;
5006: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
5007: l_amortized_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
5008: l_loan_start_date date;
5009: l_num_pay_dates number; -- number of dates on installment schedule
5010: l_periodic_payment number;

Line 5007: l_amortized_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;

5003: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
5004: l_amortization_tbl LNS_FINANCIALS.AMORTIZATION_TBL;
5005: l_rate_tbl LNS_FINANCIALS.RATE_SCHEDULE_TBL;
5006: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
5007: l_amortized_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
5008: l_loan_start_date date;
5009: l_num_pay_dates number; -- number of dates on installment schedule
5010: l_periodic_payment number;
5011: l_periodic_principal number;

Line 5095: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;

5091: l_early_pay_cr_detail_str varchar2(2000);
5092:
5093: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
5094: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
5095: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
5096: l_FREQUENCY_REC LNS_FIN_UTILS.FREQUENCY_SCHEDULE;
5097: l_prev_payment_frequency varchar2(30);
5098:
5099: -- get last bill date

Line 5096: l_FREQUENCY_REC LNS_FIN_UTILS.FREQUENCY_SCHEDULE;

5092:
5093: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
5094: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
5095: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
5096: l_FREQUENCY_REC LNS_FIN_UTILS.FREQUENCY_SCHEDULE;
5097: l_prev_payment_frequency varchar2(30);
5098:
5099: -- get last bill date
5100: cursor c_get_last_bill_date(p_loan_id number, p_installment_number number) is

Line 5236: l_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(

5232:
5233: -- get payment schedule
5234: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || '- getting payment schedule');
5235:
5236: l_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(
5237: P_LOAN_ID => l_loan_id,
5238: P_PHASE => 'TERM',
5239: P_COMPONENT => 'PRIN_INT');
5240:

Line 5241: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(

5237: P_LOAN_ID => l_loan_id,
5238: P_PHASE => 'TERM',
5239: P_COMPONENT => 'PRIN_INT');
5240:
5241: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(
5242: p_loan_start_date => l_loan_start_date,
5243: p_loan_maturity_date => l_maturity_date,
5244: p_freq_schedule_tbl => l_freq_schedule_tbl);
5245: /*

Line 5246: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(p_loan_start_date => l_loan_start_date

5242: p_loan_start_date => l_loan_start_date,
5243: p_loan_maturity_date => l_maturity_date,
5244: p_freq_schedule_tbl => l_freq_schedule_tbl);
5245: /*
5246: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(p_loan_start_date => l_loan_start_date
5247: ,p_loan_maturity_date => l_maturity_date
5248: ,p_first_pay_date => l_first_payment_date
5249: ,p_num_intervals => null --l_intervals
5250: ,p_interval_type => l_payment_frequency

Line 5259: l_amortized_maturity_date := LNS_FIN_UTILS.getMaturityDate(p_term => l_amortized_term

5255:
5256: if l_loan_term <> l_amortized_term then
5257:
5258: -- get amortize maturity date
5259: l_amortized_maturity_date := LNS_FIN_UTILS.getMaturityDate(p_term => l_amortized_term
5260: ,p_term_period => l_amortized_term_period
5261: ,p_frequency => l_payment_frequency
5262: ,p_start_date => l_loan_start_date);
5263: -- get amortize payment schedule

Line 5266: l_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(

5262: ,p_start_date => l_loan_start_date);
5263: -- get amortize payment schedule
5264: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || '- getting amortize payment schedule');
5265:
5266: l_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(
5267: P_LOAN_ID => l_loan_id,
5268: P_PHASE => 'TERM',
5269: P_COMPONENT => 'PRIN_INT');
5270:

Line 5271: l_amortized_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(

5267: P_LOAN_ID => l_loan_id,
5268: P_PHASE => 'TERM',
5269: P_COMPONENT => 'PRIN_INT');
5270:
5271: l_amortized_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(
5272: p_loan_start_date => l_loan_start_date,
5273: p_loan_maturity_date => l_amortized_maturity_date,
5274: p_freq_schedule_tbl => l_freq_schedule_tbl);
5275: /*

Line 5276: l_amortized_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(p_loan_start_date => l_loan_start_date

5272: p_loan_start_date => l_loan_start_date,
5273: p_loan_maturity_date => l_amortized_maturity_date,
5274: p_freq_schedule_tbl => l_freq_schedule_tbl);
5275: /*
5276: l_amortized_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(p_loan_start_date => l_loan_start_date
5277: ,p_loan_maturity_date => l_amortized_maturity_date
5278: ,p_first_pay_date => l_first_payment_date
5279: ,p_num_intervals => null --l_intervals
5280: ,p_interval_type => l_payment_frequency

Line 5475: LNS_FIN_UTILS.fetchPayFreqRecByDate(

5471:
5472: if l_begin = 1 then
5473: l_prev_payment_frequency := '';
5474: else
5475: LNS_FIN_UTILS.fetchPayFreqRecByDate(
5476: p_FREQUENCY_SCHEDULE => l_freq_schedule_tbl,
5477: p_DATE => l_payment_tbl(l_begin-1).PERIOD_DUE_DATE,
5478: x_FREQUENCY_REC => l_FREQUENCY_REC);
5479: l_prev_payment_frequency := l_FREQUENCY_REC.FREQUENCY;

Line 5646: LNS_FIN_UTILS.fetchPayFreqRecByDate(

5642: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': l_increased_amount1 = ' || l_increased_amount1);
5643: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': l_increase_amount_instal = ' || l_increase_amount_instal);
5644:
5645: -- getting current frequency record
5646: LNS_FIN_UTILS.fetchPayFreqRecByDate(
5647: p_FREQUENCY_SCHEDULE => l_freq_schedule_tbl,
5648: p_DATE => l_payment_tbl(l_installment_number).PERIOD_DUE_DATE,
5649: x_FREQUENCY_REC => l_FREQUENCY_REC);
5650: l_payment_frequency := l_FREQUENCY_REC.FREQUENCY;

Line 6389: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;

6385:
6386: l_amortization_rec LNS_FINANCIALS.AMORTIZATION_REC;
6387: l_amortization_tbl LNS_FINANCIALS.AMORTIZATION_TBL;
6388: l_rate_tbl LNS_FINANCIALS.RATE_SCHEDULE_TBL;
6389: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
6390: l_loan_start_date date;
6391: l_num_pay_dates number; -- number of dates on installment schedule
6392: l_periodic_payment number;
6393: l_periodic_principal number;

Line 6434: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;

6430: l_prev_end_balance number;
6431:
6432: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
6433: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
6434: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
6435:
6436: cursor c_total_disbursed(p_loan_id number, p_from_date date, p_to_date date) is
6437: select nvl(sum(header_amount), 0)
6438: from lns_disb_headers

Line 6496: l_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(

6492: -- get payment schedule
6493: -- this will return the acutal dates that payments will be due on
6494: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || '- getting payment schedule');
6495:
6496: l_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(
6497: P_LOAN_ID => l_loan_id,
6498: P_PHASE => 'OPEN',
6499: P_COMPONENT => 'PRIN_INT');
6500:

Line 6501: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(

6497: P_LOAN_ID => l_loan_id,
6498: P_PHASE => 'OPEN',
6499: P_COMPONENT => 'PRIN_INT');
6500:
6501: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(
6502: p_loan_start_date => l_loan_start_date,
6503: p_loan_maturity_date => l_maturity_date,
6504: p_freq_schedule_tbl => l_freq_schedule_tbl);
6505: /*

Line 6506: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(p_loan_start_date => l_loan_start_date

6502: p_loan_start_date => l_loan_start_date,
6503: p_loan_maturity_date => l_maturity_date,
6504: p_freq_schedule_tbl => l_freq_schedule_tbl);
6505: /*
6506: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(p_loan_start_date => l_loan_start_date
6507: ,p_loan_maturity_date => l_maturity_date
6508: ,p_first_pay_date => l_first_payment_date
6509: ,p_num_intervals => l_intervals
6510: ,p_interval_type => l_payment_frequency

Line 7313: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;

7309: l_num_pay_dates number;
7310: l_period_start_date date;
7311: l_period_end_date date;
7312: --l_pay_in_arrears boolean;
7313: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
7314: l_exit_loop boolean;
7315: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
7316: l_int_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
7317: l_prin_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;

Line 7315: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;

7311: l_period_end_date date;
7312: --l_pay_in_arrears boolean;
7313: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
7314: l_exit_loop boolean;
7315: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
7316: l_int_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
7317: l_prin_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
7318:
7319: begin

Line 7316: l_int_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;

7312: --l_pay_in_arrears boolean;
7313: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
7314: l_exit_loop boolean;
7315: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
7316: l_int_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
7317: l_prin_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
7318:
7319: begin
7320:

Line 7317: l_prin_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;

7313: l_payment_tbl LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
7314: l_exit_loop boolean;
7315: l_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
7316: l_int_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
7317: l_prin_freq_schedule_tbl LNS_FIN_UTILS.FREQUENCY_SCHEDULE_TBL;
7318:
7319: begin
7320:
7321: l_api_name := 'getWeightedRate';

Line 7335: l_int_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(

7331: if p_loan_details.custom_schedule = 'N' then
7332:
7333: if p_loan_details.PAYMENT_CALC_METHOD = 'SEPARATE_SCHEDULES' then
7334:
7335: l_int_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(
7336: P_LOAN_ID => p_loan_details.LOAN_ID,
7337: P_PHASE => 'TERM',
7338: P_COMPONENT => 'INT');
7339:

Line 7340: l_prin_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(

7336: P_LOAN_ID => p_loan_details.LOAN_ID,
7337: P_PHASE => 'TERM',
7338: P_COMPONENT => 'INT');
7339:
7340: l_prin_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(
7341: P_LOAN_ID => p_loan_details.LOAN_ID,
7342: P_PHASE => 'TERM',
7343: P_COMPONENT => 'PRIN');
7344:

Line 7345: l_payment_tbl := LNS_FIN_UTILS.buildSIPPaymentSchedule(

7341: P_LOAN_ID => p_loan_details.LOAN_ID,
7342: P_PHASE => 'TERM',
7343: P_COMPONENT => 'PRIN');
7344:
7345: l_payment_tbl := LNS_FIN_UTILS.buildSIPPaymentSchedule(
7346: p_loan_start_date => p_loan_details.loan_start_date,
7347: p_loan_maturity_date => p_loan_details.maturity_date,
7348: p_prin_freq_schedule_tbl => l_prin_freq_schedule_tbl,
7349: p_int_freq_schedule_tbl => l_int_freq_schedule_tbl);

Line 7351: l_payment_tbl := LNS_FIN_UTILS.buildSIPPaymentSchedule(

7347: p_loan_maturity_date => p_loan_details.maturity_date,
7348: p_prin_freq_schedule_tbl => l_prin_freq_schedule_tbl,
7349: p_int_freq_schedule_tbl => l_int_freq_schedule_tbl);
7350: /*
7351: l_payment_tbl := LNS_FIN_UTILS.buildSIPPaymentSchedule(
7352: p_loan_start_date => p_loan_details.loan_start_date
7353: ,p_loan_maturity_date => p_loan_details.maturity_date
7354: ,p_int_first_pay_date => p_loan_details.first_payment_date
7355: ,p_int_num_intervals => p_loan_details.number_installments

Line 7365: l_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(

7361: ,p_prin_pay_in_arrears => p_loan_details.PRIN_PAY_IN_ARREARS_BOOL);
7362: */
7363: else
7364:
7365: l_freq_schedule_tbl := LNS_FIN_UTILS.fetchFreqSchedule(
7366: P_LOAN_ID => p_loan_details.LOAN_ID,
7367: P_PHASE => 'TERM',
7368: P_COMPONENT => 'PRIN_INT');
7369:

Line 7370: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(

7366: P_LOAN_ID => p_loan_details.LOAN_ID,
7367: P_PHASE => 'TERM',
7368: P_COMPONENT => 'PRIN_INT');
7369:
7370: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(
7371: p_loan_start_date => p_loan_details.loan_start_date,
7372: p_loan_maturity_date => p_loan_details.maturity_date,
7373: p_freq_schedule_tbl => l_freq_schedule_tbl);
7374: /*

Line 7375: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(p_loan_start_date => p_loan_details.loan_start_date

7371: p_loan_start_date => p_loan_details.loan_start_date,
7372: p_loan_maturity_date => p_loan_details.maturity_date,
7373: p_freq_schedule_tbl => l_freq_schedule_tbl);
7374: /*
7375: l_payment_tbl := LNS_FIN_UTILS.buildPaymentSchedule(p_loan_start_date => p_loan_details.loan_start_date
7376: ,p_loan_maturity_date => p_loan_details.maturity_date
7377: ,p_first_pay_date => p_loan_details.first_payment_date
7378: ,p_num_intervals => p_loan_details.number_installments
7379: ,p_interval_type => p_loan_details.payment_frequency

Line 7434: l_days_at_rate := LNS_FIN_UTILS.getDayCount(p_start_date => l_period_start_date

7430: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' l_period_end_date: ' || l_period_end_date);
7431:
7432: if l_period_start_date is not null and l_period_end_date is not null then
7433:
7434: l_days_at_rate := LNS_FIN_UTILS.getDayCount(p_start_date => l_period_start_date
7435: ,p_end_date => l_period_end_date
7436: ,p_day_count_method => p_loan_details.day_count_method);
7437: l_rate_details := getRateDetails(p_installment => k
7438: ,p_rate_tbl => p_rate_tbl);

Line 7707: ,nvl(lns_fin_utils.getActiveRate(h.loan_id), decode(p_phase, 'TERM', t.TERM_PROJECTED_RATE, t.OPEN_PROJECTED_RATE)) LAST_INTEREST_RATE

7703: ,t.INDEX_RATE_ID TERM_INDEX_RATE_ID
7704: ,t.OPEN_INDEX_DATE OPEN_INDEX_DATE
7705: ,t.TERM_INDEX_DATE TERM_INDEX_DATE
7706: ,decode(p_phase, 'TERM', t.TERM_PROJECTED_RATE, t.OPEN_PROJECTED_RATE) INITIAL_INTEREST_RATE
7707: ,nvl(lns_fin_utils.getActiveRate(h.loan_id), decode(p_phase, 'TERM', t.TERM_PROJECTED_RATE, t.OPEN_PROJECTED_RATE)) LAST_INTEREST_RATE
7708: ,nvl(t.FIRST_RATE_CHANGE_DATE, t.NEXT_RATE_CHANGE_DATE) FIRST_RATE_CHANGE_DATE
7709: ,t.NEXT_RATE_CHANGE_DATE NEXT_RATE_CHANGE_DATE
7710: ,t.CALCULATION_METHOD
7711: ,t.INTEREST_COMPOUNDING_FREQ

Line 7823: l_amortize_dates LNS_FIN_UTILS.DATE_TBL;

7819: l_billed_principal number;
7820: l_amortized_to_Date date;
7821: --l_pay_in_arrears boolean;
7822: l_loan_Details LNS_FINANCIALS.LOAN_DETAILS_REC;
7823: l_amortize_dates LNS_FIN_UTILS.DATE_TBL;
7824: l_loan_id number;
7825: l_api_name varchar2(25);
7826:
7827: begin

Line 8246: l_initial_months := lns_fin_utils.convertPeriod(p_term => l_term

8242: if l_custom_payments_flag <> 'Y' then
8243: -- we will be converting the term of the loan if frequency > MONTHLY
8244: if l_payment_frequency <> 'SEMI-MONTHLY' AND l_payment_frequency <> 'WEEKLY' AND l_payment_frequency <> 'BIWEEKLY' then
8245: l_new_frequency := 'MONTHS';
8246: l_initial_months := lns_fin_utils.convertPeriod(p_term => l_term
8247: ,p_term_period => l_term_period);
8248: else
8249: --weeks or semi-months
8250: if substr(l_payment_frequency, length(l_payment_frequency) - 1, 2) = 'LY' then

Line 8264: l_new_maturity_date := lns_fin_utils.getNextDate(p_date => l_new_maturity_date

8260: loop
8261: -- i will be the number of "TERMS" to add the LNS_LOAN_HEADERS.TERM
8262: i := i + 1;
8263: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - i ' || l_new_maturity_date);
8264: l_new_maturity_date := lns_fin_utils.getNextDate(p_date => l_new_maturity_date
8265: ,p_interval_type => l_new_frequency
8266: ,p_direction => 1);
8267: exit when l_new_maturity_date >= l_max_pay_request_date;
8268: end loop;

Line 8477: l_new_maturity_date := LNS_FIN_UTILS.getMaturityDate(p_term => l_loan_Details.loan_term

8473: return;
8474: end if;
8475:
8476: -- get the new maturity date
8477: l_new_maturity_date := LNS_FIN_UTILS.getMaturityDate(p_term => l_loan_Details.loan_term
8478: ,p_term_period => l_loan_Details.loan_term_period
8479: ,p_frequency => l_loan_Details.amortization_frequency
8480: ,p_start_date => p_new_start_date);
8481:

Line 9673: l_day_count := LNS_FIN_UTILS.getDayCount(p_start_date => l_start_date

9669:
9670: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': l_start_date = ' || l_start_date);
9671: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': l_end_date = ' || l_end_date);
9672:
9673: l_day_count := LNS_FIN_UTILS.getDayCount(p_start_date => l_start_date
9674: ,p_end_date => l_end_date
9675: ,p_day_count_method => p_days_count_method);
9676:
9677: l_days_in_year := LNS_FIN_UTILS.daysInYear(p_year => k

Line 9677: l_days_in_year := LNS_FIN_UTILS.daysInYear(p_year => k

9673: l_day_count := LNS_FIN_UTILS.getDayCount(p_start_date => l_start_date
9674: ,p_end_date => l_end_date
9675: ,p_day_count_method => p_days_count_method);
9676:
9677: l_days_in_year := LNS_FIN_UTILS.daysInYear(p_year => k
9678: ,p_year_count_method => p_days_count_method);
9679:
9680: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': l_day_count = ' || l_day_count);
9681: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': l_days_in_year = ' || l_days_in_year);

Line 9710: l_days_in_year := LNS_FIN_UTILS.daysInYear(p_year => k

9706: l_avrg_days_in_years := 0;
9707: l_years_count := 0;
9708: for k in l_year1..l_year2 loop
9709:
9710: l_days_in_year := LNS_FIN_UTILS.daysInYear(p_year => k
9711: ,p_year_count_method => p_days_count_method);
9712:
9713: l_avrg_days_in_years := l_avrg_days_in_years + l_days_in_year;
9714: l_years_count := l_years_count + 1;

Line 9847: l_day_count := LNS_FIN_UTILS.getDayCount(p_start_date => l_start_date

9843:
9844: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': l_start_date = ' || l_start_date);
9845: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': l_end_date = ' || l_end_date);
9846:
9847: l_day_count := LNS_FIN_UTILS.getDayCount(p_start_date => l_start_date
9848: ,p_end_date => l_end_date
9849: ,p_day_count_method => p_days_count_method);
9850:
9851: l_days_in_year := LNS_FIN_UTILS.daysInYear(p_year => k

Line 9851: l_days_in_year := LNS_FIN_UTILS.daysInYear(p_year => k

9847: l_day_count := LNS_FIN_UTILS.getDayCount(p_start_date => l_start_date
9848: ,p_end_date => l_end_date
9849: ,p_day_count_method => p_days_count_method);
9850:
9851: l_days_in_year := LNS_FIN_UTILS.daysInYear(p_year => k
9852: ,p_year_count_method => p_days_count_method);
9853:
9854: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': l_day_count = ' || l_day_count);
9855: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': l_days_in_year = ' || l_days_in_year);

Line 9871: l_days_in_year := LNS_FIN_UTILS.daysInYear(p_year => k

9867: l_avrg_days_in_years := 0;
9868: l_years_count := 0;
9869: for k in l_year1..l_year2 loop
9870:
9871: l_days_in_year := LNS_FIN_UTILS.daysInYear(p_year => k
9872: ,p_year_count_method => p_days_count_method);
9873:
9874: l_avrg_days_in_years := l_avrg_days_in_years + l_days_in_year;
9875: l_years_count := l_years_count + 1;

Line 10465: l_num_days := LNS_FIN_UTILS.getDayCount(p_start_date => p_from_date

10461: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - activity date: ' || l_loan_activities(p).activity_date);
10462: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - activity amount: ' || l_loan_activities(p).activity_amount);
10463: if p = 1 then
10464: -- this is for the previous balance
10465: l_num_days := LNS_FIN_UTILS.getDayCount(p_start_date => p_from_date
10466: ,p_end_date => p_to_date
10467: ,p_day_count_method => p_day_count_method);
10468: elsif p < m then
10469: l_num_days := LNS_FIN_UTILS.getDayCount(p_start_date => l_loan_activities(p).activity_date

Line 10469: l_num_days := LNS_FIN_UTILS.getDayCount(p_start_date => l_loan_activities(p).activity_date

10465: l_num_days := LNS_FIN_UTILS.getDayCount(p_start_date => p_from_date
10466: ,p_end_date => p_to_date
10467: ,p_day_count_method => p_day_count_method);
10468: elsif p < m then
10469: l_num_days := LNS_FIN_UTILS.getDayCount(p_start_date => l_loan_activities(p).activity_date
10470: ,p_end_date => l_loan_activities(p+1).activity_date
10471: ,p_day_count_method => p_day_count_method);
10472: elsif p = m then
10473: --dbms_output.put_line('2');

Line 10474: l_num_days := LNS_FIN_UTILS.getDayCount(p_start_date => l_loan_activities(p).activity_date

10470: ,p_end_date => l_loan_activities(p+1).activity_date
10471: ,p_day_count_method => p_day_count_method);
10472: elsif p = m then
10473: --dbms_output.put_line('2');
10474: l_num_days := LNS_FIN_UTILS.getDayCount(p_start_date => l_loan_activities(p).activity_date
10475: ,p_end_date => p_to_date
10476: ,p_day_count_method => p_day_count_method);
10477: end if;
10478:

Line 10496: l_total_Days := LNS_FIN_UTILS.getDayCount(p_start_date => p_from_date

10492:
10493: end loop;
10494:
10495: -- this is the total days (denominator)
10496: l_total_Days := LNS_FIN_UTILS.getDayCount(p_start_date => p_from_date
10497: ,p_end_date => p_to_date
10498: ,p_day_count_method => p_day_count_method);
10499: -- dbms_output.put_line('total days is ' || l_total_Days );
10500: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_balance_days: ' || l_balance_days);

Line 10934: l_num_days := LNS_FIN_UTILS.getDayCount(p_start_date => p_from_date

10930: for p in k..m loop
10931: --dbms_output.put_line('p is ' || p);
10932: if p = k then -- first record
10933: --dbms_output.put_line('1');
10934: l_num_days := LNS_FIN_UTILS.getDayCount(p_start_date => p_from_date
10935: ,p_end_date => l_loan_activities(p + 1).activity_date
10936: ,p_day_count_method => l_loan_details.day_count_method);
10937:
10938: elsif p = m then

Line 10940: l_num_days := LNS_FIN_UTILS.getDayCount(p_start_date => l_loan_activities(p).activity_date

10936: ,p_day_count_method => l_loan_details.day_count_method);
10937:
10938: elsif p = m then
10939: -- dbms_output.put_line('3');
10940: l_num_days := LNS_FIN_UTILS.getDayCount(p_start_date => l_loan_activities(p).activity_date
10941: ,p_end_date => p_to_date
10942: ,p_day_count_method => l_loan_details.day_count_method);
10943:
10944: else

Line 10946: l_num_days := LNS_FIN_UTILS.getDayCount(p_start_date => l_loan_activities(p).activity_date

10942: ,p_day_count_method => l_loan_details.day_count_method);
10943:
10944: else
10945: -- dbms_output.put_line('2');
10946: l_num_days := LNS_FIN_UTILS.getDayCount(p_start_date => l_loan_activities(p).activity_date
10947: ,p_end_date => l_loan_activities(p + 1).activity_date
10948: ,p_day_count_method => l_loan_details.day_count_method);
10949:
10950: end if;

Line 10957: l_total_Days := LNS_FIN_UTILS.getDayCount(p_start_date => p_from_date

10953: l_balance_days := l_balance_days + l_num_days * l_loan_activities(p).ending_balance;
10954:
10955: end loop;
10956: -- this is the total days (denominator)
10957: l_total_Days := LNS_FIN_UTILS.getDayCount(p_start_date => p_from_date
10958: ,p_end_date => p_to_date
10959: ,p_day_count_method => l_loan_details.day_count_method);
10960:
10961: --dbms_output.put_line('total days is ' || l_total_Days );