APPS.BSC_UPDATE_DIM dependencies on BSC_SYS_BENCHMARKS_B

Line 2302: -- Delete from BSC_SYS_BENCHMARKS_B and BSC_SYS_BENCHMARKS_TL the

2298: -- isc_plan_snapshot_v does not exists so we cannot import dbi plans
2299: RETURN TRUE;
2300: END IF;
2301:
2302: -- Delete from BSC_SYS_BENCHMARKS_B and BSC_SYS_BENCHMARKS_TL the
2303: -- DBI plans that are no longer valid.
2304: l_sql := 'DELETE FROM bsc_sys_benchmarks_b'||
2305: ' WHERE source_type = :1'||
2306: ' AND data_type NOT IN ('||

Line 2304: l_sql := 'DELETE FROM bsc_sys_benchmarks_b'||

2300: END IF;
2301:
2302: -- Delete from BSC_SYS_BENCHMARKS_B and BSC_SYS_BENCHMARKS_TL the
2303: -- DBI plans that are no longer valid.
2304: l_sql := 'DELETE FROM bsc_sys_benchmarks_b'||
2305: ' WHERE source_type = :1'||
2306: ' AND data_type NOT IN ('||
2307: ' SELECT id FROM isc_plan_snapshot_v'||
2308: ')';

Line 2312: WHERE bm_id NOT IN (SELECT bm_id FROM bsc_sys_benchmarks_b);

2308: ')';
2309: EXECUTE IMMEDIATE l_sql USING 2;
2310:
2311: DELETE FROM bsc_sys_benchmarks_tl
2312: WHERE bm_id NOT IN (SELECT bm_id FROM bsc_sys_benchmarks_b);
2313:
2314: -- Insert new dbi plans into BSC_SYS_BENCHMARKS and BSC_SYS_BENCHMARKS_TL
2315: -- Added s.id < 1000 for bug#6713924
2316: l_num_ids := 0;

Line 2318: ' FROM isc_plan_snapshot_v s, bsc_sys_benchmarks_b b'||

2314: -- Insert new dbi plans into BSC_SYS_BENCHMARKS and BSC_SYS_BENCHMARKS_TL
2315: -- Added s.id < 1000 for bug#6713924
2316: l_num_ids := 0;
2317: l_sql := 'SELECT s.id, s.value'||
2318: ' FROM isc_plan_snapshot_v s, bsc_sys_benchmarks_b b'||
2319: ' WHERE s.id = b.data_type (+) AND b.source_type (+) = :1 AND b.data_type IS NULL AND s.id < 1000';
2320: OPEN l_cursor FOR l_sql USING 2;
2321: LOOP
2322: FETCH l_cursor INTO l_id, l_value;

Line 2333: FROM bsc_sys_benchmarks_b;

2329: CLOSE l_cursor;
2330:
2331: FOR l_i IN 1..l_num_ids LOOP
2332: SELECT NVL(MAX(bm_id)+1,1) INTO l_bm_id
2333: FROM bsc_sys_benchmarks_b;
2334:
2335: -- This inserts the record in bs_sys_benchmarks_b and tl for existing languages
2336: BSC_SYS_BENCHMARKS_PKG.Insert_Row(x_bm_id => l_bm_id,
2337: x_color => 0,