eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_EXEC_MIG_CMDS dependencies on FND_TS_MIG_CMDS

Line 16: UPDATE fnd_ts_mig_cmds

12: x_status := 'SUCCESS';
13: x_err_code := 0;
14:
15: BEGIN
16: UPDATE fnd_ts_mig_cmds
17: SET start_date = sysdate,
18: last_update_date = sysdate,
19: end_date = null
20: WHERE lineno = p_lineno;

Line 24: UPDATE fnd_ts_mig_cmds

20: WHERE lineno = p_lineno;
21:
22: EXECUTE IMMEDIATE p_mig_cmd;
23:
24: UPDATE fnd_ts_mig_cmds
25: SET migration_status = 'SUCCESS',
26: end_date = sysdate,
27: last_update_date = sysdate,
28: error_text = NULL

Line 37: UPDATE fnd_ts_mig_cmds

33: l_err_code := sqlcode;
34: x_err_code := sqlcode;
35: l_err := sqlerrm(sqlcode);
36: x_status := 'ERROR';
37: UPDATE fnd_ts_mig_cmds
38: SET migration_status = 'ERROR',
39: end_date = sysdate,
40: error_text = l_err,
41: last_update_date = sysdate

Line 73: FROM fnd_ts_mig_cmds

69: partitioned,
70: parent_owner,
71: parent_object_name,
72: execution_mode
73: FROM fnd_ts_mig_cmds
74: WHERE parent_lineno = l_lineno;
75: BEGIN
76: l_enqopt.visibility := DBMS_AQ.IMMEDIATE;
77:

Line 122: l_parent_owner FND_TS_MIG_CMDS.PARENT_OWNER%TYPE;

118: l_deqopt DBMS_AQ.dequeue_options_t;
119: l_enq_msgid RAW(16);
120: l_deq_msgid RAW(16);
121:
122: l_parent_owner FND_TS_MIG_CMDS.PARENT_OWNER%TYPE;
123: l_parent_object_name FND_TS_MIG_CMDS.PARENT_OBJECT_NAME%TYPE;
124: l_owner FND_TS_MIG_CMDS.OWNER%TYPE;
125: l_object_name FND_TS_MIG_CMDS.OBJECT_NAME%TYPE;
126: l_mig_status FND_TS_MIG_CMDS.MIGRATION_STATUS%TYPE := 'SUCCESS';

Line 123: l_parent_object_name FND_TS_MIG_CMDS.PARENT_OBJECT_NAME%TYPE;

119: l_enq_msgid RAW(16);
120: l_deq_msgid RAW(16);
121:
122: l_parent_owner FND_TS_MIG_CMDS.PARENT_OWNER%TYPE;
123: l_parent_object_name FND_TS_MIG_CMDS.PARENT_OBJECT_NAME%TYPE;
124: l_owner FND_TS_MIG_CMDS.OWNER%TYPE;
125: l_object_name FND_TS_MIG_CMDS.OBJECT_NAME%TYPE;
126: l_mig_status FND_TS_MIG_CMDS.MIGRATION_STATUS%TYPE := 'SUCCESS';
127: l_partitioned FND_TS_MIG_CMDS.PARTITIONED%TYPE;

Line 124: l_owner FND_TS_MIG_CMDS.OWNER%TYPE;

120: l_deq_msgid RAW(16);
121:
122: l_parent_owner FND_TS_MIG_CMDS.PARENT_OWNER%TYPE;
123: l_parent_object_name FND_TS_MIG_CMDS.PARENT_OBJECT_NAME%TYPE;
124: l_owner FND_TS_MIG_CMDS.OWNER%TYPE;
125: l_object_name FND_TS_MIG_CMDS.OBJECT_NAME%TYPE;
126: l_mig_status FND_TS_MIG_CMDS.MIGRATION_STATUS%TYPE := 'SUCCESS';
127: l_partitioned FND_TS_MIG_CMDS.PARTITIONED%TYPE;
128: l_queue_name VARCHAR2(100);

Line 125: l_object_name FND_TS_MIG_CMDS.OBJECT_NAME%TYPE;

121:
122: l_parent_owner FND_TS_MIG_CMDS.PARENT_OWNER%TYPE;
123: l_parent_object_name FND_TS_MIG_CMDS.PARENT_OBJECT_NAME%TYPE;
124: l_owner FND_TS_MIG_CMDS.OWNER%TYPE;
125: l_object_name FND_TS_MIG_CMDS.OBJECT_NAME%TYPE;
126: l_mig_status FND_TS_MIG_CMDS.MIGRATION_STATUS%TYPE := 'SUCCESS';
127: l_partitioned FND_TS_MIG_CMDS.PARTITIONED%TYPE;
128: l_queue_name VARCHAR2(100);
129: l_cnt NUMBER;

Line 126: l_mig_status FND_TS_MIG_CMDS.MIGRATION_STATUS%TYPE := 'SUCCESS';

122: l_parent_owner FND_TS_MIG_CMDS.PARENT_OWNER%TYPE;
123: l_parent_object_name FND_TS_MIG_CMDS.PARENT_OBJECT_NAME%TYPE;
124: l_owner FND_TS_MIG_CMDS.OWNER%TYPE;
125: l_object_name FND_TS_MIG_CMDS.OBJECT_NAME%TYPE;
126: l_mig_status FND_TS_MIG_CMDS.MIGRATION_STATUS%TYPE := 'SUCCESS';
127: l_partitioned FND_TS_MIG_CMDS.PARTITIONED%TYPE;
128: l_queue_name VARCHAR2(100);
129: l_cnt NUMBER;
130: l_string VARCHAR2(4000);

Line 127: l_partitioned FND_TS_MIG_CMDS.PARTITIONED%TYPE;

123: l_parent_object_name FND_TS_MIG_CMDS.PARENT_OBJECT_NAME%TYPE;
124: l_owner FND_TS_MIG_CMDS.OWNER%TYPE;
125: l_object_name FND_TS_MIG_CMDS.OBJECT_NAME%TYPE;
126: l_mig_status FND_TS_MIG_CMDS.MIGRATION_STATUS%TYPE := 'SUCCESS';
127: l_partitioned FND_TS_MIG_CMDS.PARTITIONED%TYPE;
128: l_queue_name VARCHAR2(100);
129: l_cnt NUMBER;
130: l_string VARCHAR2(4000);
131: TYPE mig_cmd_cur_type IS REF CURSOR;

Line 156: from fnd_ts_mig_cmds

152: migration_cmd,
153: partitioned,
154: parent_owner,
155: parent_object_name
156: from fnd_ts_mig_cmds
157: --where object_type IN ('TABLE', 'INDEX', 'MVIEW', 'MV_LOG', 'LONG_INDEX','LONG_MVLOG')
158: where object_type IN ('TABLE', 'INDEX', 'MVIEW', 'MV_LOG')
159: and migration_status in ('ERROR', 'GENERATED')
160: and object_name not like 'FND_TS_MIG_CMDS%'

Line 160: and object_name not like 'FND_TS_MIG_CMDS%'

156: from fnd_ts_mig_cmds
157: --where object_type IN ('TABLE', 'INDEX', 'MVIEW', 'MV_LOG', 'LONG_INDEX','LONG_MVLOG')
158: where object_type IN ('TABLE', 'INDEX', 'MVIEW', 'MV_LOG')
159: and migration_status in ('ERROR', 'GENERATED')
160: and object_name not like 'FND_TS_MIG_CMDS%'
161: and object_name not like 'FND_TS_SIZING%'
162: and object_name not like 'FND_TS_PROD_INSTS%'
163: AND execution_mode = l_exec_mode
164: AND ( (migration_status = 'ERROR' -- for restart

Line 171: (migration_status = 'GENERATED' and parent_lineno in (select lineno from fnd_ts_mig_cmds where migration_status='SUCCESS')) -- for bug 4332349

167: AND start_date IS NOT NULL)) -- for restart of Abort cases
168: OR
169: (parent_lineno IS NULL) -- for first time enqueueing
170: OR
171: (migration_status = 'GENERATED' and parent_lineno in (select lineno from fnd_ts_mig_cmds where migration_status='SUCCESS')) -- for bug 4332349
172: )
173: order by total_blocks desc;
174:
175: l_schema_list VARCHAR2(4000);

Line 209: from fnd_ts_mig_cmds

205: migration_cmd,
206: partitioned,
207: parent_owner,
208: parent_object_name
209: from fnd_ts_mig_cmds
210: where owner IN '||l_schema_list||'
211: and object_type IN (''TABLE'', ''INDEX'', ''MVIEW'', ''MV_LOG'', ''LONG_INDEX'',''LONG_MVLOG'')
212: and migration_status in (''ERROR'', ''GENERATED'')
213: and object_name not like ''FND_TS_MIG_CMDS%''

Line 213: and object_name not like ''FND_TS_MIG_CMDS%''

209: from fnd_ts_mig_cmds
210: where owner IN '||l_schema_list||'
211: and object_type IN (''TABLE'', ''INDEX'', ''MVIEW'', ''MV_LOG'', ''LONG_INDEX'',''LONG_MVLOG'')
212: and migration_status in (''ERROR'', ''GENERATED'')
213: and object_name not like ''FND_TS_MIG_CMDS%''
214: and object_name not like ''FND_TS_SIZING%''
215: and object_name not like ''FND_TS_PROD_INSTS%''
216: AND execution_mode = '''||p_exec_mode||'''
217: AND ( (migration_status = ''ERROR''

Line 390: from fnd_ts_mig_cmds

386: IS
387: cursor disable_cur is
388: select lineno,
389: migration_cmd
390: from fnd_ts_mig_cmds
391: where owner = p_owner
392: and object_type = 'DISABLE_CONSTRAINT'
393: order by lineno asc;
394: query VARCHAR2(4000);

Line 403: UPDATE fnd_ts_mig_cmds

399: FOR disable_rec IN disable_cur
400: LOOP
401: query := disable_rec.migration_cmd;
402: BEGIN
403: UPDATE fnd_ts_mig_cmds
404: SET start_date = sysdate,
405: end_date = null
406: WHERE lineno = disable_rec.lineno;
407:

Line 410: UPDATE fnd_ts_mig_cmds

406: WHERE lineno = disable_rec.lineno;
407:
408: EXECUTE IMMEDIATE query;
409:
410: UPDATE fnd_ts_mig_cmds
411: SET migration_status = 'SUCCESS',
412: end_date = sysdate,
413: last_update_date = sysdate,
414: error_text = NULL

Line 420: UPDATE fnd_ts_mig_cmds

416: EXCEPTION
417: WHEN OTHERS THEN
418: l_err := sqlerrm(sqlcode);
419: x_return_status := 'ERROR';
420: UPDATE fnd_ts_mig_cmds
421: SET migration_status = 'ERROR',
422: end_date = sysdate,
423: error_text = l_err,
424: last_update_date = sysdate

Line 437: from fnd_ts_mig_cmds

433: IS
434: cursor disable_cur is
435: select lineno,
436: migration_cmd
437: from fnd_ts_mig_cmds
438: where owner = p_owner
439: and object_type = 'DISABLE_TRIGGER'
440: order by lineno asc;
441: query VARCHAR2(4000);

Line 450: UPDATE fnd_ts_mig_cmds

446: FOR disable_rec IN disable_cur
447: LOOP
448: query := disable_rec.migration_cmd;
449: BEGIN
450: UPDATE fnd_ts_mig_cmds
451: SET start_date = sysdate,
452: end_date = null
453: WHERE lineno = disable_rec.lineno;
454:

Line 457: UPDATE fnd_ts_mig_cmds

453: WHERE lineno = disable_rec.lineno;
454:
455: EXECUTE IMMEDIATE query;
456:
457: UPDATE fnd_ts_mig_cmds
458: SET migration_status = 'SUCCESS',
459: end_date = sysdate,
460: last_update_date = sysdate,
461: error_text = NULL

Line 467: UPDATE fnd_ts_mig_cmds

463: EXCEPTION
464: WHEN OTHERS THEN
465: l_err := sqlerrm(sqlcode);
466: x_return_status := 'ERROR';
467: UPDATE fnd_ts_mig_cmds
468: SET migration_status = 'ERROR',
469: end_date = sysdate,
470: error_text = l_err,
471: last_update_date = sysdate

Line 484: from fnd_ts_mig_cmds

480: IS
481: cursor disable_cur is
482: select lineno,
483: migration_cmd
484: from fnd_ts_mig_cmds
485: where owner = p_owner
486: and object_type = 'STOP_QUEUE'
487: order by lineno asc;
488: query VARCHAR2(4000);

Line 497: UPDATE fnd_ts_mig_cmds

493: FOR disable_rec IN disable_cur
494: LOOP
495: query := disable_rec.migration_cmd;
496: BEGIN
497: UPDATE fnd_ts_mig_cmds
498: SET start_date = sysdate,
499: end_date = null
500: WHERE lineno = disable_rec.lineno;
501:

Line 504: UPDATE fnd_ts_mig_cmds

500: WHERE lineno = disable_rec.lineno;
501:
502: EXECUTE IMMEDIATE query;
503:
504: UPDATE fnd_ts_mig_cmds
505: SET migration_status = 'SUCCESS',
506: end_date = sysdate,
507: last_update_date = sysdate,
508: error_text = NULL

Line 514: UPDATE fnd_ts_mig_cmds

510: EXCEPTION
511: WHEN OTHERS THEN
512: l_err := sqlerrm(sqlcode);
513: x_return_status := 'ERROR';
514: UPDATE fnd_ts_mig_cmds
515: SET migration_status = 'ERROR',
516: end_date = sysdate,
517: error_text = l_err,
518: last_update_date = sysdate

Line 531: from fnd_ts_mig_cmds

527: IS
528: cursor disable_cur is
529: select lineno,
530: migration_cmd
531: from fnd_ts_mig_cmds
532: where owner = p_owner
533: and object_type = 'DISABLE_POLICY'
534: order by lineno asc;
535: query VARCHAR2(4000);

Line 544: UPDATE fnd_ts_mig_cmds

540: FOR disable_rec IN disable_cur
541: LOOP
542: query := disable_rec.migration_cmd;
543: BEGIN
544: UPDATE fnd_ts_mig_cmds
545: SET start_date = sysdate,
546: end_date = null
547: WHERE lineno = disable_rec.lineno;
548:

Line 551: UPDATE fnd_ts_mig_cmds

547: WHERE lineno = disable_rec.lineno;
548:
549: EXECUTE IMMEDIATE query;
550:
551: UPDATE fnd_ts_mig_cmds
552: SET migration_status = 'SUCCESS',
553: end_date = sysdate,
554: last_update_date = sysdate,
555: error_text = NULL

Line 561: UPDATE fnd_ts_mig_cmds

557: EXCEPTION
558: WHEN OTHERS THEN
559: l_err := sqlerrm(sqlcode);
560: x_return_status := 'ERROR';
561: UPDATE fnd_ts_mig_cmds
562: SET migration_status = 'ERROR',
563: end_date = sysdate,
564: error_text = l_err,
565: last_update_date = sysdate

Line 578: from fnd_ts_mig_cmds

574: IS
575: cursor disable_all_cur is
576: select lineno,
577: migration_cmd
578: from fnd_ts_mig_cmds
579: where object_type IN ('DISABLE_TRIGGER', 'DISABLE_CONSTRAINT', 'STOP_QUEUE', 'DISABLE_POLICY');
580:
581: TYPE disable_cur_type IS REF CURSOR;
582: disable_cur disable_cur_type;

Line 586: l_lineno FND_TS_MIG_CMDS.LINENO%TYPE;

582: disable_cur disable_cur_type;
583: l_string VARCHAR2(4000);
584: l_list VARCHAR2(4000);
585: l_err VARCHAR2(4000);
586: l_lineno FND_TS_MIG_CMDS.LINENO%TYPE;
587: l_migration_cmd FND_TS_MIG_CMDS.MIGRATION_CMD%TYPE;
588: query VARCHAR2(4000);
589:
590: l_schema_list VARCHAR2(4000);

Line 587: l_migration_cmd FND_TS_MIG_CMDS.MIGRATION_CMD%TYPE;

583: l_string VARCHAR2(4000);
584: l_list VARCHAR2(4000);
585: l_err VARCHAR2(4000);
586: l_lineno FND_TS_MIG_CMDS.LINENO%TYPE;
587: l_migration_cmd FND_TS_MIG_CMDS.MIGRATION_CMD%TYPE;
588: query VARCHAR2(4000);
589:
590: l_schema_list VARCHAR2(4000);
591: l_old_index NUMBER := 0;

Line 620: UPDATE fnd_ts_mig_cmds

616: FOR disable_rec IN disable_all_cur
617: LOOP
618: query := disable_rec.migration_cmd;
619: BEGIN
620: UPDATE fnd_ts_mig_cmds
621: SET start_date = sysdate,
622: end_date = null
623: WHERE lineno = disable_rec.lineno;
624:

Line 627: UPDATE fnd_ts_mig_cmds

623: WHERE lineno = disable_rec.lineno;
624:
625: EXECUTE IMMEDIATE query;
626:
627: UPDATE fnd_ts_mig_cmds
628: SET migration_status = 'SUCCESS',
629: end_date = sysdate,
630: last_update_date = sysdate,
631: error_text = NULL

Line 637: UPDATE fnd_ts_mig_cmds

633: EXCEPTION
634: WHEN OTHERS THEN
635: l_err := sqlerrm(sqlcode);
636: x_return_status := 'ERROR';
637: UPDATE fnd_ts_mig_cmds
638: SET migration_status = 'ERROR',
639: end_date = sysdate,
640: error_text = l_err,
641: last_update_date = sysdate

Line 646: l_string := 'select lineno, migration_cmd from fnd_ts_mig_cmds

642: WHERE lineno = disable_rec.lineno;
643: END;
644: END LOOP;
645: else -- for a list of schemas
646: l_string := 'select lineno, migration_cmd from fnd_ts_mig_cmds
647: where owner IN '||l_schema_list||'
648: and object_type IN (''DISABLE_TRIGGER'', ''DISABLE_CONSTRAINT'', ''STOP_QUEUE'', ''DISABLE_POLICY'')';
649: --dbms_output.put_line(l_string);
650: OPEN disable_cur FOR l_string;

Line 656: UPDATE fnd_ts_mig_cmds

652: FETCH disable_cur INTO l_lineno, l_migration_cmd;
653: EXIT WHEN disable_cur%NOTFOUND;
654: query := l_migration_cmd;
655: BEGIN
656: UPDATE fnd_ts_mig_cmds
657: SET start_date = sysdate,
658: end_date = null
659: WHERE lineno = l_lineno;
660:

Line 663: UPDATE fnd_ts_mig_cmds

659: WHERE lineno = l_lineno;
660:
661: EXECUTE IMMEDIATE query;
662:
663: UPDATE fnd_ts_mig_cmds
664: SET migration_status = 'SUCCESS',
665: end_date = sysdate,
666: last_update_date = sysdate,
667: error_text = NULL

Line 673: UPDATE fnd_ts_mig_cmds

669: EXCEPTION
670: WHEN OTHERS THEN
671: l_err := sqlerrm(sqlcode);
672: x_return_status := 'ERROR';
673: UPDATE fnd_ts_mig_cmds
674: SET migration_status = 'ERROR',
675: end_date = sysdate,
676: error_text = l_err,
677: last_update_date = sysdate

Line 692: from fnd_ts_mig_cmds

688: IS
689: cursor enable_cur is
690: select lineno,
691: migration_cmd
692: from fnd_ts_mig_cmds
693: where owner = p_owner
694: and object_type = 'ENABLE_CONSTRAINT'
695: order by lineno asc;
696: query VARCHAR2(4000);

Line 705: UPDATE fnd_ts_mig_cmds

701: FOR enable_rec IN enable_cur
702: LOOP
703: query := enable_rec.migration_cmd;
704: BEGIN
705: UPDATE fnd_ts_mig_cmds
706: SET start_date = sysdate,
707: end_date = null
708: WHERE lineno = enable_rec.lineno;
709:

Line 712: UPDATE fnd_ts_mig_cmds

708: WHERE lineno = enable_rec.lineno;
709:
710: EXECUTE IMMEDIATE query;
711:
712: UPDATE fnd_ts_mig_cmds
713: SET migration_status = 'SUCCESS',
714: end_date = sysdate,
715: last_update_date = sysdate,
716: error_text = NULL

Line 722: UPDATE fnd_ts_mig_cmds

718: EXCEPTION
719: WHEN OTHERS THEN
720: l_err := sqlerrm(sqlcode);
721: x_return_status := 'ERROR';
722: UPDATE fnd_ts_mig_cmds
723: SET migration_status = 'ERROR',
724: end_date = sysdate,
725: error_text = l_err,
726: last_update_date = sysdate

Line 739: from fnd_ts_mig_cmds

735: IS
736: cursor enable_cur is
737: select lineno,
738: migration_cmd
739: from fnd_ts_mig_cmds
740: where owner = p_owner
741: and object_type = 'ENABLE_TRIGGER'
742: order by lineno asc;
743: query VARCHAR2(4000);

Line 752: UPDATE fnd_ts_mig_cmds

748: FOR enable_rec IN enable_cur
749: LOOP
750: query := enable_rec.migration_cmd;
751: BEGIN
752: UPDATE fnd_ts_mig_cmds
753: SET start_date = sysdate,
754: end_date = null
755: WHERE lineno = enable_rec.lineno;
756:

Line 759: UPDATE fnd_ts_mig_cmds

755: WHERE lineno = enable_rec.lineno;
756:
757: EXECUTE IMMEDIATE query;
758:
759: UPDATE fnd_ts_mig_cmds
760: SET migration_status = 'SUCCESS',
761: end_date = sysdate,
762: last_update_date = sysdate,
763: error_text = NULL

Line 769: UPDATE fnd_ts_mig_cmds

765: EXCEPTION
766: WHEN OTHERS THEN
767: l_err := sqlerrm(sqlcode);
768: x_return_status := 'ERROR';
769: UPDATE fnd_ts_mig_cmds
770: SET migration_status = 'ERROR',
771: end_date = sysdate,
772: error_text = l_err,
773: last_update_date = sysdate

Line 786: from fnd_ts_mig_cmds

782: IS
783: cursor enable_cur is
784: select lineno,
785: migration_cmd
786: from fnd_ts_mig_cmds
787: where owner = p_owner
788: and object_type = 'START_QUEUE'
789: order by lineno asc;
790: query VARCHAR2(4000);

Line 799: UPDATE fnd_ts_mig_cmds

795: FOR enable_rec IN enable_cur
796: LOOP
797: query := enable_rec.migration_cmd;
798: BEGIN
799: UPDATE fnd_ts_mig_cmds
800: SET start_date = sysdate,
801: end_date = null
802: WHERE lineno = enable_rec.lineno;
803:

Line 806: UPDATE fnd_ts_mig_cmds

802: WHERE lineno = enable_rec.lineno;
803:
804: EXECUTE IMMEDIATE query;
805:
806: UPDATE fnd_ts_mig_cmds
807: SET migration_status = 'SUCCESS',
808: end_date = sysdate,
809: last_update_date = sysdate,
810: error_text = NULL

Line 816: UPDATE fnd_ts_mig_cmds

812: EXCEPTION
813: WHEN OTHERS THEN
814: l_err := sqlerrm(sqlcode);
815: x_return_status := 'ERROR';
816: UPDATE fnd_ts_mig_cmds
817: SET migration_status = 'ERROR',
818: end_date = sysdate,
819: error_text = l_err,
820: last_update_date = sysdate

Line 833: from fnd_ts_mig_cmds

829: IS
830: cursor enable_cur is
831: select lineno,
832: migration_cmd
833: from fnd_ts_mig_cmds
834: where owner = p_owner
835: and object_type = 'ENABLE_POLICY'
836: order by lineno asc;
837: query VARCHAR2(4000);

Line 846: UPDATE fnd_ts_mig_cmds

842: FOR enable_rec IN enable_cur
843: LOOP
844: query := enable_rec.migration_cmd;
845: BEGIN
846: UPDATE fnd_ts_mig_cmds
847: SET start_date = sysdate,
848: end_date = null
849: WHERE lineno = enable_rec.lineno;
850:

Line 853: UPDATE fnd_ts_mig_cmds

849: WHERE lineno = enable_rec.lineno;
850:
851: EXECUTE IMMEDIATE query;
852:
853: UPDATE fnd_ts_mig_cmds
854: SET migration_status = 'SUCCESS',
855: end_date = sysdate,
856: last_update_date = sysdate,
857: error_text = NULL

Line 863: UPDATE fnd_ts_mig_cmds

859: EXCEPTION
860: WHEN OTHERS THEN
861: l_err := sqlerrm(sqlcode);
862: x_return_status := 'ERROR';
863: UPDATE fnd_ts_mig_cmds
864: SET migration_status = 'ERROR',
865: end_date = sysdate,
866: error_text = l_err,
867: last_update_date = sysdate

Line 880: from fnd_ts_mig_cmds

876: IS
877: cursor enable_all_cur is
878: select lineno,
879: migration_cmd
880: from fnd_ts_mig_cmds
881: where object_type IN ('ENABLE_TRIGGER', 'ENABLE_CONSTRAINT', 'START_QUEUE', 'ENABLE_POLICY');
882:
883: cursor proc_csr IS
884: select 1

Line 901: from fnd_ts_mig_cmds

897:
898: cursor postmig_csr is
899: select lineno,
900: migration_cmd
901: from fnd_ts_mig_cmds
902: where object_type = 'POSTMIG';
903:
904: TYPE enable_cur_type IS REF CURSOR;
905: enable_cur enable_cur_type;

Line 909: l_lineno FND_TS_MIG_CMDS.LINENO%TYPE;

905: enable_cur enable_cur_type;
906: l_string VARCHAR2(4000);
907: l_list VARCHAR2(4000);
908: l_err VARCHAR2(4000);
909: l_lineno FND_TS_MIG_CMDS.LINENO%TYPE;
910: l_migration_cmd FND_TS_MIG_CMDS.MIGRATION_CMD%TYPE;
911: query VARCHAR2(4000);
912: l_schema_list VARCHAR2(4000);
913: l_old_index NUMBER := 0;

Line 910: l_migration_cmd FND_TS_MIG_CMDS.MIGRATION_CMD%TYPE;

906: l_string VARCHAR2(4000);
907: l_list VARCHAR2(4000);
908: l_err VARCHAR2(4000);
909: l_lineno FND_TS_MIG_CMDS.LINENO%TYPE;
910: l_migration_cmd FND_TS_MIG_CMDS.MIGRATION_CMD%TYPE;
911: query VARCHAR2(4000);
912: l_schema_list VARCHAR2(4000);
913: l_old_index NUMBER := 0;
914: l_new_index NUMBER := 0;

Line 944: UPDATE fnd_ts_mig_cmds

940: FOR enable_rec IN enable_all_cur
941: LOOP
942: query := enable_rec.migration_cmd;
943: BEGIN
944: UPDATE fnd_ts_mig_cmds
945: SET start_date = sysdate,
946: end_date = null
947: WHERE lineno = enable_rec.lineno;
948:

Line 951: UPDATE fnd_ts_mig_cmds

947: WHERE lineno = enable_rec.lineno;
948:
949: EXECUTE IMMEDIATE query;
950:
951: UPDATE fnd_ts_mig_cmds
952: SET migration_status = 'SUCCESS',
953: end_date = sysdate,
954: last_update_date = sysdate,
955: error_text = NULL

Line 961: UPDATE fnd_ts_mig_cmds

957: EXCEPTION
958: WHEN OTHERS THEN
959: l_err := sqlerrm(sqlcode);
960: x_return_status := 'ERROR';
961: UPDATE fnd_ts_mig_cmds
962: SET migration_status = 'ERROR',
963: end_date = sysdate,
964: error_text = l_err,
965: last_update_date = sysdate

Line 970: l_string := 'select lineno, migration_cmd from fnd_ts_mig_cmds

966: WHERE lineno = enable_rec.lineno;
967: END;
968: END LOOP;
969: else -- for a list of schemas
970: l_string := 'select lineno, migration_cmd from fnd_ts_mig_cmds
971: where owner IN '||l_schema_list||'
972: and object_type IN (''ENABLE_TRIGGER'', ''ENABLE_CONSTRAINT'', ''START_QUEUE'', ''ENABLE_POLICY'', ''POSTMIG'')';
973: OPEN enable_cur FOR l_string;
974: LOOP

Line 979: UPDATE fnd_ts_mig_cmds

975: FETCH enable_cur INTO l_lineno, l_migration_cmd;
976: EXIT WHEN enable_cur%NOTFOUND;
977: query := l_migration_cmd;
978: BEGIN
979: UPDATE fnd_ts_mig_cmds
980: SET start_date = sysdate,
981: end_date = null
982: WHERE lineno = l_lineno;
983:

Line 986: UPDATE fnd_ts_mig_cmds

982: WHERE lineno = l_lineno;
983:
984: EXECUTE IMMEDIATE query;
985:
986: UPDATE fnd_ts_mig_cmds
987: SET migration_status = 'SUCCESS',
988: end_date = sysdate,
989: last_update_date = sysdate,
990: error_text = NULL

Line 996: UPDATE fnd_ts_mig_cmds

992: EXCEPTION
993: WHEN OTHERS THEN
994: l_err := sqlerrm(sqlcode);
995: x_return_status := 'ERROR';
996: UPDATE fnd_ts_mig_cmds
997: SET migration_status = 'ERROR',
998: end_date = sysdate,
999: error_text = l_err,
1000: last_update_date = sysdate

Line 1013: UPDATE fnd_ts_mig_cmds

1009: if proc_csr%NOTFOUND then
1010: FOR postmig_rec IN postmig_csr
1011: LOOP
1012: BEGIN
1013: UPDATE fnd_ts_mig_cmds
1014: SET start_date = sysdate,
1015: end_date = null
1016: WHERE lineno = postmig_rec.lineno;
1017:

Line 1020: UPDATE fnd_ts_mig_cmds

1016: WHERE lineno = postmig_rec.lineno;
1017:
1018: EXECUTE IMMEDIATE postmig_rec.migration_cmd;
1019:
1020: UPDATE fnd_ts_mig_cmds
1021: SET migration_status = 'SUCCESS',
1022: end_date = sysdate,
1023: last_update_date = sysdate,
1024: error_text = NULL

Line 1030: UPDATE fnd_ts_mig_cmds

1026: EXCEPTION
1027: WHEN OTHERS THEN
1028: l_err := sqlerrm(sqlcode);
1029: x_return_status := 'ERROR';
1030: UPDATE fnd_ts_mig_cmds
1031: SET migration_status = 'ERROR',
1032: end_date = sysdate,
1033: error_text = l_err,
1034: last_update_date = sysdate

Line 1045: from fnd_ts_mig_cmds

1041:
1042: PROCEDURE migtsobj IS
1043: CURSOR c1 IS
1044: select *
1045: from fnd_ts_mig_cmds
1046: where migration_status <> 'SUCCESS'
1047: and (object_name like 'FND_TS_MIG_CMDS%'
1048: or object_name like 'FND_TS_PROD_INST%'
1049: or object_name like 'FND_TS_SIZING%')

Line 1047: and (object_name like 'FND_TS_MIG_CMDS%'

1043: CURSOR c1 IS
1044: select *
1045: from fnd_ts_mig_cmds
1046: where migration_status <> 'SUCCESS'
1047: and (object_name like 'FND_TS_MIG_CMDS%'
1048: or object_name like 'FND_TS_PROD_INST%'
1049: or object_name like 'FND_TS_SIZING%')
1050: order by lineno;
1051: TYPE cmd_tab_type IS TABLE OF FND_TS_MIG_CMDS%ROWTYPE;

Line 1051: TYPE cmd_tab_type IS TABLE OF FND_TS_MIG_CMDS%ROWTYPE;

1047: and (object_name like 'FND_TS_MIG_CMDS%'
1048: or object_name like 'FND_TS_PROD_INST%'
1049: or object_name like 'FND_TS_SIZING%')
1050: order by lineno;
1051: TYPE cmd_tab_type IS TABLE OF FND_TS_MIG_CMDS%ROWTYPE;
1052: cmd_tab cmd_tab_type;
1053: i INTEGER := 0;
1054: BEGIN
1055: OPEN c1;

Line 1082: UPDATE fnd_ts_mig_cmds

1078: END LOOP;
1079:
1080: FOR j IN cmd_tab.FIRST..cmd_tab.LAST
1081: LOOP
1082: UPDATE fnd_ts_mig_cmds
1083: SET migration_status = cmd_tab(j).migration_status,
1084: start_date = cmd_tab(j).start_date,
1085: end_date = cmd_tab(j).end_date,
1086: last_update_date = cmd_tab(j).last_update_date,