APPS.MSC_CL_COLLECTION dependencies on AD_DDL

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

819: EXECUTE IMMEDIATE lv_sql_stmt;
820: COMMIT;
821:
822: /*
823: AD_DDL.DO_DDL( APPLSYS_SCHEMA => lv_msc_schema,
824: APPLICATION_SHORT_NAME => 'MSC',
825: STATEMENT_TYPE => AD_DDL.TRUNCATE_TABLE,
826: STATEMENT => lv_sql_stmt,
827: OBJECT_NAME => p_table_name);

Line 825: STATEMENT_TYPE => AD_DDL.TRUNCATE_TABLE,

821:
822: /*
823: AD_DDL.DO_DDL( APPLSYS_SCHEMA => lv_msc_schema,
824: APPLICATION_SHORT_NAME => 'MSC',
825: STATEMENT_TYPE => AD_DDL.TRUNCATE_TABLE,
826: STATEMENT => lv_sql_stmt,
827: OBJECT_NAME => p_table_name);
828: */
829:

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

1211: ||' TRUNCATE PARTITION '||lv_partition_name;
1212:
1213: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, lv_sql_stmt);
1214:
1215: AD_DDL.DO_DDL( APPLSYS_SCHEMA => v_applsys_schema,
1216: APPLICATION_SHORT_NAME => 'MSC',
1217: STATEMENT_TYPE => AD_DDL.ALTER_TABLE,
1218: STATEMENT => lv_sql_stmt,
1219: OBJECT_NAME => p_table_name);

Line 1217: STATEMENT_TYPE => AD_DDL.ALTER_TABLE,

1213: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, lv_sql_stmt);
1214:
1215: AD_DDL.DO_DDL( APPLSYS_SCHEMA => v_applsys_schema,
1216: APPLICATION_SHORT_NAME => 'MSC',
1217: STATEMENT_TYPE => AD_DDL.ALTER_TABLE,
1218: STATEMENT => lv_sql_stmt,
1219: OBJECT_NAME => p_table_name);
1220:
1221: ELSE