5: TYPE currency_conversion_rec IS RECORD
6: (
7: min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
8: precision ZX_TAXES_B.TAX_PRECISION%TYPE,
9: conversion_rate ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
10: derive_effective FND_CURRENCIES.DERIVE_EFFECTIVE%TYPE,
11: derive_type FND_CURRENCIES.DERIVE_TYPE%TYPE,
12: conversion_date ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
13: currency_type VARCHAR2(30)
8: precision ZX_TAXES_B.TAX_PRECISION%TYPE,
9: conversion_rate ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
10: derive_effective FND_CURRENCIES.DERIVE_EFFECTIVE%TYPE,
11: derive_type FND_CURRENCIES.DERIVE_TYPE%TYPE,
12: conversion_date ZX_LINES.TAX_CURRENCY_CONVERSION_DATE%TYPE,
13: currency_type VARCHAR2(30)
14: );
15:
16:
21: INDEX BY BINARY_INTEGER;
22:
23: TYPE hdr_grp_rec_type IS RECORD
24: (
25: application_id ZX_LINES.application_id%TYPE,
26: event_class_code ZX_LINES.event_class_code%TYPE,
27: entity_code ZX_LINES.entity_code%TYPE,
28: trx_id ZX_LINES.trx_id%TYPE,
29: tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
22:
23: TYPE hdr_grp_rec_type IS RECORD
24: (
25: application_id ZX_LINES.application_id%TYPE,
26: event_class_code ZX_LINES.event_class_code%TYPE,
27: entity_code ZX_LINES.entity_code%TYPE,
28: trx_id ZX_LINES.trx_id%TYPE,
29: tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
30: tax ZX_TAXES_B.tax%TYPE,
23: TYPE hdr_grp_rec_type IS RECORD
24: (
25: application_id ZX_LINES.application_id%TYPE,
26: event_class_code ZX_LINES.event_class_code%TYPE,
27: entity_code ZX_LINES.entity_code%TYPE,
28: trx_id ZX_LINES.trx_id%TYPE,
29: tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
30: tax ZX_TAXES_B.tax%TYPE,
31: tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
24: (
25: application_id ZX_LINES.application_id%TYPE,
26: event_class_code ZX_LINES.event_class_code%TYPE,
27: entity_code ZX_LINES.entity_code%TYPE,
28: trx_id ZX_LINES.trx_id%TYPE,
29: tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
30: tax ZX_TAXES_B.tax%TYPE,
31: tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
32: tax_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE,
29: tax_regime_code ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
30: tax ZX_TAXES_B.tax%TYPE,
31: tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
32: tax_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE,
33: tax_rate ZX_LINES.TAX_RATE%TYPE,
34: tax_rate_id ZX_LINES.TAX_RATE_ID%TYPE,
35: tax_jurisdiction_code ZX_LINES.TAX_JURISDICTION_CODE%TYPE,
36: taxable_basis_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
37: tax_calculation_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
30: tax ZX_TAXES_B.tax%TYPE,
31: tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
32: tax_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE,
33: tax_rate ZX_LINES.TAX_RATE%TYPE,
34: tax_rate_id ZX_LINES.TAX_RATE_ID%TYPE,
35: tax_jurisdiction_code ZX_LINES.TAX_JURISDICTION_CODE%TYPE,
36: taxable_basis_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
37: tax_calculation_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
38: tax_Amt_Included_Flag ZX_LINES.TAX_AMT_INCLUDED_FLAG%TYPE,
31: tax_status_code ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
32: tax_rate_code ZX_RATES_B.TAX_RATE_CODE%TYPE,
33: tax_rate ZX_LINES.TAX_RATE%TYPE,
34: tax_rate_id ZX_LINES.TAX_RATE_ID%TYPE,
35: tax_jurisdiction_code ZX_LINES.TAX_JURISDICTION_CODE%TYPE,
36: taxable_basis_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
37: tax_calculation_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
38: tax_Amt_Included_Flag ZX_LINES.TAX_AMT_INCLUDED_FLAG%TYPE,
39: compounding_tax_flag ZX_LINES.COMPOUNDING_TAX_FLAG%TYPE,
34: tax_rate_id ZX_LINES.TAX_RATE_ID%TYPE,
35: tax_jurisdiction_code ZX_LINES.TAX_JURISDICTION_CODE%TYPE,
36: taxable_basis_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
37: tax_calculation_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
38: tax_Amt_Included_Flag ZX_LINES.TAX_AMT_INCLUDED_FLAG%TYPE,
39: compounding_tax_flag ZX_LINES.COMPOUNDING_TAX_FLAG%TYPE,
40: historical_flag ZX_LINES.HISTORICAL_FLAG%TYPE,
41: self_assessed_flag ZX_LINES.SELF_ASSESSED_FLAG%TYPE,
42: overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
35: tax_jurisdiction_code ZX_LINES.TAX_JURISDICTION_CODE%TYPE,
36: taxable_basis_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
37: tax_calculation_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
38: tax_Amt_Included_Flag ZX_LINES.TAX_AMT_INCLUDED_FLAG%TYPE,
39: compounding_tax_flag ZX_LINES.COMPOUNDING_TAX_FLAG%TYPE,
40: historical_flag ZX_LINES.HISTORICAL_FLAG%TYPE,
41: self_assessed_flag ZX_LINES.SELF_ASSESSED_FLAG%TYPE,
42: overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
43: manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
36: taxable_basis_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
37: tax_calculation_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
38: tax_Amt_Included_Flag ZX_LINES.TAX_AMT_INCLUDED_FLAG%TYPE,
39: compounding_tax_flag ZX_LINES.COMPOUNDING_TAX_FLAG%TYPE,
40: historical_flag ZX_LINES.HISTORICAL_FLAG%TYPE,
41: self_assessed_flag ZX_LINES.SELF_ASSESSED_FLAG%TYPE,
42: overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
43: manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
44: copied_from_other_doc_flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
37: tax_calculation_formula ZX_FORMULA_B.FORMULA_CODE%TYPE,
38: tax_Amt_Included_Flag ZX_LINES.TAX_AMT_INCLUDED_FLAG%TYPE,
39: compounding_tax_flag ZX_LINES.COMPOUNDING_TAX_FLAG%TYPE,
40: historical_flag ZX_LINES.HISTORICAL_FLAG%TYPE,
41: self_assessed_flag ZX_LINES.SELF_ASSESSED_FLAG%TYPE,
42: overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
43: manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
44: copied_from_other_doc_flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
45: associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
38: tax_Amt_Included_Flag ZX_LINES.TAX_AMT_INCLUDED_FLAG%TYPE,
39: compounding_tax_flag ZX_LINES.COMPOUNDING_TAX_FLAG%TYPE,
40: historical_flag ZX_LINES.HISTORICAL_FLAG%TYPE,
41: self_assessed_flag ZX_LINES.SELF_ASSESSED_FLAG%TYPE,
42: overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
43: manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
44: copied_from_other_doc_flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
45: associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
46: tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
39: compounding_tax_flag ZX_LINES.COMPOUNDING_TAX_FLAG%TYPE,
40: historical_flag ZX_LINES.HISTORICAL_FLAG%TYPE,
41: self_assessed_flag ZX_LINES.SELF_ASSESSED_FLAG%TYPE,
42: overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
43: manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
44: copied_from_other_doc_flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
45: associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
46: tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
47: mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
40: historical_flag ZX_LINES.HISTORICAL_FLAG%TYPE,
41: self_assessed_flag ZX_LINES.SELF_ASSESSED_FLAG%TYPE,
42: overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
43: manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
44: copied_from_other_doc_flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
45: associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
46: tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
47: mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
48: reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
41: self_assessed_flag ZX_LINES.SELF_ASSESSED_FLAG%TYPE,
42: overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
43: manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
44: copied_from_other_doc_flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
45: associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
46: tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
47: mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
48: reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
49: applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
42: overridden_flag ZX_LINES.OVERRIDDEN_FLAG%TYPE,
43: manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
44: copied_from_other_doc_flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
45: associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
46: tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
47: mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
48: reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
49: applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
50: applied_from_event_class_code ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
43: manually_entered_flag ZX_LINES.MANUALLY_ENTERED_FLAG%TYPE,
44: copied_from_other_doc_flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
45: associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
46: tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
47: mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
48: reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
49: applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
50: applied_from_event_class_code ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
51: applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
44: copied_from_other_doc_flag ZX_LINES.COPIED_FROM_OTHER_DOC_FLAG%TYPE,
45: associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
46: tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
47: mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
48: reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
49: applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
50: applied_from_event_class_code ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
51: applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
52: applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
45: associated_child_frozen_flag ZX_LINES.ASSOCIATED_CHILD_FROZEN_FLAG%TYPE,
46: tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
47: mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
48: reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
49: applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
50: applied_from_event_class_code ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
51: applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
52: applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
53: applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
46: tax_only_line_flag ZX_LINES.TAX_ONLY_LINE_FLAG%TYPE,
47: mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
48: reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
49: applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
50: applied_from_event_class_code ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
51: applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
52: applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
53: applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
54: adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
47: mrc_tax_line_flag ZX_LINES.MRC_TAX_LINE_FLAG%TYPE,
48: reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
49: applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
50: applied_from_event_class_code ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
51: applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
52: applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
53: applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
54: adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
55: adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
48: reporting_only_flag ZX_LINES.REPORTING_ONLY_FLAG%TYPE,
49: applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
50: applied_from_event_class_code ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
51: applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
52: applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
53: applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
54: adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
55: adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
56: adjusted_doc_event_class_code ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
49: applied_from_application_id ZX_LINES.APPLIED_FROM_APPLICATION_ID%TYPE,
50: applied_from_event_class_code ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
51: applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
52: applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
53: applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
54: adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
55: adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
56: adjusted_doc_event_class_code ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
57: adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
50: applied_from_event_class_code ZX_LINES.APPLIED_FROM_EVENT_CLASS_CODE%TYPE,
51: applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
52: applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
53: applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
54: adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
55: adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
56: adjusted_doc_event_class_code ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
57: adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
58: applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
51: applied_from_entity_code ZX_LINES.APPLIED_FROM_ENTITY_CODE%TYPE,
52: applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
53: applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
54: adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
55: adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
56: adjusted_doc_event_class_code ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
57: adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
58: applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
59: applied_to_event_class_code ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
52: applied_from_trx_id ZX_LINES.APPLIED_FROM_TRX_ID%TYPE,
53: applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
54: adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
55: adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
56: adjusted_doc_event_class_code ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
57: adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
58: applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
59: applied_to_event_class_code ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
60: applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
53: applied_from_line_id ZX_LINES.APPLIED_FROM_LINE_ID%TYPE,
54: adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
55: adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
56: adjusted_doc_event_class_code ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
57: adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
58: applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
59: applied_to_event_class_code ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
60: applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
61: applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
54: adjusted_doc_application_id ZX_LINES.ADJUSTED_DOC_APPLICATION_ID%TYPE,
55: adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
56: adjusted_doc_event_class_code ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
57: adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
58: applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
59: applied_to_event_class_code ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
60: applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
61: applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
62: applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
55: adjusted_doc_entity_code ZX_LINES.ADJUSTED_DOC_ENTITY_CODE%TYPE,
56: adjusted_doc_event_class_code ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
57: adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
58: applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
59: applied_to_event_class_code ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
60: applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
61: applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
62: applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
63: tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
56: adjusted_doc_event_class_code ZX_LINES.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE,
57: adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
58: applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
59: applied_to_event_class_code ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
60: applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
61: applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
62: applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
63: tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
64: tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
57: adjusted_doc_trx_id ZX_LINES.ADJUSTED_DOC_TRX_ID%TYPE,
58: applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
59: applied_to_event_class_code ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
60: applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
61: applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
62: applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
63: tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
64: tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
65: tax_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
58: applied_to_application_id ZX_LINES.APPLIED_TO_APPLICATION_ID%TYPE,
59: applied_to_event_class_code ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
60: applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
61: applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
62: applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
63: tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
64: tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
65: tax_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
66: exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
59: applied_to_event_class_code ZX_LINES.APPLIED_TO_EVENT_CLASS_CODE%TYPE,
60: applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
61: applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
62: applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
63: tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
64: tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
65: tax_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
66: exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
67: exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
60: applied_to_entity_code ZX_LINES.APPLIED_TO_ENTITY_CODE%TYPE,
61: applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
62: applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
63: tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
64: tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
65: tax_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
66: exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
67: exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
68: exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
61: applied_to_trx_id ZX_LINES.APPLIED_TO_TRX_ID%TYPE,
62: applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
63: tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
64: tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
65: tax_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
66: exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
67: exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
68: exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
69: exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
62: applied_to_line_id ZX_LINES.APPLIED_TO_LINE_ID%TYPE,
63: tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
64: tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
65: tax_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
66: exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
67: exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
68: exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
69: exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
70: tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
63: tax_exemption_id ZX_LINES.TAX_EXEMPTION_ID%TYPE,
64: tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
65: tax_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
66: exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
67: exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
68: exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
69: exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
70: tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
71: tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
64: tax_rate_before_exemption ZX_LINES.TAX_RATE_BEFORE_EXEMPTION%TYPE,
65: tax_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
66: exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
67: exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
68: exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
69: exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
70: tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
71: tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
72: tax_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
65: tax_rate_name_before_exemption ZX_LINES.TAX_RATE_NAME_BEFORE_EXEMPTION%TYPE,
66: exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
67: exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
68: exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
69: exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
70: tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
71: tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
72: tax_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
73: exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
66: exempt_rate_modifier ZX_LINES.EXEMPT_RATE_MODIFIER%TYPE,
67: exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
68: exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
69: exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
70: tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
71: tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
72: tax_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
73: exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
74: ledger_id ZX_LINES.LEDGER_ID%TYPE,
67: exempt_certificate_number ZX_LINES.EXEMPT_CERTIFICATE_NUMBER%TYPE,
68: exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
69: exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
70: tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
71: tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
72: tax_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
73: exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
74: ledger_id ZX_LINES.LEDGER_ID%TYPE,
75: legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
68: exempt_reason ZX_LINES.EXEMPT_REASON%TYPE,
69: exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
70: tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
71: tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
72: tax_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
73: exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
74: ledger_id ZX_LINES.LEDGER_ID%TYPE,
75: legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
76: establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
69: exempt_reason_code ZX_LINES.EXEMPT_REASON_CODE%TYPE,
70: tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
71: tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
72: tax_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
73: exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
74: ledger_id ZX_LINES.LEDGER_ID%TYPE,
75: legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
76: establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
77: currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
70: tax_exception_id ZX_LINES.TAX_EXCEPTION_ID%TYPE,
71: tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
72: tax_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
73: exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
74: ledger_id ZX_LINES.LEDGER_ID%TYPE,
75: legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
76: establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
77: currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
78: currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
71: tax_rate_before_exception ZX_LINES.TAX_RATE_BEFORE_EXCEPTION%TYPE,
72: tax_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
73: exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
74: ledger_id ZX_LINES.LEDGER_ID%TYPE,
75: legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
76: establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
77: currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
78: currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
79: currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
72: tax_rate_name_before_exception ZX_LINES.TAX_RATE_NAME_BEFORE_EXCEPTION%TYPE,
73: exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
74: ledger_id ZX_LINES.LEDGER_ID%TYPE,
75: legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
76: establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
77: currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
78: currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
79: currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
80: record_type_code ZX_LINES.RECORD_TYPE_CODE%TYPE
73: exception_rate ZX_LINES.EXCEPTION_RATE%TYPE,
74: ledger_id ZX_LINES.LEDGER_ID%TYPE,
75: legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
76: establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
77: currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
78: currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
79: currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
80: record_type_code ZX_LINES.RECORD_TYPE_CODE%TYPE
81: );
74: ledger_id ZX_LINES.LEDGER_ID%TYPE,
75: legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
76: establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
77: currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
78: currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
79: currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
80: record_type_code ZX_LINES.RECORD_TYPE_CODE%TYPE
81: );
82:
75: legal_entity_id ZX_LINES.LEGAL_ENTITY_ID%TYPE,
76: establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
77: currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
78: currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
79: currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
80: record_type_code ZX_LINES.RECORD_TYPE_CODE%TYPE
81: );
82:
83: TYPE header_rounding_info_rec IS RECORD
76: establishment_id ZX_LINES.ESTABLISHMENT_ID%TYPE,
77: currency_conversion_date ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE,
78: currency_conversion_type ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
79: currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
80: record_type_code ZX_LINES.RECORD_TYPE_CODE%TYPE
81: );
82:
83: TYPE header_rounding_info_rec IS RECORD
84: (
81: );
82:
83: TYPE header_rounding_info_rec IS RECORD
84: (
85: tax_line_id ZX_LINES.TAX_LINE_ID%TYPE,
86: tax_id ZX_LINES.TAX_ID%TYPE,
87: Rounding_Rule_Code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE,
88: min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
89: precision ZX_TAXES_B.TAX_PRECISION%TYPE,
82:
83: TYPE header_rounding_info_rec IS RECORD
84: (
85: tax_line_id ZX_LINES.TAX_LINE_ID%TYPE,
86: tax_id ZX_LINES.TAX_ID%TYPE,
87: Rounding_Rule_Code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE,
88: min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE,
89: precision ZX_TAXES_B.TAX_PRECISION%TYPE,
90: sum_unrnd_tax_amt NUMBER,
92: sum_rnd_tax_curr NUMBER,
93: sum_rnd_funcl_curr NUMBER,
94: max_unrnd_tax_amt NUMBER,
95: total_rec_in_grp NUMBER,
96: tax_curr_conv_rate ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
97: currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
98: rnd_tax_amt NUMBER,
99: rnd_tax_amt_tax_curr NUMBER,
100: rnd_tax_amt_funcl_curr NUMBER,
93: sum_rnd_funcl_curr NUMBER,
94: max_unrnd_tax_amt NUMBER,
95: total_rec_in_grp NUMBER,
96: tax_curr_conv_rate ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
97: currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
98: rnd_tax_amt NUMBER,
99: rnd_tax_amt_tax_curr NUMBER,
100: rnd_tax_amt_funcl_curr NUMBER,
101: rnd_taxable_amt_tax_curr NUMBER,
99: rnd_tax_amt_tax_curr NUMBER,
100: rnd_tax_amt_funcl_curr NUMBER,
101: rnd_taxable_amt_tax_curr NUMBER,
102: rnd_taxable_amt_funcl_curr NUMBER,
103: tax_calculation_formula ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
104: ledger_id ZX_LINES.LEDGER_ID%TYPE,
105: tax_rate ZX_LINES.TAX_RATE%TYPE,
106: mrc_tax_line_flag zx_lines.mrc_tax_line_flag%TYPE
107: );
100: rnd_tax_amt_funcl_curr NUMBER,
101: rnd_taxable_amt_tax_curr NUMBER,
102: rnd_taxable_amt_funcl_curr NUMBER,
103: tax_calculation_formula ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
104: ledger_id ZX_LINES.LEDGER_ID%TYPE,
105: tax_rate ZX_LINES.TAX_RATE%TYPE,
106: mrc_tax_line_flag zx_lines.mrc_tax_line_flag%TYPE
107: );
108:
101: rnd_taxable_amt_tax_curr NUMBER,
102: rnd_taxable_amt_funcl_curr NUMBER,
103: tax_calculation_formula ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
104: ledger_id ZX_LINES.LEDGER_ID%TYPE,
105: tax_rate ZX_LINES.TAX_RATE%TYPE,
106: mrc_tax_line_flag zx_lines.mrc_tax_line_flag%TYPE
107: );
108:
109: TYPE hdr_rounding_info_tbl IS TABLE OF header_rounding_info_rec
102: rnd_taxable_amt_funcl_curr NUMBER,
103: tax_calculation_formula ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
104: ledger_id ZX_LINES.LEDGER_ID%TYPE,
105: tax_rate ZX_LINES.TAX_RATE%TYPE,
106: mrc_tax_line_flag zx_lines.mrc_tax_line_flag%TYPE
107: );
108:
109: TYPE hdr_rounding_info_tbl IS TABLE OF header_rounding_info_rec
110: INDEX BY BINARY_INTEGER;
110: INDEX BY BINARY_INTEGER;
111:
112: TYPE header_rounding_curr_rec IS RECORD
113: (
114: tax_line_id ZX_LINES.TAX_LINE_ID%TYPE,
115: sum_unrnd_tax_amt NUMBER,
116: sum_rnd_curr NUMBER,
117: max_unrnd_tax_amt NUMBER,
118: total_rec_in_grp NUMBER,
115: sum_unrnd_tax_amt NUMBER,
116: sum_rnd_curr NUMBER,
117: max_unrnd_tax_amt NUMBER,
118: total_rec_in_grp NUMBER,
119: currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
120: rnd_tax_amt_curr NUMBER,
121: rnd_taxable_amt_curr NUMBER,
122: tax_calculation_formula ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
123: ledger_id ZX_LINES.LEDGER_ID%TYPE,
118: total_rec_in_grp NUMBER,
119: currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
120: rnd_tax_amt_curr NUMBER,
121: rnd_taxable_amt_curr NUMBER,
122: tax_calculation_formula ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
123: ledger_id ZX_LINES.LEDGER_ID%TYPE,
124: tax_rate ZX_LINES.TAX_RATE%TYPE
125: );
126:
119: currency_conversion_rate ZX_LINES.CURRENCY_CONVERSION_RATE%TYPE,
120: rnd_tax_amt_curr NUMBER,
121: rnd_taxable_amt_curr NUMBER,
122: tax_calculation_formula ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
123: ledger_id ZX_LINES.LEDGER_ID%TYPE,
124: tax_rate ZX_LINES.TAX_RATE%TYPE
125: );
126:
127: TYPE hdr_rounding_curr_tbl IS TABLE OF header_rounding_curr_rec
120: rnd_tax_amt_curr NUMBER,
121: rnd_taxable_amt_curr NUMBER,
122: tax_calculation_formula ZX_LINES.TAX_CALCULATION_FORMULA%TYPE,
123: ledger_id ZX_LINES.LEDGER_ID%TYPE,
124: tax_rate ZX_LINES.TAX_RATE%TYPE
125: );
126:
127: TYPE hdr_rounding_curr_tbl IS TABLE OF header_rounding_curr_rec
128: INDEX BY BINARY_INTEGER;
127: TYPE hdr_rounding_curr_tbl IS TABLE OF header_rounding_curr_rec
128: INDEX BY BINARY_INTEGER;
129:
130: TYPE tax_line_id_tbl IS TABLE OF
131: ZX_LINES.tax_line_id%TYPE
132: INDEX BY BINARY_INTEGER;
133:
134: TYPE manually_entered_flag_tbl IS TABLE OF
135: ZX_LINES.Manually_Entered_Flag%TYPE
131: ZX_LINES.tax_line_id%TYPE
132: INDEX BY BINARY_INTEGER;
133:
134: TYPE manually_entered_flag_tbl IS TABLE OF
135: ZX_LINES.Manually_Entered_Flag%TYPE
136: INDEX BY BINARY_INTEGER;
137:
138: TYPE tax_id_tbl IS TABLE OF
139: ZX_LINES.tax_id%TYPE
135: ZX_LINES.Manually_Entered_Flag%TYPE
136: INDEX BY BINARY_INTEGER;
137:
138: TYPE tax_id_tbl IS TABLE OF
139: ZX_LINES.tax_id%TYPE
140: INDEX BY BINARY_INTEGER;
141:
142: TYPE tax_regime_code_tbl IS TABLE OF
143: ZX_LINES.tax_regime_code%TYPE
139: ZX_LINES.tax_id%TYPE
140: INDEX BY BINARY_INTEGER;
141:
142: TYPE tax_regime_code_tbl IS TABLE OF
143: ZX_LINES.tax_regime_code%TYPE
144: INDEX BY BINARY_INTEGER;
145:
146: TYPE tax_tbl IS TABLE OF
147: ZX_LINES.tax%TYPE
143: ZX_LINES.tax_regime_code%TYPE
144: INDEX BY BINARY_INTEGER;
145:
146: TYPE tax_tbl IS TABLE OF
147: ZX_LINES.tax%TYPE
148: INDEX BY BINARY_INTEGER;
149:
150: TYPE tax_status_code_tbl IS TABLE OF
151: ZX_LINES.tax_status_code%TYPE
147: ZX_LINES.tax%TYPE
148: INDEX BY BINARY_INTEGER;
149:
150: TYPE tax_status_code_tbl IS TABLE OF
151: ZX_LINES.tax_status_code%TYPE
152: INDEX BY BINARY_INTEGER;
153:
154: TYPE tax_rate_code_tbl IS TABLE OF
155: ZX_LINES.tax_rate_code%TYPE
151: ZX_LINES.tax_status_code%TYPE
152: INDEX BY BINARY_INTEGER;
153:
154: TYPE tax_rate_code_tbl IS TABLE OF
155: ZX_LINES.tax_rate_code%TYPE
156: INDEX BY BINARY_INTEGER;
157:
158: TYPE tax_rate_tbl IS TABLE OF
159: ZX_LINES.tax_rate%TYPE
155: ZX_LINES.tax_rate_code%TYPE
156: INDEX BY BINARY_INTEGER;
157:
158: TYPE tax_rate_tbl IS TABLE OF
159: ZX_LINES.tax_rate%TYPE
160: INDEX BY BINARY_INTEGER;
161:
162: TYPE tax_rate_id_tbl IS TABLE OF
163: ZX_LINES.tax_rate_id%TYPE
159: ZX_LINES.tax_rate%TYPE
160: INDEX BY BINARY_INTEGER;
161:
162: TYPE tax_rate_id_tbl IS TABLE OF
163: ZX_LINES.tax_rate_id%TYPE
164: INDEX BY BINARY_INTEGER;
165:
166: TYPE tax_jurisdiction_code_tbl IS TABLE OF
167: ZX_LINES.tax_jurisdiction_code%TYPE
163: ZX_LINES.tax_rate_id%TYPE
164: INDEX BY BINARY_INTEGER;
165:
166: TYPE tax_jurisdiction_code_tbl IS TABLE OF
167: ZX_LINES.tax_jurisdiction_code%TYPE
168: INDEX BY BINARY_INTEGER;
169:
170: TYPE taxable_basis_formula_tbl IS TABLE OF
171: ZX_LINES.taxable_basis_formula%TYPE
167: ZX_LINES.tax_jurisdiction_code%TYPE
168: INDEX BY BINARY_INTEGER;
169:
170: TYPE taxable_basis_formula_tbl IS TABLE OF
171: ZX_LINES.taxable_basis_formula%TYPE
172: INDEX BY BINARY_INTEGER;
173:
174: TYPE tax_calculation_formula_tbl IS TABLE OF
175: ZX_LINES.tax_calculation_formula%TYPE
171: ZX_LINES.taxable_basis_formula%TYPE
172: INDEX BY BINARY_INTEGER;
173:
174: TYPE tax_calculation_formula_tbl IS TABLE OF
175: ZX_LINES.tax_calculation_formula%TYPE
176: INDEX BY BINARY_INTEGER;
177:
178: TYPE tax_amt_included_flag_tbl IS TABLE OF
179: ZX_LINES.Tax_Amt_Included_Flag%TYPE
175: ZX_LINES.tax_calculation_formula%TYPE
176: INDEX BY BINARY_INTEGER;
177:
178: TYPE tax_amt_included_flag_tbl IS TABLE OF
179: ZX_LINES.Tax_Amt_Included_Flag%TYPE
180: INDEX BY BINARY_INTEGER;
181:
182: TYPE compounding_tax_flag_tbl IS TABLE OF
183: ZX_LINES.compounding_tax_flag%TYPE
179: ZX_LINES.Tax_Amt_Included_Flag%TYPE
180: INDEX BY BINARY_INTEGER;
181:
182: TYPE compounding_tax_flag_tbl IS TABLE OF
183: ZX_LINES.compounding_tax_flag%TYPE
184: INDEX BY BINARY_INTEGER;
185:
186: TYPE historical_flag_tbl IS TABLE OF
187: ZX_LINES.historical_flag%TYPE
183: ZX_LINES.compounding_tax_flag%TYPE
184: INDEX BY BINARY_INTEGER;
185:
186: TYPE historical_flag_tbl IS TABLE OF
187: ZX_LINES.historical_flag%TYPE
188: INDEX BY BINARY_INTEGER;
189:
190: TYPE self_assessed_flag_tbl IS TABLE OF
191: ZX_LINES.self_assessed_flag%TYPE
187: ZX_LINES.historical_flag%TYPE
188: INDEX BY BINARY_INTEGER;
189:
190: TYPE self_assessed_flag_tbl IS TABLE OF
191: ZX_LINES.self_assessed_flag%TYPE
192: INDEX BY BINARY_INTEGER;
193:
194: TYPE overridden_flag_tbl IS TABLE OF
195: ZX_LINES.overridden_flag%TYPE
191: ZX_LINES.self_assessed_flag%TYPE
192: INDEX BY BINARY_INTEGER;
193:
194: TYPE overridden_flag_tbl IS TABLE OF
195: ZX_LINES.overridden_flag%TYPE
196: INDEX BY BINARY_INTEGER;
197:
198: TYPE cop_from_other_doc_flag_tbl IS TABLE OF
199: ZX_LINES.copied_from_other_doc_flag%TYPE
195: ZX_LINES.overridden_flag%TYPE
196: INDEX BY BINARY_INTEGER;
197:
198: TYPE cop_from_other_doc_flag_tbl IS TABLE OF
199: ZX_LINES.copied_from_other_doc_flag%TYPE
200: INDEX BY BINARY_INTEGER;
201:
202: TYPE assoc_child_frozen_flag_tbl IS TABLE OF
203: ZX_LINES.associated_child_frozen_flag%TYPE
199: ZX_LINES.copied_from_other_doc_flag%TYPE
200: INDEX BY BINARY_INTEGER;
201:
202: TYPE assoc_child_frozen_flag_tbl IS TABLE OF
203: ZX_LINES.associated_child_frozen_flag%TYPE
204: INDEX BY BINARY_INTEGER;
205:
206: TYPE tax_only_line_flag_tbl IS TABLE OF
207: ZX_LINES.tax_only_line_flag%TYPE
203: ZX_LINES.associated_child_frozen_flag%TYPE
204: INDEX BY BINARY_INTEGER;
205:
206: TYPE tax_only_line_flag_tbl IS TABLE OF
207: ZX_LINES.tax_only_line_flag%TYPE
208: INDEX BY BINARY_INTEGER;
209:
210: TYPE mrc_tax_line_flag_tbl IS TABLE OF
211: ZX_LINES.mrc_tax_line_flag%TYPE
207: ZX_LINES.tax_only_line_flag%TYPE
208: INDEX BY BINARY_INTEGER;
209:
210: TYPE mrc_tax_line_flag_tbl IS TABLE OF
211: ZX_LINES.mrc_tax_line_flag%TYPE
212: INDEX BY BINARY_INTEGER;
213:
214: TYPE reporting_only_flag_tbl IS TABLE OF
215: ZX_LINES.reporting_only_flag%TYPE
211: ZX_LINES.mrc_tax_line_flag%TYPE
212: INDEX BY BINARY_INTEGER;
213:
214: TYPE reporting_only_flag_tbl IS TABLE OF
215: ZX_LINES.reporting_only_flag%TYPE
216: INDEX BY BINARY_INTEGER;
217:
218: TYPE applied_from_applic_id_tbl IS TABLE OF
219: ZX_LINES.applied_from_application_id%TYPE
215: ZX_LINES.reporting_only_flag%TYPE
216: INDEX BY BINARY_INTEGER;
217:
218: TYPE applied_from_applic_id_tbl IS TABLE OF
219: ZX_LINES.applied_from_application_id%TYPE
220: INDEX BY BINARY_INTEGER;
221:
222: TYPE applied_from_evnt_cls_cd_tbl IS TABLE OF
223: ZX_LINES.applied_from_event_class_code%TYPE
219: ZX_LINES.applied_from_application_id%TYPE
220: INDEX BY BINARY_INTEGER;
221:
222: TYPE applied_from_evnt_cls_cd_tbl IS TABLE OF
223: ZX_LINES.applied_from_event_class_code%TYPE
224: INDEX BY BINARY_INTEGER;
225:
226: TYPE applied_from_entity_code_tbl IS TABLE OF
227: ZX_LINES.applied_from_entity_code%TYPE
223: ZX_LINES.applied_from_event_class_code%TYPE
224: INDEX BY BINARY_INTEGER;
225:
226: TYPE applied_from_entity_code_tbl IS TABLE OF
227: ZX_LINES.applied_from_entity_code%TYPE
228: INDEX BY BINARY_INTEGER;
229:
230: TYPE applied_from_trx_id_tbl IS TABLE OF
231: ZX_LINES.applied_from_trx_id%TYPE
227: ZX_LINES.applied_from_entity_code%TYPE
228: INDEX BY BINARY_INTEGER;
229:
230: TYPE applied_from_trx_id_tbl IS TABLE OF
231: ZX_LINES.applied_from_trx_id%TYPE
232: INDEX BY BINARY_INTEGER;
233:
234: TYPE applied_from_line_id_tbl IS TABLE OF
235: ZX_LINES.applied_from_line_id%TYPE
231: ZX_LINES.applied_from_trx_id%TYPE
232: INDEX BY BINARY_INTEGER;
233:
234: TYPE applied_from_line_id_tbl IS TABLE OF
235: ZX_LINES.applied_from_line_id%TYPE
236: INDEX BY BINARY_INTEGER;
237:
238: TYPE adjusted_doc_applic_id_tbl IS TABLE OF
239: ZX_LINES.adjusted_doc_application_id%TYPE
235: ZX_LINES.applied_from_line_id%TYPE
236: INDEX BY BINARY_INTEGER;
237:
238: TYPE adjusted_doc_applic_id_tbl IS TABLE OF
239: ZX_LINES.adjusted_doc_application_id%TYPE
240: INDEX BY BINARY_INTEGER;
241:
242: TYPE adjusted_doc_entity_code_tbl IS TABLE OF
243: ZX_LINES.adjusted_doc_entity_code%TYPE
239: ZX_LINES.adjusted_doc_application_id%TYPE
240: INDEX BY BINARY_INTEGER;
241:
242: TYPE adjusted_doc_entity_code_tbl IS TABLE OF
243: ZX_LINES.adjusted_doc_entity_code%TYPE
244: INDEX BY BINARY_INTEGER;
245:
246: TYPE adjusted_doc_evnt_cls_cd_tbl IS TABLE OF
247: ZX_LINES.adjusted_doc_event_class_code%TYPE
243: ZX_LINES.adjusted_doc_entity_code%TYPE
244: INDEX BY BINARY_INTEGER;
245:
246: TYPE adjusted_doc_evnt_cls_cd_tbl IS TABLE OF
247: ZX_LINES.adjusted_doc_event_class_code%TYPE
248: INDEX BY BINARY_INTEGER;
249:
250: TYPE adjusted_doc_trx_id_tbl IS TABLE OF
251: ZX_LINES.adjusted_doc_trx_id%TYPE
247: ZX_LINES.adjusted_doc_event_class_code%TYPE
248: INDEX BY BINARY_INTEGER;
249:
250: TYPE adjusted_doc_trx_id_tbl IS TABLE OF
251: ZX_LINES.adjusted_doc_trx_id%TYPE
252: INDEX BY BINARY_INTEGER;
253:
254: TYPE applied_to_applic_id_tbl IS TABLE OF
255: ZX_LINES.applied_to_application_id%TYPE
251: ZX_LINES.adjusted_doc_trx_id%TYPE
252: INDEX BY BINARY_INTEGER;
253:
254: TYPE applied_to_applic_id_tbl IS TABLE OF
255: ZX_LINES.applied_to_application_id%TYPE
256: INDEX BY BINARY_INTEGER;
257:
258: TYPE applied_to_evnt_cls_cd_tbl IS TABLE OF
259: ZX_LINES.applied_to_event_class_code%TYPE
255: ZX_LINES.applied_to_application_id%TYPE
256: INDEX BY BINARY_INTEGER;
257:
258: TYPE applied_to_evnt_cls_cd_tbl IS TABLE OF
259: ZX_LINES.applied_to_event_class_code%TYPE
260: INDEX BY BINARY_INTEGER;
261:
262: TYPE applied_to_entity_code_tbl IS TABLE OF
263: ZX_LINES.applied_to_entity_code%TYPE
259: ZX_LINES.applied_to_event_class_code%TYPE
260: INDEX BY BINARY_INTEGER;
261:
262: TYPE applied_to_entity_code_tbl IS TABLE OF
263: ZX_LINES.applied_to_entity_code%TYPE
264: INDEX BY BINARY_INTEGER;
265:
266: TYPE applied_to_trx_id_tbl IS TABLE OF
267: ZX_LINES.applied_to_trx_id%TYPE
263: ZX_LINES.applied_to_entity_code%TYPE
264: INDEX BY BINARY_INTEGER;
265:
266: TYPE applied_to_trx_id_tbl IS TABLE OF
267: ZX_LINES.applied_to_trx_id%TYPE
268: INDEX BY BINARY_INTEGER;
269:
270: TYPE applied_to_line_id_tbl IS TABLE OF
271: ZX_LINES.applied_to_line_id%TYPE
267: ZX_LINES.applied_to_trx_id%TYPE
268: INDEX BY BINARY_INTEGER;
269:
270: TYPE applied_to_line_id_tbl IS TABLE OF
271: ZX_LINES.applied_to_line_id%TYPE
272: INDEX BY BINARY_INTEGER;
273:
274: TYPE tax_exemption_id_tbl IS TABLE OF
275: ZX_LINES.tax_exemption_id%TYPE
271: ZX_LINES.applied_to_line_id%TYPE
272: INDEX BY BINARY_INTEGER;
273:
274: TYPE tax_exemption_id_tbl IS TABLE OF
275: ZX_LINES.tax_exemption_id%TYPE
276: INDEX BY BINARY_INTEGER;
277:
278: TYPE rate_before_exemption_tbl IS TABLE OF
279: ZX_LINES.tax_rate_before_exemption%TYPE
275: ZX_LINES.tax_exemption_id%TYPE
276: INDEX BY BINARY_INTEGER;
277:
278: TYPE rate_before_exemption_tbl IS TABLE OF
279: ZX_LINES.tax_rate_before_exemption%TYPE
280: INDEX BY BINARY_INTEGER;
281:
282: TYPE rate_name_before_exemption_tbl IS TABLE OF
283: ZX_LINES.tax_rate_name_before_exemption%TYPE
279: ZX_LINES.tax_rate_before_exemption%TYPE
280: INDEX BY BINARY_INTEGER;
281:
282: TYPE rate_name_before_exemption_tbl IS TABLE OF
283: ZX_LINES.tax_rate_name_before_exemption%TYPE
284: INDEX BY BINARY_INTEGER;
285:
286: TYPE exempt_rate_modifier_tbl IS TABLE OF
287: ZX_LINES.exempt_rate_modifier%TYPE
283: ZX_LINES.tax_rate_name_before_exemption%TYPE
284: INDEX BY BINARY_INTEGER;
285:
286: TYPE exempt_rate_modifier_tbl IS TABLE OF
287: ZX_LINES.exempt_rate_modifier%TYPE
288: INDEX BY BINARY_INTEGER;
289:
290: TYPE exempt_certificate_num_tbl IS TABLE OF
291: ZX_LINES.exempt_certificate_number%TYPE
287: ZX_LINES.exempt_rate_modifier%TYPE
288: INDEX BY BINARY_INTEGER;
289:
290: TYPE exempt_certificate_num_tbl IS TABLE OF
291: ZX_LINES.exempt_certificate_number%TYPE
292: INDEX BY BINARY_INTEGER;
293:
294: TYPE exempt_reason_tbl IS TABLE OF
295: ZX_LINES.exempt_reason%TYPE
291: ZX_LINES.exempt_certificate_number%TYPE
292: INDEX BY BINARY_INTEGER;
293:
294: TYPE exempt_reason_tbl IS TABLE OF
295: ZX_LINES.exempt_reason%TYPE
296: INDEX BY BINARY_INTEGER;
297:
298: TYPE exempt_reason_code_tbl IS TABLE OF
299: ZX_LINES.exempt_reason_code%TYPE
295: ZX_LINES.exempt_reason%TYPE
296: INDEX BY BINARY_INTEGER;
297:
298: TYPE exempt_reason_code_tbl IS TABLE OF
299: ZX_LINES.exempt_reason_code%TYPE
300: INDEX BY BINARY_INTEGER;
301:
302: TYPE tax_exception_id_tbl IS TABLE OF
303: ZX_LINES.tax_exception_id%TYPE
299: ZX_LINES.exempt_reason_code%TYPE
300: INDEX BY BINARY_INTEGER;
301:
302: TYPE tax_exception_id_tbl IS TABLE OF
303: ZX_LINES.tax_exception_id%TYPE
304: INDEX BY BINARY_INTEGER;
305:
306: TYPE rate_before_exception_tbl IS TABLE OF
307: ZX_LINES.tax_rate_before_exception%TYPE
303: ZX_LINES.tax_exception_id%TYPE
304: INDEX BY BINARY_INTEGER;
305:
306: TYPE rate_before_exception_tbl IS TABLE OF
307: ZX_LINES.tax_rate_before_exception%TYPE
308: INDEX BY BINARY_INTEGER;
309:
310: TYPE rate_name_before_exception_tbl IS TABLE OF
311: ZX_LINES.tax_rate_name_before_exception%TYPE
307: ZX_LINES.tax_rate_before_exception%TYPE
308: INDEX BY BINARY_INTEGER;
309:
310: TYPE rate_name_before_exception_tbl IS TABLE OF
311: ZX_LINES.tax_rate_name_before_exception%TYPE
312: INDEX BY BINARY_INTEGER;
313:
314: TYPE exception_rate_tbl IS TABLE OF
315: ZX_LINES.exception_rate%TYPE
311: ZX_LINES.tax_rate_name_before_exception%TYPE
312: INDEX BY BINARY_INTEGER;
313:
314: TYPE exception_rate_tbl IS TABLE OF
315: ZX_LINES.exception_rate%TYPE
316: INDEX BY BINARY_INTEGER;
317:
318: TYPE min_acct_unit_tbl IS TABLE OF
319: ZX_LINES.minimum_accountable_unit%TYPE
315: ZX_LINES.exception_rate%TYPE
316: INDEX BY BINARY_INTEGER;
317:
318: TYPE min_acct_unit_tbl IS TABLE OF
319: ZX_LINES.minimum_accountable_unit%TYPE
320: INDEX BY BINARY_INTEGER;
321:
322: TYPE precision_tbl IS TABLE OF
323: ZX_LINES.precision%TYPE
319: ZX_LINES.minimum_accountable_unit%TYPE
320: INDEX BY BINARY_INTEGER;
321:
322: TYPE precision_tbl IS TABLE OF
323: ZX_LINES.precision%TYPE
324: INDEX BY BINARY_INTEGER;
325:
326: TYPE trx_currency_code_tbl IS TABLE OF
327: ZX_LINES.trx_currency_code%TYPE
323: ZX_LINES.precision%TYPE
324: INDEX BY BINARY_INTEGER;
325:
326: TYPE trx_currency_code_tbl IS TABLE OF
327: ZX_LINES.trx_currency_code%TYPE
328: INDEX BY BINARY_INTEGER;
329:
330: TYPE tax_currency_code_tbl IS TABLE OF
331: ZX_LINES.tax_currency_code%TYPE
327: ZX_LINES.trx_currency_code%TYPE
328: INDEX BY BINARY_INTEGER;
329:
330: TYPE tax_currency_code_tbl IS TABLE OF
331: ZX_LINES.tax_currency_code%TYPE
332: INDEX BY BINARY_INTEGER;
333:
334: TYPE tax_curr_conv_date_tbl IS TABLE OF
335: ZX_LINES.tax_currency_conversion_date%TYPE
331: ZX_LINES.tax_currency_code%TYPE
332: INDEX BY BINARY_INTEGER;
333:
334: TYPE tax_curr_conv_date_tbl IS TABLE OF
335: ZX_LINES.tax_currency_conversion_date%TYPE
336: INDEX BY BINARY_INTEGER;
337:
338: TYPE tax_curr_conv_type_tbl IS TABLE OF
339: ZX_LINES.tax_currency_conversion_type%TYPE
335: ZX_LINES.tax_currency_conversion_date%TYPE
336: INDEX BY BINARY_INTEGER;
337:
338: TYPE tax_curr_conv_type_tbl IS TABLE OF
339: ZX_LINES.tax_currency_conversion_type%TYPE
340: INDEX BY BINARY_INTEGER;
341:
342: TYPE tax_curr_conv_rate_tbl IS TABLE OF
343: ZX_LINES.tax_currency_conversion_rate%TYPE
339: ZX_LINES.tax_currency_conversion_type%TYPE
340: INDEX BY BINARY_INTEGER;
341:
342: TYPE tax_curr_conv_rate_tbl IS TABLE OF
343: ZX_LINES.tax_currency_conversion_rate%TYPE
344: INDEX BY BINARY_INTEGER;
345:
346: TYPE tax_amt_tbl IS TABLE OF
347: ZX_LINES.tax_amt%TYPE
343: ZX_LINES.tax_currency_conversion_rate%TYPE
344: INDEX BY BINARY_INTEGER;
345:
346: TYPE tax_amt_tbl IS TABLE OF
347: ZX_LINES.tax_amt%TYPE
348: INDEX BY BINARY_INTEGER;
349:
350: TYPE taxable_amt_tbl IS TABLE OF
351: ZX_LINES.taxable_amt%TYPE
347: ZX_LINES.tax_amt%TYPE
348: INDEX BY BINARY_INTEGER;
349:
350: TYPE taxable_amt_tbl IS TABLE OF
351: ZX_LINES.taxable_amt%TYPE
352: INDEX BY BINARY_INTEGER;
353:
354: TYPE cal_tax_amt_tbl IS TABLE OF
355: ZX_LINES.cal_tax_amt%TYPE
351: ZX_LINES.taxable_amt%TYPE
352: INDEX BY BINARY_INTEGER;
353:
354: TYPE cal_tax_amt_tbl IS TABLE OF
355: ZX_LINES.cal_tax_amt%TYPE
356: INDEX BY BINARY_INTEGER;
357:
358: TYPE tax_amt_tax_curr_tbl IS TABLE OF
359: ZX_LINES.tax_amt_tax_curr%TYPE
355: ZX_LINES.cal_tax_amt%TYPE
356: INDEX BY BINARY_INTEGER;
357:
358: TYPE tax_amt_tax_curr_tbl IS TABLE OF
359: ZX_LINES.tax_amt_tax_curr%TYPE
360: INDEX BY BINARY_INTEGER;
361:
362: TYPE taxable_amt_tax_curr_tbl IS TABLE OF
363: ZX_LINES.taxable_amt_tax_curr%TYPE
359: ZX_LINES.tax_amt_tax_curr%TYPE
360: INDEX BY BINARY_INTEGER;
361:
362: TYPE taxable_amt_tax_curr_tbl IS TABLE OF
363: ZX_LINES.taxable_amt_tax_curr%TYPE
364: INDEX BY BINARY_INTEGER;
365:
366: TYPE cal_tax_amt_tax_curr_tbl IS TABLE OF
367: ZX_LINES.cal_tax_amt_tax_curr%TYPE
363: ZX_LINES.taxable_amt_tax_curr%TYPE
364: INDEX BY BINARY_INTEGER;
365:
366: TYPE cal_tax_amt_tax_curr_tbl IS TABLE OF
367: ZX_LINES.cal_tax_amt_tax_curr%TYPE
368: INDEX BY BINARY_INTEGER;
369:
370: TYPE rounding_rule_tbl IS TABLE OF
371: ZX_LINES.Rounding_Rule_Code%TYPE
367: ZX_LINES.cal_tax_amt_tax_curr%TYPE
368: INDEX BY BINARY_INTEGER;
369:
370: TYPE rounding_rule_tbl IS TABLE OF
371: ZX_LINES.Rounding_Rule_Code%TYPE
372: INDEX BY BINARY_INTEGER;
373:
374: TYPE unrounded_taxable_amt_tbl IS TABLE OF
375: ZX_LINES.unrounded_taxable_amt%TYPE
371: ZX_LINES.Rounding_Rule_Code%TYPE
372: INDEX BY BINARY_INTEGER;
373:
374: TYPE unrounded_taxable_amt_tbl IS TABLE OF
375: ZX_LINES.unrounded_taxable_amt%TYPE
376: INDEX BY BINARY_INTEGER;
377:
378: TYPE unrounded_tax_amt_tbl IS TABLE OF
379: ZX_LINES.unrounded_tax_amt%TYPE
375: ZX_LINES.unrounded_taxable_amt%TYPE
376: INDEX BY BINARY_INTEGER;
377:
378: TYPE unrounded_tax_amt_tbl IS TABLE OF
379: ZX_LINES.unrounded_tax_amt%TYPE
380: INDEX BY BINARY_INTEGER;
381:
382: TYPE currency_conversion_type_tbl IS TABLE OF
383: ZX_LINES.currency_conversion_type%TYPE
379: ZX_LINES.unrounded_tax_amt%TYPE
380: INDEX BY BINARY_INTEGER;
381:
382: TYPE currency_conversion_type_tbl IS TABLE OF
383: ZX_LINES.currency_conversion_type%TYPE
384: INDEX BY BINARY_INTEGER;
385:
386: TYPE currency_conversion_rate_tbl IS TABLE OF
387: ZX_LINES.currency_conversion_rate%TYPE
383: ZX_LINES.currency_conversion_type%TYPE
384: INDEX BY BINARY_INTEGER;
385:
386: TYPE currency_conversion_rate_tbl IS TABLE OF
387: ZX_LINES.currency_conversion_rate%TYPE
388: INDEX BY BINARY_INTEGER;
389:
390: TYPE currency_conversion_date_tbl IS TABLE OF
391: ZX_LINES.currency_conversion_date%TYPE
387: ZX_LINES.currency_conversion_rate%TYPE
388: INDEX BY BINARY_INTEGER;
389:
390: TYPE currency_conversion_date_tbl IS TABLE OF
391: ZX_LINES.currency_conversion_date%TYPE
392: INDEX BY BINARY_INTEGER;
393:
394: TYPE tax_amt_funcl_curr_tbl IS TABLE OF
395: ZX_LINES.tax_amt_funcl_curr%TYPE
391: ZX_LINES.currency_conversion_date%TYPE
392: INDEX BY BINARY_INTEGER;
393:
394: TYPE tax_amt_funcl_curr_tbl IS TABLE OF
395: ZX_LINES.tax_amt_funcl_curr%TYPE
396: INDEX BY BINARY_INTEGER;
397:
398: TYPE taxable_amt_funcl_curr_tbl IS TABLE OF
399: ZX_LINES.taxable_amt_funcl_curr%TYPE
395: ZX_LINES.tax_amt_funcl_curr%TYPE
396: INDEX BY BINARY_INTEGER;
397:
398: TYPE taxable_amt_funcl_curr_tbl IS TABLE OF
399: ZX_LINES.taxable_amt_funcl_curr%TYPE
400: INDEX BY BINARY_INTEGER;
401:
402: TYPE cal_tax_amt_funcl_curr_tbl IS TABLE OF
403: ZX_LINES.cal_tax_amt_funcl_curr%TYPE
399: ZX_LINES.taxable_amt_funcl_curr%TYPE
400: INDEX BY BINARY_INTEGER;
401:
402: TYPE cal_tax_amt_funcl_curr_tbl IS TABLE OF
403: ZX_LINES.cal_tax_amt_funcl_curr%TYPE
404: INDEX BY BINARY_INTEGER;
405:
406: TYPE rounding_level_tbl IS TABLE OF
407: ZX_LINES.Rounding_Level_Code%TYPE
403: ZX_LINES.cal_tax_amt_funcl_curr%TYPE
404: INDEX BY BINARY_INTEGER;
405:
406: TYPE rounding_level_tbl IS TABLE OF
407: ZX_LINES.Rounding_Level_Code%TYPE
408: INDEX BY BINARY_INTEGER;
409:
410: TYPE ledger_id_tbl IS TABLE OF
411: ZX_LINES.ledger_id%TYPE
407: ZX_LINES.Rounding_Level_Code%TYPE
408: INDEX BY BINARY_INTEGER;
409:
410: TYPE ledger_id_tbl IS TABLE OF
411: ZX_LINES.ledger_id%TYPE
412: INDEX BY BINARY_INTEGER;
413:
414: TYPE prd_total_tax_amt_tbl IS TABLE OF
415: ZX_LINES.prd_total_tax_amt%TYPE
411: ZX_LINES.ledger_id%TYPE
412: INDEX BY BINARY_INTEGER;
413:
414: TYPE prd_total_tax_amt_tbl IS TABLE OF
415: ZX_LINES.prd_total_tax_amt%TYPE
416: INDEX BY BINARY_INTEGER;
417:
418: TYPE prd_total_tax_amt_tax_curr_tbl IS TABLE OF
419: ZX_LINES.prd_total_tax_amt_tax_curr%TYPE
415: ZX_LINES.prd_total_tax_amt%TYPE
416: INDEX BY BINARY_INTEGER;
417:
418: TYPE prd_total_tax_amt_tax_curr_tbl IS TABLE OF
419: ZX_LINES.prd_total_tax_amt_tax_curr%TYPE
420: INDEX BY BINARY_INTEGER;
421:
422: TYPE prd_total_tax_amt_fcl_curr_tbl IS TABLE OF
423: ZX_LINES.prd_total_tax_amt_funcl_curr%TYPE
419: ZX_LINES.prd_total_tax_amt_tax_curr%TYPE
420: INDEX BY BINARY_INTEGER;
421:
422: TYPE prd_total_tax_amt_fcl_curr_tbl IS TABLE OF
423: ZX_LINES.prd_total_tax_amt_funcl_curr%TYPE
424: INDEX BY BINARY_INTEGER;
425:
426: TYPE legal_entity_id_tbl IS TABLE OF
427: ZX_LINES.legal_entity_id%TYPE
423: ZX_LINES.prd_total_tax_amt_funcl_curr%TYPE
424: INDEX BY BINARY_INTEGER;
425:
426: TYPE legal_entity_id_tbl IS TABLE OF
427: ZX_LINES.legal_entity_id%TYPE
428: INDEX BY BINARY_INTEGER;
429:
430: TYPE establishment_id_tbl IS TABLE OF
431: ZX_LINES.establishment_id%TYPE
427: ZX_LINES.legal_entity_id%TYPE
428: INDEX BY BINARY_INTEGER;
429:
430: TYPE establishment_id_tbl IS TABLE OF
431: ZX_LINES.establishment_id%TYPE
432: INDEX BY BINARY_INTEGER;
433:
434: TYPE record_type_code_tbl IS TABLE OF
435: ZX_LINES.record_type_code%TYPE
431: ZX_LINES.establishment_id%TYPE
432: INDEX BY BINARY_INTEGER;
433:
434: TYPE record_type_code_tbl IS TABLE OF
435: ZX_LINES.record_type_code%TYPE
436: INDEX BY BINARY_INTEGER;
437:
438: TYPE tax_provider_id_tbl IS TABLE OF
439: ZX_LINES.tax_provider_id%TYPE
435: ZX_LINES.record_type_code%TYPE
436: INDEX BY BINARY_INTEGER;
437:
438: TYPE tax_provider_id_tbl IS TABLE OF
439: ZX_LINES.tax_provider_id%TYPE
440: INDEX BY BINARY_INTEGER;
441:
442: TYPE application_id_tbl IS TABLE OF
443: ZX_LINES.application_id%TYPE
439: ZX_LINES.tax_provider_id%TYPE
440: INDEX BY BINARY_INTEGER;
441:
442: TYPE application_id_tbl IS TABLE OF
443: ZX_LINES.application_id%TYPE
444: INDEX BY BINARY_INTEGER;
445:
446: TYPE INTERNAL_ORGANIZATION_ID_TBL IS TABLE OF
447: ZX_LINES.internal_organization_id%TYPE
443: ZX_LINES.application_id%TYPE
444: INDEX BY BINARY_INTEGER;
445:
446: TYPE INTERNAL_ORGANIZATION_ID_TBL IS TABLE OF
447: ZX_LINES.internal_organization_id%TYPE
448: INDEX BY BINARY_INTEGER;
449:
450: TYPE event_class_code_tbl IS TABLE OF
451: ZX_LINES.event_class_code%TYPE
447: ZX_LINES.internal_organization_id%TYPE
448: INDEX BY BINARY_INTEGER;
449:
450: TYPE event_class_code_tbl IS TABLE OF
451: ZX_LINES.event_class_code%TYPE
452: INDEX BY BINARY_INTEGER;
453:
454: TYPE entity_code_tbl IS TABLE OF
455: ZX_LINES.entity_code%TYPE
451: ZX_LINES.event_class_code%TYPE
452: INDEX BY BINARY_INTEGER;
453:
454: TYPE entity_code_tbl IS TABLE OF
455: ZX_LINES.entity_code%TYPE
456: INDEX BY BINARY_INTEGER;
457:
458: TYPE trx_id_tbl IS TABLE OF
459: ZX_LINES.trx_id%TYPE
455: ZX_LINES.entity_code%TYPE
456: INDEX BY BINARY_INTEGER;
457:
458: TYPE trx_id_tbl IS TABLE OF
459: ZX_LINES.trx_id%TYPE
460: INDEX BY BINARY_INTEGER;
461:
462: TYPE rounding_level_code_tbl IS TABLE OF
463: ZX_LINES.rounding_level_code%TYPE
459: ZX_LINES.trx_id%TYPE
460: INDEX BY BINARY_INTEGER;
461:
462: TYPE rounding_level_code_tbl IS TABLE OF
463: ZX_LINES.rounding_level_code%TYPE
464: INDEX BY BINARY_INTEGER;
465:
466: g_currency_tbl currency_conversion_tbl;
467: g_tax_curr_conv_rate_tbl tax_curr_conversion_rate_tbl;
478: p_error_buffer OUT NOCOPY VARCHAR2
479: ) RETURN NUMBER;
480:
481: FUNCTION round_tax_funcl_curr(
482: p_unround_amt IN ZX_LINES.TAX_AMT%TYPE,
483: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
484: p_return_status OUT NOCOPY VARCHAR2,
485: p_error_buffer OUT NOCOPY VARCHAR2
486: ) RETURN NUMBER;
479: ) RETURN NUMBER;
480:
481: FUNCTION round_tax_funcl_curr(
482: p_unround_amt IN ZX_LINES.TAX_AMT%TYPE,
483: p_ledger_id IN ZX_LINES.LEDGER_ID%TYPE,
484: p_return_status OUT NOCOPY VARCHAR2,
485: p_error_buffer OUT NOCOPY VARCHAR2
486: ) RETURN NUMBER;
487:
485: p_error_buffer OUT NOCOPY VARCHAR2
486: ) RETURN NUMBER;
487:
488: PROCEDURE convert_to_currency(
489: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
490: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
491: p_conversion_date IN ZX_LINES.tax_currency_conversion_date%TYPE,
492: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
493: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
486: ) RETURN NUMBER;
487:
488: PROCEDURE convert_to_currency(
489: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
490: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
491: p_conversion_date IN ZX_LINES.tax_currency_conversion_date%TYPE,
492: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
493: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
494: p_to_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
487:
488: PROCEDURE convert_to_currency(
489: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
490: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
491: p_conversion_date IN ZX_LINES.tax_currency_conversion_date%TYPE,
492: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
493: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
494: p_to_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
495: p_from_amt IN ZX_LINES.TAX_AMT%TYPE,
488: PROCEDURE convert_to_currency(
489: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
490: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
491: p_conversion_date IN ZX_LINES.tax_currency_conversion_date%TYPE,
492: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
493: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
494: p_to_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
495: p_from_amt IN ZX_LINES.TAX_AMT%TYPE,
496: p_to_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
489: p_from_currency IN ZX_LINES.TRX_CURRENCY_CODE%TYPE,
490: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
491: p_conversion_date IN ZX_LINES.tax_currency_conversion_date%TYPE,
492: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
493: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
494: p_to_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
495: p_from_amt IN ZX_LINES.TAX_AMT%TYPE,
496: p_to_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
497: p_return_status OUT NOCOPY VARCHAR2,
490: p_to_currency IN ZX_LINES.TAX_CURRENCY_CODE%TYPE,
491: p_conversion_date IN ZX_LINES.tax_currency_conversion_date%TYPE,
492: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
493: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
494: p_to_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
495: p_from_amt IN ZX_LINES.TAX_AMT%TYPE,
496: p_to_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
497: p_return_status OUT NOCOPY VARCHAR2,
498: p_error_buffer OUT NOCOPY VARCHAR2,
491: p_conversion_date IN ZX_LINES.tax_currency_conversion_date%TYPE,
492: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
493: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
494: p_to_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
495: p_from_amt IN ZX_LINES.TAX_AMT%TYPE,
496: p_to_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
497: p_return_status OUT NOCOPY VARCHAR2,
498: p_error_buffer OUT NOCOPY VARCHAR2,
499: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL); --Bug7183884
492: p_tax_conversion_type IN ZX_LINES.TAX_CURRENCY_CONVERSION_TYPE%TYPE,
493: p_trx_conversion_type IN ZX_LINES.CURRENCY_CONVERSION_TYPE%TYPE,
494: p_to_curr_conv_rate IN OUT NOCOPY ZX_LINES.TAX_CURRENCY_CONVERSION_RATE%TYPE,
495: p_from_amt IN ZX_LINES.TAX_AMT%TYPE,
496: p_to_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
497: p_return_status OUT NOCOPY VARCHAR2,
498: p_error_buffer OUT NOCOPY VARCHAR2,
499: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL); --Bug7183884
500:
495: p_from_amt IN ZX_LINES.TAX_AMT%TYPE,
496: p_to_amt OUT NOCOPY ZX_LINES.TAX_AMT_TAX_CURR%TYPE,
497: p_return_status OUT NOCOPY VARCHAR2,
498: p_error_buffer OUT NOCOPY VARCHAR2,
499: p_trx_conversion_date IN ZX_LINES.CURRENCY_CONVERSION_DATE%TYPE DEFAULT NULL); --Bug7183884
500:
501: PROCEDURE get_rounding_level_and_rule(
502: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
503: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
502: p_event_class_rec IN ZX_API_PUB.EVENT_CLASS_REC_TYPE,
503: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
504: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
505: p_rnd_lvl_party_tax_prof_id
506: OUT NOCOPY ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID%TYPE,
507: p_rounding_lvl_party_type OUT NOCOPY ZX_LINES.ROUNDING_LVL_PARTY_TYPE%TYPE,
508: p_return_status OUT NOCOPY VARCHAR2,
509: p_error_buffer OUT NOCOPY VARCHAR2
510: );
503: p_rounding_level_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_LEVEL_CODE%TYPE,
504: p_rounding_rule_code OUT NOCOPY ZX_PARTY_TAX_PROFILE.ROUNDING_RULE_CODE%TYPE,
505: p_rnd_lvl_party_tax_prof_id
506: OUT NOCOPY ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID%TYPE,
507: p_rounding_lvl_party_type OUT NOCOPY ZX_LINES.ROUNDING_LVL_PARTY_TYPE%TYPE,
508: p_return_status OUT NOCOPY VARCHAR2,
509: p_error_buffer OUT NOCOPY VARCHAR2
510: );
511:
536: p_error_buffer OUT NOCOPY VARCHAR2
537: );
538:
539: PROCEDURE round_tax_amt_entered(
540: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
541: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
542: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
543: p_entity_code IN ZX_LINES.ENTITY_CODE%TYPE,
544: p_event_class_code IN ZX_LINES.EVENT_CLASS_CODE%TYPE,
538:
539: PROCEDURE round_tax_amt_entered(
540: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
541: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
542: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
543: p_entity_code IN ZX_LINES.ENTITY_CODE%TYPE,
544: p_event_class_code IN ZX_LINES.EVENT_CLASS_CODE%TYPE,
545: p_trx_id IN ZX_LINES.TRX_ID%TYPE,
546: p_return_status OUT NOCOPY VARCHAR2,
539: PROCEDURE round_tax_amt_entered(
540: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
541: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
542: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
543: p_entity_code IN ZX_LINES.ENTITY_CODE%TYPE,
544: p_event_class_code IN ZX_LINES.EVENT_CLASS_CODE%TYPE,
545: p_trx_id IN ZX_LINES.TRX_ID%TYPE,
546: p_return_status OUT NOCOPY VARCHAR2,
547: p_error_buffer OUT NOCOPY VARCHAR2
540: p_tax_amt IN OUT NOCOPY ZX_LINES.TAX_AMT%TYPE,
541: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
542: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
543: p_entity_code IN ZX_LINES.ENTITY_CODE%TYPE,
544: p_event_class_code IN ZX_LINES.EVENT_CLASS_CODE%TYPE,
545: p_trx_id IN ZX_LINES.TRX_ID%TYPE,
546: p_return_status OUT NOCOPY VARCHAR2,
547: p_error_buffer OUT NOCOPY VARCHAR2
548: );
541: p_tax_id IN ZX_TAXES_B.TAX_ID%TYPE,
542: p_application_id IN ZX_LINES.APPLICATION_ID%TYPE,
543: p_entity_code IN ZX_LINES.ENTITY_CODE%TYPE,
544: p_event_class_code IN ZX_LINES.EVENT_CLASS_CODE%TYPE,
545: p_trx_id IN ZX_LINES.TRX_ID%TYPE,
546: p_return_status OUT NOCOPY VARCHAR2,
547: p_error_buffer OUT NOCOPY VARCHAR2
548: );
549: