eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_TDS_REVERSE_DOCUMENT_PKG dependencies on ZX_LINES

Line 4: TYPE tax_line_id_tp IS TABLE OF zx_lines.tax_line_id%TYPE INDEX BY BINARY_INTEGER;

1: PACKAGE BODY ZX_TDS_REVERSE_DOCUMENT_PKG AS
2: /* $Header: zxdirevdocmtpkgb.pls 120.27.12010000.2 2008/11/18 05:59:25 srajapar ship $ */
3:
4: TYPE tax_line_id_tp IS TABLE OF zx_lines.tax_line_id%TYPE INDEX BY BINARY_INTEGER;
5:
6: FUNCTION get_tbl_index (
7: l_number_tbl IN tax_line_id_tp,
8: l_number_value IN zx_lines.tax_line_id%TYPE,

Line 8: l_number_value IN zx_lines.tax_line_id%TYPE,

4: TYPE tax_line_id_tp IS TABLE OF zx_lines.tax_line_id%TYPE INDEX BY BINARY_INTEGER;
5:
6: FUNCTION get_tbl_index (
7: l_number_tbl IN tax_line_id_tp,
8: l_number_value IN zx_lines.tax_line_id%TYPE,
9: x_return_status OUT NOCOPY VARCHAR2 ) RETURN NUMBER;
10:
11: g_current_runtime_level NUMBER;
12: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

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 65: FROM ZX_LINES line

61: AND summ.entity_code = lngt.reversed_entity_code
62: AND summ.event_class_code = lngt.reversed_evnt_cls_code
63: AND EXISTS
64: (SELECT /*+ no_unnest */ 1
65: FROM ZX_LINES line
66: WHERE line.summary_tax_line_id = summ.summary_tax_line_id
67: AND line.trx_id = summ.trx_id
68: AND line.application_id = summ.application_id
69: AND line.entity_code = summ.entity_code

Line 77: zl.tax_line_id, -- from zx_lines

73:
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

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 79: zl.offset_link_to_tax_line_id, -- from zx_lines

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
83: lngt.reversing_evnt_cls_code, -- from line gt

Line 80: zl.summary_tax_line_id, -- from zx_lines

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
83: lngt.reversing_evnt_cls_code, -- from line gt
84: lngt.reversing_trx_id, -- from line gt

Line 90: zx_lines zl

86: lngt.reversing_trx_level_type, -- from line gt
87: hdrgt.trx_number -- from header gt
88: FROM zx_rev_trx_headers_gt hdrgt,
89: zx_reverse_trx_lines_gt lngt,
90: zx_lines zl
91: WHERE hdrgt.reversing_appln_id = p_event_class_rec.application_id
92: AND hdrgt.reversing_entity_code = p_event_class_rec.entity_code
93: AND hdrgt.reversing_evnt_cls_code = p_event_class_rec.event_class_code
94: 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

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.

Line 462: -- create reversed detail tax lines in zx_lines

458: END IF;
459: END LOOP;
460: END IF;
461:
462: -- create reversed detail tax lines in zx_lines
463: --
464: FORALL i IN NVL(l_reversing_tax_line_id_tb.FIRST, 0) ..
465: NVL(l_reversing_tax_line_id_tb.LAST, -1)
466: INSERT INTO zx_lines (

Line 466: INSERT INTO zx_lines (

462: -- create reversed detail tax lines in zx_lines
463: --
464: FORALL i IN NVL(l_reversing_tax_line_id_tb.FIRST, 0) ..
465: NVL(l_reversing_tax_line_id_tb.LAST, -1)
466: INSERT INTO zx_lines (
467: tax_line_id,
468: internal_organization_id,
469: application_id,
470: entity_code,

Line 1059: FROM zx_lines zl

1055: zl.adjusted_doc_tax_line_id,
1056: 1,
1057: zl.tax_line_id, -- reversed_tax_line_id
1058: zl.account_source_tax_rate_id
1059: FROM zx_lines zl
1060: WHERE tax_line_id = l_reversed_tax_line_id_tb(i);
1061:
1062: IF (g_level_procedure >= g_current_runtime_level ) THEN
1063: FND_LOG.STRING(g_level_procedure,

Line 1094: l_number_value IN zx_lines.tax_line_id%TYPE,

1090: | l_number_value does not esist in l_number_tbl |
1091: * ======================================================================*/
1092: FUNCTION get_tbl_index (
1093: l_number_tbl IN tax_line_id_tp,
1094: l_number_value IN zx_lines.tax_line_id%TYPE,
1095: x_return_status OUT NOCOPY VARCHAR2
1096: ) RETURN NUMBER IS
1097:
1098: l_return_index NUMBER;