APPS.LNS_LOAN_PUB dependencies on LNS_LOAN_LINES

Line 386: type PAYMENT_SCHEDULE_ID_tab_t is table of lns_loan_lines.PAYMENT_SCHEDULE_ID%TYPE

382: +-----------------------------------------------------------------------*/
383:
384: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_LOAN';
385: l_api_version CONSTANT NUMBER := 1.0;
386: type PAYMENT_SCHEDULE_ID_tab_t is table of lns_loan_lines.PAYMENT_SCHEDULE_ID%TYPE
387: index by pls_integer;
388: v_PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID_tab_t;
389:
390: type customer_trx_id_tab_t is table of lns_loan_lines.reference_id%TYPE

Line 390: type customer_trx_id_tab_t is table of lns_loan_lines.reference_id%TYPE

386: type PAYMENT_SCHEDULE_ID_tab_t is table of lns_loan_lines.PAYMENT_SCHEDULE_ID%TYPE
387: index by pls_integer;
388: v_PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID_tab_t;
389:
390: type customer_trx_id_tab_t is table of lns_loan_lines.reference_id%TYPE
391: index by pls_integer;
392: v_customer_trx_id customer_trx_id_tab_t;
393:
394: type reference_number_tab_t is table of lns_loan_lines.reference_number%TYPE

Line 394: type reference_number_tab_t is table of lns_loan_lines.reference_number%TYPE

390: type customer_trx_id_tab_t is table of lns_loan_lines.reference_id%TYPE
391: index by pls_integer;
392: v_customer_trx_id customer_trx_id_tab_t;
393:
394: type reference_number_tab_t is table of lns_loan_lines.reference_number%TYPE
395: index by pls_integer;
396: v_reference_number reference_number_tab_t;
397:
398: type installment_number_tab_t is table of lns_loan_lines.installment_number%TYPE

Line 398: type installment_number_tab_t is table of lns_loan_lines.installment_number%TYPE

394: type reference_number_tab_t is table of lns_loan_lines.reference_number%TYPE
395: index by pls_integer;
396: v_reference_number reference_number_tab_t;
397:
398: type installment_number_tab_t is table of lns_loan_lines.installment_number%TYPE
399: index by pls_integer;
400: v_installment_number installment_number_tab_t;
401:
402: type remaining_balance_tab_t is table of ar_payment_schedules_all.amount_due_remaining%TYPE

Line 405: type requested_amount_tab_t is table of lns_loan_lines.requested_amount%TYPE

401:
402: type remaining_balance_tab_t is table of ar_payment_schedules_all.amount_due_remaining%TYPE
403: index by pls_integer;
404: v_remaining_balance remaining_balance_tab_t;
405: type requested_amount_tab_t is table of lns_loan_lines.requested_amount%TYPE
406: index by pls_integer;
407: v_requested_amount requested_amount_tab_t;
408: type DESCRIPTION_tab_t is table of lns_loan_lines.REFERENCE_DESCRIPTION%TYPE
409: index by pls_integer;

Line 408: type DESCRIPTION_tab_t is table of lns_loan_lines.REFERENCE_DESCRIPTION%TYPE

404: v_remaining_balance remaining_balance_tab_t;
405: type requested_amount_tab_t is table of lns_loan_lines.requested_amount%TYPE
406: index by pls_integer;
407: v_requested_amount requested_amount_tab_t;
408: type DESCRIPTION_tab_t is table of lns_loan_lines.REFERENCE_DESCRIPTION%TYPE
409: index by pls_integer;
410: v_DESCRIPTION DESCRIPTION_tab_t;
411: type line_number_tab_t is table of NUMBER(15)
412: index by pls_integer;

Line 1503: INSERT INTO LNS_LOAN_LINES

1499: -- Insert Lines if ERS and update Loan Header Record
1500: IF l_product_rec.loan_class_code = 'ERS' THEN
1501: IF P_Loan_Lines_Rec.COUNT <> 0 THEN
1502: FORALL i in v_customer_trx_id.FIRST..v_customer_trx_id.LAST
1503: INSERT INTO LNS_LOAN_LINES
1504: (
1505: LOAN_LINE_ID
1506: ,LOAN_ID
1507: ,LAST_UPDATE_DATE