APPS.BSC_MO_DB_PKG dependencies on BSC_DBGEN_UTILS

Line 1104: l_origin_tables := BSC_DBGEN_UTILS.get_source_table_names(p_table.name);

1100: IF (p_table.data.count=0) THEN
1101: bsc_mo_helper_pkg.writeTmp('Completed Alter Tables zero data count= ', FND_LOG.LEVEL_STATEMENT, true);
1102: return;
1103: END IF;
1104: l_origin_tables := BSC_DBGEN_UTILS.get_source_table_names(p_table.name);
1105: l_origin_tables(l_origin_tables.count) := p_table.name;
1106: FOR i IN p_table.data.first..p_table.data.last LOOP
1107: IF p_table.data(i).changeType='NEW' THEN -- new column, insert into db_tables_cols
1108: --alter all tables in l_origin_tables as they need this new column, eg, T, B and I tables if p_table is a T table

Line 1111: l_table_type := BSC_DBGEN_UTILS.get_table_type(l_origin_tables(j));

1107: IF p_table.data(i).changeType='NEW' THEN -- new column, insert into db_tables_cols
1108: --alter all tables in l_origin_tables as they need this new column, eg, T, B and I tables if p_table is a T table
1109: bsc_mo_helper_pkg.writeTmp('Measure '||p_table.data(i).fieldName||' needs to be added ', FND_LOG.LEVEL_STATEMENT, false);
1110: FOR j in l_origin_tables.first..l_origin_tables.last LOOP
1111: l_table_type := BSC_DBGEN_UTILS.get_table_type(l_origin_tables(j));
1112: IF BSC_METADATA_OPTIMIZER_PKG.g_BSC_mv AND l_table_type='T' THEN -- T tables do not exist in MV arch.
1113: null;
1114: ELSIF Not bsc_mo_helper_pkg.table_column_exists(l_origin_tables(j), p_table.data(i).fieldName) THEN
1115: l_stmt := 'ALTER TABLE ' || l_origin_tables(j) || ' ADD '||p_table.data(i).fieldName||' NUMBER';