APPS.MSC_ATP_REFRESH_MVIEW dependencies on AD_DDL

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

646: --storage(INITIAL 40K NEXT 2M PCTINCREASE 0) LOCAL tablespace ' || l_tbspace(i);
647:
648: END IF;
649:
650: msc_util.msc_log('Before AD_DDL');
651: BEGIN
652: msc_util.msc_log('Before create table : ' ||l_temp_table(i));
653: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
654: APPLICATION_SHORT_NAME => l_apps_schema,

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

649:
650: msc_util.msc_log('Before AD_DDL');
651: BEGIN
652: msc_util.msc_log('Before create table : ' ||l_temp_table(i));
653: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
654: APPLICATION_SHORT_NAME => l_apps_schema,
655: STATEMENT_TYPE => ad_ddl.create_table,
656: STATEMENT => sql_stmt1,
657: OBJECT_NAME => l_temp_table(i));

Line 655: STATEMENT_TYPE => ad_ddl.create_table,

651: BEGIN
652: msc_util.msc_log('Before create table : ' ||l_temp_table(i));
653: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
654: APPLICATION_SHORT_NAME => l_apps_schema,
655: STATEMENT_TYPE => ad_ddl.create_table,
656: STATEMENT => sql_stmt1,
657: OBJECT_NAME => l_temp_table(i));
658: EXCEPTION
659: WHEN others THEN

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

667: ELSE
668: msc_util.msc_log(sqlerrm);
669: msc_util.msc_log('Inside Exception of create table : ' ||l_temp_table(i));
670:
671: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
672: APPLICATION_SHORT_NAME => l_apps_schema,
673: STATEMENT_TYPE => ad_ddl.drop_table,
674: STATEMENT => 'DROP TABLE ' || l_temp_table(i),
675: OBJECT_NAME => l_temp_table(i));

Line 673: STATEMENT_TYPE => ad_ddl.drop_table,

669: msc_util.msc_log('Inside Exception of create table : ' ||l_temp_table(i));
670:
671: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
672: APPLICATION_SHORT_NAME => l_apps_schema,
673: STATEMENT_TYPE => ad_ddl.drop_table,
674: STATEMENT => 'DROP TABLE ' || l_temp_table(i),
675: OBJECT_NAME => l_temp_table(i));
676:
677: msc_util.msc_log('After Drop table : ' ||l_temp_table(i));

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

674: STATEMENT => 'DROP TABLE ' || l_temp_table(i),
675: OBJECT_NAME => l_temp_table(i));
676:
677: msc_util.msc_log('After Drop table : ' ||l_temp_table(i));
678: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
679: APPLICATION_SHORT_NAME => l_apps_schema,
680: STATEMENT_TYPE => ad_ddl.create_table,
681: STATEMENT => sql_stmt1,
682: OBJECT_NAME => l_temp_table(i));

Line 680: STATEMENT_TYPE => ad_ddl.create_table,

676:
677: msc_util.msc_log('After Drop table : ' ||l_temp_table(i));
678: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
679: APPLICATION_SHORT_NAME => l_apps_schema,
680: STATEMENT_TYPE => ad_ddl.create_table,
681: STATEMENT => sql_stmt1,
682: OBJECT_NAME => l_temp_table(i));
683: msc_util.msc_log('After create table : ' ||l_temp_table(i));
684:

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

686: END;
687:
688: BEGIN
689: msc_util.msc_log('Before create index : ' ||l_temp_table(i));
690: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
691: APPLICATION_SHORT_NAME => l_apps_schema,
692: STATEMENT_TYPE => ad_ddl.create_index,
693: STATEMENT => sql_stmt2,
694: OBJECT_NAME => l_temp_table(i));

Line 692: STATEMENT_TYPE => ad_ddl.create_index,

688: BEGIN
689: msc_util.msc_log('Before create index : ' ||l_temp_table(i));
690: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
691: APPLICATION_SHORT_NAME => l_apps_schema,
692: STATEMENT_TYPE => ad_ddl.create_index,
693: STATEMENT => sql_stmt2,
694: OBJECT_NAME => l_temp_table(i));
695: EXCEPTION
696: WHEN others THEN

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

726: ' including indexes without validation';
727:
728: BEGIN
729: msc_util.msc_log('Before alter table : ' ||l_cur_table(i));
730: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
731: APPLICATION_SHORT_NAME => l_apps_schema,
732: STATEMENT_TYPE => ad_ddl.alter_table,
733: STATEMENT => sql_stmt1,
734: OBJECT_NAME => l_cur_table(i));

Line 732: STATEMENT_TYPE => ad_ddl.alter_table,

728: BEGIN
729: msc_util.msc_log('Before alter table : ' ||l_cur_table(i));
730: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
731: APPLICATION_SHORT_NAME => l_apps_schema,
732: STATEMENT_TYPE => ad_ddl.alter_table,
733: STATEMENT => sql_stmt1,
734: OBJECT_NAME => l_cur_table(i));
735: EXCEPTION
736: WHEN others THEN

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

745: sql_stmt2 := 'DROP TABLE ' || l_temp_table(i);
746:
747: BEGIN
748: msc_util.msc_log('Before drop table : ' ||l_temp_table(i));
749: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
750: APPLICATION_SHORT_NAME => l_apps_schema,
751: STATEMENT_TYPE => ad_ddl.drop_table,
752: STATEMENT => sql_stmt2,
753: OBJECT_NAME => l_temp_table(i));

Line 751: STATEMENT_TYPE => ad_ddl.drop_table,

747: BEGIN
748: msc_util.msc_log('Before drop table : ' ||l_temp_table(i));
749: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
750: APPLICATION_SHORT_NAME => l_apps_schema,
751: STATEMENT_TYPE => ad_ddl.drop_table,
752: STATEMENT => sql_stmt2,
753: OBJECT_NAME => l_temp_table(i));
754: EXCEPTION
755: WHEN others THEN

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

779: WHILE i IS NOT NULL LOOP
780:
781: sql_stmt2 := 'DROP TABLE ' || l_temp_table(i);
782: BEGIN
783: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
784: APPLICATION_SHORT_NAME => l_apps_schema,
785: STATEMENT_TYPE => ad_ddl.drop_table,
786: STATEMENT => sql_stmt2,
787: OBJECT_NAME => l_temp_table(i));

Line 785: STATEMENT_TYPE => ad_ddl.drop_table,

781: sql_stmt2 := 'DROP TABLE ' || l_temp_table(i);
782: BEGIN
783: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
784: APPLICATION_SHORT_NAME => l_apps_schema,
785: STATEMENT_TYPE => ad_ddl.drop_table,
786: STATEMENT => sql_stmt2,
787: OBJECT_NAME => l_temp_table(i));
788: EXCEPTION
789: WHEN OTHERS THEN