APPS.MSC_ATP_REFRESH_MVIEW dependencies on AD_DDL

Line 643: msc_util.msc_log('Before AD_DDL');

639: --storage(INITIAL 40K NEXT 2M PCTINCREASE 0) LOCAL tablespace ' || l_tbspace(i);
640:
641: END IF;
642:
643: msc_util.msc_log('Before AD_DDL');
644: BEGIN
645: msc_util.msc_log('Before create table : ' ||l_temp_table(i));
646: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
647: APPLICATION_SHORT_NAME => 'MSC',

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

642:
643: msc_util.msc_log('Before AD_DDL');
644: BEGIN
645: msc_util.msc_log('Before create table : ' ||l_temp_table(i));
646: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
647: APPLICATION_SHORT_NAME => 'MSC',
648: STATEMENT_TYPE => ad_ddl.create_table,
649: STATEMENT => sql_stmt1,
650: OBJECT_NAME => l_temp_table(i));

Line 648: STATEMENT_TYPE => ad_ddl.create_table,

644: BEGIN
645: msc_util.msc_log('Before create table : ' ||l_temp_table(i));
646: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
647: APPLICATION_SHORT_NAME => 'MSC',
648: STATEMENT_TYPE => ad_ddl.create_table,
649: STATEMENT => sql_stmt1,
650: OBJECT_NAME => l_temp_table(i));
651: EXCEPTION
652: WHEN others THEN

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

652: WHEN others THEN
653:
654: msc_util.msc_log(sqlerrm);
655: msc_util.msc_log('Inside Exception of create table : ' ||l_temp_table(i));
656: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
657: APPLICATION_SHORT_NAME => 'MSC',
658: STATEMENT_TYPE => ad_ddl.drop_table,
659: STATEMENT => 'DROP TABLE ' || l_temp_table(i),
660: OBJECT_NAME => l_temp_table(i));

Line 658: STATEMENT_TYPE => ad_ddl.drop_table,

654: msc_util.msc_log(sqlerrm);
655: msc_util.msc_log('Inside Exception of create table : ' ||l_temp_table(i));
656: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
657: APPLICATION_SHORT_NAME => 'MSC',
658: STATEMENT_TYPE => ad_ddl.drop_table,
659: STATEMENT => 'DROP TABLE ' || l_temp_table(i),
660: OBJECT_NAME => l_temp_table(i));
661:
662: msc_util.msc_log('After Drop table : ' ||l_temp_table(i));

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

659: STATEMENT => 'DROP TABLE ' || l_temp_table(i),
660: OBJECT_NAME => l_temp_table(i));
661:
662: msc_util.msc_log('After Drop table : ' ||l_temp_table(i));
663: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
664: APPLICATION_SHORT_NAME => 'MSC',
665: STATEMENT_TYPE => ad_ddl.create_table,
666: STATEMENT => sql_stmt1,
667: OBJECT_NAME => l_temp_table(i));

Line 665: STATEMENT_TYPE => ad_ddl.create_table,

661:
662: msc_util.msc_log('After Drop table : ' ||l_temp_table(i));
663: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
664: APPLICATION_SHORT_NAME => 'MSC',
665: STATEMENT_TYPE => ad_ddl.create_table,
666: STATEMENT => sql_stmt1,
667: OBJECT_NAME => l_temp_table(i));
668: msc_util.msc_log('After create table : ' ||l_temp_table(i));
669: END;

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

669: END;
670:
671: BEGIN
672: msc_util.msc_log('Before create index : ' ||l_temp_table(i));
673: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
674: APPLICATION_SHORT_NAME => 'MSC',
675: STATEMENT_TYPE => ad_ddl.create_index,
676: STATEMENT => sql_stmt2,
677: OBJECT_NAME => l_temp_table(i));

Line 675: STATEMENT_TYPE => ad_ddl.create_index,

671: BEGIN
672: msc_util.msc_log('Before create index : ' ||l_temp_table(i));
673: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
674: APPLICATION_SHORT_NAME => 'MSC',
675: STATEMENT_TYPE => ad_ddl.create_index,
676: STATEMENT => sql_stmt2,
677: OBJECT_NAME => l_temp_table(i));
678: EXCEPTION
679: WHEN others THEN

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

709: ' including indexes without validation';
710:
711: BEGIN
712: msc_util.msc_log('Before alter table : ' ||l_cur_table(i));
713: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
714: APPLICATION_SHORT_NAME => 'MSC',
715: STATEMENT_TYPE => ad_ddl.alter_table,
716: STATEMENT => sql_stmt1,
717: OBJECT_NAME => l_cur_table(i));

Line 715: STATEMENT_TYPE => ad_ddl.alter_table,

711: BEGIN
712: msc_util.msc_log('Before alter table : ' ||l_cur_table(i));
713: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
714: APPLICATION_SHORT_NAME => 'MSC',
715: STATEMENT_TYPE => ad_ddl.alter_table,
716: STATEMENT => sql_stmt1,
717: OBJECT_NAME => l_cur_table(i));
718: EXCEPTION
719: WHEN others THEN

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

728: sql_stmt2 := 'DROP TABLE ' || l_temp_table(i);
729:
730: BEGIN
731: msc_util.msc_log('Before drop table : ' ||l_temp_table(i));
732: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
733: APPLICATION_SHORT_NAME => 'MSC',
734: STATEMENT_TYPE => ad_ddl.drop_table,
735: STATEMENT => sql_stmt2,
736: OBJECT_NAME => l_temp_table(i));

Line 734: STATEMENT_TYPE => ad_ddl.drop_table,

730: BEGIN
731: msc_util.msc_log('Before drop table : ' ||l_temp_table(i));
732: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
733: APPLICATION_SHORT_NAME => 'MSC',
734: STATEMENT_TYPE => ad_ddl.drop_table,
735: STATEMENT => sql_stmt2,
736: OBJECT_NAME => l_temp_table(i));
737: EXCEPTION
738: WHEN others THEN

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

762: WHILE i IS NOT NULL LOOP
763:
764: sql_stmt2 := 'DROP TABLE ' || l_temp_table(i);
765: BEGIN
766: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
767: APPLICATION_SHORT_NAME => 'MSC',
768: STATEMENT_TYPE => ad_ddl.drop_table,
769: STATEMENT => sql_stmt2,
770: OBJECT_NAME => l_temp_table(i));

Line 768: STATEMENT_TYPE => ad_ddl.drop_table,

764: sql_stmt2 := 'DROP TABLE ' || l_temp_table(i);
765: BEGIN
766: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
767: APPLICATION_SHORT_NAME => 'MSC',
768: STATEMENT_TYPE => ad_ddl.drop_table,
769: STATEMENT => sql_stmt2,
770: OBJECT_NAME => l_temp_table(i));
771: EXCEPTION
772: WHEN OTHERS THEN