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_IMPORT_DOCUMENT_PKG dependencies on ZX_IMPORT_TAX_LINES_GT

Line 13: summary_tax_line_number zx_import_tax_lines_gt.summary_tax_line_number%TYPE,

9:
10: NUMBER_DUMMY CONSTANT NUMBER := -999999999999;
11:
12: TYPE tax_line_rec_type is RECORD (
13: summary_tax_line_number zx_import_tax_lines_gt.summary_tax_line_number%TYPE,
14: internal_organization_id zx_import_tax_lines_gt.internal_organization_id%TYPE,
15: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,
16: tax zx_import_tax_lines_gt.tax%TYPE,
17: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,

Line 14: internal_organization_id zx_import_tax_lines_gt.internal_organization_id%TYPE,

10: NUMBER_DUMMY CONSTANT NUMBER := -999999999999;
11:
12: TYPE tax_line_rec_type is RECORD (
13: summary_tax_line_number zx_import_tax_lines_gt.summary_tax_line_number%TYPE,
14: internal_organization_id zx_import_tax_lines_gt.internal_organization_id%TYPE,
15: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,
16: tax zx_import_tax_lines_gt.tax%TYPE,
17: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,
18: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,

Line 15: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,

11:
12: TYPE tax_line_rec_type is RECORD (
13: summary_tax_line_number zx_import_tax_lines_gt.summary_tax_line_number%TYPE,
14: internal_organization_id zx_import_tax_lines_gt.internal_organization_id%TYPE,
15: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,
16: tax zx_import_tax_lines_gt.tax%TYPE,
17: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,
18: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,
19: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,

Line 16: tax zx_import_tax_lines_gt.tax%TYPE,

12: TYPE tax_line_rec_type is RECORD (
13: summary_tax_line_number zx_import_tax_lines_gt.summary_tax_line_number%TYPE,
14: internal_organization_id zx_import_tax_lines_gt.internal_organization_id%TYPE,
15: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,
16: tax zx_import_tax_lines_gt.tax%TYPE,
17: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,
18: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,
19: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,
20: summary_tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,

Line 17: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,

13: summary_tax_line_number zx_import_tax_lines_gt.summary_tax_line_number%TYPE,
14: internal_organization_id zx_import_tax_lines_gt.internal_organization_id%TYPE,
15: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,
16: tax zx_import_tax_lines_gt.tax%TYPE,
17: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,
18: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,
19: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,
20: summary_tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,
21: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,

Line 18: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,

14: internal_organization_id zx_import_tax_lines_gt.internal_organization_id%TYPE,
15: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,
16: tax zx_import_tax_lines_gt.tax%TYPE,
17: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,
18: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,
19: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,
20: summary_tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,
21: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,
22: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE,

Line 19: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,

15: tax_regime_code zx_import_tax_lines_gt.tax_regime_code%TYPE,
16: tax zx_import_tax_lines_gt.tax%TYPE,
17: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,
18: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,
19: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,
20: summary_tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,
21: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,
22: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE,
23: tax_exception_id zx_import_tax_lines_gt.tax_exception_id%TYPE,

Line 20: summary_tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,

16: tax zx_import_tax_lines_gt.tax%TYPE,
17: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,
18: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,
19: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,
20: summary_tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,
21: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,
22: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE,
23: tax_exception_id zx_import_tax_lines_gt.tax_exception_id%TYPE,
24: tax_exemption_id zx_import_tax_lines_gt.tax_exemption_id%TYPE,

Line 21: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,

17: tax_status_code zx_import_tax_lines_gt.tax_status_code%TYPE,
18: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,
19: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,
20: summary_tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,
21: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,
22: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE,
23: tax_exception_id zx_import_tax_lines_gt.tax_exception_id%TYPE,
24: tax_exemption_id zx_import_tax_lines_gt.tax_exemption_id%TYPE,
25: exempt_reason_code zx_import_tax_lines_gt.exempt_reason_code%TYPE,

Line 22: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE,

18: tax_rate_code zx_import_tax_lines_gt.tax_rate_code%TYPE,
19: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,
20: summary_tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,
21: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,
22: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE,
23: tax_exception_id zx_import_tax_lines_gt.tax_exception_id%TYPE,
24: tax_exemption_id zx_import_tax_lines_gt.tax_exemption_id%TYPE,
25: exempt_reason_code zx_import_tax_lines_gt.exempt_reason_code%TYPE,
26: exempt_certificate_number zx_import_tax_lines_gt.exempt_certificate_number%TYPE,

Line 23: tax_exception_id zx_import_tax_lines_gt.tax_exception_id%TYPE,

19: tax_rate zx_import_tax_lines_gt.tax_rate%TYPE,
20: summary_tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,
21: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,
22: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE,
23: tax_exception_id zx_import_tax_lines_gt.tax_exception_id%TYPE,
24: tax_exemption_id zx_import_tax_lines_gt.tax_exemption_id%TYPE,
25: exempt_reason_code zx_import_tax_lines_gt.exempt_reason_code%TYPE,
26: exempt_certificate_number zx_import_tax_lines_gt.exempt_certificate_number%TYPE,
27: trx_line_id zx_trx_tax_link_gt.trx_line_id%TYPE,

Line 24: tax_exemption_id zx_import_tax_lines_gt.tax_exemption_id%TYPE,

20: summary_tax_amt zx_import_tax_lines_gt.tax_amt%TYPE,
21: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,
22: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE,
23: tax_exception_id zx_import_tax_lines_gt.tax_exception_id%TYPE,
24: tax_exemption_id zx_import_tax_lines_gt.tax_exemption_id%TYPE,
25: exempt_reason_code zx_import_tax_lines_gt.exempt_reason_code%TYPE,
26: exempt_certificate_number zx_import_tax_lines_gt.exempt_certificate_number%TYPE,
27: trx_line_id zx_trx_tax_link_gt.trx_line_id%TYPE,
28: line_amt zx_trx_tax_link_gt.line_amt%TYPE,

Line 25: exempt_reason_code zx_import_tax_lines_gt.exempt_reason_code%TYPE,

21: tax_jurisdiction_code zx_import_tax_lines_gt.tax_jurisdiction_code%TYPE,
22: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE,
23: tax_exception_id zx_import_tax_lines_gt.tax_exception_id%TYPE,
24: tax_exemption_id zx_import_tax_lines_gt.tax_exemption_id%TYPE,
25: exempt_reason_code zx_import_tax_lines_gt.exempt_reason_code%TYPE,
26: exempt_certificate_number zx_import_tax_lines_gt.exempt_certificate_number%TYPE,
27: trx_line_id zx_trx_tax_link_gt.trx_line_id%TYPE,
28: line_amt zx_trx_tax_link_gt.line_amt%TYPE,
29: trx_date zx_trx_headers_gt.trx_date%TYPE,

Line 26: exempt_certificate_number zx_import_tax_lines_gt.exempt_certificate_number%TYPE,

22: tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE,
23: tax_exception_id zx_import_tax_lines_gt.tax_exception_id%TYPE,
24: tax_exemption_id zx_import_tax_lines_gt.tax_exemption_id%TYPE,
25: exempt_reason_code zx_import_tax_lines_gt.exempt_reason_code%TYPE,
26: exempt_certificate_number zx_import_tax_lines_gt.exempt_certificate_number%TYPE,
27: trx_line_id zx_trx_tax_link_gt.trx_line_id%TYPE,
28: line_amt zx_trx_tax_link_gt.line_amt%TYPE,
29: trx_date zx_trx_headers_gt.trx_date%TYPE,
30: minimum_accountable_unit zx_trx_headers_gt.minimum_accountable_unit%TYPE,

Line 36: interface_entity_code zx_import_tax_lines_gt.interface_entity_code%TYPE,

32: trx_level_type zx_transaction_lines_gt.trx_level_type%TYPE,
33: trx_line_date zx_transaction_lines_gt.trx_line_date%TYPE,
34: adjusted_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE,
35: line_level_action zx_transaction_lines_gt.line_level_action%TYPE,
36: interface_entity_code zx_import_tax_lines_gt.interface_entity_code%TYPE,
37: interface_tax_line_id zx_import_tax_lines_gt.interface_tax_line_id%TYPE,
38: related_doc_date zx_trx_headers_gt.related_doc_date%TYPE,
39: provnl_tax_determination_date zx_trx_headers_gt.provnl_tax_determination_date%TYPE,
40: -- added for bug 5018766

Line 37: interface_tax_line_id zx_import_tax_lines_gt.interface_tax_line_id%TYPE,

33: trx_line_date zx_transaction_lines_gt.trx_line_date%TYPE,
34: adjusted_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE,
35: line_level_action zx_transaction_lines_gt.line_level_action%TYPE,
36: interface_entity_code zx_import_tax_lines_gt.interface_entity_code%TYPE,
37: interface_tax_line_id zx_import_tax_lines_gt.interface_tax_line_id%TYPE,
38: related_doc_date zx_trx_headers_gt.related_doc_date%TYPE,
39: provnl_tax_determination_date zx_trx_headers_gt.provnl_tax_determination_date%TYPE,
40: -- added for bug 5018766
41: tax_date zx_transaction_lines_gt.tax_date%type,

Line 45: attribute1 zx_import_tax_lines_gt.attribute1%TYPE,

41: tax_date zx_transaction_lines_gt.tax_date%type,
42: tax_determine_date zx_transaction_lines_gt.tax_determine_date%type,
43: tax_point_date zx_transaction_lines_gt.tax_point_date%type,
44: -- Bug 7117340 -- DFF ER
45: attribute1 zx_import_tax_lines_gt.attribute1%TYPE,
46: attribute2 zx_import_tax_lines_gt.attribute2%TYPE,
47: attribute3 zx_import_tax_lines_gt.attribute3%TYPE,
48: attribute4 zx_import_tax_lines_gt.attribute4%TYPE,
49: attribute5 zx_import_tax_lines_gt.attribute5%TYPE,

Line 46: attribute2 zx_import_tax_lines_gt.attribute2%TYPE,

42: tax_determine_date zx_transaction_lines_gt.tax_determine_date%type,
43: tax_point_date zx_transaction_lines_gt.tax_point_date%type,
44: -- Bug 7117340 -- DFF ER
45: attribute1 zx_import_tax_lines_gt.attribute1%TYPE,
46: attribute2 zx_import_tax_lines_gt.attribute2%TYPE,
47: attribute3 zx_import_tax_lines_gt.attribute3%TYPE,
48: attribute4 zx_import_tax_lines_gt.attribute4%TYPE,
49: attribute5 zx_import_tax_lines_gt.attribute5%TYPE,
50: attribute6 zx_import_tax_lines_gt.attribute6%TYPE,

Line 47: attribute3 zx_import_tax_lines_gt.attribute3%TYPE,

43: tax_point_date zx_transaction_lines_gt.tax_point_date%type,
44: -- Bug 7117340 -- DFF ER
45: attribute1 zx_import_tax_lines_gt.attribute1%TYPE,
46: attribute2 zx_import_tax_lines_gt.attribute2%TYPE,
47: attribute3 zx_import_tax_lines_gt.attribute3%TYPE,
48: attribute4 zx_import_tax_lines_gt.attribute4%TYPE,
49: attribute5 zx_import_tax_lines_gt.attribute5%TYPE,
50: attribute6 zx_import_tax_lines_gt.attribute6%TYPE,
51: attribute7 zx_import_tax_lines_gt.attribute7%TYPE,

Line 48: attribute4 zx_import_tax_lines_gt.attribute4%TYPE,

44: -- Bug 7117340 -- DFF ER
45: attribute1 zx_import_tax_lines_gt.attribute1%TYPE,
46: attribute2 zx_import_tax_lines_gt.attribute2%TYPE,
47: attribute3 zx_import_tax_lines_gt.attribute3%TYPE,
48: attribute4 zx_import_tax_lines_gt.attribute4%TYPE,
49: attribute5 zx_import_tax_lines_gt.attribute5%TYPE,
50: attribute6 zx_import_tax_lines_gt.attribute6%TYPE,
51: attribute7 zx_import_tax_lines_gt.attribute7%TYPE,
52: attribute8 zx_import_tax_lines_gt.attribute8%TYPE,

Line 49: attribute5 zx_import_tax_lines_gt.attribute5%TYPE,

45: attribute1 zx_import_tax_lines_gt.attribute1%TYPE,
46: attribute2 zx_import_tax_lines_gt.attribute2%TYPE,
47: attribute3 zx_import_tax_lines_gt.attribute3%TYPE,
48: attribute4 zx_import_tax_lines_gt.attribute4%TYPE,
49: attribute5 zx_import_tax_lines_gt.attribute5%TYPE,
50: attribute6 zx_import_tax_lines_gt.attribute6%TYPE,
51: attribute7 zx_import_tax_lines_gt.attribute7%TYPE,
52: attribute8 zx_import_tax_lines_gt.attribute8%TYPE,
53: attribute9 zx_import_tax_lines_gt.attribute9%TYPE,

Line 50: attribute6 zx_import_tax_lines_gt.attribute6%TYPE,

46: attribute2 zx_import_tax_lines_gt.attribute2%TYPE,
47: attribute3 zx_import_tax_lines_gt.attribute3%TYPE,
48: attribute4 zx_import_tax_lines_gt.attribute4%TYPE,
49: attribute5 zx_import_tax_lines_gt.attribute5%TYPE,
50: attribute6 zx_import_tax_lines_gt.attribute6%TYPE,
51: attribute7 zx_import_tax_lines_gt.attribute7%TYPE,
52: attribute8 zx_import_tax_lines_gt.attribute8%TYPE,
53: attribute9 zx_import_tax_lines_gt.attribute9%TYPE,
54: attribute10 zx_import_tax_lines_gt.attribute10%TYPE,

Line 51: attribute7 zx_import_tax_lines_gt.attribute7%TYPE,

47: attribute3 zx_import_tax_lines_gt.attribute3%TYPE,
48: attribute4 zx_import_tax_lines_gt.attribute4%TYPE,
49: attribute5 zx_import_tax_lines_gt.attribute5%TYPE,
50: attribute6 zx_import_tax_lines_gt.attribute6%TYPE,
51: attribute7 zx_import_tax_lines_gt.attribute7%TYPE,
52: attribute8 zx_import_tax_lines_gt.attribute8%TYPE,
53: attribute9 zx_import_tax_lines_gt.attribute9%TYPE,
54: attribute10 zx_import_tax_lines_gt.attribute10%TYPE,
55: attribute11 zx_import_tax_lines_gt.attribute11%TYPE,

Line 52: attribute8 zx_import_tax_lines_gt.attribute8%TYPE,

48: attribute4 zx_import_tax_lines_gt.attribute4%TYPE,
49: attribute5 zx_import_tax_lines_gt.attribute5%TYPE,
50: attribute6 zx_import_tax_lines_gt.attribute6%TYPE,
51: attribute7 zx_import_tax_lines_gt.attribute7%TYPE,
52: attribute8 zx_import_tax_lines_gt.attribute8%TYPE,
53: attribute9 zx_import_tax_lines_gt.attribute9%TYPE,
54: attribute10 zx_import_tax_lines_gt.attribute10%TYPE,
55: attribute11 zx_import_tax_lines_gt.attribute11%TYPE,
56: attribute12 zx_import_tax_lines_gt.attribute12%TYPE,

Line 53: attribute9 zx_import_tax_lines_gt.attribute9%TYPE,

49: attribute5 zx_import_tax_lines_gt.attribute5%TYPE,
50: attribute6 zx_import_tax_lines_gt.attribute6%TYPE,
51: attribute7 zx_import_tax_lines_gt.attribute7%TYPE,
52: attribute8 zx_import_tax_lines_gt.attribute8%TYPE,
53: attribute9 zx_import_tax_lines_gt.attribute9%TYPE,
54: attribute10 zx_import_tax_lines_gt.attribute10%TYPE,
55: attribute11 zx_import_tax_lines_gt.attribute11%TYPE,
56: attribute12 zx_import_tax_lines_gt.attribute12%TYPE,
57: attribute13 zx_import_tax_lines_gt.attribute13%TYPE,

Line 54: attribute10 zx_import_tax_lines_gt.attribute10%TYPE,

50: attribute6 zx_import_tax_lines_gt.attribute6%TYPE,
51: attribute7 zx_import_tax_lines_gt.attribute7%TYPE,
52: attribute8 zx_import_tax_lines_gt.attribute8%TYPE,
53: attribute9 zx_import_tax_lines_gt.attribute9%TYPE,
54: attribute10 zx_import_tax_lines_gt.attribute10%TYPE,
55: attribute11 zx_import_tax_lines_gt.attribute11%TYPE,
56: attribute12 zx_import_tax_lines_gt.attribute12%TYPE,
57: attribute13 zx_import_tax_lines_gt.attribute13%TYPE,
58: attribute14 zx_import_tax_lines_gt.attribute14%TYPE,

Line 55: attribute11 zx_import_tax_lines_gt.attribute11%TYPE,

51: attribute7 zx_import_tax_lines_gt.attribute7%TYPE,
52: attribute8 zx_import_tax_lines_gt.attribute8%TYPE,
53: attribute9 zx_import_tax_lines_gt.attribute9%TYPE,
54: attribute10 zx_import_tax_lines_gt.attribute10%TYPE,
55: attribute11 zx_import_tax_lines_gt.attribute11%TYPE,
56: attribute12 zx_import_tax_lines_gt.attribute12%TYPE,
57: attribute13 zx_import_tax_lines_gt.attribute13%TYPE,
58: attribute14 zx_import_tax_lines_gt.attribute14%TYPE,
59: attribute15 zx_import_tax_lines_gt.attribute15%TYPE,

Line 56: attribute12 zx_import_tax_lines_gt.attribute12%TYPE,

52: attribute8 zx_import_tax_lines_gt.attribute8%TYPE,
53: attribute9 zx_import_tax_lines_gt.attribute9%TYPE,
54: attribute10 zx_import_tax_lines_gt.attribute10%TYPE,
55: attribute11 zx_import_tax_lines_gt.attribute11%TYPE,
56: attribute12 zx_import_tax_lines_gt.attribute12%TYPE,
57: attribute13 zx_import_tax_lines_gt.attribute13%TYPE,
58: attribute14 zx_import_tax_lines_gt.attribute14%TYPE,
59: attribute15 zx_import_tax_lines_gt.attribute15%TYPE,
60: attribute_category zx_import_tax_lines_gt.attribute_category%TYPE

Line 57: attribute13 zx_import_tax_lines_gt.attribute13%TYPE,

53: attribute9 zx_import_tax_lines_gt.attribute9%TYPE,
54: attribute10 zx_import_tax_lines_gt.attribute10%TYPE,
55: attribute11 zx_import_tax_lines_gt.attribute11%TYPE,
56: attribute12 zx_import_tax_lines_gt.attribute12%TYPE,
57: attribute13 zx_import_tax_lines_gt.attribute13%TYPE,
58: attribute14 zx_import_tax_lines_gt.attribute14%TYPE,
59: attribute15 zx_import_tax_lines_gt.attribute15%TYPE,
60: attribute_category zx_import_tax_lines_gt.attribute_category%TYPE
61: );

Line 58: attribute14 zx_import_tax_lines_gt.attribute14%TYPE,

54: attribute10 zx_import_tax_lines_gt.attribute10%TYPE,
55: attribute11 zx_import_tax_lines_gt.attribute11%TYPE,
56: attribute12 zx_import_tax_lines_gt.attribute12%TYPE,
57: attribute13 zx_import_tax_lines_gt.attribute13%TYPE,
58: attribute14 zx_import_tax_lines_gt.attribute14%TYPE,
59: attribute15 zx_import_tax_lines_gt.attribute15%TYPE,
60: attribute_category zx_import_tax_lines_gt.attribute_category%TYPE
61: );
62:

Line 59: attribute15 zx_import_tax_lines_gt.attribute15%TYPE,

55: attribute11 zx_import_tax_lines_gt.attribute11%TYPE,
56: attribute12 zx_import_tax_lines_gt.attribute12%TYPE,
57: attribute13 zx_import_tax_lines_gt.attribute13%TYPE,
58: attribute14 zx_import_tax_lines_gt.attribute14%TYPE,
59: attribute15 zx_import_tax_lines_gt.attribute15%TYPE,
60: attribute_category zx_import_tax_lines_gt.attribute_category%TYPE
61: );
62:
63: PROCEDURE create_detail_tax_line (

Line 60: attribute_category zx_import_tax_lines_gt.attribute_category%TYPE

56: attribute12 zx_import_tax_lines_gt.attribute12%TYPE,
57: attribute13 zx_import_tax_lines_gt.attribute13%TYPE,
58: attribute14 zx_import_tax_lines_gt.attribute14%TYPE,
59: attribute15 zx_import_tax_lines_gt.attribute15%TYPE,
60: attribute_category zx_import_tax_lines_gt.attribute_category%TYPE
61: );
62:
63: PROCEDURE create_detail_tax_line (
64: p_event_class_rec IN zx_api_pub.event_class_rec_type,

Line 101: INDEX(sumgt ZX_IMPORT_TAX_LINES_GT_U1)

97:
98: CURSOR get_alloc_detail_tax_lines_csr IS
99: SELECT /*+ ORDERED
100: INDEX(headergt ZX_TRX_HEADERS_GT_U1)
101: INDEX(sumgt ZX_IMPORT_TAX_LINES_GT_U1)
102: INDEX(allocgt ZX_TRX_TAX_LINK_GT_U1)
103: INDEX(linegt ZX_TRANSACTION_LINES_GT_U1 )*/
104: sumgt.summary_tax_line_number,
105: sumgt.internal_organization_id,

Line 153: zx_import_tax_lines_gt sumgt,

149: sumgt.attribute14,
150: sumgt.attribute15,
151: sumgt.attribute_category
152: FROM zx_trx_headers_gt headergt,
153: zx_import_tax_lines_gt sumgt,
154: zx_trx_tax_link_gt allocgt,
155: zx_transaction_lines_gt linegt
156: WHERE headergt.application_id = p_event_class_rec.application_id
157: AND headergt.event_class_code = p_event_class_rec.event_class_code

Line 181: INDEX(sumgt ZX_IMPORT_TAX_LINES_GT_U1)

177:
178: CURSOR get_one_alloc_det_tax_lines_cr IS
179: SELECT /*+ ORDERED
180: INDEX(headergt ZX_TRX_HEADERS_GT_U1)
181: INDEX(sumgt ZX_IMPORT_TAX_LINES_GT_U1)
182: INDEX(linegt ZX_TRANSACTION_LINES_GT_U1)*/
183: sumgt.summary_tax_line_number,
184: sumgt.internal_organization_id,
185: sumgt.tax_regime_code,

Line 232: zx_import_tax_lines_gt sumgt,

228: sumgt.attribute14,
229: sumgt.attribute15,
230: sumgt.attribute_category
231: FROM zx_trx_headers_gt headergt,
232: zx_import_tax_lines_gt sumgt,
233: zx_transaction_lines_gt linegt
234: WHERE headergt.application_id = p_event_class_rec.application_id
235: AND headergt.event_class_code = p_event_class_rec.event_class_code
236: AND headergt.entity_code = p_event_class_rec.entity_code

Line 254: INDEX(sumgt ZX_IMPORT_TAX_LINES_GT_U1)

250:
251: CURSOR get_all_detail_tax_lines_csr IS
252: SELECT /*+ ORDERED
253: INDEX(headergt ZX_TRX_HEADERS_GT_U1)
254: INDEX(sumgt ZX_IMPORT_TAX_LINES_GT_U1)
255: INDEX(linegt ZX_TRANSACTION_LINES_GT_U1) */
256: sumgt.summary_tax_line_number,
257: sumgt.internal_organization_id,
258: sumgt.tax_regime_code,

Line 305: zx_import_tax_lines_gt sumgt,

301: sumgt.attribute14,
302: sumgt.attribute15,
303: sumgt.attribute_category
304: FROM zx_trx_headers_gt headergt,
305: zx_import_tax_lines_gt sumgt,
306: zx_transaction_lines_gt linegt
307: WHERE headergt.application_id = p_event_class_rec.application_id
308: AND headergt.event_class_code = p_event_class_rec.event_class_code
309: AND headergt.entity_code = p_event_class_rec.entity_code

Line 1048: l_tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE;

1044: l_tax_id ZX_TAXES_B.tax_id%TYPE;
1045: l_def_reg_type ZX_TAXES_B.def_registr_party_type_code%TYPE;
1046: l_reg_rule_flg ZX_TAXES_B.registration_type_rule_flag%TYPE;
1047: l_tax_rate zx_lines.tax_rate%TYPE;
1048: l_tax_amt_included_flag zx_import_tax_lines_gt.tax_amt_included_flag%TYPE;
1049:
1050: l_adjusted_doc_tax_line_id zx_lines.adjusted_doc_tax_line_id%TYPE;
1051: l_reporting_code_id ZX_REPORTING_CODES_B.reporting_code_id%type;
1052: BEGIN