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_UTIL

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 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 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 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 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