[Home] [Help]
189: -- As these are truncate statements this procedure does a commit.
190: -- Common/Misc Tables:
191: -- OPI_DBI_OPM_INV_LED_CURRENT
192: -- OPI_DBI_OPM_INV_STG
193: -- OPI_DBI_CONVERSION_RATES
194: -- OPI_DBI_INV_ITEM_COSTS_TMP
195: -- OPI_PMI_COST_PARAM_GTMP
196: -- OPI_DBI_INV_VALUE_LOG -- added as part of CPCS Change.
197: -- Note: OPI_DBI_INV_TYPE_CODES is not cleaned anywhere.
242: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
243: END IF;
244:
245: l_stmt_num := 30;
246: execute immediate 'truncate table ' || g_opi_schema || '.OPI_DBI_CONVERSION_RATES';
247:
248: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
249: l_debug_msg := 'OPI_DBI_CONVERSION_RATES table truncated';
250: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
245: l_stmt_num := 30;
246: execute immediate 'truncate table ' || g_opi_schema || '.OPI_DBI_CONVERSION_RATES';
247:
248: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
249: l_debug_msg := 'OPI_DBI_CONVERSION_RATES table truncated';
250: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
251: END IF;
252:
253: -- Added opi_dbi_inv_value_log truncate for CPCS. This table should not be truncated in incremental load.
2651: organization_id,
2652: transaction_date,
2653: conversion_rate,
2654: sec_conversion_rate
2655: from OPI_DBI_CONVERSION_RATES
2656: ) rate
2657: where s.organization_id = rate.organization_id
2658: and s.transaction_date = rate.transaction_date;
2659:
2972: -- 2. opi_dbi_opm_inv_stg -- Pre r12 OPM DATA
2973: -- 3. OPI_DBI_INTRANSIT_STG -- Intransit Qty and Value
2974: -- 4. OPI_DBI_INV_BEG_STG -- Inception qty and value
2975: -- 5. OPI_DBI_ONHAND_STG -- On hand value
2976: -- 6. OPI_DBI_CONVERSION_RATES -- currency conversion rates
2977: OPI_DBI_INV_VALUE_INIT_PKG.merge_initial_load;
2978:
2979: l_stmt_num :=100;
2980: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then