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_TERMS

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 170: || -- POST PROCESSING STEPS recalculate and enter into LNS_TERMS

166: ||
167: || KNOWN ISSUES
168: ||
169: || NOTES
170: || -- POST PROCESSING STEPS recalculate and enter into LNS_TERMS
171: || -- 1. next_rate_change_date
172: || -- 2. new projected rate
173: || -- 3. re-align rate schedule
174: ||

Line 245: update lns_terms

241: ,p_direction => 1);
242: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - updating terms with new date ' || l_next_rate_change);
243: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - updating terms with new rate' || p_annualized_interest_rate);
244: if p_phase = 'OPEN' then
245: update lns_terms
246: set next_rate_change_date = l_next_rate_change
247: ,open_projected_rate = p_annualized_interest_rate
248: ,last_update_date = sysdate
249: ,last_updated_by = lns_utility_pub.user_id

Line 252: update lns_terms

248: ,last_update_date = sysdate
249: ,last_updated_by = lns_utility_pub.user_id
250: where loan_id = p_loan_id;
251: elsif p_phase = 'TERM' then
252: update lns_terms
253: set next_rate_change_date = l_next_rate_change
254: ,term_projected_rate = p_annualized_interest_rate
255: ,last_update_date = sysdate
256: ,last_updated_by = lns_utility_pub.user_id

Line 427: FROM LNS_TERMS

423: l_status varchar2(30);
424:
425: CURSOR c_terms(p_Loan_id NUMBER) IS
426: SELECT TERM_ID
427: FROM LNS_TERMS
428: WHERE LOAN_ID = p_Loan_id;
429:
430: BEGIN
431:

Line 2092: ,lns_terms t

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';
2096: begin

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 6296: lns_terms t,

6292: ,end_installment_number
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

Line 6751: || Source Tables: LNS_LOAN_HEADER, LNS_TERMS, LNS_AMORTIZATION_SCHEDS

6747: || Parameter: loan_id
6748: ||
6749: || Return value: table of dates
6750: ||
6751: || Source Tables: LNS_LOAN_HEADER, LNS_TERMS, LNS_AMORTIZATION_SCHEDS
6752: ||
6753: || Target Tables: NA
6754: ||
6755: || KNOWN ISSUES

Line 6848: ,lns_terms t

6844: ,decode(trunc(nvl(t.prin_first_pay_date, t.first_payment_date)) - trunc(h.loan_start_date), 0, 'N', 'Y') -- calculate in advance or arrears for principal
6845: ,nvl(t.PENAL_INT_RATE, 0)
6846: ,nvl(t.PENAL_INT_GRACE_DAYS, 0)
6847: FROM lns_loan_headers_all h
6848: ,lns_terms t
6849: ,fnd_currencies curr
6850: WHERE h.loan_id = p_loan_id
6851: AND t.loan_id = h.loan_id
6852: AND curr.currency_code = h.loan_currency;

Line 6864: ,lns_terms t

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
6868: AND rs.begin_installment_number = 1

Line 6874: -- we should move this to LNS_TERMS when we have terms realignment

6870: */
6871:
6872: -- get reamortization information
6873: -- this is temporary place on LNS_AMORTIZATION_SCHEDS
6874: -- we should move this to LNS_TERMS when we have terms realignment
6875: -- bug# 5664316 - we only store ONE reamortization row
6876: CURSOR c_reamortization(p_Loan_id NUMBER) IS
6877: SELECT nvl(reamortization_amount, 0)
6878: ,nvl(reamortize_from_installment, 0)

Line 7325: || LNS_TERMS

7321: ||
7322: || Parameter: p_loan_id = loan_id
7323: ||
7324: || Source Tables: LNS_LOAN_HEADERS_ALL, LNS_DISB_HEADERS
7325: || LNS_TERMS
7326: ||
7327: || Target Tables: LNS_LOAN_HEADERS_ALL, LNS_TERMS
7328: ||
7329: || Return value: Standard Oracle API

Line 7327: || Target Tables: LNS_LOAN_HEADERS_ALL, LNS_TERMS

7323: ||
7324: || Source Tables: LNS_LOAN_HEADERS_ALL, LNS_DISB_HEADERS
7325: || LNS_TERMS
7326: ||
7327: || Target Tables: LNS_LOAN_HEADERS_ALL, LNS_TERMS
7328: ||
7329: || Return value: Standard Oracle API
7330: ||
7331: || MODIFICATION HISTORY

Line 7366: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;

7362: l_msg_count NUMBER;
7363: l_msg_data VARCHAR2(32767);
7364: l_loan_details LOAN_DETAILS_REC;
7365: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
7366: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;
7367: l_version_number number;
7368: l_terms_version_number number;
7369: l_dates_shifted_flag varchar2(1) := 'N';
7370:

Line 7397: from lns_terms t

7393: ,h.OBJECT_VERSION_NUMBER
7394: ,t.object_VERSION_NUMBER
7395: ,t.term_id
7396: ,h.current_phase
7397: from lns_terms t
7398: ,lns_loan_headers h
7399: where h.loan_id = p_loan_id
7400: and h.loan_id = t.loan_id;
7401:

Line 7514: lns_terms_pub.update_term(p_object_version_number => l_terms_version_number

7510: l_term_rec.FIRST_PAYMENT_DATE := l_loan_details.first_payment_Date;
7511: l_term_rec.NEXT_PAYMENT_DUE_DATE := l_loan_details.first_payment_Date;
7512: l_loan_header_rec.loan_maturity_date := l_loan_details.maturity_date;
7513: l_loan_header_rec.loan_start_date := l_loan_details.loan_start_date;
7514: lns_terms_pub.update_term(p_object_version_number => l_terms_version_number
7515: ,p_init_msg_list => fnd_api.g_false
7516: ,p_loan_term_rec => l_term_rec
7517: ,x_return_status => l_return_status
7518: ,x_msg_count => l_msg_count

Line 8267: ,lns_terms t

8263: select nvl(h.current_phase, 'TERM')
8264: ,t.rate_type
8265: ,t.index_rate_id
8266: from lns_loan_headers h
8267: ,lns_terms t
8268: where h.loan_id = p_loan_id
8269: and t.loan_id = h.loan_id;
8270:
8271: cursor c_get_last_bill_date(p_loan_id number, p_installment_number number) is

Line 8894: lns_terms t,

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
8898: and rs.term_id = t.term_id

Line 9092: || Source Tables: LNS_TERMS, LNS_LOAN_HEADER, LNS_AMORTIZATION_SCHEDS

9088: || Parameter: loan_id
9089: ||
9090: || Return value: Amount Or BALANCE on loan
9091: ||
9092: || Source Tables: LNS_TERMS, LNS_LOAN_HEADER, LNS_AMORTIZATION_SCHEDS
9093: ||
9094: || Target Tables: NA
9095: ||
9096: || KNOWN ISSUES