APPS.BSC_UPDATE_DIM dependencies on AD_DDL

Line 125: BSC_APPS.Do_DDL(l_sql, AD_DDL.CREATE_TABLE, l_table_name);

121: ' '||BSC_APPS.bsc_storage_clause;
122: if bsc_im_utils.g_debug then
123: write_to_log_file_n(l_sql);
124: end if;
125: BSC_APPS.Do_DDL(l_sql, AD_DDL.CREATE_TABLE, l_table_name);
126: END IF;
127:
128: -- Create the mv log
129: SELECT COUNT(1) INTO l_count

Line 147: BSC_APPS.Do_DDL(l_sql, AD_DDL.ALTER_TABLE, l_table_name);

143: ' ADD CONSTRAINT '||l_constraint_name||' PRIMARY KEY(USER_CODE) RELY ENABLE NOVALIDATE';
144: if bsc_im_utils.g_debug then
145: write_to_log_file_n(l_sql);
146: end if;
147: BSC_APPS.Do_DDL(l_sql, AD_DDL.ALTER_TABLE, l_table_name);
148: END IF;
149:
150: -- Create mv log
151: l_sql := 'CREATE MATERIALIZED VIEW LOG ON '||l_table_owner||'.'||l_table_name||

Line 179: BSC_APPS.Do_DDL(l_sql, AD_DDL.CREATE_INDEX, l_index_name);

175: if bsc_im_utils.g_debug then
176: write_to_log_file_n(l_sql);
177: end if;
178: begin
179: BSC_APPS.Do_DDL(l_sql, AD_DDL.CREATE_INDEX, l_index_name);
180: exception
181: when l_col_already_indexed then
182: null;
183: end;

Line 204: BSC_APPS.Do_DDL(l_sql, AD_DDL.CREATE_TABLE, l_table_name);

200: ' '||BSC_APPS.bsc_storage_clause;
201: if bsc_im_utils.g_debug then
202: write_to_log_file_n(l_sql);
203: end if;
204: BSC_APPS.Do_DDL(l_sql, AD_DDL.CREATE_TABLE, l_table_name);
205: END IF;
206: -- Create the Index
207: l_index_name := substr(l_table_name,1,29)||'N';
208: IF NOT BSC_APPS.Index_Exists(l_index_name) THEN

Line 217: BSC_APPS.Do_DDL(l_sql, AD_DDL.CREATE_INDEX, l_index_name);

213: if bsc_im_utils.g_debug then
214: write_to_log_file_n(l_sql);
215: end if;
216: begin
217: BSC_APPS.Do_DDL(l_sql, AD_DDL.CREATE_INDEX, l_index_name);
218: exception
219: when l_col_already_indexed then
220: null;
221: end;

Line 4609: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_TABLE, 'BSC_TMP_DIMENSION');

4605: h_sql := 'CREATE TABLE BSC_TMP_DIMENSION ('||
4606: 'CODE NUMBER'||h_lst_relation_cols_desc||
4607: ') TABLESPACE '||BSC_APPS.Get_Tablespace_Name(BSC_APPS.other_table_tbs_type)||
4608: ' '||BSC_APPS.bsc_storage_clause;
4609: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_TABLE, 'BSC_TMP_DIMENSION');
4610:
4611: -- Insert records
4612: h_sql := 'INSERT INTO BSC_TMP_DIMENSION (CODE'||h_lst_relation_cols||')'||
4613: ' SELECT CODE'||h_lst_relation_cols||