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_AOL_UP dependencies on UTL_FILE

Line 38: p_file_handle IN UTL_FILE.FILE_TYPE

34: --
35: PROCEDURE add_details(p_migration_id IN NUMBER,
36: p_phase_id IN NUMBER,
37: p_phase_item_id IN NUMBER,
38: p_file_handle IN UTL_FILE.FILE_TYPE
39: ) IS
40: --
41:
42: l_loader_name VARCHAR2(30);

Line 288: utl_file.put_line(p_file_handle, l_string);

284: l_parameter9 || ' ' ||
285: l_parameter10;
286:
287:
288: utl_file.put_line(p_file_handle, l_string);
289:
290: hr_dm_utility.message('INFO','Added UA entry', 115);
291: hr_dm_utility.message('SUMM','Added UA entry', 120);
292: hr_dm_utility.message('ROUT','exit:hr_dm_aol_up.add_details', 125);

Line 503: l_filehandle UTL_FILE.FILE_TYPE;

499: l_phase_item_id NUMBER;
500: l_phase VARCHAR2(30);
501: l_location VARCHAR2(2000);
502: l_aol_filename VARCHAR2(30);
503: l_filehandle UTL_FILE.FILE_TYPE;
504: l_sysdate VARCHAR2(30);
505: l_destination_database VARCHAR2(30);
506: l_loader_group VARCHAR2(30);
507: l_source_db VARCHAR2(30);

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

582:
583:
584:
585: -- find logfile directory and open file for AOL Loader commands
586: fnd_profile.get('UTL_FILE_LOG', l_location);
587: l_aol_filename := 'DM' || p_migration_id || '.txt';
588: hr_dm_utility.message('INFO','l_location ' || l_location, 13);
589: hr_dm_utility.message('INFO','l_aol_filename ' || l_aol_filename, 13);
590:

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

596: RAISE e_fatal_error2;
597: END IF;
598:
599: hr_dm_utility.message('INFO','Opening file', 13);
600: l_filehandle := utl_file.fopen(l_location, l_aol_filename, 'w');
601: hr_dm_utility.message('INFO','File opened ', 13);
602:
603: -- get migration info
604: OPEN csr_mig_info;

Line 617: utl_file.put_line(l_filehandle, '# Data Migrator AOL Upload');

613: CLOSE csr_mig_info;
614:
615:
616: -- add header info
617: utl_file.put_line(l_filehandle, '# Data Migrator AOL Upload');
618: utl_file.put_line(l_filehandle, '# ');
619: utl_file.put_line(l_filehandle, '# ');
620: utl_file.put_line(l_filehandle, '# Migration Information:');
621: utl_file.put_line(l_filehandle, '# ');

Line 618: utl_file.put_line(l_filehandle, '# ');

614:
615:
616: -- add header info
617: utl_file.put_line(l_filehandle, '# Data Migrator AOL Upload');
618: utl_file.put_line(l_filehandle, '# ');
619: utl_file.put_line(l_filehandle, '# ');
620: utl_file.put_line(l_filehandle, '# Migration Information:');
621: utl_file.put_line(l_filehandle, '# ');
622: utl_file.put_line(l_filehandle, '# Migration ID ' || p_migration_id);

Line 619: utl_file.put_line(l_filehandle, '# ');

615:
616: -- add header info
617: utl_file.put_line(l_filehandle, '# Data Migrator AOL Upload');
618: utl_file.put_line(l_filehandle, '# ');
619: utl_file.put_line(l_filehandle, '# ');
620: utl_file.put_line(l_filehandle, '# Migration Information:');
621: utl_file.put_line(l_filehandle, '# ');
622: utl_file.put_line(l_filehandle, '# Migration ID ' || p_migration_id);
623: SELECT to_char(sysdate,'HH:MI DD-MON-YYYY')

Line 620: utl_file.put_line(l_filehandle, '# Migration Information:');

616: -- add header info
617: utl_file.put_line(l_filehandle, '# Data Migrator AOL Upload');
618: utl_file.put_line(l_filehandle, '# ');
619: utl_file.put_line(l_filehandle, '# ');
620: utl_file.put_line(l_filehandle, '# Migration Information:');
621: utl_file.put_line(l_filehandle, '# ');
622: utl_file.put_line(l_filehandle, '# Migration ID ' || p_migration_id);
623: SELECT to_char(sysdate,'HH:MI DD-MON-YYYY')
624: INTO l_sysdate

Line 621: utl_file.put_line(l_filehandle, '# ');

617: utl_file.put_line(l_filehandle, '# Data Migrator AOL Upload');
618: utl_file.put_line(l_filehandle, '# ');
619: utl_file.put_line(l_filehandle, '# ');
620: utl_file.put_line(l_filehandle, '# Migration Information:');
621: utl_file.put_line(l_filehandle, '# ');
622: utl_file.put_line(l_filehandle, '# Migration ID ' || p_migration_id);
623: SELECT to_char(sysdate,'HH:MI DD-MON-YYYY')
624: INTO l_sysdate
625: FROM dual;

Line 622: utl_file.put_line(l_filehandle, '# Migration ID ' || p_migration_id);

618: utl_file.put_line(l_filehandle, '# ');
619: utl_file.put_line(l_filehandle, '# ');
620: utl_file.put_line(l_filehandle, '# Migration Information:');
621: utl_file.put_line(l_filehandle, '# ');
622: utl_file.put_line(l_filehandle, '# Migration ID ' || p_migration_id);
623: SELECT to_char(sysdate,'HH:MI DD-MON-YYYY')
624: INTO l_sysdate
625: FROM dual;
626: utl_file.put_line(l_filehandle, '# Date ' || l_sysdate);

Line 626: utl_file.put_line(l_filehandle, '# Date ' || l_sysdate);

622: utl_file.put_line(l_filehandle, '# Migration ID ' || p_migration_id);
623: SELECT to_char(sysdate,'HH:MI DD-MON-YYYY')
624: INTO l_sysdate
625: FROM dual;
626: utl_file.put_line(l_filehandle, '# Date ' || l_sysdate);
627:
628: utl_file.put_line(l_filehandle, '# Source Database ' || l_source_db);
629: utl_file.put_line(l_filehandle, '# Destination Database ' || l_destination_db);
630: utl_file.put_line(l_filehandle, '# Migration Type (code) ' || l_migration_type);

Line 628: utl_file.put_line(l_filehandle, '# Source Database ' || l_source_db);

624: INTO l_sysdate
625: FROM dual;
626: utl_file.put_line(l_filehandle, '# Date ' || l_sysdate);
627:
628: utl_file.put_line(l_filehandle, '# Source Database ' || l_source_db);
629: utl_file.put_line(l_filehandle, '# Destination Database ' || l_destination_db);
630: utl_file.put_line(l_filehandle, '# Migration Type (code) ' || l_migration_type);
631: utl_file.put_line(l_filehandle, '# Migration Type ' || l_migration_type_meaning);
632: utl_file.put_line(l_filehandle, '# Business Group ID ' || l_business_group_id);

Line 629: utl_file.put_line(l_filehandle, '# Destination Database ' || l_destination_db);

625: FROM dual;
626: utl_file.put_line(l_filehandle, '# Date ' || l_sysdate);
627:
628: utl_file.put_line(l_filehandle, '# Source Database ' || l_source_db);
629: utl_file.put_line(l_filehandle, '# Destination Database ' || l_destination_db);
630: utl_file.put_line(l_filehandle, '# Migration Type (code) ' || l_migration_type);
631: utl_file.put_line(l_filehandle, '# Migration Type ' || l_migration_type_meaning);
632: utl_file.put_line(l_filehandle, '# Business Group ID ' || l_business_group_id);
633: utl_file.put_line(l_filehandle, '# Business Group Name ' || l_business_group_name);

Line 630: utl_file.put_line(l_filehandle, '# Migration Type (code) ' || l_migration_type);

626: utl_file.put_line(l_filehandle, '# Date ' || l_sysdate);
627:
628: utl_file.put_line(l_filehandle, '# Source Database ' || l_source_db);
629: utl_file.put_line(l_filehandle, '# Destination Database ' || l_destination_db);
630: utl_file.put_line(l_filehandle, '# Migration Type (code) ' || l_migration_type);
631: utl_file.put_line(l_filehandle, '# Migration Type ' || l_migration_type_meaning);
632: utl_file.put_line(l_filehandle, '# Business Group ID ' || l_business_group_id);
633: utl_file.put_line(l_filehandle, '# Business Group Name ' || l_business_group_name);
634: utl_file.put_line(l_filehandle, '# Selective Migration Criteria');

Line 631: utl_file.put_line(l_filehandle, '# Migration Type ' || l_migration_type_meaning);

627:
628: utl_file.put_line(l_filehandle, '# Source Database ' || l_source_db);
629: utl_file.put_line(l_filehandle, '# Destination Database ' || l_destination_db);
630: utl_file.put_line(l_filehandle, '# Migration Type (code) ' || l_migration_type);
631: utl_file.put_line(l_filehandle, '# Migration Type ' || l_migration_type_meaning);
632: utl_file.put_line(l_filehandle, '# Business Group ID ' || l_business_group_id);
633: utl_file.put_line(l_filehandle, '# Business Group Name ' || l_business_group_name);
634: utl_file.put_line(l_filehandle, '# Selective Migration Criteria');
635: utl_file.put_line(l_filehandle, '# ' ||

Line 632: utl_file.put_line(l_filehandle, '# Business Group ID ' || l_business_group_id);

628: utl_file.put_line(l_filehandle, '# Source Database ' || l_source_db);
629: utl_file.put_line(l_filehandle, '# Destination Database ' || l_destination_db);
630: utl_file.put_line(l_filehandle, '# Migration Type (code) ' || l_migration_type);
631: utl_file.put_line(l_filehandle, '# Migration Type ' || l_migration_type_meaning);
632: utl_file.put_line(l_filehandle, '# Business Group ID ' || l_business_group_id);
633: utl_file.put_line(l_filehandle, '# Business Group Name ' || l_business_group_name);
634: utl_file.put_line(l_filehandle, '# Selective Migration Criteria');
635: utl_file.put_line(l_filehandle, '# ' ||
636: NVL(SUBSTR(l_selective_mc,1,240),'(Not Applicable)'));

Line 633: utl_file.put_line(l_filehandle, '# Business Group Name ' || l_business_group_name);

629: utl_file.put_line(l_filehandle, '# Destination Database ' || l_destination_db);
630: utl_file.put_line(l_filehandle, '# Migration Type (code) ' || l_migration_type);
631: utl_file.put_line(l_filehandle, '# Migration Type ' || l_migration_type_meaning);
632: utl_file.put_line(l_filehandle, '# Business Group ID ' || l_business_group_id);
633: utl_file.put_line(l_filehandle, '# Business Group Name ' || l_business_group_name);
634: utl_file.put_line(l_filehandle, '# Selective Migration Criteria');
635: utl_file.put_line(l_filehandle, '# ' ||
636: NVL(SUBSTR(l_selective_mc,1,240),'(Not Applicable)'));
637:

Line 634: utl_file.put_line(l_filehandle, '# Selective Migration Criteria');

630: utl_file.put_line(l_filehandle, '# Migration Type (code) ' || l_migration_type);
631: utl_file.put_line(l_filehandle, '# Migration Type ' || l_migration_type_meaning);
632: utl_file.put_line(l_filehandle, '# Business Group ID ' || l_business_group_id);
633: utl_file.put_line(l_filehandle, '# Business Group Name ' || l_business_group_name);
634: utl_file.put_line(l_filehandle, '# Selective Migration Criteria');
635: utl_file.put_line(l_filehandle, '# ' ||
636: NVL(SUBSTR(l_selective_mc,1,240),'(Not Applicable)'));
637:
638: utl_file.put_line(l_filehandle, '# ');

Line 635: utl_file.put_line(l_filehandle, '# ' ||

631: utl_file.put_line(l_filehandle, '# Migration Type ' || l_migration_type_meaning);
632: utl_file.put_line(l_filehandle, '# Business Group ID ' || l_business_group_id);
633: utl_file.put_line(l_filehandle, '# Business Group Name ' || l_business_group_name);
634: utl_file.put_line(l_filehandle, '# Selective Migration Criteria');
635: utl_file.put_line(l_filehandle, '# ' ||
636: NVL(SUBSTR(l_selective_mc,1,240),'(Not Applicable)'));
637:
638: utl_file.put_line(l_filehandle, '# ');
639: utl_file.put_line(l_filehandle, '# ');

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

634: utl_file.put_line(l_filehandle, '# Selective Migration Criteria');
635: utl_file.put_line(l_filehandle, '# ' ||
636: NVL(SUBSTR(l_selective_mc,1,240),'(Not Applicable)'));
637:
638: utl_file.put_line(l_filehandle, '# ');
639: utl_file.put_line(l_filehandle, '# ');
640: utl_file.put_line(l_filehandle, '# AOL Loader commands:');
641: utl_file.put_line(l_filehandle, '# Replace apps/apps with the appropriate values.');
642: utl_file.put_line(l_filehandle, '# ');

Line 639: utl_file.put_line(l_filehandle, '# ');

635: utl_file.put_line(l_filehandle, '# ' ||
636: NVL(SUBSTR(l_selective_mc,1,240),'(Not Applicable)'));
637:
638: utl_file.put_line(l_filehandle, '# ');
639: utl_file.put_line(l_filehandle, '# ');
640: utl_file.put_line(l_filehandle, '# AOL Loader commands:');
641: utl_file.put_line(l_filehandle, '# Replace apps/apps with the appropriate values.');
642: utl_file.put_line(l_filehandle, '# ');
643:

Line 640: utl_file.put_line(l_filehandle, '# AOL Loader commands:');

636: NVL(SUBSTR(l_selective_mc,1,240),'(Not Applicable)'));
637:
638: utl_file.put_line(l_filehandle, '# ');
639: utl_file.put_line(l_filehandle, '# ');
640: utl_file.put_line(l_filehandle, '# AOL Loader commands:');
641: utl_file.put_line(l_filehandle, '# Replace apps/apps with the appropriate values.');
642: utl_file.put_line(l_filehandle, '# ');
643:
644:

Line 641: utl_file.put_line(l_filehandle, '# Replace apps/apps with the appropriate values.');

637:
638: utl_file.put_line(l_filehandle, '# ');
639: utl_file.put_line(l_filehandle, '# ');
640: utl_file.put_line(l_filehandle, '# AOL Loader commands:');
641: utl_file.put_line(l_filehandle, '# Replace apps/apps with the appropriate values.');
642: utl_file.put_line(l_filehandle, '# ');
643:
644:
645: -- loop around all groups

Line 642: utl_file.put_line(l_filehandle, '# ');

638: utl_file.put_line(l_filehandle, '# ');
639: utl_file.put_line(l_filehandle, '# ');
640: utl_file.put_line(l_filehandle, '# AOL Loader commands:');
641: utl_file.put_line(l_filehandle, '# Replace apps/apps with the appropriate values.');
642: utl_file.put_line(l_filehandle, '# ');
643:
644:
645: -- loop around all groups
646: OPEN csr_loader;

Line 655: utl_file.put_line(l_filehandle, '# ');

651: -- send info on current table to logfile
652: hr_dm_utility.message('INFO','Processing - ' || l_loader_group, 13);
653:
654: -- show start of group
655: utl_file.put_line(l_filehandle, '# ');
656: utl_file.put_line(l_filehandle, '# <' || l_loader_group || '>');
657: utl_file.put_line(l_filehandle, '# ');
658:
659:

Line 656: utl_file.put_line(l_filehandle, '# <' || l_loader_group || '>');

652: hr_dm_utility.message('INFO','Processing - ' || l_loader_group, 13);
653:
654: -- show start of group
655: utl_file.put_line(l_filehandle, '# ');
656: utl_file.put_line(l_filehandle, '# <' || l_loader_group || '>');
657: utl_file.put_line(l_filehandle, '# ');
658:
659:
660: -- process each group

Line 657: utl_file.put_line(l_filehandle, '# ');

653:
654: -- show start of group
655: utl_file.put_line(l_filehandle, '# ');
656: utl_file.put_line(l_filehandle, '# <' || l_loader_group || '>');
657: utl_file.put_line(l_filehandle, '# ');
658:
659:
660: -- process each group
661: OPEN csr_get_pi;

Line 689: utl_file.put_line(l_filehandle, '# ');

685: CLOSE csr_get_pi;
686:
687:
688: -- show end of group
689: utl_file.put_line(l_filehandle, '# ');
690: utl_file.put_line(l_filehandle, '# ');
691: utl_file.put_line(l_filehandle, '# ');
692:
693: END LOOP;

Line 690: utl_file.put_line(l_filehandle, '# ');

686:
687:
688: -- show end of group
689: utl_file.put_line(l_filehandle, '# ');
690: utl_file.put_line(l_filehandle, '# ');
691: utl_file.put_line(l_filehandle, '# ');
692:
693: END LOOP;
694: CLOSE csr_loader;

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

687:
688: -- show end of group
689: utl_file.put_line(l_filehandle, '# ');
690: utl_file.put_line(l_filehandle, '# ');
691: utl_file.put_line(l_filehandle, '# ');
692:
693: END LOOP;
694: CLOSE csr_loader;
695:

Line 698: utl_file.put_line(l_filehandle, '# ');

694: CLOSE csr_loader;
695:
696:
697:
698: utl_file.put_line(l_filehandle, '# ');
699: utl_file.put_line(l_filehandle, '# End of AOL Uploader commands.');
700: utl_file.put_line(l_filehandle, '# ');
701:
702:

Line 699: utl_file.put_line(l_filehandle, '# End of AOL Uploader commands.');

695:
696:
697:
698: utl_file.put_line(l_filehandle, '# ');
699: utl_file.put_line(l_filehandle, '# End of AOL Uploader commands.');
700: utl_file.put_line(l_filehandle, '# ');
701:
702:
703: -- get the destination database name

Line 700: utl_file.put_line(l_filehandle, '# ');

696:
697:
698: utl_file.put_line(l_filehandle, '# ');
699: utl_file.put_line(l_filehandle, '# End of AOL Uploader commands.');
700: utl_file.put_line(l_filehandle, '# ');
701:
702:
703: -- get the destination database name
704: SELECT DESTINATION_DATABASE_INSTANCE

Line 710: utl_file.put_line(l_filehandle, '# Taskflow upload commands');

706: FROM HR_DM_MIGRATIONS
707: WHERE migration_id = p_migration_id;
708:
709:
710: utl_file.put_line(l_filehandle, '# Taskflow upload commands');
711: utl_file.put_line(l_filehandle, '# ');
712: utl_file.put_line(l_filehandle, 'sqlplus apps/apps@' || l_destination_database ||
713: ' @hrwkflow.sql');
714: utl_file.put_line(l_filehandle, 'sqlplus apps/apps@' || l_destination_database ||

Line 711: utl_file.put_line(l_filehandle, '# ');

707: WHERE migration_id = p_migration_id;
708:
709:
710: utl_file.put_line(l_filehandle, '# Taskflow upload commands');
711: utl_file.put_line(l_filehandle, '# ');
712: utl_file.put_line(l_filehandle, 'sqlplus apps/apps@' || l_destination_database ||
713: ' @hrwkflow.sql');
714: utl_file.put_line(l_filehandle, 'sqlplus apps/apps@' || l_destination_database ||
715: ' @usrwkflw.sql');

Line 712: utl_file.put_line(l_filehandle, 'sqlplus apps/apps@' || l_destination_database ||

708:
709:
710: utl_file.put_line(l_filehandle, '# Taskflow upload commands');
711: utl_file.put_line(l_filehandle, '# ');
712: utl_file.put_line(l_filehandle, 'sqlplus apps/apps@' || l_destination_database ||
713: ' @hrwkflow.sql');
714: utl_file.put_line(l_filehandle, 'sqlplus apps/apps@' || l_destination_database ||
715: ' @usrwkflw.sql');
716: utl_file.put_line(l_filehandle, '# ');

Line 714: utl_file.put_line(l_filehandle, 'sqlplus apps/apps@' || l_destination_database ||

710: utl_file.put_line(l_filehandle, '# Taskflow upload commands');
711: utl_file.put_line(l_filehandle, '# ');
712: utl_file.put_line(l_filehandle, 'sqlplus apps/apps@' || l_destination_database ||
713: ' @hrwkflow.sql');
714: utl_file.put_line(l_filehandle, 'sqlplus apps/apps@' || l_destination_database ||
715: ' @usrwkflw.sql');
716: utl_file.put_line(l_filehandle, '# ');
717: utl_file.put_line(l_filehandle, '# End of Taskflow upload commands');
718: utl_file.put_line(l_filehandle, '# ');

Line 716: utl_file.put_line(l_filehandle, '# ');

712: utl_file.put_line(l_filehandle, 'sqlplus apps/apps@' || l_destination_database ||
713: ' @hrwkflow.sql');
714: utl_file.put_line(l_filehandle, 'sqlplus apps/apps@' || l_destination_database ||
715: ' @usrwkflw.sql');
716: utl_file.put_line(l_filehandle, '# ');
717: utl_file.put_line(l_filehandle, '# End of Taskflow upload commands');
718: utl_file.put_line(l_filehandle, '# ');
719:
720: -- close file

Line 717: utl_file.put_line(l_filehandle, '# End of Taskflow upload commands');

713: ' @hrwkflow.sql');
714: utl_file.put_line(l_filehandle, 'sqlplus apps/apps@' || l_destination_database ||
715: ' @usrwkflw.sql');
716: utl_file.put_line(l_filehandle, '# ');
717: utl_file.put_line(l_filehandle, '# End of Taskflow upload commands');
718: utl_file.put_line(l_filehandle, '# ');
719:
720: -- close file
721: utl_file.fclose(l_filehandle);

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

714: utl_file.put_line(l_filehandle, 'sqlplus apps/apps@' || l_destination_database ||
715: ' @usrwkflw.sql');
716: utl_file.put_line(l_filehandle, '# ');
717: utl_file.put_line(l_filehandle, '# End of Taskflow upload commands');
718: utl_file.put_line(l_filehandle, '# ');
719:
720: -- close file
721: utl_file.fclose(l_filehandle);
722:

Line 721: utl_file.fclose(l_filehandle);

717: utl_file.put_line(l_filehandle, '# End of Taskflow upload commands');
718: utl_file.put_line(l_filehandle, '# ');
719:
720: -- close file
721: utl_file.fclose(l_filehandle);
722:
723:
724:
725: