APPS.OPI_DBI_JOB_TXN_STG_PKG dependencies on FII_CURRENCY

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

147: END IF;
148:
149:
150: l_stmt_num := 30;
151: -- Use the fii_currency.get_global_rate_primary function to get the
152: -- conversion rate given a currency code and a date.
153: -- The function returns:
154: -- 1 for currency code of 'USD' which is the global currency
155: -- -1 for dates for which there is no currency conversion rate

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

157: -- -3 for missing EUR to USD rates on 01-JAN-1999 when the
158: -- transaction_date is prior to 01-JAN-1999 (when the EUR
159: -- officially went into circulation).
160:
161: -- Use the fii_currency.get_global_rate_secondary to get the secondary
162: -- global rate. If the secondary currency has not been set up,
163: -- make the rate null. If the secondary currency/rate types are the
164: -- same as the primary, don't call the API but rather use an update
165: -- statement followed by the insert.

Line 192: fii_currency.get_global_rate_primary (

188: curr_codes.currency_code,
189: to_conv.transaction_date,
190: decode (curr_codes.currency_code,
191: g_global_currency_code, 1,
192: fii_currency.get_global_rate_primary (
193: curr_codes.currency_code,
194: to_conv.transaction_date) ),
195: decode (g_secondary_currency_code,
196: NULL, NULL,

Line 200: fii_currency.get_global_rate_secondary (

196: NULL, NULL,
197: curr_codes.currency_code, 1,
198: decode (l_pri_sec_curr_same,
199: 1, C_PRI_SEC_CURR_SAME_MARKER,
200: fii_currency.get_global_rate_secondary (
201: curr_codes.currency_code,
202: to_conv.transaction_date))),
203: s_sysdate,
204: s_sysdate,