APPS.BSC_MIGRATION dependencies on BSC_INTEGRATION_MV_GEN

Line 1929: BSC_INTEGRATION_MV_GEN.Drop_Materialized_View(h_table, 'Y');

1925: IF BSC_APPS.Object_Exists(h_table) THEN
1926: h_message := BSC_APPS.Replace_Token(h_base_message, 'TABLE', h_table);
1927: BSC_APPS.Write_Line_Log(h_message, BSC_APPS.OUTPUT_FILE);
1928:
1929: BSC_INTEGRATION_MV_GEN.Drop_Materialized_View(h_table, 'Y');
1930: IF BSC_APPS.CheckError('BSC_INTEGRATION_MV_GEN.Drop_Materialized_View') THEN
1931: RAISE e_unexpected_error;
1932: END IF;
1933:

Line 1930: IF BSC_APPS.CheckError('BSC_INTEGRATION_MV_GEN.Drop_Materialized_View') THEN

1926: h_message := BSC_APPS.Replace_Token(h_base_message, 'TABLE', h_table);
1927: BSC_APPS.Write_Line_Log(h_message, BSC_APPS.OUTPUT_FILE);
1928:
1929: BSC_INTEGRATION_MV_GEN.Drop_Materialized_View(h_table, 'Y');
1930: IF BSC_APPS.CheckError('BSC_INTEGRATION_MV_GEN.Drop_Materialized_View') THEN
1931: RAISE e_unexpected_error;
1932: END IF;
1933:
1934: END IF;

Line 2008: -- BSC_INTEGRATION_MV_GEN.Drop_Materialized_View(h_table, 'N');

2004: -- -- neither if the table is from EDW. So I check if there is a materialized
2005: -- -- view corresponding to this table. In that case I drop the materialize view.
2006: -- h_mv := h_table||'_MV_V';
2007: -- IF BSC_APPS.Object_Exists(h_mv) THEN
2008: -- BSC_INTEGRATION_MV_GEN.Drop_Materialized_View(h_table, 'N');
2009: -- IF BSC_APPS.CheckError('BSC_INTEGRATION_MV_GEN.Drop_Materialized_View') THEN
2010: -- RAISE e_unexpected_error;
2011: -- END IF;
2012: -- END IF;

Line 2009: -- IF BSC_APPS.CheckError('BSC_INTEGRATION_MV_GEN.Drop_Materialized_View') THEN

2005: -- -- view corresponding to this table. In that case I drop the materialize view.
2006: -- h_mv := h_table||'_MV_V';
2007: -- IF BSC_APPS.Object_Exists(h_mv) THEN
2008: -- BSC_INTEGRATION_MV_GEN.Drop_Materialized_View(h_table, 'N');
2009: -- IF BSC_APPS.CheckError('BSC_INTEGRATION_MV_GEN.Drop_Materialized_View') THEN
2010: -- RAISE e_unexpected_error;
2011: -- END IF;
2012: -- END IF;
2013: --