APPS.PER_UPLOAD_USER_TABLE dependencies on UTL_FILE

Line 309: l_file_handler UTL_FILE.FILE_TYPE;

305: --and
306: -- set update mode as correction -if its correction, no changes to l_eff_date
307: -- if update mode is updation -- fetch effevtive date nad pass as l_eff_date
308: is
309: l_file_handler UTL_FILE.FILE_TYPE;
310: l_line VARCHAR2(300);
311: l_delim_postn number:=0;
312: l_start_postn number := 0;
313: l_delim_count number := 1;

Line 342: l_file_handler := UTL_FILE.FOPEN(p_directory,p_filename,'R');

338: end if;
339: hr_utility.trace(p_effective_date);
340:
341: begin
342: l_file_handler := UTL_FILE.FOPEN(p_directory,p_filename,'R');
343: exception when others then
344: hr_utility.trace('Unable to open file, check the directory or file provided');
345: RAISE;
346: end;

Line 349: UTL_FILE.GET_LINE(l_file_handler,l_line);

345: RAISE;
346: end;
347:
348: LOOP
349: UTL_FILE.GET_LINE(l_file_handler,l_line);
350:
351: l_delim_count := 1;
352: l_start_postn := 0;
353: loop

Line 453: --UTL_FILE.FCLOSE(file_handler);

449:
450: commit;
451:
452: END LOOP;
453: --UTL_FILE.FCLOSE(file_handler);
454: EXCEPTION
455: WHEN NO_DATA_FOUND THEN
456: UTL_FILE.FCLOSE(l_file_handler);
457: hr_utility.trace('Closing file');

Line 456: UTL_FILE.FCLOSE(l_file_handler);

452: END LOOP;
453: --UTL_FILE.FCLOSE(file_handler);
454: EXCEPTION
455: WHEN NO_DATA_FOUND THEN
456: UTL_FILE.FCLOSE(l_file_handler);
457: hr_utility.trace('Closing file');
458: -- hr_utility.trace_off();
459:
460: END enter_user_table_values;

Line 579: l_file_handler UTL_FILE.FILE_TYPE;

575: p_effective_date IN VARCHAR2,
576: p_business_group_id IN NUMBER
577: )
578: IS
579: l_file_handler UTL_FILE.FILE_TYPE;
580: l_line VARCHAR2(500);
581: l_delim_postn NUMBER := 0;
582: l_start_postn NUMBER := 0;
583: l_delim_count NUMBER := 1;

Line 617: l_file_handler := UTL_FILE.FOPEN(p_directory,p_filename,'R');

613:
614: hr_utility.trace(l_security_group_id);
615:
616: BEGIN
617: l_file_handler := UTL_FILE.FOPEN(p_directory,p_filename,'R');
618: exception when others then
619: hr_utility.trace('Unable to open file, check the directory or file provided');
620: RAISE;
621: END;

Line 624: UTL_FILE.GET_LINE(l_file_handler,l_line);

620: RAISE;
621: END;
622:
623: LOOP
624: UTL_FILE.GET_LINE(l_file_handler,l_line);
625:
626: l_delim_count := 1;
627: l_start_postn := 1;
628:

Line 693: UTL_FILE.FCLOSE(l_file_handler);

689: end if;
690: END LOOP;
691: EXCEPTION
692: WHEN NO_DATA_FOUND THEN
693: UTL_FILE.FCLOSE(l_file_handler);
694: hr_utility.trace('Closing file');
695: -- hr_utility.trace_off();
696: END enter_lookup_values;
697: