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_DISB_HEADERS

Line 131: WHEN ((select nvl(max(DISBURSEMENT_NUMBER), 0) + 1 from lns_disb_headers

127: WHEN (head.status = 'CANCELLED') THEN
128: 'N'
129: WHEN (head.status is null) THEN
130: CASE
131: WHEN ((select nvl(max(DISBURSEMENT_NUMBER), 0) + 1 from lns_disb_headers
132: where loan_id = head.loan_id and status = 'FULLY_FUNDED') = head.DISBURSEMENT_NUMBER) THEN
133: 'Y'
134: ELSE
135: 'N'

Line 142: from lns_disb_headers head,

138: -- END
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:

Line 206: WHEN ((select nvl(count(1), 0) from lns_disb_lines line, lns_disb_headers head

202: (nvl(loan.CURRENT_PHASE, 'TERM') = 'TERM' and
203: loan.MULTIPLE_FUNDING_FLAG = 'N' and loan.LOAN_STATUS = 'APPROVED'))
204: THEN
205: CASE
206: WHEN ((select nvl(count(1), 0) from lns_disb_lines line, lns_disb_headers head
207: where head.loan_id = loan.LOAN_ID and head.disb_header_id = line.disb_header_id and
208: (line.status is null or line.status = 'FUNDING_ERROR' or line.status = 'IN_FUNDING')) > 0) THEN
209: 'Y'
210: ELSE

Line 292: from lns_disb_headers head,

288: END
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:

Line 366: lns_disb_headers head,

362: 'N'
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;

Line 427: WHEN ((select max(DISBURSEMENT_NUMBER) from lns_disb_headers where loan_id = loan.loan_id) = head.DISBURSEMENT_NUMBER) THEN

423: select
424: CASE
425: WHEN (loan.current_phase = 'OPEN' and loan.OPEN_TO_TERM_FLAG = 'Y' and loan.OPEN_TO_TERM_EVENT = 'AUTO_FINAL_DISBURSEMENT') THEN
426: CASE
427: WHEN ((select max(DISBURSEMENT_NUMBER) from lns_disb_headers where loan_id = loan.loan_id) = head.DISBURSEMENT_NUMBER) THEN
428: 'Y'
429: ELSE
430: 'N'
431: END

Line 435: from lns_disb_headers head,

431: END
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:

Line 469: | P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC

465: | P_API_VERSION IN Standard in parameter
466: | P_INIT_MSG_LIST IN Standard in parameter
467: | P_COMMIT IN Standard in parameter
468: | P_VALIDATION_LEVEL IN Standard in parameter
469: | P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC
470: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
471: | X_MSG_COUNT OUT NOCOPY Standard out parameter
472: | X_MSG_DATA OUT NOCOPY Standard out parameter
473: |

Line 491: P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC,

487: P_API_VERSION IN NUMBER,
488: P_INIT_MSG_LIST IN VARCHAR2,
489: P_COMMIT IN VARCHAR2,
490: P_VALIDATION_LEVEL IN NUMBER,
491: P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC,
492: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
493: X_MSG_COUNT OUT NOCOPY NUMBER,
494: X_MSG_DATA OUT NOCOPY VARCHAR2)
495: IS

Line 565: LNS_DISB_HEADERS_PKG.Insert_Row(

561:
562: end if;
563:
564: -- calling table handler api
565: LNS_DISB_HEADERS_PKG.Insert_Row(
566: X_DISB_HEADER_ID => l_pk_id,
567: P_LOAN_ID => P_DISB_HEADER_REC.LOAN_ID,
568: P_ACTIVITY_CODE => P_DISB_HEADER_REC.ACTIVITY_CODE,
569: P_DISBURSEMENT_NUMBER => P_DISB_HEADER_REC.DISBURSEMENT_NUMBER,

Line 640: | P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC

636: | P_API_VERSION IN Standard in parameter
637: | P_INIT_MSG_LIST IN Standard in parameter
638: | P_COMMIT IN Standard in parameter
639: | P_VALIDATION_LEVEL IN Standard in parameter
640: | P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC
641: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
642: | X_MSG_COUNT OUT NOCOPY Standard out parameter
643: | X_MSG_DATA OUT NOCOPY Standard out parameter
644: |

Line 662: P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC,

658: P_API_VERSION IN NUMBER,
659: P_INIT_MSG_LIST IN VARCHAR2,
660: P_COMMIT IN VARCHAR2,
661: P_VALIDATION_LEVEL IN NUMBER,
662: P_DISB_HEADER_REC IN LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC,
663: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
664: X_MSG_COUNT OUT NOCOPY NUMBER,
665: X_MSG_DATA OUT NOCOPY VARCHAR2)
666: IS

Line 686: from lns_disb_headers

682:
683: -- getting disbursement header info from db
684: CURSOR disb_head_cur(P_DISB_HEADER_ID number) IS
685: select OBJECT_VERSION_NUMBER
686: from lns_disb_headers
687: where disb_header_id = P_DISB_HEADER_ID;
688: -- FOR UPDATE OF disb_header_id NOWAIT;
689:
690: BEGIN

Line 763: FND_MESSAGE.SET_TOKEN('TABLE', 'LNS_DISB_HEADERS');

759: if l_disb_header_version <> P_DISB_HEADER_REC.OBJECT_VERSION_NUMBER then
760:
761: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement header record has already been changed');
762: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
763: FND_MESSAGE.SET_TOKEN('TABLE', 'LNS_DISB_HEADERS');
764: FND_MSG_PUB.ADD;
765: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
766: RAISE FND_API.G_EXC_ERROR;
767:

Line 773: LNS_DISB_HEADERS_PKG.Update_Row(

769:
770: l_disb_header_version := nvl(l_disb_header_version, 1) + 1;
771:
772: -- calling table handler api
773: LNS_DISB_HEADERS_PKG.Update_Row(
774: P_DISB_HEADER_ID => P_DISB_HEADER_REC.DISB_HEADER_ID,
775: P_LOAN_ID => P_DISB_HEADER_REC.LOAN_ID,
776: P_ACTIVITY_CODE => P_DISB_HEADER_REC.ACTIVITY_CODE,
777: P_DISBURSEMENT_NUMBER => P_DISB_HEADER_REC.DISBURSEMENT_NUMBER,

Line 893: from lns_disb_headers

889:
890: -- getting disbursement header info from db
891: CURSOR disb_head_cur(P_DISB_HEADER_ID number) IS
892: select status
893: from lns_disb_headers
894: where disb_header_id = P_DISB_HEADER_ID;
895:
896: -- getting disbursement lines
897: CURSOR disb_line_cur(P_DISB_HEADER_ID number) IS

Line 1000: LNS_DISB_HEADERS_PKG.Delete_Row(P_DISB_HEADER_ID);

996: LNS_FEE_ASSIGNMENT_PUB.delete_DISB_FEE_ASSIGNMENT(P_DISB_HEADER_ID);
997: LNS_COND_ASSIGNMENT_PUB.delete_DISB_COND_ASSIGNMENT(P_DISB_HEADER_ID);
998:
999: -- calling table handler api
1000: LNS_DISB_HEADERS_PKG.Delete_Row(P_DISB_HEADER_ID);
1001:
1002: if P_COMMIT = FND_API.G_TRUE then
1003: COMMIT WORK;
1004: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Commited');

Line 1516: from lns_disb_headers hdr,

1512:
1513: -- getting disbursement header and line info from db
1514: CURSOR disb_head_cur(P_DISB_LINE_ID number) IS
1515: select hdr.status
1516: from lns_disb_headers hdr,
1517: lns_disb_lines ln
1518: where hdr.disb_header_id = ln.disb_header_id and
1519: ln.disb_line_id = P_DISB_LINE_ID;
1520:

Line 1694: LNS_DISB_HEADERS head,

1690: CURSOR payees_cur(P_DISB_HEADER_ID number) IS
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

Line 1856: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

1852: l_loan_maturity_date date;
1853: l_party_site_id number;
1854: l_due_date date;
1855:
1856: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
1857: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
1858:
1859: /*-----------------------------------------------------------------------+
1860: | Cursor Declarations |

Line 1878: from LNS_DISB_HEADERS head,

1874: head.STATUS,
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;

Line 1897: LNS_DISB_HEADERS head

1893: line.PAYMENT_METHOD_CODE,
1894: line.REQUEST_DATE,
1895: nvl(head.PAYMENT_REQUEST_DATE, head.TARGET_DATE)
1896: from LNS_DISB_LINES line,
1897: LNS_DISB_HEADERS head
1898: where line.DISB_HEADER_ID = P_DISB_HEADER_ID and
1899: line.DISB_HEADER_ID = head.DISB_HEADER_ID
1900: order by line.DISB_LINE_NUMBER;
1901:

Line 2300: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

2296: l_msg_data VARCHAR2(32767);
2297: l_no_pay_mtd_count NUMBER;
2298: l_open_start_date DATE;
2299:
2300: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
2301:
2302: /*-----------------------------------------------------------------------+
2303: | Cursor Declarations |
2304: +-----------------------------------------------------------------------*/

Line 2316: from LNS_DISB_HEADERS head,

2312: head.PAYMENT_REQUEST_DATE,
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:

Line 2559: LNS_DISB_HEADERS head,

2555: loan.ORG_ID,
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

Line 2884: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

2880: l_loan_maturity_date date;
2881: l_loan_status varchar2(30);
2882: l_move_maturity_date number;
2883:
2884: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
2885: TYPE DISB_HEADERS_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC INDEX BY BINARY_INTEGER;
2886: l_DISB_HEADERS_TBL DISB_HEADERS_TBL;
2887:
2888: /*-----------------------------------------------------------------------+

Line 2885: TYPE DISB_HEADERS_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC INDEX BY BINARY_INTEGER;

2881: l_loan_status varchar2(30);
2882: l_move_maturity_date number;
2883:
2884: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
2885: TYPE DISB_HEADERS_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC INDEX BY BINARY_INTEGER;
2886: l_DISB_HEADERS_TBL DISB_HEADERS_TBL;
2887:
2888: /*-----------------------------------------------------------------------+
2889: | Cursor Declarations |

Line 2910: from LNS_DISB_HEADERS head,

2906: decode(nvl(loan.CURRENT_PHASE, 'TERM'), 'TERM', loan.LOAN_START_DATE, loan.OPEN_LOAN_START_DATE),
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;

Line 2921: (select trunc(max(PAYMENT_REQUEST_DATE)) from LNS_DISB_HEADERS where LOAN_ID = loan.LOAN_ID))

2917: select
2918: CASE
2919: WHEN (nvl(loan.CURRENT_PHASE, 'TERM') = 'OPEN') THEN
2920: sign(trunc(loan.OPEN_MATURITY_DATE) -
2921: (select trunc(max(PAYMENT_REQUEST_DATE)) from LNS_DISB_HEADERS where LOAN_ID = loan.LOAN_ID))
2922: WHEN (nvl(loan.CURRENT_PHASE, 'TERM') = 'TERM' and loan.MULTIPLE_FUNDING_FLAG = 'N') THEN
2923: sign(trunc(loan.LOAN_MATURITY_DATE) -
2924: (select trunc(max(PAYMENT_REQUEST_DATE)) from LNS_DISB_HEADERS where LOAN_ID = loan.LOAN_ID))
2925: ELSE

Line 2924: (select trunc(max(PAYMENT_REQUEST_DATE)) from LNS_DISB_HEADERS where LOAN_ID = loan.LOAN_ID))

2920: sign(trunc(loan.OPEN_MATURITY_DATE) -
2921: (select trunc(max(PAYMENT_REQUEST_DATE)) from LNS_DISB_HEADERS where LOAN_ID = loan.LOAN_ID))
2922: WHEN (nvl(loan.CURRENT_PHASE, 'TERM') = 'TERM' and loan.MULTIPLE_FUNDING_FLAG = 'N') THEN
2923: sign(trunc(loan.LOAN_MATURITY_DATE) -
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

Line 3489: FOR Disb_Rec in (SELECT lns_disb_headers_s.NEXTVAL disb_header_id

3485: IF l_return_status = 'S' THEN
3486: l_payment_method_code := l_Default_Pmt_Attrs_Rec.Payment_Method.Payment_Method_Code;
3487: l_bank_account_id := l_Default_Pmt_Attrs_Rec.Payee_BankAccount.Payee_BankAccount_Id;
3488: END IF;
3489: FOR Disb_Rec in (SELECT lns_disb_headers_s.NEXTVAL disb_header_id
3490: , loan_product_lines_id
3491: , activity_code
3492: , disb_percent
3493: , sequence_number

Line 3504: from lns_disb_headers ldh

3500: AND lpl.LOAN_PRODUCT_LINE_TYPE = 'DISBURSEMENT'
3501: AND SYSDATE BETWEEN NVL(lpl.start_date_active,SYSDATE)
3502: AND NVL(lpl.end_date_active,SYSDATE)
3503: AND NOT EXISTS (select 1
3504: from lns_disb_headers ldh
3505: where ldh.loan_id = llh.loan_id)) LOOP
3506:
3507: -- Default Product Disbursements
3508: LNS_DISB_HEADERS_PKG.Insert_Row(

Line 3508: LNS_DISB_HEADERS_PKG.Insert_Row(

3504: from lns_disb_headers ldh
3505: where ldh.loan_id = llh.loan_id)) LOOP
3506:
3507: -- Default Product Disbursements
3508: LNS_DISB_HEADERS_PKG.Insert_Row(
3509: X_DISB_HEADER_ID => Disb_Rec.disb_header_id,
3510: P_LOAN_ID => p_loan_id,
3511: P_ACTIVITY_CODE => Disb_Rec.activity_code,
3512: P_DISBURSEMENT_NUMBER => Disb_Rec.sequence_number,

Line 3609: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

3605: l_api_version CONSTANT NUMBER := 1.0;
3606: l_return_status VARCHAR2(1);
3607: l_msg_count NUMBER;
3608: l_msg_data VARCHAR2(32767);
3609: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
3610: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
3611:
3612: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;
3613: l_DISB_LINES_TBL DISB_LINES_TBL;

Line 3688: LNS_DISB_HEADERS head,

3684: loan.ORG_ID,
3685: loan.LEGAL_ENTITY_ID,
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

Line 4719: from LNS_DISB_HEADERS

4715: -- getting disbursement header info
4716: CURSOR disb_headers_cur(P_LOAN_ID number) IS
4717: select DISB_HEADER_ID,
4718: nvl(AUTOFUNDING_FLAG, 'N')
4719: from LNS_DISB_HEADERS
4720: where LOAN_ID = P_LOAN_ID and
4721: DISBURSEMENT_NUMBER = 1;
4722:
4723: BEGIN

Line 4848: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

4844: l_api_version CONSTANT NUMBER := 1.0;
4845: l_return_status VARCHAR2(1);
4846: l_msg_count NUMBER;
4847: l_msg_data VARCHAR2(32767);
4848: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
4849: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
4850:
4851: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;
4852: l_DISB_LINES_TBL DISB_LINES_TBL;

Line 4899: LNS_DISB_HEADERS head

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:
4903: -- checking for conditions

Line 5220: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

5216: l_last_api_called varchar2(500);
5217:
5218:
5219: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
5220: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
5221: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
5222: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;
5223: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
5224: l_event_table lns_distributions_pub.acc_event_tbl;

Line 5251: LNS_DISB_HEADERS head,

5247: head.DISBURSEMENT_NUMBER,
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

Line 5277: LNS_DISB_HEADERS head,

5273: -- getting sum of all disbursed amount for this loan from ap_invoices_all - real situation
5274: CURSOR disb_amount_cur(P_LOAN_ID number) IS
5275: select nvl(sum(inv.amount_paid), 0)
5276: from LNS_DISB_LINES lines,
5277: LNS_DISB_HEADERS head,
5278: ap_invoices_all inv
5279: where head.LOAN_ID = P_LOAN_ID and
5280: lines.DISB_HEADER_ID = head.DISB_HEADER_ID and
5281: lines.invoice_id is not null and

Line 5288: LNS_DISB_HEADERS head

5284: -- getting sum of all disbursed amount for this loan from lns_disb_lines - testing
5285: CURSOR disb_amount_cur1(P_LOAN_ID number) IS
5286: select nvl(sum(lines.LINE_AMOUNT), 0)
5287: from LNS_DISB_LINES lines,
5288: LNS_DISB_HEADERS head
5289: where head.LOAN_ID = P_LOAN_ID and
5290: lines.DISB_HEADER_ID = head.DISB_HEADER_ID and
5291: (lines.STATUS is not null and lines.STATUS = 'FULLY_FUNDED') and
5292: lines.DISBURSEMENT_DATE is not null;

Line 5318: OR disb_header_id in (select disb_header_id from lns_disb_headers where loan_id = P_LOAN_ID) -- Bug#6613647

5314: and billing_option = 'ORIGINATION'
5315: and (loan_id = P_LOAN_ID
5316: -- Bug#6613647, The loanId is NULL if for the disbFees in lns_fee_assignments.
5317: -- So to check any existed 0th installment fees for a loan, also check existed fees for disb_header_id.
5318: OR disb_header_id in (select disb_header_id from lns_disb_headers where loan_id = P_LOAN_ID) -- Bug#6613647
5319: );
5320:
5321: -- get invoice payment amount
5322: CURSOR inv_paid_amount_cur(P_INVOICE_ID number) IS

Line 6268: LNS_DISB_HEADERS head

6264: -- getting all available disbursements
6265: CURSOR avail_disb_cur(P_LOAN_ID number) IS
6266: select line.INVOICE_ID
6267: from LNS_DISB_LINES line,
6268: LNS_DISB_HEADERS head
6269: where head.LOAN_ID = P_LOAN_ID and
6270: head.DISB_HEADER_ID = line.DISB_HEADER_ID and
6271: line.status is not null and
6272: line.status = 'IN_FUNDING' and

Line 6433: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

6429: l_success boolean;
6430: l_success_str varchar2(10);
6431:
6432: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
6433: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
6434:
6435: /*-----------------------------------------------------------------------+
6436: | Cursor Declarations |
6437: +-----------------------------------------------------------------------*/

Line 6447: from LNS_DISB_HEADERS head

6443: (select count(1)
6444: from lns_disb_lines
6445: where DISB_HEADER_ID = head.DISB_HEADER_ID and
6446: status <> 'CANCELLED')
6447: from LNS_DISB_HEADERS head
6448: where head.DISB_HEADER_ID = P_DISB_HEADER_ID;
6449:
6450: -- getting disbursement lines info
6451: CURSOR disb_lines_cur(P_DISB_HEADER_ID number) IS

Line 6748: from LNS_DISB_HEADERS head,

6744: CURSOR avail_disb_cur(P_LOAN_ID number) IS
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:

Line 6756: from LNS_DISB_HEADERS head

6752:
6753: -- getting number of already submitted disbursements
6754: CURSOR submitted_disb_cur(P_LOAN_ID number) IS
6755: select count(head.DISB_HEADER_ID)
6756: from LNS_DISB_HEADERS head
6757: where head.LOAN_ID = P_LOAN_ID and
6758: head.status <> 'CANCELLED';
6759:
6760: BEGIN

Line 7789: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;

7785: l_DISB_HEADER_ID NUMBER;
7786: l_OBJECT_VERSION_NUMBER NUMBER;
7787: l_cond_count number;
7788:
7789: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
7790:
7791: /*-----------------------------------------------------------------------+
7792: | Cursor Declarations |
7793: +-----------------------------------------------------------------------*/

Line 7800: from LNS_DISB_HEADERS

7796: CURSOR disb_headers_cur(P_LOAN_ID number) IS
7797: select
7798: DISB_HEADER_ID,
7799: OBJECT_VERSION_NUMBER
7800: from LNS_DISB_HEADERS
7801: where LOAN_ID = P_LOAN_ID and
7802: DISBURSEMENT_NUMBER = 1;
7803:
7804: -- checking for conditions

Line 7930: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully updated record into LNS_DISB_HEADERS');

7926: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Call to UPDATE_DISB_HEADER failed');
7927: RAISE FND_API.G_EXC_ERROR;
7928: END IF;
7929:
7930: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully updated record into LNS_DISB_HEADERS');
7931:
7932: if P_COMMIT = FND_API.G_TRUE then
7933: COMMIT WORK;
7934: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Commited');

Line 8636: LNS_DISB_HEADERS head

8632: -- querying disbursement lines info
8633: CURSOR in_fund_count_cur(P_LOAN_ID number) IS
8634: select nvl(count(line.DISB_LINE_ID), 0)
8635: from LNS_DISB_LINES line,
8636: LNS_DISB_HEADERS head
8637: where head.LOAN_ID = P_LOAN_ID and
8638: line.DISB_HEADER_ID = head.DISB_HEADER_ID and
8639: line.status is not null and
8640: line.status = 'IN_FUNDING';