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 165: || Target Tables: LNS_TERMS, LNS_RATE_SCHEDULES

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

Line 205: from lns_rate_schedules where rate_id = pRateId;

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

Line 261: -- 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

257: where loan_id = p_loan_id;
258: end if;
259:
260: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - updating the rate schedule ' || p_rate_id);
261: -- 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
262: open c_get_rate_sch_info(p_rate_id);
263: fetch c_get_rate_sch_info into l_begin_inst_num,l_end_inst_num;
264: close c_get_rate_sch_info;
265:

Line 270: update lns_rate_schedules

266: if (l_begin_inst_num = l_end_inst_num and l_begin_inst_num = p_installment_number) then
267: 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);
268:
269: -- update existing rate_schedule row
270: update lns_rate_schedules
271: set current_interest_rate = p_annualized_interest_rate
272: ,index_rate = p_annualized_interest_rate - nvl(spread,0)
273: where rate_id = p_rate_id;
274:

Line 277: update lns_rate_schedules

273: where rate_id = p_rate_id;
274:
275: else --else for if (l_begin_inst_num = l_end_inst_num = p_installment_number) then
276: 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');
277: update lns_rate_schedules
278: set begin_installment_number = begin_installment_number + 1
279: ,current_interest_rate = spread
280: ,index_rate = null
281: where rate_id = p_rate_id;

Line 283: select LNS_RATE_SCHEDULES_S.NEXTVAL into l_new_rate_id

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

Line 288: insert into lns_rate_schedules(RATE_ID

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

Line 327: from lns_rate_schedules

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

Line 339: update lns_rate_schedules

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

Line 2091: from lns_rate_schedules rs

2087:
2088: cursor c_rate_info(p_loan_id number) is
2089: select spread
2090: ,rate_id
2091: from lns_rate_schedules rs
2092: ,lns_terms t
2093: where t.loan_id = p_loan_id
2094: and t.term_id = rs.term_id
2095: and phase = 'OPEN';

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

5987: ||
5988: || Overview: procedure will run a loan projection ||
5989: || Parameter: loan_id
5990: ||
5991: || Source Tables: LNS_LOAN_HEADERS, LNS_TERMS, LNS_RATE_SCHEDULES,
5992: || LNS_DISB_HEADERS, LNS_DISB_LINES
5993: ||
5994: || Target Tables: None
5995: ||

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

6242: ||
6243: || Parameter: loan_id,
6244: || p_phase 'OPEN' or 'TERM'
6245: ||
6246: || Source Tables: LNS_RATE_SCHEDULES, LNS_TERMS, LNS_LOAN_HEADER_ALL
6247: ||
6248: || Target Tables: NA
6249: ||
6250: || Return value: rate_schedule_tbl which is defined as

Line 6297: lns_rate_schedules rs

6293: ,nvl(interest_only_flag, 'N')
6294: ,nvl(floating_flag, 'N')
6295: from lns_loan_headers_all h,
6296: lns_terms t,
6297: lns_rate_schedules rs
6298: where h.loan_id = p_loan_id
6299: and h.loan_id = t.loan_id
6300: and t.term_id = rs.term_id
6301: and rs.end_date_active is null

Line 6863: from lns_rate_schedules rs

6859: ,t.index_rate_id -- term_phase
6860: ,rs.index_date -- term_phase
6861: ,nvl(t.ceiling_rate, 100) -- term_phase
6862: ,nvl(t.floor_rate, 0) -- term_phase
6863: from lns_rate_schedules rs
6864: ,lns_terms t
6865: where t.loan_id = p_loan_id
6866: AND t.term_id = rs.term_id
6867: AND rs.phase = p_phase

Line 8870: || Source Tables: LNS_RATE_SCHEDULES

8866: || Parameter: loan_id
8867: ||
8868: || Return value: current annual rate for the loan
8869: ||
8870: || Source Tables: LNS_RATE_SCHEDULES
8871: ||
8872: || Target Tables: NA
8873: ||
8874: || KNOWN ISSUES

Line 8893: from lns_rate_schedules rs,

8889:
8890: -- logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
8891:
8892: select rs.current_interest_rate into l_rate
8893: from lns_rate_schedules rs,
8894: lns_terms t,
8895: lns_loan_headers_all h
8896: where h.loan_id = p_loan_id
8897: and h.loan_id = t.loan_id

Line 8929: || Source Tables: LNS_RATE_SCHEDULES,

8925: || Parameter: loan_id
8926: ||
8927: || Return value: current annual rate for the loan
8928: ||
8929: || Source Tables: LNS_RATE_SCHEDULES,
8930: ||
8931: || Target Tables: NA
8932: ||
8933: || KNOWN ISSUES