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 1088: (p_file_id in utl_file.file_type

1084: -- Description: Output mag file
1085: --
1086: ---------------------------------------------------------------------------
1087: procedure evs_put_record
1088: (p_file_id in utl_file.file_type
1089: ,p_ssn in varchar2
1090: ,p_last_name in varchar2
1091: ,p_first_name in varchar2
1092: ,p_middle_name in varchar2

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

1151: (which => fnd_file.output
1152: ,buff => l_buff
1153: );
1154:
1155: utl_file.put(g_file_id,l_buff);
1156: utl_file.fflush(g_file_id); -- XXXXX
1157:
1158: hr_utility.set_location('Leavning : ' || l_proc,100);
1159: end evs_put_record;

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

1152: ,buff => l_buff
1153: );
1154:
1155: utl_file.put(g_file_id,l_buff);
1156: utl_file.fflush(g_file_id); -- XXXXX
1157:
1158: hr_utility.set_location('Leavning : ' || l_proc,100);
1159: end evs_put_record;
1160: ------------------------------------------------------------------------------

Line 1204: WHERE name='utl_file_dir';

1200: --
1201: CURSOR csr_valid_profile IS
1202: SELECT value
1203: FROM v$parameter
1204: WHERE name='utl_file_dir';
1205:
1206: --
1207: -- Retrieve GREs if gre parameter is blank
1208: --

Line 1257: -- GET UTL_FILE_DIR

1253: l_gre_count := 0;
1254:
1255: hr_utility.set_location('Entering:' || l_proc,10);
1256: --
1257: -- GET UTL_FILE_DIR
1258: --
1259: OPEN csr_valid_profile;
1260: FETCH csr_valid_profile INTO l_valid_profile;
1261: if csr_valid_profile%FOUND then

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

1261: if csr_valid_profile%FOUND then
1262: close csr_valid_profile;
1263: hr_utility.trace('l_valid_profile : ' || l_valid_profile);
1264: l_path := GET_ROOT_DIR(l_valid_profile);
1265: hr_utility.trace('UTL_FILE_DIR : ' || l_path );
1266: else
1267: null;
1268: close csr_valid_profile;
1269: end if;

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

1325:
1326: --
1327: -- File Open
1328: --
1329: g_file_id := utl_file.fopen(l_path,g_file_name,'w');
1330:
1331: evs_mag_report
1332: (p_path => l_path
1333: ,p_report_category => p_report_category

Line 1346: utl_file.fclose(g_file_id);

1342: ,p_gre_count => l_gre_count
1343: );
1344:
1345: hr_utility.set_location(l_proc,50);
1346: utl_file.fclose(g_file_id);
1347: if l_header = 0 then
1348: fnd_file.put_line
1349: (which => fnd_file.log
1350: ,buff => ' '

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

1383:
1384: --
1385: -- File Open
1386: --
1387: g_file_id := utl_file.fopen(l_path,g_file_name,'w');
1388:
1389: FOR gre_record IN csr_get_gre LOOP
1390: if gre_record.requester_id_code is NULL then
1391: fnd_message.set_name('PER','HR_449246_EVS_NO_REQ_ID');

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

1449: fnd_file.put_line
1450: (which => fnd_file.log
1451: ,buff => ' '
1452: );
1453: -- utl_file.fclose(g_file_id); -- 08-JUL-2005
1454: hr_utility.set_location(l_proc,74);
1455: end if;
1456: hr_utility.set_location('Leaving..: ' || l_proc,100);
1457: