APPS.CE_CASH_FCST dependencies on CE_CURRENCY_RATES_TEMP

Line 387: | CE_CURRENCY_RATES_TEMP for base currency |

383: | populate_base_xrate_table |
384: | |
385: | DESCRIPTION |
386: | populate the exchange rate information from GL table to |
387: | CE_CURRENCY_RATES_TEMP for base currency |
388: | |
389: | CALLED BY |
390: | |
391: | REQUIRES |

Line 457: insert into CE_CURRENCY_RATES_TEMP

453: BEGIN
454: xrate := GL_CURRENCY_API.get_rate(curr, to_curr,
455: CE_CASH_FCST.G_rp_exchange_date,
456: CE_CASH_FCST.G_rp_exchange_type);
457: insert into CE_CURRENCY_RATES_TEMP
458: (forecast_request_id, currency_code, exchange_rate, to_currency)
459: values (CE_CASH_FCST.G_forecast_id, curr, xrate, to_curr);
460: cep_standard.debug(' Exchange info - '||curr||'->'||to_curr||' has rate '||to_char(xrate));
461: EXCEPTION

Line 482: insert into CE_CURRENCY_RATES_TEMP (forecast_request_id, currency_code,

478:
479: --
480: -- Insert constant rate (1) for base_currency to base_currency
481: --
482: insert into CE_CURRENCY_RATES_TEMP (forecast_request_id, currency_code,
483: exchange_rate, to_currency)
484: values (CE_CASH_FCST.G_forecast_id, to_curr, 1, to_curr);
485:
486: OPEN bad_curr;

Line 524: | CE_CURRENCY_RATES_TEMP |

520: | populate_xrate_table |
521: | |
522: | DESCRIPTION |
523: | populate the exchange rate information from GL table to |
524: | CE_CURRENCY_RATES_TEMP |
525: | |
526: | CALLED BY |
527: | |
528: | REQUIRES |

Line 574: insert into CE_CURRENCY_RATES_TEMP

570:
571: --
572: -- Insert constant rate (1) for forecast_currency to forecast_currency
573: --
574: insert into CE_CURRENCY_RATES_TEMP
575: (forecast_request_id, currency_code, exchange_rate, to_currency)
576: values (CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_currency, 1,
577: CE_CASH_FCST.G_rp_forecast_currency);
578:

Line 626: insert into CE_CURRENCY_RATES_TEMP (forecast_request_id,

622: BEGIN
623: xrate := GL_CURRENCY_API.get_rate(from_curr, G_rp_forecast_currency,
624: CE_CASH_FCST.G_rp_exchange_date,
625: CE_CASH_FCST.G_rp_exchange_type);
626: insert into CE_CURRENCY_RATES_TEMP (forecast_request_id,
627: currency_code, exchange_rate, to_currency)
628: values (CE_CASH_FCST.G_forecast_id, from_curr, xrate,
629: G_rp_forecast_currency);
630: cep_standard.debug(' Exchange info - '||from_curr||' has rate '||to_char(xrate));

Line 733: | clear the exchange rate information in CE_CURRENCY_RATES_TEMP |

729: | PRIVATE PROCEDURE |
730: | clear_xrate_table |
731: | |
732: | DESCRIPTION |
733: | clear the exchange rate information in CE_CURRENCY_RATES_TEMP |
734: | |
735: | CALLED BY |
736: | |
737: | REQUIRES |

Line 745: delete from CE_CURRENCY_RATES_TEMP

741: ---------------------------------------------------------------------*/
742: PROCEDURE clear_xrate_table IS
743: BEGIN
744: cep_standard.debug('Delete all xrate information');
745: delete from CE_CURRENCY_RATES_TEMP
746: where forecast_request_id = CE_CASH_FCST.G_forecast_id;
747: EXCEPTION
748: WHEN OTHERS THEN
749: cep_standard.debug('EXCEPTION - OTHERS: clear_xrate_table');