DBA Data[Home] [Help]

APPS.AS_MC_PKG dependencies on FND_PROFILE

Line 67: l_conversion_type := FND_PROFILE.value('AS_MC_DAILY_CONVERSION_TYPE');

63: IF (p_from_currency = p_to_currency) THEN
64: return(p_amount);
65: END IF;
66: -- Decide the value of AS_MC_DAILY_CONVERSION_TYPE is valid
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

Line 124: l_conversion_type := fnd_profile.value_WNPS('AS_MC_DAILY_CONVERSION_TYPE');

120: IF (p_from_currency = p_to_currency) THEN
121: return(p_amount);
122: END IF;
123: -- Decide the value of AS_MC_DAILY_CONVERSION_TYPE is valid
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

Line 244: l_calendar := FND_PROFILE.value_WNPS('AS_FORECAST_CALENDAR');

240: FROM GL_PERIODS
241: WHERE PERIOD_SET_NAME = l_calendar
242: AND PERIOD_NAME = l_period;
243: BEGIN
244: l_calendar := FND_PROFILE.value_WNPS('AS_FORECAST_CALENDAR');
245: IF (l_calendar IS NULL) THEN
246: raise INVALID_FORECAST_CALENDAR;
247: END IF;
248: l_date_mapping := FND_PROFILE.value_WNPS('AS_MC_DATE_MAPPING_TYPE');

Line 248: l_date_mapping := FND_PROFILE.value_WNPS('AS_MC_DATE_MAPPING_TYPE');

244: l_calendar := FND_PROFILE.value_WNPS('AS_FORECAST_CALENDAR');
245: IF (l_calendar IS NULL) THEN
246: raise INVALID_FORECAST_CALENDAR;
247: END IF;
248: l_date_mapping := FND_PROFILE.value_WNPS('AS_MC_DATE_MAPPING_TYPE');
249: l_period := p_period;
250: OPEN l_period_csr;
251: FETCH l_period_csr INTO x_period_type, l_start_date, l_end_date;
252: IF NOT l_period_csr%FOUND THEN

Line 298: l_calendar := FND_PROFILE.value_WNPS('AS_FORECAST_CALENDAR');

294: FROM AS_MC_TYPE_MAPPINGS
295: WHERE PERIOD_SET_NAME = l_calendar
296: AND PERIOD_TYPE = l_period_type;
297: BEGIN
298: l_calendar := FND_PROFILE.value_WNPS('AS_FORECAST_CALENDAR');
299: IF (l_calendar IS NULL) THEN
300: raise INVALID_FORECAST_CALENDAR;
301: END IF;
302: l_period_type := p_period_type;

Line 516: l_conversion_type := FND_PROFILE.value('AS_MC_DAILY_CONVERSION_TYPE');

512: IF (p_from_currency = p_to_currency) THEN
513: RETURN(1);
514: END IF;
515: -- API Body
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,

Line 564: l_conversion_type := FND_PROFILE.value('AS_MC_DAILY_CONVERSION_TYPE');

560: IF (p_from_currency = p_to_currency) THEN
561: RETURN(1);
562: END IF;
563: -- API Body
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,

Line 745: l_conversion_type := FND_PROFILE.value('AS_MC_DAILY_CONVERSION_TYPE');

741: x_rate_date := p_conversion_date;
742: RETURN('Y');
743: END IF;
744: -- API Body
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,