eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TRL_DISTRIBUTIONS_PKG dependencies on ZX_REC_NREC_DIST

Line 541: FROM ZX_REC_NREC_DIST

537: CREATION_DATE,
538: LAST_UPDATED_BY,
539: LAST_UPDATE_DATE,
540: LAST_UPDATE_LOGIN
541: FROM ZX_REC_NREC_DIST
542: WHERE REC_NREC_TAX_DIST_ID = p_rec_nrec_tax_dist_id;
543:
544: Recinfo dist_csr%ROWTYPE;
545:

Line 1244: 'Update ZX_REC_NREC_DIST (+)');

1240: 'l_unrounded_rec_nrec_tax_amt :'||l_unrounded_rec_nrec_tax_amt);
1241:
1242: FND_LOG.STRING(g_level_procedure,
1243: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Update_Row',
1244: 'Update ZX_REC_NREC_DIST (+)');
1245: END IF;
1246:
1247:
1248: -- Bug 5985143. In Determine_recovery call, update_taxline_rec_nrec_amt updates process_for_recovery_flag to 'N'.

Line 1257: WHERE (trx_id, trx_line_id) IN (SELECT trx_id, trx_line_id FROM zx_rec_nrec_dist WHERE REC_NREC_TAX_DIST_ID = p_rec_nrec_tax_dist_id)

1253:
1254:
1255: UPDATE ZX_LINES
1256: SET process_for_recovery_flag='Y'
1257: WHERE (trx_id, trx_line_id) IN (SELECT trx_id, trx_line_id FROM zx_rec_nrec_dist WHERE REC_NREC_TAX_DIST_ID = p_rec_nrec_tax_dist_id)
1258: AND application_id=p_application_id
1259: AND entity_code=p_entity_code
1260: AND event_class_code=p_event_class_code;
1261:

Line 1263: UPDATE ZX_REC_NREC_DIST

1259: AND entity_code=p_entity_code
1260: AND event_class_code=p_event_class_code;
1261:
1262:
1263: UPDATE ZX_REC_NREC_DIST
1264: SET orig_rec_nrec_rate = NVL(orig_rec_nrec_rate, rec_nrec_rate),
1265: orig_rec_rate_code = NVL(orig_rec_rate_code, recovery_rate_code),
1266: orig_rec_nrec_tax_amt = NVL(orig_rec_nrec_tax_amt, rec_nrec_tax_amt),
1267: orig_rec_nrec_tax_amt_tax_curr = NVL(orig_rec_nrec_tax_amt_tax_curr, rec_nrec_tax_amt_tax_curr),

Line 1281: 'Update ZX_REC_NREC_DIST (-)');

1277:
1278: IF (g_level_procedure >= g_current_runtime_level ) THEN
1279: FND_LOG.STRING(g_level_procedure,
1280: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Update_Row',
1281: 'Update ZX_REC_NREC_DIST (-)');
1282: END IF;
1283:
1284: IF (g_level_procedure >= g_current_runtime_level ) THEN
1285: FND_LOG.STRING(g_level_procedure,

Line 1287: 'Update for Non recoverable ZX_REC_NREC_DIST (+)');

1283:
1284: IF (g_level_procedure >= g_current_runtime_level ) THEN
1285: FND_LOG.STRING(g_level_procedure,
1286: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Update_Row',
1287: 'Update for Non recoverable ZX_REC_NREC_DIST (+)');
1288: END IF;
1289:
1290: l_rec_nrec_rate := 100 - p_rec_nrec_rate;
1291:

Line 1294: UPDATE ZX_REC_NREC_DIST

1290: l_rec_nrec_rate := 100 - p_rec_nrec_rate;
1291:
1292: l_unrounded_rec_nrec_tax_amt := (p_trx_line_dist_tax_amt * l_rec_nrec_rate)/100;
1293:
1294: UPDATE ZX_REC_NREC_DIST
1295: SET recovery_rate_code = NULL,
1296: rec_nrec_rate = l_rec_nrec_rate,
1297: unrounded_rec_nrec_tax_amt = l_unrounded_rec_nrec_tax_amt,
1298: orig_rec_nrec_rate = NVL(orig_rec_nrec_rate, rec_nrec_rate),

Line 1322: 'Update for Non recoverable ZX_REC_NREC_DIST (-)');

1318:
1319: IF (g_level_procedure >= g_current_runtime_level ) THEN
1320: FND_LOG.STRING(g_level_procedure,
1321: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Update_Row',
1322: 'Update for Non recoverable ZX_REC_NREC_DIST (-)');
1323: END IF;
1324:
1325: END IF; -- reverse flag
1326:

Line 1460: 'Insert into ZX_REC_NREC_DIST');

1456: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1457: FND_LOG.STRING(g_level_unexpected,
1458: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Reverse_Row',
1459: 'Incorrect return_status after calling ' ||
1460: 'Insert into ZX_REC_NREC_DIST');
1461: END IF;
1462:
1463: RETURN;
1464:

Line 1476: 'Delete from ZX_REC_NREC_DIST (+)');

1472:
1473: IF (g_level_procedure >= g_current_runtime_level ) THEN
1474: FND_LOG.STRING(g_level_procedure,
1475: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Reverse_Row',
1476: 'Delete from ZX_REC_NREC_DIST (+)');
1477: END IF;
1478:
1479: DELETE FROM ZX_REC_NREC_DIST
1480: WHERE REC_NREC_TAX_DIST_ID IN (SELECT TAX_DIST_ID

Line 1479: DELETE FROM ZX_REC_NREC_DIST

1475: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Reverse_Row',
1476: 'Delete from ZX_REC_NREC_DIST (+)');
1477: END IF;
1478:
1479: DELETE FROM ZX_REC_NREC_DIST
1480: WHERE REC_NREC_TAX_DIST_ID IN (SELECT TAX_DIST_ID
1481: FROM ZX_TAX_DIST_ID_GT);
1482:
1483: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 1486: 'Delete from ZX_REC_NREC_DIST (-)');

1482:
1483: IF (g_level_procedure >= g_current_runtime_level ) THEN
1484: FND_LOG.STRING(g_level_procedure,
1485: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Reverse_Row',
1486: 'Delete from ZX_REC_NREC_DIST (-)');
1487: END IF;
1488:
1489: IF (g_level_procedure >= g_current_runtime_level ) THEN
1490: FND_LOG.STRING(g_level_procedure,

Line 1492: 'Insert into ZX_REC_NREC_DIST (+)');

1488:
1489: IF (g_level_procedure >= g_current_runtime_level ) THEN
1490: FND_LOG.STRING(g_level_procedure,
1491: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Reverse_Row',
1492: 'Insert into ZX_REC_NREC_DIST (+)');
1493: END IF;
1494:
1495: FORALL i IN l_rec_nrec_dist_tbl.first..l_rec_nrec_dist_tbl.last
1496:

Line 1497: INSERT INTO ZX_REC_NREC_DIST VALUES l_rec_nrec_dist_tbl(i);

1493: END IF;
1494:
1495: FORALL i IN l_rec_nrec_dist_tbl.first..l_rec_nrec_dist_tbl.last
1496:
1497: INSERT INTO ZX_REC_NREC_DIST VALUES l_rec_nrec_dist_tbl(i);
1498:
1499: IF (g_level_procedure >= g_current_runtime_level ) THEN
1500: FND_LOG.STRING(g_level_procedure,
1501: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Reverse_Row',

Line 1502: 'Insert into ZX_REC_NREC_DIST (-)');

1498:
1499: IF (g_level_procedure >= g_current_runtime_level ) THEN
1500: FND_LOG.STRING(g_level_procedure,
1501: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Reverse_Row',
1502: 'Insert into ZX_REC_NREC_DIST (-)');
1503: END IF;
1504:
1505: IF (g_level_procedure >= g_current_runtime_level ) THEN
1506: FND_LOG.STRING(g_level_procedure,

Line 1543: FROM ZX_REC_NREC_DIST

1539: c_event_class_code VARCHAR2,
1540: c_entity_code VARCHAR2,
1541: c_trx_id NUMBER) IS
1542: SELECT *
1543: FROM ZX_REC_NREC_DIST
1544: WHERE application_id = c_application_id
1545: AND entity_code = c_entity_code
1546: AND event_class_code = c_event_class_code
1547: AND trx_id = c_trx_id