DBA Data[Home] [Help]

APPS.ZX_TDS_TAXABLE_BASIS_DETM_PKG dependencies on STANDARD

Line 664: IF l_formula_code IN ('STANDARD_TB', 'STANDARD_QUANTITY') THEN

660: parameter_tbl(l_tax_id).basiscoef:= 1;
661: parameter_tbl(l_tax_id).constcoef:= 0;
662: parameter_tbl(l_tax_id).overrideconst:= 0;
663:
664: IF l_formula_code IN ('STANDARD_TB', 'STANDARD_QUANTITY') THEN
665: -- When formula code is STANDARD_TB, the rate type should be PERCENT.
666: -- When formula code is STANDARD_QUANTITY, the rate type should be QUANTITY. Otherwise
667: -- multiplying taxable basis by tax rate will give incorrect result.
668: IF (l_formula_code = 'STANDARD_TB' AND

Line 665: -- When formula code is STANDARD_TB, the rate type should be PERCENT.

661: parameter_tbl(l_tax_id).constcoef:= 0;
662: parameter_tbl(l_tax_id).overrideconst:= 0;
663:
664: IF l_formula_code IN ('STANDARD_TB', 'STANDARD_QUANTITY') THEN
665: -- When formula code is STANDARD_TB, the rate type should be PERCENT.
666: -- When formula code is STANDARD_QUANTITY, the rate type should be QUANTITY. Otherwise
667: -- multiplying taxable basis by tax rate will give incorrect result.
668: IF (l_formula_code = 'STANDARD_TB' AND
669: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_type <> 'PERCENTAGE')

Line 666: -- When formula code is STANDARD_QUANTITY, the rate type should be QUANTITY. Otherwise

662: parameter_tbl(l_tax_id).overrideconst:= 0;
663:
664: IF l_formula_code IN ('STANDARD_TB', 'STANDARD_QUANTITY') THEN
665: -- When formula code is STANDARD_TB, the rate type should be PERCENT.
666: -- When formula code is STANDARD_QUANTITY, the rate type should be QUANTITY. Otherwise
667: -- multiplying taxable basis by tax rate will give incorrect result.
668: IF (l_formula_code = 'STANDARD_TB' AND
669: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_type <> 'PERCENTAGE')
670: -- Added following condition for bug fix 5481559

Line 668: IF (l_formula_code = 'STANDARD_TB' AND

664: IF l_formula_code IN ('STANDARD_TB', 'STANDARD_QUANTITY') THEN
665: -- When formula code is STANDARD_TB, the rate type should be PERCENT.
666: -- When formula code is STANDARD_QUANTITY, the rate type should be QUANTITY. Otherwise
667: -- multiplying taxable basis by tax rate will give incorrect result.
668: IF (l_formula_code = 'STANDARD_TB' AND
669: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_type <> 'PERCENTAGE')
670: -- Added following condition for bug fix 5481559
671: OR
672: (l_formula_code = 'STANDARD_QUANTITY' AND

Line 672: (l_formula_code = 'STANDARD_QUANTITY' AND

668: IF (l_formula_code = 'STANDARD_TB' AND
669: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_type <> 'PERCENTAGE')
670: -- Added following condition for bug fix 5481559
671: OR
672: (l_formula_code = 'STANDARD_QUANTITY' AND
673: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_rate_type <> 'QUANTITY')
674: THEN
675: p_return_status:= FND_API.G_RET_STS_ERROR;
676: FND_MESSAGE.SET_NAME('ZX','ZX_RATE_FORMULA_MISMATCH');

Line 700: -- When formula code is STANDARD_TB then no discounts or charges are

696: END IF;
697: RETURN;
698: END IF;
699:
700: -- When formula code is STANDARD_TB then no discounts or charges are
701: -- applicable. Base rate modifier is set to 1
702: parameter_tbl(l_tax_id).discount:= 0;
703: parameter_tbl(l_tax_id).base_rate_modifier:= 1;
704:

Line 723: ELSIF l_formula_code <> 'STANDARD_QUANTITY' THEN

719: -- parameter_tbl(l_tax_id).constcoef:= 0;
720: -- parameter_tbl(l_tax_id).overrideconst:= 0;
721: -- END IF;
722:
723: ELSIF l_formula_code <> 'STANDARD_QUANTITY' THEN
724:
725: OPEN getFormulaInfoH(l_formula_code,l_tax_date);
726: FETCH getFormulaInfoH
727: INTO l_formula_id,

Line 975: IF parameter_tbl(l_compounding_tax_id).formula_code = 'STANDARD_QUANTITY'

971: l_compounding_factor:= -1;
972: END IF;
973:
974: -- Bug 8512848 - Adding the following condition for Quantity Based Taxes
975: IF parameter_tbl(l_compounding_tax_id).formula_code = 'STANDARD_QUANTITY'
976: AND l_line_amt <> 0 THEN -- Bug8840197
977: FOR j IN p_begin_index..p_end_index LOOP
978: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(j).tax_id = to_char(l_compounding_tax_id) THEN
979: l_source := j;

Line 1073: IF parameter_tbl(l_tax_id).formula_code = 'STANDARD_QUANTITY'

1069: ', sum_basiscoef: ' || l_sum_basiscoef ||
1070: ', sum_basiscoef_qua: ' || l_sum_basiscoef_qua);
1071: END IF;
1072:
1073: IF parameter_tbl(l_tax_id).formula_code = 'STANDARD_QUANTITY'
1074: AND l_line_amt <> 0 THEN
1075: l_sum_basiscoef_qua:= l_sum_basiscoef_qua +
1076: (parameter_tbl(l_tax_id).composite_incl_indicator
1077: * parameter_tbl(l_tax_id).basiscoef

Line 1307: -- 1 non-manual tax line with taxable_basis_formula STANDARD_TB and

1303: 'Case 8 ... Updating columns');
1304: END IF;
1305:
1306: -- A migrated invoice can have 2 tax lines with same Regime and Tax
1307: -- 1 non-manual tax line with taxable_basis_formula STANDARD_TB and
1308: -- 1 manual tax line with taxable_basis_formula PRORATED_TB.
1309: -- Migrated Tax lines with same Regime and Tax will have same Tax_id
1310: -- so parameter_tbl(l_tax_id).formula_code can be populated with value
1311: -- PRORATED_TB by the upper loop.

Line 1337: IF parameter_tbl(l_tax_id).formula_code = 'STANDARD_QUANTITY' THEN

1333: 'Taxable_Basis_formula : '||
1334: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).taxable_basis_formula);
1335: END IF;
1336:
1337: IF parameter_tbl(l_tax_id).formula_code = 'STANDARD_QUANTITY' THEN
1338: -- For quantity based taxes, the calculation is not performed using
1339: -- the regular calculation cycle. Hence calculate the taxable amt
1340: -- and tax amt for quantity based taxes.
1341: -- For quantity based taxes, taxable amt is set equal to quantity