DBA Data[Home] [Help]

PACKAGE: APPS.ZX_TAXWARE_USER_PKG

Source


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;