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_OEXOEACK_XMLP_PKG dependencies on GL_CURRENCY_API

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

964: ,X_TO_CURRENCY IN VARCHAR2
965: ,X_EFFECTIVE_DATE IN DATE) RETURN VARCHAR2 IS
966: X0 VARCHAR2(2000);
967: BEGIN
968: /*STPROC.INIT('begin :X0 := GL_CURRENCY_API.IS_FIXED_RATE(:X_FROM_CURRENCY, :X_TO_CURRENCY, :X_EFFECTIVE_DATE); end;');
969: STPROC.BIND_O(X0);
970: STPROC.BIND_I(X_FROM_CURRENCY);
971: STPROC.BIND_I(X_TO_CURRENCY);
972: STPROC.BIND_I(X_EFFECTIVE_DATE);

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

972: STPROC.BIND_I(X_EFFECTIVE_DATE);
973: STPROC.EXECUTE;
974: STPROC.RETRIEVE(1
975: ,X0);*/
976: X0 := GL_CURRENCY_API.IS_FIXED_RATE(X_FROM_CURRENCY, X_TO_CURRENCY, X_EFFECTIVE_DATE);
977: RETURN X0;
978: END IS_FIXED_RATE;
979:
980: PROCEDURE GET_RELATION(X_FROM_CURRENCY IN VARCHAR2

Line 988: GL_CURRENCY_API.GET_RELATION(:X_FROM_CURRENCY, :X_TO_CURRENCY,

984: ,X_RELATIONSHIP IN OUT NOCOPY VARCHAR2) IS
985: BEGIN
986: /* STPROC.INIT('declare X_FIXED_RATE BOOLEAN;
987: begin X_FIXED_RATE := sys.diutil.int_to_bool(:X_FIXED_RATE);
988: GL_CURRENCY_API.GET_RELATION(:X_FROM_CURRENCY, :X_TO_CURRENCY,
989: :X_EFFECTIVE_DATE, X_FIXED_RATE, :X_RELATIONSHIP);
990: :X_FIXED_RATE := sys.diutil.bool_to_int(X_FIXED_RATE); end;');
991: STPROC.BIND_IO(X_FIXED_RATE);
992: STPROC.BIND_I(X_FROM_CURRENCY);

Line 1002: GL_CURRENCY_API.GET_RELATION(X_FROM_CURRENCY, X_TO_CURRENCY, X_EFFECTIVE_DATE, X_FIXED_RATE, X_RELATIONSHIP);

998: ,X_FIXED_RATE);
999: STPROC.RETRIEVE(5
1000: ,X_RELATIONSHIP);*/
1001: --X_FIXED_RATE := sys.diutil.int_to_bool(X_FIXED_RATE);
1002: GL_CURRENCY_API.GET_RELATION(X_FROM_CURRENCY, X_TO_CURRENCY, X_EFFECTIVE_DATE, X_FIXED_RATE, X_RELATIONSHIP);
1003: --X_FIXED_RATE := sys.diutil.bool_to_int(X_FIXED_RATE);
1004: END GET_RELATION;
1005:
1006: FUNCTION GET_EURO_CODE RETURN VARCHAR2 IS

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

1005:
1006: FUNCTION GET_EURO_CODE RETURN VARCHAR2 IS
1007: X0 VARCHAR2(2000);
1008: BEGIN
1009: /*STPROC.INIT('begin :X0 := GL_CURRENCY_API.GET_EURO_CODE; end;');
1010: STPROC.BIND_O(X0);
1011: STPROC.EXECUTE;
1012: STPROC.RETRIEVE(1
1013: ,X0);*/

Line 1014: X0 := GL_CURRENCY_API.GET_EURO_CODE;

1010: STPROC.BIND_O(X0);
1011: STPROC.EXECUTE;
1012: STPROC.RETRIEVE(1
1013: ,X0);*/
1014: X0 := GL_CURRENCY_API.GET_EURO_CODE;
1015: RETURN X0;
1016: END GET_EURO_CODE;
1017:
1018: FUNCTION GET_RATE(X_FROM_CURRENCY IN VARCHAR2

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

1020: ,X_CONVERSION_DATE IN DATE
1021: ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER IS
1022: X0 NUMBER;
1023: BEGIN
1024: /*STPROC.INIT('begin :X0 := GL_CURRENCY_API.GET_RATE(:X_FROM_CURRENCY, :X_TO_CURRENCY, :X_CONVERSION_DATE, :X_CONVERSION_TYPE); end;');
1025: STPROC.BIND_O(X0);
1026: STPROC.BIND_I(X_FROM_CURRENCY);
1027: STPROC.BIND_I(X_TO_CURRENCY);
1028: STPROC.BIND_I(X_CONVERSION_DATE);

Line 1033: X0 := GL_CURRENCY_API.GET_RATE(X_FROM_CURRENCY, X_TO_CURRENCY, X_CONVERSION_DATE, X_CONVERSION_TYPE);

1029: STPROC.BIND_I(X_CONVERSION_TYPE);
1030: STPROC.EXECUTE;
1031: STPROC.RETRIEVE(1
1032: ,X0);*/
1033: X0 := GL_CURRENCY_API.GET_RATE(X_FROM_CURRENCY, X_TO_CURRENCY, X_CONVERSION_DATE, X_CONVERSION_TYPE);
1034: RETURN X0;
1035: END GET_RATE;
1036:
1037: FUNCTION GET_RATE(X_SET_OF_BOOKS_ID IN NUMBER

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

1039: ,X_CONVERSION_DATE IN DATE
1040: ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER IS
1041: X0 NUMBER;
1042: BEGIN
1043: /*STPROC.INIT('begin :X0 := GL_CURRENCY_API.GET_RATE(:X_SET_OF_BOOKS_ID, :X_FROM_CURRENCY, :X_CONVERSION_DATE, :X_CONVERSION_TYPE); end;');
1044: STPROC.BIND_O(X0);
1045: STPROC.BIND_I(X_SET_OF_BOOKS_ID);
1046: STPROC.BIND_I(X_FROM_CURRENCY);
1047: STPROC.BIND_I(X_CONVERSION_DATE);

Line 1052: X0 := GL_CURRENCY_API.GET_RATE(X_SET_OF_BOOKS_ID, X_FROM_CURRENCY, X_CONVERSION_DATE, X_CONVERSION_TYPE);

1048: STPROC.BIND_I(X_CONVERSION_TYPE);
1049: STPROC.EXECUTE;
1050: STPROC.RETRIEVE(1
1051: ,X0);*/
1052: X0 := GL_CURRENCY_API.GET_RATE(X_SET_OF_BOOKS_ID, X_FROM_CURRENCY, X_CONVERSION_DATE, X_CONVERSION_TYPE);
1053: RETURN X0;
1054: END GET_RATE;
1055:
1056: FUNCTION CONVERT_AMOUNT(X_FROM_CURRENCY IN VARCHAR2

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

1059: ,X_CONVERSION_TYPE IN VARCHAR2
1060: ,X_AMOUNT IN NUMBER) RETURN NUMBER IS
1061: X0 NUMBER;
1062: BEGIN
1063: /*STPROC.INIT('begin :X0 := GL_CURRENCY_API.CONVERT_AMOUNT(:X_FROM_CURRENCY, :X_TO_CURRENCY, :X_CONVERSION_DATE, :X_CONVERSION_TYPE, :X_AMOUNT); end;');
1064: STPROC.BIND_O(X0);
1065: STPROC.BIND_I(X_FROM_CURRENCY);
1066: STPROC.BIND_I(X_TO_CURRENCY);
1067: STPROC.BIND_I(X_CONVERSION_DATE);

Line 1073: X0 := GL_CURRENCY_API.CONVERT_AMOUNT(X_FROM_CURRENCY, X_TO_CURRENCY, X_CONVERSION_DATE, X_CONVERSION_TYPE, X_AMOUNT);

1069: STPROC.BIND_I(X_AMOUNT);
1070: STPROC.EXECUTE;
1071: STPROC.RETRIEVE(1
1072: ,X0);*/
1073: X0 := GL_CURRENCY_API.CONVERT_AMOUNT(X_FROM_CURRENCY, X_TO_CURRENCY, X_CONVERSION_DATE, X_CONVERSION_TYPE, X_AMOUNT);
1074: RETURN X0;
1075: END CONVERT_AMOUNT;
1076:
1077: FUNCTION CONVERT_AMOUNT(X_SET_OF_BOOKS_ID IN NUMBER

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

1080: ,X_CONVERSION_TYPE IN VARCHAR2
1081: ,X_AMOUNT IN NUMBER) RETURN NUMBER IS
1082: X0 NUMBER;
1083: BEGIN
1084: /*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;');
1085: STPROC.BIND_O(X0);
1086: STPROC.BIND_I(X_SET_OF_BOOKS_ID);
1087: STPROC.BIND_I(X_FROM_CURRENCY);
1088: STPROC.BIND_I(X_CONVERSION_DATE);

Line 1094: X0 := GL_CURRENCY_API.CONVERT_AMOUNT(X_SET_OF_BOOKS_ID, X_FROM_CURRENCY, X_CONVERSION_DATE, X_CONVERSION_TYPE, X_AMOUNT);

1090: STPROC.BIND_I(X_AMOUNT);
1091: STPROC.EXECUTE;
1092: STPROC.RETRIEVE(1
1093: ,X0);*/
1094: X0 := GL_CURRENCY_API.CONVERT_AMOUNT(X_SET_OF_BOOKS_ID, X_FROM_CURRENCY, X_CONVERSION_DATE, X_CONVERSION_TYPE, X_AMOUNT);
1095: RETURN X0;
1096: END CONVERT_AMOUNT;
1097:
1098: FUNCTION GET_DERIVE_TYPE(SOB_ID IN NUMBER

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

1099: ,PERIOD IN VARCHAR2
1100: ,CURR_CODE IN VARCHAR2) RETURN VARCHAR2 IS
1101: X0 VARCHAR2(2000);
1102: BEGIN
1103: /*STPROC.INIT('begin :X0 := GL_CURRENCY_API.GET_DERIVE_TYPE(:SOB_ID, :PERIOD, :CURR_CODE); end;');
1104: STPROC.BIND_O(X0);
1105: STPROC.BIND_I(SOB_ID);
1106: STPROC.BIND_I(PERIOD);
1107: STPROC.BIND_I(CURR_CODE);

Line 1111: X0 := GL_CURRENCY_API.GET_DERIVE_TYPE(SOB_ID, PERIOD, CURR_CODE);

1107: STPROC.BIND_I(CURR_CODE);
1108: STPROC.EXECUTE;
1109: STPROC.RETRIEVE(1
1110: ,X0);*/
1111: X0 := GL_CURRENCY_API.GET_DERIVE_TYPE(SOB_ID, PERIOD, CURR_CODE);
1112: RETURN X0;
1113: END GET_DERIVE_TYPE;
1114:
1115: FUNCTION RATE_EXISTS(X_FROM_CURRENCY IN VARCHAR2

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

1117: ,X_CONVERSION_DATE IN DATE
1118: ,X_CONVERSION_TYPE IN VARCHAR2) RETURN VARCHAR2 IS
1119: X0 VARCHAR2(2000);
1120: BEGIN
1121: /*STPROC.INIT('begin :X0 := GL_CURRENCY_API.RATE_EXISTS(:X_FROM_CURRENCY, :X_TO_CURRENCY, :X_CONVERSION_DATE, :X_CONVERSION_TYPE); end;');
1122: STPROC.BIND_O(X0);
1123: STPROC.BIND_I(X_FROM_CURRENCY);
1124: STPROC.BIND_I(X_TO_CURRENCY);
1125: STPROC.BIND_I(X_CONVERSION_DATE);

Line 1130: X0 := GL_CURRENCY_API.RATE_EXISTS(X_FROM_CURRENCY, X_TO_CURRENCY, X_CONVERSION_DATE, X_CONVERSION_TYPE);

1126: STPROC.BIND_I(X_CONVERSION_TYPE);
1127: STPROC.EXECUTE;
1128: STPROC.RETRIEVE(1
1129: ,X0);*/
1130: X0 := GL_CURRENCY_API.RATE_EXISTS(X_FROM_CURRENCY, X_TO_CURRENCY, X_CONVERSION_DATE, X_CONVERSION_TYPE);
1131: RETURN X0;
1132: END RATE_EXISTS;
1133:
1134: FUNCTION BEFOREREPORT RETURN BOOLEAN IS