APPS.ECE_UTILITIES dependencies on UTL_FILE

Line 722: u_file_handle utl_file.file_type;

718: l_data_value VARCHAR2(32000) := NULL;
719: l_insert_stmt VARCHAR2(2000);
720: c_current_line VARCHAR2(5000);
721:
722: u_file_handle utl_file.file_type;
723: x_num NUMBER;
724: l_initial_position NUMBER := 100;
725: l_start_position NUMBER;
726: l_end_position NUMBER;

Line 782: u_file_handle := utl_file.fopen(p_File_path, p_Filename, 'r',5000);

778: -- ***********************************************************************
779:
780: BEGIN
781: xProgress := 'RDATA-10-1000';
782: u_file_handle := utl_file.fopen(p_File_path, p_Filename, 'r',5000);
783:
784: LOOP
785: xProgress := 'RDATA-10-1010';
786: x_num := x_num + 1;

Line 797: utl_file.get_line(u_file_handle, c_current_line);

793: EXIT;
794: end if;
795:
796: xProgress := 'RDATA-10-1040';
797: utl_file.get_line(u_file_handle, c_current_line);
798:
799: xProgress := 'RDATA-10-1050';
800: l_rec_number := TO_NUMBER(SUBSTRB(c_current_line,
801: ece_flatfile_pvt.g_record_num_start,

Line 869: -- finish utl_file.get_line

865: l_prv_record_num := interface_data_rec.Record_number;
866: END LOOP;
867: END LOOP;
868:
869: -- finish utl_file.get_line
870: EXCEPTION
871: -- this exception handler is to handle end of file
872: WHEN NO_DATA_FOUND THEN
873: NULL;