1 PACKAGE ZX_TAXWARE_USER_PKG AS
2 /* $Header: zxtxwuserpkgs.pls 120.7 2006/09/21 09:51:58 vchallur ship $ */
3
4 /*These are two global variables which are used to hold the transaction date and transaction type id
5 Since these are derived at the header level and are reused at the header level they have been made
6 global*/
7
8 g_trx_date ZX_LINES_DET_FACTORS.TRX_DATE%TYPE;
9 g_trx_type_id ZX_LINES_DET_FACTORS.RECEIVABLES_TRX_TYPE_ID%TYPE;
10 g_line_negation BOOLEAN;
11 g_trx_line_id ZX_LINES_DET_FACTORS.TRX_ID%TYPE;
12 G_MESSAGES_TBL ZX_TAX_PARTNER_PKG.messages_tbl_type;
13 err_count number :=0;
14
15 /*The following are the nested table declartions to collect all the records
16 fetch from the main cursor defined in Derive_Line_Ext_Attr procedure .*/
17
18 TYPE org_id_table IS TABLE OF ZX_LINES_DET_FACTORS.Internal_Organization_Id%TYPE
19 INDEX BY BINARY_INTEGER;
20 TYPE application_id_table IS TABLE OF ZX_LINES_DET_FACTORS.Application_Id%TYPE
21 INDEX BY BINARY_INTEGER;
22 TYPE entity_code_table IS TABLE OF ZX_LINES_DET_FACTORS.entity_code%TYPE
23 INDEX BY BINARY_INTEGER;
24 TYPE event_class_code_table IS TABLE OF ZX_LINES_DET_FACTORS.event_class_code%TYPE
25 INDEX BY BINARY_INTEGER;
26 TYPE trx_id_table IS TABLE OF ZX_LINES_DET_FACTORS.trx_id%TYPE
27 INDEX BY BINARY_INTEGER;
28 TYPE trx_provider_id_table IS TABLE OF ZX_USER_PROC_INPUT_V.Tax_Provider_Id%TYPE
29 INDEX BY BINARY_INTEGER;
30 TYPE tax_regime_code_table IS TABLE OF ZX_USER_PROC_INPUT_V.Tax_Regime_Code%TYPE
31 INDEX BY BINARY_INTEGER;
32 TYPE trx_line_type_table IS TABLE OF ZX_LINES_DET_FACTORS.Trx_Line_Type%TYPE
33 INDEX BY BINARY_INTEGER;
34 TYPE trx_line_id_table IS TABLE OF ZX_LINES_DET_FACTORS.trx_line_id%TYPE
35 INDEX BY BINARY_INTEGER;
36 TYPE product_id_table IS TABLE OF ZX_LINES_DET_FACTORS.product_id%TYPE
37 INDEX BY BINARY_INTEGER;
38 TYPE product_org_id_table IS TABLE OF ZX_LINES_DET_FACTORS.product_org_id%TYPE
39 INDEX BY BINARY_INTEGER;
40 TYPE ship_to_party_tx_prf_id_table IS TABLE OF ZX_LINES_DET_FACTORS.ship_to_party_tax_prof_id%TYPE
41 INDEX BY BINARY_INTEGER;
42 TYPE exempt_cert_number_table IS TABLE OF ZX_LINES_DET_FACTORS.exempt_certificate_number%TYPE
43 INDEX BY BINARY_INTEGER;
44 TYPE exempt_control_flag_table IS TABLE OF ZX_LINES_DET_FACTORS.Exemption_Control_Flag%TYPE
45 INDEX BY BINARY_INTEGER;
46 TYPE exempt_reason_code_table IS TABLE OF ZX_LINES_DET_FACTORS.exempt_reason_code%TYPE
47 INDEX BY BINARY_INTEGER;
48 TYPE ship_to_site_tax_prof_table IS TABLE OF ZX_LINES_DET_FACTORS.ship_to_site_tax_prof_id%TYPE
49 INDEX BY BINARY_INTEGER;
50 TYPE ship_from_prty_tx_prf_id_table IS TABLE OF ZX_LINES_DET_FACTORS.Ship_from_Party_Tax_Prof_Id%TYPE
51 INDEX BY BINARY_INTEGER;
52 TYPE ship_to_location_id_table IS TABLE OF ZX_LINES_DET_FACTORS.ship_to_location_id%TYPE
53 INDEX BY BINARY_INTEGER;
54 TYPE ship_to_address_id_table IS TABLE OF ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE
55 INDEX BY BINARY_INTEGER;
56 TYPE ship_to_party_id_table IS TABLE OF ZX_PARTY_TAX_PROFILE.PARTY_ID%TYPE
57 INDEX BY BINARY_INTEGER;
58 TYPE arp_trx_line_type_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE1%TYPE
59 INDEX BY BINARY_INTEGER;
60 TYPE arp_product_code_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE2%TYPE
61 INDEX BY BINARY_INTEGER;
62 TYPE arp_exempt_cert_number_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE3%TYPE
63 INDEX BY BINARY_INTEGER;
64 TYPE arp_state_exempt_reason_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE4%TYPE
65 INDEX BY BINARY_INTEGER;
66 TYPE arp_county_exempt_reason_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE5%TYPE
67 INDEX BY BINARY_INTEGER;
68 TYPE arp_city_exempt_reason_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE6%TYPE
69 INDEX BY BINARY_INTEGER;
70 TYPE arp_district_exempt_rs_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE7%TYPE
71 INDEX BY BINARY_INTEGER;
72 TYPE arp_audit_flag_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE8%TYPE
73 INDEX BY BINARY_INTEGER;
74 TYPE arp_ship_to_add_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE9%TYPE
75 INDEX BY BINARY_INTEGER;
76 TYPE arp_ship_from_add_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE10%TYPE
77 INDEX BY BINARY_INTEGER;
78 TYPE arp_poa_add_code_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE11%TYPE
79 INDEX BY BINARY_INTEGER;
80 TYPE arp_poo_add_code_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE20%TYPE
81 INDEX BY BINARY_INTEGER;
82 TYPE arp_customer_code_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE12%TYPE
83 INDEX BY BINARY_INTEGER;
84 TYPE arp_customer_name_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE13%TYPE
85 INDEX BY BINARY_INTEGER;
86 TYPE arp_company_code_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE14%TYPE
87 INDEX BY BINARY_INTEGER;
88 TYPE arp_division_code_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE15%TYPE
89 INDEX BY BINARY_INTEGER;
90 TYPE arp_vnd_ctrl_exmpt_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE16%TYPE
91 INDEX BY BINARY_INTEGER;
92 TYPE arp_use_nexpro_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE17%TYPE
93 INDEX BY BINARY_INTEGER;
94 TYPE arp_tax_type_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE18%TYPE
95 INDEX BY BINARY_INTEGER;
96 TYPE arp_service_ind_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE19%TYPE
97 INDEX BY BINARY_INTEGER;
98 TYPE arp_transaction_date_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_DATE_ATTRIBUTE1%TYPE
99 INDEX BY BINARY_INTEGER;
100 TYPE arp_state_exempt_percent_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_NUMBER_ATTRIBUTE1%TYPE
101 INDEX BY BINARY_INTEGER;
102 TYPE arp_county_exempt_pct_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_NUMBER_ATTRIBUTE2%TYPE
103 INDEX BY BINARY_INTEGER;
104 TYPE arp_city_exempt_pct_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_NUMBER_ATTRIBUTE3%TYPE
105 INDEX BY BINARY_INTEGER;
106 TYPE arp_district_exempt_pct_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_NUMBER_ATTRIBUTE4%TYPE
107 INDEX BY BINARY_INTEGER;
108 TYPE ship_to_site_use_table IS TABLE OF ZX_LINES_DET_FACTORS.SHIP_TO_CUST_ACCT_SITE_USE_ID%TYPE
109 INDEX BY BINARY_INTEGER;
110 TYPE arp_tax_sel_param_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_NUMBER_ATTRIBUTE5%TYPE
111 INDEX BY BINARY_INTEGER;
112 TYPE bill_to_site_use_table IS TABLE OF ZX_LINES_DET_FACTORS.BILL_TO_CUST_ACCT_SITE_USE_ID%TYPE
113 INDEX BY BINARY_INTEGER;
114 TYPE bill_to_site_tax_prof_table IS TABLE OF ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE
115 INDEX BY BINARY_INTEGER;
116 TYPE bill_to_location_id_table IS TABLE OF ZX_LINES_DET_FACTORS.BILL_TO_LOCATION_ID%TYPE
117 INDEX BY BINARY_INTEGER;
118 TYPE bill_to_party_tax_id_table IS TABLE OF ZX_LINES_DET_FACTORS.BILL_TO_PARTY_TAX_PROF_ID%TYPE
119 INDEX BY BINARY_INTEGER;
120 TYPE bill_third_pty_acct_id_table IS TABLE OF ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_ID%TYPE
121 INDEX BY BINARY_INTEGER;
122 TYPE hq_site_tax_prof_id_tab IS TABLE OF ZX_LINES_DET_FACTORS.TRADING_HQ_SITE_TAX_PROF_ID%TYPE
123 INDEX BY BINARY_INTEGER;
124 TYPE hq_party_tax_prof_id_tab IS TABLE OF ZX_LINES_DET_FACTORS.TRADING_HQ_PARTY_TAX_PROF_ID%TYPE
125 INDEX BY BINARY_INTEGER;
126 TYPE line_level_action_table IS TABLE OF ZX_LINES_DET_FACTORS.LINE_LEVEL_ACTION%TYPE
127 INDEX BY BINARY_INTEGER;
128 TYPE exemption_control_flag_table IS TABLE OF ZX_LINES_DET_FACTORS.EXEMPTION_CONTROL_FLAG%TYPE
129 INDEX BY BINARY_INTEGER;
130 TYPE adjusted_doc_trx_id_table IS TABLE OF ZX_LINES_DET_FACTORS.ADJUSTED_DOC_TRX_ID%TYPE
131 INDEX BY BINARY_INTEGER;
132 TYPE line_amount_table IS TABLE OF ZX_LINES_DET_FACTORS.LINE_AMT%TYPE
133 INDEX BY BINARY_INTEGER;
134 TYPE trx_type_id_table IS TABLE OF ZX_LINES_DET_FACTORS.RECEIVABLES_TRX_TYPE_ID%TYPE
135 INDEX BY BINARY_INTEGER;
136 TYPE state_cert_no_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE20%TYPE
137 INDEX BY BINARY_INTEGER;
138 TYPE county_cert_no_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE21%TYPE
139 INDEX BY BINARY_INTEGER;
140 TYPE calculation_flag_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE21%TYPE
141 INDEX BY BINARY_INTEGER;
142 TYPE city_cert_no_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE22%TYPE
143 INDEX BY BINARY_INTEGER;
144 TYPE use_step_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE23%TYPE
145 INDEX BY BINARY_INTEGER;
146 TYPE step_proc_flag_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE24%TYPE
147 INDEX BY BINARY_INTEGER;
148 TYPE crit_flag_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE25%TYPE
149 INDEX BY BINARY_INTEGER;
150 TYPE Sec_County_Exempt_Pct_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_NUMBER_ATTRIBUTE6%TYPE
151 INDEX BY BINARY_INTEGER;
152 TYPE Sec_City_Exempt_Pct_table IS TABLE OF ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_NUMBER_ATTRIBUTE7%TYPE
153 INDEX BY BINARY_INTEGER;
154 TYPE adj_doc_appl_id_table IS TABLE OF ZX_LINES_DET_FACTORS.ADJUSTED_DOC_APPLICATION_ID%TYPE
155 INDEX BY BINARY_INTEGER;
156 TYPE adj_doc_entity_code_table IS TABLE OF ZX_LINES_DET_FACTORS.ADJUSTED_DOC_ENTITY_CODE%TYPE
157 INDEX BY BINARY_INTEGER;
158 TYPE adj_evnt_cls_code_table IS TABLE OF ZX_LINES_DET_FACTORS.ADJUSTED_DOC_EVENT_CLASS_CODE%TYPE
159 INDEX BY BINARY_INTEGER;
160 TYPE adj_doc_line_id_table IS TABLE OF ZX_LINES_DET_FACTORS.ADJUSTED_DOC_LINE_ID%TYPE
161 INDEX BY BINARY_INTEGER;
162 TYPE adj_doc_trx_level_type_table IS TABLE OF ZX_LINES_DET_FACTORS.ADJUSTED_DOC_TRX_LEVEL_TYPE%TYPE
163 INDEX BY BINARY_INTEGER;
164 TYPE ship_third_pty_site_table IS TABLE OF ZX_LINES_DET_FACTORS.SHIP_THIRD_PTY_ACCT_SITE_ID%TYPE
165 INDEX BY BINARY_INTEGER;
166 TYPE bill_third_pty_site_table IS TABLE OF ZX_LINES_DET_FACTORS.BILL_THIRD_PTY_ACCT_SITE_ID%TYPE
167 INDEX BY BINARY_INTEGER;
168
169
170
171
172
173 TYPE exemptions_info_rec IS RECORD (
174 state_exempt_reason ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE4%TYPE,
175 county_exempt_reason ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE5%TYPE,
176 city_exempt_reason ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE6%TYPE,
177 state_exempt_pct ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_NUMBER_ATTRIBUTE1%TYPE,
178 county_exempt_pct ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_NUMBER_ATTRIBUTE2%TYPE,
179 city_exempt_pct ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_NUMBER_ATTRIBUTE3%TYPE,
180 default_exempt_pct ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_NUMBER_ATTRIBUTE4%TYPE,
181 State_Cert_No ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE20%TYPE,
182 County_Cert_No ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE21%TYPE,
183 City_Cert_No ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE22%TYPE,
184 Sec_County_Exempt_Percent ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_NUMBER_ATTRIBUTE6%TYPE,
185 Sec_City_Exempt_Percent ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_NUMBER_ATTRIBUTE7%TYPE,
186 Use_Step ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE23%TYPE,
187 Step_Proc_Flag ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE24%TYPE,
188 Crit_Flag ZX_PRVDR_LINE_EXTNS_GT.LINE_EXT_VARCHAR_ATTRIBUTE25%TYPE
189 );
190
191 TYPE exemptions_info_table IS TABLE OF exemptions_info_rec
192 INDEX BY BINARY_INTEGER;
193
194 --The following are the variable declarations for all the nested tables above(one per nested table)
195
196 internal_org_id_tab org_id_table ;
197 application_id_tab application_id_table;
198 entity_code_tab entity_code_table;
199 event_class_code_tab event_class_code_table;
200 trx_id_tab trx_id_table;
201 tax_provider_id_tab trx_provider_id_table;
202 tax_regime_code_tab tax_regime_code_table;
203 trx_line_type_tab trx_line_type_table;
204 trx_line_id_tab trx_line_id_table;
205 product_id_tab product_id_table;
206 Product_Org_Id_tab product_org_id_table;
207 ship_to_tx_id_tab ship_to_party_tx_prf_id_table;
208 ship_from_tx_id_tab ship_from_prty_tx_prf_id_table;
209 cert_num_tab exempt_cert_number_table;
210 exmpt_rsn_code_tab exempt_reason_code_table;
211 exemption_control_flag_tab exemption_control_flag_table;
212
213 ship_to_site_tax_prof_tab ship_to_site_tax_prof_table;
214 ship_to_loc_id_tab ship_to_location_id_table;
215 exmpt_control_flg_tab exempt_control_flag_table;
216 arp_trx_line_type_tab arp_trx_line_type_table ;
217 arp_product_code_tab arp_product_code_table;
218 arp_audit_flag_tab arp_audit_flag_table;
222 arp_poo_add_code_tab arp_poo_add_code_table;
219 arp_ship_to_add_tab arp_ship_to_add_table;
220 arp_ship_from_add_tab arp_ship_from_add_table;
221 arp_poa_add_code_tab arp_poa_add_code_table;
223 arp_customer_code_tab arp_customer_code_table;
224 arp_customer_name_tab arp_customer_name_table;
225 arp_company_code_tab arp_company_code_table;
226 arp_division_code_tab arp_division_code_table;
227 arp_transaction_date_tab arp_transaction_date_table;
228 ship_to_address_id_tab ship_to_address_id_table;
229 ship_to_party_id_tab ship_to_party_id_table;
230
231 arp_state_exempt_reason_tab arp_state_exempt_reason_table ;
232 arp_county_exempt_reason_tab arp_county_exempt_reason_table;
233 arp_city_exempt_reason_tab arp_city_exempt_reason_table;
234 arp_district_exempt_rs_tab arp_district_exempt_rs_table;
235 arp_state_exempt_percent_tab arp_state_exempt_percent_table;
236 ship_to_site_use_tab ship_to_site_use_table;
237 arp_county_exempt_pct_tab arp_county_exempt_pct_table;
238 arp_city_exempt_pct_tab arp_city_exempt_pct_table;
239 arp_district_exempt_pct_tab arp_district_exempt_pct_table;
240 bill_to_site_use_tab bill_to_site_use_table;
241 bill_to_site_tax_prof_tab bill_to_site_tax_prof_table;
242 bill_to_party_tax_id_tab bill_to_party_tax_id_table;
243 bill_to_location_id_tab bill_to_location_id_table;
244 trad_hq_site_tax_prof_id_tab hq_site_tax_prof_id_tab;
245 trad_hq_party_tax_prof_id_tab hq_party_tax_prof_id_tab;
246 bill_third_pty_acct_id_tab bill_third_pty_acct_id_table;
247 line_level_action_tab line_level_action_table;
248 adjusted_doc_trx_id_tab adjusted_doc_trx_id_table;
249 line_amount_tab line_amount_table;
250 trx_type_id_tab trx_type_id_table;
251 exemptions_info_tab exemptions_info_table;
252 arp_vnd_ctrl_exmpt_tab arp_vnd_ctrl_exmpt_table;
253 arp_use_nexpro_tab arp_use_nexpro_table;
254 arp_tax_type_tab arp_tax_type_table;
255 arp_service_ind_tab arp_service_ind_table;
256 arp_tax_sel_param_tab arp_tax_sel_param_table;
257 state_cert_no_tab state_cert_no_table;
258 county_cert_no_tab county_cert_no_table;
259 city_cert_no_tab city_cert_no_table;
260 use_step_tab use_step_table;
261 step_proc_flag_tab step_proc_flag_table;
262 crit_flag_tab crit_flag_table;
263 sec_county_exempt_pct_tab sec_county_exempt_pct_table;
264 sec_city_exempt_pct_tab sec_city_exempt_pct_table;
265 calculation_flag_tab calculation_flag_table;
266 adj_doc_appl_id_tab adj_doc_appl_id_table;
267 adj_doc_entity_code_tab adj_doc_entity_code_table;
268 adj_evnt_cls_code_tab adj_evnt_cls_code_table;
269 adj_doc_line_id_tab adj_doc_line_id_table;
270 adj_doc_trx_level_type_tab adj_doc_trx_level_type_table;
271 ship_third_pty_site_tab ship_third_pty_site_table;
272 bill_third_pty_site_tab bill_third_pty_site_table;
273
274
275 PROCEDURE Derive_Hdr_Ext_Attr(
276 x_error_status OUT NOCOPY VARCHAR2,
277 x_messages_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.messages_tbl_type);
278 PROCEDURE Derive_Line_Ext_Attr(
279 x_error_status OUT NOCOPY VARCHAR2,
280 x_messages_tbl OUT NOCOPY ZX_TAX_PARTNER_PKG.messages_tbl_type);
281
282 END ZX_TAXWARE_USER_PKG;