eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.MSC_MANAGE_PLAN_PARTITIONS dependencies on AD_DDL

Line 164: ad_ddl.do_ddl(l_applsys_schema,'MSC',

160:
161: -- dbms_output.put_line(sql_stmt);
162: -- execute immediate sql_stmt;
163: begin
164: ad_ddl.do_ddl(l_applsys_schema,'MSC',
165: ad_ddl.alter_table,sql_stmt,cur_table);
166: exception
167: --
168: -- ignore the drop errors

Line 165: ad_ddl.alter_table,sql_stmt,cur_table);

161: -- dbms_output.put_line(sql_stmt);
162: -- execute immediate sql_stmt;
163: begin
164: ad_ddl.do_ddl(l_applsys_schema,'MSC',
165: ad_ddl.alter_table,sql_stmt,cur_table);
166: exception
167: --
168: -- ignore the drop errors
169: --

Line 287: ad_ddl.do_ddl(l_applsys_schema,'MSC',

283: -- execute immediate sql_stmt;
284:
285: if (cur_table NOT IN ('MSC_ITEM_CATEGORIES','MSC_SALES_ORDERS', 'MSC_ATP_SUMMARY_SO'
286: ,'MSC_DELIVERY_DETAILS','MSC_REGIONS','MSC_REGION_LOCATIONS','MSC_ZONE_REGIONS')) then
287: ad_ddl.do_ddl(l_applsys_schema,'MSC',
288: ad_ddl.alter_table,sql_stmt,cur_table);
289: end if;
290: part_created := part_created +1;
291:

Line 288: ad_ddl.alter_table,sql_stmt,cur_table);

284:
285: if (cur_table NOT IN ('MSC_ITEM_CATEGORIES','MSC_SALES_ORDERS', 'MSC_ATP_SUMMARY_SO'
286: ,'MSC_DELIVERY_DETAILS','MSC_REGIONS','MSC_REGION_LOCATIONS','MSC_ZONE_REGIONS')) then
287: ad_ddl.do_ddl(l_applsys_schema,'MSC',
288: ad_ddl.alter_table,sql_stmt,cur_table);
289: end if;
290: part_created := part_created +1;
291:
292: END LOOP;

Line 326: ad_ddl.do_ddl(l_applsys_schema,'MSC',

322: || l_partition_name;
323:
324: -- dbms_output.put_line(sql_stmt);
325: -- execute immediate sql_stmt;
326: ad_ddl.do_ddl(l_applsys_schema,'MSC',
327: ad_ddl.alter_table,sql_stmt,cur_table);
328:
329: END LOOP;
330:

Line 327: ad_ddl.alter_table,sql_stmt,cur_table);

323:
324: -- dbms_output.put_line(sql_stmt);
325: -- execute immediate sql_stmt;
326: ad_ddl.do_ddl(l_applsys_schema,'MSC',
327: ad_ddl.alter_table,sql_stmt,cur_table);
328:
329: END LOOP;
330:
331:

Line 421: ad_ddl.do_ddl(l_applsys_schema,'MSC',

417:
418: -- execute immediate sql_stmt;
419: -- msc_util.log_msg(MSC_UTIL.G_D_STATUS,'db1-'||sql_stmt);
420:
421: ad_ddl.do_ddl(l_applsys_schema,'MSC',
422: ad_ddl.alter_table,sql_stmt,cur_table);
423: -- msc_util.log_msg(MSC_UTIL.G_D_STATUS,'db1-competed');
424: part_created := part_created +1;
425:

Line 422: ad_ddl.alter_table,sql_stmt,cur_table);

418: -- execute immediate sql_stmt;
419: -- msc_util.log_msg(MSC_UTIL.G_D_STATUS,'db1-'||sql_stmt);
420:
421: ad_ddl.do_ddl(l_applsys_schema,'MSC',
422: ad_ddl.alter_table,sql_stmt,cur_table);
423: -- msc_util.log_msg(MSC_UTIL.G_D_STATUS,'db1-competed');
424: part_created := part_created +1;
425:
426: END LOOP;

Line 482: ad_ddl.do_ddl(l_applsys_schema,'MSC',

478: || l_partition_name;
479:
480: -- dbms_output.put_line(sql_stmt);
481: -- execute immediate sql_stmt;
482: ad_ddl.do_ddl(l_applsys_schema,'MSC',
483: ad_ddl.alter_table,sql_stmt,cur_table);
484:
485: END LOOP;
486:

Line 483: ad_ddl.alter_table,sql_stmt,cur_table);

479:
480: -- dbms_output.put_line(sql_stmt);
481: -- execute immediate sql_stmt;
482: ad_ddl.do_ddl(l_applsys_schema,'MSC',
483: ad_ddl.alter_table,sql_stmt,cur_table);
484:
485: END LOOP;
486:
487: