[Home] [Help]
756: currency_conversion_date,
757: tax_determine_date,
758: taxable_amt,
759: tax_amt
760: FROM zx_detail_tax_lines_gt
761: WHERE trx_id = cp_trx_id
762: AND application_id = G_OKL_APPLICATION_ID
763: AND trx_level_type = G_TRX_LEVEL_TYPE
764: AND entity_code = cp_entity_code
1632: CURSOR l_totaltax_quote_csr(cp_trx_id IN NUMBER, cp_trx_line_id IN NUMBER,
1633: cp_application_id IN NUMBER, cp_event_class_code IN VARCHAR2,
1634: cp_entity_code IN VARCHAR2, cp_trx_level_type IN VARCHAR2) IS
1635: SELECT SUM(tax_amt) total_tax
1636: FROM zx_detail_tax_lines_gt
1637: WHERE trx_id = cp_trx_id
1638: AND trx_line_id = cp_trx_line_id
1639: AND application_id = cp_application_id
1640: AND event_class_code = cp_event_class_code
1670: i := 1;
1671: IF p_source_trx_name = 'Estimated Billing' THEN
1672: FOR l_taxablelines_bill_rec IN l_taxablelines_bill_csr(cp_trx_id => p_source_trx_id) LOOP
1673:
1674: -- Get the modified tax lines from zx_detail_tax_lines_gt, sum up the total tax amount
1675: -- and store in total_tax column of okl_tax_sources
1676: OPEN l_totaltax_quote_csr(cp_trx_id => p_source_trx_id,
1677: cp_trx_line_id => l_taxablelines_bill_rec.trx_line_id,
1678: cp_application_id => l_taxablelines_bill_rec.application_id,
2405:
2406: -- Populate the tax data into eBtax global session table
2407: IF (G_DEBUG_LEVEL_STATEMENT >= G_DEBUG_CURRENT_RUNTIME_LEVEL) THEN
2408: FND_LOG.STRING(G_DEBUG_LEVEL_STATEMENT,'OKL_PROCESS_SALES_TAX_PVT.populate_tax_trx_details.',
2409: 'INSERT INTO zx_detail_tax_lines_gt');
2410: END IF;
2411:
2412: FOR l_get_tax_data_rec IN l_get_tax_data_csr LOOP
2413: INSERT INTO zx_detail_tax_lines_gt(
2409: 'INSERT INTO zx_detail_tax_lines_gt');
2410: END IF;
2411:
2412: FOR l_get_tax_data_rec IN l_get_tax_data_csr LOOP
2413: INSERT INTO zx_detail_tax_lines_gt(
2414: tax_line_id,
2415: tax_determine_date,
2416: tax_rate_id,
2417: tax_rate_code,