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_TDS_IMPORT_DOCUMENT_PKG dependencies on ZX_GLOBAL_STRUCTURES_PKG

Line 929: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)

925: -- AND NVL(hdr_trx_user_key4, 'X') = NVL(p_event_class_rec.hdr_trx_user_key4, 'X')
926: -- AND NVL(hdr_trx_user_key5, 'X') = NVL(p_event_class_rec.hdr_trx_user_key5, 'X')
927: -- AND NVL(hdr_trx_user_key6, 'X') = NVL(p_event_class_rec.hdr_trx_user_key6, 'X')
928: AND trx_line_id =
929: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
930: AND trx_level_type =
931: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
932:
933: l_begin_index BINARY_INTEGER;

Line 931: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);

927: -- AND NVL(hdr_trx_user_key6, 'X') = NVL(p_event_class_rec.hdr_trx_user_key6, 'X')
928: AND trx_line_id =
929: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
930: AND trx_level_type =
931: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
932:
933: l_begin_index BINARY_INTEGER;
934: l_end_index BINARY_INTEGER;
935: l_provider_id NUMBER;

Line 1087: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index);

1083: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1084: l_new_row_num).unrounded_tax_amt = 0 THEN
1085: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1086: l_new_row_num).unrounded_taxable_amt :=
1087: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index);
1088:
1089: ELSE
1090: x_return_status := FND_API.G_RET_STS_ERROR;
1091: IF (g_level_unexpected >= g_current_runtime_level ) THEN

Line 1108: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);

1104: FND_MESSAGE.SET_NAME('ZX','ZX_IMP_TAX_RATE_AMT_MISMATCH');
1105:
1106: -- FND_MSG_PUB.Add;
1107: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1108: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
1109: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1110: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
1111:
1112: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);

Line 1110: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);

1106: -- FND_MSG_PUB.Add;
1107: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_line_id :=
1108: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
1109: ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec.trx_level_type :=
1110: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
1111:
1112: ZX_API_PUB.add_msg(ZX_TDS_CALC_SERVICES_PUB_PKG.g_msg_context_info_rec);
1113:
1114: RETURN;

Line 1135: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)

1131: AND entity_code =p_event_class_rec.entity_code
1132: AND event_class_code =p_event_class_rec.event_class_code
1133: AND trx_id = p_event_class_rec.trx_id
1134: AND trx_line_id =
1135: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
1136: AND trx_level_type =
1137: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
1138:
1139: IF (g_level_procedure >= g_current_runtime_level ) THEN

Line 1137: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);

1133: AND trx_id = p_event_class_rec.trx_id
1134: AND trx_line_id =
1135: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index)
1136: AND trx_level_type =
1137: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index);
1138:
1139: IF (g_level_procedure >= g_current_runtime_level ) THEN
1140: FND_LOG.STRING(g_level_procedure,
1141: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import',

Line 1205: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(

1201: in adjusted doc columns and cash receipt info in applied from columns.
1202: In this case, tax calculation must be done using invoice (ie. adjusted doc info).
1203: */
1204:
1205: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
1206: p_trx_line_index) IS NOT NULL
1207: THEN
1208:
1209: get_taxes_from_adjusted_to(

Line 1234: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(

1230: 'ZX.PLSQL.ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1231: END IF;
1232: RETURN;
1233: END IF;
1234: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(
1235: p_trx_line_index) IS NOT NULL
1236: THEN
1237:
1238: get_taxes_from_applied_from(

Line 1264: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

1260: END IF;
1261: RETURN;
1262: END IF;
1263:
1264: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1265: p_trx_line_index) ='LINE_INFO_TAX_ONLY' THEN
1266:
1267: -- Bug 3010729: skip performing additional applicability for trx lines with
1268: -- line level action 'LINE_INFO_TAX_ONLY'

Line 1284: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

1280: 'ZX_TDS_IMPORT_DOCUMENT_PKG.calculate_tax_for_import(-)');
1281: END IF;
1282: RETURN;
1283:
1284: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1285: p_trx_line_index) ='CREATE'
1286: OR (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1287: p_trx_line_index) ='CREATE_WITH_TAX'
1288: AND p_event_class_rec.perf_addnl_appl_for_imprt_flag = 'Y')

Line 1286: OR (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

1282: RETURN;
1283:
1284: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1285: p_trx_line_index) ='CREATE'
1286: OR (ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1287: p_trx_line_index) ='CREATE_WITH_TAX'
1288: AND p_event_class_rec.perf_addnl_appl_for_imprt_flag = 'Y')
1289: THEN
1290:

Line 1352: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.FIRST, 0)..

1348:
1349: ELSE
1350:
1351: FOR regime_index IN
1352: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.FIRST, 0)..
1353: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.LAST, -1)
1354: LOOP
1355:
1356: IF ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(

Line 1353: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.LAST, -1)

1349: ELSE
1350:
1351: FOR regime_index IN
1352: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.FIRST, 0)..
1353: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.LAST, -1)
1354: LOOP
1355:
1356: IF ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
1357: regime_index).trx_line_index = p_trx_line_index THEN

Line 1356: IF ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(

1352: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.FIRST, 0)..
1353: NVL(ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl.LAST, -1)
1354: LOOP
1355:
1356: IF ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
1357: regime_index).trx_line_index = p_trx_line_index THEN
1358: -- Get tax_provider_id
1359: --
1360: l_tax_regime_id := ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(

Line 1360: l_tax_regime_id := ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(

1356: IF ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
1357: regime_index).trx_line_index = p_trx_line_index THEN
1358: -- Get tax_provider_id
1359: --
1360: l_tax_regime_id := ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
1361: regime_index).tax_regime_id;
1362: l_provider_id := ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(
1363: l_tax_regime_id).tax_provider_id;
1364: IF (l_provider_id IS NULL) THEN

Line 1362: l_provider_id := ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(

1358: -- Get tax_provider_id
1359: --
1360: l_tax_regime_id := ZX_GLOBAL_STRUCTURES_PKG.detail_tax_regime_tbl(
1361: regime_index).tax_regime_id;
1362: l_provider_id := ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(
1363: l_tax_regime_id).tax_provider_id;
1364: IF (l_provider_id IS NULL) THEN
1365:
1366: -- If the provider id is null, OTE needs to calculate tax

Line 1370: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(

1366: -- If the provider id is null, OTE needs to calculate tax
1367: --
1368: ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes (
1369: l_tax_regime_id,
1370: ZX_GLOBAL_STRUCTURES_PKG.tax_regime_tbl(
1371: l_tax_regime_id).tax_regime_code,
1372: p_trx_line_index,
1373: p_event_class_rec,
1374: p_tax_date,

Line 1416: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

1412: -- assessed for the second time calculation, set overriden_flag
1413: -- and orig_self_assessed_flag
1414: --
1415: IF p_event_class_rec.self_assess_tax_lines_flag ='Y' AND
1416: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
1417: p_trx_line_index) ='CREATE_WITH_TAX'
1418: THEN
1419: FOR i IN NVL(l_begin_index_additional, 0) .. NVL(l_end_index_additional, -1)
1420: LOOP

Line 1616: l_tax_regime_rec ZX_GLOBAL_STRUCTURES_PKG.tax_regime_rec_type;

1612: p_new_row_num IN NUMBER,
1613: p_tax_class IN zx_rates_b.tax_class%TYPE,
1614: x_return_status OUT NOCOPY VARCHAR2) IS
1615:
1616: l_tax_regime_rec ZX_GLOBAL_STRUCTURES_PKG.tax_regime_rec_type;
1617: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
1618: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
1619: l_tax_jur_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
1620: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

Line 2056: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)

2052:
2053: CURSOR get_tax_lines_csr IS
2054: SELECT * FROM zx_lines
2055: WHERE application_id =
2056: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
2057: AND entity_code =
2058: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
2059: AND event_class_code =
2060: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)

Line 2058: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)

2054: SELECT * FROM zx_lines
2055: WHERE application_id =
2056: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
2057: AND entity_code =
2058: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
2059: AND event_class_code =
2060: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
2061: AND trx_id =
2062: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)

Line 2060: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)

2056: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
2057: AND entity_code =
2058: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
2059: AND event_class_code =
2060: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
2061: AND trx_id =
2062: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
2063: AND trx_line_id =
2064: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)

Line 2062: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)

2058: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
2059: AND event_class_code =
2060: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
2061: AND trx_id =
2062: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
2063: AND trx_line_id =
2064: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
2065: AND trx_level_type =
2066: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index)

Line 2064: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)

2060: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_index)
2061: AND trx_id =
2062: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
2063: AND trx_line_id =
2064: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
2065: AND trx_level_type =
2066: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index)
2067: AND tax_provider_id IS NULL
2068: AND cancel_flag<> 'Y'

Line 2066: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index)

2062: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_id(p_trx_line_index)
2063: AND trx_line_id =
2064: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_line_id(p_trx_line_index)
2065: AND trx_level_type =
2066: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index)
2067: AND tax_provider_id IS NULL
2068: AND cancel_flag<> 'Y'
2069: AND offset_link_to_tax_line_id IS NULL
2070: AND mrc_tax_line_flag = 'N';

Line 2079: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;

2075: l_orig_begin_index BINARY_INTEGER;
2076: l_orig_end_index BINARY_INTEGER;
2077: l_tax_tbl_index NUMBER;
2078:
2079: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
2080: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
2081: l_tax_jur_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
2082: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2083:

Line 2110: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index),

2106:
2107: l_tax_tbl_index := ZX_TDS_UTILITIES_PKG.get_tax_index (
2108: tax_line_rec.tax_regime_code,
2109: tax_line_rec.tax,
2110: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index),
2111: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index),
2112: l_orig_begin_index,
2113: l_orig_end_index,
2114: x_return_status);

Line 2111: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index),

2107: l_tax_tbl_index := ZX_TDS_UTILITIES_PKG.get_tax_index (
2108: tax_line_rec.tax_regime_code,
2109: tax_line_rec.tax,
2110: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index),
2111: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index),
2112: l_orig_begin_index,
2113: l_orig_end_index,
2114: x_return_status);
2115:

Line 2301: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index);

2297: -- prorate prd_total_tax_amt, prd_total_tax_amt_tax_curr and
2298: -- prd_total_tax_amt_funcl_curr
2299: --
2300: l_line_amt_current :=
2301: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index);
2302:
2303: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2304: l_new_row_num).prd_total_tax_amt := tax_line_rec.tax_amt *
2305: (l_line_amt_current/tax_line_rec.line_amt);

Line 2549: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(

2545:
2546: CURSOR get_tax_lines_csr IS
2547: SELECT * FROM zx_lines
2548: WHERE application_id =
2549: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
2550: p_trx_line_index)
2551: AND entity_code =
2552: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(
2553: p_trx_line_index)

Line 2552: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(

2548: WHERE application_id =
2549: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
2550: p_trx_line_index)
2551: AND entity_code =
2552: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(
2553: p_trx_line_index)
2554: AND event_class_code =
2555: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(
2556: p_trx_line_index)

Line 2555: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(

2551: AND entity_code =
2552: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(
2553: p_trx_line_index)
2554: AND event_class_code =
2555: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(
2556: p_trx_line_index)
2557: AND trx_id =
2558: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(
2559: p_trx_line_index)

Line 2558: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(

2554: AND event_class_code =
2555: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(
2556: p_trx_line_index)
2557: AND trx_id =
2558: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(
2559: p_trx_line_index)
2560: AND trx_line_id =
2561: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(
2562: p_trx_line_index)

Line 2561: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(

2557: AND trx_id =
2558: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_id(
2559: p_trx_line_index)
2560: AND trx_line_id =
2561: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(
2562: p_trx_line_index)
2563: AND trx_level_type =
2564: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(
2565: p_trx_line_index)

Line 2564: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(

2560: AND trx_line_id =
2561: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_line_id(
2562: p_trx_line_index)
2563: AND trx_level_type =
2564: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_trx_level_type(
2565: p_trx_line_index)
2566: /* Bug 5131206:
2567: For partner integration, when the line_level_action is 'ALLOCATE_TAX_ONLY_ADJUSTMENT',
2568: eBTax needs to create prorated tax lines.

Line 2573: OR ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT')

2569: In other cases, partner tax lines should be excluded.
2570: */
2571: -- AND tax_provider_id IS NULL
2572: AND (tax_provider_id IS NULL
2573: OR ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT')
2574: AND cancel_flag<> 'Y'
2575: AND offset_link_to_tax_line_id IS NULL
2576: AND mrc_tax_line_flag = 'N';
2577:

Line 2585: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;

2581: l_orig_begin_index BINARY_INTEGER;
2582: l_orig_end_index BINARY_INTEGER;
2583: l_tax_tbl_index NUMBER;
2584:
2585: l_tax_regime_rec zx_global_structures_pkg.tax_regime_rec_type;
2586: l_tax_rec ZX_TDS_UTILITIES_PKG.zx_tax_info_cache_rec;
2587: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2588: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
2589:

Line 2618: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index),

2614:
2615: l_tax_tbl_index := ZX_TDS_UTILITIES_PKG.get_tax_index (
2616: tax_line_rec.tax_regime_code,
2617: tax_line_rec.tax,
2618: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index),
2619: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index),
2620: l_orig_begin_index,
2621: l_orig_end_index,
2622: x_return_status);

Line 2619: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index),

2615: l_tax_tbl_index := ZX_TDS_UTILITIES_PKG.get_tax_index (
2616: tax_line_rec.tax_regime_code,
2617: tax_line_rec.tax,
2618: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index),
2619: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_level_type(p_trx_line_index),
2620: l_orig_begin_index,
2621: l_orig_end_index,
2622: x_return_status);
2623: ELSE

Line 2724: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt_includes_tax_flag(

2720:
2721:
2722: -- If line_amt_include_tax_flag on trx line is A, then set to 'Y'
2723: -- for other cases, set to the one from adjusted doc.
2724: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt_includes_tax_flag(
2725: p_trx_line_index) = 'A'
2726: THEN
2727: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2728: l_new_row_num).tax_amt_included_flag := 'Y';

Line 2761: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(

2757: ELSE
2758: -- For system generated tax lines on the original trx line
2759: -- populate the unrounded taxable basis and tax amount
2760:
2761: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2762: p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT'
2763: THEN
2764: IF (g_level_statement >= g_current_runtime_level ) THEN
2765: FND_LOG.STRING(g_level_statement,

Line 2801: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *

2797: -- tax exclusive trx.
2798: IF ( tax_line_rec.line_amt + tax_line_rec.tax_amt) <> 0 THEN
2799: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2800: l_new_row_num).unrounded_taxable_amt
2801: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
2802: ( tax_line_rec.unrounded_taxable_amt /
2803: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );
2804:
2805: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2807: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *

2803: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );
2804:
2805: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2806: l_new_row_num).unrounded_tax_amt
2807: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
2808: ( tax_line_rec.unrounded_tax_amt /
2809: ( tax_line_rec.line_amt + tax_line_rec.tax_amt) );
2810: ELSE
2811: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2821: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *

2817: END IF;
2818: ELSE -- both current tax line and original tax line are inclusive and exclusive
2819: IF tax_line_rec.line_amt <> 0 THEN
2820: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
2821: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
2822: ( tax_line_rec.unrounded_taxable_amt / tax_line_rec.line_amt);
2823:
2824: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
2825: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *

Line 2825: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *

2821: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
2822: ( tax_line_rec.unrounded_taxable_amt / tax_line_rec.line_amt);
2823:
2824: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_tax_amt
2825: := ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_trx_line_index) *
2826: ( tax_line_rec.unrounded_tax_amt / tax_line_rec.line_amt );
2827: ELSE -- equal to that the original trx is a tax only trx
2828: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).unrounded_taxable_amt
2829: := tax_line_rec.unrounded_taxable_amt;

Line 2856: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(

2852:
2853: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2854: l_new_row_num).tax_amt_included_flag = 'Y' THEN
2855:
2856: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(
2857: p_trx_line_index) := 'Y';
2858: END IF;
2859:
2860: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 2863: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(

2859:
2860: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2861: l_new_row_num).compounding_dep_tax_flag = 'Y' THEN
2862:
2863: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(
2864: p_trx_line_index) := 'Y';
2865: END IF;
2866:
2867: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).tax_exemption_id

Line 2970: if(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT' and

2966:
2967: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2968: l_new_row_num).tax_provider_id := tax_line_rec.tax_provider_id;
2969:
2970: if(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(p_trx_line_index) = 'ALLOCATE_TAX_ONLY_ADJUSTMENT' and
2971: tax_line_rec.tax_provider_id is not null ) THEN
2972: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_new_row_num).SYNC_WITH_PRVDR_FLAG := 'Y';
2973: end if;
2974: