[Home] [Help]
61: p_tax IN zx_taxes_b.tax%TYPE,
62: p_tax_date IN DATE,
63: p_tax_determine_date IN DATE,
64: p_tax_point_date IN DATE,
65: x_self_assessed_flag OUT NOCOPY zx_lines.self_assessed_flag%TYPE,
66: x_tax_amt_included_flag OUT NOCOPY zx_lines.tax_amt_included_flag%TYPE,
67: x_tax_jurisdiction_id OUT NOCOPY zx_lines.tax_jurisdiction_id%TYPE,
68: x_tax_jurisdiction_code OUT NOCOPY zx_lines.tax_jurisdiction_code%TYPE,
69: x_return_status OUT NOCOPY VARCHAR2);
62: p_tax_date IN DATE,
63: p_tax_determine_date IN DATE,
64: p_tax_point_date IN DATE,
65: x_self_assessed_flag OUT NOCOPY zx_lines.self_assessed_flag%TYPE,
66: x_tax_amt_included_flag OUT NOCOPY zx_lines.tax_amt_included_flag%TYPE,
67: x_tax_jurisdiction_id OUT NOCOPY zx_lines.tax_jurisdiction_id%TYPE,
68: x_tax_jurisdiction_code OUT NOCOPY zx_lines.tax_jurisdiction_code%TYPE,
69: x_return_status OUT NOCOPY VARCHAR2);
70:
63: p_tax_determine_date IN DATE,
64: p_tax_point_date IN DATE,
65: x_self_assessed_flag OUT NOCOPY zx_lines.self_assessed_flag%TYPE,
66: x_tax_amt_included_flag OUT NOCOPY zx_lines.tax_amt_included_flag%TYPE,
67: x_tax_jurisdiction_id OUT NOCOPY zx_lines.tax_jurisdiction_id%TYPE,
68: x_tax_jurisdiction_code OUT NOCOPY zx_lines.tax_jurisdiction_code%TYPE,
69: x_return_status OUT NOCOPY VARCHAR2);
70:
71: PROCEDURE enforce_tax_from_ref_doc(
64: p_tax_point_date IN DATE,
65: x_self_assessed_flag OUT NOCOPY zx_lines.self_assessed_flag%TYPE,
66: x_tax_amt_included_flag OUT NOCOPY zx_lines.tax_amt_included_flag%TYPE,
67: x_tax_jurisdiction_id OUT NOCOPY zx_lines.tax_jurisdiction_id%TYPE,
68: x_tax_jurisdiction_code OUT NOCOPY zx_lines.tax_jurisdiction_code%TYPE,
69: x_return_status OUT NOCOPY VARCHAR2);
70:
71: PROCEDURE enforce_tax_from_ref_doc(
72: p_begin_index IN BINARY_INTEGER,
88: g_inner_jurisdiction_id ZX_JURISDICTIONS_B.tax_jurisdiction_id%TYPE;
89: g_outer_jurisdiction_code ZX_JURISDICTIONS_B.tax_jurisdiction_code%TYPE;
90: g_outer_jurisdiction_id ZX_JURISDICTIONS_B.tax_jurisdiction_id%TYPE;
91:
92: g_trx_line_id ZX_LINES.trx_line_id%TYPE;
93:
94: -------------------------------------------------------------------------------
95: -- PUBLIC PROCEDURE
96: -- get_tax_date
1090: -- fetch_tax_lines
1091: --
1092: -- DESCRIPTION
1093: --
1094: -- This procedure fetch detail tax lines from zx_lines
1095: --
1096: -- IN/OUT
1097: -- p_event_class_rec
1098: -- p_tax_line_tbl
1113:
1114: -- fetch manual tax lines for UPDATE
1115: --
1116: CURSOR get_manual_tax_lines IS
1117: SELECT * FROM zx_lines
1118: WHERE trx_id = p_event_class_rec.trx_id
1119: AND application_id = p_event_class_rec.application_id
1120: AND event_class_code = p_event_class_rec.event_class_code
1121: AND entity_code = p_event_class_rec.entity_code
1128: AND mrc_tax_line_flag = 'N'
1129: AND tax_provider_id IS NULL;
1130:
1131: CURSOR get_tax_lines_override_r IS
1132: SELECT * FROM zx_lines
1133: WHERE trx_id = p_event_class_rec.trx_id
1134: AND application_id = p_event_class_rec.application_id
1135: AND event_class_code = p_event_class_rec.event_class_code
1136: AND entity_code = p_event_class_rec.entity_code
1145: AND recalc_required_flag = 'Y'
1146: ORDER BY manually_entered_flag DESC;
1147:
1148: CURSOR get_tax_lines_override_ri IS
1149: SELECT * FROM zx_lines
1150: WHERE trx_id = p_event_class_rec.trx_id
1151: AND application_id = p_event_class_rec.application_id
1152: AND event_class_code = p_event_class_rec.event_class_code
1153: AND entity_code = p_event_class_rec.entity_code
1162: AND (recalc_required_flag = 'Y' OR tax_amt_included_flag = 'Y')
1163: ORDER BY manually_entered_flag DESC;
1164:
1165: CURSOR get_tax_lines_override_rc IS
1166: SELECT * FROM zx_lines
1167: WHERE trx_id = p_event_class_rec.trx_id
1168: AND application_id = p_event_class_rec.application_id
1169: AND event_class_code = p_event_class_rec.event_class_code
1170: AND entity_code = p_event_class_rec.entity_code
1180: ORDER BY manually_entered_flag DESC, compounding_tax_flag DESC,
1181: compounding_dep_tax_flag;
1182:
1183: CURSOR get_tax_lines_override_a IS
1184: SELECT * FROM zx_lines
1185: WHERE trx_id = p_event_class_rec.trx_id
1186: AND application_id = p_event_class_rec.application_id
1187: AND event_class_code = p_event_class_rec.event_class_code
1188: AND entity_code = p_event_class_rec.entity_code
1201:
1202: -- fetch all tax lines for migrated transaction
1203: --
1204: CURSOR get_all_tax_lines_migrated IS
1205: SELECT * FROM zx_lines
1206: WHERE trx_id = p_event_class_rec.trx_id
1207: AND application_id = p_event_class_rec.application_id
1208: AND event_class_code = p_event_class_rec.event_class_code
1209: AND entity_code = p_event_class_rec.entity_code
1222: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
1223: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
1224: l_tax_jurisdiction_rec ZX_TDS_UTILITIES_PKG.zx_jur_info_cache_rec_type;
1225:
1226: l_current_line_amt zx_lines.line_amt%TYPE;
1227: l_rownum BINARY_INTEGER;
1228: l_error_buffer VARCHAR2(200);
1229:
1230: l_tax_class ZX_RATES_B.tax_class%TYPE;
1229:
1230: l_tax_class ZX_RATES_B.tax_class%TYPE;
1231:
1232: -- bug fix 5525890
1233: l_tax_amt_included_flag_usr zx_lines.tax_amt_included_flag%TYPE;
1234: l_self_assessed_flag_usr zx_lines.self_assessed_flag%TYPE;
1235:
1236: BEGIN
1237:
1230: l_tax_class ZX_RATES_B.tax_class%TYPE;
1231:
1232: -- bug fix 5525890
1233: l_tax_amt_included_flag_usr zx_lines.tax_amt_included_flag%TYPE;
1234: l_self_assessed_flag_usr zx_lines.self_assessed_flag%TYPE;
1235:
1236: BEGIN
1237:
1238: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1264: FOR tax_line_rec IN get_all_tax_lines_migrated LOOP
1265:
1266: l_rownum := l_rownum + 1;
1267:
1268: -- populate tax info fetched from zx_lines to g_detail_tax_lines_tbl
1269: --
1270: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_rownum) := tax_line_rec;
1271:
1272: -- populate tax cache : bug 5167406
1414: FOR tax_line_rec IN get_tax_lines_override_r LOOP
1415:
1416: l_rownum := l_rownum + 1;
1417:
1418: -- populate tax info fetched from zx_lines to g_detail_tax_lines_tbl
1419: --
1420: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_rownum) := tax_line_rec;
1421:
1422: -- populate tax cache : bug 5167406
1565: FOR tax_line_rec IN get_tax_lines_override_ri LOOP
1566:
1567: l_rownum := l_rownum + 1;
1568:
1569: -- populate tax info fetched from zx_lines to g_detail_tax_lines_tbl
1570: --
1571: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_rownum) := tax_line_rec;
1572:
1573: -- populate tax cache : bug 5167406
1668: FOR tax_line_rec IN get_tax_lines_override_rc LOOP
1669:
1670: l_rownum := l_rownum + 1;
1671:
1672: -- populate tax info fetched from zx_lines to g_detail_tax_lines_tbl
1673: --
1674: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_rownum) := tax_line_rec;
1675:
1676: -- populate tax cache : bug 5167406
1771: FOR tax_line_rec IN get_tax_lines_override_a LOOP
1772:
1773: l_rownum := l_rownum + 1;
1774:
1775: -- populate tax info fetched from zx_lines to g_detail_tax_lines_tbl
1776: --
1777: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_rownum) := tax_line_rec;
1778:
1779: -- populate tax cache : bug 5167406
1877: FOR tax_line_rec IN get_manual_tax_lines LOOP
1878:
1879: l_rownum := l_rownum + 1;
1880:
1881: -- populate tax info fetched from zx_lines to g_detail_tax_lines_tbl
1882: --
1883: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_rownum) := tax_line_rec;
1884:
1885: -- 10029625
2243: --IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2244: -- p_trx_line_index) = 'UPDATE' THEN
2245: -- copy transaction info to manual tax lines
2246: --
2247: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines (p_trx_line_index,
2248: x_begin_index,
2249: x_end_index,
2250: x_return_status,
2251: l_error_buffer );
2254: IF (g_level_statement >= g_current_runtime_level ) THEN
2255: FND_LOG.STRING(g_level_statement,
2256: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2257: 'Incorrect RETURN_STATUS after calling '||
2258: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
2259: FND_LOG.STRING(g_level_statement,
2260: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2261: 'RETURN_STATUS = ' || x_return_status);
2262: FND_LOG.STRING(g_level_statement,
2334: l_direct_rate_result_rec zx_process_results%ROWTYPE;
2335: l_tax_applicable BOOLEAN;
2336:
2337: /* Commented out as part of restructuring for STCC (bug 4959835)
2338: l_last_manual_entry zx_lines.last_manual_entry%TYPE;
2339: l_tax_status_code zx_lines.tax_status_code%TYPE;
2340: l_orig_tax_status_id zx_lines.orig_tax_status_id%TYPE;
2341: l_orig_tax_status_code zx_lines.orig_tax_status_code%TYPE;
2342: l_tax_rate_code zx_lines.tax_rate_code%TYPE;
2335: l_tax_applicable BOOLEAN;
2336:
2337: /* Commented out as part of restructuring for STCC (bug 4959835)
2338: l_last_manual_entry zx_lines.last_manual_entry%TYPE;
2339: l_tax_status_code zx_lines.tax_status_code%TYPE;
2340: l_orig_tax_status_id zx_lines.orig_tax_status_id%TYPE;
2341: l_orig_tax_status_code zx_lines.orig_tax_status_code%TYPE;
2342: l_tax_rate_code zx_lines.tax_rate_code%TYPE;
2343: l_tax_rate zx_lines.tax_rate%TYPE;
2336:
2337: /* Commented out as part of restructuring for STCC (bug 4959835)
2338: l_last_manual_entry zx_lines.last_manual_entry%TYPE;
2339: l_tax_status_code zx_lines.tax_status_code%TYPE;
2340: l_orig_tax_status_id zx_lines.orig_tax_status_id%TYPE;
2341: l_orig_tax_status_code zx_lines.orig_tax_status_code%TYPE;
2342: l_tax_rate_code zx_lines.tax_rate_code%TYPE;
2343: l_tax_rate zx_lines.tax_rate%TYPE;
2344: l_orig_tax_rate_id zx_lines.orig_tax_rate_id%TYPE;
2337: /* Commented out as part of restructuring for STCC (bug 4959835)
2338: l_last_manual_entry zx_lines.last_manual_entry%TYPE;
2339: l_tax_status_code zx_lines.tax_status_code%TYPE;
2340: l_orig_tax_status_id zx_lines.orig_tax_status_id%TYPE;
2341: l_orig_tax_status_code zx_lines.orig_tax_status_code%TYPE;
2342: l_tax_rate_code zx_lines.tax_rate_code%TYPE;
2343: l_tax_rate zx_lines.tax_rate%TYPE;
2344: l_orig_tax_rate_id zx_lines.orig_tax_rate_id%TYPE;
2345: l_orig_tax_rate_code zx_lines.orig_tax_rate_code%TYPE;
2338: l_last_manual_entry zx_lines.last_manual_entry%TYPE;
2339: l_tax_status_code zx_lines.tax_status_code%TYPE;
2340: l_orig_tax_status_id zx_lines.orig_tax_status_id%TYPE;
2341: l_orig_tax_status_code zx_lines.orig_tax_status_code%TYPE;
2342: l_tax_rate_code zx_lines.tax_rate_code%TYPE;
2343: l_tax_rate zx_lines.tax_rate%TYPE;
2344: l_orig_tax_rate_id zx_lines.orig_tax_rate_id%TYPE;
2345: l_orig_tax_rate_code zx_lines.orig_tax_rate_code%TYPE;
2346: l_orig_tax_rate zx_lines.orig_tax_rate%TYPE;
2339: l_tax_status_code zx_lines.tax_status_code%TYPE;
2340: l_orig_tax_status_id zx_lines.orig_tax_status_id%TYPE;
2341: l_orig_tax_status_code zx_lines.orig_tax_status_code%TYPE;
2342: l_tax_rate_code zx_lines.tax_rate_code%TYPE;
2343: l_tax_rate zx_lines.tax_rate%TYPE;
2344: l_orig_tax_rate_id zx_lines.orig_tax_rate_id%TYPE;
2345: l_orig_tax_rate_code zx_lines.orig_tax_rate_code%TYPE;
2346: l_orig_tax_rate zx_lines.orig_tax_rate%TYPE;
2347: l_tax_amt zx_lines.tax_amt%TYPE;
2340: l_orig_tax_status_id zx_lines.orig_tax_status_id%TYPE;
2341: l_orig_tax_status_code zx_lines.orig_tax_status_code%TYPE;
2342: l_tax_rate_code zx_lines.tax_rate_code%TYPE;
2343: l_tax_rate zx_lines.tax_rate%TYPE;
2344: l_orig_tax_rate_id zx_lines.orig_tax_rate_id%TYPE;
2345: l_orig_tax_rate_code zx_lines.orig_tax_rate_code%TYPE;
2346: l_orig_tax_rate zx_lines.orig_tax_rate%TYPE;
2347: l_tax_amt zx_lines.tax_amt%TYPE;
2348: l_orig_tax_amt zx_lines.orig_tax_amt%TYPE;
2341: l_orig_tax_status_code zx_lines.orig_tax_status_code%TYPE;
2342: l_tax_rate_code zx_lines.tax_rate_code%TYPE;
2343: l_tax_rate zx_lines.tax_rate%TYPE;
2344: l_orig_tax_rate_id zx_lines.orig_tax_rate_id%TYPE;
2345: l_orig_tax_rate_code zx_lines.orig_tax_rate_code%TYPE;
2346: l_orig_tax_rate zx_lines.orig_tax_rate%TYPE;
2347: l_tax_amt zx_lines.tax_amt%TYPE;
2348: l_orig_tax_amt zx_lines.orig_tax_amt%TYPE;
2349: l_taxable_amt zx_lines.taxable_amt%TYPE;
2342: l_tax_rate_code zx_lines.tax_rate_code%TYPE;
2343: l_tax_rate zx_lines.tax_rate%TYPE;
2344: l_orig_tax_rate_id zx_lines.orig_tax_rate_id%TYPE;
2345: l_orig_tax_rate_code zx_lines.orig_tax_rate_code%TYPE;
2346: l_orig_tax_rate zx_lines.orig_tax_rate%TYPE;
2347: l_tax_amt zx_lines.tax_amt%TYPE;
2348: l_orig_tax_amt zx_lines.orig_tax_amt%TYPE;
2349: l_taxable_amt zx_lines.taxable_amt%TYPE;
2350: l_orig_taxable_amt zx_lines.orig_taxable_amt%TYPE;
2343: l_tax_rate zx_lines.tax_rate%TYPE;
2344: l_orig_tax_rate_id zx_lines.orig_tax_rate_id%TYPE;
2345: l_orig_tax_rate_code zx_lines.orig_tax_rate_code%TYPE;
2346: l_orig_tax_rate zx_lines.orig_tax_rate%TYPE;
2347: l_tax_amt zx_lines.tax_amt%TYPE;
2348: l_orig_tax_amt zx_lines.orig_tax_amt%TYPE;
2349: l_taxable_amt zx_lines.taxable_amt%TYPE;
2350: l_orig_taxable_amt zx_lines.orig_taxable_amt%TYPE;
2351: l_line_amt zx_lines.line_amt%TYPE;
2344: l_orig_tax_rate_id zx_lines.orig_tax_rate_id%TYPE;
2345: l_orig_tax_rate_code zx_lines.orig_tax_rate_code%TYPE;
2346: l_orig_tax_rate zx_lines.orig_tax_rate%TYPE;
2347: l_tax_amt zx_lines.tax_amt%TYPE;
2348: l_orig_tax_amt zx_lines.orig_tax_amt%TYPE;
2349: l_taxable_amt zx_lines.taxable_amt%TYPE;
2350: l_orig_taxable_amt zx_lines.orig_taxable_amt%TYPE;
2351: l_line_amt zx_lines.line_amt%TYPE;
2352: l_current_line_amt zx_lines.line_amt%TYPE;
2345: l_orig_tax_rate_code zx_lines.orig_tax_rate_code%TYPE;
2346: l_orig_tax_rate zx_lines.orig_tax_rate%TYPE;
2347: l_tax_amt zx_lines.tax_amt%TYPE;
2348: l_orig_tax_amt zx_lines.orig_tax_amt%TYPE;
2349: l_taxable_amt zx_lines.taxable_amt%TYPE;
2350: l_orig_taxable_amt zx_lines.orig_taxable_amt%TYPE;
2351: l_line_amt zx_lines.line_amt%TYPE;
2352: l_current_line_amt zx_lines.line_amt%TYPE;
2353: */
2346: l_orig_tax_rate zx_lines.orig_tax_rate%TYPE;
2347: l_tax_amt zx_lines.tax_amt%TYPE;
2348: l_orig_tax_amt zx_lines.orig_tax_amt%TYPE;
2349: l_taxable_amt zx_lines.taxable_amt%TYPE;
2350: l_orig_taxable_amt zx_lines.orig_taxable_amt%TYPE;
2351: l_line_amt zx_lines.line_amt%TYPE;
2352: l_current_line_amt zx_lines.line_amt%TYPE;
2353: */
2354:
2347: l_tax_amt zx_lines.tax_amt%TYPE;
2348: l_orig_tax_amt zx_lines.orig_tax_amt%TYPE;
2349: l_taxable_amt zx_lines.taxable_amt%TYPE;
2350: l_orig_taxable_amt zx_lines.orig_taxable_amt%TYPE;
2351: l_line_amt zx_lines.line_amt%TYPE;
2352: l_current_line_amt zx_lines.line_amt%TYPE;
2353: */
2354:
2355: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
2348: l_orig_tax_amt zx_lines.orig_tax_amt%TYPE;
2349: l_taxable_amt zx_lines.taxable_amt%TYPE;
2350: l_orig_taxable_amt zx_lines.orig_taxable_amt%TYPE;
2351: l_line_amt zx_lines.line_amt%TYPE;
2352: l_current_line_amt zx_lines.line_amt%TYPE;
2353: */
2354:
2355: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
2356: l_tax_amt_included_flag zx_lines.tax_amt_included_flag%TYPE;
2351: l_line_amt zx_lines.line_amt%TYPE;
2352: l_current_line_amt zx_lines.line_amt%TYPE;
2353: */
2354:
2355: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
2356: l_tax_amt_included_flag zx_lines.tax_amt_included_flag%TYPE;
2357: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
2358: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
2359: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2352: l_current_line_amt zx_lines.line_amt%TYPE;
2353: */
2354:
2355: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
2356: l_tax_amt_included_flag zx_lines.tax_amt_included_flag%TYPE;
2357: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
2358: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
2359: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2360: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
2353: */
2354:
2355: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
2356: l_tax_amt_included_flag zx_lines.tax_amt_included_flag%TYPE;
2357: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
2358: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
2359: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2360: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
2361:
2354:
2355: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
2356: l_tax_amt_included_flag zx_lines.tax_amt_included_flag%TYPE;
2357: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
2358: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
2359: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2360: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
2361:
2362: l_error_buffer VARCHAR2(200);
2362: l_error_buffer VARCHAR2(200);
2363: l_tax_tbl_subscript NUMBER;
2364:
2365: l_trx_line_id NUMBER;
2366: l_trx_level_type zx_lines.trx_level_type%TYPE;
2367: l_begin_index BINARY_INTEGER;
2368: l_end_index BINARY_INTEGER;
2369:
2370: /* Bug4959835: Moved to handle_update_scenarios
2367: l_begin_index BINARY_INTEGER;
2368: l_end_index BINARY_INTEGER;
2369:
2370: /* Bug4959835: Moved to handle_update_scenarios
2371: l_unrounded_taxable_amt zx_lines.unrounded_taxable_amt%TYPE;
2372: l_unrounded_tax_amt zx_lines.unrounded_tax_amt%TYPE;
2373: l_cal_tax_amt zx_lines.cal_tax_amt%TYPE;
2374: */
2375:
2368: l_end_index BINARY_INTEGER;
2369:
2370: /* Bug4959835: Moved to handle_update_scenarios
2371: l_unrounded_taxable_amt zx_lines.unrounded_taxable_amt%TYPE;
2372: l_unrounded_tax_amt zx_lines.unrounded_tax_amt%TYPE;
2373: l_cal_tax_amt zx_lines.cal_tax_amt%TYPE;
2374: */
2375:
2376: l_jur_index NUMBER;
2369:
2370: /* Bug4959835: Moved to handle_update_scenarios
2371: l_unrounded_taxable_amt zx_lines.unrounded_taxable_amt%TYPE;
2372: l_unrounded_tax_amt zx_lines.unrounded_tax_amt%TYPE;
2373: l_cal_tax_amt zx_lines.cal_tax_amt%TYPE;
2374: */
2375:
2376: l_jur_index NUMBER;
2377:
2459: AND rownum = 1)
2460: ORDER BY compounding_precedence;
2461:
2462: /* Bug 4959835: Moved to procedure handle_update_scenarios
2463: CURSOR get_key_columns_cur(p_tax zx_lines.tax%TYPE) IS
2464: SELECT tax_line_id,
2465: last_manual_entry,
2466: tax_status_code,
2467: orig_tax_status_id,
2487: unrounded_taxable_amt,
2488: unrounded_tax_amt,
2489: cal_tax_amt,
2490: associated_child_frozen_flag
2491: FROM zx_lines
2492: WHERE application_id = p_event_class_rec.application_id
2493: AND entity_code = p_event_class_rec.entity_code
2494: AND event_class_code = p_event_class_rec.event_class_code
2495: AND trx_id = p_event_class_rec.trx_id
2501: AND tax = p_tax
2502: AND mrc_tax_line_flag = 'N';
2503:
2504: CURSOR enforce_rate_code_from_ref_doc(
2505: c_tax zx_lines.tax%TYPE,
2506: c_tax_regime_code zx_lines.tax_regime_code%TYPE) IS
2507: SELECT tax_status_code,
2508: tax_rate_code,
2509: line_amt,
2502: AND mrc_tax_line_flag = 'N';
2503:
2504: CURSOR enforce_rate_code_from_ref_doc(
2505: c_tax zx_lines.tax%TYPE,
2506: c_tax_regime_code zx_lines.tax_regime_code%TYPE) IS
2507: SELECT tax_status_code,
2508: tax_rate_code,
2509: line_amt,
2510: tax_amt,
2508: tax_rate_code,
2509: line_amt,
2510: tax_amt,
2511: taxable_amt
2512: FROM zx_lines
2513: WHERE application_id =
2514: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(p_trx_line_index)
2515: AND event_class_code =
2516: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(p_trx_line_index)
3101:
3102: ELSE -- 'CREATE'
3103: /*
3104: * will be populated by pop_tax_line_for_trx_line
3105: * SELECT zx_lines_s.NEXTVAL
3106: * INTO ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3107: * l_new_row_num).tax_line_id
3108: * FROM dual;
3109: */
3163: l_place_of_supply_type_code;
3164:
3165: -- if orig_tax_jurisdiction_code(id) is not NULL (for UPDATE),
3166: -- populate tax_jurisdiction_code and tax_jurisdiction_id fetched
3167: -- from zx_lines. Otherwise, populate new tax_jurisdiction_code
3168: -- and tax_jurisdiction_id from most inner jurisdiction info
3169: --
3170:
3171: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3348: END IF;
3349:
3350: -- If orig_tax_amt_included_flag/orig_self_assessed_flag is not NULL
3351: -- (for UPDATE), populate tax_amt_included_flag/self_assessed_flag
3352: -- fetched from zx_lines. Otherwise, keep tax_amt_included_flag/
3353: -- self_assessed_flag returned from get_tax_registration
3354: --
3355: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3356: l_new_row_num).orig_tax_amt_included_flag IS NOT NULL THEN
3553: END IF; -- p_event_class_rec.enforce_tax_from_ref_doc_flag = 'Y'
3554:
3555: -- copy transaction info to new tax lines
3556: --
3557: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines (p_trx_line_index,
3558: x_begin_index,
3559: x_end_index,
3560: x_return_status,
3561: l_error_buffer );
3564: IF (g_level_statement >= g_current_runtime_level ) THEN
3565: FND_LOG.STRING(g_level_statement,
3566: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3567: 'Incorrect RETURN_STATUS after calling '||
3568: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
3569: FND_LOG.STRING(g_level_statement,
3570: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3571: 'RETURN_STATUS = ' || x_return_status);
3572: FND_LOG.STRING(g_level_statement,
3629: x_end_index IN OUT NOCOPY BINARY_INTEGER,
3630: x_return_status OUT NOCOPY VARCHAR2) IS
3631:
3632: CURSOR get_tax_lines IS
3633: SELECT * FROM zx_lines
3634: WHERE application_id =
3635: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
3636: AND entity_code =
3637: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
3721: --
3722: /*
3723: * will be populated by pop_tax_line_for_trx_line
3724: *
3725: * SELECT zx_lines_s.NEXTVAL
3726: * INTO ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3727: * l_new_row_num).tax_line_id from dual;
3728: */
3729: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3985:
3986: IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index) = 200 THEN
3987: SELECT line_amt
3988: INTO l_orig_amt
3989: FROM zx_lines_det_factors
3990: WHERE application_id =
3991: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
3992: AND entity_code =
3993: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
4001: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index);
4002:
4003: SELECT sum(line_amt)
4004: INTO l_appl_line_amt
4005: FROM zx_lines_det_factors
4006: WHERE applied_from_application_id =
4007: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
4008: AND applied_from_entity_code =
4009: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
4017: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_trx_level_type(p_trx_line_index);
4018:
4019: SELECT sum(tax_amt)
4020: INTO l_appl_tax_amt
4021: FROM zx_lines
4022: WHERE applied_from_application_id =
4023: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
4024: AND applied_from_entity_code =
4025: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
4277: END IF;
4278:
4279: -- copy transaction info to new tax lines for new tax_lines created here
4280: --
4281: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines(
4282: p_trx_line_index ,
4283: l_begin_index,
4284: x_end_index,
4285: x_return_status,
4289: IF (g_level_statement >= g_current_runtime_level ) THEN
4290: FND_LOG.STRING(g_level_statement,
4291: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
4292: 'Incorrect return_status after calling ' ||
4293: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
4294: FND_LOG.STRING(g_level_statement,
4295: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
4296: 'RETURN_STATUS = ' || x_return_status);
4297: FND_LOG.STRING(g_level_statement,
4350: x_end_index IN OUT NOCOPY BINARY_INTEGER,
4351: x_return_status OUT NOCOPY VARCHAR2) IS
4352:
4353: CURSOR get_tax_lines IS
4354: SELECT * FROM zx_lines
4355: WHERE application_id =
4356: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_index)
4357: AND entity_code =
4358: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_index)
4383: -- Bug 7597449 Added Tax apportionment line number to pick the correct tax line id for upgraded invoices which have same regime-tax information.
4384: CURSOR get_key_columns_cur
4385: (c_tax_regime_code zx_regimes_b.tax_regime_code%TYPE,
4386: c_tax zx_taxes_b.tax%TYPE,
4387: c_apportionment_line_number zx_lines.tax_apportionment_line_number%type) IS
4388: SELECT * FROM zx_lines
4389: WHERE application_id = p_event_class_rec.application_id
4390: AND entity_code = p_event_class_rec.entity_code
4391: AND event_class_code = p_event_class_rec.event_class_code
4384: CURSOR get_key_columns_cur
4385: (c_tax_regime_code zx_regimes_b.tax_regime_code%TYPE,
4386: c_tax zx_taxes_b.tax%TYPE,
4387: c_apportionment_line_number zx_lines.tax_apportionment_line_number%type) IS
4388: SELECT * FROM zx_lines
4389: WHERE application_id = p_event_class_rec.application_id
4390: AND entity_code = p_event_class_rec.entity_code
4391: AND event_class_code = p_event_class_rec.event_class_code
4392: AND trx_id = p_event_class_rec.trx_id
4398: AND tax = c_tax
4399: AND tax_apportionment_line_number = c_apportionment_line_number
4400: AND mrc_tax_line_flag = 'N';
4401:
4402: l_tax_line_rec zx_lines%ROWTYPE;
4403: l_new_row_num NUMBER;
4404: l_begin_index BINARY_INTEGER;
4405: l_error_buffer VARCHAR2(200);
4406:
4460: --
4461: /*
4462: * will be populated by pop_tax_line_for_trx_line
4463: *
4464: * SELECT zx_lines_s.NEXTVAL
4465: * INTO ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4466: * l_new_row_num).tax_line_id from dual;
4467: */
4468:
5103: END IF;
5104:
5105: -- copy transaction info to new tax lines for new tax_lines created here
5106: --
5107: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines(
5108: p_trx_line_index ,
5109: l_begin_index,
5110: x_end_index,
5111: x_return_status ,
5115: IF (g_level_statement >= g_current_runtime_level ) THEN
5116: FND_LOG.STRING(g_level_statement,
5117: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust',
5118: 'Incorrect return_status after calling ' ||
5119: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
5120: FND_LOG.STRING(g_level_statement,
5121: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust',
5122: 'RETURN_STATUS = ' || x_return_status);
5123: FND_LOG.STRING(g_level_statement,
5732: p_structure_index IN BINARY_INTEGER,
5733: p_event_class_rec IN zx_api_pub.event_class_rec_type,
5734: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
5735: p_tax IN zx_taxes_b.tax%TYPE,
5736: p_tax_determine_date IN zx_lines.tax_determine_date%TYPE,
5737: p_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
5738: p_reg_party_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
5739: x_registration_rec OUT NOCOPY zx_tcm_control_pkg.zx_registration_info_rec,
5740: x_return_status OUT NOCOPY VARCHAR2
5752: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5753: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5754: l_account_type_code VARCHAR2(30);
5755: l_first_party_flag BOOLEAN;
5756: l_hq_estb_ptp_id zx_lines.hq_estb_party_tax_prof_id%TYPE;
5757: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
5758:
5759: -- Bug#5395227
5760: l_tax_rec ZX_TDS_UTILITIES_PKG.ZX_TAX_INFO_CACHE_REC;
6421: p_tax_line_index IN BINARY_INTEGER,
6422: x_return_status OUT NOCOPY VARCHAR2,
6423: x_error_buffer OUT NOCOPY VARCHAR2)
6424: IS
6425: l_hq_estb_ptp_id zx_lines.hq_estb_party_tax_prof_id%TYPE;
6426: i BINARY_INTEGER;
6427: l_tax_id BINARY_INTEGER;
6428: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
6429: l_ret_record_level VARCHAR2(30);
6679:
6680: l_tax_id NUMBER;
6681: l_error_buffer VARCHAR2(200);
6682: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
6683: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
6684: BEGIN
6685:
6686: x_return_status := FND_API.G_RET_STS_SUCCESS;
6687:
7509: END IF;
7510:
7511: -- copy transaction info to new tax lines
7512: --
7513: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines(
7514: p_trx_line_index,
7515: l_begin_index_from_acct,
7516: l_end_index_from_acct,
7517: x_return_status,
7521: IF (g_level_statement >= g_current_runtime_level ) THEN
7522: FND_LOG.STRING(g_level_statement,
7523: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
7524: 'Incorrect return_status after calling ' ||
7525: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
7526: FND_LOG.STRING(g_level_statement,
7527: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
7528: 'RETURN_STATUS = ' || x_return_status);
7529: FND_LOG.STRING(g_level_statement,
7575: x_return_status OUT NOCOPY VARCHAR2) IS
7576:
7577: CURSOR get_taxes_f_intercomp_trx_csr IS
7578: SELECT zxl.*
7579: FROM zx_lines zxl, zx_evnt_cls_mappings map
7580: WHERE map.application_id =
7581: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index)
7582: AND map.entity_code =
7583: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index)
7700:
7701: l_is_valid := TRUE;
7702: l_rownum := l_rownum + 1;
7703:
7704: -- populate tax info fetched from zx_lines to g_detail_tax_lines_tbl
7705: --
7706: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_rownum) := tax_line_rec;
7707:
7708: -- set tax_line_id to NULL. It will be reset in pop_tax_line_for_trx_line
8487: IF (x_begin_index IS NOT NULL) THEN
8488: x_end_index := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST;
8489: END IF;
8490:
8491: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines (p_trx_line_index,
8492: x_begin_index,
8493: x_end_index,
8494: x_return_status,
8495: l_error_buffer );
8498: IF (g_level_statement >= g_current_runtime_level ) THEN
8499: FND_LOG.STRING(g_level_statement,
8500: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
8501: 'Incorrect RETURN_STATUS after calling '||
8502: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
8503: FND_LOG.STRING(g_level_statement,
8504: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
8505: 'RETURN_STATUS = ' || x_return_status);
8506: FND_LOG.STRING(g_level_statement,
8552: x_end_index IN OUT NOCOPY BINARY_INTEGER,
8553: x_return_status OUT NOCOPY VARCHAR2) IS
8554:
8555: CURSOR get_unique_constraint_csr(
8556: c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE,
8557: c_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE)
8558: IS
8559: SELECT cg.constraint_id
8560: FROM zx_condition_groups_b cg,
8553: x_return_status OUT NOCOPY VARCHAR2) IS
8554:
8555: CURSOR get_unique_constraint_csr(
8556: c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE,
8557: c_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE)
8558: IS
8559: SELECT cg.constraint_id
8560: FROM zx_condition_groups_b cg,
8561: ar_tax_conditions_all tc
8566: AND tc.org_id = c_internal_organization_id;
8567:
8568:
8569: -- CURSOR get_constraints_csr
8570: -- (c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE)
8571: -- IS
8572: -- SELECT cg.CONSTRAINT_ID
8573: -- FROM zx_condition_groups_b cg
8574: -- WHERE cg.CONDITION_GROUP_CODE like c_tax_classification_code||'~'||'%'
8576: -- AND cg.constraint_id IS NOT NULL;
8577: --
8578: --
8579: -- CURSOR get_unique_constraint_csr(
8580: -- c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE,
8581: -- c_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE)
8582: -- IS
8583: -- SELECT cg.constraint_id
8584: -- FROM zx_condition_groups_b cg,
8577: --
8578: --
8579: -- CURSOR get_unique_constraint_csr(
8580: -- c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE,
8581: -- c_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE)
8582: -- IS
8583: -- SELECT cg.constraint_id
8584: -- FROM zx_condition_groups_b cg,
8585: -- ar_tax_conditions tc
8771: -- Local variables
8772: --
8773: l_constraint_id zx_condition_groups_b.constraint_id%TYPE;
8774: l_condition_group_code zx_condition_groups_b.condition_group_code%TYPE;
8775: l_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE;
8776: l_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE;
8777: l_cec_result BOOLEAN;
8778: l_action_rec_tbl ZX_TDS_PROCESS_CEC_PVT.action_rec_tbl_type;
8779: l_tax_regime_code_tbl tax_regime_code_tbl;
8772: --
8773: l_constraint_id zx_condition_groups_b.constraint_id%TYPE;
8774: l_condition_group_code zx_condition_groups_b.condition_group_code%TYPE;
8775: l_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE;
8776: l_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE;
8777: l_cec_result BOOLEAN;
8778: l_action_rec_tbl ZX_TDS_PROCESS_CEC_PVT.action_rec_tbl_type;
8779: l_tax_regime_code_tbl tax_regime_code_tbl;
8780: l_tax_tbl tax_tbl;
8805: l_tax_index NUMBER;
8806: l_trx_line_id NUMBER;
8807: l_trx_level_type VARCHAR2(30);
8808:
8809: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
8810: l_tax_amt_included_flag zx_lines.tax_amt_included_flag%TYPE;
8811: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
8812: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
8813: l_jur_index NUMBER;
8806: l_trx_line_id NUMBER;
8807: l_trx_level_type VARCHAR2(30);
8808:
8809: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
8810: l_tax_amt_included_flag zx_lines.tax_amt_included_flag%TYPE;
8811: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
8812: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
8813: l_jur_index NUMBER;
8814: l_jurisdiction_rec_tbl ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_tbl_type;
8807: l_trx_level_type VARCHAR2(30);
8808:
8809: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
8810: l_tax_amt_included_flag zx_lines.tax_amt_included_flag%TYPE;
8811: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
8812: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
8813: l_jur_index NUMBER;
8814: l_jurisdiction_rec_tbl ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_tbl_type;
8815: l_index NUMBER;
8808:
8809: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
8810: l_tax_amt_included_flag zx_lines.tax_amt_included_flag%TYPE;
8811: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
8812: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
8813: l_jur_index NUMBER;
8814: l_jurisdiction_rec_tbl ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_tbl_type;
8815: l_index NUMBER;
8816: l_tbl_index BINARY_INTEGER;
8817: l_rate_exists_same_prod_family BOOLEAN;
8818: l_tax_applicable BOOLEAN;
8819: l_applicability_result_id NUMBER;
8820: l_applicability_result zx_process_results.alphanumeric_result%TYPE;
8821: l_exception_rate zx_lines.exception_rate%TYPE;
8822:
8823: -- Added for Bug 10184087
8824: l_ref_doc_tax_applicable BOOLEAN;
8825: l_tmp_tax_apportionmt_ln_num NUMBER;
9803: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
9804:
9805: -- if orig_tax_jurisdiction_code(id) is not NULL (for UPDATE),
9806: -- populate tax_jurisdiction_code and tax_jurisdiction_id fetched
9807: -- from zx_lines. Otherwise, populate new tax_jurisdiction_code
9808: -- and tax_jurisdiction_id from most inner jurisdiction info
9809: --
9810: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
9811: l_rownum).orig_tax_jurisdiction_code IS NOT NULL
9923: END IF;
9924:
9925: -- If orig_tax_amt_included_flag/orig_self_assessed_flag is not NULL
9926: -- (for UPDATE), populate tax_amt_included_flag/self_assessed_flag
9927: -- fetched from zx_lines. Otherwise, keep tax_amt_included_flag/
9928: -- self_assessed_flag returned from get_tax_registration
9929: --
9930: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
9931: l_rownum).orig_tax_amt_included_flag IS NOT NULL THEN
10075: END IF;
10076:
10077: -- copy transaction info to new tax lines
10078:
10079: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines (p_trx_line_index,
10080: x_begin_index,
10081: x_end_index,
10082: x_return_status,
10083: l_error_buffer );
10086: IF (g_level_statement >= g_current_runtime_level ) THEN
10087: FND_LOG.STRING(g_level_statement,
10088: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
10089: 'Incorrect RETURN_STATUS after calling '||
10090: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
10091: FND_LOG.STRING(g_level_statement,
10092: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
10093: 'RETURN_STATUS = ' || x_return_status);
10094: FND_LOG.STRING(g_level_statement,
10188: p_tax IN zx_taxes_b.tax%TYPE,
10189: p_tax_date IN DATE,
10190: p_tax_determine_date IN DATE,
10191: p_tax_point_date IN DATE,
10192: x_self_assessed_flag OUT NOCOPY zx_lines.self_assessed_flag%TYPE,
10193: x_tax_amt_included_flag OUT NOCOPY zx_lines.tax_amt_included_flag%TYPE,
10194: x_tax_jurisdiction_id OUT NOCOPY zx_lines.tax_jurisdiction_id%TYPE,
10195: x_tax_jurisdiction_code OUT NOCOPY zx_lines.tax_jurisdiction_code%TYPE,
10196: x_return_status OUT NOCOPY VARCHAR2) IS
10189: p_tax_date IN DATE,
10190: p_tax_determine_date IN DATE,
10191: p_tax_point_date IN DATE,
10192: x_self_assessed_flag OUT NOCOPY zx_lines.self_assessed_flag%TYPE,
10193: x_tax_amt_included_flag OUT NOCOPY zx_lines.tax_amt_included_flag%TYPE,
10194: x_tax_jurisdiction_id OUT NOCOPY zx_lines.tax_jurisdiction_id%TYPE,
10195: x_tax_jurisdiction_code OUT NOCOPY zx_lines.tax_jurisdiction_code%TYPE,
10196: x_return_status OUT NOCOPY VARCHAR2) IS
10197:
10190: p_tax_determine_date IN DATE,
10191: p_tax_point_date IN DATE,
10192: x_self_assessed_flag OUT NOCOPY zx_lines.self_assessed_flag%TYPE,
10193: x_tax_amt_included_flag OUT NOCOPY zx_lines.tax_amt_included_flag%TYPE,
10194: x_tax_jurisdiction_id OUT NOCOPY zx_lines.tax_jurisdiction_id%TYPE,
10195: x_tax_jurisdiction_code OUT NOCOPY zx_lines.tax_jurisdiction_code%TYPE,
10196: x_return_status OUT NOCOPY VARCHAR2) IS
10197:
10198: -- Local variables
10191: p_tax_point_date IN DATE,
10192: x_self_assessed_flag OUT NOCOPY zx_lines.self_assessed_flag%TYPE,
10193: x_tax_amt_included_flag OUT NOCOPY zx_lines.tax_amt_included_flag%TYPE,
10194: x_tax_jurisdiction_id OUT NOCOPY zx_lines.tax_jurisdiction_id%TYPE,
10195: x_tax_jurisdiction_code OUT NOCOPY zx_lines.tax_jurisdiction_code%TYPE,
10196: x_return_status OUT NOCOPY VARCHAR2) IS
10197:
10198: -- Local variables
10199: l_current_line_amt zx_lines.line_amt%TYPE;
10195: x_tax_jurisdiction_code OUT NOCOPY zx_lines.tax_jurisdiction_code%TYPE,
10196: x_return_status OUT NOCOPY VARCHAR2) IS
10197:
10198: -- Local variables
10199: l_current_line_amt zx_lines.line_amt%TYPE;
10200: l_tax_line_rec zx_lines%ROWTYPE;
10201:
10202: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
10203: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
10196: x_return_status OUT NOCOPY VARCHAR2) IS
10197:
10198: -- Local variables
10199: l_current_line_amt zx_lines.line_amt%TYPE;
10200: l_tax_line_rec zx_lines%ROWTYPE;
10201:
10202: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
10203: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
10204: l_error_buffer VARCHAR2(200);
10206: l_tax_class zx_rates_b.tax_class%TYPE;
10207:
10208:
10209: CURSOR get_key_columns_cur IS
10210: SELECT * FROM zx_lines
10211: WHERE application_id = p_event_class_rec.application_id
10212: AND entity_code = p_event_class_rec.entity_code
10213: AND event_class_code = p_event_class_rec.event_class_code
10214: AND trx_id = p_event_class_rec.trx_id
10750:
10751: ELSIF get_key_columns_cur%NOTFOUND THEN
10752: /*
10753: * will be populated by pop_tax_line_for_trx_line
10754: * SELECT zx_lines_s.NEXTVAL
10755: * INTO ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
10756: * p_row_num).tax_line_id
10757: * FROM dual;
10758: */
10820: l_error_buffer VARCHAR2(200);
10821:
10822: -- Cursor definitions
10823: CURSOR enforce_rate_code_from_ref_doc(
10824: c_tax zx_lines.tax%TYPE,
10825: c_tax_regime_code zx_lines.tax_regime_code%TYPE) IS
10826: SELECT tax_status_code,
10827: tax_rate_code,
10828: line_amt,
10821:
10822: -- Cursor definitions
10823: CURSOR enforce_rate_code_from_ref_doc(
10824: c_tax zx_lines.tax%TYPE,
10825: c_tax_regime_code zx_lines.tax_regime_code%TYPE) IS
10826: SELECT tax_status_code,
10827: tax_rate_code,
10828: line_amt,
10829: tax_amt,
10830: taxable_amt,
10831: -- nipatel bug 6648042
10832: tax_apportionment_line_number
10833: -- nipatel bug 6648042
10834: FROM zx_lines
10835: WHERE application_id =
10836: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(p_trx_line_index)
10837: AND event_class_code =
10838: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(p_trx_line_index)