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 219: l_stmt := 'delete from ' || fnd_profile.VALUE('MSD_DEM_SCHEMA') || '.' || new_currency.real_table || ' where index_date between :1 and :2 ';

215: msd_dem_common_utilities.log_debug('Collecting Currency : ' || p_currency_code);
216:
217: msd_dem_common_utilities.log_debug('Start Time: ' || to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS'));
218:
219: l_stmt := 'delete from ' || fnd_profile.VALUE('MSD_DEM_SCHEMA') || '.' || new_currency.real_table || ' where index_date between :1 and :2 ';
220:
221: msd_dem_common_utilities.log_debug('Bind Variables: ');
222: msd_dem_common_utilities.log_debug('From Date: ' || p_from_date);
223: msd_dem_common_utilities.log_debug('To Date: ' || p_to_date);

Line 230: 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

226: EXECUTE IMMEDIATE l_stmt USING p_from_date,
227: p_to_date;
228:
229: IF(p_currency_code <> l_base_curr) THEN
230: 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
231: gl_daily_ratesDBLINK
232: where from_currency = ' || '''' || p_base_currency_code || '''' || ' and to_currency = ' || '''' || p_currency_code || '''' || ' and conversion_date between :1 and :2 ' ||
233: ' and conversion_type = ''' || fnd_profile.value('MSD_DEM_CONVERSION_TYPE') || ''' )';
234: l_stmt := REPLACE(l_stmt, 'DBLINK', g_dblink);

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

229: IF(p_currency_code <> l_base_curr) THEN
230: 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
231: gl_daily_ratesDBLINK
232: where from_currency = ' || '''' || p_base_currency_code || '''' || ' and to_currency = ' || '''' || p_currency_code || '''' || ' and conversion_date between :1 and :2 ' ||
233: ' and conversion_type = ''' || fnd_profile.value('MSD_DEM_CONVERSION_TYPE') || ''' )';
234: l_stmt := REPLACE(l_stmt, 'DBLINK', g_dblink);
235: ELSE
236: 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
237: gl_daily_ratesDBLINK

Line 236: 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

232: where from_currency = ' || '''' || p_base_currency_code || '''' || ' and to_currency = ' || '''' || p_currency_code || '''' || ' and conversion_date between :1 and :2 ' ||
233: ' and conversion_type = ''' || fnd_profile.value('MSD_DEM_CONVERSION_TYPE') || ''' )';
234: l_stmt := REPLACE(l_stmt, 'DBLINK', g_dblink);
235: ELSE
236: 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
237: gl_daily_ratesDBLINK
238: where from_currency = ' || '''' || p_currency_code || '''' || ' and to_currency = ' || '''' || p_base_currency_code || '''' || ' and conversion_date between :1 and :2 ' ||
239: ' and conversion_type = ''' || fnd_profile.value('MSD_DEM_CONVERSION_TYPE') || ''')';
240: l_stmt := REPLACE(l_stmt, 'DBLINK', g_dblink);

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

235: ELSE
236: 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
237: gl_daily_ratesDBLINK
238: where from_currency = ' || '''' || p_currency_code || '''' || ' and to_currency = ' || '''' || p_base_currency_code || '''' || ' and conversion_date between :1 and :2 ' ||
239: ' and conversion_type = ''' || fnd_profile.value('MSD_DEM_CONVERSION_TYPE') || ''')';
240: l_stmt := REPLACE(l_stmt, 'DBLINK', g_dblink);
241: END IF;
242:
243: msd_dem_common_utilities.log_debug(l_stmt);

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

245: EXECUTE IMMEDIATE l_stmt USING p_from_date,
246: p_to_date;
247: COMMIT;
248:
249: l_stmt := 'select count(*) from ' || fnd_profile.VALUE('MSD_DEM_SCHEMA') || '.' || new_currency.real_table || ' where rownum < 5';
250:
251: execute immediate l_stmt into l_cur_count;
252:
253: if l_cur_count = 0 then

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

310: /* Get the min and max date in demantra time */
311:
312: get_min_max_date(l_min_date, l_max_date);
313:
314: l_base_curr := fnd_profile.VALUE('MSD_DEM_CURRENCY_CODE');
315:
316: l_date_from := nvl(fnd_date.canonical_to_date(p_from_date), l_min_date);
317: l_date_to := nvl(fnd_date.canonical_to_date(p_to_date), l_max_date);
318:

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

351:
352: l_stmt := NULL;
353:
354: l_stmt := 'select distinct from_currency from_currency ' || ' from gl_daily_rates' || g_dblink || ' where to_currency = ''' || l_base_curr || '''' ||
355: ' and conversion_type = ''' || fnd_profile.value('MSD_DEM_CONVERSION_TYPE') || '''' ;
356:
357: l_list := NULL;
358: l_list2 := NULL;
359: