DBA Data[Home] [Help]

APPS.ZX_TDS_TAXABLE_BASIS_DETM_PKG dependencies on ZX_GLOBAL_STRUCTURES_PKG

Line 156: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(

152: END IF;
153:
154: p_return_status:= FND_API.G_RET_STS_SUCCESS;
155:
156: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(
157: p_structure_index) IS NOT NULL THEN
158: IF (g_level_procedure >= g_current_runtime_level ) THEN
159: FND_LOG.STRING(g_level_procedure,
160: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis.END',

Line 173: l_line_amt:= ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_structure_index);

169: l_sum_constcoef := 0;
170:
171: -- Bug#5520167- get line amt from trx line
172: --l_line_amt:= ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(p_begin_index).line_amt;
173: l_line_amt:= ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt(p_structure_index);
174:
175: IF p_begin_index IS NULL OR p_end_index IS NULL THEN
176: p_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
177: IF (g_level_procedure >= g_current_runtime_level) THEN

Line 244: -- ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_hdr_tx_amt(p_structure_index) is not null

240: -- (
241: -- NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
242: -- i).last_manual_entry, 'X') <> 'TAX_AMOUNT'
243: -- OR
244: -- ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_hdr_tx_amt(p_structure_index) is not null
245: -- OR
246: -- ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_line_tx_amt(p_structure_index) is not null
247: -- )
248: THEN

Line 246: -- ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_line_tx_amt(p_structure_index) is not null

242: -- i).last_manual_entry, 'X') <> 'TAX_AMOUNT'
243: -- OR
244: -- ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_hdr_tx_amt(p_structure_index) is not null
245: -- OR
246: -- ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ctrl_total_line_tx_amt(p_structure_index) is not null
247: -- )
248: THEN
249: -- populate inclusive_tax_flag by calling populate_inclusive_tax_flag
250: --

Line 339: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt_includes_tax_flag(

335: ELSE
336: parameter_tbl(l_tax_id).weird_indicator:= 0;
337: END IF;
338:
339: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt_includes_tax_flag(
340: p_structure_index) = 'I' OR
341: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
342: i).tax_amt_included_flag = 'Y'
343: THEN

Line 401: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(p_structure_index) <> 'INTERCOMPANY_TRX' --Bug 10162888

397:
398: -- 3
399: WHEN ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).OTHER_DOC_SOURCE ='ADJUSTED' AND
400: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code <> 'OVERRIDE_TAX' AND
401: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(p_structure_index) <> 'INTERCOMPANY_TRX' --Bug 10162888
402: THEN
403:
404: IF (g_level_statement >= g_current_runtime_level ) THEN
405: FND_LOG.STRING(g_level_statement,

Line 636: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt_includes_tax_flag(

632: ELSE
633: parameter_tbl(l_tax_id).weird_indicator:= 0;
634: END IF;
635:
636: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt_includes_tax_flag(
637: p_structure_index) = 'I' OR
638: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
639: i).tax_amt_included_flag = 'Y'
640: THEN

Line 813: ABS(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.cash_discount(p_structure_index));

809: l_discount_amt:= 0;
810:
811: IF l_cash_discount_appl_flag = 'Y' THEN
812: l_discount_amt:= l_discount_amt -
813: ABS(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.cash_discount(p_structure_index));
814: END IF;
815:
816: IF l_volume_discount_appl_flag = 'Y' THEN
817: l_discount_amt:= l_discount_amt -

Line 818: ABS(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.volume_discount(p_structure_index));

814: END IF;
815:
816: IF l_volume_discount_appl_flag = 'Y' THEN
817: l_discount_amt:= l_discount_amt -
818: ABS(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.volume_discount(p_structure_index));
819: END IF;
820:
821: IF l_trading_discount_appl_flag = 'Y' THEN
822: l_discount_amt:= l_discount_amt -

Line 823: ABS(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trading_discount(p_structure_index));

819: END IF;
820:
821: IF l_trading_discount_appl_flag = 'Y' THEN
822: l_discount_amt:= l_discount_amt -
823: ABS(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trading_discount(p_structure_index));
824: END IF;
825:
826: IF l_transfer_charge_appl_flag = 'Y' THEN
827: l_discount_amt:= l_discount_amt +

Line 828: ABS(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.transfer_charge(p_structure_index));

824: END IF;
825:
826: IF l_transfer_charge_appl_flag = 'Y' THEN
827: l_discount_amt:= l_discount_amt +
828: ABS(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.transfer_charge(p_structure_index));
829: END IF;
830:
831: IF l_trans_chrg_appl_flg = 'Y' THEN
832: l_discount_amt:= l_discount_amt +

Line 833: ABS(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.transportation_charge(p_structure_index));

829: END IF;
830:
831: IF l_trans_chrg_appl_flg = 'Y' THEN
832: l_discount_amt:= l_discount_amt +
833: ABS(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.transportation_charge(p_structure_index));
834: END IF;
835:
836: IF l_insurance_charge_appl_flag = 'Y' THEN
837: l_discount_amt:= l_discount_amt +

Line 838: ABS(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.insurance_charge(p_structure_index));

834: END IF;
835:
836: IF l_insurance_charge_appl_flag = 'Y' THEN
837: l_discount_amt:= l_discount_amt +
838: ABS(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.insurance_charge(p_structure_index));
839: END IF;
840:
841: IF l_other_charge_appl_flag = 'Y' THEN
842: l_discount_amt:= l_discount_amt +

Line 843: ABS(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.other_charge(p_structure_index));

839: END IF;
840:
841: IF l_other_charge_appl_flag = 'Y' THEN
842: l_discount_amt:= l_discount_amt +
843: ABS(ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.other_charge(p_structure_index));
844: END IF;
845:
846: IF (g_level_statement >= g_current_runtime_level ) THEN
847: FND_LOG.STRING(g_level_statement,

Line 1212: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(p_structure_index) <> 'INTERCOMPANY_TRX'

1208: -- added code to do nothing in case of these 2 conditions for Bug#13579802
1209: -- 4
1210: WHEN ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).OTHER_DOC_SOURCE ='ADJUSTED' AND
1211: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code <> 'OVERRIDE_TAX' AND
1212: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.source_event_class_code(p_structure_index) <> 'INTERCOMPANY_TRX'
1213: THEN
1214: IF (g_level_statement >= g_current_runtime_level ) THEN
1215: FND_LOG.STRING(g_level_statement,
1216: 'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',

Line 1549: -- ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl

1545:
1546: END CASE;
1547:
1548: -- polpulate tax_amt_included_flag and compounding_tax_flag in
1549: -- ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl
1550: --
1551: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1552: i).tax_amt_included_flag = 'Y' THEN
1553: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(

Line 1553: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(

1549: -- ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl
1550: --
1551: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1552: i).tax_amt_included_flag = 'Y' THEN
1553: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.tax_amt_included_flag(
1554: p_structure_index) := 'Y';
1555: END IF;
1556:
1557: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(

Line 1559: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(

1555: END IF;
1556:
1557: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1558: i).compounding_dep_tax_flag = 'Y' THEN
1559: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.compounding_tax_flag(
1560: p_structure_index) := 'Y';
1561: END IF;
1562:
1563: END LOOP;

Line 1629: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt_includes_tax_flag(

1625: -- is 'Y'/'N'. If line_amt_includes_tax_flag IN ('S', 'I'), need to
1626: -- determine tax_amt_included_flag from tax rate/tax registration/
1627: -- PTP/Tax.
1628: --
1629: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt_includes_tax_flag(
1630: p_structure_index) = 'A'
1631: THEN
1632: --ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1633: -- p_tax_line_index).tax_amt_included_flag := 'Y';

Line 1634: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_structure_index) = 200

1630: p_structure_index) = 'A'
1631: THEN
1632: --ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1633: -- p_tax_line_index).tax_amt_included_flag := 'Y';
1634: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_structure_index) = 200
1635: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_structure_index) = 'EXPENSE REPORTS' THEN
1636: ZX_TDS_UTILITIES_PKG.get_tax_rate_info (
1637: p_tax_rate_id => ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1638: p_tax_line_index).tax_rate_id,

Line 1635: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_structure_index) = 'EXPENSE REPORTS' THEN

1631: THEN
1632: --ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1633: -- p_tax_line_index).tax_amt_included_flag := 'Y';
1634: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_structure_index) = 200
1635: AND ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.event_class_code(p_structure_index) = 'EXPENSE REPORTS' THEN
1636: ZX_TDS_UTILITIES_PKG.get_tax_rate_info (
1637: p_tax_rate_id => ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1638: p_tax_line_index).tax_rate_id,
1639: p_tax_rate_rec => l_tax_rate_rec,

Line 1697: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt_includes_tax_flag(

1693: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1694: p_tax_line_index).tax_amt_included_flag := 'Y';
1695: END IF; -- check for special inclusive applicability for expense reports only
1696:
1697: ELSIF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_amt_includes_tax_flag(
1698: p_structure_index) = 'N'
1699: THEN
1700: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1701: p_tax_line_index).tax_amt_included_flag := 'N';

Line 1703: ELSIF ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.line_amt_includes_tax_flag(

1699: THEN
1700: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
1701: p_tax_line_index).tax_amt_included_flag := 'N';
1702:
1703: ELSIF ZX_GLOBAL_STRUCTURES_PKG.TRX_LINE_DIST_TBL.line_amt_includes_tax_flag(
1704: p_structure_index) IN ('S', 'I')
1705: THEN
1706:
1707: -- Get tax_amt_included_flag from tax rate