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.OPI_DBI_INV_CCA_PKG dependencies on FII_CURRENCY

Line 1715: OPI_DBI_INV_CCA_STG using the fii_currency.get_global_rate_primary

1711: The conversion rate work table was truncated during
1712: the initialization phase.
1713:
1714: Get the currency conversion rates based on the data in
1715: OPI_DBI_INV_CCA_STG using the fii_currency.get_global_rate_primary
1716: API for the primary global currency and
1717: fii_currency.get_global_rate_secondary for the secondary global currency.
1718: The primary currency API:
1719: 1. finds the conversion rate if one exists.

Line 1717: fii_currency.get_global_rate_secondary for the secondary global currency.

1713:
1714: Get the currency conversion rates based on the data in
1715: OPI_DBI_INV_CCA_STG using the fii_currency.get_global_rate_primary
1716: API for the primary global currency and
1717: fii_currency.get_global_rate_secondary for the secondary global currency.
1718: The primary currency API:
1719: 1. finds the conversion rate if one exists.
1720: 2. 'USD' always has a conversion rate of 1 (since it is global currency).
1721: 3. returns -1 if there is no conversion rate on that date.

Line 1773: -- By the logic of the fii_currency.get_global_rate_primary

1769:
1770: invalid_rates_exist_rec invalid_rates_exist_csr%ROWTYPE;
1771:
1772: -- Set up a cursor to get all the invalid rates.
1773: -- By the logic of the fii_currency.get_global_rate_primary
1774: -- and fii_currency.get_global_rate_secondary APIs, the returned value
1775: -- is -ve if no rate exists:
1776: -- -1 for dates with no rate.
1777: -- -2 for unrecognized conversion rates.

Line 1774: -- and fii_currency.get_global_rate_secondary APIs, the returned value

1770: invalid_rates_exist_rec invalid_rates_exist_csr%ROWTYPE;
1771:
1772: -- Set up a cursor to get all the invalid rates.
1773: -- By the logic of the fii_currency.get_global_rate_primary
1774: -- and fii_currency.get_global_rate_secondary APIs, the returned value
1775: -- is -ve if no rate exists:
1776: -- -1 for dates with no rate.
1777: -- -2 for unrecognized conversion rates.
1778: -- -3 for missing EUR to USD rates on 01-JAN-1999 when the

Line 1873: -- Use the fii_currency.get_global_rate_primary function to get the

1869: -- Get all the distinct organization and date pairs and the
1870: -- base currency codes for the orgs into the conversion rates
1871: -- work table.
1872:
1873: -- Use the fii_currency.get_global_rate_primary function to get the
1874: -- conversion rate given a currency code and a date.
1875: -- The function returns:
1876: -- 1 for currency code of 'USD' which is the global currency
1877: -- -1 for dates for which there is no currency conversion rate

Line 1883: -- Use the fii_currency.get_global_rate_secondary to get the secondary

1879: -- -3 for missing EUR to USD rates on 01-JAN-1999 when the
1880: -- transaction_date is prior to 01-JAN-1999 (when the EUR
1881: -- officially went into circulation).
1882:
1883: -- Use the fii_currency.get_global_rate_secondary to get the secondary
1884: -- global rate. If the secondary currency has not been set up,
1885: -- make the rate null. If the secondary currency/rate types are the
1886: -- same as the primary, don't call the API but rather use an update
1887: -- statement followed by the insert.

Line 1905: fii_currency.get_global_rate_primary (

1901: curr_codes.currency_code,
1902: to_conv.approval_date,
1903: decode (curr_codes.currency_code,
1904: s_global_curr_code, 1,
1905: fii_currency.get_global_rate_primary (
1906: curr_codes.currency_code,
1907: to_conv.approval_date) ),
1908: decode (s_secondary_curr_code,
1909: NULL, NULL,

Line 1913: fii_currency.get_global_rate_secondary (

1909: NULL, NULL,
1910: curr_codes.currency_code, 1,
1911: decode (l_pri_sec_curr_same,
1912: 1, C_PRI_SEC_CURR_SAME_MARKER,
1913: fii_currency.get_global_rate_secondary (
1914: curr_codes.currency_code,
1915: to_conv.approval_date)))
1916: FROM
1917: (SELECT /*+ parallel (opi_dbi_inv_cca_stg) */

Line 3470: OPI_DBI_INV_CCA_STG using the fii_currency.get_global_rate_primary

3466: The conversion rate work table was truncated during
3467: the initialization phase.
3468:
3469: Get the currency conversion rates based on the data in
3470: OPI_DBI_INV_CCA_STG using the fii_currency.get_global_rate_primary
3471: API for the primary global currency and
3472: fii_currency.get_global_rate_secondary for the secondary global currency.
3473: The primary currency API:
3474: 1. finds the conversion rate if one exists.

Line 3472: fii_currency.get_global_rate_secondary for the secondary global currency.

3468:
3469: Get the currency conversion rates based on the data in
3470: OPI_DBI_INV_CCA_STG using the fii_currency.get_global_rate_primary
3471: API for the primary global currency and
3472: fii_currency.get_global_rate_secondary for the secondary global currency.
3473: The primary currency API:
3474: 1. finds the conversion rate if one exists.
3475: 2. 'USD' always has a conversion rate of 1 (since it is global currency).
3476: 3. returns -1 if there is no conversion rate on that date.

Line 3527: -- By the logic of the fii_currency.get_global_rate_primary

3523:
3524: invalid_rates_exist_rec invalid_rates_exist_csr%ROWTYPE;
3525:
3526: -- Set up a cursor to get all the invalid rates.
3527: -- By the logic of the fii_currency.get_global_rate_primary
3528: -- and fii_currency.get_global_rate_secondary APIs, the returned value
3529: -- is -ve if no rate exists:
3530: -- -1 for dates with no rate.
3531: -- -2 for unrecognized conversion rates.

Line 3528: -- and fii_currency.get_global_rate_secondary APIs, the returned value

3524: invalid_rates_exist_rec invalid_rates_exist_csr%ROWTYPE;
3525:
3526: -- Set up a cursor to get all the invalid rates.
3527: -- By the logic of the fii_currency.get_global_rate_primary
3528: -- and fii_currency.get_global_rate_secondary APIs, the returned value
3529: -- is -ve if no rate exists:
3530: -- -1 for dates with no rate.
3531: -- -2 for unrecognized conversion rates.
3532: -- -3 for missing EUR to USD rates on 01-JAN-1999 when the

Line 3623: -- Use the fii_currency.get_global_rate_primary function to get the

3619: -- Get all the distinct organization and date pairs and the
3620: -- base currency codes for the orgs into the conversion rates
3621: -- work table.
3622:
3623: -- Use the fii_currency.get_global_rate_primary function to get the
3624: -- conversion rate given a currency code and a date.
3625: -- The function returns:
3626: -- 1 for currency code of 'USD' which is the global currency
3627: -- -1 for dates for which there is no currency conversion rate

Line 3633: -- Use the fii_currency.get_global_rate_secondary to get the secondary

3629: -- -3 for missing EUR to USD rates on 01-JAN-1999 when the
3630: -- transaction_date is prior to 01-JAN-1999 (when the EUR
3631: -- officially went into circulation).
3632:
3633: -- Use the fii_currency.get_global_rate_secondary to get the secondary
3634: -- global rate. If the secondary currency has not been set up,
3635: -- make the rate null. If the secondary currency/rate types are the
3636: -- same as the primary, don't call the API but rather use an update
3637: -- statement followed by the insert.

Line 3655: fii_currency.get_global_rate_primary (

3651: curr_codes.currency_code,
3652: to_conv.approval_date,
3653: decode (curr_codes.currency_code,
3654: s_global_curr_code, 1,
3655: fii_currency.get_global_rate_primary (
3656: curr_codes.currency_code,
3657: to_conv.approval_date) ),
3658: decode (s_secondary_curr_code,
3659: NULL, NULL,

Line 3663: fii_currency.get_global_rate_secondary (

3659: NULL, NULL,
3660: curr_codes.currency_code, 1,
3661: decode (l_pri_sec_curr_same,
3662: 1, C_PRI_SEC_CURR_SAME_MARKER,
3663: fii_currency.get_global_rate_secondary (
3664: curr_codes.currency_code,
3665: to_conv.approval_date)))
3666: FROM
3667: (SELECT