DBA Data[Home] [Help]

APPS.ZX_TRL_DISTRIBUTIONS_PKG dependencies on ZX_TAX_DIST_ID_GT

Line 1226: 'Update for reverse dist ZX_TAX_DIST_ID_GT (+)');

1222:
1223: IF (g_level_procedure >= g_current_runtime_level ) THEN
1224: FND_LOG.STRING(g_level_procedure,
1225: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Update_Row',
1226: 'Update for reverse dist ZX_TAX_DIST_ID_GT (+)');
1227: END IF;
1228:
1229: IF p_reverse_flag = 'Y' THEN
1230:

Line 1231: INSERT INTO ZX_TAX_DIST_ID_GT (TAX_DIST_ID) VALUES (p_rec_nrec_tax_dist_id);

1227: END IF;
1228:
1229: IF p_reverse_flag = 'Y' THEN
1230:
1231: INSERT INTO ZX_TAX_DIST_ID_GT (TAX_DIST_ID) VALUES (p_rec_nrec_tax_dist_id);
1232:
1233: ELSE
1234:
1235: l_unrounded_rec_nrec_tax_amt := (p_trx_line_dist_tax_amt * p_rec_nrec_rate)/100;

Line 1330: 'Update for reverse dist ZX_TAX_DIST_ID_GT (-)');

1326:
1327: IF (g_level_procedure >= g_current_runtime_level ) THEN
1328: FND_LOG.STRING(g_level_procedure,
1329: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Update_Row',
1330: 'Update for reverse dist ZX_TAX_DIST_ID_GT (-)');
1331: END IF;
1332:
1333: IF (g_level_procedure >= g_current_runtime_level ) THEN
1334: FND_LOG.STRING(g_level_procedure,

Line 1441: FROM ZX_TAX_DIST_ID_GT;

1437: END IF;
1438:
1439: SELECT count(*)
1440: INTO l_tax_dist
1441: FROM ZX_TAX_DIST_ID_GT;
1442:
1443: IF l_tax_dist > 0 THEN
1444: BEGIN
1445:

Line 1481: FROM ZX_TAX_DIST_ID_GT);

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
1484: FND_LOG.STRING(g_level_procedure,
1485: 'ZX.PLSQL.ZX_TRL_DISTRIBUTIONS_PKG.Reverse_Row',