[Home] [Help]
PACKAGE BODY: APPS.ZX_MIGRATE_TAX_PROFILES
Source
1 PACKAGE BODY zx_migrate_tax_profiles AS
2 /* $Header: zxtaxprofilemigb.pls 120.4 2006/10/05 23:38:44 svaze ship $ */
3
4 /*===========================================================================+
5 | PROCEDURE
6 | migrate_tax_profile_values
7 |
8 | IN
9 |
10 | OUT
11 |
12 | DESCRIPTION
13 | This routine migrates AP/AR/OM Tax Profile values to ZX.
14 |
15 | SCOPE - PUBLIC
16 |
17 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
18 |
19 | CALLED FROM
20 |
21 | NOTES
22 |
23 | MODIFICATION HISTORY
24 | 04/08/2005 Yoshimichi Konishi Created.
25 |
26 +==========================================================================*/
27 PROCEDURE migrate_tax_profile_values
28 IS
29 BEGIN
30 --
31 -- INSERT FND_PROFILE_OPTION_VALUES
32 --
33 INSERT INTO FND_PROFILE_OPTION_VALUES
34 (
35 APPLICATION_ID ,
36 PROFILE_OPTION_ID ,
37 LEVEL_ID ,
38 LEVEL_VALUE ,
39 LAST_UPDATE_DATE ,
40 LAST_UPDATED_BY ,
41 CREATION_DATE ,
42 CREATED_BY ,
43 LAST_UPDATE_LOGIN ,
44 PROFILE_OPTION_VALUE ,
45 LEVEL_VALUE_APPLICATION_ID
46 )
47 SELECT
48 235, -- APPLICATION_ID
49 (select profile_option_id
50 from fnd_profile_options
51 where profile_option_name = 'ZX_ALLOW_TRX_LINE_EXEMPTIONS'), -- PROFILE_OPTION_ID
52 LEVEL_ID,
53 LEVEL_VALUE,
54 sysdate, --LAST_UPDATE_DATE
55 fnd_global.user_id, --LAST_UPDATED_BY
56 sysdate, --CREATION_DATE
57 fnd_global.user_id, --CREATED_BY
58 fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
59 PROFILE_OPTION_VALUE,
60 LEVEL_VALUE_APPLICATION_ID
61 FROM fnd_profile_option_values
62 WHERE profile_option_id = (select profile_option_id
63 from fnd_profile_options
64 where profile_option_name = 'AR_ALLOW_TRX_LINE_EXEMPTIONS')
65 AND NOT EXISTS (SELECT 1
66 FROM fnd_profile_option_values
67 WHERE profile_option_id = (SELECT profile_option_id
68 FROM fnd_profile_options
69 WHERE profile_option_name = 'ZX_ALLOW_TRX_LINE_EXEMPTIONS')
70 );
71
72 -- 1.
73
74 INSERT INTO FND_PROFILE_OPTION_VALUES
75 (
76 APPLICATION_ID ,
77 PROFILE_OPTION_ID ,
78 LEVEL_ID ,
79 LEVEL_VALUE ,
80 LAST_UPDATE_DATE ,
81 LAST_UPDATED_BY ,
82 CREATION_DATE ,
83 CREATED_BY ,
84 LAST_UPDATE_LOGIN ,
85 PROFILE_OPTION_VALUE ,
86 LEVEL_VALUE_APPLICATION_ID
87 )
88 SELECT
89 235, -- APPLICATION_ID
90 (select profile_option_id
91 from fnd_profile_options
92 where profile_option_name = 'ZX_ALLOW_TAX_UPDATE'), -- PROFILE_OPTION_ID
93 LEVEL_ID,
94 LEVEL_VALUE,
95 sysdate, --LAST_UPDATE_DATE
96 fnd_global.user_id, --LAST_UPDATED_BY
97 sysdate, --CREATION_DATE
98 fnd_global.user_id, --CREATED_BY
99 fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
100 PROFILE_OPTION_VALUE,
101 LEVEL_VALUE_APPLICATION_ID
102 FROM fnd_profile_option_values
103 WHERE profile_option_id = (select profile_option_id
104 from fnd_profile_options
105 where profile_option_name = 'AR_ALLOW_TAX_UPDATE')
106 AND APPLICATION_ID = 222
107 AND NOT EXISTS (SELECT 1
108 FROM fnd_profile_option_values
109 WHERE profile_option_id = (SELECT profile_option_id
110 FROM fnd_profile_options
111 WHERE profile_option_name = 'ZX_ALLOW_TAX_UPDATE')
112 );
113
114 -- 2.
115
116 INSERT INTO FND_PROFILE_OPTION_VALUES
117 (
118 APPLICATION_ID ,
119 PROFILE_OPTION_ID ,
120 LEVEL_ID ,
121 LEVEL_VALUE ,
122 LAST_UPDATE_DATE ,
123 LAST_UPDATED_BY ,
124 CREATION_DATE ,
125 CREATED_BY ,
126 LAST_UPDATE_LOGIN ,
127 PROFILE_OPTION_VALUE ,
128 LEVEL_VALUE_APPLICATION_ID
129 )
130 SELECT
131 235, -- APPLICATION_ID
132 (select profile_option_id
133 from fnd_profile_options
134 where profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES'), -- PROFILE_OPTION_ID
135 LEVEL_ID,
136 LEVEL_VALUE,
137 sysdate, --LAST_UPDATE_DATE
138 fnd_global.user_id, --LAST_UPDATED_BY
139 sysdate, --CREATION_DATE
140 fnd_global.user_id, --CREATED_BY
141 fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
142 PROFILE_OPTION_VALUE,
143 LEVEL_VALUE_APPLICATION_ID
144 FROM fnd_profile_option_values
145 WHERE profile_option_id = (select profile_option_id
146 from fnd_profile_options
147 where profile_option_name = 'AR_ALLOW_MANUAL_TAX_LINES')
148 AND NOT EXISTS (SELECT 1
149 FROM fnd_profile_option_values
150 WHERE profile_option_id = (SELECT profile_option_id
151 FROM fnd_profile_options
152 WHERE profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES')
153 );
154
155 -- 3.
156 /*Bug 5529992
157 INSERT INTO FND_PROFILE_OPTION_VALUES
158 (
159 APPLICATION_ID ,
160 PROFILE_OPTION_ID ,
161 LEVEL_ID ,
162 LEVEL_VALUE ,
163 LAST_UPDATE_DATE ,
164 LAST_UPDATED_BY ,
165 CREATION_DATE ,
166 CREATED_BY ,
167 LAST_UPDATE_LOGIN ,
168 PROFILE_OPTION_VALUE ,
169 LEVEL_VALUE_APPLICATION_ID
170 )
171 SELECT
172 235, -- APPLICATION_ID
173 (select profile_option_id
174 from fnd_profile_options
175 where profile_option_name = 'ZX_INVENTORY_ITEM_FOR_FREIGHT'), -- PROFILE_OPTION_ID
176 LEVEL_ID,
177 LEVEL_VALUE,
178 sysdate, --LAST_UPDATE_DATE
179 fnd_global.user_id, --LAST_UPDATED_BY
180 sysdate, --CREATION_DATE
181 fnd_global.user_id, --CREATED_BY
182 fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
183 PROFILE_OPTION_VALUE,
184 LEVEL_VALUE_APPLICATION_ID
185 FROM fnd_profile_option_values
186 WHERE profile_option_id = (select profile_option_id
187 from fnd_profile_options
188 where profile_option_name = 'OE_INVENTORY_ITEM_FOR_FREIGHT')
189 AND NOT EXISTS (SELECT 1
190 FROM fnd_profile_option_values
191 WHERE profile_option_id = (SELECT profile_option_id
192 FROM fnd_profile_options
193 WHERE profile_option_name = 'ZX_INVENTORY_ITEM_FOR_FREIGHT')
194 );
195
196
197 -- 4.
198
199 INSERT INTO FND_PROFILE_OPTION_VALUES
200 (
201 APPLICATION_ID ,
202 PROFILE_OPTION_ID ,
203 LEVEL_ID ,
204 LEVEL_VALUE ,
205 LAST_UPDATE_DATE ,
206 LAST_UPDATED_BY ,
207 CREATION_DATE ,
208 CREATED_BY ,
209 LAST_UPDATE_LOGIN ,
210 PROFILE_OPTION_VALUE ,
211 LEVEL_VALUE_APPLICATION_ID
212 )
213 SELECT
214 235, -- APPLICATION_ID
215 (select profile_option_id
216 from fnd_profile_options
217 where profile_option_name = 'ZX_INVOICE_FREIGHT_AS_LINE'), -- PROFILE_OPTION_ID
218 LEVEL_ID,
219 LEVEL_VALUE,
220 sysdate, --LAST_UPDATE_DATE
221 fnd_global.user_id, --LAST_UPDATED_BY
222 sysdate, --CREATION_DATE
223 fnd_global.user_id, --CREATED_BY
224 fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
225 PROFILE_OPTION_VALUE,
226 LEVEL_VALUE_APPLICATION_ID
227 FROM fnd_profile_option_values
228 WHERE profile_option_id = (select profile_option_id
229 from fnd_profile_options
230 where profile_option_name = 'OE_INVOICE_FREIGHT_AS_LINE')
231 AND NOT EXISTS (SELECT 1
232 FROM fnd_profile_option_values
233 WHERE profile_option_id = (SELECT profile_option_id
234 FROM fnd_profile_options
235 WHERE profile_option_name = 'ZX_INVOICE_FREIGHT_AS_LINE')
236 );
237 */
238
239 -- 5.
240
241 INSERT INTO FND_PROFILE_OPTION_VALUES
242 (
243 APPLICATION_ID ,
244 PROFILE_OPTION_ID ,
245 LEVEL_ID ,
246 LEVEL_VALUE ,
247 LAST_UPDATE_DATE ,
248 LAST_UPDATED_BY ,
249 CREATION_DATE ,
250 CREATED_BY ,
251 LAST_UPDATE_LOGIN ,
252 PROFILE_OPTION_VALUE ,
253 LEVEL_VALUE_APPLICATION_ID
254 )
255 SELECT
256 235, -- APPLICATION_ID
257 (select profile_option_id
258 from fnd_profile_options
259 where profile_option_name = 'ZX_ALLOW_TAX_RECVRY_RATE_OVERRIDE'), -- PROFILE_OPTION_ID
260 LEVEL_ID,
261 LEVEL_VALUE,
262 sysdate, --LAST_UPDATE_DATE
263 fnd_global.user_id, --LAST_UPDATED_BY
264 sysdate, --CREATION_DATE
265 fnd_global.user_id, --CREATED_BY
266 fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
267 PROFILE_OPTION_VALUE,
268 LEVEL_VALUE_APPLICATION_ID
269 FROM fnd_profile_option_values
270 WHERE profile_option_id = (select profile_option_id
271 from fnd_profile_options
272 where profile_option_name = 'AP_ALLOW_TAX_RECVRY_RATE_OVERRIDE')
273 AND NOT EXISTS (SELECT 1
274 FROM fnd_profile_option_values
275 WHERE profile_option_id = (SELECT profile_option_id
276 FROM fnd_profile_options
277 WHERE profile_option_name = 'ZX_ALLOW_TAX_RECVRY_RATE_OVERRIDE')
278 );
279
280 -- 6.
281
282 INSERT INTO FND_PROFILE_OPTION_VALUES
283 (
284 APPLICATION_ID ,
285 PROFILE_OPTION_ID ,
286 LEVEL_ID ,
287 LEVEL_VALUE ,
288 LAST_UPDATE_DATE ,
289 LAST_UPDATED_BY ,
290 CREATION_DATE ,
291 CREATED_BY ,
292 LAST_UPDATE_LOGIN ,
293 PROFILE_OPTION_VALUE ,
294 LEVEL_VALUE_APPLICATION_ID
295 )
296 SELECT
297 235, -- APPLICATION_ID
298 (select profile_option_id
299 from fnd_profile_options
300 where profile_option_name = 'ZX_ALLOW_TAX_CLASSIF_OVERRIDE'), -- PROFILE_OPTION_ID
301 LEVEL_ID,
302 LEVEL_VALUE,
303 sysdate, --LAST_UPDATE_DATE
304 fnd_global.user_id, --LAST_UPDATED_BY
305 sysdate, --CREATION_DATE
306 fnd_global.user_id, --CREATED_BY
307 fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
308 PROFILE_OPTION_VALUE,
309 LEVEL_VALUE_APPLICATION_ID
310 FROM fnd_profile_option_values
311 WHERE profile_option_id = (select profile_option_id
312 from fnd_profile_options
313 where profile_option_name = 'AR_ALLOW_TAX_CODE_OVERRIDE')
314 AND NOT EXISTS (SELECT 1
315 FROM fnd_profile_option_values
316 WHERE profile_option_id = (SELECT profile_option_id
317 FROM fnd_profile_options
318 WHERE profile_option_name = 'ZX_ALLOW_TAX_CLASSIF_OVERRIDE')
319 );
320
321 -- 7.
322
323 /* Vendor Profiles : Bug 4631047 */
324
325 INSERT INTO FND_PROFILE_OPTION_VALUES
326 (
327 APPLICATION_ID ,
328 PROFILE_OPTION_ID ,
329 LEVEL_ID ,
330 LEVEL_VALUE ,
331 LAST_UPDATE_DATE ,
335 LAST_UPDATE_LOGIN ,
332 LAST_UPDATED_BY ,
333 CREATION_DATE ,
334 CREATED_BY ,
336 PROFILE_OPTION_VALUE ,
337 LEVEL_VALUE_APPLICATION_ID
338 )
339 SELECT
340 235, -- APPLICATION_ID
341 (select profile_option_id
342 from fnd_profile_options
343 where profile_option_name = 'ZX_TAXVDR_USENEXPRO'), -- PROFILE_OPTION_ID
344 LEVEL_ID,
345 LEVEL_VALUE,
346 sysdate, --LAST_UPDATE_DATE
347 fnd_global.user_id, --LAST_UPDATED_BY
348 sysdate, --CREATION_DATE
349 fnd_global.user_id, --CREATED_BY
350 fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
351 PROFILE_OPTION_VALUE,
352 LEVEL_VALUE_APPLICATION_ID
353 FROM fnd_profile_option_values valar
354 , fnd_profile_options fpoar
355 WHERE valar.profile_option_id = fpoar.profile_option_id
356 AND fpoar.profile_option_name = 'AR_TAXVDR_USENEXPRO'
357 AND NOT EXISTS (SELECT 1
358 FROM fnd_profile_option_values valzx
359 , fnd_profile_options fpozx
360 WHERE valzx.profile_option_id = fpozx.profile_option_id
361 AND fpozx.profile_option_name = 'ZX_TAXVDR_USENEXPRO');
362
363 -- 8.
364
365 INSERT INTO FND_PROFILE_OPTION_VALUES
366 (
367 APPLICATION_ID ,
368 PROFILE_OPTION_ID ,
369 LEVEL_ID ,
370 LEVEL_VALUE ,
371 LAST_UPDATE_DATE ,
372 LAST_UPDATED_BY ,
373 CREATION_DATE ,
374 CREATED_BY ,
375 LAST_UPDATE_LOGIN ,
376 PROFILE_OPTION_VALUE ,
377 LEVEL_VALUE_APPLICATION_ID
378 )
379 SELECT
380 235, -- APPLICATION_ID
381 (select profile_option_id
382 from fnd_profile_options
383 where profile_option_name = 'ZX_TAXVDR_TAXSELPARAM'), -- PROFILE_OPTION_ID
384 LEVEL_ID,
385 LEVEL_VALUE,
386 sysdate, --LAST_UPDATE_DATE
387 fnd_global.user_id, --LAST_UPDATED_BY
388 sysdate, --CREATION_DATE
389 fnd_global.user_id, --CREATED_BY
390 fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
391 PROFILE_OPTION_VALUE,
392 LEVEL_VALUE_APPLICATION_ID
393 FROM fnd_profile_option_values valar
394 , fnd_profile_options fpoar
395 WHERE valar.profile_option_id = fpoar.profile_option_id
396 AND fpoar.profile_option_name = 'AR_TAXVDR_TAXSELPARAM'
397 AND NOT EXISTS (SELECT 1
398 FROM fnd_profile_option_values valzx
399 , fnd_profile_options fpozx
400 WHERE valzx.profile_option_id = fpozx.profile_option_id
401 AND fpozx.profile_option_name = 'ZX_TAXVDR_TAXSELPARAM');
402
403 -- 9.
404
405 /*
406 INSERT INTO FND_PROFILE_OPTION_VALUES
407 (
408 APPLICATION_ID ,
409 PROFILE_OPTION_ID ,
410 LEVEL_ID ,
411 LEVEL_VALUE ,
412 LAST_UPDATE_DATE ,
413 LAST_UPDATED_BY ,
414 CREATION_DATE ,
415 CREATED_BY ,
416 LAST_UPDATE_LOGIN ,
417 PROFILE_OPTION_VALUE ,
418 LEVEL_VALUE_APPLICATION_ID
419 )
420 SELECT
421 235, -- APPLICATION_ID
422 (select profile_option_id
423 from fnd_profile_options
424 where profile_option_name = 'ZX_TAXVDR_TAXTYPE'), -- PROFILE_OPTION_ID
425 LEVEL_ID,
426 LEVEL_VALUE,
427 sysdate, --LAST_UPDATE_DATE
428 fnd_global.user_id, --LAST_UPDATED_BY
429 sysdate, --CREATION_DATE
430 fnd_global.user_id, --CREATED_BY
431 fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
432 PROFILE_OPTION_VALUE,
433 LEVEL_VALUE_APPLICATION_ID
434 FROM fnd_profile_option_values valar
435 , fnd_profile_options fpoar
436 WHERE valar.profile_option_id = fpoar.profile_option_id
437 AND fpoar.profile_option_name = 'AR_TAXVDR_TAXTYPE'
438 AND NOT EXISTS (SELECT 1
439 FROM fnd_profile_option_values valzx
440 , fnd_profile_options fpozx
441 WHERE valzx.profile_option_id = fpozx.profile_option_id
442 AND fpozx.profile_option_name = 'ZX_TAXVDR_TAXTYPE');
443 */
444
445 -- 10.
446
447 INSERT INTO FND_PROFILE_OPTION_VALUES
448 (
449 APPLICATION_ID ,
450 PROFILE_OPTION_ID ,
451 LEVEL_ID ,
452 LEVEL_VALUE ,
453 LAST_UPDATE_DATE ,
454 LAST_UPDATED_BY ,
455 CREATION_DATE ,
456 CREATED_BY ,
457 LAST_UPDATE_LOGIN ,
458 PROFILE_OPTION_VALUE ,
459 LEVEL_VALUE_APPLICATION_ID
460 )
461 SELECT
462 235, -- APPLICATION_ID
463 (select profile_option_id
464 from fnd_profile_options
465 where profile_option_name = 'ZX_TAXVDR_SERVICEIND'), -- PROFILE_OPTION_ID
466 LEVEL_ID,
467 LEVEL_VALUE,
468 sysdate, --LAST_UPDATE_DATE
469 fnd_global.user_id, --LAST_UPDATED_BY
470 sysdate, --CREATION_DATE
471 fnd_global.user_id, --CREATED_BY
472 fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
473 PROFILE_OPTION_VALUE,
474 LEVEL_VALUE_APPLICATION_ID
475 FROM fnd_profile_option_values valar
479 AND NOT EXISTS (SELECT 1
476 , fnd_profile_options fpoar
477 WHERE valar.profile_option_id = fpoar.profile_option_id
478 AND fpoar.profile_option_name = 'AR_TAXVDR_SERVICEIND'
480 FROM fnd_profile_option_values valzx
481 , fnd_profile_options fpozx
482 WHERE valzx.profile_option_id = fpozx.profile_option_id
483 AND fpozx.profile_option_name = 'ZX_TAXVDR_SERVICEIND');
484
485 -- 11.
486
487 INSERT INTO FND_PROFILE_OPTION_VALUES
488 (
489 APPLICATION_ID ,
490 PROFILE_OPTION_ID ,
491 LEVEL_ID ,
492 LEVEL_VALUE ,
493 LAST_UPDATE_DATE ,
494 LAST_UPDATED_BY ,
495 CREATION_DATE ,
496 CREATED_BY ,
497 LAST_UPDATE_LOGIN ,
498 PROFILE_OPTION_VALUE ,
499 LEVEL_VALUE_APPLICATION_ID
500 )
501 SELECT
502 235, -- APPLICATION_ID
503 (select profile_option_id
504 from fnd_profile_options
505 where profile_option_name = 'ZX_TAXVDR_CASESENSITIVE'), -- PROFILE_OPTION_ID
506 LEVEL_ID,
507 LEVEL_VALUE,
508 sysdate, --LAST_UPDATE_DATE
509 fnd_global.user_id, --LAST_UPDATED_BY
510 sysdate, --CREATION_DATE
511 fnd_global.user_id, --CREATED_BY
512 fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
513 PROFILE_OPTION_VALUE,
514 LEVEL_VALUE_APPLICATION_ID
515 FROM fnd_profile_option_values valar
516 , fnd_profile_options fpoar
517 WHERE valar.profile_option_id = fpoar.profile_option_id
518 AND fpoar.profile_option_name = 'AR_TAXVDR_CASESENSITIVE'
519 AND NOT EXISTS (SELECT 1
520 FROM fnd_profile_option_values valzx
521 , fnd_profile_options fpozx
522 WHERE valzx.profile_option_id = fpozx.profile_option_id
523 AND fpozx.profile_option_name = 'ZX_TAXVDR_CASESENSITIVE');
524
525 -- 12.
526
527 END migrate_tax_profile_values;
528
529
530 /*===========================================================================+
531 | PROCEDURE
532 | end_date_tax_profiles
533 |
534 | IN
535 | p_mig_phase : NULL for downtime processing.
536 | PRE-MIG for pre-migration patch processing.
537 |
538 | OUT
539 |
540 | DESCRIPTION
541 | This routine end date AP/AR/OM Tax Profiles.
542 |
543 | SCOPE - PUBLIC
544 |
545 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
546 |
547 | CALLED FROM
548 |
549 | NOTES
550 |
551 | MODIFICATION HISTORY
552 | 04/08/2005 Yoshimichi Konishi Created.
553 |
554 +==========================================================================*/
555 PROCEDURE end_date_tax_profiles (p_mig_phase VARCHAR2)
556 IS
557 BEGIN
558 IF p_mig_phase <> 'PRE-MIG' THEN
559 --
560 -- DISABLE/END DATE FND_PROFILE_OPTIONS
561 --
562 -- Note: 04/08/2005
563 -- End dating profile should not be executed for pre-migration patch.
564 --
565 UPDATE fnd_profile_options
566 SET END_DATE_ACTIVE = sysdate,
567 LAST_UPDATE_DATE = sysdate,
568 LAST_UPDATED_BY = fnd_global.user_id,
569 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
570 WHERE profile_option_name = 'AR_ALLOW_TRX_LINE_EXEMPTIONS'
571 AND end_date_active IS NULL;
572
573 -- 1.
574
575 UPDATE fnd_profile_options
576 SET END_DATE_ACTIVE = sysdate,
577 LAST_UPDATE_DATE = sysdate,
578 LAST_UPDATED_BY = fnd_global.user_id,
579 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
580 WHERE profile_option_name = 'AR_ALLOW_TAX_UPDATE'
581 AND end_date_active IS NULL;
582
583 -- 2.
584
585 UPDATE fnd_profile_options
586 SET END_DATE_ACTIVE = sysdate,
587 LAST_UPDATE_DATE = sysdate,
588 LAST_UPDATED_BY = fnd_global.user_id,
589 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
590 WHERE profile_option_name = 'AR_ALLOW_MANUAL_TAX_LINES'
591 AND end_date_active IS NULL;
592
593 -- 3.
594
595 UPDATE fnd_profile_options
596 SET END_DATE_ACTIVE = sysdate,
597 LAST_UPDATE_DATE = sysdate,
598 LAST_UPDATED_BY = fnd_global.user_id,
599 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
600 WHERE profile_option_name = 'OE_INVENTORY_ITEM_FOR_FREIGHT'
601 AND end_date_active IS NULL;
602
603
604 -- 4.
605
606 UPDATE fnd_profile_options
607 SET END_DATE_ACTIVE = sysdate,
608 LAST_UPDATE_DATE = sysdate,
609 LAST_UPDATED_BY = fnd_global.user_id,
610 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
611 WHERE profile_option_name = 'OE_INVOICE_FREIGHT_AS_LINE'
612 AND end_date_active IS NULL;
613
614 -- 5.
615
616 UPDATE fnd_profile_options
617 SET END_DATE_ACTIVE = sysdate,
618 LAST_UPDATE_DATE = sysdate,
619 LAST_UPDATED_BY = fnd_global.user_id,
620 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
621 WHERE profile_option_name = 'AP_ALLOW_TAX_RECVRY_RATE_OVERRIDE'
622 AND end_date_active IS NULL;
623
624 -- 6.
625
626 UPDATE fnd_profile_options
627 SET END_DATE_ACTIVE = sysdate,
628 LAST_UPDATE_DATE = sysdate,
629 LAST_UPDATED_BY = fnd_global.user_id,
630 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
631 WHERE profile_option_name = 'AR_ALLOW_TAX_CODE_OVERRIDE'
632 AND end_date_active IS NULL;
633
634 -- 7.
635
636 /* Tax Vendor Profiles : Bug 4631047 */
637
641 LAST_UPDATED_BY = fnd_global.user_id,
638 UPDATE fnd_profile_options
639 SET END_DATE_ACTIVE = sysdate,
640 LAST_UPDATE_DATE = sysdate,
642 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
643 WHERE profile_option_name = 'AR_TAXVDR_USENEXPRO'
644 AND end_date_active IS NULL;
645
646 -- 8.
647
648 UPDATE fnd_profile_options
649 SET END_DATE_ACTIVE = sysdate,
650 LAST_UPDATE_DATE = sysdate,
651 LAST_UPDATED_BY = fnd_global.user_id,
652 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
653 WHERE profile_option_name = 'AR_TAXVDR_TAXSELPARAM'
654 AND end_date_active IS NULL;
655
656 -- 9.
657
658 UPDATE fnd_profile_options
659 SET END_DATE_ACTIVE = sysdate,
660 LAST_UPDATE_DATE = sysdate,
661 LAST_UPDATED_BY = fnd_global.user_id,
662 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
663 WHERE profile_option_name = 'AR_TAXVDR_TAXTYPE'
664 AND end_date_active IS NULL;
665
666 -- 10.
667
668 UPDATE fnd_profile_options
669 SET END_DATE_ACTIVE = sysdate,
670 LAST_UPDATE_DATE = sysdate,
671 LAST_UPDATED_BY = fnd_global.user_id,
672 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
673 WHERE profile_option_name = 'AR_TAXVDR_SERVICEIND'
674 AND end_date_active IS NULL;
675
676 -- 11.
677
678 UPDATE fnd_profile_options
679 SET END_DATE_ACTIVE = sysdate,
680 LAST_UPDATE_DATE = sysdate,
681 LAST_UPDATED_BY = fnd_global.user_id,
682 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
683 WHERE profile_option_name = 'AR_TAXVDR_CASESENSITIVE'
684 AND end_date_active IS NULL;
685
686 -- 12.
687
688 END IF;
689 END;
690
691 END zx_migrate_tax_profiles;