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

Line 483: l_conversion_rate := gl_currency_api.get_rate (

479: IF currency2 = rp_functional_currency then
480: l_conversion_rate := 1 ;
481: else
482: IF conversion_rate is null then
483: l_conversion_rate := gl_currency_api.get_rate (
484: p_sob_id,
485: currency2,
486: return_date,
487: conversion_type_code );

Line 591: /*STPROC.INIT('begin :X0 := GL_CURRENCY_API.IS_FIXED_RATE(:X_FROM_CURRENCY, :X_TO_CURRENCY, :X_EFFECTIVE_DATE); end;');

587: ,X_TO_CURRENCY IN VARCHAR2
588: ,X_EFFECTIVE_DATE IN DATE) RETURN VARCHAR2 IS
589: X0 VARCHAR2(2000);
590: BEGIN
591: /*STPROC.INIT('begin :X0 := GL_CURRENCY_API.IS_FIXED_RATE(:X_FROM_CURRENCY, :X_TO_CURRENCY, :X_EFFECTIVE_DATE); end;');
592: STPROC.BIND_O(X0);
593: STPROC.BIND_I(X_FROM_CURRENCY);
594: STPROC.BIND_I(X_TO_CURRENCY);
595: STPROC.BIND_I(X_EFFECTIVE_DATE);

Line 608: /* STPROC.INIT('declare X_FIXED_RATE BOOLEAN; begin X_FIXED_RATE := sys.diutil.int_to_bool(:X_FIXED_RATE); GL_CURRENCY_API.GET_RELATION(:X_FROM_CURRENCY, :X_TO_CURRENCY,

604: ,X_EFFECTIVE_DATE IN DATE
605: ,X_FIXED_RATE IN OUT NOCOPY BOOLEAN
606: ,X_RELATIONSHIP IN OUT NOCOPY VARCHAR2) IS
607: BEGIN
608: /* STPROC.INIT('declare X_FIXED_RATE BOOLEAN; begin X_FIXED_RATE := sys.diutil.int_to_bool(:X_FIXED_RATE); GL_CURRENCY_API.GET_RELATION(:X_FROM_CURRENCY, :X_TO_CURRENCY,
609: :X_EFFECTIVE_DATE, X_FIXED_RATE, :X_RELATIONSHIP); :X_FIXED_RATE := sys.diutil.bool_to_int(X_FIXED_RATE); end;');
610: STPROC.BIND_IO(X_FIXED_RATE);
611: STPROC.BIND_I(X_FROM_CURRENCY);
612: STPROC.BIND_I(X_TO_CURRENCY);

Line 625: /*STPROC.INIT('begin :X0 := GL_CURRENCY_API.GET_EURO_CODE; end;');

621:
622: FUNCTION GET_EURO_CODE RETURN VARCHAR2 IS
623: X0 VARCHAR2(2000);
624: BEGIN
625: /*STPROC.INIT('begin :X0 := GL_CURRENCY_API.GET_EURO_CODE; end;');
626: STPROC.BIND_O(X0);
627: STPROC.EXECUTE;
628: STPROC.RETRIEVE(1
629: ,X0);*/

Line 639: /* STPROC.INIT('begin :X0 := GL_CURRENCY_API.GET_RATE(:X_FROM_CURRENCY, :X_TO_CURRENCY, :X_CONVERSION_DATE, :X_CONVERSION_TYPE); end;');

635: ,X_CONVERSION_DATE IN DATE
636: ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER IS
637: X0 NUMBER;
638: BEGIN
639: /* STPROC.INIT('begin :X0 := GL_CURRENCY_API.GET_RATE(:X_FROM_CURRENCY, :X_TO_CURRENCY, :X_CONVERSION_DATE, :X_CONVERSION_TYPE); end;');
640: STPROC.BIND_O(X0);
641: STPROC.BIND_I(X_FROM_CURRENCY);
642: STPROC.BIND_I(X_TO_CURRENCY);
643: STPROC.BIND_I(X_CONVERSION_DATE);

Line 657: /* STPROC.INIT('begin :X0 := GL_CURRENCY_API.GET_RATE(:X_SET_OF_BOOKS_ID, :X_FROM_CURRENCY, :X_CONVERSION_DATE, :X_CONVERSION_TYPE); end;');

653: ,X_CONVERSION_DATE IN DATE
654: ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER IS
655: X0 NUMBER;
656: BEGIN
657: /* STPROC.INIT('begin :X0 := GL_CURRENCY_API.GET_RATE(:X_SET_OF_BOOKS_ID, :X_FROM_CURRENCY, :X_CONVERSION_DATE, :X_CONVERSION_TYPE); end;');
658: STPROC.BIND_O(X0);
659: STPROC.BIND_I(X_SET_OF_BOOKS_ID);
660: STPROC.BIND_I(X_FROM_CURRENCY);
661: STPROC.BIND_I(X_CONVERSION_DATE);

Line 676: /* STPROC.INIT('begin :X0 := GL_CURRENCY_API.CONVERT_AMOUNT(:X_FROM_CURRENCY, :X_TO_CURRENCY, :X_CONVERSION_DATE, :X_CONVERSION_TYPE, :X_AMOUNT); end;');

672: ,X_CONVERSION_TYPE IN VARCHAR2
673: ,X_AMOUNT IN NUMBER) RETURN NUMBER IS
674: X0 NUMBER;
675: BEGIN
676: /* STPROC.INIT('begin :X0 := GL_CURRENCY_API.CONVERT_AMOUNT(:X_FROM_CURRENCY, :X_TO_CURRENCY, :X_CONVERSION_DATE, :X_CONVERSION_TYPE, :X_AMOUNT); end;');
677: STPROC.BIND_O(X0);
678: STPROC.BIND_I(X_FROM_CURRENCY);
679: STPROC.BIND_I(X_TO_CURRENCY);
680: STPROC.BIND_I(X_CONVERSION_DATE);

Line 696: /* STPROC.INIT('begin :X0 := GL_CURRENCY_API.CONVERT_AMOUNT(:X_SET_OF_BOOKS_ID, :X_FROM_CURRENCY, :X_CONVERSION_DATE, :X_CONVERSION_TYPE, :X_AMOUNT); end;');

692: ,X_CONVERSION_TYPE IN VARCHAR2
693: ,X_AMOUNT IN NUMBER) RETURN NUMBER IS
694: X0 NUMBER;
695: BEGIN
696: /* STPROC.INIT('begin :X0 := GL_CURRENCY_API.CONVERT_AMOUNT(:X_SET_OF_BOOKS_ID, :X_FROM_CURRENCY, :X_CONVERSION_DATE, :X_CONVERSION_TYPE, :X_AMOUNT); end;');
697: STPROC.BIND_O(X0);
698: STPROC.BIND_I(X_SET_OF_BOOKS_ID);
699: STPROC.BIND_I(X_FROM_CURRENCY);
700: STPROC.BIND_I(X_CONVERSION_DATE);

Line 714: /* STPROC.INIT('begin :X0 := GL_CURRENCY_API.GET_DERIVE_TYPE(:SOB_ID, :PERIOD, :CURR_CODE); end;');

710: ,PERIOD IN VARCHAR2
711: ,CURR_CODE IN VARCHAR2) RETURN VARCHAR2 IS
712: X0 VARCHAR2(2000);
713: BEGIN
714: /* STPROC.INIT('begin :X0 := GL_CURRENCY_API.GET_DERIVE_TYPE(:SOB_ID, :PERIOD, :CURR_CODE); end;');
715: STPROC.BIND_O(X0);
716: STPROC.BIND_I(SOB_ID);
717: STPROC.BIND_I(PERIOD);
718: STPROC.BIND_I(CURR_CODE);