DBA Data[Home] [Help]

APPS.ZX_MIGRATE_TAX_PROFILES dependencies on FND_GLOBAL

Line 55: fnd_global.user_id, --LAST_UPDATED_BY

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,

Line 57: fnd_global.user_id, --CREATED_BY

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

Line 58: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN

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

Line 96: fnd_global.user_id, --LAST_UPDATED_BY

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,

Line 98: fnd_global.user_id, --CREATED_BY

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

Line 99: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN

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

Line 138: fnd_global.user_id, --LAST_UPDATED_BY

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,

Line 140: fnd_global.user_id, --CREATED_BY

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

Line 141: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN

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

Line 179: fnd_global.user_id, --LAST_UPDATED_BY

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,

Line 181: fnd_global.user_id, --CREATED_BY

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

Line 182: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN

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

Line 221: fnd_global.user_id, --LAST_UPDATED_BY

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,

Line 223: fnd_global.user_id, --CREATED_BY

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

Line 224: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN

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

Line 263: fnd_global.user_id, --LAST_UPDATED_BY

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,

Line 265: fnd_global.user_id, --CREATED_BY

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

Line 266: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN

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

Line 304: fnd_global.user_id, --LAST_UPDATED_BY

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,

Line 306: fnd_global.user_id, --CREATED_BY

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

Line 307: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN

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

Line 349: fnd_global.user_id, --LAST_UPDATED_BY

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
352: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
353: PROFILE_OPTION_VALUE,

Line 351: fnd_global.user_id, --CREATED_BY

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
352: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
353: PROFILE_OPTION_VALUE,
354: LEVEL_VALUE_APPLICATION_ID
355: FROM fnd_profile_option_values valar

Line 352: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN

348: sysdate, --LAST_UPDATE_DATE
349: fnd_global.user_id, --LAST_UPDATED_BY
350: sysdate, --CREATION_DATE
351: fnd_global.user_id, --CREATED_BY
352: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
353: PROFILE_OPTION_VALUE,
354: LEVEL_VALUE_APPLICATION_ID
355: FROM fnd_profile_option_values valar
356: , fnd_profile_options fpoar

Line 389: fnd_global.user_id, --LAST_UPDATED_BY

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,

Line 391: fnd_global.user_id, --CREATED_BY

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

Line 392: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN

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

Line 430: fnd_global.user_id, --LAST_UPDATED_BY

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,

Line 432: fnd_global.user_id, --CREATED_BY

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

Line 433: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN

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

Line 471: fnd_global.user_id, --LAST_UPDATED_BY

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,

Line 473: fnd_global.user_id, --CREATED_BY

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

Line 474: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN

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

Line 511: fnd_global.user_id, --LAST_UPDATED_BY

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,

Line 513: fnd_global.user_id, --CREATED_BY

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

Line 514: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN

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

Line 570: LAST_UPDATED_BY = fnd_global.user_id,

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:

Line 571: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

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.

Line 580: LAST_UPDATED_BY = fnd_global.user_id,

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:

Line 581: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

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.

Line 590: LAST_UPDATED_BY = fnd_global.user_id,

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:

Line 591: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

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.

Line 600: LAST_UPDATED_BY = fnd_global.user_id,

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:

Line 601: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

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:

Line 611: LAST_UPDATED_BY = fnd_global.user_id,

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:

Line 612: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

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.

Line 621: LAST_UPDATED_BY = fnd_global.user_id,

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:

Line 622: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

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.

Line 631: LAST_UPDATED_BY = fnd_global.user_id,

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:

Line 632: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

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.

Line 643: LAST_UPDATED_BY = fnd_global.user_id,

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:

Line 644: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

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.

Line 653: LAST_UPDATED_BY = fnd_global.user_id,

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:

Line 654: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

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.

Line 663: LAST_UPDATED_BY = fnd_global.user_id,

659:
660: UPDATE fnd_profile_options
661: SET END_DATE_ACTIVE = sysdate,
662: LAST_UPDATE_DATE = sysdate,
663: LAST_UPDATED_BY = fnd_global.user_id,
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:

Line 664: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

660: UPDATE fnd_profile_options
661: SET END_DATE_ACTIVE = sysdate,
662: LAST_UPDATE_DATE = sysdate,
663: LAST_UPDATED_BY = fnd_global.user_id,
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.

Line 673: LAST_UPDATED_BY = fnd_global.user_id,

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:

Line 674: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

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.

Line 683: LAST_UPDATED_BY = fnd_global.user_id,

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:

Line 684: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

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.