[Home] [Help]
26: --| 21-NOV-2005 shu add code in po_uom_convert_p as it is use the |
27: --| the 3-character UOM_CODE,not 25-character |
28: --| 29-NOV-2005 shu added uom_to_code function . |
29: --| 29-NOV-2005 shu modified convert_amount function, using |
30: --| GL_CURRENCY_API.convert_amount_sql that with |
31: --| exception handle. |
32: --| 16-DEC-2005 shu modified debug_output to save information into|
33: --| FND_LOG_MESSAGE table using fnd_log.string |
34: --+===========================================================================+
555: -- : p_to_currency To currency
556: -- : p_conversion_date Conversion date
557: -- : p_conversion_type Conversion type
558: -- RETURN : return the sonversion rate
559: -- COMMENT : reference to the APPS.GL_CURRENCY_API,
560: -- Returns 'Y' if there is a conversion rate between the two currencies
561: -- for a given conversion date and conversion type;
562: -- 'N' otherwise.
563:
572: ,p_conversion_type IN VARCHAR2 DEFAULT NULL
573: ) RETURN VARCHAR2 IS
574: BEGIN
575:
576: RETURN GL_CURRENCY_API.rate_exists(x_from_currency => p_from_currency
577: ,x_to_currency => p_to_currency
578: ,x_conversion_date => p_conversion_date
579: ,x_conversion_type => p_conversion_type);
580:
586: -- : p_to_currency To currency
587: -- : p_conversion_date Conversion date
588: -- : p_conversion_type Conversion type
589: -- RETURN : return the sonversion rate
590: -- COMMENT : reference to the APPS.GL_CURRENCY_API, to get the currency conversion rate
591: -- PRE-COND :
592: -- EXCEPTIONS:
593: --========================================================================
594: FUNCTION get_rate
600: RETURN NUMBER
601: IS
602: BEGIN
603:
604: RETURN GL_CURRENCY_API.get_rate(x_from_currency => p_from_currency
605: ,x_to_currency => p_to_currency
606: ,x_conversion_date => p_conversion_date
607: ,x_conversion_type => p_conversion_type);
608:
614: -- : p_from_currency From currency
615: -- : p_conversion_date Conversion date
616: -- : p_conversion_type Conversion type
617: -- RETURN : return the sonversion rate
618: -- COMMENT : reference to the APPS.GL_CURRENCY_API,
619: -- Returns the rate between the from currency and the functional
620: -- currency of the set of books.
621: -- PRE-COND :
622: -- EXCEPTIONS:
630: RETURN NUMBER
631: IS
632: BEGIN
633:
634: RETURN GL_CURRENCY_API.get_rate(x_set_of_books_id => p_ledger_id
635: ,x_from_currency => p_from_currency
636: ,x_conversion_date => p_conversion_date
637: ,x_conversion_type => p_conversion_type);
638:
646: -- : p_conversion_type Conversion type
647: -- : p_amount Amount to be converted from the from currency
648: -- into the to currency
649: -- RETURN : return the sonversion rate
650: -- COMMENT : reference to the APPS.GL_CURRENCY_API,
651: -- Returns the amount converted from the from currency into the
652: -- to currency for a given conversion date and conversion type.
653: -- The amount returned is rounded to the precision and minimum
654: -- account unit of the to currency.
667: l_converted_amount NUMBER;
668:
669: BEGIN
670:
671: /*RETURN GL_CURRENCY_API.convert_amount(x_from_currency => p_from_currency
672: ,x_to_currency => p_to_currency
673: ,x_conversion_date => p_conversion_date
674: ,x_conversion_type => p_conversion_type
675: ,x_amount => p_amount);*/
672: ,x_to_currency => p_to_currency
673: ,x_conversion_date => p_conversion_date
674: ,x_conversion_type => p_conversion_type
675: ,x_amount => p_amount);*/
676: l_converted_amount := GL_CURRENCY_API.convert_amount_sql(x_from_currency => p_from_currency
677: ,x_to_currency => p_to_currency
678: ,x_conversion_date => p_conversion_date
679: ,x_conversion_type => p_conversion_type
680: ,x_amount => p_amount);
689: -- : p_conversion_type Conversion type
690: -- : p_amount Amount to be converted from the from currency
691: -- into the to currency
692: -- RETURN : return the sonversion rate
693: -- COMMENT : reference to the APPS.GL_CURRENCY_API,
694: -- Returns the amount converted from the from currency into the
695: -- functional currency of that set of books. The amount returned is
696: -- rounded to the precision and minimum account unit of the to currency.
697:
710: l_converted_amount NUMBER;
711:
712: BEGIN
713:
714: /*RETURN GL_CURRENCY_API.convert_amount(x_set_of_books_id => p_ledger_id
715: ,x_from_currency => p_from_currency
716: ,x_conversion_date => p_conversion_date
717: ,x_conversion_type => p_conversion_type
718: ,x_amount => p_amount);*/
715: ,x_from_currency => p_from_currency
716: ,x_conversion_date => p_conversion_date
717: ,x_conversion_type => p_conversion_type
718: ,x_amount => p_amount);*/
719: l_converted_amount := GL_CURRENCY_API.convert_amount_sql(x_set_of_books_id => p_ledger_id
720: ,x_from_currency => p_from_currency
721: ,x_conversion_date => p_conversion_date
722: ,x_conversion_type => p_conversion_type
723: ,x_amount => p_amount);