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_BILLING_BATCH_PUB dependencies on LNS_TERMS

Line 3303: 'lns_terms terms, ' ||

3299: 'lns_loan_types_vl loan_type, ' ||
3300: 'lns_lookups loan_class, ' ||
3301: 'lns_lookups periodlkup, ' ||
3302: 'lns_lookups loan_subtype, ' ||
3303: 'lns_terms terms, ' ||
3304: 'lns_int_rate_headers int_rate_hdr, ' ||
3305: 'lns_lookups rate_type, ' ||
3306: 'lns_lookups rate_freq, ' ||
3307: 'lns_lookups pay_freq, ' ||

Line 3579: ,lns_terms t

3575:
3576: cursor cur_floating(p_loan_id number, p_phase varchar2, p_installment number) is
3577: select nvl(floating_flag, 'N')
3578: from lns_rate_schedules rs
3579: ,lns_terms t
3580: where t.loan_id = p_loan_id
3581: and t.term_id = rs.term_id
3582: and rs.end_date_active is null
3583: and rs.phase = p_phase

Line 4163: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;

4159: l_start date;
4160:
4161: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
4162: l_amortization_rec lns_financials.AMORTIZATION_REC;
4163: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;
4164:
4165: /*-----------------------------------------------------------------------+
4166: | Cursor Declarations |
4167: +-----------------------------------------------------------------------*/

Line 4172: from LNS_TERMS

4168:
4169: CURSOR term_version_cur(P_LOAN_ID number) IS
4170: select TERM_ID,
4171: OBJECT_VERSION_NUMBER
4172: from LNS_TERMS
4173: where LOAN_ID = P_LOAN_ID;
4174:
4175: /* get loan current phase */
4176: CURSOR loan_cur_phase_cur(P_LOAN_ID number) IS

Line 4294: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_terms w following values:');

4290: fetch term_version_cur into l_term_id, l_version_number;
4291: close term_version_cur;
4292:
4293: /* Updating terms */
4294: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_terms w following values:');
4295:
4296: l_term_rec.TERM_ID := l_term_id;
4297: l_term_rec.LOAN_ID := P_LOAN_NEXT_DD_REC.LOAN_ID;
4298:

Line 4307: LNS_TERMS_PUB.update_term(P_OBJECT_VERSION_NUMBER => l_version_number,

4303: l_term_rec.OPEN_NEXT_PAYMENT_DATE := l_next_payment_due_date;
4304: LogMessage(FND_LOG.LEVEL_STATEMENT, 'OPEN_NEXT_PAYMENT_DATE: ' || l_term_rec.OPEN_NEXT_PAYMENT_DATE);
4305: end if;
4306:
4307: LNS_TERMS_PUB.update_term(P_OBJECT_VERSION_NUMBER => l_version_number,
4308: p_init_msg_list => FND_API.G_FALSE,
4309: p_loan_term_rec => l_term_rec,
4310: X_RETURN_STATUS => l_return_status,
4311: X_MSG_COUNT => l_msg_count,

Line 4317: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_TERMS');

4313:
4314: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
4315:
4316: IF l_return_status = 'S' THEN
4317: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_TERMS');
4318: ELSE
4319: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));
4320: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
4321: FND_MSG_PUB.Add;

Line 4319: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));

4315:
4316: IF l_return_status = 'S' THEN
4317: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_TERMS');
4318: ELSE
4319: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));
4320: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
4321: FND_MSG_PUB.Add;
4322: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
4323: RAISE FND_API.G_EXC_ERROR;

Line 4755: LNS_TERMS term

4751: nvl(head.CURRENT_PHASE, 'TERM'),
4752: nvl(head.FORGIVENESS_FLAG, 'N'),
4753: nvl(head.FORGIVENESS_PERCENT, 0)
4754: from LNS_LOAN_HEADERS head,
4755: LNS_TERMS term
4756: where head.LOAN_STATUS in ('ACTIVE', 'DEFAULT', 'DELINQUENT')
4757: and head.loan_id = term.loan_id
4758: and LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) < LNS_FIN_UTILS.getNumberInstallments(head.LOAN_ID, nvl(head.current_phase, 'TERM'))
4759: and (head.BILLED_FLAG is null or head.BILLED_FLAG = 'N')

Line 5125: LNS_TERMS term

5121: head.OBJECT_VERSION_NUMBER,
5122: LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) + 1,
5123: head.CUSTOM_PAYMENTS_FLAG
5124: from LNS_LOAN_HEADERS head,
5125: LNS_TERMS term
5126: where head.LOAN_STATUS in ('ACTIVE', 'DEFAULT', 'DELINQUENT')
5127: and head.loan_id = term.loan_id
5128: and (head.BILLED_FLAG = 'Y' or head.BILLED_FLAG is null) -- scherkas; fix for bug 5687852
5129: and LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) < LNS_FIN_UTILS.getNumberInstallments(head.LOAN_ID, nvl(head.current_phase, 'TERM'))

Line 5369: from LNS_TERMS

5365: where LOAN_ID = P_LOAN_ID;
5366:
5367: CURSOR terms_cur(P_LOAN_ID number) IS
5368: select rate_type
5369: from LNS_TERMS
5370: where LOAN_ID = P_LOAN_ID;
5371:
5372: BEGIN
5373:

Line 6044: LNS_TERMS term,

6040: nvl(head.CURRENT_PHASE, 'TERM'),
6041: nvl(head.FORGIVENESS_FLAG, 'N'),
6042: nvl(head.FORGIVENESS_PERCENT, 0)
6043: from LNS_LOAN_HEADERS head,
6044: LNS_TERMS term,
6045: LNS_AMORTIZATION_SCHEDS am
6046: where head.LOAN_STATUS in ('ACTIVE', 'DEFAULT', 'DELINQUENT')
6047: and head.LOAN_ID = P_LOAN_ID
6048: and head.loan_id = term.loan_id