APPS.AP_WEB_UPLOAD_ACCUM_MILES_PKG dependencies on UTL_FILE

Line 20: P_FileHandle OUT NOCOPY utl_file.file_type,

16: --
17: --
18: -- ---------------------------------------------------------
19: PROCEDURE OpenDataFile(P_DataFile IN VARCHAR2,
20: P_FileHandle OUT NOCOPY utl_file.file_type,
21: P_ErrorBuffer OUT NOCOPY VARCHAR2,
22: P_ReturnCode OUT NOCOPY NUMBER) IS
23: l_DatafilePath VARCHAR2(240);
24: l_Datafile VARCHAR2(240);

Line 25: l_DatafilePtr utl_file.file_type;

21: P_ErrorBuffer OUT NOCOPY VARCHAR2,
22: P_ReturnCode OUT NOCOPY NUMBER) IS
23: l_DatafilePath VARCHAR2(240);
24: l_Datafile VARCHAR2(240);
25: l_DatafilePtr utl_file.file_type;
26: l_Ntdir NUMBER;
27: l_Unixdir NUMBER;
28: BEGIN
29:

Line 62: P_FileHandle := utl_file.fopen(l_DatafilePath, l_Datafile, 'r');

58: END IF;
59:
60: --
61: -- Open the datafile for read
62: P_FileHandle := utl_file.fopen(l_DatafilePath, l_Datafile, 'r');
63: P_ReturnCode := 0;
64:
65: EXCEPTION
66: WHEN OTHERS THEN

Line 67: utl_file.fclose(l_datafileptr);

63: P_ReturnCode := 0;
64:
65: EXCEPTION
66: WHEN OTHERS THEN
67: utl_file.fclose(l_datafileptr);
68: fnd_message.set_name('AK', 'AK_INVALID_FILE_OPERATION');
69: fnd_message.set_token('PATH', l_datafilepath);
70: fnd_message.set_token('FILE', l_datafile);
71: P_ErrorBuffer := fnd_message.get();

Line 81: PROCEDURE CloseDataFile(P_FileHandle IN utl_file.file_type) IS

77: -- Procedure CloseDataFile
78: -- Descrition Closes a data file for a given handle
79: --
80: -- ---------------------------------------------------------
81: PROCEDURE CloseDataFile(P_FileHandle IN utl_file.file_type) IS
82: l_FileHandle utl_file.FILE_TYPE;
83: BEGIN
84:
85: IF ( g_DebugSwitch = 'Y' ) THEN

Line 82: l_FileHandle utl_file.FILE_TYPE;

78: -- Descrition Closes a data file for a given handle
79: --
80: -- ---------------------------------------------------------
81: PROCEDURE CloseDataFile(P_FileHandle IN utl_file.file_type) IS
82: l_FileHandle utl_file.FILE_TYPE;
83: BEGIN
84:
85: IF ( g_DebugSwitch = 'Y' ) THEN
86: -- ----------- Begin Loggin ------------------

Line 92: utl_file.fclose(l_FileHandle);

88: -- ----------- End Logging -------------------
89: END IF;
90:
91: l_FileHandle := P_FileHandle;
92: utl_file.fclose(l_FileHandle);
93:
94: END CloseDataFile;
95:
96:

Line 158: l_FileHandle utl_file.FILE_TYPE;

154: l_Result BOOLEAN;
155: l_Status VARCHAR2(240);
156: l_Message VARCHAR2(240);
157: l_Errors NUMBER;
158: l_FileHandle utl_file.FILE_TYPE;
159: l_NumLines NUMBER;
160: l_RowIndex NUMBER;
161: l_NumRejected NUMBER;
162: l_Line VARCHAR2(240);

Line 233: utl_file.get_line(l_FileHandle, l_Line);

229: l_RowIndex := 0;
230:
231: LOOP
232: BEGIN
233: utl_file.get_line(l_FileHandle, l_Line);
234: l_NumLines := l_NumLines + 1;
235: l_Length := length(l_Line);
236:
237: l_DelimPos := instr(l_Line, ';', 1, 1);