APPS.EAM_WORKORDER_UTIL_PKG dependencies on UTL_FILE

Line 1430: fileHandler UTL_FILE.FILE_TYPE;

1426: l_full_path VARCHAR2(512);
1427: l_new_full_path VARCHAR2(512);
1428: l_file_dir VARCHAR2(512);
1429:
1430: fileHandler UTL_FILE.FILE_TYPE;
1431: fileName VARCHAR2(50);
1432:
1433: l_flag NUMBER;
1434: l_index NUMBER;

Line 1442: WHERE name = 'utl_file_dir';

1438: /* get output directory path from database */
1439: SELECT value
1440: INTO l_full_path
1441: FROM v$parameter
1442: WHERE name = 'utl_file_dir';
1443:
1444: l_flag := 0;
1445: --l_full_path contains a list of comma-separated directories
1446: WHILE(TRUE)

Line 1457: fileHandler := UTL_FILE.FOPEN(l_file_dir , filename, 'w');

1453: l_file_dir := trim( substr( l_full_path, 1, l_index ) );
1454:
1455: -- check if the dir is valid
1456: BEGIN
1457: fileHandler := UTL_FILE.FOPEN(l_file_dir , filename, 'w');
1458: l_flag := 1;
1459: EXCEPTION
1460: WHEN utl_file.invalid_path THEN
1461: l_flag := 0;

Line 1460: WHEN utl_file.invalid_path THEN

1456: BEGIN
1457: fileHandler := UTL_FILE.FOPEN(l_file_dir , filename, 'w');
1458: l_flag := 1;
1459: EXCEPTION
1460: WHEN utl_file.invalid_path THEN
1461: l_flag := 0;
1462: WHEN utl_file.invalid_operation THEN
1463: l_flag := 0;
1464: END;

Line 1462: WHEN utl_file.invalid_operation THEN

1458: l_flag := 1;
1459: EXCEPTION
1460: WHEN utl_file.invalid_path THEN
1461: l_flag := 0;
1462: WHEN utl_file.invalid_operation THEN
1463: l_flag := 0;
1464: END;
1465:
1466: IF l_flag = 1 THEN --got a valid directory

Line 1467: utl_file.fclose(fileHandler);

1463: l_flag := 0;
1464: END;
1465:
1466: IF l_flag = 1 THEN --got a valid directory
1467: utl_file.fclose(fileHandler);
1468: EXIT;
1469: END IF;
1470:
1471: --earlier found dir was not a valid dir,