APPS.BSC_UPDATE_UTIL dependencies on AD_DDL

Line 192: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_INDEX, x_index_name);

188: h_sql := 'CREATE UNIQUE INDEX '||x_index_name||
189: ' ON '||x_table_name||' ('||x_lst_columns||
190: ') TABLESPACE '||BSC_APPS.Get_Tablespace_Name(x_tbs_type)||
191: ' '||BSC_APPS.bsc_storage_clause;
192: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_INDEX, x_index_name);
193: END IF;
194:
195: RETURN TRUE;
196:

Line 298: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, x_table_name);

294: END IF;
295:
296: IF h_drop_it THEN
297: h_sql := 'DROP TABLE '||x_table_name;
298: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, x_table_name);
299: END IF;
300:
301: IF h_create_it THEN
302: h_lst_cols_desc := NULL;

Line 325: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_TABLE, x_table_name);

321: END LOOP;
322:
323: h_sql := 'CREATE GLOBAL TEMPORARY TABLE '||x_table_name||' ('||h_lst_cols_desc||
324: ') ON COMMIT PRESERVE ROWS';
325: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_TABLE, x_table_name);
326:
327: -- Create index
328: IF h_lst_cols_index IS NOT NULL THEN
329: h_index_name := x_table_name||'_N1';

Line 334: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_INDEX, h_index_name);

330: loop --modifed code for 4099338
331: begin
332: h_sql := 'CREATE INDEX '||h_index_name||
333: ' ON '||x_table_name||' ('||h_lst_cols_index||')';
334: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_INDEX, h_index_name);
335: exit;
336: exception
337: when others then
338: if h_lst_cols_index is null then

Line 373: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_INDEX, h_index_name);

369:
370: IF h_count > 0 THEN
371: -- Index exist but it is not needed
372: h_sql := 'DROP INDEX '||h_index_name;
373: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_INDEX, h_index_name);
374: END IF;
375: END IF;
376: END IF;
377:

Line 469: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, x_table_name);

465: END IF;
466:
467: IF h_drop_it THEN
468: h_sql := 'DROP TABLE '||x_table_name;
469: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, x_table_name);
470: END IF;
471:
472: IF h_create_it THEN
473: h_lst_cols_desc := NULL;

Line 497: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_TABLE, x_table_name);

493:
494: h_sql := 'CREATE TABLE '||x_table_name||' ('||h_lst_cols_desc||')'||
495: ' TABLESPACE '||x_tablespace||
496: ' '||BSC_APPS.bsc_storage_clause;
497: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_TABLE, x_table_name);
498:
499: -- Create index
500: IF h_lst_cols_index IS NOT NULL THEN
501: h_index_name := x_table_name||'_N1';

Line 506: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_INDEX, h_index_name);

502: h_sql := 'CREATE INDEX '||h_index_name||
503: ' ON '||x_table_name||' ('||h_lst_cols_index||')'||
504: ' TABLESPACE '||x_idx_tablespace||
505: ' '||BSC_APPS.bsc_storage_clause;
506: BSC_APPS.Do_DDL(h_sql, AD_DDL.CREATE_INDEX, h_index_name);
507: END IF;
508: END IF;
509:
510: RETURN TRUE;

Line 664: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_INDEX, x_index_name);

660: END IF;
661:
662: IF h_do_it THEN
663: h_sql := 'DROP INDEX '||x_index_name;
664: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_INDEX, x_index_name);
665: END IF;
666:
667: RETURN TRUE;
668:

Line 693: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, x_table_name);

689: -- Truncate table to release space --> Bug: DROP TABLE don't release the space immediately
690: Truncate_Table(x_table_name);
691:
692: h_sql := 'DROP TABLE '||x_table_name;
693: BSC_APPS.Do_DDL(h_sql, AD_DDL.DROP_TABLE, x_table_name);
694: END IF;
695:
696: RETURN TRUE;
697: