[Home] [Help]
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'
652: -- If these datasets were already synchronized above, then there would be a record
653: -- in bis_indicators for every dataset. Hence, added the check here so that
654: -- update is done only if that dataset id is not already set in bis_indicators
655: SELECT count(1) INTO l_count
656: FROM BISBV_PERFORMANCE_MEASURES
657: WHERE dataset_id = cr.dataset_id;
658:
659: IF (l_count = 0) THEN
660: UPDATE BIS_INDICATORS