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_LINES

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

2140: l_new_lines_tbl(l_Count3).CUSTOMER_TRX_ID := l_customer_trx_id;
2141: l_new_lines_tbl(l_Count3).PAYMENT_SCHEDULE_ID := l_payment_schedule_id;
2142: l_new_lines_tbl(l_Count3).CUSTOMER_TRX_LINE_ID := l_customer_trx_line_id;
2143:
2144: /* inserting new record into LNS_AMORTIZATION_LINES */
2145: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting new record into LNS_AMORTIZATION_LINES w following values:');
2146: LogMessage(FND_LOG.LEVEL_STATEMENT, 'AMORTIZATION_SCHEDULE_ID: ' || P_LOAN_REC.NEXT_AMORTIZATION_ID);
2147: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || P_LOAN_REC.LOAN_ID);
2148: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LINE_TYPE: ' || l_line_type);

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

2141: l_new_lines_tbl(l_Count3).PAYMENT_SCHEDULE_ID := l_payment_schedule_id;
2142: l_new_lines_tbl(l_Count3).CUSTOMER_TRX_LINE_ID := l_customer_trx_line_id;
2143:
2144: /* inserting new record into LNS_AMORTIZATION_LINES */
2145: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Inserting new record into LNS_AMORTIZATION_LINES w following values:');
2146: LogMessage(FND_LOG.LEVEL_STATEMENT, 'AMORTIZATION_SCHEDULE_ID: ' || P_LOAN_REC.NEXT_AMORTIZATION_ID);
2147: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LOAN_ID: ' || P_LOAN_REC.LOAN_ID);
2148: LogMessage(FND_LOG.LEVEL_STATEMENT, 'LINE_TYPE: ' || l_line_type);
2149: LogMessage(FND_LOG.LEVEL_STATEMENT, 'AMOUNT: ' || l_amount);

Line 2156: LNS_AMORTIZATION_LINES_PKG.Insert_Row(

2152: LogMessage(FND_LOG.LEVEL_STATEMENT, 'FEE_ID: ' || l_new_lines_tbl(l_Count3).LINE_REF_ID);
2153: LogMessage(FND_LOG.LEVEL_STATEMENT, 'FEE_SCHEDULE_ID: ' || l_new_lines_tbl(l_Count3).FEE_SCHEDULE_ID);
2154:
2155: l_amortization_line_id := null;
2156: LNS_AMORTIZATION_LINES_PKG.Insert_Row(
2157: X_AMORTIZATION_LINE_ID => l_amortization_line_id
2158: ,P_AMORTIZATION_SCHEDULE_ID => P_LOAN_REC.NEXT_AMORTIZATION_ID
2159: ,P_LOAN_ID => P_LOAN_REC.LOAN_ID
2160: ,P_LINE_TYPE => l_line_type

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

2165: ,P_OBJECT_VERSION_NUMBER => 1
2166: ,P_FEE_SCHEDULE_ID => l_new_lines_tbl(l_Count3).FEE_SCHEDULE_ID);
2167:
2168: LogMessage(FND_LOG.LEVEL_STATEMENT, 'AMORTIZATION_LINE_ID: ' || l_amortization_line_id);
2169: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully inserted record into LNS_AMORTIZATION_LINES');
2170:
2171: exit;
2172:
2173: end if;

Line 5351: lns_amortization_lines lines,

5347: (psa.AMOUNT_DUE_ORIGINAL - psa.AMOUNT_DUE_REMAINING),
5348: trx.org_id
5349: from
5350: RA_CUSTOMER_TRX_ALL trx,
5351: lns_amortization_lines lines,
5352: ar_payment_schedules psa
5353: where
5354: trx.customer_trx_id = lines.CUST_TRX_ID and
5355: trx.customer_trx_id = psa.customer_trx_id and

Line 5771: lns_amortization_lines lines,

5767: (psa.AMOUNT_DUE_ORIGINAL - psa.AMOUNT_DUE_REMAINING),
5768: trx.org_id
5769: from
5770: RA_CUSTOMER_TRX_ALL trx,
5771: lns_amortization_lines lines,
5772: ar_payment_schedules psa
5773: where
5774: trx.customer_trx_id = lines.CUST_TRX_ID and
5775: trx.customer_trx_id = psa.customer_trx_id and

Line 6650: lns_amortization_lines lines,

6646: (psa.AMOUNT_DUE_ORIGINAL - psa.AMOUNT_DUE_REMAINING),
6647: trx.org_id
6648: from
6649: RA_CUSTOMER_TRX_ALL trx,
6650: lns_amortization_lines lines,
6651: ar_payment_schedules psa
6652: where
6653: trx.customer_trx_id = lines.CUST_TRX_ID and
6654: trx.customer_trx_id = psa.customer_trx_id and