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_FIN_UTILS

Line 1380: function getPayment(P_LOAN_ID IN NUMBER, P_PAYMENT_NUMBER IN NUMBER) return LNS_FIN_UTILS.PAYMENT_SCHEDULE

1376:
1377:
1378: -- This function returns payment schedule record
1379: -- introduced for bug 7319358
1380: function getPayment(P_LOAN_ID IN NUMBER, P_PAYMENT_NUMBER IN NUMBER) return LNS_FIN_UTILS.PAYMENT_SCHEDULE
1381: IS
1382:
1383: /*-----------------------------------------------------------------------+
1384: | Local Variable Declarations and initializations |

Line 1388: l_payment_schedule LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;

1384: | Local Variable Declarations and initializations |
1385: +-----------------------------------------------------------------------*/
1386:
1387: l_api_name CONSTANT VARCHAR2(30) := 'getPayment';
1388: l_payment_schedule LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
1389: l_payment LNS_FIN_UTILS.PAYMENT_SCHEDULE;
1390: i number;
1391:
1392: /*-----------------------------------------------------------------------+

Line 1389: l_payment LNS_FIN_UTILS.PAYMENT_SCHEDULE;

1385: +-----------------------------------------------------------------------*/
1386:
1387: l_api_name CONSTANT VARCHAR2(30) := 'getPayment';
1388: l_payment_schedule LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
1389: l_payment LNS_FIN_UTILS.PAYMENT_SCHEDULE;
1390: i number;
1391:
1392: /*-----------------------------------------------------------------------+
1393: | Cursor Declarations |

Line 1471: ,nvl(lns_fin_utils.getActiveRate(h.loan_id), t.TERM_PROJECTED_RATE) LAST_INTEREST_RATE

1467: ,t.PERCENT_INCREASE_LIFE TERM_PERCENT_INCREASE_LIFE
1468: ,t.FIRST_PERCENT_INCREASE TERM_FIRST_PERCENT_INCREASE
1469: ,t.INDEX_RATE_ID TERM_INDEX_RATE_ID
1470: ,t.TERM_PROJECTED_RATE INITIAL_INTEREST_RATE
1471: ,nvl(lns_fin_utils.getActiveRate(h.loan_id), t.TERM_PROJECTED_RATE) LAST_INTEREST_RATE
1472: ,nvl(t.FIRST_RATE_CHANGE_DATE, t.NEXT_RATE_CHANGE_DATE) FIRST_RATE_CHANGE_DATE
1473: ,t.NEXT_RATE_CHANGE_DATE NEXT_RATE_CHANGE_DATE
1474: ,t.TERM_PROJECTED_RATE TERM_PROJECTED_RATE
1475: ,nvl(t.PENAL_INT_RATE, 0)

Line 1954: l_payment LNS_FIN_UTILS.PAYMENT_SCHEDULE;

1950: l_penal_prin_interest number;
1951: l_penal_int_interest number;
1952: l_penal_interest number;
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;

Line 2304: l_rate_details.ANNUAL_RATE := lns_fin_utils.getRateForDate(l_loan_details.TERM_INDEX_RATE_ID

2300: if P_BASED_ON_TERMS = 'CURRENT' then
2301:
2302: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': FLOATING RECALCULATE');
2303:
2304: l_rate_details.ANNUAL_RATE := lns_fin_utils.getRateForDate(l_loan_details.TERM_INDEX_RATE_ID
2305: ,l_period_begin_date);
2306:
2307: -- raise error as rates does not exist
2308: if l_rate_details.ANNUAL_RATE is null then

Line 2534: l_rate_to_calculate := lns_fin_utils.convertRate(p_annualized_rate => l_annualized_rate

2530: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calculating periodic_payment...');
2531:
2532: if (l_calc_method = 'SIMPLE') then
2533:
2534: l_rate_to_calculate := lns_fin_utils.convertRate(p_annualized_rate => l_annualized_rate
2535: ,p_amortization_frequency => l_payment_freq);
2536:
2537: elsif (l_calc_method = 'COMPOUND') then
2538:

Line 3246: l_num_installments := LNS_FIN_UTILS.getNumberInstallments(p_loan_id);

3242: RAISE FND_API.G_EXC_ERROR;
3243: END IF;
3244:
3245: -- synching rate schedule
3246: l_num_installments := LNS_FIN_UTILS.getNumberInstallments(p_loan_id);
3247: synchRateSchedule(l_term_id, l_num_installments);
3248: */
3249: else
3250: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Nothing to update');

Line 3824: -- This procedure builds custom payment schedule and returns LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL table

3820: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, 'Rollbacked');
3821: END;
3822:
3823:
3824: -- This procedure builds custom payment schedule and returns LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL table
3825: function buildCustomPaySchedule(P_LOAN_ID IN NUMBER) return LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL
3826: IS
3827:
3828: /*-----------------------------------------------------------------------+

Line 3825: function buildCustomPaySchedule(P_LOAN_ID IN NUMBER) return LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL

3821: END;
3822:
3823:
3824: -- This procedure builds custom payment schedule and returns LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL table
3825: function buildCustomPaySchedule(P_LOAN_ID IN NUMBER) return LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL
3826: IS
3827:
3828: /*-----------------------------------------------------------------------+
3829: | Local Variable Declarations and initializations |

Line 3833: l_payment_schedule LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;

3829: | Local Variable Declarations and initializations |
3830: +-----------------------------------------------------------------------*/
3831:
3832: l_api_name CONSTANT VARCHAR2(30) := 'buildCustomPaySchedule';
3833: l_payment_schedule LNS_FIN_UTILS.PAYMENT_SCHEDULE_TBL;
3834: l_loan_details LNS_CUSTOM_PUB.LOAN_DETAILS_REC;
3835: l_due_date date;
3836: l_payment_number number;
3837: i number;