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_OCM_ADP_PUB dependencies on LNS_LOAN_HEADERS_ALL

Line 36: l_loan_req_amt lns_loan_headers_all.requested_amount%TYPE ;

32:
33: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
34: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
35:
36: l_loan_req_amt lns_loan_headers_all.requested_amount%TYPE ;
37: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;
38:
39: BEGIN
40:

Line 37: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

33: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
34: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
35:
36: l_loan_req_amt lns_loan_headers_all.requested_amount%TYPE ;
37: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;
38:
39: BEGIN
40:
41: x_resultout := FND_API.G_RET_STS_SUCCESS;

Line 45: FROM lns_loan_headers_all

41: x_resultout := FND_API.G_RET_STS_SUCCESS;
42: BEGIN
43: SELECT requested_amount , loan_currency
44: INTO l_loan_req_amt , l_loan_currency
45: FROM lns_loan_headers_all
46: WHERE loan_id = l_cr_loan_id ;
47:
48:
49: IF(l_cr_currency<>l_loan_currency) THEN

Line 107: l_loan_subtype lns_loan_headers_all.loan_subtype%TYPE ;

103: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
104:
105: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
106:
107: l_loan_subtype lns_loan_headers_all.loan_subtype%TYPE ;
108: l_loan_secured VARCHAR2(1) ;
109:
110:
111: BEGIN

Line 117: FROM lns_loan_headers_all

113: x_resultout := FND_API.G_RET_STS_SUCCESS;
114: BEGIN
115: SELECT loan_subtype
116: INTO l_loan_subtype
117: FROM lns_loan_headers_all
118: WHERE loan_id = l_cr_loan_id ;
119:
120: IF(l_loan_subtype = 'SECURED' ) THEN
121: l_loan_secured := 'Y' ;

Line 175: l_loan_collateral_perecent lns_loan_headers_all.collateral_percent%TYPE ;

171: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
172:
173: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
174:
175: l_loan_collateral_perecent lns_loan_headers_all.collateral_percent%TYPE ;
176:
177:
178: BEGIN
179:

Line 184: FROM lns_loan_headers_all

180: x_resultout := FND_API.G_RET_STS_SUCCESS;
181: BEGIN
182: SELECT collateral_percent
183: INTO l_loan_collateral_perecent
184: FROM lns_loan_headers_all
185: WHERE loan_id = l_cr_loan_id ;
186:
187:
188:

Line 248: lns_loan_headers_all llh ,

244: BEGIN
245: SELECT lrs.current_interest_rate
246: INTO l_initial_interest_rate
247: FROM lns_rate_schedules lrs,
248: lns_loan_headers_all llh ,
249: lns_terms lt
250: WHERE llh.loan_id = l_cr_loan_id
251: AND lt.loan_id = llh.loan_id
252: AND lrs.term_id = lt.term_id

Line 576: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

572: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
573: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
574:
575: l_req_coll_amount NUMBER ;
576: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;
577:
578:
579: BEGIN
580:

Line 587: FROM lns_loan_headers_all loan

583:
584: SELECT ( loan.requested_amount * nvl(loan.collateral_percent,0) / 100 ) ,
585: loan_currency
586: INTO l_req_coll_amount , l_loan_currency
587: FROM lns_loan_headers_all loan
588: WHERE loan.loan_id = l_cr_loan_id ;
589:
590:
591: IF(l_cr_currency<>l_loan_currency) THEN

Line 645: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

641: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
642: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
643:
644: l_total_coll_amount NUMBER ;
645: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;
646:
647:
648: BEGIN
649:

Line 659: FROM lns_loan_headers_all loan

655: where laa.loan_id = loan.loan_id
656: and (laa.end_date_active is null or trunc(laa.end_date_active) > trunc(sysdate))
657: and exists (select 1 from lns_assets la where la.asset_id = laa.asset_id)) , loan.loan_currency
658: INTO l_total_coll_amount , l_loan_currency
659: FROM lns_loan_headers_all loan
660: WHERE loan.loan_id = l_cr_loan_id ;
661:
662: IF(l_cr_currency<>l_loan_currency) THEN
663: l_total_coll_amount := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, null , l_total_coll_amount);

Line 718: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

714: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
715:
716:
717: l_deliquency_amount NUMBER ;
718: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;
719:
720:
721: BEGIN
722:

Line 727: FROM lns_terms lt , lns_loan_headers_all llh

723: x_resultout := FND_API.G_RET_STS_SUCCESS;
724: BEGIN
725: SELECT lt.delinquency_threshold_amount , llh.loan_currency
726: INTO l_deliquency_amount , l_loan_currency
727: FROM lns_terms lt , lns_loan_headers_all llh
728: WHERE llh.loan_id = l_cr_loan_id
729: AND lt.loan_id = llh.loan_id ;
730:
731:

Line 1121: FROM lns_loan_headers_all

1117: BEGIN
1118:
1119: SELECT count(*)
1120: INTO l_count_active_loans
1121: FROM lns_loan_headers_all
1122: WHERE loan_id IN ( SELECT loan_id
1123: FROM lns_participants
1124: WHERE hz_party_id = l_cr_party_id
1125: AND ( loan_participant_type = 'PRIMARY_BORROWER'

Line 1181: FROM lns_loan_headers_all llh ,

1177: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
1178:
1179: CURSOR active_loans_balance(C_PARTY_ID NUMBER) IS
1180: SELECT sum(lps.total_principal_balance) , llh.loan_currency
1181: FROM lns_loan_headers_all llh ,
1182: LNS_PAY_SUM_V lps
1183: WHERE llh.loan_id = lps.loan_id
1184: AND llh.loan_id IN ( SELECT loan_id
1185: FROM lns_participants

Line 1198: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

1194: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1195: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
1196:
1197: l_loan_balance_amt NUMBER ;
1198: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;
1199: l_total_balance_amt NUMBER ;
1200:
1201:
1202: BEGIN

Line 1286: FROM lns_loan_headers_all

1282: BEGIN
1283:
1284: SELECT count(*)
1285: INTO l_count_pending_loans
1286: FROM lns_loan_headers_all
1287: WHERE loan_id IN ( SELECT loan_id
1288: FROM lns_participants
1289: WHERE hz_party_id = l_cr_party_id
1290: AND ( loan_participant_type = 'PRIMARY_BORROWER'

Line 1346: FROM lns_loan_headers_all llh ,

1342:
1343:
1344: CURSOR pending_loans_balance(C_PARTY_ID NUMBER) IS
1345: SELECT sum(lps.total_principal_balance) , llh.loan_currency
1346: FROM lns_loan_headers_all llh ,
1347: LNS_PAY_SUM_V lps
1348: WHERE llh.loan_id = lps.loan_id
1349: AND llh.loan_id IN ( SELECT loan_id
1350: FROM lns_participants

Line 1363: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

1359: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1360: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
1361:
1362: l_loan_balance_amt NUMBER ;
1363: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;
1364: l_total_balance_amt NUMBER ;
1365:
1366:
1367: BEGIN

Line 1450: FROM lns_loan_headers_all

1446: BEGIN
1447:
1448: SELECT count(*)
1449: INTO l_count_delinquent_loans
1450: FROM lns_loan_headers_all
1451: WHERE loan_id IN ( SELECT loan_id
1452: FROM lns_participants
1453: WHERE hz_party_id = l_cr_party_id
1454: AND ( loan_participant_type = 'PRIMARY_BORROWER'

Line 1510: FROM lns_loan_headers_all llh ,

1506:
1507:
1508: CURSOR delinquent_loans_balance(C_PARTY_ID NUMBER) IS
1509: SELECT sum(lps.total_principal_balance) , llh.loan_currency
1510: FROM lns_loan_headers_all llh ,
1511: LNS_PAY_SUM_V lps
1512: WHERE llh.loan_id = lps.loan_id
1513: AND llh.loan_id IN ( SELECT loan_id
1514: FROM lns_participants

Line 1527: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

1523: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1524: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
1525:
1526: l_loan_balance_amt NUMBER ;
1527: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;
1528: l_total_balance_amt NUMBER ;
1529:
1530:
1531: BEGIN

Line 1615: FROM lns_loan_headers_all

1611: BEGIN
1612:
1613: SELECT count(*)
1614: INTO l_count_default_loans
1615: FROM lns_loan_headers_all
1616: WHERE loan_id IN ( SELECT loan_id
1617: FROM lns_participants
1618: WHERE hz_party_id = l_cr_party_id
1619: AND ( loan_participant_type = 'PRIMARY_BORROWER'

Line 1674: FROM lns_loan_headers_all llh ,

1670:
1671:
1672: CURSOR default_loans_balance(C_PARTY_ID NUMBER) IS
1673: SELECT sum(lps.total_principal_balance) , llh.loan_currency
1674: FROM lns_loan_headers_all llh ,
1675: LNS_PAY_SUM_V lps
1676: WHERE llh.loan_id = lps.loan_id
1677: AND llh.loan_id IN ( SELECT loan_id
1678: FROM lns_participants

Line 1691: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

1687: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1688: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
1689:
1690: l_loan_balance_amt NUMBER ;
1691: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;
1692: l_total_balance_amt NUMBER ;
1693:
1694:
1695: BEGIN

Line 1778: FROM lns_loan_headers_all

1774: BEGIN
1775:
1776: SELECT count(*)
1777: INTO l_count_paidoff_loans
1778: FROM lns_loan_headers_all
1779: WHERE loan_id IN ( SELECT loan_id
1780: FROM lns_participants
1781: WHERE hz_party_id = l_cr_party_id
1782: AND ( loan_participant_type = 'PRIMARY_BORROWER'

Line 1837: FROM lns_loan_headers_all llh ,

1833:
1834:
1835: CURSOR paidoff_loans_balance(C_PARTY_ID NUMBER) IS
1836: SELECT sum(lps.total_principal_balance) , llh.loan_currency
1837: FROM lns_loan_headers_all llh ,
1838: LNS_PAY_SUM_V lps
1839: WHERE llh.loan_id = lps.loan_id
1840: AND llh.loan_id IN ( SELECT loan_id
1841: FROM lns_participants

Line 1854: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

1850: l_cr_party_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_party_id ) ;
1851: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
1852:
1853: l_loan_balance_amt NUMBER ;
1854: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;
1855: l_total_balance_amt NUMBER ;
1856:
1857:
1858: BEGIN

Line 1947: FROM lns_loan_headers_all

1943: BEGIN
1944:
1945: SELECT count(*)
1946: INTO l_total_active_loans
1947: FROM lns_loan_headers_all
1948: WHERE loan_id IN ( SELECT loan_id
1949: FROM lns_participants
1950: WHERE hz_party_id IN ( SELECT hz_party_id
1951: FROM lns_participants

Line 2028: FROM lns_loan_headers_all llh ,

2024:
2025:
2026: CURSOR total_active_loans_balance(C_LOAN_ID NUMBER , C_PARTY_ID NUMBER) IS
2027: SELECT sum( nvl(lps.total_principal_balance,0) ) , llh.loan_currency
2028: FROM lns_loan_headers_all llh ,
2029: LNS_PAY_SUM_V lps
2030: WHERE llh.loan_id = lps.loan_id
2031: AND llh.loan_id IN ( SELECT loan_id
2032: FROM lns_participants

Line 2059: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

2055: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
2056: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
2057:
2058: l_loan_balance_amt NUMBER ;
2059: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;
2060: l_total_balance_amt NUMBER ;
2061:
2062:
2063: BEGIN

Line 2150: FROM lns_loan_headers_all

2146: BEGIN
2147:
2148: SELECT count(*)
2149: INTO l_total_deliquent_loans
2150: FROM lns_loan_headers_all
2151: WHERE loan_id IN ( SELECT loan_id
2152: FROM lns_participants
2153: WHERE hz_party_id IN ( SELECT hz_party_id
2154: FROM lns_participants

Line 2229: FROM lns_loan_headers_all llh ,

2225: x_errormsg OUT NOCOPY VARCHAR2 ) RETURN VARCHAR2 IS
2226:
2227: CURSOR total_active_loans_overdue(C_LOAN_ID NUMBER , C_PARTY_ID NUMBER) IS
2228: SELECT sum( nvl(lps.total_overdue ,0) ) , llh.loan_currency
2229: FROM lns_loan_headers_all llh ,
2230: LNS_PAY_SUM_OVERDUE_V lps
2231: WHERE llh.loan_id = lps.loan_id
2232: AND llh.loan_id IN ( SELECT loan_id
2233: FROM lns_participants

Line 2260: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

2256: l_cr_loan_id NUMBER := to_number(OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_source_column1 ) ;
2257: l_cr_currency VARCHAR2(30) := OCM_ADD_DATA_POINTS.pg_ocm_add_dp_param_rec.P_TRX_CURRENCY ;
2258:
2259: l_loan_overdue_amt NUMBER ;
2260: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;
2261: l_total_overdue_amt NUMBER ;
2262:
2263:
2264: BEGIN

Line 2352: FROM lns_loan_headers_all

2348: BEGIN
2349:
2350: SELECT count(*)
2351: INTO l_total_default_loans
2352: FROM lns_loan_headers_all
2353: WHERE loan_id IN ( SELECT loan_id
2354: FROM lns_participants
2355: WHERE hz_party_id IN ( SELECT hz_party_id
2356: FROM lns_participants