4 TYPE system_info_rec_type IS RECORD
1 package ZX_AP_TAX_CLASSIFICATN_DEF_PKG AUTHID CURRENT_USER as
2 /* $Header: zxaptxclsdefpkgs.pls 120.10.12010000.3 2009/08/11 15:45:43 tsen ship $ */
3
5 (
6 --
7 -- This record holds general information used by the Tax Defaulting handler
8 -- and its associated functions.
9 --
10 ap_info zx_product_options_all%ROWTYPE,
11 po_info zx_product_options_all%ROWTYPE,
12 cc_info zx_product_options_all%ROWTYPE, -- Bug 6510307
13 set_of_books_id gl_sets_of_books.set_of_books_id%TYPE, --Bug 8353620
14 chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE,
15 org_id financials_system_parameters.org_id%TYPE
16 );
17 sysinfo system_info_rec_type;
18
19 TYPE TaxHierTabType IS TABLE OF VARCHAR2(100)
20 INDEX BY BINARY_INTEGER;
21
22 aptaxtab TaxHierTabType;
23 potaxtab TaxHierTabType;
24 cctaxtab TaxHierTabType; -- Bug 6510307
25
26 ap_info zx_product_options_all%ROWTYPE;
27 po_info zx_product_options_all%ROWTYPE;
28 cc_info zx_product_options_all%ROWTYPE; -- Bug 6510307
29
30 -- get_default_tax_code is replaced by get_default_tax_classification
31 procedure get_default_tax_classification
32 (
33 --p_line_location_id IN po_line_locations.line_location_id%TYPE,
34 p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
35 p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
36 p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
37 p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
38 p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
39 p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
40 p_vendor_id IN po_vendors.vendor_id%TYPE,
41 p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
45 p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
42 p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
43 p_concatenated_segments IN varchar2,
44 p_templ_tax_classification_cd IN varchar2,
46 p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
47 p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
48 p_item_org_id IN mtl_system_items.organization_id%TYPE,
49 p_tax_classification_code IN OUT NOCOPY varchar2,
50 p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
51 p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,
52 APPL_SHORT_NAME IN fnd_application.application_short_name%TYPE,
53 FUNC_SHORT_NAME IN VARCHAR2,
54 p_calling_sequence IN VARCHAR2,
55 p_event_class_code IN VARCHAR2,
56 p_entity_code IN VARCHAR2,
57 p_application_id IN NUMBER,
58 p_internal_organization_id IN NUMBER);
59
60 -- get_default_tax_code is replaced by get_default_tax_classification
61 procedure get_default_tax_classification
62 (
63 --p_line_location_id IN po_line_locations.line_location_id%TYPE,
64 p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
65 p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
66 p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
67 p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
68 p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
69 p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
70 p_vendor_id IN po_vendors.vendor_id%TYPE,
71 p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
72 p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
73 p_concatenated_segments IN varchar2,
74 p_templ_tax_classification_cd IN varchar2,
75 p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
76 p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
77 p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
78 p_item_org_id IN mtl_system_items.organization_id%TYPE,
79 p_tax_classification_code IN OUT NOCOPY varchar2,
80 p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
81 p_tax_user_override_flag IN VARCHAR2,
82 p_user_tax_name IN varchar2,
83 p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,
84 APPL_SHORT_NAME IN fnd_application.application_short_name%TYPE,
85 FUNC_SHORT_NAME IN VARCHAR2,
86 p_calling_sequence IN VARCHAR2,
87 p_event_class_code IN VARCHAR2,
88 p_entity_code IN VARCHAR2,
89 p_application_id IN NUMBER,
90 p_internal_organization_id IN NUMBER);
91
92 FUNCTION get_input_tax_classif_code (
93 --p_line_location_id IN po_line_locations.line_location_id%TYPE,
94 p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
95 p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
96 p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
97 p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
98 p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
99 p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
100 p_calling_sequence IN VARCHAR2 )
101
102 RETURN VARCHAR2;
103
104 FUNCTION get_site_tax (
105 p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
106 p_calling_sequence IN VARCHAR2 )
107
108 RETURN VARCHAR2;
109
110 FUNCTION get_vendor_tax (
111 p_vendor_id IN po_vendors.vendor_id%TYPE,
112 p_calling_sequence IN VARCHAR2)
113
114 RETURN VARCHAR2;
115
116 FUNCTION get_ship_to_location_tax (
117 p_ship_to_loc_id IN hr_locations_all.location_id%TYPE,
118 p_ship_to_loc_org_id IN hr_locations_all.inventory_organization_id%TYPE,
119 p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,
120 p_calling_sequence IN VARCHAR2)
121
122 RETURN VARCHAR2;
123
124 FUNCTION get_item_tax (
125 p_item_id IN mtl_system_items.inventory_item_id%TYPE,
126 p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
127 p_item_org_id IN mtl_system_items.organization_id%TYPE,
128 p_calling_sequence IN VARCHAR2)
129
130 RETURN VARCHAR2;
131
132 PROCEDURE get_account_tax (
133 p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
134 p_concatenated_segments IN varchar2,
135 p_tax_classification_code IN OUT NOCOPY varchar2,
136 p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
137 p_tax_classification_found IN OUT NOCOPY boolean,
138 p_calling_sequence IN VARCHAR2);
139
140 -- bug#4891362- add overloaded versions :
141
142 procedure get_default_tax_classification
143 (
144 p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
145 p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
146 p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
147 p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
148 p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
149 p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
150 p_vendor_id IN po_vendors.vendor_id%TYPE,
151 p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
155 p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
152 p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
153 p_concatenated_segments IN varchar2,
154 p_templ_tax_classification_cd IN varchar2,
156 p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
157 p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
158 p_item_org_id IN mtl_system_items.organization_id%TYPE,
159 p_tax_classification_code IN OUT NOCOPY varchar2,
160 p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
161 -- p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,
162 APPL_SHORT_NAME IN fnd_application.application_short_name%TYPE,
163 FUNC_SHORT_NAME IN VARCHAR2,
164 p_calling_sequence IN VARCHAR2,
165 p_event_class_code IN VARCHAR2,
166 p_entity_code IN VARCHAR2,
167 p_application_id IN NUMBER,
168 p_internal_organization_id IN NUMBER);
169
170 procedure get_default_tax_classification
171 (
172 p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
173 p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
174 p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
175 p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
176 p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
177 p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
178 p_vendor_id IN po_vendors.vendor_id%TYPE,
179 p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
180 p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
181 p_concatenated_segments IN varchar2,
182 p_templ_tax_classification_cd IN varchar2,
183 p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
184 p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
185 p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
186 p_item_org_id IN mtl_system_items.organization_id%TYPE,
187 p_tax_classification_code IN OUT NOCOPY varchar2,
188 p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
189 p_tax_user_override_flag IN VARCHAR2,
190 p_user_tax_name IN varchar2,
191 --p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,
192 APPL_SHORT_NAME IN fnd_application.application_short_name%TYPE,
193 FUNC_SHORT_NAME IN VARCHAR2,
194 p_calling_sequence IN VARCHAR2,
195 p_event_class_code IN VARCHAR2,
196 p_entity_code IN VARCHAR2,
197 p_application_id IN NUMBER,
198 p_internal_organization_id IN NUMBER);
199
200
201 FUNCTION get_ship_to_location_tax (
202 p_ship_to_loc_id IN hr_locations_all.location_id%TYPE,
203 p_ship_to_loc_org_id IN hr_locations_all.inventory_organization_id%TYPE,
204 -- p_legal_entity_id IN zx_lines.legal_entity_id%TYPE,
205 p_calling_sequence IN VARCHAR2)
206 RETURN VARCHAR2;
207
208 -- get_default_tax_code is replaced by get_default_tax_classification
209 -- bug#8717533
210 procedure get_def_tax_classif_from_acc
211 (
212 p_ref_doc_application_id IN zx_lines_det_factors.ref_doc_application_id%TYPE,
213 p_ref_doc_entity_code IN zx_lines_det_factors.ref_doc_entity_code%TYPE,
214 p_ref_doc_event_class_code IN zx_lines_det_factors.ref_doc_event_class_code%TYPE,
215 p_ref_doc_trx_id IN zx_lines_det_factors.ref_doc_trx_id%TYPE,
216 p_ref_doc_line_id IN zx_lines_det_factors.ref_doc_line_id%TYPE,
217 p_ref_doc_trx_level_type IN zx_lines_det_factors.ref_doc_trx_level_type%TYPE,
218 p_vendor_id IN po_vendors.vendor_id%TYPE,
219 p_vendor_site_id IN po_vendor_sites.vendor_site_id%TYPE,
220 p_code_combination_id IN gl_code_combinations.code_combination_id%TYPE,
221 p_concatenated_segments IN varchar2,
222 p_templ_tax_classification_cd IN varchar2,
223 p_ship_to_location_id IN hr_locations_all.location_id%TYPE,
224 p_ship_to_loc_org_id IN mtl_system_items.organization_id%TYPE,
225 p_inventory_item_id IN mtl_system_items.inventory_item_id%TYPE,
226 p_item_org_id IN mtl_system_items.organization_id%TYPE,
227 p_tax_classification_code IN OUT NOCOPY VARCHAR2,
228 p_allow_tax_code_override_flag OUT NOCOPY zx_acct_tx_cls_defs.allow_tax_code_override_flag%TYPE,
229 p_tax_user_override_flag IN VARCHAR2 DEFAULT 'N',
230 p_user_tax_name IN VARCHAR2 DEFAULT NULL,
231 p_legal_entity_id IN zx_lines.legal_entity_id%TYPE DEFAULT NULL,
232 APPL_SHORT_NAME IN fnd_application.application_short_name%TYPE,
233 FUNC_SHORT_NAME IN VARCHAR2,
234 p_calling_sequence IN VARCHAR2,
235 p_event_class_code IN VARCHAR2,
236 p_entity_code IN VARCHAR2,
237 p_application_id IN NUMBER,
238 p_internal_organization_id IN NUMBER,
239 p_default_hierarchy OUT NOCOPY BOOLEAN);
240
241 end ZX_AP_TAX_CLASSIFICATN_DEF_PKG;