DBA Data[Home] [Help]

APPS.ZX_TDS_UTILITIES_PKG dependencies on ZX_RATES_B

Line 90: tax_regime_code zx_rates_b.tax_regime_code%TYPE,

86: -- Tax rate information
87: -- tax_jurisdiction_id is added for rate detemination requirement for multiple
88: -- jurisdictions case (bug 4534949)
89: TYPE zx_rate_info_rec_type IS RECORD (
90: tax_regime_code zx_rates_b.tax_regime_code%TYPE,
91: tax zx_rates_b.tax%TYPE,
92: tax_status_code zx_rates_b.tax_status_code%TYPE,
93: tax_rate_code zx_rates_b.tax_rate_code%TYPE,
94: tax_rate_id zx_rates_b.tax_rate_id%TYPE,

Line 91: tax zx_rates_b.tax%TYPE,

87: -- tax_jurisdiction_id is added for rate detemination requirement for multiple
88: -- jurisdictions case (bug 4534949)
89: TYPE zx_rate_info_rec_type IS RECORD (
90: tax_regime_code zx_rates_b.tax_regime_code%TYPE,
91: tax zx_rates_b.tax%TYPE,
92: tax_status_code zx_rates_b.tax_status_code%TYPE,
93: tax_rate_code zx_rates_b.tax_rate_code%TYPE,
94: tax_rate_id zx_rates_b.tax_rate_id%TYPE,
95: effective_from zx_rates_b.effective_from%TYPE,

Line 92: tax_status_code zx_rates_b.tax_status_code%TYPE,

88: -- jurisdictions case (bug 4534949)
89: TYPE zx_rate_info_rec_type IS RECORD (
90: tax_regime_code zx_rates_b.tax_regime_code%TYPE,
91: tax zx_rates_b.tax%TYPE,
92: tax_status_code zx_rates_b.tax_status_code%TYPE,
93: tax_rate_code zx_rates_b.tax_rate_code%TYPE,
94: tax_rate_id zx_rates_b.tax_rate_id%TYPE,
95: effective_from zx_rates_b.effective_from%TYPE,
96: effective_to zx_rates_b.effective_to%TYPE,

Line 93: tax_rate_code zx_rates_b.tax_rate_code%TYPE,

89: TYPE zx_rate_info_rec_type IS RECORD (
90: tax_regime_code zx_rates_b.tax_regime_code%TYPE,
91: tax zx_rates_b.tax%TYPE,
92: tax_status_code zx_rates_b.tax_status_code%TYPE,
93: tax_rate_code zx_rates_b.tax_rate_code%TYPE,
94: tax_rate_id zx_rates_b.tax_rate_id%TYPE,
95: effective_from zx_rates_b.effective_from%TYPE,
96: effective_to zx_rates_b.effective_to%TYPE,
97: rate_type_code zx_rates_b.rate_type_code%TYPE,

Line 94: tax_rate_id zx_rates_b.tax_rate_id%TYPE,

90: tax_regime_code zx_rates_b.tax_regime_code%TYPE,
91: tax zx_rates_b.tax%TYPE,
92: tax_status_code zx_rates_b.tax_status_code%TYPE,
93: tax_rate_code zx_rates_b.tax_rate_code%TYPE,
94: tax_rate_id zx_rates_b.tax_rate_id%TYPE,
95: effective_from zx_rates_b.effective_from%TYPE,
96: effective_to zx_rates_b.effective_to%TYPE,
97: rate_type_code zx_rates_b.rate_type_code%TYPE,
98: percentage_rate zx_rates_b.percentage_rate%TYPE,

Line 95: effective_from zx_rates_b.effective_from%TYPE,

91: tax zx_rates_b.tax%TYPE,
92: tax_status_code zx_rates_b.tax_status_code%TYPE,
93: tax_rate_code zx_rates_b.tax_rate_code%TYPE,
94: tax_rate_id zx_rates_b.tax_rate_id%TYPE,
95: effective_from zx_rates_b.effective_from%TYPE,
96: effective_to zx_rates_b.effective_to%TYPE,
97: rate_type_code zx_rates_b.rate_type_code%TYPE,
98: percentage_rate zx_rates_b.percentage_rate%TYPE,
99: quantity_rate zx_rates_b.quantity_rate%TYPE,

Line 96: effective_to zx_rates_b.effective_to%TYPE,

92: tax_status_code zx_rates_b.tax_status_code%TYPE,
93: tax_rate_code zx_rates_b.tax_rate_code%TYPE,
94: tax_rate_id zx_rates_b.tax_rate_id%TYPE,
95: effective_from zx_rates_b.effective_from%TYPE,
96: effective_to zx_rates_b.effective_to%TYPE,
97: rate_type_code zx_rates_b.rate_type_code%TYPE,
98: percentage_rate zx_rates_b.percentage_rate%TYPE,
99: quantity_rate zx_rates_b.quantity_rate%TYPE,
100: allow_adhoc_tax_rate_flag zx_rates_b.allow_adhoc_tax_rate_flag%TYPE,

Line 97: rate_type_code zx_rates_b.rate_type_code%TYPE,

93: tax_rate_code zx_rates_b.tax_rate_code%TYPE,
94: tax_rate_id zx_rates_b.tax_rate_id%TYPE,
95: effective_from zx_rates_b.effective_from%TYPE,
96: effective_to zx_rates_b.effective_to%TYPE,
97: rate_type_code zx_rates_b.rate_type_code%TYPE,
98: percentage_rate zx_rates_b.percentage_rate%TYPE,
99: quantity_rate zx_rates_b.quantity_rate%TYPE,
100: allow_adhoc_tax_rate_flag zx_rates_b.allow_adhoc_tax_rate_flag%TYPE,
101: uom_code zx_rates_b.uom_code%TYPE,

Line 98: percentage_rate zx_rates_b.percentage_rate%TYPE,

94: tax_rate_id zx_rates_b.tax_rate_id%TYPE,
95: effective_from zx_rates_b.effective_from%TYPE,
96: effective_to zx_rates_b.effective_to%TYPE,
97: rate_type_code zx_rates_b.rate_type_code%TYPE,
98: percentage_rate zx_rates_b.percentage_rate%TYPE,
99: quantity_rate zx_rates_b.quantity_rate%TYPE,
100: allow_adhoc_tax_rate_flag zx_rates_b.allow_adhoc_tax_rate_flag%TYPE,
101: uom_code zx_rates_b.uom_code%TYPE,
102: tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE,

Line 99: quantity_rate zx_rates_b.quantity_rate%TYPE,

95: effective_from zx_rates_b.effective_from%TYPE,
96: effective_to zx_rates_b.effective_to%TYPE,
97: rate_type_code zx_rates_b.rate_type_code%TYPE,
98: percentage_rate zx_rates_b.percentage_rate%TYPE,
99: quantity_rate zx_rates_b.quantity_rate%TYPE,
100: allow_adhoc_tax_rate_flag zx_rates_b.allow_adhoc_tax_rate_flag%TYPE,
101: uom_code zx_rates_b.uom_code%TYPE,
102: tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE,
103: offset_tax zx_rates_b.offset_tax%TYPE,

Line 100: allow_adhoc_tax_rate_flag zx_rates_b.allow_adhoc_tax_rate_flag%TYPE,

96: effective_to zx_rates_b.effective_to%TYPE,
97: rate_type_code zx_rates_b.rate_type_code%TYPE,
98: percentage_rate zx_rates_b.percentage_rate%TYPE,
99: quantity_rate zx_rates_b.quantity_rate%TYPE,
100: allow_adhoc_tax_rate_flag zx_rates_b.allow_adhoc_tax_rate_flag%TYPE,
101: uom_code zx_rates_b.uom_code%TYPE,
102: tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE,
103: offset_tax zx_rates_b.offset_tax%TYPE,
104: offset_status_code zx_rates_b.offset_status_code%TYPE,

Line 101: uom_code zx_rates_b.uom_code%TYPE,

97: rate_type_code zx_rates_b.rate_type_code%TYPE,
98: percentage_rate zx_rates_b.percentage_rate%TYPE,
99: quantity_rate zx_rates_b.quantity_rate%TYPE,
100: allow_adhoc_tax_rate_flag zx_rates_b.allow_adhoc_tax_rate_flag%TYPE,
101: uom_code zx_rates_b.uom_code%TYPE,
102: tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE,
103: offset_tax zx_rates_b.offset_tax%TYPE,
104: offset_status_code zx_rates_b.offset_status_code%TYPE,
105: offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE,

Line 102: tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE,

98: percentage_rate zx_rates_b.percentage_rate%TYPE,
99: quantity_rate zx_rates_b.quantity_rate%TYPE,
100: allow_adhoc_tax_rate_flag zx_rates_b.allow_adhoc_tax_rate_flag%TYPE,
101: uom_code zx_rates_b.uom_code%TYPE,
102: tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE,
103: offset_tax zx_rates_b.offset_tax%TYPE,
104: offset_status_code zx_rates_b.offset_status_code%TYPE,
105: offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE,
106: allow_exemptions_flag zx_rates_b.allow_exemptions_flag%TYPE,

Line 103: offset_tax zx_rates_b.offset_tax%TYPE,

99: quantity_rate zx_rates_b.quantity_rate%TYPE,
100: allow_adhoc_tax_rate_flag zx_rates_b.allow_adhoc_tax_rate_flag%TYPE,
101: uom_code zx_rates_b.uom_code%TYPE,
102: tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE,
103: offset_tax zx_rates_b.offset_tax%TYPE,
104: offset_status_code zx_rates_b.offset_status_code%TYPE,
105: offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE,
106: allow_exemptions_flag zx_rates_b.allow_exemptions_flag%TYPE,
107: allow_exceptions_flag zx_rates_b.allow_exceptions_flag%TYPE,

Line 104: offset_status_code zx_rates_b.offset_status_code%TYPE,

100: allow_adhoc_tax_rate_flag zx_rates_b.allow_adhoc_tax_rate_flag%TYPE,
101: uom_code zx_rates_b.uom_code%TYPE,
102: tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE,
103: offset_tax zx_rates_b.offset_tax%TYPE,
104: offset_status_code zx_rates_b.offset_status_code%TYPE,
105: offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE,
106: allow_exemptions_flag zx_rates_b.allow_exemptions_flag%TYPE,
107: allow_exceptions_flag zx_rates_b.allow_exceptions_flag%TYPE,
108: tax_jurisdiction_id zx_jurisdictions_b.tax_jurisdiction_id%TYPE,

Line 105: offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE,

101: uom_code zx_rates_b.uom_code%TYPE,
102: tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE,
103: offset_tax zx_rates_b.offset_tax%TYPE,
104: offset_status_code zx_rates_b.offset_status_code%TYPE,
105: offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE,
106: allow_exemptions_flag zx_rates_b.allow_exemptions_flag%TYPE,
107: allow_exceptions_flag zx_rates_b.allow_exceptions_flag%TYPE,
108: tax_jurisdiction_id zx_jurisdictions_b.tax_jurisdiction_id%TYPE,
109: def_rec_settlement_option_code zx_rates_b.def_rec_settlement_option_code%TYPE,

Line 106: allow_exemptions_flag zx_rates_b.allow_exemptions_flag%TYPE,

102: tax_jurisdiction_code zx_rates_b.tax_jurisdiction_code%TYPE,
103: offset_tax zx_rates_b.offset_tax%TYPE,
104: offset_status_code zx_rates_b.offset_status_code%TYPE,
105: offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE,
106: allow_exemptions_flag zx_rates_b.allow_exemptions_flag%TYPE,
107: allow_exceptions_flag zx_rates_b.allow_exceptions_flag%TYPE,
108: tax_jurisdiction_id zx_jurisdictions_b.tax_jurisdiction_id%TYPE,
109: def_rec_settlement_option_code zx_rates_b.def_rec_settlement_option_code%TYPE,
110: taxable_basis_formula_code zx_rates_b.taxable_basis_formula_code%TYPE,

Line 107: allow_exceptions_flag zx_rates_b.allow_exceptions_flag%TYPE,

103: offset_tax zx_rates_b.offset_tax%TYPE,
104: offset_status_code zx_rates_b.offset_status_code%TYPE,
105: offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE,
106: allow_exemptions_flag zx_rates_b.allow_exemptions_flag%TYPE,
107: allow_exceptions_flag zx_rates_b.allow_exceptions_flag%TYPE,
108: tax_jurisdiction_id zx_jurisdictions_b.tax_jurisdiction_id%TYPE,
109: def_rec_settlement_option_code zx_rates_b.def_rec_settlement_option_code%TYPE,
110: taxable_basis_formula_code zx_rates_b.taxable_basis_formula_code%TYPE,
111: adj_for_adhoc_amt_code zx_rates_b.adj_for_adhoc_amt_code%TYPE,

Line 109: def_rec_settlement_option_code zx_rates_b.def_rec_settlement_option_code%TYPE,

105: offset_tax_rate_code zx_rates_b.offset_tax_rate_code%TYPE,
106: allow_exemptions_flag zx_rates_b.allow_exemptions_flag%TYPE,
107: allow_exceptions_flag zx_rates_b.allow_exceptions_flag%TYPE,
108: tax_jurisdiction_id zx_jurisdictions_b.tax_jurisdiction_id%TYPE,
109: def_rec_settlement_option_code zx_rates_b.def_rec_settlement_option_code%TYPE,
110: taxable_basis_formula_code zx_rates_b.taxable_basis_formula_code%TYPE,
111: adj_for_adhoc_amt_code zx_rates_b.adj_for_adhoc_amt_code%TYPE,
112: inclusive_tax_flag zx_rates_b.inclusive_tax_flag%TYPE,
113: tax_class zx_rates_b.tax_class%TYPE

Line 110: taxable_basis_formula_code zx_rates_b.taxable_basis_formula_code%TYPE,

106: allow_exemptions_flag zx_rates_b.allow_exemptions_flag%TYPE,
107: allow_exceptions_flag zx_rates_b.allow_exceptions_flag%TYPE,
108: tax_jurisdiction_id zx_jurisdictions_b.tax_jurisdiction_id%TYPE,
109: def_rec_settlement_option_code zx_rates_b.def_rec_settlement_option_code%TYPE,
110: taxable_basis_formula_code zx_rates_b.taxable_basis_formula_code%TYPE,
111: adj_for_adhoc_amt_code zx_rates_b.adj_for_adhoc_amt_code%TYPE,
112: inclusive_tax_flag zx_rates_b.inclusive_tax_flag%TYPE,
113: tax_class zx_rates_b.tax_class%TYPE
114: );

Line 111: adj_for_adhoc_amt_code zx_rates_b.adj_for_adhoc_amt_code%TYPE,

107: allow_exceptions_flag zx_rates_b.allow_exceptions_flag%TYPE,
108: tax_jurisdiction_id zx_jurisdictions_b.tax_jurisdiction_id%TYPE,
109: def_rec_settlement_option_code zx_rates_b.def_rec_settlement_option_code%TYPE,
110: taxable_basis_formula_code zx_rates_b.taxable_basis_formula_code%TYPE,
111: adj_for_adhoc_amt_code zx_rates_b.adj_for_adhoc_amt_code%TYPE,
112: inclusive_tax_flag zx_rates_b.inclusive_tax_flag%TYPE,
113: tax_class zx_rates_b.tax_class%TYPE
114: );
115:

Line 112: inclusive_tax_flag zx_rates_b.inclusive_tax_flag%TYPE,

108: tax_jurisdiction_id zx_jurisdictions_b.tax_jurisdiction_id%TYPE,
109: def_rec_settlement_option_code zx_rates_b.def_rec_settlement_option_code%TYPE,
110: taxable_basis_formula_code zx_rates_b.taxable_basis_formula_code%TYPE,
111: adj_for_adhoc_amt_code zx_rates_b.adj_for_adhoc_amt_code%TYPE,
112: inclusive_tax_flag zx_rates_b.inclusive_tax_flag%TYPE,
113: tax_class zx_rates_b.tax_class%TYPE
114: );
115:
116: TYPE zx_rate_info_cache IS TABLE OF zx_rate_info_rec_type

Line 113: tax_class zx_rates_b.tax_class%TYPE

109: def_rec_settlement_option_code zx_rates_b.def_rec_settlement_option_code%TYPE,
110: taxable_basis_formula_code zx_rates_b.taxable_basis_formula_code%TYPE,
111: adj_for_adhoc_amt_code zx_rates_b.adj_for_adhoc_amt_code%TYPE,
112: inclusive_tax_flag zx_rates_b.inclusive_tax_flag%TYPE,
113: tax_class zx_rates_b.tax_class%TYPE
114: );
115:
116: TYPE zx_rate_info_cache IS TABLE OF zx_rate_info_rec_type
117: INDEX BY BINARY_INTEGER;