APPS.ZX_TDS_REVERSE_DOCUMENT_PKG dependencies on ZX_LINES_S

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 78: zx_lines_s.NEXTVAL, -- from Sequence

74: CURSOR get_rev_tax_lines_info_csr IS
75: SELECT /*+ ORDERED INDEX(hdrgt ZX_REV_TRX_HEADERS_GT_U1)
76: INDEX(lngt ZX_REVERSE_TRX_LINES_GT_U1) */
77: zl.tax_line_id, -- from zx_lines
78: zx_lines_s.NEXTVAL, -- from Sequence
79: zl.offset_link_to_tax_line_id, -- from zx_lines
80: zl.summary_tax_line_id, -- from zx_lines
81: lngt.reversing_appln_id, -- from line gt
82: lngt.reversing_entity_code, -- from line gt

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

Line 386: -- 1. tax_line_id has new value form sequence zx_lines_s, stored in

382:
383: END IF; -- of summarization_flag = 'Y'
384:
385: -- For detail tax lines in reversed document:
386: -- 1. tax_line_id has new value form sequence zx_lines_s, stored in
387: -- l_reversed_tax_line_id_tb.
388: -- 2. All the amount related columns have values reversed from
389: -- the reversing document.
390: -- 3. Some columns(16) have new values from zx_rev_trx_headers_gt.