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.

APPS.MSC_MANAGE_PLAN_PARTITIONS dependencies on AD_DDL

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

191:
192: -- dbms_output.put_line(sql_stmt);
193: -- execute immediate sql_stmt;
194: begin
195: ad_ddl.do_ddl(l_applsys_schema,'MSC',
196: ad_ddl.alter_table,sql_stmt,cur_table);
197: exception
198: --
199: -- ignore the drop errors

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

192: -- dbms_output.put_line(sql_stmt);
193: -- execute immediate sql_stmt;
194: begin
195: ad_ddl.do_ddl(l_applsys_schema,'MSC',
196: ad_ddl.alter_table,sql_stmt,cur_table);
197: exception
198: --
199: -- ignore the drop errors
200: --

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

328: 'MSC_WO_TASK_HIERARCHY','MSC_WORK_BREAKDOWN_STRUCT','MSC_WO_OPERATION_REL',
329: 'MSC_ORG_AGGR_IBUC','MSC_DOC_ATTACHMENTS','MSC_SHORT_TEXT','MSC_LONG_TEXT',
330: 'MSC_ITEM_CATEGORIES','MSC_SALES_ORDERS', 'MSC_ATP_SUMMARY_SO'
331: ,'MSC_DELIVERY_DETAILS','MSC_REGIONS','MSC_REGION_LOCATIONS','MSC_ZONE_REGIONS')) then
332: ad_ddl.do_ddl(l_applsys_schema,'MSC',
333: ad_ddl.alter_table,sql_stmt,cur_table);
334: end if;
335: part_created := part_created +1;
336:

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

329: 'MSC_ORG_AGGR_IBUC','MSC_DOC_ATTACHMENTS','MSC_SHORT_TEXT','MSC_LONG_TEXT',
330: 'MSC_ITEM_CATEGORIES','MSC_SALES_ORDERS', 'MSC_ATP_SUMMARY_SO'
331: ,'MSC_DELIVERY_DETAILS','MSC_REGIONS','MSC_REGION_LOCATIONS','MSC_ZONE_REGIONS')) then
332: ad_ddl.do_ddl(l_applsys_schema,'MSC',
333: ad_ddl.alter_table,sql_stmt,cur_table);
334: end if;
335: part_created := part_created +1;
336:
337: END LOOP;

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

367: || l_partition_name;
368:
369: -- dbms_output.put_line(sql_stmt);
370: -- execute immediate sql_stmt;
371: ad_ddl.do_ddl(l_applsys_schema,'MSC',
372: ad_ddl.alter_table,sql_stmt,cur_table);
373:
374: END LOOP;
375:

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

368:
369: -- dbms_output.put_line(sql_stmt);
370: -- execute immediate sql_stmt;
371: ad_ddl.do_ddl(l_applsys_schema,'MSC',
372: ad_ddl.alter_table,sql_stmt,cur_table);
373:
374: END LOOP;
375:
376:

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

466:
467: -- execute immediate sql_stmt;
468: -- msc_util.log_msg(MSC_UTIL.G_D_STATUS,'db1-'||sql_stmt);
469:
470: ad_ddl.do_ddl(l_applsys_schema,'MSC',
471: ad_ddl.alter_table,sql_stmt,cur_table);
472: -- msc_util.log_msg(MSC_UTIL.G_D_STATUS,'db1-competed');
473: part_created := part_created +1;
474:

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

467: -- execute immediate sql_stmt;
468: -- msc_util.log_msg(MSC_UTIL.G_D_STATUS,'db1-'||sql_stmt);
469:
470: ad_ddl.do_ddl(l_applsys_schema,'MSC',
471: ad_ddl.alter_table,sql_stmt,cur_table);
472: -- msc_util.log_msg(MSC_UTIL.G_D_STATUS,'db1-competed');
473: part_created := part_created +1;
474:
475: END LOOP;

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

527: || l_partition_name;
528:
529: -- dbms_output.put_line(sql_stmt);
530: -- execute immediate sql_stmt;
531: ad_ddl.do_ddl(l_applsys_schema,'MSC',
532: ad_ddl.alter_table,sql_stmt,cur_table);
533:
534: END LOOP;
535:

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

528:
529: -- dbms_output.put_line(sql_stmt);
530: -- execute immediate sql_stmt;
531: ad_ddl.do_ddl(l_applsys_schema,'MSC',
532: ad_ddl.alter_table,sql_stmt,cur_table);
533:
534: END LOOP;
535:
536: