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_CUSTOM_PUB dependencies on LNS_FEE_ENGINE

Line 297: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;

293: l_original_loan_amount number;
294: l_fee_amount number;
295:
296: -- for fees
297: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
298: l_orig_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
299: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
300: l_orig_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
301: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;

Line 298: l_orig_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;

294: l_fee_amount number;
295:
296: -- for fees
297: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
298: l_orig_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
299: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
300: l_orig_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
301: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
302:

Line 299: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;

295:
296: -- for fees
297: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
298: l_orig_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
299: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
300: l_orig_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
301: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
302:
303: -- total fees on the schedule by installment

Line 300: l_orig_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;

296: -- for fees
297: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
298: l_orig_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
299: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
300: l_orig_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
301: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
302:
303: -- total fees on the schedule by installment
304: cursor c_fees(p_loan_id number, p_installment number) is

Line 301: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;

297: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
298: l_orig_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
299: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
300: l_orig_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
301: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
302:
303: -- total fees on the schedule by installment
304: cursor c_fees(p_loan_id number, p_installment number) is
305: select nvl(sum(sched.fee_amount), 0)

Line 375: l_orig_fee_structures := lns_fee_engine.getFeeStructures(p_loan_id => p_loan_id

371: close c_loan_details;
372:
373: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - getting fee structures');
374: -- now we've passed validation initialize loan_begin_balance to calculate balances
375: l_orig_fee_structures := lns_fee_engine.getFeeStructures(p_loan_id => p_loan_id
376: ,p_fee_category => 'EVENT'
377: ,p_fee_type => 'EVENT_ORIGINATION'
378: ,p_installment => null
379: ,p_phase => 'TERM'

Line 382: l_fee_structures := lns_fee_engine.getFeeStructures(p_loan_id => p_loan_id

378: ,p_installment => null
379: ,p_phase => 'TERM'
380: ,p_fee_id => null);
381:
382: l_fee_structures := lns_fee_engine.getFeeStructures(p_loan_id => p_loan_id
383: ,p_fee_category => 'RECUR'
384: ,p_fee_type => null
385: ,p_installment => null
386: ,p_phase => 'TERM'

Line 440: lns_fee_engine.calculateFees(p_loan_id => p_loan_id

436: l_fee_basis_tbl(2).fee_basis_amount := l_original_loan_amount;
437:
438: if k = 1 then
439: if l_orig_fee_structures.count > 0 then
440: lns_fee_engine.calculateFees(p_loan_id => p_loan_id
441: ,p_installment => k
442: ,p_fee_basis_tbl => l_fee_basis_tbl
443: ,p_fee_structures => l_orig_fee_structures
444: ,x_fees_tbl => l_orig_fees_tbl

Line 453: lns_fee_engine.calculateFees(p_loan_id => p_loan_id

449: end if;
450: end if;
451:
452: if l_fee_structures.count > 0 then
453: lns_fee_engine.calculateFees(p_loan_id => p_loan_id
454: ,p_installment => k
455: ,p_fee_basis_tbl => l_fee_basis_tbl
456: ,p_fee_structures => l_fee_structures
457: ,x_fees_tbl => l_fees_tbl

Line 2152: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;

2148: l_penal_int_interest number;
2149: l_penal_interest number;
2150: l_prev_grace_end_date date;
2151: l_payment LNS_FIN_UTILS.PAYMENT_SCHEDULE;
2152: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
2153: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
2154:
2155: l_fee_amount number;
2156: l_other_amount number;

Line 2153: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;

2149: l_penal_interest number;
2150: l_prev_grace_end_date date;
2151: l_payment LNS_FIN_UTILS.PAYMENT_SCHEDULE;
2152: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
2153: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
2154:
2155: l_fee_amount number;
2156: l_other_amount number;
2157: l_manual_fee_amount number;

Line 3326: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for this installment...');

3322: l_fee_basis_tbl(8).fee_basis_amount := l_custom_tbl(i).UNPAID_INT;
3323: l_fee_basis_tbl(9).fee_basis_name := 'CURR_LOAN';
3324: l_fee_basis_tbl(9).fee_basis_amount := l_loan_details.requested_amount + l_loan_details.ADD_REQUESTED_AMOUNT;
3325:
3326: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for this installment...');
3327: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE
3328: ,p_loan_id => p_loan_id
3329: ,p_installment => l_custom_tbl(i).PAYMENT_NUMBER
3330: ,p_fee_basis_tbl => l_fee_basis_tbl

Line 3327: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE

3323: l_fee_basis_tbl(9).fee_basis_name := 'CURR_LOAN';
3324: l_fee_basis_tbl(9).fee_basis_amount := l_loan_details.requested_amount + l_loan_details.ADD_REQUESTED_AMOUNT;
3325:
3326: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': Calling LNS_FEE_ENGINE.getFeeDetails for this installment...');
3327: LNS_FEE_ENGINE.getFeeDetails(p_init_msg_list => FND_API.G_FALSE
3328: ,p_loan_id => p_loan_id
3329: ,p_installment => l_custom_tbl(i).PAYMENT_NUMBER
3330: ,p_fee_basis_tbl => l_fee_basis_tbl
3331: ,p_based_on_terms => p_based_on_terms