APPS.ZX_TDS_REVERSE_DOCUMENT_PKG dependencies on ZX_LINES_SUMMARY

Line 32: zx_lines_summary_s.NEXTVAL,

28: IS
29:
30: CURSOR get_sum_tax_line_id_tbl_csr IS
31: SELECT summary_tax_line_id,
32: zx_lines_summary_s.NEXTVAL,
33: reversing_appln_id,
34: reversing_entity_code,
35: reversing_evnt_cls_code,
36: reversing_trx_id,

Line 50: zx_lines_summary summ

46: lngt.reversing_trx_id,
47: hdrgt.trx_number
48: FROM zx_rev_trx_headers_gt hdrgt,
49: zx_reverse_trx_lines_gt lngt,
50: zx_lines_summary summ
51: WHERE hdrgt.reversing_appln_id = p_event_class_rec.application_id
52: AND hdrgt.reversing_entity_code = p_event_class_rec.entity_code
53: AND hdrgt.reversing_evnt_cls_code = p_event_class_rec.event_class_code
54: AND hdrgt.reversing_trx_id = p_event_class_rec.trx_id

Line 150: -- summary tax lines with sequence zx_lines_summary_s

146:
147: -- reverse summary tax lines
148: -- 1. get all summary_tax_line_ids that need to be reversed,
149: -- meanwhile, create summary_tax_line_ids for the reversed
150: -- summary tax lines with sequence zx_lines_summary_s
151: -- 2. reverse summary tax lines in zx_lines_summary
152: --
153:
154: IF p_event_class_rec.summarization_flag = 'Y' THEN

Line 151: -- 2. reverse summary tax lines in zx_lines_summary

147: -- reverse summary tax lines
148: -- 1. get all summary_tax_line_ids that need to be reversed,
149: -- meanwhile, create summary_tax_line_ids for the reversed
150: -- summary tax lines with sequence zx_lines_summary_s
151: -- 2. reverse summary tax lines in zx_lines_summary
152: --
153:
154: IF p_event_class_rec.summarization_flag = 'Y' THEN
155:

Line 169: -- create reversed summary tax lines in zx_lines_summary

165: l_trx_number_tb;
166:
167: CLOSE get_sum_tax_line_id_tbl_csr;
168:
169: -- create reversed summary tax lines in zx_lines_summary
170: --
171: FORALL i IN NVL(l_reversed_sum_tax_line_id_tb.FIRST, 0) ..
172: NVL(l_reversed_sum_tax_line_id_tb.LAST, -1)
173: INSERT INTO zx_lines_summary

Line 173: INSERT INTO zx_lines_summary

169: -- create reversed summary tax lines in zx_lines_summary
170: --
171: FORALL i IN NVL(l_reversed_sum_tax_line_id_tb.FIRST, 0) ..
172: NVL(l_reversed_sum_tax_line_id_tb.LAST, -1)
173: INSERT INTO zx_lines_summary
174: ( summary_tax_line_id,
175: internal_organization_id,
176: application_id,
177: entity_code,

Line 370: FROM zx_lines_summary

366: exception_rate,
367: mrc_tax_line_flag,
368: content_owner_id,
369: 1
370: FROM zx_lines_summary
371: WHERE summary_tax_line_id = l_reversed_sum_tax_line_id_tb(i);
372:
373: -- initialize the following data structures because they will be reused in
374: -- reversing detail tax lines