DBA Data[Home] [Help]

APPS.BSC_MO_LOADER_CONFIG_PKG dependencies on AD_DDL

Line 324: BSC_MO_HELPER_PKG.do_ddl(l_stmt, ad_ddl.create_view, uv_name);

320: --We have to recreate the union view because the materializaed
321: --view is invalid until loader refresh it
322: uv_name := table_name || BSC_METADATA_OPTIMIZER_PKG.EDW_UNION_VIEW_EXT;
323: l_stmt := 'CREATE OR REPLACE VIEW '|| uv_name ||' AS SELECT * FROM '|| table_name;
324: BSC_MO_HELPER_PKG.do_ddl(l_stmt, ad_ddl.create_view, uv_name);
325:
326: END Loop;
327: CLOSE C1;
328: IF BSC_METADATA_OPTIMIZER_PKG.g_log THEN

Line 1431: BSC_MO_HELPER_PKG.Do_DDL( ddl_sql , ad_ddl.alter_table, l_table_name);

1427: If Not BSC_MO_HELPER_PKG.table_column_exists(l_table_name, l_measure.fieldName) Then
1428: --Add the internal column
1429: ddl_sql := 'ALTER TABLE ' || l_table_name ||' ADD ' || l_measure.fieldName ||' NUMBER ';
1430: begin
1431: BSC_MO_HELPER_PKG.Do_DDL( ddl_sql , ad_ddl.alter_table, l_table_name);
1432: newColumnFlag := True;
1433: exception when others then
1434: BSC_MO_HELPER_PKG.writeTmp('Error while executing : '||ddl_sql||', Error is '||sqlerrm, FND_LOG.LEVEL_UNEXPECTED, true);
1435: raise;