[Home] [Help]
568:
569: -- Fix bug#3923207: Load dbi plans into bsc benchmarks whenever Loader is called to load data
570: IF x_process_name = PC_LOADER_PROCESS THEN
571: --LOCKING: Get the locks needed to import benchmarks
572: IF NOT BSC_UPDATE_LOCK.Lock_Import_Dbi_Plans THEN
573: RAISE e_could_not_get_lock;
574: END IF;
575:
576: -- LOCKING: Call the autonomous transaction function
613: -- of the current process whose status is pending
614:
615: -- AW_INTEGRATION: Create temporary tables needed for AW dimension processing
616: --LOCKING: Lock the temporal tables for dimensions
617: IF NOT BSC_UPDATE_LOCK.Lock_Temp_Tables('DIMENSION') THEN
618: RAISE e_could_not_get_lock;
619: END IF;
620:
621: -- LOCKING: call the autonomous trnasaction function
654: --LOCKING: Lock all the indicators that are going to be affected in the
655: -- incremental logic. This is in cascade mode and in READ mode.
656: -- This is to prevent Metadata Optimizer and Designer to modify those indicators
657: -- during this process
658: IF NOT BSC_UPDATE_LOCK.Lock_Incremental_Indicators THEN
659: RAISE e_could_not_get_lock;
660: END IF;
661:
662: --LOCKING: call the autonomous transaction function
680: -- This is in cascade mode and in READ mode.
681: -- This is to prevent Metadata Optimizer and Designer to modify those indicators
682: -- during this process.
683:
684: IF NOT BSC_UPDATE_LOCK.Lock_Indicators(h_input_tables, h_num_input_tables) THEN
685: RAISE e_could_not_get_lock;
686: END IF;
687:
688: --LOCKING: Review no commit between this point and the commit to release the locks
725:
726: -- LOCKING: Lock the indicators in cascade mode and in read mode that are using
727: -- any of the calendars. This is to prevent Metadata Optimizer to run on those
728: -- indicators or Designer to midify those indicators, its measures and dimensions
729: IF NOT BSC_UPDATE_LOCK.Lock_Indicators_by_Calendar(h_calendars, h_num_calendars) THEN
730: RAISE e_could_not_get_lock;
731: END IF;
732:
733: --LOCKING: Review no commit between this point and the commit to release the locks
765: CLOSE c_indicators;
766:
767: -- LOCKING: lock all the affected indicators in casscade mode and in read mode to prevent
768: -- metadata optimizer and designers to run on those indicators during this process
769: IF NOT BSC_UPDATE_LOCK.Lock_Indicators_To_Delete(h_indicators, h_num_indicators) THEN
770: RAISE e_could_not_get_lock;
771: END IF;
772:
773: IF g_keep_input_table_data IS NULL THEN
1134: h_num_aw_indicators := 0;
1135: h_num_aw_base_tables := 0;
1136:
1137: --LOCKING: Lock the objects required to change the calendar
1138: IF NOT BSC_UPDATE_LOCK.Lock_Calendar_Change(x_calendar_id) THEN
1139: RAISE e_could_not_get_lock;
1140: END IF;
1141:
1142: --LOCKING: review no commit between this point and the commit to release the locks
1486: FETCH c_sum_tables_mv INTO h_table_name;
1487: EXIT WHEN c_sum_tables_mv%NOTFOUND;
1488:
1489: --LOCKING: Lock the table
1490: IF NOT BSC_UPDATE_LOCK.Lock_Table(h_table_name) THEN
1491: RAISE e_could_not_get_lock;
1492: END IF;
1493:
1494: --LOCKING: Call the autonomous transaction function
1510: -- bug 5660053 we are not creating AW tables for base tables so we do not need to truncate
1511: /*FOR h_i IN 1..h_num_aw_base_tables LOOP
1512: -- We need to truncate the AW table created for the base table
1513: --LOCKING: Lock the table
1514: IF NOT BSC_UPDATE_LOCK.Lock_Table(h_aw_base_tables(h_i)) THEN
1515: RAISE e_could_not_get_lock;
1516: END IF;
1517:
1518: h_aw_table_name := BSC_UPDATE_BASE.Get_Base_AW_Table_Name(h_aw_base_tables(h_i));
1527: -- AW_INTEGRATION: Refresh indicators cubes
1528: FOR h_i IN 1..h_num_aw_indicators LOOP
1529: IF BSC_UPDATE_UTIL.Is_Kpi_In_Production(h_aw_indicators(h_i)) THEN
1530: --LOCKING: Lock the objects required to refresh the AW indicator cubes
1531: IF NOT BSC_UPDATE_LOCK.Lock_Refresh_AW_Indicator(h_aw_indicators(h_i)) THEN
1532: RAISE e_could_not_get_lock;
1533: END IF;
1534:
1535: --LOCKING: call the autonomous transaction procedure
1542: COMMIT;
1543:
1544: -- Write the update date
1545: --LOCKING: Lock date of update process
1546: IF NOT BSC_UPDATE_LOCK.Lock_Update_Date THEN
1547: RAISE e_could_not_get_lock;
1548: END IF;
1549:
1550: IF NOT BSC_UPDATE_UTIL.Write_Init_Variable_Value('UPDATE_DATE', TO_CHAR(SYSDATE, 'DD/MM/YYYY')) THEN
1562: -- BSC_MV Note: Populate reporting calendar
1563: -- Fix bug#4027813: move load reporting calendar here and pass calendar id
1564: IF BSC_APPS.bsc_mv THEN
1565: -- LOCKING: lock the calendar
1566: IF NOT BSC_UPDATE_LOCK.Lock_Calendar(x_calendar_id) THEN
1567: RAISE e_could_not_get_lock;
1568: END IF;
1569:
1570: --LOCKING: call the autonomous transaction
2211: BSC_UPDATE_UTIL.Get_Lookup_Value('BSC_UI_COMMON', 'SYMBOL_COLON')||' '||h_source_name;
2212: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
2213:
2214: -- LOCKING: Lock required objects
2215: IF NOT BSC_UPDATE_LOCK.Lock_Import_ITable(h_input_table) THEN
2216: RAISE e_could_not_get_lock;
2217: END IF;
2218:
2219: -- LOCKING: call the autonomous transaction
2577: h_input_table := x_input_tables(h_i);
2578:
2579: --LOCKING: Lock the required objects to process this dimension table
2580: --LOCKING: Remove any commit between this point and the commit to release the locks
2581: IF NOT BSC_UPDATE_LOCK.Lock_Load_Dimension_Table(h_dim_table, h_input_table) THEN
2582: RAISE e_could_not_get_lock;
2583: END IF;
2584:
2585: -- AW_INTEGRATION: init this variable
2932: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_DATATABLE_UPD_PROCESS'), BSC_UPDATE_LOG.OUTPUT);
2933:
2934: -- Create generic temporal tables for the process
2935: --LOCKING: lock the temporary tables
2936: IF NOT BSC_UPDATE_LOCK.Lock_Temp_Tables('DATA') THEN
2937: RAISE e_could_not_get_lock;
2938: END IF;
2939:
2940: --LOCKING: call the autonomous transaction function
2985: h_aw_flag := FALSE;
2986: END IF;
2987:
2988: --LOCKING: lock the input table and the base table
2989: IF NOT BSC_UPDATE_LOCK.Lock_Update_Base_Table(h_input_table, h_base_table) THEN
2990: RAISE e_could_not_get_lock;
2991: END IF;
2992:
2993: --LOCKING: review no commit between this point and the commit to release the locks
3182: RAISE e_unexpected_error;
3183: END IF;
3184:
3185: --LOCKING: lock the input table and the base table
3186: IF NOT BSC_UPDATE_LOCK.Lock_Update_Base_Table(x_input_tables(h_i), h_base_table) THEN
3187: RAISE e_could_not_get_lock;
3188: END IF;
3189:
3190: --LOCKING: review no commit between this point and the commit to release the locks
3346: h_system_tables_aw,
3347: h_num_system_tables_aw) THEN
3348: -- This table is for an AW indicator
3349: --LOCKING: lock the tables needed to refresh this table
3350: IF NOT BSC_UPDATE_LOCK.Lock_Refresh_AW_Table(h_system_tables(h_i)) THEN
3351: RAISE e_could_not_get_lock;
3352: END IF;
3353:
3354: --LOCKING: call the autonomous transaction function
3360: COMMIT;
3361: ELSE
3362: -- This table is for a MV indicator
3363: --LOCKING: lock the tables needed to refresh this table
3364: IF NOT BSC_UPDATE_LOCK.Lock_Refresh_MV(h_system_tables(h_i)) THEN
3365: RAISE e_could_not_get_lock;
3366: END IF;
3367:
3368: -- LOCKING: call the autonomous transaction function
3378: COMMIT;
3379: END IF;
3380: ELSE
3381: --LOCKING: lock the tables needed to refresh this table
3382: IF NOT BSC_UPDATE_LOCK.Lock_Refresh_Sum_Table(h_system_tables(h_i)) THEN
3383: RAISE e_could_not_get_lock;
3384: END IF;
3385:
3386: --LOCKING: call the autonomous transaction function
3400:
3401: --LOCKING: remove this call
3402: -- Update Time Stamp of the indicators using this table directly
3403: --LOCKING: Lock the indicator period fo the indicators using this table
3404: IF NOT BSC_UPDATE_LOCK.Lock_Period_Indicators(h_system_tables(h_i)) THEN
3405: RAISE e_could_not_get_lock;
3406: END IF;
3407:
3408: BSC_UPDATE_UTIL.Update_Kpi_Table_Time_Stamp(h_system_tables(h_i));
3455: ' '||h_indicators_aw(h_i),
3456: BSC_UPDATE_LOG.OUTPUT);
3457:
3458: --LOCKING: Lock the objects required to refresh the AW indicator cubes
3459: IF NOT BSC_UPDATE_LOCK.Lock_Refresh_AW_Indicator(h_indicators_aw(h_i)) THEN
3460: RAISE e_could_not_get_lock;
3461: END IF;
3462:
3463: -- AW_INTEGRATION: Call the aw api to refresh the indicator cubes
3497: END IF;
3498:
3499: IF h_num_color_indicators > 0 THEN
3500: -- LOCKING: Lock temp tables for coloring
3501: IF NOT BSC_UPDATE_LOCK.Lock_Temp_Tables('COLOR') THEN
3502: RAISE e_could_not_get_lock;
3503: END IF;
3504:
3505: -- LOCKING: call the autonomous transaction function
3533: ' '||h_color_indicators(h_i),
3534: BSC_UPDATE_LOG.OUTPUT);
3535:
3536: --LOCKING: Calculate indicator period here
3537: IF NOT BSC_UPDATE_LOCK.Lock_Period_Indicator(h_color_indicators(h_i)) THEN
3538: RAISE e_could_not_get_lock;
3539: END IF;
3540:
3541: IF NOT Update_Indicator_Period(h_color_indicators(h_i)) THEN
3551: --LOCKING: commit to release lock
3552: COMMIT;
3553:
3554: --LOCKING: Lock indicator color
3555: IF NOT BSC_UPDATE_LOCK.Lock_Color_Indicator(h_color_indicators(h_i)) THEN
3556: RAISE e_could_not_get_lock;
3557: END IF;
3558:
3559: -- LOCKING: Call the autonomous transaction
3569: BSC_UPDATE_LOG.Write_Line_log(h_message,
3570: BSC_UPDATE_LOG.OUTPUT);
3571:
3572: --LOCKING: Lock the update period of the indicator
3573: IF NOT BSC_UPDATE_LOCK.Lock_Period_Indicator(h_color_indicators(h_i)) THEN
3574: RAISE e_could_not_get_lock;
3575: END IF;
3576:
3577: -- LOCKING: review not commit between this point and the commit to release the locks
3596:
3597: -- BSC-BIS-DIMENSIONS: Since we can run on indicators with prototype flag 6 or 7
3598: -- we need to update the indicator to prototype flag 0
3599: --LOCKING: lock the prototype flag of the indicator
3600: IF NOT BSC_UPDATE_LOCK.Lock_Prototype_Indicator(h_color_indicators(h_i)) THEN
3601: RAISE e_could_not_get_lock;
3602: END IF;
3603:
3604: UPDATE bsc_kpis_b
3619: END IF;
3620:
3621: -- Update the date of update process
3622: --LOCKING: Lock date of update process
3623: IF NOT BSC_UPDATE_LOCK.Lock_Update_Date THEN
3624: RAISE e_could_not_get_lock;
3625: END IF;
3626:
3627: IF NOT BSC_UPDATE_UTIL.Write_Init_Variable_Value('UPDATE_DATE', TO_CHAR(SYSDATE, 'DD/MM/YYYY')) THEN
3797:
3798: --LOCKING: Lock the objects required for the mv refresh
3799: --LOCKING: review that no commits between this point and the commit to
3800: -- to release the locks
3801: IF NOT BSC_UPDATE_LOCK.Lock_Refresh_MV(h_system_tables(h_i)) THEN
3802: RAISE e_could_not_get_lock;
3803: END IF;
3804:
3805: --LOCKING: call the autonomous transaction function