APPS.OPI_DBI_INV_VALUE_UTL_PKG dependencies on OPI_DBI_CONVERSION_RATES

Line 47: FROM opi_dbi_conversion_rates

43:
44: -- Cursor to see if any rates are missing. See below for details
45: CURSOR invalid_rates_exist_csr IS
46: SELECT 1
47: FROM opi_dbi_conversion_rates
48: WHERE ( nvl (conversion_rate, -999) < 0
49: OR nvl (sec_conversion_rate, 999) < 0)
50: AND rownum < 2;
51:

Line 87: FROM opi_dbi_conversion_rates conv,

83: decode (conv.conversion_rate,
84: C_EURO_MISSING_AT_START, C_EURO_START_DATE,
85: conv.transaction_date) transaction_date,
86: conv.f_currency_code
87: FROM opi_dbi_conversion_rates conv,
88: mtl_parameters mp,
89: (SELECT /*+ parallel (opi_dbi_onhand_stg) */
90: DISTINCT organization_id, transaction_date
91: FROM opi_dbi_onhand_stg

Line 129: FROM opi_dbi_conversion_rates conv,

125: decode (conv.sec_conversion_rate,
126: C_EURO_MISSING_AT_START, C_EURO_START_DATE,
127: conv.transaction_date) transaction_date,
128: conv.f_currency_code
129: FROM opi_dbi_conversion_rates conv,
130: mtl_parameters mp,
131: (SELECT /*+ parallel (opi_dbi_onhand_stg) */
132: DISTINCT organization_id, transaction_date
133: FROM opi_dbi_onhand_stg

Line 194: '.OPI_DBI_CONVERSION_RATES';

190: ('OPI', l_status, l_industry, l_opi_schema)) ) THEN
191: return -1;
192: END IF;
193: EXECUTE IMMEDIATE 'truncate table ' || l_opi_schema ||
194: '.OPI_DBI_CONVERSION_RATES';
195: BIS_COLLECTION_UTILITIES.put_line (
196: 'OPI_DBI_CONVERSION_RATES table truncated.');
197:
198:

Line 196: 'OPI_DBI_CONVERSION_RATES table truncated.');

192: END IF;
193: EXECUTE IMMEDIATE 'truncate table ' || l_opi_schema ||
194: '.OPI_DBI_CONVERSION_RATES';
195: BIS_COLLECTION_UTILITIES.put_line (
196: 'OPI_DBI_CONVERSION_RATES table truncated.');
197:
198:
199: l_stmt_id := 10;
200: -- get the global currency code/rate types

Line 264: INSERT /*+ append parallel (opi_dbi_conversion_rates) */

260: -- and hr_organization_information, take care of duplicate codes.
261: --
262: -- Since OPM uses it's own currency conversion rate logic,
263: -- just filter out rows with source = 2.
264: INSERT /*+ append parallel (opi_dbi_conversion_rates) */
265: INTO opi_dbi_conversion_rates (
266: organization_id,
267: f_currency_code,
268: transaction_date,

Line 265: INTO opi_dbi_conversion_rates (

261: --
262: -- Since OPM uses it's own currency conversion rate logic,
263: -- just filter out rows with source = 2.
264: INSERT /*+ append parallel (opi_dbi_conversion_rates) */
265: INTO opi_dbi_conversion_rates (
266: organization_id,
267: f_currency_code,
268: transaction_date,
269: conversion_rate,

Line 347: UPDATE /*+ parallel (opi_dbi_conversion_rates) */

343: -- update the secondary with the primary
344: IF (l_pri_sec_curr_same = 1) THEN
345:
346: l_stmt_id := 70;
347: UPDATE /*+ parallel (opi_dbi_conversion_rates) */
348: opi_dbi_conversion_rates
349: SET sec_conversion_rate = conversion_rate;
350:
351: -- safe to commit, as before

Line 348: opi_dbi_conversion_rates

344: IF (l_pri_sec_curr_same = 1) THEN
345:
346: l_stmt_id := 70;
347: UPDATE /*+ parallel (opi_dbi_conversion_rates) */
348: opi_dbi_conversion_rates
349: SET sec_conversion_rate = conversion_rate;
350:
351: -- safe to commit, as before
352: l_stmt_id := 80;