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.GL_CRM_UTILITIES_PKG dependencies on GL_CROSS_RATE_TEMP

Line 1436: fnd_file.put_line(fnd_file.LOG, 'Clean gl_cross_rate_temp.');

1432: gl_message.func_ent('Cross Rates Calculation');
1433:
1434: -- select all the lines who can be calculate cross rate from the gl_daily_rates table
1435: IF DEBUG_MODE THEN
1436: fnd_file.put_line(fnd_file.LOG, 'Clean gl_cross_rate_temp.');
1437: END IF;
1438:
1439: DELETE FROM gl_cross_rate_temp;
1440:

Line 1439: DELETE FROM gl_cross_rate_temp;

1435: IF DEBUG_MODE THEN
1436: fnd_file.put_line(fnd_file.LOG, 'Clean gl_cross_rate_temp.');
1437: END IF;
1438:
1439: DELETE FROM gl_cross_rate_temp;
1440:
1441: IF DEBUG_MODE THEN
1442: fnd_file.put_line
1443: (fnd_file.LOG,

Line 1444: 'Copy rows from interface table to gl_cross_rate_temp.');

1440:
1441: IF DEBUG_MODE THEN
1442: fnd_file.put_line
1443: (fnd_file.LOG,
1444: 'Copy rows from interface table to gl_cross_rate_temp.');
1445: END IF;
1446:
1447: INSERT INTO gl_cross_rate_temp
1448: (conversion_type, pivot_currency, from_currency,

Line 1447: INSERT INTO gl_cross_rate_temp

1443: (fnd_file.LOG,
1444: 'Copy rows from interface table to gl_cross_rate_temp.');
1445: END IF;
1446:
1447: INSERT INTO gl_cross_rate_temp
1448: (conversion_type, pivot_currency, from_currency,
1449: to_currency, from_conversion_date,
1450: to_conversion_date, conversion_rate,
1451: inverse_conversion_rate, mode_flag,

Line 1510: UPDATE gl_cross_rate_temp ri

1506: IF DEBUG_MODE THEN
1507: fnd_file.put_line(fnd_file.LOG, 'Update the used for ab translation');
1508: END IF;
1509:
1510: UPDATE gl_cross_rate_temp ri
1511: SET used_for_ab_translation =
1512: ( SELECT nvl(max('Y'), 'N')
1513: FROM gl_daily_conversion_types ct,
1514: gl_ledgers led,

Line 1536: FROM gl_cross_rate_temp

1532: BEGIN
1533:
1534: SELECT 'Y'
1535: INTO l_launch_rate_change
1536: FROM gl_cross_rate_temp
1537: WHERE used_for_ab_translation = 'Y'
1538: AND ROWNUM < 2;
1539:
1540: EXCEPTION

Line 1572: gl_cross_rate_temp glcrt,

1568: usr_daily_rate_cannot_delete.r_rate,
1569: usr_daily_rate_cannot_delete.r_rate_source_code
1570: FROM gl_daily_rates gldr,
1571: gl_daily_conversion_types gldct,
1572: gl_cross_rate_temp glcrt,
1573: gl_row_multipliers glrm
1574: WHERE gldr.conversion_type = gldct.conversion_type
1575: AND ( (gldr.rate_source_code IS NULL)
1576: OR ( (gldr.rate_source_code IS NOT NULL)

Line 1645: gl_cross_rate_temp glcrt,

1641: usr_daily_rate_cannot_override.r_rate,
1642: usr_daily_rate_cannot_override.r_rate_source_code
1643: FROM gl_daily_rates gldr,
1644: gl_daily_conversion_types gldct,
1645: gl_cross_rate_temp glcrt,
1646: gl_row_multipliers glrm
1647: WHERE gldr.conversion_type = gldct.conversion_type
1648: AND ( (gldr.rate_source_code IS NULL)
1649: OR ( (gldr.rate_source_code IS NOT NULL)

Line 1732: gl_cross_rate_temp glcrt,

1728: glcrt.conversion_type,
1729: TRUNC(glcrt.from_conversion_date)
1730: + glrm.multiplier - 1
1731: FROM gl_row_multipliers glrm,
1732: gl_cross_rate_temp glcrt,
1733: gl_daily_rates gldr
1734: WHERE glcrt.mode_flag = 'D'
1735: AND glcrt.used_for_ab_translation = 'Y'
1736: AND gldr.from_currency = glcrt.from_currency

Line 1754: gl_cross_rate_temp glcrt,

1750: glcrt.conversion_type,
1751: TRUNC(glcrt.from_conversion_date)
1752: + glrm.multiplier - 1
1753: FROM gl_row_multipliers glrm,
1754: gl_cross_rate_temp glcrt,
1755: gl_daily_rates gldr
1756: WHERE glcrt.mode_flag = 'D'
1757: AND glcrt.used_for_ab_translation = 'Y'
1758: AND gldr.to_currency = glcrt.from_currency

Line 1794: gl_cross_rate_temp glcrt,

1790: glcrt.conversion_type,
1791: TRUNC(glcrt.from_conversion_date)
1792: + glrm.multiplier - 1
1793: FROM gl_row_multipliers glrm,
1794: gl_cross_rate_temp glcrt,
1795: gl_daily_rates gldr
1796: WHERE ( glcrt.mode_flag in ('I', 'T')
1797: OR ( glcrt.mode_flag = 'D'
1798: AND glcrt.used_for_ab_translation <>

Line 1819: gl_cross_rate_temp glcrt,

1815: glcrt.conversion_type,
1816: TRUNC(glcrt.from_conversion_date)
1817: + glrm.multiplier - 1
1818: FROM gl_row_multipliers glrm,
1819: gl_cross_rate_temp glcrt,
1820: gl_daily_rates gldr
1821: WHERE ( glcrt.mode_flag in ('I', 'T')
1822: OR ( glcrt.mode_flag = 'D'
1823: AND glcrt.used_for_ab_translation <>

Line 1845: UPDATE gl_cross_rate_temp rt

1841: fnd_file.put_line(fnd_file.LOG,
1842: SQL%ROWCOUNT || ' rows deleted.');
1843: END IF;
1844:
1845: UPDATE gl_cross_rate_temp rt
1846: SET mode_flag = 'F'
1847: WHERE mode_flag = 'N'
1848: AND (EXISTS (SELECT 1 FROM gl_daily_rates dr
1849: WHERE dr.from_currency = rt.from_currency

Line 1881: gl_cross_rate_temp glcrt,

1877: glcrt.inverse_conversion_rate * gldr.conversion_rate,
1878: DECODE(glcrt.used_for_ab_translation, 'Y', 'O', 'C'),
1879: SYSDATE, 1, SYSDATE, 1, 1, 'SYSTEM'
1880: FROM gl_row_multipliers glrm,
1881: gl_cross_rate_temp glcrt,
1882: gl_daily_rates gldr
1883: WHERE glcrt.mode_flag in ('I', 'T', 'N')
1884: AND gldr.from_currency = glcrt.pivot_currency
1885: AND gldr.to_currency = glcrt.to_currency

Line 1925: gl_cross_rate_temp glcrt,

1921: glcrt.conversion_rate * gldr.conversion_rate,
1922: DECODE(glcrt.used_for_ab_translation, 'Y', 'O', 'C'),
1923: SYSDATE, 1, SYSDATE, 1, 1, 'SYSTEM'
1924: FROM gl_row_multipliers glrm,
1925: gl_cross_rate_temp glcrt,
1926: gl_daily_rates gldr
1927: WHERE glcrt.mode_flag in ('I', 'T', 'N')
1928: AND gldr.to_currency = glcrt.pivot_currency
1929: AND gldr.from_currency = glcrt.to_currency