[Home] [Help]
1134: p_rec_nrec_dist_tbl(i).mrc_tax_dist_flag :=
1135: p_detail_tax_line_tbl(p_tax_line_index).mrc_tax_line_flag;
1136:
1137: -- IF applied_amt_handling_flag = 'R', copy prd_total_tax_amt,
1138: -- prd_total_tax_amt_tax_curr, prd_total_tax_amt_funcl_curr from zx_lines
1139: --
1140: IF p_rec_nrec_dist_tbl(p_rnd_begin_index).applied_from_tax_dist_id IS NOT NULL THEN
1141:
1142: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.exists(p_detail_tax_line_tbl(
3083: END LOOP;
3084: END IF;
3085: END IF; -- l_nrec_tax_rnd_diff <> 0
3086:
3087: -- check rounding difference between tax line in zx_lines and
3088: -- the tax distributions in zx_rec_nrec_tax_dist with the same
3089: -- tax_line_id.
3090: --
3091: IF p_tax_line_amt IS NOT NULL THEN
3755: END LOOP;
3756: END IF;
3757: END IF; -- l_nrec_tax_rnd_diff_tax_curr <> 0
3758:
3759: -- check rounding difference between tax line in zx_lines and
3760: -- the tax distributions in zx_rec_nrec_tax_dist with the same
3761: -- tax_line_id.
3762: --
3763: IF p_tax_line_amt_tax_curr IS NOT NULL THEN
5738: --
5739: UPDATE zx_rec_nrec_dist_gt gt
5740: SET ref_doc_unit_price =
5741: (SELECT unit_price
5742: FROM zx_lines_det_factors line
5743: WHERE line.application_id = gt.ref_doc_application_id
5744: AND line.entity_code = gt.ref_doc_entity_code
5745: AND line.event_class_code = gt.ref_doc_event_class_code
5746: AND line.trx_id = gt.ref_doc_trx_id
5787: p_return_status OUT NOCOPY VARCHAR2,
5788: p_error_buffer OUT NOCOPY VARCHAR2) IS
5789:
5790: CURSOR get_mrc_tax_line_info_csr(
5791: c_trx_line_id zx_lines.trx_line_id%TYPE,
5792: c_trx_level_type zx_lines.trx_level_type%TYPE,
5793: c_tax_line_number zx_lines.tax_line_number%TYPE) IS
5794: SELECT ledger_id,
5795: reporting_currency_code,
5788: p_error_buffer OUT NOCOPY VARCHAR2) IS
5789:
5790: CURSOR get_mrc_tax_line_info_csr(
5791: c_trx_line_id zx_lines.trx_line_id%TYPE,
5792: c_trx_level_type zx_lines.trx_level_type%TYPE,
5793: c_tax_line_number zx_lines.tax_line_number%TYPE) IS
5794: SELECT ledger_id,
5795: reporting_currency_code,
5796: currency_conversion_rate,
5789:
5790: CURSOR get_mrc_tax_line_info_csr(
5791: c_trx_line_id zx_lines.trx_line_id%TYPE,
5792: c_trx_level_type zx_lines.trx_level_type%TYPE,
5793: c_tax_line_number zx_lines.tax_line_number%TYPE) IS
5794: SELECT ledger_id,
5795: reporting_currency_code,
5796: currency_conversion_rate,
5797: currency_conversion_date,
5800: precision,
5801: tax_line_id,
5802: summary_tax_line_id,
5803: tax_amt
5804: FROM zx_lines
5805: WHERE application_id = p_event_class_rec.application_id
5806: AND entity_code = p_event_class_rec.entity_code
5807: AND event_class_code = p_event_class_rec.event_class_code
5808: AND trx_id = p_event_class_rec.trx_id