APPS.MSC_PHUB_PKG dependencies on AD_DDL

Line 319: ad_ddl.do_ddl(l_applsys_schema, 'MSC', ad_ddl.alter_table, l_ddl, p_tables(i));

315: if (l_ddl is not null) then
316: msc_phub_util.log(l_ddl);
317: for j in 1..1800 loop
318: begin
319: ad_ddl.do_ddl(l_applsys_schema, 'MSC', ad_ddl.alter_table, l_ddl, p_tables(i));
320: exit;
321:
322: exception
323: when e_partition_not_exist then exit;

Line 2096: ad_ddl.do_ddl(l_applsys_schema, l_msc_schema, ad_ddl.alter_table, l_ddl, r.table_name);

2092: for r in c_obsolete_partitions(l_tables(i)) loop
2093: l_ddl := 'alter table '||r.table_name||' drop partition '||r.partition_name;
2094: begin
2095: msc_phub_util.log(l_ddl);
2096: ad_ddl.do_ddl(l_applsys_schema, l_msc_schema, ad_ddl.alter_table, l_ddl, r.table_name);
2097: exception
2098: when e_partition_not_exist then
2099: msc_phub_util.log('msc_phub_pkg.clean_up_fact_partitions.exception: '||sqlerrm);
2100: end;