APPS.OPI_DBI_RES_PKG dependencies on FII_CURRENCY

Line 236: OPI_DBI_RES_ACTUAL_STG using the fii_currency.get_global_rate_primary

232: The conversion rate work table was truncated during
233: the initialization phase.
234:
235: Get the currency conversion rates based on the data in
236: OPI_DBI_RES_ACTUAL_STG using the fii_currency.get_global_rate_primary
237: API for the primary global currency and
238: fii_currency.get_global_rate_secondary for the secondary global currency.
239: The primary currency API:
240: 1. finds the conversion rate if one exists.

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

234:
235: Get the currency conversion rates based on the data in
236: OPI_DBI_RES_ACTUAL_STG using the fii_currency.get_global_rate_primary
237: API for the primary global currency and
238: fii_currency.get_global_rate_secondary for the secondary global currency.
239: The primary currency API:
240: 1. finds the conversion rate if one exists.
241: 2. returns -1 if there is no conversion rate on that date.
242: 3. returns -2 if the currency code is not found.

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

285: invalid_rates_exist_rec invalid_rates_exist_csr%ROWTYPE;
286:
287:
288: -- Set up a cursor to get all the invalid rates.
289: -- By the logic of the fii_currency.get_global_rate_primary
290: -- and fii_currency.get_global_rate_secondary APIs, the returned value
291: -- is -ve if no rate exists:
292: -- -1 for dates with no rate.
293: -- -2 for unrecognized conversion rates.

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

286:
287:
288: -- Set up a cursor to get all the invalid rates.
289: -- By the logic of the fii_currency.get_global_rate_primary
290: -- and fii_currency.get_global_rate_secondary APIs, the returned value
291: -- is -ve if no rate exists:
292: -- -1 for dates with no rate.
293: -- -2 for unrecognized conversion rates.
294: -- -3 for missing EUR to USD rates on 01-JAN-1999 when the

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

407: --}
408: END IF;
409:
410: l_stmt_num := 10;
411: -- Use the fii_currency.get_global_rate_primary function to get the
412: -- conversion rate given a currency code and a date.
413: -- The function returns:
414: -- 1 for currency code of 'USD' which is the global currency
415: -- -1 for dates for which there is no currency conversion rate

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

417: -- -3 for missing EUR to USD rates on 01-JAN-1999 when the
418: -- transaction_date is prior to 01-JAN-1999 (when the EUR
419: -- officially went into circulation).
420:
421: -- Use the fii_currency.get_global_rate_secondary to get the secondary
422: -- global rate. If the secondary currency has not been set up,
423: -- make the rate null. If the secondary currency/rate types are the
424: -- same as the primary, don't call the API but rather use an update
425: -- statement followed by the insert.

Line 442: fii_currency.get_global_rate_primary (

438: curr_codes.currency_code,
439: to_conv.transaction_date,
440: decode (curr_codes.currency_code,
441: g_global_currency_code, 1,
442: fii_currency.get_global_rate_primary (
443: curr_codes.currency_code,
444: to_conv.transaction_date) ),
445: decode (g_secondary_currency_code,
446: NULL, NULL,

Line 450: fii_currency.get_global_rate_secondary (

446: NULL, NULL,
447: curr_codes.currency_code, 1,
448: decode (l_pri_sec_curr_same,
449: 1, C_PRI_SEC_CURR_SAME_MARKER,
450: fii_currency.get_global_rate_secondary (
451: curr_codes.currency_code,
452: to_conv.transaction_date)))
453: FROM
454: (SELECT /*+ parallel (opi_dbi_res_actual_stg) */