[Home] [Help]
200: END IF;
201:
202:
203:
204: rate := GL_CURRENCY_API.get_closest_rate_sql (
205: p_from_currency_code,
206: g_prim_currency_code,
207: l_exchange_date,
208: g_prim_rate_type,
261:
262: IF (g_sec_currency_code IS NULL) THEN
263: rate := 1;
264:
265: ELSE rate := GL_CURRENCY_API.get_closest_rate_sql (
266: p_from_currency_code,
267: g_sec_currency_code,
268: l_exchange_date,
269: g_sec_rate_type,
318: ELSIF (p_exchange_date IS NULL OR
319: p_from_currency_code IS NULL) THEN
320: l_converted_amount := -1;
321: ELSE
322: l_converted_amount := GL_CURRENCY_API.convert_closest_amount_sql (
323: p_from_currency_code,
324: l_global_currency_code,
325: p_exchange_date,
326: l_global_rate_type,
377: ELSIF (p_exchange_date IS NULL OR
378: p_from_currency_code IS NULL) THEN
379: l_converted_amount := -1;
380: ELSE
381: l_converted_amount := GL_CURRENCY_API.convert_closest_amount_sql (
382: p_from_currency_code,
383: l_global_currency_code,
384: p_exchange_date,
385: l_global_rate_type,
472: -- To Currency
473: -- Exchange Date
474: -- Exchange Rate Type
475: -- Desc: Given the from currency, to currency, exchange date and rate type,
476: -- this API will call the GL_CURRENCY_API.get_closest_rate_sql API to
477: -- get the currency conversion rate.
478: -- Output: Conversion rate, data type: NUMBER
479: -- Returns -1 if no rate exists
480: -- Returns -2 if the From Currency is an invalid currency
511: ELSIF (p_to_currency_code = 'EUR' AND l_exchange_date < to_date('01/01/1999','DD/MM/RRRR') )
512: THEN l_exchange_date := to_date('01/01/1999','DD/MM/RRRR');
513: END IF;
514:
515: rate := GL_CURRENCY_API.get_closest_rate_sql (
516: p_from_currency_code,
517: p_to_currency_code,
518: l_exchange_date,
519: p_exchange_rate_type,
604: -- exchange date is before Jan 1 ,1999
605: -- Return -4 for any other exception.
606: -- How the exceptions are handled :
607: -- Other exceptions are handled by get_fc_to_pgc_rate
608: -- No Rate and Invalid Currency are handled in gl_currency_api.get_closest_rate_sql
609: -- When one of the currency is EUR and exchange date is before Jan 1,1999
610: -- -3 is returned from get_rate.
611: ---------------------------------------------------------------------------
612: FUNCTION get_fc_to_pgc_rate(p_tc_code IN VARCHAR2,
652: -- exchange date is before Jan 1 ,1999
653: -- Return -4 for any other exception.
654: -- How the exceptions are handled :
655: -- Other exceptions are handled by get_fc_to_sgc_rate
656: -- No Rate and Invalid Currency are handled in gl_currency_api.get_closest_rate_sql
657: -- When one of the currency is EUR and exchange date is before Jan 1,1999
658: -- -3 is returned from get_rate.
659: ---------------------------------------------------------------------------
660: FUNCTION get_fc_to_sgc_rate(p_tc_code IN VARCHAR2,
720: -- Returns -8 when treasury rate type is null and p_rate is null and exchange
721: -- rate type is null.
722: -- How the exceptions are handled :
723: -- Other exceptions are handled by get_tc_to_pgc_rate
724: -- Invalid Currency (-2) is handled in gl_currency_api.get_closest_rate_sql
725: -- When one of the currency is EUR and exchange date is before Jan 1,1999
726: -- and no rate exists on Jan 1,1999 then -3 is returned from FII_CURRENCY.get_rate
727: -- -5,-6,-7 ,-8 are handled in get_tc_pgc_rate
728: ----------------------------------------------------------------------------------------------
860: -- Returns -8 when treasury rate type is null and p_rate is null and exchange
861: -- rate type is null.
862: -- How the exceptions are handled :
863: -- Other exceptions are handled by get_tc_to_pgc_rate
864: -- Invalid Currency (-2) is handled in gl_currency_api.get_closest_rate_sql
865: -- When one of the currency is EUR and exchange date is before Jan 1,1999
866: -- and no rate exists on Jan 1,1999 then -3 is returned from FII_CURRENCY.get_rate
867: -- -5,-6,-7 ,-8 are handled in get_tc_sgc_rate
868: ----------------------------------------------------------------------------------------------