APPS.MSC_UTIL dependencies on AD_DDL

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

437:
438: v_sql_stmt:=
439: ' CREATE SNAPSHOT LOG ON '||p_schema ||'.'||p_table||' WITH ROWID ' ;
440:
441: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
442: application_short_name => p_schema,
443: statement_type => AD_DDL.CREATE_TABLE,
444: statement => v_sql_stmt,
445: object_name => p_table);

Line 443: statement_type => AD_DDL.CREATE_TABLE,

439: ' CREATE SNAPSHOT LOG ON '||p_schema ||'.'||p_table||' WITH ROWID ' ;
440:
441: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
442: application_short_name => p_schema,
443: statement_type => AD_DDL.CREATE_TABLE,
444: statement => v_sql_stmt,
445: object_name => p_table);
446:
447: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Snapshot Log for ' ||p_table||' successfully created...');

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

482:
483: v_sql_stmt:=
484: ' CREATE SNAPSHOT LOG ON '||p_schema ||'.'||p_table||' WITH ROWID ' ;
485:
486: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
487: application_short_name => lappshortname,
488: statement_type => AD_DDL.CREATE_TABLE,
489: statement => v_sql_stmt,
490: object_name => p_table);

Line 488: statement_type => AD_DDL.CREATE_TABLE,

484: ' CREATE SNAPSHOT LOG ON '||p_schema ||'.'||p_table||' WITH ROWID ' ;
485:
486: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
487: application_short_name => lappshortname,
488: statement_type => AD_DDL.CREATE_TABLE,
489: statement => v_sql_stmt,
490: object_name => p_table);
491:
492: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Snapshot Log for ' ||p_table||' successfully created...');

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

638: EXECUTE IMMEDIATE p_sql_stmt;
639:
640: ELSE
641:
642: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
643: application_short_name => lv_appl_short_nm,
644: statement_type => AD_DDL.CREATE_TABLE,
645: statement => p_sql_stmt,
646: object_name => p_object);

Line 644: statement_type => AD_DDL.CREATE_TABLE,

640: ELSE
641:
642: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
643: application_short_name => lv_appl_short_nm,
644: statement_type => AD_DDL.CREATE_TABLE,
645: statement => p_sql_stmt,
646: object_name => p_object);
647: END IF;
648:

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

723: p_parallel_degree,
724: p_error );
725: ELSE
726:
727: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
728: application_short_name => lv_appl_short_nm,
729: statement_type => AD_DDL.CREATE_TABLE,
730: statement => p_sql_stmt,
731: object_name => p_object);

Line 729: statement_type => AD_DDL.CREATE_TABLE,

725: ELSE
726:
727: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
728: application_short_name => lv_appl_short_nm,
729: statement_type => AD_DDL.CREATE_TABLE,
730: statement => p_sql_stmt,
731: object_name => p_object);
732: END IF;
733:

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

859: EXECUTE IMMEDIATE p_sql_stmt;
860:
861: ELSE
862:
863: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
864: application_short_name => lv_appl_short_nm,
865: statement_type => AD_DDL.CREATE_INDEX,
866: statement => p_sql_stmt,
867: object_name => p_object);

Line 865: statement_type => AD_DDL.CREATE_INDEX,

861: ELSE
862:
863: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
864: application_short_name => lv_appl_short_nm,
865: statement_type => AD_DDL.CREATE_INDEX,
866: statement => p_sql_stmt,
867: object_name => p_object);
868: END IF;
869:

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

908: EXECUTE IMMEDIATE p_sql_stmt;
909:
910: ELSE
911:
912: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
913: application_short_name => lv_appl_short_nm,
914: statement_type => AD_DDL.DROP_INDEX,
915: statement => p_sql_stmt,
916: object_name => p_table);

Line 914: statement_type => AD_DDL.DROP_INDEX,

910: ELSE
911:
912: ad_ddl.do_ddl( applsys_schema => p_applsys_schema,
913: application_short_name => lv_appl_short_nm,
914: statement_type => AD_DDL.DROP_INDEX,
915: statement => p_sql_stmt,
916: object_name => p_table);
917: END IF;
918: