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 105: l_loan_subtype lns_loan_headers_all.loan_subtype%TYPE ;

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

Line 115: FROM lns_loan_headers_all

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

Line 173: l_loan_collateral_perecent lns_loan_headers_all.collateral_percent%TYPE ;

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

Line 182: FROM lns_loan_headers_all

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

Line 246: lns_loan_headers_all llh ,

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

Line 574: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

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

Line 585: FROM lns_loan_headers_all loan

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

Line 643: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

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

Line 657: FROM lns_loan_headers_all loan

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

Line 716: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

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

Line 725: FROM lns_terms lt , lns_loan_headers_all llh

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

Line 1119: FROM lns_loan_headers_all

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

Line 1179: FROM lns_loan_headers_all llh ,

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

Line 1196: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

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

Line 1284: FROM lns_loan_headers_all

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

Line 1344: FROM lns_loan_headers_all llh ,

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

Line 1361: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

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

Line 1448: FROM lns_loan_headers_all

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

Line 1508: FROM lns_loan_headers_all llh ,

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

Line 1525: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

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

Line 1613: FROM lns_loan_headers_all

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

Line 1672: FROM lns_loan_headers_all llh ,

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

Line 1689: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

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

Line 1776: FROM lns_loan_headers_all

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

Line 1835: FROM lns_loan_headers_all llh ,

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

Line 1852: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

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

Line 1945: FROM lns_loan_headers_all

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

Line 2026: FROM lns_loan_headers_all llh ,

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

Line 2057: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

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

Line 2148: FROM lns_loan_headers_all

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

Line 2227: FROM lns_loan_headers_all llh ,

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

Line 2258: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;

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

Line 2350: FROM lns_loan_headers_all

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