APPS.HR_CURRENCY_PKG dependencies on GL_DAILY_RATES

Line 42: g_from_currency gl_daily_rates.from_currency%TYPE := null;

38: --
39: -- The following global variables are used for chaching in function
40: -- get_other_rate
41: --
42: g_from_currency gl_daily_rates.from_currency%TYPE := null;
43: g_to_currency gl_daily_rates.to_currency%TYPE := null;
44: g_conversion_date gl_daily_rates.conversion_date%TYPE := null;
45: g_conversion_type gl_daily_rates.conversion_type%TYPE := null;
46: g_conversion_rate gl_daily_rates.conversion_rate%TYPE := null;

Line 43: g_to_currency gl_daily_rates.to_currency%TYPE := null;

39: -- The following global variables are used for chaching in function
40: -- get_other_rate
41: --
42: g_from_currency gl_daily_rates.from_currency%TYPE := null;
43: g_to_currency gl_daily_rates.to_currency%TYPE := null;
44: g_conversion_date gl_daily_rates.conversion_date%TYPE := null;
45: g_conversion_type gl_daily_rates.conversion_type%TYPE := null;
46: g_conversion_rate gl_daily_rates.conversion_rate%TYPE := null;
47: --

Line 44: g_conversion_date gl_daily_rates.conversion_date%TYPE := null;

40: -- get_other_rate
41: --
42: g_from_currency gl_daily_rates.from_currency%TYPE := null;
43: g_to_currency gl_daily_rates.to_currency%TYPE := null;
44: g_conversion_date gl_daily_rates.conversion_date%TYPE := null;
45: g_conversion_type gl_daily_rates.conversion_type%TYPE := null;
46: g_conversion_rate gl_daily_rates.conversion_rate%TYPE := null;
47: --
48: -- The following global variables are used for caching in function

Line 45: g_conversion_type gl_daily_rates.conversion_type%TYPE := null;

41: --
42: g_from_currency gl_daily_rates.from_currency%TYPE := null;
43: g_to_currency gl_daily_rates.to_currency%TYPE := null;
44: g_conversion_date gl_daily_rates.conversion_date%TYPE := null;
45: g_conversion_type gl_daily_rates.conversion_type%TYPE := null;
46: g_conversion_rate gl_daily_rates.conversion_rate%TYPE := null;
47: --
48: -- The following global variables are used for caching in function
49: -- convert_amount

Line 46: g_conversion_rate gl_daily_rates.conversion_rate%TYPE := null;

42: g_from_currency gl_daily_rates.from_currency%TYPE := null;
43: g_to_currency gl_daily_rates.to_currency%TYPE := null;
44: g_conversion_date gl_daily_rates.conversion_date%TYPE := null;
45: g_conversion_type gl_daily_rates.conversion_type%TYPE := null;
46: g_conversion_rate gl_daily_rates.conversion_rate%TYPE := null;
47: --
48: -- The following global variables are used for caching in function
49: -- convert_amount
50: --

Line 51: g_rate_conversion_date gl_daily_rates.conversion_date%TYPE;

47: --
48: -- The following global variables are used for caching in function
49: -- convert_amount
50: --
51: g_rate_conversion_date gl_daily_rates.conversion_date%TYPE;
52: g_rate_to_currency gl_daily_rates.to_currency%TYPE;
53: g_rate_rate_type gl_daily_rates.conversion_type%TYPE;
54: g_rate_rounding NUMBER;
55: g_rate_to_rate NUMBER;

Line 52: g_rate_to_currency gl_daily_rates.to_currency%TYPE;

48: -- The following global variables are used for caching in function
49: -- convert_amount
50: --
51: g_rate_conversion_date gl_daily_rates.conversion_date%TYPE;
52: g_rate_to_currency gl_daily_rates.to_currency%TYPE;
53: g_rate_rate_type gl_daily_rates.conversion_type%TYPE;
54: g_rate_rounding NUMBER;
55: g_rate_to_rate NUMBER;
56: g_rate_to_mau NUMBER;

Line 53: g_rate_rate_type gl_daily_rates.conversion_type%TYPE;

49: -- convert_amount
50: --
51: g_rate_conversion_date gl_daily_rates.conversion_date%TYPE;
52: g_rate_to_currency gl_daily_rates.to_currency%TYPE;
53: g_rate_rate_type gl_daily_rates.conversion_type%TYPE;
54: g_rate_rounding NUMBER;
55: g_rate_to_rate NUMBER;
56: g_rate_to_mau NUMBER;
57: g_rate_to_type VARCHAR2(8);

Line 327: -- Get conversion rate between the two currencies from GL_DAILY_RATES

323: hr_utility.trace(' cache '||rate);
324: return(rate);
325: --
326: else
327: -- Get conversion rate between the two currencies from GL_DAILY_RATES
328: SELECT conversion_rate
329: INTO rate
330: FROM GL_DAILY_RATES
331: WHERE from_currency = p_from_currency

Line 330: FROM GL_DAILY_RATES

326: else
327: -- Get conversion rate between the two currencies from GL_DAILY_RATES
328: SELECT conversion_rate
329: INTO rate
330: FROM GL_DAILY_RATES
331: WHERE from_currency = p_from_currency
332: AND to_currency = p_to_currency
333: AND conversion_date = trunc(p_conversion_date)
334: AND conversion_type = p_conversion_type;