APPS.MSC_CL_COLLECTION dependencies on AD_DDL

Line 815: AD_DDL.DO_DDL( APPLSYS_SCHEMA => lv_msc_schema,

811: EXECUTE IMMEDIATE lv_sql_stmt;
812: COMMIT;
813:
814: /*
815: AD_DDL.DO_DDL( APPLSYS_SCHEMA => lv_msc_schema,
816: APPLICATION_SHORT_NAME => 'MSC',
817: STATEMENT_TYPE => AD_DDL.TRUNCATE_TABLE,
818: STATEMENT => lv_sql_stmt,
819: OBJECT_NAME => p_table_name);

Line 817: STATEMENT_TYPE => AD_DDL.TRUNCATE_TABLE,

813:
814: /*
815: AD_DDL.DO_DDL( APPLSYS_SCHEMA => lv_msc_schema,
816: APPLICATION_SHORT_NAME => 'MSC',
817: STATEMENT_TYPE => AD_DDL.TRUNCATE_TABLE,
818: STATEMENT => lv_sql_stmt,
819: OBJECT_NAME => p_table_name);
820: */
821:

Line 1197: AD_DDL.DO_DDL( APPLSYS_SCHEMA => v_applsys_schema,

1193: ||' TRUNCATE PARTITION '||lv_partition_name;
1194:
1195: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, lv_sql_stmt);
1196:
1197: AD_DDL.DO_DDL( APPLSYS_SCHEMA => v_applsys_schema,
1198: APPLICATION_SHORT_NAME => 'MSC',
1199: STATEMENT_TYPE => AD_DDL.ALTER_TABLE,
1200: STATEMENT => lv_sql_stmt,
1201: OBJECT_NAME => p_table_name);

Line 1199: STATEMENT_TYPE => AD_DDL.ALTER_TABLE,

1195: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, lv_sql_stmt);
1196:
1197: AD_DDL.DO_DDL( APPLSYS_SCHEMA => v_applsys_schema,
1198: APPLICATION_SHORT_NAME => 'MSC',
1199: STATEMENT_TYPE => AD_DDL.ALTER_TABLE,
1200: STATEMENT => lv_sql_stmt,
1201: OBJECT_NAME => p_table_name);
1202:
1203: ELSE