APPS.JAI_AP_UTILS_PKG dependencies on UTL_FILE

Line 4256: l_file_old UTL_FILE.file_type;

4252: pv_file_new_name varchar2
4253: )
4254: is
4255:
4256: l_file_old UTL_FILE.file_type;
4257: l_file_new UTL_FILE.file_type;
4258:
4259: l_line_old VARCHAR2 (32767);
4260: l_line_new VARCHAR2 (32767);

Line 4257: l_file_new UTL_FILE.file_type;

4253: )
4254: is
4255:
4256: l_file_old UTL_FILE.file_type;
4257: l_file_new UTL_FILE.file_type;
4258:
4259: l_line_old VARCHAR2 (32767);
4260: l_line_new VARCHAR2 (32767);
4261:

Line 4288: l_file_old := UTL_FILE.fopen (l_old_file_dir, l_old_file_name, 'R');

4284:
4285: l_old_file_name := pv_file_old_name;--'old';--Old Section file name
4286: l_new_file_name := pv_file_new_name;--'new';--New Section file name
4287:
4288: l_file_old := UTL_FILE.fopen (l_old_file_dir, l_old_file_name, 'R');
4289: l_file_new := UTL_FILE.fopen (l_new_file_dir, l_new_file_name, 'R');
4290:
4291:
4292: ln_flag := 1;

Line 4289: l_file_new := UTL_FILE.fopen (l_new_file_dir, l_new_file_name, 'R');

4285: l_old_file_name := pv_file_old_name;--'old';--Old Section file name
4286: l_new_file_name := pv_file_new_name;--'new';--New Section file name
4287:
4288: l_file_old := UTL_FILE.fopen (l_old_file_dir, l_old_file_name, 'R');
4289: l_file_new := UTL_FILE.fopen (l_new_file_dir, l_new_file_name, 'R');
4290:
4291:
4292: ln_flag := 1;
4293: ln_sum := 0;

Line 4299: UTL_FILE.get_line (l_file_old, l_line_old);

4295: delete from jai_tds_section_mapping;
4296:
4297: LOOP
4298:
4299: UTL_FILE.get_line (l_file_old, l_line_old);
4300: UTL_FILE.get_line (l_file_new, l_line_new);
4301:
4302: ln_flag_old := 0;
4303: ln_flag_new := 0;

Line 4300: UTL_FILE.get_line (l_file_new, l_line_new);

4296:
4297: LOOP
4298:
4299: UTL_FILE.get_line (l_file_old, l_line_old);
4300: UTL_FILE.get_line (l_file_new, l_line_new);
4301:
4302: ln_flag_old := 0;
4303: ln_flag_new := 0;
4304:

Line 4353: UTL_FILE.fclose (l_file_old);

4349:
4350: EXCEPTION
4351: WHEN NO_DATA_FOUND
4352: THEN
4353: UTL_FILE.fclose (l_file_old);
4354: UTL_FILE.fclose (l_file_new);
4355:
4356: if(ln_flag = 0)then
4357: Fnd_File.put_line(Fnd_File.LOG,'0 rows inserted , Please check files to ensure the Section Code is avaiable in System.');

Line 4354: UTL_FILE.fclose (l_file_new);

4350: EXCEPTION
4351: WHEN NO_DATA_FOUND
4352: THEN
4353: UTL_FILE.fclose (l_file_old);
4354: UTL_FILE.fclose (l_file_new);
4355:
4356: if(ln_flag = 0)then
4357: Fnd_File.put_line(Fnd_File.LOG,'0 rows inserted , Please check files to ensure the Section Code is avaiable in System.');
4358: rollback;