APPS.OPI_DBI_MTL_VARIANCE_PKG dependencies on FII_CURRENCY

Line 70: fii_currency.get_global_rate_primary API for the primary global

66: the initialization phase.
67:
68: Get the currency conversion rates based on the organizations in the
69: WIP_ENTITIES and IC_WHSE_MST tabls using the
70: fii_currency.get_global_rate_primary API for the primary global
71: currency and fii_currency.get_global_rate_secondary for the
72: secondary global currency.
73: The primary currency API:
74: 1. finds the conversion rate if one exists.

Line 71: currency and fii_currency.get_global_rate_secondary for the

67:
68: Get the currency conversion rates based on the organizations in the
69: WIP_ENTITIES and IC_WHSE_MST tabls using the
70: fii_currency.get_global_rate_primary API for the primary global
71: currency and fii_currency.get_global_rate_secondary for the
72: secondary global currency.
73: The primary currency API:
74: 1. finds the conversion rate if one exists.
75: 2. returns -1 if there is no conversion rate on that date.

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

117: invalid_rates_exist_rec invalid_rates_exist_csr%ROWTYPE;
118:
119:
120: -- Set up a cursor to get all the invalid rates.
121: -- By the logic of the fii_currency.get_global_rate_primary
122: -- and fii_currency.get_global_rate_secondary APIs, the returned value
123: -- is -ve if no rate exists:
124: -- -1 for dates with no rate.
125: -- -2 for unrecognized conversion rates.

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

118:
119:
120: -- Set up a cursor to get all the invalid rates.
121: -- By the logic of the fii_currency.get_global_rate_primary
122: -- and fii_currency.get_global_rate_secondary APIs, the returned value
123: -- is -ve if no rate exists:
124: -- -1 for dates with no rate.
125: -- -2 for unrecognized conversion rates.
126: -- -3 for missing EUR to USD rates on 01-JAN-1999 when the

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

261: l_pri_sec_curr_same := 1;
262: END IF;
263:
264: l_stmt_num := 20;
265: -- Use the fii_currency.get_global_rate_primary function to get the
266: -- conversion rate given a currency code and a date.
267: -- The function returns:
268: -- 1 for currency code of 'USD' which is the global currency
269: -- -1 for dates for which there is no currency conversion rate

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

271: -- -3 for missing EUR to USD rates on 01-JAN-1999 when the
272: -- transaction_date is prior to 01-JAN-1999 (when the EUR
273: -- officially went into circulation).
274:
275: -- Use the fii_currency.get_global_rate_secondary to get the secondary
276: -- global rate. If the secondary currency has not been set up,
277: -- make the rate null. If the secondary currency/rate types are the
278: -- same as the primary, don't call the API but rather use an update
279: -- statement followed by the insert.

Line 305: fii_currency.get_global_rate_primary (

301: curr_codes.currency_code,
302: to_conv.transaction_date,
303: decode (curr_codes.currency_code,
304: g_global_currency_code, 1,
305: fii_currency.get_global_rate_primary (
306: curr_codes.currency_code,
307: to_conv.transaction_date) ),
308: decode (g_secondary_currency_code,
309: NULL, NULL,

Line 313: fii_currency.get_global_rate_secondary (

309: NULL, NULL,
310: curr_codes.currency_code, 1,
311: decode (l_pri_sec_curr_same,
312: 1, C_PRI_SEC_CURR_SAME_MARKER,
313: fii_currency.get_global_rate_secondary (
314: curr_codes.currency_code,
315: to_conv.transaction_date))),
316: g_sysdate,
317: g_sysdate,