APPS.ONT_OEXOEOSR_XMLP_PKG dependencies on GL_CURRENCY_API

Line 791: begin X0 := GL_CURRENCY_API.IS_FIXED_RATE(X_FROM_CURRENCY, X_TO_CURRENCY, X_EFFECTIVE_DATE);

787: ,X_TO_CURRENCY IN VARCHAR2
788: ,X_EFFECTIVE_DATE IN DATE) RETURN VARCHAR2 IS
789: X0 VARCHAR2(2000);
790: BEGIN
791: begin X0 := GL_CURRENCY_API.IS_FIXED_RATE(X_FROM_CURRENCY, X_TO_CURRENCY, X_EFFECTIVE_DATE);
792: end;
793: /*STPROC.INIT('begin :X0 := GL_CURRENCY_API.IS_FIXED_RATE(:X_FROM_CURRENCY, :X_TO_CURRENCY, :X_EFFECTIVE_DATE); end;');
794: STPROC.BIND_O(X0);
795: STPROC.BIND_I(X_FROM_CURRENCY);

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

789: X0 VARCHAR2(2000);
790: BEGIN
791: begin X0 := GL_CURRENCY_API.IS_FIXED_RATE(X_FROM_CURRENCY, X_TO_CURRENCY, X_EFFECTIVE_DATE);
792: end;
793: /*STPROC.INIT('begin :X0 := GL_CURRENCY_API.IS_FIXED_RATE(:X_FROM_CURRENCY, :X_TO_CURRENCY, :X_EFFECTIVE_DATE); end;');
794: STPROC.BIND_O(X0);
795: STPROC.BIND_I(X_FROM_CURRENCY);
796: STPROC.BIND_I(X_TO_CURRENCY);
797: STPROC.BIND_I(X_EFFECTIVE_DATE);

Line 829: X0 := GL_CURRENCY_API.GET_EURO_CODE;

825: FUNCTION GET_EURO_CODE RETURN VARCHAR2 IS
826: X0 VARCHAR2(2000);
827: BEGIN
828: begin
829: X0 := GL_CURRENCY_API.GET_EURO_CODE;
830: end;
831: /*STPROC.INIT('begin :X0 := GL_CURRENCY_API.GET_EURO_CODE; end;');
832: STPROC.BIND_O(X0);
833: STPROC.EXECUTE;

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

827: BEGIN
828: begin
829: X0 := GL_CURRENCY_API.GET_EURO_CODE;
830: end;
831: /*STPROC.INIT('begin :X0 := GL_CURRENCY_API.GET_EURO_CODE; end;');
832: STPROC.BIND_O(X0);
833: STPROC.EXECUTE;
834: STPROC.RETRIEVE(1
835: ,X0);*/

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

841: ,X_CONVERSION_DATE IN DATE
842: ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER IS
843: X0 NUMBER;
844: BEGIN
845: /* STPROC.INIT('begin :X0 := GL_CURRENCY_API.GET_RATE(:X_FROM_CURRENCY, :X_TO_CURRENCY, :X_CONVERSION_DATE, :X_CONVERSION_TYPE); end;');
846: STPROC.BIND_O(X0);
847: STPROC.BIND_I(X_FROM_CURRENCY);
848: STPROC.BIND_I(X_TO_CURRENCY);
849: STPROC.BIND_I(X_CONVERSION_DATE);

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

859: ,X_CONVERSION_DATE IN DATE
860: ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER IS
861: X0 NUMBER;
862: BEGIN
863: /*STPROC.INIT('begin :X0 := GL_CURRENCY_API.GET_RATE(:X_SET_OF_BOOKS_ID, :X_FROM_CURRENCY, :X_CONVERSION_DATE, :X_CONVERSION_TYPE); end;');
864: STPROC.BIND_O(X0);
865: STPROC.BIND_I(X_SET_OF_BOOKS_ID);
866: STPROC.BIND_I(X_FROM_CURRENCY);
867: STPROC.BIND_I(X_CONVERSION_DATE);

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

878: ,X_CONVERSION_TYPE IN VARCHAR2
879: ,X_AMOUNT IN NUMBER) RETURN NUMBER IS
880: X0 NUMBER;
881: BEGIN
882: /*STPROC.INIT('begin :X0 := GL_CURRENCY_API.CONVERT_AMOUNT(:X_FROM_CURRENCY, :X_TO_CURRENCY, :X_CONVERSION_DATE, :X_CONVERSION_TYPE, :X_AMOUNT); end;');
883: STPROC.BIND_O(X0);
884: STPROC.BIND_I(X_FROM_CURRENCY);
885: STPROC.BIND_I(X_TO_CURRENCY);
886: STPROC.BIND_I(X_CONVERSION_DATE);

Line 902: /*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;');

898: ,X_CONVERSION_TYPE IN VARCHAR2
899: ,X_AMOUNT IN NUMBER) RETURN NUMBER IS
900: X0 NUMBER;
901: BEGIN
902: /*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;');
903: STPROC.BIND_O(X0);
904: STPROC.BIND_I(X_SET_OF_BOOKS_ID);
905: STPROC.BIND_I(X_FROM_CURRENCY);
906: STPROC.BIND_I(X_CONVERSION_DATE);

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

916: ,PERIOD IN VARCHAR2
917: ,CURR_CODE IN VARCHAR2) RETURN VARCHAR2 IS
918: X0 VARCHAR2(2000);
919: BEGIN
920: /*STPROC.INIT('begin :X0 := GL_CURRENCY_API.GET_DERIVE_TYPE(:SOB_ID, :PERIOD, :CURR_CODE); end;');
921: STPROC.BIND_O(X0);
922: STPROC.BIND_I(SOB_ID);
923: STPROC.BIND_I(PERIOD);
924: STPROC.BIND_I(CURR_CODE);