APPS.LNS_DISTRIBUTIONS_PUB dependencies on LNS_FINANCIALS

Line 8737: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;

8733:
8734: IS
8735:
8736: l_api_name VARCHAR2(30);
8737: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
8738: l_rate_tbl LNS_FINANCIALS.RATE_SCHEDULE_TBL;
8739: l_annualized_rate NUMBER;
8740: l_accr_norm_interest NUMBER;
8741: l_last_int_billed_date DATE;

Line 8738: l_rate_tbl LNS_FINANCIALS.RATE_SCHEDULE_TBL;

8734: IS
8735:
8736: l_api_name VARCHAR2(30);
8737: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
8738: l_rate_tbl LNS_FINANCIALS.RATE_SCHEDULE_TBL;
8739: l_annualized_rate NUMBER;
8740: l_accr_norm_interest NUMBER;
8741: l_last_int_billed_date DATE;
8742: l_current_phase VARCHAR2(30);

Line 8827: l_loan_details := lns_financials.getLoanDetails(p_loan_id => p_loan_id

8823: fetch c_loan_info into l_current_phase;
8824: close c_loan_info;
8825: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - current phase ' || l_current_phase);
8826:
8827: l_loan_details := lns_financials.getLoanDetails(p_loan_id => p_loan_id
8828: ,p_based_on_terms => 'CURRENT'
8829: ,p_phase => l_current_phase);
8830:
8831: l_rate_tbl := lns_financials.getRateSchedule(p_loan_id, l_current_phase);

Line 8831: l_rate_tbl := lns_financials.getRateSchedule(p_loan_id, l_current_phase);

8827: l_loan_details := lns_financials.getLoanDetails(p_loan_id => p_loan_id
8828: ,p_based_on_terms => 'CURRENT'
8829: ,p_phase => l_current_phase);
8830:
8831: l_rate_tbl := lns_financials.getRateSchedule(p_loan_id, l_current_phase);
8832: l_last_inst_number := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT_2(p_loan_id);
8833:
8834: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_last_inst_number: ' || l_last_inst_number);
8835:

Line 8845: l_annualized_rate := lns_financials.getWeightedRate(p_loan_details => l_loan_details

8841:
8842: if l_rate_tbl.count = 1 then
8843: l_annualized_rate := l_rate_tbl(1).annual_rate;
8844: else
8845: l_annualized_rate := lns_financials.getWeightedRate(p_loan_details => l_loan_details
8846: ,p_start_date => l_last_int_billed_date
8847: ,p_end_date => p_accrual_date
8848: ,p_rate_tbl => l_rate_tbl);
8849: end if;

Line 8854: LNS_FINANCIALS.CALC_NORM_INTEREST(p_loan_id => p_loan_id,

8850: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_annualized_rate: ' || l_annualized_rate);
8851:
8852:
8853: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calculating accrued interest...');
8854: LNS_FINANCIALS.CALC_NORM_INTEREST(p_loan_id => p_loan_id,
8855: p_calc_method => l_loan_details.CALCULATION_METHOD,
8856: p_period_start_date => l_last_int_billed_date,
8857: p_period_end_date => p_accrual_date,
8858: p_interest_rate => l_annualized_rate,

Line 8874: LNS_FINANCIALS.CALC_ADD_INTEREST(p_loan_id => p_loan_id,

8870: IF (l_last_inst_number >= 0) THEN
8871:
8872: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calculating additional interest on unpaid principal...');
8873: -- calculate additional interest on unpaid principal
8874: LNS_FINANCIALS.CALC_ADD_INTEREST(p_loan_id => p_loan_id,
8875: p_calc_method => l_loan_details.CALCULATION_METHOD,
8876: p_period_start_date => l_last_int_billed_date,
8877: p_period_end_date => p_accrual_date,
8878: p_interest_rate => l_annualized_rate,

Line 8897: LNS_FINANCIALS.CALC_ADD_INTEREST(p_loan_id => p_loan_id,

8893: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_add_prin_interest: ' || l_add_prin_interest);
8894:
8895: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calculating additional interest on unpaid interest...');
8896: -- calculate additional interest on unpaid interest
8897: LNS_FINANCIALS.CALC_ADD_INTEREST(p_loan_id => p_loan_id,
8898: p_calc_method => l_loan_details.CALCULATION_METHOD,
8899: p_period_start_date => l_last_int_billed_date,
8900: p_period_end_date => p_accrual_date,
8901: p_interest_rate => l_annualized_rate,