[Home] [Help]
1000: -- AND NVL(hdr_trx_user_key4, 'X') = NVL(p_event_class_rec.hdr_trx_user_key4, 'X')
1001: -- AND NVL(hdr_trx_user_key5, 'X') = NVL(p_event_class_rec.hdr_trx_user_key5, 'X')
1002: -- AND NVL(hdr_trx_user_key6, 'X') = NVL(p_event_class_rec.hdr_trx_user_key6, 'X')
1003: AND trx_line_id =
1004: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
1005: AND trx_level_type =
1006: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
1007:
1008: CURSOR get_key_columns_cur
1002: -- AND NVL(hdr_trx_user_key6, 'X') = NVL(p_event_class_rec.hdr_trx_user_key6, 'X')
1003: AND trx_line_id =
1004: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
1005: AND trx_level_type =
1006: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
1007:
1008: CURSOR get_key_columns_cur
1009: (c_tax_regime_code zx_regimes_b.tax_regime_code%TYPE,
1010: c_tax zx_taxes_b.tax%TYPE,
1010: c_tax zx_taxes_b.tax%TYPE,
1011: c_apportionment_line_number zx_lines.tax_apportionment_line_number%type) IS
1012: SELECT tax_line_id FROM zx_lines
1013: WHERE application_id =
1014: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_index)
1015: AND entity_code =
1016: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_index)
1017: AND event_class_code =
1018: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_index)
1012: SELECT tax_line_id FROM zx_lines
1013: WHERE application_id =
1014: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_index)
1015: AND entity_code =
1016: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_index)
1017: AND event_class_code =
1018: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_index)
1019: AND trx_id =
1020: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id( p_trx_line_index)
1014: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_index)
1015: AND entity_code =
1016: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_index)
1017: AND event_class_code =
1018: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_index)
1019: AND trx_id =
1020: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id( p_trx_line_index)
1021: AND trx_line_id =
1022: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(
1016: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_index)
1017: AND event_class_code =
1018: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_index)
1019: AND trx_id =
1020: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id( p_trx_line_index)
1021: AND trx_line_id =
1022: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(
1023: p_trx_line_index), trx_line_id)
1024: AND trx_level_type =
1018: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_index)
1019: AND trx_id =
1020: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id( p_trx_line_index)
1021: AND trx_line_id =
1022: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(
1023: p_trx_line_index), trx_line_id)
1024: AND trx_level_type =
1025: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(
1026: p_trx_line_index), trx_level_type)
1021: AND trx_line_id =
1022: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(
1023: p_trx_line_index), trx_line_id)
1024: AND trx_level_type =
1025: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(
1026: p_trx_line_index), trx_level_type)
1027: AND (tax_provider_id IS NULL
1028: OR ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT')
1029: AND Cancel_Flag <> 'Y'
1024: AND trx_level_type =
1025: NVL(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(
1026: p_trx_line_index), trx_level_type)
1027: AND (tax_provider_id IS NULL
1028: OR ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT')
1029: AND Cancel_Flag <> 'Y'
1030: AND offset_link_to_tax_line_id IS NULL
1031: AND mrc_tax_line_flag = 'N'
1032: AND tax = c_tax
1083: -- populate hq_estb_party_tax_prof_id
1084: --
1085: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1086: l_new_row_num).hq_estb_party_tax_prof_id :=
1087: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.hq_estb_party_tax_prof_id(
1088: p_trx_line_index);
1089: -- get l_def_reg_type and l_reg_rule_flg from tax chche
1090: --
1091: l_tax_id := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1198: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1199: l_new_row_num).unrounded_tax_amt = 0 THEN
1200: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1201: l_new_row_num).unrounded_taxable_amt :=
1202: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index);
1203:
1204: ELSE
1205: x_return_status := FND_API.G_RET_STS_ERROR;
1206: IF (g_level_unexpected >= g_current_runtime_level ) THEN
1219: FND_MESSAGE.SET_NAME('ZX','ZX_IMP_TAX_RATE_AMT_MISMATCH');
1220:
1221: -- FND_MSG_PUB.Add;
1222: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1223: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
1224: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1225: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
1226:
1227: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1221: -- FND_MSG_PUB.Add;
1222: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1223: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
1224: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1225: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
1226:
1227: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1228:
1229: RETURN;
1229: RETURN;
1230: END IF;
1231: END IF; -- l_tax_rate <> 0 OR ELSE
1232:
1233: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_index) IS NOT NULL
1234: THEN
1235: OPEN get_key_columns_cur(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_regime_code,
1236: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax,
1237: NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_apportionment_line_number, 1)
1265: AND entity_code =p_event_class_rec.entity_code
1266: AND event_class_code =p_event_class_rec.event_class_code
1267: AND trx_id = p_event_class_rec.trx_id
1268: AND trx_line_id =
1269: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
1270: AND trx_level_type =
1271: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
1272:
1273: IF (g_level_procedure >= g_current_runtime_level ) THEN
1267: AND trx_id = p_event_class_rec.trx_id
1268: AND trx_line_id =
1269: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
1270: AND trx_level_type =
1271: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
1272:
1273: IF (g_level_procedure >= g_current_runtime_level ) THEN
1274: FND_LOG.STRING(g_level_procedure,
1275: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',
1342: in adjusted doc columns and cash receipt info in applied from columns.
1343: In this case, tax calculation must be done using invoice (ie. adjusted doc info).
1344: */
1345:
1346: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
1347: p_trx_line_index) IS NOT NULL
1348: THEN
1349:
1350: get_taxes_from_adjusted_to(
1371: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1372: END IF;
1373: RETURN;
1374: END IF;
1375: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(
1376: p_trx_line_index) IS NOT NULL
1377: THEN
1378:
1379: get_taxes_from_applied_from(
1401: END IF;
1402: RETURN;
1403: END IF;
1404:
1405: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1406: p_trx_line_index) ='LINE_INFO_TAX_ONLY' THEN
1407:
1408: -- Bug 3010729: skip performing additional applicability for trx lines with
1409: -- line level action 'LINE_INFO_TAX_ONLY'
1421: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1422: END IF;
1423: RETURN;
1424:
1425: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1426: p_trx_line_index) ='CREATE'
1427: OR (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1428: p_trx_line_index) ='CREATE_WITH_TAX'
1429: AND p_event_class_rec.perf_addnl_appl_for_imprt_flag = 'Y')
1423: RETURN;
1424:
1425: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1426: p_trx_line_index) ='CREATE'
1427: OR (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1428: p_trx_line_index) ='CREATE_WITH_TAX'
1429: AND p_event_class_rec.perf_addnl_appl_for_imprt_flag = 'Y')
1430: THEN
1431:
1489:
1490: ELSE
1491:
1492: FOR regime_index IN
1493: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.FIRST, 0)..
1494: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.LAST, -1)
1495: LOOP
1496:
1497: IF ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
1490: ELSE
1491:
1492: FOR regime_index IN
1493: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.FIRST, 0)..
1494: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.LAST, -1)
1495: LOOP
1496:
1497: IF ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
1498: regime_index).trx_line_index = p_trx_line_index THEN
1493: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.FIRST, 0)..
1494: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.LAST, -1)
1495: LOOP
1496:
1497: IF ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
1498: regime_index).trx_line_index = p_trx_line_index THEN
1499: -- Get tax_provider_id
1500: --
1501: l_tax_regime_id := ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
1497: IF ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
1498: regime_index).trx_line_index = p_trx_line_index THEN
1499: -- Get tax_provider_id
1500: --
1501: l_tax_regime_id := ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
1502: regime_index).tax_regime_id;
1503: l_provider_id := ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(
1504: l_tax_regime_id).tax_provider_id;
1505: IF (l_provider_id IS NULL) THEN
1499: -- Get tax_provider_id
1500: --
1501: l_tax_regime_id := ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
1502: regime_index).tax_regime_id;
1503: l_provider_id := ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(
1504: l_tax_regime_id).tax_provider_id;
1505: IF (l_provider_id IS NULL) THEN
1506:
1507: -- If the provider id is null, OTE needs to calculate tax
1507: -- If the provider id is null, OTE needs to calculate tax
1508: --
1509: ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes (
1510: l_tax_regime_id,
1511: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(
1512: l_tax_regime_id).tax_regime_code,
1513: p_trx_line_index,
1514: p_event_class_rec,
1515: p_tax_date,
1553: -- assessed for the second time calculation, set overriden_flag
1554: -- and orig_self_assessed_flag
1555: --
1556: IF p_event_class_rec.self_assess_tax_lines_flag ='Y' AND
1557: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1558: p_trx_line_index) ='CREATE_WITH_TAX'
1559: THEN
1560: FOR i IN NVL(l_begin_index_additional, 0) .. NVL(l_end_index_additional, -1)
1561: LOOP
1753: p_new_row_num IN NUMBER,
1754: p_tax_class IN zx_rates_b.tax_class%TYPE,
1755: x_return_status OUT NOCOPY VARCHAR2) IS
1756:
1757: l_tax_regime_rec ZX_GLOBAL_STRUCTURES_PKG.tax_regime_rec_type;
1758: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
1759: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
1760: l_tax_jur_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
1761: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
2246:
2247: CURSOR get_tax_lines_csr IS
2248: SELECT * FROM zx_lines
2249: WHERE application_id =
2250: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
2251: AND entity_code =
2252: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
2253: AND event_class_code =
2254: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
2248: SELECT * FROM zx_lines
2249: WHERE application_id =
2250: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
2251: AND entity_code =
2252: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
2253: AND event_class_code =
2254: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
2255: AND trx_id =
2256: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
2250: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
2251: AND entity_code =
2252: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
2253: AND event_class_code =
2254: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
2255: AND trx_id =
2256: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
2257: AND trx_line_id =
2258: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
2252: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
2253: AND event_class_code =
2254: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
2255: AND trx_id =
2256: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
2257: AND trx_line_id =
2258: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
2259: AND trx_level_type =
2260: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index)
2254: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
2255: AND trx_id =
2256: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
2257: AND trx_line_id =
2258: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
2259: AND trx_level_type =
2260: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index)
2261: AND tax_provider_id IS NULL
2262: AND cancel_flag<> 'Y'
2256: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
2257: AND trx_line_id =
2258: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
2259: AND trx_level_type =
2260: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index)
2261: AND tax_provider_id IS NULL
2262: AND cancel_flag<> 'Y'
2263: --AND offset_link_to_tax_line_id IS NULL
2264: AND mrc_tax_line_flag = 'N';
2269: l_orig_begin_index BINARY_INTEGER;
2270: l_orig_end_index BINARY_INTEGER;
2271: l_tax_tbl_index NUMBER;
2272:
2273: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
2274: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
2275: l_tax_jur_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
2276: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2277:
2305:
2306: l_tax_tbl_index := ZX_TDS_UTILITIES_PKG.get_tax_index (
2307: tax_line_rec.tax_regime_code,
2308: tax_line_rec.tax,
2309: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index),
2310: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index),
2311: l_orig_begin_index,
2312: l_orig_end_index,
2313: x_return_status);
2306: l_tax_tbl_index := ZX_TDS_UTILITIES_PKG.get_tax_index (
2307: tax_line_rec.tax_regime_code,
2308: tax_line_rec.tax,
2309: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index),
2310: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index),
2311: l_orig_begin_index,
2312: l_orig_end_index,
2313: x_return_status);
2314:
2496: -- prorate prd_total_tax_amt, prd_total_tax_amt_tax_curr and
2497: -- prd_total_tax_amt_funcl_curr
2498: --
2499: l_line_amt_current :=
2500: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index);
2501:
2502: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2503: l_new_row_num).prd_total_tax_amt := tax_line_rec.tax_amt *
2504: (l_line_amt_current/tax_line_rec.line_amt);
2720: -- do this check only for Payables.
2721:
2722: l_unrounded_tax_amt := NULL;
2723:
2724: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index) = 200 THEN
2725: SELECT line_amt
2726: INTO l_orig_amt
2727: FROM zx_lines_det_factors
2728: WHERE application_id =
2725: SELECT line_amt
2726: INTO l_orig_amt
2727: FROM zx_lines_det_factors
2728: WHERE application_id =
2729: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
2730: AND entity_code =
2731: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
2732: AND event_class_code =
2733: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
2727: FROM zx_lines_det_factors
2728: WHERE application_id =
2729: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
2730: AND entity_code =
2731: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
2732: AND event_class_code =
2733: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
2734: AND trx_id =
2735: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
2729: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
2730: AND entity_code =
2731: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
2732: AND event_class_code =
2733: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
2734: AND trx_id =
2735: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
2736: AND trx_line_id =
2737: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
2731: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
2732: AND event_class_code =
2733: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
2734: AND trx_id =
2735: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
2736: AND trx_line_id =
2737: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
2738: AND trx_level_type =
2739: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index);
2733: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
2734: AND trx_id =
2735: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
2736: AND trx_line_id =
2737: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
2738: AND trx_level_type =
2739: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index);
2740:
2741: SELECT sum(line_amt)
2735: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
2736: AND trx_line_id =
2737: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
2738: AND trx_level_type =
2739: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index);
2740:
2741: SELECT sum(line_amt)
2742: INTO l_appl_line_amt
2743: FROM zx_lines_det_factors
2741: SELECT sum(line_amt)
2742: INTO l_appl_line_amt
2743: FROM zx_lines_det_factors
2744: WHERE applied_from_application_id =
2745: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
2746: AND applied_from_entity_code =
2747: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
2748: AND applied_from_event_class_code =
2749: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
2743: FROM zx_lines_det_factors
2744: WHERE applied_from_application_id =
2745: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
2746: AND applied_from_entity_code =
2747: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
2748: AND applied_from_event_class_code =
2749: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
2750: AND applied_from_trx_id =
2751: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
2745: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
2746: AND applied_from_entity_code =
2747: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
2748: AND applied_from_event_class_code =
2749: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
2750: AND applied_from_trx_id =
2751: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
2752: AND applied_from_line_id =
2753: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
2747: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
2748: AND applied_from_event_class_code =
2749: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
2750: AND applied_from_trx_id =
2751: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
2752: AND applied_from_line_id =
2753: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
2754: AND applied_from_trx_level_type =
2755: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index);
2749: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
2750: AND applied_from_trx_id =
2751: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
2752: AND applied_from_line_id =
2753: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
2754: AND applied_from_trx_level_type =
2755: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index);
2756:
2757: SELECT sum(tax_amt)
2751: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
2752: AND applied_from_line_id =
2753: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
2754: AND applied_from_trx_level_type =
2755: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index);
2756:
2757: SELECT sum(tax_amt)
2758: INTO l_appl_tax_amt
2759: FROM zx_lines
2757: SELECT sum(tax_amt)
2758: INTO l_appl_tax_amt
2759: FROM zx_lines
2760: WHERE applied_from_application_id =
2761: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
2762: AND applied_from_entity_code =
2763: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
2764: AND applied_from_event_class_code =
2765: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
2759: FROM zx_lines
2760: WHERE applied_from_application_id =
2761: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
2762: AND applied_from_entity_code =
2763: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
2764: AND applied_from_event_class_code =
2765: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
2766: AND applied_from_trx_id =
2767: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
2761: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
2762: AND applied_from_entity_code =
2763: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
2764: AND applied_from_event_class_code =
2765: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
2766: AND applied_from_trx_id =
2767: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
2768: AND applied_from_line_id =
2769: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
2763: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
2764: AND applied_from_event_class_code =
2765: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
2766: AND applied_from_trx_id =
2767: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
2768: AND applied_from_line_id =
2769: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
2770: AND applied_from_trx_level_type =
2771: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index)
2765: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
2766: AND applied_from_trx_id =
2767: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
2768: AND applied_from_line_id =
2769: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
2770: AND applied_from_trx_level_type =
2771: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index)
2772: AND tax_provider_id IS NULL
2773: AND Cancel_Flag <> 'Y'
2767: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
2768: AND applied_from_line_id =
2769: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
2770: AND applied_from_trx_level_type =
2771: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index)
2772: AND tax_provider_id IS NULL
2773: AND Cancel_Flag <> 'Y'
2774: --AND offset_link_to_tax_line_id IS NULL
2775: AND mrc_tax_line_flag = 'N';
2773: AND Cancel_Flag <> 'Y'
2774: --AND offset_link_to_tax_line_id IS NULL
2775: AND mrc_tax_line_flag = 'N';
2776:
2777: IF l_orig_amt + (l_appl_line_amt + ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index)) <= 0 THEN
2778: -- Final Application
2779: IF (tax_line_rec.tax_amt + l_appl_tax_amt >= 0)
2780: THEN
2781: l_unrounded_tax_amt := sign(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index)) *
2777: IF l_orig_amt + (l_appl_line_amt + ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index)) <= 0 THEN
2778: -- Final Application
2779: IF (tax_line_rec.tax_amt + l_appl_tax_amt >= 0)
2780: THEN
2781: l_unrounded_tax_amt := sign(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index)) *
2782: (tax_line_rec.tax_amt + l_appl_tax_amt);
2783: END IF;
2784: END IF;
2785: ELSE
2789: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_amt <> 0 THEN
2790:
2791: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt:=
2792: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_taxable_amt *
2793: ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) /
2794: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_amt );
2795:
2796: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt:=
2797: NVL(l_unrounded_tax_amt,
2795:
2796: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt:=
2797: NVL(l_unrounded_tax_amt,
2798: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_tax_amt *
2799: ( ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) /
2800: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).other_doc_line_amt ));
2801:
2802: ELSE -- other_doc_line_amt = 0 OR IS NULL
2803: -- copy unrounded_taxable_amt from reference document,
2907:
2908: CURSOR get_tax_lines_csr IS
2909: SELECT * FROM zx_lines
2910: WHERE application_id =
2911: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
2912: p_trx_line_index)
2913: AND entity_code =
2914: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(
2915: p_trx_line_index)
2910: WHERE application_id =
2911: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
2912: p_trx_line_index)
2913: AND entity_code =
2914: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(
2915: p_trx_line_index)
2916: AND event_class_code =
2917: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(
2918: p_trx_line_index)
2913: AND entity_code =
2914: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(
2915: p_trx_line_index)
2916: AND event_class_code =
2917: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(
2918: p_trx_line_index)
2919: AND trx_id =
2920: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(
2921: p_trx_line_index)
2916: AND event_class_code =
2917: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(
2918: p_trx_line_index)
2919: AND trx_id =
2920: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(
2921: p_trx_line_index)
2922: AND trx_line_id =
2923: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(
2924: p_trx_line_index)
2919: AND trx_id =
2920: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(
2921: p_trx_line_index)
2922: AND trx_line_id =
2923: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(
2924: p_trx_line_index)
2925: AND trx_level_type =
2926: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(
2927: p_trx_line_index)
2922: AND trx_line_id =
2923: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(
2924: p_trx_line_index)
2925: AND trx_level_type =
2926: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(
2927: p_trx_line_index)
2928: /* Bug 5131206:
2929: For partner integration, when the line_level_action is 'ALLOCATE_TAX_ONLY_ADJUSTMENT',
2930: eBTax needs to create prorated tax lines.
2931: In other cases, partner tax lines should be excluded.
2932: */
2933: -- AND tax_provider_id IS NULL
2934: AND (tax_provider_id IS NULL
2935: OR ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT')
2936: AND cancel_flag<> 'Y'
2937: --AND offset_link_to_tax_line_id IS NULL
2938: AND mrc_tax_line_flag = 'N';
2939:
2943: l_orig_begin_index BINARY_INTEGER;
2944: l_orig_end_index BINARY_INTEGER;
2945: l_tax_tbl_index NUMBER;
2946:
2947: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
2948: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
2949: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2950: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
2951:
2976:
2977: l_tax_tbl_index := ZX_TDS_UTILITIES_PKG.get_tax_index (
2978: tax_line_rec.tax_regime_code,
2979: tax_line_rec.tax,
2980: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index),
2981: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index),
2982: l_orig_begin_index,
2983: l_orig_end_index,
2984: x_return_status);
2977: l_tax_tbl_index := ZX_TDS_UTILITIES_PKG.get_tax_index (
2978: tax_line_rec.tax_regime_code,
2979: tax_line_rec.tax,
2980: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index),
2981: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index),
2982: l_orig_begin_index,
2983: l_orig_end_index,
2984: x_return_status);
2985: ELSE
3082:
3083:
3084: -- If line_amt_include_tax_flag on trx line is A, then set to 'Y'
3085: -- for other cases, set to the one from adjusted doc.
3086: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt_includes_tax_flag(
3087: p_trx_line_index) = 'A'
3088: THEN
3089: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3090: l_new_row_num).tax_amt_included_flag := 'Y';
3119: ELSE
3120: -- For system generated tax lines on the original trx line
3121: -- populate the unrounded taxable basis and tax amount
3122:
3123: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
3124: p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT'
3125: THEN
3126: IF (g_level_statement >= g_current_runtime_level ) THEN
3127: FND_LOG.STRING(g_level_statement,
3159: -- tax exclusive trx.
3160: IF ( tax_line_rec.line_amt + tax_line_rec.tax_amt) <> 0 THEN
3161: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3162: l_new_row_num).unrounded_taxable_amt
3163: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
3164: ( tax_line_rec.unrounded_taxable_amt /
3165: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );
3166:
3167: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3165: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );
3166:
3167: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3168: l_new_row_num).unrounded_tax_amt
3169: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
3170: ( tax_line_rec.unrounded_tax_amt /
3171: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );
3172: ELSE
3173: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3179: END IF;
3180: ELSE -- both current tax line and original tax line are inclusive and exclusive
3181: IF tax_line_rec.line_amt <> 0 THEN
3182: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
3183: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
3184: ( tax_line_rec.unrounded_taxable_amt / tax_line_rec.line_amt);
3185:
3186: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
3187: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
3183: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
3184: ( tax_line_rec.unrounded_taxable_amt / tax_line_rec.line_amt);
3185:
3186: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
3187: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
3188: ( tax_line_rec.unrounded_tax_amt / tax_line_rec.line_amt );
3189: ELSE -- equal to that the original trx is a tax only trx
3190: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index) = 'CREDIT_MEMO' THEN
3191: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
3186: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
3187: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
3188: ( tax_line_rec.unrounded_tax_amt / tax_line_rec.line_amt );
3189: ELSE -- equal to that the original trx is a tax only trx
3190: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_trx_line_index) = 'CREDIT_MEMO' THEN
3191: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
3192: := -1 * tax_line_rec.unrounded_taxable_amt;
3193: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
3194: := -1 * tax_line_rec.unrounded_tax_amt;
3225:
3226: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3227: l_new_row_num).tax_amt_included_flag = 'Y' THEN
3228:
3229: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(
3230: p_trx_line_index) := 'Y';
3231: END IF;
3232:
3233: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3232:
3233: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3234: l_new_row_num).compounding_dep_tax_flag = 'Y' THEN
3235:
3236: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(
3237: p_trx_line_index) := 'Y';
3238: END IF;
3239:
3240: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_exemption_id
3344:
3345: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3346: l_new_row_num).tax_provider_id := tax_line_rec.tax_provider_id;
3347:
3348: if(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT' and
3349: tax_line_rec.tax_provider_id is not null ) THEN
3350: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).SYNC_WITH_PRVDR_FLAG := 'Y';
3351: end if;
3352: