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.

APPS.LNS_FEE_ENGINE dependencies on LNS_FINANCIALS

Line 1153: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;

1149: l_calc_fee number;
1150: i number;
1151: l_fee_calc_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
1152: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
1153: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
1154: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
1155: l_installment Number;
1156: l_phase varchar2(30);
1157:

Line 1219: l_loan_details := lns_financials.getLoanDetails(p_loan_id, l_based_on_terms, l_phase);

1215: end if;
1216:
1217: -- build the fee bases
1218: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - getting details');
1219: l_loan_details := lns_financials.getLoanDetails(p_loan_id, l_based_on_terms, l_phase);
1220:
1221: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_installment ' || l_installment);
1222:
1223: l_fee_basis_tbl(1).fee_basis_name := 'TOTAL_BAL';

Line 2269: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;

2265: l_return_status VARCHAR2(1);
2266: l_msg_count NUMBER;
2267: l_msg_data VARCHAR2(32767);
2268:
2269: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
2270: l_fee_schedule_id NUMBER;
2271: i number;
2272:
2273: cursor c_fee_schedule_id (p_loan_id number, p_fee_id number) is

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

2339: open c_phase(p_loan_id);
2340: fetch c_phase into l_phase;
2341: close c_phase;
2342:
2343: l_loan_details := lns_financials.getLoanDetails(p_loan_id, 'CURRENT', l_phase);
2344: i := p_fees_tbl.count;
2345: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - found ' || i || 'fee structures');
2346:
2347: -- validate all structures

Line 2513: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;

2509: l_return_status VARCHAR2(1);
2510: l_msg_count NUMBER;
2511: l_msg_data VARCHAR2(32767);
2512:
2513: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
2514: l_fee_schedule_id NUMBER;
2515: i number;
2516: l_phase varchar2(30);
2517:

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

2560: open c_phase(p_loan_id);
2561: fetch c_phase into l_phase;
2562: close c_phase;
2563:
2564: l_loan_details := lns_financials.getLoanDetails(p_loan_id, 'CURRENT', l_phase);
2565: i := p_fees_tbl.count;
2566: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - found ' || i || 'fee structures');
2567:
2568: -- validate all structures

Line 2738: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;

2734: l_return_status VARCHAR2(1);
2735: l_msg_count NUMBER;
2736: l_msg_data VARCHAR2(32767);
2737:
2738: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
2739: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
2740: l_fee_schedule_id NUMBER;
2741: l_fee_calc_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
2742: l_fee_category varchar2(30);

Line 3324: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;

3320: l_int_overdue number;
3321:
3322: l_write_fee_calc_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
3323: l_update_fee_calc_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
3324: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
3325:
3326: CURSOR last_instal_cur(P_LOAN_ID number, p_payment_number number) IS
3327: select DUE_DATE
3328: from LNS_AMORTIZATION_SCHEDS

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

3377:
3378: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - p_loan_id = ' || p_loan_id);
3379: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_phase = ' || l_phase);
3380:
3381: l_loan_details := lns_financials.getLoanDetails(p_loan_id, 'CURRENT', l_phase);
3382:
3383: l_last_installment := l_loan_details.last_installment_billed;
3384: l_current_installment := l_last_installment + 1;
3385: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - l_last_installment = ' || l_last_installment);