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_FINANCIALS dependencies on LNS_RATE_SCHEDULES

Line 167: || Target Tables: LNS_TERMS, LNS_RATE_SCHEDULES

163: || Return value:
164: ||
165: || Source Tables:
166: ||
167: || Target Tables: LNS_TERMS, LNS_RATE_SCHEDULES
168: ||
169: || KNOWN ISSUES
170: ||
171: || NOTES

Line 207: from lns_rate_schedules where rate_id = pRateId;

203: l_msg_data VARCHAR2(32767);
204:
205: Cursor c_get_rate_sch_info(pRateId number) is
206: select begin_installment_number, end_installment_number
207: from lns_rate_schedules where rate_id = pRateId;
208: l_begin_inst_num number;
209: l_end_inst_num number;
210: BEGIN
211:

Line 263: -- store the row on lns_rate_schedules(only if the existing row does not have begin and end installment numbers same as this installment) and update existing rate_schedule row

259: where loan_id = p_loan_id;
260: end if;
261:
262: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - updating the rate schedule ' || p_rate_id);
263: -- store the row on lns_rate_schedules(only if the existing row does not have begin and end installment numbers same as this installment) and update existing rate_schedule row
264: open c_get_rate_sch_info(p_rate_id);
265: fetch c_get_rate_sch_info into l_begin_inst_num,l_end_inst_num;
266: close c_get_rate_sch_info;
267:

Line 272: update lns_rate_schedules

268: if (l_begin_inst_num = l_end_inst_num and l_begin_inst_num = p_installment_number) then
269: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' (l_begin_inst_num = l_end_inst_num = p_installment_number) - NO need to insert new row - updating the existing rate schedule ' || p_rate_id);
270:
271: -- update existing rate_schedule row
272: update lns_rate_schedules
273: set current_interest_rate = p_annualized_interest_rate
274: ,index_rate = p_annualized_interest_rate - nvl(spread,0)
275: where rate_id = p_rate_id;
276:

Line 279: update lns_rate_schedules

275: where rate_id = p_rate_id;
276:
277: else --else for if (l_begin_inst_num = l_end_inst_num = p_installment_number) then
278: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' update the existing row as the next row and insert new row for the current rate sch');
279: update lns_rate_schedules
280: set begin_installment_number = begin_installment_number + 1
281: ,current_interest_rate = spread
282: ,index_rate = null
283: where rate_id = p_rate_id;

Line 285: select LNS_RATE_SCHEDULES_S.NEXTVAL into l_new_rate_id

281: ,current_interest_rate = spread
282: ,index_rate = null
283: where rate_id = p_rate_id;
284:
285: select LNS_RATE_SCHEDULES_S.NEXTVAL into l_new_rate_id
286: from dual;
287:
288: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - adding new row into rate schedule');
289: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_new_rate_id ' || l_new_rate_id );

Line 290: insert into lns_rate_schedules(RATE_ID

286: from dual;
287:
288: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - adding new row into rate schedule');
289: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_new_rate_id ' || l_new_rate_id );
290: insert into lns_rate_schedules(RATE_ID
291: ,TERM_ID
292: ,INDEX_RATE
293: ,SPREAD
294: ,CURRENT_INTEREST_RATE

Line 329: from lns_rate_schedules

325: ,p_installment_number
326: ,INTEREST_ONLY_FLAG
327: ,FLOATING_FLAG
328: ,PHASE
329: from lns_rate_schedules
330: where rate_id = p_rate_id);
331:
332: -- assign new rate id for OUT parameter
333: p_rate_id := l_new_rate_id ;

Line 341: update lns_rate_schedules

337: else --else for if p_installment_number <> lns_fin_utils.getNumberInstallments(p_loan_id => p_loan_id
338:
339: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - updating the rate schedule LAST ROW ' || p_rate_id);
340: -- update existing rate_schedule row
341: update lns_rate_schedules
342: set current_interest_rate = p_annualized_interest_rate
343: ,index_rate = p_annualized_interest_rate - nvl(spread,0)
344: where rate_id = p_rate_id;
345:

Line 2072: from lns_rate_schedules rs

2068:
2069: cursor c_rate_info(p_loan_id number) is
2070: select spread
2071: ,rate_id
2072: from lns_rate_schedules rs
2073: ,lns_terms t
2074: where t.loan_id = p_loan_id
2075: and t.term_id = rs.term_id
2076: and phase = 'OPEN';

Line 6897: || Source Tables: LNS_LOAN_HEADERS, LNS_TERMS, LNS_RATE_SCHEDULES,

6893: ||
6894: || Overview: procedure will run a loan projection ||
6895: || Parameter: loan_id
6896: ||
6897: || Source Tables: LNS_LOAN_HEADERS, LNS_TERMS, LNS_RATE_SCHEDULES,
6898: || LNS_DISB_HEADERS, LNS_DISB_LINES
6899: ||
6900: || Target Tables: None
6901: ||

Line 7095: || Source Tables: LNS_RATE_SCHEDULES, LNS_TERMS, LNS_LOAN_HEADER_ALL

7091: ||
7092: || Parameter: loan_id,
7093: || p_phase 'OPEN' or 'TERM'
7094: ||
7095: || Source Tables: LNS_RATE_SCHEDULES, LNS_TERMS, LNS_LOAN_HEADER_ALL
7096: ||
7097: || Target Tables: NA
7098: ||
7099: || Return value: rate_schedule_tbl which is defined as

Line 7146: lns_rate_schedules rs

7142: ,nvl(interest_only_flag, 'N')
7143: ,nvl(floating_flag, 'N')
7144: from lns_loan_headers_all h,
7145: lns_terms t,
7146: lns_rate_schedules rs
7147: where h.loan_id = p_loan_id
7148: and h.loan_id = t.loan_id
7149: and t.term_id = rs.term_id
7150: and rs.end_date_active is null

Line 9939: || Source Tables: LNS_RATE_SCHEDULES

9935: || Parameter: loan_id
9936: ||
9937: || Return value: current annual rate for the loan
9938: ||
9939: || Source Tables: LNS_RATE_SCHEDULES
9940: ||
9941: || Target Tables: NA
9942: ||
9943: || KNOWN ISSUES

Line 9962: from lns_rate_schedules rs,

9958:
9959: -- logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
9960:
9961: select rs.current_interest_rate into l_rate
9962: from lns_rate_schedules rs,
9963: lns_terms t,
9964: lns_loan_headers_all h
9965: where h.loan_id = p_loan_id
9966: and h.loan_id = t.loan_id

Line 9998: || Source Tables: LNS_RATE_SCHEDULES,

9994: || Parameter: loan_id
9995: ||
9996: || Return value: current annual rate for the loan
9997: ||
9998: || Source Tables: LNS_RATE_SCHEDULES,
9999: ||
10000: || Target Tables: NA
10001: ||
10002: || KNOWN ISSUES