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_POST_PRO dependencies on AD_DDL

Line 532: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

528: -- NOLOGGING
529: (sr_instance_id, organization_id, inventory_item_id, sd_date, demand_class)
530: storage(INITIAL 40K NEXT 2M PCTINCREASE 0)'; --tablespace ' || l_tbspace(i);
531: msc_util.msc_log('Before create index on MSC_atp_summary_so: ');
532: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
533: APPLICATION_SHORT_NAME => 'MSC',
534: STATEMENT_TYPE => ad_ddl.create_index,
535: STATEMENT => l_sql_stmt_1,
536: OBJECT_NAME => 'MSC_TEMP_SUMM_SO');

Line 534: STATEMENT_TYPE => ad_ddl.create_index,

530: storage(INITIAL 40K NEXT 2M PCTINCREASE 0)'; --tablespace ' || l_tbspace(i);
531: msc_util.msc_log('Before create index on MSC_atp_summary_so: ');
532: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
533: APPLICATION_SHORT_NAME => 'MSC',
534: STATEMENT_TYPE => ad_ddl.create_index,
535: STATEMENT => l_sql_stmt_1,
536: OBJECT_NAME => 'MSC_TEMP_SUMM_SO');
537: END;
538: --analyze temp table

Line 549: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

545: ' including indexes without validation';
546:
547: BEGIN
548: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_SO: ');
549: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
550: APPLICATION_SHORT_NAME => 'MSC',
551: STATEMENT_TYPE => ad_ddl.alter_table,
552: STATEMENT => l_sql_stmt,
553: OBJECT_NAME => 'MSC_ATP_SUMMARY_SO');

Line 551: STATEMENT_TYPE => ad_ddl.alter_table,

547: BEGIN
548: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_SO: ');
549: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
550: APPLICATION_SHORT_NAME => 'MSC',
551: STATEMENT_TYPE => ad_ddl.alter_table,
552: STATEMENT => l_sql_stmt,
553: OBJECT_NAME => 'MSC_ATP_SUMMARY_SO');
554: END;
555: END IF;

Line 567: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

563: -- NOLOGGING
564: (plan_id, sr_instance_id, organization_id,inventory_item_id,sd_date, demand_class)
565: storage(INITIAL 40K NEXT 2M PCTINCREASE 0)'; --tablespace ' || l_tbspace(i);
566: msc_util.msc_log('Before create index on MSC_atp_summary_sd: ');
567: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
568: APPLICATION_SHORT_NAME => 'MSC',
569: STATEMENT_TYPE => ad_ddl.create_index,
570: STATEMENT => l_sql_stmt_1,
571: OBJECT_NAME => 'MSC_TEMP_SUMM_SD');

Line 569: STATEMENT_TYPE => ad_ddl.create_index,

565: storage(INITIAL 40K NEXT 2M PCTINCREASE 0)'; --tablespace ' || l_tbspace(i);
566: msc_util.msc_log('Before create index on MSC_atp_summary_sd: ');
567: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
568: APPLICATION_SHORT_NAME => 'MSC',
569: STATEMENT_TYPE => ad_ddl.create_index,
570: STATEMENT => l_sql_stmt_1,
571: OBJECT_NAME => 'MSC_TEMP_SUMM_SD');
572: END;
573: ---analyze supply demand table

Line 586: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

582: ' including indexes without validation';
583:
584: BEGIN
585: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_sd: ');
586: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
587: APPLICATION_SHORT_NAME => 'MSC',
588: STATEMENT_TYPE => ad_ddl.alter_table,
589: STATEMENT => l_sql_stmt,
590: OBJECT_NAME => 'MSC_ATP_SUMMARY_SD');

Line 588: STATEMENT_TYPE => ad_ddl.alter_table,

584: BEGIN
585: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_sd: ');
586: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
587: APPLICATION_SHORT_NAME => 'MSC',
588: STATEMENT_TYPE => ad_ddl.alter_table,
589: STATEMENT => l_sql_stmt,
590: OBJECT_NAME => 'MSC_ATP_SUMMARY_SD');
591: END;
592: END IF;

Line 1598: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,

1594: l_sql_stmt := 'TRUNCATE TABLE MSC_TEMP_SUMM_SO';
1595:
1596: BEGIN
1597: msc_util.msc_log('Tuncate Table MSC_TEMP_SUMM_SO');
1598: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
1599: APPLICATION_SHORT_NAME => 'MSC',
1600: STATEMENT_TYPE => ad_ddl.truncate_table,
1601: STATEMENT => l_sql_stmt,
1602: OBJECT_NAME => 'MSC_TEMP_SUMM_SO');

Line 1600: STATEMENT_TYPE => ad_ddl.truncate_table,

1596: BEGIN
1597: msc_util.msc_log('Tuncate Table MSC_TEMP_SUMM_SO');
1598: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
1599: APPLICATION_SHORT_NAME => 'MSC',
1600: STATEMENT_TYPE => ad_ddl.truncate_table,
1601: STATEMENT => l_sql_stmt,
1602: OBJECT_NAME => 'MSC_TEMP_SUMM_SO');
1603: EXCEPTION
1604: WHEN OTHERS THEN

Line 1612: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,

1608: l_sql_stmt := 'TRUNCATE TABLE MSC_TEMP_SUMM_SD';
1609:
1610: BEGIN
1611: msc_util.msc_log('Tuncate Table MSC_TEMP_SUMM_SD');
1612: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
1613: APPLICATION_SHORT_NAME => 'MSC',
1614: STATEMENT_TYPE => ad_ddl.truncate_table,
1615: STATEMENT => l_sql_stmt,
1616: OBJECT_NAME => 'MSC_TEMP_SUMM_SD');

Line 1614: STATEMENT_TYPE => ad_ddl.truncate_table,

1610: BEGIN
1611: msc_util.msc_log('Tuncate Table MSC_TEMP_SUMM_SD');
1612: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
1613: APPLICATION_SHORT_NAME => 'MSC',
1614: STATEMENT_TYPE => ad_ddl.truncate_table,
1615: STATEMENT => l_sql_stmt,
1616: OBJECT_NAME => 'MSC_TEMP_SUMM_SD');
1617: EXCEPTION
1618: WHEN OTHERS THEN

Line 1626: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,

1622: l_sql_stmt := 'DROP INDEX MSC_TEMP_SUMM_SO_N1';
1623:
1624: BEGIN
1625: msc_util.msc_log('Drop Index MSC_TEMP_SUMM_SO_N1');
1626: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
1627: APPLICATION_SHORT_NAME => 'MSC',
1628: STATEMENT_TYPE => ad_ddl.drop_index,
1629: STATEMENT => l_sql_stmt,
1630: OBJECT_NAME => 'MSC_TEMP_SUMM_SO_N1');

Line 1628: STATEMENT_TYPE => ad_ddl.drop_index,

1624: BEGIN
1625: msc_util.msc_log('Drop Index MSC_TEMP_SUMM_SO_N1');
1626: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
1627: APPLICATION_SHORT_NAME => 'MSC',
1628: STATEMENT_TYPE => ad_ddl.drop_index,
1629: STATEMENT => l_sql_stmt,
1630: OBJECT_NAME => 'MSC_TEMP_SUMM_SO_N1');
1631: EXCEPTION
1632: WHEN OTHERS THEN

Line 1641: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,

1637: l_sql_stmt := 'DROP INDEX MSC_TEMP_SUMM_SD_N1';
1638:
1639: BEGIN
1640: msc_util.msc_log('Drop Index MSC_TEMP_SUMM_SD_N1');
1641: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
1642: APPLICATION_SHORT_NAME => 'MSC',
1643: STATEMENT_TYPE => ad_ddl.drop_index,
1644: STATEMENT => l_sql_stmt,
1645: OBJECT_NAME => 'MSC_TEMP_SUMM_SD_N1');

Line 1643: STATEMENT_TYPE => ad_ddl.drop_index,

1639: BEGIN
1640: msc_util.msc_log('Drop Index MSC_TEMP_SUMM_SD_N1');
1641: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
1642: APPLICATION_SHORT_NAME => 'MSC',
1643: STATEMENT_TYPE => ad_ddl.drop_index,
1644: STATEMENT => l_sql_stmt,
1645: OBJECT_NAME => 'MSC_TEMP_SUMM_SD_N1');
1646: EXCEPTION
1647: WHEN OTHERS THEN

Line 1890: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,

1886: l_sql_stmt := 'TRUNCATE TABLE MSC_TEMP_SUMM_SD';
1887:
1888: BEGIN
1889: msc_util.msc_log('Tuncate Table MSC_TEMP_SUMM_SD');
1890: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
1891: APPLICATION_SHORT_NAME => 'MSC',
1892: STATEMENT_TYPE => ad_ddl.truncate_table,
1893: STATEMENT => l_sql_stmt,
1894: OBJECT_NAME => 'MSC_TEMP_SUMM_SD');

Line 1892: STATEMENT_TYPE => ad_ddl.truncate_table,

1888: BEGIN
1889: msc_util.msc_log('Tuncate Table MSC_TEMP_SUMM_SD');
1890: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
1891: APPLICATION_SHORT_NAME => 'MSC',
1892: STATEMENT_TYPE => ad_ddl.truncate_table,
1893: STATEMENT => l_sql_stmt,
1894: OBJECT_NAME => 'MSC_TEMP_SUMM_SD');
1895: EXCEPTION
1896: WHEN OTHERS THEN

Line 1905: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,

1901: l_sql_stmt := 'DROP INDEX MSC_TEMP_SUMM_SD_N1';
1902:
1903: BEGIN
1904: msc_util.msc_log('Drop Index MSC_TEMP_SUMM_SD_N1');
1905: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
1906: APPLICATION_SHORT_NAME => 'MSC',
1907: STATEMENT_TYPE => ad_ddl.drop_index,
1908: STATEMENT => l_sql_stmt,
1909: OBJECT_NAME => 'MSC_TEMP_SUMM_SD_N1');

Line 1907: STATEMENT_TYPE => ad_ddl.drop_index,

1903: BEGIN
1904: msc_util.msc_log('Drop Index MSC_TEMP_SUMM_SD_N1');
1905: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
1906: APPLICATION_SHORT_NAME => 'MSC',
1907: STATEMENT_TYPE => ad_ddl.drop_index,
1908: STATEMENT => l_sql_stmt,
1909: OBJECT_NAME => 'MSC_TEMP_SUMM_SD_N1');
1910: EXCEPTION
1911: WHEN OTHERS THEN

Line 1920: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,

1916: l_sql_stmt := 'TRUNCATE TABLE MSC_TEMP_SUMM_SUP';
1917:
1918: BEGIN
1919: msc_util.msc_log('Tuncate Table MSC_TEMP_SUMM_SUP');
1920: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
1921: APPLICATION_SHORT_NAME => 'MSC',
1922: STATEMENT_TYPE => ad_ddl.truncate_table,
1923: STATEMENT => l_sql_stmt,
1924: OBJECT_NAME => 'MSC_TEMP_SUMM_SUP');

Line 1922: STATEMENT_TYPE => ad_ddl.truncate_table,

1918: BEGIN
1919: msc_util.msc_log('Tuncate Table MSC_TEMP_SUMM_SUP');
1920: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
1921: APPLICATION_SHORT_NAME => 'MSC',
1922: STATEMENT_TYPE => ad_ddl.truncate_table,
1923: STATEMENT => l_sql_stmt,
1924: OBJECT_NAME => 'MSC_TEMP_SUMM_SUP');
1925: EXCEPTION
1926: WHEN OTHERS THEN

Line 1935: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,

1931: l_sql_stmt := 'DROP INDEX MSC_TEMP_SUMM_SUP_N1';
1932:
1933: BEGIN
1934: msc_util.msc_log('Drop Index MSC_TEMP_SUMM_SUP_N1');
1935: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
1936: APPLICATION_SHORT_NAME => 'MSC',
1937: STATEMENT_TYPE => ad_ddl.drop_index,
1938: STATEMENT => l_sql_stmt,
1939: OBJECT_NAME => 'MSC_TEMP_SUMM_SUP_N1');

Line 1937: STATEMENT_TYPE => ad_ddl.drop_index,

1933: BEGIN
1934: msc_util.msc_log('Drop Index MSC_TEMP_SUMM_SUP_N1');
1935: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
1936: APPLICATION_SHORT_NAME => 'MSC',
1937: STATEMENT_TYPE => ad_ddl.drop_index,
1938: STATEMENT => l_sql_stmt,
1939: OBJECT_NAME => 'MSC_TEMP_SUMM_SUP_N1');
1940: EXCEPTION
1941: WHEN OTHERS THEN

Line 1950: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,

1946: l_sql_stmt := 'TRUNCATE TABLE MSC_TEMP_SUMM_RES';
1947:
1948: BEGIN
1949: msc_util.msc_log('Tuncate Table MSC_TEMP_SUMM_RES');
1950: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
1951: APPLICATION_SHORT_NAME => 'MSC',
1952: STATEMENT_TYPE => ad_ddl.truncate_table,
1953: STATEMENT => l_sql_stmt,
1954: OBJECT_NAME => 'MSC_TEMP_SUMM_RES');

Line 1952: STATEMENT_TYPE => ad_ddl.truncate_table,

1948: BEGIN
1949: msc_util.msc_log('Tuncate Table MSC_TEMP_SUMM_RES');
1950: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
1951: APPLICATION_SHORT_NAME => 'MSC',
1952: STATEMENT_TYPE => ad_ddl.truncate_table,
1953: STATEMENT => l_sql_stmt,
1954: OBJECT_NAME => 'MSC_TEMP_SUMM_RES');
1955: EXCEPTION
1956: WHEN OTHERS THEN

Line 1965: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,

1961: l_sql_stmt := 'DROP INDEX MSC_TEMP_SUMM_RES_N1';
1962:
1963: BEGIN
1964: msc_util.msc_log('Drop Index MSC_TEMP_SUMM_RES_N1');
1965: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
1966: APPLICATION_SHORT_NAME => 'MSC',
1967: STATEMENT_TYPE => ad_ddl.drop_index,
1968: STATEMENT => l_sql_stmt,
1969: OBJECT_NAME => 'MSC_TEMP_SUMM_RES_N1');

Line 1967: STATEMENT_TYPE => ad_ddl.drop_index,

1963: BEGIN
1964: msc_util.msc_log('Drop Index MSC_TEMP_SUMM_RES_N1');
1965: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
1966: APPLICATION_SHORT_NAME => 'MSC',
1967: STATEMENT_TYPE => ad_ddl.drop_index,
1968: STATEMENT => l_sql_stmt,
1969: OBJECT_NAME => 'MSC_TEMP_SUMM_RES_N1');
1970: EXCEPTION
1971: WHEN OTHERS THEN

Line 3522: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,

3518:
3519: msc_util.msc_log('l_sql_stmt := ' || l_sql_stmt);
3520: CLOSE C_PLAN;
3521:
3522: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
3523: APPLICATION_SHORT_NAME => 'MSC',
3524: STATEMENT_TYPE => ad_ddl.alter_table,
3525: STATEMENT => l_sql_stmt,
3526: OBJECT_NAME => l_table_name);

Line 3524: STATEMENT_TYPE => ad_ddl.alter_table,

3520: CLOSE C_PLAN;
3521:
3522: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
3523: APPLICATION_SHORT_NAME => 'MSC',
3524: STATEMENT_TYPE => ad_ddl.alter_table,
3525: STATEMENT => l_sql_stmt,
3526: OBJECT_NAME => l_table_name);
3527: msc_util.msc_log('Create Partition successful');
3528: END IF; -- l_summary_flag <> 0 THEN

Line 3627: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,

3623: || ' INTO ( PARTITION ' || l_partition_name || ','
3624: || ' PARTITION ' ||l_split_partition || ')';
3625: END IF; -- l_table_name = 'MSC_ATP_SUMMARY_SO' THEN
3626: msc_util.msc_log('l_sql_stmt := ' || l_sql_stmt);
3627: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
3628: APPLICATION_SHORT_NAME => 'MSC',
3629: STATEMENT_TYPE => ad_ddl.alter_table,
3630: STATEMENT => l_sql_stmt,
3631: OBJECT_NAME => l_table_name);

Line 3629: STATEMENT_TYPE => ad_ddl.alter_table,

3625: END IF; -- l_table_name = 'MSC_ATP_SUMMARY_SO' THEN
3626: msc_util.msc_log('l_sql_stmt := ' || l_sql_stmt);
3627: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
3628: APPLICATION_SHORT_NAME => 'MSC',
3629: STATEMENT_TYPE => ad_ddl.alter_table,
3630: STATEMENT => l_sql_stmt,
3631: OBJECT_NAME => l_table_name);
3632: msc_util.msc_log('Create Partition successful');
3633: END IF; -- l_summary_flag <> 0 THEN

Line 3760: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

3756: || ' INTO ( PARTITION ' || l_partition_name || ','
3757: || ' PARTITION ' ||l_split_partition || ')';
3758: END IF; -- l_table_name = 'MSC_ATP_SUMMARY_SO' THEN
3759: msc_util.msc_log('l_sql_stmt := ' || l_sql_stmt);
3760: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
3761: APPLICATION_SHORT_NAME => 'MSC',
3762: STATEMENT_TYPE => ad_ddl.alter_table,
3763: STATEMENT => l_sql_stmt,
3764: OBJECT_NAME => l_table_name);

Line 3762: STATEMENT_TYPE => ad_ddl.alter_table,

3758: END IF; -- l_table_name = 'MSC_ATP_SUMMARY_SO' THEN
3759: msc_util.msc_log('l_sql_stmt := ' || l_sql_stmt);
3760: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
3761: APPLICATION_SHORT_NAME => 'MSC',
3762: STATEMENT_TYPE => ad_ddl.alter_table,
3763: STATEMENT => l_sql_stmt,
3764: OBJECT_NAME => l_table_name);
3765: msc_util.msc_log('Create Partition successful');
3766: ELSE

Line 3834: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

3830: || l_partition_name
3831: || ' VALUES LESS THAN ('
3832: || to_char(l_plan_id) || ', ' ||to_char(MAXVALUE + 1)
3833: || ')';
3834: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
3835: APPLICATION_SHORT_NAME => 'MSC',
3836: STATEMENT_TYPE => ad_ddl.alter_table,
3837: STATEMENT => l_sql_stmt,
3838: OBJECT_NAME => atp_summ_tab(i));

Line 3836: STATEMENT_TYPE => ad_ddl.alter_table,

3832: || to_char(l_plan_id) || ', ' ||to_char(MAXVALUE + 1)
3833: || ')';
3834: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
3835: APPLICATION_SHORT_NAME => 'MSC',
3836: STATEMENT_TYPE => ad_ddl.alter_table,
3837: STATEMENT => l_sql_stmt,
3838: OBJECT_NAME => atp_summ_tab(i));
3839:
3840: msc_util.msc_log('Create Partition successful');

Line 3897: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

3893: || l_partition_name
3894: || ' VALUES LESS THAN ('
3895: || to_char(l_plan_id) || ', ' ||to_char(MAXVALUE + 1)
3896: || ')';
3897: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
3898: APPLICATION_SHORT_NAME => 'MSC',
3899: STATEMENT_TYPE => ad_ddl.alter_table,
3900: STATEMENT => l_sql_stmt,
3901: OBJECT_NAME => atp_summ_tab(i));

Line 3899: STATEMENT_TYPE => ad_ddl.alter_table,

3895: || to_char(l_plan_id) || ', ' ||to_char(MAXVALUE + 1)
3896: || ')';
3897: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
3898: APPLICATION_SHORT_NAME => 'MSC',
3899: STATEMENT_TYPE => ad_ddl.alter_table,
3900: STATEMENT => l_sql_stmt,
3901: OBJECT_NAME => atp_summ_tab(i));
3902:
3903: msc_util.msc_log('Create Partition successful');

Line 4012: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,

4008: l_sql_stmt := 'DROP TABLE MSC_ALLOC_TEMP_' || to_char(p_plan_id2);
4009:
4010: BEGIN
4011: msc_util.msc_log(l_sql_stmt);
4012: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
4013: APPLICATION_SHORT_NAME => 'MSC',
4014: STATEMENT_TYPE => ad_ddl.drop_table,
4015: STATEMENT => l_sql_stmt,
4016: OBJECT_NAME => 'MSC_ALLOC_TEMP_' || to_char(p_plan_id2));

Line 4014: STATEMENT_TYPE => ad_ddl.drop_table,

4010: BEGIN
4011: msc_util.msc_log(l_sql_stmt);
4012: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
4013: APPLICATION_SHORT_NAME => 'MSC',
4014: STATEMENT_TYPE => ad_ddl.drop_table,
4015: STATEMENT => l_sql_stmt,
4016: OBJECT_NAME => 'MSC_ALLOC_TEMP_' || to_char(p_plan_id2));
4017: EXCEPTION
4018: WHEN OTHERS THEN

Line 4029: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,

4025: l_sql_stmt := 'DROP TABLE MSC_TEMP_ALLOC_DEM_' || to_char(p_plan_id);
4026:
4027: BEGIN
4028: msc_util.msc_log(l_sql_stmt);
4029: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
4030: APPLICATION_SHORT_NAME => 'MSC',
4031: STATEMENT_TYPE => ad_ddl.drop_table,
4032: STATEMENT => l_sql_stmt,
4033: OBJECT_NAME => 'MSC_TEMP_ALLOC_DEM_' || to_char(p_plan_id));

Line 4031: STATEMENT_TYPE => ad_ddl.drop_table,

4027: BEGIN
4028: msc_util.msc_log(l_sql_stmt);
4029: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
4030: APPLICATION_SHORT_NAME => 'MSC',
4031: STATEMENT_TYPE => ad_ddl.drop_table,
4032: STATEMENT => l_sql_stmt,
4033: OBJECT_NAME => 'MSC_TEMP_ALLOC_DEM_' || to_char(p_plan_id));
4034: EXCEPTION
4035: WHEN OTHERS THEN

Line 4044: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,

4040: l_sql_stmt := 'DROP TABLE MSC_TEMP_ALLOC_SUP_' || to_char(p_plan_id);
4041:
4042: BEGIN
4043: msc_util.msc_log(l_sql_stmt);
4044: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
4045: APPLICATION_SHORT_NAME => 'MSC',
4046: STATEMENT_TYPE => ad_ddl.drop_table,
4047: STATEMENT => l_sql_stmt,
4048: OBJECT_NAME => 'MSC_TEMP_ALLOC_SUP_' || to_char(p_plan_id));

Line 4046: STATEMENT_TYPE => ad_ddl.drop_table,

4042: BEGIN
4043: msc_util.msc_log(l_sql_stmt);
4044: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
4045: APPLICATION_SHORT_NAME => 'MSC',
4046: STATEMENT_TYPE => ad_ddl.drop_table,
4047: STATEMENT => l_sql_stmt,
4048: OBJECT_NAME => 'MSC_TEMP_ALLOC_SUP_' || to_char(p_plan_id));
4049: EXCEPTION
4050: WHEN OTHERS THEN

Line 5158: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

5154: PCTFREE 0 STORAGE(INITIAL 40K NEXT 5M PCTINCREASE 0)';
5155: */
5156: msc_util.msc_log('before creating table : ' || l_temp_table);
5157: BEGIN
5158: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
5159: APPLICATION_SHORT_NAME => 'MSC',
5160: STATEMENT_TYPE => ad_ddl.create_table,
5161: STATEMENT => l_insert_stmt,
5162: OBJECT_NAME => l_temp_table);

Line 5160: STATEMENT_TYPE => ad_ddl.create_table,

5156: msc_util.msc_log('before creating table : ' || l_temp_table);
5157: BEGIN
5158: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
5159: APPLICATION_SHORT_NAME => 'MSC',
5160: STATEMENT_TYPE => ad_ddl.create_table,
5161: STATEMENT => l_insert_stmt,
5162: OBJECT_NAME => l_temp_table);
5163: msc_util.msc_log('after creating table : ' || l_temp_table);
5164:

Line 5170: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

5166: WHEN others THEN
5167: msc_util.msc_log(sqlcode || ': ' || sqlerrm);
5168: msc_util.msc_log('Exception of create table : ' || l_temp_table);
5169:
5170: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
5171: APPLICATION_SHORT_NAME => 'MSC',
5172: STATEMENT_TYPE => ad_ddl.drop_table,
5173: STATEMENT => 'DROP TABLE ' || l_temp_table,
5174: OBJECT_NAME => l_temp_table);

Line 5172: STATEMENT_TYPE => ad_ddl.drop_table,

5168: msc_util.msc_log('Exception of create table : ' || l_temp_table);
5169:
5170: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
5171: APPLICATION_SHORT_NAME => 'MSC',
5172: STATEMENT_TYPE => ad_ddl.drop_table,
5173: STATEMENT => 'DROP TABLE ' || l_temp_table,
5174: OBJECT_NAME => l_temp_table);
5175:
5176: msc_util.msc_log('After Drop table : ' ||l_temp_table);

Line 5179: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

5175:
5176: msc_util.msc_log('After Drop table : ' ||l_temp_table);
5177: msc_util.msc_log('Before exception create table : ' ||l_temp_table);
5178:
5179: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
5180: APPLICATION_SHORT_NAME => 'MSC',
5181: STATEMENT_TYPE => ad_ddl.create_table,
5182: STATEMENT => l_insert_stmt,
5183: OBJECT_NAME => l_temp_table);

Line 5181: STATEMENT_TYPE => ad_ddl.create_table,

5177: msc_util.msc_log('Before exception create table : ' ||l_temp_table);
5178:
5179: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
5180: APPLICATION_SHORT_NAME => 'MSC',
5181: STATEMENT_TYPE => ad_ddl.create_table,
5182: STATEMENT => l_insert_stmt,
5183: OBJECT_NAME => l_temp_table);
5184: msc_util.msc_log('After exception create table : ' ||l_temp_table);
5185: END;

Line 5603: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

5599: STORAGE(INITIAL 40K NEXT 2M PCTINCREASE 0) tablespace ' || l_ind_tbspace;
5600:
5601: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N1');
5602:
5603: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
5604: APPLICATION_SHORT_NAME => 'MSC',
5605: STATEMENT_TYPE => ad_ddl.create_index,
5606: STATEMENT => l_sql_stmt_1,
5607: OBJECT_NAME => l_temp_table);

Line 5605: STATEMENT_TYPE => ad_ddl.create_index,

5601: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N1');
5602:
5603: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
5604: APPLICATION_SHORT_NAME => 'MSC',
5605: STATEMENT_TYPE => ad_ddl.create_index,
5606: STATEMENT => l_sql_stmt_1,
5607: OBJECT_NAME => l_temp_table);
5608:
5609: msc_util.msc_log('After index : ' || l_temp_table || '.' || l_temp_table || '_N1');

Line 5620: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

5616: STORAGE(INITIAL 40K NEXT 2M PCTINCREASE 0) tablespace ' || l_ind_tbspace;
5617:
5618: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N2');
5619:
5620: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
5621: APPLICATION_SHORT_NAME => 'MSC',
5622: STATEMENT_TYPE => ad_ddl.create_index,
5623: STATEMENT => l_sql_stmt_1,
5624: OBJECT_NAME => l_temp_table);

Line 5622: STATEMENT_TYPE => ad_ddl.create_index,

5618: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N2');
5619:
5620: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
5621: APPLICATION_SHORT_NAME => 'MSC',
5622: STATEMENT_TYPE => ad_ddl.create_index,
5623: STATEMENT => l_sql_stmt_1,
5624: OBJECT_NAME => l_temp_table);
5625:
5626: msc_util.msc_log('After index : ' || l_temp_table || '.' || l_temp_table || '_N2');

Line 5637: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

5633: STORAGE(INITIAL 40K NEXT 2M PCTINCREASE 0) tablespace ' || l_ind_tbspace;
5634:
5635: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N3');
5636:
5637: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
5638: APPLICATION_SHORT_NAME => 'MSC',
5639: STATEMENT_TYPE => ad_ddl.create_index,
5640: STATEMENT => l_sql_stmt_1,
5641: OBJECT_NAME => l_temp_table);

Line 5639: STATEMENT_TYPE => ad_ddl.create_index,

5635: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N3');
5636:
5637: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
5638: APPLICATION_SHORT_NAME => 'MSC',
5639: STATEMENT_TYPE => ad_ddl.create_index,
5640: STATEMENT => l_sql_stmt_1,
5641: OBJECT_NAME => l_temp_table);
5642:
5643: msc_util.msc_log('After index : ' || l_temp_table || '.' || l_temp_table || '_N3');

Line 5711: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

5707: */
5708:
5709: msc_util.msc_log('before creating table : ' || l_temp_table);
5710: BEGIN
5711: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
5712: APPLICATION_SHORT_NAME => 'MSC',
5713: STATEMENT_TYPE => ad_ddl.create_table,
5714: STATEMENT => l_insert_stmt,
5715: OBJECT_NAME => l_temp_table);

Line 5713: STATEMENT_TYPE => ad_ddl.create_table,

5709: msc_util.msc_log('before creating table : ' || l_temp_table);
5710: BEGIN
5711: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
5712: APPLICATION_SHORT_NAME => 'MSC',
5713: STATEMENT_TYPE => ad_ddl.create_table,
5714: STATEMENT => l_insert_stmt,
5715: OBJECT_NAME => l_temp_table);
5716: msc_util.msc_log('after creating table : ' || l_temp_table);
5717:

Line 5723: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

5719: WHEN others THEN
5720: msc_util.msc_log(sqlcode || ': ' || sqlerrm);
5721: msc_util.msc_log('Exception of create table : ' || l_temp_table);
5722:
5723: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
5724: APPLICATION_SHORT_NAME => 'MSC',
5725: STATEMENT_TYPE => ad_ddl.drop_table,
5726: STATEMENT => 'DROP TABLE ' || l_temp_table,
5727: OBJECT_NAME => l_temp_table);

Line 5725: STATEMENT_TYPE => ad_ddl.drop_table,

5721: msc_util.msc_log('Exception of create table : ' || l_temp_table);
5722:
5723: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
5724: APPLICATION_SHORT_NAME => 'MSC',
5725: STATEMENT_TYPE => ad_ddl.drop_table,
5726: STATEMENT => 'DROP TABLE ' || l_temp_table,
5727: OBJECT_NAME => l_temp_table);
5728:
5729: msc_util.msc_log('After Drop table : ' ||l_temp_table);

Line 5732: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

5728:
5729: msc_util.msc_log('After Drop table : ' ||l_temp_table);
5730: msc_util.msc_log('Before exception create table : ' ||l_temp_table);
5731:
5732: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
5733: APPLICATION_SHORT_NAME => 'MSC',
5734: STATEMENT_TYPE => ad_ddl.create_table,
5735: STATEMENT => l_insert_stmt,
5736: OBJECT_NAME => l_temp_table);

Line 5734: STATEMENT_TYPE => ad_ddl.create_table,

5730: msc_util.msc_log('Before exception create table : ' ||l_temp_table);
5731:
5732: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
5733: APPLICATION_SHORT_NAME => 'MSC',
5734: STATEMENT_TYPE => ad_ddl.create_table,
5735: STATEMENT => l_insert_stmt,
5736: OBJECT_NAME => l_temp_table);
5737: msc_util.msc_log('After exception create table : ' ||l_temp_table);
5738: END;

Line 6081: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

6077: STORAGE(INITIAL 40K NEXT 2M PCTINCREASE 0) tablespace ' || l_ind_tbspace;
6078:
6079: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N1');
6080:
6081: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
6082: APPLICATION_SHORT_NAME => 'MSC',
6083: STATEMENT_TYPE => ad_ddl.create_index,
6084: STATEMENT => l_sql_stmt_1,
6085: OBJECT_NAME => l_temp_table);

Line 6083: STATEMENT_TYPE => ad_ddl.create_index,

6079: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N1');
6080:
6081: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
6082: APPLICATION_SHORT_NAME => 'MSC',
6083: STATEMENT_TYPE => ad_ddl.create_index,
6084: STATEMENT => l_sql_stmt_1,
6085: OBJECT_NAME => l_temp_table);
6086:
6087: msc_util.msc_log('After index : ' || l_temp_table || '.' || l_temp_table || '_N1');

Line 6098: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

6094: STORAGE(INITIAL 40K NEXT 2M PCTINCREASE 0) tablespace ' || l_ind_tbspace;
6095:
6096: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N2');
6097:
6098: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
6099: APPLICATION_SHORT_NAME => 'MSC',
6100: STATEMENT_TYPE => ad_ddl.create_index,
6101: STATEMENT => l_sql_stmt_1,
6102: OBJECT_NAME => l_temp_table);

Line 6100: STATEMENT_TYPE => ad_ddl.create_index,

6096: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N2');
6097:
6098: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
6099: APPLICATION_SHORT_NAME => 'MSC',
6100: STATEMENT_TYPE => ad_ddl.create_index,
6101: STATEMENT => l_sql_stmt_1,
6102: OBJECT_NAME => l_temp_table);
6103:
6104: msc_util.msc_log('After index : ' || l_temp_table || '.' || l_temp_table || '_N2');

Line 6116: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

6112: STORAGE(INITIAL 40K NEXT 2M PCTINCREASE 0) tablespace ' || l_ind_tbspace;
6113:
6114: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N3');
6115:
6116: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
6117: APPLICATION_SHORT_NAME => 'MSC',
6118: STATEMENT_TYPE => ad_ddl.create_index,
6119: STATEMENT => l_sql_stmt_1,
6120: OBJECT_NAME => l_temp_table);

Line 6118: STATEMENT_TYPE => ad_ddl.create_index,

6114: msc_util.msc_log('Before index : ' || l_temp_table || '.' || l_temp_table || '_N3');
6115:
6116: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
6117: APPLICATION_SHORT_NAME => 'MSC',
6118: STATEMENT_TYPE => ad_ddl.create_index,
6119: STATEMENT => l_sql_stmt_1,
6120: OBJECT_NAME => l_temp_table);
6121:
6122: msc_util.msc_log('After index : ' || l_temp_table || '.' || l_temp_table || '_N3');

Line 6142: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

6138: ' including indexes without validation';
6139:
6140: BEGIN
6141: msc_util.msc_log('Before alter table msc_alloc_demands');
6142: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
6143: APPLICATION_SHORT_NAME => 'MSC',
6144: STATEMENT_TYPE => ad_ddl.alter_table,
6145: STATEMENT => l_sql_stmt,
6146: OBJECT_NAME => 'MSC_ALLOC_DEMANDS');

Line 6144: STATEMENT_TYPE => ad_ddl.alter_table,

6140: BEGIN
6141: msc_util.msc_log('Before alter table msc_alloc_demands');
6142: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
6143: APPLICATION_SHORT_NAME => 'MSC',
6144: STATEMENT_TYPE => ad_ddl.alter_table,
6145: STATEMENT => l_sql_stmt,
6146: OBJECT_NAME => 'MSC_ALLOC_DEMANDS');
6147: END;
6148:

Line 6160: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,

6156: ' including indexes without validation';
6157:
6158: BEGIN
6159: msc_util.msc_log('Before alter table msc_alloc_supplies');
6160: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
6161: APPLICATION_SHORT_NAME => 'MSC',
6162: STATEMENT_TYPE => ad_ddl.alter_table,
6163: STATEMENT => l_sql_stmt,
6164: OBJECT_NAME => 'MSC_ALLOC_SUPPLIES');

Line 6162: STATEMENT_TYPE => ad_ddl.alter_table,

6158: BEGIN
6159: msc_util.msc_log('Before alter table msc_alloc_supplies');
6160: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
6161: APPLICATION_SHORT_NAME => 'MSC',
6162: STATEMENT_TYPE => ad_ddl.alter_table,
6163: STATEMENT => l_sql_stmt,
6164: OBJECT_NAME => 'MSC_ALLOC_SUPPLIES');
6165: END;
6166:

Line 8783: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,

8779: l_partition_name || ' DROP STORAGE';
8780:
8781: BEGIN
8782: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_SD');
8783: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
8784: APPLICATION_SHORT_NAME => 'MSC',
8785: STATEMENT_TYPE => ad_ddl.alter_table,
8786: STATEMENT => l_sql_stmt,
8787: OBJECT_NAME => 'MSC_ATP_SUMMARY_SD');

Line 8785: STATEMENT_TYPE => ad_ddl.alter_table,

8781: BEGIN
8782: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_SD');
8783: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
8784: APPLICATION_SHORT_NAME => 'MSC',
8785: STATEMENT_TYPE => ad_ddl.alter_table,
8786: STATEMENT => l_sql_stmt,
8787: OBJECT_NAME => 'MSC_ATP_SUMMARY_SD');
8788: END;
8789: msc_util.msc_log('Truncate_Summ_Plan_Partition: ' || 'After truncating SD partition');

Line 8801: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,

8797: l_partition_name || ' DROP STORAGE';
8798:
8799: BEGIN
8800: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_SUP');
8801: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
8802: APPLICATION_SHORT_NAME => 'MSC',
8803: STATEMENT_TYPE => ad_ddl.alter_table,
8804: STATEMENT => l_sql_stmt,
8805: OBJECT_NAME => 'MSC_ATP_SUMMARY_SUP');

Line 8803: STATEMENT_TYPE => ad_ddl.alter_table,

8799: BEGIN
8800: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_SUP');
8801: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
8802: APPLICATION_SHORT_NAME => 'MSC',
8803: STATEMENT_TYPE => ad_ddl.alter_table,
8804: STATEMENT => l_sql_stmt,
8805: OBJECT_NAME => 'MSC_ATP_SUMMARY_SUP');
8806: END;
8807: msc_util.msc_log('Truncate_Summ_Plan_Partition: ' || 'After truncating sup partition');

Line 8819: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,

8815: l_partition_name || ' DROP STORAGE';
8816:
8817: BEGIN
8818: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_RES');
8819: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
8820: APPLICATION_SHORT_NAME => 'MSC',
8821: STATEMENT_TYPE => ad_ddl.alter_table,
8822: STATEMENT => l_sql_stmt,
8823: OBJECT_NAME => 'MSC_ATP_SUMMARY_RES');

Line 8821: STATEMENT_TYPE => ad_ddl.alter_table,

8817: BEGIN
8818: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_RES');
8819: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
8820: APPLICATION_SHORT_NAME => 'MSC',
8821: STATEMENT_TYPE => ad_ddl.alter_table,
8822: STATEMENT => l_sql_stmt,
8823: OBJECT_NAME => 'MSC_ATP_SUMMARY_RES');
8824: END;
8825: msc_util.msc_log('Truncate_Summ_Plan_Partition: ' || 'After truncating res partition');