eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_UPDATE dependencies on BSC_UPDATE_DIM

Line 530: -- IF NOT BSC_UPDATE_DIM.Refresh_EDW_Dimensions(h_edw_dim_tables, h_num_edw_dim_tables) THEN

526: -- RAISE e_update_error;
527: -- END IF;
528: --
529: -- IF h_num_edw_dim_tables > 0 THEN
530: -- IF NOT BSC_UPDATE_DIM.Refresh_EDW_Dimensions(h_edw_dim_tables, h_num_edw_dim_tables) THEN
531: -- RAISE e_update_error;
532: -- END IF;
533: -- END IF;
534: -- END IF;

Line 577: IF NOT BSC_UPDATE_DIM.Import_Dbi_Plans_AT(h_error_message) THEN

573: RAISE e_could_not_get_lock;
574: END IF;
575:
576: -- LOCKING: Call the autonomous transaction function
577: IF NOT BSC_UPDATE_DIM.Import_Dbi_Plans_AT(h_error_message) THEN
578: RAISE e_import_dbi_plans;
579: END IF;
580:
581: -- AW_INTEGRATION: Load TYPE dimension into AW

Line 600: BSC_UPDATE_DIM.Load_Type_Into_AW_AT;

596: h_load_type_into_aw := TRUE;
597: END IF;
598: END IF;
599: IF h_load_type_into_aw THEN
600: BSC_UPDATE_DIM.Load_Type_Into_AW_AT;
601: END IF;
602:
603: --LOCKING: commit to release the locks
604: COMMIT;

Line 622: IF NOT BSC_UPDATE_DIM.Create_AW_Dim_Temp_Tables_AT THEN

618: RAISE e_could_not_get_lock;
619: END IF;
620:
621: -- LOCKING: call the autonomous trnasaction function
622: IF NOT BSC_UPDATE_DIM.Create_AW_Dim_Temp_Tables_AT THEN
623: RAISE e_update_error;
624: END IF;
625:
626: --LOCKING: commit to release locks

Line 790: -- IF NOT BSC_UPDATE_DIM.Refresh_EDW_Dimensions(h_edw_dim_tables, h_num_edw_dim_tables) THEN

786: --ELSIF x_process_name = PC_REFRESH_EDW_DIMENSION THEN
787: -- -- Refresh EDW dimension table
788: -- h_num_edw_dim_tables := 1;
789: -- h_edw_dim_tables(1) := x_parameter_1;
790: -- IF NOT BSC_UPDATE_DIM.Refresh_EDW_Dimensions(h_edw_dim_tables, h_num_edw_dim_tables) THEN
791: -- RAISE e_update_error;
792: -- END IF;
793: END IF;
794:

Line 927: BSC_MESSAGE.Add(x_message => 'BSC_UPDATE_DIM.Import_Dbi_Plans: '||h_error_message,

923: -- Delete records in the temporal table used for big 'in' conditions
924: BSC_APPS.Init_Big_In_Cond_Table;
925:
926: BSC_MESSAGE.flush;
927: BSC_MESSAGE.Add(x_message => 'BSC_UPDATE_DIM.Import_Dbi_Plans: '||h_error_message,
928: x_source => 'BSC_UPDATE.Execute_Update_Process',
929: x_mode => 'I');
930: COMMIT;
931:

Line 2543: h_dim_tables(h_i) := BSC_UPDATE_DIM.Get_Dim_Table_of_Input_Table(x_input_tables(h_i));

2539:
2540: -- Init array h_dim_tables which contains the dimension table corrsponding to input
2541: -- tables in array x_input_tables (same order)
2542: FOR h_i IN 1 .. x_num_input_tables LOOP
2543: h_dim_tables(h_i) := BSC_UPDATE_DIM.Get_Dim_Table_of_Input_Table(x_input_tables(h_i));
2544: END LOOP;
2545: h_num_dim_tables := x_num_input_tables;
2546:
2547: -- Load input tables

Line 2608: h_table_is_valid := BSC_UPDATE_DIM.Validate_Input_Table_AT(h_input_table, h_dim_table);

2604: h_message := BSC_UPDATE_UTIL.Get_Message('BSC_TABLE_NAME_VALIDATION');
2605: h_message := BSC_UPDATE_UTIL.Replace_Token(h_message, 'TABLE_NAME', h_input_table);
2606: BSC_UPDATE_LOG.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
2607: --LOCKING: call the automous transaction function
2608: h_table_is_valid := BSC_UPDATE_DIM.Validate_Input_Table_AT(h_input_table, h_dim_table);
2609:
2610: IF h_table_is_valid IS NULL THEN
2611: RAISE e_unexpected_error;
2612: END IF;

Line 2630: IF NOT BSC_UPDATE_DIM.Load_Dim_Table_AT(h_dim_table, h_input_table) THEN

2626: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_UPDATING_DIM_TABLE')||
2627: ' '||h_dim_table, BSC_UPDATE_LOG.OUTPUT);
2628:
2629: --LOCKING: Call the autonomous trnsaction
2630: IF NOT BSC_UPDATE_DIM.Load_Dim_Table_AT(h_dim_table, h_input_table) THEN
2631: RAISE e_unexpected_error;
2632: END IF;
2633:
2634: -- AW_INTEGRATION: init this variable

Line 2673: h_dim_table_type := BSC_UPDATE_DIM.Get_Dim_Table_Type(h_dim_table);

2669: END IF;
2670:
2671: --AW_INTEGRATION: We need to load the dimension into AW even if the table was not loaded
2672: IF NOT h_dim_was_loaded THEN
2673: h_dim_table_type := BSC_UPDATE_DIM.Get_Dim_Table_Type(h_dim_table);
2674: IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_1N THEN
2675: IF BSC_UPDATE_DIM.Dimension_Used_In_AW_Kpi(h_dim_table) THEN
2676: BSC_UPDATE_LOG.Write_Line_Log('Loading '||h_dim_table||' into AW', BSC_UPDATE_LOG.OUTPUT);
2677: --LOCKING: Call the autonomous transaction procedure

Line 2674: IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_1N THEN

2670:
2671: --AW_INTEGRATION: We need to load the dimension into AW even if the table was not loaded
2672: IF NOT h_dim_was_loaded THEN
2673: h_dim_table_type := BSC_UPDATE_DIM.Get_Dim_Table_Type(h_dim_table);
2674: IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_1N THEN
2675: IF BSC_UPDATE_DIM.Dimension_Used_In_AW_Kpi(h_dim_table) THEN
2676: BSC_UPDATE_LOG.Write_Line_Log('Loading '||h_dim_table||' into AW', BSC_UPDATE_LOG.OUTPUT);
2677: --LOCKING: Call the autonomous transaction procedure
2678: BSC_UPDATE_DIM.Load_Dim_Into_AW_AT(h_dim_table);

Line 2675: IF BSC_UPDATE_DIM.Dimension_Used_In_AW_Kpi(h_dim_table) THEN

2671: --AW_INTEGRATION: We need to load the dimension into AW even if the table was not loaded
2672: IF NOT h_dim_was_loaded THEN
2673: h_dim_table_type := BSC_UPDATE_DIM.Get_Dim_Table_Type(h_dim_table);
2674: IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_1N THEN
2675: IF BSC_UPDATE_DIM.Dimension_Used_In_AW_Kpi(h_dim_table) THEN
2676: BSC_UPDATE_LOG.Write_Line_Log('Loading '||h_dim_table||' into AW', BSC_UPDATE_LOG.OUTPUT);
2677: --LOCKING: Call the autonomous transaction procedure
2678: BSC_UPDATE_DIM.Load_Dim_Into_AW_AT(h_dim_table);
2679: END IF;

Line 2678: BSC_UPDATE_DIM.Load_Dim_Into_AW_AT(h_dim_table);

2674: IF h_dim_table_type = BSC_UPDATE_DIM.DIM_TABLE_TYPE_1N THEN
2675: IF BSC_UPDATE_DIM.Dimension_Used_In_AW_Kpi(h_dim_table) THEN
2676: BSC_UPDATE_LOG.Write_Line_Log('Loading '||h_dim_table||' into AW', BSC_UPDATE_LOG.OUTPUT);
2677: --LOCKING: Call the autonomous transaction procedure
2678: BSC_UPDATE_DIM.Load_Dim_Into_AW_AT(h_dim_table);
2679: END IF;
2680: END IF;
2681: END IF;
2682:

Line 2714: IF NOT BSC_UPDATE_DIM.WriteRemovedKeyItems THEN

2710:
2711: BSC_UPDATE_LOG.Write_Line_Log(BSC_UPDATE_UTIL.Get_Message('BSC_DIMTABLE_UPDATED'), BSC_UPDATE_LOG.OUTPUT);
2712:
2713: -- Write indicator with unexisting default dimenision values
2714: IF NOT BSC_UPDATE_DIM.WriteRemovedKeyItems THEN
2715: NULL;
2716: END IF;
2717:
2718: RETURN TRUE;

Line 4832: --IF NOT BSC_UPDATE_DIM.Import_Dbi_Plans(h_error_msg) THEN

4828: RETURN;
4829: END IF;
4830:
4831: --Fix bug#3923207: import dbi plans was moved to execute_update_process
4832: --IF NOT BSC_UPDATE_DIM.Import_Dbi_Plans(h_error_msg) THEN
4833: -- RAISE e_import_dbi_plans;
4834: --END IF;
4835:
4836: -- Bug#4681065: we are going to process only indicators in production.

Line 5138: IF NOT BSC_UPDATE_DIM.Get_Dbi_Dims_Kpis(h_indicators, h_num_indicators, h_dbi_dimensions, h_num_dbi_dimensions) THEN

5134: -- Get short name of the DBI dimensions used by the indicators
5135: -- AW_INTEGRATION: Since we need to bring all the BIS dimensions used by AW indicators into AW world
5136: -- I need to change the next function to return all the BIS dimensions and not only the
5137: -- ones that are materialized in BSC
5138: IF NOT BSC_UPDATE_DIM.Get_Dbi_Dims_Kpis(h_indicators, h_num_indicators, h_dbi_dimensions, h_num_dbi_dimensions) THEN
5139: RAISE e_unexpected_error;
5140: END IF;
5141:
5142: -- Launch a concurrent program to refresh each DBI dim table created in BSC to materialize

Line 5147: IF NOT BSC_UPDATE_DIM.Create_Dbi_Dim_Temp_Tables THEN

5143: -- the DBi dimension view.
5144:
5145: -- Create the global temporary tables needed in this process (one time)
5146: IF h_num_dbi_dimensions > 0 THEN
5147: IF NOT BSC_UPDATE_DIM.Create_Dbi_Dim_Temp_Tables THEN
5148: RAISE e_unexpected_error;
5149: END IF;
5150: -- AW_INTEGRATION: Create temporary tables needed for AW dimension processing
5151: IF NOT BSC_UPDATE_DIM.Create_AW_Dim_Temp_Tables THEN

Line 5151: IF NOT BSC_UPDATE_DIM.Create_AW_Dim_Temp_Tables THEN

5147: IF NOT BSC_UPDATE_DIM.Create_Dbi_Dim_Temp_Tables THEN
5148: RAISE e_unexpected_error;
5149: END IF;
5150: -- AW_INTEGRATION: Create temporary tables needed for AW dimension processing
5151: IF NOT BSC_UPDATE_DIM.Create_AW_Dim_Temp_Tables THEN
5152: RAISE e_unexpected_error;
5153: END IF;
5154: END IF;
5155: