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

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

269: /*========================================================================
270: | PRIVATE PROCEDURE STORE_LAST_PAYMENT_NUMBER
271: |
272: | DESCRIPTION
273: | This procedure stores last payment number and last amortization id in lns_loan_headers_all
274: |
275: | CALLED FROM PROCEDURES/FUNCTIONS (local to this package body)
276: |
277: | CALLS PROCEDURES/FUNCTIONS (local to this package body)

Line 331: LNS_LOAN_HEADERS head

327: head.LAST_PAYMENT_NUMBER,
328: head.LAST_AMORTIZATION_ID,
329: nvl(head.CURRENT_PHASE, 'TERM')
330: from
331: LNS_LOAN_HEADERS head
332: where
333: head.loan_id = P_LOAN_ID;
334:
335: CURSOR pay_number_cur(P_LOAN_ID NUMBER, P_PHASE VARCHAR2) IS

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

406:
407: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
408:
409: IF l_return_status = 'S' THEN
410: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
411: ELSE
412: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
413: FND_MSG_PUB.Add;
414: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 502: LNS_LOAN_HEADERS head

498: head.loan_id,
499: head.loan_number
500: from
501: LNS_PAY_SUM_V sum,
502: LNS_LOAN_HEADERS head
503: where
504: head.loan_id = nvl(P_LOAN_ID, head.loan_id) and
505: head.loan_id = sum.loan_id and
506: --karamach --Bug5295446

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

611:
612: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
613:
614: IF l_return_status = 'S' THEN
615: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
616: ELSE
617: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
618: FND_MSG_PUB.Add;
619: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 740: LNS_LOAN_HEADERS head

736: head.OBJECT_VERSION_NUMBER,
737: head.loan_id,
738: head.loan_number
739: from
740: LNS_LOAN_HEADERS head
741: where
742: head.loan_status = 'PAIDOFF' and
743: ((select nvl(sum(total_remaining_amount),0)
744: from LNS_AM_SCHEDS_V

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

784:
785: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
786:
787: IF l_return_status = 'S' THEN
788: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully updated LNS_LOAN_HEADERS_ALL');
789: ELSE
790: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
791: FND_MSG_PUB.Add;
792: LogMessage(FND_LOG.LEVEL_ERROR, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 1172: from LNS_LOAN_HEADERS

1168:
1169: /* query trx_type_id */
1170: CURSOR trx_type_cur(P_LOAN_ID number) IS
1171: select REFERENCE_TYPE_ID
1172: from LNS_LOAN_HEADERS
1173: where loan_id = P_LOAN_ID;
1174:
1175: /* query for site_use_id */
1176: CURSOR site_use_id_cur(P_SITE_ID number) IS

Line 2870: from lns_loan_headers loan,

2866: to_char(P_PRIN_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
2867: to_char(P_INT_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
2868: to_char(P_FEE_AMOUNT_DUE, FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50)),
2869: to_char((P_PRIN_AMOUNT_DUE + P_INT_AMOUNT_DUE + P_FEE_AMOUNT_DUE), FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50))
2870: from lns_loan_headers loan,
2871: hz_parties party
2872: where party.party_id = loan.PRIMARY_BORROWER_ID and
2873: loan.loan_id = P_LOAN_ID;
2874:

Line 3001: select loan_number from lns_loan_headers where loan_id = P_LOAN_ID;

2997: select party_name from hz_parties party where party_id = P_BORROWER_ID;
2998:
2999: /* query for loan number */
3000: CURSOR loan_cur(P_LOAN_ID number) IS
3001: select loan_number from lns_loan_headers where loan_id = P_LOAN_ID;
3002:
3003: /* query for org name */
3004: CURSOR org_cur(P_ORG_ID number) IS
3005: select name

Line 3149: from lns_loan_headers_all loan

3145: +-----------------------------------------------------------------------*/
3146:
3147: CURSOR c_get_currency_format_mask(pLoanId Number) is
3148: select FND_CURRENCY.SAFE_GET_FORMAT_MASK(loan.LOAN_CURRENCY,50) mask
3149: from lns_loan_headers_all loan
3150: where loan.loan_id = pLoanId;
3151:
3152: BEGIN
3153:

Line 3288: 'FROM lns_loan_headers_all loan, ' ||

3284: 'payment_history.AMORTIZATION_SCHEDULE_ID < payment_summary.next_payment_amortization_id ' ||
3285: 'order by payment_history.AMORTIZATION_SCHEDULE_ID) ' ||
3286: 'AS Recent_Payment_History ' ||
3287:
3288: 'FROM lns_loan_headers_all loan, ' ||
3289: 'hz_parties party, ' ||
3290: 'fnd_territories_tl terr, ' ||
3291: 'hr_all_organization_units_tl org, ' ||
3292: 'LNS_PAYMENTS_SUMMARY_V payment_summary, ' ||

Line 3450: lns_loan_headers head

3446: CURSOR verify_amount_cur(P_LOAN_ID number) IS
3447: select max(head.funded_amount) - nvl(sum(am.PRINCIPAL_AMOUNT), 0)
3448: from
3449: LNS_AMORTIZATION_SCHEDS am,
3450: lns_loan_headers head
3451: where
3452: head.loan_id = P_LOAN_ID
3453: and head.loan_id = am.LOAN_ID
3454: and (am.REVERSED_FLAG is null or am.REVERSED_FLAG = 'N')

Line 3563: from LNS_LOAN_HEADERS loan,

3559: );
3560: /* get statement after its billed */
3561: CURSOR get_statement_cur(P_LOAN_ID number) IS
3562: select STATEMENT_XML
3563: from LNS_LOAN_HEADERS loan,
3564: lns_amortization_scheds am
3565: where loan.loan_id = am.loan_id and
3566: am.AMORTIZATION_SCHEDULE_ID = loan.LAST_AMORTIZATION_ID and
3567: am.PAYMENT_NUMBER = loan.LAST_PAYMENT_NUMBER and

Line 3573: from LNS_LOAN_HEADERS

3569:
3570: -- getting loan version
3571: CURSOR loan_version_cur(P_LOAN_ID number) IS
3572: select OBJECT_VERSION_NUMBER
3573: from LNS_LOAN_HEADERS
3574: where LOAN_ID = P_LOAN_ID;
3575:
3576: cursor cur_floating(p_loan_id number, p_phase varchar2, p_installment number) is
3577: select nvl(floating_flag, 'N')

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

3986:
3987: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
3988:
3989: IF l_return_status = 'S' THEN
3990: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
3991: ELSE
3992: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_LOAN_HEADER_PUB.UPDATE_LOAN returned error: ' || substr(l_msg_data,1,225));
3993: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
3994: FND_MSG_PUB.Add;

Line 4178: from LNS_LOAN_HEADERS

4174:
4175: /* get loan current phase */
4176: CURSOR loan_cur_phase_cur(P_LOAN_ID number) IS
4177: select nvl(CURRENT_PHASE, 'TERM')
4178: from LNS_LOAN_HEADERS
4179: where LOAN_ID = P_LOAN_ID;
4180:
4181: BEGIN
4182:

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

4275:
4276: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
4277:
4278: IF l_return_status = 'S' THEN
4279: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
4280: ELSE
4281: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ERROR: LNS_LOAN_HEADER_PUB.UPDATE_LOAN returned error: ' || substr(l_msg_data,1,225));
4282: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
4283: FND_MSG_PUB.Add;

Line 4754: from LNS_LOAN_HEADERS head,

4750: head.LEGAL_ENTITY_ID,
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'))

Line 5124: from LNS_LOAN_HEADERS head,

5120: head.LOAN_NUMBER,
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

Line 5364: from LNS_LOAN_HEADERS

5360: select
5361: LOAN_NUMBER,
5362: OBJECT_VERSION_NUMBER,
5363: CUSTOM_PAYMENTS_FLAG
5364: from LNS_LOAN_HEADERS
5365: where LOAN_ID = P_LOAN_ID;
5366:
5367: CURSOR terms_cur(P_LOAN_ID number) IS
5368: select rate_type

Line 5785: from LNS_LOAN_HEADERS

5781: select
5782: LOAN_NUMBER,
5783: OBJECT_VERSION_NUMBER,
5784: CUSTOM_PAYMENTS_FLAG
5785: from LNS_LOAN_HEADERS
5786: where LOAN_ID = P_LOAN_ID;
5787:
5788: BEGIN
5789:

Line 6043: from LNS_LOAN_HEADERS head,

6039: head.FUNDED_AMOUNT,
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

Line 6954: from LNS_LOAN_HEADERS loan,

6950: trx.org_id,
6951: trx.legal_entity_id,
6952: lines.REC_ADJUSTMENT_ID,
6953: nvl(lines.installment_number, 1)
6954: from LNS_LOAN_HEADERS loan,
6955: RA_CUSTOMER_TRX trx,
6956: ar_payment_schedules psa,
6957: lns_loan_lines lines
6958: where loan.loan_id = P_LOAN_ID and

Line 7278: from LNS_LOAN_HEADERS

7274: /* querying loan number */
7275: CURSOR loan_cur(P_LOAN_ID number) IS
7276: select
7277: LOAN_NUMBER, nvl(CURRENT_PHASE, 'TERM')
7278: from LNS_LOAN_HEADERS
7279: where LOAN_ID = P_LOAN_ID;
7280:
7281: BEGIN
7282:

Line 7611: from LNS_LOAN_HEADERS loan,

7607: psa.GL_DATE,
7608: nvl(loan.CURRENT_PHASE, 'TERM'),
7609: psa.org_id,
7610: loan.LOAN_CURRENCY
7611: from LNS_LOAN_HEADERS loan,
7612: lns_amortization_scheds am,
7613: ar_payment_schedules psa
7614: where
7615: loan.loan_id = P_LOAN_ID and