APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on AD_DDL

Line 225: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

221:
222: IF lv_table_exist=SYS_YES THEN
223: v_sql_stmt := 'DROP TABLE '||pTableName;
224:
225: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
226: application_short_name => 'MSC',
227: statement_type => AD_DDL.DROP_TABLE,
228: statement => v_sql_stmt,
229: object_name => pTableName);

Line 227: statement_type => AD_DDL.DROP_TABLE,

223: v_sql_stmt := 'DROP TABLE '||pTableName;
224:
225: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
226: application_short_name => 'MSC',
227: statement_type => AD_DDL.DROP_TABLE,
228: statement => v_sql_stmt,
229: object_name => pTableName);
230: END IF;
231:

Line 382: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

378: ||' WHERE NULL=NULL';
379:
380:
381:
382: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
383: application_short_name => 'MSC',
384: statement_type => AD_DDL.CREATE_TABLE,
385: statement => v_sql_stmt,
386: object_name => pTmpTableName);

Line 384: statement_type => AD_DDL.CREATE_TABLE,

380:
381:
382: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
383: application_short_name => 'MSC',
384: statement_type => AD_DDL.CREATE_TABLE,
385: statement => v_sql_stmt,
386: object_name => pTmpTableName);
387:
388: --trc('en:Create_Temp_Tab_PVT');

Line 821: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

817:
818: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'exchange part:-'||v_sql_stmt);
819:
820: /* execute the sql statement */
821: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
822: application_short_name => 'MSC',
823: statement_type => AD_DDL.ALTER_TABLE,
824: statement => v_sql_stmt,
825: object_name => pPartitionedTableName);

Line 823: statement_type => AD_DDL.ALTER_TABLE,

819:
820: /* execute the sql statement */
821: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
822: application_short_name => 'MSC',
823: statement_type => AD_DDL.ALTER_TABLE,
824: statement => v_sql_stmt,
825: object_name => pPartitionedTableName);
826:
827: trc('en:EXCHANGE_SINGLE_TAB_PARTN' || pPartitionedTableName);

Line 1745: ad_ddl.do_ddl(applsys_schema => v_applsys_schema,

1741: /* execute the sql statement */
1742:
1743: BEGIN
1744: /* create index */
1745: ad_ddl.do_ddl(applsys_schema => v_applsys_schema,
1746: application_short_name => 'MSC',
1747: statement_type => AD_DDL.CREATE_INDEX,
1748: statement => v_sql_stmt,
1749: object_name => lv_temp_index_name);

Line 1747: statement_type => AD_DDL.CREATE_INDEX,

1743: BEGIN
1744: /* create index */
1745: ad_ddl.do_ddl(applsys_schema => v_applsys_schema,
1746: application_short_name => 'MSC',
1747: statement_type => AD_DDL.CREATE_INDEX,
1748: statement => v_sql_stmt,
1749: object_name => lv_temp_index_name);
1750: EXCEPTION
1751: WHEN OTHERS THEN

Line 1824: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

1820: EXECUTE IMMEDIATE lv_sql_stmt4;
1821: COMMIT;
1822:
1823: BEGIN
1824: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1825: application_short_name => 'MSC',
1826: statement_type => AD_DDL.CREATE_INDEX,
1827: statement => v_sql_stmt,
1828: object_name => lv_temp_index_name);

Line 1826: statement_type => AD_DDL.CREATE_INDEX,

1822:
1823: BEGIN
1824: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1825: application_short_name => 'MSC',
1826: statement_type => AD_DDL.CREATE_INDEX,
1827: statement => v_sql_stmt,
1828: object_name => lv_temp_index_name);
1829: EXCEPTION
1830: WHEN OTHERS THEN