APPS.MSC_CL_EXCHANGE_PARTTBL dependencies on AD_DDL

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

322:
323: IF lv_object_exist=SYS_YES THEN
324: v_sql_stmt := 'DROP TABLE '||pTableName;
325:
326: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
327: application_short_name => 'MSC',
328: statement_type => AD_DDL.DROP_TABLE,
329: statement => v_sql_stmt,
330: object_name => pTableName);

Line 328: statement_type => AD_DDL.DROP_TABLE,

324: v_sql_stmt := 'DROP TABLE '||pTableName;
325:
326: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
327: application_short_name => 'MSC',
328: statement_type => AD_DDL.DROP_TABLE,
329: statement => v_sql_stmt,
330: object_name => pTableName);
331: END IF;
332:

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

340:
341: IF lv_object_exist=SYS_YES THEN
342: v_sql_stmt := 'DROP VIEW '||pTableName;
343:
344: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
345: application_short_name => 'MSC',
346: statement_type => AD_DDL.DROP_VIEW,
347: statement => v_sql_stmt,
348: object_name => pTableName);

Line 346: statement_type => AD_DDL.DROP_VIEW,

342: v_sql_stmt := 'DROP VIEW '||pTableName;
343:
344: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
345: application_short_name => 'MSC',
346: statement_type => AD_DDL.DROP_VIEW,
347: statement => v_sql_stmt,
348: object_name => pTableName);
349: END IF;
350:

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

498: ||' WHERE NULL=NULL';
499:
500:
501:
502: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
503: application_short_name => 'MSC',
504: statement_type => AD_DDL.CREATE_TABLE,
505: statement => v_sql_stmt,
506: object_name => pTmpTableName);

Line 504: statement_type => AD_DDL.CREATE_TABLE,

500:
501:
502: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
503: application_short_name => 'MSC',
504: statement_type => AD_DDL.CREATE_TABLE,
505: statement => v_sql_stmt,
506: object_name => pTmpTableName);
507:
508: --trc('en:Create_Temp_Tab_PVT');

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

945:
946: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'exchange part:-'||v_sql_stmt);
947:
948: /* execute the sql statement */
949: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
950: application_short_name => 'MSC',
951: statement_type => AD_DDL.ALTER_TABLE,
952: statement => v_sql_stmt,
953: object_name => pPartitionedTableName);

Line 951: statement_type => AD_DDL.ALTER_TABLE,

947:
948: /* execute the sql statement */
949: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
950: application_short_name => 'MSC',
951: statement_type => AD_DDL.ALTER_TABLE,
952: statement => v_sql_stmt,
953: object_name => pPartitionedTableName);
954:
955: trc('en:EXCHANGE_SINGLE_TAB_PARTN' || pPartitionedTableName);

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

2013: /* execute the sql statement */
2014:
2015: BEGIN
2016: /* create index */
2017: ad_ddl.do_ddl(applsys_schema => v_applsys_schema,
2018: application_short_name => 'MSC',
2019: statement_type => AD_DDL.CREATE_INDEX,
2020: statement => v_sql_stmt,
2021: object_name => lv_temp_index_name);

Line 2019: statement_type => AD_DDL.CREATE_INDEX,

2015: BEGIN
2016: /* create index */
2017: ad_ddl.do_ddl(applsys_schema => v_applsys_schema,
2018: application_short_name => 'MSC',
2019: statement_type => AD_DDL.CREATE_INDEX,
2020: statement => v_sql_stmt,
2021: object_name => lv_temp_index_name);
2022: EXCEPTION
2023: WHEN OTHERS THEN

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

2092: EXECUTE IMMEDIATE lv_sql_stmt4;
2093: COMMIT;
2094:
2095: BEGIN
2096: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2097: application_short_name => 'MSC',
2098: statement_type => AD_DDL.CREATE_INDEX,
2099: statement => v_sql_stmt,
2100: object_name => lv_temp_index_name);

Line 2098: statement_type => AD_DDL.CREATE_INDEX,

2094:
2095: BEGIN
2096: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2097: application_short_name => 'MSC',
2098: statement_type => AD_DDL.CREATE_INDEX,
2099: statement => v_sql_stmt,
2100: object_name => lv_temp_index_name);
2101: EXCEPTION
2102: WHEN OTHERS THEN