1 PACKAGE ZX_UPGRADE_CONTROL_PKG AUTHID CURRENT_USER AS
2 /* $Header: zxupctls.pls 120.2 2005/10/30 01:52:56 appldev ship $ */
3
4
5 FUNCTION IS_AP_TAX_DEF_UPDATE_ALLOWED
6 (
7 p_org_id IN ap_system_parameters.org_id%TYPE
8 ) RETURN BOOLEAN;
9
10 FUNCTION IS_AP_INV_TAX_UPDATE_ALLOWED
11 (
12 p_org_id IN ap_system_parameters.org_id%TYPE
13 ) RETURN BOOLEAN ;
14
15 FUNCTION IS_FIN_SYS_TAX_UPDATE_ALLOWED
16 (
17 p_org_id IN FINANCIALS_SYSTEM_PARAMS_ALL.ORG_ID%TYPE
18 ) RETURN BOOLEAN ;
19
20 FUNCTION IS_HR_LOCATION_UPDATE_ALLOWED
21 (
22 p_location_id IN HR_LOCATIONS_ALL.LOCATION_ID%TYPE
23 ) RETURN BOOLEAN ;
24
25 FUNCTION IS_PO_TAX_DEF_UPDATE_ALLOWED
26 (
27 p_org_id IN po_system_parameters.org_id%TYPE
28 ) RETURN BOOLEAN;
29
30 FUNCTION IS_AR_TAX_UPDATE_ALLOWED
31 (
32 p_org_id IN ar_system_parameters.org_id%TYPE
33 ) RETURN BOOLEAN;
34
35 FUNCTION IS_AR_TAX_DEF_UPDATE_ALLOWED
36 (
37 p_org_id IN ar_system_parameters.org_id%TYPE
38 ) RETURN BOOLEAN;
39
40 FUNCTION IS_JL_LTE_GDF_UPDATE_ALLOWED
41 RETURN BOOLEAN;
42
43 FUNCTION IS_CUST_UPDATE_ALLOWED
44 (
45 p_org_id IN hz_cust_accounts.org_id%TYPE Default NULL
46 )
47 RETURN BOOLEAN;
48
49
50 /* ==========================================================================*
51 | Procedure Name: SYNC_GL_ACCOUNT_TAX
52 *===========================================================================*/
53
54 PROCEDURE SYNC_GL_ACCOUNT_TAX
55 (
56 P_Dml_Type IN VARCHAR2,
57 P_RowId IN VARCHAR2,
58 P_Set_Of_Books_Id IN NUMBER,
59 P_Org_id IN NUMBER,
60 P_Account_Segment_Value IN VARCHAR2,
61 P_Tax_Type_Code IN VARCHAR2,
62 P_Allow_Tax_Code_Override_Flag IN VARCHAR2,
63 P_Amount_Includes_Tax_Flag IN VARCHAR2,
64 P_Creation_Date IN DATE,
65 P_Created_By IN NUMBER,
66 P_Last_Update_Date IN DATE,
67 P_Last_Updated_By IN NUMBER,
68 P_Last_Update_Login IN NUMBER,
72 P_Attribute2 IN VARCHAR2,
69 P_Tax_Code IN VARCHAR2,
70 P_Context IN VARCHAR2,
71 P_Attribute1 IN VARCHAR2,
73 P_Attribute3 IN VARCHAR2,
74 P_Attribute4 IN VARCHAR2,
75 P_Attribute5 IN VARCHAR2,
76 P_Attribute6 IN VARCHAR2,
77 P_Attribute7 IN VARCHAR2,
78 P_Attribute8 IN VARCHAR2,
79 P_Attribute9 IN VARCHAR2,
80 P_Attribute10 IN VARCHAR2,
81 P_Attribute11 IN VARCHAR2,
82 P_Attribute12 IN VARCHAR2,
83 P_Attribute13 IN VARCHAR2,
84 P_Attribute14 IN VARCHAR2,
85 P_Attribute15 IN VARCHAR2);
86
87
88 PROCEDURE SYNC_SUPPLIERS
89 (
90 P_Dml_Type IN VARCHAR2,
91 P_Vendor_Id IN NUMBER,
92 P_Last_Update_Date IN DATE,
93 P_Last_Updated_By IN NUMBER,
94 P_Vendor_Name IN VARCHAR2,
95 P_Segment1 IN VARCHAR2,
96 P_Summary_Flag IN VARCHAR2,
97 P_Enabled_Flag IN VARCHAR2,
98 P_Last_Update_Login IN NUMBER,
99 P_Creation_Date IN DATE,
100 P_Created_By IN NUMBER,
101 P_Employee_Id IN NUMBER,
102 P_Validation_Number IN NUMBER,
103 P_Vendor_Type_Lookup_Code IN VARCHAR2,
104 P_Customer_Num IN VARCHAR2,
105 P_One_Time_Flag IN VARCHAR2,
106 P_Parent_Vendor_Id IN NUMBER,
107 P_Min_Order_Amount IN NUMBER,
108 P_Ship_To_Location_Id IN NUMBER,
109 P_Bill_To_Location_Id IN NUMBER,
110 P_Ship_Via_Lookup_Code IN VARCHAR2,
111 P_Freight_Terms_Lookup_Code IN VARCHAR2,
112 P_Fob_Lookup_Code IN VARCHAR2,
113 P_Terms_Id IN NUMBER,
114 P_Set_Of_Books_Id IN NUMBER,
115 P_Always_Take_Disc_Flag IN VARCHAR2,
116 P_Pay_Date_Basis_Lookup_Code IN VARCHAR2,
117 P_Pay_Group_Lookup_Code IN VARCHAR2,
118 P_Payment_Priority IN NUMBER,
119 P_Invoice_Currency_Code IN VARCHAR2,
120 P_Payment_Currency_Code IN VARCHAR2,
121 P_Invoice_Amount_Limit IN NUMBER,
122 P_Hold_All_Payments_Flag IN VARCHAR2,
123 P_Hold_Future_Payments_Flag IN VARCHAR2,
124 P_Hold_Reason IN VARCHAR2,
125 P_Distribution_Set_Id IN NUMBER,
126 P_Accts_Pay_CCID IN NUMBER,
127 P_Future_Dated_Payment_CCID IN NUMBER,
128 P_Prepay_CCID IN NUMBER,
129 P_Num_1099 IN VARCHAR2,
130 P_Type_1099 IN VARCHAR2,
131 P_Withholding_Stat_Lookup_Code IN VARCHAR2,
132 P_Withholding_Start_Date IN DATE,
133 P_Org_Type_Lookup_Code IN VARCHAR2,
134 P_Vat_Code IN VARCHAR2,
135 P_Start_Date_Active IN DATE,
136 P_End_Date_Active IN DATE,
137 P_Qty_Rcv_Tolerance IN NUMBER,
138 P_Minority_Group_Lookup_Code IN VARCHAR2,
139 P_Payment_Method_Lookup_Code IN VARCHAR2,
140 P_Bank_Account_Name IN VARCHAR2,
141 P_Bank_Account_Num IN VARCHAR2,
142 P_Bank_Num IN VARCHAR2,
143 P_Bank_Account_Type IN VARCHAR2,
144 P_Women_Owned_Flag IN VARCHAR2,
145 P_Small_Business_Flag IN VARCHAR2,
146 P_Standard_Industry_Class IN VARCHAR2,
147 P_Attribute_Category IN VARCHAR2,
148 P_Attribute1 IN VARCHAR2,
149 P_Attribute2 IN VARCHAR2,
150 P_Attribute3 IN VARCHAR2,
151 P_Attribute4 IN VARCHAR2,
152 P_Attribute5 IN VARCHAR2,
153 P_Hold_Flag IN VARCHAR2,
154 P_Purchasing_Hold_Reason IN VARCHAR2,
155 P_Hold_By IN NUMBER,
156 P_Hold_Date IN DATE,
157 P_Terms_Date_Basis IN VARCHAR2,
158 P_Price_Tolerance IN NUMBER,
159 P_Attribute10 IN VARCHAR2,
160 P_Attribute11 IN VARCHAR2,
161 P_Attribute12 IN VARCHAR2,
162 P_Attribute13 IN VARCHAR2,
163 P_Attribute14 IN VARCHAR2,
164 P_Attribute15 IN VARCHAR2,
165 P_Attribute6 IN VARCHAR2,
166 P_Attribute7 IN VARCHAR2,
167 P_Attribute8 IN VARCHAR2,
168 P_Attribute9 IN VARCHAR2,
169 P_Days_Early_Receipt_Allowed IN NUMBER,
170 P_Days_Late_Receipt_Allowed IN NUMBER,
171 P_Enforce_Ship_To_Loc_Code IN VARCHAR2,
172 P_Exclusive_Payment_Flag IN VARCHAR2,
173 P_Federal_Reportable_Flag IN VARCHAR2,
174 P_Hold_Unmatched_Invoices_Flag IN VARCHAR2,
175 P_Match_Option IN VARCHAR2,
176 P_Create_Debit_Memo_Flag IN VARCHAR2,
177 P_Inspection_Required_Flag IN VARCHAR2,
178 P_Receipt_Required_Flag IN VARCHAR2,
179 P_Receiving_Routing_Id IN NUMBER,
180 P_State_Reportable_Flag IN VARCHAR2,
181 P_Tax_Verification_Date IN DATE,
182 P_Auto_Calculate_Interest_Flag IN VARCHAR2,
183 P_Name_Control IN VARCHAR2,
184 P_Allow_Subst_Receipts_Flag IN VARCHAR2,
185 P_allow_Unord_Receipts_Flag IN VARCHAR2,
186 P_Receipt_Days_Exception_Code IN VARCHAR2,
187 P_Qty_Rcv_Exception_Code IN VARCHAR2,
188 P_Offset_Tax_Flag IN VARCHAR2,
189 P_Exclude_Freight_From_Disc IN VARCHAR2,
190 P_Vat_Registration_Num IN VARCHAR2,
191 P_Tax_Reporting_Name IN VARCHAR2,
192 P_Awt_Group_Id IN NUMBER,
193 P_Check_Digits IN VARCHAR2,
194 P_Bank_Number IN VARCHAR2,
195 P_Allow_Awt_Flag IN VARCHAR2,
196 P_Bank_Branch_Type IN VARCHAR2,
197 P_EDI_Payment_Method IN VARCHAR2,
198 P_EDI_Payment_Format IN VARCHAR2,
199 P_EDI_Remittance_Method IN VARCHAR2,
200 P_EDI_Remittance_Instruction IN VARCHAR2,
201 P_EDI_transaction_handling IN VARCHAR2,
202 P_Auto_Tax_Calc_Flag IN VARCHAR2,
203 P_Auto_Tax_Calc_Override IN VARCHAR2,
204 P_Amount_Includes_Tax_Flag IN VARCHAR2,
205 P_AP_Tax_Rounding_Rule IN VARCHAR2,
206 P_Vendor_Name_Alt IN VARCHAR2,
207 P_global_attribute_category IN VARCHAR2,
208 P_global_attribute1 IN VARCHAR2,
209 P_global_attribute2 IN VARCHAR2,
210 P_global_attribute3 IN VARCHAR2,
211 P_global_attribute4 IN VARCHAR2,
212 P_global_attribute5 IN VARCHAR2,
213 P_global_attribute6 IN VARCHAR2,
214 P_global_attribute7 IN VARCHAR2,
215 P_global_attribute8 IN VARCHAR2,
216 P_global_attribute9 IN VARCHAR2,
217 P_global_attribute10 IN VARCHAR2,
218 P_global_attribute11 IN VARCHAR2,
219 P_global_attribute12 IN VARCHAR2,
220 P_global_attribute13 IN VARCHAR2,
221 P_global_attribute14 IN VARCHAR2,
222 P_global_attribute15 IN VARCHAR2,
223 P_global_attribute16 IN VARCHAR2,
224 P_global_attribute17 IN VARCHAR2,
225 P_global_attribute18 IN VARCHAR2,
226 P_global_attribute19 IN VARCHAR2,
227 P_global_attribute20 IN VARCHAR2,
228 P_bank_charge_bearer IN VARCHAR2);
229
230 PROCEDURE SYNC_SUPPLIERS_MERGE
231 (
232 P_Dml_Type IN VARCHAR2,
233 P_Vendor_Id IN NUMBER,
234 P_End_Date_Active IN DATE,
235 P_Last_Update_Date IN DATE,
236 P_Last_Updated_By IN NUMBER
237 );
238
239 PROCEDURE SYNC_SUPPLIER_SITES
240 (
241 P_Dml_Type IN VARCHAR2,
242 P_Vendor_Site_Id IN NUMBER,
243 P_Last_Update_Date IN DATE,
244 P_Last_Updated_By IN NUMBER,
245 P_Vendor_Id IN NUMBER,
246 P_Vendor_Site_Code IN VARCHAR2,
247 P_Last_Update_Login IN NUMBER,
248 P_Creation_Date IN DATE,
249 P_Created_By IN NUMBER,
250 P_Purchasing_Site_Flag IN VARCHAR2,
251 P_Rfq_Only_Site_Flag IN VARCHAR2,
252 P_Pay_Site_Flag IN VARCHAR2,
253 P_Attention_Ar_Flag IN VARCHAR2,
254 P_Address_Line1 IN VARCHAR2,
255 P_Address_Line2 IN VARCHAR2,
256 P_Address_Line3 IN VARCHAR2,
257 P_City IN VARCHAR2,
258 P_State IN VARCHAR2,
259 P_Zip IN VARCHAR2,
260 P_Province IN VARCHAR2,
261 P_Country IN VARCHAR2,
262 P_Area_Code IN VARCHAR2,
263 P_Phone IN VARCHAR2,
264 P_Customer_Num IN VARCHAR2,
265 P_Ship_To_Location_Id IN NUMBER,
266 P_Bill_To_Location_Id IN NUMBER,
267 P_Ship_Via_Lookup_Code IN VARCHAR2,
268 P_Freight_Terms_Lookup_Code IN VARCHAR2,
269 P_Fob_Lookup_Code IN VARCHAR2,
270 P_Inactive_Date IN DATE,
271 P_Fax IN VARCHAR2,
272 P_Fax_Area_Code IN VARCHAR2,
273 P_Telex IN VARCHAR2,
274 P_Payment_Method_Lookup_Code IN VARCHAR2,
275 P_Bank_Account_Name IN VARCHAR2,
276 P_Bank_Account_Num IN VARCHAR2,
277 P_Bank_Num IN VARCHAR2,
278 P_Bank_Account_Type IN VARCHAR2,
279 P_Terms_Date_Basis IN VARCHAR2,
280 P_Current_Catalog_Num IN VARCHAR2,
281 P_Vat_Code IN VARCHAR2,
282 P_Distribution_Set_Id IN NUMBER,
283 P_Accts_Pay_CCID IN NUMBER,
284 P_Future_Dated_Payment_CCID IN NUMBER,
285 P_Prepay_Code_Combination_Id IN NUMBER,
286 P_Pay_Group_Lookup_Code IN VARCHAR2,
287 P_Payment_Priority IN NUMBER,
288 P_Terms_Id IN NUMBER,
289 P_Invoice_Amount_Limit IN NUMBER,
290 P_Pay_Date_Basis_Lookup_Code IN VARCHAR2,
291 P_Always_Take_Disc_Flag IN VARCHAR2,
292 P_Invoice_Currency_Code IN VARCHAR2,
293 P_Payment_Currency_Code IN VARCHAR2,
294 P_Hold_All_Payments_Flag IN VARCHAR2,
295 P_Hold_Future_Payments_Flag IN VARCHAR2,
296 P_Hold_Reason IN VARCHAR2,
297 P_Hold_Unmatched_Invoices_Flag IN VARCHAR2,
298 P_Match_Option IN VARCHAR2,
299 P_create_debit_memo_flag IN VARCHAR2,
300 P_Exclusive_Payment_Flag IN VARCHAR2,
301 P_Tax_Reporting_Site_Flag IN VARCHAR2,
302 P_Attribute_Category IN VARCHAR2,
303 P_Attribute1 IN VARCHAR2,
304 P_Attribute2 IN VARCHAR2,
305 P_Attribute3 IN VARCHAR2,
306 P_Attribute4 IN VARCHAR2,
307 P_Attribute5 IN VARCHAR2,
308 P_Attribute6 IN VARCHAR2,
309 P_Attribute7 IN VARCHAR2,
310 P_Attribute8 IN VARCHAR2,
311 P_Attribute9 IN VARCHAR2,
312 P_Attribute10 IN VARCHAR2,
313 P_Attribute11 IN VARCHAR2,
314 P_Attribute12 IN VARCHAR2,
315 P_Attribute13 IN VARCHAR2,
316 P_Attribute14 IN VARCHAR2,
317 P_Attribute15 IN VARCHAR2,
318 P_Validation_Number IN NUMBER,
319 P_Exclude_Freight_From_Disc IN VARCHAR2,
320 P_Vat_Registration_Num IN VARCHAR2,
321 P_Offset_Tax_Flag IN VARCHAR2,
322 P_Check_Digits IN VARCHAR2,
323 P_Bank_Number IN VARCHAR2,
324 P_Address_Line4 IN VARCHAR2,
325 P_County IN VARCHAR2,
326 P_Address_Style IN VARCHAR2,
327 P_Language IN VARCHAR2,
328 P_Allow_Awt_Flag IN VARCHAR2,
329 P_Awt_Group_Id IN NUMBER,
330 P_pay_on_code IN VARCHAR2,
331 P_default_pay_site_id IN NUMBER,
332 P_pay_on_receipt_summary_code IN VARCHAR2,
333 P_Bank_Branch_Type IN VARCHAR2,
334 P_EDI_ID_Number IN VARCHAR2,
335 P_EDI_Payment_Method IN VARCHAR2,
336 P_EDI_Payment_Format IN VARCHAR2,
337 P_EDI_Remittance_Method IN VARCHAR2,
338 P_EDI_Remittance_Instruction IN VARCHAR2,
339 P_EDI_transaction_handling IN VARCHAR2,
340 P_Auto_Tax_Calc_Flag IN VARCHAR2,
341 P_Auto_Tax_Calc_Override IN VARCHAR2,
342 P_Amount_Includes_Tax_Flag IN VARCHAR2,
343 P_AP_Tax_Rounding_Rule IN VARCHAR2,
344 P_Vendor_Site_Code_Alt IN VARCHAR2,
345 P_Address_Lines_Alt IN VARCHAR2,
346 P_global_attribute_category IN VARCHAR2,
347 P_global_attribute1 IN VARCHAR2,
348 P_global_attribute2 IN VARCHAR2,
349 P_global_attribute3 IN VARCHAR2,
350 P_global_attribute4 IN VARCHAR2,
351 P_global_attribute5 IN VARCHAR2,
352 P_global_attribute6 IN VARCHAR2,
353 P_global_attribute7 IN VARCHAR2,
354 P_global_attribute8 IN VARCHAR2,
355 P_global_attribute9 IN VARCHAR2,
356 P_global_attribute10 IN VARCHAR2,
357 P_global_attribute11 IN VARCHAR2,
358 P_global_attribute12 IN VARCHAR2,
359 P_global_attribute13 IN VARCHAR2,
360 P_global_attribute14 IN VARCHAR2,
361 P_global_attribute15 IN VARCHAR2,
362 P_global_attribute16 IN VARCHAR2,
363 P_global_attribute17 IN VARCHAR2,
364 P_global_attribute18 IN VARCHAR2,
365 P_global_attribute19 IN VARCHAR2,
366 P_global_attribute20 IN VARCHAR2,
367 P_bank_charge_bearer IN VARCHAR2,
368 P_ece_tp_location_code IN VARCHAR2,
369 P_Pcard_Site_Flag IN VARCHAR2,
370 P_Country_of_Origin_Code IN VARCHAR2,
371 P_Shipping_Location_id IN NUMBER,
372 P_Supplier_Notif_Method IN VARCHAR2,
373 P_Email_Address IN VARCHAR2,
374 P_Remittance_email IN VARCHAR2,
375 P_primary_pay_site_flag IN VARCHAR2,
376 P_Shipping_Control IN VARCHAR2) ;
377
378 PROCEDURE SYNC_SUPPLIER_SITES_MERGE
379 (
380 P_Dml_Type IN VARCHAR2,
381 P_Vendor_Site_Id IN NUMBER,
382 P_Inactive_Date IN DATE,
383 P_Primary_Pay_Site_Flag IN VARCHAR2,
384 P_Tax_Reporting_Site_Flag IN VARCHAR2,
385 P_Last_Update_Date IN DATE,
386 P_Last_Updated_By IN NUMBER
387 );
388
389 PROCEDURE SYNC_AR_TAX_GROUP_CODES
390 (
391 P_DML_TYPE IN VARCHAR2,
392 P_TAX_GROUP_CODE_ID IN NUMBER,
393 P_CREATED_BY IN NUMBER,
394 P_CREATION_DATE IN DATE,
395 P_LAST_UPDATED_BY IN NUMBER,
396 P_LAST_UPDATE_DATE IN DATE,
397 P_LAST_UPDATE_LOGIN IN NUMBER,
398 P_TAX_GROUP_TYPE IN VARCHAR2,
399 P_TAX_GROUP_ID IN NUMBER,
400 P_DISPLAY_ORDER IN NUMBER,
401 P_TAX_CODE_ID IN NUMBER,
402 P_TAX_CONDITION_ID IN NUMBER,
403 P_TAX_EXCEPTION_ID IN NUMBER,
404 P_START_DATE IN DATE,
405 P_END_DATE IN DATE,
406 P_ENABLED_FLAG IN VARCHAR2,
407 P_COMPOUNDING_PRECEDENCE IN NUMBER,
408 P_ORG_ID IN NUMBER,
409 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
410 P_ATTRIBUTE1 IN VARCHAR2 ,
411 P_ATTRIBUTE2 IN VARCHAR2,
412 P_ATTRIBUTE3 IN VARCHAR2,
413 P_ATTRIBUTE4 IN VARCHAR2,
414 P_ATTRIBUTE5 IN VARCHAR2,
415 P_ATTRIBUTE6 IN VARCHAR2,
416 P_ATTRIBUTE7 IN VARCHAR2,
417 P_ATTRIBUTE8 IN VARCHAR2,
418 P_ATTRIBUTE9 IN VARCHAR2,
419 P_ATTRIBUTE10 IN VARCHAR2,
420 P_ATTRIBUTE11 IN VARCHAR2,
421 P_ATTRIBUTE12 IN VARCHAR2,
422 P_ATTRIBUTE13 IN VARCHAR2,
423 P_ATTRIBUTE14 IN VARCHAR2,
424 P_ATTRIBUTE15 IN VARCHAR2,
425 P_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
426 P_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
427 P_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
428 P_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
429 P_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
430 P_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
431 P_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
432 P_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
433 P_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
434 P_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
435 P_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
436 P_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
437 P_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
438 P_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
439 P_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
440 P_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
441 P_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
442 P_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
443 P_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
444 P_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
445 P_GLOBAL_ATTRIBUTE20 IN VARCHAR2);
446
447 PROCEDURE SYNC_AP_TAX_CODES
448 (
449 P_DML_TYPE IN VARCHAR2,
450 P_NAME IN VARCHAR2,
451 P_LAST_UPDATE_DATE IN DATE,
452 P_LAST_UPDATED_BY IN NUMBER,
453 P_TAX_TYPE IN VARCHAR2,
454 P_SET_OF_BOOKS_ID IN NUMBER,
455 P_DESCRIPTION IN VARCHAR2,
456 P_TAX_RATE IN NUMBER,
457 P_TAX_CODE_COMBINATION_ID IN NUMBER,
458 P_INACTIVE_DATE IN DATE,
459 P_LAST_UPDATE_LOGIN IN NUMBER,
460 P_CREATION_DATE IN DATE,
461 P_CREATED_BY IN NUMBER,
462 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
463 P_ATTRIBUTE1 IN VARCHAR2,
464 P_ATTRIBUTE2 IN VARCHAR2,
465 P_ATTRIBUTE3 IN VARCHAR2,
466 P_ATTRIBUTE4 IN VARCHAR2,
467 P_ATTRIBUTE5 IN VARCHAR2,
468 P_ATTRIBUTE6 IN VARCHAR2,
469 P_ATTRIBUTE7 IN VARCHAR2,
470 P_ATTRIBUTE8 IN VARCHAR2,
471 P_ATTRIBUTE9 IN VARCHAR2,
472 P_ATTRIBUTE10 IN VARCHAR2,
473 P_ATTRIBUTE11 IN VARCHAR2,
474 P_ATTRIBUTE12 IN VARCHAR2,
475 P_ATTRIBUTE13 IN VARCHAR2,
476 P_ATTRIBUTE14 IN VARCHAR2,
477 P_ATTRIBUTE15 IN VARCHAR2,
478 P_AWT_VENDOR_ID IN NUMBER,
479 P_AWT_VENDOR_SITE_ID IN NUMBER,
480 P_AWT_PERIOD_TYPE IN VARCHAR2,
481 P_AWT_PERIOD_LIMIT IN NUMBER,
482 P_RANGE_AMOUNT_BASIS IN VARCHAR2,
483 P_RANGE_PERIOD_BASIS IN VARCHAR2,
484 P_ORG_ID IN NUMBER,
485 P_VAT_TRANSACTION_TYPE IN VARCHAR2,
486 P_TAX_ID IN NUMBER,
487 P_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
488 P_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
489 P_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
490 P_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
491 P_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
492 P_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
493 P_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
494 P_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
495 P_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
496 P_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
497 P_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
498 P_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
499 P_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
500 P_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
501 P_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
502 P_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
503 P_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
504 P_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
505 P_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
506 P_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
507 P_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
508 P_WEB_ENABLED_FLAG IN VARCHAR2,
509 P_TAX_RECOVERY_RULE_ID IN NUMBER,
510 P_TAX_RECOVERY_RATE IN NUMBER,
511 P_START_DATE IN DATE,
512 P_ENABLED_FLAG IN VARCHAR2,
513 P_AWT_RATE_TYPE IN VARCHAR2,
514 P_OFFSET_TAX_CODE_ID IN NUMBER,
515 P_SUPPRESS_ZERO_AMOUNT_FLAG IN VARCHAR2);
516
517
518 PROCEDURE SYNC_AP_TAX_RECVRY_RULES
519 (
520 P_DML_TYPE IN VARCHAR2,
521 P_RULE_ID IN NUMBER,
522 P_CREATED_BY IN NUMBER,
523 P_CREATION_DATE IN DATE,
524 P_LAST_UPDATED_BY IN NUMBER,
525 P_LAST_UPDATE_DATE IN DATE,
526 P_LAST_UPDATE_LOGIN IN NUMBER,
527 P_NAME IN VARCHAR2,
528 P_DESCRIPTION IN VARCHAR2,
529 P_ORG_ID IN NUMBER,
530 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
531 P_ATTRIBUTE1 IN VARCHAR2,
532 P_ATTRIBUTE2 IN VARCHAR2,
533 P_ATTRIBUTE3 IN VARCHAR2,
534 P_ATTRIBUTE4 IN VARCHAR2,
535 P_ATTRIBUTE5 IN VARCHAR2,
536 P_ATTRIBUTE6 IN VARCHAR2,
537 P_ATTRIBUTE7 IN VARCHAR2,
538 P_ATTRIBUTE8 IN VARCHAR2,
539 P_ATTRIBUTE9 IN VARCHAR2,
540 P_ATTRIBUTE10 IN VARCHAR2,
541 P_ATTRIBUTE11 IN VARCHAR2,
542 P_ATTRIBUTE12 IN VARCHAR2,
543 P_ATTRIBUTE13 IN VARCHAR2,
544 P_ATTRIBUTE14 IN VARCHAR2,
545 P_ATTRIBUTE15 IN VARCHAR2,
546 P_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
547 P_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
548 P_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
549 P_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
550 P_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
551 P_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
552 P_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
553 P_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
554 P_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
555 P_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
556 P_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
557 P_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
558 P_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
559 P_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
560 P_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
561 P_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
562 P_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
563 P_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
564 P_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
565 P_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
566 P_GLOBAL_ATTRIBUTE20 IN VARCHAR2);
567
568 PROCEDURE SYNC_AP_TAX_RECVRY_RATES
569 (
570 P_DML_TYPE IN VARCHAR2,
571 P_RATE_ID IN NUMBER,
572 P_CREATED_BY IN NUMBER,
573 P_CREATION_DATE IN DATE,
574 P_LAST_UPDATED_BY IN NUMBER,
575 P_LAST_UPDATE_DATE IN DATE,
576 P_LAST_UPDATE_LOGIN IN NUMBER,
577 P_RULE_ID IN NUMBER,
578 P_CONCATENATED_SEGMENT_LOW IN VARCHAR2,
579 P_CONCATENATED_SEGMENT_HIGH IN VARCHAR2,
580 P_ENABLED_FLAG IN VARCHAR2,
581 P_START_DATE IN DATE,
582 P_END_DATE IN DATE,
583 P_RECOVERY_RATE IN NUMBER,
584 P_CONDITION IN VARCHAR2,
585 P_CONDITION_VALUE IN VARCHAR2,
586 P_FUNCTION IN VARCHAR2,
587 P_DESCRIPTION IN VARCHAR2,
588 P_ORG_ID IN NUMBER,
589 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
590 P_ATTRIBUTE1 IN VARCHAR2,
591 P_ATTRIBUTE2 IN VARCHAR2,
592 P_ATTRIBUTE3 IN VARCHAR2,
593 P_ATTRIBUTE4 IN VARCHAR2,
594 P_ATTRIBUTE5 IN VARCHAR2,
595 P_ATTRIBUTE6 IN VARCHAR2,
596 P_ATTRIBUTE7 IN VARCHAR2,
597 P_ATTRIBUTE8 IN VARCHAR2,
598 P_ATTRIBUTE9 IN VARCHAR2,
599 P_ATTRIBUTE10 IN VARCHAR2,
600 P_ATTRIBUTE11 IN VARCHAR2,
601 P_ATTRIBUTE12 IN VARCHAR2,
602 P_ATTRIBUTE13 IN VARCHAR2,
603 P_ATTRIBUTE14 IN VARCHAR2,
604 P_ATTRIBUTE15 IN VARCHAR2,
605 P_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
606 P_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
607 P_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
608 P_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
609 P_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
610 P_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
611 P_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
612 P_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
613 P_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
614 P_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
615 P_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
616 P_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
617 P_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
618 P_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
619 P_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
620 P_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
621 P_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
622 P_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
623 P_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
624 P_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
625 P_GLOBAL_ATTRIBUTE20 IN VARCHAR2) ;
626
627 PROCEDURE SYNC_MTL_SYSTEM_ITEMS(
628 P_ITEM_ID IN NUMBER,
629 P_ITEM_ORGANIZATION_ID IN NUMBER,
630 P_FISCAL_CLASSIF_TYPE_CODE IN VARCHAR2,
631 P_FISCAL_CLASSIF_CODE IN VARCHAR2 );
632
633 PROCEDURE SYNC_GDF_AR_MEMO_LINES (
634 P_MEMO_LINE_ID IN NUMBER,
635 P_SET_OF_BOOKS_ID IN NUMBER,
636 P_LINE_TYPE IN VARCHAR2,
637 P_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
638 P_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
639 P_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
640 P_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
641 P_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
642 P_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
643 P_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
644 P_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
645 P_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
646 P_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
647 P_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
648 P_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
649 P_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
650 P_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
651 P_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
652 P_GLOBAL_ATTRIBUTE15 IN VARCHAR2);
653
654 PROCEDURE SYNC_LTE_CATEG (
655 P_DML_TYPE IN VARCHAR2,
656 P_TAX_CATEGORY_ID IN NUMBER,
657 P_TAX_CATEGORY IN VARCHAR2,
658 P_END_DATE_ACTIVE IN DATE,
659 P_LAST_UPDATED_BY IN NUMBER,
660 P_LAST_UPDATE_DATE IN DATE,
661 P_CREATED_BY IN NUMBER,
662 P_CREATION_DATE IN DATE,
663 P_LAST_UPDATE_LOGIN IN NUMBER,
664 P_THRESHOLD_CHECK_LEVEL IN VARCHAR2,
665 P_THRESHOLD_CHECK_GRP_BY IN VARCHAR2,
666 P_MIN_AMOUNT IN NUMBER,
667 P_MIN_TAXABLE_BASIS IN NUMBER,
668 P_MIN_PERCENTAGE IN NUMBER,
669 P_TAX_INCLUSIVE IN VARCHAR2,
670 P_ORG_TAX_ATTRIBUTE IN VARCHAR2,
671 P_CUS_TAX_ATTRIBUTE IN VARCHAR2,
672 P_TXN_TAX_ATTRIBUTE IN VARCHAR2,
673 P_TRIBUTARY_SUBSTITUTION IN VARCHAR2,
674 P_USED_TO_REDUCE IN VARCHAR2,
675 P_TAX_CATEG_TO_REDUCE_ID IN NUMBER,
676 P_TAX_CODE IN VARCHAR2,
677 P_TAX_AUTHORITY_CODE IN VARCHAR2,
678 P_MANDATORY_IN_CLASS IN VARCHAR2,
679 P_PRINT_FLAG IN VARCHAR2,
680 P_TAX_RULE_SET IN VARCHAR2,
681 P_START_DATE_ACTIVE IN DATE,
682 P_TAX_REGIME IN VARCHAR2,
683 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
684 P_ATTRIBUTE1 IN VARCHAR2,
685 P_ATTRIBUTE2 IN VARCHAR2,
686 P_ATTRIBUTE3 IN VARCHAR2,
687 P_ATTRIBUTE4 IN VARCHAR2,
688 P_ATTRIBUTE5 IN VARCHAR2,
689 P_ATTRIBUTE6 IN VARCHAR2,
690 P_ATTRIBUTE7 IN VARCHAR2,
691 P_ATTRIBUTE8 IN VARCHAR2,
692 P_ATTRIBUTE9 IN VARCHAR2,
693 P_ATTRIBUTE10 IN VARCHAR2,
694 P_ATTRIBUTE11 IN VARCHAR2,
695 P_ATTRIBUTE12 IN VARCHAR2,
696 P_ATTRIBUTE13 IN VARCHAR2,
697 P_ATTRIBUTE14 IN VARCHAR2,
698 P_ATTRIBUTE15 IN VARCHAR2 );
699
700 PROCEDURE SYNC_LTE_GROUPS (
701 P_DML_TYPE IN VARCHAR2,
702 P_GROUP_TAX_ID IN NUMBER,
703 P_TAX_CATEGORY_ID IN NUMBER,
704 P_TAX_GROUP_RECORD_ID IN NUMBER,
705 P_ESTABLISHMENT_TYPE IN VARCHAR2,
706 P_CONTRIBUTOR_TYPE IN VARCHAR2,
707 P_TRANSACTION_NATURE IN VARCHAR2,
708 P_END_DATE_ACTIVE IN DATE,
709 P_USE_TX_CATEG_THRESHOLDS IN VARCHAR2,
710 P_LAST_UPDATE_DATE IN DATE,
711 P_LAST_UPDATED_BY IN NUMBER,
712 P_COMPOUND_PRECEDENCE IN NUMBER,
713 P_MIN_AMOUNT IN NUMBER,
714 P_MIN_TAXABLE_BASIS IN NUMBER,
715 P_MIN_PERCENTAGE IN NUMBER,
716 P_TAX_INCLUSIVE IN VARCHAR2,
717 P_TRIBUTARY_SUBSTITUTION IN VARCHAR2,
718 P_USED_TO_REDUCE IN VARCHAR2,
719 P_TAX_CODE IN VARCHAR2,
720 P_BASE_RATE IN NUMBER,
721 P_START_DATE_ACTIVE IN DATE,
722 P_LAST_UPDATE_LOGIN IN NUMBER,
723 P_CREATION_DATE IN DATE,
724 P_CREATED_BY IN NUMBER,
725 P_TAX_CATEGORY_TO_REDUCE_ID IN NUMBER,
726 P_CALCULATE_IN_OE IN VARCHAR2,
727 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
728 P_ATTRIBUTE1 IN VARCHAR2,
729 P_ATTRIBUTE2 IN VARCHAR2,
730 P_ATTRIBUTE3 IN VARCHAR2,
731 P_ATTRIBUTE4 IN VARCHAR2,
732 P_ATTRIBUTE5 IN VARCHAR2,
733 P_ATTRIBUTE6 IN VARCHAR2,
734 P_ATTRIBUTE7 IN VARCHAR2,
735 P_ATTRIBUTE8 IN VARCHAR2,
736 P_ATTRIBUTE9 IN VARCHAR2,
737 P_ATTRIBUTE10 IN VARCHAR2,
738 P_ATTRIBUTE11 IN VARCHAR2,
739 P_ATTRIBUTE12 IN VARCHAR2,
740 P_ATTRIBUTE13 IN VARCHAR2,
741 P_ATTRIBUTE14 IN VARCHAR2,
742 P_ATTRIBUTE15 IN VARCHAR2);
743
744 PROCEDURE SYNC_LTE_CAT_ATT (
745 P_DML_TYPE IN VARCHAR2,
746 P_TAX_CATEG_ATTR_ID IN NUMBER,
747 P_TAX_CATEGORY_ID IN NUMBER,
748 P_TAX_ATTRIBUTE_TYPE IN VARCHAR2,
749 P_TAX_ATTRIBUTE_NAME IN VARCHAR2,
750 P_MANDATORY_IN_CLASS IN VARCHAR2,
751 P_DETERMINING_FACTOR IN VARCHAR2,
752 P_GROUPING_ATTRIBUTE IN VARCHAR2,
753 P_PRIORITY_NUMBER IN NUMBER,
754 P_LAST_UPDATE_DATE IN DATE,
755 P_LAST_UPDATED_BY IN NUMBER,
756 P_CREATION_DATE IN DATE,
757 P_CREATED_BY IN NUMBER,
758 P_LAST_UPDATE_LOGIN IN NUMBER,
759 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
760 P_ATTRIBUTE1 IN VARCHAR2,
761 P_ATTRIBUTE2 IN VARCHAR2,
762 P_ATTRIBUTE3 IN VARCHAR2,
763 P_ATTRIBUTE4 IN VARCHAR2,
764 P_ATTRIBUTE5 IN VARCHAR2,
765 P_ATTRIBUTE6 IN VARCHAR2,
766 P_ATTRIBUTE7 IN VARCHAR2,
767 P_ATTRIBUTE8 IN VARCHAR2,
768 P_ATTRIBUTE9 IN VARCHAR2,
769 P_ATTRIBUTE10 IN VARCHAR2,
770 P_ATTRIBUTE11 IN VARCHAR2,
771 P_ATTRIBUTE12 IN VARCHAR2,
772 P_ATTRIBUTE13 IN VARCHAR2,
773 P_ATTRIBUTE14 IN VARCHAR2,
774 P_ATTRIBUTE15 IN VARCHAR2);
775
776 PROCEDURE SYNC_LTE_ATT_VAL (
777 P_DML_TYPE IN VARCHAR2,
778 P_TAX_CATEG_ATTR_VAL_ID IN NUMBER,
779 P_TAX_CATEGORY_ID IN NUMBER,
780 P_TAX_ATTRIBUTE_TYPE IN VARCHAR2,
781 P_TAX_ATTRIBUTE_NAME IN VARCHAR2,
782 P_TAX_ATTRIBUTE_VALUE IN VARCHAR2,
783 P_TAX_ATTR_VALUE_CODE IN VARCHAR2,
784 P_DEFAULT_TO_CLASS IN VARCHAR2,
785 P_LAST_UPDATE_DATE IN DATE,
786 P_LAST_UPDATED_BY IN NUMBER,
787 P_CREATION_DATE IN DATE,
788 P_CREATED_BY IN NUMBER,
789 P_LAST_UPDATE_LOGIN IN NUMBER,
790 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
791 P_ATTRIBUTE1 IN VARCHAR2,
792 P_ATTRIBUTE2 IN VARCHAR2,
793 P_ATTRIBUTE3 IN VARCHAR2,
794 P_ATTRIBUTE4 IN VARCHAR2,
795 P_ATTRIBUTE5 IN VARCHAR2,
796 P_ATTRIBUTE6 IN VARCHAR2,
797 P_ATTRIBUTE7 IN VARCHAR2,
798 P_ATTRIBUTE8 IN VARCHAR2,
799 P_ATTRIBUTE9 IN VARCHAR2,
800 P_ATTRIBUTE10 IN VARCHAR2,
801 P_ATTRIBUTE11 IN VARCHAR2,
802 P_ATTRIBUTE12 IN VARCHAR2,
803 P_ATTRIBUTE13 IN VARCHAR2,
804 P_ATTRIBUTE14 IN VARCHAR2,
805 P_ATTRIBUTE15 IN VARCHAR2);
806
807 PROCEDURE SYNC_LTE_ATT_CLS_HDR (
808 P_DML_TYPE IN VARCHAR2,
809 P_LOOKUP_TYPE IN VARCHAR2,
810 P_SECURITY_GROUP_ID IN NUMBER,
811 P_VIEW_APPLICATION_ID IN NUMBER,
812 P_LOOKUP_CODE IN VARCHAR2,
813 P_ENABLED_FLAG IN VARCHAR2,
814 P_START_DATE_ACTIVE IN DATE,
815 P_END_DATE_ACTIVE IN DATE,
816 P_TERRITORY_CODE IN VARCHAR2,
817 P_TAG IN VARCHAR2,
818 P_MEANING IN VARCHAR2,
819 P_DESCRIPTION IN VARCHAR2,
820 P_CREATION_DATE IN VARCHAR2,
821 P_CREATED_BY IN VARCHAR2,
822 P_LAST_UPDATE_DATE IN VARCHAR2,
823 P_LAST_UPDATED_BY IN VARCHAR2,
824 P_LAST_UPDATE_LOGIN IN VARCHAR2,
825 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
826 P_ATTRIBUTE1 IN VARCHAR2,
827 P_ATTRIBUTE2 IN VARCHAR2,
828 P_ATTRIBUTE3 IN VARCHAR2,
829 P_ATTRIBUTE4 IN VARCHAR2,
830 P_ATTRIBUTE5 IN VARCHAR2,
831 P_ATTRIBUTE6 IN VARCHAR2,
832 P_ATTRIBUTE7 IN VARCHAR2,
833 P_ATTRIBUTE8 IN VARCHAR2,
834 P_ATTRIBUTE9 IN VARCHAR2,
835 P_ATTRIBUTE10 IN VARCHAR2,
836 P_ATTRIBUTE11 IN VARCHAR2,
837 P_ATTRIBUTE12 IN VARCHAR2,
838 P_ATTRIBUTE13 IN VARCHAR2,
839 P_ATTRIBUTE14 IN VARCHAR2,
840 P_ATTRIBUTE15 IN VARCHAR2);
841
842 PROCEDURE SYNC_LTE_ATT_CLS (
843 P_DML_TYPE IN VARCHAR2,
844 P_ATTRIBUTE_CLASS_ID IN NUMBER,
845 P_TAX_ATTR_CLASS_TYPE IN VARCHAR2,
846 P_TAX_ATTR_CLASS_CODE IN VARCHAR2,
847 P_TAX_CATEGORY_ID IN NUMBER,
848 P_TAX_ATTRIBUTE_TYPE IN VARCHAR2,
849 P_TAX_ATTRIBUTE_NAME IN VARCHAR2,
850 P_TAX_ATTRIBUTE_VALUE IN VARCHAR2,
851 P_ENABLED_FLAG IN VARCHAR2,
852 P_LAST_UPDATED_BY IN NUMBER,
853 P_LAST_UPDATE_DATE IN DATE,
854 P_LAST_UPDATE_LOGIN IN NUMBER,
855 P_CREATION_DATE IN DATE,
856 P_CREATED_BY IN NUMBER,
857 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
858 P_ATTRIBUTE1 IN VARCHAR2,
859 P_ATTRIBUTE2 IN VARCHAR2,
860 P_ATTRIBUTE3 IN VARCHAR2,
861 P_ATTRIBUTE4 IN VARCHAR2,
862 P_ATTRIBUTE5 IN VARCHAR2,
863 P_ATTRIBUTE6 IN VARCHAR2,
864 P_ATTRIBUTE7 IN VARCHAR2,
865 P_ATTRIBUTE8 IN VARCHAR2,
866 P_ATTRIBUTE9 IN VARCHAR2,
867 P_ATTRIBUTE10 IN VARCHAR2,
868 P_ATTRIBUTE11 IN VARCHAR2,
869 P_ATTRIBUTE12 IN VARCHAR2,
870 P_ATTRIBUTE13 IN VARCHAR2,
871 P_ATTRIBUTE14 IN VARCHAR2,
872 P_ATTRIBUTE15 IN VARCHAR2);
873
874 PROCEDURE SYNC_LTE_LOCN (
875 P_DML_TYPE IN VARCHAR2,
876 P_LOCN_ID IN NUMBER,
877 P_SHIP_FROM_CODE IN VARCHAR2,
878 P_SHIP_TO_SEGMENT_ID IN NUMBER,
879 P_TAX_CATEGORY_ID IN NUMBER,
880 P_END_DATE_ACTIVE IN DATE,
881 P_LAST_UPDATED_BY IN NUMBER,
882 P_LAST_UPDATE_DATE IN DATE,
883 P_BASE_RATE IN NUMBER,
884 P_TAX_CODE IN VARCHAR2,
885 P_TRIB_SUBST_INSCRIPTION IN VARCHAR2,
886 P_START_DATE_ACTIVE IN DATE,
887 P_LAST_UPDATE_LOGIN IN NUMBER,
888 P_CREATION_DATE IN DATE,
889 P_CREATED_BY IN NUMBER,
890 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
891 P_ATTRIBUTE1 IN VARCHAR2,
892 P_ATTRIBUTE2 IN VARCHAR2,
893 P_ATTRIBUTE3 IN VARCHAR2,
894 P_ATTRIBUTE4 IN VARCHAR2,
895 P_ATTRIBUTE5 IN VARCHAR2,
896 P_ATTRIBUTE6 IN VARCHAR2,
897 P_ATTRIBUTE7 IN VARCHAR2,
898 P_ATTRIBUTE8 IN VARCHAR2,
899 P_ATTRIBUTE9 IN VARCHAR2,
900 P_ATTRIBUTE10 IN VARCHAR2,
901 P_ATTRIBUTE11 IN VARCHAR2,
902 P_ATTRIBUTE12 IN VARCHAR2,
903 P_ATTRIBUTE13 IN VARCHAR2,
904 P_ATTRIBUTE14 IN VARCHAR2,
905 P_ATTRIBUTE15 IN VARCHAR2);
906
907 PROCEDURE SYNC_LTE_FSC_CLS_HDR (
908 P_DML_TYPE IN VARCHAR2,
909 P_LOOKUP_TYPE IN VARCHAR2,
910 P_LOOKUP_CODE IN VARCHAR2,
911 P_ENABLED_FLAG IN VARCHAR2,
912 P_START_DATE_ACTIVE IN DATE,
913 P_END_DATE_ACTIVE IN DATE,
914 P_MEANING IN VARCHAR2,
915 P_DESCRIPTION IN VARCHAR2,
916 P_CREATION_DATE IN DATE,
917 P_CREATED_BY IN VARCHAR2,
918 P_LAST_UPDATE_DATE IN DATE,
919 P_LAST_UPDATED_BY IN VARCHAR2,
920 P_LAST_UPDATE_LOGIN IN VARCHAR2,
921 P_SECURITY_GROUP_ID IN NUMBER,
922 P_VIEW_APPLICATION_ID IN NUMBER,
923 P_TAG IN VARCHAR2,
924 P_TERRITORY_CODE IN VARCHAR2,
925 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
926 P_ATTRIBUTE1 IN VARCHAR2,
927 P_ATTRIBUTE2 IN VARCHAR2,
928 P_ATTRIBUTE3 IN VARCHAR2,
929 P_ATTRIBUTE4 IN VARCHAR2,
930 P_ATTRIBUTE5 IN VARCHAR2,
931 P_ATTRIBUTE6 IN VARCHAR2,
932 P_ATTRIBUTE7 IN VARCHAR2,
933 P_ATTRIBUTE8 IN VARCHAR2,
934 P_ATTRIBUTE9 IN VARCHAR2,
935 P_ATTRIBUTE10 IN VARCHAR2,
936 P_ATTRIBUTE11 IN VARCHAR2,
937 P_ATTRIBUTE12 IN VARCHAR2,
938 P_ATTRIBUTE13 IN VARCHAR2,
939 P_ATTRIBUTE14 IN VARCHAR2,
940 P_ATTRIBUTE15 IN VARCHAR2);
941
942 PROCEDURE SYNC_LTE_FSC_CLS (
943 P_DML_TYPE IN VARCHAR2,
944 P_FSC_CLS_ID IN NUMBER,
945 P_FISCAL_CLASSIFICATION_CODE IN VARCHAR2,
946 P_TAX_CATEGORY_ID IN NUMBER,
947 P_TAX_CODE IN VARCHAR2,
948 P_END_DATE_ACTIVE IN DATE,
949 P_BASE_RATE IN NUMBER,
950 P_START_DATE_ACTIVE IN DATE,
951 P_ENABLED_FLAG IN VARCHAR2,
952 P_LAST_UPDATE_DATE IN DATE,
953 P_LAST_UPDATED_BY IN NUMBER,
954 P_CREATION_DATE IN DATE,
955 P_CREATED_BY IN NUMBER,
956 P_LAST_UPDATE_LOGIN IN NUMBER,
957 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
958 P_ATTRIBUTE1 IN VARCHAR2,
959 P_ATTRIBUTE2 IN VARCHAR2,
960 P_ATTRIBUTE3 IN VARCHAR2,
961 P_ATTRIBUTE4 IN VARCHAR2,
962 P_ATTRIBUTE5 IN VARCHAR2,
963 P_ATTRIBUTE6 IN VARCHAR2,
964 P_ATTRIBUTE7 IN VARCHAR2,
965 P_ATTRIBUTE8 IN VARCHAR2,
966 P_ATTRIBUTE9 IN VARCHAR2,
967 P_ATTRIBUTE10 IN VARCHAR2,
968 P_ATTRIBUTE11 IN VARCHAR2,
969 P_ATTRIBUTE12 IN VARCHAR2,
970 P_ATTRIBUTE13 IN VARCHAR2,
971 P_ATTRIBUTE14 IN VARCHAR2,
972 P_ATTRIBUTE15 IN VARCHAR2);
973
974 PROCEDURE SYNC_LTE_RULES (
975 P_DML_TYPE IN VARCHAR2,
976 P_RULE_ID IN NUMBER,
977 P_TAX_RULE_LEVEL IN VARCHAR2,
978 P_RULE IN VARCHAR2,
979 P_TAX_CATEGORY_ID IN NUMBER,
980 P_CONTRIBUTOR_TYPE IN VARCHAR2,
981 P_CUST_TRX_TYPE_ID IN NUMBER,
982 P_LAST_UPDATE_DATE IN DATE,
983 P_LAST_UPDATED_BY IN NUMBER,
984 P_PRIORITY IN NUMBER,
985 P_DESCRIPTION IN VARCHAR2,
986 P_LAST_UPDATE_LOGIN IN NUMBER,
987 P_CREATION_DATE IN DATE,
988 P_CREATED_BY IN NUMBER);
989
990 PROCEDURE SYNC_LTE_CAT_DTL (
991 P_DML_TYPE IN VARCHAR2,
992 P_TAX_CATEG_DTL_ID IN NUMBER,
993 P_TAX_CATEGORY_ID IN NUMBER,
994 P_END_DATE_ACTIVE IN DATE,
995 P_MIN_TAXABLE_BASIS IN NUMBER,
996 P_LAST_UPDATE_DATE IN DATE,
997 P_LAST_UPDATED_BY IN NUMBER,
998 P_MIN_AMOUNT IN NUMBER,
999 P_MIN_PERCENTAGE IN NUMBER,
1000 P_TAX_CODE IN VARCHAR2,
1001 P_START_DATE_ACTIVE IN DATE,
1002 P_LAST_UPDATE_LOGIN IN NUMBER,
1003 P_CREATION_DATE IN DATE,
1004 P_CREATED_BY IN NUMBER,
1005 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
1006 P_ATTRIBUTE1 IN VARCHAR2,
1007 P_ATTRIBUTE2 IN VARCHAR2,
1008 P_ATTRIBUTE3 IN VARCHAR2,
1009 P_ATTRIBUTE4 IN VARCHAR2,
1010 P_ATTRIBUTE5 IN VARCHAR2,
1011 P_ATTRIBUTE6 IN VARCHAR2,
1012 P_ATTRIBUTE7 IN VARCHAR2,
1013 P_ATTRIBUTE8 IN VARCHAR2,
1014 P_ATTRIBUTE9 IN VARCHAR2,
1015 P_ATTRIBUTE10 IN VARCHAR2,
1016 P_ATTRIBUTE11 IN VARCHAR2,
1017 P_ATTRIBUTE12 IN VARCHAR2,
1018 P_ATTRIBUTE13 IN VARCHAR2,
1019 P_ATTRIBUTE14 IN VARCHAR2,
1020 P_ATTRIBUTE15 IN VARCHAR2);
1021
1022 PROCEDURE SYNC_LTE_SCHEDULES (
1023 P_DML_TYPE IN VARCHAR2,
1024 P_TAX_CATEG_SLAB_ID IN NUMBER,
1025 P_TAX_CATEGORY_ID IN NUMBER,
1026 P_END_DATE_ACTIVE IN DATE,
1027 P_MIN_TAXABLE_BASIS IN NUMBER,
1028 P_LAST_UPDATE_DATE IN DATE,
1029 P_LAST_UPDATED_BY IN NUMBER,
1030 P_MAX_TAXABLE_BASIS IN NUMBER,
1031 P_TAX_CODE IN VARCHAR2,
1032 P_START_DATE_ACTIVE IN DATE,
1033 P_LAST_UPDATE_LOGIN IN NUMBER,
1034 P_CREATION_DATE IN DATE,
1035 P_CREATED_BY IN NUMBER,
1036 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
1037 P_ATTRIBUTE1 IN VARCHAR2,
1038 P_ATTRIBUTE2 IN VARCHAR2,
1039 P_ATTRIBUTE3 IN VARCHAR2,
1040 P_ATTRIBUTE4 IN VARCHAR2,
1041 P_ATTRIBUTE5 IN VARCHAR2,
1042 P_ATTRIBUTE6 IN VARCHAR2,
1043 P_ATTRIBUTE7 IN VARCHAR2,
1044 P_ATTRIBUTE8 IN VARCHAR2,
1045 P_ATTRIBUTE9 IN VARCHAR2,
1046 P_ATTRIBUTE10 IN VARCHAR2,
1047 P_ATTRIBUTE11 IN VARCHAR2,
1048 P_ATTRIBUTE12 IN VARCHAR2,
1049 P_ATTRIBUTE13 IN VARCHAR2,
1050 P_ATTRIBUTE14 IN VARCHAR2,
1051 P_ATTRIBUTE15 IN VARCHAR2);
1052
1053 PROCEDURE SYNC_LTE_LGL_MSG (
1054 P_DML_TYPE IN VARCHAR2,
1055 P_RULE_ID IN NUMBER,
1056 P_RULE_DATA_ID IN NUMBER,
1057 P_EXCEPTION_CODE IN VARCHAR2,
1058 P_MESSAGE_ID IN NUMBER,
1059 P_INVENTORY_ITEM_FLAG IN VARCHAR2,
1060 P_INVENTORY_ORGANIZATION_ID IN NUMBER,
1061 P_START_DATE_ACTIVE IN DATE,
1062 P_END_DATE_ACTIVE IN DATE,
1063 P_LAST_UPDATE_DATE IN DATE,
1064 P_LAST_UPDATED_BY IN NUMBER,
1065 P_LAST_UPDATE_LOGIN IN NUMBER,
1066 P_CREATION_DATE IN DATE,
1067 P_CREATED_BY IN NUMBER);
1068
1069 PROCEDURE SYNC_LTE_CUS_CLS (
1070 P_DML_TYPE IN VARCHAR2,
1071 P_CUS_CLASS_ID IN NUMBER,
1072 P_ADDRESS_ID IN NUMBER,
1073 P_TAX_ATTR_CLASS_CODE IN VARCHAR2,
1074 P_TAX_CATEGORY_ID IN NUMBER,
1075 P_TAX_ATTRIBUTE_NAME IN VARCHAR2,
1076 P_TAX_ATTRIBUTE_VALUE IN VARCHAR2,
1077 P_ENABLED_FLAG IN VARCHAR2,
1078 P_LAST_UPDATED_BY IN NUMBER,
1079 P_LAST_UPDATE_DATE IN DATE,
1080 P_LAST_UPDATE_LOGIN IN NUMBER,
1081 P_CREATION_DATE IN DATE,
1082 P_CREATED_BY IN NUMBER);
1083
1084 PROCEDURE SYNC_LTE_EXC_FSC (
1085 P_DML_TYPE IN VARCHAR2,
1086 P_EXC_FSC_ID IN NUMBER,
1087 P_SHIP_FROM_CODE IN VARCHAR2,
1088 P_SHIP_TO_SEGMENT_ID IN NUMBER,
1089 P_FISCAL_CLASSIFICATION_CODE IN VARCHAR2,
1090 P_TAX_CATEGORY_ID IN NUMBER,
1091 P_END_DATE_ACTIVE IN DATE,
1092 P_START_DATE_ACTIVE IN DATE,
1093 P_TAX_CODE IN VARCHAR2,
1094 P_BASE_RATE IN NUMBER,
1095 P_LAST_UPDATED_BY IN NUMBER,
1096 P_LAST_UPDATE_DATE IN DATE,
1097 P_LAST_UPDATE_LOGIN IN NUMBER,
1098 P_CREATION_DATE IN DATE,
1099 P_CREATED_BY IN NUMBER,
1100 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
1101 P_ATTRIBUTE1 IN VARCHAR2,
1102 P_ATTRIBUTE2 IN VARCHAR2,
1103 P_ATTRIBUTE3 IN VARCHAR2,
1104 P_ATTRIBUTE4 IN VARCHAR2,
1105 P_ATTRIBUTE5 IN VARCHAR2,
1106 P_ATTRIBUTE6 IN VARCHAR2,
1107 P_ATTRIBUTE7 IN VARCHAR2,
1108 P_ATTRIBUTE8 IN VARCHAR2,
1109 P_ATTRIBUTE9 IN VARCHAR2,
1110 P_ATTRIBUTE10 IN VARCHAR2,
1111 P_ATTRIBUTE11 IN VARCHAR2,
1112 P_ATTRIBUTE12 IN VARCHAR2,
1113 P_ATTRIBUTE13 IN VARCHAR2,
1114 P_ATTRIBUTE14 IN VARCHAR2,
1115 P_ATTRIBUTE15 IN VARCHAR2);
1116
1117 PROCEDURE SYNC_LTE_EXC_ITM (
1118 P_DML_TYPE IN VARCHAR2,
1119 P_EXC_ITM_ID IN NUMBER,
1120 P_SHIP_FROM_CODE IN VARCHAR2,
1121 P_SHIP_TO_SEGMENT_ID IN NUMBER,
1122 P_INVENTORY_ITEM_ID IN NUMBER,
1123 P_ORGANIZATION_ID IN NUMBER,
1124 P_TAX_CATEGORY_ID IN NUMBER,
1125 P_END_DATE_ACTIVE IN DATE,
1126 P_START_DATE_ACTIVE IN DATE,
1127 P_TAX_CODE IN VARCHAR2,
1128 P_BASE_RATE IN NUMBER,
1129 P_LAST_UPDATED_BY IN NUMBER,
1130 P_LAST_UPDATE_DATE IN DATE,
1131 P_LAST_UPDATE_LOGIN IN NUMBER,
1132 P_CREATION_DATE IN DATE,
1133 P_CREATED_BY IN NUMBER,
1134 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
1135 P_ATTRIBUTE1 IN VARCHAR2,
1136 P_ATTRIBUTE2 IN VARCHAR2,
1137 P_ATTRIBUTE3 IN VARCHAR2,
1138 P_ATTRIBUTE4 IN VARCHAR2,
1139 P_ATTRIBUTE5 IN VARCHAR2,
1140 P_ATTRIBUTE6 IN VARCHAR2,
1141 P_ATTRIBUTE7 IN VARCHAR2,
1142 P_ATTRIBUTE8 IN VARCHAR2,
1143 P_ATTRIBUTE9 IN VARCHAR2,
1144 P_ATTRIBUTE10 IN VARCHAR2,
1145 P_ATTRIBUTE11 IN VARCHAR2,
1146 P_ATTRIBUTE12 IN VARCHAR2,
1147 P_ATTRIBUTE13 IN VARCHAR2,
1148 P_ATTRIBUTE14 IN VARCHAR2,
1149 P_ATTRIBUTE15 IN VARCHAR2);
1150
1151 PROCEDURE SYNC_LTE_EXC_CUS (
1152 P_DML_TYPE IN VARCHAR2,
1153 P_EXC_CUS_ID IN NUMBER,
1154 P_ADDRESS_ID IN NUMBER,
1155 P_TAX_CATEGORY_ID IN NUMBER,
1156 P_END_DATE_ACTIVE IN DATE,
1157 P_LAST_UPDATE_DATE IN DATE,
1158 P_LAST_UPDATED_BY IN NUMBER,
1159 P_TAX_CODE IN VARCHAR2,
1160 P_BASE_RATE IN NUMBER,
1161 P_START_DATE_ACTIVE IN DATE,
1162 P_LAST_UPDATE_LOGIN IN NUMBER,
1163 P_CREATION_DATE IN DATE,
1164 P_CREATED_BY IN NUMBER,
1165 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
1166 P_ATTRIBUTE1 IN VARCHAR2,
1167 P_ATTRIBUTE2 IN VARCHAR2,
1168 P_ATTRIBUTE3 IN VARCHAR2,
1169 P_ATTRIBUTE4 IN VARCHAR2,
1170 P_ATTRIBUTE5 IN VARCHAR2,
1171 P_ATTRIBUTE6 IN VARCHAR2,
1172 P_ATTRIBUTE7 IN VARCHAR2,
1173 P_ATTRIBUTE8 IN VARCHAR2,
1174 P_ATTRIBUTE9 IN VARCHAR2,
1175 P_ATTRIBUTE10 IN VARCHAR2,
1176 P_ATTRIBUTE11 IN VARCHAR2,
1177 P_ATTRIBUTE12 IN VARCHAR2,
1178 P_ATTRIBUTE13 IN VARCHAR2,
1179 P_ATTRIBUTE14 IN VARCHAR2,
1180 P_ATTRIBUTE15 IN VARCHAR2);
1181
1182 PROCEDURE SYNC_LTE_NAT_RAT (
1183 P_DML_TYPE IN VARCHAR2,
1184 P_TXN_NATURE_ID IN NUMBER,
1185 P_LAST_UPDATE_DATE IN DATE,
1186 P_LAST_UPDATED_BY IN NUMBER,
1187 P_CREATION_DATE IN DATE,
1188 P_CREATED_BY IN NUMBER,
1189 P_LAST_UPDATE_LOGIN IN NUMBER,
1190 P_TAX_CATEG_ATTR_VAL_ID IN NUMBER,
1191 P_END_DATE_ACTIVE IN DATE,
1192 P_TAX_CODE IN VARCHAR2,
1193 P_MIN_TAXABLE_BASIS IN NUMBER,
1194 P_MIN_AMOUNT IN NUMBER,
1195 P_MIN_PERCENTAGE IN NUMBER,
1196 P_BASE_RATE IN NUMBER,
1197 P_START_DATE_ACTIVE IN DATE,
1198 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
1199 P_ATTRIBUTE1 IN VARCHAR2,
1200 P_ATTRIBUTE2 IN VARCHAR2,
1201 P_ATTRIBUTE3 IN VARCHAR2,
1202 P_ATTRIBUTE4 IN VARCHAR2,
1203 P_ATTRIBUTE5 IN VARCHAR2,
1204 P_ATTRIBUTE6 IN VARCHAR2,
1205 P_ATTRIBUTE7 IN VARCHAR2,
1206 P_ATTRIBUTE8 IN VARCHAR2,
1207 P_ATTRIBUTE9 IN VARCHAR2,
1208 P_ATTRIBUTE10 IN VARCHAR2,
1209 P_ATTRIBUTE11 IN VARCHAR2,
1210 P_ATTRIBUTE12 IN VARCHAR2,
1211 P_ATTRIBUTE13 IN VARCHAR2,
1212 P_ATTRIBUTE14 IN VARCHAR2,
1213 P_ATTRIBUTE15 IN VARCHAR2);
1214
1215 PROCEDURE SYNC_AR_TAX_CONDITION_ACTIONS
1216 (
1217 P_DML_TYPE IN VARCHAR2,
1218 P_TAX_CONDITION_ACTION_ID IN NUMBER,
1219 P_CREATED_BY IN NUMBER,
1220 P_TAX_CONDITION_ID IN NUMBER,
1221 P_CREATION_DATE IN DATE,
1222 P_TAX_CONDITION_ACTION_TYPE IN VARCHAR2,
1223 P_DISPLAY_ORDER IN NUMBER,
1224 P_LAST_UPDATED_BY IN NUMBER,
1225 P_LAST_UPDATE_DATE IN DATE,
1226 P_LAST_UPDATE_LOGIN IN NUMBER,
1227 P_TAX_CONDITION_ACTION_CODE IN VARCHAR2,
1228 P_TAX_CONDITION_ACTION_VALUE IN VARCHAR2,
1229 P_ORG_ID IN NUMBER,
1230 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
1231 P_ATTRIBUTE1 IN VARCHAR2,
1232 P_ATTRIBUTE2 IN VARCHAR2,
1233 P_ATTRIBUTE3 IN VARCHAR2,
1234 P_ATTRIBUTE4 IN VARCHAR2,
1235 P_ATTRIBUTE5 IN VARCHAR2,
1236 P_ATTRIBUTE6 IN VARCHAR2,
1237 P_ATTRIBUTE7 IN VARCHAR2,
1238 P_ATTRIBUTE8 IN VARCHAR2,
1239 P_ATTRIBUTE9 IN VARCHAR2,
1240 P_ATTRIBUTE10 IN VARCHAR2,
1241 P_ATTRIBUTE11 IN VARCHAR2,
1242 P_ATTRIBUTE12 IN VARCHAR2,
1243 P_ATTRIBUTE13 IN VARCHAR2,
1244 P_ATTRIBUTE14 IN VARCHAR2,
1245 P_ATTRIBUTE15 IN VARCHAR2,
1246 P_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
1247 P_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
1248 P_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
1249 P_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
1250 P_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
1251 P_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
1252 P_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
1253 P_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
1254 P_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
1255 P_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
1256 P_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
1257 P_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
1258 P_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
1259 P_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
1260 P_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
1261 P_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
1262 P_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
1263 P_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
1264 P_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
1265 P_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
1266 P_GLOBAL_ATTRIBUTE20 IN VARCHAR2
1267 );
1268
1269 PROCEDURE SYNC_AR_TAX_CONDITON_LINES
1270 (
1271 P_DML_TYPE IN VARCHAR2,
1272 P_TAX_CONDITION_LINE_ID IN NUMBER,
1273 P_CREATED_BY IN NUMBER,
1274 P_TAX_CONDITION_ID IN NUMBER,
1275 P_CREATION_DATE IN DATE,
1276 P_DISPLAY_ORDER IN NUMBER,
1277 P_LAST_UPDATED_BY IN NUMBER,
1278 P_LAST_UPDATE_DATE IN DATE,
1279 P_LAST_UPDATE_LOGIN IN NUMBER,
1280 P_TAX_CONDITION_CLAUSE IN VARCHAR2,
1281 P_TAX_CONDITION_ENTITY IN VARCHAR2,
1282 P_TAX_CONDITION_OPERATOR IN VARCHAR2,
1283 P_TAX_CONDITION_FIELD IN VARCHAR2,
1284 P_TAX_CONDITION_VALUE IN VARCHAR2,
1285 P_TAX_CONDITION_EXPR IN VARCHAR2,
1286 P_ORG_ID IN NUMBER,
1287 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
1288 P_ATTRIBUTE1 IN VARCHAR2,
1289 P_ATTRIBUTE2 IN VARCHAR2,
1290 P_ATTRIBUTE3 IN VARCHAR2,
1291 P_ATTRIBUTE4 IN VARCHAR2,
1292 P_ATTRIBUTE5 IN VARCHAR2,
1293 P_ATTRIBUTE6 IN VARCHAR2,
1294 P_ATTRIBUTE7 IN VARCHAR2,
1295 P_ATTRIBUTE8 IN VARCHAR2,
1296 P_ATTRIBUTE9 IN VARCHAR2,
1297 P_ATTRIBUTE10 IN VARCHAR2,
1298 P_ATTRIBUTE11 IN VARCHAR2,
1299 P_ATTRIBUTE12 IN VARCHAR2,
1300 P_ATTRIBUTE13 IN VARCHAR2,
1301 P_ATTRIBUTE14 IN VARCHAR2,
1302 P_ATTRIBUTE15 IN VARCHAR2,
1303 P_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
1304 P_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
1305 P_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
1306 P_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
1307 P_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
1308 P_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
1309 P_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
1310 P_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
1311 P_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
1312 P_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
1313 P_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
1314 P_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
1315 P_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
1316 P_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
1317 P_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
1318 P_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
1319 P_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
1320 P_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
1321 P_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
1322 P_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
1323 P_GLOBAL_ATTRIBUTE20 IN VARCHAR2
1324 );
1325
1326 PROCEDURE SYNC_AR_TAX_CONDITIONS
1327 (
1328 P_DML_TYPE IN VARCHAR2,
1329 P_TAX_CONDITION_ID IN NUMBER,
1330 P_CREATED_BY IN NUMBER,
1331 P_CREATION_DATE IN DATE,
1332 P_LAST_UPDATED_BY IN NUMBER,
1333 P_LAST_UPDATE_DATE IN DATE,
1334 P_LAST_UPDATE_LOGIN IN NUMBER,
1335 P_TAX_CONDITION_NAME IN VARCHAR2,
1336 P_TAX_CONDITION_TYPE IN VARCHAR2,
1337 P_TAX_CONDITION_EXPR IN VARCHAR2,
1338 P_ORG_ID IN NUMBER,
1339 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
1340 P_ATTRIBUTE1 IN VARCHAR2,
1341 P_ATTRIBUTE2 IN VARCHAR2,
1342 P_ATTRIBUTE3 IN VARCHAR2,
1343 P_ATTRIBUTE4 IN VARCHAR2,
1344 P_ATTRIBUTE5 IN VARCHAR2,
1345 P_ATTRIBUTE6 IN VARCHAR2,
1346 P_ATTRIBUTE7 IN VARCHAR2,
1347 P_ATTRIBUTE8 IN VARCHAR2,
1348 P_ATTRIBUTE9 IN VARCHAR2,
1349 P_ATTRIBUTE10 IN VARCHAR2,
1350 P_ATTRIBUTE11 IN VARCHAR2,
1351 P_ATTRIBUTE12 IN VARCHAR2,
1352 P_ATTRIBUTE13 IN VARCHAR2,
1353 P_ATTRIBUTE14 IN VARCHAR2,
1354 P_ATTRIBUTE15 IN VARCHAR2,
1355 P_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
1356 P_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
1357 P_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
1358 P_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
1359 P_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
1360 P_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
1361 P_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
1362 P_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
1363 P_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
1364 P_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
1365 P_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
1366 P_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
1367 P_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
1368 P_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
1369 P_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
1370 P_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
1371 P_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
1372 P_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
1373 P_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
1374 P_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
1375 P_GLOBAL_ATTRIBUTE20 IN VARCHAR2
1376 );
1377
1378 PROCEDURE SYNC_AR_TAX_EXCEPTIONS
1379 (
1380 P_Dml_Type IN VARCHAR2,
1381 P_Org_Id IN NUMBER,
1382 P_Item_Exception_Rate_Id IN NUMBER,
1383 P_Creation_Date IN DATE,
1384 P_Created_By IN NUMBER,
1385 P_Last_Update_Login IN NUMBER,
1386 P_Last_Updated_By IN NUMBER,
1387 P_Last_Update_Date IN DATE,
1388 P_Item_Id IN NUMBER,
1389 P_Rate_Context IN VARCHAR2,
1390 P_Location1_Rate IN NUMBER,
1391 P_Location2_Rate IN NUMBER,
1392 P_Location3_Rate IN NUMBER,
1393 P_Location4_Rate IN NUMBER,
1394 P_Location5_Rate IN NUMBER,
1395 P_Location6_Rate IN NUMBER,
1396 P_Location7_Rate IN NUMBER,
1397 P_Location8_Rate IN NUMBER,
1398 P_Location9_Rate IN NUMBER,
1399 P_Location10_Rate IN NUMBER,
1400 P_Start_Date IN DATE,
1401 P_End_Date IN DATE,
1402 P_Attribute_Category IN VARCHAR2,
1403 P_Attribute1 IN VARCHAR2,
1404 P_Attribute2 IN VARCHAR2,
1405 P_Attribute3 IN VARCHAR2,
1406 P_Attribute4 IN VARCHAR2,
1407 P_Attribute5 IN VARCHAR2,
1408 P_Attribute6 IN VARCHAR2,
1409 P_Attribute7 IN VARCHAR2,
1410 P_Attribute8 IN VARCHAR2,
1411 P_Attribute9 IN VARCHAR2,
1412 P_Attribute10 IN VARCHAR2,
1413 P_Attribute11 IN VARCHAR2,
1414 P_Attribute12 IN VARCHAR2,
1415 P_Attribute13 IN VARCHAR2,
1416 P_Attribute14 IN VARCHAR2,
1417 P_Attribute15 IN VARCHAR2,
1418 P_Reason_Code IN VARCHAR2,
1419 P_Location_Context IN VARCHAR2,
1420 P_Location_Id_Segment_1 IN NUMBER,
1421 P_Location_Id_Segment_2 IN NUMBER,
1422 P_Location_Id_Segment_3 IN NUMBER,
1423 P_Location_Id_Segment_4 IN NUMBER,
1424 P_Location_Id_Segment_5 IN NUMBER,
1425 P_Location_Id_Segment_6 IN NUMBER,
1426 P_Location_Id_Segment_7 IN NUMBER,
1427 P_Location_Id_Segment_8 IN NUMBER,
1428 P_Location_Id_Segment_9 IN NUMBER,
1429 P_Location_Id_Segment_10 IN NUMBER
1430 );
1431
1432 PROCEDURE SYNC_AR_TAX_EXEMPTIONS
1433 (
1434 P_Dml_Type IN VARCHAR2,
1435 P_Org_Id IN NUMBER,
1436 p_Tax_exemption_id IN NUMBER,
1437 p_Last_updated_by IN NUMBER,
1438 p_Last_update_date IN DATE,
1439 p_Created_by IN NUMBER,
1440 p_Creation_date IN DATE,
1441 p_Status IN VARCHAR2,
1442 p_Inventory_item_id IN NUMBER,
1443 p_Customer_id IN NUMBER,
1444 p_Site_use_id IN NUMBER,
1445 p_Exemption_type IN VARCHAR2,
1446 p_Tax_code IN VARCHAR2,
1447 p_Percent_exempt IN NUMBER,
1448 p_Customer_exemption_number IN VARCHAR2,
1449 p_Start_date IN DATE,
1450 p_End_date IN DATE,
1451 p_Location_context IN VARCHAR2,
1452 p_Location_id_segment_1 IN NUMBER,
1453 p_Location_id_segment_2 IN NUMBER,
1454 p_Location_id_segment_3 IN NUMBER,
1455 p_Location_id_segment_4 IN NUMBER,
1456 p_Location_id_segment_5 IN NUMBER,
1457 p_Location_id_segment_6 IN NUMBER,
1458 p_Location_id_segment_7 IN NUMBER,
1459 p_Location_id_segment_8 IN NUMBER,
1460 p_Location_id_segment_9 IN NUMBER,
1461 p_Location_id_segment_10 IN NUMBER,
1462 p_Attribute_category IN VARCHAR2,
1463 p_Attribute1 IN VARCHAR2,
1464 p_Attribute2 IN VARCHAR2,
1465 p_Attribute3 IN VARCHAR2,
1466 p_Attribute4 IN VARCHAR2,
1467 p_Attribute5 IN VARCHAR2,
1468 p_Attribute6 IN VARCHAR2,
1469 p_Attribute7 IN VARCHAR2,
1470 p_Attribute8 IN VARCHAR2,
1471 p_Attribute9 IN VARCHAR2,
1472 p_Attribute10 IN VARCHAR2,
1473 p_Attribute11 IN VARCHAR2,
1474 p_Attribute12 IN VARCHAR2,
1475 p_Attribute13 IN VARCHAR2,
1476 p_Attribute14 IN VARCHAR2,
1477 p_Attribute15 IN VARCHAR2,
1478 p_In_use_flag IN VARCHAR2,
1479 p_Program_id IN NUMBER,
1480 p_Program_update_date IN DATE,
1481 p_Request_id IN NUMBER,
1482 p_Program_application_id IN NUMBER,
1483 p_Reason_code IN VARCHAR2,
1484 p_Exempt_Context IN VARCHAR2,
1485 p_Exempt_percent1 IN NUMBER,
1486 p_Exempt_percent2 IN NUMBER,
1487 p_Exempt_percent3 IN NUMBER,
1488 p_Exempt_percent4 IN NUMBER,
1489 p_Exempt_percent5 IN NUMBER,
1490 p_Exempt_percent6 IN NUMBER,
1491 p_Exempt_percent7 IN NUMBER,
1492 p_Exempt_percent8 IN NUMBER,
1493 p_Exempt_percent9 IN NUMBER,
1494 p_Exempt_percent10 IN NUMBER
1495 );
1496
1497 /* ==========================================================================*
1498 | Procedure Name: GET_PTP
1499 *===========================================================================*/
1500
1501 PROCEDURE GET_PTP(
1502 p_party_id IN NUMBER,
1503 p_party_type IN VARCHAR2,
1504 p_ptp_id OUT NOCOPY NUMBER,
1505 p_return_status OUT NOCOPY VARCHAR2);
1506
1507 PROCEDURE SYNC_AR_VAT_TAX (
1508 P_DML_TYPE IN VARCHAR2,
1509 P_ORG_ID IN NUMBER,
1510 P_VAT_TAX_ID IN NUMBER,
1511 P_TAX_CONSTRAINT_ID IN NUMBER,
1512 P_TAX_CLASS IN VARCHAR2,
1513 P_DISPLAYED_FLAG IN VARCHAR2,
1514 P_ENABLED_FLAG IN VARCHAR2,
1515 P_AMOUNT_INCLUDES_TAX_FLAG IN VARCHAR2,
1516 P_AMOUNT_INCLUDES_TAX_OVERRIDE IN VARCHAR2,
1517 P_TAXABLE_BASIS IN VARCHAR2,
1518 P_TAX_CALCULATION_PLSQL_BLOCK IN VARCHAR2,
1519 P_INTERIM_TAX_CCID IN NUMBER,
1520 P_ADJ_CCID IN NUMBER,
1521 P_EDISC_CCID IN NUMBER,
1522 P_UNEDISC_CCID IN NUMBER,
1523 P_FINCHRG_CCID IN NUMBER,
1524 P_ADJ_NON_REC_TAX_CCID IN NUMBER,
1525 P_EDISC_NON_REC_TAX_CCID IN NUMBER,
1526 P_UNEDISC_NON_REC_TAX_CCID IN NUMBER,
1527 P_FINCHRG_NON_REC_TAX_CCID IN NUMBER,
1528 P_SET_OF_BOOKS_ID IN NUMBER,
1529 P_TAX_CODE IN VARCHAR2,
1530 P_TAX_RATE IN NUMBER,
1531 P_TAX_TYPE IN VARCHAR2,
1532 P_VALIDATE_FLAG IN VARCHAR2,
1533 P_TAX_ACCOUNT_ID IN NUMBER,
1534 P_START_DATE IN DATE,
1535 P_END_DATE IN DATE,
1536 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
1537 P_ATTRIBUTE1 IN VARCHAR2,
1538 P_ATTRIBUTE2 IN VARCHAR2,
1539 P_ATTRIBUTE3 IN VARCHAR2,
1540 P_ATTRIBUTE4 IN VARCHAR2,
1541 P_ATTRIBUTE5 IN VARCHAR2,
1542 P_ATTRIBUTE6 IN VARCHAR2,
1543 P_ATTRIBUTE7 IN VARCHAR2,
1544 P_ATTRIBUTE8 IN VARCHAR2,
1545 P_ATTRIBUTE9 IN VARCHAR2,
1546 P_ATTRIBUTE10 IN VARCHAR2,
1547 P_ATTRIBUTE11 IN VARCHAR2,
1548 P_ATTRIBUTE12 IN VARCHAR2,
1549 P_ATTRIBUTE13 IN VARCHAR2,
1550 P_ATTRIBUTE14 IN VARCHAR2,
1551 P_ATTRIBUTE15 IN VARCHAR2,
1552 P_UNAPPROVED_EXEMPTION_FLAG IN VARCHAR2,
1553 P_DESCRIPTION IN VARCHAR2,
1554 P_VAT_TRANSACTION_TYPE IN VARCHAR2,
1555 P_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
1556 P_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
1557 P_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
1558 P_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
1559 P_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
1560 P_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
1561 P_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
1562 P_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
1563 P_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
1564 P_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
1565 P_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
1566 P_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
1567 P_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
1568 P_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
1569 P_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
1570 P_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
1571 P_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
1572 P_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
1573 P_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
1574 P_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
1575 P_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
1576 P_PRINTED_TAX_NAME IN VARCHAR2,
1577 P_CREATION_DATE IN DATE,
1578 P_CREATED_BY IN NUMBER,
1579 P_LAST_UPDATE_DATE IN DATE,
1580 P_LAST_UPDATED_BY IN NUMBER,
1581 P_LAST_UPDATE_LOGIN IN NUMBER,
1582 P_TAX_REGIME_CODE IN VARCHAR2 DEFAULT NULL, --Bug3872888
1583 P_TAX IN VARCHAR2 DEFAULT NULL, --Bug3872889
1584 P_TAX_STATUS_CODE IN VARCHAR2 DEFAULT NULL); --Bug3872889
1585
1586 END ZX_UPGRADE_CONTROL_PKG ;
[Home] [Help]