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.OKI_REFRESH_PVT dependencies on GL_DAILY_RATES

Line 1218: TYPE rate_tab_typ IS TABLE OF gl_daily_rates.conversion_rate%TYPE INDEX BY BINARY_INTEGER;

1214: TYPE chr_id_tab_typ IS TABLE OF oki_sales_k_hdrs.chr_id%TYPE INDEX BY BINARY_INTEGER;
1215: TYPE version_number_tab_typ IS TABLE OF oki_sales_k_hdrs.major_version%TYPE INDEX BY BINARY_INTEGER;
1216: TYPE date_tab_typ IS TABLE OF oki_sales_k_hdrs.start_date%TYPE INDEX BY BINARY_INTEGER;
1217: TYPE currency_tab_typ IS TABLE OF oki_sales_k_hdrs.currency_code%TYPE INDEX BY BINARY_INTEGER;
1218: TYPE rate_tab_typ IS TABLE OF gl_daily_rates.conversion_rate%TYPE INDEX BY BINARY_INTEGER;
1219:
1220: TYPE sob_acct_period_tab_typ IS TABLE OF gl_sets_of_books.accounted_period_type%TYPE INDEX BY BINARY_INTEGER;
1221: TYPE sob_id_tab_typ IS TABLE OF gl_sets_of_books.set_of_books_id%TYPE INDEX BY BINARY_INTEGER;
1222: TYPE period_set_name_tab_typ IS TABLE OF gl_sets_of_books.period_set_name%TYPE INDEX BY BINARY_INTEGER;

Line 1276: l_conv_type gl_daily_rates.conversion_type%TYPE;

1272: AND oin.org_information_context = 'Operating Unit Information'
1273: AND sob.set_of_books_id = oin.org_information3;
1274:
1275:
1276: l_conv_type gl_daily_rates.conversion_type%TYPE;
1277:
1278: CURSOR cur_currency_rate(l_curr_date Date,
1279: l_from_curr Varchar2,
1280: l_to_curr Varchar2,

Line 1282: Select conversion_rate from gl_daily_rates

1278: CURSOR cur_currency_rate(l_curr_date Date,
1279: l_from_curr Varchar2,
1280: l_to_curr Varchar2,
1281: l_conv_type Varchar2) IS
1282: Select conversion_rate from gl_daily_rates
1283: Where from_currency = l_from_curr
1284: And to_currency = l_to_curr
1285: And conversion_date = (SELECT MAX(conversion_date)
1286: FROM gl_daily_rates

Line 1286: FROM gl_daily_rates

1282: Select conversion_rate from gl_daily_rates
1283: Where from_currency = l_from_curr
1284: And to_currency = l_to_curr
1285: And conversion_date = (SELECT MAX(conversion_date)
1286: FROM gl_daily_rates
1287: WHERE from_currency = l_from_curr
1288: AND to_currency = l_to_curr
1289: AND conversion_date <= l_curr_date
1290: AND conversion_type = l_conv_type)

Line 1874: -- 1. gets the latest conversion rate from GL_Daily_Rates given a

1870: /***11510 Change New Function to get the conversion rates for the contracts ***/
1871: ---------------------------------------------------------------------
1872: -- Function get_conversion_rate
1873: --
1874: -- 1. gets the latest conversion rate from GL_Daily_Rates given a
1875: -- conversion date,From and To currency
1876: -- Returns 0 if the conversion rates could not be found
1877: -- Returns 1 if the from and to cirrency are same
1878: -- Returns -1 if some error occurs during the calculation of the rate

Line 1887: l_conv_type gl_daily_rates.conversion_type%TYPE;

1883: , p_to_currency IN VARCHAR2
1884: ) RETURN NUMBER
1885: IS
1886:
1887: l_conv_type gl_daily_rates.conversion_type%TYPE;
1888:
1889: CURSOR cur_currency_rate (p_curr_date Date,
1890: p_from_currency varchar2,
1891: p_to_currency varchar2)

Line 1893: SELECT conversion_rate FROM gl_daily_rates

1889: CURSOR cur_currency_rate (p_curr_date Date,
1890: p_from_currency varchar2,
1891: p_to_currency varchar2)
1892: IS
1893: SELECT conversion_rate FROM gl_daily_rates
1894: WHERE from_currency = p_from_currency
1895: AND to_currency = p_to_currency
1896: AND conversion_date = (SELECT MAX (conversion_date)
1897: FROM gl_daily_rates

Line 1897: FROM gl_daily_rates

1893: SELECT conversion_rate FROM gl_daily_rates
1894: WHERE from_currency = p_from_currency
1895: AND to_currency = p_to_currency
1896: AND conversion_date = (SELECT MAX (conversion_date)
1897: FROM gl_daily_rates
1898: WHERE from_currency = p_from_currency
1899: AND to_currency = p_to_currency
1900: AND conversion_date <= p_curr_date
1901: AND conversion_type = l_conv_type)

Line 2224: -- l_conversion_type gl_daily_rates.conversion_type%TYPE := 'Corporate';

2220: PROCEDURE refresh_daily_rates(errbuf OUT NOCOPY VARCHAR2
2221: ,retcode OUT NOCOPY VARCHAR2) IS
2222:
2223: v_dummy varchar2(1);
2224: -- l_conversion_type gl_daily_rates.conversion_type%TYPE := 'Corporate';
2225: l_conversion_type gl_daily_rates.conversion_type%TYPE ;
2226: l_no_update_refresh EXCEPTION;
2227: CURSOR c_conversion IS
2228: SELECT a.from_currency,

Line 2225: l_conversion_type gl_daily_rates.conversion_type%TYPE ;

2221: ,retcode OUT NOCOPY VARCHAR2) IS
2222:
2223: v_dummy varchar2(1);
2224: -- l_conversion_type gl_daily_rates.conversion_type%TYPE := 'Corporate';
2225: l_conversion_type gl_daily_rates.conversion_type%TYPE ;
2226: l_no_update_refresh EXCEPTION;
2227: CURSOR c_conversion IS
2228: SELECT a.from_currency,
2229: a.to_currency,

Line 2232: FROM gl_daily_rates a

2228: SELECT a.from_currency,
2229: a.to_currency,
2230: a.conversion_rate,
2231: a.conversion_date
2232: FROM gl_daily_rates a
2233: WHERE (a.from_currency, a.to_currency, a.conversion_date) IN
2234: ( SELECT b.from_currency, b.to_currency, MAX(b.conversion_date) conversion_date
2235: FROM gl_daily_rates b
2236: WHERE b.conversion_type = l_conversion_type

Line 2235: FROM gl_daily_rates b

2231: a.conversion_date
2232: FROM gl_daily_rates a
2233: WHERE (a.from_currency, a.to_currency, a.conversion_date) IN
2234: ( SELECT b.from_currency, b.to_currency, MAX(b.conversion_date) conversion_date
2235: FROM gl_daily_rates b
2236: WHERE b.conversion_type = l_conversion_type
2237: GROUP BY b.from_currency, b.to_currency)
2238: AND a.conversion_type = l_conversion_type;
2239: BEGIN