APPS.MSC_PURGE_LID dependencies on AD_DDL

Line 209: AD_DDL.DO_DDL( APPLSYS_SCHEMA => v_applsys_schema,

205:
206: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
207:
208:
209: AD_DDL.DO_DDL( APPLSYS_SCHEMA => v_applsys_schema,
210: APPLICATION_SHORT_NAME => lv_appl_short_nm,
211: STATEMENT_TYPE => AD_DDL.ALTER_TABLE,
212: STATEMENT => lv_sql_stmt,
213: OBJECT_NAME => p_table_name);

Line 211: STATEMENT_TYPE => AD_DDL.ALTER_TABLE,

207:
208:
209: AD_DDL.DO_DDL( APPLSYS_SCHEMA => v_applsys_schema,
210: APPLICATION_SHORT_NAME => lv_appl_short_nm,
211: STATEMENT_TYPE => AD_DDL.ALTER_TABLE,
212: STATEMENT => lv_sql_stmt,
213: OBJECT_NAME => p_table_name);
214:
215: ELSE

Line 2537: AD_DDL.DO_DDL( APPLSYS_SCHEMA => v_applsys_schema,

2533: lv_sql_stmt:= 'ALTER TABLE '||pTable_name
2534: ||' TRUNCATE PARTITION '||lv_partition_name;
2535:
2536: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
2537: AD_DDL.DO_DDL( APPLSYS_SCHEMA => v_applsys_schema,
2538: APPLICATION_SHORT_NAME => 'MSC',
2539: STATEMENT_TYPE => AD_DDL.ALTER_TABLE,
2540: STATEMENT => lv_sql_stmt,
2541: OBJECT_NAME => pTable_name);

Line 2539: STATEMENT_TYPE => AD_DDL.ALTER_TABLE,

2535:
2536: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,lv_sql_stmt);
2537: AD_DDL.DO_DDL( APPLSYS_SCHEMA => v_applsys_schema,
2538: APPLICATION_SHORT_NAME => 'MSC',
2539: STATEMENT_TYPE => AD_DDL.ALTER_TABLE,
2540: STATEMENT => lv_sql_stmt,
2541: OBJECT_NAME => pTable_name);
2542: lv_is_data_truncated := true;
2543: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,'Table ' || pTable_name || 'Partition ' || lv_partition_name || ' truncated ');