APPS.CE_CASH_FCST dependencies on CE_CURRENCY_RATES_TEMP

Line 373: | CE_CURRENCY_RATES_TEMP for base currency |

369: | populate_base_xrate_table |
370: | |
371: | DESCRIPTION |
372: | populate the exchange rate information from GL table to |
373: | CE_CURRENCY_RATES_TEMP for base currency |
374: | |
375: | CALLED BY |
376: | |
377: | REQUIRES |

Line 443: insert into CE_CURRENCY_RATES_TEMP

439: BEGIN
440: xrate := GL_CURRENCY_API.get_rate(curr, to_curr,
441: CE_CASH_FCST.G_rp_exchange_date,
442: CE_CASH_FCST.G_rp_exchange_type);
443: insert into CE_CURRENCY_RATES_TEMP
444: (forecast_request_id, currency_code, exchange_rate, to_currency)
445: values (CE_CASH_FCST.G_forecast_id, curr, xrate, to_curr);
446: cep_standard.debug(' Exchange info - '||curr||'->'||to_curr||' has rate '||to_char(xrate));
447: EXCEPTION

Line 468: insert into CE_CURRENCY_RATES_TEMP (forecast_request_id, currency_code,

464:
465: --
466: -- Insert constant rate (1) for base_currency to base_currency
467: --
468: insert into CE_CURRENCY_RATES_TEMP (forecast_request_id, currency_code,
469: exchange_rate, to_currency)
470: values (CE_CASH_FCST.G_forecast_id, to_curr, 1, to_curr);
471:
472: OPEN bad_curr;

Line 510: | CE_CURRENCY_RATES_TEMP |

506: | populate_xrate_table |
507: | |
508: | DESCRIPTION |
509: | populate the exchange rate information from GL table to |
510: | CE_CURRENCY_RATES_TEMP |
511: | |
512: | CALLED BY |
513: | |
514: | REQUIRES |

Line 560: insert into CE_CURRENCY_RATES_TEMP

556:
557: --
558: -- Insert constant rate (1) for forecast_currency to forecast_currency
559: --
560: insert into CE_CURRENCY_RATES_TEMP
561: (forecast_request_id, currency_code, exchange_rate, to_currency)
562: values (CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_currency, 1,
563: CE_CASH_FCST.G_rp_forecast_currency);
564:

Line 612: insert into CE_CURRENCY_RATES_TEMP (forecast_request_id,

608: BEGIN
609: xrate := GL_CURRENCY_API.get_rate(from_curr, G_rp_forecast_currency,
610: CE_CASH_FCST.G_rp_exchange_date,
611: CE_CASH_FCST.G_rp_exchange_type);
612: insert into CE_CURRENCY_RATES_TEMP (forecast_request_id,
613: currency_code, exchange_rate, to_currency)
614: values (CE_CASH_FCST.G_forecast_id, from_curr, xrate,
615: G_rp_forecast_currency);
616: cep_standard.debug(' Exchange info - '||from_curr||' has rate '||to_char(xrate));

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

715: | PRIVATE PROCEDURE |
716: | clear_xrate_table |
717: | |
718: | DESCRIPTION |
719: | clear the exchange rate information in CE_CURRENCY_RATES_TEMP |
720: | |
721: | CALLED BY |
722: | |
723: | REQUIRES |

Line 731: delete from CE_CURRENCY_RATES_TEMP

727: ---------------------------------------------------------------------*/
728: PROCEDURE clear_xrate_table IS
729: BEGIN
730: cep_standard.debug('Delete all xrate information');
731: delete from CE_CURRENCY_RATES_TEMP
732: where forecast_request_id = CE_CASH_FCST.G_forecast_id;
733: EXCEPTION
734: WHEN OTHERS THEN
735: cep_standard.debug('EXCEPTION - OTHERS: clear_xrate_table');