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_AMORTIZATION_LINES

Line 2310: /* inserting new record into LNS_AMORTIZATION_LINES */

2306: l_new_lines_tbl(l_Count3).CUSTOMER_TRX_ID := l_customer_trx_id;
2307: l_new_lines_tbl(l_Count3).PAYMENT_SCHEDULE_ID := l_payment_schedule_id;
2308: l_new_lines_tbl(l_Count3).CUSTOMER_TRX_LINE_ID := l_customer_trx_line_id;
2309:
2310: /* inserting new record into LNS_AMORTIZATION_LINES */
2311: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting new record into LNS_AMORTIZATION_LINES w following values:');
2312: LogMessage(FND_LOG.LEVEL_STATEMENT, 'AMORTIZATION_SCHEDULE_ID: ' || P_LOAN_REC.NEXT_AMORTIZATION_ID);
2313: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || P_LOAN_REC.LOAN_ID);
2314: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LINE_TYPE: ' || l_line_type);

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

2307: l_new_lines_tbl(l_Count3).PAYMENT_SCHEDULE_ID := l_payment_schedule_id;
2308: l_new_lines_tbl(l_Count3).CUSTOMER_TRX_LINE_ID := l_customer_trx_line_id;
2309:
2310: /* inserting new record into LNS_AMORTIZATION_LINES */
2311: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting new record into LNS_AMORTIZATION_LINES w following values:');
2312: LogMessage(FND_LOG.LEVEL_STATEMENT, 'AMORTIZATION_SCHEDULE_ID: ' || P_LOAN_REC.NEXT_AMORTIZATION_ID);
2313: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || P_LOAN_REC.LOAN_ID);
2314: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LINE_TYPE: ' || l_line_type);
2315: LogMessage(FND_LOG.LEVEL_STATEMENT, 'AMOUNT: ' || l_amount);

Line 2322: LNS_AMORTIZATION_LINES_PKG.Insert_Row(

2318: LogMessage(FND_LOG.LEVEL_STATEMENT, 'FEE_ID: ' || l_new_lines_tbl(l_Count3).LINE_REF_ID);
2319: LogMessage(FND_LOG.LEVEL_STATEMENT, 'FEE_SCHEDULE_ID: ' || l_new_lines_tbl(l_Count3).FEE_SCHEDULE_ID);
2320:
2321: l_amortization_line_id := null;
2322: LNS_AMORTIZATION_LINES_PKG.Insert_Row(
2323: X_AMORTIZATION_LINE_ID => l_amortization_line_id
2324: ,P_AMORTIZATION_SCHEDULE_ID => P_LOAN_REC.NEXT_AMORTIZATION_ID
2325: ,P_LOAN_ID => P_LOAN_REC.LOAN_ID
2326: ,P_LINE_TYPE => l_line_type

Line 2336: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully inserted record into LNS_AMORTIZATION_LINES');

2332: ,P_FEE_SCHEDULE_ID => l_new_lines_tbl(l_Count3).FEE_SCHEDULE_ID
2333: ,P_LINE_DETAILS => l_new_lines_tbl(l_Count3).LINE_DETAILS);
2334:
2335: LogMessage(FND_LOG.LEVEL_STATEMENT, 'AMORTIZATION_LINE_ID: ' || l_amortization_line_id);
2336: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully inserted record into LNS_AMORTIZATION_LINES');
2337:
2338: exit;
2339:
2340: end if;

Line 5965: lns_amortization_lines lines,

5961: (psa.AMOUNT_DUE_ORIGINAL - psa.AMOUNT_DUE_REMAINING),
5962: trx.org_id
5963: from
5964: RA_CUSTOMER_TRX_ALL trx,
5965: lns_amortization_lines lines,
5966: ar_payment_schedules psa
5967: where
5968: trx.customer_trx_id = lines.CUST_TRX_ID and
5969: trx.customer_trx_id = psa.customer_trx_id and

Line 6392: lns_amortization_lines lines,

6388: (psa.AMOUNT_DUE_ORIGINAL - psa.AMOUNT_DUE_REMAINING),
6389: trx.org_id
6390: from
6391: RA_CUSTOMER_TRX_ALL trx,
6392: lns_amortization_lines lines,
6393: ar_payment_schedules psa
6394: where
6395: trx.customer_trx_id = lines.CUST_TRX_ID and
6396: trx.customer_trx_id = psa.customer_trx_id and

Line 7277: lns_amortization_lines lines,

7273: (psa.AMOUNT_DUE_ORIGINAL - psa.AMOUNT_DUE_REMAINING),
7274: trx.org_id
7275: from
7276: RA_CUSTOMER_TRX_ALL trx,
7277: lns_amortization_lines lines,
7278: ar_payment_schedules psa
7279: where
7280: trx.customer_trx_id = lines.CUST_TRX_ID and
7281: trx.customer_trx_id = psa.customer_trx_id and

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