APPS.BSC_MIGRATION dependencies on BSC_BIA_WRAPPER

Line 1549: BSC_BIA_WRAPPER.Analyze_Table(h_table);

1545: LOOP
1546: FETCH h_cursor INTO h_table;
1547: EXIT WHEN h_cursor%NOTFOUND;
1548:
1549: BSC_BIA_WRAPPER.Analyze_Table(h_table);
1550: commit;
1551: END LOOP;
1552: CLOSE h_cursor;
1553:

Line 1559: BSC_BIA_WRAPPER.Analyze_Table(h_table);

1555: FOR h_i IN 1..g_num_mig_tables LOOP
1556: h_table := g_mig_tables(h_i);
1557:
1558: IF Is_Base_Table(h_table) THEN
1559: BSC_BIA_WRAPPER.Analyze_Table(h_table);
1560: END IF;
1561: END LOOP;
1562:
1563: RETURN TRUE;

Line 2073: IF NOT BSC_BIA_WRAPPER.Drop_Summary_MV(h_mv_name, h_error_message_drop_mv) THEN

2069:
2070: h_message := BSC_APPS.Replace_Token(h_base_message, 'VIEW', h_mv_name);
2071: BSC_APPS.Write_Line_Log(h_message, BSC_APPS.OUTPUT_FILE);
2072:
2073: IF NOT BSC_BIA_WRAPPER.Drop_Summary_MV(h_mv_name, h_error_message_drop_mv) THEN
2074: RAISE e_error_drop_mv;
2075: END IF;
2076: END LOOP;
2077: CLOSE h_cursor;

Line 2080: h_sql := 'SELECT DISTINCT BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(SOURCE_TABLE_NAME) MV_NAME'||

2076: END LOOP;
2077: CLOSE h_cursor;
2078:
2079: -- BSC-MV Note: Also Drop all MV used for targets
2080: h_sql := 'SELECT DISTINCT BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(SOURCE_TABLE_NAME) MV_NAME'||
2081: ' FROM BSC_DB_TABLES_RELS'||
2082: ' WHERE TABLE_NAME IN ('||
2083: ' SELECT TABLE_NAME'||
2084: ' FROM BSC_KPI_DATA_TABLES'||

Line 2096: IF NOT BSC_BIA_WRAPPER.Drop_Summary_MV(h_mv_name, h_error_message_drop_mv) THEN

2092:
2093: h_message := BSC_APPS.Replace_Token(h_base_message, 'VIEW', h_mv_name);
2094: BSC_APPS.Write_Line_Log(h_message, BSC_APPS.OUTPUT_FILE);
2095:
2096: IF NOT BSC_BIA_WRAPPER.Drop_Summary_MV(h_mv_name, h_error_message_drop_mv) THEN
2097: RAISE e_error_drop_mv;
2098: END IF;
2099:
2100: END LOOP;

Line 2138: BSC_MESSAGE.Add (x_message => 'BSC_BIA_WRAPPER.Drop_Summary_MV: '||h_mv_name||' '||h_error_message_drop_mv,

2134: x_source => 'BSC_MIGRATION.Drop_Dynamic_Objects');
2135: RETURN FALSE;
2136:
2137: WHEN e_error_drop_mv THEN
2138: BSC_MESSAGE.Add (x_message => 'BSC_BIA_WRAPPER.Drop_Summary_MV: '||h_mv_name||' '||h_error_message_drop_mv,
2139: x_source => 'BSC_MIGRATION.Drop_Dynamic_Objects');
2140: RETURN FALSE;
2141:
2142: WHEN OTHERS THEN

Line 5853: IF NOT BSC_BIA_WRAPPER.Implement_Bsc_MV(g_mig_kpis(h_i),

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,
5856: h_error_implement_mv) THEN
5857: RAISE e_error_implement_mv;

Line 5937: IF NOT BSC_BIA_WRAPPER.Load_Reporting_Calendar(h_calendar_id, h_error_msg) THEN

5933: LOOP
5934: FETCH h_cursor INTO h_calendar_id;
5935: EXIT WHEN h_cursor%NOTFOUND;
5936:
5937: IF NOT BSC_BIA_WRAPPER.Load_Reporting_Calendar(h_calendar_id, h_error_msg) THEN
5938: RAISE e_load_rpt_cal;
5939: END IF;
5940: END LOOP;
5941: CLOSE h_cursor;

Line 6063: BSC_MESSAGE.Add(x_message => 'Error in BSC_BIA_WRAPPER.Load_Reporting_Calendar: '||h_calendar_id||' '||h_error_msg,

6059: -- Delete records in the temporal table used for big 'in' conditions
6060: BSC_APPS.Init_Big_In_Cond_Table;
6061:
6062: BSC_MESSAGE.flush;
6063: BSC_MESSAGE.Add(x_message => 'Error in BSC_BIA_WRAPPER.Load_Reporting_Calendar: '||h_calendar_id||' '||h_error_msg,
6064: x_source => 'BSC_MIGRATION.Migrate_System',
6065: x_mode => 'I');
6066: COMMIT;
6067:

Line 6122: BSC_MESSAGE.Add(x_message => 'BSC_BIA_WRAPPER.Implement_Bsc_MV '||g_mig_kpis(h_i)||' '||h_error_implement_mv,

6118: -- Delete records in the temporal table used for big 'in' conditions
6119: BSC_APPS.Init_Big_In_Cond_Table;
6120:
6121: BSC_MESSAGE.flush;
6122: BSC_MESSAGE.Add(x_message => 'BSC_BIA_WRAPPER.Implement_Bsc_MV '||g_mig_kpis(h_i)||' '||h_error_implement_mv,
6123: x_source => 'BSC_MIGRATION.Migrate_System',
6124: x_mode => 'I');
6125: COMMIT;
6126: