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.FII_CURR_CONV_MAINTAIN_PKG dependencies on FII_CURR_CONV_RATES

Line 142: FROM FII_CURR_CONV_RATES

138: , CONVERSION_TYPE
139: , CONVERSION_RATE
140: , CURRENCY_TYPE
141: , least(PERIOD_START_DATE, g_current_start_date) CONVERSION_DATE
142: FROM FII_CURR_CONV_RATES
143: WHERE 1=0;
144:
145: TYPE CursorRef IS ref cursor RETURN Dummy_Missing_Rates_Cur%ROWTYPE;
146: Missing_Rates_Cur CursorRef;

Line 178: FROM FII_CURR_CONV_RATES_GT

174: , CONVERSION_TYPE
175: , CONVERSION_RATE
176: , CURRENCY_TYPE
177: , least(PERIOD_START_DATE, g_current_start_date) CONVERSION_DATE
178: FROM FII_CURR_CONV_RATES_GT
179: MINUS
180: SELECT
181: PERIOD_SET_NAME
182: , PERIOD_ID

Line 191: FROM FII_CURR_CONV_RATES

187: , CONVERSION_TYPE
188: , CONVERSION_RATE
189: , CURRENCY_TYPE
190: , least(PERIOD_START_DATE, g_current_start_date) CONVERSION_DATE
191: FROM FII_CURR_CONV_RATES
192: WHERE CONVERSION_RATE < 0;
193:
194: elsif (p_try_num = 2) then
195:

Line 208: FROM FII_CURR_CONV_RATES

204: , CONVERSION_TYPE
205: , CONVERSION_RATE
206: , CURRENCY_TYPE
207: , least(PERIOD_START_DATE, g_current_start_date) CONVERSION_DATE
208: FROM FII_CURR_CONV_RATES
209: WHERE CONVERSION_RATE < 0;
210:
211: else
212:

Line 293: g_phase := 'Truncate table FII_CURR_CONV_RATES';

289: FII_MESSAGE.Func_Ent(func_name =>
290: 'FII_CURR_CONV_MAINTAIN_PKG.Init_Load');
291: END IF;
292:
293: g_phase := 'Truncate table FII_CURR_CONV_RATES';
294:
295: FII_UTIL.truncate_table ('FII_CURR_CONV_RATES', g_schema_name, g_retcode);
296:
297: g_phase := 'Insert into FII_CURR_CONV_RATES';

Line 295: FII_UTIL.truncate_table ('FII_CURR_CONV_RATES', g_schema_name, g_retcode);

291: END IF;
292:
293: g_phase := 'Truncate table FII_CURR_CONV_RATES';
294:
295: FII_UTIL.truncate_table ('FII_CURR_CONV_RATES', g_schema_name, g_retcode);
296:
297: g_phase := 'Insert into FII_CURR_CONV_RATES';
298:
299: insert into FII_CURR_CONV_RATES (

Line 297: g_phase := 'Insert into FII_CURR_CONV_RATES';

293: g_phase := 'Truncate table FII_CURR_CONV_RATES';
294:
295: FII_UTIL.truncate_table ('FII_CURR_CONV_RATES', g_schema_name, g_retcode);
296:
297: g_phase := 'Insert into FII_CURR_CONV_RATES';
298:
299: insert into FII_CURR_CONV_RATES (
300: PERIOD_SET_NAME
301: , PERIOD_ID

Line 299: insert into FII_CURR_CONV_RATES (

295: FII_UTIL.truncate_table ('FII_CURR_CONV_RATES', g_schema_name, g_retcode);
296:
297: g_phase := 'Insert into FII_CURR_CONV_RATES';
298:
299: insert into FII_CURR_CONV_RATES (
300: PERIOD_SET_NAME
301: , PERIOD_ID
302: , PERIOD_START_DATE
303: , PERIOD_END_DATE

Line 351: ' rows into FII_CURR_CONV_RATES');

347: where prd.end_date >= g_global_start_date;
348:
349: IF (FIIDIM_Debug) THEN
350: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT ||
351: ' rows into FII_CURR_CONV_RATES');
352: END IF;
353:
354: g_phase := 'Copy missing rates to FII_CURR_CONV_RATES_GT';
355:

Line 354: g_phase := 'Copy missing rates to FII_CURR_CONV_RATES_GT';

350: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT ||
351: ' rows into FII_CURR_CONV_RATES');
352: END IF;
353:
354: g_phase := 'Copy missing rates to FII_CURR_CONV_RATES_GT';
355:
356: insert into FII_CURR_CONV_RATES_GT (
357: PERIOD_SET_NAME
358: , PERIOD_ID

Line 356: insert into FII_CURR_CONV_RATES_GT (

352: END IF;
353:
354: g_phase := 'Copy missing rates to FII_CURR_CONV_RATES_GT';
355:
356: insert into FII_CURR_CONV_RATES_GT (
357: PERIOD_SET_NAME
358: , PERIOD_ID
359: , PERIOD_START_DATE
360: , PERIOD_END_DATE

Line 377: FROM FII_CURR_CONV_RATES

373: , TO_CURRENCY
374: , CONVERSION_TYPE
375: , CONVERSION_RATE
376: , CURRENCY_TYPE
377: FROM FII_CURR_CONV_RATES
378: WHERE CONVERSION_RATE < 0;
379:
380: IF (FIIDIM_Debug) THEN
381: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT ||

Line 382: ' rows into FII_CURR_CONV_RATES_GT');

378: WHERE CONVERSION_RATE < 0;
379:
380: IF (FIIDIM_Debug) THEN
381: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT ||
382: ' rows into FII_CURR_CONV_RATES_GT');
383: END IF;
384:
385: g_phase := 'Update FII_CURR_CONV_RATES';
386:

Line 385: g_phase := 'Update FII_CURR_CONV_RATES';

381: FII_UTIL.Write_Log('Inserted ' || SQL%ROWCOUNT ||
382: ' rows into FII_CURR_CONV_RATES_GT');
383: END IF;
384:
385: g_phase := 'Update FII_CURR_CONV_RATES';
386:
387: update FII_CURR_CONV_RATES
388: set CONVERSION_RATE =
389: GL_CURRENCY_API.get_closest_rate_sql(

Line 387: update FII_CURR_CONV_RATES

383: END IF;
384:
385: g_phase := 'Update FII_CURR_CONV_RATES';
386:
387: update FII_CURR_CONV_RATES
388: set CONVERSION_RATE =
389: GL_CURRENCY_API.get_closest_rate_sql(
390: nvl(FROM_CURRENCY, '')
391: , TO_CURRENCY

Line 401: ' rows in FII_CURR_CONV_RATES');

397: and least(PERIOD_START_DATE, g_current_start_date) > g_global_start_date;
398:
399: IF (FIIDIM_Debug) THEN
400: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT ||
401: ' rows in FII_CURR_CONV_RATES');
402: END IF;
403:
404: g_phase := 'Detect missing rates in FII_CURR_CONV_RATES';
405:

Line 404: g_phase := 'Detect missing rates in FII_CURR_CONV_RATES';

400: FII_UTIL.Write_Log('Updated ' || SQL%ROWCOUNT ||
401: ' rows in FII_CURR_CONV_RATES');
402: END IF;
403:
404: g_phase := 'Detect missing rates in FII_CURR_CONV_RATES';
405:
406: Detect_Missing_Rates(1);
407: Detect_Missing_Rates(2);
408:

Line 409: g_phase := 'Gather_table_stats for FII_CURR_CONV_RATES';

405:
406: Detect_Missing_Rates(1);
407: Detect_Missing_Rates(2);
408:
409: g_phase := 'Gather_table_stats for FII_CURR_CONV_RATES';
410:
411: FND_STATS.gather_table_stats
412: (ownname => g_schema_name,
413: tabname => 'FII_CURR_CONV_RATES');

Line 413: tabname => 'FII_CURR_CONV_RATES');

409: g_phase := 'Gather_table_stats for FII_CURR_CONV_RATES';
410:
411: FND_STATS.gather_table_stats
412: (ownname => g_schema_name,
413: tabname => 'FII_CURR_CONV_RATES');
414:
415: g_phase := 'Commit the change';
416:
417: FND_CONCURRENT.Af_Commit;