APPS.MSC_UTIL dependencies on AD_DDL

Line 426: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,

422:
423: v_sql_stmt:=
424: ' CREATE SNAPSHOT LOG ON '||p_schema ||'.'||p_table||' WITH ROWID ' ;
425:
426: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
427: application_short_name => p_schema,
428: statement_type => AD_DDL.CREATE_TABLE,
429: statement => v_sql_stmt,
430: object_name => p_table);

Line 428: statement_type => AD_DDL.CREATE_TABLE,

424: ' CREATE SNAPSHOT LOG ON '||p_schema ||'.'||p_table||' WITH ROWID ' ;
425:
426: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
427: application_short_name => p_schema,
428: statement_type => AD_DDL.CREATE_TABLE,
429: statement => v_sql_stmt,
430: object_name => p_table);
431:
432: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Snapshot Log for ' ||p_table||' successfully created...');

Line 568: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,

564: ||' '||p_logging ||' PARALLEL '|| p_parallel_degree;
565:
566: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Creating Snapshot for '||p_table||' ...');
567:
568: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
569: application_short_name => p_schema,
570: statement_type => AD_DDL.CREATE_TABLE,
571: statement => p_sql_stmt,
572: object_name => p_object);

Line 570: statement_type => AD_DDL.CREATE_TABLE,

566: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Creating Snapshot for '||p_table||' ...');
567:
568: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
569: application_short_name => p_schema,
570: statement_type => AD_DDL.CREATE_TABLE,
571: statement => p_sql_stmt,
572: object_name => p_object);
573:
574: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Snapshot for '||p_table||' succesfully created...');

Line 621: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,

617: v_sql_stmt VARCHAR2(6000);
618: lv_schema VARCHAR2(30);
619: BEGIN -- Index
620:
621: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
622: application_short_name => p_schema,
623: statement_type => AD_DDL.CREATE_INDEX,
624: statement => p_sql_stmt,
625: object_name => p_object);

Line 623: statement_type => AD_DDL.CREATE_INDEX,

619: BEGIN -- Index
620:
621: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
622: application_short_name => p_schema,
623: statement_type => AD_DDL.CREATE_INDEX,
624: statement => p_sql_stmt,
625: object_name => p_object);
626:
627: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Index '||p_object||' succesfully created...');

Line 656: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,

652: IS
653: v_sql_stmt VARCHAR2(6000);
654: BEGIN -- Index
655:
656: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
657: application_short_name => p_schema,
658: statement_type => AD_DDL.DROP_INDEX,
659: statement => p_sql_stmt,
660: object_name => p_table);

Line 658: statement_type => AD_DDL.DROP_INDEX,

654: BEGIN -- Index
655:
656: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
657: application_short_name => p_schema,
658: statement_type => AD_DDL.DROP_INDEX,
659: statement => p_sql_stmt,
660: object_name => p_table);
661:
662: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Index '||p_index||' succesfully dropped...');