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.OKC_CURRENCY_API dependencies on GL_CURRENCY_API

Line 211: IF gl_currency_api.is_fixed_rate( p_from_currency, p_to_currency,

207: IS
208:
209: BEGIN
210:
211: IF gl_currency_api.is_fixed_rate( p_from_currency, p_to_currency,
212: p_effective_date ) = 'Y' then
213: Return FALSE;
214: ELSE Return TRUE;
215: END IF;

Line 247: Return gl_currency_api.get_rate(p_from_currency, p_to_currency,

243: Else
244: Return -1;
245: End IF;
246: ELSE
247: Return gl_currency_api.get_rate(p_from_currency, p_to_currency,
248: p_conversion_date, p_conversion_type);
249: END IF;
250:
251: END GET_RATE;

Line 284: gl_currency_api.get_relation(p_from_currency, p_to_currency, p_conversion_date, l_fixed_rate, l_relation);

280: IF l_rate = -1 then
281: l_return_status := OKC_API.G_RET_STS_ERROR; -- 'user' conversion type is not allowed
282: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_USER_CONVERSION');
283: ELSE
284: gl_currency_api.get_relation(p_from_currency, p_to_currency, p_conversion_date, l_fixed_rate, l_relation);
285: IF l_relation in ('OTHER-EMU','EMU-EMU','EURO-EMU') then
286: IF p_conversion_type = 'User' then
287:
288: l_euro_rate := x_conversion_rate / get_rate(gl_currency_api.get_euro_code, p_to_currency, p_conversion_date, p_conversion_type);

Line 288: l_euro_rate := x_conversion_rate / get_rate(gl_currency_api.get_euro_code, p_to_currency, p_conversion_date, p_conversion_type);

284: gl_currency_api.get_relation(p_from_currency, p_to_currency, p_conversion_date, l_fixed_rate, l_relation);
285: IF l_relation in ('OTHER-EMU','EMU-EMU','EURO-EMU') then
286: IF p_conversion_type = 'User' then
287:
288: l_euro_rate := x_conversion_rate / get_rate(gl_currency_api.get_euro_code, p_to_currency, p_conversion_date, p_conversion_type);
289: ELSE
290: l_euro_rate := get_rate(p_from_currency,gl_currency_api.get_euro_code, p_conversion_date, p_conversion_type);
291: END IF;
292: END IF;

Line 290: l_euro_rate := get_rate(p_from_currency,gl_currency_api.get_euro_code, p_conversion_date, p_conversion_type);

286: IF p_conversion_type = 'User' then
287:
288: l_euro_rate := x_conversion_rate / get_rate(gl_currency_api.get_euro_code, p_to_currency, p_conversion_date, p_conversion_type);
289: ELSE
290: l_euro_rate := get_rate(p_from_currency,gl_currency_api.get_euro_code, p_conversion_date, p_conversion_type);
291: END IF;
292: END IF;
293: END IF;
294: x_euro_rate := l_euro_rate;

Line 299: WHEN gl_currency_api.no_rate THEN

295: x_conversion_rate := l_rate;
296: x_return_status := l_return_status;
297:
298: EXCEPTION
299: WHEN gl_currency_api.no_rate THEN
300: x_return_status := OKC_API.G_RET_STS_ERROR;
301: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_CONVERSION_RATE');
302: --RAISE no_rate;
303: WHEN gl_currency_api.invalid_currency THEN

Line 303: WHEN gl_currency_api.invalid_currency THEN

299: WHEN gl_currency_api.no_rate THEN
300: x_return_status := OKC_API.G_RET_STS_ERROR;
301: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_CONVERSION_RATE');
302: --RAISE no_rate;
303: WHEN gl_currency_api.invalid_currency THEN
304: x_return_status := OKC_API.G_RET_STS_ERROR;
305: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_INVALID_CURRENCY');
306: -- RAISE invalid_currency;
307: WHEN OTHERS THEN

Line 336: gl_currency_api.get_relation(p_from_currency, p_to_currency, p_conversion_date,

332: BEGIN
333:
334: x_return_status := 'S';
335:
336: gl_currency_api.get_relation(p_from_currency, p_to_currency, p_conversion_date,
337: l_fixed_rate, l_relation);
338:
339: IF p_conversion_type IS NULL then
340: x_return_status := 'E';

Line 392: gl_currency_api.convert_closest_amount(p_from_currency, p_to_currency,

388: l_num_rate number;
389:
390: BEGIN
391:
392: gl_currency_api.convert_closest_amount(p_from_currency, p_to_currency,
393: p_conversion_date, p_conversion_type,
394: x_conversion_rate, p_amount, 0,
395: l_converted_amount, l_denom_rate,
396: l_num_rate, l_conversion_rate);

Line 493: -- l_curr_euro := gl_currency_api.get_euro_code; /* Bugfix 2256060 - This line is moved after checking the currency_type */

489: l_curr_euro varchar2(5);
490: BEGIN
491:
492: l_currency_type := GET_CURRENCY_TYPE( p_currency, sysdate );
493: -- l_curr_euro := gl_currency_api.get_euro_code; /* Bugfix 2256060 - This line is moved after checking the currency_type */
494:
495:
496: /* If the OKC Context is not set then Org_ID would be returned as NULL
497: and the fnd_profile would be used.

Line 503: l_curr_euro := gl_currency_api.get_euro_code; /* Bugfix 2256060 - moved this line from above */

499:
500: -- commented out sysdate check for testing.
501:
502: IF (l_currency_type = 'EMU' ) then
503: l_curr_euro := gl_currency_api.get_euro_code; /* Bugfix 2256060 - moved this line from above */
504: -- and sysdate >= to_date('01-jan-2002','dd-mon-yyyy')
505: IF (get_ou_currency(okc_context.get_okc_org_id) = l_curr_euro ) then
506: return l_curr_euro;
507: ELSE

Line 516: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN

512: END IF;
513:
514: EXCEPTION
515: /* Bugfix 2256060 - Added the exception from GL to give a proper message */
516: WHEN GL_CURRENCY_API.INVALID_CURRENCY THEN
517: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
518: p_msg_name => 'OKC_NO_EURO_CURR'); /* Bugfix 2256060 - added new message */
519: raise;
520: WHEN OTHERS THEN