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_MIGRATION dependencies on BSC_UPDATE

Line 1058: h_key_columns BSC_UPDATE_UTIL.t_array_of_varchar2;

1054:
1055: --bug#5943112
1056: h_max_partitions NUMBER;
1057: h_num_partitions NUMBER;
1058: h_key_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
1059: h_key_dim_tables BSC_UPDATE_UTIL.t_array_of_varchar2;
1060: h_source_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
1061: h_source_dim_tables BSC_UPDATE_UTIL.t_array_of_varchar2;
1062: h_num_key_columns NUMBER;

Line 1059: h_key_dim_tables BSC_UPDATE_UTIL.t_array_of_varchar2;

1055: --bug#5943112
1056: h_max_partitions NUMBER;
1057: h_num_partitions NUMBER;
1058: h_key_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
1059: h_key_dim_tables BSC_UPDATE_UTIL.t_array_of_varchar2;
1060: h_source_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
1061: h_source_dim_tables BSC_UPDATE_UTIL.t_array_of_varchar2;
1062: h_num_key_columns NUMBER;
1063: h_key_columns_create BOOLEAN;

Line 1060: h_source_columns BSC_UPDATE_UTIL.t_array_of_varchar2;

1056: h_max_partitions NUMBER;
1057: h_num_partitions NUMBER;
1058: h_key_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
1059: h_key_dim_tables BSC_UPDATE_UTIL.t_array_of_varchar2;
1060: h_source_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
1061: h_source_dim_tables BSC_UPDATE_UTIL.t_array_of_varchar2;
1062: h_num_key_columns NUMBER;
1063: h_key_columns_create BOOLEAN;
1064: BEGIN

Line 1061: h_source_dim_tables BSC_UPDATE_UTIL.t_array_of_varchar2;

1057: h_num_partitions NUMBER;
1058: h_key_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
1059: h_key_dim_tables BSC_UPDATE_UTIL.t_array_of_varchar2;
1060: h_source_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
1061: h_source_dim_tables BSC_UPDATE_UTIL.t_array_of_varchar2;
1062: h_num_key_columns NUMBER;
1063: h_key_columns_create BOOLEAN;
1064: BEGIN
1065:

Line 1171: IF NOT BSC_UPDATE_UTIL.Get_Information_Key_Columns(h_table,

1167: FOR h_i IN 1..g_num_mig_tables LOOP
1168: h_table := g_mig_tables(h_i);
1169: h_num_key_columns := 0;
1170: h_key_columns_create:=false;
1171: IF NOT BSC_UPDATE_UTIL.Get_Information_Key_Columns(h_table,
1172: h_key_columns,
1173: h_key_dim_tables,
1174: h_source_columns,
1175: h_source_dim_tables,

Line 1241: IF BSC_UPDATE_UTIL.Get_Table_Generation_Type(h_table) <> -1 THEN

1237: END IF;
1238: END IF;
1239: ELSE
1240: -- BSC-MV architecture. Generation type = -1 means the table does not exists
1241: IF BSC_UPDATE_UTIL.Get_Table_Generation_Type(h_table) <> -1 THEN
1242: IF Is_Input_Table(h_table) THEN
1243: h_tbs_type := BSC_APPS.input_table_tbs_type;
1244:
1245: h_message := BSC_APPS.Replace_Token(h_base_message, 'TABLE', h_table);

Line 1450: IF BSC_UPDATE_UTIL.Get_Table_Generation_Type(h_table) <> -1 THEN

1446: END IF;
1447:
1448: ELSE
1449: -- BSC-MV architecture. Generation type = -1 means the table does not exists
1450: IF BSC_UPDATE_UTIL.Get_Table_Generation_Type(h_table) <> -1 THEN
1451: IF Is_Input_Table(h_table) THEN
1452: h_tbs_type := BSC_APPS.input_index_tbs_type;
1453:
1454: IF NOT Create_Table_Indexes(h_table, h_tbs_type) THEN

Line 2528: ERRBUF := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED');

2524: ' '||TO_CHAR(SYSDATE, c_fto_long_date_time), BSC_APPS.OUTPUT_FILE);
2525: BSC_APPS.Write_Line_Log(BSC_APPS.Get_Message('BSC_PROGRAM_COMPLETED'), BSC_APPS.OUTPUT_FILE);
2526:
2527:
2528: ERRBUF := BSC_UPDATE_UTIL.Get_Message('BSC_UPDATE_PROC_FAILED');
2529: RETCODE := 2; -- Request completed with errors
2530:
2531: -- LOCKING
2532: BSC_LOCKS_PUB.Remove_System_Lock;

Line 4540: IF BSC_UPDATE_UTIL.Get_Table_Generation_Type(h_table) <> -1 THEN

4536: commit;
4537: END IF;
4538: ELSE
4539: -- BSC-MV architecture. Generation type = -1 means the table does not exists
4540: IF BSC_UPDATE_UTIL.Get_Table_Generation_Type(h_table) <> -1 THEN
4541: -- ENH_B_TABLES_PERF: for base table we need to check if it has a projection table.
4542: -- in this case the base table is in the new architecture (partitions and projection table)
4543: -- We need to fix the batch column in th esame time we are inserting rows inthe target
4544: -- since the number of partititons may be different from the source.

Line 5383: h_base_tables BSC_UPDATE_UTIL.t_array_of_varchar2;

5379: --BSC-MV Note: New variables
5380: h_error_implement_mv VARCHAR2(2000) := NULL;
5381: e_error_implement_mv EXCEPTION;
5382: h_table VARCHAR2(30);
5383: h_base_tables BSC_UPDATE_UTIL.t_array_of_varchar2;
5384: h_num_base_tables NUMBER;
5385: h_base_message_v VARCHAR2(4000);
5386: h_message VARCHAR2(4000);
5387:

Line 5406: h_dim_tables BSC_UPDATE_UTIL.t_array_of_varchar2;

5402: h_dim_level_list dbms_sql.varchar2_table;
5403: h_kpi_list dbms_sql.varchar2_table;
5404: h_calendar_id NUMBER;
5405: h_level_table_name VARCHAR2(50);
5406: h_dim_tables BSC_UPDATE_UTIL.t_array_of_varchar2;
5407: h_num_dim_tables NUMBER;
5408:
5409: h_report_type VARCHAR2(2000);
5410:

Line 5840: IF BSC_UPDATE_UTIL.Get_Kpi_Impl_Type(g_mig_kpis(h_i)) = 2 THEN

5836: END IF;
5837: CLOSE c_indic_sum_level;
5838:
5839: --AW_INTEGRATION: see if the indicator is implemented in AW
5840: IF BSC_UPDATE_UTIL.Get_Kpi_Impl_Type(g_mig_kpis(h_i)) = 2 THEN
5841: --AW implementation
5842: h_message := 'Creating AW cubes: '||g_mig_kpis(h_i);
5843: BSC_APPS.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
5844: h_kpi_list.delete;

Line 5843: BSC_APPS.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);

5839: --AW_INTEGRATION: see if the indicator is implemented in AW
5840: IF BSC_UPDATE_UTIL.Get_Kpi_Impl_Type(g_mig_kpis(h_i)) = 2 THEN
5841: --AW implementation
5842: h_message := 'Creating AW cubes: '||g_mig_kpis(h_i);
5843: BSC_APPS.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
5844: h_kpi_list.delete;
5845: h_kpi_list(1) := g_mig_kpis(h_i);
5846: bsc_aw_adapter.implement_kpi_aw(h_kpi_list,
5847: 'DEBUG LOG,RECREATE KPI,SUMMARIZATION LEVEL='||h_kpi_sum_level);

Line 5851: BSC_APPS.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);

5847: 'DEBUG LOG,RECREATE KPI,SUMMARIZATION LEVEL='||h_kpi_sum_level);
5848: ELSE
5849: --MV implementation
5850: h_message := BSC_APPS.Replace_Token(h_base_message_v, 'VIEW', TO_CHAR(g_mig_kpis(h_i)));
5851: BSC_APPS.Write_Line_Log(h_message, BSC_UPDATE_LOG.OUTPUT);
5852:
5853: IF NOT BSC_BIA_WRAPPER.Implement_Bsc_MV(g_mig_kpis(h_i),
5854: h_kpi_sum_level,
5855: FALSE,

Line 5866: IF NOT BSC_UPDATE_DIM.Create_Dbi_Dim_Temp_Tables THEN

5862:
5863: -- Refresh BIS Dimension tables. The BIS dimension tables that are materialized in BSC
5864: -- will be refreshed.
5865: -- AW_INTEGRATION: The BIS dimensions used in AW indicators will be loaded to AW
5866: IF NOT BSC_UPDATE_DIM.Create_Dbi_Dim_Temp_Tables THEN
5867: RAISE e_unexpected_error;
5868: END IF;
5869: -- AW_INTEGRATION: Create temporary tables needed for AW dimension processing
5870: IF NOT BSC_UPDATE_DIM.Create_AW_Dim_Temp_Tables THEN

Line 5870: IF NOT BSC_UPDATE_DIM.Create_AW_Dim_Temp_Tables THEN

5866: IF NOT BSC_UPDATE_DIM.Create_Dbi_Dim_Temp_Tables THEN
5867: RAISE e_unexpected_error;
5868: END IF;
5869: -- AW_INTEGRATION: Create temporary tables needed for AW dimension processing
5870: IF NOT BSC_UPDATE_DIM.Create_AW_Dim_Temp_Tables THEN
5871: RAISE e_unexpected_error;
5872: END IF;
5873: -- Fix bug#4457823: Need to create the DBI dimension tables where we materialize
5874: IF NOT BSC_UPDATE_DIM.Create_Dbi_Dim_Tables(h_error_msg) THEN

Line 5874: IF NOT BSC_UPDATE_DIM.Create_Dbi_Dim_Tables(h_error_msg) THEN

5870: IF NOT BSC_UPDATE_DIM.Create_AW_Dim_Temp_Tables THEN
5871: RAISE e_unexpected_error;
5872: END IF;
5873: -- Fix bug#4457823: Need to create the DBI dimension tables where we materialize
5874: IF NOT BSC_UPDATE_DIM.Create_Dbi_Dim_Tables(h_error_msg) THEN
5875: RAISE e_creating_dbi_dim_tables;
5876: END IF;
5877:
5878: h_sql := 'select distinct short_name'||

Line 5885: IF NOT BSC_UPDATE_DIM.Refresh_Dbi_Dimension_Table(h_dbi_short_name) THEN

5881: OPEN h_cursor FOR h_sql USING 'PMF';
5882: LOOP
5883: FETCH h_cursor INTO h_dbi_short_name;
5884: EXIT WHEN h_cursor%NOTFOUND;
5885: IF NOT BSC_UPDATE_DIM.Refresh_Dbi_Dimension_Table(h_dbi_short_name) THEN
5886: -- fix bug#4682494: if for any reason the dbi dimension cannot be refreshed
5887: -- then we write this to the log file an continue
5888: g_warnings := TRUE;
5889: BSC_APPS.Write_Line_Log(BSC_APPS.Get_Message('BSC_WARNING')||' '||

Line 5891: BSC_UPDATE_LOG.OUTPUT);

5887: -- then we write this to the log file an continue
5888: g_warnings := TRUE;
5889: BSC_APPS.Write_Line_Log(BSC_APPS.Get_Message('BSC_WARNING')||' '||
5890: BSC_APPS.Get_Message('BSC_RETR_DIMTABLE_FAILED')||' '||h_dbi_short_name,
5891: BSC_UPDATE_LOG.OUTPUT);
5892: END IF;
5893: END LOOP;
5894: CLOSE h_cursor;
5895:

Line 5898: IF BSC_UPDATE_UTIL.Exists_AW_Kpi THEN

5894: CLOSE h_cursor;
5895:
5896:
5897: --AW_INTEGRATION: Load TYPE dimension into AW
5898: IF BSC_UPDATE_UTIL.Exists_AW_Kpi THEN
5899: h_dim_level_list.delete;
5900: h_dim_level_list(1) := 'TYPE';
5901: bsc_aw_load.load_dim(
5902: p_dim_level_list => h_dim_level_list,

Line 5925: IF NOT BSC_UPDATE.Load_Dims_Into_AW(h_dim_tables, h_num_dim_tables) THEN

5921: h_num_dim_tables := h_num_dim_tables + 1;
5922: h_dim_tables(h_num_dim_tables) := h_level_table_name;
5923: END LOOP;
5924: CLOSE h_cursor;
5925: IF NOT BSC_UPDATE.Load_Dims_Into_AW(h_dim_tables, h_num_dim_tables) THEN
5926: RAISE e_unexpected_error;
5927: END IF;
5928:
5929: --Fix bug#4873669: Populate bsc_reporting_calendar fro all the calendars

Line 5978: IF NOT BSC_UPDATE_UTIL.Is_Table_For_AW_Kpi(h_table) THEN

5974: LOOP
5975: FETCH h_cursor INTO h_table;
5976: EXIT WHEN h_cursor%NOTFOUND;
5977:
5978: IF NOT BSC_UPDATE_UTIL.Is_Table_For_AW_Kpi(h_table) THEN
5979: -- The base table is for a MV indicator
5980: h_num_base_tables := h_num_base_tables + 1;
5981: h_base_tables(h_num_base_tables) := h_table;
5982: END IF;

Line 5987: IF NOT BSC_UPDATE.Refresh_System_MVs_Mig(h_base_tables, h_num_base_tables) THEN

5983: END LOOP;
5984: CLOSE h_cursor;
5985:
5986: -- Refresh all MVs in the system affected by base tables
5987: IF NOT BSC_UPDATE.Refresh_System_MVs_Mig(h_base_tables, h_num_base_tables) THEN
5988: RAISE e_unexpected_error;
5989: END IF;
5990:
5991: --AW_INTEGRATION: Now refresh the AW indicators

Line 6083: BSC_MESSAGE.Add(x_message => 'Error in BSC_UPDATE_DIM.Create_Dbi_Dim_Tables: '||h_error_msg,

6079: -- Delete records in the temporal table used for big 'in' conditions
6080: BSC_APPS.Init_Big_In_Cond_Table;
6081:
6082: BSC_MESSAGE.flush;
6083: BSC_MESSAGE.Add(x_message => 'Error in BSC_UPDATE_DIM.Create_Dbi_Dim_Tables: '||h_error_msg,
6084: x_source => 'BSC_MIGRATION.Migrate_System',
6085: x_mode => 'I');
6086: COMMIT;
6087:

Line 7156: BSC_UPDATE_LOG.OUTPUT);

7152: IF g_num_no_mig_kpis > 0 THEN
7153: BSC_APPS.Write_Line_Log(' ', BSC_APPS.OUTPUT_FILE);
7154: BSC_APPS.Write_Line_Log(RPAD(BSC_APPS.Get_Lookup_Value('BSC_UI_BACKEND', 'KPI_CODE'), 15)||
7155: RPAD(BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'KPI_NAME'), 50),
7156: BSC_UPDATE_LOG.OUTPUT);
7157:
7158: h_condition := BSC_APPS.Get_New_Big_In_Cond_Number(1, 'indicator');
7159: FOR h_i IN 1 .. g_num_no_mig_kpis LOOP
7160: BSC_APPS.Add_Value_Big_In_Cond(1, g_no_mig_kpis(h_i));

Line 7172: BSC_UPDATE_LOG.OUTPUT);

7168: FETCH h_cursor INTO h_indicator, h_name;
7169: EXIT WHEN h_cursor%NOTFOUND;
7170:
7171: BSC_APPS.Write_Line_Log(RPAD(h_indicator, 15)||h_name,
7172: BSC_UPDATE_LOG.OUTPUT);
7173:
7174: END LOOP;
7175: CLOSE h_cursor;
7176: END IF;

Line 7183: BSC_UPDATE_LOG.OUTPUT);

7179: BSC_APPS.Write_Line_Log(' ', BSC_APPS.OUTPUT_FILE);
7180: BSC_APPS.Write_Line_Log(RPAD(BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'EDW_MEASURE'), 40)||
7181: RPAD(BSC_APPS.Get_Lookup_Value('BSC_UI_SETUP', 'SHORT_NAME'), 35)||
7182: RPAD(BSC_APPS.Get_Lookup_Value('BSC_UI_SETUP', 'APPLICATION_NAME'), 40),
7183: BSC_UPDATE_LOG.OUTPUT);
7184:
7185: h_condition := BSC_APPS.Get_New_Big_In_Cond_Varchar2(1, 'i.short_name');
7186: FOR h_i IN 1 .. g_num_invalid_pmf_measures LOOP
7187: BSC_APPS.Add_Value_Big_In_Cond(1, g_invalid_pmf_measures(h_i));

Line 7208: BSC_UPDATE_LOG.OUTPUT);

7204:
7205: BSC_APPS.Write_Line_Log(RPAD(h_name, 40)||
7206: RPAD(h_short_name, 35)||
7207: h_application_name,
7208: BSC_UPDATE_LOG.OUTPUT);
7209: END LOOP;
7210: CLOSE h_cursor;
7211: END IF;
7212:

Line 7218: BSC_UPDATE_LOG.OUTPUT);

7214: BSC_APPS.Write_Line_Log(' ', BSC_APPS.OUTPUT_FILE);
7215: BSC_APPS.Write_Line_Log(RPAD(BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'EDW_DIMENSION'), 40)||
7216: RPAD(BSC_APPS.Get_Lookup_Value('BSC_UI_SETUP', 'SHORT_NAME'), 35)||
7217: RPAD(BSC_APPS.Get_Lookup_Value('BSC_UI_SETUP', 'APPLICATION_NAME'), 40),
7218: BSC_UPDATE_LOG.OUTPUT);
7219:
7220: h_condition := BSC_APPS.Get_New_Big_In_Cond_Varchar2(1, 'd.short_name');
7221: FOR h_i IN 1 .. g_num_invalid_pmf_dimensions LOOP
7222: BSC_APPS.Add_Value_Big_In_Cond(1, g_invalid_pmf_dimensions(h_i));

Line 7240: BSC_UPDATE_LOG.OUTPUT);

7236:
7237: BSC_APPS.Write_Line_Log(RPAD(h_name, 40)||
7238: RPAD(h_short_name, 35)||
7239: h_application_name,
7240: BSC_UPDATE_LOG.OUTPUT);
7241: END LOOP;
7242: CLOSE h_cursor;
7243: END IF;
7244:

Line 7250: BSC_UPDATE_LOG.OUTPUT);

7246: BSC_APPS.Write_Line_Log(' ', BSC_APPS.OUTPUT_FILE);
7247: BSC_APPS.Write_Line_Log(RPAD(BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DIMENSION_OBJECT'), 40)||
7248: RPAD(BSC_APPS.Get_Lookup_Value('BSC_UI_SETUP', 'SHORT_NAME'), 35)||
7249: RPAD(BSC_APPS.Get_Lookup_Value('BSC_UI_SETUP', 'APPLICATION_NAME'), 40),
7250: BSC_UPDATE_LOG.OUTPUT);
7251:
7252: h_condition := BSC_APPS.Get_New_Big_In_Cond_Varchar2(1, 'l.short_name');
7253: FOR h_i IN 1 .. g_num_invalid_pmf_dim_levels LOOP
7254: BSC_APPS.Add_Value_Big_In_Cond(1, g_invalid_pmf_dim_levels(h_i));

Line 7272: BSC_UPDATE_LOG.OUTPUT);

7268:
7269: BSC_APPS.Write_Line_Log(RPAD(h_name, 40)||
7270: RPAD(h_short_name, 35)||
7271: h_application_name,
7272: BSC_UPDATE_LOG.OUTPUT);
7273: END LOOP;
7274: CLOSE h_cursor;
7275: END IF;
7276: END IF;

Line 8123: h_key_columns BSC_UPDATE_UTIL.t_array_of_varchar2;

8119: h_table VARCHAR2(30);
8120: h_num_partitions NUMBER;
8121: h_max_partitions NUMBER;
8122:
8123: h_key_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
8124: h_key_dim_tables BSC_UPDATE_UTIL.t_array_of_varchar2;
8125: h_source_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
8126: h_source_dim_tables BSC_UPDATE_UTIL.t_array_of_varchar2;
8127: h_num_key_columns NUMBER;

Line 8124: h_key_dim_tables BSC_UPDATE_UTIL.t_array_of_varchar2;

8120: h_num_partitions NUMBER;
8121: h_max_partitions NUMBER;
8122:
8123: h_key_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
8124: h_key_dim_tables BSC_UPDATE_UTIL.t_array_of_varchar2;
8125: h_source_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
8126: h_source_dim_tables BSC_UPDATE_UTIL.t_array_of_varchar2;
8127: h_num_key_columns NUMBER;
8128:

Line 8125: h_source_columns BSC_UPDATE_UTIL.t_array_of_varchar2;

8121: h_max_partitions NUMBER;
8122:
8123: h_key_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
8124: h_key_dim_tables BSC_UPDATE_UTIL.t_array_of_varchar2;
8125: h_source_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
8126: h_source_dim_tables BSC_UPDATE_UTIL.t_array_of_varchar2;
8127: h_num_key_columns NUMBER;
8128:
8129: h_i NUMBER;

Line 8126: h_source_dim_tables BSC_UPDATE_UTIL.t_array_of_varchar2;

8122:
8123: h_key_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
8124: h_key_dim_tables BSC_UPDATE_UTIL.t_array_of_varchar2;
8125: h_source_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
8126: h_source_dim_tables BSC_UPDATE_UTIL.t_array_of_varchar2;
8127: h_num_key_columns NUMBER;
8128:
8129: h_i NUMBER;
8130: h_j NUMBER;

Line 8134: h_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;

8130: h_j NUMBER;
8131: h_level_table_name VARCHAR2(100);
8132: h_level_short_name VARCHAR2(300);
8133: h_level_source VARCHAR2(100);
8134: h_dbi_dim_data BSC_UPDATE_DIM.t_dbi_dim_data;
8135:
8136: CURSOR c_columns(p_table varchar2) IS
8137: SELECT column_name
8138: FROM all_tab_columns

Line 8158: IF NOT BSC_UPDATE_UTIL.Get_Information_Key_Columns(x_base_table,

8154: h_batch_column := UPPER(BSC_DBGEN_STD_METADATA.BSC_BATCH_COLUMN_NAME);
8155:
8156: IF h_num_partitions <> h_max_partitions THEN
8157: h_num_key_columns := 0;
8158: IF NOT BSC_UPDATE_UTIL.Get_Information_Key_Columns(x_base_table,
8159: h_key_columns,
8160: h_key_dim_tables,
8161: h_source_columns,
8162: h_source_dim_tables,

Line 9563: l_arr_columns BSC_UPDATE_UTIL.t_array_of_varchar2;

9559: l_Table_Number NUMBER;
9560: l_kpi_metadata_tables BSC_DESIGNER_PVT.t_kpi_metadata_tables;
9561: l_sql VARCHAR2(32700);
9562: l_table_name all_tables.table_name%TYPE;
9563: l_arr_columns BSC_UPDATE_UTIL.t_array_of_varchar2;
9564: l_num_columns NUMBER;
9565: l_colum VARCHAR2(100);
9566: l_key_name VARCHAR2(30);
9567: l_error_msg VARCHAR2(4000);

Line 9728: BSC_UPDATE_UTIL.Execute_Immediate(l_sql);

9724: END IF;
9725: END LOOP;
9726: l_sql:= l_sql || ' FROM ' || l_table_name||'@'||g_db_link;
9727: l_sql:= l_sql || ' WHERE ' || l_condition;
9728: BSC_UPDATE_UTIL.Execute_Immediate(l_sql);
9729: END IF;
9730:
9731: IF l_kpi_metadata_tables(h_i).mls_table IS NOT NULL AND
9732: l_kpi_metadata_tables(h_i).mls_table = bsc_utility.YES THEN