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_LOAN_LINE_PUB dependencies on LNS_LOAN_LINES

Line 41: | 10-Jan-2006 karamach Added payment_schedule_id and installment_number for lns_loan_lines per bug#4887994

37: | There are no table-handler apis for loan lines table since it uses java-based EO
38: |
39: | MODIFICATION HISTORY
40: | Date Author Description of Changes
41: | 10-Jan-2006 karamach Added payment_schedule_id and installment_number for lns_loan_lines per bug#4887994
42: | 20-Dec-2004 karamach Created
43: |
44: *=======================================================================*/
45: PROCEDURE UPDATE_LINE_ADJUSTMENT_NUMBER(

Line 81: p_table_name => 'LNS_LOAN_LINES'

77: --Call to record history
78: LNS_LOAN_HISTORY_PUB.log_record_pre(
79: p_id => p_loan_line_id,
80: p_primary_key_name => 'LOAN_LINE_ID',
81: p_table_name => 'LNS_LOAN_LINES'
82: );
83:
84: -- update loan line
85: UPDATE LNS_LOAN_LINES

Line 85: UPDATE LNS_LOAN_LINES

81: p_table_name => 'LNS_LOAN_LINES'
82: );
83:
84: -- update loan line
85: UPDATE LNS_LOAN_LINES
86: SET REC_ADJUSTMENT_NUMBER = p_rec_adjustment_number,
87: REC_ADJUSTMENT_ID = p_rec_adjustment_id,
88: PAYMENT_SCHEDULE_ID = p_payment_schedule_id,
89: INSTALLMENT_NUMBER = p_installment_number,

Line 101: p_table_name => 'LNS_LOAN_LINES',

97: --Call to record history
98: LNS_LOAN_HISTORY_PUB.log_record_post(
99: p_id => p_loan_line_id,
100: p_primary_key_name => 'LOAN_LINE_ID',
101: p_table_name => 'LNS_LOAN_LINES',
102: p_loan_id => p_loan_id
103: );
104:
105:

Line 201: | after inserting the receivables into lns_loan_lines table.

197: | for ERS loan receivables derivation and inserts into loan lines table.
198: | If NO rules have been defined for the loan product, calling this api retrieves
199: | ALL OPEN Receivables for the customer and inserts them into loan lines.
200: | The function returns the total requested amount for updating loan header
201: | after inserting the receivables into lns_loan_lines table.
202: |
203: | NOTES
204: | This api does a bulk select if max_requested_amount is NOT specified on the product.
205: | This api does bulk insert into lns_loan_lines after retrieving the matching receivables into table types.

Line 205: | This api does bulk insert into lns_loan_lines after retrieving the matching receivables into table types.

201: | after inserting the receivables into lns_loan_lines table.
202: |
203: | NOTES
204: | This api does a bulk select if max_requested_amount is NOT specified on the product.
205: | This api does bulk insert into lns_loan_lines after retrieving the matching receivables into table types.
206: | Incase an error is encountered during processing the api returns zero with error message in the stack.
207: | The api also returns zero if no receivables found for inserting into loan lines.
208: |
209: | MODIFICATION HISTORY

Line 245: (select null from lns_loan_lines where loan_id = pLoanId and end_date is null);

241: CURSOR c_check_existing_line(pLoanId Number) IS
242: select 'Y' line_exists
243: from dual
244: where exists
245: (select null from lns_loan_lines where loan_id = pLoanId and end_date is null);
246:
247: CURSOR c_loan_product(pLoanProductId Number, pOrgId Number) IS
248: select loan_product_name,MAX_REQUESTED_AMOUNT
249: from lns_loan_products_all_vl

Line 254: TYPE lns_pmt_sch_id_type IS TABLE OF LNS_LOAN_LINES.PAYMENT_SCHEDULE_ID%TYPE INDEX BY PLS_INTEGER;

250: where loan_product_id = pLoanProductId
251: and org_id = pOrgId;
252:
253: --Need to define separate table types for each column for bulk insert since table type with all columns is not supported for bulk processing
254: TYPE lns_pmt_sch_id_type IS TABLE OF LNS_LOAN_LINES.PAYMENT_SCHEDULE_ID%TYPE INDEX BY PLS_INTEGER;
255: l_pmt_sch_id_tbl lns_pmt_sch_id_type;
256:
257: TYPE lns_reference_id_type IS TABLE OF LNS_LOAN_LINES.REFERENCE_ID%TYPE INDEX BY PLS_INTEGER;
258: l_reference_id_tbl lns_reference_id_type;

Line 257: TYPE lns_reference_id_type IS TABLE OF LNS_LOAN_LINES.REFERENCE_ID%TYPE INDEX BY PLS_INTEGER;

253: --Need to define separate table types for each column for bulk insert since table type with all columns is not supported for bulk processing
254: TYPE lns_pmt_sch_id_type IS TABLE OF LNS_LOAN_LINES.PAYMENT_SCHEDULE_ID%TYPE INDEX BY PLS_INTEGER;
255: l_pmt_sch_id_tbl lns_pmt_sch_id_type;
256:
257: TYPE lns_reference_id_type IS TABLE OF LNS_LOAN_LINES.REFERENCE_ID%TYPE INDEX BY PLS_INTEGER;
258: l_reference_id_tbl lns_reference_id_type;
259:
260: TYPE lns_reference_number_type IS TABLE OF LNS_LOAN_LINES.REFERENCE_NUMBER%TYPE INDEX BY PLS_INTEGER;
261: l_reference_number_tbl lns_reference_number_type;

Line 260: TYPE lns_reference_number_type IS TABLE OF LNS_LOAN_LINES.REFERENCE_NUMBER%TYPE INDEX BY PLS_INTEGER;

256:
257: TYPE lns_reference_id_type IS TABLE OF LNS_LOAN_LINES.REFERENCE_ID%TYPE INDEX BY PLS_INTEGER;
258: l_reference_id_tbl lns_reference_id_type;
259:
260: TYPE lns_reference_number_type IS TABLE OF LNS_LOAN_LINES.REFERENCE_NUMBER%TYPE INDEX BY PLS_INTEGER;
261: l_reference_number_tbl lns_reference_number_type;
262:
263: TYPE lns_reference_amount_type IS TABLE OF LNS_LOAN_LINES.REFERENCE_AMOUNT%TYPE INDEX BY PLS_INTEGER;
264: l_reference_amount_tbl lns_reference_amount_type;

Line 263: TYPE lns_reference_amount_type IS TABLE OF LNS_LOAN_LINES.REFERENCE_AMOUNT%TYPE INDEX BY PLS_INTEGER;

259:
260: TYPE lns_reference_number_type IS TABLE OF LNS_LOAN_LINES.REFERENCE_NUMBER%TYPE INDEX BY PLS_INTEGER;
261: l_reference_number_tbl lns_reference_number_type;
262:
263: TYPE lns_reference_amount_type IS TABLE OF LNS_LOAN_LINES.REFERENCE_AMOUNT%TYPE INDEX BY PLS_INTEGER;
264: l_reference_amount_tbl lns_reference_amount_type;
265:
266: TYPE lns_requested_amount_type IS TABLE OF LNS_LOAN_LINES.REQUESTED_AMOUNT%TYPE INDEX BY PLS_INTEGER;
267: l_requested_amount_tbl lns_requested_amount_type;

Line 266: TYPE lns_requested_amount_type IS TABLE OF LNS_LOAN_LINES.REQUESTED_AMOUNT%TYPE INDEX BY PLS_INTEGER;

262:
263: TYPE lns_reference_amount_type IS TABLE OF LNS_LOAN_LINES.REFERENCE_AMOUNT%TYPE INDEX BY PLS_INTEGER;
264: l_reference_amount_tbl lns_reference_amount_type;
265:
266: TYPE lns_requested_amount_type IS TABLE OF LNS_LOAN_LINES.REQUESTED_AMOUNT%TYPE INDEX BY PLS_INTEGER;
267: l_requested_amount_tbl lns_requested_amount_type;
268:
269: TYPE lns_installment_number_type IS TABLE OF LNS_LOAN_LINES.INSTALLMENT_NUMBER%TYPE INDEX BY PLS_INTEGER;
270: l_installment_number_tbl lns_installment_number_type;

Line 269: TYPE lns_installment_number_type IS TABLE OF LNS_LOAN_LINES.INSTALLMENT_NUMBER%TYPE INDEX BY PLS_INTEGER;

265:
266: TYPE lns_requested_amount_type IS TABLE OF LNS_LOAN_LINES.REQUESTED_AMOUNT%TYPE INDEX BY PLS_INTEGER;
267: l_requested_amount_tbl lns_requested_amount_type;
268:
269: TYPE lns_installment_number_type IS TABLE OF LNS_LOAN_LINES.INSTALLMENT_NUMBER%TYPE INDEX BY PLS_INTEGER;
270: l_installment_number_tbl lns_installment_number_type;
271:
272: CURSOR c_get_rule_object(pRuleObjectName VARCHAR2, pApplicationId NUMBER, pLoanProductId NUMBER, pOrgId NUMBER) IS
273: select 'Y' rule_exists, attr.DEFAULT_VALUE sort_attribute

Line 334: from lns_loan_lines

330: AND inv.invoice_currency_code = pCurrencyCode;
331:
332: CURSOR c_get_bulk_total(pLoanId NUMBER) IS
333: select sum(requested_amount) total_amount, count(loan_line_id) record_count
334: from lns_loan_lines
335: where loan_id = pLoanId
336: and end_date is null;
337:
338: BEGIN

Line 381: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_LINES_EXIST');

377:
378: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, l_api_name || ': ' || ' - loan lines already exist for this loan_id');
379:
380: --throw exception
381: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_LINES_EXIST');
382: FND_MSG_PUB.Add;
383: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ': ' || FND_MSG_PUB.Get(p_encoded => 'F'));
384: RAISE FND_API.G_EXC_ERROR;
385:

Line 574: l_last_api_called := 'Bulk insert into lns_loan_lines';

570: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ': ' || FND_MSG_PUB.Get(p_encoded => 'F'));
571: RAISE FND_API.G_EXC_ERROR;
572: END IF;
573:
574: l_last_api_called := 'Bulk insert into lns_loan_lines';
575: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ': ' || ' - BEGIN: ' || l_last_api_called);
576:
577: forall i in l_pmt_sch_id_tbl.first..l_pmt_sch_id_tbl.last
578: insert into lns_loan_lines(

Line 578: insert into lns_loan_lines(

574: l_last_api_called := 'Bulk insert into lns_loan_lines';
575: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ': ' || ' - BEGIN: ' || l_last_api_called);
576:
577: forall i in l_pmt_sch_id_tbl.first..l_pmt_sch_id_tbl.last
578: insert into lns_loan_lines(
579: LOAN_LINE_ID
580: ,LOAN_ID
581: ,LAST_UPDATE_DATE
582: ,LAST_UPDATED_BY

Line 625: /* --open cursor to get number of records and total requested amount from lns_loan_lines

621: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ': ' || ' - END: ' || l_last_api_called);
622:
623: IF (l_bulk_process = 'Y') THEN
624: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Record fetch was performed as a bulk operation since maximum loan amount is NOT specified in loan product');
625: /* --open cursor to get number of records and total requested amount from lns_loan_lines
626: OPEN c_get_bulk_total(l_loan_id);
627: FETCH c_get_bulk_total INTO l_loan_amount, l_record_count;
628: CLOSE c_get_bulk_total;
629: --the return value should not be null

Line 642: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Inserted '|| l_record_count || ' rows into lns_loan_lines successfully!');

638: l_record_count := l_record_count + 1;
639: l_loan_amount := l_loan_amount + l_requested_amount_tbl(j);
640: end loop;
641: END IF;
642: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Inserted '|| l_record_count || ' rows into lns_loan_lines successfully!');
643: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - The total loan amount processed is ' || l_loan_amount);
644:
645: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
646: