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

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

Line 247: update lns_terms

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

Line 254: update lns_terms

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

Line 429: FROM LNS_TERMS

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

Line 2073: ,lns_terms t

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

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

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

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

7624: || Parameter: loan_id
7625: ||
7626: || Return value: table of dates
7627: ||
7628: || Source Tables: LNS_LOAN_HEADER, LNS_TERMS, LNS_AMORTIZATION_SCHEDS
7629: ||
7630: || Target Tables: NA
7631: ||
7632: || KNOWN ISSUES

Line 7732: ,lns_terms t

7728: ,nvl(t.CALC_ADD_INT_UNPAID_INT, 'N')
7729: ,nvl(t.CAPITALIZE_INT, 'N')
7730: ,nvl(t.FLUCTUATE_EQ_PAY_AMOUNT, 'N')
7731: FROM lns_loan_headers_all h
7732: ,lns_terms t
7733: ,fnd_currencies curr
7734: WHERE h.loan_id = p_loan_id
7735: AND t.loan_id = h.loan_id
7736: AND curr.currency_code = h.loan_currency;

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

7736: AND curr.currency_code = h.loan_currency;
7737:
7738: -- get reamortization information
7739: -- this is temporary place on LNS_AMORTIZATION_SCHEDS
7740: -- we should move this to LNS_TERMS when we have terms realignment
7741: -- bug# 5664316 - we only store ONE reamortization row
7742: CURSOR c_reamortization(p_Loan_id NUMBER) IS
7743: SELECT nvl(reamortization_amount, 0)
7744: ,nvl(reamortize_from_installment, 0)

Line 8106: || LNS_TERMS

8102: ||
8103: || Parameter: p_loan_id = loan_id
8104: ||
8105: || Source Tables: LNS_LOAN_HEADERS_ALL, LNS_DISB_HEADERS
8106: || LNS_TERMS
8107: ||
8108: || Target Tables: LNS_LOAN_HEADERS_ALL, LNS_TERMS
8109: ||
8110: || Return value: Standard Oracle API

Line 8108: || Target Tables: LNS_LOAN_HEADERS_ALL, LNS_TERMS

8104: ||
8105: || Source Tables: LNS_LOAN_HEADERS_ALL, LNS_DISB_HEADERS
8106: || LNS_TERMS
8107: ||
8108: || Target Tables: LNS_LOAN_HEADERS_ALL, LNS_TERMS
8109: ||
8110: || Return value: Standard Oracle API
8111: ||
8112: || MODIFICATION HISTORY

Line 8147: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;

8143: l_msg_count NUMBER;
8144: l_msg_data VARCHAR2(32767);
8145: l_loan_details LOAN_DETAILS_REC;
8146: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
8147: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;
8148: l_version_number number;
8149: l_terms_version_number number;
8150: l_dates_shifted_flag varchar2(1) := 'N';
8151:

Line 8178: from lns_terms t

8174: ,h.OBJECT_VERSION_NUMBER
8175: ,t.object_VERSION_NUMBER
8176: ,t.term_id
8177: ,h.current_phase
8178: from lns_terms t
8179: ,lns_loan_headers h
8180: where h.loan_id = p_loan_id
8181: and h.loan_id = t.loan_id;
8182:

Line 8297: lns_terms_pub.update_term(p_object_version_number => l_terms_version_number

8293: l_term_rec.PRIN_FIRST_PAY_DATE := l_loan_details.PRIN_FIRST_PAY_DATE;
8294: l_term_rec.NEXT_PAYMENT_DUE_DATE := l_loan_details.first_payment_Date;
8295: l_loan_header_rec.loan_maturity_date := l_loan_details.maturity_date;
8296: l_loan_header_rec.loan_start_date := l_loan_details.loan_start_date;
8297: lns_terms_pub.update_term(p_object_version_number => l_terms_version_number
8298: ,p_init_msg_list => fnd_api.g_false
8299: ,p_loan_term_rec => l_term_rec
8300: ,x_return_status => l_return_status
8301: ,x_msg_count => l_msg_count

Line 9963: lns_terms t,

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

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

10157: || Parameter: loan_id
10158: ||
10159: || Return value: Amount Or BALANCE on loan
10160: ||
10161: || Source Tables: LNS_TERMS, LNS_LOAN_HEADER, LNS_AMORTIZATION_SCHEDS
10162: ||
10163: || Target Tables: NA
10164: ||
10165: || KNOWN ISSUES

Line 11343: lns_terms term

11339:
11340: cursor c_add_int_setting(p_loan_id number, p_target varchar2) is
11341: select decode(p_target, 'UNPAID_PRIN', nvl(term.CALC_ADD_INT_UNPAID_PRIN, 'Y'), 'UNPAID_INT', nvl(term.CALC_ADD_INT_UNPAID_INT, 'Y'))
11342: from lns_loan_headers loan,
11343: lns_terms term
11344: where loan.loan_id = p_loan_id and
11345: loan.loan_id = term.loan_id;
11346:
11347: cursor c_curr_precision(p_loan_id number) is

Line 12219: lns_terms term

12215:
12216: cursor c_early_payment_setting(p_loan_id number) is
12217: select nvl(term.CALC_EARLY_PAY_CR, 'N')
12218: from lns_loan_headers loan,
12219: lns_terms term
12220: where loan.loan_id = p_loan_id and
12221: loan.loan_id = term.loan_id;
12222:
12223: cursor c_curr_precision(p_loan_id number) is