[Home] [Help]
1531: /*========================================================================
1532: | PRIVATE PROCEDURE update_tax_sources_total
1533: |
1534: | DESCRIPTION
1535: | This procedure fetches the tax amount from ZX_LINES and updates
1536: | the tax sources
1537: |
1538: | CALLED FROM
1539: | process_contract_reversal_tax()
1619: CURSOR l_zxlinestotaltax_csr(cp_trx_id IN NUMBER, cp_trx_line_id IN NUMBER,
1620: cp_application_id IN NUMBER, cp_event_class_code IN VARCHAR2,
1621: cp_entity_code IN VARCHAR2, cp_trx_level_type IN VARCHAR2) IS
1622: SELECT SUM(tax_amt) total_tax
1623: FROM zx_lines
1624: WHERE trx_id = cp_trx_id
1625: AND trx_line_id = cp_trx_line_id
1626: AND application_id = cp_application_id
1627: AND event_class_code = cp_event_class_code
1695: END LOOP;
1696:
1697: ELSIF p_source_trx_name = 'Rebook' THEN
1698:
1699: -- Get the modified tax lines from zx_lines, sum up the total tax amount
1700: -- and store in total_tax column of okl_tax_sources
1701: FOR l_taxablelines_rbk_rec IN l_taxablelines_rbk_csr(cp_trx_id => p_source_trx_id) LOOP
1702: OPEN l_zxlinestotaltax_csr(cp_trx_id => p_source_trx_id,
1703: cp_trx_line_id => l_taxablelines_rbk_rec.trx_line_id,
1720: END LOOP;
1721:
1722: ELSIF (p_source_trx_name = 'Asset Relocation' AND p_serialized_asset = 'Y') THEN
1723:
1724: -- Get the modified tax lines from zx_lines, sum up the total tax amount
1725: -- and store in total_tax column of okl_tax_sources
1726: FOR l_taxablelines_alc_ser_rec IN l_taxablelines_alc_ser_csr(cp_trx_id => p_source_trx_id) LOOP
1727: OPEN l_zxlinestotaltax_csr(cp_trx_id => p_source_trx_id,
1728: cp_trx_line_id => l_taxablelines_alc_ser_rec.trx_line_id,
1744: END LOOP;
1745:
1746: ELSIF (p_source_trx_name = 'Tax Schedule') THEN
1747:
1748: -- Get the modified tax lines from zx_lines_det_factors, sum up the total tax amount
1749: -- and store in total_tax column of okl_tax_sources
1750: FOR l_taxablelines_txs_rec IN l_taxablelines_txs_csr(cp_trx_id => p_source_trx_id) LOOP
1751: OPEN l_totaltax_quote_csr(cp_trx_id => p_source_trx_id,
1752: cp_trx_line_id => l_taxablelines_txs_rec.trx_line_id,
1767: END LOOP;
1768:
1769: ELSE
1770:
1771: -- Get the modified tax lines from zx_lines, sum up the total tax amount
1772: -- and store in total_tax column of okl_tax_sources
1773: FOR l_taxablelines_rec IN l_taxablelines_csr(cp_trx_id => p_source_trx_id) LOOP
1774:
1775: IF p_source_trx_name = 'Sales Quote' THEN
2458: last_update_date,
2459: last_update_login,
2460: object_version_number) VALUES
2461: (
2462: zx_lines_s.nextval,
2463: l_get_tax_data_rec.tax_determine_date,
2464: l_get_tax_data_rec.tax_rate_id,
2465: l_get_tax_data_rec.tax_rate_code,
2466: l_get_tax_data_rec.taxable_amt,
2937: RAISE OKL_API.G_EXCEPTION_ERROR;
2938: END IF;
2939:
2940: -- Get the total tax amount corresponding to 'Reverse' transaction from
2941: -- zx_lines and update total_tax on okl_tax_sources
2942: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
2943: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_contract_reversal_tax.',
2944: 'Calling "update_tax_sources_total" for updating Total Tax for all Lines in Tax Sources');
2945: END IF;
8344: -- check if stream element is billed in AR
8345: -- Get total tax for a taxable line
8346: CURSOR l_get_zx_total_tax(cp_trx_id IN NUMBER, cp_trx_line_id IN NUMBER) IS
8347: SELECT SUM(zx.tax_amt) tax_amt
8348: FROM zx_lines zx
8349: WHERE zx.trx_id = cp_trx_id
8350: AND zx.trx_line_id = cp_trx_line_id
8351: AND zx.entity_code = G_AR_ENTITY_CODE
8352: AND zx.event_class_code = G_INVOICE_EVENT_CLASS_CODE
8370: zxdet.internal_organization_id,
8371: zxdet.input_tax_classification_code,
8372: zx.legal_entity_id,
8373: zxdet.line_intended_use
8374: FROM zx_lines zx,
8375: zx_lines_det_factors zxdet
8376: WHERE zx.trx_line_id = cp_trx_line_id
8377: AND zx.trx_id = cp_trx_id
8378: AND zx.internal_organization_id = MO_GLOBAL.get_current_org_id
8371: zxdet.input_tax_classification_code,
8372: zx.legal_entity_id,
8373: zxdet.line_intended_use
8374: FROM zx_lines zx,
8375: zx_lines_det_factors zxdet
8376: WHERE zx.trx_line_id = cp_trx_line_id
8377: AND zx.trx_id = cp_trx_id
8378: AND zx.internal_organization_id = MO_GLOBAL.get_current_org_id
8379: AND zx.entity_code = G_AR_ENTITY_CODE
8433: zxdet.trx_business_category,
8434: zxdet.product_fisc_classification,
8435: zxdet.user_defined_fisc_class,
8436: zxdet.product_type
8437: FROM zx_lines zx,
8438: zx_lines_det_factors zxdet
8439: WHERE zx.trx_id = cp_trx_id
8440: AND zx.trx_line_id = cp_trx_line_id
8441: AND zx.internal_organization_id = MO_GLOBAL.get_current_org_id
8434: zxdet.product_fisc_classification,
8435: zxdet.user_defined_fisc_class,
8436: zxdet.product_type
8437: FROM zx_lines zx,
8438: zx_lines_det_factors zxdet
8439: WHERE zx.trx_id = cp_trx_id
8440: AND zx.trx_line_id = cp_trx_line_id
8441: AND zx.internal_organization_id = MO_GLOBAL.get_current_org_id
8442: AND zx.entity_code = G_AR_ENTITY_CODE
12612: RAISE OKL_API.G_EXCEPTION_ERROR;
12613: END IF;
12614:
12615: -- Get the total tax amount corresponding to 'Reverse' transaction from
12616: -- zx_lines and update total_tax on okl_tax_sources
12617: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
12618: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_split_asset_tax.',
12619: 'Calling "update_tax_sources_total" for updating Total Tax for all Lines in Tax Sources');
12620: END IF;
13489: END LOOP;
13490: CLOSE l_prev_taxsources_csr;
13491: -- deletion from tax sources -- end
13492:
13493: -- delete booking tax lines from zx_lines -- start
13494: IF (l_delete_data) THEN
13495:
13496: l_transaction_rec.internal_organization_id := l_internal_organization_id;
13497: l_transaction_rec.application_id := l_application_id;
13523: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
13524: RAISE OKL_API.G_EXCEPTION_ERROR;
13525: END IF;
13526: END IF;
13527: -- delete booking tax lines from zx_lines -- end
13528:
13529: -- Fetch the Ledger info
13530: l_ledger_id := okl_accounting_util.get_set_of_books_id;
13531: l_reported_yn := 'N';
18232:
18233: CURSOR l_zxlinestotaltax_csr(cp_trx_id IN NUMBER, cp_trx_line_id IN NUMBER,
18234: cp_application_id IN NUMBER, cp_event_class_code IN VARCHAR2,
18235: cp_entity_code IN VARCHAR2, cp_trx_level_type IN VARCHAR2) IS
18236: SELECT SUM(zx_lines.tax_amt) total_tax
18237: FROM zx_lines
18238: WHERE trx_id = cp_trx_id
18239: AND trx_line_id = cp_trx_line_id
18240: AND application_id = cp_application_id
18233: CURSOR l_zxlinestotaltax_csr(cp_trx_id IN NUMBER, cp_trx_line_id IN NUMBER,
18234: cp_application_id IN NUMBER, cp_event_class_code IN VARCHAR2,
18235: cp_entity_code IN VARCHAR2, cp_trx_level_type IN VARCHAR2) IS
18236: SELECT SUM(zx_lines.tax_amt) total_tax
18237: FROM zx_lines
18238: WHERE trx_id = cp_trx_id
18239: AND trx_line_id = cp_trx_line_id
18240: AND application_id = cp_application_id
18241: AND event_class_code = cp_event_class_code
18792: RAISE OKL_API.G_EXCEPTION_ERROR;
18793: END IF;
18794:
18795: -- Overriding a tax line can impact the tax lines of other transaction lines
18796: -- Get the modified tax lines from zx_lines, sum up the total tax amount
18797: -- and store in total_tax column of okl_tax_sources
18798:
18799: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
18800: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.process_tax_details_override.',