DBA Data[Home] [Help]

APPS.ZX_TRD_INTERNAL_SERVICES_PVT dependencies on ZX_LINES

Line 1223: -- prd_total_tax_amt_tax_curr, prd_total_tax_amt_funcl_curr from zx_lines

1219: p_rec_nrec_dist_tbl(i).attribute_category := p_detail_tax_line_tbl(p_tax_line_index).attribute_category;
1220: -- End Bug 7117340 -- DFF ER
1221:
1222: -- IF applied_amt_handling_flag = 'R', copy prd_total_tax_amt,
1223: -- prd_total_tax_amt_tax_curr, prd_total_tax_amt_funcl_curr from zx_lines
1224: --
1225: IF p_rec_nrec_dist_tbl(p_rnd_begin_index).applied_from_tax_dist_id IS NOT NULL THEN
1226:
1227: IF NOT ZX_TDS_UTILITIES_PKG.g_tax_rec_tbl.exists(p_detail_tax_line_tbl(

Line 3391: -- check rounding difference between tax line in zx_lines and

3387: END LOOP;
3388: END IF;
3389: END IF; -- l_nrec_tax_rnd_diff <> 0
3390:
3391: -- check rounding difference between tax line in zx_lines and
3392: -- the tax distributions in zx_rec_nrec_tax_dist with the same
3393: -- tax_line_id.
3394: --
3395: IF p_tax_line_amt IS NOT NULL THEN

Line 4159: -- check rounding difference between tax line in zx_lines and

4155: END LOOP;
4156: END IF;
4157: END IF; -- l_nrec_tax_rnd_diff_tax_curr <> 0
4158:
4159: -- check rounding difference between tax line in zx_lines and
4160: -- the tax distributions in zx_rec_nrec_tax_dist with the same
4161: -- tax_line_id.
4162: --
4163: IF p_tax_line_amt_tax_curr IS NOT NULL THEN

Line 5251: FROM zx_lines zl

5247:
5248: UPDATE zx_rec_nrec_dist zd
5249: SET tax_apportionment_line_number =
5250: (SELECT tax_apportionment_line_number
5251: FROM zx_lines zl
5252: WHERE zl.tax_line_id = zd.tax_line_id)
5253: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_application_id(p_trx_line_dist_index)
5254: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_entity_code(p_trx_line_dist_index)
5255: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.applied_from_event_class_code(p_trx_line_dist_index)

Line 5478: FROM zx_lines zl

5474:
5475: UPDATE zx_rec_nrec_dist zd
5476: SET tax_apportionment_line_number =
5477: (SELECT tax_apportionment_line_number
5478: FROM zx_lines zl
5479: WHERE zl.tax_line_id = zd.tax_line_id)
5480: WHERE application_id = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_application_id(p_trx_line_dist_index)
5481: AND entity_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_entity_code(p_trx_line_dist_index)
5482: AND event_class_code = ZX_GLOBAL_STRUCTURES_PKG.trx_line_dist_tbl.adjusted_doc_event_class_code(p_trx_line_dist_index)

Line 6488: FROM zx_lines_det_factors line

6484: --
6485: UPDATE zx_rec_nrec_dist_gt gt
6486: SET ref_doc_unit_price =
6487: (SELECT unit_price
6488: FROM zx_lines_det_factors line
6489: WHERE line.application_id = gt.ref_doc_application_id
6490: AND line.entity_code = gt.ref_doc_entity_code
6491: AND line.event_class_code = gt.ref_doc_event_class_code
6492: AND line.trx_id = gt.ref_doc_trx_id

Line 6562: FROM zx_lines_det_factors line

6558: --
6559: UPDATE zx_rec_nrec_dist_gt gt
6560: SET ref_doc_unit_price =
6561: (SELECT unit_price
6562: FROM zx_lines_det_factors line
6563: WHERE line.application_id = gt.ref_doc_application_id
6564: AND line.entity_code = gt.ref_doc_entity_code
6565: AND line.event_class_code = gt.ref_doc_event_class_code
6566: AND line.trx_id = gt.ref_doc_trx_id

Line 6639: FROM zx_lines_det_factors line

6635:
6636: UPDATE zx_rec_nrec_dist_gt gt
6637: SET ref_doc_unit_price =
6638: (SELECT unit_price
6639: FROM zx_lines_det_factors line
6640: WHERE line.application_id = gt.ref_doc_application_id
6641: AND line.entity_code = gt.ref_doc_entity_code
6642: AND line.event_class_code = gt.ref_doc_event_class_code
6643: AND line.trx_id = gt.ref_doc_trx_id

Line 6698: c_trx_line_id zx_lines.trx_line_id%TYPE,

6694: p_return_status OUT NOCOPY VARCHAR2,
6695: p_error_buffer OUT NOCOPY VARCHAR2) IS
6696:
6697: CURSOR get_mrc_tax_line_info_csr(
6698: c_trx_line_id zx_lines.trx_line_id%TYPE,
6699: c_trx_level_type zx_lines.trx_level_type%TYPE,
6700: c_tax_line_number zx_lines.tax_line_number%TYPE) IS
6701: SELECT ledger_id,
6702: reporting_currency_code,

Line 6699: c_trx_level_type zx_lines.trx_level_type%TYPE,

6695: p_error_buffer OUT NOCOPY VARCHAR2) IS
6696:
6697: CURSOR get_mrc_tax_line_info_csr(
6698: c_trx_line_id zx_lines.trx_line_id%TYPE,
6699: c_trx_level_type zx_lines.trx_level_type%TYPE,
6700: c_tax_line_number zx_lines.tax_line_number%TYPE) IS
6701: SELECT ledger_id,
6702: reporting_currency_code,
6703: currency_conversion_rate,

Line 6700: c_tax_line_number zx_lines.tax_line_number%TYPE) IS

6696:
6697: CURSOR get_mrc_tax_line_info_csr(
6698: c_trx_line_id zx_lines.trx_line_id%TYPE,
6699: c_trx_level_type zx_lines.trx_level_type%TYPE,
6700: c_tax_line_number zx_lines.tax_line_number%TYPE) IS
6701: SELECT ledger_id,
6702: reporting_currency_code,
6703: currency_conversion_rate,
6704: currency_conversion_date,

Line 6711: FROM zx_lines

6707: precision,
6708: tax_line_id,
6709: summary_tax_line_id,
6710: tax_amt
6711: FROM zx_lines
6712: WHERE application_id = p_event_class_rec.application_id
6713: AND entity_code = p_event_class_rec.entity_code
6714: AND event_class_code = p_event_class_rec.event_class_code
6715: AND trx_id = p_event_class_rec.trx_id