APPS.ZX_TRL_PUB_PKG dependencies on ZX_REC_NREC_DIST

Line 1214: -- transaction line from zx_lines and zx_rec_nrec_dist.

1210: -- delete_tax_lines_and_dists
1211: --
1212: -- DESCRIPTION
1213: -- Delete all the detail tax lines and distributions of the passed-in
1214: -- transaction line from zx_lines and zx_rec_nrec_dist.
1215: ------------------------------------------------------------------------------
1216:
1217: PROCEDURE delete_tax_lines_and_dists
1218: (

Line 1252: DELETE FROM zx_rec_nrec_dist

1248: END IF;
1249: x_return_status := FND_API.G_RET_STS_SUCCESS;
1250:
1251: -- delete the distributions
1252: DELETE FROM zx_rec_nrec_dist
1253: WHERE application_id = p_application_id
1254: AND entity_code = p_entity_code
1255: AND event_class_code = p_event_class_code
1256: AND trx_id = p_trx_id

Line 1347: -- line from zx_rec_nrec_dist.

1343: -- delete_tax_dists
1344: --
1345: -- DESCRIPTION
1346: -- Delete all the detail tax distributions of the passed-in transaction
1347: -- line from zx_rec_nrec_dist.
1348: ------------------------------------------------------------------------------
1349:
1350: PROCEDURE delete_tax_dists
1351: (

Line 1373: DELETE FROM zx_rec_nrec_dist

1369: 'ZX_TRL_PUB_PKG: delete_tax_dists (+)');
1370: END IF;
1371: x_return_status := FND_API.G_RET_STS_SUCCESS;
1372:
1373: DELETE FROM zx_rec_nrec_dist
1374: WHERE application_id = p_application_id
1375: AND entity_code = p_entity_code
1376: AND event_class_code = p_event_class_code
1377: AND trx_id = p_trx_id

Line 1432: -- from ZX_REC_NREC_DIST while tax processing

1428: -- Check_Frozen_Tax_Dists
1429: --
1430: -- DESCRIPTION
1431: -- To run a validation to find if any frozen tax distribution is deleted
1432: -- from ZX_REC_NREC_DIST while tax processing
1433: ------------------------------------------------------------------------------
1434:
1435: PROCEDURE Check_Frozen_Tax_Dists
1436: (x_return_status OUT NOCOPY VARCHAR2,

Line 1464: FROM zx_rec_nrec_dist zd

1460: OR NVL(aid.match_status_flag,'N') IN ('A','T')
1461: OR NVL(aid.posted_flag,'N') = 'Y'
1462: OR NVL(aid.encumbered_flag, 'N') IN ('Y','D','W','X'))
1463: AND NOT EXISTS(SELECT /*+ NO_UNNEST */ 'Tax Distributions'
1464: FROM zx_rec_nrec_dist zd
1465: WHERE zd.rec_nrec_tax_dist_id = aid.detail_tax_dist_id
1466: AND NVL(zd.self_assessed_flag, 'N') = 'N');
1467:
1468: -- bug 14198788 driving queries from zx_trx_headers_gt

Line 1487: FROM zx_rec_nrec_dist zd

1483: OR NVL(asad.match_status_flag,'N') IN ('A','T')
1484: OR NVL(asad.posted_flag,'N') = 'Y'
1485: OR NVL(asad.encumbered_flag, 'N') IN ('Y','D','W','X'))
1486: AND NOT EXISTS(SELECT /*+ NO_UNNEST */ 'Tax Distributions'
1487: FROM zx_rec_nrec_dist zd
1488: WHERE zd.rec_nrec_tax_dist_id = asad.detail_tax_dist_id
1489: AND NVL(zd.self_assessed_flag, 'N') = 'Y');
1490:
1491: TYPE num_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 1549: 'Following frozen tax distributions deleted from ZX_REC_NREC_DIST:');

1545: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Check_Frozen_Tax_Dists',
1546: 'ERROR: '||l_error_buffer);
1547: FND_LOG.STRING(g_level_unexpected,
1548: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Check_Frozen_Tax_Dists',
1549: 'Following frozen tax distributions deleted from ZX_REC_NREC_DIST:');
1550: END IF;
1551:
1552: FOR i IN NVL(l_trx_id_tbl.FIRST,0)..NVL(l_trx_id_tbl.LAST,-99) LOOP
1553: IF l_prev_trx_id <> l_trx_id_tbl(i) THEN

Line 1597: 'Following self-assessed frozen tax distributions deleted from ZX_REC_NREC_DIST:');

1593: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Check_Frozen_Tax_Dists',
1594: 'ERROR: '||l_error_buffer);
1595: FND_LOG.STRING(g_level_unexpected,
1596: 'ZX.PLSQL.ZX_TRL_PUB_PKG.Check_Frozen_Tax_Dists',
1597: 'Following self-assessed frozen tax distributions deleted from ZX_REC_NREC_DIST:');
1598: END IF;
1599:
1600: FOR i IN NVL(l_trx_id_tbl.FIRST,0)..NVL(l_trx_id_tbl.LAST,-99) LOOP
1601: IF l_prev_trx_id <> l_trx_id_tbl(i) THEN