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_AMORTIZATION_SCHEDS

Line 337: from LNS_AMORTIZATION_SCHEDS

333: head.loan_id = P_LOAN_ID;
334:
335: CURSOR pay_number_cur(P_LOAN_ID NUMBER, P_PHASE VARCHAR2) IS
336: select max(PAYMENT_NUMBER)
337: from LNS_AMORTIZATION_SCHEDS
338: where LOAN_ID = P_LOAN_ID
339: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N')
340: and REAMORTIZATION_AMOUNT is null
341: and nvl(PHASE, 'TERM') = nvl(P_PHASE, 'TERM');

Line 345: from LNS_AMORTIZATION_SCHEDS

341: and nvl(PHASE, 'TERM') = nvl(P_PHASE, 'TERM');
342:
343: CURSOR amortization_cur(P_LOAN_ID NUMBER, P_PHASE VARCHAR2) IS
344: select max(AMORTIZATION_SCHEDULE_ID)
345: from LNS_AMORTIZATION_SCHEDS
346: where LOAN_ID = P_LOAN_ID
347: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N')
348: and nvl(PHASE, 'TERM') = nvl(P_PHASE, 'TERM')
349: and PAYMENT_NUMBER =

Line 351: from LNS_AMORTIZATION_SCHEDS

347: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N')
348: and nvl(PHASE, 'TERM') = nvl(P_PHASE, 'TERM')
349: and PAYMENT_NUMBER =
350: nvl((select max(PAYMENT_NUMBER)
351: from LNS_AMORTIZATION_SCHEDS
352: where LOAN_ID = P_LOAN_ID
353: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N')
354: and REAMORTIZATION_AMOUNT is null
355: and nvl(PHASE, 'TERM') = nvl(P_PHASE, 'TERM')), 0);

Line 2224: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_AMORTIZATION_SCHEDS with new trx ids:');

2220: end if;
2221:
2222: /* Update amortization table with new principal, interest and fee ids */
2223:
2224: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_AMORTIZATION_SCHEDS with new trx ids:');
2225: LogMessage(FND_LOG.LEVEL_STATEMENT, 'principal_trx_id: ' || l_principal_trx_id);
2226: LogMessage(FND_LOG.LEVEL_STATEMENT, 'interest_trx_id: ' || l_interest_trx_id);
2227: LogMessage(FND_LOG.LEVEL_STATEMENT, 'fee_trx_id: ' || l_fee_trx_id);
2228:

Line 2229: LNS_AMORTIZATION_SCHEDS_PKG.Update_Row(

2225: LogMessage(FND_LOG.LEVEL_STATEMENT, 'principal_trx_id: ' || l_principal_trx_id);
2226: LogMessage(FND_LOG.LEVEL_STATEMENT, 'interest_trx_id: ' || l_interest_trx_id);
2227: LogMessage(FND_LOG.LEVEL_STATEMENT, 'fee_trx_id: ' || l_fee_trx_id);
2228:
2229: LNS_AMORTIZATION_SCHEDS_PKG.Update_Row(
2230: P_AMORTIZATION_SCHEDULE_ID => P_LOAN_REC.NEXT_AMORTIZATION_ID
2231: ,P_PRINCIPAL_TRX_ID => l_principal_trx_id
2232: ,P_INTEREST_TRX_ID => l_interest_trx_id
2233: ,P_FEE_TRX_ID => l_fee_trx_id);

Line 3293: 'lns_amortization_scheds am, ' ||

3289: 'hz_parties party, ' ||
3290: 'fnd_territories_tl terr, ' ||
3291: 'hr_all_organization_units_tl org, ' ||
3292: 'LNS_PAYMENTS_SUMMARY_V payment_summary, ' ||
3293: 'lns_amortization_scheds am, ' ||
3294: 'hz_locations loc, ' ||
3295: 'hz_cust_acct_sites_all acct_site, ' ||
3296: 'hz_party_sites site, ' ||
3297: 'fnd_currencies_tl curr, ' ||

Line 3405: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating record in LNS_AMORTIZATION_SCHEDS...') ;

3401:
3402: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Generated billing statement');
3403:
3404: /* Update amortization table */
3405: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating record in LNS_AMORTIZATION_SCHEDS...') ;
3406:
3407: LNS_AMORTIZATION_SCHEDS_PKG.Update_Statement(
3408: P_AMORTIZATION_SCHEDULE_ID => p_amortization_schedule_id
3409: ,P_STATEMENT_XML => result);

Line 3407: LNS_AMORTIZATION_SCHEDS_PKG.Update_Statement(

3403:
3404: /* Update amortization table */
3405: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating record in LNS_AMORTIZATION_SCHEDS...') ;
3406:
3407: LNS_AMORTIZATION_SCHEDS_PKG.Update_Statement(
3408: P_AMORTIZATION_SCHEDULE_ID => p_amortization_schedule_id
3409: ,P_STATEMENT_XML => result);
3410:
3411: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Update successfull!');

Line 3449: LNS_AMORTIZATION_SCHEDS am,

3445:
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

Line 3564: lns_amortization_scheds am

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
3568: loan.loan_id = P_LOAN_ID;

Line 3926: /* inserting new record into LNS_AMORTIZATION_SCHEDS */

3922:
3923: /* late date */
3924: P_LOAN_REC.NEXT_PAYMENT_LATE_DATE := P_LOAN_REC.NEXT_PAYMENT_DUE_DATE + nvl(P_LOAN_REC.NUMBER_GRACE_DAYS, 0);
3925:
3926: /* inserting new record into LNS_AMORTIZATION_SCHEDS */
3927: l_prin_balance := null;
3928: if P_LOAN_REC.CURRENT_PHASE is not null and P_LOAN_REC.CURRENT_PHASE = 'OPEN' then
3929: l_prin_balance := P_LOAN_REC.FUNDED_AMOUNT;
3930: end if;

Line 3932: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting new record into LNS_AMORTIZATION_SCHEDS w following values:');

3928: if P_LOAN_REC.CURRENT_PHASE is not null and P_LOAN_REC.CURRENT_PHASE = 'OPEN' then
3929: l_prin_balance := P_LOAN_REC.FUNDED_AMOUNT;
3930: end if;
3931:
3932: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting new record into LNS_AMORTIZATION_SCHEDS w following values:');
3933: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || P_LOAN_REC.LOAN_ID);
3934: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'PAYMENT_NUMBER: ' || P_LOAN_REC.NEXT_PAYMENT_NUMBER);
3935: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'DUE_DATE: ' || P_LOAN_REC.NEXT_PAYMENT_DUE_DATE);
3936: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LATE_DATE: ' || P_LOAN_REC.NEXT_PAYMENT_LATE_DATE);

Line 3944: LNS_AMORTIZATION_SCHEDS_PKG.Insert_Row(

3940: LogMessage(FND_LOG.LEVEL_STATEMENT, 'RATE_ID: ' || P_LOAN_REC.RATE_ID);
3941: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRINCIPAL_BALANCE: ' || l_prin_balance);
3942: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PHASE: ' || P_LOAN_REC.CURRENT_PHASE);
3943:
3944: LNS_AMORTIZATION_SCHEDS_PKG.Insert_Row(
3945: X_AMORTIZATION_SCHEDULE_ID => P_LOAN_REC.NEXT_AMORTIZATION_ID
3946: ,P_LOAN_ID => P_LOAN_REC.LOAN_ID
3947: ,P_PAYMENT_NUMBER => P_LOAN_REC.NEXT_PAYMENT_NUMBER
3948: ,P_DUE_DATE => P_LOAN_REC.NEXT_PAYMENT_DUE_DATE

Line 3960: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully inserted record into LNS_AMORTIZATION_SCHEDS');

3956: ,P_PRINCIPAL_BALANCE => l_prin_balance
3957: ,P_PHASE => P_LOAN_REC.CURRENT_PHASE);
3958:
3959: LogMessage(FND_LOG.LEVEL_STATEMENT, 'AMORTIZATION_SCHEDULE_ID: ' || P_LOAN_REC.NEXT_AMORTIZATION_ID);
3960: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully inserted record into LNS_AMORTIZATION_SCHEDS');
3961:
3962: /* creating AR invoices */
3963: CREATE_AR_INVOICES(P_LOAN_REC, l_lines_tbl);
3964:

Line 5335: from LNS_AMORTIZATION_SCHEDS

5331: select PAYMENT_NUMBER,
5332: DUE_DATE,
5333: AMORTIZATION_SCHEDULE_ID,
5334: RATE_ID
5335: from LNS_AMORTIZATION_SCHEDS
5336: where LOAN_ID = P_LOAN_ID
5337: and AMORTIZATION_SCHEDULE_ID = LNS_BILLING_UTIL_PUB.LAST_AMORTIZATION_SCHED(LOAN_ID);
5338:
5339: CURSOR trx_to_reverse_cur(P_LOAN_ID number, P_AMORTIZATION_ID number) IS

Line 5423: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Querying for last amortization record in LNS_AMORTIZATION_SCHEDS:');

5419:
5420: end if;
5421:
5422: /* quering for last loan amortization record */
5423: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Querying for last amortization record in LNS_AMORTIZATION_SCHEDS:');
5424:
5425: open last_loan_amort_cur(P_LOAN_ID);
5426:
5427: fetch last_loan_amort_cur into

Line 5509: delete from LNS_AMORTIZATION_SCHEDS

5505:
5506: /* Deleting reamortize record */
5507: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Deleting reamortize record...');
5508:
5509: delete from LNS_AMORTIZATION_SCHEDS
5510: where loan_id = P_LOAN_ID and
5511: REAMORTIZE_FROM_INSTALLMENT = l_last_payment_number;
5512:
5513: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Deleted!');

Line 5516: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating record in LNS_AMORTIZATION_SCHEDS...') ;

5512:
5513: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Deleted!');
5514:
5515: /* Update amortization table */
5516: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating record in LNS_AMORTIZATION_SCHEDS...') ;
5517:
5518: LNS_AMORTIZATION_SCHEDS_PKG.Update_Row(
5519: P_AMORTIZATION_SCHEDULE_ID => l_amortization_schedule_id
5520: ,P_REVERSED_FLAG => 'Y'

Line 5518: LNS_AMORTIZATION_SCHEDS_PKG.Update_Row(

5514:
5515: /* Update amortization table */
5516: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating record in LNS_AMORTIZATION_SCHEDS...') ;
5517:
5518: LNS_AMORTIZATION_SCHEDS_PKG.Update_Row(
5519: P_AMORTIZATION_SCHEDULE_ID => l_amortization_schedule_id
5520: ,P_REVERSED_FLAG => 'Y'
5521: ,P_REVERSED_DATE => sysdate);
5522:

Line 5755: from LNS_AMORTIZATION_SCHEDS

5751: CURSOR last_loan_amort_cur(P_LOAN_ID number) IS
5752: select PAYMENT_NUMBER,
5753: DUE_DATE,
5754: AMORTIZATION_SCHEDULE_ID
5755: from LNS_AMORTIZATION_SCHEDS
5756: where LOAN_ID = P_LOAN_ID
5757: and AMORTIZATION_SCHEDULE_ID = LNS_BILLING_UTIL_PUB.LAST_AMORTIZATION_SCHED(LOAN_ID);
5758:
5759: CURSOR trx_to_reverse_cur(P_LOAN_ID number, P_AMORTIZATION_ID number, p_line_type varchar2) IS

Line 5841: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Querying for last amortization record in LNS_AMORTIZATION_SCHEDS:');

5837: RAISE FND_API.G_EXC_ERROR;
5838: end if;
5839:
5840: /* quering for last loan amortization record */
5841: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Querying for last amortization record in LNS_AMORTIZATION_SCHEDS:');
5842:
5843: open last_loan_amort_cur(P_LOAN_ID);
5844:
5845: fetch last_loan_amort_cur into

Line 6045: LNS_AMORTIZATION_SCHEDS am

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
6049: and head.loan_id = am.loan_id(+)

Line 6241: /* Inserting new record into LNS_AMORTIZATION_SCHEDS */

6237: l_loan_rec.NEXT_PAYMENT_NUMBER := P_BILL_HEADER_REC.ASSOC_PAYMENT_NUM;
6238: l_loan_rec.NEXT_PAYMENT_DUE_DATE := P_BILL_HEADER_REC.DUE_DATE;
6239: l_loan_rec.NEXT_PAYMENT_LATE_DATE := P_BILL_HEADER_REC.DUE_DATE + nvl(l_loan_rec.NUMBER_GRACE_DAYS, 0);
6240:
6241: /* Inserting new record into LNS_AMORTIZATION_SCHEDS */
6242: l_prin_balance := null;
6243: if l_loan_rec.CURRENT_PHASE is not null and l_loan_rec.CURRENT_PHASE = 'OPEN' then
6244: l_prin_balance := l_loan_rec.FUNDED_AMOUNT;
6245: end if;

Line 6247: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting new record into LNS_AMORTIZATION_SCHEDS w following values:');

6243: if l_loan_rec.CURRENT_PHASE is not null and l_loan_rec.CURRENT_PHASE = 'OPEN' then
6244: l_prin_balance := l_loan_rec.FUNDED_AMOUNT;
6245: end if;
6246:
6247: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting new record into LNS_AMORTIZATION_SCHEDS w following values:');
6248: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || l_loan_rec.LOAN_ID);
6249: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PAYMENT_NUMBER: ' || l_loan_rec.NEXT_PAYMENT_NUMBER);
6250: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DUE_DATE: ' || l_loan_rec.NEXT_PAYMENT_DUE_DATE);
6251: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LATE_DATE: ' || l_loan_rec.NEXT_PAYMENT_LATE_DATE);

Line 6259: LNS_AMORTIZATION_SCHEDS_PKG.Insert_Row(

6255: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PARENT_AMORTIZATION_ID: ' || l_loan_rec.PARENT_AMORTIZATION_ID);
6256: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PRINCIPAL_BALANCE: ' || l_prin_balance);
6257: LogMessage(FND_LOG.LEVEL_STATEMENT, 'PHASE: ' || l_loan_rec.CURRENT_PHASE);
6258:
6259: LNS_AMORTIZATION_SCHEDS_PKG.Insert_Row(
6260: X_AMORTIZATION_SCHEDULE_ID => l_loan_rec.NEXT_AMORTIZATION_ID
6261: ,P_LOAN_ID => l_loan_rec.LOAN_ID
6262: ,P_PAYMENT_NUMBER => l_loan_rec.NEXT_PAYMENT_NUMBER
6263: ,P_DUE_DATE => l_loan_rec.NEXT_PAYMENT_DUE_DATE

Line 6275: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully inserted record into LNS_AMORTIZATION_SCHEDS');

6271: ,P_PRINCIPAL_BALANCE => l_prin_balance
6272: ,P_PHASE => l_loan_rec.CURRENT_PHASE);
6273:
6274: LogMessage(FND_LOG.LEVEL_STATEMENT, 'AMORTIZATION_SCHEDULE_ID: ' || l_loan_rec.NEXT_AMORTIZATION_ID);
6275: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully inserted record into LNS_AMORTIZATION_SCHEDS');
6276:
6277: /* Creating AR invoices */
6278: CREATE_AR_INVOICES(l_loan_rec, l_lines_tbl);
6279:

Line 6790: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating record in LNS_AMORTIZATION_SCHEDS...') ;

6786: /* Create credit memos */
6787: CREATE_AR_CM(l_reverse_tbl);
6788:
6789: /* Updating amortization table */
6790: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating record in LNS_AMORTIZATION_SCHEDS...') ;
6791:
6792: LNS_AMORTIZATION_SCHEDS_PKG.Update_Row(
6793: P_AMORTIZATION_SCHEDULE_ID => P_AMORTIZATION_ID
6794: ,P_REVERSED_FLAG => 'Y'

Line 6792: LNS_AMORTIZATION_SCHEDS_PKG.Update_Row(

6788:
6789: /* Updating amortization table */
6790: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating record in LNS_AMORTIZATION_SCHEDS...') ;
6791:
6792: LNS_AMORTIZATION_SCHEDS_PKG.Update_Row(
6793: P_AMORTIZATION_SCHEDULE_ID => P_AMORTIZATION_ID
6794: ,P_REVERSED_FLAG => 'Y'
6795: ,P_REVERSED_DATE => sysdate);
6796:

Line 7612: lns_amortization_scheds am,

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
7616: loan.LAST_AMORTIZATION_ID = am.AMORTIZATION_SCHEDULE_ID and