[Home] [Help]
PACKAGE BODY: APPS.ZX_MIGRATE_TAX_PROFILES
Source
1 PACKAGE BODY zx_migrate_tax_profiles AS
2 /* $Header: zxtaxprofilemigb.pls 120.5 2011/11/21 12:34:50 prigovin 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 --Bug 13371914
315 AND application_id = 222
316 AND NOT EXISTS (SELECT 1
317 FROM fnd_profile_option_values
318 WHERE profile_option_id = (SELECT profile_option_id
319 FROM fnd_profile_options
320 WHERE profile_option_name = 'ZX_ALLOW_TAX_CLASSIF_OVERRIDE')
321 );
322
323 -- 7.
324
325 /* Vendor Profiles : Bug 4631047 */
326
327 INSERT INTO FND_PROFILE_OPTION_VALUES
328 (
329 APPLICATION_ID ,
330 PROFILE_OPTION_ID ,
331 LEVEL_ID ,
332 LEVEL_VALUE ,
333 LAST_UPDATE_DATE ,
334 LAST_UPDATED_BY ,
335 CREATION_DATE ,
336 CREATED_BY ,
337 LAST_UPDATE_LOGIN ,
338 PROFILE_OPTION_VALUE ,
339 LEVEL_VALUE_APPLICATION_ID
340 )
341 SELECT
342 235, -- APPLICATION_ID
343 (select profile_option_id
344 from fnd_profile_options
345 where profile_option_name = 'ZX_TAXVDR_USENEXPRO'), -- PROFILE_OPTION_ID
346 LEVEL_ID,
347 LEVEL_VALUE,
348 sysdate, --LAST_UPDATE_DATE
349 fnd_global.user_id, --LAST_UPDATED_BY
350 sysdate, --CREATION_DATE
351 fnd_global.user_id, --CREATED_BY
355 FROM fnd_profile_option_values valar
352 fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
353 PROFILE_OPTION_VALUE,
354 LEVEL_VALUE_APPLICATION_ID
356 , fnd_profile_options fpoar
357 WHERE valar.profile_option_id = fpoar.profile_option_id
358 AND fpoar.profile_option_name = 'AR_TAXVDR_USENEXPRO'
359 AND NOT EXISTS (SELECT 1
360 FROM fnd_profile_option_values valzx
361 , fnd_profile_options fpozx
362 WHERE valzx.profile_option_id = fpozx.profile_option_id
363 AND fpozx.profile_option_name = 'ZX_TAXVDR_USENEXPRO');
364
365 -- 8.
366
367 INSERT INTO FND_PROFILE_OPTION_VALUES
368 (
369 APPLICATION_ID ,
370 PROFILE_OPTION_ID ,
371 LEVEL_ID ,
372 LEVEL_VALUE ,
373 LAST_UPDATE_DATE ,
374 LAST_UPDATED_BY ,
375 CREATION_DATE ,
376 CREATED_BY ,
377 LAST_UPDATE_LOGIN ,
378 PROFILE_OPTION_VALUE ,
379 LEVEL_VALUE_APPLICATION_ID
380 )
381 SELECT
382 235, -- APPLICATION_ID
383 (select profile_option_id
384 from fnd_profile_options
385 where profile_option_name = 'ZX_TAXVDR_TAXSELPARAM'), -- PROFILE_OPTION_ID
386 LEVEL_ID,
387 LEVEL_VALUE,
388 sysdate, --LAST_UPDATE_DATE
389 fnd_global.user_id, --LAST_UPDATED_BY
390 sysdate, --CREATION_DATE
391 fnd_global.user_id, --CREATED_BY
392 fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
393 PROFILE_OPTION_VALUE,
394 LEVEL_VALUE_APPLICATION_ID
395 FROM fnd_profile_option_values valar
396 , fnd_profile_options fpoar
397 WHERE valar.profile_option_id = fpoar.profile_option_id
398 AND fpoar.profile_option_name = 'AR_TAXVDR_TAXSELPARAM'
399 AND NOT EXISTS (SELECT 1
400 FROM fnd_profile_option_values valzx
401 , fnd_profile_options fpozx
402 WHERE valzx.profile_option_id = fpozx.profile_option_id
403 AND fpozx.profile_option_name = 'ZX_TAXVDR_TAXSELPARAM');
404
405 -- 9.
406
407 /*
408 INSERT INTO FND_PROFILE_OPTION_VALUES
409 (
410 APPLICATION_ID ,
411 PROFILE_OPTION_ID ,
412 LEVEL_ID ,
413 LEVEL_VALUE ,
414 LAST_UPDATE_DATE ,
415 LAST_UPDATED_BY ,
416 CREATION_DATE ,
417 CREATED_BY ,
418 LAST_UPDATE_LOGIN ,
419 PROFILE_OPTION_VALUE ,
420 LEVEL_VALUE_APPLICATION_ID
421 )
422 SELECT
423 235, -- APPLICATION_ID
424 (select profile_option_id
425 from fnd_profile_options
426 where profile_option_name = 'ZX_TAXVDR_TAXTYPE'), -- PROFILE_OPTION_ID
427 LEVEL_ID,
428 LEVEL_VALUE,
429 sysdate, --LAST_UPDATE_DATE
430 fnd_global.user_id, --LAST_UPDATED_BY
431 sysdate, --CREATION_DATE
432 fnd_global.user_id, --CREATED_BY
433 fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
434 PROFILE_OPTION_VALUE,
435 LEVEL_VALUE_APPLICATION_ID
436 FROM fnd_profile_option_values valar
437 , fnd_profile_options fpoar
438 WHERE valar.profile_option_id = fpoar.profile_option_id
439 AND fpoar.profile_option_name = 'AR_TAXVDR_TAXTYPE'
440 AND NOT EXISTS (SELECT 1
441 FROM fnd_profile_option_values valzx
442 , fnd_profile_options fpozx
443 WHERE valzx.profile_option_id = fpozx.profile_option_id
444 AND fpozx.profile_option_name = 'ZX_TAXVDR_TAXTYPE');
445 */
446
447 -- 10.
448
449 INSERT INTO FND_PROFILE_OPTION_VALUES
450 (
451 APPLICATION_ID ,
452 PROFILE_OPTION_ID ,
453 LEVEL_ID ,
454 LEVEL_VALUE ,
455 LAST_UPDATE_DATE ,
456 LAST_UPDATED_BY ,
457 CREATION_DATE ,
458 CREATED_BY ,
459 LAST_UPDATE_LOGIN ,
460 PROFILE_OPTION_VALUE ,
461 LEVEL_VALUE_APPLICATION_ID
462 )
463 SELECT
464 235, -- APPLICATION_ID
465 (select profile_option_id
466 from fnd_profile_options
467 where profile_option_name = 'ZX_TAXVDR_SERVICEIND'), -- PROFILE_OPTION_ID
468 LEVEL_ID,
469 LEVEL_VALUE,
470 sysdate, --LAST_UPDATE_DATE
471 fnd_global.user_id, --LAST_UPDATED_BY
472 sysdate, --CREATION_DATE
473 fnd_global.user_id, --CREATED_BY
474 fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
475 PROFILE_OPTION_VALUE,
476 LEVEL_VALUE_APPLICATION_ID
477 FROM fnd_profile_option_values valar
478 , fnd_profile_options fpoar
479 WHERE valar.profile_option_id = fpoar.profile_option_id
480 AND fpoar.profile_option_name = 'AR_TAXVDR_SERVICEIND'
481 AND NOT EXISTS (SELECT 1
482 FROM fnd_profile_option_values valzx
483 , fnd_profile_options fpozx
484 WHERE valzx.profile_option_id = fpozx.profile_option_id
485 AND fpozx.profile_option_name = 'ZX_TAXVDR_SERVICEIND');
486
487 -- 11.
488
489 INSERT INTO FND_PROFILE_OPTION_VALUES
490 (
491 APPLICATION_ID ,
492 PROFILE_OPTION_ID ,
493 LEVEL_ID ,
494 LEVEL_VALUE ,
498 CREATED_BY ,
495 LAST_UPDATE_DATE ,
496 LAST_UPDATED_BY ,
497 CREATION_DATE ,
499 LAST_UPDATE_LOGIN ,
500 PROFILE_OPTION_VALUE ,
501 LEVEL_VALUE_APPLICATION_ID
502 )
503 SELECT
504 235, -- APPLICATION_ID
505 (select profile_option_id
506 from fnd_profile_options
507 where profile_option_name = 'ZX_TAXVDR_CASESENSITIVE'), -- PROFILE_OPTION_ID
508 LEVEL_ID,
509 LEVEL_VALUE,
510 sysdate, --LAST_UPDATE_DATE
511 fnd_global.user_id, --LAST_UPDATED_BY
512 sysdate, --CREATION_DATE
513 fnd_global.user_id, --CREATED_BY
514 fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
515 PROFILE_OPTION_VALUE,
516 LEVEL_VALUE_APPLICATION_ID
517 FROM fnd_profile_option_values valar
518 , fnd_profile_options fpoar
519 WHERE valar.profile_option_id = fpoar.profile_option_id
520 AND fpoar.profile_option_name = 'AR_TAXVDR_CASESENSITIVE'
521 AND NOT EXISTS (SELECT 1
522 FROM fnd_profile_option_values valzx
523 , fnd_profile_options fpozx
524 WHERE valzx.profile_option_id = fpozx.profile_option_id
525 AND fpozx.profile_option_name = 'ZX_TAXVDR_CASESENSITIVE');
526
527 -- 12.
528
529 END migrate_tax_profile_values;
530
531
532 /*===========================================================================+
533 | PROCEDURE
534 | end_date_tax_profiles
535 |
536 | IN
537 | p_mig_phase : NULL for downtime processing.
538 | PRE-MIG for pre-migration patch processing.
539 |
540 | OUT
541 |
542 | DESCRIPTION
543 | This routine end date AP/AR/OM Tax Profiles.
544 |
545 | SCOPE - PUBLIC
546 |
547 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
548 |
549 | CALLED FROM
550 |
551 | NOTES
552 |
553 | MODIFICATION HISTORY
554 | 04/08/2005 Yoshimichi Konishi Created.
555 |
556 +==========================================================================*/
557 PROCEDURE end_date_tax_profiles (p_mig_phase VARCHAR2)
558 IS
559 BEGIN
560 IF p_mig_phase <> 'PRE-MIG' THEN
561 --
562 -- DISABLE/END DATE FND_PROFILE_OPTIONS
563 --
564 -- Note: 04/08/2005
565 -- End dating profile should not be executed for pre-migration patch.
566 --
567 UPDATE fnd_profile_options
568 SET END_DATE_ACTIVE = sysdate,
569 LAST_UPDATE_DATE = sysdate,
570 LAST_UPDATED_BY = fnd_global.user_id,
571 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
572 WHERE profile_option_name = 'AR_ALLOW_TRX_LINE_EXEMPTIONS'
573 AND end_date_active IS NULL;
574
575 -- 1.
576
577 UPDATE fnd_profile_options
578 SET END_DATE_ACTIVE = sysdate,
579 LAST_UPDATE_DATE = sysdate,
580 LAST_UPDATED_BY = fnd_global.user_id,
581 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
582 WHERE profile_option_name = 'AR_ALLOW_TAX_UPDATE'
583 AND end_date_active IS NULL;
584
585 -- 2.
586
587 UPDATE fnd_profile_options
588 SET END_DATE_ACTIVE = sysdate,
589 LAST_UPDATE_DATE = sysdate,
590 LAST_UPDATED_BY = fnd_global.user_id,
591 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
592 WHERE profile_option_name = 'AR_ALLOW_MANUAL_TAX_LINES'
593 AND end_date_active IS NULL;
594
595 -- 3.
596
597 UPDATE fnd_profile_options
598 SET END_DATE_ACTIVE = sysdate,
599 LAST_UPDATE_DATE = sysdate,
600 LAST_UPDATED_BY = fnd_global.user_id,
601 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
602 WHERE profile_option_name = 'OE_INVENTORY_ITEM_FOR_FREIGHT'
603 AND end_date_active IS NULL;
604
605
606 -- 4.
607
608 UPDATE fnd_profile_options
609 SET END_DATE_ACTIVE = sysdate,
610 LAST_UPDATE_DATE = sysdate,
611 LAST_UPDATED_BY = fnd_global.user_id,
612 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
613 WHERE profile_option_name = 'OE_INVOICE_FREIGHT_AS_LINE'
614 AND end_date_active IS NULL;
615
616 -- 5.
617
618 UPDATE fnd_profile_options
619 SET END_DATE_ACTIVE = sysdate,
620 LAST_UPDATE_DATE = sysdate,
621 LAST_UPDATED_BY = fnd_global.user_id,
622 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
623 WHERE profile_option_name = 'AP_ALLOW_TAX_RECVRY_RATE_OVERRIDE'
624 AND end_date_active IS NULL;
625
626 -- 6.
627
628 UPDATE fnd_profile_options
629 SET END_DATE_ACTIVE = sysdate,
630 LAST_UPDATE_DATE = sysdate,
631 LAST_UPDATED_BY = fnd_global.user_id,
632 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
633 WHERE profile_option_name = 'AR_ALLOW_TAX_CODE_OVERRIDE'
634 AND end_date_active IS NULL;
635
636 -- 7.
637
638 /* Tax Vendor Profiles : Bug 4631047 */
639
640 UPDATE fnd_profile_options
641 SET END_DATE_ACTIVE = sysdate,
642 LAST_UPDATE_DATE = sysdate,
643 LAST_UPDATED_BY = fnd_global.user_id,
644 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
645 WHERE profile_option_name = 'AR_TAXVDR_USENEXPRO'
646 AND end_date_active IS NULL;
647
648 -- 8.
649
650 UPDATE fnd_profile_options
651 SET END_DATE_ACTIVE = sysdate,
652 LAST_UPDATE_DATE = sysdate,
653 LAST_UPDATED_BY = fnd_global.user_id,
654 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
655 WHERE profile_option_name = 'AR_TAXVDR_TAXSELPARAM'
656 AND end_date_active IS NULL;
657
658 -- 9.
659
663 LAST_UPDATED_BY = fnd_global.user_id,
660 UPDATE fnd_profile_options
661 SET END_DATE_ACTIVE = sysdate,
662 LAST_UPDATE_DATE = sysdate,
664 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
665 WHERE profile_option_name = 'AR_TAXVDR_TAXTYPE'
666 AND end_date_active IS NULL;
667
668 -- 10.
669
670 UPDATE fnd_profile_options
671 SET END_DATE_ACTIVE = sysdate,
672 LAST_UPDATE_DATE = sysdate,
673 LAST_UPDATED_BY = fnd_global.user_id,
674 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
675 WHERE profile_option_name = 'AR_TAXVDR_SERVICEIND'
676 AND end_date_active IS NULL;
677
678 -- 11.
679
680 UPDATE fnd_profile_options
681 SET END_DATE_ACTIVE = sysdate,
682 LAST_UPDATE_DATE = sysdate,
683 LAST_UPDATED_BY = fnd_global.user_id,
684 LAST_UPDATE_LOGIN = fnd_global.conc_login_id
685 WHERE profile_option_name = 'AR_TAXVDR_CASESENSITIVE'
686 AND end_date_active IS NULL;
687
688 -- 12.
689
690 END IF;
691 END;
692
693 END zx_migrate_tax_profiles;