APPS.OPI_DBI_JOBS_PKG dependencies on OPI_DBI_MUV_CONV_RATES

Line 100: FROM opi_dbi_muv_conv_rates

96:
97: -- Cursor to see if any rates are missing. See below for details
98: CURSOR invalid_rates_exist_csr IS
99: SELECT 1
100: FROM opi_dbi_muv_conv_rates
101: WHERE ( nvl (conversion_rate, -999) < 0
102: OR nvl (sec_conversion_rate, 999) < 0)
103: AND rownum < 2;
104:

Line 141: FROM opi_dbi_muv_conv_rates conv,

137: decode (conv.conversion_rate,
138: C_EURO_MISSING_AT_START, g_euro_start_date,
139: conv.transaction_date) completion_date,
140: conv.f_currency_code func_currency_code
141: FROM opi_dbi_muv_conv_rates conv,
142: mtl_parameters mp,
143: (SELECT /*+ parallel (opi_dbi_jobs_stg) */
144: DISTINCT organization_id,
145: trunc (completion_date) completion_date

Line 163: FROM opi_dbi_muv_conv_rates conv,

159: decode (conv.sec_conversion_rate,
160: C_EURO_MISSING_AT_START, g_euro_start_date,
161: conv.transaction_date) completion_date,
162: conv.f_currency_code func_currency_code
163: FROM opi_dbi_muv_conv_rates conv,
164: mtl_parameters mp,
165: (SELECT /*+ parallel (opi_dbi_jobs_stg) */
166: DISTINCT organization_id,
167: trunc (completion_date) completion_date

Line 228: INTO opi_dbi_muv_conv_rates rates (

224:
225: -- By selecting distinct org and currency code from the gl_set_of_books
226: -- and hr_organization_information, take care of duplicate codes.
227: INSERT /*+ append parallel(rates) */
228: INTO opi_dbi_muv_conv_rates rates (
229: organization_id,
230: f_currency_code,
231: transaction_date,
232: conversion_rate,

Line 293: UPDATE /*+ parallel (opi_dbi_muv_conv_rates) */

289: -- if the primary and secondary currency codes are the same, then
290: -- update the secondary with the primary
291: IF (l_pri_sec_curr_same = 1) THEN
292:
293: UPDATE /*+ parallel (opi_dbi_muv_conv_rates) */
294: opi_dbi_muv_conv_rates
295: SET sec_conversion_rate = conversion_rate;
296:
297: -- safe to commit, as before

Line 294: opi_dbi_muv_conv_rates

290: -- update the secondary with the primary
291: IF (l_pri_sec_curr_same = 1) THEN
292:
293: UPDATE /*+ parallel (opi_dbi_muv_conv_rates) */
294: opi_dbi_muv_conv_rates
295: SET sec_conversion_rate = conversion_rate;
296:
297: -- safe to commit, as before
298: commit;

Line 429: opi_dbi_muv_conv_rates conv

425: fstg.PROGRAM_LOGIN_ID,
426: fstg.PROGRAM_APPLICATION_ID,
427: fstg.REQUEST_ID
428: FROM opi_dbi_jobs_stg fstg,
429: opi_dbi_muv_conv_rates conv
430: WHERE fstg.organization_id = conv.organization_id
431: AND fstg.completion_date = conv.transaction_date;
432:
433: l_row_count := sql%rowcount;

Line 478: opi_dbi_muv_conv_rates conv

474: fstg.PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID,
475: fstg.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID,
476: fstg.REQUEST_ID REQUEST_ID
477: FROM opi_dbi_jobs_stg fstg,
478: opi_dbi_muv_conv_rates conv
479: WHERE fstg.organization_id = conv.organization_id
480: AND fstg.completion_date = conv.transaction_date ) s
481: ON ( f.Organization_id = s.Organization_id
482: and f.Job_id = s.Job_id

Line 664: '.OPI_DBI_MUV_CONV_RATES';

660: -- '.MLOG$_OPI_DBI_JOBS_F';
661: execute immediate 'truncate table ' || l_opi_schema ||
662: '.OPI_DBI_JOBS_F PURGE MATERIALIZED VIEW LOG';
663: execute immediate 'truncate table ' || l_opi_schema ||
664: '.OPI_DBI_MUV_CONV_RATES';
665: END IF;
666:
667: l_stmt_num := 10;
668: -- GSD -- already checked if it is set up

Line 1546: '.OPI_DBI_MUV_CONV_RATES';

1542: l_stmt_num := 35;
1543: IF fnd_installation.get_app_info ('OPI', l_status,
1544: l_industry, l_opi_schema) THEN
1545: execute immediate 'truncate table ' || l_opi_schema ||
1546: '.OPI_DBI_MUV_CONV_RATES';
1547:
1548: execute immediate 'truncate table ' || l_opi_schema ||
1549: '.OPI_DBI_JOBS_STG';
1550: END IF;