APPS.ZX_API_PUB dependencies on ZX_LINES_SUMMARY

Line 3185: UPDATE ZX_LINES_SUMMARY

3181: AND EVENT_CLASS_CODE = p_sync_trx_rec.EVENT_CLASS_CODE
3182: AND TRX_ID = p_sync_trx_rec.TRX_ID;
3183:
3184: IF (l_event_class_rec.prod_family_grp_code = 'P2P') THEN
3185: UPDATE ZX_LINES_SUMMARY
3186: SET TRX_NUMBER = p_sync_trx_rec.TRX_NUMBER
3187: WHERE APPLICATION_ID = p_sync_trx_rec.APPLICATION_ID
3188: AND ENTITY_CODE = p_sync_trx_rec.ENTITY_CODE
3189: AND EVENT_CLASS_CODE = p_sync_trx_rec.EVENT_CLASS_CODE

Line 3280: UPDATE ZX_LINES_SUMMARY

3276: AND EVENT_CLASS_CODE = p_sync_trx_rec.EVENT_CLASS_CODE
3277: AND TRX_ID = p_sync_trx_rec.TRX_ID;
3278:
3279: IF (l_event_class_rec.prod_family_grp_code = 'P2P') THEN
3280: UPDATE ZX_LINES_SUMMARY
3281: SET TRX_NUMBER = p_sync_trx_rec.TRX_NUMBER
3282: WHERE APPLICATION_ID = p_sync_trx_rec.APPLICATION_ID
3283: AND ENTITY_CODE = p_sync_trx_rec.ENTITY_CODE
3284: AND EVENT_CLASS_CODE = p_sync_trx_rec.EVENT_CLASS_CODE

Line 14654: FROM ZX_LINES_SUMMARY summ

14650: END IF;
14651:
14652: IF l_summarization_flag = 'Y' THEN
14653: DELETE
14654: FROM ZX_LINES_SUMMARY summ
14655: WHERE (APPLICATION_ID, ENTITY_CODE,EVENT_CLASS_CODE,TRX_ID)
14656: IN (SELECT /*+ INDEX (ZX_PURGE_TRANSACTIONS_GT ZX_PURGE_TRANSACTIONS_GT_U1)*/
14657: APPLICATION_ID,
14658: ENTITY_CODE,

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

14663: IF SQL%FOUND THEN
14664: l_row_count := SQL%ROWCOUNT;
14665: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
14666: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name ,
14667: 'Number of rows deleted from ZX_LINES_SUMMARY = '||to_char(l_row_count));
14668: END IF;
14669: END IF;
14670: END IF; --summarization_flag is Y
14671: