APPS.LNS_LOAN_PUB dependencies on LNS_LOAN_HEADERS_ALL

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 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;