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_LINES

Line 119: WHEN ((select nvl(count(1), 0) from lns_disb_lines

115: WHEN (head.status = 'FULLY_FUNDED') THEN
116: 'N'
117: WHEN (head.status = 'PARTIALLY_FUNDED') THEN
118: CASE
119: WHEN ((select nvl(count(1), 0) from lns_disb_lines
120: where disb_header_id = head.DISB_HEADER_ID and (status is null or status = 'FUNDING_ERROR')) > 0) THEN
121: 'Y'
122: ELSE
123: 'N'

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 280: WHEN ((select nvl(count(1), 0) from lns_disb_lines

276: WHEN (head.status is not null and (head.status = 'FULLY_FUNDED' or head.status = 'CANCELLED' or head.status = 'IN_FUNDING')) THEN
277: 'Y'
278: WHEN (head.status is not null and head.status = 'PARTIALLY_FUNDED') THEN
279: CASE
280: WHEN ((select nvl(count(1), 0) from lns_disb_lines
281: where disb_header_id = head.DISB_HEADER_ID and (status is null or status = 'FUNDING_ERROR')) > 0) THEN
282: 'N'
283: ELSE
284: 'Y'

Line 365: from lns_disb_lines line,

361: ELSE
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

Line 900: from LNS_DISB_LINES

896: -- getting disbursement lines
897: CURSOR disb_line_cur(P_DISB_HEADER_ID number) IS
898: select
899: DISB_LINE_ID
900: from LNS_DISB_LINES
901: where DISB_HEADER_ID = P_DISB_HEADER_ID;
902:
903: BEGIN
904:

Line 1062: | P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC

1058: | P_API_VERSION IN Standard in parameter
1059: | P_INIT_MSG_LIST IN Standard in parameter
1060: | P_COMMIT IN Standard in parameter
1061: | P_VALIDATION_LEVEL IN Standard in parameter
1062: | P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC
1063: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
1064: | X_MSG_COUNT OUT NOCOPY Standard out parameter
1065: | X_MSG_DATA OUT NOCOPY Standard out parameter
1066: |

Line 1084: P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC,

1080: P_API_VERSION IN NUMBER,
1081: P_INIT_MSG_LIST IN VARCHAR2,
1082: P_COMMIT IN VARCHAR2,
1083: P_VALIDATION_LEVEL IN NUMBER,
1084: P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC,
1085: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1086: X_MSG_COUNT OUT NOCOPY NUMBER,
1087: X_MSG_DATA OUT NOCOPY VARCHAR2)
1088: IS

Line 1178: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_DISB_LINES_PKG.Insert_Row');

1174: RAISE FND_API.G_EXC_ERROR;
1175:
1176: end if;
1177:
1178: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_DISB_LINES_PKG.Insert_Row');
1179:
1180: -- calling table handler api
1181: LNS_DISB_LINES_PKG.Insert_Row(
1182: X_DISB_LINE_ID => l_pk_id,

Line 1181: LNS_DISB_LINES_PKG.Insert_Row(

1177:
1178: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_DISB_LINES_PKG.Insert_Row');
1179:
1180: -- calling table handler api
1181: LNS_DISB_LINES_PKG.Insert_Row(
1182: X_DISB_LINE_ID => l_pk_id,
1183: P_DISB_HEADER_ID => P_DISB_LINE_REC.DISB_HEADER_ID,
1184: P_DISB_LINE_NUMBER => P_DISB_LINE_REC.DISB_LINE_NUMBER,
1185: P_LINE_AMOUNT => P_DISB_LINE_REC.LINE_AMOUNT,

Line 1259: | P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC

1255: | P_API_VERSION IN Standard in parameter
1256: | P_INIT_MSG_LIST IN Standard in parameter
1257: | P_COMMIT IN Standard in parameter
1258: | P_VALIDATION_LEVEL IN Standard in parameter
1259: | P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC
1260: | X_RETURN_STATUS OUT NOCOPY Standard out parameter
1261: | X_MSG_COUNT OUT NOCOPY Standard out parameter
1262: | X_MSG_DATA OUT NOCOPY Standard out parameter
1263: |

Line 1281: P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC,

1277: P_API_VERSION IN NUMBER,
1278: P_INIT_MSG_LIST IN VARCHAR2,
1279: P_COMMIT IN VARCHAR2,
1280: P_VALIDATION_LEVEL IN NUMBER,
1281: P_DISB_LINE_REC IN LNS_FUNDING_PUB.LNS_DISB_LINES_REC,
1282: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1283: X_MSG_COUNT OUT NOCOPY NUMBER,
1284: X_MSG_DATA OUT NOCOPY VARCHAR2)
1285: IS

Line 1305: from lns_disb_lines

1301:
1302: -- getting disbursement line info from db
1303: CURSOR disb_line_cur(P_DISB_LINE_ID number) IS
1304: select OBJECT_VERSION_NUMBER
1305: from lns_disb_lines
1306: where disb_line_id = P_DISB_LINE_ID;
1307: -- FOR UPDATE OF disb_line_id NOWAIT;
1308:
1309: BEGIN

Line 1384: FND_MESSAGE.SET_TOKEN('TABLE', 'LNS_DISB_LINES');

1380: if l_disb_line_version <> P_DISB_LINE_REC.OBJECT_VERSION_NUMBER then
1381:
1382: -- LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Disbursement line record has already been changed');
1383: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
1384: FND_MESSAGE.SET_TOKEN('TABLE', 'LNS_DISB_LINES');
1385: FND_MSG_PUB.ADD;
1386: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1387: RAISE FND_API.G_EXC_ERROR;
1388:

Line 1394: LNS_DISB_LINES_PKG.Update_Row(

1390:
1391: l_disb_line_version := nvl(l_disb_line_version, 1) + 1;
1392:
1393: -- calling table handler api
1394: LNS_DISB_LINES_PKG.Update_Row(
1395: P_DISB_LINE_ID => P_DISB_LINE_REC.DISB_LINE_ID,
1396: P_DISB_HEADER_ID => P_DISB_LINE_REC.DISB_HEADER_ID,
1397: P_DISB_LINE_NUMBER => P_DISB_LINE_REC.DISB_LINE_NUMBER,
1398: P_LINE_AMOUNT => P_DISB_LINE_REC.LINE_AMOUNT,

Line 1517: lns_disb_lines ln

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:
1521: BEGIN

Line 1591: LNS_DISB_LINES_PKG.Delete_Row(P_DISB_LINE_ID);

1587:
1588: end if;
1589:
1590: -- calling table handler api
1591: LNS_DISB_LINES_PKG.Delete_Row(P_DISB_LINE_ID);
1592:
1593: if P_COMMIT = FND_API.G_TRUE then
1594: COMMIT WORK;
1595: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Commited');

Line 1693: from LNS_DISB_LINES line,

1689: -- getting payees
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

Line 1857: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;

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 |
1861: +-----------------------------------------------------------------------*/

Line 1896: from LNS_DISB_LINES line,

1892: line.BANK_ACCOUNT_ID,
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;

Line 2314: (select count(1) from lns_disb_lines where disb_header_id = head.DISB_HEADER_ID and

2310: head.HEADER_AMOUNT,
2311: head.HEADER_PERCENT,
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

Line 2528: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;

2524: l_disb_number number;
2525: l_due_date date;
2526: l_party_site_id number;
2527:
2528: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
2529: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;
2530: l_DISB_LINES_TBL DISB_LINES_TBL;
2531:
2532:

Line 2529: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;

2525: l_due_date date;
2526: l_party_site_id number;
2527:
2528: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;
2529: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;
2530: l_DISB_LINES_TBL DISB_LINES_TBL;
2531:
2532:
2533: /*-----------------------------------------------------------------------+

Line 2558: from LNS_DISB_LINES line,

2554: loan.LOAN_CURRENCY,
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

Line 3439: l_payment_method_code lns_disb_lines.payment_method_code%TYPE;

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);
3443: l_msg_count number;

Line 3440: l_bank_account_id lns_disb_lines.bank_account_id%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);
3443: l_msg_count number;
3444: l_msg_data varchar2(4000);

Line 3441: l_payee_party_id lns_disb_lines.payee_party_id%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);
3443: l_msg_count number;
3444: l_msg_data varchar2(4000);
3445: BEGIN

Line 3495: , lns_disb_lines_s.NEXTVAL disb_line_id

3491: , activity_code
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

Line 3516: LNS_DISB_LINES_PKG.Insert_Row(

3512: P_DISBURSEMENT_NUMBER => Disb_Rec.sequence_number,
3513: P_HEADER_PERCENT => Disb_Rec.disb_percent,
3514: P_OBJECT_VERSION_NUMBER => 1);
3515:
3516: LNS_DISB_LINES_PKG.Insert_Row(
3517: X_DISB_LINE_ID => Disb_Rec.disb_line_id,
3518: P_DISB_HEADER_ID => Disb_Rec.disb_header_id,
3519: P_DISB_LINE_NUMBER => 1,
3520: P_LINE_PERCENT => 100,

Line 3610: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;

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

Line 3612: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;

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;
3614:
3615: l_org_id number;
3616: l_invoice_line_id number;

Line 3687: from LNS_DISB_LINES line,

3683: loan.LOAN_CURRENCY,
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

Line 4849: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;

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

Line 4851: TYPE DISB_LINES_TBL IS TABLE OF LNS_FUNDING_PUB.LNS_DISB_LINES_REC INDEX BY BINARY_INTEGER;

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;
4853:
4854: l_loan_number varchar2(60);
4855: l_Count number;

Line 4886: from LNS_DISB_LINES

4882: PAYMENT_METHOD_CODE,
4883: STATUS,
4884: REQUEST_DATE,
4885: OBJECT_VERSION_NUMBER
4886: from LNS_DISB_LINES
4887: where DISB_HEADER_ID = P_DISB_HEADER_ID and
4888: (status is null or status = 'FUNDING_ERROR');
4889:
4890: -- query loan details

Line 5219: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;

5215: l_iso_territory FND_LANGUAGES.iso_territory%TYPE;
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;

Line 5250: from LNS_DISB_LINES lines,

5246: loan.loan_status,
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

Line 5260: select count(1) from LNS_DISB_LINES

5256: head.LOAN_ID = loan.LOAN_ID;
5257:
5258: -- getting partially or fully funded lines count
5259: CURSOR c_funded_lines_count_cur(P_DISB_HEADER_ID number) IS
5260: select count(1) from LNS_DISB_LINES
5261: where DISB_HEADER_ID = P_DISB_HEADER_ID and STATUS IN ('FULLY_FUNDED', 'PARTIALLY_FUNDED');
5262:
5263: -- getting diff between total lines count and fully funded lines
5264: CURSOR funded_count_cur(P_DISB_HEADER_ID number) IS

Line 5266: (select count(1) from LNS_DISB_LINES

5262:
5263: -- getting diff between total lines count and fully funded lines
5264: CURSOR funded_count_cur(P_DISB_HEADER_ID number) IS
5265: select
5266: (select count(1) from LNS_DISB_LINES
5267: where DISB_HEADER_ID = P_DISB_HEADER_ID)
5268: -
5269: (select count(1) from LNS_DISB_LINES
5270: where DISB_HEADER_ID = P_DISB_HEADER_ID and (STATUS is not null and STATUS = 'FULLY_FUNDED'))

Line 5269: (select count(1) from LNS_DISB_LINES

5265: select
5266: (select count(1) from LNS_DISB_LINES
5267: where DISB_HEADER_ID = P_DISB_HEADER_ID)
5268: -
5269: (select count(1) from LNS_DISB_LINES
5270: where DISB_HEADER_ID = P_DISB_HEADER_ID and (STATUS is not null and STATUS = 'FULLY_FUNDED'))
5271: from dual;
5272:
5273: -- getting sum of all disbursed amount for this loan from ap_invoices_all - real situation

Line 5276: from LNS_DISB_LINES lines,

5272:
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

Line 5284: -- getting sum of all disbursed amount for this loan from lns_disb_lines - testing

5280: lines.DISB_HEADER_ID = head.DISB_HEADER_ID and
5281: lines.invoice_id is not null and
5282: lines.invoice_id = inv.invoice_id;
5283:
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

Line 5287: from LNS_DISB_LINES lines,

5283:
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

Line 6267: from LNS_DISB_LINES line,

6263:
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

Line 6432: l_DISB_LINE_REC LNS_FUNDING_PUB.LNS_DISB_LINES_REC;

6428: l_Token varchar2(30);
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 |

Line 6444: from lns_disb_lines

6440: CURSOR disb_hdr_cur(P_DISB_HEADER_ID number) IS
6441: select head.DISB_HEADER_ID,
6442: head.OBJECT_VERSION_NUMBER,
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;

Line 6456: from LNS_DISB_LINES line

6452: select line.DISB_LINE_ID,
6453: line.OBJECT_VERSION_NUMBER,
6454: line.STATUS,
6455: line.INVOICE_ID
6456: from LNS_DISB_LINES line
6457: where line.DISB_HEADER_ID = P_DISB_HEADER_ID;
6458:
6459: -- getting last history record to update status
6460: CURSOR last_hist_rec_cur(P_DISB_LINE_ID number) IS

Line 8635: from LNS_DISB_LINES line,

8631:
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