470: CLOSE c_get_table;
471: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'truncate table ' || l_truncate_table);
472: EXECUTE IMMEDIATE 'truncate table ' || l_truncate_table;*/
473: LogMessage(FND_LOG.LEVEL_STATEMENT,'Truncating IEX_DLN_UWQ_SUMMARY');
474: ad_ddl.do_ddl( l_out_oracle_schema,
475: 'IEX',
476: AD_DDL.TRUNCATE_TABLE,
477: 'TRUNCATE TABLE IEX_DLN_UWQ_SUMMARY',
478: 'IEX_DLN_UWQ_SUMMARY' );
472: EXECUTE IMMEDIATE 'truncate table ' || l_truncate_table;*/
473: LogMessage(FND_LOG.LEVEL_STATEMENT,'Truncating IEX_DLN_UWQ_SUMMARY');
474: ad_ddl.do_ddl( l_out_oracle_schema,
475: 'IEX',
476: AD_DDL.TRUNCATE_TABLE,
477: 'TRUNCATE TABLE IEX_DLN_UWQ_SUMMARY',
478: 'IEX_DLN_UWQ_SUMMARY' );
479:
480: LogMessage(FND_LOG.LEVEL_STATEMENT,'Truncated IEX_DLN_UWQ_SUMMARY');
532: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'truncate table ' || l_truncate_table);
533: EXECUTE IMMEDIATE 'truncate table ' || l_truncate_table;
534: LogMessage(FND_LOG.LEVEL_STATEMENT,'Truncated whole table');*/
535: LogMessage(FND_LOG.LEVEL_STATEMENT,'Truncating IEX_DLN_UWQ_SUMMARY');
536: ad_ddl.do_ddl( l_out_oracle_schema,
537: 'IEX',
538: AD_DDL.TRUNCATE_TABLE,
539: 'TRUNCATE TABLE IEX_DLN_UWQ_SUMMARY',
540: 'IEX_DLN_UWQ_SUMMARY' );
534: LogMessage(FND_LOG.LEVEL_STATEMENT,'Truncated whole table');*/
535: LogMessage(FND_LOG.LEVEL_STATEMENT,'Truncating IEX_DLN_UWQ_SUMMARY');
536: ad_ddl.do_ddl( l_out_oracle_schema,
537: 'IEX',
538: AD_DDL.TRUNCATE_TABLE,
539: 'TRUNCATE TABLE IEX_DLN_UWQ_SUMMARY',
540: 'IEX_DLN_UWQ_SUMMARY' );
541:
542: LogMessage(FND_LOG.LEVEL_STATEMENT,'Truncated IEX_DLN_UWQ_SUMMARY');
585: LogMessage(FND_LOG.LEVEL_UNEXPECTED,'truncate table ' || l_truncate_table);
586: EXECUTE IMMEDIATE 'truncate table ' || l_truncate_table;
587: LogMessage(FND_LOG.LEVEL_STATEMENT,'Truncated whole table');*/
588: LogMessage(FND_LOG.LEVEL_STATEMENT,'Truncating IEX_DLN_UWQ_SUMMARY');
589: ad_ddl.do_ddl( l_out_oracle_schema,
590: 'IEX',
591: AD_DDL.TRUNCATE_TABLE,
592: 'TRUNCATE TABLE IEX_DLN_UWQ_SUMMARY',
593: 'IEX_DLN_UWQ_SUMMARY' );
587: LogMessage(FND_LOG.LEVEL_STATEMENT,'Truncated whole table');*/
588: LogMessage(FND_LOG.LEVEL_STATEMENT,'Truncating IEX_DLN_UWQ_SUMMARY');
589: ad_ddl.do_ddl( l_out_oracle_schema,
590: 'IEX',
591: AD_DDL.TRUNCATE_TABLE,
592: 'TRUNCATE TABLE IEX_DLN_UWQ_SUMMARY',
593: 'IEX_DLN_UWQ_SUMMARY' );
594:
595: LogMessage(FND_LOG.LEVEL_STATEMENT,'Truncated IEX_DLN_UWQ_SUMMARY');