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 347: fnd_global.user_id, --LAST_UPDATED_BY

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,

Line 349: fnd_global.user_id, --CREATED_BY

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

Line 350: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN

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

Line 387: fnd_global.user_id, --LAST_UPDATED_BY

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,

Line 389: fnd_global.user_id, --CREATED_BY

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

Line 390: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN

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

Line 428: fnd_global.user_id, --LAST_UPDATED_BY

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,

Line 430: fnd_global.user_id, --CREATED_BY

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

Line 431: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN

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

Line 469: fnd_global.user_id, --LAST_UPDATED_BY

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,

Line 471: fnd_global.user_id, --CREATED_BY

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

Line 472: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN

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
476: , fnd_profile_options fpoar

Line 509: fnd_global.user_id, --LAST_UPDATED_BY

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,

Line 511: fnd_global.user_id, --CREATED_BY

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

Line 512: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN

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

Line 568: LAST_UPDATED_BY = fnd_global.user_id,

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:

Line 569: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

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.

Line 578: LAST_UPDATED_BY = fnd_global.user_id,

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:

Line 579: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

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.

Line 588: LAST_UPDATED_BY = fnd_global.user_id,

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:

Line 589: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

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.

Line 598: LAST_UPDATED_BY = fnd_global.user_id,

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:

Line 599: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

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:

Line 609: LAST_UPDATED_BY = fnd_global.user_id,

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:

Line 610: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

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.

Line 619: LAST_UPDATED_BY = fnd_global.user_id,

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:

Line 620: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

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.

Line 629: LAST_UPDATED_BY = fnd_global.user_id,

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:

Line 630: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

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.

Line 641: LAST_UPDATED_BY = fnd_global.user_id,

637:
638: UPDATE fnd_profile_options
639: SET END_DATE_ACTIVE = sysdate,
640: LAST_UPDATE_DATE = sysdate,
641: LAST_UPDATED_BY = fnd_global.user_id,
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:

Line 642: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

638: UPDATE fnd_profile_options
639: SET END_DATE_ACTIVE = sysdate,
640: LAST_UPDATE_DATE = sysdate,
641: LAST_UPDATED_BY = fnd_global.user_id,
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.

Line 651: LAST_UPDATED_BY = fnd_global.user_id,

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:

Line 652: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

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.

Line 661: LAST_UPDATED_BY = fnd_global.user_id,

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:

Line 662: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

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.

Line 671: LAST_UPDATED_BY = fnd_global.user_id,

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:

Line 672: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

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.

Line 681: LAST_UPDATED_BY = fnd_global.user_id,

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:

Line 682: LAST_UPDATE_LOGIN = fnd_global.conc_login_id

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.