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 GL_CURRENCY_API

Line 50: l_loan_req_amt := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_loan_req_amt);

46: WHERE loan_id = l_cr_loan_id ;
47:
48:
49: IF(l_cr_currency<>l_loan_currency) THEN
50: l_loan_req_amt := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_loan_req_amt);
51: END IF ;
52:
53: EXCEPTION
54: WHEN NO_DATA_FOUND THEN

Line 590: l_req_coll_amount := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_req_coll_amount);

586: WHERE loan.loan_id = l_cr_loan_id ;
587:
588:
589: IF(l_cr_currency<>l_loan_currency) THEN
590: l_req_coll_amount := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_req_coll_amount);
591: END IF ;
592:
593: EXCEPTION
594: WHEN NO_DATA_FOUND THEN

Line 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);

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);
662: END IF ;
663:
664: EXCEPTION
665: WHEN NO_DATA_FOUND THEN

Line 731: l_deliquency_amount := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_deliquency_amount);

727: AND lt.loan_id = llh.loan_id ;
728:
729:
730: IF(l_cr_currency<>l_loan_currency) THEN
731: l_deliquency_amount := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_deliquency_amount);
732: END IF ;
733:
734: EXCEPTION
735: WHEN NO_DATA_FOUND THEN

Line 834: l_asset_amount := gl_currency_api.convert_amount(l_asset_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_asset_amount);

830: FETCH party_total_assets INTO l_asset_amount , l_asset_currency ;
831: EXIT WHEN party_total_assets%NOTFOUND ;
832:
833: IF(l_cr_currency<>l_asset_currency) THEN
834: l_asset_amount := gl_currency_api.convert_amount(l_asset_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_asset_amount);
835: END IF ;
836:
837: l_total_assets_amount := l_total_assets_amount + l_asset_amount ;
838:

Line 942: l_asset_pledged_amt := gl_currency_api.convert_amount(l_asset_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_asset_pledged_amt);

938: FETCH party_pledged_assets INTO l_asset_pledged_amt , l_asset_currency ;
939: EXIT WHEN party_pledged_assets%NOTFOUND ;
940:
941: IF(l_cr_currency<>l_asset_currency) THEN
942: l_asset_pledged_amt := gl_currency_api.convert_amount(l_asset_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_asset_pledged_amt);
943: END IF ;
944:
945: l_total_assets_pledged_amt := l_total_assets_pledged_amt + l_asset_pledged_amt ;
946:

Line 1049: l_asset_available_amt := gl_currency_api.convert_amount(l_asset_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_asset_available_amt);

1045: FETCH party_available_assets INTO l_asset_available_amt , l_asset_currency ;
1046: EXIT WHEN party_available_assets%NOTFOUND ;
1047:
1048: IF(l_cr_currency<>l_asset_currency) THEN
1049: l_asset_available_amt := gl_currency_api.convert_amount(l_asset_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_asset_available_amt);
1050: END IF ;
1051:
1052: l_total_assets_available_amt := l_total_assets_available_amt + l_asset_available_amt ;
1053:

Line 1214: l_loan_balance_amt := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_loan_balance_amt);

1210: FETCH active_loans_balance INTO l_loan_balance_amt , l_loan_currency ;
1211: EXIT WHEN active_loans_balance%NOTFOUND ;
1212:
1213: IF(l_cr_currency<>l_loan_currency) THEN
1214: l_loan_balance_amt := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_loan_balance_amt);
1215: END IF ;
1216:
1217: l_total_balance_amt := l_total_balance_amt + l_loan_balance_amt ;
1218:

Line 1379: l_loan_balance_amt := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_loan_balance_amt);

1375: FETCH pending_loans_balance INTO l_loan_balance_amt , l_loan_currency ;
1376: EXIT WHEN pending_loans_balance%NOTFOUND ;
1377:
1378: IF(l_cr_currency<>l_loan_currency) THEN
1379: l_loan_balance_amt := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_loan_balance_amt);
1380: END IF ;
1381:
1382: l_total_balance_amt := l_total_balance_amt + l_loan_balance_amt ;
1383:

Line 1543: l_loan_balance_amt := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_loan_balance_amt);

1539: FETCH delinquent_loans_balance INTO l_loan_balance_amt , l_loan_currency ;
1540: EXIT WHEN delinquent_loans_balance%NOTFOUND ;
1541:
1542: IF(l_cr_currency<>l_loan_currency) THEN
1543: l_loan_balance_amt := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_loan_balance_amt);
1544: END IF ;
1545:
1546: l_total_balance_amt := l_total_balance_amt + l_loan_balance_amt ;
1547:

Line 1707: l_loan_balance_amt := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_loan_balance_amt);

1703: FETCH default_loans_balance INTO l_loan_balance_amt , l_loan_currency ;
1704: EXIT WHEN default_loans_balance%NOTFOUND ;
1705:
1706: IF(l_cr_currency<>l_loan_currency) THEN
1707: l_loan_balance_amt := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_loan_balance_amt);
1708: END IF ;
1709:
1710: l_total_balance_amt := l_total_balance_amt + l_loan_balance_amt ;
1711:

Line 1870: l_loan_balance_amt := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_loan_balance_amt);

1866: FETCH paidoff_loans_balance INTO l_loan_balance_amt , l_loan_currency ;
1867: EXIT WHEN paidoff_loans_balance%NOTFOUND ;
1868:
1869: IF(l_cr_currency<>l_loan_currency) THEN
1870: l_loan_balance_amt := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_loan_balance_amt);
1871: END IF ;
1872:
1873: l_total_balance_amt := l_total_balance_amt + l_loan_balance_amt ;
1874:

Line 2075: l_loan_balance_amt := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_loan_balance_amt);

2071: FETCH total_active_loans_balance INTO l_loan_balance_amt , l_loan_currency ;
2072: EXIT WHEN total_active_loans_balance%NOTFOUND ;
2073:
2074: IF(l_cr_currency<>l_loan_currency) THEN
2075: l_loan_balance_amt := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_loan_balance_amt);
2076: END IF ;
2077:
2078: l_total_balance_amt := l_total_balance_amt + l_loan_balance_amt ;
2079:

Line 2276: l_loan_overdue_amt := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_loan_overdue_amt);

2272: FETCH total_active_loans_overdue INTO l_loan_overdue_amt , l_loan_currency ;
2273: EXIT WHEN total_active_loans_overdue%NOTFOUND ;
2274:
2275: IF(l_cr_currency<>l_loan_currency) THEN
2276: l_loan_overdue_amt := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, g_exchange_rate_type , l_loan_overdue_amt);
2277: END IF ;
2278:
2279: l_total_overdue_amt := l_total_overdue_amt + l_loan_overdue_amt ;
2280: