获取货币汇率API

来源:互联网 发布:老干部网络意思 编辑:程序博客网 时间:2024/05/17 13:06

--获取货币转换率
gl_currency_api.get_rate_sql(
                                x_from_currency    VARCHAR2,
                                x_to_currency    VARCHAR2,
                                x_conversion_date  DATE,
                                x_conversion_type    VARCHAR2 DEFAULT NULL)
--获取转换汇率后的金额  API
gl_currency_api.convert_amount(
                                x_from_currency        VARCHAR2,
                                x_to_currency        VARCHAR2,
                                x_conversion_date    DATE,
                                x_conversion_type    VARCHAR2 DEFAULT NULL,
                                x_amount        NUMBER  )