[Home] [Help]
519: RETURN;
520: END IF;
521:
522: -- When no tax line found for the historical transaction, check if the trx line
523: -- exists in zx_lines_det_factors. If yes, it means the historical transaction
524: -- was migrated, but don't have tax. Otherwise, migrate the historical
525: -- transaction on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines
526: -- again to fetch the tax lines for the historical transaction.
527:
629: END IF;
630:
631: -- bug fix 4642405 : handle on the fly migration
632: -- When no tax line found for the adjusted doc, check if the trx line
633: -- exists in zx_lines_det_factors. If yes, it means the adjusted doc was
634: -- migrated, but don't have tax. Otherwise, migrate the adjusted doc
635: -- on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust
636: -- again to fetch the tax lines for the adjusted doc.
637:
746: END IF;
747:
748: -- bug fix 4642405 : handle on the fly migration
749: -- When no tax line found for the applied_from doc, check if the trx line
750: -- exists in zx_lines_det_factors. If yes, it means the applied_from doc was
751: -- migrated, but don't have tax. Otherwise, migrate the applied_from doc
752: -- on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied
753: -- again to fetch the tax lines for the applied_from doc.
754:
833: END IF;
834:
835: ELSE -- loop through detail_tax_regime_tbl to get applicable taxes
836:
837: -- For UPDATE case, fetch manual tax lines from zx_lines
838: --
839:
840: IF (((ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
841: p_trx_line_index) = 'UPDATE')
879: END IF;
880:
881: -- bug fix 4642405 : handle on the fly migration
882: -- When no tax line found for docto be updated, check if the trx line
883: -- exists in zx_lines_det_factors. If yes, it means current doc was
884: -- migrated, but don't have tax. Otherwise, migrate current doc
885: -- on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines
886: -- again to fetch the tax lines for current doc.
887:
1000: END IF;
1001:
1002: -- bug fix 4653504 : handle on the fly migration
1003: -- When no tax line found for doc to be updated, check if the trx line
1004: -- exists in zx_lines_det_factors. If yes, it means current doc was
1005: -- migrated, but don't have tax. Otherwise, migrate current doc
1006: -- on-the-fly and call ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines
1007: -- again to fetch the tax lines for current doc.
1008:
1068: --Bug 10631930 (continuation of bug 9587918, relaxing event class code check for intercompany invoices)
1069:
1070: IF l_upg_trx_info_rec.trx_line_id IS NOT NULL THEN
1071: SELECT count(*) into l_count
1072: FROM zx_lines_det_factors
1073: WHERE application_id = l_upg_trx_info_rec.application_id
1074: AND entity_code = l_upg_trx_info_rec.entity_code
1075: AND trx_id = l_upg_trx_info_rec.trx_id
1076: AND trx_line_id = l_upg_trx_info_rec.trx_line_id
1076: AND trx_line_id = l_upg_trx_info_rec.trx_line_id
1077: AND trx_level_type = l_upg_trx_info_rec.trx_level_type;
1078: ELSE
1079: SELECT count(*) into l_count
1080: FROM zx_lines_det_factors
1081: WHERE application_id = l_upg_trx_info_rec.application_id
1082: AND entity_code = l_upg_trx_info_rec.entity_code
1083: AND trx_id = l_upg_trx_info_rec.trx_id;
1084: END IF;
2225: -- parameter in the calling procedure. This may be changed later.
2226: --
2227: l_currency_conversion_rate := p_currency_conversion_rate;
2228:
2229: -- perform conversion and rounding for tax lines in ZX_LINES
2230: --
2231: ZX_TDS_TAX_ROUNDING_PKG.convert_and_round_curr(
2232: p_conversion_rate => l_currency_conversion_rate,
2233: p_conversion_type => p_currency_conversion_type,
2284: RETURN;
2285: END IF;
2286: END IF; -- p_event_class_rec.tax_recovery_flag = 'Y'
2287:
2288: -- updating related columns in functional currency in ZX_LINES_SUMMARY and
2289: -- ZX_LINES
2290: --
2291: ZX_TRL_PUB_PKG.update_exchange_rate (
2292: p_event_class_rec => p_event_class_rec,
2285: END IF;
2286: END IF; -- p_event_class_rec.tax_recovery_flag = 'Y'
2287:
2288: -- updating related columns in functional currency in ZX_LINES_SUMMARY and
2289: -- ZX_LINES
2290: --
2291: ZX_TRL_PUB_PKG.update_exchange_rate (
2292: p_event_class_rec => p_event_class_rec,
2293: x_return_status => x_return_status);
3104: tax_line.trx_id,
3105: trx_line.ctrl_total_hdr_tx_amt,
3106: ROUND(SUM(tax_line.unrounded_tax_amt), 20)
3107: FROM zx_detail_tax_lines_gt tax_line,
3108: zx_lines_det_factors trx_line
3109: WHERE tax_line.application_id = trx_line.application_id
3110: AND tax_line.event_class_code = trx_line.event_class_code
3111: AND tax_line.entity_code = trx_line.entity_code
3112: AND tax_line.trx_id = trx_line.trx_id
3135: tax_line.entity_code,
3136: tax_line.trx_id,
3137: ROUND(SUM(tax_line.unrounded_tax_amt), 20) total_trx_tax_amt
3138: FROM zx_detail_tax_lines_gt tax_line,
3139: zx_lines_det_factors trx_line
3140: WHERE tax_line.application_id = trx_line.application_id
3141: AND tax_line.event_class_code = trx_line.event_class_code
3142: AND tax_line.entity_code = trx_line.entity_code
3143: AND tax_line.trx_id = trx_line.trx_id
3582: tax_line.entity_code,
3583: tax_line.trx_id,
3584: trx_line.ctrl_total_hdr_tx_amt
3585: FROM zx_detail_tax_lines_gt tax_line,
3586: zx_lines_det_factors trx_line
3587: WHERE tax_line.application_id = trx_line.application_id
3588: AND tax_line.event_class_code = trx_line.event_class_code
3589: AND tax_line.entity_code = trx_line.entity_code
3590: AND tax_line.trx_id = trx_line.trx_id
3755: x_return_status OUT NOCOPY VARCHAR2) IS
3756:
3757: CURSOR get_sum_tax_lines_for_adj_csr IS
3758: SELECT tax_amt, summary_tax_line_id
3759: FROM zx_lines_summary
3760: WHERE application_id = p_event_class_rec.application_id
3761: AND entity_code = p_event_class_rec.entity_code
3762: AND event_class_code = p_event_class_rec.event_class_code
3763: AND trx_id = p_event_class_rec.trx_id
4484: -- calculate_tax
4485: -----------------------------------------------------------------------
4486: FUNCTION get_rep_code_id (
4487: p_result_id IN ZX_PROCESS_RESULTS.RESULT_ID%TYPE,
4488: p_date IN ZX_LINES.TRX_DATE%TYPE) RETURN ZX_REPORTING_CODES_B.REPORTING_CODE_ID%TYPE IS
4489: l_api_name CONSTANT VARCHAR2(30):= 'GET_REP_CODE_ID';
4490: l_reporting_code_id ZX_REPORTING_CODES_B.REPORTING_CODE_ID%type;
4491: l_date ZX_LINES.TRX_DATE%TYPE;
4492: BEGIN
4487: p_result_id IN ZX_PROCESS_RESULTS.RESULT_ID%TYPE,
4488: p_date IN ZX_LINES.TRX_DATE%TYPE) RETURN ZX_REPORTING_CODES_B.REPORTING_CODE_ID%TYPE IS
4489: l_api_name CONSTANT VARCHAR2(30):= 'GET_REP_CODE_ID';
4490: l_reporting_code_id ZX_REPORTING_CODES_B.REPORTING_CODE_ID%type;
4491: l_date ZX_LINES.TRX_DATE%TYPE;
4492: BEGIN
4493:
4494: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4495: FND_LOG.STRING(G_LEVEL_STATEMENT,'ZX.PLSQL.ZX_TDS_CALC_SERVICES_PUB_PKG.get_rep_code_id.BEGIN',
4568: ) RETURN NUMBER IS
4569:
4570: l_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
4571: l_mau ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
4572: l_round_amt ZX_LINES.TAX_AMT%TYPE;
4573:
4574: BEGIN
4575: IF (g_level_procedure >= g_current_runtime_level ) THEN
4576: FND_LOG.STRING(g_level_procedure,