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

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

287: ,X_TO_CURRENCY IN VARCHAR2
288: ,X_EFFECTIVE_DATE IN DATE) RETURN VARCHAR2 IS
289: X0 VARCHAR2(2000);
290: BEGIN
291: /* STPROC.INIT('begin :X0 := GL_CURRENCY_API.IS_FIXED_RATE(:X_FROM_CURRENCY, :X_TO_CURRENCY, :X_EFFECTIVE_DATE); end;');
292: STPROC.BIND_O(X0);
293: STPROC.BIND_I(X_FROM_CURRENCY);
294: STPROC.BIND_I(X_TO_CURRENCY);
295: STPROC.BIND_I(X_EFFECTIVE_DATE);

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

295: STPROC.BIND_I(X_EFFECTIVE_DATE);
296: STPROC.EXECUTE;
297: STPROC.RETRIEVE(1
298: ,X0);*/
299: X0 := GL_CURRENCY_API.IS_FIXED_RATE(X_FROM_CURRENCY,X_TO_CURRENCY,X_EFFECTIVE_DATE);
300: RETURN X0;
301: END IS_FIXED_RATE;
302: /*PROCEDURE GET_RELATION(X_FROM_CURRENCY IN VARCHAR2
303: ,X_TO_CURRENCY IN VARCHAR2

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

305: ,X_FIXED_RATE IN OUT NOCOPY BOOLEAN
306: ,X_RELATIONSHIP IN OUT NOCOPY VARCHAR2) IS
307: BEGIN
308: X_FIXED_RATE := sys.diutil.int_to_bool(X_FIXED_RATE);
309: GL_CURRENCY_API.GET_RELATION(X_FROM_CURRENCY, X_TO_CURRENCY, X_EFFECTIVE_DATE, X_FIXED_RATE, X_RELATIONSHIP);
310: X_FIXED_RATE := sys.diutil.bool_to_int(X_FIXED_RATE);
311: END GET_RELATION;*/
312: FUNCTION GET_EURO_CODE RETURN VARCHAR2 IS
313: X0 VARCHAR2(2000);

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

311: END GET_RELATION;*/
312: FUNCTION GET_EURO_CODE RETURN VARCHAR2 IS
313: X0 VARCHAR2(2000);
314: BEGIN
315: /* STPROC.INIT('begin :X0 := GL_CURRENCY_API.GET_EURO_CODE; end;');
316: STPROC.BIND_O(X0);
317: STPROC.EXECUTE;
318: STPROC.RETRIEVE(1
319: ,X0);*/

Line 320: X0 := GL_CURRENCY_API.GET_EURO_CODE;

316: STPROC.BIND_O(X0);
317: STPROC.EXECUTE;
318: STPROC.RETRIEVE(1
319: ,X0);*/
320: X0 := GL_CURRENCY_API.GET_EURO_CODE;
321: RETURN X0;
322: END GET_EURO_CODE;
323: FUNCTION GET_RATE(X_FROM_CURRENCY IN VARCHAR2
324: ,X_TO_CURRENCY IN VARCHAR2

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

325: ,X_CONVERSION_DATE IN DATE
326: ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER IS
327: X0 NUMBER;
328: BEGIN
329: /* STPROC.INIT('begin :X0 := GL_CURRENCY_API.GET_RATE(:X_FROM_CURRENCY, :X_TO_CURRENCY, :X_CONVERSION_DATE, :X_CONVERSION_TYPE); end;');
330: STPROC.BIND_O(X0);
331: STPROC.BIND_I(X_FROM_CURRENCY);
332: STPROC.BIND_I(X_TO_CURRENCY);
333: STPROC.BIND_I(X_CONVERSION_DATE);

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

334: STPROC.BIND_I(X_CONVERSION_TYPE);
335: STPROC.EXECUTE;
336: STPROC.RETRIEVE(1
337: ,X0);*/
338: X0 := GL_CURRENCY_API.GET_RATE(X_FROM_CURRENCY, X_TO_CURRENCY, X_CONVERSION_DATE, X_CONVERSION_TYPE);
339: RETURN X0;
340: END GET_RATE;
341: FUNCTION GET_RATE(X_SET_OF_BOOKS_ID IN NUMBER
342: ,X_FROM_CURRENCY IN VARCHAR2

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

343: ,X_CONVERSION_DATE IN DATE
344: ,X_CONVERSION_TYPE IN VARCHAR2) RETURN NUMBER IS
345: X0 NUMBER;
346: BEGIN
347: /* STPROC.INIT('begin :X0 := GL_CURRENCY_API.GET_RATE(:X_SET_OF_BOOKS_ID, :X_FROM_CURRENCY, :X_CONVERSION_DATE, :X_CONVERSION_TYPE); end;');
348: STPROC.BIND_O(X0);
349: STPROC.BIND_I(X_SET_OF_BOOKS_ID);
350: STPROC.BIND_I(X_FROM_CURRENCY);
351: STPROC.BIND_I(X_CONVERSION_DATE);

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

352: STPROC.BIND_I(X_CONVERSION_TYPE);
353: STPROC.EXECUTE;
354: STPROC.RETRIEVE(1
355: ,X0);*/
356: X0 := GL_CURRENCY_API.GET_RATE(X_SET_OF_BOOKS_ID, X_FROM_CURRENCY, X_CONVERSION_DATE, X_CONVERSION_TYPE);
357: RETURN X0;
358: END GET_RATE;
359: FUNCTION CONVERT_AMOUNT(X_FROM_CURRENCY IN VARCHAR2
360: ,X_TO_CURRENCY IN VARCHAR2

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

362: ,X_CONVERSION_TYPE IN VARCHAR2
363: ,X_AMOUNT IN NUMBER) RETURN NUMBER IS
364: X0 NUMBER;
365: BEGIN
366: /* STPROC.INIT('begin :X0 := GL_CURRENCY_API.CONVERT_AMOUNT(:X_FROM_CURRENCY, :X_TO_CURRENCY, :X_CONVERSION_DATE, :X_CONVERSION_TYPE, :X_AMOUNT); end;');
367: STPROC.BIND_O(X0);
368: STPROC.BIND_I(X_FROM_CURRENCY);
369: STPROC.BIND_I(X_TO_CURRENCY);
370: STPROC.BIND_I(X_CONVERSION_DATE);

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

372: STPROC.BIND_I(X_AMOUNT);
373: STPROC.EXECUTE;
374: STPROC.RETRIEVE(1
375: ,X0);*/
376: X0 := GL_CURRENCY_API.CONVERT_AMOUNT(X_FROM_CURRENCY, X_TO_CURRENCY, X_CONVERSION_DATE, X_CONVERSION_TYPE, X_AMOUNT);
377: RETURN X0;
378: END CONVERT_AMOUNT;
379: FUNCTION CONVERT_AMOUNT(X_SET_OF_BOOKS_ID IN NUMBER
380: ,X_FROM_CURRENCY IN VARCHAR2

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

382: ,X_CONVERSION_TYPE IN VARCHAR2
383: ,X_AMOUNT IN NUMBER) RETURN NUMBER IS
384: X0 NUMBER;
385: BEGIN
386: /* 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;');
387: STPROC.BIND_O(X0);
388: STPROC.BIND_I(X_SET_OF_BOOKS_ID);
389: STPROC.BIND_I(X_FROM_CURRENCY);
390: STPROC.BIND_I(X_CONVERSION_DATE);

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

392: STPROC.BIND_I(X_AMOUNT);
393: STPROC.EXECUTE;
394: STPROC.RETRIEVE(1
395: ,X0);*/
396: X0 := GL_CURRENCY_API.CONVERT_AMOUNT(X_SET_OF_BOOKS_ID, X_FROM_CURRENCY, X_CONVERSION_DATE, X_CONVERSION_TYPE, X_AMOUNT);
397: RETURN X0;
398: END CONVERT_AMOUNT;
399: FUNCTION GET_DERIVE_TYPE(SOB_ID IN NUMBER
400: ,PERIOD IN VARCHAR2

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

400: ,PERIOD IN VARCHAR2
401: ,CURR_CODE IN VARCHAR2) RETURN VARCHAR2 IS
402: X0 VARCHAR2(2000);
403: BEGIN
404: /* STPROC.INIT('begin :X0 := GL_CURRENCY_API.GET_DERIVE_TYPE(:SOB_ID, :PERIOD, :CURR_CODE); end;');
405: STPROC.BIND_O(X0);
406: STPROC.BIND_I(SOB_ID);
407: STPROC.BIND_I(PERIOD);
408: STPROC.BIND_I(CURR_CODE);

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

409: STPROC.EXECUTE;
410: STPROC.RETRIEVE(1
411: ,X0);
412: RETURN X0;*/
413: X0 := GL_CURRENCY_API.GET_DERIVE_TYPE(SOB_ID, PERIOD, CURR_CODE);
414: END GET_DERIVE_TYPE;
415: --added
416: function C_CONVERT_AMOUNTFormula(p_use_functional_currency in varchar2,qty_ordered in number ,qty_invoiced in number ,qty_shipped in number ,
417: currency2 IN VARCHAR2,rp_functional_currency IN VARCHAR2,conversion_rate in number,p_sob_id in number

Line 434: l_conversion_rate := gl_currency_api.get_rate (

430: IF currency2 = rp_functional_currency then
431: l_conversion_rate := 1 ;
432: else
433: IF conversion_rate is null then
434: l_conversion_rate := gl_currency_api.get_rate (
435: p_sob_id,
436: currency2,
437: order_date,
438: conversion_type_code );