DBA Data[Home] [Help]

APPS.LNS_FEE_ENGINE dependencies on LNS_FINANCIALS

Line 1090: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;

1086: l_calc_fee number;
1087: i number;
1088: l_fee_calc_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
1089: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
1090: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
1091: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
1092: l_installment Number;
1093:
1094: cursor c_from_installment(p_fee_id number, p_loan_id number) is

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

1131: end if;
1132:
1133: -- build the fee bases
1134: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - getting details');
1135: l_loan_details := lns_financials.getLoanDetails(p_loan_id => p_loan_id
1136: ,p_based_on_terms => 'ORIGINAL'
1137: ,p_phase => 'TERM');
1138:
1139: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_installment ' || l_installment);

Line 1609: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;

1605: l_msg_count NUMBER;
1606: l_msg_data VARCHAR2(32767);
1607: iFeeCount number;
1608: l_last_installment number;
1609: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
1610: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL; --use for recurring
1611: l_orig_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL; --use for origination
1612: l_conv_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL; --use for conversion
1613: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;

Line 1672: l_loan_Details := lns_financials.getLoanDetails(p_loan_id, p_based_on_terms, 'OPEN');

1668:
1669:
1670: --elsif -- we going by original amortization schedule
1671: -- get disbursement_ids for timePeriod
1672: l_loan_Details := lns_financials.getLoanDetails(p_loan_id, p_based_on_terms, 'OPEN');
1673:
1674: -- 0. buildPaymentSchedule
1675: l_payment_tbl := lns_fin_utils.buildPaymentSchedule(p_loan_start_date => l_loan_Details.loan_start_date
1676: ,p_loan_maturity_date => l_loan_details.maturity_date

Line 1941: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;

1937: l_return_status VARCHAR2(1);
1938: l_msg_count NUMBER;
1939: l_msg_data VARCHAR2(32767);
1940:
1941: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
1942: l_fee_schedule_id NUMBER;
1943: i number;
1944:
1945: cursor c_fee_schedule_id (p_loan_id number, p_fee_id number) is

Line 2015: l_loan_details := lns_financials.getLoanDetails(p_loan_id, 'CURRENT', l_phase);

2011: open c_phase(p_loan_id);
2012: fetch c_phase into l_phase;
2013: close c_phase;
2014:
2015: l_loan_details := lns_financials.getLoanDetails(p_loan_id, 'CURRENT', l_phase);
2016: i := p_fees_tbl.count;
2017: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - found ' || i || 'fee structures');
2018:
2019: -- validate all structures

Line 2173: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;

2169: l_return_status VARCHAR2(1);
2170: l_msg_count NUMBER;
2171: l_msg_data VARCHAR2(32767);
2172:
2173: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
2174: l_fee_schedule_id NUMBER;
2175: i number;
2176:
2177: cursor c_phase(p_loan_id number) is

Line 2225: l_loan_details := lns_financials.getLoanDetails(p_loan_id, 'CURRENT', l_phase);

2221: open c_phase(p_loan_id);
2222: fetch c_phase into l_phase;
2223: close c_phase;
2224:
2225: l_loan_details := lns_financials.getLoanDetails(p_loan_id, 'CURRENT', l_phase);
2226: i := p_fees_tbl.count;
2227: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - found ' || i || 'fee structures');
2228:
2229: -- validate all structures

Line 2393: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;

2389: l_return_status VARCHAR2(1);
2390: l_msg_count NUMBER;
2391: l_msg_data VARCHAR2(32767);
2392:
2393: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
2394: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
2395: l_fee_schedule_id NUMBER;
2396: l_fee_calc_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
2397: l_fee_category varchar2(30);