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 345: from LNS_AMORTIZATION_SCHEDS

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

Line 353: from LNS_AMORTIZATION_SCHEDS

349: and nvl(PHASE, 'TERM') = nvl(P_PHASE, 'TERM');
350:
351: CURSOR amortization_cur(P_LOAN_ID NUMBER, P_PHASE VARCHAR2) IS
352: select max(AMORTIZATION_SCHEDULE_ID)
353: from LNS_AMORTIZATION_SCHEDS
354: where LOAN_ID = P_LOAN_ID
355: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N')
356: and nvl(PHASE, 'TERM') = nvl(P_PHASE, 'TERM')
357: and PAYMENT_NUMBER =

Line 359: from LNS_AMORTIZATION_SCHEDS

355: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N')
356: and nvl(PHASE, 'TERM') = nvl(P_PHASE, 'TERM')
357: and PAYMENT_NUMBER =
358: nvl((select max(PAYMENT_NUMBER)
359: from LNS_AMORTIZATION_SCHEDS
360: where LOAN_ID = P_LOAN_ID
361: and (REVERSED_FLAG is null or REVERSED_FLAG = 'N')
362: and REAMORTIZATION_AMOUNT is null
363: and nvl(PHASE, 'TERM') = nvl(P_PHASE, 'TERM')), 0);

Line 1305: select LNS_AMORTIZATION_SCHEDS_S.NEXTVAL into P_LOAN_REC.NEXT_AMORTIZATION_ID from dual;

1301: -- fix for bug 5840180: get LNS_CREATE_ZERO_PRIN_INV profile value to see if we need to bill 0 amount principal invoices
1302: l_bill_0_prin_inv := NVL(FND_PROFILE.VALUE('LNS_CREATE_ZERO_PRIN_INV'), 'N');
1303: LogMessage(FND_LOG.LEVEL_STATEMENT, 'The profile LNS_CREATE_ZERO_PRIN_INV value is : '||l_bill_0_prin_inv);
1304:
1305: select LNS_AMORTIZATION_SCHEDS_S.NEXTVAL into P_LOAN_REC.NEXT_AMORTIZATION_ID from dual;
1306:
1307: l_Count1 := 0; -- lines counter
1308: l_Count2 := 0; -- distributions counter
1309: l_Count3 := 0; -- header counter

Line 2216: /* inserting record into LNS_AMORTIZATION_SCHEDS */

2212: end if;
2213:
2214: end if;
2215:
2216: /* inserting record into LNS_AMORTIZATION_SCHEDS */
2217: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting new record into LNS_AMORTIZATION_SCHEDS w following values:');
2218: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || P_LOAN_REC.LOAN_ID);
2219: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'PAYMENT_NUMBER: ' || P_LOAN_REC.NEXT_PAYMENT_NUMBER);
2220: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'DUE_DATE: ' || P_LOAN_REC.NEXT_PAYMENT_DUE_DATE);

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

2213:
2214: end if;
2215:
2216: /* inserting record into LNS_AMORTIZATION_SCHEDS */
2217: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting new record into LNS_AMORTIZATION_SCHEDS w following values:');
2218: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || P_LOAN_REC.LOAN_ID);
2219: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'PAYMENT_NUMBER: ' || P_LOAN_REC.NEXT_PAYMENT_NUMBER);
2220: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'DUE_DATE: ' || P_LOAN_REC.NEXT_PAYMENT_DUE_DATE);
2221: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LATE_DATE: ' || P_LOAN_REC.NEXT_PAYMENT_LATE_DATE);

Line 2234: LNS_AMORTIZATION_SCHEDS_PKG.Insert_Row(

2230: LogMessage(FND_LOG.LEVEL_STATEMENT, 'DEFERRED_INT_AMOUNT: ' || P_LOAN_REC.DEFERRED_INT_AMOUNT);
2231: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CURR_CAP_INT_AMOUNT: ' || P_LOAN_REC.CURR_CAP_INT_AMOUNT);
2232: LogMessage(FND_LOG.LEVEL_STATEMENT, 'CAP_INT_AMOUNT: ' || P_LOAN_REC.CAP_INT_AMOUNT);
2233:
2234: LNS_AMORTIZATION_SCHEDS_PKG.Insert_Row(
2235: X_AMORTIZATION_SCHEDULE_ID => P_LOAN_REC.NEXT_AMORTIZATION_ID
2236: ,P_LOAN_ID => P_LOAN_REC.LOAN_ID
2237: ,P_PAYMENT_NUMBER => P_LOAN_REC.NEXT_PAYMENT_NUMBER
2238: ,P_DUE_DATE => P_LOAN_REC.NEXT_PAYMENT_DUE_DATE

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

2251: ,P_CURR_CAP_INT_AMOUNT => P_LOAN_REC.CURR_CAP_INT_AMOUNT
2252: ,P_CAP_INT_AMOUNT => P_LOAN_REC.CAP_INT_AMOUNT);
2253:
2254: LogMessage(FND_LOG.LEVEL_STATEMENT, 'AMORTIZATION_SCHEDULE_ID: ' || P_LOAN_REC.NEXT_AMORTIZATION_ID);
2255: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully inserted record into LNS_AMORTIZATION_SCHEDS');
2256:
2257: if l_ar_inv_created = true then
2258:
2259: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Fetching inserted ar invoice details...');

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

2387: end if;
2388:
2389: /* Update amortization table with new principal, interest and fee ids */
2390:
2391: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating LNS_AMORTIZATION_SCHEDS with new trx ids:');
2392: LogMessage(FND_LOG.LEVEL_STATEMENT, 'principal_trx_id: ' || l_principal_trx_id);
2393: LogMessage(FND_LOG.LEVEL_STATEMENT, 'interest_trx_id: ' || l_interest_trx_id);
2394: LogMessage(FND_LOG.LEVEL_STATEMENT, 'fee_trx_id: ' || l_fee_trx_id);
2395:

Line 2396: LNS_AMORTIZATION_SCHEDS_PKG.Update_Row(

2392: LogMessage(FND_LOG.LEVEL_STATEMENT, 'principal_trx_id: ' || l_principal_trx_id);
2393: LogMessage(FND_LOG.LEVEL_STATEMENT, 'interest_trx_id: ' || l_interest_trx_id);
2394: LogMessage(FND_LOG.LEVEL_STATEMENT, 'fee_trx_id: ' || l_fee_trx_id);
2395:
2396: LNS_AMORTIZATION_SCHEDS_PKG.Update_Row(
2397: P_AMORTIZATION_SCHEDULE_ID => P_LOAN_REC.NEXT_AMORTIZATION_ID
2398: ,P_PRINCIPAL_TRX_ID => l_principal_trx_id
2399: ,P_INTEREST_TRX_ID => l_interest_trx_id
2400: ,P_FEE_TRX_ID => l_fee_trx_id);

Line 3566: 'lns_amortization_scheds am, ' ||

3562: 'hr_all_organization_units_tl org, ' ||
3563: 'LNS_PAY_SUM_V PAY_SUM, ' ||
3564: 'LNS_PAY_SUM_YEARLY_V PAY_SUM_YEARLY, ' ||
3565: 'LNS_PAY_SUM_OVERDUE_V PAY_SUM_OVERDUE, ' ||
3566: 'lns_amortization_scheds am, ' ||
3567: 'hz_locations loc, ' ||
3568: 'hz_cust_acct_sites_all acct_site, ' ||
3569: 'hz_party_sites site, ' ||
3570: 'fnd_currencies_tl curr, ' ||

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

3682:
3683: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Generated billing statement');
3684:
3685: /* Update amortization table */
3686: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating record in LNS_AMORTIZATION_SCHEDS...') ;
3687:
3688: LNS_AMORTIZATION_SCHEDS_PKG.Update_Statement(
3689: P_AMORTIZATION_SCHEDULE_ID => p_amortization_schedule_id
3690: ,P_STATEMENT_XML => result);

Line 3688: LNS_AMORTIZATION_SCHEDS_PKG.Update_Statement(

3684:
3685: /* Update amortization table */
3686: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating record in LNS_AMORTIZATION_SCHEDS...') ;
3687:
3688: LNS_AMORTIZATION_SCHEDS_PKG.Update_Statement(
3689: P_AMORTIZATION_SCHEDULE_ID => p_amortization_schedule_id
3690: ,P_STATEMENT_XML => result);
3691:
3692: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Update successfull!');

Line 3735: LNS_AMORTIZATION_SCHEDS am,

3731:
3732: CURSOR verify_amount_cur(P_LOAN_ID number) IS
3733: select nvl(sum(am.PRINCIPAL_AMOUNT), 0)
3734: from
3735: LNS_AMORTIZATION_SCHEDS am,
3736: lns_loan_headers head
3737: where
3738: head.loan_id = P_LOAN_ID
3739: and head.loan_id = am.LOAN_ID

Line 3886: lns_amortization_scheds am

3882: /* get statement after its billed */
3883: CURSOR get_statement_cur(P_LOAN_ID number) IS
3884: select STATEMENT_XML
3885: from LNS_LOAN_HEADERS loan,
3886: lns_amortization_scheds am
3887: where loan.loan_id = am.loan_id and
3888: am.AMORTIZATION_SCHEDULE_ID = loan.LAST_AMORTIZATION_ID and
3889: am.PAYMENT_NUMBER = loan.LAST_PAYMENT_NUMBER and
3890: loan.loan_id = P_LOAN_ID;

Line 5949: from LNS_AMORTIZATION_SCHEDS

5945: select PAYMENT_NUMBER,
5946: DUE_DATE,
5947: AMORTIZATION_SCHEDULE_ID,
5948: RATE_ID
5949: from LNS_AMORTIZATION_SCHEDS
5950: where LOAN_ID = P_LOAN_ID
5951: and AMORTIZATION_SCHEDULE_ID = LNS_BILLING_UTIL_PUB.LAST_AMORTIZATION_SCHED(LOAN_ID);
5952:
5953: CURSOR trx_to_reverse_cur(P_LOAN_ID number, P_AMORTIZATION_ID number) IS

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

6033:
6034: end if;
6035:
6036: /* quering for last loan amortization record */
6037: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Querying for last amortization record in LNS_AMORTIZATION_SCHEDS:');
6038:
6039: open last_loan_amort_cur(P_LOAN_ID);
6040:
6041: fetch last_loan_amort_cur into

Line 6127: delete from LNS_AMORTIZATION_SCHEDS

6123:
6124: /* Deleting reamortize record */
6125: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Deleting reamortize record...');
6126:
6127: delete from LNS_AMORTIZATION_SCHEDS
6128: where loan_id = P_LOAN_ID and
6129: REAMORTIZE_FROM_INSTALLMENT = l_last_payment_number;
6130:
6131: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Deleted!');

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

6130:
6131: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Deleted!');
6132:
6133: /* Update amortization table */
6134: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating record in LNS_AMORTIZATION_SCHEDS...') ;
6135:
6136: LNS_AMORTIZATION_SCHEDS_PKG.Update_Row(
6137: P_AMORTIZATION_SCHEDULE_ID => l_amortization_schedule_id
6138: ,P_REVERSED_FLAG => 'Y'

Line 6136: LNS_AMORTIZATION_SCHEDS_PKG.Update_Row(

6132:
6133: /* Update amortization table */
6134: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating record in LNS_AMORTIZATION_SCHEDS...') ;
6135:
6136: LNS_AMORTIZATION_SCHEDS_PKG.Update_Row(
6137: P_AMORTIZATION_SCHEDULE_ID => l_amortization_schedule_id
6138: ,P_REVERSED_FLAG => 'Y'
6139: ,P_REVERSED_DATE => sysdate);
6140:

Line 6376: from LNS_AMORTIZATION_SCHEDS

6372: CURSOR last_loan_amort_cur(P_LOAN_ID number) IS
6373: select PAYMENT_NUMBER,
6374: DUE_DATE,
6375: AMORTIZATION_SCHEDULE_ID
6376: from LNS_AMORTIZATION_SCHEDS
6377: where LOAN_ID = P_LOAN_ID
6378: and AMORTIZATION_SCHEDULE_ID = LNS_BILLING_UTIL_PUB.LAST_AMORTIZATION_SCHED(LOAN_ID);
6379:
6380: CURSOR trx_to_reverse_cur(P_LOAN_ID number, P_AMORTIZATION_ID number, p_line_type varchar2) IS

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

6458: RAISE FND_API.G_EXC_ERROR;
6459: end if;
6460:
6461: /* quering for last loan amortization record */
6462: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Querying for last amortization record in LNS_AMORTIZATION_SCHEDS:');
6463:
6464: open last_loan_amort_cur(P_LOAN_ID);
6465:
6466: fetch last_loan_amort_cur into

Line 6669: LNS_AMORTIZATION_SCHEDS am

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')
6673: and head.loan_id = term.loan_id

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

6875: l_loan_rec.NEXT_PAYMENT_NUMBER := P_BILL_HEADER_REC.ASSOC_PAYMENT_NUM;
6876: l_loan_rec.NEXT_PAYMENT_DUE_DATE := P_BILL_HEADER_REC.DUE_DATE;
6877: l_loan_rec.NEXT_PAYMENT_LATE_DATE := P_BILL_HEADER_REC.DUE_DATE + nvl(l_loan_rec.NUMBER_GRACE_DAYS, 0);
6878:
6879: /* Inserting new record into LNS_AMORTIZATION_SCHEDS */
6880: l_prin_balance := null;
6881: if l_loan_rec.CURRENT_PHASE is not null and l_loan_rec.CURRENT_PHASE = 'OPEN' then
6882: l_prin_balance := l_loan_rec.FUNDED_AMOUNT;
6883: end if;

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

7413: /* Create credit memos */
7414: CREATE_AR_CM(l_reverse_tbl);
7415:
7416: /* Updating amortization table */
7417: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating record in LNS_AMORTIZATION_SCHEDS...') ;
7418:
7419: LNS_AMORTIZATION_SCHEDS_PKG.Update_Row(
7420: P_AMORTIZATION_SCHEDULE_ID => P_AMORTIZATION_ID
7421: ,P_REVERSED_FLAG => 'Y'

Line 7419: LNS_AMORTIZATION_SCHEDS_PKG.Update_Row(

7415:
7416: /* Updating amortization table */
7417: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating record in LNS_AMORTIZATION_SCHEDS...') ;
7418:
7419: LNS_AMORTIZATION_SCHEDS_PKG.Update_Row(
7420: P_AMORTIZATION_SCHEDULE_ID => P_AMORTIZATION_ID
7421: ,P_REVERSED_FLAG => 'Y'
7422: ,P_REVERSED_DATE => sysdate);
7423:

Line 8409: lns_amortization_scheds am,

8405: nvl(loan.CURRENT_PHASE, 'TERM'),
8406: psa.org_id,
8407: loan.LOAN_CURRENCY
8408: from LNS_LOAN_HEADERS_VL loan,
8409: lns_amortization_scheds am,
8410: ar_payment_schedules psa
8411: where
8412: loan.loan_id = P_LOAN_ID and
8413: loan.LAST_AMORTIZATION_ID = am.AMORTIZATION_SCHEDULE_ID and

Line 9374: lns_amortization_scheds am,

9370: P_INVOICE_TYPE,
9371: psa.invoice_currency_code,
9372: nvl(loan.EXCHANGE_RATE, 1)
9373: from
9374: lns_amortization_scheds am,
9375: lns_loan_headers loan,
9376: ar_payment_schedules psa,
9377: lns_lookups look
9378: where

Line 10015: lns_amortization_scheds am,

10011: psa.invoice_currency_code,
10012: nvl(loan.EXCHANGE_RATE, 1),
10013: trx_type.name
10014: from
10015: lns_amortization_scheds am,
10016: lns_loan_headers loan,
10017: ar_payment_schedules psa,
10018: RA_CUST_TRX_TYPES_ALL trx_type
10019: where

Line 10210: from LNS_AMORTIZATION_SCHEDS

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
10210: from LNS_AMORTIZATION_SCHEDS
10211: where loan_id = P_LOAN_ID and
10212: AMORTIZATION_SCHEDULE_ID > P_LAST_AM_SCHED and
10213: (REVERSED_FLAG is null or REVERSED_FLAG = 'N')
10214: order by AMORTIZATION_SCHEDULE_ID;

Line 10698: FROM LNS_AMORTIZATION_SCHEDS scheds,lns_amortization_lines lines, lns_fees_all fee, lns_fee_schedules feeSchd

10694:
10695: -- At present Reversing only SubmitForApproval Fees
10696: CURSOR c_billed_submitAppFee(c_amortization_id NUMBER) IS
10697: SELECT lines.fee_schedule_id, feeSchd.object_version_number
10698: FROM LNS_AMORTIZATION_SCHEDS scheds,lns_amortization_lines lines, lns_fees_all fee, lns_fee_schedules feeSchd
10699: WHERE scheds.amortization_schedule_id = lines.amortization_schedule_id
10700: AND scheds.amortization_schedule_id = C_AMORTIZATION_ID
10701: AND lines.line_type = 'FEE'
10702: AND fee.fee_id = lines.fee_id