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.CE_CASH_FCST dependencies on FND_CURRENCIES

Line 399: FROM fnd_currencies

395: ---------------------------------------------------------------------*/
396: FUNCTION populate_base_xrate_table RETURN BOOLEAN IS
397: CURSOR from_curr(orig_curr VARCHAR2) IS
398: SELECT currency_code
399: FROM fnd_currencies
400: WHERE enabled_flag = 'Y'
401: AND currency_code <> CE_CASH_FCST.G_rp_forecast_currency
402: AND currency_code <> 'STAT'
403: AND CE_CASH_FCST.G_rp_exchange_date BETWEEN

Line 409: FROM fnd_currencies

405: NVL(end_date_active,CE_CASH_FCST.G_rp_exchange_date);
406:
407: CURSOR bad_curr IS
408: SELECT currency_code
409: FROM fnd_currencies
410: WHERE enabled_flag = 'Y'
411: AND currency_code <> CE_CASH_FCST.G_rp_forecast_currency
412: AND currency_code <> 'STAT'
413: AND ( CE_CASH_FCST.G_rp_exchange_date <

Line 430: curr FND_CURRENCIES.currency_code%TYPE;

426: AND org.currency_code <> CE_CASH_FCST.G_rp_forecast_currency
427: AND r.trx_type = 'OEO'
428: AND org.org_id = NVL(r.org_id, org.org_id);
429:
430: curr FND_CURRENCIES.currency_code%TYPE;
431: to_curr FND_CURRENCIES.currency_code%TYPE;
432: error_msg FND_NEW_MESSAGES.message_text%TYPE;
433: xrate NUMBER;
434: all_exist_flag BOOLEAN := TRUE;

Line 431: to_curr FND_CURRENCIES.currency_code%TYPE;

427: AND r.trx_type = 'OEO'
428: AND org.org_id = NVL(r.org_id, org.org_id);
429:
430: curr FND_CURRENCIES.currency_code%TYPE;
431: to_curr FND_CURRENCIES.currency_code%TYPE;
432: error_msg FND_NEW_MESSAGES.message_text%TYPE;
433: xrate NUMBER;
434: all_exist_flag BOOLEAN := TRUE;
435: BEGIN

Line 536: FROM fnd_currencies

532: ---------------------------------------------------------------------*/
533: FUNCTION populate_xrate_table RETURN BOOLEAN IS
534: CURSOR C IS
535: SELECT currency_code
536: FROM fnd_currencies
537: WHERE enabled_flag = 'Y'
538: AND currency_code <> CE_CASH_FCST.G_rp_forecast_currency
539: AND currency_code <> 'STAT'
540: AND CE_CASH_FCST.G_rp_exchange_date BETWEEN

Line 546: FROM fnd_currencies

542: and NVL(end_date_active,CE_CASH_FCST.G_rp_exchange_date);
543:
544: CURSOR bad_curr IS
545: SELECT currency_code
546: FROM fnd_currencies
547: WHERE enabled_flag = 'Y'
548: AND currency_code <> CE_CASH_FCST.G_rp_forecast_currency
549: AND currency_code <> 'STAT'
550: AND ( CE_CASH_FCST.G_rp_exchange_date <

Line 555: curr FND_CURRENCIES.currency_code%TYPE;

551: NVL(start_date_active,CE_CASH_FCST.G_rp_exchange_date) OR
552: CE_CASH_FCST.G_rp_exchange_date >
553: NVL(end_date_active,CE_CASH_FCST.G_rp_exchange_date));
554:
555: curr FND_CURRENCIES.currency_code%TYPE;
556: from_curr FND_CURRENCIES.currency_code%TYPE;
557: to_curr FND_CURRENCIES.currency_code%TYPE;
558: euro_curr FND_CURRENCIES.currency_code%TYPE;
559: error_msg FND_NEW_MESSAGES.message_text%TYPE;

Line 556: from_curr FND_CURRENCIES.currency_code%TYPE;

552: CE_CASH_FCST.G_rp_exchange_date >
553: NVL(end_date_active,CE_CASH_FCST.G_rp_exchange_date));
554:
555: curr FND_CURRENCIES.currency_code%TYPE;
556: from_curr FND_CURRENCIES.currency_code%TYPE;
557: to_curr FND_CURRENCIES.currency_code%TYPE;
558: euro_curr FND_CURRENCIES.currency_code%TYPE;
559: error_msg FND_NEW_MESSAGES.message_text%TYPE;
560: xrate NUMBER;

Line 557: to_curr FND_CURRENCIES.currency_code%TYPE;

553: NVL(end_date_active,CE_CASH_FCST.G_rp_exchange_date));
554:
555: curr FND_CURRENCIES.currency_code%TYPE;
556: from_curr FND_CURRENCIES.currency_code%TYPE;
557: to_curr FND_CURRENCIES.currency_code%TYPE;
558: euro_curr FND_CURRENCIES.currency_code%TYPE;
559: error_msg FND_NEW_MESSAGES.message_text%TYPE;
560: xrate NUMBER;
561: skip_err_log BOOLEAN;

Line 558: euro_curr FND_CURRENCIES.currency_code%TYPE;

554:
555: curr FND_CURRENCIES.currency_code%TYPE;
556: from_curr FND_CURRENCIES.currency_code%TYPE;
557: to_curr FND_CURRENCIES.currency_code%TYPE;
558: euro_curr FND_CURRENCIES.currency_code%TYPE;
559: error_msg FND_NEW_MESSAGES.message_text%TYPE;
560: xrate NUMBER;
561: skip_err_log BOOLEAN;
562: all_exist_flag BOOLEAN := TRUE;

Line 584: FROM FND_CURRENCIES

580: G_rp_src_curr_type <> 'E')THEN
581:
582: SELECT DECODE(COUNT(*),0,'N','Y')
583: INTO fcast_curr_is_emu
584: FROM FND_CURRENCIES
585: WHERE currency_code = CE_CASH_FCST.G_rp_forecast_currency AND
586: derive_type = 'EMU';
587:
588: SELECT DECODE(COUNT(*),0,'N','Y')

Line 590: FROM FND_CURRENCIES

586: derive_type = 'EMU';
587:
588: SELECT DECODE(COUNT(*),0,'N','Y')
589: INTO src_curr_is_emu
590: FROM FND_CURRENCIES
591: WHERE currency_code = CE_CASH_FCST.G_rp_src_currency AND
592: derive_type = 'EMU';
593:
594: IF ( (fcast_curr_is_emu = 'Y' OR src_curr_is_emu = 'Y') OR

Line 599: FROM fnd_currencies

595: G_rp_src_curr_type = 'A' ) THEN
596: BEGIN
597: SELECT currency_code
598: INTO euro_curr
599: FROM fnd_currencies
600: WHERE derive_type = 'EURO';
601: EXCEPTION
602: WHEN NO_DATA_FOUND THEN
603: FND_MESSAGE.set_name ('CE','CE_FC_EURO_NOT_DEFINED');

Line 617: FROM FND_CURRENCIES

613: FETCH C INTO from_curr;
614:
615: SELECT DECODE(COUNT(*),0,'N','Y')
616: INTO from_curr_is_emu
617: FROM FND_CURRENCIES
618: WHERE currency_code = from_curr AND
619: derive_type IN ('EMU','EURO');
620:
621: EXIT WHEN (C%NOTFOUND OR C%NOTFOUND IS NULL);

Line 654: FROM FND_CURRENCIES

650: -1, 'OTHER',
651: 'EMU'),
652: 'OTHER' )
653: INTO l_currency_type
654: FROM FND_CURRENCIES
655: WHERE currency_code = to_curr;
656: IF (l_currency_type = 'EMU') THEN
657: to_curr := euro_curr;
658: END IF;

Line 668: FROM FND_CURRENCIES

664: -1, 'OTHER',
665: 'EMU'),
666: 'OTHER' )
667: INTO l_currency_type
668: FROM FND_CURRENCIES
669: WHERE currency_code = from_curr;
670: IF (l_currency_type = 'EMU') THEN
671: from_curr := euro_curr;
672: END IF;