DBA Data[Home] [Help]

APPS.ZX_API_PUB dependencies on ZX_LINES_SUMMARY

Line 13479: FROM ZX_LINES_SUMMARY summ

13475: END IF;
13476:
13477: IF l_summarization_flag = 'Y' THEN
13478: DELETE
13479: FROM ZX_LINES_SUMMARY summ
13480: WHERE (APPLICATION_ID, ENTITY_CODE,EVENT_CLASS_CODE,TRX_ID)
13481: IN (SELECT /*+ INDEX (ZX_PURGE_TRANSACTIONS_GT ZX_PURGE_TRANSACTIONS_GT_U1)*/
13482: APPLICATION_ID,
13483: ENTITY_CODE,

Line 13492: 'Number of rows deleted from ZX_LINES_SUMMARY = '||to_char(l_row_count));

13488: IF SQL%FOUND THEN
13489: l_row_count := SQL%ROWCOUNT;
13490: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
13491: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name ,
13492: 'Number of rows deleted from ZX_LINES_SUMMARY = '||to_char(l_row_count));
13493: END IF;
13494: END IF;
13495: END IF; --summarization_flag is Y
13496: