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, null , 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, null , l_loan_req_amt);
51: END IF ;
52:
53: EXCEPTION
54: WHEN NO_DATA_FOUND THEN

Line 592: l_req_coll_amount := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, null , l_req_coll_amount);

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

Line 663: l_total_coll_amount := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, null , l_total_coll_amount);

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

Line 733: l_deliquency_amount := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, null , l_deliquency_amount);

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

Line 836: l_asset_amount := gl_currency_api.convert_amount(l_asset_currency ,l_cr_currency , sysdate, null , l_asset_amount);

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

Line 944: l_asset_pledged_amt := gl_currency_api.convert_amount(l_asset_currency ,l_cr_currency , sysdate, null , l_asset_pledged_amt);

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

Line 1051: l_asset_available_amt := gl_currency_api.convert_amount(l_asset_currency ,l_cr_currency , sysdate, null , l_asset_available_amt);

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

Line 1216: l_loan_balance_amt := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, null , l_loan_balance_amt);

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

Line 1381: l_loan_balance_amt := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, null , l_loan_balance_amt);

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

Line 1545: l_loan_balance_amt := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, null , l_loan_balance_amt);

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

Line 1709: l_loan_balance_amt := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, null , l_loan_balance_amt);

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

Line 1872: l_loan_balance_amt := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, null , l_loan_balance_amt);

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

Line 2077: l_loan_balance_amt := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, null , l_loan_balance_amt);

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

Line 2278: l_loan_overdue_amt := gl_currency_api.convert_amount(l_loan_currency ,l_cr_currency , sysdate, null , l_loan_overdue_amt);

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