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.CE_BANK_STATEMENT_LOADER dependencies on FND_CURRENCIES

Line 2333: -- Precision is not sent by the bank at header level hence extracting from fnd_currencies table

2329: --Get the precision from Bank Statement File
2330: l_hdr_precision := To_Number(RTrim(RTrim(Lookup_Val('H', C_rec.rec_no, 'PRECISION')),'/')) ;
2331:
2332: IF( l_hdr_precision IS NULL ) THEN
2333: -- Precision is not sent by the bank at header level hence extracting from fnd_currencies table
2334: -- If there is no data at fnd_currencies table then the default precision set at mappings will be considered
2335: BEGIN
2336: SELECT PRECISION
2337: INTO l_hdr_precision

Line 2334: -- If there is no data at fnd_currencies table then the default precision set at mappings will be considered

2330: l_hdr_precision := To_Number(RTrim(RTrim(Lookup_Val('H', C_rec.rec_no, 'PRECISION')),'/')) ;
2331:
2332: IF( l_hdr_precision IS NULL ) THEN
2333: -- Precision is not sent by the bank at header level hence extracting from fnd_currencies table
2334: -- If there is no data at fnd_currencies table then the default precision set at mappings will be considered
2335: BEGIN
2336: SELECT PRECISION
2337: INTO l_hdr_precision
2338: FROM fnd_currencies

Line 2338: FROM fnd_currencies

2334: -- If there is no data at fnd_currencies table then the default precision set at mappings will be considered
2335: BEGIN
2336: SELECT PRECISION
2337: INTO l_hdr_precision
2338: FROM fnd_currencies
2339: WHERE CURRENCY_CODE=G_hdr_currency_code
2340: AND ( Nvl(G_statement_date,SYSDATE) >= Nvl(START_DATE_ACTIVE,Nvl(G_statement_date,SYSDATE))
2341: AND
2342: Nvl(G_statement_date,SYSDATE) <= Nvl(END_DATE_ACTIVE,nvl(G_statement_date,SYSDATE))

Line 2346: cep_standard.debug('G_hdr_precision from Fnd_Currencies: '||l_hdr_precision);

2342: Nvl(G_statement_date,SYSDATE) <= Nvl(END_DATE_ACTIVE,nvl(G_statement_date,SYSDATE))
2343: );
2344:
2345: IF l_DEBUG in ('Y', 'C') THEN
2346: cep_standard.debug('G_hdr_precision from Fnd_Currencies: '||l_hdr_precision);
2347: END IF;
2348:
2349: G_hdr_precision := Get_Precision(l_hdr_precision);
2350: G_precision := G_hdr_precision;