APPS.ZX_API_PUB dependencies on ZX_REC_NREC_DIST

Line 3192: UPDATE ZX_REC_NREC_DIST

3188: AND ENTITY_CODE = p_sync_trx_rec.ENTITY_CODE
3189: AND EVENT_CLASS_CODE = p_sync_trx_rec.EVENT_CLASS_CODE
3190: AND TRX_ID = p_sync_trx_rec.TRX_ID;
3191:
3192: UPDATE ZX_REC_NREC_DIST
3193: SET TRX_NUMBER = p_sync_trx_rec.TRX_NUMBER
3194: WHERE APPLICATION_ID = p_sync_trx_rec.APPLICATION_ID
3195: AND ENTITY_CODE = p_sync_trx_rec.ENTITY_CODE
3196: AND EVENT_CLASS_CODE = p_sync_trx_rec.EVENT_CLASS_CODE

Line 3287: UPDATE ZX_REC_NREC_DIST

3283: AND ENTITY_CODE = p_sync_trx_rec.ENTITY_CODE
3284: AND EVENT_CLASS_CODE = p_sync_trx_rec.EVENT_CLASS_CODE
3285: AND TRX_ID = p_sync_trx_rec.TRX_ID;
3286:
3287: UPDATE ZX_REC_NREC_DIST
3288: SET TRX_NUMBER = p_sync_trx_rec.TRX_NUMBER
3289: WHERE APPLICATION_ID = p_sync_trx_rec.APPLICATION_ID
3290: AND ENTITY_CODE = p_sync_trx_rec.ENTITY_CODE
3291: AND EVENT_CLASS_CODE = p_sync_trx_rec.EVENT_CLASS_CODE

Line 5792: DELETE FROM ZX_REC_NREC_DIST_GT;

5788: --IF zx_global_structures_pkg.g_event_class_rec.record_flag = 'Y' AND ZX_GLOBAL_STRUCTURES_PKG.g_event_class_rec.quote_flag = 'N'
5789:
5790: --Reimplemented the fix done in bug#7506576
5791: IF l_record_dist_lines = 'Y' THEN
5792: DELETE FROM ZX_REC_NREC_DIST_GT;
5793: END IF;
5794:
5795: END LOOP;--event_classes cursor
5796:

Line 6304: FROM zx_rec_nrec_dist dist,

6300: 'UPDATE' tax_event_type_code,
6301: 'UPDATED' doc_status_code,
6302: evntcls.summarization_flag,
6303: evntcls.retain_summ_tax_line_id_flag
6304: FROM zx_rec_nrec_dist dist,
6305: zx_evnt_cls_mappings evntcls,
6306: zx_evnt_typ_mappings evnttyp,
6307: zx_tax_dist_id_gt distgt
6308: WHERE dist.application_id = evntcls.application_id

Line 6439: dist.trx_level_type from zx_rec_nrec_dist dist,

6435: AND ENTITY_CODE = p_transaction_rec.ENTITY_CODE
6436: AND EVENT_CLASS_CODE = p_transaction_rec.EVENT_CLASS_CODE
6437: -- AND TRX_ID = p_transaction_rec.TRX_ID
6438: AND (TRX_ID,TRX_LINE_ID,TRX_LEVEL_TYPE) IN (Select dist.trx_id, dist.trx_line_id,
6439: dist.trx_level_type from zx_rec_nrec_dist dist,
6440: zx_tax_dist_id_gt zxgt
6441: where dist.rec_nrec_tax_dist_id = zxgt.tax_dist_id);
6442:
6443: -- End Bug fix 5552750

Line 14674: FROM ZX_REC_NREC_DIST dist

14670: END IF; --summarization_flag is Y
14671:
14672: IF l_tax_recovery_flag ='Y' THEN
14673: DELETE
14674: FROM ZX_REC_NREC_DIST dist
14675: WHERE (APPLICATION_ID, ENTITY_CODE,EVENT_CLASS_CODE,TRX_ID)
14676: IN (SELECT /*+ INDEX (ZX_PURGE_TRANSACTIONS_GT ZX_PURGE_TRANSACTIONS_GT_U1)*/
14677: APPLICATION_ID,
14678: ENTITY_CODE,

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

14684: IF SQL%FOUND THEN
14685: l_row_count := SQL%ROWCOUNT;
14686: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
14687: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name ,
14688: 'Number of rows deleted from ZX_REC_NREC_DIST = '||to_char(l_row_count));
14689: END IF;
14690: END IF;
14691: END IF; --tax recovery is Y
14692: