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

Line 8: g_file_id UTL_FILE.FILE_TYPE;

4: ----
5: -- Package Variables
6: --
7: g_package VARCHAR2(33) := 'per_evs_mag_report.';
8: g_file_id UTL_FILE.FILE_TYPE;
9: g_file_name VARCHAR2(40);
10:
11: --
12: --

Line 634: -- The following is old version code using UTL_FILE

630:
631:
632:
633: ---------------------------------------------------------------------------
634: -- The following is old version code using UTL_FILE
635: ---------------------------------------------------------------------------
636:
637:
638:

Line 643: -- p_path - utl_file_dir directores

639: -- ------------------------- GET_ROOT_DIR ---------------------------------
640: -- Description: Opens the specified file in the named location
641: --
642: -- Input Parameters
643: -- p_path - utl_file_dir directores
644: --
645: --
646: -- Output Parameters
647: -- l_directory - output directory

Line 962: utl_file.fclose(g_file_id);

958: hr_utility.trace('l_count = ' || l_count);
959: hr_utility.trace('l_gre_count = ' || l_gre_count);
960: if p_media_type = 'DISKETTE' then
961: if l_count >= 11000 then
962: utl_file.fclose(g_file_id);
963: l_file_count := l_file_count + 1 ;
964: hr_utility.set_location(l_proc,25);
965: g_file_id := utl_file.fopen(p_path, g_file_name || l_file_count, 'w');
966: l_count := 0;

Line 965: g_file_id := utl_file.fopen(p_path, g_file_name || l_file_count, 'w');

961: if l_count >= 11000 then
962: utl_file.fclose(g_file_id);
963: l_file_count := l_file_count + 1 ;
964: hr_utility.set_location(l_proc,25);
965: g_file_id := utl_file.fopen(p_path, g_file_name || l_file_count, 'w');
966: l_count := 0;
967: end if;
968: end if;
969: END LOOP;

Line 992: utl_file.fclose(g_file_id);

988: hr_utility.trace('l_gre_count = ' || l_gre_count);
989: if p_media_type = 'DISKETTE' then
990: if l_count >= 11000 then
991: hr_utility.set_location(l_proc,35);
992: utl_file.fclose(g_file_id);
993: l_file_count := l_file_count + 1 ;
994: g_file_id := utl_file.fopen(p_path, g_file_name || l_file_count, 'w');
995: l_count := 0;
996: end if;

Line 994: g_file_id := utl_file.fopen(p_path, g_file_name || l_file_count, 'w');

990: if l_count >= 11000 then
991: hr_utility.set_location(l_proc,35);
992: utl_file.fclose(g_file_id);
993: l_file_count := l_file_count + 1 ;
994: g_file_id := utl_file.fopen(p_path, g_file_name || l_file_count, 'w');
995: l_count := 0;
996: end if;
997: end if;
998: END LOOP;

Line 1021: utl_file.fclose(g_file_id);

1017: hr_utility.trace('l_gre_count = ' || l_gre_count);
1018: if p_media_type = 'DISKETTE' then
1019: if l_count >= 11000 then
1020: hr_utility.set_location(l_proc,45);
1021: utl_file.fclose(g_file_id);
1022: l_file_count := l_file_count + 1 ;
1023: g_file_id := utl_file.fopen(p_path, g_file_name || l_file_count, 'w');
1024: l_count := 0;
1025: end if;

Line 1023: g_file_id := utl_file.fopen(p_path, g_file_name || l_file_count, 'w');

1019: if l_count >= 11000 then
1020: hr_utility.set_location(l_proc,45);
1021: utl_file.fclose(g_file_id);
1022: l_file_count := l_file_count + 1 ;
1023: g_file_id := utl_file.fopen(p_path, g_file_name || l_file_count, 'w');
1024: l_count := 0;
1025: end if;
1026: end if;
1027: END LOOP;

Line 1050: utl_file.fclose(g_file_id);

1046: hr_utility.trace('l_gre_count = ' || l_gre_count);
1047: if p_media_type = 'DISKETTE' then
1048: if l_count >= 11000 then
1049: hr_utility.set_location(l_proc,55);
1050: utl_file.fclose(g_file_id);
1051: l_file_count := l_file_count + 1 ;
1052: g_file_id := utl_file.fopen(p_path, g_file_name || l_file_count, 'w');
1053: l_count := 0;
1054: end if;

Line 1052: g_file_id := utl_file.fopen(p_path, g_file_name || l_file_count, 'w');

1048: if l_count >= 11000 then
1049: hr_utility.set_location(l_proc,55);
1050: utl_file.fclose(g_file_id);
1051: l_file_count := l_file_count + 1 ;
1052: g_file_id := utl_file.fopen(p_path, g_file_name || l_file_count, 'w');
1053: l_count := 0;
1054: end if;
1055: end if;
1056: END LOOP;

Line 1068: (p_file_id in utl_file.file_type

1064: -- Description: Output mag file
1065: --
1066: ---------------------------------------------------------------------------
1067: procedure evs_put_record
1068: (p_file_id in utl_file.file_type
1069: ,p_ssn in varchar2
1070: ,p_last_name in varchar2
1071: ,p_first_name in varchar2
1072: ,p_middle_name in varchar2

Line 1135: utl_file.put(g_file_id,l_buff);

1131: (which => fnd_file.output
1132: ,buff => l_buff
1133: );
1134:
1135: utl_file.put(g_file_id,l_buff);
1136: utl_file.fflush(g_file_id); -- XXXXX
1137:
1138: hr_utility.set_location('Leavning : ' || l_proc,100);
1139: end evs_put_record;

Line 1136: utl_file.fflush(g_file_id); -- XXXXX

1132: ,buff => l_buff
1133: );
1134:
1135: utl_file.put(g_file_id,l_buff);
1136: utl_file.fflush(g_file_id); -- XXXXX
1137:
1138: hr_utility.set_location('Leavning : ' || l_proc,100);
1139: end evs_put_record;
1140: ------------------------------------------------------------------------------

Line 1184: WHERE name='utl_file_dir';

1180: --
1181: CURSOR csr_valid_profile IS
1182: SELECT value
1183: FROM v$parameter
1184: WHERE name='utl_file_dir';
1185:
1186: --
1187: -- Retrieve GREs if gre parameter is blank
1188: --

Line 1237: -- GET UTL_FILE_DIR

1233: l_gre_count := 0;
1234:
1235: hr_utility.set_location('Entering:' || l_proc,10);
1236: --
1237: -- GET UTL_FILE_DIR
1238: --
1239: OPEN csr_valid_profile;
1240: FETCH csr_valid_profile INTO l_valid_profile;
1241: if csr_valid_profile%FOUND then

Line 1245: hr_utility.trace('UTL_FILE_DIR : ' || l_path );

1241: if csr_valid_profile%FOUND then
1242: close csr_valid_profile;
1243: hr_utility.trace('l_valid_profile : ' || l_valid_profile);
1244: l_path := GET_ROOT_DIR(l_valid_profile);
1245: hr_utility.trace('UTL_FILE_DIR : ' || l_path );
1246: else
1247: null;
1248: close csr_valid_profile;
1249: end if;

Line 1309: g_file_id := utl_file.fopen(l_path,g_file_name,'w');

1305:
1306: --
1307: -- File Open
1308: --
1309: g_file_id := utl_file.fopen(l_path,g_file_name,'w');
1310:
1311: evs_mag_report
1312: (p_path => l_path
1313: ,p_report_category => p_report_category

Line 1326: utl_file.fclose(g_file_id);

1322: ,p_gre_count => l_gre_count
1323: );
1324:
1325: hr_utility.set_location(l_proc,50);
1326: utl_file.fclose(g_file_id);
1327: if l_header = 0 then
1328: fnd_file.put_line
1329: (which => fnd_file.log
1330: ,buff => ' '

Line 1367: g_file_id := utl_file.fopen(l_path,g_file_name,'w');

1363:
1364: --
1365: -- File Open
1366: --
1367: g_file_id := utl_file.fopen(l_path,g_file_name,'w');
1368:
1369: FOR gre_record IN csr_get_gre LOOP
1370: if gre_record.requester_id_code is NULL then
1371: fnd_message.set_name('PER','HR_449246_EVS_NO_REQ_ID');

Line 1433: -- utl_file.fclose(g_file_id); -- 08-JUL-2005

1429: fnd_file.put_line
1430: (which => fnd_file.log
1431: ,buff => ' '
1432: );
1433: -- utl_file.fclose(g_file_id); -- 08-JUL-2005
1434: hr_utility.set_location(l_proc,74);
1435: end if;
1436: hr_utility.set_location('Leaving..: ' || l_proc,100);
1437: