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_ALL

Line 217: from lns_loan_headers_all loan

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

Line 294: lns_loan_headers_all loan

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

Line 368: lns_loan_headers_all loan

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

Line 437: lns_loan_headers_all loan

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

Line 1734: LNS_LOAN_HEADERS_ALL loan

1730: select line.PAYEE_PARTY_ID,
1731: loan.org_id
1732: from LNS_DISB_LINES line,
1733: LNS_DISB_HEADERS head,
1734: LNS_LOAN_HEADERS_ALL loan
1735: where head.DISB_HEADER_ID = P_DISB_HEADER_ID and
1736: head.DISB_HEADER_ID = line.DISB_HEADER_ID and
1737: head.loan_id = loan.loan_id and not exists
1738: (select PAYEE_PARTY_ID

Line 1929: LNS_LOAN_HEADERS_ALL loan

1925: head.TARGET_DATE,
1926: decode(nvl(loan.CURRENT_PHASE, 'TERM'), 'TERM', loan.LOAN_START_DATE, loan.OPEN_LOAN_START_DATE),
1927: loan.OPEN_MATURITY_DATE
1928: from LNS_DISB_HEADERS head,
1929: LNS_LOAN_HEADERS_ALL loan
1930: where loan.LOAN_ID = P_LOAN_ID and
1931: head.LOAN_ID = loan.LOAN_ID
1932: order by head.DISBURSEMENT_NUMBER;
1933:

Line 2382: LNS_LOAN_HEADERS_ALL loan

2378: decode(loan.current_phase, 'OPEN', loan.OPEN_LOAN_START_DATE, loan.LOAN_START_DATE),
2379: (select count(1) from lns_disb_lines where disb_header_id = head.DISB_HEADER_ID and
2380: PAYMENT_METHOD_CODE is null)
2381: from LNS_DISB_HEADERS head,
2382: LNS_LOAN_HEADERS_ALL loan
2383: where head.DISB_HEADER_ID = P_DISB_HEADER_ID and
2384: head.LOAN_ID = loan.LOAN_ID and
2385: nvl(loan.current_phase, 'TERM') = nvl(head.phase, 'OPEN');
2386:

Line 2629: LNS_LOAN_HEADERS_ALL loan

2625: loan.LEGAL_ENTITY_ID,
2626: nvl(head.PAYMENT_REQUEST_DATE, head.TARGET_DATE)
2627: from LNS_DISB_LINES line,
2628: LNS_DISB_HEADERS head,
2629: LNS_LOAN_HEADERS_ALL loan
2630: where line.DISB_HEADER_ID = P_DISB_HEADER_ID and
2631: line.DISB_HEADER_ID = head.DISB_HEADER_ID and
2632: head.LOAN_ID = loan.LOAN_ID
2633: order by line.DISB_LINE_ID;

Line 2983: LNS_LOAN_HEADERS_ALL loan

2979: head.payment_request_date,
2980: head.phase,
2981: head.description
2982: from LNS_DISB_HEADERS head,
2983: LNS_LOAN_HEADERS_ALL loan
2984: where loan.LOAN_ID = P_LOAN_ID and
2985: head.LOAN_ID = loan.LOAN_ID and
2986: nvl(loan.current_phase, 'TERM') = nvl(head.phase, 'OPEN')
2987: order by head.TARGET_DATE;

Line 3001: from lns_loan_headers_all loan

2997: (select trunc(max(PAYMENT_REQUEST_DATE)) from LNS_DISB_HEADERS where LOAN_ID = loan.LOAN_ID))
2998: ELSE
2999: 1
3000: END
3001: from lns_loan_headers_all loan
3002: where loan.LOAN_ID = P_LOAN_ID;
3003:
3004: BEGIN
3005:

Line 3541: l_org_id lns_loan_headers_all.org_id%TYPE;

3537: l_api_name CONSTANT VARCHAR2(30) := 'DEFAULT_PROD_DISBURSEMENTS';
3538: l_api_version CONSTANT NUMBER := 1.0;
3539: l_Trxn_Attributes_Rec IBY_DISBURSEMENT_COMP_PUB.Trxn_Attributes_Rec_Type;
3540: l_Default_Pmt_Attrs_Rec IBY_DISBURSEMENT_COMP_PUB.Default_Pmt_Attrs_Rec_Type;
3541: l_org_id lns_loan_headers_all.org_id%TYPE;
3542: l_legal_entity_id lns_Loan_headers_all.legal_entity_id%TYPE;
3543: l_payment_method_code lns_disb_lines.payment_method_code%TYPE;
3544: l_bank_account_id lns_disb_lines.bank_account_id%TYPE;
3545: l_payee_party_id lns_disb_lines.payee_party_id%TYPE;

Line 3542: l_legal_entity_id lns_Loan_headers_all.legal_entity_id%TYPE;

3538: l_api_version CONSTANT NUMBER := 1.0;
3539: l_Trxn_Attributes_Rec IBY_DISBURSEMENT_COMP_PUB.Trxn_Attributes_Rec_Type;
3540: l_Default_Pmt_Attrs_Rec IBY_DISBURSEMENT_COMP_PUB.Default_Pmt_Attrs_Rec_Type;
3541: l_org_id lns_loan_headers_all.org_id%TYPE;
3542: l_legal_entity_id lns_Loan_headers_all.legal_entity_id%TYPE;
3543: l_payment_method_code lns_disb_lines.payment_method_code%TYPE;
3544: l_bank_account_id lns_disb_lines.bank_account_id%TYPE;
3545: l_payee_party_id lns_disb_lines.payee_party_id%TYPE;
3546: l_return_status varchar2(1);

Line 3589: FROM lns_loan_headers_all llh

3585: ,l_legal_entity_id
3586: ,l_current_phase
3587: ,l_requested_amount
3588: ,l_currency
3589: FROM lns_loan_headers_all llh
3590: WHERE llh.loan_id = p_loan_id;
3591:
3592: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_payee_party_id: ' || l_payee_party_id);
3593: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_org_id: ' || l_org_id);

Line 3643: FROM lns_loan_headers_all llh, lns_loan_product_lines lpl

3639: , disb_percent
3640: , sequence_number
3641: , llh.primary_borrower_id payee_party_id
3642: , lns_disb_lines_s.NEXTVAL disb_line_id
3643: FROM lns_loan_headers_all llh, lns_loan_product_lines lpl
3644: WHERE llh.loan_id = p_loan_id
3645: -- AND llh.multiple_funding_flag = 'Y' Bug#6613708
3646: AND lpl.LOAN_PRODUCT_ID = llh.PRODUCT_ID
3647: AND lpl.LOAN_PRODUCT_LINE_TYPE = 'DISBURSEMENT'

Line 3868: LNS_LOAN_HEADERS_ALL loan

3864: line.TYPE_1099
3865: from LNS_DISB_LINES line,
3866: LNS_DISB_HEADERS head,
3867: lns_lookups lkp,
3868: LNS_LOAN_HEADERS_ALL loan
3869: where line.DISB_LINE_ID = P_DISB_LINE_ID and
3870: head.DISB_HEADER_ID = line.DISB_HEADER_ID and
3871: lkp.lookup_type(+) = 'DISB_ACTIVITY' and
3872: lkp.lookup_code(+) = head.ACTIVITY_CODE and

Line 4936: from LNS_LOAN_HEADERS_ALL loan,

4932: -- getting disbursement header info
4933: CURSOR disb_headers_cur(P_LOAN_ID number) IS
4934: select head.DISB_HEADER_ID,
4935: nvl(head.AUTOFUNDING_FLAG, 'N')
4936: from LNS_LOAN_HEADERS_ALL loan,
4937: LNS_DISB_HEADERS head
4938: where loan.LOAN_ID = P_LOAN_ID and
4939: loan.loan_id = head.loan_id and
4940: head.DISBURSEMENT_NUMBER = 1 and

Line 5134: from LNS_LOAN_HEADERS_ALL loan,

5130: loan.OBJECT_VERSION_NUMBER,
5131: loan.LOAN_STATUS,
5132: head.DISBURSEMENT_NUMBER,
5133: nvl(loan.FUNDS_RESERVED_FLAG,'N')
5134: from LNS_LOAN_HEADERS_ALL loan,
5135: LNS_DISB_HEADERS head
5136: where head.DISB_HEADER_ID = P_DISB_HEADER_ID and
5137: head.LOAN_ID = loan.LOAN_ID;
5138:

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

5361:
5362: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
5363:
5364: IF l_return_status = 'S' THEN
5365: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
5366: ELSE
5367: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
5368: FND_MSG_PUB.Add;
5369: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 5579: lns_loan_headers_all loan

5575: select nvl(sum(inv.amount_paid), 0)
5576: from LNS_DISB_LINES lines,
5577: LNS_DISB_HEADERS head,
5578: ap_invoices_all inv,
5579: lns_loan_headers_all loan
5580: where head.LOAN_ID = P_LOAN_ID and
5581: head.loan_id = loan.loan_id and
5582: --nvl(loan.current_phase, 'TERM') = nvl(head.phase, 'OPEN') and
5583: lines.DISB_HEADER_ID = head.DISB_HEADER_ID and

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

6106:
6107: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
6108:
6109: IF l_return_status = 'S' THEN
6110: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
6111: ELSE
6112: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
6113: FND_MSG_PUB.Add;
6114: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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

6148:
6149: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
6150:
6151: IF l_return_status = 'S' THEN
6152: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
6153: ELSE
6154: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
6155: FND_MSG_PUB.Add;
6156: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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

6271:
6272: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
6273:
6274: IF l_return_status = 'S' THEN
6275: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
6276: ELSE
6277: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
6278: FND_MSG_PUB.Add;
6279: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

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

7319:
7320: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
7321:
7322: IF l_return_status = 'S' THEN
7323: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
7324: ELSE
7325: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
7326: FND_MSG_PUB.Add;
7327: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 7462: where table_name = 'LNS_LOAN_HEADERS_ALL' and

7458: -- getting loan previous status
7459: CURSOR prev_status_cur(P_LOAN_ID number) IS
7460: select old_value
7461: from lns_loan_histories_h
7462: where table_name = 'LNS_LOAN_HEADERS_ALL' and
7463: column_name = 'LOAN_STATUS' and
7464: new_value = 'PENDING_CANCELLATION' and
7465: loan_id = P_LOAN_ID and
7466: loan_history_id =

Line 7469: where table_name = 'LNS_LOAN_HEADERS_ALL' and

7465: loan_id = P_LOAN_ID and
7466: loan_history_id =
7467: (select max(loan_history_id)
7468: from lns_loan_histories_h
7469: where table_name = 'LNS_LOAN_HEADERS_ALL' and
7470: column_name = 'LOAN_STATUS' and
7471: loan_id = P_LOAN_ID);
7472:
7473: BEGIN

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

7523:
7524: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
7525:
7526: IF l_return_status = 'S' THEN
7527: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
7528: ELSE
7529: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
7530: FND_MSG_PUB.Add;
7531: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 7649: lns_loan_headers_all loan

7645: -- querying required approval flag
7646: CURSOR appr_flag_cur(P_LOAN_ID number) IS
7647: select nvl(prod.APPR_REQ_FOR_CNCL_FLAG, 'N')
7648: from lns_loan_products_all prod,
7649: lns_loan_headers_all loan
7650: where loan.loan_id = P_LOAN_ID and
7651: loan.product_id = prod.loan_product_id;
7652: BEGIN
7653: LogMessage(FND_LOG.LEVEL_PROCEDURE, ' ');

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

7705:
7706: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
7707:
7708: IF l_return_status = 'S' THEN
7709: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully update LNS_LOAN_HEADERS_ALL');
7710: ELSE
7711: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
7712: FND_MSG_PUB.Add;
7713: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 8282: LNS_LOAN_HEADERS_ALL loan

8278: select
8279: head.DISB_HEADER_ID,
8280: head.OBJECT_VERSION_NUMBER
8281: from LNS_DISB_HEADERS head,
8282: LNS_LOAN_HEADERS_ALL loan
8283: where loan.LOAN_ID = P_LOAN_ID and
8284: head.LOAN_ID = loan.LOAN_ID and
8285: head.DISBURSEMENT_NUMBER = 1 and
8286: nvl(loan.current_phase, 'TERM') = nvl(head.phase, 'OPEN');

Line 9694: l_org_id lns_loan_headers_all.org_id%TYPE;

9690: l_msg_count NUMBER;
9691: l_msg_data VARCHAR2(32767);
9692: l_Trxn_Attributes_Rec IBY_DISBURSEMENT_COMP_PUB.Trxn_Attributes_Rec_Type;
9693: l_Default_Pmt_Attrs_Rec IBY_DISBURSEMENT_COMP_PUB.Default_Pmt_Attrs_Rec_Type;
9694: l_org_id lns_loan_headers_all.org_id%TYPE;
9695: l_legal_entity_id lns_Loan_headers_all.legal_entity_id%TYPE;
9696: l_payment_method_code lns_disb_lines.payment_method_code%TYPE;
9697: l_bank_account_id lns_disb_lines.bank_account_id%TYPE;
9698: l_payee_party_id lns_disb_lines.payee_party_id%TYPE;

Line 9695: l_legal_entity_id lns_Loan_headers_all.legal_entity_id%TYPE;

9691: l_msg_data VARCHAR2(32767);
9692: l_Trxn_Attributes_Rec IBY_DISBURSEMENT_COMP_PUB.Trxn_Attributes_Rec_Type;
9693: l_Default_Pmt_Attrs_Rec IBY_DISBURSEMENT_COMP_PUB.Default_Pmt_Attrs_Rec_Type;
9694: l_org_id lns_loan_headers_all.org_id%TYPE;
9695: l_legal_entity_id lns_Loan_headers_all.legal_entity_id%TYPE;
9696: l_payment_method_code lns_disb_lines.payment_method_code%TYPE;
9697: l_bank_account_id lns_disb_lines.bank_account_id%TYPE;
9698: l_payee_party_id lns_disb_lines.payee_party_id%TYPE;
9699: l_current_phase varchar2(30);

Line 9773: FROM lns_loan_headers_all llh

9769: ,l_org_id
9770: ,l_legal_entity_id
9771: ,l_current_phase
9772: ,l_currency
9773: FROM lns_loan_headers_all llh
9774: WHERE llh.loan_id = p_loan_id;
9775:
9776: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_payee_party_id: ' || l_payee_party_id);
9777: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_org_id: ' || l_org_id);