APPS.ZX_API_PUB dependencies on ZX_REC_NREC_DIST

Line 4988: DELETE FROM ZX_REC_NREC_DIST_GT;

4984: --IF zx_global_structures_pkg.g_event_class_rec.record_flag = 'Y' AND ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec.quote_flag = 'N'
4985:
4986: --Reimplemented the fix done in bug#7506576
4987: IF l_record_dist_lines = 'Y' THEN
4988: DELETE FROM ZX_REC_NREC_DIST_GT;
4989: END IF;
4990:
4991: END LOOP;--event_classes cursor
4992:

Line 5346: FROM zx_rec_nrec_dist dist,

5342: 'UPDATE' tax_event_type_code,
5343: 'UPDATED' doc_status_code,
5344: evntcls.summarization_flag,
5345: evntcls.retain_summ_tax_line_id_flag
5346: FROM zx_rec_nrec_dist dist,
5347: zx_evnt_cls_mappings evntcls,
5348: zx_evnt_typ_mappings evnttyp,
5349: zx_tax_dist_id_gt distgt
5350: WHERE dist.application_id = evntcls.application_id

Line 5481: dist.trx_level_type from zx_rec_nrec_dist dist,

5477: AND ENTITY_CODE = p_transaction_rec.ENTITY_CODE
5478: AND EVENT_CLASS_CODE = p_transaction_rec.EVENT_CLASS_CODE
5479: -- AND TRX_ID = p_transaction_rec.TRX_ID
5480: AND (TRX_ID,TRX_LINE_ID,TRX_LEVEL_TYPE) IN (Select dist.trx_id, dist.trx_line_id,
5481: dist.trx_level_type from zx_rec_nrec_dist dist,
5482: zx_tax_dist_id_gt zxgt
5483: where dist.rec_nrec_tax_dist_id = zxgt.tax_dist_id);
5484:
5485: -- End Bug fix 5552750

Line 13499: FROM ZX_REC_NREC_DIST dist

13495: END IF; --summarization_flag is Y
13496:
13497: IF l_tax_recovery_flag ='Y' THEN
13498: DELETE
13499: FROM ZX_REC_NREC_DIST dist
13500: WHERE (APPLICATION_ID, ENTITY_CODE,EVENT_CLASS_CODE,TRX_ID)
13501: IN (SELECT /*+ INDEX (ZX_PURGE_TRANSACTIONS_GT ZX_PURGE_TRANSACTIONS_GT_U1)*/
13502: APPLICATION_ID,
13503: ENTITY_CODE,

Line 13513: 'Number of rows deleted from ZX_REC_NREC_DIST = '||to_char(l_row_count));

13509: IF SQL%FOUND THEN
13510: l_row_count := SQL%ROWCOUNT;
13511: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
13512: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name ,
13513: 'Number of rows deleted from ZX_REC_NREC_DIST = '||to_char(l_row_count));
13514: END IF;
13515: END IF;
13516: END IF; --tax recovery is Y
13517: