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.AS_MC_PKG dependencies on GL_CURRENCY_API

Line 49: -- The above definition follows rules defined in GL_CURRENCY_API.

45: -- conversion date for the most recent date on which a rate is defined.
46: -- 2. If it is a negative number, the function will look backward without any
47: -- date limit to find the most recent date on which a rate is defined.
48: -- 3. If it is zero, the funtion doesn't look backward. This is the default value.
49: -- The above definition follows rules defined in GL_CURRENCY_API.
50: -- End of Comments
51: --
52: FUNCTION convert_amount_daily (
53: p_from_currency IN VARCHAR2,

Line 71: -- Call GL_CURRENCY_API to do conversion

67: l_conversion_type := FND_PROFILE.value('AS_MC_DAILY_CONVERSION_TYPE');
68: IF (l_conversion_type IS NULL) THEN
69: raise INVALID_DAILY_CONVERSION_TYPE;
70: END IF;
71: -- Call GL_CURRENCY_API to do conversion
72: l_converted_amount := gl_currency_api.convert_closest_amount_sql(p_from_currency,
73: p_to_currency,p_conversion_date,l_conversion_type,0,p_amount,p_max_roll_days);
74: IF l_converted_amount = -1 THEN
75: raise gl_currency_api.NO_RATE;

Line 72: l_converted_amount := gl_currency_api.convert_closest_amount_sql(p_from_currency,

68: IF (l_conversion_type IS NULL) THEN
69: raise INVALID_DAILY_CONVERSION_TYPE;
70: END IF;
71: -- Call GL_CURRENCY_API to do conversion
72: l_converted_amount := gl_currency_api.convert_closest_amount_sql(p_from_currency,
73: p_to_currency,p_conversion_date,l_conversion_type,0,p_amount,p_max_roll_days);
74: IF l_converted_amount = -1 THEN
75: raise gl_currency_api.NO_RATE;
76: ELSIF l_converted_amount = -2 THEN

Line 75: raise gl_currency_api.NO_RATE;

71: -- Call GL_CURRENCY_API to do conversion
72: l_converted_amount := gl_currency_api.convert_closest_amount_sql(p_from_currency,
73: p_to_currency,p_conversion_date,l_conversion_type,0,p_amount,p_max_roll_days);
74: IF l_converted_amount = -1 THEN
75: raise gl_currency_api.NO_RATE;
76: ELSIF l_converted_amount = -2 THEN
77: raise gl_currency_api.INVALID_CURRENCY;
78: END IF;
79: return(l_converted_amount);

Line 77: raise gl_currency_api.INVALID_CURRENCY;

73: p_to_currency,p_conversion_date,l_conversion_type,0,p_amount,p_max_roll_days);
74: IF l_converted_amount = -1 THEN
75: raise gl_currency_api.NO_RATE;
76: ELSIF l_converted_amount = -2 THEN
77: raise gl_currency_api.INVALID_CURRENCY;
78: END IF;
79: return(l_converted_amount);
80:
81: END convert_amount_daily;

Line 128: -- Call GL_CURRENCY_API to do conversion

124: l_conversion_type := fnd_profile.value_WNPS('AS_MC_DAILY_CONVERSION_TYPE');
125: IF (l_conversion_type IS NULL) THEN
126: raise INVALID_DAILY_CONVERSION_TYPE;
127: END IF;
128: -- Call GL_CURRENCY_API to do conversion
129: l_converted_amount := gl_currency_api.convert_closest_amount_sql(p_from_currency,
130: p_to_currency,p_conversion_date,l_conversion_type,0,p_amount,p_max_roll_days);
131: IF l_converted_amount = -1 THEN
132: l_converted_amount := G_NEG_MAX;

Line 129: l_converted_amount := gl_currency_api.convert_closest_amount_sql(p_from_currency,

125: IF (l_conversion_type IS NULL) THEN
126: raise INVALID_DAILY_CONVERSION_TYPE;
127: END IF;
128: -- Call GL_CURRENCY_API to do conversion
129: l_converted_amount := gl_currency_api.convert_closest_amount_sql(p_from_currency,
130: p_to_currency,p_conversion_date,l_conversion_type,0,p_amount,p_max_roll_days);
131: IF l_converted_amount = -1 THEN
132: l_converted_amount := G_NEG_MAX;
133: ELSIF l_converted_amount = -2 THEN

Line 190: -- Call GL_CURRENCY_API to do conversion

186:
187: IF (p_conversion_type IS NULL) THEN
188: raise INVALID_DAILY_CONVERSION_TYPE;
189: END IF;
190: -- Call GL_CURRENCY_API to do conversion
191: l_converted_amount := gl_currency_api.convert_closest_amount_sql(p_from_currency,
192: p_to_currency,p_conversion_date,p_conversion_type,0,p_amount,p_max_roll_days);
193: IF l_converted_amount = -1 THEN
194: l_converted_amount := G_NEG_MAX;

Line 191: l_converted_amount := gl_currency_api.convert_closest_amount_sql(p_from_currency,

187: IF (p_conversion_type IS NULL) THEN
188: raise INVALID_DAILY_CONVERSION_TYPE;
189: END IF;
190: -- Call GL_CURRENCY_API to do conversion
191: l_converted_amount := gl_currency_api.convert_closest_amount_sql(p_from_currency,
192: p_to_currency,p_conversion_date,p_conversion_type,0,p_amount,p_max_roll_days);
193: IF l_converted_amount = -1 THEN
194: l_converted_amount := G_NEG_MAX;
195: ELSIF l_converted_amount = -2 THEN

Line 355: -- Call GL_CURRENCY_API to do conversion

351: RETURN(p_amount);
352: END IF;
353: get_period_info(p_conversion_period, l_period_type, l_conversion_date);
354: l_conversion_type := get_conversion_type(l_period_type);
355: -- Call GL_CURRENCY_API to do conversion
356: l_converted_amount := gl_currency_api.convert_amount(p_from_currency,p_to_currency,
357: l_conversion_date, l_conversion_type, p_amount);
358: RETURN(l_converted_amount);
359: END convert_amount_period;

Line 356: l_converted_amount := gl_currency_api.convert_amount(p_from_currency,p_to_currency,

352: END IF;
353: get_period_info(p_conversion_period, l_period_type, l_conversion_date);
354: l_conversion_type := get_conversion_type(l_period_type);
355: -- Call GL_CURRENCY_API to do conversion
356: l_converted_amount := gl_currency_api.convert_amount(p_from_currency,p_to_currency,
357: l_conversion_date, l_conversion_type, p_amount);
358: RETURN(l_converted_amount);
359: END convert_amount_period;
360:

Line 404: l_converted_amount := gl_currency_api.convert_amount(p_from_currency,p_to_currency,

400: END IF;
401: -- API Body
402: get_period_info(p_conversion_period, l_period_type, l_conversion_date);
403: l_conversion_type := get_conversion_type(l_period_type);
404: l_converted_amount := gl_currency_api.convert_amount(p_from_currency,p_to_currency,
405: l_conversion_date, l_conversion_type, p_amount);
406: RETURN(l_converted_amount);
407: EXCEPTION
408: WHEN gl_currency_api.NO_RATE THEN

Line 408: WHEN gl_currency_api.NO_RATE THEN

404: l_converted_amount := gl_currency_api.convert_amount(p_from_currency,p_to_currency,
405: l_conversion_date, l_conversion_type, p_amount);
406: RETURN(l_converted_amount);
407: EXCEPTION
408: WHEN gl_currency_api.NO_RATE THEN
409: return(G_NEG_MAX);
410: WHEN gl_currency_api.INVALID_CURRENCY THEN
411: return(G_NEG_MAX);
412: WHEN INVALID_PERIOD THEN

Line 410: WHEN gl_currency_api.INVALID_CURRENCY THEN

406: RETURN(l_converted_amount);
407: EXCEPTION
408: WHEN gl_currency_api.NO_RATE THEN
409: return(G_NEG_MAX);
410: WHEN gl_currency_api.INVALID_CURRENCY THEN
411: return(G_NEG_MAX);
412: WHEN INVALID_PERIOD THEN
413: return(G_NEG_MAX);
414: WHEN INVALID_FORECAST_CALENDAR THEN

Line 460: l_converted_amount := gl_currency_api.convert_amount(p_from_currency,p_to_currency,

456: IF (p_from_currency = p_to_currency) THEN
457: RETURN(p_amount);
458: END IF;
459: -- API Body
460: l_converted_amount := gl_currency_api.convert_amount(p_from_currency,p_to_currency,
461: p_conversion_date, p_conversion_type, p_amount);
462: RETURN(l_converted_amount);
463: EXCEPTION
464: WHEN gl_currency_api.NO_RATE THEN

Line 464: WHEN gl_currency_api.NO_RATE THEN

460: l_converted_amount := gl_currency_api.convert_amount(p_from_currency,p_to_currency,
461: p_conversion_date, p_conversion_type, p_amount);
462: RETURN(l_converted_amount);
463: EXCEPTION
464: WHEN gl_currency_api.NO_RATE THEN
465: return(G_NEG_MAX);
466: WHEN gl_currency_api.INVALID_CURRENCY THEN
467: return(G_NEG_MAX);
468: WHEN INVALID_PERIOD THEN

Line 466: WHEN gl_currency_api.INVALID_CURRENCY THEN

462: RETURN(l_converted_amount);
463: EXCEPTION
464: WHEN gl_currency_api.NO_RATE THEN
465: return(G_NEG_MAX);
466: WHEN gl_currency_api.INVALID_CURRENCY THEN
467: return(G_NEG_MAX);
468: WHEN INVALID_PERIOD THEN
469: return(G_NEG_MAX);
470: WHEN INVALID_FORECAST_CALENDAR THEN

Line 520: l_conversion_rate := gl_currency_api.get_closest_rate(p_from_currency, p_to_currency,

516: l_conversion_type := FND_PROFILE.value('AS_MC_DAILY_CONVERSION_TYPE');
517: IF (l_conversion_type IS NULL) THEN
518: raise INVALID_DAILY_CONVERSION_TYPE;
519: END IF;
520: l_conversion_rate := gl_currency_api.get_closest_rate(p_from_currency, p_to_currency,
521: p_conversion_date, l_conversion_type, p_max_roll_days);
522: return(l_conversion_rate);
523: END get_daily_rate;
524:

Line 568: l_conversion_rate := gl_currency_api.get_closest_rate(p_from_currency, p_to_currency,

564: l_conversion_type := FND_PROFILE.value('AS_MC_DAILY_CONVERSION_TYPE');
565: IF (l_conversion_type IS NULL) THEN
566: raise INVALID_DAILY_CONVERSION_TYPE;
567: END IF;
568: l_conversion_rate := gl_currency_api.get_closest_rate(p_from_currency, p_to_currency,
569: p_conversion_date, l_conversion_type, p_max_roll_days);
570: return(l_conversion_rate);
571: EXCEPTION
572: WHEN gl_currency_api.NO_RATE THEN

Line 572: WHEN gl_currency_api.NO_RATE THEN

568: l_conversion_rate := gl_currency_api.get_closest_rate(p_from_currency, p_to_currency,
569: p_conversion_date, l_conversion_type, p_max_roll_days);
570: return(l_conversion_rate);
571: EXCEPTION
572: WHEN gl_currency_api.NO_RATE THEN
573: return(G_NEG_MAX);
574: WHEN gl_currency_api.INVALID_CURRENCY THEN
575: return(G_NEG_MAX);
576: WHEN INVALID_DAILY_CONVERSION_TYPE THEN

Line 574: WHEN gl_currency_api.INVALID_CURRENCY THEN

570: return(l_conversion_rate);
571: EXCEPTION
572: WHEN gl_currency_api.NO_RATE THEN
573: return(G_NEG_MAX);
574: WHEN gl_currency_api.INVALID_CURRENCY THEN
575: return(G_NEG_MAX);
576: WHEN INVALID_DAILY_CONVERSION_TYPE THEN
577: return(G_NEG_MAX);
578: WHEN OTHERS THEN

Line 619: l_conversion_rate := gl_currency_api.get_rate(p_from_currency, p_to_currency,

615: END IF;
616: -- API Body
617: get_period_info(p_conversion_period, l_period_type, l_conversion_date);
618: l_conversion_type := get_conversion_type(l_period_type);
619: l_conversion_rate := gl_currency_api.get_rate(p_from_currency, p_to_currency,
620: l_conversion_date, l_conversion_type);
621:
622: return(l_conversion_rate);
623: END get_period_rate;

Line 664: l_conversion_rate := gl_currency_api.get_rate(p_from_currency, p_to_currency,

660: END IF;
661: -- API Body
662: get_period_info(p_conversion_period, l_period_type, l_conversion_date);
663: l_conversion_type := get_conversion_type(l_period_type);
664: l_conversion_rate := gl_currency_api.get_rate(p_from_currency, p_to_currency,
665: l_conversion_date, l_conversion_type);
666:
667: return(l_conversion_rate);
668: EXCEPTION

Line 669: WHEN gl_currency_api.NO_RATE THEN

665: l_conversion_date, l_conversion_type);
666:
667: return(l_conversion_rate);
668: EXCEPTION
669: WHEN gl_currency_api.NO_RATE THEN
670: return(G_NEG_MAX);
671: WHEN gl_currency_api.INVALID_CURRENCY THEN
672: return(G_NEG_MAX);
673: WHEN INVALID_PERIOD THEN

Line 671: WHEN gl_currency_api.INVALID_CURRENCY THEN

667: return(l_conversion_rate);
668: EXCEPTION
669: WHEN gl_currency_api.NO_RATE THEN
670: return(G_NEG_MAX);
671: WHEN gl_currency_api.INVALID_CURRENCY THEN
672: return(G_NEG_MAX);
673: WHEN INVALID_PERIOD THEN
674: return(G_NEG_MAX);
675: WHEN INVALID_FORECAST_CALENDAR THEN

Line 706: -- follows the searching rule defined in GL_CURRENCY_API. So, if the rule is

702: -- History :
703: -- 22-Sep-98 J. Shang Created
704: -- Note :
705: -- In this function, a cursor is defined to search a closest rate. The query
706: -- follows the searching rule defined in GL_CURRENCY_API. So, if the rule is
707: -- changed in GL_CURRENCY_API, this cursor has to be changed also.
708: -- End of Comments
709: --
710: FUNCTION daily_rate_exists (

Line 707: -- changed in GL_CURRENCY_API, this cursor has to be changed also.

703: -- 22-Sep-98 J. Shang Created
704: -- Note :
705: -- In this function, a cursor is defined to search a closest rate. The query
706: -- follows the searching rule defined in GL_CURRENCY_API. So, if the rule is
707: -- changed in GL_CURRENCY_API, this cursor has to be changed also.
708: -- End of Comments
709: --
710: FUNCTION daily_rate_exists (
711: p_from_currency IN VARCHAR2, -- From currency

Line 749: l_exist_flag := gl_currency_api.rate_exists(p_from_currency, p_to_currency,

745: l_conversion_type := FND_PROFILE.value('AS_MC_DAILY_CONVERSION_TYPE');
746: IF (l_conversion_type IS NULL) THEN
747: raise INVALID_DAILY_CONVERSION_TYPE;
748: END IF;
749: l_exist_flag := gl_currency_api.rate_exists(p_from_currency, p_to_currency,
750: p_conversion_date, l_conversion_type);
751: IF (l_exist_flag = 'Y') THEN
752: x_rate_date := p_conversion_date;
753: ELSE

Line 757: gl_currency_api.get_relation(p_from_currency, p_to_currency,

753: ELSE
754: IF (p_max_roll_days = 0) THEN
755: l_exist_flag := 'N';
756: ELSE
757: gl_currency_api.get_relation(p_from_currency, p_to_currency,
758: p_conversion_date, l_fix_rate, l_relationship);
759: IF (INSTR(l_relationship,'OTHER') <> 0) THEN
760: l_from_currency := p_from_currency;
761: l_to_currency := p_to_currency;

Line 819: l_exist_flag := gl_currency_api.rate_exists(p_from_currency, p_to_currency,

815: END IF;
816: -- API Body
817: get_period_info(p_conversion_period, l_period_type, l_conversion_date);
818: l_conversion_type := get_conversion_type(l_period_type);
819: l_exist_flag := gl_currency_api.rate_exists(p_from_currency, p_to_currency,
820: l_conversion_date, l_conversion_type);
821: return(l_exist_flag);
822: END period_rate_exists;
823:

Line 1003: -- gl_currency_api.NO_RATE

999: -- History :
1000: -- 11-Dec-98 J. Shang Created
1001: -- Note :
1002: -- The possible exceptions generated from this procedure are
1003: -- gl_currency_api.NO_RATE
1004: -- gl_currency_api.INVALID_CURRENCY
1005: -- as_mc_pkg.INVALID_DAILY_CONVERSION_TYPE
1006: -- End of Comments
1007: --

Line 1004: -- gl_currency_api.INVALID_CURRENCY

1000: -- 11-Dec-98 J. Shang Created
1001: -- Note :
1002: -- The possible exceptions generated from this procedure are
1003: -- gl_currency_api.NO_RATE
1004: -- gl_currency_api.INVALID_CURRENCY
1005: -- as_mc_pkg.INVALID_DAILY_CONVERSION_TYPE
1006: -- End of Comments
1007: --
1008: PROCEDURE convert_group_amounts_daily (