1 PACKAGE BODY ZX_UPGRADE_CONTROL_PKG AS
2 /* $Header: zxupctlb.pls 120.24 2011/08/04 19:09:10 ssohal ship $ */
3
4
5 PG_DEBUG CONSTANT VARCHAR(1) default
6 NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
7
8 /*PROCEDURE migrate_sco_code_lte(
9 P_TAX_REGIME_CODE IN VARCHAR2 DEFAULT NULL,
10 P_ORG_ID IN NUMBER,
11 P_CREATION_DATE IN DATE,
12 P_CREATED_BY IN NUMBER,
13 P_LAST_UPDATE_DATE IN DATE,
14 P_LAST_UPDATED_BY IN NUMBER,
15 P_LAST_UPDATE_LOGIN IN NUMBER);
16 */
17 /* Following Functions and Procedures Calls will be placed in the appropriate
18 Forms in AP */
19
20 /* ========================================================================*
21 | Function Name: IS_AP_TAX_DEF_UPDATE_ALLOWED
22 |
23 | Product using
24 | this function : Will be called by AP, from Payables Option Form
25 |
26 | Purpose: Will be used to lock the Tax Attributes on 'Tax Defaults
27 | and Rules' Tab in Payables Option Form
28 |
29 |
30 | A value of TRUE will be returned in this skeleton version.
31 |
32 | In later version of the same function (delivered in ZX),
33 | it will be replaced with the actual solution.
34 | A value of FALSE would be returned if eTax defaulting hierarchy
35 | migration starts. Tax attributes in Payables 'Tax Defaults
36 | and Rules' should be made non-updateable in Payables Option Form,
37 | if value returned is FALSE.
38 |
39 *=========================================================================*/
40
41 FUNCTION IS_AP_TAX_DEF_UPDATE_ALLOWED
42 (
43 p_org_id IN ap_system_parameters.org_id%TYPE
44 ) RETURN BOOLEAN IS
45
46 BEGIN
47
48 RETURN TRUE;
49
50 END IS_AP_TAX_DEF_UPDATE_ALLOWED;
51
52
53 /* =========================================================================*
54 | Function Name: IS_AP_INV_TAX_UPDATE_ALLOWED
55 | Product using
56 | this function : Will be called by AP, from Payables Option Form
57 |
58 |
59 | Purpose: Will be used to lock the Tax Attributes on 'Invoice Tax' Tab in
60 | Payables Option Form.
61 |
62 | A value of TRUE will be returned in this skeleton version.
63 |
64 | In later version of the sa e function (delivered in ZX),
65 | it will be replaced with the actual solution.
66 | A value of FALSE would be returned if eTax Defintion
67 | migration starts. Tax attributes in Payables 'Invoice Tax' Tab
68 | should be ade non-updateable in Payables Option Form,
69 | if value returned is FALSE.
70 |
71 *========================================================================*/
72
73 FUNCTION IS_AP_INV_TAX_UPDATE_ALLOWED
74 (
75 p_org_id IN ap_system_parameters.org_id%TYPE
76 ) RETURN BOOLEAN IS
77
78 BEGIN
79
80 RETURN TRUE;
81
82 END IS_AP_INV_TAX_UPDATE_ALLOWED;
83
84
85 /* =========================================================================*
86 | Function Name: IS_FIN_SYS_TAX_UPDATE_ALLOWED
87 | Product using
88 | this function : Will be called by AP, from Financial Options Form
89 |
90 | Purpose: Will be used to lock the Tax Attributes on 'Tax' Tab in
91 | Financial Options Form.
92 | A value of TRUE will be returned in this skeleton version.
93 |
94 | In later version of the same function (delivered in ZX),
95 | it will be replaced with the actual solution.
96 | A value of FALSE would be returned if eTax Defintion
97 | migration starts. Tax attributes in Financial Options Form
98 | should be made non-updateable in Payables Option Form,
99 | if value returned is FALSE.
100 |
101 *========================================================================*/
102
103 FUNCTION IS_FIN_SYS_TAX_UPDATE_ALLOWED
104 (
105 p_org_id IN FINANCIALS_SYSTEM_PARAMS_ALL.ORG_ID%TYPE
106 ) RETURN BOOLEAN IS
107
108 BEGIN
109
110 RETURN TRUE;
111
112 END IS_FIN_SYS_TAX_UPDATE_ALLOWED;
113
114 /* =========================================================================*
115 | Function Name: IS_CUST_UPDATE_ALLOWED
116 | Product using
117 | this function : Will be called by AR/TCA
118 |
119 | Purpose: Will be used to lock the Tax Attributes in
120 | Customer Form.
121 |
122 *========================================================================*/
123
124 FUNCTION IS_CUST_UPDATE_ALLOWED
125 (
126 p_org_id IN hz_cust_accounts.org_id%TYPE Default NULL
127 )
128 RETURN BOOLEAN IS
129
130 BEGIN
131
132 RETURN TRUE;
133
134 END IS_CUST_UPDATE_ALLOWED;
135
136
137 /* =========================================================================*
138 | Procedure Name: SYNC_SUPPLIERS
139 | Product using
140 | this Procedure : Will be called by AP, from Suppliers Form
141 |
142 | Purpose: Will be used to Synchronize the data between the Suppliers and
143 | eTax Party tax profile Gateway entity.
144 |
145 | Will be called from Suppliers form,passing the attributes
146 | required for synchronization.
147 |
148 | This stubbed version will do nothing.
149 |
150 | In later version of the same Procedure(delivered in ZX),
151 | it will be replaced with the actual solution for synchronizing
152 | data between the source (Suppliers) and eTax Party tax profile
153 | Gateway entity.
154 |
155 *========================================================================*/
156
157
158 PROCEDURE SYNC_SUPPLIERS
159 (
160 P_Dml_Type IN VARCHAR2,
161 P_Vendor_Id IN NUMBER,
162 P_Last_Update_Date IN DATE,
163 P_Last_Updated_By IN NUMBER,
164 P_Vendor_Name IN VARCHAR2,
165 P_Segment1 IN VARCHAR2,
166 P_Summary_Flag IN VARCHAR2,
167 P_Enabled_Flag IN VARCHAR2,
168 P_Last_Update_Login IN NUMBER,
169 P_Creation_Date IN DATE,
170 P_Created_By IN NUMBER,
171 P_Employee_Id IN NUMBER,
172 P_Validation_Number IN NUMBER,
173 P_Vendor_Type_Lookup_Code IN VARCHAR2,
174 P_Customer_Num IN VARCHAR2,
175 P_One_Time_Flag IN VARCHAR2,
176 P_Parent_Vendor_Id IN NUMBER,
177 P_Min_Order_Amount IN NUMBER,
178 P_Ship_To_Location_Id IN NUMBER,
179 P_Bill_To_Location_Id IN NUMBER,
180 P_Ship_Via_Lookup_Code IN VARCHAR2,
181 P_Freight_Terms_Lookup_Code IN VARCHAR2,
182 P_Fob_Lookup_Code IN VARCHAR2,
183 P_Terms_Id IN NUMBER,
184 P_Set_Of_Books_Id IN NUMBER,
185 P_Always_Take_Disc_Flag IN VARCHAR2,
186 P_Pay_Date_Basis_Lookup_Code IN VARCHAR2,
187 P_Pay_Group_Lookup_Code IN VARCHAR2,
188 P_Payment_Priority IN NUMBER,
189 P_Invoice_Currency_Code IN VARCHAR2,
190 P_Payment_Currency_Code IN VARCHAR2,
191 P_Invoice_Amount_Limit IN NUMBER,
192 P_Hold_All_Payments_Flag IN VARCHAR2,
193 P_Hold_Future_Payments_Flag IN VARCHAR2,
194 P_Hold_Reason IN VARCHAR2,
195 P_Distribution_Set_Id IN NUMBER,
196 P_Accts_Pay_CCID IN NUMBER,
197 P_Future_Dated_Payment_CCID IN NUMBER,
198 P_Prepay_CCID IN NUMBER,
199 P_Num_1099 IN VARCHAR2,
200 P_Type_1099 IN VARCHAR2,
201 P_Withholding_Stat_Lookup_Code IN VARCHAR2,
202 P_Withholding_Start_Date IN DATE,
203 P_Org_Type_Lookup_Code IN VARCHAR2,
204 P_Vat_Code IN VARCHAR2,
205 P_Start_Date_Active IN DATE,
206 P_End_Date_Active IN DATE,
207 P_Qty_Rcv_Tolerance IN NUMBER,
208 P_Minority_Group_Lookup_Code IN VARCHAR2,
209 P_Payment_Method_Lookup_Code IN VARCHAR2,
210 P_Bank_Account_Name IN VARCHAR2,
211 P_Bank_Account_Num IN VARCHAR2,
212 P_Bank_Num IN VARCHAR2,
213 P_Bank_Account_Type IN VARCHAR2,
214 P_Women_Owned_Flag IN VARCHAR2,
215 P_Small_Business_Flag IN VARCHAR2,
216 P_Standard_Industry_Class IN VARCHAR2,
217 P_Attribute_Category IN VARCHAR2,
218 P_Attribute1 IN VARCHAR2,
219 P_Attribute2 IN VARCHAR2,
220 P_Attribute3 IN VARCHAR2,
221 P_Attribute4 IN VARCHAR2,
222 P_Attribute5 IN VARCHAR2,
223 P_Hold_Flag IN VARCHAR2,
224 P_Purchasing_Hold_Reason IN VARCHAR2,
225 P_Hold_By IN NUMBER,
226 P_Hold_Date IN DATE,
227 P_Terms_Date_Basis IN VARCHAR2,
228 P_Price_Tolerance IN NUMBER,
229 P_Attribute10 IN VARCHAR2,
230 P_Attribute11 IN VARCHAR2,
231 P_Attribute12 IN VARCHAR2,
232 P_Attribute13 IN VARCHAR2,
233 P_Attribute14 IN VARCHAR2,
234 P_Attribute15 IN VARCHAR2,
235 P_Attribute6 IN VARCHAR2,
236 P_Attribute7 IN VARCHAR2,
237 P_Attribute8 IN VARCHAR2,
238 P_Attribute9 IN VARCHAR2,
239 P_Days_Early_Receipt_Allowed IN NUMBER,
240 P_Days_Late_Receipt_Allowed IN NUMBER,
241 P_Enforce_Ship_To_Loc_Code IN VARCHAR2,
242 P_Exclusive_Payment_Flag IN VARCHAR2,
243 P_Federal_Reportable_Flag IN VARCHAR2,
244 P_Hold_Unmatched_Invoices_Flag IN VARCHAR2,
245 P_Match_Option IN VARCHAR2,
246 P_Create_Debit_Memo_Flag IN VARCHAR2,
247 P_Inspection_Required_Flag IN VARCHAR2,
248 P_Receipt_Required_Flag IN VARCHAR2,
249 P_Receiving_Routing_Id IN NUMBER,
250 P_State_Reportable_Flag IN VARCHAR2,
251 P_Tax_Verification_Date IN DATE,
252 P_Auto_Calculate_Interest_Flag IN VARCHAR2,
253 P_Name_Control IN VARCHAR2,
254 P_Allow_Subst_Receipts_Flag IN VARCHAR2,
255 P_allow_Unord_Receipts_Flag IN VARCHAR2,
256 P_Receipt_Days_Exception_Code IN VARCHAR2,
257 P_Qty_Rcv_Exception_Code IN VARCHAR2,
258 P_Offset_Tax_Flag IN VARCHAR2,
259 P_Exclude_Freight_From_Disc IN VARCHAR2,
260 P_Vat_Registration_Num IN VARCHAR2,
261 P_Tax_Reporting_Name IN VARCHAR2,
262 P_Awt_Group_Id IN NUMBER,
263 P_Check_Digits IN VARCHAR2,
264 P_Bank_Number IN VARCHAR2,
265 P_Allow_Awt_Flag IN VARCHAR2,
266 P_Bank_Branch_Type IN VARCHAR2,
267 P_EDI_Payment_Method IN VARCHAR2,
268 P_EDI_Payment_Format IN VARCHAR2,
269 P_EDI_Remittance_Method IN VARCHAR2,
270 P_EDI_Remittance_Instruction IN VARCHAR2,
271 P_EDI_transaction_handling IN VARCHAR2,
272 P_Auto_Tax_Calc_Flag IN VARCHAR2,
273 P_Auto_Tax_Calc_Override IN VARCHAR2,
274 P_Amount_Includes_Tax_Flag IN VARCHAR2,
275 P_AP_Tax_Rounding_Rule IN VARCHAR2,
276 P_Vendor_Name_Alt IN VARCHAR2,
277 P_global_attribute_category IN VARCHAR2,
278 P_global_attribute1 IN VARCHAR2,
279 P_global_attribute2 IN VARCHAR2,
280 P_global_attribute3 IN VARCHAR2,
281 P_global_attribute4 IN VARCHAR2,
282 P_global_attribute5 IN VARCHAR2,
283 P_global_attribute6 IN VARCHAR2,
284 P_global_attribute7 IN VARCHAR2,
285 P_global_attribute8 IN VARCHAR2,
286 P_global_attribute9 IN VARCHAR2,
287 P_global_attribute10 IN VARCHAR2,
288 P_global_attribute11 IN VARCHAR2,
289 P_global_attribute12 IN VARCHAR2,
290 P_global_attribute13 IN VARCHAR2,
291 P_global_attribute14 IN VARCHAR2,
292 P_global_attribute15 IN VARCHAR2,
293 P_global_attribute16 IN VARCHAR2,
294 P_global_attribute17 IN VARCHAR2,
295 P_global_attribute18 IN VARCHAR2,
296 P_global_attribute19 IN VARCHAR2,
297 P_global_attribute20 IN VARCHAR2,
298 P_bank_charge_bearer IN VARCHAR2) IS
299
300 CURSOR C_SUPPLIER_TYPE IS
301 SELECT POV.VENDOR_ID
302 FROM ap_suppliers POV , ZX_PARTY_TAX_PROFILE PTP
303 WHERE POV.VENDOR_ID = PTP.PARTY_ID
304 AND POV.VENDOR_ID = p_vendor_id
305 AND PTP.PARTY_TYPE_CODE = 'SUPPLIER'
306 AND VENDOR_TYPE_LOOKUP_CODE is not null
307 AND VENDOR_TYPE_LOOKUP_CODE <> 'TAX AUTHORITY';
308
309 l_party_tax_profile_id zx_party_tax_profile.party_tax_profile_id%type;
310 l_status fnd_module_installations.status%TYPE;
311 l_db_status fnd_module_installations.DB_STATUS%TYPE;
312
313 BEGIN
314
315 IF P_DML_TYPE = 'I' THEN
316 arp_util_tax.debug(' Insert of SYNC SUPPLIERS(+) ' );
317
318 INSERT INTO
319 ZX_PARTY_TAX_PROFILE(
320 Party_Tax_Profile_Id
321 ,Party_Id
322 ,Party_Type_code
323 ,Customer_Flag
324 ,First_Party_Le_Flag
325 ,Supplier_Flag
326 ,Site_Flag
327 ,Legal_Establishment_Flag
328 ,Rounding_Level_code
329 ,Process_For_Applicability_Flag
330 ,ROUNDING_RULE_CODE
331 ,Inclusive_Tax_Flag
332 ,Use_Le_As_Subscriber_Flag
333 ,Effective_From_Use_Le
334 ,Reporting_Authority_Flag
335 ,Collecting_Authority_Flag
336 ,PROVIDER_TYPE_CODE
337 ,RECORD_TYPE_CODE
338 ,TAX_CLASSIFICATION_CODE
339 ,Self_Assess_Flag
340 ,Allow_Offset_Tax_Flag
341 ,Created_By
342 ,Creation_Date
343 ,Last_Updated_By
344 ,Last_Update_Date
345 ,Last_Update_Login)
346 VALUES(
347 ZX_PARTY_TAX_PROFILE_S.NEXTVAL
348 ,P_VENDOR_ID -- Party ID
349 ,'SUPPLIER' -- Party Type
350 ,'N' -- Customer_Flag
351 ,'N' -- First Party
352 ,'Y' -- Suppliers
353 ,'N' -- Site
354 ,'N' -- Establishment
355 ,decode(nvl(p_auto_tax_calc_flag,'L'),'L','LINE','H','HEADER','T','HEADER','LINE')
356 ,decode(nvl(p_auto_tax_calc_flag, 'N'), 'N', 'N', 'Y')
357 ,DECODE (P_AP_TAX_ROUNDING_RULE,'N','NEAREST','D','DOWN','UP')
358 ,nvl(p_amount_includes_tax_flag,'N')
359 ,'N' -- Use_Le_As_Subscriber_Flag
360 ,NULL -- Effective_From_Use_Le
361 ,'N' -- Reporting Authority Flag
362 ,'N' -- Collecting Authority Flag
363 ,NULL -- Provider Type
364 ,'MIGRATED' -- Record Type
365 ,p_vat_code -- Tax Classification
366 ,'N' -- Self_Assess_Flag
367 ,nvl(p_offset_tax_flag,'N') -- Allow_Offset_Tax_Flag
368 ,fnd_global.user_id -- Who Columns
369 ,SYSDATE -- Who Columns
370 ,fnd_global.user_id -- Who Columns
371 ,SYSDATE -- Who Columns
372 ,FND_GLOBAL.CONC_LOGIN_ID); -- Who Columns
373
374
375 INSERT INTO
376 ZX_REGISTRATIONS(
377 Registration_Id,
378 Registration_Type_Code,
379 Registration_Number,
380 Registration_Status_Code,
381 Registration_Source_Code,
382 Registration_Reason_Code,
383 Party_Tax_Profile_Id,
384 Tax_Authority_Id,
385 Coll_Tax_Authority_Id,
386 Rep_Tax_Authority_Id,
387 Tax,
388 Tax_Regime_Code,
389 ROUNDING_RULE_CODE,
390 Tax_Jurisdiction_Code,
391 Self_Assess_Flag,
392 Inclusive_Tax_Flag,
393 Effective_From,
394 Effective_To,
395 Rep_Party_Tax_Name,
396 Legal_Registration_Id,
397 Default_Registration_Flag,
398 RECORD_TYPE_CODE,
399 Created_By,
400 Creation_Date,
401 Last_Updated_By,
402 Last_Update_Date,
403 Last_Update_Login)
404 (SELECT
405 ZX_REGISTRATIONS_S.NEXTVAL
406 ,Null -- Type
407 ,decode(p_GLOBAL_ATTRIBUTE_CATEGORY,
408 'JL.AR.APXVDMVD.SUPPLIERS',p_Global_Attribute12,
409 'JL.CL.APXVDMVD.SUPPLIERS',p_Global_Attribute12,
410 'JL.CO.APXVDMVD.SUPPLIERS',p_Global_Attribute12,
411 P_Vat_Registration_Num) -- Reg Number
412 --Bug # 3594759
413 ,decode(p_GLOBAL_ATTRIBUTE_CATEGORY,
414 'JL.AR.APXVDMVD.SUPPLIERS',p_Global_Attribute1,
415 'REGISTERED') -- Registration_Status_code
416 ,'EXPLICIT' -- Registration_Source_Code
417 ,NULL -- Registration_Reason_Code
418 ,PTP.Party_Tax_Profile_ID
419 ,NULL -- Tax Authority ID
420 ,NULL -- Collecting Tax Authority ID
421 ,NULL -- Reporting Tax Authority ID
422 ,NULL -- Tax
423 ,NULL -- TAX_Regime_Code
424 ,PTP.ROUNDING_RULE_CODE
425 ,NULL -- Tax Jurisdiction Code
426 , PTP.Self_Assess_Flag -- Self Assess
427 ,PTP.Inclusive_Tax_Flag
428 ,nvl(P_Start_Date_Active, Sysdate) -- Effective from
429 ,P_End_Date_Active -- Effective to
430 ,NULL -- Rep_Party_Tax_Name
431 ,NULL -- Legal Registration_ID
432 ,'Y' -- Default Registration Flag
433 ,'MIGRATED' -- Record Type
434 ,fnd_global.user_id
435 ,SYSDATE
436 ,fnd_global.user_id
437 ,SYSDATE
438 ,FND_GLOBAL.CONC_LOGIN_ID
439 FROM zx_party_tax_profile ptp
440 WHERE PTP.Party_ID = P_VENDOR_ID
441 AND PTP.Party_Type_code = 'SUPPLIER');
442
443 arp_util_tax.debug(' Now calling SUPPLIER_TYPE_EXTRACT ' );
444
445 SELECT PTP.PARTY_TAX_PROFILE_ID
446 INTO l_party_tax_profile_id
447 FROM ZX_PARTY_TAX_PROFILE PTP
448 WHERE PTP.PARTY_ID= P_VENDOR_ID
449 AND PTP.PARTY_TYPE_CODE = 'SUPPLIER'
450 AND P_Vendor_Type_Lookup_Code is not null
451 AND P_Vendor_Type_Lookup_Code <> 'TAX AUTHORITY' ;
452
453
454 ZX_PTP_MIGRATE_PKG.Party_Assoc_Extract
455 (p_party_source=>'ZX_PARTY_TAX_PROFILE',
456 p_party_tax_profile_id => l_party_tax_profile_id,
457 p_fiscal_class_type_code=> 'SUPPLIER_TYPE',
458 p_fiscal_classification_code=>P_Vendor_Type_Lookup_Code,
459 p_dml_type =>'I');
460
461
462
463 END IF; -- For P_DML_TYPE = 'I'
464
465 IF P_DML_TYPE = 'U' THEN
466
467 arp_util_tax.debug(' Update of SYNC SUPPLIERS (+) ' );
468
469
470 UPDATE ZX_PARTY_TAX_PROFILE
471 SET Rounding_Level_code =
472 decode(nvl(p_auto_tax_calc_flag,'L'),'L','LINE','H','HEADER','T','HEADER','LINE'),
473 Process_For_Applicability_Flag =
474 decode(nvl(p_auto_tax_calc_flag, 'N'), 'N', 'N', 'Y'),
475 ROUNDING_RULE_CODE=
476 DECODE (p_AP_TAX_ROUNDING_RULE,'N','NEAREST','D','DOWN','UP'),
477 Inclusive_Tax_Flag=
478 nvl(p_amount_includes_tax_flag,'N'),
479 TAX_CLASSIFICATION_CODE=
480 p_vat_code, -- Tax Classification
481 Allow_Offset_Tax_Flag=
482 nvl(p_Offset_Tax_Flag,'N'), -- Allow_Offset_Tax_Flag,
483 Last_updated_By=fnd_global.user_id,
484 Last_update_Date=SYSDATE,
485 Last_update_Login=FND_GLOBAL.CONC_LOGIN_ID
486 WHERE party_tax_profile_id=p_vendor_id and
487 party_type_code ='SUPPLIER';
488
489 UPDATE ZX_REGISTRATIONS
490 SET Registration_Number = decode(p_GLOBAL_ATTRIBUTE_CATEGORY,
491 'JL.AR.APXVDMVD.SUPPLIERS',p_Global_Attribute12,
492 'JL.CL.APXVDMVD.SUPPLIERS',p_Global_Attribute12,
493 'JL.CO.APXVDMVD.SUPPLIERS',p_Global_Attribute12,
494 P_Vat_Registration_Num) , -- Reg Number
495 Registration_Status_code = decode(p_GLOBAL_ATTRIBUTE_CATEGORY,
496 'JL.AR.APXVDMVD.SUPPLIERS',p_Global_Attribute1,
497 'REGISTERED') , -- Registration_Status_code
498 ROUNDING_RULE_CODE = decode(nvl(p_auto_tax_calc_flag,'L'),'L','LINE','H','HEADER','T','HEADER','LINE'),
499 Inclusive_Tax_Flag = nvl(p_amount_includes_tax_flag,'N'),
500 Effective_From = nvl(p_start_date_active, Sysdate),
501 Effective_To = p_end_date_active,
502 Last_Updated_By = fnd_global.user_id,
503 Last_Update_Date = SYSDATE,
504 Last_Update_Login = FND_GLOBAL.CONC_LOGIN_ID
505 WHERE Party_tax_profile_id in (select party_tax_profile_id
506 from zx_party_tax_profile where party_id
507 = p_vendor_id and party_type_code = 'SUPPLIER');
508
509
510 SELECT PTP.PARTY_TAX_PROFILE_ID
511 INTO l_party_tax_profile_id
512 FROM ZX_PARTY_TAX_PROFILE PTP
513 WHERE PTP.PARTY_ID= P_VENDOR_ID
514 AND PTP.PARTY_TYPE_CODE = 'SUPPLIER'
515 AND P_VENDOR_TYPE_LOOKUP_CODE is not null
516 AND P_VENDOR_TYPE_LOOKUP_CODE <> 'TAX AUTHORITY';
517
518
519 ZX_PTP_MIGRATE_PKG.Party_Assoc_Extract
520 (p_party_source=>'ZX_PARTY_TAX_PROFILE',
521 p_party_tax_profile_id => l_party_tax_profile_id,
522 p_fiscal_class_type_code=> 'SUPPLIER_TYPE',
523 p_fiscal_classification_code=>P_Vendor_Type_Lookup_Code,
524 p_dml_type =>'U');
525
526 END IF; -- For P_DML_TYPE = 'U'
527
528 arp_util_tax.debug(' SYNC_SUPPLIERS(-) ' );
529
530 EXCEPTION
531 WHEN OTHERS THEN
532 arp_util_tax.debug('Exception: Error Occurred during Supplier synchronization ..'||SQLERRM );
533
534 END SYNC_SUPPLIERS;
535
536
537 /* ==========================================================================*
538 | Procedure Name: SYNC_SUPPLIER_MERGE
539 | Product using
540 | this Procedure : Will be called by AP, from Suppliers Merge
541 |
542 |
543 | Purpose: Will be used to Synchronize the data between the Suppliers and
544 | eTax Party tax profile entity.
545 |
546 | Will be called fro Suppliers for passing the attributes
547 | required for synchronization.
548 |
549 | This stubbed version will do nothing.
550 |
551 | In later version of the same Procedure(delivered in ZX),
552 | it will be replaced with the actual solution for synchronizing data
553 | between the source (Suppliers) and eTax Party tax profile Gateway
554 | entity.
555 |
556 *==========================================================================*/
557
558 PROCEDURE SYNC_SUPPLIERS_MERGE
559 (
560 P_Dml_Type IN VARCHAR2,
561 P_Vendor_Id IN NUMBER,
562 P_End_Date_Active IN DATE,
563 P_Last_Update_Date IN DATE,
564 P_Last_Updated_By IN NUMBER
565 ) IS
566 BEGIN
567 NULL;
568 END SYNC_SUPPLIERS_MERGE;
569
570
571 /* ==========================================================================*
572 | Procedure Name: SYNC_SUPPLIER_SITES
573 | Product using
574 | this Procedure : Will be called by AP, from Suppliers Form
575 |
576 |
577 | Purpose: Will be used to Synchronize the data between the Suppliers and
578 | eTax Party tax profile Gateway entity.
579 |
580 | Will be called fro Suppliers for passing the attributes
581 | required for synchronization.
582 |
583 | This stubbed version will do nothing.
584 |
585 | In later version of the sa e Procedure(delivered in ZX),
586 | it will be replaced with the actual solution for synchronizing data
587 | between the source (Suppliers) and eTax Party tax profile Gateway
588 | entity.
589 |
590 *==========================================================================*/
591
592 PROCEDURE SYNC_SUPPLIER_SITES
593 (
594 P_Dml_Type IN VARCHAR2,
595 P_Vendor_Site_Id IN NUMBER,
596 P_Last_Update_Date IN DATE,
597 P_Last_Updated_By IN NUMBER,
598 P_Vendor_Id IN NUMBER,
599 P_Vendor_Site_Code IN VARCHAR2,
600 P_Last_Update_Login IN NUMBER,
601 P_Creation_Date IN DATE,
602 P_Created_By IN NUMBER,
603 P_Purchasing_Site_Flag IN VARCHAR2,
604 P_Rfq_Only_Site_Flag IN VARCHAR2,
605 P_Pay_Site_Flag IN VARCHAR2,
606 P_Attention_Ar_Flag IN VARCHAR2,
607 P_Address_Line1 IN VARCHAR2,
608 P_Address_Line2 IN VARCHAR2,
609 P_Address_Line3 IN VARCHAR2,
610 P_City IN VARCHAR2,
611 P_State IN VARCHAR2,
612 P_Zip IN VARCHAR2,
613 P_Province IN VARCHAR2,
614 P_Country IN VARCHAR2,
615 P_Area_Code IN VARCHAR2,
616 P_Phone IN VARCHAR2,
617 P_Customer_Num IN VARCHAR2,
618 P_Ship_To_Location_Id IN NUMBER,
619 P_Bill_To_Location_Id IN NUMBER,
620 P_Ship_Via_Lookup_Code IN VARCHAR2,
621 P_Freight_Terms_Lookup_Code IN VARCHAR2,
622 P_Fob_Lookup_Code IN VARCHAR2,
623 P_Inactive_Date IN DATE,
624 P_Fax IN VARCHAR2,
625 P_Fax_Area_Code IN VARCHAR2,
626 P_Telex IN VARCHAR2,
627 P_Payment_Method_Lookup_Code IN VARCHAR2,
628 P_Bank_Account_Name IN VARCHAR2,
629 P_Bank_Account_Num IN VARCHAR2,
630 P_Bank_Num IN VARCHAR2,
631 P_Bank_Account_Type IN VARCHAR2,
632 P_Terms_Date_Basis IN VARCHAR2,
633 P_Current_Catalog_Num IN VARCHAR2,
634 P_Vat_Code IN VARCHAR2,
635 P_Distribution_Set_Id IN NUMBER,
636 P_Accts_Pay_CCID IN NUMBER,
637 P_Future_Dated_Payment_CCID IN NUMBER,
638 P_Prepay_Code_Combination_Id IN NUMBER,
639 P_Pay_Group_Lookup_Code IN VARCHAR2,
640 P_Payment_Priority IN NUMBER,
641 P_Terms_Id IN NUMBER,
642 P_Invoice_Amount_Limit IN NUMBER,
643 P_Pay_Date_Basis_Lookup_Code IN VARCHAR2,
644 P_Always_Take_Disc_Flag IN VARCHAR2,
645 P_Invoice_Currency_Code IN VARCHAR2,
646 P_Payment_Currency_Code IN VARCHAR2,
647 P_Hold_All_Payments_Flag IN VARCHAR2,
648 P_Hold_Future_Payments_Flag IN VARCHAR2,
649 P_Hold_Reason IN VARCHAR2,
650 P_Hold_Unmatched_Invoices_Flag IN VARCHAR2,
651 P_Match_Option IN VARCHAR2,
652 P_create_debit_memo_flag IN VARCHAR2,
653 P_Exclusive_Payment_Flag IN VARCHAR2,
654 P_Tax_Reporting_Site_Flag IN VARCHAR2,
655 P_Attribute_Category IN VARCHAR2,
656 P_Attribute1 IN VARCHAR2,
657 P_Attribute2 IN VARCHAR2,
658 P_Attribute3 IN VARCHAR2,
659 P_Attribute4 IN VARCHAR2,
660 P_Attribute5 IN VARCHAR2,
661 P_Attribute6 IN VARCHAR2,
662 P_Attribute7 IN VARCHAR2,
663 P_Attribute8 IN VARCHAR2,
664 P_Attribute9 IN VARCHAR2,
665 P_Attribute10 IN VARCHAR2,
666 P_Attribute11 IN VARCHAR2,
667 P_Attribute12 IN VARCHAR2,
668 P_Attribute13 IN VARCHAR2,
669 P_Attribute14 IN VARCHAR2,
670 P_Attribute15 IN VARCHAR2,
671 P_Validation_Number IN NUMBER,
672 P_Exclude_Freight_From_Disc IN VARCHAR2,
673 P_Vat_Registration_Num IN VARCHAR2,
674 P_Offset_Tax_Flag IN VARCHAR2,
675 P_Check_Digits IN VARCHAR2,
676 P_Bank_Number IN VARCHAR2,
677 P_Address_Line4 IN VARCHAR2,
678 P_County IN VARCHAR2,
679 P_Address_Style IN VARCHAR2,
680 P_Language IN VARCHAR2,
681 P_Allow_Awt_Flag IN VARCHAR2,
682 P_Awt_Group_Id IN NUMBER,
683 P_pay_on_code IN VARCHAR2,
684 P_default_pay_site_id IN NUMBER,
685 P_pay_on_receipt_summary_code IN VARCHAR2,
686 P_Bank_Branch_Type IN VARCHAR2,
687 P_EDI_ID_Number IN VARCHAR2,
688 P_EDI_Payment_Method IN VARCHAR2,
689 P_EDI_Payment_Format IN VARCHAR2,
690 P_EDI_Remittance_Method IN VARCHAR2,
691 P_EDI_Remittance_Instruction IN VARCHAR2,
692 P_EDI_transaction_handling IN VARCHAR2,
693 P_Auto_Tax_Calc_Flag IN VARCHAR2,
694 P_Auto_Tax_Calc_Override IN VARCHAR2,
695 P_Amount_Includes_Tax_Flag IN VARCHAR2,
696 P_AP_Tax_Rounding_Rule IN VARCHAR2,
697 P_Vendor_Site_Code_Alt IN VARCHAR2,
698 P_Address_Lines_Alt IN VARCHAR2,
699 P_global_attribute_category IN VARCHAR2,
700 P_global_attribute1 IN VARCHAR2,
701 P_global_attribute2 IN VARCHAR2,
702 P_global_attribute3 IN VARCHAR2,
703 P_global_attribute4 IN VARCHAR2,
704 P_global_attribute5 IN VARCHAR2,
705 P_global_attribute6 IN VARCHAR2,
706 P_global_attribute7 IN VARCHAR2,
707 P_global_attribute8 IN VARCHAR2,
708 P_global_attribute9 IN VARCHAR2,
709 P_global_attribute10 IN VARCHAR2,
710 P_global_attribute11 IN VARCHAR2,
711 P_global_attribute12 IN VARCHAR2,
712 P_global_attribute13 IN VARCHAR2,
713 P_global_attribute14 IN VARCHAR2,
714 P_global_attribute15 IN VARCHAR2,
715 P_global_attribute16 IN VARCHAR2,
716 P_global_attribute17 IN VARCHAR2,
717 P_global_attribute18 IN VARCHAR2,
718 P_global_attribute19 IN VARCHAR2,
719 P_global_attribute20 IN VARCHAR2,
720 P_bank_charge_bearer IN VARCHAR2,
721 P_ece_tp_location_code IN VARCHAR2,
722 P_Pcard_Site_Flag IN VARCHAR2,
723 P_Country_of_Origin_Code IN VARCHAR2,
724 P_Shipping_Location_id IN NUMBER,
725 P_Supplier_Notif_Method IN VARCHAR2,
726 P_Email_Address IN VARCHAR2,
727 P_Remittance_email IN VARCHAR2,
728 P_primary_pay_site_flag IN VARCHAR2,
729 P_Shipping_Control IN VARCHAR2) IS
730
731 l_Global_Attribute10 po_vendors.Global_Attribute10%type;
732 l_Global_Attribute11 po_vendors.Global_Attribute11%type;
733 l_Global_Attribute12 po_vendors.Global_Attribute12%type;
734 l_Global_Attribute13 po_vendors.Global_Attribute13%type;
735 l_Global_Attribute14 po_vendors.Global_Attribute14%type;
736
737
738 BEGIN
739
740
741 IF P_DML_TYPE = 'I' THEN
742 arp_util_tax.debug(' SYNC_SUPPLIER_SITES(+) ' );
743
744 INSERT INTO ZX_PARTY_TAX_PROFILE(
745 Party_Tax_Profile_Id
746 ,Party_Id
747 ,Party_Type_code
748 ,Customer_Flag
749 ,First_Party_Le_Flag
750 ,Supplier_Flag
751 ,Site_Flag
752 ,Legal_Establishment_Flag
753 ,Rounding_Level_code
754 ,Process_For_Applicability_Flag
755 ,ROUNDING_RULE_CODE
756 ,Inclusive_Tax_Flag
757 ,Use_Le_As_Subscriber_Flag
758 ,Effective_From_Use_Le
759 ,Reporting_Authority_Flag
760 ,Collecting_Authority_Flag
761 ,PROVIDER_TYPE_CODE
762 ,RECORD_TYPE_CODE
763 ,TAX_CLASSIFICATION_CODE
764 ,Self_Assess_Flag
765 ,Allow_Offset_Tax_Flag
766 ,Created_By
767 ,Creation_Date
768 ,Last_Updated_By
769 ,Last_Update_Date
770 ,Last_Update_Login)
771 SELECT
772 ZX_PARTY_TAX_PROFILE_S.NEXTVAL
773 ,p_VENDOR_SITE_ID -- Party ID
774 ,'SUPPLIER_SITE' -- Party Type
775 ,'N' -- Customer_Flag
776 ,'N' -- First Party
777 ,'N' -- Suppliers
778 ,'Y' -- Site
779 ,'N' -- Establishment
780 ,decode(nvl(p_auto_tax_calc_flag,'L'),'L','LINE','H','HEADER','T','HEADER','LINE')
781 ,decode(nvl(p_auto_tax_calc_flag, 'N'), 'N', 'N', 'Y')
782 , DECODE (p_AP_TAX_ROUNDING_RULE,'N','NEAREST',
783 'D','DOWN', 'UP')
784 , nvl(p_amount_includes_tax_flag, 'N')
785 ,'N' -- Use_Le_As_Subscriber_Flag
786 , NULL -- Effective_From_Use_Le
787 ,'N' -- Reporting Authority Flag
788 ,'N' -- Collecting Authority Flag
789 ,NULL -- Provider Type
790 ,'MIGRATED' -- Record Type
791 ,p_vat_code -- Tax Classification
792 ,'N' -- Self_Assess_Flag
793 , nvl(pv.offset_tax_flag,'N') -- Allow_Offset_Tax_Flag
794 , fnd_global.user_id -- Who Columns
795 ,SYSDATE -- Who Columns
796 ,fnd_global.user_id -- Who Columns
797 ,SYSDATE -- Who Columns
798 ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns
799 FROM ap_suppliers Pv
800 WHERE p_Vendor_Site_Id = nvl(P_vendor_site_Id,p_Vendor_site_Id)
801 AND p_vendor_id = pv.vendor_id
802 AND pv.VENDOR_TYPE_LOOKUP_CODE <> 'TAX AUTHORITY';
803
804
805 INSERT INTO ZX_REGISTRATIONS(
806 Registration_Id,
807 Registration_Type_Code,
808 Registration_Number,
809 Registration_Status_Code,
810 Registration_Source_Code,
811 Registration_Reason_Code,
812 Party_Tax_Profile_Id,
813 Tax_Authority_Id,
814 Coll_Tax_Authority_Id,
815 Rep_Tax_Authority_Id,
816 Tax,
817 Tax_Regime_Code,
818 ROUNDING_RULE_CODE,
819 Tax_Jurisdiction_Code,
820 Self_Assess_Flag,
821 Inclusive_Tax_Flag,
822 Effective_From,
823 Effective_To,
824 Rep_Party_Tax_Name,
825 Legal_Registration_Id,
826 Default_Registration_Flag,
827 RECORD_TYPE_CODE,
828 Created_By,
829 Creation_Date,
830 Last_Updated_By,
831 Last_Update_Date,
832 Last_Update_Login)
833 (SELECT
834 ZX_REGISTRATIONS_S.NEXTVAL
835 ,NULL -- Registration type code
836 ,P_Vat_Registration_Num --Reg Number
837 ,'REGISTERED' -- Registration_Status_code
838 ,'EXPLICIT' -- Registration_Source_Code
839 ,NULL -- Registration_Reason_Code
840 ,PTP.Party_Tax_Profile_ID
841 ,NULL -- Tax Authority ID
842 ,NULL -- Collecting Tax Authority ID
843 ,NULL -- Reporting Tax Authority ID
844 ,NULL -- Tax
845 ,NULL -- TAX_Regime_Code
846 ,PTP.ROUNDING_RULE_CODE
847 , NULL -- Tax Jurisdiction Code
848 , PTP.Self_Assess_Flag -- Self Assess
849 ,PTP.Inclusive_Tax_Flag
850 ,nvl(PV.Start_Date_Active, Sysdate) -- Effective from
851 ,PV.End_Date_Active -- Effective to
852 ,NULL -- Rep_Party_Tax_Name
853 ,NULL -- Legal Registration_ID
854 ,'Y' -- Default Registration Flag
855 ,'MIGRATED' -- Record Type
856 ,fnd_global.user_id
857 ,SYSDATE
858 ,fnd_global.user_id
859 ,SYSDATE
860 ,FND_GLOBAL.CONC_LOGIN_ID
861 FROM ap_suppliers PV,
862 zx_party_tax_profile PTP
863 WHERE
864 P_vendor_site_id = PTP.Party_ID
865 AND PTP.Party_Type_code = 'SUPPLIER_SITE'
866 AND P_Vendor_ID = PV.Vendor_ID);
867
868
869 -- Verify Argentina Installation
870 IF (p_GLOBAL_ATTRIBUTE_CATEGORY='JL.AR.APXVDMVD.SUPPLIER_SITES') THEN
871
872 -- Code for Reporting Code Association. Bug # 3594759
873 -- Insert the Fiscal Printer Codes into Association table
874
875 INSERT INTO ZX_REPORT_CODES_ASSOC(
876 REPORTING_CODE_ASSOC_ID,
877 ENTITY_CODE,
878 ENTITY_ID,
879 REPORTING_TYPE_ID,
880 REPORTING_CODE_CHAR_VALUE,
881 EXCEPTION_CODE,
882 EFFECTIVE_FROM,
883 EFFECTIVE_TO,
884 CREATED_BY,
885 CREATION_DATE,
886 LAST_UPDATED_BY,
887 LAST_UPDATE_DATE,
888 LAST_UPDATE_LOGIN)
889 (SELECT
890 ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
891 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
892 ptp.Party_Tax_Profile_Id, --ENTITY_ID
893 REPORTING_TYPE_ID , --REPORTING_TYPE_ID
894 p_GLOBAL_ATTRIBUTE18, --REPORTING_CODE_CHAR_VALUE
895 null, --EXCEPTION_CODE
896 sysdate, --EFFECTIVE_FROM
897 null, --EFFECTIVE_TO
898 fnd_global.user_id,
899 sysdate,
900 fnd_global.user_id,
901 sysdate,
902 fnd_global.conc_login_id
903 FROM zx_party_tax_profile ptp ,
904 zx_reporting_types_b
905 WHERE ptp.party_id = p_vendor_site_id and
906 ptp.Party_Type_Code = 'SUPPLIER_SITE' and
907 reporting_type_code = 'FISCAL PRINTER');
908
909 -- Insert the CAI Number and Date into Association table
910
911 INSERT INTO ZX_REPORT_CODES_ASSOC(
912 REPORTING_CODE_ASSOC_ID,
913 ENTITY_CODE,
914 ENTITY_ID,
915 REPORTING_TYPE_ID ,
916 REPORTING_CODE_NUM_VALUE,
917 EXCEPTION_CODE,
918 EFFECTIVE_FROM,
919 EFFECTIVE_TO,
920 CREATED_BY,
921 CREATION_DATE,
922 LAST_UPDATED_BY,
923 LAST_UPDATE_DATE,
924 LAST_UPDATE_LOGIN)
925 (SELECT
926 ZX_REPORT_CODES_ASSOC_S.nextval, --REPORTING_CODE_ASSOC_ID
927 'ZX_PARTY_TAX_PROFILE', --ENTITY_CODE
928 ptp.Party_Tax_Profile_Id, --ENTITY_ID
929 REPORTING_TYPE_ID, --REPORTING_TYPE_ID
930 p_GLOBAL_ATTRIBUTE19, --REPORTING_CODE_NUM_VALUE
931 null, --EXCEPTION_CODE
932 sysdate, --EFFECTIVE_FROM
933 p_GLOBAL_ATTRIBUTE20, --EFFECTIVE_TO
934 fnd_global.user_id,
935 sysdate,
936 fnd_global.user_id,
937 sysdate,
938 fnd_global.conc_login_id
939 FROM zx_party_tax_profile ptp ,
940 zx_reporting_types_b
941 WHERE ptp.party_id = p_vendor_site_id and
942 ptp.Party_Type_Code = 'SUPPLIER_SITE' and
943 reporting_type_code = 'CAI NUMBER');
944
945 END IF; -- end of Argentina Installation verification
946
947 IF (p_GLOBAL_ATTRIBUTE_CATEGORY = 'JL.BR.APXVDMVD.SITES') THEN
948
949 -- Inserts Records for CNPJ
950
951 INSERT INTO ZX_REGISTRATIONS(
952 Registration_Id,
953 Registration_Type_Code,
954 Registration_Number,
955 Registration_Status_Code,
956 Registration_Source_Code,
957 Registration_Reason_Code,
958 Party_Tax_Profile_Id,
959 Tax_Authority_Id,
960 Coll_Tax_Authority_Id,
961 Rep_Tax_Authority_Id,
962 Tax,
963 Tax_Regime_Code,
964 ROUNDING_RULE_CODE,
965 Tax_Jurisdiction_Code,
966 Self_Assess_Flag,
967 Inclusive_Tax_Flag,
968 Effective_From,
969 Effective_To,
970 Rep_Party_Tax_Name,
971 Legal_Registration_Id,
972 Default_Registration_Flag,
973 RECORD_TYPE_CODE,
974 Created_By,
975 Creation_Date,
976 Last_Updated_By,
977 Last_Update_Date,
978 Last_Update_Login)
979 (SELECT
980 ZX_REGISTRATIONS_S.NEXTVAL
981 ,'CNPJ' -- Type
982 ,p_Global_Attribute10 ||' / '|| p_Global_Attribute11 ||' / '|| p_Global_Attribute12 --Reg Number
983 ,'REGISTERED' -- Registration_Status_code
984 ,'EXPLICIT'
985 ,NULL -- Registration_Reason_Code
986 ,PTP.Party_Tax_Profile_ID
987 ,NULL -- Tax Authority ID
988 ,NULL -- Collecting Tax Authority ID
989 ,NULL -- Reporting Tax Authority ID
990 ,NULL -- Tax
991 ,'BR-IPI' -- Tax_Regime_Code
992 ,PTP.ROUNDING_RULE_CODE
993 , NULL -- Tax Jurisdiction Code
994 , PTP.Self_Assess_Flag -- Self Assess
995 ,PTP.Inclusive_Tax_Flag
996 ,nvl(PV.Start_Date_Active, Sysdate) -- Effective from
997 ,PV.End_Date_Active -- Effective to
998 ,NULL -- Rep_Party_Tax_Name
999 ,NULL -- Legal Registration_ID
1000 ,'Y' -- Default Registration Flag
1001 ,'MIGRATED' -- Record Type
1002 ,fnd_global.user_id
1003 ,SYSDATE
1004 ,fnd_global.user_id
1005 ,SYSDATE
1006 ,FND_GLOBAL.CONC_LOGIN_ID
1007 FROM ap_supplier_sites_all PVS,
1008 ap_suppliers PV,
1009 zx_party_tax_profile PTP
1010 WHERE p_vendor_site_id = PTP.Party_ID
1011 AND PTP.Party_Type_code = 'SUPPLIER_SITE'
1012 AND p_Vendor_ID = PV.Vendor_ID);
1013
1014
1015 -- Inserts Records for State Inscription
1016
1017 INSERT INTO ZX_REGISTRATIONS(
1018 Registration_Id,
1019 Registration_Type_Code,
1020 Registration_Number,
1021 Registration_Status_Code,
1022 Registration_Source_Code,
1023 Registration_Reason_Code,
1024 Party_Tax_Profile_Id,
1025 Tax_Authority_Id,
1026 Coll_Tax_Authority_Id,
1027 Rep_Tax_Authority_Id,
1028 Tax,
1029 Tax_Regime_Code,
1030 ROUNDING_RULE_CODE,
1031 Tax_Jurisdiction_Code,
1032 Self_Assess_Flag,
1033 Inclusive_Tax_Flag,
1034 Effective_From,
1035 Effective_To,
1036 Rep_Party_Tax_Name,
1037 Legal_Registration_Id,
1038 Default_Registration_Flag,
1039 RECORD_TYPE_CODE,
1040 Created_By,
1041 Creation_Date,
1042 Last_Updated_By,
1043 Last_Update_Date,
1044 Last_Update_Login)
1045 SELECT
1046 ZX_REGISTRATIONS_S.NEXTVAL
1047 ,'STATE INSCRIPTION' -- Type
1048 ,p_Global_Attribute13 -- State Registration Num
1049 ,'REGISTERED' -- Registration_Status_Code
1050 ,'EXPLICIT'
1051 ,NULL -- Registration_Reason_Code
1052 ,PTP.Party_Tax_Profile_ID
1053 ,NULL -- Tax Authority ID
1054 ,NULL -- Collecting Tax Authority ID
1055 ,NULL -- Reporting Tax Authority ID
1056 ,NULL -- Tax
1057 ,'BR-ICMS' -- Tax_Regime_Code
1058 ,PTP.ROUNDING_RULE_CODE
1059 , NULL -- Tax Jurisdiction Code
1060 , PTP.Self_Assess_Flag -- Self Asses
1061 ,PTP.Inclusive_Tax_Flag
1062 ,nvl(PV.Start_Date_Active, Sysdate) -- Effective from
1063 ,PV.End_Date_Active -- Effective To
1064 ,NULL -- Rep_Party_Tax_Name
1065 ,NULL -- Legal Registration_ID
1066 ,'N' -- Default Registration Flag
1067 ,'MIGRATED' -- Record Type
1068 ,fnd_global.user_id
1069 ,SYSDATE
1070 ,fnd_global.user_id
1071 ,SYSDATE
1072 ,FND_GLOBAL.CONC_LOGIN_ID
1073 FROM ap_suppliers PV,
1074 zx_party_tax_profile PTP
1075 WHERE p_vendor_site_id = PTP.Party_ID
1076 AND PTP.Party_Type_code = 'SUPPLIER_SITE'
1077 AND p_Vendor_ID = PV.Vendor_ID;
1078
1079 -- Inserts Records for Municipal Inscription
1080
1081 INSERT INTO ZX_REGISTRATIONS(
1082 Registration_Id,
1083 Registration_Type_Code,
1084 Registration_Number,
1085 Registration_Status_Code,
1086 Registration_Source_Code,
1087 Registration_Reason_Code,
1088 Party_Tax_Profile_Id,
1089 Tax_Authority_Id,
1090 Coll_Tax_Authority_Id,
1091 Rep_Tax_Authority_Id,
1092 Tax,
1093 Tax_Regime_Code,
1094 ROUNDING_RULE_CODE,
1095 Tax_Jurisdiction_Code,
1096 Self_Assess_Flag,
1097 Inclusive_Tax_Flag,
1098 Effective_From,
1099 Effective_To,
1100 Rep_Party_Tax_Name,
1101 Legal_Registration_Id,
1102 Default_Registration_Flag,
1103 RECORD_TYPE_CODE,
1104 Created_By,
1105 Creation_Date,
1106 Last_Updated_By,
1107 Last_Update_Date,
1108 Last_Update_Login)
1109 (SELECT
1110 ZX_REGISTRATIONS_S.NEXTVAL
1111 ,'CITY INSCRIPTION' -- Type
1112 ,p_Global_Attribute14 -- City Registration Num
1113 ,'REGISTERED' -- Registration_Status_Code
1114 ,'EXPLICIT'
1115 ,NULL -- Registration_Reason_Code
1116 ,PTP.Party_Tax_Profile_ID
1117 ,NULL -- Tax Authority ID
1118 ,NULL -- Collecting Tax Authority ID
1119 ,NULL -- Reporting Tax Authority ID
1120 ,NULL -- Tax
1121 ,'BR-ISS' -- Tax_Regime_Code
1122 ,PTP.ROUNDING_RULE_CODE
1123 ,NULL -- Tax Jurisdiction Code
1124 ,PTP.Self_Assess_Flag -- Self Asses
1125 ,PTP.Inclusive_Tax_Flag
1126 ,nvl(PV.Start_Date_Active, Sysdate) -- Effective from
1127 ,PV.End_Date_Active -- Effective To
1128 ,NULL -- Rep_Party_Tax_Name
1129 ,NULL -- Legal Registration_ID
1130 ,'N' -- Default Registration Flag
1131 ,'MIGRATED' -- Record Type
1132 ,fnd_global.user_id
1133 ,SYSDATE
1134 ,fnd_global.user_id
1135 ,SYSDATE
1136 ,FND_GLOBAL.CONC_LOGIN_ID
1137 FROM ap_supplier_sites_all PVS,
1138 ap_suppliers PV,
1139 zx_party_tax_profile PTP
1140 WHERE p_vendor_site_id = PTP.Party_ID
1141 AND PTP.Party_Type_code = 'SUPPLIER_SITE'
1142 AND p_Vendor_ID = PV.Vendor_ID);
1143
1144
1145 END IF; -- Brazil Localizations
1146
1147 END IF; -- End for insert mode
1148
1149 IF P_DML_TYPE = 'U' THEN
1150
1151 arp_util_tax.debug(' Update of SYNC_SUPPLIER_SITES(+) ' );
1152
1153
1154 UPDATE ZX_PARTY_TAX_PROFILE
1155 SET
1156 Rounding_Level_code= decode(nvl(p_auto_tax_calc_flag,'L'),'L','LINE','H','HEADER','T','HEADER','LINE'),
1157 Process_For_Applicability_Flag =
1158 decode(nvl(p_auto_tax_calc_flag, 'N'), 'N', 'N', 'Y'),
1159 ROUNDING_RULE_CODE=
1160 DECODE (p_AP_TAX_ROUNDING_RULE,'N','NEAREST','D','DOWN', 'UP'),
1161 Inclusive_Tax_Flag=nvl(p_amount_includes_tax_flag, 'N'),
1162 TAX_CLASSIFICATION_CODE=p_vat_code, -- Tax Classification
1163 Allow_Offset_Tax_Flag =nvl(p_offset_tax_flag,'N'), -- Allow_Offset_Tax_Flag
1164 Last_Updated_By=fnd_global.user_id,
1165 Last_Update_Date=SYSDATE,
1166 Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1167 WHERE party_tax_profile_id= p_VENDOR_SITE_ID
1168 and party_TYPE_CODE = 'SUPPLIER_SITE'
1169 and p_vendor_id in ( SELECT vendor_id
1170 FROM ap_suppliers
1171 WHERE p_vendor_id = p_vendor_id
1172 AND VENDOR_TYPE_LOOKUP_CODE <> 'TAX AUTHORITY' );
1173
1174
1175 SELECT global_attribute10,global_attribute11,global_attribute12,global_attribute13,global_attribute14
1176 INTO l_global_attribute10,l_global_attribute11,l_global_attribute12,l_global_attribute13,l_global_attribute14
1177 FROM ap_suppliers
1178 WHERE vendor_id=p_Vendor_id;
1179
1180
1181 UPDATE ZX_REGISTRATIONS
1182 SET Registration_Number = P_Vat_Registration_Num, -- Reg Number
1183 ROUNDING_RULE_CODE = DECODE (p_AP_TAX_ROUNDING_RULE,'N','NEAREST','D','DOWN', 'UP'),
1184 Inclusive_Tax_Flag=nvl(p_amount_includes_tax_flag, 'N'),
1185 Last_Updated_By=fnd_global.user_id,
1186 Last_Update_Date=SYSDATE,
1187 Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1188 WHERE Party_tax_profile_id in (select party_tax_profile_id
1189 from zx_party_tax_profile where party_id
1190 = p_vendor_site_id and party_type_code = 'SUPPLIER_SITE');
1191
1192
1193 -- Verify Argentina Installation
1194
1195 IF (p_GLOBAL_ATTRIBUTE_CATEGORY='JL.AR.APXVDMVD.SUPPLIER_SITES') THEN
1196
1197
1198 -- Code for Reporting Code Association. Bug # 3594759
1199 -- Update the Fiscal Printer Codes into Association table
1200
1201 UPDATE ZX_REPORT_CODES_ASSOC
1202 SET REPORTING_CODE_CHAR_VALUE = p_GLOBAL_ATTRIBUTE18,
1203 LAST_UPDATED_BY = fnd_global.user_id,
1204 LAST_UPDATE_DATE = sysdate,
1205 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
1206 WHERE ENTITY_CODE = 'ZX_PARTY_TAX_PROFILE' AND
1207 REPORTING_TYPE_ID = (SELECT REPORTING_TYPE_ID
1208 FROM ZX_REPORTING_TYPES_B
1209 WHERE REPORTING_TYPE_CODE ='FISCAL PRINTER')
1210 AND ENTITY_ID in (SELECT Party_Tax_Profile_Id
1211 FROM zx_party_tax_profile ptp
1212 WHERE ptp.party_id = p_vendor_site_id
1213 AND ptp.Party_Type_Code = 'SUPPLIER_SITE');
1214
1215
1216 -- Update the CAI Number and Date into Association table
1217
1218 UPDATE ZX_REPORT_CODES_ASSOC
1219 SET REPORTING_CODE_NUM_VALUE = p_GLOBAL_ATTRIBUTE19,
1220 EFFECTIVE_TO = p_GLOBAL_ATTRIBUTE20,
1221 LAST_UPDATED_BY = fnd_global.user_id,
1222 LAST_UPDATE_DATE = sysdate,
1223 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
1224 WHERE ENTITY_CODE = 'ZX_PARTY_TAX_PROFILE' AND
1225 REPORTING_TYPE_ID = (SELECT REPORTING_TYPE_ID
1226 FROM ZX_REPORTING_TYPES_B
1227 WHERE REPORTING_TYPE_CODE ='CAI NUMBER')
1228 AND ENTITY_ID in (SELECT Party_Tax_Profile_Id
1229 FROM zx_party_tax_profile ptp
1230 WHERE ptp.party_id = p_vendor_site_id
1231 AND ptp.Party_Type_Code = 'SUPPLIER_SITE');
1232
1233 END IF; -- end of Argentina Installation verification
1234
1235
1236 IF (p_GLOBAL_ATTRIBUTE_CATEGORY = 'JL.BR.APXVDMVD.SITES') THEN
1237
1238 -- Updates Records for CNPJ
1239
1240 UPDATE ZX_REGISTRATIONS
1241 SET Registration_Number = p_Global_Attribute10||' / '||p_Global_Attribute11||' / '||p_Global_Attribute12, --Reg Num
1242 Tax_Regime_Code = 'BR-IPI',
1243 ROUNDING_RULE_CODE= DECODE (p_AP_TAX_ROUNDING_RULE,'N','NEAREST','D','DOWN', 'UP'),
1244 Inclusive_Tax_Flag=nvl(p_amount_includes_tax_flag, 'N'),
1245 Last_Updated_By=fnd_global.user_id,
1246 Last_Update_Date=SYSDATE,
1247 Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1248 WHERE Party_tax_profile_id in (select party_tax_profile_id
1249 from zx_party_tax_profile where party_id
1250 = p_vendor_site_id and party_type_code = 'SUPPLIER_SITE');
1251
1252
1253 -- Updates Records for State Inscription
1254
1255 UPDATE ZX_REGISTRATIONS
1256 SET Registration_Number = p_Global_Attribute13,-- State Registration Num,
1257 Tax_Regime_Code = 'BR-ICMS',
1258 ROUNDING_RULE_CODE = DECODE (p_AP_TAX_ROUNDING_RULE,'N','NEAREST','D','DOWN', 'UP'),
1259 Inclusive_Tax_Flag =nvl(p_amount_includes_tax_flag, 'N'),
1260 Last_Updated_By=fnd_global.user_id,
1261 Last_Update_Date=SYSDATE,
1262 Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1263 WHERE Party_tax_profile_id in (select party_tax_profile_id
1264 from zx_party_tax_profile where party_id
1265 = p_vendor_site_id and party_type_code = 'SUPPLIER_SITE');
1266
1267
1268 -- Updates Records for Municipal Inscription
1269
1270 UPDATE ZX_REGISTRATIONS
1271 SET Registration_Number = p_Global_Attribute14,-- City Registration Num,
1272 Tax_Regime_Code = 'BR-ISS',
1273 ROUNDING_RULE_CODE = DECODE (p_AP_TAX_ROUNDING_RULE,'N','NEAREST','D','DOWN', 'UP'),
1274 Inclusive_Tax_Flag =nvl(p_amount_includes_tax_flag, 'N'),
1275 Last_Updated_By=fnd_global.user_id,
1276 Last_Update_Date=SYSDATE,
1277 Last_Update_Login=FND_GLOBAL.CONC_LOGIN_ID
1278 WHERE Party_tax_profile_id in (select party_tax_profile_id
1279 from zx_party_tax_profile where party_id
1280 = p_vendor_site_id and party_type_code = 'SUPPLIER_SITE');
1281
1282
1283 END IF; -- Brazil Localizations
1284
1285 END IF; -- End of p_dml_type = update
1286
1287 arp_util_tax.debug(' SYNC_SUPPLIER_SITES(-) ' );
1288
1289 EXCEPTION
1290 WHEN OTHERS THEN
1291 arp_util_tax.debug('Exception: Error Occurred during Supplier sites Extract in PTP/REGISTRATIONS Migration '||SQLERRM );
1292
1293 END SYNC_SUPPLIER_SITES;
1294
1295 /* ==========================================================================*
1296 | Procedure Name: SYNC_SUPPLIER_SITES_MERGE
1297 | Product using
1298 | this Procedure : Will be called by AP, from Suppliers Merge
1299 |
1300 |
1301 | Purpose: Will be used to Synchronize the data between the Suppliers and
1302 | eTax Party tax profile entity.
1303 |
1304 | Will be called fro Suppliers for passing the attributes
1305 | required for synchronization.
1306 |
1307 | This stubbed version will do nothing.
1308 |
1309 | In later version of the sa e Procedure(delivered in ZX),
1310 | it will be replaced with the actual solution for synchronizing data
1311 | between the source (Suppliers) and eTax Party tax profile Gateway
1312 | entity.
1313 |
1314 *==========================================================================*/
1315
1316 PROCEDURE SYNC_SUPPLIER_SITES_MERGE
1317 (
1318 P_Dml_Type IN VARCHAR2,
1319 P_Vendor_Site_Id IN NUMBER,
1320 P_Inactive_Date IN DATE,
1321 P_Primary_Pay_Site_Flag IN VARCHAR2,
1322 P_Tax_Reporting_Site_Flag IN VARCHAR2,
1323 P_Last_Update_Date IN DATE,
1324 P_Last_Updated_By IN NUMBER
1325 ) IS
1326 BEGIN
1327
1328 NULL;
1329 END SYNC_SUPPLIER_SITES_MERGE;
1330
1331
1332 /* Following Procedure Call will be placed in the appropriate
1333 Forms in GL */
1334
1335 /* ========================================================================*
1336 | Procedure Name: SYNC_GL_ACCOUNT_TAX
1337 | Product using
1338 | this Procedure : Will be called by GL, from GL Tax Option Accounts
1339 |
1340 | Purpose: Will be used to Synchronize the data between the GL Tax Option
1341 | Accounts and eTax Gateway entities.
1342 | Will be called from GL Tax Option Accounts form, passing the
1343 | attributes required for synchronization.
1344 |
1345 | This stubbed version will do nothing.
1346 |
1347 | In later version of the same Procedure(delivered in ZX),
1348 | it will be replaced with the actual solution for synchronizing
1349 | data between the source (GL tax option accounts) and eTax
1350 | ZX_CONDITIONS_GATEWAY and ZX_RULES_GATEWAY Gateway entities.
1351 |
1352 | Modification History:
1353 |
1354 *=======================================================================*/
1355
1356 PROCEDURE SYNC_GL_ACCOUNT_TAX
1357 (
1358 P_Dml_Type IN VARCHAR2,
1359 P_RowId IN VARCHAR2,
1360 P_Set_Of_Books_Id IN NUMBER,
1361 P_Org_id IN NUMBER,
1362 P_Account_Segment_Value IN VARCHAR2,
1363 P_Tax_Type_Code IN VARCHAR2,
1364 P_Allow_Tax_Code_Override_Flag IN VARCHAR2,
1365 P_Amount_Includes_Tax_Flag IN VARCHAR2,
1366 P_Creation_Date IN DATE,
1367 P_Created_By IN NUMBER,
1368 P_Last_Update_Date IN DATE,
1369 P_Last_Updated_By IN NUMBER,
1370 P_Last_Update_Login IN NUMBER,
1371 P_Tax_Code IN VARCHAR2,
1372 P_Context IN VARCHAR2,
1373 P_Attribute1 IN VARCHAR2,
1374 P_Attribute2 IN VARCHAR2,
1375 P_Attribute3 IN VARCHAR2,
1376 P_Attribute4 IN VARCHAR2,
1377 P_Attribute5 IN VARCHAR2,
1378 P_Attribute6 IN VARCHAR2,
1379 P_Attribute7 IN VARCHAR2,
1380 P_Attribute8 IN VARCHAR2,
1381 P_Attribute9 IN VARCHAR2,
1382 P_Attribute10 IN VARCHAR2,
1383 P_Attribute11 IN VARCHAR2,
1384 P_Attribute12 IN VARCHAR2,
1385 P_Attribute13 IN VARCHAR2,
1386 P_Attribute14 IN VARCHAR2,
1387 P_Attribute15 IN VARCHAR2) IS
1388
1389 l_tax VARCHAR2(30);
1390 BEGIN
1391
1392 arp_util_tax.debug('SYNC_GL_ACCOUNT_TAX(+)');
1393 null;
1394 arp_util_tax.debug('SYNC_GL_ACCOUNT_TAX(-)');
1395
1396 END SYNC_GL_ACCOUNT_TAX;
1397
1398 /* Following Function Call will be placed in the appropriate
1399 Form in HR */
1400
1401 /* ========================================================================*
1402 | Function Name: IS_HR_LOCATION_UPDATE_ALLOWED
1403 | Product using
1404 | this function : Will be called by HR, from Locations Form
1405 |
1406 | Purpose: Will be used to lock the Tax Attributes on Locations
1407 | Form.
1408 | A value of TRUE will be returned in this skeleton version.
1409 |
1410 | In later version of the same function (delivered in ZX),
1411 | it will be replaced with the actual solution.
1412 | A value of FALSE would be returned if eTax Defintion
1413 | migration starts. Tax attributes in Location Form
1414 | should be ade non-updateable,if value returned is FALSE.
1415 |
1416 *=========================================================================*/
1417
1418 FUNCTION IS_HR_LOCATION_UPDATE_ALLOWED
1419 (
1420 p_location_id IN HR_LOCATIONS_ALL.LOCATION_ID%TYPE
1421 ) RETURN BOOLEAN IS
1422
1423 BEGIN
1424
1425 RETURN TRUE;
1426
1427 END IS_HR_LOCATION_UPDATE_ALLOWED;
1428
1429 /* ===========================================================================*
1430 | Function Name: IS_PO_TAX_DEF_UPDATE_ALLOWED
1431 | Product using
1432 | this function : Will be called by PO, from System Options Form
1433 |
1434 | Purpose: Will be used to lock the Tax Attributes on PO System Options
1435 | Form.
1436 | A value of TRUE will be returned in this skeleton version.
1437 |
1438 | In later version of the same function (delivered in ZX),
1439 | it will be replaced with the actual solution.
1440 | A value of FALSE would be returned if eTax Defaulting
1441 | migration starts. Tax attributes in PO System Options Form
1442 | should be ade non-updateable,if value returned is FALSE.
1443 |
1444 *===========================================================================*/
1445
1446
1447 FUNCTION IS_PO_TAX_DEF_UPDATE_ALLOWED
1448 (
1449 p_org_id IN po_system_parameters.org_id%TYPE
1450 ) RETURN BOOLEAN IS
1451
1452 BEGIN
1453
1454 RETURN TRUE;
1455 END IS_PO_TAX_DEF_UPDATE_ALLOWED;
1456
1457 /* Following Functions and Procedures Calls will be placed in the appropriate
1458 Forms in AR */
1459
1460 /* ========================================================================*
1461 | Function Name: IS_AR_TAX_UPDATE_ALLOWED
1462 |
1463 | Product using
1464 | this function : Will be called by AR, from Receivables Option Form
1465 |
1466 | Purpose: Will be used to lock the Tax Attributes on 'Tax' Tab in
1467 | Receivables Option Form
1468 |
1469 | A value of TRUE will be returned in this skeleton version.
1470 |
1471 | In later version of the same function (delivered in ZX),
1472 | it will be replaced with the actual solution.
1473 | A value of FALSE would be returned if eTax definition
1474 | migration starts. Tax attributes in 'Tax' Tab
1475 | should be made non-updateable in the System Option Form,
1476 | if value returned is FALSE.
1477 |
1478 *=========================================================================*/
1479
1480 FUNCTION IS_AR_TAX_UPDATE_ALLOWED
1481 (
1482 p_org_id IN ar_system_parameters.org_id%TYPE
1483 ) RETURN BOOLEAN IS
1484
1485 BEGIN
1486
1487 RETURN TRUE;
1488
1489 END IS_AR_TAX_UPDATE_ALLOWED;
1490
1491 /* ========================================================================*
1492 | Function Name: IS_AR_TAX_DEF_UPDATE_ALLOWED
1493 |
1494 | Product using
1495 | this function : Will be called by AR, from Receivables Option Form
1496 |
1497 | Purpose: Will be used to lock the Tax Attributes on 'Tax Defaults
1498 | and Rules' Tab in Receivables Option Form
1499 |
1500 | A value of TRUE will be returned in this skeleton version.
1501 |
1502 | In later version of the same function (delivered in ZX),
1503 | it will be replaced with the actual solution.
1504 | A value of FALSE would be returned if eTax defaulting hierarchy
1505 | migration starts. Tax attributes in Receivables 'Tax Defaults
1506 | and Rules' should be made non-updateable in the Option Form,
1507 | if value returned is FALSE.
1508 |
1509 *=========================================================================*/
1510
1511 FUNCTION IS_AR_TAX_DEF_UPDATE_ALLOWED
1512 (
1513 p_org_id IN ar_system_parameters.org_id%TYPE
1514 ) RETURN BOOLEAN IS
1515
1516 BEGIN
1517
1518 RETURN TRUE;
1519
1520 END IS_AR_TAX_DEF_UPDATE_ALLOWED;
1521
1522 /* ========================================================================*
1523 | Function Name: IS_JL_LTE_GDF_UPDATE_ALLOWED
1524 |
1525 | Product using
1526 | this function : Will be called by JL from various Core Forms to decide
1527 | on whether updates to GDF is allowed or not.
1528 |
1529 | Purpose: Will be used to lock GDF Attributes of LTE feature
1530 |
1531 | A value of TRUE will be returned in this skeleton version.
1532 |
1533 | In later version of the same function (delivered in ZX),
1534 | it will be replaced with the actual solution.
1535 |
1536 *=========================================================================*/
1537 FUNCTION IS_JL_LTE_GDF_UPDATE_ALLOWED
1538 RETURN BOOLEAN IS
1539
1540 BEGIN
1541
1542 RETURN TRUE;
1543
1544 END IS_JL_LTE_GDF_UPDATE_ALLOWED;
1545
1546
1547
1548 /* Following Procedure Calls will be placed in the appropriate
1549 Forms in AP (tax), that are owned by Tax */
1550
1551
1552 /* =========================================================================*
1553 | Procedure Name: SYNC_AR_TAX_GROUP_CODES
1554 | Purpose: Will be used to Synchronize the data between the Tax Groups and
1555 | eTax Conditions and Rules gateway entity.
1556 |
1557 | Will be called from Tax Group form, passing the attributes
1558 | required for synchronization.
1559 |
1560 | This stubbed version will do nothing.
1561 |
1562 | In later version of the same Procedure(delivered in ZX),
1563 | it will be replaced with the actual solution for synchronizing
1564 | data between the source (Tax Group) and eTax Conditions and Rules
1565 | Gateway entity
1566 |
1567 | Modification History:
1568 | 30-Jan-2004 Srinivas Lokam Added code for the synchronization of
1569 | eBTax entities for default tax
1570 | hierarchy setup.Code will insert
1571 | AP/PO tax default hierarchy related
1572 | eBTax RULES entities, whenever
1573 | new tax code(s) within the Tax group is
1574 | inserted in AP Tax groups Form.
1575 |
1576 *=========================================================================*/
1577
1578 PROCEDURE SYNC_AR_TAX_GROUP_CODES
1579 (
1580 P_DML_TYPE IN VARCHAR2,
1581 P_TAX_GROUP_CODE_ID IN NUMBER,
1582 P_CREATED_BY IN NUMBER,
1583 P_CREATION_DATE IN DATE,
1584 P_LAST_UPDATED_BY IN NUMBER,
1585 P_LAST_UPDATE_DATE IN DATE,
1586 P_LAST_UPDATE_LOGIN IN NUMBER,
1587 P_TAX_GROUP_TYPE IN VARCHAR2,
1588 P_TAX_GROUP_ID IN NUMBER,
1589 P_DISPLAY_ORDER IN NUMBER,
1590 P_TAX_CODE_ID IN NUMBER,
1591 P_TAX_CONDITION_ID IN NUMBER,
1592 P_TAX_EXCEPTION_ID IN NUMBER,
1593 P_START_DATE IN DATE,
1594 P_END_DATE IN DATE,
1595 P_ENABLED_FLAG IN VARCHAR2,
1596 P_COMPOUNDING_PRECEDENCE IN NUMBER,
1597 P_ORG_ID IN NUMBER,
1598 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
1599 P_ATTRIBUTE1 IN VARCHAR2 ,
1600 P_ATTRIBUTE2 IN VARCHAR2,
1601 P_ATTRIBUTE3 IN VARCHAR2,
1602 P_ATTRIBUTE4 IN VARCHAR2,
1603 P_ATTRIBUTE5 IN VARCHAR2,
1604 P_ATTRIBUTE6 IN VARCHAR2,
1605 P_ATTRIBUTE7 IN VARCHAR2,
1606 P_ATTRIBUTE8 IN VARCHAR2,
1607 P_ATTRIBUTE9 IN VARCHAR2,
1608 P_ATTRIBUTE10 IN VARCHAR2,
1609 P_ATTRIBUTE11 IN VARCHAR2,
1610 P_ATTRIBUTE12 IN VARCHAR2,
1611 P_ATTRIBUTE13 IN VARCHAR2,
1612 P_ATTRIBUTE14 IN VARCHAR2,
1613 P_ATTRIBUTE15 IN VARCHAR2,
1614 P_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
1615 P_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
1616 P_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
1617 P_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
1618 P_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
1619 P_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
1620 P_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
1621 P_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
1622 P_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
1623 P_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
1624 P_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
1625 P_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
1626 P_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
1627 P_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
1628 P_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
1629 P_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
1630 P_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
1631 P_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
1632 P_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
1633 P_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
1634 P_GLOBAL_ATTRIBUTE20 IN VARCHAR2) IS
1635
1636 l_tax VARCHAR2(30);
1637 l_name VARCHAR2(30);
1638 BEGIN
1639 arp_util_tax.debug('SYNC_AR_TAX_GROUP_CODES(+)');
1640 IF P_TAX_GROUP_TYPE = 'AP' AND P_DML_TYPE = 'I' THEN
1641 /* Following code creates the RULEs gateway entities for the Tax codes
1642 within the Tax groups,where as the associated CONDITIONs entities
1643 for the corresponding Tax group was already created in
1644 SYNC process of the AP_TAX_CODES */
1645 -- For Sync of Default Hierarchy
1646 SELECT DECODE(global_attribute_category,
1647 'JE.CZ.APXTADTC.TAX_ORIGIN', global_attribute1,
1648 'JE.HU.APXTADTC.TAX_ORIGIN', global_attribute1,
1649 'JE.PL.APXTADTC.TAX_ORIGIN', global_attribute1,
1650 'JE.CH.APXTADTC.TAX_INFO', global_attribute1,
1651 zx_migrate_util.GET_TAX(name, tax_type)
1652 ),
1653 NAME
1654 INTO l_tax,l_name
1655 FROM AP_TAX_CODES_ALL
1656 WHERE TAX_ID = P_TAX_CODE_ID;
1657
1658 Zx_Migrate_Tax_Default_Hier.create_rules(l_tax);
1659 Zx_Migrate_Tax_Default_Hier.create_process_results
1660 (p_tax_id => p_tax_code_id,
1661 p_sync_module => 'AP');
1662 -- End of sync for Default Hierarchy
1663 ELSIF P_TAX_GROUP_TYPE = 'AR' AND P_DML_TYPE = 'I' THEN
1664 -- For Sync of Default Hierarchy
1665
1666 SELECT DECODE(global_attribute_category,
1667 'JE.CZ.ARXSUVAT.TAX_ORIGIN', global_attribute1,
1668 'JE.HU.ARXSUVAT.TAX_ORIGIN', global_attribute1,
1669 'JE.PL.ARXSUVAT.TAX_ORIGIN', global_attribute1,
1670 Zx_Migrate_Util.GET_TAX( tax_code, tax_type) ),
1671 tax_code
1672 INTO l_tax , l_name
1673 FROM AR_VAT_TAX_ALL
1674 WHERE VAT_TAX_ID = P_TAX_CODE_ID;
1675
1676 Zx_Migrate_Tax_Default_Hier.create_rules(l_tax);
1677 Zx_Migrate_Tax_Default_Hier.create_process_results
1678 (p_tax_id => p_tax_code_id,
1679 p_sync_module => 'AR');
1680 -- End of sync for Default Hierarchy
1681
1682 END IF;
1683 arp_util_tax.debug('SYNC_AR_TAX_GROUP_CODES(-)');
1684 END SYNC_AR_TAX_GROUP_CODES;
1685
1686
1687 /* =========================================================================*
1688 | Procedure Name: SYNC_AP_TAX_CODES
1689 |
1690 | Purpose: Will be used to Synchronize the data between the Tax Codes and
1691 | eTax Tax Definition Gateway entity.
1692 |
1693 | Will be called from Tax Codes form, passing the attributes
1694 | required for synchronization.
1695 |
1696 | This stubbed version will do nothing.
1697 |
1698 | In later version of the sa e Procedure(delivered in ZX),
1699 | it will be replaced with the actual solution for synchronizing
1700 | data between the source (Tax Codes) and eTax Tax Definition
1701 | Gateway entity
1702 |
1703 | Modification History:
1704 | 30-Jan-2004 Srinivas Lokam Added code for the synchronization of
1705 | eBTax entities for both Tax Definition and
1706 | default AP tax hierarchy setup.
1707 | For Tax Definition entities:-
1708 | Creates associated ZX_RATES_B,ZX_STATUS_B,
1709 | ZX_TAXES_B,ZX_REGIMES_B and also creates
1710 | ZX_CONDITIONS, ZX_RULES_B,ZX_PROCESS_RESULTS
1711 | based on recoveryr rates(rules) setup of
1712 | newly created Tax codes.
1713 | For Tax Default Hierarchy:-
1714 | Creates associated ZX_CONDITIONS,ZX_RULES,
1715 | ZX_PROCESS_RESULTS for newly created
1716 | Tax codes.
1717 |
1718 *=========================================================================*/
1719
1720 PROCEDURE SYNC_AP_TAX_CODES
1721 (
1722 P_DML_TYPE IN VARCHAR2,
1723 P_NAME IN VARCHAR2,
1724 P_LAST_UPDATE_DATE IN DATE,
1725 P_LAST_UPDATED_BY IN NUMBER,
1726 P_TAX_TYPE IN VARCHAR2,
1727 P_SET_OF_BOOKS_ID IN NUMBER,
1728 P_DESCRIPTION IN VARCHAR2,
1729 P_TAX_RATE IN NUMBER,
1730 P_TAX_CODE_COMBINATION_ID IN NUMBER,
1731 P_INACTIVE_DATE IN DATE,
1732 P_LAST_UPDATE_LOGIN IN NUMBER,
1733 P_CREATION_DATE IN DATE,
1734 P_CREATED_BY IN NUMBER,
1735 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
1736 P_ATTRIBUTE1 IN VARCHAR2,
1737 P_ATTRIBUTE2 IN VARCHAR2,
1738 P_ATTRIBUTE3 IN VARCHAR2,
1739 P_ATTRIBUTE4 IN VARCHAR2,
1740 P_ATTRIBUTE5 IN VARCHAR2,
1741 P_ATTRIBUTE6 IN VARCHAR2,
1742 P_ATTRIBUTE7 IN VARCHAR2,
1743 P_ATTRIBUTE8 IN VARCHAR2,
1744 P_ATTRIBUTE9 IN VARCHAR2,
1745 P_ATTRIBUTE10 IN VARCHAR2,
1746 P_ATTRIBUTE11 IN VARCHAR2,
1747 P_ATTRIBUTE12 IN VARCHAR2,
1748 P_ATTRIBUTE13 IN VARCHAR2,
1749 P_ATTRIBUTE14 IN VARCHAR2,
1750 P_ATTRIBUTE15 IN VARCHAR2,
1751 P_AWT_VENDOR_ID IN NUMBER,
1752 P_AWT_VENDOR_SITE_ID IN NUMBER,
1753 P_AWT_PERIOD_TYPE IN VARCHAR2,
1754 P_AWT_PERIOD_LIMIT IN NUMBER,
1755 P_RANGE_AMOUNT_BASIS IN VARCHAR2,
1756 P_RANGE_PERIOD_BASIS IN VARCHAR2,
1757 P_ORG_ID IN NUMBER,
1758 P_VAT_TRANSACTION_TYPE IN VARCHAR2,
1759 P_TAX_ID IN NUMBER,
1760 P_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
1761 P_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
1762 P_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
1763 P_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
1764 P_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
1765 P_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
1766 P_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
1767 P_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
1768 P_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
1769 P_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
1770 P_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
1771 P_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
1772 P_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
1773 P_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
1774 P_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
1775 P_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
1776 P_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
1777 P_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
1778 P_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
1779 P_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
1780 P_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
1781 P_WEB_ENABLED_FLAG IN VARCHAR2,
1782 P_TAX_RECOVERY_RULE_ID IN NUMBER,
1783 P_TAX_RECOVERY_RATE IN NUMBER,
1784 P_START_DATE IN DATE,
1785 P_ENABLED_FLAG IN VARCHAR2,
1786 P_AWT_RATE_TYPE IN VARCHAR2,
1787 P_OFFSET_TAX_CODE_ID IN NUMBER,
1788 P_SUPPRESS_ZERO_AMOUNT_FLAG IN VARCHAR2) IS
1789
1790 l_tax VARCHAR2(30);
1791
1792 BEGIN
1793 IF PG_DEBUG = 'Y' THEN
1794 arp_util_tax.debug('SYNC_AP_TAX_CODES (+)');
1795 END IF;
1796
1797 --IF control_table THEN
1798
1799 IF p_dml_type = 'I' AND p_tax_type <> 'AWT' THEN
1800 Zx_Migrate_Tax_Def.Create_Tax_Classifications(p_tax_id);
1801 END IF;
1802
1803 IF p_dml_type = 'I' AND p_tax_type = 'TAX_GROUP' THEN
1804 -- For Sync of Default Hierarchy
1805 /* Following code creates CONDITION's entities for the new
1806 TAX GROUP and the associated RULE entities for each
1807 Tax code within the Tax Group will be created in the SYNC process
1808 of AR_TAX_GROUP_CODES */
1809 Zx_Migrate_Tax_Default_Hier.create_condition_groups(p_name);
1810 -- End of sync for Default Hierarchy
1811
1812 ELSIF p_dml_type = 'I' AND p_tax_type = 'OFFSET' THEN
1813
1814 -- For sync of eB-Tax defintion entities.
1815 ZX_MIGRATE_TAX_DEF.migrate_unassign_offset_codes(p_tax_id);
1816 IF p_tax_recovery_rate is not null THEN
1817 ZX_MIGRATE_TAX_DEF.migrate_recovery_rates(p_tax_id);
1818 END IF;
1819 ZX_MIGRATE_TAX_DEF.create_zx_statuses(p_tax_id);
1820 ZX_MIGRATE_TAX_DEF.create_zx_taxes(p_tax_id);
1821
1822 /******************************************************************************
1823 * Important!!! please check why this API ZX_MIGRATE_TAX_DEF.create_zx_regimes *
1824 * was dropped and see if this API call needs to be replaced with another one *
1825 * Commentiong out this call temporarily ge get this package body valid for *
1826 * sanity testing *
1827 ******************************************************************************/
1828 -- bug 4507349 ZX_MIGRATE_TAX_DEF.create_zx_regimes(p_tax_id);
1829 -- End of sync for eB-Tax defintion entities.
1830
1831 ELSIF p_dml_type = 'I' AND p_tax_type <> 'AWT' THEN
1832
1833 -- For sync of eB-Tax defintion entities.
1834 ZX_MIGRATE_TAX_DEF.migrate_normal_tax_codes(p_tax_id);
1835 IF p_tax_recovery_rate is not null THEN
1836 ZX_MIGRATE_TAX_DEF.migrate_recovery_rates(p_tax_id);
1837 ELSIF p_tax_recovery_rule_id is not null THEN
1838 ZX_MIGRATE_TAX_DEF.create_rules(p_tax_id);
1839 END IF;
1840 IF p_offset_tax_code_id is not null THEN
1841 ZX_MIGRATE_TAX_DEF.migrate_assign_offset_codes
1842 (p_offset_tax_code_id);
1843 END IF;
1844 ZX_MIGRATE_TAX_DEF.create_zx_statuses(p_tax_id);
1845 ZX_MIGRATE_TAX_DEF.create_zx_taxes(p_tax_id);
1846 /******************************************************************************
1847 * Important!!! please check why this API ZX_MIGRATE_TAX_DEF.create_zx_regimes *
1848 * was dropped and see if this API call needs to be replaced with another one *
1849 * Commentiong out this call temporarily ge get this package body valid for *
1850 * sanity testing *
1851 ******************************************************************************/
1852 -- bug 4507349 ZX_MIGRATE_TAX_DEF.create_zx_regimes(p_tax_id);
1853 -- End of sync for eB-Tax defintion entities.
1854
1855 -- For Sync of Default Hierarchy
1856 SELECT DECODE(p_global_attribute_category,
1857 'JE.CZ.APXTADTC.TAX_ORIGIN',
1858 p_global_attribute1,
1859 'JE.HU.APXTADTC.TAX_ORIGIN',
1860 p_global_attribute1,
1861 'JE.PL.APXTADTC.TAX_ORIGIN',
1862 p_global_attribute1,
1863 'JE.CH.APXTADTC.TAX_INFO',
1864 p_global_attribute1,
1865 zx_migrate_util.GET_TAX(p_name,
1866 p_tax_type)
1867 ) INTO l_tax
1868 FROM DUAL;
1869
1870 -- Bug 3751717
1871 IF p_tax_type NOT IN('OFFSET','USE') THEN
1872 Zx_Migrate_Tax_Default_Hier.create_condition_groups(p_name);
1873 Zx_Migrate_Tax_Default_Hier.create_rules(l_tax);
1874 Zx_Migrate_Tax_Default_Hier.create_process_results
1875 (p_tax_id => p_tax_id,
1876 p_sync_module => 'AP');
1877 END IF;
1878 -- End of sync for Default Hierarchy
1879
1880 ELSE
1881 null;
1882 END IF;
1883
1884 --END IF;
1885 IF PG_DEBUG = 'Y' THEN
1886 arp_util_tax.debug('SYNC_AP_TAX_CODES (-)');
1887 END IF;
1888 END SYNC_AP_TAX_CODES;
1889
1890 /* ==========================================================================*
1891 | Procedure Name: SYNC_AP_TAX_RECVRY_RULES
1892 |
1893 | Purpose: Will be used to Synchronize the data between the Tax Recovery
1894 | Rules and eTax Condition and Rules Gateway entity.
1895 |
1896 | Will be called fro Tax Codes for passing the attributes
1897 | required for synchronization.
1898 |
1899 | This stubbed version will do nothing.
1900 |
1901 | In later version of the sa e Procedure(delivered in ZX),
1902 | it will be replaced with the actual solution for synchronizing
1903 | data between the source (Tax Recovery Rules) and eTax Condition
1904 | and Rules Gateway entity
1905 |
1906 *=========================================================================*/
1907
1908 PROCEDURE SYNC_AP_TAX_RECVRY_RULES
1909 (
1910 P_DML_TYPE IN VARCHAR2,
1911 P_RULE_ID IN NUMBER,
1912 P_CREATED_BY IN NUMBER,
1913 P_CREATION_DATE IN DATE,
1914 P_LAST_UPDATED_BY IN NUMBER,
1915 P_LAST_UPDATE_DATE IN DATE,
1916 P_LAST_UPDATE_LOGIN IN NUMBER,
1917 P_NAME IN VARCHAR2,
1918 P_DESCRIPTION IN VARCHAR2,
1919 P_ORG_ID IN NUMBER,
1920 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
1921 P_ATTRIBUTE1 IN VARCHAR2,
1922 P_ATTRIBUTE2 IN VARCHAR2,
1923 P_ATTRIBUTE3 IN VARCHAR2,
1924 P_ATTRIBUTE4 IN VARCHAR2,
1925 P_ATTRIBUTE5 IN VARCHAR2,
1926 P_ATTRIBUTE6 IN VARCHAR2,
1927 P_ATTRIBUTE7 IN VARCHAR2,
1928 P_ATTRIBUTE8 IN VARCHAR2,
1929 P_ATTRIBUTE9 IN VARCHAR2,
1930 P_ATTRIBUTE10 IN VARCHAR2,
1931 P_ATTRIBUTE11 IN VARCHAR2,
1932 P_ATTRIBUTE12 IN VARCHAR2,
1933 P_ATTRIBUTE13 IN VARCHAR2,
1934 P_ATTRIBUTE14 IN VARCHAR2,
1935 P_ATTRIBUTE15 IN VARCHAR2,
1936 P_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
1937 P_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
1938 P_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
1939 P_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
1940 P_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
1941 P_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
1942 P_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
1943 P_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
1944 P_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
1945 P_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
1946 P_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
1947 P_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
1948 P_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
1949 P_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
1950 P_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
1951 P_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
1952 P_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
1953 P_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
1954 P_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
1955 P_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
1956 P_GLOBAL_ATTRIBUTE20 IN VARCHAR2) IS
1957
1958 BEGIN
1959 IF PG_DEBUG = 'Y' THEN
1960 arp_util_tax.debug('SYNC_AP_TAX_RECVRY_RULES()+');
1961 END IF;
1962 null;
1963 IF PG_DEBUG = 'Y' THEN
1964 arp_util_tax.debug('SYNC_AP_TAX_RECVRY_RULES()-');
1965 END IF;
1966 END SYNC_AP_TAX_RECVRY_RULES;
1967
1968 /* =========================================================================*
1969 | Procedure Name: SYNC_AP_TAX_RECVRY_RATES
1970 |
1971 | Purpose: Will be used to Synchronize the data between the Tax REcovery
1972 | Rates and eTax Tax Definition Gateway entity.
1973 |
1974 | Will be called fro Tax Codes for passing the attributes
1975 | required for synchronization.
1976 |
1977 | This stubbed version will do nothing.
1978 |
1979 | In later version of the sa e Procedure(delivered in ZX),
1980 | it will be replaced with the actual solution for synchronizing
1981 | data between the source (Tax Recovery Rates) and eTax Tax
1982 | Definition Gateway entity
1983 |
1984 *========================================================================*/
1985
1986 PROCEDURE SYNC_AP_TAX_RECVRY_RATES
1987 (
1988 P_DML_TYPE IN VARCHAR2,
1989 P_RATE_ID IN NUMBER,
1990 P_CREATED_BY IN NUMBER,
1991 P_CREATION_DATE IN DATE,
1992 P_LAST_UPDATED_BY IN NUMBER,
1993 P_LAST_UPDATE_DATE IN DATE,
1994 P_LAST_UPDATE_LOGIN IN NUMBER,
1995 P_RULE_ID IN NUMBER,
1996 P_CONCATENATED_SEGMENT_LOW IN VARCHAR2,
1997 P_CONCATENATED_SEGMENT_HIGH IN VARCHAR2,
1998 P_ENABLED_FLAG IN VARCHAR2,
1999 P_START_DATE IN DATE,
2000 P_END_DATE IN DATE,
2001 P_RECOVERY_RATE IN NUMBER,
2002 P_CONDITION IN VARCHAR2,
2003 P_CONDITION_VALUE IN VARCHAR2,
2004 P_FUNCTION IN VARCHAR2,
2005 P_DESCRIPTION IN VARCHAR2,
2006 P_ORG_ID IN NUMBER,
2007 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
2008 P_ATTRIBUTE1 IN VARCHAR2,
2009 P_ATTRIBUTE2 IN VARCHAR2,
2010 P_ATTRIBUTE3 IN VARCHAR2,
2011 P_ATTRIBUTE4 IN VARCHAR2,
2012 P_ATTRIBUTE5 IN VARCHAR2,
2013 P_ATTRIBUTE6 IN VARCHAR2,
2014 P_ATTRIBUTE7 IN VARCHAR2,
2015 P_ATTRIBUTE8 IN VARCHAR2,
2016 P_ATTRIBUTE9 IN VARCHAR2,
2017 P_ATTRIBUTE10 IN VARCHAR2,
2018 P_ATTRIBUTE11 IN VARCHAR2,
2019 P_ATTRIBUTE12 IN VARCHAR2,
2020 P_ATTRIBUTE13 IN VARCHAR2,
2021 P_ATTRIBUTE14 IN VARCHAR2,
2022 P_ATTRIBUTE15 IN VARCHAR2,
2023 P_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
2024 P_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
2025 P_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
2026 P_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
2027 P_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
2028 P_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
2029 P_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
2030 P_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
2031 P_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
2032 P_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
2033 P_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
2034 P_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
2035 P_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
2036 P_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
2037 P_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
2038 P_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
2039 P_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
2040 P_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
2041 P_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
2042 P_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
2043 P_GLOBAL_ATTRIBUTE20 IN VARCHAR2) IS
2044
2045 BEGIN
2046 IF PG_DEBUG = 'Y' THEN
2047 arp_util_tax.debug('SYNC_AP_TAX_RECVRY_RATES()+');
2048 END IF;
2049 IF p_dml_type = 'I' THEN
2050 ZX_MIGRATE_TAX_DEF.create_condition_groups(p_rate_id);
2051 END IF;
2052 IF PG_DEBUG = 'Y' THEN
2053 arp_util_tax.debug('SYNC_AP_TAX_RECVRY_RATES()-');
2054 END IF;
2055
2056 END SYNC_AP_TAX_RECVRY_RATES;
2057
2058 /* =========================================================================*
2059 | Procedure Name: SYNC_MTL_SYSTEM_ITEMS
2060 |
2061 | Purpose: Will be used to Synchronize the data between the Inventory Items
2062 | and eTax Fiscal Classifications.
2063 |
2064 | Will be called from JE library passing the Global Attributes
2065 | required for synchronization.
2066 |
2067 | This stubbed version will do nothing.
2068 |
2069 | In later version of these Procedure(delivered in ZX),
2070 | it will be replaced with the actual solution for synchronizing
2071 | data. This procedure will be creating data in
2072 | ZX_PROD_FSC_CLASS_ASSOC_GW
2073 *========================================================================*/
2074
2075
2076 PROCEDURE SYNC_MTL_SYSTEM_ITEMS(
2077 P_ITEM_ID IN NUMBER,
2078 P_ITEM_ORGANIZATION_ID IN NUMBER,
2079 P_FISCAL_CLASSIF_TYPE_CODE IN VARCHAR2,
2080 P_FISCAL_CLASSIF_CODE IN VARCHAR2 ) IS
2081
2082 BEGIN
2083 NULL;
2084
2085 END SYNC_MTL_SYSTEM_ITEMS;
2086
2087 /* =========================================================================*
2088 | Procedure Name: SYNC_GDF_AR_MEMO_LINES
2089 |
2090 | Purpose: Will be used to Synchronize Global Attributes data between
2091 | the Memo Lines and eTax entities.
2092 |
2093 | Will be called from JL library passing the Global Attributes
2094 | required for synchronization.
2095 |
2096 | This stubbed version will do nothing.
2097 |
2098 | In later version of these Procedure(delivered in ZX),
2099 | it will be replaced with the actual solution for synchronizing
2100 | data.
2101 *========================================================================*/
2102
2103 PROCEDURE SYNC_GDF_AR_MEMO_LINES (
2104 P_MEMO_LINE_ID IN NUMBER,
2105 P_SET_OF_BOOKS_ID IN NUMBER,
2106 P_LINE_TYPE IN VARCHAR2,
2107 P_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
2108 P_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
2109 P_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
2110 P_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
2111 P_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
2112 P_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
2113 P_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
2114 P_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
2115 P_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
2116 P_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
2117 P_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
2118 P_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
2119 P_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
2120 P_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
2121 P_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
2122 P_GLOBAL_ATTRIBUTE15 IN VARCHAR2) IS
2123
2124 BEGIN
2125 NULL;
2126
2127 END SYNC_GDF_AR_MEMO_LINES;
2128
2129 /* =========================================================================*
2130 | Procedure Name: SYNC_LTE_CATEG
2131 | Product using
2132 | this Procedure : Will be called by JL, from Latin Tax Categories Form
2133 |
2134 | Purpose: Will be used to Synchronize data with eTax Gateway entity.
2135 |
2136 *========================================================================*/
2137
2138 PROCEDURE SYNC_LTE_CATEG (
2139 P_DML_TYPE IN VARCHAR2,
2140 P_TAX_CATEGORY_ID IN NUMBER,
2141 P_TAX_CATEGORY IN VARCHAR2,
2142 P_END_DATE_ACTIVE IN DATE,
2143 P_LAST_UPDATED_BY IN NUMBER,
2144 P_LAST_UPDATE_DATE IN DATE,
2145 P_CREATED_BY IN NUMBER,
2146 P_CREATION_DATE IN DATE,
2147 P_LAST_UPDATE_LOGIN IN NUMBER,
2148 P_THRESHOLD_CHECK_LEVEL IN VARCHAR2,
2149 P_THRESHOLD_CHECK_GRP_BY IN VARCHAR2,
2150 P_MIN_AMOUNT IN NUMBER,
2151 P_MIN_TAXABLE_BASIS IN NUMBER,
2152 P_MIN_PERCENTAGE IN NUMBER,
2153 P_TAX_INCLUSIVE IN VARCHAR2,
2154 P_ORG_TAX_ATTRIBUTE IN VARCHAR2,
2155 P_CUS_TAX_ATTRIBUTE IN VARCHAR2,
2156 P_TXN_TAX_ATTRIBUTE IN VARCHAR2,
2157 P_TRIBUTARY_SUBSTITUTION IN VARCHAR2,
2158 P_USED_TO_REDUCE IN VARCHAR2,
2159 P_TAX_CATEG_TO_REDUCE_ID IN NUMBER,
2160 P_TAX_CODE IN VARCHAR2,
2161 P_TAX_AUTHORITY_CODE IN VARCHAR2,
2162 P_MANDATORY_IN_CLASS IN VARCHAR2,
2163 P_PRINT_FLAG IN VARCHAR2,
2164 P_TAX_RULE_SET IN VARCHAR2,
2165 P_START_DATE_ACTIVE IN DATE,
2166 P_TAX_REGIME IN VARCHAR2,
2167 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
2168 P_ATTRIBUTE1 IN VARCHAR2,
2169 P_ATTRIBUTE2 IN VARCHAR2,
2170 P_ATTRIBUTE3 IN VARCHAR2,
2171 P_ATTRIBUTE4 IN VARCHAR2,
2172 P_ATTRIBUTE5 IN VARCHAR2,
2173 P_ATTRIBUTE6 IN VARCHAR2,
2174 P_ATTRIBUTE7 IN VARCHAR2,
2175 P_ATTRIBUTE8 IN VARCHAR2,
2176 P_ATTRIBUTE9 IN VARCHAR2,
2177 P_ATTRIBUTE10 IN VARCHAR2,
2178 P_ATTRIBUTE11 IN VARCHAR2,
2179 P_ATTRIBUTE12 IN VARCHAR2,
2180 P_ATTRIBUTE13 IN VARCHAR2,
2181 P_ATTRIBUTE14 IN VARCHAR2,
2182 P_ATTRIBUTE15 IN VARCHAR2 ) IS
2183 BEGIN
2184 NULL;
2185 END SYNC_LTE_CATEG;
2186
2187 /* =========================================================================*
2188 | Procedure Name: SYNC_LTE_GROUPS
2189 | Product using
2190 | this Procedure : Will be called by JL, from Latin Tax Groups Form
2191 |
2192 | Purpose: Will be used to Synchronize data with eTax Gateway entity.
2193 |
2194 *========================================================================*/
2195
2196 PROCEDURE SYNC_LTE_GROUPS (
2197 P_DML_TYPE IN VARCHAR2,
2198 P_GROUP_TAX_ID IN NUMBER,
2199 P_TAX_CATEGORY_ID IN NUMBER,
2200 P_TAX_GROUP_RECORD_ID IN NUMBER,
2201 P_ESTABLISHMENT_TYPE IN VARCHAR2,
2202 P_CONTRIBUTOR_TYPE IN VARCHAR2,
2203 P_TRANSACTION_NATURE IN VARCHAR2,
2204 P_END_DATE_ACTIVE IN DATE,
2205 P_USE_TX_CATEG_THRESHOLDS IN VARCHAR2,
2206 P_LAST_UPDATE_DATE IN DATE,
2207 P_LAST_UPDATED_BY IN NUMBER,
2208 P_COMPOUND_PRECEDENCE IN NUMBER,
2209 P_MIN_AMOUNT IN NUMBER,
2210 P_MIN_TAXABLE_BASIS IN NUMBER,
2211 P_MIN_PERCENTAGE IN NUMBER,
2212 P_TAX_INCLUSIVE IN VARCHAR2,
2213 P_TRIBUTARY_SUBSTITUTION IN VARCHAR2,
2214 P_USED_TO_REDUCE IN VARCHAR2,
2215 P_TAX_CODE IN VARCHAR2,
2216 P_BASE_RATE IN NUMBER,
2217 P_START_DATE_ACTIVE IN DATE,
2218 P_LAST_UPDATE_LOGIN IN NUMBER,
2219 P_CREATION_DATE IN DATE,
2220 P_CREATED_BY IN NUMBER,
2221 P_TAX_CATEGORY_TO_REDUCE_ID IN NUMBER,
2222 P_CALCULATE_IN_OE IN VARCHAR2,
2223 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
2224 P_ATTRIBUTE1 IN VARCHAR2,
2225 P_ATTRIBUTE2 IN VARCHAR2,
2226 P_ATTRIBUTE3 IN VARCHAR2,
2227 P_ATTRIBUTE4 IN VARCHAR2,
2228 P_ATTRIBUTE5 IN VARCHAR2,
2229 P_ATTRIBUTE6 IN VARCHAR2,
2230 P_ATTRIBUTE7 IN VARCHAR2,
2231 P_ATTRIBUTE8 IN VARCHAR2,
2232 P_ATTRIBUTE9 IN VARCHAR2,
2233 P_ATTRIBUTE10 IN VARCHAR2,
2234 P_ATTRIBUTE11 IN VARCHAR2,
2235 P_ATTRIBUTE12 IN VARCHAR2,
2236 P_ATTRIBUTE13 IN VARCHAR2,
2237 P_ATTRIBUTE14 IN VARCHAR2,
2238 P_ATTRIBUTE15 IN VARCHAR2) IS
2239 BEGIN
2240 NULL;
2241 END SYNC_LTE_GROUPS;
2242
2243 /* =========================================================================*
2244 | Procedure Name: SYNC_LTE_CAT_ATT
2245 | Product using
2246 | this Procedure : Will be called by JL, from Associate Latin Tax Category
2247 | with Conditions and Values Form (Master Block)
2248 |
2249 | Purpose: Will be used to Synchronize data with eTax Gateway entity.
2250 |
2251 *========================================================================*/
2252
2253 PROCEDURE SYNC_LTE_CAT_ATT (
2254 P_DML_TYPE IN VARCHAR2,
2255 P_TAX_CATEG_ATTR_ID IN NUMBER,
2256 P_TAX_CATEGORY_ID IN NUMBER,
2257 P_TAX_ATTRIBUTE_TYPE IN VARCHAR2,
2258 P_TAX_ATTRIBUTE_NAME IN VARCHAR2,
2259 P_MANDATORY_IN_CLASS IN VARCHAR2,
2260 P_DETERMINING_FACTOR IN VARCHAR2,
2261 P_GROUPING_ATTRIBUTE IN VARCHAR2,
2262 P_PRIORITY_NUMBER IN NUMBER,
2263 P_LAST_UPDATE_DATE IN DATE,
2264 P_LAST_UPDATED_BY IN NUMBER,
2265 P_CREATION_DATE IN DATE,
2266 P_CREATED_BY IN NUMBER,
2267 P_LAST_UPDATE_LOGIN IN NUMBER,
2268 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
2269 P_ATTRIBUTE1 IN VARCHAR2,
2270 P_ATTRIBUTE2 IN VARCHAR2,
2271 P_ATTRIBUTE3 IN VARCHAR2,
2272 P_ATTRIBUTE4 IN VARCHAR2,
2273 P_ATTRIBUTE5 IN VARCHAR2,
2274 P_ATTRIBUTE6 IN VARCHAR2,
2275 P_ATTRIBUTE7 IN VARCHAR2,
2276 P_ATTRIBUTE8 IN VARCHAR2,
2277 P_ATTRIBUTE9 IN VARCHAR2,
2278 P_ATTRIBUTE10 IN VARCHAR2,
2279 P_ATTRIBUTE11 IN VARCHAR2,
2280 P_ATTRIBUTE12 IN VARCHAR2,
2281 P_ATTRIBUTE13 IN VARCHAR2,
2282 P_ATTRIBUTE14 IN VARCHAR2,
2283 P_ATTRIBUTE15 IN VARCHAR2) IS
2284 BEGIN
2285 NULL;
2286 END SYNC_LTE_CAT_ATT;
2287
2288
2289 /* =========================================================================*
2290 | Procedure Name: SYNC_LTE_ATT_VAL
2291 | Product using
2292 | this Procedure : Will be called by JL, from Associate Latin Tax Category
2293 | with Conditions and Values Form (Detail Block)
2294 |
2295 | Purpose: Will be used to Synchronize data with eTax Gateway entity.
2296 |
2297 *========================================================================*/
2298
2299 PROCEDURE SYNC_LTE_ATT_VAL (
2300 P_DML_TYPE IN VARCHAR2,
2301 P_TAX_CATEG_ATTR_VAL_ID IN NUMBER,
2302 P_TAX_CATEGORY_ID IN NUMBER,
2303 P_TAX_ATTRIBUTE_TYPE IN VARCHAR2,
2304 P_TAX_ATTRIBUTE_NAME IN VARCHAR2,
2305 P_TAX_ATTRIBUTE_VALUE IN VARCHAR2,
2306 P_TAX_ATTR_VALUE_CODE IN VARCHAR2,
2307 P_DEFAULT_TO_CLASS IN VARCHAR2,
2308 P_LAST_UPDATE_DATE IN DATE,
2309 P_LAST_UPDATED_BY IN NUMBER,
2310 P_CREATION_DATE IN DATE,
2311 P_CREATED_BY IN NUMBER,
2312 P_LAST_UPDATE_LOGIN IN NUMBER,
2313 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
2314 P_ATTRIBUTE1 IN VARCHAR2,
2315 P_ATTRIBUTE2 IN VARCHAR2,
2316 P_ATTRIBUTE3 IN VARCHAR2,
2317 P_ATTRIBUTE4 IN VARCHAR2,
2318 P_ATTRIBUTE5 IN VARCHAR2,
2319 P_ATTRIBUTE6 IN VARCHAR2,
2320 P_ATTRIBUTE7 IN VARCHAR2,
2321 P_ATTRIBUTE8 IN VARCHAR2,
2322 P_ATTRIBUTE9 IN VARCHAR2,
2323 P_ATTRIBUTE10 IN VARCHAR2,
2324 P_ATTRIBUTE11 IN VARCHAR2,
2325 P_ATTRIBUTE12 IN VARCHAR2,
2326 P_ATTRIBUTE13 IN VARCHAR2,
2327 P_ATTRIBUTE14 IN VARCHAR2,
2328 P_ATTRIBUTE15 IN VARCHAR2) IS
2329 BEGIN
2330 NULL;
2331 END SYNC_LTE_ATT_VAL;
2332
2333 /* =========================================================================*
2334 | Procedure Name: SYNC_LTE_ATT_CLS_HDR
2335 | Product using
2336 | this Procedure : Will be called by JL, from Latin Tax Condition Classes
2337 | Form (Master Block)
2338 |
2339 | Purpose: Will be used to Synchronize data with eTax Gateway entity.
2340 |
2341 *========================================================================*/
2342
2343 PROCEDURE SYNC_LTE_ATT_CLS_HDR (
2344 P_DML_TYPE IN VARCHAR2,
2345 P_LOOKUP_TYPE IN VARCHAR2,
2346 P_SECURITY_GROUP_ID IN NUMBER,
2347 P_VIEW_APPLICATION_ID IN NUMBER,
2348 P_LOOKUP_CODE IN VARCHAR2,
2349 P_ENABLED_FLAG IN VARCHAR2,
2350 P_START_DATE_ACTIVE IN DATE,
2351 P_END_DATE_ACTIVE IN DATE,
2352 P_TERRITORY_CODE IN VARCHAR2,
2353 P_TAG IN VARCHAR2,
2354 P_MEANING IN VARCHAR2,
2355 P_DESCRIPTION IN VARCHAR2,
2356 P_CREATION_DATE IN VARCHAR2,
2357 P_CREATED_BY IN VARCHAR2,
2358 P_LAST_UPDATE_DATE IN VARCHAR2,
2359 P_LAST_UPDATED_BY IN VARCHAR2,
2360 P_LAST_UPDATE_LOGIN IN VARCHAR2,
2361 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
2362 P_ATTRIBUTE1 IN VARCHAR2,
2363 P_ATTRIBUTE2 IN VARCHAR2,
2364 P_ATTRIBUTE3 IN VARCHAR2,
2365 P_ATTRIBUTE4 IN VARCHAR2,
2366 P_ATTRIBUTE5 IN VARCHAR2,
2367 P_ATTRIBUTE6 IN VARCHAR2,
2368 P_ATTRIBUTE7 IN VARCHAR2,
2369 P_ATTRIBUTE8 IN VARCHAR2,
2370 P_ATTRIBUTE9 IN VARCHAR2,
2371 P_ATTRIBUTE10 IN VARCHAR2,
2372 P_ATTRIBUTE11 IN VARCHAR2,
2373 P_ATTRIBUTE12 IN VARCHAR2,
2374 P_ATTRIBUTE13 IN VARCHAR2,
2375 P_ATTRIBUTE14 IN VARCHAR2,
2376 P_ATTRIBUTE15 IN VARCHAR2) IS
2377 BEGIN
2378 NULL;
2379 END SYNC_LTE_ATT_CLS_HDR;
2380
2381 /* =========================================================================*
2382 | Procedure Name: SYNC_LTE_ATT_CLS
2383 | Product using
2384 | this Procedure : Will be called by JL, from Latin Tax Condition Classes
2385 | Form (Detail Block)
2386 |
2387 | Purpose: Will be used to Synchronize data with eTax Gateway entity.
2388 |
2389 *========================================================================*/
2390
2391 PROCEDURE SYNC_LTE_ATT_CLS (
2392 P_DML_TYPE IN VARCHAR2,
2393 P_ATTRIBUTE_CLASS_ID IN NUMBER,
2394 P_TAX_ATTR_CLASS_TYPE IN VARCHAR2,
2395 P_TAX_ATTR_CLASS_CODE IN VARCHAR2,
2396 P_TAX_CATEGORY_ID IN NUMBER,
2397 P_TAX_ATTRIBUTE_TYPE IN VARCHAR2,
2398 P_TAX_ATTRIBUTE_NAME IN VARCHAR2,
2399 P_TAX_ATTRIBUTE_VALUE IN VARCHAR2,
2400 P_ENABLED_FLAG IN VARCHAR2,
2401 P_LAST_UPDATED_BY IN NUMBER,
2402 P_LAST_UPDATE_DATE IN DATE,
2403 P_LAST_UPDATE_LOGIN IN NUMBER,
2404 P_CREATION_DATE IN DATE,
2405 P_CREATED_BY IN NUMBER,
2406 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
2407 P_ATTRIBUTE1 IN VARCHAR2,
2408 P_ATTRIBUTE2 IN VARCHAR2,
2409 P_ATTRIBUTE3 IN VARCHAR2,
2410 P_ATTRIBUTE4 IN VARCHAR2,
2411 P_ATTRIBUTE5 IN VARCHAR2,
2412 P_ATTRIBUTE6 IN VARCHAR2,
2413 P_ATTRIBUTE7 IN VARCHAR2,
2414 P_ATTRIBUTE8 IN VARCHAR2,
2415 P_ATTRIBUTE9 IN VARCHAR2,
2416 P_ATTRIBUTE10 IN VARCHAR2,
2417 P_ATTRIBUTE11 IN VARCHAR2,
2418 P_ATTRIBUTE12 IN VARCHAR2,
2419 P_ATTRIBUTE13 IN VARCHAR2,
2420 P_ATTRIBUTE14 IN VARCHAR2,
2421 P_ATTRIBUTE15 IN VARCHAR2) IS
2422 BEGIN
2423 NULL;
2424 END SYNC_LTE_ATT_CLS;
2425
2426 /* =========================================================================*
2427 | Procedure Name: SYNC_LTE_LOCN
2428 | Product using
2429 | this Procedure : Will be called by JL, from Latin Locations Form
2430 |
2431 | Purpose: Will be used to Synchronize data with eTax Gateway entity.
2432 |
2433 *========================================================================*/
2434
2435 PROCEDURE SYNC_LTE_LOCN (
2436 P_DML_TYPE IN VARCHAR2,
2437 P_LOCN_ID IN NUMBER,
2438 P_SHIP_FROM_CODE IN VARCHAR2,
2439 P_SHIP_TO_SEGMENT_ID IN NUMBER,
2440 P_TAX_CATEGORY_ID IN NUMBER,
2441 P_END_DATE_ACTIVE IN DATE,
2442 P_LAST_UPDATED_BY IN NUMBER,
2443 P_LAST_UPDATE_DATE IN DATE,
2444 P_BASE_RATE IN NUMBER,
2445 P_TAX_CODE IN VARCHAR2,
2446 P_TRIB_SUBST_INSCRIPTION IN VARCHAR2,
2447 P_START_DATE_ACTIVE IN DATE,
2448 P_LAST_UPDATE_LOGIN IN NUMBER,
2449 P_CREATION_DATE IN DATE,
2450 P_CREATED_BY IN NUMBER,
2451 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
2452 P_ATTRIBUTE1 IN VARCHAR2,
2453 P_ATTRIBUTE2 IN VARCHAR2,
2454 P_ATTRIBUTE3 IN VARCHAR2,
2455 P_ATTRIBUTE4 IN VARCHAR2,
2456 P_ATTRIBUTE5 IN VARCHAR2,
2457 P_ATTRIBUTE6 IN VARCHAR2,
2458 P_ATTRIBUTE7 IN VARCHAR2,
2459 P_ATTRIBUTE8 IN VARCHAR2,
2460 P_ATTRIBUTE9 IN VARCHAR2,
2461 P_ATTRIBUTE10 IN VARCHAR2,
2462 P_ATTRIBUTE11 IN VARCHAR2,
2463 P_ATTRIBUTE12 IN VARCHAR2,
2464 P_ATTRIBUTE13 IN VARCHAR2,
2465 P_ATTRIBUTE14 IN VARCHAR2,
2466 P_ATTRIBUTE15 IN VARCHAR2) IS
2467 BEGIN
2468 NULL;
2469 END SYNC_LTE_LOCN;
2470
2471 /* =========================================================================*
2472 | Procedure Name: SYNC_LTE_FSC_CLS_HDR
2473 | Product using
2474 | this Procedure : Will be called by JL, from Latin Fiscal Classifications
2475 | Form (Master Block)
2476 |
2477 | Purpose: Will be used to Synchronize data with eTax Gateway entity.
2478 |
2479 *========================================================================*/
2480
2481 PROCEDURE SYNC_LTE_FSC_CLS_HDR (
2482 P_DML_TYPE IN VARCHAR2,
2483 P_LOOKUP_TYPE IN VARCHAR2,
2484 P_LOOKUP_CODE IN VARCHAR2,
2485 P_ENABLED_FLAG IN VARCHAR2,
2486 P_START_DATE_ACTIVE IN DATE,
2487 P_END_DATE_ACTIVE IN DATE,
2488 P_MEANING IN VARCHAR2,
2489 P_DESCRIPTION IN VARCHAR2,
2490 P_CREATION_DATE IN DATE,
2491 P_CREATED_BY IN VARCHAR2,
2492 P_LAST_UPDATE_DATE IN DATE,
2493 P_LAST_UPDATED_BY IN VARCHAR2,
2494 P_LAST_UPDATE_LOGIN IN VARCHAR2,
2495 P_SECURITY_GROUP_ID IN NUMBER,
2496 P_VIEW_APPLICATION_ID IN NUMBER,
2497 P_TAG IN VARCHAR2,
2498 P_TERRITORY_CODE IN VARCHAR2,
2499 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
2500 P_ATTRIBUTE1 IN VARCHAR2,
2501 P_ATTRIBUTE2 IN VARCHAR2,
2502 P_ATTRIBUTE3 IN VARCHAR2,
2503 P_ATTRIBUTE4 IN VARCHAR2,
2504 P_ATTRIBUTE5 IN VARCHAR2,
2505 P_ATTRIBUTE6 IN VARCHAR2,
2506 P_ATTRIBUTE7 IN VARCHAR2,
2507 P_ATTRIBUTE8 IN VARCHAR2,
2508 P_ATTRIBUTE9 IN VARCHAR2,
2509 P_ATTRIBUTE10 IN VARCHAR2,
2510 P_ATTRIBUTE11 IN VARCHAR2,
2511 P_ATTRIBUTE12 IN VARCHAR2,
2512 P_ATTRIBUTE13 IN VARCHAR2,
2513 P_ATTRIBUTE14 IN VARCHAR2,
2514 P_ATTRIBUTE15 IN VARCHAR2) IS
2515 BEGIN
2516 NULL;
2517 END SYNC_LTE_FSC_CLS_HDR;
2518
2519 /* =========================================================================*
2520 | Procedure Name: SYNC_LTE_FSC_CLS
2521 | Product using
2522 | this Procedure : Will be called by JL, from Latin Fiscal Classifications
2523 | Form (Detail Block)
2524 |
2525 | Purpose: Will be used to Synchronize data with eTax Gateway entity.
2526 |
2527 *========================================================================*/
2528
2529 PROCEDURE SYNC_LTE_FSC_CLS (
2530 P_DML_TYPE IN VARCHAR2,
2531 P_FSC_CLS_ID IN NUMBER,
2532 P_FISCAL_CLASSIFICATION_CODE IN VARCHAR2,
2533 P_TAX_CATEGORY_ID IN NUMBER,
2534 P_TAX_CODE IN VARCHAR2,
2535 P_END_DATE_ACTIVE IN DATE,
2536 P_BASE_RATE IN NUMBER,
2537 P_START_DATE_ACTIVE IN DATE,
2538 P_ENABLED_FLAG IN VARCHAR2,
2539 P_LAST_UPDATE_DATE IN DATE,
2540 P_LAST_UPDATED_BY IN NUMBER,
2541 P_CREATION_DATE IN DATE,
2542 P_CREATED_BY IN NUMBER,
2543 P_LAST_UPDATE_LOGIN IN NUMBER,
2544 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
2545 P_ATTRIBUTE1 IN VARCHAR2,
2546 P_ATTRIBUTE2 IN VARCHAR2,
2547 P_ATTRIBUTE3 IN VARCHAR2,
2548 P_ATTRIBUTE4 IN VARCHAR2,
2549 P_ATTRIBUTE5 IN VARCHAR2,
2550 P_ATTRIBUTE6 IN VARCHAR2,
2551 P_ATTRIBUTE7 IN VARCHAR2,
2552 P_ATTRIBUTE8 IN VARCHAR2,
2553 P_ATTRIBUTE9 IN VARCHAR2,
2554 P_ATTRIBUTE10 IN VARCHAR2,
2555 P_ATTRIBUTE11 IN VARCHAR2,
2556 P_ATTRIBUTE12 IN VARCHAR2,
2557 P_ATTRIBUTE13 IN VARCHAR2,
2558 P_ATTRIBUTE14 IN VARCHAR2,
2559 P_ATTRIBUTE15 IN VARCHAR2) IS
2560 BEGIN
2561 NULL;
2562 END SYNC_LTE_FSC_CLS;
2563
2564 /* =========================================================================*
2565 | Procedure Name: SYNC_LTE_RULES
2566 | Product using
2567 | this Procedure : Will be called by JL, from Tax Rules Form
2568 |
2569 | Purpose: Will be used to Synchronize data with eTax Gateway entity.
2570 |
2571 *========================================================================*/
2572
2573 PROCEDURE SYNC_LTE_RULES (
2574 P_DML_TYPE IN VARCHAR2,
2575 P_RULE_ID IN NUMBER,
2576 P_TAX_RULE_LEVEL IN VARCHAR2,
2577 P_RULE IN VARCHAR2,
2578 P_TAX_CATEGORY_ID IN NUMBER,
2579 P_CONTRIBUTOR_TYPE IN VARCHAR2,
2580 P_CUST_TRX_TYPE_ID IN NUMBER,
2581 P_LAST_UPDATE_DATE IN DATE,
2582 P_LAST_UPDATED_BY IN NUMBER,
2583 P_PRIORITY IN NUMBER,
2584 P_DESCRIPTION IN VARCHAR2,
2585 P_LAST_UPDATE_LOGIN IN NUMBER,
2586 P_CREATION_DATE IN DATE,
2587 P_CREATED_BY IN NUMBER) IS
2588 BEGIN
2589 NULL;
2590 END SYNC_LTE_RULES;
2591
2592 /* =========================================================================*
2593 | Procedure Name: SYNC_LTE_CAT_DTL
2594 | Product using
2595 | this Procedure : Will be called by JL, from Latin Tax Category Details
2596 | Form
2597 |
2598 | Purpose: Will be used to Synchronize data with eTax Gateway entity.
2599 |
2600 *========================================================================*/
2601
2602 PROCEDURE SYNC_LTE_CAT_DTL (
2603 P_DML_TYPE IN VARCHAR2,
2604 P_TAX_CATEG_DTL_ID IN NUMBER,
2605 P_TAX_CATEGORY_ID IN NUMBER,
2606 P_END_DATE_ACTIVE IN DATE,
2607 P_MIN_TAXABLE_BASIS IN NUMBER,
2608 P_LAST_UPDATE_DATE IN DATE,
2609 P_LAST_UPDATED_BY IN NUMBER,
2610 P_MIN_AMOUNT IN NUMBER,
2611 P_MIN_PERCENTAGE IN NUMBER,
2612 P_TAX_CODE IN VARCHAR2,
2613 P_START_DATE_ACTIVE IN DATE,
2614 P_LAST_UPDATE_LOGIN IN NUMBER,
2615 P_CREATION_DATE IN DATE,
2616 P_CREATED_BY IN NUMBER,
2617 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
2618 P_ATTRIBUTE1 IN VARCHAR2,
2619 P_ATTRIBUTE2 IN VARCHAR2,
2620 P_ATTRIBUTE3 IN VARCHAR2,
2621 P_ATTRIBUTE4 IN VARCHAR2,
2622 P_ATTRIBUTE5 IN VARCHAR2,
2623 P_ATTRIBUTE6 IN VARCHAR2,
2624 P_ATTRIBUTE7 IN VARCHAR2,
2625 P_ATTRIBUTE8 IN VARCHAR2,
2626 P_ATTRIBUTE9 IN VARCHAR2,
2627 P_ATTRIBUTE10 IN VARCHAR2,
2628 P_ATTRIBUTE11 IN VARCHAR2,
2629 P_ATTRIBUTE12 IN VARCHAR2,
2630 P_ATTRIBUTE13 IN VARCHAR2,
2631 P_ATTRIBUTE14 IN VARCHAR2,
2632 P_ATTRIBUTE15 IN VARCHAR2) IS
2633 BEGIN
2634 NULL;
2635 END SYNC_LTE_CAT_DTL;
2636
2637 /* =========================================================================*
2638 | Procedure Name: SYNC_LTE_SCHEDULES
2639 | Product using
2640 | this Procedure : Will be called by JL, from Latin Tax Category Schedules
2641 | Form
2642 |
2643 | Purpose: Will be used to Synchronize data with eTax Gateway entity.
2644 |
2645 *========================================================================*/
2646
2647 PROCEDURE SYNC_LTE_SCHEDULES (
2648 P_DML_TYPE IN VARCHAR2,
2649 P_TAX_CATEG_SLAB_ID IN NUMBER,
2650 P_TAX_CATEGORY_ID IN NUMBER,
2651 P_END_DATE_ACTIVE IN DATE,
2652 P_MIN_TAXABLE_BASIS IN NUMBER,
2653 P_LAST_UPDATE_DATE IN DATE,
2654 P_LAST_UPDATED_BY IN NUMBER,
2655 P_MAX_TAXABLE_BASIS IN NUMBER,
2656 P_TAX_CODE IN VARCHAR2,
2657 P_START_DATE_ACTIVE IN DATE,
2658 P_LAST_UPDATE_LOGIN IN NUMBER,
2659 P_CREATION_DATE IN DATE,
2660 P_CREATED_BY IN NUMBER,
2661 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
2662 P_ATTRIBUTE1 IN VARCHAR2,
2663 P_ATTRIBUTE2 IN VARCHAR2,
2664 P_ATTRIBUTE3 IN VARCHAR2,
2665 P_ATTRIBUTE4 IN VARCHAR2,
2666 P_ATTRIBUTE5 IN VARCHAR2,
2667 P_ATTRIBUTE6 IN VARCHAR2,
2668 P_ATTRIBUTE7 IN VARCHAR2,
2669 P_ATTRIBUTE8 IN VARCHAR2,
2670 P_ATTRIBUTE9 IN VARCHAR2,
2671 P_ATTRIBUTE10 IN VARCHAR2,
2672 P_ATTRIBUTE11 IN VARCHAR2,
2673 P_ATTRIBUTE12 IN VARCHAR2,
2674 P_ATTRIBUTE13 IN VARCHAR2,
2675 P_ATTRIBUTE14 IN VARCHAR2,
2676 P_ATTRIBUTE15 IN VARCHAR2) IS
2677 BEGIN
2678 NULL;
2679 END SYNC_LTE_SCHEDULES;
2680
2681 /* =========================================================================*
2682 | Procedure Name: SYNC_LTE_LGL_MSG
2683 | Product using
2684 | this Procedure : Will be called by JL, from Associate Latin Tax Legal
2685 | Messages Form
2686 |
2687 | Purpose: Will be used to Synchronize data with eTax Gateway entity.
2688 |
2689 *========================================================================*/
2690
2691 PROCEDURE SYNC_LTE_LGL_MSG (
2692 P_DML_TYPE IN VARCHAR2,
2693 P_RULE_ID IN NUMBER,
2694 P_RULE_DATA_ID IN NUMBER,
2695 P_EXCEPTION_CODE IN VARCHAR2,
2696 P_MESSAGE_ID IN NUMBER,
2697 P_INVENTORY_ITEM_FLAG IN VARCHAR2,
2698 P_INVENTORY_ORGANIZATION_ID IN NUMBER,
2699 P_START_DATE_ACTIVE IN DATE,
2700 P_END_DATE_ACTIVE IN DATE,
2701 P_LAST_UPDATE_DATE IN DATE,
2702 P_LAST_UPDATED_BY IN NUMBER,
2703 P_LAST_UPDATE_LOGIN IN NUMBER,
2704 P_CREATION_DATE IN DATE,
2705 P_CREATED_BY IN NUMBER) IS
2706 BEGIN
2707 NULL;
2708 END SYNC_LTE_LGL_MSG;
2709
2710 /* =========================================================================*
2711 | Procedure Name: SYNC_LTE_CUS_CLS
2712 | Product using
2713 | this Procedure : Will be called by JL, from Latin Tax Customer Site
2714 | Profile Form
2715 |
2716 | Purpose: Will be used to Synchronize data with eTax Gateway entity.
2717 |
2718 *========================================================================*/
2719
2720 PROCEDURE SYNC_LTE_CUS_CLS (
2721 P_DML_TYPE IN VARCHAR2,
2722 P_CUS_CLASS_ID IN NUMBER,
2723 P_ADDRESS_ID IN NUMBER,
2724 P_TAX_ATTR_CLASS_CODE IN VARCHAR2,
2725 P_TAX_CATEGORY_ID IN NUMBER,
2726 P_TAX_ATTRIBUTE_NAME IN VARCHAR2,
2727 P_TAX_ATTRIBUTE_VALUE IN VARCHAR2,
2728 P_ENABLED_FLAG IN VARCHAR2,
2729 P_LAST_UPDATED_BY IN NUMBER,
2730 P_LAST_UPDATE_DATE IN DATE,
2731 P_LAST_UPDATE_LOGIN IN NUMBER,
2732 P_CREATION_DATE IN DATE,
2733 P_CREATED_BY IN NUMBER) IS
2734 BEGIN
2735 NULL;
2736 END SYNC_LTE_CUS_CLS;
2737
2738 /* =========================================================================*
2739 | Procedure Name: SYNC_LTE_EXC_FSC
2740 | Product using
2741 | this Procedure : Will be called by JL, from Latin Tax Exceptions by Fiscal
2742 | Classification Form
2743 |
2744 | Purpose: Will be used to Synchronize data with eTax Gateway entity.
2745 |
2746 *========================================================================*/
2747
2748 PROCEDURE SYNC_LTE_EXC_FSC (
2749 P_DML_TYPE IN VARCHAR2,
2750 P_EXC_FSC_ID IN NUMBER,
2751 P_SHIP_FROM_CODE IN VARCHAR2,
2752 P_SHIP_TO_SEGMENT_ID IN NUMBER,
2753 P_FISCAL_CLASSIFICATION_CODE IN VARCHAR2,
2754 P_TAX_CATEGORY_ID IN NUMBER,
2755 P_END_DATE_ACTIVE IN DATE,
2756 P_START_DATE_ACTIVE IN DATE,
2757 P_TAX_CODE IN VARCHAR2,
2758 P_BASE_RATE IN NUMBER,
2759 P_LAST_UPDATED_BY IN NUMBER,
2760 P_LAST_UPDATE_DATE IN DATE,
2761 P_LAST_UPDATE_LOGIN IN NUMBER,
2762 P_CREATION_DATE IN DATE,
2763 P_CREATED_BY IN NUMBER,
2764 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
2765 P_ATTRIBUTE1 IN VARCHAR2,
2766 P_ATTRIBUTE2 IN VARCHAR2,
2767 P_ATTRIBUTE3 IN VARCHAR2,
2768 P_ATTRIBUTE4 IN VARCHAR2,
2769 P_ATTRIBUTE5 IN VARCHAR2,
2770 P_ATTRIBUTE6 IN VARCHAR2,
2771 P_ATTRIBUTE7 IN VARCHAR2,
2772 P_ATTRIBUTE8 IN VARCHAR2,
2773 P_ATTRIBUTE9 IN VARCHAR2,
2774 P_ATTRIBUTE10 IN VARCHAR2,
2775 P_ATTRIBUTE11 IN VARCHAR2,
2776 P_ATTRIBUTE12 IN VARCHAR2,
2777 P_ATTRIBUTE13 IN VARCHAR2,
2778 P_ATTRIBUTE14 IN VARCHAR2,
2779 P_ATTRIBUTE15 IN VARCHAR2) IS
2780 BEGIN
2781 NULL;
2782 END SYNC_LTE_EXC_FSC;
2783
2784 /* =========================================================================*
2785 | Procedure Name: SYNC_LTE_EXC_ITM
2786 | Product using
2787 | this Procedure : Will be called by JL, from Latin Tax Exceptions by Item
2788 | Form
2789 |
2790 | Purpose: Will be used to Synchronize data with eTax Gateway entity.
2791 |
2792 *========================================================================*/
2793
2794 PROCEDURE SYNC_LTE_EXC_ITM (
2795 P_DML_TYPE IN VARCHAR2,
2796 P_EXC_ITM_ID IN NUMBER,
2797 P_SHIP_FROM_CODE IN VARCHAR2,
2798 P_SHIP_TO_SEGMENT_ID IN NUMBER,
2799 P_INVENTORY_ITEM_ID IN NUMBER,
2800 P_ORGANIZATION_ID IN NUMBER,
2801 P_TAX_CATEGORY_ID IN NUMBER,
2802 P_END_DATE_ACTIVE IN DATE,
2803 P_START_DATE_ACTIVE IN DATE,
2804 P_TAX_CODE IN VARCHAR2,
2805 P_BASE_RATE IN NUMBER,
2806 P_LAST_UPDATED_BY IN NUMBER,
2807 P_LAST_UPDATE_DATE IN DATE,
2808 P_LAST_UPDATE_LOGIN IN NUMBER,
2809 P_CREATION_DATE IN DATE,
2810 P_CREATED_BY IN NUMBER,
2811 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
2812 P_ATTRIBUTE1 IN VARCHAR2,
2813 P_ATTRIBUTE2 IN VARCHAR2,
2814 P_ATTRIBUTE3 IN VARCHAR2,
2815 P_ATTRIBUTE4 IN VARCHAR2,
2816 P_ATTRIBUTE5 IN VARCHAR2,
2817 P_ATTRIBUTE6 IN VARCHAR2,
2818 P_ATTRIBUTE7 IN VARCHAR2,
2819 P_ATTRIBUTE8 IN VARCHAR2,
2820 P_ATTRIBUTE9 IN VARCHAR2,
2821 P_ATTRIBUTE10 IN VARCHAR2,
2822 P_ATTRIBUTE11 IN VARCHAR2,
2823 P_ATTRIBUTE12 IN VARCHAR2,
2824 P_ATTRIBUTE13 IN VARCHAR2,
2825 P_ATTRIBUTE14 IN VARCHAR2,
2826 P_ATTRIBUTE15 IN VARCHAR2) IS
2827 BEGIN
2828 NULL;
2829 END SYNC_LTE_EXC_ITM;
2830
2831 /* =========================================================================*
2832 | Procedure Name: SYNC_LTE_EXC_CUS
2833 | Product using
2834 | this Procedure : Will be called by JL, from Latin Tax Exceptions by
2835 | Customer Sites Form
2836 |
2837 | Purpose: Will be used to Synchronize data with eTax Gateway entity.
2838 |
2839 *========================================================================*/
2840
2841 PROCEDURE SYNC_LTE_EXC_CUS (
2842 P_DML_TYPE IN VARCHAR2,
2843 P_EXC_CUS_ID IN NUMBER,
2844 P_ADDRESS_ID IN NUMBER,
2845 P_TAX_CATEGORY_ID IN NUMBER,
2846 P_END_DATE_ACTIVE IN DATE,
2847 P_LAST_UPDATE_DATE IN DATE,
2848 P_LAST_UPDATED_BY IN NUMBER,
2849 P_TAX_CODE IN VARCHAR2,
2850 P_BASE_RATE IN NUMBER,
2851 P_START_DATE_ACTIVE IN DATE,
2852 P_LAST_UPDATE_LOGIN IN NUMBER,
2853 P_CREATION_DATE IN DATE,
2854 P_CREATED_BY IN NUMBER,
2855 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
2856 P_ATTRIBUTE1 IN VARCHAR2,
2857 P_ATTRIBUTE2 IN VARCHAR2,
2858 P_ATTRIBUTE3 IN VARCHAR2,
2859 P_ATTRIBUTE4 IN VARCHAR2,
2860 P_ATTRIBUTE5 IN VARCHAR2,
2861 P_ATTRIBUTE6 IN VARCHAR2,
2862 P_ATTRIBUTE7 IN VARCHAR2,
2863 P_ATTRIBUTE8 IN VARCHAR2,
2864 P_ATTRIBUTE9 IN VARCHAR2,
2865 P_ATTRIBUTE10 IN VARCHAR2,
2866 P_ATTRIBUTE11 IN VARCHAR2,
2867 P_ATTRIBUTE12 IN VARCHAR2,
2868 P_ATTRIBUTE13 IN VARCHAR2,
2869 P_ATTRIBUTE14 IN VARCHAR2,
2870 P_ATTRIBUTE15 IN VARCHAR2) IS
2871 BEGIN
2872 NULL;
2873 END SYNC_LTE_EXC_CUS;
2874
2875 /* =========================================================================*
2876 | Procedure Name: SYNC_LTE_NAT_RAT
2877 | Product using
2878 | this Procedure : Will be called by JL, from Latin Tax Exceptions by
2879 | Transaction Condition Values Form
2880 |
2881 | Purpose: Will be used to Synchronize data with eTax Gateway entity.
2882 |
2883 *========================================================================*/
2884
2885 PROCEDURE SYNC_LTE_NAT_RAT (
2886 P_DML_TYPE IN VARCHAR2,
2887 P_TXN_NATURE_ID IN NUMBER,
2888 P_LAST_UPDATE_DATE IN DATE,
2889 P_LAST_UPDATED_BY IN NUMBER,
2890 P_CREATION_DATE IN DATE,
2891 P_CREATED_BY IN NUMBER,
2892 P_LAST_UPDATE_LOGIN IN NUMBER,
2893 P_TAX_CATEG_ATTR_VAL_ID IN NUMBER,
2894 P_END_DATE_ACTIVE IN DATE,
2895 P_TAX_CODE IN VARCHAR2,
2896 P_MIN_TAXABLE_BASIS IN NUMBER,
2897 P_MIN_AMOUNT IN NUMBER,
2898 P_MIN_PERCENTAGE IN NUMBER,
2899 P_BASE_RATE IN NUMBER,
2900 P_START_DATE_ACTIVE IN DATE,
2901 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
2902 P_ATTRIBUTE1 IN VARCHAR2,
2903 P_ATTRIBUTE2 IN VARCHAR2,
2904 P_ATTRIBUTE3 IN VARCHAR2,
2905 P_ATTRIBUTE4 IN VARCHAR2,
2906 P_ATTRIBUTE5 IN VARCHAR2,
2907 P_ATTRIBUTE6 IN VARCHAR2,
2908 P_ATTRIBUTE7 IN VARCHAR2,
2909 P_ATTRIBUTE8 IN VARCHAR2,
2910 P_ATTRIBUTE9 IN VARCHAR2,
2911 P_ATTRIBUTE10 IN VARCHAR2,
2912 P_ATTRIBUTE11 IN VARCHAR2,
2913 P_ATTRIBUTE12 IN VARCHAR2,
2914 P_ATTRIBUTE13 IN VARCHAR2,
2915 P_ATTRIBUTE14 IN VARCHAR2,
2916 P_ATTRIBUTE15 IN VARCHAR2) IS
2917 BEGIN
2918 NULL;
2919 END SYNC_LTE_NAT_RAT;
2920
2921
2922 /* =========================================================================*
2923 | Procedure Name: SYNC_AR_TAX_CONDITION_ACTIONS
2924 |
2925 | Purpose: Will be used to Synchronize the data between the AR Tax Conditons and
2926 | eTax Tax Definition, Tax Rules, Tax Conditions Gateway entity.
2927 |
2928 | Will be called from Tax Groups form, passing the attributes
2929 | required for synchronization.
2930 |
2931 | This stubbed version will do nothing.
2932 |
2933 | In later version of the Procedure(delivered in ZX),
2934 | it will be replaced with the actual solution for synchronizing
2935 | data between the source (Tax Groups) and eTax Tax Definition,
2936 | Rules, Conditions Gateway entity
2937 |
2938 *=========================================================================*/
2939
2940 PROCEDURE SYNC_AR_TAX_CONDITION_ACTIONS
2941 (
2942 P_DML_TYPE IN VARCHAR2,
2943 P_TAX_CONDITION_ACTION_ID IN NUMBER,
2944 P_CREATED_BY IN NUMBER,
2945 P_TAX_CONDITION_ID IN NUMBER,
2946 P_CREATION_DATE IN DATE,
2947 P_TAX_CONDITION_ACTION_TYPE IN VARCHAR2,
2948 P_DISPLAY_ORDER IN NUMBER,
2949 P_LAST_UPDATED_BY IN NUMBER,
2950 P_LAST_UPDATE_DATE IN DATE,
2951 P_LAST_UPDATE_LOGIN IN NUMBER,
2952 P_TAX_CONDITION_ACTION_CODE IN VARCHAR2,
2953 P_TAX_CONDITION_ACTION_VALUE IN VARCHAR2,
2954 P_ORG_ID IN NUMBER,
2955 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
2956 P_ATTRIBUTE1 IN VARCHAR2,
2957 P_ATTRIBUTE2 IN VARCHAR2,
2958 P_ATTRIBUTE3 IN VARCHAR2,
2959 P_ATTRIBUTE4 IN VARCHAR2,
2960 P_ATTRIBUTE5 IN VARCHAR2,
2961 P_ATTRIBUTE6 IN VARCHAR2,
2962 P_ATTRIBUTE7 IN VARCHAR2,
2963 P_ATTRIBUTE8 IN VARCHAR2,
2964 P_ATTRIBUTE9 IN VARCHAR2,
2965 P_ATTRIBUTE10 IN VARCHAR2,
2966 P_ATTRIBUTE11 IN VARCHAR2,
2967 P_ATTRIBUTE12 IN VARCHAR2,
2968 P_ATTRIBUTE13 IN VARCHAR2,
2969 P_ATTRIBUTE14 IN VARCHAR2,
2970 P_ATTRIBUTE15 IN VARCHAR2,
2971 P_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
2972 P_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
2973 P_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
2974 P_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
2975 P_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
2976 P_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
2977 P_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
2978 P_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
2979 P_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
2980 P_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
2981 P_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
2982 P_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
2983 P_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
2984 P_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
2985 P_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
2986 P_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
2987 P_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
2988 P_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
2989 P_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
2990 P_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
2991 P_GLOBAL_ATTRIBUTE20 IN VARCHAR2
2992 )
2993 IS
2994 BEGIN
2995 NULL;
2996 END SYNC_AR_TAX_CONDITION_ACTIONS;
2997
2998
2999 /* =========================================================================*
3000 | Procedure Name: SYNC_AR_TAX_CONDITION_LINES
3001 |
3002 | Purpose: Will be used to Synchronize the data between the AR Tax Conditons and
3003 | eTax Tax Definition, Tax Rules, Tax Conditions Gateway entity.
3004 |
3005 | Will be called from Tax Groups form, passing the attributes
3006 | required for synchronization.
3007 |
3008 | This stubbed version will do nothing.
3009 |
3010 | In later version of the Procedure(delivered in ZX),
3011 | it will be replaced with the actual solution for synchronizing
3012 | data between the source (Tax Groups) and eTax Tax Definition,
3013 | Rules, Conditions Gateway entity
3014 |
3015 *=========================================================================*/
3016
3017 PROCEDURE SYNC_AR_TAX_CONDITON_LINES
3018 (
3019 P_DML_TYPE IN VARCHAR2,
3020 P_TAX_CONDITION_LINE_ID IN NUMBER,
3021 P_CREATED_BY IN NUMBER,
3022 P_TAX_CONDITION_ID IN NUMBER,
3023 P_CREATION_DATE IN DATE,
3024 P_DISPLAY_ORDER IN NUMBER,
3025 P_LAST_UPDATED_BY IN NUMBER,
3026 P_LAST_UPDATE_DATE IN DATE,
3027 P_LAST_UPDATE_LOGIN IN NUMBER,
3028 P_TAX_CONDITION_CLAUSE IN VARCHAR2,
3029 P_TAX_CONDITION_ENTITY IN VARCHAR2,
3030 P_TAX_CONDITION_OPERATOR IN VARCHAR2,
3031 P_TAX_CONDITION_FIELD IN VARCHAR2,
3032 P_TAX_CONDITION_VALUE IN VARCHAR2,
3033 P_TAX_CONDITION_EXPR IN VARCHAR2,
3034 P_ORG_ID IN NUMBER,
3035 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
3036 P_ATTRIBUTE1 IN VARCHAR2,
3037 P_ATTRIBUTE2 IN VARCHAR2,
3038 P_ATTRIBUTE3 IN VARCHAR2,
3039 P_ATTRIBUTE4 IN VARCHAR2,
3040 P_ATTRIBUTE5 IN VARCHAR2,
3041 P_ATTRIBUTE6 IN VARCHAR2,
3042 P_ATTRIBUTE7 IN VARCHAR2,
3043 P_ATTRIBUTE8 IN VARCHAR2,
3044 P_ATTRIBUTE9 IN VARCHAR2,
3045 P_ATTRIBUTE10 IN VARCHAR2,
3046 P_ATTRIBUTE11 IN VARCHAR2,
3047 P_ATTRIBUTE12 IN VARCHAR2,
3048 P_ATTRIBUTE13 IN VARCHAR2,
3049 P_ATTRIBUTE14 IN VARCHAR2,
3050 P_ATTRIBUTE15 IN VARCHAR2,
3051 P_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
3052 P_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
3053 P_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
3054 P_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
3055 P_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
3056 P_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
3057 P_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
3058 P_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
3059 P_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
3060 P_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
3061 P_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
3062 P_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
3063 P_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
3064 P_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
3065 P_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
3066 P_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
3067 P_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
3068 P_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
3069 P_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
3070 P_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
3071 P_GLOBAL_ATTRIBUTE20 IN VARCHAR2
3072 )
3073 IS
3074 BEGIN
3075 NULL;
3076 END SYNC_AR_TAX_CONDITON_LINES;
3077
3078
3079 /* =========================================================================*
3080 | Procedure Name: SYNC_AR_TAX_CONDITIONS
3081 |
3082 | Purpose: Will be used to Synchronize the data between the AR Tax Conditons and
3083 | eTax Tax Definition, Tax Rules, Tax Conditions Gateway entity.
3084 |
3085 | Will be called from Tax Groups form, passing the attributes
3086 | required for synchronization.
3087 |
3088 | This stubbed version will do nothing.
3089 |
3090 | In later version of the Procedure(delivered in ZX),
3091 | it will be replaced with the actual solution for synchronizing
3092 | data between the source (Tax Groups) and eTax Tax Definition,
3093 | Rules, Conditions Gateway entity
3094 |
3095 *=========================================================================*/
3096
3097 PROCEDURE SYNC_AR_TAX_CONDITIONS
3098 (
3099 P_DML_TYPE IN VARCHAR2,
3100 P_TAX_CONDITION_ID IN NUMBER,
3101 P_CREATED_BY IN NUMBER,
3102 P_CREATION_DATE IN DATE,
3103 P_LAST_UPDATED_BY IN NUMBER,
3104 P_LAST_UPDATE_DATE IN DATE,
3105 P_LAST_UPDATE_LOGIN IN NUMBER,
3106 P_TAX_CONDITION_NAME IN VARCHAR2,
3107 P_TAX_CONDITION_TYPE IN VARCHAR2,
3108 P_TAX_CONDITION_EXPR IN VARCHAR2,
3109 P_ORG_ID IN NUMBER,
3110 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
3111 P_ATTRIBUTE1 IN VARCHAR2,
3112 P_ATTRIBUTE2 IN VARCHAR2,
3113 P_ATTRIBUTE3 IN VARCHAR2,
3114 P_ATTRIBUTE4 IN VARCHAR2,
3115 P_ATTRIBUTE5 IN VARCHAR2,
3116 P_ATTRIBUTE6 IN VARCHAR2,
3117 P_ATTRIBUTE7 IN VARCHAR2,
3118 P_ATTRIBUTE8 IN VARCHAR2,
3119 P_ATTRIBUTE9 IN VARCHAR2,
3120 P_ATTRIBUTE10 IN VARCHAR2,
3121 P_ATTRIBUTE11 IN VARCHAR2,
3122 P_ATTRIBUTE12 IN VARCHAR2,
3123 P_ATTRIBUTE13 IN VARCHAR2,
3124 P_ATTRIBUTE14 IN VARCHAR2,
3125 P_ATTRIBUTE15 IN VARCHAR2,
3126 P_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
3127 P_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
3128 P_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
3129 P_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
3130 P_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
3131 P_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
3132 P_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
3133 P_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
3134 P_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
3135 P_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
3136 P_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
3137 P_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
3138 P_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
3139 P_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
3140 P_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
3141 P_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
3142 P_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
3143 P_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
3144 P_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
3145 P_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
3146 P_GLOBAL_ATTRIBUTE20 IN VARCHAR2
3147 )
3148 IS
3149 BEGIN
3150 NULL;
3151 END SYNC_AR_TAX_CONDITIONS;
3152
3153
3154 /* =========================================================================*
3155 | Procedure Name: SYNC_AR_TAX_EXCEPTIONS
3156 |
3157 | Purpose: Will be used to Synchronize the data between the AR Tax Exceptions and
3158 | eTax Tax Definition, Tax Rules, Tax Conditions Gateway entity.
3159 |
3160 | Will be called from AR Tax Exceptions form, passing the attributes
3161 | required for synchronization.
3162 |
3163 | This stubbed version will do nothing.
3164 |
3165 | In later version of the Procedure(delivered in ZX),
3166 | it will be replaced with the actual solution for synchronizing
3167 | data between the source (Tax Exception) and eTax Tax Definition,
3168 | Rules, Conditions Gateway entity
3169 |
3170 *=========================================================================*/
3171
3172 PROCEDURE SYNC_AR_TAX_EXCEPTIONS
3173 (
3174 P_Dml_Type IN VARCHAR2,
3175 P_Org_Id IN NUMBER,
3176 P_Item_Exception_Rate_Id IN NUMBER,
3177 P_Creation_Date IN DATE,
3178 P_Created_By IN NUMBER,
3179 P_Last_Update_Login IN NUMBER,
3180 P_Last_Updated_By IN NUMBER,
3181 P_Last_Update_Date IN DATE,
3182 P_Item_Id IN NUMBER,
3183 P_Rate_Context IN VARCHAR2,
3184 P_Location1_Rate IN NUMBER,
3185 P_Location2_Rate IN NUMBER,
3186 P_Location3_Rate IN NUMBER,
3187 P_Location4_Rate IN NUMBER,
3188 P_Location5_Rate IN NUMBER,
3189 P_Location6_Rate IN NUMBER,
3190 P_Location7_Rate IN NUMBER,
3191 P_Location8_Rate IN NUMBER,
3192 P_Location9_Rate IN NUMBER,
3193 P_Location10_Rate IN NUMBER,
3194 P_Start_Date IN DATE,
3195 P_End_Date IN DATE,
3196 P_Attribute_Category IN VARCHAR2,
3197 P_Attribute1 IN VARCHAR2,
3198 P_Attribute2 IN VARCHAR2,
3199 P_Attribute3 IN VARCHAR2,
3200 P_Attribute4 IN VARCHAR2,
3201 P_Attribute5 IN VARCHAR2,
3202 P_Attribute6 IN VARCHAR2,
3203 P_Attribute7 IN VARCHAR2,
3204 P_Attribute8 IN VARCHAR2,
3205 P_Attribute9 IN VARCHAR2,
3206 P_Attribute10 IN VARCHAR2,
3207 P_Attribute11 IN VARCHAR2,
3208 P_Attribute12 IN VARCHAR2,
3209 P_Attribute13 IN VARCHAR2,
3210 P_Attribute14 IN VARCHAR2,
3211 P_Attribute15 IN VARCHAR2,
3212 P_Reason_Code IN VARCHAR2,
3213 P_Location_Context IN VARCHAR2,
3214 P_Location_Id_Segment_1 IN NUMBER,
3215 P_Location_Id_Segment_2 IN NUMBER,
3216 P_Location_Id_Segment_3 IN NUMBER,
3217 P_Location_Id_Segment_4 IN NUMBER,
3218 P_Location_Id_Segment_5 IN NUMBER,
3219 P_Location_Id_Segment_6 IN NUMBER,
3220 P_Location_Id_Segment_7 IN NUMBER,
3221 P_Location_Id_Segment_8 IN NUMBER,
3222 P_Location_Id_Segment_9 IN NUMBER,
3223 P_Location_Id_Segment_10 IN NUMBER
3224 )
3225 IS
3226 BEGIN
3227 NULL;
3228 END SYNC_AR_TAX_EXCEPTIONS;
3229
3230
3231
3232 /* =========================================================================*
3233 | Procedure Name: SYNC_AR_TAX_EXEMPTIONS
3234 |
3235 | Purpose: Will be used to Synchronize the data between the AR Tax Exemptions and
3236 | eTax Tax Definition, Tax Rules, Tax Conditions Gateway entity.
3237 |
3238 | Will be called from AR Tax Exemptions form, passing the attributes
3239 | required for synchronization.
3240 |
3241 | This stubbed version will do nothing.
3242 |
3243 | In later version of the Procedure(delivered in ZX),
3244 | it will be replaced with the actual solution for synchronizing
3245 | data between the source (Tax Exemption) and eTax Tax Definition,
3246 | Rules, Conditions Gateway entity
3247 |
3248 *=========================================================================*/
3249
3250 PROCEDURE SYNC_AR_TAX_EXEMPTIONS
3251 (
3252 P_Dml_Type IN VARCHAR2,
3253 P_Org_Id IN NUMBER,
3254 p_Tax_exemption_id IN NUMBER,
3255 p_Last_updated_by IN NUMBER,
3256 p_Last_update_date IN DATE,
3257 p_Created_by IN NUMBER,
3258 p_Creation_date IN DATE,
3259 p_Status IN VARCHAR2,
3260 p_Inventory_item_id IN NUMBER,
3261 p_Customer_id IN NUMBER,
3262 p_Site_use_id IN NUMBER,
3263 p_Exemption_type IN VARCHAR2,
3264 p_Tax_code IN VARCHAR2,
3265 p_Percent_exempt IN NUMBER,
3266 p_Customer_exemption_number IN VARCHAR2,
3267 p_Start_date IN DATE,
3268 p_End_date IN DATE,
3269 p_Location_context IN VARCHAR2,
3270 p_Location_id_segment_1 IN NUMBER,
3271 p_Location_id_segment_2 IN NUMBER,
3272 p_Location_id_segment_3 IN NUMBER,
3273 p_Location_id_segment_4 IN NUMBER,
3274 p_Location_id_segment_5 IN NUMBER,
3275 p_Location_id_segment_6 IN NUMBER,
3276 p_Location_id_segment_7 IN NUMBER,
3277 p_Location_id_segment_8 IN NUMBER,
3278 p_Location_id_segment_9 IN NUMBER,
3279 p_Location_id_segment_10 IN NUMBER,
3280 p_Attribute_category IN VARCHAR2,
3281 p_Attribute1 IN VARCHAR2,
3282 p_Attribute2 IN VARCHAR2,
3283 p_Attribute3 IN VARCHAR2,
3284 p_Attribute4 IN VARCHAR2,
3285 p_Attribute5 IN VARCHAR2,
3286 p_Attribute6 IN VARCHAR2,
3287 p_Attribute7 IN VARCHAR2,
3288 p_Attribute8 IN VARCHAR2,
3289 p_Attribute9 IN VARCHAR2,
3290 p_Attribute10 IN VARCHAR2,
3291 p_Attribute11 IN VARCHAR2,
3292 p_Attribute12 IN VARCHAR2,
3293 p_Attribute13 IN VARCHAR2,
3294 p_Attribute14 IN VARCHAR2,
3295 p_Attribute15 IN VARCHAR2,
3296 p_In_use_flag IN VARCHAR2,
3297 p_Program_id IN NUMBER,
3298 p_Program_update_date IN DATE,
3299 p_Request_id IN NUMBER,
3300 p_Program_application_id IN NUMBER,
3301 p_Reason_code IN VARCHAR2,
3302 p_Exempt_Context IN VARCHAR2,
3303 p_Exempt_percent1 IN NUMBER,
3304 p_Exempt_percent2 IN NUMBER,
3305 p_Exempt_percent3 IN NUMBER,
3306 p_Exempt_percent4 IN NUMBER,
3307 p_Exempt_percent5 IN NUMBER,
3308 p_Exempt_percent6 IN NUMBER,
3309 p_Exempt_percent7 IN NUMBER,
3310 p_Exempt_percent8 IN NUMBER,
3311 p_Exempt_percent9 IN NUMBER,
3312 p_Exempt_percent10 IN NUMBER
3313 )
3314 IS
3315 BEGIN
3316 NULL;
3317 END SYNC_AR_TAX_EXEMPTIONS;
3318
3319 /*==========================================================
3320 | This procudure inserts data into
3321 | subscription tables for LTE
3322 | Call from : SYNC_AR_VAT_TAX
3323 ==========================================================*/
3324 PROCEDURE migrate_sco_code_lte(
3325 P_TAX_REGIME_CODE IN VARCHAR2 DEFAULT NULL,
3326 P_ORG_ID IN NUMBER,
3327 P_CREATION_DATE IN DATE,
3328 P_CREATED_BY IN NUMBER,
3329 P_LAST_UPDATE_DATE IN DATE,
3330 P_LAST_UPDATED_BY IN NUMBER,
3331 P_LAST_UPDATE_LOGIN IN NUMBER
3332 ) IS
3333
3334 CURSOR pty_org_id_cur IS
3335 SELECT party_tax_profile_id
3336 FROM zx_party_tax_profile
3337 WHERE party_id = P_ORG_ID
3338 AND party_type_code = 'OU';
3339
3340 CURSOR regm_id IS
3341 SELECT tax_regime_id,effective_from
3342 FROM zx_regimes_b
3343 WHERE tax_regime_code = P_TAX_REGIME_CODE;
3344
3345
3346 CURSOR sub_usage_id_cur (c_tax_regime_code zx_regimes_b.tax_regime_code%type,
3347 c_pty_org_id NUMBER)IS
3348 SELECT COUNT(*)
3349 FROM zx_subscription_options
3350 WHERE REGIME_USAGE_ID
3351 IN (SELECT REGIME_USAGE_ID
3352 FROM ZX_REGIMES_USAGES
3353 WHERE tax_regime_code = c_tax_regime_code
3354 AND FIRST_PTY_ORG_ID = c_pty_org_id);
3355
3356 l_pty_org_id NUMBER;
3357 l_regime_id NUMBER;
3358 l_regime_usage_id NUMBER;
3359 l_regm_start_date DATE;
3360 l_sub_opt_id NUMBER;
3361 l_count NUMBER;
3362
3363 BEGIN
3364
3365 arp_util_tax.debug('MIGRATE_SCO_CODE_LTE(+)');
3366 arp_util_tax.debug('Regime tax Code :'||p_tax_regime_code);
3367 arp_util_tax.debug('P_ORG_ID:'||to_char(P_ORG_ID));
3368
3369 OPEN pty_org_id_cur;
3370 FETCH pty_org_id_cur INTO l_pty_org_id;
3371 CLOSE pty_org_id_cur;
3372
3373 OPEN regm_id;
3374 FETCH regm_id INTO l_regime_id, l_regm_start_date;
3375 CLOSE regm_id;
3376
3377 OPEN sub_usage_id_cur(p_tax_regime_code,l_pty_org_id);
3378 FETCH sub_usage_id_cur INTO l_count;
3379
3380 arp_util_tax.debug('l_pty_org_id:'||to_char(l_pty_org_id));
3381 IF sub_usage_id_cur%NOTFOUND THEN
3382 BEGIN
3383 arp_util_tax.debug('sub_usage_id_cur NOTFOUND :');
3384
3385 SELECT zx_regimes_usages_s.nextval
3386 INTO l_regime_usage_id
3387 FROM dual;
3388
3389 SELECT zx_subscription_options_s.nextval
3390 INTO l_sub_opt_id
3391 FROM dual;
3392
3393 INSERT INTO zx_regimes_usages
3394 (regime_usage_id,
3395 first_pty_org_id,
3396 tax_regime_id,
3397 tax_regime_code,
3398 record_type_code,
3399 object_version_number,
3400 CREATED_BY,
3401 CREATION_DATE,
3402 LAST_UPDATED_BY,
3403 LAST_UPDATE_DATE,
3404 LAST_UPDATE_LOGIN)
3405 VALUES (l_regime_usage_id,
3406 l_pty_org_id,
3407 l_regime_id,
3408 P_TAX_REGIME_CODE,
3409 'MIGRATED',
3410 1,
3411 P_CREATED_BY,
3412 P_CREATION_DATE,
3413 P_LAST_UPDATED_BY,
3414 P_LAST_UPDATE_DATE,
3415 P_LAST_UPDATE_LOGIN);
3416
3417 INSERT INTO zx_subscription_options
3418 (SUBSCRIPTION_OPTION_ID,
3419 SUBSCRIPTION_OPTION_CODE,
3420 REGIME_USAGE_ID,
3421 EFFECTIVE_FROM,
3422 ENABLED_FLAG,
3423 ALLOW_SUBSCRIPTION_FLAG,
3424 RECORD_TYPE_CODE,
3425 CREATED_BY,
3426 CREATION_DATE,
3427 LAST_UPDATED_BY,
3428 LAST_UPDATE_DATE,
3429 LAST_UPDATE_LOGIN,
3430 EXCEPTION_OPTION_CODE)
3431 VALUES(l_sub_opt_id,
3432 'OWN_GCO',
3433 l_regime_usage_id,
3434 l_regm_start_date,
3435 'Y',
3436 'Y',
3437 'MIGRATED',
3438 P_CREATED_BY,
3439 P_CREATION_DATE,
3440 P_LAST_UPDATED_BY,
3441 P_LAST_UPDATE_DATE,
3442 P_LAST_UPDATE_LOGIN,
3443 'OWN_ONLY');
3444
3445 INSERT INTO zx_subscription_details
3446 (SUBSCRIPTION_DETAIL_ID,
3447 SUBSCRIPTION_OPTION_ID,
3448 FIRST_PTY_ORG_ID,
3449 PARENT_FIRST_PTY_ORG_ID,
3450 VIEW_OPTIONS_CODE,
3451 TAX_REGIME_CODE,
3452 EFFECTIVE_FROM,
3453 RECORD_TYPE_CODE,
3454 CREATED_BY,
3455 CREATION_DATE,
3456 LAST_UPDATED_BY,
3457 LAST_UPDATE_DATE,
3458 LAST_UPDATE_LOGIN)
3459 VALUES(zx_subscription_details_s.nextval,
3460 l_sub_opt_id,
3461 l_pty_org_id,
3462 l_pty_org_id,
3463 'VFC',
3464 P_TAX_REGIME_CODE,
3465 l_regm_start_date,
3466 'MIGRATED',
3467 P_CREATED_BY,
3468 P_CREATION_DATE,
3469 P_LAST_UPDATED_BY,
3470 P_LAST_UPDATE_DATE,
3471 P_LAST_UPDATE_LOGIN);
3472
3473 INSERT INTO zx_subscription_details
3474 (SUBSCRIPTION_DETAIL_ID,
3475 SUBSCRIPTION_OPTION_ID,
3476 FIRST_PTY_ORG_ID,
3477 PARENT_FIRST_PTY_ORG_ID,
3478 VIEW_OPTIONS_CODE,
3479 TAX_REGIME_CODE,
3480 EFFECTIVE_FROM,
3481 RECORD_TYPE_CODE,
3482 CREATED_BY,
3483 CREATION_DATE,
3484 LAST_UPDATED_BY,
3485 LAST_UPDATE_DATE,
3486 LAST_UPDATE_LOGIN)
3487 VALUES(zx_subscription_details_s.nextval,
3488 l_sub_opt_id,
3489 l_pty_org_id,
3490 -99,
3491 'VFR',
3492 P_TAX_REGIME_CODE,
3493 l_regm_start_date,
3494 'MIGRATED',
3495 P_CREATED_BY,
3496 P_CREATION_DATE,
3497 P_LAST_UPDATED_BY,
3498 P_LAST_UPDATE_DATE,
3499 P_LAST_UPDATE_LOGIN);
3500 END;
3501 END IF;
3502 CLOSE sub_usage_id_cur;
3503 arp_util_tax.debug('MIGRATE_SCO_CODE_LTE(-)');
3504 EXCEPTION
3505 WHEN OTHERS THEN
3506 CLOSE sub_usage_id_cur;
3507 END migrate_sco_code_lte;
3508
3509 /* ==========================================================================*
3510 | Procedure Name: GET_PTP
3511 | Purpose: This procedure will be called during upload,to populate
3512 | the party tax profile id(content_owner_id) in various
3513 | eTax target tables.
3514 *===========================================================================*/
3515
3516 PROCEDURE GET_PTP(
3517 p_party_id IN NUMBER,
3518 p_party_type IN VARCHAR2,
3519 p_ptp_id OUT NOCOPY NUMBER,
3520 p_return_status OUT NOCOPY VARCHAR2) IS
3521 BEGIN
3522 NULL;
3523 END;
3524
3525 /* =========================================================================*
3526 | Procedure Name: SYNC_AR_VAT_TAX
3527 |
3528 | Purpose: Will be used to Synchronize the data between the AR Tax Codes and
3529 | eTax Tax Definition, Tax Rules, Tax Conditions Gateway entity.
3530 |
3531 | Will be called from AR Tax Codes form, passing the attributes
3532 | required for synchronization.
3533 |
3534 | This stubbed version will do nothing.
3535 |
3536 | In later version of the Procedure(delivered in ZX),
3537 | it will be replaced with the actual solution for synchronizing
3538 | data between the source (AR Tax Codes) and eTax Tax Definition,
3539 | Rules, Conditions Gateway entity
3540 |
3541 *=========================================================================*/
3542 PROCEDURE SYNC_AR_VAT_TAX (
3543 P_DML_TYPE IN VARCHAR2,
3544 P_ORG_ID IN NUMBER,
3545 P_VAT_TAX_ID IN NUMBER,
3546 P_TAX_CONSTRAINT_ID IN NUMBER,
3547 P_TAX_CLASS IN VARCHAR2,
3548 P_DISPLAYED_FLAG IN VARCHAR2,
3549 P_ENABLED_FLAG IN VARCHAR2,
3550 P_AMOUNT_INCLUDES_TAX_FLAG IN VARCHAR2,
3551 P_AMOUNT_INCLUDES_TAX_OVERRIDE IN VARCHAR2,
3552 P_TAXABLE_BASIS IN VARCHAR2,
3553 P_TAX_CALCULATION_PLSQL_BLOCK IN VARCHAR2,
3554 P_INTERIM_TAX_CCID IN NUMBER,
3555 P_ADJ_CCID IN NUMBER,
3556 P_EDISC_CCID IN NUMBER,
3557 P_UNEDISC_CCID IN NUMBER,
3558 P_FINCHRG_CCID IN NUMBER,
3559 P_ADJ_NON_REC_TAX_CCID IN NUMBER,
3560 P_EDISC_NON_REC_TAX_CCID IN NUMBER,
3561 P_UNEDISC_NON_REC_TAX_CCID IN NUMBER,
3562 P_FINCHRG_NON_REC_TAX_CCID IN NUMBER,
3563 P_SET_OF_BOOKS_ID IN NUMBER,
3564 P_TAX_CODE IN VARCHAR2,
3565 P_TAX_RATE IN NUMBER,
3566 P_TAX_TYPE IN VARCHAR2,
3567 P_VALIDATE_FLAG IN VARCHAR2,
3568 P_TAX_ACCOUNT_ID IN NUMBER,
3569 P_START_DATE IN DATE,
3570 P_END_DATE IN DATE,
3571 P_ATTRIBUTE_CATEGORY IN VARCHAR2,
3572 P_ATTRIBUTE1 IN VARCHAR2,
3573 P_ATTRIBUTE2 IN VARCHAR2,
3574 P_ATTRIBUTE3 IN VARCHAR2,
3575 P_ATTRIBUTE4 IN VARCHAR2,
3576 P_ATTRIBUTE5 IN VARCHAR2,
3577 P_ATTRIBUTE6 IN VARCHAR2,
3578 P_ATTRIBUTE7 IN VARCHAR2,
3579 P_ATTRIBUTE8 IN VARCHAR2,
3580 P_ATTRIBUTE9 IN VARCHAR2,
3581 P_ATTRIBUTE10 IN VARCHAR2,
3582 P_ATTRIBUTE11 IN VARCHAR2,
3583 P_ATTRIBUTE12 IN VARCHAR2,
3584 P_ATTRIBUTE13 IN VARCHAR2,
3585 P_ATTRIBUTE14 IN VARCHAR2,
3586 P_ATTRIBUTE15 IN VARCHAR2,
3587 P_UNAPPROVED_EXEMPTION_FLAG IN VARCHAR2,
3588 P_DESCRIPTION IN VARCHAR2,
3589 P_VAT_TRANSACTION_TYPE IN VARCHAR2,
3590 P_GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2,
3591 P_GLOBAL_ATTRIBUTE1 IN VARCHAR2,
3592 P_GLOBAL_ATTRIBUTE2 IN VARCHAR2,
3593 P_GLOBAL_ATTRIBUTE3 IN VARCHAR2,
3594 P_GLOBAL_ATTRIBUTE4 IN VARCHAR2,
3595 P_GLOBAL_ATTRIBUTE5 IN VARCHAR2,
3596 P_GLOBAL_ATTRIBUTE6 IN VARCHAR2,
3597 P_GLOBAL_ATTRIBUTE7 IN VARCHAR2,
3598 P_GLOBAL_ATTRIBUTE8 IN VARCHAR2,
3599 P_GLOBAL_ATTRIBUTE9 IN VARCHAR2,
3600 P_GLOBAL_ATTRIBUTE10 IN VARCHAR2,
3601 P_GLOBAL_ATTRIBUTE11 IN VARCHAR2,
3602 P_GLOBAL_ATTRIBUTE12 IN VARCHAR2,
3603 P_GLOBAL_ATTRIBUTE13 IN VARCHAR2,
3604 P_GLOBAL_ATTRIBUTE14 IN VARCHAR2,
3605 P_GLOBAL_ATTRIBUTE15 IN VARCHAR2,
3606 P_GLOBAL_ATTRIBUTE16 IN VARCHAR2,
3607 P_GLOBAL_ATTRIBUTE17 IN VARCHAR2,
3608 P_GLOBAL_ATTRIBUTE18 IN VARCHAR2,
3609 P_GLOBAL_ATTRIBUTE19 IN VARCHAR2,
3610 P_GLOBAL_ATTRIBUTE20 IN VARCHAR2,
3611 P_PRINTED_TAX_NAME IN VARCHAR2,
3612 P_CREATION_DATE IN DATE,
3613 P_CREATED_BY IN NUMBER,
3614 P_LAST_UPDATE_DATE IN DATE,
3615 P_LAST_UPDATED_BY IN NUMBER,
3616 P_LAST_UPDATE_LOGIN IN NUMBER,
3617 P_TAX_REGIME_CODE IN VARCHAR2 DEFAULT NULL, --Bug3872888
3618 P_TAX IN VARCHAR2 DEFAULT NULL, --Bug3872888
3619 P_TAX_STATUS_CODE IN VARCHAR2 DEFAULT NULL --Bug3872888
3620 ) IS
3621 l_tax VARCHAR2(30);
3622 --x_return_status VARCHAR2(30);
3623 BEGIN
3624
3625 arp_util_tax.debug('SYNC_AR_VAT_TAX(+)');
3626 arp_util_tax.debug('p_vat_tax_id :'||to_char(p_vat_tax_id));
3627 arp_util_tax.debug('p_dml_type :'||p_dml_type);
3628 arp_util_tax.debug('p_tax_type :'||p_tax_type);
3629
3630 IF p_dml_type = 'I' THEN
3631 --Tax Code Synch
3632 zx_migrate_tax_def_common.load_results_for_ar(p_vat_tax_id);
3633 zx_migrate_tax_def_common.load_regimes;
3634 --zx_sbscr_options_migrate_pkg.sbscrptn_options_migrate(x_return_status);
3635
3636 IF p_tax_type = 'LOCATION' THEN
3637 zx_migrate_ar_tax_def.migrate_loc_tax_code (p_vat_tax_id, p_tax_type);
3638 ELSIF p_tax_type = 'SALES_TAX' THEN
3639 zx_migrate_ar_tax_def.migrate_vnd_tax_code (p_vat_tax_id, p_tax_type);
3640 ELSE
3641 zx_migrate_ar_tax_def.migrate_ar_tax_code_setup (p_vat_tax_id);
3642 END IF;
3643
3644 --Begin of sync for AR Tax defaulting process.
3645 Zx_Migrate_Tax_Default_Hier.create_condition_groups(p_tax_code);
3646
3647 -- Bug 3751717
3648 -- If Tax Type is group then we are creating the Tax Rule and Process
3649 -- result in SYNC_AR_TAX_GROUP_CODES procedure
3650 IF P_TAX_TYPE <> 'TAX_GROUP' THEN
3651 SELECT DECODE(p_global_attribute_category,
3652 'JE.CZ.ARXSUVAT.TAX_ORIGIN', p_global_attribute1,
3653 'JE.HU.ARXSUVAT.TAX_ORIGIN', p_global_attribute1,
3654 'JE.PL.ARXSUVAT.TAX_ORIGIN', p_global_attribute1,
3655 Zx_Migrate_Util.GET_TAX( p_tax_code, p_tax_type) )
3656 INTO l_tax
3657 FROM DUAL;
3658
3659 Zx_Migrate_Tax_Default_Hier.create_rules(l_tax);
3660 Zx_Migrate_Tax_Default_Hier.create_process_results
3661 (p_tax_id => p_vat_tax_id,
3662 p_sync_module => 'AR');
3663 END IF;
3664
3665 --End of Sync for AR tax defaulting process.
3666 ELSIF p_dml_type = 'U' THEN
3667
3668 arp_util_tax.debug('p_dml_type'||p_dml_type);
3669
3670 -- 6820043: moving description from zx_rates_b to zx_rates_tl
3671 UPDATE ZX_RATES_B_TMP
3672 SET EFFECTIVE_TO = P_END_DATE,
3673 ACTIVE_FLAG = P_ENABLED_FLAG,
3674 ADJ_FOR_ADHOC_AMT_CODE = DECODE(nvl(P_VALIDATE_FLAG, 'N'),'Y', 'TAX_RATE','N', NULL),
3675 ALLOW_ADHOC_TAX_RATE_FLAG = P_VALIDATE_FLAG,
3676 DEF_REC_SETTLEMENT_OPTION_CODE = DECODE(P_INTERIM_TAX_CCID,NULL, 'IMMEDIATE','DEFERRED'),
3677 VAT_TRANSACTION_TYPE_CODE = P_VAT_TRANSACTION_TYPE,
3678 INCLUSIVE_TAX_FLAG = P_AMOUNT_INCLUDES_TAX_FLAG,
3679 TAX_INCLUSIVE_OVERRIDE_FLAG = P_AMOUNT_INCLUDES_TAX_OVERRIDE,
3680 -- DESCRIPTION = P_DESCRIPTION,
3681 ATTRIBUTE1 = P_ATTRIBUTE1,
3682 ATTRIBUTE2 = P_ATTRIBUTE2,
3683 ATTRIBUTE3 = P_ATTRIBUTE3,
3684 ATTRIBUTE4 = P_ATTRIBUTE4,
3685 ATTRIBUTE5 = P_ATTRIBUTE5,
3686 ATTRIBUTE6 = P_ATTRIBUTE6,
3687 ATTRIBUTE7 = P_ATTRIBUTE7,
3688 ATTRIBUTE8 = P_ATTRIBUTE8,
3689 ATTRIBUTE9 = P_ATTRIBUTE9,
3690 ATTRIBUTE10 = P_ATTRIBUTE10,
3691 ATTRIBUTE11 = P_ATTRIBUTE11,
3692 ATTRIBUTE12 = P_ATTRIBUTE12,
3693 ATTRIBUTE13 = P_ATTRIBUTE13,
3694 ATTRIBUTE14 = P_ATTRIBUTE14,
3695 ATTRIBUTE15 = P_ATTRIBUTE15,
3696 ATTRIBUTE_CATEGORY = P_ATTRIBUTE_CATEGORY,
3697 LAST_UPDATED_BY = P_LAST_UPDATED_BY,
3698 LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
3699 LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
3700 WHERE TAX_RATE_ID = P_VAT_TAX_ID;
3701
3702 UPDATE ZX_RATES_TL
3703 SET TAX_RATE_NAME = P_PRINTED_TAX_NAME,
3704 DESCRIPTION = P_DESCRIPTION,
3705 LAST_UPDATED_BY = P_LAST_UPDATED_BY,
3706 LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
3707 LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
3708 WHERE TAX_RATE_ID = P_VAT_TAX_ID;
3709
3710 UPDATE ZX_ACCOUNTS
3711 SET LEDGER_ID = P_SET_OF_BOOKS_ID,
3712 TAX_ACCOUNT_CCID = P_TAX_ACCOUNT_ID,
3713 INTERIM_TAX_CCID = P_INTERIM_TAX_CCID,
3714 NON_REC_ACCOUNT_CCID = DECODE(P_GLOBAL_ATTRIBUTE_CATEGORY,'JL.CL.ARXSUVAT.VAT_TAX',
3715 fnd_flex_ext.get_ccid( 'SQLGL','GL#',
3716 (SELECT chart_of_accounts_id
3717 FROM gl_sets_of_books
3718 WHERE set_of_books_id = P_SET_OF_BOOKS_ID),
3719 sysdate,P_GLOBAL_ATTRIBUTE5),NULL),
3720 ADJ_CCID = P_ADJ_CCID,
3721 EDISC_CCID = P_EDISC_CCID,
3722 UNEDISC_CCID = P_UNEDISC_CCID,
3723 FINCHRG_CCID = P_FINCHRG_CCID,
3724 ADJ_NON_REC_TAX_CCID = P_ADJ_NON_REC_TAX_CCID,
3725 EDISC_NON_REC_TAX_CCID = P_EDISC_NON_REC_TAX_CCID,
3726 UNEDISC_NON_REC_TAX_CCID = P_UNEDISC_NON_REC_TAX_CCID,
3727 FINCHRG_NON_REC_TAX_CCID = P_FINCHRG_NON_REC_TAX_CCID,
3728 LAST_UPDATED_BY = P_LAST_UPDATED_BY,
3729 LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
3730 LAST_UPDATE_LOGIN = P_LAST_UPDATE_LOGIN
3731 WHERE TAX_ACCOUNT_ENTITY_ID = P_VAT_TAX_ID
3732 AND TAX_ACCOUNT_ENTITY_CODE = 'RATES';
3733
3734 END IF;
3735
3736 migrate_sco_code_lte( P_TAX_REGIME_CODE,
3737 P_ORG_ID,
3738 P_CREATION_DATE,
3739 P_CREATED_BY,
3740 P_LAST_UPDATE_DATE,
3741 P_LAST_UPDATED_BY,
3742 P_LAST_UPDATE_LOGIN);
3743
3744 arp_util_tax.debug('SYNC_AR_VAT_TAX(-)');
3745 END SYNC_AR_VAT_TAX;
3746
3747 END ZX_UPGRADE_CONTROL_PKG ;
[Home] [Help]