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.HR_DM_DELETE dependencies on UTL_FILE

Line 601: l_filehandle UTL_FILE.FILE_TYPE;

597: --
598:
599: l_location VARCHAR2(2000);
600: l_aol_filename VARCHAR2(30);
601: l_filehandle UTL_FILE.FILE_TYPE;
602: l_sysdate VARCHAR2(30);
603: e_fatal_error EXCEPTION;
604: l_fatal_error_message VARCHAR2(200);
605:

Line 616: fnd_profile.get('UTL_FILE_LOG', l_location);

612:
613:
614:
615: -- find logfile directory and open file for delete script
616: fnd_profile.get('UTL_FILE_LOG', l_location);
617: l_aol_filename := 'DM' || r_migration_data.migration_id || '.sql';
618: hr_dm_utility.message('INFO','l_location ' || l_location, 13);
619: hr_dm_utility.message('INFO','l_aol_filename ' || l_aol_filename, 13);
620:

Line 630: l_filehandle := utl_file.fopen(l_location, l_aol_filename, 'w');

626: RAISE e_fatal_error;
627: END IF;
628:
629:
630: l_filehandle := utl_file.fopen(l_location, l_aol_filename, 'w');
631:
632: -- add header info
633: utl_file.put_line(l_filehandle, 'REM');
634: utl_file.put_line(l_filehandle, 'WHENEVER SQLERROR EXIT FAILURE ROLLBACK;');

Line 633: utl_file.put_line(l_filehandle, 'REM');

629:
630: l_filehandle := utl_file.fopen(l_location, l_aol_filename, 'w');
631:
632: -- add header info
633: utl_file.put_line(l_filehandle, 'REM');
634: utl_file.put_line(l_filehandle, 'WHENEVER SQLERROR EXIT FAILURE ROLLBACK;');
635: utl_file.put_line(l_filehandle, 'WHENEVER OSERROR EXIT FAILURE ROLLBACK;');
636: utl_file.put_line(l_filehandle, 'REM');
637: utl_file.put_line(l_filehandle, 'REM Data Migrator Delete Script');

Line 634: utl_file.put_line(l_filehandle, 'WHENEVER SQLERROR EXIT FAILURE ROLLBACK;');

630: l_filehandle := utl_file.fopen(l_location, l_aol_filename, 'w');
631:
632: -- add header info
633: utl_file.put_line(l_filehandle, 'REM');
634: utl_file.put_line(l_filehandle, 'WHENEVER SQLERROR EXIT FAILURE ROLLBACK;');
635: utl_file.put_line(l_filehandle, 'WHENEVER OSERROR EXIT FAILURE ROLLBACK;');
636: utl_file.put_line(l_filehandle, 'REM');
637: utl_file.put_line(l_filehandle, 'REM Data Migrator Delete Script');
638: utl_file.put_line(l_filehandle, 'REM ');

Line 635: utl_file.put_line(l_filehandle, 'WHENEVER OSERROR EXIT FAILURE ROLLBACK;');

631:
632: -- add header info
633: utl_file.put_line(l_filehandle, 'REM');
634: utl_file.put_line(l_filehandle, 'WHENEVER SQLERROR EXIT FAILURE ROLLBACK;');
635: utl_file.put_line(l_filehandle, 'WHENEVER OSERROR EXIT FAILURE ROLLBACK;');
636: utl_file.put_line(l_filehandle, 'REM');
637: utl_file.put_line(l_filehandle, 'REM Data Migrator Delete Script');
638: utl_file.put_line(l_filehandle, 'REM ');
639: utl_file.put_line(l_filehandle, 'REM Migration ID ' || r_migration_data.migration_id);

Line 636: utl_file.put_line(l_filehandle, 'REM');

632: -- add header info
633: utl_file.put_line(l_filehandle, 'REM');
634: utl_file.put_line(l_filehandle, 'WHENEVER SQLERROR EXIT FAILURE ROLLBACK;');
635: utl_file.put_line(l_filehandle, 'WHENEVER OSERROR EXIT FAILURE ROLLBACK;');
636: utl_file.put_line(l_filehandle, 'REM');
637: utl_file.put_line(l_filehandle, 'REM Data Migrator Delete Script');
638: utl_file.put_line(l_filehandle, 'REM ');
639: utl_file.put_line(l_filehandle, 'REM Migration ID ' || r_migration_data.migration_id);
640: SELECT to_char(sysdate,'HH:MI DD-MON-YYYY')

Line 637: utl_file.put_line(l_filehandle, 'REM Data Migrator Delete Script');

633: utl_file.put_line(l_filehandle, 'REM');
634: utl_file.put_line(l_filehandle, 'WHENEVER SQLERROR EXIT FAILURE ROLLBACK;');
635: utl_file.put_line(l_filehandle, 'WHENEVER OSERROR EXIT FAILURE ROLLBACK;');
636: utl_file.put_line(l_filehandle, 'REM');
637: utl_file.put_line(l_filehandle, 'REM Data Migrator Delete Script');
638: utl_file.put_line(l_filehandle, 'REM ');
639: utl_file.put_line(l_filehandle, 'REM Migration ID ' || r_migration_data.migration_id);
640: SELECT to_char(sysdate,'HH:MI DD-MON-YYYY')
641: INTO l_sysdate

Line 638: utl_file.put_line(l_filehandle, 'REM ');

634: utl_file.put_line(l_filehandle, 'WHENEVER SQLERROR EXIT FAILURE ROLLBACK;');
635: utl_file.put_line(l_filehandle, 'WHENEVER OSERROR EXIT FAILURE ROLLBACK;');
636: utl_file.put_line(l_filehandle, 'REM');
637: utl_file.put_line(l_filehandle, 'REM Data Migrator Delete Script');
638: utl_file.put_line(l_filehandle, 'REM ');
639: utl_file.put_line(l_filehandle, 'REM Migration ID ' || r_migration_data.migration_id);
640: SELECT to_char(sysdate,'HH:MI DD-MON-YYYY')
641: INTO l_sysdate
642: FROM dual;

Line 639: utl_file.put_line(l_filehandle, 'REM Migration ID ' || r_migration_data.migration_id);

635: utl_file.put_line(l_filehandle, 'WHENEVER OSERROR EXIT FAILURE ROLLBACK;');
636: utl_file.put_line(l_filehandle, 'REM');
637: utl_file.put_line(l_filehandle, 'REM Data Migrator Delete Script');
638: utl_file.put_line(l_filehandle, 'REM ');
639: utl_file.put_line(l_filehandle, 'REM Migration ID ' || r_migration_data.migration_id);
640: SELECT to_char(sysdate,'HH:MI DD-MON-YYYY')
641: INTO l_sysdate
642: FROM dual;
643: utl_file.put_line(l_filehandle, 'REM Date ' || l_sysdate);

Line 643: utl_file.put_line(l_filehandle, 'REM Date ' || l_sysdate);

639: utl_file.put_line(l_filehandle, 'REM Migration ID ' || r_migration_data.migration_id);
640: SELECT to_char(sysdate,'HH:MI DD-MON-YYYY')
641: INTO l_sysdate
642: FROM dual;
643: utl_file.put_line(l_filehandle, 'REM Date ' || l_sysdate);
644: utl_file.put_line(l_filehandle, 'REM ');
645: utl_file.put_line(l_filehandle, 'REM ');
646:
647: utl_file.put_line(l_filehandle, '--');

Line 644: utl_file.put_line(l_filehandle, 'REM ');

640: SELECT to_char(sysdate,'HH:MI DD-MON-YYYY')
641: INTO l_sysdate
642: FROM dual;
643: utl_file.put_line(l_filehandle, 'REM Date ' || l_sysdate);
644: utl_file.put_line(l_filehandle, 'REM ');
645: utl_file.put_line(l_filehandle, 'REM ');
646:
647: utl_file.put_line(l_filehandle, '--');
648: utl_file.put_line(l_filehandle, 'BEGIN');

Line 645: utl_file.put_line(l_filehandle, 'REM ');

641: INTO l_sysdate
642: FROM dual;
643: utl_file.put_line(l_filehandle, 'REM Date ' || l_sysdate);
644: utl_file.put_line(l_filehandle, 'REM ');
645: utl_file.put_line(l_filehandle, 'REM ');
646:
647: utl_file.put_line(l_filehandle, '--');
648: utl_file.put_line(l_filehandle, 'BEGIN');
649: utl_file.put_line(l_filehandle, '--');

Line 647: utl_file.put_line(l_filehandle, '--');

643: utl_file.put_line(l_filehandle, 'REM Date ' || l_sysdate);
644: utl_file.put_line(l_filehandle, 'REM ');
645: utl_file.put_line(l_filehandle, 'REM ');
646:
647: utl_file.put_line(l_filehandle, '--');
648: utl_file.put_line(l_filehandle, 'BEGIN');
649: utl_file.put_line(l_filehandle, '--');
650:
651: utl_file.put_line(l_filehandle, '-- local lookups, security info');

Line 648: utl_file.put_line(l_filehandle, 'BEGIN');

644: utl_file.put_line(l_filehandle, 'REM ');
645: utl_file.put_line(l_filehandle, 'REM ');
646:
647: utl_file.put_line(l_filehandle, '--');
648: utl_file.put_line(l_filehandle, 'BEGIN');
649: utl_file.put_line(l_filehandle, '--');
650:
651: utl_file.put_line(l_filehandle, '-- local lookups, security info');
652: utl_file.put_line(l_filehandle, 'hr_dm_delete.del_fnd_info(' ||

Line 649: utl_file.put_line(l_filehandle, '--');

645: utl_file.put_line(l_filehandle, 'REM ');
646:
647: utl_file.put_line(l_filehandle, '--');
648: utl_file.put_line(l_filehandle, 'BEGIN');
649: utl_file.put_line(l_filehandle, '--');
650:
651: utl_file.put_line(l_filehandle, '-- local lookups, security info');
652: utl_file.put_line(l_filehandle, 'hr_dm_delete.del_fnd_info(' ||
653: r_migration_data.business_group_id || ');');

Line 651: utl_file.put_line(l_filehandle, '-- local lookups, security info');

647: utl_file.put_line(l_filehandle, '--');
648: utl_file.put_line(l_filehandle, 'BEGIN');
649: utl_file.put_line(l_filehandle, '--');
650:
651: utl_file.put_line(l_filehandle, '-- local lookups, security info');
652: utl_file.put_line(l_filehandle, 'hr_dm_delete.del_fnd_info(' ||
653: r_migration_data.business_group_id || ');');
654: utl_file.put_line(l_filehandle, '');
655:

Line 652: utl_file.put_line(l_filehandle, 'hr_dm_delete.del_fnd_info(' ||

648: utl_file.put_line(l_filehandle, 'BEGIN');
649: utl_file.put_line(l_filehandle, '--');
650:
651: utl_file.put_line(l_filehandle, '-- local lookups, security info');
652: utl_file.put_line(l_filehandle, 'hr_dm_delete.del_fnd_info(' ||
653: r_migration_data.business_group_id || ');');
654: utl_file.put_line(l_filehandle, '');
655:
656: utl_file.put_line(l_filehandle, '');

Line 654: utl_file.put_line(l_filehandle, '');

650:
651: utl_file.put_line(l_filehandle, '-- local lookups, security info');
652: utl_file.put_line(l_filehandle, 'hr_dm_delete.del_fnd_info(' ||
653: r_migration_data.business_group_id || ');');
654: utl_file.put_line(l_filehandle, '');
655:
656: utl_file.put_line(l_filehandle, '');
657: utl_file.put_line(l_filehandle, '-- business group info');
658:

Line 656: utl_file.put_line(l_filehandle, '');

652: utl_file.put_line(l_filehandle, 'hr_dm_delete.del_fnd_info(' ||
653: r_migration_data.business_group_id || ');');
654: utl_file.put_line(l_filehandle, '');
655:
656: utl_file.put_line(l_filehandle, '');
657: utl_file.put_line(l_filehandle, '-- business group info');
658:
659: utl_file.put_line(l_filehandle, 'delete from HR_ALL_ORGANIZATION_UNITS_TL');
660: utl_file.put_line(l_filehandle, 'where ORGANIZATION_ID in (');

Line 657: utl_file.put_line(l_filehandle, '-- business group info');

653: r_migration_data.business_group_id || ');');
654: utl_file.put_line(l_filehandle, '');
655:
656: utl_file.put_line(l_filehandle, '');
657: utl_file.put_line(l_filehandle, '-- business group info');
658:
659: utl_file.put_line(l_filehandle, 'delete from HR_ALL_ORGANIZATION_UNITS_TL');
660: utl_file.put_line(l_filehandle, 'where ORGANIZATION_ID in (');
661: utl_file.put_line(l_filehandle, ' select ORGANIZATION_ID');

Line 659: utl_file.put_line(l_filehandle, 'delete from HR_ALL_ORGANIZATION_UNITS_TL');

655:
656: utl_file.put_line(l_filehandle, '');
657: utl_file.put_line(l_filehandle, '-- business group info');
658:
659: utl_file.put_line(l_filehandle, 'delete from HR_ALL_ORGANIZATION_UNITS_TL');
660: utl_file.put_line(l_filehandle, 'where ORGANIZATION_ID in (');
661: utl_file.put_line(l_filehandle, ' select ORGANIZATION_ID');
662: utl_file.put_line(l_filehandle, ' from HR_ALL_ORGANIZATION_UNITS');
663: utl_file.put_line(l_filehandle, ' where BUSINESS_GROUP_ID = ' ||

Line 660: utl_file.put_line(l_filehandle, 'where ORGANIZATION_ID in (');

656: utl_file.put_line(l_filehandle, '');
657: utl_file.put_line(l_filehandle, '-- business group info');
658:
659: utl_file.put_line(l_filehandle, 'delete from HR_ALL_ORGANIZATION_UNITS_TL');
660: utl_file.put_line(l_filehandle, 'where ORGANIZATION_ID in (');
661: utl_file.put_line(l_filehandle, ' select ORGANIZATION_ID');
662: utl_file.put_line(l_filehandle, ' from HR_ALL_ORGANIZATION_UNITS');
663: utl_file.put_line(l_filehandle, ' where BUSINESS_GROUP_ID = ' ||
664: r_migration_data.business_group_id || ');');

Line 661: utl_file.put_line(l_filehandle, ' select ORGANIZATION_ID');

657: utl_file.put_line(l_filehandle, '-- business group info');
658:
659: utl_file.put_line(l_filehandle, 'delete from HR_ALL_ORGANIZATION_UNITS_TL');
660: utl_file.put_line(l_filehandle, 'where ORGANIZATION_ID in (');
661: utl_file.put_line(l_filehandle, ' select ORGANIZATION_ID');
662: utl_file.put_line(l_filehandle, ' from HR_ALL_ORGANIZATION_UNITS');
663: utl_file.put_line(l_filehandle, ' where BUSINESS_GROUP_ID = ' ||
664: r_migration_data.business_group_id || ');');
665: utl_file.put_line(l_filehandle, '');

Line 662: utl_file.put_line(l_filehandle, ' from HR_ALL_ORGANIZATION_UNITS');

658:
659: utl_file.put_line(l_filehandle, 'delete from HR_ALL_ORGANIZATION_UNITS_TL');
660: utl_file.put_line(l_filehandle, 'where ORGANIZATION_ID in (');
661: utl_file.put_line(l_filehandle, ' select ORGANIZATION_ID');
662: utl_file.put_line(l_filehandle, ' from HR_ALL_ORGANIZATION_UNITS');
663: utl_file.put_line(l_filehandle, ' where BUSINESS_GROUP_ID = ' ||
664: r_migration_data.business_group_id || ');');
665: utl_file.put_line(l_filehandle, '');
666:

Line 663: utl_file.put_line(l_filehandle, ' where BUSINESS_GROUP_ID = ' ||

659: utl_file.put_line(l_filehandle, 'delete from HR_ALL_ORGANIZATION_UNITS_TL');
660: utl_file.put_line(l_filehandle, 'where ORGANIZATION_ID in (');
661: utl_file.put_line(l_filehandle, ' select ORGANIZATION_ID');
662: utl_file.put_line(l_filehandle, ' from HR_ALL_ORGANIZATION_UNITS');
663: utl_file.put_line(l_filehandle, ' where BUSINESS_GROUP_ID = ' ||
664: r_migration_data.business_group_id || ');');
665: utl_file.put_line(l_filehandle, '');
666:
667: utl_file.put_line(l_filehandle, 'delete from HR_LOCATIONS_ALL_TL');

Line 665: utl_file.put_line(l_filehandle, '');

661: utl_file.put_line(l_filehandle, ' select ORGANIZATION_ID');
662: utl_file.put_line(l_filehandle, ' from HR_ALL_ORGANIZATION_UNITS');
663: utl_file.put_line(l_filehandle, ' where BUSINESS_GROUP_ID = ' ||
664: r_migration_data.business_group_id || ');');
665: utl_file.put_line(l_filehandle, '');
666:
667: utl_file.put_line(l_filehandle, 'delete from HR_LOCATIONS_ALL_TL');
668: utl_file.put_line(l_filehandle, 'where LOCATION_ID in (');
669: utl_file.put_line(l_filehandle, ' select LOCATION_ID');

Line 667: utl_file.put_line(l_filehandle, 'delete from HR_LOCATIONS_ALL_TL');

663: utl_file.put_line(l_filehandle, ' where BUSINESS_GROUP_ID = ' ||
664: r_migration_data.business_group_id || ');');
665: utl_file.put_line(l_filehandle, '');
666:
667: utl_file.put_line(l_filehandle, 'delete from HR_LOCATIONS_ALL_TL');
668: utl_file.put_line(l_filehandle, 'where LOCATION_ID in (');
669: utl_file.put_line(l_filehandle, ' select LOCATION_ID');
670: utl_file.put_line(l_filehandle, ' from HR_LOCATIONS_ALL');
671: utl_file.put_line(l_filehandle, ' where BUSINESS_GROUP_ID = ' ||

Line 668: utl_file.put_line(l_filehandle, 'where LOCATION_ID in (');

664: r_migration_data.business_group_id || ');');
665: utl_file.put_line(l_filehandle, '');
666:
667: utl_file.put_line(l_filehandle, 'delete from HR_LOCATIONS_ALL_TL');
668: utl_file.put_line(l_filehandle, 'where LOCATION_ID in (');
669: utl_file.put_line(l_filehandle, ' select LOCATION_ID');
670: utl_file.put_line(l_filehandle, ' from HR_LOCATIONS_ALL');
671: utl_file.put_line(l_filehandle, ' where BUSINESS_GROUP_ID = ' ||
672: r_migration_data.business_group_id || ');');

Line 669: utl_file.put_line(l_filehandle, ' select LOCATION_ID');

665: utl_file.put_line(l_filehandle, '');
666:
667: utl_file.put_line(l_filehandle, 'delete from HR_LOCATIONS_ALL_TL');
668: utl_file.put_line(l_filehandle, 'where LOCATION_ID in (');
669: utl_file.put_line(l_filehandle, ' select LOCATION_ID');
670: utl_file.put_line(l_filehandle, ' from HR_LOCATIONS_ALL');
671: utl_file.put_line(l_filehandle, ' where BUSINESS_GROUP_ID = ' ||
672: r_migration_data.business_group_id || ');');
673: utl_file.put_line(l_filehandle, '');

Line 670: utl_file.put_line(l_filehandle, ' from HR_LOCATIONS_ALL');

666:
667: utl_file.put_line(l_filehandle, 'delete from HR_LOCATIONS_ALL_TL');
668: utl_file.put_line(l_filehandle, 'where LOCATION_ID in (');
669: utl_file.put_line(l_filehandle, ' select LOCATION_ID');
670: utl_file.put_line(l_filehandle, ' from HR_LOCATIONS_ALL');
671: utl_file.put_line(l_filehandle, ' where BUSINESS_GROUP_ID = ' ||
672: r_migration_data.business_group_id || ');');
673: utl_file.put_line(l_filehandle, '');
674:

Line 671: utl_file.put_line(l_filehandle, ' where BUSINESS_GROUP_ID = ' ||

667: utl_file.put_line(l_filehandle, 'delete from HR_LOCATIONS_ALL_TL');
668: utl_file.put_line(l_filehandle, 'where LOCATION_ID in (');
669: utl_file.put_line(l_filehandle, ' select LOCATION_ID');
670: utl_file.put_line(l_filehandle, ' from HR_LOCATIONS_ALL');
671: utl_file.put_line(l_filehandle, ' where BUSINESS_GROUP_ID = ' ||
672: r_migration_data.business_group_id || ');');
673: utl_file.put_line(l_filehandle, '');
674:
675: utl_file.put_line(l_filehandle, 'delete from HR_ORGANIZATION_INFORMATION ');

Line 673: utl_file.put_line(l_filehandle, '');

669: utl_file.put_line(l_filehandle, ' select LOCATION_ID');
670: utl_file.put_line(l_filehandle, ' from HR_LOCATIONS_ALL');
671: utl_file.put_line(l_filehandle, ' where BUSINESS_GROUP_ID = ' ||
672: r_migration_data.business_group_id || ');');
673: utl_file.put_line(l_filehandle, '');
674:
675: utl_file.put_line(l_filehandle, 'delete from HR_ORGANIZATION_INFORMATION ');
676: utl_file.put_line(l_filehandle, 'where ORGANIZATION_ID in (');
677: utl_file.put_line(l_filehandle, ' select ORGANIZATION_ID');

Line 675: utl_file.put_line(l_filehandle, 'delete from HR_ORGANIZATION_INFORMATION ');

671: utl_file.put_line(l_filehandle, ' where BUSINESS_GROUP_ID = ' ||
672: r_migration_data.business_group_id || ');');
673: utl_file.put_line(l_filehandle, '');
674:
675: utl_file.put_line(l_filehandle, 'delete from HR_ORGANIZATION_INFORMATION ');
676: utl_file.put_line(l_filehandle, 'where ORGANIZATION_ID in (');
677: utl_file.put_line(l_filehandle, ' select ORGANIZATION_ID');
678: utl_file.put_line(l_filehandle, ' from HR_ALL_ORGANIZATION_UNITS');
679: utl_file.put_line(l_filehandle, ' where BUSINESS_GROUP_ID = ' ||

Line 676: utl_file.put_line(l_filehandle, 'where ORGANIZATION_ID in (');

672: r_migration_data.business_group_id || ');');
673: utl_file.put_line(l_filehandle, '');
674:
675: utl_file.put_line(l_filehandle, 'delete from HR_ORGANIZATION_INFORMATION ');
676: utl_file.put_line(l_filehandle, 'where ORGANIZATION_ID in (');
677: utl_file.put_line(l_filehandle, ' select ORGANIZATION_ID');
678: utl_file.put_line(l_filehandle, ' from HR_ALL_ORGANIZATION_UNITS');
679: utl_file.put_line(l_filehandle, ' where BUSINESS_GROUP_ID = ' ||
680: r_migration_data.business_group_id || ');');

Line 677: utl_file.put_line(l_filehandle, ' select ORGANIZATION_ID');

673: utl_file.put_line(l_filehandle, '');
674:
675: utl_file.put_line(l_filehandle, 'delete from HR_ORGANIZATION_INFORMATION ');
676: utl_file.put_line(l_filehandle, 'where ORGANIZATION_ID in (');
677: utl_file.put_line(l_filehandle, ' select ORGANIZATION_ID');
678: utl_file.put_line(l_filehandle, ' from HR_ALL_ORGANIZATION_UNITS');
679: utl_file.put_line(l_filehandle, ' where BUSINESS_GROUP_ID = ' ||
680: r_migration_data.business_group_id || ');');
681: utl_file.put_line(l_filehandle, '');

Line 678: utl_file.put_line(l_filehandle, ' from HR_ALL_ORGANIZATION_UNITS');

674:
675: utl_file.put_line(l_filehandle, 'delete from HR_ORGANIZATION_INFORMATION ');
676: utl_file.put_line(l_filehandle, 'where ORGANIZATION_ID in (');
677: utl_file.put_line(l_filehandle, ' select ORGANIZATION_ID');
678: utl_file.put_line(l_filehandle, ' from HR_ALL_ORGANIZATION_UNITS');
679: utl_file.put_line(l_filehandle, ' where BUSINESS_GROUP_ID = ' ||
680: r_migration_data.business_group_id || ');');
681: utl_file.put_line(l_filehandle, '');
682:

Line 679: utl_file.put_line(l_filehandle, ' where BUSINESS_GROUP_ID = ' ||

675: utl_file.put_line(l_filehandle, 'delete from HR_ORGANIZATION_INFORMATION ');
676: utl_file.put_line(l_filehandle, 'where ORGANIZATION_ID in (');
677: utl_file.put_line(l_filehandle, ' select ORGANIZATION_ID');
678: utl_file.put_line(l_filehandle, ' from HR_ALL_ORGANIZATION_UNITS');
679: utl_file.put_line(l_filehandle, ' where BUSINESS_GROUP_ID = ' ||
680: r_migration_data.business_group_id || ');');
681: utl_file.put_line(l_filehandle, '');
682:
683: utl_file.put_line(l_filehandle, 'delete from HR_ALL_ORGANIZATION_UNITS');

Line 681: utl_file.put_line(l_filehandle, '');

677: utl_file.put_line(l_filehandle, ' select ORGANIZATION_ID');
678: utl_file.put_line(l_filehandle, ' from HR_ALL_ORGANIZATION_UNITS');
679: utl_file.put_line(l_filehandle, ' where BUSINESS_GROUP_ID = ' ||
680: r_migration_data.business_group_id || ');');
681: utl_file.put_line(l_filehandle, '');
682:
683: utl_file.put_line(l_filehandle, 'delete from HR_ALL_ORGANIZATION_UNITS');
684: utl_file.put_line(l_filehandle, 'where BUSINESS_GROUP_ID = ' ||
685: r_migration_data.business_group_id || ';');

Line 683: utl_file.put_line(l_filehandle, 'delete from HR_ALL_ORGANIZATION_UNITS');

679: utl_file.put_line(l_filehandle, ' where BUSINESS_GROUP_ID = ' ||
680: r_migration_data.business_group_id || ');');
681: utl_file.put_line(l_filehandle, '');
682:
683: utl_file.put_line(l_filehandle, 'delete from HR_ALL_ORGANIZATION_UNITS');
684: utl_file.put_line(l_filehandle, 'where BUSINESS_GROUP_ID = ' ||
685: r_migration_data.business_group_id || ';');
686: utl_file.put_line(l_filehandle, '');
687:

Line 684: utl_file.put_line(l_filehandle, 'where BUSINESS_GROUP_ID = ' ||

680: r_migration_data.business_group_id || ');');
681: utl_file.put_line(l_filehandle, '');
682:
683: utl_file.put_line(l_filehandle, 'delete from HR_ALL_ORGANIZATION_UNITS');
684: utl_file.put_line(l_filehandle, 'where BUSINESS_GROUP_ID = ' ||
685: r_migration_data.business_group_id || ';');
686: utl_file.put_line(l_filehandle, '');
687:
688: utl_file.put_line(l_filehandle, 'delete from HR_LOCATIONS_ALL');

Line 686: utl_file.put_line(l_filehandle, '');

682:
683: utl_file.put_line(l_filehandle, 'delete from HR_ALL_ORGANIZATION_UNITS');
684: utl_file.put_line(l_filehandle, 'where BUSINESS_GROUP_ID = ' ||
685: r_migration_data.business_group_id || ';');
686: utl_file.put_line(l_filehandle, '');
687:
688: utl_file.put_line(l_filehandle, 'delete from HR_LOCATIONS_ALL');
689: utl_file.put_line(l_filehandle, 'where BUSINESS_GROUP_ID = ' ||
690: r_migration_data.business_group_id || ';');

Line 688: utl_file.put_line(l_filehandle, 'delete from HR_LOCATIONS_ALL');

684: utl_file.put_line(l_filehandle, 'where BUSINESS_GROUP_ID = ' ||
685: r_migration_data.business_group_id || ';');
686: utl_file.put_line(l_filehandle, '');
687:
688: utl_file.put_line(l_filehandle, 'delete from HR_LOCATIONS_ALL');
689: utl_file.put_line(l_filehandle, 'where BUSINESS_GROUP_ID = ' ||
690: r_migration_data.business_group_id || ';');
691: utl_file.put_line(l_filehandle, '');
692:

Line 689: utl_file.put_line(l_filehandle, 'where BUSINESS_GROUP_ID = ' ||

685: r_migration_data.business_group_id || ';');
686: utl_file.put_line(l_filehandle, '');
687:
688: utl_file.put_line(l_filehandle, 'delete from HR_LOCATIONS_ALL');
689: utl_file.put_line(l_filehandle, 'where BUSINESS_GROUP_ID = ' ||
690: r_migration_data.business_group_id || ';');
691: utl_file.put_line(l_filehandle, '');
692:
693: utl_file.put_line(l_filehandle, '-- DM processes info');

Line 691: utl_file.put_line(l_filehandle, '');

687:
688: utl_file.put_line(l_filehandle, 'delete from HR_LOCATIONS_ALL');
689: utl_file.put_line(l_filehandle, 'where BUSINESS_GROUP_ID = ' ||
690: r_migration_data.business_group_id || ';');
691: utl_file.put_line(l_filehandle, '');
692:
693: utl_file.put_line(l_filehandle, '-- DM processes info');
694: utl_file.put_line(l_filehandle, 'delete from BEN_BATCH_PARAMETER');
695: utl_file.put_line(l_filehandle, 'where BUSINESS_GROUP_ID = ' ||

Line 693: utl_file.put_line(l_filehandle, '-- DM processes info');

689: utl_file.put_line(l_filehandle, 'where BUSINESS_GROUP_ID = ' ||
690: r_migration_data.business_group_id || ';');
691: utl_file.put_line(l_filehandle, '');
692:
693: utl_file.put_line(l_filehandle, '-- DM processes info');
694: utl_file.put_line(l_filehandle, 'delete from BEN_BATCH_PARAMETER');
695: utl_file.put_line(l_filehandle, 'where BUSINESS_GROUP_ID = ' ||
696: r_migration_data.business_group_id || ';');
697: utl_file.put_line(l_filehandle, '');

Line 694: utl_file.put_line(l_filehandle, 'delete from BEN_BATCH_PARAMETER');

690: r_migration_data.business_group_id || ';');
691: utl_file.put_line(l_filehandle, '');
692:
693: utl_file.put_line(l_filehandle, '-- DM processes info');
694: utl_file.put_line(l_filehandle, 'delete from BEN_BATCH_PARAMETER');
695: utl_file.put_line(l_filehandle, 'where BUSINESS_GROUP_ID = ' ||
696: r_migration_data.business_group_id || ';');
697: utl_file.put_line(l_filehandle, '');
698:

Line 695: utl_file.put_line(l_filehandle, 'where BUSINESS_GROUP_ID = ' ||

691: utl_file.put_line(l_filehandle, '');
692:
693: utl_file.put_line(l_filehandle, '-- DM processes info');
694: utl_file.put_line(l_filehandle, 'delete from BEN_BATCH_PARAMETER');
695: utl_file.put_line(l_filehandle, 'where BUSINESS_GROUP_ID = ' ||
696: r_migration_data.business_group_id || ';');
697: utl_file.put_line(l_filehandle, '');
698:
699: utl_file.put_line(l_filehandle, '-- misc tables');

Line 697: utl_file.put_line(l_filehandle, '');

693: utl_file.put_line(l_filehandle, '-- DM processes info');
694: utl_file.put_line(l_filehandle, 'delete from BEN_BATCH_PARAMETER');
695: utl_file.put_line(l_filehandle, 'where BUSINESS_GROUP_ID = ' ||
696: r_migration_data.business_group_id || ';');
697: utl_file.put_line(l_filehandle, '');
698:
699: utl_file.put_line(l_filehandle, '-- misc tables');
700: utl_file.put_line(l_filehandle, 'delete from BEN_EXT_CHG_EVT_LOG');
701: utl_file.put_line(l_filehandle, 'where BUSINESS_GROUP_ID = ' ||

Line 699: utl_file.put_line(l_filehandle, '-- misc tables');

695: utl_file.put_line(l_filehandle, 'where BUSINESS_GROUP_ID = ' ||
696: r_migration_data.business_group_id || ';');
697: utl_file.put_line(l_filehandle, '');
698:
699: utl_file.put_line(l_filehandle, '-- misc tables');
700: utl_file.put_line(l_filehandle, 'delete from BEN_EXT_CHG_EVT_LOG');
701: utl_file.put_line(l_filehandle, 'where BUSINESS_GROUP_ID = ' ||
702: r_migration_data.business_group_id || ';');
703: utl_file.put_line(l_filehandle, '');

Line 700: utl_file.put_line(l_filehandle, 'delete from BEN_EXT_CHG_EVT_LOG');

696: r_migration_data.business_group_id || ';');
697: utl_file.put_line(l_filehandle, '');
698:
699: utl_file.put_line(l_filehandle, '-- misc tables');
700: utl_file.put_line(l_filehandle, 'delete from BEN_EXT_CHG_EVT_LOG');
701: utl_file.put_line(l_filehandle, 'where BUSINESS_GROUP_ID = ' ||
702: r_migration_data.business_group_id || ';');
703: utl_file.put_line(l_filehandle, '');
704:

Line 701: utl_file.put_line(l_filehandle, 'where BUSINESS_GROUP_ID = ' ||

697: utl_file.put_line(l_filehandle, '');
698:
699: utl_file.put_line(l_filehandle, '-- misc tables');
700: utl_file.put_line(l_filehandle, 'delete from BEN_EXT_CHG_EVT_LOG');
701: utl_file.put_line(l_filehandle, 'where BUSINESS_GROUP_ID = ' ||
702: r_migration_data.business_group_id || ';');
703: utl_file.put_line(l_filehandle, '');
704:
705:

Line 703: utl_file.put_line(l_filehandle, '');

699: utl_file.put_line(l_filehandle, '-- misc tables');
700: utl_file.put_line(l_filehandle, 'delete from BEN_EXT_CHG_EVT_LOG');
701: utl_file.put_line(l_filehandle, 'where BUSINESS_GROUP_ID = ' ||
702: r_migration_data.business_group_id || ';');
703: utl_file.put_line(l_filehandle, '');
704:
705:
706: utl_file.put_line(l_filehandle, '-- migration info');
707: utl_file.put_line(l_filehandle, 'delete from hr_dm_migration_requests');

Line 706: utl_file.put_line(l_filehandle, '-- migration info');

702: r_migration_data.business_group_id || ';');
703: utl_file.put_line(l_filehandle, '');
704:
705:
706: utl_file.put_line(l_filehandle, '-- migration info');
707: utl_file.put_line(l_filehandle, 'delete from hr_dm_migration_requests');
708: utl_file.put_line(l_filehandle, 'where migration_id in');
709: utl_file.put_line(l_filehandle, ' (select migration_id');
710: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');

Line 707: utl_file.put_line(l_filehandle, 'delete from hr_dm_migration_requests');

703: utl_file.put_line(l_filehandle, '');
704:
705:
706: utl_file.put_line(l_filehandle, '-- migration info');
707: utl_file.put_line(l_filehandle, 'delete from hr_dm_migration_requests');
708: utl_file.put_line(l_filehandle, 'where migration_id in');
709: utl_file.put_line(l_filehandle, ' (select migration_id');
710: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
711: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||

Line 708: utl_file.put_line(l_filehandle, 'where migration_id in');

704:
705:
706: utl_file.put_line(l_filehandle, '-- migration info');
707: utl_file.put_line(l_filehandle, 'delete from hr_dm_migration_requests');
708: utl_file.put_line(l_filehandle, 'where migration_id in');
709: utl_file.put_line(l_filehandle, ' (select migration_id');
710: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
711: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
712: r_migration_data.business_group_id || ');');

Line 709: utl_file.put_line(l_filehandle, ' (select migration_id');

705:
706: utl_file.put_line(l_filehandle, '-- migration info');
707: utl_file.put_line(l_filehandle, 'delete from hr_dm_migration_requests');
708: utl_file.put_line(l_filehandle, 'where migration_id in');
709: utl_file.put_line(l_filehandle, ' (select migration_id');
710: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
711: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
712: r_migration_data.business_group_id || ');');
713: utl_file.put_line(l_filehandle, '');

Line 710: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');

706: utl_file.put_line(l_filehandle, '-- migration info');
707: utl_file.put_line(l_filehandle, 'delete from hr_dm_migration_requests');
708: utl_file.put_line(l_filehandle, 'where migration_id in');
709: utl_file.put_line(l_filehandle, ' (select migration_id');
710: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
711: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
712: r_migration_data.business_group_id || ');');
713: utl_file.put_line(l_filehandle, '');
714:

Line 711: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||

707: utl_file.put_line(l_filehandle, 'delete from hr_dm_migration_requests');
708: utl_file.put_line(l_filehandle, 'where migration_id in');
709: utl_file.put_line(l_filehandle, ' (select migration_id');
710: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
711: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
712: r_migration_data.business_group_id || ');');
713: utl_file.put_line(l_filehandle, '');
714:
715: utl_file.put_line(l_filehandle, 'delete from hr_dm_migration_ranges');

Line 713: utl_file.put_line(l_filehandle, '');

709: utl_file.put_line(l_filehandle, ' (select migration_id');
710: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
711: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
712: r_migration_data.business_group_id || ');');
713: utl_file.put_line(l_filehandle, '');
714:
715: utl_file.put_line(l_filehandle, 'delete from hr_dm_migration_ranges');
716: utl_file.put_line(l_filehandle, 'where phase_item_id in');
717: utl_file.put_line(l_filehandle, ' (select phase_item_id');

Line 715: utl_file.put_line(l_filehandle, 'delete from hr_dm_migration_ranges');

711: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
712: r_migration_data.business_group_id || ');');
713: utl_file.put_line(l_filehandle, '');
714:
715: utl_file.put_line(l_filehandle, 'delete from hr_dm_migration_ranges');
716: utl_file.put_line(l_filehandle, 'where phase_item_id in');
717: utl_file.put_line(l_filehandle, ' (select phase_item_id');
718: utl_file.put_line(l_filehandle, ' from hr_dm_phase_items');
719: utl_file.put_line(l_filehandle, ' where phase_id in');

Line 716: utl_file.put_line(l_filehandle, 'where phase_item_id in');

712: r_migration_data.business_group_id || ');');
713: utl_file.put_line(l_filehandle, '');
714:
715: utl_file.put_line(l_filehandle, 'delete from hr_dm_migration_ranges');
716: utl_file.put_line(l_filehandle, 'where phase_item_id in');
717: utl_file.put_line(l_filehandle, ' (select phase_item_id');
718: utl_file.put_line(l_filehandle, ' from hr_dm_phase_items');
719: utl_file.put_line(l_filehandle, ' where phase_id in');
720: utl_file.put_line(l_filehandle, ' (select phase_id');

Line 717: utl_file.put_line(l_filehandle, ' (select phase_item_id');

713: utl_file.put_line(l_filehandle, '');
714:
715: utl_file.put_line(l_filehandle, 'delete from hr_dm_migration_ranges');
716: utl_file.put_line(l_filehandle, 'where phase_item_id in');
717: utl_file.put_line(l_filehandle, ' (select phase_item_id');
718: utl_file.put_line(l_filehandle, ' from hr_dm_phase_items');
719: utl_file.put_line(l_filehandle, ' where phase_id in');
720: utl_file.put_line(l_filehandle, ' (select phase_id');
721: utl_file.put_line(l_filehandle, ' from hr_dm_phases');

Line 718: utl_file.put_line(l_filehandle, ' from hr_dm_phase_items');

714:
715: utl_file.put_line(l_filehandle, 'delete from hr_dm_migration_ranges');
716: utl_file.put_line(l_filehandle, 'where phase_item_id in');
717: utl_file.put_line(l_filehandle, ' (select phase_item_id');
718: utl_file.put_line(l_filehandle, ' from hr_dm_phase_items');
719: utl_file.put_line(l_filehandle, ' where phase_id in');
720: utl_file.put_line(l_filehandle, ' (select phase_id');
721: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
722: utl_file.put_line(l_filehandle, ' where migration_id in');

Line 719: utl_file.put_line(l_filehandle, ' where phase_id in');

715: utl_file.put_line(l_filehandle, 'delete from hr_dm_migration_ranges');
716: utl_file.put_line(l_filehandle, 'where phase_item_id in');
717: utl_file.put_line(l_filehandle, ' (select phase_item_id');
718: utl_file.put_line(l_filehandle, ' from hr_dm_phase_items');
719: utl_file.put_line(l_filehandle, ' where phase_id in');
720: utl_file.put_line(l_filehandle, ' (select phase_id');
721: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
722: utl_file.put_line(l_filehandle, ' where migration_id in');
723: utl_file.put_line(l_filehandle, ' (select migration_id');

Line 720: utl_file.put_line(l_filehandle, ' (select phase_id');

716: utl_file.put_line(l_filehandle, 'where phase_item_id in');
717: utl_file.put_line(l_filehandle, ' (select phase_item_id');
718: utl_file.put_line(l_filehandle, ' from hr_dm_phase_items');
719: utl_file.put_line(l_filehandle, ' where phase_id in');
720: utl_file.put_line(l_filehandle, ' (select phase_id');
721: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
722: utl_file.put_line(l_filehandle, ' where migration_id in');
723: utl_file.put_line(l_filehandle, ' (select migration_id');
724: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');

Line 721: utl_file.put_line(l_filehandle, ' from hr_dm_phases');

717: utl_file.put_line(l_filehandle, ' (select phase_item_id');
718: utl_file.put_line(l_filehandle, ' from hr_dm_phase_items');
719: utl_file.put_line(l_filehandle, ' where phase_id in');
720: utl_file.put_line(l_filehandle, ' (select phase_id');
721: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
722: utl_file.put_line(l_filehandle, ' where migration_id in');
723: utl_file.put_line(l_filehandle, ' (select migration_id');
724: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
725: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||

Line 722: utl_file.put_line(l_filehandle, ' where migration_id in');

718: utl_file.put_line(l_filehandle, ' from hr_dm_phase_items');
719: utl_file.put_line(l_filehandle, ' where phase_id in');
720: utl_file.put_line(l_filehandle, ' (select phase_id');
721: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
722: utl_file.put_line(l_filehandle, ' where migration_id in');
723: utl_file.put_line(l_filehandle, ' (select migration_id');
724: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
725: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
726: r_migration_data.business_group_id || ')));');

Line 723: utl_file.put_line(l_filehandle, ' (select migration_id');

719: utl_file.put_line(l_filehandle, ' where phase_id in');
720: utl_file.put_line(l_filehandle, ' (select phase_id');
721: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
722: utl_file.put_line(l_filehandle, ' where migration_id in');
723: utl_file.put_line(l_filehandle, ' (select migration_id');
724: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
725: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
726: r_migration_data.business_group_id || ')));');
727: utl_file.put_line(l_filehandle, '');

Line 724: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');

720: utl_file.put_line(l_filehandle, ' (select phase_id');
721: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
722: utl_file.put_line(l_filehandle, ' where migration_id in');
723: utl_file.put_line(l_filehandle, ' (select migration_id');
724: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
725: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
726: r_migration_data.business_group_id || ')));');
727: utl_file.put_line(l_filehandle, '');
728:

Line 725: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||

721: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
722: utl_file.put_line(l_filehandle, ' where migration_id in');
723: utl_file.put_line(l_filehandle, ' (select migration_id');
724: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
725: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
726: r_migration_data.business_group_id || ')));');
727: utl_file.put_line(l_filehandle, '');
728:
729: utl_file.put_line(l_filehandle, 'delete from hr_dm_phase_items');

Line 727: utl_file.put_line(l_filehandle, '');

723: utl_file.put_line(l_filehandle, ' (select migration_id');
724: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
725: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
726: r_migration_data.business_group_id || ')));');
727: utl_file.put_line(l_filehandle, '');
728:
729: utl_file.put_line(l_filehandle, 'delete from hr_dm_phase_items');
730: utl_file.put_line(l_filehandle, 'where phase_item_id in');
731: utl_file.put_line(l_filehandle, ' (select phase_item_id');

Line 729: utl_file.put_line(l_filehandle, 'delete from hr_dm_phase_items');

725: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
726: r_migration_data.business_group_id || ')));');
727: utl_file.put_line(l_filehandle, '');
728:
729: utl_file.put_line(l_filehandle, 'delete from hr_dm_phase_items');
730: utl_file.put_line(l_filehandle, 'where phase_item_id in');
731: utl_file.put_line(l_filehandle, ' (select phase_item_id');
732: utl_file.put_line(l_filehandle, ' from hr_dm_phase_items');
733: utl_file.put_line(l_filehandle, ' where phase_id in');

Line 730: utl_file.put_line(l_filehandle, 'where phase_item_id in');

726: r_migration_data.business_group_id || ')));');
727: utl_file.put_line(l_filehandle, '');
728:
729: utl_file.put_line(l_filehandle, 'delete from hr_dm_phase_items');
730: utl_file.put_line(l_filehandle, 'where phase_item_id in');
731: utl_file.put_line(l_filehandle, ' (select phase_item_id');
732: utl_file.put_line(l_filehandle, ' from hr_dm_phase_items');
733: utl_file.put_line(l_filehandle, ' where phase_id in');
734: utl_file.put_line(l_filehandle, ' (select phase_id');

Line 731: utl_file.put_line(l_filehandle, ' (select phase_item_id');

727: utl_file.put_line(l_filehandle, '');
728:
729: utl_file.put_line(l_filehandle, 'delete from hr_dm_phase_items');
730: utl_file.put_line(l_filehandle, 'where phase_item_id in');
731: utl_file.put_line(l_filehandle, ' (select phase_item_id');
732: utl_file.put_line(l_filehandle, ' from hr_dm_phase_items');
733: utl_file.put_line(l_filehandle, ' where phase_id in');
734: utl_file.put_line(l_filehandle, ' (select phase_id');
735: utl_file.put_line(l_filehandle, ' from hr_dm_phases');

Line 732: utl_file.put_line(l_filehandle, ' from hr_dm_phase_items');

728:
729: utl_file.put_line(l_filehandle, 'delete from hr_dm_phase_items');
730: utl_file.put_line(l_filehandle, 'where phase_item_id in');
731: utl_file.put_line(l_filehandle, ' (select phase_item_id');
732: utl_file.put_line(l_filehandle, ' from hr_dm_phase_items');
733: utl_file.put_line(l_filehandle, ' where phase_id in');
734: utl_file.put_line(l_filehandle, ' (select phase_id');
735: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
736: utl_file.put_line(l_filehandle, ' where migration_id in');

Line 733: utl_file.put_line(l_filehandle, ' where phase_id in');

729: utl_file.put_line(l_filehandle, 'delete from hr_dm_phase_items');
730: utl_file.put_line(l_filehandle, 'where phase_item_id in');
731: utl_file.put_line(l_filehandle, ' (select phase_item_id');
732: utl_file.put_line(l_filehandle, ' from hr_dm_phase_items');
733: utl_file.put_line(l_filehandle, ' where phase_id in');
734: utl_file.put_line(l_filehandle, ' (select phase_id');
735: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
736: utl_file.put_line(l_filehandle, ' where migration_id in');
737: utl_file.put_line(l_filehandle, ' (select migration_id');

Line 734: utl_file.put_line(l_filehandle, ' (select phase_id');

730: utl_file.put_line(l_filehandle, 'where phase_item_id in');
731: utl_file.put_line(l_filehandle, ' (select phase_item_id');
732: utl_file.put_line(l_filehandle, ' from hr_dm_phase_items');
733: utl_file.put_line(l_filehandle, ' where phase_id in');
734: utl_file.put_line(l_filehandle, ' (select phase_id');
735: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
736: utl_file.put_line(l_filehandle, ' where migration_id in');
737: utl_file.put_line(l_filehandle, ' (select migration_id');
738: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');

Line 735: utl_file.put_line(l_filehandle, ' from hr_dm_phases');

731: utl_file.put_line(l_filehandle, ' (select phase_item_id');
732: utl_file.put_line(l_filehandle, ' from hr_dm_phase_items');
733: utl_file.put_line(l_filehandle, ' where phase_id in');
734: utl_file.put_line(l_filehandle, ' (select phase_id');
735: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
736: utl_file.put_line(l_filehandle, ' where migration_id in');
737: utl_file.put_line(l_filehandle, ' (select migration_id');
738: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
739: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||

Line 736: utl_file.put_line(l_filehandle, ' where migration_id in');

732: utl_file.put_line(l_filehandle, ' from hr_dm_phase_items');
733: utl_file.put_line(l_filehandle, ' where phase_id in');
734: utl_file.put_line(l_filehandle, ' (select phase_id');
735: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
736: utl_file.put_line(l_filehandle, ' where migration_id in');
737: utl_file.put_line(l_filehandle, ' (select migration_id');
738: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
739: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
740: r_migration_data.business_group_id || ')));');

Line 737: utl_file.put_line(l_filehandle, ' (select migration_id');

733: utl_file.put_line(l_filehandle, ' where phase_id in');
734: utl_file.put_line(l_filehandle, ' (select phase_id');
735: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
736: utl_file.put_line(l_filehandle, ' where migration_id in');
737: utl_file.put_line(l_filehandle, ' (select migration_id');
738: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
739: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
740: r_migration_data.business_group_id || ')));');
741: utl_file.put_line(l_filehandle, '');

Line 738: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');

734: utl_file.put_line(l_filehandle, ' (select phase_id');
735: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
736: utl_file.put_line(l_filehandle, ' where migration_id in');
737: utl_file.put_line(l_filehandle, ' (select migration_id');
738: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
739: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
740: r_migration_data.business_group_id || ')));');
741: utl_file.put_line(l_filehandle, '');
742:

Line 739: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||

735: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
736: utl_file.put_line(l_filehandle, ' where migration_id in');
737: utl_file.put_line(l_filehandle, ' (select migration_id');
738: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
739: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
740: r_migration_data.business_group_id || ')));');
741: utl_file.put_line(l_filehandle, '');
742:
743: utl_file.put_line(l_filehandle, 'delete from hr_dm_phases');

Line 741: utl_file.put_line(l_filehandle, '');

737: utl_file.put_line(l_filehandle, ' (select migration_id');
738: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
739: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
740: r_migration_data.business_group_id || ')));');
741: utl_file.put_line(l_filehandle, '');
742:
743: utl_file.put_line(l_filehandle, 'delete from hr_dm_phases');
744: utl_file.put_line(l_filehandle, 'where phase_id in');
745: utl_file.put_line(l_filehandle, ' (select phase_id');

Line 743: utl_file.put_line(l_filehandle, 'delete from hr_dm_phases');

739: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
740: r_migration_data.business_group_id || ')));');
741: utl_file.put_line(l_filehandle, '');
742:
743: utl_file.put_line(l_filehandle, 'delete from hr_dm_phases');
744: utl_file.put_line(l_filehandle, 'where phase_id in');
745: utl_file.put_line(l_filehandle, ' (select phase_id');
746: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
747: utl_file.put_line(l_filehandle, ' where migration_id in');

Line 744: utl_file.put_line(l_filehandle, 'where phase_id in');

740: r_migration_data.business_group_id || ')));');
741: utl_file.put_line(l_filehandle, '');
742:
743: utl_file.put_line(l_filehandle, 'delete from hr_dm_phases');
744: utl_file.put_line(l_filehandle, 'where phase_id in');
745: utl_file.put_line(l_filehandle, ' (select phase_id');
746: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
747: utl_file.put_line(l_filehandle, ' where migration_id in');
748: utl_file.put_line(l_filehandle, ' (select migration_id');

Line 745: utl_file.put_line(l_filehandle, ' (select phase_id');

741: utl_file.put_line(l_filehandle, '');
742:
743: utl_file.put_line(l_filehandle, 'delete from hr_dm_phases');
744: utl_file.put_line(l_filehandle, 'where phase_id in');
745: utl_file.put_line(l_filehandle, ' (select phase_id');
746: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
747: utl_file.put_line(l_filehandle, ' where migration_id in');
748: utl_file.put_line(l_filehandle, ' (select migration_id');
749: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');

Line 746: utl_file.put_line(l_filehandle, ' from hr_dm_phases');

742:
743: utl_file.put_line(l_filehandle, 'delete from hr_dm_phases');
744: utl_file.put_line(l_filehandle, 'where phase_id in');
745: utl_file.put_line(l_filehandle, ' (select phase_id');
746: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
747: utl_file.put_line(l_filehandle, ' where migration_id in');
748: utl_file.put_line(l_filehandle, ' (select migration_id');
749: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
750: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||

Line 747: utl_file.put_line(l_filehandle, ' where migration_id in');

743: utl_file.put_line(l_filehandle, 'delete from hr_dm_phases');
744: utl_file.put_line(l_filehandle, 'where phase_id in');
745: utl_file.put_line(l_filehandle, ' (select phase_id');
746: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
747: utl_file.put_line(l_filehandle, ' where migration_id in');
748: utl_file.put_line(l_filehandle, ' (select migration_id');
749: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
750: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
751: r_migration_data.business_group_id || '));');

Line 748: utl_file.put_line(l_filehandle, ' (select migration_id');

744: utl_file.put_line(l_filehandle, 'where phase_id in');
745: utl_file.put_line(l_filehandle, ' (select phase_id');
746: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
747: utl_file.put_line(l_filehandle, ' where migration_id in');
748: utl_file.put_line(l_filehandle, ' (select migration_id');
749: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
750: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
751: r_migration_data.business_group_id || '));');
752: utl_file.put_line(l_filehandle, '');

Line 749: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');

745: utl_file.put_line(l_filehandle, ' (select phase_id');
746: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
747: utl_file.put_line(l_filehandle, ' where migration_id in');
748: utl_file.put_line(l_filehandle, ' (select migration_id');
749: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
750: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
751: r_migration_data.business_group_id || '));');
752: utl_file.put_line(l_filehandle, '');
753:

Line 750: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||

746: utl_file.put_line(l_filehandle, ' from hr_dm_phases');
747: utl_file.put_line(l_filehandle, ' where migration_id in');
748: utl_file.put_line(l_filehandle, ' (select migration_id');
749: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
750: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
751: r_migration_data.business_group_id || '));');
752: utl_file.put_line(l_filehandle, '');
753:
754: utl_file.put_line(l_filehandle, 'delete from hr_dm_migrations');

Line 752: utl_file.put_line(l_filehandle, '');

748: utl_file.put_line(l_filehandle, ' (select migration_id');
749: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
750: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
751: r_migration_data.business_group_id || '));');
752: utl_file.put_line(l_filehandle, '');
753:
754: utl_file.put_line(l_filehandle, 'delete from hr_dm_migrations');
755: utl_file.put_line(l_filehandle, 'where migration_id in');
756: utl_file.put_line(l_filehandle, ' (select migration_id');

Line 754: utl_file.put_line(l_filehandle, 'delete from hr_dm_migrations');

750: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
751: r_migration_data.business_group_id || '));');
752: utl_file.put_line(l_filehandle, '');
753:
754: utl_file.put_line(l_filehandle, 'delete from hr_dm_migrations');
755: utl_file.put_line(l_filehandle, 'where migration_id in');
756: utl_file.put_line(l_filehandle, ' (select migration_id');
757: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
758: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||

Line 755: utl_file.put_line(l_filehandle, 'where migration_id in');

751: r_migration_data.business_group_id || '));');
752: utl_file.put_line(l_filehandle, '');
753:
754: utl_file.put_line(l_filehandle, 'delete from hr_dm_migrations');
755: utl_file.put_line(l_filehandle, 'where migration_id in');
756: utl_file.put_line(l_filehandle, ' (select migration_id');
757: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
758: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
759: r_migration_data.business_group_id || ');');

Line 756: utl_file.put_line(l_filehandle, ' (select migration_id');

752: utl_file.put_line(l_filehandle, '');
753:
754: utl_file.put_line(l_filehandle, 'delete from hr_dm_migrations');
755: utl_file.put_line(l_filehandle, 'where migration_id in');
756: utl_file.put_line(l_filehandle, ' (select migration_id');
757: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
758: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
759: r_migration_data.business_group_id || ');');
760: utl_file.put_line(l_filehandle, '');

Line 757: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');

753:
754: utl_file.put_line(l_filehandle, 'delete from hr_dm_migrations');
755: utl_file.put_line(l_filehandle, 'where migration_id in');
756: utl_file.put_line(l_filehandle, ' (select migration_id');
757: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
758: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
759: r_migration_data.business_group_id || ');');
760: utl_file.put_line(l_filehandle, '');
761:

Line 758: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||

754: utl_file.put_line(l_filehandle, 'delete from hr_dm_migrations');
755: utl_file.put_line(l_filehandle, 'where migration_id in');
756: utl_file.put_line(l_filehandle, ' (select migration_id');
757: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
758: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
759: r_migration_data.business_group_id || ');');
760: utl_file.put_line(l_filehandle, '');
761:
762:

Line 760: utl_file.put_line(l_filehandle, '');

756: utl_file.put_line(l_filehandle, ' (select migration_id');
757: utl_file.put_line(l_filehandle, ' from hr_dm_migrations');
758: utl_file.put_line(l_filehandle, ' where business_group_id = ' ||
759: r_migration_data.business_group_id || ');');
760: utl_file.put_line(l_filehandle, '');
761:
762:
763: utl_file.put_line(l_filehandle, '--');
764: utl_file.put_line(l_filehandle, 'END;');

Line 763: utl_file.put_line(l_filehandle, '--');

759: r_migration_data.business_group_id || ');');
760: utl_file.put_line(l_filehandle, '');
761:
762:
763: utl_file.put_line(l_filehandle, '--');
764: utl_file.put_line(l_filehandle, 'END;');
765: utl_file.put_line(l_filehandle, '--');
766: utl_file.put_line(l_filehandle, '/');
767: utl_file.put_line(l_filehandle, 'COMMIT;');

Line 764: utl_file.put_line(l_filehandle, 'END;');

760: utl_file.put_line(l_filehandle, '');
761:
762:
763: utl_file.put_line(l_filehandle, '--');
764: utl_file.put_line(l_filehandle, 'END;');
765: utl_file.put_line(l_filehandle, '--');
766: utl_file.put_line(l_filehandle, '/');
767: utl_file.put_line(l_filehandle, 'COMMIT;');
768: utl_file.put_line(l_filehandle, 'EXIT;');

Line 765: utl_file.put_line(l_filehandle, '--');

761:
762:
763: utl_file.put_line(l_filehandle, '--');
764: utl_file.put_line(l_filehandle, 'END;');
765: utl_file.put_line(l_filehandle, '--');
766: utl_file.put_line(l_filehandle, '/');
767: utl_file.put_line(l_filehandle, 'COMMIT;');
768: utl_file.put_line(l_filehandle, 'EXIT;');
769:

Line 766: utl_file.put_line(l_filehandle, '/');

762:
763: utl_file.put_line(l_filehandle, '--');
764: utl_file.put_line(l_filehandle, 'END;');
765: utl_file.put_line(l_filehandle, '--');
766: utl_file.put_line(l_filehandle, '/');
767: utl_file.put_line(l_filehandle, 'COMMIT;');
768: utl_file.put_line(l_filehandle, 'EXIT;');
769:
770:

Line 767: utl_file.put_line(l_filehandle, 'COMMIT;');

763: utl_file.put_line(l_filehandle, '--');
764: utl_file.put_line(l_filehandle, 'END;');
765: utl_file.put_line(l_filehandle, '--');
766: utl_file.put_line(l_filehandle, '/');
767: utl_file.put_line(l_filehandle, 'COMMIT;');
768: utl_file.put_line(l_filehandle, 'EXIT;');
769:
770:
771: -- close file

Line 768: utl_file.put_line(l_filehandle, 'EXIT;');

764: utl_file.put_line(l_filehandle, 'END;');
765: utl_file.put_line(l_filehandle, '--');
766: utl_file.put_line(l_filehandle, '/');
767: utl_file.put_line(l_filehandle, 'COMMIT;');
768: utl_file.put_line(l_filehandle, 'EXIT;');
769:
770:
771: -- close file
772: utl_file.fclose(l_filehandle);

Line 772: utl_file.fclose(l_filehandle);

768: utl_file.put_line(l_filehandle, 'EXIT;');
769:
770:
771: -- close file
772: utl_file.fclose(l_filehandle);
773:
774:
775:
776: hr_dm_utility.message('INFO','Delete - cleanup script', 15);