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