DBA Data[Home] [Help]

APPS.IEX_UWQ_POP_SUM_TBL_PVT dependencies on AD_DDL

Line 474: ad_ddl.do_ddl( l_out_oracle_schema,

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' );

Line 476: AD_DDL.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' );
479:
480: LogMessage(FND_LOG.LEVEL_STATEMENT,'Truncated IEX_DLN_UWQ_SUMMARY');

Line 536: ad_ddl.do_ddl( l_out_oracle_schema,

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' );

Line 538: AD_DDL.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' );
541:
542: LogMessage(FND_LOG.LEVEL_STATEMENT,'Truncated IEX_DLN_UWQ_SUMMARY');

Line 589: ad_ddl.do_ddl( l_out_oracle_schema,

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' );

Line 591: AD_DDL.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' );
594:
595: LogMessage(FND_LOG.LEVEL_STATEMENT,'Truncated IEX_DLN_UWQ_SUMMARY');