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

Line 143: lns_loan_headers loan

139: ELSE
140: 'N'
141: END
142: from lns_disb_headers head,
143: lns_loan_headers loan
144: where head.DISB_HEADER_ID = P_DISB_HEADER_ID and
145: head.LOAN_ID = loan.LOAN_ID;
146:
147: BEGIN

Line 216: from lns_loan_headers_all loan

212: END
213: ELSE
214: 'N'
215: END
216: from lns_loan_headers_all loan
217: where loan.LOAN_ID = P_LOAN_ID;
218:
219: BEGIN
220: l_return := 'N';

Line 293: lns_loan_headers_all loan

289: ELSE
290: 'Y'
291: END
292: from lns_disb_headers head,
293: lns_loan_headers_all loan
294: where head.DISB_HEADER_ID = P_DISB_HEADER_ID and
295: head.loan_id = loan.loan_id;
296:
297: BEGIN

Line 367: lns_loan_headers_all loan

363: END
364: END
365: from lns_disb_lines line,
366: lns_disb_headers head,
367: lns_loan_headers_all loan
368: where line.DISB_LINE_ID = P_DISB_LINE_ID and
369: line.disb_header_id = head.disb_header_id and
370: head.loan_id = loan.loan_id;
371:

Line 436: lns_loan_headers_all loan

432: ELSE
433: 'N'
434: END
435: from lns_disb_headers head,
436: lns_loan_headers_all loan
437: where head.DISB_HEADER_ID = P_DISB_HEADER_ID and
438: head.loan_id = loan.loan_id;
439:
440: BEGIN

Line 1695: LNS_LOAN_HEADERS_ALL loan

1691: select line.PAYEE_PARTY_ID,
1692: loan.org_id
1693: from LNS_DISB_LINES line,
1694: LNS_DISB_HEADERS head,
1695: LNS_LOAN_HEADERS_ALL loan
1696: where head.DISB_HEADER_ID = P_DISB_HEADER_ID and
1697: head.DISB_HEADER_ID = line.DISB_HEADER_ID and
1698: head.loan_id = loan.loan_id and not exists
1699: (select PAYEE_PARTY_ID

Line 1879: LNS_LOAN_HEADERS_ALL loan

1875: head.TARGET_DATE,
1876: decode(nvl(loan.CURRENT_PHASE, 'TERM'), 'TERM', loan.LOAN_START_DATE, loan.OPEN_LOAN_START_DATE),
1877: loan.OPEN_MATURITY_DATE
1878: from LNS_DISB_HEADERS head,
1879: LNS_LOAN_HEADERS_ALL loan
1880: where loan.LOAN_ID = P_LOAN_ID and
1881: head.LOAN_ID = loan.LOAN_ID
1882: order by head.DISBURSEMENT_NUMBER;
1883:

Line 2317: LNS_LOAN_HEADERS_ALL loan

2313: loan.OPEN_LOAN_START_DATE,
2314: (select count(1) from lns_disb_lines where disb_header_id = head.DISB_HEADER_ID and
2315: PAYMENT_METHOD_CODE is null)
2316: from LNS_DISB_HEADERS head,
2317: LNS_LOAN_HEADERS_ALL loan
2318: where head.DISB_HEADER_ID = P_DISB_HEADER_ID and
2319: head.LOAN_ID = loan.LOAN_ID;
2320:
2321: BEGIN

Line 2560: LNS_LOAN_HEADERS_ALL loan

2556: loan.LEGAL_ENTITY_ID,
2557: nvl(head.PAYMENT_REQUEST_DATE, head.TARGET_DATE)
2558: from LNS_DISB_LINES line,
2559: LNS_DISB_HEADERS head,
2560: LNS_LOAN_HEADERS_ALL loan
2561: where line.DISB_HEADER_ID = P_DISB_HEADER_ID and
2562: line.DISB_HEADER_ID = head.DISB_HEADER_ID and
2563: head.LOAN_ID = loan.LOAN_ID
2564: order by line.DISB_LINE_ID;

Line 2911: LNS_LOAN_HEADERS_ALL loan

2907: loan.OPEN_MATURITY_DATE,
2908: loan.loan_status,
2909: head.payment_request_date
2910: from LNS_DISB_HEADERS head,
2911: LNS_LOAN_HEADERS_ALL loan
2912: where loan.LOAN_ID = P_LOAN_ID and
2913: head.LOAN_ID = loan.LOAN_ID
2914: order by head.TARGET_DATE;
2915:

Line 2928: from lns_loan_headers_all loan

2924: (select trunc(max(PAYMENT_REQUEST_DATE)) from LNS_DISB_HEADERS where LOAN_ID = loan.LOAN_ID))
2925: ELSE
2926: 1
2927: END
2928: from lns_loan_headers_all loan
2929: where loan.LOAN_ID = P_LOAN_ID;
2930:
2931: BEGIN
2932:

Line 3437: l_org_id lns_loan_headers_all.org_id%TYPE;

3433: l_api_name CONSTANT VARCHAR2(30) := 'DEFAULT_PROD_DISBURSEMENTS';
3434: l_api_version CONSTANT NUMBER := 1.0;
3435: l_Trxn_Attributes_Rec IBY_DISBURSEMENT_COMP_PUB.Trxn_Attributes_Rec_Type;
3436: l_Default_Pmt_Attrs_Rec IBY_DISBURSEMENT_COMP_PUB.Default_Pmt_Attrs_Rec_Type;
3437: l_org_id lns_loan_headers_all.org_id%TYPE;
3438: l_legal_entity_id lns_Loan_headers_all.legal_entity_id%TYPE;
3439: l_payment_method_code lns_disb_lines.payment_method_code%TYPE;
3440: l_bank_account_id lns_disb_lines.bank_account_id%TYPE;
3441: l_payee_party_id lns_disb_lines.payee_party_id%TYPE;

Line 3438: l_legal_entity_id lns_Loan_headers_all.legal_entity_id%TYPE;

3434: l_api_version CONSTANT NUMBER := 1.0;
3435: l_Trxn_Attributes_Rec IBY_DISBURSEMENT_COMP_PUB.Trxn_Attributes_Rec_Type;
3436: l_Default_Pmt_Attrs_Rec IBY_DISBURSEMENT_COMP_PUB.Default_Pmt_Attrs_Rec_Type;
3437: l_org_id lns_loan_headers_all.org_id%TYPE;
3438: l_legal_entity_id lns_Loan_headers_all.legal_entity_id%TYPE;
3439: l_payment_method_code lns_disb_lines.payment_method_code%TYPE;
3440: l_bank_account_id lns_disb_lines.bank_account_id%TYPE;
3441: l_payee_party_id lns_disb_lines.payee_party_id%TYPE;
3442: l_return_status varchar2(1);

Line 3465: FROM lns_loan_headers_all llh

3461: ,llh.legal_entity_id
3462: INTO l_payee_party_id
3463: ,l_org_id
3464: ,l_legal_entity_id
3465: FROM lns_loan_headers_all llh
3466: WHERE llh.loan_id = p_loan_id;
3467: l_Trxn_Attributes_Rec.Application_Id := 206;
3468: l_Trxn_Attributes_Rec.Payer_Legal_Entity_Id := l_legal_entity_id;
3469: l_Trxn_Attributes_Rec.Payer_Org_Id := l_org_id;

Line 3496: FROM lns_loan_headers_all llh, lns_loan_product_lines lpl

3492: , disb_percent
3493: , sequence_number
3494: , llh.primary_borrower_id payee_party_id
3495: , lns_disb_lines_s.NEXTVAL disb_line_id
3496: FROM lns_loan_headers_all llh, lns_loan_product_lines lpl
3497: WHERE llh.loan_id = p_loan_id
3498: -- AND llh.multiple_funding_flag = 'Y' Bug#6613708
3499: AND lpl.LOAN_PRODUCT_ID = llh.PRODUCT_ID
3500: AND lpl.LOAN_PRODUCT_LINE_TYPE = 'DISBURSEMENT'

Line 3690: LNS_LOAN_HEADERS_ALL loan

3686: line.INVOICE_INTERFACE_ID
3687: from LNS_DISB_LINES line,
3688: LNS_DISB_HEADERS head,
3689: lns_lookups lkp,
3690: LNS_LOAN_HEADERS_ALL loan
3691: where line.DISB_LINE_ID = P_DISB_LINE_ID and
3692: head.DISB_HEADER_ID = line.DISB_HEADER_ID and
3693: lkp.lookup_type = 'DISB_ACTIVITY' and
3694: lkp.lookup_code = head.ACTIVITY_CODE and

Line 4898: from LNS_LOAN_HEADERS_ALL loan,

4894: loan.OBJECT_VERSION_NUMBER,
4895: loan.LOAN_STATUS,
4896: head.DISBURSEMENT_NUMBER,
4897: nvl(loan.FUNDS_RESERVED_FLAG,'N')
4898: from LNS_LOAN_HEADERS_ALL loan,
4899: LNS_DISB_HEADERS head
4900: where head.DISB_HEADER_ID = P_DISB_HEADER_ID and
4901: head.LOAN_ID = loan.LOAN_ID;
4902:

Line 5107: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');

5103:
5104: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
5105:
5106: IF l_return_status = 'S' THEN
5107: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
5108: ELSE
5109: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
5110: FND_MSG_PUB.Add;
5111: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 5252: LNS_LOAN_HEADERS loan

5248: loan.secondary_status,
5249: loan.MULTIPLE_FUNDING_FLAG
5250: from LNS_DISB_LINES lines,
5251: LNS_DISB_HEADERS head,
5252: LNS_LOAN_HEADERS loan
5253: where lines.INVOICE_ID = P_INVOICE_ID and
5254: lines.DISB_HEADER_ID = head.DISB_HEADER_ID and
5255: lines.status is not null and lines.status <> 'FULLY_FUNDED' and
5256: head.LOAN_ID = loan.LOAN_ID;

Line 5636: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');

5632:
5633: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
5634:
5635: IF l_return_status = 'S' THEN
5636: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
5637: ELSE
5638: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
5639: FND_MSG_PUB.Add;
5640: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 5744: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');

5740:
5741: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
5742:
5743: IF l_return_status = 'S' THEN
5744: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
5745: ELSE
5746: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
5747: FND_MSG_PUB.Add;
5748: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 5954: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');

5950:
5951: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
5952:
5953: IF l_return_status = 'S' THEN
5954: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
5955: ELSE
5956: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
5957: FND_MSG_PUB.Add;
5958: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 6749: LNS_LOAN_HEADERS loan

6745: select head.DISB_HEADER_ID,
6746: loan.LOAN_STATUS,
6747: loan.OBJECT_VERSION_NUMBER
6748: from LNS_DISB_HEADERS head,
6749: LNS_LOAN_HEADERS loan
6750: where head.LOAN_ID = P_LOAN_ID and
6751: head.LOAN_ID = loan.LOAN_ID;
6752:
6753: -- getting number of already submitted disbursements

Line 6844: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');

6840:
6841: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
6842:
6843: IF l_return_status = 'S' THEN
6844: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
6845: ELSE
6846: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
6847: FND_MSG_PUB.Add;
6848: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 6974: from LNS_LOAN_HEADERS loan

6970:
6971: -- getting loan info
6972: CURSOR loan_info_cur(P_LOAN_ID number) IS
6973: select loan.OBJECT_VERSION_NUMBER
6974: from LNS_LOAN_HEADERS loan
6975: where loan.LOAN_ID = P_LOAN_ID;
6976:
6977: -- getting loan previous status
6978: CURSOR prev_status_cur(P_LOAN_ID number) IS

Line 6981: where table_name = 'LNS_LOAN_HEADERS_ALL' and

6977: -- getting loan previous status
6978: CURSOR prev_status_cur(P_LOAN_ID number) IS
6979: select old_value
6980: from lns_loan_histories_h
6981: where table_name = 'LNS_LOAN_HEADERS_ALL' and
6982: column_name = 'LOAN_STATUS' and
6983: new_value = 'PENDING_CANCELLATION' and
6984: loan_id = P_LOAN_ID and
6985: loan_history_id =

Line 6988: where table_name = 'LNS_LOAN_HEADERS_ALL' and

6984: loan_id = P_LOAN_ID and
6985: loan_history_id =
6986: (select max(loan_history_id)
6987: from lns_loan_histories_h
6988: where table_name = 'LNS_LOAN_HEADERS_ALL' and
6989: column_name = 'LOAN_STATUS' and
6990: loan_id = P_LOAN_ID);
6991:
6992: BEGIN

Line 7046: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');

7042:
7043: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
7044:
7045: IF l_return_status = 'S' THEN
7046: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
7047: ELSE
7048: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
7049: FND_MSG_PUB.Add;
7050: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 7161: from LNS_LOAN_HEADERS loan

7157:
7158: -- getting loan info
7159: CURSOR loan_info_cur(P_LOAN_ID number) IS
7160: select loan.OBJECT_VERSION_NUMBER
7161: from LNS_LOAN_HEADERS loan
7162: where loan.LOAN_ID = P_LOAN_ID;
7163:
7164: -- querying required approval flag
7165: CURSOR appr_flag_cur(P_LOAN_ID number) IS

Line 7168: lns_loan_headers_all loan

7164: -- querying required approval flag
7165: CURSOR appr_flag_cur(P_LOAN_ID number) IS
7166: select nvl(prod.APPR_REQ_FOR_CNCL_FLAG, 'N')
7167: from lns_loan_products_all prod,
7168: lns_loan_headers_all loan
7169: where loan.loan_id = P_LOAN_ID and
7170: loan.product_id = prod.loan_product_id;
7171: BEGIN
7172: LogMessage(FND_LOG.LEVEL_PROCEDURE, ' ');

Line 7228: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');

7224:
7225: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
7226:
7227: IF l_return_status = 'S' THEN
7228: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
7229: ELSE
7230: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
7231: FND_MSG_PUB.Add;
7232: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));