APPS.OPI_DBI_JOBS_PKG dependencies on FII_CURRENCY

Line 57: OPI_DBI_JOBS_STG using the fii_currency.get_global_rate_primary

53: The conversion rate work table was truncated during
54: the initialization phase.
55:
56: Get the currency conversion rates based on the data in
57: OPI_DBI_JOBS_STG using the fii_currency.get_global_rate_primary
58: API for the primary global currency and
59: fii_currency.get_global_rate_secondary for the secondary global currency.
60: The primary currency API:
61: 1. finds the conversion rate if one exists.

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

55:
56: Get the currency conversion rates based on the data in
57: OPI_DBI_JOBS_STG using the fii_currency.get_global_rate_primary
58: API for the primary global currency and
59: fii_currency.get_global_rate_secondary for the secondary global currency.
60: The primary currency API:
61: 1. finds the conversion rate if one exists.
62: 2. returns -1 if there is no conversion rate on that date.
63: 3. returns -2 if the currency code is not found.

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

105: invalid_rates_exist_rec invalid_rates_exist_csr%ROWTYPE;
106:
107:
108: -- Set up a cursor to get all the invalid rates.
109: -- By the logic of the fii_currency.get_global_rate_primary
110: -- and fii_currency.get_global_rate_secondary APIs, the returned value
111: -- is -ve if no rate exists:
112: -- -1 for dates with no rate.
113: -- -2 for unrecognized conversion rates.

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

106:
107:
108: -- Set up a cursor to get all the invalid rates.
109: -- By the logic of the fii_currency.get_global_rate_primary
110: -- and fii_currency.get_global_rate_secondary APIs, the returned value
111: -- is -ve if no rate exists:
112: -- -1 for dates with no rate.
113: -- -2 for unrecognized conversion rates.
114: -- -3 for missing EUR to USD rates on 01-JAN-1999 when the

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

205: END IF;
206:
207:
208: l_stmt_num := 20;
209: -- Use the fii_currency.get_global_rate_primary function to get the
210: -- conversion rate given a currency code and a date.
211: -- The function returns:
212: -- 1 for currency code of 'USD' which is the global currency
213: -- -1 for dates for which there is no currency conversion rate

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

215: -- -3 for missing EUR to USD rates on 01-JAN-1999 when the
216: -- transaction_date is prior to 01-JAN-1999 (when the EUR
217: -- officially went into circulation).
218:
219: -- Use the fii_currency.get_global_rate_secondary to get the secondary
220: -- global rate. If the secondary currency has not been set up,
221: -- make the rate null. If the secondary currency/rate types are the
222: -- same as the primary, don't call the API but rather use an update
223: -- statement followed by the insert.

Line 249: fii_currency.get_global_rate_primary (

245: curr_codes.currency_code,
246: to_conv.completion_date,
247: decode (curr_codes.currency_code,
248: g_global_currency_code, 1,
249: fii_currency.get_global_rate_primary (
250: curr_codes.currency_code,
251: to_conv.completion_date) ),
252: decode (g_secondary_currency_code,
253: NULL, NULL,

Line 257: fii_currency.get_global_rate_secondary (

253: NULL, NULL,
254: curr_codes.currency_code, 1,
255: decode (l_pri_sec_curr_same,
256: 1, C_PRI_SEC_CURR_SAME_MARKER,
257: fii_currency.get_global_rate_secondary (
258: curr_codes.currency_code,
259: to_conv.completion_date))),
260: g_sysdate,
261: g_sysdate,