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.MSD_DEM_COLLECT_CURRENCY dependencies on FND_PROFILE

Line 245: l_stmt := 'delete from ' || fnd_profile.VALUE('MSD_DEM_SCHEMA') || '.' || new_currency.real_table || ' where index_date between :1 and :2 ';

241: msd_dem_common_utilities.log_debug('Collecting Currency : ' || p_currency_code);
242:
243: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS'));
244:
245: l_stmt := 'delete from ' || fnd_profile.VALUE('MSD_DEM_SCHEMA') || '.' || new_currency.real_table || ' where index_date between :1 and :2 ';
246:
247: msd_dem_common_utilities.log_debug('Bind Variables: ');
248: msd_dem_common_utilities.log_debug('From Date: ' || p_from_date);
249: msd_dem_common_utilities.log_debug('To Date: ' || p_to_date);

Line 256: l_stmt := 'insert into ' || fnd_profile.VALUE('MSD_DEM_SCHEMA') || '.' || new_currency.real_table || ' (index_date, index_value) ' || '(select conversion_date, round(conversion_rate, 5) from

252: EXECUTE IMMEDIATE l_stmt USING p_from_date,
253: p_to_date;
254:
255: IF(p_currency_code <> l_base_curr) THEN
256: l_stmt := 'insert into ' || fnd_profile.VALUE('MSD_DEM_SCHEMA') || '.' || new_currency.real_table || ' (index_date, index_value) ' || '(select conversion_date, round(conversion_rate, 5) from
257: gl_daily_ratesDBLINK
258: where from_currency = ' || '''' || p_base_currency_code || '''' || ' and to_currency = ' || '''' || p_currency_code || '''' || ' and conversion_date between :1 and :2 ' ||
259: ' and conversion_type = fnd_profile.valueDBLINK(''MSD_DEM_CONVERSION_TYPE'') )';
260: l_stmt := REPLACE(l_stmt, 'DBLINK', g_dblink);

Line 259: ' and conversion_type = fnd_profile.valueDBLINK(''MSD_DEM_CONVERSION_TYPE'') )';

255: IF(p_currency_code <> l_base_curr) THEN
256: l_stmt := 'insert into ' || fnd_profile.VALUE('MSD_DEM_SCHEMA') || '.' || new_currency.real_table || ' (index_date, index_value) ' || '(select conversion_date, round(conversion_rate, 5) from
257: gl_daily_ratesDBLINK
258: where from_currency = ' || '''' || p_base_currency_code || '''' || ' and to_currency = ' || '''' || p_currency_code || '''' || ' and conversion_date between :1 and :2 ' ||
259: ' and conversion_type = fnd_profile.valueDBLINK(''MSD_DEM_CONVERSION_TYPE'') )';
260: l_stmt := REPLACE(l_stmt, 'DBLINK', g_dblink);
261: ELSE
262: l_stmt := 'insert into ' || fnd_profile.VALUE('MSD_DEM_SCHEMA') || '.' || new_currency.real_table || ' (index_date, index_value) ' || '(select conversion_date, round((1/conversion_rate), 5) from
263: gl_daily_ratesDBLINK

Line 262: l_stmt := 'insert into ' || fnd_profile.VALUE('MSD_DEM_SCHEMA') || '.' || new_currency.real_table || ' (index_date, index_value) ' || '(select conversion_date, round((1/conversion_rate), 5) from

258: where from_currency = ' || '''' || p_base_currency_code || '''' || ' and to_currency = ' || '''' || p_currency_code || '''' || ' and conversion_date between :1 and :2 ' ||
259: ' and conversion_type = fnd_profile.valueDBLINK(''MSD_DEM_CONVERSION_TYPE'') )';
260: l_stmt := REPLACE(l_stmt, 'DBLINK', g_dblink);
261: ELSE
262: l_stmt := 'insert into ' || fnd_profile.VALUE('MSD_DEM_SCHEMA') || '.' || new_currency.real_table || ' (index_date, index_value) ' || '(select conversion_date, round((1/conversion_rate), 5) from
263: gl_daily_ratesDBLINK
264: where from_currency = ' || '''' || p_currency_code || '''' || ' and to_currency = ' || '''' || p_base_currency_code || '''' || ' and conversion_date between :1 and :2 ' ||
265: ' and conversion_type = fnd_profile.valueDBLINK(''MSD_DEM_CONVERSION_TYPE'') )';
266: l_stmt := REPLACE(l_stmt, 'DBLINK', g_dblink);

Line 265: ' and conversion_type = fnd_profile.valueDBLINK(''MSD_DEM_CONVERSION_TYPE'') )';

261: ELSE
262: l_stmt := 'insert into ' || fnd_profile.VALUE('MSD_DEM_SCHEMA') || '.' || new_currency.real_table || ' (index_date, index_value) ' || '(select conversion_date, round((1/conversion_rate), 5) from
263: gl_daily_ratesDBLINK
264: where from_currency = ' || '''' || p_currency_code || '''' || ' and to_currency = ' || '''' || p_base_currency_code || '''' || ' and conversion_date between :1 and :2 ' ||
265: ' and conversion_type = fnd_profile.valueDBLINK(''MSD_DEM_CONVERSION_TYPE'') )';
266: l_stmt := REPLACE(l_stmt, 'DBLINK', g_dblink);
267: END IF;
268:
269: msd_dem_common_utilities.log_debug(l_stmt);

Line 275: l_stmt := 'select count(*) from ' || fnd_profile.VALUE('MSD_DEM_SCHEMA') || '.' || new_currency.real_table || ' where rownum < 5';

271: EXECUTE IMMEDIATE l_stmt USING p_from_date,
272: p_to_date;
273: COMMIT;
274:
275: l_stmt := 'select count(*) from ' || fnd_profile.VALUE('MSD_DEM_SCHEMA') || '.' || new_currency.real_table || ' where rownum < 5';
276:
277: execute immediate l_stmt into l_cur_count;
278:
279: if l_cur_count = 0 then

Line 340: l_base_curr := fnd_profile.VALUE('MSD_DEM_CURRENCY_CODE');

336: /* Get the min and max date in demantra time */
337:
338: get_min_max_date(l_min_date, l_max_date);
339:
340: l_base_curr := fnd_profile.VALUE('MSD_DEM_CURRENCY_CODE');
341:
342: l_date_from := nvl(fnd_date.canonical_to_date(p_from_date), l_min_date);
343: l_date_to := nvl(fnd_date.canonical_to_date(p_to_date), l_max_date);
344:

Line 381: ' and conversion_type = fnd_profile.value' || g_dblink || '(''MSD_DEM_CONVERSION_TYPE'') ';

377:
378: l_stmt := NULL;
379:
380: l_stmt := 'select distinct from_currency from_currency ' || ' from gl_daily_rates' || g_dblink || ' where to_currency = ''' || l_base_curr || '''' ||
381: ' and conversion_type = fnd_profile.value' || g_dblink || '(''MSD_DEM_CONVERSION_TYPE'') ';
382:
383: l_list := NULL;
384: l_list2 := NULL;
385: