APPS.LNS_LOAN_PUB dependencies on LNS_RATE_SCHEDULES

Line 44: g_rate_term_rec lns_rate_schedules%ROWTYPE;

40: g_participants_rec LNS_PARTICIPANTS_PUB.loan_participant_rec_type;
41: g_term_rec LNS_TERMS_PUB.loan_term_rec_type;
42: g_participant_rec LNS_PARTICIPANTS_PUB.loan_participant_rec_type;
43: --lns_terms%ROWTYPE;
44: g_rate_term_rec lns_rate_schedules%ROWTYPE;
45: g_rate_open_rec lns_rate_schedules%ROWTYPE;
46: CURSOR Csr_Product_values (p_product_id IN NUMBER) IS
47: SELECT loan_type.loan_type_id loan_type_id
48: ,loan_type.loan_class_code loan_class_code

Line 45: g_rate_open_rec lns_rate_schedules%ROWTYPE;

41: g_term_rec LNS_TERMS_PUB.loan_term_rec_type;
42: g_participant_rec LNS_PARTICIPANTS_PUB.loan_participant_rec_type;
43: --lns_terms%ROWTYPE;
44: g_rate_term_rec lns_rate_schedules%ROWTYPE;
45: g_rate_open_rec lns_rate_schedules%ROWTYPE;
46: CURSOR Csr_Product_values (p_product_id IN NUMBER) IS
47: SELECT loan_type.loan_type_id loan_type_id
48: ,loan_type.loan_class_code loan_class_code
49: ,loan_type.loan_type_name loan_type_name

Line 420: l_total_installments lns_rate_schedules.end_installment_number%TYPE;

416: l_dummy VARCHAR2(30);
417: l_borrower_valid BOOLEAN;
418: l_cust_acct_valid BOOLEAN;
419: l_generate_loan_number VARCHAR2(1);
420: l_total_installments lns_rate_schedules.end_installment_number%TYPE;
421: l_contact_person_party_id hz_relationships.SUBJECT_ID%TYPE;
422: l_loan_id number(15);
423: l_loan_number VARCHAR2(60);
424: l_header_insert_success VARCHAR2(1);

Line 1393: SELECT LNS_RATE_SCHEDULES_S.nextval

1389:
1390:
1391: g_rate_term_rec.term_id := g_term_rec.term_id;
1392:
1393: SELECT LNS_RATE_SCHEDULES_S.nextval
1394: INTO g_rate_term_rec.rate_id
1395: FROM dual;
1396:
1397: g_rate_term_rec.index_rate := P_Loan_Details_Rec.term_index_rate;

Line 1426: SELECT LNS_RATE_SCHEDULES_S.nextval

1422: IF l_product_rec.multiple_funding_flag = 'Y' THEN
1423:
1424: g_rate_open_rec.term_id := g_term_rec.term_id;
1425:
1426: SELECT LNS_RATE_SCHEDULES_S.nextval
1427: INTO g_rate_open_rec.rate_id
1428: FROM dual;
1429:
1430: g_rate_open_rec.index_rate := P_Loan_Details_Rec.open_index_rate;

Line 1580: insert into LNS_RATE_SCHEDULES

1576: --Insert Term Rate Schedule
1577: IF (l_product_rec.open_to_term_flag = 'Y'
1578: OR l_product_rec.multiple_funding_flag = 'N') THEN
1579: BEGIN
1580: insert into LNS_RATE_SCHEDULES
1581: (RATE_ID
1582: ,TERM_ID
1583: ,INDEX_RATE
1584: ,SPREAD

Line 1633: insert into LNS_RATE_SCHEDULES

1629:
1630: --Insert Open Rate Schedule
1631: IF ( l_product_rec.multiple_funding_flag = 'Y') THEN
1632: BEGIN
1633: insert into LNS_RATE_SCHEDULES
1634: (RATE_ID
1635: ,TERM_ID
1636: ,INDEX_RATE
1637: ,SPREAD