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_LOAN_HEADERS_ALL

Line 281: | This procedure stores last payment number and last amortization id in lns_loan_headers_all

277: /*========================================================================
278: | PRIVATE PROCEDURE STORE_LAST_PAYMENT_NUMBER
279: |
280: | DESCRIPTION
281: | This procedure stores last payment number and last amortization id in lns_loan_headers_all
282: |
283: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
284: |
285: | CALLS PROCEDURES/FUNCTIONS (local to this package body)

Line 418: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');

414:
415: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
416:
417: IF l_return_status = 'S' THEN
418: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
419: ELSE
420: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
421: FND_MSG_PUB.Add;
422: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 622: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');

618:
619: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
620:
621: IF l_return_status = 'S' THEN
622: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
623: ELSE
624: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
625: FND_MSG_PUB.Add;
626: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 795: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully updated LNS_LOAN_HEADERS_ALL');

791:
792: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
793:
794: IF l_return_status = 'S' THEN
795: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully updated LNS_LOAN_HEADERS_ALL');
796: ELSE
797: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
798: FND_MSG_PUB.Add;
799: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 3414: from lns_loan_headers_all loan

3410: +-----------------------------------------------------------------------*/
3411:
3412: CURSOR c_get_currency_format_mask(pLoanId Number) is
3413: select FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50) mask
3414: from lns_loan_headers_all loan
3415: where loan.loan_id = pLoanId;
3416:
3417: BEGIN
3418:

Line 3559: 'FROM lns_loan_headers_all_vl loan, ' ||

3555: 'payment_history.AMORTIZATION_SCHEDULE_ID < PAY_SUM.next_payment_amortization_id ' ||
3556: 'order by payment_history.AMORTIZATION_SCHEDULE_ID) ' ||
3557: 'AS Recent_Payment_History ' ||
3558:
3559: 'FROM lns_loan_headers_all_vl loan, ' ||
3560: 'hz_parties party, ' ||
3561: 'fnd_territories_tl terr, ' ||
3562: 'hr_all_organization_units_tl org, ' ||
3563: 'LNS_PAY_SUM_V PAY_SUM, ' ||

Line 4307: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');

4303:
4304: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
4305:
4306: IF l_return_status = 'S' THEN
4307: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
4308: ELSE
4309: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_LOAN_HEADER_PUB.UPDATE_LOAN returned error: ' || substr(l_msg_data,1,225));
4310: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
4311: FND_MSG_PUB.Add;

Line 4596: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');

4592:
4593: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
4594:
4595: IF l_return_status = 'S' THEN
4596: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
4597: ELSE
4598: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_LOAN_HEADER_PUB.UPDATE_LOAN returned error: ' || substr(l_msg_data,1,225));
4599: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
4600: FND_MSG_PUB.Add;

Line 7249: l_lns_status LNS_LOAN_HEADERS_ALL.loan_status%TYPE;

7245: l_TRX_NUMBER varchar2(20);
7246: l_ORG_ID number;
7247:
7248: l_reverse_tbl LNS_BILLING_BATCH_PUB.REVERSE_TBL;
7249: l_lns_status LNS_LOAN_HEADERS_ALL.loan_status%TYPE;
7250:
7251: /*-----------------------------------------------------------------------+
7252: | Cursor Declarations |
7253: +-----------------------------------------------------------------------*/

Line 8683: from lns_loan_headers_all

8679: +-----------------------------------------------------------------------*/
8680:
8681: cursor c_loanInfo(p_loan_id number) is
8682: select loan_number, LOAN_CURRENCY, nvl(EXCHANGE_RATE, 1), nvl(CURRENT_PHASE, 'TERM')
8683: from lns_loan_headers_all
8684: where loan_id = p_loan_id;
8685:
8686: /* query trx_type_id */
8687: CURSOR prin_trx_type_cur(P_LOAN_ID number) IS

Line 8689: from LNS_LOAN_HEADERS_ALL

8685:
8686: /* query trx_type_id */
8687: CURSOR prin_trx_type_cur(P_LOAN_ID number) IS
8688: select REFERENCE_TYPE_ID
8689: from LNS_LOAN_HEADERS_ALL
8690: where loan_id = P_LOAN_ID;
8691:
8692: CURSOR trx_type_cur(p_trx_type_id number) IS
8693: select NAME

Line 9080: from LNS_LOAN_HEADERS_ALL_VL head,

9076: head.EXCHANGE_RATE,
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:

Line 9087: from LNS_LOAN_HEADERS_all loan

9083: and head.LOAN_ID = P_LOAN_ID;
9084:
9085: CURSOR get_last_am_cur(P_LOAN_ID number) IS
9086: select loan.LAST_AMORTIZATION_ID
9087: from LNS_LOAN_HEADERS_all loan
9088: where loan.loan_id = P_LOAN_ID;
9089:
9090: BEGIN
9091:

Line 10205: from LNS_LOAN_HEADERS_all loan

10201: +-----------------------------------------------------------------------*/
10202:
10203: CURSOR get_last_am_cur(P_LOAN_ID number) IS
10204: select loan.LAST_AMORTIZATION_ID
10205: from LNS_LOAN_HEADERS_all loan
10206: where loan.loan_id = P_LOAN_ID;
10207:
10208: CURSOR get_new_am_cur(P_LOAN_ID number, P_LAST_AM_SCHED number) IS
10209: select AMORTIZATION_SCHEDULE_ID

Line 10798: FROM LNS_LOAN_HEADERS_ALL head

10794: +-----------------------------------------------------------------------*/
10795:
10796: CURSOR cur_disable_bill(C_LOAN_ID NUMBER) IS
10797: SELECT head.DISABLE_BILLING_FLAG
10798: FROM LNS_LOAN_HEADERS_ALL head
10799: where head.loan_id = C_LOAN_ID;
10800: BEGIN
10801:
10802: --LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' +');