[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
1376: FOR tax_line_rec IN get_tax_lines_override_r LOOP
1377:
1378: l_rownum := l_rownum + 1;
1379:
1380: -- populate tax info fetched from zx_lines to g_detail_tax_lines_tbl
1381: --
1382: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_rownum) := tax_line_rec;
1383:
1384: -- populate tax cache : bug 5167406
1527: FOR tax_line_rec IN get_tax_lines_override_ri LOOP
1528:
1529: l_rownum := l_rownum + 1;
1530:
1531: -- populate tax info fetched from zx_lines to g_detail_tax_lines_tbl
1532: --
1533: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_rownum) := tax_line_rec;
1534:
1535: -- populate tax cache : bug 5167406
1630: FOR tax_line_rec IN get_tax_lines_override_rc LOOP
1631:
1632: l_rownum := l_rownum + 1;
1633:
1634: -- populate tax info fetched from zx_lines to g_detail_tax_lines_tbl
1635: --
1636: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_rownum) := tax_line_rec;
1637:
1638: -- populate tax cache : bug 5167406
1733: FOR tax_line_rec IN get_tax_lines_override_a LOOP
1734:
1735: l_rownum := l_rownum + 1;
1736:
1737: -- populate tax info fetched from zx_lines to g_detail_tax_lines_tbl
1738: --
1739: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_rownum) := tax_line_rec;
1740:
1741: -- populate tax cache : bug 5167406
1836: FOR tax_line_rec IN get_manual_tax_lines LOOP
1837:
1838: l_rownum := l_rownum + 1;
1839:
1840: -- populate tax info fetched from zx_lines to g_detail_tax_lines_tbl
1841: --
1842: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_rownum) := tax_line_rec;
1843:
1844: -- bug 7008562: Per Harsh and Desh, do not do validation for PO taxes
2185: --IF ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.line_level_action(
2186: -- p_trx_line_index) = 'UPDATE' THEN
2187: -- copy transaction info to manual tax lines
2188: --
2189: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines (p_trx_line_index,
2190: x_begin_index,
2191: x_end_index,
2192: x_return_status,
2193: l_error_buffer );
2196: IF (g_level_statement >= g_current_runtime_level ) THEN
2197: FND_LOG.STRING(g_level_statement,
2198: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2199: 'Incorrect RETURN_STATUS after calling '||
2200: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
2201: FND_LOG.STRING(g_level_statement,
2202: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.fetch_tax_lines',
2203: 'RETURN_STATUS = ' || x_return_status);
2204: FND_LOG.STRING(g_level_statement,
2276: l_direct_rate_result_rec zx_process_results%ROWTYPE;
2277: l_tax_applicable BOOLEAN;
2278:
2279: /* Commented out as part of restructuring for STCC (bug 4959835)
2280: l_last_manual_entry zx_lines.last_manual_entry%TYPE;
2281: l_tax_status_code zx_lines.tax_status_code%TYPE;
2282: l_orig_tax_status_id zx_lines.orig_tax_status_id%TYPE;
2283: l_orig_tax_status_code zx_lines.orig_tax_status_code%TYPE;
2284: l_tax_rate_code zx_lines.tax_rate_code%TYPE;
2277: l_tax_applicable BOOLEAN;
2278:
2279: /* Commented out as part of restructuring for STCC (bug 4959835)
2280: l_last_manual_entry zx_lines.last_manual_entry%TYPE;
2281: l_tax_status_code zx_lines.tax_status_code%TYPE;
2282: l_orig_tax_status_id zx_lines.orig_tax_status_id%TYPE;
2283: l_orig_tax_status_code zx_lines.orig_tax_status_code%TYPE;
2284: l_tax_rate_code zx_lines.tax_rate_code%TYPE;
2285: l_tax_rate zx_lines.tax_rate%TYPE;
2278:
2279: /* Commented out as part of restructuring for STCC (bug 4959835)
2280: l_last_manual_entry zx_lines.last_manual_entry%TYPE;
2281: l_tax_status_code zx_lines.tax_status_code%TYPE;
2282: l_orig_tax_status_id zx_lines.orig_tax_status_id%TYPE;
2283: l_orig_tax_status_code zx_lines.orig_tax_status_code%TYPE;
2284: l_tax_rate_code zx_lines.tax_rate_code%TYPE;
2285: l_tax_rate zx_lines.tax_rate%TYPE;
2286: l_orig_tax_rate_id zx_lines.orig_tax_rate_id%TYPE;
2279: /* Commented out as part of restructuring for STCC (bug 4959835)
2280: l_last_manual_entry zx_lines.last_manual_entry%TYPE;
2281: l_tax_status_code zx_lines.tax_status_code%TYPE;
2282: l_orig_tax_status_id zx_lines.orig_tax_status_id%TYPE;
2283: l_orig_tax_status_code zx_lines.orig_tax_status_code%TYPE;
2284: l_tax_rate_code zx_lines.tax_rate_code%TYPE;
2285: l_tax_rate zx_lines.tax_rate%TYPE;
2286: l_orig_tax_rate_id zx_lines.orig_tax_rate_id%TYPE;
2287: l_orig_tax_rate_code zx_lines.orig_tax_rate_code%TYPE;
2280: l_last_manual_entry zx_lines.last_manual_entry%TYPE;
2281: l_tax_status_code zx_lines.tax_status_code%TYPE;
2282: l_orig_tax_status_id zx_lines.orig_tax_status_id%TYPE;
2283: l_orig_tax_status_code zx_lines.orig_tax_status_code%TYPE;
2284: l_tax_rate_code zx_lines.tax_rate_code%TYPE;
2285: l_tax_rate zx_lines.tax_rate%TYPE;
2286: l_orig_tax_rate_id zx_lines.orig_tax_rate_id%TYPE;
2287: l_orig_tax_rate_code zx_lines.orig_tax_rate_code%TYPE;
2288: l_orig_tax_rate zx_lines.orig_tax_rate%TYPE;
2281: l_tax_status_code zx_lines.tax_status_code%TYPE;
2282: l_orig_tax_status_id zx_lines.orig_tax_status_id%TYPE;
2283: l_orig_tax_status_code zx_lines.orig_tax_status_code%TYPE;
2284: l_tax_rate_code zx_lines.tax_rate_code%TYPE;
2285: l_tax_rate zx_lines.tax_rate%TYPE;
2286: l_orig_tax_rate_id zx_lines.orig_tax_rate_id%TYPE;
2287: l_orig_tax_rate_code zx_lines.orig_tax_rate_code%TYPE;
2288: l_orig_tax_rate zx_lines.orig_tax_rate%TYPE;
2289: l_tax_amt zx_lines.tax_amt%TYPE;
2282: l_orig_tax_status_id zx_lines.orig_tax_status_id%TYPE;
2283: l_orig_tax_status_code zx_lines.orig_tax_status_code%TYPE;
2284: l_tax_rate_code zx_lines.tax_rate_code%TYPE;
2285: l_tax_rate zx_lines.tax_rate%TYPE;
2286: l_orig_tax_rate_id zx_lines.orig_tax_rate_id%TYPE;
2287: l_orig_tax_rate_code zx_lines.orig_tax_rate_code%TYPE;
2288: l_orig_tax_rate zx_lines.orig_tax_rate%TYPE;
2289: l_tax_amt zx_lines.tax_amt%TYPE;
2290: l_orig_tax_amt zx_lines.orig_tax_amt%TYPE;
2283: l_orig_tax_status_code zx_lines.orig_tax_status_code%TYPE;
2284: l_tax_rate_code zx_lines.tax_rate_code%TYPE;
2285: l_tax_rate zx_lines.tax_rate%TYPE;
2286: l_orig_tax_rate_id zx_lines.orig_tax_rate_id%TYPE;
2287: l_orig_tax_rate_code zx_lines.orig_tax_rate_code%TYPE;
2288: l_orig_tax_rate zx_lines.orig_tax_rate%TYPE;
2289: l_tax_amt zx_lines.tax_amt%TYPE;
2290: l_orig_tax_amt zx_lines.orig_tax_amt%TYPE;
2291: l_taxable_amt zx_lines.taxable_amt%TYPE;
2284: l_tax_rate_code zx_lines.tax_rate_code%TYPE;
2285: l_tax_rate zx_lines.tax_rate%TYPE;
2286: l_orig_tax_rate_id zx_lines.orig_tax_rate_id%TYPE;
2287: l_orig_tax_rate_code zx_lines.orig_tax_rate_code%TYPE;
2288: l_orig_tax_rate zx_lines.orig_tax_rate%TYPE;
2289: l_tax_amt zx_lines.tax_amt%TYPE;
2290: l_orig_tax_amt zx_lines.orig_tax_amt%TYPE;
2291: l_taxable_amt zx_lines.taxable_amt%TYPE;
2292: l_orig_taxable_amt zx_lines.orig_taxable_amt%TYPE;
2285: l_tax_rate zx_lines.tax_rate%TYPE;
2286: l_orig_tax_rate_id zx_lines.orig_tax_rate_id%TYPE;
2287: l_orig_tax_rate_code zx_lines.orig_tax_rate_code%TYPE;
2288: l_orig_tax_rate zx_lines.orig_tax_rate%TYPE;
2289: l_tax_amt zx_lines.tax_amt%TYPE;
2290: l_orig_tax_amt zx_lines.orig_tax_amt%TYPE;
2291: l_taxable_amt zx_lines.taxable_amt%TYPE;
2292: l_orig_taxable_amt zx_lines.orig_taxable_amt%TYPE;
2293: l_line_amt zx_lines.line_amt%TYPE;
2286: l_orig_tax_rate_id zx_lines.orig_tax_rate_id%TYPE;
2287: l_orig_tax_rate_code zx_lines.orig_tax_rate_code%TYPE;
2288: l_orig_tax_rate zx_lines.orig_tax_rate%TYPE;
2289: l_tax_amt zx_lines.tax_amt%TYPE;
2290: l_orig_tax_amt zx_lines.orig_tax_amt%TYPE;
2291: l_taxable_amt zx_lines.taxable_amt%TYPE;
2292: l_orig_taxable_amt zx_lines.orig_taxable_amt%TYPE;
2293: l_line_amt zx_lines.line_amt%TYPE;
2294: l_current_line_amt zx_lines.line_amt%TYPE;
2287: l_orig_tax_rate_code zx_lines.orig_tax_rate_code%TYPE;
2288: l_orig_tax_rate zx_lines.orig_tax_rate%TYPE;
2289: l_tax_amt zx_lines.tax_amt%TYPE;
2290: l_orig_tax_amt zx_lines.orig_tax_amt%TYPE;
2291: l_taxable_amt zx_lines.taxable_amt%TYPE;
2292: l_orig_taxable_amt zx_lines.orig_taxable_amt%TYPE;
2293: l_line_amt zx_lines.line_amt%TYPE;
2294: l_current_line_amt zx_lines.line_amt%TYPE;
2295: */
2288: l_orig_tax_rate zx_lines.orig_tax_rate%TYPE;
2289: l_tax_amt zx_lines.tax_amt%TYPE;
2290: l_orig_tax_amt zx_lines.orig_tax_amt%TYPE;
2291: l_taxable_amt zx_lines.taxable_amt%TYPE;
2292: l_orig_taxable_amt zx_lines.orig_taxable_amt%TYPE;
2293: l_line_amt zx_lines.line_amt%TYPE;
2294: l_current_line_amt zx_lines.line_amt%TYPE;
2295: */
2296:
2289: l_tax_amt zx_lines.tax_amt%TYPE;
2290: l_orig_tax_amt zx_lines.orig_tax_amt%TYPE;
2291: l_taxable_amt zx_lines.taxable_amt%TYPE;
2292: l_orig_taxable_amt zx_lines.orig_taxable_amt%TYPE;
2293: l_line_amt zx_lines.line_amt%TYPE;
2294: l_current_line_amt zx_lines.line_amt%TYPE;
2295: */
2296:
2297: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
2290: l_orig_tax_amt zx_lines.orig_tax_amt%TYPE;
2291: l_taxable_amt zx_lines.taxable_amt%TYPE;
2292: l_orig_taxable_amt zx_lines.orig_taxable_amt%TYPE;
2293: l_line_amt zx_lines.line_amt%TYPE;
2294: l_current_line_amt zx_lines.line_amt%TYPE;
2295: */
2296:
2297: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
2298: l_tax_amt_included_flag zx_lines.tax_amt_included_flag%TYPE;
2293: l_line_amt zx_lines.line_amt%TYPE;
2294: l_current_line_amt zx_lines.line_amt%TYPE;
2295: */
2296:
2297: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
2298: l_tax_amt_included_flag zx_lines.tax_amt_included_flag%TYPE;
2299: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
2300: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
2301: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2294: l_current_line_amt zx_lines.line_amt%TYPE;
2295: */
2296:
2297: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
2298: l_tax_amt_included_flag zx_lines.tax_amt_included_flag%TYPE;
2299: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
2300: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
2301: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2302: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
2295: */
2296:
2297: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
2298: l_tax_amt_included_flag zx_lines.tax_amt_included_flag%TYPE;
2299: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
2300: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
2301: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2302: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
2303:
2296:
2297: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
2298: l_tax_amt_included_flag zx_lines.tax_amt_included_flag%TYPE;
2299: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
2300: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
2301: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
2302: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
2303:
2304: l_error_buffer VARCHAR2(200);
2304: l_error_buffer VARCHAR2(200);
2305: l_tax_tbl_subscript NUMBER;
2306:
2307: l_trx_line_id NUMBER;
2308: l_trx_level_type zx_lines.trx_level_type%TYPE;
2309: l_begin_index BINARY_INTEGER;
2310: l_end_index BINARY_INTEGER;
2311:
2312: /* Bug4959835: Moved to handle_update_scenarios
2309: l_begin_index BINARY_INTEGER;
2310: l_end_index BINARY_INTEGER;
2311:
2312: /* Bug4959835: Moved to handle_update_scenarios
2313: l_unrounded_taxable_amt zx_lines.unrounded_taxable_amt%TYPE;
2314: l_unrounded_tax_amt zx_lines.unrounded_tax_amt%TYPE;
2315: l_cal_tax_amt zx_lines.cal_tax_amt%TYPE;
2316: */
2317:
2310: l_end_index BINARY_INTEGER;
2311:
2312: /* Bug4959835: Moved to handle_update_scenarios
2313: l_unrounded_taxable_amt zx_lines.unrounded_taxable_amt%TYPE;
2314: l_unrounded_tax_amt zx_lines.unrounded_tax_amt%TYPE;
2315: l_cal_tax_amt zx_lines.cal_tax_amt%TYPE;
2316: */
2317:
2318: l_jur_index NUMBER;
2311:
2312: /* Bug4959835: Moved to handle_update_scenarios
2313: l_unrounded_taxable_amt zx_lines.unrounded_taxable_amt%TYPE;
2314: l_unrounded_tax_amt zx_lines.unrounded_tax_amt%TYPE;
2315: l_cal_tax_amt zx_lines.cal_tax_amt%TYPE;
2316: */
2317:
2318: l_jur_index NUMBER;
2319:
2389: AND zxt.offset_tax_flag = 'N'
2390: ORDER BY compounding_precedence;
2391:
2392: /* Bug 4959835: Moved to procedure handle_update_scenarios
2393: CURSOR get_key_columns_cur(p_tax zx_lines.tax%TYPE) IS
2394: SELECT tax_line_id,
2395: last_manual_entry,
2396: tax_status_code,
2397: orig_tax_status_id,
2417: unrounded_taxable_amt,
2418: unrounded_tax_amt,
2419: cal_tax_amt,
2420: associated_child_frozen_flag
2421: FROM zx_lines
2422: WHERE application_id = p_event_class_rec.application_id
2423: AND entity_code = p_event_class_rec.entity_code
2424: AND event_class_code = p_event_class_rec.event_class_code
2425: AND trx_id = p_event_class_rec.trx_id
2431: AND tax = p_tax
2432: AND mrc_tax_line_flag = 'N';
2433:
2434: CURSOR enforce_rate_code_from_ref_doc(
2435: c_tax zx_lines.tax%TYPE,
2436: c_tax_regime_code zx_lines.tax_regime_code%TYPE) IS
2437: SELECT tax_status_code,
2438: tax_rate_code,
2439: line_amt,
2432: AND mrc_tax_line_flag = 'N';
2433:
2434: CURSOR enforce_rate_code_from_ref_doc(
2435: c_tax zx_lines.tax%TYPE,
2436: c_tax_regime_code zx_lines.tax_regime_code%TYPE) IS
2437: SELECT tax_status_code,
2438: tax_rate_code,
2439: line_amt,
2440: tax_amt,
2438: tax_rate_code,
2439: line_amt,
2440: tax_amt,
2441: taxable_amt
2442: FROM zx_lines
2443: WHERE application_id =
2444: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(p_trx_line_index)
2445: AND event_class_code =
2446: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(p_trx_line_index)
2989:
2990: ELSE -- 'CREATE'
2991: /*
2992: * will be populated by pop_tax_line_for_trx_line
2993: * SELECT zx_lines_s.NEXTVAL
2994: * INTO ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
2995: * l_new_row_num).tax_line_id
2996: * FROM dual;
2997: */
3030: l_place_of_supply_type_code;
3031:
3032: -- if orig_tax_jurisdiction_code(id) is not NULL (for UPDATE),
3033: -- populate tax_jurisdiction_code and tax_jurisdiction_id fetched
3034: -- from zx_lines. Otherwise, populate new tax_jurisdiction_code
3035: -- and tax_jurisdiction_id from most inner jurisdiction info
3036: --
3037: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3038: l_new_row_num).orig_tax_jurisdiction_code IS NOT NULL
3198: END IF;
3199:
3200: -- If orig_tax_amt_included_flag/orig_self_assessed_flag is not NULL
3201: -- (for UPDATE), populate tax_amt_included_flag/self_assessed_flag
3202: -- fetched from zx_lines. Otherwise, keep tax_amt_included_flag/
3203: -- self_assessed_flag returned from get_tax_registration
3204: --
3205: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3206: l_new_row_num).orig_tax_amt_included_flag IS NOT NULL THEN
3402: END IF; -- p_event_class_rec.enforce_tax_from_ref_doc_flag = 'Y'
3403:
3404: -- copy transaction info to new tax lines
3405: --
3406: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines (p_trx_line_index,
3407: x_begin_index,
3408: x_end_index,
3409: x_return_status,
3410: l_error_buffer );
3413: IF (g_level_statement >= g_current_runtime_level ) THEN
3414: FND_LOG.STRING(g_level_statement,
3415: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3416: 'Incorrect RETURN_STATUS after calling '||
3417: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
3418: FND_LOG.STRING(g_level_statement,
3419: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_applicable_taxes',
3420: 'RETURN_STATUS = ' || x_return_status);
3421: FND_LOG.STRING(g_level_statement,
3478: x_end_index IN OUT NOCOPY BINARY_INTEGER,
3479: x_return_status OUT NOCOPY VARCHAR2) IS
3480:
3481: CURSOR get_tax_lines IS
3482: SELECT * FROM zx_lines
3483: WHERE application_id =
3484: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_index)
3485: AND entity_code =
3486: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_index)
3557: --
3558: /*
3559: * will be populated by pop_tax_line_for_trx_line
3560: *
3561: * SELECT zx_lines_s.NEXTVAL
3562: * INTO ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3563: * l_new_row_num).tax_line_id from dual;
3564: */
3565: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
3957: END IF;
3958:
3959: -- copy transaction info to new tax lines for new tax_lines created here
3960: --
3961: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines(
3962: p_trx_line_index ,
3963: l_begin_index,
3964: x_end_index,
3965: x_return_status,
3969: IF (g_level_statement >= g_current_runtime_level ) THEN
3970: FND_LOG.STRING(g_level_statement,
3971: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3972: 'Incorrect return_status after calling ' ||
3973: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
3974: FND_LOG.STRING(g_level_statement,
3975: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_applied',
3976: 'RETURN_STATUS = ' || x_return_status);
3977: FND_LOG.STRING(g_level_statement,
4030: x_end_index IN OUT NOCOPY BINARY_INTEGER,
4031: x_return_status OUT NOCOPY VARCHAR2) IS
4032:
4033: CURSOR get_tax_lines IS
4034: SELECT * FROM zx_lines
4035: WHERE application_id =
4036: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_index)
4037: AND entity_code =
4038: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_index)
4062: -- Bug 7597449 Added Tax apportionment line number to pick the correct tax line id for upgraded invoices which have same regime-tax information.
4063: CURSOR get_key_columns_cur
4064: (c_tax_regime_code zx_regimes_b.tax_regime_code%TYPE,
4065: c_tax zx_taxes_b.tax%TYPE,
4066: c_apportionment_line_number zx_lines.tax_apportionment_line_number%type) IS
4067: SELECT * FROM zx_lines
4068: WHERE application_id = p_event_class_rec.application_id
4069: AND entity_code = p_event_class_rec.entity_code
4070: AND event_class_code = p_event_class_rec.event_class_code
4063: CURSOR get_key_columns_cur
4064: (c_tax_regime_code zx_regimes_b.tax_regime_code%TYPE,
4065: c_tax zx_taxes_b.tax%TYPE,
4066: c_apportionment_line_number zx_lines.tax_apportionment_line_number%type) IS
4067: SELECT * FROM zx_lines
4068: WHERE application_id = p_event_class_rec.application_id
4069: AND entity_code = p_event_class_rec.entity_code
4070: AND event_class_code = p_event_class_rec.event_class_code
4071: AND trx_id = p_event_class_rec.trx_id
4077: AND tax = c_tax
4078: AND tax_apportionment_line_number = c_apportionment_line_number
4079: AND mrc_tax_line_flag = 'N';
4080:
4081: l_tax_line_rec zx_lines%ROWTYPE;
4082: l_new_row_num NUMBER;
4083: l_begin_index BINARY_INTEGER;
4084: l_error_buffer VARCHAR2(200);
4085:
4131: --
4132: /*
4133: * will be populated by pop_tax_line_for_trx_line
4134: *
4135: * SELECT zx_lines_s.NEXTVAL
4136: * INTO ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
4137: * l_new_row_num).tax_line_id from dual;
4138: */
4139:
4605: END IF;
4606:
4607: -- copy transaction info to new tax lines for new tax_lines created here
4608: --
4609: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines(
4610: p_trx_line_index ,
4611: l_begin_index,
4612: x_end_index,
4613: x_return_status ,
4617: IF (g_level_statement >= g_current_runtime_level ) THEN
4618: FND_LOG.STRING(g_level_statement,
4619: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust',
4620: 'Incorrect return_status after calling ' ||
4621: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
4622: FND_LOG.STRING(g_level_statement,
4623: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_det_tax_lines_from_adjust',
4624: 'RETURN_STATUS = ' || x_return_status);
4625: FND_LOG.STRING(g_level_statement,
5234: p_structure_index IN BINARY_INTEGER,
5235: p_event_class_rec IN zx_api_pub.event_class_rec_type,
5236: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
5237: p_tax IN zx_taxes_b.tax%TYPE,
5238: p_tax_determine_date IN zx_lines.tax_determine_date%TYPE,
5239: p_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
5240: p_reg_party_type IN zx_taxes_b.def_registr_party_type_code%TYPE,
5241: x_registration_rec OUT NOCOPY zx_tcm_control_pkg.zx_registration_info_rec,
5242: x_return_status OUT NOCOPY VARCHAR2
5254: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5255: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
5256: l_account_type_code VARCHAR2(30);
5257: l_first_party_flag BOOLEAN;
5258: l_hq_estb_ptp_id zx_lines.hq_estb_party_tax_prof_id%TYPE;
5259: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
5260:
5261: -- Bug#5395227
5262: l_tax_rec ZX_TDS_UTILITIES_PKG.ZX_TAX_INFO_CACHE_REC;
5923: p_tax_line_index IN BINARY_INTEGER,
5924: x_return_status OUT NOCOPY VARCHAR2,
5925: x_error_buffer OUT NOCOPY VARCHAR2)
5926: IS
5927: l_hq_estb_ptp_id zx_lines.hq_estb_party_tax_prof_id%TYPE;
5928: i BINARY_INTEGER;
5929: l_tax_id BINARY_INTEGER;
5930: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
5931: l_ret_record_level VARCHAR2(30);
6181:
6182: l_tax_id NUMBER;
6183: l_error_buffer VARCHAR2(200);
6184: l_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE;
6185: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
6186:
6187: BEGIN
6188:
6189: x_return_status := FND_API.G_RET_STS_SUCCESS;
6967: END IF;
6968:
6969: -- copy transaction info to new tax lines
6970: --
6971: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines(
6972: p_trx_line_index,
6973: l_begin_index_from_acct,
6974: l_end_index_from_acct,
6975: x_return_status,
6979: IF (g_level_statement >= g_current_runtime_level ) THEN
6980: FND_LOG.STRING(g_level_statement,
6981: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6982: 'Incorrect return_status after calling ' ||
6983: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
6984: FND_LOG.STRING(g_level_statement,
6985: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_tax_from_account',
6986: 'RETURN_STATUS = ' || x_return_status);
6987: FND_LOG.STRING(g_level_statement,
7033: x_return_status OUT NOCOPY VARCHAR2) IS
7034:
7035: CURSOR get_taxes_f_intercomp_trx_csr IS
7036: SELECT zxl.*
7037: FROM zx_lines zxl, zx_evnt_cls_mappings map
7038: WHERE map.application_id =
7039: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.application_id(p_trx_line_index)
7040: AND map.entity_code =
7041: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.entity_code(p_trx_line_index)
7156:
7157: l_is_valid := TRUE;
7158: l_rownum := l_rownum + 1;
7159:
7160: -- populate tax info fetched from zx_lines to g_detail_tax_lines_tbl
7161: --
7162: ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(l_rownum) := tax_line_rec;
7163:
7164: -- set tax_line_id to NULL. It will be reset in pop_tax_line_for_trx_line
7850: IF (x_begin_index IS NOT NULL) THEN
7851: x_end_index := ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl.LAST;
7852: END IF;
7853:
7854: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines (p_trx_line_index,
7855: x_begin_index,
7856: x_end_index,
7857: x_return_status,
7858: l_error_buffer );
7861: IF (g_level_statement >= g_current_runtime_level ) THEN
7862: FND_LOG.STRING(g_level_statement,
7863: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7864: 'Incorrect RETURN_STATUS after calling '||
7865: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
7866: FND_LOG.STRING(g_level_statement,
7867: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_taxes_for_intercomp_trx',
7868: 'RETURN_STATUS = ' || x_return_status);
7869: FND_LOG.STRING(g_level_statement,
7915: x_end_index IN OUT NOCOPY BINARY_INTEGER,
7916: x_return_status OUT NOCOPY VARCHAR2) IS
7917:
7918: CURSOR get_unique_constraint_csr(
7919: c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE,
7920: c_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE)
7921: IS
7922: SELECT cg.constraint_id
7923: FROM zx_condition_groups_b cg,
7916: x_return_status OUT NOCOPY VARCHAR2) IS
7917:
7918: CURSOR get_unique_constraint_csr(
7919: c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE,
7920: c_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE)
7921: IS
7922: SELECT cg.constraint_id
7923: FROM zx_condition_groups_b cg,
7924: ar_tax_conditions_all tc
7929: AND tc.org_id = c_internal_organization_id;
7930:
7931:
7932: -- CURSOR get_constraints_csr
7933: -- (c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE)
7934: -- IS
7935: -- SELECT cg.CONSTRAINT_ID
7936: -- FROM zx_condition_groups_b cg
7937: -- WHERE cg.CONDITION_GROUP_CODE like c_tax_classification_code||'~'||'%'
7939: -- AND cg.constraint_id IS NOT NULL;
7940: --
7941: --
7942: -- CURSOR get_unique_constraint_csr(
7943: -- c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE,
7944: -- c_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE)
7945: -- IS
7946: -- SELECT cg.constraint_id
7947: -- FROM zx_condition_groups_b cg,
7940: --
7941: --
7942: -- CURSOR get_unique_constraint_csr(
7943: -- c_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE,
7944: -- c_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE)
7945: -- IS
7946: -- SELECT cg.constraint_id
7947: -- FROM zx_condition_groups_b cg,
7948: -- ar_tax_conditions tc
8109: -- Local variables
8110: --
8111: l_constraint_id zx_condition_groups_b.constraint_id%TYPE;
8112: l_condition_group_code zx_condition_groups_b.condition_group_code%TYPE;
8113: l_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE;
8114: l_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE;
8115: l_cec_result BOOLEAN;
8116: l_action_rec_tbl ZX_TDS_PROCESS_CEC_PVT.action_rec_tbl_type;
8117: l_tax_regime_code_tbl tax_regime_code_tbl;
8110: --
8111: l_constraint_id zx_condition_groups_b.constraint_id%TYPE;
8112: l_condition_group_code zx_condition_groups_b.condition_group_code%TYPE;
8113: l_tax_classification_code zx_lines_det_factors.input_tax_classification_code%TYPE;
8114: l_internal_organization_id zx_lines_det_factors.internal_organization_id%TYPE;
8115: l_cec_result BOOLEAN;
8116: l_action_rec_tbl ZX_TDS_PROCESS_CEC_PVT.action_rec_tbl_type;
8117: l_tax_regime_code_tbl tax_regime_code_tbl;
8118: l_tax_tbl tax_tbl;
8143: l_tax_index NUMBER;
8144: l_trx_line_id NUMBER;
8145: l_trx_level_type VARCHAR2(30);
8146:
8147: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
8148: l_tax_amt_included_flag zx_lines.tax_amt_included_flag%TYPE;
8149: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
8150: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
8151: l_jur_index NUMBER;
8144: l_trx_line_id NUMBER;
8145: l_trx_level_type VARCHAR2(30);
8146:
8147: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
8148: l_tax_amt_included_flag zx_lines.tax_amt_included_flag%TYPE;
8149: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
8150: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
8151: l_jur_index NUMBER;
8152: l_jurisdiction_rec_tbl ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_tbl_type;
8145: l_trx_level_type VARCHAR2(30);
8146:
8147: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
8148: l_tax_amt_included_flag zx_lines.tax_amt_included_flag%TYPE;
8149: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
8150: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
8151: l_jur_index NUMBER;
8152: l_jurisdiction_rec_tbl ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_tbl_type;
8153: l_index NUMBER;
8146:
8147: l_self_assessed_flag zx_lines.self_assessed_flag%TYPE;
8148: l_tax_amt_included_flag zx_lines.tax_amt_included_flag%TYPE;
8149: l_tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE;
8150: l_tax_jurisdiction_code zx_lines.tax_jurisdiction_code%TYPE;
8151: l_jur_index NUMBER;
8152: l_jurisdiction_rec_tbl ZX_TCM_GEO_JUR_PKG.tax_jurisdiction_rec_tbl_type;
8153: l_index NUMBER;
8154: l_tbl_index BINARY_INTEGER;
8155: l_rate_exists_same_prod_family BOOLEAN;
8156: l_tax_applicable BOOLEAN;
8157: l_applicability_result_id NUMBER;
8158: l_applicability_result zx_process_results.alphanumeric_result%TYPE;
8159: l_exception_rate zx_lines.exception_rate%TYPE;
8160:
8161: BEGIN
8162:
8163: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
9078: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.trx_line_id(p_trx_line_index);
9079:
9080: -- if orig_tax_jurisdiction_code(id) is not NULL (for UPDATE),
9081: -- populate tax_jurisdiction_code and tax_jurisdiction_id fetched
9082: -- from zx_lines. Otherwise, populate new tax_jurisdiction_code
9083: -- and tax_jurisdiction_id from most inner jurisdiction info
9084: --
9085: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
9086: l_rownum).orig_tax_jurisdiction_code IS NOT NULL
9190: END IF;
9191:
9192: -- If orig_tax_amt_included_flag/orig_self_assessed_flag is not NULL
9193: -- (for UPDATE), populate tax_amt_included_flag/self_assessed_flag
9194: -- fetched from zx_lines. Otherwise, keep tax_amt_included_flag/
9195: -- self_assessed_flag returned from get_tax_registration
9196: --
9197: IF ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
9198: l_rownum).orig_tax_amt_included_flag IS NOT NULL THEN
9332: END IF;
9333:
9334: -- copy transaction info to new tax lines
9335:
9336: ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines (p_trx_line_index,
9337: x_begin_index,
9338: x_end_index,
9339: x_return_status,
9340: l_error_buffer );
9343: IF (g_level_statement >= g_current_runtime_level ) THEN
9344: FND_LOG.STRING(g_level_statement,
9345: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
9346: 'Incorrect RETURN_STATUS after calling '||
9347: 'ZX_TDS_TAX_LINES_POPU_PKG.cp_tsrm_val_to_zx_lines');
9348: FND_LOG.STRING(g_level_statement,
9349: 'ZX.PLSQL.ZX_TDS_APPLICABILITY_DETM_PKG.get_process_results',
9350: 'RETURN_STATUS = ' || x_return_status);
9351: FND_LOG.STRING(g_level_statement,
9445: p_tax IN zx_taxes_b.tax%TYPE,
9446: p_tax_date IN DATE,
9447: p_tax_determine_date IN DATE,
9448: p_tax_point_date IN DATE,
9449: x_self_assessed_flag OUT NOCOPY zx_lines.self_assessed_flag%TYPE,
9450: x_tax_amt_included_flag OUT NOCOPY zx_lines.tax_amt_included_flag%TYPE,
9451: x_tax_jurisdiction_id OUT NOCOPY zx_lines.tax_jurisdiction_id%TYPE,
9452: x_tax_jurisdiction_code OUT NOCOPY zx_lines.tax_jurisdiction_code%TYPE,
9453: x_return_status OUT NOCOPY VARCHAR2) IS
9446: p_tax_date IN DATE,
9447: p_tax_determine_date IN DATE,
9448: p_tax_point_date IN DATE,
9449: x_self_assessed_flag OUT NOCOPY zx_lines.self_assessed_flag%TYPE,
9450: x_tax_amt_included_flag OUT NOCOPY zx_lines.tax_amt_included_flag%TYPE,
9451: x_tax_jurisdiction_id OUT NOCOPY zx_lines.tax_jurisdiction_id%TYPE,
9452: x_tax_jurisdiction_code OUT NOCOPY zx_lines.tax_jurisdiction_code%TYPE,
9453: x_return_status OUT NOCOPY VARCHAR2) IS
9454:
9447: p_tax_determine_date IN DATE,
9448: p_tax_point_date IN DATE,
9449: x_self_assessed_flag OUT NOCOPY zx_lines.self_assessed_flag%TYPE,
9450: x_tax_amt_included_flag OUT NOCOPY zx_lines.tax_amt_included_flag%TYPE,
9451: x_tax_jurisdiction_id OUT NOCOPY zx_lines.tax_jurisdiction_id%TYPE,
9452: x_tax_jurisdiction_code OUT NOCOPY zx_lines.tax_jurisdiction_code%TYPE,
9453: x_return_status OUT NOCOPY VARCHAR2) IS
9454:
9455: -- Local variables
9448: p_tax_point_date IN DATE,
9449: x_self_assessed_flag OUT NOCOPY zx_lines.self_assessed_flag%TYPE,
9450: x_tax_amt_included_flag OUT NOCOPY zx_lines.tax_amt_included_flag%TYPE,
9451: x_tax_jurisdiction_id OUT NOCOPY zx_lines.tax_jurisdiction_id%TYPE,
9452: x_tax_jurisdiction_code OUT NOCOPY zx_lines.tax_jurisdiction_code%TYPE,
9453: x_return_status OUT NOCOPY VARCHAR2) IS
9454:
9455: -- Local variables
9456: l_current_line_amt zx_lines.line_amt%TYPE;
9452: x_tax_jurisdiction_code OUT NOCOPY zx_lines.tax_jurisdiction_code%TYPE,
9453: x_return_status OUT NOCOPY VARCHAR2) IS
9454:
9455: -- Local variables
9456: l_current_line_amt zx_lines.line_amt%TYPE;
9457: l_tax_line_rec zx_lines%ROWTYPE;
9458:
9459: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
9460: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
9453: x_return_status OUT NOCOPY VARCHAR2) IS
9454:
9455: -- Local variables
9456: l_current_line_amt zx_lines.line_amt%TYPE;
9457: l_tax_line_rec zx_lines%ROWTYPE;
9458:
9459: l_tax_status_rec ZX_TDS_UTILITIES_PKG.zx_status_info_rec;
9460: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
9461: l_error_buffer VARCHAR2(200);
9463: l_tax_class zx_rates_b.tax_class%TYPE;
9464:
9465:
9466: CURSOR get_key_columns_cur IS
9467: SELECT * FROM zx_lines
9468: WHERE application_id = p_event_class_rec.application_id
9469: AND entity_code = p_event_class_rec.entity_code
9470: AND event_class_code = p_event_class_rec.event_class_code
9471: AND trx_id = p_event_class_rec.trx_id
9984:
9985: ELSIF get_key_columns_cur%NOTFOUND THEN
9986: /*
9987: * will be populated by pop_tax_line_for_trx_line
9988: * SELECT zx_lines_s.NEXTVAL
9989: * INTO ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(
9990: * p_row_num).tax_line_id
9991: * FROM dual;
9992: */
10054: l_error_buffer VARCHAR2(200);
10055:
10056: -- Cursor definitions
10057: CURSOR enforce_rate_code_from_ref_doc(
10058: c_tax zx_lines.tax%TYPE,
10059: c_tax_regime_code zx_lines.tax_regime_code%TYPE) IS
10060: SELECT tax_status_code,
10061: tax_rate_code,
10062: line_amt,
10055:
10056: -- Cursor definitions
10057: CURSOR enforce_rate_code_from_ref_doc(
10058: c_tax zx_lines.tax%TYPE,
10059: c_tax_regime_code zx_lines.tax_regime_code%TYPE) IS
10060: SELECT tax_status_code,
10061: tax_rate_code,
10062: line_amt,
10063: tax_amt,
10064: taxable_amt,
10065: -- nipatel bug 6648042
10066: tax_apportionment_line_number
10067: -- nipatel bug 6648042
10068: FROM zx_lines
10069: WHERE application_id =
10070: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_application_id(p_trx_line_index)
10071: AND event_class_code =
10072: ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.ref_doc_event_class_code(p_trx_line_index)