APPS.MSC_PHUB_COST_PKG dependencies on AD_DDL

Line 1193: ad_ddl.do_ddl(l_applsys_schema, l_msc_schema,

1189: l_sql := 'alter table '||l_costs_f||
1190: ' add partition '||substr(l_costs_f, 5)||'_'||to_char(r.plan_run_id)||
1191: ' values less than ('||to_char(r.plan_run_id+1)||')';
1192:
1193: ad_ddl.do_ddl(l_applsys_schema, l_msc_schema,
1194: ad_ddl.alter_table, l_sql, l_costs_f);
1195: --msc_phub_util.log(l_sql);
1196: end if;
1197:

Line 1194: ad_ddl.alter_table, l_sql, l_costs_f);

1190: ' add partition '||substr(l_costs_f, 5)||'_'||to_char(r.plan_run_id)||
1191: ' values less than ('||to_char(r.plan_run_id+1)||')';
1192:
1193: ad_ddl.do_ddl(l_applsys_schema, l_msc_schema,
1194: ad_ddl.alter_table, l_sql, l_costs_f);
1195: --msc_phub_util.log(l_sql);
1196: end if;
1197:
1198: l_sql :=

Line 1288: ad_ddl.do_ddl(l_applsys_schema, l_msc_schema,

1284: ' at ('||to_char(r.plan_run_id+1)||')'||
1285: ' into (partition '||substr(l_costs_f, 5)||'_'||to_char(r.plan_run_id)||', '||
1286: ' partition '||substr(l_costs_f, 5)||'_'||to_char(l_next_id)||')';
1287:
1288: ad_ddl.do_ddl(l_applsys_schema, l_msc_schema,
1289: ad_ddl.alter_table, l_sql, l_costs_f);
1290: --msc_phub_util.log(l_sql);
1291: end if;
1292: end loop;

Line 1289: ad_ddl.alter_table, l_sql, l_costs_f);

1285: ' into (partition '||substr(l_costs_f, 5)||'_'||to_char(r.plan_run_id)||', '||
1286: ' partition '||substr(l_costs_f, 5)||'_'||to_char(l_next_id)||')';
1287:
1288: ad_ddl.do_ddl(l_applsys_schema, l_msc_schema,
1289: ad_ddl.alter_table, l_sql, l_costs_f);
1290: --msc_phub_util.log(l_sql);
1291: end if;
1292: end loop;
1293: msc_phub_util.log('msc_phub_cost_pkg.migrate complete');