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_MO_HELPER_PKG dependencies on AD_DDL

Line 128: do_ddl(l_stmt, ad_ddl.create_table, TableName);

124: from bsc_db_tables_rels
125: where table_name like ''BSC_S%''
126: and (source_table_name like ''BSC_B%'' or source_table_name like ''BSC_T%'' )';
127:
128: do_ddl(l_stmt, ad_ddl.create_table, TableName);
129: bsc_metadata_optimizer_pkg.logProgress('INIT', 'Created '||TableName);
130: writeTmp('Created '||TableName, FND_LOG.LEVEL_STATEMENT, false);
131: l_stmt := 'create unique index '||TableName||'_u1 on '||TableName||'(indicator, dim_set_id, table_name) TABLESPACE '||BSC_METADATA_OPTIMIZER_PKG.gSummaryIndexTbsName;
132: do_ddl(l_stmt, ad_ddl.create_index, TableName||'_U1');

Line 132: do_ddl(l_stmt, ad_ddl.create_index, TableName||'_U1');

128: do_ddl(l_stmt, ad_ddl.create_table, TableName);
129: bsc_metadata_optimizer_pkg.logProgress('INIT', 'Created '||TableName);
130: writeTmp('Created '||TableName, FND_LOG.LEVEL_STATEMENT, false);
131: l_stmt := 'create unique index '||TableName||'_u1 on '||TableName||'(indicator, dim_set_id, table_name) TABLESPACE '||BSC_METADATA_OPTIMIZER_PKG.gSummaryIndexTbsName;
132: do_ddl(l_stmt, ad_ddl.create_index, TableName||'_U1');
133: bsc_metadata_optimizer_pkg.logProgress('INIT', 'Created '||TableName||'_U1');
134: writeTmp('Created index '||TableName||'_u1', FND_LOG.LEVEL_STATEMENT, false);
135: l_stmt := 'create index '||TableName||'_n1 on '||TableName||'(table_name) TABLESPACE '||BSC_METADATA_OPTIMIZER_PKG.gSummaryIndexTbsName;
136: do_ddl(l_stmt, ad_ddl.create_index, TableName||'_N1');

Line 136: do_ddl(l_stmt, ad_ddl.create_index, TableName||'_N1');

132: do_ddl(l_stmt, ad_ddl.create_index, TableName||'_U1');
133: bsc_metadata_optimizer_pkg.logProgress('INIT', 'Created '||TableName||'_U1');
134: writeTmp('Created index '||TableName||'_u1', FND_LOG.LEVEL_STATEMENT, false);
135: l_stmt := 'create index '||TableName||'_n1 on '||TableName||'(table_name) TABLESPACE '||BSC_METADATA_OPTIMIZER_PKG.gSummaryIndexTbsName;
136: do_ddl(l_stmt, ad_ddl.create_index, TableName||'_N1');
137: writeTmp('Created index '||TableName||'_n1', FND_LOG.LEVEL_STATEMENT, false);
138: bsc_metadata_optimizer_pkg.logProgress('INIT', 'Created '||TableName||'_N1');
139: bsc_metadata_optimizer_pkg.logProgress('INIT', 'Completed CreateKPIDataTableTmp');
140:

Line 3778: Do_DDL(l_stmt, ad_ddl.create_table, l_table_name);

3774: IF BSC_METADATA_OPTIMIZER_PKG.gSummaryTableTbsName is NULL THEN
3775: InitTablespaceNames;
3776: END IF;
3777: l_stmt := l_stmt ||' TABLESPACE '|| BSC_METADATA_OPTIMIZER_PKG.gSummaryTableTbsName||' '|| BSC_METADATA_OPTIMIZER_PKG.gStorageClause;
3778: Do_DDL(l_stmt, ad_ddl.create_table, l_table_name);
3779: OPEN cPeriods;
3780: LOOP
3781: FETCH cPeriods INTO cPeriodRow;
3782: EXIT WHEN cPeriods%NOTFOUND;

Line 4801: Do_DDL(l_stmt, ad_ddl.create_table, CopyTableName);

4797: ELSE
4798: l_stmt := l_stmt ||TbsName;
4799: END IF;
4800: l_stmt := l_stmt||' AS SELECT * FROM '||TableName||' '||p_where_clause;
4801: Do_DDL(l_stmt, ad_ddl.create_table, CopyTableName);
4802: l_stmt := 'select count(1) from '||CopyTableName;
4803: OPEN cv FOR l_stmt;
4804: FETCH cv INTO l_Val;
4805: CLOSE cv;

Line 4914: Do_DDL(l_stmt, ad_ddl.create_index, newIndexName);

4910: ELSE
4911: l_stmt := l_stmt||' TABLESPACE '|| TbsName;
4912: END IF;
4913: l_stmt := l_stmt|| ' ' || BSC_METADATA_OPTIMIZER_PKG.gStorageClause;
4914: Do_DDL(l_stmt, ad_ddl.create_index, newIndexName);
4915: End If;
4916:
4917: END LOOP;
4918: Close cIndex;

Line 5110: Drop a given table using Ad_ddl.do_ddl, ignore errors

5106: /****************************************************************************
5107: DropTable
5108:
5109: DESCRIPTION:
5110: Drop a given table using Ad_ddl.do_ddl, ignore errors
5111: ***************************************************************************/
5112:
5113: PROCEDURE DropTable(p_table_name in VARCHAR2) IS
5114: BEGIN

Line 5125: do_ddl('DROP TABLE '||p_table_name|| ' CASCADE CONSTRAINTS', ad_ddl.drop_table, p_table_name);

5121:
5122: END IF;
5123:
5124: BEGIN
5125: do_ddl('DROP TABLE '||p_table_name|| ' CASCADE CONSTRAINTS', ad_ddl.drop_table, p_table_name);
5126: EXCEPTION WHEN OTHERS THEN
5127: null;
5128: END;
5129: END;

Line 5135: Drop a given view using Ad_ddl.do_ddl, ignore errors

5131: /****************************************************************************
5132: DropTable
5133:
5134: DESCRIPTION:
5135: Drop a given view using Ad_ddl.do_ddl, ignore errors
5136: ***************************************************************************/
5137:
5138: PROCEDURE DropView(p_view_name in VARCHAR2) IS
5139: BEGIN

Line 5141: do_ddl('DROP VIEW '||p_view_name, ad_ddl.drop_view, p_view_name);

5137:
5138: PROCEDURE DropView(p_view_name in VARCHAR2) IS
5139: BEGIN
5140:
5141: do_ddl('DROP VIEW '||p_view_name, ad_ddl.drop_view, p_view_name);
5142: EXCEPTION WHEN OTHERS THEN
5143: null;
5144:
5145: END;

Line 5151: Wrapper for ad_ddl.do_ddl

5147: /****************************************************************************
5148: Do_DDL
5149:
5150: DESCRIPTION:
5151: Wrapper for ad_ddl.do_ddl
5152: ***************************************************************************/
5153:
5154: PROCEDURE Do_DDL(
5155: x_statement IN VARCHAR2,

Line 6050: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.alter_table, p_Table_name );

6046: l_stmt := 'alter table '||p_Table_name ||' drop column '||p_column_name;
6047: --writeTmp(l_stmt);
6048: IF (table_column_exists(p_table_name, p_column_name)) THEN
6049: writeTmp(l_stmt);
6050: BSC_MO_HELPER_PKG.Do_DDL(l_stmt, ad_ddl.alter_table, p_Table_name );
6051: ELSE
6052: writeTmp(p_table_name||'.'||p_column_name||' doesnt exist, so not calling alter table as this was possibly dropped earlier');
6053: END IF;
6054: DELETE bsc_db_tables_cols