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.

[Home] [Help]

APPS.LNS_BILLING_BATCH_PUB dependencies on LNS_TERMS

Line 3576: 'lns_terms terms, ' ||

3572: 'lns_loan_types_vl loan_type, ' ||
3573: 'lns_lookups loan_class, ' ||
3574: 'lns_lookups periodlkup, ' ||
3575: 'lns_lookups loan_subtype, ' ||
3576: 'lns_terms terms, ' ||
3577: 'lns_int_rate_headers_vl int_rate_hdr, ' ||
3578: 'lns_lookups rate_type, ' ||
3579: 'lns_lookups rate_freq, ' ||
3580: 'lns_lookups pay_freq, ' ||

Line 3901: ,lns_terms t

3897: /*
3898: cursor cur_floating(p_loan_id number, p_phase varchar2, p_installment number) is
3899: select nvl(floating_flag, 'N')
3900: from lns_rate_schedules rs
3901: ,lns_terms t
3902: where t.loan_id = p_loan_id
3903: and t.term_id = rs.term_id
3904: and rs.end_date_active is null
3905: and rs.phase = p_phase

Line 4480: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;

4476: l_start date;
4477:
4478: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
4479: l_amortization_rec lns_financials.AMORTIZATION_REC;
4480: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;
4481:
4482: /*-----------------------------------------------------------------------+
4483: | Cursor Declarations |
4484: +-----------------------------------------------------------------------*/

Line 4489: from LNS_TERMS

4485:
4486: CURSOR term_version_cur(P_LOAN_ID number) IS
4487: select TERM_ID,
4488: OBJECT_VERSION_NUMBER
4489: from LNS_TERMS
4490: where LOAN_ID = P_LOAN_ID;
4491:
4492: /* get loan current phase */
4493: CURSOR loan_cur_phase_cur(P_LOAN_ID number) IS

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

4607: fetch term_version_cur into l_term_id, l_version_number;
4608: close term_version_cur;
4609:
4610: /* Updating terms */
4611: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_terms w following values:');
4612:
4613: l_term_rec.TERM_ID := l_term_id;
4614: l_term_rec.LOAN_ID := P_LOAN_NEXT_DD_REC.LOAN_ID;
4615:

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

4620: l_term_rec.OPEN_NEXT_PAYMENT_DATE := l_next_payment_due_date;
4621: LogMessage(FND_LOG.LEVEL_STATEMENT, 'OPEN_NEXT_PAYMENT_DATE: ' || l_term_rec.OPEN_NEXT_PAYMENT_DATE);
4622: end if;
4623:
4624: LNS_TERMS_PUB.update_term(P_OBJECT_VERSION_NUMBER => l_version_number,
4625: p_init_msg_list => FND_API.G_FALSE,
4626: p_loan_term_rec => l_term_rec,
4627: X_RETURN_STATUS => l_return_status,
4628: X_MSG_COUNT => l_msg_count,

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

4630:
4631: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
4632:
4633: IF l_return_status = 'S' THEN
4634: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_TERMS');
4635: ELSE
4636: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));
4637: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
4638: FND_MSG_PUB.Add;

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

4632:
4633: IF l_return_status = 'S' THEN
4634: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_TERMS');
4635: ELSE
4636: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_TERMS_PUB.update_term returned error: ' || substr(l_msg_data,1,225));
4637: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_TERM_FAIL');
4638: FND_MSG_PUB.Add;
4639: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));
4640: RAISE FND_API.G_EXC_ERROR;

Line 5351: LNS_TERMS term

5347: nvl(head.FORGIVENESS_FLAG, 'N'),
5348: nvl(head.FORGIVENESS_PERCENT, 0),
5349: nvl(head.DISABLE_BILLING_FLAG, 'N')
5350: from LNS_LOAN_HEADERS_VL head,
5351: LNS_TERMS term
5352: where head.LOAN_STATUS in ('ACTIVE', 'DEFAULT', 'DELINQUENT')
5353: and head.loan_id = term.loan_id
5354: and LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) < LNS_FIN_UTILS.getNumberInstallments(head.LOAN_ID, nvl(head.current_phase, 'TERM'))
5355: and (head.BILLED_FLAG is null or head.BILLED_FLAG = 'N')

Line 5739: LNS_TERMS term

5735: head.OBJECT_VERSION_NUMBER,
5736: LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) + 1,
5737: head.CUSTOM_PAYMENTS_FLAG
5738: from LNS_LOAN_HEADERS head,
5739: LNS_TERMS term
5740: where head.LOAN_STATUS in ('ACTIVE', 'DEFAULT', 'DELINQUENT')
5741: and head.loan_id = term.loan_id
5742: and (head.BILLED_FLAG = 'Y' or head.BILLED_FLAG is null) -- scherkas; fix for bug 5687852
5743: and LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) < LNS_FIN_UTILS.getNumberInstallments(head.LOAN_ID, nvl(head.current_phase, 'TERM'))

Line 5983: from LNS_TERMS

5979: where LOAN_ID = P_LOAN_ID;
5980:
5981: CURSOR terms_cur(P_LOAN_ID number) IS
5982: select rate_type
5983: from LNS_TERMS
5984: where LOAN_ID = P_LOAN_ID;
5985:
5986: BEGIN
5987:

Line 6668: LNS_TERMS term,

6664: nvl(head.FORGIVENESS_FLAG, 'N'),
6665: nvl(head.FORGIVENESS_PERCENT, 0),
6666: decode(am.AMORTIZATION_SCHEDULE_ID, null, head.FUNDED_AMOUNT, am.FUNDED_AMOUNT)
6667: from LNS_LOAN_HEADERS_VL head,
6668: LNS_TERMS term,
6669: LNS_AMORTIZATION_SCHEDS am
6670: where head.LOAN_ID = P_LOAN_ID
6671: -- Bug#6830765 - Enable billing for all loan status, used in Application fee 'SubmitForApproval Fee'
6672: -- and head.LOAN_STATUS in ('ACTIVE', 'DEFAULT', 'DELINQUENT')

Line 9081: LNS_TERMS term

9077: nvl(head.FORGIVENESS_FLAG, 'N'),
9078: nvl(head.FORGIVENESS_PERCENT, 0),
9079: nvl(head.CURRENT_PHASE,'TERM')
9080: from LNS_LOAN_HEADERS_ALL_VL head,
9081: LNS_TERMS term
9082: where head.loan_id = term.loan_id
9083: and head.LOAN_ID = P_LOAN_ID;
9084:
9085: CURSOR get_last_am_cur(P_LOAN_ID number) IS

Line 9357: from lns_terms

9353:
9354: -- get payment application order
9355: CURSOR order_cur(P_LOAN_ID number) IS
9356: select PAYMENT_APPLICATION_ORDER
9357: from lns_terms
9358: where loan_id = P_LOAN_ID;
9359:
9360: -- fetching open invoices in payment order
9361: CURSOR invoices_cur(P_LOAN_ID number, P_AMORTIZATION_SCHED_ID number, P_INVOICE_TYPE varchar2) IS

Line 9821: LNS_TERMS term

9817: head.OBJECT_VERSION_NUMBER,
9818: LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) + 1,
9819: head.CUSTOM_PAYMENTS_FLAG
9820: from LNS_LOAN_HEADERS head,
9821: LNS_TERMS term
9822: where head.LOAN_STATUS in ('ACTIVE', 'DEFAULT', 'DELINQUENT')
9823: and head.loan_id = term.loan_id
9824: and (head.BILLED_FLAG = 'Y' or head.BILLED_FLAG is null)
9825: and nvl(head.LAST_PAYMENT_NUMBER, 0) < (select max(END_INSTALLMENT_NUMBER) from lns_rate_schedules

Line 9833: LNS_TERMS term

9829:
9830: CURSOR can_bill_cur(P_LOAN_ID NUMBER) IS
9831: select 'x'
9832: from LNS_LOAN_HEADERS head,
9833: LNS_TERMS term
9834: where head.LOAN_STATUS in ('ACTIVE', 'DEFAULT', 'DELINQUENT')
9835: and head.loan_id = term.loan_id
9836: and (head.BILLED_FLAG is null or head.BILLED_FLAG = 'N')
9837: and nvl(head.LAST_PAYMENT_NUMBER, 0) < (select max(END_INSTALLMENT_NUMBER) from lns_rate_schedules