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_LOAN_PUB dependencies on LNS_LOAN_HEADERS

Line 496: l_contact_rel_party_id lns_loan_headers_all.contact_rel_party_id%TYPE;

492: l_exchange_required VARCHAR2(1);
493: l_functional_currency gl_sets_of_books.currency_code%TYPE;
494: l_borrower_valid boolean;
495: l_cust_acct_valid boolean;
496: l_contact_rel_party_id lns_loan_headers_all.contact_rel_party_id%TYPE;
497: l_contact_pers_party_id lns_loan_headers_all.contact_pers_party_id%TYPE;
498: l_valid_contact_rel VARCHAR2(1) := 'N';
499: l_valid_contact_pers VARCHAR2(1) := 'N';
500:

Line 497: l_contact_pers_party_id lns_loan_headers_all.contact_pers_party_id%TYPE;

493: l_functional_currency gl_sets_of_books.currency_code%TYPE;
494: l_borrower_valid boolean;
495: l_cust_acct_valid boolean;
496: l_contact_rel_party_id lns_loan_headers_all.contact_rel_party_id%TYPE;
497: l_contact_pers_party_id lns_loan_headers_all.contact_pers_party_id%TYPE;
498: l_valid_contact_rel VARCHAR2(1) := 'N';
499: l_valid_contact_pers VARCHAR2(1) := 'N';
500:
501: BEGIN

Line 1875: l_contact_rel_party_id lns_loan_headers_all.contact_rel_party_id%TYPE;

1871: l_api_name constant VARCHAR2(30) := 'VALIDATE_PARTICIPANTS';
1872: l_dummy VARCHAR2(1);
1873: l_borrower_valid boolean;
1874: l_cust_acct_valid boolean;
1875: l_contact_rel_party_id lns_loan_headers_all.contact_rel_party_id%TYPE;
1876: l_contact_pers_party_id lns_loan_headers_all.contact_pers_party_id%TYPE;
1877: l_valid_contact_rel VARCHAR2(1) := 'N';
1878: l_valid_contact_pers VARCHAR2(1) := 'N';
1879:

Line 1876: l_contact_pers_party_id lns_loan_headers_all.contact_pers_party_id%TYPE;

1872: l_dummy VARCHAR2(1);
1873: l_borrower_valid boolean;
1874: l_cust_acct_valid boolean;
1875: l_contact_rel_party_id lns_loan_headers_all.contact_rel_party_id%TYPE;
1876: l_contact_pers_party_id lns_loan_headers_all.contact_pers_party_id%TYPE;
1877: l_valid_contact_rel VARCHAR2(1) := 'N';
1878: l_valid_contact_pers VARCHAR2(1) := 'N';
1879:
1880: BEGIN

Line 2539: LNS_LOAN_HEADERS LnsLoanHeaders ,

2535: NULL OPEN_PHASE_FLAG,
2536: NULL PHASE,
2537: LnsFees.CUSTOM_PROCEDURE
2538: FROM LNS_FEES LnsFees ,
2539: LNS_LOAN_HEADERS LnsLoanHeaders ,
2540: LNS_LOAN_PRODUCT_LINES LnsLoanProductLines
2541: WHERE LnsLoanHeaders.LOAN_ID = c_loan_id
2542: AND LnsLoanHeaders.PRODUCT_ID = LnsLoanProductLines.LOAN_PRODUCT_ID
2543: AND LnsLoanProductLines.LOAN_PRODUCT_LINE_TYPE = 'FEE'

Line 2553: FROM LNS_LOAN_HEADERS LnsLoanHeaders

2549: WHERE ACCOUNT_NAME = 'FEE_RECEIVABLE' OR FEE_ID = c_fee_id ;
2550:
2551: CURSOR current_loan_status ( c_loan_id NUMBER ) IS
2552: SELECT LOAN_STATUS , CURRENT_PHASE
2553: FROM LNS_LOAN_HEADERS LnsLoanHeaders
2554: WHERE LnsLoanHeaders.LOAN_ID = c_loan_id ;
2555:
2556:
2557: CURSOR loan_fee_exists ( c_loan_id NUMBER ) IS

Line 2570: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE ;

2566: WHERE TABLE_NAME = 'LNS_FEE_ASSIGNMENTS' AND LOAN_ID = c_loan_id) ;
2567:
2568: l_fee_assignment_rec LNS_FEE_ASSIGNMENT_PUB.fee_assignment_rec_type ;
2569: l_fee_assignment_id NUMBER ;
2570: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE ;
2571: l_loan_current_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE ;
2572: l_loan_fee_exists VARCHAR2(1) ;
2573:
2574: l_line_type LNS_DEFAULT_DISTRIBS.LINE_TYPE%TYPE ;

Line 2571: l_loan_current_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE ;

2567:
2568: l_fee_assignment_rec LNS_FEE_ASSIGNMENT_PUB.fee_assignment_rec_type ;
2569: l_fee_assignment_id NUMBER ;
2570: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE ;
2571: l_loan_current_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE ;
2572: l_loan_fee_exists VARCHAR2(1) ;
2573:
2574: l_line_type LNS_DEFAULT_DISTRIBS.LINE_TYPE%TYPE ;
2575: l_account_name LNS_DEFAULT_DISTRIBS.ACCOUNT_NAME%TYPE ;

Line 3155: select LNS_LOAN_HEADERS_S.nextval

3151:
3152: -- loan record
3153: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Setting l_loan_rec record...');
3154:
3155: select LNS_LOAN_HEADERS_S.nextval
3156: into l_loan_rec.loan_id
3157: from dual;
3158: l_loan_rec.product_id := P_Loan_Details_Rec.product_id;
3159:

Line 4038: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_loan_headers_all with requested_amount = ' || l_ers_requested_amount);

4034:
4035: IF l_ers_requested_amount = 0 THEN
4036: LogErrors(p_message_name=>'LNS_LCREATE_ERR_LINE_DERIVE');
4037: ELSE
4038: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_loan_headers_all with requested_amount = ' || l_ers_requested_amount);
4039: UPDATE lns_loan_headers_all
4040: SET requested_amount = l_ers_requested_amount
4041: ,object_version_number = 2
4042: WHERE loan_id = l_loan_rec.loan_id;

Line 4039: UPDATE lns_loan_headers_all

4035: IF l_ers_requested_amount = 0 THEN
4036: LogErrors(p_message_name=>'LNS_LCREATE_ERR_LINE_DERIVE');
4037: ELSE
4038: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating lns_loan_headers_all with requested_amount = ' || l_ers_requested_amount);
4039: UPDATE lns_loan_headers_all
4040: SET requested_amount = l_ers_requested_amount
4041: ,object_version_number = 2
4042: WHERE loan_id = l_loan_rec.loan_id;
4043: END IF;