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 294: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;

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

Line 295: l_orig_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;

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

Line 296: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;

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

Line 297: l_orig_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;

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

Line 298: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;

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

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

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

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

374: ,p_fee_type => 'EVENT_ORIGINATION'
375: ,p_installment => null
376: ,p_fee_id => null);
377:
378: l_fee_structures := lns_fee_engine.getFeeStructures(p_loan_id => p_loan_id
379: ,p_fee_category => 'RECUR'
380: ,p_fee_type => null
381: ,p_installment => null
382: ,p_fee_id => null);

Line 435: lns_fee_engine.calculateFees(p_loan_id => p_loan_id

431: l_fee_basis_tbl(2).fee_basis_amount := l_original_loan_amount;
432:
433: if k = 1 then
434: if l_orig_fee_structures.count > 0 then
435: lns_fee_engine.calculateFees(p_loan_id => p_loan_id
436: ,p_installment => k
437: ,p_fee_basis_tbl => l_fee_basis_tbl
438: ,p_fee_structures => l_orig_fee_structures
439: ,x_fees_tbl => l_orig_fees_tbl

Line 448: lns_fee_engine.calculateFees(p_loan_id => p_loan_id

444: end if;
445: end if;
446:
447: if l_fee_structures.count > 0 then
448: lns_fee_engine.calculateFees(p_loan_id => p_loan_id
449: ,p_installment => k
450: ,p_fee_basis_tbl => l_fee_basis_tbl
451: ,p_fee_structures => l_fee_structures
452: ,x_fees_tbl => l_fees_tbl

Line 1957: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;

1953: l_prev_grace_end_date date;
1954: l_payment LNS_FIN_UTILS.PAYMENT_SCHEDULE;
1955:
1956: -- for fees
1957: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
1958: l_memo_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
1959: l_orig_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
1960: l_memo_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
1961: l_orig_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;

Line 1958: l_memo_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;

1954: l_payment LNS_FIN_UTILS.PAYMENT_SCHEDULE;
1955:
1956: -- for fees
1957: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
1958: l_memo_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
1959: l_orig_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
1960: l_memo_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
1961: l_orig_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
1962: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;

Line 1959: l_orig_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;

1955:
1956: -- for fees
1957: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
1958: l_memo_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
1959: l_orig_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
1960: l_memo_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
1961: l_orig_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
1962: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
1963: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;

Line 1960: l_memo_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;

1956: -- for fees
1957: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
1958: l_memo_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
1959: l_orig_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
1960: l_memo_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
1961: l_orig_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
1962: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
1963: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
1964: l_fee_amount number;

Line 1961: l_orig_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;

1957: l_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
1958: l_memo_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
1959: l_orig_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
1960: l_memo_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
1961: l_orig_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
1962: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
1963: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
1964: l_fee_amount number;
1965: l_other_amount number;

Line 1962: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;

1958: l_memo_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
1959: l_orig_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
1960: l_memo_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
1961: l_orig_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
1962: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
1963: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
1964: l_fee_amount number;
1965: l_other_amount number;
1966: l_manual_fee_amount number;

Line 1963: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;

1959: l_orig_fee_structures LNS_FEE_ENGINE.FEE_STRUCTURE_TBL;
1960: l_memo_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
1961: l_orig_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
1962: l_fees_tbl LNS_FEE_ENGINE.FEE_CALC_TBL;
1963: l_fee_basis_tbl LNS_FEE_ENGINE.FEE_BASIS_TBL;
1964: l_fee_amount number;
1965: l_other_amount number;
1966: l_manual_fee_amount number;
1967:

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

2215: synchRateSchedule(l_rate_tbl, l_num_installments);
2216:
2217: --getting fees
2218: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'getting fee structures');
2219: l_orig_fee_structures := lns_fee_engine.getFeeStructures(p_loan_id => p_loan_id
2220: ,p_fee_category => 'EVENT'
2221: ,p_fee_type => 'EVENT_ORIGINATION'
2222: ,p_installment => null
2223: ,p_fee_id => null);

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

2221: ,p_fee_type => 'EVENT_ORIGINATION'
2222: ,p_installment => null
2223: ,p_fee_id => null);
2224:
2225: l_fee_structures := lns_fee_engine.getFeeStructures(p_loan_id => p_loan_id
2226: ,p_fee_category => 'RECUR'
2227: ,p_fee_type => null
2228: ,p_installment => null
2229: ,p_fee_id => null);

Line 2231: l_memo_fee_structures := lns_fee_engine.getFeeStructures(p_loan_id => p_loan_id

2227: ,p_fee_type => null
2228: ,p_installment => null
2229: ,p_fee_id => null);
2230:
2231: l_memo_fee_structures := lns_fee_engine.getFeeStructures(p_loan_id => p_loan_id
2232: ,p_fee_category => 'MEMO'
2233: ,p_fee_type => null
2234: ,p_installment => null
2235: ,p_fee_id => null);

Line 2628: lns_fee_engine.calculateFees(p_loan_id => p_loan_id

2624: l_fee_basis_tbl(2).fee_basis_amount := l_loan_details.FUNDED_AMOUNT;
2625:
2626: if l_custom_tbl(i).PAYMENT_NUMBER = 1 then
2627: if l_orig_fee_structures.count > 0 then
2628: lns_fee_engine.calculateFees(p_loan_id => p_loan_id
2629: ,p_installment => l_custom_tbl(i).PAYMENT_NUMBER
2630: ,p_fee_basis_tbl => l_fee_basis_tbl
2631: ,p_fee_structures => l_orig_fee_structures
2632: ,x_fees_tbl => l_orig_fees_tbl

Line 2642: lns_fee_engine.calculateFees(p_loan_id => p_loan_id

2638: end if;
2639:
2640: -- calculate the memo fees
2641: if l_memo_fee_structures.count > 0 then
2642: lns_fee_engine.calculateFees(p_loan_id => p_loan_id
2643: ,p_installment => l_custom_tbl(i).PAYMENT_NUMBER
2644: ,p_fee_basis_tbl => l_fee_basis_tbl
2645: ,p_fee_structures => l_memo_fee_structures
2646: ,x_fees_tbl => l_memo_fees_tbl

Line 2655: lns_fee_engine.calculateFees(p_loan_id => p_loan_id

2651:
2652: end if;
2653:
2654: if l_fee_structures.count > 0 then
2655: lns_fee_engine.calculateFees(p_loan_id => p_loan_id
2656: ,p_installment => l_custom_tbl(i).PAYMENT_NUMBER
2657: ,p_fee_basis_tbl => l_fee_basis_tbl
2658: ,p_fee_structures => l_fee_structures
2659: ,x_fees_tbl => l_fees_tbl