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 969: /*STPROC.INIT('begin :X0 := GL_CURRENCY_API.IS_FIXED_RATE(:X_FROM_CURRENCY, :X_TO_CURRENCY, :X_EFFECTIVE_DATE); end;');

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

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

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

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

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

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

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

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

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

Line 1015: X0 := GL_CURRENCY_API.GET_EURO_CODE;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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