APPS.MSC_ANALYSIS_SAFETY_STOCK_PERF dependencies on AD_DDL

Line 2920: ad_ddl.do_ddl(l_applsys_schema,'MSC', ad_ddl.alter_table,sql_stmt,l_partitioned_table);

2916: sql_stmt := 'alter table ' || l_partitioned_table || ' add partition '
2917: || l_partition_name || ' values less than ('|| to_char(p_plan_id+1) || ')';
2918: if (l_temp = 0) then
2919: put_line(sql_stmt);
2920: ad_ddl.do_ddl(l_applsys_schema,'MSC', ad_ddl.alter_table,sql_stmt,l_partitioned_table);
2921: end if;
2922: elsif (p_part_mode = 2) then
2923: --drop partitions
2924: sql_stmt := 'alter table ' || l_partitioned_table || ' drop partition '|| l_partition_name ;

Line 2926: ad_ddl.do_ddl(l_applsys_schema,'MSC', ad_ddl.alter_table,sql_stmt,l_partitioned_table);

2922: elsif (p_part_mode = 2) then
2923: --drop partitions
2924: sql_stmt := 'alter table ' || l_partitioned_table || ' drop partition '|| l_partition_name ;
2925: put_line(sql_stmt);
2926: ad_ddl.do_ddl(l_applsys_schema,'MSC', ad_ddl.alter_table,sql_stmt,l_partitioned_table);
2927: end if;
2928:
2929:
2930: return retcode;