[Home] [Help]
280: l_Projection_Id BSC_DB_MEASURE_COLS_TL.PROJECTION_ID%TYPE;
281: l_Measure_Type BSC_DB_MEASURE_COLS_TL.MEASURE_TYPE%TYPE;
282: CURSOR bsc_indicators_cursor IS
283: SELECT d.dataset_id, i.name as measure_name, i.description, i.short_name as measure_short_name, i.indicator_id measure_id, i.created_by created_by, i.last_updated_by last_updated_by, i.last_update_login last_update_login
284: FROM bsc_sys_datasets_vl d, bis_indicators_vl i, bsc_sys_measures m
285: WHERE i.short_name = m.short_name (+)
286: and (d.source is null or d.source = 'PMF')
287: and m.measure_id = d.measure_id1 (+)
288: and (i.dataset_id is null or d.dataset_id <> i.dataset_id);
441: l_Short_Name BIS_INDICATORS.short_name%TYPE;
442:
443: CURSOR bsc_datasets_cursor_1 IS
444: SELECT d.dataset_id, name, m.measure_id, m.created_by created_by, m.last_updated_by last_updated_by, m.last_update_login last_update_login
445: FROM bsc_sys_datasets_vl d, bsc_sys_measures m, bisbv_performance_measures pm
446: WHERE d.measure_id1 = m.measure_id
447: AND m.short_name is null
448: AND d.source = 'BSC'
449: AND d.dataset_id = pm.dataset_id (+)
554: l_err VARCHAR2(2000);
555:
556: CURSOR cds_datasets_cursor IS
557: SELECT d.dataset_id, m.short_name
558: FROM bsc_sys_datasets_vl d, bsc_sys_measures m, bisbv_performance_measures pm
559: WHERE d.measure_id1 = m.measure_id
560: AND m.short_name = pm.measure_short_name (+)
561: AND m.short_name IS NOT NULL
562: AND d.source = 'CDS'
632: l_err VARCHAR2(2000);
633:
634: CURSOR bsc_datasets_cursor_2 IS
635: SELECT d.dataset_id, name, m.short_name, m.measure_id, pm.measure_short_name, m.created_by created_by, m.last_updated_by last_updated_by, m.last_update_login last_update_login
636: FROM bsc_sys_datasets_vl d, bsc_sys_measures m, bisbv_performance_measures pm
637: WHERE d.measure_id1 = m.measure_id
638: AND m.short_name = pm.measure_short_name (+)
639: AND m.short_name IS NOT NULL
640: AND d.source = 'BSC'
804: ,B.short_name bisShortName
805: ,B.dataset_id
806: ,M.measure_id
807: FROM bsc_sys_measures M
808: ,bsc_sys_datasets_vl V
809: ,bis_indicators_Vl B
810: WHERE M.measure_id = V.measure_id1
811: AND B.dataset_id = V.dataset_id
812: AND V.SOURCE = 'BSC'
847:
848: BEGIN
849:
850: -- meastmon bug#3379110 --------------------------------------------------------------------
851: -- If the dataset_ids from BIS_INDICATORS and BSC_SYS_DATASETS_VL are not in synch
852: -- we are going to:
853: -- 1. Remove BSC measures from PMF repository
854: -- 2. Update all the dataset_ids to NULL.
855: -- Then synchronization will refresh the dataset_id in BIS_INDICATORS with the correct value
852: -- we are going to:
853: -- 1. Remove BSC measures from PMF repository
854: -- 2. Update all the dataset_ids to NULL.
855: -- Then synchronization will refresh the dataset_id in BIS_INDICATORS with the correct value
856: -- from BSC_SYS_DATASETS_VL
857: delete_bsc_measures_from_pmf;
858:
859: -- For every PMF record that does not exist in bsc_sys_datasets, create one in bsc_sys_datasets and bsc_sys_measures
860: sync_measures_pmf_to_bsc;
2487: CURSOR c_update_appid IS
2488: SELECT bisapp.indicator_id
2489: FROM bis_application_measures bisapp,
2490: bis_indicators bisindic,
2491: bsc_sys_datasets_vl bsc
2492: WHERE bisapp.indicator_id = bisindic.indicator_id
2493: AND bisindic.dataset_id = bsc.dataset_id
2494: AND bsc.source= 'BSC'
2495: AND (bisapp.application_id = -1 OR bisapp.application_id IS NULL);
2585: I.DATASET_ID,
2586: I.NAME
2587: FROM
2588: BSC_SYS_MEASURES M,
2589: BSC_SYS_DATASETS_VL D,
2590: BIS_INDICATORS_VL I
2591: WHERE
2592: M.MEASURE_ID = D.MEASURE_ID1 AND
2593: D.DATASET_ID=I.DATASET_ID AND